0s autopkgtest [00:01:53]: starting date and time: 2025-02-27 00:01:53+0000 0s autopkgtest [00:01:53]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [00:01:53]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.stybblvn/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-12 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025a-0ubuntu0.20.04 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-16.secgroup --name adt-focal-amd64-postgresql-12-20250227-000152-juju-7f2275-prod-proposed-migration-environment-20-2f9aedc8-eb4f-49c5-8cb5-e9a7e14fa765 --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/ 249s autopkgtest [00:06:02]: testbed dpkg architecture: amd64 249s autopkgtest [00:06:02]: testbed apt version: 2.0.10 249s autopkgtest [00:06:02]: @@@@@@@@@@@@@@@@@@@@ test bed setup 249s autopkgtest [00:06:02]: testbed release detected to be: None 251s autopkgtest [00:06:03]: updating testbed package index (apt update) 251s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 251s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 251s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 251s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 251s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 251s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 251s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 251s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 251s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [82.1 kB] 251s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [339 kB] 251s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1436 B] 251s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [4568 B] 251s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [529 kB] 252s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 252s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [24.4 kB] 252s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [42.1 kB] 252s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1772 B] 252s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [2652 B] 252s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [10.7 kB] 252s Get:20 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [312 B] 256s Fetched 1419 kB in 1s (1087 kB/s) 256s Reading package lists... 257s Reading package lists... 257s Building dependency tree... 257s Reading state information... 257s Calculating upgrade... 257s The following packages will be upgraded: 257s binutils binutils-common binutils-x86-64-linux-gnu libbinutils libctf-nobfd0 257s libctf0 pollinate 258s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 258s Need to get 2405 kB of archives. 258s After this operation, 34.8 kB disk space will be freed. 258s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libctf0 amd64 2.34-6ubuntu1.10 [46.7 kB] 258s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils-x86-64-linux-gnu amd64 2.34-6ubuntu1.10 [1613 kB] 258s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libbinutils amd64 2.34-6ubuntu1.10 [474 kB] 258s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils amd64 2.34-6ubuntu1.10 [3380 B] 258s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils-common amd64 2.34-6ubuntu1.10 [208 kB] 258s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libctf-nobfd0 amd64 2.34-6ubuntu1.10 [48.1 kB] 258s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main amd64 pollinate all 4.33-3ubuntu1.20.04.2 [12.3 kB] 258s Fetched 2405 kB in 1s (3499 kB/s) 259s (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 ... 97383 files and directories currently installed.) 259s Preparing to unpack .../0-libctf0_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking libctf0:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../1-binutils-x86-64-linux-gnu_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking binutils-x86-64-linux-gnu (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../2-libbinutils_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking libbinutils:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../3-binutils_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking binutils (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../4-binutils-common_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking binutils-common:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../5-libctf-nobfd0_2.34-6ubuntu1.10_amd64.deb ... 259s Unpacking libctf-nobfd0:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 259s Preparing to unpack .../6-pollinate_4.33-3ubuntu1.20.04.2_all.deb ... 259s Unpacking pollinate (4.33-3ubuntu1.20.04.2) over (4.33-3ubuntu1.20.04.1) ... 259s Setting up binutils-common:amd64 (2.34-6ubuntu1.10) ... 259s Setting up libctf-nobfd0:amd64 (2.34-6ubuntu1.10) ... 259s Setting up pollinate (4.33-3ubuntu1.20.04.2) ... 260s Setting up libbinutils:amd64 (2.34-6ubuntu1.10) ... 260s Setting up libctf0:amd64 (2.34-6ubuntu1.10) ... 260s Setting up binutils-x86-64-linux-gnu (2.34-6ubuntu1.10) ... 260s Setting up binutils (2.34-6ubuntu1.10) ... 260s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 260s Processing triggers for man-db (2.9.1-1) ... 261s Reading package lists...autopkgtest [00:06:14]: upgrading testbed (apt dist-upgrade and autopurge) 261s 261s Building dependency tree... 261s Reading state information... 261s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 261s Reading package lists... 261s Building dependency tree... 261s Reading state information... 261s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 261s Starting 2 pkgProblemResolver with broken count: 0 261s Done 261s 261s The following packages will be upgraded: 261s tzdata 262s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 262s Need to get 300 kB of archives. 262s After this operation, 3072 B of additional disk space will be used. 262s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 tzdata all 2025a-0ubuntu0.20.04 [300 kB] 262s Preconfiguring packages ... 262s Fetched 300 kB in 0s (734 kB/s) 262s (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 ... 97383 files and directories currently installed.) 262s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 262s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 262s Setting up tzdata (2025a-0ubuntu0.20.04) ... 263s 263s Current default time zone: 'Etc/UTC' 263s Local time is now: Thu Feb 27 00:06:16 UTC 2025. 263s Universal Time is now: Thu Feb 27 00:06:16 UTC 2025. 263s Run 'dpkg-reconfigure tzdata' if you wish to change it. 263s 263s Reading package lists... 263s Building dependency tree... 263s Reading state information... 263s Starting pkgProblemResolver with broken count: 0 263s Starting 2 pkgProblemResolver with broken count: 0 263s Done 263s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 264s autopkgtest [00:06:17]: rebooting testbed after setup commands that affected boot 288s autopkgtest [00:06:41]: testbed running kernel: Linux 5.4.0-208-generic #228-Ubuntu SMP Fri Feb 7 19:41:33 UTC 2025 290s autopkgtest [00:06:43]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-12 302s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (dsc) [3764 B] 302s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (tar) [27.9 MB] 302s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-12 12.22-0ubuntu0.20.04.1 (diff) [31.2 kB] 303s gpgv: Signature made Wed Nov 27 17:17:35 2024 UTC 303s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 303s gpgv: Can't check signature: No public key 303s dpkg-source: warning: failed to verify signature on ./postgresql-12_12.22-0ubuntu0.20.04.1.dsc 304s autopkgtest [00:06:57]: testing package postgresql-12 version 12.22-0ubuntu0.20.04.1 305s autopkgtest [00:06:58]: build not needed 312s autopkgtest [00:07:05]: test run-testsuite: preparing testbed 312s Reading package lists... 313s Building dependency tree... 313s Reading state information... 313s Starting pkgProblemResolver with broken count: 0 313s Starting 2 pkgProblemResolver with broken count: 0 313s Done 313s The following NEW packages will be installed: 313s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 313s emacsen-common g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us lib32gcc-s1 313s lib32stdc++6 libasan5 libatomic1 libc-dev-bin libc6-dev libc6-i386 libcc1-0 313s libclang-common-10-dev libclang-cpp10 libclang1-10 libcrypt-dev 313s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1c2 libgcc-9-dev 313s libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 libncurses-dev 313s libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.8 313s libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 libubsan1 313s libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 313s llvm-10-runtime llvm-10-tools net-tools postgresql-12 postgresql-client-12 313s postgresql-client-common postgresql-common postgresql-doc-12 313s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 313s postgresql-server-dev-12 python3-pygments ssl-cert 313s 0 upgraded, 71 newly installed, 0 to remove and 0 not upgraded. 313s Need to get 143 MB of archives. 313s After this operation, 752 MB of additional disk space will be used. 313s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 313s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 313s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-208.228 [1118 kB] 314s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 314s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 314s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 314s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 314s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 314s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 314s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 314s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 314s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 314s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 314s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 314s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 314s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 314s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 314s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 314s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 314s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 315s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 315s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 315s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 315s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 315s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 315s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 315s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 315s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 316s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 316s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 316s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 316s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 316s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 316s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 316s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 316s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 316s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 316s Get:38 http://ftpmaster.internal/ubuntu focal/main amd64 emacsen-common all 3.0.4 [14.9 kB] 316s Get:39 http://ftpmaster.internal/ubuntu focal/main amd64 dictionaries-common all 1.28.1 [178 kB] 316s Get:40 http://ftpmaster.internal/ubuntu focal/main amd64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 316s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.1 [45.7 kB] 316s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.1 [117 kB] 316s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.1 [43.4 kB] 316s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.1 [12.7 kB] 316s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.1 [137 kB] 316s Get:46 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.1 [239 kB] 316s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 316s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.15 [1626 kB] 316s Get:49 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 316s Get:50 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 316s Get:51 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.1 [151 kB] 316s Get:52 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 316s Get:53 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 316s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 316s Get:55 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 316s Get:56 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 316s Get:57 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 316s Get:58 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 317s Get:59 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 317s Get:60 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 317s Get:61 http://ftpmaster.internal/ubuntu focal/main amd64 net-tools amd64 1.60+git20180626.aebd88e-1ubuntu1 [196 kB] 317s Get:62 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 317s Get:63 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.1 [1056 kB] 317s Get:64 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 317s Get:65 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 317s Get:66 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.1 [13.6 MB] 318s Get:67 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 318s Get:68 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.1 [68.4 kB] 318s Get:69 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.1 [76.7 kB] 318s Get:70 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.1 [31.6 kB] 318s Get:71 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.1 [992 kB] 319s Preconfiguring packages ... 319s Fetched 143 MB in 5s (26.8 MB/s) 319s Selecting previously unselected package binfmt-support. 319s (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 ... 97384 files and directories currently installed.) 319s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 319s Unpacking binfmt-support (2.2.0-2) ... 319s Selecting previously unselected package libc-dev-bin. 319s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 319s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 319s Selecting previously unselected package linux-libc-dev:amd64. 319s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_amd64.deb ... 319s Unpacking linux-libc-dev:amd64 (5.4.0-208.228) ... 319s Selecting previously unselected package libcrypt-dev:amd64. 319s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 319s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 319s Selecting previously unselected package libc6-dev:amd64. 319s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 319s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 320s Selecting previously unselected package gcc-9-base:amd64. 320s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 320s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 320s Selecting previously unselected package libisl22:amd64. 320s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 320s Unpacking libisl22:amd64 (0.22.1-1) ... 320s Selecting previously unselected package libmpc3:amd64. 320s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 320s Unpacking libmpc3:amd64 (1.1.0-1) ... 320s Selecting previously unselected package cpp-9. 320s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 320s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 320s Selecting previously unselected package cpp. 320s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 320s Unpacking cpp (4:9.3.0-1ubuntu2) ... 320s Selecting previously unselected package libcc1-0:amd64. 320s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 320s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 320s Selecting previously unselected package libgomp1:amd64. 320s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 320s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 320s Selecting previously unselected package libitm1:amd64. 320s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 320s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 320s Selecting previously unselected package libatomic1:amd64. 320s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 320s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 320s Selecting previously unselected package libasan5:amd64. 320s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 320s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 321s Selecting previously unselected package liblsan0:amd64. 321s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 321s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 321s Selecting previously unselected package libtsan0:amd64. 321s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 321s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 321s Selecting previously unselected package libubsan1:amd64. 321s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 321s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 321s Selecting previously unselected package libquadmath0:amd64. 321s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 321s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 321s Selecting previously unselected package libgcc-9-dev:amd64. 321s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 321s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 321s Selecting previously unselected package gcc-9. 321s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 321s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 322s Selecting previously unselected package gcc. 322s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 322s Unpacking gcc (4:9.3.0-1ubuntu2) ... 322s Selecting previously unselected package libstdc++-9-dev:amd64. 322s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 322s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 322s Selecting previously unselected package g++-9. 322s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 322s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 323s Selecting previously unselected package g++. 323s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 323s Unpacking g++ (4:9.3.0-1ubuntu2) ... 323s Selecting previously unselected package build-essential. 323s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 323s Unpacking build-essential (12.8ubuntu1.1) ... 323s Selecting previously unselected package libllvm10:amd64. 323s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 323s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 324s Selecting previously unselected package libclang-cpp10. 324s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 324s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 325s Selecting previously unselected package libgc1c2:amd64. 325s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 325s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 325s Selecting previously unselected package libobjc4:amd64. 325s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 325s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 325s Selecting previously unselected package libobjc-9-dev:amd64. 325s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 325s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 325s Selecting previously unselected package libc6-i386. 325s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 325s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 325s Selecting previously unselected package lib32gcc-s1. 325s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 325s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 325s Selecting previously unselected package lib32stdc++6. 325s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 325s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 325s Selecting previously unselected package libclang-common-10-dev. 325s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 325s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 325s Selecting previously unselected package libclang1-10. 325s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 325s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 326s Selecting previously unselected package clang-10. 326s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 326s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 326s Selecting previously unselected package emacsen-common. 326s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 326s Unpacking emacsen-common (3.0.4) ... 326s Selecting previously unselected package dictionaries-common. 326s Preparing to unpack .../38-dictionaries-common_1.28.1_all.deb ... 326s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 326s Unpacking dictionaries-common (1.28.1) ... 326s Selecting previously unselected package hunspell-en-us. 326s Preparing to unpack .../39-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 326s Unpacking hunspell-en-us (1:2018.04.16-1) ... 326s Selecting previously unselected package libpgtypes3:amd64. 326s Preparing to unpack .../40-libpgtypes3_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libpq5:amd64. 326s Preparing to unpack .../41-libpq5_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libecpg6:amd64. 326s Preparing to unpack .../42-libecpg6_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libecpg-compat3:amd64. 326s Preparing to unpack .../43-libecpg-compat3_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libpq-dev. 326s Preparing to unpack .../44-libpq-dev_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libecpg-dev. 326s Preparing to unpack .../45-libecpg-dev_12.22-0ubuntu0.20.04.1_amd64.deb ... 326s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 326s Selecting previously unselected package libncurses-dev:amd64. 326s Preparing to unpack .../46-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 326s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 326s Selecting previously unselected package libpython3.8:amd64. 326s Preparing to unpack .../47-libpython3.8_3.8.10-0ubuntu1~20.04.15_amd64.deb ... 326s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.15) ... 326s Selecting previously unselected package libtcl8.6:amd64. 327s Preparing to unpack .../48-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 327s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 327s Selecting previously unselected package libtinfo-dev:amd64. 327s Preparing to unpack .../49-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 327s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 327s Selecting previously unselected package libxslt1.1:amd64. 327s Preparing to unpack .../50-libxslt1.1_1.1.34-4ubuntu0.20.04.1_amd64.deb ... 327s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.1) ... 327s Selecting previously unselected package llvm-10-runtime. 327s Preparing to unpack .../51-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 327s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 327s Selecting previously unselected package libpfm4:amd64. 327s Preparing to unpack .../52-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 327s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 327s Selecting previously unselected package llvm-10. 327s Preparing to unpack .../53-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 327s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 327s Selecting previously unselected package libffi-dev:amd64. 327s Preparing to unpack .../54-libffi-dev_3.3-4_amd64.deb ... 327s Unpacking libffi-dev:amd64 (3.3-4) ... 327s Selecting previously unselected package python3-pygments. 327s Preparing to unpack .../55-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 327s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 327s Selecting previously unselected package llvm-10-tools. 327s Preparing to unpack .../56-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 327s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 327s Selecting previously unselected package libz3-4:amd64. 327s Preparing to unpack .../57-libz3-4_4.8.7-4build1_amd64.deb ... 327s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 328s Selecting previously unselected package libz3-dev:amd64. 328s Preparing to unpack .../58-libz3-dev_4.8.7-4build1_amd64.deb ... 328s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 328s Selecting previously unselected package llvm-10-dev. 328s Preparing to unpack .../59-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 328s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 330s Selecting previously unselected package net-tools. 330s Preparing to unpack .../60-net-tools_1.60+git20180626.aebd88e-1ubuntu1_amd64.deb ... 330s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 330s Selecting previously unselected package postgresql-client-common. 330s Preparing to unpack .../61-postgresql-client-common_214ubuntu0.1_all.deb ... 330s Unpacking postgresql-client-common (214ubuntu0.1) ... 330s Selecting previously unselected package postgresql-client-12. 330s Preparing to unpack .../62-postgresql-client-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 330s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 330s Selecting previously unselected package ssl-cert. 330s Preparing to unpack .../63-ssl-cert_1.0.39_all.deb ... 330s Unpacking ssl-cert (1.0.39) ... 330s Selecting previously unselected package postgresql-common. 330s Preparing to unpack .../64-postgresql-common_214ubuntu0.1_all.deb ... 330s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 330s Unpacking postgresql-common (214ubuntu0.1) ... 330s Selecting previously unselected package postgresql-12. 330s Preparing to unpack .../65-postgresql-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 330s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 331s Selecting previously unselected package postgresql-doc-12. 331s Preparing to unpack .../66-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 331s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 332s Selecting previously unselected package postgresql-plperl-12. 332s Preparing to unpack .../67-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 332s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 332s Selecting previously unselected package postgresql-plpython3-12. 332s Preparing to unpack .../68-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 332s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 332s Selecting previously unselected package postgresql-pltcl-12. 332s Preparing to unpack .../69-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 332s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 332s Selecting previously unselected package postgresql-server-dev-12. 332s Preparing to unpack .../70-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 332s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 332s Setting up postgresql-client-common (214ubuntu0.1) ... 332s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.1) ... 332s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 332s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 332s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.1) ... 332s Setting up linux-libc-dev:amd64 (5.4.0-208.228) ... 332s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 332s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 332s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 332s Setting up libffi-dev:amd64 (3.3-4) ... 332s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 332s 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 332s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 332s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 332s Setting up libz3-4:amd64 (4.8.7-4build1) ... 332s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 333s 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 333s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 333s Setting up emacsen-common (3.0.4) ... 333s Setting up ssl-cert (1.0.39) ... 333s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 333s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.15) ... 333s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 333s Setting up postgresql-common (214ubuntu0.1) ... 333s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 333s Adding user postgres to group ssl-cert 333s 333s Creating config file /etc/postgresql-common/createcluster.conf with new version 334s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 334s en_us 334s Removing obsolete dictionary files: 334s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 334s Setting up libmpc3:amd64 (1.1.0-1) ... 334s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 335s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 335s Setting up binfmt-support (2.2.0-2) ... 335s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 335s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 335s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 335s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.1) ... 335s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.1) ... 335s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 335s Setting up libisl22:amd64 (0.22.1-1) ... 335s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 335s Creating new PostgreSQL cluster 12/main ... 335s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 335s The files belonging to this database system will be owned by user "postgres". 335s This user must also own the server process. 335s 335s The database cluster will be initialized with locale "C.UTF-8". 335s The default database encoding has accordingly been set to "UTF8". 335s The default text search configuration will be set to "english". 335s 335s Data page checksums are disabled. 335s 335s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 335s creating subdirectories ... ok 335s selecting dynamic shared memory implementation ... posix 335s selecting default max_connections ... 100 335s selecting default shared_buffers ... 128MB 335s selecting default time zone ... Etc/UTC 335s creating configuration files ... ok 335s running bootstrap script ... ok 336s performing post-bootstrap initialization ... ok 336s syncing data to disk ... ok 336s 336s Success. You can now start the database server using: 336s 336s pg_ctlcluster 12 main start 336s 336s Ver Cluster Port Status Owner Data directory Log file 336s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 336s 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 339s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 339s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 339s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 339s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 339s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 339s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 339s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 339s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 339s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.1) ... 339s Setting up dictionaries-common (1.28.1) ... 339s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 339s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 339s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 339s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 339s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 339s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 339s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 339s Setting up hunspell-en-us (1:2018.04.16-1) ... 339s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 339s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 339s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 339s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 339s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 339s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up cpp (4:9.3.0-1ubuntu2) ... 339s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 339s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up gcc (4:9.3.0-1ubuntu2) ... 339s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 339s Setting up g++ (4:9.3.0-1ubuntu2) ... 339s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 339s Setting up build-essential (12.8ubuntu1.1) ... 339s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 339s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 339s Processing triggers for systemd (245.4-4ubuntu3.24) ... 339s Processing triggers for man-db (2.9.1-1) ... 342s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 342s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 342s Processing triggers for dictionaries-common (1.28.1) ... 345s autopkgtest [00:07:38]: test run-testsuite: [----------------------- 345s Generating locales (this might take a while)... 347s en_US.UTF-8... done 347s ru_RU.ISO-8859-5... done 349s ru_RU.UTF-8... done 349s Generation complete. 349s ====== Running all tests with umask 077 ======= 349s === Running test 001_packages.t ... === 349s 1..18 349s # PostgreSQL versions installed: 12 349s ok 1 - postgresql-12 installed 349s ok 2 # skip No python2 support 349s ok 3 - postgresql-plpython3-12 installed 349s ok 4 - postgresql-plperl-12 installed 349s ok 5 - postgresql-pltcl-12 installed 349s ok 6 - postgresql-server-dev-12 installed 349s ok 7 # skip No postgresql-contrib-12 package for version 12 349s ok 8 - libecpg-dev installed 349s ok 9 - procps installed 349s ok 10 - netcat-openbsd installed 349s ok 11 - hunspell-en-us installed 349s ok 12 - system has a default UTF-8 locale 349s ok 13 - locale ru_RU exists 349s ok 14 - locale ru_RU.UTF-8 exists 349s ok 15 - user postgres in the UNIX group ssl-cert 349s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 349s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 349s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 349s === Running test 002_existing_clusters.t ... === 349s 1..8 349s ok 1 - Cleanup: No clusters left behind 349s ok 2 - No postgres processes left behind 349s ok 3 - No files in /etc/postgresql left behind 349s ok 4 - No files in /var/lib/postgresql left behind 349s ok 5 - No files in /var/run/postgresql left behind 349s ok 6 - No files in /var/log/postgresql left behind 349s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 349s ok 8 - PostgreSQL TCP ports are closed 349s === Running test 003_package_checks.t ... === 349s 1..4 349s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 349s ok 2 - psql is linked against libedit 349s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 349s ok 4 - psql is not linked against libreadline 349s === Running test 005_PgCommon.t ... === 349s 1..24 349s ok 1 - correctly parsed line 'local all postgres ident sameuser' 349s ok 2 - correctly parsed line 'local foo nobody trust' 349s ok 3 - correctly parsed line 'local foo nobody crypt' 349s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 349s ok 5 - correctly parsed line 'local foo,bar nobody ident' 349s ok 6 - correctly parsed line 'local all +foogrp password' 349s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 349s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 349s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 349s ok 10 - @expected_records has correct number of entries 349s ok 11 - returned read_pg_hba array has correct number of records 349s ok 12 - line 'foo all all md5' parsed as invalid 349s ok 13 - line 'local all all foo' parsed as invalid 349s ok 14 - line 'host all all foo' parsed as invalid 349s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 349s ok 16 - line 'host all all md5' parsed as invalid 349s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 349s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 349s ok 19 - read_conf_file returns empty dict for nonexisting file 349s ok 20 - read_conf_file() parsing 349s ok 21 - read_conf_file() parsing with include directives 349s ok 22 - set_conf_value 349s ok 23 - disable_conf_value 349s ok 24 - replace_conf_value 349s === Running test 006_next_free_port.t ... === 349s 1..5 349s ok 1 - next_free_port is 5432 350s ok 2 - next_free_port detects localhost ipv4 socket 351s ok 3 - next_free_port detects wildcard ipv4 socket 351s ok 4 - next_free_port detects localhost ipv6 socket 352s ok 5 - next_free_port detects wildcard ipv6 socket 352s === Running test 007_pg_conftool.t ... === 352s 1..41 352s # test without cluster 352s ok 1 - pg_conftool show all 352s ok 2 - correct output of pg_conftool show all 352s ok 3 - pg_conftool foo.conf show all 352s ok 4 - correct output of pg_conftool foo.conf show all 352s ok 5 - pg_conftool /tmp/tmVCL5U_0Z/different.conf show all 352s ok 6 - correct output of pg_conftool /tmp/tmVCL5U_0Z/different.conf show all 352s ok 7 - pg_conftool 9.7 main show all 352s ok 8 - correct output of pg_conftool 9.7 main show all 352s # test show 352s ok 9 - pg_conftool show all 352s ok 10 - correct output of pg_conftool show all 352s ok 11 - pg_conftool other.conf show all 352s ok 12 - correct output of pg_conftool other.conf show all 352s ok 13 - pg_conftool /tmp/tmVCL5U_0Z/different.conf show all 352s ok 14 - correct output of pg_conftool /tmp/tmVCL5U_0Z/different.conf show all 352s ok 15 - pg_conftool 12 main show all 352s ok 16 - correct output of pg_conftool 12 main show all 352s ok 17 - pg_conftool 12 main other.conf show all 352s ok 18 - correct output of pg_conftool 12 main other.conf show all 352s ok 19 - pg_conftool show a 352s ok 20 - correct output of pg_conftool show a 352s ok 21 - pg_conftool -s show a 352s ok 22 - correct output of pg_conftool -s show a 352s # test set 352s ok 23 - pg_conftool set c 7 352s ok 24 - correct output of pg_conftool set c 7 352s ok 25 - file contains new setting 352s ok 26 - pg_conftool set a 8 352s ok 27 - correct output of pg_conftool set a 8 352s ok 28 - file contains updated setting 352s ok 29 - pg_conftool /tmp/tmVCL5U_0Z/different.conf set a 9 352s ok 30 - correct output of pg_conftool /tmp/tmVCL5U_0Z/different.conf set a 9 352s ok 31 - file with path contains updated setting 352s # test remove 352s ok 32 - pg_conftool remove a 352s ok 33 - correct output of pg_conftool remove a 352s ok 34 - setting removed from file 352s ok 35 - pg_conftool /tmp/tmVCL5U_0Z/different.conf remove a 352s ok 36 - correct output of pg_conftool /tmp/tmVCL5U_0Z/different.conf remove a 352s ok 37 - setting removed from file with path 352s # test edit 352s ok 38 - pg_conftool edit 352s ok 39 - correct output of pg_conftool edit 353s ok 40 - pg_conftool /tmp/tmVCL5U_0Z/different.conf edit 353s ok 41 - correct output of pg_conftool /tmp/tmVCL5U_0Z/different.conf edit 353s === Running test 010_defaultport_cluster.t ... === 353s 1..14 353s ok 1 - psql --version 353s ok 2 - pg_wrapper selects highest available version number 353s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 353s ok 4 - connecting to localhost fails with no clusters 353s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 353s ok 6 - pg_wrapper uses host and port from PGCLUSTER 353s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 353s ok 8 - pg_wrapper uses --cluster from the command line 353s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 353s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 353s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 353s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 353s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 353s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 353s === Running test 015_start_stop.t ... === 353s 1..71 353s # We are running systemd 353s # Running tests for 12 353s # Cluster does not exist yet 353s ok 1 - cluster 12 main does not exist 353s ok 2 - service postgresql@12-main does not exist 353s ok 3 - systemctl start postgresql 353s ok 4 - cluster 12 main does not exist 353s ok 5 - service postgresql@12-main does not exist 353s ok 6 - systemctl start postgresql@12-main 353s ok 7 - cluster 12 main does not exist 353s ok 8 - service postgresql@12-main does not exist 353s # Start/stop postgresql using system tools 354s ok 9 - pg_createcluster 12 main 354s ok 10 - cluster 12 main is stopped 354s ok 11 - service postgresql@12-main is stopped 356s ok 12 - systemctl start postgresql 356s ok 13 - cluster 12 main is running 356s ok 14 - service postgresql@12-main is running 356s ok 15 - systemctl start postgresql 356s ok 16 - cluster 12 main is already running 356s ok 17 - service postgresql@12-main is already running 356s ok 18 - systemctl stop postgresql 362s ok 19 - cluster 12 main is stopped 362s ok 20 - service postgresql@12-main is stopped 362s ok 21 - systemctl stop postgresql 362s ok 22 - cluster 12 main is already stopped 362s ok 23 - service postgresql@12-main is already stopped 362s # Start/stop specific cluster using system tools 364s ok 24 - systemctl start postgresql@12-main 364s ok 25 - cluster 12 main is running 364s ok 26 - service postgresql@12-main is running 364s ok 27 - systemctl start postgresql@12-main 364s ok 28 - cluster 12 main is running 364s ok 29 - service postgresql@12-main is running 367s ok 30 - systemctl restart postgresql@12-main 367s ok 31 - cluster 12 main is running 367s ok 32 - service postgresql@12-main is running 367s ok 33 - systemctl stop postgresql@12-main 367s ok 34 - cluster 12 main is stopped 367s ok 35 - service postgresql@12-main is stopped 367s ok 36 - systemctl stop postgresql@12-main 367s ok 37 - cluster 12 main is already stopped 367s ok 38 - service postgresql@12-main is already stopped 368s ok 39 - pg_dropcluster 12 main 368s ok 40 - cluster 12 main does not exist 368s ok 41 - service postgresql@12-main does not exist 368s # Start/stop specific cluster using pg_*cluster 368s ok 42 - pg_ctlcluster start 12 main 368s ok 43 - cluster 12 main does not exist 368s ok 44 - service postgresql@12-main does not exist 371s ok 45 - pg_createcluster 12 main --start 371s ok 46 - cluster 12 main is running 371s ok 47 - service postgresql@12-main is running 371s ok 48 - pg_ctlcluster 12 main start 371s ok 49 - cluster 12 main is already running 371s ok 50 - service postgresql@12-main is already running 373s ok 51 - pg_ctlcluster 12-main restart 373s ok 52 - cluster 12 main is running 373s ok 53 - service postgresql@12-main is running 373s ok 54 - pg_ctlcluster 12 main stop 373s ok 55 - cluster 12 main is stopped 373s ok 56 - service postgresql@12-main is stopped 375s ok 57 - pg_ctlcluster 12 main stop 375s ok 58 - cluster 12 main is already stopped 375s ok 59 - service postgresql@12-main is already stopped 376s ok 60 - pg_ctlcluster start 12-main 376s ok 61 - cluster 12 main is running 376s ok 62 - service postgresql@12-main is running 376s ok 63 - pg_dropcluster 12 main --stop 376s ok 64 - Cleanup: No clusters left behind 376s ok 65 - No postgres processes left behind 376s ok 66 - No files in /etc/postgresql left behind 376s ok 67 - No files in /var/lib/postgresql left behind 376s ok 68 - No files in /var/run/postgresql left behind 376s ok 69 - No files in /var/log/postgresql left behind 376s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 376s ok 71 - PostgreSQL TCP ports are closed 376s === Running test 020_create_sql_remove.t ... === 376s 1..144 376s # Running tests for 12 379s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog._TVsjR 379s ok 2 - pg_createcluster 12 main 379s ok 3 - Socket and pid file are in /var/run/postgresql/ 379s ok 4 - xlog/wal directory /tmp/12.xlog._TVsjR was created 379s ok 5 - Exactly one postgres master process running 381s ok 6 - pg_ctlcluster 12 main restart 381s ok 7 - cluster restarts with new environment file 381s ok 8 - Exactly one postgres master process running 381s ok 9 - correct value of PGEXTRAVAR1 in environment 381s ok 10 - correct value of PGEXTRAVAR2 in environment 381s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 382s ok 12 - createdb --version 382s ok 13 - pg_wrapper selects version number of cluster 382s ok 14 - psql --version 382s ok 15 - pg_wrapper selects version number of cluster 382s ok 16 - pg_lscluster reports online cluster on port 5432 382s ok 17 - log file is actually used 382s ok 18 - /etc/postgresql is owned by user "postgres" 382s ok 19 - version configuration directory file is owned by user "postgres" 382s ok 20 - configuration directory file is owned by user "postgres" 382s ok 21 - version data directory file is owned by user "postgres" 382s ok 22 - data directory file is owned by user "postgres" 382s ok 23 - log file has 0640 permissions 382s ok 24 - log file is owned by user "postgres" 382s ok 25 - log file is owned by group "adm" 382s ok 26 - no log symlink by default 382s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 382s ok 28 - pg_lsclusters -h 382s ok 29 - correct output of pg_lsclusters -h 382s ok 30 - stopping cluster 384s ok 31 - restarting cluster with nondefault log symlink 384s ok 32 - log target is used as log file 384s ok 33 - default log is not used 384s ok 34 - pg_lsclusters -h 384s ok 35 - correct output of pg_lsclusters -h 385s ok 36 - stopping cluster 387s ok 37 - restarting cluster with explicitly configured log file 387s ok 38 - default log is not used 387s ok 39 - log symlink target is used for startup message 387s ok 40 - exactly one log file 387s ok 41 - custom log is actually used 387s ok 42 - pg_lsclusters -h 387s ok 43 - correct output of pg_lsclusters -h 387s ok 44 - stopping cluster 387s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 387s ok 46 - /etc/postgres-hack was not created 389s ok 47 - restarting cluster 389s ok 48 - ps -o tty -U postgres h 389s ok 49 - postgres processes do not have an associated terminal 389s ok 50 - SSL is enabled 389s ok 51 - psql -l fails for nobody 389s ok 52 - createuser nobody 389s ok 53 - createdb nobodydb 389s ok 54 - psql -ltA succeeds for nobody 389s ok 55 - psql -ltA output 389s ok 56 - SQL command: create table 389s ok 57 - SQL command: insert into table values 389s ok 58 - SQL command: insert into table values 389s ok 59 - primary key violation 389s ok 60 - psql -tAc "select * from phone order by name" nobodydb 389s ok 61 - SQL command output: select -tA 389s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 389s ok 63 - SQL command output: select -tx 389s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 389s ok 65 - SQL command output: select -tAx 390s ok 66 - CREATE EXTENSION plperlu fails for user nobody 390s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 390s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 390s ok 69 - creating PL/PerlU function as user nobody fails 390s ok 70 - creating unsafe PL/Perl function as user postgres fails 390s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 390s ok 72 - creating PL/PerlU function as user postgres succeeds 390s ok 73 - psql nobodydb -Atc "select read_file()" 390s ok 74 - calling PL/PerlU function 390s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 390s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 390s ok 77 - creating unsafe PL/Perl function as user nobody fails 390s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 390s ok 79 - creating PL/Perl function as user nobody succeeds 390s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 390s ok 81 - calling PL/Perl function 390s ok 82 # skip No python2 support 390s ok 83 # skip No python2 support 390s ok 84 # skip No python2 support 390s ok 85 # skip No python2 support 390s ok 86 # skip No python2 support 390s ok 87 # skip No python2 support 390s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 390s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 390s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 390s ok 91 - creating PL/Python3 function as user postgres succeeds 390s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 390s ok 93 - calling PL/Python function 390s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 390s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 390s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 390s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 390s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 390s ok 99 - creating PL/Tcl function as user nobody succeeds 390s 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;" 390s ok 101 - creating PL/TclU function as user postgres succeeds 390s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 390s ok 103 - calling PL/Tcl function 390s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 390s ok 105 - calling PL/TclU function 390s ok 106 - stopping cluster 390s ok 107 - pg_ctlcluster 12 main start 390s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 393s ok 109 - pg_ctlcluster 12 main start 393s ok 110 - cluster restarts with pgdata symlink 393s ok 111 - postgres master has OOM killer protection 393s ok 112 - postgres client backend has no OOM adjustment 393s ok 113 - ps h 7455 393s ok 114 - process title is idle 394s ok 115 - ps h 7455 394s ok 116 - process title is idle in transaction 394s ok 117 - ps h 7455 394s ok 118 - process title is SELECT 396s ok 119 - dropdb nobodydb 396s ok 120 - dropuser nobody 396s ok 121 - stopping cluster 399s ok 122 - starting cluster as postgres works without a log file 399s ok 123 - log file got recreated and used 399s ok 124 - creating a directory in spc2 399s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.ZIUAgU'" 399s ok 126 - creating tablespace spc1 399s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 399s ok 128 - creating a table in spc1 399s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.qZJOiV'" 399s ok 130 - creating tablespace spc2 399s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 399s ok 132 - creating a table in spc2 399s ok 133 - pg_dropcluster removes cluster 399s ok 134 - xlog/wal directory /tmp/12.xlog._TVsjR was deleted 399s ok 135 - tablespace spc1 was emptied 399s ok 136 - tablespace spc2 was emptied 399s ok 137 - Cleanup: No clusters left behind 399s ok 138 - No postgres processes left behind 399s ok 139 - No files in /etc/postgresql left behind 399s ok 140 - No files in /var/lib/postgresql left behind 399s ok 141 - No files in /var/run/postgresql left behind 399s ok 142 - No files in /var/log/postgresql left behind 399s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 399s ok 144 - PostgreSQL TCP ports are closed 399s === Running test 021_pg_renamecluster.t ... === 399s 1..20 402s ok 1 - pg_createcluster 12 main 405s ok 2 - pg_renamecluster 12 main donau 405s ok 3 - psql -tAc "show data_directory" 405s ok 4 - cluster is running and data_directory was moved 405s ok 5 - pg_hba.conf location updated 405s ok 6 - pg_ident.conf location updated 405s ok 7 - external_pid_file location updated 405s ok 8 - external_pid_file exists 405s ok 9 - stats_temp_directory location updated 405s ok 10 - stats_temp_directory exists 405s ok 11 - cluster_name is updated 405s ok 12 - pg_dropcluster removes cluster 405s ok 13 - Cleanup: No clusters left behind 405s ok 14 - No postgres processes left behind 405s ok 15 - No files in /etc/postgresql left behind 405s ok 16 - No files in /var/lib/postgresql left behind 405s ok 17 - No files in /var/run/postgresql left behind 405s ok 18 - No files in /var/log/postgresql left behind 405s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 405s ok 20 - PostgreSQL TCP ports are closed 405s === Running test 022_recovery.t ... === 405s 1..17 405s # Running tests for 12 408s ok 1 - pg_createcluster 12 main --start >/dev/null 408s ok 2 - pg_ctlcluster 12 main stop -m i 411s ok 3 - pg_ctlcluster 12 main start 411s ok 4 - psql -c '' 411s ok 5 - pg_ctlcluster 12 main stop -m i 411s ok 6 - create write-protected file in data directory 413s ok 7 - pg_ctlcluster 12 main start 413s ok 8 - psql -c '' 414s ok 9 - pg_dropcluster removes cluster 414s ok 10 - Cleanup: No clusters left behind 414s ok 11 - No postgres processes left behind 414s ok 12 - No files in /etc/postgresql left behind 414s ok 13 - No files in /var/lib/postgresql left behind 414s ok 14 - No files in /var/run/postgresql left behind 414s ok 15 - No files in /var/log/postgresql left behind 414s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 414s ok 17 - PostgreSQL TCP ports are closed 414s === Running test 025_logging.t ... === 414s 1..55 414s # Logging to /var/log/syslog works 414s # Running tests for 12 417s ok 1 - pg_createcluster 12 main 417s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 417s ok 3 - psql -qc "'foobar_12_8111'" 417s ok 4 - log an error 417s ok 5 - grep --binary-files=text foobar_12_8111 /var/log/postgresql/postgresql-12-main.log 417s ok 6 - error appears in logfile 417s ok 7 - pg_conftool 12 main set log_destination syslog 417s ok 8 - set log_destination syslog 417s ok 9 - pg_ctlcluster 12 main reload 417s ok 10 - 12 main reload 417s ok 11 - psql -Atc "show log_destination" 417s ok 12 - log_destination is syslog 417s ok 13 - pg_lscluster reports syslog 418s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 418s ok 15 - error appears in /var/log/syslog 418s ok 16 - pg_conftool 12 main set logging_collector on 418s ok 17 - set logging_collector on 418s ok 18 - pg_conftool 12 main set log_destination csvlog 418s ok 19 - set log_destination csvlog 420s ok 20 - pg_ctlcluster 12 main restart 420s ok 21 - 12 main restart 420s ok 22 - psql -Atc "show logging_collector" 420s ok 23 - logging_collector is on 420s ok 24 - psql -Atc "show log_destination" 420s ok 25 - log_destination is csvlog 420s ok 26 - pg_lscluster reports csvlog 420s ok 27 - psql -qc "'barbaz_12_8111'" 420s ok 28 - log an error 420s ok 29 - grep --binary-files=text barbaz_12_8111 /var/lib/postgresql/12/main/log/*.csv 420s ok 30 - error appears in log/*.csv 420s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 420s ok 32 - set log_destination stderr,syslog,csvlog 421s ok 33 - pg_ctlcluster 12 main reload 421s ok 34 - 12 main reload 421s ok 35 - psql -Atc "show log_destination" 421s ok 36 - log_destination is stderr,syslog,csvlog 421s ok 37 - pg_lscluster reports stderr,syslog,csvlog 421s ok 38 - psql -qc "'moo_12_8111'" 421s ok 39 - log an error 421s ok 40 - grep --binary-files=text moo_12_8111 /var/lib/postgresql/12/main/log/*.log 421s ok 41 - error appears in log/*.log 421s ok 42 - grep --binary-files=text 'postgres.*moo_12_8111' /var/log/syslog 421s ok 43 - error appears in /var/log/syslog 421s ok 44 - grep --binary-files=text moo_12_8111 /var/lib/postgresql/12/main/log/*.csv 421s ok 45 - error appears in log/*.csv 422s ok 46 - pg_dropcluster 12 main --stop 422s ok 47 - pg_dropcluster removes cluster 422s ok 48 - Cleanup: No clusters left behind 422s ok 49 - No postgres processes left behind 422s ok 50 - No files in /etc/postgresql left behind 422s ok 51 - No files in /var/lib/postgresql left behind 422s ok 52 - No files in /var/run/postgresql left behind 422s ok 53 - No files in /var/log/postgresql left behind 422s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 422s ok 55 - PostgreSQL TCP ports are closed 422s === Running test 030_errors.t ... === 422s 1..149 422s ok 1 - pg_lscluster reports cluster without binaries 422s ok 2 - pg_dropcluster 6.3 main 422s ok 3 - pg_createcluster --socketdir 422s ok 4 - pg_lsclusters -h 422s ok 5 - cluster was created 422s ok 6 - Port of created cluster is 5432 422s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 422s ok 8 - pg_createcluster on existing cluster 422s ok 9 - pg_lsclusters -h 422s ok 10 - original cluster still exists 422s ok 11 - pg_createcluster 12 test -p foo 422s ok 12 - pg_createcluster -p checks that port option is numeric 422s ok 13 - pg_createcluster 12 test -p 42 422s ok 14 - pg_createcluster -p checks valid port range 422s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 423s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 423s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 425s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 425s ok 19 - No sockets in /var/run/postgresql 425s ok 20 - Socket is in /tmp/postgresql-testsuite/ 425s ok 21 - cluster stops with custom unix_socket_dir 425s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 427s ok 23 - cluster starts after removing unix_socket_dir 427s ok 24 - Socket is in default dir /var/run/postgresql 427s ok 25 - No sockets in /tmp/postgresql-testsuite/ 427s ok 26 - pg_ctlcluster 12 main stop 427s ok 27 - pg_ctlcluster fails with corrupted PID file 427s ok 28 - pg_lsclusters -h 427s ok 29 - cluster is still online 428s ok 30 - pg_ctlcluster succeeds with restored PID file 428s ok 31 - pg_lsclusters -h 428s ok 32 - cluster is down 428s ok 33 - pg_ctlcluster 12 main stop 428s ok 34 - pg_ctlcluster stop fails on stopped cluster 430s ok 35 - pg_ctlcluster 12 main start 430s ok 36 - pg_ctlcluster succeeds with already existing PID file 430s ok 37 - pg_lsclusters -h 430s ok 38 - cluster is online 430s ok 39 - pg_ctlcluster stop succeeds 430s ok 40 - pg_lsclusters -h 430s ok 41 - cluster is down 430s ok 42 - no pid file left 430s ok 43 - pg_ctlcluster 12 main stop 430s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 430s ok 45 - pid file was cleaned up 430s ok 46 - pg_ctlcluster --force 12 main stop 430s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 430s ok 48 - pid file was cleaned up 430s ok 49 - pg_ctlcluster 12 main stop 430s ok 50 - pg_ctlcluster stop succeeds with stale PID file 430s ok 51 - pid file was cleaned up 430s ok 52 - pg_ctlcluster --force 12 main stop 430s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 430s ok 54 - pid file was cleaned up 430s ok 55 - pg_ctlcluster --force 12 main stop 430s ok 56 - pg_ctlcluster stop succeeds with empty PID file 430s ok 57 - pid file was cleaned up 432s ok 58 - pg_ctlcluster 12 main start 432s ok 59 - pg_ctlcluster succeeds with corrupted PID file 432s ok 60 - pg_lsclusters -h 432s ok 61 - cluster is online 432s ok 62 - pg_ctlcluster 12 main start 432s ok 63 - pg_ctlcluster start fails on running cluster 433s ok 64 - pg_ctlcluster stop 433s ok 65 - pg_ctlcluster 12 main start 433s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 433s ok 67 - pg_ctlcluster 12 main stop 433s ok 68 - stopping cluster 439s ok 69 - pg_ctlcluster 12 main start 439s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 439s ok 71 - pg_ctlcluster 12 main stop 439s ok 72 - stopping cluster 439s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 439s ok 74 - pg_dropcluster 12 main 439s ok 75 - pg_dropcluster works as user postgres 440s ok 76 - pg_createcluster succeeds 440s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 440s ok 78 - proper error message for nonexisting /var/lib/postgresql 442s ok 79 - pg_ctlcluster 12 main start 442s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 442s ok 81 - pg_ctlcluster 12 main stop 442s ok 82 - stopping cluster 443s ok 83 - pg_createcluster other 445s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 447s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 447s ok 86 448s ok 87 - pg_ctlcluster 12 other start 448s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 448s ok 89 - pg_ctlcluster 12 main stop 448s ok 90 - stopping main cluster 450s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 450s ok 92 - pg_dropcluster other 451s ok 93 - pg_dropcluster 451s ok 94 - No sockets any more 451s ok 95 - 'pg_lsclusters 4.5 foo' fails 451s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 451s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 451s ok 98 - 'psql --cluster 4.5/foo' fails 451s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 451s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 451s ok 101 - 'psql --cluster 12/foo' fails 451s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 451s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 451s ok 104 - 'pg_dropcluster 4.5 foo' fails 451s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 451s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 451s ok 107 - 'pg_dropcluster 12 foo' fails 451s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 451s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 451s ok 110 - 'pg_upgradecluster 4.5 foo' fails 451s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 451s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 451s ok 113 - 'pg_upgradecluster 12 foo' fails 451s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 451s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 451s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 451s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 451s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 451s ok 119 - 'pg_ctlcluster 12 foo stop' fails 451s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 451s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 451s ok 122 - Cleanup: No clusters left behind 451s ok 123 - No postgres processes left behind 451s ok 124 - No files in /etc/postgresql left behind 451s ok 125 - No files in /var/lib/postgresql left behind 451s ok 126 - No files in /var/run/postgresql left behind 451s ok 127 - No files in /var/log/postgresql left behind 451s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 451s ok 129 - PostgreSQL TCP ports are closed 451s ok 130 - pg_dropcluster 12 broken 451s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 451s ok 132 - Cleanup: No clusters left behind 451s ok 133 - No postgres processes left behind 451s ok 134 - No files in /etc/postgresql left behind 451s ok 135 - No files in /var/lib/postgresql left behind 451s ok 136 - No files in /var/run/postgresql left behind 451s ok 137 - No files in /var/log/postgresql left behind 451s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 451s ok 139 - PostgreSQL TCP ports are closed 451s ok 140 - pg_dropcluster 12 broken 451s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 451s ok 142 - Cleanup: No clusters left behind 451s ok 143 - No postgres processes left behind 451s ok 144 - No files in /etc/postgresql left behind 451s ok 145 - No files in /var/lib/postgresql left behind 451s ok 146 - No files in /var/run/postgresql left behind 451s ok 147 - No files in /var/log/postgresql left behind 451s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 451s ok 149 - PostgreSQL TCP ports are closed 451s === Running test 031_errors_disk_full.t ... === 451s 1..22 451s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 451s ok 1 - script failed 451s ok 2 - pg_createcluster fails due to insufficient disk space 451s ok 3 - does not leave files behind 451s ok 4 - Cleanup: No clusters left behind 451s ok 5 - No postgres processes left behind 451s ok 6 - No files in /etc/postgresql left behind 451s ok 7 - No files in /var/lib/postgresql left behind 451s ok 8 - No files in /var/run/postgresql left behind 451s ok 9 - No files in /var/log/postgresql left behind 451s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 451s ok 11 - PostgreSQL TCP ports are closed 451s # check disk full conditions on startup 453s ok 12 - script failed 453s ok 13 - pg_ctlcluster prints error message 453s ok 14 - log file has error message 453s ok 15 - Cleanup: No clusters left behind 453s ok 16 - No postgres processes left behind 453s ok 17 - No files in /etc/postgresql left behind 453s ok 18 - No files in /var/lib/postgresql left behind 453s ok 19 - No files in /var/run/postgresql left behind 453s ok 20 - No files in /var/log/postgresql left behind 453s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 453s ok 22 - PostgreSQL TCP ports are closed 453s === Running test 032_ssl_key_permissions.t ... === 453s 1..22 453s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 453s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 453s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 453s # 12 (12.22-0ubuntu0.20.04.1) 454s ok 4 - pg_createcluster 12 main 454s ok 5 - pg_ctlcluster 12 main start 454s ok 6 - ssl key owned by nobody refused 454s ok 7 - pg_ctlcluster 12 main start 454s ok 8 - ssl key with permissions root:root 0644 refused 454s ok 9 - pg_ctlcluster 12 main start 454s ok 10 - ssl key with permissions postgres:postgres 0640 refused 454s ok 11 - pg_dropcluster 12 main --stop 454s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 454s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 454s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 454s ok 15 - Cleanup: No clusters left behind 454s ok 16 - No postgres processes left behind 454s ok 17 - No files in /etc/postgresql left behind 454s ok 18 - No files in /var/lib/postgresql left behind 454s ok 19 - No files in /var/run/postgresql left behind 454s ok 20 - No files in /var/log/postgresql left behind 454s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 454s ok 22 - PostgreSQL TCP ports are closed 454s === Running test 040_upgrade.t ... === 454s 1..1 454s ok 1 - only one major version installed, skipping upgrade tests 454s === Running test 041_upgrade_custompaths.t ... === 454s 1..1 454s ok 1 - only one major version installed, skipping upgrade tests 454s === Running test 043_upgrade_ssl_cert.t ... === 454s 1..1 454s ok 1 - only one major version installed, skipping upgrade tests 454s === Running test 050_encodings.t ... === 455s 1..60 455s # Checking 12 ru_RU 457s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 458s ok 2 - psql -l succeeds 458s ok 3 - template1 is not UTF-8 encoded 458s ok 4 - creating test database 459s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 459s # create table t (x varchar); copy t from stdin" test 459s ok 6 - creating table with ISO-8859-5 characters 459s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 459s ok 8 - correct string in UTF-8 459s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 459s ok 10 - correct string in ISO-8859-5 459s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 459s # delete from t; copy t from stdin" test 459s ok 12 - creating table with UTF-8 characters 459s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 459s ok 14 - correct string in UTF-8 459s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 459s ok 16 - correct string in ISO-8859-1 459s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 459s ok 18 - Server error message has correct language and encoding 461s ok 19 - pg_ctlcluster 12 ru_RU restart 461s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 461s ok 21 - Dropping cluster 461s # Checking 12 ru_RU.UTF-8 464s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 466s ok 23 - psql -l succeeds 466s ok 24 - template1 is UTF-8 encoded 466s ok 25 - creating test database 466s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 466s # create table t (x varchar); copy t from stdin" test 466s ok 27 - creating table with ISO-8859-5 characters 466s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 466s ok 29 - correct string in UTF-8 466s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 466s ok 31 - correct string in ISO-8859-5 466s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 466s # delete from t; copy t from stdin" test 466s ok 33 - creating table with UTF-8 characters 466s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 466s ok 35 - correct string in UTF-8 466s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 466s ok 37 - correct string in ISO-8859-1 466s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 466s ok 39 - Server error message has correct language and encoding 468s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 468s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 468s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 468s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 468s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 468s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 468s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 468s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 469s ok 48 - Dropping cluster 469s # Check 12 locale environment variables 472s ok 49 - pg_createcluster: LC_ALL dominates LANG 472s ok 50 - psql -Atl --cluster 12/main 472s ok 51 - template1 is ASCII encoded 472s ok 52 - Dropping cluster 472s ok 53 - Cleanup: No clusters left behind 472s ok 54 - No postgres processes left behind 472s ok 55 - No files in /etc/postgresql left behind 472s ok 56 - No files in /var/lib/postgresql left behind 472s ok 57 - No files in /var/run/postgresql left behind 472s ok 58 - No files in /var/log/postgresql left behind 472s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 472s ok 60 - PostgreSQL TCP ports are closed 472s === Running test 052_upgrade_encodings.t ... === 472s 1..1 472s ok 1 - only one major version installed, skipping upgrade tests 472s === Running test 060_obsolete_confparams.t ... === 472s 1..1 472s ok 1 - only one major version installed, skipping upgrade tests 472s === Running test 070_non_postgres_clusters.t ... === 472s 1..40 473s ok 1 - pg_createcluster 12 main for owner nobody 473s ok 2 - pg_ctlcluster 12 main start 473s ok 3 - start refused when config and data owners mismatch 475s ok 4 - pg_ctlcluster succeeds with owner nobody 475s ok 5 - pg_lsclusters -h 475s ok 6 - pg_lsclusters shows running cluster 475s ok 7 - postgres is running as user nobody 475s ok 8 - ls /tmp/.s.PGSQL.* 475s ok 9 - socket is in /tmp 475s ok 10 - /var/run/postgresql is empty 475s ok 11 - conf dir is owned by user 475s ok 12 - conf dir is owned by user's primary group 475s ok 13 - files are owned by user 475s ok 14 - files are owned by user's primary group 475s ok 15 - log file has 0640 permissions 475s ok 16 - log file is owned by user 475s ok 17 - log file is owned by user's primary group 475s ok 18 - only one major version installed, skipping upgrade test 475s ok 19 - ... 475s ok 20 - ... 475s ok 21 - ... 475s ok 22 - ... 475s ok 23 - ... 475s ok 24 - ... 475s ok 25 - ... 475s ok 26 - ... 475s ok 27 - ... 475s ok 28 - ... 475s ok 29 - pg_dropcluster 476s ok 30 - pg_lsclusters -h 476s ok 31 - No clusters left 476s ok 32 - No postgres processes left 476s ok 33 - Cleanup: No clusters left behind 476s ok 34 - No postgres processes left behind 476s ok 35 - No files in /etc/postgresql left behind 476s ok 36 - No files in /var/lib/postgresql left behind 476s ok 37 - No files in /var/run/postgresql left behind 476s ok 38 - No files in /var/log/postgresql left behind 476s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 476s ok 40 - PostgreSQL TCP ports are closed 476s === Running test 080_start.conf.t ... === 476s 1..73 476s ok 1 - pg_createcluster 12 main 476s # start.conf auto 476s ok 2 - get_cluster_start_conf returns auto 476s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 476s ok 4 - start.conf contains auto 476s ok 5 - systemd generator links cluster 476s ok 6 - systemd generator links correct service file 478s ok 7 - /etc/init.d/postgresql start 12 478s ok 8 - correct output of /etc/init.d/postgresql start 12 478s ok 9 - pg_lsclusters -h 478s ok 10 - cluster is online 478s ok 11 - /etc/init.d/postgresql stop 12 479s ok 12 - correct output of /etc/init.d/postgresql stop 12 482s ok 13 - pg_lsclusters -h 482s ok 14 - cluster is down 482s # start.conf manual 482s ok 15 - get_cluster_start_conf returns manual 482s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 482s ok 17 - start.conf contains manual 482s ok 18 - systemd generator doesn't link cluster 482s ok 19 - /etc/init.d/postgresql start 12 482s ok 20 - correct output of /etc/init.d/postgresql start 12 482s ok 21 - pg_lsclusters -h 482s ok 22 - cluster is down 484s ok 23 - pg_ctlcluster 12 main start 484s ok 24 - correct output of pg_ctlcluster 12 main start 484s ok 25 - pg_lsclusters -h 484s ok 26 - cluster is online 484s ok 27 - pg_ctlcluster 12 main stop 484s ok 28 - correct output of pg_ctlcluster 12 main stop 484s ok 29 - pg_lsclusters -h 484s ok 30 - cluster is down 484s # start.conf disabled 484s ok 31 - get_cluster_start_conf returns disabled 484s ok 32 - systemd generator doesn't link cluster 484s ok 33 - /etc/init.d/postgresql start 12 484s ok 34 - correct output of /etc/init.d/postgresql start 12 484s ok 35 - pg_lsclusters -h 484s ok 36 - cluster is down 484s ok 37 - pg_ctlcluster 12 main start 484s ok 38 - correct output of pg_ctlcluster 12 main start 484s ok 39 - pg_lsclusters -h 484s ok 40 - cluster is down 487s ok 41 - pg_ctlcluster 12 main start 487s ok 42 - correct output of pg_ctlcluster 12 main start 487s ok 43 - pg_lsclusters -h 487s ok 44 - cluster is online 487s ok 45 - pg_ctlcluster 12 main stop 487s ok 46 - correct output of pg_ctlcluster 12 main stop 487s ok 47 - pg_lsclusters -h 487s ok 48 - cluster is down 489s ok 49 - pg_ctlcluster 12 main start 489s ok 50 - correct output of pg_ctlcluster 12 main start 489s ok 51 - pg_lsclusters -h 489s ok 52 - cluster is online 489s # test upgrade 489s ok 53 - only one major version installed, skipping upgrade test 489s ok 54 - ... 489s ok 55 - get_cluster_start_conf for old cluster returns manual 489s ok 56 - get_cluster_start_conf for new cluster returns manual 489s ok 57 - ... 489s ok 58 - dropping upgraded cluster 489s ok 59 - pg_lsclusters -h 489s ok 60 - no clusters any more 489s ok 61 - pg_createcluster 12 main --start-conf foo 489s ok 62 - pg_createcluster checks --start-conf validity 490s ok 63 - pg_createcluster checks --start-conf manual 490s ok 64 - get_cluster_start_conf returns manual 490s ok 65 - dropping cluster 490s ok 66 - Cleanup: No clusters left behind 490s ok 67 - No postgres processes left behind 490s ok 68 - No files in /etc/postgresql left behind 490s ok 69 - No files in /var/lib/postgresql left behind 490s ok 70 - No files in /var/run/postgresql left behind 490s ok 71 - No files in /var/log/postgresql left behind 490s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 490s ok 73 - PostgreSQL TCP ports are closed 490s === Running test 085_pg_ctl.conf.t ... === 490s 1..29 491s ok 1 - pg_createcluster 12 main 491s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 493s ok 3 - pg_ctlcluster 12 main start 493s ok 4 - starting cluster 493s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 493s ok 6 - soft core size is 0 493s ok 7 - set pg_ctl default option to -c 495s ok 8 - pg_ctlcluster 12 main restart 495s ok 9 - restarting cluster 495s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 495s ok 11 - soft core size is unlimited 495s ok 12 - restored pg_ctl default option 497s ok 13 - pg_ctlcluster 12 main restart 497s ok 14 - restarting cluster 497s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 497s ok 16 - soft core size is 0 500s ok 17 - pg_ctlcluster 12 main restart -- -c 500s ok 18 - restarting cluster with -c on the command line 500s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 500s ok 20 - soft core size is unlimited 500s ok 21 - dropping cluster 500s ok 22 - Cleanup: No clusters left behind 500s ok 23 - No postgres processes left behind 500s ok 24 - No files in /etc/postgresql left behind 500s ok 25 - No files in /var/lib/postgresql left behind 500s ok 26 - No files in /var/run/postgresql left behind 500s ok 27 - No files in /var/log/postgresql left behind 500s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 500s ok 29 - PostgreSQL TCP ports are closed 500s === Running test 090_multicluster.t ... === 500s 1..125 501s ok 1 - pg_createcluster 12 old 501s ok 2 - pg_createcluster 12 new1 502s ok 3 - pg_createcluster 12 new2 504s ok 4 - starting cluster 12/old 506s ok 5 - starting cluster 12/new1 509s ok 6 - starting cluster 12/new2 509s ok 7 - pg_lsclusters -h | sort -k3 509s ok 8 - clusters have the correct ports, skipping used 5433 509s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 509s ok 10 - createdb --version 509s ok 11 - pg_wrapper selects port 5432 as default cluster 509s ok 12 - createdb --cluster 12/new1 --version 509s ok 13 - pg_wrapper --cluster works 509s ok 14 - createdb --cluster 12/foo --version 509s ok 15 - pg_wrapper --cluster errors out for invalid cluster 509s ok 16 - createdb --cluster 12/new1 test 509s ok 17 - correct output of createdb --cluster 12/new1 test 509s ok 18 - psql -Atl --cluster 12/new1 509s ok 19 - test db appears in cluster new1 509s ok 20 - psql -Atl --cluster 12/new2 509s ok 21 - test db does not appear in cluster new2 509s ok 22 - psql -Atl 509s ok 23 - test db does not appear in default cluster 509s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 509s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 509s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 509s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 509s ok 28 - psql -Atl --cluster 12/localhost:5434 509s ok 29 - test db appears in cluster 12/localhost:5434 509s ok 30 - psql -Atl --cluster 12/localhost:5440 509s ok 31 - test db does not appear in cluster 12/localhost:5440 509s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 509s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 509s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 509s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 509s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 509s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 509s ok 38 - psql -Atl --cluster 6.4/localhost: 509s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 509s ok 40 - psql -Atl 509s ok 41 - PGCLUSTER selection (1) 509s ok 42 - psql -Atl 509s ok 43 - PGCLUSTER selection (2) 509s ok 44 - psql -l 509s ok 45 - invalid PGCLUSTER value 509s ok 46 - createdb --version 509s ok 47 - PGCLUSTER network cluster selection (1) 509s ok 48 - psql -Atl 509s ok 49 - PGCLUSTER network cluster selection (2) 509s ok 50 - psql -Atl 509s ok 51 - PGCLUSTER network cluster selection (3) 509s ok 52 - LC_MESSAGES=C psql -Atl 509s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 509s ok 54 - psql -Atc "show port" template1 509s ok 55 - PGPORT selection (1) 510s ok 56 - psql -Atc "show port" template1 510s ok 57 - PGPORT selection (2) 510s ok 58 - createdb --version 510s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 510s ok 60 - psql -Atc "show port" template1 510s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 510s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 510s ok 63 - PGDATABASE environment variable works 510s ok 64 - createdb --version 510s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 510s ok 66 - createdb --cluster 12/new1 --version 510s ok 67 - pg_wrapper --cluster works with empty user_clusters 510s ok 68 - createdb --version 510s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 510s ok 70 - psql -Atc "select current_database()" 510s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 510s ok 72 - psql -Atc 'select current_database()' 510s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 510s ok 74 - createdb --version 510s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 510s ok 76 - createdb --version 510s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 510s ok 78 - createdb --version 510s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 510s ok 80 - createdb --version 510s ok 81 - pg_wrapper selects correct version with per-user user_clusters 510s ok 82 - createdb --version 510s ok 83 - pg_wrapper selects correct version with per-user user_clusters 510s ok 84 - createdb --version 510s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 510s ok 86 - psql -Atl 510s ok 87 - $PGHOST overrides user_clusters 510s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 510s ok 89 - --cluster overrides $PGHOST 510s ok 90 - createdb --version 510s ok 91 - pg_wrapper ignores invalid lines in user_clusters 510s ok 92 - psql -Atc 'select current_database()' 510s ok 93 - pg_service conf selection 1 510s ok 94 - psql -Atc 'select current_database()' 510s ok 95 - pg_service conf selection 2 510s ok 96 - psql -Atc 'select current_database()' 510s ok 97 - pg_service conf selection 3 510s ok 98 - stopping cluster 12/old 513s ok 99 - restarting cluster 12/old 513s ok 100 - pg_lsclusters -h | sort -k3 513s ok 101 - port of first cluster was successfully changed 513s ok 102 - psql -l 513s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 513s ok 104 - psql -Atl --cluster 12/new1 513s ok 105 - --cluster selects appropriate cluster 513s ok 106 - psql -Atl -p 5434 513s ok 107 - -p selects appropriate cluster 513s ok 108 - psql -Atlp 5434 513s ok 109 - -Atlp selects appropriate cluster 513s ok 110 - psql -Atl --port 5434 513s ok 111 - --port selects appropriate cluster 513s ok 112 - env PGPORT=5434 psql -Atl 513s ok 113 - $PGPORT selects appropriate cluster 513s ok 114 - Restoring original /etc/postgresql-common/user_clusters 513s ok 115 - dropping 12/new1 514s ok 116 - dropping 12/new2 514s ok 117 - dropping 12/old 514s ok 118 - Cleanup: No clusters left behind 514s ok 119 - No postgres processes left behind 514s ok 120 - No files in /etc/postgresql left behind 514s ok 121 - No files in /var/lib/postgresql left behind 514s ok 122 - No files in /var/run/postgresql left behind 514s ok 123 - No files in /var/log/postgresql left behind 514s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 514s ok 125 - PostgreSQL TCP ports are closed 514s === Running test 100_upgrade_scripts.t ... === 514s 1..27 517s ok 1 - pg_createcluster 12 main 517s ok 2 - createdb --cluster 12/main db1 517s ok 3 - correct output of createdb --cluster 12/main db1 517s ok 4 - createdb --cluster 12/main db2 517s ok 5 - correct output of createdb --cluster 12/main db2 517s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 517s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 517s ok 8 - get_cluster_databases() works 517s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 519s ok 10 - run-upgrade-scripts succeeds 519s ok 11 - correct run-upgrade-script output 519s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 519s ok 13 - check SQL scripts results in 12/main db1 519s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 519s ok 15 - check SQL scripts results in 12/main db2 519s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 519s ok 17 - check shell scripts results in $v/main 519s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 519s ok 19 - pg_dropcluster 12 main 519s ok 20 - Cleanup: No clusters left behind 519s ok 21 - No postgres processes left behind 519s ok 22 - No files in /etc/postgresql left behind 519s ok 23 - No files in /var/lib/postgresql left behind 519s ok 24 - No files in /var/run/postgresql left behind 519s ok 25 - No files in /var/log/postgresql left behind 519s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 519s ok 27 - PostgreSQL TCP ports are closed 519s === Running test 110_integrate_cluster.t ... === 519s 1..32 520s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/xUA8Wh32J9/c/postgres 520s ok 2 - creating raw initdb cluster for user postgres 520s ok 3 - pg_createcluster 12 postgres -d /tmp/xUA8Wh32J9/c/postgres 520s ok 4 - integrating postgres cluster 520s ok 5 - pg_lsclusters 520s ok 6 - correct pg_lsclusters output 522s ok 7 - pg_ctlcluster 12 postgres start 522s ok 8 - starting cluster postgres 522s ok 9 - pg_lsclusters 522s ok 10 - correct pg_lsclusters output 523s ok 11 - dropping cluster postgres 523s ok 12 - No files in temporary cluster dir left behind 523s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/xUA8Wh32J9/c/nobody 523s ok 14 - creating raw initdb cluster for user nobody 524s ok 15 - pg_createcluster 12 nobody -d /tmp/xUA8Wh32J9/c/nobody 524s ok 16 - integrating nobody cluster 524s ok 17 - pg_lsclusters 524s ok 18 - correct pg_lsclusters output 535s ok 19 - pg_ctlcluster 12 nobody start 535s ok 20 - starting cluster nobody 535s ok 21 - pg_lsclusters 535s ok 22 - correct pg_lsclusters output 535s ok 23 - dropping cluster nobody 535s ok 24 - No files in temporary cluster dir left behind 535s ok 25 - Cleanup: No clusters left behind 535s ok 26 - No postgres processes left behind 535s ok 27 - No files in /etc/postgresql left behind 535s ok 28 - No files in /var/lib/postgresql left behind 535s ok 29 - No files in /var/run/postgresql left behind 535s ok 30 - No files in /var/log/postgresql left behind 535s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 535s ok 32 - PostgreSQL TCP ports are closed 535s === Running test 120_pg_upgradecluster_scripts.t ... === 535s 1..1 535s ok 1 - only one major version installed, skipping upgrade tests 535s === Running test 130_nonroot_admin.t ... === 535s 1..22 535s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 535s ok 2 - pg_lsclusters -h 535s ok 3 - correct output of pg_lsclusters -h 535s ok 4 - psql -Atl 535s ok 5 - correct output of psql -Atl 535s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 535s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 535s ok 15 - Cleanup: No clusters left behind 535s ok 16 - No postgres processes left behind 535s ok 17 - No files in /etc/postgresql left behind 535s ok 18 - No files in /var/lib/postgresql left behind 535s ok 19 - No files in /var/run/postgresql left behind 535s ok 20 - No files in /var/log/postgresql left behind 535s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 535s ok 22 - PostgreSQL TCP ports are closed 535s === Running test 135_pg_virtualenv.t ... === 535s 1..20 535s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 535s ok 2 - running pg_virtualenv as root 536s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 536s ok 4 - running pg_virtualenv as postgres 539s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 539s ok 6 - running pg_virtualenv as nobody 539s ok 7 # skip /usr/bin/fakeroot not available 539s ok 8 # skip /usr/bin/fakeroot not available 539s ok 9 # skip /usr/bin/fakeroot not available 539s ok 10 # skip /usr/bin/fakeroot not available 539s ok 11 # skip /usr/bin/fakeroot not available 539s ok 12 # skip /usr/bin/fakeroot not available 539s ok 13 - Cleanup: No clusters left behind 539s ok 14 - No postgres processes left behind 539s ok 15 - No files in /etc/postgresql left behind 539s ok 16 - No files in /var/lib/postgresql left behind 539s ok 17 - No files in /var/run/postgresql left behind 539s ok 18 - No files in /var/log/postgresql left behind 539s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 539s ok 20 - PostgreSQL TCP ports are closed 539s === Running test 140_pg_config.t ... === 539s 1..38 539s # Multiarch is enabled 539s # checking version specific output for 12 539s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 539s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 539s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 539s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 539s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 539s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 539s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 539s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 539s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 539s # checking pg_config output (should behave like version 12) 539s ok 15 - pg_config 539s ok 16 - correct output of pg_config 539s ok 17 - pg_config --help 539s ok 18 - correct output of pg_config --help 539s ok 19 - pg_config --pgxs 539s ok 20 - correct output of pg_config --pgxs 539s ok 21 - pg_config --libdir 539s ok 22 - correct output of pg_config --libdir 539s ok 23 - pg_config --pkglibdir 539s ok 24 - correct output of pg_config --pkglibdir 539s ok 25 - pg_config --bindir 539s ok 26 - correct output of pg_config --bindir 539s # checking pg_config.libpq-dev output (should behave like version 12) 539s ok 27 - pg_config.libpq-dev 539s ok 28 - correct output of pg_config.libpq-dev 539s ok 29 - pg_config.libpq-dev --help 539s ok 30 - correct output of pg_config.libpq-dev --help 539s ok 31 - pg_config.libpq-dev --pgxs 539s ok 32 - correct output of pg_config.libpq-dev --pgxs 539s ok 33 - pg_config.libpq-dev --libdir 539s ok 34 - correct output of pg_config.libpq-dev --libdir 539s ok 35 - pg_config.libpq-dev --pkglibdir 539s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 539s ok 37 - pg_config.libpq-dev --bindir 539s ok 38 - correct output of pg_config.libpq-dev --bindir 539s === Running test 150_tsearch_stemming.t ... === 539s 1..37 539s ok 1 - pg_updatedicts succeeded 539s ok 2 - pg_updatedicts created en_us.affix 539s ok 3 - pg_updatedicts created en_us.dict 539s ok 4 - pg_updatedicts created 12 en_us.affix symlink 539s ok 5 - pg_updatedicts created 12 en_us.dict symlink 542s ok 6 - pg_createcluster 12 main 542s ok 7 - createdb fts 542s ok 8 - correct output of createdb fts 542s ok 9 - creating en_US full text search configuration 542s ok 10 - creating data table and search index 542s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 542s ok 12 - stem search of correct word 542s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 542s ok 14 - stem search of correct word 543s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 543s ok 16 - stem search of unknown word 543s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 543s ok 18 - full text search, exact word 543s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 543s ok 20 - full text search for word stem 543s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 543s ok 22 - full text search for word substring fails 543s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 543s ok 24 - full text search, exact unicode word 543s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 543s ok 26 - full text search for unicode word stem 543s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 543s ok 28 - full text search for unicode word substring fails 543s ok 29 543s ok 30 - Cleanup: No clusters left behind 543s ok 31 - No postgres processes left behind 543s ok 32 - No files in /etc/postgresql left behind 543s ok 33 - No files in /var/lib/postgresql left behind 543s ok 34 - No files in /var/run/postgresql left behind 543s ok 35 - No files in /var/log/postgresql left behind 543s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 543s ok 37 - PostgreSQL TCP ports are closed 543s === Running test 160_alternate_confroot.t ... === 543s 1..28 546s ok 1 546s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 546s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 546s ok 4 - pg_lsclusters -h 546s ok 5 - correct output of pg_lsclusters -h 546s ok 6 - psql -Atl 546s ok 7 - correct output of psql -Atl 546s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 546s ok 9 - ... 546s ok 10 - ... 546s ok 11 - ... 546s ok 12 - ... 546s ok 13 - ... 546s ok 14 - ... 546s ok 15 - pg_dropcluster 12 test --stop 546s ok 16 - correct output of pg_dropcluster 12 test --stop 546s ok 17 - pg_lsclusters -h 546s ok 18 - correct output of pg_lsclusters -h 546s ok 19 - No files in root/data left behind 546s ok 20 - No cruft in root dir left behind 546s ok 21 - Cleanup: No clusters left behind 546s ok 22 - No postgres processes left behind 546s ok 23 - No files in /etc/postgresql left behind 546s ok 24 - No files in /var/lib/postgresql left behind 546s ok 25 - No files in /var/run/postgresql left behind 546s ok 26 - No files in /var/log/postgresql left behind 546s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 546s ok 28 - PostgreSQL TCP ports are closed 546s === Running test 170_extensions.t ... === 547s # Running tests for 12 550s ok 1 - pg_createcluster 12 main 550s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 550s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 550s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 550s ok 5 - extension adminpack installs without error 550s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 550s ok 7 - extension adminpack removes without error 550s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 550s ok 9 - extension amcheck installs without error 550s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 550s ok 11 - extension amcheck removes without error 550s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 550s ok 13 - extension autoinc installs without error 550s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 550s ok 15 - extension autoinc removes without error 550s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 550s ok 17 - extension bloom installs without error 550s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 550s ok 19 - extension bloom removes without error 550s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 550s ok 21 - extension btree_gin installs without error 550s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 550s ok 23 - extension btree_gin removes without error 550s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 550s ok 25 - extension btree_gist installs without error 550s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 550s ok 27 - extension btree_gist removes without error 550s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 550s ok 29 - extension citext installs without error 550s ok 30 - psql -qc 'DROP EXTENSION "citext"' 550s ok 31 - extension citext removes without error 550s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 550s ok 33 - extension cube installs without error 551s ok 34 - psql -qc 'DROP EXTENSION "cube"' 551s ok 35 - extension cube removes without error 551s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 551s ok 37 - extension dblink installs without error 551s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 551s ok 39 - extension dblink removes without error 551s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 551s ok 41 - extension dict_int installs without error 551s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 551s ok 43 - extension dict_int removes without error 551s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 551s ok 45 - extension dict_xsyn installs without error 551s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 551s ok 47 - extension dict_xsyn removes without error 551s ok 48 - psql -qc 'CREATE EXTENSION cube' 551s ok 49 - earthdistance dependency cube installs without error 551s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 551s ok 51 - extension earthdistance installs without error 551s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 551s ok 53 - extension earthdistance removes without error 551s ok 54 - psql -qc 'DROP EXTENSION cube' 551s ok 55 - earthdistance dependency extension cube removes without error 551s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 551s ok 57 - extension file_fdw installs without error 551s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 551s ok 59 - extension file_fdw removes without error 551s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 551s ok 61 - extension fuzzystrmatch installs without error 551s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 551s ok 63 - extension fuzzystrmatch removes without error 551s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 551s ok 65 - extension hstore installs without error 551s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 551s ok 67 - extension hstore removes without error 551s ok 68 - psql -qc 'CREATE EXTENSION hstore' 551s ok 69 - hstore_plperl dependency hstore installs without error 551s ok 70 - psql -qc 'CREATE EXTENSION plperl' 551s ok 71 - hstore_plperl dependency plperl installs without error 551s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 551s ok 73 - extension hstore_plperl installs without error 552s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 552s ok 75 - extension hstore_plperl removes without error 552s ok 76 - psql -qc 'DROP EXTENSION hstore' 552s ok 77 - hstore_plperl dependency extension hstore removes without error 552s ok 78 - psql -qc 'DROP EXTENSION plperl' 552s ok 79 - hstore_plperl dependency extension plperl removes without error 552s ok 80 - psql -qc 'CREATE EXTENSION hstore' 552s ok 81 - hstore_plperlu dependency hstore installs without error 552s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 552s ok 83 - hstore_plperlu dependency plperlu installs without error 552s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 552s ok 85 - extension hstore_plperlu installs without error 552s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 552s ok 87 - extension hstore_plperlu removes without error 552s ok 88 - psql -qc 'DROP EXTENSION hstore' 552s ok 89 - hstore_plperlu dependency extension hstore removes without error 552s ok 90 - psql -qc 'DROP EXTENSION plperlu' 552s ok 91 - hstore_plperlu dependency extension plperlu removes without error 552s ok 92 - psql -qc 'CREATE EXTENSION hstore' 552s ok 93 - hstore_plpython3u dependency hstore installs without error 552s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 552s ok 95 - hstore_plpython3u dependency plpython3u installs without error 552s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 552s ok 97 - extension hstore_plpython3u installs without error 552s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 552s ok 99 - extension hstore_plpython3u removes without error 552s ok 100 - psql -qc 'DROP EXTENSION hstore' 552s ok 101 - hstore_plpython3u dependency extension hstore removes without error 552s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 552s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 552s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 552s ok 105 - extension insert_username installs without error 552s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 552s ok 107 - extension insert_username removes without error 552s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 552s ok 109 - extension intagg installs without error 552s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 552s ok 111 - extension intagg removes without error 553s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 553s ok 113 - extension intarray installs without error 553s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 553s ok 115 - extension intarray removes without error 553s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 553s ok 117 - extension isn installs without error 553s ok 118 - psql -qc 'DROP EXTENSION "isn"' 553s ok 119 - extension isn removes without error 553s ok 120 - psql -qc 'CREATE EXTENSION plperl' 553s ok 121 - jsonb_plperl dependency plperl installs without error 553s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 553s ok 123 - extension jsonb_plperl installs without error 553s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 553s ok 125 - extension jsonb_plperl removes without error 553s ok 126 - psql -qc 'DROP EXTENSION plperl' 553s ok 127 - jsonb_plperl dependency extension plperl removes without error 553s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 553s ok 129 - jsonb_plperlu dependency plperlu installs without error 553s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 553s ok 131 - extension jsonb_plperlu installs without error 553s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 553s ok 133 - extension jsonb_plperlu removes without error 553s ok 134 - psql -qc 'DROP EXTENSION plperlu' 553s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 553s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 553s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 553s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 553s ok 139 - extension jsonb_plpython3u installs without error 553s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 553s ok 141 - extension jsonb_plpython3u removes without error 553s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 553s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 553s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 553s ok 145 - extension lo installs without error 553s ok 146 - psql -qc 'DROP EXTENSION "lo"' 553s ok 147 - extension lo removes without error 553s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 553s ok 149 - extension ltree installs without error 553s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 553s ok 151 - extension ltree removes without error 553s ok 152 - psql -qc 'CREATE EXTENSION ltree' 553s ok 153 - ltree_plpython3u dependency ltree installs without error 554s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 554s ok 155 - ltree_plpython3u dependency plpython3u installs without error 554s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 554s ok 157 - extension ltree_plpython3u installs without error 554s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 554s ok 159 - extension ltree_plpython3u removes without error 554s ok 160 - psql -qc 'DROP EXTENSION ltree' 554s ok 161 - ltree_plpython3u dependency extension ltree removes without error 554s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 554s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 554s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 554s ok 165 - extension moddatetime installs without error 554s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 554s ok 167 - extension moddatetime removes without error 554s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 554s ok 169 - extension pageinspect installs without error 554s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 554s ok 171 - extension pageinspect removes without error 554s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 554s ok 173 - extension pg_buffercache installs without error 554s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 554s ok 175 - extension pg_buffercache removes without error 554s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 554s ok 177 - extension pg_freespacemap installs without error 554s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 554s ok 179 - extension pg_freespacemap removes without error 554s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 554s ok 181 - extension pg_prewarm installs without error 554s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 554s ok 183 - extension pg_prewarm removes without error 554s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 554s ok 185 - extension pg_stat_statements installs without error 554s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 554s ok 187 - extension pg_stat_statements removes without error 554s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 554s ok 189 - extension pg_trgm installs without error 554s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 554s ok 191 - extension pg_trgm removes without error 554s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 554s ok 193 - extension pg_visibility installs without error 554s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 554s ok 195 - extension pg_visibility removes without error 554s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 554s ok 197 - extension pgcrypto installs without error 554s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 554s ok 199 - extension pgcrypto removes without error 554s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 554s ok 201 - extension pgrowlocks installs without error 554s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 554s ok 203 - extension pgrowlocks removes without error 555s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 555s ok 205 - extension pgstattuple installs without error 555s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 555s ok 207 - extension pgstattuple removes without error 555s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 555s ok 209 - extension plperl installs without error 555s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 555s ok 211 - extension plperl removes without error 555s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 555s ok 213 - extension plperlu installs without error 555s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 555s ok 215 - extension plperlu removes without error 555s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 555s ok 217 - extension plpython3u installs without error 555s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 555s ok 219 - extension plpython3u removes without error 555s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 555s ok 221 - extension pltcl installs without error 555s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 555s ok 223 - extension pltcl removes without error 555s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 555s ok 225 - extension pltclu installs without error 555s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 555s ok 227 - extension pltclu removes without error 555s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 555s ok 229 - extension postgres_fdw installs without error 555s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 555s ok 231 - extension postgres_fdw removes without error 555s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 555s ok 233 - extension refint installs without error 555s ok 234 - psql -qc 'DROP EXTENSION "refint"' 555s ok 235 - extension refint removes without error 555s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 555s ok 237 - extension seg installs without error 555s ok 238 - psql -qc 'DROP EXTENSION "seg"' 555s ok 239 - extension seg removes without error 555s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 555s ok 241 - extension sslinfo installs without error 555s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 555s ok 243 - extension sslinfo removes without error 556s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 556s ok 245 - extension tablefunc installs without error 556s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 556s ok 247 - extension tablefunc removes without error 556s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 556s ok 249 - extension tcn installs without error 556s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 556s ok 251 - extension tcn removes without error 556s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 556s ok 253 - extension tsm_system_rows installs without error 556s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 556s ok 255 - extension tsm_system_rows removes without error 556s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 556s ok 257 - extension tsm_system_time installs without error 556s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 556s ok 259 - extension tsm_system_time removes without error 556s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 556s ok 261 - extension unaccent installs without error 556s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 556s ok 263 - extension unaccent removes without error 556s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 556s ok 265 - extension uuid-ossp installs without error 556s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 556s ok 267 - extension uuid-ossp removes without error 556s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 556s ok 269 - extension xml2 installs without error 556s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 556s ok 271 - extension xml2 removes without error 557s ok 272 - pg_dropcluster 12 main 557s ok 273 - Cleanup: No clusters left behind 557s ok 274 - No postgres processes left behind 557s ok 275 - No files in /etc/postgresql left behind 557s ok 276 - No files in /var/lib/postgresql left behind 557s ok 277 - No files in /var/run/postgresql left behind 557s ok 278 - No files in /var/log/postgresql left behind 557s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 557s ok 280 - PostgreSQL TCP ports are closed 557s 1..280 557s === Running test 180_ecpg.t ... === 557s 1..17 557s ok 1 - ecpg test.pgc 557s ok 2 - ecpg processing 557s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 557s ok 4 - compiling ecpg output 560s ok 5 - pg_createcluster 12 main 560s ok 6 - createuser nobody 560s ok 7 - /tmp/tmp.KE3VvFHrmR/test 560s ok 8 - runs and gives correct output 560s ok 9 - pg_dropcluster 12 main 560s ok 10 - Cleanup: No clusters left behind 560s ok 11 - No postgres processes left behind 560s ok 12 - No files in /etc/postgresql left behind 560s ok 13 - No files in /var/lib/postgresql left behind 560s ok 14 - No files in /var/run/postgresql left behind 560s ok 15 - No files in /var/log/postgresql left behind 560s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 560s ok 17 - PostgreSQL TCP ports are closed 561s autopkgtest [00:11:14]: test run-testsuite: -----------------------] 561s run-testsuite PASS 561s autopkgtest [00:11:14]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 562s autopkgtest [00:11:15]: test installcheck: preparing testbed 877s autopkgtest [00:16:30]: testbed dpkg architecture: amd64 878s autopkgtest [00:16:31]: testbed apt version: 2.0.10 878s autopkgtest [00:16:31]: @@@@@@@@@@@@@@@@@@@@ test bed setup 878s autopkgtest [00:16:31]: testbed release detected to be: focal 879s autopkgtest [00:16:32]: updating testbed package index (apt update) 881s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 881s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 881s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 881s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 881s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [18.0 kB] 881s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [9588 B] 882s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [68.1 kB] 882s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [8604 B] 882s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [82.1 kB] 882s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [339 kB] 882s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1436 B] 882s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [529 kB] 882s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [4568 B] 882s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 882s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [24.4 kB] 882s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [42.1 kB] 882s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1772 B] 882s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [10.7 kB] 882s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [2652 B] 882s Get:20 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [312 B] 890s Fetched 1419 kB in 3s (473 kB/s) 890s Reading package lists... 891s Reading package lists... 891s Building dependency tree... 891s Reading state information... 891s Calculating upgrade... 891s The following packages will be upgraded: 891s binutils binutils-common binutils-x86-64-linux-gnu libbinutils libctf-nobfd0 891s libctf0 pollinate 892s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 892s Need to get 2405 kB of archives. 892s After this operation, 34.8 kB disk space will be freed. 892s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libctf0 amd64 2.34-6ubuntu1.10 [46.7 kB] 893s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils-x86-64-linux-gnu amd64 2.34-6ubuntu1.10 [1613 kB] 893s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libbinutils amd64 2.34-6ubuntu1.10 [474 kB] 894s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils amd64 2.34-6ubuntu1.10 [3380 B] 894s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 binutils-common amd64 2.34-6ubuntu1.10 [208 kB] 894s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libctf-nobfd0 amd64 2.34-6ubuntu1.10 [48.1 kB] 894s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main amd64 pollinate all 4.33-3ubuntu1.20.04.2 [12.3 kB] 894s Fetched 2405 kB in 2s (1014 kB/s) 894s (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 ... 97383 files and directories currently installed.) 894s Preparing to unpack .../0-libctf0_2.34-6ubuntu1.10_amd64.deb ... 894s Unpacking libctf0:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 894s Preparing to unpack .../1-binutils-x86-64-linux-gnu_2.34-6ubuntu1.10_amd64.deb ... 894s Unpacking binutils-x86-64-linux-gnu (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 894s Preparing to unpack .../2-libbinutils_2.34-6ubuntu1.10_amd64.deb ... 894s Unpacking libbinutils:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 894s Preparing to unpack .../3-binutils_2.34-6ubuntu1.10_amd64.deb ... 894s Unpacking binutils (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 895s Preparing to unpack .../4-binutils-common_2.34-6ubuntu1.10_amd64.deb ... 895s Unpacking binutils-common:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 895s Preparing to unpack .../5-libctf-nobfd0_2.34-6ubuntu1.10_amd64.deb ... 895s Unpacking libctf-nobfd0:amd64 (2.34-6ubuntu1.10) over (2.34-6ubuntu1.9) ... 895s Preparing to unpack .../6-pollinate_4.33-3ubuntu1.20.04.2_all.deb ... 895s Unpacking pollinate (4.33-3ubuntu1.20.04.2) over (4.33-3ubuntu1.20.04.1) ... 895s Setting up binutils-common:amd64 (2.34-6ubuntu1.10) ... 895s Setting up libctf-nobfd0:amd64 (2.34-6ubuntu1.10) ... 895s Setting up pollinate (4.33-3ubuntu1.20.04.2) ... 895s Setting up libbinutils:amd64 (2.34-6ubuntu1.10) ... 895s Setting up libctf0:amd64 (2.34-6ubuntu1.10) ... 895s Setting up binutils-x86-64-linux-gnu (2.34-6ubuntu1.10) ... 895s Setting up binutils (2.34-6ubuntu1.10) ... 895s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 895s Processing triggers for man-db (2.9.1-1) ... 896s Reading package lists... 896s Building dependency tree... 896s Reading state information... 896s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 896s autopkgtest [00:16:49]: upgrading testbed (apt dist-upgrade and autopurge) 896s Reading package lists... 897s Building dependency tree... 897s Reading state information... 897s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 897s Starting 2 pkgProblemResolver with broken count: 0 897s Done 897s 897s The following packages will be upgraded: 897s tzdata 897s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 897s Need to get 300 kB of archives. 897s After this operation, 3072 B of additional disk space will be used. 897s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 tzdata all 2025a-0ubuntu0.20.04 [300 kB] 898s Preconfiguring packages ... 898s Fetched 300 kB in 0s (710 kB/s) 898s (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 ... 97383 files and directories currently installed.) 898s Preparing to unpack .../tzdata_2025a-0ubuntu0.20.04_all.deb ... 898s Unpacking tzdata (2025a-0ubuntu0.20.04) over (2024b-0ubuntu0.20.04.1) ... 898s Setting up tzdata (2025a-0ubuntu0.20.04) ... 898s 898s Current default time zone: 'Etc/UTC' 898s Local time is now: Thu Feb 27 00:16:51 UTC 2025. 898s Universal Time is now: Thu Feb 27 00:16:51 UTC 2025. 898s Run 'dpkg-reconfigure tzdata' if you wish to change it. 898s 899s Reading package lists... 899s Building dependency tree... 899s Reading state information... 899s Starting pkgProblemResolver with broken count: 0 899s Starting 2 pkgProblemResolver with broken count: 0 899s Done 900s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 900s autopkgtest [00:16:53]: rebooting testbed after setup commands that affected boot 926s Reading package lists... 926s Building dependency tree... 926s Reading state information... 926s Starting pkgProblemResolver with broken count: 0 926s Starting 2 pkgProblemResolver with broken count: 0 926s Done 927s The following NEW packages will be installed: 927s binfmt-support build-essential clang-10 cpp cpp-9 g++ g++-9 gcc gcc-9 927s gcc-9-base lib32gcc-s1 lib32stdc++6 libasan5 libatomic1 libc-dev-bin 927s libc6-dev libc6-i386 libcc1-0 libclang-common-10-dev libclang-cpp10 927s libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libffi-dev 927s libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 927s libncurses-dev libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 927s libpython3.8 libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 927s libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 927s llvm-10-runtime llvm-10-tools postgresql-12 postgresql-client-12 927s postgresql-client-common postgresql-common postgresql-doc-12 927s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 927s postgresql-server-dev-12 python3-pygments ssl-cert 927s 0 upgraded, 67 newly installed, 0 to remove and 0 not upgraded. 927s Need to get 142 MB of archives. 927s After this operation, 750 MB of additional disk space will be used. 927s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 927s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 927s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-208.228 [1118 kB] 928s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 928s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 928s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 928s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 929s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 929s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 930s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 930s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 930s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 930s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 930s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 930s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 930s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 930s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 930s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 930s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 930s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 930s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 931s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 931s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 931s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 931s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 931s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 931s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 932s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 932s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 932s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 932s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 932s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 932s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 932s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 932s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 932s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 933s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 933s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.1 [45.7 kB] 933s Get:39 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.1 [117 kB] 933s Get:40 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.1 [43.4 kB] 933s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.1 [12.7 kB] 933s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.1 [137 kB] 933s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.1 [239 kB] 933s Get:44 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 933s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.15 [1626 kB] 933s Get:46 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 933s Get:47 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 933s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.1 [151 kB] 933s Get:49 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 933s Get:50 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 933s Get:51 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 933s Get:52 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 933s Get:53 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 933s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 933s Get:55 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 933s Get:56 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 933s Get:57 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 934s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 934s Get:59 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.1 [1056 kB] 934s Get:60 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 934s Get:61 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 934s Get:62 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.1 [13.6 MB] 934s Get:63 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-doc-12 all 12.22-0ubuntu0.20.04.1 [1949 kB] 934s Get:64 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.1 [68.4 kB] 934s Get:65 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.1 [76.7 kB] 934s Get:66 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.1 [31.6 kB] 934s Get:67 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.1 [992 kB] 935s Preconfiguring packages ... 935s Fetched 142 MB in 7s (19.0 MB/s) 935s Selecting previously unselected package binfmt-support. 935s (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 ... 97384 files and directories currently installed.) 935s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 935s Unpacking binfmt-support (2.2.0-2) ... 935s Selecting previously unselected package libc-dev-bin. 935s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 935s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 935s Selecting previously unselected package linux-libc-dev:amd64. 935s Preparing to unpack .../02-linux-libc-dev_5.4.0-208.228_amd64.deb ... 935s Unpacking linux-libc-dev:amd64 (5.4.0-208.228) ... 935s Selecting previously unselected package libcrypt-dev:amd64. 935s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 935s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 935s Selecting previously unselected package libc6-dev:amd64. 935s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 935s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 935s Selecting previously unselected package gcc-9-base:amd64. 935s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 935s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 935s Selecting previously unselected package libisl22:amd64. 935s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 935s Unpacking libisl22:amd64 (0.22.1-1) ... 935s Selecting previously unselected package libmpc3:amd64. 935s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 935s Unpacking libmpc3:amd64 (1.1.0-1) ... 935s Selecting previously unselected package cpp-9. 935s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 935s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 936s Selecting previously unselected package cpp. 936s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 936s Unpacking cpp (4:9.3.0-1ubuntu2) ... 936s Selecting previously unselected package libcc1-0:amd64. 936s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 936s Selecting previously unselected package libgomp1:amd64. 936s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 936s Selecting previously unselected package libitm1:amd64. 936s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 936s Selecting previously unselected package libatomic1:amd64. 936s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 936s Selecting previously unselected package libasan5:amd64. 936s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 936s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 936s Selecting previously unselected package liblsan0:amd64. 936s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 936s Selecting previously unselected package libtsan0:amd64. 936s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 936s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 937s Selecting previously unselected package libubsan1:amd64. 937s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 937s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 937s Selecting previously unselected package libquadmath0:amd64. 937s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 937s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 937s Selecting previously unselected package libgcc-9-dev:amd64. 937s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 937s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 937s Selecting previously unselected package gcc-9. 937s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 937s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 937s Selecting previously unselected package gcc. 937s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 937s Unpacking gcc (4:9.3.0-1ubuntu2) ... 937s Selecting previously unselected package libstdc++-9-dev:amd64. 937s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 937s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 938s Selecting previously unselected package g++-9. 938s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 938s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 938s Selecting previously unselected package g++. 938s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 938s Unpacking g++ (4:9.3.0-1ubuntu2) ... 938s Selecting previously unselected package build-essential. 938s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 938s Unpacking build-essential (12.8ubuntu1.1) ... 938s Selecting previously unselected package libllvm10:amd64. 938s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 938s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 940s Selecting previously unselected package libclang-cpp10. 940s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 940s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 940s Selecting previously unselected package libgc1c2:amd64. 940s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 940s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 940s Selecting previously unselected package libobjc4:amd64. 941s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 941s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 941s Selecting previously unselected package libobjc-9-dev:amd64. 941s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 941s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 941s Selecting previously unselected package libc6-i386. 941s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 941s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 941s Selecting previously unselected package lib32gcc-s1. 941s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 941s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 941s Selecting previously unselected package lib32stdc++6. 941s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 941s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 941s Selecting previously unselected package libclang-common-10-dev. 941s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 941s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 941s Selecting previously unselected package libclang1-10. 941s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 941s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 942s Selecting previously unselected package clang-10. 942s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 942s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 942s Selecting previously unselected package libpgtypes3:amd64. 942s Preparing to unpack .../37-libpgtypes3_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libpq5:amd64. 942s Preparing to unpack .../38-libpq5_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libecpg6:amd64. 942s Preparing to unpack .../39-libecpg6_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libecpg-compat3:amd64. 942s Preparing to unpack .../40-libecpg-compat3_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libpq-dev. 942s Preparing to unpack .../41-libpq-dev_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libpq-dev (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libecpg-dev. 942s Preparing to unpack .../42-libecpg-dev_12.22-0ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.1) ... 942s Selecting previously unselected package libncurses-dev:amd64. 942s Preparing to unpack .../43-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 942s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 942s Selecting previously unselected package libpython3.8:amd64. 942s Preparing to unpack .../44-libpython3.8_3.8.10-0ubuntu1~20.04.15_amd64.deb ... 942s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.15) ... 942s Selecting previously unselected package libtcl8.6:amd64. 942s Preparing to unpack .../45-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 942s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 942s Selecting previously unselected package libtinfo-dev:amd64. 942s Preparing to unpack .../46-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 942s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 942s Selecting previously unselected package libxslt1.1:amd64. 942s Preparing to unpack .../47-libxslt1.1_1.1.34-4ubuntu0.20.04.1_amd64.deb ... 942s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.1) ... 942s Selecting previously unselected package llvm-10-runtime. 942s Preparing to unpack .../48-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 942s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 942s Selecting previously unselected package libpfm4:amd64. 942s Preparing to unpack .../49-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 942s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 942s Selecting previously unselected package llvm-10. 942s Preparing to unpack .../50-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 942s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 943s Selecting previously unselected package libffi-dev:amd64. 943s Preparing to unpack .../51-libffi-dev_3.3-4_amd64.deb ... 943s Unpacking libffi-dev:amd64 (3.3-4) ... 943s Selecting previously unselected package python3-pygments. 943s Preparing to unpack .../52-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 943s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 943s Selecting previously unselected package llvm-10-tools. 943s Preparing to unpack .../53-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 943s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 943s Selecting previously unselected package libz3-4:amd64. 943s Preparing to unpack .../54-libz3-4_4.8.7-4build1_amd64.deb ... 943s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 943s Selecting previously unselected package libz3-dev:amd64. 943s Preparing to unpack .../55-libz3-dev_4.8.7-4build1_amd64.deb ... 943s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 943s Selecting previously unselected package llvm-10-dev. 943s Preparing to unpack .../56-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 943s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 946s Selecting previously unselected package postgresql-client-common. 946s Preparing to unpack .../57-postgresql-client-common_214ubuntu0.1_all.deb ... 946s Unpacking postgresql-client-common (214ubuntu0.1) ... 946s Selecting previously unselected package postgresql-client-12. 946s Preparing to unpack .../58-postgresql-client-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 946s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 946s Selecting previously unselected package ssl-cert. 946s Preparing to unpack .../59-ssl-cert_1.0.39_all.deb ... 946s Unpacking ssl-cert (1.0.39) ... 946s Selecting previously unselected package postgresql-common. 946s Preparing to unpack .../60-postgresql-common_214ubuntu0.1_all.deb ... 946s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 946s Unpacking postgresql-common (214ubuntu0.1) ... 946s Selecting previously unselected package postgresql-12. 946s Preparing to unpack .../61-postgresql-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 946s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.1) ... 947s Selecting previously unselected package postgresql-doc-12. 947s Preparing to unpack .../62-postgresql-doc-12_12.22-0ubuntu0.20.04.1_all.deb ... 947s Unpacking postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 948s Selecting previously unselected package postgresql-plperl-12. 948s Preparing to unpack .../63-postgresql-plperl-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 948s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 948s Selecting previously unselected package postgresql-plpython3-12. 948s Preparing to unpack .../64-postgresql-plpython3-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 948s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 948s Selecting previously unselected package postgresql-pltcl-12. 948s Preparing to unpack .../65-postgresql-pltcl-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 948s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 948s Selecting previously unselected package postgresql-server-dev-12. 948s Preparing to unpack .../66-postgresql-server-dev-12_12.22-0ubuntu0.20.04.1_amd64.deb ... 948s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 948s Setting up postgresql-client-common (214ubuntu0.1) ... 948s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.1) ... 948s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 948s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.1) ... 948s Setting up linux-libc-dev:amd64 (5.4.0-208.228) ... 948s Setting up libpq-dev (12.22-0ubuntu0.20.04.1) ... 948s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 948s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 948s Setting up libffi-dev:amd64 (3.3-4) ... 948s Setting up postgresql-doc-12 (12.22-0ubuntu0.20.04.1) ... 948s 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 948s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 948s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 948s Setting up libz3-4:amd64 (4.8.7-4build1) ... 948s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.1) ... 949s 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 949s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 949s Setting up ssl-cert (1.0.39) ... 949s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 949s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.15) ... 949s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 949s Setting up postgresql-common (214ubuntu0.1) ... 949s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 949s Adding user postgres to group ssl-cert 949s 949s Creating config file /etc/postgresql-common/createcluster.conf with new version 949s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 949s Removing obsolete dictionary files: 950s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 950s Setting up libmpc3:amd64 (1.1.0-1) ... 950s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 950s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 950s Setting up binfmt-support (2.2.0-2) ... 950s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 951s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 951s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 951s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.1) ... 951s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.1) ... 951s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 951s Setting up libisl22:amd64 (0.22.1-1) ... 951s Setting up postgresql-12 (12.22-0ubuntu0.20.04.1) ... 951s Creating new PostgreSQL cluster 12/main ... 951s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 951s The files belonging to this database system will be owned by user "postgres". 951s This user must also own the server process. 951s 951s The database cluster will be initialized with locale "C.UTF-8". 951s The default database encoding has accordingly been set to "UTF8". 951s The default text search configuration will be set to "english". 951s 951s Data page checksums are disabled. 951s 951s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 951s creating subdirectories ... ok 951s selecting dynamic shared memory implementation ... posix 951s selecting default max_connections ... 100 951s selecting default shared_buffers ... 128MB 951s selecting default time zone ... Etc/UTC 951s creating configuration files ... ok 951s running bootstrap script ... ok 951s performing post-bootstrap initialization ... ok 952s syncing data to disk ... ok 952s 952s Success. You can now start the database server using: 952s 952s pg_ctlcluster 12 main start 952s 952s Ver Cluster Port Status Owner Data directory Log file 952s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 952s 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 955s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 955s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 955s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 955s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 955s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 955s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.1) ... 955s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 955s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 955s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.1) ... 955s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.1) ... 955s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 955s Setting up libecpg-dev (12.22-0ubuntu0.20.04.1) ... 955s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 955s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 955s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 955s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.1) ... 955s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 955s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 955s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 955s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 955s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 955s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up cpp (4:9.3.0-1ubuntu2) ... 955s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 955s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up gcc (4:9.3.0-1ubuntu2) ... 955s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 955s Setting up g++ (4:9.3.0-1ubuntu2) ... 955s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 955s Setting up build-essential (12.8ubuntu1.1) ... 955s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 955s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.1) ... 955s Processing triggers for systemd (245.4-4ubuntu3.24) ... 955s Processing triggers for man-db (2.9.1-1) ... 957s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 957s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 986s autopkgtest [00:18:19]: test installcheck: [----------------------- 986s + dpkg-parsechangelog -SSource 986s + SOURCE=postgresql-12 986s + MAJOR=12 986s + cd src/test/regress 986s + make -f ../../../debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/12/bin/pg_config with_llvm=no 986s 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 987s 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 987s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.mxFKU0/build.ZGD/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 987s + rm -rf testtablespace results regression.* 987s + mkdir testtablespace results 987s + id -u 987s + [ 1000 = 0 ] 987s + pg_virtualenv -v 12 /usr/lib/postgresql/12/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule 987s Creating new PostgreSQL cluster 12/regress ... 987s /usr/lib/postgresql/12/bin/initdb -D /tmp/pg_virtualenv.vjIVLZ/data/12/regress --auth-local peer --auth-host md5 --username=ubuntu --pwfile=/tmp/pg_virtualenv.vjIVLZ/postgresql-common/pwfile --nosync 987s The files belonging to this database system will be owned by user "ubuntu". 987s This user must also own the server process. 987s 987s The database cluster will be initialized with locale "C.UTF-8". 987s The default database encoding has accordingly been set to "UTF8". 987s The default text search configuration will be set to "english". 987s 987s Data page checksums are disabled. 987s 987s fixing permissions on existing directory /tmp/pg_virtualenv.vjIVLZ/data/12/regress ... ok 987s creating subdirectories ... ok 987s selecting dynamic shared memory implementation ... posix 987s selecting default max_connections ... 100 987s selecting default shared_buffers ... 128MB 987s selecting default time zone ... Etc/UTC 987s creating configuration files ... ok 987s running bootstrap script ... ok 987s performing post-bootstrap initialization ... ok 987s 987s Sync to disk skipped. 987s The data directory might become corrupt if the operating system crashes. 987s 987s Success. You can now start the database server using: 987s 987s pg_ctlcluster 12 regress start 987s 988s Warning: The parent /var/run/postgresql of the selected 988s stats_temp_directory is not writable for the cluster owner. Not adding this 988s setting in postgresql.conf. 990s Ver Cluster Port Status Owner Data directory Log file 990s 12 regress 5433 online ubuntu /tmp/pg_virtualenv.vjIVLZ/data/12/regress /tmp/pg_virtualenv.vjIVLZ/log/postgresql-12-regress.log 990s 990s (using postmaster on localhost, port 5433) 990s ============== dropping database "regression" ============== 990s DROP DATABASE 990s NOTICE: database "regression" does not exist, skipping 990s ============== creating database "regression" ============== 990s CREATE DATABASE 990s ALTER DATABASE 990s ============== running regression test queries ============== 990s test tablespace ... ok 105 ms 990s parallel group (20 tests): char pg_lsn varchar uuid oid txid regproc name int2 text money int4 float4 int8 enum float8 bit boolean numeric rangetypes 990s boolean ... ok 349 ms 990s char ... ok 64 ms 990s name ... ok 153 ms 990s varchar ... ok 114 ms 990s text ... ok 158 ms 990s int2 ... ok 154 ms 990s int4 ... ok 165 ms 990s int8 ... ok 183 ms 990s oid ... ok 134 ms 990s float4 ... ok 182 ms 990s float8 ... ok 242 ms 990s bit ... ok 294 ms 990s numeric ... ok 406 ms 990s txid ... ok 135 ms 990s uuid ... ok 123 ms 990s enum ... ok 239 ms 990s money ... ok 159 ms 990s rangetypes ... ok 453 ms 990s pg_lsn ... ok 87 ms 990s regproc ... ok 138 ms 991s parallel group (19 tests): numerology path circle macaddr lseg time timetz line macaddr8 interval tstypes inet point date box strings timestamp timestamptz polygon 991s strings ... ok 279 ms 991s numerology ... ok 124 ms 991s point ... ok 254 ms 991s lseg ... ok 150 ms 991s line ... ok 159 ms 991s box ... ok 263 ms 991s path ... ok 123 ms 991s polygon ... ok 506 ms 991s circle ... ok 123 ms 991s date ... ok 258 ms 991s time ... ok 149 ms 991s timetz ... ok 152 ms 991s timestamp ... ok 430 ms 991s timestamptz ... FAILED 483 ms 991s interval ... ok 228 ms 991s inet ... ok 252 ms 991s macaddr ... ok 137 ms 991s macaddr8 ... ok 184 ms 991s tstypes ... ok 238 ms 991s parallel group (10 tests): comments misc_sanity expressions geometry type_sanity database oidjoins regex opr_sanity horology 991s geometry ... ok 206 ms 991s horology ... ok 429 ms 991s regex ... ok 383 ms 991s oidjoins ... ok 244 ms 991s type_sanity ... ok 218 ms 991s opr_sanity ... ok 399 ms 991s misc_sanity ... ok 78 ms 991s comments ... ok 43 ms 991s expressions ... ok 99 ms 991s database ... ok 231 ms 991s test create_function_1 ... ok 9 ms 991s test create_type ... ok 13 ms 992s test create_table ... ok 175 ms 992s test create_function_2 ... ok 8 ms 992s parallel group (5 tests): copyselect copydml insert_conflict insert copy 992s copy ... ok 241 ms 992s copyselect ... ok 22 ms 992s copydml ... ok 37 ms 992s insert ... ok 192 ms 992s insert_conflict ... ok 137 ms 992s parallel group (4 tests): create_procedure create_schema create_operator create_misc 992s create_misc ... ok 58 ms 992s create_operator ... ok 41 ms 992s create_procedure ... ok 29 ms 992s create_schema ... ok 37 ms 993s parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 993s create_index ... ok 881 ms 993s create_index_spgist ... ok 826 ms 993s create_view ... ok 231 ms 993s index_including ... ok 186 ms 993s index_including_gist ... ok 269 ms 994s parallel group (16 tests): create_cast hash_func create_function_3 create_am roleattributes errors typed_table create_aggregate drop_if_exists constraints vacuum infinite_recurse select updatable_views triggers inherit 994s create_aggregate ... ok 254 ms 994s create_function_3 ... ok 118 ms 994s create_cast ... ok 83 ms 994s constraints ... ok 384 ms 994s triggers ... ok 765 ms 994s select ... ok 428 ms 994s inherit ... ok 790 ms 994s typed_table ... ok 195 ms 994s vacuum ... ok 393 ms 994s drop_if_exists ... ok 267 ms 994s updatable_views ... ok 680 ms 994s roleattributes ... ok 162 ms 994s create_am ... ok 117 ms 994s hash_func ... ok 111 ms 994s errors ... ok 191 ms 994s infinite_recurse ... ok 409 ms 994s test sanity_check ... ok 81 ms 995s parallel group (20 tests): select_distinct_on random namespace select_having select_distinct select_implicit delete transactions portals select_into prepared_xacts case union subselect hash_index aggregates arrays btree_index update join 995s select_into ... ok 220 ms 995s select_distinct ... ok 115 ms 995s select_distinct_on ... ok 60 ms 995s select_implicit ... ok 120 ms 995s select_having ... ok 110 ms 995s subselect ... ok 382 ms 995s union ... ok 349 ms 995s case ... ok 232 ms 995s join ... ok 1046 ms 995s aggregates ... ok 543 ms 995s transactions ... ok 184 ms 995s random ... ok 69 ms 995s portals ... ok 204 ms 995s arrays ... ok 560 ms 995s btree_index ... ok 617 ms 995s hash_index ... ok 506 ms 995s update ... ok 705 ms 995s delete ... ok 152 ms 995s namespace ... ok 78 ms 995s prepared_xacts ... ok 227 ms 1000s parallel group (20 tests): security_label init_privs drop_operator tablesample lock password object_address replica_identity identity gin generated matview rowsecurity groupingsets collate spgist gist brin join_hash privileges 1000s brin ... ok 5639 ms 1000s gin ... ok 1185 ms 1000s gist ... ok 2043 ms 1001s spgist ... ok 1787 ms 1001s privileges ... ok 5760 ms 1001s init_privs ... ok 170 ms 1001s security_label ... ok 132 ms 1001s collate ... ok 1714 ms 1001s matview ... ok 1218 ms 1001s lock ... ok 422 ms 1001s replica_identity ... ok 529 ms 1001s rowsecurity ... ok 1619 ms 1001s object_address ... ok 527 ms 1001s tablesample ... ok 412 ms 1001s groupingsets ... ok 1690 ms 1001s drop_operator ... ok 284 ms 1001s password ... ok 441 ms 1001s identity ... ok 635 ms 1001s generated ... ok 1190 ms 1001s join_hash ... ok 5640 ms 1001s parallel group (11 tests): async dbsize alter_operator tidscan tid tsrf alter_generic create_table_like sysviews misc_functions misc 1001s create_table_like ... ok 302 ms 1001s alter_generic ... ok 209 ms 1001s alter_operator ... ok 56 ms 1001s misc ... ok 822 ms 1001s async ... ok 47 ms 1001s dbsize ... ok 51 ms 1001s misc_functions ... ok 550 ms 1001s sysviews ... ok 549 ms 1001s tsrf ... ok 155 ms 1001s tid ... ok 139 ms 1001s tidscan ... ok 137 ms 1002s parallel group (5 tests): psql_crosstab amutils psql rules stats_ext 1002s rules ... ok 297 ms 1002s psql ... ok 228 ms 1002s psql_crosstab ... ok 27 ms 1002s amutils ... ok 54 ms 1002s stats_ext ... ok 591 ms 1004s test select_parallel ... ok 2253 ms 1004s test write_parallel ... ok 54 ms 1004s parallel group (2 tests): subscription publication 1004s publication ... ok 55 ms 1004s subscription ... ok 32 ms 1006s parallel group (17 tests): portals_p2 advisory_lock select_views functional_deps combocid xmlmap dependency tsdicts guc equivclass window cluster bitmapops indirect_toast foreign_data tsearch foreign_key 1006s select_views ... ok 278 ms 1006s portals_p2 ... ok 79 ms 1006s foreign_key ... ok 1248 ms 1006s cluster ... ok 762 ms 1006s dependency ... ok 381 ms 1006s guc ... ok 437 ms 1006s bitmapops ... ok 798 ms 1006s combocid ... ok 329 ms 1006s tsearch ... ok 1141 ms 1006s tsdicts ... ok 410 ms 1006s foreign_data ... ok 1093 ms 1006s window ... ok 638 ms 1006s xmlmap ... ok 348 ms 1006s functional_deps ... ok 283 ms 1006s advisory_lock ... ok 259 ms 1006s indirect_toast ... ok 962 ms 1006s equivclass ... ok 510 ms 1006s parallel group (6 tests): jsonpath_encoding json_encoding jsonpath jsonb_jsonpath json jsonb 1006s json ... ok 142 ms 1006s jsonb ... ok 161 ms 1006s json_encoding ... ok 51 ms 1006s jsonpath ... ok 73 ms 1006s jsonpath_encoding ... ok 46 ms 1006s jsonb_jsonpath ... ok 120 ms 1007s parallel group (18 tests): conversion limit prepare returning temp plancache copy2 with truncate sequence rowtypes polymorphism largeobject domain rangefuncs xml plpgsql alter_table 1007s plancache ... ok 322 ms 1007s limit ... ok 100 ms 1007s plpgsql ... ok 906 ms 1007s copy2 ... ok 352 ms 1007s temp ... ok 301 ms 1007s domain ... ok 660 ms 1007s rangefuncs ... ok 843 ms 1007s prepare ... ok 107 ms 1007s conversion ... ok 68 ms 1007s truncate ... ok 461 ms 1007s alter_table ... ok 1206 ms 1007s sequence ... ok 498 ms 1007s polymorphism ... ok 546 ms 1007s rowtypes ... ok 518 ms 1007s returning ... ok 281 ms 1007s largeobject ... ok 605 ms 1007s with ... ok 421 ms 1007s xml ... ok 878 ms 1008s parallel group (7 tests): reloptions hash_part partition_info partition_join partition_aggregate indexing partition_prune 1008s partition_join ... ok 496 ms 1008s partition_prune ... ok 915 ms 1008s reloptions ... ok 56 ms 1008s hash_part ... ok 66 ms 1008s indexing ... ok 672 ms 1008s partition_aggregate ... ok 546 ms 1008s partition_info ... ok 88 ms 1008s test event_trigger ... ok 61 ms 1008s test fast_default ... ok 75 ms 1009s test stats ... ok 560 ms 1009s 1009s ======================== 1009s 1 of 196 tests failed. 1009s ======================== 1009s 1009s The differences that caused some tests to fail can be viewed in the 1009s file "/tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/regression.diffs". A copy of the test summary that you see 1009s above is saved in the file "/tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/regression.out". 1009s 1009s *** /tmp/pg_virtualenv.vjIVLZ/log/postgresql-12-regress.log (last 100 lines) *** 1009s 2025-02-27 00:18:41.115 UTC [6435] ubuntu@regression DETAIL: Key (a)=(3) already exists. 1009s 2025-02-27 00:18:41.115 UTC [6435] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression DETAIL: Key (a)=(4) already exists. 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 1009s 2025-02-27 00:18:41.117 UTC [6435] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 1009s 2025-02-27 00:18:41.118 UTC [6435] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 1009s 2025-02-27 00:18:41.118 UTC [6435] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 1009s 2025-02-27 00:18:41.120 UTC [6435] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 1009s 2025-02-27 00:18:41.120 UTC [6435] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 1009s 2025-02-27 00:18:41.144 UTC [6435] ubuntu@regression ERROR: division by zero 1009s 2025-02-27 00:18:41.144 UTC [6435] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 1009s 2025-02-27 00:18:41.408 UTC [6517] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 1009s 2025-02-27 00:18:41.408 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 1009s on ddl_command_start 1009s execute procedure pg_backend_pid(); 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression ERROR: trigger functions can only be called as triggers 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 1009s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 1009s SELECT 1 $$ language sql; 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 1009s 2025-02-27 00:18:41.409 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: unrecognized filter variable "food" 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when food in ('sandwich') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('sandwich') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('create table', 'create skunkcabbage') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('DROP EVENT TRIGGER') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('CREATE ROLE') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('CREATE DATABASE') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('CREATE TABLESPACE') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: filter variable "tag" specified more than once 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s when tag in ('create table') and tag in ('CREATE FUNCTION') 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 1009s execute procedure test_event_trigger('argument not allowed'); 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression HINT: Must be superuser to create an event trigger. 1009s 2025-02-27 00:18:41.410 UTC [6517] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 1009s execute procedure test_event_trigger(); 1009s 2025-02-27 00:18:41.417 UTC [6517] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 1009s 2025-02-27 00:18:41.417 UTC [6517] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 1009s 2025-02-27 00:18:41.417 UTC [6517] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 1009s 2025-02-27 00:18:41.417 UTC [6517] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 1009s 2025-02-27 00:18:41.417 UTC [6517] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 1009s 2025-02-27 00:18:41.418 UTC [6517] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 1009s 2025-02-27 00:18:41.418 UTC [6517] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 1009s 2025-02-27 00:18:41.418 UTC [6517] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 1009s 2025-02-27 00:18:41.418 UTC [6517] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 1009s owner of user mapping for regress_evt_user on server useless_server 1009s owner of default privileges on new relations belonging to role regress_evt_user 1009s 2025-02-27 00:18:41.418 UTC [6517] ubuntu@regression STATEMENT: drop role regress_evt_user; 1009s 2025-02-27 00:18:41.427 UTC [6517] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 1009s 2025-02-27 00:18:41.427 UTC [6517] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 1009s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 1009s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 1009s 2025-02-27 00:18:41.427 UTC [6517] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 1009s 2025-02-27 00:18:41.429 UTC [6517] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 1009s 2025-02-27 00:18:41.429 UTC [6517] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 1009s 2025-02-27 00:18:41.429 UTC [6517] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 1009s 2025-02-27 00:18:41.446 UTC [6517] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 1009s 2025-02-27 00:18:41.446 UTC [6517] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 1009s 2025-02-27 00:18:41.449 UTC [6517] ubuntu@regression ERROR: rewrites not allowed 1009s 2025-02-27 00:18:41.449 UTC [6517] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 1009s 2025-02-27 00:18:41.449 UTC [6517] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 1009s 2025-02-27 00:18:41.458 UTC [6517] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 1009s 2025-02-27 00:18:41.458 UTC [6517] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 1009s 2025-02-27 00:18:42.093 UTC [6526] ubuntu@regression LOG: wait_for_stats delayed 0.51811 seconds 1009s 2025-02-27 00:18:42.093 UTC [6526] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 1009s 2025-02-27 00:18:42.093 UTC [6526] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 1009s Dropping cluster 12/regress ... 1009s + cat regression.diffs 1009s diff -U3 /tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/expected/timestamptz.out /tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/results/timestamptz.out 1009s --- /tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:41:03.000000000 +0000 1009s +++ /tmp/autopkgtest.mxFKU0/build.ZGD/src/src/test/regress/results/timestamptz.out 2025-02-27 00:18:24.389423385 +0000 1009s @@ -2060,7 +2060,7 @@ 1009s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 1009s timezone 1009s -------------------------- 1009s - Wed Dec 09 15:56:00 1846 1009s + Wed Dec 09 15:56:08 1846 1009s (1 row) 1009s 1009s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 1009s + exit 1 1009s autopkgtest [00:18:42]: test installcheck: -----------------------] 1010s autopkgtest [00:18:43]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 1010s installcheck FAIL non-zero exit status 1 1010s autopkgtest [00:18:43]: @@@@@@@@@@@@@@@@@@@@ summary 1010s run-testsuite PASS 1010s installcheck FAIL non-zero exit status 1 1145s nova [W] Skipping flock for amd64 1145s Creating nova instance adt-focal-amd64-postgresql-12-20250227-000152-juju-7f2275-prod-proposed-migration-environment-20-2f9aedc8-eb4f-49c5-8cb5-e9a7e14fa765 from image adt/ubuntu-focal-amd64-server-20250226.img (UUID a697b2aa-2d6f-4246-bbeb-b1891145fff1)... 1145s nova [W] Timed out waiting for a9fbba70-1880-481a-8882-005d9bc9342e to get deleted. 1145s nova [W] Skipping flock for amd64 1145s Creating nova instance adt-focal-amd64-postgresql-12-20250227-000152-juju-7f2275-prod-proposed-migration-environment-20-2f9aedc8-eb4f-49c5-8cb5-e9a7e14fa765 from image adt/ubuntu-focal-amd64-server-20250226.img (UUID a697b2aa-2d6f-4246-bbeb-b1891145fff1)... 1145s nova [W] Timed out waiting for 7b01dd6f-b6b4-4509-9438-a9dcb28f962d to get deleted.