<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div style="font-family:Verdana,Arial,Helvetica,sans-serif; font-size:small; color:black">
<span style="font-family:Verdana,Arial,Helvetica,sans-serif; font-size:small; color:black">Dear Tatsuo,
<br>
<br>
thanks for your quick response! <br>
Can you please elaborate on this bug/ do you have suggestions on how to work around it, until the fixed version finds it way into the Ubuntu repository?
<br>
<br>
Regarding your other email, ulimit shows unlimited processes. <br>
<br>
Best regards, <br>
Ludwig <br>
<br>
Mobil gesendet.<br>
<br>
<span style="color:black">-----Original Message----- <br>
<b>From:</b> Tatsuo Ishii [ishii@postgresql.org]<br>
<b>Received:</b> Dienstag, 08 Mai 2012, 2:14<br>
<b>To:</b> Ludwig Adam [ludwig.adam@petafuel.de]<br>
<b>CC:</b> pgpool-general@pgpool.net [pgpool-general@pgpool.net]; EDV [EDV@petafuel.de]<br>
<b>Subject:</b> Re: [pgpool-general: 418] pg-pool-3.0.4. -unable to create child processes<br>
<br>
</span></span></div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">I suspect you hit a bug fixed in 3.0.7:<br>
<br>
- Fix bug that the process exits before unlocking semaphore by a<br>
signal interrupt. (Tatsuo Ishii)<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><br>
<br>
> Dear list,<br>
> <br>
> we just encountered a production issue with pg-pool-3.0.4.: pg-pool killed all idle childprocesses which were waiting for a connection request and failed to create new ones.<br>
> <br>
> I am unsure why the childs exited:<br>
> <br>
> <br>
> 1) As we have child_life_time = 300 I guess the childs exited normally after a 5 minute period.<br>
> <br>
> 2) We did a Config reload on pg_pool, and that could mean also that waiting child processes are killed<br>
> <br>
> but pg_pool did not create new ones. So we were left with ~110 active pg-pool processes (which still seemed to work) but we could make no new connections to pgppol (can't tell if the connections have been queued or not).<br>
> This is what the syslog says:<br>
> <br>
> May 7 15:43:13 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 15:43:13 LOG: pid 938: reload config files.<br>
> May 7 15:43:13 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 15:43:13 LOG: pid 2707: reload config files.<br>
> May 7 16:09:29 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 16:09:17 ERROR: pid 938: fork() failed. reason: Resource temporarily unavailable<br>
> May 7 16:09:34 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 16:09:34 LOG: pid 29194: connect_inet_domain_socket_by_port: exit request has been sent<br>
> May 7 16:09:34 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 16:09:34 ERROR: pid 29194: connection to <backendserver ha1 here> (5432) failed<br>
> May 7 16:09:34 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 16:09:34 ERROR: pid 29194: new_connection: create_cp() failed<br>
> May 7 16:09:34 pgpool-PrepaidDB-HA1 pgpool: 2012-05-07 16:09:34 LOG: pid 29194: notice_backend_error: 0 fail over request from pid 29194<br>
> May 7 16:30:22 pgpool-PrepaidDB-HA1 heartbeat: [2425]: info: pgpool-prepaiddb-ha1 wants to go standby [all]<br>
> <br>
> We also noticed some high load on the server which may be related to the issue.<br>
> <br>
> Any idea what the the cause of this issue is? Do you recommend setting child_life_time = 0? I think there are some memory leak issues in the 3.0.4 versions.<br>
> 3.0.4 is the latest official version in the Ubuntu repository and we would rather not go to self-compiled versions for reasons of maintenance and compliance.<br>
> <br>
> Best regards,<br>
> Ludwig<br>
> <br>
> petaFuel GmbH<br>
> Ludwig Adam<br>
> Geschäftsführer<br>
> <br>
> Münchner Strasse 4<br>
> 85354 Freising<br>
> <br>
> Tel.: +49 (0) 8161 4060 - 202 Mobil: +49 (0) 179-22 911 02<br>
> Fax: +49 (0) 8161 4060 - 401 eMail: ludwig.adam@petafuel.de<mailto:ludwig.adam@petafuel.de><br>
> <br>
> Geschäftsführer: Ludwig Adam, Dr. Peter Schönweitz<br>
> Amtsgericht München, HRB 133773<br>
> <a href="http://www.petaFuel.de">www.petaFuel.de</a><br>
> <br>
</div>
</span></font>
</body>
</html>