0s autopkgtest [07:33:24]: starting date and time: 2025-11-04 07:33:24+0000 0s autopkgtest [07:33:24]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [07:33:24]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.m6yckqcf/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:openldap,src:mingw-w64 --apt-upgrade postgresql-18 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=openldap/2.6.10+dfsg-1ubuntu3 mingw-w64/13.0.0-1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-amd64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@sto01-7.secgroup --name adt-resolute-amd64-postgresql-18-20251104-073324-juju-7f2275-prod-proposed-migration-environment-15-1ba3b2e2-435e-4f3d-87a5-a5f269736e1a --image adt/ubuntu-resolute-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-autopkgtest-workers-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 3s Creating nova instance adt-resolute-amd64-postgresql-18-20251104-073324-juju-7f2275-prod-proposed-migration-environment-15-1ba3b2e2-435e-4f3d-87a5-a5f269736e1a from image adt/ubuntu-resolute-amd64-server-20251104.img (UUID e329c678-0fca-4d10-9e41-bfeb59fd2b3a)... 32s autopkgtest [07:33:56]: testbed dpkg architecture: amd64 32s autopkgtest [07:33:56]: testbed apt version: 3.1.11 32s autopkgtest [07:33:56]: @@@@@@@@@@@@@@@@@@@@ test bed setup 33s autopkgtest [07:33:57]: testbed release detected to be: None 33s autopkgtest [07:33:57]: updating testbed package index (apt update) 33s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 33s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 33s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 33s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 34s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [82.2 kB] 34s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [23.4 kB] 34s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [1038 kB] 34s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 34s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [136 kB] 34s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [92.9 kB] 34s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3020 B] 34s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 34s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 34s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 34s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [668 kB] 34s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [264 kB] 34s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [19.3 kB] 34s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [7180 B] 34s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [15.2 kB] 34s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [652 B] 35s Fetched 2516 kB in 1s (2107 kB/s) 35s Reading package lists... 36s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 36s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 36s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 36s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 37s Reading package lists... 37s Reading package lists... 37s Building dependency tree... 37s Reading state information... 37s Calculating upgrade... 37s The following packages will be upgraded: 37s bash-completion iputils-tracepath libldap-common libldap2 37s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 37s Need to get 469 kB of archives. 37s After this operation, 39.9 kB disk space will be freed. 37s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 bash-completion all 1:2.16.0-8 [214 kB] 37s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 iputils-tracepath amd64 3:20250605-1ubuntu1 [14.8 kB] 37s Get:3 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libldap-common all 2.6.10+dfsg-1ubuntu3 [35.9 kB] 37s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libldap2 amd64 2.6.10+dfsg-1ubuntu3 [204 kB] 37s dpkg-preconfigure: unable to re-open stdin: No such file or directory 37s Fetched 469 kB in 0s (0 B/s) 37s (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 ... 78551 files and directories currently installed.) 37s Preparing to unpack .../bash-completion_1%3a2.16.0-8_all.deb ... 37s Unpacking bash-completion (1:2.16.0-8) over (1:2.16.0-7) ... 37s Preparing to unpack .../iputils-tracepath_3%3a20250605-1ubuntu1_amd64.deb ... 37s Unpacking iputils-tracepath (3:20250605-1ubuntu1) over (3:20240905-3ubuntu3) ... 37s Preparing to unpack .../libldap-common_2.6.10+dfsg-1ubuntu3_all.deb ... 37s Unpacking libldap-common (2.6.10+dfsg-1ubuntu3) over (2.6.10+dfsg-1ubuntu2) ... 37s Preparing to unpack .../libldap2_2.6.10+dfsg-1ubuntu3_amd64.deb ... 37s Unpacking libldap2:amd64 (2.6.10+dfsg-1ubuntu3) over (2.6.10+dfsg-1ubuntu2) ... 37s Setting up libldap-common (2.6.10+dfsg-1ubuntu3) ... 37s Setting up bash-completion (1:2.16.0-8) ... 37s Setting up libldap2:amd64 (2.6.10+dfsg-1ubuntu3) ... 37s Setting up iputils-tracepath (3:20250605-1ubuntu1) ... 37s Processing triggers for man-db (2.13.1-1) ... 38s Processing triggers for libc-bin (2.42-0ubuntu3) ... 38s autopkgtest [07:34:02]: upgrading testbed (apt dist-upgrade and autopurge) 38s Reading package lists... 38s Building dependency tree... 38s Reading state information... 39s Calculating upgrade... 39s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 39s Reading package lists... 39s Building dependency tree... 39s Reading state information... 39s Solving dependencies... 39s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 41s autopkgtest [07:34:05]: testbed running kernel: Linux 6.17.0-5-generic #5-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 22 10:00:33 UTC 2025 41s autopkgtest [07:34:05]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-18 48s Get:1 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (dsc) [4420 B] 48s Get:2 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (tar) [22.4 MB] 48s Get:3 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (diff) [22.9 kB] 48s gpgv: Signature made Fri Sep 26 07:48:05 2025 UTC 48s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 48s gpgv: Can't check signature: No public key 48s dpkg-source: warning: cannot verify inline signature for ./postgresql-18_18.0-1.dsc: no acceptable signature found 51s autopkgtest [07:34:15]: testing package postgresql-18 version 18.0-1 53s autopkgtest [07:34:17]: build not needed 61s autopkgtest [07:34:25]: test run-testsuite: preparing testbed 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 62s Solving dependencies... 62s The following NEW packages will be installed: 62s autoconf automake autopoint autotools-dev build-essential clang-21 cpp 62s cpp-15 cpp-15-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 62s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 62s fakeroot g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-15 62s gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 62s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-21-dev 62s libclang-cpp21 libclang1-21 libdebhelper-perl libecpg-compat3 libecpg-dev 62s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 62s libgcc-15-dev libgomp1 libhwasan0 libicu76 libio-pty-perl libipc-run-perl 62s libisl23 libitm1 libjson-perl libllvm21 liblsan0 liblzma-dev libmpc3 62s libncurses-dev libobjc-15-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 62s libpq-oauth libpq5 libquadmath0 libssl-dev libstdc++-15-dev libtcl8.6 62s libtool libtsan2 libubsan1 liburing2 libxml2-dev libxslt1.1 llvm-21 62s llvm-21-dev llvm-21-linker-tools llvm-21-runtime llvm-21-tools locales-all 62s m4 po-debconf postgresql-18 postgresql-18-jit postgresql-client-18 62s postgresql-client-common postgresql-common postgresql-common-dev 62s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 62s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert zlib1g-dev 62s 0 upgraded, 95 newly installed, 0 to remove and 0 not upgraded. 62s Need to get 259 MB of archives. 62s After this operation, 1405 MB of additional disk space will be used. 62s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 62s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 62s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 62s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 62s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 62s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 62s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 62s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 m4 amd64 1.4.20-2 [217 kB] 62s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 62s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 autotools-dev all 20240727.1 [43.4 kB] 62s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 automake all 1:1.18.1-2 [581 kB] 62s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 autopoint all 0.23.1-2build2 [619 kB] 62s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 62s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 62s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 62s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 62s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 62s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 62s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 62s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 62s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 62s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 62s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 62s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 63s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 63s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 63s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 63s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 63s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 63s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 63s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 63s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 63s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 63s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 63s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 63s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 63s Get:37 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 63s Get:38 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 63s Get:39 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 64s Get:40 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 64s Get:41 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 64s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 64s Get:43 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 64s Get:44 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 64s Get:45 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 64s Get:46 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 64s Get:47 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 64s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 64s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libtool all 2.5.4-4build1 [169 kB] 64s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-autoreconf all 21 [12.5 kB] 64s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 64s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [20.5 kB] 64s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-strip-nondeterminism all 1.15.0-1 [5090 B] 64s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 debugedit amd64 1:5.2-3 [49.9 kB] 64s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 dwz amd64 0.16-2 [115 kB] 64s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 gettext amd64 0.23.1-2build2 [1043 kB] 64s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 64s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 64s Get:59 http://ftpmaster.internal/ubuntu resolute/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 64s Get:60 http://ftpmaster.internal/ubuntu resolute/main amd64 emacsen-common all 3.0.8 [13.9 kB] 64s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 dictionaries-common all 1.30.11 [178 kB] 64s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 64s Get:63 http://ftpmaster.internal/ubuntu resolute/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 64s Get:64 http://ftpmaster.internal/ubuntu resolute/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 64s Get:65 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 64s Get:66 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 64s Get:67 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 64s Get:68 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 64s Get:69 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 64s Get:70 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 64s Get:71 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 64s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 64s Get:73 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 64s Get:74 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 65s Get:75 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 65s Get:76 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 65s Get:77 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 65s Get:78 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 65s Get:79 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 65s Get:80 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 65s Get:81 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 65s Get:82 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 65s Get:83 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 65s Get:84 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 65s Get:85 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 65s Get:86 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 66s Get:87 http://ftpmaster.internal/ubuntu resolute/main amd64 locales-all amd64 2.42-0ubuntu3 [11.2 MB] 66s Get:88 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 66s Get:89 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 66s Get:90 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 66s Get:91 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 66s Get:92 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 66s Get:93 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 66s Get:94 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 66s Get:95 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 66s Preconfiguring packages ... 67s Fetched 259 MB in 5s (56.0 MB/s) 67s Selecting previously unselected package libjson-perl. 67s (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 ... 78551 files and directories currently installed.) 67s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 67s Unpacking libjson-perl (4.10000-1) ... 67s Selecting previously unselected package postgresql-client-common. 67s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 67s Unpacking postgresql-client-common (282ubuntu1) ... 67s Selecting previously unselected package libio-pty-perl. 67s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 67s Unpacking libio-pty-perl (1:1.20-1build3) ... 67s Selecting previously unselected package libipc-run-perl. 67s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 67s Unpacking libipc-run-perl (20231003.0-2) ... 67s Selecting previously unselected package postgresql-common-dev. 67s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 67s Unpacking postgresql-common-dev (282ubuntu1) ... 67s Selecting previously unselected package ssl-cert. 67s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 67s Unpacking ssl-cert (1.1.3ubuntu1) ... 67s Selecting previously unselected package postgresql-common. 67s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 67s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 67s Unpacking postgresql-common (282ubuntu1) ... 67s Selecting previously unselected package m4. 67s Preparing to unpack .../07-m4_1.4.20-2_amd64.deb ... 67s Unpacking m4 (1.4.20-2) ... 67s Selecting previously unselected package autoconf. 67s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 67s Unpacking autoconf (2.72-3.1ubuntu1) ... 67s Selecting previously unselected package autotools-dev. 67s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 67s Unpacking autotools-dev (20240727.1) ... 67s Selecting previously unselected package automake. 67s Preparing to unpack .../10-automake_1%3a1.18.1-2_all.deb ... 67s Unpacking automake (1:1.18.1-2) ... 67s Selecting previously unselected package autopoint. 67s Preparing to unpack .../11-autopoint_0.23.1-2build2_all.deb ... 67s Unpacking autopoint (0.23.1-2build2) ... 67s Selecting previously unselected package libisl23:amd64. 67s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 67s Unpacking libisl23:amd64 (0.27-1) ... 67s Selecting previously unselected package libmpc3:amd64. 67s Preparing to unpack .../13-libmpc3_1.3.1-1build3_amd64.deb ... 67s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 67s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 67s Preparing to unpack .../14-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package cpp-15. 67s Preparing to unpack .../15-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package cpp-x86-64-linux-gnu. 67s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 67s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 67s Selecting previously unselected package cpp. 67s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 67s Unpacking cpp (4:15.2.0-4ubuntu1) ... 67s Selecting previously unselected package libcc1-0:amd64. 67s Preparing to unpack .../18-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libgomp1:amd64. 67s Preparing to unpack .../19-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libitm1:amd64. 67s Preparing to unpack .../20-libitm1_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libasan8:amd64. 67s Preparing to unpack .../21-libasan8_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package liblsan0:amd64. 67s Preparing to unpack .../22-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libtsan2:amd64. 67s Preparing to unpack .../23-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libubsan1:amd64. 67s Preparing to unpack .../24-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libhwasan0:amd64. 67s Preparing to unpack .../25-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libquadmath0:amd64. 67s Preparing to unpack .../26-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package libgcc-15-dev:amd64. 67s Preparing to unpack .../27-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 67s Preparing to unpack .../28-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package gcc-15. 67s Preparing to unpack .../29-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package gcc-x86-64-linux-gnu. 67s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 67s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 67s Selecting previously unselected package gcc. 67s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 67s Unpacking gcc (4:15.2.0-4ubuntu1) ... 67s Selecting previously unselected package libstdc++-15-dev:amd64. 67s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 67s Selecting previously unselected package g++-15-x86-64-linux-gnu. 67s Preparing to unpack .../33-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 67s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 68s Selecting previously unselected package g++-15. 68s Preparing to unpack .../34-g++-15_15.2.0-7ubuntu1_amd64.deb ... 68s Unpacking g++-15 (15.2.0-7ubuntu1) ... 68s Selecting previously unselected package g++-x86-64-linux-gnu. 68s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 68s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 68s Selecting previously unselected package g++. 68s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 68s Unpacking g++ (4:15.2.0-4ubuntu1) ... 68s Selecting previously unselected package build-essential. 68s Preparing to unpack .../37-build-essential_12.12ubuntu1_amd64.deb ... 68s Unpacking build-essential (12.12ubuntu1) ... 68s Selecting previously unselected package libllvm21:amd64. 68s Preparing to unpack .../38-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package libclang-cpp21. 68s Preparing to unpack .../39-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package libgc1:amd64. 68s Preparing to unpack .../40-libgc1_1%3a8.2.10-1_amd64.deb ... 68s Unpacking libgc1:amd64 (1:8.2.10-1) ... 68s Selecting previously unselected package libobjc4:amd64. 68s Preparing to unpack .../41-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 68s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 68s Selecting previously unselected package libobjc-15-dev:amd64. 68s Preparing to unpack .../42-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 68s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 68s Selecting previously unselected package libclang-common-21-dev:amd64. 68s Preparing to unpack .../43-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package llvm-21-linker-tools. 68s Preparing to unpack .../44-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package libclang1-21. 68s Preparing to unpack .../45-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package clang-21. 68s Preparing to unpack .../46-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 68s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 68s Selecting previously unselected package libdebhelper-perl. 68s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 68s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 68s Selecting previously unselected package libtool. 68s Preparing to unpack .../48-libtool_2.5.4-4build1_all.deb ... 68s Unpacking libtool (2.5.4-4build1) ... 68s Selecting previously unselected package dh-autoreconf. 68s Preparing to unpack .../49-dh-autoreconf_21_all.deb ... 68s Unpacking dh-autoreconf (21) ... 68s Selecting previously unselected package libarchive-zip-perl. 68s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 68s Unpacking libarchive-zip-perl (1.68-1) ... 68s Selecting previously unselected package libfile-stripnondeterminism-perl. 68s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... 68s Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... 68s Selecting previously unselected package dh-strip-nondeterminism. 68s Preparing to unpack .../52-dh-strip-nondeterminism_1.15.0-1_all.deb ... 68s Unpacking dh-strip-nondeterminism (1.15.0-1) ... 68s Selecting previously unselected package debugedit. 68s Preparing to unpack .../53-debugedit_1%3a5.2-3_amd64.deb ... 68s Unpacking debugedit (1:5.2-3) ... 68s Selecting previously unselected package dwz. 68s Preparing to unpack .../54-dwz_0.16-2_amd64.deb ... 68s Unpacking dwz (0.16-2) ... 68s Selecting previously unselected package gettext. 68s Preparing to unpack .../55-gettext_0.23.1-2build2_amd64.deb ... 68s Unpacking gettext (0.23.1-2build2) ... 68s Selecting previously unselected package intltool-debian. 68s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 68s Unpacking intltool-debian (0.35.0+20060710.6) ... 68s Selecting previously unselected package po-debconf. 68s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 68s Unpacking po-debconf (1.0.21+nmu1) ... 68s Selecting previously unselected package debhelper. 68s Preparing to unpack .../58-debhelper_13.24.2ubuntu1_all.deb ... 68s Unpacking debhelper (13.24.2ubuntu1) ... 68s Selecting previously unselected package emacsen-common. 68s Preparing to unpack .../59-emacsen-common_3.0.8_all.deb ... 68s Unpacking emacsen-common (3.0.8) ... 69s Selecting previously unselected package dictionaries-common. 69s Preparing to unpack .../60-dictionaries-common_1.30.11_all.deb ... 69s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 69s Unpacking dictionaries-common (1.30.11) ... 69s Selecting previously unselected package libfakeroot:amd64. 69s Preparing to unpack .../61-libfakeroot_1.37.1.2-1_amd64.deb ... 69s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 69s Selecting previously unselected package fakeroot. 69s Preparing to unpack .../62-fakeroot_1.37.1.2-1_amd64.deb ... 69s Unpacking fakeroot (1.37.1.2-1) ... 69s Selecting previously unselected package hunspell-en-us. 69s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 69s Unpacking hunspell-en-us (1:2020.12.07-4) ... 69s Selecting previously unselected package libpgtypes3:amd64. 69s Preparing to unpack .../64-libpgtypes3_18.0-1_amd64.deb ... 69s Unpacking libpgtypes3:amd64 (18.0-1) ... 69s Selecting previously unselected package libpq5:amd64. 69s Preparing to unpack .../65-libpq5_18.0-1_amd64.deb ... 69s Unpacking libpq5:amd64 (18.0-1) ... 69s Selecting previously unselected package libecpg6:amd64. 69s Preparing to unpack .../66-libecpg6_18.0-1_amd64.deb ... 69s Unpacking libecpg6:amd64 (18.0-1) ... 69s Selecting previously unselected package libecpg-compat3:amd64. 69s Preparing to unpack .../67-libecpg-compat3_18.0-1_amd64.deb ... 69s Unpacking libecpg-compat3:amd64 (18.0-1) ... 69s Selecting previously unselected package libssl-dev:amd64. 69s Preparing to unpack .../68-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 69s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 69s Selecting previously unselected package libpq-dev. 69s Preparing to unpack .../69-libpq-dev_18.0-1_amd64.deb ... 69s Unpacking libpq-dev (18.0-1) ... 69s Selecting previously unselected package libecpg-dev. 69s Preparing to unpack .../70-libecpg-dev_18.0-1_amd64.deb ... 69s Unpacking libecpg-dev (18.0-1) ... 69s Selecting previously unselected package libicu76:amd64. 69s Preparing to unpack .../71-libicu76_76.1-4ubuntu2_amd64.deb ... 69s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 69s Selecting previously unselected package libncurses-dev:amd64. 69s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 69s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 69s Selecting previously unselected package libpq-oauth:amd64. 69s Preparing to unpack .../73-libpq-oauth_18.0-1_amd64.deb ... 69s Unpacking libpq-oauth:amd64 (18.0-1) ... 69s Selecting previously unselected package libtcl8.6:amd64. 69s Preparing to unpack .../74-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 69s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 69s Selecting previously unselected package liburing2:amd64. 69s Preparing to unpack .../75-liburing2_2.11-1_amd64.deb ... 69s Unpacking liburing2:amd64 (2.11-1) ... 69s Selecting previously unselected package liblzma-dev:amd64. 69s Preparing to unpack .../76-liblzma-dev_5.8.1-1build2_amd64.deb ... 69s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 69s Selecting previously unselected package zlib1g-dev:amd64. 69s Preparing to unpack .../77-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 69s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 69s Selecting previously unselected package libxml2-dev:amd64. 69s Preparing to unpack .../78-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 69s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 69s Selecting previously unselected package libxslt1.1:amd64. 69s Preparing to unpack .../79-libxslt1.1_1.1.43-0.3_amd64.deb ... 69s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 69s Selecting previously unselected package llvm-21-runtime. 69s Preparing to unpack .../80-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 69s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 69s Selecting previously unselected package libpfm4:amd64. 69s Preparing to unpack .../81-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 69s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 69s Selecting previously unselected package llvm-21. 69s Preparing to unpack .../82-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 69s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 69s Selecting previously unselected package libffi-dev:amd64. 69s Preparing to unpack .../83-libffi-dev_3.5.2-2_amd64.deb ... 69s Unpacking libffi-dev:amd64 (3.5.2-2) ... 69s Selecting previously unselected package llvm-21-tools. 69s Preparing to unpack .../84-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 69s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 69s Selecting previously unselected package llvm-21-dev. 69s Preparing to unpack .../85-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 69s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 70s Selecting previously unselected package locales-all. 70s Preparing to unpack .../86-locales-all_2.42-0ubuntu3_amd64.deb ... 70s Unpacking locales-all (2.42-0ubuntu3) ... 71s Selecting previously unselected package postgresql-client-18. 71s Preparing to unpack .../87-postgresql-client-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-client-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-18. 71s Preparing to unpack .../88-postgresql-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-18-jit. 71s Preparing to unpack .../89-postgresql-18-jit_18.0-1_amd64.deb ... 71s Unpacking postgresql-18-jit (18.0-1) ... 71s Selecting previously unselected package postgresql-doc-18. 71s Preparing to unpack .../90-postgresql-doc-18_18.0-1_all.deb ... 71s Unpacking postgresql-doc-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-plperl-18. 71s Preparing to unpack .../91-postgresql-plperl-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-plperl-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-plpython3-18. 71s Preparing to unpack .../92-postgresql-plpython3-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-plpython3-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-pltcl-18. 71s Preparing to unpack .../93-postgresql-pltcl-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-pltcl-18 (18.0-1) ... 71s Selecting previously unselected package postgresql-server-dev-18. 71s Preparing to unpack .../94-postgresql-server-dev-18_18.0-1_amd64.deb ... 71s Unpacking postgresql-server-dev-18 (18.0-1) ... 71s Setting up postgresql-client-common (282ubuntu1) ... 71s Setting up libpgtypes3:amd64 (18.0-1) ... 71s Setting up postgresql-doc-18 (18.0-1) ... 72s update-alternatives: using /usr/share/postgresql/18/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 72s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 72s Setting up libio-pty-perl (1:1.20-1build3) ... 72s Setting up libarchive-zip-perl (1.68-1) ... 72s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 72s Setting up libpq5:amd64 (18.0-1) ... 72s Setting up m4 (1.4.20-2) ... 72s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libffi-dev:amd64 (3.5.2-2) ... 72s Setting up locales-all (2.42-0ubuntu3) ... 72s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 72s Setting up fakeroot (1.37.1.2-1) ... 72s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 72s Setting up autotools-dev (20240727.1) ... 72s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 72s Setting up emacsen-common (3.0.8) ... 72s Setting up ssl-cert (1.1.3ubuntu1) ... 72s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 72s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 72s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 72s Setting up libmpc3:amd64 (1.3.1-1build3) ... 72s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 72s Setting up autopoint (0.23.1-2build2) ... 72s Setting up libipc-run-perl (20231003.0-2) ... 72s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 72s Setting up libgc1:amd64 (1:8.2.10-1) ... 72s Setting up autoconf (2.72-3.1ubuntu1) ... 72s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 72s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 72s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 72s Setting up dwz (0.16-2) ... 72s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libjson-perl (4.10000-1) ... 72s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 72s Setting up debugedit (1:5.2-3) ... 72s Setting up libecpg6:amd64 (18.0-1) ... 72s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 72s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 72s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 72s Setting up liburing2:amd64 (2.11-1) ... 72s Setting up libisl23:amd64 (0.27-1) ... 72s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 72s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 72s Setting up postgresql-common-dev (282ubuntu1) ... 72s Setting up automake (1:1.18.1-2) ... 72s update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode 72s Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... 72s Setting up gettext (0.23.1-2build2) ... 72s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 72s Setting up libecpg-compat3:amd64 (18.0-1) ... 72s Setting up postgresql-client-18 (18.0-1) ... 72s 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 72s Setting up dictionaries-common (1.30.11) ... 72s Setting up libpq-oauth:amd64 (18.0-1) ... 72s Setting up libpq-dev (18.0-1) ... 72s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 72s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 72s Setting up libecpg-dev (18.0-1) ... 72s Setting up intltool-debian (0.35.0+20060710.6) ... 72s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 72s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 72s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 72s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 72s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 72s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 72s Setting up postgresql-common (282ubuntu1) ... 73s Creating config file /etc/postgresql-common/createcluster.conf with new version 73s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 73s en_us 73s Removing obsolete dictionary files: 73s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 73s Setting up dh-strip-nondeterminism (1.15.0-1) ... 73s Setting up cpp-15 (15.2.0-7ubuntu1) ... 73s Setting up hunspell-en-us (1:2020.12.07-4) ... 73s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 73s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 73s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 73s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 73s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 73s Setting up po-debconf (1.0.21+nmu1) ... 73s Setting up postgresql-18 (18.0-1) ... 74s Creating new PostgreSQL cluster 18/main ... 74s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 74s The files belonging to this database system will be owned by user "postgres". 74s This user must also own the server process. 74s 74s The database cluster will be initialized with locale "C.UTF-8". 74s The default database encoding has accordingly been set to "UTF8". 74s The default text search configuration will be set to "english". 74s 74s Data page checksums are enabled. 74s 74s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 74s creating subdirectories ... ok 74s selecting dynamic shared memory implementation ... posix 74s selecting default "max_connections" ... 100 74s selecting default "shared_buffers" ... 128MB 74s selecting default time zone ... Etc/UTC 74s creating configuration files ... ok 74s running bootstrap script ... ok 74s performing post-bootstrap initialization ... ok 74s syncing data to disk ... ok 76s Setting up postgresql-18-jit (18.0-1) ... 76s Setting up gcc-15 (15.2.0-7ubuntu1) ... 76s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 77s Setting up postgresql-plpython3-18 (18.0-1) ... 77s Setting up cpp (4:15.2.0-4ubuntu1) ... 77s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 77s Setting up postgresql-plperl-18 (18.0-1) ... 77s Setting up g++-15 (15.2.0-7ubuntu1) ... 77s Setting up postgresql-pltcl-18 (18.0-1) ... 77s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 77s Setting up libtool (2.5.4-4build1) ... 77s Setting up postgresql-server-dev-18 (18.0-1) ... 77s Setting up gcc (4:15.2.0-4ubuntu1) ... 77s Setting up dh-autoreconf (21) ... 77s Setting up g++ (4:15.2.0-4ubuntu1) ... 77s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 77s Setting up build-essential (12.12ubuntu1) ... 77s Setting up debhelper (13.24.2ubuntu1) ... 77s Processing triggers for man-db (2.13.1-1) ... 77s Processing triggers for install-info (7.2-5) ... 77s Processing triggers for libc-bin (2.42-0ubuntu3) ... 77s Processing triggers for systemd (257.9-0ubuntu2) ... 77s Processing triggers for dictionaries-common (1.30.11) ... 80s autopkgtest [07:34:44]: test run-testsuite: [----------------------- 81s ====== Running all tests with umask 077 ======= 81s ### PostgreSQL test 001_packages.t ### 81s 1..23 81s ok 1 - /etc/os-release exists 81s ok 2 - OS is ubuntu 81s ok 3 - OS version is 26.04 81s # PostgreSQL versions installed: 18 81s # 18 81s ok 4 - postgresql-18 installed 81s ok 5 - postgresql-plpython3-18 installed 81s ok 6 - postgresql-plperl-18 installed 81s ok 7 - postgresql-pltcl-18 installed 81s ok 8 - postgresql-18-jit installed 81s ok 9 - postgresql-server-dev-18 installed 81s ok 10 # skip No postgresql-contrib-18 package for version 18 81s # postgresql-doc-18 installed 81s ok 11 - At least one doc package installed 81s ok 12 - libecpg-dev installed 81s ok 13 - postgresql-common-dev installed 81s ok 14 - procps installed 81s ok 15 - netcat-openbsd installed 81s ok 16 - hunspell-en-us installed 81s ok 17 - system has a default UTF-8 locale 81s ok 18 - locale ru_RU exists 81s ok 19 - locale ru_RU.UTF-8 exists 81s ok 20 - user postgres in the UNIX group ssl-cert 81s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 81s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 81s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 81s ### End test 001_packages.t ### 81s 81s ### PostgreSQL test 002_existing_clusters.t ### 81s 1..8 81s # Cleanup 81s ok 1 - Cleanup: No clusters left behind 81s ok 2 - No postgres processes left behind 81s ok 3 - No files in /etc/postgresql left behind 81s ok 4 - No files in /var/lib/postgresql left behind 81s ok 5 - No files in /var/run/postgresql left behind 81s ok 6 - No files in /var/log/postgresql left behind 81s ok 7 - PostgreSQL TCP ports are closed 81s ok 8 - Next free port is 5432 81s ### End test 002_existing_clusters.t ### 81s 81s ### PostgreSQL test 003_alternatives.t ### 81s 1..9 81s # Newest PG version installed is 18 81s ok 1 - psql.1.gz link group 81s ok 2 - postmaster.1.gz link group does not exist 81s ok 3 - psql.1.gz alternative 81s ok 4 - pg_dump.1.gz alternative 81s ok 5 - postgres.1.gz alternative 81s ok 6 - pg_ctl.1.gz alternative 81s # Newest PG doc version installed is 18 81s ok 7 - SPI_connect.3.gz link group 81s ok 8 - SPI_connect.3.gz alternative 81s ok 9 - SPI_exec.3.gz alternative 81s ### End test 003_alternatives.t ### 81s 81s ### PostgreSQL test 005_PgCommon.t ### 81s 1..24 81s ok 1 - correctly parsed line 'local all postgres ident sameuser' 81s ok 2 - correctly parsed line 'local foo nobody trust' 81s ok 3 - correctly parsed line 'local foo nobody crypt' 81s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 81s ok 5 - correctly parsed line 'local foo,bar nobody ident' 81s ok 6 - correctly parsed line 'local all +foogrp password' 81s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 81s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 81s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 81s ok 10 - @expected_records has correct number of entries 81s ok 11 - returned read_pg_hba array has correct number of records 81s ok 12 - line 'foo all all md5' parsed as invalid 81s ok 13 - line 'local all all foo' parsed as invalid 81s ok 14 - line 'host all all foo' parsed as invalid 81s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 81s ok 16 - line 'host all all md5' parsed as invalid 81s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 81s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 81s ok 19 - read_conf_file returns empty dict for nonexisting file 81s ok 20 - read_conf_file() parsing 81s ok 21 - read_conf_file() parsing with include directives 81s ok 22 - set_conf_value 81s ok 23 - disable_conf_value 81s ok 24 - replace_conf_value 81s ### End test 005_PgCommon.t ### 81s 81s ### PostgreSQL test 006_next_free_port.t ### 81s 1..5 81s ok 1 - next_free_port is 5432 82s ok 2 - next_free_port detects localhost ipv4 socket 83s ok 3 - next_free_port detects wildcard ipv4 socket 84s ok 4 - next_free_port detects localhost ipv6 socket 85s ok 5 - next_free_port detects wildcard ipv6 socket 85s ### End test 006_next_free_port.t ### 85s 85s ### PostgreSQL test 007_pg_conftool.t ### 85s 1..41 85s # test without cluster 85s ok 1 - pg_conftool show all 85s ok 2 - correct output of pg_conftool show all 85s ok 3 - pg_conftool foo.conf show all 85s ok 4 - correct output of pg_conftool foo.conf show all 85s ok 5 - pg_conftool /tmp/2VvU9uBwHU/different.conf show all 85s ok 6 - correct output of pg_conftool /tmp/2VvU9uBwHU/different.conf show all 85s ok 7 - pg_conftool 9.7 main show all 85s ok 8 - correct output of pg_conftool 9.7 main show all 85s # test show 85s ok 9 - pg_conftool show all 85s ok 10 - correct output of pg_conftool show all 85s ok 11 - pg_conftool other.conf show all 85s ok 12 - correct output of pg_conftool other.conf show all 85s ok 13 - pg_conftool /tmp/2VvU9uBwHU/different.conf show all 85s ok 14 - correct output of pg_conftool /tmp/2VvU9uBwHU/different.conf show all 85s ok 15 - pg_conftool 18 main show all 85s ok 16 - correct output of pg_conftool 18 main show all 86s ok 17 - pg_conftool 18 main other.conf show all 86s ok 18 - correct output of pg_conftool 18 main other.conf show all 86s ok 19 - pg_conftool show a 86s ok 20 - correct output of pg_conftool show a 86s ok 21 - pg_conftool -s show a 86s ok 22 - correct output of pg_conftool -s show a 86s # test set 86s ok 23 - pg_conftool set c 7 86s ok 24 - correct output of pg_conftool set c 7 86s ok 25 - file contains new setting 86s ok 26 - pg_conftool set a 8 86s ok 27 - correct output of pg_conftool set a 8 86s ok 28 - file contains updated setting 86s ok 29 - pg_conftool /tmp/2VvU9uBwHU/different.conf set a 9 86s ok 30 - correct output of pg_conftool /tmp/2VvU9uBwHU/different.conf set a 9 86s ok 31 - file with path contains updated setting 86s # test remove 86s ok 32 - pg_conftool remove a 86s ok 33 - correct output of pg_conftool remove a 86s ok 34 - setting removed from file 86s ok 35 - pg_conftool /tmp/2VvU9uBwHU/different.conf remove a 86s ok 36 - correct output of pg_conftool /tmp/2VvU9uBwHU/different.conf remove a 86s ok 37 - setting removed from file with path 86s # test edit 86s ok 38 - pg_conftool edit 86s ok 39 - correct output of pg_conftool edit 86s ok 40 - pg_conftool /tmp/2VvU9uBwHU/different.conf edit 86s ok 41 - correct output of pg_conftool /tmp/2VvU9uBwHU/different.conf edit 86s ### End test 007_pg_conftool.t ### 86s 86s ### PostgreSQL test 010_defaultport_cluster.t ### 86s 1..14 86s ok 1 - psql --version 86s ok 2 - pg_wrapper selects highest available version number 86s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 86s ok 4 - connecting to localhost fails with no clusters 86s ok 5 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -l 86s ok 6 - pg_wrapper uses host and port from PGCLUSTER 86s ok 7 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --cluster 18/127.0.0.3:5430 -l 86s ok 8 - pg_wrapper uses --cluster from the command line 86s ok 9 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -h 127.0.0.3 -l 86s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 86s ok 11 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --host 127.0.0.3 -l 86s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 86s ok 13 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 86s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 86s ### End test 010_defaultport_cluster.t ### 86s 86s ### PostgreSQL test 015_start_stop.t ### 86s 1..71 86s # We are running systemd 86s # Running tests for 18 86s # Cluster does not exist yet 86s ok 1 - cluster 18 main does not exist 86s ok 2 - service postgresql@18-main does not exist 86s ok 3 - systemctl start postgresql 86s ok 4 - cluster 18 main does not exist 86s ok 5 - service postgresql@18-main does not exist 86s ok 6 - systemctl start postgresql@18-main 86s ok 7 - cluster 18 main does not exist 86s ok 8 - service postgresql@18-main does not exist 86s # Start/stop postgresql using system tools 87s ok 9 - pg_createcluster 18 main 87s ok 10 - cluster 18 main is stopped 87s ok 11 - service postgresql@18-main is stopped 89s ok 12 - systemctl start postgresql 89s ok 13 - cluster 18 main is running 89s ok 14 - service postgresql@18-main is running 89s ok 15 - systemctl start postgresql 89s ok 16 - cluster 18 main is already running 89s ok 17 - service postgresql@18-main is already running 89s ok 18 - systemctl stop postgresql 95s ok 19 - cluster 18 main is stopped 95s ok 20 - service postgresql@18-main is stopped 95s ok 21 - systemctl stop postgresql 95s ok 22 - cluster 18 main is already stopped 95s ok 23 - service postgresql@18-main is already stopped 95s # Start/stop specific cluster using system tools 97s ok 24 - systemctl start postgresql@18-main 97s ok 25 - cluster 18 main is running 97s ok 26 - service postgresql@18-main is running 97s ok 27 - systemctl start postgresql@18-main 97s ok 28 - cluster 18 main is running 97s ok 29 - service postgresql@18-main is running 100s ok 30 - systemctl restart postgresql@18-main 100s ok 31 - cluster 18 main is running 100s ok 32 - service postgresql@18-main is running 100s ok 33 - systemctl stop postgresql@18-main 100s ok 34 - cluster 18 main is stopped 100s ok 35 - service postgresql@18-main is stopped 100s ok 36 - systemctl stop postgresql@18-main 100s ok 37 - cluster 18 main is already stopped 100s ok 38 - service postgresql@18-main is already stopped 101s ok 39 - pg_dropcluster 18 main 101s ok 40 - cluster 18 main does not exist 101s ok 41 - service postgresql@18-main does not exist 101s # Start/stop specific cluster using pg_*cluster 101s ok 42 - pg_ctlcluster start 18 main 101s ok 43 - cluster 18 main does not exist 101s ok 44 - service postgresql@18-main does not exist 104s ok 45 - pg_createcluster 18 main --start 104s ok 46 - cluster 18 main is running 104s ok 47 - service postgresql@18-main is running 104s ok 48 - pg_ctlcluster 18 main start 104s ok 49 - cluster 18 main is already running 104s ok 50 - service postgresql@18-main is already running 106s ok 51 - pg_ctlcluster 18-main restart 106s ok 52 - cluster 18 main is running 106s ok 53 - service postgresql@18-main is running 106s ok 54 - pg_ctlcluster 18 main stop 106s ok 55 - cluster 18 main is stopped 106s ok 56 - service postgresql@18-main is stopped 106s ok 57 - pg_ctlcluster 18 main stop 106s ok 58 - cluster 18 main is already stopped 106s ok 59 - service postgresql@18-main is already stopped 109s ok 60 - pg_ctlcluster start 18-main 109s ok 61 - cluster 18 main is running 109s ok 62 - service postgresql@18-main is running 110s ok 63 - pg_dropcluster 18 main --stop 110s # Cleanup 110s ok 64 - Cleanup: No clusters left behind 110s ok 65 - No postgres processes left behind 110s ok 66 - No files in /etc/postgresql left behind 110s ok 67 - No files in /var/lib/postgresql left behind 110s ok 68 - No files in /var/run/postgresql left behind 110s ok 69 - No files in /var/log/postgresql left behind 110s ok 70 - PostgreSQL TCP ports are closed 110s ok 71 - Next free port is 5432 110s ### End test 015_start_stop.t ### 110s 110s ### PostgreSQL test 020_create_sql_remove.t ### 110s 1..141 110s # Running tests for 18 112s ok 1 - pg_createcluster 18 main --start -- -X /tmp/18.xlog.yz3h81 112s ok 2 - pg_createcluster 18 main 112s ok 3 - Socket and pid file are in /var/run/postgresql/ 112s ok 4 - xlog/wal directory /tmp/18.xlog.yz3h81 was created 112s ok 5 - local method in pg_hba.conf is peer 112s ok 6 - host method in pg_hba.conf is scram-sha-256 112s ok 7 - Exactly one postgres master process running 115s ok 8 - pg_ctlcluster 18 main restart 115s ok 9 - cluster restarts with new environment file 115s ok 10 - Exactly one postgres master process running 115s ok 11 - correct value of PGEXTRAVAR1 in environment 115s ok 12 - correct value of PGEXTRAVAR2 in environment 115s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 115s ok 14 - createdb --version 115s ok 15 - pg_wrapper+createdb selects version number of cluster 115s ok 16 - psql --version 115s ok 17 - pg_wrapper+psql selects version 18 115s ok 18 - pg_lscluster reports online cluster on port 5432 115s ok 19 - log file is actually used 115s ok 20 - /etc/postgresql is owned by user "postgres" 115s ok 21 - version configuration directory file is owned by user "postgres" 115s ok 22 - configuration directory file is owned by user "postgres" 115s ok 23 - version data directory file is owned by user "postgres" 115s ok 24 - data directory file is owned by user "postgres" 115s ok 25 - log file has 0640 permissions 115s ok 26 - log file is owned by user "postgres" 115s ok 27 - log file is owned by group "adm" 115s ok 28 - no log symlink by default 115s ok 29 - /var/log/postgresql/postgresql-18-main.log is the default log if log symlink is missing 115s ok 30 - pg_lsclusters -h 115s ok 31 - correct output of pg_lsclusters -h 115s ok 32 - stopping cluster 118s ok 33 - restarting cluster with nondefault log symlink 118s ok 34 - log target is used as log file 118s ok 35 - default log is not used 118s ok 36 - pg_lsclusters -h 118s ok 37 - correct output of pg_lsclusters -h 118s ok 38 - stopping cluster 120s ok 39 - restarting cluster with explicitly configured log file 120s ok 40 - default log is not used 120s ok 41 - log symlink target is used for startup message 120s ok 42 - exactly one log file 120s ok 43 - custom log is actually used 120s ok 44 - pg_lsclusters -h 120s ok 45 - correct output of pg_lsclusters -h 121s ok 46 - stopping cluster 121s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 121s ok 48 - /etc/postgres-hack was not created 123s ok 49 - restarting cluster 123s ok 50 - ps -o tty -U postgres h 123s ok 51 - postgres processes do not have an associated terminal 123s ok 52 - Server is linked with SSL support 123s ok 53 - SSL is enabled in postgresql.conf 123s ok 54 - psql -l fails for nobody 123s ok 55 - createuser nobody 123s ok 56 - createdb nobodydb 123s ok 57 - psql -ltA succeeds for nobody 123s ok 58 - psql -ltA output 123s ok 59 - SQL command: create table 123s ok 60 - SQL command: insert into table values 123s ok 61 - SQL command: insert into table values 123s ok 62 - primary key violation 123s ok 63 - psql -tAc "select * from phone order by name" nobodydb 123s ok 64 - SQL command output: select -tA 123s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 123s ok 66 - SQL command output: select -tx 123s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 123s ok 68 - SQL command output: select -tAx 123s ok 69 - CREATE EXTENSION plperlu fails for user nobody 123s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 123s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 123s ok 72 - creating PL/PerlU function as user nobody fails 123s ok 73 - creating unsafe PL/Perl function as user postgres fails 123s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 123s ok 75 - creating PL/PerlU function as user postgres succeeds 123s ok 76 - psql nobodydb -Atc "select read_file()" 123s ok 77 - calling PL/PerlU function 123s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 123s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 123s ok 80 - creating unsafe PL/Perl function as user nobody fails 123s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 123s ok 82 - creating PL/Perl function as user nobody succeeds 123s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 123s ok 84 - calling PL/Perl function 123s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 123s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 123s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 123s ok 88 - creating PL/Python3 function as user postgres succeeds 124s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 124s ok 90 - calling PL/Python function 124s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 124s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 124s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 124s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 124s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 124s ok 96 - creating PL/Tcl function as user nobody succeeds 124s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 124s ok 98 - creating PL/TclU function as user postgres succeeds 124s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 124s ok 100 - calling PL/Tcl function 124s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 124s ok 102 - calling PL/TclU function 124s ok 103 - stopping cluster 124s ok 104 - pg_ctlcluster 18 main start 124s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 126s ok 106 - pg_ctlcluster 18 main start 126s ok 107 - cluster restarts with pgdata symlink 127s ok 108 - postgres master has OOM killer protection 127s ok 109 - postgres client backend has no OOM adjustment 127s ok 110 - ps h 7327 127s ok 111 - process title is idle 127s ok 112 - ps h 7327 127s ok 113 - process title is idle in transaction 127s ok 114 - stopping cluster 130s ok 115 - starting cluster as postgres works without a log file 130s ok 116 - log file got recreated and used 130s ok 117 - creating a directory in spc2 130s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/18.spc1.JwHhFT'" 130s ok 119 - creating tablespace spc1 130s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 130s ok 121 - creating a table in spc1 130s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/18.spc2.vYKGAx'" 130s ok 123 - creating tablespace spc2 130s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 130s ok 125 - creating a table in spc2 130s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 130s ok 127 - Correct apt NeverAutoRemove config 130s ok 128 - pg_dropcluster removes cluster 130s ok 129 - xlog/wal directory /tmp/18.xlog.yz3h81 was deleted 130s ok 130 - tablespace spc1 was emptied 130s ok 131 - tablespace spc2 was emptied 130s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 130s ok 133 - Correct apt NeverAutoRemove config 130s # Cleanup 130s ok 134 - Cleanup: No clusters left behind 130s ok 135 - No postgres processes left behind 130s ok 136 - No files in /etc/postgresql left behind 130s ok 137 - No files in /var/lib/postgresql left behind 130s ok 138 - No files in /var/run/postgresql left behind 130s ok 139 - No files in /var/log/postgresql left behind 130s ok 140 - PostgreSQL TCP ports are closed 130s ok 141 - Next free port is 5432 130s ### End test 020_create_sql_remove.t ### 130s 130s ### PostgreSQL test 021_pg_renamecluster.t ### 130s 1..20 133s ok 1 - pg_createcluster 18 main 136s ok 2 - pg_renamecluster 18 main donau 136s ok 3 - psql -tAc "show data_directory" 136s ok 4 - cluster is running and data_directory was moved 136s ok 5 - pg_hba.conf location updated 136s ok 6 - pg_ident.conf location updated 136s ok 7 - external_pid_file location updated 136s ok 8 - external_pid_file exists 136s ok 9 # skip no stats_temp_directory in 18 136s ok 10 # skip no stats_temp_directory in 18 136s ok 11 - cluster_name is updated 137s ok 12 - pg_dropcluster removes cluster 137s # Cleanup 137s ok 13 - Cleanup: No clusters left behind 137s ok 14 - No postgres processes left behind 137s ok 15 - No files in /etc/postgresql left behind 137s ok 16 - No files in /var/lib/postgresql left behind 137s ok 17 - No files in /var/run/postgresql left behind 137s ok 18 - No files in /var/log/postgresql left behind 137s ok 19 - PostgreSQL TCP ports are closed 137s ok 20 - Next free port is 5432 137s ### End test 021_pg_renamecluster.t ### 137s 137s ### PostgreSQL test 022_recovery.t ### 137s 1..17 137s # Running tests for 18 140s ok 1 - pg_createcluster 18 main --start >/dev/null 140s ok 2 - pg_ctlcluster 18 main stop -m i 142s ok 3 - pg_ctlcluster 18 main start 142s ok 4 - psql -c '' 142s ok 5 - pg_ctlcluster 18 main stop -m i 142s ok 6 - create write-protected file in data directory 145s ok 7 - pg_ctlcluster 18 main start 145s ok 8 - psql -c '' 145s ok 9 - pg_dropcluster removes cluster 145s # Cleanup 145s ok 10 - Cleanup: No clusters left behind 145s ok 11 - No postgres processes left behind 145s ok 12 - No files in /etc/postgresql left behind 145s ok 13 - No files in /var/lib/postgresql left behind 145s ok 14 - No files in /var/run/postgresql left behind 145s ok 15 - No files in /var/log/postgresql left behind 145s ok 16 - PostgreSQL TCP ports are closed 145s ok 17 - Next free port is 5432 145s ### End test 022_recovery.t ### 145s 145s ### PostgreSQL test 025_logging.t ### 146s 1..55 146s # Logging to /var/log/syslog works 146s # Running tests for 18 149s ok 1 - pg_createcluster 18 main 149s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-18-main.log 149s ok 3 - psql -qc "'foobar_18_8564'" 149s ok 4 - log an error 149s ok 5 - grep --binary-files=text foobar_18_8564 /var/log/postgresql/postgresql-18-main.log 149s ok 6 - error appears in logfile 149s ok 7 - pg_conftool 18 main set log_destination syslog 149s ok 8 - set log_destination syslog 149s ok 9 - pg_ctlcluster 18 main reload 149s ok 10 - 18 main reload 149s ok 11 - psql -Atc "show log_destination" 149s ok 12 - log_destination is syslog 149s ok 13 - pg_lscluster reports syslog 150s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 150s ok 15 - error appears in /var/log/syslog 150s ok 16 - pg_conftool 18 main set logging_collector on 150s ok 17 - set logging_collector on 150s ok 18 - pg_conftool 18 main set log_destination csvlog 150s ok 19 - set log_destination csvlog 152s ok 20 - pg_ctlcluster 18 main restart 152s ok 21 - 18 main restart 152s ok 22 - psql -Atc "show logging_collector" 152s ok 23 - logging_collector is on 152s ok 24 - psql -Atc "show log_destination" 152s ok 25 - log_destination is csvlog 152s ok 26 - pg_lscluster reports csvlog 152s ok 27 - psql -qc "'barbaz_18_8564'" 152s ok 28 - log an error 153s ok 29 - grep --binary-files=text barbaz_18_8564 /var/lib/postgresql/18/main/log/*.csv 153s ok 30 - error appears in log/*.csv 153s ok 31 - pg_conftool 18 main set log_destination stderr,syslog,csvlog 153s ok 32 - set log_destination stderr,syslog,csvlog 153s ok 33 - pg_ctlcluster 18 main reload 153s ok 34 - 18 main reload 153s ok 35 - psql -Atc "show log_destination" 153s ok 36 - log_destination is stderr,syslog,csvlog 153s ok 37 - pg_lscluster reports stderr,syslog,csvlog 153s ok 38 - psql -qc "'moo_18_8564'" 153s ok 39 - log an error 154s ok 40 - grep --binary-files=text moo_18_8564 /var/lib/postgresql/18/main/log/*.log 154s ok 41 - error appears in log/*.log 154s ok 42 - grep --binary-files=text 'postgres.*moo_18_8564' /var/log/syslog 154s ok 43 - error appears in /var/log/syslog 154s ok 44 - grep --binary-files=text moo_18_8564 /var/lib/postgresql/18/main/log/*.csv 154s ok 45 - error appears in log/*.csv 155s ok 46 - pg_dropcluster 18 main --stop 155s ok 47 - pg_dropcluster removes cluster 155s # Cleanup 155s ok 48 - Cleanup: No clusters left behind 155s ok 49 - No postgres processes left behind 155s ok 50 - No files in /etc/postgresql left behind 155s ok 51 - No files in /var/lib/postgresql left behind 155s ok 52 - No files in /var/run/postgresql left behind 155s ok 53 - No files in /var/log/postgresql left behind 155s ok 54 - PostgreSQL TCP ports are closed 155s ok 55 - Next free port is 5432 155s ### End test 025_logging.t ### 155s 155s ### PostgreSQL test 027_jit.t ### 155s # 18 158s ok 1 - pg_createcluster 18 main --start 158s ok 2 - psql -Xatc 'show jit' 158s ok 3 - JIT is on by default 158s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 158s ok 5 - No JIT on cheap query 158s ok 6 - pg_conftool 18 main set seq_page_cost 100000 158s ok 7 - pg_conftool 18 main set random_page_cost 100000 158s ok 8 - pg_ctlcluster 18 main reload 158s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 158s ok 10 - Expensive query is JITed 159s ok 11 - pg_dropcluster --stop 18 main 159s # Cleanup 159s ok 12 - Cleanup: No clusters left behind 159s ok 13 - No postgres processes left behind 159s ok 14 - No files in /etc/postgresql left behind 159s ok 15 - No files in /var/lib/postgresql left behind 159s ok 16 - No files in /var/run/postgresql left behind 159s ok 17 - No files in /var/log/postgresql left behind 159s ok 18 - PostgreSQL TCP ports are closed 159s ok 19 - Next free port is 5432 159s 1..19 159s ### End test 027_jit.t ### 159s 159s ### PostgreSQL test 030_errors.t ### 159s 1..156 159s ok 1 - pg_lscluster reports cluster without binaries 160s ok 2 - pg_dropcluster 6.3 main 160s ok 3 - pg_createcluster --socketdir 160s ok 4 - pg_lsclusters -h 160s ok 5 - cluster was created 160s ok 6 - Port of created cluster is 5432 160s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 18 main 160s ok 8 - pg_createcluster on existing cluster 160s ok 9 - pg_lsclusters -h 160s ok 10 - original cluster still exists 160s ok 11 - pg_createcluster 18 test -p foo 160s ok 12 - pg_createcluster -p checks that port option is numeric 160s ok 13 - pg_createcluster 18 test -p 42 160s ok 14 - pg_createcluster -p checks valid port range 160s ok 15 - pg_ctlcluster 18 main start 160s ok 16 - pg_ctlcluster refuses to start root-owned cluster 160s ok 17 - pg_ctlcluster 18 main start 160s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 161s ok 19 - pg_ctlcluster 18 main start 161s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 161s ok 21 - pg_ctlcluster 18 main start 161s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 163s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 163s ok 24 - No sockets in /var/run/postgresql 163s ok 25 - Socket is in /tmp/postgresql-testsuite/ 163s ok 26 - cluster stops with custom unix_socket_dir 163s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 165s ok 28 - cluster starts after removing unix_socket_dir 165s ok 29 - Socket is in default dir /var/run/postgresql 165s ok 30 - No sockets in /tmp/postgresql-testsuite/ 165s ok 31 - pg_ctlcluster 18 main stop 165s ok 32 - pg_ctlcluster fails with corrupted PID file 165s ok 33 - pg_lsclusters -h 165s ok 34 - cluster is still online 165s ok 35 - pg_ctlcluster succeeds with restored PID file 165s ok 36 - pg_lsclusters -h 165s ok 37 - cluster is down 165s ok 38 - pg_ctlcluster 18 main stop 165s ok 39 - pg_ctlcluster stop fails on stopped cluster 168s ok 40 - pg_ctlcluster 18 main start 168s ok 41 - pg_ctlcluster succeeds with already existing PID file 168s ok 42 - pg_lsclusters -h 168s ok 43 - cluster is online 168s ok 44 - pg_ctlcluster stop succeeds 168s ok 45 - pg_lsclusters -h 168s ok 46 - cluster is down 168s ok 47 - no pid file left 168s ok 48 - pg_ctlcluster 18 main stop 168s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 168s ok 50 - pid file was cleaned up 168s ok 51 - pg_ctlcluster --force 18 main stop 168s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 168s ok 53 - pid file was cleaned up 168s ok 54 - pg_ctlcluster 18 main stop 168s ok 55 - pg_ctlcluster stop succeeds with stale PID file 168s ok 56 - pid file was cleaned up 168s ok 57 - pg_ctlcluster --force 18 main stop 168s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 168s ok 59 - pid file was cleaned up 168s ok 60 - pg_ctlcluster --force 18 main stop 168s ok 61 - pg_ctlcluster stop succeeds with empty PID file 168s ok 62 - pid file was cleaned up 170s ok 63 - pg_ctlcluster 18 main start 170s ok 64 - pg_ctlcluster succeeds with corrupted PID file 170s ok 65 - pg_lsclusters -h 170s ok 66 - cluster is online 170s ok 67 - pg_ctlcluster 18 main start 170s ok 68 - pg_ctlcluster start fails on running cluster 170s ok 69 - pg_ctlcluster stop 170s ok 70 - pg_ctlcluster 18 main start 170s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 170s ok 72 - pg_ctlcluster 18 main stop 170s ok 73 - stopping cluster 177s ok 74 - pg_ctlcluster 18 main start 177s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 177s ok 76 - pg_ctlcluster 18 main stop 177s ok 77 - stopping cluster 177s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 177s ok 79 - pg_dropcluster 18 main 177s ok 80 - pg_dropcluster works as user postgres 177s ok 81 - pg_createcluster succeeds 177s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 177s ok 83 - proper error message for nonexisting /var/lib/postgresql 180s ok 84 - pg_ctlcluster 18 main start 180s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 180s ok 86 - pg_ctlcluster 18 main stop 180s ok 87 - stopping cluster 180s ok 88 - pg_createcluster other 182s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 185s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 185s ok 91 185s ok 92 - pg_ctlcluster 18 other start 185s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 185s ok 94 - pg_ctlcluster 18 main stop 185s ok 95 - stopping main cluster 187s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 188s ok 97 - pg_dropcluster other 189s ok 98 - pg_dropcluster 189s ok 99 - No sockets any more 189s ok 100 - 'pg_lsclusters 4.5 foo' fails 189s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 189s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 189s ok 103 - 'psql --cluster 4.5/foo' fails 189s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 189s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 189s ok 106 - 'psql --cluster 18/foo' fails 189s ok 107 - psql --cluster 18/foo gives error message about nonexisting cluster 189s ok 108 - psql --cluster 18/foo does not print 'invalid symbolic link' gibberish 189s ok 109 - 'pg_dropcluster 4.5 foo' fails 189s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 189s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 189s ok 112 - 'pg_dropcluster 18 foo' fails 189s ok 113 - pg_dropcluster 18 foo gives error message about nonexisting cluster 189s ok 114 - pg_dropcluster 18 foo does not print 'invalid symbolic link' gibberish 189s ok 115 - 'pg_upgradecluster 4.5 foo' fails 189s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 189s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 189s ok 118 - 'pg_upgradecluster 18 foo' fails 189s ok 119 - pg_upgradecluster 18 foo gives error message about nonexisting cluster 189s ok 120 - pg_upgradecluster 18 foo does not print 'invalid symbolic link' gibberish 189s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 189s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 189s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 189s ok 124 - 'pg_ctlcluster 18 foo stop' fails 189s ok 125 - pg_ctlcluster 18 foo stop gives error message about nonexisting cluster 189s ok 126 - pg_ctlcluster 18 foo stop does not print 'invalid symbolic link' gibberish 189s # Cleanup 189s ok 127 - Cleanup: No clusters left behind 189s ok 128 - No postgres processes left behind 189s ok 129 - No files in /etc/postgresql left behind 189s ok 130 - No files in /var/lib/postgresql left behind 189s ok 131 - No files in /var/run/postgresql left behind 189s ok 132 - No files in /var/log/postgresql left behind 189s ok 133 - PostgreSQL TCP ports are closed 189s ok 134 - Next free port is 5432 190s ok 135 - pg_dropcluster 18 broken 190s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 190s # Cleanup 190s ok 137 - Cleanup: No clusters left behind 190s ok 138 - No postgres processes left behind 190s ok 139 - No files in /etc/postgresql left behind 190s ok 140 - No files in /var/lib/postgresql left behind 190s ok 141 - No files in /var/run/postgresql left behind 190s ok 142 - No files in /var/log/postgresql left behind 190s ok 143 - PostgreSQL TCP ports are closed 190s ok 144 - Next free port is 5432 191s ok 145 - pg_dropcluster 18 broken 191s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 191s ok 147 - /etc/postgresql/18 was removed 191s ok 148 - /var/lib/postgresql/18 was removed 191s # Cleanup 191s ok 149 - Cleanup: No clusters left behind 191s ok 150 - No postgres processes left behind 191s ok 151 - No files in /etc/postgresql left behind 191s ok 152 - No files in /var/lib/postgresql left behind 191s ok 153 - No files in /var/run/postgresql left behind 191s ok 154 - No files in /var/log/postgresql left behind 191s ok 155 - PostgreSQL TCP ports are closed 191s ok 156 - Next free port is 5432 191s ### End test 030_errors.t ### 191s 191s ### PostgreSQL test 031_errors_disk_full.t ### 191s 1..22 191s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 192s ok 1 - script failed 192s ok 2 - pg_createcluster fails due to insufficient disk space 192s ok 3 - does not leave files behind 192s # Cleanup 192s ok 4 - Cleanup: No clusters left behind 192s ok 5 - No postgres processes left behind 192s ok 6 - No files in /etc/postgresql left behind 192s ok 7 - No files in /var/lib/postgresql left behind 192s ok 8 - No files in /var/run/postgresql left behind 192s ok 9 - No files in /var/log/postgresql left behind 192s ok 10 - PostgreSQL TCP ports are closed 192s ok 11 - Next free port is 5432 192s # check disk full conditions on startup 193s ok 12 - script failed 193s ok 13 - pg_ctlcluster prints error message 193s ok 14 - log file has error message 193s # Cleanup 193s ok 15 - Cleanup: No clusters left behind 193s ok 16 - No postgres processes left behind 193s ok 17 - No files in /etc/postgresql left behind 193s ok 18 - No files in /var/lib/postgresql left behind 193s ok 19 - No files in /var/run/postgresql left behind 193s ok 20 - No files in /var/log/postgresql left behind 193s ok 21 - PostgreSQL TCP ports are closed 193s ok 22 - Next free port is 5432 193s ### End test 031_errors_disk_full.t ### 193s 193s ### PostgreSQL test 032_ssl_key_permissions.t ### 193s 1..22 193s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 193s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 193s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 194s ok 4 - pg_createcluster 18 main 194s ok 5 - pg_ctlcluster 18 main start 194s ok 6 - ssl key owned by nobody refused 194s ok 7 - pg_ctlcluster 18 main start 194s ok 8 - ssl key with permissions root:root 0644 refused 194s ok 9 - pg_ctlcluster 18 main start 194s ok 10 - ssl key with permissions postgres:postgres 0640 refused 195s ok 11 - pg_dropcluster 18 main --stop 195s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 195s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 195s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 195s # Cleanup 195s ok 15 - Cleanup: No clusters left behind 195s ok 16 - No postgres processes left behind 195s ok 17 - No files in /etc/postgresql left behind 195s ok 18 - No files in /var/lib/postgresql left behind 195s ok 19 - No files in /var/run/postgresql left behind 195s ok 20 - No files in /var/log/postgresql left behind 195s ok 21 - PostgreSQL TCP ports are closed 195s ok 22 - Next free port is 5432 195s ### End test 032_ssl_key_permissions.t ### 195s 195s ### PostgreSQL test 040_upgrade.t ### 195s 1..1 195s ok 1 - only one major version installed, skipping upgrade tests 195s ### End test 040_upgrade.t ### 195s 195s ### PostgreSQL test 041_upgrade_custompaths.t ### 195s 1..1 195s ok 1 - only one major version installed, skipping upgrade tests 195s ### End test 041_upgrade_custompaths.t ### 195s 195s ### PostgreSQL test 042_upgrade_rename.t ### 195s 1..15 195s # PostgreSQL 18 198s ok 1 - pg_createcluster 18 main --start 203s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/18/bin -v 18 --rename upgr 18 main 203s ok 3 - pg_lsclusters -h 203s ok 4 - correct output of pg_lsclusters -h 203s ok 5 - pg_dropcluster 18 main --stop 204s ok 6 - pg_dropcluster 18 upgr --stop 204s ok 7 - Cleaning pg_upgrade log files 204s # Cleanup 205s ok 8 - Cleanup: No clusters left behind 205s ok 9 - No postgres processes left behind 205s ok 10 - No files in /etc/postgresql left behind 205s ok 11 - No files in /var/lib/postgresql left behind 205s ok 12 - No files in /var/run/postgresql left behind 205s ok 13 - No files in /var/log/postgresql left behind 205s ok 14 - PostgreSQL TCP ports are closed 205s ok 15 - Next free port is 5432 205s ### End test 042_upgrade_rename.t ### 205s 205s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 205s 1..1 205s ok 1 - only one major version installed, skipping upgrade tests 205s ### End test 043_upgrade_ssl_cert.t ### 205s 205s ### PostgreSQL test 045_backup.t ### 205s # We are running systemd 205s # PostgreSQL 18 205s # create cluster 207s ok 1 - pg_createcluster --locale en_US.UTF-8 18 main --start 207s ok 2 - pg_lsclusters -h 207s ok 3 - correct output of pg_lsclusters -h 207s ok 4 - pg_conftool 18 main set work_mem 11MB 207s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 208s ok 6 - psql -c 'alter database mydb set search_path=public' 208s ok 7 - psql -c 'create table foo (t text)' mydb 208s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 208s ok 9 - psql -c 'CREATE USER myuser' 208s ok 10 - psql -c 'grant create on database mydb to myuser' 208s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 208s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 208s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 208s # create directory 208s ok 14 - pg_backupcluster 18 main createdirectory 208s ok 15 - /var/backups/postgresql/18-main owned by uid postgres 208s ok 16 - /var/backups/postgresql/18-main owned by gid postgres 208s # dump 208s ok 17 - systemctl start pg_dump@18-main 208s ok 18 - dump created in /var/backups/postgresql/18-main/2025-11-04T073651Z.dump 208s ok 19 - /var/backups/postgresql/18-main/2025-11-04T073651Z.dump owned by uid postgres 208s ok 20 - /var/backups/postgresql/18-main/2025-11-04T073651Z.dump owned by gid postgres 208s # basebackup 208s ok 21 - systemctl start pg_receivewal@18-main 208s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 209s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [000000010000000000000002.gz.partial] 209s not ok 23 - /var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 209s # Failed test '/var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial' 209s # at t/TestLib.pm line 171. 209s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 209s ok 25 - psql -c 'select pg_reload_conf()' 236s ok 26 - systemctl start pg_basebackup@18-main 236s ok 27 - dump created in /var/backups/postgresql/18-main/2025-11-04T073652Z.backup 236s ok 28 - /var/backups/postgresql/18-main/2025-11-04T073652Z.backup owned by uid postgres 236s ok 29 - /var/backups/postgresql/18-main/2025-11-04T073652Z.backup owned by gid postgres 236s # list 236s ok 30 - pg_backupcluster 18 main list 236s ok 31 - correct output of pg_backupcluster 18 main list 236s # more database changes 236s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 236s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 236s ok 34 - retrieve recovery timestamp 236s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 237s ok 36 - systemctl stop pg_receivewal@18-main 237s # restore /var/backups/postgresql/18-main/2025-11-04T073651Z.dump 238s ok 37 - pg_dropcluster 18 main --stop 241s ok 38 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-04T073651Z.dump --start --datadir /var/lib/postgresql/18/snowflake 241s ok 39 - pg_lsclusters -h 241s ok 40 - correct output of pg_lsclusters -h 241s ok 41 - psql -XAtl 241s ok 42 - mydb locales 241s ok 43 - mydb grants 241s ok 44 - myicudb locales 241s ok 45 - psql -XAtc 'show work_mem' 241s ok 46 - correct output of psql -XAtc 'show work_mem' 241s ok 47 - psql -XAtc 'select * from foo' mydb 241s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 241s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 241s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 241s ok 51 - psql -XAtc '\drds' 241s ok 52 - correct output of psql -XAtc '\drds' 241s # restore /var/backups/postgresql/18-main/2025-11-04T073652Z.backup 242s ok 53 - pg_dropcluster 18 main --stop 245s ok 54 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-04T073652Z.backup --start --datadir /var/lib/postgresql/18/snowflake 245s ok 55 - pg_lsclusters -h 245s ok 56 - correct output of pg_lsclusters -h 245s ok 57 - psql -XAtl 245s ok 58 - mydb locales 245s ok 59 - mydb grants 245s ok 60 - myicudb locales 245s ok 61 - psql -XAtc 'show work_mem' 245s ok 62 - correct output of psql -XAtc 'show work_mem' 245s ok 63 - psql -XAtc 'select * from foo' mydb 245s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 245s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 245s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 245s ok 67 - psql -XAtc '\drds' 245s ok 68 - correct output of psql -XAtc '\drds' 245s # restore /var/backups/postgresql/18-main/2025-11-04T073652Z.backup with WAL archive 246s ok 69 - pg_dropcluster 18 main --stop 249s ok 70 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-04T073652Z.backup --start --archive --port 5430 249s ok 71 - pg_lsclusters -h 249s ok 72 - correct output of pg_lsclusters -h 249s ok 73 - psql -XAtc 'select * from foo order by t' mydb 249s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 249s # restore /var/backups/postgresql/18-main/2025-11-04T073652Z.backup with PITR 250s ok 75 - pg_dropcluster 18 main --stop 253s ok 76 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-04T073652Z.backup --start --pitr '2025-11-04 07:37:19.826038+00 253s # ' 253s ok 77 - pg_lsclusters -h 253s ok 78 - correct output of pg_lsclusters -h 253s ok 79 - psql -XAtc 'select * from foo order by t' mydb 253s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 254s ok 81 - pg_dropcluster 18 main --stop 254s # Cleanup 254s ok 82 - Cleanup: No clusters left behind 254s ok 83 - No postgres processes left behind 254s ok 84 - No files in /etc/postgresql left behind 254s ok 85 - No files in /var/lib/postgresql left behind 254s ok 86 - No files in /var/run/postgresql left behind 254s ok 87 - No files in /var/log/postgresql left behind 254s ok 88 - PostgreSQL TCP ports are closed 254s ok 89 - Next free port is 5432 254s 1..89 254s ### End test 045_backup.t ### 254s 254s ### PostgreSQL test 050_encodings.t ### 255s 1..60 255s # Checking 18 ru_RU 257s ok 1 - pg_createcluster version 18 for ru_RU without --encoding succeeded 258s ok 2 - psql -l succeeds 258s ok 3 - template1 is not UTF-8 encoded 258s ok 4 - creating test database 258s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 258s # create table t (x varchar); copy t from stdin" test 258s ok 6 - creating table with ISO-8859-5 characters 258s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 258s ok 8 - correct string in UTF-8 258s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 258s ok 10 - correct string in ISO-8859-5 258s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 258s # delete from t; copy t from stdin" test 258s ok 12 - creating table with UTF-8 characters 259s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 259s ok 14 - correct string in UTF-8 259s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 259s ok 16 - correct string in ISO-8859-1 259s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 259s ok 18 - Server error message has correct language and encoding 261s ok 19 - pg_ctlcluster 18 ru_RU restart 261s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 262s ok 21 - Dropping cluster 262s # Checking 18 ru_RU.UTF-8 265s ok 22 - pg_createcluster version 18 for ru_RU.UTF-8 without --encoding succeeded 266s ok 23 - psql -l succeeds 266s ok 24 - template1 is UTF-8 encoded 266s ok 25 - creating test database 266s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 266s # create table t (x varchar); copy t from stdin" test 266s ok 27 - creating table with ISO-8859-5 characters 266s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 266s ok 29 - correct string in UTF-8 266s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 266s ok 31 - correct string in ISO-8859-5 266s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 266s # delete from t; copy t from stdin" test 266s ok 33 - creating table with UTF-8 characters 266s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 266s ok 35 - correct string in UTF-8 266s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 266s ok 37 - correct string in ISO-8859-1 266s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 266s ok 39 - Server error message has correct language and encoding 268s ok 40 - pg_ctlcluster 18 ru_RU.UTF8 restart 268s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 268s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 268s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 268s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 268s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 268s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 268s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 269s ok 48 - Dropping cluster 269s # Check 18 locale environment variables 272s ok 49 - pg_createcluster: LC_ALL dominates LANG 272s ok 50 - psql -Atl --cluster 18/main 272s ok 51 - template1 is ASCII encoded 273s ok 52 - Dropping cluster 273s # Cleanup 273s ok 53 - Cleanup: No clusters left behind 273s ok 54 - No postgres processes left behind 273s ok 55 - No files in /etc/postgresql left behind 273s ok 56 - No files in /var/lib/postgresql left behind 273s ok 57 - No files in /var/run/postgresql left behind 273s ok 58 - No files in /var/log/postgresql left behind 273s ok 59 - PostgreSQL TCP ports are closed 273s ok 60 - Next free port is 5432 273s ### End test 050_encodings.t ### 273s 273s ### PostgreSQL test 052_upgrade_encodings.t ### 273s 1..1 273s ok 1 - only one major version installed, skipping upgrade tests 273s ### End test 052_upgrade_encodings.t ### 273s 273s ### PostgreSQL test 060_obsolete_confparams.t ### 273s ok 1 - only one major version installed, skipping upgrade tests 273s 1..1 273s ### End test 060_obsolete_confparams.t ### 273s 273s ### PostgreSQL test 070_non_postgres_clusters.t ### 273s 1..40 274s ok 1 - pg_createcluster 18 main for owner nobody 274s ok 2 - pg_ctlcluster 18 main start 274s ok 3 - start refused when config and data owners mismatch 276s ok 4 - pg_ctlcluster succeeds with owner nobody 276s ok 5 - pg_lsclusters -h 276s ok 6 - pg_lsclusters shows running cluster 276s ok 7 - postgres is running as user nobody 276s ok 8 - ls /tmp/.s.PGSQL.* 276s ok 9 - socket is in /tmp 276s ok 10 - /var/run/postgresql is empty 276s ok 11 - conf dir is owned by user 276s ok 12 - conf dir is owned by user's primary group 276s ok 13 - files are owned by user 276s ok 14 - files are owned by user's primary group 276s ok 15 - log file has 0640 permissions 276s ok 16 - log file is owned by user 276s ok 17 - log file is owned by user's primary group 276s ok 18 - only one major version installed, skipping upgrade test 276s ok 19 - ... 276s ok 20 - ... 276s ok 21 - ... 276s ok 22 - ... 276s ok 23 - ... 276s ok 24 - ... 276s ok 25 - ... 276s ok 26 - ... 276s ok 27 - ... 276s ok 28 - ... 277s ok 29 - pg_dropcluster 277s ok 30 - pg_lsclusters -h 277s ok 31 - No clusters left 277s ok 32 - No postgres processes left 277s # Cleanup 277s ok 33 - Cleanup: No clusters left behind 277s ok 34 - No postgres processes left behind 277s ok 35 - No files in /etc/postgresql left behind 277s ok 36 - No files in /var/lib/postgresql left behind 277s ok 37 - No files in /var/run/postgresql left behind 277s ok 38 - No files in /var/log/postgresql left behind 277s ok 39 - PostgreSQL TCP ports are closed 277s ok 40 - Next free port is 5432 277s ### End test 070_non_postgres_clusters.t ### 277s 277s ### PostgreSQL test 080_start.conf.t ### 277s 1..73 278s ok 1 - pg_createcluster 18 main 278s # start.conf auto 278s ok 2 - get_cluster_start_conf returns auto 278s ok 3 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 278s ok 4 - start.conf contains auto 278s ok 5 - systemd generator links cluster 278s ok 6 - systemd generator links correct service file 280s ok 7 - /etc/init.d/postgresql start 18 280s ok 8 - correct output of /etc/init.d/postgresql start 18 280s ok 9 - pg_lsclusters -h 280s ok 10 - cluster is online 280s ok 11 - /etc/init.d/postgresql stop 18 280s ok 12 - correct output of /etc/init.d/postgresql stop 18 283s ok 13 - pg_lsclusters -h 283s ok 14 - cluster is down 283s # start.conf manual 283s ok 15 - get_cluster_start_conf returns manual 283s ok 16 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 283s ok 17 - start.conf contains manual 283s ok 18 - systemd generator doesn't link cluster 283s ok 19 - /etc/init.d/postgresql start 18 283s ok 20 - correct output of /etc/init.d/postgresql start 18 283s ok 21 - pg_lsclusters -h 283s ok 22 - cluster is down 285s ok 23 - pg_ctlcluster 18 main start 285s ok 24 - correct output of pg_ctlcluster 18 main start 285s ok 25 - pg_lsclusters -h 285s ok 26 - cluster is online 286s ok 27 - pg_ctlcluster 18 main stop 286s ok 28 - correct output of pg_ctlcluster 18 main stop 286s ok 29 - pg_lsclusters -h 286s ok 30 - cluster is down 286s # start.conf disabled 286s ok 31 - get_cluster_start_conf returns disabled 286s ok 32 - systemd generator doesn't link cluster 286s ok 33 - /etc/init.d/postgresql start 18 286s ok 34 - correct output of /etc/init.d/postgresql start 18 286s ok 35 - pg_lsclusters -h 286s ok 36 - cluster is down 286s ok 37 - pg_ctlcluster 18 main start 286s ok 38 - correct output of pg_ctlcluster 18 main start 286s ok 39 - pg_lsclusters -h 286s ok 40 - cluster is down 288s ok 41 - pg_ctlcluster 18 main start 288s ok 42 - correct output of pg_ctlcluster 18 main start 288s ok 43 - pg_lsclusters -h 288s ok 44 - cluster is online 288s ok 45 - pg_ctlcluster 18 main stop 288s ok 46 - correct output of pg_ctlcluster 18 main stop 288s ok 47 - pg_lsclusters -h 288s ok 48 - cluster is down 290s ok 49 - pg_ctlcluster 18 main start 290s ok 50 - correct output of pg_ctlcluster 18 main start 290s ok 51 - pg_lsclusters -h 290s ok 52 - cluster is online 290s # test upgrade 290s ok 53 - only one major version installed, skipping upgrade test 290s ok 54 - ... 290s ok 55 - get_cluster_start_conf for old cluster returns manual 290s ok 56 - get_cluster_start_conf for new cluster returns manual 290s ok 57 - ... 291s ok 58 - dropping upgraded cluster 291s ok 59 - pg_lsclusters -h 291s ok 60 - no clusters any more 291s ok 61 - pg_createcluster 18 main --start-conf foo 291s ok 62 - pg_createcluster checks --start-conf validity 292s ok 63 - pg_createcluster checks --start-conf manual 292s ok 64 - get_cluster_start_conf returns manual 292s ok 65 - dropping cluster 292s # Cleanup 292s ok 66 - Cleanup: No clusters left behind 292s ok 67 - No postgres processes left behind 292s ok 68 - No files in /etc/postgresql left behind 292s ok 69 - No files in /var/lib/postgresql left behind 292s ok 70 - No files in /var/run/postgresql left behind 292s ok 71 - No files in /var/log/postgresql left behind 292s ok 72 - PostgreSQL TCP ports are closed 292s ok 73 - Next free port is 5432 292s ### End test 080_start.conf.t ### 292s 292s ### PostgreSQL test 085_pg_ctl.conf.t ### 293s 1..33 293s ok 1 - prlimit --core=0:unlimited --pid=17351 293s ok 2 - set core file size to unlimited 293s ok 3 - sh -c 'ulimit -Hc' 293s ok 4 - core file size is unlimited 293s ok 5 - pg_createcluster 18 main 293s ok 6 - /etc/postgresql/18/main/pg_ctl.conf exists 295s ok 7 - pg_ctlcluster 18 main start 295s ok 8 - starting cluster as root 295s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 295s ok 10 - soft core size is 0 295s # hard core file size limit of root-started postgres process is unlimited 295s ok 11 - set pg_ctl default option to -c 298s ok 12 - pg_ctlcluster 18 main restart 298s ok 13 - restarting cluster as root 298s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 298s ok 15 - soft core size is unlimited 298s ok 16 - pg_ctlcluster 18 main stop 298s ok 17 - stopping cluster 298s ok 18 - restored pg_ctl default option 300s ok 19 - pg_ctlcluster 18 main start -- -c 300s ok 20 - starting cluster with -c on the command line as postgres 300s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 300s ok 22 - soft core size is unlimited 300s ok 23 - pg_ctlcluster 18 main stop 300s ok 24 - stopping cluster 301s ok 25 - dropping cluster 301s # Cleanup 301s ok 26 - Cleanup: No clusters left behind 301s ok 27 - No postgres processes left behind 301s ok 28 - No files in /etc/postgresql left behind 301s ok 29 - No files in /var/lib/postgresql left behind 301s ok 30 - No files in /var/run/postgresql left behind 301s ok 31 - No files in /var/log/postgresql left behind 301s ok 32 - PostgreSQL TCP ports are closed 301s ok 33 - Next free port is 5432 301s ### End test 085_pg_ctl.conf.t ### 301s 301s ### PostgreSQL test 090_multicluster.t ### 301s 1..125 302s ok 1 - pg_createcluster 18 old 302s ok 2 - pg_createcluster 18 new1 303s ok 3 - pg_createcluster 18 new2 305s ok 4 - starting cluster 18/old 307s ok 5 - starting cluster 18/new1 309s ok 6 - starting cluster 18/new2 309s ok 7 - pg_lsclusters -h | sort -k3 309s ok 8 - clusters have the correct ports, skipping used 5433 309s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 309s ok 10 - createdb --version 309s ok 11 - pg_wrapper selects port 5432 as default cluster 309s ok 12 - createdb --cluster 18/new1 --version 309s ok 13 - pg_wrapper --cluster works 309s ok 14 - createdb --cluster 18/foo --version 309s ok 15 - pg_wrapper --cluster errors out for invalid cluster 309s ok 16 - createdb --cluster 18/new1 test 309s ok 17 - correct output of createdb --cluster 18/new1 test 309s ok 18 - psql -Atl --cluster 18/new1 309s ok 19 - test db appears in cluster new1 310s ok 20 - psql -Atl --cluster 18/new2 310s ok 21 - test db does not appear in cluster new2 310s ok 22 - psql -Atl 310s ok 23 - test db does not appear in default cluster 310s ok 24 - psql --cluster 18/127.0.0.1: -Atc 'show port' template1 310s ok 25 - psql --cluster 18/127.0.0.1: defaults to port 5432 310s ok 26 - createdb --cluster 18/127.0.0.1:5432 --version 310s ok 27 - createdb --cluster 18/127.0.0.1:5432 uses latest client version 310s ok 28 - psql -Atl --cluster 18/localhost:5434 310s ok 29 - test db appears in cluster 18/localhost:5434 310s ok 30 - psql -Atl --cluster 18/localhost:5440 310s ok 31 - test db does not appear in cluster 18/localhost:5440 310s ok 32 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:5435 310s ok 33 - psql --cluster 18/localhost:5435 fails due to nonexisting port 310s ok 34 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:a 310s ok 35 - psql --cluster 18/localhost:a fails due to invalid syntax 310s ok 36 - LC_MESSAGES=C psql -Atl --cluster 18/doesnotexi.st 310s ok 37 - psql --cluster 18/doesnotexi.st fails due to invalid syntax 310s ok 38 - psql -Atl --cluster 6.4/localhost: 310s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 310s ok 40 - psql -Atl 310s ok 41 - PGCLUSTER selection (1) 310s ok 42 - psql -Atl 310s ok 43 - PGCLUSTER selection (2) 310s ok 44 - psql -l 310s ok 45 - invalid PGCLUSTER value 310s ok 46 - createdb --version 310s ok 47 - PGCLUSTER network cluster selection (1) 310s ok 48 - psql -Atl 310s ok 49 - PGCLUSTER network cluster selection (2) 310s ok 50 - psql -Atl 310s ok 51 - PGCLUSTER network cluster selection (3) 310s ok 52 - LC_MESSAGES=C psql -Atl 310s ok 53 - psql --cluster 18/localhost:5435 fails due to nonexisting port 310s ok 54 - psql -Atc "show port" template1 310s ok 55 - PGPORT selection (1) 310s ok 56 - psql -Atc "show port" template1 310s ok 57 - PGPORT selection (2) 310s ok 58 - createdb --version 310s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 310s ok 60 - psql -Atc "show port" template1 310s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 310s ok 62 - psql --cluster 18/new1 -Atc 'select current_database()' 310s ok 63 - PGDATABASE environment variable works 310s ok 64 - createdb --version 310s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 310s ok 66 - createdb --cluster 18/new1 --version 310s ok 67 - pg_wrapper --cluster works with empty user_clusters 310s ok 68 - createdb --version 310s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 18 new1 *' 310s ok 70 - psql -Atc "select current_database()" 310s ok 71 - pg_wrapper selects correct database with user_clusters '* * 18 new1 test' 310s ok 72 - psql -Atc 'select current_database()' 310s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 310s ok 74 - createdb --version 310s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 310s ok 76 - createdb --version 310s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 310s ok 78 - createdb --version 310s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 310s ok 80 - createdb --version 310s ok 81 - pg_wrapper selects correct version with per-user user_clusters 310s ok 82 - createdb --version 310s ok 83 - pg_wrapper selects correct version with per-user user_clusters 310s ok 84 - createdb --version 310s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 310s ok 86 - psql -Atl 310s ok 87 - $PGHOST overrides user_clusters 310s ok 88 - psql --cluster 18/localhost:5434 -Atc 'select current_database()' test 310s ok 89 - --cluster overrides $PGHOST 310s ok 90 - createdb --version 310s ok 91 - pg_wrapper ignores invalid lines in user_clusters 310s ok 92 - psql -Atc 'select current_database()' 310s ok 93 - pg_service conf selection 1 310s ok 94 - psql -Atc 'select current_database()' 310s ok 95 - pg_service conf selection 2 310s ok 96 - psql -Atc 'select current_database()' 310s ok 97 - pg_service conf selection 3 311s ok 98 - stopping cluster 18/old 313s ok 99 - restarting cluster 18/old 313s ok 100 # skip rust coreutils sort -k option regression. See LP: #2125504 313s ok 101 # skip rust coreutils sort -k option regression. See LP: #2125504 313s ok 102 - psql -l 313s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 313s ok 104 - psql -Atl --cluster 18/new1 313s ok 105 - --cluster selects appropriate cluster 313s ok 106 - psql -Atl -p 5434 313s ok 107 - -p selects appropriate cluster 313s ok 108 - psql -Atlp 5434 313s ok 109 - -Atlp selects appropriate cluster 313s ok 110 - psql -Atl --port 5434 313s ok 111 - --port selects appropriate cluster 313s ok 112 - env PGPORT=5434 psql -Atl 313s ok 113 - $PGPORT selects appropriate cluster 313s ok 114 - Restoring original /etc/postgresql-common/user_clusters 314s ok 115 - dropping 18/new1 315s ok 116 - dropping 18/new2 316s ok 117 - dropping 18/old 316s # Cleanup 316s ok 118 - Cleanup: No clusters left behind 316s ok 119 - No postgres processes left behind 316s ok 120 - No files in /etc/postgresql left behind 316s ok 121 - No files in /var/lib/postgresql left behind 316s ok 122 - No files in /var/run/postgresql left behind 316s ok 123 - No files in /var/log/postgresql left behind 316s ok 124 - PostgreSQL TCP ports are closed 316s ok 125 - Next free port is 5432 316s ### End test 090_multicluster.t ### 316s 316s ### PostgreSQL test 110_integrate_cluster.t ### 316s 1..32 316s ok 1 - /usr/lib/postgresql/18/bin/initdb /tmp/V6t78wHtRX/c/postgres 316s ok 2 - creating raw initdb cluster for user postgres 317s ok 3 - pg_createcluster 18 postgres -d /tmp/V6t78wHtRX/c/postgres 317s ok 4 - integrating postgres cluster 317s ok 5 - pg_lsclusters 317s ok 6 - correct pg_lsclusters output 319s ok 7 - pg_ctlcluster 18 postgres start 319s ok 8 - starting cluster postgres 319s ok 9 - pg_lsclusters 319s ok 10 - correct pg_lsclusters output 320s ok 11 - dropping cluster postgres 320s ok 12 - No files in temporary cluster dir left behind 320s ok 13 - /usr/lib/postgresql/18/bin/initdb /tmp/V6t78wHtRX/c/nobody 320s ok 14 - creating raw initdb cluster for user nobody 321s ok 15 - pg_createcluster 18 nobody -d /tmp/V6t78wHtRX/c/nobody 321s ok 16 - integrating nobody cluster 321s ok 17 - pg_lsclusters 321s ok 18 - correct pg_lsclusters output 323s ok 19 - pg_ctlcluster 18 nobody start 323s ok 20 - starting cluster nobody 323s ok 21 - pg_lsclusters 323s ok 22 - correct pg_lsclusters output 324s ok 23 - dropping cluster nobody 324s ok 24 - No files in temporary cluster dir left behind 324s # Cleanup 324s ok 25 - Cleanup: No clusters left behind 324s ok 26 - No postgres processes left behind 324s ok 27 - No files in /etc/postgresql left behind 324s ok 28 - No files in /var/lib/postgresql left behind 324s ok 29 - No files in /var/run/postgresql left behind 324s ok 30 - No files in /var/log/postgresql left behind 324s ok 31 - PostgreSQL TCP ports are closed 324s ok 32 - Next free port is 5432 324s ### End test 110_integrate_cluster.t ### 324s 324s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 324s 1..1 324s ok 1 - only one major version installed, skipping upgrade tests 324s ### End test 120_pg_upgradecluster_scripts.t ### 324s 324s ### PostgreSQL test 130_nonroot_admin.t ### 324s 1..22 326s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 326s ok 2 - pg_lsclusters -h 326s ok 3 - correct output of pg_lsclusters -h 327s ok 4 - psql -Atl 327s ok 5 - correct output of psql -Atl 327s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 327s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 327s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 327s # Cleanup 327s ok 15 - Cleanup: No clusters left behind 327s ok 16 - No postgres processes left behind 327s ok 17 - No files in /etc/postgresql left behind 327s ok 18 - No files in /var/lib/postgresql left behind 327s ok 19 - No files in /var/run/postgresql left behind 327s ok 20 - No files in /var/log/postgresql left behind 327s ok 21 - PostgreSQL TCP ports are closed 327s ok 22 - Next free port is 5432 327s ### End test 130_nonroot_admin.t ### 327s 327s ### PostgreSQL test 135_pg_virtualenv.t ### 327s 1..20 331s ok 1 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 331s ok 2 - running pg_virtualenv as root 333s ok 3 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 333s ok 4 - running pg_virtualenv as postgres 336s ok 5 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 336s ok 6 - running pg_virtualenv as nobody 339s ok 7 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 339s ok 8 - running fakeroot pg_virtualenv as root 342s ok 9 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 342s ok 10 - running fakeroot pg_virtualenv as postgres 344s ok 11 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 344s ok 12 - running fakeroot pg_virtualenv as nobody 344s # Cleanup 344s ok 13 - Cleanup: No clusters left behind 344s ok 14 - No postgres processes left behind 344s ok 15 - No files in /etc/postgresql left behind 344s ok 16 - No files in /var/lib/postgresql left behind 344s ok 17 - No files in /var/run/postgresql left behind 344s ok 18 - No files in /var/log/postgresql left behind 344s ok 19 - PostgreSQL TCP ports are closed 344s ok 20 - Next free port is 5432 344s ### End test 135_pg_virtualenv.t ### 344s 344s ### PostgreSQL test 140_pg_config.t ### 344s 1..38 344s # Multiarch is enabled 344s # checking version specific output for 18 344s ok 1 - /usr/lib/postgresql/18/bin/pg_config --pgxs 344s ok 2 - correct output of /usr/lib/postgresql/18/bin/pg_config --pgxs 344s ok 3 - /usr/lib/postgresql/18/bin/pg_config --libdir 344s ok 4 - correct output of /usr/lib/postgresql/18/bin/pg_config --libdir 344s ok 5 - /usr/lib/postgresql/18/bin/pg_config --pkglibdir 344s ok 6 - correct output of /usr/lib/postgresql/18/bin/pg_config --pkglibdir 344s ok 7 - /usr/lib/postgresql/18/bin/pg_config --bindir 344s ok 8 - correct output of /usr/lib/postgresql/18/bin/pg_config --bindir 344s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 344s # checking pg_config output (should behave like version 18) 344s ok 15 - pg_config 344s ok 16 - correct output of pg_config 345s ok 17 - pg_config --help 345s ok 18 - correct output of pg_config --help 345s ok 19 - pg_config --pgxs 345s ok 20 - correct output of pg_config --pgxs 345s ok 21 - pg_config --libdir 345s ok 22 - correct output of pg_config --libdir 345s ok 23 - pg_config --pkglibdir 345s ok 24 - correct output of pg_config --pkglibdir 345s ok 25 - pg_config --bindir 345s ok 26 - correct output of pg_config --bindir 345s # checking pg_config.libpq-dev output (should behave like version 18) 345s ok 27 - pg_config.libpq-dev 345s ok 28 - correct output of pg_config.libpq-dev 345s ok 29 - pg_config.libpq-dev --help 345s ok 30 - correct output of pg_config.libpq-dev --help 345s ok 31 - pg_config.libpq-dev --pgxs 345s ok 32 - correct output of pg_config.libpq-dev --pgxs 345s ok 33 - pg_config.libpq-dev --libdir 345s ok 34 - correct output of pg_config.libpq-dev --libdir 345s ok 35 - pg_config.libpq-dev --pkglibdir 345s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 345s ok 37 - pg_config.libpq-dev --bindir 345s ok 38 - correct output of pg_config.libpq-dev --bindir 345s ### End test 140_pg_config.t ### 345s 345s ### PostgreSQL test 150_tsearch_stemming.t ### 345s 1..37 345s ok 1 - pg_updatedicts succeeded 345s ok 2 - pg_updatedicts created en_us.affix 345s ok 3 - pg_updatedicts created en_us.dict 345s ok 4 - pg_updatedicts created 18 en_us.affix symlink 345s ok 5 - pg_updatedicts created 18 en_us.dict symlink 347s ok 6 - pg_createcluster 18 main 347s ok 7 - createdb fts 347s ok 8 - correct output of createdb fts 348s ok 9 - creating en_US full text search configuration 348s ok 10 - creating data table and search index 348s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 348s ok 12 - stem search of correct word 348s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 348s ok 14 - stem search of correct word 348s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 348s ok 16 - stem search of unknown word 348s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 348s ok 18 - full text search, exact word 348s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 348s ok 20 - full text search for word stem 348s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 348s ok 22 - full text search for word substring fails 348s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 348s ok 24 - full text search, exact unicode word 348s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 348s ok 26 - full text search for unicode word stem 348s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 348s ok 28 - full text search for unicode word substring fails 349s ok 29 349s # Cleanup 349s ok 30 - Cleanup: No clusters left behind 349s ok 31 - No postgres processes left behind 349s ok 32 - No files in /etc/postgresql left behind 349s ok 33 - No files in /var/lib/postgresql left behind 349s ok 34 - No files in /var/run/postgresql left behind 349s ok 35 - No files in /var/log/postgresql left behind 349s ok 36 - PostgreSQL TCP ports are closed 349s ok 37 - Next free port is 5432 349s ### End test 150_tsearch_stemming.t ### 349s 349s ### PostgreSQL test 160_alternate_confroot.t ### 349s 1..28 352s ok 1 352s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 352s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 352s ok 4 - pg_lsclusters -h 352s ok 5 - correct output of pg_lsclusters -h 352s ok 6 - psql -Atl 352s ok 7 - correct output of psql -Atl 352s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 352s ok 9 - ... 352s ok 10 - ... 352s ok 11 - ... 352s ok 12 - ... 352s ok 13 - ... 352s ok 14 - ... 352s ok 15 - pg_dropcluster 18 test --stop 352s ok 16 - correct output of pg_dropcluster 18 test --stop 352s ok 17 - pg_lsclusters -h 352s ok 18 - correct output of pg_lsclusters -h 352s ok 19 - No files in root/data left behind 352s ok 20 - No cruft in root dir left behind 352s # Cleanup 352s ok 21 - Cleanup: No clusters left behind 352s ok 22 - No postgres processes left behind 352s ok 23 - No files in /etc/postgresql left behind 352s ok 24 - No files in /var/lib/postgresql left behind 352s ok 25 - No files in /var/run/postgresql left behind 352s ok 26 - No files in /var/log/postgresql left behind 352s ok 27 - PostgreSQL TCP ports are closed 352s ok 28 - Next free port is 5432 352s ### End test 160_alternate_confroot.t ### 352s 352s ### PostgreSQL test 170_extensions.t ### 352s # Running tests for 18 355s ok 1 - pg_createcluster 18 main 355s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 355s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 355s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 355s ok 5 - extension amcheck installs without error 355s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 355s ok 7 - extension amcheck removes without error 355s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 355s ok 9 - extension autoinc installs without error 355s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 355s ok 11 - extension autoinc removes without error 355s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 355s ok 13 - extension bloom installs without error 355s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 355s ok 15 - extension bloom removes without error 355s ok 16 - psql -qc 'CREATE EXTENSION plperl' 355s ok 17 - bool_plperl dependency plperl installs without error 355s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 355s ok 19 - extension bool_plperl installs without error 355s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 355s ok 21 - extension bool_plperl removes without error 355s ok 22 - psql -qc 'DROP EXTENSION plperl' 355s ok 23 - bool_plperl dependency extension plperl removes without error 355s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 355s ok 25 - bool_plperlu dependency plperlu installs without error 355s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 355s ok 27 - extension bool_plperlu installs without error 355s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 355s ok 29 - extension bool_plperlu removes without error 355s ok 30 - psql -qc 'DROP EXTENSION plperlu' 355s ok 31 - bool_plperlu dependency extension plperlu removes without error 355s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 355s ok 33 - extension btree_gin installs without error 355s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 355s ok 35 - extension btree_gin removes without error 355s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 355s ok 37 - extension btree_gist installs without error 355s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 355s ok 39 - extension btree_gist removes without error 355s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 355s ok 41 - extension citext installs without error 355s ok 42 - psql -qc 'DROP EXTENSION "citext"' 355s ok 43 - extension citext removes without error 355s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 355s ok 45 - extension cube installs without error 356s ok 46 - psql -qc 'DROP EXTENSION "cube"' 356s ok 47 - extension cube removes without error 356s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 356s ok 49 - extension dblink installs without error 356s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 356s ok 51 - extension dblink removes without error 356s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 356s ok 53 - extension dict_int installs without error 356s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 356s ok 55 - extension dict_int removes without error 356s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 356s ok 57 - extension dict_xsyn installs without error 356s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 356s ok 59 - extension dict_xsyn removes without error 356s ok 60 - psql -qc 'CREATE EXTENSION cube' 356s ok 61 - earthdistance dependency cube installs without error 356s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 356s ok 63 - extension earthdistance installs without error 356s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 356s ok 65 - extension earthdistance removes without error 356s ok 66 - psql -qc 'DROP EXTENSION cube' 356s ok 67 - earthdistance dependency extension cube removes without error 356s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 356s ok 69 - extension file_fdw installs without error 356s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 356s ok 71 - extension file_fdw removes without error 356s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 356s ok 73 - extension fuzzystrmatch installs without error 356s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 356s ok 75 - extension fuzzystrmatch removes without error 356s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 356s ok 77 - extension hstore installs without error 356s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 356s ok 79 - extension hstore removes without error 356s ok 80 - psql -qc 'CREATE EXTENSION hstore' 356s ok 81 - hstore_plperl dependency hstore installs without error 356s ok 82 - psql -qc 'CREATE EXTENSION plperl' 356s ok 83 - hstore_plperl dependency plperl installs without error 356s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 356s ok 85 - extension hstore_plperl installs without error 356s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 356s ok 87 - extension hstore_plperl removes without error 356s ok 88 - psql -qc 'DROP EXTENSION hstore' 356s ok 89 - hstore_plperl dependency extension hstore removes without error 356s ok 90 - psql -qc 'DROP EXTENSION plperl' 356s ok 91 - hstore_plperl dependency extension plperl removes without error 356s ok 92 - psql -qc 'CREATE EXTENSION hstore' 356s ok 93 - hstore_plperlu dependency hstore installs without error 356s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 356s ok 95 - hstore_plperlu dependency plperlu installs without error 356s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 356s ok 97 - extension hstore_plperlu installs without error 356s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 356s ok 99 - extension hstore_plperlu removes without error 356s ok 100 - psql -qc 'DROP EXTENSION hstore' 356s ok 101 - hstore_plperlu dependency extension hstore removes without error 356s ok 102 - psql -qc 'DROP EXTENSION plperlu' 356s ok 103 - hstore_plperlu dependency extension plperlu removes without error 356s ok 104 - psql -qc 'CREATE EXTENSION hstore' 356s ok 105 - hstore_plpython3u dependency hstore installs without error 356s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 356s ok 107 - hstore_plpython3u dependency plpython3u installs without error 356s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 356s ok 109 - extension hstore_plpython3u installs without error 356s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 356s ok 111 - extension hstore_plpython3u removes without error 356s ok 112 - psql -qc 'DROP EXTENSION hstore' 356s ok 113 - hstore_plpython3u dependency extension hstore removes without error 356s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 356s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 356s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 356s ok 117 - extension insert_username installs without error 357s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 357s ok 119 - extension insert_username removes without error 357s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 357s ok 121 - extension intagg installs without error 357s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 357s ok 123 - extension intagg removes without error 357s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 357s ok 125 - extension intarray installs without error 357s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 357s ok 127 - extension intarray removes without error 357s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 357s ok 129 - extension isn installs without error 357s ok 130 - psql -qc 'DROP EXTENSION "isn"' 357s ok 131 - extension isn removes without error 357s ok 132 - psql -qc 'CREATE EXTENSION plperl' 357s ok 133 - jsonb_plperl dependency plperl installs without error 357s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 357s ok 135 - extension jsonb_plperl installs without error 357s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 357s ok 137 - extension jsonb_plperl removes without error 357s ok 138 - psql -qc 'DROP EXTENSION plperl' 357s ok 139 - jsonb_plperl dependency extension plperl removes without error 357s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 357s ok 141 - jsonb_plperlu dependency plperlu installs without error 357s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 357s ok 143 - extension jsonb_plperlu installs without error 357s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 357s ok 145 - extension jsonb_plperlu removes without error 357s ok 146 - psql -qc 'DROP EXTENSION plperlu' 357s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 357s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 357s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 357s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 357s ok 151 - extension jsonb_plpython3u installs without error 357s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 357s ok 153 - extension jsonb_plpython3u removes without error 357s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 357s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 357s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 357s ok 157 - extension lo installs without error 357s ok 158 - psql -qc 'DROP EXTENSION "lo"' 357s ok 159 - extension lo removes without error 357s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 357s ok 161 - extension ltree installs without error 357s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 357s ok 163 - extension ltree removes without error 357s ok 164 - psql -qc 'CREATE EXTENSION ltree' 357s ok 165 - ltree_plpython3u dependency ltree installs without error 357s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 357s ok 167 - ltree_plpython3u dependency plpython3u installs without error 357s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 357s ok 169 - extension ltree_plpython3u installs without error 357s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 357s ok 171 - extension ltree_plpython3u removes without error 357s ok 172 - psql -qc 'DROP EXTENSION ltree' 357s ok 173 - ltree_plpython3u dependency extension ltree removes without error 357s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 357s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 357s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 357s ok 177 - extension moddatetime installs without error 357s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 357s ok 179 - extension moddatetime removes without error 357s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 357s ok 181 - extension pageinspect installs without error 357s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 357s ok 183 - extension pageinspect removes without error 357s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 357s ok 185 - extension pg_buffercache installs without error 357s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 357s ok 187 - extension pg_buffercache removes without error 358s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 358s ok 189 - extension pg_freespacemap installs without error 358s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 358s ok 191 - extension pg_freespacemap removes without error 358s ok 192 - psql -qc 'CREATE EXTENSION "pg_logicalinspect"' 358s ok 193 - extension pg_logicalinspect installs without error 358s ok 194 - psql -qc 'DROP EXTENSION "pg_logicalinspect"' 358s ok 195 - extension pg_logicalinspect removes without error 358s ok 196 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 358s ok 197 - extension pg_prewarm installs without error 358s ok 198 - psql -qc 'DROP EXTENSION "pg_prewarm"' 358s ok 199 - extension pg_prewarm removes without error 358s ok 200 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 358s ok 201 - extension pg_stat_statements installs without error 358s ok 202 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 358s ok 203 - extension pg_stat_statements removes without error 358s ok 204 - psql -qc 'CREATE EXTENSION "pg_surgery"' 358s ok 205 - extension pg_surgery installs without error 358s ok 206 - psql -qc 'DROP EXTENSION "pg_surgery"' 358s ok 207 - extension pg_surgery removes without error 358s ok 208 - psql -qc 'CREATE EXTENSION "pg_trgm"' 358s ok 209 - extension pg_trgm installs without error 358s ok 210 - psql -qc 'DROP EXTENSION "pg_trgm"' 358s ok 211 - extension pg_trgm removes without error 358s ok 212 - psql -qc 'CREATE EXTENSION "pg_visibility"' 358s ok 213 - extension pg_visibility installs without error 358s ok 214 - psql -qc 'DROP EXTENSION "pg_visibility"' 358s ok 215 - extension pg_visibility removes without error 358s ok 216 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 358s ok 217 - extension pg_walinspect installs without error 358s ok 218 - psql -qc 'DROP EXTENSION "pg_walinspect"' 358s ok 219 - extension pg_walinspect removes without error 358s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 358s ok 221 - extension pgcrypto installs without error 358s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 358s ok 223 - extension pgcrypto removes without error 358s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 358s ok 225 - extension pgrowlocks installs without error 358s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 358s ok 227 - extension pgrowlocks removes without error 358s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 358s ok 229 - extension pgstattuple installs without error 358s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 358s ok 231 - extension pgstattuple removes without error 358s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 358s ok 233 - extension plperl installs without error 358s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 358s ok 235 - extension plperl removes without error 358s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 358s ok 237 - extension plperlu installs without error 358s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 358s ok 239 - extension plperlu removes without error 358s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 358s ok 241 - extension plpython3u installs without error 358s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 358s ok 243 - extension plpython3u removes without error 358s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 358s ok 245 - extension pltcl installs without error 358s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 358s ok 247 - extension pltcl removes without error 358s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 358s ok 249 - extension pltclu installs without error 358s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 358s ok 251 - extension pltclu removes without error 358s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 358s ok 253 - extension postgres_fdw installs without error 358s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 358s ok 255 - extension postgres_fdw removes without error 358s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 358s ok 257 - extension refint installs without error 358s ok 258 - psql -qc 'DROP EXTENSION "refint"' 358s ok 259 - extension refint removes without error 358s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 358s ok 261 - extension seg installs without error 359s ok 262 - psql -qc 'DROP EXTENSION "seg"' 359s ok 263 - extension seg removes without error 359s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 359s ok 265 - extension sslinfo installs without error 359s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 359s ok 267 - extension sslinfo removes without error 359s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 359s ok 269 - extension tablefunc installs without error 359s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 359s ok 271 - extension tablefunc removes without error 359s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 359s ok 273 - extension tcn installs without error 359s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 359s ok 275 - extension tcn removes without error 359s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 359s ok 277 - extension tsm_system_rows installs without error 359s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 359s ok 279 - extension tsm_system_rows removes without error 359s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 359s ok 281 - extension tsm_system_time installs without error 359s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 359s ok 283 - extension tsm_system_time removes without error 359s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 359s ok 285 - extension unaccent installs without error 359s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 359s ok 287 - extension unaccent removes without error 359s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 359s ok 289 - extension uuid-ossp installs without error 359s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 359s ok 291 - extension uuid-ossp removes without error 359s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 359s ok 293 - extension xml2 installs without error 359s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 359s ok 295 - extension xml2 removes without error 360s ok 296 - pg_dropcluster 18 main 360s # Cleanup 360s ok 297 - Cleanup: No clusters left behind 360s ok 298 - No postgres processes left behind 360s ok 299 - No files in /etc/postgresql left behind 360s ok 300 - No files in /var/lib/postgresql left behind 360s ok 301 - No files in /var/run/postgresql left behind 360s ok 302 - No files in /var/log/postgresql left behind 360s ok 303 - PostgreSQL TCP ports are closed 360s ok 304 - Next free port is 5432 360s 1..304 360s ### End test 170_extensions.t ### 360s 360s ### PostgreSQL test 180_ecpg.t ### 360s 1..14 360s ok 1 - ecpg test.pgc 360s ok 2 - ecpg processing 360s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 360s ok 4 - compiling ecpg output 367s ok 5 - pg_virtualenv /tmp/tmp.UrN20LyVwj/test 367s ok 6 - test program runs and gives correct output 367s # Cleanup 367s ok 7 - Cleanup: No clusters left behind 367s ok 8 - No postgres processes left behind 367s ok 9 - No files in /etc/postgresql left behind 367s ok 10 - No files in /var/lib/postgresql left behind 367s ok 11 - No files in /var/run/postgresql left behind 367s ok 12 - No files in /var/log/postgresql left behind 367s ok 13 - PostgreSQL TCP ports are closed 367s ok 14 - Next free port is 5432 367s ### End test 180_ecpg.t ### 367s 367s ### PostgreSQL test 190_pg_buildext.t ### 367s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 367s 1..1 367s ### End test 190_pg_buildext.t ### 367s 367s ### PostgreSQL test 200_maintscripts.t ### 367s 1..15 367s # We are running systemd 370s ok 1 - pg_createcluster 18 main --start 370s ok 2 - postmaster PID is 22443 376s ok 3 - apt-get update -q 376s # postgresql-common: 376s # Installed: 282ubuntu1 376s # Candidate: 282ubuntu1 376s # Version table: 376s # *** 282ubuntu1 500 376s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 376s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 376s # 100 /var/lib/dpkg/status 378s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 378s # postgresql-common: 378s # Installed: 282ubuntu1 378s # Candidate: 282ubuntu1 378s # Version table: 378s # *** 282ubuntu1 500 378s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 378s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 378s # 100 /var/lib/dpkg/status 378s ok 5 - postmaster PID is 22443 378s ok 6 - postmaster was not restarted 379s ok 7 - pg_dropcluster 18 main --stop 379s # Cleanup 379s ok 8 - Cleanup: No clusters left behind 379s ok 9 - No postgres processes left behind 379s ok 10 - No files in /etc/postgresql left behind 379s ok 11 - No files in /var/lib/postgresql left behind 379s ok 12 - No files in /var/run/postgresql left behind 379s ok 13 - No files in /var/log/postgresql left behind 379s ok 14 - PostgreSQL TCP ports are closed 379s ok 15 - Next free port is 5432 379s ### End test 200_maintscripts.t ### 379s 379s autopkgtest [07:39:43]: test run-testsuite: -----------------------] 380s autopkgtest [07:39:44]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 380s run-testsuite PASS 380s autopkgtest [07:39:44]: test installcheck: preparing testbed 387s Creating nova instance adt-resolute-amd64-postgresql-18-20251104-073324-juju-7f2275-prod-proposed-migration-environment-15-1ba3b2e2-435e-4f3d-87a5-a5f269736e1a from image adt/ubuntu-resolute-amd64-server-20251104.img (UUID e329c678-0fca-4d10-9e41-bfeb59fd2b3a)... 417s autopkgtest [07:40:21]: testbed dpkg architecture: amd64 418s autopkgtest [07:40:22]: testbed apt version: 3.1.11 418s autopkgtest [07:40:22]: @@@@@@@@@@@@@@@@@@@@ test bed setup 418s autopkgtest [07:40:22]: testbed release detected to be: resolute 419s autopkgtest [07:40:23]: updating testbed package index (apt update) 419s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 419s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 419s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 419s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 419s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [24.1 kB] 419s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [1026 kB] 419s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [82.4 kB] 419s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 419s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [88.8 kB] 419s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [132 kB] 419s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3020 B] 420s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 420s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 420s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 420s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [648 kB] 420s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [253 kB] 420s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [19.2 kB] 420s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [15.2 kB] 420s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [7180 B] 420s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [652 B] 420s Fetched 2465 kB in 1s (2521 kB/s) 421s Reading package lists... 421s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 421s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 421s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 421s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 422s Reading package lists... 422s Reading package lists... 422s Building dependency tree... 422s Reading state information... 422s Calculating upgrade... 422s The following packages will be upgraded: 422s base-passwd bash-completion iputils-tracepath libldap-common libldap2 422s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 422s Need to get 524 kB of archives. 422s After this operation, 30.7 kB disk space will be freed. 422s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 base-passwd amd64 3.6.8 [54.9 kB] 422s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 bash-completion all 1:2.16.0-8 [214 kB] 422s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 iputils-tracepath amd64 3:20250605-1ubuntu1 [14.8 kB] 422s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libldap-common all 2.6.10+dfsg-1ubuntu3 [35.9 kB] 422s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libldap2 amd64 2.6.10+dfsg-1ubuntu3 [204 kB] 422s dpkg-preconfigure: unable to re-open stdin: No such file or directory 422s Fetched 524 kB in 0s (0 B/s) 423s (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 ... 78551 files and directories currently installed.) 423s Preparing to unpack .../base-passwd_3.6.8_amd64.deb ... 423s Unpacking base-passwd (3.6.8) over (3.6.7) ... 423s Setting up base-passwd (3.6.8) ... 423s (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 ... 78551 files and directories currently installed.) 423s Preparing to unpack .../bash-completion_1%3a2.16.0-8_all.deb ... 423s Unpacking bash-completion (1:2.16.0-8) over (1:2.16.0-7) ... 423s Preparing to unpack .../iputils-tracepath_3%3a20250605-1ubuntu1_amd64.deb ... 423s Unpacking iputils-tracepath (3:20250605-1ubuntu1) over (3:20240905-3ubuntu3) ... 423s Preparing to unpack .../libldap-common_2.6.10+dfsg-1ubuntu3_all.deb ... 423s Unpacking libldap-common (2.6.10+dfsg-1ubuntu3) over (2.6.10+dfsg-1ubuntu2) ... 423s Preparing to unpack .../libldap2_2.6.10+dfsg-1ubuntu3_amd64.deb ... 423s Unpacking libldap2:amd64 (2.6.10+dfsg-1ubuntu3) over (2.6.10+dfsg-1ubuntu2) ... 423s Setting up libldap-common (2.6.10+dfsg-1ubuntu3) ... 423s Setting up bash-completion (1:2.16.0-8) ... 423s Setting up libldap2:amd64 (2.6.10+dfsg-1ubuntu3) ... 423s Setting up iputils-tracepath (3:20250605-1ubuntu1) ... 423s Processing triggers for man-db (2.13.1-1) ... 424s Processing triggers for libc-bin (2.42-0ubuntu3) ... 424s autopkgtest [07:40:28]: upgrading testbed (apt dist-upgrade and autopurge) 424s Reading package lists... 424s Building dependency tree... 424s Reading state information... 424s Calculating upgrade... 424s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 424s Reading package lists... 424s Building dependency tree... 424s Reading state information... 425s Solving dependencies... 425s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 427s Reading package lists... 427s Building dependency tree... 427s Reading state information... 427s Solving dependencies... 427s The following NEW packages will be installed: 427s build-essential clang-21 cpp cpp-15 cpp-15-x86-64-linux-gnu 427s cpp-x86-64-linux-gnu g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu 427s gcc gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 427s libclang-common-21-dev libclang-cpp21 libclang1-21 libecpg-compat3 427s libecpg-dev libecpg6 libffi-dev libgc1 libgcc-15-dev libgomp1 libhwasan0 427s libicu76 libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl 427s libllvm21 liblsan0 liblzma-dev libmpc3 libncurses-dev libobjc-15-dev 427s libobjc4 libpfm4 libpgtypes3 libpq-dev libpq-oauth libpq5 libquadmath0 427s libssl-dev libstdc++-15-dev libtcl8.6 libtsan2 libubsan1 liburing2 427s libxml2-dev libxslt1.1 llvm-21 llvm-21-dev llvm-21-linker-tools 427s llvm-21-runtime llvm-21-tools postgresql-18 postgresql-18-jit 427s postgresql-client-18 postgresql-client-common postgresql-common 427s postgresql-common-dev postgresql-doc-18 postgresql-plperl-18 427s postgresql-plpython3-18 postgresql-pltcl-18 postgresql-server-dev-18 427s ssl-cert tzdata-legacy zlib1g-dev 427s 0 upgraded, 73 newly installed, 0 to remove and 0 not upgraded. 427s Need to get 242 MB of archives. 427s After this operation, 1149 MB of additional disk space will be used. 427s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 427s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 427s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 427s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 427s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 427s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 427s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 427s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 427s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 428s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 428s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 428s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 428s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 428s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 428s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 428s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 428s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 428s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 428s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 428s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 428s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 428s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 428s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 428s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 428s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 428s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 428s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 428s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 429s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 429s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 429s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 429s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 429s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 429s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 429s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 429s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 429s Get:37 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 429s Get:38 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 429s Get:39 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 430s Get:40 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 430s Get:41 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 430s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 430s Get:43 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 430s Get:44 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 430s Get:45 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 430s Get:46 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 430s Get:47 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 430s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 430s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 430s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 430s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 430s Get:52 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 430s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 430s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 430s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 430s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 430s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 430s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 430s Get:59 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 430s Get:60 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 430s Get:61 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 430s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 431s Get:63 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 431s Get:64 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 431s Get:65 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 431s Get:66 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 431s Get:67 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 432s Get:68 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 432s Get:69 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 432s Get:70 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 432s Get:71 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 432s Get:72 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 432s Get:73 http://ftpmaster.internal/ubuntu resolute/main amd64 tzdata-legacy all 2025b-5ubuntu1 [99.3 kB] 432s Preconfiguring packages ... 432s Fetched 242 MB in 5s (52.8 MB/s) 432s Selecting previously unselected package libjson-perl. 432s (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 ... 78551 files and directories currently installed.) 432s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 432s Unpacking libjson-perl (4.10000-1) ... 432s Selecting previously unselected package postgresql-client-common. 432s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 432s Unpacking postgresql-client-common (282ubuntu1) ... 432s Selecting previously unselected package libio-pty-perl. 432s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 432s Unpacking libio-pty-perl (1:1.20-1build3) ... 432s Selecting previously unselected package libipc-run-perl. 432s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 432s Unpacking libipc-run-perl (20231003.0-2) ... 432s Selecting previously unselected package postgresql-common-dev. 432s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 432s Unpacking postgresql-common-dev (282ubuntu1) ... 432s Selecting previously unselected package ssl-cert. 432s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 432s Unpacking ssl-cert (1.1.3ubuntu1) ... 432s Selecting previously unselected package postgresql-common. 432s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 432s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 432s Unpacking postgresql-common (282ubuntu1) ... 432s Selecting previously unselected package libisl23:amd64. 432s Preparing to unpack .../07-libisl23_0.27-1_amd64.deb ... 432s Unpacking libisl23:amd64 (0.27-1) ... 432s Selecting previously unselected package libmpc3:amd64. 432s Preparing to unpack .../08-libmpc3_1.3.1-1build3_amd64.deb ... 432s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 432s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 432s Preparing to unpack .../09-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package cpp-15. 432s Preparing to unpack .../10-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package cpp-x86-64-linux-gnu. 432s Preparing to unpack .../11-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 432s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 432s Selecting previously unselected package cpp. 432s Preparing to unpack .../12-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 432s Unpacking cpp (4:15.2.0-4ubuntu1) ... 432s Selecting previously unselected package libcc1-0:amd64. 432s Preparing to unpack .../13-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libgomp1:amd64. 432s Preparing to unpack .../14-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libitm1:amd64. 432s Preparing to unpack .../15-libitm1_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libasan8:amd64. 432s Preparing to unpack .../16-libasan8_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package liblsan0:amd64. 432s Preparing to unpack .../17-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libtsan2:amd64. 432s Preparing to unpack .../18-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libubsan1:amd64. 432s Preparing to unpack .../19-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libhwasan0:amd64. 432s Preparing to unpack .../20-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libquadmath0:amd64. 432s Preparing to unpack .../21-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 432s Selecting previously unselected package libgcc-15-dev:amd64. 432s Preparing to unpack .../22-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 432s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 433s Preparing to unpack .../23-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 433s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package gcc-15. 433s Preparing to unpack .../24-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 433s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package gcc-x86-64-linux-gnu. 433s Preparing to unpack .../25-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 433s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 433s Selecting previously unselected package gcc. 433s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 433s Unpacking gcc (4:15.2.0-4ubuntu1) ... 433s Selecting previously unselected package libstdc++-15-dev:amd64. 433s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 433s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package g++-15-x86-64-linux-gnu. 433s Preparing to unpack .../28-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 433s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package g++-15. 433s Preparing to unpack .../29-g++-15_15.2.0-7ubuntu1_amd64.deb ... 433s Unpacking g++-15 (15.2.0-7ubuntu1) ... 433s Selecting previously unselected package g++-x86-64-linux-gnu. 433s Preparing to unpack .../30-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 433s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 433s Selecting previously unselected package g++. 433s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 433s Unpacking g++ (4:15.2.0-4ubuntu1) ... 433s Selecting previously unselected package build-essential. 433s Preparing to unpack .../32-build-essential_12.12ubuntu1_amd64.deb ... 433s Unpacking build-essential (12.12ubuntu1) ... 433s Selecting previously unselected package libllvm21:amd64. 433s Preparing to unpack .../33-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 433s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 433s Selecting previously unselected package libclang-cpp21. 433s Preparing to unpack .../34-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 433s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package libgc1:amd64. 434s Preparing to unpack .../35-libgc1_1%3a8.2.10-1_amd64.deb ... 434s Unpacking libgc1:amd64 (1:8.2.10-1) ... 434s Selecting previously unselected package libobjc4:amd64. 434s Preparing to unpack .../36-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 434s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 434s Selecting previously unselected package libobjc-15-dev:amd64. 434s Preparing to unpack .../37-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 434s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 434s Selecting previously unselected package libclang-common-21-dev:amd64. 434s Preparing to unpack .../38-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package llvm-21-linker-tools. 434s Preparing to unpack .../39-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package libclang1-21. 434s Preparing to unpack .../40-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package clang-21. 434s Preparing to unpack .../41-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package libpgtypes3:amd64. 434s Preparing to unpack .../42-libpgtypes3_18.0-1_amd64.deb ... 434s Unpacking libpgtypes3:amd64 (18.0-1) ... 434s Selecting previously unselected package libpq5:amd64. 434s Preparing to unpack .../43-libpq5_18.0-1_amd64.deb ... 434s Unpacking libpq5:amd64 (18.0-1) ... 434s Selecting previously unselected package libecpg6:amd64. 434s Preparing to unpack .../44-libecpg6_18.0-1_amd64.deb ... 434s Unpacking libecpg6:amd64 (18.0-1) ... 434s Selecting previously unselected package libecpg-compat3:amd64. 434s Preparing to unpack .../45-libecpg-compat3_18.0-1_amd64.deb ... 434s Unpacking libecpg-compat3:amd64 (18.0-1) ... 434s Selecting previously unselected package libssl-dev:amd64. 434s Preparing to unpack .../46-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 434s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 434s Selecting previously unselected package libpq-dev. 434s Preparing to unpack .../47-libpq-dev_18.0-1_amd64.deb ... 434s Unpacking libpq-dev (18.0-1) ... 434s Selecting previously unselected package libecpg-dev. 434s Preparing to unpack .../48-libecpg-dev_18.0-1_amd64.deb ... 434s Unpacking libecpg-dev (18.0-1) ... 434s Selecting previously unselected package libicu76:amd64. 434s Preparing to unpack .../49-libicu76_76.1-4ubuntu2_amd64.deb ... 434s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 434s Selecting previously unselected package libncurses-dev:amd64. 434s Preparing to unpack .../50-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 434s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 434s Selecting previously unselected package libpq-oauth:amd64. 434s Preparing to unpack .../51-libpq-oauth_18.0-1_amd64.deb ... 434s Unpacking libpq-oauth:amd64 (18.0-1) ... 434s Selecting previously unselected package libtcl8.6:amd64. 434s Preparing to unpack .../52-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 434s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 434s Selecting previously unselected package liburing2:amd64. 434s Preparing to unpack .../53-liburing2_2.11-1_amd64.deb ... 434s Unpacking liburing2:amd64 (2.11-1) ... 434s Selecting previously unselected package liblzma-dev:amd64. 434s Preparing to unpack .../54-liblzma-dev_5.8.1-1build2_amd64.deb ... 434s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 434s Selecting previously unselected package zlib1g-dev:amd64. 434s Preparing to unpack .../55-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 434s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 434s Selecting previously unselected package libxml2-dev:amd64. 434s Preparing to unpack .../56-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 434s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 434s Selecting previously unselected package libxslt1.1:amd64. 434s Preparing to unpack .../57-libxslt1.1_1.1.43-0.3_amd64.deb ... 434s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 434s Selecting previously unselected package llvm-21-runtime. 434s Preparing to unpack .../58-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 434s Selecting previously unselected package libpfm4:amd64. 434s Preparing to unpack .../59-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 434s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 434s Selecting previously unselected package llvm-21. 434s Preparing to unpack .../60-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 434s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 435s Selecting previously unselected package libffi-dev:amd64. 435s Preparing to unpack .../61-libffi-dev_3.5.2-2_amd64.deb ... 435s Unpacking libffi-dev:amd64 (3.5.2-2) ... 435s Selecting previously unselected package llvm-21-tools. 435s Preparing to unpack .../62-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 435s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 435s Selecting previously unselected package llvm-21-dev. 435s Preparing to unpack .../63-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 435s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 435s Selecting previously unselected package postgresql-client-18. 435s Preparing to unpack .../64-postgresql-client-18_18.0-1_amd64.deb ... 435s Unpacking postgresql-client-18 (18.0-1) ... 435s Selecting previously unselected package postgresql-18. 435s Preparing to unpack .../65-postgresql-18_18.0-1_amd64.deb ... 435s Unpacking postgresql-18 (18.0-1) ... 436s Selecting previously unselected package postgresql-18-jit. 436s Preparing to unpack .../66-postgresql-18-jit_18.0-1_amd64.deb ... 436s Unpacking postgresql-18-jit (18.0-1) ... 436s Selecting previously unselected package postgresql-doc-18. 436s Preparing to unpack .../67-postgresql-doc-18_18.0-1_all.deb ... 436s Unpacking postgresql-doc-18 (18.0-1) ... 436s Selecting previously unselected package postgresql-plperl-18. 436s Preparing to unpack .../68-postgresql-plperl-18_18.0-1_amd64.deb ... 436s Unpacking postgresql-plperl-18 (18.0-1) ... 436s Selecting previously unselected package postgresql-plpython3-18. 436s Preparing to unpack .../69-postgresql-plpython3-18_18.0-1_amd64.deb ... 436s Unpacking postgresql-plpython3-18 (18.0-1) ... 436s Selecting previously unselected package postgresql-pltcl-18. 436s Preparing to unpack .../70-postgresql-pltcl-18_18.0-1_amd64.deb ... 436s Unpacking postgresql-pltcl-18 (18.0-1) ... 436s Selecting previously unselected package postgresql-server-dev-18. 436s Preparing to unpack .../71-postgresql-server-dev-18_18.0-1_amd64.deb ... 436s Unpacking postgresql-server-dev-18 (18.0-1) ... 436s Selecting previously unselected package tzdata-legacy. 436s Preparing to unpack .../72-tzdata-legacy_2025b-5ubuntu1_all.deb ... 436s Unpacking tzdata-legacy (2025b-5ubuntu1) ... 436s Setting up postgresql-client-common (282ubuntu1) ... 436s Setting up libpgtypes3:amd64 (18.0-1) ... 436s Setting up postgresql-doc-18 (18.0-1) ... 436s update-alternatives: using /usr/share/postgresql/18/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 436s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 436s Setting up libio-pty-perl (1:1.20-1build3) ... 436s Setting up libpq5:amd64 (18.0-1) ... 436s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libffi-dev:amd64 (3.5.2-2) ... 436s Setting up tzdata-legacy (2025b-5ubuntu1) ... 436s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 436s Setting up ssl-cert (1.1.3ubuntu1) ... 436s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 436s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 436s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 436s Setting up libmpc3:amd64 (1.3.1-1build3) ... 436s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 436s Setting up libipc-run-perl (20231003.0-2) ... 436s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 436s Setting up libgc1:amd64 (1:8.2.10-1) ... 436s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 436s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 436s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 436s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libjson-perl (4.10000-1) ... 436s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 436s Setting up libecpg6:amd64 (18.0-1) ... 436s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 436s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 436s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 436s Setting up liburing2:amd64 (2.11-1) ... 436s Setting up libisl23:amd64 (0.27-1) ... 436s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 436s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 436s Setting up postgresql-common-dev (282ubuntu1) ... 436s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 436s Setting up libecpg-compat3:amd64 (18.0-1) ... 436s Setting up postgresql-client-18 (18.0-1) ... 437s 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 437s Setting up libpq-oauth:amd64 (18.0-1) ... 437s Setting up libpq-dev (18.0-1) ... 437s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 437s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 437s Setting up libecpg-dev (18.0-1) ... 437s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 437s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 437s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 437s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 437s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 437s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 437s Setting up postgresql-common (282ubuntu1) ... 437s Creating config file /etc/postgresql-common/createcluster.conf with new version 437s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 437s Removing obsolete dictionary files: 437s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 437s Setting up cpp-15 (15.2.0-7ubuntu1) ... 437s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 437s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 437s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 437s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 438s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 438s Setting up postgresql-18 (18.0-1) ... 438s Creating new PostgreSQL cluster 18/main ... 438s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 438s The files belonging to this database system will be owned by user "postgres". 438s This user must also own the server process. 438s 438s The database cluster will be initialized with locale "C.UTF-8". 438s The default database encoding has accordingly been set to "UTF8". 438s The default text search configuration will be set to "english". 438s 438s Data page checksums are enabled. 438s 438s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 438s creating subdirectories ... ok 438s selecting dynamic shared memory implementation ... posix 438s selecting default "max_connections" ... 100 438s selecting default "shared_buffers" ... 128MB 438s selecting default time zone ... Etc/UTC 438s creating configuration files ... ok 438s running bootstrap script ... ok 438s performing post-bootstrap initialization ... ok 438s syncing data to disk ... ok 441s Setting up postgresql-18-jit (18.0-1) ... 441s Setting up gcc-15 (15.2.0-7ubuntu1) ... 441s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 441s Setting up postgresql-plpython3-18 (18.0-1) ... 441s Setting up cpp (4:15.2.0-4ubuntu1) ... 441s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 441s Setting up postgresql-plperl-18 (18.0-1) ... 441s Setting up g++-15 (15.2.0-7ubuntu1) ... 441s Setting up postgresql-pltcl-18 (18.0-1) ... 441s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 441s Setting up postgresql-server-dev-18 (18.0-1) ... 441s Setting up gcc (4:15.2.0-4ubuntu1) ... 441s Setting up g++ (4:15.2.0-4ubuntu1) ... 441s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 441s Setting up build-essential (12.12ubuntu1) ... 441s Processing triggers for libc-bin (2.42-0ubuntu3) ... 441s Processing triggers for systemd (257.9-0ubuntu2) ... 441s Processing triggers for man-db (2.13.1-1) ... 441s Processing triggers for install-info (7.2-5) ... 452s autopkgtest [07:40:56]: test installcheck: [----------------------- 452s + dpkg-parsechangelog -SSource 452s + SOURCE=postgresql-18 452s + MAJOR=18 452s + top_srcdir=/tmp/autopkgtest.0LeIKK/build.BQH/src 452s + cd src/test/regress 452s + make -f /tmp/autopkgtest.0LeIKK/build.BQH/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config with_llvm=no 452s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -Wmissing-variable-declarations -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.0LeIKK/build.BQH/src/debian/tests/ -I/usr/include/postgresql/18/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 452s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -Wmissing-variable-declarations -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/x86_64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -fvisibility=hidden 453s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.0LeIKK/build.BQH/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyencoding.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated_stored.sql sql/generated_virtual.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/maintain_every.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numa.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/predicate.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/psql_pipeline.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/sqljson_jsontable.sql sql/sqljson_queryfuncs.sql sql/stats.sql sql/stats_ext.sql sql/stats_import.sql sql/strings.sql sql/subscription.sql sql/subselect.sql sql/sysviews.sql sql/tablesample.sql sql/tablespace.sql sql/temp.sql sql/test_setup.sql sql/text.sql sql/tid.sql sql/tidrangescan.sql sql/tidscan.sql sql/time.sql sql/timestamp.sql sql/timestamptz.sql sql/timetz.sql sql/transactions.sql sql/triggers.sql sql/truncate.sql sql/tsdicts.sql sql/tsearch.sql sql/tsrf.sql sql/tstypes.sql sql/tuplesort.sql sql/txid.sql sql/type_sanity.sql sql/typed_table.sql sql/unicode.sql sql/union.sql sql/updatable_views.sql sql/update.sql sql/uuid.sql sql/vacuum.sql sql/vacuum_parallel.sql sql/varchar.sql sql/window.sql sql/with.sql sql/without_overlaps.sql sql/write_parallel.sql sql/xid.sql sql/xml.sql sql/xmlmap.sql expected/advisory_lock.out expected/aggregates.out expected/alter_generic.out expected/alter_operator.out expected/alter_table.out expected/amutils.out expected/arrays.out expected/async.out expected/bit.out expected/bitmapops.out expected/boolean.out expected/box.out expected/brin.out expected/brin_bloom.out expected/brin_multi.out expected/btree_index.out expected/case.out expected/char.out expected/char_1.out expected/char_2.out expected/circle.out expected/cluster.out expected/collate.icu.utf8.out expected/collate.icu.utf8_1.out expected/collate.linux.utf8.out expected/collate.linux.utf8_1.out expected/collate.out expected/collate.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyencoding.out expected/copyencoding_1.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated_stored.out expected/generated_virtual.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/maintain_every.out expected/matview.out expected/md5.out expected/md5_1.out expected/md5_2.out expected/memoize.out expected/merge.out expected/misc.out expected/misc_functions.out expected/misc_sanity.out expected/money.out expected/multirangetypes.out expected/mvcc.out expected/name.out expected/namespace.out expected/numa.out expected/numa_1.out expected/numeric.out expected/numeric_big.out expected/numerology.out expected/object_address.out expected/oid.out expected/oidjoins.out expected/opr_sanity.out expected/partition_aggregate.out expected/partition_info.out expected/partition_join.out expected/partition_prune.out expected/password.out expected/password_1.out expected/password_2.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/psql_pipeline.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/stats_import.out expected/strings.out expected/subscription.out expected/subselect.out expected/sysviews.out expected/tablesample.out expected/tablespace.out expected/temp.out expected/test_setup.out expected/text.out expected/tid.out expected/tidrangescan.out expected/tidscan.out expected/time.out expected/timestamp.out expected/timestamptz.out expected/timetz.out expected/transactions.out expected/triggers.out expected/truncate.out expected/tsdicts.out expected/tsearch.out expected/tsrf.out expected/tstypes.out expected/tuplesort.out expected/txid.out expected/type_sanity.out expected/typed_table.out expected/unicode.out expected/unicode_1.out expected/union.out expected/updatable_views.out expected/update.out expected/uuid.out expected/vacuum.out expected/vacuum_parallel.out expected/varchar.out expected/varchar_1.out expected/varchar_2.out expected/window.out expected/with.out expected/without_overlaps.out expected/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 453s + id -u 453s + [ 1000 = 0 ] 453s + SU=sh 453s + sh 453s + mktemp -d /tmp/regress.XXXXXX 453s + OUTPUT=/tmp/regress.RRGCsv 453s + trap rm -rf /tmp/regress.RRGCsv EXIT 453s + pg_virtualenv -v 18 /usr/lib/postgresql/18/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.RRGCsv --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 453s Creating new PostgreSQL cluster 18/regress ... 455s # using postmaster on localhost, port 5433 455s ok 1 - test_setup 108 ms 456s # parallel group (20 tests): txid varchar pg_lsn char name oid text regproc int2 int4 money float4 float8 int8 enum uuid bit boolean numeric rangetypes 456s ok 2 + boolean 306 ms 456s ok 3 + char 109 ms 456s ok 4 + name 121 ms 456s ok 5 + varchar 101 ms 456s ok 6 + text 136 ms 456s ok 7 + int2 145 ms 456s ok 8 + int4 151 ms 456s ok 9 + int8 182 ms 456s ok 10 + oid 126 ms 456s ok 11 + float4 157 ms 456s ok 12 + float8 160 ms 456s ok 13 + bit 280 ms 456s ok 14 + numeric 346 ms 456s ok 15 + txid 86 ms 456s ok 16 + uuid 215 ms 456s ok 17 + enum 199 ms 456s ok 18 + money 148 ms 456s ok 19 + rangetypes 373 ms 456s ok 20 + pg_lsn 100 ms 456s ok 21 + regproc 133 ms 456s # parallel group (20 tests): lseg line md5 time path circle date timetz macaddr numerology macaddr8 inet strings interval polygon point box multirangetypes timestamp timestamptz 456s ok 22 + strings 236 ms 456s ok 23 + md5 100 ms 456s ok 24 + numerology 151 ms 456s ok 25 + point 290 ms 456s ok 26 + lseg 65 ms 456s ok 27 + line 75 ms 456s ok 28 + box 314 ms 456s ok 29 + path 102 ms 456s ok 30 + polygon 285 ms 456s ok 31 + circle 106 ms 456s ok 32 + date 116 ms 456s ok 33 + time 99 ms 456s ok 34 + timetz 134 ms 456s ok 35 + timestamp 421 ms 456s ok 36 + timestamptz 426 ms 456s ok 37 + interval 254 ms 456s ok 38 + inet 175 ms 456s ok 39 + macaddr 129 ms 456s ok 40 + macaddr8 148 ms 456s ok 41 + multirangetypes 311 ms 457s # parallel group (14 tests): comments unicode misc_sanity xid expressions mvcc geometry tstypes type_sanity stats_import database horology opr_sanity regex 457s ok 42 + geometry 173 ms 457s ok 43 + horology 361 ms 457s ok 44 + tstypes 177 ms 457s ok 45 + regex 407 ms 457s ok 46 + type_sanity 218 ms 457s ok 47 + opr_sanity 393 ms 457s ok 48 + misc_sanity 83 ms 457s ok 49 + comments 67 ms 457s ok 50 + expressions 157 ms 457s ok 51 + unicode 75 ms 457s ok 52 + xid 132 ms 457s ok 53 + mvcc 161 ms 457s ok 54 + database 323 ms 457s ok 55 + stats_import 232 ms 457s # parallel group (6 tests): copyencoding copyselect copydml insert_conflict copy insert 457s ok 56 + copy 104 ms 457s ok 57 + copyselect 44 ms 457s ok 58 + copydml 57 ms 457s ok 59 + copyencoding 34 ms 457s ok 60 + insert 197 ms 457s ok 61 + insert_conflict 98 ms 457s # parallel group (7 tests): create_function_c create_schema create_operator create_type create_misc create_procedure create_table 457s ok 62 + create_function_c 24 ms 457s ok 63 + create_misc 69 ms 457s ok 64 + create_operator 51 ms 457s ok 65 + create_procedure 75 ms 457s ok 66 + create_table 195 ms 457s ok 67 + create_type 61 ms 457s ok 68 + create_schema 35 ms 457s # parallel group (5 tests): index_including_gist index_including create_index_spgist create_view create_index 457s ok 69 + create_index 425 ms 457s ok 70 + create_index_spgist 261 ms 457s ok 71 + create_view 275 ms 457s ok 72 + index_including 193 ms 457s ok 73 + index_including_gist 187 ms 458s # parallel group (16 tests): create_cast create_aggregate errors hash_func roleattributes select typed_table drop_if_exists create_function_sql create_am infinite_recurse vacuum updatable_views constraints triggers inherit 458s ok 74 + create_aggregate 107 ms 458s ok 75 + create_function_sql 231 ms 458s ok 76 + create_cast 71 ms 458s ok 77 + constraints 698 ms 458s ok 78 + triggers 792 ms 458s ok 79 + select 181 ms 458s ok 80 + inherit 831 ms 458s ok 81 + typed_table 188 ms 458s ok 82 + vacuum 509 ms 458s ok 83 + drop_if_exists 199 ms 458s ok 84 + updatable_views 680 ms 458s ok 85 + roleattributes 140 ms 458s ok 86 + create_am 284 ms 458s ok 87 + hash_func 131 ms 458s ok 88 + errors 112 ms 458s ok 89 + infinite_recurse 307 ms 458s ok 90 - sanity_check 45 ms 460s # parallel group (20 tests): select_having delete select_distinct_on select_implicit case random namespace prepared_xacts union select_into transactions portals select_distinct subselect arrays hash_index update aggregates btree_index join 460s ok 91 + select_into 255 ms 460s ok 92 + select_distinct 459 ms 460s ok 93 + select_distinct_on 175 ms 460s ok 94 + select_implicit 193 ms 460s ok 95 + select_having 92 ms 460s ok 96 + subselect 542 ms 460s ok 97 + union 247 ms 460s ok 98 + case 194 ms 460s ok 99 + join 1189 ms 460s ok 100 + aggregates 1081 ms 460s ok 101 + transactions 344 ms 460s ok 102 + random 222 ms 460s ok 103 + portals 369 ms 460s ok 104 + arrays 578 ms 460s ok 105 + btree_index 1133 ms 460s ok 106 + hash_index 752 ms 460s ok 107 + update 753 ms 460s ok 108 + delete 115 ms 460s ok 109 + namespace 214 ms 460s ok 110 + prepared_xacts 216 ms 463s # parallel group (20 tests): init_privs drop_operator security_label object_address tablesample lock password collate replica_identity identity matview spgist rowsecurity generated_stored gist groupingsets gin join_hash brin privileges 463s ok 111 + brin 3345 ms 463s ok 112 + gin 1390 ms 463s ok 113 + gist 1221 ms 463s ok 114 + spgist 974 ms 463s ok 115 + privileges 3540 ms 463s ok 116 + init_privs 73 ms 463s ok 117 + security_label 146 ms 463s ok 118 + collate 396 ms 463s ok 119 + matview 828 ms 463s ok 120 + lock 275 ms 463s ok 121 + replica_identity 506 ms 463s ok 122 + rowsecurity 1117 ms 463s ok 123 + object_address 233 ms 463s ok 124 + tablesample 231 ms 463s ok 125 + groupingsets 1283 ms 463s ok 126 + drop_operator 74 ms 463s ok 127 + password 328 ms 463s ok 128 + identity 807 ms 463s ok 129 + generated_stored 1169 ms 463s ok 130 + join_hash 3331 ms 463s # parallel group (2 tests): brin_bloom brin_multi 463s ok 131 + brin_bloom 38 ms 463s ok 132 + brin_multi 100 ms 464s # parallel group (19 tests): async dbsize tidrangescan collate.utf8 tsrf tid tidscan create_role alter_operator alter_generic incremental_sort sysviews misc_functions merge create_table_like generated_virtual without_overlaps misc collate.icu.utf8 464s ok 133 + create_table_like 584 ms 464s ok 134 + alter_generic 295 ms 464s ok 135 + alter_operator 179 ms 464s ok 136 + misc 787 ms 464s ok 137 + async 54 ms 464s ok 138 + dbsize 71 ms 464s ok 139 + merge 561 ms 464s ok 140 + misc_functions 422 ms 464s ok 141 + sysviews 379 ms 464s ok 142 + tsrf 165 ms 464s ok 143 + tid 167 ms 464s ok 144 + tidscan 169 ms 464s ok 145 + tidrangescan 143 ms 464s ok 146 + collate.utf8 147 ms 464s ok 147 + collate.icu.utf8 782 ms 464s ok 148 + incremental_sort 308 ms 464s ok 149 + create_role 162 ms 464s ok 150 + without_overlaps 719 ms 464s ok 151 + generated_virtual 652 ms 465s # parallel group (8 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab psql_pipeline rules psql stats_ext 465s ok 152 + rules 253 ms 465s ok 153 + psql 346 ms 465s ok 154 + psql_crosstab 48 ms 465s ok 155 + psql_pipeline 52 ms 465s ok 156 + amutils 44 ms 465s ok 157 + stats_ext 704 ms 465s ok 158 + collate.linux.utf8 35 ms 465s ok 159 + collate.windows.win1252 37 ms 466s ok 160 - select_parallel 1377 ms 466s ok 161 - write_parallel 63 ms 466s ok 162 - vacuum_parallel 45 ms 466s ok 163 - maintain_every 16 ms 467s # parallel group (2 tests): subscription publication 467s ok 164 + publication 1023 ms 467s ok 165 + subscription 35 ms 468s # parallel group (17 tests): combocid portals_p2 advisory_lock xmlmap functional_deps tsdicts equivclass guc dependency select_views bitmapops window tsearch cluster indirect_toast foreign_data foreign_key 468s ok 166 + select_views 294 ms 468s ok 167 + portals_p2 115 ms 468s ok 168 + foreign_key 821 ms 468s ok 169 + cluster 496 ms 468s ok 170 + dependency 233 ms 468s ok 171 + guc 219 ms 468s ok 172 + bitmapops 459 ms 468s ok 173 + combocid 109 ms 468s ok 174 + tsearch 486 ms 468s ok 175 + tsdicts 210 ms 468s ok 176 + foreign_data 636 ms 468s ok 177 + window 469 ms 468s ok 178 + xmlmap 136 ms 468s ok 179 + functional_deps 175 ms 468s ok 180 + advisory_lock 114 ms 468s ok 181 + indirect_toast 520 ms 468s ok 182 + equivclass 199 ms 468s # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson json sqljson_jsontable sqljson_queryfuncs jsonb_jsonpath jsonb 468s ok 183 + json 126 ms 468s ok 184 + jsonb 217 ms 468s ok 185 + json_encoding 56 ms 468s ok 186 + jsonpath 70 ms 468s ok 187 + jsonpath_encoding 48 ms 468s ok 188 + jsonb_jsonpath 179 ms 468s ok 189 + sqljson 104 ms 468s ok 190 + sqljson_queryfuncs 158 ms 468s ok 191 + sqljson_jsontable 136 ms 470s # parallel group (18 tests): prepare conversion plancache limit returning sequence polymorphism rowtypes copy2 truncate largeobject temp with domain rangefuncs xml plpgsql alter_table 470s ok 192 + plancache 277 ms 470s ok 193 + limit 285 ms 470s ok 194 + plpgsql 848 ms 470s ok 195 + copy2 485 ms 470s ok 196 + temp 592 ms 470s ok 197 + domain 695 ms 470s ok 198 + rangefuncs 771 ms 470s ok 199 + prepare 118 ms 470s ok 200 + conversion 273 ms 470s ok 201 + truncate 536 ms 470s ok 202 + alter_table 1223 ms 470s ok 203 + sequence 416 ms 470s ok 204 + polymorphism 447 ms 470s ok 205 + rowtypes 481 ms 470s ok 206 + returning 340 ms 470s ok 207 + largeobject 576 ms 470s ok 208 + with 642 ms 470s ok 209 + xml 805 ms 471s # parallel group (14 tests): hash_part reloptions predicate partition_info explain numa memoize compression partition_aggregate tuplesort partition_join stats indexing partition_prune 471s ok 210 + partition_join 987 ms 471s ok 211 + partition_prune 1181 ms 471s ok 212 + reloptions 159 ms 471s ok 213 + hash_part 139 ms 471s ok 214 + indexing 1093 ms 471s ok 215 + partition_aggregate 862 ms 471s ok 216 + partition_info 239 ms 471s ok 217 + tuplesort 908 ms 471s ok 218 + explain 248 ms 471s ok 219 + compression 422 ms 471s ok 220 + memoize 356 ms 471s ok 221 + stats 1051 ms 471s ok 222 + predicate 228 ms 471s ok 223 + numa 252 ms 471s # parallel group (2 tests): oidjoins event_trigger 471s ok 224 + oidjoins 109 ms 471s ok 225 + event_trigger 122 ms 471s ok 226 - event_trigger_login 27 ms 471s ok 227 - fast_default 67 ms 471s ok 228 - tablespace 185 ms 471s 1..228 471s # All 228 tests passed. 471s Dropping cluster 18/regress ... 471s + rm -rf /tmp/regress.RRGCsv 472s autopkgtest [07:41:16]: test installcheck: -----------------------] 472s installcheck PASS 472s autopkgtest [07:41:16]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 472s autopkgtest [07:41:16]: @@@@@@@@@@@@@@@@@@@@ summary 472s run-testsuite PASS 472s installcheck PASS