[pgpool-general: 2042] Re: SELECT sent to both nodes in replication mode

Tatsuo Ishii ishii at postgresql.org
Fri Aug 16 08:17:32 JST 2013


Looks a bug to me. Will fix.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

>  Hello,
> 
>  I would like to use pgpool 3.3.0 and postges 9.1 in replication mode
>  with queries send to master db, without parallel queries or load
>  balancing. Unfortunately the following settings still send queries to
>  both nodes:
> 
> replication_mode = on
> replicate_select = off
> load_balance_mode = off
> master_slave_mode = off
> parallel_mode = off
> 
> This is the log:
> connection received: host=localhost port=53802
> DB node id: 0 backend pid: 11864 statement: BEGIN
> DB node id: 1 backend pid: 12508 statement: BEGIN
> DB node id: 0 backend pid: 11864 statement: SELECT 1;
> DB node id: 1 backend pid: 12508 statement: SELECT 1;
> DB node id: 1 backend pid: 12508 statement: COMMIT
> DB node id: 0 backend pid: 11864 statement: COMMIT
> DB node id: 0 backend pid: 11864 statement:  DISCARD ALL
> DB node id: 1 backend pid: 12508 statement:  DISCARD ALL
> 
> 
> As a workaround, the following seems to work as expected:
> 
> load_balance_mode = on
> backend_weight0 = 1
> backend_weight1 = 0
> 
> connection received: host=localhost port=53930
> DB node id: 0 backend pid: 12191 statement: SELECT 1;
> DB node id: 0 backend pid: 12191 statement:  DISCARD ALL
> DB node id: 1 backend pid: 12752 statement:  DISCARD ALL
> 
> It seems to be strange because based on table provided in description
> of replicate_select on
> http://www.pgpool.net/docs/latest/pgpool-en.html#replication_mode I
> would expect that the first setting will send queries only to the
> master node.
> 
> Can somebody help me to find out if there is some fault in my setup or
> in pgpool?
> 
>  Thanks and Regards,
>  Lukas Rypl
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list