0s autopkgtest [18:36:45]: starting date and time: 2025-05-06 18:36:45+0000 0s autopkgtest [18:36:45]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [18:36:45]: host juju-7f2275-prod-proposed-migration-environment-23; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.xn2bv12t/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025b-1ubuntu1.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-arm64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-23@sto01-arm64-8.secgroup --name adt-plucky-arm64-postgresql-17-20250506-183644-juju-7f2275-prod-proposed-migration-environment-23-d726dacd-673b-47bc-8836-6fb5df050c19 --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-23 --net-id=net_prod-autopkgtest-workers-arm64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 105s autopkgtest [18:38:30]: testbed dpkg architecture: arm64 105s autopkgtest [18:38:30]: testbed apt version: 3.0.0 105s autopkgtest [18:38:30]: @@@@@@@@@@@@@@@@@@@@ test bed setup 105s autopkgtest [18:38:30]: testbed release detected to be: None 106s autopkgtest [18:38:31]: updating testbed package index (apt update) 106s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 106s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 106s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 106s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 106s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 106s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [5840 B] 106s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [252 B] 106s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [224 B] 106s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [16.6 kB] 106s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [8288 B] 106s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [324 B] 107s Fetched 302 kB in 0s (689 kB/s) 108s Reading package lists... 108s autopkgtest [18:38:33]: upgrading testbed (apt dist-upgrade and autopurge) 109s Reading package lists... 109s Building dependency tree... 109s Reading state information... 109s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 109s Starting 2 pkgProblemResolver with broken count: 0 109s Done 110s Entering ResolveByKeep 110s 110s Calculating upgrade... 111s The following packages will be upgraded: 111s tzdata 111s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s Need to get 198 kB of archives. 111s After this operation, 0 B of additional disk space will be used. 111s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 tzdata all 2025b-1ubuntu1.1 [198 kB] 111s Preconfiguring packages ... 111s Fetched 198 kB in 0s (7742 kB/s) 111s (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 ... 85224 files and directories currently installed.) 111s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 111s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 111s Setting up tzdata (2025b-1ubuntu1.1) ... 111s 111s Current default time zone: 'Etc/UTC' 111s Local time is now: Tue May 6 18:38:36 UTC 2025. 111s Universal Time is now: Tue May 6 18:38:36 UTC 2025. 111s Run 'dpkg-reconfigure tzdata' if you wish to change it. 111s 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 113s Solving dependencies... 113s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 115s autopkgtest [18:38:40]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 115s autopkgtest [18:38:40]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 122s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (dsc) [4245 B] 122s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (tar) [21.5 MB] 122s Get:3 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (diff) [27.2 kB] 122s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 122s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 122s gpgv: Can't check signature: No public key 122s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 126s autopkgtest [18:38:51]: testing package postgresql-17 version 17.4-1 128s autopkgtest [18:38:53]: build not needed 135s autopkgtest [18:39:00]: test run-testsuite: preparing testbed 135s Reading package lists... 135s Building dependency tree... 135s Reading state information... 135s Starting pkgProblemResolver with broken count: 0 135s Starting 2 pkgProblemResolver with broken count: 0 135s Done 136s The following NEW packages will be installed: 136s autoconf automake autopoint autotools-dev binutils-gold 136s binutils-gold-aarch64-linux-gnu build-essential clang-20 cpp cpp-14 136s cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 136s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 136s fakeroot g++ g++-14 g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 136s gcc-14 gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext hunspell-en-us 136s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-20-dev 136s libclang-cpp20 libclang1-20 libdebhelper-perl libecpg-compat3 libecpg-dev 136s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 136s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 136s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 136s libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libssl-dev 136s libstdc++-14-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 136s llvm-20 llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools 136s locales-all m4 po-debconf postgresql-17 postgresql-client-17 136s postgresql-client-common postgresql-common postgresql-common-dev 136s postgresql-doc-17 postgresql-plperl-17 postgresql-plpython3-17 136s postgresql-pltcl-17 postgresql-server-dev-17 ssl-cert 136s 0 upgraded, 90 newly installed, 0 to remove and 0 not upgraded. 136s Need to get 228 MB of archives. 136s After this operation, 1330 MB of additional disk space will be used. 136s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 136s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 136s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 136s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 136s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 136s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 136s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 136s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 m4 arm64 1.4.19-7 [244 kB] 136s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 autoconf all 2.72-3ubuntu1 [383 kB] 136s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 autotools-dev all 20220109.1 [44.9 kB] 136s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 automake all 1:1.17-3ubuntu1 [572 kB] 136s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 autopoint all 0.23.1-1 [619 kB] 136s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 binutils-gold-aarch64-linux-gnu arm64 2.44-2 [2033 kB] 136s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 binutils-gold arm64 2.44-2 [2168 B] 136s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 136s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 136s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [10.6 MB] 137s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-19ubuntu2 [1026 B] 137s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [5558 B] 137s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.2.0-1ubuntu1 [22.4 kB] 137s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 15-20250404-0ubuntu1 [49.1 kB] 137s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 15-20250404-0ubuntu1 [147 kB] 137s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 15-20250404-0ubuntu1 [27.8 kB] 137s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 15-20250404-0ubuntu1 [2922 kB] 137s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 15-20250404-0ubuntu1 [1318 kB] 137s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 15-20250404-0ubuntu1 [2692 kB] 137s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 15-20250404-0ubuntu1 [1177 kB] 137s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 15-20250404-0ubuntu1 [1640 kB] 137s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-19ubuntu2 [2593 kB] 137s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [20.9 MB] 137s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-19ubuntu2 [529 kB] 137s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [1200 B] 137s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.2.0-1ubuntu1 [4998 B] 137s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-19ubuntu2 [2501 kB] 137s Get:35 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [12.1 MB] 138s Get:36 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-19ubuntu2 [23.0 kB] 138s Get:37 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [956 B] 138s Get:38 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.2.0-1ubuntu1 [1080 B] 138s Get:39 http://ftpmaster.internal/ubuntu plucky/main arm64 build-essential arm64 12.12ubuntu1 [5082 B] 138s Get:40 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.2-0ubuntu1 [29.1 MB] 138s Get:41 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp20 arm64 1:20.1.2-0ubuntu1 [13.8 MB] 138s Get:42 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 138s Get:43 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 15-20250404-0ubuntu1 [45.5 kB] 138s Get:44 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-19ubuntu2 [190 kB] 138s Get:45 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-20-dev arm64 1:20.1.2-0ubuntu1 [782 kB] 138s Get:46 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-linker-tools arm64 1:20.1.2-0ubuntu1 [1243 kB] 138s Get:47 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang1-20 arm64 1:20.1.2-0ubuntu1 [7989 kB] 138s Get:48 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-20 arm64 1:20.1.2-0ubuntu1 [76.4 kB] 138s Get:49 http://ftpmaster.internal/ubuntu plucky/main arm64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 138s Get:50 http://ftpmaster.internal/ubuntu plucky/main arm64 libtool all 2.5.4-4 [168 kB] 138s Get:51 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-autoreconf all 20 [16.1 kB] 138s Get:52 http://ftpmaster.internal/ubuntu plucky/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 138s Get:53 http://ftpmaster.internal/ubuntu plucky/main arm64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 138s Get:54 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 138s Get:55 http://ftpmaster.internal/ubuntu plucky/main arm64 debugedit arm64 1:5.1-2 [46.1 kB] 139s Get:56 http://ftpmaster.internal/ubuntu plucky/main arm64 dwz arm64 0.15-1build6 [113 kB] 139s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 gettext arm64 0.23.1-1 [998 kB] 139s Get:58 http://ftpmaster.internal/ubuntu plucky/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 139s Get:59 http://ftpmaster.internal/ubuntu plucky/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 139s Get:60 http://ftpmaster.internal/ubuntu plucky/main arm64 debhelper all 13.24.1ubuntu2 [895 kB] 139s Get:61 http://ftpmaster.internal/ubuntu plucky/main arm64 emacsen-common all 3.0.7 [13.0 kB] 139s Get:62 http://ftpmaster.internal/ubuntu plucky/main arm64 dictionaries-common all 1.30.10 [178 kB] 139s Get:63 http://ftpmaster.internal/ubuntu plucky/main arm64 libfakeroot arm64 1.37.1-1 [33.9 kB] 139s Get:64 http://ftpmaster.internal/ubuntu plucky/main arm64 fakeroot arm64 1.37.1-1 [67.4 kB] 139s Get:65 http://ftpmaster.internal/ubuntu plucky/main arm64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 139s Get:66 http://ftpmaster.internal/ubuntu plucky/main arm64 libpgtypes3 arm64 17.4-1 [43.6 kB] 139s Get:67 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 139s Get:68 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg6 arm64 17.4-1 [44.0 kB] 139s Get:69 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-compat3 arm64 17.4-1 [12.4 kB] 139s Get:70 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.1-1ubuntu3 [3285 kB] 139s Get:71 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq-dev arm64 17.4-1 [159 kB] 139s Get:72 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-dev arm64 17.4-1 [263 kB] 139s Get:73 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5+20250216-2 [389 kB] 139s Get:74 http://ftpmaster.internal/ubuntu plucky/main arm64 libtcl8.6 arm64 8.6.16+dfsg-1 [987 kB] 139s Get:75 http://ftpmaster.internal/ubuntu plucky-updates/main arm64 libxml2-dev arm64 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [804 kB] 139s Get:76 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu4 [168 kB] 139s Get:77 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-runtime arm64 1:20.1.2-0ubuntu1 [538 kB] 139s Get:78 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 139s Get:79 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20 arm64 1:20.1.2-0ubuntu1 [19.0 MB] 139s Get:80 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.7-1 [59.5 kB] 139s Get:81 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-tools arm64 1:20.1.2-0ubuntu1 [512 kB] 139s Get:82 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-dev arm64 1:20.1.2-0ubuntu1 [48.2 MB] 140s Get:83 http://ftpmaster.internal/ubuntu plucky/universe arm64 locales-all arm64 2.41-6ubuntu1 [11.2 MB] 140s Get:84 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 140s Get:85 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 141s Get:86 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc-17 all 17.4-1 [2131 kB] 141s Get:87 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plperl-17 arm64 17.4-1 [64.5 kB] 141s Get:88 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plpython3-17 arm64 17.4-1 [74.0 kB] 141s Get:89 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-pltcl-17 arm64 17.4-1 [30.0 kB] 141s Get:90 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-17 arm64 17.4-1 [1390 kB] 141s Preconfiguring packages ... 141s Fetched 228 MB in 5s (47.2 MB/s) 141s Selecting previously unselected package libjson-perl. 141s (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 ... 85224 files and directories currently installed.) 141s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 141s Unpacking libjson-perl (4.10000-1) ... 141s Selecting previously unselected package postgresql-client-common. 141s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 141s Unpacking postgresql-client-common (274) ... 141s Selecting previously unselected package libio-pty-perl. 141s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 141s Unpacking libio-pty-perl (1:1.20-1build3) ... 141s Selecting previously unselected package libipc-run-perl. 141s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 141s Unpacking libipc-run-perl (20231003.0-2) ... 141s Selecting previously unselected package postgresql-common-dev. 141s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 141s Unpacking postgresql-common-dev (274) ... 141s Selecting previously unselected package ssl-cert. 141s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 141s Unpacking ssl-cert (1.1.3ubuntu1) ... 141s Selecting previously unselected package postgresql-common. 141s Preparing to unpack .../06-postgresql-common_274_all.deb ... 141s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 141s Unpacking postgresql-common (274) ... 141s Selecting previously unselected package m4. 141s Preparing to unpack .../07-m4_1.4.19-7_arm64.deb ... 141s Unpacking m4 (1.4.19-7) ... 142s Selecting previously unselected package autoconf. 142s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 142s Unpacking autoconf (2.72-3ubuntu1) ... 142s Selecting previously unselected package autotools-dev. 142s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 142s Unpacking autotools-dev (20220109.1) ... 142s Selecting previously unselected package automake. 142s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 142s Unpacking automake (1:1.17-3ubuntu1) ... 142s Selecting previously unselected package autopoint. 142s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 142s Unpacking autopoint (0.23.1-1) ... 142s Selecting previously unselected package binutils-gold-aarch64-linux-gnu. 142s Preparing to unpack .../12-binutils-gold-aarch64-linux-gnu_2.44-2_arm64.deb ... 142s Unpacking binutils-gold-aarch64-linux-gnu (2.44-2) ... 142s Selecting previously unselected package binutils-gold. 142s Preparing to unpack .../13-binutils-gold_2.44-2_arm64.deb ... 142s Unpacking binutils-gold (2.44-2) ... 142s Selecting previously unselected package libisl23:arm64. 142s Preparing to unpack .../14-libisl23_0.27-1_arm64.deb ... 142s Unpacking libisl23:arm64 (0.27-1) ... 142s Selecting previously unselected package libmpc3:arm64. 142s Preparing to unpack .../15-libmpc3_1.3.1-1build2_arm64.deb ... 142s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 142s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 142s Preparing to unpack .../16-cpp-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 142s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 142s Selecting previously unselected package cpp-14. 142s Preparing to unpack .../17-cpp-14_14.2.0-19ubuntu2_arm64.deb ... 142s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 142s Selecting previously unselected package cpp-aarch64-linux-gnu. 142s Preparing to unpack .../18-cpp-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 142s Unpacking cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 142s Selecting previously unselected package cpp. 142s Preparing to unpack .../19-cpp_4%3a14.2.0-1ubuntu1_arm64.deb ... 142s Unpacking cpp (4:14.2.0-1ubuntu1) ... 142s Selecting previously unselected package libcc1-0:arm64. 142s Preparing to unpack .../20-libcc1-0_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libcc1-0:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libgomp1:arm64. 142s Preparing to unpack .../21-libgomp1_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libgomp1:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libitm1:arm64. 142s Preparing to unpack .../22-libitm1_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libitm1:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libasan8:arm64. 142s Preparing to unpack .../23-libasan8_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libasan8:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package liblsan0:arm64. 142s Preparing to unpack .../24-liblsan0_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking liblsan0:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libtsan2:arm64. 142s Preparing to unpack .../25-libtsan2_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libtsan2:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libubsan1:arm64. 142s Preparing to unpack .../26-libubsan1_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libubsan1:arm64 (15-20250404-0ubuntu1) ... 142s Selecting previously unselected package libhwasan0:arm64. 142s Preparing to unpack .../27-libhwasan0_15-20250404-0ubuntu1_arm64.deb ... 142s Unpacking libhwasan0:arm64 (15-20250404-0ubuntu1) ... 143s Selecting previously unselected package libgcc-14-dev:arm64. 143s Preparing to unpack .../28-libgcc-14-dev_14.2.0-19ubuntu2_arm64.deb ... 143s Unpacking libgcc-14-dev:arm64 (14.2.0-19ubuntu2) ... 143s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 143s Preparing to unpack .../29-gcc-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 143s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 143s Selecting previously unselected package gcc-14. 143s Preparing to unpack .../30-gcc-14_14.2.0-19ubuntu2_arm64.deb ... 143s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 143s Selecting previously unselected package gcc-aarch64-linux-gnu. 143s Preparing to unpack .../31-gcc-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 143s Unpacking gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 143s Selecting previously unselected package gcc. 143s Preparing to unpack .../32-gcc_4%3a14.2.0-1ubuntu1_arm64.deb ... 143s Unpacking gcc (4:14.2.0-1ubuntu1) ... 143s Selecting previously unselected package libstdc++-14-dev:arm64. 143s Preparing to unpack .../33-libstdc++-14-dev_14.2.0-19ubuntu2_arm64.deb ... 143s Unpacking libstdc++-14-dev:arm64 (14.2.0-19ubuntu2) ... 143s Selecting previously unselected package g++-14-aarch64-linux-gnu. 143s Preparing to unpack .../34-g++-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 143s Unpacking g++-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 143s Selecting previously unselected package g++-14. 144s Preparing to unpack .../35-g++-14_14.2.0-19ubuntu2_arm64.deb ... 144s Unpacking g++-14 (14.2.0-19ubuntu2) ... 144s Selecting previously unselected package g++-aarch64-linux-gnu. 144s Preparing to unpack .../36-g++-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 144s Unpacking g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 144s Selecting previously unselected package g++. 144s Preparing to unpack .../37-g++_4%3a14.2.0-1ubuntu1_arm64.deb ... 144s Unpacking g++ (4:14.2.0-1ubuntu1) ... 144s Selecting previously unselected package build-essential. 144s Preparing to unpack .../38-build-essential_12.12ubuntu1_arm64.deb ... 144s Unpacking build-essential (12.12ubuntu1) ... 144s Selecting previously unselected package libllvm20:arm64. 144s Preparing to unpack .../39-libllvm20_1%3a20.1.2-0ubuntu1_arm64.deb ... 144s Unpacking libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 144s Selecting previously unselected package libclang-cpp20. 144s Preparing to unpack .../40-libclang-cpp20_1%3a20.1.2-0ubuntu1_arm64.deb ... 144s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 145s Selecting previously unselected package libgc1:arm64. 145s Preparing to unpack .../41-libgc1_1%3a8.2.8-1_arm64.deb ... 145s Unpacking libgc1:arm64 (1:8.2.8-1) ... 145s Selecting previously unselected package libobjc4:arm64. 145s Preparing to unpack .../42-libobjc4_15-20250404-0ubuntu1_arm64.deb ... 145s Unpacking libobjc4:arm64 (15-20250404-0ubuntu1) ... 145s Selecting previously unselected package libobjc-14-dev:arm64. 145s Preparing to unpack .../43-libobjc-14-dev_14.2.0-19ubuntu2_arm64.deb ... 145s Unpacking libobjc-14-dev:arm64 (14.2.0-19ubuntu2) ... 145s Selecting previously unselected package libclang-common-20-dev:arm64. 145s Preparing to unpack .../44-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_arm64.deb ... 145s Unpacking libclang-common-20-dev:arm64 (1:20.1.2-0ubuntu1) ... 145s Selecting previously unselected package llvm-20-linker-tools. 145s Preparing to unpack .../45-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_arm64.deb ... 145s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 145s Selecting previously unselected package libclang1-20. 145s Preparing to unpack .../46-libclang1-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 145s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 145s Selecting previously unselected package clang-20. 145s Preparing to unpack .../47-clang-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 145s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 145s Selecting previously unselected package libdebhelper-perl. 145s Preparing to unpack .../48-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 145s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 145s Selecting previously unselected package libtool. 145s Preparing to unpack .../49-libtool_2.5.4-4_all.deb ... 145s Unpacking libtool (2.5.4-4) ... 145s Selecting previously unselected package dh-autoreconf. 145s Preparing to unpack .../50-dh-autoreconf_20_all.deb ... 145s Unpacking dh-autoreconf (20) ... 145s Selecting previously unselected package libarchive-zip-perl. 145s Preparing to unpack .../51-libarchive-zip-perl_1.68-1_all.deb ... 145s Unpacking libarchive-zip-perl (1.68-1) ... 145s Selecting previously unselected package libfile-stripnondeterminism-perl. 145s Preparing to unpack .../52-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 145s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 145s Selecting previously unselected package dh-strip-nondeterminism. 145s Preparing to unpack .../53-dh-strip-nondeterminism_1.14.1-2_all.deb ... 145s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 145s Selecting previously unselected package debugedit. 145s Preparing to unpack .../54-debugedit_1%3a5.1-2_arm64.deb ... 145s Unpacking debugedit (1:5.1-2) ... 145s Selecting previously unselected package dwz. 145s Preparing to unpack .../55-dwz_0.15-1build6_arm64.deb ... 145s Unpacking dwz (0.15-1build6) ... 145s Selecting previously unselected package gettext. 145s Preparing to unpack .../56-gettext_0.23.1-1_arm64.deb ... 145s Unpacking gettext (0.23.1-1) ... 146s Selecting previously unselected package intltool-debian. 146s Preparing to unpack .../57-intltool-debian_0.35.0+20060710.6_all.deb ... 146s Unpacking intltool-debian (0.35.0+20060710.6) ... 146s Selecting previously unselected package po-debconf. 146s Preparing to unpack .../58-po-debconf_1.0.21+nmu1_all.deb ... 146s Unpacking po-debconf (1.0.21+nmu1) ... 146s Selecting previously unselected package debhelper. 146s Preparing to unpack .../59-debhelper_13.24.1ubuntu2_all.deb ... 146s Unpacking debhelper (13.24.1ubuntu2) ... 146s Selecting previously unselected package emacsen-common. 146s Preparing to unpack .../60-emacsen-common_3.0.7_all.deb ... 146s Unpacking emacsen-common (3.0.7) ... 146s Selecting previously unselected package dictionaries-common. 146s Preparing to unpack .../61-dictionaries-common_1.30.10_all.deb ... 146s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 146s Unpacking dictionaries-common (1.30.10) ... 146s Selecting previously unselected package libfakeroot:arm64. 146s Preparing to unpack .../62-libfakeroot_1.37.1-1_arm64.deb ... 146s Unpacking libfakeroot:arm64 (1.37.1-1) ... 146s Selecting previously unselected package fakeroot. 146s Preparing to unpack .../63-fakeroot_1.37.1-1_arm64.deb ... 146s Unpacking fakeroot (1.37.1-1) ... 146s Selecting previously unselected package hunspell-en-us. 146s Preparing to unpack .../64-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 146s Unpacking hunspell-en-us (1:2020.12.07-4) ... 146s Selecting previously unselected package libpgtypes3:arm64. 146s Preparing to unpack .../65-libpgtypes3_17.4-1_arm64.deb ... 146s Unpacking libpgtypes3:arm64 (17.4-1) ... 146s Selecting previously unselected package libpq5:arm64. 146s Preparing to unpack .../66-libpq5_17.4-1_arm64.deb ... 146s Unpacking libpq5:arm64 (17.4-1) ... 146s Selecting previously unselected package libecpg6:arm64. 146s Preparing to unpack .../67-libecpg6_17.4-1_arm64.deb ... 146s Unpacking libecpg6:arm64 (17.4-1) ... 146s Selecting previously unselected package libecpg-compat3:arm64. 146s Preparing to unpack .../68-libecpg-compat3_17.4-1_arm64.deb ... 146s Unpacking libecpg-compat3:arm64 (17.4-1) ... 146s Selecting previously unselected package libssl-dev:arm64. 146s Preparing to unpack .../69-libssl-dev_3.4.1-1ubuntu3_arm64.deb ... 146s Unpacking libssl-dev:arm64 (3.4.1-1ubuntu3) ... 146s Selecting previously unselected package libpq-dev. 146s Preparing to unpack .../70-libpq-dev_17.4-1_arm64.deb ... 146s Unpacking libpq-dev (17.4-1) ... 146s Selecting previously unselected package libecpg-dev. 146s Preparing to unpack .../71-libecpg-dev_17.4-1_arm64.deb ... 146s Unpacking libecpg-dev (17.4-1) ... 146s Selecting previously unselected package libncurses-dev:arm64. 146s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2_arm64.deb ... 146s Unpacking libncurses-dev:arm64 (6.5+20250216-2) ... 146s Selecting previously unselected package libtcl8.6:arm64. 146s Preparing to unpack .../73-libtcl8.6_8.6.16+dfsg-1_arm64.deb ... 146s Unpacking libtcl8.6:arm64 (8.6.16+dfsg-1) ... 146s Selecting previously unselected package libxml2-dev:arm64. 146s Preparing to unpack .../74-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_arm64.deb ... 146s Unpacking libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 146s Selecting previously unselected package libxslt1.1:arm64. 146s Preparing to unpack .../75-libxslt1.1_1.1.39-0exp1ubuntu4_arm64.deb ... 146s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 146s Selecting previously unselected package llvm-20-runtime. 146s Preparing to unpack .../76-llvm-20-runtime_1%3a20.1.2-0ubuntu1_arm64.deb ... 146s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 146s Selecting previously unselected package libpfm4:arm64. 146s Preparing to unpack .../77-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 146s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 146s Selecting previously unselected package llvm-20. 146s Preparing to unpack .../78-llvm-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 146s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 147s Selecting previously unselected package libffi-dev:arm64. 147s Preparing to unpack .../79-libffi-dev_3.4.7-1_arm64.deb ... 147s Unpacking libffi-dev:arm64 (3.4.7-1) ... 147s Selecting previously unselected package llvm-20-tools. 147s Preparing to unpack .../80-llvm-20-tools_1%3a20.1.2-0ubuntu1_arm64.deb ... 147s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 147s Selecting previously unselected package llvm-20-dev. 147s Preparing to unpack .../81-llvm-20-dev_1%3a20.1.2-0ubuntu1_arm64.deb ... 147s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 149s Selecting previously unselected package locales-all. 149s Preparing to unpack .../82-locales-all_2.41-6ubuntu1_arm64.deb ... 149s Unpacking locales-all (2.41-6ubuntu1) ... 150s Selecting previously unselected package postgresql-client-17. 150s Preparing to unpack .../83-postgresql-client-17_17.4-1_arm64.deb ... 150s Unpacking postgresql-client-17 (17.4-1) ... 150s Selecting previously unselected package postgresql-17. 150s Preparing to unpack .../84-postgresql-17_17.4-1_arm64.deb ... 150s Unpacking postgresql-17 (17.4-1) ... 151s Selecting previously unselected package postgresql-doc-17. 151s Preparing to unpack .../85-postgresql-doc-17_17.4-1_all.deb ... 151s Unpacking postgresql-doc-17 (17.4-1) ... 151s Selecting previously unselected package postgresql-plperl-17. 151s Preparing to unpack .../86-postgresql-plperl-17_17.4-1_arm64.deb ... 151s Unpacking postgresql-plperl-17 (17.4-1) ... 151s Selecting previously unselected package postgresql-plpython3-17. 151s Preparing to unpack .../87-postgresql-plpython3-17_17.4-1_arm64.deb ... 151s Unpacking postgresql-plpython3-17 (17.4-1) ... 151s Selecting previously unselected package postgresql-pltcl-17. 151s Preparing to unpack .../88-postgresql-pltcl-17_17.4-1_arm64.deb ... 151s Unpacking postgresql-pltcl-17 (17.4-1) ... 151s Selecting previously unselected package postgresql-server-dev-17. 151s Preparing to unpack .../89-postgresql-server-dev-17_17.4-1_arm64.deb ... 151s Unpacking postgresql-server-dev-17 (17.4-1) ... 151s Setting up postgresql-client-common (274) ... 151s Setting up libpgtypes3:arm64 (17.4-1) ... 151s Setting up libncurses-dev:arm64 (6.5+20250216-2) ... 151s Setting up libio-pty-perl (1:1.20-1build3) ... 151s Setting up libarchive-zip-perl (1.68-1) ... 151s Setting up libclang-common-20-dev:arm64 (1:20.1.2-0ubuntu1) ... 151s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 151s Setting up postgresql-doc-17 (17.4-1) ... 151s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 151s Setting up libpq5:arm64 (17.4-1) ... 151s Setting up m4 (1.4.19-7) ... 151s Setting up binutils-gold-aarch64-linux-gnu (2.44-2) ... 151s Setting up libgomp1:arm64 (15-20250404-0ubuntu1) ... 151s Setting up libffi-dev:arm64 (3.4.7-1) ... 151s Setting up locales-all (2.41-6ubuntu1) ... 151s Setting up libfakeroot:arm64 (1.37.1-1) ... 151s Setting up fakeroot (1.37.1-1) ... 151s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 151s Setting up autotools-dev (20220109.1) ... 151s Setting up libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 151s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 151s Setting up emacsen-common (3.0.7) ... 151s Setting up ssl-cert (1.1.3ubuntu1) ... 152s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 152s Setting up libssl-dev:arm64 (3.4.1-1ubuntu3) ... 152s Setting up libmpc3:arm64 (1.3.1-1build2) ... 152s Setting up libtcl8.6:arm64 (8.6.16+dfsg-1) ... 152s Setting up autopoint (0.23.1-1) ... 152s Setting up libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 152s Setting up libipc-run-perl (20231003.0-2) ... 152s Setting up libgc1:arm64 (1:8.2.8-1) ... 152s Setting up autoconf (2.72-3ubuntu1) ... 152s Setting up libubsan1:arm64 (15-20250404-0ubuntu1) ... 152s Setting up dwz (0.15-1build6) ... 152s Setting up libhwasan0:arm64 (15-20250404-0ubuntu1) ... 152s Setting up libasan8:arm64 (15-20250404-0ubuntu1) ... 152s Setting up libjson-perl (4.10000-1) ... 152s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 152s Setting up debugedit (1:5.1-2) ... 152s Setting up libecpg6:arm64 (17.4-1) ... 152s Setting up libtsan2:arm64 (15-20250404-0ubuntu1) ... 152s Setting up libisl23:arm64 (0.27-1) ... 152s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 152s Setting up libcc1-0:arm64 (15-20250404-0ubuntu1) ... 152s Setting up liblsan0:arm64 (15-20250404-0ubuntu1) ... 152s Setting up libitm1:arm64 (15-20250404-0ubuntu1) ... 152s Setting up postgresql-common-dev (274) ... 152s Setting up automake (1:1.17-3ubuntu1) ... 152s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 152s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 152s Setting up gettext (0.23.1-1) ... 152s Setting up libecpg-compat3:arm64 (17.4-1) ... 152s Setting up dictionaries-common (1.30.10) ... 152s Setting up postgresql-client-17 (17.4-1) ... 153s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 153s Setting up binutils-gold (2.44-2) ... 153s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 153s Setting up libpq-dev (17.4-1) ... 153s Setting up libobjc4:arm64 (15-20250404-0ubuntu1) ... 153s Setting up libecpg-dev (17.4-1) ... 153s Setting up intltool-debian (0.35.0+20060710.6) ... 153s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 153s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 153s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 153s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 153s Setting up postgresql-common (274) ... 153s Creating config file /etc/postgresql-common/createcluster.conf with new version 153s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 153s en_us 153s Removing obsolete dictionary files: 154s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 154s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 154s Setting up dh-strip-nondeterminism (1.14.1-2) ... 154s Setting up cpp-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 154s Setting up hunspell-en-us (1:2020.12.07-4) ... 154s Setting up libgcc-14-dev:arm64 (14.2.0-19ubuntu2) ... 154s Setting up libstdc++-14-dev:arm64 (14.2.0-19ubuntu2) ... 154s Setting up postgresql-17 (17.4-1) ... 155s Creating new PostgreSQL cluster 17/main ... 155s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 155s The files belonging to this database system will be owned by user "postgres". 155s This user must also own the server process. 155s 155s The database cluster will be initialized with locale "C.UTF-8". 155s The default database encoding has accordingly been set to "UTF8". 155s The default text search configuration will be set to "english". 155s 155s Data page checksums are disabled. 155s 155s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 155s creating subdirectories ... ok 155s selecting dynamic shared memory implementation ... posix 155s selecting default "max_connections" ... 100 155s selecting default "shared_buffers" ... 128MB 155s selecting default time zone ... Etc/UTC 155s creating configuration files ... ok 155s running bootstrap script ... ok 156s performing post-bootstrap initialization ... ok 156s syncing data to disk ... ok 159s Setting up po-debconf (1.0.21+nmu1) ... 159s Setting up libobjc-14-dev:arm64 (14.2.0-19ubuntu2) ... 159s Setting up cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 159s Setting up cpp-14 (14.2.0-19ubuntu2) ... 159s Setting up postgresql-plpython3-17 (17.4-1) ... 159s Setting up postgresql-plperl-17 (17.4-1) ... 159s Setting up cpp (4:14.2.0-1ubuntu1) ... 159s Setting up gcc-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 159s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 159s Setting up gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 159s Setting up postgresql-pltcl-17 (17.4-1) ... 159s Setting up g++-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 159s Setting up libtool (2.5.4-4) ... 159s Setting up gcc-14 (14.2.0-19ubuntu2) ... 159s Setting up dh-autoreconf (20) ... 159s Setting up postgresql-server-dev-17 (17.4-1) ... 159s Setting up g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 159s Setting up g++-14 (14.2.0-19ubuntu2) ... 159s Setting up debhelper (13.24.1ubuntu2) ... 159s Setting up gcc (4:14.2.0-1ubuntu1) ... 159s Setting up g++ (4:14.2.0-1ubuntu1) ... 159s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 159s Setting up build-essential (12.12ubuntu1) ... 159s Processing triggers for libc-bin (2.41-6ubuntu1) ... 159s Processing triggers for systemd (257.4-1ubuntu3) ... 159s Processing triggers for man-db (2.13.0-1) ... 160s Processing triggers for install-info (7.1.1-1) ... 160s Processing triggers for dictionaries-common (1.30.10) ... 163s autopkgtest [18:39:28]: test run-testsuite: [----------------------- 163s ====== Running all tests with umask 077 ======= 163s ### PostgreSQL test 001_packages.t ### 163s 1..22 163s ok 1 - /etc/os-release exists 163s ok 2 - OS is ubuntu 163s ok 3 - OS version is 25.04 163s # PostgreSQL versions installed: 17 163s ok 4 - postgresql-17 installed 163s ok 5 - postgresql-plpython3-17 installed 163s ok 6 - postgresql-plperl-17 installed 163s ok 7 - postgresql-pltcl-17 installed 163s ok 8 - postgresql-server-dev-17 installed 163s ok 9 # skip No postgresql-contrib-17 package for version 17 163s # postgresql-doc-17 installed 163s ok 10 - At least one doc package installed 163s ok 11 - libecpg-dev installed 163s ok 12 - postgresql-common-dev installed 163s ok 13 - procps installed 163s ok 14 - netcat-openbsd installed 163s ok 15 - hunspell-en-us installed 163s ok 16 - system has a default UTF-8 locale 163s ok 17 - locale ru_RU exists 163s ok 18 - locale ru_RU.UTF-8 exists 163s ok 19 - user postgres in the UNIX group ssl-cert 163s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 163s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 163s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 163s ### End test 001_packages.t ### 163s 163s ### PostgreSQL test 002_existing_clusters.t ### 163s 1..8 163s # Cleanup 163s ok 1 - Cleanup: No clusters left behind 163s ok 2 - No postgres processes left behind 163s ok 3 - No files in /etc/postgresql left behind 163s ok 4 - No files in /var/lib/postgresql left behind 163s ok 5 - No files in /var/run/postgresql left behind 163s ok 6 - No files in /var/log/postgresql left behind 163s ok 7 - PostgreSQL TCP ports are closed 163s ok 8 - Next free port is 5432 163s ### End test 002_existing_clusters.t ### 163s 163s ### PostgreSQL test 003_alternatives.t ### 163s 1..9 163s # Newest PG version installed is 17 164s ok 1 - psql.1.gz link group 164s ok 2 - postmaster.1.gz link group does not exist 164s ok 3 - psql.1.gz alternative 164s ok 4 - pg_dump.1.gz alternative 164s ok 5 - postgres.1.gz alternative 164s ok 6 - pg_ctl.1.gz alternative 164s # Newest PG doc version installed is 17 164s ok 7 - SPI_connect.3.gz link group 164s ok 8 - SPI_connect.3.gz alternative 164s ok 9 - SPI_exec.3.gz alternative 164s ### End test 003_alternatives.t ### 164s 164s ### PostgreSQL test 005_PgCommon.t ### 164s 1..24 164s ok 1 - correctly parsed line 'local all postgres ident sameuser' 164s ok 2 - correctly parsed line 'local foo nobody trust' 164s ok 3 - correctly parsed line 'local foo nobody crypt' 164s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 164s ok 5 - correctly parsed line 'local foo,bar nobody ident' 164s ok 6 - correctly parsed line 'local all +foogrp password' 164s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 164s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 164s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 164s ok 10 - @expected_records has correct number of entries 164s ok 11 - returned read_pg_hba array has correct number of records 164s ok 12 - line 'foo all all md5' parsed as invalid 164s ok 13 - line 'local all all foo' parsed as invalid 164s ok 14 - line 'host all all foo' parsed as invalid 164s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 164s ok 16 - line 'host all all md5' parsed as invalid 164s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 164s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 164s ok 19 - read_conf_file returns empty dict for nonexisting file 164s ok 20 - read_conf_file() parsing 164s ok 21 - read_conf_file() parsing with include directives 164s ok 22 - set_conf_value 164s ok 23 - disable_conf_value 164s ok 24 - replace_conf_value 164s ### End test 005_PgCommon.t ### 164s 164s ### PostgreSQL test 006_next_free_port.t ### 164s 1..5 164s ok 1 - next_free_port is 5432 165s ok 2 - next_free_port detects localhost ipv4 socket 166s ok 3 - next_free_port detects wildcard ipv4 socket 167s ok 4 - next_free_port detects localhost ipv6 socket 168s ok 5 - next_free_port detects wildcard ipv6 socket 168s ### End test 006_next_free_port.t ### 168s 168s ### PostgreSQL test 007_pg_conftool.t ### 168s 1..41 168s # test without cluster 168s ok 1 - pg_conftool show all 168s ok 2 - correct output of pg_conftool show all 168s ok 3 - pg_conftool foo.conf show all 168s ok 4 - correct output of pg_conftool foo.conf show all 168s ok 5 - pg_conftool /tmp/kEyQuvlDBQ/different.conf show all 168s ok 6 - correct output of pg_conftool /tmp/kEyQuvlDBQ/different.conf show all 168s ok 7 - pg_conftool 9.7 main show all 168s ok 8 - correct output of pg_conftool 9.7 main show all 168s # test show 168s ok 9 - pg_conftool show all 168s ok 10 - correct output of pg_conftool show all 168s ok 11 - pg_conftool other.conf show all 168s ok 12 - correct output of pg_conftool other.conf show all 168s ok 13 - pg_conftool /tmp/kEyQuvlDBQ/different.conf show all 168s ok 14 - correct output of pg_conftool /tmp/kEyQuvlDBQ/different.conf show all 168s ok 15 - pg_conftool 17 main show all 168s ok 16 - correct output of pg_conftool 17 main show all 168s ok 17 - pg_conftool 17 main other.conf show all 168s ok 18 - correct output of pg_conftool 17 main other.conf show all 168s ok 19 - pg_conftool show a 168s ok 20 - correct output of pg_conftool show a 168s ok 21 - pg_conftool -s show a 168s ok 22 - correct output of pg_conftool -s show a 168s # test set 168s ok 23 - pg_conftool set c 7 168s ok 24 - correct output of pg_conftool set c 7 168s ok 25 - file contains new setting 168s ok 26 - pg_conftool set a 8 168s ok 27 - correct output of pg_conftool set a 8 168s ok 28 - file contains updated setting 168s ok 29 - pg_conftool /tmp/kEyQuvlDBQ/different.conf set a 9 168s ok 30 - correct output of pg_conftool /tmp/kEyQuvlDBQ/different.conf set a 9 168s ok 31 - file with path contains updated setting 168s # test remove 168s ok 32 - pg_conftool remove a 168s ok 33 - correct output of pg_conftool remove a 168s ok 34 - setting removed from file 168s ok 35 - pg_conftool /tmp/kEyQuvlDBQ/different.conf remove a 168s ok 36 - correct output of pg_conftool /tmp/kEyQuvlDBQ/different.conf remove a 168s ok 37 - setting removed from file with path 168s # test edit 168s ok 38 - pg_conftool edit 168s ok 39 - correct output of pg_conftool edit 168s ok 40 - pg_conftool /tmp/kEyQuvlDBQ/different.conf edit 168s ok 41 - correct output of pg_conftool /tmp/kEyQuvlDBQ/different.conf edit 168s ### End test 007_pg_conftool.t ### 168s 168s ### PostgreSQL test 010_defaultport_cluster.t ### 168s 1..14 168s ok 1 - psql --version 168s ok 2 - pg_wrapper selects highest available version number 169s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 169s ok 4 - connecting to localhost fails with no clusters 169s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 169s ok 6 - pg_wrapper uses host and port from PGCLUSTER 169s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 169s ok 8 - pg_wrapper uses --cluster from the command line 169s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 169s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 169s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 169s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 169s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 169s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 169s ### End test 010_defaultport_cluster.t ### 169s 169s ### PostgreSQL test 015_start_stop.t ### 169s 1..71 169s # We are running systemd 169s # Running tests for 17 169s # Cluster does not exist yet 169s ok 1 - cluster 17 main does not exist 169s ok 2 - service postgresql@17-main does not exist 169s ok 3 - systemctl start postgresql 169s ok 4 - cluster 17 main does not exist 169s ok 5 - service postgresql@17-main does not exist 169s ok 6 - systemctl start postgresql@17-main 169s ok 7 - cluster 17 main does not exist 169s ok 8 - service postgresql@17-main does not exist 169s # Start/stop postgresql using system tools 170s ok 9 - pg_createcluster 17 main 170s ok 10 - cluster 17 main is stopped 170s ok 11 - service postgresql@17-main is stopped 172s ok 12 - systemctl start postgresql 172s ok 13 - cluster 17 main is running 172s ok 14 - service postgresql@17-main is running 172s ok 15 - systemctl start postgresql 172s ok 16 - cluster 17 main is already running 172s ok 17 - service postgresql@17-main is already running 172s ok 18 - systemctl stop postgresql 178s ok 19 - cluster 17 main is stopped 178s ok 20 - service postgresql@17-main is stopped 178s ok 21 - systemctl stop postgresql 178s ok 22 - cluster 17 main is already stopped 178s ok 23 - service postgresql@17-main is already stopped 178s # Start/stop specific cluster using system tools 181s ok 24 - systemctl start postgresql@17-main 181s ok 25 - cluster 17 main is running 181s ok 26 - service postgresql@17-main is running 181s ok 27 - systemctl start postgresql@17-main 181s ok 28 - cluster 17 main is running 181s ok 29 - service postgresql@17-main is running 183s ok 30 - systemctl restart postgresql@17-main 183s ok 31 - cluster 17 main is running 183s ok 32 - service postgresql@17-main is running 183s ok 33 - systemctl stop postgresql@17-main 183s ok 34 - cluster 17 main is stopped 183s ok 35 - service postgresql@17-main is stopped 183s ok 36 - systemctl stop postgresql@17-main 183s ok 37 - cluster 17 main is already stopped 184s ok 38 - service postgresql@17-main is already stopped 185s ok 39 - pg_dropcluster 17 main 185s ok 40 - cluster 17 main does not exist 185s ok 41 - service postgresql@17-main does not exist 185s # Start/stop specific cluster using pg_*cluster 185s ok 42 - pg_ctlcluster start 17 main 185s ok 43 - cluster 17 main does not exist 185s ok 44 - service postgresql@17-main does not exist 188s ok 45 - pg_createcluster 17 main --start 188s ok 46 - cluster 17 main is running 188s ok 47 - service postgresql@17-main is running 188s ok 48 - pg_ctlcluster 17 main start 189s ok 49 - cluster 17 main is already running 189s ok 50 - service postgresql@17-main is already running 191s ok 51 - pg_ctlcluster 17-main restart 191s ok 52 - cluster 17 main is running 191s ok 53 - service postgresql@17-main is running 191s ok 54 - pg_ctlcluster 17 main stop 191s ok 55 - cluster 17 main is stopped 191s ok 56 - service postgresql@17-main is stopped 191s ok 57 - pg_ctlcluster 17 main stop 191s ok 58 - cluster 17 main is already stopped 191s ok 59 - service postgresql@17-main is already stopped 194s ok 60 - pg_ctlcluster start 17-main 194s ok 61 - cluster 17 main is running 194s ok 62 - service postgresql@17-main is running 195s ok 63 - pg_dropcluster 17 main --stop 195s # Cleanup 195s ok 64 - Cleanup: No clusters left behind 195s ok 65 - No postgres processes left behind 195s ok 66 - No files in /etc/postgresql left behind 195s ok 67 - No files in /var/lib/postgresql left behind 195s ok 68 - No files in /var/run/postgresql left behind 195s ok 69 - No files in /var/log/postgresql left behind 195s ok 70 - PostgreSQL TCP ports are closed 195s ok 71 - Next free port is 5432 195s ### End test 015_start_stop.t ### 195s 195s ### PostgreSQL test 020_create_sql_remove.t ### 195s 1..141 195s # Running tests for 17 198s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.X3T6EG 198s ok 2 - pg_createcluster 17 main 198s ok 3 - Socket and pid file are in /var/run/postgresql/ 198s ok 4 - xlog/wal directory /tmp/17.xlog.X3T6EG was created 198s ok 5 - local method in pg_hba.conf is peer 198s ok 6 - host method in pg_hba.conf is scram-sha-256 198s ok 7 - Exactly one postgres master process running 201s ok 8 - pg_ctlcluster 17 main restart 201s ok 9 - cluster restarts with new environment file 201s ok 10 - Exactly one postgres master process running 201s ok 11 - correct value of PGEXTRAVAR1 in environment 201s ok 12 - correct value of PGEXTRAVAR2 in environment 201s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 201s ok 14 - createdb --version 201s ok 15 - pg_wrapper+createdb selects version number of cluster 201s ok 16 - psql --version 201s ok 17 - pg_wrapper+psql selects version 17 201s ok 18 - pg_lscluster reports online cluster on port 5432 201s ok 19 - log file is actually used 201s ok 20 - /etc/postgresql is owned by user "postgres" 201s ok 21 - version configuration directory file is owned by user "postgres" 201s ok 22 - configuration directory file is owned by user "postgres" 201s ok 23 - version data directory file is owned by user "postgres" 201s ok 24 - data directory file is owned by user "postgres" 201s ok 25 - log file has 0640 permissions 201s ok 26 - log file is owned by user "postgres" 201s ok 27 - log file is owned by group "adm" 201s ok 28 - no log symlink by default 201s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 201s ok 30 - pg_lsclusters -h 201s ok 31 - correct output of pg_lsclusters -h 201s ok 32 - stopping cluster 204s ok 33 - restarting cluster with nondefault log symlink 204s ok 34 - log target is used as log file 204s ok 35 - default log is not used 204s ok 36 - pg_lsclusters -h 204s ok 37 - correct output of pg_lsclusters -h 204s ok 38 - stopping cluster 207s ok 39 - restarting cluster with explicitly configured log file 207s ok 40 - default log is not used 207s ok 41 - log symlink target is used for startup message 207s ok 42 - exactly one log file 207s ok 43 - custom log is actually used 207s ok 44 - pg_lsclusters -h 207s ok 45 - correct output of pg_lsclusters -h 207s ok 46 - stopping cluster 207s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 207s ok 48 - /etc/postgres-hack was not created 209s ok 49 - restarting cluster 209s ok 50 - ps -o tty -U postgres h 209s ok 51 - postgres processes do not have an associated terminal 209s ok 52 - Server is linked with SSL support 209s ok 53 - SSL is enabled in postgresql.conf 209s ok 54 - psql -l fails for nobody 209s ok 55 - createuser nobody 209s ok 56 - createdb nobodydb 209s ok 57 - psql -ltA succeeds for nobody 209s ok 58 - psql -ltA output 209s ok 59 - SQL command: create table 209s ok 60 - SQL command: insert into table values 209s ok 61 - SQL command: insert into table values 210s ok 62 - primary key violation 210s ok 63 - psql -tAc "select * from phone order by name" nobodydb 210s ok 64 - SQL command output: select -tA 210s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 210s ok 66 - SQL command output: select -tx 210s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 210s ok 68 - SQL command output: select -tAx 210s ok 69 - CREATE EXTENSION plperlu fails for user nobody 210s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 210s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 210s ok 72 - creating PL/PerlU function as user nobody fails 210s ok 73 - creating unsafe PL/Perl function as user postgres fails 210s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 210s ok 75 - creating PL/PerlU function as user postgres succeeds 210s ok 76 - psql nobodydb -Atc "select read_file()" 210s ok 77 - calling PL/PerlU function 210s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 210s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 210s ok 80 - creating unsafe PL/Perl function as user nobody fails 210s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 210s ok 82 - creating PL/Perl function as user nobody succeeds 210s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 210s ok 84 - calling PL/Perl function 210s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 210s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 210s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 210s ok 88 - creating PL/Python3 function as user postgres succeeds 210s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 210s ok 90 - calling PL/Python function 210s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 210s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 210s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 210s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 210s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 210s ok 96 - creating PL/Tcl function as user nobody succeeds 211s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 211s ok 98 - creating PL/TclU function as user postgres succeeds 211s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 211s ok 100 - calling PL/Tcl function 211s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 211s ok 102 - calling PL/TclU function 211s ok 103 - stopping cluster 211s ok 104 - pg_ctlcluster 17 main start 211s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 213s ok 106 - pg_ctlcluster 17 main start 213s ok 107 - cluster restarts with pgdata symlink 214s ok 108 - postgres master has OOM killer protection 214s ok 109 - postgres client backend has no OOM adjustment 214s ok 110 - ps h 6976 214s ok 111 - process title is idle 214s ok 112 - ps h 6976 214s ok 113 - process title is idle in transaction 214s ok 114 - stopping cluster 216s ok 115 - starting cluster as postgres works without a log file 216s ok 116 - log file got recreated and used 216s ok 117 - creating a directory in spc2 216s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.StvO4M'" 216s ok 119 - creating tablespace spc1 216s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 216s ok 121 - creating a table in spc1 217s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.fQGMMy'" 217s ok 123 - creating tablespace spc2 217s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 217s ok 125 - creating a table in spc2 217s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 217s ok 127 - Correct apt NeverAutoRemove config 218s ok 128 - pg_dropcluster removes cluster 218s ok 129 - xlog/wal directory /tmp/17.xlog.X3T6EG was deleted 218s ok 130 - tablespace spc1 was emptied 218s ok 131 - tablespace spc2 was emptied 218s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 218s ok 133 - Correct apt NeverAutoRemove config 218s # Cleanup 218s ok 134 - Cleanup: No clusters left behind 218s ok 135 - No postgres processes left behind 218s ok 136 - No files in /etc/postgresql left behind 218s ok 137 - No files in /var/lib/postgresql left behind 218s ok 138 - No files in /var/run/postgresql left behind 218s ok 139 - No files in /var/log/postgresql left behind 218s ok 140 - PostgreSQL TCP ports are closed 218s ok 141 - Next free port is 5432 218s ### End test 020_create_sql_remove.t ### 218s 218s ### PostgreSQL test 021_pg_renamecluster.t ### 218s 1..20 221s ok 1 - pg_createcluster 17 main 224s ok 2 - pg_renamecluster 17 main donau 224s ok 3 - psql -tAc "show data_directory" 224s ok 4 - cluster is running and data_directory was moved 224s ok 5 - pg_hba.conf location updated 224s ok 6 - pg_ident.conf location updated 224s ok 7 - external_pid_file location updated 224s ok 8 - external_pid_file exists 224s ok 9 # skip no stats_temp_directory in 17 224s ok 10 # skip no stats_temp_directory in 17 224s ok 11 - cluster_name is updated 226s ok 12 - pg_dropcluster removes cluster 226s # Cleanup 226s ok 13 - Cleanup: No clusters left behind 226s ok 14 - No postgres processes left behind 226s ok 15 - No files in /etc/postgresql left behind 226s ok 16 - No files in /var/lib/postgresql left behind 226s ok 17 - No files in /var/run/postgresql left behind 226s ok 18 - No files in /var/log/postgresql left behind 226s ok 19 - PostgreSQL TCP ports are closed 226s ok 20 - Next free port is 5432 226s ### End test 021_pg_renamecluster.t ### 226s 226s ### PostgreSQL test 022_recovery.t ### 226s 1..17 226s # Running tests for 17 229s ok 1 - pg_createcluster 17 main --start >/dev/null 229s ok 2 - pg_ctlcluster 17 main stop -m i 231s ok 3 - pg_ctlcluster 17 main start 231s ok 4 - psql -c '' 232s ok 5 - pg_ctlcluster 17 main stop -m i 232s ok 6 - create write-protected file in data directory 234s ok 7 - pg_ctlcluster 17 main start 234s ok 8 - psql -c '' 236s ok 9 - pg_dropcluster removes cluster 236s # Cleanup 236s ok 10 - Cleanup: No clusters left behind 236s ok 11 - No postgres processes left behind 236s ok 12 - No files in /etc/postgresql left behind 236s ok 13 - No files in /var/lib/postgresql left behind 236s ok 14 - No files in /var/run/postgresql left behind 236s ok 15 - No files in /var/log/postgresql left behind 236s ok 16 - PostgreSQL TCP ports are closed 236s ok 17 - Next free port is 5432 236s ### End test 022_recovery.t ### 236s 236s ### PostgreSQL test 025_logging.t ### 236s 1..55 236s # Logging to /var/log/syslog works 236s # Running tests for 17 239s ok 1 - pg_createcluster 17 main 239s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 239s ok 3 - psql -qc "'foobar_17_8203'" 239s ok 4 - log an error 240s ok 5 - grep --binary-files=text foobar_17_8203 /var/log/postgresql/postgresql-17-main.log 240s ok 6 - error appears in logfile 240s ok 7 - pg_conftool 17 main set log_destination syslog 240s ok 8 - set log_destination syslog 240s ok 9 - pg_ctlcluster 17 main reload 240s ok 10 - 17 main reload 240s ok 11 - psql -Atc "show log_destination" 240s ok 12 - log_destination is syslog 240s ok 13 - pg_lscluster reports syslog 241s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 241s ok 15 - error appears in /var/log/syslog 241s ok 16 - pg_conftool 17 main set logging_collector on 241s ok 17 - set logging_collector on 241s ok 18 - pg_conftool 17 main set log_destination csvlog 241s ok 19 - set log_destination csvlog 243s ok 20 - pg_ctlcluster 17 main restart 243s ok 21 - 17 main restart 243s ok 22 - psql -Atc "show logging_collector" 243s ok 23 - logging_collector is on 243s ok 24 - psql -Atc "show log_destination" 243s ok 25 - log_destination is csvlog 243s ok 26 - pg_lscluster reports csvlog 243s ok 27 - psql -qc "'barbaz_17_8203'" 243s ok 28 - log an error 244s ok 29 - grep --binary-files=text barbaz_17_8203 /var/lib/postgresql/17/main/log/*.csv 244s ok 30 - error appears in log/*.csv 244s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 244s ok 32 - set log_destination stderr,syslog,csvlog 244s ok 33 - pg_ctlcluster 17 main reload 244s ok 34 - 17 main reload 244s ok 35 - psql -Atc "show log_destination" 244s ok 36 - log_destination is stderr,syslog,csvlog 244s ok 37 - pg_lscluster reports stderr,syslog,csvlog 244s ok 38 - psql -qc "'moo_17_8203'" 244s ok 39 - log an error 244s ok 40 - grep --binary-files=text moo_17_8203 /var/lib/postgresql/17/main/log/*.log 244s ok 41 - error appears in log/*.log 245s ok 42 - grep --binary-files=text 'postgres.*moo_17_8203' /var/log/syslog 245s ok 43 - error appears in /var/log/syslog 245s ok 44 - grep --binary-files=text moo_17_8203 /var/lib/postgresql/17/main/log/*.csv 245s ok 45 - error appears in log/*.csv 247s ok 46 - pg_dropcluster 17 main --stop 247s ok 47 - pg_dropcluster removes cluster 247s # Cleanup 247s ok 48 - Cleanup: No clusters left behind 247s ok 49 - No postgres processes left behind 247s ok 50 - No files in /etc/postgresql left behind 247s ok 51 - No files in /var/lib/postgresql left behind 247s ok 52 - No files in /var/run/postgresql left behind 247s ok 53 - No files in /var/log/postgresql left behind 247s ok 54 - PostgreSQL TCP ports are closed 247s ok 55 - Next free port is 5432 247s ### End test 025_logging.t ### 247s 247s ### PostgreSQL test 027_jit.t ### 247s # 17 250s ok 1 - pg_createcluster 17 main --start 250s ok 2 - psql -Xatc 'show jit' 250s ok 3 - JIT is on by default 250s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 250s ok 5 - No JIT on cheap query 250s ok 6 - pg_conftool 17 main set seq_page_cost 100000 250s ok 7 - pg_conftool 17 main set random_page_cost 100000 250s ok 8 - pg_ctlcluster 17 main reload 250s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 250s ok 10 - Expensive query is JITed 252s ok 11 - pg_dropcluster --stop 17 main 252s # Cleanup 252s ok 12 - Cleanup: No clusters left behind 252s ok 13 - No postgres processes left behind 252s ok 14 - No files in /etc/postgresql left behind 252s ok 15 - No files in /var/lib/postgresql left behind 252s ok 16 - No files in /var/run/postgresql left behind 252s ok 17 - No files in /var/log/postgresql left behind 252s ok 18 - PostgreSQL TCP ports are closed 252s ok 19 - Next free port is 5432 252s 1..19 252s ### End test 027_jit.t ### 252s 252s ### PostgreSQL test 030_errors.t ### 252s 1..156 252s ok 1 - pg_lscluster reports cluster without binaries 253s ok 2 - pg_dropcluster 6.3 main 254s ok 3 - pg_createcluster --socketdir 254s ok 4 - pg_lsclusters -h 254s ok 5 - cluster was created 254s ok 6 - Port of created cluster is 5432 254s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 254s ok 8 - pg_createcluster on existing cluster 254s ok 9 - pg_lsclusters -h 254s ok 10 - original cluster still exists 254s ok 11 - pg_createcluster 17 test -p foo 254s ok 12 - pg_createcluster -p checks that port option is numeric 254s ok 13 - pg_createcluster 17 test -p 42 254s ok 14 - pg_createcluster -p checks valid port range 254s ok 15 - pg_ctlcluster 17 main start 254s ok 16 - pg_ctlcluster refuses to start root-owned cluster 254s ok 17 - pg_ctlcluster 17 main start 254s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 254s ok 19 - pg_ctlcluster 17 main start 254s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 254s ok 21 - pg_ctlcluster 17 main start 254s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 257s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 257s ok 24 - No sockets in /var/run/postgresql 257s ok 25 - Socket is in /tmp/postgresql-testsuite/ 257s ok 26 - cluster stops with custom unix_socket_dir 257s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 259s ok 28 - cluster starts after removing unix_socket_dir 259s ok 29 - Socket is in default dir /var/run/postgresql 259s ok 30 - No sockets in /tmp/postgresql-testsuite/ 259s ok 31 - pg_ctlcluster 17 main stop 259s ok 32 - pg_ctlcluster fails with corrupted PID file 259s ok 33 - pg_lsclusters -h 259s ok 34 - cluster is still online 259s ok 35 - pg_ctlcluster succeeds with restored PID file 259s ok 36 - pg_lsclusters -h 259s ok 37 - cluster is down 259s ok 38 - pg_ctlcluster 17 main stop 259s ok 39 - pg_ctlcluster stop fails on stopped cluster 262s ok 40 - pg_ctlcluster 17 main start 262s ok 41 - pg_ctlcluster succeeds with already existing PID file 262s ok 42 - pg_lsclusters -h 262s ok 43 - cluster is online 262s ok 44 - pg_ctlcluster stop succeeds 262s ok 45 - pg_lsclusters -h 262s ok 46 - cluster is down 262s ok 47 - no pid file left 262s ok 48 - pg_ctlcluster 17 main stop 262s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 262s ok 50 - pid file was cleaned up 262s ok 51 - pg_ctlcluster --force 17 main stop 262s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 262s ok 53 - pid file was cleaned up 262s ok 54 - pg_ctlcluster 17 main stop 262s ok 55 - pg_ctlcluster stop succeeds with stale PID file 262s ok 56 - pid file was cleaned up 262s ok 57 - pg_ctlcluster --force 17 main stop 262s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 262s ok 59 - pid file was cleaned up 262s ok 60 - pg_ctlcluster --force 17 main stop 262s ok 61 - pg_ctlcluster stop succeeds with empty PID file 262s ok 62 - pid file was cleaned up 264s ok 63 - pg_ctlcluster 17 main start 264s ok 64 - pg_ctlcluster succeeds with corrupted PID file 264s ok 65 - pg_lsclusters -h 264s ok 66 - cluster is online 265s ok 67 - pg_ctlcluster 17 main start 265s ok 68 - pg_ctlcluster start fails on running cluster 265s ok 69 - pg_ctlcluster stop 265s ok 70 - pg_ctlcluster 17 main start 265s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 265s ok 72 - pg_ctlcluster 17 main stop 265s ok 73 - stopping cluster 271s ok 74 - pg_ctlcluster 17 main start 271s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 271s ok 76 - pg_ctlcluster 17 main stop 271s ok 77 - stopping cluster 271s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 271s ok 79 - pg_dropcluster 17 main 271s ok 80 - pg_dropcluster works as user postgres 272s ok 81 - pg_createcluster succeeds 272s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 272s ok 83 - proper error message for nonexisting /var/lib/postgresql 275s ok 84 - pg_ctlcluster 17 main start 275s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 275s ok 86 - pg_ctlcluster 17 main stop 275s ok 87 - stopping cluster 276s ok 88 - pg_createcluster other 278s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 280s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 280s ok 91 280s ok 92 - pg_ctlcluster 17 other start 280s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 280s ok 94 - pg_ctlcluster 17 main stop 280s ok 95 - stopping main cluster 283s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 284s ok 97 - pg_dropcluster other 286s ok 98 - pg_dropcluster 286s ok 99 - No sockets any more 286s ok 100 - 'pg_lsclusters 4.5 foo' fails 286s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 286s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 286s ok 103 - 'psql --cluster 4.5/foo' fails 286s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 286s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 286s ok 106 - 'psql --cluster 17/foo' fails 286s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 286s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 286s ok 109 - 'pg_dropcluster 4.5 foo' fails 286s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 286s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 286s ok 112 - 'pg_dropcluster 17 foo' fails 286s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 286s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 286s ok 115 - 'pg_upgradecluster 4.5 foo' fails 286s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 286s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 286s ok 118 - 'pg_upgradecluster 17 foo' fails 286s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 286s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 286s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 286s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 286s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 286s ok 124 - 'pg_ctlcluster 17 foo stop' fails 286s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 286s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 286s # Cleanup 286s ok 127 - Cleanup: No clusters left behind 286s ok 128 - No postgres processes left behind 286s ok 129 - No files in /etc/postgresql left behind 286s ok 130 - No files in /var/lib/postgresql left behind 286s ok 131 - No files in /var/run/postgresql left behind 286s ok 132 - No files in /var/log/postgresql left behind 286s ok 133 - PostgreSQL TCP ports are closed 286s ok 134 - Next free port is 5432 287s ok 135 - pg_dropcluster 17 broken 287s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 287s # Cleanup 287s ok 137 - Cleanup: No clusters left behind 287s ok 138 - No postgres processes left behind 287s ok 139 - No files in /etc/postgresql left behind 287s ok 140 - No files in /var/lib/postgresql left behind 287s ok 141 - No files in /var/run/postgresql left behind 287s ok 142 - No files in /var/log/postgresql left behind 287s ok 143 - PostgreSQL TCP ports are closed 287s ok 144 - Next free port is 5432 288s ok 145 - pg_dropcluster 17 broken 288s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 288s ok 147 - /etc/postgresql/17 was removed 288s ok 148 - /var/lib/postgresql/17 was removed 288s # Cleanup 288s ok 149 - Cleanup: No clusters left behind 288s ok 150 - No postgres processes left behind 288s ok 151 - No files in /etc/postgresql left behind 288s ok 152 - No files in /var/lib/postgresql left behind 288s ok 153 - No files in /var/run/postgresql left behind 288s ok 154 - No files in /var/log/postgresql left behind 288s ok 155 - PostgreSQL TCP ports are closed 288s ok 156 - Next free port is 5432 288s ### End test 030_errors.t ### 288s 288s ### PostgreSQL test 031_errors_disk_full.t ### 289s 1..22 289s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 290s ok 1 - script failed 290s ok 2 - pg_createcluster fails due to insufficient disk space 290s ok 3 - does not leave files behind 290s # Cleanup 290s ok 4 - Cleanup: No clusters left behind 290s ok 5 - No postgres processes left behind 290s ok 6 - No files in /etc/postgresql left behind 290s ok 7 - No files in /var/lib/postgresql left behind 290s ok 8 - No files in /var/run/postgresql left behind 290s ok 9 - No files in /var/log/postgresql left behind 290s ok 10 - PostgreSQL TCP ports are closed 290s ok 11 - Next free port is 5432 290s # check disk full conditions on startup 292s ok 12 - script failed 292s ok 13 - pg_ctlcluster prints error message 292s ok 14 - log file has error message 292s # Cleanup 292s ok 15 - Cleanup: No clusters left behind 292s ok 16 - No postgres processes left behind 292s ok 17 - No files in /etc/postgresql left behind 292s ok 18 - No files in /var/lib/postgresql left behind 292s ok 19 - No files in /var/run/postgresql left behind 292s ok 20 - No files in /var/log/postgresql left behind 292s ok 21 - PostgreSQL TCP ports are closed 292s ok 22 - Next free port is 5432 292s ### End test 031_errors_disk_full.t ### 292s 292s ### PostgreSQL test 032_ssl_key_permissions.t ### 292s 1..22 292s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 292s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 292s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 293s ok 4 - pg_createcluster 17 main 294s ok 5 - pg_ctlcluster 17 main start 294s ok 6 - ssl key owned by nobody refused 294s ok 7 - pg_ctlcluster 17 main start 294s ok 8 - ssl key with permissions root:root 0644 refused 294s ok 9 - pg_ctlcluster 17 main start 294s ok 10 - ssl key with permissions postgres:postgres 0640 refused 295s ok 11 - pg_dropcluster 17 main --stop 295s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 295s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 295s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 295s # Cleanup 295s ok 15 - Cleanup: No clusters left behind 295s ok 16 - No postgres processes left behind 295s ok 17 - No files in /etc/postgresql left behind 295s ok 18 - No files in /var/lib/postgresql left behind 295s ok 19 - No files in /var/run/postgresql left behind 295s ok 20 - No files in /var/log/postgresql left behind 295s ok 21 - PostgreSQL TCP ports are closed 295s ok 22 - Next free port is 5432 295s ### End test 032_ssl_key_permissions.t ### 295s 295s ### PostgreSQL test 040_upgrade.t ### 295s 1..1 295s ok 1 - only one major version installed, skipping upgrade tests 295s ### End test 040_upgrade.t ### 295s 295s ### PostgreSQL test 041_upgrade_custompaths.t ### 295s 1..1 295s ok 1 - only one major version installed, skipping upgrade tests 295s ### End test 041_upgrade_custompaths.t ### 295s 295s ### PostgreSQL test 042_upgrade_rename.t ### 296s 1..15 296s # PostgreSQL 17 299s ok 1 - pg_createcluster 17 main --start 305s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 305s ok 3 - pg_lsclusters -h 305s ok 4 - correct output of pg_lsclusters -h 306s ok 5 - pg_dropcluster 17 main --stop 308s ok 6 - pg_dropcluster 17 upgr --stop 308s ok 7 - Cleaning pg_upgrade log files 308s # Cleanup 308s ok 8 - Cleanup: No clusters left behind 308s ok 9 - No postgres processes left behind 308s ok 10 - No files in /etc/postgresql left behind 308s ok 11 - No files in /var/lib/postgresql left behind 308s ok 12 - No files in /var/run/postgresql left behind 308s ok 13 - No files in /var/log/postgresql left behind 308s ok 14 - PostgreSQL TCP ports are closed 308s ok 15 - Next free port is 5432 308s ### End test 042_upgrade_rename.t ### 308s 308s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 308s 1..1 308s ok 1 - only one major version installed, skipping upgrade tests 308s ### End test 043_upgrade_ssl_cert.t ### 308s 308s ### PostgreSQL test 045_backup.t ### 308s # We are running systemd 308s # PostgreSQL 17 308s # create cluster 311s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 311s ok 2 - pg_lsclusters -h 311s ok 3 - correct output of pg_lsclusters -h 311s ok 4 - pg_conftool 17 main set work_mem 11MB 311s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 311s ok 6 - psql -c 'alter database mydb set search_path=public' 311s ok 7 - psql -c 'create table foo (t text)' mydb 311s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 311s ok 9 - psql -c 'CREATE USER myuser' 311s ok 10 - psql -c 'grant create on database mydb to myuser' 312s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 312s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 312s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 312s # create directory 312s ok 14 - pg_backupcluster 17 main createdirectory 312s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 312s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 312s # dump 312s ok 17 - systemctl start pg_dump@17-main 312s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-06T184156Z.dump 312s ok 19 - /var/backups/postgresql/17-main/2025-05-06T184156Z.dump owned by uid postgres 312s ok 20 - /var/backups/postgresql/17-main/2025-05-06T184156Z.dump owned by gid postgres 312s # basebackup 312s ok 21 - systemctl start pg_receivewal@17-main 312s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 313s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 313s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 313s ok 25 - psql -c 'select pg_reload_conf()' 341s ok 26 - systemctl start pg_basebackup@17-main 341s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-06T184158Z.backup 341s ok 28 - /var/backups/postgresql/17-main/2025-05-06T184158Z.backup owned by uid postgres 341s ok 29 - /var/backups/postgresql/17-main/2025-05-06T184158Z.backup owned by gid postgres 341s # list 341s ok 30 - pg_backupcluster 17 main list 341s ok 31 - correct output of pg_backupcluster 17 main list 341s # more database changes 341s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 341s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 341s ok 34 - retrieve recovery timestamp 341s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 342s ok 36 - systemctl stop pg_receivewal@17-main 342s # restore /var/backups/postgresql/17-main/2025-05-06T184156Z.dump 343s ok 37 - pg_dropcluster 17 main --stop 347s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184156Z.dump --start --datadir /var/lib/postgresql/17/snowflake 347s ok 39 - pg_lsclusters -h 347s ok 40 - correct output of pg_lsclusters -h 347s ok 41 - psql -XAtl 347s ok 42 - mydb locales 347s ok 43 - mydb grants 347s ok 44 - myicudb locales 348s ok 45 - psql -XAtc 'show work_mem' 348s ok 46 - correct output of psql -XAtc 'show work_mem' 348s ok 47 - psql -XAtc 'select * from foo' mydb 348s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 348s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 348s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 348s ok 51 - psql -XAtc '\drds' 348s ok 52 - correct output of psql -XAtc '\drds' 348s # restore /var/backups/postgresql/17-main/2025-05-06T184158Z.backup 349s ok 53 - pg_dropcluster 17 main --stop 353s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184158Z.backup --start --datadir /var/lib/postgresql/17/snowflake 353s ok 55 - pg_lsclusters -h 353s ok 56 - correct output of pg_lsclusters -h 353s ok 57 - psql -XAtl 353s ok 58 - mydb locales 353s ok 59 - mydb grants 353s ok 60 - myicudb locales 353s ok 61 - psql -XAtc 'show work_mem' 353s ok 62 - correct output of psql -XAtc 'show work_mem' 353s ok 63 - psql -XAtc 'select * from foo' mydb 353s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 353s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 353s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 353s ok 67 - psql -XAtc '\drds' 353s ok 68 - correct output of psql -XAtc '\drds' 353s # restore /var/backups/postgresql/17-main/2025-05-06T184158Z.backup with WAL archive 354s ok 69 - pg_dropcluster 17 main --stop 358s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184158Z.backup --start --archive --port 5430 358s ok 71 - pg_lsclusters -h 358s ok 72 - correct output of pg_lsclusters -h 358s ok 73 - psql -XAtc 'select * from foo order by t' mydb 358s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 358s # restore /var/backups/postgresql/17-main/2025-05-06T184158Z.backup with PITR 360s ok 75 - pg_dropcluster 17 main --stop 363s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184158Z.backup --start --pitr '2025-05-06 18:42:26.198297+00 363s # ' 363s ok 77 - pg_lsclusters -h 363s ok 78 - correct output of pg_lsclusters -h 363s ok 79 - psql -XAtc 'select * from foo order by t' mydb 363s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 365s ok 81 - pg_dropcluster 17 main --stop 365s # Cleanup 365s ok 82 - Cleanup: No clusters left behind 365s ok 83 - No postgres processes left behind 365s ok 84 - No files in /etc/postgresql left behind 365s ok 85 - No files in /var/lib/postgresql left behind 365s ok 86 - No files in /var/run/postgresql left behind 365s ok 87 - No files in /var/log/postgresql left behind 365s ok 88 - PostgreSQL TCP ports are closed 365s ok 89 - Next free port is 5432 365s 1..89 365s ### End test 045_backup.t ### 365s 365s ### PostgreSQL test 050_encodings.t ### 365s 1..60 365s # Checking 17 ru_RU 368s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 369s ok 2 - psql -l succeeds 369s ok 3 - template1 is not UTF-8 encoded 369s ok 4 - creating test database 369s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 369s # create table t (x varchar); copy t from stdin" test 369s ok 6 - creating table with ISO-8859-5 characters 370s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 370s ok 8 - correct string in UTF-8 370s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 370s ok 10 - correct string in ISO-8859-5 370s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 370s # delete from t; copy t from stdin" test 370s ok 12 - creating table with UTF-8 characters 370s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 370s ok 14 - correct string in UTF-8 370s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 370s ok 16 - correct string in ISO-8859-1 370s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 370s ok 18 - Server error message has correct language and encoding 372s ok 19 - pg_ctlcluster 17 ru_RU restart 372s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 374s ok 21 - Dropping cluster 374s # Checking 17 ru_RU.UTF-8 377s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 378s ok 23 - psql -l succeeds 378s ok 24 - template1 is UTF-8 encoded 378s ok 25 - creating test database 378s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 378s # create table t (x varchar); copy t from stdin" test 378s ok 27 - creating table with ISO-8859-5 characters 378s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 378s ok 29 - correct string in UTF-8 378s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 378s ok 31 - correct string in ISO-8859-5 378s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 378s # delete from t; copy t from stdin" test 378s ok 33 - creating table with UTF-8 characters 378s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 378s ok 35 - correct string in UTF-8 378s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 378s ok 37 - correct string in ISO-8859-1 378s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 378s ok 39 - Server error message has correct language and encoding 381s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 381s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 381s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 381s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 381s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 381s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 381s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 381s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 383s ok 48 - Dropping cluster 383s # Check 17 locale environment variables 386s ok 49 - pg_createcluster: LC_ALL dominates LANG 386s ok 50 - psql -Atl --cluster 17/main 386s ok 51 - template1 is ASCII encoded 387s ok 52 - Dropping cluster 387s # Cleanup 387s ok 53 - Cleanup: No clusters left behind 387s ok 54 - No postgres processes left behind 387s ok 55 - No files in /etc/postgresql left behind 387s ok 56 - No files in /var/lib/postgresql left behind 387s ok 57 - No files in /var/run/postgresql left behind 387s ok 58 - No files in /var/log/postgresql left behind 387s ok 59 - PostgreSQL TCP ports are closed 387s ok 60 - Next free port is 5432 387s ### End test 050_encodings.t ### 387s 387s ### PostgreSQL test 052_upgrade_encodings.t ### 388s 1..1 388s ok 1 - only one major version installed, skipping upgrade tests 388s ### End test 052_upgrade_encodings.t ### 388s 388s ### PostgreSQL test 060_obsolete_confparams.t ### 388s ok 1 - only one major version installed, skipping upgrade tests 388s 1..1 388s ### End test 060_obsolete_confparams.t ### 388s 388s ### PostgreSQL test 070_non_postgres_clusters.t ### 388s 1..40 389s ok 1 - pg_createcluster 17 main for owner nobody 389s ok 2 - pg_ctlcluster 17 main start 389s ok 3 - start refused when config and data owners mismatch 391s ok 4 - pg_ctlcluster succeeds with owner nobody 391s ok 5 - pg_lsclusters -h 391s ok 6 - pg_lsclusters shows running cluster 391s ok 7 - postgres is running as user nobody 391s ok 8 - ls /tmp/.s.PGSQL.* 391s ok 9 - socket is in /tmp 391s ok 10 - /var/run/postgresql is empty 391s ok 11 - conf dir is owned by user 391s ok 12 - conf dir is owned by user's primary group 391s ok 13 - files are owned by user 391s ok 14 - files are owned by user's primary group 391s ok 15 - log file has 0640 permissions 391s ok 16 - log file is owned by user 391s ok 17 - log file is owned by user's primary group 391s ok 18 - only one major version installed, skipping upgrade test 391s ok 19 - ... 391s ok 20 - ... 391s ok 21 - ... 391s ok 22 - ... 391s ok 23 - ... 391s ok 24 - ... 391s ok 25 - ... 391s ok 26 - ... 391s ok 27 - ... 391s ok 28 - ... 392s ok 29 - pg_dropcluster 392s ok 30 - pg_lsclusters -h 392s ok 31 - No clusters left 392s ok 32 - No postgres processes left 392s # Cleanup 392s ok 33 - Cleanup: No clusters left behind 393s ok 34 - No postgres processes left behind 393s ok 35 - No files in /etc/postgresql left behind 393s ok 36 - No files in /var/lib/postgresql left behind 393s ok 37 - No files in /var/run/postgresql left behind 393s ok 38 - No files in /var/log/postgresql left behind 393s ok 39 - PostgreSQL TCP ports are closed 393s ok 40 - Next free port is 5432 393s ### End test 070_non_postgres_clusters.t ### 393s 393s ### PostgreSQL test 080_start.conf.t ### 393s 1..73 394s ok 1 - pg_createcluster 17 main 394s # start.conf auto 394s ok 2 - get_cluster_start_conf returns auto 394s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 394s ok 4 - start.conf contains auto 394s ok 5 - systemd generator links cluster 394s ok 6 - systemd generator links correct service file 396s ok 7 - /etc/init.d/postgresql start 17 396s ok 8 - correct output of /etc/init.d/postgresql start 17 396s ok 9 - pg_lsclusters -h 396s ok 10 - cluster is online 396s ok 11 - /etc/init.d/postgresql stop 17 396s ok 12 - correct output of /etc/init.d/postgresql stop 17 399s ok 13 - pg_lsclusters -h 399s ok 14 - cluster is down 399s # start.conf manual 399s ok 15 - get_cluster_start_conf returns manual 399s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 399s ok 17 - start.conf contains manual 399s ok 18 - systemd generator doesn't link cluster 399s ok 19 - /etc/init.d/postgresql start 17 399s ok 20 - correct output of /etc/init.d/postgresql start 17 399s ok 21 - pg_lsclusters -h 399s ok 22 - cluster is down 402s ok 23 - pg_ctlcluster 17 main start 402s ok 24 - correct output of pg_ctlcluster 17 main start 402s ok 25 - pg_lsclusters -h 402s ok 26 - cluster is online 402s ok 27 - pg_ctlcluster 17 main stop 402s ok 28 - correct output of pg_ctlcluster 17 main stop 402s ok 29 - pg_lsclusters -h 402s ok 30 - cluster is down 402s # start.conf disabled 402s ok 31 - get_cluster_start_conf returns disabled 402s ok 32 - systemd generator doesn't link cluster 402s ok 33 - /etc/init.d/postgresql start 17 402s ok 34 - correct output of /etc/init.d/postgresql start 17 402s ok 35 - pg_lsclusters -h 402s ok 36 - cluster is down 402s ok 37 - pg_ctlcluster 17 main start 402s ok 38 - correct output of pg_ctlcluster 17 main start 402s ok 39 - pg_lsclusters -h 402s ok 40 - cluster is down 404s ok 41 - pg_ctlcluster 17 main start 404s ok 42 - correct output of pg_ctlcluster 17 main start 404s ok 43 - pg_lsclusters -h 404s ok 44 - cluster is online 405s ok 45 - pg_ctlcluster 17 main stop 405s ok 46 - correct output of pg_ctlcluster 17 main stop 405s ok 47 - pg_lsclusters -h 405s ok 48 - cluster is down 407s ok 49 - pg_ctlcluster 17 main start 407s ok 50 - correct output of pg_ctlcluster 17 main start 407s ok 51 - pg_lsclusters -h 407s ok 52 - cluster is online 407s # test upgrade 407s ok 53 - only one major version installed, skipping upgrade test 407s ok 54 - ... 407s ok 55 - get_cluster_start_conf for old cluster returns manual 407s ok 56 - get_cluster_start_conf for new cluster returns manual 407s ok 57 - ... 408s ok 58 - dropping upgraded cluster 408s ok 59 - pg_lsclusters -h 408s ok 60 - no clusters any more 408s ok 61 - pg_createcluster 17 main --start-conf foo 408s ok 62 - pg_createcluster checks --start-conf validity 409s ok 63 - pg_createcluster checks --start-conf manual 409s ok 64 - get_cluster_start_conf returns manual 410s ok 65 - dropping cluster 410s # Cleanup 410s ok 66 - Cleanup: No clusters left behind 410s ok 67 - No postgres processes left behind 410s ok 68 - No files in /etc/postgresql left behind 410s ok 69 - No files in /var/lib/postgresql left behind 410s ok 70 - No files in /var/run/postgresql left behind 410s ok 71 - No files in /var/log/postgresql left behind 410s ok 72 - PostgreSQL TCP ports are closed 410s ok 73 - Next free port is 5432 410s ### End test 080_start.conf.t ### 410s 410s ### PostgreSQL test 085_pg_ctl.conf.t ### 410s 1..33 410s ok 1 - prlimit --core=0:unlimited --pid=17002 410s ok 2 - set core file size to unlimited 410s ok 3 - sh -c 'ulimit -Hc' 410s ok 4 - core file size is unlimited 411s ok 5 - pg_createcluster 17 main 411s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 413s ok 7 - pg_ctlcluster 17 main start 413s ok 8 - starting cluster as root 413s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 413s ok 10 - soft core size is 0 413s # hard core file size limit of root-started postgres process is unlimited 413s ok 11 - set pg_ctl default option to -c 416s ok 12 - pg_ctlcluster 17 main restart 416s ok 13 - restarting cluster as root 416s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 416s ok 15 - soft core size is unlimited 416s ok 16 - pg_ctlcluster 17 main stop 416s ok 17 - stopping cluster 416s ok 18 - restored pg_ctl default option 418s ok 19 - pg_ctlcluster 17 main start -- -c 418s ok 20 - starting cluster with -c on the command line as postgres 418s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 418s ok 22 - soft core size is unlimited 418s ok 23 - pg_ctlcluster 17 main stop 418s ok 24 - stopping cluster 420s ok 25 - dropping cluster 420s # Cleanup 420s ok 26 - Cleanup: No clusters left behind 420s ok 27 - No postgres processes left behind 420s ok 28 - No files in /etc/postgresql left behind 420s ok 29 - No files in /var/lib/postgresql left behind 420s ok 30 - No files in /var/run/postgresql left behind 420s ok 31 - No files in /var/log/postgresql left behind 420s ok 32 - PostgreSQL TCP ports are closed 420s ok 33 - Next free port is 5432 420s ### End test 085_pg_ctl.conf.t ### 420s 420s ### PostgreSQL test 090_multicluster.t ### 420s 1..125 421s ok 1 - pg_createcluster 17 old 422s ok 2 - pg_createcluster 17 new1 423s ok 3 - pg_createcluster 17 new2 425s ok 4 - starting cluster 17/old 427s ok 5 - starting cluster 17/new1 430s ok 6 - starting cluster 17/new2 430s ok 7 - pg_lsclusters -h | sort -k3 430s ok 8 - clusters have the correct ports, skipping used 5433 430s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 430s ok 10 - createdb --version 430s ok 11 - pg_wrapper selects port 5432 as default cluster 430s ok 12 - createdb --cluster 17/new1 --version 430s ok 13 - pg_wrapper --cluster works 430s ok 14 - createdb --cluster 17/foo --version 430s ok 15 - pg_wrapper --cluster errors out for invalid cluster 430s ok 16 - createdb --cluster 17/new1 test 430s ok 17 - correct output of createdb --cluster 17/new1 test 430s ok 18 - psql -Atl --cluster 17/new1 430s ok 19 - test db appears in cluster new1 430s ok 20 - psql -Atl --cluster 17/new2 430s ok 21 - test db does not appear in cluster new2 430s ok 22 - psql -Atl 430s ok 23 - test db does not appear in default cluster 430s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 430s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 430s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 430s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 430s ok 28 - psql -Atl --cluster 17/localhost:5434 430s ok 29 - test db appears in cluster 17/localhost:5434 430s ok 30 - psql -Atl --cluster 17/localhost:5440 430s ok 31 - test db does not appear in cluster 17/localhost:5440 430s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 430s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 430s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 430s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 430s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 430s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 430s ok 38 - psql -Atl --cluster 6.4/localhost: 430s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 430s ok 40 - psql -Atl 430s ok 41 - PGCLUSTER selection (1) 431s ok 42 - psql -Atl 431s ok 43 - PGCLUSTER selection (2) 431s ok 44 - psql -l 431s ok 45 - invalid PGCLUSTER value 431s ok 46 - createdb --version 431s ok 47 - PGCLUSTER network cluster selection (1) 431s ok 48 - psql -Atl 431s ok 49 - PGCLUSTER network cluster selection (2) 431s ok 50 - psql -Atl 431s ok 51 - PGCLUSTER network cluster selection (3) 431s ok 52 - LC_MESSAGES=C psql -Atl 431s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 431s ok 54 - psql -Atc "show port" template1 431s ok 55 - PGPORT selection (1) 431s ok 56 - psql -Atc "show port" template1 431s ok 57 - PGPORT selection (2) 431s ok 58 - createdb --version 431s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 431s ok 60 - psql -Atc "show port" template1 431s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 431s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 431s ok 63 - PGDATABASE environment variable works 431s ok 64 - createdb --version 431s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 431s ok 66 - createdb --cluster 17/new1 --version 431s ok 67 - pg_wrapper --cluster works with empty user_clusters 431s ok 68 - createdb --version 431s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 431s ok 70 - psql -Atc "select current_database()" 431s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 431s ok 72 - psql -Atc 'select current_database()' 431s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 431s ok 74 - createdb --version 431s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 431s ok 76 - createdb --version 431s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 431s ok 78 - createdb --version 431s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 431s ok 80 - createdb --version 431s ok 81 - pg_wrapper selects correct version with per-user user_clusters 431s ok 82 - createdb --version 431s ok 83 - pg_wrapper selects correct version with per-user user_clusters 431s ok 84 - createdb --version 431s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 431s ok 86 - psql -Atl 431s ok 87 - $PGHOST overrides user_clusters 431s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 431s ok 89 - --cluster overrides $PGHOST 431s ok 90 - createdb --version 431s ok 91 - pg_wrapper ignores invalid lines in user_clusters 431s ok 92 - psql -Atc 'select current_database()' 431s ok 93 - pg_service conf selection 1 432s ok 94 - psql -Atc 'select current_database()' 432s ok 95 - pg_service conf selection 2 432s ok 96 - psql -Atc 'select current_database()' 432s ok 97 - pg_service conf selection 3 432s ok 98 - stopping cluster 17/old 434s ok 99 - restarting cluster 17/old 434s ok 100 - pg_lsclusters -h | sort -k3 434s ok 101 - port of first cluster was successfully changed 434s ok 102 - psql -l 434s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 434s ok 104 - psql -Atl --cluster 17/new1 434s ok 105 - --cluster selects appropriate cluster 434s ok 106 - psql -Atl -p 5434 434s ok 107 - -p selects appropriate cluster 434s ok 108 - psql -Atlp 5434 434s ok 109 - -Atlp selects appropriate cluster 434s ok 110 - psql -Atl --port 5434 434s ok 111 - --port selects appropriate cluster 434s ok 112 - env PGPORT=5434 psql -Atl 434s ok 113 - $PGPORT selects appropriate cluster 434s ok 114 - Restoring original /etc/postgresql-common/user_clusters 436s ok 115 - dropping 17/new1 438s ok 116 - dropping 17/new2 439s ok 117 - dropping 17/old 439s # Cleanup 439s ok 118 - Cleanup: No clusters left behind 439s ok 119 - No postgres processes left behind 439s ok 120 - No files in /etc/postgresql left behind 439s ok 121 - No files in /var/lib/postgresql left behind 439s ok 122 - No files in /var/run/postgresql left behind 439s ok 123 - No files in /var/log/postgresql left behind 439s ok 124 - PostgreSQL TCP ports are closed 439s ok 125 - Next free port is 5432 439s ### End test 090_multicluster.t ### 439s 439s ### PostgreSQL test 110_integrate_cluster.t ### 439s 1..32 440s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/1N2Y9LrOeL/c/postgres 440s ok 2 - creating raw initdb cluster for user postgres 440s ok 3 - pg_createcluster 17 postgres -d /tmp/1N2Y9LrOeL/c/postgres 440s ok 4 - integrating postgres cluster 440s ok 5 - pg_lsclusters 440s ok 6 - correct pg_lsclusters output 443s ok 7 - pg_ctlcluster 17 postgres start 443s ok 8 - starting cluster postgres 443s ok 9 - pg_lsclusters 443s ok 10 - correct pg_lsclusters output 444s ok 11 - dropping cluster postgres 444s ok 12 - No files in temporary cluster dir left behind 445s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/1N2Y9LrOeL/c/nobody 445s ok 14 - creating raw initdb cluster for user nobody 445s ok 15 - pg_createcluster 17 nobody -d /tmp/1N2Y9LrOeL/c/nobody 445s ok 16 - integrating nobody cluster 445s ok 17 - pg_lsclusters 445s ok 18 - correct pg_lsclusters output 447s ok 19 - pg_ctlcluster 17 nobody start 447s ok 20 - starting cluster nobody 448s ok 21 - pg_lsclusters 448s ok 22 - correct pg_lsclusters output 449s ok 23 - dropping cluster nobody 449s ok 24 - No files in temporary cluster dir left behind 449s # Cleanup 449s ok 25 - Cleanup: No clusters left behind 449s ok 26 - No postgres processes left behind 449s ok 27 - No files in /etc/postgresql left behind 449s ok 28 - No files in /var/lib/postgresql left behind 449s ok 29 - No files in /var/run/postgresql left behind 449s ok 30 - No files in /var/log/postgresql left behind 449s ok 31 - PostgreSQL TCP ports are closed 449s ok 32 - Next free port is 5432 449s ### End test 110_integrate_cluster.t ### 449s 449s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 449s 1..1 449s ok 1 - only one major version installed, skipping upgrade tests 449s ### End test 120_pg_upgradecluster_scripts.t ### 449s 449s ### PostgreSQL test 130_nonroot_admin.t ### 449s 1..22 452s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 452s ok 2 - pg_lsclusters -h 452s ok 3 - correct output of pg_lsclusters -h 452s ok 4 - psql -Atl 452s ok 5 - correct output of psql -Atl 452s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 452s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 452s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 452s # Cleanup 452s ok 15 - Cleanup: No clusters left behind 452s ok 16 - No postgres processes left behind 452s ok 17 - No files in /etc/postgresql left behind 452s ok 18 - No files in /var/lib/postgresql left behind 452s ok 19 - No files in /var/run/postgresql left behind 452s ok 20 - No files in /var/log/postgresql left behind 452s ok 21 - PostgreSQL TCP ports are closed 452s ok 22 - Next free port is 5432 452s ### End test 130_nonroot_admin.t ### 452s 452s ### PostgreSQL test 135_pg_virtualenv.t ### 452s 1..20 457s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 457s ok 2 - running pg_virtualenv as root 460s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 460s ok 4 - running pg_virtualenv as postgres 463s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 463s ok 6 - running pg_virtualenv as nobody 467s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 467s ok 8 - running fakeroot pg_virtualenv as root 470s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 470s ok 10 - running fakeroot pg_virtualenv as postgres 473s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 473s ok 12 - running fakeroot pg_virtualenv as nobody 473s # Cleanup 473s ok 13 - Cleanup: No clusters left behind 473s ok 14 - No postgres processes left behind 473s ok 15 - No files in /etc/postgresql left behind 473s ok 16 - No files in /var/lib/postgresql left behind 473s ok 17 - No files in /var/run/postgresql left behind 473s ok 18 - No files in /var/log/postgresql left behind 473s ok 19 - PostgreSQL TCP ports are closed 473s ok 20 - Next free port is 5432 473s ### End test 135_pg_virtualenv.t ### 473s 473s ### PostgreSQL test 140_pg_config.t ### 473s 1..38 473s # Multiarch is enabled 473s # checking version specific output for 17 473s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 473s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 473s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 473s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 473s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 473s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 473s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 473s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 473s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 473s # checking pg_config output (should behave like version 17) 473s ok 15 - pg_config 473s ok 16 - correct output of pg_config 473s ok 17 - pg_config --help 473s ok 18 - correct output of pg_config --help 473s ok 19 - pg_config --pgxs 473s ok 20 - correct output of pg_config --pgxs 473s ok 21 - pg_config --libdir 473s ok 22 - correct output of pg_config --libdir 473s ok 23 - pg_config --pkglibdir 473s ok 24 - correct output of pg_config --pkglibdir 473s ok 25 - pg_config --bindir 473s ok 26 - correct output of pg_config --bindir 473s # checking pg_config.libpq-dev output (should behave like version 17) 473s ok 27 - pg_config.libpq-dev 473s ok 28 - correct output of pg_config.libpq-dev 473s ok 29 - pg_config.libpq-dev --help 473s ok 30 - correct output of pg_config.libpq-dev --help 473s ok 31 - pg_config.libpq-dev --pgxs 473s ok 32 - correct output of pg_config.libpq-dev --pgxs 473s ok 33 - pg_config.libpq-dev --libdir 473s ok 34 - correct output of pg_config.libpq-dev --libdir 473s ok 35 - pg_config.libpq-dev --pkglibdir 473s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 473s ok 37 - pg_config.libpq-dev --bindir 473s ok 38 - correct output of pg_config.libpq-dev --bindir 473s ### End test 140_pg_config.t ### 473s 473s ### PostgreSQL test 150_tsearch_stemming.t ### 473s 1..37 473s ok 1 - pg_updatedicts succeeded 473s ok 2 - pg_updatedicts created en_us.affix 473s ok 3 - pg_updatedicts created en_us.dict 473s ok 4 - pg_updatedicts created 17 en_us.affix symlink 473s ok 5 - pg_updatedicts created 17 en_us.dict symlink 476s ok 6 - pg_createcluster 17 main 477s ok 7 - createdb fts 477s ok 8 - correct output of createdb fts 477s ok 9 - creating en_US full text search configuration 477s ok 10 - creating data table and search index 477s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 477s ok 12 - stem search of correct word 477s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 477s ok 14 - stem search of correct word 477s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 477s ok 16 - stem search of unknown word 477s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 477s ok 18 - full text search, exact word 477s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 477s ok 20 - full text search for word stem 477s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 477s ok 22 - full text search for word substring fails 477s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 477s ok 24 - full text search, exact unicode word 477s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 477s ok 26 - full text search for unicode word stem 477s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 477s ok 28 - full text search for unicode word substring fails 479s ok 29 479s # Cleanup 479s ok 30 - Cleanup: No clusters left behind 479s ok 31 - No postgres processes left behind 479s ok 32 - No files in /etc/postgresql left behind 479s ok 33 - No files in /var/lib/postgresql left behind 479s ok 34 - No files in /var/run/postgresql left behind 479s ok 35 - No files in /var/log/postgresql left behind 479s ok 36 - PostgreSQL TCP ports are closed 479s ok 37 - Next free port is 5432 479s ### End test 150_tsearch_stemming.t ### 479s 479s ### PostgreSQL test 160_alternate_confroot.t ### 479s 1..28 482s ok 1 482s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 482s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 482s ok 4 - pg_lsclusters -h 482s ok 5 - correct output of pg_lsclusters -h 482s ok 6 - psql -Atl 482s ok 7 - correct output of psql -Atl 482s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 482s ok 9 - ... 482s ok 10 - ... 482s ok 11 - ... 482s ok 12 - ... 482s ok 13 - ... 482s ok 14 - ... 482s ok 15 - pg_dropcluster 17 test --stop 482s ok 16 - correct output of pg_dropcluster 17 test --stop 482s ok 17 - pg_lsclusters -h 482s ok 18 - correct output of pg_lsclusters -h 482s ok 19 - No files in root/data left behind 482s ok 20 - No cruft in root dir left behind 482s # Cleanup 482s ok 21 - Cleanup: No clusters left behind 482s ok 22 - No postgres processes left behind 482s ok 23 - No files in /etc/postgresql left behind 482s ok 24 - No files in /var/lib/postgresql left behind 482s ok 25 - No files in /var/run/postgresql left behind 482s ok 26 - No files in /var/log/postgresql left behind 482s ok 27 - PostgreSQL TCP ports are closed 482s ok 28 - Next free port is 5432 482s ### End test 160_alternate_confroot.t ### 482s 482s ### PostgreSQL test 170_extensions.t ### 482s # Running tests for 17 486s ok 1 - pg_createcluster 17 main 486s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 486s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 486s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 486s ok 5 - extension amcheck installs without error 486s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 486s ok 7 - extension amcheck removes without error 486s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 486s ok 9 - extension autoinc installs without error 486s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 486s ok 11 - extension autoinc removes without error 486s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 486s ok 13 - extension bloom installs without error 486s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 486s ok 15 - extension bloom removes without error 486s ok 16 - psql -qc 'CREATE EXTENSION plperl' 486s ok 17 - bool_plperl dependency plperl installs without error 486s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 486s ok 19 - extension bool_plperl installs without error 486s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 486s ok 21 - extension bool_plperl removes without error 486s ok 22 - psql -qc 'DROP EXTENSION plperl' 486s ok 23 - bool_plperl dependency extension plperl removes without error 486s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 486s ok 25 - bool_plperlu dependency plperlu installs without error 486s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 486s ok 27 - extension bool_plperlu installs without error 486s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 486s ok 29 - extension bool_plperlu removes without error 486s ok 30 - psql -qc 'DROP EXTENSION plperlu' 486s ok 31 - bool_plperlu dependency extension plperlu removes without error 486s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 486s ok 33 - extension btree_gin installs without error 486s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 486s ok 35 - extension btree_gin removes without error 486s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 486s ok 37 - extension btree_gist installs without error 487s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 487s ok 39 - extension btree_gist removes without error 487s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 487s ok 41 - extension citext installs without error 487s ok 42 - psql -qc 'DROP EXTENSION "citext"' 487s ok 43 - extension citext removes without error 487s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 487s ok 45 - extension cube installs without error 487s ok 46 - psql -qc 'DROP EXTENSION "cube"' 487s ok 47 - extension cube removes without error 487s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 487s ok 49 - extension dblink installs without error 487s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 487s ok 51 - extension dblink removes without error 487s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 487s ok 53 - extension dict_int installs without error 487s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 487s ok 55 - extension dict_int removes without error 487s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 487s ok 57 - extension dict_xsyn installs without error 487s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 487s ok 59 - extension dict_xsyn removes without error 487s ok 60 - psql -qc 'CREATE EXTENSION cube' 487s ok 61 - earthdistance dependency cube installs without error 487s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 487s ok 63 - extension earthdistance installs without error 487s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 487s ok 65 - extension earthdistance removes without error 487s ok 66 - psql -qc 'DROP EXTENSION cube' 487s ok 67 - earthdistance dependency extension cube removes without error 487s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 487s ok 69 - extension file_fdw installs without error 487s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 487s ok 71 - extension file_fdw removes without error 487s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 487s ok 73 - extension fuzzystrmatch installs without error 487s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 487s ok 75 - extension fuzzystrmatch removes without error 487s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 487s ok 77 - extension hstore installs without error 487s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 487s ok 79 - extension hstore removes without error 488s ok 80 - psql -qc 'CREATE EXTENSION hstore' 488s ok 81 - hstore_plperl dependency hstore installs without error 488s ok 82 - psql -qc 'CREATE EXTENSION plperl' 488s ok 83 - hstore_plperl dependency plperl installs without error 488s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 488s ok 85 - extension hstore_plperl installs without error 488s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 488s ok 87 - extension hstore_plperl removes without error 488s ok 88 - psql -qc 'DROP EXTENSION hstore' 488s ok 89 - hstore_plperl dependency extension hstore removes without error 488s ok 90 - psql -qc 'DROP EXTENSION plperl' 488s ok 91 - hstore_plperl dependency extension plperl removes without error 488s ok 92 - psql -qc 'CREATE EXTENSION hstore' 488s ok 93 - hstore_plperlu dependency hstore installs without error 488s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 488s ok 95 - hstore_plperlu dependency plperlu installs without error 488s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 488s ok 97 - extension hstore_plperlu installs without error 488s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 488s ok 99 - extension hstore_plperlu removes without error 488s ok 100 - psql -qc 'DROP EXTENSION hstore' 488s ok 101 - hstore_plperlu dependency extension hstore removes without error 488s ok 102 - psql -qc 'DROP EXTENSION plperlu' 488s ok 103 - hstore_plperlu dependency extension plperlu removes without error 488s ok 104 - psql -qc 'CREATE EXTENSION hstore' 488s ok 105 - hstore_plpython3u dependency hstore installs without error 488s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 488s ok 107 - hstore_plpython3u dependency plpython3u installs without error 488s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 488s ok 109 - extension hstore_plpython3u installs without error 488s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 488s ok 111 - extension hstore_plpython3u removes without error 488s ok 112 - psql -qc 'DROP EXTENSION hstore' 488s ok 113 - hstore_plpython3u dependency extension hstore removes without error 488s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 488s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 488s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 488s ok 117 - extension insert_username installs without error 488s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 488s ok 119 - extension insert_username removes without error 488s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 488s ok 121 - extension intagg installs without error 488s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 488s ok 123 - extension intagg removes without error 488s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 488s ok 125 - extension intarray installs without error 489s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 489s ok 127 - extension intarray removes without error 489s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 489s ok 129 - extension isn installs without error 489s ok 130 - psql -qc 'DROP EXTENSION "isn"' 489s ok 131 - extension isn removes without error 489s ok 132 - psql -qc 'CREATE EXTENSION plperl' 489s ok 133 - jsonb_plperl dependency plperl installs without error 489s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 489s ok 135 - extension jsonb_plperl installs without error 489s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 489s ok 137 - extension jsonb_plperl removes without error 489s ok 138 - psql -qc 'DROP EXTENSION plperl' 489s ok 139 - jsonb_plperl dependency extension plperl removes without error 489s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 489s ok 141 - jsonb_plperlu dependency plperlu installs without error 489s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 489s ok 143 - extension jsonb_plperlu installs without error 489s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 489s ok 145 - extension jsonb_plperlu removes without error 489s ok 146 - psql -qc 'DROP EXTENSION plperlu' 489s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 489s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 489s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 489s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 489s ok 151 - extension jsonb_plpython3u installs without error 489s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 489s ok 153 - extension jsonb_plpython3u removes without error 489s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 489s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 489s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 489s ok 157 - extension lo installs without error 489s ok 158 - psql -qc 'DROP EXTENSION "lo"' 489s ok 159 - extension lo removes without error 489s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 489s ok 161 - extension ltree installs without error 489s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 489s ok 163 - extension ltree removes without error 489s ok 164 - psql -qc 'CREATE EXTENSION ltree' 489s ok 165 - ltree_plpython3u dependency ltree installs without error 489s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 489s ok 167 - ltree_plpython3u dependency plpython3u installs without error 490s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 490s ok 169 - extension ltree_plpython3u installs without error 490s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 490s ok 171 - extension ltree_plpython3u removes without error 490s ok 172 - psql -qc 'DROP EXTENSION ltree' 490s ok 173 - ltree_plpython3u dependency extension ltree removes without error 490s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 490s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 490s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 490s ok 177 - extension moddatetime installs without error 490s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 490s ok 179 - extension moddatetime removes without error 490s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 490s ok 181 - extension pageinspect installs without error 490s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 490s ok 183 - extension pageinspect removes without error 490s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 490s ok 185 - extension pg_buffercache installs without error 490s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 490s ok 187 - extension pg_buffercache removes without error 490s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 490s ok 189 - extension pg_freespacemap installs without error 490s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 490s ok 191 - extension pg_freespacemap removes without error 490s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 490s ok 193 - extension pg_prewarm installs without error 490s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 490s ok 195 - extension pg_prewarm removes without error 490s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 490s ok 197 - extension pg_stat_statements installs without error 490s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 490s ok 199 - extension pg_stat_statements removes without error 490s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 490s ok 201 - extension pg_surgery installs without error 490s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 490s ok 203 - extension pg_surgery removes without error 490s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 490s ok 205 - extension pg_trgm installs without error 490s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 490s ok 207 - extension pg_trgm removes without error 490s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 490s ok 209 - extension pg_visibility installs without error 490s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 490s ok 211 - extension pg_visibility removes without error 491s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 491s ok 213 - extension pg_walinspect installs without error 491s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 491s ok 215 - extension pg_walinspect removes without error 491s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 491s ok 217 - extension pgcrypto installs without error 491s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 491s ok 219 - extension pgcrypto removes without error 491s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 491s ok 221 - extension pgrowlocks installs without error 491s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 491s ok 223 - extension pgrowlocks removes without error 491s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 491s ok 225 - extension pgstattuple installs without error 491s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 491s ok 227 - extension pgstattuple removes without error 491s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 491s ok 229 - extension plperl installs without error 491s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 491s ok 231 - extension plperl removes without error 491s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 491s ok 233 - extension plperlu installs without error 491s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 491s ok 235 - extension plperlu removes without error 491s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 491s ok 237 - extension plpython3u installs without error 491s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 491s ok 239 - extension plpython3u removes without error 491s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 491s ok 241 - extension pltcl installs without error 491s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 491s ok 243 - extension pltcl removes without error 491s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 491s ok 245 - extension pltclu installs without error 491s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 491s ok 247 - extension pltclu removes without error 491s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 491s ok 249 - extension postgres_fdw installs without error 491s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 491s ok 251 - extension postgres_fdw removes without error 491s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 491s ok 253 - extension refint installs without error 491s ok 254 - psql -qc 'DROP EXTENSION "refint"' 491s ok 255 - extension refint removes without error 492s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 492s ok 257 - extension seg installs without error 492s ok 258 - psql -qc 'DROP EXTENSION "seg"' 492s ok 259 - extension seg removes without error 492s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 492s ok 261 - extension sslinfo installs without error 492s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 492s ok 263 - extension sslinfo removes without error 492s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 492s ok 265 - extension tablefunc installs without error 492s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 492s ok 267 - extension tablefunc removes without error 492s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 492s ok 269 - extension tcn installs without error 492s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 492s ok 271 - extension tcn removes without error 492s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 492s ok 273 - extension tsm_system_rows installs without error 492s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 492s ok 275 - extension tsm_system_rows removes without error 492s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 492s ok 277 - extension tsm_system_time installs without error 492s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 492s ok 279 - extension tsm_system_time removes without error 492s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 492s ok 281 - extension unaccent installs without error 492s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 492s ok 283 - extension unaccent removes without error 492s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 492s ok 285 - extension uuid-ossp installs without error 492s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 492s ok 287 - extension uuid-ossp removes without error 492s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 492s ok 289 - extension xml2 installs without error 492s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 492s ok 291 - extension xml2 removes without error 494s ok 292 - pg_dropcluster 17 main 494s # Cleanup 494s ok 293 - Cleanup: No clusters left behind 494s ok 294 - No postgres processes left behind 494s ok 295 - No files in /etc/postgresql left behind 494s ok 296 - No files in /var/lib/postgresql left behind 494s ok 297 - No files in /var/run/postgresql left behind 494s ok 298 - No files in /var/log/postgresql left behind 494s ok 299 - PostgreSQL TCP ports are closed 494s ok 300 - Next free port is 5432 494s 1..300 494s ### End test 170_extensions.t ### 494s 494s ### PostgreSQL test 180_ecpg.t ### 494s 1..14 494s ok 1 - ecpg test.pgc 494s ok 2 - ecpg processing 494s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 494s ok 4 - compiling ecpg output 501s ok 5 - pg_virtualenv /tmp/tmp.PN7d0d1Ws6/test 501s ok 6 - test program runs and gives correct output 501s # Cleanup 501s ok 7 - Cleanup: No clusters left behind 501s ok 8 - No postgres processes left behind 501s ok 9 - No files in /etc/postgresql left behind 501s ok 10 - No files in /var/lib/postgresql left behind 501s ok 11 - No files in /var/run/postgresql left behind 501s ok 12 - No files in /var/log/postgresql left behind 501s ok 13 - PostgreSQL TCP ports are closed 501s ok 14 - Next free port is 5432 501s ### End test 180_ecpg.t ### 501s 501s ### PostgreSQL test 190_pg_buildext.t ### 501s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 501s 1..1 501s ### End test 190_pg_buildext.t ### 501s 501s ### PostgreSQL test 200_maintscripts.t ### 501s 1..15 501s # We are running systemd 505s ok 1 - pg_createcluster 17 main --start 505s ok 2 - postmaster PID is 22023 506s ok 3 - apt-get update -q 506s # postgresql-common: 506s # Installed: 274 506s # Candidate: 274 506s # Version table: 506s # *** 274 500 506s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 506s # 100 /var/lib/dpkg/status 509s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 509s # postgresql-common: 509s # Installed: 274 509s # Candidate: 274 509s # Version table: 509s # *** 274 500 509s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 509s # 100 /var/lib/dpkg/status 509s ok 5 - postmaster PID is 22023 509s ok 6 - postmaster was not restarted 511s ok 7 - pg_dropcluster 17 main --stop 511s # Cleanup 511s ok 8 - Cleanup: No clusters left behind 511s ok 9 - No postgres processes left behind 511s ok 10 - No files in /etc/postgresql left behind 511s ok 11 - No files in /var/lib/postgresql left behind 511s ok 12 - No files in /var/run/postgresql left behind 511s ok 13 - No files in /var/log/postgresql left behind 511s ok 14 - PostgreSQL TCP ports are closed 511s ok 15 - Next free port is 5432 511s ### End test 200_maintscripts.t ### 511s 511s autopkgtest [18:45:16]: test run-testsuite: -----------------------] 512s autopkgtest [18:45:17]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 512s run-testsuite PASS 512s autopkgtest [18:45:17]: test installcheck: preparing testbed 574s autopkgtest [18:46:19]: testbed dpkg architecture: arm64 574s autopkgtest [18:46:19]: testbed apt version: 3.0.0 574s autopkgtest [18:46:19]: @@@@@@@@@@@@@@@@@@@@ test bed setup 574s autopkgtest [18:46:19]: testbed release detected to be: plucky 575s autopkgtest [18:46:20]: updating testbed package index (apt update) 575s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 575s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 575s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 575s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 575s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 575s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [5840 B] 576s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [252 B] 576s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [224 B] 576s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [16.6 kB] 576s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [8288 B] 576s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [324 B] 577s Fetched 302 kB in 0s (687 kB/s) 577s Reading package lists... 578s autopkgtest [18:46:23]: upgrading testbed (apt dist-upgrade and autopurge) 578s Reading package lists... 578s Building dependency tree... 578s Reading state information... 579s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 579s Starting 2 pkgProblemResolver with broken count: 0 579s Done 579s Entering ResolveByKeep 580s 580s Calculating upgrade... 580s The following packages will be upgraded: 580s tzdata 580s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 580s Need to get 198 kB of archives. 580s After this operation, 0 B of additional disk space will be used. 580s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 tzdata all 2025b-1ubuntu1.1 [198 kB] 580s Preconfiguring packages ... 580s Fetched 198 kB in 0s (14.5 MB/s) 581s (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 ... 85224 files and directories currently installed.) 581s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 581s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 581s Setting up tzdata (2025b-1ubuntu1.1) ... 581s 581s Current default time zone: 'Etc/UTC' 581s Local time is now: Tue May 6 18:46:25 UTC 2025. 581s Universal Time is now: Tue May 6 18:46:25 UTC 2025. 581s Run 'dpkg-reconfigure tzdata' if you wish to change it. 581s 581s Reading package lists... 581s Building dependency tree... 581s Reading state information... 582s Starting pkgProblemResolver with broken count: 0 582s Starting 2 pkgProblemResolver with broken count: 0 582s Done 582s Solving dependencies... 583s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 585s Reading package lists... 585s Building dependency tree... 585s Reading state information... 585s Starting pkgProblemResolver with broken count: 0 586s Starting 2 pkgProblemResolver with broken count: 0 586s Done 586s The following NEW packages will be installed: 586s binutils-gold binutils-gold-aarch64-linux-gnu build-essential clang-20 cpp 586s cpp-14 cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu g++ g++-14 586s g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc gcc-14 586s gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu libasan8 libcc1-0 586s libclang-common-20-dev libclang-cpp20 libclang1-20 libffi-dev libgc1 586s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 586s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 586s libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libssl-dev libstdc++-14-dev 586s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 586s llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 586s postgresql-client-17 postgresql-client-common postgresql-common 586s postgresql-common-dev postgresql-server-dev-17 ssl-cert tzdata-legacy 586s 0 upgraded, 59 newly installed, 0 to remove and 0 not upgraded. 586s Need to get 208 MB of archives. 586s After this operation, 1048 MB of additional disk space will be used. 586s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 586s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 586s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 586s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 586s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 586s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 586s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 586s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 binutils-gold-aarch64-linux-gnu arm64 2.44-2 [2033 kB] 586s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 binutils-gold arm64 2.44-2 [2168 B] 586s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 586s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 586s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [10.6 MB] 587s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-19ubuntu2 [1026 B] 587s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [5558 B] 587s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.2.0-1ubuntu1 [22.4 kB] 587s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 15-20250404-0ubuntu1 [49.1 kB] 587s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 15-20250404-0ubuntu1 [147 kB] 587s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 15-20250404-0ubuntu1 [27.8 kB] 587s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 15-20250404-0ubuntu1 [2922 kB] 587s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 15-20250404-0ubuntu1 [1318 kB] 587s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 15-20250404-0ubuntu1 [2692 kB] 587s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 15-20250404-0ubuntu1 [1177 kB] 587s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 15-20250404-0ubuntu1 [1640 kB] 587s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-19ubuntu2 [2593 kB] 587s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [20.9 MB] 587s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-19ubuntu2 [529 kB] 587s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [1200 B] 587s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.2.0-1ubuntu1 [4998 B] 587s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-19ubuntu2 [2501 kB] 587s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-19ubuntu2 [12.1 MB] 588s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-19ubuntu2 [23.0 kB] 588s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [956 B] 588s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.2.0-1ubuntu1 [1080 B] 588s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 build-essential arm64 12.12ubuntu1 [5082 B] 588s Get:35 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.2-0ubuntu1 [29.1 MB] 588s Get:36 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp20 arm64 1:20.1.2-0ubuntu1 [13.8 MB] 588s Get:37 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 588s Get:38 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 15-20250404-0ubuntu1 [45.5 kB] 588s Get:39 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-19ubuntu2 [190 kB] 588s Get:40 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-20-dev arm64 1:20.1.2-0ubuntu1 [782 kB] 588s Get:41 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-linker-tools arm64 1:20.1.2-0ubuntu1 [1243 kB] 588s Get:42 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang1-20 arm64 1:20.1.2-0ubuntu1 [7989 kB] 588s Get:43 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-20 arm64 1:20.1.2-0ubuntu1 [76.4 kB] 588s Get:44 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5+20250216-2 [389 kB] 588s Get:45 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 588s Get:46 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.1-1ubuntu3 [3285 kB] 588s Get:47 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq-dev arm64 17.4-1 [159 kB] 588s Get:48 http://ftpmaster.internal/ubuntu plucky-updates/main arm64 libxml2-dev arm64 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [804 kB] 588s Get:49 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu4 [168 kB] 589s Get:50 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-runtime arm64 1:20.1.2-0ubuntu1 [538 kB] 589s Get:51 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 589s Get:52 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20 arm64 1:20.1.2-0ubuntu1 [19.0 MB] 589s Get:53 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.7-1 [59.5 kB] 589s Get:54 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-tools arm64 1:20.1.2-0ubuntu1 [512 kB] 589s Get:55 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-20-dev arm64 1:20.1.2-0ubuntu1 [48.2 MB] 589s Get:56 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 590s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 590s Get:58 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-17 arm64 17.4-1 [1390 kB] 590s Get:59 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 tzdata-legacy all 2025b-1ubuntu1.1 [99.2 kB] 590s Preconfiguring packages ... 590s Fetched 208 MB in 4s (57.3 MB/s) 590s Selecting previously unselected package libjson-perl. 590s (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 ... 85224 files and directories currently installed.) 590s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 590s Unpacking libjson-perl (4.10000-1) ... 590s Selecting previously unselected package postgresql-client-common. 590s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 590s Unpacking postgresql-client-common (274) ... 590s Selecting previously unselected package libio-pty-perl. 590s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 590s Unpacking libio-pty-perl (1:1.20-1build3) ... 590s Selecting previously unselected package libipc-run-perl. 590s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 590s Unpacking libipc-run-perl (20231003.0-2) ... 590s Selecting previously unselected package postgresql-common-dev. 590s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 590s Unpacking postgresql-common-dev (274) ... 590s Selecting previously unselected package ssl-cert. 590s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 590s Unpacking ssl-cert (1.1.3ubuntu1) ... 590s Selecting previously unselected package postgresql-common. 590s Preparing to unpack .../06-postgresql-common_274_all.deb ... 590s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 590s Unpacking postgresql-common (274) ... 590s Selecting previously unselected package binutils-gold-aarch64-linux-gnu. 590s Preparing to unpack .../07-binutils-gold-aarch64-linux-gnu_2.44-2_arm64.deb ... 590s Unpacking binutils-gold-aarch64-linux-gnu (2.44-2) ... 591s Selecting previously unselected package binutils-gold. 591s Preparing to unpack .../08-binutils-gold_2.44-2_arm64.deb ... 591s Unpacking binutils-gold (2.44-2) ... 591s Selecting previously unselected package libisl23:arm64. 591s Preparing to unpack .../09-libisl23_0.27-1_arm64.deb ... 591s Unpacking libisl23:arm64 (0.27-1) ... 591s Selecting previously unselected package libmpc3:arm64. 591s Preparing to unpack .../10-libmpc3_1.3.1-1build2_arm64.deb ... 591s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 591s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 591s Preparing to unpack .../11-cpp-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 591s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 591s Selecting previously unselected package cpp-14. 591s Preparing to unpack .../12-cpp-14_14.2.0-19ubuntu2_arm64.deb ... 591s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 591s Selecting previously unselected package cpp-aarch64-linux-gnu. 591s Preparing to unpack .../13-cpp-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 591s Unpacking cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 591s Selecting previously unselected package cpp. 591s Preparing to unpack .../14-cpp_4%3a14.2.0-1ubuntu1_arm64.deb ... 591s Unpacking cpp (4:14.2.0-1ubuntu1) ... 591s Selecting previously unselected package libcc1-0:arm64. 591s Preparing to unpack .../15-libcc1-0_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libcc1-0:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libgomp1:arm64. 591s Preparing to unpack .../16-libgomp1_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libgomp1:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libitm1:arm64. 591s Preparing to unpack .../17-libitm1_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libitm1:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libasan8:arm64. 591s Preparing to unpack .../18-libasan8_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libasan8:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package liblsan0:arm64. 591s Preparing to unpack .../19-liblsan0_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking liblsan0:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libtsan2:arm64. 591s Preparing to unpack .../20-libtsan2_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libtsan2:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libubsan1:arm64. 591s Preparing to unpack .../21-libubsan1_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libubsan1:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libhwasan0:arm64. 591s Preparing to unpack .../22-libhwasan0_15-20250404-0ubuntu1_arm64.deb ... 591s Unpacking libhwasan0:arm64 (15-20250404-0ubuntu1) ... 591s Selecting previously unselected package libgcc-14-dev:arm64. 591s Preparing to unpack .../23-libgcc-14-dev_14.2.0-19ubuntu2_arm64.deb ... 591s Unpacking libgcc-14-dev:arm64 (14.2.0-19ubuntu2) ... 591s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 591s Preparing to unpack .../24-gcc-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 591s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 592s Selecting previously unselected package gcc-14. 592s Preparing to unpack .../25-gcc-14_14.2.0-19ubuntu2_arm64.deb ... 592s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 592s Selecting previously unselected package gcc-aarch64-linux-gnu. 592s Preparing to unpack .../26-gcc-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 592s Unpacking gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 592s Selecting previously unselected package gcc. 592s Preparing to unpack .../27-gcc_4%3a14.2.0-1ubuntu1_arm64.deb ... 592s Unpacking gcc (4:14.2.0-1ubuntu1) ... 592s Selecting previously unselected package libstdc++-14-dev:arm64. 592s Preparing to unpack .../28-libstdc++-14-dev_14.2.0-19ubuntu2_arm64.deb ... 592s Unpacking libstdc++-14-dev:arm64 (14.2.0-19ubuntu2) ... 592s Selecting previously unselected package g++-14-aarch64-linux-gnu. 592s Preparing to unpack .../29-g++-14-aarch64-linux-gnu_14.2.0-19ubuntu2_arm64.deb ... 592s Unpacking g++-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 592s Selecting previously unselected package g++-14. 592s Preparing to unpack .../30-g++-14_14.2.0-19ubuntu2_arm64.deb ... 592s Unpacking g++-14 (14.2.0-19ubuntu2) ... 592s Selecting previously unselected package g++-aarch64-linux-gnu. 592s Preparing to unpack .../31-g++-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 592s Unpacking g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 592s Selecting previously unselected package g++. 592s Preparing to unpack .../32-g++_4%3a14.2.0-1ubuntu1_arm64.deb ... 592s Unpacking g++ (4:14.2.0-1ubuntu1) ... 592s Selecting previously unselected package build-essential. 592s Preparing to unpack .../33-build-essential_12.12ubuntu1_arm64.deb ... 592s Unpacking build-essential (12.12ubuntu1) ... 592s Selecting previously unselected package libllvm20:arm64. 592s Preparing to unpack .../34-libllvm20_1%3a20.1.2-0ubuntu1_arm64.deb ... 592s Unpacking libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 593s Selecting previously unselected package libclang-cpp20. 593s Preparing to unpack .../35-libclang-cpp20_1%3a20.1.2-0ubuntu1_arm64.deb ... 593s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 593s Selecting previously unselected package libgc1:arm64. 593s Preparing to unpack .../36-libgc1_1%3a8.2.8-1_arm64.deb ... 593s Unpacking libgc1:arm64 (1:8.2.8-1) ... 593s Selecting previously unselected package libobjc4:arm64. 594s Preparing to unpack .../37-libobjc4_15-20250404-0ubuntu1_arm64.deb ... 594s Unpacking libobjc4:arm64 (15-20250404-0ubuntu1) ... 594s Selecting previously unselected package libobjc-14-dev:arm64. 594s Preparing to unpack .../38-libobjc-14-dev_14.2.0-19ubuntu2_arm64.deb ... 594s Unpacking libobjc-14-dev:arm64 (14.2.0-19ubuntu2) ... 594s Selecting previously unselected package libclang-common-20-dev:arm64. 594s Preparing to unpack .../39-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking libclang-common-20-dev:arm64 (1:20.1.2-0ubuntu1) ... 594s Selecting previously unselected package llvm-20-linker-tools. 594s Preparing to unpack .../40-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 594s Selecting previously unselected package libclang1-20. 594s Preparing to unpack .../41-libclang1-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 594s Selecting previously unselected package clang-20. 594s Preparing to unpack .../42-clang-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 594s Selecting previously unselected package libncurses-dev:arm64. 594s Preparing to unpack .../43-libncurses-dev_6.5+20250216-2_arm64.deb ... 594s Unpacking libncurses-dev:arm64 (6.5+20250216-2) ... 594s Selecting previously unselected package libpq5:arm64. 594s Preparing to unpack .../44-libpq5_17.4-1_arm64.deb ... 594s Unpacking libpq5:arm64 (17.4-1) ... 594s Selecting previously unselected package libssl-dev:arm64. 594s Preparing to unpack .../45-libssl-dev_3.4.1-1ubuntu3_arm64.deb ... 594s Unpacking libssl-dev:arm64 (3.4.1-1ubuntu3) ... 594s Selecting previously unselected package libpq-dev. 594s Preparing to unpack .../46-libpq-dev_17.4-1_arm64.deb ... 594s Unpacking libpq-dev (17.4-1) ... 594s Selecting previously unselected package libxml2-dev:arm64. 594s Preparing to unpack .../47-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_arm64.deb ... 594s Unpacking libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 594s Selecting previously unselected package libxslt1.1:arm64. 594s Preparing to unpack .../48-libxslt1.1_1.1.39-0exp1ubuntu4_arm64.deb ... 594s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 594s Selecting previously unselected package llvm-20-runtime. 594s Preparing to unpack .../49-llvm-20-runtime_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 594s Selecting previously unselected package libpfm4:arm64. 594s Preparing to unpack .../50-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 594s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 594s Selecting previously unselected package llvm-20. 594s Preparing to unpack .../51-llvm-20_1%3a20.1.2-0ubuntu1_arm64.deb ... 594s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 595s Selecting previously unselected package libffi-dev:arm64. 595s Preparing to unpack .../52-libffi-dev_3.4.7-1_arm64.deb ... 595s Unpacking libffi-dev:arm64 (3.4.7-1) ... 595s Selecting previously unselected package llvm-20-tools. 595s Preparing to unpack .../53-llvm-20-tools_1%3a20.1.2-0ubuntu1_arm64.deb ... 595s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 595s Selecting previously unselected package llvm-20-dev. 595s Preparing to unpack .../54-llvm-20-dev_1%3a20.1.2-0ubuntu1_arm64.deb ... 595s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 597s Selecting previously unselected package postgresql-client-17. 597s Preparing to unpack .../55-postgresql-client-17_17.4-1_arm64.deb ... 597s Unpacking postgresql-client-17 (17.4-1) ... 597s Selecting previously unselected package postgresql-17. 597s Preparing to unpack .../56-postgresql-17_17.4-1_arm64.deb ... 597s Unpacking postgresql-17 (17.4-1) ... 597s Selecting previously unselected package postgresql-server-dev-17. 597s Preparing to unpack .../57-postgresql-server-dev-17_17.4-1_arm64.deb ... 597s Unpacking postgresql-server-dev-17 (17.4-1) ... 597s Selecting previously unselected package tzdata-legacy. 597s Preparing to unpack .../58-tzdata-legacy_2025b-1ubuntu1.1_all.deb ... 597s Unpacking tzdata-legacy (2025b-1ubuntu1.1) ... 597s Setting up postgresql-client-common (274) ... 597s Setting up libncurses-dev:arm64 (6.5+20250216-2) ... 597s Setting up libio-pty-perl (1:1.20-1build3) ... 598s Setting up libclang-common-20-dev:arm64 (1:20.1.2-0ubuntu1) ... 598s Setting up libpq5:arm64 (17.4-1) ... 598s Setting up binutils-gold-aarch64-linux-gnu (2.44-2) ... 598s Setting up libgomp1:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libffi-dev:arm64 (3.4.7-1) ... 598s Setting up tzdata-legacy (2025b-1ubuntu1.1) ... 598s Setting up libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 598s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 598s Setting up ssl-cert (1.1.3ubuntu1) ... 598s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 598s Setting up libssl-dev:arm64 (3.4.1-1ubuntu3) ... 598s Setting up libmpc3:arm64 (1.3.1-1build2) ... 598s Setting up libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 598s Setting up libipc-run-perl (20231003.0-2) ... 598s Setting up libgc1:arm64 (1:8.2.8-1) ... 598s Setting up libubsan1:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libhwasan0:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libasan8:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libjson-perl (4.10000-1) ... 598s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 598s Setting up libtsan2:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libisl23:arm64 (0.27-1) ... 598s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 598s Setting up libcc1-0:arm64 (15-20250404-0ubuntu1) ... 598s Setting up liblsan0:arm64 (15-20250404-0ubuntu1) ... 598s Setting up libitm1:arm64 (15-20250404-0ubuntu1) ... 598s Setting up postgresql-common-dev (274) ... 598s Setting up postgresql-client-17 (17.4-1) ... 599s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 599s Setting up binutils-gold (2.44-2) ... 599s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 599s Setting up libpq-dev (17.4-1) ... 599s Setting up libobjc4:arm64 (15-20250404-0ubuntu1) ... 599s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 599s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 599s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 599s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 599s Setting up postgresql-common (274) ... 599s Creating config file /etc/postgresql-common/createcluster.conf with new version 599s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 599s Removing obsolete dictionary files: 600s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 600s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 600s Setting up cpp-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 600s Setting up libgcc-14-dev:arm64 (14.2.0-19ubuntu2) ... 600s Setting up libstdc++-14-dev:arm64 (14.2.0-19ubuntu2) ... 600s Setting up postgresql-17 (17.4-1) ... 601s Creating new PostgreSQL cluster 17/main ... 601s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 601s The files belonging to this database system will be owned by user "postgres". 601s This user must also own the server process. 601s 601s The database cluster will be initialized with locale "C.UTF-8". 601s The default database encoding has accordingly been set to "UTF8". 601s The default text search configuration will be set to "english". 601s 601s Data page checksums are disabled. 601s 601s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 601s creating subdirectories ... ok 601s selecting dynamic shared memory implementation ... posix 601s selecting default "max_connections" ... 100 601s selecting default "shared_buffers" ... 128MB 601s selecting default time zone ... Etc/UTC 601s creating configuration files ... ok 601s running bootstrap script ... ok 602s performing post-bootstrap initialization ... ok 602s syncing data to disk ... ok 605s Setting up libobjc-14-dev:arm64 (14.2.0-19ubuntu2) ... 605s Setting up cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 605s Setting up cpp-14 (14.2.0-19ubuntu2) ... 605s Setting up cpp (4:14.2.0-1ubuntu1) ... 605s Setting up gcc-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 605s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 605s Setting up gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 605s Setting up g++-14-aarch64-linux-gnu (14.2.0-19ubuntu2) ... 605s Setting up gcc-14 (14.2.0-19ubuntu2) ... 605s Setting up postgresql-server-dev-17 (17.4-1) ... 605s Setting up g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 605s Setting up g++-14 (14.2.0-19ubuntu2) ... 605s Setting up gcc (4:14.2.0-1ubuntu1) ... 605s Setting up g++ (4:14.2.0-1ubuntu1) ... 605s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 605s Setting up build-essential (12.12ubuntu1) ... 605s Processing triggers for libc-bin (2.41-6ubuntu1) ... 605s Processing triggers for systemd (257.4-1ubuntu3) ... 605s Processing triggers for man-db (2.13.0-1) ... 606s Processing triggers for install-info (7.1.1-1) ... 622s autopkgtest [18:47:07]: test installcheck: [----------------------- 622s + dpkg-parsechangelog -SSource 622s + SOURCE=postgresql-17 622s + MAJOR=17 622s + top_srcdir=/tmp/autopkgtest.Ds27Ku/build.PO1/src 622s + cd src/test/regress 622s + make -f /tmp/autopkgtest.Ds27Ku/build.PO1/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 622s 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 -moutline-atomics -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -mbranch-protection=standard -fdebug-prefix-map=/build/postgresql-17-G1JMoS/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.Ds27Ku/build.PO1/src/debian/tests/ -I/usr/include/postgresql/17/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 623s 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 -moutline-atomics -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -mbranch-protection=standard -fdebug-prefix-map=/build/postgresql-17-G1JMoS/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/aarch64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-20/lib -Wl,--as-needed -fvisibility=hidden 624s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.Ds27Ku/build.PO1/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated.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/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/predicate.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/sqljson_jsontable.sql sql/sqljson_queryfuncs.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.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated.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/matview.out expected/md5.out expected/md5_1.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/password_1.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/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 624s + id -u 624s + [ 1000 = 0 ] 624s + SU=sh 624s + sh 624s + mktemp -d /tmp/regress.XXXXXX 624s + OUTPUT=/tmp/regress.BUPvTQ 624s + trap rm -rf /tmp/regress.BUPvTQ EXIT 624s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.BUPvTQ --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 624s Creating new PostgreSQL cluster 17/regress ... 627s # using postmaster on localhost, port 5433 627s ok 1 - test_setup 180 ms 628s # parallel group (20 tests): varchar oid char pg_lsn name text int2 int4 txid money uuid float4 regproc float8 int8 enum bit boolean numeric rangetypes 628s ok 2 + boolean 788 ms 628s ok 3 + char 255 ms 628s ok 4 + name 276 ms 628s ok 5 + varchar 225 ms 628s ok 6 + text 278 ms 628s ok 7 + int2 293 ms 628s ok 8 + int4 311 ms 628s ok 9 + int8 413 ms 628s ok 10 + oid 241 ms 628s ok 11 + float4 380 ms 628s ok 12 + float8 405 ms 628s ok 13 + bit 775 ms 628s ok 14 + numeric 894 ms 628s ok 15 + txid 302 ms 628s ok 16 + uuid 331 ms 628s ok 17 + enum 406 ms 628s ok 18 + money 319 ms 628s ok 19 + rangetypes 933 ms 628s ok 20 + pg_lsn 244 ms 628s ok 21 + regproc 374 ms 629s # parallel group (20 tests): md5 lseg line circle path time macaddr timetz date numerology macaddr8 inet interval strings timestamp timestamptz point polygon multirangetypes box 629s ok 22 + strings 644 ms 629s ok 23 + md5 175 ms 629s ok 24 + numerology 366 ms 629s ok 25 + point 730 ms 629s ok 26 + lseg 185 ms 629s ok 27 + line 191 ms 629s ok 28 + box 1319 ms 629s ok 29 + path 214 ms 629s ok 30 + polygon 1065 ms 629s ok 31 + circle 190 ms 629s ok 32 + date 325 ms 629s ok 33 + time 262 ms 629s ok 34 + timetz 292 ms 629s ok 35 + timestamp 638 ms 629s ok 36 + timestamptz 666 ms 629s ok 37 + interval 602 ms 629s ok 38 + inet 390 ms 629s ok 39 + macaddr 265 ms 629s ok 40 + macaddr8 352 ms 629s ok 41 + multirangetypes 1101 ms 630s # parallel group (13 tests): comments unicode misc_sanity expressions xid mvcc tstypes type_sanity geometry regex opr_sanity database horology 630s ok 42 + geometry 453 ms 630s ok 43 + horology 752 ms 630s ok 44 + tstypes 283 ms 630s ok 45 + regex 694 ms 630s ok 46 + type_sanity 354 ms 630s ok 47 + opr_sanity 712 ms 630s ok 48 + misc_sanity 141 ms 630s ok 49 + comments 99 ms 630s ok 50 + expressions 229 ms 630s ok 51 + unicode 113 ms 630s ok 52 + xid 245 ms 630s ok 53 + mvcc 275 ms 630s ok 54 + database 731 ms 630s # parallel group (5 tests): copydml copyselect copy insert_conflict insert 630s ok 55 + copy 176 ms 630s ok 56 + copyselect 89 ms 630s ok 57 + copydml 82 ms 630s ok 58 + insert 348 ms 630s ok 59 + insert_conflict 205 ms 631s # parallel group (7 tests): create_function_c create_operator create_type create_misc create_schema create_procedure create_table 631s ok 60 + create_function_c 63 ms 631s ok 61 + create_misc 130 ms 631s ok 62 + create_operator 96 ms 631s ok 63 + create_procedure 138 ms 631s ok 64 + create_table 354 ms 631s ok 65 + create_type 117 ms 631s ok 66 + create_schema 127 ms 632s # parallel group (5 tests): index_including_gist index_including create_view create_index_spgist create_index 632s ok 67 + create_index 1221 ms 632s ok 68 + create_index_spgist 1123 ms 632s ok 69 + create_view 466 ms 632s ok 70 + index_including 458 ms 632s ok 71 + index_including_gist 451 ms 634s # parallel group (16 tests): create_cast hash_func create_aggregate errors roleattributes typed_table drop_if_exists create_function_sql create_am select infinite_recurse constraints vacuum updatable_views inherit triggers 634s ok 72 + create_aggregate 256 ms 634s ok 73 + create_function_sql 518 ms 634s ok 74 + create_cast 222 ms 634s ok 75 + constraints 809 ms 634s ok 76 + triggers 1558 ms 634s ok 77 + select 691 ms 634s ok 78 + inherit 1507 ms 634s ok 79 + typed_table 424 ms 634s ok 80 + vacuum 978 ms 634s ok 81 + drop_if_exists 469 ms 634s ok 82 + updatable_views 1444 ms 634s ok 83 + roleattributes 277 ms 634s ok 84 + create_am 641 ms 634s ok 85 + hash_func 240 ms 634s ok 86 + errors 256 ms 634s ok 87 + infinite_recurse 715 ms 634s ok 88 - sanity_check 73 ms 636s # parallel group (20 tests): select_distinct_on select_having select_implicit delete case random namespace select_into prepared_xacts union transactions portals select_distinct subselect arrays hash_index update btree_index aggregates join 636s ok 89 + select_into 457 ms 636s ok 90 + select_distinct 908 ms 636s ok 91 + select_distinct_on 213 ms 636s ok 92 + select_implicit 283 ms 636s ok 93 + select_having 275 ms 636s ok 94 + subselect 1061 ms 636s ok 95 + union 893 ms 636s ok 96 + case 349 ms 636s ok 97 + join 2530 ms 636s ok 98 + aggregates 2404 ms 636s ok 99 + transactions 882 ms 636s ok 100 + random 398 ms 636s ok 101 + portals 890 ms 636s ok 102 + arrays 1172 ms 636s ok 103 + btree_index 2261 ms 636s ok 104 + hash_index 1477 ms 636s ok 105 + update 1605 ms 636s ok 106 + delete 275 ms 636s ok 107 + namespace 400 ms 636s ok 108 + prepared_xacts 449 ms 643s # parallel group (20 tests): init_privs security_label drop_operator tablesample lock object_address password replica_identity identity matview collate spgist generated rowsecurity gist groupingsets gin brin join_hash privileges 643s ok 109 + brin 6714 ms 643s ok 110 + gin 2923 ms 643s ok 111 + gist 2579 ms 643s ok 112 + spgist 2068 ms 643s ok 113 + privileges 7095 ms 643s ok 114 + init_privs 142 ms 643s ok 115 + security_label 242 ms 643s ok 116 + collate 2033 ms 643s ok 117 + matview 1844 ms 643s ok 118 + lock 515 ms 643s ok 119 + replica_identity 945 ms 643s ok 120 + rowsecurity 2385 ms 643s ok 121 + object_address 606 ms 643s ok 122 + tablesample 455 ms 643s ok 123 + groupingsets 2891 ms 643s ok 124 + drop_operator 281 ms 643s ok 125 + password 675 ms 643s ok 126 + identity 1605 ms 643s ok 127 + generated 2225 ms 643s ok 128 + join_hash 6701 ms 644s # parallel group (2 tests): brin_bloom brin_multi 644s ok 129 + brin_bloom 71 ms 644s ok 130 + brin_multi 203 ms 645s # parallel group (17 tests): async dbsize collate.utf8 alter_operator tidscan tsrf tid create_role sysviews misc_functions alter_generic tidrangescan create_table_like merge incremental_sort misc collate.icu.utf8 645s ok 131 + create_table_like 854 ms 645s ok 132 + alter_generic 542 ms 645s ok 133 + alter_operator 240 ms 645s ok 134 + misc 1210 ms 645s ok 135 + async 110 ms 645s ok 136 + dbsize 181 ms 645s ok 137 + merge 926 ms 645s ok 138 + misc_functions 499 ms 645s ok 139 + sysviews 490 ms 645s ok 140 + tsrf 290 ms 645s ok 141 + tid 316 ms 645s ok 142 + tidscan 279 ms 645s ok 143 + tidrangescan 788 ms 645s ok 144 + collate.utf8 219 ms 645s ok 145 + collate.icu.utf8 1232 ms 645s ok 146 + incremental_sort 975 ms 645s ok 147 + create_role 371 ms 646s # parallel group (7 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab psql rules stats_ext 646s ok 148 + rules 503 ms 646s ok 149 + psql 431 ms 646s ok 150 + psql_crosstab 99 ms 646s ok 151 + amutils 82 ms 646s ok 152 + stats_ext 1191 ms 646s ok 153 + collate.linux.utf8 70 ms 646s ok 154 + collate.windows.win1252 64 ms 649s ok 155 - select_parallel 3404 ms 650s ok 156 - write_parallel 130 ms 650s ok 157 - vacuum_parallel 91 ms 651s # parallel group (2 tests): subscription publication 651s ok 158 + publication 1745 ms 651s ok 159 + subscription 59 ms 653s # parallel group (17 tests): portals_p2 combocid equivclass advisory_lock xmlmap functional_deps dependency guc tsdicts select_views bitmapops window cluster indirect_toast foreign_data foreign_key tsearch 653s ok 160 + select_views 538 ms 653s ok 161 + portals_p2 206 ms 653s ok 162 + foreign_key 1649 ms 653s ok 163 + cluster 984 ms 653s ok 164 + dependency 405 ms 653s ok 165 + guc 434 ms 653s ok 166 + bitmapops 869 ms 653s ok 167 + combocid 207 ms 653s ok 168 + tsearch 1936 ms 653s ok 169 + tsdicts 451 ms 653s ok 170 + foreign_data 1272 ms 653s ok 171 + window 945 ms 653s ok 172 + xmlmap 331 ms 653s ok 173 + functional_deps 358 ms 653s ok 174 + advisory_lock 256 ms 653s ok 175 + indirect_toast 1009 ms 653s ok 176 + equivclass 229 ms 654s # parallel group (9 tests): jsonpath_encoding json_encoding sqljson jsonpath sqljson_jsontable sqljson_queryfuncs jsonb_jsonpath json jsonb 654s ok 177 + json 368 ms 654s ok 178 + jsonb 448 ms 654s ok 179 + json_encoding 109 ms 654s ok 180 + jsonpath 223 ms 654s ok 181 + jsonpath_encoding 86 ms 654s ok 182 + jsonb_jsonpath 361 ms 654s ok 183 + sqljson 181 ms 654s ok 184 + sqljson_queryfuncs 349 ms 654s ok 185 + sqljson_jsontable 238 ms 656s # parallel group (18 tests): prepare returning limit plancache conversion temp truncate sequence copy2 rowtypes polymorphism largeobject domain with rangefuncs plpgsql xml alter_table 656s ok 186 + plancache 528 ms 656s ok 187 + limit 442 ms 656s ok 188 + plpgsql 1715 ms 656s ok 189 + copy2 1035 ms 656s ok 190 + temp 874 ms 656s ok 191 + domain 1262 ms 656s ok 192 + rangefuncs 1609 ms 656s ok 193 + prepare 268 ms 656s ok 194 + conversion 596 ms 656s ok 195 + truncate 935 ms 656s ok 196 + alter_table 2325 ms 656s ok 197 + sequence 961 ms 656s ok 198 + polymorphism 1066 ms 656s ok 199 + rowtypes 1015 ms 656s ok 200 + returning 348 ms 656s ok 201 + largeobject 1155 ms 656s ok 202 + with 1338 ms 656s ok 203 + xml 1758 ms 659s # parallel group (13 tests): hash_part reloptions predicate explain partition_info compression memoize partition_aggregate stats partition_join tuplesort indexing partition_prune 659s ok 204 + partition_join 2032 ms 659s ok 205 + partition_prune 2493 ms 659s ok 206 + reloptions 351 ms 659s ok 207 + hash_part 216 ms 659s ok 208 + indexing 2094 ms 659s ok 209 + partition_aggregate 1734 ms 659s ok 210 + partition_info 435 ms 659s ok 211 + tuplesort 2061 ms 659s ok 212 + explain 384 ms 659s ok 213 + compression 606 ms 659s ok 214 + memoize 1528 ms 659s ok 215 + stats 2001 ms 659s ok 216 + predicate 369 ms 659s # parallel group (2 tests): oidjoins event_trigger 659s ok 217 + oidjoins 186 ms 659s ok 218 + event_trigger 210 ms 659s ok 219 - event_trigger_login 58 ms 659s ok 220 - fast_default 120 ms 660s ok 221 - tablespace 279 ms 660s 1..221 660s # All 221 tests passed. 660s Dropping cluster 17/regress ... 660s + rm -rf /tmp/regress.BUPvTQ 660s autopkgtest [18:47:45]: test installcheck: -----------------------] 661s installcheck PASS 661s autopkgtest [18:47:46]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 661s autopkgtest [18:47:46]: @@@@@@@@@@@@@@@@@@@@ summary 661s run-testsuite PASS 661s installcheck PASS 664s nova [W] Using flock in prodstack7-arm64 664s flock: timeout while waiting to get lock 664s Creating nova instance adt-plucky-arm64-postgresql-17-20250506-183644-juju-7f2275-prod-proposed-migration-environment-23-d726dacd-673b-47bc-8836-6fb5df050c19 from image adt/ubuntu-plucky-arm64-server-20250506.img (UUID 8fd9e2cb-0db5-4c6d-99b6-bce8533eebcd)... 664s nova [W] Timed out waiting for 484e5f75-7bfd-48af-8a31-59d314f1ca21 to get deleted. 664s nova [W] Using flock in prodstack7-arm64 664s Creating nova instance adt-plucky-arm64-postgresql-17-20250506-183644-juju-7f2275-prod-proposed-migration-environment-23-d726dacd-673b-47bc-8836-6fb5df050c19 from image adt/ubuntu-plucky-arm64-server-20250506.img (UUID 8fd9e2cb-0db5-4c6d-99b6-bce8533eebcd)... 664s nova [W] Timed out waiting for 2b9ae24a-2224-4a91-99bc-f437bc1b395f to get deleted.