[pgpool-general: 1171] Re: Mismatch - how to avoid

[Tatsuo Ishii]

Have you enabled replicate_select? 
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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