Skip to content

Instantly share code, notes, and snippets.

@eduherraiz
Created November 18, 2015 15:34
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 eduherraiz/412c9abe87cc9114cd77 to your computer and use it in GitHub Desktop.
Save eduherraiz/412c9abe87cc9114cd77 to your computer and use it in GitHub Desktop.
deadlock zulip
2015-11-18 15:11:07.033 GMT [564c9379.4621]: [2-1] LOG: process 17953 still waiting for ShareLock on transaction 1100010 after 1000.076 ms
2015-11-18 15:11:07.033 GMT [564c9379.4621]: [3-1] STATEMENT: UPDATE "zerver_usermessage" SET "flags" = ("zerver_usermessage"."flags" | 1) WHERE ("zerver_usermessage"."message_id" IN (6341, 6342, 6343) AND "zerver_usermessage"."user_profile_id" = 14 AND "zerver_usermessage"."flags" | -2 = -2)
2015-11-18 15:11:28.918 GMT [564c92d4.43b2]: [1-1] LOG: process 17330 still waiting for ShareLock on transaction 1100011 after 1000.121 ms
2015-11-18 15:11:28.919 GMT [564c92d4.43b2]: [2-1] STATEMENT: UPDATE "django_session" SET "session_data" = 'NmRmMjYxYTM1MzVhZTE1OTRlNzlmZTg0MzE0YjI5OWY2OTllOGNhMjp7Il9hdXRoX3VzZXJfaGFzaCI6IjRkOGRlYWMxMWY5MWM5ZWNlNjhlNjc1ZGE5NWI2NTQzYTZjZjhhNjQiLCJfYXV0aF91c2VyX2lkIjoiMTQiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ6cHJvamVjdC5iYWNrZW5kcy5FbWFpbEF1dGhCYWNrZW5kIn0=', "expire_date" = '2015-12-02T15:11:27.917714+00:00'::timestamptz WHERE "django_session"."session_key" = '94g6szckfxw1aynrhttmhr6sgkvnco41'
2015-11-18 15:19:55.172 GMT [564c971a.5425]: [1-1] LOG: process 21541 still waiting for ShareLock on transaction 1100018 after 1000.093 ms
2015-11-18 15:19:55.172 GMT [564c971a.5425]: [2-1] STATEMENT: UPDATE "zerver_userprofile" SET "last_reminder" = NULL WHERE "zerver_userprofile"."id" = 7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment