0s autopkgtest [13:50:53]: starting date and time: 2025-02-26 13:50:53+0000 0s autopkgtest [13:50:53]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:50:53]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work._2063j1q/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-15.secgroup --name adt-focal-arm64-postgresql-12-20250226-131551-juju-7f2275-prod-proposed-migration-environment-15-3c30380e-6b55-4816-b432-2424cddc82dd --image adt/ubuntu-focal-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration -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/ 68s autopkgtest [13:52:01]: testbed dpkg architecture: arm64 68s autopkgtest [13:52:01]: testbed apt version: 2.0.10 68s autopkgtest [13:52:01]: @@@@@@@@@@@@@@@@@@@@ test bed setup 68s autopkgtest [13:52:01]: testbed release detected to be: None 69s autopkgtest [13:52:02]: updating testbed package index (apt update) 69s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 70s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 70s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 70s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 70s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 70s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 70s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 70s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 70s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 Packages [274 kB] 70s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 c-n-f Metadata [1428 B] 70s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 Packages [14.1 kB] 70s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 c-n-f Metadata [116 B] 70s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 Packages [46.7 kB] 70s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 c-n-f Metadata [1712 B] 70s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 Packages [10.0 kB] 70s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 c-n-f Metadata [304 B] 73s Fetched 730 kB in 1s (676 kB/s) 74s Reading package lists... 75s + lsb_release --codename --short 75s + RELEASE=focal 75s + cat 75s + [ focal != trusty ] 75s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 75s Reading package lists... 75s Building dependency tree... 75s Reading state information... 75s Calculating upgrade... 76s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 76s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 76s + /usr/lib/apt/apt-helper analyze-pattern ?true 76s + + sed s/\./\\./g 76s uname -r 76s + running_kernel_pattern=^linux-.*5\.4\.0-208-generic.* 76s + apt list ?obsolete 76s + tail -n+2 76s + cut -d/ -f1 76s + grep -v ^linux-.*5\.4\.0-208-generic.* 76s + true 76s + obsolete_pkgs= 76s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 76s Reading package lists... 76s Building dependency tree... 76s Reading state information... 77s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 77s + grep -q trusty /etc/lsb-release 77s + [ ! -d /usr/share/doc/unattended-upgrades ] 77s + [ ! -d /usr/share/doc/lxd ] 77s + [ ! -d /usr/share/doc/lxd-client ] 77s + [ ! -d /usr/share/doc/snapd ] 77s + type iptables 77s + cat 77s + chmod 755 /etc/rc.local 77s + . /etc/rc.local 77s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 77s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 77s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 77s + uname -m 77s + [ aarch64 = ppc64le ] 77s + [ -d /run/systemd/system ] 77s + systemd-detect-virt --quiet --vm 77s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 77s + cat 77s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 77s + echo COMPRESS=lz4 77s autopkgtest [13:52:10]: upgrading testbed (apt dist-upgrade and autopurge) 77s Reading package lists... 77s Building dependency tree... 77s Reading state information... 77s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 77s Starting 2 pkgProblemResolver with broken count: 0 77s Done 77s 78s The following packages will be upgraded: 78s tzdata 78s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 78s Need to get 300 kB of archives. 78s After this operation, 3072 B of additional disk space will be used. 78s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 tzdata all 2025a-0ubuntu0.20.04 [300 kB] 78s Preconfiguring packages ... 78s Fetched 300 kB in 0s (664 kB/s) 79s (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 ... 100151 files and directories currently installed.) 79s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 79s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 79s Setting up tzdata (2025a-0ubuntu0.20.04) ... 79s 79s Current default time zone: 'Etc/UTC' 79s Local time is now: Wed Feb 26 13:52:12 UTC 2025. 79s Universal Time is now: Wed Feb 26 13:52:12 UTC 2025. 79s Run 'dpkg-reconfigure tzdata' if you wish to change it. 79s 80s Reading package lists... 80s Building dependency tree... 80s Reading state information... 80s Starting pkgProblemResolver with broken count: 0 80s Starting 2 pkgProblemResolver with broken count: 0 80s Done 80s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s autopkgtest [13:52:16]: testbed running kernel: Linux 5.4.0-208-generic #228-Ubuntu SMP Sat Feb 8 14:01:34 UTC 2025 83s autopkgtest [13:52:16]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-12 96s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (dsc) [3764 B] 96s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (tar) [27.9 MB] 96s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (diff) [31.2 kB] 97s gpgv: Signature made Wed Nov 27 17:17:35 2024 UTC 97s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 97s gpgv: Can't check signature: No public key 97s dpkg-source: warning: failed to verify signature on ./postgresql-12_12.22-0ubuntu0.20.04.1.dsc 98s autopkgtest [13:52:31]: testing package postgresql-12 version 12.22-0ubuntu0.20.04.1 99s autopkgtest [13:52:32]: build not needed 109s autopkgtest [13:52:42]: test run-testsuite: preparing testbed 109s Reading package lists... 110s Building dependency tree... 110s Reading state information... 110s Starting pkgProblemResolver with broken count: 0 110s Starting 2 pkgProblemResolver with broken count: 0 110s Done 110s The following NEW packages will be installed: 110s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 110s emacsen-common g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us libasan5 110s libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-10-dev 110s libclang-cpp10 libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev 110s libecpg6 libffi-dev libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 110s libllvm10 liblsan0 libmpc3 libncurses-dev libobjc-9-dev libobjc4 libpfm4 110s libpgtypes3 libpq-dev libpq5 libpython3.8 libstdc++-9-dev libtcl8.6 110s libtinfo-dev libtsan0 libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev 110s llvm-10 llvm-10-dev llvm-10-runtime llvm-10-tools net-tools postgresql-12 110s postgresql-client-12 postgresql-client-common postgresql-common 110s postgresql-doc-12 postgresql-plperl-12 postgresql-plpython3-12 110s postgresql-pltcl-12 postgresql-server-dev-12 python3-pygments ssl-cert 110s 0 upgraded, 67 newly installed, 0 to remove and 0 not upgraded. 110s Need to get 119 MB of archives. 110s After this operation, 647 MB of additional disk space will be used. 110s Get:1 http://ftpmaster.internal/ubuntu focal/universe arm64 binfmt-support arm64 2.2.0-2 [55.5 kB] 110s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc-dev-bin arm64 2.31-0ubuntu9.17 [64.2 kB] 110s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main arm64 linux-libc-dev arm64 5.4.0-208.228 [1098 kB] 111s Get:4 http://ftpmaster.internal/ubuntu focal/main arm64 libcrypt-dev arm64 1:4.4.10-10ubuntu4 [111 kB] 111s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc6-dev arm64 2.31-0ubuntu9.17 [2069 kB] 111s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9-base arm64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 111s Get:7 http://ftpmaster.internal/ubuntu focal/main arm64 libisl22 arm64 0.22.1-1 [537 kB] 111s Get:8 http://ftpmaster.internal/ubuntu focal/main arm64 libmpc3 arm64 1.1.0-1 [37.2 kB] 111s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main arm64 cpp-9 arm64 9.4.0-1ubuntu1~20.04.2 [5985 kB] 111s Get:10 http://ftpmaster.internal/ubuntu focal/main arm64 cpp arm64 4:9.3.0-1ubuntu2 [27.6 kB] 111s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libcc1-0 arm64 10.5.0-1ubuntu1~20.04 [46.2 kB] 111s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgomp1 arm64 10.5.0-1ubuntu1~20.04 [93.5 kB] 111s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libitm1 arm64 10.5.0-1ubuntu1~20.04 [24.1 kB] 111s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libatomic1 arm64 10.5.0-1ubuntu1~20.04 [9808 B] 111s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libasan5 arm64 9.4.0-1ubuntu1~20.04.2 [2690 kB] 111s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main arm64 liblsan0 arm64 10.5.0-1ubuntu1~20.04 [800 kB] 111s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtsan0 arm64 10.5.0-1ubuntu1~20.04 [1972 kB] 112s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libubsan1 arm64 10.5.0-1ubuntu1~20.04 [765 kB] 112s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgcc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [920 kB] 112s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9 arm64 9.4.0-1ubuntu1~20.04.2 [6736 kB] 112s Get:21 http://ftpmaster.internal/ubuntu focal/main arm64 gcc arm64 4:9.3.0-1ubuntu2 [5228 B] 112s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libstdc++-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [1687 kB] 112s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main arm64 g++-9 arm64 9.4.0-1ubuntu1~20.04.2 [6843 kB] 112s Get:24 http://ftpmaster.internal/ubuntu focal/main arm64 g++ arm64 4:9.3.0-1ubuntu2 [1592 B] 112s Get:25 http://ftpmaster.internal/ubuntu focal-updates/main arm64 build-essential arm64 12.8ubuntu1.1 [4664 B] 112s Get:26 http://ftpmaster.internal/ubuntu focal/main arm64 libllvm10 arm64 1:10.0.0-4ubuntu1 [12.7 MB] 113s Get:27 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-cpp10 arm64 1:10.0.0-4ubuntu1 [8123 kB] 113s Get:28 http://ftpmaster.internal/ubuntu focal/main arm64 libgc1c2 arm64 1:7.6.4-0.4ubuntu1 [74.0 kB] 113s Get:29 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc4 arm64 10.5.0-1ubuntu1~20.04 [39.5 kB] 113s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [211 kB] 113s Get:31 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-common-10-dev arm64 1:10.0.0-4ubuntu1 [3267 kB] 113s Get:32 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang1-10 arm64 1:10.0.0-4ubuntu1 [6176 kB] 113s Get:33 http://ftpmaster.internal/ubuntu focal/universe arm64 clang-10 arm64 1:10.0.0-4ubuntu1 [61.9 kB] 113s Get:34 http://ftpmaster.internal/ubuntu focal/main arm64 emacsen-common all 3.0.4 [14.9 kB] 113s Get:35 http://ftpmaster.internal/ubuntu focal/main arm64 dictionaries-common all 1.28.1 [178 kB] 113s Get:36 http://ftpmaster.internal/ubuntu focal/main arm64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 113s Get:37 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpgtypes3 arm64 12.22-0ubuntu0.20.04.1 [43.1 kB] 113s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpq5 arm64 12.22-0ubuntu0.20.04.1 [111 kB] 113s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg6 arm64 12.22-0ubuntu0.20.04.1 [40.5 kB] 113s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg-compat3 arm64 12.22-0ubuntu0.20.04.1 [12.0 kB] 113s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpq-dev arm64 12.22-0ubuntu0.20.04.1 [134 kB] 113s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg-dev arm64 12.22-0ubuntu0.20.04.1 [224 kB] 113s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libncurses-dev arm64 6.2-0ubuntu2.1 [327 kB] 113s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpython3.8 arm64 3.8.10-0ubuntu1~20.04.15 [1490 kB] 113s Get:45 http://ftpmaster.internal/ubuntu focal/main arm64 libtcl8.6 arm64 8.6.10+dfsg-1 [849 kB] 113s Get:46 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtinfo-dev arm64 6.2-0ubuntu2.1 [972 B] 113s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.20.04.1 [141 kB] 113s Get:48 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-runtime arm64 1:10.0.0-4ubuntu1 [148 kB] 113s Get:49 http://ftpmaster.internal/ubuntu focal/main arm64 libpfm4 arm64 4.10.1+git20-g7700f49-2 [33.1 kB] 113s Get:50 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10 arm64 1:10.0.0-4ubuntu1 [4076 kB] 113s Get:51 http://ftpmaster.internal/ubuntu focal/main arm64 libffi-dev arm64 3.3-4 [53.5 kB] 113s Get:52 http://ftpmaster.internal/ubuntu focal-updates/main arm64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 113s Get:53 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-tools arm64 1:10.0.0-4ubuntu1 [276 kB] 113s Get:54 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-4 arm64 4.8.7-4build1 [5860 kB] 114s Get:55 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-dev arm64 4.8.7-4build1 [67.5 kB] 114s Get:56 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-dev arm64 1:10.0.0-4ubuntu1 [23.0 MB] 114s Get:57 http://ftpmaster.internal/ubuntu focal/main arm64 net-tools arm64 1.60+git20180626.aebd88e-1ubuntu1 [194 kB] 114s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 114s Get:59 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-12 arm64 12.22-0ubuntu0.20.04.1 [1020 kB] 114s Get:60 http://ftpmaster.internal/ubuntu focal/main arm64 ssl-cert all 1.0.39 [17.0 kB] 114s Get:61 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-common all 214ubuntu0.1 [169 kB] 114s Get:62 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-12 arm64 12.22-0ubuntu0.20.04.1 [13.1 MB] 115s Get:63 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 115s Get:64 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-plperl-12 arm64 12.22-0ubuntu0.20.04.1 [64.6 kB] 115s Get:65 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-plpython3-12 arm64 12.22-0ubuntu0.20.04.1 [72.3 kB] 115s Get:66 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-pltcl-12 arm64 12.22-0ubuntu0.20.04.1 [30.0 kB] 115s Get:67 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-server-dev-12 arm64 12.22-0ubuntu0.20.04.1 [987 kB] 115s Preconfiguring packages ... 116s Fetched 119 MB in 5s (24.9 MB/s) 116s Selecting previously unselected package binfmt-support. 116s (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 ... 100152 files and directories currently installed.) 116s Preparing to unpack .../00-binfmt-support_2.2.0-2_arm64.deb ... 116s Unpacking binfmt-support (2.2.0-2) ... 116s Selecting previously unselected package libc-dev-bin. 116s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_arm64.deb ... 116s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 116s Selecting previously unselected package linux-libc-dev:arm64. 116s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_arm64.deb ... 116s Unpacking linux-libc-dev:arm64 (5.4.0-208.228) ... 116s Selecting previously unselected package libcrypt-dev:arm64. 116s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_arm64.deb ... 116s Unpacking libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 116s Selecting previously unselected package libc6-dev:arm64. 116s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_arm64.deb ... 116s Unpacking libc6-dev:arm64 (2.31-0ubuntu9.17) ... 116s Selecting previously unselected package gcc-9-base:arm64. 116s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 116s Unpacking gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 116s Selecting previously unselected package libisl22:arm64. 116s Preparing to unpack .../06-libisl22_0.22.1-1_arm64.deb ... 116s Unpacking libisl22:arm64 (0.22.1-1) ... 116s Selecting previously unselected package libmpc3:arm64. 116s Preparing to unpack .../07-libmpc3_1.1.0-1_arm64.deb ... 116s Unpacking libmpc3:arm64 (1.1.0-1) ... 116s Selecting previously unselected package cpp-9. 116s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 116s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 117s Selecting previously unselected package cpp. 117s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_arm64.deb ... 117s Unpacking cpp (4:9.3.0-1ubuntu2) ... 117s Selecting previously unselected package libcc1-0:arm64. 117s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libgomp1:arm64. 117s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libitm1:arm64. 117s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libatomic1:arm64. 117s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libasan5:arm64. 117s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 117s Unpacking libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 117s Selecting previously unselected package liblsan0:arm64. 117s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libtsan0:arm64. 117s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libubsan1:arm64. 117s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_arm64.deb ... 117s Unpacking libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 117s Selecting previously unselected package libgcc-9-dev:arm64. 117s Preparing to unpack .../18-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 117s Unpacking libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 117s Selecting previously unselected package gcc-9. 117s Preparing to unpack .../19-gcc-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 117s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 118s Selecting previously unselected package gcc. 118s Preparing to unpack .../20-gcc_4%3a9.3.0-1ubuntu2_arm64.deb ... 118s Unpacking gcc (4:9.3.0-1ubuntu2) ... 118s Selecting previously unselected package libstdc++-9-dev:arm64. 118s Preparing to unpack .../21-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 118s Unpacking libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 118s Selecting previously unselected package g++-9. 118s Preparing to unpack .../22-g++-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 118s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 119s Selecting previously unselected package g++. 119s Preparing to unpack .../23-g++_4%3a9.3.0-1ubuntu2_arm64.deb ... 119s Unpacking g++ (4:9.3.0-1ubuntu2) ... 119s Selecting previously unselected package build-essential. 119s Preparing to unpack .../24-build-essential_12.8ubuntu1.1_arm64.deb ... 119s Unpacking build-essential (12.8ubuntu1.1) ... 119s Selecting previously unselected package libllvm10:arm64. 119s Preparing to unpack .../25-libllvm10_1%3a10.0.0-4ubuntu1_arm64.deb ... 119s Unpacking libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 119s Selecting previously unselected package libclang-cpp10. 120s Preparing to unpack .../26-libclang-cpp10_1%3a10.0.0-4ubuntu1_arm64.deb ... 120s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 120s Selecting previously unselected package libgc1c2:arm64. 120s Preparing to unpack .../27-libgc1c2_1%3a7.6.4-0.4ubuntu1_arm64.deb ... 120s Unpacking libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 120s Selecting previously unselected package libobjc4:arm64. 120s Preparing to unpack .../28-libobjc4_10.5.0-1ubuntu1~20.04_arm64.deb ... 120s Unpacking libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 120s Selecting previously unselected package libobjc-9-dev:arm64. 120s Preparing to unpack .../29-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 120s Unpacking libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 120s Selecting previously unselected package libclang-common-10-dev. 120s Preparing to unpack .../30-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 120s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 121s Selecting previously unselected package libclang1-10. 121s Preparing to unpack .../31-libclang1-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 121s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 121s Selecting previously unselected package clang-10. 121s Preparing to unpack .../32-clang-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 121s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 121s Selecting previously unselected package emacsen-common. 121s Preparing to unpack .../33-emacsen-common_3.0.4_all.deb ... 121s Unpacking emacsen-common (3.0.4) ... 121s Selecting previously unselected package dictionaries-common. 121s Preparing to unpack .../34-dictionaries-common_1.28.1_all.deb ... 121s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 121s Unpacking dictionaries-common (1.28.1) ... 121s Selecting previously unselected package hunspell-en-us. 121s Preparing to unpack .../35-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 121s Unpacking hunspell-en-us (1:2018.04.16-1) ... 121s Selecting previously unselected package libpgtypes3:arm64. 121s Preparing to unpack .../36-libpgtypes3_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libpgtypes3:arm64 (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libpq5:arm64. 121s Preparing to unpack .../37-libpq5_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libpq5:arm64 (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libecpg6:arm64. 121s Preparing to unpack .../38-libecpg6_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libecpg6:arm64 (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libecpg-compat3:arm64. 121s Preparing to unpack .../39-libecpg-compat3_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libpq-dev. 121s Preparing to unpack .../40-libpq-dev_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libecpg-dev. 121s Preparing to unpack .../41-libecpg-dev_12.22-0ubuntu0.20.04.1_arm64.deb ... 121s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 121s Selecting previously unselected package libncurses-dev:arm64. 121s Preparing to unpack .../42-libncurses-dev_6.2-0ubuntu2.1_arm64.deb ... 121s Unpacking libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 121s Selecting previously unselected package libpython3.8:arm64. 121s Preparing to unpack .../43-libpython3.8_3.8.10-0ubuntu1~20.04.15_arm64.deb ... 121s Unpacking libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.15) ... 122s Selecting previously unselected package libtcl8.6:arm64. 122s Preparing to unpack .../44-libtcl8.6_8.6.10+dfsg-1_arm64.deb ... 122s Unpacking libtcl8.6:arm64 (8.6.10+dfsg-1) ... 122s Selecting previously unselected package libtinfo-dev:arm64. 122s Preparing to unpack .../45-libtinfo-dev_6.2-0ubuntu2.1_arm64.deb ... 122s Unpacking libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 122s Selecting previously unselected package libxslt1.1:arm64. 122s Preparing to unpack .../46-libxslt1.1_1.1.34-4ubuntu0.20.04.1_arm64.deb ... 122s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.1) ... 122s Selecting previously unselected package llvm-10-runtime. 122s Preparing to unpack .../47-llvm-10-runtime_1%3a10.0.0-4ubuntu1_arm64.deb ... 122s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 122s Selecting previously unselected package libpfm4:arm64. 122s Preparing to unpack .../48-libpfm4_4.10.1+git20-g7700f49-2_arm64.deb ... 122s Unpacking libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 122s Selecting previously unselected package llvm-10. 122s Preparing to unpack .../49-llvm-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 122s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 122s Selecting previously unselected package libffi-dev:arm64. 122s Preparing to unpack .../50-libffi-dev_3.3-4_arm64.deb ... 122s Unpacking libffi-dev:arm64 (3.3-4) ... 122s Selecting previously unselected package python3-pygments. 122s Preparing to unpack .../51-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 122s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 122s Selecting previously unselected package llvm-10-tools. 122s Preparing to unpack .../52-llvm-10-tools_1%3a10.0.0-4ubuntu1_arm64.deb ... 122s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 122s Selecting previously unselected package libz3-4:arm64. 122s Preparing to unpack .../53-libz3-4_4.8.7-4build1_arm64.deb ... 122s Unpacking libz3-4:arm64 (4.8.7-4build1) ... 123s Selecting previously unselected package libz3-dev:arm64. 123s Preparing to unpack .../54-libz3-dev_4.8.7-4build1_arm64.deb ... 123s Unpacking libz3-dev:arm64 (4.8.7-4build1) ... 123s Selecting previously unselected package llvm-10-dev. 123s Preparing to unpack .../55-llvm-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 123s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 125s Selecting previously unselected package net-tools. 125s Preparing to unpack .../56-net-tools_1.60+git20180626.aebd88e-1ubuntu1_arm64.deb ... 125s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 125s Selecting previously unselected package postgresql-client-common. 125s Preparing to unpack .../57-postgresql-client-common_214ubuntu0.1_all.deb ... 125s Unpacking postgresql-client-common (214ubuntu0.1) ... 125s Selecting previously unselected package postgresql-client-12. 125s Preparing to unpack .../58-postgresql-client-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 125s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 125s Selecting previously unselected package ssl-cert. 125s Preparing to unpack .../59-ssl-cert_1.0.39_all.deb ... 125s Unpacking ssl-cert (1.0.39) ... 125s Selecting previously unselected package postgresql-common. 125s Preparing to unpack .../60-postgresql-common_214ubuntu0.1_all.deb ... 125s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 125s Unpacking postgresql-common (214ubuntu0.1) ... 125s Selecting previously unselected package postgresql-12. 125s Preparing to unpack .../61-postgresql-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 125s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package postgresql-doc-12. 126s Preparing to unpack .../62-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 126s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package postgresql-plperl-12. 126s Preparing to unpack .../63-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 126s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package postgresql-plpython3-12. 126s Preparing to unpack .../64-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 126s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package postgresql-pltcl-12. 126s Preparing to unpack .../65-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 126s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package postgresql-server-dev-12. 126s Preparing to unpack .../66-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 126s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 126s Setting up postgresql-client-common (214ubuntu0.1) ... 126s Setting up libpgtypes3:arm64 (12.22-0ubuntu0.20.04.1) ... 126s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 126s Setting up libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 126s Setting up libpq5:arm64 (12.22-0ubuntu0.20.04.1) ... 126s Setting up linux-libc-dev:arm64 (5.4.0-208.228) ... 126s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 126s Setting up libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 126s Setting up libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 126s Setting up libffi-dev:arm64 (3.3-4) ... 126s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 126s 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 126s Setting up libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 126s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 127s Setting up libz3-4:arm64 (4.8.7-4build1) ... 127s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 128s 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 128s Setting up libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 128s Setting up emacsen-common (3.0.4) ... 128s Setting up ssl-cert (1.0.39) ... 128s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 128s Setting up libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.15) ... 128s Setting up postgresql-common (214ubuntu0.1) ... 128s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 128s Adding user postgres to group ssl-cert 128s 128s Creating config file /etc/postgresql-common/createcluster.conf with new version 128s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 128s en_us 128s Removing obsolete dictionary files: 129s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 129s Setting up libmpc3:arm64 (1.1.0-1) ... 129s Setting up libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 129s Setting up libtcl8.6:arm64 (8.6.10+dfsg-1) ... 129s Setting up binfmt-support (2.2.0-2) ... 129s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 130s Setting up libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 130s Setting up libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 130s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.1) ... 130s Setting up libecpg6:arm64 (12.22-0ubuntu0.20.04.1) ... 130s Setting up libisl22:arm64 (0.22.1-1) ... 130s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 131s Creating new PostgreSQL cluster 12/main ... 131s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 131s The files belonging to this database system will be owned by user "postgres". 131s This user must also own the server process. 131s 131s The database cluster will be initialized with locale "C.UTF-8". 131s The default database encoding has accordingly been set to "UTF8". 131s The default text search configuration will be set to "english". 131s 131s Data page checksums are disabled. 131s 131s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 131s creating subdirectories ... ok 131s selecting dynamic shared memory implementation ... posix 131s selecting default max_connections ... 100 131s selecting default shared_buffers ... 128MB 131s selecting default time zone ... Etc/UTC 131s creating configuration files ... ok 131s running bootstrap script ... ok 131s performing post-bootstrap initialization ... ok 131s syncing data to disk ... ok 131s 131s Success. You can now start the database server using: 131s 131s pg_ctlcluster 12 main start 131s 132s Ver Cluster Port Status Owner Data directory Log file 132s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 132s 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 134s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 134s Setting up libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 134s Setting up liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 134s Setting up libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 134s Setting up gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 134s Setting up libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 134s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 134s Setting up libz3-dev:arm64 (4.8.7-4build1) ... 134s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 134s Setting up libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.1) ... 134s Setting up dictionaries-common (1.28.1) ... 135s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 135s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 135s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 135s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 135s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 135s Setting up libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 135s Setting up hunspell-en-us (1:2018.04.16-1) ... 135s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up libc6-dev:arm64 (2.31-0ubuntu9.17) ... 135s Setting up libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 135s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 135s Setting up libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 135s Setting up libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up cpp (4:9.3.0-1ubuntu2) ... 135s Setting up libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 135s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up gcc (4:9.3.0-1ubuntu2) ... 135s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 135s Setting up g++ (4:9.3.0-1ubuntu2) ... 135s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 135s Setting up build-essential (12.8ubuntu1.1) ... 135s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 135s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 135s Processing triggers for systemd (245.4-4ubuntu3.24) ... 135s Processing triggers for man-db (2.9.1-1) ... 137s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 137s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 137s Processing triggers for dictionaries-common (1.28.1) ... 141s autopkgtest [13:53:14]: test run-testsuite: [----------------------- 141s Generating locales (this might take a while)... 143s en_US.UTF-8... done 143s ru_RU.ISO-8859-5... done 145s ru_RU.UTF-8... done 145s Generation complete. 145s ====== Running all tests with umask 077 ======= 145s === Running test 001_packages.t ... === 145s 1..18 145s # PostgreSQL versions installed: 12 145s ok 1 - postgresql-12 installed 145s ok 2 # skip No python2 support 145s ok 3 - postgresql-plpython3-12 installed 145s ok 4 - postgresql-plperl-12 installed 145s ok 5 - postgresql-pltcl-12 installed 145s ok 6 - postgresql-server-dev-12 installed 145s ok 7 # skip No postgresql-contrib-12 package for version 12 145s ok 8 - libecpg-dev installed 145s ok 9 - procps installed 145s ok 10 - netcat-openbsd installed 145s ok 11 - hunspell-en-us installed 145s ok 12 - system has a default UTF-8 locale 145s ok 13 - locale ru_RU exists 145s ok 14 - locale ru_RU.UTF-8 exists 145s ok 15 - user postgres in the UNIX group ssl-cert 145s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 145s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 145s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 145s === Running test 002_existing_clusters.t ... === 145s 1..8 145s ok 1 - Cleanup: No clusters left behind 145s ok 2 - No postgres processes left behind 145s ok 3 - No files in /etc/postgresql left behind 145s ok 4 - No files in /var/lib/postgresql left behind 145s ok 5 - No files in /var/run/postgresql left behind 145s ok 6 - No files in /var/log/postgresql left behind 145s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 145s ok 8 - PostgreSQL TCP ports are closed 145s === Running test 003_package_checks.t ... === 146s 1..4 146s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 146s ok 2 - psql is linked against libedit 146s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 146s ok 4 - psql is not linked against libreadline 146s === Running test 005_PgCommon.t ... === 146s 1..24 146s ok 1 - correctly parsed line 'local all postgres ident sameuser' 146s ok 2 - correctly parsed line 'local foo nobody trust' 146s ok 3 - correctly parsed line 'local foo nobody crypt' 146s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 146s ok 5 - correctly parsed line 'local foo,bar nobody ident' 146s ok 6 - correctly parsed line 'local all +foogrp password' 146s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 146s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 146s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 146s ok 10 - @expected_records has correct number of entries 146s ok 11 - returned read_pg_hba array has correct number of records 146s ok 12 - line 'foo all all md5' parsed as invalid 146s ok 13 - line 'local all all foo' parsed as invalid 146s ok 14 - line 'host all all foo' parsed as invalid 146s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 146s ok 16 - line 'host all all md5' parsed as invalid 146s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 146s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 146s ok 19 - read_conf_file returns empty dict for nonexisting file 146s ok 20 - read_conf_file() parsing 146s ok 21 - read_conf_file() parsing with include directives 146s ok 22 - set_conf_value 146s ok 23 - disable_conf_value 146s ok 24 - replace_conf_value 146s === Running test 006_next_free_port.t ... === 146s 1..5 146s ok 1 - next_free_port is 5432 147s ok 2 - next_free_port detects localhost ipv4 socket 147s ok 3 - next_free_port detects wildcard ipv4 socket 148s ok 4 - next_free_port detects localhost ipv6 socket 148s ok 5 - next_free_port detects wildcard ipv6 socket 148s === Running test 007_pg_conftool.t ... === 148s 1..41 148s # test without cluster 148s ok 1 - pg_conftool show all 148s ok 2 - correct output of pg_conftool show all 148s ok 3 - pg_conftool foo.conf show all 148s ok 4 - correct output of pg_conftool foo.conf show all 148s ok 5 - pg_conftool /tmp/A2VCY6cEMx/different.conf show all 148s ok 6 - correct output of pg_conftool /tmp/A2VCY6cEMx/different.conf show all 148s ok 7 - pg_conftool 9.7 main show all 148s ok 8 - correct output of pg_conftool 9.7 main show all 148s # test show 148s ok 9 - pg_conftool show all 148s ok 10 - correct output of pg_conftool show all 148s ok 11 - pg_conftool other.conf show all 148s ok 12 - correct output of pg_conftool other.conf show all 148s ok 13 - pg_conftool /tmp/A2VCY6cEMx/different.conf show all 148s ok 14 - correct output of pg_conftool /tmp/A2VCY6cEMx/different.conf show all 149s ok 15 - pg_conftool 12 main show all 149s ok 16 - correct output of pg_conftool 12 main show all 149s ok 17 - pg_conftool 12 main other.conf show all 149s ok 18 - correct output of pg_conftool 12 main other.conf show all 149s ok 19 - pg_conftool show a 149s ok 20 - correct output of pg_conftool show a 149s ok 21 - pg_conftool -s show a 149s ok 22 - correct output of pg_conftool -s show a 149s # test set 149s ok 23 - pg_conftool set c 7 149s ok 24 - correct output of pg_conftool set c 7 149s ok 25 - file contains new setting 149s ok 26 - pg_conftool set a 8 149s ok 27 - correct output of pg_conftool set a 8 149s ok 28 - file contains updated setting 149s ok 29 - pg_conftool /tmp/A2VCY6cEMx/different.conf set a 9 149s ok 30 - correct output of pg_conftool /tmp/A2VCY6cEMx/different.conf set a 9 149s ok 31 - file with path contains updated setting 149s # test remove 149s ok 32 - pg_conftool remove a 149s ok 33 - correct output of pg_conftool remove a 149s ok 34 - setting removed from file 149s ok 35 - pg_conftool /tmp/A2VCY6cEMx/different.conf remove a 149s ok 36 - correct output of pg_conftool /tmp/A2VCY6cEMx/different.conf remove a 149s ok 37 - setting removed from file with path 149s # test edit 149s ok 38 - pg_conftool edit 149s ok 39 - correct output of pg_conftool edit 149s ok 40 - pg_conftool /tmp/A2VCY6cEMx/different.conf edit 149s ok 41 - correct output of pg_conftool /tmp/A2VCY6cEMx/different.conf edit 149s === Running test 010_defaultport_cluster.t ... === 149s 1..14 149s ok 1 - psql --version 149s ok 2 - pg_wrapper selects highest available version number 149s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 149s ok 4 - connecting to localhost fails with no clusters 149s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 149s ok 6 - pg_wrapper uses host and port from PGCLUSTER 149s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 149s ok 8 - pg_wrapper uses --cluster from the command line 149s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 149s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 149s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 149s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 149s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 149s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 149s === Running test 015_start_stop.t ... === 149s 1..71 149s # We are running systemd 149s # Running tests for 12 149s # Cluster does not exist yet 149s ok 1 - cluster 12 main does not exist 149s ok 2 - service postgresql@12-main does not exist 149s ok 3 - systemctl start postgresql 149s ok 4 - cluster 12 main does not exist 149s ok 5 - service postgresql@12-main does not exist 149s ok 6 - systemctl start postgresql@12-main 149s ok 7 - cluster 12 main does not exist 149s ok 8 - service postgresql@12-main does not exist 149s # Start/stop postgresql using system tools 150s ok 9 - pg_createcluster 12 main 150s ok 10 - cluster 12 main is stopped 150s ok 11 - service postgresql@12-main is stopped 153s ok 12 - systemctl start postgresql 153s ok 13 - cluster 12 main is running 153s ok 14 - service postgresql@12-main is running 153s ok 15 - systemctl start postgresql 153s ok 16 - cluster 12 main is already running 153s ok 17 - service postgresql@12-main is already running 153s ok 18 - systemctl stop postgresql 159s ok 19 - cluster 12 main is stopped 159s ok 20 - service postgresql@12-main is stopped 159s ok 21 - systemctl stop postgresql 159s ok 22 - cluster 12 main is already stopped 159s ok 23 - service postgresql@12-main is already stopped 159s # Start/stop specific cluster using system tools 161s ok 24 - systemctl start postgresql@12-main 161s ok 25 - cluster 12 main is running 161s ok 26 - service postgresql@12-main is running 161s ok 27 - systemctl start postgresql@12-main 161s ok 28 - cluster 12 main is running 161s ok 29 - service postgresql@12-main is running 163s ok 30 - systemctl restart postgresql@12-main 164s ok 31 - cluster 12 main is running 164s ok 32 - service postgresql@12-main is running 164s ok 33 - systemctl stop postgresql@12-main 164s ok 34 - cluster 12 main is stopped 164s ok 35 - service postgresql@12-main is stopped 164s ok 36 - systemctl stop postgresql@12-main 164s ok 37 - cluster 12 main is already stopped 164s ok 38 - service postgresql@12-main is already stopped 164s ok 39 - pg_dropcluster 12 main 164s ok 40 - cluster 12 main does not exist 164s ok 41 - service postgresql@12-main does not exist 164s # Start/stop specific cluster using pg_*cluster 164s ok 42 - pg_ctlcluster start 12 main 164s ok 43 - cluster 12 main does not exist 164s ok 44 - service postgresql@12-main does not exist 167s ok 45 - pg_createcluster 12 main --start 167s ok 46 - cluster 12 main is running 167s ok 47 - service postgresql@12-main is running 167s ok 48 - pg_ctlcluster 12 main start 167s ok 49 - cluster 12 main is already running 167s ok 50 - service postgresql@12-main is already running 170s ok 51 - pg_ctlcluster 12-main restart 170s ok 52 - cluster 12 main is running 170s ok 53 - service postgresql@12-main is running 170s ok 54 - pg_ctlcluster 12 main stop 170s ok 55 - cluster 12 main is stopped 170s ok 56 - service postgresql@12-main is stopped 170s ok 57 - pg_ctlcluster 12 main stop 170s ok 58 - cluster 12 main is already stopped 170s ok 59 - service postgresql@12-main is already stopped 172s ok 60 - pg_ctlcluster start 12-main 172s ok 61 - cluster 12 main is running 172s ok 62 - service postgresql@12-main is running 173s ok 63 - pg_dropcluster 12 main --stop 173s ok 64 - Cleanup: No clusters left behind 173s ok 65 - No postgres processes left behind 173s ok 66 - No files in /etc/postgresql left behind 173s ok 67 - No files in /var/lib/postgresql left behind 173s ok 68 - No files in /var/run/postgresql left behind 173s ok 69 - No files in /var/log/postgresql left behind 173s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 173s ok 71 - PostgreSQL TCP ports are closed 173s === Running test 020_create_sql_remove.t ... === 173s 1..144 173s # Running tests for 12 176s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.vOudnG 176s ok 2 - pg_createcluster 12 main 176s ok 3 - Socket and pid file are in /var/run/postgresql/ 176s ok 4 - xlog/wal directory /tmp/12.xlog.vOudnG was created 176s ok 5 - Exactly one postgres master process running 178s ok 6 - pg_ctlcluster 12 main restart 178s ok 7 - cluster restarts with new environment file 178s ok 8 - Exactly one postgres master process running 178s ok 9 - correct value of PGEXTRAVAR1 in environment 178s ok 10 - correct value of PGEXTRAVAR2 in environment 178s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 178s ok 12 - createdb --version 178s ok 13 - pg_wrapper selects version number of cluster 179s ok 14 - psql --version 179s ok 15 - pg_wrapper selects version number of cluster 179s ok 16 - pg_lscluster reports online cluster on port 5432 179s ok 17 - log file is actually used 179s ok 18 - /etc/postgresql is owned by user "postgres" 179s ok 19 - version configuration directory file is owned by user "postgres" 179s ok 20 - configuration directory file is owned by user "postgres" 179s ok 21 - version data directory file is owned by user "postgres" 179s ok 22 - data directory file is owned by user "postgres" 179s ok 23 - log file has 0640 permissions 179s ok 24 - log file is owned by user "postgres" 179s ok 25 - log file is owned by group "adm" 179s ok 26 - no log symlink by default 179s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 179s ok 28 - pg_lsclusters -h 179s ok 29 - correct output of pg_lsclusters -h 179s ok 30 - stopping cluster 181s ok 31 - restarting cluster with nondefault log symlink 181s ok 32 - log target is used as log file 181s ok 33 - default log is not used 181s ok 34 - pg_lsclusters -h 181s ok 35 - correct output of pg_lsclusters -h 181s ok 36 - stopping cluster 183s ok 37 - restarting cluster with explicitly configured log file 183s ok 38 - default log is not used 183s ok 39 - log symlink target is used for startup message 183s ok 40 - exactly one log file 183s ok 41 - custom log is actually used 183s ok 42 - pg_lsclusters -h 183s ok 43 - correct output of pg_lsclusters -h 184s ok 44 - stopping cluster 184s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 184s ok 46 - /etc/postgres-hack was not created 186s ok 47 - restarting cluster 186s ok 48 - ps -o tty -U postgres h 186s ok 49 - postgres processes do not have an associated terminal 186s ok 50 - SSL is enabled 186s ok 51 - psql -l fails for nobody 186s ok 52 - createuser nobody 186s ok 53 - createdb nobodydb 186s ok 54 - psql -ltA succeeds for nobody 186s ok 55 - psql -ltA output 186s ok 56 - SQL command: create table 186s ok 57 - SQL command: insert into table values 186s ok 58 - SQL command: insert into table values 186s ok 59 - primary key violation 186s ok 60 - psql -tAc "select * from phone order by name" nobodydb 186s ok 61 - SQL command output: select -tA 186s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 186s ok 63 - SQL command output: select -tx 186s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 186s ok 65 - SQL command output: select -tAx 186s ok 66 - CREATE EXTENSION plperlu fails for user nobody 186s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 186s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 186s ok 69 - creating PL/PerlU function as user nobody fails 186s ok 70 - creating unsafe PL/Perl function as user postgres fails 187s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 187s ok 72 - creating PL/PerlU function as user postgres succeeds 187s ok 73 - psql nobodydb -Atc "select read_file()" 187s ok 74 - calling PL/PerlU function 187s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 187s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 187s ok 77 - creating unsafe PL/Perl function as user nobody fails 187s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 187s ok 79 - creating PL/Perl function as user nobody succeeds 187s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 187s ok 81 - calling PL/Perl function 187s ok 82 # skip No python2 support 187s ok 83 # skip No python2 support 187s ok 84 # skip No python2 support 187s ok 85 # skip No python2 support 187s ok 86 # skip No python2 support 187s ok 87 # skip No python2 support 187s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 187s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 187s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 187s ok 91 - creating PL/Python3 function as user postgres succeeds 187s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 187s ok 93 - calling PL/Python function 187s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 187s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 187s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 187s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 187s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 187s ok 99 - creating PL/Tcl function as user nobody succeeds 187s 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;" 187s ok 101 - creating PL/TclU function as user postgres succeeds 187s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 187s ok 103 - calling PL/Tcl function 187s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 187s ok 105 - calling PL/TclU function 188s ok 106 - stopping cluster 188s ok 107 - pg_ctlcluster 12 main start 188s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 190s ok 109 - pg_ctlcluster 12 main start 190s ok 110 - cluster restarts with pgdata symlink 190s ok 111 - postgres master has OOM killer protection 190s ok 112 - postgres client backend has no OOM adjustment 190s ok 113 - ps h 8180 190s ok 114 - process title is idle 191s ok 115 - ps h 8180 191s ok 116 - process title is idle in transaction 191s ok 117 - ps h 8180 191s ok 118 - process title is SELECT 193s ok 119 - dropdb nobodydb 193s ok 120 - dropuser nobody 194s ok 121 - stopping cluster 196s ok 122 - starting cluster as postgres works without a log file 196s ok 123 - log file got recreated and used 196s ok 124 - creating a directory in spc2 196s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.0kw7RG'" 196s ok 126 - creating tablespace spc1 196s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 196s ok 128 - creating a table in spc1 196s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.25KUDo'" 196s ok 130 - creating tablespace spc2 196s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 196s ok 132 - creating a table in spc2 196s ok 133 - pg_dropcluster removes cluster 196s ok 134 - xlog/wal directory /tmp/12.xlog.vOudnG was deleted 196s ok 135 - tablespace spc1 was emptied 196s ok 136 - tablespace spc2 was emptied 196s ok 137 - Cleanup: No clusters left behind 196s ok 138 - No postgres processes left behind 196s ok 139 - No files in /etc/postgresql left behind 196s ok 140 - No files in /var/lib/postgresql left behind 196s ok 141 - No files in /var/run/postgresql left behind 196s ok 142 - No files in /var/log/postgresql left behind 196s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 196s ok 144 - PostgreSQL TCP ports are closed 196s === Running test 021_pg_renamecluster.t ... === 196s 1..20 200s ok 1 - pg_createcluster 12 main 202s ok 2 - pg_renamecluster 12 main donau 202s ok 3 - psql -tAc "show data_directory" 202s ok 4 - cluster is running and data_directory was moved 202s ok 5 - pg_hba.conf location updated 202s ok 6 - pg_ident.conf location updated 202s ok 7 - external_pid_file location updated 202s ok 8 - external_pid_file exists 202s ok 9 - stats_temp_directory location updated 202s ok 10 - stats_temp_directory exists 202s ok 11 - cluster_name is updated 203s ok 12 - pg_dropcluster removes cluster 203s ok 13 - Cleanup: No clusters left behind 203s ok 14 - No postgres processes left behind 203s ok 15 - No files in /etc/postgresql left behind 203s ok 16 - No files in /var/lib/postgresql left behind 203s ok 17 - No files in /var/run/postgresql left behind 203s ok 18 - No files in /var/log/postgresql left behind 203s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 203s ok 20 - PostgreSQL TCP ports are closed 203s === Running test 022_recovery.t ... === 203s 1..17 203s # Running tests for 12 206s ok 1 - pg_createcluster 12 main --start >/dev/null 206s ok 2 - pg_ctlcluster 12 main stop -m i 208s ok 3 - pg_ctlcluster 12 main start 208s ok 4 - psql -c '' 209s ok 5 - pg_ctlcluster 12 main stop -m i 209s ok 6 - create write-protected file in data directory 211s ok 7 - pg_ctlcluster 12 main start 211s ok 8 - psql -c '' 211s ok 9 - pg_dropcluster removes cluster 211s ok 10 - Cleanup: No clusters left behind 212s ok 11 - No postgres processes left behind 212s ok 12 - No files in /etc/postgresql left behind 212s ok 13 - No files in /var/lib/postgresql left behind 212s ok 14 - No files in /var/run/postgresql left behind 212s ok 15 - No files in /var/log/postgresql left behind 212s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 212s ok 17 - PostgreSQL TCP ports are closed 212s === Running test 025_logging.t ... === 212s 1..55 212s # Logging to /var/log/syslog works 212s # Running tests for 12 215s ok 1 - pg_createcluster 12 main 215s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 215s ok 3 - psql -qc "'foobar_12_8796'" 215s ok 4 - log an error 215s ok 5 - grep --binary-files=text foobar_12_8796 /var/log/postgresql/postgresql-12-main.log 215s ok 6 - error appears in logfile 215s ok 7 - pg_conftool 12 main set log_destination syslog 215s ok 8 - set log_destination syslog 215s ok 9 - pg_ctlcluster 12 main reload 215s ok 10 - 12 main reload 215s ok 11 - psql -Atc "show log_destination" 215s ok 12 - log_destination is syslog 215s ok 13 - pg_lscluster reports syslog 216s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 216s ok 15 - error appears in /var/log/syslog 216s ok 16 - pg_conftool 12 main set logging_collector on 216s ok 17 - set logging_collector on 216s ok 18 - pg_conftool 12 main set log_destination csvlog 216s ok 19 - set log_destination csvlog 218s ok 20 - pg_ctlcluster 12 main restart 218s ok 21 - 12 main restart 218s ok 22 - psql -Atc "show logging_collector" 218s ok 23 - logging_collector is on 219s ok 24 - psql -Atc "show log_destination" 219s ok 25 - log_destination is csvlog 219s ok 26 - pg_lscluster reports csvlog 219s ok 27 - psql -qc "'barbaz_12_8796'" 219s ok 28 - log an error 219s ok 29 - grep --binary-files=text barbaz_12_8796 /var/lib/postgresql/12/main/log/*.csv 219s ok 30 - error appears in log/*.csv 219s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 219s ok 32 - set log_destination stderr,syslog,csvlog 219s ok 33 - pg_ctlcluster 12 main reload 219s ok 34 - 12 main reload 219s ok 35 - psql -Atc "show log_destination" 219s ok 36 - log_destination is stderr,syslog,csvlog 219s ok 37 - pg_lscluster reports stderr,syslog,csvlog 219s ok 38 - psql -qc "'moo_12_8796'" 219s ok 39 - log an error 219s ok 40 - grep --binary-files=text moo_12_8796 /var/lib/postgresql/12/main/log/*.log 219s ok 41 - error appears in log/*.log 219s ok 42 - grep --binary-files=text 'postgres.*moo_12_8796' /var/log/syslog 219s ok 43 - error appears in /var/log/syslog 219s ok 44 - grep --binary-files=text moo_12_8796 /var/lib/postgresql/12/main/log/*.csv 219s ok 45 - error appears in log/*.csv 220s ok 46 - pg_dropcluster 12 main --stop 220s ok 47 - pg_dropcluster removes cluster 220s ok 48 - Cleanup: No clusters left behind 220s ok 49 - No postgres processes left behind 220s ok 50 - No files in /etc/postgresql left behind 220s ok 51 - No files in /var/lib/postgresql left behind 220s ok 52 - No files in /var/run/postgresql left behind 220s ok 53 - No files in /var/log/postgresql left behind 220s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 220s ok 55 - PostgreSQL TCP ports are closed 220s === Running test 030_errors.t ... === 220s 1..149 220s ok 1 - pg_lscluster reports cluster without binaries 220s ok 2 - pg_dropcluster 6.3 main 221s ok 3 - pg_createcluster --socketdir 221s ok 4 - pg_lsclusters -h 221s ok 5 - cluster was created 221s ok 6 - Port of created cluster is 5432 221s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 221s ok 8 - pg_createcluster on existing cluster 221s ok 9 - pg_lsclusters -h 221s ok 10 - original cluster still exists 221s ok 11 - pg_createcluster 12 test -p foo 221s ok 12 - pg_createcluster -p checks that port option is numeric 221s ok 13 - pg_createcluster 12 test -p 42 221s ok 14 - pg_createcluster -p checks valid port range 221s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 221s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 221s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 223s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 223s ok 19 - No sockets in /var/run/postgresql 223s ok 20 - Socket is in /tmp/postgresql-testsuite/ 224s ok 21 - cluster stops with custom unix_socket_dir 224s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 226s ok 23 - cluster starts after removing unix_socket_dir 226s ok 24 - Socket is in default dir /var/run/postgresql 226s ok 25 - No sockets in /tmp/postgresql-testsuite/ 226s ok 26 - pg_ctlcluster 12 main stop 226s ok 27 - pg_ctlcluster fails with corrupted PID file 226s ok 28 - pg_lsclusters -h 226s ok 29 - cluster is still online 226s ok 30 - pg_ctlcluster succeeds with restored PID file 226s ok 31 - pg_lsclusters -h 226s ok 32 - cluster is down 226s ok 33 - pg_ctlcluster 12 main stop 226s ok 34 - pg_ctlcluster stop fails on stopped cluster 228s ok 35 - pg_ctlcluster 12 main start 228s ok 36 - pg_ctlcluster succeeds with already existing PID file 228s ok 37 - pg_lsclusters -h 228s ok 38 - cluster is online 229s ok 39 - pg_ctlcluster stop succeeds 229s ok 40 - pg_lsclusters -h 229s ok 41 - cluster is down 229s ok 42 - no pid file left 229s ok 43 - pg_ctlcluster 12 main stop 229s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 229s ok 45 - pid file was cleaned up 229s ok 46 - pg_ctlcluster --force 12 main stop 229s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 229s ok 48 - pid file was cleaned up 229s ok 49 - pg_ctlcluster 12 main stop 229s ok 50 - pg_ctlcluster stop succeeds with stale PID file 229s ok 51 - pid file was cleaned up 229s ok 52 - pg_ctlcluster --force 12 main stop 229s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 229s ok 54 - pid file was cleaned up 229s ok 55 - pg_ctlcluster --force 12 main stop 229s ok 56 - pg_ctlcluster stop succeeds with empty PID file 229s ok 57 - pid file was cleaned up 231s ok 58 - pg_ctlcluster 12 main start 231s ok 59 - pg_ctlcluster succeeds with corrupted PID file 231s ok 60 - pg_lsclusters -h 231s ok 61 - cluster is online 231s ok 62 - pg_ctlcluster 12 main start 231s ok 63 - pg_ctlcluster start fails on running cluster 231s ok 64 - pg_ctlcluster stop 231s ok 65 - pg_ctlcluster 12 main start 231s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 231s ok 67 - pg_ctlcluster 12 main stop 231s ok 68 - stopping cluster 238s ok 69 - pg_ctlcluster 12 main start 238s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 238s ok 71 - pg_ctlcluster 12 main stop 238s ok 72 - stopping cluster 238s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 238s ok 74 - pg_dropcluster 12 main 238s ok 75 - pg_dropcluster works as user postgres 239s ok 76 - pg_createcluster succeeds 239s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 239s ok 78 - proper error message for nonexisting /var/lib/postgresql 241s ok 79 - pg_ctlcluster 12 main start 241s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 241s ok 81 - pg_ctlcluster 12 main stop 241s ok 82 - stopping cluster 242s ok 83 - pg_createcluster other 244s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 246s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 247s ok 86 247s ok 87 - pg_ctlcluster 12 other start 247s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 247s ok 89 - pg_ctlcluster 12 main stop 247s ok 90 - stopping main cluster 249s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 249s ok 92 - pg_dropcluster other 250s ok 93 - pg_dropcluster 250s ok 94 - No sockets any more 250s ok 95 - 'pg_lsclusters 4.5 foo' fails 250s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 250s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 250s ok 98 - 'psql --cluster 4.5/foo' fails 250s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 250s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 250s ok 101 - 'psql --cluster 12/foo' fails 250s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 250s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 250s ok 104 - 'pg_dropcluster 4.5 foo' fails 250s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 250s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 250s ok 107 - 'pg_dropcluster 12 foo' fails 250s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 250s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 250s ok 110 - 'pg_upgradecluster 4.5 foo' fails 250s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 250s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 250s ok 113 - 'pg_upgradecluster 12 foo' fails 250s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 250s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 250s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 250s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 250s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 250s ok 119 - 'pg_ctlcluster 12 foo stop' fails 250s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 250s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 250s ok 122 - Cleanup: No clusters left behind 250s ok 123 - No postgres processes left behind 250s ok 124 - No files in /etc/postgresql left behind 250s ok 125 - No files in /var/lib/postgresql left behind 250s ok 126 - No files in /var/run/postgresql left behind 250s ok 127 - No files in /var/log/postgresql left behind 250s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 250s ok 129 - PostgreSQL TCP ports are closed 250s ok 130 - pg_dropcluster 12 broken 250s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 250s ok 132 - Cleanup: No clusters left behind 250s ok 133 - No postgres processes left behind 250s ok 134 - No files in /etc/postgresql left behind 250s ok 135 - No files in /var/lib/postgresql left behind 250s ok 136 - No files in /var/run/postgresql left behind 250s ok 137 - No files in /var/log/postgresql left behind 250s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 250s ok 139 - PostgreSQL TCP ports are closed 250s ok 140 - pg_dropcluster 12 broken 250s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 250s ok 142 - Cleanup: No clusters left behind 250s ok 143 - No postgres processes left behind 250s ok 144 - No files in /etc/postgresql left behind 250s ok 145 - No files in /var/lib/postgresql left behind 250s ok 146 - No files in /var/run/postgresql left behind 250s ok 147 - No files in /var/log/postgresql left behind 250s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 250s ok 149 - PostgreSQL TCP ports are closed 250s === Running test 031_errors_disk_full.t ... === 250s 1..22 250s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 251s ok 1 - script failed 251s ok 2 - pg_createcluster fails due to insufficient disk space 251s ok 3 - does not leave files behind 251s ok 4 - Cleanup: No clusters left behind 251s ok 5 - No postgres processes left behind 251s ok 6 - No files in /etc/postgresql left behind 251s ok 7 - No files in /var/lib/postgresql left behind 251s ok 8 - No files in /var/run/postgresql left behind 251s ok 9 - No files in /var/log/postgresql left behind 251s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 251s ok 11 - PostgreSQL TCP ports are closed 251s # check disk full conditions on startup 252s ok 12 - script failed 252s ok 13 - pg_ctlcluster prints error message 252s ok 14 - log file has error message 252s ok 15 - Cleanup: No clusters left behind 252s ok 16 - No postgres processes left behind 252s ok 17 - No files in /etc/postgresql left behind 252s ok 18 - No files in /var/lib/postgresql left behind 252s ok 19 - No files in /var/run/postgresql left behind 252s ok 20 - No files in /var/log/postgresql left behind 252s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 252s ok 22 - PostgreSQL TCP ports are closed 252s === Running test 032_ssl_key_permissions.t ... === 252s 1..22 252s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 252s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 252s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 252s # 12 (12.22-0ubuntu0.20.04.1) 253s ok 4 - pg_createcluster 12 main 253s ok 5 - pg_ctlcluster 12 main start 253s ok 6 - ssl key owned by nobody refused 253s ok 7 - pg_ctlcluster 12 main start 253s ok 8 - ssl key with permissions root:root 0644 refused 253s ok 9 - pg_ctlcluster 12 main start 253s ok 10 - ssl key with permissions postgres:postgres 0640 refused 254s ok 11 - pg_dropcluster 12 main --stop 254s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 254s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 254s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 254s ok 15 - Cleanup: No clusters left behind 254s ok 16 - No postgres processes left behind 254s ok 17 - No files in /etc/postgresql left behind 254s ok 18 - No files in /var/lib/postgresql left behind 254s ok 19 - No files in /var/run/postgresql left behind 254s ok 20 - No files in /var/log/postgresql left behind 254s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 254s ok 22 - PostgreSQL TCP ports are closed 254s === Running test 040_upgrade.t ... === 254s 1..1 254s ok 1 - only one major version installed, skipping upgrade tests 254s === Running test 041_upgrade_custompaths.t ... === 254s 1..1 254s ok 1 - only one major version installed, skipping upgrade tests 254s === Running test 043_upgrade_ssl_cert.t ... === 254s 1..1 254s ok 1 - only one major version installed, skipping upgrade tests 254s === Running test 050_encodings.t ... === 254s 1..60 254s # Checking 12 ru_RU 257s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 258s ok 2 - psql -l succeeds 258s ok 3 - template1 is not UTF-8 encoded 258s ok 4 - creating test database 258s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 258s # create table t (x varchar); copy t from stdin" test 258s ok 6 - creating table with ISO-8859-5 characters 258s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 258s ok 8 - correct string in UTF-8 258s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 258s ok 10 - correct string in ISO-8859-5 258s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 258s # delete from t; copy t from stdin" test 258s ok 12 - creating table with UTF-8 characters 258s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 258s ok 14 - correct string in UTF-8 258s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 258s ok 16 - correct string in ISO-8859-1 259s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 259s ok 18 - Server error message has correct language and encoding 261s ok 19 - pg_ctlcluster 12 ru_RU restart 261s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 261s ok 21 - Dropping cluster 261s # Checking 12 ru_RU.UTF-8 264s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 266s ok 23 - psql -l succeeds 266s ok 24 - template1 is UTF-8 encoded 266s ok 25 - creating test database 266s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 266s # create table t (x varchar); copy t from stdin" test 266s ok 27 - creating table with ISO-8859-5 characters 266s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 266s ok 29 - correct string in UTF-8 266s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 266s ok 31 - correct string in ISO-8859-5 266s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 266s # delete from t; copy t from stdin" test 266s ok 33 - creating table with UTF-8 characters 266s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 266s ok 35 - correct string in UTF-8 266s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 266s ok 37 - correct string in ISO-8859-1 266s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 266s ok 39 - Server error message has correct language and encoding 269s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 269s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 269s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 269s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 269s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 269s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 269s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 269s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 269s ok 48 - Dropping cluster 269s # Check 12 locale environment variables 272s ok 49 - pg_createcluster: LC_ALL dominates LANG 272s ok 50 - psql -Atl --cluster 12/main 272s ok 51 - template1 is ASCII encoded 273s ok 52 - Dropping cluster 273s ok 53 - Cleanup: No clusters left behind 273s ok 54 - No postgres processes left behind 273s ok 55 - No files in /etc/postgresql left behind 273s ok 56 - No files in /var/lib/postgresql left behind 273s ok 57 - No files in /var/run/postgresql left behind 273s ok 58 - No files in /var/log/postgresql left behind 273s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 273s ok 60 - PostgreSQL TCP ports are closed 273s === Running test 052_upgrade_encodings.t ... === 273s 1..1 273s ok 1 - only one major version installed, skipping upgrade tests 273s === Running test 060_obsolete_confparams.t ... === 273s 1..1 273s ok 1 - only one major version installed, skipping upgrade tests 273s === Running test 070_non_postgres_clusters.t ... === 273s 1..40 274s ok 1 - pg_createcluster 12 main for owner nobody 274s ok 2 - pg_ctlcluster 12 main start 274s ok 3 - start refused when config and data owners mismatch 276s ok 4 - pg_ctlcluster succeeds with owner nobody 276s ok 5 - pg_lsclusters -h 276s ok 6 - pg_lsclusters shows running cluster 276s ok 7 - postgres is running as user nobody 276s ok 8 - ls /tmp/.s.PGSQL.* 276s ok 9 - socket is in /tmp 276s ok 10 - /var/run/postgresql is empty 276s ok 11 - conf dir is owned by user 276s ok 12 - conf dir is owned by user's primary group 276s ok 13 - files are owned by user 276s ok 14 - files are owned by user's primary group 276s ok 15 - log file has 0640 permissions 276s ok 16 - log file is owned by user 276s ok 17 - log file is owned by user's primary group 276s ok 18 - only one major version installed, skipping upgrade test 276s ok 19 - ... 276s ok 20 - ... 276s ok 21 - ... 276s ok 22 - ... 276s ok 23 - ... 276s ok 24 - ... 276s ok 25 - ... 276s ok 26 - ... 276s ok 27 - ... 276s ok 28 - ... 276s ok 29 - pg_dropcluster 277s ok 30 - pg_lsclusters -h 277s ok 31 - No clusters left 277s ok 32 - No postgres processes left 277s ok 33 - Cleanup: No clusters left behind 277s ok 34 - No postgres processes left behind 277s ok 35 - No files in /etc/postgresql left behind 277s ok 36 - No files in /var/lib/postgresql left behind 277s ok 37 - No files in /var/run/postgresql left behind 277s ok 38 - No files in /var/log/postgresql left behind 277s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 277s ok 40 - PostgreSQL TCP ports are closed 277s === Running test 080_start.conf.t ... === 277s 1..73 277s ok 1 - pg_createcluster 12 main 277s # start.conf auto 277s ok 2 - get_cluster_start_conf returns auto 277s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 277s ok 4 - start.conf contains auto 277s ok 5 - systemd generator links cluster 277s 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 283s ok 13 - pg_lsclusters -h 283s ok 14 - cluster is down 283s # start.conf manual 283s ok 15 - get_cluster_start_conf returns manual 283s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 283s ok 17 - start.conf contains manual 283s ok 18 - systemd generator doesn't link cluster 283s ok 19 - /etc/init.d/postgresql start 12 283s ok 20 - correct output of /etc/init.d/postgresql start 12 283s ok 21 - pg_lsclusters -h 283s ok 22 - cluster is down 285s ok 23 - pg_ctlcluster 12 main start 285s ok 24 - correct output of pg_ctlcluster 12 main start 285s ok 25 - pg_lsclusters -h 285s ok 26 - cluster is online 285s ok 27 - pg_ctlcluster 12 main stop 285s ok 28 - correct output of pg_ctlcluster 12 main stop 285s ok 29 - pg_lsclusters -h 285s ok 30 - cluster is down 285s # start.conf disabled 285s 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 288s ok 43 - pg_lsclusters -h 288s ok 44 - cluster is online 288s ok 45 - pg_ctlcluster 12 main stop 288s ok 46 - correct output of pg_ctlcluster 12 main stop 288s ok 47 - pg_lsclusters -h 288s ok 48 - cluster is down 290s ok 49 - pg_ctlcluster 12 main start 290s ok 50 - correct output of pg_ctlcluster 12 main start 290s ok 51 - pg_lsclusters -h 290s ok 52 - cluster is online 290s # test upgrade 290s ok 53 - only one major version installed, skipping upgrade test 290s ok 54 - ... 290s ok 55 - get_cluster_start_conf for old cluster returns manual 290s ok 56 - get_cluster_start_conf for new cluster returns manual 290s 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 291s ok 63 - pg_createcluster checks --start-conf manual 291s ok 64 - get_cluster_start_conf returns manual 291s ok 65 - dropping cluster 291s ok 66 - Cleanup: No clusters left behind 291s ok 67 - No postgres processes left behind 291s ok 68 - No files in /etc/postgresql left behind 291s ok 69 - No files in /var/lib/postgresql left behind 291s ok 70 - No files in /var/run/postgresql left behind 291s ok 71 - No files in /var/log/postgresql left behind 291s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 291s ok 73 - PostgreSQL TCP ports are closed 291s === 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 302s ok 17 - pg_ctlcluster 12 main restart -- -c 302s ok 18 - restarting cluster with -c on the command line 302s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 302s 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 303s ok 1 - pg_createcluster 12 old 304s ok 2 - pg_createcluster 12 new1 305s ok 3 - pg_createcluster 12 new2 307s ok 4 - starting cluster 12/old 309s ok 5 - starting cluster 12/new1 311s ok 6 - starting cluster 12/new2 311s ok 7 - pg_lsclusters -h | sort -k3 311s ok 8 - clusters have the correct ports, skipping used 5433 311s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 312s ok 10 - createdb --version 312s ok 11 - pg_wrapper selects port 5432 as default cluster 312s ok 12 - createdb --cluster 12/new1 --version 312s ok 13 - pg_wrapper --cluster works 312s ok 14 - createdb --cluster 12/foo --version 312s ok 15 - pg_wrapper --cluster errors out for invalid cluster 312s ok 16 - createdb --cluster 12/new1 test 312s ok 17 - correct output of createdb --cluster 12/new1 test 312s ok 18 - psql -Atl --cluster 12/new1 312s ok 19 - test db appears in cluster new1 312s ok 20 - psql -Atl --cluster 12/new2 312s ok 21 - test db does not appear in cluster new2 312s ok 22 - psql -Atl 312s ok 23 - test db does not appear in default cluster 312s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 312s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 312s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 312s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 312s ok 28 - psql -Atl --cluster 12/localhost:5434 312s ok 29 - test db appears in cluster 12/localhost:5434 312s ok 30 - psql -Atl --cluster 12/localhost:5440 312s ok 31 - test db does not appear in cluster 12/localhost:5440 312s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 312s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 312s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 312s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 312s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 312s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 312s ok 38 - psql -Atl --cluster 6.4/localhost: 312s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 312s ok 40 - psql -Atl 312s ok 41 - PGCLUSTER selection (1) 312s ok 42 - psql -Atl 312s ok 43 - PGCLUSTER selection (2) 312s ok 44 - psql -l 312s ok 45 - invalid PGCLUSTER value 312s ok 46 - createdb --version 312s ok 47 - PGCLUSTER network cluster selection (1) 312s ok 48 - psql -Atl 312s ok 49 - PGCLUSTER network cluster selection (2) 313s ok 50 - psql -Atl 313s ok 51 - PGCLUSTER network cluster selection (3) 313s ok 52 - LC_MESSAGES=C psql -Atl 313s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 313s ok 54 - psql -Atc "show port" template1 313s ok 55 - PGPORT selection (1) 313s ok 56 - psql -Atc "show port" template1 313s ok 57 - PGPORT selection (2) 313s ok 58 - createdb --version 313s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 313s ok 60 - psql -Atc "show port" template1 313s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 313s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 313s ok 63 - PGDATABASE environment variable works 313s ok 64 - createdb --version 313s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 313s ok 66 - createdb --cluster 12/new1 --version 313s ok 67 - pg_wrapper --cluster works with empty user_clusters 313s ok 68 - createdb --version 313s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 313s ok 70 - psql -Atc "select current_database()" 313s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 313s ok 72 - psql -Atc 'select current_database()' 313s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 313s ok 74 - createdb --version 313s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 313s ok 76 - createdb --version 313s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 313s ok 78 - createdb --version 313s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 313s ok 80 - createdb --version 313s ok 81 - pg_wrapper selects correct version with per-user user_clusters 313s ok 82 - createdb --version 313s ok 83 - pg_wrapper selects correct version with per-user user_clusters 314s ok 84 - createdb --version 314s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 314s ok 86 - psql -Atl 314s ok 87 - $PGHOST overrides user_clusters 314s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 314s ok 89 - --cluster overrides $PGHOST 314s ok 90 - createdb --version 314s ok 91 - pg_wrapper ignores invalid lines in user_clusters 314s ok 92 - psql -Atc 'select current_database()' 314s ok 93 - pg_service conf selection 1 314s ok 94 - psql -Atc 'select current_database()' 314s ok 95 - pg_service conf selection 2 314s ok 96 - psql -Atc 'select current_database()' 314s ok 97 - pg_service conf selection 3 314s ok 98 - stopping cluster 12/old 316s ok 99 - restarting cluster 12/old 316s ok 100 - pg_lsclusters -h | sort -k3 316s ok 101 - port of first cluster was successfully changed 316s ok 102 - psql -l 316s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 316s ok 104 - psql -Atl --cluster 12/new1 316s ok 105 - --cluster selects appropriate cluster 316s ok 106 - psql -Atl -p 5434 316s ok 107 - -p selects appropriate cluster 316s ok 108 - psql -Atlp 5434 316s ok 109 - -Atlp selects appropriate cluster 317s ok 110 - psql -Atl --port 5434 317s ok 111 - --port selects appropriate cluster 317s ok 112 - env PGPORT=5434 psql -Atl 317s ok 113 - $PGPORT selects appropriate cluster 317s ok 114 - Restoring original /etc/postgresql-common/user_clusters 317s ok 115 - dropping 12/new1 317s ok 116 - dropping 12/new2 318s ok 117 - dropping 12/old 318s ok 118 - Cleanup: No clusters left behind 318s ok 119 - No postgres processes left behind 318s ok 120 - No files in /etc/postgresql left behind 318s ok 121 - No files in /var/lib/postgresql left behind 318s ok 122 - No files in /var/run/postgresql left behind 318s ok 123 - No files in /var/log/postgresql left behind 318s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 318s ok 125 - PostgreSQL TCP ports are closed 318s === Running test 100_upgrade_scripts.t ... === 318s 1..27 321s ok 1 - pg_createcluster 12 main 321s ok 2 - createdb --cluster 12/main db1 321s ok 3 - correct output of createdb --cluster 12/main db1 321s ok 4 - createdb --cluster 12/main db2 321s ok 5 - correct output of createdb --cluster 12/main db2 321s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 321s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 321s ok 8 - get_cluster_databases() works 321s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 323s ok 10 - run-upgrade-scripts succeeds 323s ok 11 - correct run-upgrade-script output 323s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 323s ok 13 - check SQL scripts results in 12/main db1 323s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 323s ok 15 - check SQL scripts results in 12/main db2 323s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 323s ok 17 - check shell scripts results in $v/main 323s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 324s ok 19 - pg_dropcluster 12 main 324s ok 20 - Cleanup: No clusters left behind 324s ok 21 - No postgres processes left behind 324s ok 22 - No files in /etc/postgresql left behind 324s ok 23 - No files in /var/lib/postgresql left behind 324s ok 24 - No files in /var/run/postgresql left behind 324s ok 25 - No files in /var/log/postgresql left behind 324s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 324s ok 27 - PostgreSQL TCP ports are closed 324s === Running test 110_integrate_cluster.t ... === 324s 1..32 325s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/q5w6tYk6Ha/c/postgres 325s ok 2 - creating raw initdb cluster for user postgres 325s ok 3 - pg_createcluster 12 postgres -d /tmp/q5w6tYk6Ha/c/postgres 325s ok 4 - integrating postgres cluster 325s ok 5 - pg_lsclusters 325s ok 6 - correct pg_lsclusters output 327s ok 7 - pg_ctlcluster 12 postgres start 327s ok 8 - starting cluster postgres 327s ok 9 - pg_lsclusters 327s ok 10 - correct pg_lsclusters output 328s ok 11 - dropping cluster postgres 328s ok 12 - No files in temporary cluster dir left behind 328s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/q5w6tYk6Ha/c/nobody 328s ok 14 - creating raw initdb cluster for user nobody 329s ok 15 - pg_createcluster 12 nobody -d /tmp/q5w6tYk6Ha/c/nobody 329s ok 16 - integrating nobody cluster 329s ok 17 - pg_lsclusters 329s ok 18 - correct pg_lsclusters output 331s ok 19 - pg_ctlcluster 12 nobody start 331s ok 20 - starting cluster nobody 331s ok 21 - pg_lsclusters 331s ok 22 - correct pg_lsclusters output 331s ok 23 - dropping cluster nobody 331s ok 24 - No files in temporary cluster dir left behind 331s ok 25 - Cleanup: No clusters left behind 331s ok 26 - No postgres processes left behind 331s ok 27 - No files in /etc/postgresql left behind 331s ok 28 - No files in /var/lib/postgresql left behind 331s ok 29 - No files in /var/run/postgresql left behind 331s ok 30 - No files in /var/log/postgresql left behind 331s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 331s ok 32 - PostgreSQL TCP ports are closed 331s === Running test 120_pg_upgradecluster_scripts.t ... === 332s 1..1 332s ok 1 - only one major version installed, skipping upgrade tests 332s === Running test 130_nonroot_admin.t ... === 332s 1..22 334s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 334s ok 2 - pg_lsclusters -h 334s ok 3 - correct output of pg_lsclusters -h 335s ok 4 - psql -Atl 335s ok 5 - correct output of psql -Atl 335s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 335s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 335s ok 15 - Cleanup: No clusters left behind 335s ok 16 - No postgres processes left behind 335s ok 17 - No files in /etc/postgresql left behind 335s ok 18 - No files in /var/lib/postgresql left behind 335s ok 19 - No files in /var/run/postgresql left behind 335s ok 20 - No files in /var/log/postgresql left behind 335s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 335s ok 22 - PostgreSQL TCP ports are closed 335s === Running test 135_pg_virtualenv.t ... === 335s 1..20 338s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 338s ok 2 - running pg_virtualenv as root 342s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 342s ok 4 - running pg_virtualenv as postgres 345s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 345s ok 6 - running pg_virtualenv as nobody 345s ok 7 # skip /usr/bin/fakeroot not available 345s ok 8 # skip /usr/bin/fakeroot not available 345s ok 9 # skip /usr/bin/fakeroot not available 345s ok 10 # skip /usr/bin/fakeroot not available 345s ok 11 # skip /usr/bin/fakeroot not available 345s ok 12 # skip /usr/bin/fakeroot not available 345s ok 13 - Cleanup: No clusters left behind 345s ok 14 - No postgres processes left behind 345s ok 15 - No files in /etc/postgresql left behind 345s ok 16 - No files in /var/lib/postgresql left behind 345s ok 17 - No files in /var/run/postgresql left behind 345s ok 18 - No files in /var/log/postgresql left behind 345s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 345s ok 20 - PostgreSQL TCP ports are closed 345s === Running test 140_pg_config.t ... === 345s 1..38 345s # Multiarch is enabled 345s # checking version specific output for 12 345s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 345s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 345s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 345s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 345s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 345s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 345s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 345s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 345s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 345s # checking pg_config output (should behave like version 12) 345s ok 15 - pg_config 345s ok 16 - correct output of pg_config 345s ok 17 - pg_config --help 345s ok 18 - correct output of pg_config --help 345s ok 19 - pg_config --pgxs 345s ok 20 - correct output of pg_config --pgxs 345s ok 21 - pg_config --libdir 345s ok 22 - correct output of pg_config --libdir 345s ok 23 - pg_config --pkglibdir 345s ok 24 - correct output of pg_config --pkglibdir 345s ok 25 - pg_config --bindir 345s ok 26 - correct output of pg_config --bindir 345s # checking pg_config.libpq-dev output (should behave like version 12) 345s ok 27 - pg_config.libpq-dev 345s ok 28 - correct output of pg_config.libpq-dev 345s ok 29 - pg_config.libpq-dev --help 345s ok 30 - correct output of pg_config.libpq-dev --help 345s ok 31 - pg_config.libpq-dev --pgxs 345s ok 32 - correct output of pg_config.libpq-dev --pgxs 345s ok 33 - pg_config.libpq-dev --libdir 345s ok 34 - correct output of pg_config.libpq-dev --libdir 345s ok 35 - pg_config.libpq-dev --pkglibdir 345s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 345s ok 37 - pg_config.libpq-dev --bindir 345s ok 38 - correct output of pg_config.libpq-dev --bindir 345s === Running test 150_tsearch_stemming.t ... === 345s 1..37 345s ok 1 - pg_updatedicts succeeded 345s ok 2 - pg_updatedicts created en_us.affix 345s ok 3 - pg_updatedicts created en_us.dict 345s ok 4 - pg_updatedicts created 12 en_us.affix symlink 345s ok 5 - pg_updatedicts created 12 en_us.dict symlink 348s ok 6 - pg_createcluster 12 main 348s ok 7 - createdb fts 348s ok 8 - correct output of createdb fts 348s ok 9 - creating en_US full text search configuration 348s ok 10 - creating data table and search index 349s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 349s ok 12 - stem search of correct word 349s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 349s ok 14 - stem search of correct word 349s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 349s ok 16 - stem search of unknown word 349s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 349s ok 18 - full text search, exact word 349s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 349s ok 20 - full text search for word stem 349s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 349s ok 22 - full text search for word substring fails 349s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 349s ok 24 - full text search, exact unicode word 349s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 349s ok 26 - full text search for unicode word stem 349s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 349s ok 28 - full text search for unicode word substring fails 349s ok 29 350s ok 30 - Cleanup: No clusters left behind 350s ok 31 - No postgres processes left behind 350s ok 32 - No files in /etc/postgresql left behind 350s ok 33 - No files in /var/lib/postgresql left behind 350s ok 34 - No files in /var/run/postgresql left behind 350s ok 35 - No files in /var/log/postgresql left behind 350s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 350s ok 37 - PostgreSQL TCP ports are closed 350s === Running test 160_alternate_confroot.t ... === 350s 1..28 353s ok 1 353s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 353s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 353s ok 4 - pg_lsclusters -h 353s ok 5 - correct output of pg_lsclusters -h 353s ok 6 - psql -Atl 353s ok 7 - correct output of psql -Atl 353s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 353s ok 9 - ... 353s ok 10 - ... 353s ok 11 - ... 353s ok 12 - ... 353s ok 13 - ... 353s ok 14 - ... 353s ok 15 - pg_dropcluster 12 test --stop 353s ok 16 - correct output of pg_dropcluster 12 test --stop 353s ok 17 - pg_lsclusters -h 353s ok 18 - correct output of pg_lsclusters -h 353s ok 19 - No files in root/data left behind 353s ok 20 - No cruft in root dir left behind 353s ok 21 - Cleanup: No clusters left behind 353s ok 22 - No postgres processes left behind 353s ok 23 - No files in /etc/postgresql left behind 353s ok 24 - No files in /var/lib/postgresql left behind 353s ok 25 - No files in /var/run/postgresql left behind 353s ok 26 - No files in /var/log/postgresql left behind 353s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 353s ok 28 - PostgreSQL TCP ports are closed 353s === Running test 170_extensions.t ... === 353s # Running tests for 12 356s ok 1 - pg_createcluster 12 main 356s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 356s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 356s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 356s ok 5 - extension adminpack installs without error 356s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 356s ok 7 - extension adminpack removes without error 356s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 356s ok 9 - extension amcheck installs without error 356s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 356s ok 11 - extension amcheck removes without error 356s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 356s ok 13 - extension autoinc installs without error 356s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 356s ok 15 - extension autoinc removes without error 356s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 356s ok 17 - extension bloom installs without error 357s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 357s ok 19 - extension bloom removes without error 357s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 357s ok 21 - extension btree_gin installs without error 357s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 357s ok 23 - extension btree_gin removes without error 357s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 357s ok 25 - extension btree_gist installs without error 357s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 357s ok 27 - extension btree_gist removes without error 357s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 357s ok 29 - extension citext installs without error 357s ok 30 - psql -qc 'DROP EXTENSION "citext"' 357s ok 31 - extension citext removes without error 357s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 357s ok 33 - extension cube installs without error 357s ok 34 - psql -qc 'DROP EXTENSION "cube"' 357s ok 35 - extension cube removes without error 357s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 357s ok 37 - extension dblink installs without error 357s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 357s ok 39 - extension dblink removes without error 357s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 357s ok 41 - extension dict_int installs without error 357s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 357s ok 43 - extension dict_int removes without error 357s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 357s ok 45 - extension dict_xsyn installs without error 357s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 357s ok 47 - extension dict_xsyn removes without error 357s ok 48 - psql -qc 'CREATE EXTENSION cube' 357s ok 49 - earthdistance dependency cube installs without error 357s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 357s ok 51 - extension earthdistance installs without error 357s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 357s ok 53 - extension earthdistance removes without error 358s ok 54 - psql -qc 'DROP EXTENSION cube' 358s ok 55 - earthdistance dependency extension cube removes without error 358s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 358s ok 57 - extension file_fdw installs without error 358s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 358s ok 59 - extension file_fdw removes without error 358s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 358s ok 61 - extension fuzzystrmatch installs without error 358s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 358s ok 63 - extension fuzzystrmatch removes without error 358s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 358s ok 65 - extension hstore installs without error 358s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 358s ok 67 - extension hstore removes without error 358s ok 68 - psql -qc 'CREATE EXTENSION hstore' 358s ok 69 - hstore_plperl dependency hstore installs without error 358s ok 70 - psql -qc 'CREATE EXTENSION plperl' 358s ok 71 - hstore_plperl dependency plperl installs without error 358s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 358s ok 73 - extension hstore_plperl installs without error 358s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 358s ok 75 - extension hstore_plperl removes without error 358s ok 76 - psql -qc 'DROP EXTENSION hstore' 358s ok 77 - hstore_plperl dependency extension hstore removes without error 358s ok 78 - psql -qc 'DROP EXTENSION plperl' 358s ok 79 - hstore_plperl dependency extension plperl removes without error 358s ok 80 - psql -qc 'CREATE EXTENSION hstore' 358s ok 81 - hstore_plperlu dependency hstore installs without error 358s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 358s ok 83 - hstore_plperlu dependency plperlu installs without error 358s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 358s ok 85 - extension hstore_plperlu installs without error 358s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 358s ok 87 - extension hstore_plperlu removes without error 358s ok 88 - psql -qc 'DROP EXTENSION hstore' 358s ok 89 - hstore_plperlu dependency extension hstore removes without error 358s ok 90 - psql -qc 'DROP EXTENSION plperlu' 358s ok 91 - hstore_plperlu dependency extension plperlu removes without error 359s ok 92 - psql -qc 'CREATE EXTENSION hstore' 359s ok 93 - hstore_plpython3u dependency hstore installs without error 359s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 359s ok 95 - hstore_plpython3u dependency plpython3u installs without error 359s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 359s ok 97 - extension hstore_plpython3u installs without error 359s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 359s ok 99 - extension hstore_plpython3u removes without error 359s ok 100 - psql -qc 'DROP EXTENSION hstore' 359s ok 101 - hstore_plpython3u dependency extension hstore removes without error 359s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 359s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 359s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 359s ok 105 - extension insert_username installs without error 359s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 359s ok 107 - extension insert_username removes without error 359s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 359s ok 109 - extension intagg installs without error 359s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 359s ok 111 - extension intagg removes without error 359s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 359s ok 113 - extension intarray installs without error 359s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 359s ok 115 - extension intarray removes without error 359s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 359s ok 117 - extension isn installs without error 359s ok 118 - psql -qc 'DROP EXTENSION "isn"' 359s ok 119 - extension isn removes without error 359s ok 120 - psql -qc 'CREATE EXTENSION plperl' 359s ok 121 - jsonb_plperl dependency plperl installs without error 359s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 359s ok 123 - extension jsonb_plperl installs without error 359s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 359s ok 125 - extension jsonb_plperl removes without error 359s ok 126 - psql -qc 'DROP EXTENSION plperl' 359s ok 127 - jsonb_plperl dependency extension plperl removes without error 360s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 360s ok 129 - jsonb_plperlu dependency plperlu installs without error 360s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 360s ok 131 - extension jsonb_plperlu installs without error 360s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 360s ok 133 - extension jsonb_plperlu removes without error 360s ok 134 - psql -qc 'DROP EXTENSION plperlu' 360s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 360s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 360s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 360s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 360s ok 139 - extension jsonb_plpython3u installs without error 360s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 360s ok 141 - extension jsonb_plpython3u removes without error 360s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 360s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 360s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 360s ok 145 - extension lo installs without error 360s ok 146 - psql -qc 'DROP EXTENSION "lo"' 360s ok 147 - extension lo removes without error 360s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 360s ok 149 - extension ltree installs without error 360s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 360s ok 151 - extension ltree removes without error 360s ok 152 - psql -qc 'CREATE EXTENSION ltree' 360s ok 153 - ltree_plpython3u dependency ltree installs without error 360s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 360s ok 155 - ltree_plpython3u dependency plpython3u installs without error 360s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 360s ok 157 - extension ltree_plpython3u installs without error 360s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 360s ok 159 - extension ltree_plpython3u removes without error 360s ok 160 - psql -qc 'DROP EXTENSION ltree' 360s ok 161 - ltree_plpython3u dependency extension ltree removes without error 360s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 360s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 360s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 360s ok 165 - extension moddatetime installs without error 360s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 360s ok 167 - extension moddatetime removes without error 361s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 361s ok 169 - extension pageinspect installs without error 361s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 361s ok 171 - extension pageinspect removes without error 361s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 361s ok 173 - extension pg_buffercache installs without error 361s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 361s ok 175 - extension pg_buffercache removes without error 361s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 361s ok 177 - extension pg_freespacemap installs without error 361s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 361s ok 179 - extension pg_freespacemap removes without error 361s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 361s ok 181 - extension pg_prewarm installs without error 361s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 361s ok 183 - extension pg_prewarm removes without error 361s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 361s ok 185 - extension pg_stat_statements installs without error 361s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 361s ok 187 - extension pg_stat_statements removes without error 361s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 361s ok 189 - extension pg_trgm installs without error 361s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 361s ok 191 - extension pg_trgm removes without error 361s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 361s ok 193 - extension pg_visibility installs without error 361s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 361s ok 195 - extension pg_visibility removes without error 361s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 361s ok 197 - extension pgcrypto installs without error 361s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 361s ok 199 - extension pgcrypto removes without error 361s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 361s ok 201 - extension pgrowlocks installs without error 361s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 361s ok 203 - extension pgrowlocks removes without error 361s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 361s ok 205 - extension pgstattuple installs without error 361s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 361s ok 207 - extension pgstattuple removes without error 362s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 362s ok 209 - extension plperl installs without error 362s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 362s ok 211 - extension plperl removes without error 362s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 362s ok 213 - extension plperlu installs without error 362s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 362s ok 215 - extension plperlu removes without error 362s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 362s ok 217 - extension plpython3u installs without error 362s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 362s ok 219 - extension plpython3u removes without error 362s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 362s ok 221 - extension pltcl installs without error 362s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 362s ok 223 - extension pltcl removes without error 362s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 362s ok 225 - extension pltclu installs without error 362s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 362s ok 227 - extension pltclu removes without error 362s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 362s ok 229 - extension postgres_fdw installs without error 362s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 362s ok 231 - extension postgres_fdw removes without error 362s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 362s ok 233 - extension refint installs without error 362s ok 234 - psql -qc 'DROP EXTENSION "refint"' 362s ok 235 - extension refint removes without error 362s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 362s ok 237 - extension seg installs without error 362s ok 238 - psql -qc 'DROP EXTENSION "seg"' 362s ok 239 - extension seg removes without error 362s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 362s ok 241 - extension sslinfo installs without error 362s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 362s ok 243 - extension sslinfo removes without error 362s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 362s ok 245 - extension tablefunc installs without error 362s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 362s ok 247 - extension tablefunc removes without error 363s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 363s ok 249 - extension tcn installs without error 363s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 363s ok 251 - extension tcn removes without error 363s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 363s ok 253 - extension tsm_system_rows installs without error 363s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 363s ok 255 - extension tsm_system_rows removes without error 363s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 363s ok 257 - extension tsm_system_time installs without error 363s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 363s ok 259 - extension tsm_system_time removes without error 363s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 363s ok 261 - extension unaccent installs without error 363s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 363s ok 263 - extension unaccent removes without error 363s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 363s ok 265 - extension uuid-ossp installs without error 363s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 363s ok 267 - extension uuid-ossp removes without error 363s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 363s ok 269 - extension xml2 installs without error 363s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 363s ok 271 - extension xml2 removes without error 363s ok 272 - pg_dropcluster 12 main 364s ok 273 - Cleanup: No clusters left behind 364s ok 274 - No postgres processes left behind 364s ok 275 - No files in /etc/postgresql left behind 364s ok 276 - No files in /var/lib/postgresql left behind 364s ok 277 - No files in /var/run/postgresql left behind 364s ok 278 - No files in /var/log/postgresql left behind 364s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 364s ok 280 - PostgreSQL TCP ports are closed 364s 1..280 364s === Running test 180_ecpg.t ... === 364s 1..17 364s ok 1 - ecpg test.pgc 364s ok 2 - ecpg processing 364s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 364s ok 4 - compiling ecpg output 367s ok 5 - pg_createcluster 12 main 367s ok 6 - createuser nobody 367s ok 7 - /tmp/tmp.TEoZ4WqPkJ/test 367s ok 8 - runs and gives correct output 367s ok 9 - pg_dropcluster 12 main 367s ok 10 - Cleanup: No clusters left behind 367s ok 11 - No postgres processes left behind 367s ok 12 - No files in /etc/postgresql left behind 367s ok 13 - No files in /var/lib/postgresql left behind 367s ok 14 - No files in /var/run/postgresql left behind 367s ok 15 - No files in /var/log/postgresql left behind 367s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 367s ok 17 - PostgreSQL TCP ports are closed 368s autopkgtest [13:57:01]: test run-testsuite: -----------------------] 369s autopkgtest [13:57:02]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 369s run-testsuite PASS 370s autopkgtest [13:57:03]: test installcheck: preparing testbed 455s autopkgtest [13:58:28]: testbed dpkg architecture: arm64 455s autopkgtest [13:58:28]: testbed apt version: 2.0.10 455s autopkgtest [13:58:28]: @@@@@@@@@@@@@@@@@@@@ test bed setup 455s autopkgtest [13:58:28]: testbed release detected to be: focal 456s autopkgtest [13:58:29]: updating testbed package index (apt update) 457s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 457s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 457s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 457s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 457s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 457s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 457s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 457s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 457s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 Packages [274 kB] 457s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 c-n-f Metadata [1428 B] 457s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 Packages [14.1 kB] 457s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 c-n-f Metadata [116 B] 457s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 Packages [46.7 kB] 457s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 c-n-f Metadata [1712 B] 457s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 Packages [10.0 kB] 457s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 c-n-f Metadata [304 B] 461s Fetched 730 kB in 1s (720 kB/s) 461s Reading package lists... 462s + lsb_release --codename --short 462s + RELEASE=focal 462s + cat 462s + [ focal != trusty ] 462s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 462s Reading package lists... 462s Building dependency tree... 462s Reading state information... 462s Calculating upgrade... 463s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 463s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 463s + /usr/lib/apt/apt-helper analyze-pattern ?true 463s + uname -r 463s + sed s/\./\\./g 463s + running_kernel_pattern=^linux-.*5\.4\.0-208-generic.* 463s + apt list ?obsolete 463s + tail -n+2 463s + cut -d/ -f1 463s + grep -v ^linux-.*5\.4\.0-208-generic.* 463s + true 463s + obsolete_pkgs= 463s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 463s Reading package lists... 463s Building dependency tree... 463s Reading state information... 464s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 464s + grep -q trusty /etc/lsb-release 464s + [ ! -d /usr/share/doc/unattended-upgrades ] 464s + [ ! -d /usr/share/doc/lxd ] 464s + [ ! -d /usr/share/doc/lxd-client ] 464s + [ ! -d /usr/share/doc/snapd ] 464s + type iptables 464s + cat 464s + chmod 755 /etc/rc.local 464s + . /etc/rc.local 464s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 464s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 464s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 464s + uname -m 464s + [ aarch64 = ppc64le ] 464s + [ -d /run/systemd/system ] 464s + systemd-detect-virt --quiet --vm 464s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 464s + cat 464s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 464s + echo COMPRESS=lz4 464s autopkgtest [13:58:37]: upgrading testbed (apt dist-upgrade and autopurge) 464s Reading package lists... 464s Building dependency tree... 464s Reading state information... 464s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 465s Starting 2 pkgProblemResolver with broken count: 0 465s Done 465s 465s The following packages will be upgraded: 465s tzdata 465s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 465s Need to get 300 kB of archives. 465s After this operation, 3072 B of additional disk space will be used. 465s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 tzdata all 2025a-0ubuntu0.20.04 [300 kB] 466s Preconfiguring packages ... 466s Fetched 300 kB in 0s (741 kB/s) 466s (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 ... 100151 files and directories currently installed.) 466s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 466s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 466s Setting up tzdata (2025a-0ubuntu0.20.04) ... 466s 466s Current default time zone: 'Etc/UTC' 466s Local time is now: Wed Feb 26 13:58:39 UTC 2025. 466s Universal Time is now: Wed Feb 26 13:58:39 UTC 2025. 466s Run 'dpkg-reconfigure tzdata' if you wish to change it. 466s 467s Reading package lists... 467s Building dependency tree... 467s Reading state information... 467s Starting pkgProblemResolver with broken count: 0 467s Starting 2 pkgProblemResolver with broken count: 0 467s Done 468s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 470s Reading package lists... 471s Building dependency tree... 471s Reading state information... 471s Starting pkgProblemResolver with broken count: 0 471s Starting 2 pkgProblemResolver with broken count: 0 471s Done 471s The following NEW packages will be installed: 471s binfmt-support build-essential clang-10 cpp cpp-9 g++ g++-9 gcc gcc-9 471s gcc-9-base libasan5 libatomic1 libc-dev-bin libc6-dev libcc1-0 471s libclang-common-10-dev libclang-cpp10 libclang1-10 libcrypt-dev 471s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1c2 libgcc-9-dev 471s libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 libncurses-dev 471s libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.8 471s libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 libubsan1 libxslt1.1 libz3-4 471s libz3-dev linux-libc-dev llvm-10 llvm-10-dev llvm-10-runtime llvm-10-tools 471s postgresql-12 postgresql-client-12 postgresql-client-common 471s postgresql-common postgresql-doc-12 postgresql-plperl-12 471s postgresql-plpython3-12 postgresql-pltcl-12 postgresql-server-dev-12 471s python3-pygments ssl-cert 471s 0 upgraded, 63 newly installed, 0 to remove and 0 not upgraded. 471s Need to get 118 MB of archives. 471s After this operation, 645 MB of additional disk space will be used. 471s Get:1 http://ftpmaster.internal/ubuntu focal/universe arm64 binfmt-support arm64 2.2.0-2 [55.5 kB] 471s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc-dev-bin arm64 2.31-0ubuntu9.17 [64.2 kB] 471s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main arm64 linux-libc-dev arm64 5.4.0-208.228 [1098 kB] 472s Get:4 http://ftpmaster.internal/ubuntu focal/main arm64 libcrypt-dev arm64 1:4.4.10-10ubuntu4 [111 kB] 472s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc6-dev arm64 2.31-0ubuntu9.17 [2069 kB] 472s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9-base arm64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 472s Get:7 http://ftpmaster.internal/ubuntu focal/main arm64 libisl22 arm64 0.22.1-1 [537 kB] 472s Get:8 http://ftpmaster.internal/ubuntu focal/main arm64 libmpc3 arm64 1.1.0-1 [37.2 kB] 472s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main arm64 cpp-9 arm64 9.4.0-1ubuntu1~20.04.2 [5985 kB] 472s Get:10 http://ftpmaster.internal/ubuntu focal/main arm64 cpp arm64 4:9.3.0-1ubuntu2 [27.6 kB] 472s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libcc1-0 arm64 10.5.0-1ubuntu1~20.04 [46.2 kB] 472s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgomp1 arm64 10.5.0-1ubuntu1~20.04 [93.5 kB] 472s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libitm1 arm64 10.5.0-1ubuntu1~20.04 [24.1 kB] 472s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libatomic1 arm64 10.5.0-1ubuntu1~20.04 [9808 B] 472s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libasan5 arm64 9.4.0-1ubuntu1~20.04.2 [2690 kB] 472s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main arm64 liblsan0 arm64 10.5.0-1ubuntu1~20.04 [800 kB] 472s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtsan0 arm64 10.5.0-1ubuntu1~20.04 [1972 kB] 472s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libubsan1 arm64 10.5.0-1ubuntu1~20.04 [765 kB] 472s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgcc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [920 kB] 472s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9 arm64 9.4.0-1ubuntu1~20.04.2 [6736 kB] 472s Get:21 http://ftpmaster.internal/ubuntu focal/main arm64 gcc arm64 4:9.3.0-1ubuntu2 [5228 B] 472s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libstdc++-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [1687 kB] 472s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main arm64 g++-9 arm64 9.4.0-1ubuntu1~20.04.2 [6843 kB] 473s Get:24 http://ftpmaster.internal/ubuntu focal/main arm64 g++ arm64 4:9.3.0-1ubuntu2 [1592 B] 473s Get:25 http://ftpmaster.internal/ubuntu focal-updates/main arm64 build-essential arm64 12.8ubuntu1.1 [4664 B] 473s Get:26 http://ftpmaster.internal/ubuntu focal/main arm64 libllvm10 arm64 1:10.0.0-4ubuntu1 [12.7 MB] 473s Get:27 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-cpp10 arm64 1:10.0.0-4ubuntu1 [8123 kB] 473s Get:28 http://ftpmaster.internal/ubuntu focal/main arm64 libgc1c2 arm64 1:7.6.4-0.4ubuntu1 [74.0 kB] 473s Get:29 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc4 arm64 10.5.0-1ubuntu1~20.04 [39.5 kB] 473s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [211 kB] 473s Get:31 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-common-10-dev arm64 1:10.0.0-4ubuntu1 [3267 kB] 473s Get:32 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang1-10 arm64 1:10.0.0-4ubuntu1 [6176 kB] 473s Get:33 http://ftpmaster.internal/ubuntu focal/universe arm64 clang-10 arm64 1:10.0.0-4ubuntu1 [61.9 kB] 473s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpgtypes3 arm64 12.22-0ubuntu0.20.04.1 [43.1 kB] 473s Get:35 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpq5 arm64 12.22-0ubuntu0.20.04.1 [111 kB] 473s Get:36 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg6 arm64 12.22-0ubuntu0.20.04.1 [40.5 kB] 473s Get:37 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg-compat3 arm64 12.22-0ubuntu0.20.04.1 [12.0 kB] 473s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpq-dev arm64 12.22-0ubuntu0.20.04.1 [134 kB] 473s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libecpg-dev arm64 12.22-0ubuntu0.20.04.1 [224 kB] 473s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libncurses-dev arm64 6.2-0ubuntu2.1 [327 kB] 473s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpython3.8 arm64 3.8.10-0ubuntu1~20.04.15 [1490 kB] 473s Get:42 http://ftpmaster.internal/ubuntu focal/main arm64 libtcl8.6 arm64 8.6.10+dfsg-1 [849 kB] 473s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtinfo-dev arm64 6.2-0ubuntu2.1 [972 B] 473s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.20.04.1 [141 kB] 473s Get:45 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-runtime arm64 1:10.0.0-4ubuntu1 [148 kB] 473s Get:46 http://ftpmaster.internal/ubuntu focal/main arm64 libpfm4 arm64 4.10.1+git20-g7700f49-2 [33.1 kB] 473s Get:47 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10 arm64 1:10.0.0-4ubuntu1 [4076 kB] 474s Get:48 http://ftpmaster.internal/ubuntu focal/main arm64 libffi-dev arm64 3.3-4 [53.5 kB] 474s Get:49 http://ftpmaster.internal/ubuntu focal-updates/main arm64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 474s Get:50 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-tools arm64 1:10.0.0-4ubuntu1 [276 kB] 474s Get:51 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-4 arm64 4.8.7-4build1 [5860 kB] 474s Get:52 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-dev arm64 4.8.7-4build1 [67.5 kB] 474s Get:53 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-dev arm64 1:10.0.0-4ubuntu1 [23.0 MB] 474s Get:54 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 474s Get:55 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-12 arm64 12.22-0ubuntu0.20.04.1 [1020 kB] 474s Get:56 http://ftpmaster.internal/ubuntu focal/main arm64 ssl-cert all 1.0.39 [17.0 kB] 474s Get:57 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-common all 214ubuntu0.1 [169 kB] 474s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-12 arm64 12.22-0ubuntu0.20.04.1 [13.1 MB] 475s Get:59 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 475s Get:60 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-plperl-12 arm64 12.22-0ubuntu0.20.04.1 [64.6 kB] 475s Get:61 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-plpython3-12 arm64 12.22-0ubuntu0.20.04.1 [72.3 kB] 475s Get:62 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-pltcl-12 arm64 12.22-0ubuntu0.20.04.1 [30.0 kB] 475s Get:63 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-server-dev-12 arm64 12.22-0ubuntu0.20.04.1 [987 kB] 476s Preconfiguring packages ... 476s Fetched 118 MB in 4s (31.9 MB/s) 476s Selecting previously unselected package binfmt-support. 476s (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 ... 100152 files and directories currently installed.) 476s Preparing to unpack .../00-binfmt-support_2.2.0-2_arm64.deb ... 476s Unpacking binfmt-support (2.2.0-2) ... 476s Selecting previously unselected package libc-dev-bin. 476s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_arm64.deb ... 476s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 476s Selecting previously unselected package linux-libc-dev:arm64. 476s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_arm64.deb ... 476s Unpacking linux-libc-dev:arm64 (5.4.0-208.228) ... 476s Selecting previously unselected package libcrypt-dev:arm64. 476s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_arm64.deb ... 476s Unpacking libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 476s Selecting previously unselected package libc6-dev:arm64. 476s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_arm64.deb ... 476s Unpacking libc6-dev:arm64 (2.31-0ubuntu9.17) ... 476s Selecting previously unselected package gcc-9-base:arm64. 476s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 476s Unpacking gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 476s Selecting previously unselected package libisl22:arm64. 476s Preparing to unpack .../06-libisl22_0.22.1-1_arm64.deb ... 476s Unpacking libisl22:arm64 (0.22.1-1) ... 476s Selecting previously unselected package libmpc3:arm64. 476s Preparing to unpack .../07-libmpc3_1.1.0-1_arm64.deb ... 476s Unpacking libmpc3:arm64 (1.1.0-1) ... 477s Selecting previously unselected package cpp-9. 477s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 477s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 477s Selecting previously unselected package cpp. 477s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_arm64.deb ... 477s Unpacking cpp (4:9.3.0-1ubuntu2) ... 477s Selecting previously unselected package libcc1-0:arm64. 477s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 477s Selecting previously unselected package libgomp1:arm64. 477s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 477s Selecting previously unselected package libitm1:arm64. 477s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 477s Selecting previously unselected package libatomic1:arm64. 477s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 477s Selecting previously unselected package libasan5:arm64. 477s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 477s Unpacking libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 477s Selecting previously unselected package liblsan0:arm64. 477s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 477s Selecting previously unselected package libtsan0:arm64. 477s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 477s Unpacking libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 478s Selecting previously unselected package libubsan1:arm64. 478s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_arm64.deb ... 478s Unpacking libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 478s Selecting previously unselected package libgcc-9-dev:arm64. 478s Preparing to unpack .../18-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 478s Unpacking libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 478s Selecting previously unselected package gcc-9. 478s Preparing to unpack .../19-gcc-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 478s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 478s Selecting previously unselected package gcc. 478s Preparing to unpack .../20-gcc_4%3a9.3.0-1ubuntu2_arm64.deb ... 478s Unpacking gcc (4:9.3.0-1ubuntu2) ... 478s Selecting previously unselected package libstdc++-9-dev:arm64. 478s Preparing to unpack .../21-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 478s Unpacking libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 479s Selecting previously unselected package g++-9. 479s Preparing to unpack .../22-g++-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 479s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 479s Selecting previously unselected package g++. 479s Preparing to unpack .../23-g++_4%3a9.3.0-1ubuntu2_arm64.deb ... 479s Unpacking g++ (4:9.3.0-1ubuntu2) ... 479s Selecting previously unselected package build-essential. 479s Preparing to unpack .../24-build-essential_12.8ubuntu1.1_arm64.deb ... 479s Unpacking build-essential (12.8ubuntu1.1) ... 479s Selecting previously unselected package libllvm10:arm64. 479s Preparing to unpack .../25-libllvm10_1%3a10.0.0-4ubuntu1_arm64.deb ... 479s Unpacking libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 480s Selecting previously unselected package libclang-cpp10. 480s Preparing to unpack .../26-libclang-cpp10_1%3a10.0.0-4ubuntu1_arm64.deb ... 480s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 481s Selecting previously unselected package libgc1c2:arm64. 481s Preparing to unpack .../27-libgc1c2_1%3a7.6.4-0.4ubuntu1_arm64.deb ... 481s Unpacking libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 481s Selecting previously unselected package libobjc4:arm64. 481s Preparing to unpack .../28-libobjc4_10.5.0-1ubuntu1~20.04_arm64.deb ... 481s Unpacking libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 481s Selecting previously unselected package libobjc-9-dev:arm64. 481s Preparing to unpack .../29-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 481s Unpacking libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 481s Selecting previously unselected package libclang-common-10-dev. 481s Preparing to unpack .../30-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 481s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 481s Selecting previously unselected package libclang1-10. 481s Preparing to unpack .../31-libclang1-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 481s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 482s Selecting previously unselected package clang-10. 482s Preparing to unpack .../32-clang-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 482s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 482s Selecting previously unselected package libpgtypes3:arm64. 482s Preparing to unpack .../33-libpgtypes3_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libpgtypes3:arm64 (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libpq5:arm64. 482s Preparing to unpack .../34-libpq5_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libpq5:arm64 (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libecpg6:arm64. 482s Preparing to unpack .../35-libecpg6_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libecpg6:arm64 (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libecpg-compat3:arm64. 482s Preparing to unpack .../36-libecpg-compat3_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libpq-dev. 482s Preparing to unpack .../37-libpq-dev_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libecpg-dev. 482s Preparing to unpack .../38-libecpg-dev_12.22-0ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 482s Selecting previously unselected package libncurses-dev:arm64. 482s Preparing to unpack .../39-libncurses-dev_6.2-0ubuntu2.1_arm64.deb ... 482s Unpacking libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 482s Selecting previously unselected package libpython3.8:arm64. 482s Preparing to unpack .../40-libpython3.8_3.8.10-0ubuntu1~20.04.15_arm64.deb ... 482s Unpacking libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.15) ... 482s Selecting previously unselected package libtcl8.6:arm64. 482s Preparing to unpack .../41-libtcl8.6_8.6.10+dfsg-1_arm64.deb ... 482s Unpacking libtcl8.6:arm64 (8.6.10+dfsg-1) ... 482s Selecting previously unselected package libtinfo-dev:arm64. 482s Preparing to unpack .../42-libtinfo-dev_6.2-0ubuntu2.1_arm64.deb ... 482s Unpacking libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 482s Selecting previously unselected package libxslt1.1:arm64. 482s Preparing to unpack .../43-libxslt1.1_1.1.34-4ubuntu0.20.04.1_arm64.deb ... 482s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.1) ... 482s Selecting previously unselected package llvm-10-runtime. 482s Preparing to unpack .../44-llvm-10-runtime_1%3a10.0.0-4ubuntu1_arm64.deb ... 482s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 482s Selecting previously unselected package libpfm4:arm64. 482s Preparing to unpack .../45-libpfm4_4.10.1+git20-g7700f49-2_arm64.deb ... 482s Unpacking libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 482s Selecting previously unselected package llvm-10. 482s Preparing to unpack .../46-llvm-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 482s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 483s Selecting previously unselected package libffi-dev:arm64. 483s Preparing to unpack .../47-libffi-dev_3.3-4_arm64.deb ... 483s Unpacking libffi-dev:arm64 (3.3-4) ... 483s Selecting previously unselected package python3-pygments. 483s Preparing to unpack .../48-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 483s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 483s Selecting previously unselected package llvm-10-tools. 483s Preparing to unpack .../49-llvm-10-tools_1%3a10.0.0-4ubuntu1_arm64.deb ... 483s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 483s Selecting previously unselected package libz3-4:arm64. 483s Preparing to unpack .../50-libz3-4_4.8.7-4build1_arm64.deb ... 483s Unpacking libz3-4:arm64 (4.8.7-4build1) ... 483s Selecting previously unselected package libz3-dev:arm64. 483s Preparing to unpack .../51-libz3-dev_4.8.7-4build1_arm64.deb ... 483s Unpacking libz3-dev:arm64 (4.8.7-4build1) ... 483s Selecting previously unselected package llvm-10-dev. 483s Preparing to unpack .../52-llvm-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 483s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 485s Selecting previously unselected package postgresql-client-common. 485s Preparing to unpack .../53-postgresql-client-common_214ubuntu0.1_all.deb ... 485s Unpacking postgresql-client-common (214ubuntu0.1) ... 485s Selecting previously unselected package postgresql-client-12. 485s Preparing to unpack .../54-postgresql-client-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 485s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 485s Selecting previously unselected package ssl-cert. 485s Preparing to unpack .../55-ssl-cert_1.0.39_all.deb ... 485s Unpacking ssl-cert (1.0.39) ... 485s Selecting previously unselected package postgresql-common. 485s Preparing to unpack .../56-postgresql-common_214ubuntu0.1_all.deb ... 485s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 485s Unpacking postgresql-common (214ubuntu0.1) ... 485s Selecting previously unselected package postgresql-12. 485s Preparing to unpack .../57-postgresql-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 485s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 486s Selecting previously unselected package postgresql-doc-12. 486s Preparing to unpack .../58-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 486s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 486s Selecting previously unselected package postgresql-plperl-12. 486s Preparing to unpack .../59-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 486s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 486s Selecting previously unselected package postgresql-plpython3-12. 486s Preparing to unpack .../60-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 486s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 486s Selecting previously unselected package postgresql-pltcl-12. 487s Preparing to unpack .../61-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 487s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 487s Selecting previously unselected package postgresql-server-dev-12. 487s Preparing to unpack .../62-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_arm64.deb ... 487s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 487s Setting up postgresql-client-common (214ubuntu0.1) ... 487s Setting up libpgtypes3:arm64 (12.22-0ubuntu0.20.04.1) ... 487s Setting up libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 487s Setting up libpq5:arm64 (12.22-0ubuntu0.20.04.1) ... 487s Setting up linux-libc-dev:arm64 (5.4.0-208.228) ... 487s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 487s Setting up libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 487s Setting up libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 487s Setting up libffi-dev:arm64 (3.3-4) ... 487s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 487s 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 487s Setting up libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 487s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 488s Setting up libz3-4:arm64 (4.8.7-4build1) ... 488s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 488s 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 488s Setting up libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 488s Setting up ssl-cert (1.0.39) ... 488s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 488s Setting up libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.15) ... 488s Setting up postgresql-common (214ubuntu0.1) ... 489s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 489s Adding user postgres to group ssl-cert 489s 489s Creating config file /etc/postgresql-common/createcluster.conf with new version 489s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 489s Removing obsolete dictionary files: 489s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 490s Setting up libmpc3:arm64 (1.1.0-1) ... 490s Setting up libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 490s Setting up libtcl8.6:arm64 (8.6.10+dfsg-1) ... 490s Setting up binfmt-support (2.2.0-2) ... 490s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 491s Setting up libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 491s Setting up libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 491s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.1) ... 491s Setting up libecpg6:arm64 (12.22-0ubuntu0.20.04.1) ... 491s Setting up libisl22:arm64 (0.22.1-1) ... 491s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 491s Creating new PostgreSQL cluster 12/main ... 491s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 491s The files belonging to this database system will be owned by user "postgres". 491s This user must also own the server process. 491s 491s The database cluster will be initialized with locale "C.UTF-8". 491s The default database encoding has accordingly been set to "UTF8". 491s The default text search configuration will be set to "english". 491s 491s Data page checksums are disabled. 491s 491s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 491s creating subdirectories ... ok 491s selecting dynamic shared memory implementation ... posix 491s selecting default max_connections ... 100 491s selecting default shared_buffers ... 128MB 491s selecting default time zone ... Etc/UTC 491s creating configuration files ... ok 491s running bootstrap script ... ok 492s performing post-bootstrap initialization ... ok 492s syncing data to disk ... ok 492s 492s Success. You can now start the database server using: 492s 492s pg_ctlcluster 12 main start 492s 492s Ver Cluster Port Status Owner Data directory Log file 492s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 492s 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 495s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 495s Setting up libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 495s Setting up liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 495s Setting up libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 495s Setting up gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 495s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 495s Setting up libz3-dev:arm64 (4.8.7-4build1) ... 495s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 495s Setting up libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.1) ... 495s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 495s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 495s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 495s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 495s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 495s Setting up libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 495s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up libc6-dev:arm64 (2.31-0ubuntu9.17) ... 495s Setting up libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 495s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 495s Setting up libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 495s Setting up libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up cpp (4:9.3.0-1ubuntu2) ... 495s Setting up libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 495s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up gcc (4:9.3.0-1ubuntu2) ... 495s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 495s Setting up g++ (4:9.3.0-1ubuntu2) ... 495s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 495s Setting up build-essential (12.8ubuntu1.1) ... 495s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 495s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 495s Processing triggers for systemd (245.4-4ubuntu3.24) ... 495s Processing triggers for man-db (2.9.1-1) ... 497s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 498s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 515s autopkgtest [13:59:28]: test installcheck: [----------------------- 515s + dpkg-parsechangelog -SSource 515s + SOURCE=postgresql-12 515s + MAJOR=12 515s + cd src/test/regress 515s + make -f ../../../debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/12/bin/pg_config with_llvm=no 515s 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 515s 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/aarch64-linux-gnu -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-10/lib -L/usr/lib/aarch64-linux-gnu/mit-krb5 -Wl,--as-needed 515s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.xch9MN/build.vJZ/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 515s + rm -rf testtablespace results regression.* 515s + mkdir testtablespace results 515s + id -u 515s + [ 1000 = 0 ] 515s + pg_virtualenv -v 12 /usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule 516s Creating new PostgreSQL cluster 12/regress ... 516s /usr/lib/postgresql/12/bin/initdb -D /tmp/pg_virtualenv.e5hw3V/data/12/regress --auth-local peer --auth-host md5 --username=ubuntu --pwfile=/tmp/pg_virtualenv.e5hw3V/postgresql-common/pwfile --nosync 516s The files belonging to this database system will be owned by user "ubuntu". 516s This user must also own the server process. 516s 516s The database cluster will be initialized with locale "C.UTF-8". 516s The default database encoding has accordingly been set to "UTF8". 516s The default text search configuration will be set to "english". 516s 516s Data page checksums are disabled. 516s 516s fixing permissions on existing directory /tmp/pg_virtualenv.e5hw3V/data/12/regress ... ok 516s creating subdirectories ... ok 516s selecting dynamic shared memory implementation ... posix 516s selecting default max_connections ... 100 516s selecting default shared_buffers ... 128MB 516s selecting default time zone ... Etc/UTC 516s creating configuration files ... ok 516s running bootstrap script ... ok 516s performing post-bootstrap initialization ... ok 516s 516s Sync to disk skipped. 516s The data directory might become corrupt if the operating system crashes. 516s 516s Success. You can now start the database server using: 516s 516s pg_ctlcluster 12 regress start 516s 516s Warning: The parent /var/run/postgresql of the selected 516s stats_temp_directory is not writable for the cluster owner. Not adding this 516s setting in postgresql.conf. 518s Ver Cluster Port Status Owner Data directory Log file 518s 12 regress 5433 online ubuntu /tmp/pg_virtualenv.e5hw3V/data/12/regress /tmp/pg_virtualenv.e5hw3V/log/postgresql-12-regress.log 518s 518s (using postmaster on localhost, port 5433) 518s ============== dropping database "regression" ============== 518s DROP DATABASE 518s NOTICE: database "regression" does not exist, skipping 518s ============== creating database "regression" ============== 518s CREATE DATABASE 518s ALTER DATABASE 518s ============== running regression test queries ============== 519s test tablespace ... ok 149 ms 519s parallel group (20 tests): varchar char pg_lsn name oid uuid int2 text float4 txid money int4 int8 regproc enum float8 bit boolean numeric rangetypes 519s boolean ... ok 537 ms 519s char ... ok 63 ms 519s name ... ok 183 ms 519s varchar ... ok 57 ms 519s text ... ok 223 ms 519s int2 ... ok 192 ms 519s int4 ... ok 271 ms 519s int8 ... ok 271 ms 519s oid ... ok 183 ms 519s float4 ... ok 248 ms 519s float8 ... ok 308 ms 519s bit ... ok 490 ms 519s numeric ... ok 570 ms 519s txid ... ok 253 ms 519s uuid ... ok 182 ms 519s enum ... ok 282 ms 519s money ... ok 258 ms 519s rangetypes ... ok 732 ms 519s pg_lsn ... ok 118 ms 519s regproc ... ok 276 ms 520s parallel group (19 tests): numerology lseg path circle time interval macaddr line macaddr8 point inet timetz tstypes date box strings timestamptz timestamp polygon 520s strings ... ok 389 ms 520s numerology ... ok 78 ms 520s point ... ok 271 ms 520s lseg ... ok 173 ms 520s line ... ok 264 ms 520s box ... ok 370 ms 520s path ... ok 177 ms 520s polygon ... ok 650 ms 520s circle ... ok 190 ms 520s date ... ok 347 ms 520s time ... ok 201 ms 520s timetz ... ok 301 ms 520s timestamp ... ok 497 ms 520s timestamptz ... FAILED 475 ms 520s interval ... ok 226 ms 520s inet ... ok 282 ms 520s macaddr ... ok 232 ms 520s macaddr8 ... ok 263 ms 520s tstypes ... ok 302 ms 521s parallel group (10 tests): comments misc_sanity expressions database type_sanity geometry oidjoins opr_sanity horology regex 521s geometry ... ok 332 ms 521s horology ... ok 558 ms 521s regex ... ok 679 ms 521s oidjoins ... ok 338 ms 521s type_sanity ... ok 272 ms 521s opr_sanity ... ok 531 ms 521s misc_sanity ... ok 110 ms 521s comments ... ok 68 ms 521s expressions ... ok 125 ms 521s database ... ok 247 ms 521s test create_function_1 ... ok 14 ms 521s test create_type ... ok 19 ms 521s test create_table ... ok 256 ms 521s test create_function_2 ... ok 13 ms 521s parallel group (5 tests): copydml copyselect insert_conflict copy insert 521s copy ... ok 312 ms 521s copyselect ... ok 78 ms 521s copydml ... ok 50 ms 521s insert ... ok 331 ms 521s insert_conflict ... ok 201 ms 521s parallel group (4 tests): create_operator create_schema create_procedure create_misc 521s create_misc ... ok 89 ms 521s create_operator ... ok 29 ms 521s create_procedure ... ok 59 ms 521s create_schema ... ok 55 ms 523s parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 523s create_index ... ok 1194 ms 523s create_index_spgist ... ok 1126 ms 523s create_view ... ok 425 ms 523s index_including ... ok 329 ms 523s index_including_gist ... ok 360 ms 524s parallel group (16 tests): create_cast create_function_3 hash_func create_aggregate roleattributes typed_table errors drop_if_exists create_am infinite_recurse constraints vacuum select updatable_views inherit triggers 524s create_aggregate ... ok 243 ms 524s create_function_3 ... ok 136 ms 524s create_cast ... ok 23 ms 524s constraints ... ok 580 ms 524s triggers ... ok 1276 ms 524s select ... ok 631 ms 524s inherit ... ok 1165 ms 524s typed_table ... ok 296 ms 524s vacuum ... ok 625 ms 524s drop_if_exists ... ok 357 ms 524s updatable_views ... ok 963 ms 524s roleattributes ... ok 248 ms 524s create_am ... ok 372 ms 524s hash_func ... ok 225 ms 524s errors ... ok 328 ms 524s infinite_recurse ... ok 534 ms 524s test sanity_check ... ok 159 ms 526s parallel group (20 tests): select_having select_distinct_on delete random select_distinct select_implicit namespace select_into case prepared_xacts union subselect transactions portals hash_index arrays btree_index aggregates update join 526s select_into ... ok 214 ms 526s select_distinct ... ok 194 ms 526s select_distinct_on ... ok 158 ms 526s select_implicit ... ok 201 ms 526s select_having ... ok 41 ms 526s subselect ... ok 642 ms 526s union ... ok 566 ms 526s case ... ok 286 ms 526s join ... ok 1482 ms 526s aggregates ... ok 936 ms 526s transactions ... ok 701 ms 526s random ... ok 186 ms 526s portals ... ok 742 ms 526s arrays ... ok 827 ms 526s btree_index ... ok 839 ms 526s hash_index ... ok 822 ms 526s update ... ok 1081 ms 526s delete ... ok 178 ms 526s namespace ... ok 201 ms 526s prepared_xacts ... ok 386 ms 532s parallel group (20 tests): security_label init_privs drop_operator password lock tablesample object_address replica_identity identity matview gin generated spgist groupingsets brin collate rowsecurity gist join_hash privileges 532s brin ... ok 1747 ms 532s gin ... ok 1261 ms 532s gist ... ok 2001 ms 532s spgist ... ok 1724 ms 532s privileges ... ok 6332 ms 532s init_privs ... ok 175 ms 532s security_label ... ok 71 ms 532s collate ... ok 1796 ms 532s matview ... ok 1046 ms 532s lock ... ok 613 ms 532s replica_identity ... ok 711 ms 532s rowsecurity ... ok 1851 ms 532s object_address ... ok 688 ms 532s tablesample ... ok 624 ms 532s groupingsets ... ok 1725 ms 532s drop_operator ... ok 290 ms 532s password ... ok 424 ms 532s identity ... ok 893 ms 532s generated ... ok 1513 ms 532s join_hash ... ok 6160 ms 533s parallel group (11 tests): async dbsize tid alter_operator tidscan tsrf alter_generic misc_functions sysviews create_table_like misc 533s create_table_like ... ok 415 ms 533s alter_generic ... ok 197 ms 533s alter_operator ... ok 128 ms 533s misc ... ok 840 ms 533s async ... ok 80 ms 533s dbsize ... ok 89 ms 533s misc_functions ... ok 246 ms 533s sysviews ... ok 259 ms 533s tsrf ... ok 167 ms 533s tid ... ok 105 ms 533s tidscan ... ok 130 ms 534s parallel group (5 tests): psql_crosstab amutils psql rules stats_ext 534s rules ... ok 367 ms 534s psql ... ok 250 ms 534s psql_crosstab ... ok 25 ms 534s amutils ... ok 46 ms 534s stats_ext ... ok 660 ms 536s test select_parallel ... ok 2587 ms 536s test write_parallel ... ok 67 ms 536s parallel group (2 tests): subscription publication 536s publication ... ok 58 ms 536s subscription ... ok 21 ms 538s parallel group (17 tests): portals_p2 advisory_lock dependency functional_deps xmlmap combocid equivclass select_views tsdicts guc window cluster bitmapops indirect_toast foreign_data tsearch foreign_key 538s select_views ... ok 422 ms 538s portals_p2 ... ok 134 ms 538s foreign_key ... ok 1326 ms 538s cluster ... ok 781 ms 538s dependency ... ok 229 ms 538s guc ... ok 550 ms 538s bitmapops ... ok 817 ms 538s combocid ... ok 364 ms 538s tsearch ... ok 1199 ms 538s tsdicts ... ok 510 ms 538s foreign_data ... ok 1132 ms 538s window ... ok 755 ms 538s xmlmap ... ok 297 ms 538s functional_deps ... ok 293 ms 538s advisory_lock ... ok 174 ms 538s indirect_toast ... ok 878 ms 538s equivclass ... ok 386 ms 538s parallel group (6 tests): json_encoding jsonpath_encoding jsonpath json jsonb_jsonpath jsonb 538s json ... ok 139 ms 538s jsonb ... ok 234 ms 538s json_encoding ... ok 22 ms 538s jsonpath ... ok 83 ms 538s jsonpath_encoding ... ok 48 ms 538s jsonb_jsonpath ... ok 145 ms 540s parallel group (18 tests): conversion limit returning prepare rowtypes sequence temp plancache copy2 with truncate polymorphism largeobject domain plpgsql rangefuncs xml alter_table 540s plancache ... ok 524 ms 540s limit ... ok 184 ms 540s plpgsql ... ok 1315 ms 540s copy2 ... ok 713 ms 540s temp ... ok 477 ms 540s domain ... ok 1034 ms 540s rangefuncs ... ok 1318 ms 540s prepare ... ok 233 ms 540s conversion ... ok 101 ms 540s truncate ... ok 804 ms 540s alter_table ... ok 1831 ms 540s sequence ... ok 383 ms 540s polymorphism ... ok 822 ms 540s rowtypes ... ok 368 ms 540s returning ... ok 200 ms 540s largeobject ... ok 1004 ms 540s with ... ok 743 ms 540s xml ... ok 1404 ms 541s parallel group (7 tests): hash_part reloptions partition_info partition_join indexing partition_aggregate partition_prune 541s partition_join ... ok 603 ms 541s partition_prune ... ok 1388 ms 541s reloptions ... ok 98 ms 541s hash_part ... ok 80 ms 541s indexing ... ok 942 ms 541s partition_aggregate ... ok 967 ms 541s partition_info ... ok 147 ms 541s test event_trigger ... ok 90 ms 541s test fast_default ... ok 109 ms 542s test stats ... ok 578 ms 542s 542s ======================== 542s 1 of 196 tests failed. 542s ======================== 542s 542s The differences that caused some tests to fail can be viewed in the 542s file "/tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/regression.diffs". A copy of the test summary that you see 542s above is saved in the file "/tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/regression.out". 542s 542s *** /tmp/pg_virtualenv.e5hw3V/log/postgresql-12-regress.log (last 100 lines) *** 542s 2025-02-26 13:59:54.083 UTC [7295] ubuntu@regression DETAIL: Key (a)=(3) already exists. 542s 2025-02-26 13:59:54.083 UTC [7295] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression DETAIL: Key (a)=(4) already exists. 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 542s 2025-02-26 13:59:54.088 UTC [7295] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 542s 2025-02-26 13:59:54.091 UTC [7295] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 542s 2025-02-26 13:59:54.091 UTC [7295] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 542s 2025-02-26 13:59:54.097 UTC [7295] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 542s 2025-02-26 13:59:54.097 UTC [7295] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 542s 2025-02-26 13:59:54.146 UTC [7295] ubuntu@regression ERROR: division by zero 542s 2025-02-26 13:59:54.146 UTC [7295] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 542s 2025-02-26 13:59:54.623 UTC [7376] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 542s 2025-02-26 13:59:54.623 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 542s on ddl_command_start 542s execute procedure pg_backend_pid(); 542s 2025-02-26 13:59:54.625 UTC [7376] ubuntu@regression ERROR: trigger functions can only be called as triggers 542s 2025-02-26 13:59:54.625 UTC [7376] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 542s 2025-02-26 13:59:54.625 UTC [7376] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 542s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 542s SELECT 1 $$ language sql; 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 542s 2025-02-26 13:59:54.626 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: unrecognized filter variable "food" 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when food in ('sandwich') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('sandwich') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('create table', 'create skunkcabbage') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('DROP EVENT TRIGGER') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('CREATE ROLE') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('CREATE DATABASE') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('CREATE TABLESPACE') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: filter variable "tag" specified more than once 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s when tag in ('create table') and tag in ('CREATE FUNCTION') 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 542s 2025-02-26 13:59:54.627 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 542s execute procedure test_event_trigger('argument not allowed'); 542s 2025-02-26 13:59:54.628 UTC [7376] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 542s 2025-02-26 13:59:54.628 UTC [7376] ubuntu@regression HINT: Must be superuser to create an event trigger. 542s 2025-02-26 13:59:54.628 UTC [7376] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 542s execute procedure test_event_trigger(); 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 542s 2025-02-26 13:59:54.637 UTC [7376] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 542s 2025-02-26 13:59:54.638 UTC [7376] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 542s 2025-02-26 13:59:54.638 UTC [7376] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 542s owner of user mapping for regress_evt_user on server useless_server 542s owner of default privileges on new relations belonging to role regress_evt_user 542s 2025-02-26 13:59:54.638 UTC [7376] ubuntu@regression STATEMENT: drop role regress_evt_user; 542s 2025-02-26 13:59:54.650 UTC [7376] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 542s 2025-02-26 13:59:54.650 UTC [7376] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 542s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 542s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 542s 2025-02-26 13:59:54.650 UTC [7376] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 542s 2025-02-26 13:59:54.653 UTC [7376] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 542s 2025-02-26 13:59:54.653 UTC [7376] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 542s 2025-02-26 13:59:54.653 UTC [7376] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 542s 2025-02-26 13:59:54.680 UTC [7376] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 542s 2025-02-26 13:59:54.680 UTC [7376] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 542s 2025-02-26 13:59:54.685 UTC [7376] ubuntu@regression ERROR: rewrites not allowed 542s 2025-02-26 13:59:54.685 UTC [7376] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 542s 2025-02-26 13:59:54.685 UTC [7376] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 542s 2025-02-26 13:59:54.698 UTC [7376] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 542s 2025-02-26 13:59:54.698 UTC [7376] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 542s 2025-02-26 13:59:55.384 UTC [7385] ubuntu@regression LOG: wait_for_stats delayed 0.5213 seconds 542s 2025-02-26 13:59:55.384 UTC [7385] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 542s 2025-02-26 13:59:55.384 UTC [7385] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 542s Dropping cluster 12/regress ... 542s + cat regression.diffs 542s diff -U3 /tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/expected/timestamptz.out /tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/results/timestamptz.out 542s --- /tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:41:03.000000000 +0000 542s +++ /tmp/autopkgtest.xch9MN/build.vJZ/src/src/test/regress/results/timestamptz.out 2025-02-26 13:59:33.290835576 +0000 542s @@ -2060,7 +2060,7 @@ 542s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 542s timezone 542s -------------------------- 542s - Wed Dec 09 15:56:00 1846 542s + Wed Dec 09 15:56:08 1846 542s (1 row) 542s 542s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 542s + exit 1 543s autopkgtest [13:59:56]: test installcheck: -----------------------] 543s autopkgtest [13:59:56]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 543s installcheck FAIL non-zero exit status 1 543s autopkgtest [13:59:56]: @@@@@@@@@@@@@@@@@@@@ summary 543s run-testsuite PASS 543s installcheck FAIL non-zero exit status 1 560s nova [W] Using flock in prodstack6-arm64 560s Creating nova instance adt-focal-arm64-postgresql-12-20250226-131551-juju-7f2275-prod-proposed-migration-environment-15-3c30380e-6b55-4816-b432-2424cddc82dd from image adt/ubuntu-focal-arm64-server-20250226.img (UUID 726743c4-eaa7-4228-9fb1-69506b9e52ca)... 560s nova [W] Timed out waiting for fccd1124-cd33-42f9-940e-965b8a03d9f4 to get deleted. 560s nova [W] Using flock in prodstack6-arm64 560s Creating nova instance adt-focal-arm64-postgresql-12-20250226-131551-juju-7f2275-prod-proposed-migration-environment-15-3c30380e-6b55-4816-b432-2424cddc82dd from image adt/ubuntu-focal-arm64-server-20250226.img (UUID 726743c4-eaa7-4228-9fb1-69506b9e52ca)... 560s nova [W] Timed out waiting for 7265724b-9cd6-48f1-8560-f3e7ca3549e2 to get deleted.