0s autopkgtest [23:23:15]: starting date and time: 2025-11-02 23:23:15+0000 0s autopkgtest [23:23:15]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [23:23:15]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.98dqmbkc/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:liburing --apt-upgrade postgresql-18 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=liburing/2.12-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-20251102-232315-juju-7f2275-prod-proposed-migration-environment-15-4a64cf16-9c13-4cb7-befe-69d049d1c054 --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-20251102-232315-juju-7f2275-prod-proposed-migration-environment-15-4a64cf16-9c13-4cb7-befe-69d049d1c054 from image adt/ubuntu-resolute-amd64-server-20251102.img (UUID 78978bf7-ada0-4083-bfa4-315ae4f39784)... 63s autopkgtest [23:24:18]: testbed dpkg architecture: amd64 63s autopkgtest [23:24:18]: testbed apt version: 3.1.11 64s autopkgtest [23:24:19]: @@@@@@@@@@@@@@@@@@@@ test bed setup 64s autopkgtest [23:24:19]: testbed release detected to be: None 64s autopkgtest [23:24:19]: updating testbed package index (apt update) 65s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 65s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 65s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 65s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 65s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [44.6 kB] 65s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [1108 kB] 66s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [93.3 kB] 66s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 66s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [99.6 kB] 67s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [145 kB] 67s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3412 B] 67s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 67s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 67s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 67s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [766 kB] 68s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [290 kB] 68s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [23.5 kB] 68s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [37.1 kB] 68s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [11.2 kB] 68s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [1440 B] 69s Fetched 2790 kB in 4s (719 kB/s) 69s Reading package lists... 70s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 70s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 70s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 70s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 71s Reading package lists... 71s Reading package lists... 71s Building dependency tree... 71s Reading state information... 71s Calculating upgrade... 71s The following packages will be upgraded: 71s linux-firmware 71s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 71s Need to get 654 MB of archives. 71s After this operation, 13.4 MB of additional disk space will be used. 71s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 linux-firmware all 20251029.git4f72031f-0ubuntu1 [654 MB] 223s dpkg-preconfigure: unable to re-open stdin: No such file or directory 223s Fetched 654 MB in 2min 31s (4317 kB/s) 223s (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 ... 78534 files and directories currently installed.) 223s Preparing to unpack .../linux-firmware_20251029.git4f72031f-0ubuntu1_all.deb ... 223s Unpacking linux-firmware (20251029.git4f72031f-0ubuntu1) over (20251009.git46a6999a-0ubuntu1) ... 224s Setting up linux-firmware (20251029.git4f72031f-0ubuntu1) ... 224s Processing triggers for initramfs-tools (0.150ubuntu4) ... 225s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 229s autopkgtest [23:27:04]: upgrading testbed (apt dist-upgrade and autopurge) 229s Reading package lists... 229s Building dependency tree... 229s Reading state information... 230s Calculating upgrade... 230s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 230s Reading package lists... 230s Building dependency tree... 230s Reading state information... 230s Solving dependencies... 230s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 230s autopkgtest [23:27:05]: rebooting testbed after setup commands that affected boot 246s autopkgtest [23:27:21]: testbed running kernel: Linux 6.17.0-5-generic #5-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 22 10:00:33 UTC 2025 248s autopkgtest [23:27:23]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-18 256s Get:1 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (dsc) [4420 B] 256s Get:2 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (tar) [22.4 MB] 256s Get:3 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (diff) [22.9 kB] 256s gpgv: Signature made Fri Sep 26 07:48:05 2025 UTC 256s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 256s gpgv: Can't check signature: No public key 256s dpkg-source: warning: cannot verify inline signature for ./postgresql-18_18.0-1.dsc: no acceptable signature found 259s autopkgtest [23:27:34]: testing package postgresql-18 version 18.0-1 260s autopkgtest [23:27:35]: build not needed 268s autopkgtest [23:27:43]: test run-testsuite: preparing testbed 268s Reading package lists... 268s Building dependency tree... 268s Reading state information... 268s Solving dependencies... 268s The following NEW packages will be installed: 268s autoconf automake autopoint autotools-dev build-essential clang-21 cpp 268s cpp-15 cpp-15-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 268s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 268s fakeroot g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-15 268s gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 268s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-21-dev 268s libclang-cpp21 libclang1-21 libdebhelper-perl libecpg-compat3 libecpg-dev 268s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 268s libgcc-15-dev libgomp1 libhwasan0 libicu76 libio-pty-perl libipc-run-perl 268s libisl23 libitm1 libjson-perl libllvm21 liblsan0 liblzma-dev libmpc3 268s libncurses-dev libobjc-15-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 268s libpq-oauth libpq5 libquadmath0 libssl-dev libstdc++-15-dev libtcl8.6 268s libtool libtsan2 libubsan1 liburing2 libxml2-dev libxslt1.1 llvm-21 268s llvm-21-dev llvm-21-linker-tools llvm-21-runtime llvm-21-tools locales-all 268s m4 po-debconf postgresql-18 postgresql-18-jit postgresql-client-18 268s postgresql-client-common postgresql-common postgresql-common-dev 268s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 268s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert zlib1g-dev 268s 0 upgraded, 95 newly installed, 0 to remove and 0 not upgraded. 268s Need to get 259 MB of archives. 268s After this operation, 1405 MB of additional disk space will be used. 268s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 268s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 268s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 268s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 268s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 268s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 268s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 268s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 m4 amd64 1.4.20-2 [217 kB] 268s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 268s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 autotools-dev all 20240727.1 [43.4 kB] 269s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 automake all 1:1.18.1-2 [581 kB] 269s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 autopoint all 0.23.1-2build2 [619 kB] 269s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 269s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 269s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 270s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 270s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 270s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 270s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 270s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 270s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 270s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 270s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 271s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 271s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 271s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 271s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 271s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 271s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 273s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 273s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 273s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 273s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 273s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 274s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 274s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 274s Get:37 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 274s Get:38 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 274s Get:39 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 276s Get:40 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 277s Get:41 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 277s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 277s Get:43 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 277s Get:44 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 277s Get:45 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 277s Get:46 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 278s Get:47 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 278s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 278s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libtool all 2.5.4-4build1 [169 kB] 278s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-autoreconf all 21 [12.5 kB] 278s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 278s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [20.5 kB] 278s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-strip-nondeterminism all 1.15.0-1 [5090 B] 278s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 debugedit amd64 1:5.2-3 [49.9 kB] 278s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 dwz amd64 0.16-2 [115 kB] 278s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 gettext amd64 0.23.1-2build2 [1043 kB] 278s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 278s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 278s Get:59 http://ftpmaster.internal/ubuntu resolute/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 278s Get:60 http://ftpmaster.internal/ubuntu resolute/main amd64 emacsen-common all 3.0.8 [13.9 kB] 278s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 dictionaries-common all 1.30.11 [178 kB] 278s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 278s Get:63 http://ftpmaster.internal/ubuntu resolute/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 278s Get:64 http://ftpmaster.internal/ubuntu resolute/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 278s Get:65 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 278s Get:66 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 278s Get:67 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 278s Get:68 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 278s Get:69 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 278s Get:70 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 278s Get:71 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 278s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 279s Get:73 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 279s Get:74 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 279s Get:75 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 279s Get:76 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 liburing2 amd64 2.12-1 [24.7 kB] 279s Get:77 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 279s Get:78 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 279s Get:79 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 279s Get:80 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 279s Get:81 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 279s Get:82 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 280s Get:83 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 281s Get:84 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 281s Get:85 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 281s Get:86 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 284s Get:87 http://ftpmaster.internal/ubuntu resolute/main amd64 locales-all amd64 2.42-0ubuntu3 [11.2 MB] 284s Get:88 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 284s Get:89 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 285s Get:90 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 286s Get:91 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 286s Get:92 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 286s Get:93 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 286s Get:94 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 286s Get:95 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 287s Preconfiguring packages ... 287s Fetched 259 MB in 18s (14.5 MB/s) 287s Selecting previously unselected package libjson-perl. 287s (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.) 287s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 287s Unpacking libjson-perl (4.10000-1) ... 287s Selecting previously unselected package postgresql-client-common. 287s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 287s Unpacking postgresql-client-common (282ubuntu1) ... 287s Selecting previously unselected package libio-pty-perl. 287s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 287s Unpacking libio-pty-perl (1:1.20-1build3) ... 287s Selecting previously unselected package libipc-run-perl. 287s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 287s Unpacking libipc-run-perl (20231003.0-2) ... 287s Selecting previously unselected package postgresql-common-dev. 287s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 287s Unpacking postgresql-common-dev (282ubuntu1) ... 287s Selecting previously unselected package ssl-cert. 287s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 287s Unpacking ssl-cert (1.1.3ubuntu1) ... 287s Selecting previously unselected package postgresql-common. 287s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 287s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 287s Unpacking postgresql-common (282ubuntu1) ... 287s Selecting previously unselected package m4. 287s Preparing to unpack .../07-m4_1.4.20-2_amd64.deb ... 287s Unpacking m4 (1.4.20-2) ... 287s Selecting previously unselected package autoconf. 287s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 287s Unpacking autoconf (2.72-3.1ubuntu1) ... 287s Selecting previously unselected package autotools-dev. 287s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 287s Unpacking autotools-dev (20240727.1) ... 287s Selecting previously unselected package automake. 287s Preparing to unpack .../10-automake_1%3a1.18.1-2_all.deb ... 287s Unpacking automake (1:1.18.1-2) ... 287s Selecting previously unselected package autopoint. 287s Preparing to unpack .../11-autopoint_0.23.1-2build2_all.deb ... 287s Unpacking autopoint (0.23.1-2build2) ... 287s Selecting previously unselected package libisl23:amd64. 287s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 287s Unpacking libisl23:amd64 (0.27-1) ... 287s Selecting previously unselected package libmpc3:amd64. 287s Preparing to unpack .../13-libmpc3_1.3.1-1build3_amd64.deb ... 287s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 287s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 287s Preparing to unpack .../14-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package cpp-15. 287s Preparing to unpack .../15-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package cpp-x86-64-linux-gnu. 287s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 287s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 287s Selecting previously unselected package cpp. 287s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 287s Unpacking cpp (4:15.2.0-4ubuntu1) ... 287s Selecting previously unselected package libcc1-0:amd64. 287s Preparing to unpack .../18-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libgomp1:amd64. 287s Preparing to unpack .../19-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libitm1:amd64. 287s Preparing to unpack .../20-libitm1_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libasan8:amd64. 287s Preparing to unpack .../21-libasan8_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package liblsan0:amd64. 287s Preparing to unpack .../22-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libtsan2:amd64. 287s Preparing to unpack .../23-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libubsan1:amd64. 287s Preparing to unpack .../24-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libhwasan0:amd64. 287s Preparing to unpack .../25-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libquadmath0:amd64. 287s Preparing to unpack .../26-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package libgcc-15-dev:amd64. 287s Preparing to unpack .../27-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 287s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 287s Preparing to unpack .../28-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 287s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 288s Selecting previously unselected package gcc-15. 288s Preparing to unpack .../29-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 288s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 288s Selecting previously unselected package gcc-x86-64-linux-gnu. 288s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 288s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 288s Selecting previously unselected package gcc. 288s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 288s Unpacking gcc (4:15.2.0-4ubuntu1) ... 288s Selecting previously unselected package libstdc++-15-dev:amd64. 288s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 288s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 288s Selecting previously unselected package g++-15-x86-64-linux-gnu. 288s Preparing to unpack .../33-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 288s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 288s Selecting previously unselected package g++-15. 288s Preparing to unpack .../34-g++-15_15.2.0-7ubuntu1_amd64.deb ... 288s Unpacking g++-15 (15.2.0-7ubuntu1) ... 288s Selecting previously unselected package g++-x86-64-linux-gnu. 288s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 288s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 288s Selecting previously unselected package g++. 288s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 288s Unpacking g++ (4:15.2.0-4ubuntu1) ... 288s Selecting previously unselected package build-essential. 288s Preparing to unpack .../37-build-essential_12.12ubuntu1_amd64.deb ... 288s Unpacking build-essential (12.12ubuntu1) ... 288s Selecting previously unselected package libllvm21:amd64. 288s Preparing to unpack .../38-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 288s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 288s Selecting previously unselected package libclang-cpp21. 288s Preparing to unpack .../39-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 288s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 289s Selecting previously unselected package libgc1:amd64. 289s Preparing to unpack .../40-libgc1_1%3a8.2.10-1_amd64.deb ... 289s Unpacking libgc1:amd64 (1:8.2.10-1) ... 289s Selecting previously unselected package libobjc4:amd64. 289s Preparing to unpack .../41-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 289s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 289s Selecting previously unselected package libobjc-15-dev:amd64. 289s Preparing to unpack .../42-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 289s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 289s Selecting previously unselected package libclang-common-21-dev:amd64. 289s Preparing to unpack .../43-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 289s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 289s Selecting previously unselected package llvm-21-linker-tools. 289s Preparing to unpack .../44-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 289s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 289s Selecting previously unselected package libclang1-21. 289s Preparing to unpack .../45-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 289s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 289s Selecting previously unselected package clang-21. 289s Preparing to unpack .../46-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 289s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 289s Selecting previously unselected package libdebhelper-perl. 289s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 289s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 289s Selecting previously unselected package libtool. 289s Preparing to unpack .../48-libtool_2.5.4-4build1_all.deb ... 289s Unpacking libtool (2.5.4-4build1) ... 289s Selecting previously unselected package dh-autoreconf. 289s Preparing to unpack .../49-dh-autoreconf_21_all.deb ... 289s Unpacking dh-autoreconf (21) ... 289s Selecting previously unselected package libarchive-zip-perl. 289s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 289s Unpacking libarchive-zip-perl (1.68-1) ... 289s Selecting previously unselected package libfile-stripnondeterminism-perl. 289s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... 289s Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... 289s Selecting previously unselected package dh-strip-nondeterminism. 289s Preparing to unpack .../52-dh-strip-nondeterminism_1.15.0-1_all.deb ... 289s Unpacking dh-strip-nondeterminism (1.15.0-1) ... 289s Selecting previously unselected package debugedit. 289s Preparing to unpack .../53-debugedit_1%3a5.2-3_amd64.deb ... 289s Unpacking debugedit (1:5.2-3) ... 289s Selecting previously unselected package dwz. 289s Preparing to unpack .../54-dwz_0.16-2_amd64.deb ... 289s Unpacking dwz (0.16-2) ... 289s Selecting previously unselected package gettext. 289s Preparing to unpack .../55-gettext_0.23.1-2build2_amd64.deb ... 289s Unpacking gettext (0.23.1-2build2) ... 289s Selecting previously unselected package intltool-debian. 289s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 289s Unpacking intltool-debian (0.35.0+20060710.6) ... 289s Selecting previously unselected package po-debconf. 289s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 289s Unpacking po-debconf (1.0.21+nmu1) ... 289s Selecting previously unselected package debhelper. 289s Preparing to unpack .../58-debhelper_13.24.2ubuntu1_all.deb ... 289s Unpacking debhelper (13.24.2ubuntu1) ... 289s Selecting previously unselected package emacsen-common. 289s Preparing to unpack .../59-emacsen-common_3.0.8_all.deb ... 289s Unpacking emacsen-common (3.0.8) ... 289s Selecting previously unselected package dictionaries-common. 289s Preparing to unpack .../60-dictionaries-common_1.30.11_all.deb ... 289s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 289s Unpacking dictionaries-common (1.30.11) ... 289s Selecting previously unselected package libfakeroot:amd64. 289s Preparing to unpack .../61-libfakeroot_1.37.1.2-1_amd64.deb ... 289s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 289s Selecting previously unselected package fakeroot. 289s Preparing to unpack .../62-fakeroot_1.37.1.2-1_amd64.deb ... 289s Unpacking fakeroot (1.37.1.2-1) ... 289s Selecting previously unselected package hunspell-en-us. 289s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 289s Unpacking hunspell-en-us (1:2020.12.07-4) ... 289s Selecting previously unselected package libpgtypes3:amd64. 289s Preparing to unpack .../64-libpgtypes3_18.0-1_amd64.deb ... 289s Unpacking libpgtypes3:amd64 (18.0-1) ... 289s Selecting previously unselected package libpq5:amd64. 289s Preparing to unpack .../65-libpq5_18.0-1_amd64.deb ... 289s Unpacking libpq5:amd64 (18.0-1) ... 289s Selecting previously unselected package libecpg6:amd64. 289s Preparing to unpack .../66-libecpg6_18.0-1_amd64.deb ... 289s Unpacking libecpg6:amd64 (18.0-1) ... 289s Selecting previously unselected package libecpg-compat3:amd64. 289s Preparing to unpack .../67-libecpg-compat3_18.0-1_amd64.deb ... 289s Unpacking libecpg-compat3:amd64 (18.0-1) ... 289s Selecting previously unselected package libssl-dev:amd64. 289s Preparing to unpack .../68-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 289s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 289s Selecting previously unselected package libpq-dev. 289s Preparing to unpack .../69-libpq-dev_18.0-1_amd64.deb ... 289s Unpacking libpq-dev (18.0-1) ... 289s Selecting previously unselected package libecpg-dev. 289s Preparing to unpack .../70-libecpg-dev_18.0-1_amd64.deb ... 289s Unpacking libecpg-dev (18.0-1) ... 289s Selecting previously unselected package libicu76:amd64. 289s Preparing to unpack .../71-libicu76_76.1-4ubuntu2_amd64.deb ... 289s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 289s Selecting previously unselected package libncurses-dev:amd64. 289s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 289s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 289s Selecting previously unselected package libpq-oauth:amd64. 289s Preparing to unpack .../73-libpq-oauth_18.0-1_amd64.deb ... 289s Unpacking libpq-oauth:amd64 (18.0-1) ... 289s Selecting previously unselected package libtcl8.6:amd64. 289s Preparing to unpack .../74-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 289s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 289s Selecting previously unselected package liburing2:amd64. 289s Preparing to unpack .../75-liburing2_2.12-1_amd64.deb ... 289s Unpacking liburing2:amd64 (2.12-1) ... 289s Selecting previously unselected package liblzma-dev:amd64. 289s Preparing to unpack .../76-liblzma-dev_5.8.1-1build2_amd64.deb ... 289s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 289s Selecting previously unselected package zlib1g-dev:amd64. 289s Preparing to unpack .../77-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 289s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 289s Selecting previously unselected package libxml2-dev:amd64. 289s Preparing to unpack .../78-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 289s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 289s Selecting previously unselected package libxslt1.1:amd64. 289s Preparing to unpack .../79-libxslt1.1_1.1.43-0.3_amd64.deb ... 289s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 289s Selecting previously unselected package llvm-21-runtime. 289s Preparing to unpack .../80-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 289s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 290s Selecting previously unselected package libpfm4:amd64. 290s Preparing to unpack .../81-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 290s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 290s Selecting previously unselected package llvm-21. 290s Preparing to unpack .../82-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 290s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 290s Selecting previously unselected package libffi-dev:amd64. 290s Preparing to unpack .../83-libffi-dev_3.5.2-2_amd64.deb ... 290s Unpacking libffi-dev:amd64 (3.5.2-2) ... 290s Selecting previously unselected package llvm-21-tools. 290s Preparing to unpack .../84-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 290s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 290s Selecting previously unselected package llvm-21-dev. 290s Preparing to unpack .../85-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 290s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 291s Selecting previously unselected package locales-all. 291s Preparing to unpack .../86-locales-all_2.42-0ubuntu3_amd64.deb ... 291s Unpacking locales-all (2.42-0ubuntu3) ... 292s Selecting previously unselected package postgresql-client-18. 292s Preparing to unpack .../87-postgresql-client-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-client-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-18. 292s Preparing to unpack .../88-postgresql-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-18-jit. 292s Preparing to unpack .../89-postgresql-18-jit_18.0-1_amd64.deb ... 292s Unpacking postgresql-18-jit (18.0-1) ... 292s Selecting previously unselected package postgresql-doc-18. 292s Preparing to unpack .../90-postgresql-doc-18_18.0-1_all.deb ... 292s Unpacking postgresql-doc-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-plperl-18. 292s Preparing to unpack .../91-postgresql-plperl-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-plperl-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-plpython3-18. 292s Preparing to unpack .../92-postgresql-plpython3-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-plpython3-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-pltcl-18. 292s Preparing to unpack .../93-postgresql-pltcl-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-pltcl-18 (18.0-1) ... 292s Selecting previously unselected package postgresql-server-dev-18. 292s Preparing to unpack .../94-postgresql-server-dev-18_18.0-1_amd64.deb ... 292s Unpacking postgresql-server-dev-18 (18.0-1) ... 292s Setting up postgresql-client-common (282ubuntu1) ... 292s Setting up libpgtypes3:amd64 (18.0-1) ... 292s Setting up postgresql-doc-18 (18.0-1) ... 292s 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 292s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 292s Setting up libio-pty-perl (1:1.20-1build3) ... 292s Setting up libarchive-zip-perl (1.68-1) ... 292s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 292s Setting up libpq5:amd64 (18.0-1) ... 292s Setting up m4 (1.4.20-2) ... 292s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 292s Setting up libffi-dev:amd64 (3.5.2-2) ... 292s Setting up locales-all (2.42-0ubuntu3) ... 292s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 292s Setting up fakeroot (1.37.1.2-1) ... 292s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 292s Setting up autotools-dev (20240727.1) ... 292s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 292s Setting up emacsen-common (3.0.8) ... 292s Setting up ssl-cert (1.1.3ubuntu1) ... 293s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 293s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 293s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 293s Setting up libmpc3:amd64 (1.3.1-1build3) ... 293s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 293s Setting up autopoint (0.23.1-2build2) ... 293s Setting up libipc-run-perl (20231003.0-2) ... 293s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 293s Setting up libgc1:amd64 (1:8.2.10-1) ... 293s Setting up autoconf (2.72-3.1ubuntu1) ... 293s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 293s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 293s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 293s Setting up dwz (0.16-2) ... 293s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libjson-perl (4.10000-1) ... 293s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 293s Setting up debugedit (1:5.2-3) ... 293s Setting up libecpg6:amd64 (18.0-1) ... 293s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 293s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 293s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 293s Setting up liburing2:amd64 (2.12-1) ... 293s Setting up libisl23:amd64 (0.27-1) ... 293s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 293s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 293s Setting up postgresql-common-dev (282ubuntu1) ... 293s Setting up automake (1:1.18.1-2) ... 293s update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode 293s Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... 293s Setting up gettext (0.23.1-2build2) ... 293s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 293s Setting up libecpg-compat3:amd64 (18.0-1) ... 293s Setting up postgresql-client-18 (18.0-1) ... 293s 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 293s Setting up dictionaries-common (1.30.11) ... 293s Setting up libpq-oauth:amd64 (18.0-1) ... 293s Setting up libpq-dev (18.0-1) ... 293s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 293s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 293s Setting up libecpg-dev (18.0-1) ... 293s Setting up intltool-debian (0.35.0+20060710.6) ... 293s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 293s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 293s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 293s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 293s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 293s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 293s Setting up postgresql-common (282ubuntu1) ... 293s Creating config file /etc/postgresql-common/createcluster.conf with new version 293s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 293s en_us 293s Removing obsolete dictionary files: 294s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 294s Setting up dh-strip-nondeterminism (1.15.0-1) ... 294s Setting up cpp-15 (15.2.0-7ubuntu1) ... 294s Setting up hunspell-en-us (1:2020.12.07-4) ... 294s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 294s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 294s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 294s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 294s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 294s Setting up po-debconf (1.0.21+nmu1) ... 294s Setting up postgresql-18 (18.0-1) ... 294s Creating new PostgreSQL cluster 18/main ... 294s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 294s The files belonging to this database system will be owned by user "postgres". 294s This user must also own the server process. 294s 294s The database cluster will be initialized with locale "C.UTF-8". 294s The default database encoding has accordingly been set to "UTF8". 294s The default text search configuration will be set to "english". 294s 294s Data page checksums are enabled. 294s 294s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 294s creating subdirectories ... ok 294s selecting dynamic shared memory implementation ... posix 294s selecting default "max_connections" ... 100 294s selecting default "shared_buffers" ... 128MB 294s selecting default time zone ... Etc/UTC 294s creating configuration files ... ok 295s running bootstrap script ... ok 295s performing post-bootstrap initialization ... ok 295s syncing data to disk ... ok 297s Setting up postgresql-18-jit (18.0-1) ... 297s Setting up gcc-15 (15.2.0-7ubuntu1) ... 297s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 297s Setting up postgresql-plpython3-18 (18.0-1) ... 297s Setting up cpp (4:15.2.0-4ubuntu1) ... 297s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 297s Setting up postgresql-plperl-18 (18.0-1) ... 297s Setting up g++-15 (15.2.0-7ubuntu1) ... 297s Setting up postgresql-pltcl-18 (18.0-1) ... 297s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 297s Setting up libtool (2.5.4-4build1) ... 297s Setting up postgresql-server-dev-18 (18.0-1) ... 297s Setting up gcc (4:15.2.0-4ubuntu1) ... 297s Setting up dh-autoreconf (21) ... 297s Setting up g++ (4:15.2.0-4ubuntu1) ... 297s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 297s Setting up build-essential (12.12ubuntu1) ... 297s Setting up debhelper (13.24.2ubuntu1) ... 297s Processing triggers for man-db (2.13.1-1) ... 299s Processing triggers for install-info (7.2-5) ... 299s Processing triggers for libc-bin (2.42-0ubuntu3) ... 299s Processing triggers for systemd (257.9-0ubuntu2) ... 299s Processing triggers for dictionaries-common (1.30.11) ... 302s autopkgtest [23:28:17]: test run-testsuite: [----------------------- 302s ====== Running all tests with umask 077 ======= 302s ### PostgreSQL test 001_packages.t ### 302s 1..23 302s ok 1 - /etc/os-release exists 302s ok 2 - OS is ubuntu 302s ok 3 - OS version is 26.04 302s # PostgreSQL versions installed: 18 302s # 18 302s ok 4 - postgresql-18 installed 302s ok 5 - postgresql-plpython3-18 installed 302s ok 6 - postgresql-plperl-18 installed 302s ok 7 - postgresql-pltcl-18 installed 302s ok 8 - postgresql-18-jit installed 302s ok 9 - postgresql-server-dev-18 installed 302s ok 10 # skip No postgresql-contrib-18 package for version 18 302s # postgresql-doc-18 installed 302s ok 11 - At least one doc package installed 302s ok 12 - libecpg-dev installed 302s ok 13 - postgresql-common-dev installed 302s ok 14 - procps installed 302s ok 15 - netcat-openbsd installed 302s ok 16 - hunspell-en-us installed 302s ok 17 - system has a default UTF-8 locale 302s ok 18 - locale ru_RU exists 302s ok 19 - locale ru_RU.UTF-8 exists 302s ok 20 - user postgres in the UNIX group ssl-cert 302s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 302s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 302s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 302s ### End test 001_packages.t ### 302s 302s ### PostgreSQL test 002_existing_clusters.t ### 302s 1..8 302s # Cleanup 302s ok 1 - Cleanup: No clusters left behind 302s ok 2 - No postgres processes left behind 302s ok 3 - No files in /etc/postgresql left behind 302s ok 4 - No files in /var/lib/postgresql left behind 302s ok 5 - No files in /var/run/postgresql left behind 302s ok 6 - No files in /var/log/postgresql left behind 302s ok 7 - PostgreSQL TCP ports are closed 302s ok 8 - Next free port is 5432 302s ### End test 002_existing_clusters.t ### 302s 302s ### PostgreSQL test 003_alternatives.t ### 302s 1..9 302s # Newest PG version installed is 18 302s ok 1 - psql.1.gz link group 302s ok 2 - postmaster.1.gz link group does not exist 302s ok 3 - psql.1.gz alternative 302s ok 4 - pg_dump.1.gz alternative 302s ok 5 - postgres.1.gz alternative 302s ok 6 - pg_ctl.1.gz alternative 302s # Newest PG doc version installed is 18 302s ok 7 - SPI_connect.3.gz link group 302s ok 8 - SPI_connect.3.gz alternative 302s ok 9 - SPI_exec.3.gz alternative 302s ### End test 003_alternatives.t ### 302s 302s ### PostgreSQL test 005_PgCommon.t ### 302s 1..24 302s ok 1 - correctly parsed line 'local all postgres ident sameuser' 302s ok 2 - correctly parsed line 'local foo nobody trust' 302s ok 3 - correctly parsed line 'local foo nobody crypt' 302s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 302s ok 5 - correctly parsed line 'local foo,bar nobody ident' 302s ok 6 - correctly parsed line 'local all +foogrp password' 302s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 302s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 302s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 302s ok 10 - @expected_records has correct number of entries 302s ok 11 - returned read_pg_hba array has correct number of records 302s ok 12 - line 'foo all all md5' parsed as invalid 302s ok 13 - line 'local all all foo' parsed as invalid 302s ok 14 - line 'host all all foo' parsed as invalid 302s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 302s ok 16 - line 'host all all md5' parsed as invalid 302s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 302s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 302s ok 19 - read_conf_file returns empty dict for nonexisting file 302s ok 20 - read_conf_file() parsing 302s ok 21 - read_conf_file() parsing with include directives 302s ok 22 - set_conf_value 302s ok 23 - disable_conf_value 302s ok 24 - replace_conf_value 302s ### End test 005_PgCommon.t ### 302s 302s ### PostgreSQL test 006_next_free_port.t ### 302s 1..5 302s ok 1 - next_free_port is 5432 303s ok 2 - next_free_port detects localhost ipv4 socket 304s ok 3 - next_free_port detects wildcard ipv4 socket 305s ok 4 - next_free_port detects localhost ipv6 socket 306s ok 5 - next_free_port detects wildcard ipv6 socket 306s ### End test 006_next_free_port.t ### 306s 306s ### PostgreSQL test 007_pg_conftool.t ### 306s 1..41 306s # test without cluster 306s ok 1 - pg_conftool show all 306s ok 2 - correct output of pg_conftool show all 307s ok 3 - pg_conftool foo.conf show all 307s ok 4 - correct output of pg_conftool foo.conf show all 307s ok 5 - pg_conftool /tmp/RE8VbpdAOp/different.conf show all 307s ok 6 - correct output of pg_conftool /tmp/RE8VbpdAOp/different.conf show all 307s ok 7 - pg_conftool 9.7 main show all 307s ok 8 - correct output of pg_conftool 9.7 main show all 307s # test show 307s ok 9 - pg_conftool show all 307s ok 10 - correct output of pg_conftool show all 307s ok 11 - pg_conftool other.conf show all 307s ok 12 - correct output of pg_conftool other.conf show all 307s ok 13 - pg_conftool /tmp/RE8VbpdAOp/different.conf show all 307s ok 14 - correct output of pg_conftool /tmp/RE8VbpdAOp/different.conf show all 307s ok 15 - pg_conftool 18 main show all 307s ok 16 - correct output of pg_conftool 18 main show all 307s ok 17 - pg_conftool 18 main other.conf show all 307s ok 18 - correct output of pg_conftool 18 main other.conf show all 307s ok 19 - pg_conftool show a 307s ok 20 - correct output of pg_conftool show a 307s ok 21 - pg_conftool -s show a 307s ok 22 - correct output of pg_conftool -s show a 307s # test set 307s ok 23 - pg_conftool set c 7 307s ok 24 - correct output of pg_conftool set c 7 307s ok 25 - file contains new setting 307s ok 26 - pg_conftool set a 8 307s ok 27 - correct output of pg_conftool set a 8 307s ok 28 - file contains updated setting 307s ok 29 - pg_conftool /tmp/RE8VbpdAOp/different.conf set a 9 307s ok 30 - correct output of pg_conftool /tmp/RE8VbpdAOp/different.conf set a 9 307s ok 31 - file with path contains updated setting 307s # test remove 307s ok 32 - pg_conftool remove a 307s ok 33 - correct output of pg_conftool remove a 307s ok 34 - setting removed from file 307s ok 35 - pg_conftool /tmp/RE8VbpdAOp/different.conf remove a 307s ok 36 - correct output of pg_conftool /tmp/RE8VbpdAOp/different.conf remove a 307s ok 37 - setting removed from file with path 307s # test edit 307s ok 38 - pg_conftool edit 307s ok 39 - correct output of pg_conftool edit 307s ok 40 - pg_conftool /tmp/RE8VbpdAOp/different.conf edit 307s ok 41 - correct output of pg_conftool /tmp/RE8VbpdAOp/different.conf edit 307s ### End test 007_pg_conftool.t ### 307s 307s ### PostgreSQL test 010_defaultport_cluster.t ### 307s 1..14 307s ok 1 - psql --version 307s ok 2 - pg_wrapper selects highest available version number 307s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 307s ok 4 - connecting to localhost fails with no clusters 307s ok 5 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -l 307s ok 6 - pg_wrapper uses host and port from PGCLUSTER 307s ok 7 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --cluster 18/127.0.0.3:5430 -l 307s ok 8 - pg_wrapper uses --cluster from the command line 307s ok 9 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -h 127.0.0.3 -l 307s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 307s ok 11 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --host 127.0.0.3 -l 307s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 307s ok 13 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 307s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 307s ### End test 010_defaultport_cluster.t ### 307s 307s ### PostgreSQL test 015_start_stop.t ### 307s 1..71 307s # We are running systemd 307s # Running tests for 18 307s # Cluster does not exist yet 307s ok 1 - cluster 18 main does not exist 307s ok 2 - service postgresql@18-main does not exist 307s ok 3 - systemctl start postgresql 307s ok 4 - cluster 18 main does not exist 307s ok 5 - service postgresql@18-main does not exist 307s ok 6 - systemctl start postgresql@18-main 307s ok 7 - cluster 18 main does not exist 307s ok 8 - service postgresql@18-main does not exist 307s # Start/stop postgresql using system tools 308s ok 9 - pg_createcluster 18 main 308s ok 10 - cluster 18 main is stopped 308s ok 11 - service postgresql@18-main is stopped 310s ok 12 - systemctl start postgresql 310s ok 13 - cluster 18 main is running 310s ok 14 - service postgresql@18-main is running 310s ok 15 - systemctl start postgresql 310s ok 16 - cluster 18 main is already running 310s ok 17 - service postgresql@18-main is already running 310s ok 18 - systemctl stop postgresql 316s ok 19 - cluster 18 main is stopped 316s ok 20 - service postgresql@18-main is stopped 316s ok 21 - systemctl stop postgresql 316s ok 22 - cluster 18 main is already stopped 316s ok 23 - service postgresql@18-main is already stopped 316s # Start/stop specific cluster using system tools 318s ok 24 - systemctl start postgresql@18-main 318s ok 25 - cluster 18 main is running 318s ok 26 - service postgresql@18-main is running 319s ok 27 - systemctl start postgresql@18-main 319s ok 28 - cluster 18 main is running 319s ok 29 - service postgresql@18-main is running 321s ok 30 - systemctl restart postgresql@18-main 321s ok 31 - cluster 18 main is running 321s ok 32 - service postgresql@18-main is running 321s ok 33 - systemctl stop postgresql@18-main 321s ok 34 - cluster 18 main is stopped 321s ok 35 - service postgresql@18-main is stopped 321s ok 36 - systemctl stop postgresql@18-main 321s ok 37 - cluster 18 main is already stopped 321s ok 38 - service postgresql@18-main is already stopped 322s ok 39 - pg_dropcluster 18 main 322s ok 40 - cluster 18 main does not exist 322s ok 41 - service postgresql@18-main does not exist 322s # Start/stop specific cluster using pg_*cluster 322s ok 42 - pg_ctlcluster start 18 main 322s ok 43 - cluster 18 main does not exist 322s ok 44 - service postgresql@18-main does not exist 325s ok 45 - pg_createcluster 18 main --start 325s ok 46 - cluster 18 main is running 325s ok 47 - service postgresql@18-main is running 325s ok 48 - pg_ctlcluster 18 main start 325s ok 49 - cluster 18 main is already running 325s ok 50 - service postgresql@18-main is already running 327s ok 51 - pg_ctlcluster 18-main restart 327s ok 52 - cluster 18 main is running 327s ok 53 - service postgresql@18-main is running 327s ok 54 - pg_ctlcluster 18 main stop 327s ok 55 - cluster 18 main is stopped 327s ok 56 - service postgresql@18-main is stopped 328s ok 57 - pg_ctlcluster 18 main stop 328s ok 58 - cluster 18 main is already stopped 328s ok 59 - service postgresql@18-main is already stopped 330s ok 60 - pg_ctlcluster start 18-main 330s ok 61 - cluster 18 main is running 330s ok 62 - service postgresql@18-main is running 331s ok 63 - pg_dropcluster 18 main --stop 331s # Cleanup 331s ok 64 - Cleanup: No clusters left behind 331s ok 65 - No postgres processes left behind 331s ok 66 - No files in /etc/postgresql left behind 331s ok 67 - No files in /var/lib/postgresql left behind 331s ok 68 - No files in /var/run/postgresql left behind 331s ok 69 - No files in /var/log/postgresql left behind 331s ok 70 - PostgreSQL TCP ports are closed 331s ok 71 - Next free port is 5432 331s ### End test 015_start_stop.t ### 331s 331s ### PostgreSQL test 020_create_sql_remove.t ### 331s 1..141 331s # Running tests for 18 334s ok 1 - pg_createcluster 18 main --start -- -X /tmp/18.xlog.MKOgHI 334s ok 2 - pg_createcluster 18 main 334s ok 3 - Socket and pid file are in /var/run/postgresql/ 334s ok 4 - xlog/wal directory /tmp/18.xlog.MKOgHI was created 334s ok 5 - local method in pg_hba.conf is peer 334s ok 6 - host method in pg_hba.conf is scram-sha-256 334s ok 7 - Exactly one postgres master process running 336s ok 8 - pg_ctlcluster 18 main restart 336s ok 9 - cluster restarts with new environment file 336s ok 10 - Exactly one postgres master process running 336s ok 11 - correct value of PGEXTRAVAR1 in environment 336s ok 12 - correct value of PGEXTRAVAR2 in environment 336s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 336s ok 14 - createdb --version 336s ok 15 - pg_wrapper+createdb selects version number of cluster 336s ok 16 - psql --version 336s ok 17 - pg_wrapper+psql selects version 18 336s ok 18 - pg_lscluster reports online cluster on port 5432 336s ok 19 - log file is actually used 336s ok 20 - /etc/postgresql is owned by user "postgres" 336s ok 21 - version configuration directory file is owned by user "postgres" 336s ok 22 - configuration directory file is owned by user "postgres" 336s ok 23 - version data directory file is owned by user "postgres" 336s ok 24 - data directory file is owned by user "postgres" 336s ok 25 - log file has 0640 permissions 336s ok 26 - log file is owned by user "postgres" 336s ok 27 - log file is owned by group "adm" 336s ok 28 - no log symlink by default 336s ok 29 - /var/log/postgresql/postgresql-18-main.log is the default log if log symlink is missing 336s ok 30 - pg_lsclusters -h 336s ok 31 - correct output of pg_lsclusters -h 336s ok 32 - stopping cluster 339s ok 33 - restarting cluster with nondefault log symlink 339s ok 34 - log target is used as log file 339s ok 35 - default log is not used 339s ok 36 - pg_lsclusters -h 339s ok 37 - correct output of pg_lsclusters -h 339s ok 38 - stopping cluster 342s ok 39 - restarting cluster with explicitly configured log file 342s ok 40 - default log is not used 342s ok 41 - log symlink target is used for startup message 342s ok 42 - exactly one log file 342s ok 43 - custom log is actually used 342s ok 44 - pg_lsclusters -h 342s ok 45 - correct output of pg_lsclusters -h 342s ok 46 - stopping cluster 342s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 342s ok 48 - /etc/postgres-hack was not created 344s ok 49 - restarting cluster 344s ok 50 - ps -o tty -U postgres h 344s ok 51 - postgres processes do not have an associated terminal 344s ok 52 - Server is linked with SSL support 344s ok 53 - SSL is enabled in postgresql.conf 344s ok 54 - psql -l fails for nobody 344s ok 55 - createuser nobody 344s ok 56 - createdb nobodydb 344s ok 57 - psql -ltA succeeds for nobody 344s ok 58 - psql -ltA output 344s ok 59 - SQL command: create table 344s ok 60 - SQL command: insert into table values 344s ok 61 - SQL command: insert into table values 344s ok 62 - primary key violation 344s ok 63 - psql -tAc "select * from phone order by name" nobodydb 344s ok 64 - SQL command output: select -tA 344s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 344s ok 66 - SQL command output: select -tx 344s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 344s ok 68 - SQL command output: select -tAx 344s ok 69 - CREATE EXTENSION plperlu fails for user nobody 344s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 344s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 344s ok 72 - creating PL/PerlU function as user nobody fails 344s ok 73 - creating unsafe PL/Perl function as user postgres fails 344s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 344s ok 75 - creating PL/PerlU function as user postgres succeeds 345s ok 76 - psql nobodydb -Atc "select read_file()" 345s ok 77 - calling PL/PerlU function 345s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 345s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 345s ok 80 - creating unsafe PL/Perl function as user nobody fails 345s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 345s ok 82 - creating PL/Perl function as user nobody succeeds 345s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 345s ok 84 - calling PL/Perl function 345s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 345s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 345s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 345s ok 88 - creating PL/Python3 function as user postgres succeeds 345s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 345s ok 90 - calling PL/Python function 345s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 345s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 345s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 345s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 345s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 345s ok 96 - creating PL/Tcl function as user nobody succeeds 345s 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;" 345s ok 98 - creating PL/TclU function as user postgres succeeds 345s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 345s ok 100 - calling PL/Tcl function 345s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 345s ok 102 - calling PL/TclU function 345s ok 103 - stopping cluster 345s ok 104 - pg_ctlcluster 18 main start 345s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 347s ok 106 - pg_ctlcluster 18 main start 347s ok 107 - cluster restarts with pgdata symlink 348s ok 108 - postgres master has OOM killer protection 348s ok 109 - postgres client backend has no OOM adjustment 348s ok 110 - ps h 6888 348s ok 111 - process title is idle 348s ok 112 - ps h 6888 348s ok 113 - process title is idle in transaction 348s ok 114 - stopping cluster 351s ok 115 - starting cluster as postgres works without a log file 351s ok 116 - log file got recreated and used 351s ok 117 - creating a directory in spc2 351s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/18.spc1.JEABWH'" 351s ok 119 - creating tablespace spc1 351s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 351s ok 121 - creating a table in spc1 351s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/18.spc2.tZt81s'" 351s ok 123 - creating tablespace spc2 351s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 351s ok 125 - creating a table in spc2 351s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 351s ok 127 - Correct apt NeverAutoRemove config 352s ok 128 - pg_dropcluster removes cluster 352s ok 129 - xlog/wal directory /tmp/18.xlog.MKOgHI was deleted 352s ok 130 - tablespace spc1 was emptied 352s ok 131 - tablespace spc2 was emptied 352s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 352s ok 133 - Correct apt NeverAutoRemove config 352s # Cleanup 352s ok 134 - Cleanup: No clusters left behind 352s ok 135 - No postgres processes left behind 352s ok 136 - No files in /etc/postgresql left behind 352s ok 137 - No files in /var/lib/postgresql left behind 352s ok 138 - No files in /var/run/postgresql left behind 352s ok 139 - No files in /var/log/postgresql left behind 352s ok 140 - PostgreSQL TCP ports are closed 352s ok 141 - Next free port is 5432 352s ### End test 020_create_sql_remove.t ### 352s 352s ### PostgreSQL test 021_pg_renamecluster.t ### 352s 1..20 355s ok 1 - pg_createcluster 18 main 357s ok 2 - pg_renamecluster 18 main donau 357s ok 3 - psql -tAc "show data_directory" 357s ok 4 - cluster is running and data_directory was moved 357s ok 5 - pg_hba.conf location updated 357s ok 6 - pg_ident.conf location updated 357s ok 7 - external_pid_file location updated 357s ok 8 - external_pid_file exists 357s ok 9 # skip no stats_temp_directory in 18 357s ok 10 # skip no stats_temp_directory in 18 357s ok 11 - cluster_name is updated 358s ok 12 - pg_dropcluster removes cluster 358s # Cleanup 358s ok 13 - Cleanup: No clusters left behind 358s ok 14 - No postgres processes left behind 358s ok 15 - No files in /etc/postgresql left behind 358s ok 16 - No files in /var/lib/postgresql left behind 358s ok 17 - No files in /var/run/postgresql left behind 358s ok 18 - No files in /var/log/postgresql left behind 358s ok 19 - PostgreSQL TCP ports are closed 358s ok 20 - Next free port is 5432 358s ### End test 021_pg_renamecluster.t ### 358s 358s ### PostgreSQL test 022_recovery.t ### 358s 1..17 358s # Running tests for 18 361s ok 1 - pg_createcluster 18 main --start >/dev/null 361s ok 2 - pg_ctlcluster 18 main stop -m i 363s ok 3 - pg_ctlcluster 18 main start 364s ok 4 - psql -c '' 364s ok 5 - pg_ctlcluster 18 main stop -m i 364s ok 6 - create write-protected file in data directory 366s ok 7 - pg_ctlcluster 18 main start 366s ok 8 - psql -c '' 367s ok 9 - pg_dropcluster removes cluster 367s # Cleanup 367s ok 10 - Cleanup: No clusters left behind 367s ok 11 - No postgres processes left behind 367s ok 12 - No files in /etc/postgresql left behind 367s ok 13 - No files in /var/lib/postgresql left behind 367s ok 14 - No files in /var/run/postgresql left behind 367s ok 15 - No files in /var/log/postgresql left behind 367s ok 16 - PostgreSQL TCP ports are closed 367s ok 17 - Next free port is 5432 367s ### End test 022_recovery.t ### 367s 367s ### PostgreSQL test 025_logging.t ### 367s 1..55 367s # Logging to /var/log/syslog works 367s # Running tests for 18 370s ok 1 - pg_createcluster 18 main 370s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-18-main.log 370s ok 3 - psql -qc "'foobar_18_8096'" 370s ok 4 - log an error 371s ok 5 - grep --binary-files=text foobar_18_8096 /var/log/postgresql/postgresql-18-main.log 371s ok 6 - error appears in logfile 371s ok 7 - pg_conftool 18 main set log_destination syslog 371s ok 8 - set log_destination syslog 371s ok 9 - pg_ctlcluster 18 main reload 371s ok 10 - 18 main reload 371s ok 11 - psql -Atc "show log_destination" 371s ok 12 - log_destination is syslog 371s ok 13 - pg_lscluster reports syslog 371s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 371s ok 15 - error appears in /var/log/syslog 371s ok 16 - pg_conftool 18 main set logging_collector on 371s ok 17 - set logging_collector on 371s ok 18 - pg_conftool 18 main set log_destination csvlog 371s ok 19 - set log_destination csvlog 374s ok 20 - pg_ctlcluster 18 main restart 374s ok 21 - 18 main restart 374s ok 22 - psql -Atc "show logging_collector" 374s ok 23 - logging_collector is on 374s ok 24 - psql -Atc "show log_destination" 374s ok 25 - log_destination is csvlog 374s ok 26 - pg_lscluster reports csvlog 374s ok 27 - psql -qc "'barbaz_18_8096'" 374s ok 28 - log an error 374s ok 29 - grep --binary-files=text barbaz_18_8096 /var/lib/postgresql/18/main/log/*.csv 374s ok 30 - error appears in log/*.csv 374s ok 31 - pg_conftool 18 main set log_destination stderr,syslog,csvlog 374s ok 32 - set log_destination stderr,syslog,csvlog 374s ok 33 - pg_ctlcluster 18 main reload 374s ok 34 - 18 main reload 374s ok 35 - psql -Atc "show log_destination" 374s ok 36 - log_destination is stderr,syslog,csvlog 374s ok 37 - pg_lscluster reports stderr,syslog,csvlog 375s ok 38 - psql -qc "'moo_18_8096'" 375s ok 39 - log an error 375s ok 40 - grep --binary-files=text moo_18_8096 /var/lib/postgresql/18/main/log/*.log 375s ok 41 - error appears in log/*.log 376s ok 42 - grep --binary-files=text 'postgres.*moo_18_8096' /var/log/syslog 376s ok 43 - error appears in /var/log/syslog 376s ok 44 - grep --binary-files=text moo_18_8096 /var/lib/postgresql/18/main/log/*.csv 376s ok 45 - error appears in log/*.csv 377s ok 46 - pg_dropcluster 18 main --stop 377s ok 47 - pg_dropcluster removes cluster 377s # Cleanup 377s ok 48 - Cleanup: No clusters left behind 377s ok 49 - No postgres processes left behind 377s ok 50 - No files in /etc/postgresql left behind 377s ok 51 - No files in /var/lib/postgresql left behind 377s ok 52 - No files in /var/run/postgresql left behind 377s ok 53 - No files in /var/log/postgresql left behind 377s ok 54 - PostgreSQL TCP ports are closed 377s ok 55 - Next free port is 5432 377s ### End test 025_logging.t ### 377s 377s ### PostgreSQL test 027_jit.t ### 377s # 18 379s ok 1 - pg_createcluster 18 main --start 379s ok 2 - psql -Xatc 'show jit' 379s ok 3 - JIT is on by default 379s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 379s ok 5 - No JIT on cheap query 379s ok 6 - pg_conftool 18 main set seq_page_cost 100000 379s ok 7 - pg_conftool 18 main set random_page_cost 100000 380s ok 8 - pg_ctlcluster 18 main reload 380s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 380s ok 10 - Expensive query is JITed 381s ok 11 - pg_dropcluster --stop 18 main 381s # Cleanup 381s ok 12 - Cleanup: No clusters left behind 381s ok 13 - No postgres processes left behind 381s ok 14 - No files in /etc/postgresql left behind 381s ok 15 - No files in /var/lib/postgresql left behind 381s ok 16 - No files in /var/run/postgresql left behind 381s ok 17 - No files in /var/log/postgresql left behind 381s ok 18 - PostgreSQL TCP ports are closed 381s ok 19 - Next free port is 5432 381s 1..19 381s ### End test 027_jit.t ### 381s 381s ### PostgreSQL test 030_errors.t ### 381s 1..156 381s ok 1 - pg_lscluster reports cluster without binaries 381s ok 2 - pg_dropcluster 6.3 main 382s ok 3 - pg_createcluster --socketdir 382s ok 4 - pg_lsclusters -h 382s ok 5 - cluster was created 382s ok 6 - Port of created cluster is 5432 382s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 18 main 382s ok 8 - pg_createcluster on existing cluster 382s ok 9 - pg_lsclusters -h 382s ok 10 - original cluster still exists 382s ok 11 - pg_createcluster 18 test -p foo 382s ok 12 - pg_createcluster -p checks that port option is numeric 382s ok 13 - pg_createcluster 18 test -p 42 382s ok 14 - pg_createcluster -p checks valid port range 382s ok 15 - pg_ctlcluster 18 main start 382s ok 16 - pg_ctlcluster refuses to start root-owned cluster 382s ok 17 - pg_ctlcluster 18 main start 382s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 382s ok 19 - pg_ctlcluster 18 main start 382s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 382s ok 21 - pg_ctlcluster 18 main start 382s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 384s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 384s ok 24 - No sockets in /var/run/postgresql 384s ok 25 - Socket is in /tmp/postgresql-testsuite/ 385s ok 26 - cluster stops with custom unix_socket_dir 385s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 387s ok 28 - cluster starts after removing unix_socket_dir 387s ok 29 - Socket is in default dir /var/run/postgresql 387s ok 30 - No sockets in /tmp/postgresql-testsuite/ 387s ok 31 - pg_ctlcluster 18 main stop 387s ok 32 - pg_ctlcluster fails with corrupted PID file 387s ok 33 - pg_lsclusters -h 387s ok 34 - cluster is still online 387s ok 35 - pg_ctlcluster succeeds with restored PID file 387s ok 36 - pg_lsclusters -h 387s ok 37 - cluster is down 387s ok 38 - pg_ctlcluster 18 main stop 387s ok 39 - pg_ctlcluster stop fails on stopped cluster 389s ok 40 - pg_ctlcluster 18 main start 389s ok 41 - pg_ctlcluster succeeds with already existing PID file 389s ok 42 - pg_lsclusters -h 389s ok 43 - cluster is online 389s ok 44 - pg_ctlcluster stop succeeds 389s ok 45 - pg_lsclusters -h 389s ok 46 - cluster is down 389s ok 47 - no pid file left 389s ok 48 - pg_ctlcluster 18 main stop 389s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 389s ok 50 - pid file was cleaned up 389s ok 51 - pg_ctlcluster --force 18 main stop 389s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 389s ok 53 - pid file was cleaned up 389s ok 54 - pg_ctlcluster 18 main stop 389s ok 55 - pg_ctlcluster stop succeeds with stale PID file 389s ok 56 - pid file was cleaned up 389s ok 57 - pg_ctlcluster --force 18 main stop 389s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 389s ok 59 - pid file was cleaned up 390s ok 60 - pg_ctlcluster --force 18 main stop 390s ok 61 - pg_ctlcluster stop succeeds with empty PID file 390s ok 62 - pid file was cleaned up 392s ok 63 - pg_ctlcluster 18 main start 392s ok 64 - pg_ctlcluster succeeds with corrupted PID file 392s ok 65 - pg_lsclusters -h 392s ok 66 - cluster is online 392s ok 67 - pg_ctlcluster 18 main start 392s ok 68 - pg_ctlcluster start fails on running cluster 392s ok 69 - pg_ctlcluster stop 392s ok 70 - pg_ctlcluster 18 main start 392s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 392s ok 72 - pg_ctlcluster 18 main stop 392s ok 73 - stopping cluster 398s ok 74 - pg_ctlcluster 18 main start 398s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 398s ok 76 - pg_ctlcluster 18 main stop 398s ok 77 - stopping cluster 398s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 398s ok 79 - pg_dropcluster 18 main 398s ok 80 - pg_dropcluster works as user postgres 399s ok 81 - pg_createcluster succeeds 399s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 399s ok 83 - proper error message for nonexisting /var/lib/postgresql 401s ok 84 - pg_ctlcluster 18 main start 401s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 401s ok 86 - pg_ctlcluster 18 main stop 401s ok 87 - stopping cluster 402s ok 88 - pg_createcluster other 404s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 406s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 406s ok 91 406s ok 92 - pg_ctlcluster 18 other start 406s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 407s ok 94 - pg_ctlcluster 18 main stop 407s ok 95 - stopping main cluster 409s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 410s ok 97 - pg_dropcluster other 411s ok 98 - pg_dropcluster 411s ok 99 - No sockets any more 411s ok 100 - 'pg_lsclusters 4.5 foo' fails 411s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 411s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 411s ok 103 - 'psql --cluster 4.5/foo' fails 411s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 411s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 411s ok 106 - 'psql --cluster 18/foo' fails 411s ok 107 - psql --cluster 18/foo gives error message about nonexisting cluster 411s ok 108 - psql --cluster 18/foo does not print 'invalid symbolic link' gibberish 411s ok 109 - 'pg_dropcluster 4.5 foo' fails 411s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 411s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 411s ok 112 - 'pg_dropcluster 18 foo' fails 411s ok 113 - pg_dropcluster 18 foo gives error message about nonexisting cluster 411s ok 114 - pg_dropcluster 18 foo does not print 'invalid symbolic link' gibberish 411s ok 115 - 'pg_upgradecluster 4.5 foo' fails 411s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 411s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 411s ok 118 - 'pg_upgradecluster 18 foo' fails 411s ok 119 - pg_upgradecluster 18 foo gives error message about nonexisting cluster 411s ok 120 - pg_upgradecluster 18 foo does not print 'invalid symbolic link' gibberish 411s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 411s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 411s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 411s ok 124 - 'pg_ctlcluster 18 foo stop' fails 411s ok 125 - pg_ctlcluster 18 foo stop gives error message about nonexisting cluster 411s ok 126 - pg_ctlcluster 18 foo stop does not print 'invalid symbolic link' gibberish 411s # Cleanup 411s ok 127 - Cleanup: No clusters left behind 411s ok 128 - No postgres processes left behind 411s ok 129 - No files in /etc/postgresql left behind 411s ok 130 - No files in /var/lib/postgresql left behind 411s ok 131 - No files in /var/run/postgresql left behind 411s ok 132 - No files in /var/log/postgresql left behind 411s ok 133 - PostgreSQL TCP ports are closed 411s ok 134 - Next free port is 5432 411s ok 135 - pg_dropcluster 18 broken 411s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 411s # Cleanup 412s ok 137 - Cleanup: No clusters left behind 412s ok 138 - No postgres processes left behind 412s ok 139 - No files in /etc/postgresql left behind 412s ok 140 - No files in /var/lib/postgresql left behind 412s ok 141 - No files in /var/run/postgresql left behind 412s ok 142 - No files in /var/log/postgresql left behind 412s ok 143 - PostgreSQL TCP ports are closed 412s ok 144 - Next free port is 5432 412s ok 145 - pg_dropcluster 18 broken 412s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 412s ok 147 - /etc/postgresql/18 was removed 412s ok 148 - /var/lib/postgresql/18 was removed 412s # Cleanup 412s ok 149 - Cleanup: No clusters left behind 412s ok 150 - No postgres processes left behind 412s ok 151 - No files in /etc/postgresql left behind 412s ok 152 - No files in /var/lib/postgresql left behind 412s ok 153 - No files in /var/run/postgresql left behind 412s ok 154 - No files in /var/log/postgresql left behind 412s ok 155 - PostgreSQL TCP ports are closed 412s ok 156 - Next free port is 5432 412s ### End test 030_errors.t ### 412s 412s ### PostgreSQL test 031_errors_disk_full.t ### 412s 1..22 412s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 413s ok 1 - script failed 413s ok 2 - pg_createcluster fails due to insufficient disk space 413s ok 3 - does not leave files behind 413s # Cleanup 413s ok 4 - Cleanup: No clusters left behind 413s ok 5 - No postgres processes left behind 413s ok 6 - No files in /etc/postgresql left behind 413s ok 7 - No files in /var/lib/postgresql left behind 413s ok 8 - No files in /var/run/postgresql left behind 413s ok 9 - No files in /var/log/postgresql left behind 413s ok 10 - PostgreSQL TCP ports are closed 413s ok 11 - Next free port is 5432 413s # check disk full conditions on startup 415s ok 12 - script failed 415s ok 13 - pg_ctlcluster prints error message 415s ok 14 - log file has error message 415s # Cleanup 415s ok 15 - Cleanup: No clusters left behind 415s ok 16 - No postgres processes left behind 415s ok 17 - No files in /etc/postgresql left behind 415s ok 18 - No files in /var/lib/postgresql left behind 415s ok 19 - No files in /var/run/postgresql left behind 415s ok 20 - No files in /var/log/postgresql left behind 415s ok 21 - PostgreSQL TCP ports are closed 415s ok 22 - Next free port is 5432 415s ### End test 031_errors_disk_full.t ### 415s 415s ### PostgreSQL test 032_ssl_key_permissions.t ### 415s 1..22 415s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 415s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 415s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 416s ok 4 - pg_createcluster 18 main 416s ok 5 - pg_ctlcluster 18 main start 416s ok 6 - ssl key owned by nobody refused 416s ok 7 - pg_ctlcluster 18 main start 416s ok 8 - ssl key with permissions root:root 0644 refused 416s ok 9 - pg_ctlcluster 18 main start 416s ok 10 - ssl key with permissions postgres:postgres 0640 refused 417s ok 11 - pg_dropcluster 18 main --stop 417s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 417s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 417s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 417s # Cleanup 417s ok 15 - Cleanup: No clusters left behind 417s ok 16 - No postgres processes left behind 417s ok 17 - No files in /etc/postgresql left behind 417s ok 18 - No files in /var/lib/postgresql left behind 417s ok 19 - No files in /var/run/postgresql left behind 417s ok 20 - No files in /var/log/postgresql left behind 417s ok 21 - PostgreSQL TCP ports are closed 417s ok 22 - Next free port is 5432 417s ### End test 032_ssl_key_permissions.t ### 417s 417s ### PostgreSQL test 040_upgrade.t ### 417s 1..1 417s ok 1 - only one major version installed, skipping upgrade tests 417s ### End test 040_upgrade.t ### 417s 417s ### PostgreSQL test 041_upgrade_custompaths.t ### 417s 1..1 417s ok 1 - only one major version installed, skipping upgrade tests 417s ### End test 041_upgrade_custompaths.t ### 417s 417s ### PostgreSQL test 042_upgrade_rename.t ### 417s 1..15 417s # PostgreSQL 18 420s ok 1 - pg_createcluster 18 main --start 425s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/18/bin -v 18 --rename upgr 18 main 425s ok 3 - pg_lsclusters -h 425s ok 4 - correct output of pg_lsclusters -h 425s ok 5 - pg_dropcluster 18 main --stop 426s ok 6 - pg_dropcluster 18 upgr --stop 426s ok 7 - Cleaning pg_upgrade log files 426s # Cleanup 426s ok 8 - Cleanup: No clusters left behind 426s ok 9 - No postgres processes left behind 426s ok 10 - No files in /etc/postgresql left behind 426s ok 11 - No files in /var/lib/postgresql left behind 426s ok 12 - No files in /var/run/postgresql left behind 426s ok 13 - No files in /var/log/postgresql left behind 426s ok 14 - PostgreSQL TCP ports are closed 426s ok 15 - Next free port is 5432 426s ### End test 042_upgrade_rename.t ### 426s 426s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 426s 1..1 426s ok 1 - only one major version installed, skipping upgrade tests 426s ### End test 043_upgrade_ssl_cert.t ### 426s 426s ### PostgreSQL test 045_backup.t ### 426s # We are running systemd 426s # PostgreSQL 18 426s # create cluster 429s ok 1 - pg_createcluster --locale en_US.UTF-8 18 main --start 429s ok 2 - pg_lsclusters -h 429s ok 3 - correct output of pg_lsclusters -h 429s ok 4 - pg_conftool 18 main set work_mem 11MB 429s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 429s ok 6 - psql -c 'alter database mydb set search_path=public' 429s ok 7 - psql -c 'create table foo (t text)' mydb 429s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 429s ok 9 - psql -c 'CREATE USER myuser' 429s ok 10 - psql -c 'grant create on database mydb to myuser' 429s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 430s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 430s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 430s # create directory 430s ok 14 - pg_backupcluster 18 main createdirectory 430s ok 15 - /var/backups/postgresql/18-main owned by uid postgres 430s ok 16 - /var/backups/postgresql/18-main owned by gid postgres 430s # dump 430s ok 17 - systemctl start pg_dump@18-main 430s ok 18 - dump created in /var/backups/postgresql/18-main/2025-11-02T233024Z.dump 430s ok 19 - /var/backups/postgresql/18-main/2025-11-02T233024Z.dump owned by uid postgres 430s ok 20 - /var/backups/postgresql/18-main/2025-11-02T233024Z.dump owned by gid postgres 430s # basebackup 430s ok 21 - systemctl start pg_receivewal@18-main 430s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 431s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [000000010000000000000002.gz.partial] 431s not ok 23 - /var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 431s # Failed test '/var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial' 431s # at t/TestLib.pm line 171. 431s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 431s ok 25 - psql -c 'select pg_reload_conf()' 458s ok 26 - systemctl start pg_basebackup@18-main 458s ok 27 - dump created in /var/backups/postgresql/18-main/2025-11-02T233025Z.backup 458s ok 28 - /var/backups/postgresql/18-main/2025-11-02T233025Z.backup owned by uid postgres 458s ok 29 - /var/backups/postgresql/18-main/2025-11-02T233025Z.backup owned by gid postgres 458s # list 458s ok 30 - pg_backupcluster 18 main list 458s ok 31 - correct output of pg_backupcluster 18 main list 458s # more database changes 458s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 458s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 458s ok 34 - retrieve recovery timestamp 458s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 458s ok 36 - systemctl stop pg_receivewal@18-main 458s # restore /var/backups/postgresql/18-main/2025-11-02T233024Z.dump 459s ok 37 - pg_dropcluster 18 main --stop 463s ok 38 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-02T233024Z.dump --start --datadir /var/lib/postgresql/18/snowflake 463s ok 39 - pg_lsclusters -h 463s ok 40 - correct output of pg_lsclusters -h 463s ok 41 - psql -XAtl 463s ok 42 - mydb locales 463s ok 43 - mydb grants 463s ok 44 - myicudb locales 463s ok 45 - psql -XAtc 'show work_mem' 463s ok 46 - correct output of psql -XAtc 'show work_mem' 463s ok 47 - psql -XAtc 'select * from foo' mydb 463s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 463s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 463s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 463s ok 51 - psql -XAtc '\drds' 463s ok 52 - correct output of psql -XAtc '\drds' 463s # restore /var/backups/postgresql/18-main/2025-11-02T233025Z.backup 464s ok 53 - pg_dropcluster 18 main --stop 467s ok 54 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-02T233025Z.backup --start --datadir /var/lib/postgresql/18/snowflake 467s ok 55 - pg_lsclusters -h 467s ok 56 - correct output of pg_lsclusters -h 467s ok 57 - psql -XAtl 467s ok 58 - mydb locales 467s ok 59 - mydb grants 467s ok 60 - myicudb locales 467s ok 61 - psql -XAtc 'show work_mem' 467s ok 62 - correct output of psql -XAtc 'show work_mem' 467s ok 63 - psql -XAtc 'select * from foo' mydb 467s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 467s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 467s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 467s ok 67 - psql -XAtc '\drds' 467s ok 68 - correct output of psql -XAtc '\drds' 467s # restore /var/backups/postgresql/18-main/2025-11-02T233025Z.backup with WAL archive 468s ok 69 - pg_dropcluster 18 main --stop 471s ok 70 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-02T233025Z.backup --start --archive --port 5430 471s ok 71 - pg_lsclusters -h 471s ok 72 - correct output of pg_lsclusters -h 471s ok 73 - psql -XAtc 'select * from foo order by t' mydb 471s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 471s # restore /var/backups/postgresql/18-main/2025-11-02T233025Z.backup with PITR 472s ok 75 - pg_dropcluster 18 main --stop 475s ok 76 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-02T233025Z.backup --start --pitr '2025-11-02 23:30:52.807427+00 475s # ' 475s ok 77 - pg_lsclusters -h 475s ok 78 - correct output of pg_lsclusters -h 475s ok 79 - psql -XAtc 'select * from foo order by t' mydb 475s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 476s ok 81 - pg_dropcluster 18 main --stop 476s # Cleanup 476s ok 82 - Cleanup: No clusters left behind 476s ok 83 - No postgres processes left behind 476s ok 84 - No files in /etc/postgresql left behind 476s ok 85 - No files in /var/lib/postgresql left behind 476s ok 86 - No files in /var/run/postgresql left behind 476s ok 87 - No files in /var/log/postgresql left behind 476s ok 88 - PostgreSQL TCP ports are closed 476s ok 89 - Next free port is 5432 476s 1..89 476s ### End test 045_backup.t ### 476s 476s ### PostgreSQL test 050_encodings.t ### 476s 1..60 476s # Checking 18 ru_RU 479s ok 1 - pg_createcluster version 18 for ru_RU without --encoding succeeded 480s ok 2 - psql -l succeeds 480s ok 3 - template1 is not UTF-8 encoded 480s ok 4 - creating test database 480s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 480s # create table t (x varchar); copy t from stdin" test 480s ok 6 - creating table with ISO-8859-5 characters 480s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 480s ok 8 - correct string in UTF-8 480s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 480s ok 10 - correct string in ISO-8859-5 480s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 480s # delete from t; copy t from stdin" test 480s ok 12 - creating table with UTF-8 characters 480s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 480s ok 14 - correct string in UTF-8 480s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 480s ok 16 - correct string in ISO-8859-1 481s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 481s ok 18 - Server error message has correct language and encoding 483s ok 19 - pg_ctlcluster 18 ru_RU restart 483s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 484s ok 21 - Dropping cluster 484s # Checking 18 ru_RU.UTF-8 487s ok 22 - pg_createcluster version 18 for ru_RU.UTF-8 without --encoding succeeded 488s ok 23 - psql -l succeeds 488s ok 24 - template1 is UTF-8 encoded 488s ok 25 - creating test database 488s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 488s # create table t (x varchar); copy t from stdin" test 488s ok 27 - creating table with ISO-8859-5 characters 488s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 488s ok 29 - correct string in UTF-8 488s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 488s ok 31 - correct string in ISO-8859-5 488s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 488s # delete from t; copy t from stdin" test 488s ok 33 - creating table with UTF-8 characters 488s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 488s ok 35 - correct string in UTF-8 488s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 488s ok 37 - correct string in ISO-8859-1 488s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 488s ok 39 - Server error message has correct language and encoding 490s ok 40 - pg_ctlcluster 18 ru_RU.UTF8 restart 490s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 490s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 490s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 490s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 490s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 490s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 490s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 491s ok 48 - Dropping cluster 491s # Check 18 locale environment variables 494s ok 49 - pg_createcluster: LC_ALL dominates LANG 494s ok 50 - psql -Atl --cluster 18/main 494s ok 51 - template1 is ASCII encoded 495s ok 52 - Dropping cluster 495s # Cleanup 495s ok 53 - Cleanup: No clusters left behind 495s ok 54 - No postgres processes left behind 495s ok 55 - No files in /etc/postgresql left behind 495s ok 56 - No files in /var/lib/postgresql left behind 495s ok 57 - No files in /var/run/postgresql left behind 495s ok 58 - No files in /var/log/postgresql left behind 495s ok 59 - PostgreSQL TCP ports are closed 495s ok 60 - Next free port is 5432 495s ### End test 050_encodings.t ### 495s 495s ### PostgreSQL test 052_upgrade_encodings.t ### 495s 1..1 495s ok 1 - only one major version installed, skipping upgrade tests 495s ### End test 052_upgrade_encodings.t ### 495s 495s ### PostgreSQL test 060_obsolete_confparams.t ### 495s ok 1 - only one major version installed, skipping upgrade tests 495s 1..1 495s ### End test 060_obsolete_confparams.t ### 495s 495s ### PostgreSQL test 070_non_postgres_clusters.t ### 495s 1..40 496s ok 1 - pg_createcluster 18 main for owner nobody 496s ok 2 - pg_ctlcluster 18 main start 496s ok 3 - start refused when config and data owners mismatch 498s ok 4 - pg_ctlcluster succeeds with owner nobody 498s ok 5 - pg_lsclusters -h 498s ok 6 - pg_lsclusters shows running cluster 498s ok 7 - postgres is running as user nobody 498s ok 8 - ls /tmp/.s.PGSQL.* 498s ok 9 - socket is in /tmp 498s ok 10 - /var/run/postgresql is empty 498s ok 11 - conf dir is owned by user 498s ok 12 - conf dir is owned by user's primary group 498s ok 13 - files are owned by user 498s ok 14 - files are owned by user's primary group 498s ok 15 - log file has 0640 permissions 498s ok 16 - log file is owned by user 498s ok 17 - log file is owned by user's primary group 498s ok 18 - only one major version installed, skipping upgrade test 498s ok 19 - ... 498s ok 20 - ... 498s ok 21 - ... 498s ok 22 - ... 498s ok 23 - ... 498s ok 24 - ... 498s ok 25 - ... 498s ok 26 - ... 498s ok 27 - ... 498s ok 28 - ... 499s ok 29 - pg_dropcluster 499s ok 30 - pg_lsclusters -h 499s ok 31 - No clusters left 499s ok 32 - No postgres processes left 499s # Cleanup 499s ok 33 - Cleanup: No clusters left behind 499s ok 34 - No postgres processes left behind 499s ok 35 - No files in /etc/postgresql left behind 499s ok 36 - No files in /var/lib/postgresql left behind 499s ok 37 - No files in /var/run/postgresql left behind 499s ok 38 - No files in /var/log/postgresql left behind 499s ok 39 - PostgreSQL TCP ports are closed 499s ok 40 - Next free port is 5432 499s ### End test 070_non_postgres_clusters.t ### 499s 499s ### PostgreSQL test 080_start.conf.t ### 499s 1..73 500s ok 1 - pg_createcluster 18 main 500s # start.conf auto 500s ok 2 - get_cluster_start_conf returns auto 500s ok 3 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 500s ok 4 - start.conf contains auto 500s ok 5 - systemd generator links cluster 500s ok 6 - systemd generator links correct service file 502s ok 7 - /etc/init.d/postgresql start 18 502s ok 8 - correct output of /etc/init.d/postgresql start 18 502s ok 9 - pg_lsclusters -h 502s ok 10 - cluster is online 502s ok 11 - /etc/init.d/postgresql stop 18 502s ok 12 - correct output of /etc/init.d/postgresql stop 18 505s ok 13 - pg_lsclusters -h 505s ok 14 - cluster is down 505s # start.conf manual 505s ok 15 - get_cluster_start_conf returns manual 505s ok 16 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 505s ok 17 - start.conf contains manual 505s ok 18 - systemd generator doesn't link cluster 505s ok 19 - /etc/init.d/postgresql start 18 505s ok 20 - correct output of /etc/init.d/postgresql start 18 505s ok 21 - pg_lsclusters -h 505s ok 22 - cluster is down 507s ok 23 - pg_ctlcluster 18 main start 507s ok 24 - correct output of pg_ctlcluster 18 main start 507s ok 25 - pg_lsclusters -h 507s ok 26 - cluster is online 507s ok 27 - pg_ctlcluster 18 main stop 507s ok 28 - correct output of pg_ctlcluster 18 main stop 507s ok 29 - pg_lsclusters -h 507s ok 30 - cluster is down 507s # start.conf disabled 507s ok 31 - get_cluster_start_conf returns disabled 508s ok 32 - systemd generator doesn't link cluster 508s ok 33 - /etc/init.d/postgresql start 18 508s ok 34 - correct output of /etc/init.d/postgresql start 18 508s ok 35 - pg_lsclusters -h 508s ok 36 - cluster is down 508s ok 37 - pg_ctlcluster 18 main start 508s ok 38 - correct output of pg_ctlcluster 18 main start 508s ok 39 - pg_lsclusters -h 508s ok 40 - cluster is down 510s ok 41 - pg_ctlcluster 18 main start 510s ok 42 - correct output of pg_ctlcluster 18 main start 510s ok 43 - pg_lsclusters -h 510s ok 44 - cluster is online 510s ok 45 - pg_ctlcluster 18 main stop 510s ok 46 - correct output of pg_ctlcluster 18 main stop 510s ok 47 - pg_lsclusters -h 510s ok 48 - cluster is down 512s ok 49 - pg_ctlcluster 18 main start 512s ok 50 - correct output of pg_ctlcluster 18 main start 512s ok 51 - pg_lsclusters -h 512s ok 52 - cluster is online 512s # test upgrade 512s ok 53 - only one major version installed, skipping upgrade test 512s ok 54 - ... 512s ok 55 - get_cluster_start_conf for old cluster returns manual 512s ok 56 - get_cluster_start_conf for new cluster returns manual 512s ok 57 - ... 513s ok 58 - dropping upgraded cluster 513s ok 59 - pg_lsclusters -h 513s ok 60 - no clusters any more 513s ok 61 - pg_createcluster 18 main --start-conf foo 513s ok 62 - pg_createcluster checks --start-conf validity 514s ok 63 - pg_createcluster checks --start-conf manual 514s ok 64 - get_cluster_start_conf returns manual 514s ok 65 - dropping cluster 514s # Cleanup 514s ok 66 - Cleanup: No clusters left behind 514s ok 67 - No postgres processes left behind 514s ok 68 - No files in /etc/postgresql left behind 514s ok 69 - No files in /var/lib/postgresql left behind 514s ok 70 - No files in /var/run/postgresql left behind 514s ok 71 - No files in /var/log/postgresql left behind 514s ok 72 - PostgreSQL TCP ports are closed 514s ok 73 - Next free port is 5432 514s ### End test 080_start.conf.t ### 514s 514s ### PostgreSQL test 085_pg_ctl.conf.t ### 514s 1..33 514s ok 1 - prlimit --core=0:unlimited --pid=16909 514s ok 2 - set core file size to unlimited 514s ok 3 - sh -c 'ulimit -Hc' 514s ok 4 - core file size is unlimited 515s ok 5 - pg_createcluster 18 main 515s ok 6 - /etc/postgresql/18/main/pg_ctl.conf exists 517s ok 7 - pg_ctlcluster 18 main start 517s ok 8 - starting cluster as root 517s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 517s ok 10 - soft core size is 0 517s # hard core file size limit of root-started postgres process is unlimited 517s ok 11 - set pg_ctl default option to -c 520s ok 12 - pg_ctlcluster 18 main restart 520s ok 13 - restarting cluster as root 520s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 520s ok 15 - soft core size is unlimited 520s ok 16 - pg_ctlcluster 18 main stop 520s ok 17 - stopping cluster 520s ok 18 - restored pg_ctl default option 522s ok 19 - pg_ctlcluster 18 main start -- -c 522s ok 20 - starting cluster with -c on the command line as postgres 522s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 522s ok 22 - soft core size is unlimited 522s ok 23 - pg_ctlcluster 18 main stop 522s ok 24 - stopping cluster 523s ok 25 - dropping cluster 523s # Cleanup 523s ok 26 - Cleanup: No clusters left behind 523s ok 27 - No postgres processes left behind 523s ok 28 - No files in /etc/postgresql left behind 523s ok 29 - No files in /var/lib/postgresql left behind 523s ok 30 - No files in /var/run/postgresql left behind 523s ok 31 - No files in /var/log/postgresql left behind 523s ok 32 - PostgreSQL TCP ports are closed 523s ok 33 - Next free port is 5432 523s ### End test 085_pg_ctl.conf.t ### 523s 523s ### PostgreSQL test 090_multicluster.t ### 523s 1..125 524s ok 1 - pg_createcluster 18 old 524s ok 2 - pg_createcluster 18 new1 525s ok 3 - pg_createcluster 18 new2 527s ok 4 - starting cluster 18/old 529s ok 5 - starting cluster 18/new1 531s ok 6 - starting cluster 18/new2 531s ok 7 - pg_lsclusters -h | sort -k3 531s ok 8 - clusters have the correct ports, skipping used 5433 531s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 531s ok 10 - createdb --version 531s ok 11 - pg_wrapper selects port 5432 as default cluster 531s ok 12 - createdb --cluster 18/new1 --version 531s ok 13 - pg_wrapper --cluster works 531s ok 14 - createdb --cluster 18/foo --version 531s ok 15 - pg_wrapper --cluster errors out for invalid cluster 531s ok 16 - createdb --cluster 18/new1 test 531s ok 17 - correct output of createdb --cluster 18/new1 test 531s ok 18 - psql -Atl --cluster 18/new1 531s ok 19 - test db appears in cluster new1 531s ok 20 - psql -Atl --cluster 18/new2 531s ok 21 - test db does not appear in cluster new2 531s ok 22 - psql -Atl 531s ok 23 - test db does not appear in default cluster 532s ok 24 - psql --cluster 18/127.0.0.1: -Atc 'show port' template1 532s ok 25 - psql --cluster 18/127.0.0.1: defaults to port 5432 532s ok 26 - createdb --cluster 18/127.0.0.1:5432 --version 532s ok 27 - createdb --cluster 18/127.0.0.1:5432 uses latest client version 532s ok 28 - psql -Atl --cluster 18/localhost:5434 532s ok 29 - test db appears in cluster 18/localhost:5434 532s ok 30 - psql -Atl --cluster 18/localhost:5440 532s ok 31 - test db does not appear in cluster 18/localhost:5440 532s ok 32 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:5435 532s ok 33 - psql --cluster 18/localhost:5435 fails due to nonexisting port 532s ok 34 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:a 532s ok 35 - psql --cluster 18/localhost:a fails due to invalid syntax 532s ok 36 - LC_MESSAGES=C psql -Atl --cluster 18/doesnotexi.st 532s ok 37 - psql --cluster 18/doesnotexi.st fails due to invalid syntax 532s ok 38 - psql -Atl --cluster 6.4/localhost: 532s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 532s ok 40 - psql -Atl 532s ok 41 - PGCLUSTER selection (1) 532s ok 42 - psql -Atl 532s ok 43 - PGCLUSTER selection (2) 532s ok 44 - psql -l 532s ok 45 - invalid PGCLUSTER value 532s ok 46 - createdb --version 532s ok 47 - PGCLUSTER network cluster selection (1) 532s ok 48 - psql -Atl 532s ok 49 - PGCLUSTER network cluster selection (2) 532s ok 50 - psql -Atl 532s ok 51 - PGCLUSTER network cluster selection (3) 532s ok 52 - LC_MESSAGES=C psql -Atl 532s ok 53 - psql --cluster 18/localhost:5435 fails due to nonexisting port 532s ok 54 - psql -Atc "show port" template1 532s ok 55 - PGPORT selection (1) 532s ok 56 - psql -Atc "show port" template1 532s ok 57 - PGPORT selection (2) 532s ok 58 - createdb --version 532s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 532s ok 60 - psql -Atc "show port" template1 532s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 532s ok 62 - psql --cluster 18/new1 -Atc 'select current_database()' 532s ok 63 - PGDATABASE environment variable works 532s ok 64 - createdb --version 532s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 532s ok 66 - createdb --cluster 18/new1 --version 532s ok 67 - pg_wrapper --cluster works with empty user_clusters 532s ok 68 - createdb --version 532s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 18 new1 *' 532s ok 70 - psql -Atc "select current_database()" 532s ok 71 - pg_wrapper selects correct database with user_clusters '* * 18 new1 test' 532s ok 72 - psql -Atc 'select current_database()' 532s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 532s ok 74 - createdb --version 532s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 532s ok 76 - createdb --version 532s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 532s ok 78 - createdb --version 532s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 532s ok 80 - createdb --version 532s ok 81 - pg_wrapper selects correct version with per-user user_clusters 532s ok 82 - createdb --version 532s ok 83 - pg_wrapper selects correct version with per-user user_clusters 532s ok 84 - createdb --version 532s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 532s ok 86 - psql -Atl 532s ok 87 - $PGHOST overrides user_clusters 532s ok 88 - psql --cluster 18/localhost:5434 -Atc 'select current_database()' test 532s ok 89 - --cluster overrides $PGHOST 532s ok 90 - createdb --version 532s ok 91 - pg_wrapper ignores invalid lines in user_clusters 532s ok 92 - psql -Atc 'select current_database()' 532s ok 93 - pg_service conf selection 1 532s ok 94 - psql -Atc 'select current_database()' 532s ok 95 - pg_service conf selection 2 532s ok 96 - psql -Atc 'select current_database()' 532s ok 97 - pg_service conf selection 3 533s ok 98 - stopping cluster 18/old 535s ok 99 - restarting cluster 18/old 535s ok 100 # skip rust coreutils sort -k option regression. See LP: #2125504 535s ok 101 # skip rust coreutils sort -k option regression. See LP: #2125504 535s ok 102 - psql -l 535s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 535s ok 104 - psql -Atl --cluster 18/new1 535s ok 105 - --cluster selects appropriate cluster 535s ok 106 - psql -Atl -p 5434 535s ok 107 - -p selects appropriate cluster 535s ok 108 - psql -Atlp 5434 535s ok 109 - -Atlp selects appropriate cluster 535s ok 110 - psql -Atl --port 5434 535s ok 111 - --port selects appropriate cluster 535s ok 112 - env PGPORT=5434 psql -Atl 535s ok 113 - $PGPORT selects appropriate cluster 535s ok 114 - Restoring original /etc/postgresql-common/user_clusters 536s ok 115 - dropping 18/new1 537s ok 116 - dropping 18/new2 538s ok 117 - dropping 18/old 538s # Cleanup 538s ok 118 - Cleanup: No clusters left behind 538s ok 119 - No postgres processes left behind 538s ok 120 - No files in /etc/postgresql left behind 538s ok 121 - No files in /var/lib/postgresql left behind 538s ok 122 - No files in /var/run/postgresql left behind 538s ok 123 - No files in /var/log/postgresql left behind 538s ok 124 - PostgreSQL TCP ports are closed 538s ok 125 - Next free port is 5432 538s ### End test 090_multicluster.t ### 538s 538s ### PostgreSQL test 110_integrate_cluster.t ### 538s 1..32 538s ok 1 - /usr/lib/postgresql/18/bin/initdb /tmp/E3MlkM19ET/c/postgres 538s ok 2 - creating raw initdb cluster for user postgres 539s ok 3 - pg_createcluster 18 postgres -d /tmp/E3MlkM19ET/c/postgres 539s ok 4 - integrating postgres cluster 539s ok 5 - pg_lsclusters 539s ok 6 - correct pg_lsclusters output 541s ok 7 - pg_ctlcluster 18 postgres start 541s ok 8 - starting cluster postgres 541s ok 9 - pg_lsclusters 541s ok 10 - correct pg_lsclusters output 543s ok 11 - dropping cluster postgres 543s ok 12 - No files in temporary cluster dir left behind 543s ok 13 - /usr/lib/postgresql/18/bin/initdb /tmp/E3MlkM19ET/c/nobody 543s ok 14 - creating raw initdb cluster for user nobody 543s ok 15 - pg_createcluster 18 nobody -d /tmp/E3MlkM19ET/c/nobody 543s ok 16 - integrating nobody cluster 543s ok 17 - pg_lsclusters 543s ok 18 - correct pg_lsclusters output 545s ok 19 - pg_ctlcluster 18 nobody start 545s ok 20 - starting cluster nobody 545s ok 21 - pg_lsclusters 545s ok 22 - correct pg_lsclusters output 546s ok 23 - dropping cluster nobody 546s ok 24 - No files in temporary cluster dir left behind 546s # Cleanup 546s ok 25 - Cleanup: No clusters left behind 546s ok 26 - No postgres processes left behind 546s ok 27 - No files in /etc/postgresql left behind 546s ok 28 - No files in /var/lib/postgresql left behind 546s ok 29 - No files in /var/run/postgresql left behind 546s ok 30 - No files in /var/log/postgresql left behind 546s ok 31 - PostgreSQL TCP ports are closed 546s ok 32 - Next free port is 5432 546s ### End test 110_integrate_cluster.t ### 546s 546s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 546s 1..1 546s ok 1 - only one major version installed, skipping upgrade tests 546s ### End test 120_pg_upgradecluster_scripts.t ### 546s 546s ### PostgreSQL test 130_nonroot_admin.t ### 546s 1..22 548s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 549s ok 2 - pg_lsclusters -h 549s ok 3 - correct output of pg_lsclusters -h 549s ok 4 - psql -Atl 549s ok 5 - correct output of psql -Atl 549s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 549s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 549s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 549s # Cleanup 549s ok 15 - Cleanup: No clusters left behind 549s ok 16 - No postgres processes left behind 549s ok 17 - No files in /etc/postgresql left behind 549s ok 18 - No files in /var/lib/postgresql left behind 549s ok 19 - No files in /var/run/postgresql left behind 549s ok 20 - No files in /var/log/postgresql left behind 549s ok 21 - PostgreSQL TCP ports are closed 549s ok 22 - Next free port is 5432 549s ### End test 130_nonroot_admin.t ### 549s 549s ### PostgreSQL test 135_pg_virtualenv.t ### 549s 1..20 552s ok 1 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 552s ok 2 - running pg_virtualenv as root 555s ok 3 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 555s ok 4 - running pg_virtualenv as postgres 558s ok 5 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 558s ok 6 - running pg_virtualenv as nobody 561s ok 7 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 561s ok 8 - running fakeroot pg_virtualenv as root 563s ok 9 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 563s ok 10 - running fakeroot pg_virtualenv as postgres 566s ok 11 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 566s ok 12 - running fakeroot pg_virtualenv as nobody 566s # Cleanup 566s ok 13 - Cleanup: No clusters left behind 566s ok 14 - No postgres processes left behind 566s ok 15 - No files in /etc/postgresql left behind 566s ok 16 - No files in /var/lib/postgresql left behind 566s ok 17 - No files in /var/run/postgresql left behind 566s ok 18 - No files in /var/log/postgresql left behind 566s ok 19 - PostgreSQL TCP ports are closed 566s ok 20 - Next free port is 5432 566s ### End test 135_pg_virtualenv.t ### 566s 566s ### PostgreSQL test 140_pg_config.t ### 566s 1..38 566s # Multiarch is enabled 566s # checking version specific output for 18 566s ok 1 - /usr/lib/postgresql/18/bin/pg_config --pgxs 566s ok 2 - correct output of /usr/lib/postgresql/18/bin/pg_config --pgxs 566s ok 3 - /usr/lib/postgresql/18/bin/pg_config --libdir 566s ok 4 - correct output of /usr/lib/postgresql/18/bin/pg_config --libdir 566s ok 5 - /usr/lib/postgresql/18/bin/pg_config --pkglibdir 566s ok 6 - correct output of /usr/lib/postgresql/18/bin/pg_config --pkglibdir 566s ok 7 - /usr/lib/postgresql/18/bin/pg_config --bindir 566s ok 8 - correct output of /usr/lib/postgresql/18/bin/pg_config --bindir 566s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 566s # checking pg_config output (should behave like version 18) 566s ok 15 - pg_config 566s ok 16 - correct output of pg_config 566s ok 17 - pg_config --help 566s ok 18 - correct output of pg_config --help 566s ok 19 - pg_config --pgxs 566s ok 20 - correct output of pg_config --pgxs 566s ok 21 - pg_config --libdir 566s ok 22 - correct output of pg_config --libdir 566s ok 23 - pg_config --pkglibdir 566s ok 24 - correct output of pg_config --pkglibdir 566s ok 25 - pg_config --bindir 566s ok 26 - correct output of pg_config --bindir 566s # checking pg_config.libpq-dev output (should behave like version 18) 566s ok 27 - pg_config.libpq-dev 566s ok 28 - correct output of pg_config.libpq-dev 566s ok 29 - pg_config.libpq-dev --help 566s ok 30 - correct output of pg_config.libpq-dev --help 566s ok 31 - pg_config.libpq-dev --pgxs 566s ok 32 - correct output of pg_config.libpq-dev --pgxs 566s ok 33 - pg_config.libpq-dev --libdir 566s ok 34 - correct output of pg_config.libpq-dev --libdir 566s ok 35 - pg_config.libpq-dev --pkglibdir 566s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 566s ok 37 - pg_config.libpq-dev --bindir 566s ok 38 - correct output of pg_config.libpq-dev --bindir 566s ### End test 140_pg_config.t ### 566s 566s ### PostgreSQL test 150_tsearch_stemming.t ### 567s 1..37 568s ok 1 - pg_updatedicts succeeded 568s ok 2 - pg_updatedicts created en_us.affix 568s ok 3 - pg_updatedicts created en_us.dict 568s ok 4 - pg_updatedicts created 18 en_us.affix symlink 568s ok 5 - pg_updatedicts created 18 en_us.dict symlink 569s ok 6 - pg_createcluster 18 main 569s ok 7 - createdb fts 569s ok 8 - correct output of createdb fts 569s ok 9 - creating en_US full text search configuration 570s ok 10 - creating data table and search index 570s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 570s ok 12 - stem search of correct word 570s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 570s ok 14 - stem search of correct word 570s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 570s ok 16 - stem search of unknown word 570s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 570s ok 18 - full text search, exact word 570s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 570s ok 20 - full text search for word stem 570s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 570s ok 22 - full text search for word substring fails 570s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 570s ok 24 - full text search, exact unicode word 570s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 570s ok 26 - full text search for unicode word stem 570s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 570s ok 28 - full text search for unicode word substring fails 571s ok 29 571s # Cleanup 571s ok 30 - Cleanup: No clusters left behind 571s ok 31 - No postgres processes left behind 571s ok 32 - No files in /etc/postgresql left behind 571s ok 33 - No files in /var/lib/postgresql left behind 571s ok 34 - No files in /var/run/postgresql left behind 571s ok 35 - No files in /var/log/postgresql left behind 571s ok 36 - PostgreSQL TCP ports are closed 571s ok 37 - Next free port is 5432 571s ### End test 150_tsearch_stemming.t ### 571s 571s ### PostgreSQL test 160_alternate_confroot.t ### 571s 1..28 574s ok 1 574s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 574s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 574s ok 4 - pg_lsclusters -h 574s ok 5 - correct output of pg_lsclusters -h 574s ok 6 - psql -Atl 574s ok 7 - correct output of psql -Atl 574s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 574s ok 9 - ... 574s ok 10 - ... 574s ok 11 - ... 574s ok 12 - ... 574s ok 13 - ... 574s ok 14 - ... 574s ok 15 - pg_dropcluster 18 test --stop 574s ok 16 - correct output of pg_dropcluster 18 test --stop 574s ok 17 - pg_lsclusters -h 574s ok 18 - correct output of pg_lsclusters -h 574s ok 19 - No files in root/data left behind 574s ok 20 - No cruft in root dir left behind 574s # Cleanup 574s ok 21 - Cleanup: No clusters left behind 574s ok 22 - No postgres processes left behind 574s ok 23 - No files in /etc/postgresql left behind 574s ok 24 - No files in /var/lib/postgresql left behind 574s ok 25 - No files in /var/run/postgresql left behind 574s ok 26 - No files in /var/log/postgresql left behind 574s ok 27 - PostgreSQL TCP ports are closed 574s ok 28 - Next free port is 5432 574s ### End test 160_alternate_confroot.t ### 574s 574s ### PostgreSQL test 170_extensions.t ### 574s # Running tests for 18 577s ok 1 - pg_createcluster 18 main 577s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 577s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 577s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 577s ok 5 - extension amcheck installs without error 577s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 577s ok 7 - extension amcheck removes without error 577s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 577s ok 9 - extension autoinc installs without error 577s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 577s ok 11 - extension autoinc removes without error 577s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 577s ok 13 - extension bloom installs without error 577s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 577s ok 15 - extension bloom removes without error 577s ok 16 - psql -qc 'CREATE EXTENSION plperl' 577s ok 17 - bool_plperl dependency plperl installs without error 577s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 577s ok 19 - extension bool_plperl installs without error 577s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 577s ok 21 - extension bool_plperl removes without error 577s ok 22 - psql -qc 'DROP EXTENSION plperl' 577s ok 23 - bool_plperl dependency extension plperl removes without error 577s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 577s ok 25 - bool_plperlu dependency plperlu installs without error 577s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 577s ok 27 - extension bool_plperlu installs without error 577s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 577s ok 29 - extension bool_plperlu removes without error 577s ok 30 - psql -qc 'DROP EXTENSION plperlu' 577s ok 31 - bool_plperlu dependency extension plperlu removes without error 577s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 577s ok 33 - extension btree_gin installs without error 577s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 577s ok 35 - extension btree_gin removes without error 577s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 577s ok 37 - extension btree_gist installs without error 577s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 577s ok 39 - extension btree_gist removes without error 577s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 577s ok 41 - extension citext installs without error 577s ok 42 - psql -qc 'DROP EXTENSION "citext"' 577s ok 43 - extension citext removes without error 577s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 577s ok 45 - extension cube installs without error 577s ok 46 - psql -qc 'DROP EXTENSION "cube"' 577s ok 47 - extension cube removes without error 578s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 578s ok 49 - extension dblink installs without error 578s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 578s ok 51 - extension dblink removes without error 578s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 578s ok 53 - extension dict_int installs without error 578s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 578s ok 55 - extension dict_int removes without error 578s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 578s ok 57 - extension dict_xsyn installs without error 578s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 578s ok 59 - extension dict_xsyn removes without error 578s ok 60 - psql -qc 'CREATE EXTENSION cube' 578s ok 61 - earthdistance dependency cube installs without error 578s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 578s ok 63 - extension earthdistance installs without error 578s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 578s ok 65 - extension earthdistance removes without error 578s ok 66 - psql -qc 'DROP EXTENSION cube' 578s ok 67 - earthdistance dependency extension cube removes without error 578s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 578s ok 69 - extension file_fdw installs without error 578s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 578s ok 71 - extension file_fdw removes without error 578s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 578s ok 73 - extension fuzzystrmatch installs without error 578s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 578s ok 75 - extension fuzzystrmatch removes without error 578s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 578s ok 77 - extension hstore installs without error 578s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 578s ok 79 - extension hstore removes without error 578s ok 80 - psql -qc 'CREATE EXTENSION hstore' 578s ok 81 - hstore_plperl dependency hstore installs without error 578s ok 82 - psql -qc 'CREATE EXTENSION plperl' 578s ok 83 - hstore_plperl dependency plperl installs without error 578s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 578s ok 85 - extension hstore_plperl installs without error 578s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 578s ok 87 - extension hstore_plperl removes without error 578s ok 88 - psql -qc 'DROP EXTENSION hstore' 578s ok 89 - hstore_plperl dependency extension hstore removes without error 578s ok 90 - psql -qc 'DROP EXTENSION plperl' 578s ok 91 - hstore_plperl dependency extension plperl removes without error 578s ok 92 - psql -qc 'CREATE EXTENSION hstore' 578s ok 93 - hstore_plperlu dependency hstore installs without error 578s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 578s ok 95 - hstore_plperlu dependency plperlu installs without error 578s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 578s ok 97 - extension hstore_plperlu installs without error 578s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 578s ok 99 - extension hstore_plperlu removes without error 578s ok 100 - psql -qc 'DROP EXTENSION hstore' 578s ok 101 - hstore_plperlu dependency extension hstore removes without error 578s ok 102 - psql -qc 'DROP EXTENSION plperlu' 578s ok 103 - hstore_plperlu dependency extension plperlu removes without error 578s ok 104 - psql -qc 'CREATE EXTENSION hstore' 578s ok 105 - hstore_plpython3u dependency hstore installs without error 578s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 578s ok 107 - hstore_plpython3u dependency plpython3u installs without error 578s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 578s ok 109 - extension hstore_plpython3u installs without error 578s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 578s ok 111 - extension hstore_plpython3u removes without error 578s ok 112 - psql -qc 'DROP EXTENSION hstore' 578s ok 113 - hstore_plpython3u dependency extension hstore removes without error 578s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 578s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 578s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 578s ok 117 - extension insert_username installs without error 579s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 579s ok 119 - extension insert_username removes without error 579s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 579s ok 121 - extension intagg installs without error 579s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 579s ok 123 - extension intagg removes without error 579s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 579s ok 125 - extension intarray installs without error 579s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 579s ok 127 - extension intarray removes without error 579s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 579s ok 129 - extension isn installs without error 579s ok 130 - psql -qc 'DROP EXTENSION "isn"' 579s ok 131 - extension isn removes without error 579s ok 132 - psql -qc 'CREATE EXTENSION plperl' 579s ok 133 - jsonb_plperl dependency plperl installs without error 579s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 579s ok 135 - extension jsonb_plperl installs without error 579s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 579s ok 137 - extension jsonb_plperl removes without error 579s ok 138 - psql -qc 'DROP EXTENSION plperl' 579s ok 139 - jsonb_plperl dependency extension plperl removes without error 579s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 579s ok 141 - jsonb_plperlu dependency plperlu installs without error 579s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 579s ok 143 - extension jsonb_plperlu installs without error 579s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 579s ok 145 - extension jsonb_plperlu removes without error 579s ok 146 - psql -qc 'DROP EXTENSION plperlu' 579s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 579s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 579s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 579s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 579s ok 151 - extension jsonb_plpython3u installs without error 579s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 579s ok 153 - extension jsonb_plpython3u removes without error 579s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 579s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 579s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 579s ok 157 - extension lo installs without error 579s ok 158 - psql -qc 'DROP EXTENSION "lo"' 579s ok 159 - extension lo removes without error 579s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 579s ok 161 - extension ltree installs without error 579s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 579s ok 163 - extension ltree removes without error 579s ok 164 - psql -qc 'CREATE EXTENSION ltree' 579s ok 165 - ltree_plpython3u dependency ltree installs without error 579s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 579s ok 167 - ltree_plpython3u dependency plpython3u installs without error 579s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 579s ok 169 - extension ltree_plpython3u installs without error 579s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 579s ok 171 - extension ltree_plpython3u removes without error 579s ok 172 - psql -qc 'DROP EXTENSION ltree' 579s ok 173 - ltree_plpython3u dependency extension ltree removes without error 579s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 579s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 579s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 579s ok 177 - extension moddatetime installs without error 579s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 579s ok 179 - extension moddatetime removes without error 579s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 579s ok 181 - extension pageinspect installs without error 579s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 579s ok 183 - extension pageinspect removes without error 579s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 579s ok 185 - extension pg_buffercache installs without error 579s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 579s ok 187 - extension pg_buffercache removes without error 580s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 580s ok 189 - extension pg_freespacemap installs without error 580s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 580s ok 191 - extension pg_freespacemap removes without error 580s ok 192 - psql -qc 'CREATE EXTENSION "pg_logicalinspect"' 580s ok 193 - extension pg_logicalinspect installs without error 580s ok 194 - psql -qc 'DROP EXTENSION "pg_logicalinspect"' 580s ok 195 - extension pg_logicalinspect removes without error 580s ok 196 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 580s ok 197 - extension pg_prewarm installs without error 580s ok 198 - psql -qc 'DROP EXTENSION "pg_prewarm"' 580s ok 199 - extension pg_prewarm removes without error 580s ok 200 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 580s ok 201 - extension pg_stat_statements installs without error 580s ok 202 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 580s ok 203 - extension pg_stat_statements removes without error 580s ok 204 - psql -qc 'CREATE EXTENSION "pg_surgery"' 580s ok 205 - extension pg_surgery installs without error 580s ok 206 - psql -qc 'DROP EXTENSION "pg_surgery"' 580s ok 207 - extension pg_surgery removes without error 580s ok 208 - psql -qc 'CREATE EXTENSION "pg_trgm"' 580s ok 209 - extension pg_trgm installs without error 580s ok 210 - psql -qc 'DROP EXTENSION "pg_trgm"' 580s ok 211 - extension pg_trgm removes without error 580s ok 212 - psql -qc 'CREATE EXTENSION "pg_visibility"' 580s ok 213 - extension pg_visibility installs without error 580s ok 214 - psql -qc 'DROP EXTENSION "pg_visibility"' 580s ok 215 - extension pg_visibility removes without error 580s ok 216 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 580s ok 217 - extension pg_walinspect installs without error 580s ok 218 - psql -qc 'DROP EXTENSION "pg_walinspect"' 580s ok 219 - extension pg_walinspect removes without error 580s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 580s ok 221 - extension pgcrypto installs without error 580s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 580s ok 223 - extension pgcrypto removes without error 580s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 580s ok 225 - extension pgrowlocks installs without error 580s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 580s ok 227 - extension pgrowlocks removes without error 580s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 580s ok 229 - extension pgstattuple installs without error 580s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 580s ok 231 - extension pgstattuple removes without error 580s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 580s ok 233 - extension plperl installs without error 580s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 580s ok 235 - extension plperl removes without error 580s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 580s ok 237 - extension plperlu installs without error 580s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 580s ok 239 - extension plperlu removes without error 580s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 580s ok 241 - extension plpython3u installs without error 580s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 580s ok 243 - extension plpython3u removes without error 580s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 580s ok 245 - extension pltcl installs without error 580s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 580s ok 247 - extension pltcl removes without error 580s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 580s ok 249 - extension pltclu installs without error 580s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 580s ok 251 - extension pltclu removes without error 580s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 580s ok 253 - extension postgres_fdw installs without error 580s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 580s ok 255 - extension postgres_fdw removes without error 580s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 580s ok 257 - extension refint installs without error 580s ok 258 - psql -qc 'DROP EXTENSION "refint"' 580s ok 259 - extension refint removes without error 581s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 581s ok 261 - extension seg installs without error 581s ok 262 - psql -qc 'DROP EXTENSION "seg"' 581s ok 263 - extension seg removes without error 581s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 581s ok 265 - extension sslinfo installs without error 581s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 581s ok 267 - extension sslinfo removes without error 581s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 581s ok 269 - extension tablefunc installs without error 581s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 581s ok 271 - extension tablefunc removes without error 581s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 581s ok 273 - extension tcn installs without error 581s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 581s ok 275 - extension tcn removes without error 581s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 581s ok 277 - extension tsm_system_rows installs without error 581s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 581s ok 279 - extension tsm_system_rows removes without error 581s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 581s ok 281 - extension tsm_system_time installs without error 581s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 581s ok 283 - extension tsm_system_time removes without error 581s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 581s ok 285 - extension unaccent installs without error 581s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 581s ok 287 - extension unaccent removes without error 581s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 581s ok 289 - extension uuid-ossp installs without error 581s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 581s ok 291 - extension uuid-ossp removes without error 581s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 581s ok 293 - extension xml2 installs without error 581s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 581s ok 295 - extension xml2 removes without error 582s ok 296 - pg_dropcluster 18 main 582s # Cleanup 582s ok 297 - Cleanup: No clusters left behind 582s ok 298 - No postgres processes left behind 582s ok 299 - No files in /etc/postgresql left behind 582s ok 300 - No files in /var/lib/postgresql left behind 582s ok 301 - No files in /var/run/postgresql left behind 582s ok 302 - No files in /var/log/postgresql left behind 582s ok 303 - PostgreSQL TCP ports are closed 582s ok 304 - Next free port is 5432 582s 1..304 582s ### End test 170_extensions.t ### 582s 582s ### PostgreSQL test 180_ecpg.t ### 582s 1..14 582s ok 1 - ecpg test.pgc 582s ok 2 - ecpg processing 582s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 582s ok 4 - compiling ecpg output 589s ok 5 - pg_virtualenv /tmp/tmp.dttOTHr3ub/test 589s ok 6 - test program runs and gives correct output 589s # Cleanup 589s ok 7 - Cleanup: No clusters left behind 589s ok 8 - No postgres processes left behind 589s ok 9 - No files in /etc/postgresql left behind 589s ok 10 - No files in /var/lib/postgresql left behind 589s ok 11 - No files in /var/run/postgresql left behind 589s ok 12 - No files in /var/log/postgresql left behind 589s ok 13 - PostgreSQL TCP ports are closed 589s ok 14 - Next free port is 5432 589s ### End test 180_ecpg.t ### 589s 589s ### PostgreSQL test 190_pg_buildext.t ### 589s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 589s 1..1 589s ### End test 190_pg_buildext.t ### 589s 589s ### PostgreSQL test 200_maintscripts.t ### 589s 1..15 589s # We are running systemd 592s ok 1 - pg_createcluster 18 main --start 592s ok 2 - postmaster PID is 22002 615s ok 3 - apt-get update -q 615s # postgresql-common: 615s # Installed: 282ubuntu1 615s # Candidate: 282ubuntu1 615s # Version table: 615s # *** 282ubuntu1 500 615s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 615s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 615s # 100 /var/lib/dpkg/status 617s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 617s # postgresql-common: 617s # Installed: 282ubuntu1 617s # Candidate: 282ubuntu1 617s # Version table: 617s # *** 282ubuntu1 500 617s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 617s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 617s # 100 /var/lib/dpkg/status 617s ok 5 - postmaster PID is 22002 617s ok 6 - postmaster was not restarted 618s ok 7 - pg_dropcluster 18 main --stop 618s # Cleanup 618s ok 8 - Cleanup: No clusters left behind 618s ok 9 - No postgres processes left behind 618s ok 10 - No files in /etc/postgresql left behind 618s ok 11 - No files in /var/lib/postgresql left behind 618s ok 12 - No files in /var/run/postgresql left behind 618s ok 13 - No files in /var/log/postgresql left behind 618s ok 14 - PostgreSQL TCP ports are closed 618s ok 15 - Next free port is 5432 618s ### End test 200_maintscripts.t ### 618s 618s autopkgtest [23:33:33]: test run-testsuite: -----------------------] 619s autopkgtest [23:33:34]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 619s run-testsuite PASS 619s autopkgtest [23:33:34]: test installcheck: preparing testbed 637s Creating nova instance adt-resolute-amd64-postgresql-18-20251102-232315-juju-7f2275-prod-proposed-migration-environment-15-4a64cf16-9c13-4cb7-befe-69d049d1c054 from image adt/ubuntu-resolute-amd64-server-20251102.img (UUID 78978bf7-ada0-4083-bfa4-315ae4f39784)... 666s autopkgtest [23:34:21]: testbed dpkg architecture: amd64 666s autopkgtest [23:34:21]: testbed apt version: 3.1.11 666s autopkgtest [23:34:21]: @@@@@@@@@@@@@@@@@@@@ test bed setup 667s autopkgtest [23:34:22]: testbed release detected to be: resolute 667s autopkgtest [23:34:22]: updating testbed package index (apt update) 667s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 667s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 667s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 668s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 668s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [87.9 kB] 668s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [1097 kB] 669s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 669s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [28.8 kB] 669s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [141 kB] 669s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [97.1 kB] 669s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3460 B] 669s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 669s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 669s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 670s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [290 kB] 670s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [762 kB] 670s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [23.5 kB] 670s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [26.0 kB] 670s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [10.1 kB] 670s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [1724 B] 671s Fetched 2735 kB in 3s (878 kB/s) 671s Reading package lists... 672s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 672s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 672s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 672s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 673s Reading package lists... 673s Reading package lists... 673s Building dependency tree... 673s Reading state information... 673s Calculating upgrade... 673s The following packages will be upgraded: 673s dpkg dpkg-dev libdpkg-perl linux-firmware 673s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 673s Need to get 656 MB of archives. 673s After this operation, 13.4 MB of additional disk space will be used. 673s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 dpkg amd64 1.22.21ubuntu5 [1296 kB] 674s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 dpkg-dev all 1.22.21ubuntu5 [1088 kB] 675s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libdpkg-perl all 1.22.21ubuntu5 [280 kB] 675s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 linux-firmware all 20251029.git4f72031f-0ubuntu1 [654 MB] 711s dpkg-preconfigure: unable to re-open stdin: No such file or directory 711s Fetched 656 MB in 38s (17.2 MB/s) 711s (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 ... 78534 files and directories currently installed.) 711s Preparing to unpack .../dpkg_1.22.21ubuntu5_amd64.deb ... 711s Unpacking dpkg (1.22.21ubuntu5) over (1.22.21ubuntu4) ... 711s Setting up dpkg (1.22.21ubuntu5) ... 712s (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 ... 78534 files and directories currently installed.) 712s Preparing to unpack .../dpkg-dev_1.22.21ubuntu5_all.deb ... 712s Unpacking dpkg-dev (1.22.21ubuntu5) over (1.22.21ubuntu4) ... 712s Preparing to unpack .../libdpkg-perl_1.22.21ubuntu5_all.deb ... 712s Unpacking libdpkg-perl (1.22.21ubuntu5) over (1.22.21ubuntu4) ... 712s Preparing to unpack .../linux-firmware_20251029.git4f72031f-0ubuntu1_all.deb ... 712s Unpacking linux-firmware (20251029.git4f72031f-0ubuntu1) over (20251009.git46a6999a-0ubuntu1) ... 713s Setting up linux-firmware (20251029.git4f72031f-0ubuntu1) ... 713s Setting up libdpkg-perl (1.22.21ubuntu5) ... 713s Setting up dpkg-dev (1.22.21ubuntu5) ... 713s Processing triggers for man-db (2.13.1-1) ... 715s Processing triggers for initramfs-tools (0.150ubuntu4) ... 715s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 719s autopkgtest [23:35:14]: upgrading testbed (apt dist-upgrade and autopurge) 719s Reading package lists... 719s Building dependency tree... 719s Reading state information... 719s Calculating upgrade... 719s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 720s Reading package lists... 720s Building dependency tree... 720s Reading state information... 720s Solving dependencies... 720s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 720s autopkgtest [23:35:15]: rebooting testbed after setup commands that affected boot 738s Reading package lists... 739s Building dependency tree... 739s Reading state information... 739s Solving dependencies... 739s The following NEW packages will be installed: 739s build-essential clang-21 cpp cpp-15 cpp-15-x86-64-linux-gnu 739s cpp-x86-64-linux-gnu g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu 739s gcc gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 739s libclang-common-21-dev libclang-cpp21 libclang1-21 libecpg-compat3 739s libecpg-dev libecpg6 libffi-dev libgc1 libgcc-15-dev libgomp1 libhwasan0 739s libicu76 libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl 739s libllvm21 liblsan0 liblzma-dev libmpc3 libncurses-dev libobjc-15-dev 739s libobjc4 libpfm4 libpgtypes3 libpq-dev libpq-oauth libpq5 libquadmath0 739s libssl-dev libstdc++-15-dev libtcl8.6 libtsan2 libubsan1 liburing2 739s libxml2-dev libxslt1.1 llvm-21 llvm-21-dev llvm-21-linker-tools 739s llvm-21-runtime llvm-21-tools postgresql-18 postgresql-18-jit 739s postgresql-client-18 postgresql-client-common postgresql-common 739s postgresql-common-dev postgresql-doc-18 postgresql-plperl-18 739s postgresql-plpython3-18 postgresql-pltcl-18 postgresql-server-dev-18 739s ssl-cert tzdata-legacy zlib1g-dev 739s 0 upgraded, 73 newly installed, 0 to remove and 0 not upgraded. 739s Need to get 242 MB of archives. 739s After this operation, 1149 MB of additional disk space will be used. 739s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 739s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 739s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 739s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 739s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 739s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 739s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 739s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 739s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 739s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 750s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 750s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 750s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 750s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 750s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 750s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 750s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 751s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 752s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 754s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 755s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 756s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 756s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 758s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 771s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 771s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 771s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 771s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 772s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 774s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 774s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 774s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 774s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 774s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 776s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 777s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 777s Get:37 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 777s Get:38 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 777s Get:39 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 777s Get:40 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 777s Get:41 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 778s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 778s Get:43 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 778s Get:44 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 778s Get:45 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 778s Get:46 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 778s Get:47 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 778s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 778s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 778s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 779s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 779s Get:52 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 779s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 779s Get:54 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 liburing2 amd64 2.12-1 [24.7 kB] 779s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 779s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 779s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 779s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 779s Get:59 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 779s Get:60 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 779s Get:61 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 781s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 781s Get:63 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 781s Get:64 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 783s Get:65 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 784s Get:66 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 784s Get:67 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 784s Get:68 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 784s Get:69 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 784s Get:70 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 784s Get:71 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 784s Get:72 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 784s Get:73 http://ftpmaster.internal/ubuntu resolute/main amd64 tzdata-legacy all 2025b-5ubuntu1 [99.3 kB] 785s Preconfiguring packages ... 785s Fetched 242 MB in 46s (5307 kB/s) 785s Selecting previously unselected package libjson-perl. 785s (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.) 785s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 785s Unpacking libjson-perl (4.10000-1) ... 785s Selecting previously unselected package postgresql-client-common. 785s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 785s Unpacking postgresql-client-common (282ubuntu1) ... 785s Selecting previously unselected package libio-pty-perl. 785s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 785s Unpacking libio-pty-perl (1:1.20-1build3) ... 785s Selecting previously unselected package libipc-run-perl. 785s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 785s Unpacking libipc-run-perl (20231003.0-2) ... 785s Selecting previously unselected package postgresql-common-dev. 785s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 785s Unpacking postgresql-common-dev (282ubuntu1) ... 785s Selecting previously unselected package ssl-cert. 785s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 785s Unpacking ssl-cert (1.1.3ubuntu1) ... 785s Selecting previously unselected package postgresql-common. 785s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 785s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 785s Unpacking postgresql-common (282ubuntu1) ... 785s Selecting previously unselected package libisl23:amd64. 785s Preparing to unpack .../07-libisl23_0.27-1_amd64.deb ... 785s Unpacking libisl23:amd64 (0.27-1) ... 785s Selecting previously unselected package libmpc3:amd64. 785s Preparing to unpack .../08-libmpc3_1.3.1-1build3_amd64.deb ... 785s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 785s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 785s Preparing to unpack .../09-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package cpp-15. 785s Preparing to unpack .../10-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package cpp-x86-64-linux-gnu. 785s Preparing to unpack .../11-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 785s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 785s Selecting previously unselected package cpp. 785s Preparing to unpack .../12-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 785s Unpacking cpp (4:15.2.0-4ubuntu1) ... 785s Selecting previously unselected package libcc1-0:amd64. 785s Preparing to unpack .../13-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libgomp1:amd64. 785s Preparing to unpack .../14-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libitm1:amd64. 785s Preparing to unpack .../15-libitm1_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libasan8:amd64. 785s Preparing to unpack .../16-libasan8_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package liblsan0:amd64. 785s Preparing to unpack .../17-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libtsan2:amd64. 785s Preparing to unpack .../18-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libubsan1:amd64. 785s Preparing to unpack .../19-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libhwasan0:amd64. 785s Preparing to unpack .../20-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libquadmath0:amd64. 785s Preparing to unpack .../21-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package libgcc-15-dev:amd64. 785s Preparing to unpack .../22-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 785s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 785s Preparing to unpack .../23-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 785s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package gcc-15. 786s Preparing to unpack .../24-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package gcc-x86-64-linux-gnu. 786s Preparing to unpack .../25-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 786s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 786s Selecting previously unselected package gcc. 786s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 786s Unpacking gcc (4:15.2.0-4ubuntu1) ... 786s Selecting previously unselected package libstdc++-15-dev:amd64. 786s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package g++-15-x86-64-linux-gnu. 786s Preparing to unpack .../28-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package g++-15. 786s Preparing to unpack .../29-g++-15_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking g++-15 (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package g++-x86-64-linux-gnu. 786s Preparing to unpack .../30-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 786s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 786s Selecting previously unselected package g++. 786s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 786s Unpacking g++ (4:15.2.0-4ubuntu1) ... 786s Selecting previously unselected package build-essential. 786s Preparing to unpack .../32-build-essential_12.12ubuntu1_amd64.deb ... 786s Unpacking build-essential (12.12ubuntu1) ... 786s Selecting previously unselected package libllvm21:amd64. 786s Preparing to unpack .../33-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 786s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 786s Selecting previously unselected package libclang-cpp21. 786s Preparing to unpack .../34-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 786s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 786s Selecting previously unselected package libgc1:amd64. 786s Preparing to unpack .../35-libgc1_1%3a8.2.10-1_amd64.deb ... 786s Unpacking libgc1:amd64 (1:8.2.10-1) ... 786s Selecting previously unselected package libobjc4:amd64. 786s Preparing to unpack .../36-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package libobjc-15-dev:amd64. 786s Preparing to unpack .../37-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 786s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 786s Selecting previously unselected package libclang-common-21-dev:amd64. 786s Preparing to unpack .../38-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 786s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 786s Selecting previously unselected package llvm-21-linker-tools. 786s Preparing to unpack .../39-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 786s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package libclang1-21. 787s Preparing to unpack .../40-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package clang-21. 787s Preparing to unpack .../41-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package libpgtypes3:amd64. 787s Preparing to unpack .../42-libpgtypes3_18.0-1_amd64.deb ... 787s Unpacking libpgtypes3:amd64 (18.0-1) ... 787s Selecting previously unselected package libpq5:amd64. 787s Preparing to unpack .../43-libpq5_18.0-1_amd64.deb ... 787s Unpacking libpq5:amd64 (18.0-1) ... 787s Selecting previously unselected package libecpg6:amd64. 787s Preparing to unpack .../44-libecpg6_18.0-1_amd64.deb ... 787s Unpacking libecpg6:amd64 (18.0-1) ... 787s Selecting previously unselected package libecpg-compat3:amd64. 787s Preparing to unpack .../45-libecpg-compat3_18.0-1_amd64.deb ... 787s Unpacking libecpg-compat3:amd64 (18.0-1) ... 787s Selecting previously unselected package libssl-dev:amd64. 787s Preparing to unpack .../46-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 787s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 787s Selecting previously unselected package libpq-dev. 787s Preparing to unpack .../47-libpq-dev_18.0-1_amd64.deb ... 787s Unpacking libpq-dev (18.0-1) ... 787s Selecting previously unselected package libecpg-dev. 787s Preparing to unpack .../48-libecpg-dev_18.0-1_amd64.deb ... 787s Unpacking libecpg-dev (18.0-1) ... 787s Selecting previously unselected package libicu76:amd64. 787s Preparing to unpack .../49-libicu76_76.1-4ubuntu2_amd64.deb ... 787s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 787s Selecting previously unselected package libncurses-dev:amd64. 787s Preparing to unpack .../50-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 787s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 787s Selecting previously unselected package libpq-oauth:amd64. 787s Preparing to unpack .../51-libpq-oauth_18.0-1_amd64.deb ... 787s Unpacking libpq-oauth:amd64 (18.0-1) ... 787s Selecting previously unselected package libtcl8.6:amd64. 787s Preparing to unpack .../52-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 787s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 787s Selecting previously unselected package liburing2:amd64. 787s Preparing to unpack .../53-liburing2_2.12-1_amd64.deb ... 787s Unpacking liburing2:amd64 (2.12-1) ... 787s Selecting previously unselected package liblzma-dev:amd64. 787s Preparing to unpack .../54-liblzma-dev_5.8.1-1build2_amd64.deb ... 787s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 787s Selecting previously unselected package zlib1g-dev:amd64. 787s Preparing to unpack .../55-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 787s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 787s Selecting previously unselected package libxml2-dev:amd64. 787s Preparing to unpack .../56-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 787s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 787s Selecting previously unselected package libxslt1.1:amd64. 787s Preparing to unpack .../57-libxslt1.1_1.1.43-0.3_amd64.deb ... 787s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 787s Selecting previously unselected package llvm-21-runtime. 787s Preparing to unpack .../58-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package libpfm4:amd64. 787s Preparing to unpack .../59-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 787s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 787s Selecting previously unselected package llvm-21. 787s Preparing to unpack .../60-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package libffi-dev:amd64. 787s Preparing to unpack .../61-libffi-dev_3.5.2-2_amd64.deb ... 787s Unpacking libffi-dev:amd64 (3.5.2-2) ... 787s Selecting previously unselected package llvm-21-tools. 787s Preparing to unpack .../62-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 787s Selecting previously unselected package llvm-21-dev. 787s Preparing to unpack .../63-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 787s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 788s Selecting previously unselected package postgresql-client-18. 788s Preparing to unpack .../64-postgresql-client-18_18.0-1_amd64.deb ... 788s Unpacking postgresql-client-18 (18.0-1) ... 788s Selecting previously unselected package postgresql-18. 788s Preparing to unpack .../65-postgresql-18_18.0-1_amd64.deb ... 788s Unpacking postgresql-18 (18.0-1) ... 788s Selecting previously unselected package postgresql-18-jit. 788s Preparing to unpack .../66-postgresql-18-jit_18.0-1_amd64.deb ... 788s Unpacking postgresql-18-jit (18.0-1) ... 788s Selecting previously unselected package postgresql-doc-18. 789s Preparing to unpack .../67-postgresql-doc-18_18.0-1_all.deb ... 789s Unpacking postgresql-doc-18 (18.0-1) ... 789s Selecting previously unselected package postgresql-plperl-18. 789s Preparing to unpack .../68-postgresql-plperl-18_18.0-1_amd64.deb ... 789s Unpacking postgresql-plperl-18 (18.0-1) ... 789s Selecting previously unselected package postgresql-plpython3-18. 789s Preparing to unpack .../69-postgresql-plpython3-18_18.0-1_amd64.deb ... 789s Unpacking postgresql-plpython3-18 (18.0-1) ... 789s Selecting previously unselected package postgresql-pltcl-18. 789s Preparing to unpack .../70-postgresql-pltcl-18_18.0-1_amd64.deb ... 789s Unpacking postgresql-pltcl-18 (18.0-1) ... 789s Selecting previously unselected package postgresql-server-dev-18. 789s Preparing to unpack .../71-postgresql-server-dev-18_18.0-1_amd64.deb ... 789s Unpacking postgresql-server-dev-18 (18.0-1) ... 789s Selecting previously unselected package tzdata-legacy. 789s Preparing to unpack .../72-tzdata-legacy_2025b-5ubuntu1_all.deb ... 789s Unpacking tzdata-legacy (2025b-5ubuntu1) ... 789s Setting up postgresql-client-common (282ubuntu1) ... 789s Setting up libpgtypes3:amd64 (18.0-1) ... 789s Setting up postgresql-doc-18 (18.0-1) ... 789s 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 789s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 789s Setting up libio-pty-perl (1:1.20-1build3) ... 789s Setting up libpq5:amd64 (18.0-1) ... 789s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libffi-dev:amd64 (3.5.2-2) ... 789s Setting up tzdata-legacy (2025b-5ubuntu1) ... 789s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 789s Setting up ssl-cert (1.1.3ubuntu1) ... 789s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 789s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 789s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 789s Setting up libmpc3:amd64 (1.3.1-1build3) ... 789s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 789s Setting up libipc-run-perl (20231003.0-2) ... 789s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 789s Setting up libgc1:amd64 (1:8.2.10-1) ... 789s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 789s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 789s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 789s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libjson-perl (4.10000-1) ... 789s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 789s Setting up libecpg6:amd64 (18.0-1) ... 789s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 789s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 789s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 789s Setting up liburing2:amd64 (2.12-1) ... 789s Setting up libisl23:amd64 (0.27-1) ... 789s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 789s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 789s Setting up postgresql-common-dev (282ubuntu1) ... 789s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 789s Setting up libecpg-compat3:amd64 (18.0-1) ... 789s Setting up postgresql-client-18 (18.0-1) ... 789s 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 789s Setting up libpq-oauth:amd64 (18.0-1) ... 789s Setting up libpq-dev (18.0-1) ... 789s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 789s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 789s Setting up libecpg-dev (18.0-1) ... 789s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 789s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 789s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 789s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 789s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 789s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 789s Setting up postgresql-common (282ubuntu1) ... 790s Creating config file /etc/postgresql-common/createcluster.conf with new version 790s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 790s Removing obsolete dictionary files: 790s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 790s Setting up cpp-15 (15.2.0-7ubuntu1) ... 790s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 790s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 790s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 790s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 790s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 790s Setting up postgresql-18 (18.0-1) ... 791s Creating new PostgreSQL cluster 18/main ... 791s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 791s The files belonging to this database system will be owned by user "postgres". 791s This user must also own the server process. 791s 791s The database cluster will be initialized with locale "C.UTF-8". 791s The default database encoding has accordingly been set to "UTF8". 791s The default text search configuration will be set to "english". 791s 791s Data page checksums are enabled. 791s 791s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 791s creating subdirectories ... ok 791s selecting dynamic shared memory implementation ... posix 791s selecting default "max_connections" ... 100 791s selecting default "shared_buffers" ... 128MB 791s selecting default time zone ... Etc/UTC 791s creating configuration files ... ok 791s running bootstrap script ... ok 791s performing post-bootstrap initialization ... ok 791s syncing data to disk ... ok 794s Setting up postgresql-18-jit (18.0-1) ... 794s Setting up gcc-15 (15.2.0-7ubuntu1) ... 794s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 794s Setting up postgresql-plpython3-18 (18.0-1) ... 794s Setting up cpp (4:15.2.0-4ubuntu1) ... 794s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 794s Setting up postgresql-plperl-18 (18.0-1) ... 794s Setting up g++-15 (15.2.0-7ubuntu1) ... 794s Setting up postgresql-pltcl-18 (18.0-1) ... 794s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 794s Setting up postgresql-server-dev-18 (18.0-1) ... 794s Setting up gcc (4:15.2.0-4ubuntu1) ... 794s Setting up g++ (4:15.2.0-4ubuntu1) ... 794s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 794s Setting up build-essential (12.12ubuntu1) ... 794s Processing triggers for libc-bin (2.42-0ubuntu3) ... 794s Processing triggers for systemd (257.9-0ubuntu2) ... 794s Processing triggers for man-db (2.13.1-1) ... 795s Processing triggers for install-info (7.2-5) ... 807s autopkgtest [23:36:42]: test installcheck: [----------------------- 808s + dpkg-parsechangelog -SSource 808s + SOURCE=postgresql-18 808s + MAJOR=18 808s + top_srcdir=/tmp/autopkgtest.bGVfGy/build.jr5/src 808s + cd src/test/regress 808s + make -f /tmp/autopkgtest.bGVfGy/build.jr5/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config with_llvm=no 808s 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.bGVfGy/build.jr5/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 808s 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 808s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.bGVfGy/build.jr5/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 808s + id -u 808s + [ 1000 = 0 ] 808s + SU=sh 808s + sh 808s + mktemp -d /tmp/regress.XXXXXX 808s + OUTPUT=/tmp/regress.dHepTd 808s + trap rm -rf /tmp/regress.dHepTd EXIT 808s + pg_virtualenv -v 18 /usr/lib/postgresql/18/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.dHepTd --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 808s Creating new PostgreSQL cluster 18/regress ... 811s # using postmaster on localhost, port 5433 811s ok 1 - test_setup 107 ms 811s # parallel group (20 tests): char oid varchar pg_lsn name text int2 int4 txid money regproc float4 int8 float8 enum uuid bit boolean numeric rangetypes 811s ok 2 + boolean 290 ms 811s ok 3 + char 81 ms 811s ok 4 + name 111 ms 811s ok 5 + varchar 97 ms 811s ok 6 + text 121 ms 811s ok 7 + int2 131 ms 811s ok 8 + int4 131 ms 811s ok 9 + int8 167 ms 811s ok 10 + oid 90 ms 811s ok 11 + float4 164 ms 811s ok 12 + float8 171 ms 811s ok 13 + bit 251 ms 811s ok 14 + numeric 341 ms 811s ok 15 + txid 136 ms 811s ok 16 + uuid 200 ms 811s ok 17 + enum 188 ms 811s ok 18 + money 134 ms 811s ok 19 + rangetypes 350 ms 811s ok 20 + pg_lsn 94 ms 811s ok 21 + regproc 144 ms 812s # parallel group (20 tests): lseg md5 circle path line time macaddr timetz numerology macaddr8 date inet interval strings polygon point multirangetypes box timestamp timestamptz 812s ok 22 + strings 233 ms 812s ok 23 + md5 80 ms 812s ok 24 + numerology 132 ms 812s ok 25 + point 294 ms 812s ok 26 + lseg 35 ms 812s ok 27 + line 92 ms 812s ok 28 + box 317 ms 812s ok 29 + path 89 ms 812s ok 30 + polygon 289 ms 812s ok 31 + circle 88 ms 812s ok 32 + date 170 ms 812s ok 33 + time 109 ms 812s ok 34 + timetz 128 ms 812s ok 35 + timestamp 403 ms 812s ok 36 + timestamptz 421 ms 812s ok 37 + interval 226 ms 812s ok 38 + inet 175 ms 812s ok 39 + macaddr 107 ms 812s ok 40 + macaddr8 141 ms 812s ok 41 + multirangetypes 299 ms 812s # parallel group (14 tests): comments unicode misc_sanity tstypes expressions mvcc xid type_sanity stats_import geometry opr_sanity horology database regex 812s ok 42 + geometry 257 ms 812s ok 43 + horology 359 ms 812s ok 44 + tstypes 123 ms 812s ok 45 + regex 390 ms 812s ok 46 + type_sanity 186 ms 812s ok 47 + opr_sanity 322 ms 812s ok 48 + misc_sanity 62 ms 812s ok 49 + comments 49 ms 812s ok 50 + expressions 124 ms 812s ok 51 + unicode 54 ms 812s ok 52 + xid 129 ms 812s ok 53 + mvcc 125 ms 812s ok 54 + database 360 ms 812s ok 55 + stats_import 226 ms 812s # parallel group (6 tests): copyencoding copyselect copydml copy insert_conflict insert 812s ok 56 + copy 78 ms 812s ok 57 + copyselect 42 ms 812s ok 58 + copydml 50 ms 812s ok 59 + copyencoding 32 ms 812s ok 60 + insert 182 ms 812s ok 61 + insert_conflict 111 ms 813s # parallel group (7 tests): create_function_c create_schema create_operator create_type create_misc create_procedure create_table 813s ok 62 + create_function_c 39 ms 813s ok 63 + create_misc 71 ms 813s ok 64 + create_operator 49 ms 813s ok 65 + create_procedure 78 ms 813s ok 66 + create_table 183 ms 813s ok 67 + create_type 64 ms 813s ok 68 + create_schema 45 ms 813s # parallel group (5 tests): index_including_gist index_including create_view create_index_spgist create_index 813s ok 69 + create_index 399 ms 813s ok 70 + create_index_spgist 297 ms 813s ok 71 + create_view 243 ms 813s ok 72 + index_including 201 ms 813s ok 73 + index_including_gist 197 ms 814s # parallel group (16 tests): create_cast create_aggregate errors hash_func roleattributes select drop_if_exists typed_table create_am create_function_sql infinite_recurse vacuum constraints updatable_views triggers inherit 814s ok 74 + create_aggregate 87 ms 814s ok 75 + create_function_sql 251 ms 814s ok 76 + create_cast 80 ms 814s ok 77 + constraints 635 ms 814s ok 78 + triggers 703 ms 814s ok 79 + select 171 ms 814s ok 80 + inherit 831 ms 814s ok 81 + typed_table 198 ms 814s ok 82 + vacuum 429 ms 814s ok 83 + drop_if_exists 168 ms 814s ok 84 + updatable_views 692 ms 814s ok 85 + roleattributes 121 ms 814s ok 86 + create_am 206 ms 814s ok 87 + hash_func 101 ms 814s ok 88 + errors 89 ms 814s ok 89 + infinite_recurse 316 ms 814s ok 90 - sanity_check 44 ms 815s # parallel group (20 tests): select_having select_implicit delete select_distinct_on case random namespace prepared_xacts select_into transactions portals union select_distinct subselect arrays hash_index update aggregates btree_index join 815s ok 91 + select_into 237 ms 815s ok 92 + select_distinct 457 ms 815s ok 93 + select_distinct_on 150 ms 815s ok 94 + select_implicit 139 ms 815s ok 95 + select_having 122 ms 815s ok 96 + subselect 502 ms 815s ok 97 + union 381 ms 815s ok 98 + case 155 ms 815s ok 99 + join 1282 ms 815s ok 100 + aggregates 1020 ms 815s ok 101 + transactions 307 ms 815s ok 102 + random 184 ms 815s ok 103 + portals 328 ms 815s ok 104 + arrays 600 ms 815s ok 105 + btree_index 1020 ms 815s ok 106 + hash_index 713 ms 815s ok 107 + update 735 ms 815s ok 108 + delete 147 ms 815s ok 109 + namespace 196 ms 815s ok 110 + prepared_xacts 202 ms 819s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password collate replica_identity matview identity spgist generated_stored gist rowsecurity groupingsets gin join_hash brin privileges 819s ok 111 + brin 3265 ms 819s ok 112 + gin 1323 ms 819s ok 113 + gist 1166 ms 819s ok 114 + spgist 921 ms 819s ok 115 + privileges 3456 ms 819s ok 116 + init_privs 99 ms 819s ok 117 + security_label 123 ms 819s ok 118 + collate 425 ms 819s ok 119 + matview 756 ms 819s ok 120 + lock 255 ms 819s ok 121 + replica_identity 469 ms 819s ok 122 + rowsecurity 1206 ms 819s ok 123 + object_address 298 ms 819s ok 124 + tablesample 204 ms 819s ok 125 + groupingsets 1270 ms 819s ok 126 + drop_operator 98 ms 819s ok 127 + password 344 ms 819s ok 128 + identity 775 ms 819s ok 129 + generated_stored 1109 ms 819s ok 130 + join_hash 3244 ms 819s # parallel group (2 tests): brin_bloom brin_multi 819s ok 131 + brin_bloom 58 ms 819s ok 132 + brin_multi 117 ms 820s # parallel group (19 tests): async dbsize tidrangescan tid collate.utf8 tidscan alter_operator tsrf create_role alter_generic incremental_sort sysviews misc_functions create_table_like merge generated_virtual without_overlaps collate.icu.utf8 misc 820s ok 133 + create_table_like 582 ms 820s ok 134 + alter_generic 268 ms 820s ok 135 + alter_operator 153 ms 820s ok 136 + misc 783 ms 820s ok 137 + async 66 ms 820s ok 138 + dbsize 75 ms 820s ok 139 + merge 579 ms 820s ok 140 + misc_functions 375 ms 820s ok 141 + sysviews 348 ms 820s ok 142 + tsrf 155 ms 820s ok 143 + tid 133 ms 820s ok 144 + tidscan 147 ms 820s ok 145 + tidrangescan 130 ms 820s ok 146 + collate.utf8 144 ms 820s ok 147 + collate.icu.utf8 770 ms 820s ok 148 + incremental_sort 318 ms 820s ok 149 + create_role 183 ms 820s ok 150 + without_overlaps 695 ms 820s ok 151 + generated_virtual 630 ms 820s # parallel group (8 tests): amutils collate.windows.win1252 collate.linux.utf8 psql_crosstab psql_pipeline rules psql stats_ext 820s ok 152 + rules 303 ms 820s ok 153 + psql 355 ms 820s ok 154 + psql_crosstab 65 ms 820s ok 155 + psql_pipeline 68 ms 820s ok 156 + amutils 30 ms 820s ok 157 + stats_ext 744 ms 820s ok 158 + collate.linux.utf8 37 ms 820s ok 159 + collate.windows.win1252 33 ms 822s ok 160 - select_parallel 1329 ms 822s ok 161 - write_parallel 60 ms 822s ok 162 - vacuum_parallel 44 ms 822s ok 163 - maintain_every 13 ms 823s # parallel group (2 tests): subscription publication 823s ok 164 + publication 1032 ms 823s ok 165 + subscription 33 ms 824s # parallel group (17 tests): combocid portals_p2 advisory_lock xmlmap functional_deps equivclass dependency guc tsdicts select_views window bitmapops indirect_toast cluster tsearch foreign_data foreign_key 824s ok 166 + select_views 256 ms 824s ok 167 + portals_p2 105 ms 824s ok 168 + foreign_key 828 ms 824s ok 169 + cluster 500 ms 824s ok 170 + dependency 197 ms 824s ok 171 + guc 214 ms 824s ok 172 + bitmapops 427 ms 824s ok 173 + combocid 74 ms 824s ok 174 + tsearch 505 ms 824s ok 175 + tsdicts 213 ms 824s ok 176 + foreign_data 625 ms 824s ok 177 + window 356 ms 824s ok 178 + xmlmap 131 ms 824s ok 179 + functional_deps 194 ms 824s ok 180 + advisory_lock 126 ms 824s ok 181 + indirect_toast 445 ms 824s ok 182 + equivclass 189 ms 824s # parallel group (9 tests): jsonpath jsonpath_encoding json_encoding sqljson_jsontable sqljson json sqljson_queryfuncs jsonb jsonb_jsonpath 824s ok 183 + json 166 ms 824s ok 184 + jsonb 185 ms 824s ok 185 + json_encoding 49 ms 824s ok 186 + jsonpath 46 ms 824s ok 187 + jsonpath_encoding 48 ms 824s ok 188 + jsonb_jsonpath 192 ms 824s ok 189 + sqljson 123 ms 824s ok 190 + sqljson_queryfuncs 167 ms 824s ok 191 + sqljson_jsontable 113 ms 825s # parallel group (18 tests): prepare conversion limit plancache copy2 returning sequence rowtypes polymorphism truncate temp largeobject domain with rangefuncs plpgsql xml alter_table 825s ok 192 + plancache 308 ms 825s ok 193 + limit 297 ms 825s ok 194 + plpgsql 800 ms 825s ok 195 + copy2 352 ms 825s ok 196 + temp 577 ms 825s ok 197 + domain 672 ms 825s ok 198 + rangefuncs 717 ms 825s ok 199 + prepare 139 ms 825s ok 200 + conversion 270 ms 825s ok 201 + truncate 544 ms 825s ok 202 + alter_table 1219 ms 825s ok 203 + sequence 481 ms 825s ok 204 + polymorphism 536 ms 825s ok 205 + rowtypes 510 ms 825s ok 206 + returning 374 ms 825s ok 207 + largeobject 626 ms 825s ok 208 + with 680 ms 825s ok 209 + xml 803 ms 826s # parallel group (14 tests): hash_part explain reloptions partition_info predicate numa memoize compression partition_aggregate partition_join tuplesort stats indexing partition_prune 826s ok 210 + partition_join 885 ms 826s ok 211 + partition_prune 1168 ms 826s ok 212 + reloptions 164 ms 826s ok 213 + hash_part 70 ms 826s ok 214 + indexing 1029 ms 826s ok 215 + partition_aggregate 862 ms 826s ok 216 + partition_info 189 ms 826s ok 217 + tuplesort 976 ms 826s ok 218 + explain 162 ms 826s ok 219 + compression 354 ms 826s ok 220 + memoize 292 ms 826s ok 221 + stats 1025 ms 826s ok 222 + predicate 205 ms 826s ok 223 + numa 206 ms 826s # parallel group (2 tests): oidjoins event_trigger 826s ok 224 + oidjoins 105 ms 826s ok 225 + event_trigger 117 ms 827s ok 226 - event_trigger_login 25 ms 827s ok 227 - fast_default 64 ms 827s ok 228 - tablespace 177 ms 827s 1..228 827s # All 228 tests passed. 827s Dropping cluster 18/regress ... 827s + rm -rf /tmp/regress.dHepTd 827s autopkgtest [23:37:02]: test installcheck: -----------------------] 828s installcheck PASS 828s autopkgtest [23:37:03]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 828s autopkgtest [23:37:03]: @@@@@@@@@@@@@@@@@@@@ summary 828s run-testsuite PASS 828s installcheck PASS