From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: maxime.boyer@cra-arc.gc.ca
Subject: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106
Date: Tue, 24 Oct 2023 19:40:41 +0000
Message-ID: <18168-ed449e75cefb972a@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18168
Logged by: Maxime Boyer
Email address: maxime.boyer@cra-arc.gc.ca
PostgreSQL version: 11.17
Operating system: Windows Server 2019
Description:
This error happened in PostgreSQL 11.17, slightly more than 12 hours after
startup. I believe it's the first time this happens.
New firmware were installed on the server, this happened after restarting
the server. Since then, the database runs on a secondary server without
issue. That server received the same updates. We haven't tried moving it
back as this is our production database. Was this a fluke?
Looking online, the error code seems to refer to Windows sockets, with most
pages from the Windows XP era.
Startup: Oct 17 @ 11:40:20 PM
Shutdown: Oct 18 @ 11:43:15 PM
83 identical errors were logged in the system Event Viewer:
could not create inherited socket: error code 10106
Normal log until then. The application was running normally.
Server:
Windows Server 2019 Standard 64-bit
Microsoft Visual C++ 2015-2022 Redistributable (x64) - 14.36.32532
HP ProLiant BL460c Gen9
Intel Xeon CPU E5-2620 v4 @ 2.10 GHz (32 CPUs)
128 GB RAM
Logs:
2023-10-18 11:43:15.658 EDT,,,8164,,652f53a2.1fe4,3,,2023-10-17 23:40:18
EDT,,0,LOG,00000,"background worker ""parallel worker"" (PID 9740) exited
with exit code 1",,,,,,,,"LogChildExit,
d:\pginstaller.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:3590",""
2023-10-18 11:43:15.680 EDT,,,8164,,652f53a2.1fe4,4,,2023-10-17 23:40:18
EDT,,0,LOG,00000,"background worker ""parallel worker"" (PID 9516) exited
with exit code 1",,,,,,,,"LogChildExit,
d:\pginstaller.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:3590",""
2023-10-18 11:43:16.129
EDT,"dbuser","database",808,"app_node_ip:53838",652ff955.328,3,"",2023-10-18
11:27:17 EDT,43/1242715,0,ERROR,55000,"parallel worker failed to
initialize",,"More details may be available in the server log.",,,,"SELECT
COUNT(I.ID) FROM public.jiraissue I WHERE (I.ARCHIVED = $1 ) OR (I.ARCHIVED
IS NULL )",,"WaitForParallelWorkersToFinish,
d:\pginstaller.auto\postgres.windows-x64\src\backend\access\transam\parallel.c:799","PostgreSQL
JDBC Driver"
2023-10-18 11:43:21.476 EDT,,,8164,,652f53a2.1fe4,5,,2023-10-17 23:40:18
EDT,,0,LOG,00000,"received fast shutdown request",,,,,,,,"pmdie,
d:\pginstaller.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:2722",""
2023-10-18 11:43:21.478 EDT,,,8164,,652f53a2.1fe4,6,,2023-10-17 23:40:18
EDT,,0,LOG,00000,"aborting any active transactions",,,,,,,,"pmdie,
d:\pginstaller.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:2740",""
Thank you,
Maxime
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, maxime.boyer@cra-arc.gc.ca
Subject: Re: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106
In-Reply-To: <18168-ed449e75cefb972a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox