[pgpool-general: 1192] Re: read_kind_from_backend: 0 th kind C does not match with master or majority connection kind N

Tatsuo Ishii ishii at postgresql.org
Sat Nov 24 07:15:19 JST 2012


I don't see this problem here. How can I reproduce your problem?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi Tatsuo,
> 
> do you have any idea on this?
> Is it a good idea to downgrade to 3.1?
> We didn't get these Errors on 3.0 but there's no Debian Squeeeze Package
> for 3.0.
> 
> Rgds, Jens
> 
> -------- Original-Nachricht --------
> Betreff: [pgpool-general: 1191] read_kind_from_backend: 0 th kind C does
> not match with master or majority connection kind N
> Datum: Thu, 22 Nov 2012 11:18:49 +0100
> Von: Jens Wilke <jens.wilke at 1und1.de>
> An: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
> 
> Hello,
> 
> commits are distributed to all Backends and cause errors.
> How to get rid of them?
> 
> pgpool-II version 3.2.1
> 
> load_balance_mode = on
> master_slave_mode = on
> master_slave_sub_mode = 'stream'
> parallel_mode = off
> replication_mode = off
> connection_cache = on or off
> 
> Nov 22 10:51:45 dbspgp001pb pgpool: 2012-11-22 10:51:45 LOG:   pid
> 29884: statement: COMMIT
> Nov 22 10:51:45 dbspgp001pb pgpool: 2012-11-22 10:51:45 LOG:   pid
> 29884: pool_send_and_wait: Error or notice message from backend: : DB
> node id: 1 backend pid: 24115 statement: COMMIT message: WARNING:  there
> is no transaction in progress
> Nov 22 10:51:45 dbspgp001pb pgpool:
> Nov 22 10:51:45 dbspgp001pb pgpool: 2012-11-22 10:51:45 LOG:   pid
> 29884: pool_send_and_wait: Error or notice message from backend: : DB
> node id: 2 backend pid: 15303 statement: COMMIT message: WARNING:  there
> is no transaction in progress
> Nov 22 10:51:45 dbspgp001pb pgpool:
> Nov 22 10:51:45 dbspgp001pb pgpool: 2012-11-22 10:51:45 ERROR: pid
> 29884: read_kind_from_backend: 0 th kind C does not match with master or
> majority connection kind N
> Nov 22 10:51:45 dbspgp001pb pgpool: 2012-11-22 10:51:45 ERROR: pid
> 29884: kind mismatch among backends. Possible last query was: "COMMIT"
> kind details are: 0[C] 1[N: WARNING:  there is no transaction in progress
> 
> Regards, Jens


More information about the pgpool-general mailing list