| From: | Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: locks problem |
| Date: | 2012-11-27 10:01:00 |
| Message-ID: | CABnqL33P8G4RafZTMu1zGBP8MZ_KPjp=Ns=aqnfkHYwKa7CRBQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Ok I figured it out. I had a prepared transaction holding the locks. The
pg_prepared_xacts was helpful.
27-11-2012 10:27, "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com> napisał(a):
> Hi list,
>
> I've got a locking problem which prevents me from doing some alters on my
> tables. When I looked into pg_locks I saw a lot of entries (around 1000)
> with pid being NULL and almost all of them are AccessShare. Can anyone tell
> me what might those be and how do I get rid of them ?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ssylla | 2012-11-27 10:13:51 | select on many-to-many relationship |
| Previous Message | ssylla | 2012-11-27 09:59:54 | output query on many to many relationship into several columns |