0s autopkgtest [13:15:54]: starting date and time: 2025-02-26 13:15:54+0000 0s autopkgtest [13:15:54]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:15:54]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.2jzl_wpo/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-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-s390x-15.secgroup --name adt-jammy-s390x-postgresql-14-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-2092b963-c55c-4f43-9c9a-95fb5375b1c1 --image adt/ubuntu-jammy-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-s390x -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/ 101s autopkgtest [13:17:35]: testbed dpkg architecture: s390x 101s autopkgtest [13:17:35]: testbed apt version: 2.4.13 102s autopkgtest [13:17:36]: @@@@@@@@@@@@@@@@@@@@ test bed setup 102s autopkgtest [13:17:36]: testbed release detected to be: None 103s autopkgtest [13:17:37]: updating testbed package index (apt update) 103s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 103s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 103s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 103s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 104s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 104s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 104s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 104s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 104s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x Packages [146 kB] 104s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x c-n-f Metadata [1724 B] 104s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x Packages [2048 B] 104s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x c-n-f Metadata [116 B] 104s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x Packages [45.5 kB] 104s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x c-n-f Metadata [1312 B] 104s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse s390x Packages [740 B] 104s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse s390x c-n-f Metadata [116 B] 105s Fetched 633 kB in 1s (695 kB/s) 106s Reading package lists... 106s + lsb_release --codename --short 106s + RELEASE=jammy 106s + cat 106s + [ jammy != trusty ] 106s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 106s Reading package lists... 106s Building dependency tree... 106s Reading state information... 107s Calculating upgrade... 107s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 107s + /usr/lib/apt/apt-helper analyze-pattern ?true 107s + uname -r 107s + sed s/\./\\./g 107s + running_kernel_pattern=^linux-.*5\.15\.0-133-generic.* 107s + apt list ?obsolete 107s + tail -n+2 107s + cut -d/ -f1 107s + grep -v ^linux-.*5\.15\.0-133-generic.* 107s + true 107s + obsolete_pkgs= 107s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 107s + grep -q trusty /etc/lsb-release 107s + [ ! -d /usr/share/doc/unattended-upgrades ] 107s + [ ! -d /usr/share/doc/lxd ] 107s + [ ! -d /usr/share/doc/lxd-client ] 107s + [ ! -d /usr/share/doc/snapd ] 107s + type iptables 107s + cat 107s + chmod 755 /etc/rc.local 107s + . /etc/rc.local 107s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 107s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 107s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 107s + uname -m 107s + [ s390x = ppc64le ] 107s + [ -d /run/systemd/system ] 107s + systemd-detect-virt --quiet --vm 107s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 107s + cat 107s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 107s + echo COMPRESS=lz4 107s autopkgtest [13:17:41]: upgrading testbed (apt dist-upgrade and autopurge) 107s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 107s Starting 2 pkgProblemResolver with broken count: 0 107s Done 108s Entering ResolveByKeep 108s 108s The following packages will be upgraded: 108s tzdata 108s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s Need to get 347 kB of archives. 108s After this operation, 4096 B of additional disk space will be used. 108s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x tzdata all 2025a-0ubuntu0.22.04 [347 kB] 109s Preconfiguring packages ... 109s Fetched 347 kB in 0s (694 kB/s) 109s (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 ... 50346 files and directories currently installed.) 109s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 109s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 109s Setting up tzdata (2025a-0ubuntu0.22.04) ... 109s 109s Current default time zone: 'Etc/UTC' 109s Local time is now: Wed Feb 26 13:19:09 UTC 2025. 109s Universal Time is now: Wed Feb 26 13:19:09 UTC 2025. 109s Run 'dpkg-reconfigure tzdata' if you wish to change it. 109s 109s Reading package lists... 110s Building dependency tree... 110s Reading state information... 110s Starting pkgProblemResolver with broken count: 0 110s Starting 2 pkgProblemResolver with broken count: 0 110s Done 110s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 112s autopkgtest [13:17:46]: testbed running kernel: Linux 5.15.0-133-generic #144-Ubuntu SMP Sat Feb 8 14:01:22 UTC 2025 112s autopkgtest [13:17:46]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-14 122s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (dsc) [3864 B] 122s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (tar) [29.3 MB] 122s Get:3 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (diff) [30.0 kB] 122s gpgv: Signature made Wed Nov 27 17:13:16 2024 UTC 122s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 122s gpgv: Can't check signature: No public key 122s dpkg-source: warning: cannot verify signature ./postgresql-14_14.15-0ubuntu0.22.04.1.dsc 122s autopkgtest [13:17:56]: testing package postgresql-14 version 14.15-0ubuntu0.22.04.1 124s autopkgtest [13:17:58]: build not needed 133s autopkgtest [13:18:07]: test run-testsuite: preparing testbed 133s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Starting pkgProblemResolver with broken count: 0 133s Starting 2 pkgProblemResolver with broken count: 0 133s Done 133s The following NEW packages will be installed: 133s build-essential cpp cpp-11 dictionaries-common emacsen-common g++ g++-11 gcc 133s gcc-11 gcc-11-base hunspell-en-us libasan6 libatomic1 libc-dev-bin libc6-dev 133s libcc1-0 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libgcc-11-dev 133s libgomp1 libisl23 libitm1 libjson-perl libmpc3 libnsl-dev libpgtypes3 133s libpq-dev libpq5 libpython3.10 libssl-dev libstdc++-11-dev libtirpc-dev 133s libubsan1 libxslt1.1 linux-libc-dev net-tools postgresql-14 133s postgresql-client-14 postgresql-client-common postgresql-common 133s postgresql-doc-14 postgresql-plperl-14 postgresql-plpython3-14 133s postgresql-pltcl-14 postgresql-server-dev-14 rpcsvc-proto ssl-cert 133s 0 upgraded, 49 newly installed, 0 to remove and 0 not upgraded. 133s Need to get 58.7 MB of archives. 133s After this operation, 215 MB of additional disk space will be used. 133s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libc-dev-bin s390x 2.35-0ubuntu3.9 [20.0 kB] 133s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main s390x linux-libc-dev s390x 5.15.0-133.144 [1295 kB] 134s Get:3 http://ftpmaster.internal/ubuntu jammy/main s390x libcrypt-dev s390x 1:4.4.27-1 [114 kB] 134s Get:4 http://ftpmaster.internal/ubuntu jammy/main s390x rpcsvc-proto s390x 1.4.2-0ubuntu6 [64.7 kB] 134s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libtirpc-dev s390x 1.3.2-2ubuntu0.1 [189 kB] 134s Get:6 http://ftpmaster.internal/ubuntu jammy/main s390x libnsl-dev s390x 1.3.0-2build2 [70.9 kB] 134s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libc6-dev s390x 2.35-0ubuntu3.9 [1502 kB] 134s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main s390x gcc-11-base s390x 11.4.0-1ubuntu1~22.04 [20.3 kB] 134s Get:9 http://ftpmaster.internal/ubuntu jammy/main s390x libisl23 s390x 0.24-2build1 [701 kB] 134s Get:10 http://ftpmaster.internal/ubuntu jammy/main s390x libmpc3 s390x 1.2.1-2build1 [47.7 kB] 134s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main s390x cpp-11 s390x 11.4.0-1ubuntu1~22.04 [7871 kB] 134s Get:12 http://ftpmaster.internal/ubuntu jammy/main s390x cpp s390x 4:11.2.0-1ubuntu1 [27.7 kB] 134s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libcc1-0 s390x 12.3.0-1ubuntu1~22.04 [46.2 kB] 134s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libgomp1 s390x 12.3.0-1ubuntu1~22.04 [123 kB] 134s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libitm1 s390x 12.3.0-1ubuntu1~22.04 [29.9 kB] 134s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libatomic1 s390x 12.3.0-1ubuntu1~22.04 [9076 B] 134s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libasan6 s390x 11.4.0-1ubuntu1~22.04 [2247 kB] 134s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libubsan1 s390x 12.3.0-1ubuntu1~22.04 [968 kB] 134s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libgcc-11-dev s390x 11.4.0-1ubuntu1~22.04 [829 kB] 134s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main s390x gcc-11 s390x 11.4.0-1ubuntu1~22.04 [15.8 MB] 135s Get:21 http://ftpmaster.internal/ubuntu jammy/main s390x gcc s390x 4:11.2.0-1ubuntu1 [5118 B] 135s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libstdc++-11-dev s390x 11.4.0-1ubuntu1~22.04 [2103 kB] 135s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main s390x g++-11 s390x 11.4.0-1ubuntu1~22.04 [9204 kB] 135s Get:24 http://ftpmaster.internal/ubuntu jammy/main s390x g++ s390x 4:11.2.0-1ubuntu1 [1408 B] 135s Get:25 http://ftpmaster.internal/ubuntu jammy/main s390x build-essential s390x 12.9ubuntu3 [4748 B] 135s Get:26 http://ftpmaster.internal/ubuntu jammy/main s390x emacsen-common all 3.0.4 [14.9 kB] 135s Get:27 http://ftpmaster.internal/ubuntu jammy/main s390x dictionaries-common all 1.28.14 [185 kB] 135s Get:28 http://ftpmaster.internal/ubuntu jammy/main s390x hunspell-en-us all 1:2020.12.07-2 [280 kB] 135s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpgtypes3 s390x 14.15-0ubuntu0.22.04.1 [48.4 kB] 135s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq5 s390x 14.15-0ubuntu0.22.04.1 [144 kB] 135s Get:31 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg6 s390x 14.15-0ubuntu0.22.04.1 [43.8 kB] 135s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg-compat3 s390x 14.15-0ubuntu0.22.04.1 [13.3 kB] 135s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libssl-dev s390x 3.0.2-0ubuntu1.19 [2029 kB] 135s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq-dev s390x 14.15-0ubuntu0.22.04.1 [146 kB] 135s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg-dev s390x 14.15-0ubuntu0.22.04.1 [264 kB] 135s Get:36 http://ftpmaster.internal/ubuntu jammy/main s390x libjson-perl all 4.04000-1 [81.8 kB] 135s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpython3.10 s390x 3.10.12-1~22.04.9 [1900 kB] 135s Get:38 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.22.04.1 [157 kB] 135s Get:39 http://ftpmaster.internal/ubuntu jammy/main s390x net-tools s390x 1.60+git20181103.0eebece-1ubuntu5 [200 kB] 135s Get:40 http://ftpmaster.internal/ubuntu jammy/main s390x postgresql-client-common all 238 [29.6 kB] 135s Get:41 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-client-14 s390x 14.15-0ubuntu0.22.04.1 [1205 kB] 135s Get:42 http://ftpmaster.internal/ubuntu jammy/main s390x ssl-cert all 1.1.2 [17.4 kB] 135s Get:43 http://ftpmaster.internal/ubuntu jammy/main s390x postgresql-common all 238 [169 kB] 135s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-14 s390x 14.15-0ubuntu0.22.04.1 [5094 kB] 135s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 136s Get:46 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-plperl-14 s390x 14.15-0ubuntu0.22.04.1 [52.8 kB] 136s Get:47 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-plpython3-14 s390x 14.15-0ubuntu0.22.04.1 [62.2 kB] 136s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-pltcl-14 s390x 14.15-0ubuntu0.22.04.1 [35.3 kB] 136s Get:49 http://ftpmaster.internal/ubuntu jammy-updates/universe s390x postgresql-server-dev-14 s390x 14.15-0ubuntu0.22.04.1 [1176 kB] 136s Preconfiguring packages ... 136s Fetched 58.7 MB in 2s (24.9 MB/s) 136s Selecting previously unselected package libc-dev-bin. 136s (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 ... 50347 files and directories currently installed.) 136s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_s390x.deb ... 136s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 136s Selecting previously unselected package linux-libc-dev:s390x. 136s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_s390x.deb ... 136s Unpacking linux-libc-dev:s390x (5.15.0-133.144) ... 136s Selecting previously unselected package libcrypt-dev:s390x. 136s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_s390x.deb ... 136s Unpacking libcrypt-dev:s390x (1:4.4.27-1) ... 136s Selecting previously unselected package rpcsvc-proto. 136s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_s390x.deb ... 136s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 136s Selecting previously unselected package libtirpc-dev:s390x. 136s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_s390x.deb ... 136s Unpacking libtirpc-dev:s390x (1.3.2-2ubuntu0.1) ... 136s Selecting previously unselected package libnsl-dev:s390x. 136s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_s390x.deb ... 136s Unpacking libnsl-dev:s390x (1.3.0-2build2) ... 136s Selecting previously unselected package libc6-dev:s390x. 136s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_s390x.deb ... 136s Unpacking libc6-dev:s390x (2.35-0ubuntu3.9) ... 136s Selecting previously unselected package gcc-11-base:s390x. 136s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking gcc-11-base:s390x (11.4.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libisl23:s390x. 136s Preparing to unpack .../08-libisl23_0.24-2build1_s390x.deb ... 136s Unpacking libisl23:s390x (0.24-2build1) ... 136s Selecting previously unselected package libmpc3:s390x. 136s Preparing to unpack .../09-libmpc3_1.2.1-2build1_s390x.deb ... 136s Unpacking libmpc3:s390x (1.2.1-2build1) ... 136s Selecting previously unselected package cpp-11. 136s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package cpp. 136s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_s390x.deb ... 136s Unpacking cpp (4:11.2.0-1ubuntu1) ... 136s Selecting previously unselected package libcc1-0:s390x. 136s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libcc1-0:s390x (12.3.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libgomp1:s390x. 136s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libgomp1:s390x (12.3.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libitm1:s390x. 136s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libitm1:s390x (12.3.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libatomic1:s390x. 136s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libatomic1:s390x (12.3.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libasan6:s390x. 136s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libasan6:s390x (11.4.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libubsan1:s390x. 136s Preparing to unpack .../17-libubsan1_12.3.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libubsan1:s390x (12.3.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package libgcc-11-dev:s390x. 136s Preparing to unpack .../18-libgcc-11-dev_11.4.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking libgcc-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 136s Selecting previously unselected package gcc-11. 136s Preparing to unpack .../19-gcc-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 136s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 137s Selecting previously unselected package gcc. 137s Preparing to unpack .../20-gcc_4%3a11.2.0-1ubuntu1_s390x.deb ... 137s Unpacking gcc (4:11.2.0-1ubuntu1) ... 137s Selecting previously unselected package libstdc++-11-dev:s390x. 137s Preparing to unpack .../21-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_s390x.deb ... 137s Unpacking libstdc++-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 137s Selecting previously unselected package g++-11. 137s Preparing to unpack .../22-g++-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 137s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 137s Selecting previously unselected package g++. 137s Preparing to unpack .../23-g++_4%3a11.2.0-1ubuntu1_s390x.deb ... 137s Unpacking g++ (4:11.2.0-1ubuntu1) ... 137s Selecting previously unselected package build-essential. 137s Preparing to unpack .../24-build-essential_12.9ubuntu3_s390x.deb ... 137s Unpacking build-essential (12.9ubuntu3) ... 137s Selecting previously unselected package emacsen-common. 137s Preparing to unpack .../25-emacsen-common_3.0.4_all.deb ... 137s Unpacking emacsen-common (3.0.4) ... 137s Selecting previously unselected package dictionaries-common. 137s Preparing to unpack .../26-dictionaries-common_1.28.14_all.deb ... 137s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 137s Unpacking dictionaries-common (1.28.14) ... 137s Selecting previously unselected package hunspell-en-us. 137s Preparing to unpack .../27-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 137s Unpacking hunspell-en-us (1:2020.12.07-2) ... 137s Selecting previously unselected package libpgtypes3:s390x. 137s Preparing to unpack .../28-libpgtypes3_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libpgtypes3:s390x (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libpq5:s390x. 137s Preparing to unpack .../29-libpq5_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libpq5:s390x (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libecpg6:s390x. 137s Preparing to unpack .../30-libecpg6_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libecpg6:s390x (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libecpg-compat3:s390x. 137s Preparing to unpack .../31-libecpg-compat3_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libecpg-compat3:s390x (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libssl-dev:s390x. 137s Preparing to unpack .../32-libssl-dev_3.0.2-0ubuntu1.19_s390x.deb ... 137s Unpacking libssl-dev:s390x (3.0.2-0ubuntu1.19) ... 137s Selecting previously unselected package libpq-dev. 137s Preparing to unpack .../33-libpq-dev_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libecpg-dev. 137s Preparing to unpack .../34-libecpg-dev_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package libjson-perl. 137s Preparing to unpack .../35-libjson-perl_4.04000-1_all.deb ... 137s Unpacking libjson-perl (4.04000-1) ... 137s Selecting previously unselected package libpython3.10:s390x. 137s Preparing to unpack .../36-libpython3.10_3.10.12-1~22.04.9_s390x.deb ... 137s Unpacking libpython3.10:s390x (3.10.12-1~22.04.9) ... 137s Selecting previously unselected package libxslt1.1:s390x. 137s Preparing to unpack .../37-libxslt1.1_1.1.34-4ubuntu0.22.04.1_s390x.deb ... 137s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... 137s Selecting previously unselected package net-tools. 137s Preparing to unpack .../38-net-tools_1.60+git20181103.0eebece-1ubuntu5_s390x.deb ... 137s Unpacking net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 137s Selecting previously unselected package postgresql-client-common. 137s Preparing to unpack .../39-postgresql-client-common_238_all.deb ... 137s Unpacking postgresql-client-common (238) ... 137s Selecting previously unselected package postgresql-client-14. 137s Preparing to unpack .../40-postgresql-client-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package ssl-cert. 137s Preparing to unpack .../41-ssl-cert_1.1.2_all.deb ... 137s Unpacking ssl-cert (1.1.2) ... 137s Selecting previously unselected package postgresql-common. 137s Preparing to unpack .../42-postgresql-common_238_all.deb ... 137s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 137s Unpacking postgresql-common (238) ... 137s Selecting previously unselected package postgresql-14. 137s Preparing to unpack .../43-postgresql-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package postgresql-doc-14. 137s Preparing to unpack .../44-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 137s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package postgresql-plperl-14. 137s Preparing to unpack .../45-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package postgresql-plpython3-14. 137s Preparing to unpack .../46-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package postgresql-pltcl-14. 137s Preparing to unpack .../47-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 137s Selecting previously unselected package postgresql-server-dev-14. 137s Preparing to unpack .../48-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 137s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 138s Setting up postgresql-client-common (238) ... 138s Setting up libpgtypes3:s390x (14.15-0ubuntu0.22.04.1) ... 138s Setting up gcc-11-base:s390x (11.4.0-1ubuntu1~22.04) ... 138s Setting up libpython3.10:s390x (3.10.12-1~22.04.9) ... 138s Setting up net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 138s Setting up libpq5:s390x (14.15-0ubuntu0.22.04.1) ... 138s Setting up linux-libc-dev:s390x (5.15.0-133.144) ... 138s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 138s 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 138s Setting up libgomp1:s390x (12.3.0-1ubuntu1~22.04) ... 138s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 138s 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 138s Setting up libasan6:s390x (11.4.0-1ubuntu1~22.04) ... 138s Setting up libtirpc-dev:s390x (1.3.2-2ubuntu0.1) ... 138s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 138s Setting up emacsen-common (3.0.4) ... 138s Setting up ssl-cert (1.1.2) ... 139s Setting up libssl-dev:s390x (3.0.2-0ubuntu1.19) ... 139s Setting up libmpc3:s390x (1.2.1-2build1) ... 139s Setting up libatomic1:s390x (12.3.0-1ubuntu1~22.04) ... 139s Setting up libubsan1:s390x (12.3.0-1ubuntu1~22.04) ... 139s Setting up libnsl-dev:s390x (1.3.0-2build2) ... 139s Setting up libcrypt-dev:s390x (1:4.4.27-1) ... 139s Setting up libjson-perl (4.04000-1) ... 139s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... 139s Setting up libecpg6:s390x (14.15-0ubuntu0.22.04.1) ... 139s Setting up libisl23:s390x (0.24-2build1) ... 139s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 139s Setting up libcc1-0:s390x (12.3.0-1ubuntu1~22.04) ... 139s Setting up libitm1:s390x (12.3.0-1ubuntu1~22.04) ... 139s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 139s Setting up libecpg-compat3:s390x (14.15-0ubuntu0.22.04.1) ... 139s Setting up dictionaries-common (1.28.14) ... 139s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 139s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 139s Setting up postgresql-common (238) ... 139s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 139s Adding user postgres to group ssl-cert 139s 139s Creating config file /etc/postgresql-common/createcluster.conf with new version 139s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 139s en_us 140s Removing obsolete dictionary files: 140s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 140s Setting up libgcc-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 140s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 140s Setting up cpp (4:11.2.0-1ubuntu1) ... 140s Setting up hunspell-en-us (1:2020.12.07-2) ... 140s Setting up libc6-dev:s390x (2.35-0ubuntu3.9) ... 140s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 140s Creating new PostgreSQL cluster 14/main ... 140s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 140s The files belonging to this database system will be owned by user "postgres". 140s This user must also own the server process. 140s 140s The database cluster will be initialized with locale "C.UTF-8". 140s The default database encoding has accordingly been set to "UTF8". 140s The default text search configuration will be set to "english". 140s 140s Data page checksums are disabled. 140s 140s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 140s creating subdirectories ... ok 140s selecting dynamic shared memory implementation ... posix 140s selecting default max_connections ... 100 140s selecting default shared_buffers ... 128MB 140s selecting default time zone ... Etc/UTC 140s creating configuration files ... ok 140s running bootstrap script ... ok 141s performing post-bootstrap initialization ... ok 141s syncing data to disk ... ok 141s 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 144s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 144s Setting up gcc (4:11.2.0-1ubuntu1) ... 144s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 144s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 144s Setting up libstdc++-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 144s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 144s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 144s Setting up g++ (4:11.2.0-1ubuntu1) ... 144s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 144s Setting up build-essential (12.9ubuntu3) ... 144s Processing triggers for man-db (2.10.2-1) ... 144s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 144s Processing triggers for dictionaries-common (1.28.14) ... 147s autopkgtest [13:18:21]: test run-testsuite: [----------------------- 147s Generating locales (this might take a while)... 148s en_US.UTF-8... done 148s ru_RU.ISO-8859-5... done 149s ru_RU.UTF-8... done 149s Generation complete. 150s ====== Running all tests with umask 077 ======= 150s === Running test 001_packages.t ... === 150s 1..21 150s ok 1 - /etc/os-release exists 150s ok 2 - OS is ubuntu 150s ok 3 - OS version is 22.04 150s # PostgreSQL versions installed: 14 150s ok 4 - postgresql-14 installed 150s ok 5 # skip No python2 support 150s ok 6 - postgresql-plpython3-14 installed 150s ok 7 - postgresql-plperl-14 installed 150s ok 8 - postgresql-pltcl-14 installed 150s ok 9 - postgresql-server-dev-14 installed 150s ok 10 # skip No postgresql-contrib-14 package for version 14 150s ok 11 - libecpg-dev installed 150s ok 12 - procps installed 150s ok 13 - netcat-openbsd installed 150s ok 14 - hunspell-en-us installed 150s ok 15 - system has a default UTF-8 locale 150s ok 16 - locale ru_RU exists 150s ok 17 - locale ru_RU.UTF-8 exists 150s ok 18 - user postgres in the UNIX group ssl-cert 150s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 150s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 150s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 150s === Running test 002_existing_clusters.t ... === 150s 1..8 150s # Cleanup 150s ok 1 - Cleanup: No clusters left behind 150s ok 2 - No postgres processes left behind 150s ok 3 - No files in /etc/postgresql left behind 150s ok 4 - No files in /var/lib/postgresql left behind 150s ok 5 - No files in /var/run/postgresql left behind 150s ok 6 - No files in /var/log/postgresql left behind 150s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 150s ok 8 - PostgreSQL TCP ports are closed 150s === Running test 005_PgCommon.t ... === 150s 1..24 150s ok 1 - correctly parsed line 'local all postgres ident sameuser' 150s ok 2 - correctly parsed line 'local foo nobody trust' 150s ok 3 - correctly parsed line 'local foo nobody crypt' 150s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 150s ok 5 - correctly parsed line 'local foo,bar nobody ident' 150s ok 6 - correctly parsed line 'local all +foogrp password' 150s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 150s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 150s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 150s ok 10 - @expected_records has correct number of entries 150s ok 11 - returned read_pg_hba array has correct number of records 150s ok 12 - line 'foo all all md5' parsed as invalid 150s ok 13 - line 'local all all foo' parsed as invalid 150s ok 14 - line 'host all all foo' parsed as invalid 150s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 150s ok 16 - line 'host all all md5' parsed as invalid 150s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 150s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 150s ok 19 - read_conf_file returns empty dict for nonexisting file 150s ok 20 - read_conf_file() parsing 150s ok 21 - read_conf_file() parsing with include directives 150s ok 22 - set_conf_value 150s ok 23 - disable_conf_value 150s ok 24 - replace_conf_value 150s === Running test 006_next_free_port.t ... === 150s 1..5 150s ok 1 - next_free_port is 5432 151s ok 2 - next_free_port detects localhost ipv4 socket 152s ok 3 - next_free_port detects wildcard ipv4 socket 153s ok 4 - next_free_port detects localhost ipv6 socket 154s ok 5 - next_free_port detects wildcard ipv6 socket 154s === Running test 007_pg_conftool.t ... === 154s 1..41 154s # test without cluster 154s ok 1 - pg_conftool show all 154s ok 2 - correct output of pg_conftool show all 154s ok 3 - pg_conftool foo.conf show all 154s ok 4 - correct output of pg_conftool foo.conf show all 154s ok 5 - pg_conftool /tmp/O_hxqXyDyD/different.conf show all 154s ok 6 - correct output of pg_conftool /tmp/O_hxqXyDyD/different.conf show all 154s ok 7 - pg_conftool 9.7 main show all 154s ok 8 - correct output of pg_conftool 9.7 main show all 154s # test show 154s ok 9 - pg_conftool show all 154s ok 10 - correct output of pg_conftool show all 154s ok 11 - pg_conftool other.conf show all 154s ok 12 - correct output of pg_conftool other.conf show all 154s ok 13 - pg_conftool /tmp/O_hxqXyDyD/different.conf show all 154s ok 14 - correct output of pg_conftool /tmp/O_hxqXyDyD/different.conf show all 154s ok 15 - pg_conftool 14 main show all 154s ok 16 - correct output of pg_conftool 14 main show all 154s ok 17 - pg_conftool 14 main other.conf show all 154s ok 18 - correct output of pg_conftool 14 main other.conf show all 154s ok 19 - pg_conftool show a 154s ok 20 - correct output of pg_conftool show a 154s ok 21 - pg_conftool -s show a 154s ok 22 - correct output of pg_conftool -s show a 154s # test set 154s ok 23 - pg_conftool set c 7 154s ok 24 - correct output of pg_conftool set c 7 154s ok 25 - file contains new setting 154s ok 26 - pg_conftool set a 8 154s ok 27 - correct output of pg_conftool set a 8 154s ok 28 - file contains updated setting 154s ok 29 - pg_conftool /tmp/O_hxqXyDyD/different.conf set a 9 154s ok 30 - correct output of pg_conftool /tmp/O_hxqXyDyD/different.conf set a 9 154s ok 31 - file with path contains updated setting 154s # test remove 154s ok 32 - pg_conftool remove a 154s ok 33 - correct output of pg_conftool remove a 154s ok 34 - setting removed from file 154s ok 35 - pg_conftool /tmp/O_hxqXyDyD/different.conf remove a 154s ok 36 - correct output of pg_conftool /tmp/O_hxqXyDyD/different.conf remove a 154s ok 37 - setting removed from file with path 154s # test edit 154s ok 38 - pg_conftool edit 154s ok 39 - correct output of pg_conftool edit 154s ok 40 - pg_conftool /tmp/O_hxqXyDyD/different.conf edit 154s ok 41 - correct output of pg_conftool /tmp/O_hxqXyDyD/different.conf edit 154s === Running test 010_defaultport_cluster.t ... === 154s 1..14 154s ok 1 - psql --version 154s ok 2 - pg_wrapper selects highest available version number 154s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 154s ok 4 - connecting to localhost fails with no clusters 154s ok 5 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -l 154s ok 6 - pg_wrapper uses host and port from PGCLUSTER 155s ok 7 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --cluster 14/127.0.0.3:5430 -l 155s ok 8 - pg_wrapper uses --cluster from the command line 155s ok 9 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -h 127.0.0.3 -l 155s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 155s ok 11 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --host 127.0.0.3 -l 155s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 155s ok 13 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 155s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 155s === Running test 012_maintscripts.t ... === 155s 1..14 155s # We are running systemd 158s ok 1 - pg_createcluster 14 main --start 158s ok 2 - postmaster PID is 4970 158s ok 3 - dpkg-reconfigure --frontend=noninteractive postgresql-common 158s ok 4 - postmaster PID is 4970 158s ok 5 - postmaster was not restarted 159s ok 6 - pg_dropcluster 14 main --stop 159s # Cleanup 159s ok 7 - Cleanup: No clusters left behind 159s ok 8 - No postgres processes left behind 159s ok 9 - No files in /etc/postgresql left behind 159s ok 10 - No files in /var/lib/postgresql left behind 159s ok 11 - No files in /var/run/postgresql left behind 159s ok 12 - No files in /var/log/postgresql left behind 159s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 159s ok 14 - PostgreSQL TCP ports are closed 159s === Running test 015_start_stop.t ... === 159s 1..71 159s # We are running systemd 159s # Running tests for 14 159s # Cluster does not exist yet 159s ok 1 - cluster 14 main does not exist 159s ok 2 - service postgresql@14-main does not exist 159s ok 3 - systemctl start postgresql 159s ok 4 - cluster 14 main does not exist 159s ok 5 - service postgresql@14-main does not exist 159s ok 6 - systemctl start postgresql@14-main 159s ok 7 - cluster 14 main does not exist 159s ok 8 - service postgresql@14-main does not exist 159s # Start/stop postgresql using system tools 160s ok 9 - pg_createcluster 14 main 160s ok 10 - cluster 14 main is stopped 160s ok 11 - service postgresql@14-main is stopped 162s ok 12 - systemctl start postgresql 162s ok 13 - cluster 14 main is running 162s ok 14 - service postgresql@14-main is running 162s ok 15 - systemctl start postgresql 162s ok 16 - cluster 14 main is already running 162s ok 17 - service postgresql@14-main is already running 162s ok 18 - systemctl stop postgresql 169s ok 19 - cluster 14 main is stopped 169s ok 20 - service postgresql@14-main is stopped 169s ok 21 - systemctl stop postgresql 169s ok 22 - cluster 14 main is already stopped 169s ok 23 - service postgresql@14-main is already stopped 169s # Start/stop specific cluster using system tools 171s ok 24 - systemctl start postgresql@14-main 171s ok 25 - cluster 14 main is running 171s ok 26 - service postgresql@14-main is running 171s ok 27 - systemctl start postgresql@14-main 171s ok 28 - cluster 14 main is running 171s ok 29 - service postgresql@14-main is running 173s ok 30 - systemctl restart postgresql@14-main 173s ok 31 - cluster 14 main is running 173s ok 32 - service postgresql@14-main is running 173s ok 33 - systemctl stop postgresql@14-main 173s ok 34 - cluster 14 main is stopped 173s ok 35 - service postgresql@14-main is stopped 173s ok 36 - systemctl stop postgresql@14-main 173s ok 37 - cluster 14 main is already stopped 173s ok 38 - service postgresql@14-main is already stopped 174s ok 39 - pg_dropcluster 14 main 174s ok 40 - cluster 14 main does not exist 174s ok 41 - service postgresql@14-main does not exist 174s # Start/stop specific cluster using pg_*cluster 174s ok 42 - pg_ctlcluster start 14 main 174s ok 43 - cluster 14 main does not exist 174s ok 44 - service postgresql@14-main does not exist 177s ok 45 - pg_createcluster 14 main --start 177s ok 46 - cluster 14 main is running 177s ok 47 - service postgresql@14-main is running 177s ok 48 - pg_ctlcluster 14 main start 178s ok 49 - cluster 14 main is already running 178s ok 50 - service postgresql@14-main is already running 180s ok 51 - pg_ctlcluster 14-main restart 180s ok 52 - cluster 14 main is running 180s ok 53 - service postgresql@14-main is running 180s ok 54 - pg_ctlcluster 14 main stop 180s ok 55 - cluster 14 main is stopped 180s ok 56 - service postgresql@14-main is stopped 180s ok 57 - pg_ctlcluster 14 main stop 180s ok 58 - cluster 14 main is already stopped 180s ok 59 - service postgresql@14-main is already stopped 182s ok 60 - pg_ctlcluster start 14-main 182s ok 61 - cluster 14 main is running 182s ok 62 - service postgresql@14-main is running 183s ok 63 - pg_dropcluster 14 main --stop 183s # Cleanup 183s ok 64 - Cleanup: No clusters left behind 183s ok 65 - No postgres processes left behind 183s ok 66 - No files in /etc/postgresql left behind 183s ok 67 - No files in /var/lib/postgresql left behind 183s ok 68 - No files in /var/run/postgresql left behind 183s ok 69 - No files in /var/log/postgresql left behind 183s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 183s ok 71 - PostgreSQL TCP ports are closed 183s === Running test 020_create_sql_remove.t ... === 183s 1..147 183s # Running tests for 14 186s ok 1 - pg_createcluster 14 main --start -- -X /tmp/14.xlog.irURBB 186s ok 2 - pg_createcluster 14 main 186s ok 3 - Socket and pid file are in /var/run/postgresql/ 186s ok 4 - xlog/wal directory /tmp/14.xlog.irURBB was created 186s ok 5 - local method in pg_hba.conf is peer 186s ok 6 - host method in pg_hba.conf is scram-sha-256 186s ok 7 - Exactly one postgres master process running 189s ok 8 - pg_ctlcluster 14 main restart 189s ok 9 - cluster restarts with new environment file 189s ok 10 - Exactly one postgres master process running 189s ok 11 - correct value of PGEXTRAVAR1 in environment 189s ok 12 - correct value of PGEXTRAVAR2 in environment 189s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 189s ok 14 - createdb --version 189s ok 15 - pg_wrapper selects version number of cluster 189s ok 16 - psql --version 189s ok 17 - pg_wrapper selects version number of cluster 189s ok 18 - pg_lscluster reports online cluster on port 5432 189s ok 19 - log file is actually used 189s ok 20 - /etc/postgresql is owned by user "postgres" 189s ok 21 - version configuration directory file is owned by user "postgres" 189s ok 22 - configuration directory file is owned by user "postgres" 189s ok 23 - version data directory file is owned by user "postgres" 189s ok 24 - data directory file is owned by user "postgres" 189s ok 25 - log file has 0640 permissions 189s ok 26 - log file is owned by user "postgres" 189s ok 27 - log file is owned by group "adm" 189s ok 28 - no log symlink by default 189s ok 29 - /var/log/postgresql/postgresql-14-main.log is the default log if log symlink is missing 189s ok 30 - pg_lsclusters -h 189s ok 31 - correct output of pg_lsclusters -h 189s 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 192s 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 197s ok 49 - restarting cluster 197s ok 50 - ps -o tty -U postgres h 197s ok 51 - postgres processes do not have an associated terminal 197s ok 52 - Server is linked with SSL support 197s ok 53 - SSL is enabled in postgresql.conf 197s ok 54 - psql -l fails for nobody 197s ok 55 - createuser nobody 197s ok 56 - createdb nobodydb 197s ok 57 - psql -ltA succeeds for nobody 197s ok 58 - psql -ltA output 197s ok 59 - SQL command: create table 197s 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 197s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 197s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 197s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 197s ok 102 - creating PL/Tcl function as user nobody succeeds 197s 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;" 197s ok 104 - creating PL/TclU function as user postgres succeeds 197s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 197s ok 106 - calling PL/Tcl function 197s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 197s 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 200s ok 114 - postgres master has OOM killer protection 200s ok 115 - postgres client backend has no OOM adjustment 200s ok 116 - ps h 6551 200s ok 117 - process title is idle 201s ok 118 - ps h 6551 201s ok 119 - process title is idle in transaction 201s ok 120 - stopping cluster 203s ok 121 - starting cluster as postgres works without a log file 203s ok 122 - log file got recreated and used 203s ok 123 - creating a directory in spc2 203s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/14.spc1.Y2mn48'" 203s ok 125 - creating tablespace spc1 203s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 203s ok 127 - creating a table in spc1 203s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/14.spc2.eK8unY'" 203s ok 129 - creating tablespace spc2 203s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 203s ok 131 - creating a table in spc2 203s ok 132 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 203s ok 133 - Correct apt NeverAutoRemove config 204s ok 134 - pg_dropcluster removes cluster 204s ok 135 - xlog/wal directory /tmp/14.xlog.irURBB was deleted 204s ok 136 - tablespace spc1 was emptied 204s ok 137 - tablespace spc2 was emptied 204s ok 138 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 204s ok 139 - Correct apt NeverAutoRemove config 204s # Cleanup 204s ok 140 - Cleanup: No clusters left behind 204s ok 141 - No postgres processes left behind 204s ok 142 - No files in /etc/postgresql left behind 204s ok 143 - No files in /var/lib/postgresql left behind 204s ok 144 - No files in /var/run/postgresql left behind 204s ok 145 - No files in /var/log/postgresql left behind 204s ok 146 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 204s ok 147 - PostgreSQL TCP ports are closed 204s === Running test 021_pg_renamecluster.t ... === 204s 1..20 207s ok 1 - pg_createcluster 14 main 210s ok 2 - pg_renamecluster 14 main donau 210s ok 3 - psql -tAc "show data_directory" 210s ok 4 - cluster is running and data_directory was moved 210s ok 5 - pg_hba.conf location updated 210s ok 6 - pg_ident.conf location updated 210s ok 7 - external_pid_file location updated 210s ok 8 - external_pid_file exists 210s ok 9 - stats_temp_directory location updated 210s ok 10 - stats_temp_directory exists 210s ok 11 - cluster_name is updated 211s ok 12 - pg_dropcluster removes cluster 211s # Cleanup 211s ok 13 - Cleanup: No clusters left behind 211s ok 14 - No postgres processes left behind 211s ok 15 - No files in /etc/postgresql left behind 211s ok 16 - No files in /var/lib/postgresql left behind 211s ok 17 - No files in /var/run/postgresql left behind 211s ok 18 - No files in /var/log/postgresql left behind 211s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 211s ok 20 - PostgreSQL TCP ports are closed 211s === Running test 022_recovery.t ... === 211s 1..17 211s # Running tests for 14 214s ok 1 - pg_createcluster 14 main --start >/dev/null 214s ok 2 - pg_ctlcluster 14 main stop -m i 216s ok 3 - pg_ctlcluster 14 main start 216s ok 4 - psql -c '' 216s ok 5 - pg_ctlcluster 14 main stop -m i 216s ok 6 - create write-protected file in data directory 219s ok 7 - pg_ctlcluster 14 main start 219s ok 8 - psql -c '' 220s ok 9 - pg_dropcluster removes cluster 220s # Cleanup 220s ok 10 - Cleanup: No clusters left behind 220s ok 11 - No postgres processes left behind 220s ok 12 - No files in /etc/postgresql left behind 220s ok 13 - No files in /var/lib/postgresql left behind 220s ok 14 - No files in /var/run/postgresql left behind 220s ok 15 - No files in /var/log/postgresql left behind 220s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 220s ok 17 - PostgreSQL TCP ports are closed 220s === Running test 025_logging.t ... === 220s 1..55 220s # Logging to /var/log/syslog works 220s # Running tests for 14 223s ok 1 - pg_createcluster 14 main 223s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-14-main.log 223s ok 3 - psql -qc "'foobar_14_7489'" 223s ok 4 - log an error 224s ok 5 - grep --binary-files=text foobar_14_7489 /var/log/postgresql/postgresql-14-main.log 224s ok 6 - error appears in logfile 224s ok 7 - pg_conftool 14 main set log_destination syslog 224s ok 8 - set log_destination syslog 224s ok 9 - pg_ctlcluster 14 main reload 224s ok 10 - 14 main reload 224s ok 11 - psql -Atc "show log_destination" 224s ok 12 - log_destination is syslog 224s ok 13 - pg_lscluster reports syslog 224s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 224s ok 15 - error appears in /var/log/syslog 224s ok 16 - pg_conftool 14 main set logging_collector on 224s ok 17 - set logging_collector on 224s ok 18 - pg_conftool 14 main set log_destination csvlog 224s ok 19 - set log_destination csvlog 227s ok 20 - pg_ctlcluster 14 main restart 227s ok 21 - 14 main restart 227s ok 22 - psql -Atc "show logging_collector" 227s ok 23 - logging_collector is on 227s ok 24 - psql -Atc "show log_destination" 227s ok 25 - log_destination is csvlog 227s ok 26 - pg_lscluster reports csvlog 227s ok 27 - psql -qc "'barbaz_14_7489'" 227s ok 28 - log an error 227s ok 29 - grep --binary-files=text barbaz_14_7489 /var/lib/postgresql/14/main/log/*.csv 227s ok 30 - error appears in log/*.csv 227s ok 31 - pg_conftool 14 main set log_destination stderr,syslog,csvlog 227s ok 32 - set log_destination stderr,syslog,csvlog 227s ok 33 - pg_ctlcluster 14 main reload 227s ok 34 - 14 main reload 227s ok 35 - psql -Atc "show log_destination" 227s ok 36 - log_destination is stderr,syslog,csvlog 227s ok 37 - pg_lscluster reports stderr,syslog,csvlog 228s ok 38 - psql -qc "'moo_14_7489'" 228s ok 39 - log an error 228s ok 40 - grep --binary-files=text moo_14_7489 /var/lib/postgresql/14/main/log/*.log 228s ok 41 - error appears in log/*.log 229s ok 42 - grep --binary-files=text 'postgres.*moo_14_7489' /var/log/syslog 229s ok 43 - error appears in /var/log/syslog 229s ok 44 - grep --binary-files=text moo_14_7489 /var/lib/postgresql/14/main/log/*.csv 229s ok 45 - error appears in log/*.csv 230s ok 46 - pg_dropcluster 14 main --stop 230s ok 47 - pg_dropcluster removes cluster 230s # Cleanup 230s ok 48 - Cleanup: No clusters left behind 230s ok 49 - No postgres processes left behind 230s ok 50 - No files in /etc/postgresql left behind 230s ok 51 - No files in /var/lib/postgresql left behind 230s ok 52 - No files in /var/run/postgresql left behind 230s ok 53 - No files in /var/log/postgresql left behind 230s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 230s ok 55 - PostgreSQL TCP ports are closed 230s === Running test 030_errors.t ... === 230s 1..156 230s ok 1 - pg_lscluster reports cluster without binaries 230s ok 2 - pg_dropcluster 6.3 main 231s ok 3 - pg_createcluster --socketdir 231s ok 4 - pg_lsclusters -h 231s ok 5 - cluster was created 231s ok 6 - Port of created cluster is 5432 231s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 14 main 231s ok 8 - pg_createcluster on existing cluster 231s ok 9 - pg_lsclusters -h 231s ok 10 - original cluster still exists 231s ok 11 - pg_createcluster 14 test -p foo 231s ok 12 - pg_createcluster -p checks that port option is numeric 231s ok 13 - pg_createcluster 14 test -p 42 231s ok 14 - pg_createcluster -p checks valid port range 231s ok 15 - pg_ctlcluster 14 main start 231s ok 16 - pg_ctlcluster refuses to start root-owned cluster 231s ok 17 - pg_ctlcluster 14 main start 231s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 231s ok 19 - pg_ctlcluster 14 main start 231s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 231s ok 21 - pg_ctlcluster 14 main start 231s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 233s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 233s ok 24 - No sockets in /var/run/postgresql 233s ok 25 - Socket is in /tmp/postgresql-testsuite/ 234s ok 26 - cluster stops with custom unix_socket_dir 234s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 236s ok 28 - cluster starts after removing unix_socket_dir 236s ok 29 - Socket is in default dir /var/run/postgresql 236s ok 30 - No sockets in /tmp/postgresql-testsuite/ 236s ok 31 - pg_ctlcluster 14 main stop 236s ok 32 - pg_ctlcluster fails with corrupted PID file 236s ok 33 - pg_lsclusters -h 236s ok 34 - cluster is still online 236s ok 35 - pg_ctlcluster succeeds with restored PID file 236s ok 36 - pg_lsclusters -h 236s ok 37 - cluster is down 236s ok 38 - pg_ctlcluster 14 main stop 236s ok 39 - pg_ctlcluster stop fails on stopped cluster 238s ok 40 - pg_ctlcluster 14 main start 238s ok 41 - pg_ctlcluster succeeds with already existing PID file 238s ok 42 - pg_lsclusters -h 238s ok 43 - cluster is online 238s ok 44 - pg_ctlcluster stop succeeds 238s ok 45 - pg_lsclusters -h 238s ok 46 - cluster is down 238s ok 47 - no pid file left 238s ok 48 - pg_ctlcluster 14 main stop 238s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 238s ok 50 - pid file was cleaned up 238s ok 51 - pg_ctlcluster --force 14 main stop 238s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 238s ok 53 - pid file was cleaned up 239s ok 54 - pg_ctlcluster 14 main stop 239s ok 55 - pg_ctlcluster stop succeeds with stale PID file 239s ok 56 - pid file was cleaned up 239s ok 57 - pg_ctlcluster --force 14 main stop 239s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 239s ok 59 - pid file was cleaned up 239s ok 60 - pg_ctlcluster --force 14 main stop 239s ok 61 - pg_ctlcluster stop succeeds with empty PID file 239s ok 62 - pid file was cleaned up 241s ok 63 - pg_ctlcluster 14 main start 241s ok 64 - pg_ctlcluster succeeds with corrupted PID file 241s ok 65 - pg_lsclusters -h 241s ok 66 - cluster is online 241s ok 67 - pg_ctlcluster 14 main start 241s ok 68 - pg_ctlcluster start fails on running cluster 241s ok 69 - pg_ctlcluster stop 241s ok 70 - pg_ctlcluster 14 main start 241s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 241s ok 72 - pg_ctlcluster 14 main stop 241s ok 73 - stopping cluster 247s ok 74 - pg_ctlcluster 14 main start 247s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 247s ok 76 - pg_ctlcluster 14 main stop 247s ok 77 - stopping cluster 247s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 248s ok 79 - pg_dropcluster 14 main 248s ok 80 - pg_dropcluster works as user postgres 248s ok 81 - pg_createcluster succeeds 248s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 248s ok 83 - proper error message for nonexisting /var/lib/postgresql 250s ok 84 - pg_ctlcluster 14 main start 250s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 251s ok 86 - pg_ctlcluster 14 main stop 251s ok 87 - stopping cluster 251s ok 88 - pg_createcluster other 253s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 256s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 256s ok 91 256s ok 92 - pg_ctlcluster 14 other start 256s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 256s ok 94 - pg_ctlcluster 14 main stop 256s ok 95 - stopping main cluster 258s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 259s ok 97 - pg_dropcluster other 260s ok 98 - pg_dropcluster 260s ok 99 - No sockets any more 260s ok 100 - 'pg_lsclusters 4.5 foo' fails 260s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 260s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 260s ok 103 - 'psql --cluster 4.5/foo' fails 260s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 260s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 260s ok 106 - 'psql --cluster 14/foo' fails 260s ok 107 - psql --cluster 14/foo gives error message about nonexisting cluster 260s ok 108 - psql --cluster 14/foo does not print 'invalid symbolic link' gibberish 260s ok 109 - 'pg_dropcluster 4.5 foo' fails 260s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 260s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 260s ok 112 - 'pg_dropcluster 14 foo' fails 260s ok 113 - pg_dropcluster 14 foo gives error message about nonexisting cluster 260s ok 114 - pg_dropcluster 14 foo does not print 'invalid symbolic link' gibberish 260s ok 115 - 'pg_upgradecluster 4.5 foo' fails 260s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 260s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 260s ok 118 - 'pg_upgradecluster 14 foo' fails 260s ok 119 - pg_upgradecluster 14 foo gives error message about nonexisting cluster 260s ok 120 - pg_upgradecluster 14 foo does not print 'invalid symbolic link' gibberish 260s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 260s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 260s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 260s ok 124 - 'pg_ctlcluster 14 foo stop' fails 260s ok 125 - pg_ctlcluster 14 foo stop gives error message about nonexisting cluster 260s ok 126 - pg_ctlcluster 14 foo stop does not print 'invalid symbolic link' gibberish 260s # Cleanup 260s ok 127 - Cleanup: No clusters left behind 260s ok 128 - No postgres processes left behind 260s ok 129 - No files in /etc/postgresql left behind 260s ok 130 - No files in /var/lib/postgresql left behind 260s ok 131 - No files in /var/run/postgresql left behind 260s ok 132 - No files in /var/log/postgresql left behind 260s ok 133 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 260s ok 134 - PostgreSQL TCP ports are closed 261s ok 135 - pg_dropcluster 14 broken 261s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 261s # Cleanup 261s ok 137 - Cleanup: No clusters left behind 261s ok 138 - No postgres processes left behind 261s ok 139 - No files in /etc/postgresql left behind 261s ok 140 - No files in /var/lib/postgresql left behind 261s ok 141 - No files in /var/run/postgresql left behind 261s ok 142 - No files in /var/log/postgresql left behind 261s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 261s ok 144 - PostgreSQL TCP ports are closed 262s ok 145 - pg_dropcluster 14 broken 262s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 262s ok 147 - /etc/postgresql/14 was removed 262s ok 148 - /var/lib/postgresql/14 was removed 262s # Cleanup 262s ok 149 - Cleanup: No clusters left behind 262s ok 150 - No postgres processes left behind 262s ok 151 - No files in /etc/postgresql left behind 262s ok 152 - No files in /var/lib/postgresql left behind 262s ok 153 - No files in /var/run/postgresql left behind 262s ok 154 - No files in /var/log/postgresql left behind 262s ok 155 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 262s ok 156 - PostgreSQL TCP ports are closed 262s === Running test 031_errors_disk_full.t ... === 262s 1..22 262s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 263s ok 1 - script failed 263s ok 2 - pg_createcluster fails due to insufficient disk space 263s ok 3 - does not leave files behind 263s # Cleanup 263s ok 4 - Cleanup: No clusters left behind 263s ok 5 - No postgres processes left behind 263s ok 6 - No files in /etc/postgresql left behind 263s ok 7 - No files in /var/lib/postgresql left behind 263s ok 8 - No files in /var/run/postgresql left behind 263s ok 9 - No files in /var/log/postgresql left behind 263s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 263s ok 11 - PostgreSQL TCP ports are closed 263s # check disk full conditions on startup 264s ok 12 - script failed 264s ok 13 - pg_ctlcluster prints error message 264s ok 14 - log file has error message 264s # Cleanup 264s ok 15 - Cleanup: No clusters left behind 264s ok 16 - No postgres processes left behind 264s ok 17 - No files in /etc/postgresql left behind 264s ok 18 - No files in /var/lib/postgresql left behind 264s ok 19 - No files in /var/run/postgresql left behind 264s ok 20 - No files in /var/log/postgresql left behind 264s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 264s ok 22 - PostgreSQL TCP ports are closed 264s === Running test 032_ssl_key_permissions.t ... === 265s 1..22 265s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 265s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 265s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 265s # 14 (14.15-0ubuntu0.22.04.1) 265s ok 4 - pg_createcluster 14 main 265s ok 5 - pg_ctlcluster 14 main start 265s ok 6 - ssl key owned by nobody refused 266s ok 7 - pg_ctlcluster 14 main start 266s ok 8 - ssl key with permissions root:root 0644 refused 266s ok 9 - pg_ctlcluster 14 main start 266s ok 10 - ssl key with permissions postgres:postgres 0640 refused 266s ok 11 - pg_dropcluster 14 main --stop 266s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 266s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 266s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 266s # Cleanup 266s ok 15 - Cleanup: No clusters left behind 266s ok 16 - No postgres processes left behind 266s ok 17 - No files in /etc/postgresql left behind 266s ok 18 - No files in /var/lib/postgresql left behind 266s ok 19 - No files in /var/run/postgresql left behind 266s ok 20 - No files in /var/log/postgresql left behind 266s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 266s ok 22 - PostgreSQL TCP ports are closed 266s === Running test 040_upgrade.t ... === 267s 1..1 267s ok 1 - only one major version installed, skipping upgrade tests 267s === Running test 041_upgrade_custompaths.t ... === 267s 1..1 267s ok 1 - only one major version installed, skipping upgrade tests 267s === Running test 043_upgrade_ssl_cert.t ... === 267s 1..1 267s ok 1 - only one major version installed, skipping upgrade tests 267s === Running test 045_backup.t ... === 267s # We are running systemd 267s # PostgreSQL 14 267s # create cluster 270s ok 1 - pg_createcluster --locale en_US.UTF-8 14 main --start 270s ok 2 - pg_lsclusters -h 270s ok 3 - correct output of pg_lsclusters -h 270s ok 4 - pg_conftool 14 main set work_mem 11MB 270s ok 5 - createdb -E SQL_ASCII -T template0 mydb 270s ok 6 - psql -c 'alter database mydb set search_path=public' 270s ok 7 - psql -c 'create table foo (t text)' mydb 270s ok 8 - psql -c "insert into foo values ('important data')" mydb 270s ok 9 - psql -c 'CREATE USER myuser' 270s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 270s ok 11 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 270s # create directory 270s ok 12 - pg_backupcluster 14 main createdirectory 270s ok 13 - /var/backups/postgresql/14-main owned by uid postgres 270s ok 14 - /var/backups/postgresql/14-main owned by gid postgres 270s # dump 270s ok 15 - systemctl start pg_dump@14-main 270s ok 16 - dump created in /var/backups/postgresql/14-main/2025-02-26T132024Z.dump 270s ok 17 - /var/backups/postgresql/14-main/2025-02-26T132024Z.dump owned by uid postgres 270s ok 18 - /var/backups/postgresql/14-main/2025-02-26T132024Z.dump owned by gid postgres 270s # basebackup 270s ok 19 - systemctl start pg_receivewal@14-main 275s ok 20 - systemctl start pg_basebackup@14-main 275s ok 21 - dump created in /var/backups/postgresql/14-main/2025-02-26T132024Z.backup 275s ok 22 - /var/backups/postgresql/14-main/2025-02-26T132024Z.backup owned by uid postgres 275s ok 23 - /var/backups/postgresql/14-main/2025-02-26T132024Z.backup owned by gid postgres 275s # list 275s ok 24 - pg_backupcluster 14 main list 275s ok 25 - correct output of pg_backupcluster 14 main list 275s # more database changes 275s ok 26 - psql -c "insert into foo values ('some other data')" mydb 275s ok 27 - psql -c "insert into foo values ('yet more data')" mydb 275s ok 28 - retrieve recovery timestamp 275s ok 29 - psql -c "delete from foo where t = 'some other data'" mydb 276s ok 30 - systemctl stop pg_receivewal@14-main 276s # restore /var/backups/postgresql/14-main/2025-02-26T132024Z.dump 277s ok 31 - pg_dropcluster 14 main --stop 280s ok 32 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132024Z.dump --start --datadir /var/lib/postgresql/14/snowflake 280s ok 33 - pg_lsclusters -h 280s ok 34 - correct output of pg_lsclusters -h 280s ok 35 - psql -XAtl 280s ok 36 - correct output of psql -XAtl 280s ok 37 - psql -XAtc 'show work_mem' 280s ok 38 - correct output of psql -XAtc 'show work_mem' 280s ok 39 - psql -XAtc 'select * from foo' mydb 280s ok 40 - correct output of psql -XAtc 'select * from foo' mydb 280s ok 41 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 280s ok 42 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 280s ok 43 - psql -XAtc '\drds' 280s ok 44 - correct output of psql -XAtc '\drds' 280s # restore /var/backups/postgresql/14-main/2025-02-26T132024Z.backup 281s ok 45 - pg_dropcluster 14 main --stop 284s ok 46 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132024Z.backup --start --datadir /var/lib/postgresql/14/snowflake 284s ok 47 - pg_lsclusters -h 284s ok 48 - correct output of pg_lsclusters -h 284s ok 49 - psql -XAtl 284s ok 50 - correct output of psql -XAtl 284s ok 51 - psql -XAtc 'show work_mem' 284s ok 52 - correct output of psql -XAtc 'show work_mem' 284s ok 53 - psql -XAtc 'select * from foo' mydb 284s ok 54 - correct output of psql -XAtc 'select * from foo' mydb 284s ok 55 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 284s ok 56 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 284s ok 57 - psql -XAtc '\drds' 284s ok 58 - correct output of psql -XAtc '\drds' 284s # restore /var/backups/postgresql/14-main/2025-02-26T132024Z.backup with WAL archive 285s ok 59 - pg_dropcluster 14 main --stop 288s ok 60 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132024Z.backup --start --archive --port 5430 288s ok 61 - pg_lsclusters -h 288s ok 62 - correct output of pg_lsclusters -h 288s ok 63 - psql -XAtc 'select * from foo order by t' mydb 288s ok 64 - correct output of psql -XAtc 'select * from foo order by t' mydb 288s # restore /var/backups/postgresql/14-main/2025-02-26T132024Z.backup with PITR 289s ok 65 - pg_dropcluster 14 main --stop 292s ok 66 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132024Z.backup --start --pitr '2025-02-26 13:20:29.619369+00 292s # ' 292s ok 67 - pg_lsclusters -h 292s ok 68 - correct output of pg_lsclusters -h 292s ok 69 - psql -XAtc 'select * from foo order by t' mydb 292s ok 70 - correct output of psql -XAtc 'select * from foo order by t' mydb 293s ok 71 - pg_dropcluster 14 main --stop 293s # Cleanup 293s ok 72 - Cleanup: No clusters left behind 293s ok 73 - No postgres processes left behind 293s ok 74 - No files in /etc/postgresql left behind 293s ok 75 - No files in /var/lib/postgresql left behind 293s ok 76 - No files in /var/run/postgresql left behind 293s ok 77 - No files in /var/log/postgresql left behind 293s ok 78 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 293s ok 79 - PostgreSQL TCP ports are closed 293s 1..79 293s === Running test 050_encodings.t ... === 293s 1..60 293s # Checking 14 ru_RU 296s ok 1 - pg_createcluster version 14 for ru_RU without --encoding succeeded 297s ok 2 - psql -l succeeds 297s ok 3 - template1 is not UTF-8 encoded 297s ok 4 - creating test database 297s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 297s # create table t (x varchar); copy t from stdin" test 297s ok 6 - creating table with ISO-8859-5 characters 297s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 297s ok 8 - correct string in UTF-8 297s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 297s ok 10 - correct string in ISO-8859-5 297s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 297s # delete from t; copy t from stdin" test 297s ok 12 - creating table with UTF-8 characters 297s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 297s ok 14 - correct string in UTF-8 297s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 297s ok 16 - correct string in ISO-8859-1 297s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 297s ok 18 - Server error message has correct language and encoding 299s ok 19 - pg_ctlcluster 14 ru_RU restart 299s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 300s ok 21 - Dropping cluster 300s # Checking 14 ru_RU.UTF-8 303s ok 22 - pg_createcluster version 14 for ru_RU.UTF-8 without --encoding succeeded 304s ok 23 - psql -l succeeds 304s ok 24 - template1 is UTF-8 encoded 304s ok 25 - creating test database 304s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 304s # create table t (x varchar); copy t from stdin" test 304s ok 27 - creating table with ISO-8859-5 characters 304s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 304s ok 29 - correct string in UTF-8 305s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 305s ok 31 - correct string in ISO-8859-5 305s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 305s # delete from t; copy t from stdin" test 305s ok 33 - creating table with UTF-8 characters 305s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 305s ok 35 - correct string in UTF-8 305s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 305s ok 37 - correct string in ISO-8859-1 305s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 305s ok 39 - Server error message has correct language and encoding 307s ok 40 - pg_ctlcluster 14 ru_RU.UTF8 restart 307s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 307s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 307s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 307s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 307s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 307s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 307s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 308s ok 48 - Dropping cluster 308s # Check 14 locale environment variables 311s ok 49 - pg_createcluster: LC_ALL dominates LANG 311s ok 50 - psql -Atl --cluster 14/main 311s ok 51 - template1 is ASCII encoded 312s ok 52 - Dropping cluster 312s # Cleanup 312s ok 53 - Cleanup: No clusters left behind 312s ok 54 - No postgres processes left behind 312s ok 55 - No files in /etc/postgresql left behind 312s ok 56 - No files in /var/lib/postgresql left behind 312s ok 57 - No files in /var/run/postgresql left behind 312s ok 58 - No files in /var/log/postgresql left behind 312s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 312s ok 60 - PostgreSQL TCP ports are closed 312s === Running test 052_upgrade_encodings.t ... === 312s 1..1 312s ok 1 - only one major version installed, skipping upgrade tests 312s === Running test 060_obsolete_confparams.t ... === 312s ok 1 - only one major version installed, skipping upgrade tests 312s 1..1 312s === Running test 070_non_postgres_clusters.t ... === 312s 1..40 313s ok 1 - pg_createcluster 14 main for owner nobody 313s ok 2 - pg_ctlcluster 14 main start 313s ok 3 - start refused when config and data owners mismatch 315s ok 4 - pg_ctlcluster succeeds with owner nobody 315s ok 5 - pg_lsclusters -h 315s ok 6 - pg_lsclusters shows running cluster 315s ok 7 - postgres is running as user nobody 315s ok 8 - ls /tmp/.s.PGSQL.* 315s ok 9 - socket is in /tmp 315s ok 10 - /var/run/postgresql is empty 315s ok 11 - conf dir is owned by user 315s ok 12 - conf dir is owned by user's primary group 315s ok 13 - files are owned by user 315s ok 14 - files are owned by user's primary group 315s ok 15 - log file has 0640 permissions 315s ok 16 - log file is owned by user 315s ok 17 - log file is owned by user's primary group 315s ok 18 - only one major version installed, skipping upgrade test 315s ok 19 - ... 315s ok 20 - ... 315s ok 21 - ... 315s ok 22 - ... 315s ok 23 - ... 315s ok 24 - ... 315s ok 25 - ... 315s ok 26 - ... 315s ok 27 - ... 315s ok 28 - ... 316s ok 29 - pg_dropcluster 316s ok 30 - pg_lsclusters -h 316s ok 31 - No clusters left 316s ok 32 - No postgres processes left 316s # Cleanup 316s ok 33 - Cleanup: No clusters left behind 316s ok 34 - No postgres processes left behind 316s ok 35 - No files in /etc/postgresql left behind 316s ok 36 - No files in /var/lib/postgresql left behind 316s ok 37 - No files in /var/run/postgresql left behind 316s ok 38 - No files in /var/log/postgresql left behind 316s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 316s ok 40 - PostgreSQL TCP ports are closed 316s === Running test 080_start.conf.t ... === 316s 1..73 317s ok 1 - pg_createcluster 14 main 317s # start.conf auto 317s ok 2 - get_cluster_start_conf returns auto 317s ok 3 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 317s ok 4 - start.conf contains auto 317s ok 5 - systemd generator links cluster 317s ok 6 - systemd generator links correct service file 319s ok 7 - /etc/init.d/postgresql start 14 319s ok 8 - correct output of /etc/init.d/postgresql start 14 319s ok 9 - pg_lsclusters -h 319s ok 10 - cluster is online 319s ok 11 - /etc/init.d/postgresql stop 14 319s ok 12 - correct output of /etc/init.d/postgresql stop 14 322s ok 13 - pg_lsclusters -h 322s ok 14 - cluster is down 322s # start.conf manual 322s ok 15 - get_cluster_start_conf returns manual 322s ok 16 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 322s ok 17 - start.conf contains manual 323s ok 18 - systemd generator doesn't link cluster 323s ok 19 - /etc/init.d/postgresql start 14 323s ok 20 - correct output of /etc/init.d/postgresql start 14 323s ok 21 - pg_lsclusters -h 323s ok 22 - cluster is down 325s ok 23 - pg_ctlcluster 14 main start 325s ok 24 - correct output of pg_ctlcluster 14 main start 325s ok 25 - pg_lsclusters -h 325s ok 26 - cluster is online 325s ok 27 - pg_ctlcluster 14 main stop 325s ok 28 - correct output of pg_ctlcluster 14 main stop 325s ok 29 - pg_lsclusters -h 325s ok 30 - cluster is down 325s # start.conf disabled 325s ok 31 - get_cluster_start_conf returns disabled 325s ok 32 - systemd generator doesn't link cluster 325s ok 33 - /etc/init.d/postgresql start 14 325s ok 34 - correct output of /etc/init.d/postgresql start 14 325s ok 35 - pg_lsclusters -h 325s ok 36 - cluster is down 325s ok 37 - pg_ctlcluster 14 main start 325s ok 38 - correct output of pg_ctlcluster 14 main start 325s ok 39 - pg_lsclusters -h 325s ok 40 - cluster is down 327s ok 41 - pg_ctlcluster 14 main start 327s ok 42 - correct output of pg_ctlcluster 14 main start 327s ok 43 - pg_lsclusters -h 327s ok 44 - cluster is online 328s ok 45 - pg_ctlcluster 14 main stop 328s ok 46 - correct output of pg_ctlcluster 14 main stop 328s ok 47 - pg_lsclusters -h 328s ok 48 - cluster is down 330s ok 49 - pg_ctlcluster 14 main start 330s ok 50 - correct output of pg_ctlcluster 14 main start 330s ok 51 - pg_lsclusters -h 330s ok 52 - cluster is online 330s # test upgrade 330s ok 53 - only one major version installed, skipping upgrade test 330s ok 54 - ... 330s ok 55 - get_cluster_start_conf for old cluster returns manual 330s ok 56 - get_cluster_start_conf for new cluster returns manual 330s ok 57 - ... 331s ok 58 - dropping upgraded cluster 331s ok 59 - pg_lsclusters -h 331s ok 60 - no clusters any more 331s ok 61 - pg_createcluster 14 main --start-conf foo 331s ok 62 - pg_createcluster checks --start-conf validity 331s ok 63 - pg_createcluster checks --start-conf manual 331s ok 64 - get_cluster_start_conf returns manual 332s ok 65 - dropping cluster 332s # Cleanup 332s ok 66 - Cleanup: No clusters left behind 332s ok 67 - No postgres processes left behind 332s ok 68 - No files in /etc/postgresql left behind 332s ok 69 - No files in /var/lib/postgresql left behind 332s ok 70 - No files in /var/run/postgresql left behind 332s ok 71 - No files in /var/log/postgresql left behind 332s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 332s ok 73 - PostgreSQL TCP ports are closed 332s === Running test 085_pg_ctl.conf.t ... === 332s 1..29 333s ok 1 - pg_createcluster 14 main 333s ok 2 - /etc/postgresql/14/main/pg_ctl.conf exists 335s ok 3 - pg_ctlcluster 14 main start 335s ok 4 - starting cluster 335s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 335s ok 6 - soft core size is 0 335s ok 7 - set pg_ctl default option to -c 337s ok 8 - pg_ctlcluster 14 main restart 337s ok 9 - restarting cluster 337s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 337s ok 11 - soft core size is unlimited 337s ok 12 - restored pg_ctl default option 340s ok 13 - pg_ctlcluster 14 main restart 340s ok 14 - restarting cluster 340s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 340s ok 16 - soft core size is 0 342s ok 17 - pg_ctlcluster 14 main restart -- -c 342s ok 18 - restarting cluster with -c on the command line 342s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 342s ok 20 - soft core size is unlimited 343s ok 21 - dropping cluster 343s # Cleanup 343s ok 22 - Cleanup: No clusters left behind 343s ok 23 - No postgres processes left behind 343s ok 24 - No files in /etc/postgresql left behind 343s ok 25 - No files in /var/lib/postgresql left behind 343s ok 26 - No files in /var/run/postgresql left behind 343s ok 27 - No files in /var/log/postgresql left behind 343s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 343s ok 29 - PostgreSQL TCP ports are closed 343s === Running test 090_multicluster.t ... === 343s 1..125 344s ok 1 - pg_createcluster 14 old 344s ok 2 - pg_createcluster 14 new1 345s ok 3 - pg_createcluster 14 new2 347s ok 4 - starting cluster 14/old 349s ok 5 - starting cluster 14/new1 352s ok 6 - starting cluster 14/new2 352s ok 7 - pg_lsclusters -h | sort -k3 352s ok 8 - clusters have the correct ports, skipping used 5433 352s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 352s ok 10 - createdb --version 352s ok 11 - pg_wrapper selects port 5432 as default cluster 352s ok 12 - createdb --cluster 14/new1 --version 352s ok 13 - pg_wrapper --cluster works 352s ok 14 - createdb --cluster 14/foo --version 352s ok 15 - pg_wrapper --cluster errors out for invalid cluster 352s ok 16 - createdb --cluster 14/new1 test 352s ok 17 - correct output of createdb --cluster 14/new1 test 352s ok 18 - psql -Atl --cluster 14/new1 352s ok 19 - test db appears in cluster new1 352s ok 20 - psql -Atl --cluster 14/new2 352s ok 21 - test db does not appear in cluster new2 352s ok 22 - psql -Atl 352s ok 23 - test db does not appear in default cluster 352s ok 24 - psql --cluster 14/127.0.0.1: -Atc 'show port' template1 352s ok 25 - psql --cluster 14/127.0.0.1: defaults to port 5432 352s ok 26 - createdb --cluster 14/127.0.0.1:5432 --version 352s ok 27 - createdb --cluster 14/127.0.0.1:5432 uses latest client version 352s ok 28 - psql -Atl --cluster 14/localhost:5434 352s ok 29 - test db appears in cluster 14/localhost:5434 352s ok 30 - psql -Atl --cluster 14/localhost:5440 352s ok 31 - test db does not appear in cluster 14/localhost:5440 352s ok 32 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:5435 352s ok 33 - psql --cluster 14/localhost:5435 fails due to nonexisting port 352s ok 34 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:a 352s ok 35 - psql --cluster 14/localhost:a fails due to invalid syntax 352s ok 36 - LC_MESSAGES=C psql -Atl --cluster 14/doesnotexi.st 352s ok 37 - psql --cluster 14/doesnotexi.st fails due to invalid syntax 352s ok 38 - psql -Atl --cluster 6.4/localhost: 352s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 352s ok 40 - psql -Atl 352s ok 41 - PGCLUSTER selection (1) 352s ok 42 - psql -Atl 352s ok 43 - PGCLUSTER selection (2) 352s ok 44 - psql -l 352s ok 45 - invalid PGCLUSTER value 352s ok 46 - createdb --version 352s ok 47 - PGCLUSTER network cluster selection (1) 352s ok 48 - psql -Atl 352s ok 49 - PGCLUSTER network cluster selection (2) 352s ok 50 - psql -Atl 352s ok 51 - PGCLUSTER network cluster selection (3) 352s ok 52 - LC_MESSAGES=C psql -Atl 352s ok 53 - psql --cluster 14/localhost:5435 fails due to nonexisting port 352s ok 54 - psql -Atc "show port" template1 352s ok 55 - PGPORT selection (1) 352s ok 56 - psql -Atc "show port" template1 352s ok 57 - PGPORT selection (2) 352s ok 58 - createdb --version 352s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 352s ok 60 - psql -Atc "show port" template1 352s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 352s ok 62 - psql --cluster 14/new1 -Atc 'select current_database()' 352s ok 63 - PGDATABASE environment variable works 352s ok 64 - createdb --version 352s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 352s ok 66 - createdb --cluster 14/new1 --version 352s ok 67 - pg_wrapper --cluster works with empty user_clusters 352s ok 68 - createdb --version 352s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 14 new1 *' 352s ok 70 - psql -Atc "select current_database()" 352s ok 71 - pg_wrapper selects correct database with user_clusters '* * 14 new1 test' 353s ok 72 - psql -Atc 'select current_database()' 353s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 353s ok 74 - createdb --version 353s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 353s ok 76 - createdb --version 353s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 353s ok 78 - createdb --version 353s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 353s ok 80 - createdb --version 353s ok 81 - pg_wrapper selects correct version with per-user user_clusters 353s ok 82 - createdb --version 353s ok 83 - pg_wrapper selects correct version with per-user user_clusters 353s ok 84 - createdb --version 353s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 353s ok 86 - psql -Atl 353s ok 87 - $PGHOST overrides user_clusters 353s ok 88 - psql --cluster 14/localhost:5434 -Atc 'select current_database()' test 353s ok 89 - --cluster overrides $PGHOST 353s ok 90 - createdb --version 353s ok 91 - pg_wrapper ignores invalid lines in user_clusters 353s ok 92 - psql -Atc 'select current_database()' 353s ok 93 - pg_service conf selection 1 353s ok 94 - psql -Atc 'select current_database()' 353s ok 95 - pg_service conf selection 2 353s ok 96 - psql -Atc 'select current_database()' 353s ok 97 - pg_service conf selection 3 353s ok 98 - stopping cluster 14/old 355s ok 99 - restarting cluster 14/old 355s ok 100 - pg_lsclusters -h | sort -k3 355s ok 101 - port of first cluster was successfully changed 355s ok 102 - psql -l 355s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 355s ok 104 - psql -Atl --cluster 14/new1 355s ok 105 - --cluster selects appropriate cluster 355s ok 106 - psql -Atl -p 5434 355s ok 107 - -p selects appropriate cluster 355s ok 108 - psql -Atlp 5434 355s ok 109 - -Atlp selects appropriate cluster 355s ok 110 - psql -Atl --port 5434 355s ok 111 - --port selects appropriate cluster 355s ok 112 - env PGPORT=5434 psql -Atl 355s ok 113 - $PGPORT selects appropriate cluster 355s ok 114 - Restoring original /etc/postgresql-common/user_clusters 356s ok 115 - dropping 14/new1 357s ok 116 - dropping 14/new2 358s ok 117 - dropping 14/old 358s # Cleanup 358s ok 118 - Cleanup: No clusters left behind 358s ok 119 - No postgres processes left behind 358s ok 120 - No files in /etc/postgresql left behind 358s ok 121 - No files in /var/lib/postgresql left behind 358s ok 122 - No files in /var/run/postgresql left behind 358s ok 123 - No files in /var/log/postgresql left behind 359s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 359s ok 125 - PostgreSQL TCP ports are closed 359s === Running test 100_upgrade_scripts.t ... === 359s 1..27 361s ok 1 - pg_createcluster 14 main 361s ok 2 - createdb --cluster 14/main db1 361s ok 3 - correct output of createdb --cluster 14/main db1 362s ok 4 - createdb --cluster 14/main db2 362s ok 5 - correct output of createdb --cluster 14/main db2 362s ok 6 - psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 362s ok 7 - correct output of psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 362s ok 8 - get_cluster_databases() works 362s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 363s ok 10 - run-upgrade-scripts succeeds 363s ok 11 - correct run-upgrade-script output 363s ok 12 - psql --cluster 14/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 363s ok 13 - check SQL scripts results in 14/main db1 363s ok 14 - psql --cluster 14/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 363s ok 15 - check SQL scripts results in 14/main db2 363s ok 16 - psql --cluster 14/main db1 -Atc 'select * from log order by str' 363s ok 17 - check shell scripts results in $v/main 363s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 364s ok 19 - pg_dropcluster 14 main 364s # Cleanup 364s ok 20 - Cleanup: No clusters left behind 364s ok 21 - No postgres processes left behind 364s ok 22 - No files in /etc/postgresql left behind 364s ok 23 - No files in /var/lib/postgresql left behind 364s ok 24 - No files in /var/run/postgresql left behind 364s ok 25 - No files in /var/log/postgresql left behind 364s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 364s ok 27 - PostgreSQL TCP ports are closed 364s === Running test 110_integrate_cluster.t ... === 364s 1..32 364s ok 1 - /usr/lib/postgresql/14/bin/initdb /tmp/1lRA0IQQvh/c/postgres 364s ok 2 - creating raw initdb cluster for user postgres 365s ok 3 - pg_createcluster 14 postgres -d /tmp/1lRA0IQQvh/c/postgres 365s ok 4 - integrating postgres cluster 365s ok 5 - pg_lsclusters 365s ok 6 - correct pg_lsclusters output 367s ok 7 - pg_ctlcluster 14 postgres start 367s ok 8 - starting cluster postgres 367s ok 9 - pg_lsclusters 367s ok 10 - correct pg_lsclusters output 368s ok 11 - dropping cluster postgres 368s ok 12 - No files in temporary cluster dir left behind 368s ok 13 - /usr/lib/postgresql/14/bin/initdb /tmp/1lRA0IQQvh/c/nobody 368s ok 14 - creating raw initdb cluster for user nobody 369s ok 15 - pg_createcluster 14 nobody -d /tmp/1lRA0IQQvh/c/nobody 369s ok 16 - integrating nobody cluster 369s ok 17 - pg_lsclusters 369s ok 18 - correct pg_lsclusters output 371s ok 19 - pg_ctlcluster 14 nobody start 371s ok 20 - starting cluster nobody 371s ok 21 - pg_lsclusters 371s ok 22 - correct pg_lsclusters output 372s ok 23 - dropping cluster nobody 372s ok 24 - No files in temporary cluster dir left behind 372s # Cleanup 372s ok 25 - Cleanup: No clusters left behind 372s ok 26 - No postgres processes left behind 372s ok 27 - No files in /etc/postgresql left behind 372s ok 28 - No files in /var/lib/postgresql left behind 372s ok 29 - No files in /var/run/postgresql left behind 372s ok 30 - No files in /var/log/postgresql left behind 372s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 372s ok 32 - PostgreSQL TCP ports are closed 372s === Running test 120_pg_upgradecluster_scripts.t ... === 372s 1..1 372s ok 1 - only one major version installed, skipping upgrade tests 372s === Running test 130_nonroot_admin.t ... === 372s 1..22 375s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 375s ok 2 - pg_lsclusters -h 375s ok 3 - correct output of pg_lsclusters -h 375s ok 4 - psql -Atl 375s ok 5 - correct output of psql -Atl 375s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 375s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 375s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 375s # Cleanup 375s ok 15 - Cleanup: No clusters left behind 375s ok 16 - No postgres processes left behind 375s ok 17 - No files in /etc/postgresql left behind 375s ok 18 - No files in /var/lib/postgresql left behind 375s ok 19 - No files in /var/run/postgresql left behind 375s ok 20 - No files in /var/log/postgresql left behind 375s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 375s ok 22 - PostgreSQL TCP ports are closed 375s === Running test 135_pg_virtualenv.t ... === 375s 1..20 379s ok 1 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 379s ok 2 - running pg_virtualenv as root 382s ok 3 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 382s ok 4 - running pg_virtualenv as postgres 385s ok 5 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 385s ok 6 - running pg_virtualenv as nobody 385s ok 7 # skip /usr/bin/fakeroot not available 385s ok 8 # skip /usr/bin/fakeroot not available 385s ok 9 # skip /usr/bin/fakeroot not available 385s ok 10 # skip /usr/bin/fakeroot not available 385s ok 11 # skip /usr/bin/fakeroot not available 385s ok 12 # skip /usr/bin/fakeroot not available 385s # Cleanup 385s ok 13 - Cleanup: No clusters left behind 385s ok 14 - No postgres processes left behind 385s ok 15 - No files in /etc/postgresql left behind 385s ok 16 - No files in /var/lib/postgresql left behind 385s ok 17 - No files in /var/run/postgresql left behind 385s ok 18 - No files in /var/log/postgresql left behind 385s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 385s ok 20 - PostgreSQL TCP ports are closed 385s === Running test 140_pg_config.t ... === 385s 1..38 385s # Multiarch is enabled 385s # checking version specific output for 14 385s ok 1 - /usr/lib/postgresql/14/bin/pg_config --pgxs 385s ok 2 - correct output of /usr/lib/postgresql/14/bin/pg_config --pgxs 385s ok 3 - /usr/lib/postgresql/14/bin/pg_config --libdir 385s ok 4 - correct output of /usr/lib/postgresql/14/bin/pg_config --libdir 385s ok 5 - /usr/lib/postgresql/14/bin/pg_config --pkglibdir 385s ok 6 - correct output of /usr/lib/postgresql/14/bin/pg_config --pkglibdir 385s ok 7 - /usr/lib/postgresql/14/bin/pg_config --bindir 385s ok 8 - correct output of /usr/lib/postgresql/14/bin/pg_config --bindir 385s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 385s # checking pg_config output (should behave like version 14) 385s ok 15 - pg_config 385s ok 16 - correct output of pg_config 385s ok 17 - pg_config --help 385s ok 18 - correct output of pg_config --help 385s ok 19 - pg_config --pgxs 385s ok 20 - correct output of pg_config --pgxs 385s ok 21 - pg_config --libdir 385s ok 22 - correct output of pg_config --libdir 385s ok 23 - pg_config --pkglibdir 385s ok 24 - correct output of pg_config --pkglibdir 385s ok 25 - pg_config --bindir 385s ok 26 - correct output of pg_config --bindir 385s # checking pg_config.libpq-dev output (should behave like version 14) 385s ok 27 - pg_config.libpq-dev 385s ok 28 - correct output of pg_config.libpq-dev 385s ok 29 - pg_config.libpq-dev --help 385s ok 30 - correct output of pg_config.libpq-dev --help 385s ok 31 - pg_config.libpq-dev --pgxs 385s ok 32 - correct output of pg_config.libpq-dev --pgxs 385s ok 33 - pg_config.libpq-dev --libdir 385s ok 34 - correct output of pg_config.libpq-dev --libdir 385s ok 35 - pg_config.libpq-dev --pkglibdir 385s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 385s ok 37 - pg_config.libpq-dev --bindir 385s ok 38 - correct output of pg_config.libpq-dev --bindir 385s === Running test 150_tsearch_stemming.t ... === 385s 1..37 385s ok 1 - pg_updatedicts succeeded 385s ok 2 - pg_updatedicts created en_us.affix 385s ok 3 - pg_updatedicts created en_us.dict 385s ok 4 - pg_updatedicts created 14 en_us.affix symlink 385s ok 5 - pg_updatedicts created 14 en_us.dict symlink 388s ok 6 - pg_createcluster 14 main 388s ok 7 - createdb fts 388s ok 8 - correct output of createdb fts 388s ok 9 - creating en_US full text search configuration 388s ok 10 - creating data table and search index 388s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 388s ok 12 - stem search of correct word 388s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 388s ok 14 - stem search of correct word 388s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 388s ok 16 - stem search of unknown word 388s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 388s ok 18 - full text search, exact word 388s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 388s ok 20 - full text search for word stem 388s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 388s ok 22 - full text search for word substring fails 389s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 389s ok 24 - full text search, exact unicode word 389s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 389s ok 26 - full text search for unicode word stem 389s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 389s ok 28 - full text search for unicode word substring fails 390s ok 29 390s # Cleanup 390s ok 30 - Cleanup: No clusters left behind 390s ok 31 - No postgres processes left behind 390s ok 32 - No files in /etc/postgresql left behind 390s ok 33 - No files in /var/lib/postgresql left behind 390s ok 34 - No files in /var/run/postgresql left behind 390s ok 35 - No files in /var/log/postgresql left behind 390s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 390s ok 37 - PostgreSQL TCP ports are closed 390s === Running test 160_alternate_confroot.t ... === 390s 1..28 392s ok 1 392s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 392s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 392s ok 4 - pg_lsclusters -h 392s ok 5 - correct output of pg_lsclusters -h 392s ok 6 - psql -Atl 392s ok 7 - correct output of psql -Atl 392s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 392s ok 9 - ... 392s ok 10 - ... 392s ok 11 - ... 392s ok 12 - ... 392s ok 13 - ... 392s ok 14 - ... 393s ok 15 - pg_dropcluster 14 test --stop 393s ok 16 - correct output of pg_dropcluster 14 test --stop 393s ok 17 - pg_lsclusters -h 393s ok 18 - correct output of pg_lsclusters -h 393s ok 19 - No files in root/data left behind 393s ok 20 - No cruft in root dir left behind 393s # Cleanup 393s ok 21 - Cleanup: No clusters left behind 393s ok 22 - No postgres processes left behind 393s ok 23 - No files in /etc/postgresql left behind 393s ok 24 - No files in /var/lib/postgresql left behind 393s ok 25 - No files in /var/run/postgresql left behind 393s ok 26 - No files in /var/log/postgresql left behind 393s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 393s ok 28 - PostgreSQL TCP ports are closed 393s === Running test 170_extensions.t ... === 393s # Running tests for 14 396s ok 1 - pg_createcluster 14 main 396s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 396s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 396s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 396s ok 5 - extension adminpack installs without error 396s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 396s ok 7 - extension adminpack removes without error 396s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 396s ok 9 - extension amcheck installs without error 396s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 396s ok 11 - extension amcheck removes without error 396s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 396s ok 13 - extension autoinc installs without error 396s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 396s ok 15 - extension autoinc removes without error 396s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 396s ok 17 - extension bloom installs without error 396s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 396s ok 19 - extension bloom removes without error 396s ok 20 - psql -qc 'CREATE EXTENSION plperl' 396s ok 21 - bool_plperl dependency plperl installs without error 396s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 396s ok 23 - extension bool_plperl installs without error 396s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 396s ok 25 - extension bool_plperl removes without error 396s ok 26 - psql -qc 'DROP EXTENSION plperl' 396s ok 27 - bool_plperl dependency extension plperl removes without error 396s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 396s ok 29 - bool_plperlu dependency plperlu installs without error 396s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 396s ok 31 - extension bool_plperlu installs without error 396s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 396s ok 33 - extension bool_plperlu removes without error 396s ok 34 - psql -qc 'DROP EXTENSION plperlu' 396s ok 35 - bool_plperlu dependency extension plperlu removes without error 396s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 396s ok 37 - extension btree_gin installs without error 396s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 396s ok 39 - extension btree_gin removes without error 396s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 396s ok 41 - extension btree_gist installs without error 396s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 396s ok 43 - extension btree_gist removes without error 396s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 396s ok 45 - extension citext installs without error 396s ok 46 - psql -qc 'DROP EXTENSION "citext"' 396s ok 47 - extension citext removes without error 396s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 396s ok 49 - extension cube installs without error 396s ok 50 - psql -qc 'DROP EXTENSION "cube"' 396s ok 51 - extension cube removes without error 396s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 396s ok 53 - extension dblink installs without error 396s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 396s ok 55 - extension dblink removes without error 396s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 396s ok 57 - extension dict_int installs without error 397s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 397s ok 59 - extension dict_int removes without error 397s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 397s ok 61 - extension dict_xsyn installs without error 397s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 397s ok 63 - extension dict_xsyn removes without error 397s ok 64 - psql -qc 'CREATE EXTENSION cube' 397s ok 65 - earthdistance dependency cube installs without error 397s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 397s ok 67 - extension earthdistance installs without error 397s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 397s ok 69 - extension earthdistance removes without error 397s ok 70 - psql -qc 'DROP EXTENSION cube' 397s ok 71 - earthdistance dependency extension cube removes without error 397s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 397s ok 73 - extension file_fdw installs without error 397s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 397s ok 75 - extension file_fdw removes without error 397s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 397s ok 77 - extension fuzzystrmatch installs without error 397s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 397s ok 79 - extension fuzzystrmatch removes without error 397s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 397s ok 81 - extension hstore installs without error 397s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 397s ok 83 - extension hstore removes without error 397s ok 84 - psql -qc 'CREATE EXTENSION hstore' 397s ok 85 - hstore_plperl dependency hstore installs without error 397s ok 86 - psql -qc 'CREATE EXTENSION plperl' 397s ok 87 - hstore_plperl dependency plperl installs without error 397s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 397s ok 89 - extension hstore_plperl installs without error 397s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 397s ok 91 - extension hstore_plperl removes without error 397s ok 92 - psql -qc 'DROP EXTENSION hstore' 397s ok 93 - hstore_plperl dependency extension hstore removes without error 397s ok 94 - psql -qc 'DROP EXTENSION plperl' 397s ok 95 - hstore_plperl dependency extension plperl removes without error 397s ok 96 - psql -qc 'CREATE EXTENSION hstore' 397s ok 97 - hstore_plperlu dependency hstore installs without error 397s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 397s ok 99 - hstore_plperlu dependency plperlu installs without error 397s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 397s ok 101 - extension hstore_plperlu installs without error 397s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 397s ok 103 - extension hstore_plperlu removes without error 397s ok 104 - psql -qc 'DROP EXTENSION hstore' 397s ok 105 - hstore_plperlu dependency extension hstore removes without error 397s ok 106 - psql -qc 'DROP EXTENSION plperlu' 397s ok 107 - hstore_plperlu dependency extension plperlu removes without error 397s ok 108 - psql -qc 'CREATE EXTENSION hstore' 397s ok 109 - hstore_plpython3u dependency hstore installs without error 397s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 397s ok 111 - hstore_plpython3u dependency plpython3u installs without error 397s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 397s ok 113 - extension hstore_plpython3u installs without error 397s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 397s ok 115 - extension hstore_plpython3u removes without error 397s ok 116 - psql -qc 'DROP EXTENSION hstore' 397s ok 117 - hstore_plpython3u dependency extension hstore removes without error 397s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 397s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 397s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 397s ok 121 - extension insert_username installs without error 397s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 397s ok 123 - extension insert_username removes without error 397s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 397s ok 125 - extension intagg installs without error 398s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 398s ok 127 - extension intagg removes without error 398s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 398s ok 129 - extension intarray installs without error 398s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 398s ok 131 - extension intarray removes without error 398s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 398s ok 133 - extension isn installs without error 398s ok 134 - psql -qc 'DROP EXTENSION "isn"' 398s ok 135 - extension isn removes without error 398s ok 136 - psql -qc 'CREATE EXTENSION plperl' 398s ok 137 - jsonb_plperl dependency plperl installs without error 398s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 398s ok 139 - extension jsonb_plperl installs without error 398s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 398s ok 141 - extension jsonb_plperl removes without error 398s ok 142 - psql -qc 'DROP EXTENSION plperl' 398s ok 143 - jsonb_plperl dependency extension plperl removes without error 398s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 398s ok 145 - jsonb_plperlu dependency plperlu installs without error 398s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 398s ok 147 - extension jsonb_plperlu installs without error 398s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 398s ok 149 - extension jsonb_plperlu removes without error 398s ok 150 - psql -qc 'DROP EXTENSION plperlu' 398s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 398s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 398s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 398s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 398s ok 155 - extension jsonb_plpython3u installs without error 398s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 398s ok 157 - extension jsonb_plpython3u removes without error 398s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 398s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 398s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 398s ok 161 - extension lo installs without error 398s ok 162 - psql -qc 'DROP EXTENSION "lo"' 398s ok 163 - extension lo removes without error 398s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 398s ok 165 - extension ltree installs without error 398s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 398s ok 167 - extension ltree removes without error 398s ok 168 - psql -qc 'CREATE EXTENSION ltree' 398s ok 169 - ltree_plpython3u dependency ltree installs without error 398s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 398s ok 171 - ltree_plpython3u dependency plpython3u installs without error 398s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 398s ok 173 - extension ltree_plpython3u installs without error 398s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 398s ok 175 - extension ltree_plpython3u removes without error 398s ok 176 - psql -qc 'DROP EXTENSION ltree' 398s ok 177 - ltree_plpython3u dependency extension ltree removes without error 398s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 398s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 398s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 398s ok 181 - extension moddatetime installs without error 398s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 398s ok 183 - extension moddatetime removes without error 398s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 398s ok 185 - extension old_snapshot installs without error 398s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 398s ok 187 - extension old_snapshot removes without error 398s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 398s ok 189 - extension pageinspect installs without error 398s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 398s ok 191 - extension pageinspect removes without error 399s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 399s ok 193 - extension pg_buffercache installs without error 399s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 399s ok 195 - extension pg_buffercache removes without error 399s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 399s ok 197 - extension pg_freespacemap installs without error 399s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 399s ok 199 - extension pg_freespacemap removes without error 399s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 399s ok 201 - extension pg_prewarm installs without error 399s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 399s ok 203 - extension pg_prewarm removes without error 399s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 399s ok 205 - extension pg_stat_statements installs without error 399s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 399s ok 207 - extension pg_stat_statements removes without error 399s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 399s ok 209 - extension pg_surgery installs without error 399s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 399s ok 211 - extension pg_surgery removes without error 399s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 399s ok 213 - extension pg_trgm installs without error 399s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 399s ok 215 - extension pg_trgm removes without error 399s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 399s ok 217 - extension pg_visibility installs without error 399s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 399s ok 219 - extension pg_visibility removes without error 399s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 399s ok 221 - extension pgcrypto installs without error 399s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 399s ok 223 - extension pgcrypto removes without error 399s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 399s ok 225 - extension pgrowlocks installs without error 399s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 399s ok 227 - extension pgrowlocks removes without error 399s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 399s ok 229 - extension pgstattuple installs without error 399s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 399s ok 231 - extension pgstattuple removes without error 399s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 399s ok 233 - extension plperl installs without error 399s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 399s ok 235 - extension plperl removes without error 399s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 399s ok 237 - extension plperlu installs without error 399s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 399s ok 239 - extension plperlu removes without error 399s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 399s ok 241 - extension plpython3u installs without error 399s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 399s ok 243 - extension plpython3u removes without error 399s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 399s ok 245 - extension pltcl installs without error 399s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 399s ok 247 - extension pltcl removes without error 399s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 399s ok 249 - extension pltclu installs without error 399s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 399s ok 251 - extension pltclu removes without error 399s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 399s ok 253 - extension postgres_fdw installs without error 399s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 399s ok 255 - extension postgres_fdw removes without error 399s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 399s ok 257 - extension refint installs without error 399s ok 258 - psql -qc 'DROP EXTENSION "refint"' 399s ok 259 - extension refint removes without error 399s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 399s ok 261 - extension seg installs without error 400s ok 262 - psql -qc 'DROP EXTENSION "seg"' 400s ok 263 - extension seg removes without error 400s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 400s ok 265 - extension sslinfo installs without error 400s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 400s ok 267 - extension sslinfo removes without error 400s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 400s ok 269 - extension tablefunc installs without error 400s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 400s ok 271 - extension tablefunc removes without error 400s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 400s ok 273 - extension tcn installs without error 400s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 400s ok 275 - extension tcn removes without error 400s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 400s ok 277 - extension tsm_system_rows installs without error 400s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 400s ok 279 - extension tsm_system_rows removes without error 400s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 400s ok 281 - extension tsm_system_time installs without error 400s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 400s ok 283 - extension tsm_system_time removes without error 400s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 400s ok 285 - extension unaccent installs without error 400s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 400s ok 287 - extension unaccent removes without error 400s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 400s ok 289 - extension uuid-ossp installs without error 400s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 400s ok 291 - extension uuid-ossp removes without error 400s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 400s ok 293 - extension xml2 installs without error 400s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 400s ok 295 - extension xml2 removes without error 401s ok 296 - pg_dropcluster 14 main 401s # Cleanup 401s ok 297 - Cleanup: No clusters left behind 401s ok 298 - No postgres processes left behind 401s ok 299 - No files in /etc/postgresql left behind 401s ok 300 - No files in /var/lib/postgresql left behind 401s ok 301 - No files in /var/run/postgresql left behind 401s ok 302 - No files in /var/log/postgresql left behind 401s ok 303 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 401s ok 304 - PostgreSQL TCP ports are closed 401s 1..304 401s === Running test 180_ecpg.t ... === 401s 1..14 401s ok 1 - ecpg test.pgc 401s ok 2 - ecpg processing 401s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 401s ok 4 - compiling ecpg output 408s ok 5 - pg_virtualenv /tmp/tmp.ysKsF0n4d4/test 408s ok 6 - test program runs and gives correct output 408s # Cleanup 408s ok 7 - Cleanup: No clusters left behind 408s ok 8 - No postgres processes left behind 408s ok 9 - No files in /etc/postgresql left behind 408s ok 10 - No files in /var/lib/postgresql left behind 408s ok 11 - No files in /var/run/postgresql left behind 408s ok 12 - No files in /var/log/postgresql left behind 408s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 408s ok 14 - PostgreSQL TCP ports are closed 408s === Running test 190_pg_buildext.t ... === 408s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 408s 1..1 409s autopkgtest [13:22:43]: test run-testsuite: -----------------------] 409s autopkgtest [13:22:43]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 409s run-testsuite PASS 410s autopkgtest [13:22:44]: test installcheck: preparing testbed 527s autopkgtest [13:24:41]: testbed dpkg architecture: s390x 527s autopkgtest [13:24:41]: testbed apt version: 2.4.13 527s autopkgtest [13:24:41]: @@@@@@@@@@@@@@@@@@@@ test bed setup 527s autopkgtest [13:24:41]: testbed release detected to be: jammy 528s autopkgtest [13:24:42]: updating testbed package index (apt update) 528s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 528s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 529s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 529s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 529s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 529s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 529s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 529s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 529s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x Packages [146 kB] 529s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x c-n-f Metadata [1724 B] 529s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x Packages [2048 B] 529s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x c-n-f Metadata [116 B] 529s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x Packages [45.5 kB] 529s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x c-n-f Metadata [1312 B] 529s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse s390x Packages [740 B] 529s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse s390x c-n-f Metadata [116 B] 530s Fetched 633 kB in 1s (698 kB/s) 531s Reading package lists... 531s + lsb_release --codename --short 531s + RELEASE=jammy 531s + cat 531s + [ jammy != trusty ] 531s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 532s Reading package lists... 532s Building dependency tree... 532s Reading state information... 532s Calculating upgrade... 532s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 532s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 532s + /usr/lib/apt/apt-helper analyze-pattern ?true 532s + uname -r+ sed s/\./\\./g 532s 532s + running_kernel_pattern=^linux-.*5\.15\.0-133-generic.* 532s + apt list ?obsolete 532s + cut -d/ -f1 532s + grep -v ^linux-.*5\.15\.0-133-generic.* 532s + tail -n+2 532s + true 532s + obsolete_pkgs= 532s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 532s Reading package lists... 532s Building dependency tree... 532s Reading state information... 532s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 532s + grep -q trusty /etc/lsb-release 532s + [ ! -d /usr/share/doc/unattended-upgrades ] 532s + [ ! -d /usr/share/doc/lxd ] 532s + [ ! -d /usr/share/doc/lxd-client ] 532s + [ ! -d /usr/share/doc/snapd ] 532s + type iptables 532s + cat 532s + chmod 755 /etc/rc.local 532s + . /etc/rc.local 532s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 532s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 532s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 532s + uname -m 532s + [ s390x = ppc64le ] 532s + [ -d /run/systemd/system ] 532s + systemd-detect-virt --quiet --vm 532s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 532s + cat 532s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 532s + echo COMPRESS=lz4 532s autopkgtest [13:24:46]: upgrading testbed (apt dist-upgrade and autopurge) 533s Reading package lists... 533s Building dependency tree... 533s Reading state information... 533s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 533s Starting 2 pkgProblemResolver with broken count: 0 533s Done 533s Entering ResolveByKeep 533s 533s The following packages will be upgraded: 533s tzdata 533s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 533s Need to get 347 kB of archives. 533s After this operation, 4096 B of additional disk space will be used. 533s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x tzdata all 2025a-0ubuntu0.22.04 [347 kB] 534s Preconfiguring packages ... 534s Fetched 347 kB in 0s (848 kB/s) 534s (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 ... 50346 files and directories currently installed.) 534s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 534s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 534s Setting up tzdata (2025a-0ubuntu0.22.04) ... 534s 534s Current default time zone: 'Etc/UTC' 534s Local time is now: Wed Feb 26 13:26:14 UTC 2025. 534s Universal Time is now: Wed Feb 26 13:26:14 UTC 2025. 534s Run 'dpkg-reconfigure tzdata' if you wish to change it. 534s 535s Reading package lists... 535s Building dependency tree... 535s Reading state information... 535s Starting pkgProblemResolver with broken count: 0 535s Starting 2 pkgProblemResolver with broken count: 0 535s Done 535s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 537s Reading package lists... 537s Building dependency tree... 537s Reading state information... 538s Starting pkgProblemResolver with broken count: 0 538s Starting 2 pkgProblemResolver with broken count: 0 538s Done 538s The following NEW packages will be installed: 538s build-essential cpp cpp-11 g++ g++-11 gcc gcc-11 gcc-11-base libasan6 538s libatomic1 libc-dev-bin libc6-dev libcc1-0 libcrypt-dev libecpg-compat3 538s libecpg-dev libecpg6 libgcc-11-dev libgomp1 libisl23 libitm1 libjson-perl 538s libmpc3 libnsl-dev libpgtypes3 libpq-dev libpq5 libpython3.10 libssl-dev 538s libstdc++-11-dev libtirpc-dev libubsan1 libxslt1.1 linux-libc-dev 538s postgresql-14 postgresql-client-14 postgresql-client-common 538s postgresql-common postgresql-doc-14 postgresql-plperl-14 538s postgresql-plpython3-14 postgresql-pltcl-14 postgresql-server-dev-14 538s rpcsvc-proto ssl-cert 538s 0 upgraded, 45 newly installed, 0 to remove and 0 not upgraded. 538s Need to get 58.0 MB of archives. 538s After this operation, 213 MB of additional disk space will be used. 538s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libc-dev-bin s390x 2.35-0ubuntu3.9 [20.0 kB] 538s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main s390x linux-libc-dev s390x 5.15.0-133.144 [1295 kB] 538s Get:3 http://ftpmaster.internal/ubuntu jammy/main s390x libcrypt-dev s390x 1:4.4.27-1 [114 kB] 538s Get:4 http://ftpmaster.internal/ubuntu jammy/main s390x rpcsvc-proto s390x 1.4.2-0ubuntu6 [64.7 kB] 538s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libtirpc-dev s390x 1.3.2-2ubuntu0.1 [189 kB] 538s Get:6 http://ftpmaster.internal/ubuntu jammy/main s390x libnsl-dev s390x 1.3.0-2build2 [70.9 kB] 538s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libc6-dev s390x 2.35-0ubuntu3.9 [1502 kB] 538s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main s390x gcc-11-base s390x 11.4.0-1ubuntu1~22.04 [20.3 kB] 538s Get:9 http://ftpmaster.internal/ubuntu jammy/main s390x libisl23 s390x 0.24-2build1 [701 kB] 538s Get:10 http://ftpmaster.internal/ubuntu jammy/main s390x libmpc3 s390x 1.2.1-2build1 [47.7 kB] 538s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main s390x cpp-11 s390x 11.4.0-1ubuntu1~22.04 [7871 kB] 539s Get:12 http://ftpmaster.internal/ubuntu jammy/main s390x cpp s390x 4:11.2.0-1ubuntu1 [27.7 kB] 539s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libcc1-0 s390x 12.3.0-1ubuntu1~22.04 [46.2 kB] 539s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libgomp1 s390x 12.3.0-1ubuntu1~22.04 [123 kB] 539s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libitm1 s390x 12.3.0-1ubuntu1~22.04 [29.9 kB] 539s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libatomic1 s390x 12.3.0-1ubuntu1~22.04 [9076 B] 539s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libasan6 s390x 11.4.0-1ubuntu1~22.04 [2247 kB] 539s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libubsan1 s390x 12.3.0-1ubuntu1~22.04 [968 kB] 539s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libgcc-11-dev s390x 11.4.0-1ubuntu1~22.04 [829 kB] 539s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main s390x gcc-11 s390x 11.4.0-1ubuntu1~22.04 [15.8 MB] 539s Get:21 http://ftpmaster.internal/ubuntu jammy/main s390x gcc s390x 4:11.2.0-1ubuntu1 [5118 B] 539s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libstdc++-11-dev s390x 11.4.0-1ubuntu1~22.04 [2103 kB] 539s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main s390x g++-11 s390x 11.4.0-1ubuntu1~22.04 [9204 kB] 540s Get:24 http://ftpmaster.internal/ubuntu jammy/main s390x g++ s390x 4:11.2.0-1ubuntu1 [1408 B] 540s Get:25 http://ftpmaster.internal/ubuntu jammy/main s390x build-essential s390x 12.9ubuntu3 [4748 B] 540s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpgtypes3 s390x 14.15-0ubuntu0.22.04.1 [48.4 kB] 540s Get:27 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq5 s390x 14.15-0ubuntu0.22.04.1 [144 kB] 540s Get:28 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg6 s390x 14.15-0ubuntu0.22.04.1 [43.8 kB] 540s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg-compat3 s390x 14.15-0ubuntu0.22.04.1 [13.3 kB] 540s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libssl-dev s390x 3.0.2-0ubuntu1.19 [2029 kB] 540s Get:31 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq-dev s390x 14.15-0ubuntu0.22.04.1 [146 kB] 540s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libecpg-dev s390x 14.15-0ubuntu0.22.04.1 [264 kB] 540s Get:33 http://ftpmaster.internal/ubuntu jammy/main s390x libjson-perl all 4.04000-1 [81.8 kB] 540s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpython3.10 s390x 3.10.12-1~22.04.9 [1900 kB] 540s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.22.04.1 [157 kB] 540s Get:36 http://ftpmaster.internal/ubuntu jammy/main s390x postgresql-client-common all 238 [29.6 kB] 540s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-client-14 s390x 14.15-0ubuntu0.22.04.1 [1205 kB] 540s Get:38 http://ftpmaster.internal/ubuntu jammy/main s390x ssl-cert all 1.1.2 [17.4 kB] 540s Get:39 http://ftpmaster.internal/ubuntu jammy/main s390x postgresql-common all 238 [169 kB] 540s Get:40 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-14 s390x 14.15-0ubuntu0.22.04.1 [5094 kB] 540s Get:41 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 541s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-plperl-14 s390x 14.15-0ubuntu0.22.04.1 [52.8 kB] 541s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-plpython3-14 s390x 14.15-0ubuntu0.22.04.1 [62.2 kB] 541s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-pltcl-14 s390x 14.15-0ubuntu0.22.04.1 [35.3 kB] 541s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/universe s390x postgresql-server-dev-14 s390x 14.15-0ubuntu0.22.04.1 [1176 kB] 541s Preconfiguring packages ... 541s Fetched 58.0 MB in 3s (20.1 MB/s) 541s Selecting previously unselected package libc-dev-bin. 541s (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 ... 50347 files and directories currently installed.) 541s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_s390x.deb ... 541s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 541s Selecting previously unselected package linux-libc-dev:s390x. 541s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_s390x.deb ... 541s Unpacking linux-libc-dev:s390x (5.15.0-133.144) ... 541s Selecting previously unselected package libcrypt-dev:s390x. 541s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_s390x.deb ... 541s Unpacking libcrypt-dev:s390x (1:4.4.27-1) ... 541s Selecting previously unselected package rpcsvc-proto. 541s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_s390x.deb ... 541s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 541s Selecting previously unselected package libtirpc-dev:s390x. 541s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_s390x.deb ... 541s Unpacking libtirpc-dev:s390x (1.3.2-2ubuntu0.1) ... 541s Selecting previously unselected package libnsl-dev:s390x. 541s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_s390x.deb ... 541s Unpacking libnsl-dev:s390x (1.3.0-2build2) ... 541s Selecting previously unselected package libc6-dev:s390x. 541s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_s390x.deb ... 541s Unpacking libc6-dev:s390x (2.35-0ubuntu3.9) ... 541s Selecting previously unselected package gcc-11-base:s390x. 541s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking gcc-11-base:s390x (11.4.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libisl23:s390x. 541s Preparing to unpack .../08-libisl23_0.24-2build1_s390x.deb ... 541s Unpacking libisl23:s390x (0.24-2build1) ... 541s Selecting previously unselected package libmpc3:s390x. 541s Preparing to unpack .../09-libmpc3_1.2.1-2build1_s390x.deb ... 541s Unpacking libmpc3:s390x (1.2.1-2build1) ... 541s Selecting previously unselected package cpp-11. 541s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package cpp. 541s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_s390x.deb ... 541s Unpacking cpp (4:11.2.0-1ubuntu1) ... 541s Selecting previously unselected package libcc1-0:s390x. 541s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libcc1-0:s390x (12.3.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libgomp1:s390x. 541s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libgomp1:s390x (12.3.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libitm1:s390x. 541s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libitm1:s390x (12.3.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libatomic1:s390x. 541s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libatomic1:s390x (12.3.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libasan6:s390x. 541s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libasan6:s390x (11.4.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libubsan1:s390x. 541s Preparing to unpack .../17-libubsan1_12.3.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libubsan1:s390x (12.3.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package libgcc-11-dev:s390x. 541s Preparing to unpack .../18-libgcc-11-dev_11.4.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking libgcc-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 541s Selecting previously unselected package gcc-11. 541s Preparing to unpack .../19-gcc-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 541s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 542s Selecting previously unselected package gcc. 542s Preparing to unpack .../20-gcc_4%3a11.2.0-1ubuntu1_s390x.deb ... 542s Unpacking gcc (4:11.2.0-1ubuntu1) ... 542s Selecting previously unselected package libstdc++-11-dev:s390x. 542s Preparing to unpack .../21-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_s390x.deb ... 542s Unpacking libstdc++-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 542s Selecting previously unselected package g++-11. 542s Preparing to unpack .../22-g++-11_11.4.0-1ubuntu1~22.04_s390x.deb ... 542s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 542s Selecting previously unselected package g++. 542s Preparing to unpack .../23-g++_4%3a11.2.0-1ubuntu1_s390x.deb ... 542s Unpacking g++ (4:11.2.0-1ubuntu1) ... 542s Selecting previously unselected package build-essential. 542s Preparing to unpack .../24-build-essential_12.9ubuntu3_s390x.deb ... 542s Unpacking build-essential (12.9ubuntu3) ... 542s Selecting previously unselected package libpgtypes3:s390x. 542s Preparing to unpack .../25-libpgtypes3_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libpgtypes3:s390x (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libpq5:s390x. 542s Preparing to unpack .../26-libpq5_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libpq5:s390x (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libecpg6:s390x. 542s Preparing to unpack .../27-libecpg6_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libecpg6:s390x (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libecpg-compat3:s390x. 542s Preparing to unpack .../28-libecpg-compat3_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libecpg-compat3:s390x (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libssl-dev:s390x. 542s Preparing to unpack .../29-libssl-dev_3.0.2-0ubuntu1.19_s390x.deb ... 542s Unpacking libssl-dev:s390x (3.0.2-0ubuntu1.19) ... 542s Selecting previously unselected package libpq-dev. 542s Preparing to unpack .../30-libpq-dev_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libecpg-dev. 542s Preparing to unpack .../31-libecpg-dev_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package libjson-perl. 542s Preparing to unpack .../32-libjson-perl_4.04000-1_all.deb ... 542s Unpacking libjson-perl (4.04000-1) ... 542s Selecting previously unselected package libpython3.10:s390x. 542s Preparing to unpack .../33-libpython3.10_3.10.12-1~22.04.9_s390x.deb ... 542s Unpacking libpython3.10:s390x (3.10.12-1~22.04.9) ... 542s Selecting previously unselected package libxslt1.1:s390x. 542s Preparing to unpack .../34-libxslt1.1_1.1.34-4ubuntu0.22.04.1_s390x.deb ... 542s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-client-common. 542s Preparing to unpack .../35-postgresql-client-common_238_all.deb ... 542s Unpacking postgresql-client-common (238) ... 542s Selecting previously unselected package postgresql-client-14. 542s Preparing to unpack .../36-postgresql-client-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package ssl-cert. 542s Preparing to unpack .../37-ssl-cert_1.1.2_all.deb ... 542s Unpacking ssl-cert (1.1.2) ... 542s Selecting previously unselected package postgresql-common. 542s Preparing to unpack .../38-postgresql-common_238_all.deb ... 542s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 542s Unpacking postgresql-common (238) ... 542s Selecting previously unselected package postgresql-14. 542s Preparing to unpack .../39-postgresql-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-doc-14. 542s Preparing to unpack .../40-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 542s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-plperl-14. 542s Preparing to unpack .../41-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-plpython3-14. 542s Preparing to unpack .../42-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-pltcl-14. 542s Preparing to unpack .../43-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 542s Selecting previously unselected package postgresql-server-dev-14. 542s Preparing to unpack .../44-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_s390x.deb ... 542s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 542s Setting up postgresql-client-common (238) ... 542s Setting up libpgtypes3:s390x (14.15-0ubuntu0.22.04.1) ... 542s Setting up gcc-11-base:s390x (11.4.0-1ubuntu1~22.04) ... 542s Setting up libpython3.10:s390x (3.10.12-1~22.04.9) ... 542s Setting up libpq5:s390x (14.15-0ubuntu0.22.04.1) ... 542s Setting up linux-libc-dev:s390x (5.15.0-133.144) ... 542s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 543s 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 543s Setting up libgomp1:s390x (12.3.0-1ubuntu1~22.04) ... 543s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 543s 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 543s Setting up libasan6:s390x (11.4.0-1ubuntu1~22.04) ... 543s Setting up libtirpc-dev:s390x (1.3.2-2ubuntu0.1) ... 543s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 543s Setting up ssl-cert (1.1.2) ... 544s Setting up libssl-dev:s390x (3.0.2-0ubuntu1.19) ... 544s Setting up libmpc3:s390x (1.2.1-2build1) ... 544s Setting up libatomic1:s390x (12.3.0-1ubuntu1~22.04) ... 544s Setting up libubsan1:s390x (12.3.0-1ubuntu1~22.04) ... 544s Setting up libnsl-dev:s390x (1.3.0-2build2) ... 544s Setting up libcrypt-dev:s390x (1:4.4.27-1) ... 544s Setting up libjson-perl (4.04000-1) ... 544s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... 544s Setting up libecpg6:s390x (14.15-0ubuntu0.22.04.1) ... 544s Setting up libisl23:s390x (0.24-2build1) ... 544s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 544s Setting up libcc1-0:s390x (12.3.0-1ubuntu1~22.04) ... 544s Setting up libitm1:s390x (12.3.0-1ubuntu1~22.04) ... 544s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 544s Setting up libecpg-compat3:s390x (14.15-0ubuntu0.22.04.1) ... 544s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 544s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 544s Setting up postgresql-common (238) ... 544s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 544s Adding user postgres to group ssl-cert 544s 544s Creating config file /etc/postgresql-common/createcluster.conf with new version 544s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 544s Removing obsolete dictionary files: 545s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 545s Setting up libgcc-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 545s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 545s Setting up cpp (4:11.2.0-1ubuntu1) ... 545s Setting up libc6-dev:s390x (2.35-0ubuntu3.9) ... 545s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 545s Creating new PostgreSQL cluster 14/main ... 545s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 545s The files belonging to this database system will be owned by user "postgres". 545s This user must also own the server process. 545s 545s The database cluster will be initialized with locale "C.UTF-8". 545s The default database encoding has accordingly been set to "UTF8". 545s The default text search configuration will be set to "english". 545s 545s Data page checksums are disabled. 545s 545s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 545s creating subdirectories ... ok 545s selecting dynamic shared memory implementation ... posix 545s selecting default max_connections ... 100 545s selecting default shared_buffers ... 128MB 545s selecting default time zone ... Etc/UTC 545s creating configuration files ... ok 545s running bootstrap script ... ok 545s performing post-bootstrap initialization ... ok 545s syncing data to disk ... ok 546s 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 548s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 548s Setting up gcc (4:11.2.0-1ubuntu1) ... 548s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 548s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 548s Setting up libstdc++-11-dev:s390x (11.4.0-1ubuntu1~22.04) ... 548s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 548s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 548s Setting up g++ (4:11.2.0-1ubuntu1) ... 548s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 548s Setting up build-essential (12.9ubuntu3) ... 548s Processing triggers for man-db (2.10.2-1) ... 548s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 574s autopkgtest [13:25:28]: test installcheck: [----------------------- 574s + dpkg-parsechangelog -SSource 574s + SOURCE=postgresql-14 574s + MAJOR=14 574s + top_srcdir=/tmp/autopkgtest.G5tJZd/build.jYZ/src 574s + cd src/test/regress 574s + make -f /tmp/autopkgtest.G5tJZd/build.jYZ/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/14/bin/pg_config with_llvm=no 574s 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 -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fPIC -I. -I/tmp/autopkgtest.G5tJZd/build.jYZ/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 574s 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 -O2 -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/s390x-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now -Wl,--as-needed 575s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.G5tJZd/build.jYZ/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 575s + id -u 575s + [ 1000 = 0 ] 575s + SU=sh 575s + sh 575s + mktemp -d /tmp/regress.XXXXXX 575s + OUTPUT=/tmp/regress.cWiogR 575s + trap rm -rf /tmp/regress.cWiogR EXIT 575s + pg_virtualenv -v 14 /usr/lib/postgresql/14/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --make-testtablespace-dir --outputdir=/tmp/regress.cWiogR --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 575s Creating new PostgreSQL cluster 14/regress ... 577s (using postmaster on localhost, port 5433) 577s ============== dropping database "regression" ============== 577s NOTICE: database "regression" does not exist, skipping 577s DROP DATABASE 577s ============== creating database "regression" ============== 577s CREATE DATABASE 577s ALTER DATABASE 577s ============== running regression test queries ============== 578s test tablespace ... ok 132 ms 578s parallel group (20 tests): char text pg_lsn uuid regproc float8 varchar money txid name float4 bit enum oid int2 boolean int4 int8 numeric rangetypes 578s boolean ... ok 216 ms 578s char ... ok 91 ms 578s name ... ok 169 ms 578s varchar ... ok 137 ms 578s text ... ok 100 ms 578s int2 ... ok 212 ms 578s int4 ... ok 217 ms 578s int8 ... ok 221 ms 578s oid ... ok 208 ms 578s float4 ... ok 190 ms 578s float8 ... ok 124 ms 578s bit ... ok 192 ms 578s numeric ... ok 300 ms 578s txid ... ok 164 ms 578s uuid ... ok 104 ms 578s enum ... ok 204 ms 578s money ... ok 140 ms 578s rangetypes ... ok 330 ms 578s pg_lsn ... ok 103 ms 578s regproc ... ok 106 ms 578s parallel group (20 tests): path strings numerology point timetz macaddr8 inet interval lseg line time create_function_0 circle macaddr date polygon box multirangetypes timestamp timestamptz 578s strings ... ok 66 ms 578s numerology ... ok 96 ms 578s point ... ok 99 ms 578s lseg ... ok 177 ms 578s line ... ok 222 ms 578s box ... ok 305 ms 578s path ... ok 47 ms 578s polygon ... ok 304 ms 578s circle ... ok 229 ms 578s date ... ok 245 ms 578s time ... ok 224 ms 578s timetz ... ok 143 ms 578s timestamp ... ok 540 ms 578s timestamptz ... FAILED 550 ms 578s interval ... ok 172 ms 578s inet ... ok 166 ms 578s macaddr ... ok 231 ms 578s macaddr8 ... ok 143 ms 578s multirangetypes ... ok 339 ms 578s create_function_0 ... ok 226 ms 579s parallel group (13 tests): misc_sanity xid unicode comments mvcc expressions geometry type_sanity tstypes database horology opr_sanity regex 579s geometry ... ok 230 ms 579s horology ... ok 269 ms 579s tstypes ... ok 261 ms 579s regex ... ok 471 ms 579s type_sanity ... ok 231 ms 579s opr_sanity ... ok 302 ms 579s misc_sanity ... ok 110 ms 579s comments ... ok 168 ms 579s expressions ... ok 220 ms 579s unicode ... ok 160 ms 579s xid ... ok 156 ms 579s mvcc ... ok 197 ms 579s database ... ok 261 ms 579s test create_function_1 ... ok 16 ms 579s test create_type ... ok 20 ms 579s test create_table ... ok 169 ms 579s test create_function_2 ... ok 15 ms 579s parallel group (5 tests): copydml copyselect insert_conflict insert copy 579s copy ... ok 275 ms 579s copyselect ... ok 55 ms 579s copydml ... ok 34 ms 579s insert ... ok 193 ms 579s insert_conflict ... ok 135 ms 580s parallel group (4 tests): create_schema create_operator create_procedure create_misc 580s create_misc ... ok 71 ms 580s create_operator ... ok 44 ms 580s create_procedure ... ok 55 ms 580s create_schema ... ok 38 ms 580s parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 580s create_index ... ok 518 ms 580s create_index_spgist ... ok 336 ms 580s create_view ... ok 284 ms 580s index_including ... ok 191 ms 580s index_including_gist ... ok 262 ms 581s parallel group (16 tests): create_cast typed_table select create_function_3 roleattributes create_aggregate errors create_am hash_func constraints drop_if_exists infinite_recurse vacuum inherit triggers updatable_views 581s create_aggregate ... ok 258 ms 581s create_function_3 ... ok 200 ms 581s create_cast ... ok 128 ms 581s constraints ... ok 315 ms 581s triggers ... ok 629 ms 581s select ... ok 157 ms 581s inherit ... ok 548 ms 581s typed_table ... ok 142 ms 581s vacuum ... ok 517 ms 581s drop_if_exists ... ok 331 ms 581s updatable_views ... ok 652 ms 581s roleattributes ... ok 214 ms 581s create_am ... ok 301 ms 581s hash_func ... ok 310 ms 581s errors ... ok 282 ms 581s infinite_recurse ... ok 343 ms 581s test sanity_check ... ok 64 ms 582s parallel group (20 tests): case select_distinct_on select_having select_implicit delete random namespace select_into prepared_xacts select_distinct portals union transactions subselect hash_index arrays update aggregates join btree_index 582s select_into ... ok 292 ms 582s select_distinct ... ok 408 ms 582s select_distinct_on ... ok 139 ms 582s select_implicit ... ok 153 ms 582s select_having ... ok 146 ms 582s subselect ... ok 512 ms 582s union ... ok 470 ms 582s case ... ok 114 ms 582s join ... ok 744 ms 582s aggregates ... ok 685 ms 582s transactions ... ok 498 ms 582s random ... ok 203 ms 582s portals ... ok 453 ms 582s arrays ... ok 616 ms 582s btree_index ... ok 1031 ms 582s hash_index ... ok 585 ms 582s update ... ok 666 ms 582s delete ... ok 201 ms 582s namespace ... ok 208 ms 582s prepared_xacts ... ok 297 ms 584s parallel group (20 tests): tablesample init_privs drop_operator object_address security_label lock replica_identity collate identity password groupingsets generated matview rowsecurity spgist gin gist brin join_hash privileges 584s brin ... ok 1681 ms 584s gin ... ok 1424 ms 584s gist ... ok 1452 ms 584s spgist ... ok 1259 ms 584s privileges ... ok 1938 ms 584s init_privs ... ok 231 ms 584s security_label ... ok 363 ms 584s collate ... ok 555 ms 584s matview ... ok 993 ms 584s lock ... ok 415 ms 584s replica_identity ... ok 516 ms 584s rowsecurity ... ok 1179 ms 584s object_address ... ok 359 ms 584s tablesample ... ok 154 ms 584s groupingsets ... ok 855 ms 584s drop_operator ... ok 294 ms 584s password ... ok 737 ms 584s identity ... ok 639 ms 584s generated ... ok 868 ms 584s join_hash ... ok 1679 ms 584s parallel group (2 tests): brin_bloom brin_multi 584s brin_bloom ... ok 59 ms 584s brin_multi ... ok 105 ms 584s parallel group (14 tests): sysviews alter_operator async tidscan dbsize tid tidrangescan tsrf create_table_like alter_generic incremental_sort misc_functions misc collate.icu.utf8 584s create_table_like ... ok 263 ms 584s alter_generic ... ok 270 ms 584s alter_operator ... ok 161 ms 584s misc ... ok 300 ms 584s async ... ok 163 ms 584s dbsize ... ok 200 ms 584s misc_functions ... ok 298 ms 584s sysviews ... ok 155 ms 584s tsrf ... ok 245 ms 584s tid ... ok 200 ms 584s tidscan ... ok 181 ms 584s tidrangescan ... ok 204 ms 584s collate.icu.utf8 ... ok 329 ms 584s incremental_sort ... ok 282 ms 585s parallel group (6 tests): collate.linux.utf8 amutils psql_crosstab rules psql stats_ext 585s rules ... ok 151 ms 585s psql ... ok 222 ms 585s psql_crosstab ... ok 71 ms 585s amutils ... ok 54 ms 585s stats_ext ... ok 785 ms 585s collate.linux.utf8 ... ok 34 ms 586s test select_parallel ... ok 644 ms 586s test write_parallel ... ok 72 ms 586s test vacuum_parallel ... ok 72 ms 586s parallel group (2 tests): subscription publication 586s publication ... ok 52 ms 586s subscription ... ok 36 ms 587s parallel group (17 tests): advisory_lock portals_p2 functional_deps guc dependency xmlmap select_views combocid equivclass tsdicts window tsearch bitmapops cluster foreign_data indirect_toast foreign_key 587s select_views ... ok 289 ms 587s portals_p2 ... ok 230 ms 587s foreign_key ... ok 803 ms 587s cluster ... ok 560 ms 587s dependency ... ok 284 ms 587s guc ... ok 258 ms 587s bitmapops ... ok 515 ms 587s combocid ... ok 297 ms 587s tsearch ... ok 510 ms 587s tsdicts ... ok 332 ms 587s foreign_data ... ok 625 ms 587s window ... ok 433 ms 587s xmlmap ... ok 286 ms 587s functional_deps ... ok 245 ms 587s advisory_lock ... ok 216 ms 587s indirect_toast ... ok 656 ms 587s equivclass ... ok 303 ms 587s parallel group (6 tests): jsonpath json_encoding jsonpath_encoding jsonb_jsonpath json jsonb 587s json ... ok 102 ms 587s jsonb ... ok 157 ms 587s json_encoding ... ok 54 ms 587s jsonpath ... ok 36 ms 587s jsonpath_encoding ... ok 55 ms 587s jsonb_jsonpath ... ok 92 ms 588s parallel group (18 tests): prepare plancache conversion limit returning rangefuncs temp polymorphism copy2 sequence domain truncate rowtypes with largeobject xml plpgsql alter_table 588s plancache ... ok 139 ms 588s limit ... ok 230 ms 588s plpgsql ... ok 715 ms 588s copy2 ... ok 388 ms 588s temp ... ok 337 ms 588s domain ... ok 409 ms 588s rangefuncs ... ok 304 ms 588s prepare ... ok 123 ms 588s conversion ... ok 186 ms 588s truncate ... ok 447 ms 588s alter_table ... ok 1019 ms 588s sequence ... ok 406 ms 588s polymorphism ... ok 337 ms 588s rowtypes ... ok 451 ms 588s returning ... ok 301 ms 588s largeobject ... ok 595 ms 588s with ... ok 480 ms 588s xml ... ok 693 ms 589s parallel group (11 tests): hash_part partition_info reloptions explain memoize compression partition_prune indexing partition_aggregate partition_join tuplesort 589s partition_join ... ok 864 ms 589s partition_prune ... ok 633 ms 589s reloptions ... ok 154 ms 589s hash_part ... ok 117 ms 589s indexing ... ok 776 ms 589s partition_aggregate ... ok 857 ms 589s partition_info ... ok 151 ms 589s tuplesort ... ok 1003 ms 589s explain ... ok 155 ms 589s compression ... ok 277 ms 589s memoize ... ok 206 ms 589s parallel group (2 tests): event_trigger oidjoins 589s event_trigger ... ok 68 ms 589s oidjoins ... ok 117 ms 589s test fast_default ... ok 62 ms 590s test stats ... ok 570 ms 590s 590s ======================== 590s 1 of 212 tests failed. 590s ======================== 590s 590s The differences that caused some tests to fail can be viewed in the 590s file "/tmp/regress.cWiogR/regression.diffs". A copy of the test summary that you see 590s above is saved in the file "/tmp/regress.cWiogR/regression.out". 590s 590s *** /tmp/pg_virtualenv.JSsA6O/log/postgresql-14-regress.log (last 100 lines) *** 590s 2025-02-26 13:25:43.091 UTC [5509] ubuntu@regression DETAIL: Key (a)=(3) already exists. 590s 2025-02-26 13:25:43.091 UTC [5509] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression DETAIL: Key (a)=(4) already exists. 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 590s 2025-02-26 13:25:43.092 UTC [5509] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 590s 2025-02-26 13:25:43.093 UTC [5509] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 590s 2025-02-26 13:25:43.093 UTC [5509] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 590s 2025-02-26 13:25:43.094 UTC [5509] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 590s 2025-02-26 13:25:43.094 UTC [5509] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 590s 2025-02-26 13:25:43.134 UTC [5509] ubuntu@regression ERROR: division by zero 590s 2025-02-26 13:25:43.134 UTC [5509] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 590s 2025-02-26 13:25:43.395 UTC [5592] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 590s 2025-02-26 13:25:43.395 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 590s on ddl_command_start 590s execute procedure pg_backend_pid(); 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression ERROR: trigger functions can only be called as triggers 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 590s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 590s 2025-02-26 13:25:43.396 UTC [5592] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 590s SELECT 1 $$ language sql; 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: unrecognized filter variable "food" 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when food in ('sandwich') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('sandwich') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('create table', 'create skunkcabbage') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('DROP EVENT TRIGGER') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('CREATE ROLE') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('CREATE DATABASE') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('CREATE TABLESPACE') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: filter variable "tag" specified more than once 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s when tag in ('create table') and tag in ('CREATE FUNCTION') 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 590s execute procedure test_event_trigger('argument not allowed'); 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression HINT: Must be superuser to create an event trigger. 590s 2025-02-26 13:25:43.410 UTC [5592] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 590s execute procedure test_event_trigger(); 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 590s owner of user mapping for regress_evt_user on server useless_server 590s owner of default privileges on new relations belonging to role regress_evt_user 590s 2025-02-26 13:25:43.414 UTC [5592] ubuntu@regression STATEMENT: drop role regress_evt_user; 590s 2025-02-26 13:25:43.421 UTC [5592] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 590s 2025-02-26 13:25:43.421 UTC [5592] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 590s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 590s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 590s 2025-02-26 13:25:43.421 UTC [5592] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 590s 2025-02-26 13:25:43.422 UTC [5592] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 590s 2025-02-26 13:25:43.422 UTC [5592] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 590s 2025-02-26 13:25:43.422 UTC [5592] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 590s 2025-02-26 13:25:43.436 UTC [5592] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 590s 2025-02-26 13:25:43.436 UTC [5592] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 590s 2025-02-26 13:25:43.438 UTC [5592] ubuntu@regression ERROR: rewrites not allowed 590s 2025-02-26 13:25:43.438 UTC [5592] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 590s 2025-02-26 13:25:43.438 UTC [5592] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 590s 2025-02-26 13:25:43.445 UTC [5592] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 590s 2025-02-26 13:25:43.445 UTC [5592] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 590s 2025-02-26 13:25:44.125 UTC [5603] ubuntu@regression LOG: wait_for_stats delayed 0.519293 seconds 590s 2025-02-26 13:25:44.125 UTC [5603] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 590s 2025-02-26 13:25:44.125 UTC [5603] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 590s Dropping cluster 14/regress ... 590s diff -U3 /tmp/autopkgtest.G5tJZd/build.jYZ/src/src/test/regress/expected/timestamptz.out /tmp/regress.cWiogR/results/timestamptz.out 590s --- /tmp/autopkgtest.G5tJZd/build.jYZ/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:37:40.000000000 +0000 590s +++ /tmp/regress.cWiogR/results/timestamptz.out 2025-02-26 13:25:32.941596899 +0000 590s @@ -2280,7 +2280,7 @@ 590s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 590s timezone 590s -------------------------- 590s - Wed Dec 09 15:56:00 1846 590s + Wed Dec 09 15:56:08 1846 590s (1 row) 590s 590s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 590s + head -100 /tmp/regress.cWiogR/regression.diffs 590s + exit 1 590s + rm -rf /tmp/regress.cWiogR 590s autopkgtest [13:25:44]: test installcheck: -----------------------] 591s autopkgtest [13:25:45]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 591s installcheck FAIL non-zero exit status 1 591s autopkgtest [13:25:45]: @@@@@@@@@@@@@@@@@@@@ summary 591s run-testsuite PASS 591s installcheck FAIL non-zero exit status 1 608s nova [W] Using flock in prodstack6-s390x 608s flock: timeout while waiting to get lock 608s Creating nova instance adt-jammy-s390x-postgresql-14-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-2092b963-c55c-4f43-9c9a-95fb5375b1c1 from image adt/ubuntu-jammy-s390x-server-20250226.img (UUID 391b9efd-4c56-4327-976d-a2a29ffd64a3)... 608s nova [W] Timed out waiting for 93eac5f8-744e-4e4d-bde5-bf76de4373e0 to get deleted. 608s nova [W] Using flock in prodstack6-s390x 608s Creating nova instance adt-jammy-s390x-postgresql-14-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-2092b963-c55c-4f43-9c9a-95fb5375b1c1 from image adt/ubuntu-jammy-s390x-server-20250226.img (UUID 391b9efd-4c56-4327-976d-a2a29ffd64a3)... 608s nova [W] Timed out waiting for a9676b14-095d-4078-8b6a-60217cb7055b to get deleted.