0s autopkgtest [13:38:40]: starting date and time: 2025-02-26 13:38:40+0000 0s autopkgtest [13:38:40]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:38:40]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.dyx51rqk/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-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-8.secgroup --name adt-focal-ppc64el-postgresql-12-20250226-133840-juju-7f2275-prod-proposed-migration-environment-2-650c6102-816f-4ce1-94a1-612799d31590 --image adt/ubuntu-focal-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 69s autopkgtest [13:39:49]: testbed dpkg architecture: ppc64el 70s autopkgtest [13:39:50]: testbed apt version: 2.0.10 70s autopkgtest [13:39:50]: @@@@@@@@@@@@@@@@@@@@ test bed setup 70s autopkgtest [13:39:50]: testbed release detected to be: None 71s autopkgtest [13:39:51]: updating testbed package index (apt update) 71s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 71s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 72s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 72s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 72s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 72s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 72s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 72s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 72s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el Packages [140 kB] 72s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el c-n-f Metadata [1444 B] 72s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted ppc64el Packages [1872 B] 72s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted ppc64el c-n-f Metadata [116 B] 72s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe ppc64el Packages [33.2 kB] 72s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe ppc64el c-n-f Metadata [1760 B] 72s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse ppc64el Packages [952 B] 72s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse ppc64el c-n-f Metadata [116 B] 75s Fetched 560 kB in 1s (575 kB/s) 76s Reading package lists... 77s Reading package lists... 77s Building dependency tree... 77s Reading state information... 77s Calculating upgrade... 77s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 78s Reading package lists... 78s Building dependency tree... 78s Reading state information... 78s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 78s autopkgtest [13:39:58]: upgrading testbed (apt dist-upgrade and autopurge) 78s Reading package lists... 78s Building dependency tree... 78s Reading state information... 78s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 78s Starting 2 pkgProblemResolver with broken count: 0 78s Done 78s 79s The following packages will be upgraded: 79s tzdata 79s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 79s Need to get 300 kB of archives. 79s After this operation, 3072 B of additional disk space will be used. 79s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el tzdata all 2025a-0ubuntu0.20.04 [300 kB] 79s Preconfiguring packages ... 79s Fetched 300 kB in 0s (736 kB/s) 80s (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 ... 94082 files and directories currently installed.) 80s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 80s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 80s Setting up tzdata (2025a-0ubuntu0.20.04) ... 80s 80s Current default time zone: 'Etc/UTC' 80s Local time is now: Wed Feb 26 13:40:00 UTC 2025. 80s Universal Time is now: Wed Feb 26 13:40:00 UTC 2025. 80s Run 'dpkg-reconfigure tzdata' if you wish to change it. 80s 81s Reading package lists... 81s Building dependency tree... 81s Reading state information... 81s Starting pkgProblemResolver with broken count: 0 81s Starting 2 pkgProblemResolver with broken count: 0 81s Done 81s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 84s autopkgtest [13:40:04]: testbed running kernel: Linux 5.4.0-208-generic #228-Ubuntu SMP Fri Feb 7 19:47:07 UTC 2025 84s autopkgtest [13:40:04]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-12 97s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (dsc) [3764 B] 97s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (tar) [27.9 MB] 97s 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 99s autopkgtest [13:40:19]: testing package postgresql-12 version 12.22-0ubuntu0.20.04.1 101s autopkgtest [13:40:21]: build not needed 108s autopkgtest [13:40:28]: test run-testsuite: preparing testbed 108s Reading package lists... 109s Building dependency tree... 109s Reading state information... 109s Starting pkgProblemResolver with broken count: 0 109s Starting 2 pkgProblemResolver with broken count: 0 109s Done 109s The following NEW packages will be installed: 109s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 109s emacsen-common g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us libasan5 109s libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-10-dev 109s libclang-cpp10 libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev 109s libecpg6 libffi-dev libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 109s libllvm10 liblsan0 libmpc3 libncurses-dev libobjc-9-dev libobjc4 libpfm4 109s libpgtypes3 libpq-dev libpq5 libpython3.8 libquadmath0 libstdc++-9-dev 109s libtcl8.6 libtinfo-dev libtsan0 libubsan1 libxslt1.1 libz3-4 libz3-dev 109s linux-libc-dev llvm-10 llvm-10-dev llvm-10-runtime llvm-10-tools net-tools 109s postgresql-12 postgresql-client-12 postgresql-client-common 109s postgresql-common postgresql-doc-12 postgresql-plperl-12 109s postgresql-plpython3-12 postgresql-pltcl-12 postgresql-server-dev-12 109s python3-pygments ssl-cert 109s 0 upgraded, 68 newly installed, 0 to remove and 0 not upgraded. 109s Need to get 133 MB of archives. 109s After this operation, 758 MB of additional disk space will be used. 109s Get:1 http://ftpmaster.internal/ubuntu focal/universe ppc64el binfmt-support ppc64el 2.2.0-2 [69.4 kB] 109s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libc-dev-bin ppc64el 2.31-0ubuntu9.17 [72.9 kB] 109s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el linux-libc-dev ppc64el 5.4.0-208.228 [1112 kB] 109s Get:4 http://ftpmaster.internal/ubuntu focal/main ppc64el libcrypt-dev ppc64el 1:4.4.10-10ubuntu4 [139 kB] 109s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libc6-dev ppc64el 2.31-0ubuntu9.17 [2516 kB] 110s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el gcc-9-base ppc64el 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 110s Get:7 http://ftpmaster.internal/ubuntu focal/main ppc64el libisl22 ppc64el 0.22.1-1 [691 kB] 110s Get:8 http://ftpmaster.internal/ubuntu focal/main ppc64el libmpc3 ppc64el 1.1.0-1 [40.5 kB] 110s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el cpp-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [6847 kB] 110s Get:10 http://ftpmaster.internal/ubuntu focal/main ppc64el cpp ppc64el 4:9.3.0-1ubuntu2 [27.6 kB] 110s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libcc1-0 ppc64el 10.5.0-1ubuntu1~20.04 [42.1 kB] 110s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libgomp1 ppc64el 10.5.0-1ubuntu1~20.04 [109 kB] 110s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libitm1 ppc64el 10.5.0-1ubuntu1~20.04 [28.5 kB] 110s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libatomic1 ppc64el 10.5.0-1ubuntu1~20.04 [10.0 kB] 110s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libasan5 ppc64el 9.4.0-1ubuntu1~20.04.2 [2784 kB] 110s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el liblsan0 ppc64el 10.5.0-1ubuntu1~20.04 [848 kB] 110s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libtsan0 ppc64el 10.5.0-1ubuntu1~20.04 [2029 kB] 110s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libubsan1 ppc64el 10.5.0-1ubuntu1~20.04 [800 kB] 110s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libquadmath0 ppc64el 10.5.0-1ubuntu1~20.04 [149 kB] 110s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libgcc-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [1258 kB] 110s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el gcc-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [7591 kB] 111s Get:22 http://ftpmaster.internal/ubuntu focal/main ppc64el gcc ppc64el 4:9.3.0-1ubuntu2 [5228 B] 111s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libstdc++-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [1762 kB] 111s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el g++-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [7765 kB] 111s Get:25 http://ftpmaster.internal/ubuntu focal/main ppc64el g++ ppc64el 4:9.3.0-1ubuntu2 [1600 B] 111s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el build-essential ppc64el 12.8ubuntu1.1 [4664 B] 111s Get:27 http://ftpmaster.internal/ubuntu focal/main ppc64el libllvm10 ppc64el 1:10.0.0-4ubuntu1 [14.4 MB] 112s Get:28 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang-cpp10 ppc64el 1:10.0.0-4ubuntu1 [9294 kB] 113s Get:29 http://ftpmaster.internal/ubuntu focal/main ppc64el libgc1c2 ppc64el 1:7.6.4-0.4ubuntu1 [85.8 kB] 113s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el libobjc4 ppc64el 10.5.0-1ubuntu1~20.04 [47.4 kB] 113s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el libobjc-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [231 kB] 113s Get:32 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang-common-10-dev ppc64el 1:10.0.0-4ubuntu1 [3049 kB] 113s Get:33 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang1-10 ppc64el 1:10.0.0-4ubuntu1 [7301 kB] 113s Get:34 http://ftpmaster.internal/ubuntu focal/universe ppc64el clang-10 ppc64el 1:10.0.0-4ubuntu1 [66.1 kB] 113s Get:35 http://ftpmaster.internal/ubuntu focal/main ppc64el emacsen-common all 3.0.4 [14.9 kB] 113s Get:36 http://ftpmaster.internal/ubuntu focal/main ppc64el dictionaries-common all 1.28.1 [178 kB] 113s Get:37 http://ftpmaster.internal/ubuntu focal/main ppc64el hunspell-en-us all 1:2018.04.16-1 [170 kB] 113s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpgtypes3 ppc64el 12.22-0ubuntu0.20.04.1 [50.6 kB] 113s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpq5 ppc64el 12.22-0ubuntu0.20.04.1 [135 kB] 113s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg6 ppc64el 12.22-0ubuntu0.20.04.1 [47.6 kB] 113s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg-compat3 ppc64el 12.22-0ubuntu0.20.04.1 [13.3 kB] 113s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpq-dev ppc64el 12.22-0ubuntu0.20.04.1 [153 kB] 113s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg-dev ppc64el 12.22-0ubuntu0.20.04.1 [244 kB] 113s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libncurses-dev ppc64el 6.2-0ubuntu2.1 [413 kB] 114s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpython3.8 ppc64el 3.8.10-0ubuntu1~20.04.15 [1690 kB] 114s Get:46 http://ftpmaster.internal/ubuntu focal/main ppc64el libtcl8.6 ppc64el 8.6.10+dfsg-1 [1008 kB] 114s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libtinfo-dev ppc64el 6.2-0ubuntu2.1 [976 B] 114s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libxslt1.1 ppc64el 1.1.34-4ubuntu0.20.04.1 [166 kB] 114s Get:49 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-runtime ppc64el 1:10.0.0-4ubuntu1 [985 kB] 114s Get:50 http://ftpmaster.internal/ubuntu focal/main ppc64el libpfm4 ppc64el 4.10.1+git20-g7700f49-2 [140 kB] 114s Get:51 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10 ppc64el 1:10.0.0-4ubuntu1 [4821 kB] 114s Get:52 http://ftpmaster.internal/ubuntu focal/main ppc64el libffi-dev ppc64el 3.3-4 [60.7 kB] 114s Get:53 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 114s Get:54 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-tools ppc64el 1:10.0.0-4ubuntu1 [336 kB] 114s Get:55 http://ftpmaster.internal/ubuntu focal/universe ppc64el libz3-4 ppc64el 4.8.7-4build1 [6665 kB] 115s Get:56 http://ftpmaster.internal/ubuntu focal/universe ppc64el libz3-dev ppc64el 4.8.7-4build1 [67.5 kB] 115s Get:57 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-dev ppc64el 1:10.0.0-4ubuntu1 [25.4 MB] 116s Get:58 http://ftpmaster.internal/ubuntu focal/main ppc64el net-tools ppc64el 1.60+git20180626.aebd88e-1ubuntu1 [220 kB] 116s Get:59 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-client-common all 214ubuntu0.1 [28.2 kB] 116s Get:60 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-client-12 ppc64el 12.22-0ubuntu0.20.04.1 [1108 kB] 116s Get:61 http://ftpmaster.internal/ubuntu focal/main ppc64el ssl-cert all 1.0.39 [17.0 kB] 116s Get:62 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-common all 214ubuntu0.1 [169 kB] 116s Get:63 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-12 ppc64el 12.22-0ubuntu0.20.04.1 [14.1 MB] 117s Get:64 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 117s Get:65 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-plperl-12 ppc64el 12.22-0ubuntu0.20.04.1 [71.2 kB] 117s Get:66 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-plpython3-12 ppc64el 12.22-0ubuntu0.20.04.1 [77.6 kB] 117s Get:67 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-pltcl-12 ppc64el 12.22-0ubuntu0.20.04.1 [31.9 kB] 117s Get:68 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-server-dev-12 ppc64el 12.22-0ubuntu0.20.04.1 [1017 kB] 118s Preconfiguring packages ... 118s Fetched 133 MB in 8s (16.5 MB/s) 118s Selecting previously unselected package binfmt-support. 118s (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 ... 94083 files and directories currently installed.) 118s Preparing to unpack .../00-binfmt-support_2.2.0-2_ppc64el.deb ... 118s Unpacking binfmt-support (2.2.0-2) ... 118s Selecting previously unselected package libc-dev-bin. 118s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_ppc64el.deb ... 118s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 118s Selecting previously unselected package linux-libc-dev:ppc64el. 118s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_ppc64el.deb ... 118s Unpacking linux-libc-dev:ppc64el (5.4.0-208.228) ... 118s Selecting previously unselected package libcrypt-dev:ppc64el. 118s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_ppc64el.deb ... 118s Unpacking libcrypt-dev:ppc64el (1:4.4.10-10ubuntu4) ... 118s Selecting previously unselected package libc6-dev:ppc64el. 118s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_ppc64el.deb ... 118s Unpacking libc6-dev:ppc64el (2.31-0ubuntu9.17) ... 118s Selecting previously unselected package gcc-9-base:ppc64el. 118s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 118s Unpacking gcc-9-base:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 118s Selecting previously unselected package libisl22:ppc64el. 118s Preparing to unpack .../06-libisl22_0.22.1-1_ppc64el.deb ... 118s Unpacking libisl22:ppc64el (0.22.1-1) ... 118s Selecting previously unselected package libmpc3:ppc64el. 118s Preparing to unpack .../07-libmpc3_1.1.0-1_ppc64el.deb ... 118s Unpacking libmpc3:ppc64el (1.1.0-1) ... 119s Selecting previously unselected package cpp-9. 119s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 119s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 119s Selecting previously unselected package cpp. 119s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 119s Unpacking cpp (4:9.3.0-1ubuntu2) ... 119s Selecting previously unselected package libcc1-0:ppc64el. 119s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 119s Unpacking libcc1-0:ppc64el (10.5.0-1ubuntu1~20.04) ... 119s Selecting previously unselected package libgomp1:ppc64el. 119s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 119s Unpacking libgomp1:ppc64el (10.5.0-1ubuntu1~20.04) ... 119s Selecting previously unselected package libitm1:ppc64el. 119s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 119s Unpacking libitm1:ppc64el (10.5.0-1ubuntu1~20.04) ... 119s Selecting previously unselected package libatomic1:ppc64el. 119s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 119s Unpacking libatomic1:ppc64el (10.5.0-1ubuntu1~20.04) ... 119s Selecting previously unselected package libasan5:ppc64el. 119s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 119s Unpacking libasan5:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 120s Selecting previously unselected package liblsan0:ppc64el. 120s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 120s Unpacking liblsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 120s Selecting previously unselected package libtsan0:ppc64el. 120s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 120s Unpacking libtsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 120s Selecting previously unselected package libubsan1:ppc64el. 120s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 120s Unpacking libubsan1:ppc64el (10.5.0-1ubuntu1~20.04) ... 120s Selecting previously unselected package libquadmath0:ppc64el. 120s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 120s Unpacking libquadmath0:ppc64el (10.5.0-1ubuntu1~20.04) ... 120s Selecting previously unselected package libgcc-9-dev:ppc64el. 120s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 120s Unpacking libgcc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 120s Selecting previously unselected package gcc-9. 120s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 120s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 121s Selecting previously unselected package gcc. 121s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 121s Unpacking gcc (4:9.3.0-1ubuntu2) ... 121s Selecting previously unselected package libstdc++-9-dev:ppc64el. 121s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 121s Unpacking libstdc++-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 121s Selecting previously unselected package g++-9. 121s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 121s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 122s Selecting previously unselected package g++. 122s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 122s Unpacking g++ (4:9.3.0-1ubuntu2) ... 122s Selecting previously unselected package build-essential. 122s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_ppc64el.deb ... 122s Unpacking build-essential (12.8ubuntu1.1) ... 122s Selecting previously unselected package libllvm10:ppc64el. 122s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 122s Unpacking libllvm10:ppc64el (1:10.0.0-4ubuntu1) ... 123s Selecting previously unselected package libclang-cpp10. 123s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 123s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 124s Selecting previously unselected package libgc1c2:ppc64el. 124s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_ppc64el.deb ... 124s Unpacking libgc1c2:ppc64el (1:7.6.4-0.4ubuntu1) ... 124s Selecting previously unselected package libobjc4:ppc64el. 124s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 124s Unpacking libobjc4:ppc64el (10.5.0-1ubuntu1~20.04) ... 124s Selecting previously unselected package libobjc-9-dev:ppc64el. 124s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 124s Unpacking libobjc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 124s Selecting previously unselected package libclang-common-10-dev. 124s Preparing to unpack .../31-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 124s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 125s Selecting previously unselected package libclang1-10. 125s Preparing to unpack .../32-libclang1-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 125s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 125s Selecting previously unselected package clang-10. 125s Preparing to unpack .../33-clang-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 125s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 125s Selecting previously unselected package emacsen-common. 125s Preparing to unpack .../34-emacsen-common_3.0.4_all.deb ... 125s Unpacking emacsen-common (3.0.4) ... 125s Selecting previously unselected package dictionaries-common. 125s Preparing to unpack .../35-dictionaries-common_1.28.1_all.deb ... 125s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 125s Unpacking dictionaries-common (1.28.1) ... 125s Selecting previously unselected package hunspell-en-us. 126s Preparing to unpack .../36-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 126s Unpacking hunspell-en-us (1:2018.04.16-1) ... 126s Selecting previously unselected package libpgtypes3:ppc64el. 126s Preparing to unpack .../37-libpgtypes3_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libpgtypes3:ppc64el (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libpq5:ppc64el. 126s Preparing to unpack .../38-libpq5_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libpq5:ppc64el (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libecpg6:ppc64el. 126s Preparing to unpack .../39-libecpg6_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libecpg6:ppc64el (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libecpg-compat3:ppc64el. 126s Preparing to unpack .../40-libecpg-compat3_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libecpg-compat3:ppc64el (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libpq-dev. 126s Preparing to unpack .../41-libpq-dev_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libecpg-dev. 126s Preparing to unpack .../42-libecpg-dev_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 126s Selecting previously unselected package libncurses-dev:ppc64el. 126s Preparing to unpack .../43-libncurses-dev_6.2-0ubuntu2.1_ppc64el.deb ... 126s Unpacking libncurses-dev:ppc64el (6.2-0ubuntu2.1) ... 126s Selecting previously unselected package libpython3.8:ppc64el. 126s Preparing to unpack .../44-libpython3.8_3.8.10-0ubuntu1~20.04.15_ppc64el.deb ... 126s Unpacking libpython3.8:ppc64el (3.8.10-0ubuntu1~20.04.15) ... 126s Selecting previously unselected package libtcl8.6:ppc64el. 126s Preparing to unpack .../45-libtcl8.6_8.6.10+dfsg-1_ppc64el.deb ... 126s Unpacking libtcl8.6:ppc64el (8.6.10+dfsg-1) ... 126s Selecting previously unselected package libtinfo-dev:ppc64el. 126s Preparing to unpack .../46-libtinfo-dev_6.2-0ubuntu2.1_ppc64el.deb ... 126s Unpacking libtinfo-dev:ppc64el (6.2-0ubuntu2.1) ... 126s Selecting previously unselected package libxslt1.1:ppc64el. 126s Preparing to unpack .../47-libxslt1.1_1.1.34-4ubuntu0.20.04.1_ppc64el.deb ... 126s Unpacking libxslt1.1:ppc64el (1.1.34-4ubuntu0.20.04.1) ... 126s Selecting previously unselected package llvm-10-runtime. 126s Preparing to unpack .../48-llvm-10-runtime_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 126s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 126s Selecting previously unselected package libpfm4:ppc64el. 126s Preparing to unpack .../49-libpfm4_4.10.1+git20-g7700f49-2_ppc64el.deb ... 126s Unpacking libpfm4:ppc64el (4.10.1+git20-g7700f49-2) ... 126s Selecting previously unselected package llvm-10. 126s Preparing to unpack .../50-llvm-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 126s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 127s Selecting previously unselected package libffi-dev:ppc64el. 127s Preparing to unpack .../51-libffi-dev_3.3-4_ppc64el.deb ... 127s Unpacking libffi-dev:ppc64el (3.3-4) ... 127s Selecting previously unselected package python3-pygments. 127s Preparing to unpack .../52-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 127s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 127s Selecting previously unselected package llvm-10-tools. 127s Preparing to unpack .../53-llvm-10-tools_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 127s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 127s Selecting previously unselected package libz3-4:ppc64el. 127s Preparing to unpack .../54-libz3-4_4.8.7-4build1_ppc64el.deb ... 127s Unpacking libz3-4:ppc64el (4.8.7-4build1) ... 127s Selecting previously unselected package libz3-dev:ppc64el. 127s Preparing to unpack .../55-libz3-dev_4.8.7-4build1_ppc64el.deb ... 127s Unpacking libz3-dev:ppc64el (4.8.7-4build1) ... 127s Selecting previously unselected package llvm-10-dev. 127s Preparing to unpack .../56-llvm-10-dev_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 127s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 130s Selecting previously unselected package net-tools. 130s Preparing to unpack .../57-net-tools_1.60+git20180626.aebd88e-1ubuntu1_ppc64el.deb ... 130s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 130s Selecting previously unselected package postgresql-client-common. 130s Preparing to unpack .../58-postgresql-client-common_214ubuntu0.1_all.deb ... 130s Unpacking postgresql-client-common (214ubuntu0.1) ... 130s Selecting previously unselected package postgresql-client-12. 130s Preparing to unpack .../59-postgresql-client-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 130s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 130s Selecting previously unselected package ssl-cert. 130s Preparing to unpack .../60-ssl-cert_1.0.39_all.deb ... 130s Unpacking ssl-cert (1.0.39) ... 130s Selecting previously unselected package postgresql-common. 130s Preparing to unpack .../61-postgresql-common_214ubuntu0.1_all.deb ... 130s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 130s Unpacking postgresql-common (214ubuntu0.1) ... 130s Selecting previously unselected package postgresql-12. 130s Preparing to unpack .../62-postgresql-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 130s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 131s Selecting previously unselected package postgresql-doc-12. 131s Preparing to unpack .../63-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 131s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 132s Selecting previously unselected package postgresql-plperl-12. 132s Preparing to unpack .../64-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 132s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 132s Selecting previously unselected package postgresql-plpython3-12. 132s Preparing to unpack .../65-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 132s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 132s Selecting previously unselected package postgresql-pltcl-12. 132s Preparing to unpack .../66-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 132s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 132s Selecting previously unselected package postgresql-server-dev-12. 132s Preparing to unpack .../67-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 132s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 132s Setting up postgresql-client-common (214ubuntu0.1) ... 132s Setting up libpgtypes3:ppc64el (12.22-0ubuntu0.20.04.1) ... 132s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 132s Setting up libgc1c2:ppc64el (1:7.6.4-0.4ubuntu1) ... 132s Setting up libpq5:ppc64el (12.22-0ubuntu0.20.04.1) ... 132s Setting up linux-libc-dev:ppc64el (5.4.0-208.228) ... 132s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 132s Setting up libobjc4:ppc64el (10.5.0-1ubuntu1~20.04) ... 132s Setting up libgomp1:ppc64el (10.5.0-1ubuntu1~20.04) ... 132s Setting up libffi-dev:ppc64el (3.3-4) ... 132s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 132s 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 132s Setting up libllvm10:ppc64el (1:10.0.0-4ubuntu1) ... 132s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 133s Setting up libz3-4:ppc64el (4.8.7-4build1) ... 133s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 133s 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 133s Setting up libpfm4:ppc64el (4.10.1+git20-g7700f49-2) ... 133s Setting up emacsen-common (3.0.4) ... 133s Setting up ssl-cert (1.0.39) ... 133s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 133s Setting up libpython3.8:ppc64el (3.8.10-0ubuntu1~20.04.15) ... 133s Setting up libquadmath0:ppc64el (10.5.0-1ubuntu1~20.04) ... 133s Setting up postgresql-common (214ubuntu0.1) ... 134s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 134s Adding user postgres to group ssl-cert 134s 134s Creating config file /etc/postgresql-common/createcluster.conf with new version 134s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 134s en_us 134s Removing obsolete dictionary files: 134s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 135s Setting up libmpc3:ppc64el (1.1.0-1) ... 135s Setting up libatomic1:ppc64el (10.5.0-1ubuntu1~20.04) ... 135s Setting up libtcl8.6:ppc64el (8.6.10+dfsg-1) ... 135s Setting up binfmt-support (2.2.0-2) ... 135s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 136s Setting up libubsan1:ppc64el (10.5.0-1ubuntu1~20.04) ... 136s Setting up libcrypt-dev:ppc64el (1:4.4.10-10ubuntu4) ... 136s Setting up libxslt1.1:ppc64el (1.1.34-4ubuntu0.20.04.1) ... 136s Setting up libecpg6:ppc64el (12.22-0ubuntu0.20.04.1) ... 136s Setting up libisl22:ppc64el (0.22.1-1) ... 136s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 136s Creating new PostgreSQL cluster 12/main ... 136s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 137s The files belonging to this database system will be owned by user "postgres". 137s This user must also own the server process. 137s 137s The database cluster will be initialized with locale "C.UTF-8". 137s The default database encoding has accordingly been set to "UTF8". 137s The default text search configuration will be set to "english". 137s 137s Data page checksums are disabled. 137s 137s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 137s creating subdirectories ... ok 137s selecting dynamic shared memory implementation ... posix 137s selecting default max_connections ... 100 137s selecting default shared_buffers ... 128MB 137s selecting default time zone ... Etc/UTC 137s creating configuration files ... ok 137s running bootstrap script ... ok 137s performing post-bootstrap initialization ... ok 137s syncing data to disk ... ok 137s 137s Success. You can now start the database server using: 137s 137s pg_ctlcluster 12 main start 137s 138s Ver Cluster Port Status Owner Data directory Log file 138s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 138s 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 141s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 141s Setting up libcc1-0:ppc64el (10.5.0-1ubuntu1~20.04) ... 141s Setting up liblsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 141s Setting up libitm1:ppc64el (10.5.0-1ubuntu1~20.04) ... 141s Setting up gcc-9-base:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up libtsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 141s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 141s Setting up libz3-dev:ppc64el (4.8.7-4build1) ... 141s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 141s Setting up libecpg-compat3:ppc64el (12.22-0ubuntu0.20.04.1) ... 141s Setting up dictionaries-common (1.28.1) ... 141s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 141s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 141s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 141s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 141s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 141s Setting up libasan5:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 141s Setting up hunspell-en-us (1:2018.04.16-1) ... 141s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up libc6-dev:ppc64el (2.31-0ubuntu9.17) ... 141s Setting up libncurses-dev:ppc64el (6.2-0ubuntu2.1) ... 141s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 141s Setting up libgcc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 141s Setting up libobjc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up cpp (4:9.3.0-1ubuntu2) ... 141s Setting up libtinfo-dev:ppc64el (6.2-0ubuntu2.1) ... 141s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up libstdc++-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up gcc (4:9.3.0-1ubuntu2) ... 141s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 141s Setting up g++ (4:9.3.0-1ubuntu2) ... 141s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 141s Setting up build-essential (12.8ubuntu1.1) ... 141s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 141s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 141s Processing triggers for systemd (245.4-4ubuntu3.24) ... 141s Processing triggers for man-db (2.9.1-1) ... 143s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 143s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 143s Processing triggers for dictionaries-common (1.28.1) ... 147s autopkgtest [13:41:07]: test run-testsuite: [----------------------- 147s Generating locales (this might take a while)... 148s en_US.UTF-8... done 149s ru_RU.ISO-8859-5... done 150s ru_RU.UTF-8... done 150s Generation complete. 151s ====== Running all tests with umask 077 ======= 151s === Running test 001_packages.t ... === 151s 1..18 151s # PostgreSQL versions installed: 12 151s ok 1 - postgresql-12 installed 151s ok 2 # skip No python2 support 151s ok 3 - postgresql-plpython3-12 installed 151s ok 4 - postgresql-plperl-12 installed 151s ok 5 - postgresql-pltcl-12 installed 151s ok 6 - postgresql-server-dev-12 installed 151s ok 7 # skip No postgresql-contrib-12 package for version 12 151s ok 8 - libecpg-dev installed 151s ok 9 - procps installed 151s ok 10 - netcat-openbsd installed 151s ok 11 - hunspell-en-us installed 151s ok 12 - system has a default UTF-8 locale 151s ok 13 - locale ru_RU exists 151s ok 14 - locale ru_RU.UTF-8 exists 151s ok 15 - user postgres in the UNIX group ssl-cert 151s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 151s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 151s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 151s === Running test 002_existing_clusters.t ... === 151s 1..8 151s ok 1 - Cleanup: No clusters left behind 151s ok 2 - No postgres processes left behind 151s ok 3 - No files in /etc/postgresql left behind 151s ok 4 - No files in /var/lib/postgresql left behind 151s ok 5 - No files in /var/run/postgresql left behind 151s ok 6 - No files in /var/log/postgresql left behind 151s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 151s ok 8 - PostgreSQL TCP ports are closed 151s === Running test 003_package_checks.t ... === 151s 1..4 151s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 151s ok 2 - psql is linked against libedit 151s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 151s ok 4 - psql is not linked against libreadline 151s === Running test 005_PgCommon.t ... === 151s 1..24 151s ok 1 - correctly parsed line 'local all postgres ident sameuser' 151s ok 2 - correctly parsed line 'local foo nobody trust' 151s ok 3 - correctly parsed line 'local foo nobody crypt' 151s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 151s ok 5 - correctly parsed line 'local foo,bar nobody ident' 151s ok 6 - correctly parsed line 'local all +foogrp password' 151s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 151s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 151s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 151s ok 10 - @expected_records has correct number of entries 151s ok 11 - returned read_pg_hba array has correct number of records 151s ok 12 - line 'foo all all md5' parsed as invalid 151s ok 13 - line 'local all all foo' parsed as invalid 151s ok 14 - line 'host all all foo' parsed as invalid 151s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 151s ok 16 - line 'host all all md5' parsed as invalid 151s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 151s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 151s ok 19 - read_conf_file returns empty dict for nonexisting file 151s ok 20 - read_conf_file() parsing 151s ok 21 - read_conf_file() parsing with include directives 151s ok 22 - set_conf_value 151s ok 23 - disable_conf_value 151s ok 24 - replace_conf_value 151s === Running test 006_next_free_port.t ... === 151s 1..5 151s ok 1 - next_free_port is 5432 152s ok 2 - next_free_port detects localhost ipv4 socket 153s ok 3 - next_free_port detects wildcard ipv4 socket 153s ok 4 - next_free_port detects localhost ipv6 socket 154s ok 5 - next_free_port detects wildcard ipv6 socket 154s === Running test 007_pg_conftool.t ... === 154s 1..41 154s # test without cluster 154s ok 1 - pg_conftool show all 154s ok 2 - correct output of pg_conftool show all 154s ok 3 - pg_conftool foo.conf show all 154s ok 4 - correct output of pg_conftool foo.conf show all 154s ok 5 - pg_conftool /tmp/LRtJQpLOTo/different.conf show all 154s ok 6 - correct output of pg_conftool /tmp/LRtJQpLOTo/different.conf show all 154s ok 7 - pg_conftool 9.7 main show all 154s ok 8 - correct output of pg_conftool 9.7 main show all 154s # test show 154s ok 9 - pg_conftool show all 154s ok 10 - correct output of pg_conftool show all 154s ok 11 - pg_conftool other.conf show all 154s ok 12 - correct output of pg_conftool other.conf show all 154s ok 13 - pg_conftool /tmp/LRtJQpLOTo/different.conf show all 154s ok 14 - correct output of pg_conftool /tmp/LRtJQpLOTo/different.conf show all 154s ok 15 - pg_conftool 12 main show all 154s ok 16 - correct output of pg_conftool 12 main show all 154s ok 17 - pg_conftool 12 main other.conf show all 154s ok 18 - correct output of pg_conftool 12 main other.conf show all 154s ok 19 - pg_conftool show a 154s ok 20 - correct output of pg_conftool show a 154s ok 21 - pg_conftool -s show a 154s ok 22 - correct output of pg_conftool -s show a 154s # test set 154s ok 23 - pg_conftool set c 7 154s ok 24 - correct output of pg_conftool set c 7 154s ok 25 - file contains new setting 154s ok 26 - pg_conftool set a 8 154s ok 27 - correct output of pg_conftool set a 8 154s ok 28 - file contains updated setting 154s ok 29 - pg_conftool /tmp/LRtJQpLOTo/different.conf set a 9 154s ok 30 - correct output of pg_conftool /tmp/LRtJQpLOTo/different.conf set a 9 154s ok 31 - file with path contains updated setting 154s # test remove 155s ok 32 - pg_conftool remove a 155s ok 33 - correct output of pg_conftool remove a 155s ok 34 - setting removed from file 155s ok 35 - pg_conftool /tmp/LRtJQpLOTo/different.conf remove a 155s ok 36 - correct output of pg_conftool /tmp/LRtJQpLOTo/different.conf remove a 155s ok 37 - setting removed from file with path 155s # test edit 155s ok 38 - pg_conftool edit 155s ok 39 - correct output of pg_conftool edit 155s ok 40 - pg_conftool /tmp/LRtJQpLOTo/different.conf edit 155s ok 41 - correct output of pg_conftool /tmp/LRtJQpLOTo/different.conf edit 155s === Running test 010_defaultport_cluster.t ... === 155s 1..14 155s ok 1 - psql --version 155s ok 2 - pg_wrapper selects highest available version number 155s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 155s ok 4 - connecting to localhost fails with no clusters 155s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 155s ok 6 - pg_wrapper uses host and port from PGCLUSTER 155s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 155s ok 8 - pg_wrapper uses --cluster from the command line 155s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 155s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 155s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 155s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 155s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 155s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 155s === Running test 015_start_stop.t ... === 155s 1..71 155s # We are running systemd 155s # Running tests for 12 155s # Cluster does not exist yet 155s ok 1 - cluster 12 main does not exist 155s ok 2 - service postgresql@12-main does not exist 155s ok 3 - systemctl start postgresql 155s ok 4 - cluster 12 main does not exist 155s ok 5 - service postgresql@12-main does not exist 155s ok 6 - systemctl start postgresql@12-main 155s ok 7 - cluster 12 main does not exist 155s ok 8 - service postgresql@12-main does not exist 155s # Start/stop postgresql using system tools 156s ok 9 - pg_createcluster 12 main 156s ok 10 - cluster 12 main is stopped 156s ok 11 - service postgresql@12-main is stopped 159s ok 12 - systemctl start postgresql 159s ok 13 - cluster 12 main is running 159s ok 14 - service postgresql@12-main is running 159s ok 15 - systemctl start postgresql 159s ok 16 - cluster 12 main is already running 159s ok 17 - service postgresql@12-main is already running 159s ok 18 - systemctl stop postgresql 165s ok 19 - cluster 12 main is stopped 165s ok 20 - service postgresql@12-main is stopped 165s ok 21 - systemctl stop postgresql 165s ok 22 - cluster 12 main is already stopped 165s ok 23 - service postgresql@12-main is already stopped 165s # Start/stop specific cluster using system tools 167s ok 24 - systemctl start postgresql@12-main 167s ok 25 - cluster 12 main is running 167s ok 26 - service postgresql@12-main is running 167s ok 27 - systemctl start postgresql@12-main 167s ok 28 - cluster 12 main is running 167s ok 29 - service postgresql@12-main is running 170s ok 30 - systemctl restart postgresql@12-main 170s ok 31 - cluster 12 main is running 170s ok 32 - service postgresql@12-main is running 170s ok 33 - systemctl stop postgresql@12-main 170s ok 34 - cluster 12 main is stopped 170s ok 35 - service postgresql@12-main is stopped 170s ok 36 - systemctl stop postgresql@12-main 170s ok 37 - cluster 12 main is already stopped 170s ok 38 - service postgresql@12-main is already stopped 170s ok 39 - pg_dropcluster 12 main 170s ok 40 - cluster 12 main does not exist 170s ok 41 - service postgresql@12-main does not exist 170s # Start/stop specific cluster using pg_*cluster 170s ok 42 - pg_ctlcluster start 12 main 170s ok 43 - cluster 12 main does not exist 170s ok 44 - service postgresql@12-main does not exist 174s ok 45 - pg_createcluster 12 main --start 174s ok 46 - cluster 12 main is running 174s ok 47 - service postgresql@12-main is running 174s ok 48 - pg_ctlcluster 12 main start 174s ok 49 - cluster 12 main is already running 174s ok 50 - service postgresql@12-main is already running 176s ok 51 - pg_ctlcluster 12-main restart 176s ok 52 - cluster 12 main is running 176s ok 53 - service postgresql@12-main is running 177s ok 54 - pg_ctlcluster 12 main stop 177s ok 55 - cluster 12 main is stopped 177s ok 56 - service postgresql@12-main is stopped 177s ok 57 - pg_ctlcluster 12 main stop 177s ok 58 - cluster 12 main is already stopped 177s ok 59 - service postgresql@12-main is already stopped 179s ok 60 - pg_ctlcluster start 12-main 179s ok 61 - cluster 12 main is running 179s ok 62 - service postgresql@12-main is running 180s ok 63 - pg_dropcluster 12 main --stop 180s ok 64 - Cleanup: No clusters left behind 180s ok 65 - No postgres processes left behind 180s ok 66 - No files in /etc/postgresql left behind 180s ok 67 - No files in /var/lib/postgresql left behind 180s ok 68 - No files in /var/run/postgresql left behind 180s ok 69 - No files in /var/log/postgresql left behind 180s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 180s ok 71 - PostgreSQL TCP ports are closed 180s === Running test 020_create_sql_remove.t ... === 180s 1..144 180s # Running tests for 12 183s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.zCmF5u 183s ok 2 - pg_createcluster 12 main 183s ok 3 - Socket and pid file are in /var/run/postgresql/ 183s ok 4 - xlog/wal directory /tmp/12.xlog.zCmF5u was created 183s ok 5 - Exactly one postgres master process running 186s ok 6 - pg_ctlcluster 12 main restart 186s ok 7 - cluster restarts with new environment file 186s ok 8 - Exactly one postgres master process running 186s ok 9 - correct value of PGEXTRAVAR1 in environment 186s ok 10 - correct value of PGEXTRAVAR2 in environment 186s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 186s ok 12 - createdb --version 186s ok 13 - pg_wrapper selects version number of cluster 186s ok 14 - psql --version 186s ok 15 - pg_wrapper selects version number of cluster 186s ok 16 - pg_lscluster reports online cluster on port 5432 186s ok 17 - log file is actually used 186s ok 18 - /etc/postgresql is owned by user "postgres" 186s ok 19 - version configuration directory file is owned by user "postgres" 186s ok 20 - configuration directory file is owned by user "postgres" 186s ok 21 - version data directory file is owned by user "postgres" 186s ok 22 - data directory file is owned by user "postgres" 186s ok 23 - log file has 0640 permissions 186s ok 24 - log file is owned by user "postgres" 186s ok 25 - log file is owned by group "adm" 186s ok 26 - no log symlink by default 186s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 186s ok 28 - pg_lsclusters -h 186s ok 29 - correct output of pg_lsclusters -h 186s ok 30 - stopping cluster 188s ok 31 - restarting cluster with nondefault log symlink 188s ok 32 - log target is used as log file 188s ok 33 - default log is not used 188s ok 34 - pg_lsclusters -h 188s ok 35 - correct output of pg_lsclusters -h 188s ok 36 - stopping cluster 191s ok 37 - restarting cluster with explicitly configured log file 191s ok 38 - default log is not used 191s ok 39 - log symlink target is used for startup message 191s ok 40 - exactly one log file 191s ok 41 - custom log is actually used 191s ok 42 - pg_lsclusters -h 191s ok 43 - correct output of pg_lsclusters -h 191s ok 44 - stopping cluster 191s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 191s ok 46 - /etc/postgres-hack was not created 193s ok 47 - restarting cluster 193s ok 48 - ps -o tty -U postgres h 193s ok 49 - postgres processes do not have an associated terminal 193s ok 50 - SSL is enabled 193s ok 51 - psql -l fails for nobody 193s ok 52 - createuser nobody 193s ok 53 - createdb nobodydb 193s ok 54 - psql -ltA succeeds for nobody 193s ok 55 - psql -ltA output 194s ok 56 - SQL command: create table 194s ok 57 - SQL command: insert into table values 194s ok 58 - SQL command: insert into table values 194s ok 59 - primary key violation 194s ok 60 - psql -tAc "select * from phone order by name" nobodydb 194s ok 61 - SQL command output: select -tA 194s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 194s ok 63 - SQL command output: select -tx 194s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 194s ok 65 - SQL command output: select -tAx 194s ok 66 - CREATE EXTENSION plperlu fails for user nobody 194s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 194s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 194s ok 69 - creating PL/PerlU function as user nobody fails 194s ok 70 - creating unsafe PL/Perl function as user postgres fails 194s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 194s ok 72 - creating PL/PerlU function as user postgres succeeds 194s ok 73 - psql nobodydb -Atc "select read_file()" 194s ok 74 - calling PL/PerlU function 194s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 194s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 194s ok 77 - creating unsafe PL/Perl function as user nobody fails 194s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 194s ok 79 - creating PL/Perl function as user nobody succeeds 195s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 195s ok 81 - calling PL/Perl function 195s ok 82 # skip No python2 support 195s ok 83 # skip No python2 support 195s ok 84 # skip No python2 support 195s ok 85 # skip No python2 support 195s ok 86 # skip No python2 support 195s ok 87 # skip No python2 support 195s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 195s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 195s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 195s ok 91 - creating PL/Python3 function as user postgres succeeds 195s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 195s ok 93 - calling PL/Python function 195s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 195s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 195s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 195s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 195s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 195s ok 99 - creating PL/Tcl function as user nobody succeeds 195s ok 100 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 195s ok 101 - creating PL/TclU function as user postgres succeeds 195s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 195s ok 103 - calling PL/Tcl function 195s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 195s ok 105 - calling PL/TclU function 195s ok 106 - stopping cluster 195s ok 107 - pg_ctlcluster 12 main start 195s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 198s ok 109 - pg_ctlcluster 12 main start 198s ok 110 - cluster restarts with pgdata symlink 198s ok 111 - postgres master has OOM killer protection 198s ok 112 - postgres client backend has no OOM adjustment 198s ok 113 - ps h 8253 198s ok 114 - process title is idle 199s ok 115 - ps h 8253 199s ok 116 - process title is idle in transaction 199s ok 117 - ps h 8253 199s ok 118 - process title is SELECT 201s ok 119 - dropdb nobodydb 201s ok 120 - dropuser nobody 201s ok 121 - stopping cluster 204s ok 122 - starting cluster as postgres works without a log file 204s ok 123 - log file got recreated and used 204s ok 124 - creating a directory in spc2 204s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.JREwgx'" 204s ok 126 - creating tablespace spc1 204s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 204s ok 128 - creating a table in spc1 204s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.pZWNIL'" 204s ok 130 - creating tablespace spc2 204s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 204s ok 132 - creating a table in spc2 204s ok 133 - pg_dropcluster removes cluster 204s ok 134 - xlog/wal directory /tmp/12.xlog.zCmF5u was deleted 204s ok 135 - tablespace spc1 was emptied 204s ok 136 - tablespace spc2 was emptied 204s ok 137 - Cleanup: No clusters left behind 204s ok 138 - No postgres processes left behind 204s ok 139 - No files in /etc/postgresql left behind 204s ok 140 - No files in /var/lib/postgresql left behind 204s ok 141 - No files in /var/run/postgresql left behind 204s ok 142 - No files in /var/log/postgresql left behind 204s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 204s ok 144 - PostgreSQL TCP ports are closed 204s === Running test 021_pg_renamecluster.t ... === 204s 1..20 208s ok 1 - pg_createcluster 12 main 211s ok 2 - pg_renamecluster 12 main donau 211s ok 3 - psql -tAc "show data_directory" 211s ok 4 - cluster is running and data_directory was moved 211s ok 5 - pg_hba.conf location updated 211s ok 6 - pg_ident.conf location updated 211s ok 7 - external_pid_file location updated 211s ok 8 - external_pid_file exists 211s ok 9 - stats_temp_directory location updated 211s ok 10 - stats_temp_directory exists 211s ok 11 - cluster_name is updated 211s ok 12 - pg_dropcluster removes cluster 211s ok 13 - Cleanup: No clusters left behind 211s ok 14 - No postgres processes left behind 211s ok 15 - No files in /etc/postgresql left behind 211s ok 16 - No files in /var/lib/postgresql left behind 211s ok 17 - No files in /var/run/postgresql left behind 211s ok 18 - No files in /var/log/postgresql left behind 211s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 211s ok 20 - PostgreSQL TCP ports are closed 211s === Running test 022_recovery.t ... === 211s 1..17 211s # Running tests for 12 215s ok 1 - pg_createcluster 12 main --start >/dev/null 215s ok 2 - pg_ctlcluster 12 main stop -m i 217s ok 3 - pg_ctlcluster 12 main start 217s ok 4 - psql -c '' 218s ok 5 - pg_ctlcluster 12 main stop -m i 218s ok 6 - create write-protected file in data directory 220s ok 7 - pg_ctlcluster 12 main start 220s ok 8 - psql -c '' 220s ok 9 - pg_dropcluster removes cluster 220s ok 10 - Cleanup: No clusters left behind 220s ok 11 - No postgres processes left behind 220s ok 12 - No files in /etc/postgresql left behind 220s ok 13 - No files in /var/lib/postgresql left behind 220s ok 14 - No files in /var/run/postgresql left behind 220s ok 15 - No files in /var/log/postgresql left behind 220s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 220s ok 17 - PostgreSQL TCP ports are closed 220s === Running test 025_logging.t ... === 221s 1..55 221s # Logging to /var/log/syslog works 221s # Running tests for 12 224s ok 1 - pg_createcluster 12 main 225s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 225s ok 3 - psql -qc "'foobar_12_8879'" 225s ok 4 - log an error 225s ok 5 - grep --binary-files=text foobar_12_8879 /var/log/postgresql/postgresql-12-main.log 225s ok 6 - error appears in logfile 225s ok 7 - pg_conftool 12 main set log_destination syslog 225s ok 8 - set log_destination syslog 225s ok 9 - pg_ctlcluster 12 main reload 225s ok 10 - 12 main reload 225s ok 11 - psql -Atc "show log_destination" 225s ok 12 - log_destination is syslog 225s ok 13 - pg_lscluster reports syslog 225s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 225s ok 15 - error appears in /var/log/syslog 225s ok 16 - pg_conftool 12 main set logging_collector on 225s ok 17 - set logging_collector on 225s ok 18 - pg_conftool 12 main set log_destination csvlog 225s ok 19 - set log_destination csvlog 228s ok 20 - pg_ctlcluster 12 main restart 228s ok 21 - 12 main restart 228s ok 22 - psql -Atc "show logging_collector" 228s ok 23 - logging_collector is on 228s ok 24 - psql -Atc "show log_destination" 228s ok 25 - log_destination is csvlog 228s ok 26 - pg_lscluster reports csvlog 228s ok 27 - psql -qc "'barbaz_12_8879'" 228s ok 28 - log an error 228s ok 29 - grep --binary-files=text barbaz_12_8879 /var/lib/postgresql/12/main/log/*.csv 228s ok 30 - error appears in log/*.csv 228s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 228s ok 32 - set log_destination stderr,syslog,csvlog 228s ok 33 - pg_ctlcluster 12 main reload 228s ok 34 - 12 main reload 228s ok 35 - psql -Atc "show log_destination" 228s ok 36 - log_destination is stderr,syslog,csvlog 228s ok 37 - pg_lscluster reports stderr,syslog,csvlog 228s ok 38 - psql -qc "'moo_12_8879'" 228s ok 39 - log an error 228s ok 40 - grep --binary-files=text moo_12_8879 /var/lib/postgresql/12/main/log/*.log 228s ok 41 - error appears in log/*.log 229s ok 42 - grep --binary-files=text 'postgres.*moo_12_8879' /var/log/syslog 229s ok 43 - error appears in /var/log/syslog 229s ok 44 - grep --binary-files=text moo_12_8879 /var/lib/postgresql/12/main/log/*.csv 229s ok 45 - error appears in log/*.csv 229s ok 46 - pg_dropcluster 12 main --stop 229s ok 47 - pg_dropcluster removes cluster 229s ok 48 - Cleanup: No clusters left behind 229s ok 49 - No postgres processes left behind 229s ok 50 - No files in /etc/postgresql left behind 229s ok 51 - No files in /var/lib/postgresql left behind 229s ok 52 - No files in /var/run/postgresql left behind 229s ok 53 - No files in /var/log/postgresql left behind 229s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 229s ok 55 - PostgreSQL TCP ports are closed 229s === Running test 030_errors.t ... === 229s 1..149 229s ok 1 - pg_lscluster reports cluster without binaries 229s ok 2 - pg_dropcluster 6.3 main 231s ok 3 - pg_createcluster --socketdir 231s ok 4 - pg_lsclusters -h 231s ok 5 - cluster was created 231s ok 6 - Port of created cluster is 5432 231s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 231s ok 8 - pg_createcluster on existing cluster 231s ok 9 - pg_lsclusters -h 231s ok 10 - original cluster still exists 231s ok 11 - pg_createcluster 12 test -p foo 231s ok 12 - pg_createcluster -p checks that port option is numeric 231s ok 13 - pg_createcluster 12 test -p 42 231s ok 14 - pg_createcluster -p checks valid port range 231s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 231s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 231s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 233s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 233s ok 19 - No sockets in /var/run/postgresql 233s ok 20 - Socket is in /tmp/postgresql-testsuite/ 233s ok 21 - cluster stops with custom unix_socket_dir 233s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 236s ok 23 - cluster starts after removing unix_socket_dir 236s ok 24 - Socket is in default dir /var/run/postgresql 236s ok 25 - No sockets in /tmp/postgresql-testsuite/ 236s ok 26 - pg_ctlcluster 12 main stop 236s ok 27 - pg_ctlcluster fails with corrupted PID file 236s ok 28 - pg_lsclusters -h 236s ok 29 - cluster is still online 236s ok 30 - pg_ctlcluster succeeds with restored PID file 236s ok 31 - pg_lsclusters -h 236s ok 32 - cluster is down 236s ok 33 - pg_ctlcluster 12 main stop 236s ok 34 - pg_ctlcluster stop fails on stopped cluster 238s ok 35 - pg_ctlcluster 12 main start 238s ok 36 - pg_ctlcluster succeeds with already existing PID file 238s ok 37 - pg_lsclusters -h 238s ok 38 - cluster is online 239s ok 39 - pg_ctlcluster stop succeeds 239s ok 40 - pg_lsclusters -h 239s ok 41 - cluster is down 239s ok 42 - no pid file left 239s ok 43 - pg_ctlcluster 12 main stop 239s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 239s ok 45 - pid file was cleaned up 239s ok 46 - pg_ctlcluster --force 12 main stop 239s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 239s ok 48 - pid file was cleaned up 239s ok 49 - pg_ctlcluster 12 main stop 239s ok 50 - pg_ctlcluster stop succeeds with stale PID file 239s ok 51 - pid file was cleaned up 239s ok 52 - pg_ctlcluster --force 12 main stop 239s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 239s ok 54 - pid file was cleaned up 239s ok 55 - pg_ctlcluster --force 12 main stop 239s ok 56 - pg_ctlcluster stop succeeds with empty PID file 239s ok 57 - pid file was cleaned up 241s ok 58 - pg_ctlcluster 12 main start 241s ok 59 - pg_ctlcluster succeeds with corrupted PID file 241s ok 60 - pg_lsclusters -h 241s ok 61 - cluster is online 241s ok 62 - pg_ctlcluster 12 main start 241s ok 63 - pg_ctlcluster start fails on running cluster 241s ok 64 - pg_ctlcluster stop 242s ok 65 - pg_ctlcluster 12 main start 242s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 242s ok 67 - pg_ctlcluster 12 main stop 242s ok 68 - stopping cluster 248s ok 69 - pg_ctlcluster 12 main start 248s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 248s ok 71 - pg_ctlcluster 12 main stop 248s ok 72 - stopping cluster 248s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 248s ok 74 - pg_dropcluster 12 main 248s ok 75 - pg_dropcluster works as user postgres 249s ok 76 - pg_createcluster succeeds 249s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 249s ok 78 - proper error message for nonexisting /var/lib/postgresql 252s ok 79 - pg_ctlcluster 12 main start 252s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 252s ok 81 - pg_ctlcluster 12 main stop 252s ok 82 - stopping cluster 253s ok 83 - pg_createcluster other 255s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 257s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 257s ok 86 258s ok 87 - pg_ctlcluster 12 other start 258s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 258s ok 89 - pg_ctlcluster 12 main stop 258s ok 90 - stopping main cluster 260s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 260s ok 92 - pg_dropcluster other 261s ok 93 - pg_dropcluster 261s ok 94 - No sockets any more 261s ok 95 - 'pg_lsclusters 4.5 foo' fails 261s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 261s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 261s ok 98 - 'psql --cluster 4.5/foo' fails 261s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 261s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 261s ok 101 - 'psql --cluster 12/foo' fails 261s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 261s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 261s ok 104 - 'pg_dropcluster 4.5 foo' fails 261s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 261s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 261s ok 107 - 'pg_dropcluster 12 foo' fails 261s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 261s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 261s ok 110 - 'pg_upgradecluster 4.5 foo' fails 261s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 261s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 261s ok 113 - 'pg_upgradecluster 12 foo' fails 261s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 261s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 261s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 261s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 261s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 261s ok 119 - 'pg_ctlcluster 12 foo stop' fails 261s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 261s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 261s ok 122 - Cleanup: No clusters left behind 261s ok 123 - No postgres processes left behind 261s ok 124 - No files in /etc/postgresql left behind 261s ok 125 - No files in /var/lib/postgresql left behind 261s ok 126 - No files in /var/run/postgresql left behind 261s ok 127 - No files in /var/log/postgresql left behind 261s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 261s ok 129 - PostgreSQL TCP ports are closed 261s ok 130 - pg_dropcluster 12 broken 261s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 261s ok 132 - Cleanup: No clusters left behind 261s ok 133 - No postgres processes left behind 261s ok 134 - No files in /etc/postgresql left behind 261s ok 135 - No files in /var/lib/postgresql left behind 261s ok 136 - No files in /var/run/postgresql left behind 261s ok 137 - No files in /var/log/postgresql left behind 261s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 261s ok 139 - PostgreSQL TCP ports are closed 262s ok 140 - pg_dropcluster 12 broken 262s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 262s ok 142 - Cleanup: No clusters left behind 262s ok 143 - No postgres processes left behind 262s ok 144 - No files in /etc/postgresql left behind 262s ok 145 - No files in /var/lib/postgresql left behind 262s ok 146 - No files in /var/run/postgresql left behind 262s ok 147 - No files in /var/log/postgresql left behind 262s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 262s ok 149 - PostgreSQL TCP ports are closed 262s === Running test 031_errors_disk_full.t ... === 262s 1..22 262s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 262s ok 1 - script failed 262s ok 2 - pg_createcluster fails due to insufficient disk space 262s ok 3 - does not leave files behind 262s ok 4 - Cleanup: No clusters left behind 262s ok 5 - No postgres processes left behind 262s ok 6 - No files in /etc/postgresql left behind 262s ok 7 - No files in /var/lib/postgresql left behind 262s ok 8 - No files in /var/run/postgresql left behind 262s ok 9 - No files in /var/log/postgresql left behind 262s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 262s ok 11 - PostgreSQL TCP ports are closed 262s # check disk full conditions on startup 264s ok 12 - script failed 264s ok 13 - pg_ctlcluster prints error message 264s ok 14 - log file has error message 264s ok 15 - Cleanup: No clusters left behind 264s ok 16 - No postgres processes left behind 264s ok 17 - No files in /etc/postgresql left behind 264s ok 18 - No files in /var/lib/postgresql left behind 264s ok 19 - No files in /var/run/postgresql left behind 264s ok 20 - No files in /var/log/postgresql left behind 264s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 264s ok 22 - PostgreSQL TCP ports are closed 264s === Running test 032_ssl_key_permissions.t ... === 264s 1..22 264s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 264s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 264s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 264s # 12 (12.22-0ubuntu0.20.04.1) 265s ok 4 - pg_createcluster 12 main 265s ok 5 - pg_ctlcluster 12 main start 265s ok 6 - ssl key owned by nobody refused 265s ok 7 - pg_ctlcluster 12 main start 265s ok 8 - ssl key with permissions root:root 0644 refused 265s ok 9 - pg_ctlcluster 12 main start 265s ok 10 - ssl key with permissions postgres:postgres 0640 refused 266s ok 11 - pg_dropcluster 12 main --stop 266s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 266s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 266s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 266s ok 15 - Cleanup: No clusters left behind 266s ok 16 - No postgres processes left behind 266s ok 17 - No files in /etc/postgresql left behind 266s ok 18 - No files in /var/lib/postgresql left behind 266s ok 19 - No files in /var/run/postgresql left behind 266s ok 20 - No files in /var/log/postgresql left behind 266s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 266s ok 22 - PostgreSQL TCP ports are closed 266s === Running test 040_upgrade.t ... === 266s 1..1 266s ok 1 - only one major version installed, skipping upgrade tests 266s === Running test 041_upgrade_custompaths.t ... === 266s 1..1 266s ok 1 - only one major version installed, skipping upgrade tests 266s === Running test 043_upgrade_ssl_cert.t ... === 266s 1..1 266s ok 1 - only one major version installed, skipping upgrade tests 266s === Running test 050_encodings.t ... === 266s 1..60 266s # Checking 12 ru_RU 269s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 271s ok 2 - psql -l succeeds 271s ok 3 - template1 is not UTF-8 encoded 271s ok 4 - creating test database 271s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 271s # create table t (x varchar); copy t from stdin" test 271s ok 6 - creating table with ISO-8859-5 characters 271s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 271s ok 8 - correct string in UTF-8 271s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 271s ok 10 - correct string in ISO-8859-5 271s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 271s # delete from t; copy t from stdin" test 271s ok 12 - creating table with UTF-8 characters 271s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 271s ok 14 - correct string in UTF-8 271s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 271s ok 16 - correct string in ISO-8859-1 271s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 271s ok 18 - Server error message has correct language and encoding 273s ok 19 - pg_ctlcluster 12 ru_RU restart 273s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 274s ok 21 - Dropping cluster 274s # Checking 12 ru_RU.UTF-8 277s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 278s ok 23 - psql -l succeeds 278s ok 24 - template1 is UTF-8 encoded 278s ok 25 - creating test database 279s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 279s # create table t (x varchar); copy t from stdin" test 279s ok 27 - creating table with ISO-8859-5 characters 279s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 279s ok 29 - correct string in UTF-8 279s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 279s ok 31 - correct string in ISO-8859-5 279s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 279s # delete from t; copy t from stdin" test 279s ok 33 - creating table with UTF-8 characters 279s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 279s ok 35 - correct string in UTF-8 279s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 279s ok 37 - correct string in ISO-8859-1 279s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 279s ok 39 - Server error message has correct language and encoding 281s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 281s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 281s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 281s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 281s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 281s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 281s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 281s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 282s ok 48 - Dropping cluster 282s # Check 12 locale environment variables 285s ok 49 - pg_createcluster: LC_ALL dominates LANG 285s ok 50 - psql -Atl --cluster 12/main 285s ok 51 - template1 is ASCII encoded 286s ok 52 - Dropping cluster 286s ok 53 - Cleanup: No clusters left behind 286s ok 54 - No postgres processes left behind 286s ok 55 - No files in /etc/postgresql left behind 286s ok 56 - No files in /var/lib/postgresql left behind 286s ok 57 - No files in /var/run/postgresql left behind 286s ok 58 - No files in /var/log/postgresql left behind 286s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 286s ok 60 - PostgreSQL TCP ports are closed 286s === Running test 052_upgrade_encodings.t ... === 286s 1..1 286s ok 1 - only one major version installed, skipping upgrade tests 286s === Running test 060_obsolete_confparams.t ... === 286s 1..1 286s ok 1 - only one major version installed, skipping upgrade tests 286s === Running test 070_non_postgres_clusters.t ... === 286s 1..40 287s ok 1 - pg_createcluster 12 main for owner nobody 287s ok 2 - pg_ctlcluster 12 main start 287s ok 3 - start refused when config and data owners mismatch 290s ok 4 - pg_ctlcluster succeeds with owner nobody 290s ok 5 - pg_lsclusters -h 290s ok 6 - pg_lsclusters shows running cluster 290s ok 7 - postgres is running as user nobody 290s ok 8 - ls /tmp/.s.PGSQL.* 290s ok 9 - socket is in /tmp 290s ok 10 - /var/run/postgresql is empty 290s ok 11 - conf dir is owned by user 290s ok 12 - conf dir is owned by user's primary group 290s ok 13 - files are owned by user 290s ok 14 - files are owned by user's primary group 290s ok 15 - log file has 0640 permissions 290s ok 16 - log file is owned by user 290s ok 17 - log file is owned by user's primary group 290s ok 18 - only one major version installed, skipping upgrade test 290s ok 19 - ... 290s ok 20 - ... 290s ok 21 - ... 290s ok 22 - ... 290s ok 23 - ... 290s ok 24 - ... 290s ok 25 - ... 290s ok 26 - ... 290s ok 27 - ... 290s ok 28 - ... 290s ok 29 - pg_dropcluster 290s ok 30 - pg_lsclusters -h 290s ok 31 - No clusters left 290s ok 32 - No postgres processes left 290s ok 33 - Cleanup: No clusters left behind 290s ok 34 - No postgres processes left behind 290s ok 35 - No files in /etc/postgresql left behind 290s ok 36 - No files in /var/lib/postgresql left behind 290s ok 37 - No files in /var/run/postgresql left behind 290s ok 38 - No files in /var/log/postgresql left behind 290s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 290s ok 40 - PostgreSQL TCP ports are closed 290s === Running test 080_start.conf.t ... === 290s 1..73 291s ok 1 - pg_createcluster 12 main 291s # start.conf auto 291s ok 2 - get_cluster_start_conf returns auto 291s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 291s ok 4 - start.conf contains auto 291s ok 5 - systemd generator links cluster 291s ok 6 - systemd generator links correct service file 294s ok 7 - /etc/init.d/postgresql start 12 294s ok 8 - correct output of /etc/init.d/postgresql start 12 294s ok 9 - pg_lsclusters -h 294s ok 10 - cluster is online 294s ok 11 - /etc/init.d/postgresql stop 12 294s ok 12 - correct output of /etc/init.d/postgresql stop 12 297s ok 13 - pg_lsclusters -h 297s ok 14 - cluster is down 297s # start.conf manual 297s ok 15 - get_cluster_start_conf returns manual 297s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 297s ok 17 - start.conf contains manual 297s ok 18 - systemd generator doesn't link cluster 297s ok 19 - /etc/init.d/postgresql start 12 297s ok 20 - correct output of /etc/init.d/postgresql start 12 297s ok 21 - pg_lsclusters -h 297s ok 22 - cluster is down 299s ok 23 - pg_ctlcluster 12 main start 299s ok 24 - correct output of pg_ctlcluster 12 main start 299s ok 25 - pg_lsclusters -h 299s ok 26 - cluster is online 300s ok 27 - pg_ctlcluster 12 main stop 300s ok 28 - correct output of pg_ctlcluster 12 main stop 300s ok 29 - pg_lsclusters -h 300s ok 30 - cluster is down 300s # start.conf disabled 300s ok 31 - get_cluster_start_conf returns disabled 300s ok 32 - systemd generator doesn't link cluster 300s ok 33 - /etc/init.d/postgresql start 12 300s ok 34 - correct output of /etc/init.d/postgresql start 12 300s ok 35 - pg_lsclusters -h 300s ok 36 - cluster is down 300s ok 37 - pg_ctlcluster 12 main start 300s ok 38 - correct output of pg_ctlcluster 12 main start 300s ok 39 - pg_lsclusters -h 300s ok 40 - cluster is down 302s ok 41 - pg_ctlcluster 12 main start 302s ok 42 - correct output of pg_ctlcluster 12 main start 302s ok 43 - pg_lsclusters -h 302s ok 44 - cluster is online 302s ok 45 - pg_ctlcluster 12 main stop 302s ok 46 - correct output of pg_ctlcluster 12 main stop 302s ok 47 - pg_lsclusters -h 302s ok 48 - cluster is down 305s ok 49 - pg_ctlcluster 12 main start 305s ok 50 - correct output of pg_ctlcluster 12 main start 305s ok 51 - pg_lsclusters -h 305s ok 52 - cluster is online 305s # test upgrade 305s ok 53 - only one major version installed, skipping upgrade test 305s ok 54 - ... 305s ok 55 - get_cluster_start_conf for old cluster returns manual 305s ok 56 - get_cluster_start_conf for new cluster returns manual 305s ok 57 - ... 305s ok 58 - dropping upgraded cluster 305s ok 59 - pg_lsclusters -h 305s ok 60 - no clusters any more 305s ok 61 - pg_createcluster 12 main --start-conf foo 305s ok 62 - pg_createcluster checks --start-conf validity 306s ok 63 - pg_createcluster checks --start-conf manual 306s ok 64 - get_cluster_start_conf returns manual 306s ok 65 - dropping cluster 306s ok 66 - Cleanup: No clusters left behind 306s ok 67 - No postgres processes left behind 306s ok 68 - No files in /etc/postgresql left behind 306s ok 69 - No files in /var/lib/postgresql left behind 306s ok 70 - No files in /var/run/postgresql left behind 306s ok 71 - No files in /var/log/postgresql left behind 306s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 306s ok 73 - PostgreSQL TCP ports are closed 306s === Running test 085_pg_ctl.conf.t ... === 306s 1..29 307s ok 1 - pg_createcluster 12 main 307s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 309s ok 3 - pg_ctlcluster 12 main start 309s ok 4 - starting cluster 309s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 309s ok 6 - soft core size is 0 309s ok 7 - set pg_ctl default option to -c 312s ok 8 - pg_ctlcluster 12 main restart 312s ok 9 - restarting cluster 312s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 312s ok 11 - soft core size is unlimited 312s ok 12 - restored pg_ctl default option 314s ok 13 - pg_ctlcluster 12 main restart 314s ok 14 - restarting cluster 314s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 314s ok 16 - soft core size is 0 316s ok 17 - pg_ctlcluster 12 main restart -- -c 316s ok 18 - restarting cluster with -c on the command line 316s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 316s ok 20 - soft core size is unlimited 317s ok 21 - dropping cluster 317s ok 22 - Cleanup: No clusters left behind 317s ok 23 - No postgres processes left behind 317s ok 24 - No files in /etc/postgresql left behind 317s ok 25 - No files in /var/lib/postgresql left behind 317s ok 26 - No files in /var/run/postgresql left behind 317s ok 27 - No files in /var/log/postgresql left behind 317s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 317s ok 29 - PostgreSQL TCP ports are closed 317s === Running test 090_multicluster.t ... === 317s 1..125 318s ok 1 - pg_createcluster 12 old 319s ok 2 - pg_createcluster 12 new1 321s ok 3 - pg_createcluster 12 new2 323s ok 4 - starting cluster 12/old 325s ok 5 - starting cluster 12/new1 327s ok 6 - starting cluster 12/new2 328s ok 7 - pg_lsclusters -h | sort -k3 328s ok 8 - clusters have the correct ports, skipping used 5433 328s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 328s ok 10 - createdb --version 328s ok 11 - pg_wrapper selects port 5432 as default cluster 328s ok 12 - createdb --cluster 12/new1 --version 328s ok 13 - pg_wrapper --cluster works 328s ok 14 - createdb --cluster 12/foo --version 328s ok 15 - pg_wrapper --cluster errors out for invalid cluster 328s ok 16 - createdb --cluster 12/new1 test 328s ok 17 - correct output of createdb --cluster 12/new1 test 328s ok 18 - psql -Atl --cluster 12/new1 328s ok 19 - test db appears in cluster new1 328s ok 20 - psql -Atl --cluster 12/new2 328s ok 21 - test db does not appear in cluster new2 328s ok 22 - psql -Atl 328s ok 23 - test db does not appear in default cluster 328s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 328s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 328s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 328s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 328s ok 28 - psql -Atl --cluster 12/localhost:5434 328s ok 29 - test db appears in cluster 12/localhost:5434 328s ok 30 - psql -Atl --cluster 12/localhost:5440 328s ok 31 - test db does not appear in cluster 12/localhost:5440 328s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 328s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 328s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 328s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 328s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 328s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 328s ok 38 - psql -Atl --cluster 6.4/localhost: 328s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 329s ok 40 - psql -Atl 329s ok 41 - PGCLUSTER selection (1) 329s ok 42 - psql -Atl 329s ok 43 - PGCLUSTER selection (2) 329s ok 44 - psql -l 329s ok 45 - invalid PGCLUSTER value 329s ok 46 - createdb --version 329s ok 47 - PGCLUSTER network cluster selection (1) 329s ok 48 - psql -Atl 329s ok 49 - PGCLUSTER network cluster selection (2) 329s ok 50 - psql -Atl 329s ok 51 - PGCLUSTER network cluster selection (3) 329s ok 52 - LC_MESSAGES=C psql -Atl 329s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 329s ok 54 - psql -Atc "show port" template1 329s ok 55 - PGPORT selection (1) 329s ok 56 - psql -Atc "show port" template1 329s ok 57 - PGPORT selection (2) 329s ok 58 - createdb --version 329s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 329s ok 60 - psql -Atc "show port" template1 329s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 329s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 329s ok 63 - PGDATABASE environment variable works 329s ok 64 - createdb --version 329s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 329s ok 66 - createdb --cluster 12/new1 --version 329s ok 67 - pg_wrapper --cluster works with empty user_clusters 329s ok 68 - createdb --version 329s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 329s ok 70 - psql -Atc "select current_database()" 329s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 329s ok 72 - psql -Atc 'select current_database()' 329s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 329s ok 74 - createdb --version 329s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 329s ok 76 - createdb --version 329s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 329s ok 78 - createdb --version 329s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 329s ok 80 - createdb --version 329s ok 81 - pg_wrapper selects correct version with per-user user_clusters 330s ok 82 - createdb --version 330s ok 83 - pg_wrapper selects correct version with per-user user_clusters 330s ok 84 - createdb --version 330s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 330s ok 86 - psql -Atl 330s ok 87 - $PGHOST overrides user_clusters 330s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 330s ok 89 - --cluster overrides $PGHOST 330s ok 90 - createdb --version 330s ok 91 - pg_wrapper ignores invalid lines in user_clusters 330s ok 92 - psql -Atc 'select current_database()' 330s ok 93 - pg_service conf selection 1 330s ok 94 - psql -Atc 'select current_database()' 330s ok 95 - pg_service conf selection 2 330s ok 96 - psql -Atc 'select current_database()' 330s ok 97 - pg_service conf selection 3 330s ok 98 - stopping cluster 12/old 332s ok 99 - restarting cluster 12/old 332s ok 100 - pg_lsclusters -h | sort -k3 332s ok 101 - port of first cluster was successfully changed 333s ok 102 - psql -l 333s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 333s ok 104 - psql -Atl --cluster 12/new1 333s ok 105 - --cluster selects appropriate cluster 333s ok 106 - psql -Atl -p 5434 333s ok 107 - -p selects appropriate cluster 333s ok 108 - psql -Atlp 5434 333s ok 109 - -Atlp selects appropriate cluster 333s ok 110 - psql -Atl --port 5434 333s ok 111 - --port selects appropriate cluster 333s ok 112 - env PGPORT=5434 psql -Atl 333s ok 113 - $PGPORT selects appropriate cluster 333s ok 114 - Restoring original /etc/postgresql-common/user_clusters 333s ok 115 - dropping 12/new1 334s ok 116 - dropping 12/new2 334s ok 117 - dropping 12/old 335s ok 118 - Cleanup: No clusters left behind 335s ok 119 - No postgres processes left behind 335s ok 120 - No files in /etc/postgresql left behind 335s ok 121 - No files in /var/lib/postgresql left behind 335s ok 122 - No files in /var/run/postgresql left behind 335s ok 123 - No files in /var/log/postgresql left behind 335s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 335s ok 125 - PostgreSQL TCP ports are closed 335s === Running test 100_upgrade_scripts.t ... === 335s 1..27 338s ok 1 - pg_createcluster 12 main 338s ok 2 - createdb --cluster 12/main db1 338s ok 3 - correct output of createdb --cluster 12/main db1 338s ok 4 - createdb --cluster 12/main db2 338s ok 5 - correct output of createdb --cluster 12/main db2 338s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 338s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 338s ok 8 - get_cluster_databases() works 338s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 341s ok 10 - run-upgrade-scripts succeeds 341s ok 11 - correct run-upgrade-script output 341s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 341s ok 13 - check SQL scripts results in 12/main db1 341s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 341s ok 15 - check SQL scripts results in 12/main db2 341s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 341s ok 17 - check shell scripts results in $v/main 341s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 341s ok 19 - pg_dropcluster 12 main 341s ok 20 - Cleanup: No clusters left behind 341s ok 21 - No postgres processes left behind 341s ok 22 - No files in /etc/postgresql left behind 341s ok 23 - No files in /var/lib/postgresql left behind 341s ok 24 - No files in /var/run/postgresql left behind 341s ok 25 - No files in /var/log/postgresql left behind 341s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 341s ok 27 - PostgreSQL TCP ports are closed 341s === Running test 110_integrate_cluster.t ... === 342s 1..32 342s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/ORuh8hMCFX/c/postgres 342s ok 2 - creating raw initdb cluster for user postgres 343s ok 3 - pg_createcluster 12 postgres -d /tmp/ORuh8hMCFX/c/postgres 343s ok 4 - integrating postgres cluster 343s ok 5 - pg_lsclusters 343s ok 6 - correct pg_lsclusters output 345s ok 7 - pg_ctlcluster 12 postgres start 345s ok 8 - starting cluster postgres 345s ok 9 - pg_lsclusters 345s ok 10 - correct pg_lsclusters output 346s ok 11 - dropping cluster postgres 346s ok 12 - No files in temporary cluster dir left behind 347s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/ORuh8hMCFX/c/nobody 347s ok 14 - creating raw initdb cluster for user nobody 347s ok 15 - pg_createcluster 12 nobody -d /tmp/ORuh8hMCFX/c/nobody 347s ok 16 - integrating nobody cluster 347s ok 17 - pg_lsclusters 347s ok 18 - correct pg_lsclusters output 349s ok 19 - pg_ctlcluster 12 nobody start 349s ok 20 - starting cluster nobody 349s ok 21 - pg_lsclusters 349s ok 22 - correct pg_lsclusters output 350s ok 23 - dropping cluster nobody 350s ok 24 - No files in temporary cluster dir left behind 350s ok 25 - Cleanup: No clusters left behind 350s ok 26 - No postgres processes left behind 350s ok 27 - No files in /etc/postgresql left behind 350s ok 28 - No files in /var/lib/postgresql left behind 350s ok 29 - No files in /var/run/postgresql left behind 350s ok 30 - No files in /var/log/postgresql left behind 350s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 350s ok 32 - PostgreSQL TCP ports are closed 350s === Running test 120_pg_upgradecluster_scripts.t ... === 350s 1..1 350s ok 1 - only one major version installed, skipping upgrade tests 350s === Running test 130_nonroot_admin.t ... === 350s 1..22 353s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 353s ok 2 - pg_lsclusters -h 353s ok 3 - correct output of pg_lsclusters -h 353s ok 4 - psql -Atl 353s ok 5 - correct output of psql -Atl 354s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 354s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 15 - Cleanup: No clusters left behind 354s ok 16 - No postgres processes left behind 354s ok 17 - No files in /etc/postgresql left behind 354s ok 18 - No files in /var/lib/postgresql left behind 354s ok 19 - No files in /var/run/postgresql left behind 354s ok 20 - No files in /var/log/postgresql left behind 354s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 354s ok 22 - PostgreSQL TCP ports are closed 354s === Running test 135_pg_virtualenv.t ... === 354s 1..20 358s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 358s ok 2 - running pg_virtualenv as root 361s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 361s ok 4 - running pg_virtualenv as postgres 365s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 365s ok 6 - running pg_virtualenv as nobody 365s ok 7 # skip /usr/bin/fakeroot not available 365s ok 8 # skip /usr/bin/fakeroot not available 365s ok 9 # skip /usr/bin/fakeroot not available 365s ok 10 # skip /usr/bin/fakeroot not available 365s ok 11 # skip /usr/bin/fakeroot not available 365s ok 12 # skip /usr/bin/fakeroot not available 365s ok 13 - Cleanup: No clusters left behind 365s ok 14 - No postgres processes left behind 365s ok 15 - No files in /etc/postgresql left behind 365s ok 16 - No files in /var/lib/postgresql left behind 365s ok 17 - No files in /var/run/postgresql left behind 365s ok 18 - No files in /var/log/postgresql left behind 365s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 365s ok 20 - PostgreSQL TCP ports are closed 365s === Running test 140_pg_config.t ... === 365s 1..38 365s # Multiarch is enabled 365s # checking version specific output for 12 365s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 365s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 365s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 365s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 365s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 365s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 365s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 365s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 365s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 365s # checking pg_config output (should behave like version 12) 365s ok 15 - pg_config 365s ok 16 - correct output of pg_config 365s ok 17 - pg_config --help 365s ok 18 - correct output of pg_config --help 365s ok 19 - pg_config --pgxs 365s ok 20 - correct output of pg_config --pgxs 365s ok 21 - pg_config --libdir 365s ok 22 - correct output of pg_config --libdir 365s ok 23 - pg_config --pkglibdir 365s ok 24 - correct output of pg_config --pkglibdir 365s ok 25 - pg_config --bindir 365s ok 26 - correct output of pg_config --bindir 365s # checking pg_config.libpq-dev output (should behave like version 12) 365s ok 27 - pg_config.libpq-dev 365s ok 28 - correct output of pg_config.libpq-dev 365s ok 29 - pg_config.libpq-dev --help 365s ok 30 - correct output of pg_config.libpq-dev --help 365s ok 31 - pg_config.libpq-dev --pgxs 365s ok 32 - correct output of pg_config.libpq-dev --pgxs 365s ok 33 - pg_config.libpq-dev --libdir 365s ok 34 - correct output of pg_config.libpq-dev --libdir 365s ok 35 - pg_config.libpq-dev --pkglibdir 365s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 365s ok 37 - pg_config.libpq-dev --bindir 365s ok 38 - correct output of pg_config.libpq-dev --bindir 365s === Running test 150_tsearch_stemming.t ... === 365s 1..37 365s ok 1 - pg_updatedicts succeeded 365s ok 2 - pg_updatedicts created en_us.affix 365s ok 3 - pg_updatedicts created en_us.dict 365s ok 4 - pg_updatedicts created 12 en_us.affix symlink 365s ok 5 - pg_updatedicts created 12 en_us.dict symlink 369s ok 6 - pg_createcluster 12 main 369s ok 7 - createdb fts 369s ok 8 - correct output of createdb fts 369s ok 9 - creating en_US full text search configuration 369s ok 10 - creating data table and search index 369s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 369s ok 12 - stem search of correct word 369s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 369s ok 14 - stem search of correct word 369s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 369s ok 16 - stem search of unknown word 369s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 369s ok 18 - full text search, exact word 369s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 369s ok 20 - full text search for word stem 369s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 369s ok 22 - full text search for word substring fails 369s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 369s ok 24 - full text search, exact unicode word 370s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 370s ok 26 - full text search for unicode word stem 370s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 370s ok 28 - full text search for unicode word substring fails 370s ok 29 370s ok 30 - Cleanup: No clusters left behind 370s ok 31 - No postgres processes left behind 370s ok 32 - No files in /etc/postgresql left behind 370s ok 33 - No files in /var/lib/postgresql left behind 370s ok 34 - No files in /var/run/postgresql left behind 370s ok 35 - No files in /var/log/postgresql left behind 370s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 370s ok 37 - PostgreSQL TCP ports are closed 370s === Running test 160_alternate_confroot.t ... === 370s 1..28 373s ok 1 373s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 373s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 374s ok 4 - pg_lsclusters -h 374s ok 5 - correct output of pg_lsclusters -h 374s ok 6 - psql -Atl 374s ok 7 - correct output of psql -Atl 374s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 374s ok 9 - ... 374s ok 10 - ... 374s ok 11 - ... 374s ok 12 - ... 374s ok 13 - ... 374s ok 14 - ... 374s ok 15 - pg_dropcluster 12 test --stop 374s ok 16 - correct output of pg_dropcluster 12 test --stop 374s ok 17 - pg_lsclusters -h 374s ok 18 - correct output of pg_lsclusters -h 374s ok 19 - No files in root/data left behind 374s ok 20 - No cruft in root dir left behind 374s ok 21 - Cleanup: No clusters left behind 374s ok 22 - No postgres processes left behind 374s ok 23 - No files in /etc/postgresql left behind 374s ok 24 - No files in /var/lib/postgresql left behind 374s ok 25 - No files in /var/run/postgresql left behind 374s ok 26 - No files in /var/log/postgresql left behind 374s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 374s ok 28 - PostgreSQL TCP ports are closed 374s === Running test 170_extensions.t ... === 374s # Running tests for 12 377s ok 1 - pg_createcluster 12 main 377s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 377s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 377s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 377s ok 5 - extension adminpack installs without error 378s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 378s ok 7 - extension adminpack removes without error 378s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 378s ok 9 - extension amcheck installs without error 378s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 378s ok 11 - extension amcheck removes without error 378s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 378s ok 13 - extension autoinc installs without error 378s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 378s ok 15 - extension autoinc removes without error 378s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 378s ok 17 - extension bloom installs without error 378s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 378s ok 19 - extension bloom removes without error 378s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 378s ok 21 - extension btree_gin installs without error 378s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 378s ok 23 - extension btree_gin removes without error 378s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 378s ok 25 - extension btree_gist installs without error 378s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 378s ok 27 - extension btree_gist removes without error 378s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 378s ok 29 - extension citext installs without error 378s ok 30 - psql -qc 'DROP EXTENSION "citext"' 378s ok 31 - extension citext removes without error 378s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 378s ok 33 - extension cube installs without error 378s ok 34 - psql -qc 'DROP EXTENSION "cube"' 378s ok 35 - extension cube removes without error 379s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 379s ok 37 - extension dblink installs without error 379s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 379s ok 39 - extension dblink removes without error 379s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 379s ok 41 - extension dict_int installs without error 379s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 379s ok 43 - extension dict_int removes without error 379s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 379s ok 45 - extension dict_xsyn installs without error 379s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 379s ok 47 - extension dict_xsyn removes without error 379s ok 48 - psql -qc 'CREATE EXTENSION cube' 379s ok 49 - earthdistance dependency cube installs without error 379s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 379s ok 51 - extension earthdistance installs without error 379s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 379s ok 53 - extension earthdistance removes without error 379s ok 54 - psql -qc 'DROP EXTENSION cube' 379s ok 55 - earthdistance dependency extension cube removes without error 379s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 379s ok 57 - extension file_fdw installs without error 379s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 379s ok 59 - extension file_fdw removes without error 379s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 379s ok 61 - extension fuzzystrmatch installs without error 379s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 379s ok 63 - extension fuzzystrmatch removes without error 379s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 379s ok 65 - extension hstore installs without error 379s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 379s ok 67 - extension hstore removes without error 379s ok 68 - psql -qc 'CREATE EXTENSION hstore' 379s ok 69 - hstore_plperl dependency hstore installs without error 380s ok 70 - psql -qc 'CREATE EXTENSION plperl' 380s ok 71 - hstore_plperl dependency plperl installs without error 380s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 380s ok 73 - extension hstore_plperl installs without error 380s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 380s ok 75 - extension hstore_plperl removes without error 380s ok 76 - psql -qc 'DROP EXTENSION hstore' 380s ok 77 - hstore_plperl dependency extension hstore removes without error 380s ok 78 - psql -qc 'DROP EXTENSION plperl' 380s ok 79 - hstore_plperl dependency extension plperl removes without error 380s ok 80 - psql -qc 'CREATE EXTENSION hstore' 380s ok 81 - hstore_plperlu dependency hstore installs without error 380s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 380s ok 83 - hstore_plperlu dependency plperlu installs without error 380s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 380s ok 85 - extension hstore_plperlu installs without error 380s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 380s ok 87 - extension hstore_plperlu removes without error 380s ok 88 - psql -qc 'DROP EXTENSION hstore' 380s ok 89 - hstore_plperlu dependency extension hstore removes without error 380s ok 90 - psql -qc 'DROP EXTENSION plperlu' 380s ok 91 - hstore_plperlu dependency extension plperlu removes without error 380s ok 92 - psql -qc 'CREATE EXTENSION hstore' 380s ok 93 - hstore_plpython3u dependency hstore installs without error 380s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 380s ok 95 - hstore_plpython3u dependency plpython3u installs without error 380s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 380s ok 97 - extension hstore_plpython3u installs without error 380s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 380s ok 99 - extension hstore_plpython3u removes without error 380s ok 100 - psql -qc 'DROP EXTENSION hstore' 380s ok 101 - hstore_plpython3u dependency extension hstore removes without error 381s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 381s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 381s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 381s ok 105 - extension insert_username installs without error 381s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 381s ok 107 - extension insert_username removes without error 381s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 381s ok 109 - extension intagg installs without error 381s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 381s ok 111 - extension intagg removes without error 381s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 381s ok 113 - extension intarray installs without error 381s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 381s ok 115 - extension intarray removes without error 381s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 381s ok 117 - extension isn installs without error 381s ok 118 - psql -qc 'DROP EXTENSION "isn"' 381s ok 119 - extension isn removes without error 381s ok 120 - psql -qc 'CREATE EXTENSION plperl' 381s ok 121 - jsonb_plperl dependency plperl installs without error 381s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 381s ok 123 - extension jsonb_plperl installs without error 381s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 381s ok 125 - extension jsonb_plperl removes without error 381s ok 126 - psql -qc 'DROP EXTENSION plperl' 381s ok 127 - jsonb_plperl dependency extension plperl removes without error 381s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 381s ok 129 - jsonb_plperlu dependency plperlu installs without error 381s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 381s ok 131 - extension jsonb_plperlu installs without error 381s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 381s ok 133 - extension jsonb_plperlu removes without error 382s ok 134 - psql -qc 'DROP EXTENSION plperlu' 382s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 382s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 382s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 382s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 382s ok 139 - extension jsonb_plpython3u installs without error 382s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 382s ok 141 - extension jsonb_plpython3u removes without error 382s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 382s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 382s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 382s ok 145 - extension lo installs without error 382s ok 146 - psql -qc 'DROP EXTENSION "lo"' 382s ok 147 - extension lo removes without error 382s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 382s ok 149 - extension ltree installs without error 382s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 382s ok 151 - extension ltree removes without error 382s ok 152 - psql -qc 'CREATE EXTENSION ltree' 382s ok 153 - ltree_plpython3u dependency ltree installs without error 382s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 382s ok 155 - ltree_plpython3u dependency plpython3u installs without error 382s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 382s ok 157 - extension ltree_plpython3u installs without error 382s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 382s ok 159 - extension ltree_plpython3u removes without error 382s ok 160 - psql -qc 'DROP EXTENSION ltree' 382s ok 161 - ltree_plpython3u dependency extension ltree removes without error 382s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 382s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 382s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 382s ok 165 - extension moddatetime installs without error 382s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 382s ok 167 - extension moddatetime removes without error 383s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 383s ok 169 - extension pageinspect installs without error 383s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 383s ok 171 - extension pageinspect removes without error 383s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 383s ok 173 - extension pg_buffercache installs without error 383s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 383s ok 175 - extension pg_buffercache removes without error 383s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 383s ok 177 - extension pg_freespacemap installs without error 383s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 383s ok 179 - extension pg_freespacemap removes without error 383s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 383s ok 181 - extension pg_prewarm installs without error 383s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 383s ok 183 - extension pg_prewarm removes without error 383s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 383s ok 185 - extension pg_stat_statements installs without error 383s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 383s ok 187 - extension pg_stat_statements removes without error 383s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 383s ok 189 - extension pg_trgm installs without error 383s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 383s ok 191 - extension pg_trgm removes without error 383s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 383s ok 193 - extension pg_visibility installs without error 383s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 383s ok 195 - extension pg_visibility removes without error 383s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 383s ok 197 - extension pgcrypto installs without error 383s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 383s ok 199 - extension pgcrypto removes without error 383s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 383s ok 201 - extension pgrowlocks installs without error 383s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 383s ok 203 - extension pgrowlocks removes without error 384s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 384s ok 205 - extension pgstattuple installs without error 384s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 384s ok 207 - extension pgstattuple removes without error 384s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 384s ok 209 - extension plperl installs without error 384s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 384s ok 211 - extension plperl removes without error 384s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 384s ok 213 - extension plperlu installs without error 384s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 384s ok 215 - extension plperlu removes without error 384s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 384s ok 217 - extension plpython3u installs without error 384s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 384s ok 219 - extension plpython3u removes without error 384s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 384s ok 221 - extension pltcl installs without error 384s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 384s ok 223 - extension pltcl removes without error 384s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 384s ok 225 - extension pltclu installs without error 384s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 384s ok 227 - extension pltclu removes without error 384s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 384s ok 229 - extension postgres_fdw installs without error 384s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 384s ok 231 - extension postgres_fdw removes without error 384s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 384s ok 233 - extension refint installs without error 384s ok 234 - psql -qc 'DROP EXTENSION "refint"' 384s ok 235 - extension refint removes without error 384s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 384s ok 237 - extension seg installs without error 384s ok 238 - psql -qc 'DROP EXTENSION "seg"' 384s ok 239 - extension seg removes without error 385s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 385s ok 241 - extension sslinfo installs without error 385s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 385s ok 243 - extension sslinfo removes without error 385s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 385s ok 245 - extension tablefunc installs without error 385s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 385s ok 247 - extension tablefunc removes without error 385s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 385s ok 249 - extension tcn installs without error 385s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 385s ok 251 - extension tcn removes without error 385s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 385s ok 253 - extension tsm_system_rows installs without error 385s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 385s ok 255 - extension tsm_system_rows removes without error 385s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 385s ok 257 - extension tsm_system_time installs without error 385s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 385s ok 259 - extension tsm_system_time removes without error 385s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 385s ok 261 - extension unaccent installs without error 385s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 385s ok 263 - extension unaccent removes without error 385s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 385s ok 265 - extension uuid-ossp installs without error 385s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 385s ok 267 - extension uuid-ossp removes without error 385s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 385s ok 269 - extension xml2 installs without error 385s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 385s ok 271 - extension xml2 removes without error 386s ok 272 - pg_dropcluster 12 main 386s ok 273 - Cleanup: No clusters left behind 386s ok 274 - No postgres processes left behind 386s ok 275 - No files in /etc/postgresql left behind 386s ok 276 - No files in /var/lib/postgresql left behind 386s ok 277 - No files in /var/run/postgresql left behind 386s ok 278 - No files in /var/log/postgresql left behind 386s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 386s ok 280 - PostgreSQL TCP ports are closed 386s 1..280 386s === Running test 180_ecpg.t ... === 386s 1..17 386s ok 1 - ecpg test.pgc 386s ok 2 - ecpg processing 386s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 386s ok 4 - compiling ecpg output 390s ok 5 - pg_createcluster 12 main 390s ok 6 - createuser nobody 390s ok 7 - /tmp/tmp.8lQpIVk28C/test 390s ok 8 - runs and gives correct output 390s ok 9 - pg_dropcluster 12 main 390s ok 10 - Cleanup: No clusters left behind 390s ok 11 - No postgres processes left behind 390s ok 12 - No files in /etc/postgresql left behind 390s ok 13 - No files in /var/lib/postgresql left behind 390s ok 14 - No files in /var/run/postgresql left behind 390s ok 15 - No files in /var/log/postgresql left behind 390s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 390s ok 17 - PostgreSQL TCP ports are closed 391s autopkgtest [13:45:11]: test run-testsuite: -----------------------] 392s run-testsuite PASS 392s autopkgtest [13:45:12]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 392s autopkgtest [13:45:12]: test installcheck: preparing testbed 474s autopkgtest [13:46:34]: testbed dpkg architecture: ppc64el 475s autopkgtest [13:46:34]: testbed apt version: 2.0.10 475s autopkgtest [13:46:35]: @@@@@@@@@@@@@@@@@@@@ test bed setup 475s autopkgtest [13:46:35]: testbed release detected to be: focal 476s autopkgtest [13:46:36]: updating testbed package index (apt update) 477s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 477s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 477s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 477s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 477s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 477s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 477s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 477s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 477s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el Packages [140 kB] 477s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el c-n-f Metadata [1444 B] 477s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted ppc64el Packages [1872 B] 477s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted ppc64el c-n-f Metadata [116 B] 477s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe ppc64el Packages [33.2 kB] 477s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe ppc64el c-n-f Metadata [1760 B] 477s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse ppc64el Packages [952 B] 477s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/multiverse ppc64el c-n-f Metadata [116 B] 480s Fetched 560 kB in 1s (561 kB/s) 481s Reading package lists... 482s Reading package lists... 482s Building dependency tree... 482s Reading state information... 482s Calculating upgrade... 483s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 483s Reading package lists... 483s Building dependency tree... 483s Reading state information... 483s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 483s autopkgtest [13:46:43]: upgrading testbed (apt dist-upgrade and autopurge) 483s Reading package lists... 484s Building dependency tree... 484s Reading state information... 484s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 484s Starting 2 pkgProblemResolver with broken count: 0 484s Done 484s 484s The following packages will be upgraded: 484s tzdata 484s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 484s Need to get 300 kB of archives. 484s After this operation, 3072 B of additional disk space will be used. 484s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main ppc64el tzdata all 2025a-0ubuntu0.20.04 [300 kB] 484s Preconfiguring packages ... 485s Fetched 300 kB in 0s (730 kB/s) 485s (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 ... 94082 files and directories currently installed.) 485s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 485s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 485s Setting up tzdata (2025a-0ubuntu0.20.04) ... 485s 485s Current default time zone: 'Etc/UTC' 485s Local time is now: Wed Feb 26 13:46:45 UTC 2025. 485s Universal Time is now: Wed Feb 26 13:46:45 UTC 2025. 485s Run 'dpkg-reconfigure tzdata' if you wish to change it. 485s 486s Reading package lists... 486s Building dependency tree... 486s Reading state information... 486s Starting pkgProblemResolver with broken count: 0 486s Starting 2 pkgProblemResolver with broken count: 0 486s Done 486s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 489s Reading package lists... 489s Building dependency tree... 489s Reading state information... 489s Starting pkgProblemResolver with broken count: 0 489s Starting 2 pkgProblemResolver with broken count: 0 489s Done 489s The following NEW packages will be installed: 489s binfmt-support build-essential clang-10 cpp cpp-9 g++ g++-9 gcc gcc-9 489s gcc-9-base libasan5 libatomic1 libc-dev-bin libc6-dev libcc1-0 489s libclang-common-10-dev libclang-cpp10 libclang1-10 libcrypt-dev 489s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1c2 libgcc-9-dev 489s libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 libncurses-dev 489s libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.8 489s libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 libubsan1 489s libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 489s llvm-10-runtime llvm-10-tools postgresql-12 postgresql-client-12 489s postgresql-client-common postgresql-common postgresql-doc-12 489s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 489s postgresql-server-dev-12 python3-pygments ssl-cert 489s 0 upgraded, 64 newly installed, 0 to remove and 0 not upgraded. 489s Need to get 133 MB of archives. 489s After this operation, 756 MB of additional disk space will be used. 489s Get:1 http://ftpmaster.internal/ubuntu focal/universe ppc64el binfmt-support ppc64el 2.2.0-2 [69.4 kB] 490s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libc-dev-bin ppc64el 2.31-0ubuntu9.17 [72.9 kB] 490s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el linux-libc-dev ppc64el 5.4.0-208.228 [1112 kB] 490s Get:4 http://ftpmaster.internal/ubuntu focal/main ppc64el libcrypt-dev ppc64el 1:4.4.10-10ubuntu4 [139 kB] 490s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libc6-dev ppc64el 2.31-0ubuntu9.17 [2516 kB] 490s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el gcc-9-base ppc64el 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 490s Get:7 http://ftpmaster.internal/ubuntu focal/main ppc64el libisl22 ppc64el 0.22.1-1 [691 kB] 490s Get:8 http://ftpmaster.internal/ubuntu focal/main ppc64el libmpc3 ppc64el 1.1.0-1 [40.5 kB] 490s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el cpp-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [6847 kB] 490s Get:10 http://ftpmaster.internal/ubuntu focal/main ppc64el cpp ppc64el 4:9.3.0-1ubuntu2 [27.6 kB] 490s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libcc1-0 ppc64el 10.5.0-1ubuntu1~20.04 [42.1 kB] 490s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libgomp1 ppc64el 10.5.0-1ubuntu1~20.04 [109 kB] 490s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libitm1 ppc64el 10.5.0-1ubuntu1~20.04 [28.5 kB] 490s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libatomic1 ppc64el 10.5.0-1ubuntu1~20.04 [10.0 kB] 490s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libasan5 ppc64el 9.4.0-1ubuntu1~20.04.2 [2784 kB] 490s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el liblsan0 ppc64el 10.5.0-1ubuntu1~20.04 [848 kB] 490s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libtsan0 ppc64el 10.5.0-1ubuntu1~20.04 [2029 kB] 490s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libubsan1 ppc64el 10.5.0-1ubuntu1~20.04 [800 kB] 490s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libquadmath0 ppc64el 10.5.0-1ubuntu1~20.04 [149 kB] 490s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libgcc-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [1258 kB] 490s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el gcc-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [7591 kB] 491s Get:22 http://ftpmaster.internal/ubuntu focal/main ppc64el gcc ppc64el 4:9.3.0-1ubuntu2 [5228 B] 491s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libstdc++-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [1762 kB] 491s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el g++-9 ppc64el 9.4.0-1ubuntu1~20.04.2 [7765 kB] 491s Get:25 http://ftpmaster.internal/ubuntu focal/main ppc64el g++ ppc64el 4:9.3.0-1ubuntu2 [1600 B] 491s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el build-essential ppc64el 12.8ubuntu1.1 [4664 B] 491s Get:27 http://ftpmaster.internal/ubuntu focal/main ppc64el libllvm10 ppc64el 1:10.0.0-4ubuntu1 [14.4 MB] 491s Get:28 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang-cpp10 ppc64el 1:10.0.0-4ubuntu1 [9294 kB] 492s Get:29 http://ftpmaster.internal/ubuntu focal/main ppc64el libgc1c2 ppc64el 1:7.6.4-0.4ubuntu1 [85.8 kB] 492s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el libobjc4 ppc64el 10.5.0-1ubuntu1~20.04 [47.4 kB] 492s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el libobjc-9-dev ppc64el 9.4.0-1ubuntu1~20.04.2 [231 kB] 492s Get:32 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang-common-10-dev ppc64el 1:10.0.0-4ubuntu1 [3049 kB] 492s Get:33 http://ftpmaster.internal/ubuntu focal/universe ppc64el libclang1-10 ppc64el 1:10.0.0-4ubuntu1 [7301 kB] 492s Get:34 http://ftpmaster.internal/ubuntu focal/universe ppc64el clang-10 ppc64el 1:10.0.0-4ubuntu1 [66.1 kB] 492s Get:35 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpgtypes3 ppc64el 12.22-0ubuntu0.20.04.1 [50.6 kB] 492s Get:36 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpq5 ppc64el 12.22-0ubuntu0.20.04.1 [135 kB] 492s Get:37 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg6 ppc64el 12.22-0ubuntu0.20.04.1 [47.6 kB] 492s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg-compat3 ppc64el 12.22-0ubuntu0.20.04.1 [13.3 kB] 492s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpq-dev ppc64el 12.22-0ubuntu0.20.04.1 [153 kB] 492s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libecpg-dev ppc64el 12.22-0ubuntu0.20.04.1 [244 kB] 492s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libncurses-dev ppc64el 6.2-0ubuntu2.1 [413 kB] 492s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libpython3.8 ppc64el 3.8.10-0ubuntu1~20.04.15 [1690 kB] 492s Get:43 http://ftpmaster.internal/ubuntu focal/main ppc64el libtcl8.6 ppc64el 8.6.10+dfsg-1 [1008 kB] 492s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libtinfo-dev ppc64el 6.2-0ubuntu2.1 [976 B] 492s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el libxslt1.1 ppc64el 1.1.34-4ubuntu0.20.04.1 [166 kB] 492s Get:46 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-runtime ppc64el 1:10.0.0-4ubuntu1 [985 kB] 492s Get:47 http://ftpmaster.internal/ubuntu focal/main ppc64el libpfm4 ppc64el 4.10.1+git20-g7700f49-2 [140 kB] 492s Get:48 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10 ppc64el 1:10.0.0-4ubuntu1 [4821 kB] 493s Get:49 http://ftpmaster.internal/ubuntu focal/main ppc64el libffi-dev ppc64el 3.3-4 [60.7 kB] 493s Get:50 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 493s Get:51 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-tools ppc64el 1:10.0.0-4ubuntu1 [336 kB] 493s Get:52 http://ftpmaster.internal/ubuntu focal/universe ppc64el libz3-4 ppc64el 4.8.7-4build1 [6665 kB] 493s Get:53 http://ftpmaster.internal/ubuntu focal/universe ppc64el libz3-dev ppc64el 4.8.7-4build1 [67.5 kB] 493s Get:54 http://ftpmaster.internal/ubuntu focal/universe ppc64el llvm-10-dev ppc64el 1:10.0.0-4ubuntu1 [25.4 MB] 494s Get:55 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-client-common all 214ubuntu0.1 [28.2 kB] 494s Get:56 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-client-12 ppc64el 12.22-0ubuntu0.20.04.1 [1108 kB] 494s Get:57 http://ftpmaster.internal/ubuntu focal/main ppc64el ssl-cert all 1.0.39 [17.0 kB] 494s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-common all 214ubuntu0.1 [169 kB] 494s Get:59 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-12 ppc64el 12.22-0ubuntu0.20.04.1 [14.1 MB] 494s Get:60 http://ftpmaster.internal/ubuntu focal-updates/main ppc64el postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 495s Get:61 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-plperl-12 ppc64el 12.22-0ubuntu0.20.04.1 [71.2 kB] 495s Get:62 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-plpython3-12 ppc64el 12.22-0ubuntu0.20.04.1 [77.6 kB] 495s Get:63 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-pltcl-12 ppc64el 12.22-0ubuntu0.20.04.1 [31.9 kB] 495s Get:64 http://ftpmaster.internal/ubuntu focal-updates/universe ppc64el postgresql-server-dev-12 ppc64el 12.22-0ubuntu0.20.04.1 [1017 kB] 495s Preconfiguring packages ... 495s Fetched 133 MB in 5s (25.3 MB/s) 495s Selecting previously unselected package binfmt-support. 495s (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 ... 94083 files and directories currently installed.) 495s Preparing to unpack .../00-binfmt-support_2.2.0-2_ppc64el.deb ... 495s Unpacking binfmt-support (2.2.0-2) ... 495s Selecting previously unselected package libc-dev-bin. 495s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_ppc64el.deb ... 495s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 495s Selecting previously unselected package linux-libc-dev:ppc64el. 495s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_ppc64el.deb ... 495s Unpacking linux-libc-dev:ppc64el (5.4.0-208.228) ... 496s Selecting previously unselected package libcrypt-dev:ppc64el. 496s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_ppc64el.deb ... 496s Unpacking libcrypt-dev:ppc64el (1:4.4.10-10ubuntu4) ... 496s Selecting previously unselected package libc6-dev:ppc64el. 496s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_ppc64el.deb ... 496s Unpacking libc6-dev:ppc64el (2.31-0ubuntu9.17) ... 496s Selecting previously unselected package gcc-9-base:ppc64el. 496s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 496s Unpacking gcc-9-base:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 496s Selecting previously unselected package libisl22:ppc64el. 496s Preparing to unpack .../06-libisl22_0.22.1-1_ppc64el.deb ... 496s Unpacking libisl22:ppc64el (0.22.1-1) ... 496s Selecting previously unselected package libmpc3:ppc64el. 496s Preparing to unpack .../07-libmpc3_1.1.0-1_ppc64el.deb ... 496s Unpacking libmpc3:ppc64el (1.1.0-1) ... 496s Selecting previously unselected package cpp-9. 496s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 496s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 497s Selecting previously unselected package cpp. 497s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 497s Unpacking cpp (4:9.3.0-1ubuntu2) ... 497s Selecting previously unselected package libcc1-0:ppc64el. 497s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libcc1-0:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libgomp1:ppc64el. 497s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libgomp1:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libitm1:ppc64el. 497s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libitm1:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libatomic1:ppc64el. 497s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libatomic1:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libasan5:ppc64el. 497s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 497s Unpacking libasan5:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 497s Selecting previously unselected package liblsan0:ppc64el. 497s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking liblsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libtsan0:ppc64el. 497s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libtsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libubsan1:ppc64el. 497s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libubsan1:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libquadmath0:ppc64el. 497s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 497s Unpacking libquadmath0:ppc64el (10.5.0-1ubuntu1~20.04) ... 497s Selecting previously unselected package libgcc-9-dev:ppc64el. 497s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 497s Unpacking libgcc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 498s Selecting previously unselected package gcc-9. 498s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 498s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 498s Selecting previously unselected package gcc. 498s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 498s Unpacking gcc (4:9.3.0-1ubuntu2) ... 498s Selecting previously unselected package libstdc++-9-dev:ppc64el. 498s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 498s Unpacking libstdc++-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 498s Selecting previously unselected package g++-9. 498s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 498s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 499s Selecting previously unselected package g++. 499s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_ppc64el.deb ... 499s Unpacking g++ (4:9.3.0-1ubuntu2) ... 499s Selecting previously unselected package build-essential. 499s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_ppc64el.deb ... 499s Unpacking build-essential (12.8ubuntu1.1) ... 499s Selecting previously unselected package libllvm10:ppc64el. 499s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 499s Unpacking libllvm10:ppc64el (1:10.0.0-4ubuntu1) ... 500s Selecting previously unselected package libclang-cpp10. 500s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 500s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 501s Selecting previously unselected package libgc1c2:ppc64el. 501s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_ppc64el.deb ... 501s Unpacking libgc1c2:ppc64el (1:7.6.4-0.4ubuntu1) ... 501s Selecting previously unselected package libobjc4:ppc64el. 501s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_ppc64el.deb ... 501s Unpacking libobjc4:ppc64el (10.5.0-1ubuntu1~20.04) ... 501s Selecting previously unselected package libobjc-9-dev:ppc64el. 501s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_ppc64el.deb ... 501s Unpacking libobjc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 501s Selecting previously unselected package libclang-common-10-dev. 501s Preparing to unpack .../31-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 501s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 502s Selecting previously unselected package libclang1-10. 502s Preparing to unpack .../32-libclang1-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 502s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 502s Selecting previously unselected package clang-10. 502s Preparing to unpack .../33-clang-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 502s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 502s Selecting previously unselected package libpgtypes3:ppc64el. 502s Preparing to unpack .../34-libpgtypes3_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libpgtypes3:ppc64el (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libpq5:ppc64el. 502s Preparing to unpack .../35-libpq5_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libpq5:ppc64el (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libecpg6:ppc64el. 502s Preparing to unpack .../36-libecpg6_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libecpg6:ppc64el (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libecpg-compat3:ppc64el. 502s Preparing to unpack .../37-libecpg-compat3_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libecpg-compat3:ppc64el (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libpq-dev. 502s Preparing to unpack .../38-libpq-dev_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libecpg-dev. 502s Preparing to unpack .../39-libecpg-dev_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 502s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 502s Selecting previously unselected package libncurses-dev:ppc64el. 502s Preparing to unpack .../40-libncurses-dev_6.2-0ubuntu2.1_ppc64el.deb ... 502s Unpacking libncurses-dev:ppc64el (6.2-0ubuntu2.1) ... 502s Selecting previously unselected package libpython3.8:ppc64el. 502s Preparing to unpack .../41-libpython3.8_3.8.10-0ubuntu1~20.04.15_ppc64el.deb ... 502s Unpacking libpython3.8:ppc64el (3.8.10-0ubuntu1~20.04.15) ... 503s Selecting previously unselected package libtcl8.6:ppc64el. 503s Preparing to unpack .../42-libtcl8.6_8.6.10+dfsg-1_ppc64el.deb ... 503s Unpacking libtcl8.6:ppc64el (8.6.10+dfsg-1) ... 503s Selecting previously unselected package libtinfo-dev:ppc64el. 503s Preparing to unpack .../43-libtinfo-dev_6.2-0ubuntu2.1_ppc64el.deb ... 503s Unpacking libtinfo-dev:ppc64el (6.2-0ubuntu2.1) ... 503s Selecting previously unselected package libxslt1.1:ppc64el. 503s Preparing to unpack .../44-libxslt1.1_1.1.34-4ubuntu0.20.04.1_ppc64el.deb ... 503s Unpacking libxslt1.1:ppc64el (1.1.34-4ubuntu0.20.04.1) ... 503s Selecting previously unselected package llvm-10-runtime. 503s Preparing to unpack .../45-llvm-10-runtime_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 503s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 503s Selecting previously unselected package libpfm4:ppc64el. 503s Preparing to unpack .../46-libpfm4_4.10.1+git20-g7700f49-2_ppc64el.deb ... 503s Unpacking libpfm4:ppc64el (4.10.1+git20-g7700f49-2) ... 503s Selecting previously unselected package llvm-10. 503s Preparing to unpack .../47-llvm-10_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 503s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 503s Selecting previously unselected package libffi-dev:ppc64el. 503s Preparing to unpack .../48-libffi-dev_3.3-4_ppc64el.deb ... 503s Unpacking libffi-dev:ppc64el (3.3-4) ... 503s Selecting previously unselected package python3-pygments. 503s Preparing to unpack .../49-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 503s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 503s Selecting previously unselected package llvm-10-tools. 503s Preparing to unpack .../50-llvm-10-tools_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 503s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 503s Selecting previously unselected package libz3-4:ppc64el. 503s Preparing to unpack .../51-libz3-4_4.8.7-4build1_ppc64el.deb ... 503s Unpacking libz3-4:ppc64el (4.8.7-4build1) ... 504s Selecting previously unselected package libz3-dev:ppc64el. 504s Preparing to unpack .../52-libz3-dev_4.8.7-4build1_ppc64el.deb ... 504s Unpacking libz3-dev:ppc64el (4.8.7-4build1) ... 504s Selecting previously unselected package llvm-10-dev. 504s Preparing to unpack .../53-llvm-10-dev_1%3a10.0.0-4ubuntu1_ppc64el.deb ... 504s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 507s Selecting previously unselected package postgresql-client-common. 507s Preparing to unpack .../54-postgresql-client-common_214ubuntu0.1_all.deb ... 507s Unpacking postgresql-client-common (214ubuntu0.1) ... 507s Selecting previously unselected package postgresql-client-12. 507s Preparing to unpack .../55-postgresql-client-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 507s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 507s Selecting previously unselected package ssl-cert. 507s Preparing to unpack .../56-ssl-cert_1.0.39_all.deb ... 507s Unpacking ssl-cert (1.0.39) ... 507s Selecting previously unselected package postgresql-common. 507s Preparing to unpack .../57-postgresql-common_214ubuntu0.1_all.deb ... 507s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 507s Unpacking postgresql-common (214ubuntu0.1) ... 507s Selecting previously unselected package postgresql-12. 507s Preparing to unpack .../58-postgresql-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 507s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 508s Selecting previously unselected package postgresql-doc-12. 508s Preparing to unpack .../59-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 508s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 508s Selecting previously unselected package postgresql-plperl-12. 508s Preparing to unpack .../60-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 508s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 508s Selecting previously unselected package postgresql-plpython3-12. 508s Preparing to unpack .../61-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 508s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 508s Selecting previously unselected package postgresql-pltcl-12. 508s Preparing to unpack .../62-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 508s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 508s Selecting previously unselected package postgresql-server-dev-12. 508s Preparing to unpack .../63-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_ppc64el.deb ... 508s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 508s Setting up postgresql-client-common (214ubuntu0.1) ... 508s Setting up libpgtypes3:ppc64el (12.22-0ubuntu0.20.04.1) ... 508s Setting up libgc1c2:ppc64el (1:7.6.4-0.4ubuntu1) ... 508s Setting up libpq5:ppc64el (12.22-0ubuntu0.20.04.1) ... 508s Setting up linux-libc-dev:ppc64el (5.4.0-208.228) ... 508s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 508s Setting up libobjc4:ppc64el (10.5.0-1ubuntu1~20.04) ... 508s Setting up libgomp1:ppc64el (10.5.0-1ubuntu1~20.04) ... 508s Setting up libffi-dev:ppc64el (3.3-4) ... 508s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 509s 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 509s Setting up libllvm10:ppc64el (1:10.0.0-4ubuntu1) ... 509s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 509s Setting up libz3-4:ppc64el (4.8.7-4build1) ... 509s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 509s 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 510s Setting up libpfm4:ppc64el (4.10.1+git20-g7700f49-2) ... 510s Setting up ssl-cert (1.0.39) ... 510s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 510s Setting up libpython3.8:ppc64el (3.8.10-0ubuntu1~20.04.15) ... 510s Setting up libquadmath0:ppc64el (10.5.0-1ubuntu1~20.04) ... 510s Setting up postgresql-common (214ubuntu0.1) ... 510s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 510s Adding user postgres to group ssl-cert 510s 510s Creating config file /etc/postgresql-common/createcluster.conf with new version 510s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 510s Removing obsolete dictionary files: 511s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 511s Setting up libmpc3:ppc64el (1.1.0-1) ... 511s Setting up libatomic1:ppc64el (10.5.0-1ubuntu1~20.04) ... 511s Setting up libtcl8.6:ppc64el (8.6.10+dfsg-1) ... 511s Setting up binfmt-support (2.2.0-2) ... 512s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 512s Setting up libubsan1:ppc64el (10.5.0-1ubuntu1~20.04) ... 512s Setting up libcrypt-dev:ppc64el (1:4.4.10-10ubuntu4) ... 512s Setting up libxslt1.1:ppc64el (1.1.34-4ubuntu0.20.04.1) ... 512s Setting up libecpg6:ppc64el (12.22-0ubuntu0.20.04.1) ... 512s Setting up libisl22:ppc64el (0.22.1-1) ... 512s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 513s Creating new PostgreSQL cluster 12/main ... 513s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 513s The files belonging to this database system will be owned by user "postgres". 513s This user must also own the server process. 513s 513s The database cluster will be initialized with locale "C.UTF-8". 513s The default database encoding has accordingly been set to "UTF8". 513s The default text search configuration will be set to "english". 513s 513s Data page checksums are disabled. 513s 513s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 513s creating subdirectories ... ok 513s selecting dynamic shared memory implementation ... posix 513s selecting default max_connections ... 100 513s selecting default shared_buffers ... 128MB 513s selecting default time zone ... Etc/UTC 513s creating configuration files ... ok 513s running bootstrap script ... ok 513s performing post-bootstrap initialization ... ok 513s syncing data to disk ... ok 513s 513s Success. You can now start the database server using: 513s 513s pg_ctlcluster 12 main start 513s 514s Ver Cluster Port Status Owner Data directory Log file 514s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 514s 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 517s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 517s Setting up libcc1-0:ppc64el (10.5.0-1ubuntu1~20.04) ... 517s Setting up liblsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 517s Setting up libitm1:ppc64el (10.5.0-1ubuntu1~20.04) ... 517s Setting up gcc-9-base:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up libtsan0:ppc64el (10.5.0-1ubuntu1~20.04) ... 517s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 517s Setting up libz3-dev:ppc64el (4.8.7-4build1) ... 517s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 517s Setting up libecpg-compat3:ppc64el (12.22-0ubuntu0.20.04.1) ... 517s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 517s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 517s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 517s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 517s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 517s Setting up libasan5:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 517s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up libc6-dev:ppc64el (2.31-0ubuntu9.17) ... 517s Setting up libncurses-dev:ppc64el (6.2-0ubuntu2.1) ... 517s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 517s Setting up libgcc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 517s Setting up libobjc-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up cpp (4:9.3.0-1ubuntu2) ... 517s Setting up libtinfo-dev:ppc64el (6.2-0ubuntu2.1) ... 517s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up libstdc++-9-dev:ppc64el (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up gcc (4:9.3.0-1ubuntu2) ... 517s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 517s Setting up g++ (4:9.3.0-1ubuntu2) ... 517s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 517s Setting up build-essential (12.8ubuntu1.1) ... 517s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 517s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 517s Processing triggers for systemd (245.4-4ubuntu3.24) ... 517s Processing triggers for man-db (2.9.1-1) ... 518s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 518s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 532s autopkgtest [13:47:32]: test installcheck: [----------------------- 532s + dpkg-parsechangelog -SSource 532s + SOURCE=postgresql-12 532s + MAJOR=12 532s + cd src/test/regress 532s + make -f ../../../debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/12/bin/pg_config with_llvm=no 532s 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 -O3 -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 533s 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 -O3 -fstack-protector-strong -Wformat -Werror=format-security -fPIC -shared -o regress.so regress.o -L/usr/lib/powerpc64le-linux-gnu -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-10/lib -L/usr/lib/powerpc64le-linux-gnu/mit-krb5 -Wl,--as-needed 533s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.4btPsT/build.0y8/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 533s + rm -rf testtablespace results regression.* 533s + mkdir testtablespace results 533s + id -u 533s + [ 1000 = 0 ] 533s + pg_virtualenv -v 12 /usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule 533s Creating new PostgreSQL cluster 12/regress ... 533s /usr/lib/postgresql/12/bin/initdb -D /tmp/pg_virtualenv.LWO2gw/data/12/regress --auth-local peer --auth-host md5 --username=ubuntu --pwfile=/tmp/pg_virtualenv.LWO2gw/postgresql-common/pwfile --nosync 533s The files belonging to this database system will be owned by user "ubuntu". 533s This user must also own the server process. 533s 533s The database cluster will be initialized with locale "C.UTF-8". 533s The default database encoding has accordingly been set to "UTF8". 533s The default text search configuration will be set to "english". 533s 533s Data page checksums are disabled. 533s 533s fixing permissions on existing directory /tmp/pg_virtualenv.LWO2gw/data/12/regress ... ok 533s creating subdirectories ... ok 533s selecting dynamic shared memory implementation ... posix 533s selecting default max_connections ... 100 533s selecting default shared_buffers ... 128MB 533s selecting default time zone ... Etc/UTC 533s creating configuration files ... ok 533s running bootstrap script ... ok 534s performing post-bootstrap initialization ... ok 534s 534s Sync to disk skipped. 534s The data directory might become corrupt if the operating system crashes. 534s 534s Success. You can now start the database server using: 534s 534s pg_ctlcluster 12 regress start 534s 534s Warning: The parent /var/run/postgresql of the selected 534s stats_temp_directory is not writable for the cluster owner. Not adding this 534s setting in postgresql.conf. 536s Ver Cluster Port Status Owner Data directory Log file 536s 12 regress 5433 online ubuntu /tmp/pg_virtualenv.LWO2gw/data/12/regress /tmp/pg_virtualenv.LWO2gw/log/postgresql-12-regress.log 536s 536s (using postmaster on localhost, port 5433) 536s ============== dropping database "regression" ============== 536s DROP DATABASE 536s NOTICE: database "regression" does not exist, skipping 536s ============== creating database "regression" ============== 536s CREATE DATABASE 536s ALTER DATABASE 536s ============== running regression test queries ============== 536s test tablespace ... ok 165 ms 537s parallel group (20 tests): varchar name text char oid int2 pg_lsn txid int4 uuid regproc money enum float4 int8 float8 boolean bit numeric rangetypes 537s boolean ... ok 413 ms 537s char ... ok 99 ms 537s name ... ok 87 ms 537s varchar ... ok 68 ms 537s text ... ok 92 ms 537s int2 ... ok 159 ms 537s int4 ... ok 187 ms 537s int8 ... ok 267 ms 537s oid ... ok 144 ms 537s float4 ... ok 259 ms 537s float8 ... ok 305 ms 537s bit ... ok 452 ms 537s numeric ... ok 525 ms 537s txid ... ok 176 ms 537s uuid ... ok 201 ms 537s enum ... ok 254 ms 537s money ... ok 237 ms 537s rangetypes ... ok 652 ms 537s pg_lsn ... ok 158 ms 537s regproc ... ok 215 ms 538s parallel group (19 tests): path circle timetz macaddr macaddr8 inet tstypes time date numerology lseg line strings interval point box timestamp timestamptz polygon 538s strings ... ok 215 ms 538s numerology ... ok 181 ms 538s point ... ok 356 ms 538s lseg ... ok 197 ms 538s line ... ok 201 ms 538s box ... ok 371 ms 538s path ... ok 114 ms 538s polygon ... ok 702 ms 538s circle ... ok 116 ms 538s date ... ok 175 ms 538s time ... ok 174 ms 538s timetz ... ok 134 ms 538s timestamp ... ok 454 ms 538s timestamptz ... FAILED 472 ms 538s interval ... ok 261 ms 538s inet ... ok 164 ms 538s macaddr ... ok 133 ms 538s macaddr8 ... ok 148 ms 538s tstypes ... ok 172 ms 538s parallel group (10 tests): comments misc_sanity expressions oidjoins type_sanity geometry database regex horology opr_sanity 538s geometry ... ok 367 ms 538s horology ... ok 636 ms 538s regex ... ok 617 ms 538s oidjoins ... ok 181 ms 538s type_sanity ... ok 310 ms 538s opr_sanity ... ok 654 ms 538s misc_sanity ... ok 93 ms 538s comments ... ok 77 ms 538s expressions ... ok 113 ms 538s database ... ok 401 ms 538s test create_function_1 ... ok 18 ms 538s test create_type ... ok 22 ms 539s test create_table ... ok 310 ms 539s test create_function_2 ... ok 13 ms 539s parallel group (5 tests): copydml copyselect insert_conflict copy insert 539s copy ... ok 386 ms 539s copyselect ... ok 61 ms 539s copydml ... ok 41 ms 539s insert ... ok 436 ms 539s insert_conflict ... ok 269 ms 539s parallel group (4 tests): create_operator create_schema create_procedure create_misc 539s create_misc ... ok 81 ms 539s create_operator ... ok 29 ms 539s create_procedure ... ok 78 ms 539s create_schema ... ok 54 ms 541s parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 541s create_index ... ok 1291 ms 541s create_index_spgist ... ok 1198 ms 541s create_view ... ok 390 ms 541s index_including ... ok 235 ms 541s index_including_gist ... ok 365 ms 542s parallel group (16 tests): infinite_recurse hash_func create_am create_function_3 roleattributes errors create_cast create_aggregate drop_if_exists typed_table select constraints vacuum updatable_views triggers inherit 542s create_aggregate ... ok 159 ms 542s create_function_3 ... ok 125 ms 542s create_cast ... ok 130 ms 542s constraints ... ok 450 ms 542s triggers ... ok 854 ms 542s select ... ok 309 ms 542s inherit ... ok 1008 ms 542s typed_table ... ok 283 ms 542s vacuum ... ok 458 ms 542s drop_if_exists ... ok 201 ms 542s updatable_views ... ok 730 ms 542s roleattributes ... ok 127 ms 542s create_am ... ok 117 ms 542s hash_func ... ok 93 ms 542s errors ... ok 127 ms 542s infinite_recurse ... ok 70 ms 542s test sanity_check ... ok 107 ms 543s parallel group (20 tests): select_distinct select_distinct_on select_having random case delete select_implicit namespace select_into prepared_xacts union transactions portals subselect arrays aggregates hash_index btree_index update join 543s select_into ... ok 222 ms 543s select_distinct ... ok 45 ms 543s select_distinct_on ... ok 80 ms 543s select_implicit ... ok 198 ms 543s select_having ... ok 136 ms 543s subselect ... ok 586 ms 543s union ... ok 415 ms 543s case ... ok 157 ms 543s join ... ok 1495 ms 543s aggregates ... ok 822 ms 543s transactions ... ok 498 ms 543s random ... ok 135 ms 543s portals ... ok 554 ms 543s arrays ... ok 740 ms 543s btree_index ... ok 1088 ms 543s hash_index ... ok 875 ms 543s update ... ok 1120 ms 543s delete ... ok 156 ms 543s namespace ... ok 197 ms 543s prepared_xacts ... ok 342 ms 550s parallel group (20 tests): init_privs security_label drop_operator lock object_address password tablesample replica_identity identity matview gin generated groupingsets rowsecurity collate spgist gist brin join_hash privileges 550s brin ... ok 6165 ms 550s gin ... ok 1190 ms 550s gist ... ok 2050 ms 550s spgist ... ok 1761 ms 550s privileges ... ok 6391 ms 550s init_privs ... ok 75 ms 550s security_label ... ok 145 ms 550s collate ... ok 1739 ms 550s matview ... ok 1164 ms 550s lock ... ok 432 ms 550s replica_identity ... ok 741 ms 550s rowsecurity ... ok 1660 ms 550s object_address ... ok 439 ms 550s tablesample ... ok 518 ms 550s groupingsets ... ok 1582 ms 550s drop_operator ... ok 298 ms 550s password ... ok 459 ms 550s identity ... ok 867 ms 550s generated ... ok 1292 ms 550s join_hash ... ok 6169 ms 551s parallel group (11 tests): alter_operator dbsize async tidscan tid tsrf alter_generic misc_functions sysviews create_table_like misc 551s create_table_like ... ok 356 ms 551s alter_generic ... ok 171 ms 551s alter_operator ... ok 22 ms 551s misc ... ok 1017 ms 551s async ... ok 84 ms 551s dbsize ... ok 75 ms 551s misc_functions ... ok 294 ms 551s sysviews ... ok 330 ms 551s tsrf ... ok 150 ms 551s tid ... ok 140 ms 551s tidscan ... ok 117 ms 551s parallel group (5 tests): amutils psql_crosstab psql rules stats_ext 551s rules ... ok 318 ms 551s psql ... ok 248 ms 551s psql_crosstab ... ok 71 ms 551s amutils ... ok 68 ms 551s stats_ext ... ok 752 ms 554s test select_parallel ... ok 2426 ms 554s test write_parallel ... ok 64 ms 554s parallel group (2 tests): subscription publication 554s publication ... ok 62 ms 554s subscription ... ok 21 ms 555s parallel group (17 tests): portals_p2 select_views advisory_lock xmlmap functional_deps dependency combocid tsdicts equivclass guc window cluster bitmapops indirect_toast foreign_data tsearch foreign_key 555s select_views ... ok 211 ms 555s portals_p2 ... ok 122 ms 555s foreign_key ... ok 1370 ms 555s cluster ... ok 815 ms 555s dependency ... ok 311 ms 555s guc ... ok 435 ms 555s bitmapops ... ok 851 ms 555s combocid ... ok 330 ms 555s tsearch ... ok 1215 ms 555s tsdicts ... ok 343 ms 555s foreign_data ... ok 1137 ms 555s window ... ok 697 ms 555s xmlmap ... ok 271 ms 555s functional_deps ... ok 309 ms 555s advisory_lock ... ok 235 ms 555s indirect_toast ... ok 924 ms 555s equivclass ... ok 404 ms 556s parallel group (6 tests): jsonpath_encoding json_encoding jsonpath json jsonb_jsonpath jsonb 556s json ... ok 110 ms 556s jsonb ... ok 212 ms 556s json_encoding ... ok 58 ms 556s jsonpath ... ok 81 ms 556s jsonpath_encoding ... ok 50 ms 556s jsonb_jsonpath ... ok 112 ms 557s parallel group (18 tests): limit conversion prepare returning copy2 temp with plancache rowtypes polymorphism sequence truncate largeobject domain xml rangefuncs plpgsql alter_table 557s plancache ... ok 552 ms 557s limit ... ok 104 ms 557s plpgsql ... ok 1156 ms 557s copy2 ... ok 495 ms 557s temp ... ok 537 ms 557s domain ... ok 802 ms 557s rangefuncs ... ok 1068 ms 557s prepare ... ok 233 ms 557s conversion ... ok 187 ms 557s truncate ... ok 692 ms 557s alter_table ... ok 1617 ms 557s sequence ... ok 684 ms 557s polymorphism ... ok 670 ms 557s rowtypes ... ok 556 ms 557s returning ... ok 349 ms 557s largeobject ... ok 797 ms 557s with ... ok 546 ms 557s xml ... ok 1055 ms 559s parallel group (7 tests): hash_part reloptions partition_info partition_join partition_aggregate indexing partition_prune 559s partition_join ... ok 713 ms 559s partition_prune ... ok 1334 ms 559s reloptions ... ok 87 ms 559s hash_part ... ok 82 ms 559s indexing ... ok 1012 ms 559s partition_aggregate ... ok 847 ms 559s partition_info ... ok 114 ms 559s test event_trigger ... ok 95 ms 559s test fast_default ... ok 114 ms 559s test stats ... ok 574 ms 559s 559s ======================== 559s 1 of 196 tests failed. 559s ======================== 559s 559s The differences that caused some tests to fail can be viewed in the 559s file "/tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/regression.diffs". A copy of the test summary that you see 559s above is saved in the file "/tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/regression.out". 559s 559s *** /tmp/pg_virtualenv.LWO2gw/log/postgresql-12-regress.log (last 100 lines) *** 559s 2025-02-26 13:47:58.734 UTC [7392] ubuntu@regression DETAIL: Key (a)=(3) already exists. 559s 2025-02-26 13:47:58.734 UTC [7392] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression DETAIL: Key (a)=(4) already exists. 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 559s 2025-02-26 13:47:58.736 UTC [7392] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 559s 2025-02-26 13:47:58.738 UTC [7392] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 559s 2025-02-26 13:47:58.738 UTC [7392] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 559s 2025-02-26 13:47:58.741 UTC [7392] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 559s 2025-02-26 13:47:58.741 UTC [7392] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 559s 2025-02-26 13:47:58.773 UTC [7392] ubuntu@regression ERROR: division by zero 559s 2025-02-26 13:47:58.773 UTC [7392] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 559s 2025-02-26 13:47:59.124 UTC [7472] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 559s 2025-02-26 13:47:59.124 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 559s on ddl_command_start 559s execute procedure pg_backend_pid(); 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression ERROR: trigger functions can only be called as triggers 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 559s 2025-02-26 13:47:59.125 UTC [7472] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 559s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 559s 2025-02-26 13:47:59.126 UTC [7472] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 559s 2025-02-26 13:47:59.126 UTC [7472] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 559s SELECT 1 $$ language sql; 559s 2025-02-26 13:47:59.126 UTC [7472] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 559s 2025-02-26 13:47:59.126 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: unrecognized filter variable "food" 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when food in ('sandwich') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('sandwich') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('create table', 'create skunkcabbage') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('DROP EVENT TRIGGER') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('CREATE ROLE') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('CREATE DATABASE') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('CREATE TABLESPACE') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: filter variable "tag" specified more than once 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s when tag in ('create table') and tag in ('CREATE FUNCTION') 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 559s 2025-02-26 13:47:59.127 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 559s execute procedure test_event_trigger('argument not allowed'); 559s 2025-02-26 13:47:59.128 UTC [7472] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 559s 2025-02-26 13:47:59.128 UTC [7472] ubuntu@regression HINT: Must be superuser to create an event trigger. 559s 2025-02-26 13:47:59.128 UTC [7472] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 559s execute procedure test_event_trigger(); 559s 2025-02-26 13:47:59.136 UTC [7472] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 559s 2025-02-26 13:47:59.136 UTC [7472] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 559s 2025-02-26 13:47:59.136 UTC [7472] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 559s owner of user mapping for regress_evt_user on server useless_server 559s owner of default privileges on new relations belonging to role regress_evt_user 559s 2025-02-26 13:47:59.137 UTC [7472] ubuntu@regression STATEMENT: drop role regress_evt_user; 560s 2025-02-26 13:47:59.151 UTC [7472] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 560s 2025-02-26 13:47:59.151 UTC [7472] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 560s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 560s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 560s 2025-02-26 13:47:59.151 UTC [7472] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 560s 2025-02-26 13:47:59.154 UTC [7472] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 560s 2025-02-26 13:47:59.154 UTC [7472] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 560s 2025-02-26 13:47:59.154 UTC [7472] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 560s 2025-02-26 13:47:59.181 UTC [7472] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 560s 2025-02-26 13:47:59.181 UTC [7472] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 560s 2025-02-26 13:47:59.189 UTC [7472] ubuntu@regression ERROR: rewrites not allowed 560s 2025-02-26 13:47:59.189 UTC [7472] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 560s 2025-02-26 13:47:59.189 UTC [7472] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 560s 2025-02-26 13:47:59.204 UTC [7472] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 560s 2025-02-26 13:47:59.204 UTC [7472] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 560s 2025-02-26 13:47:59.891 UTC [7481] ubuntu@regression LOG: wait_for_stats delayed 0.520187 seconds 560s 2025-02-26 13:47:59.891 UTC [7481] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 560s 2025-02-26 13:47:59.891 UTC [7481] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 560s Dropping cluster 12/regress ... 560s diff -U3 /tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/expected/timestamptz.out /tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/results/timestamptz.out 560s --- /tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:41:03.000000000 +0000 560s +++ /tmp/autopkgtest.4btPsT/build.0y8/src/src/test/regress/results/timestamptz.out 2025-02-26 13:47:37.935935880 +0000 560s @@ -2060,7 +2060,7 @@ 560s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 560s timezone 560s -------------------------- 560s - Wed Dec 09 15:56:00 1846 560s + Wed Dec 09 15:56:08 1846 560s (1 row) 560s 560s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 560s + cat regression.diffs 560s + exit 1 560s autopkgtest [13:48:00]: test installcheck: -----------------------] 561s autopkgtest [13:48:01]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 561s installcheck FAIL non-zero exit status 1 561s autopkgtest [13:48:01]: @@@@@@@@@@@@@@@@@@@@ summary 561s run-testsuite PASS 561s installcheck FAIL non-zero exit status 1 566s nova [W] Using flock in prodstack6-ppc64el 566s Creating nova instance adt-focal-ppc64el-postgresql-12-20250226-133840-juju-7f2275-prod-proposed-migration-environment-2-650c6102-816f-4ce1-94a1-612799d31590 from image adt/ubuntu-focal-ppc64el-server-20250226.img (UUID 429c3516-bbfa-4b5f-adb7-1b238c471c90)... 566s nova [W] Timed out waiting for b96781e2-5ebe-42a4-994d-7bb87c63b578 to get deleted. 566s nova [W] Using flock in prodstack6-ppc64el 566s Creating nova instance adt-focal-ppc64el-postgresql-12-20250226-133840-juju-7f2275-prod-proposed-migration-environment-2-650c6102-816f-4ce1-94a1-612799d31590 from image adt/ubuntu-focal-ppc64el-server-20250226.img (UUID 429c3516-bbfa-4b5f-adb7-1b238c471c90)... 566s nova [W] Timed out waiting for 270fe43d-979a-47a4-81ba-41b6ae3a4eda to get deleted.