From unknown Sun Jun 22 22:39:54 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#21073 <21073@debbugs.gnu.org> To: bug#21073 <21073@debbugs.gnu.org> Subject: Status: SQLite database creation for binary tarball is non-deterministic Reply-To: bug#21073 <21073@debbugs.gnu.org> Date: Mon, 23 Jun 2025 05:39:54 +0000 retitle 21073 SQLite database creation for binary tarball is non-determinis= tic reassign 21073 guix submitter 21073 ludo@gnu.org (Ludovic Court=C3=A8s) severity 21073 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Thu Jul 16 04:29:52 2015 Received: (at submit) by debbugs.gnu.org; 16 Jul 2015 08:29:53 +0000 Received: from localhost ([127.0.0.1]:50607 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.80) (envelope-from ) id 1ZFeYC-0000gE-GC for submit@debbugs.gnu.org; Thu, 16 Jul 2015 04:29:52 -0400 Received: from eggs.gnu.org ([208.118.235.92]:42709) by debbugs.gnu.org with esmtp (Exim 4.80) (envelope-from ) id 1ZFeYA-0000g1-UK for submit@debbugs.gnu.org; Thu, 16 Jul 2015 04:29:51 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZFeY4-00047I-K3 for submit@debbugs.gnu.org; Thu, 16 Jul 2015 04:29:45 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-3.2 required=5.0 tests=BAYES_00,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:36237) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZFeY4-00047E-Hc for submit@debbugs.gnu.org; Thu, 16 Jul 2015 04:29:44 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:56199) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZFeY3-00036C-El for bug-guix@gnu.org; Thu, 16 Jul 2015 04:29:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZFeXy-0003zt-Dk for bug-guix@gnu.org; Thu, 16 Jul 2015 04:29:43 -0400 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:37719) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZFeXy-0003zi-BJ for bug-guix@gnu.org; Thu, 16 Jul 2015 04:29:38 -0400 Received: from pluto.bordeaux.inria.fr ([193.50.110.57]:51003 helo=pluto) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1ZFeXx-00036z-Q4 for bug-guix@gnu.org; Thu, 16 Jul 2015 04:29:38 -0400 From: ludo@gnu.org (Ludovic =?utf-8?Q?Court=C3=A8s?=) To: bug-guix@gnu.org Subject: SQLite database creation for binary tarball is non-deterministic X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: 28 Messidor an 223 de la =?utf-8?Q?R=C3=A9volution?= X-PGP-Key-ID: 0x3D9AEBB5 X-PGP-Key: http://www.fdn.fr/~lcourtes/ludovic.asc X-PGP-Fingerprint: 3CE4 6455 8A84 FDC6 9DB4 0CFB 090B 1199 3D9A EBB5 X-OS: x86_64-unknown-linux-gnu Date: Thu, 16 Jul 2015 10:29:36 +0200 Message-ID: <87io9kld3j.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address (bad octet value). X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address (bad octet value). X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -6.4 (------) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.4 (------) When running =E2=80=98make guix-binary.x86_64-linux.tar.xz=E2=80=99 twice (= and of course =E2=80=98guix gc -d /gnu/store/*-guix-tarball.tar.xz=E2=80=99 in the meanti= me), one can see that the =E2=80=98db.sqlite=E2=80=99 files in the tarballs have the sam= e size but differ by a few bytes. It=E2=80=99s not clear whether this is an issue inherent to SQLite3 or rath= er something due to the way we create the database. ( might give some ideas.) Ludo=E2=80=99. From debbugs-submit-bounces@debbugs.gnu.org Thu Jun 14 05:20:04 2018 Received: (at 21073-done) by debbugs.gnu.org; 14 Jun 2018 09:20:04 +0000 Received: from localhost ([127.0.0.1]:47341 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fTOQF-0002Dx-QD for submit@debbugs.gnu.org; Thu, 14 Jun 2018 05:20:04 -0400 Received: from eggs.gnu.org ([208.118.235.92]:58352) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fTOQE-0002DQ-Hl for 21073-done@debbugs.gnu.org; Thu, 14 Jun 2018 05:20:02 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fTOQ6-0002jR-C6 for 21073-done@debbugs.gnu.org; Thu, 14 Jun 2018 05:19:57 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:40013) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fTOQ6-0002jF-7T for 21073-done@debbugs.gnu.org; Thu, 14 Jun 2018 05:19:54 -0400 Received: from [193.50.110.75] (port=35626 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1fTOQ5-00021R-OM for 21073-done@debbugs.gnu.org; Thu, 14 Jun 2018 05:19:53 -0400 From: ludo@gnu.org (Ludovic =?utf-8?Q?Court=C3=A8s?=) To: 21073-done@debbugs.gnu.org Subject: Re: bug#21073: SQLite database creation for binary tarball is non-deterministic References: <87io9kld3j.fsf@gnu.org> Date: Thu, 14 Jun 2018 11:19:52 +0200 In-Reply-To: <87io9kld3j.fsf@gnu.org> ("Ludovic \=\?utf-8\?Q\?Court\=C3\=A8s\=22'\?\= \=\?utf-8\?Q\?s\?\= message of "Thu, 16 Jul 2015 10:29:36 +0200") Message-ID: <87efh92093.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -5.0 (-----) X-Debbugs-Envelope-To: 21073-done X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -6.0 (------) ludo@gnu.org (Ludovic Court=C3=A8s) skribis: > When running =E2=80=98make guix-binary.x86_64-linux.tar.xz=E2=80=99 twice= (and of course > =E2=80=98guix gc -d /gnu/store/*-guix-tarball.tar.xz=E2=80=99 in the mean= time), one can > see that the =E2=80=98db.sqlite=E2=80=99 files in the tarballs have the s= ame size but > differ by a few bytes. Fixed by commit eb9fe97495c012c989f76cb42a14cd78f9d94629 as part of the patch series submitted at . Yay for more reproducibility! Ludo=E2=80=99. From unknown Sun Jun 22 22:39:54 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Thu, 12 Jul 2018 11:24:08 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator