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

Jens Wilke jens.wilke at 1und1.de
Thu Nov 22 19:18:49 JST 2012


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