0s autopkgtest [03:32:37]: starting date and time: 2025-03-26 03:32:37+0000 0s autopkgtest [03:32:37]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [03:32:37]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.p785gs4v/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-12 --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-12/12.22-0ubuntu0.20.04.3 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-9.secgroup --name adt-focal-s390x-postgresql-common-20250326-033237-juju-7f2275-prod-proposed-migration-environment-2-f762eef3-4dee-43cb-af8c-5c77f345d0bc --image adt/ubuntu-focal-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-s390x -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 126s autopkgtest [03:34:43]: testbed dpkg architecture: s390x 127s autopkgtest [03:34:44]: testbed apt version: 2.0.10 127s autopkgtest [03:34:44]: @@@@@@@@@@@@@@@@@@@@ test bed setup 127s autopkgtest [03:34:44]: testbed release detected to be: None 128s autopkgtest [03:34:45]: updating testbed package index (apt update) 128s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 128s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 129s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 129s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 129s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 129s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 129s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 129s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main s390x Packages [145 kB] 129s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main s390x c-n-f Metadata [1540 B] 129s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x Packages [1524 B] 129s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x c-n-f Metadata [116 B] 129s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x Packages [40.5 kB] 129s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x c-n-f Metadata [1776 B] 129s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x Packages [760 B] 129s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x c-n-f Metadata [116 B] 131s Fetched 551 kB in 1s (650 kB/s) 132s Reading package lists... 132s autopkgtest [03:34:49]: upgrading testbed (apt dist-upgrade and autopurge) 132s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 133s Starting 2 pkgProblemResolver with broken count: 0 133s Done 133s 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Starting pkgProblemResolver with broken count: 0 133s Starting 2 pkgProblemResolver with broken count: 0 133s Done 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 136s autopkgtest [03:34:53]: testbed running kernel: Linux 5.4.0-211-generic #231-Ubuntu SMP Tue Mar 11 17:23:30 UTC 2025 136s autopkgtest [03:34:53]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 142s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (dsc) [2534 B] 142s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (tar) [216 kB] 142s gpgv: Signature made Mon Aug 24 15:04:29 2020 UTC 142s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 142s gpgv: Can't check signature: No public key 142s dpkg-source: warning: failed to verify signature on ./postgresql-common_214ubuntu0.1.dsc 142s autopkgtest [03:34:59]: testing package postgresql-common version 214ubuntu0.1 142s autopkgtest [03:34:59]: build not needed 143s autopkgtest [03:35:00]: test default-psql: preparing testbed 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s Starting pkgProblemResolver with broken count: 0 143s Starting 2 pkgProblemResolver with broken count: 0 143s Done 143s The following NEW packages will be installed: 143s libpq5 libxslt1.1 postgresql postgresql-12 postgresql-client-12 143s postgresql-client-common postgresql-common ssl-cert 143s 0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded. 143s Need to get 5241 kB of archives. 143s After this operation, 22.9 MB of additional disk space will be used. 143s Get:1 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libpq5 s390x 12.22-0ubuntu0.20.04.3 [109 kB] 144s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.20.04.3 [140 kB] 144s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-common all 214ubuntu0.1 [28.2 kB] 144s Get:4 http://ftpmaster.internal/ubuntu focal-proposed/main s390x postgresql-client-12 s390x 12.22-0ubuntu0.20.04.3 [1029 kB] 144s Get:5 http://ftpmaster.internal/ubuntu focal/main s390x ssl-cert all 1.0.39 [17.0 kB] 144s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-common all 214ubuntu0.1 [169 kB] 144s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main s390x postgresql-12 s390x 12.22-0ubuntu0.20.04.3 [3745 kB] 144s Get:8 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql all 12+214ubuntu0.1 [3924 B] 144s Preconfiguring packages ... 144s Fetched 5241 kB in 1s (7031 kB/s) 144s Selecting previously unselected package libpq5:s390x. 144s (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 ... 71281 files and directories currently installed.) 144s Preparing to unpack .../0-libpq5_12.22-0ubuntu0.20.04.3_s390x.deb ... 144s Unpacking libpq5:s390x (12.22-0ubuntu0.20.04.3) ... 145s Selecting previously unselected package libxslt1.1:s390x. 145s Preparing to unpack .../1-libxslt1.1_1.1.34-4ubuntu0.20.04.3_s390x.deb ... 145s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.3) ... 145s Selecting previously unselected package postgresql-client-common. 145s Preparing to unpack .../2-postgresql-client-common_214ubuntu0.1_all.deb ... 145s Unpacking postgresql-client-common (214ubuntu0.1) ... 145s Selecting previously unselected package postgresql-client-12. 145s Preparing to unpack .../3-postgresql-client-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 145s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 145s Selecting previously unselected package ssl-cert. 145s Preparing to unpack .../4-ssl-cert_1.0.39_all.deb ... 145s Unpacking ssl-cert (1.0.39) ... 145s Selecting previously unselected package postgresql-common. 145s Preparing to unpack .../5-postgresql-common_214ubuntu0.1_all.deb ... 145s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 145s Unpacking postgresql-common (214ubuntu0.1) ... 145s Selecting previously unselected package postgresql-12. 145s Preparing to unpack .../6-postgresql-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 145s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 145s Selecting previously unselected package postgresql. 145s Preparing to unpack .../7-postgresql_12+214ubuntu0.1_all.deb ... 145s Unpacking postgresql (12+214ubuntu0.1) ... 145s Setting up postgresql-client-common (214ubuntu0.1) ... 145s Setting up libpq5:s390x (12.22-0ubuntu0.20.04.3) ... 145s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 145s 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 145s Setting up ssl-cert (1.0.39) ... 146s Setting up postgresql-common (214ubuntu0.1) ... 146s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 146s Adding user postgres to group ssl-cert 146s 146s Creating config file /etc/postgresql-common/createcluster.conf with new version 146s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 146s Removing obsolete dictionary files: 146s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 147s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.3) ... 147s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 147s Creating new PostgreSQL cluster 12/main ... 147s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 147s The files belonging to this database system will be owned by user "postgres". 147s This user must also own the server process. 147s 147s The database cluster will be initialized with locale "C.UTF-8". 147s The default database encoding has accordingly been set to "UTF8". 147s The default text search configuration will be set to "english". 147s 147s Data page checksums are disabled. 147s 147s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 147s creating subdirectories ... ok 147s selecting dynamic shared memory implementation ... posix 147s selecting default max_connections ... 100 147s selecting default shared_buffers ... 128MB 147s selecting default time zone ... Etc/UTC 147s creating configuration files ... ok 147s running bootstrap script ... ok 147s performing post-bootstrap initialization ... ok 147s syncing data to disk ... ok 147s 147s Success. You can now start the database server using: 147s 147s pg_ctlcluster 12 main start 147s 148s Ver Cluster Port Status Owner Data directory Log file 148s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 148s 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 150s Setting up postgresql (12+214ubuntu0.1) ... 150s Processing triggers for systemd (245.4-4ubuntu3.24) ... 150s Processing triggers for man-db (2.9.1-1) ... 151s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 152s autopkgtest [03:35:09]: test default-psql: [----------------------- 153s autopkgtest [03:35:10]: test default-psql: -----------------------] 154s autopkgtest [03:35:11]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 154s default-psql PASS 154s autopkgtest [03:35:11]: test run-testsuite: preparing testbed 271s autopkgtest [03:37:08]: testbed dpkg architecture: s390x 271s autopkgtest [03:37:08]: testbed apt version: 2.0.10 271s autopkgtest [03:37:08]: @@@@@@@@@@@@@@@@@@@@ test bed setup 272s autopkgtest [03:37:09]: testbed release detected to be: focal 272s autopkgtest [03:37:09]: updating testbed package index (apt update) 273s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 273s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 273s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 273s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 273s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 273s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 273s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 273s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main s390x Packages [145 kB] 273s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main s390x c-n-f Metadata [1540 B] 273s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x Packages [1524 B] 273s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted s390x c-n-f Metadata [116 B] 273s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x Packages [40.5 kB] 273s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x c-n-f Metadata [1776 B] 273s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x Packages [760 B] 273s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse s390x c-n-f Metadata [116 B] 276s Fetched 551 kB in 1s (621 kB/s) 276s Reading package lists... 277s autopkgtest [03:37:14]: upgrading testbed (apt dist-upgrade and autopurge) 277s Reading package lists... 277s Building dependency tree... 277s Reading state information... 277s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 277s Starting 2 pkgProblemResolver with broken count: 0 277s Done 277s 277s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 277s Reading package lists... 277s Building dependency tree... 277s Reading state information... 277s Starting pkgProblemResolver with broken count: 0 277s Starting 2 pkgProblemResolver with broken count: 0 277s Done 277s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 280s Reading package lists... 280s Building dependency tree... 280s Reading state information... 280s Starting pkgProblemResolver with broken count: 0 280s Starting 2 pkgProblemResolver with broken count: 0 280s Done 280s The following NEW packages will be installed: 280s build-essential cpp cpp-9 dictionaries-common emacsen-common fakeroot g++ 280s g++-9 gcc gcc-9 gcc-9-base hunspell-en-us libasan5 libatomic1 libc-dev-bin 280s libc6-dev libcc1-0 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 280s libfakeroot libgcc-9-dev libgomp1 libisl22 libitm1 libmpc3 libpgtypes3 280s libpq-dev libpq5 libpython3.8 libstdc++-9-dev libtcl8.6 libubsan1 libxslt1.1 280s linux-libc-dev net-tools postgresql-12 postgresql-all postgresql-client-12 280s postgresql-client-common postgresql-common postgresql-plperl-12 280s postgresql-plpython3-12 postgresql-pltcl-12 postgresql-server-dev-12 280s postgresql-server-dev-all ssl-cert 280s 0 upgraded, 48 newly installed, 0 to remove and 0 not upgraded. 280s Need to get 38.4 MB of archives. 280s After this operation, 179 MB of additional disk space will be used. 280s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc-dev-bin s390x 2.31-0ubuntu9.17 [63.2 kB] 281s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main s390x linux-libc-dev s390x 5.4.0-211.231 [1116 kB] 281s Get:3 http://ftpmaster.internal/ubuntu focal/main s390x libcrypt-dev s390x 1:4.4.10-10ubuntu4 [107 kB] 281s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main s390x libc6-dev s390x 2.31-0ubuntu9.17 [2023 kB] 281s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9-base s390x 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 281s Get:6 http://ftpmaster.internal/ubuntu focal/main s390x libisl22 s390x 0.22.1-1 [545 kB] 281s Get:7 http://ftpmaster.internal/ubuntu focal/main s390x libmpc3 s390x 1.1.0-1 [38.3 kB] 281s Get:8 http://ftpmaster.internal/ubuntu focal-updates/main s390x cpp-9 s390x 9.4.0-1ubuntu1~20.04.2 [5727 kB] 281s Get:9 http://ftpmaster.internal/ubuntu focal/main s390x cpp s390x 4:9.3.0-1ubuntu2 [27.6 kB] 281s Get:10 http://ftpmaster.internal/ubuntu focal-updates/main s390x libcc1-0 s390x 10.5.0-1ubuntu1~20.04 [45.0 kB] 281s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgomp1 s390x 10.5.0-1ubuntu1~20.04 [95.0 kB] 281s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main s390x libitm1 s390x 10.5.0-1ubuntu1~20.04 [25.4 kB] 281s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main s390x libatomic1 s390x 10.5.0-1ubuntu1~20.04 [8524 B] 281s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main s390x libasan5 s390x 9.4.0-1ubuntu1~20.04.2 [2556 kB] 281s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main s390x libubsan1 s390x 10.5.0-1ubuntu1~20.04 [756 kB] 281s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main s390x libgcc-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [689 kB] 281s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main s390x gcc-9 s390x 9.4.0-1ubuntu1~20.04.2 [6489 kB] 281s Get:18 http://ftpmaster.internal/ubuntu focal/main s390x gcc s390x 4:9.3.0-1ubuntu2 [5204 B] 281s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main s390x libstdc++-9-dev s390x 9.4.0-1ubuntu1~20.04.2 [1682 kB] 281s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main s390x g++-9 s390x 9.4.0-1ubuntu1~20.04.2 [6608 kB] 282s Get:21 http://ftpmaster.internal/ubuntu focal/main s390x g++ s390x 4:9.3.0-1ubuntu2 [1600 B] 282s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main s390x build-essential s390x 12.8ubuntu1.1 [4664 B] 282s Get:23 http://ftpmaster.internal/ubuntu focal/main s390x emacsen-common all 3.0.4 [14.9 kB] 282s Get:24 http://ftpmaster.internal/ubuntu focal/main s390x dictionaries-common all 1.28.1 [178 kB] 282s Get:25 http://ftpmaster.internal/ubuntu focal/main s390x libfakeroot s390x 1.24-1 [24.5 kB] 282s Get:26 http://ftpmaster.internal/ubuntu focal/main s390x fakeroot s390x 1.24-1 [61.0 kB] 282s Get:27 http://ftpmaster.internal/ubuntu focal/main s390x hunspell-en-us all 1:2018.04.16-1 [170 kB] 282s Get:28 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libpgtypes3 s390x 12.22-0ubuntu0.20.04.3 [44.3 kB] 282s Get:29 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libpq5 s390x 12.22-0ubuntu0.20.04.3 [109 kB] 282s Get:30 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libecpg6 s390x 12.22-0ubuntu0.20.04.3 [40.4 kB] 282s Get:31 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libecpg-compat3 s390x 12.22-0ubuntu0.20.04.3 [12.1 kB] 282s Get:32 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libpq-dev s390x 12.22-0ubuntu0.20.04.3 [133 kB] 282s Get:33 http://ftpmaster.internal/ubuntu focal-proposed/main s390x libecpg-dev s390x 12.22-0ubuntu0.20.04.3 [224 kB] 282s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main s390x libpython3.8 s390x 3.8.10-0ubuntu1~20.04.18 [1479 kB] 282s Get:35 http://ftpmaster.internal/ubuntu focal/main s390x libtcl8.6 s390x 8.6.10+dfsg-1 [838 kB] 282s Get:36 http://ftpmaster.internal/ubuntu focal-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.20.04.3 [140 kB] 282s Get:37 http://ftpmaster.internal/ubuntu focal/main s390x net-tools s390x 1.60+git20180626.aebd88e-1ubuntu1 [187 kB] 282s Get:38 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-client-common all 214ubuntu0.1 [28.2 kB] 282s Get:39 http://ftpmaster.internal/ubuntu focal-proposed/main s390x postgresql-client-12 s390x 12.22-0ubuntu0.20.04.3 [1029 kB] 282s Get:40 http://ftpmaster.internal/ubuntu focal/main s390x ssl-cert all 1.0.39 [17.0 kB] 282s Get:41 http://ftpmaster.internal/ubuntu focal-updates/main s390x postgresql-common all 214ubuntu0.1 [169 kB] 282s Get:42 http://ftpmaster.internal/ubuntu focal-proposed/main s390x postgresql-12 s390x 12.22-0ubuntu0.20.04.3 [3745 kB] 282s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x postgresql-server-dev-12 s390x 12.22-0ubuntu0.20.04.3 [989 kB] 282s Get:44 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-server-dev-all all 214ubuntu0.1 [7652 B] 282s Get:45 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x postgresql-plperl-12 s390x 12.22-0ubuntu0.20.04.3 [47.1 kB] 282s Get:46 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x postgresql-plpython3-12 s390x 12.22-0ubuntu0.20.04.3 [53.4 kB] 282s Get:47 http://ftpmaster.internal/ubuntu focal-proposed/universe s390x postgresql-pltcl-12 s390x 12.22-0ubuntu0.20.04.3 [30.1 kB] 282s Get:48 http://ftpmaster.internal/ubuntu focal-updates/universe s390x postgresql-all all 12+214ubuntu0.1 [1924 B] 282s Preconfiguring packages ... 282s Fetched 38.4 MB in 2s (22.4 MB/s) 282s Selecting previously unselected package libc-dev-bin. 283s (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 ... 71281 files and directories currently installed.) 283s Preparing to unpack .../00-libc-dev-bin_2.31-0ubuntu9.17_s390x.deb ... 283s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 283s Selecting previously unselected package linux-libc-dev:s390x. 283s Preparing to unpack .../01-linux-libc-dev_5.4.0-211.231_s390x.deb ... 283s Unpacking linux-libc-dev:s390x (5.4.0-211.231) ... 283s Selecting previously unselected package libcrypt-dev:s390x. 283s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.10-10ubuntu4_s390x.deb ... 283s Unpacking libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 283s Selecting previously unselected package libc6-dev:s390x. 283s Preparing to unpack .../03-libc6-dev_2.31-0ubuntu9.17_s390x.deb ... 283s Unpacking libc6-dev:s390x (2.31-0ubuntu9.17) ... 283s Selecting previously unselected package gcc-9-base:s390x. 283s Preparing to unpack .../04-gcc-9-base_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 283s Unpacking gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 283s Selecting previously unselected package libisl22:s390x. 283s Preparing to unpack .../05-libisl22_0.22.1-1_s390x.deb ... 283s Unpacking libisl22:s390x (0.22.1-1) ... 283s Selecting previously unselected package libmpc3:s390x. 283s Preparing to unpack .../06-libmpc3_1.1.0-1_s390x.deb ... 283s Unpacking libmpc3:s390x (1.1.0-1) ... 283s Selecting previously unselected package cpp-9. 283s Preparing to unpack .../07-cpp-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 283s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 283s Selecting previously unselected package cpp. 283s Preparing to unpack .../08-cpp_4%3a9.3.0-1ubuntu2_s390x.deb ... 283s Unpacking cpp (4:9.3.0-1ubuntu2) ... 283s Selecting previously unselected package libcc1-0:s390x. 283s Preparing to unpack .../09-libcc1-0_10.5.0-1ubuntu1~20.04_s390x.deb ... 283s Unpacking libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 284s Selecting previously unselected package libgomp1:s390x. 284s Preparing to unpack .../10-libgomp1_10.5.0-1ubuntu1~20.04_s390x.deb ... 284s Unpacking libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 284s Selecting previously unselected package libitm1:s390x. 284s Preparing to unpack .../11-libitm1_10.5.0-1ubuntu1~20.04_s390x.deb ... 284s Unpacking libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 284s Selecting previously unselected package libatomic1:s390x. 284s Preparing to unpack .../12-libatomic1_10.5.0-1ubuntu1~20.04_s390x.deb ... 284s Unpacking libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 284s Selecting previously unselected package libasan5:s390x. 284s Preparing to unpack .../13-libasan5_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 284s Unpacking libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 284s Selecting previously unselected package libubsan1:s390x. 284s Preparing to unpack .../14-libubsan1_10.5.0-1ubuntu1~20.04_s390x.deb ... 284s Unpacking libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 284s Selecting previously unselected package libgcc-9-dev:s390x. 284s Preparing to unpack .../15-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 284s Unpacking libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 284s Selecting previously unselected package gcc-9. 284s Preparing to unpack .../16-gcc-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 284s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 284s Selecting previously unselected package gcc. 284s Preparing to unpack .../17-gcc_4%3a9.3.0-1ubuntu2_s390x.deb ... 284s Unpacking gcc (4:9.3.0-1ubuntu2) ... 284s Selecting previously unselected package libstdc++-9-dev:s390x. 284s Preparing to unpack .../18-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 284s Unpacking libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 285s Selecting previously unselected package g++-9. 285s Preparing to unpack .../19-g++-9_9.4.0-1ubuntu1~20.04.2_s390x.deb ... 285s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 285s Selecting previously unselected package g++. 285s Preparing to unpack .../20-g++_4%3a9.3.0-1ubuntu2_s390x.deb ... 285s Unpacking g++ (4:9.3.0-1ubuntu2) ... 285s Selecting previously unselected package build-essential. 285s Preparing to unpack .../21-build-essential_12.8ubuntu1.1_s390x.deb ... 285s Unpacking build-essential (12.8ubuntu1.1) ... 285s Selecting previously unselected package emacsen-common. 285s Preparing to unpack .../22-emacsen-common_3.0.4_all.deb ... 285s Unpacking emacsen-common (3.0.4) ... 285s Selecting previously unselected package dictionaries-common. 285s Preparing to unpack .../23-dictionaries-common_1.28.1_all.deb ... 285s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 285s Unpacking dictionaries-common (1.28.1) ... 285s Selecting previously unselected package libfakeroot:s390x. 285s Preparing to unpack .../24-libfakeroot_1.24-1_s390x.deb ... 285s Unpacking libfakeroot:s390x (1.24-1) ... 285s Selecting previously unselected package fakeroot. 285s Preparing to unpack .../25-fakeroot_1.24-1_s390x.deb ... 285s Unpacking fakeroot (1.24-1) ... 285s Selecting previously unselected package hunspell-en-us. 285s Preparing to unpack .../26-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 285s Unpacking hunspell-en-us (1:2018.04.16-1) ... 285s Selecting previously unselected package libpgtypes3:s390x. 285s Preparing to unpack .../27-libpgtypes3_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libpgtypes3:s390x (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libpq5:s390x. 285s Preparing to unpack .../28-libpq5_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libpq5:s390x (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libecpg6:s390x. 285s Preparing to unpack .../29-libecpg6_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libecpg6:s390x (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libecpg-compat3:s390x. 285s Preparing to unpack .../30-libecpg-compat3_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libecpg-compat3:s390x (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libpq-dev. 285s Preparing to unpack .../31-libpq-dev_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libecpg-dev. 285s Preparing to unpack .../32-libecpg-dev_12.22-0ubuntu0.20.04.3_s390x.deb ... 285s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 285s Selecting previously unselected package libpython3.8:s390x. 285s Preparing to unpack .../33-libpython3.8_3.8.10-0ubuntu1~20.04.18_s390x.deb ... 285s Unpacking libpython3.8:s390x (3.8.10-0ubuntu1~20.04.18) ... 285s Selecting previously unselected package libtcl8.6:s390x. 285s Preparing to unpack .../34-libtcl8.6_8.6.10+dfsg-1_s390x.deb ... 285s Unpacking libtcl8.6:s390x (8.6.10+dfsg-1) ... 286s Selecting previously unselected package libxslt1.1:s390x. 286s Preparing to unpack .../35-libxslt1.1_1.1.34-4ubuntu0.20.04.3_s390x.deb ... 286s Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.3) ... 286s Selecting previously unselected package net-tools. 286s Preparing to unpack .../36-net-tools_1.60+git20180626.aebd88e-1ubuntu1_s390x.deb ... 286s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 286s Selecting previously unselected package postgresql-client-common. 286s Preparing to unpack .../37-postgresql-client-common_214ubuntu0.1_all.deb ... 286s Unpacking postgresql-client-common (214ubuntu0.1) ... 286s Selecting previously unselected package postgresql-client-12. 286s Preparing to unpack .../38-postgresql-client-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package ssl-cert. 286s Preparing to unpack .../39-ssl-cert_1.0.39_all.deb ... 286s Unpacking ssl-cert (1.0.39) ... 286s Selecting previously unselected package postgresql-common. 286s Preparing to unpack .../40-postgresql-common_214ubuntu0.1_all.deb ... 286s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 286s Unpacking postgresql-common (214ubuntu0.1) ... 286s Selecting previously unselected package postgresql-12. 286s Preparing to unpack .../41-postgresql-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package postgresql-server-dev-12. 286s Preparing to unpack .../42-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package postgresql-server-dev-all. 286s Preparing to unpack .../43-postgresql-server-dev-all_214ubuntu0.1_all.deb ... 286s Unpacking postgresql-server-dev-all (214ubuntu0.1) ... 286s Selecting previously unselected package postgresql-plperl-12. 286s Preparing to unpack .../44-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package postgresql-plpython3-12. 286s Preparing to unpack .../45-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package postgresql-pltcl-12. 286s Preparing to unpack .../46-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_s390x.deb ... 286s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 286s Selecting previously unselected package postgresql-all. 286s Preparing to unpack .../47-postgresql-all_12+214ubuntu0.1_all.deb ... 286s Unpacking postgresql-all (12+214ubuntu0.1) ... 286s Setting up postgresql-client-common (214ubuntu0.1) ... 286s Setting up libpgtypes3:s390x (12.22-0ubuntu0.20.04.3) ... 286s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 286s Setting up libpq5:s390x (12.22-0ubuntu0.20.04.3) ... 286s Setting up linux-libc-dev:s390x (5.4.0-211.231) ... 286s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 286s Setting up libgomp1:s390x (10.5.0-1ubuntu1~20.04) ... 286s Setting up libfakeroot:s390x (1.24-1) ... 286s Setting up fakeroot (1.24-1) ... 286s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 286s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 287s 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 287s Setting up emacsen-common (3.0.4) ... 287s Setting up ssl-cert (1.0.39) ... 287s Setting up libpython3.8:s390x (3.8.10-0ubuntu1~20.04.18) ... 287s Setting up postgresql-common (214ubuntu0.1) ... 287s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 287s Adding user postgres to group ssl-cert 287s 287s Creating config file /etc/postgresql-common/createcluster.conf with new version 287s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 287s en_us 287s Removing obsolete dictionary files: 287s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 288s Setting up libmpc3:s390x (1.1.0-1) ... 288s Setting up libatomic1:s390x (10.5.0-1ubuntu1~20.04) ... 288s Setting up libtcl8.6:s390x (8.6.10+dfsg-1) ... 288s Setting up libubsan1:s390x (10.5.0-1ubuntu1~20.04) ... 288s Setting up libcrypt-dev:s390x (1:4.4.10-10ubuntu4) ... 288s Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.20.04.3) ... 288s Setting up libecpg6:s390x (12.22-0ubuntu0.20.04.3) ... 288s Setting up libisl22:s390x (0.22.1-1) ... 288s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 288s Creating new PostgreSQL cluster 12/main ... 288s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 288s The files belonging to this database system will be owned by user "postgres". 288s This user must also own the server process. 288s 288s The database cluster will be initialized with locale "C.UTF-8". 288s The default database encoding has accordingly been set to "UTF8". 288s The default text search configuration will be set to "english". 288s 288s Data page checksums are disabled. 288s 288s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 288s creating subdirectories ... ok 288s selecting dynamic shared memory implementation ... posix 288s selecting default max_connections ... 100 288s selecting default shared_buffers ... 128MB 288s selecting default time zone ... Etc/UTC 288s creating configuration files ... ok 288s running bootstrap script ... ok 288s performing post-bootstrap initialization ... ok 289s syncing data to disk ... ok 289s 289s Success. You can now start the database server using: 289s 289s pg_ctlcluster 12 main start 289s 289s Ver Cluster Port Status Owner Data directory Log file 289s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 289s 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 291s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 291s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 291s Setting up libcc1-0:s390x (10.5.0-1ubuntu1~20.04) ... 291s Setting up libitm1:s390x (10.5.0-1ubuntu1~20.04) ... 291s Setting up gcc-9-base:s390x (9.4.0-1ubuntu1~20.04.2) ... 291s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 291s Setting up libecpg-compat3:s390x (12.22-0ubuntu0.20.04.3) ... 291s Setting up dictionaries-common (1.28.1) ... 292s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 292s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 292s Setting up libasan5:s390x (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 292s Setting up hunspell-en-us (1:2018.04.16-1) ... 292s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up libc6-dev:s390x (2.31-0ubuntu9.17) ... 292s Setting up postgresql-server-dev-all (214ubuntu0.1) ... 292s Setting up postgresql-all (12+214ubuntu0.1) ... 292s Setting up libgcc-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up cpp (4:9.3.0-1ubuntu2) ... 292s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up libstdc++-9-dev:s390x (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up gcc (4:9.3.0-1ubuntu2) ... 292s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 292s Setting up g++ (4:9.3.0-1ubuntu2) ... 292s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 292s Setting up build-essential (12.8ubuntu1.1) ... 292s Processing triggers for systemd (245.4-4ubuntu3.24) ... 292s Processing triggers for man-db (2.9.1-1) ... 293s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 293s Processing triggers for dictionaries-common (1.28.1) ... 295s autopkgtest [03:37:32]: test run-testsuite: [----------------------- 295s Generating locales (this might take a while)... 296s en_US.UTF-8... done 297s ru_RU.ISO-8859-5... done 297s ru_RU.UTF-8... done 297s Generation complete. 298s ====== Running all tests with umask 077 ======= 298s === Running test 001_packages.t ... === 298s 1..18 298s # PostgreSQL versions installed: 12 298s ok 1 - postgresql-12 installed 298s ok 2 # skip No python2 support 298s ok 3 - postgresql-plpython3-12 installed 298s ok 4 - postgresql-plperl-12 installed 298s ok 5 - postgresql-pltcl-12 installed 298s ok 6 - postgresql-server-dev-12 installed 298s ok 7 # skip No postgresql-contrib-12 package for version 12 298s ok 8 - libecpg-dev installed 298s ok 9 - procps installed 298s ok 10 - netcat-openbsd installed 298s ok 11 - hunspell-en-us installed 298s ok 12 - system has a default UTF-8 locale 298s ok 13 - locale ru_RU exists 298s ok 14 - locale ru_RU.UTF-8 exists 298s ok 15 - user postgres in the UNIX group ssl-cert 298s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 298s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 298s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 298s === Running test 002_existing_clusters.t ... === 298s 1..8 298s ok 1 - Cleanup: No clusters left behind 298s ok 2 - No postgres processes left behind 298s ok 3 - No files in /etc/postgresql left behind 298s ok 4 - No files in /var/lib/postgresql left behind 298s ok 5 - No files in /var/run/postgresql left behind 298s ok 6 - No files in /var/log/postgresql left behind 298s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 298s ok 8 - PostgreSQL TCP ports are closed 298s === Running test 003_package_checks.t ... === 298s 1..4 298s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 298s ok 2 - psql is linked against libedit 298s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 298s ok 4 - psql is not linked against libreadline 298s === Running test 005_PgCommon.t ... === 298s 1..24 298s ok 1 - correctly parsed line 'local all postgres ident sameuser' 298s ok 2 - correctly parsed line 'local foo nobody trust' 298s ok 3 - correctly parsed line 'local foo nobody crypt' 298s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 298s ok 5 - correctly parsed line 'local foo,bar nobody ident' 298s ok 6 - correctly parsed line 'local all +foogrp password' 298s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 298s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 298s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 298s ok 10 - @expected_records has correct number of entries 298s ok 11 - returned read_pg_hba array has correct number of records 298s ok 12 - line 'foo all all md5' parsed as invalid 298s ok 13 - line 'local all all foo' parsed as invalid 298s ok 14 - line 'host all all foo' parsed as invalid 298s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 298s ok 16 - line 'host all all md5' parsed as invalid 298s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 298s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 298s ok 19 - read_conf_file returns empty dict for nonexisting file 298s ok 20 - read_conf_file() parsing 298s ok 21 - read_conf_file() parsing with include directives 298s ok 22 - set_conf_value 298s ok 23 - disable_conf_value 298s ok 24 - replace_conf_value 298s === Running test 006_next_free_port.t ... === 298s 1..5 298s ok 1 - next_free_port is 5432 299s ok 2 - next_free_port detects localhost ipv4 socket 300s ok 3 - next_free_port detects wildcard ipv4 socket 300s ok 4 - next_free_port detects localhost ipv6 socket 301s ok 5 - next_free_port detects wildcard ipv6 socket 301s === Running test 007_pg_conftool.t ... === 301s 1..41 301s # test without cluster 301s ok 1 - pg_conftool show all 301s ok 2 - correct output of pg_conftool show all 301s ok 3 - pg_conftool foo.conf show all 301s ok 4 - correct output of pg_conftool foo.conf show all 301s ok 5 - pg_conftool /tmp/dct2Zukj4I/different.conf show all 301s ok 6 - correct output of pg_conftool /tmp/dct2Zukj4I/different.conf show all 301s ok 7 - pg_conftool 9.7 main show all 301s ok 8 - correct output of pg_conftool 9.7 main show all 301s # test show 301s ok 9 - pg_conftool show all 301s ok 10 - correct output of pg_conftool show all 301s ok 11 - pg_conftool other.conf show all 301s ok 12 - correct output of pg_conftool other.conf show all 301s ok 13 - pg_conftool /tmp/dct2Zukj4I/different.conf show all 301s ok 14 - correct output of pg_conftool /tmp/dct2Zukj4I/different.conf show all 301s ok 15 - pg_conftool 12 main show all 301s ok 16 - correct output of pg_conftool 12 main show all 301s ok 17 - pg_conftool 12 main other.conf show all 301s ok 18 - correct output of pg_conftool 12 main other.conf show all 301s ok 19 - pg_conftool show a 301s ok 20 - correct output of pg_conftool show a 301s ok 21 - pg_conftool -s show a 301s ok 22 - correct output of pg_conftool -s show a 301s # test set 301s ok 23 - pg_conftool set c 7 301s ok 24 - correct output of pg_conftool set c 7 301s ok 25 - file contains new setting 301s ok 26 - pg_conftool set a 8 301s ok 27 - correct output of pg_conftool set a 8 301s ok 28 - file contains updated setting 301s ok 29 - pg_conftool /tmp/dct2Zukj4I/different.conf set a 9 301s ok 30 - correct output of pg_conftool /tmp/dct2Zukj4I/different.conf set a 9 301s ok 31 - file with path contains updated setting 301s # test remove 301s ok 32 - pg_conftool remove a 301s ok 33 - correct output of pg_conftool remove a 301s ok 34 - setting removed from file 301s ok 35 - pg_conftool /tmp/dct2Zukj4I/different.conf remove a 301s ok 36 - correct output of pg_conftool /tmp/dct2Zukj4I/different.conf remove a 301s ok 37 - setting removed from file with path 301s # test edit 301s ok 38 - pg_conftool edit 301s ok 39 - correct output of pg_conftool edit 301s ok 40 - pg_conftool /tmp/dct2Zukj4I/different.conf edit 301s ok 41 - correct output of pg_conftool /tmp/dct2Zukj4I/different.conf edit 301s === Running test 010_defaultport_cluster.t ... === 301s 1..14 301s ok 1 - psql --version 301s ok 2 - pg_wrapper selects highest available version number 301s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 301s ok 4 - connecting to localhost fails with no clusters 301s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 301s ok 6 - pg_wrapper uses host and port from PGCLUSTER 301s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 301s ok 8 - pg_wrapper uses --cluster from the command line 301s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 301s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 301s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 301s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 301s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 301s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 301s === Running test 015_start_stop.t ... === 301s 1..71 301s # We are running systemd 301s # Running tests for 12 301s # Cluster does not exist yet 301s ok 1 - cluster 12 main does not exist 301s ok 2 - service postgresql@12-main does not exist 301s ok 3 - systemctl start postgresql 301s ok 4 - cluster 12 main does not exist 301s ok 5 - service postgresql@12-main does not exist 301s ok 6 - systemctl start postgresql@12-main 301s ok 7 - cluster 12 main does not exist 301s ok 8 - service postgresql@12-main does not exist 301s # Start/stop postgresql using system tools 302s ok 9 - pg_createcluster 12 main 302s ok 10 - cluster 12 main is stopped 302s ok 11 - service postgresql@12-main is stopped 304s ok 12 - systemctl start postgresql 304s ok 13 - cluster 12 main is running 304s ok 14 - service postgresql@12-main is running 304s ok 15 - systemctl start postgresql 304s ok 16 - cluster 12 main is already running 304s ok 17 - service postgresql@12-main is already running 304s ok 18 - systemctl stop postgresql 310s ok 19 - cluster 12 main is stopped 310s ok 20 - service postgresql@12-main is stopped 310s ok 21 - systemctl stop postgresql 311s ok 22 - cluster 12 main is already stopped 311s ok 23 - service postgresql@12-main is already stopped 311s # Start/stop specific cluster using system tools 313s ok 24 - systemctl start postgresql@12-main 313s ok 25 - cluster 12 main is running 313s ok 26 - service postgresql@12-main is running 313s ok 27 - systemctl start postgresql@12-main 313s ok 28 - cluster 12 main is running 313s ok 29 - service postgresql@12-main is running 315s ok 30 - systemctl restart postgresql@12-main 315s ok 31 - cluster 12 main is running 315s ok 32 - service postgresql@12-main is running 315s ok 33 - systemctl stop postgresql@12-main 315s ok 34 - cluster 12 main is stopped 315s ok 35 - service postgresql@12-main is stopped 315s ok 36 - systemctl stop postgresql@12-main 315s ok 37 - cluster 12 main is already stopped 315s ok 38 - service postgresql@12-main is already stopped 315s ok 39 - pg_dropcluster 12 main 316s ok 40 - cluster 12 main does not exist 316s ok 41 - service postgresql@12-main does not exist 316s # Start/stop specific cluster using pg_*cluster 316s ok 42 - pg_ctlcluster start 12 main 316s ok 43 - cluster 12 main does not exist 316s ok 44 - service postgresql@12-main does not exist 318s ok 45 - pg_createcluster 12 main --start 319s ok 46 - cluster 12 main is running 319s ok 47 - service postgresql@12-main is running 319s ok 48 - pg_ctlcluster 12 main start 319s ok 49 - cluster 12 main is already running 319s ok 50 - service postgresql@12-main is already running 321s ok 51 - pg_ctlcluster 12-main restart 321s ok 52 - cluster 12 main is running 321s ok 53 - service postgresql@12-main is running 321s ok 54 - pg_ctlcluster 12 main stop 321s ok 55 - cluster 12 main is stopped 321s ok 56 - service postgresql@12-main is stopped 321s ok 57 - pg_ctlcluster 12 main stop 321s ok 58 - cluster 12 main is already stopped 321s ok 59 - service postgresql@12-main is already stopped 323s ok 60 - pg_ctlcluster start 12-main 323s ok 61 - cluster 12 main is running 323s ok 62 - service postgresql@12-main is running 324s ok 63 - pg_dropcluster 12 main --stop 324s ok 64 - Cleanup: No clusters left behind 324s ok 65 - No postgres processes left behind 324s ok 66 - No files in /etc/postgresql left behind 324s ok 67 - No files in /var/lib/postgresql left behind 324s ok 68 - No files in /var/run/postgresql left behind 324s ok 69 - No files in /var/log/postgresql left behind 324s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 324s ok 71 - PostgreSQL TCP ports are closed 324s === Running test 020_create_sql_remove.t ... === 324s 1..144 324s # Running tests for 12 327s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.RKbN1w 327s ok 2 - pg_createcluster 12 main 327s ok 3 - Socket and pid file are in /var/run/postgresql/ 327s ok 4 - xlog/wal directory /tmp/12.xlog.RKbN1w was created 327s ok 5 - Exactly one postgres master process running 329s ok 6 - pg_ctlcluster 12 main restart 329s ok 7 - cluster restarts with new environment file 329s ok 8 - Exactly one postgres master process running 329s ok 9 - correct value of PGEXTRAVAR1 in environment 329s ok 10 - correct value of PGEXTRAVAR2 in environment 329s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 329s ok 12 - createdb --version 329s ok 13 - pg_wrapper selects version number of cluster 329s ok 14 - psql --version 329s ok 15 - pg_wrapper selects version number of cluster 329s ok 16 - pg_lscluster reports online cluster on port 5432 329s ok 17 - log file is actually used 329s ok 18 - /etc/postgresql is owned by user "postgres" 329s ok 19 - version configuration directory file is owned by user "postgres" 329s ok 20 - configuration directory file is owned by user "postgres" 329s ok 21 - version data directory file is owned by user "postgres" 329s ok 22 - data directory file is owned by user "postgres" 329s ok 23 - log file has 0640 permissions 329s ok 24 - log file is owned by user "postgres" 329s ok 25 - log file is owned by group "adm" 329s ok 26 - no log symlink by default 329s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 329s ok 28 - pg_lsclusters -h 329s ok 29 - correct output of pg_lsclusters -h 329s ok 30 - stopping cluster 331s ok 31 - restarting cluster with nondefault log symlink 331s ok 32 - log target is used as log file 331s ok 33 - default log is not used 331s ok 34 - pg_lsclusters -h 331s ok 35 - correct output of pg_lsclusters -h 332s ok 36 - stopping cluster 334s ok 37 - restarting cluster with explicitly configured log file 334s ok 38 - default log is not used 334s ok 39 - log symlink target is used for startup message 334s ok 40 - exactly one log file 334s ok 41 - custom log is actually used 334s ok 42 - pg_lsclusters -h 334s ok 43 - correct output of pg_lsclusters -h 334s ok 44 - stopping cluster 334s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 334s ok 46 - /etc/postgres-hack was not created 336s ok 47 - restarting cluster 336s ok 48 - ps -o tty -U postgres h 336s ok 49 - postgres processes do not have an associated terminal 336s ok 50 - SSL is enabled 336s ok 51 - psql -l fails for nobody 336s ok 52 - createuser nobody 336s ok 53 - createdb nobodydb 336s ok 54 - psql -ltA succeeds for nobody 336s ok 55 - psql -ltA output 336s ok 56 - SQL command: create table 336s ok 57 - SQL command: insert into table values 336s ok 58 - SQL command: insert into table values 336s ok 59 - primary key violation 336s ok 60 - psql -tAc "select * from phone order by name" nobodydb 336s ok 61 - SQL command output: select -tA 336s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 336s ok 63 - SQL command output: select -tx 336s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 336s ok 65 - SQL command output: select -tAx 336s ok 66 - CREATE EXTENSION plperlu fails for user nobody 337s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 337s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 337s ok 69 - creating PL/PerlU function as user nobody fails 337s ok 70 - creating unsafe PL/Perl function as user postgres fails 337s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 337s ok 72 - creating PL/PerlU function as user postgres succeeds 337s ok 73 - psql nobodydb -Atc "select read_file()" 337s ok 74 - calling PL/PerlU function 337s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 337s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 337s ok 77 - creating unsafe PL/Perl function as user nobody fails 337s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 337s ok 79 - creating PL/Perl function as user nobody succeeds 337s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 337s ok 81 - calling PL/Perl function 337s ok 82 # skip No python2 support 337s ok 83 # skip No python2 support 337s ok 84 # skip No python2 support 337s ok 85 # skip No python2 support 337s ok 86 # skip No python2 support 337s ok 87 # skip No python2 support 337s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 337s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 337s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 337s ok 91 - creating PL/Python3 function as user postgres succeeds 337s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 337s ok 93 - calling PL/Python function 337s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 337s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 337s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 337s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 337s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 337s ok 99 - creating PL/Tcl function as user nobody succeeds 337s 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;" 337s ok 101 - creating PL/TclU function as user postgres succeeds 337s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 337s ok 103 - calling PL/Tcl function 337s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 337s ok 105 - calling PL/TclU function 337s ok 106 - stopping cluster 337s ok 107 - pg_ctlcluster 12 main start 337s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 339s ok 109 - pg_ctlcluster 12 main start 339s ok 110 - cluster restarts with pgdata symlink 340s ok 111 - postgres master has OOM killer protection 340s ok 112 - postgres client backend has no OOM adjustment 340s ok 113 - ps h 7230 340s ok 114 - process title is idle 340s ok 115 - ps h 7230 340s ok 116 - process title is idle in transaction 341s ok 117 - ps h 7230 341s ok 118 - process title is SELECT 343s ok 119 - dropdb nobodydb 343s ok 120 - dropuser nobody 343s ok 121 - stopping cluster 345s ok 122 - starting cluster as postgres works without a log file 345s ok 123 - log file got recreated and used 345s ok 124 - creating a directory in spc2 345s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.nynWgH'" 345s ok 126 - creating tablespace spc1 345s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 345s ok 128 - creating a table in spc1 345s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.T22wRF'" 345s ok 130 - creating tablespace spc2 345s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 345s ok 132 - creating a table in spc2 346s ok 133 - pg_dropcluster removes cluster 346s ok 134 - xlog/wal directory /tmp/12.xlog.RKbN1w was deleted 346s ok 135 - tablespace spc1 was emptied 346s ok 136 - tablespace spc2 was emptied 346s ok 137 - Cleanup: No clusters left behind 346s ok 138 - No postgres processes left behind 346s ok 139 - No files in /etc/postgresql left behind 346s ok 140 - No files in /var/lib/postgresql left behind 346s ok 141 - No files in /var/run/postgresql left behind 346s ok 142 - No files in /var/log/postgresql left behind 346s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 346s ok 144 - PostgreSQL TCP ports are closed 346s === Running test 021_pg_renamecluster.t ... === 346s 1..20 349s ok 1 - pg_createcluster 12 main 351s ok 2 - pg_renamecluster 12 main donau 351s ok 3 - psql -tAc "show data_directory" 351s ok 4 - cluster is running and data_directory was moved 351s ok 5 - pg_hba.conf location updated 351s ok 6 - pg_ident.conf location updated 351s ok 7 - external_pid_file location updated 351s ok 8 - external_pid_file exists 351s ok 9 - stats_temp_directory location updated 351s ok 10 - stats_temp_directory exists 351s ok 11 - cluster_name is updated 352s ok 12 - pg_dropcluster removes cluster 352s ok 13 - Cleanup: No clusters left behind 352s ok 14 - No postgres processes left behind 352s ok 15 - No files in /etc/postgresql left behind 352s ok 16 - No files in /var/lib/postgresql left behind 352s ok 17 - No files in /var/run/postgresql left behind 352s ok 18 - No files in /var/log/postgresql left behind 352s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 352s ok 20 - PostgreSQL TCP ports are closed 352s === Running test 022_recovery.t ... === 352s 1..17 352s # Running tests for 12 355s ok 1 - pg_createcluster 12 main --start >/dev/null 355s ok 2 - pg_ctlcluster 12 main stop -m i 357s ok 3 - pg_ctlcluster 12 main start 357s ok 4 - psql -c '' 357s ok 5 - pg_ctlcluster 12 main stop -m i 357s ok 6 - create write-protected file in data directory 360s ok 7 - pg_ctlcluster 12 main start 360s ok 8 - psql -c '' 360s ok 9 - pg_dropcluster removes cluster 360s ok 10 - Cleanup: No clusters left behind 360s ok 11 - No postgres processes left behind 360s ok 12 - No files in /etc/postgresql left behind 360s ok 13 - No files in /var/lib/postgresql left behind 360s ok 14 - No files in /var/run/postgresql left behind 360s ok 15 - No files in /var/log/postgresql left behind 360s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 360s ok 17 - PostgreSQL TCP ports are closed 360s === Running test 025_logging.t ... === 360s 1..55 361s # Logging to /var/log/syslog works 361s # Running tests for 12 364s ok 1 - pg_createcluster 12 main 364s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 364s ok 3 - psql -qc "'foobar_12_7885'" 364s ok 4 - log an error 364s ok 5 - grep --binary-files=text foobar_12_7885 /var/log/postgresql/postgresql-12-main.log 364s ok 6 - error appears in logfile 364s ok 7 - pg_conftool 12 main set log_destination syslog 364s ok 8 - set log_destination syslog 364s ok 9 - pg_ctlcluster 12 main reload 364s ok 10 - 12 main reload 364s ok 11 - psql -Atc "show log_destination" 364s ok 12 - log_destination is syslog 364s ok 13 - pg_lscluster reports syslog 364s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 364s ok 15 - error appears in /var/log/syslog 364s ok 16 - pg_conftool 12 main set logging_collector on 364s ok 17 - set logging_collector on 364s ok 18 - pg_conftool 12 main set log_destination csvlog 364s ok 19 - set log_destination csvlog 367s ok 20 - pg_ctlcluster 12 main restart 367s ok 21 - 12 main restart 367s ok 22 - psql -Atc "show logging_collector" 367s ok 23 - logging_collector is on 367s ok 24 - psql -Atc "show log_destination" 367s ok 25 - log_destination is csvlog 367s ok 26 - pg_lscluster reports csvlog 367s ok 27 - psql -qc "'barbaz_12_7885'" 367s ok 28 - log an error 367s ok 29 - grep --binary-files=text barbaz_12_7885 /var/lib/postgresql/12/main/log/*.csv 367s ok 30 - error appears in log/*.csv 367s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 367s ok 32 - set log_destination stderr,syslog,csvlog 367s ok 33 - pg_ctlcluster 12 main reload 367s ok 34 - 12 main reload 367s ok 35 - psql -Atc "show log_destination" 367s ok 36 - log_destination is stderr,syslog,csvlog 367s ok 37 - pg_lscluster reports stderr,syslog,csvlog 367s ok 38 - psql -qc "'moo_12_7885'" 367s ok 39 - log an error 367s ok 40 - grep --binary-files=text moo_12_7885 /var/lib/postgresql/12/main/log/*.log 367s ok 41 - error appears in log/*.log 367s ok 42 - grep --binary-files=text 'postgres.*moo_12_7885' /var/log/syslog 367s ok 43 - error appears in /var/log/syslog 367s ok 44 - grep --binary-files=text moo_12_7885 /var/lib/postgresql/12/main/log/*.csv 367s ok 45 - error appears in log/*.csv 368s ok 46 - pg_dropcluster 12 main --stop 368s ok 47 - pg_dropcluster removes cluster 368s ok 48 - Cleanup: No clusters left behind 368s ok 49 - No postgres processes left behind 368s ok 50 - No files in /etc/postgresql left behind 368s ok 51 - No files in /var/lib/postgresql left behind 368s ok 52 - No files in /var/run/postgresql left behind 368s ok 53 - No files in /var/log/postgresql left behind 368s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 368s ok 55 - PostgreSQL TCP ports are closed 368s === Running test 030_errors.t ... === 368s 1..149 368s ok 1 - pg_lscluster reports cluster without binaries 368s ok 2 - pg_dropcluster 6.3 main 369s ok 3 - pg_createcluster --socketdir 369s ok 4 - pg_lsclusters -h 369s ok 5 - cluster was created 369s ok 6 - Port of created cluster is 5432 369s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 369s ok 8 - pg_createcluster on existing cluster 369s ok 9 - pg_lsclusters -h 369s ok 10 - original cluster still exists 369s ok 11 - pg_createcluster 12 test -p foo 369s ok 12 - pg_createcluster -p checks that port option is numeric 369s ok 13 - pg_createcluster 12 test -p 42 369s ok 14 - pg_createcluster -p checks valid port range 369s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 369s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 369s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 371s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 371s ok 19 - No sockets in /var/run/postgresql 371s ok 20 - Socket is in /tmp/postgresql-testsuite/ 371s ok 21 - cluster stops with custom unix_socket_dir 371s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 373s ok 23 - cluster starts after removing unix_socket_dir 373s ok 24 - Socket is in default dir /var/run/postgresql 373s ok 25 - No sockets in /tmp/postgresql-testsuite/ 373s ok 26 - pg_ctlcluster 12 main stop 373s ok 27 - pg_ctlcluster fails with corrupted PID file 373s ok 28 - pg_lsclusters -h 373s ok 29 - cluster is still online 374s ok 30 - pg_ctlcluster succeeds with restored PID file 374s ok 31 - pg_lsclusters -h 374s ok 32 - cluster is down 374s ok 33 - pg_ctlcluster 12 main stop 374s ok 34 - pg_ctlcluster stop fails on stopped cluster 376s ok 35 - pg_ctlcluster 12 main start 376s ok 36 - pg_ctlcluster succeeds with already existing PID file 376s ok 37 - pg_lsclusters -h 376s ok 38 - cluster is online 376s ok 39 - pg_ctlcluster stop succeeds 376s ok 40 - pg_lsclusters -h 376s ok 41 - cluster is down 376s ok 42 - no pid file left 376s ok 43 - pg_ctlcluster 12 main stop 376s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 376s ok 45 - pid file was cleaned up 376s ok 46 - pg_ctlcluster --force 12 main stop 376s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 376s ok 48 - pid file was cleaned up 376s ok 49 - pg_ctlcluster 12 main stop 376s ok 50 - pg_ctlcluster stop succeeds with stale PID file 376s ok 51 - pid file was cleaned up 376s ok 52 - pg_ctlcluster --force 12 main stop 376s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 376s ok 54 - pid file was cleaned up 376s ok 55 - pg_ctlcluster --force 12 main stop 376s ok 56 - pg_ctlcluster stop succeeds with empty PID file 376s ok 57 - pid file was cleaned up 378s ok 58 - pg_ctlcluster 12 main start 378s ok 59 - pg_ctlcluster succeeds with corrupted PID file 378s ok 60 - pg_lsclusters -h 378s ok 61 - cluster is online 378s ok 62 - pg_ctlcluster 12 main start 378s ok 63 - pg_ctlcluster start fails on running cluster 378s ok 64 - pg_ctlcluster stop 379s ok 65 - pg_ctlcluster 12 main start 379s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 379s ok 67 - pg_ctlcluster 12 main stop 379s ok 68 - stopping cluster 385s ok 69 - pg_ctlcluster 12 main start 385s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 385s ok 71 - pg_ctlcluster 12 main stop 385s ok 72 - stopping cluster 385s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 385s ok 74 - pg_dropcluster 12 main 385s ok 75 - pg_dropcluster works as user postgres 386s ok 76 - pg_createcluster succeeds 386s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 386s ok 78 - proper error message for nonexisting /var/lib/postgresql 388s ok 79 - pg_ctlcluster 12 main start 388s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 388s ok 81 - pg_ctlcluster 12 main stop 388s ok 82 - stopping cluster 389s ok 83 - pg_createcluster other 391s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 393s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 393s ok 86 393s ok 87 - pg_ctlcluster 12 other start 393s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 393s ok 89 - pg_ctlcluster 12 main stop 393s ok 90 - stopping main cluster 395s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 396s ok 92 - pg_dropcluster other 396s ok 93 - pg_dropcluster 396s ok 94 - No sockets any more 396s ok 95 - 'pg_lsclusters 4.5 foo' fails 396s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 396s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 396s ok 98 - 'psql --cluster 4.5/foo' fails 396s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 396s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 396s ok 101 - 'psql --cluster 12/foo' fails 396s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 396s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 396s ok 104 - 'pg_dropcluster 4.5 foo' fails 396s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 396s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 396s ok 107 - 'pg_dropcluster 12 foo' fails 396s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 396s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 396s ok 110 - 'pg_upgradecluster 4.5 foo' fails 396s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 396s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 396s ok 113 - 'pg_upgradecluster 12 foo' fails 396s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 396s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 396s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 396s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 396s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 396s ok 119 - 'pg_ctlcluster 12 foo stop' fails 396s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 396s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 396s ok 122 - Cleanup: No clusters left behind 396s ok 123 - No postgres processes left behind 396s ok 124 - No files in /etc/postgresql left behind 396s ok 125 - No files in /var/lib/postgresql left behind 396s ok 126 - No files in /var/run/postgresql left behind 396s ok 127 - No files in /var/log/postgresql left behind 396s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 396s ok 129 - PostgreSQL TCP ports are closed 396s ok 130 - pg_dropcluster 12 broken 396s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 396s ok 132 - Cleanup: No clusters left behind 396s ok 133 - No postgres processes left behind 396s ok 134 - No files in /etc/postgresql left behind 396s ok 135 - No files in /var/lib/postgresql left behind 396s ok 136 - No files in /var/run/postgresql left behind 396s ok 137 - No files in /var/log/postgresql left behind 396s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 396s ok 139 - PostgreSQL TCP ports are closed 396s ok 140 - pg_dropcluster 12 broken 396s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 396s ok 142 - Cleanup: No clusters left behind 396s ok 143 - No postgres processes left behind 396s ok 144 - No files in /etc/postgresql left behind 396s ok 145 - No files in /var/lib/postgresql left behind 396s ok 146 - No files in /var/run/postgresql left behind 396s ok 147 - No files in /var/log/postgresql left behind 396s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 396s ok 149 - PostgreSQL TCP ports are closed 396s === Running test 031_errors_disk_full.t ... === 397s 1..22 397s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 397s ok 1 - script failed 397s ok 2 - pg_createcluster fails due to insufficient disk space 397s ok 3 - does not leave files behind 397s ok 4 - Cleanup: No clusters left behind 397s ok 5 - No postgres processes left behind 397s ok 6 - No files in /etc/postgresql left behind 397s ok 7 - No files in /var/lib/postgresql left behind 397s ok 8 - No files in /var/run/postgresql left behind 397s ok 9 - No files in /var/log/postgresql left behind 397s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 397s ok 11 - PostgreSQL TCP ports are closed 397s # check disk full conditions on startup 398s ok 12 - script failed 398s ok 13 - pg_ctlcluster prints error message 398s ok 14 - log file has error message 398s ok 15 - Cleanup: No clusters left behind 398s ok 16 - No postgres processes left behind 398s ok 17 - No files in /etc/postgresql left behind 398s ok 18 - No files in /var/lib/postgresql left behind 398s ok 19 - No files in /var/run/postgresql left behind 398s ok 20 - No files in /var/log/postgresql left behind 398s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 398s ok 22 - PostgreSQL TCP ports are closed 398s === Running test 032_ssl_key_permissions.t ... === 398s 1..22 398s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 398s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 398s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 398s # 12 (12.22-0ubuntu0.20.04.3) 398s ok 4 - pg_createcluster 12 main 399s ok 5 - pg_ctlcluster 12 main start 399s ok 6 - ssl key owned by nobody refused 399s ok 7 - pg_ctlcluster 12 main start 399s ok 8 - ssl key with permissions root:root 0644 refused 399s ok 9 - pg_ctlcluster 12 main start 399s ok 10 - ssl key with permissions postgres:postgres 0640 refused 399s ok 11 - pg_dropcluster 12 main --stop 399s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 399s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 399s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 399s ok 15 - Cleanup: No clusters left behind 399s ok 16 - No postgres processes left behind 399s ok 17 - No files in /etc/postgresql left behind 399s ok 18 - No files in /var/lib/postgresql left behind 399s ok 19 - No files in /var/run/postgresql left behind 399s ok 20 - No files in /var/log/postgresql left behind 399s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 399s ok 22 - PostgreSQL TCP ports are closed 399s === Running test 040_upgrade.t ... === 399s 1..1 399s ok 1 - only one major version installed, skipping upgrade tests 399s === Running test 041_upgrade_custompaths.t ... === 399s 1..1 399s ok 1 - only one major version installed, skipping upgrade tests 399s === Running test 043_upgrade_ssl_cert.t ... === 399s 1..1 399s ok 1 - only one major version installed, skipping upgrade tests 399s === Running test 050_encodings.t ... === 399s 1..60 399s # Checking 12 ru_RU 402s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 403s ok 2 - psql -l succeeds 403s ok 3 - template1 is not UTF-8 encoded 403s ok 4 - creating test database 403s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 403s # create table t (x varchar); copy t from stdin" test 403s ok 6 - creating table with ISO-8859-5 characters 403s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 403s ok 8 - correct string in UTF-8 403s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 403s ok 10 - correct string in ISO-8859-5 403s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 403s # delete from t; copy t from stdin" test 403s ok 12 - creating table with UTF-8 characters 403s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 403s ok 14 - correct string in UTF-8 403s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 403s ok 16 - correct string in ISO-8859-1 403s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 403s ok 18 - Server error message has correct language and encoding 406s ok 19 - pg_ctlcluster 12 ru_RU restart 406s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 406s ok 21 - Dropping cluster 406s # Checking 12 ru_RU.UTF-8 409s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 410s ok 23 - psql -l succeeds 410s ok 24 - template1 is UTF-8 encoded 410s ok 25 - creating test database 410s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 410s # create table t (x varchar); copy t from stdin" test 410s ok 27 - creating table with ISO-8859-5 characters 410s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 410s ok 29 - correct string in UTF-8 410s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 410s ok 31 - correct string in ISO-8859-5 410s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 410s # delete from t; copy t from stdin" test 410s ok 33 - creating table with UTF-8 characters 410s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 410s ok 35 - correct string in UTF-8 410s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 410s ok 37 - correct string in ISO-8859-1 410s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 410s ok 39 - Server error message has correct language and encoding 413s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 413s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 413s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 413s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 413s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 413s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 413s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 413s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 413s ok 48 - Dropping cluster 413s # Check 12 locale environment variables 416s ok 49 - pg_createcluster: LC_ALL dominates LANG 416s ok 50 - psql -Atl --cluster 12/main 416s ok 51 - template1 is ASCII encoded 416s ok 52 - Dropping cluster 416s ok 53 - Cleanup: No clusters left behind 416s ok 54 - No postgres processes left behind 416s ok 55 - No files in /etc/postgresql left behind 416s ok 56 - No files in /var/lib/postgresql left behind 416s ok 57 - No files in /var/run/postgresql left behind 416s ok 58 - No files in /var/log/postgresql left behind 416s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 416s ok 60 - PostgreSQL TCP ports are closed 416s === Running test 052_upgrade_encodings.t ... === 416s 1..1 416s ok 1 - only one major version installed, skipping upgrade tests 416s === Running test 060_obsolete_confparams.t ... === 416s 1..1 416s ok 1 - only one major version installed, skipping upgrade tests 416s === Running test 070_non_postgres_clusters.t ... === 416s 1..40 417s ok 1 - pg_createcluster 12 main for owner nobody 417s ok 2 - pg_ctlcluster 12 main start 417s ok 3 - start refused when config and data owners mismatch 419s ok 4 - pg_ctlcluster succeeds with owner nobody 419s ok 5 - pg_lsclusters -h 419s ok 6 - pg_lsclusters shows running cluster 419s ok 7 - postgres is running as user nobody 419s ok 8 - ls /tmp/.s.PGSQL.* 419s ok 9 - socket is in /tmp 419s ok 10 - /var/run/postgresql is empty 419s ok 11 - conf dir is owned by user 419s ok 12 - conf dir is owned by user's primary group 419s ok 13 - files are owned by user 419s ok 14 - files are owned by user's primary group 419s ok 15 - log file has 0640 permissions 419s ok 16 - log file is owned by user 419s ok 17 - log file is owned by user's primary group 419s ok 18 - only one major version installed, skipping upgrade test 419s ok 19 - ... 419s ok 20 - ... 419s ok 21 - ... 419s ok 22 - ... 419s ok 23 - ... 419s ok 24 - ... 419s ok 25 - ... 419s ok 26 - ... 419s ok 27 - ... 419s ok 28 - ... 420s ok 29 - pg_dropcluster 420s ok 30 - pg_lsclusters -h 420s ok 31 - No clusters left 420s ok 32 - No postgres processes left 420s ok 33 - Cleanup: No clusters left behind 420s ok 34 - No postgres processes left behind 420s ok 35 - No files in /etc/postgresql left behind 420s ok 36 - No files in /var/lib/postgresql left behind 420s ok 37 - No files in /var/run/postgresql left behind 420s ok 38 - No files in /var/log/postgresql left behind 420s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 420s ok 40 - PostgreSQL TCP ports are closed 420s === Running test 080_start.conf.t ... === 420s 1..73 420s ok 1 - pg_createcluster 12 main 420s # start.conf auto 420s ok 2 - get_cluster_start_conf returns auto 420s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 420s ok 4 - start.conf contains auto 420s ok 5 - systemd generator links cluster 420s ok 6 - systemd generator links correct service file 423s ok 7 - /etc/init.d/postgresql start 12 423s ok 8 - correct output of /etc/init.d/postgresql start 12 423s ok 9 - pg_lsclusters -h 423s ok 10 - cluster is online 423s ok 11 - /etc/init.d/postgresql stop 12 423s ok 12 - correct output of /etc/init.d/postgresql stop 12 426s ok 13 - pg_lsclusters -h 426s ok 14 - cluster is down 426s # start.conf manual 426s ok 15 - get_cluster_start_conf returns manual 426s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 426s ok 17 - start.conf contains manual 426s ok 18 - systemd generator doesn't link cluster 426s ok 19 - /etc/init.d/postgresql start 12 426s ok 20 - correct output of /etc/init.d/postgresql start 12 426s ok 21 - pg_lsclusters -h 426s ok 22 - cluster is down 428s ok 23 - pg_ctlcluster 12 main start 428s ok 24 - correct output of pg_ctlcluster 12 main start 428s ok 25 - pg_lsclusters -h 428s ok 26 - cluster is online 428s ok 27 - pg_ctlcluster 12 main stop 428s ok 28 - correct output of pg_ctlcluster 12 main stop 428s ok 29 - pg_lsclusters -h 428s ok 30 - cluster is down 428s # start.conf disabled 428s ok 31 - get_cluster_start_conf returns disabled 428s ok 32 - systemd generator doesn't link cluster 428s ok 33 - /etc/init.d/postgresql start 12 428s ok 34 - correct output of /etc/init.d/postgresql start 12 428s ok 35 - pg_lsclusters -h 428s ok 36 - cluster is down 428s ok 37 - pg_ctlcluster 12 main start 428s ok 38 - correct output of pg_ctlcluster 12 main start 428s ok 39 - pg_lsclusters -h 428s ok 40 - cluster is down 431s ok 41 - pg_ctlcluster 12 main start 431s ok 42 - correct output of pg_ctlcluster 12 main start 431s ok 43 - pg_lsclusters -h 431s ok 44 - cluster is online 431s ok 45 - pg_ctlcluster 12 main stop 431s ok 46 - correct output of pg_ctlcluster 12 main stop 431s ok 47 - pg_lsclusters -h 431s ok 48 - cluster is down 433s ok 49 - pg_ctlcluster 12 main start 433s ok 50 - correct output of pg_ctlcluster 12 main start 433s ok 51 - pg_lsclusters -h 433s ok 52 - cluster is online 433s # test upgrade 433s ok 53 - only one major version installed, skipping upgrade test 433s ok 54 - ... 433s ok 55 - get_cluster_start_conf for old cluster returns manual 433s ok 56 - get_cluster_start_conf for new cluster returns manual 433s ok 57 - ... 433s ok 58 - dropping upgraded cluster 433s ok 59 - pg_lsclusters -h 433s ok 60 - no clusters any more 433s ok 61 - pg_createcluster 12 main --start-conf foo 433s ok 62 - pg_createcluster checks --start-conf validity 434s ok 63 - pg_createcluster checks --start-conf manual 434s ok 64 - get_cluster_start_conf returns manual 434s ok 65 - dropping cluster 434s ok 66 - Cleanup: No clusters left behind 434s ok 67 - No postgres processes left behind 434s ok 68 - No files in /etc/postgresql left behind 434s ok 69 - No files in /var/lib/postgresql left behind 434s ok 70 - No files in /var/run/postgresql left behind 434s ok 71 - No files in /var/log/postgresql left behind 434s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 434s ok 73 - PostgreSQL TCP ports are closed 434s === Running test 085_pg_ctl.conf.t ... === 434s 1..29 434s ok 1 - pg_createcluster 12 main 434s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 437s ok 3 - pg_ctlcluster 12 main start 437s ok 4 - starting cluster 437s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 437s ok 6 - soft core size is 0 437s ok 7 - set pg_ctl default option to -c 439s ok 8 - pg_ctlcluster 12 main restart 439s ok 9 - restarting cluster 439s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 439s ok 11 - soft core size is unlimited 439s ok 12 - restored pg_ctl default option 441s ok 13 - pg_ctlcluster 12 main restart 441s ok 14 - restarting cluster 441s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 441s ok 16 - soft core size is 0 444s ok 17 - pg_ctlcluster 12 main restart -- -c 444s ok 18 - restarting cluster with -c on the command line 444s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 444s ok 20 - soft core size is unlimited 444s ok 21 - dropping cluster 444s ok 22 - Cleanup: No clusters left behind 444s ok 23 - No postgres processes left behind 444s ok 24 - No files in /etc/postgresql left behind 444s ok 25 - No files in /var/lib/postgresql left behind 444s ok 26 - No files in /var/run/postgresql left behind 444s ok 27 - No files in /var/log/postgresql left behind 444s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 444s ok 29 - PostgreSQL TCP ports are closed 444s === Running test 090_multicluster.t ... === 444s 1..125 445s ok 1 - pg_createcluster 12 old 445s ok 2 - pg_createcluster 12 new1 446s ok 3 - pg_createcluster 12 new2 448s ok 4 - starting cluster 12/old 450s ok 5 - starting cluster 12/new1 452s ok 6 - starting cluster 12/new2 452s ok 7 - pg_lsclusters -h | sort -k3 452s ok 8 - clusters have the correct ports, skipping used 5433 452s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 452s ok 10 - createdb --version 452s ok 11 - pg_wrapper selects port 5432 as default cluster 452s ok 12 - createdb --cluster 12/new1 --version 452s ok 13 - pg_wrapper --cluster works 452s ok 14 - createdb --cluster 12/foo --version 452s ok 15 - pg_wrapper --cluster errors out for invalid cluster 453s ok 16 - createdb --cluster 12/new1 test 453s ok 17 - correct output of createdb --cluster 12/new1 test 453s ok 18 - psql -Atl --cluster 12/new1 453s ok 19 - test db appears in cluster new1 453s ok 20 - psql -Atl --cluster 12/new2 453s ok 21 - test db does not appear in cluster new2 453s ok 22 - psql -Atl 453s ok 23 - test db does not appear in default cluster 453s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 453s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 453s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 453s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 453s ok 28 - psql -Atl --cluster 12/localhost:5434 453s ok 29 - test db appears in cluster 12/localhost:5434 453s ok 30 - psql -Atl --cluster 12/localhost:5440 453s ok 31 - test db does not appear in cluster 12/localhost:5440 453s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 453s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 453s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 453s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 453s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 453s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 453s ok 38 - psql -Atl --cluster 6.4/localhost: 453s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 453s ok 40 - psql -Atl 453s ok 41 - PGCLUSTER selection (1) 453s ok 42 - psql -Atl 453s ok 43 - PGCLUSTER selection (2) 453s ok 44 - psql -l 453s ok 45 - invalid PGCLUSTER value 453s ok 46 - createdb --version 453s ok 47 - PGCLUSTER network cluster selection (1) 453s ok 48 - psql -Atl 453s ok 49 - PGCLUSTER network cluster selection (2) 453s ok 50 - psql -Atl 453s ok 51 - PGCLUSTER network cluster selection (3) 453s ok 52 - LC_MESSAGES=C psql -Atl 453s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 453s ok 54 - psql -Atc "show port" template1 453s ok 55 - PGPORT selection (1) 453s ok 56 - psql -Atc "show port" template1 453s ok 57 - PGPORT selection (2) 453s ok 58 - createdb --version 453s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 453s ok 60 - psql -Atc "show port" template1 453s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 453s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 453s ok 63 - PGDATABASE environment variable works 453s ok 64 - createdb --version 453s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 453s ok 66 - createdb --cluster 12/new1 --version 453s ok 67 - pg_wrapper --cluster works with empty user_clusters 453s ok 68 - createdb --version 453s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 453s ok 70 - psql -Atc "select current_database()" 453s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 453s ok 72 - psql -Atc 'select current_database()' 453s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 453s ok 74 - createdb --version 453s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 453s ok 76 - createdb --version 453s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 453s ok 78 - createdb --version 453s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 453s ok 80 - createdb --version 453s ok 81 - pg_wrapper selects correct version with per-user user_clusters 453s ok 82 - createdb --version 453s ok 83 - pg_wrapper selects correct version with per-user user_clusters 453s ok 84 - createdb --version 453s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 453s ok 86 - psql -Atl 453s ok 87 - $PGHOST overrides user_clusters 453s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 453s ok 89 - --cluster overrides $PGHOST 453s ok 90 - createdb --version 453s ok 91 - pg_wrapper ignores invalid lines in user_clusters 454s ok 92 - psql -Atc 'select current_database()' 454s ok 93 - pg_service conf selection 1 454s ok 94 - psql -Atc 'select current_database()' 454s ok 95 - pg_service conf selection 2 454s ok 96 - psql -Atc 'select current_database()' 454s ok 97 - pg_service conf selection 3 454s ok 98 - stopping cluster 12/old 456s ok 99 - restarting cluster 12/old 456s ok 100 - pg_lsclusters -h | sort -k3 456s ok 101 - port of first cluster was successfully changed 456s ok 102 - psql -l 456s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 456s ok 104 - psql -Atl --cluster 12/new1 456s ok 105 - --cluster selects appropriate cluster 456s ok 106 - psql -Atl -p 5434 456s ok 107 - -p selects appropriate cluster 456s ok 108 - psql -Atlp 5434 456s ok 109 - -Atlp selects appropriate cluster 456s ok 110 - psql -Atl --port 5434 456s ok 111 - --port selects appropriate cluster 456s ok 112 - env PGPORT=5434 psql -Atl 456s ok 113 - $PGPORT selects appropriate cluster 456s ok 114 - Restoring original /etc/postgresql-common/user_clusters 456s ok 115 - dropping 12/new1 457s ok 116 - dropping 12/new2 457s ok 117 - dropping 12/old 457s ok 118 - Cleanup: No clusters left behind 457s ok 119 - No postgres processes left behind 457s ok 120 - No files in /etc/postgresql left behind 457s ok 121 - No files in /var/lib/postgresql left behind 457s ok 122 - No files in /var/run/postgresql left behind 457s ok 123 - No files in /var/log/postgresql left behind 457s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 457s ok 125 - PostgreSQL TCP ports are closed 457s === Running test 100_upgrade_scripts.t ... === 457s 1..27 460s ok 1 - pg_createcluster 12 main 460s ok 2 - createdb --cluster 12/main db1 460s ok 3 - correct output of createdb --cluster 12/main db1 460s ok 4 - createdb --cluster 12/main db2 460s ok 5 - correct output of createdb --cluster 12/main db2 460s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 460s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 460s ok 8 - get_cluster_databases() works 460s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 461s ok 10 - run-upgrade-scripts succeeds 461s ok 11 - correct run-upgrade-script output 461s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 461s ok 13 - check SQL scripts results in 12/main db1 461s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 461s ok 15 - check SQL scripts results in 12/main db2 461s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 461s ok 17 - check shell scripts results in $v/main 461s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 462s ok 19 - pg_dropcluster 12 main 462s ok 20 - Cleanup: No clusters left behind 462s ok 21 - No postgres processes left behind 462s ok 22 - No files in /etc/postgresql left behind 462s ok 23 - No files in /var/lib/postgresql left behind 462s ok 24 - No files in /var/run/postgresql left behind 462s ok 25 - No files in /var/log/postgresql left behind 462s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 462s ok 27 - PostgreSQL TCP ports are closed 462s === Running test 110_integrate_cluster.t ... === 462s 1..32 462s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/b3vO2ou5AS/c/postgres 462s ok 2 - creating raw initdb cluster for user postgres 463s ok 3 - pg_createcluster 12 postgres -d /tmp/b3vO2ou5AS/c/postgres 463s ok 4 - integrating postgres cluster 463s ok 5 - pg_lsclusters 463s ok 6 - correct pg_lsclusters output 465s ok 7 - pg_ctlcluster 12 postgres start 465s ok 8 - starting cluster postgres 465s ok 9 - pg_lsclusters 465s ok 10 - correct pg_lsclusters output 465s ok 11 - dropping cluster postgres 465s ok 12 - No files in temporary cluster dir left behind 466s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/b3vO2ou5AS/c/nobody 466s ok 14 - creating raw initdb cluster for user nobody 466s ok 15 - pg_createcluster 12 nobody -d /tmp/b3vO2ou5AS/c/nobody 466s ok 16 - integrating nobody cluster 466s ok 17 - pg_lsclusters 466s ok 18 - correct pg_lsclusters output 468s ok 19 - pg_ctlcluster 12 nobody start 468s ok 20 - starting cluster nobody 468s ok 21 - pg_lsclusters 468s ok 22 - correct pg_lsclusters output 468s ok 23 - dropping cluster nobody 468s ok 24 - No files in temporary cluster dir left behind 468s ok 25 - Cleanup: No clusters left behind 468s ok 26 - No postgres processes left behind 468s ok 27 - No files in /etc/postgresql left behind 468s ok 28 - No files in /var/lib/postgresql left behind 468s ok 29 - No files in /var/run/postgresql left behind 468s ok 30 - No files in /var/log/postgresql left behind 468s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 468s ok 32 - PostgreSQL TCP ports are closed 468s === Running test 120_pg_upgradecluster_scripts.t ... === 468s 1..1 468s ok 1 - only one major version installed, skipping upgrade tests 468s === Running test 130_nonroot_admin.t ... === 469s 1..22 471s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 471s ok 2 - pg_lsclusters -h 471s ok 3 - correct output of pg_lsclusters -h 471s ok 4 - psql -Atl 471s ok 5 - correct output of psql -Atl 471s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 471s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 471s ok 15 - Cleanup: No clusters left behind 471s ok 16 - No postgres processes left behind 471s ok 17 - No files in /etc/postgresql left behind 471s ok 18 - No files in /var/lib/postgresql left behind 471s ok 19 - No files in /var/run/postgresql left behind 471s ok 20 - No files in /var/log/postgresql left behind 471s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 471s ok 22 - PostgreSQL TCP ports are closed 471s === Running test 135_pg_virtualenv.t ... === 471s 1..20 475s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 475s ok 2 - running pg_virtualenv as root 478s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 478s ok 4 - running pg_virtualenv as postgres 481s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 481s ok 6 - running pg_virtualenv as nobody 484s ok 7 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 484s ok 8 - running fakeroot pg_virtualenv as root 487s ok 9 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 487s ok 10 - running fakeroot pg_virtualenv as postgres 490s ok 11 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 490s ok 12 - running fakeroot pg_virtualenv as nobody 490s ok 13 - Cleanup: No clusters left behind 490s ok 14 - No postgres processes left behind 490s ok 15 - No files in /etc/postgresql left behind 490s ok 16 - No files in /var/lib/postgresql left behind 490s ok 17 - No files in /var/run/postgresql left behind 490s ok 18 - No files in /var/log/postgresql left behind 490s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 490s ok 20 - PostgreSQL TCP ports are closed 490s === Running test 140_pg_config.t ... === 490s 1..38 490s # Multiarch is enabled 490s # checking version specific output for 12 490s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 490s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 490s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 490s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 490s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 490s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 490s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 490s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 490s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 490s # checking pg_config output (should behave like version 12) 490s ok 15 - pg_config 490s ok 16 - correct output of pg_config 490s ok 17 - pg_config --help 490s ok 18 - correct output of pg_config --help 490s ok 19 - pg_config --pgxs 490s ok 20 - correct output of pg_config --pgxs 490s ok 21 - pg_config --libdir 490s ok 22 - correct output of pg_config --libdir 490s ok 23 - pg_config --pkglibdir 490s ok 24 - correct output of pg_config --pkglibdir 490s ok 25 - pg_config --bindir 490s ok 26 - correct output of pg_config --bindir 490s # checking pg_config.libpq-dev output (should behave like version 12) 490s ok 27 - pg_config.libpq-dev 490s ok 28 - correct output of pg_config.libpq-dev 490s ok 29 - pg_config.libpq-dev --help 490s ok 30 - correct output of pg_config.libpq-dev --help 490s ok 31 - pg_config.libpq-dev --pgxs 490s ok 32 - correct output of pg_config.libpq-dev --pgxs 490s ok 33 - pg_config.libpq-dev --libdir 490s ok 34 - correct output of pg_config.libpq-dev --libdir 490s ok 35 - pg_config.libpq-dev --pkglibdir 490s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 490s ok 37 - pg_config.libpq-dev --bindir 490s ok 38 - correct output of pg_config.libpq-dev --bindir 490s === Running test 150_tsearch_stemming.t ... === 490s 1..37 490s ok 1 - pg_updatedicts succeeded 490s ok 2 - pg_updatedicts created en_us.affix 490s ok 3 - pg_updatedicts created en_us.dict 490s ok 4 - pg_updatedicts created 12 en_us.affix symlink 490s ok 5 - pg_updatedicts created 12 en_us.dict symlink 493s ok 6 - pg_createcluster 12 main 493s ok 7 - createdb fts 493s ok 8 - correct output of createdb fts 493s ok 9 - creating en_US full text search configuration 493s ok 10 - creating data table and search index 493s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 493s ok 12 - stem search of correct word 493s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 493s ok 14 - stem search of correct word 493s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 493s ok 16 - stem search of unknown word 493s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 493s ok 18 - full text search, exact word 493s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 493s ok 20 - full text search for word stem 493s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 493s ok 22 - full text search for word substring fails 493s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 493s ok 24 - full text search, exact unicode word 493s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 493s ok 26 - full text search for unicode word stem 493s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 493s ok 28 - full text search for unicode word substring fails 494s ok 29 494s ok 30 - Cleanup: No clusters left behind 494s ok 31 - No postgres processes left behind 494s ok 32 - No files in /etc/postgresql left behind 494s ok 33 - No files in /var/lib/postgresql left behind 494s ok 34 - No files in /var/run/postgresql left behind 494s ok 35 - No files in /var/log/postgresql left behind 494s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 494s ok 37 - PostgreSQL TCP ports are closed 494s === Running test 160_alternate_confroot.t ... === 494s 1..28 496s ok 1 496s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 496s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 496s ok 4 - pg_lsclusters -h 496s ok 5 - correct output of pg_lsclusters -h 496s ok 6 - psql -Atl 496s ok 7 - correct output of psql -Atl 496s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 496s ok 9 - ... 496s ok 10 - ... 496s ok 11 - ... 496s ok 12 - ... 496s ok 13 - ... 496s ok 14 - ... 497s ok 15 - pg_dropcluster 12 test --stop 497s ok 16 - correct output of pg_dropcluster 12 test --stop 497s ok 17 - pg_lsclusters -h 497s ok 18 - correct output of pg_lsclusters -h 497s ok 19 - No files in root/data left behind 497s ok 20 - No cruft in root dir left behind 497s ok 21 - Cleanup: No clusters left behind 497s ok 22 - No postgres processes left behind 497s ok 23 - No files in /etc/postgresql left behind 497s ok 24 - No files in /var/lib/postgresql left behind 497s ok 25 - No files in /var/run/postgresql left behind 497s ok 26 - No files in /var/log/postgresql left behind 497s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 497s ok 28 - PostgreSQL TCP ports are closed 497s === Running test 170_extensions.t ... === 497s # Running tests for 12 500s ok 1 - pg_createcluster 12 main 500s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 500s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 500s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 500s ok 5 - extension adminpack installs without error 500s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 500s ok 7 - extension adminpack removes without error 500s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 500s ok 9 - extension amcheck installs without error 500s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 500s ok 11 - extension amcheck removes without error 500s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 500s ok 13 - extension autoinc installs without error 500s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 500s ok 15 - extension autoinc removes without error 500s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 500s ok 17 - extension bloom installs without error 500s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 500s ok 19 - extension bloom removes without error 500s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 500s ok 21 - extension btree_gin installs without error 500s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 500s ok 23 - extension btree_gin removes without error 500s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 500s ok 25 - extension btree_gist installs without error 500s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 500s ok 27 - extension btree_gist removes without error 500s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 500s ok 29 - extension citext installs without error 500s ok 30 - psql -qc 'DROP EXTENSION "citext"' 500s ok 31 - extension citext removes without error 500s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 500s ok 33 - extension cube installs without error 500s ok 34 - psql -qc 'DROP EXTENSION "cube"' 500s ok 35 - extension cube removes without error 500s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 500s ok 37 - extension dblink installs without error 500s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 500s ok 39 - extension dblink removes without error 500s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 500s ok 41 - extension dict_int installs without error 500s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 500s ok 43 - extension dict_int removes without error 500s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 500s ok 45 - extension dict_xsyn installs without error 500s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 500s ok 47 - extension dict_xsyn removes without error 500s ok 48 - psql -qc 'CREATE EXTENSION cube' 500s ok 49 - earthdistance dependency cube installs without error 500s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 500s ok 51 - extension earthdistance installs without error 501s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 501s ok 53 - extension earthdistance removes without error 501s ok 54 - psql -qc 'DROP EXTENSION cube' 501s ok 55 - earthdistance dependency extension cube removes without error 501s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 501s ok 57 - extension file_fdw installs without error 501s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 501s ok 59 - extension file_fdw removes without error 501s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 501s ok 61 - extension fuzzystrmatch installs without error 501s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 501s ok 63 - extension fuzzystrmatch removes without error 501s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 501s ok 65 - extension hstore installs without error 501s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 501s ok 67 - extension hstore removes without error 501s ok 68 - psql -qc 'CREATE EXTENSION hstore' 501s ok 69 - hstore_plperl dependency hstore installs without error 501s ok 70 - psql -qc 'CREATE EXTENSION plperl' 501s ok 71 - hstore_plperl dependency plperl installs without error 501s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 501s ok 73 - extension hstore_plperl installs without error 501s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 501s ok 75 - extension hstore_plperl removes without error 501s ok 76 - psql -qc 'DROP EXTENSION hstore' 501s ok 77 - hstore_plperl dependency extension hstore removes without error 501s ok 78 - psql -qc 'DROP EXTENSION plperl' 501s ok 79 - hstore_plperl dependency extension plperl removes without error 501s ok 80 - psql -qc 'CREATE EXTENSION hstore' 501s ok 81 - hstore_plperlu dependency hstore installs without error 501s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 501s ok 83 - hstore_plperlu dependency plperlu installs without error 501s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 501s ok 85 - extension hstore_plperlu installs without error 501s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 501s ok 87 - extension hstore_plperlu removes without error 501s ok 88 - psql -qc 'DROP EXTENSION hstore' 501s ok 89 - hstore_plperlu dependency extension hstore removes without error 501s ok 90 - psql -qc 'DROP EXTENSION plperlu' 501s ok 91 - hstore_plperlu dependency extension plperlu removes without error 501s ok 92 - psql -qc 'CREATE EXTENSION hstore' 501s ok 93 - hstore_plpython3u dependency hstore installs without error 501s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 501s ok 95 - hstore_plpython3u dependency plpython3u installs without error 501s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 501s ok 97 - extension hstore_plpython3u installs without error 501s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 501s ok 99 - extension hstore_plpython3u removes without error 501s ok 100 - psql -qc 'DROP EXTENSION hstore' 501s ok 101 - hstore_plpython3u dependency extension hstore removes without error 501s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 501s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 501s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 501s ok 105 - extension insert_username installs without error 501s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 501s ok 107 - extension insert_username removes without error 501s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 501s ok 109 - extension intagg installs without error 501s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 501s ok 111 - extension intagg removes without error 502s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 502s ok 113 - extension intarray installs without error 502s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 502s ok 115 - extension intarray removes without error 502s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 502s ok 117 - extension isn installs without error 502s ok 118 - psql -qc 'DROP EXTENSION "isn"' 502s ok 119 - extension isn removes without error 502s ok 120 - psql -qc 'CREATE EXTENSION plperl' 502s ok 121 - jsonb_plperl dependency plperl installs without error 502s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 502s ok 123 - extension jsonb_plperl installs without error 502s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 502s ok 125 - extension jsonb_plperl removes without error 502s ok 126 - psql -qc 'DROP EXTENSION plperl' 502s ok 127 - jsonb_plperl dependency extension plperl removes without error 502s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 502s ok 129 - jsonb_plperlu dependency plperlu installs without error 502s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 502s ok 131 - extension jsonb_plperlu installs without error 502s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 502s ok 133 - extension jsonb_plperlu removes without error 502s ok 134 - psql -qc 'DROP EXTENSION plperlu' 502s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 502s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 502s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 502s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 502s ok 139 - extension jsonb_plpython3u installs without error 502s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 502s ok 141 - extension jsonb_plpython3u removes without error 502s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 502s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 502s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 502s ok 145 - extension lo installs without error 502s ok 146 - psql -qc 'DROP EXTENSION "lo"' 502s ok 147 - extension lo removes without error 502s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 502s ok 149 - extension ltree installs without error 502s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 502s ok 151 - extension ltree removes without error 502s ok 152 - psql -qc 'CREATE EXTENSION ltree' 502s ok 153 - ltree_plpython3u dependency ltree installs without error 502s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 502s ok 155 - ltree_plpython3u dependency plpython3u installs without error 502s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 502s ok 157 - extension ltree_plpython3u installs without error 502s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 502s ok 159 - extension ltree_plpython3u removes without error 502s ok 160 - psql -qc 'DROP EXTENSION ltree' 502s ok 161 - ltree_plpython3u dependency extension ltree removes without error 502s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 502s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 502s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 502s ok 165 - extension moddatetime installs without error 502s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 502s ok 167 - extension moddatetime removes without error 503s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 503s ok 169 - extension pageinspect installs without error 503s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 503s ok 171 - extension pageinspect removes without error 503s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 503s ok 173 - extension pg_buffercache installs without error 503s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 503s ok 175 - extension pg_buffercache removes without error 503s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 503s ok 177 - extension pg_freespacemap installs without error 503s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 503s ok 179 - extension pg_freespacemap removes without error 503s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 503s ok 181 - extension pg_prewarm installs without error 503s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 503s ok 183 - extension pg_prewarm removes without error 503s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 503s ok 185 - extension pg_stat_statements installs without error 503s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 503s ok 187 - extension pg_stat_statements removes without error 503s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 503s ok 189 - extension pg_trgm installs without error 503s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 503s ok 191 - extension pg_trgm removes without error 503s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 503s ok 193 - extension pg_visibility installs without error 503s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 503s ok 195 - extension pg_visibility removes without error 503s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 503s ok 197 - extension pgcrypto installs without error 503s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 503s ok 199 - extension pgcrypto removes without error 503s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 503s ok 201 - extension pgrowlocks installs without error 503s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 503s ok 203 - extension pgrowlocks removes without error 503s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 503s ok 205 - extension pgstattuple installs without error 503s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 503s ok 207 - extension pgstattuple removes without error 503s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 503s ok 209 - extension plperl installs without error 503s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 503s ok 211 - extension plperl removes without error 503s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 503s ok 213 - extension plperlu installs without error 503s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 503s ok 215 - extension plperlu removes without error 503s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 503s ok 217 - extension plpython3u installs without error 503s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 503s ok 219 - extension plpython3u removes without error 503s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 503s ok 221 - extension pltcl installs without error 503s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 503s ok 223 - extension pltcl removes without error 503s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 503s ok 225 - extension pltclu installs without error 503s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 503s ok 227 - extension pltclu removes without error 503s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 503s ok 229 - extension postgres_fdw installs without error 503s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 503s ok 231 - extension postgres_fdw removes without error 503s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 503s ok 233 - extension refint installs without error 504s ok 234 - psql -qc 'DROP EXTENSION "refint"' 504s ok 235 - extension refint removes without error 504s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 504s ok 237 - extension seg installs without error 504s ok 238 - psql -qc 'DROP EXTENSION "seg"' 504s ok 239 - extension seg removes without error 504s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 504s ok 241 - extension sslinfo installs without error 504s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 504s ok 243 - extension sslinfo removes without error 504s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 504s ok 245 - extension tablefunc installs without error 504s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 504s ok 247 - extension tablefunc removes without error 504s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 504s ok 249 - extension tcn installs without error 504s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 504s ok 251 - extension tcn removes without error 504s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 504s ok 253 - extension tsm_system_rows installs without error 504s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 504s ok 255 - extension tsm_system_rows removes without error 504s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 504s ok 257 - extension tsm_system_time installs without error 504s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 504s ok 259 - extension tsm_system_time removes without error 504s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 504s ok 261 - extension unaccent installs without error 504s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 504s ok 263 - extension unaccent removes without error 504s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 504s ok 265 - extension uuid-ossp installs without error 504s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 504s ok 267 - extension uuid-ossp removes without error 504s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 504s ok 269 - extension xml2 installs without error 504s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 504s ok 271 - extension xml2 removes without error 504s ok 272 - pg_dropcluster 12 main 504s ok 273 - Cleanup: No clusters left behind 504s ok 274 - No postgres processes left behind 504s ok 275 - No files in /etc/postgresql left behind 504s ok 276 - No files in /var/lib/postgresql left behind 504s ok 277 - No files in /var/run/postgresql left behind 504s ok 278 - No files in /var/log/postgresql left behind 504s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 504s ok 280 - PostgreSQL TCP ports are closed 504s 1..280 504s === Running test 180_ecpg.t ... === 505s 1..17 505s ok 1 - ecpg test.pgc 505s ok 2 - ecpg processing 505s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 505s ok 4 - compiling ecpg output 507s ok 5 - pg_createcluster 12 main 508s ok 6 - createuser nobody 508s ok 7 - /tmp/tmp.pXHraEZIDq/test 508s not ok 8 - runs and gives correct output 508s # Failed test 'runs and gives correct output' 508s # at t/TestLib.pm line 201. 508s # got: ' 508s # ' 508s # expected: 'template1 508s # ' 508s ok 9 - pg_dropcluster 12 main 508s ok 10 - Cleanup: No clusters left behind 508s ok 11 - No postgres processes left behind 508s ok 12 - No files in /etc/postgresql left behind 508s ok 13 - No files in /var/lib/postgresql left behind 508s ok 14 - No files in /var/run/postgresql left behind 508s ok 15 - No files in /var/log/postgresql left behind 508s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 508s ok 17 - PostgreSQL TCP ports are closed 508s # Looks like you failed 1 test of 17. 508s autopkgtest [03:41:05]: test run-testsuite: -----------------------] 509s run-testsuite FAIL non-zero exit status 1 509s autopkgtest [03:41:06]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 509s autopkgtest [03:41:06]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 509s # Failed test 'runs and gives correct output' 509s # at t/TestLib.pm line 201. 509s # got: ' 509s # ' 509s # expected: 'template1 509s # ' 509s # Looks like you failed 1 test of 17. 509s autopkgtest [03:41:06]: @@@@@@@@@@@@@@@@@@@@ summary 509s default-psql PASS 509s run-testsuite FAIL non-zero exit status 1 515s nova [W] Using flock in prodstack6-s390x 515s flock: timeout while waiting to get lock 515s Creating nova instance adt-focal-s390x-postgresql-common-20250326-033237-juju-7f2275-prod-proposed-migration-environment-2-f762eef3-4dee-43cb-af8c-5c77f345d0bc from image adt/ubuntu-focal-s390x-server-20250325.img (UUID cf2790f2-2158-441b-b324-15b7026dc851)... 515s nova [W] Timed out waiting for c7cf14d1-5f44-42d6-8d99-2d3d9cd02d05 to get deleted. 515s nova [W] Using flock in prodstack6-s390x 515s flock: timeout while waiting to get lock 515s Creating nova instance adt-focal-s390x-postgresql-common-20250326-033237-juju-7f2275-prod-proposed-migration-environment-2-f762eef3-4dee-43cb-af8c-5c77f345d0bc from image adt/ubuntu-focal-s390x-server-20250325.img (UUID cf2790f2-2158-441b-b324-15b7026dc851)... 515s nova [W] Timed out waiting for 3fd448bb-650d-4b81-b5bc-f29383d0b912 to get deleted.