|
|
Zombies roaming the server: msg#00014db.postgresql.pgpool.general
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-God0kL5/+C3R7s880joybQ@xxxxxxxxxxxxxxxx> http://www.lustosa.net/ |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: pgpool-II + warm standby: 00014, Simon Riggs |
|---|---|
| Next by Date: | Re: Zombies roaming the server: 00014, Yoshiyuki Asaba |
| Previous by Thread: | pgpool-II + warm standbyi: 00014, Yoshiyuki Asaba |
| Next by Thread: | Re: Zombies roaming the server: 00014, Yoshiyuki Asaba |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |