From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id cHDzFyXN8V7ZDwAA0tVLHw (envelope-from ) for ; Tue, 23 Jun 2020 09:36:37 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id eNzdEyXN8V7LRgAAbx9fmQ (envelope-from ) for ; Tue, 23 Jun 2020 09:36:37 +0000 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 AC1AB940A68 for ; Tue, 23 Jun 2020 09:36:36 +0000 (UTC) Received: from localhost ([::1]:51980 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jnfM2-0000A3-HW for larch@yhetil.org; Tue, 23 Jun 2020 05:36:34 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:60372) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jnfJa-0004KS-Oc for bug-guix@gnu.org; Tue, 23 Jun 2020 05:34:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:52150) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jnfJa-0001mZ-Ej for bug-guix@gnu.org; Tue, 23 Jun 2020 05:34:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1jnfJa-0006Ed-BT for bug-guix@gnu.org; Tue, 23 Jun 2020 05:34:02 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#42001: =?UTF-8?Q?=E2=80=9CSQLite?= database is =?UTF-8?Q?busy=E2=80=9D:?= contention on the store database Resent-From: Ludovic =?UTF-8?Q?Court=C3=A8s?= Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 23 Jun 2020 09:34:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 42001 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 42001@debbugs.gnu.org Received: via spool by 42001-submit@debbugs.gnu.org id=B42001.159290481123925 (code B ref 42001); Tue, 23 Jun 2020 09:34:02 +0000 Received: (at 42001) by debbugs.gnu.org; 23 Jun 2020 09:33:31 +0000 Received: from localhost ([127.0.0.1]:35463 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jnfJ1-0006Dk-An for submit@debbugs.gnu.org; Tue, 23 Jun 2020 05:33:31 -0400 Received: from eggs.gnu.org ([209.51.188.92]:45750) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jnfIy-0006DW-Af for 42001@debbugs.gnu.org; Tue, 23 Jun 2020 05:33:26 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:58926) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jnfIt-0001XH-2Q for 42001@debbugs.gnu.org; Tue, 23 Jun 2020 05:33:19 -0400 Received: from [2a01:e0a:1d:7270:af76:b9b:ca24:c465] (port=52832 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1jnfIs-0006C6-Fu for 42001@debbugs.gnu.org; Tue, 23 Jun 2020 05:33:18 -0400 From: Ludovic =?UTF-8?Q?Court=C3=A8s?= References: <877dvz7228.fsf@gnu.org> Date: Tue, 23 Jun 2020 11:33:17 +0200 In-Reply-To: <877dvz7228.fsf@gnu.org> ("Ludovic \=\?utf-8\?Q\?Court\=C3\=A8s\=22'\?\= \=\?utf-8\?Q\?s\?\= message of "Mon, 22 Jun 2020 13:49:35 +0200") Message-ID: <87sgem2kki.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -3.3 (---) 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" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Spam-Score: -1.01 X-TUID: 7v/pc7aF2yyy Ludovic Court=C3=A8s skribis: > The are several possible causes of contention: (1) database opened too > many times, (2) database kept opened for too long, and (3) sqlite > mishandling contention somehow. Commit fe5de925aa0f2854a679cebdea02b03cac561c8f should make deduplication more efficient (it was an embarrassing bug=E2=80=A6), partly addressing #2. Ludo=E2=80=99.