[Pgpool-general] Zombies roaming the server
Bruno Lustosa
bruno.lists at gmail.com
Mon Feb 18 14:57:02 UTC 2008
Hello, folks.
I've been having problems with pgpool. As Yoshiyuki suggested, I
removed the "SET SESSION
AUTHORIZATION DEFAULT" from the reset query list.
Now, instead of dropping the secondary backend, it just stops
receiving connections and its children turn into zombies.
Unfortunately, it was started without -n, so I don't have logs now. I
restarted with -n, so if it happens again, I'll post the log.
There are quite a few RESET queries, also from the reset query list. I
took them out before restarting, though I don't know if this is the
real problem (just a wild guess).
I can recompile pgpool-II if some other options could help debugging.
It's currently compiled with just "-O2 -march=K8". There is no
-fomit-frame-pointer, but I could turn on some extra debug flags in
gcc if it helps.
Here is the output from a 'ps axf' after children starts becoming
zombies (hvnovo is the user and database name):
25176 ? Ss 0:14 /usr/bin/pgpool
27080 ? Z 0:00 \_ [pgpool] <defunct>
27104 ? Z 0:00 \_ [pgpool] <defunct>
28434 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(58636) idle
28639 ? S 0:01 \_ pgpool: hvnovo hvnovo 192.168.10.72(58630) INSERT
29179 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59088) idle
29186 ? S 0:01 \_ pgpool: hvnovo hvnovo 192.168.10.72(59087) INSERT
29273 ? S 0:01 \_ pgpool: hvnovo hvnovo 192.168.10.72(59152) INSERT
29290 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59153) idle
29327 ? Z 0:00 \_ [pgpool] <defunct>
29522 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53282) RESET
30040 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53287) RESET
30106 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51119) RESET
30147 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59795) RESET
30164 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51182) idle
30208 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59603) idle
30209 ? Z 0:00 \_ [pgpool] <defunct>
30224 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51181) INSERT
30228 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53394) RESET
30258 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59643) idle
30265 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59627) RESET
30278 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59639) INSERT
30280 ? Z 0:00 \_ [pgpool] <defunct>
30300 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53432) RESET
30311 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59691) RESET
30323 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53612) RESET
30332 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59733) RESET
30333 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53592) RESET
30342 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53602) RESET
30345 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59825) RESET
30347 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53524) RESET
30361 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59743) RESET
30375 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59720) RESET
30377 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59976) idle
30379 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59832) RESET
30392 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53594) RESET
30400 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53610) RESET
30404 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59855) RESET
30408 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59843) RESET
30409 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53614) RESET
30411 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53626) RESET
30419 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59777) RESET
30420 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53595) RESET
30423 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59892) RESET
30427 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59775) INSERT
30429 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59974) idle
30436 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53624) RESET
30437 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59866) RESET
30442 ? Z 0:00 \_ [pgpool] <defunct>
30443 ? Z 0:00 \_ [pgpool] <defunct>
30449 ? Z 0:00 \_ [pgpool] <defunct>
30451 ? Z 0:00 \_ [pgpool] <defunct>
30453 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51259) RESET
30458 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59889) RESET
30459 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59879) RESET
30460 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59878) RESET
30464 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59890) RESET
30474 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51268) RESET
30477 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59972) idle
30478 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59910) RESET
30481 ? Z 0:00 \_ [pgpool] <defunct>
30482 ? Z 0:00 \_ [pgpool] <defunct>
30484 ? Z 0:00 \_ [pgpool] <defunct>
30485 ? Z 0:00 \_ [pgpool] <defunct>
30487 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59837) RESET
30489 ? Z 0:00 \_ [pgpool] <defunct>
30491 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59925) RESET
30493 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.12(51277) RESET
30495 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59826) idle
30497 ? Z 0:00 \_ [pgpool] <defunct>
30498 ? Z 0:00 \_ [pgpool] <defunct>
30513 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59844) RESET
30514 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59968) idle
30516 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.22(59935) RESET
30523 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59849) RESET
30527 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59970) idle
30528 ? Z 0:00 \_ [pgpool] <defunct>
30529 ? Z 0:00 \_ [pgpool] <defunct>
30538 ? Z 0:00 \_ [pgpool] <defunct>
30543 ? Z 0:00 \_ [pgpool] <defunct>
30545 ? Z 0:00 \_ [pgpool] <defunct>
30546 ? Z 0:00 \_ [pgpool] <defunct>
30551 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53681) RESET
30554 ? Z 0:00 \_ [pgpool] <defunct>
30555 ? Z 0:00 \_ [pgpool] <defunct>
30556 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59978) idle
30557 ? Z 0:00 \_ [pgpool] <defunct>
30558 ? Z 0:00 \_ [pgpool] <defunct>
30559 ? Z 0:00 \_ [pgpool] <defunct>
30561 ? Z 0:00 \_ [pgpool] <defunct>
30565 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.82(53684) RESET
30566 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59903) idle
30574 ? Z 0:00 \_ [pgpool] <defunct>
30575 ? Z 0:00 \_ [pgpool] <defunct>
30576 ? Z 0:00 \_ [pgpool] <defunct>
30578 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59894) RESET
30581 ? Z 0:00 \_ [pgpool] <defunct>
30582 ? Z 0:00 \_ [pgpool] <defunct>
30583 ? Z 0:00 \_ [pgpool] <defunct>
30584 ? Z 0:00 \_ [pgpool] <defunct>
30585 ? Z 0:00 \_ [pgpool] <defunct>
30586 ? Z 0:00 \_ [pgpool] <defunct>
30587 ? Z 0:00 \_ [pgpool] <defunct>
30588 ? Z 0:00 \_ [pgpool] <defunct>
30589 ? Z 0:00 \_ [pgpool] <defunct>
30590 ? Z 0:00 \_ [pgpool] <defunct>
30591 ? Z 0:00 \_ [pgpool] <defunct>
30592 ? Z 0:00 \_ [pgpool] <defunct>
30593 ? Z 0:00 \_ [pgpool] <defunct>
30594 ? Z 0:00 \_ [pgpool] <defunct>
30595 ? Z 0:00 \_ [pgpool] <defunct>
30596 ? S 0:00 \_ pgpool: hvnovo hvnovo 192.168.10.72(59904) idle
30597 ? Z 0:00 \_ [pgpool] <defunct>
30598 ? Z 0:00 \_ [pgpool] <defunct>
30599 ? Z 0:00 \_ [pgpool] <defunct>
30600 ? Z 0:00 \_ [pgpool] <defunct>
30601 ? Z 0:00 \_ [pgpool] <defunct>
30602 ? Z 0:00 \_ [pgpool] <defunct>
30603 ? Z 0:00 \_ [pgpool] <defunct>
30604 ? Z 0:00 \_ [pgpool] <defunct>
30605 ? Z 0:00 \_ [pgpool] <defunct>
30606 ? Z 0:00 \_ [pgpool] <defunct>
30607 ? Z 0:00 \_ [pgpool] <defunct>
30608 ? Z 0:00 \_ [pgpool] <defunct>
30609 ? Z 0:00 \_ [pgpool] <defunct>
30610 ? Z 0:00 \_ [pgpool] <defunct>
30611 ? Z 0:00 \_ [pgpool] <defunct>
30612 ? Z 0:00 \_ [pgpool] <defunct>
30613 ? Z 0:00 \_ [pgpool] <defunct>
30614 ? Z 0:00 \_ [pgpool] <defunct>
Thanks for your help
--
Bruno Lustosa <bruno at lustosa.net>
http://www.lustosa.net/
More information about the Pgpool-general
mailing list