Project

General

Profile

Actions

Bug #5990

closed

multiple calls to create or update domain throws deadlock error

Added by Thomas McKay over 10 years ago. Updated about 9 years ago.

Status:
Duplicate
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Running hammer-cli-csv w/ 6 threads against a 7 CPU server

```
E, [2014-05-29T13:48:16.720000 #2214] ERROR -- : 500 Internal Server Error {
"error" => {
"message" => "PGError: ERROR: deadlock detected\nDETAIL: Process 13511 waits for ShareLock on transaction 25358; blocked by process 13424.\nProcess 13424 waits for ExclusiveLock on tuple (0,31) of relation 18370 of database 17586; blocked by process 13511.\nHINT: See server log for query details.\n: UPDATE \"taxonomies\" SET \"updated_at\" = '2014-05-29 21:46:53.703727', \"ignore_types\" = '--- []\n', \"default_info\" = '---\nsystem: []\ndistributor: []\n' WHERE \"taxonomies\".\"type\" IN ('Organization') AND \"taxonomies\".\"id\" = 3"
}
}
```


Files

log.txt log.txt 19.5 KB Thomas McKay, 05/29/2014 05:52 PM
create_psauxww.txt create_psauxww.txt 15.6 KB Johan Sunnerstig, 07/04/2014 03:39 AM
create_trace.txt create_trace.txt 18.2 KB Johan Sunnerstig, 07/04/2014 03:39 AM
delete_psauxww.txt delete_psauxww.txt 19.7 KB Johan Sunnerstig, 07/04/2014 03:39 AM
delete_trace.txt delete_trace.txt 16.1 KB Johan Sunnerstig, 07/04/2014 03:39 AM

Related issues 1 (0 open1 closed)

Is duplicate of Foreman - Bug #10133: Massive db deadlocks in postgres from hosts_counter updates with counter_cache_fix.rbClosedTomer Brisker04/14/2015Actions
Actions

Also available in: Atom PDF