[Pgpool-general] pgpool error when conecting from pgadmin

Tatsuo Ishii ishii at sraoss.co.jp
Sat Sep 6 03:52:40 UTC 2008 

It seems you are using pgpool in master/slave mode.

The query causing the trouble is a muti-statement one which is treated
as single one in pgpool:

SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS 
 encoding, datlastsysoid
 FROM pg_database WHERE oid = 16401

The query is using oids which are not guaranteed consistent between
master and slave DBs if you are using Slony-I.

workaround:

1) Issue the query separetely. i.e.

   SET DateStyle=ISO;
   SELECT oid, pg_encoding_to_char(encoding) AS 
    encoding, datlastsysoid
	 FROM pg_database WHERE oid = 16401;

2)  Do not use queries using oids
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> anyone can help me ?:
> 
> 
> I am trying a load balance with 2 postgresql machines.
> 
> postgresql version  8.33
> 
> 
> 
> 
>   [root at localhost ~]# 2008-09-05 14:57:32 DEBUG: pid 5483: read kind 
> from frontend Q(51)
> 2008-09-05 14:57:32 DEBUG: pid 5483: statement2: SELECT version();
> 2008-09-05 14:57:32 DEBUG: pid 5483: waiting for backend 0 completing 
> the query
> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind 
> from 0 th backend T NUM_BACKENDS: 1
> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from 
> backend: T
> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind 
> from 0 th backend D NUM_BACKENDS: 1
> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from 
> backend: D
> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind 
> from 0 th backend C NUM_BACKENDS: 1
> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from 
> backend: C
> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind 
> from 0 th backend Z NUM_BACKENDS: 1
> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from 
> backend: Z
> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_read_message_length: slot: 0 
> length: 5
> 2008-09-05 14:57:32 DEBUG: pid 5483: ReadyForQuery: message length: 5
> 2008-09-05 14:57:32 DEBUG: pid 5483: ReadyForQuery: transaction state: I
> 2008-09-05 14:57:32 DEBUG: pid 5483: end_load_balance: end load balance mode
> 2008-09-05 14:57:52 DEBUG: pid 5482: I am 5482 accept fd 0
> 2008-09-05 14:57:52 DEBUG: pid 5482: Protocol Major: 3 Minor: 0 
> database: db_master user: itamar
> 2008-09-05 14:57:52 DEBUG: pid 5482: new_connection: connecting 0 backend
> 2008-09-05 14:57:52 DEBUG: pid 5482: new_connection: connecting 1 backend
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 
> length: 8
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 
> length: 8
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: client_encoding 
> value: UTF8
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: client_encoding 
> value: UTF8
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 23
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 23
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: DateStyle 
> value: ISO, MDY
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: DateStyle 
> value: ISO, MDY
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 26
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 26
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: 
> integer_datetimes value: off
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: 
> integer_datetimes value: off
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 20
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 20
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: is_superuser 
> value: on
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: is_superuser 
> value: on
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: server_encoding 
> value: UTF8
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: server_encoding 
> value: UTF8
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 25
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: server_version 
> value: 8.3.3
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: server_version 
> value: 8.3.3
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 33
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 33
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: 
> session_authorization value: itamar
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: 
> session_authorization value: itamar
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 36
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 36
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: 
> standard_conforming_strings value: off
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: 
> standard_conforming_strings value: off
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 24
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 25
> 2008-09-05 14:57:52 ERROR: pid 5482: pool_read_message_length2: message 
> length (25) in slot 1 does not match with slot 0(24)
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: TimeZone value: 
> US/Eastern
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: TimeZone value: 
> Brazil/East
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 
> length: 12
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 
> length: 12
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_send_auth_ok: send pid 21303 
> to frontend
> 2008-09-05 14:57:52 DEBUG: pid 5482: select_load_balancing_node: 
> selected backend id is 0
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 0 th backend Z NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 1 th backend Z NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from 
> backend: Z
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 
> length: 5
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 
> length: 5
> 2008-09-05 14:57:52 DEBUG: pid 5482: ReadyForQuery: message length: 5
> 2008-09-05 14:57:52 DEBUG: pid 5482: ReadyForQuery: transaction state: I
> 2008-09-05 14:57:52 DEBUG: pid 5482: read kind from frontend Q(51)
> 2008-09-05 14:57:52 DEBUG: pid 5482: statement2: SET 
> DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, 
> datlastsysoid
>    FROM pg_database WHERE oid = 16401
> 2008-09-05 14:57:52 DEBUG: pid 5482: SimpleQuery: set master_slave_dml 
> query: SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS 
> encoding, datlastsysoid
>    FROM pg_database WHERE oid = 16401
> 2008-09-05 14:57:52 DEBUG: pid 5482: waiting for backend 0 completing 
> the query
> 2008-09-05 14:57:52 DEBUG: pid 5482: waiting for backend 1 completing 
> the query
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 0 th backend S NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 1 th backend S NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from 
> backend: S
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 0 length: 23
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master 
> slot: 1 length: 23
> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: DateStyle 
> value: ISO, MDY
> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: DateStyle 
> value: ISO, MDY
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 0 th backend C NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 1 th backend C NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from 
> backend: C
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 0 th backend T NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 1 th backend T NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from 
> backend: T
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 0 th backend D NUM_BACKENDS: 2
> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind 
> from 1 th backend C NUM_BACKENDS: 2
> *2008-09-05 14:57:52 ERROR: pid 5482: pool_process_query: 1 th kind C 
> does not match with master connection kind D
> 2008-09-05 14:57:52 LOG:   pid 5482: do_child: exits with status 1 due 
> to error*
> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler called
> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler: call wait3
> 2008-09-05 14:57:52 DEBUG: pid 5475: child 5482 exits with status 256 by 
> signal 0
> 2008-09-05 14:57:52 DEBUG: pid 5610: I am 5610
> 2008-09-05 14:57:52 DEBUG: pid 5475: fork a new child pid 5610
> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler: normally exited
> 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general

More information about the Pgpool-general mailing list