Srs, Estou testando o Pgpool com HotStandby Stream Replication e quando eu retiro(pg_ctl stop) no servidor master o segundo no não assum como o primário. Meu é ambiente são 2 PostgreSQL 9.1, Pgpool-II version 3.1 e S.O Red Hat Enterprise Linux Server release 6.1 O log do pgpool mostra o seguinte:
12-07-26 16:07:48 DEBUG: pid 6496: check_replication_time_lag: DB node is valid but no persistent connection 2012-07-26 16:07:48 ERROR: pid 6496: check_replication_time_lag: could not connect to DB node 0, check health check configuration 2012-07-26 16:07:58 DEBUG: pid 5994: starting health checking 2012-07-26 16:07:58 DEBUG: pid 5994: health_check: 0 th DB node status: 1 2012-07-26 16:07:58 ERROR: pid 5994: connect_inet_domain_socket: connect() failed: Connection refused 2012-07-26 16:07:58 ERROR: pid 5994: health check failed. 0 th host xx.x.xx.xx at port 5432 is down 2012-07-26 16:07:58 LOG: pid 5994: set 0 th backend down status 2012-07-26 16:07:58 DEBUG: pid 5994: failover_handler called 2012-07-26 16:07:58 DEBUG: pid 5994: failover_handler: starting to select new master node 2012-07-26 16:07:58 LOG: pid 5994: starting degeneration. shutdown host xx.x.xx.xx(5432) 2012-07-26 16:07:58 LOG: pid 5994: Restart all children 2012-07-26 16:07:58 LOG: pid 5994: execute command: /usr/pgpool-9.1/bin/failover_stream.sh 0 xx.x.xx.xx /tmp/arquivo_gatilho.pgsql 2012-07-26 16:07:58 LOG: pid 5994: find_primary_node_repeatedly: waiting for finding a primary node 2012-07-26 16:07:58 DEBUG: pid 5994: pool_ssl: SSL requested but SSL support is not available 2012-07-26 16:07:58 DEBUG: pid 5994: s_do_auth: auth kind: 0 2012-07-26 16:07:58 DEBUG: pid 5994: find_primary_node: 1 node is standby 2012-07-26 16:07:58 DEBUG: pid 5994: find_primary_node: no primary node found 2012-07-26 16:07:58 DEBUG: pid 5994: reap_handler called 2012-07-26 16:07:58 DEBUG: pid 5994: reap_handler: exited due to switching 2012-07-26 16:07:59 DEBUG: pid 5994: find_primary_node: 1 node is standby 2012-07-26 16:07:59 DEBUG: pid 5994: find_primary_node: no primary node found 2012-07-26 16:08:07 DEBUG: pid 5994: find_primary_node: 1 node is standby 2012-07-26 16:08:07 DEBUG: pid 5994: find_primary_node: no primary node found 2012-07-26 16:08:08 ERROR: pid 6496: connect_inet_domain_socket: connect() failed: Connection refused 2012-07-26 16:08:08 ERROR: pid 6496: make_persistent_db_connection: connection to xx.x.xx.xx(5432) failed 2012-07-26 16:08:08 DEBUG: pid 6496: pool_ssl: SSL requested but SSL support is not available 2012-07-26 16:08:08 DEBUG: pid 6496: check_replication_time_lag: DB node is valid but no persistent connection 2012-07-26 16:08:08 ERROR: pid 6496: check_replication_time_lag: could not connect to DB node 0, check health check configuration 2012-07-26 16:08:08 DEBUG: pid 5994: pool_ssl: SSL requested but SSL support is not available 2012-07-26 16:09:29 LOG: pid 5994: failover done. shutdown host xx.x.xx.xx(5432) 2012-07-26 16:10:18 DEBUG: pid 6496: check_replication_time_lag: DB node is valid but no persistent connection 2012-07-26 16:10:18 ERROR: pid 6496: check_replication_time_lag: could not connect to DB node 0, check health check configuration 2012-07-26 16:10:28 ERROR: pid 6496: connect_inet_domain_socket: connect() failed: Connection refused 2012-07-26 16:10:28 ERROR: pid 6496: make_persistent_db_connection: connection to xx.x.xx.xx(5432) failed 2012-07-26 16:10:28 DEBUG: pid 6496: pool_ssl: SSL requested but SSL support is not available 2012-07-26 16:15:28 DEBUG: pid 6496: check_replication_time_lag: DB node is valid but no persistent connection 2012-07-26 16:15:28 ERROR: pid 6496: check_replication_time_lag: could not connect to DB node 0, check health check configuration 2012-07-26 16:15:30 DEBUG: pid 5994: starting health checking 2012-07-26 16:15:30 DEBUG: pid 5994: health_check: 0 th DB node status: 3 2012-07-26 16:15:30 DEBUG: pid 5994: health_check: 1 th DB node status: 1 2012-07-26 16:15:38 ERROR: pid 6496: connect_inet_domain_socket: connect() failed: Connection refused 2012-07-26 16:15:38 ERROR: pid 6496: make_persistent_db_connection: connection to xx.x.xx.xx(5432) failed 2012-07-26 16:15:38 DEBUG: pid 6496: pool_ssl: SSL requested but SSL support is not available 2012-07-26 16:15:38 DEBUG: pid 6496: s_do_auth: auth kind: 0 Antonio Abner Junior - AJ
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
