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
pgpool.conf
Description: pgpool.conf
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
