0s autopkgtest [14:54:08]: starting date and time: 2025-03-26 14:54:08+0000 0s autopkgtest [14:54:08]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:54:08]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.wazkqxo7/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-12 --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-12/12.22-0ubuntu0.20.04.3 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-28.secgroup --name adt-focal-amd64-postgresql-common-20250326-145408-juju-7f2275-prod-proposed-migration-environment-15-81abf638-1551-46a3-9c17-f88e799fe8d4 --image adt/ubuntu-focal-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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/ 53s autopkgtest [14:55:01]: testbed dpkg architecture: amd64 53s autopkgtest [14:55:01]: testbed apt version: 2.0.10 53s autopkgtest [14:55:01]: @@@@@@@@@@@@@@@@@@@@ test bed setup 54s autopkgtest [14:55:02]: testbed release detected to be: None 55s autopkgtest [14:55:02]: updating testbed package index (apt update) 55s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 55s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 55s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 55s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 55s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 56s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 56s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 56s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [80.6 kB] 56s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [364 kB] 56s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1608 B] 56s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [1524 B] 56s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [574 kB] 56s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 56s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [48.4 kB] 56s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [30.5 kB] 56s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 56s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [1020 B] 56s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 56s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 57s Fetched 1465 kB in 1s (1359 kB/s) 59s Reading package lists... 60s autopkgtest [14:55:08]: upgrading testbed (apt dist-upgrade and autopurge) 60s Reading package lists... 60s Building dependency tree... 60s Reading state information... 60s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 60s Starting 2 pkgProblemResolver with broken count: 0 60s Done 60s 61s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 61s Starting pkgProblemResolver with broken count: 0 62s Starting 2 pkgProblemResolver with broken count: 0 62s Done 62s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s autopkgtest [14:55:12]: testbed running kernel: Linux 5.4.0-211-generic #231-Ubuntu SMP Tue Mar 11 17:06:58 UTC 2025 64s autopkgtest [14:55:12]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 71s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (dsc) [2534 B] 71s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (tar) [216 kB] 71s gpgv: Signature made Mon Aug 24 15:04:29 2020 UTC 71s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 71s gpgv: Can't check signature: No public key 71s dpkg-source: warning: failed to verify signature on ./postgresql-common_214ubuntu0.1.dsc 71s autopkgtest [14:55:19]: testing package postgresql-common version 214ubuntu0.1 72s autopkgtest [14:55:20]: build not needed 72s autopkgtest [14:55:20]: test default-psql: preparing testbed 72s Reading package lists... 73s Building dependency tree... 73s Reading state information... 73s Starting pkgProblemResolver with broken count: 0 73s Starting 2 pkgProblemResolver with broken count: 0 73s Done 73s The following NEW packages will be installed: 73s libllvm10 libpq5 libxslt1.1 postgresql postgresql-12 postgresql-client-12 73s postgresql-client-common postgresql-common ssl-cert 73s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 73s Need to get 30.4 MB of archives. 73s After this operation, 121 MB of additional disk space will be used. 73s Get:1 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 74s Get:2 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 74s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 74s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 74s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 74s Get:6 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 74s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 74s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 76s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql all 12+214ubuntu0.1 [3924 B] 76s Preconfiguring packages ... 76s Fetched 30.4 MB in 2s (17.7 MB/s) 76s Selecting previously unselected package libllvm10:amd64. 76s (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 ... 66345 files and directories currently installed.) 76s Preparing to unpack .../0-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 76s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 77s Selecting previously unselected package libpq5:amd64. 77s Preparing to unpack .../1-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 77s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 77s Selecting previously unselected package libxslt1.1:amd64. 77s Preparing to unpack .../2-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 77s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 77s Selecting previously unselected package postgresql-client-common. 77s Preparing to unpack .../3-postgresql-client-common_214ubuntu0.1_all.deb ... 77s Unpacking postgresql-client-common (214ubuntu0.1) ... 77s Selecting previously unselected package postgresql-client-12. 77s Preparing to unpack .../4-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 77s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 78s Selecting previously unselected package ssl-cert. 78s Preparing to unpack .../5-ssl-cert_1.0.39_all.deb ... 78s Unpacking ssl-cert (1.0.39) ... 78s Selecting previously unselected package postgresql-common. 78s Preparing to unpack .../6-postgresql-common_214ubuntu0.1_all.deb ... 78s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 78s Unpacking postgresql-common (214ubuntu0.1) ... 78s Selecting previously unselected package postgresql-12. 78s Preparing to unpack .../7-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 78s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 79s Selecting previously unselected package postgresql. 79s Preparing to unpack .../8-postgresql_12+214ubuntu0.1_all.deb ... 79s Unpacking postgresql (12+214ubuntu0.1) ... 79s Setting up postgresql-client-common (214ubuntu0.1) ... 79s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 79s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 79s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 79s 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 79s Setting up ssl-cert (1.0.39) ... 80s Setting up postgresql-common (214ubuntu0.1) ... 80s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 80s Adding user postgres to group ssl-cert 80s 80s Creating config file /etc/postgresql-common/createcluster.conf with new version 80s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 80s Removing obsolete dictionary files: 81s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 81s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 81s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 82s Creating new PostgreSQL cluster 12/main ... 82s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 82s The files belonging to this database system will be owned by user "postgres". 82s This user must also own the server process. 82s 82s The database cluster will be initialized with locale "C.UTF-8". 82s The default database encoding has accordingly been set to "UTF8". 82s The default text search configuration will be set to "english". 82s 82s Data page checksums are disabled. 82s 82s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 82s creating subdirectories ... ok 82s selecting dynamic shared memory implementation ... posix 82s selecting default max_connections ... 100 82s selecting default shared_buffers ... 128MB 82s selecting default time zone ... Etc/UTC 82s creating configuration files ... ok 82s running bootstrap script ... ok 83s performing post-bootstrap initialization ... ok 83s syncing data to disk ... ok 83s 83s Success. You can now start the database server using: 83s 83s pg_ctlcluster 12 main start 83s 83s Ver Cluster Port Status Owner Data directory Log file 83s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 83s 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 86s Setting up postgresql (12+214ubuntu0.1) ... 86s Processing triggers for systemd (245.4-4ubuntu3.24) ... 86s Processing triggers for man-db (2.9.1-1) ... 88s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 89s autopkgtest [14:55:37]: test default-psql: [----------------------- 90s autopkgtest [14:55:38]: test default-psql: -----------------------] 90s autopkgtest [14:55:38]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 90s default-psql PASS 91s autopkgtest [14:55:39]: test run-testsuite: preparing testbed 155s autopkgtest [14:56:43]: testbed dpkg architecture: amd64 155s autopkgtest [14:56:43]: testbed apt version: 2.0.10 156s autopkgtest [14:56:44]: @@@@@@@@@@@@@@@@@@@@ test bed setup 156s autopkgtest [14:56:44]: testbed release detected to be: focal 156s autopkgtest [14:56:44]: updating testbed package index (apt update) 157s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 157s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 158s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 158s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 158s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 158s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 158s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 158s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [364 kB] 158s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [80.6 kB] 158s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1608 B] 158s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [1524 B] 158s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [574 kB] 158s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 158s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [30.5 kB] 158s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [48.4 kB] 158s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 158s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [1020 B] 158s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 158s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 159s Fetched 1465 kB in 1s (1293 kB/s) 161s Reading package lists... 162s autopkgtest [14:56:50]: upgrading testbed (apt dist-upgrade and autopurge) 162s Reading package lists... 162s Building dependency tree... 162s Reading state information... 162s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 162s Starting 2 pkgProblemResolver with broken count: 0 162s Done 162s 163s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 163s Reading package lists... 163s Building dependency tree... 163s Reading state information... 163s Starting pkgProblemResolver with broken count: 0 164s Starting 2 pkgProblemResolver with broken count: 0 164s Done 164s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 168s Reading package lists... 168s Building dependency tree... 168s Reading state information... 168s Starting pkgProblemResolver with broken count: 0 168s Starting 2 pkgProblemResolver with broken count: 0 168s Done 168s The following NEW packages will be installed: 168s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 168s emacsen-common fakeroot g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us 168s lib32gcc-s1 lib32stdc++6 libasan5 libatomic1 libc-dev-bin libc6-dev 168s libc6-i386 libcc1-0 libclang-common-10-dev libclang-cpp10 libclang1-10 168s libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 168s libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 168s libncurses-dev libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 168s libpython3.8 libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 168s libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 169s llvm-10-runtime llvm-10-tools net-tools postgresql-12 postgresql-all 169s postgresql-client-12 postgresql-client-common postgresql-common 169s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 169s postgresql-server-dev-12 postgresql-server-dev-all python3-pygments ssl-cert 169s 0 upgraded, 74 newly installed, 0 to remove and 0 not upgraded. 169s Need to get 141 MB of archives. 169s After this operation, 738 MB of additional disk space will be used. 169s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 169s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 169s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-211.231 [1116 kB] 169s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 169s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 169s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 169s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 169s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 169s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 169s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 169s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 169s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 169s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 169s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 169s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 169s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 169s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 170s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 170s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 170s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 170s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 170s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 170s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 170s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 170s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 170s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 170s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 170s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 171s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 171s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 171s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 171s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 171s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 171s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 171s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 171s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 171s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 171s Get:38 http://ftpmaster.internal/ubuntu focal/main amd64 emacsen-common all 3.0.4 [14.9 kB] 171s Get:39 http://ftpmaster.internal/ubuntu focal/main amd64 dictionaries-common all 1.28.1 [178 kB] 171s Get:40 http://ftpmaster.internal/ubuntu focal/main amd64 libfakeroot amd64 1.24-1 [25.7 kB] 171s Get:41 http://ftpmaster.internal/ubuntu focal/main amd64 fakeroot amd64 1.24-1 [62.6 kB] 171s Get:42 http://ftpmaster.internal/ubuntu focal/main amd64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 171s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.3 [45.7 kB] 171s Get:44 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 171s Get:45 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.3 [43.4 kB] 171s Get:46 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.3 [12.7 kB] 171s Get:47 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.3 [138 kB] 171s Get:48 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.3 [239 kB] 171s Get:49 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 171s Get:50 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.18 [1625 kB] 171s Get:51 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 171s Get:52 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 171s Get:53 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 171s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 171s Get:55 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 171s Get:56 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 171s Get:57 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 171s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 172s Get:59 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 172s Get:60 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 172s Get:61 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 172s Get:62 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 173s Get:63 http://ftpmaster.internal/ubuntu focal/main amd64 net-tools amd64 1.60+git20180626.aebd88e-1ubuntu1 [196 kB] 173s Get:64 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 173s Get:65 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 173s Get:66 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 173s Get:67 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 173s Get:68 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 173s Get:69 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.3 [995 kB] 173s Get:70 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-server-dev-all all 214ubuntu0.1 [7652 B] 173s Get:71 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.3 [68.6 kB] 173s Get:72 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.3 [76.5 kB] 173s Get:73 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.3 [31.6 kB] 173s Get:74 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-all all 12+214ubuntu0.1 [1924 B] 174s Preconfiguring packages ... 174s Fetched 141 MB in 4s (32.3 MB/s) 174s Selecting previously unselected package binfmt-support. 174s (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 ... 66345 files and directories currently installed.) 174s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 174s Unpacking binfmt-support (2.2.0-2) ... 174s Selecting previously unselected package libc-dev-bin. 174s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 174s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 174s Selecting previously unselected package linux-libc-dev:amd64. 174s Preparing to unpack .../02-linux-libc-dev_5.4.0-211.231_amd64.deb ... 174s Unpacking linux-libc-dev:amd64 (5.4.0-211.231) ... 174s Selecting previously unselected package libcrypt-dev:amd64. 174s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 174s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 174s Selecting previously unselected package libc6-dev:amd64. 174s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 174s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 175s Selecting previously unselected package gcc-9-base:amd64. 175s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 175s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 175s Selecting previously unselected package libisl22:amd64. 175s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 175s Unpacking libisl22:amd64 (0.22.1-1) ... 175s Selecting previously unselected package libmpc3:amd64. 175s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 175s Unpacking libmpc3:amd64 (1.1.0-1) ... 175s Selecting previously unselected package cpp-9. 175s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 175s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 175s Selecting previously unselected package cpp. 175s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 175s Unpacking cpp (4:9.3.0-1ubuntu2) ... 175s Selecting previously unselected package libcc1-0:amd64. 175s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 175s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 175s Selecting previously unselected package libgomp1:amd64. 175s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 175s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 175s Selecting previously unselected package libitm1:amd64. 175s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 175s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libatomic1:amd64. 176s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 176s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libasan5:amd64. 176s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 176s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 176s Selecting previously unselected package liblsan0:amd64. 176s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 176s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libtsan0:amd64. 176s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 176s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libubsan1:amd64. 176s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 176s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libquadmath0:amd64. 176s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 176s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 176s Selecting previously unselected package libgcc-9-dev:amd64. 176s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 176s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 177s Selecting previously unselected package gcc-9. 177s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 177s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 178s Selecting previously unselected package gcc. 178s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 178s Unpacking gcc (4:9.3.0-1ubuntu2) ... 178s Selecting previously unselected package libstdc++-9-dev:amd64. 178s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 178s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 178s Selecting previously unselected package g++-9. 178s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 178s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 178s Selecting previously unselected package g++. 178s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 178s Unpacking g++ (4:9.3.0-1ubuntu2) ... 178s Selecting previously unselected package build-essential. 178s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 178s Unpacking build-essential (12.8ubuntu1.1) ... 178s Selecting previously unselected package libllvm10:amd64. 178s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 178s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 180s Selecting previously unselected package libclang-cpp10. 180s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 180s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 180s Selecting previously unselected package libgc1c2:amd64. 180s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 180s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 180s Selecting previously unselected package libobjc4:amd64. 180s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 180s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 180s Selecting previously unselected package libobjc-9-dev:amd64. 180s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 180s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 180s Selecting previously unselected package libc6-i386. 180s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 180s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 181s Selecting previously unselected package lib32gcc-s1. 181s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 181s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 181s Selecting previously unselected package lib32stdc++6. 181s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 181s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 181s Selecting previously unselected package libclang-common-10-dev. 181s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 181s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 181s Selecting previously unselected package libclang1-10. 181s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 181s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 182s Selecting previously unselected package clang-10. 182s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 182s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 182s Selecting previously unselected package emacsen-common. 182s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 182s Unpacking emacsen-common (3.0.4) ... 182s Selecting previously unselected package dictionaries-common. 182s Preparing to unpack .../38-dictionaries-common_1.28.1_all.deb ... 182s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 182s Unpacking dictionaries-common (1.28.1) ... 182s Selecting previously unselected package libfakeroot:amd64. 182s Preparing to unpack .../39-libfakeroot_1.24-1_amd64.deb ... 182s Unpacking libfakeroot:amd64 (1.24-1) ... 182s Selecting previously unselected package fakeroot. 182s Preparing to unpack .../40-fakeroot_1.24-1_amd64.deb ... 182s Unpacking fakeroot (1.24-1) ... 182s Selecting previously unselected package hunspell-en-us. 182s Preparing to unpack .../41-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 182s Unpacking hunspell-en-us (1:2018.04.16-1) ... 182s Selecting previously unselected package libpgtypes3:amd64. 182s Preparing to unpack .../42-libpgtypes3_12.22-0ubuntu0.20.04.3_amd64.deb ... 182s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 182s Selecting previously unselected package libpq5:amd64. 182s Preparing to unpack .../43-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 182s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 182s Selecting previously unselected package libecpg6:amd64. 182s Preparing to unpack .../44-libecpg6_12.22-0ubuntu0.20.04.3_amd64.deb ... 182s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 182s Selecting previously unselected package libecpg-compat3:amd64. 182s Preparing to unpack .../45-libecpg-compat3_12.22-0ubuntu0.20.04.3_amd64.deb ... 182s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 182s Selecting previously unselected package libpq-dev. 183s Preparing to unpack .../46-libpq-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 183s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 183s Selecting previously unselected package libecpg-dev. 183s Preparing to unpack .../47-libecpg-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 183s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 183s Selecting previously unselected package libncurses-dev:amd64. 183s Preparing to unpack .../48-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 183s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 183s Selecting previously unselected package libpython3.8:amd64. 183s Preparing to unpack .../49-libpython3.8_3.8.10-0ubuntu1~20.04.18_amd64.deb ... 183s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 183s Selecting previously unselected package libtcl8.6:amd64. 183s Preparing to unpack .../50-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 183s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 183s Selecting previously unselected package libtinfo-dev:amd64. 183s Preparing to unpack .../51-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 183s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 183s Selecting previously unselected package libxslt1.1:amd64. 183s Preparing to unpack .../52-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 183s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 183s Selecting previously unselected package llvm-10-runtime. 183s Preparing to unpack .../53-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 183s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 183s Selecting previously unselected package libpfm4:amd64. 183s Preparing to unpack .../54-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 183s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 183s Selecting previously unselected package llvm-10. 183s Preparing to unpack .../55-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 183s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 183s Selecting previously unselected package libffi-dev:amd64. 183s Preparing to unpack .../56-libffi-dev_3.3-4_amd64.deb ... 183s Unpacking libffi-dev:amd64 (3.3-4) ... 183s Selecting previously unselected package python3-pygments. 183s Preparing to unpack .../57-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 183s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 184s Selecting previously unselected package llvm-10-tools. 184s Preparing to unpack .../58-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 184s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 184s Selecting previously unselected package libz3-4:amd64. 184s Preparing to unpack .../59-libz3-4_4.8.7-4build1_amd64.deb ... 184s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 184s Selecting previously unselected package libz3-dev:amd64. 184s Preparing to unpack .../60-libz3-dev_4.8.7-4build1_amd64.deb ... 184s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 184s Selecting previously unselected package llvm-10-dev. 184s Preparing to unpack .../61-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 184s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 187s Selecting previously unselected package net-tools. 187s Preparing to unpack .../62-net-tools_1.60+git20180626.aebd88e-1ubuntu1_amd64.deb ... 187s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 187s Selecting previously unselected package postgresql-client-common. 187s Preparing to unpack .../63-postgresql-client-common_214ubuntu0.1_all.deb ... 187s Unpacking postgresql-client-common (214ubuntu0.1) ... 187s Selecting previously unselected package postgresql-client-12. 187s Preparing to unpack .../64-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 187s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 187s Selecting previously unselected package ssl-cert. 187s Preparing to unpack .../65-ssl-cert_1.0.39_all.deb ... 187s Unpacking ssl-cert (1.0.39) ... 187s Selecting previously unselected package postgresql-common. 187s Preparing to unpack .../66-postgresql-common_214ubuntu0.1_all.deb ... 187s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 187s Unpacking postgresql-common (214ubuntu0.1) ... 187s Selecting previously unselected package postgresql-12. 187s Preparing to unpack .../67-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 187s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 188s Selecting previously unselected package postgresql-server-dev-12. 188s Preparing to unpack .../68-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 188s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 188s Selecting previously unselected package postgresql-server-dev-all. 188s Preparing to unpack .../69-postgresql-server-dev-all_214ubuntu0.1_all.deb ... 188s Unpacking postgresql-server-dev-all (214ubuntu0.1) ... 188s Selecting previously unselected package postgresql-plperl-12. 188s Preparing to unpack .../70-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 188s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 188s Selecting previously unselected package postgresql-plpython3-12. 188s Preparing to unpack .../71-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 188s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 188s Selecting previously unselected package postgresql-pltcl-12. 188s Preparing to unpack .../72-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 188s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 188s Selecting previously unselected package postgresql-all. 188s Preparing to unpack .../73-postgresql-all_12+214ubuntu0.1_all.deb ... 188s Unpacking postgresql-all (12+214ubuntu0.1) ... 189s Setting up postgresql-client-common (214ubuntu0.1) ... 189s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 189s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 189s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 189s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 189s Setting up linux-libc-dev:amd64 (5.4.0-211.231) ... 189s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 189s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 189s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 189s Setting up libffi-dev:amd64 (3.3-4) ... 189s Setting up libfakeroot:amd64 (1.24-1) ... 189s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 189s Setting up fakeroot (1.24-1) ... 189s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 189s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 189s Setting up libz3-4:amd64 (4.8.7-4build1) ... 189s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 189s 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 189s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 189s Setting up emacsen-common (3.0.4) ... 189s Setting up ssl-cert (1.0.39) ... 190s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 190s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 190s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 190s Setting up postgresql-common (214ubuntu0.1) ... 190s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 190s Adding user postgres to group ssl-cert 190s 190s Creating config file /etc/postgresql-common/createcluster.conf with new version 190s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 190s en_us 190s Removing obsolete dictionary files: 191s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 191s Setting up libmpc3:amd64 (1.1.0-1) ... 191s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 191s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 191s Setting up binfmt-support (2.2.0-2) ... 192s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 192s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 192s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 192s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 192s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 192s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 192s Setting up libisl22:amd64 (0.22.1-1) ... 192s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 192s Creating new PostgreSQL cluster 12/main ... 192s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 192s The files belonging to this database system will be owned by user "postgres". 192s This user must also own the server process. 192s 192s The database cluster will be initialized with locale "C.UTF-8". 192s The default database encoding has accordingly been set to "UTF8". 192s The default text search configuration will be set to "english". 192s 192s Data page checksums are disabled. 192s 192s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 192s creating subdirectories ... ok 192s selecting dynamic shared memory implementation ... posix 192s selecting default max_connections ... 100 192s selecting default shared_buffers ... 128MB 192s selecting default time zone ... Etc/UTC 192s creating configuration files ... ok 192s running bootstrap script ... ok 193s performing post-bootstrap initialization ... ok 193s syncing data to disk ... ok 193s 193s Success. You can now start the database server using: 193s 193s pg_ctlcluster 12 main start 193s 193s Ver Cluster Port Status Owner Data directory Log file 193s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 193s 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 196s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 196s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 196s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 196s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 196s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 196s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 196s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 196s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 196s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 196s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 196s Setting up dictionaries-common (1.28.1) ... 196s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 196s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 196s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 196s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 196s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 196s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 196s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 197s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 197s Setting up hunspell-en-us (1:2018.04.16-1) ... 197s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 197s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 197s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 197s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 197s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 197s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up cpp (4:9.3.0-1ubuntu2) ... 197s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 197s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up gcc (4:9.3.0-1ubuntu2) ... 197s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 197s Setting up g++ (4:9.3.0-1ubuntu2) ... 197s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 197s Setting up build-essential (12.8ubuntu1.1) ... 197s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 197s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 197s Setting up postgresql-server-dev-all (214ubuntu0.1) ... 197s Setting up postgresql-all (12+214ubuntu0.1) ... 197s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 197s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 197s Processing triggers for systemd (245.4-4ubuntu3.24) ... 197s Processing triggers for man-db (2.9.1-1) ... 200s Processing triggers for dictionaries-common (1.28.1) ... 202s autopkgtest [14:57:30]: test run-testsuite: [----------------------- 202s Generating locales (this might take a while)... 204s en_US.UTF-8... done 204s ru_RU.ISO-8859-5... done 206s ru_RU.UTF-8... done 206s Generation complete. 206s ====== Running all tests with umask 077 ======= 206s === Running test 001_packages.t ... === 206s 1..18 206s # PostgreSQL versions installed: 12 206s ok 1 - postgresql-12 installed 206s ok 2 # skip No python2 support 206s ok 3 - postgresql-plpython3-12 installed 206s ok 4 - postgresql-plperl-12 installed 206s ok 5 - postgresql-pltcl-12 installed 206s ok 6 - postgresql-server-dev-12 installed 206s ok 7 # skip No postgresql-contrib-12 package for version 12 206s ok 8 - libecpg-dev installed 206s ok 9 - procps installed 206s ok 10 - netcat-openbsd installed 206s ok 11 - hunspell-en-us installed 206s ok 12 - system has a default UTF-8 locale 206s ok 13 - locale ru_RU exists 206s ok 14 - locale ru_RU.UTF-8 exists 206s ok 15 - user postgres in the UNIX group ssl-cert 206s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 206s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 206s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 206s === Running test 002_existing_clusters.t ... === 206s 1..8 206s ok 1 - Cleanup: No clusters left behind 206s ok 2 - No postgres processes left behind 206s ok 3 - No files in /etc/postgresql left behind 206s ok 4 - No files in /var/lib/postgresql left behind 206s ok 5 - No files in /var/run/postgresql left behind 206s ok 6 - No files in /var/log/postgresql left behind 206s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 206s ok 8 - PostgreSQL TCP ports are closed 206s === Running test 003_package_checks.t ... === 207s 1..4 207s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 207s ok 2 - psql is linked against libedit 207s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 207s ok 4 - psql is not linked against libreadline 207s === Running test 005_PgCommon.t ... === 207s 1..24 207s ok 1 - correctly parsed line 'local all postgres ident sameuser' 207s ok 2 - correctly parsed line 'local foo nobody trust' 207s ok 3 - correctly parsed line 'local foo nobody crypt' 207s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 207s ok 5 - correctly parsed line 'local foo,bar nobody ident' 207s ok 6 - correctly parsed line 'local all +foogrp password' 207s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 207s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 207s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 207s ok 10 - @expected_records has correct number of entries 207s ok 11 - returned read_pg_hba array has correct number of records 207s ok 12 - line 'foo all all md5' parsed as invalid 207s ok 13 - line 'local all all foo' parsed as invalid 207s ok 14 - line 'host all all foo' parsed as invalid 207s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 207s ok 16 - line 'host all all md5' parsed as invalid 207s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 207s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 207s ok 19 - read_conf_file returns empty dict for nonexisting file 207s ok 20 - read_conf_file() parsing 207s ok 21 - read_conf_file() parsing with include directives 207s ok 22 - set_conf_value 207s ok 23 - disable_conf_value 207s ok 24 - replace_conf_value 207s === Running test 006_next_free_port.t ... === 207s 1..5 207s ok 1 - next_free_port is 5432 208s ok 2 - next_free_port detects localhost ipv4 socket 208s ok 3 - next_free_port detects wildcard ipv4 socket 209s ok 4 - next_free_port detects localhost ipv6 socket 209s ok 5 - next_free_port detects wildcard ipv6 socket 209s === Running test 007_pg_conftool.t ... === 209s 1..41 209s # test without cluster 209s ok 1 - pg_conftool show all 209s ok 2 - correct output of pg_conftool show all 209s ok 3 - pg_conftool foo.conf show all 209s ok 4 - correct output of pg_conftool foo.conf show all 209s ok 5 - pg_conftool /tmp/3XL_mr7NUb/different.conf show all 209s ok 6 - correct output of pg_conftool /tmp/3XL_mr7NUb/different.conf show all 209s ok 7 - pg_conftool 9.7 main show all 209s ok 8 - correct output of pg_conftool 9.7 main show all 209s # test show 209s ok 9 - pg_conftool show all 209s ok 10 - correct output of pg_conftool show all 210s ok 11 - pg_conftool other.conf show all 210s ok 12 - correct output of pg_conftool other.conf show all 210s ok 13 - pg_conftool /tmp/3XL_mr7NUb/different.conf show all 210s ok 14 - correct output of pg_conftool /tmp/3XL_mr7NUb/different.conf show all 210s ok 15 - pg_conftool 12 main show all 210s ok 16 - correct output of pg_conftool 12 main show all 210s ok 17 - pg_conftool 12 main other.conf show all 210s ok 18 - correct output of pg_conftool 12 main other.conf show all 210s ok 19 - pg_conftool show a 210s ok 20 - correct output of pg_conftool show a 210s ok 21 - pg_conftool -s show a 210s ok 22 - correct output of pg_conftool -s show a 210s # test set 210s ok 23 - pg_conftool set c 7 210s ok 24 - correct output of pg_conftool set c 7 210s ok 25 - file contains new setting 210s ok 26 - pg_conftool set a 8 210s ok 27 - correct output of pg_conftool set a 8 210s ok 28 - file contains updated setting 210s ok 29 - pg_conftool /tmp/3XL_mr7NUb/different.conf set a 9 210s ok 30 - correct output of pg_conftool /tmp/3XL_mr7NUb/different.conf set a 9 210s ok 31 - file with path contains updated setting 210s # test remove 210s ok 32 - pg_conftool remove a 210s ok 33 - correct output of pg_conftool remove a 210s ok 34 - setting removed from file 210s ok 35 - pg_conftool /tmp/3XL_mr7NUb/different.conf remove a 210s ok 36 - correct output of pg_conftool /tmp/3XL_mr7NUb/different.conf remove a 210s ok 37 - setting removed from file with path 210s # test edit 210s ok 38 - pg_conftool edit 210s ok 39 - correct output of pg_conftool edit 210s ok 40 - pg_conftool /tmp/3XL_mr7NUb/different.conf edit 210s ok 41 - correct output of pg_conftool /tmp/3XL_mr7NUb/different.conf edit 210s === Running test 010_defaultport_cluster.t ... === 210s 1..14 210s ok 1 - psql --version 210s ok 2 - pg_wrapper selects highest available version number 210s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 210s ok 4 - connecting to localhost fails with no clusters 210s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 210s ok 6 - pg_wrapper uses host and port from PGCLUSTER 210s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 210s ok 8 - pg_wrapper uses --cluster from the command line 210s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 210s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 210s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 210s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 210s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 210s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 210s === Running test 015_start_stop.t ... === 210s 1..71 210s # We are running systemd 210s # Running tests for 12 210s # Cluster does not exist yet 210s ok 1 - cluster 12 main does not exist 210s ok 2 - service postgresql@12-main does not exist 210s ok 3 - systemctl start postgresql 210s ok 4 - cluster 12 main does not exist 210s ok 5 - service postgresql@12-main does not exist 210s ok 6 - systemctl start postgresql@12-main 210s ok 7 - cluster 12 main does not exist 211s ok 8 - service postgresql@12-main does not exist 211s # Start/stop postgresql using system tools 211s ok 9 - pg_createcluster 12 main 211s ok 10 - cluster 12 main is stopped 211s ok 11 - service postgresql@12-main is stopped 214s ok 12 - systemctl start postgresql 214s ok 13 - cluster 12 main is running 214s ok 14 - service postgresql@12-main is running 214s ok 15 - systemctl start postgresql 214s ok 16 - cluster 12 main is already running 214s ok 17 - service postgresql@12-main is already running 214s ok 18 - systemctl stop postgresql 220s ok 19 - cluster 12 main is stopped 220s ok 20 - service postgresql@12-main is stopped 220s ok 21 - systemctl stop postgresql 220s ok 22 - cluster 12 main is already stopped 220s ok 23 - service postgresql@12-main is already stopped 220s # Start/stop specific cluster using system tools 222s ok 24 - systemctl start postgresql@12-main 222s ok 25 - cluster 12 main is running 222s ok 26 - service postgresql@12-main is running 222s ok 27 - systemctl start postgresql@12-main 222s ok 28 - cluster 12 main is running 222s ok 29 - service postgresql@12-main is running 224s ok 30 - systemctl restart postgresql@12-main 224s ok 31 - cluster 12 main is running 224s ok 32 - service postgresql@12-main is running 225s ok 33 - systemctl stop postgresql@12-main 225s ok 34 - cluster 12 main is stopped 225s ok 35 - service postgresql@12-main is stopped 225s ok 36 - systemctl stop postgresql@12-main 225s ok 37 - cluster 12 main is already stopped 225s ok 38 - service postgresql@12-main is already stopped 225s ok 39 - pg_dropcluster 12 main 225s ok 40 - cluster 12 main does not exist 225s ok 41 - service postgresql@12-main does not exist 225s # Start/stop specific cluster using pg_*cluster 225s ok 42 - pg_ctlcluster start 12 main 225s ok 43 - cluster 12 main does not exist 225s ok 44 - service postgresql@12-main does not exist 228s ok 45 - pg_createcluster 12 main --start 228s ok 46 - cluster 12 main is running 228s ok 47 - service postgresql@12-main is running 228s ok 48 - pg_ctlcluster 12 main start 228s ok 49 - cluster 12 main is already running 228s ok 50 - service postgresql@12-main is already running 231s ok 51 - pg_ctlcluster 12-main restart 231s ok 52 - cluster 12 main is running 231s ok 53 - service postgresql@12-main is running 231s ok 54 - pg_ctlcluster 12 main stop 231s ok 55 - cluster 12 main is stopped 231s ok 56 - service postgresql@12-main is stopped 231s ok 57 - pg_ctlcluster 12 main stop 231s ok 58 - cluster 12 main is already stopped 231s ok 59 - service postgresql@12-main is already stopped 233s ok 60 - pg_ctlcluster start 12-main 233s ok 61 - cluster 12 main is running 233s ok 62 - service postgresql@12-main is running 234s ok 63 - pg_dropcluster 12 main --stop 234s ok 64 - Cleanup: No clusters left behind 234s ok 65 - No postgres processes left behind 234s ok 66 - No files in /etc/postgresql left behind 234s ok 67 - No files in /var/lib/postgresql left behind 234s ok 68 - No files in /var/run/postgresql left behind 234s ok 69 - No files in /var/log/postgresql left behind 234s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 234s ok 71 - PostgreSQL TCP ports are closed 234s === Running test 020_create_sql_remove.t ... === 234s 1..144 234s # Running tests for 12 237s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.3UtlD0 237s ok 2 - pg_createcluster 12 main 237s ok 3 - Socket and pid file are in /var/run/postgresql/ 237s ok 4 - xlog/wal directory /tmp/12.xlog.3UtlD0 was created 237s ok 5 - Exactly one postgres master process running 240s ok 6 - pg_ctlcluster 12 main restart 240s ok 7 - cluster restarts with new environment file 240s ok 8 - Exactly one postgres master process running 240s ok 9 - correct value of PGEXTRAVAR1 in environment 240s ok 10 - correct value of PGEXTRAVAR2 in environment 240s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 240s ok 12 - createdb --version 240s ok 13 - pg_wrapper selects version number of cluster 240s ok 14 - psql --version 240s ok 15 - pg_wrapper selects version number of cluster 240s ok 16 - pg_lscluster reports online cluster on port 5432 240s ok 17 - log file is actually used 240s ok 18 - /etc/postgresql is owned by user "postgres" 240s ok 19 - version configuration directory file is owned by user "postgres" 240s ok 20 - configuration directory file is owned by user "postgres" 240s ok 21 - version data directory file is owned by user "postgres" 240s ok 22 - data directory file is owned by user "postgres" 240s ok 23 - log file has 0640 permissions 240s ok 24 - log file is owned by user "postgres" 240s ok 25 - log file is owned by group "adm" 240s ok 26 - no log symlink by default 240s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 240s ok 28 - pg_lsclusters -h 240s ok 29 - correct output of pg_lsclusters -h 240s ok 30 - stopping cluster 242s ok 31 - restarting cluster with nondefault log symlink 242s ok 32 - log target is used as log file 242s ok 33 - default log is not used 242s ok 34 - pg_lsclusters -h 242s ok 35 - correct output of pg_lsclusters -h 242s ok 36 - stopping cluster 245s ok 37 - restarting cluster with explicitly configured log file 245s ok 38 - default log is not used 245s ok 39 - log symlink target is used for startup message 245s ok 40 - exactly one log file 245s ok 41 - custom log is actually used 245s ok 42 - pg_lsclusters -h 245s ok 43 - correct output of pg_lsclusters -h 245s ok 44 - stopping cluster 245s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 245s ok 46 - /etc/postgres-hack was not created 247s ok 47 - restarting cluster 247s ok 48 - ps -o tty -U postgres h 247s ok 49 - postgres processes do not have an associated terminal 247s ok 50 - SSL is enabled 247s ok 51 - psql -l fails for nobody 247s ok 52 - createuser nobody 247s ok 53 - createdb nobodydb 247s ok 54 - psql -ltA succeeds for nobody 247s ok 55 - psql -ltA output 247s ok 56 - SQL command: create table 247s ok 57 - SQL command: insert into table values 247s ok 58 - SQL command: insert into table values 247s ok 59 - primary key violation 248s ok 60 - psql -tAc "select * from phone order by name" nobodydb 248s ok 61 - SQL command output: select -tA 248s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 248s ok 63 - SQL command output: select -tx 248s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 248s ok 65 - SQL command output: select -tAx 248s ok 66 - CREATE EXTENSION plperlu fails for user nobody 248s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 248s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 248s ok 69 - creating PL/PerlU function as user nobody fails 248s ok 70 - creating unsafe PL/Perl function as user postgres fails 248s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 248s ok 72 - creating PL/PerlU function as user postgres succeeds 248s ok 73 - psql nobodydb -Atc "select read_file()" 248s ok 74 - calling PL/PerlU function 248s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 248s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 248s ok 77 - creating unsafe PL/Perl function as user nobody fails 248s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 248s ok 79 - creating PL/Perl function as user nobody succeeds 248s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 248s ok 81 - calling PL/Perl function 248s ok 82 # skip No python2 support 248s ok 83 # skip No python2 support 248s ok 84 # skip No python2 support 248s ok 85 # skip No python2 support 248s ok 86 # skip No python2 support 248s ok 87 # skip No python2 support 248s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 248s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 248s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 248s ok 91 - creating PL/Python3 function as user postgres succeeds 248s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 248s ok 93 - calling PL/Python function 249s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 249s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 249s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 249s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 249s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 249s ok 99 - creating PL/Tcl function as user nobody succeeds 249s 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;" 249s ok 101 - creating PL/TclU function as user postgres succeeds 249s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 249s ok 103 - calling PL/Tcl function 249s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 249s ok 105 - calling PL/TclU function 249s ok 106 - stopping cluster 249s ok 107 - pg_ctlcluster 12 main start 249s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 251s ok 109 - pg_ctlcluster 12 main start 251s ok 110 - cluster restarts with pgdata symlink 252s ok 111 - postgres master has OOM killer protection 252s ok 112 - postgres client backend has no OOM adjustment 252s ok 113 - ps h 7337 252s ok 114 - process title is idle 252s ok 115 - ps h 7337 252s ok 116 - process title is idle in transaction 253s ok 117 - ps h 7337 253s ok 118 - process title is SELECT 255s ok 119 - dropdb nobodydb 255s ok 120 - dropuser nobody 255s ok 121 - stopping cluster 257s ok 122 - starting cluster as postgres works without a log file 257s ok 123 - log file got recreated and used 257s ok 124 - creating a directory in spc2 257s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.Bbn57r'" 257s ok 126 - creating tablespace spc1 257s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 257s ok 128 - creating a table in spc1 257s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.l_JTi7'" 257s ok 130 - creating tablespace spc2 257s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 257s ok 132 - creating a table in spc2 258s ok 133 - pg_dropcluster removes cluster 258s ok 134 - xlog/wal directory /tmp/12.xlog.3UtlD0 was deleted 258s ok 135 - tablespace spc1 was emptied 258s ok 136 - tablespace spc2 was emptied 258s ok 137 - Cleanup: No clusters left behind 258s ok 138 - No postgres processes left behind 258s ok 139 - No files in /etc/postgresql left behind 258s ok 140 - No files in /var/lib/postgresql left behind 258s ok 141 - No files in /var/run/postgresql left behind 258s ok 142 - No files in /var/log/postgresql left behind 258s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 258s ok 144 - PostgreSQL TCP ports are closed 258s === Running test 021_pg_renamecluster.t ... === 258s 1..20 261s ok 1 - pg_createcluster 12 main 264s ok 2 - pg_renamecluster 12 main donau 264s ok 3 - psql -tAc "show data_directory" 264s ok 4 - cluster is running and data_directory was moved 264s ok 5 - pg_hba.conf location updated 264s ok 6 - pg_ident.conf location updated 264s ok 7 - external_pid_file location updated 264s ok 8 - external_pid_file exists 264s ok 9 - stats_temp_directory location updated 264s ok 10 - stats_temp_directory exists 264s ok 11 - cluster_name is updated 264s ok 12 - pg_dropcluster removes cluster 264s ok 13 - Cleanup: No clusters left behind 264s ok 14 - No postgres processes left behind 264s ok 15 - No files in /etc/postgresql left behind 264s ok 16 - No files in /var/lib/postgresql left behind 264s ok 17 - No files in /var/run/postgresql left behind 264s ok 18 - No files in /var/log/postgresql left behind 264s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 264s ok 20 - PostgreSQL TCP ports are closed 264s === Running test 022_recovery.t ... === 264s 1..17 264s # Running tests for 12 268s ok 1 - pg_createcluster 12 main --start >/dev/null 268s ok 2 - pg_ctlcluster 12 main stop -m i 270s ok 3 - pg_ctlcluster 12 main start 270s ok 4 - psql -c '' 270s ok 5 - pg_ctlcluster 12 main stop -m i 270s ok 6 - create write-protected file in data directory 272s ok 7 - pg_ctlcluster 12 main start 273s ok 8 - psql -c '' 273s ok 9 - pg_dropcluster removes cluster 273s ok 10 - Cleanup: No clusters left behind 273s ok 11 - No postgres processes left behind 273s ok 12 - No files in /etc/postgresql left behind 273s ok 13 - No files in /var/lib/postgresql left behind 273s ok 14 - No files in /var/run/postgresql left behind 273s ok 15 - No files in /var/log/postgresql left behind 273s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 273s ok 17 - PostgreSQL TCP ports are closed 273s === Running test 025_logging.t ... === 273s 1..55 274s # Logging to /var/log/syslog works 274s # Running tests for 12 277s ok 1 - pg_createcluster 12 main 277s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 277s ok 3 - psql -qc "'foobar_12_7993'" 277s ok 4 - log an error 277s ok 5 - grep --binary-files=text foobar_12_7993 /var/log/postgresql/postgresql-12-main.log 277s ok 6 - error appears in logfile 277s ok 7 - pg_conftool 12 main set log_destination syslog 277s ok 8 - set log_destination syslog 277s ok 9 - pg_ctlcluster 12 main reload 277s ok 10 - 12 main reload 277s ok 11 - psql -Atc "show log_destination" 277s ok 12 - log_destination is syslog 277s ok 13 - pg_lscluster reports syslog 278s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 278s ok 15 - error appears in /var/log/syslog 278s ok 16 - pg_conftool 12 main set logging_collector on 278s ok 17 - set logging_collector on 278s ok 18 - pg_conftool 12 main set log_destination csvlog 278s ok 19 - set log_destination csvlog 280s ok 20 - pg_ctlcluster 12 main restart 280s ok 21 - 12 main restart 280s ok 22 - psql -Atc "show logging_collector" 280s ok 23 - logging_collector is on 280s ok 24 - psql -Atc "show log_destination" 280s ok 25 - log_destination is csvlog 280s ok 26 - pg_lscluster reports csvlog 280s ok 27 - psql -qc "'barbaz_12_7993'" 280s ok 28 - log an error 280s ok 29 - grep --binary-files=text barbaz_12_7993 /var/lib/postgresql/12/main/log/*.csv 280s ok 30 - error appears in log/*.csv 280s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 280s ok 32 - set log_destination stderr,syslog,csvlog 281s ok 33 - pg_ctlcluster 12 main reload 281s ok 34 - 12 main reload 281s ok 35 - psql -Atc "show log_destination" 281s ok 36 - log_destination is stderr,syslog,csvlog 281s ok 37 - pg_lscluster reports stderr,syslog,csvlog 281s ok 38 - psql -qc "'moo_12_7993'" 281s ok 39 - log an error 281s ok 40 - grep --binary-files=text moo_12_7993 /var/lib/postgresql/12/main/log/*.log 281s ok 41 - error appears in log/*.log 281s ok 42 - grep --binary-files=text 'postgres.*moo_12_7993' /var/log/syslog 281s ok 43 - error appears in /var/log/syslog 281s ok 44 - grep --binary-files=text moo_12_7993 /var/lib/postgresql/12/main/log/*.csv 281s ok 45 - error appears in log/*.csv 282s ok 46 - pg_dropcluster 12 main --stop 282s ok 47 - pg_dropcluster removes cluster 282s ok 48 - Cleanup: No clusters left behind 282s ok 49 - No postgres processes left behind 282s ok 50 - No files in /etc/postgresql left behind 282s ok 51 - No files in /var/lib/postgresql left behind 282s ok 52 - No files in /var/run/postgresql left behind 282s ok 53 - No files in /var/log/postgresql left behind 282s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 282s ok 55 - PostgreSQL TCP ports are closed 282s === Running test 030_errors.t ... === 282s 1..149 282s ok 1 - pg_lscluster reports cluster without binaries 282s ok 2 - pg_dropcluster 6.3 main 283s ok 3 - pg_createcluster --socketdir 283s ok 4 - pg_lsclusters -h 283s ok 5 - cluster was created 283s ok 6 - Port of created cluster is 5432 283s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 283s ok 8 - pg_createcluster on existing cluster 283s ok 9 - pg_lsclusters -h 283s ok 10 - original cluster still exists 283s ok 11 - pg_createcluster 12 test -p foo 283s ok 12 - pg_createcluster -p checks that port option is numeric 283s ok 13 - pg_createcluster 12 test -p 42 283s ok 14 - pg_createcluster -p checks valid port range 283s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 283s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 283s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 285s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 285s ok 19 - No sockets in /var/run/postgresql 285s ok 20 - Socket is in /tmp/postgresql-testsuite/ 286s ok 21 - cluster stops with custom unix_socket_dir 286s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 288s ok 23 - cluster starts after removing unix_socket_dir 288s ok 24 - Socket is in default dir /var/run/postgresql 288s ok 25 - No sockets in /tmp/postgresql-testsuite/ 288s ok 26 - pg_ctlcluster 12 main stop 288s ok 27 - pg_ctlcluster fails with corrupted PID file 288s ok 28 - pg_lsclusters -h 288s ok 29 - cluster is still online 288s ok 30 - pg_ctlcluster succeeds with restored PID file 288s ok 31 - pg_lsclusters -h 288s ok 32 - cluster is down 288s ok 33 - pg_ctlcluster 12 main stop 288s ok 34 - pg_ctlcluster stop fails on stopped cluster 290s ok 35 - pg_ctlcluster 12 main start 290s ok 36 - pg_ctlcluster succeeds with already existing PID file 290s ok 37 - pg_lsclusters -h 290s ok 38 - cluster is online 291s ok 39 - pg_ctlcluster stop succeeds 291s ok 40 - pg_lsclusters -h 291s ok 41 - cluster is down 291s ok 42 - no pid file left 291s ok 43 - pg_ctlcluster 12 main stop 291s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 291s ok 45 - pid file was cleaned up 291s ok 46 - pg_ctlcluster --force 12 main stop 291s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 291s ok 48 - pid file was cleaned up 291s ok 49 - pg_ctlcluster 12 main stop 291s ok 50 - pg_ctlcluster stop succeeds with stale PID file 291s ok 51 - pid file was cleaned up 291s ok 52 - pg_ctlcluster --force 12 main stop 291s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 291s ok 54 - pid file was cleaned up 291s ok 55 - pg_ctlcluster --force 12 main stop 291s ok 56 - pg_ctlcluster stop succeeds with empty PID file 291s ok 57 - pid file was cleaned up 293s ok 58 - pg_ctlcluster 12 main start 293s ok 59 - pg_ctlcluster succeeds with corrupted PID file 293s ok 60 - pg_lsclusters -h 293s ok 61 - cluster is online 293s ok 62 - pg_ctlcluster 12 main start 293s ok 63 - pg_ctlcluster start fails on running cluster 293s ok 64 - pg_ctlcluster stop 293s ok 65 - pg_ctlcluster 12 main start 293s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 293s ok 67 - pg_ctlcluster 12 main stop 293s ok 68 - stopping cluster 300s ok 69 - pg_ctlcluster 12 main start 300s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 300s ok 71 - pg_ctlcluster 12 main stop 300s ok 72 - stopping cluster 300s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 300s ok 74 - pg_dropcluster 12 main 300s ok 75 - pg_dropcluster works as user postgres 301s ok 76 - pg_createcluster succeeds 301s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 301s ok 78 - proper error message for nonexisting /var/lib/postgresql 303s ok 79 - pg_ctlcluster 12 main start 303s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 303s ok 81 - pg_ctlcluster 12 main stop 303s ok 82 - stopping cluster 304s ok 83 - pg_createcluster other 306s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 308s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 309s ok 86 309s ok 87 - pg_ctlcluster 12 other start 309s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 309s ok 89 - pg_ctlcluster 12 main stop 309s ok 90 - stopping main cluster 311s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 311s ok 92 - pg_dropcluster other 312s ok 93 - pg_dropcluster 312s ok 94 - No sockets any more 312s ok 95 - 'pg_lsclusters 4.5 foo' fails 312s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 312s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 312s ok 98 - 'psql --cluster 4.5/foo' fails 312s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 312s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 312s ok 101 - 'psql --cluster 12/foo' fails 312s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 312s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 312s ok 104 - 'pg_dropcluster 4.5 foo' fails 312s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 312s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 312s ok 107 - 'pg_dropcluster 12 foo' fails 312s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 312s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 312s ok 110 - 'pg_upgradecluster 4.5 foo' fails 312s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 312s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 312s ok 113 - 'pg_upgradecluster 12 foo' fails 312s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 312s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 312s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 312s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 312s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 312s ok 119 - 'pg_ctlcluster 12 foo stop' fails 312s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 312s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 312s ok 122 - Cleanup: No clusters left behind 312s ok 123 - No postgres processes left behind 312s ok 124 - No files in /etc/postgresql left behind 312s ok 125 - No files in /var/lib/postgresql left behind 312s ok 126 - No files in /var/run/postgresql left behind 312s ok 127 - No files in /var/log/postgresql left behind 312s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 312s ok 129 - PostgreSQL TCP ports are closed 312s ok 130 - pg_dropcluster 12 broken 312s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 312s ok 132 - Cleanup: No clusters left behind 312s ok 133 - No postgres processes left behind 312s ok 134 - No files in /etc/postgresql left behind 312s ok 135 - No files in /var/lib/postgresql left behind 312s ok 136 - No files in /var/run/postgresql left behind 312s ok 137 - No files in /var/log/postgresql left behind 312s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 312s ok 139 - PostgreSQL TCP ports are closed 312s ok 140 - pg_dropcluster 12 broken 312s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 312s ok 142 - Cleanup: No clusters left behind 312s ok 143 - No postgres processes left behind 312s ok 144 - No files in /etc/postgresql left behind 312s ok 145 - No files in /var/lib/postgresql left behind 312s ok 146 - No files in /var/run/postgresql left behind 312s ok 147 - No files in /var/log/postgresql left behind 312s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 312s ok 149 - PostgreSQL TCP ports are closed 312s === Running test 031_errors_disk_full.t ... === 312s 1..22 312s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 313s ok 1 - script failed 313s ok 2 - pg_createcluster fails due to insufficient disk space 313s ok 3 - does not leave files behind 313s ok 4 - Cleanup: No clusters left behind 313s ok 5 - No postgres processes left behind 313s ok 6 - No files in /etc/postgresql left behind 313s ok 7 - No files in /var/lib/postgresql left behind 313s ok 8 - No files in /var/run/postgresql left behind 313s ok 9 - No files in /var/log/postgresql left behind 313s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 313s ok 11 - PostgreSQL TCP ports are closed 313s # check disk full conditions on startup 314s ok 12 - script failed 314s ok 13 - pg_ctlcluster prints error message 314s ok 14 - log file has error message 314s ok 15 - Cleanup: No clusters left behind 314s ok 16 - No postgres processes left behind 314s ok 17 - No files in /etc/postgresql left behind 314s ok 18 - No files in /var/lib/postgresql left behind 314s ok 19 - No files in /var/run/postgresql left behind 314s ok 20 - No files in /var/log/postgresql left behind 314s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 314s ok 22 - PostgreSQL TCP ports are closed 314s === Running test 032_ssl_key_permissions.t ... === 314s 1..22 314s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 314s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 314s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 314s # 12 (12.22-0ubuntu0.20.04.3) 315s ok 4 - pg_createcluster 12 main 315s ok 5 - pg_ctlcluster 12 main start 315s ok 6 - ssl key owned by nobody refused 315s ok 7 - pg_ctlcluster 12 main start 315s ok 8 - ssl key with permissions root:root 0644 refused 315s ok 9 - pg_ctlcluster 12 main start 315s ok 10 - ssl key with permissions postgres:postgres 0640 refused 316s ok 11 - pg_dropcluster 12 main --stop 316s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 316s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 316s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 316s ok 15 - Cleanup: No clusters left behind 316s ok 16 - No postgres processes left behind 316s ok 17 - No files in /etc/postgresql left behind 316s ok 18 - No files in /var/lib/postgresql left behind 316s ok 19 - No files in /var/run/postgresql left behind 316s ok 20 - No files in /var/log/postgresql left behind 316s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 316s ok 22 - PostgreSQL TCP ports are closed 316s === Running test 040_upgrade.t ... === 316s 1..1 316s ok 1 - only one major version installed, skipping upgrade tests 316s === Running test 041_upgrade_custompaths.t ... === 316s 1..1 316s ok 1 - only one major version installed, skipping upgrade tests 316s === Running test 043_upgrade_ssl_cert.t ... === 316s 1..1 316s ok 1 - only one major version installed, skipping upgrade tests 316s === Running test 050_encodings.t ... === 316s 1..60 316s # Checking 12 ru_RU 319s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 320s ok 2 - psql -l succeeds 320s ok 3 - template1 is not UTF-8 encoded 320s ok 4 - creating test database 320s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 320s # create table t (x varchar); copy t from stdin" test 320s ok 6 - creating table with ISO-8859-5 characters 320s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 320s ok 8 - correct string in UTF-8 320s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 320s ok 10 - correct string in ISO-8859-5 320s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 320s # delete from t; copy t from stdin" test 320s ok 12 - creating table with UTF-8 characters 320s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 320s ok 14 - correct string in UTF-8 320s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 320s ok 16 - correct string in ISO-8859-1 320s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 320s ok 18 - Server error message has correct language and encoding 323s ok 19 - pg_ctlcluster 12 ru_RU restart 323s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 323s ok 21 - Dropping cluster 323s # Checking 12 ru_RU.UTF-8 327s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 328s ok 23 - psql -l succeeds 328s ok 24 - template1 is UTF-8 encoded 328s ok 25 - creating test database 328s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 328s # create table t (x varchar); copy t from stdin" test 328s ok 27 - creating table with ISO-8859-5 characters 328s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 328s ok 29 - correct string in UTF-8 328s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 328s ok 31 - correct string in ISO-8859-5 328s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 328s # delete from t; copy t from stdin" test 328s ok 33 - creating table with UTF-8 characters 328s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 328s ok 35 - correct string in UTF-8 328s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 328s ok 37 - correct string in ISO-8859-1 328s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 328s ok 39 - Server error message has correct language and encoding 330s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 330s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 331s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 331s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 331s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 331s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 331s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 331s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 331s ok 48 - Dropping cluster 331s # Check 12 locale environment variables 334s ok 49 - pg_createcluster: LC_ALL dominates LANG 334s ok 50 - psql -Atl --cluster 12/main 334s ok 51 - template1 is ASCII encoded 335s ok 52 - Dropping cluster 335s ok 53 - Cleanup: No clusters left behind 335s ok 54 - No postgres processes left behind 335s ok 55 - No files in /etc/postgresql left behind 335s ok 56 - No files in /var/lib/postgresql left behind 335s ok 57 - No files in /var/run/postgresql left behind 335s ok 58 - No files in /var/log/postgresql left behind 335s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 335s ok 60 - PostgreSQL TCP ports are closed 335s === Running test 052_upgrade_encodings.t ... === 335s 1..1 335s ok 1 - only one major version installed, skipping upgrade tests 335s === Running test 060_obsolete_confparams.t ... === 335s 1..1 335s ok 1 - only one major version installed, skipping upgrade tests 335s === Running test 070_non_postgres_clusters.t ... === 335s 1..40 336s ok 1 - pg_createcluster 12 main for owner nobody 336s ok 2 - pg_ctlcluster 12 main start 336s ok 3 - start refused when config and data owners mismatch 338s ok 4 - pg_ctlcluster succeeds with owner nobody 338s ok 5 - pg_lsclusters -h 338s ok 6 - pg_lsclusters shows running cluster 338s ok 7 - postgres is running as user nobody 338s ok 8 - ls /tmp/.s.PGSQL.* 338s ok 9 - socket is in /tmp 338s ok 10 - /var/run/postgresql is empty 338s ok 11 - conf dir is owned by user 338s ok 12 - conf dir is owned by user's primary group 338s ok 13 - files are owned by user 338s ok 14 - files are owned by user's primary group 338s ok 15 - log file has 0640 permissions 338s ok 16 - log file is owned by user 338s ok 17 - log file is owned by user's primary group 338s ok 18 - only one major version installed, skipping upgrade test 338s ok 19 - ... 338s ok 20 - ... 338s ok 21 - ... 338s ok 22 - ... 338s ok 23 - ... 338s ok 24 - ... 338s ok 25 - ... 338s ok 26 - ... 338s ok 27 - ... 338s ok 28 - ... 338s ok 29 - pg_dropcluster 338s ok 30 - pg_lsclusters -h 338s ok 31 - No clusters left 338s ok 32 - No postgres processes left 338s ok 33 - Cleanup: No clusters left behind 338s ok 34 - No postgres processes left behind 338s ok 35 - No files in /etc/postgresql left behind 338s ok 36 - No files in /var/lib/postgresql left behind 338s ok 37 - No files in /var/run/postgresql left behind 338s ok 38 - No files in /var/log/postgresql left behind 338s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 338s ok 40 - PostgreSQL TCP ports are closed 338s === Running test 080_start.conf.t ... === 339s 1..73 340s ok 1 - pg_createcluster 12 main 340s # start.conf auto 340s ok 2 - get_cluster_start_conf returns auto 340s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 340s ok 4 - start.conf contains auto 340s ok 5 - systemd generator links cluster 340s ok 6 - systemd generator links correct service file 342s ok 7 - /etc/init.d/postgresql start 12 342s ok 8 - correct output of /etc/init.d/postgresql start 12 342s ok 9 - pg_lsclusters -h 342s ok 10 - cluster is online 342s ok 11 - /etc/init.d/postgresql stop 12 342s ok 12 - correct output of /etc/init.d/postgresql stop 12 345s ok 13 - pg_lsclusters -h 345s ok 14 - cluster is down 345s # start.conf manual 345s ok 15 - get_cluster_start_conf returns manual 345s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 345s ok 17 - start.conf contains manual 345s ok 18 - systemd generator doesn't link cluster 345s ok 19 - /etc/init.d/postgresql start 12 345s ok 20 - correct output of /etc/init.d/postgresql start 12 345s ok 21 - pg_lsclusters -h 345s ok 22 - cluster is down 347s ok 23 - pg_ctlcluster 12 main start 347s ok 24 - correct output of pg_ctlcluster 12 main start 347s ok 25 - pg_lsclusters -h 347s ok 26 - cluster is online 348s ok 27 - pg_ctlcluster 12 main stop 348s ok 28 - correct output of pg_ctlcluster 12 main stop 348s ok 29 - pg_lsclusters -h 348s ok 30 - cluster is down 348s # start.conf disabled 348s ok 31 - get_cluster_start_conf returns disabled 348s ok 32 - systemd generator doesn't link cluster 348s ok 33 - /etc/init.d/postgresql start 12 348s ok 34 - correct output of /etc/init.d/postgresql start 12 348s ok 35 - pg_lsclusters -h 348s ok 36 - cluster is down 348s ok 37 - pg_ctlcluster 12 main start 348s ok 38 - correct output of pg_ctlcluster 12 main start 348s ok 39 - pg_lsclusters -h 348s ok 40 - cluster is down 350s ok 41 - pg_ctlcluster 12 main start 350s ok 42 - correct output of pg_ctlcluster 12 main start 350s ok 43 - pg_lsclusters -h 350s ok 44 - cluster is online 350s ok 45 - pg_ctlcluster 12 main stop 350s ok 46 - correct output of pg_ctlcluster 12 main stop 350s ok 47 - pg_lsclusters -h 350s ok 48 - cluster is down 353s ok 49 - pg_ctlcluster 12 main start 353s ok 50 - correct output of pg_ctlcluster 12 main start 353s ok 51 - pg_lsclusters -h 353s ok 52 - cluster is online 353s # test upgrade 353s ok 53 - only one major version installed, skipping upgrade test 353s ok 54 - ... 353s ok 55 - get_cluster_start_conf for old cluster returns manual 353s ok 56 - get_cluster_start_conf for new cluster returns manual 353s ok 57 - ... 353s ok 58 - dropping upgraded cluster 353s ok 59 - pg_lsclusters -h 353s ok 60 - no clusters any more 353s ok 61 - pg_createcluster 12 main --start-conf foo 353s ok 62 - pg_createcluster checks --start-conf validity 353s ok 63 - pg_createcluster checks --start-conf manual 353s ok 64 - get_cluster_start_conf returns manual 353s ok 65 - dropping cluster 353s ok 66 - Cleanup: No clusters left behind 353s ok 67 - No postgres processes left behind 353s ok 68 - No files in /etc/postgresql left behind 353s ok 69 - No files in /var/lib/postgresql left behind 353s ok 70 - No files in /var/run/postgresql left behind 353s ok 71 - No files in /var/log/postgresql left behind 353s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 353s ok 73 - PostgreSQL TCP ports are closed 353s === Running test 085_pg_ctl.conf.t ... === 354s 1..29 354s ok 1 - pg_createcluster 12 main 354s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 357s ok 3 - pg_ctlcluster 12 main start 357s ok 4 - starting cluster 357s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 357s ok 6 - soft core size is 0 357s ok 7 - set pg_ctl default option to -c 359s ok 8 - pg_ctlcluster 12 main restart 359s ok 9 - restarting cluster 359s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 359s ok 11 - soft core size is unlimited 359s ok 12 - restored pg_ctl default option 361s ok 13 - pg_ctlcluster 12 main restart 361s ok 14 - restarting cluster 361s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 361s ok 16 - soft core size is 0 364s ok 17 - pg_ctlcluster 12 main restart -- -c 364s ok 18 - restarting cluster with -c on the command line 364s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 364s ok 20 - soft core size is unlimited 364s ok 21 - dropping cluster 364s ok 22 - Cleanup: No clusters left behind 364s ok 23 - No postgres processes left behind 364s ok 24 - No files in /etc/postgresql left behind 364s ok 25 - No files in /var/lib/postgresql left behind 364s ok 26 - No files in /var/run/postgresql left behind 364s ok 27 - No files in /var/log/postgresql left behind 364s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 364s ok 29 - PostgreSQL TCP ports are closed 364s === Running test 090_multicluster.t ... === 364s 1..125 365s ok 1 - pg_createcluster 12 old 366s ok 2 - pg_createcluster 12 new1 367s ok 3 - pg_createcluster 12 new2 369s ok 4 - starting cluster 12/old 371s ok 5 - starting cluster 12/new1 374s ok 6 - starting cluster 12/new2 374s ok 7 - pg_lsclusters -h | sort -k3 374s ok 8 - clusters have the correct ports, skipping used 5433 374s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 374s ok 10 - createdb --version 374s ok 11 - pg_wrapper selects port 5432 as default cluster 374s ok 12 - createdb --cluster 12/new1 --version 374s ok 13 - pg_wrapper --cluster works 374s ok 14 - createdb --cluster 12/foo --version 374s ok 15 - pg_wrapper --cluster errors out for invalid cluster 374s ok 16 - createdb --cluster 12/new1 test 374s ok 17 - correct output of createdb --cluster 12/new1 test 374s ok 18 - psql -Atl --cluster 12/new1 374s ok 19 - test db appears in cluster new1 374s ok 20 - psql -Atl --cluster 12/new2 374s ok 21 - test db does not appear in cluster new2 374s ok 22 - psql -Atl 374s ok 23 - test db does not appear in default cluster 374s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 374s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 374s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 374s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 374s ok 28 - psql -Atl --cluster 12/localhost:5434 374s ok 29 - test db appears in cluster 12/localhost:5434 374s ok 30 - psql -Atl --cluster 12/localhost:5440 374s ok 31 - test db does not appear in cluster 12/localhost:5440 374s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 374s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 374s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 374s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 374s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 374s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 374s ok 38 - psql -Atl --cluster 6.4/localhost: 374s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 374s ok 40 - psql -Atl 374s ok 41 - PGCLUSTER selection (1) 374s ok 42 - psql -Atl 374s ok 43 - PGCLUSTER selection (2) 375s ok 44 - psql -l 375s ok 45 - invalid PGCLUSTER value 375s ok 46 - createdb --version 375s ok 47 - PGCLUSTER network cluster selection (1) 375s ok 48 - psql -Atl 375s ok 49 - PGCLUSTER network cluster selection (2) 375s ok 50 - psql -Atl 375s ok 51 - PGCLUSTER network cluster selection (3) 375s ok 52 - LC_MESSAGES=C psql -Atl 375s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 375s ok 54 - psql -Atc "show port" template1 375s ok 55 - PGPORT selection (1) 375s ok 56 - psql -Atc "show port" template1 375s ok 57 - PGPORT selection (2) 375s ok 58 - createdb --version 375s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 375s ok 60 - psql -Atc "show port" template1 375s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 375s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 375s ok 63 - PGDATABASE environment variable works 375s ok 64 - createdb --version 375s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 375s ok 66 - createdb --cluster 12/new1 --version 375s ok 67 - pg_wrapper --cluster works with empty user_clusters 375s ok 68 - createdb --version 375s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 375s ok 70 - psql -Atc "select current_database()" 375s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 375s ok 72 - psql -Atc 'select current_database()' 375s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 375s ok 74 - createdb --version 375s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 375s ok 76 - createdb --version 375s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 375s ok 78 - createdb --version 375s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 375s ok 80 - createdb --version 375s ok 81 - pg_wrapper selects correct version with per-user user_clusters 375s ok 82 - createdb --version 375s ok 83 - pg_wrapper selects correct version with per-user user_clusters 375s ok 84 - createdb --version 375s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 375s ok 86 - psql -Atl 375s ok 87 - $PGHOST overrides user_clusters 375s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 375s ok 89 - --cluster overrides $PGHOST 375s ok 90 - createdb --version 375s ok 91 - pg_wrapper ignores invalid lines in user_clusters 376s ok 92 - psql -Atc 'select current_database()' 376s ok 93 - pg_service conf selection 1 376s ok 94 - psql -Atc 'select current_database()' 376s ok 95 - pg_service conf selection 2 376s ok 96 - psql -Atc 'select current_database()' 376s ok 97 - pg_service conf selection 3 376s ok 98 - stopping cluster 12/old 378s ok 99 - restarting cluster 12/old 378s ok 100 - pg_lsclusters -h | sort -k3 378s ok 101 - port of first cluster was successfully changed 378s ok 102 - psql -l 378s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 378s ok 104 - psql -Atl --cluster 12/new1 378s ok 105 - --cluster selects appropriate cluster 378s ok 106 - psql -Atl -p 5434 378s ok 107 - -p selects appropriate cluster 378s ok 108 - psql -Atlp 5434 378s ok 109 - -Atlp selects appropriate cluster 378s ok 110 - psql -Atl --port 5434 378s ok 111 - --port selects appropriate cluster 378s ok 112 - env PGPORT=5434 psql -Atl 378s ok 113 - $PGPORT selects appropriate cluster 378s ok 114 - Restoring original /etc/postgresql-common/user_clusters 379s ok 115 - dropping 12/new1 379s ok 116 - dropping 12/new2 380s ok 117 - dropping 12/old 380s ok 118 - Cleanup: No clusters left behind 380s ok 119 - No postgres processes left behind 380s ok 120 - No files in /etc/postgresql left behind 380s ok 121 - No files in /var/lib/postgresql left behind 380s ok 122 - No files in /var/run/postgresql left behind 380s ok 123 - No files in /var/log/postgresql left behind 380s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 380s ok 125 - PostgreSQL TCP ports are closed 380s === Running test 100_upgrade_scripts.t ... === 380s 1..27 383s ok 1 - pg_createcluster 12 main 383s ok 2 - createdb --cluster 12/main db1 383s ok 3 - correct output of createdb --cluster 12/main db1 383s ok 4 - createdb --cluster 12/main db2 383s ok 5 - correct output of createdb --cluster 12/main db2 383s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 383s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 383s ok 8 - get_cluster_databases() works 383s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 385s ok 10 - run-upgrade-scripts succeeds 385s ok 11 - correct run-upgrade-script output 385s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 385s ok 13 - check SQL scripts results in 12/main db1 385s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 385s ok 15 - check SQL scripts results in 12/main db2 386s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 386s ok 17 - check shell scripts results in $v/main 386s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 386s ok 19 - pg_dropcluster 12 main 386s ok 20 - Cleanup: No clusters left behind 386s ok 21 - No postgres processes left behind 386s ok 22 - No files in /etc/postgresql left behind 386s ok 23 - No files in /var/lib/postgresql left behind 386s ok 24 - No files in /var/run/postgresql left behind 386s ok 25 - No files in /var/log/postgresql left behind 386s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 386s ok 27 - PostgreSQL TCP ports are closed 386s === Running test 110_integrate_cluster.t ... === 386s 1..32 387s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/q6omwVqenf/c/postgres 387s ok 2 - creating raw initdb cluster for user postgres 387s ok 3 - pg_createcluster 12 postgres -d /tmp/q6omwVqenf/c/postgres 387s ok 4 - integrating postgres cluster 387s ok 5 - pg_lsclusters 387s ok 6 - correct pg_lsclusters output 390s ok 7 - pg_ctlcluster 12 postgres start 390s ok 8 - starting cluster postgres 390s ok 9 - pg_lsclusters 390s ok 10 - correct pg_lsclusters output 390s ok 11 - dropping cluster postgres 390s ok 12 - No files in temporary cluster dir left behind 391s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/q6omwVqenf/c/nobody 391s ok 14 - creating raw initdb cluster for user nobody 391s ok 15 - pg_createcluster 12 nobody -d /tmp/q6omwVqenf/c/nobody 391s ok 16 - integrating nobody cluster 391s ok 17 - pg_lsclusters 391s ok 18 - correct pg_lsclusters output 393s ok 19 - pg_ctlcluster 12 nobody start 393s ok 20 - starting cluster nobody 393s ok 21 - pg_lsclusters 393s ok 22 - correct pg_lsclusters output 394s ok 23 - dropping cluster nobody 394s ok 24 - No files in temporary cluster dir left behind 394s ok 25 - Cleanup: No clusters left behind 394s ok 26 - No postgres processes left behind 394s ok 27 - No files in /etc/postgresql left behind 394s ok 28 - No files in /var/lib/postgresql left behind 394s ok 29 - No files in /var/run/postgresql left behind 394s ok 30 - No files in /var/log/postgresql left behind 394s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 394s ok 32 - PostgreSQL TCP ports are closed 394s === Running test 120_pg_upgradecluster_scripts.t ... === 394s 1..1 394s ok 1 - only one major version installed, skipping upgrade tests 394s === Running test 130_nonroot_admin.t ... === 394s 1..22 397s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 397s ok 2 - pg_lsclusters -h 397s ok 3 - correct output of pg_lsclusters -h 397s ok 4 - psql -Atl 397s ok 5 - correct output of psql -Atl 397s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 397s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 397s ok 15 - Cleanup: No clusters left behind 397s ok 16 - No postgres processes left behind 397s ok 17 - No files in /etc/postgresql left behind 397s ok 18 - No files in /var/lib/postgresql left behind 397s ok 19 - No files in /var/run/postgresql left behind 397s ok 20 - No files in /var/log/postgresql left behind 397s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 397s ok 22 - PostgreSQL TCP ports are closed 397s === Running test 135_pg_virtualenv.t ... === 397s 1..20 401s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 401s ok 2 - running pg_virtualenv as root 404s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 404s ok 4 - running pg_virtualenv as postgres 407s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 407s ok 6 - running pg_virtualenv as nobody 410s ok 7 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 410s ok 8 - running fakeroot pg_virtualenv as root 413s ok 9 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 413s ok 10 - running fakeroot pg_virtualenv as postgres 417s ok 11 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 417s ok 12 - running fakeroot pg_virtualenv as nobody 417s ok 13 - Cleanup: No clusters left behind 417s ok 14 - No postgres processes left behind 417s ok 15 - No files in /etc/postgresql left behind 417s ok 16 - No files in /var/lib/postgresql left behind 417s ok 17 - No files in /var/run/postgresql left behind 417s ok 18 - No files in /var/log/postgresql left behind 417s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 417s ok 20 - PostgreSQL TCP ports are closed 417s === Running test 140_pg_config.t ... === 417s 1..38 417s # Multiarch is enabled 417s # checking version specific output for 12 417s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 417s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 417s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 417s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 417s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 417s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 417s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 417s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 417s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 417s # checking pg_config output (should behave like version 12) 417s ok 15 - pg_config 417s ok 16 - correct output of pg_config 417s ok 17 - pg_config --help 417s ok 18 - correct output of pg_config --help 417s ok 19 - pg_config --pgxs 417s ok 20 - correct output of pg_config --pgxs 417s ok 21 - pg_config --libdir 417s ok 22 - correct output of pg_config --libdir 417s ok 23 - pg_config --pkglibdir 417s ok 24 - correct output of pg_config --pkglibdir 417s ok 25 - pg_config --bindir 417s ok 26 - correct output of pg_config --bindir 417s # checking pg_config.libpq-dev output (should behave like version 12) 417s ok 27 - pg_config.libpq-dev 417s ok 28 - correct output of pg_config.libpq-dev 417s ok 29 - pg_config.libpq-dev --help 417s ok 30 - correct output of pg_config.libpq-dev --help 417s ok 31 - pg_config.libpq-dev --pgxs 417s ok 32 - correct output of pg_config.libpq-dev --pgxs 417s ok 33 - pg_config.libpq-dev --libdir 417s ok 34 - correct output of pg_config.libpq-dev --libdir 417s ok 35 - pg_config.libpq-dev --pkglibdir 417s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 417s ok 37 - pg_config.libpq-dev --bindir 417s ok 38 - correct output of pg_config.libpq-dev --bindir 417s === Running test 150_tsearch_stemming.t ... === 417s 1..37 417s ok 1 - pg_updatedicts succeeded 417s ok 2 - pg_updatedicts created en_us.affix 417s ok 3 - pg_updatedicts created en_us.dict 417s ok 4 - pg_updatedicts created 12 en_us.affix symlink 417s ok 5 - pg_updatedicts created 12 en_us.dict symlink 420s ok 6 - pg_createcluster 12 main 420s ok 7 - createdb fts 420s ok 8 - correct output of createdb fts 420s ok 9 - creating en_US full text search configuration 420s ok 10 - creating data table and search index 420s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 420s ok 12 - stem search of correct word 420s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 420s ok 14 - stem search of correct word 421s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 421s ok 16 - stem search of unknown word 421s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 421s ok 18 - full text search, exact word 421s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 421s ok 20 - full text search for word stem 421s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 421s ok 22 - full text search for word substring fails 421s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 421s ok 24 - full text search, exact unicode word 421s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 421s ok 26 - full text search for unicode word stem 421s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 421s ok 28 - full text search for unicode word substring fails 421s ok 29 421s ok 30 - Cleanup: No clusters left behind 421s ok 31 - No postgres processes left behind 421s ok 32 - No files in /etc/postgresql left behind 421s ok 33 - No files in /var/lib/postgresql left behind 421s ok 34 - No files in /var/run/postgresql left behind 421s ok 35 - No files in /var/log/postgresql left behind 421s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 421s ok 37 - PostgreSQL TCP ports are closed 421s === Running test 160_alternate_confroot.t ... === 421s 1..28 425s ok 1 425s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 425s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 425s ok 4 - pg_lsclusters -h 425s ok 5 - correct output of pg_lsclusters -h 425s ok 6 - psql -Atl 425s ok 7 - correct output of psql -Atl 425s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 425s ok 9 - ... 425s ok 10 - ... 425s ok 11 - ... 425s ok 12 - ... 425s ok 13 - ... 425s ok 14 - ... 425s ok 15 - pg_dropcluster 12 test --stop 425s ok 16 - correct output of pg_dropcluster 12 test --stop 425s ok 17 - pg_lsclusters -h 425s ok 18 - correct output of pg_lsclusters -h 425s ok 19 - No files in root/data left behind 425s ok 20 - No cruft in root dir left behind 425s ok 21 - Cleanup: No clusters left behind 425s ok 22 - No postgres processes left behind 425s ok 23 - No files in /etc/postgresql left behind 425s ok 24 - No files in /var/lib/postgresql left behind 425s ok 25 - No files in /var/run/postgresql left behind 425s ok 26 - No files in /var/log/postgresql left behind 425s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 425s ok 28 - PostgreSQL TCP ports are closed 425s === Running test 170_extensions.t ... === 425s # Running tests for 12 428s ok 1 - pg_createcluster 12 main 428s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 428s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 428s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 428s ok 5 - extension adminpack installs without error 428s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 428s ok 7 - extension adminpack removes without error 428s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 428s ok 9 - extension amcheck installs without error 428s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 428s ok 11 - extension amcheck removes without error 428s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 428s ok 13 - extension autoinc installs without error 428s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 428s ok 15 - extension autoinc removes without error 428s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 428s ok 17 - extension bloom installs without error 428s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 428s ok 19 - extension bloom removes without error 429s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 429s ok 21 - extension btree_gin installs without error 429s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 429s ok 23 - extension btree_gin removes without error 429s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 429s ok 25 - extension btree_gist installs without error 429s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 429s ok 27 - extension btree_gist removes without error 429s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 429s ok 29 - extension citext installs without error 429s ok 30 - psql -qc 'DROP EXTENSION "citext"' 429s ok 31 - extension citext removes without error 429s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 429s ok 33 - extension cube installs without error 429s ok 34 - psql -qc 'DROP EXTENSION "cube"' 429s ok 35 - extension cube removes without error 429s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 429s ok 37 - extension dblink installs without error 429s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 429s ok 39 - extension dblink removes without error 429s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 429s ok 41 - extension dict_int installs without error 429s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 429s ok 43 - extension dict_int removes without error 429s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 429s ok 45 - extension dict_xsyn installs without error 429s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 429s ok 47 - extension dict_xsyn removes without error 430s ok 48 - psql -qc 'CREATE EXTENSION cube' 430s ok 49 - earthdistance dependency cube installs without error 430s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 430s ok 51 - extension earthdistance installs without error 430s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 430s ok 53 - extension earthdistance removes without error 430s ok 54 - psql -qc 'DROP EXTENSION cube' 430s ok 55 - earthdistance dependency extension cube removes without error 430s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 430s ok 57 - extension file_fdw installs without error 430s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 430s ok 59 - extension file_fdw removes without error 430s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 430s ok 61 - extension fuzzystrmatch installs without error 430s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 430s ok 63 - extension fuzzystrmatch removes without error 430s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 430s ok 65 - extension hstore installs without error 430s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 430s ok 67 - extension hstore removes without error 430s ok 68 - psql -qc 'CREATE EXTENSION hstore' 430s ok 69 - hstore_plperl dependency hstore installs without error 430s ok 70 - psql -qc 'CREATE EXTENSION plperl' 430s ok 71 - hstore_plperl dependency plperl installs without error 430s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 430s ok 73 - extension hstore_plperl installs without error 430s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 430s ok 75 - extension hstore_plperl removes without error 430s ok 76 - psql -qc 'DROP EXTENSION hstore' 430s ok 77 - hstore_plperl dependency extension hstore removes without error 430s ok 78 - psql -qc 'DROP EXTENSION plperl' 430s ok 79 - hstore_plperl dependency extension plperl removes without error 430s ok 80 - psql -qc 'CREATE EXTENSION hstore' 430s ok 81 - hstore_plperlu dependency hstore installs without error 430s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 430s ok 83 - hstore_plperlu dependency plperlu installs without error 431s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 431s ok 85 - extension hstore_plperlu installs without error 431s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 431s ok 87 - extension hstore_plperlu removes without error 431s ok 88 - psql -qc 'DROP EXTENSION hstore' 431s ok 89 - hstore_plperlu dependency extension hstore removes without error 431s ok 90 - psql -qc 'DROP EXTENSION plperlu' 431s ok 91 - hstore_plperlu dependency extension plperlu removes without error 431s ok 92 - psql -qc 'CREATE EXTENSION hstore' 431s ok 93 - hstore_plpython3u dependency hstore installs without error 431s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 431s ok 95 - hstore_plpython3u dependency plpython3u installs without error 431s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 431s ok 97 - extension hstore_plpython3u installs without error 431s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 431s ok 99 - extension hstore_plpython3u removes without error 431s ok 100 - psql -qc 'DROP EXTENSION hstore' 431s ok 101 - hstore_plpython3u dependency extension hstore removes without error 431s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 431s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 431s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 431s ok 105 - extension insert_username installs without error 431s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 431s ok 107 - extension insert_username removes without error 431s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 431s ok 109 - extension intagg installs without error 431s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 431s ok 111 - extension intagg removes without error 431s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 431s ok 113 - extension intarray installs without error 431s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 431s ok 115 - extension intarray removes without error 431s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 431s ok 117 - extension isn installs without error 432s ok 118 - psql -qc 'DROP EXTENSION "isn"' 432s ok 119 - extension isn removes without error 432s ok 120 - psql -qc 'CREATE EXTENSION plperl' 432s ok 121 - jsonb_plperl dependency plperl installs without error 432s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 432s ok 123 - extension jsonb_plperl installs without error 432s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 432s ok 125 - extension jsonb_plperl removes without error 432s ok 126 - psql -qc 'DROP EXTENSION plperl' 432s ok 127 - jsonb_plperl dependency extension plperl removes without error 432s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 432s ok 129 - jsonb_plperlu dependency plperlu installs without error 432s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 432s ok 131 - extension jsonb_plperlu installs without error 432s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 432s ok 133 - extension jsonb_plperlu removes without error 432s ok 134 - psql -qc 'DROP EXTENSION plperlu' 432s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 432s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 432s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 432s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 432s ok 139 - extension jsonb_plpython3u installs without error 432s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 432s ok 141 - extension jsonb_plpython3u removes without error 432s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 432s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 432s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 432s ok 145 - extension lo installs without error 432s ok 146 - psql -qc 'DROP EXTENSION "lo"' 432s ok 147 - extension lo removes without error 432s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 432s ok 149 - extension ltree installs without error 432s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 432s ok 151 - extension ltree removes without error 432s ok 152 - psql -qc 'CREATE EXTENSION ltree' 432s ok 153 - ltree_plpython3u dependency ltree installs without error 432s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 432s ok 155 - ltree_plpython3u dependency plpython3u installs without error 432s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 432s ok 157 - extension ltree_plpython3u installs without error 432s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 432s ok 159 - extension ltree_plpython3u removes without error 432s ok 160 - psql -qc 'DROP EXTENSION ltree' 432s ok 161 - ltree_plpython3u dependency extension ltree removes without error 433s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 433s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 433s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 433s ok 165 - extension moddatetime installs without error 433s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 433s ok 167 - extension moddatetime removes without error 433s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 433s ok 169 - extension pageinspect installs without error 433s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 433s ok 171 - extension pageinspect removes without error 433s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 433s ok 173 - extension pg_buffercache installs without error 433s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 433s ok 175 - extension pg_buffercache removes without error 433s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 433s ok 177 - extension pg_freespacemap installs without error 433s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 433s ok 179 - extension pg_freespacemap removes without error 433s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 433s ok 181 - extension pg_prewarm installs without error 433s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 433s ok 183 - extension pg_prewarm removes without error 433s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 433s ok 185 - extension pg_stat_statements installs without error 433s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 433s ok 187 - extension pg_stat_statements removes without error 433s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 433s ok 189 - extension pg_trgm installs without error 433s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 433s ok 191 - extension pg_trgm removes without error 433s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 433s ok 193 - extension pg_visibility installs without error 433s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 433s ok 195 - extension pg_visibility removes without error 433s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 433s ok 197 - extension pgcrypto installs without error 433s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 433s ok 199 - extension pgcrypto removes without error 433s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 433s ok 201 - extension pgrowlocks installs without error 433s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 433s ok 203 - extension pgrowlocks removes without error 433s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 433s ok 205 - extension pgstattuple installs without error 433s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 433s ok 207 - extension pgstattuple removes without error 434s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 434s ok 209 - extension plperl installs without error 434s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 434s ok 211 - extension plperl removes without error 434s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 434s ok 213 - extension plperlu installs without error 434s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 434s ok 215 - extension plperlu removes without error 434s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 434s ok 217 - extension plpython3u installs without error 434s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 434s ok 219 - extension plpython3u removes without error 434s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 434s ok 221 - extension pltcl installs without error 434s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 434s ok 223 - extension pltcl removes without error 434s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 434s ok 225 - extension pltclu installs without error 434s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 434s ok 227 - extension pltclu removes without error 434s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 434s ok 229 - extension postgres_fdw installs without error 434s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 434s ok 231 - extension postgres_fdw removes without error 434s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 434s ok 233 - extension refint installs without error 434s ok 234 - psql -qc 'DROP EXTENSION "refint"' 434s ok 235 - extension refint removes without error 434s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 434s ok 237 - extension seg installs without error 434s ok 238 - psql -qc 'DROP EXTENSION "seg"' 434s ok 239 - extension seg removes without error 434s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 434s ok 241 - extension sslinfo installs without error 434s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 434s ok 243 - extension sslinfo removes without error 434s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 434s ok 245 - extension tablefunc installs without error 434s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 434s ok 247 - extension tablefunc removes without error 435s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 435s ok 249 - extension tcn installs without error 435s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 435s ok 251 - extension tcn removes without error 435s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 435s ok 253 - extension tsm_system_rows installs without error 435s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 435s ok 255 - extension tsm_system_rows removes without error 435s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 435s ok 257 - extension tsm_system_time installs without error 435s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 435s ok 259 - extension tsm_system_time removes without error 435s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 435s ok 261 - extension unaccent installs without error 435s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 435s ok 263 - extension unaccent removes without error 435s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 435s ok 265 - extension uuid-ossp installs without error 435s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 435s ok 267 - extension uuid-ossp removes without error 435s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 435s ok 269 - extension xml2 installs without error 435s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 435s ok 271 - extension xml2 removes without error 436s ok 272 - pg_dropcluster 12 main 436s ok 273 - Cleanup: No clusters left behind 436s ok 274 - No postgres processes left behind 436s ok 275 - No files in /etc/postgresql left behind 436s ok 276 - No files in /var/lib/postgresql left behind 436s ok 277 - No files in /var/run/postgresql left behind 436s ok 278 - No files in /var/log/postgresql left behind 436s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 436s ok 280 - PostgreSQL TCP ports are closed 436s 1..280 436s === Running test 180_ecpg.t ... === 436s 1..17 436s ok 1 - ecpg test.pgc 436s ok 2 - ecpg processing 436s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 436s ok 4 - compiling ecpg output 439s ok 5 - pg_createcluster 12 main 439s ok 6 - createuser nobody 439s ok 7 - /tmp/tmp.GNEXAtZUDr/test 439s not ok 8 - runs and gives correct output 439s # Failed test 'runs and gives correct output' 439s # at t/TestLib.pm line 201. 439s # got: ' 439s # ' 439s # expected: 'template1 439s # ' 439s ok 9 - pg_dropcluster 12 main 439s ok 10 - Cleanup: No clusters left behind 439s ok 11 - No postgres processes left behind 439s ok 12 - No files in /etc/postgresql left behind 439s ok 13 - No files in /var/lib/postgresql left behind 439s ok 14 - No files in /var/run/postgresql left behind 439s ok 15 - No files in /var/log/postgresql left behind 439s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 439s ok 17 - PostgreSQL TCP ports are closed 439s # Looks like you failed 1 test of 17. 440s autopkgtest [15:01:28]: test run-testsuite: -----------------------] 440s run-testsuite FAIL non-zero exit status 1 440s autopkgtest [15:01:28]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 441s autopkgtest [15:01:29]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 441s # Failed test 'runs and gives correct output' 441s # at t/TestLib.pm line 201. 441s # got: ' 441s # ' 441s # expected: 'template1 441s # ' 441s # Looks like you failed 1 test of 17. 441s autopkgtest [15:01:29]: @@@@@@@@@@@@@@@@@@@@ summary 441s default-psql PASS 441s run-testsuite FAIL non-zero exit status 1 446s nova [W] Skipping flock for amd64 446s Creating nova instance adt-focal-amd64-postgresql-common-20250326-145408-juju-7f2275-prod-proposed-migration-environment-15-81abf638-1551-46a3-9c17-f88e799fe8d4 from image adt/ubuntu-focal-amd64-server-20250326.img (UUID 9d085e61-ab19-4dd9-b6ee-4496b7ea89ae)... 446s nova [W] Timed out waiting for e5896c51-b5d3-4fe4-bd54-e3dd75adcc5c to get deleted. 446s nova [W] Skipping flock for amd64 446s Creating nova instance adt-focal-amd64-postgresql-common-20250326-145408-juju-7f2275-prod-proposed-migration-environment-15-81abf638-1551-46a3-9c17-f88e799fe8d4 from image adt/ubuntu-focal-amd64-server-20250326.img (UUID 9d085e61-ab19-4dd9-b6ee-4496b7ea89ae)... 446s nova [W] Timed out waiting for 46c8deca-5cea-4d80-9c47-27c162118401 to get deleted.