From: Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.ca>
To: Alexander Lakhin <exclusion@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: RE: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
Date: Sat, 21 Oct 2023 15:38:41 +0000
Message-ID: <16e2bc6a6ebf4bd69bf81f6de135253d@cra-arc.gc.ca> (raw)
In-Reply-To: <b8ee2352-4866-b8ef-5d94-e267104bab37@gmail.com>
References: <18165-bf4f525cea6e51de@postgresql.org>
<3998077.1697840164@sss.pgh.pa.us>
<20231020225433.yhcw4qjbeixpgglh@awork3.anarazel.de>
<4019765.1697851177@sss.pgh.pa.us>
<CA+hUKG+W8cPyMpRNoao_bsKBH-2=1KM59sSPh-c3kA=TDyWeVw@mail.gmail.com>
<CA+hUKGJCQKTeAVDXRvsLeEwh=H2-NGoy7DaVcwxOsR9638ZniA@mail.gmail.com>
<CA+hUKG+gFC2LT7NW76k=EVJEUwa7nWgma=Y6hthzxQRW0JXQAg@mail.gmail.com>
<b8ee2352-4866-b8ef-5d94-e267104bab37@gmail.com>
You guys are good! I did set min_dynamic_shared_memory to 2 GB in the new config, which didn't exist on 11. I can set it to 0 and give it a try on Tuesday. Does 2 GB seem overkill? We have plenty of memory to go by.
dynamic_shared_memory_type = windows # the default is the first option
# supported by the operating system:
# posix
# sysv
# windows
# mmap
# (change requires restart)
min_dynamic_shared_memory = 2GB # (change requires restart)
Thanks!
Maxime
-----Original Message-----
From: Alexander Lakhin <exclusion@gmail.com>
Sent: October 21, 2023 2:30 AM
To: Thomas Munro <thomas.munro@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>; Boyer, Maxime (he/him | il/lui) <Maxime.Boyer@cra-arc.gc.ca>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
Hi Thomas,
21.10.2023 08:26, Thomas Munro wrote:
> And concretely this would be the fix, I think. But I don't have
> Windows, and for reasons I haven't fathomed I haven't yet managed to
> reproduce it by pushing a change of default min_dynamic_shared_memory
> to CI. Is there any chance that a Postgres hacker on Windows could
> confirm the above theory, and that the attached fixes it?
I've tried on master:
echo min_dynamic_shared_memory = 10MB >c:\temp\extra.config set TEMP_CONFIG=c:\temp\extra.config vcregress check
and got:
...
Installation complete.
# initializing database system by running initdb # postmaster failed, examine ".../src/test/regress/log/postmaster.log" for the reasonBail out!
>cat ../../../src/test/regress/log/postmaster.log
2023-10-20 23:12:46.110 PDT postmaster[3140] LOG: starting PostgreSQL 17devel, compiled by Visual C++ build 1928, 64-bit
2023-10-20 23:12:46.113 PDT postmaster[3140] LOG: listening on IPv6 address "::1", port 55312
2023-10-20 23:12:46.113 PDT postmaster[3140] LOG: listening on IPv4 address "127.0.0.1", port 55312
2023-10-20 23:12:46.129 PDT startup[6188] LOG: database system was shut down at 2023-10-20 23:12:41 PDT
2023-10-20 23:12:46.130 PDT startup[6188] FATAL: could not duplicate handle for "Global/PostgreSQL.753594369": Bad file descriptor
2023-10-20 23:12:46.132 PDT postmaster[3140] LOG: startup process (PID 6188) exited with exit code 1
2023-10-20 23:12:46.132 PDT postmaster[3140] LOG: aborting startup due to startup process failure
2023-10-20 23:12:46.132 PDT postmaster[3140] LOG: database system is shut down
With your patch applied, `vcregress check` passes just fine.
Best regards,
Alexander
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: Maxime.Boyer@cra-arc.gc.ca, exclusion@gmail.com, thomas.munro@gmail.com, tgl@sss.pgh.pa.us, andres@anarazel.de, pgsql-bugs@lists.postgresql.org
Subject: RE: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor
In-Reply-To: <16e2bc6a6ebf4bd69bf81f6de135253d@cra-arc.gc.ca>
* 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