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

[Ger Apeldoorn]

Hi Tatsuo,

Ah, authentication.. I have noticed that the previous PGPOOL package ran
as root, and this one as postgres. Perhaps that messes up the
authentication.

I'll look into it and will get back to you, thanks!

Ger.

On Mon, 2010-01-18 at 09:52 +0100, Tatsuo Ishii wrote:
> > 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