| From: | "Carlos Oliva" <carlos(at)pbsinet(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | ExclusiveLock without a relation in pg_locks |
| Date: | 2006-02-23 13:54:36 |
| Message-ID: | 200602231355.IAA13665@pbsi.pbsinet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Would connections to a database require crating an extra ExclusiveLock? We
have some connections to the database that happen to be "idle in
transaction" and their pids have a granted "Exclusive Lock" in pg_locks. I
cannot discern the tables where the ExclusiveLock is being held because the
relation field is blank.
Moreover, there are other connections to the database coming from the same
ip address as that of the connection with the ExclusiveLock. Some of the
pids of these other connections seem to have different kinds of locks
(AccessShareL0ck) so I am not quite sure why the pids with the
ExclusiveLock's are necessary.
How could I find out the tables that are being locked when I see an
"ExclusiveLock" in pg_locks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pobox@verysmall.org | 2006-02-23 14:21:06 | upgrade PostgreSQL 8.x on production FreeBSD |
| Previous Message | Ragnar | 2006-02-23 13:47:13 | Re: Is there a way to check which indexes are being used |