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

[Paul Lee]

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
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) 


Best Regards..
Paul Lee


-----Original Message-----
From: Tatsuo Ishii [mailto:t-ishii at sra.co.jp] 
Sent: Saturday, 14 May 2005 2:26 a.m.
To: paul at soa.net
Cc: pgpool-general at pgfoundry.org
Subject: Re: [Pgpool-general] "read_message_length: length does not match
between backends" again

Paul,

You need pgpool -d output to track down the problem.
--
Tatsuo Ishii

> Hi All
> 
>  
> 
> Have just run into a wall with pgpool again. I've cloned and checked 
> all I can but can't find a reason why pgpool shouldn't work because of 
> my limited knowledge of it. I've duplicated the postgres database 
> files and checked user permissions in Postgres and all is fine but am
still getting the error:
> 
>  
> 
> read_message_length: length does not match between backends master(16)
> secondary(28)
> 
>  
> 
>  
> 
> Thanks in advance, not doing too well with the whole replication thing.
> 
>  
> 
> Best Regards..
> Paul
> 
>  
>