X-Loop: help-debbugs@HIDDEN
Subject: bug#51942: cuirass postgresql deadlock
Resent-From: Mathieu Othacehe <othacehe@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-guix@HIDDEN
Resent-Date: Thu, 18 Nov 2021 10:18:02 +0000
Resent-Message-ID: <handler.51942.B.163723066318856 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
X-GNU-PR-Message: report 51942
X-GNU-PR-Package: guix
X-GNU-PR-Keywords:
To: 51942 <at> debbugs.gnu.org
X-Debbugs-Original-To: bug-guix@HIDDEN
Received: via spool by submit <at> debbugs.gnu.org id=B.163723066318856
(code B ref -1); Thu, 18 Nov 2021 10:18:02 +0000
Received: (at submit) by debbugs.gnu.org; 18 Nov 2021 10:17:43 +0000
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>
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-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
Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) Content-Type: text/plain; charset=utf-8 X-Loop: help-debbugs@HIDDEN From: help-debbugs@HIDDEN (GNU bug Tracking System) To: Mathieu Othacehe <othacehe@HIDDEN> Subject: bug#51942: Acknowledgement (cuirass postgresql deadlock) Message-ID: <handler.51942.B.163723066318856.ack <at> debbugs.gnu.org> References: <87y25l6a4c.fsf@HIDDEN> X-Gnu-PR-Message: ack 51942 X-Gnu-PR-Package: guix Reply-To: 51942 <at> debbugs.gnu.org Date: Thu, 18 Nov 2021 10:18:02 +0000 Thank you for filing a new bug report with debbugs.gnu.org. This is an automatically generated reply to let you know your message has been received. Your message is being forwarded to the package maintainers and other interested parties for their attention; they will reply in due course. Your message has been sent to the package maintainer(s): bug-guix@HIDDEN If you wish to submit further information on this problem, please send it to 51942 <at> debbugs.gnu.org. Please do not send mail to help-debbugs@HIDDEN unless you wish to report a problem with the Bug-tracking system. --=20 51942: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D51942 GNU Bug Tracking System Contact help-debbugs@HIDDEN with problems
GNU bug tracking system
Copyright (C) 1999 Darren O. Benham,
1997 nCipher Corporation Ltd,
1994-97 Ian Jackson.