[Pgpool-general] pgpool error when conecting from pgadmin

Sat Sep 6 17:48:00 UTC 2008

thats true, this problem only happens when I try to connect using 
"pgAdmin III 1.8",

  It'a  a problem with "pgAdmin III 1.8", with psql works fine.

Can you report a bug for me ?

Tatsuo Ishii wrote:
> 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
>>      
>
>
>    