RE: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106

Correction, shutdown time was Oct 18 @ 11:43:15 AM

-----Original Message-----
From: PG Bug reporting form <noreply(at)postgresql(dot)org>
Sent: October 24, 2023 3:41 PM
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Boyer, Maxime (he/him | il/lui) <Maxime(dot)Boyer(at)cra-arc(dot)gc(dot)ca>
Subject: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106

***ATTENTION***

This email originated from outside of the Government of Canada. Do not click links or open attachments unless you recognize the sender and believe the content is safe. For more information regarding reporting suspicious emails, please visit the KnowHow webpage: Suspicious emails - how to report<http://druid/KnowHow/sec-suseml-e.asp>

Ce courriel provient de l'extérieur du Gouvernement du Canada. Ne cliquez pas sur les liens et n’ouvrez pas les pièces jointes, à moins de connaître l'expéditeur et croire que le contenu est sécuritaire. Pour de plus amples renseignements sur la façon de signaler les courriels suspects, veuillez consulter la page Web SavoirFaire: Courriels suspects – Comment signaler<http://druid/savoirfaire/sec-suseml-f.asp>

The following bug has been logged on the website:

Bug reference: 18168
Logged by: Maxime Boyer
Email address: maxime(dot)boyer(at)cra-arc(dot)gc(dot)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