[pgpool-general: 1152] Mismatch - how to avoid

[Khapare Joshi]

HI there,

How to avoid this kind of mismatch to be happen in production environment?

Oct 31 09:46:56 pgpool pgpool[17294]: connection received:
host=host45.local port=45721
Oct 31 09:46:56 pgpool pgpool[17294]: statement: SELECT version();
Oct 31 09:46:56 pgpool pgpool[17294]: DB node id: 1 backend pid: 2542
statement: SELECT version();
Oct 31 09:46:56 pgpool pgpool[17294]: statement: SET DateStyle=ISO;#012SET
bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS
encoding, datlastsysoid#012  FROM pg_database WHERE oid = 106347
Oct 31 09:46:56 pgpool pgpool[17294]: DB node id: 0 backend pid: 6446
statement: BEGIN
Oct 31 09:46:56 pgpool pgpool[17294]: DB node id: 1 backend pid: 2542
statement: BEGIN
Oct 31 09:46:56 pgpool pgpool[17294]: DB node id: 0 backend pid: 6446
statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012  FROM
pg_database WHERE oid = 106347
Oct 31 09:46:56 pgpool pgpool[17294]: DB node id: 1 backend pid: 2542
statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid,
pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012  FROM
pg_database WHERE oid = 106347
Oct 31 09:46:56 pgpool pgpool[17294]: read_kind_from_backend: 1 th kind C
does not match with master or majority connection kind D
Oct 31 09:46:56 pgpool pgpool[17294]: kind mismatch among backends.
Possible last query was: "SET DateStyle=ISO;#012SET
bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS
encoding, datlastsysoid#012  FROM pg_database WHERE oid = 106347" kind
details are: 0[D] 1[C]
Oct 31 09:46:56 pgpool pgpool[17294]: do_child: exits with status 1 due to
error
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121031/3a93e07b/attachment.html>