From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id 6NGVGbZdnmN4XQEAbAwnHQ (envelope-from ) for ; Sun, 18 Dec 2022 01:24:22 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id uGGvGLZdnmMaLAEAG6o9tA (envelope-from ) for ; Sun, 18 Dec 2022 01:24:22 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 25C062F8C1 for ; Sun, 18 Dec 2022 01:24:22 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1p6hTH-0005Rn-Hw; Sat, 17 Dec 2022 19:24:03 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1p6hTG-0005RH-6u for bug-guix@gnu.org; Sat, 17 Dec 2022 19:24:02 -0500 Received: from debbugs.gnu.org ([209.51.188.43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1p6hTF-0004Df-U7 for bug-guix@gnu.org; Sat, 17 Dec 2022 19:24:01 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1p6hTF-0003sU-PO for bug-guix@gnu.org; Sat, 17 Dec 2022 19:24:01 -0500 X-Loop: help-debbugs@gnu.org Subject: bug#59784: [version 1.4.0rc1] Retrying a failed install fails Resent-From: Ludovic =?UTF-8?Q?Court=C3=A8s?= Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Sun, 18 Dec 2022 00:24:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 59784 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: "pelzflorian (Florian Pelz)" Cc: Mathieu Othacehe , 59784@debbugs.gnu.org Received: via spool by 59784-submit@debbugs.gnu.org id=B59784.167132301114885 (code B ref 59784); Sun, 18 Dec 2022 00:24:01 +0000 Received: (at 59784) by debbugs.gnu.org; 18 Dec 2022 00:23:31 +0000 Received: from localhost ([127.0.0.1]:58819 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1p6hSk-0003rz-NA for submit@debbugs.gnu.org; Sat, 17 Dec 2022 19:23:31 -0500 Received: from eggs.gnu.org ([209.51.188.92]:48734) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1p6hSi-0003rp-IE for 59784@debbugs.gnu.org; Sat, 17 Dec 2022 19:23:29 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1p6hSc-0004A4-JP; Sat, 17 Dec 2022 19:23:22 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-Version:In-Reply-To:Date:References:Subject:To: From; bh=JROzbPBs6F9z+BDqYg6g5dK8KMaEU/DmzL1MgSajl+M=; b=kXLJovl2u7F8GJ9zNuir 5ADuUZgid8BKkk2IcOn1vhjk0mbcor4cYloY1PsuHju8O/8eXHWKE2rWMFRTFbTB0w8c6GLRt71yl rJ8sFjj7AVmq9FgzhyJmaX+0QueJDcvGSBDj/9DBCeP5mVCWMD6uFBerJmK0plfIl1m2a4TBChTtR MdnEwvsCptnh4iP3SaKxr5usn3wZhjKe505lSYAKcfDNLG2WzsWlq1H8jPmg/2deWb3V1A/A+6qSa UPDNjM3xFq6pEOMD3kzZnYiYqRrDHVtVBOer4lZvtqzysJcZy10ug+An9jqI0WKtkoDjwmbT68YSZ jlA34xcmdkEQsQ==; Received: from [2a01:e0a:1d:7270:af76:b9b:ca24:c465] (helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1p6hSb-000840-TX; Sat, 17 Dec 2022 19:23:22 -0500 From: Ludovic =?UTF-8?Q?Court=C3=A8s?= References: <87y1rpy9p4.fsf@pelzflorian.de> <87mt7wap6v.fsf@gnu.org> <87y1rf649x.fsf@pelzflorian.de> <87pmcny73z.fsf@gnu.org> <87k02vy6pw.fsf@gnu.org> <87ilifeyg1.fsf@pelzflorian.de> <87h6xyvqr6.fsf@gnu.org> <878rja150v.fsf@pelzflorian.de> <87h6xxpsil.fsf@pelzflorian.de> <87sfhhr1du.fsf@gnu.org> <871qp05zmf.fsf@pelzflorian.de> <87v8mcz9ai.fsf@pelzflorian.de> <87pmcji8wn.fsf@gnu.org> <87v8magg6e.fsf@gnu.org> <87zgblhlu8.fsf@pelzflorian.de> <87len5hg5h.fsf@gnu.org> Date: Sun, 18 Dec 2022 01:23:18 +0100 In-Reply-To: <87len5hg5h.fsf@gnu.org> ("Ludovic =?UTF-8?Q?Court=C3=A8s?="'s message of "Sat, 17 Dec 2022 22:30:34 +0100") Message-ID: <87cz8hh85l.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: bug-guix-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gnu.org header.s=fencepost-gnu-org header.b=kXLJovl2; spf=pass (aspmx1.migadu.com: domain of "bug-guix-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="bug-guix-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gnu.org ARC-Seal: i=1; s=key1; d=yhetil.org; t=1671323062; a=rsa-sha256; cv=none; b=qRSaJua9jcvuk4wjHpoM5S0HPj3oOeeXqHkVnYr5h6+H5PQRaY++6hHOAbFCLFtndxIzJs xxCe3NRIhKZEmjzAvoLlcVBqyun7BN2jHKVR/hOzGhY7rxW3Bh4r7xVdNaVkXNppURP1ab 2++wDCpAXs/SyrhcmOPn7kGwcxnUYVQT6aTrT1/Lywe6GYAcNK+fS2UUnAOs4IPbW+s3T3 XJ9loQ1hfZEZx+GyL9/5jHPjXBGhL1p0M6RAUlLBb8AScqb/lmB0r+H7+1zlMZBC2e2IqI dDfifxCMfollIxasKg9mz85nSNExz5roa6Av3IlQozV8Q0zXygyvJ4NsgVLrIQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1671323062; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding:resent-cc: resent-from:resent-sender:resent-message-id:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=JROzbPBs6F9z+BDqYg6g5dK8KMaEU/DmzL1MgSajl+M=; b=WuiYgOYYNucGse115XMza2OmTQlncsn7q0lNmNn4b2ldTqeCRyv0L0mFn34ceZs8qt21O2 vstZ2ubLBQHVM4EtcZLZqso00DVfAyNf57xUySmh4/V71ftm8DqWkCtUg1mUxZymoCHWW1 qOxPCUKXm+CbzO3gHCNQOmQeK8sk/Vm2YRndZ9GBsRskV52VF9KQT3oSsGOIlpGKE/hWfA Pj65V0aEZ5kg0VK3/12mMNWaPixIy+2uJay5+Du/ycYq45hiQhqxvuHg15l05EUmzwzYqW UejB+c/MUOTomI8RLL+k1bHdv1VDQKNemDSvxCxQpv6FEGdMzU1KLqlUZxN+vw== X-Migadu-Scanner: scn0.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gnu.org header.s=fencepost-gnu-org header.b=kXLJovl2; spf=pass (aspmx1.migadu.com: domain of "bug-guix-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="bug-guix-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gnu.org X-Migadu-Spam-Score: -3.77 X-Spam-Score: -3.77 X-Migadu-Queue-Id: 25C062F8C1 X-TUID: NAIVJtk8gx84 After spending a few more hours on this, I got convinced that upon restarting guix-daemon, even though we had restored /var/guix/db/db.sqlite, the presence of stale db.sqlite-{wal,shm} files could lead sqlite to do as if transactions in the WAL file had been committed. Commit 495c50008be91429ebea3805e161a1e385a2a572 deletes these two files, and it appears to solve the problem for me. I also pushed the patch previously shared in this thread, to make sure db.sqlite is only copied when guix-daemon is stopped. So we have this: 495c50008b installer: final: Delete SQLite WAL and shm files upon complet= ion. 9b6703eabe installer: final: Stop guix-daemon before accessing store data= base. I=E2=80=99ll go ahead and prepare for the release as planned, to be publish= ed on Monday. Ludo=E2=80=99.