Running as unit: rb-build-amd64_31-62382.service; invocation ID: 33d7cd62c5814425b47fb49193bc4d04 ==================================================================================== Fri Oct 31 17:51:47 UTC 2025 - running /srv/jenkins/bin/reproducible_build.sh (for job reproducible_builder_amd64_31) on jenkins, called using "ionos11-amd64 ionos5-amd64" as arguments. Fri Oct 31 17:51:47 UTC 2025 - actually running "reproducible_build.sh" (md5sum bcb6fe1b50cf4e8eedacd0971a9eb63f) as "/tmp/jenkins-script-z28o1jGk" $ git clone https://salsa.debian.org/qa/jenkins.debian.net.git ; more CONTRIBUTING Fri Oct 31 17:51:47 UTC 2025 - checking /var/lib/jenkins/offline_nodes if ionos11-amd64.debian.net is marked as down. Fri Oct 31 17:51:47 UTC 2025 - checking via ssh if ionos11-amd64.debian.net is up. removed '/tmp/read-only-fs-test-W0TTz3' Fri Oct 31 17:51:47 UTC 2025 - checking /var/lib/jenkins/offline_nodes if ionos5-amd64.debian.net is marked as down. Fri Oct 31 17:51:47 UTC 2025 - checking via ssh if ionos5-amd64.debian.net is up. removed '/tmp/read-only-fs-test-cT6OTE' ok, let's check if sqlreduce is building anywhere yet… ok, sqlreduce is not building anywhere… UPDATE 1 ============================================================================= Initialising reproducibly build of sqlreduce in forky on amd64 on jenkins now. 1st build will be done on ionos11-amd64.debian.net. 2nd build will be done on ionos5-amd64.debian.net. ============================================================================= Fri Oct 31 17:51:54 UTC 2025 I: starting to build sqlreduce/forky/amd64 on jenkins on '2025-10-31 17:51' Fri Oct 31 17:51:54 UTC 2025 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/amd64_31/62382/console.log 1761933114 amd64 forky sqlreduce Fri Oct 31 17:51:54 UTC 2025 I: Downloading source for forky/sqlreduce=1.3-1 --2025-10-31 17:51:54-- http://deb.debian.org/debian/pool/main/s/sqlreduce/sqlreduce_1.3-1.dsc Connecting to 46.16.76.132:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2039 (2.0K) [text/prs.lines.tag] Saving to: ‘sqlreduce_1.3-1.dsc’ 0K . 100% 226M=0s 2025-10-31 17:51:54 (226 MB/s) - ‘sqlreduce_1.3-1.dsc’ saved [2039/2039] --2025-10-31 17:51:54-- http://deb.debian.org/debian/pool/main/s/sqlreduce/sqlreduce_1.3-1.dsc Connecting to 46.16.76.132:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2039 (2.0K) [text/prs.lines.tag] Saving to: ‘sqlreduce_1.3-1.dsc’ 0K . 100% 226M=0s 2025-10-31 17:51:54 (226 MB/s) - ‘sqlreduce_1.3-1.dsc’ saved [2039/2039] Fri Oct 31 17:51:54 UTC 2025 I: sqlreduce_1.3-1.dsc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 3.0 (quilt) Source: sqlreduce Binary: sqlreduce Architecture: all Version: 1.3-1 Maintainer: Christoph Berg Homepage: https://github.com/df7cb/sqlreduce Standards-Version: 4.6.0 Vcs-Browser: https://github.com/df7cb/sqlreduce Vcs-Git: https://github.com/df7cb/sqlreduce.git Testsuite: autopkgtest, autopkgtest-pkg-python Testsuite-Triggers: postgresql Build-Depends: debhelper-compat (= 13), dh-python, help2man , postgresql , python3-all, python3-pglast, python3-psycopg2, python3-pytest, python3-setuptools, python3-yaml Package-List: sqlreduce deb python optional arch=all Checksums-Sha1: 5bbe28abf29a56d9edf298fdaba6bcfa88813196 12007356 sqlreduce_1.3.orig.tar.gz f4a6a8a5a408ae204e86ed1e02063c39073d5d1a 2304 sqlreduce_1.3-1.debian.tar.xz Checksums-Sha256: 75eba952fa3ebb1a96555bac62280795d1c2786b6f91e5ab657505d0da268d37 12007356 sqlreduce_1.3.orig.tar.gz 8fc39fc75a5a730dcc752376e21de1889eabace457b6622cf93fb2f1d6be8ac7 2304 sqlreduce_1.3-1.debian.tar.xz Files: 95f516def5d76be98b334ae3dfa78acb 12007356 sqlreduce_1.3.orig.tar.gz 1308909482a723b545d600f6eb1fbcc3 2304 sqlreduce_1.3-1.debian.tar.xz -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAmW45hgACgkQTFprqxLS p66d8g//b0M0zbiga/UuuLQgq6+Dh0iBjaDFC27X8aL/R237gNCT0Ya+crMPouNP EHqpuA/7Uaz58F/Xd5ZiVPwTt3ZH8/h5+WxtGu9lCRogygN039vH6KSb/Li299cV /r+IizRHZ58VV8qRqL14TEqnCxoDipftt62egfK65xMbE+AxsFqy+saUy4QTKQ2N wrwv8bDsSXw6oSZKjSeH8eW08Rjy+7VIW3xiYgA0px9cXbdxYb07hrd6duztQTk6 M9EbPCSKcVn2lYT7S2KCXXVlY+seu3b8nfLxhAEL+q3uZ52VKBHdONRs9ybzMp3L V6DUwcUlLqrNLL0QpYUxR5TbghqW7r9YKMrmhz9VeIUxDUZ3qoW5YX6U/p8SxkvG 9pY1/hHcNShjskZp8LJmJbALwsMiouJd5O5EczIeoyjLWbFifKxerSKNZI4Xa025 zfdSumWRUzU7EwD61CQso2A9+NaiwygDYccIbmEWesf3hCCs7a73reNTJjFuOMhv G15MRV7Gw25iVRrtB2x9QELlQOhuTjQpWOI0a7yq4ImIwIRZ2PB1INDWQBmsZYCh 0cxuB5WMLBC1hSqA5dRydQMw2UDyE3bTa1WISu+Vfb0bG4XCHYs6uTIg+8kesjDJ Day1zcn+47DgWSJpU3od+oYKlJ4CNQbmhJxpmszGnwZi2CKE+1M= =GyKA -----END PGP SIGNATURE----- Fri Oct 31 17:51:54 UTC 2025 I: Checking whether the package is not for us Fri Oct 31 17:51:54 UTC 2025 I: Starting 1st build on remote node ionos11-amd64.debian.net. Fri Oct 31 17:51:54 UTC 2025 I: Preparing to do remote build '1' on ionos11-amd64.debian.net. Fri Oct 31 17:51:54 UTC 2025 - checking /var/lib/jenkins/offline_nodes if ionos11-amd64.debian.net is marked as down. Fri Oct 31 17:51:54 UTC 2025 - checking via ssh if ionos11-amd64.debian.net is up. removed '/tmp/read-only-fs-test-12tyPE' ==================================================================================== Fri Oct 31 17:51:55 UTC 2025 - running /srv/jenkins/bin/reproducible_build.sh (for job /srv/jenkins/bin/reproducible_build.sh) on ionos11-amd64, called using "1 sqlreduce forky /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY 1.3-1" as arguments. Fri Oct 31 17:51:55 UTC 2025 - actually running "reproducible_build.sh" (md5sum bcb6fe1b50cf4e8eedacd0971a9eb63f) as "/tmp/jenkins-script-DFkmRqlf" $ git clone https://salsa.debian.org/qa/jenkins.debian.net.git ; more CONTRIBUTING Fri Oct 31 17:51:55 UTC 2025 I: Downloading source for forky/sqlreduce=1.3-1 Reading package lists... NOTICE: 'sqlreduce' packaging is maintained in the 'Git' version control system at: https://github.com/df7cb/sqlreduce.git Please use: git clone https://github.com/df7cb/sqlreduce.git to retrieve the latest (possibly unreleased) updates to the package. Need to get 12.0 MB of source archives. Get:1 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (dsc) [2039 B] Get:2 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (tar) [12.0 MB] Get:3 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (diff) [2304 B] Fetched 12.0 MB in 0s (136 MB/s) Download complete and in download only mode Reading package lists... NOTICE: 'sqlreduce' packaging is maintained in the 'Git' version control system at: https://github.com/df7cb/sqlreduce.git Please use: git clone https://github.com/df7cb/sqlreduce.git to retrieve the latest (possibly unreleased) updates to the package. Need to get 12.0 MB of source archives. Get:1 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (dsc) [2039 B] Get:2 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (tar) [12.0 MB] Get:3 http://deb.debian.org/debian forky/main sqlreduce 1.3-1 (diff) [2304 B] Fetched 12.0 MB in 0s (136 MB/s) Download complete and in download only mode ============================================================================= Building sqlreduce in forky on amd64 on ionos11-amd64 now. Date: Fri Oct 31 17:51:55 UTC 2025 Date UTC: Fri Oct 31 17:51:55 UTC 2025 ============================================================================= W: /root/.pbuilderrc does not exist I: Logging to b1/build.log I: pbuilder: network access will be disabled during build I: Current time: Fri Oct 31 05:51:55 -12 2025 I: pbuilder-time-stamp: 1761933115 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/forky-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [sqlreduce_1.3-1.dsc] I: copying [./sqlreduce_1.3.orig.tar.gz] I: copying [./sqlreduce_1.3-1.debian.tar.xz] I: Extracting source dpkg-source: warning: cannot verify inline signature for ./sqlreduce_1.3-1.dsc: no acceptable signature found dpkg-source: info: extracting sqlreduce in sqlreduce-1.3 dpkg-source: info: unpacking sqlreduce_1.3.orig.tar.gz dpkg-source: info: unpacking sqlreduce_1.3-1.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/2117968/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='amd64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=40 ' DISTRIBUTION='forky' HOME='/root' HOST_ARCH='amd64' IFS=' ' INVOCATION_ID='929e41747c7c4a5e847252d432c9881c' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' 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='2117968' 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.fbfXXHqY/pbuilderrc_c2h5 --distribution forky --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY/b1 --logfile b1/build.log sqlreduce_1.3-1.dsc' SUDO_GID='111' SUDO_HOME='/var/lib/jenkins' SUDO_UID='106' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://46.16.76.132:3128' I: uname -a Linux ionos11-amd64 6.12.48+deb13-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.48-1 (2025-09-20) x86_64 GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 Aug 10 12:30 /bin -> usr/bin I: user script /srv/workspace/pbuilder/2117968/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 13), dh-python, help2man, postgresql, python3-all, python3-pglast, python3-psycopg2, python3-pytest, python3-setuptools, python3-yaml dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19869 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 13); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-python; however: Package dh-python is not installed. pbuilder-satisfydepends-dummy depends on help2man; however: Package help2man is not installed. pbuilder-satisfydepends-dummy depends on postgresql; however: Package postgresql is not installed. pbuilder-satisfydepends-dummy depends on python3-all; however: Package python3-all is not installed. pbuilder-satisfydepends-dummy depends on python3-pglast; however: Package python3-pglast is not installed. pbuilder-satisfydepends-dummy depends on python3-psycopg2; however: Package python3-psycopg2 is not installed. pbuilder-satisfydepends-dummy depends on python3-pytest; however: Package python3-pytest is not installed. pbuilder-satisfydepends-dummy depends on python3-setuptools; however: Package python3-setuptools is not installed. pbuilder-satisfydepends-dummy depends on python3-yaml; however: Package python3-yaml is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-python{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} groff-base{a} help2man{a} intltool-debian{a} libarchive-zip-perl{a} libcom-err2{a} libdebhelper-perl{a} libelf1t64{a} libexpat1{a} libffi8{a} libfile-stripnondeterminism-perl{a} libgcrypt20{a} libgpg-error0{a} libgssapi-krb5-2{a} libicu76{a} libio-pty-perl{a} libipc-run-perl{a} libjson-perl{a} libk5crypto3{a} libkeyutils1{a} libkrb5-3{a} libkrb5support0{a} libldap2{a} liblocale-gettext-perl{a} libmagic-mgc{a} libmagic1t64{a} libnuma1{a} libpg-query1706.0{a} libpipeline1{a} libpq5{a} libproc2-0{a} libpython3-stdlib{a} libpython3.13-minimal{a} libpython3.13-stdlib{a} libreadline8t64{a} libsasl2-2{a} libsasl2-modules-db{a} libtext-charwidth-perl{a} libtext-wrapi18n-perl{a} libtool{a} libuchardet0{a} libunistring5{a} liburing2{a} libxml2-16{a} libxslt1.1{a} libyaml-0-2{a} m4{a} man-db{a} media-types{a} netbase{a} openssl{a} po-debconf{a} postgresql{a} postgresql-18{a} postgresql-client-18{a} postgresql-client-common{a} postgresql-common{a} postgresql-common-dev{a} procps{a} python3{a} python3-all{a} python3-autocommand{a} python3-inflect{a} python3-iniconfig{a} python3-jaraco.context{a} python3-jaraco.functools{a} python3-jaraco.text{a} python3-minimal{a} python3-more-itertools{a} python3-packaging{a} python3-pglast{a} python3-pkg-resources{a} python3-pluggy{a} python3-psycopg2{a} python3-pygments{a} python3-pytest{a} python3-setuptools{a} python3-typeguard{a} python3-typing-extensions{a} python3-yaml{a} python3-zipp{a} python3.13{a} python3.13-minimal{a} readline-common{a} sensible-utils{a} ssl-cert{a} tzdata{a} ucf{a} The following packages are RECOMMENDED but will NOT be installed: ca-certificates curl e2fsprogs krb5-locales libarchive-cpio-perl libgpg-error-l10n libjson-xs-perl libldap-common libltdl-dev libmail-sendmail-perl libsasl2-modules linux-sysctl-defaults logrotate lynx postgresql-18-jit psmisc sysstat wget 0 packages upgraded, 100 newly installed, 0 to remove and 0 not upgraded. Need to get 46.3 MB of archives. After unpacking 187 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian forky/main amd64 libexpat1 amd64 2.7.3-1 [112 kB] Get: 2 http://deb.debian.org/debian forky/main amd64 liblocale-gettext-perl amd64 1.07-7+b1 [15.3 kB] Get: 3 http://deb.debian.org/debian forky/main amd64 libjson-perl all 4.10000-1 [87.5 kB] Get: 4 http://deb.debian.org/debian forky/main amd64 netbase all 6.5 [12.4 kB] Get: 5 http://deb.debian.org/debian forky/main amd64 postgresql-client-common all 286 [47.9 kB] Get: 6 http://deb.debian.org/debian forky/main amd64 libio-pty-perl amd64 1:1.20-1+b3 [34.3 kB] Get: 7 http://deb.debian.org/debian forky/main amd64 libipc-run-perl all 20231003.0-2 [101 kB] Get: 8 http://deb.debian.org/debian forky/main amd64 postgresql-common-dev all 286 [73.2 kB] Get: 9 http://deb.debian.org/debian forky/main amd64 openssl amd64 3.5.4-1 [1496 kB] Get: 10 http://deb.debian.org/debian forky/main amd64 ssl-cert all 1.1.3 [16.8 kB] Get: 11 http://deb.debian.org/debian forky/main amd64 libtext-charwidth-perl amd64 0.04-11+b4 [9476 B] Get: 12 http://deb.debian.org/debian forky/main amd64 libtext-wrapi18n-perl all 0.06-10 [8808 B] Get: 13 http://deb.debian.org/debian forky/main amd64 libproc2-0 amd64 2:4.0.4-9 [65.6 kB] Get: 14 http://deb.debian.org/debian forky/main amd64 procps amd64 2:4.0.4-9 [882 kB] Get: 15 http://deb.debian.org/debian forky/main amd64 sensible-utils all 0.0.26 [27.0 kB] Get: 16 http://deb.debian.org/debian forky/main amd64 ucf all 3.0052 [43.3 kB] Get: 17 http://deb.debian.org/debian forky/main amd64 postgresql-common all 286 [112 kB] Get: 18 http://deb.debian.org/debian forky/main amd64 libpython3.13-minimal amd64 3.13.9-1 [865 kB] Get: 19 http://deb.debian.org/debian forky/main amd64 python3.13-minimal amd64 3.13.9-1 [2257 kB] Get: 20 http://deb.debian.org/debian forky/main amd64 python3-minimal amd64 3.13.7-1 [27.2 kB] Get: 21 http://deb.debian.org/debian forky/main amd64 media-types all 14.0.0 [30.8 kB] Get: 22 http://deb.debian.org/debian forky/main amd64 tzdata all 2025b-5 [260 kB] Get: 23 http://deb.debian.org/debian forky/main amd64 libffi8 amd64 3.5.2-2 [25.5 kB] Get: 24 http://deb.debian.org/debian forky/main amd64 readline-common all 8.3-3 [74.8 kB] Get: 25 http://deb.debian.org/debian forky/main amd64 libreadline8t64 amd64 8.3-3 [191 kB] Get: 26 http://deb.debian.org/debian forky/main amd64 libpython3.13-stdlib amd64 3.13.9-1 [1965 kB] Get: 27 http://deb.debian.org/debian forky/main amd64 python3.13 amd64 3.13.9-1 [764 kB] Get: 28 http://deb.debian.org/debian forky/main amd64 libpython3-stdlib amd64 3.13.7-1 [10.2 kB] Get: 29 http://deb.debian.org/debian forky/main amd64 python3 amd64 3.13.7-1 [28.3 kB] Get: 30 http://deb.debian.org/debian forky/main amd64 libmagic-mgc amd64 1:5.46-5 [338 kB] Get: 31 http://deb.debian.org/debian forky/main amd64 libmagic1t64 amd64 1:5.46-5 [109 kB] Get: 32 http://deb.debian.org/debian forky/main amd64 file amd64 1:5.46-5 [43.6 kB] Get: 33 http://deb.debian.org/debian forky/main amd64 gettext-base amd64 0.23.1-2+b1 [244 kB] Get: 34 http://deb.debian.org/debian forky/main amd64 libuchardet0 amd64 0.0.8-2 [68.5 kB] Get: 35 http://deb.debian.org/debian forky/main amd64 groff-base amd64 1.23.0-9 [1187 kB] Get: 36 http://deb.debian.org/debian forky/main amd64 bsdextrautils amd64 2.41.2-4 [98.5 kB] Get: 37 http://deb.debian.org/debian forky/main amd64 libpipeline1 amd64 1.5.8-1 [42.0 kB] Get: 38 http://deb.debian.org/debian forky/main amd64 man-db amd64 2.13.1-1 [1469 kB] Get: 39 http://deb.debian.org/debian forky/main amd64 m4 amd64 1.4.20-2 [325 kB] Get: 40 http://deb.debian.org/debian forky/main amd64 autoconf all 2.72-3.1 [494 kB] Get: 41 http://deb.debian.org/debian forky/main amd64 autotools-dev all 20240727.1 [60.2 kB] Get: 42 http://deb.debian.org/debian forky/main amd64 automake all 1:1.18.1-2 [877 kB] Get: 43 http://deb.debian.org/debian forky/main amd64 autopoint all 0.23.1-2 [770 kB] Get: 44 http://deb.debian.org/debian forky/main amd64 libdebhelper-perl all 13.28 [92.4 kB] Get: 45 http://deb.debian.org/debian forky/main amd64 libtool all 2.5.4-7 [540 kB] Get: 46 http://deb.debian.org/debian forky/main amd64 dh-autoreconf all 21 [12.2 kB] Get: 47 http://deb.debian.org/debian forky/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 48 http://deb.debian.org/debian forky/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [19.9 kB] Get: 49 http://deb.debian.org/debian forky/main amd64 dh-strip-nondeterminism all 1.15.0-1 [8812 B] Get: 50 http://deb.debian.org/debian forky/main amd64 libelf1t64 amd64 0.193-3 [192 kB] Get: 51 http://deb.debian.org/debian forky/main amd64 dwz amd64 0.16-2 [108 kB] Get: 52 http://deb.debian.org/debian forky/main amd64 libunistring5 amd64 1.3-2 [477 kB] Get: 53 http://deb.debian.org/debian forky/main amd64 libxml2-16 amd64 2.14.6+dfsg-0.1 [651 kB] Get: 54 http://deb.debian.org/debian forky/main amd64 gettext amd64 0.23.1-2+b1 [1680 kB] Get: 55 http://deb.debian.org/debian forky/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 56 http://deb.debian.org/debian forky/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 57 http://deb.debian.org/debian forky/main amd64 debhelper all 13.28 [941 kB] Get: 58 http://deb.debian.org/debian forky/main amd64 dh-python all 6.20250414 [116 kB] Get: 59 http://deb.debian.org/debian forky/main amd64 help2man amd64 1.49.3 [198 kB] Get: 60 http://deb.debian.org/debian forky/main amd64 libcom-err2 amd64 1.47.2-3+b3 [25.0 kB] Get: 61 http://deb.debian.org/debian forky/main amd64 libgpg-error0 amd64 1.56-2 [89.1 kB] Get: 62 http://deb.debian.org/debian forky/main amd64 libgcrypt20 amd64 1.11.2-2 [865 kB] Get: 63 http://deb.debian.org/debian forky/main amd64 libkrb5support0 amd64 1.21.3-5 [33.0 kB] Get: 64 http://deb.debian.org/debian forky/main amd64 libk5crypto3 amd64 1.21.3-5 [81.5 kB] Get: 65 http://deb.debian.org/debian forky/main amd64 libkeyutils1 amd64 1.6.3-6 [9456 B] Get: 66 http://deb.debian.org/debian forky/main amd64 libkrb5-3 amd64 1.21.3-5 [326 kB] Get: 67 http://deb.debian.org/debian forky/main amd64 libgssapi-krb5-2 amd64 1.21.3-5 [138 kB] Get: 68 http://deb.debian.org/debian forky/main amd64 libicu76 amd64 76.1-4 [9722 kB] Get: 69 http://deb.debian.org/debian forky/main amd64 libsasl2-modules-db amd64 2.1.28+dfsg1-10 [19.8 kB] Get: 70 http://deb.debian.org/debian forky/main amd64 libsasl2-2 amd64 2.1.28+dfsg1-10 [57.8 kB] Get: 71 http://deb.debian.org/debian forky/main amd64 libldap2 amd64 2.6.10+dfsg-1 [194 kB] Get: 72 http://deb.debian.org/debian forky/main amd64 libnuma1 amd64 2.0.19-1 [22.2 kB] Get: 73 http://deb.debian.org/debian forky/main amd64 libpg-query1706.0 amd64 17-6.1.0-1 [595 kB] Get: 74 http://deb.debian.org/debian forky/main amd64 libpq5 amd64 18.0-1 [251 kB] Get: 75 http://deb.debian.org/debian forky/main amd64 liburing2 amd64 2.12-1 [29.5 kB] Get: 76 http://deb.debian.org/debian forky/main amd64 libxslt1.1 amd64 1.1.43-0.3 [158 kB] Get: 77 http://deb.debian.org/debian forky/main amd64 libyaml-0-2 amd64 0.2.5-2 [52.5 kB] Get: 78 http://deb.debian.org/debian forky/main amd64 postgresql-client-18 amd64 18.0-1 [2115 kB] Get: 79 http://deb.debian.org/debian forky/main amd64 postgresql-18 amd64 18.0-1 [7237 kB] Get: 80 http://deb.debian.org/debian forky/main amd64 postgresql all 18+286 [17.8 kB] Get: 81 http://deb.debian.org/debian forky/main amd64 python3-all amd64 3.13.7-1 [1048 B] Get: 82 http://deb.debian.org/debian forky/main amd64 python3-autocommand all 2.2.2-3 [13.6 kB] Get: 83 http://deb.debian.org/debian forky/main amd64 python3-more-itertools all 10.8.0-1 [71.7 kB] Get: 84 http://deb.debian.org/debian forky/main amd64 python3-typing-extensions all 4.15.0-1 [92.4 kB] Get: 85 http://deb.debian.org/debian forky/main amd64 python3-typeguard all 4.4.4-1 [37.1 kB] Get: 86 http://deb.debian.org/debian forky/main amd64 python3-inflect all 7.5.0-1 [33.0 kB] Get: 87 http://deb.debian.org/debian forky/main amd64 python3-iniconfig all 2.1.0-1 [7432 B] Get: 88 http://deb.debian.org/debian forky/main amd64 python3-jaraco.functools all 4.1.0-1 [12.0 kB] Get: 89 http://deb.debian.org/debian forky/main amd64 python3-pkg-resources all 78.1.1-0.1 [224 kB] Get: 90 http://deb.debian.org/debian forky/main amd64 python3-jaraco.text all 4.0.0-1 [11.4 kB] Get: 91 http://deb.debian.org/debian forky/main amd64 python3-zipp all 3.23.0-1 [11.0 kB] Get: 92 http://deb.debian.org/debian forky/main amd64 python3-setuptools all 78.1.1-0.1 [738 kB] Get: 93 http://deb.debian.org/debian forky/main amd64 python3-jaraco.context all 6.0.1-1 [8276 B] Get: 94 http://deb.debian.org/debian forky/main amd64 python3-packaging all 25.0-1 [56.6 kB] Get: 95 http://deb.debian.org/debian forky/main amd64 python3-pglast amd64 7.10-1 [331 kB] Get: 96 http://deb.debian.org/debian forky/main amd64 python3-pluggy all 1.6.0-1 [27.1 kB] Get: 97 http://deb.debian.org/debian forky/main amd64 python3-psycopg2 amd64 2.9.10-1+b1 [129 kB] Get: 98 http://deb.debian.org/debian forky/main amd64 python3-pygments all 2.18.0+dfsg-2 [836 kB] Get: 99 http://deb.debian.org/debian forky/main amd64 python3-pytest all 8.4.2-1 [266 kB] Get: 100 http://deb.debian.org/debian forky/main amd64 python3-yaml amd64 6.0.2-2 [137 kB] Fetched 46.3 MB in 0s (124 MB/s) Preconfiguring packages ... /var/cache/debconf/tmp.ci/postgresql.config.X5NEPd: 12: pg_lsclusters: not found Selecting previously unselected package libexpat1:amd64. (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 ... 19869 files and directories currently installed.) Preparing to unpack .../00-libexpat1_2.7.3-1_amd64.deb ... Unpacking libexpat1:amd64 (2.7.3-1) ... Selecting previously unselected package liblocale-gettext-perl. Preparing to unpack .../01-liblocale-gettext-perl_1.07-7+b1_amd64.deb ... Unpacking liblocale-gettext-perl (1.07-7+b1) ... Selecting previously unselected package libjson-perl. Preparing to unpack .../02-libjson-perl_4.10000-1_all.deb ... Unpacking libjson-perl (4.10000-1) ... Selecting previously unselected package netbase. Preparing to unpack .../03-netbase_6.5_all.deb ... Unpacking netbase (6.5) ... Selecting previously unselected package postgresql-client-common. Preparing to unpack .../04-postgresql-client-common_286_all.deb ... Unpacking postgresql-client-common (286) ... Selecting previously unselected package libio-pty-perl. Preparing to unpack .../05-libio-pty-perl_1%3a1.20-1+b3_amd64.deb ... Unpacking libio-pty-perl (1:1.20-1+b3) ... Selecting previously unselected package libipc-run-perl. Preparing to unpack .../06-libipc-run-perl_20231003.0-2_all.deb ... Unpacking libipc-run-perl (20231003.0-2) ... Selecting previously unselected package postgresql-common-dev. Preparing to unpack .../07-postgresql-common-dev_286_all.deb ... Unpacking postgresql-common-dev (286) ... Selecting previously unselected package openssl. Preparing to unpack .../08-openssl_3.5.4-1_amd64.deb ... Unpacking openssl (3.5.4-1) ... Selecting previously unselected package ssl-cert. Preparing to unpack .../09-ssl-cert_1.1.3_all.deb ... Unpacking ssl-cert (1.1.3) ... Selecting previously unselected package libtext-charwidth-perl:amd64. Preparing to unpack .../10-libtext-charwidth-perl_0.04-11+b4_amd64.deb ... Unpacking libtext-charwidth-perl:amd64 (0.04-11+b4) ... Selecting previously unselected package libtext-wrapi18n-perl. Preparing to unpack .../11-libtext-wrapi18n-perl_0.06-10_all.deb ... Unpacking libtext-wrapi18n-perl (0.06-10) ... Selecting previously unselected package libproc2-0:amd64. Preparing to unpack .../12-libproc2-0_2%3a4.0.4-9_amd64.deb ... Unpacking libproc2-0:amd64 (2:4.0.4-9) ... Selecting previously unselected package procps. Preparing to unpack .../13-procps_2%3a4.0.4-9_amd64.deb ... Unpacking procps (2:4.0.4-9) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../14-sensible-utils_0.0.26_all.deb ... Unpacking sensible-utils (0.0.26) ... Selecting previously unselected package ucf. Preparing to unpack .../15-ucf_3.0052_all.deb ... Moving old data out of the way Unpacking ucf (3.0052) ... Selecting previously unselected package postgresql-common. Preparing to unpack .../16-postgresql-common_286_all.deb ... Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' Unpacking postgresql-common (286) ... Selecting previously unselected package libpython3.13-minimal:amd64. Preparing to unpack .../17-libpython3.13-minimal_3.13.9-1_amd64.deb ... Unpacking libpython3.13-minimal:amd64 (3.13.9-1) ... Selecting previously unselected package python3.13-minimal. Preparing to unpack .../18-python3.13-minimal_3.13.9-1_amd64.deb ... Unpacking python3.13-minimal (3.13.9-1) ... Setting up libpython3.13-minimal:amd64 (3.13.9-1) ... Setting up libexpat1:amd64 (2.7.3-1) ... Setting up python3.13-minimal (3.13.9-1) ... Selecting previously unselected package python3-minimal. (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 ... 21147 files and directories currently installed.) Preparing to unpack .../0-python3-minimal_3.13.7-1_amd64.deb ... Unpacking python3-minimal (3.13.7-1) ... Selecting previously unselected package media-types. Preparing to unpack .../1-media-types_14.0.0_all.deb ... Unpacking media-types (14.0.0) ... Selecting previously unselected package tzdata. Preparing to unpack .../2-tzdata_2025b-5_all.deb ... Unpacking tzdata (2025b-5) ... Selecting previously unselected package libffi8:amd64. Preparing to unpack .../3-libffi8_3.5.2-2_amd64.deb ... Unpacking libffi8:amd64 (3.5.2-2) ... Selecting previously unselected package readline-common. Preparing to unpack .../4-readline-common_8.3-3_all.deb ... Unpacking readline-common (8.3-3) ... Selecting previously unselected package libreadline8t64:amd64. Preparing to unpack .../5-libreadline8t64_8.3-3_amd64.deb ... Adding 'diversion of /lib/x86_64-linux-gnu/libhistory.so.8 to /lib/x86_64-linux-gnu/libhistory.so.8.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libhistory.so.8.2 to /lib/x86_64-linux-gnu/libhistory.so.8.2.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libreadline.so.8 to /lib/x86_64-linux-gnu/libreadline.so.8.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libreadline.so.8.2 to /lib/x86_64-linux-gnu/libreadline.so.8.2.usr-is-merged by libreadline8t64' Unpacking libreadline8t64:amd64 (8.3-3) ... Selecting previously unselected package libpython3.13-stdlib:amd64. Preparing to unpack .../6-libpython3.13-stdlib_3.13.9-1_amd64.deb ... Unpacking libpython3.13-stdlib:amd64 (3.13.9-1) ... Selecting previously unselected package python3.13. Preparing to unpack .../7-python3.13_3.13.9-1_amd64.deb ... Unpacking python3.13 (3.13.9-1) ... Selecting previously unselected package libpython3-stdlib:amd64. Preparing to unpack .../8-libpython3-stdlib_3.13.7-1_amd64.deb ... Unpacking libpython3-stdlib:amd64 (3.13.7-1) ... Setting up python3-minimal (3.13.7-1) ... Selecting previously unselected package python3. (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 ... 22155 files and directories currently installed.) Preparing to unpack .../00-python3_3.13.7-1_amd64.deb ... Unpacking python3 (3.13.7-1) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.46-5_amd64.deb ... Unpacking libmagic-mgc (1:5.46-5) ... Selecting previously unselected package libmagic1t64:amd64. Preparing to unpack .../02-libmagic1t64_1%3a5.46-5_amd64.deb ... Unpacking libmagic1t64:amd64 (1:5.46-5) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.46-5_amd64.deb ... Unpacking file (1:5.46-5) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.23.1-2+b1_amd64.deb ... Unpacking gettext-base (0.23.1-2+b1) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../05-libuchardet0_0.0.8-2_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.8-2) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-9_amd64.deb ... Unpacking groff-base (1.23.0-9) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.41.2-4_amd64.deb ... Unpacking bsdextrautils (2.41.2-4) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../08-libpipeline1_1.5.8-1_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.8-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.13.1-1_amd64.deb ... Unpacking man-db (2.13.1-1) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.20-2_amd64.deb ... Unpacking m4 (1.4.20-2) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.72-3.1_all.deb ... Unpacking autoconf (2.72-3.1) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20240727.1_all.deb ... Unpacking autotools-dev (20240727.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.18.1-2_all.deb ... Unpacking automake (1:1.18.1-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.23.1-2_all.deb ... Unpacking autopoint (0.23.1-2) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.28_all.deb ... Unpacking libdebhelper-perl (13.28) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.5.4-7_all.deb ... Unpacking libtool (2.5.4-7) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_21_all.deb ... Unpacking dh-autoreconf (21) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../19-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../20-dh-strip-nondeterminism_1.15.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.15.0-1) ... Selecting previously unselected package libelf1t64:amd64. Preparing to unpack .../21-libelf1t64_0.193-3_amd64.deb ... Unpacking libelf1t64:amd64 (0.193-3) ... Selecting previously unselected package dwz. Preparing to unpack .../22-dwz_0.16-2_amd64.deb ... Unpacking dwz (0.16-2) ... Selecting previously unselected package libunistring5:amd64. Preparing to unpack .../23-libunistring5_1.3-2_amd64.deb ... Unpacking libunistring5:amd64 (1.3-2) ... Selecting previously unselected package libxml2-16:amd64. Preparing to unpack .../24-libxml2-16_2.14.6+dfsg-0.1_amd64.deb ... Unpacking libxml2-16:amd64 (2.14.6+dfsg-0.1) ... Selecting previously unselected package gettext. Preparing to unpack .../25-gettext_0.23.1-2+b1_amd64.deb ... Unpacking gettext (0.23.1-2+b1) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../26-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../27-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../28-debhelper_13.28_all.deb ... Unpacking debhelper (13.28) ... Selecting previously unselected package dh-python. Preparing to unpack .../29-dh-python_6.20250414_all.deb ... Unpacking dh-python (6.20250414) ... Selecting previously unselected package help2man. Preparing to unpack .../30-help2man_1.49.3_amd64.deb ... Unpacking help2man (1.49.3) ... Selecting previously unselected package libcom-err2:amd64. Preparing to unpack .../31-libcom-err2_1.47.2-3+b3_amd64.deb ... Unpacking libcom-err2:amd64 (1.47.2-3+b3) ... Selecting previously unselected package libgpg-error0:amd64. Preparing to unpack .../32-libgpg-error0_1.56-2_amd64.deb ... Unpacking libgpg-error0:amd64 (1.56-2) ... Selecting previously unselected package libgcrypt20:amd64. Preparing to unpack .../33-libgcrypt20_1.11.2-2_amd64.deb ... Unpacking libgcrypt20:amd64 (1.11.2-2) ... Selecting previously unselected package libkrb5support0:amd64. Preparing to unpack .../34-libkrb5support0_1.21.3-5_amd64.deb ... Unpacking libkrb5support0:amd64 (1.21.3-5) ... Selecting previously unselected package libk5crypto3:amd64. Preparing to unpack .../35-libk5crypto3_1.21.3-5_amd64.deb ... Unpacking libk5crypto3:amd64 (1.21.3-5) ... Selecting previously unselected package libkeyutils1:amd64. Preparing to unpack .../36-libkeyutils1_1.6.3-6_amd64.deb ... Unpacking libkeyutils1:amd64 (1.6.3-6) ... Selecting previously unselected package libkrb5-3:amd64. Preparing to unpack .../37-libkrb5-3_1.21.3-5_amd64.deb ... Unpacking libkrb5-3:amd64 (1.21.3-5) ... Selecting previously unselected package libgssapi-krb5-2:amd64. Preparing to unpack .../38-libgssapi-krb5-2_1.21.3-5_amd64.deb ... Unpacking libgssapi-krb5-2:amd64 (1.21.3-5) ... Selecting previously unselected package libicu76:amd64. Preparing to unpack .../39-libicu76_76.1-4_amd64.deb ... Unpacking libicu76:amd64 (76.1-4) ... Selecting previously unselected package libsasl2-modules-db:amd64. Preparing to unpack .../40-libsasl2-modules-db_2.1.28+dfsg1-10_amd64.deb ... Unpacking libsasl2-modules-db:amd64 (2.1.28+dfsg1-10) ... Selecting previously unselected package libsasl2-2:amd64. Preparing to unpack .../41-libsasl2-2_2.1.28+dfsg1-10_amd64.deb ... Unpacking libsasl2-2:amd64 (2.1.28+dfsg1-10) ... Selecting previously unselected package libldap2:amd64. Preparing to unpack .../42-libldap2_2.6.10+dfsg-1_amd64.deb ... Unpacking libldap2:amd64 (2.6.10+dfsg-1) ... Selecting previously unselected package libnuma1:amd64. Preparing to unpack .../43-libnuma1_2.0.19-1_amd64.deb ... Unpacking libnuma1:amd64 (2.0.19-1) ... Selecting previously unselected package libpg-query1706.0:amd64. Preparing to unpack .../44-libpg-query1706.0_17-6.1.0-1_amd64.deb ... Unpacking libpg-query1706.0:amd64 (17-6.1.0-1) ... Selecting previously unselected package libpq5:amd64. Preparing to unpack .../45-libpq5_18.0-1_amd64.deb ... Unpacking libpq5:amd64 (18.0-1) ... Selecting previously unselected package liburing2:amd64. Preparing to unpack .../46-liburing2_2.12-1_amd64.deb ... Unpacking liburing2:amd64 (2.12-1) ... Selecting previously unselected package libxslt1.1:amd64. Preparing to unpack .../47-libxslt1.1_1.1.43-0.3_amd64.deb ... Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... Selecting previously unselected package libyaml-0-2:amd64. Preparing to unpack .../48-libyaml-0-2_0.2.5-2_amd64.deb ... Unpacking libyaml-0-2:amd64 (0.2.5-2) ... Selecting previously unselected package postgresql-client-18. Preparing to unpack .../49-postgresql-client-18_18.0-1_amd64.deb ... Unpacking postgresql-client-18 (18.0-1) ... Selecting previously unselected package postgresql-18. Preparing to unpack .../50-postgresql-18_18.0-1_amd64.deb ... Unpacking postgresql-18 (18.0-1) ... Selecting previously unselected package postgresql. Preparing to unpack .../51-postgresql_18+286_all.deb ... Unpacking postgresql (18+286) ... Selecting previously unselected package python3-all. Preparing to unpack .../52-python3-all_3.13.7-1_amd64.deb ... Unpacking python3-all (3.13.7-1) ... Selecting previously unselected package python3-autocommand. Preparing to unpack .../53-python3-autocommand_2.2.2-3_all.deb ... Unpacking python3-autocommand (2.2.2-3) ... Selecting previously unselected package python3-more-itertools. Preparing to unpack .../54-python3-more-itertools_10.8.0-1_all.deb ... Unpacking python3-more-itertools (10.8.0-1) ... Selecting previously unselected package python3-typing-extensions. Preparing to unpack .../55-python3-typing-extensions_4.15.0-1_all.deb ... Unpacking python3-typing-extensions (4.15.0-1) ... Selecting previously unselected package python3-typeguard. Preparing to unpack .../56-python3-typeguard_4.4.4-1_all.deb ... Unpacking python3-typeguard (4.4.4-1) ... Selecting previously unselected package python3-inflect. Preparing to unpack .../57-python3-inflect_7.5.0-1_all.deb ... Unpacking python3-inflect (7.5.0-1) ... Selecting previously unselected package python3-iniconfig. Preparing to unpack .../58-python3-iniconfig_2.1.0-1_all.deb ... Unpacking python3-iniconfig (2.1.0-1) ... Selecting previously unselected package python3-jaraco.functools. Preparing to unpack .../59-python3-jaraco.functools_4.1.0-1_all.deb ... Unpacking python3-jaraco.functools (4.1.0-1) ... Selecting previously unselected package python3-pkg-resources. Preparing to unpack .../60-python3-pkg-resources_78.1.1-0.1_all.deb ... Unpacking python3-pkg-resources (78.1.1-0.1) ... Selecting previously unselected package python3-jaraco.text. Preparing to unpack .../61-python3-jaraco.text_4.0.0-1_all.deb ... Unpacking python3-jaraco.text (4.0.0-1) ... Selecting previously unselected package python3-zipp. Preparing to unpack .../62-python3-zipp_3.23.0-1_all.deb ... Unpacking python3-zipp (3.23.0-1) ... Selecting previously unselected package python3-setuptools. Preparing to unpack .../63-python3-setuptools_78.1.1-0.1_all.deb ... Unpacking python3-setuptools (78.1.1-0.1) ... Selecting previously unselected package python3-jaraco.context. Preparing to unpack .../64-python3-jaraco.context_6.0.1-1_all.deb ... Unpacking python3-jaraco.context (6.0.1-1) ... Selecting previously unselected package python3-packaging. Preparing to unpack .../65-python3-packaging_25.0-1_all.deb ... Unpacking python3-packaging (25.0-1) ... Selecting previously unselected package python3-pglast. Preparing to unpack .../66-python3-pglast_7.10-1_amd64.deb ... Unpacking python3-pglast (7.10-1) ... Selecting previously unselected package python3-pluggy. Preparing to unpack .../67-python3-pluggy_1.6.0-1_all.deb ... Unpacking python3-pluggy (1.6.0-1) ... Selecting previously unselected package python3-psycopg2. Preparing to unpack .../68-python3-psycopg2_2.9.10-1+b1_amd64.deb ... Unpacking python3-psycopg2 (2.9.10-1+b1) ... Selecting previously unselected package python3-pygments. Preparing to unpack .../69-python3-pygments_2.18.0+dfsg-2_all.deb ... Unpacking python3-pygments (2.18.0+dfsg-2) ... Selecting previously unselected package python3-pytest. Preparing to unpack .../70-python3-pytest_8.4.2-1_all.deb ... Unpacking python3-pytest (8.4.2-1) ... Selecting previously unselected package python3-yaml. Preparing to unpack .../71-python3-yaml_6.0.2-2_amd64.deb ... Unpacking python3-yaml (6.0.2-2) ... Setting up media-types (14.0.0) ... Setting up libpipeline1:amd64 (1.5.8-1) ... Setting up libtext-charwidth-perl:amd64 (0.04-11+b4) ... Setting up libkeyutils1:amd64 (1.6.3-6) ... Setting up bsdextrautils (2.41.2-4) ... Setting up libgpg-error0:amd64 (1.56-2) ... Setting up libio-pty-perl (1:1.20-1+b3) ... Setting up libmagic-mgc (1:5.46-5) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libyaml-0-2:amd64 (0.2.5-2) ... Setting up libxml2-16:amd64 (2.14.6+dfsg-0.1) ... Setting up libdebhelper-perl (13.28) ... Setting up libmagic1t64:amd64 (1:5.46-5) ... Setting up gettext-base (0.23.1-2+b1) ... Setting up m4 (1.4.20-2) ... Setting up libgcrypt20:amd64 (1.11.2-2) ... Setting up libcom-err2:amd64 (1.47.2-3+b3) ... Setting up file (1:5.46-5) ... Setting up libtext-wrapi18n-perl (0.06-10) ... Setting up libelf1t64:amd64 (0.193-3) ... Setting up libkrb5support0:amd64 (1.21.3-5) ... Setting up libsasl2-modules-db:amd64 (2.1.28+dfsg1-10) ... Setting up tzdata (2025b-5) ... Current default time zone: 'Etc/UTC' Local time is now: Fri Oct 31 17:52:37 UTC 2025. Universal Time is now: Fri Oct 31 17:52:37 UTC 2025. Run 'dpkg-reconfigure tzdata' if you wish to change it. Setting up autotools-dev (20240727.1) ... Setting up libproc2-0:amd64 (2:4.0.4-9) ... Setting up libunistring5:amd64 (1.3-2) ... Setting up autopoint (0.23.1-2) ... Setting up libipc-run-perl (20231003.0-2) ... Setting up libk5crypto3:amd64 (1.21.3-5) ... Setting up libsasl2-2:amd64 (2.1.28+dfsg1-10) ... Setting up autoconf (2.72-3.1) ... Setting up libffi8:amd64 (3.5.2-2) ... Setting up libnuma1:amd64 (2.0.19-1) ... Setting up dwz (0.16-2) ... Setting up sensible-utils (0.0.26) ... Setting up libuchardet0:amd64 (0.0.8-2) ... Setting up procps (2:4.0.4-9) ... Setting up libjson-perl (4.10000-1) ... Setting up libxslt1.1:amd64 (1.1.43-0.3) ... Setting up netbase (6.5) ... Setting up libkrb5-3:amd64 (1.21.3-5) ... Setting up libicu76:amd64 (76.1-4) ... Setting up liburing2:amd64 (2.12-1) ... Setting up openssl (3.5.4-1) ... Setting up readline-common (8.3-3) ... Setting up libpg-query1706.0:amd64 (17-6.1.0-1) ... Setting up libldap2:amd64 (2.6.10+dfsg-1) ... Setting up liblocale-gettext-perl (1.07-7+b1) ... Setting up postgresql-common-dev (286) ... Setting up automake (1:1.18.1-2) ... update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode Setting up postgresql-client-common (286) ... Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... Setting up gettext (0.23.1-2+b1) ... Setting up libtool (2.5.4-7) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up help2man (1.49.3) ... Setting up dh-autoreconf (21) ... Setting up ssl-cert (1.1.3) ... Setting up libgssapi-krb5-2:amd64 (1.21.3-5) ... Setting up ucf (3.0052) ... Setting up libreadline8t64:amd64 (8.3-3) ... Setting up dh-strip-nondeterminism (1.15.0-1) ... Setting up groff-base (1.23.0-9) ... Setting up libpython3.13-stdlib:amd64 (3.13.9-1) ... Setting up libpython3-stdlib:amd64 (3.13.7-1) ... Setting up python3.13 (3.13.9-1) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up libpq5:amd64 (18.0-1) ... Setting up python3 (3.13.7-1) ... Setting up python3-zipp (3.23.0-1) ... Setting up python3-autocommand (2.2.2-3) ... Setting up man-db (2.13.1-1) ... Not building database; man-db/auto-update is not 'true'. Setting up python3-pygments (2.18.0+dfsg-2) ... Setting up python3-packaging (25.0-1) ... Setting up postgresql-common (286) ... Creating config file /etc/postgresql-common/createcluster.conf with new version Building PostgreSQL dictionaries from installed myspell/hunspell packages... Removing obsolete dictionary files: invoke-rc.d: could not determine current runlevel invoke-rc.d: policy-rc.d denied execution of start. Setting up python3-psycopg2 (2.9.10-1+b1) ... Setting up python3-typing-extensions (4.15.0-1) ... Setting up python3-pluggy (1.6.0-1) ... Setting up dh-python (6.20250414) ... Setting up python3-more-itertools (10.8.0-1) ... Setting up python3-iniconfig (2.1.0-1) ... Setting up python3-jaraco.functools (4.1.0-1) ... Setting up python3-jaraco.context (6.0.1-1) ... Setting up postgresql-client-18 (18.0-1) ... update-alternatives: using /usr/share/postgresql/18/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode Setting up python3-pytest (8.4.2-1) ... Setting up python3-typeguard (4.4.4-1) ... Setting up postgresql-18 (18.0-1) ... Creating new PostgreSQL cluster 18/main ... /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "C.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. fixing permissions on existing directory /var/lib/postgresql/18/main ... ok creating subdirectories ... ok 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 creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok invoke-rc.d: could not determine current runlevel invoke-rc.d: policy-rc.d denied execution of start. Setting up python3-all (3.13.7-1) ... Setting up python3-yaml (6.0.2-2) ... Setting up debhelper (13.28) ... Setting up python3-inflect (7.5.0-1) ... Setting up python3-jaraco.text (4.0.0-1) ... Setting up postgresql (18+286) ... Setting up python3-pkg-resources (78.1.1-0.1) ... Setting up python3-setuptools (78.1.1-0.1) ... Setting up python3-pglast (7.10-1) ... Processing triggers for libc-bin (2.41-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/reproducible-path/sqlreduce-1.3/ && 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 > ../sqlreduce_1.3-1_source.changes dpkg-buildpackage: info: source package sqlreduce dpkg-buildpackage: info: source version 1.3-1 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Christoph Berg dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 dpkg-source: info: using options from sqlreduce-1.3/debian/source/options: --extend-diff-ignore=docs/sqlreduce.1 debian/rules clean dh clean --with python3 --buildsystem=pybuild dh_auto_clean -O--buildsystem=pybuild I: pybuild base:311: python3.13 setup.py clean /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running clean removing '/build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build' (and everything under it) 'build/bdist.linux-x86_64' does not exist -- can't clean it 'build/scripts-3.13' does not exist -- can't clean it dh_autoreconf_clean -O--buildsystem=pybuild dh_clean -O--buildsystem=pybuild debian/rules binary dh binary --with python3 --buildsystem=pybuild dh_update_autotools_config -O--buildsystem=pybuild dh_autoreconf -O--buildsystem=pybuild dh_auto_configure -O--buildsystem=pybuild I: pybuild base:311: python3.13 setup.py config /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running config dh_auto_build -O--buildsystem=pybuild I: pybuild base:311: /usr/bin/python3 setup.py build /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running build running build_py creating /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce copying sqlreduce/__init__.py -> /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce copying sqlreduce/main.py -> /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce debian/rules override_dh_auto_test make[1]: Entering directory '/build/reproducible-path/sqlreduce-1.3' pg_virtualenv dh_auto_test Creating new PostgreSQL cluster 18/regress ... I: pybuild base:311: cd /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build; python3.13 -m pytest tests ============================= test session starts ============================== platform linux -- Python 3.13.9, pytest-8.4.2, pluggy-1.6.0 rootdir: /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build configfile: pyproject.toml plugins: typeguard-4.4.4 collected 3 items tests/test_sqlreduce.py ..F [100%] =================================== FAILURES =================================== __________________________________ test_rules __________________________________ def test_rules(): for classname, rule in rules.items(): print(f"{classname}:") tests = rule['tests'] if tests is None: raise Exception(f"{classname} is missing tests") for test, expected in zip(tests[0::2], tests[1::2]): print(" test:", test) res, _ = run_reduce(test) print(" got:", res) if res != expected: print("expect:", expected) > raise Exception(f"{classname} test: {test}: expected {expected}, got {res}") E Exception: TransactionStmt test: begin: expected BEGIN , got BEGIN tests/test_sqlreduce.py:59: Exception ----------------------------- Captured stdout call ----------------------------- A_ArrayExpr: test: select array[2, foo] got: SELECT foo A_Const: test: select '1,1'::point = '1,1' got: SELECT CAST(NULL AS point) = NULL A_Expr: test: select 1 + moo got: SELECT moo test: select foo between 2 and 3 got: SELECT foo test: select 1 between moo and 3 got: SELECT moo test: select 1 between 2 and bar got: SELECT bar A_Indirection: test: select foo[2] got: SELECT foo test: select (select array[1])[foo] got: SELECT (SELECT ARRAY[NULL])[foo] AlterPolicyStmt: test: alter policy moo on bar using (true) got: ALTER POLICY moo ON bar USING (NULL) BoolExpr: test: select moo and foo got: SELECT moo test: select true and (foo or false) got: SELECT foo test: select set_config('a.b', 'blub', true) = 'blub' and set_config('work_mem', current_setting('a.b'), true) = '' and true got: SELECT set_config('a.b', 'blub', NULL) = 'blub' AND set_config('work_mem', current_setting('a.b'), NULL) = '' BooleanTest: test: select foo is true got: SELECT foo CallStmt: test: call foo() got: CALL foo() test: call foo(bar + 1) got: CALL foo(bar) CaseExpr: test: select case foo when 1 then 2 else bar end got: SELECT foo test: select case when moo then 1 else bar end got: SELECT moo test: select case when true then foo end got: SELECT foo test: select case when true then 1 else bar end got: SELECT bar CaseWhen: test: select case when bar then 1 else 2 end got: SELECT bar ClusterStmt: test: cluster foo got: CLUSTER foo CoalesceExpr: test: select coalesce(1, bar) got: SELECT bar test: select coalesce(1, '', 2) got: SELECT COALESCE('', 2) ColumnRef: test: select 'foo' got: SELECT CommonTableExpr: test: with a as (select moo) select from a got: SELECT moo test: with recursive a(a) as (select 5 union select 1 from a) cycle a set is_cycle using path, b(b) as (select null) select a = b from a, b got: WITH a(a) AS (SELECT NULL UNION SELECT 1), b(b) AS (SELECT NULL) SELECT a = b FROM a, b CopyStmt: test: copy (select foo) to 'bla' got: SELECT foo test: create table foo (id int); copy foo from stdin got: CREATE TABLE foo (id integer); COPY foo FROM STDIN CreatePolicyStmt: test: create policy foo ON bar for select using (moo % 2 = 0) got: CREATE POLICY foo ON bar AS PERMISSIVE FOR select TO PUBLIC USING (NULL) CreateSchemaStmt: test: create schema foo create table bar1 partition of moo for values in (1) create table bar2 partition of moo for values in (2) got: CREATE SCHEMA foo CREATE TABLE bar2 PARTITION OF moo FOR VALUES IN (2) CreateStmt: test: create table foo (a int) got: CREATE TABLE foo (a integer) test: create table foo (id int) partition by list(id) got: CREATE TABLE foo (id integer) CreateTableAsStmt: test: create table foo as select 1, moo got: SELECT moo test: create table foo as select 1, 2 got: CREATE TABLE foo AS SELECT NULL, NULL DeclareCursorStmt: test: declare foo cursor for select bar got: SELECT bar DeleteStmt: test: delete from foo where bar got: DELETE FROM foo test: delete from foo using bar got: DELETE FROM foo test: delete from foo returning bar got: DELETE FROM foo test: delete from pg_database where bar and foo got: DELETE FROM pg_database WHERE bar ExecuteStmt: test: prepare foo as select $1; execute foo(bar + 1) got: PREPARE foo AS SELECT $1; EXECUTE foo(bar) ExplainStmt: test: explain select from foo, bar got: EXPLAIN SELECT FROM foo test: explain (analyze) select from foo got: EXPLAIN SELECT FROM foo FuncCall: test: select foo(bar) got: SELECT bar test: select foo() over () got: SELECT foo() test: select lag(1) over (partition by bar, foo) got: SELECT lag(1) OVER (PARTITION BY bar) test: select foo(1 order by moo) got: SELECT foo(1) test: select count(1 order by moo, bar) got: SELECT moo test: select foo(1 + 1) got: SELECT foo(1) InsertStmt: test: insert into bar select from bar got: SELECT FROM bar test: create table bar(id int); insert into bar values(foo) got: VALUES (foo) test: insert into foo (id) select bar got: INSERT INTO foo SELECT test: insert into foo values (1) on conflict do nothing got: INSERT INTO foo SELECT test: with foo as (select 1) insert into bar select * from foo got: INSERT INTO bar SELECT test: insert into foo select returning bar, moo got: INSERT INTO foo SELECT test: create table foo (bar int); insert into foo select returning bar, moo got: CREATE TABLE foo (bar integer); INSERT INTO foo SELECT RETURNING moo JoinExpr: test: select from foo join bar on true got: SELECT FROM foo test: select from pg_database join pg_database on moo got: SELECT FROM pg_database INNER JOIN pg_database ON NULL test: select from pg_database a join pg_database b on foo got: SELECT foo NamedArgExpr: test: select foo(bar => moo) got: SELECT moo Null: test: select null got: SELECT NullTest: test: select moo is null got: SELECT moo OnConflictClause: test: create table foo(id int primary key); insert into foo values (1) on conflict (id) do update set a=1 where true got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (id) DO UPDATE SET a = NULL test: create table foo(id int primary key); insert into foo values (1) on conflict (id) do update set id=1, b=1 got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (id) DO UPDATE SET b = NULL test: create table foo(id int primary key); insert into foo (id) values (1) on conflict (a) do update set id=1 got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (a) DO NOTHING PrepareStmt: test: prepare foo as select from bar, moo got: SELECT FROM bar RangeFunction: test: select from lateral foo() got: SELECT FROM foo() test: select from foo(1 + 1) got: SELECT FROM foo(1) test: select from rows from (f(1), f(2)) got: SELECT FROM ROWS FROM (f(1), f()) RangeSubselect: test: select from (select bar) sub got: SELECT bar RangeTableFunc: test: select from xmltable('/foo' passing bla columns foo integer, moo text) got: SELECT FROM xmltable(('/foo') PASSING bla COLUMNS moo text) RangeTableFuncCol: test: select from xmltable('/foo' passing bla columns foo integer, moo text) got: SELECT FROM xmltable(('/foo') PASSING bla COLUMNS moo text) RangeTableSample: test: select from bar tablesample system(1) got: SELECT FROM bar RangeVar: test: select from moo got: SELECT FROM moo RawStmt: test: select got: SELECT ResTarget: test: select foo as bar got: SELECT foo AS bar test: update foo set bar[2] = 1 got: UPDATE foo SET bar = NULL RowExpr: test: select row(1, foo) got: SELECT foo test: select row(1, 2) = row(3, '') got: SELECT ROW(NULL, 2) = ROW(NULL, '') SelectStmt: test: select limit 1 got: SELECT test: select offset 1 got: SELECT test: select 1 got: SELECT test: select foo, bar got: SELECT foo test: select where true got: SELECT test: select 1 from pg_database where foo got: SELECT WHERE foo test: select from foo union select from bar got: SELECT FROM foo test: select from foo, bar got: SELECT FROM foo test: select order by foo, bar got: SELECT ORDER BY foo test: select group by foo, bar got: SELECT GROUP BY foo test: values (1) got: SELECT test: values(1), (moo), (foo) got: VALUES (moo) test: select from (values (moo)) sub got: VALUES (moo) test: with moo as (select) select from foo got: SELECT FROM foo test: select distinct foo got: SELECT foo test: select distinct on (a, b) NULL got: SELECT DISTINCT ON (a) NULL SetToDefault: test: update foo set a = default got: UPDATE foo SET a = NULL SortBy: test: select foo(1 order by moo desc) got: SELECT foo(1) test: select avg(1 order by foo) got: SELECT foo SubLink: test: select (select moo) got: SELECT moo test: select exists(select moo) got: SELECT moo TruncateStmt: test: truncate foo, bar got: TRUNCATE TABLE foo TypeCast: test: select foo::int got: SELECT foo UpdateStmt: test: update foo set a=b, c=d got: UPDATE foo SET c = NULL test: update foo set a=b where true got: UPDATE foo SET a = NULL ViewStmt: test: create view foo as select bar got: SELECT bar test: create view foo (n) as select 1, 2; select n = '' from foo got: CREATE VIEW foo (n) AS SELECT 2; SELECT n = '' FROM foo WindowDef: test: select count(*) over (partition by bar, foo) got: SELECT count(*) OVER (PARTITION BY bar) test: select count(*) over (order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) test: select count(*) over (partition by bar order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) WithClause: test: with recursive a(a) as (select 5), whatever as (select), b(b) as (select '') select a = b from a, b got: WITH a(a) AS (SELECT 5), b(b) AS (SELECT NULL) SELECT a = b FROM a, b XmlExpr: test: select xmlelement(name bar, moo) got: SELECT moo test: select xmlforest(foo, bar) got: SELECT foo XmlSerialize: test: SELECT xmlserialize(content moo as text) got: SELECT moo AlterDatabaseSetStmt: test: alter database foo reset all got: ALTER DATABASE foo RESET ALL AlterDefaultPrivilegesStmt: test: alter default privileges for role foo revoke delete on tables from bar got: ALTER DEFAULT PRIVILEGES FOR ROLE foo REVOKE DELETE ON TABLES FROM bar AlterDomainStmt: test: alter domain moo add check (value <> '') got: ALTER DOMAIN moo ADD CHECK (value <> '') AlterEventTrigStmt: test: alter event trigger foo disable got: ALTER EVENT TRIGGER foo DISABLE AlterFunctionStmt: test: alter function foo() strict got: ALTER FUNCTION foo () RETURNS NULL ON NULL INPUT AlterObjectSchemaStmt: test: alter table foo set schema bla got: ALTER TABLE foo SET SCHEMA bla AlterOwnerStmt: test: alter large object 42 owner to moo got: ALTER LARGE OBJECT 42 OWNER TO moo AlterRoleSetStmt: test: alter role foo reset all got: ALTER ROLE foo RESET ALL test: alter role foo in database bar reset all got: ALTER ROLE foo IN DATABASE bar RESET ALL AlterRoleStmt: test: alter role foo superuser got: ALTER ROLE foo SUPERUSER AlterSeqStmt: test: alter sequence foo restart 1 got: ALTER SEQUENCE foo RESTART WITH 1 AlterTableStmt: test: alter table foo drop column bar got: ALTER TABLE foo DROP COLUMN bar CommentStmt: test: comment on table foo is 'bar' got: COMMENT ON TABLE foo IS 'bar' CompositeTypeStmt: test: create type foo as (a text, b integer, c timestamp) got: CREATE TYPE foo AS (a text, b integer, c timestamp) CreateCastStmt: test: create cast (foo as bar) without function got: CREATE CAST (foo AS bar) WITHOUT FUNCTION CreateConversionStmt: test: create conversion foo for 'LATIN1' to 'UTF8' from iso8859_1_to_utf8 got: CREATE CONVERSION foo FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8 CreatedbStmt: test: create database foo got: CREATE DATABASE foo CreateDomainStmt: test: create domain foo as int not null got: CREATE DOMAIN foo AS integer NOT NULL CreateEnumStmt: test: create type foo as enum ('foo', 'bar') got: CREATE TYPE foo AS ENUM ('foo', 'bar') CreateEventTrigStmt: test: create event trigger foo on ddl_command_start execute function moo() got: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() CreateFdwStmt: test: create foreign data wrapper foo got: CREATE FOREIGN DATA WRAPPER foo CreateForeignServerStmt: test: create server bar foreign data wrapper foo got: CREATE SERVER bar FOREIGN DATA WRAPPER foo CreateForeignTableStmt: test: create foreign table foo (moo int not null) server bar got: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar CreateFunctionStmt: test: create function moo() returns void as $$ select 1 $$ language sql got: CREATE FUNCTION moo() RETURNS void AS $$ select 1 $$ LANGUAGE sql CreateRangeStmt: test: create type foo as range (subtype = bar) got: CREATE TYPE foo AS RANGE (subtype = bar) CreateOpClassStmt: test: create operator class foo for type bar using moo as storage bla got: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla CreatePublicationStmt: test: create publication foo got: CREATE PUBLICATION foo CreateRoleStmt: test: create role foo got: CREATE ROLE foo CreateSeqStmt: test: create sequence foo got: CREATE SEQUENCE foo CreateSubscriptionStmt: test: create subscription moo connection '' publication foo got: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo CreateTrigStmt: test: create trigger foo before insert on bar execute procedure moo() got: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() CreateUserMappingStmt: test: create user mapping for moo server bar got: CREATE USER MAPPING FOR moo SERVER bar DeallocateStmt: test: deallocate bar got: DEALLOCATE PREPARE bar DefineStmt: test: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') got: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') DiscardStmt: test: discard all got: DISCARD ALL DoStmt: test: do $$ begin end $$ got: DO $$ begin end $$ DropdbStmt: test: drop database foo got: DROP DATABASE foo DropOwnedStmt: test: drop owned by bar got: DROP OWNED BY bar RESTRICT DropRoleStmt: test: drop role moo got: DROP ROLE moo DropStmt: test: drop table foo got: DROP TABLE foo FetchStmt: test: fetch all in foo got: FETCH FORWARD ALL FROM foo GrantStmt: test: grant select on foo to bar got: GRANT SELECT ON TABLE foo TO bar IndexStmt: test: create index on foo(bar) got: CREATE INDEX ON foo (bar) LockStmt: test: lock foo got: LOCK foo IN ACCESS EXCLUSIVE MODE ParamRef: test: select $1 got: SELECT $1 RenameStmt: test: alter table foo rename to bar got: ALTER TABLE foo RENAME TO bar RuleStmt: test: create rule foo as on insert to moo do instead nothing got: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING TransactionStmt: test: begin got: BEGIN expect: BEGIN =========================== short test summary info ============================ FAILED tests/test_sqlreduce.py::test_rules - Exception: TransactionStmt test:... ========================= 1 failed, 2 passed in 22.49s ========================= E: pybuild pybuild:389: test: plugin distutils failed with: exit code=1: cd /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build; python3.13 -m pytest tests dh_auto_test: error: pybuild --test --test-pytest -i python{version} -p 3.13 returned exit code 13 *** /tmp/pg_virtualenv.xQCOGd/log/postgresql-18-regress.log (last 100 lines) *** 2025-10-31 05:53:37.686 /USR/SHARE/ZONEINFO/ETC/GMT [2130604] pbuilder1@postgres ERROR: type "foo" does not exist 2025-10-31 05:53:37.686 /USR/SHARE/ZONEINFO/ETC/GMT [2130604] pbuilder1@postgres STATEMENT: CREATE CAST (foo AS bar) WITHOUT FUNCTION 2025-10-31 05:53:37.720 /USR/SHARE/ZONEINFO/ETC/GMT [2130607] pbuilder1@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-10-31 05:53:37.720 /USR/SHARE/ZONEINFO/ETC/GMT [2130607] pbuilder1@postgres STATEMENT: create database foo 2025-10-31 05:53:37.730 /USR/SHARE/ZONEINFO/ETC/GMT [2130608] pbuilder1@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-10-31 05:53:37.730 /USR/SHARE/ZONEINFO/ETC/GMT [2130608] pbuilder1@postgres STATEMENT: CREATE DATABASE foo 2025-10-31 05:53:37.787 /USR/SHARE/ZONEINFO/ETC/GMT [2130613] pbuilder1@postgres ERROR: function moo() does not exist 2025-10-31 05:53:37.787 /USR/SHARE/ZONEINFO/ETC/GMT [2130613] pbuilder1@postgres STATEMENT: create event trigger foo on ddl_command_start execute function moo() 2025-10-31 05:53:37.798 /USR/SHARE/ZONEINFO/ETC/GMT [2130614] pbuilder1@postgres ERROR: function moo() does not exist 2025-10-31 05:53:37.798 /USR/SHARE/ZONEINFO/ETC/GMT [2130614] pbuilder1@postgres STATEMENT: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() 2025-10-31 05:53:37.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130617] pbuilder1@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-10-31 05:53:37.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130617] pbuilder1@postgres STATEMENT: create server bar foreign data wrapper foo 2025-10-31 05:53:37.841 /USR/SHARE/ZONEINFO/ETC/GMT [2130619] pbuilder1@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-10-31 05:53:37.841 /USR/SHARE/ZONEINFO/ETC/GMT [2130619] pbuilder1@postgres STATEMENT: CREATE SERVER bar FOREIGN DATA WRAPPER foo 2025-10-31 05:53:37.854 /USR/SHARE/ZONEINFO/ETC/GMT [2130621] pbuilder1@postgres ERROR: server "bar" does not exist 2025-10-31 05:53:37.854 /USR/SHARE/ZONEINFO/ETC/GMT [2130621] pbuilder1@postgres STATEMENT: create foreign table foo (moo int not null) server bar 2025-10-31 05:53:37.866 /USR/SHARE/ZONEINFO/ETC/GMT [2130622] pbuilder1@postgres ERROR: server "bar" does not exist 2025-10-31 05:53:37.866 /USR/SHARE/ZONEINFO/ETC/GMT [2130622] pbuilder1@postgres STATEMENT: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar 2025-10-31 05:53:37.900 /USR/SHARE/ZONEINFO/ETC/GMT [2130625] pbuilder1@postgres ERROR: type "bar" does not exist 2025-10-31 05:53:37.900 /USR/SHARE/ZONEINFO/ETC/GMT [2130625] pbuilder1@postgres STATEMENT: create type foo as range (subtype = bar) 2025-10-31 05:53:37.911 /USR/SHARE/ZONEINFO/ETC/GMT [2130626] pbuilder1@postgres ERROR: type "bar" does not exist 2025-10-31 05:53:37.911 /USR/SHARE/ZONEINFO/ETC/GMT [2130626] pbuilder1@postgres STATEMENT: CREATE TYPE foo AS RANGE (subtype = bar) 2025-10-31 05:53:37.922 /USR/SHARE/ZONEINFO/ETC/GMT [2130627] pbuilder1@postgres ERROR: access method "moo" does not exist 2025-10-31 05:53:37.922 /USR/SHARE/ZONEINFO/ETC/GMT [2130627] pbuilder1@postgres STATEMENT: create operator class foo for type bar using moo as storage bla 2025-10-31 05:53:37.933 /USR/SHARE/ZONEINFO/ETC/GMT [2130628] pbuilder1@postgres ERROR: access method "moo" does not exist 2025-10-31 05:53:37.933 /USR/SHARE/ZONEINFO/ETC/GMT [2130628] pbuilder1@postgres STATEMENT: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla 2025-10-31 05:53:37.945 /USR/SHARE/ZONEINFO/ETC/GMT [2130629] pbuilder1@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-10-31 05:53:37.945 /USR/SHARE/ZONEINFO/ETC/GMT [2130629] pbuilder1@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-10-31 05:53:37.955 /USR/SHARE/ZONEINFO/ETC/GMT [2130630] pbuilder1@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-10-31 05:53:37.955 /USR/SHARE/ZONEINFO/ETC/GMT [2130630] pbuilder1@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-10-31 05:53:38.232 /USR/SHARE/ZONEINFO/ETC/GMT [2130671] pbuilder1@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-10-31 05:53:38.232 /USR/SHARE/ZONEINFO/ETC/GMT [2130671] pbuilder1@postgres STATEMENT: create subscription moo connection '' publication foo 2025-10-31 05:53:38.390 /USR/SHARE/ZONEINFO/ETC/GMT [2130703] pbuilder1@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-10-31 05:53:38.390 /USR/SHARE/ZONEINFO/ETC/GMT [2130703] pbuilder1@postgres STATEMENT: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo 2025-10-31 05:53:38.430 /USR/SHARE/ZONEINFO/ETC/GMT [2130725] pbuilder1@postgres ERROR: relation "bar" does not exist 2025-10-31 05:53:38.430 /USR/SHARE/ZONEINFO/ETC/GMT [2130725] pbuilder1@postgres STATEMENT: create trigger foo before insert on bar execute procedure moo() 2025-10-31 05:53:38.441 /USR/SHARE/ZONEINFO/ETC/GMT [2130733] pbuilder1@postgres ERROR: relation "bar" does not exist 2025-10-31 05:53:38.441 /USR/SHARE/ZONEINFO/ETC/GMT [2130733] pbuilder1@postgres STATEMENT: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() 2025-10-31 05:53:38.452 /USR/SHARE/ZONEINFO/ETC/GMT [2130737] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.452 /USR/SHARE/ZONEINFO/ETC/GMT [2130737] pbuilder1@postgres STATEMENT: create user mapping for moo server bar 2025-10-31 05:53:38.463 /USR/SHARE/ZONEINFO/ETC/GMT [2130738] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.463 /USR/SHARE/ZONEINFO/ETC/GMT [2130738] pbuilder1@postgres STATEMENT: CREATE USER MAPPING FOR moo SERVER bar 2025-10-31 05:53:38.474 /USR/SHARE/ZONEINFO/ETC/GMT [2130739] pbuilder1@postgres ERROR: prepared statement "bar" does not exist 2025-10-31 05:53:38.474 /USR/SHARE/ZONEINFO/ETC/GMT [2130739] pbuilder1@postgres STATEMENT: deallocate bar 2025-10-31 05:53:38.484 /USR/SHARE/ZONEINFO/ETC/GMT [2130740] pbuilder1@postgres ERROR: prepared statement "bar" does not exist 2025-10-31 05:53:38.484 /USR/SHARE/ZONEINFO/ETC/GMT [2130740] pbuilder1@postgres STATEMENT: DEALLOCATE PREPARE bar 2025-10-31 05:53:38.496 /USR/SHARE/ZONEINFO/ETC/GMT [2130744] pbuilder1@postgres ERROR: function foo(integer[]) does not exist 2025-10-31 05:53:38.496 /USR/SHARE/ZONEINFO/ETC/GMT [2130744] pbuilder1@postgres STATEMENT: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-10-31 05:53:38.508 /USR/SHARE/ZONEINFO/ETC/GMT [2130746] pbuilder1@postgres ERROR: function foo(integer[]) does not exist 2025-10-31 05:53:38.508 /USR/SHARE/ZONEINFO/ETC/GMT [2130746] pbuilder1@postgres STATEMENT: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-10-31 05:53:38.520 /USR/SHARE/ZONEINFO/ETC/GMT [2130748] pbuilder1@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-10-31 05:53:38.520 /USR/SHARE/ZONEINFO/ETC/GMT [2130748] pbuilder1@postgres STATEMENT: discard all 2025-10-31 05:53:38.602 /USR/SHARE/ZONEINFO/ETC/GMT [2130753] pbuilder1@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-10-31 05:53:38.602 /USR/SHARE/ZONEINFO/ETC/GMT [2130753] pbuilder1@postgres STATEMENT: DISCARD ALL 2025-10-31 05:53:38.732 /USR/SHARE/ZONEINFO/ETC/GMT [2130766] pbuilder1@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-10-31 05:53:38.732 /USR/SHARE/ZONEINFO/ETC/GMT [2130766] pbuilder1@postgres STATEMENT: drop database foo 2025-10-31 05:53:38.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130768] pbuilder1@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-10-31 05:53:38.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130768] pbuilder1@postgres STATEMENT: DROP DATABASE foo 2025-10-31 05:53:38.946 /USR/SHARE/ZONEINFO/ETC/GMT [2130770] pbuilder1@postgres ERROR: role "bar" does not exist 2025-10-31 05:53:38.946 /USR/SHARE/ZONEINFO/ETC/GMT [2130770] pbuilder1@postgres STATEMENT: drop owned by bar 2025-10-31 05:53:38.963 /USR/SHARE/ZONEINFO/ETC/GMT [2130777] pbuilder1@postgres ERROR: role "bar" does not exist 2025-10-31 05:53:38.963 /USR/SHARE/ZONEINFO/ETC/GMT [2130777] pbuilder1@postgres STATEMENT: DROP OWNED BY bar RESTRICT 2025-10-31 05:53:38.981 /USR/SHARE/ZONEINFO/ETC/GMT [2130778] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.981 /USR/SHARE/ZONEINFO/ETC/GMT [2130778] pbuilder1@postgres STATEMENT: drop role moo 2025-10-31 05:53:38.997 /USR/SHARE/ZONEINFO/ETC/GMT [2130779] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.997 /USR/SHARE/ZONEINFO/ETC/GMT [2130779] pbuilder1@postgres STATEMENT: DROP ROLE moo 2025-10-31 05:53:39.008 /USR/SHARE/ZONEINFO/ETC/GMT [2130780] pbuilder1@postgres ERROR: table "foo" does not exist 2025-10-31 05:53:39.008 /USR/SHARE/ZONEINFO/ETC/GMT [2130780] pbuilder1@postgres STATEMENT: drop table foo 2025-10-31 05:53:39.019 /USR/SHARE/ZONEINFO/ETC/GMT [2130781] pbuilder1@postgres ERROR: table "foo" does not exist 2025-10-31 05:53:39.019 /USR/SHARE/ZONEINFO/ETC/GMT [2130781] pbuilder1@postgres STATEMENT: DROP TABLE foo 2025-10-31 05:53:39.030 /USR/SHARE/ZONEINFO/ETC/GMT [2130782] pbuilder1@postgres ERROR: cursor "foo" does not exist 2025-10-31 05:53:39.030 /USR/SHARE/ZONEINFO/ETC/GMT [2130782] pbuilder1@postgres STATEMENT: fetch all in foo 2025-10-31 05:53:39.041 /USR/SHARE/ZONEINFO/ETC/GMT [2130783] pbuilder1@postgres ERROR: cursor "foo" does not exist 2025-10-31 05:53:39.041 /USR/SHARE/ZONEINFO/ETC/GMT [2130783] pbuilder1@postgres STATEMENT: FETCH FORWARD ALL FROM foo 2025-10-31 05:53:39.052 /USR/SHARE/ZONEINFO/ETC/GMT [2130785] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.052 /USR/SHARE/ZONEINFO/ETC/GMT [2130785] pbuilder1@postgres STATEMENT: grant select on foo to bar 2025-10-31 05:53:39.063 /USR/SHARE/ZONEINFO/ETC/GMT [2130786] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.063 /USR/SHARE/ZONEINFO/ETC/GMT [2130786] pbuilder1@postgres STATEMENT: GRANT SELECT ON TABLE foo TO bar 2025-10-31 05:53:39.350 /USR/SHARE/ZONEINFO/ETC/GMT [2130794] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.350 /USR/SHARE/ZONEINFO/ETC/GMT [2130794] pbuilder1@postgres STATEMENT: create index on foo(bar) 2025-10-31 05:53:39.361 /USR/SHARE/ZONEINFO/ETC/GMT [2130807] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.361 /USR/SHARE/ZONEINFO/ETC/GMT [2130807] pbuilder1@postgres STATEMENT: CREATE INDEX ON foo (bar) 2025-10-31 05:53:39.372 /USR/SHARE/ZONEINFO/ETC/GMT [2130809] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.372 /USR/SHARE/ZONEINFO/ETC/GMT [2130809] pbuilder1@postgres STATEMENT: lock foo 2025-10-31 05:53:39.382 /USR/SHARE/ZONEINFO/ETC/GMT [2130810] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.382 /USR/SHARE/ZONEINFO/ETC/GMT [2130810] pbuilder1@postgres STATEMENT: LOCK foo IN ACCESS EXCLUSIVE MODE 2025-10-31 05:53:39.393 /USR/SHARE/ZONEINFO/ETC/GMT [2130811] pbuilder1@postgres ERROR: there is no parameter $1 at character 8 2025-10-31 05:53:39.393 /USR/SHARE/ZONEINFO/ETC/GMT [2130811] pbuilder1@postgres STATEMENT: select $1 2025-10-31 05:53:39.404 /USR/SHARE/ZONEINFO/ETC/GMT [2130812] pbuilder1@postgres ERROR: there is no parameter $1 at character 8 2025-10-31 05:53:39.404 /USR/SHARE/ZONEINFO/ETC/GMT [2130812] pbuilder1@postgres STATEMENT: SELECT $1 2025-10-31 05:53:39.426 /USR/SHARE/ZONEINFO/ETC/GMT [2130814] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.426 /USR/SHARE/ZONEINFO/ETC/GMT [2130814] pbuilder1@postgres STATEMENT: alter table foo rename to bar 2025-10-31 05:53:39.436 /USR/SHARE/ZONEINFO/ETC/GMT [2130815] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.436 /USR/SHARE/ZONEINFO/ETC/GMT [2130815] pbuilder1@postgres STATEMENT: ALTER TABLE foo RENAME TO bar 2025-10-31 05:53:39.447 /USR/SHARE/ZONEINFO/ETC/GMT [2130816] pbuilder1@postgres ERROR: relation "moo" does not exist 2025-10-31 05:53:39.447 /USR/SHARE/ZONEINFO/ETC/GMT [2130816] pbuilder1@postgres STATEMENT: create rule foo as on insert to moo do instead nothing 2025-10-31 05:53:39.458 /USR/SHARE/ZONEINFO/ETC/GMT [2130817] pbuilder1@postgres ERROR: relation "moo" does not exist 2025-10-31 05:53:39.458 /USR/SHARE/ZONEINFO/ETC/GMT [2130817] pbuilder1@postgres STATEMENT: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING 2025-10-31 05:53:39.469 /USR/SHARE/ZONEINFO/ETC/GMT [2130818] pbuilder1@postgres WARNING: there is already a transaction in progress 2025-10-31 05:53:39.479 /USR/SHARE/ZONEINFO/ETC/GMT [2130819] pbuilder1@postgres WARNING: there is already a transaction in progress Dropping cluster 18/regress ... make[1]: *** [debian/rules:8: override_dh_auto_test] Error 25 make[1]: Leaving directory '/build/reproducible-path/sqlreduce-1.3' make: *** [debian/rules:21: binary] Error 2 dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2 I: copying local configuration E: Failed autobuilding of package 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/2117968 and its subdirectories Starting cleanup. All cleanup done. Fri Oct 31 17:53:46 UTC 2025 - reproducible_build.sh stopped running as /tmp/jenkins-script-DFkmRqlf, removing. /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY: total 16 drwxrwxr-x 2 jenkins jenkins 4096 Oct 31 17:53 b1 drwxrwxr-x 2 jenkins jenkins 4096 Oct 31 17:51 b2 -rw------- 1 jenkins jenkins 3139 Oct 31 17:51 rbuildlog.KMKBG8W -rw-rw-r-- 1 jenkins jenkins 2039 Jan 30 2024 sqlreduce_1.3-1.dsc /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY/b1: total 76 -rw-r--r-- 1 jenkins jenkins 76319 Oct 31 17:53 build.log /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY/b2: total 0 Fri Oct 31 17:53:47 UTC 2025 I: Deleting $TMPDIR on ionos11-amd64.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Fri Oct 31 05:51:55 -12 2025 I: pbuilder-time-stamp: 1761933115 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/forky-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [sqlreduce_1.3-1.dsc] I: copying [./sqlreduce_1.3.orig.tar.gz] I: copying [./sqlreduce_1.3-1.debian.tar.xz] I: Extracting source dpkg-source: warning: cannot verify inline signature for ./sqlreduce_1.3-1.dsc: no acceptable signature found dpkg-source: info: extracting sqlreduce in sqlreduce-1.3 dpkg-source: info: unpacking sqlreduce_1.3.orig.tar.gz dpkg-source: info: unpacking sqlreduce_1.3-1.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/2117968/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='amd64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=40 ' DISTRIBUTION='forky' HOME='/root' HOST_ARCH='amd64' IFS=' ' INVOCATION_ID='929e41747c7c4a5e847252d432c9881c' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' 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='2117968' 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.fbfXXHqY/pbuilderrc_c2h5 --distribution forky --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.fbfXXHqY/b1 --logfile b1/build.log sqlreduce_1.3-1.dsc' SUDO_GID='111' SUDO_HOME='/var/lib/jenkins' SUDO_UID='106' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://46.16.76.132:3128' I: uname -a Linux ionos11-amd64 6.12.48+deb13-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.48-1 (2025-09-20) x86_64 GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 Aug 10 12:30 /bin -> usr/bin I: user script /srv/workspace/pbuilder/2117968/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 13), dh-python, help2man, postgresql, python3-all, python3-pglast, python3-psycopg2, python3-pytest, python3-setuptools, python3-yaml dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19869 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 13); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-python; however: Package dh-python is not installed. pbuilder-satisfydepends-dummy depends on help2man; however: Package help2man is not installed. pbuilder-satisfydepends-dummy depends on postgresql; however: Package postgresql is not installed. pbuilder-satisfydepends-dummy depends on python3-all; however: Package python3-all is not installed. pbuilder-satisfydepends-dummy depends on python3-pglast; however: Package python3-pglast is not installed. pbuilder-satisfydepends-dummy depends on python3-psycopg2; however: Package python3-psycopg2 is not installed. pbuilder-satisfydepends-dummy depends on python3-pytest; however: Package python3-pytest is not installed. pbuilder-satisfydepends-dummy depends on python3-setuptools; however: Package python3-setuptools is not installed. pbuilder-satisfydepends-dummy depends on python3-yaml; however: Package python3-yaml is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-python{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} groff-base{a} help2man{a} intltool-debian{a} libarchive-zip-perl{a} libcom-err2{a} libdebhelper-perl{a} libelf1t64{a} libexpat1{a} libffi8{a} libfile-stripnondeterminism-perl{a} libgcrypt20{a} libgpg-error0{a} libgssapi-krb5-2{a} libicu76{a} libio-pty-perl{a} libipc-run-perl{a} libjson-perl{a} libk5crypto3{a} libkeyutils1{a} libkrb5-3{a} libkrb5support0{a} libldap2{a} liblocale-gettext-perl{a} libmagic-mgc{a} libmagic1t64{a} libnuma1{a} libpg-query1706.0{a} libpipeline1{a} libpq5{a} libproc2-0{a} libpython3-stdlib{a} libpython3.13-minimal{a} libpython3.13-stdlib{a} libreadline8t64{a} libsasl2-2{a} libsasl2-modules-db{a} libtext-charwidth-perl{a} libtext-wrapi18n-perl{a} libtool{a} libuchardet0{a} libunistring5{a} liburing2{a} libxml2-16{a} libxslt1.1{a} libyaml-0-2{a} m4{a} man-db{a} media-types{a} netbase{a} openssl{a} po-debconf{a} postgresql{a} postgresql-18{a} postgresql-client-18{a} postgresql-client-common{a} postgresql-common{a} postgresql-common-dev{a} procps{a} python3{a} python3-all{a} python3-autocommand{a} python3-inflect{a} python3-iniconfig{a} python3-jaraco.context{a} python3-jaraco.functools{a} python3-jaraco.text{a} python3-minimal{a} python3-more-itertools{a} python3-packaging{a} python3-pglast{a} python3-pkg-resources{a} python3-pluggy{a} python3-psycopg2{a} python3-pygments{a} python3-pytest{a} python3-setuptools{a} python3-typeguard{a} python3-typing-extensions{a} python3-yaml{a} python3-zipp{a} python3.13{a} python3.13-minimal{a} readline-common{a} sensible-utils{a} ssl-cert{a} tzdata{a} ucf{a} The following packages are RECOMMENDED but will NOT be installed: ca-certificates curl e2fsprogs krb5-locales libarchive-cpio-perl libgpg-error-l10n libjson-xs-perl libldap-common libltdl-dev libmail-sendmail-perl libsasl2-modules linux-sysctl-defaults logrotate lynx postgresql-18-jit psmisc sysstat wget 0 packages upgraded, 100 newly installed, 0 to remove and 0 not upgraded. Need to get 46.3 MB of archives. After unpacking 187 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian forky/main amd64 libexpat1 amd64 2.7.3-1 [112 kB] Get: 2 http://deb.debian.org/debian forky/main amd64 liblocale-gettext-perl amd64 1.07-7+b1 [15.3 kB] Get: 3 http://deb.debian.org/debian forky/main amd64 libjson-perl all 4.10000-1 [87.5 kB] Get: 4 http://deb.debian.org/debian forky/main amd64 netbase all 6.5 [12.4 kB] Get: 5 http://deb.debian.org/debian forky/main amd64 postgresql-client-common all 286 [47.9 kB] Get: 6 http://deb.debian.org/debian forky/main amd64 libio-pty-perl amd64 1:1.20-1+b3 [34.3 kB] Get: 7 http://deb.debian.org/debian forky/main amd64 libipc-run-perl all 20231003.0-2 [101 kB] Get: 8 http://deb.debian.org/debian forky/main amd64 postgresql-common-dev all 286 [73.2 kB] Get: 9 http://deb.debian.org/debian forky/main amd64 openssl amd64 3.5.4-1 [1496 kB] Get: 10 http://deb.debian.org/debian forky/main amd64 ssl-cert all 1.1.3 [16.8 kB] Get: 11 http://deb.debian.org/debian forky/main amd64 libtext-charwidth-perl amd64 0.04-11+b4 [9476 B] Get: 12 http://deb.debian.org/debian forky/main amd64 libtext-wrapi18n-perl all 0.06-10 [8808 B] Get: 13 http://deb.debian.org/debian forky/main amd64 libproc2-0 amd64 2:4.0.4-9 [65.6 kB] Get: 14 http://deb.debian.org/debian forky/main amd64 procps amd64 2:4.0.4-9 [882 kB] Get: 15 http://deb.debian.org/debian forky/main amd64 sensible-utils all 0.0.26 [27.0 kB] Get: 16 http://deb.debian.org/debian forky/main amd64 ucf all 3.0052 [43.3 kB] Get: 17 http://deb.debian.org/debian forky/main amd64 postgresql-common all 286 [112 kB] Get: 18 http://deb.debian.org/debian forky/main amd64 libpython3.13-minimal amd64 3.13.9-1 [865 kB] Get: 19 http://deb.debian.org/debian forky/main amd64 python3.13-minimal amd64 3.13.9-1 [2257 kB] Get: 20 http://deb.debian.org/debian forky/main amd64 python3-minimal amd64 3.13.7-1 [27.2 kB] Get: 21 http://deb.debian.org/debian forky/main amd64 media-types all 14.0.0 [30.8 kB] Get: 22 http://deb.debian.org/debian forky/main amd64 tzdata all 2025b-5 [260 kB] Get: 23 http://deb.debian.org/debian forky/main amd64 libffi8 amd64 3.5.2-2 [25.5 kB] Get: 24 http://deb.debian.org/debian forky/main amd64 readline-common all 8.3-3 [74.8 kB] Get: 25 http://deb.debian.org/debian forky/main amd64 libreadline8t64 amd64 8.3-3 [191 kB] Get: 26 http://deb.debian.org/debian forky/main amd64 libpython3.13-stdlib amd64 3.13.9-1 [1965 kB] Get: 27 http://deb.debian.org/debian forky/main amd64 python3.13 amd64 3.13.9-1 [764 kB] Get: 28 http://deb.debian.org/debian forky/main amd64 libpython3-stdlib amd64 3.13.7-1 [10.2 kB] Get: 29 http://deb.debian.org/debian forky/main amd64 python3 amd64 3.13.7-1 [28.3 kB] Get: 30 http://deb.debian.org/debian forky/main amd64 libmagic-mgc amd64 1:5.46-5 [338 kB] Get: 31 http://deb.debian.org/debian forky/main amd64 libmagic1t64 amd64 1:5.46-5 [109 kB] Get: 32 http://deb.debian.org/debian forky/main amd64 file amd64 1:5.46-5 [43.6 kB] Get: 33 http://deb.debian.org/debian forky/main amd64 gettext-base amd64 0.23.1-2+b1 [244 kB] Get: 34 http://deb.debian.org/debian forky/main amd64 libuchardet0 amd64 0.0.8-2 [68.5 kB] Get: 35 http://deb.debian.org/debian forky/main amd64 groff-base amd64 1.23.0-9 [1187 kB] Get: 36 http://deb.debian.org/debian forky/main amd64 bsdextrautils amd64 2.41.2-4 [98.5 kB] Get: 37 http://deb.debian.org/debian forky/main amd64 libpipeline1 amd64 1.5.8-1 [42.0 kB] Get: 38 http://deb.debian.org/debian forky/main amd64 man-db amd64 2.13.1-1 [1469 kB] Get: 39 http://deb.debian.org/debian forky/main amd64 m4 amd64 1.4.20-2 [325 kB] Get: 40 http://deb.debian.org/debian forky/main amd64 autoconf all 2.72-3.1 [494 kB] Get: 41 http://deb.debian.org/debian forky/main amd64 autotools-dev all 20240727.1 [60.2 kB] Get: 42 http://deb.debian.org/debian forky/main amd64 automake all 1:1.18.1-2 [877 kB] Get: 43 http://deb.debian.org/debian forky/main amd64 autopoint all 0.23.1-2 [770 kB] Get: 44 http://deb.debian.org/debian forky/main amd64 libdebhelper-perl all 13.28 [92.4 kB] Get: 45 http://deb.debian.org/debian forky/main amd64 libtool all 2.5.4-7 [540 kB] Get: 46 http://deb.debian.org/debian forky/main amd64 dh-autoreconf all 21 [12.2 kB] Get: 47 http://deb.debian.org/debian forky/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 48 http://deb.debian.org/debian forky/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [19.9 kB] Get: 49 http://deb.debian.org/debian forky/main amd64 dh-strip-nondeterminism all 1.15.0-1 [8812 B] Get: 50 http://deb.debian.org/debian forky/main amd64 libelf1t64 amd64 0.193-3 [192 kB] Get: 51 http://deb.debian.org/debian forky/main amd64 dwz amd64 0.16-2 [108 kB] Get: 52 http://deb.debian.org/debian forky/main amd64 libunistring5 amd64 1.3-2 [477 kB] Get: 53 http://deb.debian.org/debian forky/main amd64 libxml2-16 amd64 2.14.6+dfsg-0.1 [651 kB] Get: 54 http://deb.debian.org/debian forky/main amd64 gettext amd64 0.23.1-2+b1 [1680 kB] Get: 55 http://deb.debian.org/debian forky/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 56 http://deb.debian.org/debian forky/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 57 http://deb.debian.org/debian forky/main amd64 debhelper all 13.28 [941 kB] Get: 58 http://deb.debian.org/debian forky/main amd64 dh-python all 6.20250414 [116 kB] Get: 59 http://deb.debian.org/debian forky/main amd64 help2man amd64 1.49.3 [198 kB] Get: 60 http://deb.debian.org/debian forky/main amd64 libcom-err2 amd64 1.47.2-3+b3 [25.0 kB] Get: 61 http://deb.debian.org/debian forky/main amd64 libgpg-error0 amd64 1.56-2 [89.1 kB] Get: 62 http://deb.debian.org/debian forky/main amd64 libgcrypt20 amd64 1.11.2-2 [865 kB] Get: 63 http://deb.debian.org/debian forky/main amd64 libkrb5support0 amd64 1.21.3-5 [33.0 kB] Get: 64 http://deb.debian.org/debian forky/main amd64 libk5crypto3 amd64 1.21.3-5 [81.5 kB] Get: 65 http://deb.debian.org/debian forky/main amd64 libkeyutils1 amd64 1.6.3-6 [9456 B] Get: 66 http://deb.debian.org/debian forky/main amd64 libkrb5-3 amd64 1.21.3-5 [326 kB] Get: 67 http://deb.debian.org/debian forky/main amd64 libgssapi-krb5-2 amd64 1.21.3-5 [138 kB] Get: 68 http://deb.debian.org/debian forky/main amd64 libicu76 amd64 76.1-4 [9722 kB] Get: 69 http://deb.debian.org/debian forky/main amd64 libsasl2-modules-db amd64 2.1.28+dfsg1-10 [19.8 kB] Get: 70 http://deb.debian.org/debian forky/main amd64 libsasl2-2 amd64 2.1.28+dfsg1-10 [57.8 kB] Get: 71 http://deb.debian.org/debian forky/main amd64 libldap2 amd64 2.6.10+dfsg-1 [194 kB] Get: 72 http://deb.debian.org/debian forky/main amd64 libnuma1 amd64 2.0.19-1 [22.2 kB] Get: 73 http://deb.debian.org/debian forky/main amd64 libpg-query1706.0 amd64 17-6.1.0-1 [595 kB] Get: 74 http://deb.debian.org/debian forky/main amd64 libpq5 amd64 18.0-1 [251 kB] Get: 75 http://deb.debian.org/debian forky/main amd64 liburing2 amd64 2.12-1 [29.5 kB] Get: 76 http://deb.debian.org/debian forky/main amd64 libxslt1.1 amd64 1.1.43-0.3 [158 kB] Get: 77 http://deb.debian.org/debian forky/main amd64 libyaml-0-2 amd64 0.2.5-2 [52.5 kB] Get: 78 http://deb.debian.org/debian forky/main amd64 postgresql-client-18 amd64 18.0-1 [2115 kB] Get: 79 http://deb.debian.org/debian forky/main amd64 postgresql-18 amd64 18.0-1 [7237 kB] Get: 80 http://deb.debian.org/debian forky/main amd64 postgresql all 18+286 [17.8 kB] Get: 81 http://deb.debian.org/debian forky/main amd64 python3-all amd64 3.13.7-1 [1048 B] Get: 82 http://deb.debian.org/debian forky/main amd64 python3-autocommand all 2.2.2-3 [13.6 kB] Get: 83 http://deb.debian.org/debian forky/main amd64 python3-more-itertools all 10.8.0-1 [71.7 kB] Get: 84 http://deb.debian.org/debian forky/main amd64 python3-typing-extensions all 4.15.0-1 [92.4 kB] Get: 85 http://deb.debian.org/debian forky/main amd64 python3-typeguard all 4.4.4-1 [37.1 kB] Get: 86 http://deb.debian.org/debian forky/main amd64 python3-inflect all 7.5.0-1 [33.0 kB] Get: 87 http://deb.debian.org/debian forky/main amd64 python3-iniconfig all 2.1.0-1 [7432 B] Get: 88 http://deb.debian.org/debian forky/main amd64 python3-jaraco.functools all 4.1.0-1 [12.0 kB] Get: 89 http://deb.debian.org/debian forky/main amd64 python3-pkg-resources all 78.1.1-0.1 [224 kB] Get: 90 http://deb.debian.org/debian forky/main amd64 python3-jaraco.text all 4.0.0-1 [11.4 kB] Get: 91 http://deb.debian.org/debian forky/main amd64 python3-zipp all 3.23.0-1 [11.0 kB] Get: 92 http://deb.debian.org/debian forky/main amd64 python3-setuptools all 78.1.1-0.1 [738 kB] Get: 93 http://deb.debian.org/debian forky/main amd64 python3-jaraco.context all 6.0.1-1 [8276 B] Get: 94 http://deb.debian.org/debian forky/main amd64 python3-packaging all 25.0-1 [56.6 kB] Get: 95 http://deb.debian.org/debian forky/main amd64 python3-pglast amd64 7.10-1 [331 kB] Get: 96 http://deb.debian.org/debian forky/main amd64 python3-pluggy all 1.6.0-1 [27.1 kB] Get: 97 http://deb.debian.org/debian forky/main amd64 python3-psycopg2 amd64 2.9.10-1+b1 [129 kB] Get: 98 http://deb.debian.org/debian forky/main amd64 python3-pygments all 2.18.0+dfsg-2 [836 kB] Get: 99 http://deb.debian.org/debian forky/main amd64 python3-pytest all 8.4.2-1 [266 kB] Get: 100 http://deb.debian.org/debian forky/main amd64 python3-yaml amd64 6.0.2-2 [137 kB] Fetched 46.3 MB in 0s (124 MB/s) Preconfiguring packages ... /var/cache/debconf/tmp.ci/postgresql.config.X5NEPd: 12: pg_lsclusters: not found Selecting previously unselected package libexpat1:amd64. (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 ... 19869 files and directories currently installed.) Preparing to unpack .../00-libexpat1_2.7.3-1_amd64.deb ... Unpacking libexpat1:amd64 (2.7.3-1) ... Selecting previously unselected package liblocale-gettext-perl. Preparing to unpack .../01-liblocale-gettext-perl_1.07-7+b1_amd64.deb ... Unpacking liblocale-gettext-perl (1.07-7+b1) ... Selecting previously unselected package libjson-perl. Preparing to unpack .../02-libjson-perl_4.10000-1_all.deb ... Unpacking libjson-perl (4.10000-1) ... Selecting previously unselected package netbase. Preparing to unpack .../03-netbase_6.5_all.deb ... Unpacking netbase (6.5) ... Selecting previously unselected package postgresql-client-common. Preparing to unpack .../04-postgresql-client-common_286_all.deb ... Unpacking postgresql-client-common (286) ... Selecting previously unselected package libio-pty-perl. Preparing to unpack .../05-libio-pty-perl_1%3a1.20-1+b3_amd64.deb ... Unpacking libio-pty-perl (1:1.20-1+b3) ... Selecting previously unselected package libipc-run-perl. Preparing to unpack .../06-libipc-run-perl_20231003.0-2_all.deb ... Unpacking libipc-run-perl (20231003.0-2) ... Selecting previously unselected package postgresql-common-dev. Preparing to unpack .../07-postgresql-common-dev_286_all.deb ... Unpacking postgresql-common-dev (286) ... Selecting previously unselected package openssl. Preparing to unpack .../08-openssl_3.5.4-1_amd64.deb ... Unpacking openssl (3.5.4-1) ... Selecting previously unselected package ssl-cert. Preparing to unpack .../09-ssl-cert_1.1.3_all.deb ... Unpacking ssl-cert (1.1.3) ... Selecting previously unselected package libtext-charwidth-perl:amd64. Preparing to unpack .../10-libtext-charwidth-perl_0.04-11+b4_amd64.deb ... Unpacking libtext-charwidth-perl:amd64 (0.04-11+b4) ... Selecting previously unselected package libtext-wrapi18n-perl. Preparing to unpack .../11-libtext-wrapi18n-perl_0.06-10_all.deb ... Unpacking libtext-wrapi18n-perl (0.06-10) ... Selecting previously unselected package libproc2-0:amd64. Preparing to unpack .../12-libproc2-0_2%3a4.0.4-9_amd64.deb ... Unpacking libproc2-0:amd64 (2:4.0.4-9) ... Selecting previously unselected package procps. Preparing to unpack .../13-procps_2%3a4.0.4-9_amd64.deb ... Unpacking procps (2:4.0.4-9) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../14-sensible-utils_0.0.26_all.deb ... Unpacking sensible-utils (0.0.26) ... Selecting previously unselected package ucf. Preparing to unpack .../15-ucf_3.0052_all.deb ... Moving old data out of the way Unpacking ucf (3.0052) ... Selecting previously unselected package postgresql-common. Preparing to unpack .../16-postgresql-common_286_all.deb ... Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' Unpacking postgresql-common (286) ... Selecting previously unselected package libpython3.13-minimal:amd64. Preparing to unpack .../17-libpython3.13-minimal_3.13.9-1_amd64.deb ... Unpacking libpython3.13-minimal:amd64 (3.13.9-1) ... Selecting previously unselected package python3.13-minimal. Preparing to unpack .../18-python3.13-minimal_3.13.9-1_amd64.deb ... Unpacking python3.13-minimal (3.13.9-1) ... Setting up libpython3.13-minimal:amd64 (3.13.9-1) ... Setting up libexpat1:amd64 (2.7.3-1) ... Setting up python3.13-minimal (3.13.9-1) ... Selecting previously unselected package python3-minimal. (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 ... 21147 files and directories currently installed.) Preparing to unpack .../0-python3-minimal_3.13.7-1_amd64.deb ... Unpacking python3-minimal (3.13.7-1) ... Selecting previously unselected package media-types. Preparing to unpack .../1-media-types_14.0.0_all.deb ... Unpacking media-types (14.0.0) ... Selecting previously unselected package tzdata. Preparing to unpack .../2-tzdata_2025b-5_all.deb ... Unpacking tzdata (2025b-5) ... Selecting previously unselected package libffi8:amd64. Preparing to unpack .../3-libffi8_3.5.2-2_amd64.deb ... Unpacking libffi8:amd64 (3.5.2-2) ... Selecting previously unselected package readline-common. Preparing to unpack .../4-readline-common_8.3-3_all.deb ... Unpacking readline-common (8.3-3) ... Selecting previously unselected package libreadline8t64:amd64. Preparing to unpack .../5-libreadline8t64_8.3-3_amd64.deb ... Adding 'diversion of /lib/x86_64-linux-gnu/libhistory.so.8 to /lib/x86_64-linux-gnu/libhistory.so.8.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libhistory.so.8.2 to /lib/x86_64-linux-gnu/libhistory.so.8.2.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libreadline.so.8 to /lib/x86_64-linux-gnu/libreadline.so.8.usr-is-merged by libreadline8t64' Adding 'diversion of /lib/x86_64-linux-gnu/libreadline.so.8.2 to /lib/x86_64-linux-gnu/libreadline.so.8.2.usr-is-merged by libreadline8t64' Unpacking libreadline8t64:amd64 (8.3-3) ... Selecting previously unselected package libpython3.13-stdlib:amd64. Preparing to unpack .../6-libpython3.13-stdlib_3.13.9-1_amd64.deb ... Unpacking libpython3.13-stdlib:amd64 (3.13.9-1) ... Selecting previously unselected package python3.13. Preparing to unpack .../7-python3.13_3.13.9-1_amd64.deb ... Unpacking python3.13 (3.13.9-1) ... Selecting previously unselected package libpython3-stdlib:amd64. Preparing to unpack .../8-libpython3-stdlib_3.13.7-1_amd64.deb ... Unpacking libpython3-stdlib:amd64 (3.13.7-1) ... Setting up python3-minimal (3.13.7-1) ... Selecting previously unselected package python3. (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 ... 22155 files and directories currently installed.) Preparing to unpack .../00-python3_3.13.7-1_amd64.deb ... Unpacking python3 (3.13.7-1) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.46-5_amd64.deb ... Unpacking libmagic-mgc (1:5.46-5) ... Selecting previously unselected package libmagic1t64:amd64. Preparing to unpack .../02-libmagic1t64_1%3a5.46-5_amd64.deb ... Unpacking libmagic1t64:amd64 (1:5.46-5) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.46-5_amd64.deb ... Unpacking file (1:5.46-5) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.23.1-2+b1_amd64.deb ... Unpacking gettext-base (0.23.1-2+b1) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../05-libuchardet0_0.0.8-2_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.8-2) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-9_amd64.deb ... Unpacking groff-base (1.23.0-9) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.41.2-4_amd64.deb ... Unpacking bsdextrautils (2.41.2-4) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../08-libpipeline1_1.5.8-1_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.8-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.13.1-1_amd64.deb ... Unpacking man-db (2.13.1-1) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.20-2_amd64.deb ... Unpacking m4 (1.4.20-2) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.72-3.1_all.deb ... Unpacking autoconf (2.72-3.1) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20240727.1_all.deb ... Unpacking autotools-dev (20240727.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.18.1-2_all.deb ... Unpacking automake (1:1.18.1-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.23.1-2_all.deb ... Unpacking autopoint (0.23.1-2) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.28_all.deb ... Unpacking libdebhelper-perl (13.28) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.5.4-7_all.deb ... Unpacking libtool (2.5.4-7) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_21_all.deb ... Unpacking dh-autoreconf (21) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../19-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../20-dh-strip-nondeterminism_1.15.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.15.0-1) ... Selecting previously unselected package libelf1t64:amd64. Preparing to unpack .../21-libelf1t64_0.193-3_amd64.deb ... Unpacking libelf1t64:amd64 (0.193-3) ... Selecting previously unselected package dwz. Preparing to unpack .../22-dwz_0.16-2_amd64.deb ... Unpacking dwz (0.16-2) ... Selecting previously unselected package libunistring5:amd64. Preparing to unpack .../23-libunistring5_1.3-2_amd64.deb ... Unpacking libunistring5:amd64 (1.3-2) ... Selecting previously unselected package libxml2-16:amd64. Preparing to unpack .../24-libxml2-16_2.14.6+dfsg-0.1_amd64.deb ... Unpacking libxml2-16:amd64 (2.14.6+dfsg-0.1) ... Selecting previously unselected package gettext. Preparing to unpack .../25-gettext_0.23.1-2+b1_amd64.deb ... Unpacking gettext (0.23.1-2+b1) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../26-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../27-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../28-debhelper_13.28_all.deb ... Unpacking debhelper (13.28) ... Selecting previously unselected package dh-python. Preparing to unpack .../29-dh-python_6.20250414_all.deb ... Unpacking dh-python (6.20250414) ... Selecting previously unselected package help2man. Preparing to unpack .../30-help2man_1.49.3_amd64.deb ... Unpacking help2man (1.49.3) ... Selecting previously unselected package libcom-err2:amd64. Preparing to unpack .../31-libcom-err2_1.47.2-3+b3_amd64.deb ... Unpacking libcom-err2:amd64 (1.47.2-3+b3) ... Selecting previously unselected package libgpg-error0:amd64. Preparing to unpack .../32-libgpg-error0_1.56-2_amd64.deb ... Unpacking libgpg-error0:amd64 (1.56-2) ... Selecting previously unselected package libgcrypt20:amd64. Preparing to unpack .../33-libgcrypt20_1.11.2-2_amd64.deb ... Unpacking libgcrypt20:amd64 (1.11.2-2) ... Selecting previously unselected package libkrb5support0:amd64. Preparing to unpack .../34-libkrb5support0_1.21.3-5_amd64.deb ... Unpacking libkrb5support0:amd64 (1.21.3-5) ... Selecting previously unselected package libk5crypto3:amd64. Preparing to unpack .../35-libk5crypto3_1.21.3-5_amd64.deb ... Unpacking libk5crypto3:amd64 (1.21.3-5) ... Selecting previously unselected package libkeyutils1:amd64. Preparing to unpack .../36-libkeyutils1_1.6.3-6_amd64.deb ... Unpacking libkeyutils1:amd64 (1.6.3-6) ... Selecting previously unselected package libkrb5-3:amd64. Preparing to unpack .../37-libkrb5-3_1.21.3-5_amd64.deb ... Unpacking libkrb5-3:amd64 (1.21.3-5) ... Selecting previously unselected package libgssapi-krb5-2:amd64. Preparing to unpack .../38-libgssapi-krb5-2_1.21.3-5_amd64.deb ... Unpacking libgssapi-krb5-2:amd64 (1.21.3-5) ... Selecting previously unselected package libicu76:amd64. Preparing to unpack .../39-libicu76_76.1-4_amd64.deb ... Unpacking libicu76:amd64 (76.1-4) ... Selecting previously unselected package libsasl2-modules-db:amd64. Preparing to unpack .../40-libsasl2-modules-db_2.1.28+dfsg1-10_amd64.deb ... Unpacking libsasl2-modules-db:amd64 (2.1.28+dfsg1-10) ... Selecting previously unselected package libsasl2-2:amd64. Preparing to unpack .../41-libsasl2-2_2.1.28+dfsg1-10_amd64.deb ... Unpacking libsasl2-2:amd64 (2.1.28+dfsg1-10) ... Selecting previously unselected package libldap2:amd64. Preparing to unpack .../42-libldap2_2.6.10+dfsg-1_amd64.deb ... Unpacking libldap2:amd64 (2.6.10+dfsg-1) ... Selecting previously unselected package libnuma1:amd64. Preparing to unpack .../43-libnuma1_2.0.19-1_amd64.deb ... Unpacking libnuma1:amd64 (2.0.19-1) ... Selecting previously unselected package libpg-query1706.0:amd64. Preparing to unpack .../44-libpg-query1706.0_17-6.1.0-1_amd64.deb ... Unpacking libpg-query1706.0:amd64 (17-6.1.0-1) ... Selecting previously unselected package libpq5:amd64. Preparing to unpack .../45-libpq5_18.0-1_amd64.deb ... Unpacking libpq5:amd64 (18.0-1) ... Selecting previously unselected package liburing2:amd64. Preparing to unpack .../46-liburing2_2.12-1_amd64.deb ... Unpacking liburing2:amd64 (2.12-1) ... Selecting previously unselected package libxslt1.1:amd64. Preparing to unpack .../47-libxslt1.1_1.1.43-0.3_amd64.deb ... Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... Selecting previously unselected package libyaml-0-2:amd64. Preparing to unpack .../48-libyaml-0-2_0.2.5-2_amd64.deb ... Unpacking libyaml-0-2:amd64 (0.2.5-2) ... Selecting previously unselected package postgresql-client-18. Preparing to unpack .../49-postgresql-client-18_18.0-1_amd64.deb ... Unpacking postgresql-client-18 (18.0-1) ... Selecting previously unselected package postgresql-18. Preparing to unpack .../50-postgresql-18_18.0-1_amd64.deb ... Unpacking postgresql-18 (18.0-1) ... Selecting previously unselected package postgresql. Preparing to unpack .../51-postgresql_18+286_all.deb ... Unpacking postgresql (18+286) ... Selecting previously unselected package python3-all. Preparing to unpack .../52-python3-all_3.13.7-1_amd64.deb ... Unpacking python3-all (3.13.7-1) ... Selecting previously unselected package python3-autocommand. Preparing to unpack .../53-python3-autocommand_2.2.2-3_all.deb ... Unpacking python3-autocommand (2.2.2-3) ... Selecting previously unselected package python3-more-itertools. Preparing to unpack .../54-python3-more-itertools_10.8.0-1_all.deb ... Unpacking python3-more-itertools (10.8.0-1) ... Selecting previously unselected package python3-typing-extensions. Preparing to unpack .../55-python3-typing-extensions_4.15.0-1_all.deb ... Unpacking python3-typing-extensions (4.15.0-1) ... Selecting previously unselected package python3-typeguard. Preparing to unpack .../56-python3-typeguard_4.4.4-1_all.deb ... Unpacking python3-typeguard (4.4.4-1) ... Selecting previously unselected package python3-inflect. Preparing to unpack .../57-python3-inflect_7.5.0-1_all.deb ... Unpacking python3-inflect (7.5.0-1) ... Selecting previously unselected package python3-iniconfig. Preparing to unpack .../58-python3-iniconfig_2.1.0-1_all.deb ... Unpacking python3-iniconfig (2.1.0-1) ... Selecting previously unselected package python3-jaraco.functools. Preparing to unpack .../59-python3-jaraco.functools_4.1.0-1_all.deb ... Unpacking python3-jaraco.functools (4.1.0-1) ... Selecting previously unselected package python3-pkg-resources. Preparing to unpack .../60-python3-pkg-resources_78.1.1-0.1_all.deb ... Unpacking python3-pkg-resources (78.1.1-0.1) ... Selecting previously unselected package python3-jaraco.text. Preparing to unpack .../61-python3-jaraco.text_4.0.0-1_all.deb ... Unpacking python3-jaraco.text (4.0.0-1) ... Selecting previously unselected package python3-zipp. Preparing to unpack .../62-python3-zipp_3.23.0-1_all.deb ... Unpacking python3-zipp (3.23.0-1) ... Selecting previously unselected package python3-setuptools. Preparing to unpack .../63-python3-setuptools_78.1.1-0.1_all.deb ... Unpacking python3-setuptools (78.1.1-0.1) ... Selecting previously unselected package python3-jaraco.context. Preparing to unpack .../64-python3-jaraco.context_6.0.1-1_all.deb ... Unpacking python3-jaraco.context (6.0.1-1) ... Selecting previously unselected package python3-packaging. Preparing to unpack .../65-python3-packaging_25.0-1_all.deb ... Unpacking python3-packaging (25.0-1) ... Selecting previously unselected package python3-pglast. Preparing to unpack .../66-python3-pglast_7.10-1_amd64.deb ... Unpacking python3-pglast (7.10-1) ... Selecting previously unselected package python3-pluggy. Preparing to unpack .../67-python3-pluggy_1.6.0-1_all.deb ... Unpacking python3-pluggy (1.6.0-1) ... Selecting previously unselected package python3-psycopg2. Preparing to unpack .../68-python3-psycopg2_2.9.10-1+b1_amd64.deb ... Unpacking python3-psycopg2 (2.9.10-1+b1) ... Selecting previously unselected package python3-pygments. Preparing to unpack .../69-python3-pygments_2.18.0+dfsg-2_all.deb ... Unpacking python3-pygments (2.18.0+dfsg-2) ... Selecting previously unselected package python3-pytest. Preparing to unpack .../70-python3-pytest_8.4.2-1_all.deb ... Unpacking python3-pytest (8.4.2-1) ... Selecting previously unselected package python3-yaml. Preparing to unpack .../71-python3-yaml_6.0.2-2_amd64.deb ... Unpacking python3-yaml (6.0.2-2) ... Setting up media-types (14.0.0) ... Setting up libpipeline1:amd64 (1.5.8-1) ... Setting up libtext-charwidth-perl:amd64 (0.04-11+b4) ... Setting up libkeyutils1:amd64 (1.6.3-6) ... Setting up bsdextrautils (2.41.2-4) ... Setting up libgpg-error0:amd64 (1.56-2) ... Setting up libio-pty-perl (1:1.20-1+b3) ... Setting up libmagic-mgc (1:5.46-5) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libyaml-0-2:amd64 (0.2.5-2) ... Setting up libxml2-16:amd64 (2.14.6+dfsg-0.1) ... Setting up libdebhelper-perl (13.28) ... Setting up libmagic1t64:amd64 (1:5.46-5) ... Setting up gettext-base (0.23.1-2+b1) ... Setting up m4 (1.4.20-2) ... Setting up libgcrypt20:amd64 (1.11.2-2) ... Setting up libcom-err2:amd64 (1.47.2-3+b3) ... Setting up file (1:5.46-5) ... Setting up libtext-wrapi18n-perl (0.06-10) ... Setting up libelf1t64:amd64 (0.193-3) ... Setting up libkrb5support0:amd64 (1.21.3-5) ... Setting up libsasl2-modules-db:amd64 (2.1.28+dfsg1-10) ... Setting up tzdata (2025b-5) ... Current default time zone: 'Etc/UTC' Local time is now: Fri Oct 31 17:52:37 UTC 2025. Universal Time is now: Fri Oct 31 17:52:37 UTC 2025. Run 'dpkg-reconfigure tzdata' if you wish to change it. Setting up autotools-dev (20240727.1) ... Setting up libproc2-0:amd64 (2:4.0.4-9) ... Setting up libunistring5:amd64 (1.3-2) ... Setting up autopoint (0.23.1-2) ... Setting up libipc-run-perl (20231003.0-2) ... Setting up libk5crypto3:amd64 (1.21.3-5) ... Setting up libsasl2-2:amd64 (2.1.28+dfsg1-10) ... Setting up autoconf (2.72-3.1) ... Setting up libffi8:amd64 (3.5.2-2) ... Setting up libnuma1:amd64 (2.0.19-1) ... Setting up dwz (0.16-2) ... Setting up sensible-utils (0.0.26) ... Setting up libuchardet0:amd64 (0.0.8-2) ... Setting up procps (2:4.0.4-9) ... Setting up libjson-perl (4.10000-1) ... Setting up libxslt1.1:amd64 (1.1.43-0.3) ... Setting up netbase (6.5) ... Setting up libkrb5-3:amd64 (1.21.3-5) ... Setting up libicu76:amd64 (76.1-4) ... Setting up liburing2:amd64 (2.12-1) ... Setting up openssl (3.5.4-1) ... Setting up readline-common (8.3-3) ... Setting up libpg-query1706.0:amd64 (17-6.1.0-1) ... Setting up libldap2:amd64 (2.6.10+dfsg-1) ... Setting up liblocale-gettext-perl (1.07-7+b1) ... Setting up postgresql-common-dev (286) ... Setting up automake (1:1.18.1-2) ... update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode Setting up postgresql-client-common (286) ... Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... Setting up gettext (0.23.1-2+b1) ... Setting up libtool (2.5.4-7) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up help2man (1.49.3) ... Setting up dh-autoreconf (21) ... Setting up ssl-cert (1.1.3) ... Setting up libgssapi-krb5-2:amd64 (1.21.3-5) ... Setting up ucf (3.0052) ... Setting up libreadline8t64:amd64 (8.3-3) ... Setting up dh-strip-nondeterminism (1.15.0-1) ... Setting up groff-base (1.23.0-9) ... Setting up libpython3.13-stdlib:amd64 (3.13.9-1) ... Setting up libpython3-stdlib:amd64 (3.13.7-1) ... Setting up python3.13 (3.13.9-1) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up libpq5:amd64 (18.0-1) ... Setting up python3 (3.13.7-1) ... Setting up python3-zipp (3.23.0-1) ... Setting up python3-autocommand (2.2.2-3) ... Setting up man-db (2.13.1-1) ... Not building database; man-db/auto-update is not 'true'. Setting up python3-pygments (2.18.0+dfsg-2) ... Setting up python3-packaging (25.0-1) ... Setting up postgresql-common (286) ... Creating config file /etc/postgresql-common/createcluster.conf with new version Building PostgreSQL dictionaries from installed myspell/hunspell packages... Removing obsolete dictionary files: invoke-rc.d: could not determine current runlevel invoke-rc.d: policy-rc.d denied execution of start. Setting up python3-psycopg2 (2.9.10-1+b1) ... Setting up python3-typing-extensions (4.15.0-1) ... Setting up python3-pluggy (1.6.0-1) ... Setting up dh-python (6.20250414) ... Setting up python3-more-itertools (10.8.0-1) ... Setting up python3-iniconfig (2.1.0-1) ... Setting up python3-jaraco.functools (4.1.0-1) ... Setting up python3-jaraco.context (6.0.1-1) ... Setting up postgresql-client-18 (18.0-1) ... update-alternatives: using /usr/share/postgresql/18/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode Setting up python3-pytest (8.4.2-1) ... Setting up python3-typeguard (4.4.4-1) ... Setting up postgresql-18 (18.0-1) ... Creating new PostgreSQL cluster 18/main ... /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "C.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. fixing permissions on existing directory /var/lib/postgresql/18/main ... ok creating subdirectories ... ok 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 creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok invoke-rc.d: could not determine current runlevel invoke-rc.d: policy-rc.d denied execution of start. Setting up python3-all (3.13.7-1) ... Setting up python3-yaml (6.0.2-2) ... Setting up debhelper (13.28) ... Setting up python3-inflect (7.5.0-1) ... Setting up python3-jaraco.text (4.0.0-1) ... Setting up postgresql (18+286) ... Setting up python3-pkg-resources (78.1.1-0.1) ... Setting up python3-setuptools (78.1.1-0.1) ... Setting up python3-pglast (7.10-1) ... Processing triggers for libc-bin (2.41-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/reproducible-path/sqlreduce-1.3/ && 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 > ../sqlreduce_1.3-1_source.changes dpkg-buildpackage: info: source package sqlreduce dpkg-buildpackage: info: source version 1.3-1 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Christoph Berg dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 dpkg-source: info: using options from sqlreduce-1.3/debian/source/options: --extend-diff-ignore=docs/sqlreduce.1 debian/rules clean dh clean --with python3 --buildsystem=pybuild dh_auto_clean -O--buildsystem=pybuild I: pybuild base:311: python3.13 setup.py clean /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running clean removing '/build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build' (and everything under it) 'build/bdist.linux-x86_64' does not exist -- can't clean it 'build/scripts-3.13' does not exist -- can't clean it dh_autoreconf_clean -O--buildsystem=pybuild dh_clean -O--buildsystem=pybuild debian/rules binary dh binary --with python3 --buildsystem=pybuild dh_update_autotools_config -O--buildsystem=pybuild dh_autoreconf -O--buildsystem=pybuild dh_auto_configure -O--buildsystem=pybuild I: pybuild base:311: python3.13 setup.py config /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running config dh_auto_build -O--buildsystem=pybuild I: pybuild base:311: /usr/bin/python3 setup.py build /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** !! self._finalize_license_expression() running build running build_py creating /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce copying sqlreduce/__init__.py -> /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce copying sqlreduce/main.py -> /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build/sqlreduce debian/rules override_dh_auto_test make[1]: Entering directory '/build/reproducible-path/sqlreduce-1.3' pg_virtualenv dh_auto_test Creating new PostgreSQL cluster 18/regress ... I: pybuild base:311: cd /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build; python3.13 -m pytest tests ============================= test session starts ============================== platform linux -- Python 3.13.9, pytest-8.4.2, pluggy-1.6.0 rootdir: /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build configfile: pyproject.toml plugins: typeguard-4.4.4 collected 3 items tests/test_sqlreduce.py ..F [100%] =================================== FAILURES =================================== __________________________________ test_rules __________________________________ def test_rules(): for classname, rule in rules.items(): print(f"{classname}:") tests = rule['tests'] if tests is None: raise Exception(f"{classname} is missing tests") for test, expected in zip(tests[0::2], tests[1::2]): print(" test:", test) res, _ = run_reduce(test) print(" got:", res) if res != expected: print("expect:", expected) > raise Exception(f"{classname} test: {test}: expected {expected}, got {res}") E Exception: TransactionStmt test: begin: expected BEGIN , got BEGIN tests/test_sqlreduce.py:59: Exception ----------------------------- Captured stdout call ----------------------------- A_ArrayExpr: test: select array[2, foo] got: SELECT foo A_Const: test: select '1,1'::point = '1,1' got: SELECT CAST(NULL AS point) = NULL A_Expr: test: select 1 + moo got: SELECT moo test: select foo between 2 and 3 got: SELECT foo test: select 1 between moo and 3 got: SELECT moo test: select 1 between 2 and bar got: SELECT bar A_Indirection: test: select foo[2] got: SELECT foo test: select (select array[1])[foo] got: SELECT (SELECT ARRAY[NULL])[foo] AlterPolicyStmt: test: alter policy moo on bar using (true) got: ALTER POLICY moo ON bar USING (NULL) BoolExpr: test: select moo and foo got: SELECT moo test: select true and (foo or false) got: SELECT foo test: select set_config('a.b', 'blub', true) = 'blub' and set_config('work_mem', current_setting('a.b'), true) = '' and true got: SELECT set_config('a.b', 'blub', NULL) = 'blub' AND set_config('work_mem', current_setting('a.b'), NULL) = '' BooleanTest: test: select foo is true got: SELECT foo CallStmt: test: call foo() got: CALL foo() test: call foo(bar + 1) got: CALL foo(bar) CaseExpr: test: select case foo when 1 then 2 else bar end got: SELECT foo test: select case when moo then 1 else bar end got: SELECT moo test: select case when true then foo end got: SELECT foo test: select case when true then 1 else bar end got: SELECT bar CaseWhen: test: select case when bar then 1 else 2 end got: SELECT bar ClusterStmt: test: cluster foo got: CLUSTER foo CoalesceExpr: test: select coalesce(1, bar) got: SELECT bar test: select coalesce(1, '', 2) got: SELECT COALESCE('', 2) ColumnRef: test: select 'foo' got: SELECT CommonTableExpr: test: with a as (select moo) select from a got: SELECT moo test: with recursive a(a) as (select 5 union select 1 from a) cycle a set is_cycle using path, b(b) as (select null) select a = b from a, b got: WITH a(a) AS (SELECT NULL UNION SELECT 1), b(b) AS (SELECT NULL) SELECT a = b FROM a, b CopyStmt: test: copy (select foo) to 'bla' got: SELECT foo test: create table foo (id int); copy foo from stdin got: CREATE TABLE foo (id integer); COPY foo FROM STDIN CreatePolicyStmt: test: create policy foo ON bar for select using (moo % 2 = 0) got: CREATE POLICY foo ON bar AS PERMISSIVE FOR select TO PUBLIC USING (NULL) CreateSchemaStmt: test: create schema foo create table bar1 partition of moo for values in (1) create table bar2 partition of moo for values in (2) got: CREATE SCHEMA foo CREATE TABLE bar2 PARTITION OF moo FOR VALUES IN (2) CreateStmt: test: create table foo (a int) got: CREATE TABLE foo (a integer) test: create table foo (id int) partition by list(id) got: CREATE TABLE foo (id integer) CreateTableAsStmt: test: create table foo as select 1, moo got: SELECT moo test: create table foo as select 1, 2 got: CREATE TABLE foo AS SELECT NULL, NULL DeclareCursorStmt: test: declare foo cursor for select bar got: SELECT bar DeleteStmt: test: delete from foo where bar got: DELETE FROM foo test: delete from foo using bar got: DELETE FROM foo test: delete from foo returning bar got: DELETE FROM foo test: delete from pg_database where bar and foo got: DELETE FROM pg_database WHERE bar ExecuteStmt: test: prepare foo as select $1; execute foo(bar + 1) got: PREPARE foo AS SELECT $1; EXECUTE foo(bar) ExplainStmt: test: explain select from foo, bar got: EXPLAIN SELECT FROM foo test: explain (analyze) select from foo got: EXPLAIN SELECT FROM foo FuncCall: test: select foo(bar) got: SELECT bar test: select foo() over () got: SELECT foo() test: select lag(1) over (partition by bar, foo) got: SELECT lag(1) OVER (PARTITION BY bar) test: select foo(1 order by moo) got: SELECT foo(1) test: select count(1 order by moo, bar) got: SELECT moo test: select foo(1 + 1) got: SELECT foo(1) InsertStmt: test: insert into bar select from bar got: SELECT FROM bar test: create table bar(id int); insert into bar values(foo) got: VALUES (foo) test: insert into foo (id) select bar got: INSERT INTO foo SELECT test: insert into foo values (1) on conflict do nothing got: INSERT INTO foo SELECT test: with foo as (select 1) insert into bar select * from foo got: INSERT INTO bar SELECT test: insert into foo select returning bar, moo got: INSERT INTO foo SELECT test: create table foo (bar int); insert into foo select returning bar, moo got: CREATE TABLE foo (bar integer); INSERT INTO foo SELECT RETURNING moo JoinExpr: test: select from foo join bar on true got: SELECT FROM foo test: select from pg_database join pg_database on moo got: SELECT FROM pg_database INNER JOIN pg_database ON NULL test: select from pg_database a join pg_database b on foo got: SELECT foo NamedArgExpr: test: select foo(bar => moo) got: SELECT moo Null: test: select null got: SELECT NullTest: test: select moo is null got: SELECT moo OnConflictClause: test: create table foo(id int primary key); insert into foo values (1) on conflict (id) do update set a=1 where true got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (id) DO UPDATE SET a = NULL test: create table foo(id int primary key); insert into foo values (1) on conflict (id) do update set id=1, b=1 got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (id) DO UPDATE SET b = NULL test: create table foo(id int primary key); insert into foo (id) values (1) on conflict (a) do update set id=1 got: CREATE TABLE foo (id integer PRIMARY KEY); INSERT INTO foo SELECT ON CONFLICT (a) DO NOTHING PrepareStmt: test: prepare foo as select from bar, moo got: SELECT FROM bar RangeFunction: test: select from lateral foo() got: SELECT FROM foo() test: select from foo(1 + 1) got: SELECT FROM foo(1) test: select from rows from (f(1), f(2)) got: SELECT FROM ROWS FROM (f(1), f()) RangeSubselect: test: select from (select bar) sub got: SELECT bar RangeTableFunc: test: select from xmltable('/foo' passing bla columns foo integer, moo text) got: SELECT FROM xmltable(('/foo') PASSING bla COLUMNS moo text) RangeTableFuncCol: test: select from xmltable('/foo' passing bla columns foo integer, moo text) got: SELECT FROM xmltable(('/foo') PASSING bla COLUMNS moo text) RangeTableSample: test: select from bar tablesample system(1) got: SELECT FROM bar RangeVar: test: select from moo got: SELECT FROM moo RawStmt: test: select got: SELECT ResTarget: test: select foo as bar got: SELECT foo AS bar test: update foo set bar[2] = 1 got: UPDATE foo SET bar = NULL RowExpr: test: select row(1, foo) got: SELECT foo test: select row(1, 2) = row(3, '') got: SELECT ROW(NULL, 2) = ROW(NULL, '') SelectStmt: test: select limit 1 got: SELECT test: select offset 1 got: SELECT test: select 1 got: SELECT test: select foo, bar got: SELECT foo test: select where true got: SELECT test: select 1 from pg_database where foo got: SELECT WHERE foo test: select from foo union select from bar got: SELECT FROM foo test: select from foo, bar got: SELECT FROM foo test: select order by foo, bar got: SELECT ORDER BY foo test: select group by foo, bar got: SELECT GROUP BY foo test: values (1) got: SELECT test: values(1), (moo), (foo) got: VALUES (moo) test: select from (values (moo)) sub got: VALUES (moo) test: with moo as (select) select from foo got: SELECT FROM foo test: select distinct foo got: SELECT foo test: select distinct on (a, b) NULL got: SELECT DISTINCT ON (a) NULL SetToDefault: test: update foo set a = default got: UPDATE foo SET a = NULL SortBy: test: select foo(1 order by moo desc) got: SELECT foo(1) test: select avg(1 order by foo) got: SELECT foo SubLink: test: select (select moo) got: SELECT moo test: select exists(select moo) got: SELECT moo TruncateStmt: test: truncate foo, bar got: TRUNCATE TABLE foo TypeCast: test: select foo::int got: SELECT foo UpdateStmt: test: update foo set a=b, c=d got: UPDATE foo SET c = NULL test: update foo set a=b where true got: UPDATE foo SET a = NULL ViewStmt: test: create view foo as select bar got: SELECT bar test: create view foo (n) as select 1, 2; select n = '' from foo got: CREATE VIEW foo (n) AS SELECT 2; SELECT n = '' FROM foo WindowDef: test: select count(*) over (partition by bar, foo) got: SELECT count(*) OVER (PARTITION BY bar) test: select count(*) over (order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) test: select count(*) over (partition by bar order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) WithClause: test: with recursive a(a) as (select 5), whatever as (select), b(b) as (select '') select a = b from a, b got: WITH a(a) AS (SELECT 5), b(b) AS (SELECT NULL) SELECT a = b FROM a, b XmlExpr: test: select xmlelement(name bar, moo) got: SELECT moo test: select xmlforest(foo, bar) got: SELECT foo XmlSerialize: test: SELECT xmlserialize(content moo as text) got: SELECT moo AlterDatabaseSetStmt: test: alter database foo reset all got: ALTER DATABASE foo RESET ALL AlterDefaultPrivilegesStmt: test: alter default privileges for role foo revoke delete on tables from bar got: ALTER DEFAULT PRIVILEGES FOR ROLE foo REVOKE DELETE ON TABLES FROM bar AlterDomainStmt: test: alter domain moo add check (value <> '') got: ALTER DOMAIN moo ADD CHECK (value <> '') AlterEventTrigStmt: test: alter event trigger foo disable got: ALTER EVENT TRIGGER foo DISABLE AlterFunctionStmt: test: alter function foo() strict got: ALTER FUNCTION foo () RETURNS NULL ON NULL INPUT AlterObjectSchemaStmt: test: alter table foo set schema bla got: ALTER TABLE foo SET SCHEMA bla AlterOwnerStmt: test: alter large object 42 owner to moo got: ALTER LARGE OBJECT 42 OWNER TO moo AlterRoleSetStmt: test: alter role foo reset all got: ALTER ROLE foo RESET ALL test: alter role foo in database bar reset all got: ALTER ROLE foo IN DATABASE bar RESET ALL AlterRoleStmt: test: alter role foo superuser got: ALTER ROLE foo SUPERUSER AlterSeqStmt: test: alter sequence foo restart 1 got: ALTER SEQUENCE foo RESTART WITH 1 AlterTableStmt: test: alter table foo drop column bar got: ALTER TABLE foo DROP COLUMN bar CommentStmt: test: comment on table foo is 'bar' got: COMMENT ON TABLE foo IS 'bar' CompositeTypeStmt: test: create type foo as (a text, b integer, c timestamp) got: CREATE TYPE foo AS (a text, b integer, c timestamp) CreateCastStmt: test: create cast (foo as bar) without function got: CREATE CAST (foo AS bar) WITHOUT FUNCTION CreateConversionStmt: test: create conversion foo for 'LATIN1' to 'UTF8' from iso8859_1_to_utf8 got: CREATE CONVERSION foo FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8 CreatedbStmt: test: create database foo got: CREATE DATABASE foo CreateDomainStmt: test: create domain foo as int not null got: CREATE DOMAIN foo AS integer NOT NULL CreateEnumStmt: test: create type foo as enum ('foo', 'bar') got: CREATE TYPE foo AS ENUM ('foo', 'bar') CreateEventTrigStmt: test: create event trigger foo on ddl_command_start execute function moo() got: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() CreateFdwStmt: test: create foreign data wrapper foo got: CREATE FOREIGN DATA WRAPPER foo CreateForeignServerStmt: test: create server bar foreign data wrapper foo got: CREATE SERVER bar FOREIGN DATA WRAPPER foo CreateForeignTableStmt: test: create foreign table foo (moo int not null) server bar got: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar CreateFunctionStmt: test: create function moo() returns void as $$ select 1 $$ language sql got: CREATE FUNCTION moo() RETURNS void AS $$ select 1 $$ LANGUAGE sql CreateRangeStmt: test: create type foo as range (subtype = bar) got: CREATE TYPE foo AS RANGE (subtype = bar) CreateOpClassStmt: test: create operator class foo for type bar using moo as storage bla got: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla CreatePublicationStmt: test: create publication foo got: CREATE PUBLICATION foo CreateRoleStmt: test: create role foo got: CREATE ROLE foo CreateSeqStmt: test: create sequence foo got: CREATE SEQUENCE foo CreateSubscriptionStmt: test: create subscription moo connection '' publication foo got: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo CreateTrigStmt: test: create trigger foo before insert on bar execute procedure moo() got: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() CreateUserMappingStmt: test: create user mapping for moo server bar got: CREATE USER MAPPING FOR moo SERVER bar DeallocateStmt: test: deallocate bar got: DEALLOCATE PREPARE bar DefineStmt: test: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') got: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') DiscardStmt: test: discard all got: DISCARD ALL DoStmt: test: do $$ begin end $$ got: DO $$ begin end $$ DropdbStmt: test: drop database foo got: DROP DATABASE foo DropOwnedStmt: test: drop owned by bar got: DROP OWNED BY bar RESTRICT DropRoleStmt: test: drop role moo got: DROP ROLE moo DropStmt: test: drop table foo got: DROP TABLE foo FetchStmt: test: fetch all in foo got: FETCH FORWARD ALL FROM foo GrantStmt: test: grant select on foo to bar got: GRANT SELECT ON TABLE foo TO bar IndexStmt: test: create index on foo(bar) got: CREATE INDEX ON foo (bar) LockStmt: test: lock foo got: LOCK foo IN ACCESS EXCLUSIVE MODE ParamRef: test: select $1 got: SELECT $1 RenameStmt: test: alter table foo rename to bar got: ALTER TABLE foo RENAME TO bar RuleStmt: test: create rule foo as on insert to moo do instead nothing got: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING TransactionStmt: test: begin got: BEGIN expect: BEGIN =========================== short test summary info ============================ FAILED tests/test_sqlreduce.py::test_rules - Exception: TransactionStmt test:... ========================= 1 failed, 2 passed in 22.49s ========================= E: pybuild pybuild:389: test: plugin distutils failed with: exit code=1: cd /build/reproducible-path/sqlreduce-1.3/.pybuild/cpython3_3.13_sqlreduce/build; python3.13 -m pytest tests dh_auto_test: error: pybuild --test --test-pytest -i python{version} -p 3.13 returned exit code 13 *** /tmp/pg_virtualenv.xQCOGd/log/postgresql-18-regress.log (last 100 lines) *** 2025-10-31 05:53:37.686 /USR/SHARE/ZONEINFO/ETC/GMT [2130604] pbuilder1@postgres ERROR: type "foo" does not exist 2025-10-31 05:53:37.686 /USR/SHARE/ZONEINFO/ETC/GMT [2130604] pbuilder1@postgres STATEMENT: CREATE CAST (foo AS bar) WITHOUT FUNCTION 2025-10-31 05:53:37.720 /USR/SHARE/ZONEINFO/ETC/GMT [2130607] pbuilder1@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-10-31 05:53:37.720 /USR/SHARE/ZONEINFO/ETC/GMT [2130607] pbuilder1@postgres STATEMENT: create database foo 2025-10-31 05:53:37.730 /USR/SHARE/ZONEINFO/ETC/GMT [2130608] pbuilder1@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-10-31 05:53:37.730 /USR/SHARE/ZONEINFO/ETC/GMT [2130608] pbuilder1@postgres STATEMENT: CREATE DATABASE foo 2025-10-31 05:53:37.787 /USR/SHARE/ZONEINFO/ETC/GMT [2130613] pbuilder1@postgres ERROR: function moo() does not exist 2025-10-31 05:53:37.787 /USR/SHARE/ZONEINFO/ETC/GMT [2130613] pbuilder1@postgres STATEMENT: create event trigger foo on ddl_command_start execute function moo() 2025-10-31 05:53:37.798 /USR/SHARE/ZONEINFO/ETC/GMT [2130614] pbuilder1@postgres ERROR: function moo() does not exist 2025-10-31 05:53:37.798 /USR/SHARE/ZONEINFO/ETC/GMT [2130614] pbuilder1@postgres STATEMENT: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() 2025-10-31 05:53:37.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130617] pbuilder1@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-10-31 05:53:37.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130617] pbuilder1@postgres STATEMENT: create server bar foreign data wrapper foo 2025-10-31 05:53:37.841 /USR/SHARE/ZONEINFO/ETC/GMT [2130619] pbuilder1@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-10-31 05:53:37.841 /USR/SHARE/ZONEINFO/ETC/GMT [2130619] pbuilder1@postgres STATEMENT: CREATE SERVER bar FOREIGN DATA WRAPPER foo 2025-10-31 05:53:37.854 /USR/SHARE/ZONEINFO/ETC/GMT [2130621] pbuilder1@postgres ERROR: server "bar" does not exist 2025-10-31 05:53:37.854 /USR/SHARE/ZONEINFO/ETC/GMT [2130621] pbuilder1@postgres STATEMENT: create foreign table foo (moo int not null) server bar 2025-10-31 05:53:37.866 /USR/SHARE/ZONEINFO/ETC/GMT [2130622] pbuilder1@postgres ERROR: server "bar" does not exist 2025-10-31 05:53:37.866 /USR/SHARE/ZONEINFO/ETC/GMT [2130622] pbuilder1@postgres STATEMENT: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar 2025-10-31 05:53:37.900 /USR/SHARE/ZONEINFO/ETC/GMT [2130625] pbuilder1@postgres ERROR: type "bar" does not exist 2025-10-31 05:53:37.900 /USR/SHARE/ZONEINFO/ETC/GMT [2130625] pbuilder1@postgres STATEMENT: create type foo as range (subtype = bar) 2025-10-31 05:53:37.911 /USR/SHARE/ZONEINFO/ETC/GMT [2130626] pbuilder1@postgres ERROR: type "bar" does not exist 2025-10-31 05:53:37.911 /USR/SHARE/ZONEINFO/ETC/GMT [2130626] pbuilder1@postgres STATEMENT: CREATE TYPE foo AS RANGE (subtype = bar) 2025-10-31 05:53:37.922 /USR/SHARE/ZONEINFO/ETC/GMT [2130627] pbuilder1@postgres ERROR: access method "moo" does not exist 2025-10-31 05:53:37.922 /USR/SHARE/ZONEINFO/ETC/GMT [2130627] pbuilder1@postgres STATEMENT: create operator class foo for type bar using moo as storage bla 2025-10-31 05:53:37.933 /USR/SHARE/ZONEINFO/ETC/GMT [2130628] pbuilder1@postgres ERROR: access method "moo" does not exist 2025-10-31 05:53:37.933 /USR/SHARE/ZONEINFO/ETC/GMT [2130628] pbuilder1@postgres STATEMENT: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla 2025-10-31 05:53:37.945 /USR/SHARE/ZONEINFO/ETC/GMT [2130629] pbuilder1@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-10-31 05:53:37.945 /USR/SHARE/ZONEINFO/ETC/GMT [2130629] pbuilder1@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-10-31 05:53:37.955 /USR/SHARE/ZONEINFO/ETC/GMT [2130630] pbuilder1@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-10-31 05:53:37.955 /USR/SHARE/ZONEINFO/ETC/GMT [2130630] pbuilder1@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-10-31 05:53:38.232 /USR/SHARE/ZONEINFO/ETC/GMT [2130671] pbuilder1@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-10-31 05:53:38.232 /USR/SHARE/ZONEINFO/ETC/GMT [2130671] pbuilder1@postgres STATEMENT: create subscription moo connection '' publication foo 2025-10-31 05:53:38.390 /USR/SHARE/ZONEINFO/ETC/GMT [2130703] pbuilder1@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-10-31 05:53:38.390 /USR/SHARE/ZONEINFO/ETC/GMT [2130703] pbuilder1@postgres STATEMENT: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo 2025-10-31 05:53:38.430 /USR/SHARE/ZONEINFO/ETC/GMT [2130725] pbuilder1@postgres ERROR: relation "bar" does not exist 2025-10-31 05:53:38.430 /USR/SHARE/ZONEINFO/ETC/GMT [2130725] pbuilder1@postgres STATEMENT: create trigger foo before insert on bar execute procedure moo() 2025-10-31 05:53:38.441 /USR/SHARE/ZONEINFO/ETC/GMT [2130733] pbuilder1@postgres ERROR: relation "bar" does not exist 2025-10-31 05:53:38.441 /USR/SHARE/ZONEINFO/ETC/GMT [2130733] pbuilder1@postgres STATEMENT: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() 2025-10-31 05:53:38.452 /USR/SHARE/ZONEINFO/ETC/GMT [2130737] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.452 /USR/SHARE/ZONEINFO/ETC/GMT [2130737] pbuilder1@postgres STATEMENT: create user mapping for moo server bar 2025-10-31 05:53:38.463 /USR/SHARE/ZONEINFO/ETC/GMT [2130738] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.463 /USR/SHARE/ZONEINFO/ETC/GMT [2130738] pbuilder1@postgres STATEMENT: CREATE USER MAPPING FOR moo SERVER bar 2025-10-31 05:53:38.474 /USR/SHARE/ZONEINFO/ETC/GMT [2130739] pbuilder1@postgres ERROR: prepared statement "bar" does not exist 2025-10-31 05:53:38.474 /USR/SHARE/ZONEINFO/ETC/GMT [2130739] pbuilder1@postgres STATEMENT: deallocate bar 2025-10-31 05:53:38.484 /USR/SHARE/ZONEINFO/ETC/GMT [2130740] pbuilder1@postgres ERROR: prepared statement "bar" does not exist 2025-10-31 05:53:38.484 /USR/SHARE/ZONEINFO/ETC/GMT [2130740] pbuilder1@postgres STATEMENT: DEALLOCATE PREPARE bar 2025-10-31 05:53:38.496 /USR/SHARE/ZONEINFO/ETC/GMT [2130744] pbuilder1@postgres ERROR: function foo(integer[]) does not exist 2025-10-31 05:53:38.496 /USR/SHARE/ZONEINFO/ETC/GMT [2130744] pbuilder1@postgres STATEMENT: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-10-31 05:53:38.508 /USR/SHARE/ZONEINFO/ETC/GMT [2130746] pbuilder1@postgres ERROR: function foo(integer[]) does not exist 2025-10-31 05:53:38.508 /USR/SHARE/ZONEINFO/ETC/GMT [2130746] pbuilder1@postgres STATEMENT: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-10-31 05:53:38.520 /USR/SHARE/ZONEINFO/ETC/GMT [2130748] pbuilder1@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-10-31 05:53:38.520 /USR/SHARE/ZONEINFO/ETC/GMT [2130748] pbuilder1@postgres STATEMENT: discard all 2025-10-31 05:53:38.602 /USR/SHARE/ZONEINFO/ETC/GMT [2130753] pbuilder1@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-10-31 05:53:38.602 /USR/SHARE/ZONEINFO/ETC/GMT [2130753] pbuilder1@postgres STATEMENT: DISCARD ALL 2025-10-31 05:53:38.732 /USR/SHARE/ZONEINFO/ETC/GMT [2130766] pbuilder1@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-10-31 05:53:38.732 /USR/SHARE/ZONEINFO/ETC/GMT [2130766] pbuilder1@postgres STATEMENT: drop database foo 2025-10-31 05:53:38.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130768] pbuilder1@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-10-31 05:53:38.830 /USR/SHARE/ZONEINFO/ETC/GMT [2130768] pbuilder1@postgres STATEMENT: DROP DATABASE foo 2025-10-31 05:53:38.946 /USR/SHARE/ZONEINFO/ETC/GMT [2130770] pbuilder1@postgres ERROR: role "bar" does not exist 2025-10-31 05:53:38.946 /USR/SHARE/ZONEINFO/ETC/GMT [2130770] pbuilder1@postgres STATEMENT: drop owned by bar 2025-10-31 05:53:38.963 /USR/SHARE/ZONEINFO/ETC/GMT [2130777] pbuilder1@postgres ERROR: role "bar" does not exist 2025-10-31 05:53:38.963 /USR/SHARE/ZONEINFO/ETC/GMT [2130777] pbuilder1@postgres STATEMENT: DROP OWNED BY bar RESTRICT 2025-10-31 05:53:38.981 /USR/SHARE/ZONEINFO/ETC/GMT [2130778] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.981 /USR/SHARE/ZONEINFO/ETC/GMT [2130778] pbuilder1@postgres STATEMENT: drop role moo 2025-10-31 05:53:38.997 /USR/SHARE/ZONEINFO/ETC/GMT [2130779] pbuilder1@postgres ERROR: role "moo" does not exist 2025-10-31 05:53:38.997 /USR/SHARE/ZONEINFO/ETC/GMT [2130779] pbuilder1@postgres STATEMENT: DROP ROLE moo 2025-10-31 05:53:39.008 /USR/SHARE/ZONEINFO/ETC/GMT [2130780] pbuilder1@postgres ERROR: table "foo" does not exist 2025-10-31 05:53:39.008 /USR/SHARE/ZONEINFO/ETC/GMT [2130780] pbuilder1@postgres STATEMENT: drop table foo 2025-10-31 05:53:39.019 /USR/SHARE/ZONEINFO/ETC/GMT [2130781] pbuilder1@postgres ERROR: table "foo" does not exist 2025-10-31 05:53:39.019 /USR/SHARE/ZONEINFO/ETC/GMT [2130781] pbuilder1@postgres STATEMENT: DROP TABLE foo 2025-10-31 05:53:39.030 /USR/SHARE/ZONEINFO/ETC/GMT [2130782] pbuilder1@postgres ERROR: cursor "foo" does not exist 2025-10-31 05:53:39.030 /USR/SHARE/ZONEINFO/ETC/GMT [2130782] pbuilder1@postgres STATEMENT: fetch all in foo 2025-10-31 05:53:39.041 /USR/SHARE/ZONEINFO/ETC/GMT [2130783] pbuilder1@postgres ERROR: cursor "foo" does not exist 2025-10-31 05:53:39.041 /USR/SHARE/ZONEINFO/ETC/GMT [2130783] pbuilder1@postgres STATEMENT: FETCH FORWARD ALL FROM foo 2025-10-31 05:53:39.052 /USR/SHARE/ZONEINFO/ETC/GMT [2130785] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.052 /USR/SHARE/ZONEINFO/ETC/GMT [2130785] pbuilder1@postgres STATEMENT: grant select on foo to bar 2025-10-31 05:53:39.063 /USR/SHARE/ZONEINFO/ETC/GMT [2130786] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.063 /USR/SHARE/ZONEINFO/ETC/GMT [2130786] pbuilder1@postgres STATEMENT: GRANT SELECT ON TABLE foo TO bar 2025-10-31 05:53:39.350 /USR/SHARE/ZONEINFO/ETC/GMT [2130794] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.350 /USR/SHARE/ZONEINFO/ETC/GMT [2130794] pbuilder1@postgres STATEMENT: create index on foo(bar) 2025-10-31 05:53:39.361 /USR/SHARE/ZONEINFO/ETC/GMT [2130807] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.361 /USR/SHARE/ZONEINFO/ETC/GMT [2130807] pbuilder1@postgres STATEMENT: CREATE INDEX ON foo (bar) 2025-10-31 05:53:39.372 /USR/SHARE/ZONEINFO/ETC/GMT [2130809] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.372 /USR/SHARE/ZONEINFO/ETC/GMT [2130809] pbuilder1@postgres STATEMENT: lock foo 2025-10-31 05:53:39.382 /USR/SHARE/ZONEINFO/ETC/GMT [2130810] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.382 /USR/SHARE/ZONEINFO/ETC/GMT [2130810] pbuilder1@postgres STATEMENT: LOCK foo IN ACCESS EXCLUSIVE MODE 2025-10-31 05:53:39.393 /USR/SHARE/ZONEINFO/ETC/GMT [2130811] pbuilder1@postgres ERROR: there is no parameter $1 at character 8 2025-10-31 05:53:39.393 /USR/SHARE/ZONEINFO/ETC/GMT [2130811] pbuilder1@postgres STATEMENT: select $1 2025-10-31 05:53:39.404 /USR/SHARE/ZONEINFO/ETC/GMT [2130812] pbuilder1@postgres ERROR: there is no parameter $1 at character 8 2025-10-31 05:53:39.404 /USR/SHARE/ZONEINFO/ETC/GMT [2130812] pbuilder1@postgres STATEMENT: SELECT $1 2025-10-31 05:53:39.426 /USR/SHARE/ZONEINFO/ETC/GMT [2130814] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.426 /USR/SHARE/ZONEINFO/ETC/GMT [2130814] pbuilder1@postgres STATEMENT: alter table foo rename to bar 2025-10-31 05:53:39.436 /USR/SHARE/ZONEINFO/ETC/GMT [2130815] pbuilder1@postgres ERROR: relation "foo" does not exist 2025-10-31 05:53:39.436 /USR/SHARE/ZONEINFO/ETC/GMT [2130815] pbuilder1@postgres STATEMENT: ALTER TABLE foo RENAME TO bar 2025-10-31 05:53:39.447 /USR/SHARE/ZONEINFO/ETC/GMT [2130816] pbuilder1@postgres ERROR: relation "moo" does not exist 2025-10-31 05:53:39.447 /USR/SHARE/ZONEINFO/ETC/GMT [2130816] pbuilder1@postgres STATEMENT: create rule foo as on insert to moo do instead nothing 2025-10-31 05:53:39.458 /USR/SHARE/ZONEINFO/ETC/GMT [2130817] pbuilder1@postgres ERROR: relation "moo" does not exist 2025-10-31 05:53:39.458 /USR/SHARE/ZONEINFO/ETC/GMT [2130817] pbuilder1@postgres STATEMENT: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING 2025-10-31 05:53:39.469 /USR/SHARE/ZONEINFO/ETC/GMT [2130818] pbuilder1@postgres WARNING: there is already a transaction in progress 2025-10-31 05:53:39.479 /USR/SHARE/ZONEINFO/ETC/GMT [2130819] pbuilder1@postgres WARNING: there is already a transaction in progress Dropping cluster 18/regress ... make[1]: *** [debian/rules:8: override_dh_auto_test] Error 25 make[1]: Leaving directory '/build/reproducible-path/sqlreduce-1.3' make: *** [debian/rules:21: binary] Error 2 dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2 I: copying local configuration E: Failed autobuilding of package 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/2117968 and its subdirectories sqlreduce failed to build from source. removed '/var/lib/jenkins/userContent/reproducible/debian/rbuild/forky/amd64/sqlreduce_1.3-1.rbuild.log' removed '/var/lib/jenkins/userContent/reproducible/debian/rbuild/forky/amd64/sqlreduce_1.3-1.rbuild.log.gz' removed '/var/lib/jenkins/userContent/reproducible/debian/logs/forky/amd64/sqlreduce_1.3-1.build1.log.gz' Fri Oct 31 17:53:48 UTC 2025 W: No second build log, what happened? Compressing the 1st log... b1/build.log: 80.1% -- replaced with stdout INSERT 0 1 INSERT 0 1 DELETE 1 [2025-10-31 17:53:48] INFO: Starting at 2025-10-31 17:53:48.569910 [2025-10-31 17:53:48] INFO: Generating the pages of 1 package(s) [2025-10-31 17:53:48] CRITICAL: https://tests.reproducible-builds.org/debian/forky/amd64/sqlreduce didn't produce a buildlog, even though it has been built. [2025-10-31 17:53:48] INFO: Finished at 2025-10-31 17:53:48.780362, took: 0:00:00.210455 Fri Oct 31 17:53:48 UTC 2025 - successfully updated the database and updated https://tests.reproducible-builds.org/debian/rb-pkg/forky/amd64/sqlreduce.html Starting cleanup. /var/lib/jenkins/userContent/reproducible/debian/rbuild/forky/amd64/sqlreduce_1.3-1.rbuild.log: 78.9% -- replaced with /var/lib/jenkins/userContent/reproducible/debian/rbuild/forky/amd64/sqlreduce_1.3-1.rbuild.log.gz [2025-10-31 17:53:49] INFO: Starting at 2025-10-31 17:53:49.092219 [2025-10-31 17:53:49] INFO: Generating the pages of 1 package(s) [2025-10-31 17:53:49] ERROR: Either /var/lib/jenkins/userContent/reproducible/debian/logs/forky/amd64/sqlreduce_1.3-1.build2.log.gz or /var/lib/jenkins/userContent/reproducible/debian/logdiffs/forky/amd64/sqlreduce_1.3-1.diff.gz is missing [2025-10-31 17:53:49] INFO: Finished at 2025-10-31 17:53:49.294766, took: 0:00:00.202551 All cleanup done. Fri Oct 31 17:53:49 UTC 2025 - total duration: 0h 2m 1s. Fri Oct 31 17:53:49 UTC 2025 - reproducible_build.sh stopped running as /tmp/jenkins-script-z28o1jGk, removing. Finished with result: success Main processes terminated with: code=exited, status=0/SUCCESS Service runtime: 2min 2.434s CPU time consumed: 2.354s Memory peak: 35.6M (swap: 0B)