0s autopkgtest [13:47:03]: starting date and time: 2025-02-26 13:47:03+0000 0s autopkgtest [13:47:03]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:47:03]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.fqijpu2l/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-14 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025a-0ubuntu0.22.04 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-17.secgroup --name adt-jammy-ppc64el-postgresql-14-20250226-134703-juju-7f2275-prod-proposed-migration-environment-20-015d9d0b-f714-4d8e-989f-c11c23a12e80 --image adt/ubuntu-jammy-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 70s autopkgtest [13:48:13]: testbed dpkg architecture: ppc64el 70s autopkgtest [13:48:13]: testbed apt version: 2.4.13 70s autopkgtest [13:48:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 70s autopkgtest [13:48:13]: testbed release detected to be: None 71s autopkgtest [13:48:14]: updating testbed package index (apt update) 71s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 72s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 72s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 72s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 72s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 72s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 72s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 72s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 72s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el Packages [154 kB] 72s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el c-n-f Metadata [1724 B] 72s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el Packages [2048 B] 72s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el c-n-f Metadata [116 B] 72s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el Packages [77.9 kB] 72s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el c-n-f Metadata [1336 B] 72s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse ppc64el Packages [740 B] 72s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse ppc64el c-n-f Metadata [116 B] 77s Fetched 674 kB in 1s (705 kB/s) 78s Reading package lists... 79s Reading package lists... 79s Building dependency tree... 79s Reading state information... 79s Calculating upgrade... 79s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 79s Reading package lists... 80s Building dependency tree... 80s Reading state information... 80s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 80s autopkgtest [13:48:23]: upgrading testbed (apt dist-upgrade and autopurge) 80s Reading package lists... 80s Building dependency tree... 80s Reading state information... 81s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 81s Starting 2 pkgProblemResolver with broken count: 0 81s Done 81s Entering ResolveByKeep 81s 81s The following packages will be upgraded: 81s tzdata 81s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 81s Need to get 347 kB of archives. 81s After this operation, 4096 B of additional disk space will be used. 81s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el tzdata all 2025a-0ubuntu0.22.04 [347 kB] 82s Preconfiguring packages ... 82s Fetched 347 kB in 0s (822 kB/s) 82s (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 ... 66538 files and directories currently installed.) 82s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 82s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 83s Setting up tzdata (2025a-0ubuntu0.22.04) ... 83s 83s Current default time zone: 'Etc/UTC' 83s Local time is now: Wed Feb 26 13:48:26 UTC 2025. 83s Universal Time is now: Wed Feb 26 13:48:26 UTC 2025. 83s Run 'dpkg-reconfigure tzdata' if you wish to change it. 83s 83s Reading package lists... 83s Building dependency tree... 83s Reading state information... 84s Starting pkgProblemResolver with broken count: 0 84s Starting 2 pkgProblemResolver with broken count: 0 84s Done 84s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 86s autopkgtest [13:48:29]: testbed running kernel: Linux 5.15.0-133-generic #144-Ubuntu SMP Fri Feb 7 20:52:45 UTC 2025 87s autopkgtest [13:48:30]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-14 99s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (dsc) [3864 B] 99s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (tar) [29.3 MB] 99s Get:3 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (diff) [30.0 kB] 99s gpgv: Signature made Wed Nov 27 17:13:16 2024 UTC 99s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 99s gpgv: Can't check signature: No public key 99s dpkg-source: warning: cannot verify signature ./postgresql-14_14.15-0ubuntu0.22.04.1.dsc 100s autopkgtest [13:48:43]: testing package postgresql-14 version 14.15-0ubuntu0.22.04.1 102s autopkgtest [13:48:45]: build not needed 112s autopkgtest [13:48:55]: test run-testsuite: preparing testbed 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 The following NEW packages will be installed: 113s build-essential clang-14 cpp cpp-11 dictionaries-common emacsen-common g++ 113s g++-11 gcc gcc-11 gcc-11-base hunspell-en-us icu-devtools libasan6 113s libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-14-dev 113s libclang-cpp14 libclang1-14 libcrypt-dev libecpg-compat3 libecpg-dev 113s libecpg6 libffi-dev libgc1 libgcc-11-dev libgomp1 libicu-dev libisl23 113s libitm1 libjson-perl libllvm14 liblsan0 libmpc3 libncurses-dev libnsl-dev 113s libobjc-11-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.10 113s libquadmath0 libssl-dev libstdc++-11-dev libtinfo-dev libtirpc-dev libtsan0 113s libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-14 113s llvm-14-dev llvm-14-linker-tools llvm-14-runtime llvm-14-tools net-tools 113s postgresql-14 postgresql-client-14 postgresql-client-common 113s postgresql-common postgresql-doc-14 postgresql-plperl-14 113s postgresql-plpython3-14 postgresql-pltcl-14 postgresql-server-dev-14 113s python3-pygments rpcsvc-proto ssl-cert 113s 0 upgraded, 75 newly installed, 0 to remove and 0 not upgraded. 113s Need to get 205 MB of archives. 113s After this operation, 1036 MB of additional disk space will be used. 113s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc-dev-bin ppc64el 2.35-0ubuntu3.9 [21.4 kB] 113s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el linux-libc-dev ppc64el 5.15.0-133.144 [1290 kB] 113s Get:3 http://ftpmaster.internal/ubuntu jammy/main ppc64el libcrypt-dev ppc64el 1:4.4.27-1 [142 kB] 113s Get:4 http://ftpmaster.internal/ubuntu jammy/main ppc64el rpcsvc-proto ppc64el 1.4.2-0ubuntu6 [82.3 kB] 113s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtirpc-dev ppc64el 1.3.2-2ubuntu0.1 [223 kB] 113s Get:6 http://ftpmaster.internal/ubuntu jammy/main ppc64el libnsl-dev ppc64el 1.3.0-2build2 [80.0 kB] 113s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc6-dev ppc64el 2.35-0ubuntu3.9 [2053 kB] 113s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el gcc-11-base ppc64el 11.4.0-1ubuntu1~22.04 [20.3 kB] 113s Get:9 http://ftpmaster.internal/ubuntu jammy/main ppc64el libisl23 ppc64el 0.24-2build1 [833 kB] 113s Get:10 http://ftpmaster.internal/ubuntu jammy/main ppc64el libmpc3 ppc64el 1.2.1-2build1 [52.2 kB] 113s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el cpp-11 ppc64el 11.4.0-1ubuntu1~22.04 [8800 kB] 114s Get:12 http://ftpmaster.internal/ubuntu jammy/main ppc64el cpp ppc64el 4:11.2.0-1ubuntu1 [27.7 kB] 114s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libcc1-0 ppc64el 12.3.0-1ubuntu1~22.04 [49.5 kB] 114s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgomp1 ppc64el 12.3.0-1ubuntu1~22.04 [140 kB] 114s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libitm1 ppc64el 12.3.0-1ubuntu1~22.04 [32.9 kB] 114s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libatomic1 ppc64el 12.3.0-1ubuntu1~22.04 [10.6 kB] 114s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libasan6 ppc64el 11.4.0-1ubuntu1~22.04 [2303 kB] 114s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el liblsan0 ppc64el 12.3.0-1ubuntu1~22.04 [1090 kB] 114s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtsan0 ppc64el 11.4.0-1ubuntu1~22.04 [2278 kB] 114s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libubsan1 ppc64el 12.3.0-1ubuntu1~22.04 [1001 kB] 114s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libquadmath0 ppc64el 12.3.0-1ubuntu1~22.04 [156 kB] 114s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgcc-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [1477 kB] 114s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el gcc-11 ppc64el 11.4.0-1ubuntu1~22.04 [17.7 MB] 115s Get:24 http://ftpmaster.internal/ubuntu jammy/main ppc64el gcc ppc64el 4:11.2.0-1ubuntu1 [5152 B] 115s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libstdc++-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [2197 kB] 115s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el g++-11 ppc64el 11.4.0-1ubuntu1~22.04 [10.2 MB] 115s Get:27 http://ftpmaster.internal/ubuntu jammy/main ppc64el g++ ppc64el 4:11.2.0-1ubuntu1 [1408 B] 115s Get:28 http://ftpmaster.internal/ubuntu jammy/main ppc64el build-essential ppc64el 12.9ubuntu3 [4752 B] 115s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libllvm14 ppc64el 1:14.0.0-1ubuntu1.1 [24.7 MB] 115s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang-cpp14 ppc64el 1:14.0.0-1ubuntu1.1 [12.5 MB] 116s Get:31 http://ftpmaster.internal/ubuntu jammy/main ppc64el libgc1 ppc64el 1:8.0.6-1.1build1 [109 kB] 116s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc4 ppc64el 12.3.0-1ubuntu1~22.04 [54.3 kB] 116s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [223 kB] 116s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang-common-14-dev ppc64el 1:14.0.0-1ubuntu1.1 [4252 kB] 116s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-linker-tools ppc64el 1:14.0.0-1ubuntu1.1 [1401 kB] 116s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang1-14 ppc64el 1:14.0.0-1ubuntu1.1 [7447 kB] 116s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el clang-14 ppc64el 1:14.0.0-1ubuntu1.1 [81.3 kB] 116s Get:38 http://ftpmaster.internal/ubuntu jammy/main ppc64el emacsen-common all 3.0.4 [14.9 kB] 116s Get:39 http://ftpmaster.internal/ubuntu jammy/main ppc64el dictionaries-common all 1.28.14 [185 kB] 116s Get:40 http://ftpmaster.internal/ubuntu jammy/main ppc64el hunspell-en-us all 1:2020.12.07-2 [280 kB] 116s Get:41 http://ftpmaster.internal/ubuntu jammy/main ppc64el icu-devtools ppc64el 70.1-2 [224 kB] 116s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpgtypes3 ppc64el 14.15-0ubuntu0.22.04.1 [53.8 kB] 116s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq5 ppc64el 14.15-0ubuntu0.22.04.1 [181 kB] 116s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg6 ppc64el 14.15-0ubuntu0.22.04.1 [55.2 kB] 116s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg-compat3 ppc64el 14.15-0ubuntu0.22.04.1 [14.2 kB] 116s Get:46 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libssl-dev ppc64el 3.0.2-0ubuntu1.19 [2611 kB] 116s Get:47 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq-dev ppc64el 14.15-0ubuntu0.22.04.1 [168 kB] 116s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg-dev ppc64el 14.15-0ubuntu0.22.04.1 [277 kB] 116s Get:49 http://ftpmaster.internal/ubuntu jammy/main ppc64el libicu-dev ppc64el 70.1-2 [12.2 MB] 117s Get:50 http://ftpmaster.internal/ubuntu jammy/main ppc64el libjson-perl all 4.04000-1 [81.8 kB] 117s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libncurses-dev ppc64el 6.3-2ubuntu0.1 [481 kB] 117s Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpython3.10 ppc64el 3.10.12-1~22.04.9 [2150 kB] 117s Get:53 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtinfo-dev ppc64el 6.3-2ubuntu0.1 [778 B] 117s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxml2-dev ppc64el 2.9.13+dfsg-1ubuntu0.6 [923 kB] 117s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxslt1.1 ppc64el 1.1.34-4ubuntu0.22.04.1 [184 kB] 117s Get:56 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-runtime ppc64el 1:14.0.0-1ubuntu1.1 [509 kB] 117s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpfm4 ppc64el 4.11.1+git32-gd0b85fb-1ubuntu0.1 [166 kB] 117s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14 ppc64el 1:14.0.0-1ubuntu1.1 [12.6 MB] 117s Get:59 http://ftpmaster.internal/ubuntu jammy/main ppc64el libffi-dev ppc64el 3.4.2-4 [67.5 kB] 117s Get:60 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 117s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-tools ppc64el 1:14.0.0-1ubuntu1.1 [478 kB] 118s Get:62 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-4 ppc64el 4.8.12-1 [6066 kB] 118s Get:63 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-dev ppc64el 4.8.12-1 [72.2 kB] 118s Get:64 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-dev ppc64el 1:14.0.0-1ubuntu1.1 [39.0 MB] 119s Get:65 http://ftpmaster.internal/ubuntu jammy/main ppc64el net-tools ppc64el 1.60+git20181103.0eebece-1ubuntu5 [225 kB] 119s Get:66 http://ftpmaster.internal/ubuntu jammy/main ppc64el postgresql-client-common all 238 [29.6 kB] 119s Get:67 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-client-14 ppc64el 14.15-0ubuntu0.22.04.1 [1332 kB] 119s Get:68 http://ftpmaster.internal/ubuntu jammy/main ppc64el ssl-cert all 1.1.2 [17.4 kB] 119s Get:69 http://ftpmaster.internal/ubuntu jammy/main ppc64el postgresql-common all 238 [169 kB] 119s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-14 ppc64el 14.15-0ubuntu0.22.04.1 [17.4 MB] 120s Get:71 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 120s Get:72 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-plperl-14 ppc64el 14.15-0ubuntu0.22.04.1 [79.2 kB] 120s Get:73 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-plpython3-14 ppc64el 14.15-0ubuntu0.22.04.1 [85.8 kB] 120s Get:74 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-pltcl-14 ppc64el 14.15-0ubuntu0.22.04.1 [35.8 kB] 120s Get:75 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el postgresql-server-dev-14 ppc64el 14.15-0ubuntu0.22.04.1 [1219 kB] 121s Preconfiguring packages ... 121s Fetched 205 MB in 8s (26.6 MB/s) 121s Selecting previously unselected package libc-dev-bin. 121s (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 ... 66539 files and directories currently installed.) 121s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_ppc64el.deb ... 121s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 121s Selecting previously unselected package linux-libc-dev:ppc64el. 121s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_ppc64el.deb ... 121s Unpacking linux-libc-dev:ppc64el (5.15.0-133.144) ... 121s Selecting previously unselected package libcrypt-dev:ppc64el. 121s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_ppc64el.deb ... 121s Unpacking libcrypt-dev:ppc64el (1:4.4.27-1) ... 121s Selecting previously unselected package rpcsvc-proto. 121s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_ppc64el.deb ... 121s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 121s Selecting previously unselected package libtirpc-dev:ppc64el. 121s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_ppc64el.deb ... 121s Unpacking libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... 121s Selecting previously unselected package libnsl-dev:ppc64el. 121s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_ppc64el.deb ... 121s Unpacking libnsl-dev:ppc64el (1.3.0-2build2) ... 121s Selecting previously unselected package libc6-dev:ppc64el. 121s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_ppc64el.deb ... 121s Unpacking libc6-dev:ppc64el (2.35-0ubuntu3.9) ... 121s Selecting previously unselected package gcc-11-base:ppc64el. 121s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 121s Unpacking gcc-11-base:ppc64el (11.4.0-1ubuntu1~22.04) ... 121s Selecting previously unselected package libisl23:ppc64el. 121s Preparing to unpack .../08-libisl23_0.24-2build1_ppc64el.deb ... 121s Unpacking libisl23:ppc64el (0.24-2build1) ... 122s Selecting previously unselected package libmpc3:ppc64el. 122s Preparing to unpack .../09-libmpc3_1.2.1-2build1_ppc64el.deb ... 122s Unpacking libmpc3:ppc64el (1.2.1-2build1) ... 122s Selecting previously unselected package cpp-11. 122s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package cpp. 122s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 122s Unpacking cpp (4:11.2.0-1ubuntu1) ... 122s Selecting previously unselected package libcc1-0:ppc64el. 122s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libcc1-0:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libgomp1:ppc64el. 122s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libgomp1:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libitm1:ppc64el. 122s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libitm1:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libatomic1:ppc64el. 122s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libatomic1:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libasan6:ppc64el. 122s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libasan6:ppc64el (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package liblsan0:ppc64el. 122s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking liblsan0:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libtsan0:ppc64el. 122s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libtsan0:ppc64el (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libubsan1:ppc64el. 122s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libubsan1:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libquadmath0:ppc64el. 122s Preparing to unpack .../20-libquadmath0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libquadmath0:ppc64el (12.3.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package libgcc-11-dev:ppc64el. 122s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libgcc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package gcc-11. 122s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package gcc. 122s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 122s Unpacking gcc (4:11.2.0-1ubuntu1) ... 122s Selecting previously unselected package libstdc++-11-dev:ppc64el. 122s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking libstdc++-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 122s Selecting previously unselected package g++-11. 122s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 122s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 123s Selecting previously unselected package g++. 123s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 123s Unpacking g++ (4:11.2.0-1ubuntu1) ... 123s Selecting previously unselected package build-essential. 123s Preparing to unpack .../27-build-essential_12.9ubuntu3_ppc64el.deb ... 123s Unpacking build-essential (12.9ubuntu3) ... 123s Selecting previously unselected package libllvm14:ppc64el. 123s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 123s Unpacking libllvm14:ppc64el (1:14.0.0-1ubuntu1.1) ... 123s Selecting previously unselected package libclang-cpp14. 123s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 123s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 123s Selecting previously unselected package libgc1:ppc64el. 123s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_ppc64el.deb ... 123s Unpacking libgc1:ppc64el (1:8.0.6-1.1build1) ... 123s Selecting previously unselected package libobjc4:ppc64el. 123s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 123s Unpacking libobjc4:ppc64el (12.3.0-1ubuntu1~22.04) ... 123s Selecting previously unselected package libobjc-11-dev:ppc64el. 123s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 123s Unpacking libobjc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 123s Selecting previously unselected package libclang-common-14-dev. 123s Preparing to unpack .../33-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 123s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 124s Selecting previously unselected package llvm-14-linker-tools. 124s Preparing to unpack .../34-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 124s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 124s Selecting previously unselected package libclang1-14. 124s Preparing to unpack .../35-libclang1-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 124s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 124s Selecting previously unselected package clang-14. 124s Preparing to unpack .../36-clang-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 124s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 124s Selecting previously unselected package emacsen-common. 124s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 124s Unpacking emacsen-common (3.0.4) ... 124s Selecting previously unselected package dictionaries-common. 124s Preparing to unpack .../38-dictionaries-common_1.28.14_all.deb ... 124s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 124s Unpacking dictionaries-common (1.28.14) ... 124s Selecting previously unselected package hunspell-en-us. 124s Preparing to unpack .../39-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 124s Unpacking hunspell-en-us (1:2020.12.07-2) ... 124s Selecting previously unselected package icu-devtools. 124s Preparing to unpack .../40-icu-devtools_70.1-2_ppc64el.deb ... 124s Unpacking icu-devtools (70.1-2) ... 124s Selecting previously unselected package libpgtypes3:ppc64el. 124s Preparing to unpack .../41-libpgtypes3_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libpgtypes3:ppc64el (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libpq5:ppc64el. 124s Preparing to unpack .../42-libpq5_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libpq5:ppc64el (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libecpg6:ppc64el. 124s Preparing to unpack .../43-libecpg6_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libecpg6:ppc64el (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libecpg-compat3:ppc64el. 124s Preparing to unpack .../44-libecpg-compat3_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libecpg-compat3:ppc64el (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libssl-dev:ppc64el. 124s Preparing to unpack .../45-libssl-dev_3.0.2-0ubuntu1.19_ppc64el.deb ... 124s Unpacking libssl-dev:ppc64el (3.0.2-0ubuntu1.19) ... 124s Selecting previously unselected package libpq-dev. 124s Preparing to unpack .../46-libpq-dev_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libecpg-dev. 124s Preparing to unpack .../47-libecpg-dev_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 124s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 124s Selecting previously unselected package libicu-dev:ppc64el. 124s Preparing to unpack .../48-libicu-dev_70.1-2_ppc64el.deb ... 124s Unpacking libicu-dev:ppc64el (70.1-2) ... 125s Selecting previously unselected package libjson-perl. 125s Preparing to unpack .../49-libjson-perl_4.04000-1_all.deb ... 125s Unpacking libjson-perl (4.04000-1) ... 125s Selecting previously unselected package libncurses-dev:ppc64el. 125s Preparing to unpack .../50-libncurses-dev_6.3-2ubuntu0.1_ppc64el.deb ... 125s Unpacking libncurses-dev:ppc64el (6.3-2ubuntu0.1) ... 125s Selecting previously unselected package libpython3.10:ppc64el. 125s Preparing to unpack .../51-libpython3.10_3.10.12-1~22.04.9_ppc64el.deb ... 125s Unpacking libpython3.10:ppc64el (3.10.12-1~22.04.9) ... 125s Selecting previously unselected package libtinfo-dev:ppc64el. 125s Preparing to unpack .../52-libtinfo-dev_6.3-2ubuntu0.1_ppc64el.deb ... 125s Unpacking libtinfo-dev:ppc64el (6.3-2ubuntu0.1) ... 125s Selecting previously unselected package libxml2-dev:ppc64el. 125s Preparing to unpack .../53-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_ppc64el.deb ... 125s Unpacking libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.6) ... 125s Selecting previously unselected package libxslt1.1:ppc64el. 125s Preparing to unpack .../54-libxslt1.1_1.1.34-4ubuntu0.22.04.1_ppc64el.deb ... 125s Unpacking libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... 125s Selecting previously unselected package llvm-14-runtime. 125s Preparing to unpack .../55-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 125s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 125s Selecting previously unselected package libpfm4:ppc64el. 125s Preparing to unpack .../56-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_ppc64el.deb ... 125s Unpacking libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 125s Selecting previously unselected package llvm-14. 125s Preparing to unpack .../57-llvm-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 125s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 125s Selecting previously unselected package libffi-dev:ppc64el. 125s Preparing to unpack .../58-libffi-dev_3.4.2-4_ppc64el.deb ... 125s Unpacking libffi-dev:ppc64el (3.4.2-4) ... 125s Selecting previously unselected package python3-pygments. 125s Preparing to unpack .../59-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 125s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 125s Selecting previously unselected package llvm-14-tools. 125s Preparing to unpack .../60-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 125s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 125s Selecting previously unselected package libz3-4:ppc64el. 125s Preparing to unpack .../61-libz3-4_4.8.12-1_ppc64el.deb ... 125s Unpacking libz3-4:ppc64el (4.8.12-1) ... 125s Selecting previously unselected package libz3-dev:ppc64el. 125s Preparing to unpack .../62-libz3-dev_4.8.12-1_ppc64el.deb ... 125s Unpacking libz3-dev:ppc64el (4.8.12-1) ... 125s Selecting previously unselected package llvm-14-dev. 125s Preparing to unpack .../63-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 125s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 127s Selecting previously unselected package net-tools. 127s Preparing to unpack .../64-net-tools_1.60+git20181103.0eebece-1ubuntu5_ppc64el.deb ... 127s Unpacking net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 127s Selecting previously unselected package postgresql-client-common. 127s Preparing to unpack .../65-postgresql-client-common_238_all.deb ... 127s Unpacking postgresql-client-common (238) ... 127s Selecting previously unselected package postgresql-client-14. 127s Preparing to unpack .../66-postgresql-client-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 127s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 127s Selecting previously unselected package ssl-cert. 127s Preparing to unpack .../67-ssl-cert_1.1.2_all.deb ... 127s Unpacking ssl-cert (1.1.2) ... 127s Selecting previously unselected package postgresql-common. 127s Preparing to unpack .../68-postgresql-common_238_all.deb ... 127s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 127s Unpacking postgresql-common (238) ... 127s Selecting previously unselected package postgresql-14. 127s Preparing to unpack .../69-postgresql-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 127s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 127s Selecting previously unselected package postgresql-doc-14. 127s Preparing to unpack .../70-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 127s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 128s Selecting previously unselected package postgresql-plperl-14. 128s Preparing to unpack .../71-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 128s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 128s Selecting previously unselected package postgresql-plpython3-14. 128s Preparing to unpack .../72-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 128s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 128s Selecting previously unselected package postgresql-pltcl-14. 128s Preparing to unpack .../73-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 128s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 128s Selecting previously unselected package postgresql-server-dev-14. 128s Preparing to unpack .../74-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 128s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 128s Setting up postgresql-client-common (238) ... 128s Setting up libpgtypes3:ppc64el (14.15-0ubuntu0.22.04.1) ... 128s Setting up gcc-11-base:ppc64el (11.4.0-1ubuntu1~22.04) ... 128s Setting up libpython3.10:ppc64el (3.10.12-1~22.04.9) ... 128s Setting up net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 128s Setting up libpq5:ppc64el (14.15-0ubuntu0.22.04.1) ... 128s Setting up linux-libc-dev:ppc64el (5.15.0-133.144) ... 128s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 128s update-alternatives: using /usr/share/postgresql/14/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 128s Setting up libgomp1:ppc64el (12.3.0-1ubuntu1~22.04) ... 128s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 128s update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 128s Setting up libffi-dev:ppc64el (3.4.2-4) ... 128s Setting up libasan6:ppc64el (11.4.0-1ubuntu1~22.04) ... 128s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 129s Setting up libz3-4:ppc64el (4.8.12-1) ... 129s Setting up libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... 129s Setting up libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 129s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 129s Setting up emacsen-common (3.0.4) ... 129s Setting up ssl-cert (1.1.2) ... 130s Setting up libquadmath0:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up libssl-dev:ppc64el (3.0.2-0ubuntu1.19) ... 130s Setting up libmpc3:ppc64el (1.2.1-2build1) ... 130s Setting up libatomic1:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up icu-devtools (70.1-2) ... 130s Setting up libgc1:ppc64el (1:8.0.6-1.1build1) ... 130s Setting up libubsan1:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up libllvm14:ppc64el (1:14.0.0-1ubuntu1.1) ... 130s Setting up libnsl-dev:ppc64el (1.3.0-2build2) ... 130s Setting up libcrypt-dev:ppc64el (1:4.4.27-1) ... 130s Setting up libjson-perl (4.04000-1) ... 130s Setting up libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... 130s Setting up libecpg6:ppc64el (14.15-0ubuntu0.22.04.1) ... 130s Setting up libisl23:ppc64el (0.24-2build1) ... 130s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 130s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 130s Setting up libcc1-0:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up liblsan0:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up libitm1:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up libtsan0:ppc64el (11.4.0-1ubuntu1~22.04) ... 130s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 130s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 130s Setting up libz3-dev:ppc64el (4.8.12-1) ... 130s Setting up libecpg-compat3:ppc64el (14.15-0ubuntu0.22.04.1) ... 130s Setting up dictionaries-common (1.28.14) ... 130s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 130s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 130s Setting up libobjc4:ppc64el (12.3.0-1ubuntu1~22.04) ... 130s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 130s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 130s Setting up postgresql-common (238) ... 130s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 130s Adding user postgres to group ssl-cert 130s 130s Creating config file /etc/postgresql-common/createcluster.conf with new version 130s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 130s en_us 130s Removing obsolete dictionary files: 131s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 131s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 131s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 131s Setting up libgcc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 131s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 131s Setting up cpp (4:11.2.0-1ubuntu1) ... 131s Setting up hunspell-en-us (1:2020.12.07-2) ... 131s Setting up libc6-dev:ppc64el (2.35-0ubuntu3.9) ... 131s Setting up libicu-dev:ppc64el (70.1-2) ... 131s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 131s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 132s Creating new PostgreSQL cluster 14/main ... 132s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 132s The files belonging to this database system will be owned by user "postgres". 132s This user must also own the server process. 132s 132s The database cluster will be initialized with locale "C.UTF-8". 132s The default database encoding has accordingly been set to "UTF8". 132s The default text search configuration will be set to "english". 132s 132s Data page checksums are disabled. 132s 132s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 132s creating subdirectories ... ok 132s selecting dynamic shared memory implementation ... posix 132s selecting default max_connections ... 100 132s selecting default shared_buffers ... 128MB 132s selecting default time zone ... Etc/UTC 132s creating configuration files ... ok 132s running bootstrap script ... ok 132s performing post-bootstrap initialization ... ok 132s syncing data to disk ... ok 133s update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 135s Setting up libncurses-dev:ppc64el (6.3-2ubuntu0.1) ... 135s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 135s Setting up libobjc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 135s Setting up gcc (4:11.2.0-1ubuntu1) ... 135s Setting up libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.6) ... 135s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 136s Setting up libstdc++-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 136s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 136s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 136s Setting up libtinfo-dev:ppc64el (6.3-2ubuntu0.1) ... 136s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 136s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 136s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 136s Setting up g++ (4:11.2.0-1ubuntu1) ... 136s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 136s Setting up build-essential (12.9ubuntu3) ... 136s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 136s Processing triggers for man-db (2.10.2-1) ... 136s Processing triggers for install-info (6.8-4build1) ... 136s Processing triggers for dictionaries-common (1.28.14) ... 139s autopkgtest [13:49:22]: test run-testsuite: [----------------------- 140s Generating locales (this might take a while)... 141s en_US.UTF-8... done 141s ru_RU.ISO-8859-5... done 143s ru_RU.UTF-8... done 143s Generation complete. 143s ====== Running all tests with umask 077 ======= 143s === Running test 001_packages.t ... === 143s 1..21 143s ok 1 - /etc/os-release exists 143s ok 2 - OS is ubuntu 143s ok 3 - OS version is 22.04 143s # PostgreSQL versions installed: 14 143s ok 4 - postgresql-14 installed 143s ok 5 # skip No python2 support 143s ok 6 - postgresql-plpython3-14 installed 143s ok 7 - postgresql-plperl-14 installed 143s ok 8 - postgresql-pltcl-14 installed 143s ok 9 - postgresql-server-dev-14 installed 143s ok 10 # skip No postgresql-contrib-14 package for version 14 143s ok 11 - libecpg-dev installed 143s ok 12 - procps installed 143s ok 13 - netcat-openbsd installed 143s ok 14 - hunspell-en-us installed 143s ok 15 - system has a default UTF-8 locale 143s ok 16 - locale ru_RU exists 143s ok 17 - locale ru_RU.UTF-8 exists 143s ok 18 - user postgres in the UNIX group ssl-cert 143s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 143s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 143s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 143s === Running test 002_existing_clusters.t ... === 144s 1..8 144s # Cleanup 144s ok 1 - Cleanup: No clusters left behind 144s ok 2 - No postgres processes left behind 144s ok 3 - No files in /etc/postgresql left behind 144s ok 4 - No files in /var/lib/postgresql left behind 144s ok 5 - No files in /var/run/postgresql left behind 144s ok 6 - No files in /var/log/postgresql left behind 144s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 144s ok 8 - PostgreSQL TCP ports are closed 144s === Running test 005_PgCommon.t ... === 144s 1..24 144s ok 1 - correctly parsed line 'local all postgres ident sameuser' 144s ok 2 - correctly parsed line 'local foo nobody trust' 144s ok 3 - correctly parsed line 'local foo nobody crypt' 144s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 144s ok 5 - correctly parsed line 'local foo,bar nobody ident' 144s ok 6 - correctly parsed line 'local all +foogrp password' 144s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 144s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 144s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 144s ok 10 - @expected_records has correct number of entries 144s ok 11 - returned read_pg_hba array has correct number of records 144s ok 12 - line 'foo all all md5' parsed as invalid 144s ok 13 - line 'local all all foo' parsed as invalid 144s ok 14 - line 'host all all foo' parsed as invalid 144s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 144s ok 16 - line 'host all all md5' parsed as invalid 144s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 144s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 144s ok 19 - read_conf_file returns empty dict for nonexisting file 144s ok 20 - read_conf_file() parsing 144s ok 21 - read_conf_file() parsing with include directives 144s ok 22 - set_conf_value 144s ok 23 - disable_conf_value 144s ok 24 - replace_conf_value 144s === Running test 006_next_free_port.t ... === 144s 1..5 144s ok 1 - next_free_port is 5432 145s ok 2 - next_free_port detects localhost ipv4 socket 146s ok 3 - next_free_port detects wildcard ipv4 socket 147s ok 4 - next_free_port detects localhost ipv6 socket 148s ok 5 - next_free_port detects wildcard ipv6 socket 148s === Running test 007_pg_conftool.t ... === 148s 1..41 148s # test without cluster 148s ok 1 - pg_conftool show all 148s ok 2 - correct output of pg_conftool show all 148s ok 3 - pg_conftool foo.conf show all 148s ok 4 - correct output of pg_conftool foo.conf show all 148s ok 5 - pg_conftool /tmp/_L2aJZHBVg/different.conf show all 148s ok 6 - correct output of pg_conftool /tmp/_L2aJZHBVg/different.conf show all 148s ok 7 - pg_conftool 9.7 main show all 148s ok 8 - correct output of pg_conftool 9.7 main show all 148s # test show 148s ok 9 - pg_conftool show all 148s ok 10 - correct output of pg_conftool show all 148s ok 11 - pg_conftool other.conf show all 148s ok 12 - correct output of pg_conftool other.conf show all 148s ok 13 - pg_conftool /tmp/_L2aJZHBVg/different.conf show all 148s ok 14 - correct output of pg_conftool /tmp/_L2aJZHBVg/different.conf show all 148s ok 15 - pg_conftool 14 main show all 148s ok 16 - correct output of pg_conftool 14 main show all 148s ok 17 - pg_conftool 14 main other.conf show all 148s ok 18 - correct output of pg_conftool 14 main other.conf show all 148s ok 19 - pg_conftool show a 148s ok 20 - correct output of pg_conftool show a 148s ok 21 - pg_conftool -s show a 148s ok 22 - correct output of pg_conftool -s show a 148s # test set 148s ok 23 - pg_conftool set c 7 148s ok 24 - correct output of pg_conftool set c 7 148s ok 25 - file contains new setting 148s ok 26 - pg_conftool set a 8 148s ok 27 - correct output of pg_conftool set a 8 148s ok 28 - file contains updated setting 148s ok 29 - pg_conftool /tmp/_L2aJZHBVg/different.conf set a 9 148s ok 30 - correct output of pg_conftool /tmp/_L2aJZHBVg/different.conf set a 9 148s ok 31 - file with path contains updated setting 148s # test remove 149s ok 32 - pg_conftool remove a 149s ok 33 - correct output of pg_conftool remove a 149s ok 34 - setting removed from file 149s ok 35 - pg_conftool /tmp/_L2aJZHBVg/different.conf remove a 149s ok 36 - correct output of pg_conftool /tmp/_L2aJZHBVg/different.conf remove a 149s ok 37 - setting removed from file with path 149s # test edit 149s ok 38 - pg_conftool edit 149s ok 39 - correct output of pg_conftool edit 149s ok 40 - pg_conftool /tmp/_L2aJZHBVg/different.conf edit 149s ok 41 - correct output of pg_conftool /tmp/_L2aJZHBVg/different.conf edit 149s === Running test 010_defaultport_cluster.t ... === 149s 1..14 149s ok 1 - psql --version 149s ok 2 - pg_wrapper selects highest available version number 149s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 149s ok 4 - connecting to localhost fails with no clusters 149s ok 5 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -l 149s ok 6 - pg_wrapper uses host and port from PGCLUSTER 149s ok 7 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --cluster 14/127.0.0.3:5430 -l 149s ok 8 - pg_wrapper uses --cluster from the command line 149s ok 9 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -h 127.0.0.3 -l 149s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 149s ok 11 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --host 127.0.0.3 -l 149s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 149s ok 13 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 149s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 149s === Running test 012_maintscripts.t ... === 149s 1..14 149s # We are running systemd 152s ok 1 - pg_createcluster 14 main --start 152s ok 2 - postmaster PID is 5307 154s ok 3 - dpkg-reconfigure --frontend=noninteractive postgresql-common 154s ok 4 - postmaster PID is 5307 154s ok 5 - postmaster was not restarted 155s ok 6 - pg_dropcluster 14 main --stop 155s # Cleanup 155s ok 7 - Cleanup: No clusters left behind 155s ok 8 - No postgres processes left behind 155s ok 9 - No files in /etc/postgresql left behind 155s ok 10 - No files in /var/lib/postgresql left behind 155s ok 11 - No files in /var/run/postgresql left behind 155s ok 12 - No files in /var/log/postgresql left behind 155s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 155s ok 14 - PostgreSQL TCP ports are closed 155s === Running test 015_start_stop.t ... === 155s 1..71 155s # We are running systemd 155s # Running tests for 14 155s # Cluster does not exist yet 155s ok 1 - cluster 14 main does not exist 155s ok 2 - service postgresql@14-main does not exist 155s ok 3 - systemctl start postgresql 155s ok 4 - cluster 14 main does not exist 155s ok 5 - service postgresql@14-main does not exist 155s ok 6 - systemctl start postgresql@14-main 156s ok 7 - cluster 14 main does not exist 156s ok 8 - service postgresql@14-main does not exist 156s # Start/stop postgresql using system tools 157s ok 9 - pg_createcluster 14 main 157s ok 10 - cluster 14 main is stopped 157s ok 11 - service postgresql@14-main is stopped 159s ok 12 - systemctl start postgresql 159s ok 13 - cluster 14 main is running 159s ok 14 - service postgresql@14-main is running 159s ok 15 - systemctl start postgresql 159s ok 16 - cluster 14 main is already running 159s ok 17 - service postgresql@14-main is already running 159s ok 18 - systemctl stop postgresql 165s ok 19 - cluster 14 main is stopped 165s ok 20 - service postgresql@14-main is stopped 165s ok 21 - systemctl stop postgresql 165s ok 22 - cluster 14 main is already stopped 165s ok 23 - service postgresql@14-main is already stopped 165s # Start/stop specific cluster using system tools 167s ok 24 - systemctl start postgresql@14-main 167s ok 25 - cluster 14 main is running 167s ok 26 - service postgresql@14-main is running 167s ok 27 - systemctl start postgresql@14-main 167s ok 28 - cluster 14 main is running 167s ok 29 - service postgresql@14-main is running 170s ok 30 - systemctl restart postgresql@14-main 170s ok 31 - cluster 14 main is running 170s ok 32 - service postgresql@14-main is running 170s ok 33 - systemctl stop postgresql@14-main 170s ok 34 - cluster 14 main is stopped 170s ok 35 - service postgresql@14-main is stopped 170s ok 36 - systemctl stop postgresql@14-main 170s ok 37 - cluster 14 main is already stopped 170s ok 38 - service postgresql@14-main is already stopped 171s ok 39 - pg_dropcluster 14 main 171s ok 40 - cluster 14 main does not exist 171s ok 41 - service postgresql@14-main does not exist 171s # Start/stop specific cluster using pg_*cluster 171s ok 42 - pg_ctlcluster start 14 main 171s ok 43 - cluster 14 main does not exist 171s ok 44 - service postgresql@14-main does not exist 175s ok 45 - pg_createcluster 14 main --start 175s ok 46 - cluster 14 main is running 175s ok 47 - service postgresql@14-main is running 175s ok 48 - pg_ctlcluster 14 main start 175s ok 49 - cluster 14 main is already running 175s ok 50 - service postgresql@14-main is already running 177s ok 51 - pg_ctlcluster 14-main restart 177s ok 52 - cluster 14 main is running 178s ok 53 - service postgresql@14-main is running 178s ok 54 - pg_ctlcluster 14 main stop 178s ok 55 - cluster 14 main is stopped 178s ok 56 - service postgresql@14-main is stopped 178s ok 57 - pg_ctlcluster 14 main stop 178s ok 58 - cluster 14 main is already stopped 178s ok 59 - service postgresql@14-main is already stopped 180s ok 60 - pg_ctlcluster start 14-main 180s ok 61 - cluster 14 main is running 180s ok 62 - service postgresql@14-main is running 182s ok 63 - pg_dropcluster 14 main --stop 182s # Cleanup 182s ok 64 - Cleanup: No clusters left behind 182s ok 65 - No postgres processes left behind 182s ok 66 - No files in /etc/postgresql left behind 182s ok 67 - No files in /var/lib/postgresql left behind 182s ok 68 - No files in /var/run/postgresql left behind 182s ok 69 - No files in /var/log/postgresql left behind 182s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 182s ok 71 - PostgreSQL TCP ports are closed 182s === Running test 020_create_sql_remove.t ... === 182s 1..147 182s # Running tests for 14 185s ok 1 - pg_createcluster 14 main --start -- -X /tmp/14.xlog.hTTChw 185s ok 2 - pg_createcluster 14 main 185s ok 3 - Socket and pid file are in /var/run/postgresql/ 185s ok 4 - xlog/wal directory /tmp/14.xlog.hTTChw was created 185s ok 5 - local method in pg_hba.conf is peer 185s ok 6 - host method in pg_hba.conf is scram-sha-256 185s ok 7 - Exactly one postgres master process running 188s ok 8 - pg_ctlcluster 14 main restart 188s ok 9 - cluster restarts with new environment file 188s ok 10 - Exactly one postgres master process running 188s ok 11 - correct value of PGEXTRAVAR1 in environment 188s ok 12 - correct value of PGEXTRAVAR2 in environment 188s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 188s ok 14 - createdb --version 188s ok 15 - pg_wrapper selects version number of cluster 188s ok 16 - psql --version 188s ok 17 - pg_wrapper selects version number of cluster 188s ok 18 - pg_lscluster reports online cluster on port 5432 188s ok 19 - log file is actually used 188s ok 20 - /etc/postgresql is owned by user "postgres" 188s ok 21 - version configuration directory file is owned by user "postgres" 188s ok 22 - configuration directory file is owned by user "postgres" 188s ok 23 - version data directory file is owned by user "postgres" 188s ok 24 - data directory file is owned by user "postgres" 188s ok 25 - log file has 0640 permissions 188s ok 26 - log file is owned by user "postgres" 188s ok 27 - log file is owned by group "adm" 188s ok 28 - no log symlink by default 188s ok 29 - /var/log/postgresql/postgresql-14-main.log is the default log if log symlink is missing 188s ok 30 - pg_lsclusters -h 188s ok 31 - correct output of pg_lsclusters -h 188s ok 32 - stopping cluster 191s ok 33 - restarting cluster with nondefault log symlink 191s ok 34 - log target is used as log file 191s ok 35 - default log is not used 191s ok 36 - pg_lsclusters -h 191s ok 37 - correct output of pg_lsclusters -h 191s ok 38 - stopping cluster 194s ok 39 - restarting cluster with explicitly configured log file 194s ok 40 - default log is not used 194s ok 41 - log symlink target is used for startup message 194s ok 42 - exactly one log file 194s ok 43 - custom log is actually used 194s ok 44 - pg_lsclusters -h 194s ok 45 - correct output of pg_lsclusters -h 194s ok 46 - stopping cluster 194s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 194s ok 48 - /etc/postgres-hack was not created 196s ok 49 - restarting cluster 196s ok 50 - ps -o tty -U postgres h 196s ok 51 - postgres processes do not have an associated terminal 196s ok 52 - Server is linked with SSL support 196s ok 53 - SSL is enabled in postgresql.conf 196s ok 54 - psql -l fails for nobody 196s ok 55 - createuser nobody 196s ok 56 - createdb nobodydb 196s ok 57 - psql -ltA succeeds for nobody 196s ok 58 - psql -ltA output 196s ok 59 - SQL command: create table 196s ok 60 - SQL command: insert into table values 197s ok 61 - SQL command: insert into table values 197s ok 62 - primary key violation 197s ok 63 - psql -tAc "select * from phone order by name" nobodydb 197s ok 64 - SQL command output: select -tA 197s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 197s ok 66 - SQL command output: select -tx 197s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 197s ok 68 - SQL command output: select -tAx 197s ok 69 - CREATE EXTENSION plperlu fails for user nobody 197s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 197s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 197s ok 72 - creating PL/PerlU function as user nobody fails 197s ok 73 - creating unsafe PL/Perl function as user postgres fails 197s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 197s ok 75 - creating PL/PerlU function as user postgres succeeds 197s ok 76 - psql nobodydb -Atc "select read_file()" 197s ok 77 - calling PL/PerlU function 197s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 197s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 197s ok 80 - creating unsafe PL/Perl function as user nobody fails 197s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 197s ok 82 - creating PL/Perl function as user nobody succeeds 197s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 197s ok 84 - calling PL/Perl function 197s ok 85 # skip No python2 support 197s ok 86 # skip No python2 support 197s ok 87 # skip No python2 support 197s ok 88 # skip No python2 support 197s ok 89 # skip No python2 support 197s ok 90 # skip No python2 support 197s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 197s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 197s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 197s ok 94 - creating PL/Python3 function as user postgres succeeds 197s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 197s ok 96 - calling PL/Python function 197s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 197s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 198s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 198s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 198s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 198s ok 102 - creating PL/Tcl function as user nobody succeeds 198s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 198s ok 104 - creating PL/TclU function as user postgres succeeds 198s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 198s ok 106 - calling PL/Tcl function 198s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 198s ok 108 - calling PL/TclU function 198s ok 109 - stopping cluster 198s ok 110 - pg_ctlcluster 14 main start 198s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 200s ok 112 - pg_ctlcluster 14 main start 200s ok 113 - cluster restarts with pgdata symlink 201s ok 114 - postgres master has OOM killer protection 201s ok 115 - postgres client backend has no OOM adjustment 201s ok 116 - ps h 6848 201s ok 117 - process title is idle 201s ok 118 - ps h 6848 201s ok 119 - process title is idle in transaction 201s ok 120 - stopping cluster 204s ok 121 - starting cluster as postgres works without a log file 204s ok 122 - log file got recreated and used 204s ok 123 - creating a directory in spc2 204s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/14.spc1.MdvCtp'" 204s ok 125 - creating tablespace spc1 204s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 204s ok 127 - creating a table in spc1 204s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/14.spc2.LURzfF'" 204s ok 129 - creating tablespace spc2 204s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 204s ok 131 - creating a table in spc2 204s ok 132 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 204s ok 133 - Correct apt NeverAutoRemove config 205s ok 134 - pg_dropcluster removes cluster 205s ok 135 - xlog/wal directory /tmp/14.xlog.hTTChw was deleted 205s ok 136 - tablespace spc1 was emptied 205s ok 137 - tablespace spc2 was emptied 205s ok 138 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 205s ok 139 - Correct apt NeverAutoRemove config 205s # Cleanup 205s ok 140 - Cleanup: No clusters left behind 205s ok 141 - No postgres processes left behind 205s ok 142 - No files in /etc/postgresql left behind 205s ok 143 - No files in /var/lib/postgresql left behind 205s ok 144 - No files in /var/run/postgresql left behind 205s ok 145 - No files in /var/log/postgresql left behind 205s ok 146 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 205s ok 147 - PostgreSQL TCP ports are closed 205s === Running test 021_pg_renamecluster.t ... === 206s 1..20 209s ok 1 - pg_createcluster 14 main 212s ok 2 - pg_renamecluster 14 main donau 212s ok 3 - psql -tAc "show data_directory" 212s ok 4 - cluster is running and data_directory was moved 212s ok 5 - pg_hba.conf location updated 212s ok 6 - pg_ident.conf location updated 212s ok 7 - external_pid_file location updated 212s ok 8 - external_pid_file exists 212s ok 9 - stats_temp_directory location updated 212s ok 10 - stats_temp_directory exists 212s ok 11 - cluster_name is updated 214s ok 12 - pg_dropcluster removes cluster 214s # Cleanup 214s ok 13 - Cleanup: No clusters left behind 214s ok 14 - No postgres processes left behind 214s ok 15 - No files in /etc/postgresql left behind 214s ok 16 - No files in /var/lib/postgresql left behind 214s ok 17 - No files in /var/run/postgresql left behind 214s ok 18 - No files in /var/log/postgresql left behind 214s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 214s ok 20 - PostgreSQL TCP ports are closed 214s === Running test 022_recovery.t ... === 214s 1..17 214s # Running tests for 14 217s ok 1 - pg_createcluster 14 main --start >/dev/null 218s ok 2 - pg_ctlcluster 14 main stop -m i 220s ok 3 - pg_ctlcluster 14 main start 220s ok 4 - psql -c '' 220s ok 5 - pg_ctlcluster 14 main stop -m i 220s ok 6 - create write-protected file in data directory 222s ok 7 - pg_ctlcluster 14 main start 222s ok 8 - psql -c '' 224s ok 9 - pg_dropcluster removes cluster 224s # Cleanup 224s ok 10 - Cleanup: No clusters left behind 224s ok 11 - No postgres processes left behind 224s ok 12 - No files in /etc/postgresql left behind 224s ok 13 - No files in /var/lib/postgresql left behind 224s ok 14 - No files in /var/run/postgresql left behind 224s ok 15 - No files in /var/log/postgresql left behind 224s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 224s ok 17 - PostgreSQL TCP ports are closed 224s === Running test 025_logging.t ... === 224s 1..55 225s # Logging to /var/log/syslog works 225s # Running tests for 14 228s ok 1 - pg_createcluster 14 main 228s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-14-main.log 228s ok 3 - psql -qc "'foobar_14_7750'" 228s ok 4 - log an error 229s ok 5 - grep --binary-files=text foobar_14_7750 /var/log/postgresql/postgresql-14-main.log 229s ok 6 - error appears in logfile 229s ok 7 - pg_conftool 14 main set log_destination syslog 229s ok 8 - set log_destination syslog 229s ok 9 - pg_ctlcluster 14 main reload 229s ok 10 - 14 main reload 229s ok 11 - psql -Atc "show log_destination" 229s ok 12 - log_destination is syslog 229s ok 13 - pg_lscluster reports syslog 229s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 229s ok 15 - error appears in /var/log/syslog 229s ok 16 - pg_conftool 14 main set logging_collector on 229s ok 17 - set logging_collector on 229s ok 18 - pg_conftool 14 main set log_destination csvlog 229s ok 19 - set log_destination csvlog 232s ok 20 - pg_ctlcluster 14 main restart 232s ok 21 - 14 main restart 232s ok 22 - psql -Atc "show logging_collector" 232s ok 23 - logging_collector is on 232s ok 24 - psql -Atc "show log_destination" 232s ok 25 - log_destination is csvlog 232s ok 26 - pg_lscluster reports csvlog 232s ok 27 - psql -qc "'barbaz_14_7750'" 232s ok 28 - log an error 233s ok 29 - grep --binary-files=text barbaz_14_7750 /var/lib/postgresql/14/main/log/*.csv 233s ok 30 - error appears in log/*.csv 233s ok 31 - pg_conftool 14 main set log_destination stderr,syslog,csvlog 233s ok 32 - set log_destination stderr,syslog,csvlog 233s ok 33 - pg_ctlcluster 14 main reload 233s ok 34 - 14 main reload 233s ok 35 - psql -Atc "show log_destination" 233s ok 36 - log_destination is stderr,syslog,csvlog 233s ok 37 - pg_lscluster reports stderr,syslog,csvlog 233s ok 38 - psql -qc "'moo_14_7750'" 233s ok 39 - log an error 233s ok 40 - grep --binary-files=text moo_14_7750 /var/lib/postgresql/14/main/log/*.log 233s ok 41 - error appears in log/*.log 234s ok 42 - grep --binary-files=text 'postgres.*moo_14_7750' /var/log/syslog 234s ok 43 - error appears in /var/log/syslog 234s ok 44 - grep --binary-files=text moo_14_7750 /var/lib/postgresql/14/main/log/*.csv 234s ok 45 - error appears in log/*.csv 235s ok 46 - pg_dropcluster 14 main --stop 235s ok 47 - pg_dropcluster removes cluster 235s # Cleanup 235s ok 48 - Cleanup: No clusters left behind 235s ok 49 - No postgres processes left behind 235s ok 50 - No files in /etc/postgresql left behind 235s ok 51 - No files in /var/lib/postgresql left behind 235s ok 52 - No files in /var/run/postgresql left behind 235s ok 53 - No files in /var/log/postgresql left behind 235s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 235s ok 55 - PostgreSQL TCP ports are closed 235s === Running test 030_errors.t ... === 235s 1..156 236s ok 1 - pg_lscluster reports cluster without binaries 237s ok 2 - pg_dropcluster 6.3 main 238s ok 3 - pg_createcluster --socketdir 238s ok 4 - pg_lsclusters -h 238s ok 5 - cluster was created 238s ok 6 - Port of created cluster is 5432 238s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 14 main 238s ok 8 - pg_createcluster on existing cluster 238s ok 9 - pg_lsclusters -h 238s ok 10 - original cluster still exists 238s ok 11 - pg_createcluster 14 test -p foo 238s ok 12 - pg_createcluster -p checks that port option is numeric 238s ok 13 - pg_createcluster 14 test -p 42 238s ok 14 - pg_createcluster -p checks valid port range 238s ok 15 - pg_ctlcluster 14 main start 238s ok 16 - pg_ctlcluster refuses to start root-owned cluster 238s ok 17 - pg_ctlcluster 14 main start 238s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 238s ok 19 - pg_ctlcluster 14 main start 238s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 238s ok 21 - pg_ctlcluster 14 main start 238s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 241s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 241s ok 24 - No sockets in /var/run/postgresql 241s ok 25 - Socket is in /tmp/postgresql-testsuite/ 241s ok 26 - cluster stops with custom unix_socket_dir 241s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 243s ok 28 - cluster starts after removing unix_socket_dir 243s ok 29 - Socket is in default dir /var/run/postgresql 243s ok 30 - No sockets in /tmp/postgresql-testsuite/ 243s ok 31 - pg_ctlcluster 14 main stop 243s ok 32 - pg_ctlcluster fails with corrupted PID file 243s ok 33 - pg_lsclusters -h 243s ok 34 - cluster is still online 243s ok 35 - pg_ctlcluster succeeds with restored PID file 243s ok 36 - pg_lsclusters -h 243s ok 37 - cluster is down 243s ok 38 - pg_ctlcluster 14 main stop 243s ok 39 - pg_ctlcluster stop fails on stopped cluster 246s ok 40 - pg_ctlcluster 14 main start 246s ok 41 - pg_ctlcluster succeeds with already existing PID file 246s ok 42 - pg_lsclusters -h 246s ok 43 - cluster is online 246s ok 44 - pg_ctlcluster stop succeeds 246s ok 45 - pg_lsclusters -h 246s ok 46 - cluster is down 246s ok 47 - no pid file left 246s ok 48 - pg_ctlcluster 14 main stop 246s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 246s ok 50 - pid file was cleaned up 246s ok 51 - pg_ctlcluster --force 14 main stop 246s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 246s ok 53 - pid file was cleaned up 246s ok 54 - pg_ctlcluster 14 main stop 246s ok 55 - pg_ctlcluster stop succeeds with stale PID file 246s ok 56 - pid file was cleaned up 246s ok 57 - pg_ctlcluster --force 14 main stop 246s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 246s ok 59 - pid file was cleaned up 246s ok 60 - pg_ctlcluster --force 14 main stop 246s ok 61 - pg_ctlcluster stop succeeds with empty PID file 246s ok 62 - pid file was cleaned up 248s ok 63 - pg_ctlcluster 14 main start 248s ok 64 - pg_ctlcluster succeeds with corrupted PID file 248s ok 65 - pg_lsclusters -h 248s ok 66 - cluster is online 248s ok 67 - pg_ctlcluster 14 main start 248s ok 68 - pg_ctlcluster start fails on running cluster 249s ok 69 - pg_ctlcluster stop 249s ok 70 - pg_ctlcluster 14 main start 249s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 249s ok 72 - pg_ctlcluster 14 main stop 249s ok 73 - stopping cluster 255s ok 74 - pg_ctlcluster 14 main start 255s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 255s ok 76 - pg_ctlcluster 14 main stop 255s ok 77 - stopping cluster 255s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 255s ok 79 - pg_dropcluster 14 main 255s ok 80 - pg_dropcluster works as user postgres 256s ok 81 - pg_createcluster succeeds 256s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 256s ok 83 - proper error message for nonexisting /var/lib/postgresql 259s ok 84 - pg_ctlcluster 14 main start 259s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 259s ok 86 - pg_ctlcluster 14 main stop 259s ok 87 - stopping cluster 260s ok 88 - pg_createcluster other 262s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 264s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 264s ok 91 264s ok 92 - pg_ctlcluster 14 other start 264s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 265s ok 94 - pg_ctlcluster 14 main stop 265s ok 95 - stopping main cluster 267s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 268s ok 97 - pg_dropcluster other 270s ok 98 - pg_dropcluster 270s ok 99 - No sockets any more 270s ok 100 - 'pg_lsclusters 4.5 foo' fails 270s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 270s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 270s ok 103 - 'psql --cluster 4.5/foo' fails 270s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 270s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 270s ok 106 - 'psql --cluster 14/foo' fails 270s ok 107 - psql --cluster 14/foo gives error message about nonexisting cluster 270s ok 108 - psql --cluster 14/foo does not print 'invalid symbolic link' gibberish 270s ok 109 - 'pg_dropcluster 4.5 foo' fails 270s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 270s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 270s ok 112 - 'pg_dropcluster 14 foo' fails 270s ok 113 - pg_dropcluster 14 foo gives error message about nonexisting cluster 270s ok 114 - pg_dropcluster 14 foo does not print 'invalid symbolic link' gibberish 270s ok 115 - 'pg_upgradecluster 4.5 foo' fails 270s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 270s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 270s ok 118 - 'pg_upgradecluster 14 foo' fails 270s ok 119 - pg_upgradecluster 14 foo gives error message about nonexisting cluster 270s ok 120 - pg_upgradecluster 14 foo does not print 'invalid symbolic link' gibberish 270s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 270s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 270s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 270s ok 124 - 'pg_ctlcluster 14 foo stop' fails 270s ok 125 - pg_ctlcluster 14 foo stop gives error message about nonexisting cluster 270s ok 126 - pg_ctlcluster 14 foo stop does not print 'invalid symbolic link' gibberish 270s # Cleanup 270s ok 127 - Cleanup: No clusters left behind 270s ok 128 - No postgres processes left behind 270s ok 129 - No files in /etc/postgresql left behind 270s ok 130 - No files in /var/lib/postgresql left behind 270s ok 131 - No files in /var/run/postgresql left behind 270s ok 132 - No files in /var/log/postgresql left behind 270s ok 133 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 270s ok 134 - PostgreSQL TCP ports are closed 271s ok 135 - pg_dropcluster 14 broken 271s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 271s # Cleanup 271s ok 137 - Cleanup: No clusters left behind 271s ok 138 - No postgres processes left behind 271s ok 139 - No files in /etc/postgresql left behind 271s ok 140 - No files in /var/lib/postgresql left behind 271s ok 141 - No files in /var/run/postgresql left behind 271s ok 142 - No files in /var/log/postgresql left behind 271s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 271s ok 144 - PostgreSQL TCP ports are closed 272s ok 145 - pg_dropcluster 14 broken 272s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 272s ok 147 - /etc/postgresql/14 was removed 272s ok 148 - /var/lib/postgresql/14 was removed 272s # Cleanup 273s ok 149 - Cleanup: No clusters left behind 273s ok 150 - No postgres processes left behind 273s ok 151 - No files in /etc/postgresql left behind 273s ok 152 - No files in /var/lib/postgresql left behind 273s ok 153 - No files in /var/run/postgresql left behind 273s ok 154 - No files in /var/log/postgresql left behind 273s ok 155 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 273s ok 156 - PostgreSQL TCP ports are closed 273s === Running test 031_errors_disk_full.t ... === 273s 1..22 273s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 274s ok 1 - script failed 274s ok 2 - pg_createcluster fails due to insufficient disk space 274s ok 3 - does not leave files behind 274s # Cleanup 274s ok 4 - Cleanup: No clusters left behind 274s ok 5 - No postgres processes left behind 274s ok 6 - No files in /etc/postgresql left behind 274s ok 7 - No files in /var/lib/postgresql left behind 274s ok 8 - No files in /var/run/postgresql left behind 274s ok 9 - No files in /var/log/postgresql left behind 274s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 274s ok 11 - PostgreSQL TCP ports are closed 274s # check disk full conditions on startup 277s ok 12 - script failed 277s ok 13 - pg_ctlcluster prints error message 277s ok 14 - log file has error message 277s # Cleanup 277s ok 15 - Cleanup: No clusters left behind 277s ok 16 - No postgres processes left behind 277s ok 17 - No files in /etc/postgresql left behind 277s ok 18 - No files in /var/lib/postgresql left behind 277s ok 19 - No files in /var/run/postgresql left behind 277s ok 20 - No files in /var/log/postgresql left behind 277s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 277s ok 22 - PostgreSQL TCP ports are closed 277s === Running test 032_ssl_key_permissions.t ... === 277s 1..22 277s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 277s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 277s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 277s # 14 (14.15-0ubuntu0.22.04.1) 278s ok 4 - pg_createcluster 14 main 278s ok 5 - pg_ctlcluster 14 main start 278s ok 6 - ssl key owned by nobody refused 278s ok 7 - pg_ctlcluster 14 main start 278s ok 8 - ssl key with permissions root:root 0644 refused 278s ok 9 - pg_ctlcluster 14 main start 278s ok 10 - ssl key with permissions postgres:postgres 0640 refused 280s ok 11 - pg_dropcluster 14 main --stop 280s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 280s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 280s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 280s # Cleanup 280s ok 15 - Cleanup: No clusters left behind 280s ok 16 - No postgres processes left behind 280s ok 17 - No files in /etc/postgresql left behind 280s ok 18 - No files in /var/lib/postgresql left behind 280s ok 19 - No files in /var/run/postgresql left behind 280s ok 20 - No files in /var/log/postgresql left behind 280s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 280s ok 22 - PostgreSQL TCP ports are closed 280s === Running test 040_upgrade.t ... === 280s 1..1 280s ok 1 - only one major version installed, skipping upgrade tests 280s === Running test 041_upgrade_custompaths.t ... === 280s 1..1 280s ok 1 - only one major version installed, skipping upgrade tests 280s === Running test 043_upgrade_ssl_cert.t ... === 280s 1..1 280s ok 1 - only one major version installed, skipping upgrade tests 280s === Running test 045_backup.t ... === 280s # We are running systemd 280s # PostgreSQL 14 280s # create cluster 283s ok 1 - pg_createcluster --locale en_US.UTF-8 14 main --start 283s ok 2 - pg_lsclusters -h 283s ok 3 - correct output of pg_lsclusters -h 283s ok 4 - pg_conftool 14 main set work_mem 11MB 283s ok 5 - createdb -E SQL_ASCII -T template0 mydb 283s ok 6 - psql -c 'alter database mydb set search_path=public' 284s ok 7 - psql -c 'create table foo (t text)' mydb 284s ok 8 - psql -c "insert into foo values ('important data')" mydb 284s ok 9 - psql -c 'CREATE USER myuser' 284s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 284s ok 11 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 284s # create directory 284s ok 12 - pg_backupcluster 14 main createdirectory 284s ok 13 - /var/backups/postgresql/14-main owned by uid postgres 284s ok 14 - /var/backups/postgresql/14-main owned by gid postgres 284s # dump 284s ok 15 - systemctl start pg_dump@14-main 284s ok 16 - dump created in /var/backups/postgresql/14-main/2025-02-26T135147Z.dump 284s ok 17 - /var/backups/postgresql/14-main/2025-02-26T135147Z.dump owned by uid postgres 284s ok 18 - /var/backups/postgresql/14-main/2025-02-26T135147Z.dump owned by gid postgres 284s # basebackup 285s ok 19 - systemctl start pg_receivewal@14-main 291s ok 20 - systemctl start pg_basebackup@14-main 291s ok 21 - dump created in /var/backups/postgresql/14-main/2025-02-26T135148Z.backup 291s ok 22 - /var/backups/postgresql/14-main/2025-02-26T135148Z.backup owned by uid postgres 291s ok 23 - /var/backups/postgresql/14-main/2025-02-26T135148Z.backup owned by gid postgres 291s # list 291s ok 24 - pg_backupcluster 14 main list 291s ok 25 - correct output of pg_backupcluster 14 main list 291s # more database changes 291s ok 26 - psql -c "insert into foo values ('some other data')" mydb 291s ok 27 - psql -c "insert into foo values ('yet more data')" mydb 291s ok 28 - retrieve recovery timestamp 291s ok 29 - psql -c "delete from foo where t = 'some other data'" mydb 291s ok 30 - systemctl stop pg_receivewal@14-main 291s # restore /var/backups/postgresql/14-main/2025-02-26T135147Z.dump 293s ok 31 - pg_dropcluster 14 main --stop 297s ok 32 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T135147Z.dump --start --datadir /var/lib/postgresql/14/snowflake 297s ok 33 - pg_lsclusters -h 297s ok 34 - correct output of pg_lsclusters -h 297s ok 35 - psql -XAtl 297s ok 36 - correct output of psql -XAtl 297s ok 37 - psql -XAtc 'show work_mem' 297s ok 38 - correct output of psql -XAtc 'show work_mem' 297s ok 39 - psql -XAtc 'select * from foo' mydb 297s ok 40 - correct output of psql -XAtc 'select * from foo' mydb 297s ok 41 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 297s ok 42 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 297s ok 43 - psql -XAtc '\drds' 297s ok 44 - correct output of psql -XAtc '\drds' 297s # restore /var/backups/postgresql/14-main/2025-02-26T135148Z.backup 299s ok 45 - pg_dropcluster 14 main --stop 302s ok 46 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T135148Z.backup --start --datadir /var/lib/postgresql/14/snowflake 302s ok 47 - pg_lsclusters -h 302s ok 48 - correct output of pg_lsclusters -h 302s ok 49 - psql -XAtl 302s ok 50 - correct output of psql -XAtl 302s ok 51 - psql -XAtc 'show work_mem' 302s ok 52 - correct output of psql -XAtc 'show work_mem' 303s ok 53 - psql -XAtc 'select * from foo' mydb 303s ok 54 - correct output of psql -XAtc 'select * from foo' mydb 303s ok 55 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 303s ok 56 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 303s ok 57 - psql -XAtc '\drds' 303s ok 58 - correct output of psql -XAtc '\drds' 303s # restore /var/backups/postgresql/14-main/2025-02-26T135148Z.backup with WAL archive 304s ok 59 - pg_dropcluster 14 main --stop 308s ok 60 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T135148Z.backup --start --archive --port 5430 308s ok 61 - pg_lsclusters -h 308s ok 62 - correct output of pg_lsclusters -h 308s ok 63 - psql -XAtc 'select * from foo order by t' mydb 308s ok 64 - correct output of psql -XAtc 'select * from foo order by t' mydb 308s # restore /var/backups/postgresql/14-main/2025-02-26T135148Z.backup with PITR 309s ok 65 - pg_dropcluster 14 main --stop 313s ok 66 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T135148Z.backup --start --pitr '2025-02-26 13:51:54.330137+00 313s # ' 313s ok 67 - pg_lsclusters -h 313s ok 68 - correct output of pg_lsclusters -h 313s ok 69 - psql -XAtc 'select * from foo order by t' mydb 313s ok 70 - correct output of psql -XAtc 'select * from foo order by t' mydb 314s ok 71 - pg_dropcluster 14 main --stop 314s # Cleanup 314s ok 72 - Cleanup: No clusters left behind 314s ok 73 - No postgres processes left behind 314s ok 74 - No files in /etc/postgresql left behind 314s ok 75 - No files in /var/lib/postgresql left behind 314s ok 76 - No files in /var/run/postgresql left behind 314s ok 77 - No files in /var/log/postgresql left behind 314s ok 78 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 314s ok 79 - PostgreSQL TCP ports are closed 314s 1..79 314s === Running test 050_encodings.t ... === 314s 1..60 314s # Checking 14 ru_RU 318s ok 1 - pg_createcluster version 14 for ru_RU without --encoding succeeded 319s ok 2 - psql -l succeeds 319s ok 3 - template1 is not UTF-8 encoded 319s ok 4 - creating test database 319s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 319s # create table t (x varchar); copy t from stdin" test 319s ok 6 - creating table with ISO-8859-5 characters 319s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 319s ok 8 - correct string in UTF-8 319s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 319s ok 10 - correct string in ISO-8859-5 319s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 319s # delete from t; copy t from stdin" test 319s ok 12 - creating table with UTF-8 characters 319s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 319s ok 14 - correct string in UTF-8 319s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 319s ok 16 - correct string in ISO-8859-1 319s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 319s ok 18 - Server error message has correct language and encoding 322s ok 19 - pg_ctlcluster 14 ru_RU restart 322s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 323s ok 21 - Dropping cluster 323s # Checking 14 ru_RU.UTF-8 326s ok 22 - pg_createcluster version 14 for ru_RU.UTF-8 without --encoding succeeded 327s ok 23 - psql -l succeeds 327s ok 24 - template1 is UTF-8 encoded 328s ok 25 - creating test database 328s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 328s # create table t (x varchar); copy t from stdin" test 328s ok 27 - creating table with ISO-8859-5 characters 328s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 328s ok 29 - correct string in UTF-8 328s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 328s ok 31 - correct string in ISO-8859-5 328s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 328s # delete from t; copy t from stdin" test 328s ok 33 - creating table with UTF-8 characters 328s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 328s ok 35 - correct string in UTF-8 328s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 328s ok 37 - correct string in ISO-8859-1 328s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 328s ok 39 - Server error message has correct language and encoding 330s ok 40 - pg_ctlcluster 14 ru_RU.UTF8 restart 330s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 330s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 330s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 330s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 330s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 330s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 330s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 332s ok 48 - Dropping cluster 332s # Check 14 locale environment variables 335s ok 49 - pg_createcluster: LC_ALL dominates LANG 335s ok 50 - psql -Atl --cluster 14/main 335s ok 51 - template1 is ASCII encoded 337s ok 52 - Dropping cluster 337s # Cleanup 337s ok 53 - Cleanup: No clusters left behind 337s ok 54 - No postgres processes left behind 337s ok 55 - No files in /etc/postgresql left behind 337s ok 56 - No files in /var/lib/postgresql left behind 337s ok 57 - No files in /var/run/postgresql left behind 337s ok 58 - No files in /var/log/postgresql left behind 337s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 337s ok 60 - PostgreSQL TCP ports are closed 337s === Running test 052_upgrade_encodings.t ... === 337s 1..1 337s ok 1 - only one major version installed, skipping upgrade tests 337s === Running test 060_obsolete_confparams.t ... === 337s ok 1 - only one major version installed, skipping upgrade tests 337s 1..1 337s === Running test 070_non_postgres_clusters.t ... === 337s 1..40 338s ok 1 - pg_createcluster 14 main for owner nobody 338s ok 2 - pg_ctlcluster 14 main start 338s ok 3 - start refused when config and data owners mismatch 341s ok 4 - pg_ctlcluster succeeds with owner nobody 341s ok 5 - pg_lsclusters -h 341s ok 6 - pg_lsclusters shows running cluster 341s ok 7 - postgres is running as user nobody 341s ok 8 - ls /tmp/.s.PGSQL.* 341s ok 9 - socket is in /tmp 341s ok 10 - /var/run/postgresql is empty 341s ok 11 - conf dir is owned by user 341s ok 12 - conf dir is owned by user's primary group 341s ok 13 - files are owned by user 341s ok 14 - files are owned by user's primary group 341s ok 15 - log file has 0640 permissions 341s ok 16 - log file is owned by user 341s ok 17 - log file is owned by user's primary group 341s ok 18 - only one major version installed, skipping upgrade test 341s ok 19 - ... 341s ok 20 - ... 341s ok 21 - ... 341s ok 22 - ... 341s ok 23 - ... 341s ok 24 - ... 341s ok 25 - ... 341s ok 26 - ... 341s ok 27 - ... 341s ok 28 - ... 342s ok 29 - pg_dropcluster 342s ok 30 - pg_lsclusters -h 342s ok 31 - No clusters left 342s ok 32 - No postgres processes left 342s # Cleanup 342s ok 33 - Cleanup: No clusters left behind 342s ok 34 - No postgres processes left behind 342s ok 35 - No files in /etc/postgresql left behind 342s ok 36 - No files in /var/lib/postgresql left behind 342s ok 37 - No files in /var/run/postgresql left behind 342s ok 38 - No files in /var/log/postgresql left behind 342s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 342s ok 40 - PostgreSQL TCP ports are closed 342s === Running test 080_start.conf.t ... === 342s 1..73 343s ok 1 - pg_createcluster 14 main 343s # start.conf auto 343s ok 2 - get_cluster_start_conf returns auto 343s ok 3 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 343s ok 4 - start.conf contains auto 343s ok 5 - systemd generator links cluster 343s ok 6 - systemd generator links correct service file 346s ok 7 - /etc/init.d/postgresql start 14 346s ok 8 - correct output of /etc/init.d/postgresql start 14 346s ok 9 - pg_lsclusters -h 346s ok 10 - cluster is online 346s ok 11 - /etc/init.d/postgresql stop 14 346s ok 12 - correct output of /etc/init.d/postgresql stop 14 349s ok 13 - pg_lsclusters -h 349s ok 14 - cluster is down 349s # start.conf manual 349s ok 15 - get_cluster_start_conf returns manual 349s ok 16 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 349s ok 17 - start.conf contains manual 349s ok 18 - systemd generator doesn't link cluster 349s ok 19 - /etc/init.d/postgresql start 14 349s ok 20 - correct output of /etc/init.d/postgresql start 14 349s ok 21 - pg_lsclusters -h 349s ok 22 - cluster is down 351s ok 23 - pg_ctlcluster 14 main start 351s ok 24 - correct output of pg_ctlcluster 14 main start 351s ok 25 - pg_lsclusters -h 351s ok 26 - cluster is online 351s ok 27 - pg_ctlcluster 14 main stop 351s ok 28 - correct output of pg_ctlcluster 14 main stop 351s ok 29 - pg_lsclusters -h 351s ok 30 - cluster is down 351s # start.conf disabled 351s ok 31 - get_cluster_start_conf returns disabled 352s ok 32 - systemd generator doesn't link cluster 352s ok 33 - /etc/init.d/postgresql start 14 352s ok 34 - correct output of /etc/init.d/postgresql start 14 352s ok 35 - pg_lsclusters -h 352s ok 36 - cluster is down 352s ok 37 - pg_ctlcluster 14 main start 352s ok 38 - correct output of pg_ctlcluster 14 main start 352s ok 39 - pg_lsclusters -h 352s ok 40 - cluster is down 354s ok 41 - pg_ctlcluster 14 main start 354s ok 42 - correct output of pg_ctlcluster 14 main start 354s ok 43 - pg_lsclusters -h 354s ok 44 - cluster is online 354s ok 45 - pg_ctlcluster 14 main stop 354s ok 46 - correct output of pg_ctlcluster 14 main stop 354s ok 47 - pg_lsclusters -h 354s ok 48 - cluster is down 357s ok 49 - pg_ctlcluster 14 main start 357s ok 50 - correct output of pg_ctlcluster 14 main start 357s ok 51 - pg_lsclusters -h 357s ok 52 - cluster is online 357s # test upgrade 357s ok 53 - only one major version installed, skipping upgrade test 357s ok 54 - ... 357s ok 55 - get_cluster_start_conf for old cluster returns manual 357s ok 56 - get_cluster_start_conf for new cluster returns manual 357s ok 57 - ... 358s ok 58 - dropping upgraded cluster 358s ok 59 - pg_lsclusters -h 358s ok 60 - no clusters any more 358s ok 61 - pg_createcluster 14 main --start-conf foo 358s ok 62 - pg_createcluster checks --start-conf validity 359s ok 63 - pg_createcluster checks --start-conf manual 359s ok 64 - get_cluster_start_conf returns manual 360s ok 65 - dropping cluster 360s # Cleanup 360s ok 66 - Cleanup: No clusters left behind 360s ok 67 - No postgres processes left behind 360s ok 68 - No files in /etc/postgresql left behind 360s ok 69 - No files in /var/lib/postgresql left behind 360s ok 70 - No files in /var/run/postgresql left behind 360s ok 71 - No files in /var/log/postgresql left behind 360s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 360s ok 73 - PostgreSQL TCP ports are closed 360s === Running test 085_pg_ctl.conf.t ... === 360s 1..29 361s ok 1 - pg_createcluster 14 main 361s ok 2 - /etc/postgresql/14/main/pg_ctl.conf exists 363s ok 3 - pg_ctlcluster 14 main start 363s ok 4 - starting cluster 363s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 363s ok 6 - soft core size is 0 363s ok 7 - set pg_ctl default option to -c 366s ok 8 - pg_ctlcluster 14 main restart 366s ok 9 - restarting cluster 366s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 366s ok 11 - soft core size is unlimited 366s ok 12 - restored pg_ctl default option 368s ok 13 - pg_ctlcluster 14 main restart 368s ok 14 - restarting cluster 368s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 368s ok 16 - soft core size is 0 370s ok 17 - pg_ctlcluster 14 main restart -- -c 370s ok 18 - restarting cluster with -c on the command line 370s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 370s ok 20 - soft core size is unlimited 372s ok 21 - dropping cluster 372s # Cleanup 372s ok 22 - Cleanup: No clusters left behind 372s ok 23 - No postgres processes left behind 372s ok 24 - No files in /etc/postgresql left behind 372s ok 25 - No files in /var/lib/postgresql left behind 372s ok 26 - No files in /var/run/postgresql left behind 372s ok 27 - No files in /var/log/postgresql left behind 372s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 372s ok 29 - PostgreSQL TCP ports are closed 372s === Running test 090_multicluster.t ... === 372s 1..125 373s ok 1 - pg_createcluster 14 old 374s ok 2 - pg_createcluster 14 new1 375s ok 3 - pg_createcluster 14 new2 378s ok 4 - starting cluster 14/old 380s ok 5 - starting cluster 14/new1 382s ok 6 - starting cluster 14/new2 382s ok 7 - pg_lsclusters -h | sort -k3 382s ok 8 - clusters have the correct ports, skipping used 5433 382s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 382s ok 10 - createdb --version 382s ok 11 - pg_wrapper selects port 5432 as default cluster 382s ok 12 - createdb --cluster 14/new1 --version 382s ok 13 - pg_wrapper --cluster works 382s ok 14 - createdb --cluster 14/foo --version 382s ok 15 - pg_wrapper --cluster errors out for invalid cluster 382s ok 16 - createdb --cluster 14/new1 test 382s ok 17 - correct output of createdb --cluster 14/new1 test 382s ok 18 - psql -Atl --cluster 14/new1 382s ok 19 - test db appears in cluster new1 382s ok 20 - psql -Atl --cluster 14/new2 382s ok 21 - test db does not appear in cluster new2 382s ok 22 - psql -Atl 382s ok 23 - test db does not appear in default cluster 383s ok 24 - psql --cluster 14/127.0.0.1: -Atc 'show port' template1 383s ok 25 - psql --cluster 14/127.0.0.1: defaults to port 5432 383s ok 26 - createdb --cluster 14/127.0.0.1:5432 --version 383s ok 27 - createdb --cluster 14/127.0.0.1:5432 uses latest client version 383s ok 28 - psql -Atl --cluster 14/localhost:5434 383s ok 29 - test db appears in cluster 14/localhost:5434 383s ok 30 - psql -Atl --cluster 14/localhost:5440 383s ok 31 - test db does not appear in cluster 14/localhost:5440 383s ok 32 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:5435 383s ok 33 - psql --cluster 14/localhost:5435 fails due to nonexisting port 383s ok 34 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:a 383s ok 35 - psql --cluster 14/localhost:a fails due to invalid syntax 383s ok 36 - LC_MESSAGES=C psql -Atl --cluster 14/doesnotexi.st 383s ok 37 - psql --cluster 14/doesnotexi.st fails due to invalid syntax 383s ok 38 - psql -Atl --cluster 6.4/localhost: 383s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 383s ok 40 - psql -Atl 383s ok 41 - PGCLUSTER selection (1) 383s ok 42 - psql -Atl 383s ok 43 - PGCLUSTER selection (2) 383s ok 44 - psql -l 383s ok 45 - invalid PGCLUSTER value 383s ok 46 - createdb --version 383s ok 47 - PGCLUSTER network cluster selection (1) 383s ok 48 - psql -Atl 383s ok 49 - PGCLUSTER network cluster selection (2) 383s ok 50 - psql -Atl 383s ok 51 - PGCLUSTER network cluster selection (3) 383s ok 52 - LC_MESSAGES=C psql -Atl 383s ok 53 - psql --cluster 14/localhost:5435 fails due to nonexisting port 383s ok 54 - psql -Atc "show port" template1 383s ok 55 - PGPORT selection (1) 383s ok 56 - psql -Atc "show port" template1 383s ok 57 - PGPORT selection (2) 383s ok 58 - createdb --version 383s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 383s ok 60 - psql -Atc "show port" template1 383s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 383s ok 62 - psql --cluster 14/new1 -Atc 'select current_database()' 383s ok 63 - PGDATABASE environment variable works 383s ok 64 - createdb --version 383s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 383s ok 66 - createdb --cluster 14/new1 --version 383s ok 67 - pg_wrapper --cluster works with empty user_clusters 383s ok 68 - createdb --version 383s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 14 new1 *' 383s ok 70 - psql -Atc "select current_database()" 383s ok 71 - pg_wrapper selects correct database with user_clusters '* * 14 new1 test' 383s ok 72 - psql -Atc 'select current_database()' 383s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 383s ok 74 - createdb --version 383s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 384s ok 76 - createdb --version 384s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 384s ok 78 - createdb --version 384s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 384s ok 80 - createdb --version 384s ok 81 - pg_wrapper selects correct version with per-user user_clusters 384s ok 82 - createdb --version 384s ok 83 - pg_wrapper selects correct version with per-user user_clusters 384s ok 84 - createdb --version 384s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 384s ok 86 - psql -Atl 384s ok 87 - $PGHOST overrides user_clusters 384s ok 88 - psql --cluster 14/localhost:5434 -Atc 'select current_database()' test 384s ok 89 - --cluster overrides $PGHOST 384s ok 90 - createdb --version 384s ok 91 - pg_wrapper ignores invalid lines in user_clusters 384s ok 92 - psql -Atc 'select current_database()' 384s ok 93 - pg_service conf selection 1 384s ok 94 - psql -Atc 'select current_database()' 384s ok 95 - pg_service conf selection 2 384s ok 96 - psql -Atc 'select current_database()' 384s ok 97 - pg_service conf selection 3 384s ok 98 - stopping cluster 14/old 386s ok 99 - restarting cluster 14/old 386s ok 100 - pg_lsclusters -h | sort -k3 386s ok 101 - port of first cluster was successfully changed 386s ok 102 - psql -l 386s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 387s ok 104 - psql -Atl --cluster 14/new1 387s ok 105 - --cluster selects appropriate cluster 387s ok 106 - psql -Atl -p 5434 387s ok 107 - -p selects appropriate cluster 387s ok 108 - psql -Atlp 5434 387s ok 109 - -Atlp selects appropriate cluster 387s ok 110 - psql -Atl --port 5434 387s ok 111 - --port selects appropriate cluster 387s ok 112 - env PGPORT=5434 psql -Atl 387s ok 113 - $PGPORT selects appropriate cluster 387s ok 114 - Restoring original /etc/postgresql-common/user_clusters 388s ok 115 - dropping 14/new1 390s ok 116 - dropping 14/new2 391s ok 117 - dropping 14/old 391s # Cleanup 391s ok 118 - Cleanup: No clusters left behind 391s ok 119 - No postgres processes left behind 391s ok 120 - No files in /etc/postgresql left behind 391s ok 121 - No files in /var/lib/postgresql left behind 391s ok 122 - No files in /var/run/postgresql left behind 391s ok 123 - No files in /var/log/postgresql left behind 391s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 391s ok 125 - PostgreSQL TCP ports are closed 391s === Running test 100_upgrade_scripts.t ... === 391s 1..27 395s ok 1 - pg_createcluster 14 main 395s ok 2 - createdb --cluster 14/main db1 395s ok 3 - correct output of createdb --cluster 14/main db1 395s ok 4 - createdb --cluster 14/main db2 395s ok 5 - correct output of createdb --cluster 14/main db2 395s ok 6 - psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 395s ok 7 - correct output of psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 395s ok 8 - get_cluster_databases() works 395s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 397s ok 10 - run-upgrade-scripts succeeds 397s ok 11 - correct run-upgrade-script output 397s ok 12 - psql --cluster 14/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 397s ok 13 - check SQL scripts results in 14/main db1 397s ok 14 - psql --cluster 14/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 397s ok 15 - check SQL scripts results in 14/main db2 397s ok 16 - psql --cluster 14/main db1 -Atc 'select * from log order by str' 397s ok 17 - check shell scripts results in $v/main 397s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 398s ok 19 - pg_dropcluster 14 main 398s # Cleanup 398s ok 20 - Cleanup: No clusters left behind 398s ok 21 - No postgres processes left behind 398s ok 22 - No files in /etc/postgresql left behind 398s ok 23 - No files in /var/lib/postgresql left behind 398s ok 24 - No files in /var/run/postgresql left behind 398s ok 25 - No files in /var/log/postgresql left behind 398s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 398s ok 27 - PostgreSQL TCP ports are closed 398s === Running test 110_integrate_cluster.t ... === 399s 1..32 399s ok 1 - /usr/lib/postgresql/14/bin/initdb /tmp/teMe7zVxGy/c/postgres 399s ok 2 - creating raw initdb cluster for user postgres 400s ok 3 - pg_createcluster 14 postgres -d /tmp/teMe7zVxGy/c/postgres 400s ok 4 - integrating postgres cluster 400s ok 5 - pg_lsclusters 400s ok 6 - correct pg_lsclusters output 402s ok 7 - pg_ctlcluster 14 postgres start 402s ok 8 - starting cluster postgres 402s ok 9 - pg_lsclusters 402s ok 10 - correct pg_lsclusters output 404s ok 11 - dropping cluster postgres 404s ok 12 - No files in temporary cluster dir left behind 404s ok 13 - /usr/lib/postgresql/14/bin/initdb /tmp/teMe7zVxGy/c/nobody 404s ok 14 - creating raw initdb cluster for user nobody 405s ok 15 - pg_createcluster 14 nobody -d /tmp/teMe7zVxGy/c/nobody 405s ok 16 - integrating nobody cluster 405s ok 17 - pg_lsclusters 405s ok 18 - correct pg_lsclusters output 407s ok 19 - pg_ctlcluster 14 nobody start 407s ok 20 - starting cluster nobody 407s ok 21 - pg_lsclusters 407s ok 22 - correct pg_lsclusters output 409s ok 23 - dropping cluster nobody 409s ok 24 - No files in temporary cluster dir left behind 409s # Cleanup 409s ok 25 - Cleanup: No clusters left behind 409s ok 26 - No postgres processes left behind 409s ok 27 - No files in /etc/postgresql left behind 409s ok 28 - No files in /var/lib/postgresql left behind 409s ok 29 - No files in /var/run/postgresql left behind 409s ok 30 - No files in /var/log/postgresql left behind 409s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 409s ok 32 - PostgreSQL TCP ports are closed 409s === Running test 120_pg_upgradecluster_scripts.t ... === 409s 1..1 409s ok 1 - only one major version installed, skipping upgrade tests 409s === Running test 130_nonroot_admin.t ... === 409s 1..22 412s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 412s ok 2 - pg_lsclusters -h 412s ok 3 - correct output of pg_lsclusters -h 412s ok 4 - psql -Atl 412s ok 5 - correct output of psql -Atl 412s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 412s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 412s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 412s # Cleanup 412s ok 15 - Cleanup: No clusters left behind 412s ok 16 - No postgres processes left behind 412s ok 17 - No files in /etc/postgresql left behind 412s ok 18 - No files in /var/lib/postgresql left behind 412s ok 19 - No files in /var/run/postgresql left behind 412s ok 20 - No files in /var/log/postgresql left behind 412s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 412s ok 22 - PostgreSQL TCP ports are closed 412s === Running test 135_pg_virtualenv.t ... === 412s 1..20 417s ok 1 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 417s ok 2 - running pg_virtualenv as root 421s ok 3 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 421s ok 4 - running pg_virtualenv as postgres 424s ok 5 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 424s ok 6 - running pg_virtualenv as nobody 424s ok 7 # skip /usr/bin/fakeroot not available 424s ok 8 # skip /usr/bin/fakeroot not available 424s ok 9 # skip /usr/bin/fakeroot not available 424s ok 10 # skip /usr/bin/fakeroot not available 424s ok 11 # skip /usr/bin/fakeroot not available 424s ok 12 # skip /usr/bin/fakeroot not available 424s # Cleanup 424s ok 13 - Cleanup: No clusters left behind 424s ok 14 - No postgres processes left behind 424s ok 15 - No files in /etc/postgresql left behind 424s ok 16 - No files in /var/lib/postgresql left behind 424s ok 17 - No files in /var/run/postgresql left behind 424s ok 18 - No files in /var/log/postgresql left behind 424s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 424s ok 20 - PostgreSQL TCP ports are closed 424s === Running test 140_pg_config.t ... === 424s 1..38 424s # Multiarch is enabled 424s # checking version specific output for 14 424s ok 1 - /usr/lib/postgresql/14/bin/pg_config --pgxs 424s ok 2 - correct output of /usr/lib/postgresql/14/bin/pg_config --pgxs 424s ok 3 - /usr/lib/postgresql/14/bin/pg_config --libdir 424s ok 4 - correct output of /usr/lib/postgresql/14/bin/pg_config --libdir 424s ok 5 - /usr/lib/postgresql/14/bin/pg_config --pkglibdir 424s ok 6 - correct output of /usr/lib/postgresql/14/bin/pg_config --pkglibdir 424s ok 7 - /usr/lib/postgresql/14/bin/pg_config --bindir 424s ok 8 - correct output of /usr/lib/postgresql/14/bin/pg_config --bindir 424s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 424s # checking pg_config output (should behave like version 14) 424s ok 15 - pg_config 424s ok 16 - correct output of pg_config 424s ok 17 - pg_config --help 424s ok 18 - correct output of pg_config --help 424s ok 19 - pg_config --pgxs 424s ok 20 - correct output of pg_config --pgxs 424s ok 21 - pg_config --libdir 424s ok 22 - correct output of pg_config --libdir 424s ok 23 - pg_config --pkglibdir 424s ok 24 - correct output of pg_config --pkglibdir 424s ok 25 - pg_config --bindir 424s ok 26 - correct output of pg_config --bindir 424s # checking pg_config.libpq-dev output (should behave like version 14) 424s ok 27 - pg_config.libpq-dev 424s ok 28 - correct output of pg_config.libpq-dev 424s ok 29 - pg_config.libpq-dev --help 424s ok 30 - correct output of pg_config.libpq-dev --help 424s ok 31 - pg_config.libpq-dev --pgxs 424s ok 32 - correct output of pg_config.libpq-dev --pgxs 424s ok 33 - pg_config.libpq-dev --libdir 424s ok 34 - correct output of pg_config.libpq-dev --libdir 424s ok 35 - pg_config.libpq-dev --pkglibdir 424s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 424s ok 37 - pg_config.libpq-dev --bindir 424s ok 38 - correct output of pg_config.libpq-dev --bindir 424s === Running test 150_tsearch_stemming.t ... === 424s 1..37 424s ok 1 - pg_updatedicts succeeded 424s ok 2 - pg_updatedicts created en_us.affix 424s ok 3 - pg_updatedicts created en_us.dict 424s ok 4 - pg_updatedicts created 14 en_us.affix symlink 424s ok 5 - pg_updatedicts created 14 en_us.dict symlink 428s ok 6 - pg_createcluster 14 main 428s ok 7 - createdb fts 428s ok 8 - correct output of createdb fts 428s ok 9 - creating en_US full text search configuration 428s ok 10 - creating data table and search index 428s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 428s ok 12 - stem search of correct word 428s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 428s ok 14 - stem search of correct word 429s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 429s ok 16 - stem search of unknown word 429s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 429s ok 18 - full text search, exact word 429s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 429s ok 20 - full text search for word stem 429s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 429s ok 22 - full text search for word substring fails 429s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 429s ok 24 - full text search, exact unicode word 429s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 429s ok 26 - full text search for unicode word stem 429s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 429s ok 28 - full text search for unicode word substring fails 430s ok 29 430s # Cleanup 430s ok 30 - Cleanup: No clusters left behind 430s ok 31 - No postgres processes left behind 430s ok 32 - No files in /etc/postgresql left behind 430s ok 33 - No files in /var/lib/postgresql left behind 430s ok 34 - No files in /var/run/postgresql left behind 430s ok 35 - No files in /var/log/postgresql left behind 430s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 430s ok 37 - PostgreSQL TCP ports are closed 430s === Running test 160_alternate_confroot.t ... === 430s 1..28 434s ok 1 434s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 434s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 434s ok 4 - pg_lsclusters -h 434s ok 5 - correct output of pg_lsclusters -h 434s ok 6 - psql -Atl 434s ok 7 - correct output of psql -Atl 434s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 434s ok 9 - ... 434s ok 10 - ... 434s ok 11 - ... 434s ok 12 - ... 434s ok 13 - ... 434s ok 14 - ... 434s ok 15 - pg_dropcluster 14 test --stop 434s ok 16 - correct output of pg_dropcluster 14 test --stop 434s ok 17 - pg_lsclusters -h 434s ok 18 - correct output of pg_lsclusters -h 434s ok 19 - No files in root/data left behind 434s ok 20 - No cruft in root dir left behind 434s # Cleanup 434s ok 21 - Cleanup: No clusters left behind 434s ok 22 - No postgres processes left behind 434s ok 23 - No files in /etc/postgresql left behind 434s ok 24 - No files in /var/lib/postgresql left behind 434s ok 25 - No files in /var/run/postgresql left behind 434s ok 26 - No files in /var/log/postgresql left behind 434s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 434s ok 28 - PostgreSQL TCP ports are closed 434s === Running test 170_extensions.t ... === 434s # Running tests for 14 438s ok 1 - pg_createcluster 14 main 438s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 438s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 438s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 438s ok 5 - extension adminpack installs without error 438s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 438s ok 7 - extension adminpack removes without error 438s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 438s ok 9 - extension amcheck installs without error 438s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 438s ok 11 - extension amcheck removes without error 438s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 438s ok 13 - extension autoinc installs without error 438s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 438s ok 15 - extension autoinc removes without error 438s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 438s ok 17 - extension bloom installs without error 438s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 438s ok 19 - extension bloom removes without error 438s ok 20 - psql -qc 'CREATE EXTENSION plperl' 438s ok 21 - bool_plperl dependency plperl installs without error 438s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 438s ok 23 - extension bool_plperl installs without error 438s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 438s ok 25 - extension bool_plperl removes without error 438s ok 26 - psql -qc 'DROP EXTENSION plperl' 438s ok 27 - bool_plperl dependency extension plperl removes without error 438s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 438s ok 29 - bool_plperlu dependency plperlu installs without error 438s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 438s ok 31 - extension bool_plperlu installs without error 438s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 438s ok 33 - extension bool_plperlu removes without error 438s ok 34 - psql -qc 'DROP EXTENSION plperlu' 438s ok 35 - bool_plperlu dependency extension plperlu removes without error 439s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 439s ok 37 - extension btree_gin installs without error 439s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 439s ok 39 - extension btree_gin removes without error 439s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 439s ok 41 - extension btree_gist installs without error 439s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 439s ok 43 - extension btree_gist removes without error 439s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 439s ok 45 - extension citext installs without error 439s ok 46 - psql -qc 'DROP EXTENSION "citext"' 439s ok 47 - extension citext removes without error 439s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 439s ok 49 - extension cube installs without error 439s ok 50 - psql -qc 'DROP EXTENSION "cube"' 439s ok 51 - extension cube removes without error 439s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 439s ok 53 - extension dblink installs without error 439s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 439s ok 55 - extension dblink removes without error 439s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 439s ok 57 - extension dict_int installs without error 439s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 439s ok 59 - extension dict_int removes without error 439s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 439s ok 61 - extension dict_xsyn installs without error 439s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 439s ok 63 - extension dict_xsyn removes without error 439s ok 64 - psql -qc 'CREATE EXTENSION cube' 439s ok 65 - earthdistance dependency cube installs without error 439s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 439s ok 67 - extension earthdistance installs without error 440s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 440s ok 69 - extension earthdistance removes without error 440s ok 70 - psql -qc 'DROP EXTENSION cube' 440s ok 71 - earthdistance dependency extension cube removes without error 440s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 440s ok 73 - extension file_fdw installs without error 440s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 440s ok 75 - extension file_fdw removes without error 440s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 440s ok 77 - extension fuzzystrmatch installs without error 440s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 440s ok 79 - extension fuzzystrmatch removes without error 440s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 440s ok 81 - extension hstore installs without error 440s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 440s ok 83 - extension hstore removes without error 440s ok 84 - psql -qc 'CREATE EXTENSION hstore' 440s ok 85 - hstore_plperl dependency hstore installs without error 440s ok 86 - psql -qc 'CREATE EXTENSION plperl' 440s ok 87 - hstore_plperl dependency plperl installs without error 440s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 440s ok 89 - extension hstore_plperl installs without error 440s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 440s ok 91 - extension hstore_plperl removes without error 440s ok 92 - psql -qc 'DROP EXTENSION hstore' 440s ok 93 - hstore_plperl dependency extension hstore removes without error 440s ok 94 - psql -qc 'DROP EXTENSION plperl' 440s ok 95 - hstore_plperl dependency extension plperl removes without error 440s ok 96 - psql -qc 'CREATE EXTENSION hstore' 440s ok 97 - hstore_plperlu dependency hstore installs without error 440s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 440s ok 99 - hstore_plperlu dependency plperlu installs without error 440s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 440s ok 101 - extension hstore_plperlu installs without error 440s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 440s ok 103 - extension hstore_plperlu removes without error 440s ok 104 - psql -qc 'DROP EXTENSION hstore' 440s ok 105 - hstore_plperlu dependency extension hstore removes without error 440s ok 106 - psql -qc 'DROP EXTENSION plperlu' 440s ok 107 - hstore_plperlu dependency extension plperlu removes without error 441s ok 108 - psql -qc 'CREATE EXTENSION hstore' 441s ok 109 - hstore_plpython3u dependency hstore installs without error 441s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 441s ok 111 - hstore_plpython3u dependency plpython3u installs without error 441s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 441s ok 113 - extension hstore_plpython3u installs without error 441s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 441s ok 115 - extension hstore_plpython3u removes without error 441s ok 116 - psql -qc 'DROP EXTENSION hstore' 441s ok 117 - hstore_plpython3u dependency extension hstore removes without error 441s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 441s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 441s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 441s ok 121 - extension insert_username installs without error 441s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 441s ok 123 - extension insert_username removes without error 441s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 441s ok 125 - extension intagg installs without error 441s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 441s ok 127 - extension intagg removes without error 441s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 441s ok 129 - extension intarray installs without error 441s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 441s ok 131 - extension intarray removes without error 441s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 441s ok 133 - extension isn installs without error 441s ok 134 - psql -qc 'DROP EXTENSION "isn"' 441s ok 135 - extension isn removes without error 441s ok 136 - psql -qc 'CREATE EXTENSION plperl' 441s ok 137 - jsonb_plperl dependency plperl installs without error 441s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 441s ok 139 - extension jsonb_plperl installs without error 441s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 441s ok 141 - extension jsonb_plperl removes without error 441s ok 142 - psql -qc 'DROP EXTENSION plperl' 441s ok 143 - jsonb_plperl dependency extension plperl removes without error 441s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 441s ok 145 - jsonb_plperlu dependency plperlu installs without error 441s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 441s ok 147 - extension jsonb_plperlu installs without error 442s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 442s ok 149 - extension jsonb_plperlu removes without error 442s ok 150 - psql -qc 'DROP EXTENSION plperlu' 442s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 442s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 442s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 442s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 442s ok 155 - extension jsonb_plpython3u installs without error 442s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 442s ok 157 - extension jsonb_plpython3u removes without error 442s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 442s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 442s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 442s ok 161 - extension lo installs without error 442s ok 162 - psql -qc 'DROP EXTENSION "lo"' 442s ok 163 - extension lo removes without error 442s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 442s ok 165 - extension ltree installs without error 442s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 442s ok 167 - extension ltree removes without error 442s ok 168 - psql -qc 'CREATE EXTENSION ltree' 442s ok 169 - ltree_plpython3u dependency ltree installs without error 442s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 442s ok 171 - ltree_plpython3u dependency plpython3u installs without error 442s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 442s ok 173 - extension ltree_plpython3u installs without error 442s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 442s ok 175 - extension ltree_plpython3u removes without error 442s ok 176 - psql -qc 'DROP EXTENSION ltree' 442s ok 177 - ltree_plpython3u dependency extension ltree removes without error 442s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 442s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 442s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 442s ok 181 - extension moddatetime installs without error 442s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 442s ok 183 - extension moddatetime removes without error 442s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 442s ok 185 - extension old_snapshot installs without error 442s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 442s ok 187 - extension old_snapshot removes without error 442s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 442s ok 189 - extension pageinspect installs without error 442s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 442s ok 191 - extension pageinspect removes without error 443s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 443s ok 193 - extension pg_buffercache installs without error 443s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 443s ok 195 - extension pg_buffercache removes without error 443s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 443s ok 197 - extension pg_freespacemap installs without error 443s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 443s ok 199 - extension pg_freespacemap removes without error 443s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 443s ok 201 - extension pg_prewarm installs without error 443s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 443s ok 203 - extension pg_prewarm removes without error 443s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 443s ok 205 - extension pg_stat_statements installs without error 443s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 443s ok 207 - extension pg_stat_statements removes without error 443s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 443s ok 209 - extension pg_surgery installs without error 443s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 443s ok 211 - extension pg_surgery removes without error 443s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 443s ok 213 - extension pg_trgm installs without error 443s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 443s ok 215 - extension pg_trgm removes without error 443s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 443s ok 217 - extension pg_visibility installs without error 443s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 443s ok 219 - extension pg_visibility removes without error 443s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 443s ok 221 - extension pgcrypto installs without error 443s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 443s ok 223 - extension pgcrypto removes without error 443s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 443s ok 225 - extension pgrowlocks installs without error 443s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 443s ok 227 - extension pgrowlocks removes without error 443s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 443s ok 229 - extension pgstattuple installs without error 443s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 443s ok 231 - extension pgstattuple removes without error 443s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 443s ok 233 - extension plperl installs without error 443s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 443s ok 235 - extension plperl removes without error 444s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 444s ok 237 - extension plperlu installs without error 444s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 444s ok 239 - extension plperlu removes without error 444s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 444s ok 241 - extension plpython3u installs without error 444s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 444s ok 243 - extension plpython3u removes without error 444s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 444s ok 245 - extension pltcl installs without error 444s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 444s ok 247 - extension pltcl removes without error 444s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 444s ok 249 - extension pltclu installs without error 444s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 444s ok 251 - extension pltclu removes without error 444s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 444s ok 253 - extension postgres_fdw installs without error 444s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 444s ok 255 - extension postgres_fdw removes without error 444s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 444s ok 257 - extension refint installs without error 444s ok 258 - psql -qc 'DROP EXTENSION "refint"' 444s ok 259 - extension refint removes without error 444s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 444s ok 261 - extension seg installs without error 444s ok 262 - psql -qc 'DROP EXTENSION "seg"' 444s ok 263 - extension seg removes without error 444s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 444s ok 265 - extension sslinfo installs without error 444s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 444s ok 267 - extension sslinfo removes without error 444s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 444s ok 269 - extension tablefunc installs without error 444s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 444s ok 271 - extension tablefunc removes without error 444s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 444s ok 273 - extension tcn installs without error 444s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 444s ok 275 - extension tcn removes without error 444s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 444s ok 277 - extension tsm_system_rows installs without error 444s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 444s ok 279 - extension tsm_system_rows removes without error 444s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 444s ok 281 - extension tsm_system_time installs without error 445s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 445s ok 283 - extension tsm_system_time removes without error 445s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 445s ok 285 - extension unaccent installs without error 445s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 445s ok 287 - extension unaccent removes without error 445s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 445s ok 289 - extension uuid-ossp installs without error 445s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 445s ok 291 - extension uuid-ossp removes without error 445s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 445s ok 293 - extension xml2 installs without error 445s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 445s ok 295 - extension xml2 removes without error 446s ok 296 - pg_dropcluster 14 main 446s # Cleanup 446s ok 297 - Cleanup: No clusters left behind 446s ok 298 - No postgres processes left behind 446s ok 299 - No files in /etc/postgresql left behind 446s ok 300 - No files in /var/lib/postgresql left behind 446s ok 301 - No files in /var/run/postgresql left behind 446s ok 302 - No files in /var/log/postgresql left behind 446s ok 303 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 446s ok 304 - PostgreSQL TCP ports are closed 446s 1..304 446s === Running test 180_ecpg.t ... === 446s 1..14 446s ok 1 - ecpg test.pgc 446s ok 2 - ecpg processing 446s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 446s ok 4 - compiling ecpg output 454s ok 5 - pg_virtualenv /tmp/tmp.qTwmvHlVJs/test 454s ok 6 - test program runs and gives correct output 454s # Cleanup 454s ok 7 - Cleanup: No clusters left behind 454s ok 8 - No postgres processes left behind 454s ok 9 - No files in /etc/postgresql left behind 454s ok 10 - No files in /var/lib/postgresql left behind 454s ok 11 - No files in /var/run/postgresql left behind 454s ok 12 - No files in /var/log/postgresql left behind 454s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 454s ok 14 - PostgreSQL TCP ports are closed 454s === Running test 190_pg_buildext.t ... === 454s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 454s 1..1 455s autopkgtest [13:54:38]: test run-testsuite: -----------------------] 455s run-testsuite PASS 455s autopkgtest [13:54:38]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 456s autopkgtest [13:54:39]: test installcheck: preparing testbed 547s autopkgtest [13:56:10]: testbed dpkg architecture: ppc64el 547s autopkgtest [13:56:10]: testbed apt version: 2.4.13 548s autopkgtest [13:56:11]: @@@@@@@@@@@@@@@@@@@@ test bed setup 548s autopkgtest [13:56:11]: testbed release detected to be: jammy 549s autopkgtest [13:56:12]: updating testbed package index (apt update) 549s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 549s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 549s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 549s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 550s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 550s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 550s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 550s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 550s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el Packages [154 kB] 550s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el c-n-f Metadata [1724 B] 550s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el Packages [2048 B] 550s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el c-n-f Metadata [116 B] 550s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el Packages [77.9 kB] 550s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el c-n-f Metadata [1336 B] 550s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse ppc64el Packages [740 B] 550s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse ppc64el c-n-f Metadata [116 B] 555s Fetched 674 kB in 1s (701 kB/s) 558s Reading package lists... 558s autopkgtest [13:56:21]: upgrading testbed (apt dist-upgrade and autopurge) 558s Reading package lists... 558s Building dependency tree... 558s Reading state information... 558s Calculating upgrade... 558s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 558s Reading package lists... 558s Building dependency tree... 558s Reading state information... 558s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 558s Reading package lists... 558s Building dependency tree... 558s Reading state information... 558s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 558s Starting 2 pkgProblemResolver with broken count: 0 558s Done 558s Entering ResolveByKeep 559s 559s The following packages will be upgraded: 559s tzdata 559s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 559s Need to get 347 kB of archives. 559s After this operation, 4096 B of additional disk space will be used. 559s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el tzdata all 2025a-0ubuntu0.22.04 [347 kB] 559s Preconfiguring packages ... 560s Fetched 347 kB in 0s (811 kB/s) 560s (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 ... 66538 files and directories currently installed.) 560s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 560s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 560s Setting up tzdata (2025a-0ubuntu0.22.04) ... 560s 560s Current default time zone: 'Etc/UTC' 560s Local time is now: Wed Feb 26 13:56:23 UTC 2025. 560s Universal Time is now: Wed Feb 26 13:56:23 UTC 2025. 560s Run 'dpkg-reconfigure tzdata' if you wish to change it. 560s 561s Reading package lists... 561s Building dependency tree... 561s Reading state information... 561s Starting pkgProblemResolver with broken count: 0 561s Starting 2 pkgProblemResolver with broken count: 0 561s Done 561s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 564s Reading package lists... 564s Building dependency tree... 564s Reading state information... 564s Starting pkgProblemResolver with broken count: 0 564s Starting 2 pkgProblemResolver with broken count: 0 564s Done 564s The following NEW packages will be installed: 564s build-essential clang-14 cpp cpp-11 g++ g++-11 gcc gcc-11 gcc-11-base 564s icu-devtools libasan6 libatomic1 libc-dev-bin libc6-dev libcc1-0 564s libclang-common-14-dev libclang-cpp14 libclang1-14 libcrypt-dev 564s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1 libgcc-11-dev 564s libgomp1 libicu-dev libisl23 libitm1 libjson-perl libllvm14 liblsan0 libmpc3 564s libncurses-dev libnsl-dev libobjc-11-dev libobjc4 libpfm4 libpgtypes3 564s libpq-dev libpq5 libpython3.10 libquadmath0 libssl-dev libstdc++-11-dev 564s libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev libxslt1.1 libz3-4 564s libz3-dev linux-libc-dev llvm-14 llvm-14-dev llvm-14-linker-tools 564s llvm-14-runtime llvm-14-tools postgresql-14 postgresql-client-14 564s postgresql-client-common postgresql-common postgresql-doc-14 564s postgresql-plperl-14 postgresql-plpython3-14 postgresql-pltcl-14 564s postgresql-server-dev-14 python3-pygments rpcsvc-proto ssl-cert 565s 0 upgraded, 71 newly installed, 0 to remove and 0 not upgraded. 565s Need to get 205 MB of archives. 565s After this operation, 1033 MB of additional disk space will be used. 565s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc-dev-bin ppc64el 2.35-0ubuntu3.9 [21.4 kB] 565s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el linux-libc-dev ppc64el 5.15.0-133.144 [1290 kB] 565s Get:3 http://ftpmaster.internal/ubuntu jammy/main ppc64el libcrypt-dev ppc64el 1:4.4.27-1 [142 kB] 565s Get:4 http://ftpmaster.internal/ubuntu jammy/main ppc64el rpcsvc-proto ppc64el 1.4.2-0ubuntu6 [82.3 kB] 565s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtirpc-dev ppc64el 1.3.2-2ubuntu0.1 [223 kB] 565s Get:6 http://ftpmaster.internal/ubuntu jammy/main ppc64el libnsl-dev ppc64el 1.3.0-2build2 [80.0 kB] 565s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc6-dev ppc64el 2.35-0ubuntu3.9 [2053 kB] 565s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el gcc-11-base ppc64el 11.4.0-1ubuntu1~22.04 [20.3 kB] 565s Get:9 http://ftpmaster.internal/ubuntu jammy/main ppc64el libisl23 ppc64el 0.24-2build1 [833 kB] 565s Get:10 http://ftpmaster.internal/ubuntu jammy/main ppc64el libmpc3 ppc64el 1.2.1-2build1 [52.2 kB] 565s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el cpp-11 ppc64el 11.4.0-1ubuntu1~22.04 [8800 kB] 566s Get:12 http://ftpmaster.internal/ubuntu jammy/main ppc64el cpp ppc64el 4:11.2.0-1ubuntu1 [27.7 kB] 566s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libcc1-0 ppc64el 12.3.0-1ubuntu1~22.04 [49.5 kB] 566s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgomp1 ppc64el 12.3.0-1ubuntu1~22.04 [140 kB] 566s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libitm1 ppc64el 12.3.0-1ubuntu1~22.04 [32.9 kB] 566s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libatomic1 ppc64el 12.3.0-1ubuntu1~22.04 [10.6 kB] 566s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libasan6 ppc64el 11.4.0-1ubuntu1~22.04 [2303 kB] 566s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el liblsan0 ppc64el 12.3.0-1ubuntu1~22.04 [1090 kB] 566s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtsan0 ppc64el 11.4.0-1ubuntu1~22.04 [2278 kB] 566s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libubsan1 ppc64el 12.3.0-1ubuntu1~22.04 [1001 kB] 566s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libquadmath0 ppc64el 12.3.0-1ubuntu1~22.04 [156 kB] 566s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgcc-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [1477 kB] 566s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el gcc-11 ppc64el 11.4.0-1ubuntu1~22.04 [17.7 MB] 566s Get:24 http://ftpmaster.internal/ubuntu jammy/main ppc64el gcc ppc64el 4:11.2.0-1ubuntu1 [5152 B] 566s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libstdc++-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [2197 kB] 566s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el g++-11 ppc64el 11.4.0-1ubuntu1~22.04 [10.2 MB] 567s Get:27 http://ftpmaster.internal/ubuntu jammy/main ppc64el g++ ppc64el 4:11.2.0-1ubuntu1 [1408 B] 567s Get:28 http://ftpmaster.internal/ubuntu jammy/main ppc64el build-essential ppc64el 12.9ubuntu3 [4752 B] 567s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libllvm14 ppc64el 1:14.0.0-1ubuntu1.1 [24.7 MB] 567s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang-cpp14 ppc64el 1:14.0.0-1ubuntu1.1 [12.5 MB] 568s Get:31 http://ftpmaster.internal/ubuntu jammy/main ppc64el libgc1 ppc64el 1:8.0.6-1.1build1 [109 kB] 568s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc4 ppc64el 12.3.0-1ubuntu1~22.04 [54.3 kB] 568s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc-11-dev ppc64el 11.4.0-1ubuntu1~22.04 [223 kB] 568s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang-common-14-dev ppc64el 1:14.0.0-1ubuntu1.1 [4252 kB] 568s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-linker-tools ppc64el 1:14.0.0-1ubuntu1.1 [1401 kB] 568s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libclang1-14 ppc64el 1:14.0.0-1ubuntu1.1 [7447 kB] 568s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el clang-14 ppc64el 1:14.0.0-1ubuntu1.1 [81.3 kB] 568s Get:38 http://ftpmaster.internal/ubuntu jammy/main ppc64el icu-devtools ppc64el 70.1-2 [224 kB] 568s Get:39 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpgtypes3 ppc64el 14.15-0ubuntu0.22.04.1 [53.8 kB] 568s Get:40 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq5 ppc64el 14.15-0ubuntu0.22.04.1 [181 kB] 568s Get:41 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg6 ppc64el 14.15-0ubuntu0.22.04.1 [55.2 kB] 568s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg-compat3 ppc64el 14.15-0ubuntu0.22.04.1 [14.2 kB] 568s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libssl-dev ppc64el 3.0.2-0ubuntu1.19 [2611 kB] 568s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq-dev ppc64el 14.15-0ubuntu0.22.04.1 [168 kB] 568s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libecpg-dev ppc64el 14.15-0ubuntu0.22.04.1 [277 kB] 568s Get:46 http://ftpmaster.internal/ubuntu jammy/main ppc64el libicu-dev ppc64el 70.1-2 [12.2 MB] 569s Get:47 http://ftpmaster.internal/ubuntu jammy/main ppc64el libjson-perl all 4.04000-1 [81.8 kB] 569s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libncurses-dev ppc64el 6.3-2ubuntu0.1 [481 kB] 569s Get:49 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpython3.10 ppc64el 3.10.12-1~22.04.9 [2150 kB] 569s Get:50 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtinfo-dev ppc64el 6.3-2ubuntu0.1 [778 B] 569s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxml2-dev ppc64el 2.9.13+dfsg-1ubuntu0.6 [923 kB] 569s Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxslt1.1 ppc64el 1.1.34-4ubuntu0.22.04.1 [184 kB] 569s Get:53 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-runtime ppc64el 1:14.0.0-1ubuntu1.1 [509 kB] 569s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpfm4 ppc64el 4.11.1+git32-gd0b85fb-1ubuntu0.1 [166 kB] 569s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14 ppc64el 1:14.0.0-1ubuntu1.1 [12.6 MB] 570s Get:56 http://ftpmaster.internal/ubuntu jammy/main ppc64el libffi-dev ppc64el 3.4.2-4 [67.5 kB] 570s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 570s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-tools ppc64el 1:14.0.0-1ubuntu1.1 [478 kB] 570s Get:59 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-4 ppc64el 4.8.12-1 [6066 kB] 570s Get:60 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-dev ppc64el 4.8.12-1 [72.2 kB] 570s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el llvm-14-dev ppc64el 1:14.0.0-1ubuntu1.1 [39.0 MB] 572s Get:62 http://ftpmaster.internal/ubuntu jammy/main ppc64el postgresql-client-common all 238 [29.6 kB] 572s Get:63 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-client-14 ppc64el 14.15-0ubuntu0.22.04.1 [1332 kB] 572s Get:64 http://ftpmaster.internal/ubuntu jammy/main ppc64el ssl-cert all 1.1.2 [17.4 kB] 572s Get:65 http://ftpmaster.internal/ubuntu jammy/main ppc64el postgresql-common all 238 [169 kB] 572s Get:66 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-14 ppc64el 14.15-0ubuntu0.22.04.1 [17.4 MB] 572s Get:67 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 573s Get:68 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-plperl-14 ppc64el 14.15-0ubuntu0.22.04.1 [79.2 kB] 573s Get:69 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-plpython3-14 ppc64el 14.15-0ubuntu0.22.04.1 [85.8 kB] 573s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-pltcl-14 ppc64el 14.15-0ubuntu0.22.04.1 [35.8 kB] 573s Get:71 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el postgresql-server-dev-14 ppc64el 14.15-0ubuntu0.22.04.1 [1219 kB] 573s Preconfiguring packages ... 573s Fetched 205 MB in 8s (25.0 MB/s) 573s Selecting previously unselected package libc-dev-bin. 573s (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 ... 66539 files and directories currently installed.) 573s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_ppc64el.deb ... 573s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 573s Selecting previously unselected package linux-libc-dev:ppc64el. 573s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_ppc64el.deb ... 573s Unpacking linux-libc-dev:ppc64el (5.15.0-133.144) ... 573s Selecting previously unselected package libcrypt-dev:ppc64el. 573s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_ppc64el.deb ... 573s Unpacking libcrypt-dev:ppc64el (1:4.4.27-1) ... 573s Selecting previously unselected package rpcsvc-proto. 573s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_ppc64el.deb ... 573s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 573s Selecting previously unselected package libtirpc-dev:ppc64el. 573s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_ppc64el.deb ... 574s Unpacking libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... 574s Selecting previously unselected package libnsl-dev:ppc64el. 574s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_ppc64el.deb ... 574s Unpacking libnsl-dev:ppc64el (1.3.0-2build2) ... 574s Selecting previously unselected package libc6-dev:ppc64el. 574s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_ppc64el.deb ... 574s Unpacking libc6-dev:ppc64el (2.35-0ubuntu3.9) ... 574s Selecting previously unselected package gcc-11-base:ppc64el. 574s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking gcc-11-base:ppc64el (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libisl23:ppc64el. 574s Preparing to unpack .../08-libisl23_0.24-2build1_ppc64el.deb ... 574s Unpacking libisl23:ppc64el (0.24-2build1) ... 574s Selecting previously unselected package libmpc3:ppc64el. 574s Preparing to unpack .../09-libmpc3_1.2.1-2build1_ppc64el.deb ... 574s Unpacking libmpc3:ppc64el (1.2.1-2build1) ... 574s Selecting previously unselected package cpp-11. 574s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package cpp. 574s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 574s Unpacking cpp (4:11.2.0-1ubuntu1) ... 574s Selecting previously unselected package libcc1-0:ppc64el. 574s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libcc1-0:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libgomp1:ppc64el. 574s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libgomp1:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libitm1:ppc64el. 574s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libitm1:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libatomic1:ppc64el. 574s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libatomic1:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libasan6:ppc64el. 574s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libasan6:ppc64el (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package liblsan0:ppc64el. 574s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking liblsan0:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libtsan0:ppc64el. 574s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libtsan0:ppc64el (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libubsan1:ppc64el. 574s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libubsan1:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libquadmath0:ppc64el. 574s Preparing to unpack .../20-libquadmath0_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libquadmath0:ppc64el (12.3.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package libgcc-11-dev:ppc64el. 574s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libgcc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package gcc-11. 574s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 574s Selecting previously unselected package gcc. 574s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 574s Unpacking gcc (4:11.2.0-1ubuntu1) ... 574s Selecting previously unselected package libstdc++-11-dev:ppc64el. 574s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 574s Unpacking libstdc++-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 575s Selecting previously unselected package g++-11. 575s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 575s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 575s Selecting previously unselected package g++. 575s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_ppc64el.deb ... 575s Unpacking g++ (4:11.2.0-1ubuntu1) ... 575s Selecting previously unselected package build-essential. 575s Preparing to unpack .../27-build-essential_12.9ubuntu3_ppc64el.deb ... 575s Unpacking build-essential (12.9ubuntu3) ... 575s Selecting previously unselected package libllvm14:ppc64el. 575s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 575s Unpacking libllvm14:ppc64el (1:14.0.0-1ubuntu1.1) ... 575s Selecting previously unselected package libclang-cpp14. 575s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 575s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 576s Selecting previously unselected package libgc1:ppc64el. 576s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_ppc64el.deb ... 576s Unpacking libgc1:ppc64el (1:8.0.6-1.1build1) ... 576s Selecting previously unselected package libobjc4:ppc64el. 576s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_ppc64el.deb ... 576s Unpacking libobjc4:ppc64el (12.3.0-1ubuntu1~22.04) ... 576s Selecting previously unselected package libobjc-11-dev:ppc64el. 576s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_ppc64el.deb ... 576s Unpacking libobjc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 576s Selecting previously unselected package libclang-common-14-dev. 576s Preparing to unpack .../33-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 576s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 576s Selecting previously unselected package llvm-14-linker-tools. 576s Preparing to unpack .../34-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 576s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 576s Selecting previously unselected package libclang1-14. 576s Preparing to unpack .../35-libclang1-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 576s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 576s Selecting previously unselected package clang-14. 576s Preparing to unpack .../36-clang-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 576s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 576s Selecting previously unselected package icu-devtools. 576s Preparing to unpack .../37-icu-devtools_70.1-2_ppc64el.deb ... 576s Unpacking icu-devtools (70.1-2) ... 576s Selecting previously unselected package libpgtypes3:ppc64el. 576s Preparing to unpack .../38-libpgtypes3_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libpgtypes3:ppc64el (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libpq5:ppc64el. 576s Preparing to unpack .../39-libpq5_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libpq5:ppc64el (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libecpg6:ppc64el. 576s Preparing to unpack .../40-libecpg6_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libecpg6:ppc64el (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libecpg-compat3:ppc64el. 576s Preparing to unpack .../41-libecpg-compat3_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libecpg-compat3:ppc64el (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libssl-dev:ppc64el. 576s Preparing to unpack .../42-libssl-dev_3.0.2-0ubuntu1.19_ppc64el.deb ... 576s Unpacking libssl-dev:ppc64el (3.0.2-0ubuntu1.19) ... 576s Selecting previously unselected package libpq-dev. 576s Preparing to unpack .../43-libpq-dev_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libecpg-dev. 576s Preparing to unpack .../44-libecpg-dev_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 576s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 576s Selecting previously unselected package libicu-dev:ppc64el. 576s Preparing to unpack .../45-libicu-dev_70.1-2_ppc64el.deb ... 576s Unpacking libicu-dev:ppc64el (70.1-2) ... 577s Selecting previously unselected package libjson-perl. 577s Preparing to unpack .../46-libjson-perl_4.04000-1_all.deb ... 577s Unpacking libjson-perl (4.04000-1) ... 577s Selecting previously unselected package libncurses-dev:ppc64el. 577s Preparing to unpack .../47-libncurses-dev_6.3-2ubuntu0.1_ppc64el.deb ... 577s Unpacking libncurses-dev:ppc64el (6.3-2ubuntu0.1) ... 577s Selecting previously unselected package libpython3.10:ppc64el. 577s Preparing to unpack .../48-libpython3.10_3.10.12-1~22.04.9_ppc64el.deb ... 577s Unpacking libpython3.10:ppc64el (3.10.12-1~22.04.9) ... 577s Selecting previously unselected package libtinfo-dev:ppc64el. 577s Preparing to unpack .../49-libtinfo-dev_6.3-2ubuntu0.1_ppc64el.deb ... 577s Unpacking libtinfo-dev:ppc64el (6.3-2ubuntu0.1) ... 577s Selecting previously unselected package libxml2-dev:ppc64el. 577s Preparing to unpack .../50-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_ppc64el.deb ... 577s Unpacking libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.6) ... 577s Selecting previously unselected package libxslt1.1:ppc64el. 577s Preparing to unpack .../51-libxslt1.1_1.1.34-4ubuntu0.22.04.1_ppc64el.deb ... 577s Unpacking libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... 577s Selecting previously unselected package llvm-14-runtime. 577s Preparing to unpack .../52-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 577s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 577s Selecting previously unselected package libpfm4:ppc64el. 577s Preparing to unpack .../53-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_ppc64el.deb ... 577s Unpacking libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 577s Selecting previously unselected package llvm-14. 577s Preparing to unpack .../54-llvm-14_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 577s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 577s Selecting previously unselected package libffi-dev:ppc64el. 577s Preparing to unpack .../55-libffi-dev_3.4.2-4_ppc64el.deb ... 577s Unpacking libffi-dev:ppc64el (3.4.2-4) ... 577s Selecting previously unselected package python3-pygments. 577s Preparing to unpack .../56-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 577s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 577s Selecting previously unselected package llvm-14-tools. 577s Preparing to unpack .../57-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 577s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 577s Selecting previously unselected package libz3-4:ppc64el. 577s Preparing to unpack .../58-libz3-4_4.8.12-1_ppc64el.deb ... 577s Unpacking libz3-4:ppc64el (4.8.12-1) ... 577s Selecting previously unselected package libz3-dev:ppc64el. 577s Preparing to unpack .../59-libz3-dev_4.8.12-1_ppc64el.deb ... 577s Unpacking libz3-dev:ppc64el (4.8.12-1) ... 577s Selecting previously unselected package llvm-14-dev. 577s Preparing to unpack .../60-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_ppc64el.deb ... 577s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 579s Selecting previously unselected package postgresql-client-common. 579s Preparing to unpack .../61-postgresql-client-common_238_all.deb ... 579s Unpacking postgresql-client-common (238) ... 579s Selecting previously unselected package postgresql-client-14. 579s Preparing to unpack .../62-postgresql-client-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 579s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 579s Selecting previously unselected package ssl-cert. 579s Preparing to unpack .../63-ssl-cert_1.1.2_all.deb ... 579s Unpacking ssl-cert (1.1.2) ... 579s Selecting previously unselected package postgresql-common. 579s Preparing to unpack .../64-postgresql-common_238_all.deb ... 579s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 579s Unpacking postgresql-common (238) ... 579s Selecting previously unselected package postgresql-14. 579s Preparing to unpack .../65-postgresql-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 579s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 579s Selecting previously unselected package postgresql-doc-14. 579s Preparing to unpack .../66-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 579s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 580s Selecting previously unselected package postgresql-plperl-14. 580s Preparing to unpack .../67-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 580s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 580s Selecting previously unselected package postgresql-plpython3-14. 580s Preparing to unpack .../68-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 580s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 580s Selecting previously unselected package postgresql-pltcl-14. 580s Preparing to unpack .../69-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 580s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 580s Selecting previously unselected package postgresql-server-dev-14. 580s Preparing to unpack .../70-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_ppc64el.deb ... 580s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 580s Setting up postgresql-client-common (238) ... 580s Setting up libpgtypes3:ppc64el (14.15-0ubuntu0.22.04.1) ... 580s Setting up gcc-11-base:ppc64el (11.4.0-1ubuntu1~22.04) ... 580s Setting up libpython3.10:ppc64el (3.10.12-1~22.04.9) ... 580s Setting up libpq5:ppc64el (14.15-0ubuntu0.22.04.1) ... 580s Setting up linux-libc-dev:ppc64el (5.15.0-133.144) ... 580s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 580s update-alternatives: using /usr/share/postgresql/14/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 580s Setting up libgomp1:ppc64el (12.3.0-1ubuntu1~22.04) ... 580s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 580s update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 580s Setting up libffi-dev:ppc64el (3.4.2-4) ... 580s Setting up libasan6:ppc64el (11.4.0-1ubuntu1~22.04) ... 580s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 581s Setting up libz3-4:ppc64el (4.8.12-1) ... 581s Setting up libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... 581s Setting up libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 581s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 581s Setting up ssl-cert (1.1.2) ... 581s Setting up libquadmath0:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up libssl-dev:ppc64el (3.0.2-0ubuntu1.19) ... 581s Setting up libmpc3:ppc64el (1.2.1-2build1) ... 581s Setting up libatomic1:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up icu-devtools (70.1-2) ... 581s Setting up libgc1:ppc64el (1:8.0.6-1.1build1) ... 581s Setting up libubsan1:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up libllvm14:ppc64el (1:14.0.0-1ubuntu1.1) ... 581s Setting up libnsl-dev:ppc64el (1.3.0-2build2) ... 581s Setting up libcrypt-dev:ppc64el (1:4.4.27-1) ... 581s Setting up libjson-perl (4.04000-1) ... 581s Setting up libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... 581s Setting up libecpg6:ppc64el (14.15-0ubuntu0.22.04.1) ... 581s Setting up libisl23:ppc64el (0.24-2build1) ... 581s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 581s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 581s Setting up libcc1-0:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up liblsan0:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up libitm1:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up libtsan0:ppc64el (11.4.0-1ubuntu1~22.04) ... 581s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 581s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 581s Setting up libz3-dev:ppc64el (4.8.12-1) ... 581s Setting up libecpg-compat3:ppc64el (14.15-0ubuntu0.22.04.1) ... 581s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 581s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 581s Setting up libobjc4:ppc64el (12.3.0-1ubuntu1~22.04) ... 581s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 581s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 581s Setting up postgresql-common (238) ... 582s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 582s Adding user postgres to group ssl-cert 582s 582s Creating config file /etc/postgresql-common/createcluster.conf with new version 582s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 582s Removing obsolete dictionary files: 583s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 584s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 584s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 584s Setting up libgcc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 584s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 584s Setting up cpp (4:11.2.0-1ubuntu1) ... 584s Setting up libc6-dev:ppc64el (2.35-0ubuntu3.9) ... 584s Setting up libicu-dev:ppc64el (70.1-2) ... 584s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 584s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 584s Creating new PostgreSQL cluster 14/main ... 584s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 584s The files belonging to this database system will be owned by user "postgres". 584s This user must also own the server process. 584s 584s The database cluster will be initialized with locale "C.UTF-8". 584s The default database encoding has accordingly been set to "UTF8". 584s The default text search configuration will be set to "english". 584s 584s Data page checksums are disabled. 584s 584s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 584s creating subdirectories ... ok 584s selecting dynamic shared memory implementation ... posix 584s selecting default max_connections ... 100 584s selecting default shared_buffers ... 128MB 584s selecting default time zone ... Etc/UTC 584s creating configuration files ... ok 584s running bootstrap script ... ok 584s performing post-bootstrap initialization ... ok 584s syncing data to disk ... ok 584s update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 587s Setting up libncurses-dev:ppc64el (6.3-2ubuntu0.1) ... 587s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 587s Setting up libobjc-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 587s Setting up gcc (4:11.2.0-1ubuntu1) ... 587s Setting up libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.6) ... 587s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 587s Setting up libstdc++-11-dev:ppc64el (11.4.0-1ubuntu1~22.04) ... 587s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 587s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 587s Setting up libtinfo-dev:ppc64el (6.3-2ubuntu0.1) ... 587s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 587s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 587s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 587s Setting up g++ (4:11.2.0-1ubuntu1) ... 587s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 587s Setting up build-essential (12.9ubuntu3) ... 587s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 587s Processing triggers for man-db (2.10.2-1) ... 587s Processing triggers for install-info (6.8-4build1) ... 613s autopkgtest [13:57:16]: test installcheck: [----------------------- 613s + dpkg-parsechangelog -SSource 613s + SOURCE=postgresql-14 613s + MAJOR=14 613s + top_srcdir=/tmp/autopkgtest.Qnh5Bp/build.ryQ/src 613s + cd src/test/regress 613s + make -f /tmp/autopkgtest.Qnh5Bp/build.ryQ/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/14/bin/pg_config with_llvm=no 614s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O3 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fPIC -I. -I/tmp/autopkgtest.Qnh5Bp/build.ryQ/src/debian/tests/ -I/usr/include/postgresql/14/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 614s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O3 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fPIC -shared -o regress.so regress.o -L/usr/lib/powerpc64le-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-14/lib -Wl,--as-needed 615s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.Qnh5Bp/build.ryQ/src/src/test/regress/regress: input/constraints.source input/copy.source input/create_function_0.source input/create_function_1.source input/create_function_2.source input/largeobject.source input/misc.source input/tablespace.source output/constraints.source output/copy.source output/create_function_0.source output/create_function_1.source output/create_function_2.source output/largeobject.source output/largeobject_1.source output/misc.source output/tablespace.source 615s + id -u 615s + [ 1000 = 0 ] 615s + SU=sh 615s + sh 615s + mktemp -d /tmp/regress.XXXXXX 615s + OUTPUT=/tmp/regress.rIJgfM 615s + trap rm -rf /tmp/regress.rIJgfM EXIT 615s Creating new PostgreSQL cluster 14/regress ... 615s + pg_virtualenv -v 14 /usr/lib/postgresql/14/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --make-testtablespace-dir --outputdir=/tmp/regress.rIJgfM --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 618s (using postmaster on localhost, port 5433) 618s ============== dropping database "regression" ============== 618s DROP DATABASE 618s NOTICE: database "regression" does not exist, skipping 618s ============== creating database "regression" ============== 618s CREATE DATABASE 618s ALTER DATABASE 618s ============== running regression test queries ============== 618s test tablespace ... ok 235 ms 619s parallel group (20 tests): char oid txid boolean int2 uuid name varchar text pg_lsn regproc int4 money float4 enum int8 float8 bit numeric rangetypes 619s boolean ... ok 254 ms 619s char ... ok 67 ms 619s name ... ok 369 ms 619s varchar ... ok 373 ms 619s text ... ok 389 ms 619s int2 ... ok 348 ms 619s int4 ... ok 397 ms 619s int8 ... ok 477 ms 619s oid ... ok 86 ms 619s float4 ... ok 438 ms 619s float8 ... ok 478 ms 619s bit ... ok 574 ms 619s numeric ... ok 606 ms 619s txid ... ok 103 ms 619s uuid ... ok 364 ms 619s enum ... ok 438 ms 619s money ... ok 406 ms 619s rangetypes ... ok 871 ms 619s pg_lsn ... ok 392 ms 619s regproc ... ok 392 ms 620s parallel group (20 tests): path macaddr8 numerology lseg circle macaddr line strings timetz time create_function_0 date interval inet timestamptz point timestamp polygon multirangetypes box 620s strings ... ok 409 ms 620s numerology ... ok 218 ms 620s point ... ok 593 ms 620s lseg ... ok 263 ms 620s line ... ok 404 ms 620s box ... ok 1283 ms 620s path ... ok 91 ms 620s polygon ... ok 848 ms 620s circle ... ok 322 ms 620s date ... ok 499 ms 620s time ... ok 469 ms 620s timetz ... ok 442 ms 620s timestamp ... ok 692 ms 620s timestamptz ... FAILED 559 ms 620s interval ... ok 535 ms 620s inet ... ok 554 ms 620s macaddr ... ok 397 ms 620s macaddr8 ... ok 101 ms 620s multirangetypes ... ok 1001 ms 620s create_function_0 ... ok 479 ms 621s parallel group (13 tests): tstypes misc_sanity comments xid unicode mvcc expressions geometry type_sanity database regex opr_sanity horology 621s geometry ... ok 464 ms 621s horology ... ok 671 ms 621s tstypes ... ok 114 ms 621s regex ... ok 561 ms 621s type_sanity ... ok 486 ms 621s opr_sanity ... ok 611 ms 621s misc_sanity ... ok 143 ms 621s comments ... ok 211 ms 621s expressions ... ok 355 ms 621s unicode ... ok 348 ms 621s xid ... ok 269 ms 621s mvcc ... ok 354 ms 621s database ... ok 515 ms 621s test create_function_1 ... ok 24 ms 621s test create_type ... ok 64 ms 621s test create_table ... ok 268 ms 621s test create_function_2 ... ok 26 ms 622s parallel group (5 tests): copydml copyselect insert_conflict insert copy 622s copy ... ok 366 ms 622s copyselect ... ok 96 ms 622s copydml ... ok 65 ms 622s insert ... ok 342 ms 622s insert_conflict ... ok 212 ms 622s parallel group (4 tests): create_operator create_schema create_procedure create_misc 622s create_misc ... ok 106 ms 622s create_operator ... ok 85 ms 622s create_procedure ... ok 96 ms 622s create_schema ... ok 92 ms 623s parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 623s create_index ... ok 1367 ms 623s create_index_spgist ... ok 1180 ms 623s create_view ... ok 442 ms 623s index_including ... ok 275 ms 623s index_including_gist ... ok 522 ms 624s parallel group (16 tests): infinite_recurse create_cast create_function_3 drop_if_exists constraints create_aggregate typed_table errors hash_func roleattributes create_am vacuum select updatable_views triggers inherit 624s create_aggregate ... ok 386 ms 624s create_function_3 ... ok 161 ms 624s create_cast ... ok 89 ms 624s constraints ... ok 275 ms 624s triggers ... ok 1065 ms 624s select ... ok 682 ms 624s inherit ... ok 1096 ms 624s typed_table ... ok 393 ms 624s vacuum ... ok 592 ms 624s drop_if_exists ... ok 186 ms 624s updatable_views ... ok 886 ms 624s roleattributes ... ok 460 ms 624s create_am ... ok 475 ms 624s hash_func ... ok 424 ms 624s errors ... ok 404 ms 624s infinite_recurse ... ok 85 ms 625s test sanity_check ... ok 115 ms 627s parallel group (20 tests): select_distinct select_distinct_on select_into random select_having select_implicit delete namespace case union prepared_xacts transactions portals subselect arrays hash_index update aggregates join btree_index 627s select_into ... ok 313 ms 627s select_distinct ... ok 180 ms 627s select_distinct_on ... ok 296 ms 627s select_implicit ... ok 393 ms 627s select_having ... ok 347 ms 627s subselect ... ok 947 ms 627s union ... ok 715 ms 627s case ... ok 426 ms 627s join ... ok 2021 ms 627s aggregates ... ok 1553 ms 627s transactions ... ok 822 ms 627s random ... ok 324 ms 627s portals ... ok 871 ms 627s arrays ... ok 982 ms 627s btree_index ... ok 2325 ms 627s hash_index ... ok 1033 ms 627s update ... ok 1503 ms 627s delete ... ok 402 ms 627s namespace ... ok 407 ms 627s prepared_xacts ... ok 789 ms 634s parallel group (20 tests): init_privs lock drop_operator security_label tablesample object_address replica_identity identity password matview generated rowsecurity collate spgist gist groupingsets gin brin join_hash privileges 634s brin ... ok 6956 ms 634s gin ... ok 3150 ms 634s gist ... ok 2613 ms 634s spgist ... ok 2424 ms 634s privileges ... ok 7465 ms 634s init_privs ... ok 123 ms 634s security_label ... ok 450 ms 634s collate ... ok 2112 ms 634s matview ... ok 1695 ms 634s lock ... ok 321 ms 634s replica_identity ... ok 995 ms 634s rowsecurity ... ok 2002 ms 634s object_address ... ok 653 ms 634s tablesample ... ok 637 ms 634s groupingsets ... ok 2984 ms 634s drop_operator ... ok 445 ms 634s password ... ok 1441 ms 634s identity ... ok 1292 ms 634s generated ... ok 1862 ms 634s join_hash ... ok 6966 ms 635s parallel group (2 tests): brin_bloom brin_multi 635s brin_bloom ... ok 125 ms 635s brin_multi ... ok 187 ms 636s parallel group (14 tests): tidscan async dbsize alter_operator tid tsrf alter_generic create_table_like misc_functions sysviews incremental_sort tidrangescan collate.icu.utf8 misc 636s create_table_like ... ok 659 ms 636s alter_generic ... ok 543 ms 636s alter_operator ... ok 390 ms 636s misc ... ok 1229 ms 636s async ... ok 328 ms 636s dbsize ... ok 337 ms 636s misc_functions ... ok 762 ms 636s sysviews ... ok 775 ms 636s tsrf ... ok 405 ms 636s tid ... ok 399 ms 636s tidscan ... ok 115 ms 636s tidrangescan ... ok 876 ms 636s collate.icu.utf8 ... ok 1134 ms 636s incremental_sort ... ok 830 ms 637s parallel group (6 tests): amutils collate.linux.utf8 psql_crosstab rules psql stats_ext 637s rules ... ok 348 ms 637s psql ... ok 410 ms 637s psql_crosstab ... ok 100 ms 637s amutils ... ok 79 ms 637s stats_ext ... ok 1338 ms 637s collate.linux.utf8 ... ok 82 ms 640s test select_parallel ... ok 3280 ms 641s test write_parallel ... ok 123 ms 641s test vacuum_parallel ... ok 154 ms 641s parallel group (2 tests): subscription publication 641s publication ... ok 80 ms 641s subscription ... ok 51 ms 643s parallel group (17 tests): portals_p2 dependency combocid advisory_lock functional_deps xmlmap equivclass select_views guc tsdicts window cluster bitmapops indirect_toast foreign_data tsearch foreign_key 643s select_views ... ok 521 ms 643s portals_p2 ... ok 179 ms 643s foreign_key ... ok 1504 ms 643s cluster ... ok 739 ms 643s dependency ... ok 334 ms 643s guc ... ok 585 ms 643s bitmapops ... ok 1089 ms 643s combocid ... ok 352 ms 643s tsearch ... ok 1502 ms 643s tsdicts ... ok 605 ms 643s foreign_data ... ok 1196 ms 643s window ... ok 734 ms 643s xmlmap ... ok 469 ms 643s functional_deps ... ok 454 ms 643s advisory_lock ... ok 443 ms 643s indirect_toast ... ok 1100 ms 643s equivclass ... ok 483 ms 643s parallel group (6 tests): jsonpath_encoding json_encoding jsonpath json jsonb_jsonpath jsonb 643s json ... ok 129 ms 643s jsonb ... ok 253 ms 643s json_encoding ... ok 113 ms 643s jsonpath ... ok 115 ms 643s jsonpath_encoding ... ok 50 ms 643s jsonb_jsonpath ... ok 171 ms 645s parallel group (18 tests): plancache copy2 prepare returning conversion limit with rowtypes sequence largeobject truncate polymorphism domain xml temp rangefuncs plpgsql alter_table 645s plancache ... ok 155 ms 645s limit ... ok 722 ms 645s plpgsql ... ok 1334 ms 645s copy2 ... ok 323 ms 645s temp ... ok 1064 ms 645s domain ... ok 1045 ms 645s rangefuncs ... ok 1260 ms 645s prepare ... ok 501 ms 645s conversion ... ok 631 ms 645s truncate ... ok 985 ms 645s alter_table ... ok 1923 ms 645s sequence ... ok 822 ms 645s polymorphism ... ok 1022 ms 645s rowtypes ... ok 807 ms 645s returning ... ok 527 ms 645s largeobject ... ok 982 ms 645s with ... ok 733 ms 645s xml ... ok 1053 ms 647s parallel group (11 tests): explain hash_part partition_info reloptions compression memoize partition_aggregate indexing tuplesort partition_join partition_prune 647s partition_join ... ok 1929 ms 647s partition_prune ... ok 2241 ms 647s reloptions ... ok 514 ms 647s hash_part ... ok 411 ms 647s indexing ... ok 1881 ms 647s partition_aggregate ... ok 1835 ms 647s partition_info ... ok 494 ms 647s tuplesort ... ok 1908 ms 647s explain ... ok 385 ms 647s compression ... ok 718 ms 647s memoize ... ok 1568 ms 647s parallel group (2 tests): event_trigger oidjoins 647s event_trigger ... ok 105 ms 647s oidjoins ... ok 200 ms 647s test fast_default ... ok 127 ms 648s test stats ... ok 611 ms 648s 648s ======================== 648s 1 of 212 tests failed. 648s ======================== 648s 648s The differences that caused some tests to fail can be viewed in the 648s file "/tmp/regress.rIJgfM/regression.diffs". A copy of the test summary that you see 648s above is saved in the file "/tmp/regress.rIJgfM/regression.out". 648s 648s *** /tmp/pg_virtualenv.QSGUxP/log/postgresql-14-regress.log (last 100 lines) *** 648s 2025-02-26 13:57:49.792 UTC [5865] ubuntu@regression DETAIL: Key (a)=(3) already exists. 648s 2025-02-26 13:57:49.792 UTC [5865] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 648s 2025-02-26 13:57:49.795 UTC [5865] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 648s 2025-02-26 13:57:49.795 UTC [5865] ubuntu@regression DETAIL: Key (a)=(4) already exists. 648s 2025-02-26 13:57:49.795 UTC [5865] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 648s 2025-02-26 13:57:49.796 UTC [5865] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 648s 2025-02-26 13:57:49.796 UTC [5865] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 648s 2025-02-26 13:57:49.796 UTC [5865] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 648s 2025-02-26 13:57:49.800 UTC [5865] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 648s 2025-02-26 13:57:49.800 UTC [5865] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 648s 2025-02-26 13:57:49.806 UTC [5865] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 648s 2025-02-26 13:57:49.806 UTC [5865] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 648s 2025-02-26 13:57:49.893 UTC [5865] ubuntu@regression ERROR: division by zero 648s 2025-02-26 13:57:49.893 UTC [5865] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 648s 2025-02-26 13:57:50.327 UTC [5954] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 648s 2025-02-26 13:57:50.327 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 648s on ddl_command_start 648s execute procedure pg_backend_pid(); 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression ERROR: trigger functions can only be called as triggers 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 648s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 648s SELECT 1 $$ language sql; 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 648s 2025-02-26 13:57:50.329 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: unrecognized filter variable "food" 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when food in ('sandwich') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('sandwich') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('create table', 'create skunkcabbage') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('DROP EVENT TRIGGER') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('CREATE ROLE') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 648s 2025-02-26 13:57:50.330 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('CREATE DATABASE') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('CREATE TABLESPACE') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression ERROR: filter variable "tag" specified more than once 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s when tag in ('create table') and tag in ('CREATE FUNCTION') 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 648s execute procedure test_event_trigger('argument not allowed'); 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression HINT: Must be superuser to create an event trigger. 648s 2025-02-26 13:57:50.331 UTC [5954] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 648s execute procedure test_event_trigger(); 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 648s owner of user mapping for regress_evt_user on server useless_server 648s owner of default privileges on new relations belonging to role regress_evt_user 648s 2025-02-26 13:57:50.340 UTC [5954] ubuntu@regression STATEMENT: drop role regress_evt_user; 648s 2025-02-26 13:57:50.353 UTC [5954] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 648s 2025-02-26 13:57:50.353 UTC [5954] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 648s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 648s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 648s 2025-02-26 13:57:50.353 UTC [5954] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 648s 2025-02-26 13:57:50.356 UTC [5954] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 648s 2025-02-26 13:57:50.356 UTC [5954] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 648s 2025-02-26 13:57:50.356 UTC [5954] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 648s 2025-02-26 13:57:50.383 UTC [5954] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 648s 2025-02-26 13:57:50.383 UTC [5954] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 648s 2025-02-26 13:57:50.388 UTC [5954] ubuntu@regression ERROR: rewrites not allowed 648s 2025-02-26 13:57:50.388 UTC [5954] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 648s 2025-02-26 13:57:50.388 UTC [5954] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 648s 2025-02-26 13:57:50.402 UTC [5954] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 648s 2025-02-26 13:57:50.402 UTC [5954] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 648s 2025-02-26 13:57:51.235 UTC [5966] ubuntu@regression LOG: wait_for_stats delayed 0.523740 seconds 648s 2025-02-26 13:57:51.235 UTC [5966] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 648s 2025-02-26 13:57:51.235 UTC [5966] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 648s Dropping cluster 14/regress ... 648s diff -U3 /tmp/autopkgtest.Qnh5Bp/build.ryQ/src/src/test/regress/expected/timestamptz.out /tmp/regress.rIJgfM/results/timestamptz.out 648s --- /tmp/autopkgtest.Qnh5Bp/build.ryQ/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:37:40.000000000 +0000 648s +++ /tmp/regress.rIJgfM/results/timestamptz.out 2025-02-26 13:57:23.089649861 +0000 648s @@ -2280,7 +2280,7 @@ 648s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 648s timezone 648s -------------------------- 648s - Wed Dec 09 15:56:00 1846 648s + Wed Dec 09 15:56:08 1846 648s (1 row) 648s 648s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 648s + head -100 /tmp/regress.rIJgfM/regression.diffs 648s + exit 1 648s + rm -rf /tmp/regress.rIJgfM 649s autopkgtest [13:57:52]: test installcheck: -----------------------] 649s installcheck FAIL non-zero exit status 1 649s autopkgtest [13:57:52]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 649s autopkgtest [13:57:52]: @@@@@@@@@@@@@@@@@@@@ summary 649s run-testsuite PASS 649s installcheck FAIL non-zero exit status 1 655s nova [W] Using flock in prodstack6-ppc64el 655s Creating nova instance adt-jammy-ppc64el-postgresql-14-20250226-134703-juju-7f2275-prod-proposed-migration-environment-20-015d9d0b-f714-4d8e-989f-c11c23a12e80 from image adt/ubuntu-jammy-ppc64el-server-20250226.img (UUID b002c312-64c1-49a7-a959-6129ec414f24)... 655s nova [W] Timed out waiting for ff37f7e0-17ba-4817-b35f-aa478ae1a85e to get deleted. 655s nova [W] Using flock in prodstack6-ppc64el 655s Creating nova instance adt-jammy-ppc64el-postgresql-14-20250226-134703-juju-7f2275-prod-proposed-migration-environment-20-015d9d0b-f714-4d8e-989f-c11c23a12e80 from image adt/ubuntu-jammy-ppc64el-server-20250226.img (UUID b002c312-64c1-49a7-a959-6129ec414f24)... 655s nova [W] Timed out waiting for f0bc59c4-683f-4358-ad63-967d6d3afc58 to get deleted.