search

genome / ptero-workflow

Client-facing API for the PTero system
1 stars 6 forks source link

Deadlock detected while deleting workflow #260

Open mkiwala opened 8 years ago

mkiwala commented 8 years ago

---

2016-04-05 20:52:26 CDT ERROR: deadlock detected

2016-04-05 20:52:26 CDT DETAIL: Process 27469 waits for ShareLock on transaction 73998550; blocked by process 27477.

   Process 27477 waits for ShareLock on transaction 73998551; blocked by process 27469.

   Process 27469: DELETE FROM workflow WHERE workflow.id = 461761

   Process 27477: INSERT INTO execution_status_history (execution_id, timestamp, status, workflow_id) VALUES (7397831, now(), 'succeeded', 461761) RETURNING execution_status_history.id

2016-04-05 20:52:26 CDT HINT: See server log for query details.

2016-04-05 20:52:26 CDT CONTEXT: SQL statement "DELETE FROM ONLY "public"."execution" WHERE $1 OPERATOR(pg_catalog.=) "workflow_id""

2016-04-05 20:52:26 CDT STATEMENT: DELETE FROM workflow WHERE workflow.id = 461761