Hello, Attached are some of the messages due to the cited inadequate tcp kernel parameter for pgpool operation when stress loaded.
Regards. Andre Felipe Machado http://www.techforce.com.br
Dec 7 13:51:53 Pgpool01 pgpool: ERROR: pid 29377: health check failed during read. host pgBack02 at port 5432 is down. reason: Interrupted system call Dec 7 13:51:53 Pgpool01 pgpool: LOG: pid 29377: set 1 th backend down status Dec 7 13:51:53 Pgpool01 pgpool: LOG: pid 29377: starting degeneration. shutdown host pgBack02(5432) Dec 7 13:51:53 Pgpool01 pgpool: LOG: pid 29377: execute command: echo $(date), host:pgBack02, new master id:0, old master id:0 port number:5432 >> /tmp/failover.log Dec 7 13:51:54 Pgpool01 pgpool: LOG: pid 29377: failover_handler: set new master node: 0 Dec 7 13:51:54 Pgpool01 pgpool: LOG: pid 29377: failover done. shutdown host pgBack02(5432) D Dec 15 09:26:11 Pgpool01 pgpool: ERROR: pid 16160: health check failed during read. host pgBack02 at port 5432 is down. reason: Interrupted system call Dec 15 09:26:11 Pgpool01 pgpool: LOG: pid 16160: set 1 th backend down status Dec 15 09:26:11 Pgpool01 pgpool: LOG: pid 16160: starting degeneration. shutdown host pgBack02(5432) Dec 15 09:26:11 Pgpool01 pgpool: LOG: pid 16160: execute command: echo $(date), host:pgBack02, new master id:0, old master id:0 port number:5432 >> /tmp/failover.log Dec 15 09:26:11 Pgpool01 pgpool: LOG: pid 16160: failover_handler: set new master node: 0 Dec 15 09:26:11 Pgpool01 pgpool: LOG: pid 16160: failover done. shutdown host pgBack02(5432) Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6421: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6421: connection to pgBack01(5432) failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6421: new_connection: create_cp() failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6486: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 6421: notice_backend_error: 0 fail over request from pid 6421 Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6486: connection to pgBack01(5432) failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6486: new_connection: create_cp() failed Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 6486: notice_backend_error: 0 fail over request from pid 6486 Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 16160: starting degeneration. shutdown host pgBack01(5432) Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 16160: failover_handler: no valid DB node found Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6711: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6711: connection to pgBack01(5432) failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6711: new_connection: create_cp() failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6748: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6748: connection to pgBack01(5432) failed Dec 15 09:26:32 Pgpool01 pgpool: ERROR: pid 6748: new_connection: create_cp() failed Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 16160: execute command: echo $(date), host:pgBack01, new master id:2, old master id:0 port number:5432 >> /tmp/failover.log Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 16160: failover_handler: set new master node: 2 Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 7000: Cannot accept() new connection. all backends are down Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 7001: Cannot accept() new connection. all backends are down Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 7002: Cannot accept() new connection. all backends are down Dec 15 09:26:32 Pgpool01 pgpool: LOG: pid 7032: Cannot accept() new connection. all backends are down Dec 15 09:26:33 Pgpool01 pgpool: LOG: pid 16160: failover done. shutdown host pgBack01(5432) Dec 15 09:26:33 Pgpool01 pgpool: LOG: pid 7745: Cannot accept() new connection. all backends are down Dec 15 09:26:33 Pgpool01 pgpool: LOG: pid 7748: Cannot accept() new connection. all backends are down Dec 15 09:26:35 Pgpool01 pgpool: LOG: pid 7746: Cannot accept() new connection. all backends are down Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18188: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18433: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18433: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18433: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18188: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 18433: notice_backend_error: 0 fail over request from pid 18433 Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18188: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 18188: notice_backend_error: 0 fail over request from pid 18188 Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 17705: starting degeneration. shutdown host pgBack01(5432) Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 17705: failover_handler: no valid DB node found Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18122: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18122: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18122: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18186: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18186: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18186: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18244: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18244: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18244: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18395: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18395: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18395: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18396: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18396: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18396: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18373: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18373: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18373: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18370: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18412: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18370: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18370: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18412: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18412: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18149: connect_inet_domain_socket: connect() failed: Connection timed out Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18149: connection to pgBack01(5432) failed Dec 15 10:40:04 Pgpool01 pgpool: ERROR: pid 18149: new_connection: create_cp() failed Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 17705: execute command: echo $(date), host:pgBack01, new master id:2, old master id:0 port number:5432 >> /tmp/failover.log Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 17705: failover_handler: set new master node: 2 Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 18628: Cannot accept() new connection. all backends are down Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 18629: Cannot accept() new connection. all backends are down Dec 15 10:40:04 Pgpool01 pgpool: LOG: pid 18631: Cannot accept() new connection. all backends are down
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
