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._lldbmeb/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-12 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025a-0ubuntu0.20.04 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-s390x-19.secgroup --name adt-focal-s390x-postgresql-12-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-8da9da23-aa62-4dbd-9972-9c8de1d291b0 --image adt/ubuntu-focal-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/ 106s autopkgtest [13:17:40]: testbed dpkg architecture: s390x 106s autopkgtest [13:17:40]: testbed apt version: 2.0.10 106s autopkgtest [13:17:40]: @@@@@@@@@@@@@@@@@@@@ test bed setup 106s autopkgtest [13:17:40]: testbed release detected to be: None 107s autopkgtest [13:17:41]: updating testbed package index (apt update) 107s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 107s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 107s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 108s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 108s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 108s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 108s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 108s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 108s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main s390x Packages [142 kB] 108s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main s390x c-n-f Metadata [1432 B] 108s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x Packages [1872 B] 108s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x c-n-f Metadata [116 B] 108s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x Packages [36.5 kB] 108s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x c-n-f Metadata [1648 B] 108s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x Packages [952 B] 108s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x c-n-f Metadata [116 B] 110s Fetched 565 kB in 1s (611 kB/s) 111s Reading package lists... 111s + lsb_release --codename --short 111s + RELEASE=focal 111s + cat 111s + [ focal != trusty ] 111s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 111s Reading package lists... 111s Building dependency tree... 111s Reading state information... 111s Calculating upgrade... 111s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 111s + /usr/lib/apt/apt-helper analyze-pattern ?true 111s + uname -r 111s + sed s/\./\\./g 111s + running_kernel_pattern=^linux-.*5\.4\.0-208-generic.* 111s + apt list ?obsolete 111s + tail -n+2 111s + cut -d/ -f1 111s + grep -v ^linux-.*5\.4\.0-208-generic.* 112s + true 112s + obsolete_pkgs= 112s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 112s + grep -q trusty /etc/lsb-release 112s + [ ! -d /usr/share/doc/unattended-upgrades ] 112s + [ ! -d /usr/share/doc/lxd ] 112s + [ ! -d /usr/share/doc/lxd-client ] 112s + [ ! -d /usr/share/doc/snapd ] 112s + type iptables 112s + cat 112s + chmod 755 /etc/rc.local 112s + . /etc/rc.local 112s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 112s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 112s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 112s + uname -m 112s + [ s390x = ppc64le ] 112s + [ -d /run/systemd/system ] 112s + systemd-detect-virt --quiet --vm 112s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 112s + cat 112s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 112s + echo COMPRESS=lz4 112s autopkgtest [13:17:46]: upgrading testbed (apt dist-upgrade and autopurge) 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 112s 112s The following packages will be upgraded: 112s tzdata 112s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 112s Need to get 300 kB of archives. 112s After this operation, 3072 B of additional disk space will be used. 112s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main s390x tzdata all 2025a-0ubuntu0.20.04 [300 kB] 113s Preconfiguring packages ... 113s Fetched 300 kB in 0s (738 kB/s) 113s (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 ... 71285 files and directories currently installed.) 113s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 113s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 113s Setting up tzdata (2025a-0ubuntu0.20.04) ... 113s 113s Current default time zone: 'Etc/UTC' 113s Local time is now: Wed Feb 26 13:19:13 UTC 2025. 113s Universal Time is now: Wed Feb 26 13:19:13 UTC 2025. 113s Run 'dpkg-reconfigure tzdata' if you wish to change it. 113s 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s Starting pkgProblemResolver with broken count: 0 114s Starting 2 pkgProblemResolver with broken count: 0 114s Done 114s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 116s autopkgtest [13:17:50]: testbed running kernel: Linux 5.4.0-208-generic #228-Ubuntu SMP Fri Feb 7 19:42:20 UTC 2025 116s autopkgtest [13:17:50]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-12 127s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (dsc) [3764 B] 127s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (tar) [27.9 MB] 127s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (diff) [31.2 kB] 127s gpgv: Signature made Wed Nov 27 17:17:35 2024 UTC 127s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 127s gpgv: Can't check signature: No public key 127s dpkg-source: warning: failed to verify signature on ./postgresql-12_12.22-0ubuntu0.20.04.1.dsc 127s autopkgtest [13:18:01]: testing package postgresql-12 version 12.22-0ubuntu0.20.04.1 129s autopkgtest [13:18:03]: build not needed 136s autopkgtest [13:18:10]: test run-testsuite: preparing testbed 136s Reading package lists... 136s Building dependency tree... 136s Reading state information... 136s Starting pkgProblemResolver with broken count: 0 136s Starting 2 pkgProblemResolver with broken count: 0 136s Done 136s The following NEW packages will be installed: 136s build-essential cpp cpp-9 dictionaries-common emacsen-common g++ g++-9 gcc 136s gcc-9 gcc-9-base hunspell-en-us libasan5 libatomic1 libc-dev-bin libc6-dev 136s libcc1-0 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libgcc-9-dev 136s libgomp1 libisl22 libitm1 libmpc3 libpgtypes3 libpq-dev libpq5 libpython3.8 136s libstdc++-9-dev libtcl8.6 libubsan1 libxslt1.1 linux-libc-dev net-tools 136s postgresql-12 postgresql-client-12 postgresql-client-common 136s postgresql-common postgresql-doc-12 postgresql-plperl-12 136s postgresql-plpython3-12 postgresql-pltcl-12 postgresql-server-dev-12 136s ssl-cert 136s 0 upgraded, 45 newly installed, 0 to remove and 0 not upgraded. 136s Need to get 40.2 MB of archives. 136s After this operation, 194 MB of additional disk space will be used. 136s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc-dev-bin s390x 2.31-0ubuntu9.17 [63.2 kB] 136s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main s390x linux-libc-dev s390x 5.4.0-208.228 [1117 kB] 137s Get:3 http://ftpmaster.internal/ubuntu focal/main s390x libcrypt-dev s390x 1:4.4.10-10ubuntu4 [107 kB] 137s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc6-dev s390x 2.31-0ubuntu9.17 [2023 kB] 137s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9-base s390x 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 137s Get:6 http://ftpmaster.internal/ubuntu focal/main s390x libisl22 s390x 0.22.1-1 [545 kB] 137s Get:7 http://ftpmaster.internal/ubuntu focal/main s390x libmpc3 s390x 1.1.0-1 [38.3 kB] 137s Get:8 http://ftpmaster.internal/ubuntu focal-updates/main s390x cpp-9 s390x 9.4.0-1ubuntu1~20.04.2 [5727 kB] 137s Get:9 http://ftpmaster.internal/ubuntu focal/main s390x cpp s390x 4:9.3.0-1ubuntu2 [27.6 kB] 137s Get:10 http://ftpmaster.internal/ubuntu focal-updates/main s390x libcc1-0 s390x 10.5.0-1ubuntu1~20.04 [45.0 kB] 137s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgomp1 s390x 10.5.0-1ubuntu1~20.04 [95.0 kB] 137s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main s390x libitm1 s390x 10.5.0-1ubuntu1~20.04 [25.4 kB] 137s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main s390x libatomic1 s390x 10.5.0-1ubuntu1~20.04 [8524 B] 137s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main s390x libasan5 s390x 9.4.0-1ubuntu1~20.04.2 [2556 kB] 137s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main s390x libubsan1 s390x 10.5.0-1ubuntu1~20.04 [756 kB] 137s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgcc-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [689 kB] 137s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9 s390x 9.4.0-1ubuntu1~20.04.2 [6489 kB] 138s Get:18 http://ftpmaster.internal/ubuntu focal/main s390x gcc s390x 4:9.3.0-1ubuntu2 [5204 B] 138s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main s390x libstdc++-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [1682 kB] 138s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main s390x g++-9 s390x 9.4.0-1ubuntu1~20.04.2 [6608 kB] 138s Get:21 http://ftpmaster.internal/ubuntu focal/main s390x g++ s390x 4:9.3.0-1ubuntu2 [1600 B] 138s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main s390x build-essential s390x 12.8ubuntu1.1 [4664 B] 138s Get:23 http://ftpmaster.internal/ubuntu focal/main s390x emacsen-common all 3.0.4 [14.9 kB] 138s Get:24 http://ftpmaster.internal/ubuntu focal/main s390x dictionaries-common all 1.28.1 [178 kB] 138s Get:25 http://ftpmaster.internal/ubuntu focal/main s390x hunspell-en-us all 1:2018.04.16-1 [170 kB] 138s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpgtypes3 s390x 12.22-0ubuntu0.20.04.1 [44.2 kB] 138s Get:27 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpq5 s390x 12.22-0ubuntu0.20.04.1 [109 kB] 138s Get:28 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg6 s390x 12.22-0ubuntu0.20.04.1 [40.4 kB] 138s Get:29 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg-compat3 s390x 12.22-0ubuntu0.20.04.1 [12.1 kB] 138s Get:30 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpq-dev s390x 12.22-0ubuntu0.20.04.1 [133 kB] 138s Get:31 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg-dev s390x 12.22-0ubuntu0.20.04.1 [223 kB] 138s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpython3.8 s390x 3.8.10-0ubuntu1~20.04.15 [1479 kB] 139s Get:33 http://ftpmaster.internal/ubuntu focal/main s390x libtcl8.6 s390x 8.6.10+dfsg-1 [838 kB] 139s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.20.04.1 [140 kB] 139s Get:35 http://ftpmaster.internal/ubuntu focal/main s390x net-tools s390x 1.60+git20180626.aebd88e-1ubuntu1 [187 kB] 139s Get:36 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-common all 214ubuntu0.1 [28.2 kB] 139s Get:37 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-12 s390x 12.22-0ubuntu0.20.04.1 [1012 kB] 139s Get:38 http://ftpmaster.internal/ubuntu focal/main s390x ssl-cert all 1.0.39 [17.0 kB] 139s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-common all 214ubuntu0.1 [169 kB] 139s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-12 s390x 12.22-0ubuntu0.20.04.1 [3735 kB] 139s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 139s Get:42 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-plperl-12 s390x 12.22-0ubuntu0.20.04.1 [47.1 kB] 139s Get:43 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-plpython3-12 s390x 12.22-0ubuntu0.20.04.1 [53.4 kB] 139s Get:44 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-pltcl-12 s390x 12.22-0ubuntu0.20.04.1 [30.0 kB] 139s Get:45 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-server-dev-12 s390x 12.22-0ubuntu0.20.04.1 [984 kB] 140s Preconfiguring packages ... 140s Fetched 40.2 MB in 3s (13.2 MB/s) 140s Selecting previously unselected package libc-dev-bin. 140s (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 ... 71286 files and directories currently installed.) 140s Preparing to unpack .../00-libc-dev-bin_2.31-0ubuntu9.17_s390x.deb ... 140s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 140s Selecting previously unselected package linux-libc-dev:s390x. 140s Preparing to unpack .../01-linux-libc-dev_5.4.0-208.228_s390x.deb ... 140s Unpacking linux-libc-dev:s390x (5.4.0-208.228) ... 140s Selecting previously unselected package libcrypt-dev:s390x. 140s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.10-10ubuntu4_s390x.deb ... 140s Unpacking libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 140s Selecting previously unselected package libc6-dev:s390x. 140s Preparing to unpack .../03-libc6-dev_2.31-0ubuntu9.17_s390x.deb ... 140s Unpacking libc6-dev:s390x (2.31-0ubuntu9.17) ... 140s Selecting previously unselected package gcc-9-base:s390x. 140s Preparing to unpack .../04-gcc-9-base_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 140s Unpacking gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 140s Selecting previously unselected package libisl22:s390x. 140s Preparing to unpack .../05-libisl22_0.22.1-1_s390x.deb ... 140s Unpacking libisl22:s390x (0.22.1-1) ... 140s Selecting previously unselected package libmpc3:s390x. 140s Preparing to unpack .../06-libmpc3_1.1.0-1_s390x.deb ... 140s Unpacking libmpc3:s390x (1.1.0-1) ... 140s Selecting previously unselected package cpp-9. 140s Preparing to unpack .../07-cpp-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 140s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 140s Selecting previously unselected package cpp. 140s Preparing to unpack .../08-cpp_4%3a9.3.0-1ubuntu2_s390x.deb ... 140s Unpacking cpp (4:9.3.0-1ubuntu2) ... 140s Selecting previously unselected package libcc1-0:s390x. 140s Preparing to unpack .../09-libcc1-0_10.5.0-1ubuntu1~20.04_s390x.deb ... 140s Unpacking libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 140s Selecting previously unselected package libgomp1:s390x. 141s Preparing to unpack .../10-libgomp1_10.5.0-1ubuntu1~20.04_s390x.deb ... 141s Unpacking libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libitm1:s390x. 141s Preparing to unpack .../11-libitm1_10.5.0-1ubuntu1~20.04_s390x.deb ... 141s Unpacking libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libatomic1:s390x. 141s Preparing to unpack .../12-libatomic1_10.5.0-1ubuntu1~20.04_s390x.deb ... 141s Unpacking libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libasan5:s390x. 141s Preparing to unpack .../13-libasan5_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 141s Unpacking libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 141s Selecting previously unselected package libubsan1:s390x. 141s Preparing to unpack .../14-libubsan1_10.5.0-1ubuntu1~20.04_s390x.deb ... 141s Unpacking libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libgcc-9-dev:s390x. 141s Preparing to unpack .../15-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 141s Unpacking libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 141s Selecting previously unselected package gcc-9. 141s Preparing to unpack .../16-gcc-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 141s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 141s Selecting previously unselected package gcc. 141s Preparing to unpack .../17-gcc_4%3a9.3.0-1ubuntu2_s390x.deb ... 141s Unpacking gcc (4:9.3.0-1ubuntu2) ... 141s Selecting previously unselected package libstdc++-9-dev:s390x. 141s Preparing to unpack .../18-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 141s Unpacking libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 142s Selecting previously unselected package g++-9. 142s Preparing to unpack .../19-g++-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 142s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 142s Selecting previously unselected package g++. 142s Preparing to unpack .../20-g++_4%3a9.3.0-1ubuntu2_s390x.deb ... 142s Unpacking g++ (4:9.3.0-1ubuntu2) ... 142s Selecting previously unselected package build-essential. 142s Preparing to unpack .../21-build-essential_12.8ubuntu1.1_s390x.deb ... 142s Unpacking build-essential (12.8ubuntu1.1) ... 142s Selecting previously unselected package emacsen-common. 142s Preparing to unpack .../22-emacsen-common_3.0.4_all.deb ... 142s Unpacking emacsen-common (3.0.4) ... 142s Selecting previously unselected package dictionaries-common. 142s Preparing to unpack .../23-dictionaries-common_1.28.1_all.deb ... 142s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 142s Unpacking dictionaries-common (1.28.1) ... 142s Selecting previously unselected package hunspell-en-us. 142s Preparing to unpack .../24-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 142s Unpacking hunspell-en-us (1:2018.04.16-1) ... 142s Selecting previously unselected package libpgtypes3:s390x. 142s Preparing to unpack .../25-libpgtypes3_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libpgtypes3:s390x (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libpq5:s390x. 142s Preparing to unpack .../26-libpq5_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libpq5:s390x (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libecpg6:s390x. 142s Preparing to unpack .../27-libecpg6_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libecpg6:s390x (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libecpg-compat3:s390x. 142s Preparing to unpack .../28-libecpg-compat3_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libecpg-compat3:s390x (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libpq-dev. 142s Preparing to unpack .../29-libpq-dev_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libecpg-dev. 142s Preparing to unpack .../30-libecpg-dev_12.22-0ubuntu0.20.04.1_s390x.deb ... 142s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 142s Selecting previously unselected package libpython3.8:s390x. 142s Preparing to unpack .../31-libpython3.8_3.8.10-0ubuntu1~20.04.15_s390x.deb ... 142s Unpacking libpython3.8:s390x (3.8.10-0ubuntu1~20.04.15) ... 143s Selecting previously unselected package libtcl8.6:s390x. 143s Preparing to unpack .../32-libtcl8.6_8.6.10+dfsg-1_s390x.deb ... 143s Unpacking libtcl8.6:s390x (8.6.10+dfsg-1) ... 143s Selecting previously unselected package libxslt1.1:s390x. 143s Preparing to unpack .../33-libxslt1.1_1.1.34-4ubuntu0.20.04.1_s390x.deb ... 143s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.1) ... 143s Selecting previously unselected package net-tools. 143s Preparing to unpack .../34-net-tools_1.60+git20180626.aebd88e-1ubuntu1_s390x.deb ... 143s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 143s Selecting previously unselected package postgresql-client-common. 143s Preparing to unpack .../35-postgresql-client-common_214ubuntu0.1_all.deb ... 143s Unpacking postgresql-client-common (214ubuntu0.1) ... 143s Selecting previously unselected package postgresql-client-12. 143s Preparing to unpack .../36-postgresql-client-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package ssl-cert. 143s Preparing to unpack .../37-ssl-cert_1.0.39_all.deb ... 143s Unpacking ssl-cert (1.0.39) ... 143s Selecting previously unselected package postgresql-common. 143s Preparing to unpack .../38-postgresql-common_214ubuntu0.1_all.deb ... 143s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 143s Unpacking postgresql-common (214ubuntu0.1) ... 143s Selecting previously unselected package postgresql-12. 143s Preparing to unpack .../39-postgresql-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package postgresql-doc-12. 143s Preparing to unpack .../40-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 143s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package postgresql-plperl-12. 143s Preparing to unpack .../41-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package postgresql-plpython3-12. 143s Preparing to unpack .../42-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package postgresql-pltcl-12. 143s Preparing to unpack .../43-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 143s Selecting previously unselected package postgresql-server-dev-12. 143s Preparing to unpack .../44-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 143s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 143s Setting up postgresql-client-common (214ubuntu0.1) ... 143s Setting up libpgtypes3:s390x (12.22-0ubuntu0.20.04.1) ... 143s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 143s Setting up libpq5:s390x (12.22-0ubuntu0.20.04.1) ... 143s Setting up linux-libc-dev:s390x (5.4.0-208.228) ... 143s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 143s Setting up libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 143s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 144s update-alternatives: using /usr/share/postgresql/12/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 144s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 144s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 144s Setting up emacsen-common (3.0.4) ... 144s Setting up ssl-cert (1.0.39) ... 144s Setting up libpython3.8:s390x (3.8.10-0ubuntu1~20.04.15) ... 144s Setting up postgresql-common (214ubuntu0.1) ... 145s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 145s Adding user postgres to group ssl-cert 145s 145s Creating config file /etc/postgresql-common/createcluster.conf with new version 145s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 145s en_us 145s Removing obsolete dictionary files: 145s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 145s Setting up libmpc3:s390x (1.1.0-1) ... 145s Setting up libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 145s Setting up libtcl8.6:s390x (8.6.10+dfsg-1) ... 145s Setting up libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 145s Setting up libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 145s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.1) ... 145s Setting up libecpg6:s390x (12.22-0ubuntu0.20.04.1) ... 145s Setting up libisl22:s390x (0.22.1-1) ... 145s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 146s Creating new PostgreSQL cluster 12/main ... 146s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 146s The files belonging to this database system will be owned by user "postgres". 146s This user must also own the server process. 146s 146s The database cluster will be initialized with locale "C.UTF-8". 146s The default database encoding has accordingly been set to "UTF8". 146s The default text search configuration will be set to "english". 146s 146s Data page checksums are disabled. 146s 146s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 146s creating subdirectories ... ok 146s selecting dynamic shared memory implementation ... posix 146s selecting default max_connections ... 100 146s selecting default shared_buffers ... 128MB 146s selecting default time zone ... Etc/UTC 146s creating configuration files ... ok 146s running bootstrap script ... ok 146s performing post-bootstrap initialization ... ok 146s syncing data to disk ... ok 146s 146s Success. You can now start the database server using: 146s 146s pg_ctlcluster 12 main start 146s 146s Ver Cluster Port Status Owner Data directory Log file 146s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 146s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 149s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 149s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 149s Setting up libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 149s Setting up libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 149s Setting up gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 149s Setting up libecpg-compat3:s390x (12.22-0ubuntu0.20.04.1) ... 149s Setting up dictionaries-common (1.28.1) ... 149s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 149s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 149s Setting up libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 149s Setting up hunspell-en-us (1:2018.04.16-1) ... 149s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up libc6-dev:s390x (2.31-0ubuntu9.17) ... 149s Setting up libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up cpp (4:9.3.0-1ubuntu2) ... 149s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up gcc (4:9.3.0-1ubuntu2) ... 149s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 149s Setting up g++ (4:9.3.0-1ubuntu2) ... 149s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 149s Setting up build-essential (12.8ubuntu1.1) ... 149s Processing triggers for systemd (245.4-4ubuntu3.24) ... 149s Processing triggers for man-db (2.9.1-1) ... 151s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 151s Processing triggers for dictionaries-common (1.28.1) ... 154s autopkgtest [13:18:28]: test run-testsuite: [----------------------- 154s Generating locales (this might take a while)... 155s en_US.UTF-8... done 155s ru_RU.ISO-8859-5... done 156s ru_RU.UTF-8... done 156s Generation complete. 156s ====== Running all tests with umask 077 ======= 156s === Running test 001_packages.t ... === 156s 1..18 156s # PostgreSQL versions installed: 12 156s ok 1 - postgresql-12 installed 156s ok 2 # skip No python2 support 156s ok 3 - postgresql-plpython3-12 installed 156s ok 4 - postgresql-plperl-12 installed 156s ok 5 - postgresql-pltcl-12 installed 156s ok 6 - postgresql-server-dev-12 installed 156s ok 7 # skip No postgresql-contrib-12 package for version 12 156s ok 8 - libecpg-dev installed 156s ok 9 - procps installed 156s ok 10 - netcat-openbsd installed 156s ok 11 - hunspell-en-us installed 156s ok 12 - system has a default UTF-8 locale 156s ok 13 - locale ru_RU exists 156s ok 14 - locale ru_RU.UTF-8 exists 156s ok 15 - user postgres in the UNIX group ssl-cert 156s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 156s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 156s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 156s === Running test 002_existing_clusters.t ... === 156s 1..8 157s ok 1 - Cleanup: No clusters left behind 157s ok 2 - No postgres processes left behind 157s ok 3 - No files in /etc/postgresql left behind 157s ok 4 - No files in /var/lib/postgresql left behind 157s ok 5 - No files in /var/run/postgresql left behind 157s ok 6 - No files in /var/log/postgresql left behind 157s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 157s ok 8 - PostgreSQL TCP ports are closed 157s === Running test 003_package_checks.t ... === 157s 1..4 157s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 157s ok 2 - psql is linked against libedit 157s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 157s ok 4 - psql is not linked against libreadline 157s === Running test 005_PgCommon.t ... === 157s 1..24 157s ok 1 - correctly parsed line 'local all postgres ident sameuser' 157s ok 2 - correctly parsed line 'local foo nobody trust' 157s ok 3 - correctly parsed line 'local foo nobody crypt' 157s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 157s ok 5 - correctly parsed line 'local foo,bar nobody ident' 157s ok 6 - correctly parsed line 'local all +foogrp password' 157s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 157s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 157s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 157s ok 10 - @expected_records has correct number of entries 157s ok 11 - returned read_pg_hba array has correct number of records 157s ok 12 - line 'foo all all md5' parsed as invalid 157s ok 13 - line 'local all all foo' parsed as invalid 157s ok 14 - line 'host all all foo' parsed as invalid 157s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 157s ok 16 - line 'host all all md5' parsed as invalid 157s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 157s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 157s ok 19 - read_conf_file returns empty dict for nonexisting file 157s ok 20 - read_conf_file() parsing 157s ok 21 - read_conf_file() parsing with include directives 157s ok 22 - set_conf_value 157s ok 23 - disable_conf_value 157s ok 24 - replace_conf_value 157s === Running test 006_next_free_port.t ... === 157s 1..5 157s ok 1 - next_free_port is 5432 158s ok 2 - next_free_port detects localhost ipv4 socket 158s ok 3 - next_free_port detects wildcard ipv4 socket 159s ok 4 - next_free_port detects localhost ipv6 socket 159s ok 5 - next_free_port detects wildcard ipv6 socket 159s === Running test 007_pg_conftool.t ... === 159s 1..41 159s # test without cluster 159s ok 1 - pg_conftool show all 159s ok 2 - correct output of pg_conftool show all 159s ok 3 - pg_conftool foo.conf show all 159s ok 4 - correct output of pg_conftool foo.conf show all 159s ok 5 - pg_conftool /tmp/W7m8cDvv9D/different.conf show all 159s ok 6 - correct output of pg_conftool /tmp/W7m8cDvv9D/different.conf show all 159s ok 7 - pg_conftool 9.7 main show all 159s ok 8 - correct output of pg_conftool 9.7 main show all 159s # test show 159s ok 9 - pg_conftool show all 159s ok 10 - correct output of pg_conftool show all 159s ok 11 - pg_conftool other.conf show all 159s ok 12 - correct output of pg_conftool other.conf show all 159s ok 13 - pg_conftool /tmp/W7m8cDvv9D/different.conf show all 159s ok 14 - correct output of pg_conftool /tmp/W7m8cDvv9D/different.conf show all 159s ok 15 - pg_conftool 12 main show all 159s ok 16 - correct output of pg_conftool 12 main show all 159s ok 17 - pg_conftool 12 main other.conf show all 159s ok 18 - correct output of pg_conftool 12 main other.conf show all 159s ok 19 - pg_conftool show a 159s ok 20 - correct output of pg_conftool show a 160s ok 21 - pg_conftool -s show a 160s ok 22 - correct output of pg_conftool -s show a 160s # test set 160s ok 23 - pg_conftool set c 7 160s ok 24 - correct output of pg_conftool set c 7 160s ok 25 - file contains new setting 160s ok 26 - pg_conftool set a 8 160s ok 27 - correct output of pg_conftool set a 8 160s ok 28 - file contains updated setting 160s ok 29 - pg_conftool /tmp/W7m8cDvv9D/different.conf set a 9 160s ok 30 - correct output of pg_conftool /tmp/W7m8cDvv9D/different.conf set a 9 160s ok 31 - file with path contains updated setting 160s # test remove 160s ok 32 - pg_conftool remove a 160s ok 33 - correct output of pg_conftool remove a 160s ok 34 - setting removed from file 160s ok 35 - pg_conftool /tmp/W7m8cDvv9D/different.conf remove a 160s ok 36 - correct output of pg_conftool /tmp/W7m8cDvv9D/different.conf remove a 160s ok 37 - setting removed from file with path 160s # test edit 160s ok 38 - pg_conftool edit 160s ok 39 - correct output of pg_conftool edit 160s ok 40 - pg_conftool /tmp/W7m8cDvv9D/different.conf edit 160s ok 41 - correct output of pg_conftool /tmp/W7m8cDvv9D/different.conf edit 160s === Running test 010_defaultport_cluster.t ... === 160s 1..14 160s ok 1 - psql --version 160s ok 2 - pg_wrapper selects highest available version number 160s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 160s ok 4 - connecting to localhost fails with no clusters 160s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 160s ok 6 - pg_wrapper uses host and port from PGCLUSTER 160s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 160s ok 8 - pg_wrapper uses --cluster from the command line 160s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 160s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 160s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 160s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 160s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 160s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 160s === Running test 015_start_stop.t ... === 160s 1..71 160s # We are running systemd 160s # Running tests for 12 160s # Cluster does not exist yet 160s ok 1 - cluster 12 main does not exist 160s ok 2 - service postgresql@12-main does not exist 160s ok 3 - systemctl start postgresql 160s ok 4 - cluster 12 main does not exist 160s ok 5 - service postgresql@12-main does not exist 160s ok 6 - systemctl start postgresql@12-main 160s ok 7 - cluster 12 main does not exist 160s ok 8 - service postgresql@12-main does not exist 160s # Start/stop postgresql using system tools 161s ok 9 - pg_createcluster 12 main 161s ok 10 - cluster 12 main is stopped 161s ok 11 - service postgresql@12-main is stopped 163s ok 12 - systemctl start postgresql 163s ok 13 - cluster 12 main is running 163s ok 14 - service postgresql@12-main is running 163s ok 15 - systemctl start postgresql 163s ok 16 - cluster 12 main is already running 163s ok 17 - service postgresql@12-main is already running 163s ok 18 - systemctl stop postgresql 169s ok 19 - cluster 12 main is stopped 169s ok 20 - service postgresql@12-main is stopped 169s ok 21 - systemctl stop postgresql 169s ok 22 - cluster 12 main is already stopped 169s ok 23 - service postgresql@12-main is already stopped 169s # Start/stop specific cluster using system tools 171s ok 24 - systemctl start postgresql@12-main 171s ok 25 - cluster 12 main is running 171s ok 26 - service postgresql@12-main is running 171s ok 27 - systemctl start postgresql@12-main 171s ok 28 - cluster 12 main is running 171s ok 29 - service postgresql@12-main is running 174s ok 30 - systemctl restart postgresql@12-main 174s ok 31 - cluster 12 main is running 174s ok 32 - service postgresql@12-main is running 174s ok 33 - systemctl stop postgresql@12-main 174s ok 34 - cluster 12 main is stopped 174s ok 35 - service postgresql@12-main is stopped 174s ok 36 - systemctl stop postgresql@12-main 174s ok 37 - cluster 12 main is already stopped 174s ok 38 - service postgresql@12-main is already stopped 174s ok 39 - pg_dropcluster 12 main 174s ok 40 - cluster 12 main does not exist 174s ok 41 - service postgresql@12-main does not exist 174s # Start/stop specific cluster using pg_*cluster 174s ok 42 - pg_ctlcluster start 12 main 174s ok 43 - cluster 12 main does not exist 174s ok 44 - service postgresql@12-main does not exist 177s ok 45 - pg_createcluster 12 main --start 177s ok 46 - cluster 12 main is running 177s ok 47 - service postgresql@12-main is running 177s ok 48 - pg_ctlcluster 12 main start 177s ok 49 - cluster 12 main is already running 177s ok 50 - service postgresql@12-main is already running 179s ok 51 - pg_ctlcluster 12-main restart 179s ok 52 - cluster 12 main is running 179s ok 53 - service postgresql@12-main is running 180s ok 54 - pg_ctlcluster 12 main stop 180s ok 55 - cluster 12 main is stopped 180s ok 56 - service postgresql@12-main is stopped 180s ok 57 - pg_ctlcluster 12 main stop 180s ok 58 - cluster 12 main is already stopped 180s ok 59 - service postgresql@12-main is already stopped 182s ok 60 - pg_ctlcluster start 12-main 182s ok 61 - cluster 12 main is running 182s ok 62 - service postgresql@12-main is running 182s ok 63 - pg_dropcluster 12 main --stop 182s ok 64 - Cleanup: No clusters left behind 182s ok 65 - No postgres processes left behind 182s ok 66 - No files in /etc/postgresql left behind 182s ok 67 - No files in /var/lib/postgresql left behind 182s ok 68 - No files in /var/run/postgresql left behind 182s ok 69 - No files in /var/log/postgresql left behind 182s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 182s ok 71 - PostgreSQL TCP ports are closed 182s === Running test 020_create_sql_remove.t ... === 182s 1..144 182s # Running tests for 12 185s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.IfKdms 185s ok 2 - pg_createcluster 12 main 185s ok 3 - Socket and pid file are in /var/run/postgresql/ 185s ok 4 - xlog/wal directory /tmp/12.xlog.IfKdms was created 185s ok 5 - Exactly one postgres master process running 188s ok 6 - pg_ctlcluster 12 main restart 188s ok 7 - cluster restarts with new environment file 188s ok 8 - Exactly one postgres master process running 188s ok 9 - correct value of PGEXTRAVAR1 in environment 188s ok 10 - correct value of PGEXTRAVAR2 in environment 188s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 188s ok 12 - createdb --version 188s ok 13 - pg_wrapper selects version number of cluster 188s ok 14 - psql --version 188s ok 15 - pg_wrapper selects version number of cluster 188s ok 16 - pg_lscluster reports online cluster on port 5432 188s ok 17 - log file is actually used 188s ok 18 - /etc/postgresql is owned by user "postgres" 188s ok 19 - version configuration directory file is owned by user "postgres" 188s ok 20 - configuration directory file is owned by user "postgres" 188s ok 21 - version data directory file is owned by user "postgres" 188s ok 22 - data directory file is owned by user "postgres" 188s ok 23 - log file has 0640 permissions 188s ok 24 - log file is owned by user "postgres" 188s ok 25 - log file is owned by group "adm" 188s ok 26 - no log symlink by default 188s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 188s ok 28 - pg_lsclusters -h 188s ok 29 - correct output of pg_lsclusters -h 188s ok 30 - stopping cluster 190s ok 31 - restarting cluster with nondefault log symlink 190s ok 32 - log target is used as log file 190s ok 33 - default log is not used 190s ok 34 - pg_lsclusters -h 190s ok 35 - correct output of pg_lsclusters -h 190s ok 36 - stopping cluster 192s ok 37 - restarting cluster with explicitly configured log file 192s ok 38 - default log is not used 192s ok 39 - log symlink target is used for startup message 192s ok 40 - exactly one log file 192s ok 41 - custom log is actually used 192s ok 42 - pg_lsclusters -h 192s ok 43 - correct output of pg_lsclusters -h 192s ok 44 - stopping cluster 192s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 192s ok 46 - /etc/postgres-hack was not created 195s ok 47 - restarting cluster 195s ok 48 - ps -o tty -U postgres h 195s ok 49 - postgres processes do not have an associated terminal 195s ok 50 - SSL is enabled 195s ok 51 - psql -l fails for nobody 195s ok 52 - createuser nobody 195s ok 53 - createdb nobodydb 195s ok 54 - psql -ltA succeeds for nobody 195s ok 55 - psql -ltA output 195s ok 56 - SQL command: create table 195s ok 57 - SQL command: insert into table values 195s ok 58 - SQL command: insert into table values 195s ok 59 - primary key violation 195s ok 60 - psql -tAc "select * from phone order by name" nobodydb 195s ok 61 - SQL command output: select -tA 195s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 195s ok 63 - SQL command output: select -tx 195s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 195s ok 65 - SQL command output: select -tAx 195s ok 66 - CREATE EXTENSION plperlu fails for user nobody 195s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 195s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 195s ok 69 - creating PL/PerlU function as user nobody fails 195s ok 70 - creating unsafe PL/Perl function as user postgres fails 195s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 195s ok 72 - creating PL/PerlU function as user postgres succeeds 195s ok 73 - psql nobodydb -Atc "select read_file()" 195s ok 74 - calling PL/PerlU function 195s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 195s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 195s ok 77 - creating unsafe PL/Perl function as user nobody fails 195s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 195s ok 79 - creating PL/Perl function as user nobody succeeds 195s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 195s ok 81 - calling PL/Perl function 195s ok 82 # skip No python2 support 195s ok 83 # skip No python2 support 195s ok 84 # skip No python2 support 195s ok 85 # skip No python2 support 195s ok 86 # skip No python2 support 195s ok 87 # skip No python2 support 195s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 195s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 195s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 195s ok 91 - creating PL/Python3 function as user postgres succeeds 195s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 195s ok 93 - calling PL/Python function 195s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 195s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 195s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 195s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 195s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 195s ok 99 - creating PL/Tcl function as user nobody succeeds 195s ok 100 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 195s ok 101 - creating PL/TclU function as user postgres succeeds 196s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 196s ok 103 - calling PL/Tcl function 196s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 196s ok 105 - calling PL/TclU function 196s ok 106 - stopping cluster 196s ok 107 - pg_ctlcluster 12 main start 196s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 198s ok 109 - pg_ctlcluster 12 main start 198s ok 110 - cluster restarts with pgdata symlink 198s ok 111 - postgres master has OOM killer protection 198s ok 112 - postgres client backend has no OOM adjustment 198s ok 113 - ps h 8540 198s ok 114 - process title is idle 199s ok 115 - ps h 8540 199s ok 116 - process title is idle in transaction 199s ok 117 - ps h 8540 199s ok 118 - process title is SELECT 201s ok 119 - dropdb nobodydb 201s ok 120 - dropuser nobody 202s ok 121 - stopping cluster 204s ok 122 - starting cluster as postgres works without a log file 204s ok 123 - log file got recreated and used 204s ok 124 - creating a directory in spc2 204s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.338h5y'" 204s ok 126 - creating tablespace spc1 204s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 204s ok 128 - creating a table in spc1 204s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.BnDQyg'" 204s ok 130 - creating tablespace spc2 204s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 204s ok 132 - creating a table in spc2 204s ok 133 - pg_dropcluster removes cluster 204s ok 134 - xlog/wal directory /tmp/12.xlog.IfKdms was deleted 204s ok 135 - tablespace spc1 was emptied 204s ok 136 - tablespace spc2 was emptied 204s ok 137 - Cleanup: No clusters left behind 204s ok 138 - No postgres processes left behind 204s ok 139 - No files in /etc/postgresql left behind 204s ok 140 - No files in /var/lib/postgresql left behind 204s ok 141 - No files in /var/run/postgresql left behind 204s ok 142 - No files in /var/log/postgresql left behind 204s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 204s ok 144 - PostgreSQL TCP ports are closed 204s === Running test 021_pg_renamecluster.t ... === 204s 1..20 207s ok 1 - pg_createcluster 12 main 210s ok 2 - pg_renamecluster 12 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 210s ok 12 - pg_dropcluster removes cluster 210s ok 13 - Cleanup: No clusters left behind 210s ok 14 - No postgres processes left behind 210s ok 15 - No files in /etc/postgresql left behind 210s ok 16 - No files in /var/lib/postgresql left behind 210s ok 17 - No files in /var/run/postgresql left behind 210s ok 18 - No files in /var/log/postgresql left behind 210s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 210s ok 20 - PostgreSQL TCP ports are closed 210s === Running test 022_recovery.t ... === 210s 1..17 210s # Running tests for 12 213s ok 1 - pg_createcluster 12 main --start >/dev/null 213s ok 2 - pg_ctlcluster 12 main stop -m i 215s ok 3 - pg_ctlcluster 12 main start 215s ok 4 - psql -c '' 216s ok 5 - pg_ctlcluster 12 main stop -m i 216s ok 6 - create write-protected file in data directory 218s ok 7 - pg_ctlcluster 12 main start 218s ok 8 - psql -c '' 218s ok 9 - pg_dropcluster removes cluster 218s ok 10 - Cleanup: No clusters left behind 218s ok 11 - No postgres processes left behind 218s ok 12 - No files in /etc/postgresql left behind 218s ok 13 - No files in /var/lib/postgresql left behind 218s ok 14 - No files in /var/run/postgresql left behind 218s ok 15 - No files in /var/log/postgresql left behind 218s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 218s ok 17 - PostgreSQL TCP ports are closed 218s === Running test 025_logging.t ... === 218s 1..55 219s # Logging to /var/log/syslog works 219s # Running tests for 12 222s ok 1 - pg_createcluster 12 main 222s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 222s ok 3 - psql -qc "'foobar_12_9201'" 222s ok 4 - log an error 222s ok 5 - grep --binary-files=text foobar_12_9201 /var/log/postgresql/postgresql-12-main.log 222s ok 6 - error appears in logfile 222s ok 7 - pg_conftool 12 main set log_destination syslog 222s ok 8 - set log_destination syslog 222s ok 9 - pg_ctlcluster 12 main reload 222s ok 10 - 12 main reload 222s ok 11 - psql -Atc "show log_destination" 222s ok 12 - log_destination is syslog 222s ok 13 - pg_lscluster reports syslog 222s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 222s ok 15 - error appears in /var/log/syslog 222s ok 16 - pg_conftool 12 main set logging_collector on 222s ok 17 - set logging_collector on 222s ok 18 - pg_conftool 12 main set log_destination csvlog 222s ok 19 - set log_destination csvlog 225s ok 20 - pg_ctlcluster 12 main restart 225s ok 21 - 12 main restart 225s ok 22 - psql -Atc "show logging_collector" 225s ok 23 - logging_collector is on 225s ok 24 - psql -Atc "show log_destination" 225s ok 25 - log_destination is csvlog 225s ok 26 - pg_lscluster reports csvlog 225s ok 27 - psql -qc "'barbaz_12_9201'" 225s ok 28 - log an error 225s ok 29 - grep --binary-files=text barbaz_12_9201 /var/lib/postgresql/12/main/log/*.csv 225s ok 30 - error appears in log/*.csv 225s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 225s ok 32 - set log_destination stderr,syslog,csvlog 225s ok 33 - pg_ctlcluster 12 main reload 225s ok 34 - 12 main reload 225s ok 35 - psql -Atc "show log_destination" 225s ok 36 - log_destination is stderr,syslog,csvlog 225s ok 37 - pg_lscluster reports stderr,syslog,csvlog 225s ok 38 - psql -qc "'moo_12_9201'" 225s ok 39 - log an error 225s ok 40 - grep --binary-files=text moo_12_9201 /var/lib/postgresql/12/main/log/*.log 225s ok 41 - error appears in log/*.log 225s ok 42 - grep --binary-files=text 'postgres.*moo_12_9201' /var/log/syslog 225s ok 43 - error appears in /var/log/syslog 225s ok 44 - grep --binary-files=text moo_12_9201 /var/lib/postgresql/12/main/log/*.csv 225s ok 45 - error appears in log/*.csv 226s ok 46 - pg_dropcluster 12 main --stop 226s ok 47 - pg_dropcluster removes cluster 226s ok 48 - Cleanup: No clusters left behind 226s ok 49 - No postgres processes left behind 226s ok 50 - No files in /etc/postgresql left behind 226s ok 51 - No files in /var/lib/postgresql left behind 226s ok 52 - No files in /var/run/postgresql left behind 226s ok 53 - No files in /var/log/postgresql left behind 226s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 226s ok 55 - PostgreSQL TCP ports are closed 226s === Running test 030_errors.t ... === 226s 1..149 226s ok 1 - pg_lscluster reports cluster without binaries 226s ok 2 - pg_dropcluster 6.3 main 227s ok 3 - pg_createcluster --socketdir 227s ok 4 - pg_lsclusters -h 227s ok 5 - cluster was created 227s ok 6 - Port of created cluster is 5432 227s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 227s ok 8 - pg_createcluster on existing cluster 227s ok 9 - pg_lsclusters -h 227s ok 10 - original cluster still exists 227s ok 11 - pg_createcluster 12 test -p foo 227s ok 12 - pg_createcluster -p checks that port option is numeric 227s ok 13 - pg_createcluster 12 test -p 42 227s ok 14 - pg_createcluster -p checks valid port range 227s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 227s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 227s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 229s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 229s ok 19 - No sockets in /var/run/postgresql 229s ok 20 - Socket is in /tmp/postgresql-testsuite/ 229s ok 21 - cluster stops with custom unix_socket_dir 229s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 231s ok 23 - cluster starts after removing unix_socket_dir 231s ok 24 - Socket is in default dir /var/run/postgresql 231s ok 25 - No sockets in /tmp/postgresql-testsuite/ 231s ok 26 - pg_ctlcluster 12 main stop 231s ok 27 - pg_ctlcluster fails with corrupted PID file 231s ok 28 - pg_lsclusters -h 231s ok 29 - cluster is still online 232s ok 30 - pg_ctlcluster succeeds with restored PID file 232s ok 31 - pg_lsclusters -h 232s ok 32 - cluster is down 232s ok 33 - pg_ctlcluster 12 main stop 232s ok 34 - pg_ctlcluster stop fails on stopped cluster 234s ok 35 - pg_ctlcluster 12 main start 234s ok 36 - pg_ctlcluster succeeds with already existing PID file 234s ok 37 - pg_lsclusters -h 234s ok 38 - cluster is online 234s ok 39 - pg_ctlcluster stop succeeds 234s ok 40 - pg_lsclusters -h 234s ok 41 - cluster is down 234s ok 42 - no pid file left 234s ok 43 - pg_ctlcluster 12 main stop 234s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 234s ok 45 - pid file was cleaned up 234s ok 46 - pg_ctlcluster --force 12 main stop 234s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 234s ok 48 - pid file was cleaned up 234s ok 49 - pg_ctlcluster 12 main stop 234s ok 50 - pg_ctlcluster stop succeeds with stale PID file 234s ok 51 - pid file was cleaned up 234s ok 52 - pg_ctlcluster --force 12 main stop 234s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 234s ok 54 - pid file was cleaned up 234s ok 55 - pg_ctlcluster --force 12 main stop 234s ok 56 - pg_ctlcluster stop succeeds with empty PID file 234s ok 57 - pid file was cleaned up 236s ok 58 - pg_ctlcluster 12 main start 236s ok 59 - pg_ctlcluster succeeds with corrupted PID file 236s ok 60 - pg_lsclusters -h 236s ok 61 - cluster is online 236s ok 62 - pg_ctlcluster 12 main start 236s ok 63 - pg_ctlcluster start fails on running cluster 236s ok 64 - pg_ctlcluster stop 237s ok 65 - pg_ctlcluster 12 main start 237s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 237s ok 67 - pg_ctlcluster 12 main stop 237s ok 68 - stopping cluster 243s ok 69 - pg_ctlcluster 12 main start 243s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 243s ok 71 - pg_ctlcluster 12 main stop 243s ok 72 - stopping cluster 243s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 243s ok 74 - pg_dropcluster 12 main 243s ok 75 - pg_dropcluster works as user postgres 244s ok 76 - pg_createcluster succeeds 244s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 244s ok 78 - proper error message for nonexisting /var/lib/postgresql 246s ok 79 - pg_ctlcluster 12 main start 246s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 246s ok 81 - pg_ctlcluster 12 main stop 246s ok 82 - stopping cluster 247s ok 83 - pg_createcluster other 249s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 251s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 251s ok 86 251s ok 87 - pg_ctlcluster 12 other start 251s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 251s ok 89 - pg_ctlcluster 12 main stop 251s ok 90 - stopping main cluster 253s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 254s ok 92 - pg_dropcluster other 254s ok 93 - pg_dropcluster 254s ok 94 - No sockets any more 254s ok 95 - 'pg_lsclusters 4.5 foo' fails 254s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 254s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 254s ok 98 - 'psql --cluster 4.5/foo' fails 254s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 254s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 254s ok 101 - 'psql --cluster 12/foo' fails 254s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 254s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 254s ok 104 - 'pg_dropcluster 4.5 foo' fails 254s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 254s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 254s ok 107 - 'pg_dropcluster 12 foo' fails 254s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 254s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 254s ok 110 - 'pg_upgradecluster 4.5 foo' fails 254s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 254s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 254s ok 113 - 'pg_upgradecluster 12 foo' fails 254s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 254s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 254s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 254s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 254s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 254s ok 119 - 'pg_ctlcluster 12 foo stop' fails 254s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 254s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 254s ok 122 - Cleanup: No clusters left behind 254s ok 123 - No postgres processes left behind 254s ok 124 - No files in /etc/postgresql left behind 254s ok 125 - No files in /var/lib/postgresql left behind 254s ok 126 - No files in /var/run/postgresql left behind 254s ok 127 - No files in /var/log/postgresql left behind 254s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 254s ok 129 - PostgreSQL TCP ports are closed 254s ok 130 - pg_dropcluster 12 broken 254s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 254s ok 132 - Cleanup: No clusters left behind 254s ok 133 - No postgres processes left behind 254s ok 134 - No files in /etc/postgresql left behind 254s ok 135 - No files in /var/lib/postgresql left behind 254s ok 136 - No files in /var/run/postgresql left behind 254s ok 137 - No files in /var/log/postgresql left behind 254s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 254s ok 139 - PostgreSQL TCP ports are closed 255s ok 140 - pg_dropcluster 12 broken 255s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 255s ok 142 - Cleanup: No clusters left behind 255s ok 143 - No postgres processes left behind 255s ok 144 - No files in /etc/postgresql left behind 255s ok 145 - No files in /var/lib/postgresql left behind 255s ok 146 - No files in /var/run/postgresql left behind 255s ok 147 - No files in /var/log/postgresql left behind 255s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 255s ok 149 - PostgreSQL TCP ports are closed 255s === Running test 031_errors_disk_full.t ... === 255s 1..22 255s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 255s ok 1 - script failed 255s ok 2 - pg_createcluster fails due to insufficient disk space 255s ok 3 - does not leave files behind 255s ok 4 - Cleanup: No clusters left behind 255s ok 5 - No postgres processes left behind 255s ok 6 - No files in /etc/postgresql left behind 255s ok 7 - No files in /var/lib/postgresql left behind 255s ok 8 - No files in /var/run/postgresql left behind 255s ok 9 - No files in /var/log/postgresql left behind 255s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 255s ok 11 - PostgreSQL TCP ports are closed 255s # check disk full conditions on startup 256s ok 12 - script failed 256s ok 13 - pg_ctlcluster prints error message 256s ok 14 - log file has error message 256s ok 15 - Cleanup: No clusters left behind 256s ok 16 - No postgres processes left behind 256s ok 17 - No files in /etc/postgresql left behind 256s ok 18 - No files in /var/lib/postgresql left behind 256s ok 19 - No files in /var/run/postgresql left behind 256s ok 20 - No files in /var/log/postgresql left behind 256s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 256s ok 22 - PostgreSQL TCP ports are closed 256s === Running test 032_ssl_key_permissions.t ... === 256s 1..22 256s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 256s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 256s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 256s # 12 (12.22-0ubuntu0.20.04.1) 256s ok 4 - pg_createcluster 12 main 257s ok 5 - pg_ctlcluster 12 main start 257s ok 6 - ssl key owned by nobody refused 257s ok 7 - pg_ctlcluster 12 main start 257s ok 8 - ssl key with permissions root:root 0644 refused 257s ok 9 - pg_ctlcluster 12 main start 257s ok 10 - ssl key with permissions postgres:postgres 0640 refused 257s ok 11 - pg_dropcluster 12 main --stop 257s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 257s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 257s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 257s ok 15 - Cleanup: No clusters left behind 257s ok 16 - No postgres processes left behind 257s ok 17 - No files in /etc/postgresql left behind 257s ok 18 - No files in /var/lib/postgresql left behind 257s ok 19 - No files in /var/run/postgresql left behind 257s ok 20 - No files in /var/log/postgresql left behind 257s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 257s ok 22 - PostgreSQL TCP ports are closed 257s === Running test 040_upgrade.t ... === 257s 1..1 257s ok 1 - only one major version installed, skipping upgrade tests 257s === Running test 041_upgrade_custompaths.t ... === 257s 1..1 257s ok 1 - only one major version installed, skipping upgrade tests 257s === Running test 043_upgrade_ssl_cert.t ... === 257s 1..1 257s ok 1 - only one major version installed, skipping upgrade tests 257s === Running test 050_encodings.t ... === 257s 1..60 257s # Checking 12 ru_RU 260s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 261s ok 2 - psql -l succeeds 261s ok 3 - template1 is not UTF-8 encoded 261s ok 4 - creating test database 261s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 261s # create table t (x varchar); copy t from stdin" test 261s ok 6 - creating table with ISO-8859-5 characters 261s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 261s ok 8 - correct string in UTF-8 261s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 261s ok 10 - correct string in ISO-8859-5 261s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 261s # delete from t; copy t from stdin" test 261s ok 12 - creating table with UTF-8 characters 261s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 261s ok 14 - correct string in UTF-8 261s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 261s ok 16 - correct string in ISO-8859-1 261s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 261s ok 18 - Server error message has correct language and encoding 264s ok 19 - pg_ctlcluster 12 ru_RU restart 264s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 264s ok 21 - Dropping cluster 264s # Checking 12 ru_RU.UTF-8 267s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 268s ok 23 - psql -l succeeds 268s ok 24 - template1 is UTF-8 encoded 268s ok 25 - creating test database 268s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 268s # create table t (x varchar); copy t from stdin" test 268s ok 27 - creating table with ISO-8859-5 characters 268s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 268s ok 29 - correct string in UTF-8 268s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 268s ok 31 - correct string in ISO-8859-5 268s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 268s # delete from t; copy t from stdin" test 268s ok 33 - creating table with UTF-8 characters 268s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 268s ok 35 - correct string in UTF-8 268s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 268s ok 37 - correct string in ISO-8859-1 268s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 268s ok 39 - Server error message has correct language and encoding 271s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 271s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 271s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 271s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 271s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 271s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 271s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 271s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 271s ok 48 - Dropping cluster 271s # Check 12 locale environment variables 274s ok 49 - pg_createcluster: LC_ALL dominates LANG 274s ok 50 - psql -Atl --cluster 12/main 274s ok 51 - template1 is ASCII encoded 274s ok 52 - Dropping cluster 274s ok 53 - Cleanup: No clusters left behind 274s ok 54 - No postgres processes left behind 274s ok 55 - No files in /etc/postgresql left behind 274s ok 56 - No files in /var/lib/postgresql left behind 274s ok 57 - No files in /var/run/postgresql left behind 274s ok 58 - No files in /var/log/postgresql left behind 274s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 274s ok 60 - PostgreSQL TCP ports are closed 274s === Running test 052_upgrade_encodings.t ... === 274s 1..1 274s ok 1 - only one major version installed, skipping upgrade tests 274s === Running test 060_obsolete_confparams.t ... === 274s 1..1 274s ok 1 - only one major version installed, skipping upgrade tests 274s === Running test 070_non_postgres_clusters.t ... === 274s 1..40 275s ok 1 - pg_createcluster 12 main for owner nobody 275s ok 2 - pg_ctlcluster 12 main start 275s ok 3 - start refused when config and data owners mismatch 277s ok 4 - pg_ctlcluster succeeds with owner nobody 277s ok 5 - pg_lsclusters -h 277s ok 6 - pg_lsclusters shows running cluster 277s ok 7 - postgres is running as user nobody 277s ok 8 - ls /tmp/.s.PGSQL.* 277s ok 9 - socket is in /tmp 277s ok 10 - /var/run/postgresql is empty 277s ok 11 - conf dir is owned by user 277s ok 12 - conf dir is owned by user's primary group 277s ok 13 - files are owned by user 277s ok 14 - files are owned by user's primary group 277s ok 15 - log file has 0640 permissions 277s ok 16 - log file is owned by user 277s ok 17 - log file is owned by user's primary group 277s ok 18 - only one major version installed, skipping upgrade test 277s ok 19 - ... 277s ok 20 - ... 277s ok 21 - ... 277s ok 22 - ... 277s ok 23 - ... 277s ok 24 - ... 277s ok 25 - ... 277s ok 26 - ... 277s ok 27 - ... 277s ok 28 - ... 278s ok 29 - pg_dropcluster 278s ok 30 - pg_lsclusters -h 278s ok 31 - No clusters left 278s ok 32 - No postgres processes left 278s ok 33 - Cleanup: No clusters left behind 278s ok 34 - No postgres processes left behind 278s ok 35 - No files in /etc/postgresql left behind 278s ok 36 - No files in /var/lib/postgresql left behind 278s ok 37 - No files in /var/run/postgresql left behind 278s ok 38 - No files in /var/log/postgresql left behind 278s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 278s ok 40 - PostgreSQL TCP ports are closed 278s === Running test 080_start.conf.t ... === 278s 1..73 278s ok 1 - pg_createcluster 12 main 278s # start.conf auto 278s ok 2 - get_cluster_start_conf returns auto 278s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 278s ok 4 - start.conf contains auto 278s ok 5 - systemd generator links cluster 278s ok 6 - systemd generator links correct service file 280s ok 7 - /etc/init.d/postgresql start 12 280s ok 8 - correct output of /etc/init.d/postgresql start 12 280s ok 9 - pg_lsclusters -h 280s ok 10 - cluster is online 280s ok 11 - /etc/init.d/postgresql stop 12 280s ok 12 - correct output of /etc/init.d/postgresql stop 12 284s ok 13 - pg_lsclusters -h 284s ok 14 - cluster is down 284s # start.conf manual 284s ok 15 - get_cluster_start_conf returns manual 284s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 284s ok 17 - start.conf contains manual 284s ok 18 - systemd generator doesn't link cluster 284s ok 19 - /etc/init.d/postgresql start 12 284s ok 20 - correct output of /etc/init.d/postgresql start 12 284s ok 21 - pg_lsclusters -h 284s ok 22 - cluster is down 286s ok 23 - pg_ctlcluster 12 main start 286s ok 24 - correct output of pg_ctlcluster 12 main start 286s ok 25 - pg_lsclusters -h 286s ok 26 - cluster is online 286s ok 27 - pg_ctlcluster 12 main stop 286s ok 28 - correct output of pg_ctlcluster 12 main stop 286s ok 29 - pg_lsclusters -h 286s ok 30 - cluster is down 286s # start.conf disabled 286s ok 31 - get_cluster_start_conf returns disabled 286s ok 32 - systemd generator doesn't link cluster 286s ok 33 - /etc/init.d/postgresql start 12 286s ok 34 - correct output of /etc/init.d/postgresql start 12 286s ok 35 - pg_lsclusters -h 286s ok 36 - cluster is down 286s ok 37 - pg_ctlcluster 12 main start 286s ok 38 - correct output of pg_ctlcluster 12 main start 286s ok 39 - pg_lsclusters -h 286s ok 40 - cluster is down 288s ok 41 - pg_ctlcluster 12 main start 288s ok 42 - correct output of pg_ctlcluster 12 main start 289s ok 43 - pg_lsclusters -h 289s ok 44 - cluster is online 289s ok 45 - pg_ctlcluster 12 main stop 289s ok 46 - correct output of pg_ctlcluster 12 main stop 289s ok 47 - pg_lsclusters -h 289s ok 48 - cluster is down 291s ok 49 - pg_ctlcluster 12 main start 291s ok 50 - correct output of pg_ctlcluster 12 main start 291s ok 51 - pg_lsclusters -h 291s ok 52 - cluster is online 291s # test upgrade 291s ok 53 - only one major version installed, skipping upgrade test 291s ok 54 - ... 291s ok 55 - get_cluster_start_conf for old cluster returns manual 291s ok 56 - get_cluster_start_conf for new cluster returns manual 291s ok 57 - ... 291s ok 58 - dropping upgraded cluster 291s ok 59 - pg_lsclusters -h 291s ok 60 - no clusters any more 291s ok 61 - pg_createcluster 12 main --start-conf foo 291s ok 62 - pg_createcluster checks --start-conf validity 292s ok 63 - pg_createcluster checks --start-conf manual 292s ok 64 - get_cluster_start_conf returns manual 292s ok 65 - dropping cluster 292s ok 66 - Cleanup: No clusters left behind 292s ok 67 - No postgres processes left behind 292s ok 68 - No files in /etc/postgresql left behind 292s ok 69 - No files in /var/lib/postgresql left behind 292s ok 70 - No files in /var/run/postgresql left behind 292s ok 71 - No files in /var/log/postgresql left behind 292s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 292s ok 73 - PostgreSQL TCP ports are closed 292s === Running test 085_pg_ctl.conf.t ... === 292s 1..29 292s ok 1 - pg_createcluster 12 main 292s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 295s ok 3 - pg_ctlcluster 12 main start 295s ok 4 - starting cluster 295s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 295s ok 6 - soft core size is 0 295s ok 7 - set pg_ctl default option to -c 297s ok 8 - pg_ctlcluster 12 main restart 297s ok 9 - restarting cluster 297s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 297s ok 11 - soft core size is unlimited 297s ok 12 - restored pg_ctl default option 299s ok 13 - pg_ctlcluster 12 main restart 299s ok 14 - restarting cluster 299s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 299s ok 16 - soft core size is 0 301s ok 17 - pg_ctlcluster 12 main restart -- -c 301s ok 18 - restarting cluster with -c on the command line 301s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 301s ok 20 - soft core size is unlimited 302s ok 21 - dropping cluster 302s ok 22 - Cleanup: No clusters left behind 302s ok 23 - No postgres processes left behind 302s ok 24 - No files in /etc/postgresql left behind 302s ok 25 - No files in /var/lib/postgresql left behind 302s ok 26 - No files in /var/run/postgresql left behind 302s ok 27 - No files in /var/log/postgresql left behind 302s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 302s ok 29 - PostgreSQL TCP ports are closed 302s === Running test 090_multicluster.t ... === 302s 1..125 302s ok 1 - pg_createcluster 12 old 303s ok 2 - pg_createcluster 12 new1 304s ok 3 - pg_createcluster 12 new2 306s ok 4 - starting cluster 12/old 308s ok 5 - starting cluster 12/new1 310s ok 6 - starting cluster 12/new2 310s ok 7 - pg_lsclusters -h | sort -k3 310s ok 8 - clusters have the correct ports, skipping used 5433 310s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 310s ok 10 - createdb --version 310s ok 11 - pg_wrapper selects port 5432 as default cluster 310s ok 12 - createdb --cluster 12/new1 --version 310s ok 13 - pg_wrapper --cluster works 310s ok 14 - createdb --cluster 12/foo --version 310s ok 15 - pg_wrapper --cluster errors out for invalid cluster 310s ok 16 - createdb --cluster 12/new1 test 310s ok 17 - correct output of createdb --cluster 12/new1 test 310s ok 18 - psql -Atl --cluster 12/new1 310s ok 19 - test db appears in cluster new1 310s ok 20 - psql -Atl --cluster 12/new2 310s ok 21 - test db does not appear in cluster new2 310s ok 22 - psql -Atl 310s ok 23 - test db does not appear in default cluster 310s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 310s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 311s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 311s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 311s ok 28 - psql -Atl --cluster 12/localhost:5434 311s ok 29 - test db appears in cluster 12/localhost:5434 311s ok 30 - psql -Atl --cluster 12/localhost:5440 311s ok 31 - test db does not appear in cluster 12/localhost:5440 311s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 311s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 311s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 311s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 311s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 311s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 311s ok 38 - psql -Atl --cluster 6.4/localhost: 311s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 311s ok 40 - psql -Atl 311s ok 41 - PGCLUSTER selection (1) 311s ok 42 - psql -Atl 311s ok 43 - PGCLUSTER selection (2) 311s ok 44 - psql -l 311s ok 45 - invalid PGCLUSTER value 311s ok 46 - createdb --version 311s ok 47 - PGCLUSTER network cluster selection (1) 311s ok 48 - psql -Atl 311s ok 49 - PGCLUSTER network cluster selection (2) 311s ok 50 - psql -Atl 311s ok 51 - PGCLUSTER network cluster selection (3) 311s ok 52 - LC_MESSAGES=C psql -Atl 311s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 311s ok 54 - psql -Atc "show port" template1 311s ok 55 - PGPORT selection (1) 311s ok 56 - psql -Atc "show port" template1 311s ok 57 - PGPORT selection (2) 311s ok 58 - createdb --version 311s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 311s ok 60 - psql -Atc "show port" template1 311s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 311s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 311s ok 63 - PGDATABASE environment variable works 311s ok 64 - createdb --version 311s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 311s ok 66 - createdb --cluster 12/new1 --version 311s ok 67 - pg_wrapper --cluster works with empty user_clusters 311s ok 68 - createdb --version 311s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 311s ok 70 - psql -Atc "select current_database()" 311s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 311s ok 72 - psql -Atc 'select current_database()' 311s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 311s ok 74 - createdb --version 311s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 311s ok 76 - createdb --version 311s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 311s ok 78 - createdb --version 311s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 311s ok 80 - createdb --version 311s ok 81 - pg_wrapper selects correct version with per-user user_clusters 311s ok 82 - createdb --version 311s ok 83 - pg_wrapper selects correct version with per-user user_clusters 311s ok 84 - createdb --version 311s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 311s ok 86 - psql -Atl 311s ok 87 - $PGHOST overrides user_clusters 311s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 311s ok 89 - --cluster overrides $PGHOST 311s ok 90 - createdb --version 311s ok 91 - pg_wrapper ignores invalid lines in user_clusters 311s ok 92 - psql -Atc 'select current_database()' 311s ok 93 - pg_service conf selection 1 311s ok 94 - psql -Atc 'select current_database()' 311s ok 95 - pg_service conf selection 2 311s ok 96 - psql -Atc 'select current_database()' 311s ok 97 - pg_service conf selection 3 312s ok 98 - stopping cluster 12/old 314s ok 99 - restarting cluster 12/old 314s ok 100 - pg_lsclusters -h | sort -k3 314s ok 101 - port of first cluster was successfully changed 314s ok 102 - psql -l 314s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 314s ok 104 - psql -Atl --cluster 12/new1 314s ok 105 - --cluster selects appropriate cluster 314s ok 106 - psql -Atl -p 5434 314s ok 107 - -p selects appropriate cluster 314s ok 108 - psql -Atlp 5434 314s ok 109 - -Atlp selects appropriate cluster 314s ok 110 - psql -Atl --port 5434 314s ok 111 - --port selects appropriate cluster 314s ok 112 - env PGPORT=5434 psql -Atl 314s ok 113 - $PGPORT selects appropriate cluster 314s ok 114 - Restoring original /etc/postgresql-common/user_clusters 314s ok 115 - dropping 12/new1 315s ok 116 - dropping 12/new2 315s ok 117 - dropping 12/old 315s ok 118 - Cleanup: No clusters left behind 315s ok 119 - No postgres processes left behind 315s ok 120 - No files in /etc/postgresql left behind 315s ok 121 - No files in /var/lib/postgresql left behind 315s ok 122 - No files in /var/run/postgresql left behind 315s ok 123 - No files in /var/log/postgresql left behind 315s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 315s ok 125 - PostgreSQL TCP ports are closed 315s === Running test 100_upgrade_scripts.t ... === 315s 1..27 318s ok 1 - pg_createcluster 12 main 318s ok 2 - createdb --cluster 12/main db1 318s ok 3 - correct output of createdb --cluster 12/main db1 318s ok 4 - createdb --cluster 12/main db2 318s ok 5 - correct output of createdb --cluster 12/main db2 318s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 318s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 318s ok 8 - get_cluster_databases() works 318s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 319s ok 10 - run-upgrade-scripts succeeds 319s ok 11 - correct run-upgrade-script output 319s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 319s ok 13 - check SQL scripts results in 12/main db1 319s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 319s ok 15 - check SQL scripts results in 12/main db2 319s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 319s ok 17 - check shell scripts results in $v/main 319s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 320s ok 19 - pg_dropcluster 12 main 320s ok 20 - Cleanup: No clusters left behind 320s ok 21 - No postgres processes left behind 320s ok 22 - No files in /etc/postgresql left behind 320s ok 23 - No files in /var/lib/postgresql left behind 320s ok 24 - No files in /var/run/postgresql left behind 320s ok 25 - No files in /var/log/postgresql left behind 320s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 320s ok 27 - PostgreSQL TCP ports are closed 320s === Running test 110_integrate_cluster.t ... === 320s 1..32 320s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/PlL2ZJW9n8/c/postgres 320s ok 2 - creating raw initdb cluster for user postgres 321s ok 3 - pg_createcluster 12 postgres -d /tmp/PlL2ZJW9n8/c/postgres 321s ok 4 - integrating postgres cluster 321s ok 5 - pg_lsclusters 321s ok 6 - correct pg_lsclusters output 323s ok 7 - pg_ctlcluster 12 postgres start 323s ok 8 - starting cluster postgres 323s ok 9 - pg_lsclusters 323s ok 10 - correct pg_lsclusters output 323s ok 11 - dropping cluster postgres 323s ok 12 - No files in temporary cluster dir left behind 324s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/PlL2ZJW9n8/c/nobody 324s ok 14 - creating raw initdb cluster for user nobody 324s ok 15 - pg_createcluster 12 nobody -d /tmp/PlL2ZJW9n8/c/nobody 324s ok 16 - integrating nobody cluster 324s ok 17 - pg_lsclusters 324s ok 18 - correct pg_lsclusters output 326s ok 19 - pg_ctlcluster 12 nobody start 326s ok 20 - starting cluster nobody 326s ok 21 - pg_lsclusters 326s ok 22 - correct pg_lsclusters output 326s ok 23 - dropping cluster nobody 326s ok 24 - No files in temporary cluster dir left behind 326s ok 25 - Cleanup: No clusters left behind 326s ok 26 - No postgres processes left behind 326s ok 27 - No files in /etc/postgresql left behind 326s ok 28 - No files in /var/lib/postgresql left behind 326s ok 29 - No files in /var/run/postgresql left behind 326s ok 30 - No files in /var/log/postgresql left behind 326s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 326s ok 32 - PostgreSQL TCP ports are closed 326s === Running test 120_pg_upgradecluster_scripts.t ... === 326s 1..1 327s ok 1 - only one major version installed, skipping upgrade tests 327s === Running test 130_nonroot_admin.t ... === 327s 1..22 329s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 329s ok 2 - pg_lsclusters -h 329s ok 3 - correct output of pg_lsclusters -h 329s ok 4 - psql -Atl 329s ok 5 - correct output of psql -Atl 329s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 329s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 329s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 330s ok 15 - Cleanup: No clusters left behind 330s ok 16 - No postgres processes left behind 330s ok 17 - No files in /etc/postgresql left behind 330s ok 18 - No files in /var/lib/postgresql left behind 330s ok 19 - No files in /var/run/postgresql left behind 330s ok 20 - No files in /var/log/postgresql left behind 330s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 330s ok 22 - PostgreSQL TCP ports are closed 330s === Running test 135_pg_virtualenv.t ... === 330s 1..20 333s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 333s ok 2 - running pg_virtualenv as root 336s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 336s ok 4 - running pg_virtualenv as postgres 339s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 339s ok 6 - running pg_virtualenv as nobody 339s ok 7 # skip /usr/bin/fakeroot not available 339s ok 8 # skip /usr/bin/fakeroot not available 339s ok 9 # skip /usr/bin/fakeroot not available 339s ok 10 # skip /usr/bin/fakeroot not available 339s ok 11 # skip /usr/bin/fakeroot not available 339s ok 12 # skip /usr/bin/fakeroot not available 339s ok 13 - Cleanup: No clusters left behind 339s ok 14 - No postgres processes left behind 339s ok 15 - No files in /etc/postgresql left behind 339s ok 16 - No files in /var/lib/postgresql left behind 339s ok 17 - No files in /var/run/postgresql left behind 339s ok 18 - No files in /var/log/postgresql left behind 339s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 339s ok 20 - PostgreSQL TCP ports are closed 339s === Running test 140_pg_config.t ... === 339s 1..38 339s # Multiarch is enabled 339s # checking version specific output for 12 339s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 339s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 339s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 339s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 339s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 339s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 339s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 339s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 339s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 339s # checking pg_config output (should behave like version 12) 339s ok 15 - pg_config 339s ok 16 - correct output of pg_config 339s ok 17 - pg_config --help 339s ok 18 - correct output of pg_config --help 339s ok 19 - pg_config --pgxs 339s ok 20 - correct output of pg_config --pgxs 339s ok 21 - pg_config --libdir 339s ok 22 - correct output of pg_config --libdir 339s ok 23 - pg_config --pkglibdir 339s ok 24 - correct output of pg_config --pkglibdir 339s ok 25 - pg_config --bindir 339s ok 26 - correct output of pg_config --bindir 339s # checking pg_config.libpq-dev output (should behave like version 12) 339s ok 27 - pg_config.libpq-dev 339s ok 28 - correct output of pg_config.libpq-dev 339s ok 29 - pg_config.libpq-dev --help 339s ok 30 - correct output of pg_config.libpq-dev --help 339s ok 31 - pg_config.libpq-dev --pgxs 339s ok 32 - correct output of pg_config.libpq-dev --pgxs 339s ok 33 - pg_config.libpq-dev --libdir 339s ok 34 - correct output of pg_config.libpq-dev --libdir 339s ok 35 - pg_config.libpq-dev --pkglibdir 339s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 339s ok 37 - pg_config.libpq-dev --bindir 339s ok 38 - correct output of pg_config.libpq-dev --bindir 339s === Running test 150_tsearch_stemming.t ... === 339s 1..37 339s ok 1 - pg_updatedicts succeeded 339s ok 2 - pg_updatedicts created en_us.affix 339s ok 3 - pg_updatedicts created en_us.dict 339s ok 4 - pg_updatedicts created 12 en_us.affix symlink 339s ok 5 - pg_updatedicts created 12 en_us.dict symlink 342s ok 6 - pg_createcluster 12 main 342s ok 7 - createdb fts 342s ok 8 - correct output of createdb fts 342s ok 9 - creating en_US full text search configuration 342s ok 10 - creating data table and search index 342s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 342s ok 12 - stem search of correct word 342s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 342s ok 14 - stem search of correct word 342s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 342s ok 16 - stem search of unknown word 342s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 342s ok 18 - full text search, exact word 342s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 342s ok 20 - full text search for word stem 342s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 342s ok 22 - full text search for word substring fails 342s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 342s ok 24 - full text search, exact unicode word 342s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 342s ok 26 - full text search for unicode word stem 342s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 342s ok 28 - full text search for unicode word substring fails 343s ok 29 343s ok 30 - Cleanup: No clusters left behind 343s ok 31 - No postgres processes left behind 343s ok 32 - No files in /etc/postgresql left behind 343s ok 33 - No files in /var/lib/postgresql left behind 343s ok 34 - No files in /var/run/postgresql left behind 343s ok 35 - No files in /var/log/postgresql left behind 343s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 343s ok 37 - PostgreSQL TCP ports are closed 343s === Running test 160_alternate_confroot.t ... === 343s 1..28 346s ok 1 346s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 346s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 346s ok 4 - pg_lsclusters -h 346s ok 5 - correct output of pg_lsclusters -h 346s ok 6 - psql -Atl 346s ok 7 - correct output of psql -Atl 346s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 346s ok 9 - ... 346s ok 10 - ... 346s ok 11 - ... 346s ok 12 - ... 346s ok 13 - ... 346s ok 14 - ... 346s ok 15 - pg_dropcluster 12 test --stop 346s ok 16 - correct output of pg_dropcluster 12 test --stop 346s ok 17 - pg_lsclusters -h 346s ok 18 - correct output of pg_lsclusters -h 346s ok 19 - No files in root/data left behind 346s ok 20 - No cruft in root dir left behind 346s ok 21 - Cleanup: No clusters left behind 346s ok 22 - No postgres processes left behind 346s ok 23 - No files in /etc/postgresql left behind 346s ok 24 - No files in /var/lib/postgresql left behind 346s ok 25 - No files in /var/run/postgresql left behind 346s ok 26 - No files in /var/log/postgresql left behind 346s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 346s ok 28 - PostgreSQL TCP ports are closed 346s === Running test 170_extensions.t ... === 346s # Running tests for 12 349s ok 1 - pg_createcluster 12 main 349s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 349s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 349s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 349s ok 5 - extension adminpack installs without error 349s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 349s ok 7 - extension adminpack removes without error 349s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 349s ok 9 - extension amcheck installs without error 349s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 349s ok 11 - extension amcheck removes without error 349s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 349s ok 13 - extension autoinc installs without error 349s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 349s ok 15 - extension autoinc removes without error 349s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 349s ok 17 - extension bloom installs without error 349s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 349s ok 19 - extension bloom removes without error 349s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 349s ok 21 - extension btree_gin installs without error 349s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 349s ok 23 - extension btree_gin removes without error 349s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 349s ok 25 - extension btree_gist installs without error 349s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 349s ok 27 - extension btree_gist removes without error 349s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 349s ok 29 - extension citext installs without error 349s ok 30 - psql -qc 'DROP EXTENSION "citext"' 349s ok 31 - extension citext removes without error 349s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 349s ok 33 - extension cube installs without error 349s ok 34 - psql -qc 'DROP EXTENSION "cube"' 349s ok 35 - extension cube removes without error 349s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 349s ok 37 - extension dblink installs without error 349s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 349s ok 39 - extension dblink removes without error 350s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 350s ok 41 - extension dict_int installs without error 350s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 350s ok 43 - extension dict_int removes without error 350s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 350s ok 45 - extension dict_xsyn installs without error 350s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 350s ok 47 - extension dict_xsyn removes without error 350s ok 48 - psql -qc 'CREATE EXTENSION cube' 350s ok 49 - earthdistance dependency cube installs without error 350s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 350s ok 51 - extension earthdistance installs without error 350s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 350s ok 53 - extension earthdistance removes without error 350s ok 54 - psql -qc 'DROP EXTENSION cube' 350s ok 55 - earthdistance dependency extension cube removes without error 350s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 350s ok 57 - extension file_fdw installs without error 350s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 350s ok 59 - extension file_fdw removes without error 350s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 350s ok 61 - extension fuzzystrmatch installs without error 350s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 350s ok 63 - extension fuzzystrmatch removes without error 350s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 350s ok 65 - extension hstore installs without error 350s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 350s ok 67 - extension hstore removes without error 350s ok 68 - psql -qc 'CREATE EXTENSION hstore' 350s ok 69 - hstore_plperl dependency hstore installs without error 350s ok 70 - psql -qc 'CREATE EXTENSION plperl' 350s ok 71 - hstore_plperl dependency plperl installs without error 350s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 350s ok 73 - extension hstore_plperl installs without error 350s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 350s ok 75 - extension hstore_plperl removes without error 350s ok 76 - psql -qc 'DROP EXTENSION hstore' 350s ok 77 - hstore_plperl dependency extension hstore removes without error 350s ok 78 - psql -qc 'DROP EXTENSION plperl' 350s ok 79 - hstore_plperl dependency extension plperl removes without error 350s ok 80 - psql -qc 'CREATE EXTENSION hstore' 350s ok 81 - hstore_plperlu dependency hstore installs without error 350s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 350s ok 83 - hstore_plperlu dependency plperlu installs without error 350s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 350s ok 85 - extension hstore_plperlu installs without error 350s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 350s ok 87 - extension hstore_plperlu removes without error 350s ok 88 - psql -qc 'DROP EXTENSION hstore' 350s ok 89 - hstore_plperlu dependency extension hstore removes without error 350s ok 90 - psql -qc 'DROP EXTENSION plperlu' 350s ok 91 - hstore_plperlu dependency extension plperlu removes without error 350s ok 92 - psql -qc 'CREATE EXTENSION hstore' 350s ok 93 - hstore_plpython3u dependency hstore installs without error 350s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 350s ok 95 - hstore_plpython3u dependency plpython3u installs without error 350s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 350s ok 97 - extension hstore_plpython3u installs without error 350s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 350s ok 99 - extension hstore_plpython3u removes without error 350s ok 100 - psql -qc 'DROP EXTENSION hstore' 350s ok 101 - hstore_plpython3u dependency extension hstore removes without error 350s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 350s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 351s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 351s ok 105 - extension insert_username installs without error 351s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 351s ok 107 - extension insert_username removes without error 351s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 351s ok 109 - extension intagg installs without error 351s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 351s ok 111 - extension intagg removes without error 351s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 351s ok 113 - extension intarray installs without error 351s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 351s ok 115 - extension intarray removes without error 351s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 351s ok 117 - extension isn installs without error 351s ok 118 - psql -qc 'DROP EXTENSION "isn"' 351s ok 119 - extension isn removes without error 351s ok 120 - psql -qc 'CREATE EXTENSION plperl' 351s ok 121 - jsonb_plperl dependency plperl installs without error 351s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 351s ok 123 - extension jsonb_plperl installs without error 351s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 351s ok 125 - extension jsonb_plperl removes without error 351s ok 126 - psql -qc 'DROP EXTENSION plperl' 351s ok 127 - jsonb_plperl dependency extension plperl removes without error 351s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 351s ok 129 - jsonb_plperlu dependency plperlu installs without error 351s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 351s ok 131 - extension jsonb_plperlu installs without error 351s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 351s ok 133 - extension jsonb_plperlu removes without error 351s ok 134 - psql -qc 'DROP EXTENSION plperlu' 351s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 351s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 351s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 351s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 351s ok 139 - extension jsonb_plpython3u installs without error 351s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 351s ok 141 - extension jsonb_plpython3u removes without error 351s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 351s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 351s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 351s ok 145 - extension lo installs without error 351s ok 146 - psql -qc 'DROP EXTENSION "lo"' 351s ok 147 - extension lo removes without error 351s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 351s ok 149 - extension ltree installs without error 351s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 351s ok 151 - extension ltree removes without error 351s ok 152 - psql -qc 'CREATE EXTENSION ltree' 351s ok 153 - ltree_plpython3u dependency ltree installs without error 351s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 351s ok 155 - ltree_plpython3u dependency plpython3u installs without error 351s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 351s ok 157 - extension ltree_plpython3u installs without error 351s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 351s ok 159 - extension ltree_plpython3u removes without error 351s ok 160 - psql -qc 'DROP EXTENSION ltree' 351s ok 161 - ltree_plpython3u dependency extension ltree removes without error 351s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 351s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 352s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 352s ok 165 - extension moddatetime installs without error 352s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 352s ok 167 - extension moddatetime removes without error 352s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 352s ok 169 - extension pageinspect installs without error 352s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 352s ok 171 - extension pageinspect removes without error 352s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 352s ok 173 - extension pg_buffercache installs without error 352s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 352s ok 175 - extension pg_buffercache removes without error 352s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 352s ok 177 - extension pg_freespacemap installs without error 352s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 352s ok 179 - extension pg_freespacemap removes without error 352s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 352s ok 181 - extension pg_prewarm installs without error 352s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 352s ok 183 - extension pg_prewarm removes without error 352s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 352s ok 185 - extension pg_stat_statements installs without error 352s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 352s ok 187 - extension pg_stat_statements removes without error 352s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 352s ok 189 - extension pg_trgm installs without error 352s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 352s ok 191 - extension pg_trgm removes without error 352s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 352s ok 193 - extension pg_visibility installs without error 352s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 352s ok 195 - extension pg_visibility removes without error 352s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 352s ok 197 - extension pgcrypto installs without error 352s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 352s ok 199 - extension pgcrypto removes without error 352s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 352s ok 201 - extension pgrowlocks installs without error 352s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 352s ok 203 - extension pgrowlocks removes without error 352s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 352s ok 205 - extension pgstattuple installs without error 352s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 352s ok 207 - extension pgstattuple removes without error 352s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 352s ok 209 - extension plperl installs without error 352s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 352s ok 211 - extension plperl removes without error 352s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 352s ok 213 - extension plperlu installs without error 352s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 352s ok 215 - extension plperlu removes without error 352s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 352s ok 217 - extension plpython3u installs without error 352s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 352s ok 219 - extension plpython3u removes without error 352s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 352s ok 221 - extension pltcl installs without error 352s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 352s ok 223 - extension pltcl removes without error 352s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 352s ok 225 - extension pltclu installs without error 352s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 352s ok 227 - extension pltclu removes without error 353s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 353s ok 229 - extension postgres_fdw installs without error 353s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 353s ok 231 - extension postgres_fdw removes without error 353s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 353s ok 233 - extension refint installs without error 353s ok 234 - psql -qc 'DROP EXTENSION "refint"' 353s ok 235 - extension refint removes without error 353s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 353s ok 237 - extension seg installs without error 353s ok 238 - psql -qc 'DROP EXTENSION "seg"' 353s ok 239 - extension seg removes without error 353s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 353s ok 241 - extension sslinfo installs without error 353s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 353s ok 243 - extension sslinfo removes without error 353s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 353s ok 245 - extension tablefunc installs without error 353s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 353s ok 247 - extension tablefunc removes without error 353s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 353s ok 249 - extension tcn installs without error 353s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 353s ok 251 - extension tcn removes without error 353s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 353s ok 253 - extension tsm_system_rows installs without error 353s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 353s ok 255 - extension tsm_system_rows removes without error 353s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 353s ok 257 - extension tsm_system_time installs without error 353s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 353s ok 259 - extension tsm_system_time removes without error 353s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 353s ok 261 - extension unaccent installs without error 353s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 353s ok 263 - extension unaccent removes without error 353s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 353s ok 265 - extension uuid-ossp installs without error 353s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 353s ok 267 - extension uuid-ossp removes without error 353s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 353s ok 269 - extension xml2 installs without error 353s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 353s ok 271 - extension xml2 removes without error 354s ok 272 - pg_dropcluster 12 main 354s ok 273 - Cleanup: No clusters left behind 354s ok 274 - No postgres processes left behind 354s ok 275 - No files in /etc/postgresql left behind 354s ok 276 - No files in /var/lib/postgresql left behind 354s ok 277 - No files in /var/run/postgresql left behind 354s ok 278 - No files in /var/log/postgresql left behind 354s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 354s ok 280 - PostgreSQL TCP ports are closed 354s 1..280 354s === Running test 180_ecpg.t ... === 354s 1..17 354s ok 1 - ecpg test.pgc 354s ok 2 - ecpg processing 354s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 354s ok 4 - compiling ecpg output 357s ok 5 - pg_createcluster 12 main 357s ok 6 - createuser nobody 357s # Failed test 'runs and gives correct output' 357s # at t/TestLib.pm line 201. 357s # got: ' 357s # ' 357s # expected: 'template1 357s # ' 357s ok 7 - /tmp/tmp.XQk8ro8RlP/test 357s not ok 8 - runs and gives correct output 357s ok 9 - pg_dropcluster 12 main 357s ok 10 - Cleanup: No clusters left behind 357s ok 11 - No postgres processes left behind 357s ok 12 - No files in /etc/postgresql left behind 357s ok 13 - No files in /var/lib/postgresql left behind 357s ok 14 - No files in /var/run/postgresql left behind 357s ok 15 - No files in /var/log/postgresql left behind 357s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 357s ok 17 - PostgreSQL TCP ports are closed 357s # Looks like you failed 1 test of 17. 358s autopkgtest [13:21:52]: test run-testsuite: -----------------------] 358s autopkgtest [13:21:52]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 358s run-testsuite FAIL non-zero exit status 1 358s autopkgtest [13:21:52]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 358s # Failed test 'runs and gives correct output' 358s # at t/TestLib.pm line 201. 358s # got: ' 358s # ' 358s # expected: 'template1 358s # ' 358s # Looks like you failed 1 test of 17. 359s autopkgtest [13:21:53]: test installcheck: preparing testbed 435s autopkgtest [13:23:09]: testbed dpkg architecture: s390x 435s autopkgtest [13:23:09]: testbed apt version: 2.0.10 435s autopkgtest [13:23:09]: @@@@@@@@@@@@@@@@@@@@ test bed setup 435s autopkgtest [13:23:09]: testbed release detected to be: focal 436s autopkgtest [13:23:10]: updating testbed package index (apt update) 436s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 436s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 437s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 437s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 437s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 437s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 437s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 437s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 437s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main s390x Packages [142 kB] 437s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main s390x c-n-f Metadata [1432 B] 437s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x Packages [1872 B] 437s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x c-n-f Metadata [116 B] 437s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x Packages [36.5 kB] 437s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x c-n-f Metadata [1648 B] 437s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x Packages [952 B] 437s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x c-n-f Metadata [116 B] 439s Fetched 565 kB in 1s (531 kB/s) 440s Reading package lists... 440s + lsb_release --codename --short 440s + RELEASE=focal 440s + cat 440s + [ focal != trusty ] 440s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 440s Reading package lists... 441s Building dependency tree... 441s Reading state information... 441s Calculating upgrade... 441s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 441s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 441s + /usr/lib/apt/apt-helper analyze-pattern ?true 441s + uname -r 441s + sed s/\./\\./g 441s + running_kernel_pattern=^linux-.*5\.4\.0-208-generic.* 441s + apt list ?obsolete 441s + tail -n+2 441s + cut -d/ -f1 441s + grep -v ^linux-.*5\.4\.0-208-generic.* 441s + true 441s + obsolete_pkgs= 441s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 441s Reading package lists... 441s Building dependency tree... 441s Reading state information... 441s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 441s + grep -q trusty /etc/lsb-release 441s + [ ! -d /usr/share/doc/unattended-upgrades ] 441s + [ ! -d /usr/share/doc/lxd ] 441s + [ ! -d /usr/share/doc/lxd-client ] 441s + [ ! -d /usr/share/doc/snapd ] 441s + type iptables 441s + cat 441s + chmod 755 /etc/rc.local 441s + . /etc/rc.local 441s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 441s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 441s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 441s + uname -m 441s + [ s390x = ppc64le ] 441s + [ -d /run/systemd/system ] 441s + systemd-detect-virt --quiet --vm 441s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 441s + cat 441s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 441s + echo COMPRESS=lz4 441s autopkgtest [13:23:15]: upgrading testbed (apt dist-upgrade and autopurge) 441s Reading package lists... 441s Building dependency tree... 441s Reading state information... 441s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 442s Starting 2 pkgProblemResolver with broken count: 0 442s Done 442s 442s The following packages will be upgraded: 442s tzdata 442s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 442s Need to get 300 kB of archives. 442s After this operation, 3072 B of additional disk space will be used. 442s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main s390x tzdata all 2025a-0ubuntu0.20.04 [300 kB] 442s Preconfiguring packages ... 442s Fetched 300 kB in 0s (623 kB/s) 442s (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 ... 71285 files and directories currently installed.) 442s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 442s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 443s Setting up tzdata (2025a-0ubuntu0.20.04) ... 443s 443s Current default time zone: 'Etc/UTC' 443s Local time is now: Wed Feb 26 13:24:42 UTC 2025. 443s Universal Time is now: Wed Feb 26 13:24:42 UTC 2025. 443s Run 'dpkg-reconfigure tzdata' if you wish to change it. 443s 443s Reading package lists... 443s Building dependency tree... 443s Reading state information... 443s Starting pkgProblemResolver with broken count: 0 443s Starting 2 pkgProblemResolver with broken count: 0 443s Done 443s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 446s Reading package lists... 446s Building dependency tree... 446s Reading state information... 446s Starting pkgProblemResolver with broken count: 0 446s Starting 2 pkgProblemResolver with broken count: 0 446s Done 446s The following NEW packages will be installed: 446s build-essential cpp cpp-9 g++ g++-9 gcc gcc-9 gcc-9-base libasan5 libatomic1 446s libc-dev-bin libc6-dev libcc1-0 libcrypt-dev libecpg-compat3 libecpg-dev 446s libecpg6 libgcc-9-dev libgomp1 libisl22 libitm1 libmpc3 libpgtypes3 446s libpq-dev libpq5 libpython3.8 libstdc++-9-dev libtcl8.6 libubsan1 libxslt1.1 446s linux-libc-dev postgresql-12 postgresql-client-12 postgresql-client-common 446s postgresql-common postgresql-doc-12 postgresql-plperl-12 446s postgresql-plpython3-12 postgresql-pltcl-12 postgresql-server-dev-12 446s ssl-cert 446s 0 upgraded, 41 newly installed, 0 to remove and 0 not upgraded. 446s Need to get 39.7 MB of archives. 446s After this operation, 192 MB of additional disk space will be used. 446s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc-dev-bin s390x 2.31-0ubuntu9.17 [63.2 kB] 446s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main s390x linux-libc-dev s390x 5.4.0-208.228 [1117 kB] 447s Get:3 http://ftpmaster.internal/ubuntu focal/main s390x libcrypt-dev s390x 1:4.4.10-10ubuntu4 [107 kB] 447s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc6-dev s390x 2.31-0ubuntu9.17 [2023 kB] 448s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9-base s390x 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 448s Get:6 http://ftpmaster.internal/ubuntu focal/main s390x libisl22 s390x 0.22.1-1 [545 kB] 448s Get:7 http://ftpmaster.internal/ubuntu focal/main s390x libmpc3 s390x 1.1.0-1 [38.3 kB] 448s Get:8 http://ftpmaster.internal/ubuntu focal-updates/main s390x cpp-9 s390x 9.4.0-1ubuntu1~20.04.2 [5727 kB] 449s Get:9 http://ftpmaster.internal/ubuntu focal/main s390x cpp s390x 4:9.3.0-1ubuntu2 [27.6 kB] 449s Get:10 http://ftpmaster.internal/ubuntu focal-updates/main s390x libcc1-0 s390x 10.5.0-1ubuntu1~20.04 [45.0 kB] 449s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgomp1 s390x 10.5.0-1ubuntu1~20.04 [95.0 kB] 449s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main s390x libitm1 s390x 10.5.0-1ubuntu1~20.04 [25.4 kB] 449s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main s390x libatomic1 s390x 10.5.0-1ubuntu1~20.04 [8524 B] 449s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main s390x libasan5 s390x 9.4.0-1ubuntu1~20.04.2 [2556 kB] 450s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main s390x libubsan1 s390x 10.5.0-1ubuntu1~20.04 [756 kB] 450s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgcc-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [689 kB] 450s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9 s390x 9.4.0-1ubuntu1~20.04.2 [6489 kB] 450s Get:18 http://ftpmaster.internal/ubuntu focal/main s390x gcc s390x 4:9.3.0-1ubuntu2 [5204 B] 450s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main s390x libstdc++-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [1682 kB] 450s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main s390x g++-9 s390x 9.4.0-1ubuntu1~20.04.2 [6608 kB] 451s Get:21 http://ftpmaster.internal/ubuntu focal/main s390x g++ s390x 4:9.3.0-1ubuntu2 [1600 B] 451s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main s390x build-essential s390x 12.8ubuntu1.1 [4664 B] 451s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpgtypes3 s390x 12.22-0ubuntu0.20.04.1 [44.2 kB] 451s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpq5 s390x 12.22-0ubuntu0.20.04.1 [109 kB] 451s Get:25 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg6 s390x 12.22-0ubuntu0.20.04.1 [40.4 kB] 451s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg-compat3 s390x 12.22-0ubuntu0.20.04.1 [12.1 kB] 451s Get:27 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpq-dev s390x 12.22-0ubuntu0.20.04.1 [133 kB] 451s Get:28 http://ftpmaster.internal/ubuntu focal-updates/main s390x libecpg-dev s390x 12.22-0ubuntu0.20.04.1 [223 kB] 451s Get:29 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpython3.8 s390x 3.8.10-0ubuntu1~20.04.15 [1479 kB] 451s Get:30 http://ftpmaster.internal/ubuntu focal/main s390x libtcl8.6 s390x 8.6.10+dfsg-1 [838 kB] 451s Get:31 http://ftpmaster.internal/ubuntu focal-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.20.04.1 [140 kB] 451s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-common all 214ubuntu0.1 [28.2 kB] 451s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-12 s390x 12.22-0ubuntu0.20.04.1 [1012 kB] 451s Get:34 http://ftpmaster.internal/ubuntu focal/main s390x ssl-cert all 1.0.39 [17.0 kB] 451s Get:35 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-common all 214ubuntu0.1 [169 kB] 451s Get:36 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-12 s390x 12.22-0ubuntu0.20.04.1 [3735 kB] 451s Get:37 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 451s Get:38 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-plperl-12 s390x 12.22-0ubuntu0.20.04.1 [47.1 kB] 451s Get:39 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-plpython3-12 s390x 12.22-0ubuntu0.20.04.1 [53.4 kB] 451s Get:40 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-pltcl-12 s390x 12.22-0ubuntu0.20.04.1 [30.0 kB] 451s Get:41 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-server-dev-12 s390x 12.22-0ubuntu0.20.04.1 [984 kB] 452s Preconfiguring packages ... 452s Fetched 39.7 MB in 5s (7633 kB/s) 452s Selecting previously unselected package libc-dev-bin. 452s (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 ... 71286 files and directories currently installed.) 452s Preparing to unpack .../00-libc-dev-bin_2.31-0ubuntu9.17_s390x.deb ... 452s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 452s Selecting previously unselected package linux-libc-dev:s390x. 452s Preparing to unpack .../01-linux-libc-dev_5.4.0-208.228_s390x.deb ... 452s Unpacking linux-libc-dev:s390x (5.4.0-208.228) ... 452s Selecting previously unselected package libcrypt-dev:s390x. 452s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.10-10ubuntu4_s390x.deb ... 452s Unpacking libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 452s Selecting previously unselected package libc6-dev:s390x. 452s Preparing to unpack .../03-libc6-dev_2.31-0ubuntu9.17_s390x.deb ... 452s Unpacking libc6-dev:s390x (2.31-0ubuntu9.17) ... 452s Selecting previously unselected package gcc-9-base:s390x. 452s Preparing to unpack .../04-gcc-9-base_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 452s Unpacking gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 452s Selecting previously unselected package libisl22:s390x. 452s Preparing to unpack .../05-libisl22_0.22.1-1_s390x.deb ... 452s Unpacking libisl22:s390x (0.22.1-1) ... 452s Selecting previously unselected package libmpc3:s390x. 452s Preparing to unpack .../06-libmpc3_1.1.0-1_s390x.deb ... 452s Unpacking libmpc3:s390x (1.1.0-1) ... 452s Selecting previously unselected package cpp-9. 452s Preparing to unpack .../07-cpp-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 452s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 453s Selecting previously unselected package cpp. 453s Preparing to unpack .../08-cpp_4%3a9.3.0-1ubuntu2_s390x.deb ... 453s Unpacking cpp (4:9.3.0-1ubuntu2) ... 453s Selecting previously unselected package libcc1-0:s390x. 453s Preparing to unpack .../09-libcc1-0_10.5.0-1ubuntu1~20.04_s390x.deb ... 453s Unpacking libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 453s Selecting previously unselected package libgomp1:s390x. 453s Preparing to unpack .../10-libgomp1_10.5.0-1ubuntu1~20.04_s390x.deb ... 453s Unpacking libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 453s Selecting previously unselected package libitm1:s390x. 453s Preparing to unpack .../11-libitm1_10.5.0-1ubuntu1~20.04_s390x.deb ... 453s Unpacking libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 453s Selecting previously unselected package libatomic1:s390x. 453s Preparing to unpack .../12-libatomic1_10.5.0-1ubuntu1~20.04_s390x.deb ... 453s Unpacking libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 453s Selecting previously unselected package libasan5:s390x. 453s Preparing to unpack .../13-libasan5_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 453s Unpacking libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 453s Selecting previously unselected package libubsan1:s390x. 453s Preparing to unpack .../14-libubsan1_10.5.0-1ubuntu1~20.04_s390x.deb ... 453s Unpacking libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 453s Selecting previously unselected package libgcc-9-dev:s390x. 453s Preparing to unpack .../15-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 453s Unpacking libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 453s Selecting previously unselected package gcc-9. 453s Preparing to unpack .../16-gcc-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 453s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 453s Selecting previously unselected package gcc. 453s Preparing to unpack .../17-gcc_4%3a9.3.0-1ubuntu2_s390x.deb ... 453s Unpacking gcc (4:9.3.0-1ubuntu2) ... 453s Selecting previously unselected package libstdc++-9-dev:s390x. 453s Preparing to unpack .../18-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 453s Unpacking libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 454s Selecting previously unselected package g++-9. 454s Preparing to unpack .../19-g++-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 454s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 454s Selecting previously unselected package g++. 454s Preparing to unpack .../20-g++_4%3a9.3.0-1ubuntu2_s390x.deb ... 454s Unpacking g++ (4:9.3.0-1ubuntu2) ... 454s Selecting previously unselected package build-essential. 454s Preparing to unpack .../21-build-essential_12.8ubuntu1.1_s390x.deb ... 454s Unpacking build-essential (12.8ubuntu1.1) ... 454s Selecting previously unselected package libpgtypes3:s390x. 454s Preparing to unpack .../22-libpgtypes3_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libpgtypes3:s390x (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libpq5:s390x. 454s Preparing to unpack .../23-libpq5_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libpq5:s390x (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libecpg6:s390x. 454s Preparing to unpack .../24-libecpg6_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libecpg6:s390x (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libecpg-compat3:s390x. 454s Preparing to unpack .../25-libecpg-compat3_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libecpg-compat3:s390x (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libpq-dev. 454s Preparing to unpack .../26-libpq-dev_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libecpg-dev. 454s Preparing to unpack .../27-libecpg-dev_12.22-0ubuntu0.20.04.1_s390x.deb ... 454s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 454s Selecting previously unselected package libpython3.8:s390x. 454s Preparing to unpack .../28-libpython3.8_3.8.10-0ubuntu1~20.04.15_s390x.deb ... 454s Unpacking libpython3.8:s390x (3.8.10-0ubuntu1~20.04.15) ... 454s Selecting previously unselected package libtcl8.6:s390x. 454s Preparing to unpack .../29-libtcl8.6_8.6.10+dfsg-1_s390x.deb ... 454s Unpacking libtcl8.6:s390x (8.6.10+dfsg-1) ... 455s Selecting previously unselected package libxslt1.1:s390x. 455s Preparing to unpack .../30-libxslt1.1_1.1.34-4ubuntu0.20.04.1_s390x.deb ... 455s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-client-common. 455s Preparing to unpack .../31-postgresql-client-common_214ubuntu0.1_all.deb ... 455s Unpacking postgresql-client-common (214ubuntu0.1) ... 455s Selecting previously unselected package postgresql-client-12. 455s Preparing to unpack .../32-postgresql-client-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package ssl-cert. 455s Preparing to unpack .../33-ssl-cert_1.0.39_all.deb ... 455s Unpacking ssl-cert (1.0.39) ... 455s Selecting previously unselected package postgresql-common. 455s Preparing to unpack .../34-postgresql-common_214ubuntu0.1_all.deb ... 455s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 455s Unpacking postgresql-common (214ubuntu0.1) ... 455s Selecting previously unselected package postgresql-12. 455s Preparing to unpack .../35-postgresql-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-doc-12. 455s Preparing to unpack .../36-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 455s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-plperl-12. 455s Preparing to unpack .../37-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-plpython3-12. 455s Preparing to unpack .../38-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-pltcl-12. 455s Preparing to unpack .../39-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 455s Selecting previously unselected package postgresql-server-dev-12. 455s Preparing to unpack .../40-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_s390x.deb ... 455s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 455s Setting up postgresql-client-common (214ubuntu0.1) ... 455s Setting up libpgtypes3:s390x (12.22-0ubuntu0.20.04.1) ... 455s Setting up libpq5:s390x (12.22-0ubuntu0.20.04.1) ... 455s Setting up linux-libc-dev:s390x (5.4.0-208.228) ... 455s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 455s Setting up libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 455s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 456s update-alternatives: using /usr/share/postgresql/12/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 456s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 456s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 456s Setting up ssl-cert (1.0.39) ... 456s Setting up libpython3.8:s390x (3.8.10-0ubuntu1~20.04.15) ... 456s Setting up postgresql-common (214ubuntu0.1) ... 456s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 456s Adding user postgres to group ssl-cert 456s 456s Creating config file /etc/postgresql-common/createcluster.conf with new version 456s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 456s Removing obsolete dictionary files: 457s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 457s Setting up libmpc3:s390x (1.1.0-1) ... 457s Setting up libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 457s Setting up libtcl8.6:s390x (8.6.10+dfsg-1) ... 457s Setting up libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 457s Setting up libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 457s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.1) ... 457s Setting up libecpg6:s390x (12.22-0ubuntu0.20.04.1) ... 457s Setting up libisl22:s390x (0.22.1-1) ... 457s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 457s Creating new PostgreSQL cluster 12/main ... 457s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 457s The files belonging to this database system will be owned by user "postgres". 457s This user must also own the server process. 457s 457s The database cluster will be initialized with locale "C.UTF-8". 457s The default database encoding has accordingly been set to "UTF8". 457s The default text search configuration will be set to "english". 457s 457s Data page checksums are disabled. 457s 457s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 457s creating subdirectories ... ok 457s selecting dynamic shared memory implementation ... posix 457s selecting default max_connections ... 100 457s selecting default shared_buffers ... 128MB 457s selecting default time zone ... Etc/UTC 457s creating configuration files ... ok 457s running bootstrap script ... ok 458s performing post-bootstrap initialization ... ok 458s syncing data to disk ... ok 458s 458s Success. You can now start the database server using: 458s 458s pg_ctlcluster 12 main start 458s 458s Ver Cluster Port Status Owner Data directory Log file 458s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 458s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 461s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 461s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 461s Setting up libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 461s Setting up libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 461s Setting up gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 461s Setting up libecpg-compat3:s390x (12.22-0ubuntu0.20.04.1) ... 461s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 461s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 461s Setting up libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 461s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up libc6-dev:s390x (2.31-0ubuntu9.17) ... 461s Setting up libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up cpp (4:9.3.0-1ubuntu2) ... 461s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up gcc (4:9.3.0-1ubuntu2) ... 461s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 461s Setting up g++ (4:9.3.0-1ubuntu2) ... 461s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 461s Setting up build-essential (12.8ubuntu1.1) ... 461s Processing triggers for systemd (245.4-4ubuntu3.24) ... 461s Processing triggers for man-db (2.9.1-1) ... 462s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 498s autopkgtest [13:24:12]: test installcheck: [----------------------- 498s + dpkg-parsechangelog -SSource 498s + SOURCE=postgresql-12 498s + MAJOR=12 498s + cd src/test/regress 498s + make -f ../../../debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/12/bin/pg_config with_llvm=no 498s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fPIC -I. -I../../../debian/tests/ -I/usr/include/postgresql/12/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/mit-krb5 -c -o regress.o regress.c 499s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fPIC -shared -o regress.so regress.o -L/usr/lib/s390x-linux-gnu -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -L/usr/lib/s390x-linux-gnu/mit-krb5 -Wl,--as-needed 499s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/regress: input/constraints.source input/copy.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_1.source output/create_function_2.source output/largeobject.source output/largeobject_1.source output/misc.source output/tablespace.source 499s + rm -rf testtablespace results regression.* 499s + mkdir testtablespace results 499s + id -u 499s + [ 1000 = 0 ] 499s + pg_virtualenv -v 12 /usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule 499s Creating new PostgreSQL cluster 12/regress ... 499s /usr/lib/postgresql/12/bin/initdb -D /tmp/pg_virtualenv.SJurRq/data/12/regress --auth-local peer --auth-host md5 --username=ubuntu --pwfile=/tmp/pg_virtualenv.SJurRq/postgresql-common/pwfile --nosync 499s The files belonging to this database system will be owned by user "ubuntu". 499s This user must also own the server process. 499s 499s The database cluster will be initialized with locale "C.UTF-8". 499s The default database encoding has accordingly been set to "UTF8". 499s The default text search configuration will be set to "english". 499s 499s Data page checksums are disabled. 499s 499s fixing permissions on existing directory /tmp/pg_virtualenv.SJurRq/data/12/regress ... ok 499s creating subdirectories ... ok 499s selecting dynamic shared memory implementation ... posix 499s selecting default max_connections ... 100 499s selecting default shared_buffers ... 128MB 499s selecting default time zone ... Etc/UTC 499s creating configuration files ... ok 499s running bootstrap script ... ok 499s performing post-bootstrap initialization ... ok 499s 499s Sync to disk skipped. 499s The data directory might become corrupt if the operating system crashes. 499s 499s Success. You can now start the database server using: 499s 499s pg_ctlcluster 12 regress start 499s 499s Warning: The parent /var/run/postgresql of the selected 499s stats_temp_directory is not writable for the cluster owner. Not adding this 499s setting in postgresql.conf. 501s Ver Cluster Port Status Owner Data directory Log file 501s 12 regress 5433 online ubuntu /tmp/pg_virtualenv.SJurRq/data/12/regress /tmp/pg_virtualenv.SJurRq/log/postgresql-12-regress.log 501s 501s (using postmaster on localhost, port 5433) 501s ============== dropping database "regression" ============== 501s NOTICE: database "regression" does not exist, skipping 501s DROP DATABASE 501s ============== creating database "regression" ============== 501s CREATE DATABASE 501s ALTER DATABASE 501s ============== running regression test queries ============== 501s test tablespace ... ok 91 ms 502s parallel group (20 tests): name char uuid oid varchar boolean pg_lsn txid int2 regproc text int4 float4 float8 money bit enum int8 rangetypes numeric 502s boolean ... ok 99 ms 502s char ... ok 84 ms 502s name ... ok 43 ms 502s varchar ... ok 96 ms 502s text ... ok 122 ms 502s int2 ... ok 111 ms 502s int4 ... ok 123 ms 502s int8 ... ok 162 ms 502s oid ... ok 92 ms 502s float4 ... ok 136 ms 502s float8 ... ok 137 ms 502s bit ... ok 154 ms 502s numeric ... ok 267 ms 502s txid ... ok 109 ms 502s uuid ... ok 90 ms 502s enum ... ok 154 ms 502s money ... ok 146 ms 502s rangetypes ... ok 262 ms 502s pg_lsn ... ok 104 ms 502s regproc ... ok 113 ms 502s parallel group (19 tests): numerology time lseg line timetz point macaddr8 path macaddr inet circle tstypes date interval box strings polygon timestamp timestamptz 502s strings ... ok 161 ms 502s numerology ... ok 39 ms 502s point ... ok 80 ms 502s lseg ... ok 51 ms 502s line ... ok 51 ms 502s box ... ok 128 ms 502s path ... ok 94 ms 502s polygon ... ok 211 ms 502s circle ... ok 110 ms 502s date ... ok 116 ms 502s time ... ok 44 ms 502s timetz ... ok 50 ms 502s timestamp ... ok 368 ms 502s timestamptz ... FAILED 371 ms 502s interval ... ok 123 ms 502s inet ... ok 106 ms 502s macaddr ... ok 95 ms 502s macaddr8 ... ok 80 ms 502s tstypes ... ok 113 ms 502s parallel group (10 tests): comments expressions misc_sanity horology geometry type_sanity oidjoins database opr_sanity regex 502s geometry ... ok 158 ms 502s horology ... ok 132 ms 502s regex ... ok 374 ms 502s oidjoins ... ok 174 ms 502s type_sanity ... ok 159 ms 502s opr_sanity ... ok 281 ms 502s misc_sanity ... ok 83 ms 502s comments ... ok 50 ms 502s expressions ... ok 62 ms 502s database ... ok 205 ms 502s test create_function_1 ... ok 10 ms 502s test create_type ... ok 12 ms 503s test create_table ... ok 162 ms 503s test create_function_2 ... ok 7 ms 503s parallel group (5 tests): copyselect copydml insert_conflict insert copy 503s copy ... ok 209 ms 503s copyselect ... ok 15 ms 503s copydml ... ok 26 ms 503s insert ... ok 184 ms 503s insert_conflict ... ok 118 ms 503s parallel group (4 tests): create_operator create_schema create_procedure create_misc 503s create_misc ... ok 49 ms 503s create_operator ... ok 19 ms 503s create_procedure ... ok 39 ms 503s create_schema ... ok 29 ms 503s parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 503s create_index ... ok 470 ms 503s create_index_spgist ... ok 325 ms 503s create_view ... ok 258 ms 503s index_including ... ok 172 ms 503s index_including_gist ... ok 291 ms 504s parallel group (16 tests): create_cast errors create_am create_function_3 create_aggregate hash_func roleattributes select typed_table drop_if_exists infinite_recurse vacuum constraints inherit updatable_views triggers 504s create_aggregate ... ok 110 ms 504s create_function_3 ... ok 108 ms 504s create_cast ... ok 67 ms 504s constraints ... ok 271 ms 504s triggers ... ok 535 ms 504s select ... ok 191 ms 504s inherit ... ok 413 ms 504s typed_table ... ok 200 ms 504s vacuum ... ok 237 ms 504s drop_if_exists ... ok 213 ms 504s updatable_views ... ok 470 ms 504s roleattributes ... ok 151 ms 504s create_am ... ok 101 ms 504s hash_func ... ok 112 ms 504s errors ... ok 82 ms 504s infinite_recurse ... ok 220 ms 504s test sanity_check ... ok 56 ms 505s parallel group (20 tests): delete random namespace select_having select_distinct_on select_implicit case prepared_xacts select_distinct transactions select_into union portals subselect hash_index arrays update aggregates btree_index join 505s select_into ... ok 283 ms 505s select_distinct ... ok 167 ms 505s select_distinct_on ... ok 116 ms 505s select_implicit ... ok 138 ms 505s select_having ... ok 93 ms 505s subselect ... ok 349 ms 505s union ... ok 287 ms 505s case ... ok 147 ms 505s join ... ok 566 ms 505s aggregates ... ok 493 ms 505s transactions ... ok 209 ms 505s random ... ok 69 ms 505s portals ... ok 308 ms 505s arrays ... ok 421 ms 505s btree_index ... ok 517 ms 505s hash_index ... ok 412 ms 505s update ... ok 444 ms 505s delete ... ok 60 ms 505s namespace ... ok 85 ms 505s prepared_xacts ... ok 150 ms 506s parallel group (20 tests): init_privs drop_operator security_label tablesample object_address lock password gin groupingsets collate replica_identity identity generated matview rowsecurity spgist gist join_hash brin privileges 506s brin ... ok 1382 ms 506s gin ... ok 514 ms 506s gist ... ok 1239 ms 506s spgist ... ok 1026 ms 506s privileges ... ok 1469 ms 506s init_privs ... ok 96 ms 506s security_label ... ok 200 ms 506s collate ... ok 547 ms 506s matview ... ok 824 ms 506s lock ... ok 415 ms 506s replica_identity ... ok 570 ms 506s rowsecurity ... ok 988 ms 506s object_address ... ok 378 ms 506s tablesample ... ok 363 ms 506s groupingsets ... ok 513 ms 506s drop_operator ... ok 139 ms 506s password ... ok 460 ms 506s identity ... ok 586 ms 506s generated ... ok 811 ms 506s join_hash ... ok 1378 ms 506s parallel group (11 tests): dbsize tsrf tid alter_operator async tidscan alter_generic misc sysviews misc_functions create_table_like 506s create_table_like ... ok 221 ms 506s alter_generic ... ok 121 ms 506s alter_operator ... ok 73 ms 506s misc ... ok 146 ms 506s async ... ok 73 ms 506s dbsize ... ok 36 ms 506s misc_functions ... ok 190 ms 506s sysviews ... ok 169 ms 506s tsrf ... ok 39 ms 506s tid ... ok 44 ms 506s tidscan ... ok 77 ms 507s parallel group (5 tests): amutils psql_crosstab psql rules stats_ext 507s rules ... ok 160 ms 507s psql ... ok 158 ms 507s psql_crosstab ... ok 33 ms 507s amutils ... ok 28 ms 507s stats_ext ... ok 526 ms 507s test select_parallel ... ok 650 ms 507s test write_parallel ... ok 43 ms 508s parallel group (2 tests): subscription publication 508s publication ... ok 30 ms 508s subscription ... ok 12 ms 508s parallel group (17 tests): portals_p2 advisory_lock guc dependency combocid equivclass xmlmap functional_deps tsdicts select_views tsearch window bitmapops cluster indirect_toast foreign_data foreign_key 508s select_views ... ok 340 ms 508s portals_p2 ... ok 65 ms 508s foreign_key ... ok 748 ms 508s cluster ... ok 478 ms 508s dependency ... ok 129 ms 508s guc ... ok 83 ms 508s bitmapops ... ok 446 ms 508s combocid ... ok 144 ms 508s tsearch ... ok 361 ms 508s tsdicts ... ok 237 ms 508s foreign_data ... ok 606 ms 508s window ... ok 424 ms 508s xmlmap ... ok 196 ms 508s functional_deps ... ok 223 ms 508s advisory_lock ... ok 65 ms 508s indirect_toast ... ok 544 ms 508s equivclass ... ok 153 ms 508s parallel group (6 tests): json_encoding jsonpath_encoding jsonpath jsonb_jsonpath json jsonb 508s json ... ok 80 ms 508s jsonb ... ok 119 ms 508s json_encoding ... ok 12 ms 508s jsonpath ... ok 37 ms 508s jsonpath_encoding ... ok 24 ms 508s jsonb_jsonpath ... ok 47 ms 509s parallel group (18 tests): limit prepare conversion returning sequence temp copy2 polymorphism plancache rangefuncs with truncate rowtypes domain largeobject xml plpgsql alter_table 509s plancache ... ok 356 ms 509s limit ... ok 53 ms 509s plpgsql ... ok 653 ms 509s copy2 ... ok 296 ms 509s temp ... ok 272 ms 509s domain ... ok 466 ms 509s rangefuncs ... ok 373 ms 509s prepare ... ok 82 ms 509s conversion ... ok 101 ms 509s truncate ... ok 442 ms 509s alter_table ... ok 919 ms 509s sequence ... ok 201 ms 509s polymorphism ... ok 323 ms 509s rowtypes ... ok 448 ms 509s returning ... ok 135 ms 509s largeobject ... ok 499 ms 509s with ... ok 373 ms 509s xml ... ok 636 ms 510s parallel group (7 tests): reloptions hash_part partition_info partition_join indexing partition_prune partition_aggregate 510s partition_join ... ok 378 ms 510s partition_prune ... ok 530 ms 510s reloptions ... ok 20 ms 510s hash_part ... ok 60 ms 510s indexing ... ok 496 ms 510s partition_aggregate ... ok 621 ms 510s partition_info ... ok 66 ms 510s test event_trigger ... ok 48 ms 510s test fast_default ... ok 58 ms 511s test stats ... ok 553 ms 511s 511s ======================== 511s 1 of 196 tests failed. 511s ======================== 511s 511s The differences that caused some tests to fail can be viewed in the 511s file "/tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/regression.diffs". A copy of the test summary that you see 511s above is saved in the file "/tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/regression.out". 511s 511s *** /tmp/pg_virtualenv.SJurRq/log/postgresql-12-regress.log (last 100 lines) *** 511s 2025-02-26 13:24:24.236 UTC [7637] ubuntu@regression DETAIL: Key (a)=(3) already exists. 511s 2025-02-26 13:24:24.236 UTC [7637] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression DETAIL: Key (a)=(4) already exists. 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 511s 2025-02-26 13:24:24.237 UTC [7637] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 511s 2025-02-26 13:24:24.238 UTC [7637] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 511s 2025-02-26 13:24:24.238 UTC [7637] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 511s 2025-02-26 13:24:24.239 UTC [7637] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 511s 2025-02-26 13:24:24.239 UTC [7637] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 511s 2025-02-26 13:24:24.284 UTC [7637] ubuntu@regression ERROR: division by zero 511s 2025-02-26 13:24:24.284 UTC [7637] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 511s 2025-02-26 13:24:24.434 UTC [7720] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 511s 2025-02-26 13:24:24.434 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 511s on ddl_command_start 511s execute procedure pg_backend_pid(); 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression ERROR: trigger functions can only be called as triggers 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 511s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 511s SELECT 1 $$ language sql; 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 511s 2025-02-26 13:24:24.435 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: unrecognized filter variable "food" 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when food in ('sandwich') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('sandwich') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('create table', 'create skunkcabbage') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('DROP EVENT TRIGGER') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('CREATE ROLE') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('CREATE DATABASE') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('CREATE TABLESPACE') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: filter variable "tag" specified more than once 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s when tag in ('create table') and tag in ('CREATE FUNCTION') 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 511s execute procedure test_event_trigger('argument not allowed'); 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression HINT: Must be superuser to create an event trigger. 511s 2025-02-26 13:24:24.436 UTC [7720] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 511s execute procedure test_event_trigger(); 511s 2025-02-26 13:24:24.440 UTC [7720] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 511s 2025-02-26 13:24:24.440 UTC [7720] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 511s 2025-02-26 13:24:24.440 UTC [7720] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 511s 2025-02-26 13:24:24.440 UTC [7720] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 511s 2025-02-26 13:24:24.440 UTC [7720] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 511s 2025-02-26 13:24:24.441 UTC [7720] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 511s 2025-02-26 13:24:24.441 UTC [7720] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 511s 2025-02-26 13:24:24.441 UTC [7720] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 511s 2025-02-26 13:24:24.441 UTC [7720] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 511s owner of user mapping for regress_evt_user on server useless_server 511s owner of default privileges on new relations belonging to role regress_evt_user 511s 2025-02-26 13:24:24.441 UTC [7720] ubuntu@regression STATEMENT: drop role regress_evt_user; 511s 2025-02-26 13:24:24.448 UTC [7720] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 511s 2025-02-26 13:24:24.448 UTC [7720] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 511s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 511s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 511s 2025-02-26 13:24:24.448 UTC [7720] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 511s 2025-02-26 13:24:24.450 UTC [7720] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 511s 2025-02-26 13:24:24.450 UTC [7720] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 511s 2025-02-26 13:24:24.450 UTC [7720] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 511s 2025-02-26 13:24:24.464 UTC [7720] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 511s 2025-02-26 13:24:24.464 UTC [7720] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 511s 2025-02-26 13:24:24.466 UTC [7720] ubuntu@regression ERROR: rewrites not allowed 511s 2025-02-26 13:24:24.466 UTC [7720] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 511s 2025-02-26 13:24:24.466 UTC [7720] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 511s 2025-02-26 13:24:24.473 UTC [7720] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 511s 2025-02-26 13:24:24.473 UTC [7720] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 511s 2025-02-26 13:24:25.081 UTC [7729] ubuntu@regression LOG: wait_for_stats delayed 0.516421 seconds 511s 2025-02-26 13:24:25.081 UTC [7729] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 511s 2025-02-26 13:24:25.081 UTC [7729] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 511s Dropping cluster 12/regress ... 511s + cat regression.diffs 511s diff -U3 /tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/expected/timestamptz.out /tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/results/timestamptz.out 511s --- /tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:41:03.000000000 +0000 511s +++ /tmp/autopkgtest.3rbb5T/build.swV/src/src/test/regress/results/timestamptz.out 2025-02-26 13:24:16.482941902 +0000 511s @@ -2060,7 +2060,7 @@ 511s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 511s timezone 511s -------------------------- 511s - Wed Dec 09 15:56:00 1846 511s + Wed Dec 09 15:56:08 1846 511s (1 row) 511s 511s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 511s + exit 1 511s autopkgtest [13:24:25]: test installcheck: -----------------------] 512s installcheck FAIL non-zero exit status 1 512s autopkgtest [13:24:26]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 512s autopkgtest [13:24:26]: @@@@@@@@@@@@@@@@@@@@ summary 512s run-testsuite FAIL non-zero exit status 1 512s installcheck FAIL non-zero exit status 1 529s nova [W] Using flock in prodstack6-s390x 529s flock: timeout while waiting to get lock 529s Creating nova instance adt-focal-s390x-postgresql-12-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-8da9da23-aa62-4dbd-9972-9c8de1d291b0 from image adt/ubuntu-focal-s390x-server-20250226.img (UUID e45102c4-03ea-4b01-a483-51d99bb2b36c)... 529s nova [W] Timed out waiting for 3c3f4da7-3feb-4c4c-b546-048246a6c1a4 to get deleted. 529s nova [W] Using flock in prodstack6-s390x 529s Creating nova instance adt-focal-s390x-postgresql-12-20250226-131553-juju-7f2275-prod-proposed-migration-environment-15-8da9da23-aa62-4dbd-9972-9c8de1d291b0 from image adt/ubuntu-focal-s390x-server-20250226.img (UUID e45102c4-03ea-4b01-a483-51d99bb2b36c)... 529s nova [W] Timed out waiting for 7aa73093-d948-4b38-b8ad-0adcb3cdedbb to get deleted.