[Pgpool-general] psql: server closed the connection unexpectedly

Ger Apeldoorn ger.apeldoorn at sara.nl
Mon Jan 18 08:07:45 UTC 2010


Hi,

I'm having a problem on one of the pgpool instances. When I try to connect through 
pgpool, it cannot connect. The other node's pgpool works fine, so both postgresql instances
are up and running.
The configuration is the same as used for the previous version, 2.2.5.

--------%<--------
postgres at db3$ psql -p9999 database_name
psql: could not send startup packet: Broken pipe <- seen this happen once

postgres at db3$ psql -p9999 database_name
psql: server closed the connection unexpectedly <- mostly I get this error
	This probably means the server terminated abnormally
	before or while processing the request.
--------%<--------

Going directly to the local database, it works:

--------%<--------
postgres at db3$ psql -p5433 database_name
Welcome to psql 8.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

database_name=# 
--------%<--------

The /var/log/pgpool.log is flooded with the following entries:
--------%<--------
2010-01-18 08:46:19 LOG:   pid 11692: Cannot accept() new connection. all backends are down
2010-01-18 08:46:20 LOG:   pid 12526: Cannot accept() new connection. all backends are down
--------%<--------

pcp_node_info:
--------%<--------
[root at db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 0
db2 5433 3 1073741823.500000
[root at db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 1
db3 5433 3 1073741823.500000
--------%<--------

Server info:
--------%<--------
[root at db3 pgpool-II]# rpm -qa | egrep 'pgpool|postgres'
postgresql-devel-8.3.1-1PGDG.rhel5
postgresql-contrib-8.3.1-1PGDG.rhel5
compat-postgresql-libs-4-1PGDG.rhel5
postgresql-8.3.1-1PGDG.rhel5
postgresql-server-8.3.1-1PGDG.rhel5
postgresql-libs-8.3.1-1PGDG.rhel5
postgresql-docs-8.3.1-1PGDG.rhel5
pgpool-II-2.3-1.rhel5

[root at db3 pgpool-II]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
--------%<--------

Any help is very much appreciated.

Thanks,
Ger.



More information about the Pgpool-general mailing list