BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106
От | PG Bug reporting form |
---|---|
Тема | BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106 |
Дата | |
Msg-id | 18168-ed449e75cefb972a@postgresql.org обсуждение исходный текст |
Ответы |
RE: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106
Re: BUG #18168: Parallel worker failed to initialize: could not create inherited socket: error code 10106 |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: