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.
--------%<--------
postg...@db3$ psql -p9999 database_name
psql: could not send startup packet: Broken pipe <- seen this happen once
postg...@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:
--------%<--------
postg...@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:
--------%<--------
[r...@db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 0
db2 5433 3 1073741823.500000
[r...@db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 1
db3 5433 3 1073741823.500000
--------%<--------
Server info:
--------%<--------
[r...@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
[r...@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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
