Warning: you don't own a lock of type ExclusiveLock - Mailing list pgsql-general

From Gary Chambers
Subject Warning: you don't own a lock of type ExclusiveLock
Date
Msg-id alpine.DEB.2.00.1202031614350.32328@lollipop.garychambers.com
Whole thread Raw
Responses Re: Warning: you don't own a lock of type ExclusiveLock
List pgsql-general
All,

I have a recently-migrated Pg cluster running 8.4.7 on Red Hat Enterprise
Linux Client release 5.7 (Tikanga) in a VMware VM that is logging the
subject warning.  The application code is considerably old (deployed back in
the 7.4 days, I believe) and the message is preceded by a call to select
user_write_unlock(), which is a simple wrapper query that calls
pg_advisory_unlock().  What are the causes and possible problems and
side-effects of receiving such a log warning?  Thank you for any assistance
you can provide.

--
Gary Chambers

pgsql-general by date:

Previous
From: Christopher Opena
Date:
Subject: Re: Puzzling full database lock
Next
From: Chris Angelico
Date:
Subject: Re: Warning: you don't own a lock of type ExclusiveLock