Diff of the two buildlogs: -- --- b1/build.log 2023-04-13 23:53:35.395007331 +0000 +++ b2/build.log 2023-04-13 23:56:00.892552685 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Thu Apr 13 11:51:53 -12 2023 -I: pbuilder-time-stamp: 1681429913 +I: Current time: Thu May 16 20:16:42 +14 2024 +I: pbuilder-time-stamp: 1715840202 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bookworm-reproducible-base.tgz] I: copying local configuration @@ -17,7 +17,7 @@ I: copying [./pgcopydb_0.10.orig.tar.gz] I: copying [./pgcopydb_0.10-1.debian.tar.xz] I: Extracting source -gpgv: Signature made Fri Nov 4 03:19:36 2022 -12 +gpgv: Signature made Sat Nov 5 05:19:36 2022 +14 gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.10-1.dsc: no acceptable signature found @@ -26,137 +26,146 @@ dpkg-source: info: unpacking pgcopydb_0.10-1.debian.tar.xz I: using fakeroot in build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/3877/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/67537/tmp/hooks/D01_modify_environment starting +debug: Running on ionos6-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 +lrwxrwxrwx 1 root root 4 Jan 6 2023 /bin/sh -> dash +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/67537/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/67537/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' + 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=8' + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=15' DISTRIBUTION='bookworm' HOME='/root' HOST_ARCH='i386' IFS=' ' - INVOCATION_ID='dae9753fdea04aeca11dac6ad188fcdd' + INVOCATION_ID='dcee3ac9b28d45e88ca4c93a60f33b18' LANG='C' - LANGUAGE='en_US:en' + LANGUAGE='de_CH:de' 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' + 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' - PPID='3877' + PPID='67537' PS1='# ' PS2='> ' 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.MKCiWcZ3/pbuilderrc_7Nkd --distribution bookworm --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.MKCiWcZ3/b1 --logfile b1/build.log pgcopydb_0.10-1.dsc' + 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.MKCiWcZ3/pbuilderrc_6TZ6 --distribution bookworm --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.MKCiWcZ3/b2 --logfile b2/build.log --extrapackages usrmerge pgcopydb_0.10-1.dsc' SUDO_GID='112' SUDO_UID='107' SUDO_USER='jenkins' TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' + TZ='/usr/share/zoneinfo/Etc/GMT-14' USER='root' _='/usr/bin/systemd-run' - http_proxy='http://78.137.99.97:3128' + http_proxy='http://85.184.249.68:3128' I: uname -a - Linux ionos2-i386 5.10.0-21-686-pae #1 SMP Debian 5.10.162-1 (2023-01-21) i686 GNU/Linux + Linux i-capture-the-hostname 5.10.0-21-amd64 #1 SMP Debian 5.10.162-1 (2023-01-21) x86_64 GNU/Linux I: ls -l /bin total 6040 - -rwxr-xr-x 1 root root 1408088 Feb 12 08:21 bash - -rwxr-xr-x 3 root root 38404 Sep 18 2022 bunzip2 - -rwxr-xr-x 3 root root 38404 Sep 18 2022 bzcat - lrwxrwxrwx 1 root root 6 Sep 18 2022 bzcmp -> bzdiff - -rwxr-xr-x 1 root root 2225 Sep 18 2022 bzdiff - lrwxrwxrwx 1 root root 6 Sep 18 2022 bzegrep -> bzgrep - -rwxr-xr-x 1 root root 4893 Nov 27 2021 bzexe - lrwxrwxrwx 1 root root 6 Sep 18 2022 bzfgrep -> bzgrep - -rwxr-xr-x 1 root root 3775 Sep 18 2022 bzgrep - -rwxr-xr-x 3 root root 38404 Sep 18 2022 bzip2 - -rwxr-xr-x 1 root root 17892 Sep 18 2022 bzip2recover - lrwxrwxrwx 1 root root 6 Sep 18 2022 bzless -> bzmore - -rwxr-xr-x 1 root root 1297 Sep 18 2022 bzmore - -rwxr-xr-x 1 root root 42920 Sep 20 2022 cat - -rwxr-xr-x 1 root root 79816 Sep 20 2022 chgrp - -rwxr-xr-x 1 root root 67496 Sep 20 2022 chmod - -rwxr-xr-x 1 root root 79816 Sep 20 2022 chown - -rwxr-xr-x 1 root root 162024 Sep 20 2022 cp - -rwxr-xr-x 1 root root 136916 Jan 5 01:20 dash - -rwxr-xr-x 1 root root 137160 Sep 20 2022 date - -rwxr-xr-x 1 root root 100364 Sep 20 2022 dd - -rwxr-xr-x 1 root root 108940 Sep 20 2022 df - -rwxr-xr-x 1 root root 162152 Sep 20 2022 dir - -rwxr-xr-x 1 root root 87760 Mar 22 22:20 dmesg - lrwxrwxrwx 1 root root 8 Dec 19 01:33 dnsdomainname -> hostname - lrwxrwxrwx 1 root root 8 Dec 19 01:33 domainname -> hostname - -rwxr-xr-x 1 root root 38760 Sep 20 2022 echo - -rwxr-xr-x 1 root root 41 Jan 24 02:43 egrep - -rwxr-xr-x 1 root root 34664 Sep 20 2022 false - -rwxr-xr-x 1 root root 41 Jan 24 02:43 fgrep - -rwxr-xr-x 1 root root 84272 Mar 22 22:20 findmnt - -rwsr-xr-x 1 root root 30240 Mar 22 20:38 fusermount - -rwxr-xr-x 1 root root 218680 Jan 24 02:43 grep - -rwxr-xr-x 2 root root 2346 Apr 9 2022 gunzip - -rwxr-xr-x 1 root root 6447 Apr 9 2022 gzexe - -rwxr-xr-x 1 root root 100952 Apr 9 2022 gzip - -rwxr-xr-x 1 root root 21916 Dec 19 01:33 hostname - -rwxr-xr-x 1 root root 75756 Sep 20 2022 ln - -rwxr-xr-x 1 root root 55600 Mar 22 23:43 login - -rwxr-xr-x 1 root root 162152 Sep 20 2022 ls - -rwxr-xr-x 1 root root 214568 Mar 22 22:20 lsblk - -rwxr-xr-x 1 root root 96328 Sep 20 2022 mkdir - -rwxr-xr-x 1 root root 84008 Sep 20 2022 mknod - -rwxr-xr-x 1 root root 38792 Sep 20 2022 mktemp - -rwxr-xr-x 1 root root 63016 Mar 22 22:20 more - -rwsr-xr-x 1 root root 58912 Mar 22 22:20 mount - -rwxr-xr-x 1 root root 13856 Mar 22 22:20 mountpoint - -rwxr-xr-x 1 root root 157932 Sep 20 2022 mv - lrwxrwxrwx 1 root root 8 Dec 19 01:33 nisdomainname -> hostname - lrwxrwxrwx 1 root root 14 Dec 18 05:00 pidof -> /sbin/killall5 - -rwxr-xr-x 1 root root 38792 Sep 20 2022 pwd - lrwxrwxrwx 1 root root 4 Feb 12 08:21 rbash -> bash - -rwxr-xr-x 1 root root 51080 Sep 20 2022 readlink - -rwxr-xr-x 1 root root 75720 Sep 20 2022 rm - -rwxr-xr-x 1 root root 51080 Sep 20 2022 rmdir - -rwxr-xr-x 1 root root 22308 Nov 2 04:31 run-parts - -rwxr-xr-x 1 root root 133224 Jan 5 07:55 sed - lrwxrwxrwx 1 root root 4 Jan 5 01:20 sh -> dash - -rwxr-xr-x 1 root root 38760 Sep 20 2022 sleep - -rwxr-xr-x 1 root root 87976 Sep 20 2022 stty - -rwsr-xr-x 1 root root 83492 Mar 22 22:20 su - -rwxr-xr-x 1 root root 38792 Sep 20 2022 sync - -rwxr-xr-x 1 root root 602584 Feb 16 2021 tar - -rwxr-xr-x 1 root root 13860 Nov 2 04:31 tempfile - -rwxr-xr-x 1 root root 120776 Sep 20 2022 touch - -rwxr-xr-x 1 root root 34664 Sep 20 2022 true - -rwxr-xr-x 1 root root 17892 Mar 22 20:38 ulockmgr_server - -rwsr-xr-x 1 root root 30236 Mar 22 22:20 umount - -rwxr-xr-x 1 root root 38760 Sep 20 2022 uname - -rwxr-xr-x 2 root root 2346 Apr 9 2022 uncompress - -rwxr-xr-x 1 root root 162152 Sep 20 2022 vdir - -rwxr-xr-x 1 root root 71216 Mar 22 22:20 wdctl - lrwxrwxrwx 1 root root 8 Dec 19 01:33 ypdomainname -> hostname - -rwxr-xr-x 1 root root 1984 Apr 9 2022 zcat - -rwxr-xr-x 1 root root 1678 Apr 9 2022 zcmp - -rwxr-xr-x 1 root root 6460 Apr 9 2022 zdiff - -rwxr-xr-x 1 root root 29 Apr 9 2022 zegrep - -rwxr-xr-x 1 root root 29 Apr 9 2022 zfgrep - -rwxr-xr-x 1 root root 2081 Apr 9 2022 zforce - -rwxr-xr-x 1 root root 8103 Apr 9 2022 zgrep - -rwxr-xr-x 1 root root 2206 Apr 9 2022 zless - -rwxr-xr-x 1 root root 1842 Apr 9 2022 zmore - -rwxr-xr-x 1 root root 4577 Apr 9 2022 znew -I: user script /srv/workspace/pbuilder/3877/tmp/hooks/D02_print_environment finished + -rwxr-xr-x 1 root root 1408088 Feb 13 2023 bash + -rwxr-xr-x 3 root root 38404 Sep 19 2022 bunzip2 + -rwxr-xr-x 3 root root 38404 Sep 19 2022 bzcat + lrwxrwxrwx 1 root root 6 Sep 19 2022 bzcmp -> bzdiff + -rwxr-xr-x 1 root root 2225 Sep 19 2022 bzdiff + lrwxrwxrwx 1 root root 6 Sep 19 2022 bzegrep -> bzgrep + -rwxr-xr-x 1 root root 4893 Nov 28 2021 bzexe + lrwxrwxrwx 1 root root 6 Sep 19 2022 bzfgrep -> bzgrep + -rwxr-xr-x 1 root root 3775 Sep 19 2022 bzgrep + -rwxr-xr-x 3 root root 38404 Sep 19 2022 bzip2 + -rwxr-xr-x 1 root root 17892 Sep 19 2022 bzip2recover + lrwxrwxrwx 1 root root 6 Sep 19 2022 bzless -> bzmore + -rwxr-xr-x 1 root root 1297 Sep 19 2022 bzmore + -rwxr-xr-x 1 root root 42920 Sep 21 2022 cat + -rwxr-xr-x 1 root root 79816 Sep 21 2022 chgrp + -rwxr-xr-x 1 root root 67496 Sep 21 2022 chmod + -rwxr-xr-x 1 root root 79816 Sep 21 2022 chown + -rwxr-xr-x 1 root root 162024 Sep 21 2022 cp + -rwxr-xr-x 1 root root 136916 Jan 6 2023 dash + -rwxr-xr-x 1 root root 137160 Sep 21 2022 date + -rwxr-xr-x 1 root root 100364 Sep 21 2022 dd + -rwxr-xr-x 1 root root 108940 Sep 21 2022 df + -rwxr-xr-x 1 root root 162152 Sep 21 2022 dir + -rwxr-xr-x 1 root root 87760 Mar 24 2023 dmesg + lrwxrwxrwx 1 root root 8 Dec 20 2022 dnsdomainname -> hostname + lrwxrwxrwx 1 root root 8 Dec 20 2022 domainname -> hostname + -rwxr-xr-x 1 root root 38760 Sep 21 2022 echo + -rwxr-xr-x 1 root root 41 Jan 25 2023 egrep + -rwxr-xr-x 1 root root 34664 Sep 21 2022 false + -rwxr-xr-x 1 root root 41 Jan 25 2023 fgrep + -rwxr-xr-x 1 root root 84272 Mar 24 2023 findmnt + -rwsr-xr-x 1 root root 30240 Mar 23 2023 fusermount + -rwxr-xr-x 1 root root 218680 Jan 25 2023 grep + -rwxr-xr-x 2 root root 2346 Apr 10 2022 gunzip + -rwxr-xr-x 1 root root 6447 Apr 10 2022 gzexe + -rwxr-xr-x 1 root root 100952 Apr 10 2022 gzip + -rwxr-xr-x 1 root root 21916 Dec 20 2022 hostname + -rwxr-xr-x 1 root root 75756 Sep 21 2022 ln + -rwxr-xr-x 1 root root 55600 Mar 24 2023 login + -rwxr-xr-x 1 root root 162152 Sep 21 2022 ls + -rwxr-xr-x 1 root root 214568 Mar 24 2023 lsblk + -rwxr-xr-x 1 root root 96328 Sep 21 2022 mkdir + -rwxr-xr-x 1 root root 84008 Sep 21 2022 mknod + -rwxr-xr-x 1 root root 38792 Sep 21 2022 mktemp + -rwxr-xr-x 1 root root 63016 Mar 24 2023 more + -rwsr-xr-x 1 root root 58912 Mar 24 2023 mount + -rwxr-xr-x 1 root root 13856 Mar 24 2023 mountpoint + -rwxr-xr-x 1 root root 157932 Sep 21 2022 mv + lrwxrwxrwx 1 root root 8 Dec 20 2022 nisdomainname -> hostname + lrwxrwxrwx 1 root root 14 Dec 19 2022 pidof -> /sbin/killall5 + -rwxr-xr-x 1 root root 38792 Sep 21 2022 pwd + lrwxrwxrwx 1 root root 4 Feb 13 2023 rbash -> bash + -rwxr-xr-x 1 root root 51080 Sep 21 2022 readlink + -rwxr-xr-x 1 root root 75720 Sep 21 2022 rm + -rwxr-xr-x 1 root root 51080 Sep 21 2022 rmdir + -rwxr-xr-x 1 root root 22308 Nov 3 2022 run-parts + -rwxr-xr-x 1 root root 133224 Jan 6 2023 sed + lrwxrwxrwx 1 root root 4 Jan 6 2023 sh -> dash + -rwxr-xr-x 1 root root 38760 Sep 21 2022 sleep + -rwxr-xr-x 1 root root 87976 Sep 21 2022 stty + -rwsr-xr-x 1 root root 83492 Mar 24 2023 su + -rwxr-xr-x 1 root root 38792 Sep 21 2022 sync + -rwxr-xr-x 1 root root 602584 Feb 17 2021 tar + -rwxr-xr-x 1 root root 13860 Nov 3 2022 tempfile + -rwxr-xr-x 1 root root 120776 Sep 21 2022 touch + -rwxr-xr-x 1 root root 34664 Sep 21 2022 true + -rwxr-xr-x 1 root root 17892 Mar 23 2023 ulockmgr_server + -rwsr-xr-x 1 root root 30236 Mar 24 2023 umount + -rwxr-xr-x 1 root root 38760 Sep 21 2022 uname + -rwxr-xr-x 2 root root 2346 Apr 10 2022 uncompress + -rwxr-xr-x 1 root root 162152 Sep 21 2022 vdir + -rwxr-xr-x 1 root root 71216 Mar 24 2023 wdctl + lrwxrwxrwx 1 root root 8 Dec 20 2022 ypdomainname -> hostname + -rwxr-xr-x 1 root root 1984 Apr 10 2022 zcat + -rwxr-xr-x 1 root root 1678 Apr 10 2022 zcmp + -rwxr-xr-x 1 root root 6460 Apr 10 2022 zdiff + -rwxr-xr-x 1 root root 29 Apr 10 2022 zegrep + -rwxr-xr-x 1 root root 29 Apr 10 2022 zfgrep + -rwxr-xr-x 1 root root 2081 Apr 10 2022 zforce + -rwxr-xr-x 1 root root 8103 Apr 10 2022 zgrep + -rwxr-xr-x 1 root root 2206 Apr 10 2022 zless + -rwxr-xr-x 1 root root 1842 Apr 10 2022 zmore + -rwxr-xr-x 1 root root 4577 Apr 10 2022 znew +I: user script /srv/workspace/pbuilder/67537/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -368,7 +377,7 @@ Get: 146 http://deb.debian.org/debian bookworm/main i386 sphinx-common all 5.3.0-4 [653 kB] Get: 147 http://deb.debian.org/debian bookworm/main i386 python3-sphinx all 5.3.0-4 [549 kB] Get: 148 http://deb.debian.org/debian bookworm/main i386 zlib1g-dev i386 1:1.2.13.dfsg-1 [913 kB] -Fetched 187 MB in 4s (51.9 MB/s) +Fetched 187 MB in 3s (56.4 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package libjson-perl. (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 ... 19604 files and directories currently installed.) @@ -959,7 +968,7 @@ selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB -selecting default time zone ... /usr/share/zoneinfo/Etc/GMT+12 +selecting default time zone ... /usr/share/zoneinfo/Etc/GMT-14 creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok @@ -1022,10 +1031,17 @@ Reading package lists... Building dependency tree... Reading state information... +usrmerge is already the newest version (35). fakeroot is already the newest version (1.31-1.2). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. I: Building the package -I: Running cd /build/pgcopydb-0.10/ && 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 > ../pgcopydb_0.10-1_source.changes +I: user script /srv/workspace/pbuilder/67537/tmp/hooks/A99_set_merged_usr starting +Re-configuring usrmerge... +removed '/etc/unsupported-skip-usrmerge-conversion' +The system has been successfully converted. +I: user script /srv/workspace/pbuilder/67537/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/pgcopydb-0.10/ && 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 > ../pgcopydb_0.10-1_source.changes dpkg-buildpackage: info: source package pgcopydb dpkg-buildpackage: info: source version 0.10-1 dpkg-buildpackage: info: source distribution unstable @@ -1271,7 +1287,7 @@ make[1]: Leaving directory '/build/pgcopydb-0.10' debian/rules override_dh_auto_test make[1]: Entering directory '/build/pgcopydb-0.10' -PATH=/build/pgcopydb-0.10/src/bin/pgcopydb:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games debian/tests/copydb +PATH=/build/pgcopydb-0.10/src/bin/pgcopydb:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path debian/tests/copydb + WORKDIR=/build/pgcopydb-0.10/debian/home + pg_virtualenv Creating new PostgreSQL cluster 15/regress ... @@ -1282,51 +1298,51 @@ + rm -rf /build/pgcopydb-0.10/debian/home + HOME=/build/pgcopydb-0.10/debian/home + pgcopydb copy-db --source dbname=src --target dbname=dst --dir /build/pgcopydb-0.10/debian/home -11:53:26 16748 INFO Running pgcopydb version 0.10-1 from "/build/pgcopydb-0.10/src/bin/pgcopydb/pgcopydb" -11:53:26 16748 INFO [SOURCE] Copying database from "postgres://@:/src?" -11:53:26 16748 INFO [TARGET] Copying database into "postgres://@:/dst?" -11:53:26 16748 INFO Exported snapshot "00000003-00000010-1" from the source database -11:53:26 16752 INFO STEP 1: dump the source database schema (pre/post data) -11:53:26 16752 INFO /usr/lib/postgresql/15/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section pre-data --file /build/pgcopydb-0.10/debian/home/schema/pre.dump 'postgres://@:/src?' -11:53:26 16752 INFO /usr/lib/postgresql/15/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section post-data --file /build/pgcopydb-0.10/debian/home/schema/post.dump 'postgres://@:/src?' -11:53:26 16752 INFO STEP 2: fetch source database tables, indexes, and sequences -11:53:26 16752 INFO Fetched information for 1 extensions -11:53:26 16752 INFO Fetched information for 1 tables, with an estimated total of 18 quintillion tuples and 8192 B -11:53:26 16752 INFO Fetched information for 0 indexes -11:53:26 16752 INFO Fetching information for 0 sequences -11:53:26 16752 INFO STEP 3: restore the pre-data section to the target database -11:53:26 16752 INFO /usr/lib/postgresql/15/bin/pg_restore --dbname 'postgres://@:/dst?' --single-transaction --use-list /build/pgcopydb-0.10/debian/home/schema/pre.list /build/pgcopydb-0.10/debian/home/schema/pre.dump -11:53:26 16752 INFO STEP 4: copy data from source to target in 1 sub-processes -11:53:26 16752 INFO STEP 5: copy Large Objects (BLOBs) in 1 sub-process -11:53:26 16752 INFO STEP 6: starting 4 CREATE INDEX processes -11:53:26 16752 INFO STEP 7: constraints are built by the CREATE INDEX processes -11:53:26 16752 INFO STEP 8: starting 4 VACUUM processes -11:53:26 16752 INFO STEP 9: reset sequences values -11:53:26 16770 INFO Reset sequences values on the target database -11:53:26 16772 INFO COPY "public"."foo" -11:53:27 16761 INFO Copying large objects -11:53:27 16766 INFO VACUUM ANALYZE "public"."foo"; -11:53:27 16752 INFO COPY phase is done, now waiting for vacuum, index, blob, and sequences processes -11:53:27 16752 INFO STEP 10: restore the post-data section to the target database -11:53:27 16752 INFO /usr/lib/postgresql/15/bin/pg_restore --dbname 'postgres://@:/dst?' --single-transaction --use-list /build/pgcopydb-0.10/debian/home/schema/post.list /build/pgcopydb-0.10/debian/home/schema/post.dump +20:18:42 78549 INFO Running pgcopydb version 0.10-1 from "/build/pgcopydb-0.10/src/bin/pgcopydb/pgcopydb" +20:18:42 78549 INFO [SOURCE] Copying database from "postgres://@:/src?" +20:18:42 78549 INFO [TARGET] Copying database into "postgres://@:/dst?" +20:18:42 78549 INFO Exported snapshot "00000003-00000010-1" from the source database +20:18:42 78560 INFO STEP 1: dump the source database schema (pre/post data) +20:18:42 78560 INFO /usr/lib/postgresql/15/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section pre-data --file /build/pgcopydb-0.10/debian/home/schema/pre.dump 'postgres://@:/src?' +20:18:43 78560 INFO /usr/lib/postgresql/15/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section post-data --file /build/pgcopydb-0.10/debian/home/schema/post.dump 'postgres://@:/src?' +20:18:43 78560 INFO STEP 2: fetch source database tables, indexes, and sequences +20:18:43 78560 INFO Fetched information for 1 extensions +20:18:43 78560 INFO Fetched information for 1 tables, with an estimated total of 18 quintillion tuples and 8192 B +20:18:43 78560 INFO Fetched information for 0 indexes +20:18:43 78560 INFO Fetching information for 0 sequences +20:18:43 78560 INFO STEP 3: restore the pre-data section to the target database +20:18:43 78560 INFO /usr/lib/postgresql/15/bin/pg_restore --dbname 'postgres://@:/dst?' --single-transaction --use-list /build/pgcopydb-0.10/debian/home/schema/pre.list /build/pgcopydb-0.10/debian/home/schema/pre.dump +20:18:43 78560 INFO STEP 4: copy data from source to target in 1 sub-processes +20:18:43 78560 INFO STEP 5: copy Large Objects (BLOBs) in 1 sub-process +20:18:43 78560 INFO STEP 6: starting 4 CREATE INDEX processes +20:18:43 78560 INFO STEP 7: constraints are built by the CREATE INDEX processes +20:18:43 78560 INFO STEP 8: starting 4 VACUUM processes +20:18:43 78560 INFO STEP 9: reset sequences values +20:18:43 78586 INFO Reset sequences values on the target database +20:18:43 78591 INFO COPY "public"."foo" +20:18:43 78583 INFO VACUUM ANALYZE "public"."foo"; +20:18:43 78560 INFO COPY phase is done, now waiting for vacuum, index, blob, and sequences processes +20:18:43 78577 INFO Copying large objects +20:18:43 78560 INFO STEP 10: restore the post-data section to the target database +20:18:43 78560 INFO /usr/lib/postgresql/15/bin/pg_restore --dbname 'postgres://@:/dst?' --single-transaction --use-list /build/pgcopydb-0.10/debian/home/schema/post.list /build/pgcopydb-0.10/debian/home/schema/post.dump OID | Schema | Name | copy duration | indexes | create index duration ------+--------+------+---------------+---------+---------------------- -16386 | public | foo | 24ms | 0 | 0ms +16386 | public | foo | 113ms | 0 | 0ms Step Connection Duration Concurrency -------------------------------------------------- ---------- ---------- ------------ - Dump Schema source 280ms 1 - Catalog Queries (table ordering, filtering, etc) source 17ms 1 - Prepare Schema target 52ms 1 - COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 209ms 1 + 5 - COPY (cumulative) both 24ms 1 - Large Objects (cumulative) both 67ms 1 + Dump Schema source 445ms 1 + Catalog Queries (table ordering, filtering, etc) source 44ms 1 + Prepare Schema target 93ms 1 + COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 334ms 1 + 5 + COPY (cumulative) both 113ms 1 + Large Objects (cumulative) both 297ms 1 CREATE INDEX, CONSTRAINTS (cumulative) target 0ms 4 - Finalize Schema target 45ms 1 + Finalize Schema target 59ms 1 -------------------------------------------------- ---------- ---------- ------------ - Total Wall Clock Duration both 606ms 1 + 5 + Total Wall Clock Duration both 977ms 1 + 5 -------------------------------------------------- ---------- ---------- ------------ + pg_dump -t foo dst @@ -1353,7 +1369,7 @@ SET default_table_access_method = heap; -- --- Name: foo; Type: TABLE; Schema: public; Owner: pbuilder1 +-- Name: foo; Type: TABLE; Schema: public; Owner: pbuilder2 -- CREATE TABLE public.foo ( @@ -1361,10 +1377,10 @@ ); -ALTER TABLE public.foo OWNER TO pbuilder1; +ALTER TABLE public.foo OWNER TO pbuilder2; -- --- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: pbuilder1 +-- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: pbuilder2 -- COPY public.foo ("?column?") FROM stdin; @@ -1376,8 +1392,8 @@ -- PostgreSQL database dump complete -- -+ pg_dump -t foo dst + grep 579 ++ pg_dump -t foo dst 579 Dropping cluster 15/regress ... make[1]: Leaving directory '/build/pgcopydb-0.10' @@ -1417,8 +1433,8 @@ dh_gencontrol dh_md5sums dh_builddeb -dpkg-deb: building package 'pgcopydb' in '../pgcopydb_0.10-1_i386.deb'. dpkg-deb: building package 'pgcopydb-dbgsym' in '../pgcopydb-dbgsym_0.10-1_i386.deb'. +dpkg-deb: building package 'pgcopydb' in '../pgcopydb_0.10-1_i386.deb'. dpkg-genbuildinfo --build=binary -O../pgcopydb_0.10-1_i386.buildinfo dpkg-genchanges --build=binary -O../pgcopydb_0.10-1_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) @@ -1426,12 +1442,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/67537/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/67537/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/3877 and its subdirectories -I: Current time: Thu Apr 13 11:53:35 -12 2023 -I: pbuilder-time-stamp: 1681430015 +I: removing directory /srv/workspace/pbuilder/67537 and its subdirectories +I: Current time: Thu May 16 20:18:58 +14 2024 +I: pbuilder-time-stamp: 1715840338