Skip to content

Instantly share code, notes, and snippets.

@csschwe

csschwe/gist:4cc4d9be58e1cb96ec6c

Created April 14, 2015 13:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save csschwe/4cc4d9be58e1cb96ec6c to your computer and use it in GitHub Desktop.
Save csschwe/4cc4d9be58e1cb96ec6c to your computer and use it in GitHub Desktop.
Download ZIP
foreman errors with counter_cache_fix.rb
Raw
gistfile1.txt
ERROR: deadlock detected
DETAIL: Process 12111 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12208.
Process 12208 waits for ShareLock on transaction 4279180907; blocked by process 12095.
Process 12095 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12111.
Process 12111: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3
Process 12208: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3
Process 12095: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
HINT: See server log for query details.
STATEMENT: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3
ERROR: deadlock detected
DETAIL: Process 12047 waits for ShareLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12208.
Process 12208 waits for ShareLock on transaction 4279180907; blocked by process 12095.
Process 12095 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12047.
Process 12047: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:32.976230' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 244230
Process 12208: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3
Process 12095: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
HINT: See server log for query details.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."architectures" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
STATEMENT: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:32.976230' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 244230
ERROR: deadlock detected
DETAIL: Process 12095 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12208.
Process 12208 waits for ShareLock on transaction 4279180907; blocked by process 12095.
Process 12095: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
Process 12208: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3
HINT: See server log for query details.
STATEMENT: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
ERROR: deadlock detected
DETAIL: Process 12400 waits for ShareLock on transaction 4279186711; blocked by process 12208.
Process 12208 waits for ShareLock on transaction 4279186716; blocked by process 12420.
Process 12420 waits for ShareLock on tuple (1,3) of relation 16656 of database 16384; blocked by process 12400.
Process 12400: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
Process 12208: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
Process 12420: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:34.170445' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 244459
HINT: See server log for query details.
STATEMENT: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
ERROR: deadlock detected
DETAIL: Process 12420 waits for ShareLock on tuple (1,3) of relation 16656 of database 16384; blocked by process 12225.
Process 12225 waits for ShareLock on transaction 4279186711; blocked by process 12208.
Process 12208 waits for ShareLock on transaction 4279186716; blocked by process 12420.
Process 12420: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:34.170445' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 244459
Process 12225: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
Process 12208: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3
HINT: See server log for query details.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."environments" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
STATEMENT: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:34.170445' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 244459
ERROR: deadlock detected
DETAIL: Process 12256 waits for ShareLock on transaction 4279186757; blocked by process 12501.
Process 12501 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12256.
Process 12256: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12501: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12501 waits for ShareLock on transaction 4279186756; blocked by process 12225.
Process 12225 waits for ShareLock on tuple (1,17) of relation 16656 of database 16384; blocked by process 12129.
Process 12129 waits for ShareLock on transaction 4279186757; blocked by process 12501.
Process 12501: UPDATE "architectures" SET "hosts_count" = 12507 WHERE "architectures"."id" = 3
Process 12225: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:35.251565' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 247028
Process 12129: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
HINT: See server log for query details.
STATEMENT: UPDATE "architectures" SET "hosts_count" = 12507 WHERE "architectures"."id" = 3
ERROR: deadlock detected
DETAIL: Process 12225 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 11923.
Process 11923 waits for ShareLock on transaction 4279186756; blocked by process 12225.
Process 12225: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 11923: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 11923 waits for ShareLock on transaction 4279186760; blocked by process 12145.
Process 12145 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 11923.
Process 11923: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12145: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 11991 waits for ShareLock on transaction 4279186760; blocked by process 12145.
Process 12145 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 11991.
Process 11991: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12145: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12145 waits for ShareLock on transaction 4279186765; blocked by process 11951.
Process 11951 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12145.
Process 12145: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 11951: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 11951 waits for ShareLock on transaction 4279186767; blocked by process 11967.
Process 11967 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 11951.
Process 11951: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 11967: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12153 waits for ShareLock on transaction 4279186767; blocked by process 11967.
Process 11967 waits for ShareLock on transaction 4279186759; blocked by process 12452.
Process 12452 waits for ShareLock on tuple (1,18) of relation 16656 of database 16384; blocked by process 12153.
Process 12153: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
Process 11967: UPDATE "architectures" SET "hosts_count" = 12507 WHERE "architectures"."id" = 3
Process 12452: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:35.254402' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 243174
HINT: See server log for query details.
STATEMENT: UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name)
ERROR: deadlock detected
DETAIL: Process 11967 waits for ShareLock on transaction 4279186759; blocked by process 12452.
Process 12452 waits for ShareLock on transaction 4279186767; blocked by process 11967.
Process 11967: UPDATE "architectures" SET "hosts_count" = 12507 WHERE "architectures"."id" = 3
Process 12452: UPDATE "hosts" SET "model_id" = 1, "architecture_id" = 3, "operatingsystem_id" = 5, "environment_id" = 1, "updated_at" = '2015-04-14 13:03:35.254402' WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 243174
HINT: See server log for query details.
STATEMENT: UPDATE "architectures" SET "hosts_count" = 12507 WHERE "architectures"."id" = 3
ERROR: deadlock detected
DETAIL: Process 11907 waits for ShareLock on transaction 4279186759; blocked by process 12452.
Process 12452 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 11907.
Process 11907: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12452: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12283 waits for ShareLock on transaction 4279186759; blocked by process 12452.
Process 12452 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12283.
Process 12283: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12452: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12264 waits for ShareLock on transaction 4279186759; blocked by process 12452.
Process 12452 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12264.
Process 12264: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12452: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12452 waits for ShareLock on transaction 4279186764; blocked by process 12471.
Process 12471 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12452.
Process 12452: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Process 12471: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
HINT: See server log for query details.
STATEMENT: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
ERROR: deadlock detected
DETAIL: Process 12129 waits for ShareLock on transaction 4279186764; blocked by process 12471.
Process 12471 waits for ExclusiveLock on tuple (2,30) of relation 16645 of database 16384; blocked by process 12129.
Process 12129: UPDATE "models" SET "hosts_count" = 12507 WHERE "models"."id" = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment