Skip to content

dml_adaptive , in transaction, select query was routed to standby node after create table command #157

@liujinyang-highgo

Description

@liujinyang-highgo

hi,
pgpool 4.6.2.
I met a problem.
the case as below:

set disable_load_balance_on_write = 'dml_adaptive' in conf file.
begin;
create table t1(id1 int,id2 int);
select * from t1;
commit;

'select * from t1;' will be routed to standby node, it that correct? I checked function raw_expression_tree_walker() and found there is no handle for T_CreateStmt , so table will not be stored in transaction_temp_write_list.

From the literal meaning ,'dml_adaptive' maybe for DML statement, but the case above(DDL) how to handle it?

thanks

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions