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

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions