Diff of the two buildlogs: -- --- b1/build.log 2025-02-22 12:29:31.153956825 +0000 +++ b2/build.log 2025-02-22 12:30:56.094113646 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri Mar 27 06:51:45 -12 2026 -I: pbuilder-time-stamp: 1774637505 +I: Current time: Sun Feb 23 02:29:33 +14 2025 +I: pbuilder-time-stamp: 1740227373 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/unstable-reproducible-base.tgz] I: copying local configuration @@ -23,54 +23,86 @@ dpkg-source: info: unpacking sqlsmith_1.4-1.debian.tar.xz I: using fakeroot in build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/82305/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/D01_modify_environment starting +debug: Running on ionos12-i386. +I: Changing host+domainname to test build reproducibility +I: Adding a custom variable just for the fun of it... +I: Changing /bin/sh to bash +'/bin/sh' -> '/bin/bash' +lrwxrwxrwx 1 root root 9 Feb 22 12:29 /bin/sh -> /bin/bash +I: Setting pbuilder2's login shell to /bin/bash +I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build/reproducible-path' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' - BUILD_ARCH='i386' - DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=22 ' - DISTRIBUTION='unstable' - HOME='/root' - HOST_ARCH='i386' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="2" [2]="37" [3]="1" [4]="release" [5]="i686-pc-linux-gnu") + BASH_VERSION='5.2.37(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=i386 + DEBIAN_FRONTEND=noninteractive + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=10 ' + DIRSTACK=() + DISTRIBUTION=unstable + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=i686 + HOST_ARCH=i386 IFS=' ' - INVOCATION_ID='cc572aeaf63d4f6faeabc79da63174ff' - LANG='C' - LANGUAGE='en_US:en' - LC_ALL='C' - LD_LIBRARY_PATH='/usr/lib/libeatmydata' - LD_PRELOAD='libeatmydata.so' - MAIL='/var/mail/root' - OPTIND='1' - PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' - PBCURRENTCOMMANDLINEOPERATION='build' - PBUILDER_OPERATION='build' - PBUILDER_PKGDATADIR='/usr/share/pbuilder' - PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' - PBUILDER_SYSCONFDIR='/etc' - PPID='82305' - PS1='# ' - PS2='> ' + INVOCATION_ID=3ec7f219e3df4acb858fbfa33d605829 + LANG=C + LANGUAGE=de_CH:de + LC_ALL=C + LD_LIBRARY_PATH=/usr/lib/libeatmydata + LD_PRELOAD=libeatmydata.so + MACHTYPE=i686-pc-linux-gnu + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnu + PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path + PBCURRENTCOMMANDLINEOPERATION=build + PBUILDER_OPERATION=build + PBUILDER_PKGDATADIR=/usr/share/pbuilder + PBUILDER_PKGLIBDIR=/usr/lib/pbuilder + PBUILDER_SYSCONFDIR=/etc + PIPESTATUS=([0]="0") + POSIXLY_CORRECT=y + PPID=32013 PS4='+ ' - PWD='/' - SHELL='/bin/bash' - SHLVL='2' - SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.ucTmr52x/pbuilderrc_ezjQ --distribution unstable --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.ucTmr52x/b1 --logfile b1/build.log sqlsmith_1.4-1.dsc' - SUDO_GID='112' - SUDO_UID='107' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://213.165.73.152:3128' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.ucTmr52x/pbuilderrc_Jdwa --distribution unstable --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.ucTmr52x/b2 --logfile b2/build.log sqlsmith_1.4-1.dsc' + SUDO_GID=112 + SUDO_UID=107 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://46.16.76.132:3128 I: uname -a - Linux ionos16-i386 6.1.0-31-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.128-1 (2025-02-07) x86_64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-31-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.128-1 (2025-02-07) x86_64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Nov 22 2024 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/82305/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Nov 22 14:40 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -167,7 +199,7 @@ Get: 47 http://deb.debian.org/debian unstable/main i386 pkgconf i386 1.8.1-4 [26.2 kB] Get: 48 http://deb.debian.org/debian unstable/main i386 libpqxx-dev i386 7.10.0-2 [388 kB] Get: 49 http://deb.debian.org/debian unstable/main i386 libsqlite3-dev i386 3.46.1-1 [1193 kB] -Fetched 27.7 MB in 0s (63.5 MB/s) +Fetched 27.7 MB in 0s (72.5 MB/s) Preconfiguring packages ... Selecting previously unselected package autoconf-archive. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19761 files and directories currently installed.) @@ -383,7 +415,11 @@ fakeroot is already the newest version (1.37-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. I: Building the package -I: Running cd /build/reproducible-path/sqlsmith-1.4/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../sqlsmith_1.4-1_source.changes +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for unstable +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/reproducible-path/sqlsmith-1.4/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../sqlsmith_1.4-1_source.changes dpkg-buildpackage: info: source package sqlsmith dpkg-buildpackage: info: source version 1.4-1 dpkg-buildpackage: info: source distribution unstable @@ -397,10 +433,10 @@ dh binary dh_update_autotools_config dh_autoreconf -sh: 1: git: not found -sh: 1: git: not found -sh: 1: git: not found -sh: 1: git: not found +sh: line 1: git: command not found +sh: line 1: git: command not found +sh: line 1: git: command not found +sh: line 1: git: command not found configure.ac:29: installing './compile' configure.ac:28: installing './config.guess' configure.ac:28: installing './config.sub' @@ -472,14 +508,14 @@ config.status: creating config.h config.status: executing depfiles commands dh_auto_build - make -j22 + make -j10 make[1]: Entering directory '/build/reproducible-path/sqlsmith-1.4' if git describe --exclude='debian*' --dirty --tags --always > /dev/null ; then \ echo "#define GITREV \"$(git describe --exclude='debian*' --dirty --tags --always)\"" > gitrev.h ;\ else \ echo "#define GITREV \"unreleased\"" > gitrev.h ;\ fi -/bin/bash: line 1: git: command not found +/bin/sh: line 1: git: command not found make all-am make[2]: Entering directory '/build/reproducible-path/sqlsmith-1.4' g++ -std=c++17 -DHAVE_CONFIG_H -I. -I/include/boost-0 -I/usr/include/postgresql -Wall -Wextra -Wdate-time -D_FORTIFY_SOURCE=2 -g -O2 -ffile-prefix-map=/build/reproducible-path/sqlsmith-1.4=. -fstack-protector-strong -Wformat -Werror=format-security -c -o relmodel.o relmodel.cc @@ -494,31 +530,6 @@ g++ -std=c++17 -DHAVE_CONFIG_H -I. -I/include/boost-0 -I/usr/include/postgresql -Wall -Wextra -Wdate-time -D_FORTIFY_SOURCE=2 -g -O2 -ffile-prefix-map=/build/reproducible-path/sqlsmith-1.4=. -fstack-protector-strong -Wformat -Werror=format-security -c -o dump.o dump.cc g++ -std=c++17 -DHAVE_CONFIG_H -I. -I/include/boost-0 -I/usr/include/postgresql -Wall -Wextra -Wdate-time -D_FORTIFY_SOURCE=2 -g -O2 -ffile-prefix-map=/build/reproducible-path/sqlsmith-1.4=. -fstack-protector-strong -Wformat -Werror=format-security -c -o impedance.o impedance.cc g++ -std=c++17 -DHAVE_CONFIG_H -I. -I/include/boost-0 -I/usr/include/postgresql -Wall -Wextra -Wdate-time -D_FORTIFY_SOURCE=2 -g -O2 -ffile-prefix-map=/build/reproducible-path/sqlsmith-1.4=. -fstack-protector-strong -Wformat -Werror=format-security -c -o sqlsmith.o sqlsmith.cc -log.cc: In constructor 'pqxx_logger::pqxx_logger(std::string, std::string, schema&)': -log.cc:150:29: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {const char (&)[11], std::__cxx11::basic_string, std::allocator >&, char (&)[1024], std::__cxx11::basic_string, std::allocator >&, std::__cxx11::basic_string, std::allocator >}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] - 150 | result r = w.exec_prepared("instance", GITREV, target, hostname, s.version, seed.str()); - | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -In file included from /usr/include/pqxx/dbtransaction.hxx:20, - from /usr/include/pqxx/blob.hxx:36, - from /usr/include/pqxx/pqxx:6, - from log.cc:3: -/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here - 918 | result exec_prepared(zview statement, Args &&...args) - | ^~~~~~~~~~~~~ -log.cc: In member function 'virtual void pqxx_logger::error(prod&, const dut::failure&)': -log.cc:177:18: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {const char*, std::__cxx11::basic_string, std::allocator >, const std::__cxx11::basic_string, std::allocator >&}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] - 177 | w.exec_prepared("error", e.what(), s.str(), e.sqlstate); - | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here - 918 | result exec_prepared(zview statement, Args &&...args) - | ^~~~~~~~~~~~~ -log.cc: In member function 'virtual void pqxx_logger::generated(prod&)': -log.cc:192:20: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {long int&, float, float, float, std::__cxx11::basic_string, std::allocator >}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] - 192 | w.exec_prepared("stat", queries, sum_height/queries, sum_nodes/queries, sum_retries/queries, s.str()); - | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here - 918 | result exec_prepared(zview statement, Args &&...args) - | ^~~~~~~~~~~~~ postgres.cc: In constructor 'dut_pqxx::dut_pqxx(std::string)': postgres.cc:68:20: warning: 'void pqxx::connection::set_variable(std::string_view, std::string_view) &' is deprecated: To set session variables, use set_session_var. [-Wdeprecated-declarations] 68 | c.set_variable("statement_timeout", "'1s'"); @@ -550,11 +561,36 @@ /usr/include/pqxx/connection.hxx:1214:3: note: declared here 1214 | set_variable(std::string_view var, std::string_view value) &; | ^~~~~~~~~~~~ +log.cc: In constructor 'pqxx_logger::pqxx_logger(std::string, std::string, schema&)': +log.cc:150:29: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {const char (&)[11], std::__cxx11::basic_string, std::allocator >&, char (&)[1024], std::__cxx11::basic_string, std::allocator >&, std::__cxx11::basic_string, std::allocator >}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] + 150 | result r = w.exec_prepared("instance", GITREV, target, hostname, s.version, seed.str()); + | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +In file included from /usr/include/pqxx/dbtransaction.hxx:20, + from /usr/include/pqxx/blob.hxx:36, + from /usr/include/pqxx/pqxx:6, + from log.cc:3: +/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here + 918 | result exec_prepared(zview statement, Args &&...args) + | ^~~~~~~~~~~~~ +log.cc: In member function 'virtual void pqxx_logger::error(prod&, const dut::failure&)': +log.cc:177:18: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {const char*, std::__cxx11::basic_string, std::allocator >, const std::__cxx11::basic_string, std::allocator >&}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] + 177 | w.exec_prepared("error", e.what(), s.str(), e.sqlstate); + | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here + 918 | result exec_prepared(zview statement, Args &&...args) + | ^~~~~~~~~~~~~ +log.cc: In member function 'virtual void pqxx_logger::generated(prod&)': +log.cc:192:20: warning: 'pqxx::result pqxx::transaction_base::exec_prepared(pqxx::zview, Args&& ...) [with Args = {long int&, float, float, float, std::__cxx11::basic_string, std::allocator >}]' is deprecated: Use exec(prepped, params) instead. [-Wdeprecated-declarations] + 192 | w.exec_prepared("stat", queries, sum_height/queries, sum_nodes/queries, sum_retries/queries, s.str()); + | ~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +/usr/include/pqxx/transaction_base.hxx:918:10: note: declared here + 918 | result exec_prepared(zview statement, Args &&...args) + | ^~~~~~~~~~~~~ g++ -std=c++17 -g -O2 -ffile-prefix-map=/build/reproducible-path/sqlsmith-1.4=. -fstack-protector-strong -Wformat -Werror=format-security -L/lib -Wl,-z,relro -o sqlsmith relmodel.o schema.o postgres.o sqlite.o random.o prod.o expr.o grammar.o log.o dump.o impedance.o sqlsmith.o -lpqxx -lpq -lsqlite3 make[2]: Leaving directory '/build/reproducible-path/sqlsmith-1.4' make[1]: Leaving directory '/build/reproducible-path/sqlsmith-1.4' dh_auto_test - make -j22 check "TESTSUITEFLAGS=-j22 --verbose" VERBOSE=1 + make -j10 check "TESTSUITEFLAGS=-j10 --verbose" VERBOSE=1 make[1]: Entering directory '/build/reproducible-path/sqlsmith-1.4' make check-am make[2]: Entering directory '/build/reproducible-path/sqlsmith-1.4' @@ -563,7 +599,7 @@ create-stamp debian/debhelper-build-stamp dh_prep dh_auto_install --destdir=debian/sqlsmith/ - make -j22 install DESTDIR=/build/reproducible-path/sqlsmith-1.4/debian/sqlsmith AM_UPDATE_INFO_DIR=no + make -j10 install DESTDIR=/build/reproducible-path/sqlsmith-1.4/debian/sqlsmith AM_UPDATE_INFO_DIR=no make[1]: Entering directory '/build/reproducible-path/sqlsmith-1.4' make install-am make[2]: Entering directory '/build/reproducible-path/sqlsmith-1.4' @@ -590,8 +626,8 @@ dh_gencontrol dh_md5sums dh_builddeb -dpkg-deb: building package 'sqlsmith' in '../sqlsmith_1.4-1_i386.deb'. dpkg-deb: building package 'sqlsmith-dbgsym' in '../sqlsmith-dbgsym_1.4-1_i386.deb'. +dpkg-deb: building package 'sqlsmith' in '../sqlsmith_1.4-1_i386.deb'. dpkg-genbuildinfo --build=binary -O../sqlsmith_1.4-1_i386.buildinfo dpkg-genchanges --build=binary -O../sqlsmith_1.4-1_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) @@ -599,12 +635,14 @@ dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: including full source code in upload I: copying local configuration +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/32013/tmp/hooks/B01_cleanup finished I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem I: cleaning the build env -I: removing directory /srv/workspace/pbuilder/82305 and its subdirectories -I: Current time: Fri Mar 27 06:52:30 -12 2026 -I: pbuilder-time-stamp: 1774637550 +I: removing directory /srv/workspace/pbuilder/32013 and its subdirectories +I: Current time: Sun Feb 23 02:30:55 +14 2025 +I: pbuilder-time-stamp: 1740227455