[Pgpool-general] pool_do_auth: failed to read kind while processing ParamterStatus

[sergey kapustin]

Hello!
i'm running pgpool in replication mode on 2 machines:
1 - gentoo, postgresql 8.0.4 (master)
2 - debian, postgresql 8.1.8 (slave)

ssl mode is set to off both on master and slave.

below is my pgpool.conf and debug. Please help!
Thank you!

listen_addresses = '*'
port = 9999
socket_dir = '/tmp'
backend_host_name = '192.168.1.254'
backend_port = 5432
backend_socket_dir = '/var/run/postgresql'
secondary_backend_host_name = '192.168.1.99'
secondary_backend_port = 5432
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
replication_mode = true
replication_strict = true


2007-06-07 09:23:31 DEBUG: pid 18661: I am 18661 accept fd 6
2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 1234 Minor: 5679
database:  user:
2007-06-07 09:23:31 DEBUG: pid 18661: SSLRequest: sent N; retry startup
2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 3 Minor: 0 database:
msgs user: slony
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length: lenghth: 8
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
30
2007-06-07 09:23:31 DEBUG: pid 18661: name: client_encoding value: SQL_ASCII
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: client_encoding value:
SQL_ASCII
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
23
2007-06-07 09:23:31 DEBUG: pid 18661: name: DateStyle value: ISO, MDY
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: DateStyle value: ISO,
MDY
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
25
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does not
match between backends master(25) secondary(26)
2007-06-07 09:23:31 DEBUG: pid 18661: name: integer_datetimes value: on
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: integer_datetimes
value: off
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
20
2007-06-07 09:23:31 DEBUG: pid 18661: name: is_superuser value: on
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: is_superuser value: on
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
30
2007-06-07 09:23:31 DEBUG: pid 18661: name: server_encoding value: SQL_ASCII
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_encoding value:
SQL_ASCII
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
25
2007-06-07 09:23:31 DEBUG: pid 18661: name: server_version value: 8.1.8
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_version value:
8.0.4
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
32
2007-06-07 09:23:31 DEBUG: pid 18661: name: session_authorization value:
slony
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: session_authorization
value: slony
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master lenghth:
36
2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does not
match between backends master(36) secondary(17)
2007-06-07 09:23:31 DEBUG: pid 18661: name: standard_conforming_strings
value: off
2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: TimeZone value: GMT
2007-06-07 09:23:31 ERROR: pid 18661: read_kind: kind does not match between
backends master(83) secondary(75)
2007-06-07 09:23:31 ERROR: pid 18661: pool_do_auth: failed to read kind
while processing ParamterStatus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070607/08819674/attachment.html