GNU bug report logs - #51942
cuirass postgresql deadlock

Message received at submit <at> debbugs.gnu.org:

Received: (at submit) by debbugs.gnu.org; 18 Nov 2021 10:17:43 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Thu Nov 18 05:17:43 2021
Received: from localhost ([127.0.0.1]:34875 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1mneUB-0004u4-45
	for submit <at> debbugs.gnu.org; Thu, 18 Nov 2021 05:17:43 -0500
Received: from lists.gnu.org ([209.51.188.17]:34938)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <othacehe@HIDDEN>) id 1mneU9-0004tv-QI
 for submit <at> debbugs.gnu.org; Thu, 18 Nov 2021 05:17:42 -0500
Received: from eggs.gnu.org ([209.51.188.92]:59108)
 by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <othacehe@HIDDEN>) id 1mneU9-0002H7-Ly
 for bug-guix@HIDDEN; Thu, 18 Nov 2021 05:17:41 -0500
Received: from [2001:470:142:3::e] (port=43594 helo=fencepost.gnu.org)
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <othacehe@HIDDEN>) id 1mneU9-0002or-DS
 for bug-guix@HIDDEN; Thu, 18 Nov 2021 05:17:41 -0500
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org;
 s=fencepost-gnu-org; h=MIME-Version:Date:Subject:To:From:in-reply-to:
 references; bh=/2bPSPAEYh1xvRThyypCWDuAhcC1I3/LZurYDMmCPBk=; b=UrzAl0di6cz1Js
 HQJ97CIVaolL8b2KHWqS98Vt7aknWSFKDYRnDZASZCUBCXdk939/JIYu4gJqxfaM2YmLywChYtVpV
 zl7dmOFyBCNAEDjB/LXULKAckV0l1zCfPzqNiq67l1kcD/oe+vsUuoInF8G4GTMEjygMsVkm+zvQV
 GUlB3MoiPMP+frFLSabn2+qEiLektHZ5t/Uh2CJ4ytXeX/g1nCFk6WoeXU31G2fomIxdH0BBr6MWn
 S4/I85HE1BoX28Ba/cUDZuQW2EIg8RvvcnAnWvtjB8kvskrladFpYqLlbwaqHxML/EJv0m6TId/Of
 PeYaIvtkEduydPV0ilZg==;
Received: from [2a01:e34:ecab:cd0:3d50:507c:1dec:edb1] (port=45308 helo=meije)
 by fencepost.gnu.org with esmtpsa
 (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1)
 (envelope-from <othacehe@HIDDEN>) id 1mneU9-0002HK-76
 for bug-guix@HIDDEN; Thu, 18 Nov 2021 05:17:41 -0500
From: Mathieu Othacehe <othacehe@HIDDEN>
To: bug-guix@HIDDEN
Subject: cuirass postgresql deadlock
Date: Thu, 18 Nov 2021 10:17:39 +0000
Message-ID: <87y25l6a4c.fsf@HIDDEN>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
X-Spam-Score: -2.3 (--)
X-Debbugs-Envelope-To: submit
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -3.3 (---)


Hello,

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

--8<---------------cut here---------------start------------->8---
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.
--8<---------------cut here---------------end--------------->8---

I'm not sure what can cause this issue.

Thanks,

Mathieu