0s autopkgtest [09:28:32]: starting date and time: 2025-03-28 09:28:32+0000 1s autopkgtest [09:28:33]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [09:28:33]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.6_0aiwys/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata,src:postgresql-12 --apt-upgrade postgresql-12 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=tzdata/2025b-0ubuntu0.20.04 postgresql-12/12.22-0ubuntu0.20.04.3' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-29.secgroup --name adt-focal-amd64-postgresql-12-20250328-092832-juju-7f2275-prod-proposed-migration-environment-20-0b202394-55bc-4d7d-a55f-f411b651bf85 --image adt/ubuntu-focal-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-amd64 -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/ 56s autopkgtest [09:29:28]: testbed dpkg architecture: amd64 56s autopkgtest [09:29:28]: testbed apt version: 2.0.10 57s autopkgtest [09:29:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 57s autopkgtest [09:29:29]: testbed release detected to be: None 57s autopkgtest [09:29:29]: updating testbed package index (apt update) 58s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 58s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 58s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 58s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 58s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 58s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.2 kB] 58s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 59s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [365 kB] 59s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [81.8 kB] 59s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1648 B] 59s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [574 kB] 59s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [1524 B] 59s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 59s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [30.5 kB] 59s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [48.4 kB] 59s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 59s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 59s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [1020 B] 59s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 60s Fetched 1467 kB in 1s (1395 kB/s) 61s Reading package lists... 62s autopkgtest [09:29:34]: upgrading testbed (apt dist-upgrade and autopurge) 62s Reading package lists... 62s Building dependency tree... 62s Reading state information... 62s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 62s Starting 2 pkgProblemResolver with broken count: 0 62s Done 62s 62s The following packages will be upgraded: 62s tzdata 63s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 63s Need to get 300 kB of archives. 63s After this operation, 12.3 kB of additional disk space will be used. 63s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 tzdata all 2025b-0ubuntu0.20.04 [300 kB] 63s Preconfiguring packages ... 63s Fetched 300 kB in 0s (703 kB/s) 63s (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 ... 66346 files and directories currently installed.) 63s Preparing to unpack .../tzdata_2025b-0ubuntu0.20.04_all.deb ... 63s Unpacking tzdata (2025b-0ubuntu0.20.04) over (2025a-0ubuntu0.20.04) ... 64s Setting up tzdata (2025b-0ubuntu0.20.04) ... 64s 64s Current default time zone: 'Etc/UTC' 64s Local time is now: Fri Mar 28 09:29:36 UTC 2025. 64s Universal Time is now: Fri Mar 28 09:29:36 UTC 2025. 64s Run 'dpkg-reconfigure tzdata' if you wish to change it. 64s 64s Reading package lists... 65s Building dependency tree... 65s Reading state information... 65s Starting pkgProblemResolver with broken count: 0 65s Starting 2 pkgProblemResolver with broken count: 0 65s Done 65s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 67s autopkgtest [09:29:39]: testbed running kernel: Linux 5.4.0-211-generic #231-Ubuntu SMP Tue Mar 11 17:06:58 UTC 2025 67s autopkgtest [09:29:39]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-12 77s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main postgresql-12 12.22-0ubuntu0.20.04.3 (dsc) [3764 B] 77s Get:2 http://ftpmaster.internal/ubuntu focal-proposed/main postgresql-12 12.22-0ubuntu0.20.04.3 (tar) [27.9 MB] 77s Get:3 http://ftpmaster.internal/ubuntu focal-proposed/main postgresql-12 12.22-0ubuntu0.20.04.3 (diff) [51.6 kB] 77s gpgv: Signature made Fri Mar 21 21:36:19 2025 UTC 77s gpgv: using RSA key A62D2CFBD50B9B5BF360D54B159EB5C4EFC8774C 77s gpgv: Can't check signature: No public key 77s dpkg-source: warning: failed to verify signature on ./postgresql-12_12.22-0ubuntu0.20.04.3.dsc 78s autopkgtest [09:29:50]: testing package postgresql-12 version 12.22-0ubuntu0.20.04.3 80s autopkgtest [09:29:52]: build not needed 87s autopkgtest [09:29:59]: test run-testsuite: preparing testbed 87s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s Starting pkgProblemResolver with broken count: 0 88s Starting 2 pkgProblemResolver with broken count: 0 88s Done 88s The following NEW packages will be installed: 88s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 88s emacsen-common g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us lib32gcc-s1 88s lib32stdc++6 libasan5 libatomic1 libc-dev-bin libc6-dev libc6-i386 libcc1-0 88s libclang-common-10-dev libclang-cpp10 libclang1-10 libcrypt-dev 88s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1c2 libgcc-9-dev 88s libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 libncurses-dev 88s libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.8 88s libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 libubsan1 88s libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 88s llvm-10-runtime llvm-10-tools net-tools postgresql-12 postgresql-client-12 88s postgresql-client-common postgresql-common postgresql-doc-12 88s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 88s postgresql-server-dev-12 python3-pygments ssl-cert 88s 0 upgraded, 71 newly installed, 0 to remove and 0 not upgraded. 88s Need to get 143 MB of archives. 88s After this operation, 753 MB of additional disk space will be used. 88s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 88s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 88s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-211.231 [1116 kB] 89s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 89s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 89s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 89s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 89s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 89s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 89s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 89s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 89s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 89s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 89s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 89s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 89s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 89s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 89s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 89s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 89s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 89s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 89s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 89s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 89s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 90s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 90s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 90s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 91s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 91s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 91s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 91s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 91s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 92s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 92s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 92s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 92s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 92s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 92s Get:38 http://ftpmaster.internal/ubuntu focal/main amd64 emacsen-common all 3.0.4 [14.9 kB] 92s Get:39 http://ftpmaster.internal/ubuntu focal/main amd64 dictionaries-common all 1.28.1 [178 kB] 92s Get:40 http://ftpmaster.internal/ubuntu focal/main amd64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 92s Get:41 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.3 [45.7 kB] 92s Get:42 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 92s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.3 [43.4 kB] 92s Get:44 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.3 [12.7 kB] 92s Get:45 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.3 [138 kB] 92s Get:46 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.3 [239 kB] 92s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 92s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.18 [1625 kB] 92s Get:49 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 92s Get:50 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 92s Get:51 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 92s Get:52 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 92s Get:53 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 92s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 93s Get:55 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 93s Get:56 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 93s Get:57 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 93s Get:58 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 93s Get:59 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 93s Get:60 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 94s Get:61 http://ftpmaster.internal/ubuntu focal/main amd64 net-tools amd64 1.60+git20180626.aebd88e-1ubuntu1 [196 kB] 94s Get:62 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 94s Get:63 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 94s Get:64 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 94s Get:65 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 94s Get:66 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 95s Get:67 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.3 [1949 kB] 95s Get:68 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.3 [68.6 kB] 95s Get:69 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.3 [76.5 kB] 95s Get:70 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.3 [31.6 kB] 95s Get:71 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.3 [995 kB] 96s Preconfiguring packages ... 96s Fetched 143 MB in 7s (20.6 MB/s) 96s Selecting previously unselected package binfmt-support. 96s (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 ... 66349 files and directories currently installed.) 96s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 96s Unpacking binfmt-support (2.2.0-2) ... 96s Selecting previously unselected package libc-dev-bin. 96s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 96s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 96s Selecting previously unselected package linux-libc-dev:amd64. 96s Preparing to unpack .../02-linux-libc-dev_5.4.0-211.231_amd64.deb ... 96s Unpacking linux-libc-dev:amd64 (5.4.0-211.231) ... 96s Selecting previously unselected package libcrypt-dev:amd64. 96s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 96s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 96s Selecting previously unselected package libc6-dev:amd64. 96s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 96s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 96s Selecting previously unselected package gcc-9-base:amd64. 96s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 96s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 96s Selecting previously unselected package libisl22:amd64. 96s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 96s Unpacking libisl22:amd64 (0.22.1-1) ... 96s Selecting previously unselected package libmpc3:amd64. 96s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 96s Unpacking libmpc3:amd64 (1.1.0-1) ... 96s Selecting previously unselected package cpp-9. 96s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 96s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 97s Selecting previously unselected package cpp. 97s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 97s Unpacking cpp (4:9.3.0-1ubuntu2) ... 97s Selecting previously unselected package libcc1-0:amd64. 97s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libgomp1:amd64. 97s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libitm1:amd64. 97s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libatomic1:amd64. 97s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libasan5:amd64. 97s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 97s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 97s Selecting previously unselected package liblsan0:amd64. 97s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libtsan0:amd64. 97s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 97s Selecting previously unselected package libubsan1:amd64. 97s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 97s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 98s Selecting previously unselected package libquadmath0:amd64. 98s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 98s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 98s Selecting previously unselected package libgcc-9-dev:amd64. 98s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 98s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 98s Selecting previously unselected package gcc-9. 98s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 98s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 98s Selecting previously unselected package gcc. 98s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 98s Unpacking gcc (4:9.3.0-1ubuntu2) ... 98s Selecting previously unselected package libstdc++-9-dev:amd64. 98s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 99s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 99s Selecting previously unselected package g++-9. 99s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 99s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 99s Selecting previously unselected package g++. 99s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 99s Unpacking g++ (4:9.3.0-1ubuntu2) ... 99s Selecting previously unselected package build-essential. 99s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 99s Unpacking build-essential (12.8ubuntu1.1) ... 99s Selecting previously unselected package libllvm10:amd64. 99s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 99s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 101s Selecting previously unselected package libclang-cpp10. 101s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 101s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 102s Selecting previously unselected package libgc1c2:amd64. 102s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 102s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 102s Selecting previously unselected package libobjc4:amd64. 102s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 102s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 102s Selecting previously unselected package libobjc-9-dev:amd64. 102s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 102s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 102s Selecting previously unselected package libc6-i386. 102s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 102s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 102s Selecting previously unselected package lib32gcc-s1. 102s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 102s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 102s Selecting previously unselected package lib32stdc++6. 102s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 102s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 102s Selecting previously unselected package libclang-common-10-dev. 102s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 102s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 102s Selecting previously unselected package libclang1-10. 102s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 102s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 103s Selecting previously unselected package clang-10. 103s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 103s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 103s Selecting previously unselected package emacsen-common. 103s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 103s Unpacking emacsen-common (3.0.4) ... 103s Selecting previously unselected package dictionaries-common. 103s Preparing to unpack .../38-dictionaries-common_1.28.1_all.deb ... 103s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 103s Unpacking dictionaries-common (1.28.1) ... 103s Selecting previously unselected package hunspell-en-us. 103s Preparing to unpack .../39-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 103s Unpacking hunspell-en-us (1:2018.04.16-1) ... 103s Selecting previously unselected package libpgtypes3:amd64. 103s Preparing to unpack .../40-libpgtypes3_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libpq5:amd64. 103s Preparing to unpack .../41-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libecpg6:amd64. 103s Preparing to unpack .../42-libecpg6_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libecpg-compat3:amd64. 103s Preparing to unpack .../43-libecpg-compat3_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libpq-dev. 103s Preparing to unpack .../44-libpq-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libecpg-dev. 103s Preparing to unpack .../45-libecpg-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 103s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 103s Selecting previously unselected package libncurses-dev:amd64. 103s Preparing to unpack .../46-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 103s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 104s Selecting previously unselected package libpython3.8:amd64. 104s Preparing to unpack .../47-libpython3.8_3.8.10-0ubuntu1~20.04.18_amd64.deb ... 104s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 104s Selecting previously unselected package libtcl8.6:amd64. 104s Preparing to unpack .../48-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 104s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 104s Selecting previously unselected package libtinfo-dev:amd64. 104s Preparing to unpack .../49-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 104s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 104s Selecting previously unselected package libxslt1.1:amd64. 104s Preparing to unpack .../50-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 104s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 104s Selecting previously unselected package llvm-10-runtime. 104s Preparing to unpack .../51-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 104s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 104s Selecting previously unselected package libpfm4:amd64. 104s Preparing to unpack .../52-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 104s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 104s Selecting previously unselected package llvm-10. 104s Preparing to unpack .../53-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 104s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 104s Selecting previously unselected package libffi-dev:amd64. 104s Preparing to unpack .../54-libffi-dev_3.3-4_amd64.deb ... 104s Unpacking libffi-dev:amd64 (3.3-4) ... 104s Selecting previously unselected package python3-pygments. 104s Preparing to unpack .../55-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 104s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 104s Selecting previously unselected package llvm-10-tools. 104s Preparing to unpack .../56-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 104s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 104s Selecting previously unselected package libz3-4:amd64. 104s Preparing to unpack .../57-libz3-4_4.8.7-4build1_amd64.deb ... 104s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 105s Selecting previously unselected package libz3-dev:amd64. 105s Preparing to unpack .../58-libz3-dev_4.8.7-4build1_amd64.deb ... 105s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 105s Selecting previously unselected package llvm-10-dev. 105s Preparing to unpack .../59-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 105s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 107s Selecting previously unselected package net-tools. 107s Preparing to unpack .../60-net-tools_1.60+git20180626.aebd88e-1ubuntu1_amd64.deb ... 107s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 107s Selecting previously unselected package postgresql-client-common. 107s Preparing to unpack .../61-postgresql-client-common_214ubuntu0.1_all.deb ... 107s Unpacking postgresql-client-common (214ubuntu0.1) ... 107s Selecting previously unselected package postgresql-client-12. 107s Preparing to unpack .../62-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 107s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 107s Selecting previously unselected package ssl-cert. 107s Preparing to unpack .../63-ssl-cert_1.0.39_all.deb ... 107s Unpacking ssl-cert (1.0.39) ... 107s Selecting previously unselected package postgresql-common. 107s Preparing to unpack .../64-postgresql-common_214ubuntu0.1_all.deb ... 107s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 107s Unpacking postgresql-common (214ubuntu0.1) ... 107s Selecting previously unselected package postgresql-12. 107s Preparing to unpack .../65-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 107s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 111s Selecting previously unselected package postgresql-doc-12. 111s Preparing to unpack .../66-postgresql-doc-12_12.22-0ubuntu0.20.04.3_all.deb ... 111s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.3) ... 111s Selecting previously unselected package postgresql-plperl-12. 111s Preparing to unpack .../67-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 111s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 111s Selecting previously unselected package postgresql-plpython3-12. 111s Preparing to unpack .../68-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 111s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 111s Selecting previously unselected package postgresql-pltcl-12. 111s Preparing to unpack .../69-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 111s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 111s Selecting previously unselected package postgresql-server-dev-12. 111s Preparing to unpack .../70-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 111s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 111s Setting up postgresql-client-common (214ubuntu0.1) ... 111s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 111s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 111s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 111s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 111s Setting up linux-libc-dev:amd64 (5.4.0-211.231) ... 111s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 111s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 111s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 111s Setting up libffi-dev:amd64 (3.3-4) ... 111s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.3) ... 111s 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 111s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 111s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 112s Setting up libz3-4:amd64 (4.8.7-4build1) ... 112s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 112s 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 112s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 112s Setting up emacsen-common (3.0.4) ... 112s Setting up ssl-cert (1.0.39) ... 112s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 112s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 112s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 112s Setting up postgresql-common (214ubuntu0.1) ... 112s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 112s Adding user postgres to group ssl-cert 112s 112s Creating config file /etc/postgresql-common/createcluster.conf with new version 112s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 112s en_us 112s Removing obsolete dictionary files: 113s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 113s Setting up libmpc3:amd64 (1.1.0-1) ... 113s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 113s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 113s Setting up binfmt-support (2.2.0-2) ... 113s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 115s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 115s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 115s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 115s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 115s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 115s Setting up libisl22:amd64 (0.22.1-1) ... 115s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 115s Creating new PostgreSQL cluster 12/main ... 115s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 115s The files belonging to this database system will be owned by user "postgres". 115s This user must also own the server process. 115s 115s The database cluster will be initialized with locale "C.UTF-8". 115s The default database encoding has accordingly been set to "UTF8". 115s The default text search configuration will be set to "english". 115s 115s Data page checksums are disabled. 115s 115s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 115s creating subdirectories ... ok 115s selecting dynamic shared memory implementation ... posix 115s selecting default max_connections ... 100 115s selecting default shared_buffers ... 128MB 115s selecting default time zone ... Etc/UTC 115s creating configuration files ... ok 115s running bootstrap script ... ok 115s performing post-bootstrap initialization ... ok 115s syncing data to disk ... ok 115s 115s Success. You can now start the database server using: 115s 115s pg_ctlcluster 12 main start 115s 115s Ver Cluster Port Status Owner Data directory Log file 115s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 115s 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 118s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 118s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 118s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 118s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 118s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 118s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 118s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 118s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 118s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 118s Setting up dictionaries-common (1.28.1) ... 118s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 118s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 118s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 118s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 118s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 118s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 118s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 118s Setting up hunspell-en-us (1:2018.04.16-1) ... 118s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 118s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 118s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 118s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 118s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 118s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up cpp (4:9.3.0-1ubuntu2) ... 118s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 118s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up gcc (4:9.3.0-1ubuntu2) ... 118s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 118s Setting up g++ (4:9.3.0-1ubuntu2) ... 118s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 118s Setting up build-essential (12.8ubuntu1.1) ... 118s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 118s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 118s Processing triggers for systemd (245.4-4ubuntu3.24) ... 118s Processing triggers for man-db (2.9.1-1) ... 121s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 121s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 121s Processing triggers for dictionaries-common (1.28.1) ... 124s autopkgtest [09:30:36]: test run-testsuite: [----------------------- 124s Generating locales (this might take a while)... 126s en_US.UTF-8... done 126s ru_RU.ISO-8859-5... done 127s ru_RU.UTF-8... done 127s Generation complete. 127s ====== Running all tests with umask 077 ======= 127s === Running test 001_packages.t ... === 127s 1..18 127s # PostgreSQL versions installed: 12 127s ok 1 - postgresql-12 installed 127s ok 2 # skip No python2 support 127s ok 3 - postgresql-plpython3-12 installed 127s ok 4 - postgresql-plperl-12 installed 127s ok 5 - postgresql-pltcl-12 installed 127s ok 6 - postgresql-server-dev-12 installed 127s ok 7 # skip No postgresql-contrib-12 package for version 12 127s ok 8 - libecpg-dev installed 127s ok 9 - procps installed 127s ok 10 - netcat-openbsd installed 127s ok 11 - hunspell-en-us installed 127s ok 12 - system has a default UTF-8 locale 127s ok 13 - locale ru_RU exists 127s ok 14 - locale ru_RU.UTF-8 exists 127s ok 15 - user postgres in the UNIX group ssl-cert 127s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 127s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 127s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 127s === Running test 002_existing_clusters.t ... === 128s 1..8 128s ok 1 - Cleanup: No clusters left behind 128s ok 2 - No postgres processes left behind 128s ok 3 - No files in /etc/postgresql left behind 128s ok 4 - No files in /var/lib/postgresql left behind 128s ok 5 - No files in /var/run/postgresql left behind 128s ok 6 - No files in /var/log/postgresql left behind 128s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 128s ok 8 - PostgreSQL TCP ports are closed 128s === Running test 003_package_checks.t ... === 128s 1..4 128s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 128s ok 2 - psql is linked against libedit 128s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 128s ok 4 - psql is not linked against libreadline 128s === Running test 005_PgCommon.t ... === 128s 1..24 128s ok 1 - correctly parsed line 'local all postgres ident sameuser' 128s ok 2 - correctly parsed line 'local foo nobody trust' 128s ok 3 - correctly parsed line 'local foo nobody crypt' 128s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 128s ok 5 - correctly parsed line 'local foo,bar nobody ident' 128s ok 6 - correctly parsed line 'local all +foogrp password' 128s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 128s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 128s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 128s ok 10 - @expected_records has correct number of entries 128s ok 11 - returned read_pg_hba array has correct number of records 128s ok 12 - line 'foo all all md5' parsed as invalid 128s ok 13 - line 'local all all foo' parsed as invalid 128s ok 14 - line 'host all all foo' parsed as invalid 128s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 128s ok 16 - line 'host all all md5' parsed as invalid 128s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 128s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 128s ok 19 - read_conf_file returns empty dict for nonexisting file 128s ok 20 - read_conf_file() parsing 128s ok 21 - read_conf_file() parsing with include directives 128s ok 22 - set_conf_value 128s ok 23 - disable_conf_value 128s ok 24 - replace_conf_value 128s === Running test 006_next_free_port.t ... === 128s 1..5 128s ok 1 - next_free_port is 5432 129s ok 2 - next_free_port detects localhost ipv4 socket 129s ok 3 - next_free_port detects wildcard ipv4 socket 130s ok 4 - next_free_port detects localhost ipv6 socket 130s ok 5 - next_free_port detects wildcard ipv6 socket 130s === Running test 007_pg_conftool.t ... === 130s 1..41 130s # test without cluster 130s ok 1 - pg_conftool show all 130s ok 2 - correct output of pg_conftool show all 130s ok 3 - pg_conftool foo.conf show all 130s ok 4 - correct output of pg_conftool foo.conf show all 130s ok 5 - pg_conftool /tmp/Pp6qJ1fywd/different.conf show all 130s ok 6 - correct output of pg_conftool /tmp/Pp6qJ1fywd/different.conf show all 130s ok 7 - pg_conftool 9.7 main show all 130s ok 8 - correct output of pg_conftool 9.7 main show all 130s # test show 131s ok 9 - pg_conftool show all 131s ok 10 - correct output of pg_conftool show all 131s ok 11 - pg_conftool other.conf show all 131s ok 12 - correct output of pg_conftool other.conf show all 131s ok 13 - pg_conftool /tmp/Pp6qJ1fywd/different.conf show all 131s ok 14 - correct output of pg_conftool /tmp/Pp6qJ1fywd/different.conf show all 131s ok 15 - pg_conftool 12 main show all 131s ok 16 - correct output of pg_conftool 12 main show all 131s ok 17 - pg_conftool 12 main other.conf show all 131s ok 18 - correct output of pg_conftool 12 main other.conf show all 131s ok 19 - pg_conftool show a 131s ok 20 - correct output of pg_conftool show a 131s ok 21 - pg_conftool -s show a 131s ok 22 - correct output of pg_conftool -s show a 131s # test set 131s ok 23 - pg_conftool set c 7 131s ok 24 - correct output of pg_conftool set c 7 131s ok 25 - file contains new setting 131s ok 26 - pg_conftool set a 8 131s ok 27 - correct output of pg_conftool set a 8 131s ok 28 - file contains updated setting 131s ok 29 - pg_conftool /tmp/Pp6qJ1fywd/different.conf set a 9 131s ok 30 - correct output of pg_conftool /tmp/Pp6qJ1fywd/different.conf set a 9 131s ok 31 - file with path contains updated setting 131s # test remove 131s ok 32 - pg_conftool remove a 131s ok 33 - correct output of pg_conftool remove a 131s ok 34 - setting removed from file 131s ok 35 - pg_conftool /tmp/Pp6qJ1fywd/different.conf remove a 131s ok 36 - correct output of pg_conftool /tmp/Pp6qJ1fywd/different.conf remove a 131s ok 37 - setting removed from file with path 131s # test edit 131s ok 38 - pg_conftool edit 131s ok 39 - correct output of pg_conftool edit 131s ok 40 - pg_conftool /tmp/Pp6qJ1fywd/different.conf edit 131s ok 41 - correct output of pg_conftool /tmp/Pp6qJ1fywd/different.conf edit 131s === Running test 010_defaultport_cluster.t ... === 131s 1..14 131s ok 1 - psql --version 131s ok 2 - pg_wrapper selects highest available version number 131s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 131s ok 4 - connecting to localhost fails with no clusters 131s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 131s ok 6 - pg_wrapper uses host and port from PGCLUSTER 131s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 131s ok 8 - pg_wrapper uses --cluster from the command line 131s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 131s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 131s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 131s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 131s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 131s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 131s === Running test 015_start_stop.t ... === 131s 1..71 131s # We are running systemd 131s # Running tests for 12 131s # Cluster does not exist yet 131s ok 1 - cluster 12 main does not exist 131s ok 2 - service postgresql@12-main does not exist 131s ok 3 - systemctl start postgresql 131s ok 4 - cluster 12 main does not exist 131s ok 5 - service postgresql@12-main does not exist 131s ok 6 - systemctl start postgresql@12-main 131s ok 7 - cluster 12 main does not exist 131s ok 8 - service postgresql@12-main does not exist 131s # Start/stop postgresql using system tools 132s ok 9 - pg_createcluster 12 main 132s ok 10 - cluster 12 main is stopped 132s ok 11 - service postgresql@12-main is stopped 134s ok 12 - systemctl start postgresql 134s ok 13 - cluster 12 main is running 134s ok 14 - service postgresql@12-main is running 134s ok 15 - systemctl start postgresql 134s ok 16 - cluster 12 main is already running 134s ok 17 - service postgresql@12-main is already running 134s ok 18 - systemctl stop postgresql 140s ok 19 - cluster 12 main is stopped 140s ok 20 - service postgresql@12-main is stopped 140s ok 21 - systemctl stop postgresql 140s ok 22 - cluster 12 main is already stopped 140s ok 23 - service postgresql@12-main is already stopped 140s # Start/stop specific cluster using system tools 143s ok 24 - systemctl start postgresql@12-main 143s ok 25 - cluster 12 main is running 143s ok 26 - service postgresql@12-main is running 143s ok 27 - systemctl start postgresql@12-main 143s ok 28 - cluster 12 main is running 143s ok 29 - service postgresql@12-main is running 145s ok 30 - systemctl restart postgresql@12-main 145s ok 31 - cluster 12 main is running 145s ok 32 - service postgresql@12-main is running 145s ok 33 - systemctl stop postgresql@12-main 145s ok 34 - cluster 12 main is stopped 145s ok 35 - service postgresql@12-main is stopped 145s ok 36 - systemctl stop postgresql@12-main 145s ok 37 - cluster 12 main is already stopped 145s ok 38 - service postgresql@12-main is already stopped 146s ok 39 - pg_dropcluster 12 main 146s ok 40 - cluster 12 main does not exist 146s ok 41 - service postgresql@12-main does not exist 146s # Start/stop specific cluster using pg_*cluster 146s ok 42 - pg_ctlcluster start 12 main 146s ok 43 - cluster 12 main does not exist 146s ok 44 - service postgresql@12-main does not exist 149s ok 45 - pg_createcluster 12 main --start 149s ok 46 - cluster 12 main is running 149s ok 47 - service postgresql@12-main is running 149s ok 48 - pg_ctlcluster 12 main start 149s ok 49 - cluster 12 main is already running 149s ok 50 - service postgresql@12-main is already running 151s ok 51 - pg_ctlcluster 12-main restart 151s ok 52 - cluster 12 main is running 151s ok 53 - service postgresql@12-main is running 152s ok 54 - pg_ctlcluster 12 main stop 152s ok 55 - cluster 12 main is stopped 152s ok 56 - service postgresql@12-main is stopped 152s ok 57 - pg_ctlcluster 12 main stop 152s ok 58 - cluster 12 main is already stopped 152s ok 59 - service postgresql@12-main is already stopped 154s ok 60 - pg_ctlcluster start 12-main 154s ok 61 - cluster 12 main is running 154s ok 62 - service postgresql@12-main is running 154s ok 63 - pg_dropcluster 12 main --stop 155s ok 64 - Cleanup: No clusters left behind 155s ok 65 - No postgres processes left behind 155s ok 66 - No files in /etc/postgresql left behind 155s ok 67 - No files in /var/lib/postgresql left behind 155s ok 68 - No files in /var/run/postgresql left behind 155s ok 69 - No files in /var/log/postgresql left behind 155s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 155s ok 71 - PostgreSQL TCP ports are closed 155s === Running test 020_create_sql_remove.t ... === 155s 1..144 155s # Running tests for 12 158s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog._trNr8 158s ok 2 - pg_createcluster 12 main 158s ok 3 - Socket and pid file are in /var/run/postgresql/ 158s ok 4 - xlog/wal directory /tmp/12.xlog._trNr8 was created 158s ok 5 - Exactly one postgres master process running 160s ok 6 - pg_ctlcluster 12 main restart 160s ok 7 - cluster restarts with new environment file 160s ok 8 - Exactly one postgres master process running 160s ok 9 - correct value of PGEXTRAVAR1 in environment 160s ok 10 - correct value of PGEXTRAVAR2 in environment 160s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 160s ok 12 - createdb --version 160s ok 13 - pg_wrapper selects version number of cluster 160s ok 14 - psql --version 160s ok 15 - pg_wrapper selects version number of cluster 160s ok 16 - pg_lscluster reports online cluster on port 5432 160s ok 17 - log file is actually used 160s ok 18 - /etc/postgresql is owned by user "postgres" 160s ok 19 - version configuration directory file is owned by user "postgres" 160s ok 20 - configuration directory file is owned by user "postgres" 160s ok 21 - version data directory file is owned by user "postgres" 160s ok 22 - data directory file is owned by user "postgres" 160s ok 23 - log file has 0640 permissions 160s ok 24 - log file is owned by user "postgres" 160s ok 25 - log file is owned by group "adm" 160s ok 26 - no log symlink by default 160s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 160s ok 28 - pg_lsclusters -h 160s ok 29 - correct output of pg_lsclusters -h 160s ok 30 - stopping cluster 162s ok 31 - restarting cluster with nondefault log symlink 162s ok 32 - log target is used as log file 162s ok 33 - default log is not used 162s ok 34 - pg_lsclusters -h 162s ok 35 - correct output of pg_lsclusters -h 163s ok 36 - stopping cluster 165s ok 37 - restarting cluster with explicitly configured log file 165s ok 38 - default log is not used 165s ok 39 - log symlink target is used for startup message 165s ok 40 - exactly one log file 165s ok 41 - custom log is actually used 165s ok 42 - pg_lsclusters -h 165s ok 43 - correct output of pg_lsclusters -h 165s ok 44 - stopping cluster 165s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 165s ok 46 - /etc/postgres-hack was not created 167s ok 47 - restarting cluster 167s ok 48 - ps -o tty -U postgres h 167s ok 49 - postgres processes do not have an associated terminal 167s ok 50 - SSL is enabled 167s ok 51 - psql -l fails for nobody 167s ok 52 - createuser nobody 167s ok 53 - createdb nobodydb 167s ok 54 - psql -ltA succeeds for nobody 167s ok 55 - psql -ltA output 167s ok 56 - SQL command: create table 167s ok 57 - SQL command: insert into table values 167s ok 58 - SQL command: insert into table values 167s ok 59 - primary key violation 168s ok 60 - psql -tAc "select * from phone order by name" nobodydb 168s ok 61 - SQL command output: select -tA 168s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 168s ok 63 - SQL command output: select -tx 168s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 168s ok 65 - SQL command output: select -tAx 168s ok 66 - CREATE EXTENSION plperlu fails for user nobody 168s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 168s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 168s ok 69 - creating PL/PerlU function as user nobody fails 168s ok 70 - creating unsafe PL/Perl function as user postgres fails 168s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 168s ok 72 - creating PL/PerlU function as user postgres succeeds 168s ok 73 - psql nobodydb -Atc "select read_file()" 168s ok 74 - calling PL/PerlU function 168s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 168s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 168s ok 77 - creating unsafe PL/Perl function as user nobody fails 168s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 168s ok 79 - creating PL/Perl function as user nobody succeeds 168s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 168s ok 81 - calling PL/Perl function 168s ok 82 # skip No python2 support 168s ok 83 # skip No python2 support 168s ok 84 # skip No python2 support 168s ok 85 # skip No python2 support 168s ok 86 # skip No python2 support 168s ok 87 # skip No python2 support 168s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 168s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 168s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 168s ok 91 - creating PL/Python3 function as user postgres succeeds 168s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 168s ok 93 - calling PL/Python function 168s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 168s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 168s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 168s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 168s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 168s ok 99 - creating PL/Tcl function as user nobody succeeds 168s 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;" 168s ok 101 - creating PL/TclU function as user postgres succeeds 168s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 168s ok 103 - calling PL/Tcl function 168s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 168s ok 105 - calling PL/TclU function 169s ok 106 - stopping cluster 169s ok 107 - pg_ctlcluster 12 main start 169s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 171s ok 109 - pg_ctlcluster 12 main start 171s ok 110 - cluster restarts with pgdata symlink 171s ok 111 - postgres master has OOM killer protection 171s ok 112 - postgres client backend has no OOM adjustment 171s ok 113 - ps h 8367 171s ok 114 - process title is idle 172s ok 115 - ps h 8367 172s ok 116 - process title is idle in transaction 172s ok 117 - ps h 8367 172s ok 118 - process title is SELECT 174s ok 119 - dropdb nobodydb 174s ok 120 - dropuser nobody 175s ok 121 - stopping cluster 177s ok 122 - starting cluster as postgres works without a log file 177s ok 123 - log file got recreated and used 177s ok 124 - creating a directory in spc2 177s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.2yl9Zw'" 177s ok 126 - creating tablespace spc1 177s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 177s ok 128 - creating a table in spc1 177s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.CBNdnX'" 177s ok 130 - creating tablespace spc2 177s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 177s ok 132 - creating a table in spc2 177s ok 133 - pg_dropcluster removes cluster 177s ok 134 - xlog/wal directory /tmp/12.xlog._trNr8 was deleted 177s ok 135 - tablespace spc1 was emptied 177s ok 136 - tablespace spc2 was emptied 177s ok 137 - Cleanup: No clusters left behind 177s ok 138 - No postgres processes left behind 177s ok 139 - No files in /etc/postgresql left behind 177s ok 140 - No files in /var/lib/postgresql left behind 177s ok 141 - No files in /var/run/postgresql left behind 177s ok 142 - No files in /var/log/postgresql left behind 177s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 177s ok 144 - PostgreSQL TCP ports are closed 177s === Running test 021_pg_renamecluster.t ... === 177s 1..20 180s ok 1 - pg_createcluster 12 main 184s ok 2 - pg_renamecluster 12 main donau 184s ok 3 - psql -tAc "show data_directory" 184s ok 4 - cluster is running and data_directory was moved 184s ok 5 - pg_hba.conf location updated 184s ok 6 - pg_ident.conf location updated 184s ok 7 - external_pid_file location updated 184s ok 8 - external_pid_file exists 184s ok 9 - stats_temp_directory location updated 184s ok 10 - stats_temp_directory exists 184s ok 11 - cluster_name is updated 184s ok 12 - pg_dropcluster removes cluster 184s ok 13 - Cleanup: No clusters left behind 184s ok 14 - No postgres processes left behind 184s ok 15 - No files in /etc/postgresql left behind 184s ok 16 - No files in /var/lib/postgresql left behind 184s ok 17 - No files in /var/run/postgresql left behind 184s ok 18 - No files in /var/log/postgresql left behind 184s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 184s ok 20 - PostgreSQL TCP ports are closed 184s === Running test 022_recovery.t ... === 184s 1..17 184s # Running tests for 12 186s ok 1 - pg_createcluster 12 main --start >/dev/null 190s ok 2 - pg_ctlcluster 12 main stop -m i 190s ok 3 - pg_ctlcluster 12 main start 190s ok 4 - psql -c '' 190s ok 5 - pg_ctlcluster 12 main stop -m i 190s ok 6 - create write-protected file in data directory 191s ok 7 - pg_ctlcluster 12 main start 191s ok 8 - psql -c '' 192s ok 9 - pg_dropcluster removes cluster 192s ok 10 - Cleanup: No clusters left behind 192s ok 11 - No postgres processes left behind 192s ok 12 - No files in /etc/postgresql left behind 192s ok 13 - No files in /var/lib/postgresql left behind 192s ok 14 - No files in /var/run/postgresql left behind 192s ok 15 - No files in /var/log/postgresql left behind 192s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 192s ok 17 - PostgreSQL TCP ports are closed 192s === Running test 025_logging.t ... === 192s 1..55 192s # Logging to /var/log/syslog works 192s # Running tests for 12 195s ok 1 - pg_createcluster 12 main 195s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 196s ok 3 - psql -qc "'foobar_12_9023'" 196s ok 4 - log an error 196s ok 5 - grep --binary-files=text foobar_12_9023 /var/log/postgresql/postgresql-12-main.log 196s ok 6 - error appears in logfile 196s ok 7 - pg_conftool 12 main set log_destination syslog 196s ok 8 - set log_destination syslog 196s ok 9 - pg_ctlcluster 12 main reload 196s ok 10 - 12 main reload 196s ok 11 - psql -Atc "show log_destination" 196s ok 12 - log_destination is syslog 196s ok 13 - pg_lscluster reports syslog 196s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 196s ok 15 - error appears in /var/log/syslog 196s ok 16 - pg_conftool 12 main set logging_collector on 196s ok 17 - set logging_collector on 196s ok 18 - pg_conftool 12 main set log_destination csvlog 196s ok 19 - set log_destination csvlog 199s ok 20 - pg_ctlcluster 12 main restart 199s ok 21 - 12 main restart 199s ok 22 - psql -Atc "show logging_collector" 199s ok 23 - logging_collector is on 199s ok 24 - psql -Atc "show log_destination" 199s ok 25 - log_destination is csvlog 199s ok 26 - pg_lscluster reports csvlog 199s ok 27 - psql -qc "'barbaz_12_9023'" 199s ok 28 - log an error 199s ok 29 - grep --binary-files=text barbaz_12_9023 /var/lib/postgresql/12/main/log/*.csv 199s ok 30 - error appears in log/*.csv 199s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 199s ok 32 - set log_destination stderr,syslog,csvlog 199s ok 33 - pg_ctlcluster 12 main reload 199s ok 34 - 12 main reload 199s ok 35 - psql -Atc "show log_destination" 199s ok 36 - log_destination is stderr,syslog,csvlog 199s ok 37 - pg_lscluster reports stderr,syslog,csvlog 199s ok 38 - psql -qc "'moo_12_9023'" 199s ok 39 - log an error 199s ok 40 - grep --binary-files=text moo_12_9023 /var/lib/postgresql/12/main/log/*.log 199s ok 41 - error appears in log/*.log 199s ok 42 - grep --binary-files=text 'postgres.*moo_12_9023' /var/log/syslog 199s ok 43 - error appears in /var/log/syslog 199s ok 44 - grep --binary-files=text moo_12_9023 /var/lib/postgresql/12/main/log/*.csv 199s ok 45 - error appears in log/*.csv 200s ok 46 - pg_dropcluster 12 main --stop 200s ok 47 - pg_dropcluster removes cluster 200s ok 48 - Cleanup: No clusters left behind 200s ok 49 - No postgres processes left behind 200s ok 50 - No files in /etc/postgresql left behind 200s ok 51 - No files in /var/lib/postgresql left behind 200s ok 52 - No files in /var/run/postgresql left behind 200s ok 53 - No files in /var/log/postgresql left behind 200s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 200s ok 55 - PostgreSQL TCP ports are closed 200s === Running test 030_errors.t ... === 200s 1..149 200s ok 1 - pg_lscluster reports cluster without binaries 200s ok 2 - pg_dropcluster 6.3 main 201s ok 3 - pg_createcluster --socketdir 201s ok 4 - pg_lsclusters -h 201s ok 5 - cluster was created 201s ok 6 - Port of created cluster is 5432 201s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 201s ok 8 - pg_createcluster on existing cluster 201s ok 9 - pg_lsclusters -h 201s ok 10 - original cluster still exists 201s ok 11 - pg_createcluster 12 test -p foo 201s ok 12 - pg_createcluster -p checks that port option is numeric 201s ok 13 - pg_createcluster 12 test -p 42 201s ok 14 - pg_createcluster -p checks valid port range 201s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 201s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 201s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 203s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 203s ok 19 - No sockets in /var/run/postgresql 203s ok 20 - Socket is in /tmp/postgresql-testsuite/ 204s ok 21 - cluster stops with custom unix_socket_dir 204s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 206s ok 23 - cluster starts after removing unix_socket_dir 206s ok 24 - Socket is in default dir /var/run/postgresql 206s ok 25 - No sockets in /tmp/postgresql-testsuite/ 206s ok 26 - pg_ctlcluster 12 main stop 206s ok 27 - pg_ctlcluster fails with corrupted PID file 206s ok 28 - pg_lsclusters -h 206s ok 29 - cluster is still online 206s ok 30 - pg_ctlcluster succeeds with restored PID file 206s ok 31 - pg_lsclusters -h 206s ok 32 - cluster is down 206s ok 33 - pg_ctlcluster 12 main stop 206s ok 34 - pg_ctlcluster stop fails on stopped cluster 208s ok 35 - pg_ctlcluster 12 main start 208s ok 36 - pg_ctlcluster succeeds with already existing PID file 208s ok 37 - pg_lsclusters -h 208s ok 38 - cluster is online 208s ok 39 - pg_ctlcluster stop succeeds 209s ok 40 - pg_lsclusters -h 209s ok 41 - cluster is down 209s ok 42 - no pid file left 209s ok 43 - pg_ctlcluster 12 main stop 209s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 209s ok 45 - pid file was cleaned up 209s ok 46 - pg_ctlcluster --force 12 main stop 209s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 209s ok 48 - pid file was cleaned up 209s ok 49 - pg_ctlcluster 12 main stop 209s ok 50 - pg_ctlcluster stop succeeds with stale PID file 209s ok 51 - pid file was cleaned up 209s ok 52 - pg_ctlcluster --force 12 main stop 209s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 209s ok 54 - pid file was cleaned up 209s ok 55 - pg_ctlcluster --force 12 main stop 209s ok 56 - pg_ctlcluster stop succeeds with empty PID file 209s ok 57 - pid file was cleaned up 211s ok 58 - pg_ctlcluster 12 main start 211s ok 59 - pg_ctlcluster succeeds with corrupted PID file 211s ok 60 - pg_lsclusters -h 211s ok 61 - cluster is online 211s ok 62 - pg_ctlcluster 12 main start 211s ok 63 - pg_ctlcluster start fails on running cluster 211s ok 64 - pg_ctlcluster stop 211s ok 65 - pg_ctlcluster 12 main start 211s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 211s ok 67 - pg_ctlcluster 12 main stop 211s ok 68 - stopping cluster 218s ok 69 - pg_ctlcluster 12 main start 218s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 218s ok 71 - pg_ctlcluster 12 main stop 218s ok 72 - stopping cluster 218s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 218s ok 74 - pg_dropcluster 12 main 218s ok 75 - pg_dropcluster works as user postgres 218s ok 76 - pg_createcluster succeeds 218s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 218s ok 78 - proper error message for nonexisting /var/lib/postgresql 221s ok 79 - pg_ctlcluster 12 main start 221s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 221s ok 81 - pg_ctlcluster 12 main stop 221s ok 82 - stopping cluster 222s ok 83 - pg_createcluster other 224s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 226s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 226s ok 86 226s ok 87 - pg_ctlcluster 12 other start 226s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 226s ok 89 - pg_ctlcluster 12 main stop 226s ok 90 - stopping main cluster 228s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 229s ok 92 - pg_dropcluster other 229s ok 93 - pg_dropcluster 229s ok 94 - No sockets any more 229s ok 95 - 'pg_lsclusters 4.5 foo' fails 229s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 229s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 229s ok 98 - 'psql --cluster 4.5/foo' fails 229s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 229s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 229s ok 101 - 'psql --cluster 12/foo' fails 229s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 229s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 229s ok 104 - 'pg_dropcluster 4.5 foo' fails 229s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 229s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 229s ok 107 - 'pg_dropcluster 12 foo' fails 229s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 229s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 229s ok 110 - 'pg_upgradecluster 4.5 foo' fails 229s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 229s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 229s ok 113 - 'pg_upgradecluster 12 foo' fails 229s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 229s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 229s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 229s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 229s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 229s ok 119 - 'pg_ctlcluster 12 foo stop' fails 229s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 229s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 229s ok 122 - Cleanup: No clusters left behind 229s ok 123 - No postgres processes left behind 229s ok 124 - No files in /etc/postgresql left behind 229s ok 125 - No files in /var/lib/postgresql left behind 229s ok 126 - No files in /var/run/postgresql left behind 229s ok 127 - No files in /var/log/postgresql left behind 229s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 229s ok 129 - PostgreSQL TCP ports are closed 229s ok 130 - pg_dropcluster 12 broken 229s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 229s ok 132 - Cleanup: No clusters left behind 229s ok 133 - No postgres processes left behind 229s ok 134 - No files in /etc/postgresql left behind 229s ok 135 - No files in /var/lib/postgresql left behind 229s ok 136 - No files in /var/run/postgresql left behind 229s ok 137 - No files in /var/log/postgresql left behind 229s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 229s ok 139 - PostgreSQL TCP ports are closed 230s ok 140 - pg_dropcluster 12 broken 230s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 230s ok 142 - Cleanup: No clusters left behind 230s ok 143 - No postgres processes left behind 230s ok 144 - No files in /etc/postgresql left behind 230s ok 145 - No files in /var/lib/postgresql left behind 230s ok 146 - No files in /var/run/postgresql left behind 230s ok 147 - No files in /var/log/postgresql left behind 230s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 230s ok 149 - PostgreSQL TCP ports are closed 230s === Running test 031_errors_disk_full.t ... === 230s 1..22 230s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 230s ok 1 - script failed 230s ok 2 - pg_createcluster fails due to insufficient disk space 230s ok 3 - does not leave files behind 230s ok 4 - Cleanup: No clusters left behind 230s ok 5 - No postgres processes left behind 230s ok 6 - No files in /etc/postgresql left behind 230s ok 7 - No files in /var/lib/postgresql left behind 230s ok 8 - No files in /var/run/postgresql left behind 230s ok 9 - No files in /var/log/postgresql left behind 230s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 230s ok 11 - PostgreSQL TCP ports are closed 230s # check disk full conditions on startup 231s ok 12 - script failed 231s ok 13 - pg_ctlcluster prints error message 231s ok 14 - log file has error message 231s ok 15 - Cleanup: No clusters left behind 231s ok 16 - No postgres processes left behind 231s ok 17 - No files in /etc/postgresql left behind 231s ok 18 - No files in /var/lib/postgresql left behind 231s ok 19 - No files in /var/run/postgresql left behind 231s ok 20 - No files in /var/log/postgresql left behind 231s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 231s ok 22 - PostgreSQL TCP ports are closed 231s === Running test 032_ssl_key_permissions.t ... === 231s 1..22 231s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 231s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 231s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 231s # 12 (12.22-0ubuntu0.20.04.3) 232s ok 4 - pg_createcluster 12 main 232s ok 5 - pg_ctlcluster 12 main start 232s ok 6 - ssl key owned by nobody refused 232s ok 7 - pg_ctlcluster 12 main start 232s ok 8 - ssl key with permissions root:root 0644 refused 232s ok 9 - pg_ctlcluster 12 main start 232s ok 10 - ssl key with permissions postgres:postgres 0640 refused 233s ok 11 - pg_dropcluster 12 main --stop 233s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 233s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 233s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 233s ok 15 - Cleanup: No clusters left behind 233s ok 16 - No postgres processes left behind 233s ok 17 - No files in /etc/postgresql left behind 233s ok 18 - No files in /var/lib/postgresql left behind 233s ok 19 - No files in /var/run/postgresql left behind 233s ok 20 - No files in /var/log/postgresql left behind 233s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 233s ok 22 - PostgreSQL TCP ports are closed 233s === Running test 040_upgrade.t ... === 233s 1..1 233s ok 1 - only one major version installed, skipping upgrade tests 233s === Running test 041_upgrade_custompaths.t ... === 233s 1..1 233s ok 1 - only one major version installed, skipping upgrade tests 233s === Running test 043_upgrade_ssl_cert.t ... === 233s 1..1 233s ok 1 - only one major version installed, skipping upgrade tests 233s === Running test 050_encodings.t ... === 233s 1..60 233s # Checking 12 ru_RU 236s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 237s ok 2 - psql -l succeeds 237s ok 3 - template1 is not UTF-8 encoded 237s ok 4 - creating test database 237s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 237s # create table t (x varchar); copy t from stdin" test 237s ok 6 - creating table with ISO-8859-5 characters 237s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 237s ok 8 - correct string in UTF-8 237s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 237s ok 10 - correct string in ISO-8859-5 237s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 237s # delete from t; copy t from stdin" test 237s ok 12 - creating table with UTF-8 characters 237s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 237s ok 14 - correct string in UTF-8 237s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 237s ok 16 - correct string in ISO-8859-1 237s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 237s ok 18 - Server error message has correct language and encoding 239s ok 19 - pg_ctlcluster 12 ru_RU restart 239s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 240s ok 21 - Dropping cluster 240s # Checking 12 ru_RU.UTF-8 243s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 244s ok 23 - psql -l succeeds 244s ok 24 - template1 is UTF-8 encoded 244s ok 25 - creating test database 244s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 244s # create table t (x varchar); copy t from stdin" test 244s ok 27 - creating table with ISO-8859-5 characters 244s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 244s ok 29 - correct string in UTF-8 244s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 244s ok 31 - correct string in ISO-8859-5 244s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 244s # delete from t; copy t from stdin" test 244s ok 33 - creating table with UTF-8 characters 244s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 244s ok 35 - correct string in UTF-8 244s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 244s ok 37 - correct string in ISO-8859-1 244s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 244s ok 39 - Server error message has correct language and encoding 247s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 247s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 247s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 247s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 247s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 247s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 247s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 247s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 247s ok 48 - Dropping cluster 247s # Check 12 locale environment variables 250s ok 49 - pg_createcluster: LC_ALL dominates LANG 250s ok 50 - psql -Atl --cluster 12/main 250s ok 51 - template1 is ASCII encoded 251s ok 52 - Dropping cluster 251s ok 53 - Cleanup: No clusters left behind 251s ok 54 - No postgres processes left behind 251s ok 55 - No files in /etc/postgresql left behind 251s ok 56 - No files in /var/lib/postgresql left behind 251s ok 57 - No files in /var/run/postgresql left behind 251s ok 58 - No files in /var/log/postgresql left behind 251s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 251s ok 60 - PostgreSQL TCP ports are closed 251s === Running test 052_upgrade_encodings.t ... === 251s 1..1 251s ok 1 - only one major version installed, skipping upgrade tests 251s === Running test 060_obsolete_confparams.t ... === 251s 1..1 251s ok 1 - only one major version installed, skipping upgrade tests 251s === Running test 070_non_postgres_clusters.t ... === 251s 1..40 252s ok 1 - pg_createcluster 12 main for owner nobody 252s ok 2 - pg_ctlcluster 12 main start 252s ok 3 - start refused when config and data owners mismatch 254s ok 4 - pg_ctlcluster succeeds with owner nobody 254s ok 5 - pg_lsclusters -h 254s ok 6 - pg_lsclusters shows running cluster 254s ok 7 - postgres is running as user nobody 254s ok 8 - ls /tmp/.s.PGSQL.* 254s ok 9 - socket is in /tmp 254s ok 10 - /var/run/postgresql is empty 254s ok 11 - conf dir is owned by user 254s ok 12 - conf dir is owned by user's primary group 254s ok 13 - files are owned by user 254s ok 14 - files are owned by user's primary group 254s ok 15 - log file has 0640 permissions 254s ok 16 - log file is owned by user 254s ok 17 - log file is owned by user's primary group 254s ok 18 - only one major version installed, skipping upgrade test 254s ok 19 - ... 254s ok 20 - ... 254s ok 21 - ... 254s ok 22 - ... 254s ok 23 - ... 254s ok 24 - ... 254s ok 25 - ... 254s ok 26 - ... 254s ok 27 - ... 254s ok 28 - ... 254s ok 29 - pg_dropcluster 254s ok 30 - pg_lsclusters -h 254s ok 31 - No clusters left 254s ok 32 - No postgres processes left 254s ok 33 - Cleanup: No clusters left behind 254s ok 34 - No postgres processes left behind 254s ok 35 - No files in /etc/postgresql left behind 254s ok 36 - No files in /var/lib/postgresql left behind 254s ok 37 - No files in /var/run/postgresql left behind 254s ok 38 - No files in /var/log/postgresql left behind 254s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 254s ok 40 - PostgreSQL TCP ports are closed 254s === Running test 080_start.conf.t ... === 254s 1..73 255s ok 1 - pg_createcluster 12 main 255s # start.conf auto 255s ok 2 - get_cluster_start_conf returns auto 255s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 255s ok 4 - start.conf contains auto 255s ok 5 - systemd generator links cluster 255s ok 6 - systemd generator links correct service file 257s ok 7 - /etc/init.d/postgresql start 12 257s ok 8 - correct output of /etc/init.d/postgresql start 12 257s ok 9 - pg_lsclusters -h 257s ok 10 - cluster is online 257s ok 11 - /etc/init.d/postgresql stop 12 257s ok 12 - correct output of /etc/init.d/postgresql stop 12 260s ok 13 - pg_lsclusters -h 260s ok 14 - cluster is down 260s # start.conf manual 260s ok 15 - get_cluster_start_conf returns manual 260s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 260s ok 17 - start.conf contains manual 261s ok 18 - systemd generator doesn't link cluster 261s ok 19 - /etc/init.d/postgresql start 12 261s ok 20 - correct output of /etc/init.d/postgresql start 12 261s ok 21 - pg_lsclusters -h 261s ok 22 - cluster is down 263s ok 23 - pg_ctlcluster 12 main start 263s ok 24 - correct output of pg_ctlcluster 12 main start 263s ok 25 - pg_lsclusters -h 263s ok 26 - cluster is online 263s ok 27 - pg_ctlcluster 12 main stop 263s ok 28 - correct output of pg_ctlcluster 12 main stop 263s ok 29 - pg_lsclusters -h 263s ok 30 - cluster is down 263s # start.conf disabled 263s ok 31 - get_cluster_start_conf returns disabled 263s ok 32 - systemd generator doesn't link cluster 263s ok 33 - /etc/init.d/postgresql start 12 263s ok 34 - correct output of /etc/init.d/postgresql start 12 263s ok 35 - pg_lsclusters -h 263s ok 36 - cluster is down 263s ok 37 - pg_ctlcluster 12 main start 263s ok 38 - correct output of pg_ctlcluster 12 main start 263s ok 39 - pg_lsclusters -h 263s ok 40 - cluster is down 265s ok 41 - pg_ctlcluster 12 main start 265s ok 42 - correct output of pg_ctlcluster 12 main start 265s ok 43 - pg_lsclusters -h 265s ok 44 - cluster is online 266s ok 45 - pg_ctlcluster 12 main stop 266s ok 46 - correct output of pg_ctlcluster 12 main stop 266s ok 47 - pg_lsclusters -h 266s ok 48 - cluster is down 268s ok 49 - pg_ctlcluster 12 main start 268s ok 50 - correct output of pg_ctlcluster 12 main start 268s ok 51 - pg_lsclusters -h 268s ok 52 - cluster is online 268s # test upgrade 268s ok 53 - only one major version installed, skipping upgrade test 268s ok 54 - ... 268s ok 55 - get_cluster_start_conf for old cluster returns manual 268s ok 56 - get_cluster_start_conf for new cluster returns manual 268s ok 57 - ... 268s ok 58 - dropping upgraded cluster 268s ok 59 - pg_lsclusters -h 268s ok 60 - no clusters any more 268s ok 61 - pg_createcluster 12 main --start-conf foo 268s ok 62 - pg_createcluster checks --start-conf validity 269s ok 63 - pg_createcluster checks --start-conf manual 269s ok 64 - get_cluster_start_conf returns manual 269s ok 65 - dropping cluster 269s ok 66 - Cleanup: No clusters left behind 269s ok 67 - No postgres processes left behind 269s ok 68 - No files in /etc/postgresql left behind 269s ok 69 - No files in /var/lib/postgresql left behind 269s ok 70 - No files in /var/run/postgresql left behind 269s ok 71 - No files in /var/log/postgresql left behind 269s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 269s ok 73 - PostgreSQL TCP ports are closed 269s === Running test 085_pg_ctl.conf.t ... === 269s 1..29 270s ok 1 - pg_createcluster 12 main 270s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 272s ok 3 - pg_ctlcluster 12 main start 272s ok 4 - starting cluster 272s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 272s ok 6 - soft core size is 0 272s ok 7 - set pg_ctl default option to -c 274s ok 8 - pg_ctlcluster 12 main restart 274s ok 9 - restarting cluster 274s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 274s ok 11 - soft core size is unlimited 274s ok 12 - restored pg_ctl default option 276s ok 13 - pg_ctlcluster 12 main restart 276s ok 14 - restarting cluster 276s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 276s ok 16 - soft core size is 0 279s ok 17 - pg_ctlcluster 12 main restart -- -c 279s ok 18 - restarting cluster with -c on the command line 279s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 279s ok 20 - soft core size is unlimited 279s ok 21 - dropping cluster 279s ok 22 - Cleanup: No clusters left behind 279s ok 23 - No postgres processes left behind 279s ok 24 - No files in /etc/postgresql left behind 279s ok 25 - No files in /var/lib/postgresql left behind 279s ok 26 - No files in /var/run/postgresql left behind 279s ok 27 - No files in /var/log/postgresql left behind 279s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 279s ok 29 - PostgreSQL TCP ports are closed 279s === Running test 090_multicluster.t ... === 279s 1..125 280s ok 1 - pg_createcluster 12 old 281s ok 2 - pg_createcluster 12 new1 281s ok 3 - pg_createcluster 12 new2 284s ok 4 - starting cluster 12/old 286s ok 5 - starting cluster 12/new1 288s ok 6 - starting cluster 12/new2 288s ok 7 - pg_lsclusters -h | sort -k3 288s ok 8 - clusters have the correct ports, skipping used 5433 288s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 288s ok 10 - createdb --version 288s ok 11 - pg_wrapper selects port 5432 as default cluster 288s ok 12 - createdb --cluster 12/new1 --version 288s ok 13 - pg_wrapper --cluster works 288s ok 14 - createdb --cluster 12/foo --version 288s ok 15 - pg_wrapper --cluster errors out for invalid cluster 288s ok 16 - createdb --cluster 12/new1 test 288s ok 17 - correct output of createdb --cluster 12/new1 test 288s ok 18 - psql -Atl --cluster 12/new1 288s ok 19 - test db appears in cluster new1 288s ok 20 - psql -Atl --cluster 12/new2 288s ok 21 - test db does not appear in cluster new2 288s ok 22 - psql -Atl 288s ok 23 - test db does not appear in default cluster 288s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 288s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 288s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 288s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 288s ok 28 - psql -Atl --cluster 12/localhost:5434 288s ok 29 - test db appears in cluster 12/localhost:5434 288s ok 30 - psql -Atl --cluster 12/localhost:5440 288s ok 31 - test db does not appear in cluster 12/localhost:5440 288s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 288s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 288s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 288s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 289s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 289s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 289s ok 38 - psql -Atl --cluster 6.4/localhost: 289s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 289s ok 40 - psql -Atl 289s ok 41 - PGCLUSTER selection (1) 289s ok 42 - psql -Atl 289s ok 43 - PGCLUSTER selection (2) 289s ok 44 - psql -l 289s ok 45 - invalid PGCLUSTER value 289s ok 46 - createdb --version 289s ok 47 - PGCLUSTER network cluster selection (1) 289s ok 48 - psql -Atl 289s ok 49 - PGCLUSTER network cluster selection (2) 289s ok 50 - psql -Atl 289s ok 51 - PGCLUSTER network cluster selection (3) 289s ok 52 - LC_MESSAGES=C psql -Atl 289s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 289s ok 54 - psql -Atc "show port" template1 289s ok 55 - PGPORT selection (1) 289s ok 56 - psql -Atc "show port" template1 289s ok 57 - PGPORT selection (2) 289s ok 58 - createdb --version 289s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 289s ok 60 - psql -Atc "show port" template1 289s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 289s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 289s ok 63 - PGDATABASE environment variable works 289s ok 64 - createdb --version 289s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 289s ok 66 - createdb --cluster 12/new1 --version 289s ok 67 - pg_wrapper --cluster works with empty user_clusters 289s ok 68 - createdb --version 289s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 289s ok 70 - psql -Atc "select current_database()" 289s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 289s ok 72 - psql -Atc 'select current_database()' 289s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 289s ok 74 - createdb --version 289s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 289s ok 76 - createdb --version 289s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 289s ok 78 - createdb --version 289s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 289s ok 80 - createdb --version 289s ok 81 - pg_wrapper selects correct version with per-user user_clusters 289s ok 82 - createdb --version 289s ok 83 - pg_wrapper selects correct version with per-user user_clusters 289s ok 84 - createdb --version 289s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 289s ok 86 - psql -Atl 289s ok 87 - $PGHOST overrides user_clusters 289s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 289s ok 89 - --cluster overrides $PGHOST 289s ok 90 - createdb --version 289s ok 91 - pg_wrapper ignores invalid lines in user_clusters 289s ok 92 - psql -Atc 'select current_database()' 289s ok 93 - pg_service conf selection 1 289s ok 94 - psql -Atc 'select current_database()' 289s ok 95 - pg_service conf selection 2 290s ok 96 - psql -Atc 'select current_database()' 290s ok 97 - pg_service conf selection 3 290s ok 98 - stopping cluster 12/old 292s ok 99 - restarting cluster 12/old 292s ok 100 - pg_lsclusters -h | sort -k3 292s ok 101 - port of first cluster was successfully changed 292s ok 102 - psql -l 292s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 292s ok 104 - psql -Atl --cluster 12/new1 292s ok 105 - --cluster selects appropriate cluster 292s ok 106 - psql -Atl -p 5434 292s ok 107 - -p selects appropriate cluster 292s ok 108 - psql -Atlp 5434 292s ok 109 - -Atlp selects appropriate cluster 292s ok 110 - psql -Atl --port 5434 292s ok 111 - --port selects appropriate cluster 292s ok 112 - env PGPORT=5434 psql -Atl 292s ok 113 - $PGPORT selects appropriate cluster 292s ok 114 - Restoring original /etc/postgresql-common/user_clusters 293s ok 115 - dropping 12/new1 293s ok 116 - dropping 12/new2 293s ok 117 - dropping 12/old 293s ok 118 - Cleanup: No clusters left behind 293s ok 119 - No postgres processes left behind 293s ok 120 - No files in /etc/postgresql left behind 293s ok 121 - No files in /var/lib/postgresql left behind 293s ok 122 - No files in /var/run/postgresql left behind 293s ok 123 - No files in /var/log/postgresql left behind 293s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 293s ok 125 - PostgreSQL TCP ports are closed 293s === Running test 100_upgrade_scripts.t ... === 294s 1..27 297s ok 1 - pg_createcluster 12 main 297s ok 2 - createdb --cluster 12/main db1 297s ok 3 - correct output of createdb --cluster 12/main db1 297s ok 4 - createdb --cluster 12/main db2 297s ok 5 - correct output of createdb --cluster 12/main db2 297s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 297s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 297s ok 8 - get_cluster_databases() works 297s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 298s ok 10 - run-upgrade-scripts succeeds 298s ok 11 - correct run-upgrade-script output 298s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 298s ok 13 - check SQL scripts results in 12/main db1 298s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 298s ok 15 - check SQL scripts results in 12/main db2 298s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 298s ok 17 - check shell scripts results in $v/main 298s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 299s ok 19 - pg_dropcluster 12 main 299s ok 20 - Cleanup: No clusters left behind 299s ok 21 - No postgres processes left behind 299s ok 22 - No files in /etc/postgresql left behind 299s ok 23 - No files in /var/lib/postgresql left behind 299s ok 24 - No files in /var/run/postgresql left behind 299s ok 25 - No files in /var/log/postgresql left behind 299s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 299s ok 27 - PostgreSQL TCP ports are closed 299s === Running test 110_integrate_cluster.t ... === 299s 1..32 300s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/awN6HmOK5q/c/postgres 300s ok 2 - creating raw initdb cluster for user postgres 300s ok 3 - pg_createcluster 12 postgres -d /tmp/awN6HmOK5q/c/postgres 300s ok 4 - integrating postgres cluster 300s ok 5 - pg_lsclusters 300s ok 6 - correct pg_lsclusters output 302s ok 7 - pg_ctlcluster 12 postgres start 302s ok 8 - starting cluster postgres 302s ok 9 - pg_lsclusters 302s ok 10 - correct pg_lsclusters output 302s ok 11 - dropping cluster postgres 302s ok 12 - No files in temporary cluster dir left behind 303s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/awN6HmOK5q/c/nobody 303s ok 14 - creating raw initdb cluster for user nobody 303s ok 15 - pg_createcluster 12 nobody -d /tmp/awN6HmOK5q/c/nobody 303s ok 16 - integrating nobody cluster 303s ok 17 - pg_lsclusters 303s ok 18 - correct pg_lsclusters output 306s ok 19 - pg_ctlcluster 12 nobody start 306s ok 20 - starting cluster nobody 306s ok 21 - pg_lsclusters 306s ok 22 - correct pg_lsclusters output 306s ok 23 - dropping cluster nobody 306s ok 24 - No files in temporary cluster dir left behind 306s ok 25 - Cleanup: No clusters left behind 306s ok 26 - No postgres processes left behind 306s ok 27 - No files in /etc/postgresql left behind 306s ok 28 - No files in /var/lib/postgresql left behind 306s ok 29 - No files in /var/run/postgresql left behind 306s ok 30 - No files in /var/log/postgresql left behind 306s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 306s ok 32 - PostgreSQL TCP ports are closed 306s === Running test 120_pg_upgradecluster_scripts.t ... === 306s 1..1 306s ok 1 - only one major version installed, skipping upgrade tests 306s === Running test 130_nonroot_admin.t ... === 306s 1..22 309s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 309s ok 2 - pg_lsclusters -h 309s ok 3 - correct output of pg_lsclusters -h 309s ok 4 - psql -Atl 309s ok 5 - correct output of psql -Atl 309s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 309s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 309s ok 15 - Cleanup: No clusters left behind 309s ok 16 - No postgres processes left behind 309s ok 17 - No files in /etc/postgresql left behind 309s ok 18 - No files in /var/lib/postgresql left behind 309s ok 19 - No files in /var/run/postgresql left behind 309s ok 20 - No files in /var/log/postgresql left behind 309s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 309s ok 22 - PostgreSQL TCP ports are closed 309s === Running test 135_pg_virtualenv.t ... === 309s 1..20 313s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 313s ok 2 - running pg_virtualenv as root 316s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 316s ok 4 - running pg_virtualenv as postgres 319s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 319s ok 6 - running pg_virtualenv as nobody 319s ok 7 # skip /usr/bin/fakeroot not available 319s ok 8 # skip /usr/bin/fakeroot not available 319s ok 9 # skip /usr/bin/fakeroot not available 319s ok 10 # skip /usr/bin/fakeroot not available 319s ok 11 # skip /usr/bin/fakeroot not available 319s ok 12 # skip /usr/bin/fakeroot not available 319s ok 13 - Cleanup: No clusters left behind 319s ok 14 - No postgres processes left behind 319s ok 15 - No files in /etc/postgresql left behind 319s ok 16 - No files in /var/lib/postgresql left behind 319s ok 17 - No files in /var/run/postgresql left behind 319s ok 18 - No files in /var/log/postgresql left behind 319s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 319s ok 20 - PostgreSQL TCP ports are closed 319s === Running test 140_pg_config.t ... === 319s 1..38 319s # Multiarch is enabled 319s # checking version specific output for 12 319s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 319s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 319s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 319s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 319s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 319s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 319s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 319s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 319s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 319s # checking pg_config output (should behave like version 12) 319s ok 15 - pg_config 319s ok 16 - correct output of pg_config 319s ok 17 - pg_config --help 319s ok 18 - correct output of pg_config --help 319s ok 19 - pg_config --pgxs 319s ok 20 - correct output of pg_config --pgxs 319s ok 21 - pg_config --libdir 319s ok 22 - correct output of pg_config --libdir 319s ok 23 - pg_config --pkglibdir 319s ok 24 - correct output of pg_config --pkglibdir 319s ok 25 - pg_config --bindir 319s ok 26 - correct output of pg_config --bindir 319s # checking pg_config.libpq-dev output (should behave like version 12) 319s ok 27 - pg_config.libpq-dev 319s ok 28 - correct output of pg_config.libpq-dev 319s ok 29 - pg_config.libpq-dev --help 319s ok 30 - correct output of pg_config.libpq-dev --help 319s ok 31 - pg_config.libpq-dev --pgxs 319s ok 32 - correct output of pg_config.libpq-dev --pgxs 319s ok 33 - pg_config.libpq-dev --libdir 319s ok 34 - correct output of pg_config.libpq-dev --libdir 319s ok 35 - pg_config.libpq-dev --pkglibdir 319s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 319s ok 37 - pg_config.libpq-dev --bindir 319s ok 38 - correct output of pg_config.libpq-dev --bindir 319s === Running test 150_tsearch_stemming.t ... === 319s 1..37 319s ok 1 - pg_updatedicts succeeded 319s ok 2 - pg_updatedicts created en_us.affix 319s ok 3 - pg_updatedicts created en_us.dict 319s ok 4 - pg_updatedicts created 12 en_us.affix symlink 319s ok 5 - pg_updatedicts created 12 en_us.dict symlink 322s ok 6 - pg_createcluster 12 main 322s ok 7 - createdb fts 322s ok 8 - correct output of createdb fts 322s ok 9 - creating en_US full text search configuration 322s ok 10 - creating data table and search index 322s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 322s ok 12 - stem search of correct word 322s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 322s ok 14 - stem search of correct word 322s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 322s ok 16 - stem search of unknown word 322s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 322s ok 18 - full text search, exact word 322s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 322s ok 20 - full text search for word stem 322s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 322s ok 22 - full text search for word substring fails 322s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 322s ok 24 - full text search, exact unicode word 322s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 322s ok 26 - full text search for unicode word stem 323s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 323s ok 28 - full text search for unicode word substring fails 323s ok 29 323s ok 30 - Cleanup: No clusters left behind 323s ok 31 - No postgres processes left behind 323s ok 32 - No files in /etc/postgresql left behind 323s ok 33 - No files in /var/lib/postgresql left behind 323s ok 34 - No files in /var/run/postgresql left behind 323s ok 35 - No files in /var/log/postgresql left behind 323s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 323s ok 37 - PostgreSQL TCP ports are closed 323s === Running test 160_alternate_confroot.t ... === 323s 1..28 326s ok 1 326s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 326s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 326s ok 4 - pg_lsclusters -h 326s ok 5 - correct output of pg_lsclusters -h 326s ok 6 - psql -Atl 326s ok 7 - correct output of psql -Atl 326s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 326s ok 9 - ... 326s ok 10 - ... 326s ok 11 - ... 326s ok 12 - ... 326s ok 13 - ... 326s ok 14 - ... 326s ok 15 - pg_dropcluster 12 test --stop 326s ok 16 - correct output of pg_dropcluster 12 test --stop 326s ok 17 - pg_lsclusters -h 326s ok 18 - correct output of pg_lsclusters -h 326s ok 19 - No files in root/data left behind 326s ok 20 - No cruft in root dir left behind 326s ok 21 - Cleanup: No clusters left behind 326s ok 22 - No postgres processes left behind 326s ok 23 - No files in /etc/postgresql left behind 326s ok 24 - No files in /var/lib/postgresql left behind 326s ok 25 - No files in /var/run/postgresql left behind 326s ok 26 - No files in /var/log/postgresql left behind 326s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 326s ok 28 - PostgreSQL TCP ports are closed 326s === Running test 170_extensions.t ... === 326s # Running tests for 12 329s ok 1 - pg_createcluster 12 main 329s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 329s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 329s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 329s ok 5 - extension adminpack installs without error 329s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 329s ok 7 - extension adminpack removes without error 329s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 329s ok 9 - extension amcheck installs without error 329s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 329s ok 11 - extension amcheck removes without error 329s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 329s ok 13 - extension autoinc installs without error 329s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 329s ok 15 - extension autoinc removes without error 329s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 329s ok 17 - extension bloom installs without error 329s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 329s ok 19 - extension bloom removes without error 330s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 330s ok 21 - extension btree_gin installs without error 330s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 330s ok 23 - extension btree_gin removes without error 330s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 330s ok 25 - extension btree_gist installs without error 330s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 330s ok 27 - extension btree_gist removes without error 330s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 330s ok 29 - extension citext installs without error 330s ok 30 - psql -qc 'DROP EXTENSION "citext"' 330s ok 31 - extension citext removes without error 330s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 330s ok 33 - extension cube installs without error 330s ok 34 - psql -qc 'DROP EXTENSION "cube"' 330s ok 35 - extension cube removes without error 330s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 330s ok 37 - extension dblink installs without error 330s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 330s ok 39 - extension dblink removes without error 330s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 330s ok 41 - extension dict_int installs without error 330s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 330s ok 43 - extension dict_int removes without error 330s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 330s ok 45 - extension dict_xsyn installs without error 330s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 330s ok 47 - extension dict_xsyn removes without error 330s ok 48 - psql -qc 'CREATE EXTENSION cube' 330s ok 49 - earthdistance dependency cube installs without error 330s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 330s ok 51 - extension earthdistance installs without error 330s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 330s ok 53 - extension earthdistance removes without error 330s ok 54 - psql -qc 'DROP EXTENSION cube' 330s ok 55 - earthdistance dependency extension cube removes without error 330s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 330s ok 57 - extension file_fdw installs without error 331s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 331s ok 59 - extension file_fdw removes without error 331s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 331s ok 61 - extension fuzzystrmatch installs without error 331s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 331s ok 63 - extension fuzzystrmatch removes without error 331s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 331s ok 65 - extension hstore installs without error 331s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 331s ok 67 - extension hstore removes without error 331s ok 68 - psql -qc 'CREATE EXTENSION hstore' 331s ok 69 - hstore_plperl dependency hstore installs without error 331s ok 70 - psql -qc 'CREATE EXTENSION plperl' 331s ok 71 - hstore_plperl dependency plperl installs without error 331s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 331s ok 73 - extension hstore_plperl installs without error 331s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 331s ok 75 - extension hstore_plperl removes without error 331s ok 76 - psql -qc 'DROP EXTENSION hstore' 331s ok 77 - hstore_plperl dependency extension hstore removes without error 331s ok 78 - psql -qc 'DROP EXTENSION plperl' 331s ok 79 - hstore_plperl dependency extension plperl removes without error 331s ok 80 - psql -qc 'CREATE EXTENSION hstore' 331s ok 81 - hstore_plperlu dependency hstore installs without error 331s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 331s ok 83 - hstore_plperlu dependency plperlu installs without error 331s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 331s ok 85 - extension hstore_plperlu installs without error 331s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 331s ok 87 - extension hstore_plperlu removes without error 331s ok 88 - psql -qc 'DROP EXTENSION hstore' 331s ok 89 - hstore_plperlu dependency extension hstore removes without error 331s ok 90 - psql -qc 'DROP EXTENSION plperlu' 331s ok 91 - hstore_plperlu dependency extension plperlu removes without error 331s ok 92 - psql -qc 'CREATE EXTENSION hstore' 331s ok 93 - hstore_plpython3u dependency hstore installs without error 331s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 331s ok 95 - hstore_plpython3u dependency plpython3u installs without error 331s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 331s ok 97 - extension hstore_plpython3u installs without error 331s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 331s ok 99 - extension hstore_plpython3u removes without error 331s ok 100 - psql -qc 'DROP EXTENSION hstore' 331s ok 101 - hstore_plpython3u dependency extension hstore removes without error 331s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 331s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 331s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 331s ok 105 - extension insert_username installs without error 331s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 331s ok 107 - extension insert_username removes without error 332s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 332s ok 109 - extension intagg installs without error 332s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 332s ok 111 - extension intagg removes without error 332s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 332s ok 113 - extension intarray installs without error 332s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 332s ok 115 - extension intarray removes without error 332s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 332s ok 117 - extension isn installs without error 332s ok 118 - psql -qc 'DROP EXTENSION "isn"' 332s ok 119 - extension isn removes without error 332s ok 120 - psql -qc 'CREATE EXTENSION plperl' 332s ok 121 - jsonb_plperl dependency plperl installs without error 332s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 332s ok 123 - extension jsonb_plperl installs without error 332s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 332s ok 125 - extension jsonb_plperl removes without error 332s ok 126 - psql -qc 'DROP EXTENSION plperl' 332s ok 127 - jsonb_plperl dependency extension plperl removes without error 332s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 332s ok 129 - jsonb_plperlu dependency plperlu installs without error 332s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 332s ok 131 - extension jsonb_plperlu installs without error 332s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 332s ok 133 - extension jsonb_plperlu removes without error 332s ok 134 - psql -qc 'DROP EXTENSION plperlu' 332s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 332s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 332s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 332s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 332s ok 139 - extension jsonb_plpython3u installs without error 332s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 332s ok 141 - extension jsonb_plpython3u removes without error 332s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 332s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 332s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 332s ok 145 - extension lo installs without error 332s ok 146 - psql -qc 'DROP EXTENSION "lo"' 332s ok 147 - extension lo removes without error 332s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 332s ok 149 - extension ltree installs without error 332s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 332s ok 151 - extension ltree removes without error 332s ok 152 - psql -qc 'CREATE EXTENSION ltree' 332s ok 153 - ltree_plpython3u dependency ltree installs without error 333s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 333s ok 155 - ltree_plpython3u dependency plpython3u installs without error 333s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 333s ok 157 - extension ltree_plpython3u installs without error 333s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 333s ok 159 - extension ltree_plpython3u removes without error 333s ok 160 - psql -qc 'DROP EXTENSION ltree' 333s ok 161 - ltree_plpython3u dependency extension ltree removes without error 333s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 333s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 333s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 333s ok 165 - extension moddatetime installs without error 333s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 333s ok 167 - extension moddatetime removes without error 333s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 333s ok 169 - extension pageinspect installs without error 333s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 333s ok 171 - extension pageinspect removes without error 333s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 333s ok 173 - extension pg_buffercache installs without error 333s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 333s ok 175 - extension pg_buffercache removes without error 333s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 333s ok 177 - extension pg_freespacemap installs without error 333s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 333s ok 179 - extension pg_freespacemap removes without error 333s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 333s ok 181 - extension pg_prewarm installs without error 333s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 333s ok 183 - extension pg_prewarm removes without error 333s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 333s ok 185 - extension pg_stat_statements installs without error 333s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 333s ok 187 - extension pg_stat_statements removes without error 333s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 333s ok 189 - extension pg_trgm installs without error 333s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 333s ok 191 - extension pg_trgm removes without error 333s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 333s ok 193 - extension pg_visibility installs without error 333s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 333s ok 195 - extension pg_visibility removes without error 333s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 333s ok 197 - extension pgcrypto installs without error 333s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 333s ok 199 - extension pgcrypto removes without error 334s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 334s ok 201 - extension pgrowlocks installs without error 334s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 334s ok 203 - extension pgrowlocks removes without error 334s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 334s ok 205 - extension pgstattuple installs without error 334s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 334s ok 207 - extension pgstattuple removes without error 334s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 334s ok 209 - extension plperl installs without error 334s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 334s ok 211 - extension plperl removes without error 334s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 334s ok 213 - extension plperlu installs without error 334s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 334s ok 215 - extension plperlu removes without error 334s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 334s ok 217 - extension plpython3u installs without error 334s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 334s ok 219 - extension plpython3u removes without error 334s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 334s ok 221 - extension pltcl installs without error 334s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 334s ok 223 - extension pltcl removes without error 334s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 334s ok 225 - extension pltclu installs without error 334s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 334s ok 227 - extension pltclu removes without error 334s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 334s ok 229 - extension postgres_fdw installs without error 334s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 334s ok 231 - extension postgres_fdw removes without error 334s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 334s ok 233 - extension refint installs without error 334s ok 234 - psql -qc 'DROP EXTENSION "refint"' 334s ok 235 - extension refint removes without error 334s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 334s ok 237 - extension seg installs without error 334s ok 238 - psql -qc 'DROP EXTENSION "seg"' 334s ok 239 - extension seg removes without error 334s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 334s ok 241 - extension sslinfo installs without error 334s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 334s ok 243 - extension sslinfo removes without error 334s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 334s ok 245 - extension tablefunc installs without error 335s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 335s ok 247 - extension tablefunc removes without error 335s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 335s ok 249 - extension tcn installs without error 335s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 335s ok 251 - extension tcn removes without error 335s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 335s ok 253 - extension tsm_system_rows installs without error 335s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 335s ok 255 - extension tsm_system_rows removes without error 335s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 335s ok 257 - extension tsm_system_time installs without error 335s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 335s ok 259 - extension tsm_system_time removes without error 335s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 335s ok 261 - extension unaccent installs without error 335s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 335s ok 263 - extension unaccent removes without error 335s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 335s ok 265 - extension uuid-ossp installs without error 335s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 335s ok 267 - extension uuid-ossp removes without error 335s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 335s ok 269 - extension xml2 installs without error 335s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 335s ok 271 - extension xml2 removes without error 335s ok 272 - pg_dropcluster 12 main 335s ok 273 - Cleanup: No clusters left behind 335s ok 274 - No postgres processes left behind 335s ok 275 - No files in /etc/postgresql left behind 335s ok 276 - No files in /var/lib/postgresql left behind 335s ok 277 - No files in /var/run/postgresql left behind 335s ok 278 - No files in /var/log/postgresql left behind 335s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 335s ok 280 - PostgreSQL TCP ports are closed 335s 1..280 335s === Running test 180_ecpg.t ... === 336s 1..17 336s ok 1 - ecpg test.pgc 336s ok 2 - ecpg processing 336s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 336s ok 4 - compiling ecpg output 339s ok 5 - pg_createcluster 12 main 339s ok 6 - createuser nobody 339s ok 7 - /tmp/tmp.1N4RCTWXdk/test 339s not ok 8 - runs and gives correct output 339s # Failed test 'runs and gives correct output' 339s # at t/TestLib.pm line 201. 339s # got: ' 339s # ' 339s # expected: 'template1 339s # ' 339s ok 9 - pg_dropcluster 12 main 339s ok 10 - Cleanup: No clusters left behind 339s ok 11 - No postgres processes left behind 339s ok 12 - No files in /etc/postgresql left behind 339s ok 13 - No files in /var/lib/postgresql left behind 339s ok 14 - No files in /var/run/postgresql left behind 339s ok 15 - No files in /var/log/postgresql left behind 339s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 339s ok 17 - PostgreSQL TCP ports are closed 339s # Looks like you failed 1 test of 17. 340s autopkgtest [09:34:12]: test run-testsuite: -----------------------] 340s run-testsuite FAIL non-zero exit status 1 340s autopkgtest [09:34:12]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 340s autopkgtest [09:34:12]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 340s # Failed test 'runs and gives correct output' 340s # at t/TestLib.pm line 201. 340s # got: ' 340s # ' 340s # expected: 'template1 340s # ' 340s # Looks like you failed 1 test of 17. 341s autopkgtest [09:34:13]: test installcheck: preparing testbed 408s autopkgtest [09:35:20]: testbed dpkg architecture: amd64 408s autopkgtest [09:35:20]: testbed apt version: 2.0.10 408s autopkgtest [09:35:20]: @@@@@@@@@@@@@@@@@@@@ test bed setup 409s autopkgtest [09:35:21]: testbed release detected to be: focal 409s autopkgtest [09:35:21]: updating testbed package index (apt update) 410s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 410s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 410s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 410s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 410s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.2 kB] 410s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 410s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 410s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [81.8 kB] 411s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [365 kB] 411s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1648 B] 411s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [574 kB] 411s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [1524 B] 411s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 411s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [48.4 kB] 411s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [30.5 kB] 411s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 411s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [1020 B] 411s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 411s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 412s Fetched 1467 kB in 1s (1308 kB/s) 413s Reading package lists... 414s autopkgtest [09:35:26]: upgrading testbed (apt dist-upgrade and autopurge) 414s Reading package lists... 414s Building dependency tree... 414s Reading state information... 414s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 414s Starting 2 pkgProblemResolver with broken count: 0 414s Done 414s 415s The following packages will be upgraded: 415s tzdata 415s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 415s Need to get 300 kB of archives. 415s After this operation, 12.3 kB of additional disk space will be used. 415s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 tzdata all 2025b-0ubuntu0.20.04 [300 kB] 415s Preconfiguring packages ... 415s Fetched 300 kB in 0s (724 kB/s) 415s (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 ... 66346 files and directories currently installed.) 415s Preparing to unpack .../tzdata_2025b-0ubuntu0.20.04_all.deb ... 415s Unpacking tzdata (2025b-0ubuntu0.20.04) over (2025a-0ubuntu0.20.04) ... 416s Setting up tzdata (2025b-0ubuntu0.20.04) ... 416s 416s Current default time zone: 'Etc/UTC' 416s Local time is now: Fri Mar 28 09:35:28 UTC 2025. 416s Universal Time is now: Fri Mar 28 09:35:28 UTC 2025. 416s Run 'dpkg-reconfigure tzdata' if you wish to change it. 416s 416s Reading package lists... 416s Building dependency tree... 416s Reading state information... 417s Starting pkgProblemResolver with broken count: 0 417s Starting 2 pkgProblemResolver with broken count: 0 417s Done 417s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 420s Reading package lists... 420s Building dependency tree... 420s Reading state information... 420s Starting pkgProblemResolver with broken count: 0 420s Starting 2 pkgProblemResolver with broken count: 0 420s Done 420s The following NEW packages will be installed: 420s binfmt-support build-essential clang-10 cpp cpp-9 g++ g++-9 gcc gcc-9 420s gcc-9-base lib32gcc-s1 lib32stdc++6 libasan5 libatomic1 libc-dev-bin 420s libc6-dev libc6-i386 libcc1-0 libclang-common-10-dev libclang-cpp10 420s libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libffi-dev 420s libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 420s libncurses-dev libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 420s libpython3.8 libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 420s libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 420s llvm-10-runtime llvm-10-tools postgresql-12 postgresql-client-12 420s postgresql-client-common postgresql-common postgresql-doc-12 420s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 420s postgresql-server-dev-12 python3-pygments ssl-cert 420s 0 upgraded, 67 newly installed, 0 to remove and 0 not upgraded. 420s Need to get 142 MB of archives. 420s After this operation, 750 MB of additional disk space will be used. 420s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 421s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 421s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-211.231 [1116 kB] 421s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 421s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 421s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 421s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 421s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 421s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 421s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 421s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 421s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 421s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 421s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 421s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 421s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 421s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 421s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 421s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 421s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 421s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 421s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 421s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 422s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 422s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 422s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 422s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 422s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 423s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 423s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 423s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 423s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 423s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 423s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 423s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 423s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 424s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 424s Get:38 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.3 [45.7 kB] 424s Get:39 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 424s Get:40 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.3 [43.4 kB] 424s Get:41 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.3 [12.7 kB] 424s Get:42 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.3 [138 kB] 424s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.3 [239 kB] 424s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 424s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.18 [1625 kB] 424s Get:46 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 424s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 424s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 424s Get:49 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 424s Get:50 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 424s Get:51 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 424s Get:52 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 424s Get:53 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 424s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 424s Get:55 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 424s Get:56 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 424s Get:57 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 425s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 425s Get:59 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 425s Get:60 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 425s Get:61 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 425s Get:62 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 426s Get:63 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.3 [1949 kB] 426s Get:64 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.3 [68.6 kB] 426s Get:65 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.3 [76.5 kB] 426s Get:66 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.3 [31.6 kB] 426s Get:67 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.3 [995 kB] 426s Preconfiguring packages ... 426s Fetched 142 MB in 6s (25.5 MB/s) 426s Selecting previously unselected package binfmt-support. 426s (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 ... 66349 files and directories currently installed.) 426s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 426s Unpacking binfmt-support (2.2.0-2) ... 426s Selecting previously unselected package libc-dev-bin. 426s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 426s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 426s Selecting previously unselected package linux-libc-dev:amd64. 426s Preparing to unpack .../02-linux-libc-dev_5.4.0-211.231_amd64.deb ... 426s Unpacking linux-libc-dev:amd64 (5.4.0-211.231) ... 426s Selecting previously unselected package libcrypt-dev:amd64. 426s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 426s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 426s Selecting previously unselected package libc6-dev:amd64. 426s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 426s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 427s Selecting previously unselected package gcc-9-base:amd64. 427s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 427s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 427s Selecting previously unselected package libisl22:amd64. 427s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 427s Unpacking libisl22:amd64 (0.22.1-1) ... 427s Selecting previously unselected package libmpc3:amd64. 427s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 427s Unpacking libmpc3:amd64 (1.1.0-1) ... 427s Selecting previously unselected package cpp-9. 427s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 427s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 427s Selecting previously unselected package cpp. 427s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 427s Unpacking cpp (4:9.3.0-1ubuntu2) ... 427s Selecting previously unselected package libcc1-0:amd64. 427s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 427s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 427s Selecting previously unselected package libgomp1:amd64. 427s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 427s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 427s Selecting previously unselected package libitm1:amd64. 427s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 427s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 427s Selecting previously unselected package libatomic1:amd64. 427s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 427s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 427s Selecting previously unselected package libasan5:amd64. 427s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 427s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 428s Selecting previously unselected package liblsan0:amd64. 428s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 428s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 428s Selecting previously unselected package libtsan0:amd64. 428s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 428s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 428s Selecting previously unselected package libubsan1:amd64. 428s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 428s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 428s Selecting previously unselected package libquadmath0:amd64. 428s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 428s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 428s Selecting previously unselected package libgcc-9-dev:amd64. 428s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 428s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 428s Selecting previously unselected package gcc-9. 428s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 428s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 429s Selecting previously unselected package gcc. 429s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 429s Unpacking gcc (4:9.3.0-1ubuntu2) ... 429s Selecting previously unselected package libstdc++-9-dev:amd64. 429s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 429s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 429s Selecting previously unselected package g++-9. 429s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 429s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 430s Selecting previously unselected package g++. 430s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 430s Unpacking g++ (4:9.3.0-1ubuntu2) ... 430s Selecting previously unselected package build-essential. 430s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 430s Unpacking build-essential (12.8ubuntu1.1) ... 430s Selecting previously unselected package libllvm10:amd64. 430s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 430s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 431s Selecting previously unselected package libclang-cpp10. 431s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 431s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 432s Selecting previously unselected package libgc1c2:amd64. 432s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 432s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 432s Selecting previously unselected package libobjc4:amd64. 432s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 432s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 432s Selecting previously unselected package libobjc-9-dev:amd64. 432s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 432s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 432s Selecting previously unselected package libc6-i386. 432s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 432s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 432s Selecting previously unselected package lib32gcc-s1. 432s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 432s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 432s Selecting previously unselected package lib32stdc++6. 432s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 432s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 432s Selecting previously unselected package libclang-common-10-dev. 432s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 432s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 433s Selecting previously unselected package libclang1-10. 433s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 433s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 433s Selecting previously unselected package clang-10. 433s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 433s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 433s Selecting previously unselected package libpgtypes3:amd64. 433s Preparing to unpack .../37-libpgtypes3_12.22-0ubuntu0.20.04.3_amd64.deb ... 433s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 433s Selecting previously unselected package libpq5:amd64. 433s Preparing to unpack .../38-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 433s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 433s Selecting previously unselected package libecpg6:amd64. 433s Preparing to unpack .../39-libecpg6_12.22-0ubuntu0.20.04.3_amd64.deb ... 433s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 433s Selecting previously unselected package libecpg-compat3:amd64. 433s Preparing to unpack .../40-libecpg-compat3_12.22-0ubuntu0.20.04.3_amd64.deb ... 433s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 433s Selecting previously unselected package libpq-dev. 433s Preparing to unpack .../41-libpq-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 433s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 433s Selecting previously unselected package libecpg-dev. 433s Preparing to unpack .../42-libecpg-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 434s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 434s Selecting previously unselected package libncurses-dev:amd64. 434s Preparing to unpack .../43-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 434s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 434s Selecting previously unselected package libpython3.8:amd64. 434s Preparing to unpack .../44-libpython3.8_3.8.10-0ubuntu1~20.04.18_amd64.deb ... 434s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 434s Selecting previously unselected package libtcl8.6:amd64. 434s Preparing to unpack .../45-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 434s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 434s Selecting previously unselected package libtinfo-dev:amd64. 434s Preparing to unpack .../46-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 434s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 434s Selecting previously unselected package libxslt1.1:amd64. 434s Preparing to unpack .../47-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 434s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 434s Selecting previously unselected package llvm-10-runtime. 434s Preparing to unpack .../48-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 434s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 434s Selecting previously unselected package libpfm4:amd64. 434s Preparing to unpack .../49-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 434s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 434s Selecting previously unselected package llvm-10. 434s Preparing to unpack .../50-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 434s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 434s Selecting previously unselected package libffi-dev:amd64. 434s Preparing to unpack .../51-libffi-dev_3.3-4_amd64.deb ... 434s Unpacking libffi-dev:amd64 (3.3-4) ... 434s Selecting previously unselected package python3-pygments. 434s Preparing to unpack .../52-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 434s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 434s Selecting previously unselected package llvm-10-tools. 434s Preparing to unpack .../53-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 434s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 434s Selecting previously unselected package libz3-4:amd64. 435s Preparing to unpack .../54-libz3-4_4.8.7-4build1_amd64.deb ... 435s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 435s Selecting previously unselected package libz3-dev:amd64. 435s Preparing to unpack .../55-libz3-dev_4.8.7-4build1_amd64.deb ... 435s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 435s Selecting previously unselected package llvm-10-dev. 435s Preparing to unpack .../56-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 435s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 437s Selecting previously unselected package postgresql-client-common. 437s Preparing to unpack .../57-postgresql-client-common_214ubuntu0.1_all.deb ... 437s Unpacking postgresql-client-common (214ubuntu0.1) ... 437s Selecting previously unselected package postgresql-client-12. 437s Preparing to unpack .../58-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 437s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 437s Selecting previously unselected package ssl-cert. 437s Preparing to unpack .../59-ssl-cert_1.0.39_all.deb ... 437s Unpacking ssl-cert (1.0.39) ... 437s Selecting previously unselected package postgresql-common. 437s Preparing to unpack .../60-postgresql-common_214ubuntu0.1_all.deb ... 437s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 437s Unpacking postgresql-common (214ubuntu0.1) ... 437s Selecting previously unselected package postgresql-12. 437s Preparing to unpack .../61-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 437s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 439s Selecting previously unselected package postgresql-doc-12. 439s Preparing to unpack .../62-postgresql-doc-12_12.22-0ubuntu0.20.04.3_all.deb ... 439s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.3) ... 439s Selecting previously unselected package postgresql-plperl-12. 439s Preparing to unpack .../63-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 439s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 439s Selecting previously unselected package postgresql-plpython3-12. 439s Preparing to unpack .../64-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 439s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 439s Selecting previously unselected package postgresql-pltcl-12. 439s Preparing to unpack .../65-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 439s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 439s Selecting previously unselected package postgresql-server-dev-12. 439s Preparing to unpack .../66-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 439s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 439s Setting up postgresql-client-common (214ubuntu0.1) ... 439s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 439s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 439s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 439s Setting up linux-libc-dev:amd64 (5.4.0-211.231) ... 439s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 439s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 439s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 439s Setting up libffi-dev:amd64 (3.3-4) ... 439s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.3) ... 439s 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 439s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 439s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 439s Setting up libz3-4:amd64 (4.8.7-4build1) ... 439s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 440s 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 440s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 440s Setting up ssl-cert (1.0.39) ... 440s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 440s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 440s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 440s Setting up postgresql-common (214ubuntu0.1) ... 440s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 440s Adding user postgres to group ssl-cert 440s 440s Creating config file /etc/postgresql-common/createcluster.conf with new version 440s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 440s Removing obsolete dictionary files: 441s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 441s Setting up libmpc3:amd64 (1.1.0-1) ... 441s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 441s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 441s Setting up binfmt-support (2.2.0-2) ... 441s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 442s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 442s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 442s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 442s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 442s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 442s Setting up libisl22:amd64 (0.22.1-1) ... 442s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 442s Creating new PostgreSQL cluster 12/main ... 442s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 442s The files belonging to this database system will be owned by user "postgres". 442s This user must also own the server process. 442s 442s The database cluster will be initialized with locale "C.UTF-8". 442s The default database encoding has accordingly been set to "UTF8". 442s The default text search configuration will be set to "english". 442s 442s Data page checksums are disabled. 442s 442s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 442s creating subdirectories ... ok 442s selecting dynamic shared memory implementation ... posix 442s selecting default max_connections ... 100 442s selecting default shared_buffers ... 128MB 442s selecting default time zone ... Etc/UTC 442s creating configuration files ... ok 442s running bootstrap script ... ok 442s performing post-bootstrap initialization ... ok 443s syncing data to disk ... ok 443s 443s Success. You can now start the database server using: 443s 443s pg_ctlcluster 12 main start 443s 443s Ver Cluster Port Status Owner Data directory Log file 443s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 443s 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 445s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 445s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 445s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 445s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 445s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 445s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 445s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 445s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 445s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 445s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 445s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 445s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 445s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 445s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 445s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 446s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 446s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 446s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 446s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 446s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 446s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 446s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 446s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up cpp (4:9.3.0-1ubuntu2) ... 446s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 446s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up gcc (4:9.3.0-1ubuntu2) ... 446s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 446s Setting up g++ (4:9.3.0-1ubuntu2) ... 446s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 446s Setting up build-essential (12.8ubuntu1.1) ... 446s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 446s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 446s Processing triggers for systemd (245.4-4ubuntu3.24) ... 446s Processing triggers for man-db (2.9.1-1) ... 448s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 449s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 458s autopkgtest [09:36:10]: test installcheck: [----------------------- 459s + dpkg-parsechangelog -SSource 459s + SOURCE=postgresql-12 459s + MAJOR=12 459s + cd src/test/regress 459s + make -f ../../../debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/12/bin/pg_config with_llvm=no 459s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -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 459s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -shared -o regress.so regress.o -L/usr/lib/x86_64-linux-gnu -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-10/lib -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed 459s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.DQH47B/build.Uf4/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 459s + rm -rf testtablespace results regression.* 459s + mkdir testtablespace results 459s + id -u 459s + [ 1000 = 0 ] 459s + pg_virtualenv -v 12 /usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule 459s Creating new PostgreSQL cluster 12/regress ... 459s /usr/lib/postgresql/12/bin/initdb -D /tmp/pg_virtualenv.mIfx04/data/12/regress --auth-local peer --auth-host md5 --username=ubuntu --pwfile=/tmp/pg_virtualenv.mIfx04/postgresql-common/pwfile --nosync 459s The files belonging to this database system will be owned by user "ubuntu". 459s This user must also own the server process. 459s 459s The database cluster will be initialized with locale "C.UTF-8". 459s The default database encoding has accordingly been set to "UTF8". 459s The default text search configuration will be set to "english". 459s 459s Data page checksums are disabled. 459s 459s fixing permissions on existing directory /tmp/pg_virtualenv.mIfx04/data/12/regress ... ok 459s creating subdirectories ... ok 459s selecting dynamic shared memory implementation ... posix 459s selecting default max_connections ... 100 459s selecting default shared_buffers ... 128MB 459s selecting default time zone ... Etc/UTC 459s creating configuration files ... ok 459s running bootstrap script ... ok 460s performing post-bootstrap initialization ... ok 460s 460s Sync to disk skipped. 460s The data directory might become corrupt if the operating system crashes. 460s 460s Success. You can now start the database server using: 460s 460s pg_ctlcluster 12 regress start 460s 460s Warning: The parent /var/run/postgresql of the selected 460s stats_temp_directory is not writable for the cluster owner. Not adding this 460s setting in postgresql.conf. 462s Ver Cluster Port Status Owner Data directory Log file 462s 12 regress 5433 online ubuntu /tmp/pg_virtualenv.mIfx04/data/12/regress /tmp/pg_virtualenv.mIfx04/log/postgresql-12-regress.log 462s 462s (using postmaster on localhost, port 5433) 462s ============== dropping database "regression" ============== 462s DROP DATABASE 462s NOTICE: database "regression" does not exist, skipping 462s ============== creating database "regression" ============== 462s CREATE DATABASE 462s ALTER DATABASE 462s ============== running regression test queries ============== 462s test tablespace ... ok 110 ms 463s parallel group (20 tests): char pg_lsn varchar regproc name oid uuid int2 int4 text money float4 txid int8 float8 enum bit boolean numeric rangetypes 463s boolean ... ok 346 ms 463s char ... ok 49 ms 463s name ... ok 127 ms 463s varchar ... ok 81 ms 463s text ... ok 139 ms 463s int2 ... ok 137 ms 463s int4 ... ok 139 ms 463s int8 ... ok 212 ms 463s oid ... ok 126 ms 463s float4 ... ok 197 ms 463s float8 ... ok 217 ms 463s bit ... ok 324 ms 463s numeric ... ok 433 ms 463s txid ... ok 205 ms 463s uuid ... ok 126 ms 463s enum ... ok 224 ms 463s money ... ok 148 ms 463s rangetypes ... ok 472 ms 463s pg_lsn ... ok 69 ms 463s regproc ... ok 93 ms 463s parallel group (19 tests): numerology circle path time line timetz macaddr lseg macaddr8 inet date tstypes box interval strings point timestamp timestamptz polygon 463s strings ... ok 255 ms 463s numerology ... ok 62 ms 463s point ... ok 269 ms 463s lseg ... ok 154 ms 463s line ... ok 119 ms 463s box ... ok 231 ms 463s path ... ok 111 ms 463s polygon ... ok 518 ms 463s circle ... ok 109 ms 463s date ... ok 189 ms 463s time ... ok 113 ms 463s timetz ... ok 129 ms 463s timestamp ... ok 448 ms 463s timestamptz ... ok 462 ms 463s interval ... ok 249 ms 463s inet ... ok 169 ms 463s macaddr ... ok 129 ms 463s macaddr8 ... ok 153 ms 463s tstypes ... ok 229 ms 464s parallel group (10 tests): comments misc_sanity expressions geometry database oidjoins type_sanity opr_sanity horology regex 464s geometry ... ok 296 ms 464s horology ... ok 480 ms 464s regex ... ok 487 ms 464s oidjoins ... ok 321 ms 464s type_sanity ... ok 340 ms 464s opr_sanity ... ok 461 ms 464s misc_sanity ... ok 114 ms 464s comments ... ok 85 ms 464s expressions ... ok 154 ms 464s database ... ok 300 ms 464s test create_function_1 ... ok 11 ms 464s test create_type ... ok 14 ms 464s test create_table ... ok 197 ms 464s test create_function_2 ... ok 10 ms 464s parallel group (5 tests): copydml copyselect insert_conflict insert copy 464s copy ... ok 264 ms 464s copyselect ... ok 57 ms 464s copydml ... ok 19 ms 464s insert ... ok 225 ms 464s insert_conflict ... ok 144 ms 464s parallel group (4 tests): create_operator create_schema create_procedure create_misc 464s create_misc ... ok 59 ms 464s create_operator ... ok 44 ms 464s create_procedure ... ok 51 ms 464s create_schema ... ok 46 ms 465s parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 465s create_index ... ok 997 ms 465s create_index_spgist ... ok 946 ms 465s create_view ... ok 313 ms 465s index_including ... ok 161 ms 465s index_including_gist ... ok 239 ms 466s parallel group (16 tests): typed_table create_function_3 create_aggregate create_cast roleattributes constraints drop_if_exists hash_func errors create_am select vacuum infinite_recurse updatable_views triggers inherit 466s create_aggregate ... ok 111 ms 466s create_function_3 ... ok 69 ms 466s create_cast ... ok 119 ms 466s constraints ... ok 143 ms 466s triggers ... ok 796 ms 466s select ... ok 375 ms 466s inherit ... ok 850 ms 466s typed_table ... ok 63 ms 466s vacuum ... ok 384 ms 466s drop_if_exists ... ok 180 ms 466s updatable_views ... ok 729 ms 466s roleattributes ... ok 136 ms 466s create_am ... ok 336 ms 466s hash_func ... ok 195 ms 466s errors ... ok 219 ms 466s infinite_recurse ... ok 451 ms 466s test sanity_check ... ok 92 ms 467s parallel group (20 tests): select_distinct select_into select_distinct_on random case select_having namespace delete select_implicit prepared_xacts union transactions subselect portals hash_index arrays aggregates btree_index update join 467s select_into ... ok 73 ms 467s select_distinct ... ok 52 ms 467s select_distinct_on ... ok 75 ms 467s select_implicit ... ok 154 ms 467s select_having ... ok 110 ms 467s subselect ... ok 533 ms 467s union ... ok 423 ms 467s case ... ok 97 ms 467s join ... ok 1082 ms 467s aggregates ... ok 691 ms 467s transactions ... ok 491 ms 467s random ... ok 94 ms 467s portals ... ok 533 ms 467s arrays ... ok 620 ms 467s btree_index ... ok 746 ms 467s hash_index ... ok 543 ms 467s update ... ok 861 ms 467s delete ... ok 148 ms 467s namespace ... ok 125 ms 467s prepared_xacts ... ok 234 ms 472s parallel group (20 tests): init_privs security_label password tablesample lock drop_operator object_address replica_identity identity matview gin generated rowsecurity collate groupingsets spgist gist join_hash brin privileges 472s brin ... ok 4732 ms 472s gin ... ok 936 ms 472s gist ... ok 1366 ms 472s spgist ... ok 1291 ms 472s privileges ... ok 4836 ms 472s init_privs ... ok 106 ms 472s security_label ... ok 128 ms 472s collate ... ok 1205 ms 472s matview ... ok 613 ms 472s lock ... ok 216 ms 472s replica_identity ... ok 316 ms 472s rowsecurity ... ok 1199 ms 472s object_address ... ok 281 ms 472s tablesample ... ok 213 ms 472s groupingsets ... ok 1217 ms 472s drop_operator ... ok 273 ms 472s password ... ok 197 ms 472s identity ... ok 611 ms 472s generated ... ok 954 ms 472s join_hash ... ok 4725 ms 473s parallel group (11 tests): dbsize tidscan tid async alter_operator sysviews tsrf alter_generic misc_functions create_table_like misc 473s create_table_like ... ok 252 ms 473s alter_generic ... ok 160 ms 473s alter_operator ... ok 115 ms 473s misc ... ok 644 ms 473s async ... ok 79 ms 473s dbsize ... ok 66 ms 473s misc_functions ... ok 178 ms 473s sysviews ... ok 126 ms 473s tsrf ... ok 141 ms 473s tid ... ok 72 ms 473s tidscan ... ok 68 ms 473s parallel group (5 tests): amutils psql_crosstab psql rules stats_ext 473s rules ... ok 193 ms 473s psql ... ok 170 ms 473s psql_crosstab ... ok 38 ms 473s amutils ... ok 27 ms 473s stats_ext ... ok 569 ms 475s test select_parallel ... ok 1706 ms 475s test write_parallel ... ok 49 ms 475s parallel group (2 tests): subscription publication 475s publication ... ok 42 ms 475s subscription ... ok 15 ms 477s parallel group (17 tests): portals_p2 functional_deps advisory_lock combocid equivclass dependency xmlmap tsdicts select_views guc window cluster bitmapops foreign_data indirect_toast tsearch foreign_key 477s select_views ... ok 290 ms 477s portals_p2 ... ok 37 ms 477s foreign_key ... ok 1064 ms 477s cluster ... ok 636 ms 477s dependency ... ok 198 ms 477s guc ... ok 326 ms 477s bitmapops ... ok 663 ms 477s combocid ... ok 154 ms 477s tsearch ... ok 975 ms 477s tsdicts ... ok 250 ms 477s foreign_data ... ok 895 ms 477s window ... ok 483 ms 477s xmlmap ... ok 203 ms 477s functional_deps ... ok 131 ms 477s advisory_lock ... ok 139 ms 477s indirect_toast ... ok 899 ms 477s equivclass ... ok 192 ms 477s parallel group (6 tests): json_encoding jsonpath_encoding jsonpath jsonb_jsonpath json jsonb 477s json ... ok 111 ms 477s jsonb ... ok 185 ms 477s json_encoding ... ok 17 ms 477s jsonpath ... ok 80 ms 477s jsonpath_encoding ... ok 30 ms 477s jsonb_jsonpath ... ok 94 ms 478s parallel group (18 tests): conversion prepare limit returning rowtypes plancache with truncate temp copy2 sequence polymorphism largeobject domain xml rangefuncs plpgsql alter_table 478s plancache ... ok 411 ms 478s limit ... ok 196 ms 478s plpgsql ... ok 882 ms 478s copy2 ... ok 529 ms 478s temp ... ok 493 ms 478s domain ... ok 718 ms 478s rangefuncs ... ok 872 ms 478s prepare ... ok 129 ms 478s conversion ... ok 61 ms 478s truncate ... ok 456 ms 478s alter_table ... ok 1254 ms 478s sequence ... ok 548 ms 478s polymorphism ... ok 578 ms 478s rowtypes ... ok 303 ms 478s returning ... ok 209 ms 478s largeobject ... ok 672 ms 478s with ... ok 447 ms 478s xml ... ok 841 ms 479s parallel group (7 tests): hash_part reloptions partition_info partition_join indexing partition_aggregate partition_prune 479s partition_join ... ok 406 ms 479s partition_prune ... ok 1015 ms 479s reloptions ... ok 84 ms 479s hash_part ... ok 71 ms 479s indexing ... ok 711 ms 479s partition_aggregate ... ok 750 ms 479s partition_info ... ok 98 ms 479s test event_trigger ... ok 59 ms 479s test fast_default ... ok 74 ms 479s test stats ... ok 564 ms 479s 479s ======================= 479s All 196 tests passed. 479s ======================= 479s 479s Dropping cluster 12/regress ... 480s autopkgtest [09:36:32]: test installcheck: -----------------------] 480s autopkgtest [09:36:32]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 480s installcheck PASS 482s autopkgtest [09:36:34]: @@@@@@@@@@@@@@@@@@@@ summary 482s run-testsuite FAIL non-zero exit status 1 482s installcheck PASS 501s nova [W] Skipping flock for amd64 501s Creating nova instance adt-focal-amd64-postgresql-12-20250328-092832-juju-7f2275-prod-proposed-migration-environment-20-0b202394-55bc-4d7d-a55f-f411b651bf85 from image adt/ubuntu-focal-amd64-server-20250327.img (UUID 2c739713-02da-4cfc-8587-ee5b3e4cbe1e)... 501s nova [W] Timed out waiting for e98d1997-292e-47df-8651-926b57f59e48 to get deleted. 501s nova [W] Skipping flock for amd64 501s Creating nova instance adt-focal-amd64-postgresql-12-20250328-092832-juju-7f2275-prod-proposed-migration-environment-20-0b202394-55bc-4d7d-a55f-f411b651bf85 from image adt/ubuntu-focal-amd64-server-20250327.img (UUID 2c739713-02da-4cfc-8587-ee5b3e4cbe1e)... 501s nova [W] Timed out waiting for ae6ab249-c453-4415-93d9-46b5b9eba48d to get deleted.