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

[Tatsuo Ishii]

> 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.
> --------%<--------

Sounds like an authentication problem. Can you show us pgpool.conf and
pg_hba.conf of PostgreSQL on db3?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> 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.
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general