| From: | Milos Findura <milos(dot)findura(at)lmc(dot)eu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | deadlock problem |
| Date: | 2009-03-19 09:12:26 |
| Message-ID: | 200903191012.26405.milos.findura@lmc.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hi,
I found a deadlock on 2 queries, DELETE and REINDEX TABLE
DELETE waits for RowExclusiveLock on table address_jd
and
REINDEX waits for AccessExclusiveLock on PRIMARY KEY address_jd_pk
log:
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-1]
host=10.0.5.144,user=ppstat,db=ppstat ERROR: deadlock detected
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-2]
host=10.0.5.144,user=ppstat,db=ppstat DETAIL: Process 25576 waits for
RowExclusiveLock on relation 16613 of database 16388;
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-3] blocked by process 26649.
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-4] Process 26649 waits
for AccessExclusiveLock on relation 17776 of database 16388; blocked by
process 25576.
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-5]
host=10.0.5.144,user=ppstat,db=ppstat CONTEXT: SQL statement "DELETE FROM
dsa_nas.address_jd WHERE exp_id = 7"
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-6] PL/pgSQL
function "delete_export" line 16 at EXECUTE statement
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-7] SQL statement "SELECT
transform_functions.delete_export('dsa_nas', $1 )"
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-8] PL/pgSQL
function "transform_nas" line 152 at PERFORM
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-9]
host=10.0.5.144,user=ppstat,db=ppstat STATEMENT: SELECT
transform_functions.transform_nas(7)
Mar 19 00:30:57 ch08bl09 postgres[26649]: [3-1]
host=[local],user=postgres,db=ppstat LOG: duration: 865522.949 ms
statement: REINDEX TABLE dsa_nas.address_jd
where can be problem?
thanks,
tashunko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Milos Findura | 2009-03-19 09:13:43 | deadlock problem |
| Previous Message | Edoardo Panfili | 2009-03-19 06:34:50 | Re: ORDER BY: lexicographic ordering of names |