[pgpool-general: 5960] Re: pgpool load balancing problem
Tatsuo Ishii
ishii at sraoss.co.jp
Thu Mar 1 13:23:33 JST 2018
> I found a problem that had a big impact on our servers. I'm using pgpool as
> a load balancer and pool connections manager. When a user tries to run a
> select query it redirects the query to the slave. If the user tries after
> that to run dml or ddl command he get error :
>
> ERROR: cannot execute CREATE TABLE in a read-only transaction
> SQL state: 25006
>
> Is there any way to solve this issue ? It means that once the pool
> redirected your session to the slaves you cant run any ddl/dml actions ..
Normaly Pgpool-II redirects any ddl/dml query to primary. Can you
show me following query results? I would like to confirm your problem.
show pool_version;
show pool_nodes;
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list