Diff of the two buildlogs: -- --- b1/build.log 2023-04-14 23:42:50.862645385 +0000 +++ b2/build.log 2023-04-14 23:44:12.803008109 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri Apr 14 11:35:24 -12 2023 -I: pbuilder-time-stamp: 1681515324 +I: Current time: Fri May 17 20:05:53 +14 2024 +I: pbuilder-time-stamp: 1715925953 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bookworm-reproducible-base.tgz] I: copying local configuration @@ -16,7 +16,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 @@ -25,135 +25,144 @@ 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/377756/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/3363805/tmp/hooks/D01_modify_environment starting +debug: Running on ionos15-amd64. +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/3363805/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/3363805/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='amd64' DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=15' + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=16' DISTRIBUTION='bookworm' HOME='/root' HOST_ARCH='amd64' IFS=' ' - INVOCATION_ID='5f79c33988e64359947cea7c85216636' + INVOCATION_ID='b4b0bf8f612143bc94db5dcb43a4916f' LANG='C' - LANGUAGE='en_US:en' + LANGUAGE='et_EE:et' LC_ALL='C' 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='377756' + PPID='3363805' 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.sVyCA0UB/pbuilderrc_6h4O --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.sVyCA0UB/b1 --logfile b1/build.log pgcopydb_0.10-1.dsc' - SUDO_GID='110' - SUDO_UID='105' + 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.sVyCA0UB/pbuilderrc_sAu9 --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.sVyCA0UB/b2 --logfile b2/build.log --extrapackages usrmerge pgcopydb_0.10-1.dsc' + SUDO_GID='111' + SUDO_UID='106' 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 ionos1-amd64 5.10.0-21-amd64 #1 SMP Debian 5.10.162-1 (2023-01-21) x86_64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-0.deb11.5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.12-1~bpo11+1 (2023-03-05) x86_64 GNU/Linux I: ls -l /bin total 5632 - -rwxr-xr-x 1 root root 1265648 Feb 12 08:05 bash - -rwxr-xr-x 3 root root 39224 Sep 18 2022 bunzip2 - -rwxr-xr-x 3 root root 39224 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 39224 Sep 18 2022 bzip2 - -rwxr-xr-x 1 root root 14568 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 44016 Sep 20 2022 cat - -rwxr-xr-x 1 root root 68656 Sep 20 2022 chgrp - -rwxr-xr-x 1 root root 64496 Sep 20 2022 chmod - -rwxr-xr-x 1 root root 72752 Sep 20 2022 chown - -rwxr-xr-x 1 root root 151152 Sep 20 2022 cp - -rwxr-xr-x 1 root root 125640 Jan 5 01:20 dash - -rwxr-xr-x 1 root root 121904 Sep 20 2022 date - -rwxr-xr-x 1 root root 89240 Sep 20 2022 dd - -rwxr-xr-x 1 root root 102200 Sep 20 2022 df - -rwxr-xr-x 1 root root 151344 Sep 20 2022 dir - -rwxr-xr-x 1 root root 88656 Mar 22 22:02 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 43856 Sep 20 2022 echo - -rwxr-xr-x 1 root root 41 Jan 24 02:43 egrep - -rwxr-xr-x 1 root root 35664 Sep 20 2022 false - -rwxr-xr-x 1 root root 41 Jan 24 02:43 fgrep - -rwxr-xr-x 1 root root 85600 Mar 22 22:02 findmnt - -rwsr-xr-x 1 root root 35128 Mar 22 20:35 fusermount - -rwxr-xr-x 1 root root 203152 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 98136 Apr 9 2022 gzip - -rwxr-xr-x 1 root root 22680 Dec 19 01:33 hostname - -rwxr-xr-x 1 root root 72824 Sep 20 2022 ln - -rwxr-xr-x 1 root root 53024 Mar 23 00:40 login - -rwxr-xr-x 1 root root 151344 Sep 20 2022 ls - -rwxr-xr-x 1 root root 207168 Mar 22 22:02 lsblk - -rwxr-xr-x 1 root root 97552 Sep 20 2022 mkdir - -rwxr-xr-x 1 root root 72912 Sep 20 2022 mknod - -rwxr-xr-x 1 root root 43952 Sep 20 2022 mktemp - -rwxr-xr-x 1 root root 59712 Mar 22 22:02 more - -rwsr-xr-x 1 root root 59704 Mar 22 22:02 mount - -rwxr-xr-x 1 root root 18744 Mar 22 22:02 mountpoint - -rwxr-xr-x 1 root root 142968 Sep 20 2022 mv - lrwxrwxrwx 1 root root 8 Dec 19 01:33 nisdomainname -> hostname - lrwxrwxrwx 1 root root 14 Apr 2 18:25 pidof -> /sbin/killall5 - -rwxr-xr-x 1 root root 43952 Sep 20 2022 pwd - lrwxrwxrwx 1 root root 4 Feb 12 08:05 rbash -> bash - -rwxr-xr-x 1 root root 52112 Sep 20 2022 readlink - -rwxr-xr-x 1 root root 72752 Sep 20 2022 rm - -rwxr-xr-x 1 root root 56240 Sep 20 2022 rmdir - -rwxr-xr-x 1 root root 27560 Nov 2 04:31 run-parts - -rwxr-xr-x 1 root root 126424 Jan 5 07:55 sed - lrwxrwxrwx 1 root root 4 Jan 5 01:20 sh -> dash - -rwxr-xr-x 1 root root 43888 Sep 20 2022 sleep - -rwxr-xr-x 1 root root 85008 Sep 20 2022 stty - -rwsr-xr-x 1 root root 72000 Mar 22 22:02 su - -rwxr-xr-x 1 root root 39824 Sep 20 2022 sync - -rwxr-xr-x 1 root root 531984 Apr 6 02:25 tar - -rwxr-xr-x 1 root root 14520 Nov 2 04:31 tempfile - -rwxr-xr-x 1 root root 109616 Sep 20 2022 touch - -rwxr-xr-x 1 root root 35664 Sep 20 2022 true - -rwxr-xr-x 1 root root 14568 Mar 22 20:35 ulockmgr_server - -rwsr-xr-x 1 root root 35128 Mar 22 22:02 umount - -rwxr-xr-x 1 root root 43888 Sep 20 2022 uname - -rwxr-xr-x 2 root root 2346 Apr 9 2022 uncompress - -rwxr-xr-x 1 root root 151344 Sep 20 2022 vdir - -rwxr-xr-x 1 root root 72024 Mar 22 22:02 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/377756/tmp/hooks/D02_print_environment finished + -rwxr-xr-x 1 root root 1265648 Feb 13 2023 bash + -rwxr-xr-x 3 root root 39224 Sep 19 2022 bunzip2 + -rwxr-xr-x 3 root root 39224 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 39224 Sep 19 2022 bzip2 + -rwxr-xr-x 1 root root 14568 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 44016 Sep 21 2022 cat + -rwxr-xr-x 1 root root 68656 Sep 21 2022 chgrp + -rwxr-xr-x 1 root root 64496 Sep 21 2022 chmod + -rwxr-xr-x 1 root root 72752 Sep 21 2022 chown + -rwxr-xr-x 1 root root 151152 Sep 21 2022 cp + -rwxr-xr-x 1 root root 125640 Jan 6 2023 dash + -rwxr-xr-x 1 root root 121904 Sep 21 2022 date + -rwxr-xr-x 1 root root 89240 Sep 21 2022 dd + -rwxr-xr-x 1 root root 102200 Sep 21 2022 df + -rwxr-xr-x 1 root root 151344 Sep 21 2022 dir + -rwxr-xr-x 1 root root 88656 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 43856 Sep 21 2022 echo + -rwxr-xr-x 1 root root 41 Jan 25 2023 egrep + -rwxr-xr-x 1 root root 35664 Sep 21 2022 false + -rwxr-xr-x 1 root root 41 Jan 25 2023 fgrep + -rwxr-xr-x 1 root root 85600 Mar 24 2023 findmnt + -rwsr-xr-x 1 root root 35128 Mar 23 2023 fusermount + -rwxr-xr-x 1 root root 203152 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 98136 Apr 10 2022 gzip + -rwxr-xr-x 1 root root 22680 Dec 20 2022 hostname + -rwxr-xr-x 1 root root 72824 Sep 21 2022 ln + -rwxr-xr-x 1 root root 53024 Mar 24 2023 login + -rwxr-xr-x 1 root root 151344 Sep 21 2022 ls + -rwxr-xr-x 1 root root 207168 Mar 24 2023 lsblk + -rwxr-xr-x 1 root root 97552 Sep 21 2022 mkdir + -rwxr-xr-x 1 root root 72912 Sep 21 2022 mknod + -rwxr-xr-x 1 root root 43952 Sep 21 2022 mktemp + -rwxr-xr-x 1 root root 59712 Mar 24 2023 more + -rwsr-xr-x 1 root root 59704 Mar 24 2023 mount + -rwxr-xr-x 1 root root 18744 Mar 24 2023 mountpoint + -rwxr-xr-x 1 root root 142968 Sep 21 2022 mv + lrwxrwxrwx 1 root root 8 Dec 20 2022 nisdomainname -> hostname + lrwxrwxrwx 1 root root 14 Apr 3 2023 pidof -> /sbin/killall5 + -rwxr-xr-x 1 root root 43952 Sep 21 2022 pwd + lrwxrwxrwx 1 root root 4 Feb 13 2023 rbash -> bash + -rwxr-xr-x 1 root root 52112 Sep 21 2022 readlink + -rwxr-xr-x 1 root root 72752 Sep 21 2022 rm + -rwxr-xr-x 1 root root 56240 Sep 21 2022 rmdir + -rwxr-xr-x 1 root root 27560 Nov 3 2022 run-parts + -rwxr-xr-x 1 root root 126424 Jan 6 2023 sed + lrwxrwxrwx 1 root root 4 Jan 6 2023 sh -> dash + -rwxr-xr-x 1 root root 43888 Sep 21 2022 sleep + -rwxr-xr-x 1 root root 85008 Sep 21 2022 stty + -rwsr-xr-x 1 root root 72000 Mar 24 2023 su + -rwxr-xr-x 1 root root 39824 Sep 21 2022 sync + -rwxr-xr-x 1 root root 531984 Apr 7 2023 tar + -rwxr-xr-x 1 root root 14520 Nov 3 2022 tempfile + -rwxr-xr-x 1 root root 109616 Sep 21 2022 touch + -rwxr-xr-x 1 root root 35664 Sep 21 2022 true + -rwxr-xr-x 1 root root 14568 Mar 23 2023 ulockmgr_server + -rwsr-xr-x 1 root root 35128 Mar 24 2023 umount + -rwxr-xr-x 1 root root 43888 Sep 21 2022 uname + -rwxr-xr-x 2 root root 2346 Apr 10 2022 uncompress + -rwxr-xr-x 1 root root 151344 Sep 21 2022 vdir + -rwxr-xr-x 1 root root 72024 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/3363805/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -365,7 +374,7 @@ Get: 146 http://deb.debian.org/debian bookworm/main amd64 sphinx-common all 5.3.0-4 [653 kB] Get: 147 http://deb.debian.org/debian bookworm/main amd64 python3-sphinx all 5.3.0-4 [549 kB] Get: 148 http://deb.debian.org/debian bookworm/main amd64 zlib1g-dev amd64 1:1.2.13.dfsg-1 [916 kB] -Fetched 175 MB in 11s (15.6 MB/s) +Fetched 175 MB in 2s (97.7 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 ... 19596 files and directories currently installed.) @@ -956,7 +965,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 @@ -1019,10 +1028,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/3363805/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/3363805/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 @@ -1156,7 +1172,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 ... @@ -1167,51 +1183,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:42:00 451853 INFO Running pgcopydb version 0.10-1 from "/build/pgcopydb-0.10/src/bin/pgcopydb/pgcopydb" -11:42:00 451853 INFO [SOURCE] Copying database from "postgres://@:/src?" -11:42:00 451853 INFO [TARGET] Copying database into "postgres://@:/dst?" -11:42:01 451853 INFO Exported snapshot "00000003-00000010-1" from the source database -11:42:01 451909 INFO STEP 1: dump the source database schema (pre/post data) -11:42:01 451909 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:42:01 451909 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:42:02 451909 INFO STEP 2: fetch source database tables, indexes, and sequences -11:42:02 451909 INFO Fetched information for 1 extensions -11:42:02 451909 INFO Fetched information for 1 tables, with an estimated total of 18 quintillion tuples and 8192 B -11:42:02 451909 INFO Fetched information for 0 indexes -11:42:02 451909 INFO Fetching information for 0 sequences -11:42:02 451909 INFO STEP 3: restore the pre-data section to the target database -11:42:02 451909 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:42:03 451909 INFO STEP 4: copy data from source to target in 1 sub-processes -11:42:03 451909 INFO STEP 5: copy Large Objects (BLOBs) in 1 sub-process -11:42:03 451909 INFO STEP 6: starting 4 CREATE INDEX processes -11:42:03 451909 INFO STEP 7: constraints are built by the CREATE INDEX processes -11:42:03 451909 INFO STEP 8: starting 4 VACUUM processes -11:42:03 451909 INFO STEP 9: reset sequences values -11:42:03 452378 INFO Reset sequences values on the target database -11:42:03 452381 INFO COPY "public"."foo" -11:42:03 452366 INFO Copying large objects -11:42:03 452373 INFO VACUUM ANALYZE "public"."foo"; -11:42:03 451909 INFO COPY phase is done, now waiting for vacuum, index, blob, and sequences processes -11:42:03 451909 INFO STEP 10: restore the post-data section to the target database -11:42:03 451909 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:07:05 3371168 INFO Running pgcopydb version 0.10-1 from "/build/pgcopydb-0.10/src/bin/pgcopydb/pgcopydb" +20:07:05 3371168 INFO [SOURCE] Copying database from "postgres://@:/src?" +20:07:05 3371168 INFO [TARGET] Copying database into "postgres://@:/dst?" +20:07:05 3371168 INFO Exported snapshot "00000003-00000010-1" from the source database +20:07:05 3371172 INFO STEP 1: dump the source database schema (pre/post data) +20:07:05 3371172 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:07:06 3371172 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:07:06 3371172 INFO STEP 2: fetch source database tables, indexes, and sequences +20:07:06 3371172 INFO Fetched information for 1 extensions +20:07:06 3371172 INFO Fetched information for 1 tables, with an estimated total of 18 quintillion tuples and 8192 B +20:07:06 3371172 INFO Fetched information for 0 indexes +20:07:06 3371172 INFO Fetching information for 0 sequences +20:07:06 3371172 INFO STEP 3: restore the pre-data section to the target database +20:07:06 3371172 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:07:06 3371172 INFO STEP 4: copy data from source to target in 1 sub-processes +20:07:06 3371172 INFO STEP 5: copy Large Objects (BLOBs) in 1 sub-process +20:07:06 3371172 INFO STEP 6: starting 4 CREATE INDEX processes +20:07:06 3371172 INFO STEP 7: constraints are built by the CREATE INDEX processes +20:07:06 3371172 INFO STEP 8: starting 4 VACUUM processes +20:07:06 3371172 INFO STEP 9: reset sequences values +20:07:06 3371191 INFO Reset sequences values on the target database +20:07:06 3371193 INFO COPY "public"."foo" +20:07:06 3371181 INFO Copying large objects +20:07:06 3371186 INFO VACUUM ANALYZE "public"."foo"; +20:07:06 3371172 INFO COPY phase is done, now waiting for vacuum, index, blob, and sequences processes +20:07:06 3371172 INFO STEP 10: restore the post-data section to the target database +20:07:06 3371172 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 | 133ms | 0 | 0ms +16386 | public | foo | 19ms | 0 | 0ms Step Connection Duration Concurrency -------------------------------------------------- ---------- ---------- ------------ - Dump Schema source 1s457 1 - Catalog Queries (table ordering, filtering, etc) source 60ms 1 - Prepare Schema target 358ms 1 - COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 553ms 1 + 5 - COPY (cumulative) both 133ms 1 - Large Objects (cumulative) both 252ms 1 + Dump Schema source 232ms 1 + Catalog Queries (table ordering, filtering, etc) source 16ms 1 + Prepare Schema target 54ms 1 + COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 213ms 1 + 5 + COPY (cumulative) both 19ms 1 + Large Objects (cumulative) both 44ms 1 CREATE INDEX, CONSTRAINTS (cumulative) target 0ms 4 - Finalize Schema target 323ms 1 + Finalize Schema target 48ms 1 -------------------------------------------------- ---------- ---------- ------------ - Total Wall Clock Duration both 2s753 1 + 5 + Total Wall Clock Duration both 566ms 1 + 5 -------------------------------------------------- ---------- ---------- ------------ + pg_dump -t foo dst @@ -1238,7 +1254,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 ( @@ -1246,10 +1262,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; @@ -1261,8 +1277,8 @@ -- PostgreSQL database dump complete -- -+ grep 579 + pg_dump -t foo dst ++ grep 579 579 Dropping cluster 15/regress ... make[1]: Leaving directory '/build/pgcopydb-0.10' @@ -1302,8 +1318,8 @@ dh_gencontrol dh_md5sums dh_builddeb -dpkg-deb: building package 'pgcopydb-dbgsym' in '../pgcopydb-dbgsym_0.10-1_amd64.deb'. dpkg-deb: building package 'pgcopydb' in '../pgcopydb_0.10-1_amd64.deb'. +dpkg-deb: building package 'pgcopydb-dbgsym' in '../pgcopydb-dbgsym_0.10-1_amd64.deb'. dpkg-genbuildinfo --build=binary -O../pgcopydb_0.10-1_amd64.buildinfo dpkg-genchanges --build=binary -O../pgcopydb_0.10-1_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) @@ -1311,12 +1327,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/3363805/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/3363805/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/377756 and its subdirectories -I: Current time: Fri Apr 14 11:42:49 -12 2023 -I: pbuilder-time-stamp: 1681515769 +I: removing directory /srv/workspace/pbuilder/3363805 and its subdirectories +I: Current time: Fri May 17 20:07:13 +14 2024 +I: pbuilder-time-stamp: 1715926033