0s autopkgtest [03:32:02]: starting date and time: 2025-03-26 03:32:02+0000 0s autopkgtest [03:32:02]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [03:32:02]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.3jt_7jr8/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_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\n" >> /etc/environment' --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 -- lxd -r lxd-armhf-10.145.243.229 lxd-armhf-10.145.243.229:autopkgtest/ubuntu/focal/armhf 28s autopkgtest [03:32:30]: testbed dpkg architecture: armhf 32s autopkgtest [03:32:34]: testbed apt version: 2.0.10 37s autopkgtest [03:32:39]: @@@@@@@@@@@@@@@@@@@@ test bed setup 40s autopkgtest [03:32:42]: testbed release detected to be: None 50s autopkgtest [03:32:52]: updating testbed package index (apt update) 52s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 52s Get:2 http://ftpmaster.internal/ubuntu focal-updates InRelease [128 kB] 52s Get:3 http://ftpmaster.internal/ubuntu focal-security InRelease [128 kB] 52s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 53s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main Sources [625 kB] 53s Get:6 http://ftpmaster.internal/ubuntu focal-updates/restricted Sources [58.0 kB] 53s Get:7 http://ftpmaster.internal/ubuntu focal-updates/multiverse Sources [33.7 kB] 53s Get:8 http://ftpmaster.internal/ubuntu focal-updates/universe Sources [418 kB] 53s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main armhf Packages [1753 kB] 53s Get:10 http://ftpmaster.internal/ubuntu focal-updates/main armhf c-n-f Metadata [16.8 kB] 53s Get:11 http://ftpmaster.internal/ubuntu focal-updates/restricted armhf Packages [18.9 kB] 53s Get:12 http://ftpmaster.internal/ubuntu focal-updates/universe armhf Packages [1007 kB] 53s Get:13 http://ftpmaster.internal/ubuntu focal-updates/universe armhf c-n-f Metadata [23.0 kB] 53s Get:14 http://ftpmaster.internal/ubuntu focal-updates/multiverse armhf Packages [9552 B] 53s Get:15 http://ftpmaster.internal/ubuntu focal-security/restricted Sources [56.9 kB] 53s Get:16 http://ftpmaster.internal/ubuntu focal-security/universe Sources [257 kB] 53s Get:17 http://ftpmaster.internal/ubuntu focal-security/multiverse Sources [21.9 kB] 53s Get:18 http://ftpmaster.internal/ubuntu focal-security/main Sources [333 kB] 53s Get:19 http://ftpmaster.internal/ubuntu focal-security/main armhf Packages [1462 kB] 53s Get:20 http://ftpmaster.internal/ubuntu focal-security/main armhf c-n-f Metadata [13.3 kB] 53s Get:21 http://ftpmaster.internal/ubuntu focal-security/restricted armhf Packages [18.5 kB] 53s Get:22 http://ftpmaster.internal/ubuntu focal-security/universe armhf Packages [792 kB] 53s Get:23 http://ftpmaster.internal/ubuntu focal-security/universe armhf c-n-f Metadata [16.3 kB] 53s Get:24 http://ftpmaster.internal/ubuntu focal-security/multiverse armhf Packages [5672 B] 53s Get:25 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 53s Get:26 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 53s Get:27 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 53s Get:28 http://ftpmaster.internal/ubuntu focal-proposed/main armhf Packages [172 kB] 53s Get:29 http://ftpmaster.internal/ubuntu focal-proposed/main armhf c-n-f Metadata [1536 B] 53s Get:30 http://ftpmaster.internal/ubuntu focal-proposed/restricted armhf Packages [1524 B] 53s Get:31 http://ftpmaster.internal/ubuntu focal-proposed/restricted armhf c-n-f Metadata [116 B] 53s Get:32 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf Packages [39.6 kB] 53s Get:33 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf c-n-f Metadata [1780 B] 53s Get:34 http://ftpmaster.internal/ubuntu focal-proposed/multiverse armhf Packages [760 B] 53s Get:35 http://ftpmaster.internal/ubuntu focal-proposed/multiverse armhf c-n-f Metadata [116 B] 59s Fetched 7771 kB in 2s (4233 kB/s) 60s Reading package lists... 72s autopkgtest [03:33:14]: upgrading testbed (apt dist-upgrade and autopurge) 80s Reading package lists... 80s Building dependency tree... 80s Reading state information... 80s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 81s Starting 2 pkgProblemResolver with broken count: 0 81s Done 81s 81s The following packages were automatically installed and are no longer required: 81s linux-headers-5.4.0-208 linux-headers-5.4.0-208-generic 81s Use 'apt autoremove' to remove them. 81s The following NEW packages will be installed: 81s linux-headers-5.4.0-211 linux-headers-5.4.0-211-generic 81s The following packages will be upgraded: 81s libpython3.8-minimal libpython3.8-stdlib linux-headers-generic python3.8 81s python3.8-minimal 82s 5 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 82s Need to get 16.3 MB of archives. 82s After this operation, 81.6 MB of additional disk space will be used. 82s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main armhf python3.8 armhf 3.8.10-0ubuntu1~20.04.18 [387 kB] 82s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main armhf libpython3.8-stdlib armhf 3.8.10-0ubuntu1~20.04.18 [1602 kB] 82s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main armhf python3.8-minimal armhf 3.8.10-0ubuntu1~20.04.18 [1585 kB] 82s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main armhf libpython3.8-minimal armhf 3.8.10-0ubuntu1~20.04.18 [711 kB] 82s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-5.4.0-211 all 5.4.0-211.231 [11.0 MB] 82s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-5.4.0-211-generic armhf 5.4.0-211.231 [987 kB] 82s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-generic armhf 5.4.0.211.206 [2412 B] 83s Fetched 16.3 MB in 1s (16.3 MB/s) 83s (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 ... 56540 files and directories currently installed.) 83s Preparing to unpack .../0-python3.8_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 83s Unpacking python3.8 (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 83s Preparing to unpack .../1-libpython3.8-stdlib_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 83s Unpacking libpython3.8-stdlib:armhf (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 84s Preparing to unpack .../2-python3.8-minimal_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 84s Unpacking python3.8-minimal (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 84s Preparing to unpack .../3-libpython3.8-minimal_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 84s Unpacking libpython3.8-minimal:armhf (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 84s Selecting previously unselected package linux-headers-5.4.0-211. 84s Preparing to unpack .../4-linux-headers-5.4.0-211_5.4.0-211.231_all.deb ... 84s Unpacking linux-headers-5.4.0-211 (5.4.0-211.231) ... 88s Selecting previously unselected package linux-headers-5.4.0-211-generic. 88s Preparing to unpack .../5-linux-headers-5.4.0-211-generic_5.4.0-211.231_armhf.deb ... 88s Unpacking linux-headers-5.4.0-211-generic (5.4.0-211.231) ... 90s Preparing to unpack .../6-linux-headers-generic_5.4.0.211.206_armhf.deb ... 90s Unpacking linux-headers-generic (5.4.0.211.206) over (5.4.0.208.204) ... 90s Setting up libpython3.8-minimal:armhf (3.8.10-0ubuntu1~20.04.18) ... 90s Setting up linux-headers-5.4.0-211 (5.4.0-211.231) ... 90s Setting up python3.8-minimal (3.8.10-0ubuntu1~20.04.18) ... 91s Setting up libpython3.8-stdlib:armhf (3.8.10-0ubuntu1~20.04.18) ... 91s Setting up python3.8 (3.8.10-0ubuntu1~20.04.18) ... 92s Setting up linux-headers-5.4.0-211-generic (5.4.0-211.231) ... 92s Setting up linux-headers-generic (5.4.0.211.206) ... 92s Processing triggers for mime-support (3.64ubuntu1) ... 92s Processing triggers for man-db (2.9.1-1) ... 95s Reading package lists... 95s Building dependency tree... 95s Reading state information... 95s Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 96s The following packages will be REMOVED: 96s linux-headers-5.4.0-208* linux-headers-5.4.0-208-generic* 97s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 97s After this operation, 81.6 MB disk space will be freed. 97s (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 ... 87265 files and directories currently installed.) 97s Removing linux-headers-5.4.0-208-generic (5.4.0-208.228) ... 97s Removing linux-headers-5.4.0-208 (5.4.0-208.228) ... 101s autopkgtest [03:33:43]: rebooting testbed after setup commands that affected boot 152s autopkgtest [03:34:34]: testbed running kernel: Linux 6.8.0-52-generic #53~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Jan 15 18:10:51 UTC 2 188s autopkgtest [03:35:10]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 229s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (dsc) [2534 B] 229s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (tar) [216 kB] 229s gpgv: Signature made Mon Aug 24 15:04:29 2020 UTC 229s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 229s gpgv: Can't check signature: No public key 229s dpkg-source: warning: failed to verify signature on ./postgresql-common_214ubuntu0.1.dsc 229s autopkgtest [03:35:51]: testing package postgresql-common version 214ubuntu0.1 231s autopkgtest [03:35:53]: build not needed 233s autopkgtest [03:35:55]: test default-psql: preparing testbed 235s Reading package lists... 236s Building dependency tree... 236s Reading state information... 236s Starting pkgProblemResolver with broken count: 0 236s Starting 2 pkgProblemResolver with broken count: 0 236s Done 237s The following NEW packages will be installed: 237s libllvm10 libpq5 libxslt1.1 postgresql postgresql-12 postgresql-client-12 237s postgresql-client-common postgresql-common ssl-cert 237s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 237s Need to get 27.9 MB of archives. 237s After this operation, 107 MB of additional disk space will be used. 237s Get:1 http://ftpmaster.internal/ubuntu focal/main armhf libllvm10 armhf 1:10.0.0-4ubuntu1 [13.4 MB] 238s Get:2 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libpq5 armhf 12.22-0ubuntu0.20.04.3 [102 kB] 238s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main armhf libxslt1.1 armhf 1.1.34-4ubuntu0.20.04.3 [133 kB] 238s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main armhf postgresql-client-common all 214ubuntu0.1 [28.2 kB] 238s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/main armhf postgresql-client-12 armhf 12.22-0ubuntu0.20.04.3 [1008 kB] 238s Get:6 http://ftpmaster.internal/ubuntu focal/main armhf ssl-cert all 1.0.39 [17.0 kB] 238s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main armhf postgresql-common all 214ubuntu0.1 [169 kB] 238s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main armhf postgresql-12 armhf 12.22-0ubuntu0.20.04.3 [13.0 MB] 238s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main armhf postgresql all 12+214ubuntu0.1 [3924 B] 239s Preconfiguring packages ... 239s Fetched 27.9 MB in 1s (18.8 MB/s) 239s Selecting previously unselected package libllvm10:armhf. 239s (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 ... 56540 files and directories currently installed.) 239s Preparing to unpack .../0-libllvm10_1%3a10.0.0-4ubuntu1_armhf.deb ... 239s Unpacking libllvm10:armhf (1:10.0.0-4ubuntu1) ... 240s Selecting previously unselected package libpq5:armhf. 240s Preparing to unpack .../1-libpq5_12.22-0ubuntu0.20.04.3_armhf.deb ... 240s Unpacking libpq5:armhf (12.22-0ubuntu0.20.04.3) ... 240s Selecting previously unselected package libxslt1.1:armhf. 240s Preparing to unpack .../2-libxslt1.1_1.1.34-4ubuntu0.20.04.3_armhf.deb ... 240s Unpacking libxslt1.1:armhf (1.1.34-4ubuntu0.20.04.3) ... 240s Selecting previously unselected package postgresql-client-common. 240s Preparing to unpack .../3-postgresql-client-common_214ubuntu0.1_all.deb ... 240s Unpacking postgresql-client-common (214ubuntu0.1) ... 240s Selecting previously unselected package postgresql-client-12. 240s Preparing to unpack .../4-postgresql-client-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 240s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 240s Selecting previously unselected package ssl-cert. 240s Preparing to unpack .../5-ssl-cert_1.0.39_all.deb ... 240s Unpacking ssl-cert (1.0.39) ... 241s Selecting previously unselected package postgresql-common. 241s Preparing to unpack .../6-postgresql-common_214ubuntu0.1_all.deb ... 241s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 241s Unpacking postgresql-common (214ubuntu0.1) ... 241s Selecting previously unselected package postgresql-12. 241s Preparing to unpack .../7-postgresql-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 241s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 242s Selecting previously unselected package postgresql. 242s Preparing to unpack .../8-postgresql_12+214ubuntu0.1_all.deb ... 242s Unpacking postgresql (12+214ubuntu0.1) ... 242s Setting up postgresql-client-common (214ubuntu0.1) ... 242s Setting up libpq5:armhf (12.22-0ubuntu0.20.04.3) ... 242s Setting up libllvm10:armhf (1:10.0.0-4ubuntu1) ... 242s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 243s 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 243s Setting up ssl-cert (1.0.39) ... 245s Setting up postgresql-common (214ubuntu0.1) ... 245s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 246s Adding user postgres to group ssl-cert 246s 246s Creating config file /etc/postgresql-common/createcluster.conf with new version 246s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 246s Removing obsolete dictionary files: 247s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 247s Setting up libxslt1.1:armhf (1.1.34-4ubuntu0.20.04.3) ... 247s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 248s Creating new PostgreSQL cluster 12/main ... 248s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 248s The files belonging to this database system will be owned by user "postgres". 248s This user must also own the server process. 248s 248s The database cluster will be initialized with locale "C.UTF-8". 248s The default database encoding has accordingly been set to "UTF8". 248s The default text search configuration will be set to "english". 248s 248s Data page checksums are disabled. 248s 248s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 248s creating subdirectories ... ok 248s selecting dynamic shared memory implementation ... posix 248s selecting default max_connections ... 100 248s selecting default shared_buffers ... 128MB 248s selecting default time zone ... Etc/UTC 248s creating configuration files ... ok 248s running bootstrap script ... ok 249s performing post-bootstrap initialization ... ok 249s syncing data to disk ... ok 249s 249s Success. You can now start the database server using: 249s 249s pg_ctlcluster 12 main start 249s 249s Ver Cluster Port Status Owner Data directory Log file 249s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 249s 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 252s Setting up postgresql (12+214ubuntu0.1) ... 252s Processing triggers for systemd (245.4-4ubuntu3.24) ... 253s Processing triggers for man-db (2.9.1-1) ... 255s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 267s autopkgtest [03:36:29]: test default-psql: [----------------------- 269s autopkgtest [03:36:31]: test default-psql: -----------------------] 273s autopkgtest [03:36:35]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 275s default-psql PASS 281s autopkgtest [03:36:43]: test run-testsuite: preparing testbed 306s autopkgtest [03:37:08]: testbed dpkg architecture: armhf 308s autopkgtest [03:37:10]: testbed apt version: 2.0.10 311s autopkgtest [03:37:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 313s autopkgtest [03:37:15]: testbed release detected to be: focal 320s autopkgtest [03:37:22]: updating testbed package index (apt update) 322s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 322s Get:2 http://ftpmaster.internal/ubuntu focal-updates InRelease [128 kB] 323s Get:3 http://ftpmaster.internal/ubuntu focal-security InRelease [128 kB] 323s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 323s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main Sources [625 kB] 323s Get:6 http://ftpmaster.internal/ubuntu focal-updates/restricted Sources [58.0 kB] 323s Get:7 http://ftpmaster.internal/ubuntu focal-updates/universe Sources [418 kB] 323s Get:8 http://ftpmaster.internal/ubuntu focal-updates/multiverse Sources [33.7 kB] 323s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main armhf Packages [1753 kB] 323s Get:10 http://ftpmaster.internal/ubuntu focal-updates/main armhf c-n-f Metadata [16.8 kB] 323s Get:11 http://ftpmaster.internal/ubuntu focal-updates/restricted armhf Packages [18.9 kB] 323s Get:12 http://ftpmaster.internal/ubuntu focal-updates/universe armhf Packages [1007 kB] 323s Get:13 http://ftpmaster.internal/ubuntu focal-updates/universe armhf c-n-f Metadata [23.0 kB] 323s Get:14 http://ftpmaster.internal/ubuntu focal-updates/multiverse armhf Packages [9552 B] 323s Get:15 http://ftpmaster.internal/ubuntu focal-security/restricted Sources [56.9 kB] 323s Get:16 http://ftpmaster.internal/ubuntu focal-security/universe Sources [257 kB] 323s Get:17 http://ftpmaster.internal/ubuntu focal-security/multiverse Sources [21.9 kB] 323s Get:18 http://ftpmaster.internal/ubuntu focal-security/main Sources [333 kB] 323s Get:19 http://ftpmaster.internal/ubuntu focal-security/main armhf Packages [1462 kB] 323s Get:20 http://ftpmaster.internal/ubuntu focal-security/main armhf c-n-f Metadata [13.3 kB] 323s Get:21 http://ftpmaster.internal/ubuntu focal-security/restricted armhf Packages [18.5 kB] 323s Get:22 http://ftpmaster.internal/ubuntu focal-security/universe armhf Packages [792 kB] 323s Get:23 http://ftpmaster.internal/ubuntu focal-security/universe armhf c-n-f Metadata [16.3 kB] 323s Get:24 http://ftpmaster.internal/ubuntu focal-security/multiverse armhf Packages [5672 B] 323s Get:25 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 324s Get:26 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 324s Get:27 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 324s Get:28 http://ftpmaster.internal/ubuntu focal-proposed/main armhf Packages [172 kB] 324s Get:29 http://ftpmaster.internal/ubuntu focal-proposed/main armhf c-n-f Metadata [1536 B] 324s Get:30 http://ftpmaster.internal/ubuntu focal-proposed/restricted armhf Packages [1524 B] 324s Get:31 http://ftpmaster.internal/ubuntu focal-proposed/restricted armhf c-n-f Metadata [116 B] 324s Get:32 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf Packages [39.6 kB] 324s Get:33 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf c-n-f Metadata [1780 B] 324s Get:34 http://ftpmaster.internal/ubuntu focal-proposed/multiverse armhf Packages [760 B] 324s Get:35 http://ftpmaster.internal/ubuntu focal-proposed/multiverse armhf c-n-f Metadata [116 B] 329s Fetched 7771 kB in 2s (4526 kB/s) 330s Reading package lists... 336s autopkgtest [03:37:38]: upgrading testbed (apt dist-upgrade and autopurge) 338s Reading package lists... 338s Building dependency tree... 338s Reading state information... 339s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 339s Starting 2 pkgProblemResolver with broken count: 0 339s Done 339s 339s The following packages were automatically installed and are no longer required: 339s linux-headers-5.4.0-208 linux-headers-5.4.0-208-generic 339s Use 'apt autoremove' to remove them. 339s The following NEW packages will be installed: 339s linux-headers-5.4.0-211 linux-headers-5.4.0-211-generic 339s The following packages will be upgraded: 339s libpython3.8-minimal libpython3.8-stdlib linux-headers-generic python3.8 339s python3.8-minimal 340s 5 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 340s Need to get 16.3 MB of archives. 340s After this operation, 81.6 MB of additional disk space will be used. 340s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main armhf python3.8 armhf 3.8.10-0ubuntu1~20.04.18 [387 kB] 340s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main armhf libpython3.8-stdlib armhf 3.8.10-0ubuntu1~20.04.18 [1602 kB] 340s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main armhf python3.8-minimal armhf 3.8.10-0ubuntu1~20.04.18 [1585 kB] 340s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main armhf libpython3.8-minimal armhf 3.8.10-0ubuntu1~20.04.18 [711 kB] 340s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-5.4.0-211 all 5.4.0-211.231 [11.0 MB] 341s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-5.4.0-211-generic armhf 5.4.0-211.231 [987 kB] 341s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-headers-generic armhf 5.4.0.211.206 [2412 B] 342s Fetched 16.3 MB in 2s (10.7 MB/s) 342s (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 ... 56540 files and directories currently installed.) 342s Preparing to unpack .../0-python3.8_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 342s Unpacking python3.8 (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 342s Preparing to unpack .../1-libpython3.8-stdlib_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 342s Unpacking libpython3.8-stdlib:armhf (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 342s Preparing to unpack .../2-python3.8-minimal_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 342s Unpacking python3.8-minimal (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 342s Preparing to unpack .../3-libpython3.8-minimal_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 342s Unpacking libpython3.8-minimal:armhf (3.8.10-0ubuntu1~20.04.18) over (3.8.10-0ubuntu1~20.04.17) ... 343s Selecting previously unselected package linux-headers-5.4.0-211. 343s Preparing to unpack .../4-linux-headers-5.4.0-211_5.4.0-211.231_all.deb ... 343s Unpacking linux-headers-5.4.0-211 (5.4.0-211.231) ... 346s Selecting previously unselected package linux-headers-5.4.0-211-generic. 346s Preparing to unpack .../5-linux-headers-5.4.0-211-generic_5.4.0-211.231_armhf.deb ... 346s Unpacking linux-headers-5.4.0-211-generic (5.4.0-211.231) ... 348s Preparing to unpack .../6-linux-headers-generic_5.4.0.211.206_armhf.deb ... 348s Unpacking linux-headers-generic (5.4.0.211.206) over (5.4.0.208.204) ... 348s Setting up libpython3.8-minimal:armhf (3.8.10-0ubuntu1~20.04.18) ... 348s Setting up linux-headers-5.4.0-211 (5.4.0-211.231) ... 348s Setting up python3.8-minimal (3.8.10-0ubuntu1~20.04.18) ... 349s Setting up libpython3.8-stdlib:armhf (3.8.10-0ubuntu1~20.04.18) ... 349s Setting up python3.8 (3.8.10-0ubuntu1~20.04.18) ... 350s Setting up linux-headers-5.4.0-211-generic (5.4.0-211.231) ... 350s Setting up linux-headers-generic (5.4.0.211.206) ... 350s Processing triggers for mime-support (3.64ubuntu1) ... 350s Processing triggers for man-db (2.9.1-1) ... 352s Reading package lists... 353s Building dependency tree... 353s Reading state information... 353s Starting pkgProblemResolver with broken count: 0 353s Starting 2 pkgProblemResolver with broken count: 0 353s Done 354s The following packages will be REMOVED: 354s linux-headers-5.4.0-208* linux-headers-5.4.0-208-generic* 354s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 354s After this operation, 81.6 MB disk space will be freed. 354s (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 ... 87265 files and directories currently installed.) 354s Removing linux-headers-5.4.0-208-generic (5.4.0-208.228) ... 355s Removing linux-headers-5.4.0-208 (5.4.0-208.228) ... 358s autopkgtest [03:38:00]: rebooting testbed after setup commands that affected boot 429s Reading package lists... 429s Building dependency tree... 429s Reading state information... 430s Starting pkgProblemResolver with broken count: 0 430s Starting 2 pkgProblemResolver with broken count: 0 430s Done 431s The following NEW packages will be installed: 431s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 431s emacsen-common fakeroot g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us 431s libasan5 libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-10-dev 431s libclang-cpp10 libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev 431s libecpg6 libfakeroot libffi-dev libgc1c2 libgcc-9-dev libgomp1 libisl22 431s libllvm10 libmpc3 libncurses-dev libobjc-9-dev libobjc4 libpfm4 libpgtypes3 431s libpq-dev libpq5 libpython3.8 libstdc++-9-dev libtcl8.6 libtinfo-dev 431s libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 431s llvm-10-runtime llvm-10-tools net-tools postgresql-12 postgresql-all 431s postgresql-client-12 postgresql-client-common postgresql-common 431s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 431s postgresql-server-dev-12 postgresql-server-dev-all python3-pygments ssl-cert 431s 0 upgraded, 67 newly installed, 0 to remove and 0 not upgraded. 431s Need to get 116 MB of archives. 431s After this operation, 546 MB of additional disk space will be used. 431s Get:1 http://ftpmaster.internal/ubuntu focal/universe armhf binfmt-support armhf 2.2.0-2 [47.5 kB] 431s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main armhf libc-dev-bin armhf 2.31-0ubuntu9.17 [63.7 kB] 431s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main armhf linux-libc-dev armhf 5.4.0-211.231 [1098 kB] 431s Get:4 http://ftpmaster.internal/ubuntu focal/main armhf libcrypt-dev armhf 1:4.4.10-10ubuntu4 [120 kB] 431s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main armhf libc6-dev armhf 2.31-0ubuntu9.17 [1915 kB] 431s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main armhf gcc-9-base armhf 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 431s Get:7 http://ftpmaster.internal/ubuntu focal/main armhf libisl22 armhf 0.22.1-1 [460 kB] 431s Get:8 http://ftpmaster.internal/ubuntu focal/main armhf libmpc3 armhf 1.1.0-1 [33.2 kB] 431s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main armhf cpp-9 armhf 9.4.0-1ubuntu1~20.04.2 [5887 kB] 432s Get:10 http://ftpmaster.internal/ubuntu focal/main armhf cpp armhf 4:9.3.0-1ubuntu2 [27.6 kB] 432s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main armhf libcc1-0 armhf 10.5.0-1ubuntu1~20.04 [41.8 kB] 432s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main armhf libgomp1 armhf 10.5.0-1ubuntu1~20.04 [87.4 kB] 432s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main armhf libatomic1 armhf 10.5.0-1ubuntu1~20.04 [7256 B] 432s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main armhf libasan5 armhf 9.4.0-1ubuntu1~20.04.2 [2805 kB] 432s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main armhf libubsan1 armhf 10.5.0-1ubuntu1~20.04 [757 kB] 432s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main armhf libgcc-9-dev armhf 9.4.0-1ubuntu1~20.04.2 [682 kB] 432s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main armhf gcc-9 armhf 9.4.0-1ubuntu1~20.04.2 [6584 kB] 432s Get:18 http://ftpmaster.internal/ubuntu focal/main armhf gcc armhf 4:9.3.0-1ubuntu2 [5224 B] 432s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main armhf libstdc++-9-dev armhf 9.4.0-1ubuntu1~20.04.2 [1792 kB] 432s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main armhf g++-9 armhf 9.4.0-1ubuntu1~20.04.2 [6699 kB] 433s Get:21 http://ftpmaster.internal/ubuntu focal/main armhf g++ armhf 4:9.3.0-1ubuntu2 [1612 B] 433s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main armhf build-essential armhf 12.8ubuntu1.1 [4664 B] 433s Get:23 http://ftpmaster.internal/ubuntu focal/main armhf libllvm10 armhf 1:10.0.0-4ubuntu1 [13.4 MB] 433s Get:24 http://ftpmaster.internal/ubuntu focal/universe armhf libclang-cpp10 armhf 1:10.0.0-4ubuntu1 [8375 kB] 433s Get:25 http://ftpmaster.internal/ubuntu focal/main armhf libgc1c2 armhf 1:7.6.4-0.4ubuntu1 [73.0 kB] 433s Get:26 http://ftpmaster.internal/ubuntu focal-updates/universe armhf libobjc4 armhf 10.5.0-1ubuntu1~20.04 [34.2 kB] 433s Get:27 http://ftpmaster.internal/ubuntu focal-updates/universe armhf libobjc-9-dev armhf 9.4.0-1ubuntu1~20.04.2 [207 kB] 433s Get:28 http://ftpmaster.internal/ubuntu focal/universe armhf libclang-common-10-dev armhf 1:10.0.0-4ubuntu1 [2613 kB] 433s Get:29 http://ftpmaster.internal/ubuntu focal/universe armhf libclang1-10 armhf 1:10.0.0-4ubuntu1 [6287 kB] 433s Get:30 http://ftpmaster.internal/ubuntu focal/universe armhf clang-10 armhf 1:10.0.0-4ubuntu1 [60.8 kB] 433s Get:31 http://ftpmaster.internal/ubuntu focal/main armhf emacsen-common all 3.0.4 [14.9 kB] 433s Get:32 http://ftpmaster.internal/ubuntu focal/main armhf dictionaries-common all 1.28.1 [178 kB] 433s Get:33 http://ftpmaster.internal/ubuntu focal/main armhf libfakeroot armhf 1.24-1 [22.4 kB] 433s Get:34 http://ftpmaster.internal/ubuntu focal/main armhf fakeroot armhf 1.24-1 [60.9 kB] 433s Get:35 http://ftpmaster.internal/ubuntu focal/main armhf hunspell-en-us all 1:2018.04.16-1 [170 kB] 433s Get:36 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libpgtypes3 armhf 12.22-0ubuntu0.20.04.3 [40.7 kB] 433s Get:37 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libpq5 armhf 12.22-0ubuntu0.20.04.3 [102 kB] 433s Get:38 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libecpg6 armhf 12.22-0ubuntu0.20.04.3 [35.5 kB] 433s Get:39 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libecpg-compat3 armhf 12.22-0ubuntu0.20.04.3 [11.4 kB] 433s Get:40 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libpq-dev armhf 12.22-0ubuntu0.20.04.3 [126 kB] 433s Get:41 http://ftpmaster.internal/ubuntu focal-proposed/main armhf libecpg-dev armhf 12.22-0ubuntu0.20.04.3 [220 kB] 433s Get:42 http://ftpmaster.internal/ubuntu focal-updates/main armhf libncurses-dev armhf 6.2-0ubuntu2.1 [301 kB] 433s Get:43 http://ftpmaster.internal/ubuntu focal-updates/main armhf libpython3.8 armhf 3.8.10-0ubuntu1~20.04.18 [1397 kB] 433s Get:44 http://ftpmaster.internal/ubuntu focal/main armhf libtcl8.6 armhf 8.6.10+dfsg-1 [798 kB] 433s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main armhf libtinfo-dev armhf 6.2-0ubuntu2.1 [972 B] 433s Get:46 http://ftpmaster.internal/ubuntu focal-updates/main armhf libxslt1.1 armhf 1.1.34-4ubuntu0.20.04.3 [133 kB] 433s Get:47 http://ftpmaster.internal/ubuntu focal/universe armhf llvm-10-runtime armhf 1:10.0.0-4ubuntu1 [153 kB] 433s Get:48 http://ftpmaster.internal/ubuntu focal/main armhf libpfm4 armhf 4.10.1+git20-g7700f49-2 [33.0 kB] 434s Get:49 http://ftpmaster.internal/ubuntu focal/universe armhf llvm-10 armhf 1:10.0.0-4ubuntu1 [4144 kB] 434s Get:50 http://ftpmaster.internal/ubuntu focal/main armhf libffi-dev armhf 3.3-4 [53.0 kB] 434s Get:51 http://ftpmaster.internal/ubuntu focal-updates/main armhf python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 434s Get:52 http://ftpmaster.internal/ubuntu focal/universe armhf llvm-10-tools armhf 1:10.0.0-4ubuntu1 [277 kB] 434s Get:53 http://ftpmaster.internal/ubuntu focal/universe armhf libz3-4 armhf 4.8.7-4build1 [5781 kB] 434s Get:54 http://ftpmaster.internal/ubuntu focal/universe armhf libz3-dev armhf 4.8.7-4build1 [67.5 kB] 434s Get:55 http://ftpmaster.internal/ubuntu focal/universe armhf llvm-10-dev armhf 1:10.0.0-4ubuntu1 [25.5 MB] 434s Get:56 http://ftpmaster.internal/ubuntu focal/main armhf net-tools armhf 1.60+git20180626.aebd88e-1ubuntu1 [180 kB] 434s Get:57 http://ftpmaster.internal/ubuntu focal-updates/main armhf postgresql-client-common all 214ubuntu0.1 [28.2 kB] 434s Get:58 http://ftpmaster.internal/ubuntu focal-proposed/main armhf postgresql-client-12 armhf 12.22-0ubuntu0.20.04.3 [1008 kB] 434s Get:59 http://ftpmaster.internal/ubuntu focal/main armhf ssl-cert all 1.0.39 [17.0 kB] 434s Get:60 http://ftpmaster.internal/ubuntu focal-updates/main armhf postgresql-common all 214ubuntu0.1 [169 kB] 434s Get:61 http://ftpmaster.internal/ubuntu focal-proposed/main armhf postgresql-12 armhf 12.22-0ubuntu0.20.04.3 [13.0 MB] 435s Get:62 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf postgresql-server-dev-12 armhf 12.22-0ubuntu0.20.04.3 [985 kB] 435s Get:63 http://ftpmaster.internal/ubuntu focal-updates/universe armhf postgresql-server-dev-all all 214ubuntu0.1 [7652 B] 435s Get:64 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf postgresql-plperl-12 armhf 12.22-0ubuntu0.20.04.3 [64.1 kB] 435s Get:65 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf postgresql-plpython3-12 armhf 12.22-0ubuntu0.20.04.3 [69.8 kB] 435s Get:66 http://ftpmaster.internal/ubuntu focal-proposed/universe armhf postgresql-pltcl-12 armhf 12.22-0ubuntu0.20.04.3 [29.0 kB] 435s Get:67 http://ftpmaster.internal/ubuntu focal-updates/universe armhf postgresql-all all 12+214ubuntu0.1 [1924 B] 436s Preconfiguring packages ... 436s Fetched 116 MB in 4s (28.0 MB/s) 436s Selecting previously unselected package binfmt-support. 436s (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 ... 56540 files and directories currently installed.) 436s Preparing to unpack .../00-binfmt-support_2.2.0-2_armhf.deb ... 436s Unpacking binfmt-support (2.2.0-2) ... 436s Selecting previously unselected package libc-dev-bin. 436s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_armhf.deb ... 436s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 436s Selecting previously unselected package linux-libc-dev:armhf. 436s Preparing to unpack .../02-linux-libc-dev_5.4.0-211.231_armhf.deb ... 436s Unpacking linux-libc-dev:armhf (5.4.0-211.231) ... 436s Selecting previously unselected package libcrypt-dev:armhf. 436s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_armhf.deb ... 436s Unpacking libcrypt-dev:armhf (1:4.4.10-10ubuntu4) ... 436s Selecting previously unselected package libc6-dev:armhf. 437s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_armhf.deb ... 437s Unpacking libc6-dev:armhf (2.31-0ubuntu9.17) ... 437s Selecting previously unselected package gcc-9-base:armhf. 437s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 437s Unpacking gcc-9-base:armhf (9.4.0-1ubuntu1~20.04.2) ... 437s Selecting previously unselected package libisl22:armhf. 437s Preparing to unpack .../06-libisl22_0.22.1-1_armhf.deb ... 437s Unpacking libisl22:armhf (0.22.1-1) ... 437s Selecting previously unselected package libmpc3:armhf. 437s Preparing to unpack .../07-libmpc3_1.1.0-1_armhf.deb ... 437s Unpacking libmpc3:armhf (1.1.0-1) ... 437s Selecting previously unselected package cpp-9. 437s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 437s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 438s Selecting previously unselected package cpp. 438s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_armhf.deb ... 438s Unpacking cpp (4:9.3.0-1ubuntu2) ... 438s Selecting previously unselected package libcc1-0:armhf. 438s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_armhf.deb ... 438s Unpacking libcc1-0:armhf (10.5.0-1ubuntu1~20.04) ... 438s Selecting previously unselected package libgomp1:armhf. 438s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_armhf.deb ... 438s Unpacking libgomp1:armhf (10.5.0-1ubuntu1~20.04) ... 438s Selecting previously unselected package libatomic1:armhf. 438s Preparing to unpack .../12-libatomic1_10.5.0-1ubuntu1~20.04_armhf.deb ... 438s Unpacking libatomic1:armhf (10.5.0-1ubuntu1~20.04) ... 438s Selecting previously unselected package libasan5:armhf. 438s Preparing to unpack .../13-libasan5_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 438s Unpacking libasan5:armhf (9.4.0-1ubuntu1~20.04.2) ... 438s Selecting previously unselected package libubsan1:armhf. 438s Preparing to unpack .../14-libubsan1_10.5.0-1ubuntu1~20.04_armhf.deb ... 438s Unpacking libubsan1:armhf (10.5.0-1ubuntu1~20.04) ... 438s Selecting previously unselected package libgcc-9-dev:armhf. 438s Preparing to unpack .../15-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 438s Unpacking libgcc-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 438s Selecting previously unselected package gcc-9. 438s Preparing to unpack .../16-gcc-9_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 438s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 439s Selecting previously unselected package gcc. 439s Preparing to unpack .../17-gcc_4%3a9.3.0-1ubuntu2_armhf.deb ... 439s Unpacking gcc (4:9.3.0-1ubuntu2) ... 439s Selecting previously unselected package libstdc++-9-dev:armhf. 439s Preparing to unpack .../18-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 439s Unpacking libstdc++-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 439s Selecting previously unselected package g++-9. 439s Preparing to unpack .../19-g++-9_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 439s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 440s Selecting previously unselected package g++. 440s Preparing to unpack .../20-g++_4%3a9.3.0-1ubuntu2_armhf.deb ... 440s Unpacking g++ (4:9.3.0-1ubuntu2) ... 440s Selecting previously unselected package build-essential. 440s Preparing to unpack .../21-build-essential_12.8ubuntu1.1_armhf.deb ... 440s Unpacking build-essential (12.8ubuntu1.1) ... 440s Selecting previously unselected package libllvm10:armhf. 440s Preparing to unpack .../22-libllvm10_1%3a10.0.0-4ubuntu1_armhf.deb ... 440s Unpacking libllvm10:armhf (1:10.0.0-4ubuntu1) ... 441s Selecting previously unselected package libclang-cpp10. 441s Preparing to unpack .../23-libclang-cpp10_1%3a10.0.0-4ubuntu1_armhf.deb ... 441s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 442s Selecting previously unselected package libgc1c2:armhf. 442s Preparing to unpack .../24-libgc1c2_1%3a7.6.4-0.4ubuntu1_armhf.deb ... 442s Unpacking libgc1c2:armhf (1:7.6.4-0.4ubuntu1) ... 442s Selecting previously unselected package libobjc4:armhf. 442s Preparing to unpack .../25-libobjc4_10.5.0-1ubuntu1~20.04_armhf.deb ... 442s Unpacking libobjc4:armhf (10.5.0-1ubuntu1~20.04) ... 442s Selecting previously unselected package libobjc-9-dev:armhf. 442s Preparing to unpack .../26-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_armhf.deb ... 442s Unpacking libobjc-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 442s Selecting previously unselected package libclang-common-10-dev. 442s Preparing to unpack .../27-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_armhf.deb ... 442s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 443s Selecting previously unselected package libclang1-10. 443s Preparing to unpack .../28-libclang1-10_1%3a10.0.0-4ubuntu1_armhf.deb ... 443s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 443s Selecting previously unselected package clang-10. 443s Preparing to unpack .../29-clang-10_1%3a10.0.0-4ubuntu1_armhf.deb ... 443s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 443s Selecting previously unselected package emacsen-common. 443s Preparing to unpack .../30-emacsen-common_3.0.4_all.deb ... 443s Unpacking emacsen-common (3.0.4) ... 443s Selecting previously unselected package dictionaries-common. 443s Preparing to unpack .../31-dictionaries-common_1.28.1_all.deb ... 444s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 444s Unpacking dictionaries-common (1.28.1) ... 444s Selecting previously unselected package libfakeroot:armhf. 444s Preparing to unpack .../32-libfakeroot_1.24-1_armhf.deb ... 444s Unpacking libfakeroot:armhf (1.24-1) ... 444s Selecting previously unselected package fakeroot. 444s Preparing to unpack .../33-fakeroot_1.24-1_armhf.deb ... 444s Unpacking fakeroot (1.24-1) ... 444s Selecting previously unselected package hunspell-en-us. 444s Preparing to unpack .../34-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 444s Unpacking hunspell-en-us (1:2018.04.16-1) ... 444s Selecting previously unselected package libpgtypes3:armhf. 444s Preparing to unpack .../35-libpgtypes3_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libpgtypes3:armhf (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libpq5:armhf. 444s Preparing to unpack .../36-libpq5_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libpq5:armhf (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libecpg6:armhf. 444s Preparing to unpack .../37-libecpg6_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libecpg6:armhf (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libecpg-compat3:armhf. 444s Preparing to unpack .../38-libecpg-compat3_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libecpg-compat3:armhf (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libpq-dev. 444s Preparing to unpack .../39-libpq-dev_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libecpg-dev. 444s Preparing to unpack .../40-libecpg-dev_12.22-0ubuntu0.20.04.3_armhf.deb ... 444s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 444s Selecting previously unselected package libncurses-dev:armhf. 444s Preparing to unpack .../41-libncurses-dev_6.2-0ubuntu2.1_armhf.deb ... 444s Unpacking libncurses-dev:armhf (6.2-0ubuntu2.1) ... 444s Selecting previously unselected package libpython3.8:armhf. 444s Preparing to unpack .../42-libpython3.8_3.8.10-0ubuntu1~20.04.18_armhf.deb ... 444s Unpacking libpython3.8:armhf (3.8.10-0ubuntu1~20.04.18) ... 444s Selecting previously unselected package libtcl8.6:armhf. 444s Preparing to unpack .../43-libtcl8.6_8.6.10+dfsg-1_armhf.deb ... 444s Unpacking libtcl8.6:armhf (8.6.10+dfsg-1) ... 445s Selecting previously unselected package libtinfo-dev:armhf. 445s Preparing to unpack .../44-libtinfo-dev_6.2-0ubuntu2.1_armhf.deb ... 445s Unpacking libtinfo-dev:armhf (6.2-0ubuntu2.1) ... 445s Selecting previously unselected package libxslt1.1:armhf. 445s Preparing to unpack .../45-libxslt1.1_1.1.34-4ubuntu0.20.04.3_armhf.deb ... 445s Unpacking libxslt1.1:armhf (1.1.34-4ubuntu0.20.04.3) ... 445s Selecting previously unselected package llvm-10-runtime. 445s Preparing to unpack .../46-llvm-10-runtime_1%3a10.0.0-4ubuntu1_armhf.deb ... 445s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 445s Selecting previously unselected package libpfm4:armhf. 445s Preparing to unpack .../47-libpfm4_4.10.1+git20-g7700f49-2_armhf.deb ... 445s Unpacking libpfm4:armhf (4.10.1+git20-g7700f49-2) ... 445s Selecting previously unselected package llvm-10. 445s Preparing to unpack .../48-llvm-10_1%3a10.0.0-4ubuntu1_armhf.deb ... 445s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 445s Selecting previously unselected package libffi-dev:armhf. 445s Preparing to unpack .../49-libffi-dev_3.3-4_armhf.deb ... 445s Unpacking libffi-dev:armhf (3.3-4) ... 445s Selecting previously unselected package python3-pygments. 445s Preparing to unpack .../50-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 445s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 445s Selecting previously unselected package llvm-10-tools. 445s Preparing to unpack .../51-llvm-10-tools_1%3a10.0.0-4ubuntu1_armhf.deb ... 445s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 445s Selecting previously unselected package libz3-4:armhf. 445s Preparing to unpack .../52-libz3-4_4.8.7-4build1_armhf.deb ... 445s Unpacking libz3-4:armhf (4.8.7-4build1) ... 446s Selecting previously unselected package libz3-dev:armhf. 446s Preparing to unpack .../53-libz3-dev_4.8.7-4build1_armhf.deb ... 446s Unpacking libz3-dev:armhf (4.8.7-4build1) ... 446s Selecting previously unselected package llvm-10-dev. 446s Preparing to unpack .../54-llvm-10-dev_1%3a10.0.0-4ubuntu1_armhf.deb ... 446s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 449s Selecting previously unselected package net-tools. 449s Preparing to unpack .../55-net-tools_1.60+git20180626.aebd88e-1ubuntu1_armhf.deb ... 449s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 449s Selecting previously unselected package postgresql-client-common. 449s Preparing to unpack .../56-postgresql-client-common_214ubuntu0.1_all.deb ... 449s Unpacking postgresql-client-common (214ubuntu0.1) ... 449s Selecting previously unselected package postgresql-client-12. 449s Preparing to unpack .../57-postgresql-client-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 449s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 449s Selecting previously unselected package ssl-cert. 449s Preparing to unpack .../58-ssl-cert_1.0.39_all.deb ... 449s Unpacking ssl-cert (1.0.39) ... 449s Selecting previously unselected package postgresql-common. 449s Preparing to unpack .../59-postgresql-common_214ubuntu0.1_all.deb ... 449s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 449s Unpacking postgresql-common (214ubuntu0.1) ... 449s Selecting previously unselected package postgresql-12. 449s Preparing to unpack .../60-postgresql-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 449s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 450s Selecting previously unselected package postgresql-server-dev-12. 450s Preparing to unpack .../61-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 450s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 451s Selecting previously unselected package postgresql-server-dev-all. 451s Preparing to unpack .../62-postgresql-server-dev-all_214ubuntu0.1_all.deb ... 451s Unpacking postgresql-server-dev-all (214ubuntu0.1) ... 451s Selecting previously unselected package postgresql-plperl-12. 451s Preparing to unpack .../63-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 451s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 451s Selecting previously unselected package postgresql-plpython3-12. 451s Preparing to unpack .../64-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 451s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 451s Selecting previously unselected package postgresql-pltcl-12. 451s Preparing to unpack .../65-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_armhf.deb ... 451s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 451s Selecting previously unselected package postgresql-all. 451s Preparing to unpack .../66-postgresql-all_12+214ubuntu0.1_all.deb ... 451s Unpacking postgresql-all (12+214ubuntu0.1) ... 451s Setting up postgresql-client-common (214ubuntu0.1) ... 451s Setting up libpgtypes3:armhf (12.22-0ubuntu0.20.04.3) ... 451s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 451s Setting up libgc1c2:armhf (1:7.6.4-0.4ubuntu1) ... 451s Setting up libpq5:armhf (12.22-0ubuntu0.20.04.3) ... 451s Setting up linux-libc-dev:armhf (5.4.0-211.231) ... 451s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 451s Setting up libobjc4:armhf (10.5.0-1ubuntu1~20.04) ... 451s Setting up libgomp1:armhf (10.5.0-1ubuntu1~20.04) ... 451s Setting up libffi-dev:armhf (3.3-4) ... 451s Setting up libfakeroot:armhf (1.24-1) ... 451s Setting up libllvm10:armhf (1:10.0.0-4ubuntu1) ... 451s Setting up fakeroot (1.24-1) ... 451s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 451s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 452s Setting up libz3-4:armhf (4.8.7-4build1) ... 452s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 453s 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 453s Setting up libpfm4:armhf (4.10.1+git20-g7700f49-2) ... 453s Setting up emacsen-common (3.0.4) ... 453s Setting up ssl-cert (1.0.39) ... 455s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 455s Setting up libpython3.8:armhf (3.8.10-0ubuntu1~20.04.18) ... 455s Setting up postgresql-common (214ubuntu0.1) ... 455s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 456s Adding user postgres to group ssl-cert 456s 456s Creating config file /etc/postgresql-common/createcluster.conf with new version 456s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 456s en_us 456s Removing obsolete dictionary files: 456s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 457s Setting up libmpc3:armhf (1.1.0-1) ... 457s Setting up libatomic1:armhf (10.5.0-1ubuntu1~20.04) ... 457s Setting up libtcl8.6:armhf (8.6.10+dfsg-1) ... 457s Setting up binfmt-support (2.2.0-2) ... 457s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 458s Setting up libubsan1:armhf (10.5.0-1ubuntu1~20.04) ... 458s Setting up libcrypt-dev:armhf (1:4.4.10-10ubuntu4) ... 458s Setting up libxslt1.1:armhf (1.1.34-4ubuntu0.20.04.3) ... 458s Setting up libecpg6:armhf (12.22-0ubuntu0.20.04.3) ... 458s Setting up libisl22:armhf (0.22.1-1) ... 458s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 458s Creating new PostgreSQL cluster 12/main ... 458s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 458s The files belonging to this database system will be owned by user "postgres". 458s This user must also own the server process. 458s 458s The database cluster will be initialized with locale "C.UTF-8". 458s The default database encoding has accordingly been set to "UTF8". 458s The default text search configuration will be set to "english". 458s 458s Data page checksums are disabled. 458s 458s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 458s creating subdirectories ... ok 458s selecting dynamic shared memory implementation ... posix 459s selecting default max_connections ... 100 459s selecting default shared_buffers ... 128MB 459s selecting default time zone ... Etc/UTC 459s creating configuration files ... ok 459s running bootstrap script ... ok 459s performing post-bootstrap initialization ... ok 460s syncing data to disk ... ok 460s 460s Success. You can now start the database server using: 460s 460s pg_ctlcluster 12 main start 460s 460s Ver Cluster Port Status Owner Data directory Log file 460s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 460s 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 463s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 463s Setting up libcc1-0:armhf (10.5.0-1ubuntu1~20.04) ... 463s Setting up gcc-9-base:armhf (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 463s Setting up libz3-dev:armhf (4.8.7-4build1) ... 463s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 463s Setting up libecpg-compat3:armhf (12.22-0ubuntu0.20.04.3) ... 463s Setting up dictionaries-common (1.28.1) ... 463s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 463s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 463s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 463s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 463s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 463s Setting up libasan5:armhf (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 463s Setting up hunspell-en-us (1:2018.04.16-1) ... 463s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up libc6-dev:armhf (2.31-0ubuntu9.17) ... 463s Setting up libncurses-dev:armhf (6.2-0ubuntu2.1) ... 463s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 463s Setting up libgcc-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 463s Setting up libobjc-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up cpp (4:9.3.0-1ubuntu2) ... 463s Setting up libtinfo-dev:armhf (6.2-0ubuntu2.1) ... 463s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up libstdc++-9-dev:armhf (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up gcc (4:9.3.0-1ubuntu2) ... 463s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 463s Setting up g++ (4:9.3.0-1ubuntu2) ... 463s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 463s Setting up build-essential (12.8ubuntu1.1) ... 463s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 463s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 463s Setting up postgresql-server-dev-all (214ubuntu0.1) ... 463s Setting up postgresql-all (12+214ubuntu0.1) ... 463s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 464s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 464s Processing triggers for systemd (245.4-4ubuntu3.24) ... 464s Processing triggers for man-db (2.9.1-1) ... 468s Processing triggers for dictionaries-common (1.28.1) ... 481s autopkgtest [03:40:03]: test run-testsuite: [----------------------- 483s Generating locales (this might take a while)... 486s en_US.UTF-8... done 486s ru_RU.ISO-8859-5... done 489s ru_RU.UTF-8... done 489s Generation complete. 490s ====== Running all tests with umask 077 ======= 490s === Running test 001_packages.t ... === 490s 1..18 490s # PostgreSQL versions installed: 12 490s ok 1 - postgresql-12 installed 490s ok 2 # skip No python2 support 490s ok 3 - postgresql-plpython3-12 installed 490s ok 4 - postgresql-plperl-12 installed 490s ok 5 - postgresql-pltcl-12 installed 490s ok 6 - postgresql-server-dev-12 installed 490s ok 7 # skip No postgresql-contrib-12 package for version 12 490s ok 8 - libecpg-dev installed 490s ok 9 - procps installed 490s ok 10 - netcat-openbsd installed 490s ok 11 - hunspell-en-us installed 490s ok 12 - system has a default UTF-8 locale 490s ok 13 - locale ru_RU exists 490s ok 14 - locale ru_RU.UTF-8 exists 490s ok 15 - user postgres in the UNIX group ssl-cert 490s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 490s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 490s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 490s === Running test 002_existing_clusters.t ... === 490s 1..8 490s ok 1 - Cleanup: No clusters left behind 490s ok 2 - No postgres processes left behind 490s ok 3 - No files in /etc/postgresql left behind 490s ok 4 - No files in /var/lib/postgresql left behind 490s ok 5 - No files in /var/run/postgresql left behind 490s ok 6 - No files in /var/log/postgresql left behind 490s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 490s ok 8 - PostgreSQL TCP ports are closed 490s === Running test 003_package_checks.t ... === 490s 1..4 490s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 490s ok 2 - psql is linked against libedit 490s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 490s ok 4 - psql is not linked against libreadline 490s === Running test 005_PgCommon.t ... === 490s 1..24 490s ok 1 - correctly parsed line 'local all postgres ident sameuser' 490s ok 2 - correctly parsed line 'local foo nobody trust' 490s ok 3 - correctly parsed line 'local foo nobody crypt' 490s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 490s ok 5 - correctly parsed line 'local foo,bar nobody ident' 490s ok 6 - correctly parsed line 'local all +foogrp password' 490s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 490s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 490s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 490s ok 10 - @expected_records has correct number of entries 490s ok 11 - returned read_pg_hba array has correct number of records 490s ok 12 - line 'foo all all md5' parsed as invalid 490s ok 13 - line 'local all all foo' parsed as invalid 490s ok 14 - line 'host all all foo' parsed as invalid 490s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 490s ok 16 - line 'host all all md5' parsed as invalid 490s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 490s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 490s ok 19 - read_conf_file returns empty dict for nonexisting file 490s ok 20 - read_conf_file() parsing 490s ok 21 - read_conf_file() parsing with include directives 490s ok 22 - set_conf_value 490s ok 23 - disable_conf_value 490s ok 24 - replace_conf_value 490s === Running test 006_next_free_port.t ... === 490s 1..5 490s ok 1 - next_free_port is 5432 491s ok 2 - next_free_port detects localhost ipv4 socket 492s ok 3 - next_free_port detects wildcard ipv4 socket 492s ok 4 - next_free_port detects localhost ipv6 socket 493s ok 5 - next_free_port detects wildcard ipv6 socket 493s === Running test 007_pg_conftool.t ... === 493s 1..41 493s # test without cluster 493s ok 1 - pg_conftool show all 493s ok 2 - correct output of pg_conftool show all 493s ok 3 - pg_conftool foo.conf show all 493s ok 4 - correct output of pg_conftool foo.conf show all 493s ok 5 - pg_conftool /tmp/0kpibjYzfe/different.conf show all 493s ok 6 - correct output of pg_conftool /tmp/0kpibjYzfe/different.conf show all 493s ok 7 - pg_conftool 9.7 main show all 493s ok 8 - correct output of pg_conftool 9.7 main show all 493s # test show 493s ok 9 - pg_conftool show all 493s ok 10 - correct output of pg_conftool show all 493s ok 11 - pg_conftool other.conf show all 493s ok 12 - correct output of pg_conftool other.conf show all 493s ok 13 - pg_conftool /tmp/0kpibjYzfe/different.conf show all 493s ok 14 - correct output of pg_conftool /tmp/0kpibjYzfe/different.conf show all 493s ok 15 - pg_conftool 12 main show all 493s ok 16 - correct output of pg_conftool 12 main show all 493s ok 17 - pg_conftool 12 main other.conf show all 493s ok 18 - correct output of pg_conftool 12 main other.conf show all 493s ok 19 - pg_conftool show a 493s ok 20 - correct output of pg_conftool show a 493s ok 21 - pg_conftool -s show a 493s ok 22 - correct output of pg_conftool -s show a 493s # test set 493s ok 23 - pg_conftool set c 7 493s ok 24 - correct output of pg_conftool set c 7 493s ok 25 - file contains new setting 493s ok 26 - pg_conftool set a 8 493s ok 27 - correct output of pg_conftool set a 8 493s ok 28 - file contains updated setting 494s ok 29 - pg_conftool /tmp/0kpibjYzfe/different.conf set a 9 494s ok 30 - correct output of pg_conftool /tmp/0kpibjYzfe/different.conf set a 9 494s ok 31 - file with path contains updated setting 494s # test remove 494s ok 32 - pg_conftool remove a 494s ok 33 - correct output of pg_conftool remove a 494s ok 34 - setting removed from file 494s ok 35 - pg_conftool /tmp/0kpibjYzfe/different.conf remove a 494s ok 36 - correct output of pg_conftool /tmp/0kpibjYzfe/different.conf remove a 494s ok 37 - setting removed from file with path 494s # test edit 494s ok 38 - pg_conftool edit 494s ok 39 - correct output of pg_conftool edit 494s ok 40 - pg_conftool /tmp/0kpibjYzfe/different.conf edit 494s ok 41 - correct output of pg_conftool /tmp/0kpibjYzfe/different.conf edit 494s === Running test 010_defaultport_cluster.t ... === 494s 1..14 494s ok 1 - psql --version 494s ok 2 - pg_wrapper selects highest available version number 494s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 494s ok 4 - connecting to localhost fails with no clusters 494s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 494s ok 6 - pg_wrapper uses host and port from PGCLUSTER 494s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 494s ok 8 - pg_wrapper uses --cluster from the command line 494s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 494s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 494s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 494s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 494s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 494s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 494s === Running test 015_start_stop.t ... === 494s 1..71 494s # We are running systemd 494s # Running tests for 12 494s # Cluster does not exist yet 494s ok 1 - cluster 12 main does not exist 494s ok 2 - service postgresql@12-main does not exist 495s ok 3 - systemctl start postgresql 495s ok 4 - cluster 12 main does not exist 495s ok 5 - service postgresql@12-main does not exist 495s ok 6 - systemctl start postgresql@12-main 495s ok 7 - cluster 12 main does not exist 495s ok 8 - service postgresql@12-main does not exist 495s # Start/stop postgresql using system tools 496s ok 9 - pg_createcluster 12 main 496s ok 10 - cluster 12 main is stopped 496s ok 11 - service postgresql@12-main is stopped 498s ok 12 - systemctl start postgresql 498s ok 13 - cluster 12 main is running 498s ok 14 - service postgresql@12-main is running 498s ok 15 - systemctl start postgresql 498s ok 16 - cluster 12 main is already running 498s ok 17 - service postgresql@12-main is already running 498s ok 18 - systemctl stop postgresql 504s ok 19 - cluster 12 main is stopped 505s ok 20 - service postgresql@12-main is stopped 505s ok 21 - systemctl stop postgresql 505s ok 22 - cluster 12 main is already stopped 505s ok 23 - service postgresql@12-main is already stopped 505s # Start/stop specific cluster using system tools 507s ok 24 - systemctl start postgresql@12-main 507s ok 25 - cluster 12 main is running 507s ok 26 - service postgresql@12-main is running 507s ok 27 - systemctl start postgresql@12-main 507s ok 28 - cluster 12 main is running 507s ok 29 - service postgresql@12-main is running 509s ok 30 - systemctl restart postgresql@12-main 510s ok 31 - cluster 12 main is running 510s ok 32 - service postgresql@12-main is running 510s ok 33 - systemctl stop postgresql@12-main 510s ok 34 - cluster 12 main is stopped 510s ok 35 - service postgresql@12-main is stopped 510s ok 36 - systemctl stop postgresql@12-main 510s ok 37 - cluster 12 main is already stopped 510s ok 38 - service postgresql@12-main is already stopped 511s ok 39 - pg_dropcluster 12 main 511s ok 40 - cluster 12 main does not exist 511s ok 41 - service postgresql@12-main does not exist 511s # Start/stop specific cluster using pg_*cluster 511s ok 42 - pg_ctlcluster start 12 main 511s ok 43 - cluster 12 main does not exist 511s ok 44 - service postgresql@12-main does not exist 514s ok 45 - pg_createcluster 12 main --start 514s ok 46 - cluster 12 main is running 514s ok 47 - service postgresql@12-main is running 514s ok 48 - pg_ctlcluster 12 main start 514s ok 49 - cluster 12 main is already running 514s ok 50 - service postgresql@12-main is already running 517s ok 51 - pg_ctlcluster 12-main restart 517s ok 52 - cluster 12 main is running 517s ok 53 - service postgresql@12-main is running 517s ok 54 - pg_ctlcluster 12 main stop 517s ok 55 - cluster 12 main is stopped 517s ok 56 - service postgresql@12-main is stopped 517s ok 57 - pg_ctlcluster 12 main stop 517s ok 58 - cluster 12 main is already stopped 517s ok 59 - service postgresql@12-main is already stopped 519s ok 60 - pg_ctlcluster start 12-main 520s ok 61 - cluster 12 main is running 520s ok 62 - service postgresql@12-main is running 520s ok 63 - pg_dropcluster 12 main --stop 520s ok 64 - Cleanup: No clusters left behind 520s ok 65 - No postgres processes left behind 520s ok 66 - No files in /etc/postgresql left behind 520s ok 67 - No files in /var/lib/postgresql left behind 520s ok 68 - No files in /var/run/postgresql left behind 520s ok 69 - No files in /var/log/postgresql left behind 520s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 520s ok 71 - PostgreSQL TCP ports are closed 520s === Running test 020_create_sql_remove.t ... === 520s 1..144 520s # Running tests for 12 524s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.Qav75o 524s ok 2 - pg_createcluster 12 main 524s ok 3 - Socket and pid file are in /var/run/postgresql/ 524s ok 4 - xlog/wal directory /tmp/12.xlog.Qav75o was created 524s ok 5 - Exactly one postgres master process running 526s ok 6 - pg_ctlcluster 12 main restart 526s ok 7 - cluster restarts with new environment file 526s ok 8 - Exactly one postgres master process running 526s ok 9 - correct value of PGEXTRAVAR1 in environment 526s ok 10 - correct value of PGEXTRAVAR2 in environment 526s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 526s ok 12 - createdb --version 526s ok 13 - pg_wrapper selects version number of cluster 526s ok 14 - psql --version 526s ok 15 - pg_wrapper selects version number of cluster 526s ok 16 - pg_lscluster reports online cluster on port 5432 526s ok 17 - log file is actually used 526s ok 18 - /etc/postgresql is owned by user "postgres" 526s ok 19 - version configuration directory file is owned by user "postgres" 526s ok 20 - configuration directory file is owned by user "postgres" 526s ok 21 - version data directory file is owned by user "postgres" 526s ok 22 - data directory file is owned by user "postgres" 526s ok 23 - log file has 0640 permissions 526s ok 24 - log file is owned by user "postgres" 526s ok 25 - log file is owned by group "adm" 526s ok 26 - no log symlink by default 526s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 526s ok 28 - pg_lsclusters -h 526s ok 29 - correct output of pg_lsclusters -h 527s ok 30 - stopping cluster 529s ok 31 - restarting cluster with nondefault log symlink 529s ok 32 - log target is used as log file 529s ok 33 - default log is not used 529s ok 34 - pg_lsclusters -h 529s ok 35 - correct output of pg_lsclusters -h 529s ok 36 - stopping cluster 531s ok 37 - restarting cluster with explicitly configured log file 531s ok 38 - default log is not used 531s ok 39 - log symlink target is used for startup message 531s ok 40 - exactly one log file 531s ok 41 - custom log is actually used 531s ok 42 - pg_lsclusters -h 531s ok 43 - correct output of pg_lsclusters -h 532s ok 44 - stopping cluster 532s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 532s ok 46 - /etc/postgres-hack was not created 534s ok 47 - restarting cluster 534s ok 48 - ps -o tty -U postgres h 534s ok 49 - postgres processes do not have an associated terminal 534s ok 50 - SSL is enabled 534s ok 51 - psql -l fails for nobody 534s ok 52 - createuser nobody 534s ok 53 - createdb nobodydb 534s ok 54 - psql -ltA succeeds for nobody 534s ok 55 - psql -ltA output 534s ok 56 - SQL command: create table 534s ok 57 - SQL command: insert into table values 534s ok 58 - SQL command: insert into table values 535s ok 59 - primary key violation 535s ok 60 - psql -tAc "select * from phone order by name" nobodydb 535s ok 61 - SQL command output: select -tA 535s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 535s ok 63 - SQL command output: select -tx 535s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 535s ok 65 - SQL command output: select -tAx 535s ok 66 - CREATE EXTENSION plperlu fails for user nobody 535s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 535s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 535s ok 69 - creating PL/PerlU function as user nobody fails 535s ok 70 - creating unsafe PL/Perl function as user postgres fails 535s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 535s ok 72 - creating PL/PerlU function as user postgres succeeds 535s ok 73 - psql nobodydb -Atc "select read_file()" 535s ok 74 - calling PL/PerlU function 535s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 535s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 535s ok 77 - creating unsafe PL/Perl function as user nobody fails 536s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 536s ok 79 - creating PL/Perl function as user nobody succeeds 536s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 536s ok 81 - calling PL/Perl function 536s ok 82 # skip No python2 support 536s ok 83 # skip No python2 support 536s ok 84 # skip No python2 support 536s ok 85 # skip No python2 support 536s ok 86 # skip No python2 support 536s ok 87 # skip No python2 support 536s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 536s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 536s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 536s ok 91 - creating PL/Python3 function as user postgres succeeds 536s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 536s ok 93 - calling PL/Python function 536s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 536s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 536s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 536s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 536s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 536s ok 99 - creating PL/Tcl function as user nobody succeeds 536s 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;" 536s ok 101 - creating PL/TclU function as user postgres succeeds 536s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 536s ok 103 - calling PL/Tcl function 536s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 536s ok 105 - calling PL/TclU function 537s ok 106 - stopping cluster 537s ok 107 - pg_ctlcluster 12 main start 537s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 539s ok 109 - pg_ctlcluster 12 main start 539s ok 110 - cluster restarts with pgdata symlink 539s ok 111 # skip skipping postmaster OOM killer adjustment in container 539s ok 112 - postgres client backend has no OOM adjustment 540s ok 113 - ps h 5758 540s ok 114 - process title is idle 540s ok 115 - ps h 5758 540s ok 116 - process title is idle in transaction 541s ok 117 - ps h 5758 541s ok 118 - process title is SELECT 543s ok 119 - dropdb nobodydb 543s ok 120 - dropuser nobody 543s ok 121 - stopping cluster 545s ok 122 - starting cluster as postgres works without a log file 545s ok 123 - log file got recreated and used 545s ok 124 - creating a directory in spc2 545s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.eWoUVu'" 545s ok 126 - creating tablespace spc1 545s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 545s ok 128 - creating a table in spc1 545s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.hmVJZS'" 545s ok 130 - creating tablespace spc2 545s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 545s ok 132 - creating a table in spc2 546s ok 133 - pg_dropcluster removes cluster 546s ok 134 - xlog/wal directory /tmp/12.xlog.Qav75o was deleted 546s ok 135 - tablespace spc1 was emptied 546s ok 136 - tablespace spc2 was emptied 546s ok 137 - Cleanup: No clusters left behind 546s ok 138 - No postgres processes left behind 546s ok 139 - No files in /etc/postgresql left behind 546s ok 140 - No files in /var/lib/postgresql left behind 546s ok 141 - No files in /var/run/postgresql left behind 546s ok 142 - No files in /var/log/postgresql left behind 546s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 546s ok 144 - PostgreSQL TCP ports are closed 546s === Running test 021_pg_renamecluster.t ... === 546s 1..20 550s ok 1 - pg_createcluster 12 main 552s ok 2 - pg_renamecluster 12 main donau 553s ok 3 - psql -tAc "show data_directory" 553s ok 4 - cluster is running and data_directory was moved 553s ok 5 - pg_hba.conf location updated 553s ok 6 - pg_ident.conf location updated 553s ok 7 - external_pid_file location updated 553s ok 8 - external_pid_file exists 553s ok 9 - stats_temp_directory location updated 553s ok 10 - stats_temp_directory exists 553s ok 11 - cluster_name is updated 553s ok 12 - pg_dropcluster removes cluster 553s ok 13 - Cleanup: No clusters left behind 553s ok 14 - No postgres processes left behind 553s ok 15 - No files in /etc/postgresql left behind 553s ok 16 - No files in /var/lib/postgresql left behind 553s ok 17 - No files in /var/run/postgresql left behind 553s ok 18 - No files in /var/log/postgresql left behind 553s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 553s ok 20 - PostgreSQL TCP ports are closed 553s === Running test 022_recovery.t ... === 553s 1..17 553s # Running tests for 12 557s ok 1 - pg_createcluster 12 main --start >/dev/null 557s ok 2 - pg_ctlcluster 12 main stop -m i 559s ok 3 - pg_ctlcluster 12 main start 560s ok 4 - psql -c '' 560s ok 5 - pg_ctlcluster 12 main stop -m i 560s ok 6 - create write-protected file in data directory 562s ok 7 - pg_ctlcluster 12 main start 562s ok 8 - psql -c '' 563s ok 9 - pg_dropcluster removes cluster 563s ok 10 - Cleanup: No clusters left behind 563s ok 11 - No postgres processes left behind 563s ok 12 - No files in /etc/postgresql left behind 563s ok 13 - No files in /var/lib/postgresql left behind 563s ok 14 - No files in /var/run/postgresql left behind 563s ok 15 - No files in /var/log/postgresql left behind 563s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 563s ok 17 - PostgreSQL TCP ports are closed 563s === Running test 025_logging.t ... === 563s 1..55 563s # Logging to /var/log/syslog works 563s # Running tests for 12 567s ok 1 - pg_createcluster 12 main 567s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 567s ok 3 - psql -qc "'foobar_12_6327'" 567s ok 4 - log an error 567s ok 5 - grep --binary-files=text foobar_12_6327 /var/log/postgresql/postgresql-12-main.log 567s ok 6 - error appears in logfile 567s ok 7 - pg_conftool 12 main set log_destination syslog 567s ok 8 - set log_destination syslog 567s ok 9 - pg_ctlcluster 12 main reload 567s ok 10 - 12 main reload 567s ok 11 - psql -Atc "show log_destination" 567s ok 12 - log_destination is syslog 567s ok 13 - pg_lscluster reports syslog 568s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 568s ok 15 - error appears in /var/log/syslog 568s ok 16 - pg_conftool 12 main set logging_collector on 568s ok 17 - set logging_collector on 568s ok 18 - pg_conftool 12 main set log_destination csvlog 568s ok 19 - set log_destination csvlog 570s ok 20 - pg_ctlcluster 12 main restart 570s ok 21 - 12 main restart 571s ok 22 - psql -Atc "show logging_collector" 571s ok 23 - logging_collector is on 571s ok 24 - psql -Atc "show log_destination" 571s ok 25 - log_destination is csvlog 571s ok 26 - pg_lscluster reports csvlog 571s ok 27 - psql -qc "'barbaz_12_6327'" 571s ok 28 - log an error 571s ok 29 - grep --binary-files=text barbaz_12_6327 /var/lib/postgresql/12/main/log/*.csv 571s ok 30 - error appears in log/*.csv 571s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 571s ok 32 - set log_destination stderr,syslog,csvlog 571s ok 33 - pg_ctlcluster 12 main reload 571s ok 34 - 12 main reload 571s ok 35 - psql -Atc "show log_destination" 571s ok 36 - log_destination is stderr,syslog,csvlog 571s ok 37 - pg_lscluster reports stderr,syslog,csvlog 571s ok 38 - psql -qc "'moo_12_6327'" 571s ok 39 - log an error 571s ok 40 - grep --binary-files=text moo_12_6327 /var/lib/postgresql/12/main/log/*.log 571s ok 41 - error appears in log/*.log 572s ok 42 - grep --binary-files=text 'postgres.*moo_12_6327' /var/log/syslog 572s ok 43 - error appears in /var/log/syslog 572s ok 44 - grep --binary-files=text moo_12_6327 /var/lib/postgresql/12/main/log/*.csv 572s ok 45 - error appears in log/*.csv 572s ok 46 - pg_dropcluster 12 main --stop 572s ok 47 - pg_dropcluster removes cluster 572s ok 48 - Cleanup: No clusters left behind 572s ok 49 - No postgres processes left behind 572s ok 50 - No files in /etc/postgresql left behind 572s ok 51 - No files in /var/lib/postgresql left behind 572s ok 52 - No files in /var/run/postgresql left behind 572s ok 53 - No files in /var/log/postgresql left behind 572s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 572s ok 55 - PostgreSQL TCP ports are closed 572s === Running test 030_errors.t ... === 572s 1..149 572s ok 1 - pg_lscluster reports cluster without binaries 572s ok 2 - pg_dropcluster 6.3 main 574s ok 3 - pg_createcluster --socketdir 574s ok 4 - pg_lsclusters -h 574s ok 5 - cluster was created 574s ok 6 - Port of created cluster is 5432 574s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 574s ok 8 - pg_createcluster on existing cluster 574s ok 9 - pg_lsclusters -h 574s ok 10 - original cluster still exists 574s ok 11 - pg_createcluster 12 test -p foo 574s ok 12 - pg_createcluster -p checks that port option is numeric 574s ok 13 - pg_createcluster 12 test -p 42 574s ok 14 - pg_createcluster -p checks valid port range 574s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 574s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 574s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 576s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 576s ok 19 - No sockets in /var/run/postgresql 576s ok 20 - Socket is in /tmp/postgresql-testsuite/ 577s ok 21 - cluster stops with custom unix_socket_dir 577s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 579s ok 23 - cluster starts after removing unix_socket_dir 579s ok 24 - Socket is in default dir /var/run/postgresql 579s ok 25 - No sockets in /tmp/postgresql-testsuite/ 579s ok 26 - pg_ctlcluster 12 main stop 579s ok 27 - pg_ctlcluster fails with corrupted PID file 579s ok 28 - pg_lsclusters -h 579s ok 29 - cluster is still online 579s ok 30 - pg_ctlcluster succeeds with restored PID file 579s ok 31 - pg_lsclusters -h 579s ok 32 - cluster is down 579s ok 33 - pg_ctlcluster 12 main stop 579s ok 34 - pg_ctlcluster stop fails on stopped cluster 582s ok 35 - pg_ctlcluster 12 main start 582s ok 36 - pg_ctlcluster succeeds with already existing PID file 582s ok 37 - pg_lsclusters -h 582s ok 38 - cluster is online 582s ok 39 - pg_ctlcluster stop succeeds 582s ok 40 - pg_lsclusters -h 582s ok 41 - cluster is down 582s ok 42 - no pid file left 582s ok 43 - pg_ctlcluster 12 main stop 582s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 582s ok 45 - pid file was cleaned up 582s ok 46 - pg_ctlcluster --force 12 main stop 582s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 582s ok 48 - pid file was cleaned up 582s ok 49 - pg_ctlcluster 12 main stop 582s ok 50 - pg_ctlcluster stop succeeds with stale PID file 582s ok 51 - pid file was cleaned up 582s ok 52 - pg_ctlcluster --force 12 main stop 582s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 582s ok 54 - pid file was cleaned up 582s ok 55 - pg_ctlcluster --force 12 main stop 582s ok 56 - pg_ctlcluster stop succeeds with empty PID file 582s ok 57 - pid file was cleaned up 584s ok 58 - pg_ctlcluster 12 main start 584s ok 59 - pg_ctlcluster succeeds with corrupted PID file 584s ok 60 - pg_lsclusters -h 584s ok 61 - cluster is online 584s ok 62 - pg_ctlcluster 12 main start 584s ok 63 - pg_ctlcluster start fails on running cluster 585s ok 64 - pg_ctlcluster stop 585s ok 65 - pg_ctlcluster 12 main start 585s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 585s ok 67 - pg_ctlcluster 12 main stop 585s ok 68 - stopping cluster 591s ok 69 - pg_ctlcluster 12 main start 591s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 591s ok 71 - pg_ctlcluster 12 main stop 591s ok 72 - stopping cluster 591s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 592s ok 74 - pg_dropcluster 12 main 592s ok 75 - pg_dropcluster works as user postgres 593s ok 76 - pg_createcluster succeeds 593s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 593s ok 78 - proper error message for nonexisting /var/lib/postgresql 595s ok 79 - pg_ctlcluster 12 main start 595s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 595s ok 81 - pg_ctlcluster 12 main stop 595s ok 82 - stopping cluster 596s ok 83 - pg_createcluster other 599s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 601s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 601s ok 86 601s ok 87 - pg_ctlcluster 12 other start 601s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 601s ok 89 - pg_ctlcluster 12 main stop 601s ok 90 - stopping main cluster 604s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 604s ok 92 - pg_dropcluster other 604s ok 93 - pg_dropcluster 604s ok 94 - No sockets any more 604s ok 95 - 'pg_lsclusters 4.5 foo' fails 604s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 604s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 604s ok 98 - 'psql --cluster 4.5/foo' fails 604s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 604s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 604s ok 101 - 'psql --cluster 12/foo' fails 604s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 604s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 605s ok 104 - 'pg_dropcluster 4.5 foo' fails 605s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 605s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 605s ok 107 - 'pg_dropcluster 12 foo' fails 605s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 605s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 605s ok 110 - 'pg_upgradecluster 4.5 foo' fails 605s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 605s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 605s ok 113 - 'pg_upgradecluster 12 foo' fails 605s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 605s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 605s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 605s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 605s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 605s ok 119 - 'pg_ctlcluster 12 foo stop' fails 605s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 605s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 605s ok 122 - Cleanup: No clusters left behind 605s ok 123 - No postgres processes left behind 605s ok 124 - No files in /etc/postgresql left behind 605s ok 125 - No files in /var/lib/postgresql left behind 605s ok 126 - No files in /var/run/postgresql left behind 605s ok 127 - No files in /var/log/postgresql left behind 605s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 605s ok 129 - PostgreSQL TCP ports are closed 605s ok 130 - pg_dropcluster 12 broken 605s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 605s ok 132 - Cleanup: No clusters left behind 605s ok 133 - No postgres processes left behind 605s ok 134 - No files in /etc/postgresql left behind 605s ok 135 - No files in /var/lib/postgresql left behind 605s ok 136 - No files in /var/run/postgresql left behind 605s ok 137 - No files in /var/log/postgresql left behind 605s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 605s ok 139 - PostgreSQL TCP ports are closed 605s ok 140 - pg_dropcluster 12 broken 605s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 605s ok 142 - Cleanup: No clusters left behind 605s ok 143 - No postgres processes left behind 605s ok 144 - No files in /etc/postgresql left behind 605s ok 145 - No files in /var/lib/postgresql left behind 605s ok 146 - No files in /var/run/postgresql left behind 605s ok 147 - No files in /var/log/postgresql left behind 605s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 605s ok 149 - PostgreSQL TCP ports are closed 605s === Running test 031_errors_disk_full.t ... === 605s 1..22 605s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 606s ok 1 - script failed 606s ok 2 - pg_createcluster fails due to insufficient disk space 606s ok 3 - does not leave files behind 606s ok 4 - Cleanup: No clusters left behind 606s ok 5 - No postgres processes left behind 606s ok 6 - No files in /etc/postgresql left behind 606s ok 7 - No files in /var/lib/postgresql left behind 606s ok 8 - No files in /var/run/postgresql left behind 606s ok 9 - No files in /var/log/postgresql left behind 606s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 606s ok 11 - PostgreSQL TCP ports are closed 606s # check disk full conditions on startup 608s ok 12 - script failed 608s ok 13 - pg_ctlcluster prints error message 608s ok 14 - log file has error message 608s ok 15 - Cleanup: No clusters left behind 608s ok 16 - No postgres processes left behind 608s ok 17 - No files in /etc/postgresql left behind 608s ok 18 - No files in /var/lib/postgresql left behind 608s ok 19 - No files in /var/run/postgresql left behind 608s ok 20 - No files in /var/log/postgresql left behind 608s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 608s ok 22 - PostgreSQL TCP ports are closed 608s === Running test 032_ssl_key_permissions.t ... === 608s 1..22 608s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 608s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 608s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 608s # 12 (12.22-0ubuntu0.20.04.3) 609s ok 4 - pg_createcluster 12 main 609s ok 5 - pg_ctlcluster 12 main start 609s ok 6 - ssl key owned by nobody refused 609s ok 7 - pg_ctlcluster 12 main start 609s ok 8 - ssl key with permissions root:root 0644 refused 610s ok 9 - pg_ctlcluster 12 main start 610s ok 10 - ssl key with permissions postgres:postgres 0640 refused 610s ok 11 - pg_dropcluster 12 main --stop 610s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 610s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 610s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 610s ok 15 - Cleanup: No clusters left behind 610s ok 16 - No postgres processes left behind 610s ok 17 - No files in /etc/postgresql left behind 610s ok 18 - No files in /var/lib/postgresql left behind 610s ok 19 - No files in /var/run/postgresql left behind 610s ok 20 - No files in /var/log/postgresql left behind 610s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 610s ok 22 - PostgreSQL TCP ports are closed 610s === Running test 040_upgrade.t ... === 610s 1..1 610s ok 1 - only one major version installed, skipping upgrade tests 610s === Running test 041_upgrade_custompaths.t ... === 610s 1..1 610s ok 1 - only one major version installed, skipping upgrade tests 610s === Running test 043_upgrade_ssl_cert.t ... === 610s 1..1 610s ok 1 - only one major version installed, skipping upgrade tests 610s === Running test 050_encodings.t ... === 610s 1..60 610s # Checking 12 ru_RU 614s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 615s ok 2 - psql -l succeeds 615s ok 3 - template1 is not UTF-8 encoded 615s ok 4 - creating test database 615s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 615s # create table t (x varchar); copy t from stdin" test 615s ok 6 - creating table with ISO-8859-5 characters 615s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 615s ok 8 - correct string in UTF-8 615s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 615s ok 10 - correct string in ISO-8859-5 615s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 615s # delete from t; copy t from stdin" test 615s ok 12 - creating table with UTF-8 characters 615s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 615s ok 14 - correct string in UTF-8 615s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 615s ok 16 - correct string in ISO-8859-1 616s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 616s ok 18 - Server error message has correct language and encoding 618s ok 19 - pg_ctlcluster 12 ru_RU restart 618s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 619s ok 21 - Dropping cluster 619s # Checking 12 ru_RU.UTF-8 622s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 623s ok 23 - psql -l succeeds 623s ok 24 - template1 is UTF-8 encoded 623s ok 25 - creating test database 623s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 623s # create table t (x varchar); copy t from stdin" test 623s ok 27 - creating table with ISO-8859-5 characters 624s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 624s ok 29 - correct string in UTF-8 624s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 624s ok 31 - correct string in ISO-8859-5 624s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 624s # delete from t; copy t from stdin" test 624s ok 33 - creating table with UTF-8 characters 624s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 624s ok 35 - correct string in UTF-8 624s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 624s ok 37 - correct string in ISO-8859-1 624s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 624s ok 39 - Server error message has correct language and encoding 626s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 626s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 627s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 627s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 627s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 627s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 627s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 627s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 627s ok 48 - Dropping cluster 627s # Check 12 locale environment variables 631s ok 49 - pg_createcluster: LC_ALL dominates LANG 631s ok 50 - psql -Atl --cluster 12/main 631s ok 51 - template1 is ASCII encoded 631s ok 52 - Dropping cluster 631s ok 53 - Cleanup: No clusters left behind 631s ok 54 - No postgres processes left behind 631s ok 55 - No files in /etc/postgresql left behind 631s ok 56 - No files in /var/lib/postgresql left behind 631s ok 57 - No files in /var/run/postgresql left behind 631s ok 58 - No files in /var/log/postgresql left behind 631s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 631s ok 60 - PostgreSQL TCP ports are closed 631s === Running test 052_upgrade_encodings.t ... === 632s 1..1 632s ok 1 - only one major version installed, skipping upgrade tests 632s === Running test 060_obsolete_confparams.t ... === 632s 1..1 632s ok 1 - only one major version installed, skipping upgrade tests 632s === Running test 070_non_postgres_clusters.t ... === 632s 1..40 633s ok 1 - pg_createcluster 12 main for owner nobody 633s ok 2 - pg_ctlcluster 12 main start 633s ok 3 - start refused when config and data owners mismatch 635s ok 4 - pg_ctlcluster succeeds with owner nobody 635s ok 5 - pg_lsclusters -h 635s ok 6 - pg_lsclusters shows running cluster 635s ok 7 - postgres is running as user nobody 635s ok 8 - ls /tmp/.s.PGSQL.* 635s ok 9 - socket is in /tmp 635s ok 10 - /var/run/postgresql is empty 635s ok 11 - conf dir is owned by user 635s ok 12 - conf dir is owned by user's primary group 635s ok 13 - files are owned by user 635s ok 14 - files are owned by user's primary group 635s ok 15 - log file has 0640 permissions 635s ok 16 - log file is owned by user 635s ok 17 - log file is owned by user's primary group 635s ok 18 - only one major version installed, skipping upgrade test 635s ok 19 - ... 635s ok 20 - ... 635s ok 21 - ... 635s ok 22 - ... 635s ok 23 - ... 635s ok 24 - ... 635s ok 25 - ... 635s ok 26 - ... 635s ok 27 - ... 635s ok 28 - ... 636s ok 29 - pg_dropcluster 636s ok 30 - pg_lsclusters -h 636s ok 31 - No clusters left 636s ok 32 - No postgres processes left 636s ok 33 - Cleanup: No clusters left behind 636s ok 34 - No postgres processes left behind 636s ok 35 - No files in /etc/postgresql left behind 636s ok 36 - No files in /var/lib/postgresql left behind 636s ok 37 - No files in /var/run/postgresql left behind 636s ok 38 - No files in /var/log/postgresql left behind 636s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 636s ok 40 - PostgreSQL TCP ports are closed 636s === Running test 080_start.conf.t ... === 636s 1..73 637s ok 1 - pg_createcluster 12 main 637s # start.conf auto 637s ok 2 - get_cluster_start_conf returns auto 637s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 637s ok 4 - start.conf contains auto 637s ok 5 - systemd generator links cluster 637s ok 6 - systemd generator links correct service file 640s ok 7 - /etc/init.d/postgresql start 12 640s ok 8 - correct output of /etc/init.d/postgresql start 12 640s ok 9 - pg_lsclusters -h 640s ok 10 - cluster is online 640s ok 11 - /etc/init.d/postgresql stop 12 640s ok 12 - correct output of /etc/init.d/postgresql stop 12 643s ok 13 - pg_lsclusters -h 643s ok 14 - cluster is down 643s # start.conf manual 643s ok 15 - get_cluster_start_conf returns manual 643s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 643s ok 17 - start.conf contains manual 643s ok 18 - systemd generator doesn't link cluster 643s ok 19 - /etc/init.d/postgresql start 12 643s ok 20 - correct output of /etc/init.d/postgresql start 12 643s ok 21 - pg_lsclusters -h 643s ok 22 - cluster is down 645s ok 23 - pg_ctlcluster 12 main start 645s ok 24 - correct output of pg_ctlcluster 12 main start 645s ok 25 - pg_lsclusters -h 645s ok 26 - cluster is online 646s ok 27 - pg_ctlcluster 12 main stop 646s ok 28 - correct output of pg_ctlcluster 12 main stop 646s ok 29 - pg_lsclusters -h 646s ok 30 - cluster is down 646s # start.conf disabled 646s ok 31 - get_cluster_start_conf returns disabled 646s ok 32 - systemd generator doesn't link cluster 646s ok 33 - /etc/init.d/postgresql start 12 646s ok 34 - correct output of /etc/init.d/postgresql start 12 646s ok 35 - pg_lsclusters -h 646s ok 36 - cluster is down 646s ok 37 - pg_ctlcluster 12 main start 646s ok 38 - correct output of pg_ctlcluster 12 main start 646s ok 39 - pg_lsclusters -h 646s ok 40 - cluster is down 648s ok 41 - pg_ctlcluster 12 main start 648s ok 42 - correct output of pg_ctlcluster 12 main start 648s ok 43 - pg_lsclusters -h 648s ok 44 - cluster is online 648s ok 45 - pg_ctlcluster 12 main stop 648s ok 46 - correct output of pg_ctlcluster 12 main stop 649s ok 47 - pg_lsclusters -h 649s ok 48 - cluster is down 651s ok 49 - pg_ctlcluster 12 main start 651s ok 50 - correct output of pg_ctlcluster 12 main start 651s ok 51 - pg_lsclusters -h 651s ok 52 - cluster is online 651s # test upgrade 651s ok 53 - only one major version installed, skipping upgrade test 651s ok 54 - ... 651s ok 55 - get_cluster_start_conf for old cluster returns manual 651s ok 56 - get_cluster_start_conf for new cluster returns manual 651s ok 57 - ... 651s ok 58 - dropping upgraded cluster 651s ok 59 - pg_lsclusters -h 651s ok 60 - no clusters any more 651s ok 61 - pg_createcluster 12 main --start-conf foo 651s ok 62 - pg_createcluster checks --start-conf validity 652s ok 63 - pg_createcluster checks --start-conf manual 652s ok 64 - get_cluster_start_conf returns manual 652s ok 65 - dropping cluster 652s ok 66 - Cleanup: No clusters left behind 652s ok 67 - No postgres processes left behind 652s ok 68 - No files in /etc/postgresql left behind 652s ok 69 - No files in /var/lib/postgresql left behind 652s ok 70 - No files in /var/run/postgresql left behind 652s ok 71 - No files in /var/log/postgresql left behind 652s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 652s ok 73 - PostgreSQL TCP ports are closed 652s === Running test 085_pg_ctl.conf.t ... === 653s 1..29 654s ok 1 - pg_createcluster 12 main 654s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 656s ok 3 - pg_ctlcluster 12 main start 656s ok 4 - starting cluster 656s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 656s ok 6 - soft core size is 0 656s ok 7 - set pg_ctl default option to -c 658s ok 8 - pg_ctlcluster 12 main restart 658s ok 9 - restarting cluster 658s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 658s ok 11 - soft core size is unlimited 658s ok 12 - restored pg_ctl default option 661s ok 13 - pg_ctlcluster 12 main restart 661s ok 14 - restarting cluster 661s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 661s ok 16 - soft core size is 0 663s ok 17 - pg_ctlcluster 12 main restart -- -c 663s ok 18 - restarting cluster with -c on the command line 663s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 663s ok 20 - soft core size is unlimited 664s ok 21 - dropping cluster 664s ok 22 - Cleanup: No clusters left behind 664s ok 23 - No postgres processes left behind 664s ok 24 - No files in /etc/postgresql left behind 664s ok 25 - No files in /var/lib/postgresql left behind 664s ok 26 - No files in /var/run/postgresql left behind 664s ok 27 - No files in /var/log/postgresql left behind 664s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 664s ok 29 - PostgreSQL TCP ports are closed 664s === Running test 090_multicluster.t ... === 664s 1..125 665s ok 1 - pg_createcluster 12 old 666s ok 2 - pg_createcluster 12 new1 668s ok 3 - pg_createcluster 12 new2 670s ok 4 - starting cluster 12/old 672s ok 5 - starting cluster 12/new1 675s ok 6 - starting cluster 12/new2 675s ok 7 - pg_lsclusters -h | sort -k3 675s ok 8 - clusters have the correct ports, skipping used 5433 675s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 675s ok 10 - createdb --version 675s ok 11 - pg_wrapper selects port 5432 as default cluster 675s ok 12 - createdb --cluster 12/new1 --version 675s ok 13 - pg_wrapper --cluster works 675s ok 14 - createdb --cluster 12/foo --version 675s ok 15 - pg_wrapper --cluster errors out for invalid cluster 675s ok 16 - createdb --cluster 12/new1 test 675s ok 17 - correct output of createdb --cluster 12/new1 test 675s ok 18 - psql -Atl --cluster 12/new1 675s ok 19 - test db appears in cluster new1 675s ok 20 - psql -Atl --cluster 12/new2 675s ok 21 - test db does not appear in cluster new2 675s ok 22 - psql -Atl 675s ok 23 - test db does not appear in default cluster 675s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 675s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 675s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 675s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 675s ok 28 - psql -Atl --cluster 12/localhost:5434 675s ok 29 - test db appears in cluster 12/localhost:5434 675s ok 30 - psql -Atl --cluster 12/localhost:5440 675s ok 31 - test db does not appear in cluster 12/localhost:5440 675s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 675s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 676s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 676s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 676s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 676s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 676s ok 38 - psql -Atl --cluster 6.4/localhost: 676s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 676s ok 40 - psql -Atl 676s ok 41 - PGCLUSTER selection (1) 676s ok 42 - psql -Atl 676s ok 43 - PGCLUSTER selection (2) 676s ok 44 - psql -l 676s ok 45 - invalid PGCLUSTER value 676s ok 46 - createdb --version 676s ok 47 - PGCLUSTER network cluster selection (1) 676s ok 48 - psql -Atl 676s ok 49 - PGCLUSTER network cluster selection (2) 676s ok 50 - psql -Atl 676s ok 51 - PGCLUSTER network cluster selection (3) 676s ok 52 - LC_MESSAGES=C psql -Atl 676s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 676s ok 54 - psql -Atc "show port" template1 676s ok 55 - PGPORT selection (1) 676s ok 56 - psql -Atc "show port" template1 676s ok 57 - PGPORT selection (2) 676s ok 58 - createdb --version 676s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 676s ok 60 - psql -Atc "show port" template1 676s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 677s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 677s ok 63 - PGDATABASE environment variable works 677s ok 64 - createdb --version 677s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 677s ok 66 - createdb --cluster 12/new1 --version 677s ok 67 - pg_wrapper --cluster works with empty user_clusters 677s ok 68 - createdb --version 677s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 677s ok 70 - psql -Atc "select current_database()" 677s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 677s ok 72 - psql -Atc 'select current_database()' 677s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 677s ok 74 - createdb --version 677s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 677s ok 76 - createdb --version 677s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 677s ok 78 - createdb --version 677s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 677s ok 80 - createdb --version 677s ok 81 - pg_wrapper selects correct version with per-user user_clusters 677s ok 82 - createdb --version 677s ok 83 - pg_wrapper selects correct version with per-user user_clusters 677s ok 84 - createdb --version 677s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 677s ok 86 - psql -Atl 677s ok 87 - $PGHOST overrides user_clusters 677s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 677s ok 89 - --cluster overrides $PGHOST 677s ok 90 - createdb --version 677s ok 91 - pg_wrapper ignores invalid lines in user_clusters 677s ok 92 - psql -Atc 'select current_database()' 677s ok 93 - pg_service conf selection 1 677s ok 94 - psql -Atc 'select current_database()' 677s ok 95 - pg_service conf selection 2 678s ok 96 - psql -Atc 'select current_database()' 678s ok 97 - pg_service conf selection 3 678s ok 98 - stopping cluster 12/old 680s ok 99 - restarting cluster 12/old 680s ok 100 - pg_lsclusters -h | sort -k3 680s ok 101 - port of first cluster was successfully changed 680s ok 102 - psql -l 680s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 680s ok 104 - psql -Atl --cluster 12/new1 680s ok 105 - --cluster selects appropriate cluster 680s ok 106 - psql -Atl -p 5434 680s ok 107 - -p selects appropriate cluster 680s ok 108 - psql -Atlp 5434 680s ok 109 - -Atlp selects appropriate cluster 681s ok 110 - psql -Atl --port 5434 681s ok 111 - --port selects appropriate cluster 681s ok 112 - env PGPORT=5434 psql -Atl 681s ok 113 - $PGPORT selects appropriate cluster 681s ok 114 - Restoring original /etc/postgresql-common/user_clusters 681s ok 115 - dropping 12/new1 682s ok 116 - dropping 12/new2 682s ok 117 - dropping 12/old 682s ok 118 - Cleanup: No clusters left behind 682s ok 119 - No postgres processes left behind 682s ok 120 - No files in /etc/postgresql left behind 682s ok 121 - No files in /var/lib/postgresql left behind 682s ok 122 - No files in /var/run/postgresql left behind 682s ok 123 - No files in /var/log/postgresql left behind 682s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 682s ok 125 - PostgreSQL TCP ports are closed 682s === Running test 100_upgrade_scripts.t ... === 682s 1..27 686s ok 1 - pg_createcluster 12 main 686s ok 2 - createdb --cluster 12/main db1 686s ok 3 - correct output of createdb --cluster 12/main db1 686s ok 4 - createdb --cluster 12/main db2 686s ok 5 - correct output of createdb --cluster 12/main db2 686s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 686s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 686s ok 8 - get_cluster_databases() works 686s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 690s ok 10 - run-upgrade-scripts succeeds 690s ok 11 - correct run-upgrade-script output 690s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 690s ok 13 - check SQL scripts results in 12/main db1 690s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 690s ok 15 - check SQL scripts results in 12/main db2 690s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 690s ok 17 - check shell scripts results in $v/main 690s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 690s ok 19 - pg_dropcluster 12 main 690s ok 20 - Cleanup: No clusters left behind 690s ok 21 - No postgres processes left behind 690s ok 22 - No files in /etc/postgresql left behind 690s ok 23 - No files in /var/lib/postgresql left behind 690s ok 24 - No files in /var/run/postgresql left behind 690s ok 25 - No files in /var/log/postgresql left behind 690s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 690s ok 27 - PostgreSQL TCP ports are closed 690s === Running test 110_integrate_cluster.t ... === 691s 1..32 693s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/cDzQWSewRK/c/postgres 693s ok 2 - creating raw initdb cluster for user postgres 693s ok 3 - pg_createcluster 12 postgres -d /tmp/cDzQWSewRK/c/postgres 693s ok 4 - integrating postgres cluster 693s ok 5 - pg_lsclusters 693s ok 6 - correct pg_lsclusters output 696s ok 7 - pg_ctlcluster 12 postgres start 696s ok 8 - starting cluster postgres 696s ok 9 - pg_lsclusters 696s ok 10 - correct pg_lsclusters output 696s ok 11 - dropping cluster postgres 696s ok 12 - No files in temporary cluster dir left behind 699s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/cDzQWSewRK/c/nobody 699s ok 14 - creating raw initdb cluster for user nobody 699s ok 15 - pg_createcluster 12 nobody -d /tmp/cDzQWSewRK/c/nobody 699s ok 16 - integrating nobody cluster 699s ok 17 - pg_lsclusters 699s ok 18 - correct pg_lsclusters output 701s ok 19 - pg_ctlcluster 12 nobody start 701s ok 20 - starting cluster nobody 701s ok 21 - pg_lsclusters 701s ok 22 - correct pg_lsclusters output 702s ok 23 - dropping cluster nobody 702s ok 24 - No files in temporary cluster dir left behind 702s ok 25 - Cleanup: No clusters left behind 702s ok 26 - No postgres processes left behind 702s ok 27 - No files in /etc/postgresql left behind 702s ok 28 - No files in /var/lib/postgresql left behind 702s ok 29 - No files in /var/run/postgresql left behind 702s ok 30 - No files in /var/log/postgresql left behind 702s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 702s ok 32 - PostgreSQL TCP ports are closed 702s === Running test 120_pg_upgradecluster_scripts.t ... === 702s 1..1 702s ok 1 - only one major version installed, skipping upgrade tests 702s === Running test 130_nonroot_admin.t ... === 702s 1..22 705s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 705s ok 2 - pg_lsclusters -h 705s ok 3 - correct output of pg_lsclusters -h 706s ok 4 - psql -Atl 706s ok 5 - correct output of psql -Atl 706s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 706s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 706s ok 15 - Cleanup: No clusters left behind 706s ok 16 - No postgres processes left behind 706s ok 17 - No files in /etc/postgresql left behind 706s ok 18 - No files in /var/lib/postgresql left behind 706s ok 19 - No files in /var/run/postgresql left behind 706s ok 20 - No files in /var/log/postgresql left behind 706s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 706s ok 22 - PostgreSQL TCP ports are closed 706s === Running test 135_pg_virtualenv.t ... === 706s 1..20 710s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 710s ok 2 - running pg_virtualenv as root 714s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 714s ok 4 - running pg_virtualenv as postgres 718s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 718s ok 6 - running pg_virtualenv as nobody 722s ok 7 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 722s ok 8 - running fakeroot pg_virtualenv as root 726s ok 9 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 726s ok 10 - running fakeroot pg_virtualenv as postgres 729s ok 11 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 729s ok 12 - running fakeroot pg_virtualenv as nobody 730s ok 13 - Cleanup: No clusters left behind 730s ok 14 - No postgres processes left behind 730s ok 15 - No files in /etc/postgresql left behind 730s ok 16 - No files in /var/lib/postgresql left behind 730s ok 17 - No files in /var/run/postgresql left behind 730s ok 18 - No files in /var/log/postgresql left behind 730s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 730s ok 20 - PostgreSQL TCP ports are closed 730s === Running test 140_pg_config.t ... === 730s 1..38 730s # Multiarch is enabled 730s # checking version specific output for 12 730s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 730s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 730s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 730s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 730s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 730s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 730s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 730s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 730s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 730s # checking pg_config output (should behave like version 12) 730s ok 15 - pg_config 730s ok 16 - correct output of pg_config 730s ok 17 - pg_config --help 730s ok 18 - correct output of pg_config --help 730s ok 19 - pg_config --pgxs 730s ok 20 - correct output of pg_config --pgxs 730s ok 21 - pg_config --libdir 730s ok 22 - correct output of pg_config --libdir 730s ok 23 - pg_config --pkglibdir 730s ok 24 - correct output of pg_config --pkglibdir 730s ok 25 - pg_config --bindir 730s ok 26 - correct output of pg_config --bindir 730s # checking pg_config.libpq-dev output (should behave like version 12) 730s ok 27 - pg_config.libpq-dev 730s ok 28 - correct output of pg_config.libpq-dev 730s ok 29 - pg_config.libpq-dev --help 730s ok 30 - correct output of pg_config.libpq-dev --help 730s ok 31 - pg_config.libpq-dev --pgxs 730s ok 32 - correct output of pg_config.libpq-dev --pgxs 730s ok 33 - pg_config.libpq-dev --libdir 730s ok 34 - correct output of pg_config.libpq-dev --libdir 730s ok 35 - pg_config.libpq-dev --pkglibdir 730s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 730s ok 37 - pg_config.libpq-dev --bindir 730s ok 38 - correct output of pg_config.libpq-dev --bindir 730s === Running test 150_tsearch_stemming.t ... === 730s 1..37 730s ok 1 - pg_updatedicts succeeded 730s ok 2 - pg_updatedicts created en_us.affix 730s ok 3 - pg_updatedicts created en_us.dict 730s ok 4 - pg_updatedicts created 12 en_us.affix symlink 730s ok 5 - pg_updatedicts created 12 en_us.dict symlink 734s ok 6 - pg_createcluster 12 main 734s ok 7 - createdb fts 734s ok 8 - correct output of createdb fts 734s ok 9 - creating en_US full text search configuration 734s ok 10 - creating data table and search index 734s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 734s ok 12 - stem search of correct word 735s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 735s ok 14 - stem search of correct word 735s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 735s ok 16 - stem search of unknown word 735s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 735s ok 18 - full text search, exact word 735s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 735s ok 20 - full text search for word stem 735s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 735s ok 22 - full text search for word substring fails 735s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 735s ok 24 - full text search, exact unicode word 735s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 735s ok 26 - full text search for unicode word stem 735s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 735s ok 28 - full text search for unicode word substring fails 736s ok 29 736s ok 30 - Cleanup: No clusters left behind 736s ok 31 - No postgres processes left behind 736s ok 32 - No files in /etc/postgresql left behind 736s ok 33 - No files in /var/lib/postgresql left behind 736s ok 34 - No files in /var/run/postgresql left behind 736s ok 35 - No files in /var/log/postgresql left behind 736s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 736s ok 37 - PostgreSQL TCP ports are closed 736s === Running test 160_alternate_confroot.t ... === 736s 1..28 741s ok 1 741s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 741s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 741s ok 4 - pg_lsclusters -h 741s ok 5 - correct output of pg_lsclusters -h 741s ok 6 - psql -Atl 741s ok 7 - correct output of psql -Atl 741s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 741s ok 9 - ... 741s ok 10 - ... 741s ok 11 - ... 741s ok 12 - ... 741s ok 13 - ... 741s ok 14 - ... 741s ok 15 - pg_dropcluster 12 test --stop 741s ok 16 - correct output of pg_dropcluster 12 test --stop 741s ok 17 - pg_lsclusters -h 741s ok 18 - correct output of pg_lsclusters -h 741s ok 19 - No files in root/data left behind 741s ok 20 - No cruft in root dir left behind 741s ok 21 - Cleanup: No clusters left behind 741s ok 22 - No postgres processes left behind 741s ok 23 - No files in /etc/postgresql left behind 741s ok 24 - No files in /var/lib/postgresql left behind 741s ok 25 - No files in /var/run/postgresql left behind 741s ok 26 - No files in /var/log/postgresql left behind 741s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 741s ok 28 - PostgreSQL TCP ports are closed 741s === Running test 170_extensions.t ... === 741s # Running tests for 12 745s ok 1 - pg_createcluster 12 main 745s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 745s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 745s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 745s ok 5 - extension adminpack installs without error 745s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 745s ok 7 - extension adminpack removes without error 745s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 745s ok 9 - extension amcheck installs without error 745s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 745s ok 11 - extension amcheck removes without error 745s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 745s ok 13 - extension autoinc installs without error 745s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 745s ok 15 - extension autoinc removes without error 745s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 745s ok 17 - extension bloom installs without error 745s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 745s ok 19 - extension bloom removes without error 746s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 746s ok 21 - extension btree_gin installs without error 746s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 746s ok 23 - extension btree_gin removes without error 746s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 746s ok 25 - extension btree_gist installs without error 746s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 746s ok 27 - extension btree_gist removes without error 746s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 746s ok 29 - extension citext installs without error 746s ok 30 - psql -qc 'DROP EXTENSION "citext"' 746s ok 31 - extension citext removes without error 746s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 746s ok 33 - extension cube installs without error 746s ok 34 - psql -qc 'DROP EXTENSION "cube"' 746s ok 35 - extension cube removes without error 746s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 746s ok 37 - extension dblink installs without error 746s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 746s ok 39 - extension dblink removes without error 747s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 747s ok 41 - extension dict_int installs without error 747s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 747s ok 43 - extension dict_int removes without error 747s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 747s ok 45 - extension dict_xsyn installs without error 747s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 747s ok 47 - extension dict_xsyn removes without error 747s ok 48 - psql -qc 'CREATE EXTENSION cube' 747s ok 49 - earthdistance dependency cube installs without error 747s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 747s ok 51 - extension earthdistance installs without error 747s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 747s ok 53 - extension earthdistance removes without error 747s ok 54 - psql -qc 'DROP EXTENSION cube' 747s ok 55 - earthdistance dependency extension cube removes without error 747s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 747s ok 57 - extension file_fdw installs without error 747s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 747s ok 59 - extension file_fdw removes without error 747s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 747s ok 61 - extension fuzzystrmatch installs without error 747s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 747s ok 63 - extension fuzzystrmatch removes without error 748s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 748s ok 65 - extension hstore installs without error 748s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 748s ok 67 - extension hstore removes without error 748s ok 68 - psql -qc 'CREATE EXTENSION hstore' 748s ok 69 - hstore_plperl dependency hstore installs without error 748s ok 70 - psql -qc 'CREATE EXTENSION plperl' 748s ok 71 - hstore_plperl dependency plperl installs without error 748s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 748s ok 73 - extension hstore_plperl installs without error 748s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 748s ok 75 - extension hstore_plperl removes without error 748s ok 76 - psql -qc 'DROP EXTENSION hstore' 748s ok 77 - hstore_plperl dependency extension hstore removes without error 748s ok 78 - psql -qc 'DROP EXTENSION plperl' 748s ok 79 - hstore_plperl dependency extension plperl removes without error 748s ok 80 - psql -qc 'CREATE EXTENSION hstore' 748s ok 81 - hstore_plperlu dependency hstore installs without error 748s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 748s ok 83 - hstore_plperlu dependency plperlu installs without error 748s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 748s ok 85 - extension hstore_plperlu installs without error 748s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 748s ok 87 - extension hstore_plperlu removes without error 749s ok 88 - psql -qc 'DROP EXTENSION hstore' 749s ok 89 - hstore_plperlu dependency extension hstore removes without error 749s ok 90 - psql -qc 'DROP EXTENSION plperlu' 749s ok 91 - hstore_plperlu dependency extension plperlu removes without error 749s ok 92 - psql -qc 'CREATE EXTENSION hstore' 749s ok 93 - hstore_plpython3u dependency hstore installs without error 749s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 749s ok 95 - hstore_plpython3u dependency plpython3u installs without error 749s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 749s ok 97 - extension hstore_plpython3u installs without error 749s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 749s ok 99 - extension hstore_plpython3u removes without error 749s ok 100 - psql -qc 'DROP EXTENSION hstore' 749s ok 101 - hstore_plpython3u dependency extension hstore removes without error 749s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 749s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 749s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 749s ok 105 - extension insert_username installs without error 749s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 749s ok 107 - extension insert_username removes without error 749s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 749s ok 109 - extension intagg installs without error 749s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 749s ok 111 - extension intagg removes without error 750s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 750s ok 113 - extension intarray installs without error 750s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 750s ok 115 - extension intarray removes without error 750s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 750s ok 117 - extension isn installs without error 750s ok 118 - psql -qc 'DROP EXTENSION "isn"' 750s ok 119 - extension isn removes without error 750s ok 120 - psql -qc 'CREATE EXTENSION plperl' 750s ok 121 - jsonb_plperl dependency plperl installs without error 750s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 750s ok 123 - extension jsonb_plperl installs without error 750s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 750s ok 125 - extension jsonb_plperl removes without error 750s ok 126 - psql -qc 'DROP EXTENSION plperl' 750s ok 127 - jsonb_plperl dependency extension plperl removes without error 750s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 750s ok 129 - jsonb_plperlu dependency plperlu installs without error 750s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 750s ok 131 - extension jsonb_plperlu installs without error 751s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 751s ok 133 - extension jsonb_plperlu removes without error 751s ok 134 - psql -qc 'DROP EXTENSION plperlu' 751s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 751s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 751s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 751s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 751s ok 139 - extension jsonb_plpython3u installs without error 751s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 751s ok 141 - extension jsonb_plpython3u removes without error 751s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 751s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 751s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 751s ok 145 - extension lo installs without error 751s ok 146 - psql -qc 'DROP EXTENSION "lo"' 751s ok 147 - extension lo removes without error 751s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 751s ok 149 - extension ltree installs without error 751s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 751s ok 151 - extension ltree removes without error 751s ok 152 - psql -qc 'CREATE EXTENSION ltree' 751s ok 153 - ltree_plpython3u dependency ltree installs without error 751s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 751s ok 155 - ltree_plpython3u dependency plpython3u installs without error 752s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 752s ok 157 - extension ltree_plpython3u installs without error 752s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 752s ok 159 - extension ltree_plpython3u removes without error 752s ok 160 - psql -qc 'DROP EXTENSION ltree' 752s ok 161 - ltree_plpython3u dependency extension ltree removes without error 752s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 752s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 752s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 752s ok 165 - extension moddatetime installs without error 752s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 752s ok 167 - extension moddatetime removes without error 752s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 752s ok 169 - extension pageinspect installs without error 752s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 752s ok 171 - extension pageinspect removes without error 752s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 752s ok 173 - extension pg_buffercache installs without error 752s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 752s ok 175 - extension pg_buffercache removes without error 752s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 752s ok 177 - extension pg_freespacemap installs without error 752s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 752s ok 179 - extension pg_freespacemap removes without error 753s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 753s ok 181 - extension pg_prewarm installs without error 753s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 753s ok 183 - extension pg_prewarm removes without error 753s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 753s ok 185 - extension pg_stat_statements installs without error 753s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 753s ok 187 - extension pg_stat_statements removes without error 753s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 753s ok 189 - extension pg_trgm installs without error 753s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 753s ok 191 - extension pg_trgm removes without error 753s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 753s ok 193 - extension pg_visibility installs without error 753s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 753s ok 195 - extension pg_visibility removes without error 753s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 753s ok 197 - extension pgcrypto installs without error 753s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 753s ok 199 - extension pgcrypto removes without error 753s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 753s ok 201 - extension pgrowlocks installs without error 753s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 753s ok 203 - extension pgrowlocks removes without error 754s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 754s ok 205 - extension pgstattuple installs without error 754s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 754s ok 207 - extension pgstattuple removes without error 754s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 754s ok 209 - extension plperl installs without error 754s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 754s ok 211 - extension plperl removes without error 754s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 754s ok 213 - extension plperlu installs without error 754s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 754s ok 215 - extension plperlu removes without error 754s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 754s ok 217 - extension plpython3u installs without error 754s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 754s ok 219 - extension plpython3u removes without error 754s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 754s ok 221 - extension pltcl installs without error 754s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 754s ok 223 - extension pltcl removes without error 754s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 754s ok 225 - extension pltclu installs without error 754s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 754s ok 227 - extension pltclu removes without error 755s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 755s ok 229 - extension postgres_fdw installs without error 755s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 755s ok 231 - extension postgres_fdw removes without error 755s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 755s ok 233 - extension refint installs without error 755s ok 234 - psql -qc 'DROP EXTENSION "refint"' 755s ok 235 - extension refint removes without error 755s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 755s ok 237 - extension seg installs without error 756s ok 238 - psql -qc 'DROP EXTENSION "seg"' 756s ok 239 - extension seg removes without error 756s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 756s ok 241 - extension sslinfo installs without error 756s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 756s ok 243 - extension sslinfo removes without error 756s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 756s ok 245 - extension tablefunc installs without error 756s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 756s ok 247 - extension tablefunc removes without error 756s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 756s ok 249 - extension tcn installs without error 756s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 756s ok 251 - extension tcn removes without error 756s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 756s ok 253 - extension tsm_system_rows installs without error 756s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 756s ok 255 - extension tsm_system_rows removes without error 756s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 756s ok 257 - extension tsm_system_time installs without error 756s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 756s ok 259 - extension tsm_system_time removes without error 756s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 756s ok 261 - extension unaccent installs without error 756s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 756s ok 263 - extension unaccent removes without error 756s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 756s ok 265 - extension uuid-ossp installs without error 756s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 756s ok 267 - extension uuid-ossp removes without error 756s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 756s ok 269 - extension xml2 installs without error 756s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 756s ok 271 - extension xml2 removes without error 757s ok 272 - pg_dropcluster 12 main 757s ok 273 - Cleanup: No clusters left behind 757s ok 274 - No postgres processes left behind 757s ok 275 - No files in /etc/postgresql left behind 757s ok 276 - No files in /var/lib/postgresql left behind 757s ok 277 - No files in /var/run/postgresql left behind 757s ok 278 - No files in /var/log/postgresql left behind 757s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 757s ok 280 - PostgreSQL TCP ports are closed 757s 1..280 757s === Running test 180_ecpg.t ... === 757s 1..17 757s ok 1 - ecpg test.pgc 757s ok 2 - ecpg processing 757s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 757s ok 4 - compiling ecpg output 761s ok 5 - pg_createcluster 12 main 761s ok 6 - createuser nobody 761s ok 7 - /tmp/tmp.xGBDekkHPo/test 761s ok 8 - runs and gives correct output 762s ok 9 - pg_dropcluster 12 main 762s ok 10 - Cleanup: No clusters left behind 762s ok 11 - No postgres processes left behind 762s ok 12 - No files in /etc/postgresql left behind 762s ok 13 - No files in /var/lib/postgresql left behind 762s ok 14 - No files in /var/run/postgresql left behind 762s ok 15 - No files in /var/log/postgresql left behind 762s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 762s ok 17 - PostgreSQL TCP ports are closed 762s autopkgtest [03:44:44]: test run-testsuite: -----------------------] 766s run-testsuite PASS 766s autopkgtest [03:44:48]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 769s autopkgtest [03:44:51]: @@@@@@@@@@@@@@@@@@@@ summary 769s default-psql PASS 769s run-testsuite PASS