Horton

Re: BUG #18165: Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file descriptor

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: maxime.boyer@cra-arc.gc.ca
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-10-20T22:16:04Z
Lists: pgsql-bugs 
PG Bug reporting form <noreply@postgresql.org> writes:
> Could not duplicate handle for "Global/PostgreSQL.xxxxxxxxxx": Bad file
> descriptor

That must be coming from dsm_impl_pin_segment or dsm_impl_unpin_segment;
noplace else has the same error message spelling.

> Error started after a pg_upgrade from 11.17 to 14.9 on the same physical
> servers.

Both those messages predate v11, so it's hard to tell what changed.
Are you sure the OS environment didn't change too?

			regards, tom lane

Commits

  1. Fix min_dynamic_shared_memory on Windows.

  2. Fix huge_pages on Windows

  3. Preallocate some DSM space at startup.