[Pgpool-general] PGpool crashes when all DB servers go down

[Wouter D'Haeseleer]

Hi All,


Situation:
- Primary and standby db are running fine 
- Primary fails, pgpool promotes the standby to master
- New master fails also, pgool craches

BTW: Nice talk on fosdem

See bellow for logging:

2011-02-06 22:17:05 LOG:   pid 4915: pgpool-II successfully started. version 3.1.0-alpha1 (umiyameboshi)
2011-02-06 22:17:05 LOG:   pid 4915: find_primary_node: primary node id is 0

2011-02-06 22:17:55 ERROR: pid 4949: pool_read: EOF encountered with backend
2011-02-06 22:17:55 ERROR: pid 4949: do_query: error while reading message kind
2011-02-06 22:17:55 ERROR: pid 4949: check_replication_time_lag: SELECT pg_current_xlog_location() failed
2011-02-06 22:17:55 ERROR: pid 4915: connect_inet_domain_socket: connect() failed: Connection refused
2011-02-06 22:17:55 ERROR: pid 4915: health check failed. 0 th host dps-db1-3.infra.vasco.com at port 5433 is down
2011-02-06 22:17:55 LOG:   pid 4915: set 0 th backend down status
2011-02-06 22:17:55 LOG:   pid 4915: starting degeneration. shutdown host dps-db1-3.infra.vasco.com(5433)
2011-02-06 22:17:55 LOG:   pid 4915: execute command: /usr/local/bin/failover.sh 0 dps-db2-3.infra.vasco.com /tmp/trigger_file0
2011-02-06 22:17:55 LOG:   pid 4915: failover_handler: set new master node: 1
2011-02-06 22:17:55 LOG:   pid 4915: failover done. shutdown host dps-db1-3.infra.vasco.com(5433)
2011-02-06 22:17:55 LOG:   pid 4915: find_primary_node: primary node id is 1

2011-02-06 22:19:05 ERROR: pid 4915: connect_inet_domain_socket: connect() failed: Connection refused
2011-02-06 22:19:05 ERROR: pid 4915: health check failed. 1 th host dps-db2-3.infra.vasco.com at port 5433 is down
2011-02-06 22:19:05 LOG:   pid 4915: set 1 th backend down status
2011-02-06 22:19:05 LOG:   pid 4915: starting degeneration. shutdown host dps-db2-3.infra.vasco.com(5433)
2011-02-06 22:19:05 ERROR: pid 4915: failover_handler: no valid DB node found
Segmentation fault


Attached also the config file


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110207/593a3acd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 9357 bytes
Desc: pgpool.conf
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110207/593a3acd/attachment.obj>