shared memory release following failed lock acquirement. - Mailing list pgsql-hackers

From Merlin Moncure
Subject shared memory release following failed lock acquirement.
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A74D3@Herge.rcsinc.local
Whole thread Raw
Responses Re: shared memory release following failed lock acquirement.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

I noticed your recent corrections to lock.c regarding the releasing of
locks in an out of shared memory condition.  This may or may not be
relevant, but when I purposefully use up all the lock space with user
locks, the server runs out of shared memory and stays out until it is
restarted (not when the backend shuts down as it is supposed to).

In other words, after doing a select user_write_lock_oid(t.oid) from
big_table t;

It's server restart time.

What's really interesting about this is that the pg_locks view (after
the offending disconnects) reports nothing out of the ordinary even
though no backends can acquire locks after that point.

Merlin





pgsql-hackers by date:

Previous
From: Shachar Shemesh
Date:
Subject: type unknown - how important is it?
Next
From: Tom Lane
Date:
Subject: Re: shared memory release following failed lock acquirement.