cuirass postgresql deadlock

  • Done
  • quality assurance status badge
Details
2 participants
  • Ludovic Courtès
  • Mathieu Othacehe
Owner
unassigned
Submitted by
Mathieu Othacehe
Severity
normal
M
M
Mathieu Othacehe wrote on 18 Nov 2021 11:17
(address . bug-guix@gnu.org)
87y25l6a4c.fsf@gnu.org
Hello,

I observed the following deadlock on the cuirass-remote-server log file
on berlin:

Toggle snippet (11 lines)
2021-11-17T23:12:00 fetching '/gnu/store/g6iqlblaxyvlvycrri110kfli9vhm8s0-julia-mlstyle-0.4.10.drv' from http://141.80.167.159:5558
2021-12-17T23:12:03 build succeeded: '/gnu/store/g6iqlblaxyvlvycrri110kfli9vhm8s0-julia-mlstyle-0.4.10In ice-9/eval.scm:
619:8 2 (_ #(#(#<directory (cuirass scripts remote-server) ?> ?)))
298:42 1 (_ #(#(#<directory (cuirass scripts remote-server) ?> ?)))
In ice-9/boot-9.scm:
1685:16 0 (raise-exception _ #:continuable? _)
ice-9/boot-9.scm:1685:16: In procedure raise-exception:
Throw to key `psql-query-error' with args `(fatal-error "PGRES_FATAL_ERROR" "ERROR: deadlock detected\nDETAIL: Process 485 waits for ShareLock on transaction 760005012; blocked by process 17350.\nProcess 17350 waits for ShareLock on transaction 760004811; blocked by process 485.\nHINT: See server log for query details.\nCONTEXT: while rechecking updated tuple (31499,8) in relation \"builds\"\n")'.
2021-11-17T23:13:52 Poll loop busy during 109 seconds.

I'm not sure what can cause this issue.

Thanks,

Mathieu
L
L
Ludovic Courtès wrote on 14 Jul 23:55 +0200
(name . Mathieu Othacehe)(address . othacehe@gnu.org)(address . 51942-done@debbugs.gnu.org)
8734oby6xm.fsf@gnu.org
Hey!

Mathieu Othacehe <othacehe@gnu.org> skribis:

Toggle quote (12 lines)
> I observed the following deadlock on the cuirass-remote-server log file
> on berlin:
>
> 2021-11-17T23:12:00 fetching '/gnu/store/g6iqlblaxyvlvycrri110kfli9vhm8s0-julia-mlstyle-0.4.10.drv' from http://141.80.167.159:5558
> 2021-12-17T23:12:03 build succeeded: '/gnu/store/g6iqlblaxyvlvycrri110kfli9vhm8s0-julia-mlstyle-0.4.10In ice-9/eval.scm:
> 619:8 2 (_ #(#(#<directory (cuirass scripts remote-server) ?> ?)))
> 298:42 1 (_ #(#(#<directory (cuirass scripts remote-server) ?> ?)))
> In ice-9/boot-9.scm:
> 1685:16 0 (raise-exception _ #:continuable? _)
> ice-9/boot-9.scm:1685:16: In procedure raise-exception:
> Throw to key `psql-query-error' with args `(fatal-error "PGRES_FATAL_ERROR" "ERROR: deadlock detected\nDETAIL: Process 485 waits for ShareLock on transaction 760005012; blocked by process 17350.\nProcess 17350 waits for ShareLock on transaction 760004811; blocked by process 485.\nHINT: See server log for query details.\nCONTEXT: while rechecking updated tuple (31499,8) in relation \"builds\"\n")'.

I haven’t see that in the past year or two. Closing!

Ludo’.
Closed
?
Your comment

Commenting via the web interface is currently disabled.

To comment on this conversation send an email to 51942@debbugs.gnu.org

To respond to this issue using the mumi CLI, first switch to it
mumi current 51942
Then, you may apply the latest patchset in this issue (with sign off)
mumi am -- -s
Or, compose a reply to this issue
mumi compose
Or, send patches to this issue
mumi send-email *.patch