Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iol2U-0006UB-4R for pgsql-bugs@arkaria.postgresql.org; Tue, 07 Jan 2020 09:20:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iol2S-00047M-Ur for pgsql-bugs@arkaria.postgresql.org; Tue, 07 Jan 2020 09:20:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iokxv-0000vI-0W for pgsql-bugs@lists.postgresql.org; Tue, 07 Jan 2020 09:15:55 +0000 Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iokxs-0008GT-8t for pgsql-bugs@lists.postgresql.org; Tue, 07 Jan 2020 09:15:54 +0000 Received: by mail-pf1-x430.google.com with SMTP id i23so22880747pfo.2 for ; Tue, 07 Jan 2020 01:15:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ridenext-co-in.20150623.gappssmtp.com; s=20150623; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=ncZOX3rfhDhoGz7LbOwznk3Hu2y4shN0lvcnOM409YY=; b=y1C4MeMzMrxA/inNtNXt54D4/oO2EXtobfaSVaJvCmd/yby8IZcu2I1bS9YfBZHAxV MdDMLxgH/DCTN0IDQdV+p3hWdusUlNsuhzaPMXtbhGnP5JSZ/FjhJwtcNz1IzpcAiCKx tnRG8WAH5YrDSIXJWZVjOcv+XAxZC/Mac7t42QsPdzGbZK2XOBRdEir0MAyfBhAH9qkO DH0hOvlwT3jDxN+GRkYas/jbBVTmHNJiwbEqIRsNcZu1y+BqWXXfrT1HK1X0q+ePxe45 EXuaZvjhtWl392j9MAQF2XMRPGn/VVWUcTb3cVgHWxbK/CLYM8JmaflMPQVJ8EJuYzvQ l4vA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=ncZOX3rfhDhoGz7LbOwznk3Hu2y4shN0lvcnOM409YY=; b=nSLXyg+yHOrhIk/3bLgIV61aViVDkaxQJeQ24iOcPN/OWd1rnSXdZwyueeOwjcoAWA +QxQwq20IKMUdiH1Y7BM/1EgySqWL6nCTKln4Xf+ys8YliwRUKAENu48jpCWTujz3Q5h DYETGAMnOGnxAovISZ/KsCN3VVxgux3m7jtSBeN8Z0PM7ywlKNTcrPFpwkvNLkxlcwG0 RZl5ZFG/K2bEtPM+QaRryVnwmY7hFT4wUb7ugENgkT7IoNJizhOUwl+IX2V7OAbJKWJg BnYIZ/L16Ewb4TjoO47SqRS/qxCZhtZo4owRhDW1U+T6EF+b4w5QkUzOR8pkLT/Zvffz jM+A== X-Gm-Message-State: APjAAAW046YVH7rAxndrXEkMW7dex6yC+tQ0GoTSmMMTB7jAgIKBsDlF MMmAB/C4S1Ta669+qM36ZTLSDmRsyng= X-Google-Smtp-Source: APXvYqxNn75hMAaCJ1jpFcmafiwhxLri/IS58/tcd+3wz/dmOLHmao7Ne2GaGubxykqyvpjg5+5S/w== X-Received: by 2002:a63:f5c:: with SMTP id 28mr117164632pgp.348.1578388550275; Tue, 07 Jan 2020 01:15:50 -0800 (PST) Received: from LAPTOPSRU0G1QL ([106.51.132.104]) by smtp.gmail.com with ESMTPSA id q11sm81156995pff.111.2020.01.07.01.15.49 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 07 Jan 2020 01:15:49 -0800 (PST) From: "Chatur Gopalkrishna" To: Subject: Unable to fork: Resource Unavailable Date: Tue, 7 Jan 2020 14:45:44 +0530 Message-ID: <007001d5c53b$0db0ca90$29125fb0$@ridenext.co.in> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0071_01D5C569.276B2970" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdXFMFRwdLlElrZJRG2ubw0fDP44Hw== Content-Language: en-in List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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

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--