Unable to fork: Resource Unavailable
"Chatur Gopalkrishna" <[email protected]> Tue, 7 Jan 2020 14:45:44 +0530
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
This is a multipart message in MIME format.
------=_NextPart_000_0071_01D5C569.276B2970
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi!
Our system works in hot/standby mode. There are multiple tables with
multiple entries in the postgres sql database.
We observed that at times, observing the following prints:
2019-12-28T14:11:12.522653+09:00 localhost postgres[1355]: [3-1] 2019-12-28
05:11:12.521 GMT LOG: could not fork autovacuum worker process: Resource
temporarily unavailable
2019-12-28T14:11:13.050796+09:00 localhost postgres[1355]: [4-1] 2019-12-28
05:11:13.050 GMT LOG: archiver process (PID 27698) exited with exit code 1
2019-12-28T14:11:13.051514+09:00 localhost postgres[1355]: [5-1] 2019-12-28
05:11:13.051 GMT LOG: archiver process (PID 17226) exited with exit code 1
2019-12-28T14:12:23.259291+09:00 localhost postgres[1355]: [6-1] 2019-12-28
05:12:23.259 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:12:23.267624+09:00 localhost postgres[1355]: [7-1] 2019-12-28
05:12:23.267 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:14:08.384115+09:00 localhost postgres[1355]: [8-1] 2019-12-28
05:14:08.383 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:14:08.384348+09:00 localhost postgres[1355]: [9-1] 2019-12-28
05:14:08.384 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:14:12.581409+09:00 localhost postgres[1355]: [10-1] 2019-12-28
05:14:12.581 GMT LOG: could not fork autovacuum worker process: Resource
temporarily unavailable
2019-12-28T14:14:13.391192+09:00 localhost postgres[1355]: [11-1] 2019-12-28
05:14:13.391 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:14:13.391356+09:00 localhost postgres[1355]: [12-1] 2019-12-28
05:14:13.391 GMT LOG: could not fork new process for connection: Resource
temporarily unavailable
2019-12-28T14:14:13.581992+09:00 localhost postgres[1355]: [13-1] 2019-12-28
05:14:13.581 GMT LOG: could not fork autovacuum worker process: Resource
temporarily unavailable
.
.
Due to the above, our applications are unable to connect to Postgres and our
systems are rebooting.
Can someone please help me understand the reason of "Resource temporarily
unavailable" and any configuration / debug pointers?
Thanks,
Chatur G
------=_NextPart_000_0071_01D5C569.276B2970
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 15 =
(filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-IN =
link=3D"#0563C1" vlink=3D"#954F72"><div class=3DWordSection1><p =
class=3DMsoNormal>Hi!<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>Our system =
works in hot/standby mode. There are multiple tables with multiple =
entries in the postgres sql database.<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>We observed =
that at times, observing the following prints:<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:11:12.522653+09:00 localhost postgres[1355]: [3-1] =
2019-12-28 05:11:12.521 GMT LOG: could not fork autovacuum worker =
process: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:11:13.050796+09:00 localhost postgres[1355]: [4-1] =
2019-12-28 05:11:13.050 GMT LOG: archiver process (PID 27698) =
exited with exit code 1<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:11:13.051514+09:00 localhost postgres[1355]: [5-1] =
2019-12-28 05:11:13.051 GMT LOG: archiver process (PID 17226) =
exited with exit code 1<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:12:23.259291+09:00 localhost postgres[1355]: [6-1] =
2019-12-28 05:12:23.259 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:12:23.267624+09:00 localhost postgres[1355]: [7-1] =
2019-12-28 05:12:23.267 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:08.384115+09:00 localhost postgres[1355]: [8-1] =
2019-12-28 05:14:08.383 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:08.384348+09:00 localhost postgres[1355]: [9-1] =
2019-12-28 05:14:08.384 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:12.581409+09:00 localhost postgres[1355]: [10-1] =
2019-12-28 05:14:12.581 GMT LOG: could not fork autovacuum worker =
process: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:13.391192+09:00 localhost postgres[1355]: [11-1] =
2019-12-28 05:14:13.391 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:13.391356+09:00 localhost postgres[1355]: [12-1] =
2019-12-28 05:14:13.391 GMT LOG: could not fork new process for =
connection: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>2019-12-28T14:14:13.581992+09:00 localhost postgres[1355]: [13-1] =
2019-12-28 05:14:13.581 GMT LOG: could not fork autovacuum worker =
process: Resource temporarily unavailable<o:p></o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Courier =
New"'>.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'>.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:9.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></p><p class=3DMsoNormal>Due to the above, =
our applications are unable to connect to Postgres and our systems are =
rebooting.<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal>Can someone please help me understand the reason of =
“Resource temporarily unavailable” and any configuration / =
debug pointers?<o:p></o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal>Thanks,<o:p></o:p></p><p class=3DMsoNormal>Chatur =
G<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p><p =
class=3DMsoNormal><o:p> </o:p></p></div></body></html>
------=_NextPart_000_0071_01D5C569.276B2970--