Olá Srs ! Continuo na minha labuta em que o failover não funciona ! Pensei que fosse o bug, mas após atualização do pacote do pgpool para 3.1.4 o problema persiste. Segue o log caso alguém possa dar uma luz ! Interessante que antes havia feito o teste e o failover funcionou numa boa, depois que tentei novamente não funciona mais, será que após um failover o pgpool ou postgres grava alguma informação dos servidores pertencentes a node1 e node2 e não possibilita um novo failover ?
obs: Verifiquei que após o execute command: /usr/pgpool-9.1/bin/failover_stream.sh 0 xx.x.xx.xxx /tmp/arquivo_gatilho.pgsql o arquivo é alterado no outro servidor ! 2012-08-02 15:23:48 DEBUG: pid 16098: detect_stop_postmaster_error: receive crash shutdown error from a node. 2012-08-02 15:23:48 LOG: pid 16098: postmaster on DB node 0 was shutdown by administrative command 2012-08-02 15:23:48 LOG: pid 16098: degenerate_backend_set: 0 fail over request from pid 16098 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler called 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: starting to select new master node 2012-08-02 15:23:48 LOG: pid 15599: starting degeneration. shutdown host xx.x.xx.xxx(5432) 2012-08-02 15:23:48 LOG: pid 15599: Restart all children 2012-08-02 15:23:48 LOG: pid 15599: Restart all children 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: kill 15600 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: kill 15601 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: kill 15602 2012-08-02 15:23:48 DEBUG: pid 15600: child received shutdown request signal 3 2012-08-02 15:23:48 DEBUG: pid 16097: detect_error: kind: N 2012-08-02 15:23:48 DEBUG: pid 16097: detect_error: kind: N 2012-08-02 15:23:48 DEBUG: pid 16097: detect_stop_postmaster_error: receive crash shutdown error from a node. 2012-08-02 15:23:48 LOG: pid 16097: postmaster on DB node 0 was shutdown by administrative command 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: kill 15727 2012-08-02 15:23:48 DEBUG: pid 16098: child received shutdown request signal 3 2012-08-02 15:23:48 DEBUG: pid 16099: child received shutdown request signal 3 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler: kill 16099 2012-08-02 15:23:48 LOG: pid 15599: execute command: /usr/pgpool-9.1/bin/failover_stream.sh 0 xx.x.xx.xxx /tmp/arquivo_gatilho.pgsql 2012-08-02 15:23:48 LOG: pid 15599: find_primary_node_repeatedly: waiting for finding a primary node 2012-08-02 15:23:48 DEBUG: pid 15599: pool_ssl: SSL requested but SSL support is not available 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: auth kind: 0 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: parameter status data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: backend key data received 2012-08-02 15:23:48 DEBUG: pid 15599: s_do_auth: transaction state: I 2012-08-02 15:23:48 DEBUG: pid 15599: do_query: kind: T 2012-08-02 15:23:48 DEBUG: pid 15599: num_fileds: 1 2012-08-02 15:23:48 DEBUG: pid 15599: do_query: kind: D 2012-08-02 15:23:48 DEBUG: pid 15599: do_query: kind: C 2012-08-02 15:23:48 DEBUG: pid 15599: do_query: kind: Z 2012-08-02 15:23:48 DEBUG: pid 15599: find_primary_node: 1 node is standby 2012-08-02 15:23:48 DEBUG: pid 15599: find_primary_node: no primary node found 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler called 2012-08-02 15:23:48 DEBUG: pid 15599: failover_handler called while switching 2012-08-02 15:23:48 DEBUG: pid 15599: reap_handler called 2012-08-02 15:23:48 DEBUG: pid 15599: reap_handler: exited due to switching 2012-08-02 15:23:49 DEBUG: pid 15599: pool_ssl: SSL requested but SSL support is not available 2012-08-02 15:23:49 DEBUG: pid 15599: s_do_auth: auth kind: 0 2012-08-02 15:25:19 DEBUG: pid 16627: pool_initialize_private_backend_status: initialize backend status 2012-08-02 15:25:19 DEBUG: pid 16625: I am 16625 2012-08-02 15:25:19 DEBUG: pid 16625: pool_initialize_private_backend_status: initialize backend status 2012-08-02 15:25:19 LOG: pid 16101: worker process received restart request 2012-08-02 15:25:19 LOG: pid 15599: failover done. shutdown host 10.2.64.19(5432) 2012-08-02 15:25:20 DEBUG: pid 15599: child 16099 exits with status 0 2012-08-02 15:25:20 LOG: pid 15599: PCP child 16100 exits with status 256 2012-08-02 15:25:20 LOG: pid 15599: fork a new PCP child pid 16633 2012-08-02 15:25:20 DEBUG: pid 15599: reap_handler: normally exited 2012-08-02 15:25:20 DEBUG: pid 15599: failover_handler called 2012-08-02 15:25:20 DEBUG: pid 15599: failover_handler: starting to select new master node 2012-08-02 15:25:20 LOG: pid 15599: failover: no backends are degenerated 2012-08-02 15:25:20 DEBUG: pid 15599: reap_handler called 2012-08-02 15:25:20 DEBUG: pid 15599: reap_handler: call wait3 2012-08-02 15:25:20 LOG: pid 15599: worker child 16101 exits with status 256 2012-08-02 15:25:20 LOG: pid 15599: fork a new worker child pid 16634 2012-08-02 15:25:20 DEBUG: pid 15599: reap_handler: normally exited 2012-08-02 15:25:20 DEBUG: pid 15599: starting health checking 2012-08-02 15:25:20 DEBUG: pid 15599: health_check: 0 th DB node status: 3 2012-08-02 15:25:20 DEBUG: pid 15599: health_chec2012-08-02 15:25:20 DEBUG: pid 16634: pool_initialize_private_backend_status: initialize backend status 2012-08-02 15:25:20 DEBUG: pid 16634: pool_ssl: SSL requested but SSL support is not available 2012-08-02 15:25:20 DEBUG: pid 16634: s_do_auth: auth kind: 0 2012-08-02 15:38:58 DEBUG: pid 16631: child received shutdown request signal 15 2012-08-02 15:38:58 ERROR: pid 15599: Could not open status file /var/log/pgpool-II/pgpool_status/pgpool_status 2012-08-02 15:38:58 DEBUG: pid 15599: shmem_exit(0) -- Antonio Abner Junior - AJ
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
