bug#51942: cuirass postgresql deadlock

[Ludovic Courtès]

Hey!

Mathieu Othacehe <othacehe@gnu.org> skribis:

> 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’.