GNU bug report logs - #21073
SQLite database creation for binary tarball is non-deterministic

Previous Next

Full log

View this message in rfc822 format

From: help-debbugs <at> gnu.org (GNU bug Tracking System)
To: ludo <at> gnu.org (Ludovic Courtès)
Subject: bug#21073: closed (Re: bug#21073: SQLite database creation for
 binary tarball is non-deterministic)
Date: Thu, 14 Jun 2018 09:21:02 +0000

[Message part 1 (text/plain, inline)]

Your bug report

#21073: SQLite database creation for binary tarball is non-deterministic

which was filed against the guix package, has been closed.

The explanation is attached below, along with your original report.
If you require more details, please reply to 21073 <at> debbugs.gnu.org.

-- 
21073: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=21073
GNU Bug Tracking System
Contact help-debbugs <at> gnu.org with problems

[Message part 2 (message/rfc822, inline)]

From: ludo <at> gnu.org (Ludovic Courtès)
To: 21073-done <at> debbugs.gnu.org
Subject: Re: bug#21073: SQLite database creation for binary tarball is
 non-deterministic
Date: Thu, 14 Jun 2018 11:19:52 +0200

ludo <at> gnu.org (Ludovic Courtès) skribis:

> When running ‘make guix-binary.x86_64-linux.tar.xz’ twice (and of course
> ‘guix gc -d /gnu/store/*-guix-tarball.tar.xz’ in the meantime), one can
> see that the ‘db.sqlite’ files in the tarballs have the same size but
> differ by a few bytes.

Fixed by commit eb9fe97495c012c989f76cb42a14cd78f9d94629 as part of the
patch series submitted at <https://bugs.gnu.org/31755>.

Yay for more reproducibility!

Ludo’.

[Message part 3 (message/rfc822, inline)]

From: ludo <at> gnu.org (Ludovic Courtès)
To: bug-guix <at> gnu.org
Subject: SQLite database creation for binary tarball is non-deterministic
Date: Thu, 16 Jul 2015 10:29:36 +0200

When running ‘make guix-binary.x86_64-linux.tar.xz’ twice (and of course
‘guix gc -d /gnu/store/*-guix-tarball.tar.xz’ in the meantime), one can
see that the ‘db.sqlite’ files in the tarballs have the same size but
differ by a few bytes.

It’s not clear whether this is an issue inherent to SQLite3 or rather
something due to the way we create the database.

(<https://trac.torproject.org/projects/tor/ticket/11630> might give some
ideas.)

Ludo’.

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.