Warning: you don't own a lock of type ExclusiveLock

From: Gary Chambers <gwchamb(at)gwcmail(dot)com>
To: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Warning: you don't own a lock of type ExclusiveLock
Date: 2012-02-03 21:27:53
Message-ID: alpine.DEB.2.00.1202031614350.32328@lollipop.garychambers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo E. De León Plicet 2012-02-04 01:53:15 Re: Don't Thread On Me (PostgreSQL related)
Previous Message Christopher Opena 2012-02-03 20:55:37 Re: Puzzling full database lock