[Pgpool-general] "read_message_length: length does not match between backends" again

[Tatsuo Ishii]

> Hi
> 
> Thanks for your reply. Here is the debug mode output:
> 
> 2005-05-14 12:12:10 DEBUG: pid 14014: I am 14014
> 2005-05-14 12:12:45 DEBUG: pid 14014: I am 14014 accept fd 6
> 2005-05-14 12:12:45 DEBUG: pid 14014: Protocol Major: 3 Minor: 0 database:
> below user: below
> 2005-05-14 12:12:45 DEBUG: pid 14014: connecting postmaster Unix domain
> socket: /tmp/.s.PGSQL.5432
> 2005-05-14 12:12:45 DEBUG: pid 14014: connected to postmaster Unix domain
> socket: /tmp/.s.PGSQL.5432 fd: 7
> 2005-05-14 12:12:46 DEBUG: pid 14014: read_message_length: lenghth: 8
> 2005-05-14 12:12:46 DEBUG: pid 14014: trying clear text password
> authentication
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 28
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: client_encoding value: UNICODE
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 23
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: DateStyle value: ISO, MDY
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 26
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: integer_datetimes value: off
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 20
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: is_superuser value: on
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 28
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: server_encoding value: UNICODE
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 25
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: server_version value: 8.0.0
> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 34
> 2005-05-14 12:12:47 DEBUG: pid 14014: name: session_authorization value:
> below

It seems you are connecting as "below"? Is it correct?

> 2005-05-14 12:12:47 DEBUG: pid 14014: read_message_length: lenghth: 16
> 2005-05-14 12:12:47 ERROR: pid 14014: read_message_length: length does not
> match between backends master(16) secondary(28) 

It seems time zone values on each PostgreSQL server do not agree.
Connect directly to each PostgreSQL server without pgpool and type:

show TimeZone;
--
Tatsuo Ishii