[Pgpool-general] pgpool client connection server closed the connection unexpectedly

[ricardo hdz]

Hi

My software versions


postgresql-pgpool-II-2.3.3-1foo2010.0
postgresql8.4-server-8.4.4-2foo2010.0
postgresql8.4-8.4.4-2foo2010.0
libpq8.4_5-8.4.4-2foo2010.0

My box is tunning mandriva  

cat /etc/lsb-release
LSB_VERSION=lsb-4.0-ia32:lsb-4.0-noarch
DISTRIB_ID=MandrivaLinux
DISTRIB_RELEASE=2010.0
DISTRIB_CODENAME=adelie
DISTRIB_DESCRIPTION="Mandriva Linux 2010.0"


After reboot my test server and running up the pgpool service i can access to 
the pgpool server with the next command.

psql  -h pgcluster -p 9999 -U pgpool2 -d postgres

And all it's fine.


When i restarted the pgpool service with /etc/init.d/pgpool restart

and try again to connect to the pgpool service i saw this message.


$psql  -h pgcluster -p 9999 -U pgpool2 -d postgres
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.


And in the log pgpool debug i saw


2010-07-14 13:26:18 DEBUG: pid 2812: value: false kind: 1
2010-07-14 13:26:18 DEBUG: pid 2812: num_backends: 2 num_backends: 2 
total_weight: 2.000000
2010-07-14 13:26:18 DEBUG: pid 2812: backend 0 weight: 1073741823.500000
2010-07-14 13:26:18 DEBUG: pid 2812: backend 1 weight: 1073741823.500000
2010-07-14 13:26:18 DEBUG: pid 2812: I am 2812 accept fd 5
2010-07-14 13:26:18 DEBUG: pid 2812: Protocol Major: 1234 Minor: 5679 database:  
user: 
2010-07-14 13:26:18 DEBUG: pid 2812: SSLRequest from client
2010-07-14 13:26:18 DEBUG: pid 2812: Protocol Major: 3 Minor: 0 database: 
postgres user: pgpool2
2010-07-14 13:26:18 DEBUG: pid 2812: new_connection: connecting 0 backend
2010-07-14 13:26:18 DEBUG: pid 2812: new_connection: skipping slot 0 because 
backend_status = 3
2010-07-14 13:26:18 DEBUG: pid 2812: new_connection: connecting 1 backend
2010-07-14 13:26:18 LOG:   pid 2812: pool_do_auth: maybe protocol version 
mismatch (current version 3)
2010-07-14 13:26:18 DEBUG: pid 2812: pool_read_string: read all from pending 
data. po:1 len:144


So what can i do to always connect to pgpool service ?


Thanks !!