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

[Tatsuo Ishii]

Wouter,

Thank you for joining my talk and the bug report.

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

Ok, could you try included patches?

> BTW: Nice talk on fosdem

Thanks!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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 --------------
A non-text attachment was scrubbed...
Name: main.c.patch
Type: text/x-patch
Size: 1939 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110209/97130025/attachment.bin>