[Pgpool-general] pgpool error when conecting from pgadmin

Itamar - IspBrasil itamar at ispbrasil.com.br
Fri Sep 5 19:01:38 UTC 2008 

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

More information about the Pgpool-general mailing list