[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