From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id MCQINf3B/F7JDgAA0tVLHw (envelope-from ) for ; Wed, 01 Jul 2020 17:03:57 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id 8BL0MP3B/F6tHwAAB5/wlQ (envelope-from ) for ; Wed, 01 Jul 2020 17:03:57 +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 F2884940607 for ; Wed, 1 Jul 2020 17:03:56 +0000 (UTC) Received: from localhost ([::1]:35780 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jqg9K-0006AE-Ej for larch@yhetil.org; Wed, 01 Jul 2020 13:03:54 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53200) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jqg7W-0002fx-D2 for bug-guix@gnu.org; Wed, 01 Jul 2020 13:02:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:42165) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jqg7W-0006vt-1L for bug-guix@gnu.org; Wed, 01 Jul 2020 13:02:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1jqg7V-00073c-Un for bug-guix@gnu.org; Wed, 01 Jul 2020 13:02:01 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#42151: [PATCH 0/3] offload to Childhurd fails: setting synchronous mode: locking protocol Resent-From: Jan Nieuwenhuizen Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Wed, 01 Jul 2020 17:02:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 42151 X-GNU-PR-Package: guix X-GNU-PR-Keywords: patch To: 42151@debbugs.gnu.org X-Debbugs-Original-To: bug-guix@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.159362288527081 (code B ref -1); Wed, 01 Jul 2020 17:02:01 +0000 Received: (at submit) by debbugs.gnu.org; 1 Jul 2020 17:01:25 +0000 Received: from localhost ([127.0.0.1]:53711 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jqg6p-00072d-3d for submit@debbugs.gnu.org; Wed, 01 Jul 2020 13:01:25 -0400 Received: from lists.gnu.org ([209.51.188.17]:55834) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1jqg6n-00072W-3q for submit@debbugs.gnu.org; Wed, 01 Jul 2020 13:01:18 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:53034) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jqg6m-0001AC-RP for bug-guix@gnu.org; Wed, 01 Jul 2020 13:01:16 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:42521) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jqg6m-0006oT-1R; Wed, 01 Jul 2020 13:01:16 -0400 Received: from [2001:980:1b4f:1:42d2:832d:bb59:862] (port=55496 helo=dundal.peder.onsbrabantnet.nl) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1jqg6h-0004L1-Qn; Wed, 01 Jul 2020 13:01:14 -0400 From: Jan Nieuwenhuizen Organization: AvatarAcademy.nl References: <20200701142929.26919-1-janneke@gnu.org> X-Url: http://AvatarAcademy.nl Date: Wed, 01 Jul 2020 19:01:08 +0200 In-Reply-To: <20200701142929.26919-1-janneke@gnu.org> (Jan Nieuwenhuizen's message of "Wed, 1 Jul 2020 16:29:29 +0200") Message-ID: <87o8ozcgq3.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: -1.0 (-) 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: Tm1vF+rlviSd Jan (janneke) Nieuwenhuizen writes: > Maybe we're missing some file_lock patch that Debian has? Where to look, > glibc, hurd, ...? Ideas? So...I found a way to reproduce the feature/bug: run "pragma synchronous = =3D normal;" in two instances. I created a db.sqlite using sh -x tests/guix-pack-localstatedir.sh=20 (after removing the cleanup trap). Then, doing --8<---------------cut here---------------start------------->8--- $ sqlite3 db.sqlite=20 SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> SELECT * FROM ValidPaths; 1|/gnu/store/pqciscj9304544h3yaqb5m70fggsr293-manual-database|sha256:ccd93b= ed3a0018f892abc5db92bf182c3e2e986f41a8ded168915b4d9e85fa18|1||2664 2|/gnu/store/mzfkrxd4w8vqrmyrx169wj8wyw7r8i37-bash|sha256:6f887d45fa0f7e59e= 55c6d7ba86a3d8c35369c7afbb3a5829b8ed226bfef4a66|1||1351880 3|/gnu/store/lgi9x15a0w35mcpd7g1kb9274r6wy4pv-guile-bootstrap-2.0|sha256:dc= 3e6b577e995c093849454fe4b9c30e87ece6462c54369ff249121f178c5476|1||12718808 4|/gnu/store/6z4h8g6s73zmcn0h6sm63p9d47ih4b63-info-dir|sha256:fd154332e6d35= c95f12e41d6168a93945b4737fcbaf734bcaf04ca771a106544|1||432 5|/gnu/store/mj7szx64bdh080rlhzhrvcg6viyba73s-profile|sha256:e32ae4d07fc229= 8a72e6942f21ba85c0300a84bbaf5794a8c5f0393a8dc9f253|1||2960 sqlite> pragma synchronous =3D normal; sqlite> C-c C-z^Z [2]+ Stopped sqlite3 db.sqlite [148]18:55:06 janneke@dundal:~/src/guix/master [env] $ sqlite3 db.sqlite=20 SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> pragma synchronous =3D normal; sqlite>=20 --8<---------------cut here---------------end--------------->8--- works nice on GNU/Linux and on current master Childhurd gives --8<---------------cut here---------------start------------->8--- $ ssh childhurd Last login: Wed Jul 1 12:08:17 2020 from 10.0.2.2 =EE=BC=80=EE=BC=81=EE=BC=82=EE=BC=83=EE=BC=84=EE=BC=85 =EE=BC=86=EE=BC=87=EE=BC=88=EE=BC=89=EE=BC=8A=EE=BC=8B =EE=BC=8C=EE=BC=8D=EE=BC=8E=EE=BC=8F=EE=BC=90=EE=BC=91 This is the GNU Hur= d. Welcome. root@childhurd ~# sqlite3 db.sqlite=20 SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> SELECT * FROM ValidPaths; 1|/gnu/store/pqciscj9304544h3yaqb5m70fggsr293-manual-database|sha256:ccd93b= ed3a0018f892abc5db92bf182c3e2e986f41a8ded168915b4d9e85fa18|1||2664 2|/gnu/store/mzfkrxd4w8vqrmyrx169wj8wyw7r8i37-bash|sha256:6f887d45fa0f7e59e= 55c6d7ba86a3d8c35369c7afbb3a5829b8ed226bfef4a66|1||1351880 3|/gnu/store/lgi9x15a0w35mcpd7g1kb9274r6wy4pv-guile-bootstrap-2.0|sha256:dc= 3e6b577e995c093849454fe4b9c30e87ece6462c54369ff249121f178c5476|1||12718808 4|/gnu/store/6z4h8g6s73zmcn0h6sm63p9d47ih4b63-info-dir|sha256:fd154332e6d35= c95f12e41d6168a93945b4737fcbaf734bcaf04ca771a106544|1||432 5|/gnu/store/mj7szx64bdh080rlhzhrvcg6viyba73s-profile|sha256:e32ae4d07fc229= 8a72e6942f21ba85c0300a84bbaf5794a8c5f0393a8dc9f253|1||2960 sqlite> pragma synchronous =3D normal; sqlite> C-c C-z^Z [1]+ Stopped sqlite3 db.sqlite root@childhurd ~# sqlite3 db.sqlite=20 SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> pragma synchronous =3D normal; Error: locking protocol sqlite>=20 --8<---------------cut here---------------end--------------->8--- On Debian/Hurd (which I hoped had a patched, fixed sqlite3), it doesn't work at all --8<---------------cut here---------------start------------->8--- $ ssh hurd GNU debian 0.9 GNU-Mach 1.8+git20191117-486/Hurd-0.9 i686-AT386 =EE=BC=80=EE=BC=81=EE=BC=82=EE=BC=83=EE=BC=84=EE=BC=85 =EE=BC=86=EE=BC=87=EE=BC=88=EE=BC=89=EE=BC=8A=EE=BC=8B =EE=BC=8C=EE=BC=8D=EE=BC=8E=EE=BC=8F=EE=BC=90=EE=BC=91 This is the GNU Hur= d. Welcome. The Hurd is not Linux. Make sure to read http://www.debian.org/ports/hurd/hurd-install to check out the few things you _need_ to know. Also check out the FAQ http://www.gnu.org/software/hurd/faq.html or its latest version on http://darnassus.sceen.net/~hurd-web/faq/ To read a short intro on some nice features of the Hurd, just have a look at the translator_primer file, for example via 'nano translator_primer' Last login: Wed Jul 1 12:58:44 2020 from 10.0.2.2 janneke@debian:~$ sqlite3 db.sqlite SQLite version 3.32.3 2020-06-18 14:00:33 Enter ".help" for usage hints. sqlite> SELECT * FROM ValidPaths; Error: unable to open database file sqlite>=20 --8<---------------cut here---------------end--------------->8--- So, still a similar question...is the patch simply broken/bitrotted, or did some file locking change on the Hurd? Janneke --=20 Jan Nieuwenhuizen | GNU LilyPond http://lilypond.org Freelance IT http://JoyofSource.com | Avatar=C2=AE http://AvatarAcademy.com