Skip site navigation (1) Skip section navigation (2)

Re: Postgres Hanging on Inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: akavan(at)cox(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Hanging on Inserts
Date: 2003-07-30 14:25:21
Message-ID: 9546.1059575121@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Adam Kavan <akavan(at)cox(dot)net> writes:
> I looked into pg_locks and they are all waiting to get an exclusive
> lock on the same relation.  Is there anyway for me to tell what this
> relation is?

To decipher the OIDs in pg_locks, join against pg_class.oid, or just do
	select relname from pg_class where oid = nnnn;

> Does anyone know what it could be and how I can fix this
> problem?

Look for the process that already has a lock on the same relation, and
find out what it's waiting for.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: scott.marloweDate: 2003-07-30 14:25:31
Subject: Re: Basic questions before start
Previous:From: Tim McAuleyDate: 2003-07-30 14:06:05
Subject: Re: Unused Indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group