[pgpool-general: 2043] Re: SELECT sent to both nodes in replication mode
Tatsuo Ishii
ishii at postgresql.org
Sat Aug 17 10:40:17 JST 2013
Done. Fix will appear in 3.3.1.
Patch is here:
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=1ac45a28258074ea4d9d902aca016f970d31f311
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> 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
> _______________________________________________
> 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