0s autopkgtest [20:30:08]: starting date and time: 2025-12-02 20:30:08+0000 0s autopkgtest [20:30:08]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [20:30:08]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.95v8kav8/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:iproute2,src:dhcpcd --apt-upgrade postgresql-16 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=iproute2/6.1.0-1ubuntu6.3 dhcpcd/1:10.0.6-1ubuntu3.2' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-amd64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@sto01-1.secgroup --name adt-noble-amd64-postgresql-16-20251202-203008-juju-7f2275-prod-proposed-migration-environment-2-a0bf97ab-138a-42a7-a882-14b75650200e --image adt/ubuntu-noble-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-autopkgtest-workers-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 4s Creating nova instance adt-noble-amd64-postgresql-16-20251202-203008-juju-7f2275-prod-proposed-migration-environment-2-a0bf97ab-138a-42a7-a882-14b75650200e from image adt/ubuntu-noble-amd64-server-20251202.img (UUID ad7930e4-8fde-4e81-aa84-386fd598d2b2)... 55s autopkgtest [20:31:03]: testbed dpkg architecture: amd64 55s autopkgtest [20:31:03]: testbed apt version: 2.8.3 55s autopkgtest [20:31:03]: @@@@@@@@@@@@@@@@@@@@ test bed setup 55s autopkgtest [20:31:03]: testbed release detected to be: None 56s autopkgtest [20:31:04]: updating testbed package index (apt update) 56s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 56s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 56s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 56s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 56s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [41.8 kB] 56s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6376 B] 56s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [24.9 kB] 56s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [62.8 kB] 57s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [75.1 kB] 57s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [432 kB] 57s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [2668 B] 57s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [14.8 kB] 57s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [874 kB] 57s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [372 B] 57s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [45.0 kB] 57s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [130 kB] 57s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [2492 B] 57s Get:18 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [752 B] 57s Get:19 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [2956 B] 57s Get:20 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [268 B] 58s Fetched 1981 kB in 1s (2398 kB/s) 58s Reading package lists... 59s Hit:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease 59s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 59s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 59s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 60s Reading package lists... 60s Reading package lists... 60s Building dependency tree... 60s Reading state information... 61s Calculating upgrade... 61s The following packages will be upgraded: 61s dhcpcd-base iproute2 wireless-regdb 61s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 61s Need to get 1343 kB of archives. 61s After this operation, 5120 B of additional disk space will be used. 61s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 dhcpcd-base amd64 1:10.0.6-1ubuntu3.2 [215 kB] 61s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 iproute2 amd64 6.1.0-1ubuntu6.3 [1120 kB] 61s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 wireless-regdb all 2025.07.10-0ubuntu1~24.04.1 [7502 B] 62s debconf: unable to initialize frontend: Dialog 62s debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) 62s debconf: falling back to frontend: Readline 62s debconf: unable to initialize frontend: Readline 62s debconf: (This frontend requires a controlling tty.) 62s debconf: falling back to frontend: Teletype 62s dpkg-preconfigure: unable to re-open stdin: 62s Fetched 1343 kB in 1s (2191 kB/s) 62s (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 ... 74807 files and directories currently installed.) 62s Preparing to unpack .../dhcpcd-base_1%3a10.0.6-1ubuntu3.2_amd64.deb ... 62s Unpacking dhcpcd-base (1:10.0.6-1ubuntu3.2) over (1:10.0.6-1ubuntu3.1) ... 62s Preparing to unpack .../iproute2_6.1.0-1ubuntu6.3_amd64.deb ... 62s Unpacking iproute2 (6.1.0-1ubuntu6.3) over (6.1.0-1ubuntu6.2) ... 62s Preparing to unpack .../wireless-regdb_2025.07.10-0ubuntu1~24.04.1_all.deb ... 62s Unpacking wireless-regdb (2025.07.10-0ubuntu1~24.04.1) over (2024.10.07-0ubuntu2~24.04.1) ... 62s Setting up iproute2 (6.1.0-1ubuntu6.3) ... 62s debconf: unable to initialize frontend: Dialog 62s debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) 62s debconf: falling back to frontend: Readline 62s debconf: unable to initialize frontend: Readline 62s debconf: (This frontend requires a controlling tty.) 62s debconf: falling back to frontend: Teletype 62s Setting up wireless-regdb (2025.07.10-0ubuntu1~24.04.1) ... 62s Setting up dhcpcd-base (1:10.0.6-1ubuntu3.2) ... 62s Processing triggers for man-db (2.12.0-4build2) ... 63s autopkgtest [20:31:11]: upgrading testbed (apt dist-upgrade and autopurge) 63s Reading package lists... 63s Building dependency tree... 63s Reading state information... 63s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 63s Starting 2 pkgProblemResolver with broken count: 0 63s Done 64s Entering ResolveByKeep 64s 64s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s Reading package lists... 65s Building dependency tree... 65s Reading state information... 65s Starting pkgProblemResolver with broken count: 0 65s Starting 2 pkgProblemResolver with broken count: 0 65s Done 65s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 67s autopkgtest [20:31:15]: testbed running kernel: Linux 6.8.0-88-generic #89-Ubuntu SMP PREEMPT_DYNAMIC Sat Oct 11 01:02:46 UTC 2025 68s autopkgtest [20:31:16]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-16 76s Get:1 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.10-0ubuntu0.24.04.1 (dsc) [4336 B] 76s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.10-0ubuntu0.24.04.1 (tar) [32.9 MB] 76s Get:3 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.10-0ubuntu0.24.04.1 (diff) [36.9 kB] 76s gpgv: Signature made Fri Sep 5 13:11:46 2025 UTC 76s gpgv: using RSA key 5673973A86367CECF482100AB92697DB02554590 76s gpgv: Can't check signature: No public key 76s dpkg-source: warning: cannot verify inline signature for ./postgresql-16_16.10-0ubuntu0.24.04.1.dsc: no acceptable signature found 77s autopkgtest [20:31:25]: testing package postgresql-16 version 16.10-0ubuntu0.24.04.1 79s autopkgtest [20:31:27]: build not needed 88s autopkgtest [20:31:36]: test run-testsuite: preparing testbed 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 89s Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 89s The following NEW packages will be installed: 89s autoconf automake autopoint autotools-dev build-essential clang-17 cpp 89s cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 89s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 89s fakeroot g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-13 89s gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext 89s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 89s libatomic1 libcc1-0 libclang-common-17-dev libclang-cpp17t64 libclang1-17t64 89s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 89s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 89s libhwasan0 libicu-dev libisl23 libitm1 libjson-perl libllvm17t64 liblsan0 89s libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 89s libpq5 libquadmath0 libssl-dev libstdc++-13-dev libsub-override-perl 89s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 89s libz3-dev llvm-17 llvm-17-dev llvm-17-linker-tools llvm-17-runtime 89s llvm-17-tools locales-all m4 po-debconf postgresql-16 postgresql-client-16 89s postgresql-client-common postgresql-common postgresql-doc-16 89s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 89s postgresql-server-dev-16 ssl-cert 89s 0 upgraded, 93 newly installed, 0 to remove and 0 not upgraded. 89s Need to get 238 MB of archives. 89s After this operation, 1319 MB of additional disk space will be used. 89s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 89s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-common all 257build1.1 [36.4 kB] 89s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 89s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-common all 257build1.1 [161 kB] 89s Get:5 http://ftpmaster.internal/ubuntu noble/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 89s Get:6 http://ftpmaster.internal/ubuntu noble/main amd64 autoconf all 2.71-3 [339 kB] 89s Get:7 http://ftpmaster.internal/ubuntu noble/main amd64 autotools-dev all 20220109.1 [44.9 kB] 89s Get:8 http://ftpmaster.internal/ubuntu noble/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 89s Get:9 http://ftpmaster.internal/ubuntu noble/main amd64 autopoint all 0.21-14ubuntu2 [422 kB] 89s Get:10 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-base amd64 13.3.0-6ubuntu2~24.04 [51.5 kB] 89s Get:11 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libisl23 amd64 0.26-3build1.1 [680 kB] 89s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libmpc3 amd64 1.3.1-1build1.1 [54.6 kB] 89s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [10.7 MB] 90s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13 amd64 13.3.0-6ubuntu2~24.04 [1038 B] 90s Get:15 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 90s Get:16 http://ftpmaster.internal/ubuntu noble/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 90s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libcc1-0 amd64 14.2.0-4ubuntu2~24.04 [48.0 kB] 90s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgomp1 amd64 14.2.0-4ubuntu2~24.04 [148 kB] 90s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libitm1 amd64 14.2.0-4ubuntu2~24.04 [29.7 kB] 90s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libatomic1 amd64 14.2.0-4ubuntu2~24.04 [10.5 kB] 90s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libasan8 amd64 14.2.0-4ubuntu2~24.04 [3031 kB] 90s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main amd64 liblsan0 amd64 14.2.0-4ubuntu2~24.04 [1322 kB] 90s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libtsan2 amd64 14.2.0-4ubuntu2~24.04 [2772 kB] 90s Get:24 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libubsan1 amd64 14.2.0-4ubuntu2~24.04 [1184 kB] 90s Get:25 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libhwasan0 amd64 14.2.0-4ubuntu2~24.04 [1641 kB] 90s Get:26 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libquadmath0 amd64 14.2.0-4ubuntu2~24.04 [153 kB] 90s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgcc-13-dev amd64 13.3.0-6ubuntu2~24.04 [2681 kB] 90s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [21.1 MB] 90s Get:29 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13 amd64 13.3.0-6ubuntu2~24.04 [494 kB] 90s Get:30 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 90s Get:31 http://ftpmaster.internal/ubuntu noble/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 90s Get:32 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libstdc++-13-dev amd64 13.3.0-6ubuntu2~24.04 [2420 kB] 90s Get:33 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [12.2 MB] 91s Get:34 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13 amd64 13.3.0-6ubuntu2~24.04 [16.1 kB] 91s Get:35 http://ftpmaster.internal/ubuntu noble/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 91s Get:36 http://ftpmaster.internal/ubuntu noble/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 91s Get:37 http://ftpmaster.internal/ubuntu noble/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 91s Get:38 http://ftpmaster.internal/ubuntu noble/main amd64 libllvm17t64 amd64 1:17.0.6-9ubuntu1 [26.2 MB] 91s Get:39 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-cpp17t64 amd64 1:17.0.6-9ubuntu1 [12.9 MB] 91s Get:40 http://ftpmaster.internal/ubuntu noble/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 91s Get:41 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc4 amd64 14.2.0-4ubuntu2~24.04 [47.0 kB] 91s Get:42 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc-13-dev amd64 13.3.0-6ubuntu2~24.04 [194 kB] 91s Get:43 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-common-17-dev amd64 1:17.0.6-9ubuntu1 [690 kB] 91s Get:44 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-linker-tools amd64 1:17.0.6-9ubuntu1 [1308 kB] 91s Get:45 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang1-17t64 amd64 1:17.0.6-9ubuntu1 [7353 kB] 92s Get:46 http://ftpmaster.internal/ubuntu noble/universe amd64 clang-17 amd64 1:17.0.6-9ubuntu1 [78.6 kB] 92s Get:47 http://ftpmaster.internal/ubuntu noble/main amd64 libdebhelper-perl all 13.14.1ubuntu5 [89.8 kB] 92s Get:48 http://ftpmaster.internal/ubuntu noble/main amd64 libtool all 2.4.7-7build1 [166 kB] 92s Get:49 http://ftpmaster.internal/ubuntu noble/main amd64 dh-autoreconf all 20 [16.1 kB] 92s Get:50 http://ftpmaster.internal/ubuntu noble/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 92s Get:51 http://ftpmaster.internal/ubuntu noble/main amd64 libsub-override-perl all 0.10-1 [10.0 kB] 92s Get:52 http://ftpmaster.internal/ubuntu noble/main amd64 libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 92s Get:53 http://ftpmaster.internal/ubuntu noble/main amd64 dh-strip-nondeterminism all 1.13.1-1 [5362 B] 92s Get:54 http://ftpmaster.internal/ubuntu noble/main amd64 debugedit amd64 1:5.0-5build2 [46.1 kB] 92s Get:55 http://ftpmaster.internal/ubuntu noble/main amd64 dwz amd64 0.15-1build6 [115 kB] 92s Get:56 http://ftpmaster.internal/ubuntu noble/main amd64 gettext amd64 0.21-14ubuntu2 [864 kB] 92s Get:57 http://ftpmaster.internal/ubuntu noble/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 92s Get:58 http://ftpmaster.internal/ubuntu noble/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 92s Get:59 http://ftpmaster.internal/ubuntu noble/main amd64 debhelper all 13.14.1ubuntu5 [869 kB] 92s Get:60 http://ftpmaster.internal/ubuntu noble/main amd64 emacsen-common all 3.0.5 [12.1 kB] 92s Get:61 http://ftpmaster.internal/ubuntu noble/main amd64 dictionaries-common all 1.29.7 [188 kB] 92s Get:62 http://ftpmaster.internal/ubuntu noble/main amd64 libfakeroot amd64 1.33-1 [32.4 kB] 92s Get:63 http://ftpmaster.internal/ubuntu noble/main amd64 fakeroot amd64 1.33-1 [67.2 kB] 92s Get:64 http://ftpmaster.internal/ubuntu noble/main amd64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 92s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main amd64 icu-devtools amd64 74.2-1ubuntu3.1 [212 kB] 92s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpgtypes3 amd64 16.10-0ubuntu0.24.04.1 [46.3 kB] 92s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq5 amd64 16.10-0ubuntu0.24.04.1 [144 kB] 92s Get:68 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg6 amd64 16.10-0ubuntu0.24.04.1 [44.6 kB] 92s Get:69 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-compat3 amd64 16.10-0ubuntu0.24.04.1 [12.4 kB] 92s Get:70 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libssl-dev amd64 3.0.13-0ubuntu3.6 [2408 kB] 92s Get:71 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq-dev amd64 16.10-0ubuntu0.24.04.1 [151 kB] 92s Get:72 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-dev amd64 16.10-0ubuntu0.24.04.1 [266 kB] 92s Get:73 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libicu-dev amd64 74.2-1ubuntu3.1 [11.9 MB] 92s Get:74 http://ftpmaster.internal/ubuntu noble/main amd64 libncurses-dev amd64 6.4+20240113-1ubuntu2 [384 kB] 92s Get:75 http://ftpmaster.internal/ubuntu noble/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 92s Get:76 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3.6 [781 kB] 92s Get:77 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 92s Get:78 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-runtime amd64 1:17.0.6-9ubuntu1 [529 kB] 92s Get:79 http://ftpmaster.internal/ubuntu noble/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 92s Get:80 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17 amd64 1:17.0.6-9ubuntu1 [23.8 MB] 93s Get:81 http://ftpmaster.internal/ubuntu noble/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 93s Get:82 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-tools amd64 1:17.0.6-9ubuntu1 [518 kB] 93s Get:83 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 93s Get:84 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 93s Get:85 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-dev amd64 1:17.0.6-9ubuntu1 [43.4 MB] 95s Get:86 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 locales-all amd64 2.39-0ubuntu8.6 [10.9 MB] 95s Get:87 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-16 amd64 16.10-0ubuntu0.24.04.1 [1297 kB] 95s Get:88 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-16 amd64 16.10-0ubuntu0.24.04.1 [15.5 MB] 96s Get:89 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-doc-16 all 16.10-0ubuntu0.24.04.1 [2138 kB] 96s Get:90 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plperl-16 amd64 16.10-0ubuntu0.24.04.1 [70.7 kB] 96s Get:91 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plpython3-16 amd64 16.10-0ubuntu0.24.04.1 [78.9 kB] 96s Get:92 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-pltcl-16 amd64 16.10-0ubuntu0.24.04.1 [33.7 kB] 96s Get:93 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 postgresql-server-dev-16 amd64 16.10-0ubuntu0.24.04.1 [1229 kB] 96s Preconfiguring packages ... 97s Fetched 238 MB in 7s (33.5 MB/s) 97s Selecting previously unselected package libjson-perl. 97s (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 ... 74807 files and directories currently installed.) 97s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 97s Unpacking libjson-perl (4.10000-1) ... 97s Selecting previously unselected package postgresql-client-common. 97s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 97s Unpacking postgresql-client-common (257build1.1) ... 97s Selecting previously unselected package ssl-cert. 97s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 97s Unpacking ssl-cert (1.1.2ubuntu1) ... 97s Selecting previously unselected package postgresql-common. 97s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 97s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 97s Unpacking postgresql-common (257build1.1) ... 97s Selecting previously unselected package m4. 97s Preparing to unpack .../04-m4_1.4.19-4build1_amd64.deb ... 97s Unpacking m4 (1.4.19-4build1) ... 97s Selecting previously unselected package autoconf. 97s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 97s Unpacking autoconf (2.71-3) ... 97s Selecting previously unselected package autotools-dev. 97s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 97s Unpacking autotools-dev (20220109.1) ... 97s Selecting previously unselected package automake. 97s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 97s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 97s Selecting previously unselected package autopoint. 97s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 97s Unpacking autopoint (0.21-14ubuntu2) ... 97s Selecting previously unselected package gcc-13-base:amd64. 97s Preparing to unpack .../09-gcc-13-base_13.3.0-6ubuntu2~24.04_amd64.deb ... 97s Unpacking gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 97s Selecting previously unselected package libisl23:amd64. 97s Preparing to unpack .../10-libisl23_0.26-3build1.1_amd64.deb ... 97s Unpacking libisl23:amd64 (0.26-3build1.1) ... 97s Selecting previously unselected package libmpc3:amd64. 97s Preparing to unpack .../11-libmpc3_1.3.1-1build1.1_amd64.deb ... 97s Unpacking libmpc3:amd64 (1.3.1-1build1.1) ... 97s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 97s Preparing to unpack .../12-cpp-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 97s Unpacking cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 97s Selecting previously unselected package cpp-13. 97s Preparing to unpack .../13-cpp-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 97s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 97s Selecting previously unselected package cpp-x86-64-linux-gnu. 97s Preparing to unpack .../14-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 97s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 97s Selecting previously unselected package cpp. 97s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 97s Unpacking cpp (4:13.2.0-7ubuntu1) ... 97s Selecting previously unselected package libcc1-0:amd64. 97s Preparing to unpack .../16-libcc1-0_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libgomp1:amd64. 97s Preparing to unpack .../17-libgomp1_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libitm1:amd64. 97s Preparing to unpack .../18-libitm1_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libatomic1:amd64. 97s Preparing to unpack .../19-libatomic1_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libasan8:amd64. 97s Preparing to unpack .../20-libasan8_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package liblsan0:amd64. 97s Preparing to unpack .../21-liblsan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libtsan2:amd64. 97s Preparing to unpack .../22-libtsan2_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libubsan1:amd64. 97s Preparing to unpack .../23-libubsan1_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libhwasan0:amd64. 97s Preparing to unpack .../24-libhwasan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libquadmath0:amd64. 97s Preparing to unpack .../25-libquadmath0_14.2.0-4ubuntu2~24.04_amd64.deb ... 97s Unpacking libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 97s Selecting previously unselected package libgcc-13-dev:amd64. 97s Preparing to unpack .../26-libgcc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 97s Unpacking libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 97s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 97s Preparing to unpack .../27-gcc-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 97s Unpacking gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 98s Selecting previously unselected package gcc-13. 98s Preparing to unpack .../28-gcc-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 98s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 98s Selecting previously unselected package gcc-x86-64-linux-gnu. 98s Preparing to unpack .../29-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 98s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 98s Selecting previously unselected package gcc. 98s Preparing to unpack .../30-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 98s Unpacking gcc (4:13.2.0-7ubuntu1) ... 98s Selecting previously unselected package libstdc++-13-dev:amd64. 98s Preparing to unpack .../31-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 98s Unpacking libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 98s Selecting previously unselected package g++-13-x86-64-linux-gnu. 98s Preparing to unpack .../32-g++-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 98s Unpacking g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 98s Selecting previously unselected package g++-13. 98s Preparing to unpack .../33-g++-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 98s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 98s Selecting previously unselected package g++-x86-64-linux-gnu. 98s Preparing to unpack .../34-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 98s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 98s Selecting previously unselected package g++. 98s Preparing to unpack .../35-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 98s Unpacking g++ (4:13.2.0-7ubuntu1) ... 98s Selecting previously unselected package build-essential. 98s Preparing to unpack .../36-build-essential_12.10ubuntu1_amd64.deb ... 98s Unpacking build-essential (12.10ubuntu1) ... 98s Selecting previously unselected package libllvm17t64:amd64. 98s Preparing to unpack .../37-libllvm17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 98s Unpacking libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package libclang-cpp17t64. 99s Preparing to unpack .../38-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 99s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package libgc1:amd64. 99s Preparing to unpack .../39-libgc1_1%3a8.2.6-1build1_amd64.deb ... 99s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 99s Selecting previously unselected package libobjc4:amd64. 99s Preparing to unpack .../40-libobjc4_14.2.0-4ubuntu2~24.04_amd64.deb ... 99s Unpacking libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 99s Selecting previously unselected package libobjc-13-dev:amd64. 99s Preparing to unpack .../41-libobjc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 99s Unpacking libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 99s Selecting previously unselected package libclang-common-17-dev:amd64. 99s Preparing to unpack .../42-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 99s Unpacking libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package llvm-17-linker-tools. 99s Preparing to unpack .../43-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 99s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package libclang1-17t64. 99s Preparing to unpack .../44-libclang1-17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 99s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package clang-17. 99s Preparing to unpack .../45-clang-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 99s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 99s Selecting previously unselected package libdebhelper-perl. 99s Preparing to unpack .../46-libdebhelper-perl_13.14.1ubuntu5_all.deb ... 99s Unpacking libdebhelper-perl (13.14.1ubuntu5) ... 99s Selecting previously unselected package libtool. 99s Preparing to unpack .../47-libtool_2.4.7-7build1_all.deb ... 99s Unpacking libtool (2.4.7-7build1) ... 99s Selecting previously unselected package dh-autoreconf. 99s Preparing to unpack .../48-dh-autoreconf_20_all.deb ... 99s Unpacking dh-autoreconf (20) ... 99s Selecting previously unselected package libarchive-zip-perl. 99s Preparing to unpack .../49-libarchive-zip-perl_1.68-1_all.deb ... 99s Unpacking libarchive-zip-perl (1.68-1) ... 99s Selecting previously unselected package libsub-override-perl. 99s Preparing to unpack .../50-libsub-override-perl_0.10-1_all.deb ... 99s Unpacking libsub-override-perl (0.10-1) ... 99s Selecting previously unselected package libfile-stripnondeterminism-perl. 99s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 99s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 99s Selecting previously unselected package dh-strip-nondeterminism. 99s Preparing to unpack .../52-dh-strip-nondeterminism_1.13.1-1_all.deb ... 99s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 99s Selecting previously unselected package debugedit. 99s Preparing to unpack .../53-debugedit_1%3a5.0-5build2_amd64.deb ... 99s Unpacking debugedit (1:5.0-5build2) ... 99s Selecting previously unselected package dwz. 99s Preparing to unpack .../54-dwz_0.15-1build6_amd64.deb ... 99s Unpacking dwz (0.15-1build6) ... 99s Selecting previously unselected package gettext. 99s Preparing to unpack .../55-gettext_0.21-14ubuntu2_amd64.deb ... 99s Unpacking gettext (0.21-14ubuntu2) ... 99s Selecting previously unselected package intltool-debian. 99s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 99s Unpacking intltool-debian (0.35.0+20060710.6) ... 99s Selecting previously unselected package po-debconf. 99s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 99s Unpacking po-debconf (1.0.21+nmu1) ... 99s Selecting previously unselected package debhelper. 99s Preparing to unpack .../58-debhelper_13.14.1ubuntu5_all.deb ... 99s Unpacking debhelper (13.14.1ubuntu5) ... 99s Selecting previously unselected package emacsen-common. 99s Preparing to unpack .../59-emacsen-common_3.0.5_all.deb ... 99s Unpacking emacsen-common (3.0.5) ... 99s Selecting previously unselected package dictionaries-common. 99s Preparing to unpack .../60-dictionaries-common_1.29.7_all.deb ... 100s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 100s Unpacking dictionaries-common (1.29.7) ... 100s Selecting previously unselected package libfakeroot:amd64. 100s Preparing to unpack .../61-libfakeroot_1.33-1_amd64.deb ... 100s Unpacking libfakeroot:amd64 (1.33-1) ... 100s Selecting previously unselected package fakeroot. 100s Preparing to unpack .../62-fakeroot_1.33-1_amd64.deb ... 100s Unpacking fakeroot (1.33-1) ... 100s Selecting previously unselected package hunspell-en-us. 100s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 100s Unpacking hunspell-en-us (1:2020.12.07-2) ... 100s Selecting previously unselected package icu-devtools. 100s Preparing to unpack .../64-icu-devtools_74.2-1ubuntu3.1_amd64.deb ... 100s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 100s Selecting previously unselected package libpgtypes3:amd64. 100s Preparing to unpack .../65-libpgtypes3_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libpgtypes3:amd64 (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libpq5:amd64. 100s Preparing to unpack .../66-libpq5_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libpq5:amd64 (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libecpg6:amd64. 100s Preparing to unpack .../67-libecpg6_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libecpg6:amd64 (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libecpg-compat3:amd64. 100s Preparing to unpack .../68-libecpg-compat3_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libecpg-compat3:amd64 (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libssl-dev:amd64. 100s Preparing to unpack .../69-libssl-dev_3.0.13-0ubuntu3.6_amd64.deb ... 100s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu3.6) ... 100s Selecting previously unselected package libpq-dev. 100s Preparing to unpack .../70-libpq-dev_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libpq-dev (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libecpg-dev. 100s Preparing to unpack .../71-libecpg-dev_16.10-0ubuntu0.24.04.1_amd64.deb ... 100s Unpacking libecpg-dev (16.10-0ubuntu0.24.04.1) ... 100s Selecting previously unselected package libicu-dev:amd64. 100s Preparing to unpack .../72-libicu-dev_74.2-1ubuntu3.1_amd64.deb ... 100s Unpacking libicu-dev:amd64 (74.2-1ubuntu3.1) ... 100s Selecting previously unselected package libncurses-dev:amd64. 100s Preparing to unpack .../73-libncurses-dev_6.4+20240113-1ubuntu2_amd64.deb ... 100s Unpacking libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 100s Selecting previously unselected package libtcl8.6:amd64. 100s Preparing to unpack .../74-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 100s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 100s Selecting previously unselected package libxml2-dev:amd64. 100s Preparing to unpack .../75-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.6_amd64.deb ... 100s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.6) ... 100s Selecting previously unselected package libxslt1.1:amd64. 100s Preparing to unpack .../76-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_amd64.deb ... 100s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 100s Selecting previously unselected package llvm-17-runtime. 100s Preparing to unpack .../77-llvm-17-runtime_1%3a17.0.6-9ubuntu1_amd64.deb ... 100s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 100s Selecting previously unselected package libpfm4:amd64. 100s Preparing to unpack .../78-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 100s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 100s Selecting previously unselected package llvm-17. 100s Preparing to unpack .../79-llvm-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 100s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 101s Selecting previously unselected package libffi-dev:amd64. 101s Preparing to unpack .../80-libffi-dev_3.4.6-1build1_amd64.deb ... 101s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 101s Selecting previously unselected package llvm-17-tools. 101s Preparing to unpack .../81-llvm-17-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 101s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 101s Selecting previously unselected package libz3-4:amd64. 101s Preparing to unpack .../82-libz3-4_4.8.12-3.1build1_amd64.deb ... 101s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 101s Selecting previously unselected package libz3-dev:amd64. 101s Preparing to unpack .../83-libz3-dev_4.8.12-3.1build1_amd64.deb ... 101s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 101s Selecting previously unselected package llvm-17-dev. 101s Preparing to unpack .../84-llvm-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 101s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 102s Selecting previously unselected package locales-all. 102s Preparing to unpack .../85-locales-all_2.39-0ubuntu8.6_amd64.deb ... 102s Unpacking locales-all (2.39-0ubuntu8.6) ... 103s Selecting previously unselected package postgresql-client-16. 103s Preparing to unpack .../86-postgresql-client-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 103s Unpacking postgresql-client-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-16. 104s Preparing to unpack .../87-postgresql-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 104s Unpacking postgresql-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-doc-16. 104s Preparing to unpack .../88-postgresql-doc-16_16.10-0ubuntu0.24.04.1_all.deb ... 104s Unpacking postgresql-doc-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-plperl-16. 104s Preparing to unpack .../89-postgresql-plperl-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 104s Unpacking postgresql-plperl-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-plpython3-16. 104s Preparing to unpack .../90-postgresql-plpython3-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 104s Unpacking postgresql-plpython3-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-pltcl-16. 104s Preparing to unpack .../91-postgresql-pltcl-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 104s Unpacking postgresql-pltcl-16 (16.10-0ubuntu0.24.04.1) ... 104s Selecting previously unselected package postgresql-server-dev-16. 104s Preparing to unpack .../92-postgresql-server-dev-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 104s Unpacking postgresql-server-dev-16 (16.10-0ubuntu0.24.04.1) ... 104s Setting up postgresql-client-common (257build1.1) ... 104s Setting up libpgtypes3:amd64 (16.10-0ubuntu0.24.04.1) ... 104s Setting up libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 104s Setting up postgresql-doc-16 (16.10-0ubuntu0.24.04.1) ... 104s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 104s Setting up libarchive-zip-perl (1.68-1) ... 104s Setting up libdebhelper-perl (13.14.1ubuntu5) ... 104s Setting up libpq5:amd64 (16.10-0ubuntu0.24.04.1) ... 104s Setting up m4 (1.4.19-4build1) ... 104s Setting up libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 104s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 104s Setting up locales-all (2.39-0ubuntu8.6) ... 104s Setting up libfakeroot:amd64 (1.33-1) ... 104s Setting up fakeroot (1.33-1) ... 104s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 104s Setting up autotools-dev (20220109.1) ... 104s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 104s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 104s Setting up gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 104s Setting up libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 104s Setting up emacsen-common (3.0.5) ... 104s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 104s Setting up ssl-cert (1.1.2ubuntu1) ... 105s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 105s Setting up libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libssl-dev:amd64 (3.0.13-0ubuntu3.6) ... 105s Setting up libmpc3:amd64 (1.3.1-1build1.1) ... 105s Setting up libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 105s Setting up autopoint (0.21-14ubuntu2) ... 105s Setting up icu-devtools (74.2-1ubuntu3.1) ... 105s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 105s Setting up autoconf (2.71-3) ... 105s Setting up libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 105s Setting up dwz (0.15-1build6) ... 105s Setting up libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 105s Setting up libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libjson-perl (4.10000-1) ... 105s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 105s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 105s Setting up debugedit (1:5.0-5build2) ... 105s Setting up libecpg6:amd64 (16.10-0ubuntu0.24.04.1) ... 105s Setting up libsub-override-perl (0.10-1) ... 105s Setting up libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libisl23:amd64 (0.26-3build1.1) ... 105s Setting up libicu-dev:amd64 (74.2-1ubuntu3.1) ... 105s Setting up libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 105s Setting up automake (1:1.16.5-1.3ubuntu1) ... 105s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 105s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 105s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 105s Setting up gettext (0.21-14ubuntu2) ... 105s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 105s Setting up libecpg-compat3:amd64 (16.10-0ubuntu0.24.04.1) ... 105s Setting up dictionaries-common (1.29.7) ... 105s Setting up cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 105s Setting up postgresql-client-16 (16.10-0ubuntu0.24.04.1) ... 106s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 106s Setting up libpq-dev (16.10-0ubuntu0.24.04.1) ... 106s Setting up libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 106s Setting up libecpg-dev (16.10-0ubuntu0.24.04.1) ... 106s Setting up intltool-debian (0.35.0+20060710.6) ... 106s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 106s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.6) ... 106s Setting up postgresql-common (257build1.1) ... 106s 106s Creating config file /etc/postgresql-common/createcluster.conf with new version 106s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 106s en_us 106s Removing obsolete dictionary files: 106s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 107s Setting up dh-strip-nondeterminism (1.13.1-1) ... 107s Setting up libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 107s Setting up hunspell-en-us (1:2020.12.07-2) ... 107s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 107s Setting up libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 107s Setting up libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 107s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 107s Setting up postgresql-16 (16.10-0ubuntu0.24.04.1) ... 107s Creating new PostgreSQL cluster 16/main ... 107s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 107s The files belonging to this database system will be owned by user "postgres". 107s This user must also own the server process. 107s 107s The database cluster will be initialized with locale "C.UTF-8". 107s The default database encoding has accordingly been set to "UTF8". 107s The default text search configuration will be set to "english". 107s 107s Data page checksums are disabled. 107s 107s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 107s creating subdirectories ... ok 107s selecting dynamic shared memory implementation ... posix 107s selecting default max_connections ... 100 107s selecting default shared_buffers ... 128MB 107s selecting default time zone ... Etc/UTC 107s creating configuration files ... ok 107s running bootstrap script ... ok 107s performing post-bootstrap initialization ... ok 107s syncing data to disk ... ok 110s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 110s Setting up gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 110s Setting up po-debconf (1.0.21+nmu1) ... 110s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 110s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 110s Setting up postgresql-plpython3-16 (16.10-0ubuntu0.24.04.1) ... 110s Setting up cpp (4:13.2.0-7ubuntu1) ... 110s Setting up postgresql-plperl-16 (16.10-0ubuntu0.24.04.1) ... 110s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 110s Setting up postgresql-pltcl-16 (16.10-0ubuntu0.24.04.1) ... 110s Setting up g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 110s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 110s Setting up libtool (2.4.7-7build1) ... 110s Setting up gcc (4:13.2.0-7ubuntu1) ... 110s Setting up dh-autoreconf (20) ... 110s Setting up postgresql-server-dev-16 (16.10-0ubuntu0.24.04.1) ... 110s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 110s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 110s Setting up debhelper (13.14.1ubuntu5) ... 110s Setting up g++ (4:13.2.0-7ubuntu1) ... 110s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 110s Setting up build-essential (12.10ubuntu1) ... 110s Processing triggers for libc-bin (2.39-0ubuntu8.6) ... 110s Processing triggers for systemd (255.4-1ubuntu8.11) ... 110s Processing triggers for man-db (2.12.0-4build2) ... 111s Processing triggers for install-info (7.1-3build2) ... 112s Processing triggers for dictionaries-common (1.29.7) ... 114s autopkgtest [20:32:02]: test run-testsuite: [----------------------- 115s ====== Running all tests with umask 077 ======= 115s ### PostgreSQL test 001_packages.t ### 115s 1..22 115s ok 1 - /etc/os-release exists 115s ok 2 - OS is ubuntu 115s ok 3 - OS version is 24.04 115s # PostgreSQL versions installed: 16 115s ok 4 - postgresql-16 installed 115s ok 5 # skip No python2 support 115s ok 6 - postgresql-plpython3-16 installed 115s ok 7 - postgresql-plperl-16 installed 115s ok 8 - postgresql-pltcl-16 installed 115s ok 9 - postgresql-server-dev-16 installed 115s ok 10 # skip No postgresql-contrib-16 package for version 16 115s # postgresql-doc-16 installed 115s ok 11 - At least one doc package installed 115s ok 12 - libecpg-dev installed 115s ok 13 - procps installed 115s ok 14 - netcat-openbsd installed 115s ok 15 - hunspell-en-us installed 115s ok 16 - system has a default UTF-8 locale 115s ok 17 - locale ru_RU exists 115s ok 18 - locale ru_RU.UTF-8 exists 115s ok 19 - user postgres in the UNIX group ssl-cert 115s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 115s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 115s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 115s ### End test 001_packages.t ### 115s 115s ### PostgreSQL test 002_existing_clusters.t ### 115s 1..8 115s # Cleanup 115s ok 1 - Cleanup: No clusters left behind 115s ok 2 - No postgres processes left behind 115s ok 3 - No files in /etc/postgresql left behind 115s ok 4 - No files in /var/lib/postgresql left behind 115s ok 5 - No files in /var/run/postgresql left behind 115s ok 6 - No files in /var/log/postgresql left behind 115s ok 7 - PostgreSQL TCP ports are closed 115s ok 8 - Next free port is 5432 115s ### End test 002_existing_clusters.t ### 115s 115s ### PostgreSQL test 003_alternatives.t ### 115s 1..9 115s # Newest PG version installed is 16 115s ok 1 - psql.1.gz link group 115s ok 2 - postmaster.1.gz link group does not exist 115s ok 3 - psql.1.gz alternative 115s ok 4 - pg_dump.1.gz alternative 115s ok 5 - postgres.1.gz alternative 115s ok 6 - pg_ctl.1.gz alternative 115s # Newest PG doc version installed is 16 115s ok 7 - SPI_connect.3.gz link group 115s ok 8 - SPI_connect.3.gz alternative 115s ok 9 - SPI_exec.3.gz alternative 115s ### End test 003_alternatives.t ### 115s 115s ### PostgreSQL test 005_PgCommon.t ### 115s 1..24 115s ok 1 - correctly parsed line 'local all postgres ident sameuser' 115s ok 2 - correctly parsed line 'local foo nobody trust' 115s ok 3 - correctly parsed line 'local foo nobody crypt' 115s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 115s ok 5 - correctly parsed line 'local foo,bar nobody ident' 115s ok 6 - correctly parsed line 'local all +foogrp password' 115s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 115s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 115s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 115s ok 10 - @expected_records has correct number of entries 115s ok 11 - returned read_pg_hba array has correct number of records 115s ok 12 - line 'foo all all md5' parsed as invalid 115s ok 13 - line 'local all all foo' parsed as invalid 115s ok 14 - line 'host all all foo' parsed as invalid 115s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 115s ok 16 - line 'host all all md5' parsed as invalid 115s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 115s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 115s ok 19 - read_conf_file returns empty dict for nonexisting file 115s ok 20 - read_conf_file() parsing 115s ok 21 - read_conf_file() parsing with include directives 115s ok 22 - set_conf_value 115s ok 23 - disable_conf_value 115s ok 24 - replace_conf_value 115s ### End test 005_PgCommon.t ### 115s 115s ### PostgreSQL test 006_next_free_port.t ### 115s 1..5 115s ok 1 - next_free_port is 5432 116s ok 2 - next_free_port detects localhost ipv4 socket 117s ok 3 - next_free_port detects wildcard ipv4 socket 118s ok 4 - next_free_port detects localhost ipv6 socket 119s ok 5 - next_free_port detects wildcard ipv6 socket 119s ### End test 006_next_free_port.t ### 119s 119s ### PostgreSQL test 007_pg_conftool.t ### 119s 1..41 119s # test without cluster 119s ok 1 - pg_conftool show all 119s ok 2 - correct output of pg_conftool show all 119s ok 3 - pg_conftool foo.conf show all 119s ok 4 - correct output of pg_conftool foo.conf show all 119s ok 5 - pg_conftool /tmp/oGxXQ5IrHa/different.conf show all 119s ok 6 - correct output of pg_conftool /tmp/oGxXQ5IrHa/different.conf show all 119s ok 7 - pg_conftool 9.7 main show all 119s ok 8 - correct output of pg_conftool 9.7 main show all 119s # test show 119s ok 9 - pg_conftool show all 119s ok 10 - correct output of pg_conftool show all 119s ok 11 - pg_conftool other.conf show all 119s ok 12 - correct output of pg_conftool other.conf show all 119s ok 13 - pg_conftool /tmp/oGxXQ5IrHa/different.conf show all 119s ok 14 - correct output of pg_conftool /tmp/oGxXQ5IrHa/different.conf show all 119s ok 15 - pg_conftool 16 main show all 119s ok 16 - correct output of pg_conftool 16 main show all 119s ok 17 - pg_conftool 16 main other.conf show all 119s ok 18 - correct output of pg_conftool 16 main other.conf show all 119s ok 19 - pg_conftool show a 119s ok 20 - correct output of pg_conftool show a 120s ok 21 - pg_conftool -s show a 120s ok 22 - correct output of pg_conftool -s show a 120s # test set 120s ok 23 - pg_conftool set c 7 120s ok 24 - correct output of pg_conftool set c 7 120s ok 25 - file contains new setting 120s ok 26 - pg_conftool set a 8 120s ok 27 - correct output of pg_conftool set a 8 120s ok 28 - file contains updated setting 120s ok 29 - pg_conftool /tmp/oGxXQ5IrHa/different.conf set a 9 120s ok 30 - correct output of pg_conftool /tmp/oGxXQ5IrHa/different.conf set a 9 120s ok 31 - file with path contains updated setting 120s # test remove 120s ok 32 - pg_conftool remove a 120s ok 33 - correct output of pg_conftool remove a 120s ok 34 - setting removed from file 120s ok 35 - pg_conftool /tmp/oGxXQ5IrHa/different.conf remove a 120s ok 36 - correct output of pg_conftool /tmp/oGxXQ5IrHa/different.conf remove a 120s ok 37 - setting removed from file with path 120s # test edit 120s ok 38 - pg_conftool edit 120s ok 39 - correct output of pg_conftool edit 120s ok 40 - pg_conftool /tmp/oGxXQ5IrHa/different.conf edit 120s ok 41 - correct output of pg_conftool /tmp/oGxXQ5IrHa/different.conf edit 120s ### End test 007_pg_conftool.t ### 120s 120s ### PostgreSQL test 010_defaultport_cluster.t ### 120s 1..14 120s ok 1 - psql --version 120s ok 2 - pg_wrapper selects highest available version number 120s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 120s ok 4 - connecting to localhost fails with no clusters 120s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 120s ok 6 - pg_wrapper uses host and port from PGCLUSTER 120s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 120s ok 8 - pg_wrapper uses --cluster from the command line 120s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 120s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 120s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 120s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 120s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 120s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 120s ### End test 010_defaultport_cluster.t ### 120s 120s ### PostgreSQL test 015_start_stop.t ### 120s 1..71 120s # We are running systemd 120s # Running tests for 16 120s # Cluster does not exist yet 120s ok 1 - cluster 16 main does not exist 120s ok 2 - service postgresql@16-main does not exist 120s ok 3 - systemctl start postgresql 120s ok 4 - cluster 16 main does not exist 120s ok 5 - service postgresql@16-main does not exist 120s ok 6 - systemctl start postgresql@16-main 120s ok 7 - cluster 16 main does not exist 120s ok 8 - service postgresql@16-main does not exist 120s # Start/stop postgresql using system tools 121s ok 9 - pg_createcluster 16 main 121s ok 10 - cluster 16 main is stopped 121s ok 11 - service postgresql@16-main is stopped 123s ok 12 - systemctl start postgresql 123s ok 13 - cluster 16 main is running 123s ok 14 - service postgresql@16-main is running 123s ok 15 - systemctl start postgresql 123s ok 16 - cluster 16 main is already running 123s ok 17 - service postgresql@16-main is already running 123s ok 18 - systemctl stop postgresql 129s ok 19 - cluster 16 main is stopped 129s ok 20 - service postgresql@16-main is stopped 129s ok 21 - systemctl stop postgresql 129s ok 22 - cluster 16 main is already stopped 129s ok 23 - service postgresql@16-main is already stopped 129s # Start/stop specific cluster using system tools 131s ok 24 - systemctl start postgresql@16-main 131s ok 25 - cluster 16 main is running 131s ok 26 - service postgresql@16-main is running 131s ok 27 - systemctl start postgresql@16-main 132s ok 28 - cluster 16 main is running 132s ok 29 - service postgresql@16-main is running 134s ok 30 - systemctl restart postgresql@16-main 134s ok 31 - cluster 16 main is running 134s ok 32 - service postgresql@16-main is running 134s ok 33 - systemctl stop postgresql@16-main 134s ok 34 - cluster 16 main is stopped 134s ok 35 - service postgresql@16-main is stopped 134s ok 36 - systemctl stop postgresql@16-main 134s ok 37 - cluster 16 main is already stopped 134s ok 38 - service postgresql@16-main is already stopped 135s ok 39 - pg_dropcluster 16 main 135s ok 40 - cluster 16 main does not exist 135s ok 41 - service postgresql@16-main does not exist 135s # Start/stop specific cluster using pg_*cluster 135s ok 42 - pg_ctlcluster start 16 main 135s ok 43 - cluster 16 main does not exist 135s ok 44 - service postgresql@16-main does not exist 138s ok 45 - pg_createcluster 16 main --start 138s ok 46 - cluster 16 main is running 138s ok 47 - service postgresql@16-main is running 138s ok 48 - pg_ctlcluster 16 main start 138s ok 49 - cluster 16 main is already running 138s ok 50 - service postgresql@16-main is already running 141s ok 51 - pg_ctlcluster 16-main restart 141s ok 52 - cluster 16 main is running 141s ok 53 - service postgresql@16-main is running 141s ok 54 - pg_ctlcluster 16 main stop 141s ok 55 - cluster 16 main is stopped 141s ok 56 - service postgresql@16-main is stopped 141s ok 57 - pg_ctlcluster 16 main stop 141s ok 58 - cluster 16 main is already stopped 141s ok 59 - service postgresql@16-main is already stopped 143s ok 60 - pg_ctlcluster start 16-main 143s ok 61 - cluster 16 main is running 143s ok 62 - service postgresql@16-main is running 144s ok 63 - pg_dropcluster 16 main --stop 144s # Cleanup 145s ok 64 - Cleanup: No clusters left behind 145s ok 65 - No postgres processes left behind 145s ok 66 - No files in /etc/postgresql left behind 145s ok 67 - No files in /var/lib/postgresql left behind 145s ok 68 - No files in /var/run/postgresql left behind 145s ok 69 - No files in /var/log/postgresql left behind 145s ok 70 - PostgreSQL TCP ports are closed 145s ok 71 - Next free port is 5432 145s ### End test 015_start_stop.t ### 145s 145s ### PostgreSQL test 020_create_sql_remove.t ### 145s 1..147 145s # Running tests for 16 147s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.l9xWdY 147s ok 2 - pg_createcluster 16 main 147s ok 3 - Socket and pid file are in /var/run/postgresql/ 147s ok 4 - xlog/wal directory /tmp/16.xlog.l9xWdY was created 147s ok 5 - local method in pg_hba.conf is peer 147s ok 6 - host method in pg_hba.conf is scram-sha-256 147s ok 7 - Exactly one postgres master process running 150s ok 8 - pg_ctlcluster 16 main restart 150s ok 9 - cluster restarts with new environment file 150s ok 10 - Exactly one postgres master process running 150s ok 11 - correct value of PGEXTRAVAR1 in environment 150s ok 12 - correct value of PGEXTRAVAR2 in environment 150s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 150s ok 14 - createdb --version 150s ok 15 - pg_wrapper+createdb selects version number of cluster 150s ok 16 - psql --version 150s ok 17 - pg_wrapper+psql selects version 16 150s ok 18 - pg_lscluster reports online cluster on port 5432 150s ok 19 - log file is actually used 150s ok 20 - /etc/postgresql is owned by user "postgres" 150s ok 21 - version configuration directory file is owned by user "postgres" 150s ok 22 - configuration directory file is owned by user "postgres" 150s ok 23 - version data directory file is owned by user "postgres" 150s ok 24 - data directory file is owned by user "postgres" 150s ok 25 - log file has 0640 permissions 150s ok 26 - log file is owned by user "postgres" 150s ok 27 - log file is owned by group "adm" 150s ok 28 - no log symlink by default 150s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 150s ok 30 - pg_lsclusters -h 150s ok 31 - correct output of pg_lsclusters -h 150s ok 32 - stopping cluster 153s ok 33 - restarting cluster with nondefault log symlink 153s ok 34 - log target is used as log file 153s ok 35 - default log is not used 153s ok 36 - pg_lsclusters -h 153s ok 37 - correct output of pg_lsclusters -h 153s ok 38 - stopping cluster 156s ok 39 - restarting cluster with explicitly configured log file 156s ok 40 - default log is not used 156s ok 41 - log symlink target is used for startup message 156s ok 42 - exactly one log file 156s ok 43 - custom log is actually used 156s ok 44 - pg_lsclusters -h 156s ok 45 - correct output of pg_lsclusters -h 156s ok 46 - stopping cluster 156s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 156s ok 48 - /etc/postgres-hack was not created 158s ok 49 - restarting cluster 158s ok 50 - ps -o tty -U postgres h 158s ok 51 - postgres processes do not have an associated terminal 158s ok 52 - Server is linked with SSL support 158s ok 53 - SSL is enabled in postgresql.conf 158s ok 54 - psql -l fails for nobody 158s ok 55 - createuser nobody 158s ok 56 - createdb nobodydb 158s ok 57 - psql -ltA succeeds for nobody 158s ok 58 - psql -ltA output 158s ok 59 - SQL command: create table 158s ok 60 - SQL command: insert into table values 158s ok 61 - SQL command: insert into table values 158s ok 62 - primary key violation 158s ok 63 - psql -tAc "select * from phone order by name" nobodydb 158s ok 64 - SQL command output: select -tA 158s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 158s ok 66 - SQL command output: select -tx 158s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 158s ok 68 - SQL command output: select -tAx 158s ok 69 - CREATE EXTENSION plperlu fails for user nobody 158s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 158s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 159s ok 72 - creating PL/PerlU function as user nobody fails 159s ok 73 - creating unsafe PL/Perl function as user postgres fails 159s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 159s ok 75 - creating PL/PerlU function as user postgres succeeds 159s ok 76 - psql nobodydb -Atc "select read_file()" 159s ok 77 - calling PL/PerlU function 159s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 159s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 159s ok 80 - creating unsafe PL/Perl function as user nobody fails 159s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 159s ok 82 - creating PL/Perl function as user nobody succeeds 159s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 159s ok 84 - calling PL/Perl function 159s ok 85 # skip No python2 support 159s ok 86 # skip No python2 support 159s ok 87 # skip No python2 support 159s ok 88 # skip No python2 support 159s ok 89 # skip No python2 support 159s ok 90 # skip No python2 support 159s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 159s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 159s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 159s ok 94 - creating PL/Python3 function as user postgres succeeds 159s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 159s ok 96 - calling PL/Python function 159s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 159s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 159s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 159s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 159s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 159s ok 102 - creating PL/Tcl function as user nobody succeeds 159s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 159s ok 104 - creating PL/TclU function as user postgres succeeds 159s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 159s ok 106 - calling PL/Tcl function 159s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 159s ok 108 - calling PL/TclU function 159s ok 109 - stopping cluster 159s ok 110 - pg_ctlcluster 16 main start 159s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 161s ok 112 - pg_ctlcluster 16 main start 161s ok 113 - cluster restarts with pgdata symlink 162s ok 114 - postgres master has OOM killer protection 162s ok 115 - postgres client backend has no OOM adjustment 162s ok 116 - ps h 7267 162s ok 117 - process title is idle 163s ok 118 - ps h 7267 163s ok 119 - process title is idle in transaction 163s ok 120 - stopping cluster 165s ok 121 - starting cluster as postgres works without a log file 165s ok 122 - log file got recreated and used 165s ok 123 - creating a directory in spc2 165s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.jXCZ83'" 165s ok 125 - creating tablespace spc1 165s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 165s ok 127 - creating a table in spc1 165s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.iw_CbS'" 165s ok 129 - creating tablespace spc2 165s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 165s ok 131 - creating a table in spc2 165s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 165s ok 133 - Correct apt NeverAutoRemove config 166s ok 134 - pg_dropcluster removes cluster 166s ok 135 - xlog/wal directory /tmp/16.xlog.l9xWdY was deleted 166s ok 136 - tablespace spc1 was emptied 166s ok 137 - tablespace spc2 was emptied 166s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 166s ok 139 - Correct apt NeverAutoRemove config 166s # Cleanup 166s ok 140 - Cleanup: No clusters left behind 166s ok 141 - No postgres processes left behind 166s ok 142 - No files in /etc/postgresql left behind 166s ok 143 - No files in /var/lib/postgresql left behind 166s ok 144 - No files in /var/run/postgresql left behind 166s ok 145 - No files in /var/log/postgresql left behind 166s ok 146 - PostgreSQL TCP ports are closed 166s ok 147 - Next free port is 5432 166s ### End test 020_create_sql_remove.t ### 166s 166s ### PostgreSQL test 021_pg_renamecluster.t ### 166s 1..20 169s ok 1 - pg_createcluster 16 main 172s ok 2 - pg_renamecluster 16 main donau 172s ok 3 - psql -tAc "show data_directory" 172s ok 4 - cluster is running and data_directory was moved 172s ok 5 - pg_hba.conf location updated 172s ok 6 - pg_ident.conf location updated 172s ok 7 - external_pid_file location updated 172s ok 8 - external_pid_file exists 172s ok 9 # skip no stats_temp_directory in 16 172s ok 10 # skip no stats_temp_directory in 16 172s ok 11 - cluster_name is updated 173s ok 12 - pg_dropcluster removes cluster 173s # Cleanup 173s ok 13 - Cleanup: No clusters left behind 173s ok 14 - No postgres processes left behind 173s ok 15 - No files in /etc/postgresql left behind 173s ok 16 - No files in /var/lib/postgresql left behind 173s ok 17 - No files in /var/run/postgresql left behind 173s ok 18 - No files in /var/log/postgresql left behind 173s ok 19 - PostgreSQL TCP ports are closed 173s ok 20 - Next free port is 5432 173s ### End test 021_pg_renamecluster.t ### 173s 173s ### PostgreSQL test 022_recovery.t ### 173s 1..17 173s # Running tests for 16 176s ok 1 - pg_createcluster 16 main --start >/dev/null 176s ok 2 - pg_ctlcluster 16 main stop -m i 178s ok 3 - pg_ctlcluster 16 main start 178s ok 4 - psql -c '' 179s ok 5 - pg_ctlcluster 16 main stop -m i 179s ok 6 - create write-protected file in data directory 181s ok 7 - pg_ctlcluster 16 main start 181s ok 8 - psql -c '' 182s ok 9 - pg_dropcluster removes cluster 182s # Cleanup 182s ok 10 - Cleanup: No clusters left behind 182s ok 11 - No postgres processes left behind 182s ok 12 - No files in /etc/postgresql left behind 182s ok 13 - No files in /var/lib/postgresql left behind 182s ok 14 - No files in /var/run/postgresql left behind 182s ok 15 - No files in /var/log/postgresql left behind 182s ok 16 - PostgreSQL TCP ports are closed 182s ok 17 - Next free port is 5432 182s ### End test 022_recovery.t ### 182s 182s ### PostgreSQL test 025_logging.t ### 182s 1..55 183s # Logging to /var/log/syslog works 183s # Running tests for 16 186s ok 1 - pg_createcluster 16 main 186s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 186s ok 3 - psql -qc "'foobar_16_8436'" 186s ok 4 - log an error 186s ok 5 - grep --binary-files=text foobar_16_8436 /var/log/postgresql/postgresql-16-main.log 186s ok 6 - error appears in logfile 186s ok 7 - pg_conftool 16 main set log_destination syslog 186s ok 8 - set log_destination syslog 186s ok 9 - pg_ctlcluster 16 main reload 186s ok 10 - 16 main reload 186s ok 11 - psql -Atc "show log_destination" 186s ok 12 - log_destination is syslog 186s ok 13 - pg_lscluster reports syslog 187s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 187s ok 15 - error appears in /var/log/syslog 187s ok 16 - pg_conftool 16 main set logging_collector on 187s ok 17 - set logging_collector on 187s ok 18 - pg_conftool 16 main set log_destination csvlog 187s ok 19 - set log_destination csvlog 189s ok 20 - pg_ctlcluster 16 main restart 189s ok 21 - 16 main restart 189s ok 22 - psql -Atc "show logging_collector" 189s ok 23 - logging_collector is on 189s ok 24 - psql -Atc "show log_destination" 189s ok 25 - log_destination is csvlog 189s ok 26 - pg_lscluster reports csvlog 189s ok 27 - psql -qc "'barbaz_16_8436'" 189s ok 28 - log an error 190s ok 29 - grep --binary-files=text barbaz_16_8436 /var/lib/postgresql/16/main/log/*.csv 190s ok 30 - error appears in log/*.csv 190s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 190s ok 32 - set log_destination stderr,syslog,csvlog 190s ok 33 - pg_ctlcluster 16 main reload 190s ok 34 - 16 main reload 190s ok 35 - psql -Atc "show log_destination" 190s ok 36 - log_destination is stderr,syslog,csvlog 190s ok 37 - pg_lscluster reports stderr,syslog,csvlog 190s ok 38 - psql -qc "'moo_16_8436'" 190s ok 39 - log an error 190s ok 40 - grep --binary-files=text moo_16_8436 /var/lib/postgresql/16/main/log/*.log 190s ok 41 - error appears in log/*.log 191s ok 42 - grep --binary-files=text 'postgres.*moo_16_8436' /var/log/syslog 191s ok 43 - error appears in /var/log/syslog 191s ok 44 - grep --binary-files=text moo_16_8436 /var/lib/postgresql/16/main/log/*.csv 191s ok 45 - error appears in log/*.csv 192s ok 46 - pg_dropcluster 16 main --stop 192s ok 47 - pg_dropcluster removes cluster 192s # Cleanup 192s ok 48 - Cleanup: No clusters left behind 192s ok 49 - No postgres processes left behind 192s ok 50 - No files in /etc/postgresql left behind 192s ok 51 - No files in /var/lib/postgresql left behind 192s ok 52 - No files in /var/run/postgresql left behind 192s ok 53 - No files in /var/log/postgresql left behind 192s ok 54 - PostgreSQL TCP ports are closed 192s ok 55 - Next free port is 5432 192s ### End test 025_logging.t ### 192s 192s ### PostgreSQL test 030_errors.t ### 192s 1..156 192s ok 1 - pg_lscluster reports cluster without binaries 193s ok 2 - pg_dropcluster 6.3 main 194s ok 3 - pg_createcluster --socketdir 194s ok 4 - pg_lsclusters -h 194s ok 5 - cluster was created 194s ok 6 - Port of created cluster is 5432 194s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 194s ok 8 - pg_createcluster on existing cluster 194s ok 9 - pg_lsclusters -h 194s ok 10 - original cluster still exists 194s ok 11 - pg_createcluster 16 test -p foo 194s ok 12 - pg_createcluster -p checks that port option is numeric 194s ok 13 - pg_createcluster 16 test -p 42 194s ok 14 - pg_createcluster -p checks valid port range 194s ok 15 - pg_ctlcluster 16 main start 194s ok 16 - pg_ctlcluster refuses to start root-owned cluster 194s ok 17 - pg_ctlcluster 16 main start 194s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 194s ok 19 - pg_ctlcluster 16 main start 194s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 194s ok 21 - pg_ctlcluster 16 main start 194s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 196s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 196s ok 24 - No sockets in /var/run/postgresql 196s ok 25 - Socket is in /tmp/postgresql-testsuite/ 196s ok 26 - cluster stops with custom unix_socket_dir 196s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 199s ok 28 - cluster starts after removing unix_socket_dir 199s ok 29 - Socket is in default dir /var/run/postgresql 199s ok 30 - No sockets in /tmp/postgresql-testsuite/ 199s ok 31 - pg_ctlcluster 16 main stop 199s ok 32 - pg_ctlcluster fails with corrupted PID file 199s ok 33 - pg_lsclusters -h 199s ok 34 - cluster is still online 199s ok 35 - pg_ctlcluster succeeds with restored PID file 199s ok 36 - pg_lsclusters -h 199s ok 37 - cluster is down 199s ok 38 - pg_ctlcluster 16 main stop 199s ok 39 - pg_ctlcluster stop fails on stopped cluster 201s ok 40 - pg_ctlcluster 16 main start 201s ok 41 - pg_ctlcluster succeeds with already existing PID file 201s ok 42 - pg_lsclusters -h 201s ok 43 - cluster is online 201s ok 44 - pg_ctlcluster stop succeeds 201s ok 45 - pg_lsclusters -h 201s ok 46 - cluster is down 201s ok 47 - no pid file left 201s ok 48 - pg_ctlcluster 16 main stop 201s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 201s ok 50 - pid file was cleaned up 201s ok 51 - pg_ctlcluster --force 16 main stop 201s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 201s ok 53 - pid file was cleaned up 201s ok 54 - pg_ctlcluster 16 main stop 201s ok 55 - pg_ctlcluster stop succeeds with stale PID file 201s ok 56 - pid file was cleaned up 201s ok 57 - pg_ctlcluster --force 16 main stop 201s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 201s ok 59 - pid file was cleaned up 201s ok 60 - pg_ctlcluster --force 16 main stop 201s ok 61 - pg_ctlcluster stop succeeds with empty PID file 201s ok 62 - pid file was cleaned up 204s ok 63 - pg_ctlcluster 16 main start 204s ok 64 - pg_ctlcluster succeeds with corrupted PID file 204s ok 65 - pg_lsclusters -h 204s ok 66 - cluster is online 204s ok 67 - pg_ctlcluster 16 main start 204s ok 68 - pg_ctlcluster start fails on running cluster 204s ok 69 - pg_ctlcluster stop 204s ok 70 - pg_ctlcluster 16 main start 204s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 204s ok 72 - pg_ctlcluster 16 main stop 204s ok 73 - stopping cluster 210s ok 74 - pg_ctlcluster 16 main start 210s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 210s ok 76 - pg_ctlcluster 16 main stop 210s ok 77 - stopping cluster 210s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 210s ok 79 - pg_dropcluster 16 main 210s ok 80 - pg_dropcluster works as user postgres 211s ok 81 - pg_createcluster succeeds 211s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 211s ok 83 - proper error message for nonexisting /var/lib/postgresql 213s ok 84 - pg_ctlcluster 16 main start 213s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 213s ok 86 - pg_ctlcluster 16 main stop 213s ok 87 - stopping cluster 214s ok 88 - pg_createcluster other 216s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 218s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 219s ok 91 219s ok 92 - pg_ctlcluster 16 other start 219s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 219s ok 94 - pg_ctlcluster 16 main stop 219s ok 95 - stopping main cluster 221s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 222s ok 97 - pg_dropcluster other 223s ok 98 - pg_dropcluster 223s ok 99 - No sockets any more 223s ok 100 - 'pg_lsclusters 4.5 foo' fails 223s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 223s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 223s ok 103 - 'psql --cluster 4.5/foo' fails 223s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 223s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 223s ok 106 - 'psql --cluster 16/foo' fails 223s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 223s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 223s ok 109 - 'pg_dropcluster 4.5 foo' fails 223s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 223s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 223s ok 112 - 'pg_dropcluster 16 foo' fails 223s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 223s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 223s ok 115 - 'pg_upgradecluster 4.5 foo' fails 223s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 223s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 223s ok 118 - 'pg_upgradecluster 16 foo' fails 223s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 223s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 223s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 223s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 223s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 223s ok 124 - 'pg_ctlcluster 16 foo stop' fails 223s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 223s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 223s # Cleanup 223s ok 127 - Cleanup: No clusters left behind 223s ok 128 - No postgres processes left behind 223s ok 129 - No files in /etc/postgresql left behind 223s ok 130 - No files in /var/lib/postgresql left behind 223s ok 131 - No files in /var/run/postgresql left behind 223s ok 132 - No files in /var/log/postgresql left behind 223s ok 133 - PostgreSQL TCP ports are closed 223s ok 134 - Next free port is 5432 224s ok 135 - pg_dropcluster 16 broken 224s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 224s # Cleanup 224s ok 137 - Cleanup: No clusters left behind 224s ok 138 - No postgres processes left behind 224s ok 139 - No files in /etc/postgresql left behind 224s ok 140 - No files in /var/lib/postgresql left behind 224s ok 141 - No files in /var/run/postgresql left behind 224s ok 142 - No files in /var/log/postgresql left behind 224s ok 143 - PostgreSQL TCP ports are closed 224s ok 144 - Next free port is 5432 225s ok 145 - pg_dropcluster 16 broken 225s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 225s ok 147 - /etc/postgresql/16 was removed 225s ok 148 - /var/lib/postgresql/16 was removed 225s # Cleanup 225s ok 149 - Cleanup: No clusters left behind 225s ok 150 - No postgres processes left behind 225s ok 151 - No files in /etc/postgresql left behind 225s ok 152 - No files in /var/lib/postgresql left behind 225s ok 153 - No files in /var/run/postgresql left behind 225s ok 154 - No files in /var/log/postgresql left behind 225s ok 155 - PostgreSQL TCP ports are closed 225s ok 156 - Next free port is 5432 225s ### End test 030_errors.t ### 225s 225s ### PostgreSQL test 031_errors_disk_full.t ### 225s 1..22 225s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 226s ok 1 - script failed 226s ok 2 - pg_createcluster fails due to insufficient disk space 226s ok 3 - does not leave files behind 226s # Cleanup 226s ok 4 - Cleanup: No clusters left behind 226s ok 5 - No postgres processes left behind 226s ok 6 - No files in /etc/postgresql left behind 226s ok 7 - No files in /var/lib/postgresql left behind 226s ok 8 - No files in /var/run/postgresql left behind 226s ok 9 - No files in /var/log/postgresql left behind 226s ok 10 - PostgreSQL TCP ports are closed 226s ok 11 - Next free port is 5432 226s # check disk full conditions on startup 228s ok 12 - script failed 228s ok 13 - pg_ctlcluster prints error message 228s ok 14 - log file has error message 228s # Cleanup 228s ok 15 - Cleanup: No clusters left behind 228s ok 16 - No postgres processes left behind 228s ok 17 - No files in /etc/postgresql left behind 228s ok 18 - No files in /var/lib/postgresql left behind 228s ok 19 - No files in /var/run/postgresql left behind 228s ok 20 - No files in /var/log/postgresql left behind 228s ok 21 - PostgreSQL TCP ports are closed 228s ok 22 - Next free port is 5432 228s ### End test 031_errors_disk_full.t ### 228s 228s ### PostgreSQL test 032_ssl_key_permissions.t ### 228s 1..22 228s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 228s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 228s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 228s # 16 (16.10-0ubuntu0.24.04.1) 229s ok 4 - pg_createcluster 16 main 229s ok 5 - pg_ctlcluster 16 main start 229s ok 6 - ssl key owned by nobody refused 229s ok 7 - pg_ctlcluster 16 main start 229s ok 8 - ssl key with permissions root:root 0644 refused 230s ok 9 - pg_ctlcluster 16 main start 230s ok 10 - ssl key with permissions postgres:postgres 0640 refused 231s ok 11 - pg_dropcluster 16 main --stop 231s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 231s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 231s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 231s # Cleanup 231s ok 15 - Cleanup: No clusters left behind 231s ok 16 - No postgres processes left behind 231s ok 17 - No files in /etc/postgresql left behind 231s ok 18 - No files in /var/lib/postgresql left behind 231s ok 19 - No files in /var/run/postgresql left behind 231s ok 20 - No files in /var/log/postgresql left behind 231s ok 21 - PostgreSQL TCP ports are closed 231s ok 22 - Next free port is 5432 231s ### End test 032_ssl_key_permissions.t ### 231s 231s ### PostgreSQL test 040_upgrade.t ### 231s 1..1 231s ok 1 - only one major version installed, skipping upgrade tests 231s ### End test 040_upgrade.t ### 231s 231s ### PostgreSQL test 041_upgrade_custompaths.t ### 231s 1..1 231s ok 1 - only one major version installed, skipping upgrade tests 231s ### End test 041_upgrade_custompaths.t ### 231s 231s ### PostgreSQL test 042_upgrade_rename.t ### 231s 1..15 231s # PostgreSQL 16 234s ok 1 - pg_createcluster 16 main --start 239s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 239s ok 3 - pg_lsclusters -h 239s ok 4 - correct output of pg_lsclusters -h 240s ok 5 - pg_dropcluster 16 main --stop 241s ok 6 - pg_dropcluster 16 upgr --stop 241s ok 7 - Cleaning pg_upgrade log files 241s # Cleanup 241s ok 8 - Cleanup: No clusters left behind 241s ok 9 - No postgres processes left behind 241s ok 10 - No files in /etc/postgresql left behind 241s ok 11 - No files in /var/lib/postgresql left behind 241s ok 12 - No files in /var/run/postgresql left behind 241s ok 13 - No files in /var/log/postgresql left behind 241s ok 14 - PostgreSQL TCP ports are closed 241s ok 15 - Next free port is 5432 241s ### End test 042_upgrade_rename.t ### 241s 241s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 241s 1..1 241s ok 1 - only one major version installed, skipping upgrade tests 241s ### End test 043_upgrade_ssl_cert.t ### 241s 241s ### PostgreSQL test 045_backup.t ### 241s # We are running systemd 241s # PostgreSQL 16 241s # create cluster 244s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 244s ok 2 - pg_lsclusters -h 244s ok 3 - correct output of pg_lsclusters -h 244s ok 4 - pg_conftool 16 main set work_mem 11MB 244s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 245s ok 6 - psql -c 'alter database mydb set search_path=public' 245s ok 7 - psql -c 'create table foo (t text)' mydb 245s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 245s ok 9 - psql -c 'CREATE USER myuser' 245s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 245s ok 11 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 245s ok 12 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 245s # create directory 245s ok 13 - pg_backupcluster 16 main createdirectory 245s ok 14 - /var/backups/postgresql/16-main owned by uid postgres 245s ok 15 - /var/backups/postgresql/16-main owned by gid postgres 245s # dump 245s ok 16 - systemctl start pg_dump@16-main 245s ok 17 - dump created in /var/backups/postgresql/16-main/2025-12-02T203412Z.dump 245s ok 18 - /var/backups/postgresql/16-main/2025-12-02T203412Z.dump owned by uid postgres 245s ok 19 - /var/backups/postgresql/16-main/2025-12-02T203412Z.dump owned by gid postgres 245s # basebackup 245s ok 20 - systemctl start pg_receivewal@16-main 245s ok 21 - psql -c 'create table poke_receivewal (t text)' mydb 246s ok 22 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 436s ok 23 - systemctl start pg_basebackup@16-main 436s ok 24 - dump created in /var/backups/postgresql/16-main/2025-12-02T203413Z.backup 436s ok 25 - /var/backups/postgresql/16-main/2025-12-02T203413Z.backup owned by uid postgres 436s ok 26 - /var/backups/postgresql/16-main/2025-12-02T203413Z.backup owned by gid postgres 436s # list 436s ok 27 - pg_backupcluster 16 main list 436s ok 28 - correct output of pg_backupcluster 16 main list 436s # more database changes 436s ok 29 - psql -c "insert into foo values ('data later deleted')" mydb 436s ok 30 - psql -c "insert into foo values ('data from archive')" mydb 436s ok 31 - retrieve recovery timestamp 436s ok 32 - psql -c "delete from foo where t = 'data later deleted'" mydb 436s ok 33 - systemctl stop pg_receivewal@16-main 436s # restore /var/backups/postgresql/16-main/2025-12-02T203412Z.dump 437s ok 34 - pg_dropcluster 16 main --stop 441s ok 35 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-12-02T203412Z.dump --start --datadir /var/lib/postgresql/16/snowflake 441s ok 36 - pg_lsclusters -h 441s ok 37 - correct output of pg_lsclusters -h 441s ok 38 - psql -XAtl 441s ok 39 - mydb locales 441s ok 40 - myicudb locales 441s ok 41 - psql -XAtc 'show work_mem' 441s ok 42 - correct output of psql -XAtc 'show work_mem' 441s ok 43 - psql -XAtc 'select * from foo' mydb 441s ok 44 - correct output of psql -XAtc 'select * from foo' mydb 441s ok 45 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 441s ok 46 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 441s ok 47 - psql -XAtc '\drds' 441s ok 48 - correct output of psql -XAtc '\drds' 441s # restore /var/backups/postgresql/16-main/2025-12-02T203413Z.backup 442s ok 49 - pg_dropcluster 16 main --stop 445s ok 50 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-12-02T203413Z.backup --start --datadir /var/lib/postgresql/16/snowflake 445s ok 51 - pg_lsclusters -h 445s ok 52 - correct output of pg_lsclusters -h 445s ok 53 - psql -XAtl 445s ok 54 - mydb locales 445s ok 55 - myicudb locales 446s ok 56 - psql -XAtc 'show work_mem' 446s ok 57 - correct output of psql -XAtc 'show work_mem' 446s ok 58 - psql -XAtc 'select * from foo' mydb 446s ok 59 - correct output of psql -XAtc 'select * from foo' mydb 446s ok 60 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 446s ok 61 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 446s ok 62 - psql -XAtc '\drds' 446s ok 63 - correct output of psql -XAtc '\drds' 446s # restore /var/backups/postgresql/16-main/2025-12-02T203413Z.backup with WAL archive 447s ok 64 - pg_dropcluster 16 main --stop 450s ok 65 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-12-02T203413Z.backup --start --archive --port 5430 450s ok 66 - pg_lsclusters -h 450s ok 67 - correct output of pg_lsclusters -h 450s ok 68 - psql -XAtc 'select * from foo order by t' mydb 450s ok 69 - correct output of psql -XAtc 'select * from foo order by t' mydb 450s # restore /var/backups/postgresql/16-main/2025-12-02T203413Z.backup with PITR 451s ok 70 - pg_dropcluster 16 main --stop 454s ok 71 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-12-02T203413Z.backup --start --pitr '2025-12-02 20:37:23.375879+00 454s # ' 454s ok 72 - pg_lsclusters -h 454s ok 73 - correct output of pg_lsclusters -h 454s ok 74 - psql -XAtc 'select * from foo order by t' mydb 454s ok 75 - correct output of psql -XAtc 'select * from foo order by t' mydb 456s ok 76 - pg_dropcluster 16 main --stop 456s # Cleanup 456s ok 77 - Cleanup: No clusters left behind 456s ok 78 - No postgres processes left behind 456s ok 79 - No files in /etc/postgresql left behind 456s ok 80 - No files in /var/lib/postgresql left behind 456s ok 81 - No files in /var/run/postgresql left behind 456s ok 82 - No files in /var/log/postgresql left behind 456s ok 83 - PostgreSQL TCP ports are closed 456s ok 84 - Next free port is 5432 456s 1..84 456s ### End test 045_backup.t ### 456s 456s ### PostgreSQL test 050_encodings.t ### 456s 1..60 456s # Checking 16 ru_RU 459s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 460s ok 2 - psql -l succeeds 460s ok 3 - template1 is not UTF-8 encoded 460s ok 4 - creating test database 460s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 460s # create table t (x varchar); copy t from stdin" test 460s ok 6 - creating table with ISO-8859-5 characters 460s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 460s ok 8 - correct string in UTF-8 460s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 460s ok 10 - correct string in ISO-8859-5 460s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 460s # delete from t; copy t from stdin" test 460s ok 12 - creating table with UTF-8 characters 460s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 460s ok 14 - correct string in UTF-8 460s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 460s ok 16 - correct string in ISO-8859-1 460s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 460s ok 18 - Server error message has correct language and encoding 462s ok 19 - pg_ctlcluster 16 ru_RU restart 462s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 463s ok 21 - Dropping cluster 463s # Checking 16 ru_RU.UTF-8 466s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 467s ok 23 - psql -l succeeds 467s ok 24 - template1 is UTF-8 encoded 467s ok 25 - creating test database 467s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 467s # create table t (x varchar); copy t from stdin" test 467s ok 27 - creating table with ISO-8859-5 characters 467s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 467s ok 29 - correct string in UTF-8 467s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 467s ok 31 - correct string in ISO-8859-5 468s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 468s # delete from t; copy t from stdin" test 468s ok 33 - creating table with UTF-8 characters 468s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 468s ok 35 - correct string in UTF-8 468s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 468s ok 37 - correct string in ISO-8859-1 468s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 468s ok 39 - Server error message has correct language and encoding 470s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 470s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 470s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 470s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 470s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 470s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 470s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 470s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 471s ok 48 - Dropping cluster 471s # Check 16 locale environment variables 474s ok 49 - pg_createcluster: LC_ALL dominates LANG 474s ok 50 - psql -Atl --cluster 16/main 474s ok 51 - template1 is ASCII encoded 475s ok 52 - Dropping cluster 475s # Cleanup 475s ok 53 - Cleanup: No clusters left behind 475s ok 54 - No postgres processes left behind 475s ok 55 - No files in /etc/postgresql left behind 475s ok 56 - No files in /var/lib/postgresql left behind 475s ok 57 - No files in /var/run/postgresql left behind 475s ok 58 - No files in /var/log/postgresql left behind 475s ok 59 - PostgreSQL TCP ports are closed 475s ok 60 - Next free port is 5432 475s ### End test 050_encodings.t ### 475s 475s ### PostgreSQL test 052_upgrade_encodings.t ### 475s 1..1 475s ok 1 - only one major version installed, skipping upgrade tests 475s ### End test 052_upgrade_encodings.t ### 475s 475s ### PostgreSQL test 060_obsolete_confparams.t ### 475s ok 1 - only one major version installed, skipping upgrade tests 475s 1..1 475s ### End test 060_obsolete_confparams.t ### 475s 475s ### PostgreSQL test 070_non_postgres_clusters.t ### 475s 1..40 476s ok 1 - pg_createcluster 16 main for owner nobody 476s ok 2 - pg_ctlcluster 16 main start 476s ok 3 - start refused when config and data owners mismatch 478s ok 4 - pg_ctlcluster succeeds with owner nobody 478s ok 5 - pg_lsclusters -h 478s ok 6 - pg_lsclusters shows running cluster 478s ok 7 - postgres is running as user nobody 478s ok 8 - ls /tmp/.s.PGSQL.* 478s ok 9 - socket is in /tmp 478s ok 10 - /var/run/postgresql is empty 478s ok 11 - conf dir is owned by user 478s ok 12 - conf dir is owned by user's primary group 478s ok 13 - files are owned by user 478s ok 14 - files are owned by user's primary group 478s ok 15 - log file has 0640 permissions 478s ok 16 - log file is owned by user 478s ok 17 - log file is owned by user's primary group 478s ok 18 - only one major version installed, skipping upgrade test 478s ok 19 - ... 478s ok 20 - ... 478s ok 21 - ... 478s ok 22 - ... 478s ok 23 - ... 478s ok 24 - ... 478s ok 25 - ... 478s ok 26 - ... 478s ok 27 - ... 478s ok 28 - ... 480s ok 29 - pg_dropcluster 480s ok 30 - pg_lsclusters -h 480s ok 31 - No clusters left 480s ok 32 - No postgres processes left 480s # Cleanup 480s ok 33 - Cleanup: No clusters left behind 480s ok 34 - No postgres processes left behind 480s ok 35 - No files in /etc/postgresql left behind 480s ok 36 - No files in /var/lib/postgresql left behind 480s ok 37 - No files in /var/run/postgresql left behind 480s ok 38 - No files in /var/log/postgresql left behind 480s ok 39 - PostgreSQL TCP ports are closed 480s ok 40 - Next free port is 5432 480s ### End test 070_non_postgres_clusters.t ### 480s 480s ### PostgreSQL test 080_start.conf.t ### 480s 1..73 480s ok 1 - pg_createcluster 16 main 480s # start.conf auto 480s ok 2 - get_cluster_start_conf returns auto 480s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 480s ok 4 - start.conf contains auto 480s ok 5 - systemd generator links cluster 480s ok 6 - systemd generator links correct service file 483s ok 7 - /etc/init.d/postgresql start 16 483s ok 8 - correct output of /etc/init.d/postgresql start 16 483s ok 9 - pg_lsclusters -h 483s ok 10 - cluster is online 483s ok 11 - /etc/init.d/postgresql stop 16 483s ok 12 - correct output of /etc/init.d/postgresql stop 16 486s ok 13 - pg_lsclusters -h 486s ok 14 - cluster is down 486s # start.conf manual 486s ok 15 - get_cluster_start_conf returns manual 486s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 486s ok 17 - start.conf contains manual 486s ok 18 - systemd generator doesn't link cluster 486s ok 19 - /etc/init.d/postgresql start 16 486s ok 20 - correct output of /etc/init.d/postgresql start 16 486s ok 21 - pg_lsclusters -h 486s ok 22 - cluster is down 488s ok 23 - pg_ctlcluster 16 main start 488s ok 24 - correct output of pg_ctlcluster 16 main start 488s ok 25 - pg_lsclusters -h 488s ok 26 - cluster is online 488s ok 27 - pg_ctlcluster 16 main stop 488s ok 28 - correct output of pg_ctlcluster 16 main stop 488s ok 29 - pg_lsclusters -h 488s ok 30 - cluster is down 488s # start.conf disabled 488s ok 31 - get_cluster_start_conf returns disabled 488s ok 32 - systemd generator doesn't link cluster 488s ok 33 - /etc/init.d/postgresql start 16 488s ok 34 - correct output of /etc/init.d/postgresql start 16 488s ok 35 - pg_lsclusters -h 488s ok 36 - cluster is down 488s ok 37 - pg_ctlcluster 16 main start 488s ok 38 - correct output of pg_ctlcluster 16 main start 489s ok 39 - pg_lsclusters -h 489s ok 40 - cluster is down 491s ok 41 - pg_ctlcluster 16 main start 491s ok 42 - correct output of pg_ctlcluster 16 main start 491s ok 43 - pg_lsclusters -h 491s ok 44 - cluster is online 491s ok 45 - pg_ctlcluster 16 main stop 491s ok 46 - correct output of pg_ctlcluster 16 main stop 491s ok 47 - pg_lsclusters -h 491s ok 48 - cluster is down 493s ok 49 - pg_ctlcluster 16 main start 493s ok 50 - correct output of pg_ctlcluster 16 main start 493s ok 51 - pg_lsclusters -h 493s ok 52 - cluster is online 493s # test upgrade 493s ok 53 - only one major version installed, skipping upgrade test 493s ok 54 - ... 493s ok 55 - get_cluster_start_conf for old cluster returns manual 493s ok 56 - get_cluster_start_conf for new cluster returns manual 493s ok 57 - ... 494s ok 58 - dropping upgraded cluster 494s ok 59 - pg_lsclusters -h 494s ok 60 - no clusters any more 494s ok 61 - pg_createcluster 16 main --start-conf foo 494s ok 62 - pg_createcluster checks --start-conf validity 495s ok 63 - pg_createcluster checks --start-conf manual 495s ok 64 - get_cluster_start_conf returns manual 495s ok 65 - dropping cluster 495s # Cleanup 495s ok 66 - Cleanup: No clusters left behind 495s ok 67 - No postgres processes left behind 495s ok 68 - No files in /etc/postgresql left behind 495s ok 69 - No files in /var/lib/postgresql left behind 495s ok 70 - No files in /var/run/postgresql left behind 495s ok 71 - No files in /var/log/postgresql left behind 495s ok 72 - PostgreSQL TCP ports are closed 495s ok 73 - Next free port is 5432 495s ### End test 080_start.conf.t ### 495s 495s ### PostgreSQL test 085_pg_ctl.conf.t ### 496s 1..33 496s ok 1 - prlimit --core=0:unlimited --pid=16474 496s ok 2 - set core file size to unlimited 496s ok 3 - sh -c 'ulimit -Hc' 496s ok 4 - core file size is unlimited 496s ok 5 - pg_createcluster 16 main 496s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 498s ok 7 - pg_ctlcluster 16 main start 498s ok 8 - starting cluster as root 498s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 498s ok 10 - soft core size is 0 498s # hard core file size limit of root-started postgres process is unlimited 498s ok 11 - set pg_ctl default option to -c 501s ok 12 - pg_ctlcluster 16 main restart 501s ok 13 - restarting cluster as root 501s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 501s ok 15 - soft core size is unlimited 501s ok 16 - pg_ctlcluster 16 main stop 501s ok 17 - stopping cluster 501s ok 18 - restored pg_ctl default option 503s ok 19 - pg_ctlcluster 16 main start -- -c 503s ok 20 - starting cluster with -c on the command line as postgres 503s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 503s ok 22 - soft core size is unlimited 503s ok 23 - pg_ctlcluster 16 main stop 503s ok 24 - stopping cluster 504s ok 25 - dropping cluster 504s # Cleanup 504s ok 26 - Cleanup: No clusters left behind 504s ok 27 - No postgres processes left behind 504s ok 28 - No files in /etc/postgresql left behind 504s ok 29 - No files in /var/lib/postgresql left behind 504s ok 30 - No files in /var/run/postgresql left behind 504s ok 31 - No files in /var/log/postgresql left behind 504s ok 32 - PostgreSQL TCP ports are closed 504s ok 33 - Next free port is 5432 504s ### End test 085_pg_ctl.conf.t ### 504s 504s ### PostgreSQL test 090_multicluster.t ### 504s 1..125 505s ok 1 - pg_createcluster 16 old 506s ok 2 - pg_createcluster 16 new1 506s ok 3 - pg_createcluster 16 new2 509s ok 4 - starting cluster 16/old 511s ok 5 - starting cluster 16/new1 513s ok 6 - starting cluster 16/new2 513s ok 7 - pg_lsclusters -h | sort -k3 513s ok 8 - clusters have the correct ports, skipping used 5433 513s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 513s ok 10 - createdb --version 513s ok 11 - pg_wrapper selects port 5432 as default cluster 513s ok 12 - createdb --cluster 16/new1 --version 513s ok 13 - pg_wrapper --cluster works 513s ok 14 - createdb --cluster 16/foo --version 513s ok 15 - pg_wrapper --cluster errors out for invalid cluster 513s ok 16 - createdb --cluster 16/new1 test 513s ok 17 - correct output of createdb --cluster 16/new1 test 513s ok 18 - psql -Atl --cluster 16/new1 513s ok 19 - test db appears in cluster new1 513s ok 20 - psql -Atl --cluster 16/new2 513s ok 21 - test db does not appear in cluster new2 513s ok 22 - psql -Atl 513s ok 23 - test db does not appear in default cluster 513s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 513s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 513s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 513s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 513s ok 28 - psql -Atl --cluster 16/localhost:5434 513s ok 29 - test db appears in cluster 16/localhost:5434 513s ok 30 - psql -Atl --cluster 16/localhost:5440 513s ok 31 - test db does not appear in cluster 16/localhost:5440 513s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 513s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 513s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 513s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 513s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 513s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 513s ok 38 - psql -Atl --cluster 6.4/localhost: 513s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 514s ok 40 - psql -Atl 514s ok 41 - PGCLUSTER selection (1) 514s ok 42 - psql -Atl 514s ok 43 - PGCLUSTER selection (2) 514s ok 44 - psql -l 514s ok 45 - invalid PGCLUSTER value 514s ok 46 - createdb --version 514s ok 47 - PGCLUSTER network cluster selection (1) 514s ok 48 - psql -Atl 514s ok 49 - PGCLUSTER network cluster selection (2) 514s ok 50 - psql -Atl 514s ok 51 - PGCLUSTER network cluster selection (3) 514s ok 52 - LC_MESSAGES=C psql -Atl 514s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 514s ok 54 - psql -Atc "show port" template1 514s ok 55 - PGPORT selection (1) 514s ok 56 - psql -Atc "show port" template1 514s ok 57 - PGPORT selection (2) 514s ok 58 - createdb --version 514s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 514s ok 60 - psql -Atc "show port" template1 514s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 514s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 514s ok 63 - PGDATABASE environment variable works 514s ok 64 - createdb --version 514s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 514s ok 66 - createdb --cluster 16/new1 --version 514s ok 67 - pg_wrapper --cluster works with empty user_clusters 514s ok 68 - createdb --version 514s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 514s ok 70 - psql -Atc "select current_database()" 514s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 514s ok 72 - psql -Atc 'select current_database()' 514s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 514s ok 74 - createdb --version 514s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 514s ok 76 - createdb --version 514s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 514s ok 78 - createdb --version 514s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 514s ok 80 - createdb --version 514s ok 81 - pg_wrapper selects correct version with per-user user_clusters 514s ok 82 - createdb --version 514s ok 83 - pg_wrapper selects correct version with per-user user_clusters 514s ok 84 - createdb --version 514s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 514s ok 86 - psql -Atl 514s ok 87 - $PGHOST overrides user_clusters 514s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 514s ok 89 - --cluster overrides $PGHOST 514s ok 90 - createdb --version 514s ok 91 - pg_wrapper ignores invalid lines in user_clusters 514s ok 92 - psql -Atc 'select current_database()' 514s ok 93 - pg_service conf selection 1 514s ok 94 - psql -Atc 'select current_database()' 514s ok 95 - pg_service conf selection 2 514s ok 96 - psql -Atc 'select current_database()' 514s ok 97 - pg_service conf selection 3 514s ok 98 - stopping cluster 16/old 517s ok 99 - restarting cluster 16/old 517s ok 100 - pg_lsclusters -h | sort -k3 517s ok 101 - port of first cluster was successfully changed 517s ok 102 - psql -l 517s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 517s ok 104 - psql -Atl --cluster 16/new1 517s ok 105 - --cluster selects appropriate cluster 517s ok 106 - psql -Atl -p 5434 517s ok 107 - -p selects appropriate cluster 517s ok 108 - psql -Atlp 5434 517s ok 109 - -Atlp selects appropriate cluster 517s ok 110 - psql -Atl --port 5434 517s ok 111 - --port selects appropriate cluster 517s ok 112 - env PGPORT=5434 psql -Atl 517s ok 113 - $PGPORT selects appropriate cluster 517s ok 114 - Restoring original /etc/postgresql-common/user_clusters 518s ok 115 - dropping 16/new1 519s ok 116 - dropping 16/new2 520s ok 117 - dropping 16/old 520s # Cleanup 520s ok 118 - Cleanup: No clusters left behind 520s ok 119 - No postgres processes left behind 520s ok 120 - No files in /etc/postgresql left behind 520s ok 121 - No files in /var/lib/postgresql left behind 520s ok 122 - No files in /var/run/postgresql left behind 520s ok 123 - No files in /var/log/postgresql left behind 520s ok 124 - PostgreSQL TCP ports are closed 520s ok 125 - Next free port is 5432 520s ### End test 090_multicluster.t ### 520s 520s ### PostgreSQL test 110_integrate_cluster.t ### 520s 1..32 521s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/VcbO5gtPzK/c/postgres 521s ok 2 - creating raw initdb cluster for user postgres 521s ok 3 - pg_createcluster 16 postgres -d /tmp/VcbO5gtPzK/c/postgres 521s ok 4 - integrating postgres cluster 521s ok 5 - pg_lsclusters 521s ok 6 - correct pg_lsclusters output 523s ok 7 - pg_ctlcluster 16 postgres start 523s ok 8 - starting cluster postgres 523s ok 9 - pg_lsclusters 523s ok 10 - correct pg_lsclusters output 525s ok 11 - dropping cluster postgres 525s ok 12 - No files in temporary cluster dir left behind 525s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/VcbO5gtPzK/c/nobody 525s ok 14 - creating raw initdb cluster for user nobody 525s ok 15 - pg_createcluster 16 nobody -d /tmp/VcbO5gtPzK/c/nobody 525s ok 16 - integrating nobody cluster 525s ok 17 - pg_lsclusters 525s ok 18 - correct pg_lsclusters output 528s ok 19 - pg_ctlcluster 16 nobody start 528s ok 20 - starting cluster nobody 528s ok 21 - pg_lsclusters 528s ok 22 - correct pg_lsclusters output 529s ok 23 - dropping cluster nobody 529s ok 24 - No files in temporary cluster dir left behind 529s # Cleanup 529s ok 25 - Cleanup: No clusters left behind 529s ok 26 - No postgres processes left behind 529s ok 27 - No files in /etc/postgresql left behind 529s ok 28 - No files in /var/lib/postgresql left behind 529s ok 29 - No files in /var/run/postgresql left behind 529s ok 30 - No files in /var/log/postgresql left behind 529s ok 31 - PostgreSQL TCP ports are closed 529s ok 32 - Next free port is 5432 529s ### End test 110_integrate_cluster.t ### 529s 529s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 529s 1..1 529s ok 1 - only one major version installed, skipping upgrade tests 529s ### End test 120_pg_upgradecluster_scripts.t ### 529s 529s ### PostgreSQL test 130_nonroot_admin.t ### 529s 1..22 532s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 532s ok 2 - pg_lsclusters -h 532s ok 3 - correct output of pg_lsclusters -h 532s ok 4 - psql -Atl 532s ok 5 - correct output of psql -Atl 532s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 532s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 532s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 532s # Cleanup 532s ok 15 - Cleanup: No clusters left behind 532s ok 16 - No postgres processes left behind 532s ok 17 - No files in /etc/postgresql left behind 532s ok 18 - No files in /var/lib/postgresql left behind 532s ok 19 - No files in /var/run/postgresql left behind 532s ok 20 - No files in /var/log/postgresql left behind 532s ok 21 - PostgreSQL TCP ports are closed 532s ok 22 - Next free port is 5432 532s ### End test 130_nonroot_admin.t ### 532s 532s ### PostgreSQL test 135_pg_virtualenv.t ### 532s 1..20 536s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 536s ok 2 - running pg_virtualenv as root 539s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 539s ok 4 - running pg_virtualenv as postgres 542s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 542s ok 6 - running pg_virtualenv as nobody 545s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 545s ok 8 - running fakeroot pg_virtualenv as root 548s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 548s ok 10 - running fakeroot pg_virtualenv as postgres 550s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 550s ok 12 - running fakeroot pg_virtualenv as nobody 550s # Cleanup 551s ok 13 - Cleanup: No clusters left behind 551s ok 14 - No postgres processes left behind 551s ok 15 - No files in /etc/postgresql left behind 551s ok 16 - No files in /var/lib/postgresql left behind 551s ok 17 - No files in /var/run/postgresql left behind 551s ok 18 - No files in /var/log/postgresql left behind 551s ok 19 - PostgreSQL TCP ports are closed 551s ok 20 - Next free port is 5432 551s ### End test 135_pg_virtualenv.t ### 551s 551s ### PostgreSQL test 140_pg_config.t ### 551s 1..38 551s # Multiarch is enabled 551s # checking version specific output for 16 551s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 551s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 551s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 551s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 551s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 551s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 551s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 551s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 551s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 551s # checking pg_config output (should behave like version 16) 551s ok 15 - pg_config 551s ok 16 - correct output of pg_config 551s ok 17 - pg_config --help 551s ok 18 - correct output of pg_config --help 551s ok 19 - pg_config --pgxs 551s ok 20 - correct output of pg_config --pgxs 551s ok 21 - pg_config --libdir 551s ok 22 - correct output of pg_config --libdir 551s ok 23 - pg_config --pkglibdir 551s ok 24 - correct output of pg_config --pkglibdir 551s ok 25 - pg_config --bindir 551s ok 26 - correct output of pg_config --bindir 551s # checking pg_config.libpq-dev output (should behave like version 16) 551s ok 27 - pg_config.libpq-dev 551s ok 28 - correct output of pg_config.libpq-dev 551s ok 29 - pg_config.libpq-dev --help 551s ok 30 - correct output of pg_config.libpq-dev --help 551s ok 31 - pg_config.libpq-dev --pgxs 551s ok 32 - correct output of pg_config.libpq-dev --pgxs 551s ok 33 - pg_config.libpq-dev --libdir 551s ok 34 - correct output of pg_config.libpq-dev --libdir 551s ok 35 - pg_config.libpq-dev --pkglibdir 551s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 551s ok 37 - pg_config.libpq-dev --bindir 551s ok 38 - correct output of pg_config.libpq-dev --bindir 551s ### End test 140_pg_config.t ### 551s 551s ### PostgreSQL test 150_tsearch_stemming.t ### 551s 1..37 551s ok 1 - pg_updatedicts succeeded 551s ok 2 - pg_updatedicts created en_us.affix 551s ok 3 - pg_updatedicts created en_us.dict 551s ok 4 - pg_updatedicts created 16 en_us.affix symlink 551s ok 5 - pg_updatedicts created 16 en_us.dict symlink 554s ok 6 - pg_createcluster 16 main 554s ok 7 - createdb fts 554s ok 8 - correct output of createdb fts 554s ok 9 - creating en_US full text search configuration 554s ok 10 - creating data table and search index 554s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 554s ok 12 - stem search of correct word 554s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 554s ok 14 - stem search of correct word 554s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 554s ok 16 - stem search of unknown word 554s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 554s ok 18 - full text search, exact word 554s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 554s ok 20 - full text search for word stem 554s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 554s ok 22 - full text search for word substring fails 554s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 554s ok 24 - full text search, exact unicode word 554s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 554s ok 26 - full text search for unicode word stem 554s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 554s ok 28 - full text search for unicode word substring fails 556s ok 29 556s # Cleanup 556s ok 30 - Cleanup: No clusters left behind 556s ok 31 - No postgres processes left behind 556s ok 32 - No files in /etc/postgresql left behind 556s ok 33 - No files in /var/lib/postgresql left behind 556s ok 34 - No files in /var/run/postgresql left behind 556s ok 35 - No files in /var/log/postgresql left behind 556s ok 36 - PostgreSQL TCP ports are closed 556s ok 37 - Next free port is 5432 556s ### End test 150_tsearch_stemming.t ### 556s 556s ### PostgreSQL test 160_alternate_confroot.t ### 556s 1..28 558s ok 1 559s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 559s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 559s ok 4 - pg_lsclusters -h 559s ok 5 - correct output of pg_lsclusters -h 559s ok 6 - psql -Atl 559s ok 7 - correct output of psql -Atl 559s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 559s ok 9 - ... 559s ok 10 - ... 559s ok 11 - ... 559s ok 12 - ... 559s ok 13 - ... 559s ok 14 - ... 559s ok 15 - pg_dropcluster 16 test --stop 559s ok 16 - correct output of pg_dropcluster 16 test --stop 559s ok 17 - pg_lsclusters -h 559s ok 18 - correct output of pg_lsclusters -h 559s ok 19 - No files in root/data left behind 559s ok 20 - No cruft in root dir left behind 559s # Cleanup 559s ok 21 - Cleanup: No clusters left behind 559s ok 22 - No postgres processes left behind 559s ok 23 - No files in /etc/postgresql left behind 559s ok 24 - No files in /var/lib/postgresql left behind 559s ok 25 - No files in /var/run/postgresql left behind 559s ok 26 - No files in /var/log/postgresql left behind 559s ok 27 - PostgreSQL TCP ports are closed 559s ok 28 - Next free port is 5432 559s ### End test 160_alternate_confroot.t ### 559s 559s ### PostgreSQL test 170_extensions.t ### 559s # Running tests for 16 562s ok 1 - pg_createcluster 16 main 562s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 562s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 562s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 562s ok 5 - extension adminpack installs without error 562s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 562s ok 7 - extension adminpack removes without error 562s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 562s ok 9 - extension amcheck installs without error 562s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 562s ok 11 - extension amcheck removes without error 562s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 562s ok 13 - extension autoinc installs without error 562s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 562s ok 15 - extension autoinc removes without error 562s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 562s ok 17 - extension bloom installs without error 562s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 562s ok 19 - extension bloom removes without error 562s ok 20 - psql -qc 'CREATE EXTENSION plperl' 562s ok 21 - bool_plperl dependency plperl installs without error 562s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 562s ok 23 - extension bool_plperl installs without error 562s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 562s ok 25 - extension bool_plperl removes without error 562s ok 26 - psql -qc 'DROP EXTENSION plperl' 562s ok 27 - bool_plperl dependency extension plperl removes without error 562s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 562s ok 29 - bool_plperlu dependency plperlu installs without error 562s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 562s ok 31 - extension bool_plperlu installs without error 562s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 562s ok 33 - extension bool_plperlu removes without error 562s ok 34 - psql -qc 'DROP EXTENSION plperlu' 562s ok 35 - bool_plperlu dependency extension plperlu removes without error 562s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 562s ok 37 - extension btree_gin installs without error 562s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 562s ok 39 - extension btree_gin removes without error 563s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 563s ok 41 - extension btree_gist installs without error 563s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 563s ok 43 - extension btree_gist removes without error 563s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 563s ok 45 - extension citext installs without error 563s ok 46 - psql -qc 'DROP EXTENSION "citext"' 563s ok 47 - extension citext removes without error 563s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 563s ok 49 - extension cube installs without error 563s ok 50 - psql -qc 'DROP EXTENSION "cube"' 563s ok 51 - extension cube removes without error 563s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 563s ok 53 - extension dblink installs without error 563s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 563s ok 55 - extension dblink removes without error 563s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 563s ok 57 - extension dict_int installs without error 563s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 563s ok 59 - extension dict_int removes without error 563s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 563s ok 61 - extension dict_xsyn installs without error 563s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 563s ok 63 - extension dict_xsyn removes without error 563s ok 64 - psql -qc 'CREATE EXTENSION cube' 563s ok 65 - earthdistance dependency cube installs without error 563s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 563s ok 67 - extension earthdistance installs without error 563s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 563s ok 69 - extension earthdistance removes without error 563s ok 70 - psql -qc 'DROP EXTENSION cube' 563s ok 71 - earthdistance dependency extension cube removes without error 563s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 563s ok 73 - extension file_fdw installs without error 563s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 563s ok 75 - extension file_fdw removes without error 563s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 563s ok 77 - extension fuzzystrmatch installs without error 563s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 563s ok 79 - extension fuzzystrmatch removes without error 563s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 563s ok 81 - extension hstore installs without error 563s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 563s ok 83 - extension hstore removes without error 563s ok 84 - psql -qc 'CREATE EXTENSION hstore' 563s ok 85 - hstore_plperl dependency hstore installs without error 563s ok 86 - psql -qc 'CREATE EXTENSION plperl' 563s ok 87 - hstore_plperl dependency plperl installs without error 563s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 563s ok 89 - extension hstore_plperl installs without error 563s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 563s ok 91 - extension hstore_plperl removes without error 564s ok 92 - psql -qc 'DROP EXTENSION hstore' 564s ok 93 - hstore_plperl dependency extension hstore removes without error 564s ok 94 - psql -qc 'DROP EXTENSION plperl' 564s ok 95 - hstore_plperl dependency extension plperl removes without error 564s ok 96 - psql -qc 'CREATE EXTENSION hstore' 564s ok 97 - hstore_plperlu dependency hstore installs without error 564s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 564s ok 99 - hstore_plperlu dependency plperlu installs without error 564s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 564s ok 101 - extension hstore_plperlu installs without error 564s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 564s ok 103 - extension hstore_plperlu removes without error 564s ok 104 - psql -qc 'DROP EXTENSION hstore' 564s ok 105 - hstore_plperlu dependency extension hstore removes without error 564s ok 106 - psql -qc 'DROP EXTENSION plperlu' 564s ok 107 - hstore_plperlu dependency extension plperlu removes without error 564s ok 108 - psql -qc 'CREATE EXTENSION hstore' 564s ok 109 - hstore_plpython3u dependency hstore installs without error 564s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 564s ok 111 - hstore_plpython3u dependency plpython3u installs without error 564s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 564s ok 113 - extension hstore_plpython3u installs without error 564s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 564s ok 115 - extension hstore_plpython3u removes without error 564s ok 116 - psql -qc 'DROP EXTENSION hstore' 564s ok 117 - hstore_plpython3u dependency extension hstore removes without error 564s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 564s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 564s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 564s ok 121 - extension insert_username installs without error 564s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 564s ok 123 - extension insert_username removes without error 564s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 564s ok 125 - extension intagg installs without error 564s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 564s ok 127 - extension intagg removes without error 564s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 564s ok 129 - extension intarray installs without error 564s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 564s ok 131 - extension intarray removes without error 564s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 564s ok 133 - extension isn installs without error 564s ok 134 - psql -qc 'DROP EXTENSION "isn"' 564s ok 135 - extension isn removes without error 564s ok 136 - psql -qc 'CREATE EXTENSION plperl' 564s ok 137 - jsonb_plperl dependency plperl installs without error 564s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 564s ok 139 - extension jsonb_plperl installs without error 564s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 564s ok 141 - extension jsonb_plperl removes without error 564s ok 142 - psql -qc 'DROP EXTENSION plperl' 564s ok 143 - jsonb_plperl dependency extension plperl removes without error 565s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 565s ok 145 - jsonb_plperlu dependency plperlu installs without error 565s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 565s ok 147 - extension jsonb_plperlu installs without error 565s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 565s ok 149 - extension jsonb_plperlu removes without error 565s ok 150 - psql -qc 'DROP EXTENSION plperlu' 565s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 565s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 565s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 565s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 565s ok 155 - extension jsonb_plpython3u installs without error 565s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 565s ok 157 - extension jsonb_plpython3u removes without error 565s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 565s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 565s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 565s ok 161 - extension lo installs without error 565s ok 162 - psql -qc 'DROP EXTENSION "lo"' 565s ok 163 - extension lo removes without error 565s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 565s ok 165 - extension ltree installs without error 565s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 565s ok 167 - extension ltree removes without error 565s ok 168 - psql -qc 'CREATE EXTENSION ltree' 565s ok 169 - ltree_plpython3u dependency ltree installs without error 565s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 565s ok 171 - ltree_plpython3u dependency plpython3u installs without error 565s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 565s ok 173 - extension ltree_plpython3u installs without error 565s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 565s ok 175 - extension ltree_plpython3u removes without error 565s ok 176 - psql -qc 'DROP EXTENSION ltree' 565s ok 177 - ltree_plpython3u dependency extension ltree removes without error 565s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 565s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 565s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 565s ok 181 - extension moddatetime installs without error 565s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 565s ok 183 - extension moddatetime removes without error 565s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 565s ok 185 - extension old_snapshot installs without error 565s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 565s ok 187 - extension old_snapshot removes without error 565s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 565s ok 189 - extension pageinspect installs without error 565s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 565s ok 191 - extension pageinspect removes without error 565s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 565s ok 193 - extension pg_buffercache installs without error 565s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 565s ok 195 - extension pg_buffercache removes without error 565s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 565s ok 197 - extension pg_freespacemap installs without error 565s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 565s ok 199 - extension pg_freespacemap removes without error 565s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 565s ok 201 - extension pg_prewarm installs without error 566s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 566s ok 203 - extension pg_prewarm removes without error 566s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 566s ok 205 - extension pg_stat_statements installs without error 566s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 566s ok 207 - extension pg_stat_statements removes without error 566s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 566s ok 209 - extension pg_surgery installs without error 566s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 566s ok 211 - extension pg_surgery removes without error 566s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 566s ok 213 - extension pg_trgm installs without error 566s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 566s ok 215 - extension pg_trgm removes without error 566s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 566s ok 217 - extension pg_visibility installs without error 566s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 566s ok 219 - extension pg_visibility removes without error 566s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 566s ok 221 - extension pg_walinspect installs without error 566s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 566s ok 223 - extension pg_walinspect removes without error 566s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 566s ok 225 - extension pgcrypto installs without error 566s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 566s ok 227 - extension pgcrypto removes without error 566s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 566s ok 229 - extension pgrowlocks installs without error 566s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 566s ok 231 - extension pgrowlocks removes without error 566s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 566s ok 233 - extension pgstattuple installs without error 566s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 566s ok 235 - extension pgstattuple removes without error 566s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 566s ok 237 - extension plperl installs without error 566s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 566s ok 239 - extension plperl removes without error 566s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 566s ok 241 - extension plperlu installs without error 566s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 566s ok 243 - extension plperlu removes without error 566s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 566s ok 245 - extension plpython3u installs without error 566s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 566s ok 247 - extension plpython3u removes without error 566s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 566s ok 249 - extension pltcl installs without error 566s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 566s ok 251 - extension pltcl removes without error 566s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 566s ok 253 - extension pltclu installs without error 566s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 566s ok 255 - extension pltclu removes without error 567s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 567s ok 257 - extension postgres_fdw installs without error 567s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 567s ok 259 - extension postgres_fdw removes without error 567s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 567s ok 261 - extension refint installs without error 567s ok 262 - psql -qc 'DROP EXTENSION "refint"' 567s ok 263 - extension refint removes without error 567s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 567s ok 265 - extension seg installs without error 567s ok 266 - psql -qc 'DROP EXTENSION "seg"' 567s ok 267 - extension seg removes without error 567s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 567s ok 269 - extension sslinfo installs without error 567s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 567s ok 271 - extension sslinfo removes without error 567s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 567s ok 273 - extension tablefunc installs without error 567s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 567s ok 275 - extension tablefunc removes without error 567s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 567s ok 277 - extension tcn installs without error 567s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 567s ok 279 - extension tcn removes without error 567s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 567s ok 281 - extension tsm_system_rows installs without error 567s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 567s ok 283 - extension tsm_system_rows removes without error 567s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 567s ok 285 - extension tsm_system_time installs without error 567s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 567s ok 287 - extension tsm_system_time removes without error 567s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 567s ok 289 - extension unaccent installs without error 567s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 567s ok 291 - extension unaccent removes without error 567s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 567s ok 293 - extension uuid-ossp installs without error 567s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 567s ok 295 - extension uuid-ossp removes without error 567s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 567s ok 297 - extension xml2 installs without error 567s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 567s ok 299 - extension xml2 removes without error 568s ok 300 - pg_dropcluster 16 main 568s # Cleanup 568s ok 301 - Cleanup: No clusters left behind 568s ok 302 - No postgres processes left behind 568s ok 303 - No files in /etc/postgresql left behind 568s ok 304 - No files in /var/lib/postgresql left behind 568s ok 305 - No files in /var/run/postgresql left behind 568s ok 306 - No files in /var/log/postgresql left behind 569s ok 307 - PostgreSQL TCP ports are closed 569s ok 308 - Next free port is 5432 569s 1..308 569s ### End test 170_extensions.t ### 569s 569s ### PostgreSQL test 180_ecpg.t ### 569s 1..14 569s ok 1 - ecpg test.pgc 569s ok 2 - ecpg processing 569s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 569s ok 4 - compiling ecpg output 576s ok 5 - pg_virtualenv /tmp/tmp.RORmqUlZ9Y/test 576s ok 6 - test program runs and gives correct output 576s # Cleanup 576s ok 7 - Cleanup: No clusters left behind 576s ok 8 - No postgres processes left behind 576s ok 9 - No files in /etc/postgresql left behind 576s ok 10 - No files in /var/lib/postgresql left behind 576s ok 11 - No files in /var/run/postgresql left behind 576s ok 12 - No files in /var/log/postgresql left behind 576s ok 13 - PostgreSQL TCP ports are closed 576s ok 14 - Next free port is 5432 576s ### End test 180_ecpg.t ### 576s 576s ### PostgreSQL test 190_pg_buildext.t ### 576s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 576s 1..1 576s ### End test 190_pg_buildext.t ### 576s 576s ### PostgreSQL test 200_maintscripts.t ### 576s 1..15 576s # We are running systemd 579s ok 1 - pg_createcluster 16 main --start 579s ok 2 - postmaster PID is 21363 581s ok 3 - apt-get update -q 581s # postgresql-common: 581s # Installed: 257build1.1 581s # Candidate: 257build1.1 581s # Version table: 581s # *** 257build1.1 500 581s # 500 http://ftpmaster.internal/ubuntu noble-updates/main amd64 Packages 581s # 500 http://ftpmaster.internal/ubuntu noble-updates/main i386 Packages 581s # 100 /var/lib/dpkg/status 581s # 257build1 500 581s # 500 http://ftpmaster.internal/ubuntu noble/main amd64 Packages 581s # 500 http://ftpmaster.internal/ubuntu noble/main i386 Packages 584s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 584s # postgresql-common: 584s # Installed: 257build1.1 584s # Candidate: 257build1.1 584s # Version table: 584s # *** 257build1.1 500 584s # 500 http://ftpmaster.internal/ubuntu noble-updates/main amd64 Packages 584s # 500 http://ftpmaster.internal/ubuntu noble-updates/main i386 Packages 584s # 100 /var/lib/dpkg/status 584s # 257build1 500 584s # 500 http://ftpmaster.internal/ubuntu noble/main amd64 Packages 584s # 500 http://ftpmaster.internal/ubuntu noble/main i386 Packages 584s ok 5 - postmaster PID is 21363 584s ok 6 - postmaster was not restarted 585s ok 7 - pg_dropcluster 16 main --stop 585s # Cleanup 585s ok 8 - Cleanup: No clusters left behind 585s ok 9 - No postgres processes left behind 585s ok 10 - No files in /etc/postgresql left behind 585s ok 11 - No files in /var/lib/postgresql left behind 585s ok 12 - No files in /var/run/postgresql left behind 585s ok 13 - No files in /var/log/postgresql left behind 585s ok 14 - PostgreSQL TCP ports are closed 585s ok 15 - Next free port is 5432 585s ### End test 200_maintscripts.t ### 585s 586s autopkgtest [20:39:54]: test run-testsuite: -----------------------] 586s run-testsuite PASSautopkgtest [20:39:54]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 586s 586s autopkgtest [20:39:54]: test installcheck: preparing testbed 606s Creating nova instance adt-noble-amd64-postgresql-16-20251202-203008-juju-7f2275-prod-proposed-migration-environment-2-a0bf97ab-138a-42a7-a882-14b75650200e from image adt/ubuntu-noble-amd64-server-20251202.img (UUID ad7930e4-8fde-4e81-aa84-386fd598d2b2)... 656s autopkgtest [20:41:04]: testbed dpkg architecture: amd64 657s autopkgtest [20:41:05]: testbed apt version: 2.8.3 657s autopkgtest [20:41:05]: @@@@@@@@@@@@@@@@@@@@ test bed setup 657s autopkgtest [20:41:05]: testbed release detected to be: noble 658s autopkgtest [20:41:06]: updating testbed package index (apt update) 658s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 658s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 658s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 658s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 658s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [24.9 kB] 658s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6376 B] 658s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [62.8 kB] 658s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [41.8 kB] 658s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [78.8 kB] 658s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [436 kB] 659s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [2668 B] 659s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [14.8 kB] 659s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [874 kB] 659s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [372 B] 659s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [131 kB] 659s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [46.7 kB] 659s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [2492 B] 659s Get:18 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [2956 B] 659s Get:19 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [752 B] 659s Get:20 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [268 B] 660s Fetched 1992 kB in 1s (1744 kB/s) 661s Reading package lists... 661s Hit:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease 661s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 661s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 661s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 662s Reading package lists... 662s Reading package lists... 663s Building dependency tree... 663s Reading state information... 663s Calculating upgrade... 663s The following packages will be upgraded: 663s dhcpcd-base iproute2 wireless-regdb 663s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 663s Need to get 1343 kB of archives. 663s After this operation, 5120 B of additional disk space will be used. 663s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 dhcpcd-base amd64 1:10.0.6-1ubuntu3.2 [215 kB] 663s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 iproute2 amd64 6.1.0-1ubuntu6.3 [1120 kB] 664s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 wireless-regdb all 2025.07.10-0ubuntu1~24.04.1 [7502 B] 664s debconf: unable to initialize frontend: Dialog 664s debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) 664s debconf: falling back to frontend: Readline 664s debconf: unable to initialize frontend: Readline 664s debconf: (This frontend requires a controlling tty.) 664s debconf: falling back to frontend: Teletype 664s dpkg-preconfigure: unable to re-open stdin: 664s Fetched 1343 kB in 1s (1892 kB/s) 664s (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 ... 74807 files and directories currently installed.) 664s Preparing to unpack .../dhcpcd-base_1%3a10.0.6-1ubuntu3.2_amd64.deb ... 664s Unpacking dhcpcd-base (1:10.0.6-1ubuntu3.2) over (1:10.0.6-1ubuntu3.1) ... 664s Preparing to unpack .../iproute2_6.1.0-1ubuntu6.3_amd64.deb ... 664s Unpacking iproute2 (6.1.0-1ubuntu6.3) over (6.1.0-1ubuntu6.2) ... 664s Preparing to unpack .../wireless-regdb_2025.07.10-0ubuntu1~24.04.1_all.deb ... 664s Unpacking wireless-regdb (2025.07.10-0ubuntu1~24.04.1) over (2024.10.07-0ubuntu2~24.04.1) ... 664s Setting up iproute2 (6.1.0-1ubuntu6.3) ... 664s debconf: unable to initialize frontend: Dialog 664s debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) 664s debconf: falling back to frontend: Readline 664s debconf: unable to initialize frontend: Readline 664s debconf: (This frontend requires a controlling tty.) 664s debconf: falling back to frontend: Teletype 664s Setting up wireless-regdb (2025.07.10-0ubuntu1~24.04.1) ... 664s Setting up dhcpcd-base (1:10.0.6-1ubuntu3.2) ... 665s Processing triggers for man-db (2.12.0-4build2) ... 665s autopkgtest [20:41:13]: upgrading testbed (apt dist-upgrade and autopurge) 665s Reading package lists... 666s Building dependency tree... 666s Reading state information... 666s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 666s Starting 2 pkgProblemResolver with broken count: 0 666s Done 666s Entering ResolveByKeep 667s 667s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 667s Reading package lists... 667s Building dependency tree... 667s Reading state information... 667s Starting pkgProblemResolver with broken count: 0 667s Starting 2 pkgProblemResolver with broken count: 0 667s Done 668s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 670s Reading package lists... 670s Building dependency tree... 670s Reading state information... 671s Starting pkgProblemResolver with broken count: 0 671s Starting 2 pkgProblemResolver with broken count: 0 671s Done 671s The following NEW packages will be installed: 671s build-essential clang-17 cpp cpp-13 cpp-13-x86-64-linux-gnu 671s cpp-x86-64-linux-gnu g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu 671s gcc gcc-13 gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu 671s icu-devtools libasan8 libatomic1 libcc1-0 libclang-common-17-dev 671s libclang-cpp17t64 libclang1-17t64 libecpg-compat3 libecpg-dev libecpg6 671s libffi-dev libgc1 libgcc-13-dev libgomp1 libhwasan0 libicu-dev libisl23 671s libitm1 libjson-perl libllvm17t64 liblsan0 libmpc3 libncurses-dev 671s libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libquadmath0 671s libssl-dev libstdc++-13-dev libtcl8.6 libtsan2 libubsan1 libxml2-dev 671s libxslt1.1 libz3-4 libz3-dev llvm-17 llvm-17-dev llvm-17-linker-tools 671s llvm-17-runtime llvm-17-tools postgresql-16 postgresql-client-16 671s postgresql-client-common postgresql-common postgresql-doc-16 671s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 671s postgresql-server-dev-16 ssl-cert tzdata-legacy 671s 0 upgraded, 70 newly installed, 0 to remove and 0 not upgraded. 671s Need to get 222 MB of archives. 671s After this operation, 1068 MB of additional disk space will be used. 671s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 671s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-common all 257build1.1 [36.4 kB] 671s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 671s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-common all 257build1.1 [161 kB] 671s Get:5 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-base amd64 13.3.0-6ubuntu2~24.04 [51.5 kB] 671s Get:6 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libisl23 amd64 0.26-3build1.1 [680 kB] 671s Get:7 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libmpc3 amd64 1.3.1-1build1.1 [54.6 kB] 671s Get:8 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [10.7 MB] 673s Get:9 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13 amd64 13.3.0-6ubuntu2~24.04 [1038 B] 673s Get:10 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 673s Get:11 http://ftpmaster.internal/ubuntu noble/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 673s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libcc1-0 amd64 14.2.0-4ubuntu2~24.04 [48.0 kB] 673s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgomp1 amd64 14.2.0-4ubuntu2~24.04 [148 kB] 673s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libitm1 amd64 14.2.0-4ubuntu2~24.04 [29.7 kB] 673s Get:15 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libatomic1 amd64 14.2.0-4ubuntu2~24.04 [10.5 kB] 673s Get:16 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libasan8 amd64 14.2.0-4ubuntu2~24.04 [3031 kB] 673s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main amd64 liblsan0 amd64 14.2.0-4ubuntu2~24.04 [1322 kB] 673s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libtsan2 amd64 14.2.0-4ubuntu2~24.04 [2772 kB] 673s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libubsan1 amd64 14.2.0-4ubuntu2~24.04 [1184 kB] 673s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libhwasan0 amd64 14.2.0-4ubuntu2~24.04 [1641 kB] 673s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libquadmath0 amd64 14.2.0-4ubuntu2~24.04 [153 kB] 673s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgcc-13-dev amd64 13.3.0-6ubuntu2~24.04 [2681 kB] 673s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [21.1 MB] 675s Get:24 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13 amd64 13.3.0-6ubuntu2~24.04 [494 kB] 675s Get:25 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 675s Get:26 http://ftpmaster.internal/ubuntu noble/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 675s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libstdc++-13-dev amd64 13.3.0-6ubuntu2~24.04 [2420 kB] 675s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [12.2 MB] 675s Get:29 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13 amd64 13.3.0-6ubuntu2~24.04 [16.1 kB] 675s Get:30 http://ftpmaster.internal/ubuntu noble/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 675s Get:31 http://ftpmaster.internal/ubuntu noble/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 675s Get:32 http://ftpmaster.internal/ubuntu noble/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 675s Get:33 http://ftpmaster.internal/ubuntu noble/main amd64 libllvm17t64 amd64 1:17.0.6-9ubuntu1 [26.2 MB] 676s Get:34 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-cpp17t64 amd64 1:17.0.6-9ubuntu1 [12.9 MB] 677s Get:35 http://ftpmaster.internal/ubuntu noble/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 677s Get:36 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc4 amd64 14.2.0-4ubuntu2~24.04 [47.0 kB] 677s Get:37 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc-13-dev amd64 13.3.0-6ubuntu2~24.04 [194 kB] 677s Get:38 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-common-17-dev amd64 1:17.0.6-9ubuntu1 [690 kB] 677s Get:39 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-linker-tools amd64 1:17.0.6-9ubuntu1 [1308 kB] 677s Get:40 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang1-17t64 amd64 1:17.0.6-9ubuntu1 [7353 kB] 677s Get:41 http://ftpmaster.internal/ubuntu noble/universe amd64 clang-17 amd64 1:17.0.6-9ubuntu1 [78.6 kB] 677s Get:42 http://ftpmaster.internal/ubuntu noble-updates/main amd64 icu-devtools amd64 74.2-1ubuntu3.1 [212 kB] 677s Get:43 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpgtypes3 amd64 16.10-0ubuntu0.24.04.1 [46.3 kB] 677s Get:44 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq5 amd64 16.10-0ubuntu0.24.04.1 [144 kB] 677s Get:45 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg6 amd64 16.10-0ubuntu0.24.04.1 [44.6 kB] 677s Get:46 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-compat3 amd64 16.10-0ubuntu0.24.04.1 [12.4 kB] 677s Get:47 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libssl-dev amd64 3.0.13-0ubuntu3.6 [2408 kB] 678s Get:48 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq-dev amd64 16.10-0ubuntu0.24.04.1 [151 kB] 678s Get:49 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-dev amd64 16.10-0ubuntu0.24.04.1 [266 kB] 678s Get:50 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libicu-dev amd64 74.2-1ubuntu3.1 [11.9 MB] 678s Get:51 http://ftpmaster.internal/ubuntu noble/main amd64 libncurses-dev amd64 6.4+20240113-1ubuntu2 [384 kB] 678s Get:52 http://ftpmaster.internal/ubuntu noble/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 678s Get:53 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3.6 [781 kB] 678s Get:54 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 678s Get:55 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-runtime amd64 1:17.0.6-9ubuntu1 [529 kB] 678s Get:56 http://ftpmaster.internal/ubuntu noble/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 678s Get:57 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17 amd64 1:17.0.6-9ubuntu1 [23.8 MB] 679s Get:58 http://ftpmaster.internal/ubuntu noble/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 679s Get:59 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-tools amd64 1:17.0.6-9ubuntu1 [518 kB] 679s Get:60 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 680s Get:61 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 680s Get:62 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-dev amd64 1:17.0.6-9ubuntu1 [43.4 MB] 681s Get:63 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-16 amd64 16.10-0ubuntu0.24.04.1 [1297 kB] 682s Get:64 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-16 amd64 16.10-0ubuntu0.24.04.1 [15.5 MB] 682s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-doc-16 all 16.10-0ubuntu0.24.04.1 [2138 kB] 682s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plperl-16 amd64 16.10-0ubuntu0.24.04.1 [70.7 kB] 682s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plpython3-16 amd64 16.10-0ubuntu0.24.04.1 [78.9 kB] 682s Get:68 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-pltcl-16 amd64 16.10-0ubuntu0.24.04.1 [33.7 kB] 682s Get:69 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 postgresql-server-dev-16 amd64 16.10-0ubuntu0.24.04.1 [1229 kB] 682s Get:70 http://ftpmaster.internal/ubuntu noble-updates/main amd64 tzdata-legacy all 2025b-0ubuntu0.24.04.1 [94.8 kB] 683s Preconfiguring packages ... 683s Fetched 222 MB in 11s (19.6 MB/s) 683s Selecting previously unselected package libjson-perl. 683s (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 ... 74807 files and directories currently installed.) 683s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 683s Unpacking libjson-perl (4.10000-1) ... 683s Selecting previously unselected package postgresql-client-common. 683s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 683s Unpacking postgresql-client-common (257build1.1) ... 683s Selecting previously unselected package ssl-cert. 683s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 683s Unpacking ssl-cert (1.1.2ubuntu1) ... 683s Selecting previously unselected package postgresql-common. 683s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 683s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 683s Unpacking postgresql-common (257build1.1) ... 683s Selecting previously unselected package gcc-13-base:amd64. 683s Preparing to unpack .../04-gcc-13-base_13.3.0-6ubuntu2~24.04_amd64.deb ... 683s Unpacking gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 683s Selecting previously unselected package libisl23:amd64. 683s Preparing to unpack .../05-libisl23_0.26-3build1.1_amd64.deb ... 683s Unpacking libisl23:amd64 (0.26-3build1.1) ... 683s Selecting previously unselected package libmpc3:amd64. 683s Preparing to unpack .../06-libmpc3_1.3.1-1build1.1_amd64.deb ... 683s Unpacking libmpc3:amd64 (1.3.1-1build1.1) ... 683s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 683s Preparing to unpack .../07-cpp-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 683s Unpacking cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 683s Selecting previously unselected package cpp-13. 683s Preparing to unpack .../08-cpp-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 683s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 683s Selecting previously unselected package cpp-x86-64-linux-gnu. 683s Preparing to unpack .../09-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 683s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 683s Selecting previously unselected package cpp. 683s Preparing to unpack .../10-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 683s Unpacking cpp (4:13.2.0-7ubuntu1) ... 683s Selecting previously unselected package libcc1-0:amd64. 683s Preparing to unpack .../11-libcc1-0_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libgomp1:amd64. 683s Preparing to unpack .../12-libgomp1_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libitm1:amd64. 683s Preparing to unpack .../13-libitm1_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libatomic1:amd64. 683s Preparing to unpack .../14-libatomic1_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libasan8:amd64. 683s Preparing to unpack .../15-libasan8_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package liblsan0:amd64. 683s Preparing to unpack .../16-liblsan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libtsan2:amd64. 683s Preparing to unpack .../17-libtsan2_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libubsan1:amd64. 683s Preparing to unpack .../18-libubsan1_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libhwasan0:amd64. 683s Preparing to unpack .../19-libhwasan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libquadmath0:amd64. 683s Preparing to unpack .../20-libquadmath0_14.2.0-4ubuntu2~24.04_amd64.deb ... 683s Unpacking libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 683s Selecting previously unselected package libgcc-13-dev:amd64. 683s Preparing to unpack .../21-libgcc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 683s Unpacking libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 683s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 684s Preparing to unpack .../22-gcc-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 684s Unpacking gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 684s Selecting previously unselected package gcc-13. 684s Preparing to unpack .../23-gcc-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 684s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 684s Selecting previously unselected package gcc-x86-64-linux-gnu. 684s Preparing to unpack .../24-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 684s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 684s Selecting previously unselected package gcc. 684s Preparing to unpack .../25-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 684s Unpacking gcc (4:13.2.0-7ubuntu1) ... 684s Selecting previously unselected package libstdc++-13-dev:amd64. 684s Preparing to unpack .../26-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 684s Unpacking libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 684s Selecting previously unselected package g++-13-x86-64-linux-gnu. 684s Preparing to unpack .../27-g++-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 684s Unpacking g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 684s Selecting previously unselected package g++-13. 684s Preparing to unpack .../28-g++-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 684s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 684s Selecting previously unselected package g++-x86-64-linux-gnu. 684s Preparing to unpack .../29-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 684s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 684s Selecting previously unselected package g++. 684s Preparing to unpack .../30-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 684s Unpacking g++ (4:13.2.0-7ubuntu1) ... 684s Selecting previously unselected package build-essential. 684s Preparing to unpack .../31-build-essential_12.10ubuntu1_amd64.deb ... 684s Unpacking build-essential (12.10ubuntu1) ... 684s Selecting previously unselected package libllvm17t64:amd64. 684s Preparing to unpack .../32-libllvm17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 684s Unpacking libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package libclang-cpp17t64. 685s Preparing to unpack .../33-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 685s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package libgc1:amd64. 685s Preparing to unpack .../34-libgc1_1%3a8.2.6-1build1_amd64.deb ... 685s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 685s Selecting previously unselected package libobjc4:amd64. 685s Preparing to unpack .../35-libobjc4_14.2.0-4ubuntu2~24.04_amd64.deb ... 685s Unpacking libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 685s Selecting previously unselected package libobjc-13-dev:amd64. 685s Preparing to unpack .../36-libobjc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 685s Unpacking libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 685s Selecting previously unselected package libclang-common-17-dev:amd64. 685s Preparing to unpack .../37-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 685s Unpacking libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package llvm-17-linker-tools. 685s Preparing to unpack .../38-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 685s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package libclang1-17t64. 685s Preparing to unpack .../39-libclang1-17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 685s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package clang-17. 685s Preparing to unpack .../40-clang-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 685s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 685s Selecting previously unselected package icu-devtools. 685s Preparing to unpack .../41-icu-devtools_74.2-1ubuntu3.1_amd64.deb ... 685s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 685s Selecting previously unselected package libpgtypes3:amd64. 685s Preparing to unpack .../42-libpgtypes3_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libpgtypes3:amd64 (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libpq5:amd64. 685s Preparing to unpack .../43-libpq5_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libpq5:amd64 (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libecpg6:amd64. 685s Preparing to unpack .../44-libecpg6_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libecpg6:amd64 (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libecpg-compat3:amd64. 685s Preparing to unpack .../45-libecpg-compat3_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libecpg-compat3:amd64 (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libssl-dev:amd64. 685s Preparing to unpack .../46-libssl-dev_3.0.13-0ubuntu3.6_amd64.deb ... 685s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu3.6) ... 685s Selecting previously unselected package libpq-dev. 685s Preparing to unpack .../47-libpq-dev_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libpq-dev (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libecpg-dev. 685s Preparing to unpack .../48-libecpg-dev_16.10-0ubuntu0.24.04.1_amd64.deb ... 685s Unpacking libecpg-dev (16.10-0ubuntu0.24.04.1) ... 685s Selecting previously unselected package libicu-dev:amd64. 685s Preparing to unpack .../49-libicu-dev_74.2-1ubuntu3.1_amd64.deb ... 685s Unpacking libicu-dev:amd64 (74.2-1ubuntu3.1) ... 686s Selecting previously unselected package libncurses-dev:amd64. 686s Preparing to unpack .../50-libncurses-dev_6.4+20240113-1ubuntu2_amd64.deb ... 686s Unpacking libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 686s Selecting previously unselected package libtcl8.6:amd64. 686s Preparing to unpack .../51-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 686s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 686s Selecting previously unselected package libxml2-dev:amd64. 686s Preparing to unpack .../52-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.6_amd64.deb ... 686s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.6) ... 686s Selecting previously unselected package libxslt1.1:amd64. 686s Preparing to unpack .../53-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_amd64.deb ... 686s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 686s Selecting previously unselected package llvm-17-runtime. 686s Preparing to unpack .../54-llvm-17-runtime_1%3a17.0.6-9ubuntu1_amd64.deb ... 686s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 686s Selecting previously unselected package libpfm4:amd64. 686s Preparing to unpack .../55-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 686s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 686s Selecting previously unselected package llvm-17. 686s Preparing to unpack .../56-llvm-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 686s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 686s Selecting previously unselected package libffi-dev:amd64. 686s Preparing to unpack .../57-libffi-dev_3.4.6-1build1_amd64.deb ... 686s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 686s Selecting previously unselected package llvm-17-tools. 686s Preparing to unpack .../58-llvm-17-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 686s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 686s Selecting previously unselected package libz3-4:amd64. 686s Preparing to unpack .../59-libz3-4_4.8.12-3.1build1_amd64.deb ... 686s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 686s Selecting previously unselected package libz3-dev:amd64. 686s Preparing to unpack .../60-libz3-dev_4.8.12-3.1build1_amd64.deb ... 686s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 686s Selecting previously unselected package llvm-17-dev. 686s Preparing to unpack .../61-llvm-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 686s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 688s Selecting previously unselected package postgresql-client-16. 688s Preparing to unpack .../62-postgresql-client-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-client-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-16. 688s Preparing to unpack .../63-postgresql-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-doc-16. 688s Preparing to unpack .../64-postgresql-doc-16_16.10-0ubuntu0.24.04.1_all.deb ... 688s Unpacking postgresql-doc-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-plperl-16. 688s Preparing to unpack .../65-postgresql-plperl-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-plperl-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-plpython3-16. 688s Preparing to unpack .../66-postgresql-plpython3-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-plpython3-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-pltcl-16. 688s Preparing to unpack .../67-postgresql-pltcl-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-pltcl-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package postgresql-server-dev-16. 688s Preparing to unpack .../68-postgresql-server-dev-16_16.10-0ubuntu0.24.04.1_amd64.deb ... 688s Unpacking postgresql-server-dev-16 (16.10-0ubuntu0.24.04.1) ... 688s Selecting previously unselected package tzdata-legacy. 688s Preparing to unpack .../69-tzdata-legacy_2025b-0ubuntu0.24.04.1_all.deb ... 688s Unpacking tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 688s Setting up postgresql-client-common (257build1.1) ... 688s Setting up libpgtypes3:amd64 (16.10-0ubuntu0.24.04.1) ... 688s Setting up libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 688s Setting up postgresql-doc-16 (16.10-0ubuntu0.24.04.1) ... 689s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 689s Setting up libpq5:amd64 (16.10-0ubuntu0.24.04.1) ... 689s Setting up libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 689s Setting up tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 689s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 689s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 689s Setting up gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 689s Setting up libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 689s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 689s Setting up ssl-cert (1.1.2ubuntu1) ... 689s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 689s Setting up libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libssl-dev:amd64 (3.0.13-0ubuntu3.6) ... 689s Setting up libmpc3:amd64 (1.3.1-1build1.1) ... 689s Setting up libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 689s Setting up icu-devtools (74.2-1ubuntu3.1) ... 689s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 689s Setting up libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 689s Setting up libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 689s Setting up libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libjson-perl (4.10000-1) ... 689s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 689s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 689s Setting up libecpg6:amd64 (16.10-0ubuntu0.24.04.1) ... 689s Setting up libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libisl23:amd64 (0.26-3build1.1) ... 689s Setting up libicu-dev:amd64 (74.2-1ubuntu3.1) ... 689s Setting up libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 689s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 689s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 689s Setting up libecpg-compat3:amd64 (16.10-0ubuntu0.24.04.1) ... 689s Setting up cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 689s Setting up postgresql-client-16 (16.10-0ubuntu0.24.04.1) ... 690s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 690s Setting up libpq-dev (16.10-0ubuntu0.24.04.1) ... 690s Setting up libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 690s Setting up libecpg-dev (16.10-0ubuntu0.24.04.1) ... 690s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 690s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.6) ... 690s Setting up postgresql-common (257build1.1) ... 690s 690s Creating config file /etc/postgresql-common/createcluster.conf with new version 690s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 690s Removing obsolete dictionary files: 691s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 691s Setting up libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 691s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 691s Setting up libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 691s Setting up libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 691s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 691s Setting up postgresql-16 (16.10-0ubuntu0.24.04.1) ... 691s Creating new PostgreSQL cluster 16/main ... 691s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 691s The files belonging to this database system will be owned by user "postgres". 691s This user must also own the server process. 691s 691s The database cluster will be initialized with locale "C.UTF-8". 691s The default database encoding has accordingly been set to "UTF8". 691s The default text search configuration will be set to "english". 691s 691s Data page checksums are disabled. 691s 691s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 691s creating subdirectories ... ok 691s selecting dynamic shared memory implementation ... posix 691s selecting default max_connections ... 100 691s selecting default shared_buffers ... 128MB 691s selecting default time zone ... Etc/UTC 691s creating configuration files ... ok 691s running bootstrap script ... ok 691s performing post-bootstrap initialization ... ok 692s syncing data to disk ... ok 695s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 695s Setting up gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 695s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 695s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 695s Setting up postgresql-plpython3-16 (16.10-0ubuntu0.24.04.1) ... 695s Setting up cpp (4:13.2.0-7ubuntu1) ... 695s Setting up postgresql-plperl-16 (16.10-0ubuntu0.24.04.1) ... 695s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 695s Setting up postgresql-pltcl-16 (16.10-0ubuntu0.24.04.1) ... 695s Setting up g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 695s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 695s Setting up gcc (4:13.2.0-7ubuntu1) ... 695s Setting up postgresql-server-dev-16 (16.10-0ubuntu0.24.04.1) ... 695s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 695s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 695s Setting up g++ (4:13.2.0-7ubuntu1) ... 695s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 695s Setting up build-essential (12.10ubuntu1) ... 695s Processing triggers for libc-bin (2.39-0ubuntu8.6) ... 695s Processing triggers for systemd (255.4-1ubuntu8.11) ... 695s Processing triggers for man-db (2.12.0-4build2) ... 696s Processing triggers for install-info (7.1-3build2) ... 718s autopkgtest [20:42:06]: test installcheck: [----------------------- 718s + dpkg-parsechangelog -SSource 718s + SOURCE=postgresql-16 718s + MAJOR=16 718s + top_srcdir=/tmp/autopkgtest.jSI2tE/build.BWb/src 718s + cd src/test/regress 718s + make -f /tmp/autopkgtest.jSI2tE/build.BWb/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/16/bin/pg_config with_llvm=no 718s 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 -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -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.jSI2tE/build.BWb/src/debian/tests/ -I/usr/include/postgresql/16/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 719s 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 -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -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 719s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.jSI2tE/build.BWb/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.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/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/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.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/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/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.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/stats.sql sql/stats_ext.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/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.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/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/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.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/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/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/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/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.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/stats.out expected/stats_ext.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/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 719s + id -u 719s + [ 1000 = 0 ] 719s + SU=sh 719s + sh 719s + mktemp -d /tmp/regress.XXXXXX 719s + OUTPUT=/tmp/regress.awKK7j 719s + trap rm -rf /tmp/regress.awKK7j EXIT 719s + pg_virtualenv -v 16 /usr/lib/postgresql/16/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.awKK7j --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 719s Creating new PostgreSQL cluster 16/regress ... 722s # using postmaster on localhost, port 5433 722s ok 1 - test_setup 132 ms 723s # parallel group (20 tests): text int4 int2 int8 char varchar name pg_lsn oid txid uuid regproc float4 money float8 enum bit boolean numeric rangetypes 723s ok 2 + boolean 442 ms 723s ok 3 + char 178 ms 723s ok 4 + name 191 ms 723s ok 5 + varchar 185 ms 723s ok 6 + text 125 ms 723s ok 7 + int2 143 ms 723s ok 8 + int4 138 ms 723s ok 9 + int8 145 ms 723s ok 10 + oid 195 ms 723s ok 11 + float4 243 ms 723s ok 12 + float8 278 ms 723s ok 13 + bit 425 ms 723s ok 14 + numeric 525 ms 723s ok 15 + txid 199 ms 723s ok 16 + uuid 195 ms 723s ok 17 + enum 281 ms 723s ok 18 + money 232 ms 723s ok 19 + rangetypes 530 ms 723s ok 20 + pg_lsn 182 ms 723s ok 21 + regproc 214 ms 724s # parallel group (20 tests): circle lseg line path md5 time timetz inet macaddr numerology macaddr8 date interval point strings timestamp timestamptz multirangetypes polygon box 724s ok 22 + strings 461 ms 724s ok 23 + md5 148 ms 724s ok 24 + numerology 257 ms 724s ok 25 + point 439 ms 724s ok 26 + lseg 106 ms 724s ok 27 + line 127 ms 724s ok 28 + box 923 ms 724s ok 29 + path 135 ms 724s ok 30 + polygon 813 ms 724s ok 31 + circle 84 ms 724s ok 32 + date 336 ms 724s ok 33 + time 181 ms 724s ok 34 + timetz 192 ms 724s ok 35 + timestamp 556 ms 724s ok 36 + timestamptz 576 ms 724s ok 37 + interval 363 ms 724s ok 38 + inet 222 ms 724s ok 39 + macaddr 227 ms 724s ok 40 + macaddr8 245 ms 724s ok 41 + multirangetypes 776 ms 724s # parallel group (13 tests): comments misc_sanity unicode mvcc xid expressions tstypes type_sanity geometry database opr_sanity horology regex 724s ok 42 + geometry 278 ms 724s ok 43 + horology 506 ms 724s ok 44 + tstypes 221 ms 724s ok 45 + regex 542 ms 724s ok 46 + type_sanity 252 ms 724s ok 47 + opr_sanity 497 ms 724s ok 48 + misc_sanity 105 ms 724s ok 49 + comments 71 ms 724s ok 50 + expressions 187 ms 724s ok 51 + unicode 110 ms 724s ok 52 + xid 163 ms 724s ok 53 + mvcc 159 ms 724s ok 54 + database 477 ms 725s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 725s ok 55 + copy 101 ms 725s ok 56 + copyselect 39 ms 725s ok 57 + copydml 63 ms 725s ok 58 + insert 203 ms 725s ok 59 + insert_conflict 117 ms 725s # parallel group (7 tests): create_function_c create_type create_operator create_schema create_procedure create_misc create_table 725s ok 60 + create_function_c 59 ms 725s ok 61 + create_misc 91 ms 725s ok 62 + create_operator 69 ms 725s ok 63 + create_procedure 90 ms 725s ok 64 + create_table 219 ms 725s ok 65 + create_type 59 ms 725s ok 66 + create_schema 85 ms 726s # parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 726s ok 67 + create_index 726 ms 726s ok 68 + create_index_spgist 667 ms 726s ok 69 + create_view 265 ms 726s ok 70 + index_including 177 ms 726s ok 71 + index_including_gist 368 ms 726s # parallel group (16 tests): create_cast roleattributes hash_func errors create_aggregate drop_if_exists typed_table create_am create_function_sql constraints select infinite_recurse vacuum updatable_views inherit triggers 726s ok 72 + create_aggregate 205 ms 726s ok 73 + create_function_sql 302 ms 726s ok 74 + create_cast 107 ms 726s ok 75 + constraints 410 ms 726s ok 76 + triggers 813 ms 726s ok 77 + select 436 ms 726s ok 78 + inherit 803 ms 726s ok 79 + typed_table 254 ms 726s ok 80 + vacuum 566 ms 726s ok 81 + drop_if_exists 241 ms 726s ok 82 + updatable_views 647 ms 726s ok 83 + roleattributes 154 ms 726s ok 84 + create_am 299 ms 726s ok 85 + hash_func 154 ms 726s ok 86 + errors 182 ms 726s ok 87 + infinite_recurse 491 ms 726s ok 88 - sanity_check 56 ms 728s # parallel group (20 tests): select_having delete select_distinct_on random namespace select_implicit select_into case prepared_xacts transactions portals union select_distinct subselect arrays hash_index update btree_index aggregates join 728s ok 89 + select_into 248 ms 728s ok 90 + select_distinct 570 ms 728s ok 91 + select_distinct_on 166 ms 728s ok 92 + select_implicit 210 ms 728s ok 93 + select_having 145 ms 728s ok 94 + subselect 618 ms 728s ok 95 + union 511 ms 728s ok 96 + case 244 ms 728s ok 97 + join 1565 ms 728s ok 98 + aggregates 1431 ms 728s ok 99 + transactions 418 ms 728s ok 100 + random 181 ms 728s ok 101 + portals 485 ms 728s ok 102 + arrays 682 ms 728s ok 103 + btree_index 1355 ms 728s ok 104 + hash_index 813 ms 728s ok 105 + update 1076 ms 728s ok 106 + delete 151 ms 728s ok 107 + namespace 193 ms 728s ok 108 + prepared_xacts 277 ms 733s # parallel group (20 tests): drop_operator init_privs security_label tablesample lock password object_address replica_identity identity matview spgist collate generated rowsecurity gist gin groupingsets brin join_hash privileges 733s ok 109 + brin 4334 ms 733s ok 110 + gin 1757 ms 733s ok 111 + gist 1546 ms 733s ok 112 + spgist 1206 ms 733s ok 113 + privileges 4602 ms 733s ok 114 + init_privs 203 ms 733s ok 115 + security_label 258 ms 733s ok 116 + collate 1300 ms 733s ok 117 + matview 1176 ms 733s ok 118 + lock 410 ms 733s ok 119 + replica_identity 663 ms 733s ok 120 + rowsecurity 1487 ms 733s ok 121 + object_address 456 ms 733s ok 122 + tablesample 307 ms 733s ok 123 + groupingsets 1782 ms 733s ok 124 + drop_operator 167 ms 733s ok 125 + password 418 ms 733s ok 126 + identity 1027 ms 733s ok 127 + generated 1397 ms 733s ok 128 + join_hash 4315 ms 733s # parallel group (2 tests): brin_bloom brin_multi 733s ok 129 + brin_bloom 51 ms 733s ok 130 + brin_multi 96 ms 734s # parallel group (16 tests): tid async alter_operator dbsize tsrf tidscan create_role alter_generic sysviews misc_functions tidrangescan create_table_like merge incremental_sort misc collate.icu.utf8 734s ok 131 + create_table_like 539 ms 734s ok 132 + alter_generic 345 ms 734s ok 133 + alter_operator 126 ms 734s ok 134 + misc 785 ms 734s ok 135 + async 112 ms 734s ok 136 + dbsize 128 ms 734s ok 137 + merge 658 ms 734s ok 138 + misc_functions 396 ms 734s ok 139 + sysviews 388 ms 734s ok 140 + tsrf 139 ms 734s ok 141 + tid 99 ms 734s ok 142 + tidscan 165 ms 734s ok 143 + tidrangescan 473 ms 734s ok 144 + collate.icu.utf8 810 ms 734s ok 145 + incremental_sort 658 ms 734s ok 146 + create_role 243 ms 734s # parallel group (7 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab rules psql stats_ext 734s ok 147 + rules 282 ms 734s ok 148 + psql 325 ms 734s ok 149 + psql_crosstab 70 ms 734s ok 150 + amutils 59 ms 734s ok 151 + stats_ext 702 ms 734s ok 152 + collate.linux.utf8 41 ms 734s ok 153 + collate.windows.win1252 47 ms 737s ok 154 - select_parallel 2266 ms 737s ok 155 - write_parallel 113 ms 737s ok 156 - vacuum_parallel 72 ms 737s ok 157 - maintain_every 26 ms 738s # parallel group (2 tests): subscription publication 738s ok 158 + publication 1174 ms 738s ok 159 + subscription 70 ms 739s # parallel group (17 tests): portals_p2 xmlmap combocid advisory_lock functional_deps tsdicts equivclass dependency guc select_views bitmapops cluster window indirect_toast foreign_data foreign_key tsearch 739s ok 160 + select_views 362 ms 739s ok 161 + portals_p2 108 ms 739s ok 162 + foreign_key 1007 ms 739s ok 163 + cluster 611 ms 739s ok 164 + dependency 263 ms 739s ok 165 + guc 295 ms 739s ok 166 + bitmapops 576 ms 739s ok 167 + combocid 174 ms 739s ok 168 + tsearch 1337 ms 739s ok 169 + tsdicts 231 ms 739s ok 170 + foreign_data 870 ms 739s ok 171 + window 636 ms 739s ok 172 + xmlmap 156 ms 739s ok 173 + functional_deps 191 ms 739s ok 174 + advisory_lock 170 ms 739s ok 175 + indirect_toast 681 ms 739s ok 176 + equivclass 237 ms 740s # parallel group (7 tests): json_encoding jsonpath_encoding sqljson jsonpath jsonb_jsonpath json jsonb 740s ok 177 + json 172 ms 740s ok 178 + jsonb 210 ms 740s ok 179 + json_encoding 81 ms 740s ok 180 + jsonpath 124 ms 740s ok 181 + jsonpath_encoding 81 ms 740s ok 182 + jsonb_jsonpath 145 ms 740s ok 183 + sqljson 95 ms 741s # parallel group (18 tests): prepare limit returning plancache conversion temp sequence copy2 polymorphism largeobject rowtypes domain truncate with rangefuncs plpgsql xml alter_table 741s ok 184 + plancache 335 ms 741s ok 185 + limit 312 ms 741s ok 186 + plpgsql 977 ms 741s ok 187 + copy2 586 ms 741s ok 188 + temp 466 ms 741s ok 189 + domain 714 ms 741s ok 190 + rangefuncs 888 ms 741s ok 191 + prepare 193 ms 741s ok 192 + conversion 347 ms 741s ok 193 + truncate 721 ms 741s ok 194 + alter_table 1357 ms 741s ok 195 + sequence 580 ms 741s ok 196 + polymorphism 631 ms 741s ok 197 + rowtypes 691 ms 741s ok 198 + returning 297 ms 741s ok 199 + largeobject 671 ms 741s ok 200 + with 741 ms 741s ok 201 + xml 994 ms 743s # parallel group (12 tests): explain hash_part reloptions partition_info compression memoize partition_aggregate indexing partition_join tuplesort stats partition_prune 743s ok 202 + partition_join 1259 ms 743s ok 203 + partition_prune 1580 ms 743s ok 204 + reloptions 194 ms 743s ok 205 + hash_part 170 ms 743s ok 206 + indexing 1215 ms 743s ok 207 + partition_aggregate 1118 ms 743s ok 208 + partition_info 246 ms 743s ok 209 + tuplesort 1273 ms 743s ok 210 + explain 169 ms 743s ok 211 + compression 405 ms 743s ok 212 + memoize 972 ms 743s ok 213 + stats 1547 ms 743s # parallel group (2 tests): event_trigger oidjoins 743s ok 214 + event_trigger 60 ms 743s ok 215 + oidjoins 111 ms 743s ok 216 - fast_default 76 ms 743s ok 217 - tablespace 161 ms 743s 1..217 743s # All 217 tests passed. 743s Dropping cluster 16/regress ... 743s + rm -rf /tmp/regress.awKK7j 744s autopkgtest [20:42:32]: test installcheck: -----------------------] 744s autopkgtest [20:42:32]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 744s installcheck PASS 744s autopkgtest [20:42:32]: @@@@@@@@@@@@@@@@@@@@ summary 744s run-testsuite PASS 744s installcheck PASS