RE: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106 - Mailing list pgsql-bugs

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

-----Original Message-----
From: PG Bug reporting form <noreply@postgresql.org> 
Sent: October 24, 2023 3:41 PM
To: pgsql-bugs@lists.postgresql.org
Cc: Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.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
recognizethe sender and believe the content is safe. For more information regarding reporting suspicious emails, please
visitthe 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
surla façon de signaler les courriels suspects, veuillez consulter la page Web SavoirFaire: Courriels suspects –
Commentsignaler<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.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
asecondary server without issue. That server received the same updates. We haven't tried moving it back as this is our
productiondatabase. 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.10GHz (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
serverlog.",,,,"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