0s autopkgtest [09:59:06]: starting date and time: 2025-01-06 09:59:06+0000 1s autopkgtest [09:59:07]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [09:59:07]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.g7o085km/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17,src:icu --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=postgresql-17/17.2-1build2 icu/76.1-1ubuntu1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-26.secgroup --name adt-plucky-s390x-postgresql-common-20250106-095906-juju-7f2275-prod-proposed-migration-environment-2-8345b794-2d04-41ce-ae58-2aa64d9baa91 --image adt/ubuntu-plucky-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/ 68s autopkgtest [10:00:14]: testbed dpkg architecture: s390x 68s autopkgtest [10:00:14]: testbed apt version: 2.9.18 68s autopkgtest [10:00:14]: @@@@@@@@@@@@@@@@@@@@ test bed setup 69s autopkgtest [10:00:15]: testbed release detected to be: None 69s autopkgtest [10:00:15]: updating testbed package index (apt update) 70s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 70s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 70s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 70s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 70s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [105 kB] 70s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 70s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [741 kB] 70s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.2 kB] 70s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [173 kB] 70s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [756 B] 70s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [765 kB] 70s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [5928 B] 71s Fetched 1892 kB in 1s (2084 kB/s) 71s Reading package lists... 72s Reading package lists... 72s Building dependency tree... 72s Reading state information... 72s Calculating upgrade... 72s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 72s Reading package lists... 72s Building dependency tree... 72s Reading state information... 72s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 72s autopkgtest [10:00:18]: upgrading testbed (apt dist-upgrade and autopurge) 73s Reading package lists... 73s Building dependency tree... 73s Reading state information... 73s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 73s Starting 2 pkgProblemResolver with broken count: 0 73s Done 73s Entering ResolveByKeep 73s 73s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 74s Reading package lists... 74s Building dependency tree... 74s Reading state information... 74s Starting pkgProblemResolver with broken count: 0 74s Starting 2 pkgProblemResolver with broken count: 0 74s Done 74s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 77s autopkgtest [10:00:23]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 12:49:35 UTC 2024 77s autopkgtest [10:00:23]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 82s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (dsc) [2383 B] 82s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (tar) [218 kB] 82s gpgv: Signature made Thu Aug 8 15:27:49 2024 UTC 82s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 82s gpgv: Can't check signature: No public key 82s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_262.dsc: no acceptable signature found 82s autopkgtest [10:00:28]: testing package postgresql-common version 262 82s autopkgtest [10:00:28]: build not needed 83s autopkgtest [10:00:29]: test default-psql: preparing testbed 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 84s Starting pkgProblemResolver with broken count: 0 84s Starting 2 pkgProblemResolver with broken count: 0 84s Done 84s The following NEW packages will be installed: 84s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 84s postgresql-client-common postgresql-common ssl-cert 84s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 84s Need to get 18.2 MB of archives. 84s After this operation, 52.7 MB of additional disk space will be used. 84s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 85s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 262 [36.7 kB] 85s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 85s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 262 [162 kB] 85s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq5 s390x 17.2-1build2 [146 kB] 85s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 85s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-16 s390x 16.4-3 [1294 kB] 85s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-16 s390x 16.4-3 [16.3 MB] 85s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql all 16+262 [11.8 kB] 86s Preconfiguring packages ... 86s Fetched 18.2 MB in 1s (14.6 MB/s) 86s Selecting previously unselected package libjson-perl. 86s (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 ... 55616 files and directories currently installed.) 86s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 86s Unpacking libjson-perl (4.10000-1) ... 86s Selecting previously unselected package postgresql-client-common. 86s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 86s Unpacking postgresql-client-common (262) ... 86s Selecting previously unselected package ssl-cert. 86s Preparing to unpack .../2-ssl-cert_1.1.3ubuntu1_all.deb ... 86s Unpacking ssl-cert (1.1.3ubuntu1) ... 86s Selecting previously unselected package postgresql-common. 86s Preparing to unpack .../3-postgresql-common_262_all.deb ... 86s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 86s Unpacking postgresql-common (262) ... 86s Selecting previously unselected package libpq5:s390x. 86s Preparing to unpack .../4-libpq5_17.2-1build2_s390x.deb ... 86s Unpacking libpq5:s390x (17.2-1build2) ... 86s Selecting previously unselected package libxslt1.1:s390x. 86s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 86s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 86s Selecting previously unselected package postgresql-client-16. 86s Preparing to unpack .../6-postgresql-client-16_16.4-3_s390x.deb ... 86s Unpacking postgresql-client-16 (16.4-3) ... 86s Selecting previously unselected package postgresql-16. 86s Preparing to unpack .../7-postgresql-16_16.4-3_s390x.deb ... 86s Unpacking postgresql-16 (16.4-3) ... 86s Selecting previously unselected package postgresql. 86s Preparing to unpack .../8-postgresql_16+262_all.deb ... 86s Unpacking postgresql (16+262) ... 86s Setting up postgresql-client-common (262) ... 86s Setting up libpq5:s390x (17.2-1build2) ... 86s Setting up ssl-cert (1.1.3ubuntu1) ... 87s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 87s Setting up libjson-perl (4.10000-1) ... 87s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 87s Setting up postgresql-client-16 (16.4-3) ... 87s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 87s Setting up postgresql-common (262) ... 87s Creating config file /etc/postgresql-common/createcluster.conf with new version 87s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 87s Removing obsolete dictionary files: 88s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 88s Setting up postgresql-16 (16.4-3) ... 88s Creating new PostgreSQL cluster 16/main ... 88s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 88s The files belonging to this database system will be owned by user "postgres". 88s This user must also own the server process. 88s 88s The database cluster will be initialized with locale "C.UTF-8". 88s The default database encoding has accordingly been set to "UTF8". 88s The default text search configuration will be set to "english". 88s 88s Data page checksums are disabled. 88s 88s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 88s creating subdirectories ... ok 88s selecting dynamic shared memory implementation ... posix 88s selecting default max_connections ... 100 88s selecting default shared_buffers ... 128MB 88s selecting default time zone ... Etc/UTC 88s creating configuration files ... ok 88s running bootstrap script ... ok 89s performing post-bootstrap initialization ... ok 89s syncing data to disk ... ok 92s Setting up postgresql (16+262) ... 92s Processing triggers for man-db (2.13.0-1) ... 93s Processing triggers for libc-bin (2.40-4ubuntu1) ... 94s autopkgtest [10:00:40]: test default-psql: [----------------------- 94s autopkgtest [10:00:40]: test default-psql: -----------------------] 95s autopkgtest [10:00:41]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 95s default-psql PASS 95s autopkgtest [10:00:41]: test run-testsuite: preparing testbed 179s autopkgtest [10:02:05]: testbed dpkg architecture: s390x 179s autopkgtest [10:02:05]: testbed apt version: 2.9.18 179s autopkgtest [10:02:05]: @@@@@@@@@@@@@@@@@@@@ test bed setup 180s autopkgtest [10:02:06]: testbed release detected to be: plucky 180s autopkgtest [10:02:06]: updating testbed package index (apt update) 181s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 181s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 181s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 181s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 181s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [105 kB] 181s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [741 kB] 182s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.2 kB] 182s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 182s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [173 kB] 182s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [756 B] 182s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [765 kB] 182s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [5928 B] 182s Fetched 1892 kB in 1s (1321 kB/s) 183s Reading package lists... 183s Reading package lists... 183s Building dependency tree... 183s Reading state information... 184s Calculating upgrade... 184s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 184s Reading package lists... 184s Building dependency tree... 184s Reading state information... 184s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 184s autopkgtest [10:02:10]: upgrading testbed (apt dist-upgrade and autopurge) 184s Reading package lists... 184s Building dependency tree... 184s Reading state information... 184s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 184s Starting 2 pkgProblemResolver with broken count: 0 184s Done 185s Entering ResolveByKeep 185s 185s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 185s Starting pkgProblemResolver with broken count: 0 185s Starting 2 pkgProblemResolver with broken count: 0 185s Done 186s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 189s Reading package lists... 189s Building dependency tree... 189s Reading state information... 189s Starting pkgProblemResolver with broken count: 0 189s Starting 2 pkgProblemResolver with broken count: 0 189s Done 189s The following NEW packages will be installed: 189s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 189s cpp-14 cpp-14-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 189s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 189s fakeroot g++ g++-14 g++-14-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-14 189s gcc-14-s390x-linux-gnu gcc-s390x-linux-gnu gettext hunspell-en-us 189s icu-devtools intltool-debian libarchive-zip-perl libasan8 libcc1-0 189s libclang-common-19-dev libclang-cpp19 libdebhelper-perl libecpg-compat3 189s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 189s libgc1 libgcc-14-dev libgomp1 libicu-dev libicu76 libisl23 libitm1 189s libjson-perl libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 189s libpgtypes3 libpq-dev libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool 189s libubsan1 libxml2-dev libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools 189s llvm-19-runtime llvm-19-tools locales-all m4 po-debconf postgresql-16 189s postgresql-all postgresql-client-16 postgresql-client-common 189s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 189s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 189s postgresql-server-dev-all ssl-cert 189s 0 upgraded, 86 newly installed, 0 to remove and 0 not upgraded. 189s Need to get 208 MB of archives. 189s After this operation, 1193 MB of additional disk space will be used. 189s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 190s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 262 [36.7 kB] 190s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 190s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 262 [162 kB] 190s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x m4 s390x 1.4.19-4build1 [256 kB] 190s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x autoconf all 2.72-3 [382 kB] 190s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x autotools-dev all 20220109.1 [44.9 kB] 190s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x automake all 1:1.16.5-1.3ubuntu1 [558 kB] 190s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x autopoint all 0.22.5-3 [616 kB] 190s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libisl23 s390x 0.27-1 [704 kB] 191s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x libmpc3 s390x 1.3.1-1build2 [57.8 kB] 191s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [9571 kB] 192s Get:13 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-14 s390x 14.2.0-12ubuntu1 [1030 B] 192s Get:14 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [5452 B] 192s Get:15 http://ftpmaster.internal/ubuntu plucky/main s390x cpp s390x 4:14.1.0-2ubuntu1 [22.4 kB] 192s Get:16 http://ftpmaster.internal/ubuntu plucky/main s390x libcc1-0 s390x 14.2.0-12ubuntu1 [50.6 kB] 192s Get:17 http://ftpmaster.internal/ubuntu plucky/main s390x libgomp1 s390x 14.2.0-12ubuntu1 [151 kB] 192s Get:18 http://ftpmaster.internal/ubuntu plucky/main s390x libitm1 s390x 14.2.0-12ubuntu1 [30.9 kB] 192s Get:19 http://ftpmaster.internal/ubuntu plucky/main s390x libasan8 s390x 14.2.0-12ubuntu1 [2964 kB] 192s Get:20 http://ftpmaster.internal/ubuntu plucky/main s390x libubsan1 s390x 14.2.0-12ubuntu1 [1184 kB] 193s Get:21 http://ftpmaster.internal/ubuntu plucky/main s390x libgcc-14-dev s390x 14.2.0-12ubuntu1 [1036 kB] 193s Get:22 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [18.7 MB] 194s Get:23 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-14 s390x 14.2.0-12ubuntu1 [522 kB] 194s Get:24 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [1204 B] 194s Get:25 http://ftpmaster.internal/ubuntu plucky/main s390x gcc s390x 4:14.1.0-2ubuntu1 [4996 B] 194s Get:26 http://ftpmaster.internal/ubuntu plucky/main s390x libstdc++-14-dev s390x 14.2.0-12ubuntu1 [2610 kB] 194s Get:27 http://ftpmaster.internal/ubuntu plucky/main s390x g++-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [11.0 MB] 195s Get:28 http://ftpmaster.internal/ubuntu plucky/main s390x g++-14 s390x 14.2.0-12ubuntu1 [20.2 kB] 195s Get:29 http://ftpmaster.internal/ubuntu plucky/main s390x g++-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [956 B] 195s Get:30 http://ftpmaster.internal/ubuntu plucky/main s390x g++ s390x 4:14.1.0-2ubuntu1 [1076 B] 195s Get:31 http://ftpmaster.internal/ubuntu plucky/main s390x build-essential s390x 12.10ubuntu1 [4930 B] 195s Get:32 http://ftpmaster.internal/ubuntu plucky/universe s390x libclang-cpp19 s390x 1:19.1.6-1ubuntu1 [16.7 MB] 196s Get:33 http://ftpmaster.internal/ubuntu plucky/main s390x libgc1 s390x 1:8.2.8-1 [93.7 kB] 196s Get:34 http://ftpmaster.internal/ubuntu plucky/universe s390x libobjc4 s390x 14.2.0-12ubuntu1 [49.9 kB] 196s Get:35 http://ftpmaster.internal/ubuntu plucky/universe s390x libobjc-14-dev s390x 14.2.0-12ubuntu1 [194 kB] 196s Get:36 http://ftpmaster.internal/ubuntu plucky/universe s390x libclang-common-19-dev s390x 1:19.1.6-1ubuntu1 [742 kB] 196s Get:37 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-linker-tools s390x 1:19.1.6-1ubuntu1 [1546 kB] 196s Get:38 http://ftpmaster.internal/ubuntu plucky/universe s390x clang-19 s390x 1:19.1.6-1ubuntu1 [79.4 kB] 196s Get:39 http://ftpmaster.internal/ubuntu plucky/main s390x libdebhelper-perl all 13.20ubuntu1 [94.2 kB] 196s Get:40 http://ftpmaster.internal/ubuntu plucky/main s390x libtool all 2.4.7-8 [166 kB] 196s Get:41 http://ftpmaster.internal/ubuntu plucky/main s390x dh-autoreconf all 20 [16.1 kB] 196s Get:42 http://ftpmaster.internal/ubuntu plucky/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 196s Get:43 http://ftpmaster.internal/ubuntu plucky/main s390x libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 196s Get:44 http://ftpmaster.internal/ubuntu plucky/main s390x dh-strip-nondeterminism all 1.14.0-1 [5058 B] 196s Get:45 http://ftpmaster.internal/ubuntu plucky/main s390x debugedit s390x 1:5.1-1 [49.9 kB] 196s Get:46 http://ftpmaster.internal/ubuntu plucky/main s390x dwz s390x 0.15-1build6 [122 kB] 196s Get:47 http://ftpmaster.internal/ubuntu plucky/main s390x gettext s390x 0.22.5-3 [997 kB] 196s Get:48 http://ftpmaster.internal/ubuntu plucky/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 196s Get:49 http://ftpmaster.internal/ubuntu plucky/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 196s Get:50 http://ftpmaster.internal/ubuntu plucky/main s390x debhelper all 13.20ubuntu1 [893 kB] 196s Get:51 http://ftpmaster.internal/ubuntu plucky/main s390x emacsen-common all 3.0.5 [12.1 kB] 196s Get:52 http://ftpmaster.internal/ubuntu plucky/main s390x dictionaries-common all 1.30.2 [176 kB] 196s Get:53 http://ftpmaster.internal/ubuntu plucky/main s390x libfakeroot s390x 1.36.2-1 [32.4 kB] 196s Get:54 http://ftpmaster.internal/ubuntu plucky/main s390x fakeroot s390x 1.36.2-1 [67.7 kB] 196s Get:55 http://ftpmaster.internal/ubuntu plucky/main s390x hunspell-en-us all 1:2020.12.07-3 [586 kB] 196s Get:56 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libicu76 s390x 76.1-1ubuntu1 [11.2 MB] 197s Get:57 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x icu-devtools s390x 76.1-1ubuntu1 [225 kB] 197s Get:58 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpgtypes3 s390x 17.2-1build2 [48.7 kB] 197s Get:59 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq5 s390x 17.2-1build2 [146 kB] 197s Get:60 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libecpg6 s390x 17.2-1build2 [48.0 kB] 197s Get:61 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libecpg-compat3 s390x 17.2-1build2 [13.1 kB] 197s Get:62 http://ftpmaster.internal/ubuntu plucky/main s390x libssl-dev s390x 3.4.0-1ubuntu2 [2427 kB] 197s Get:63 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq-dev s390x 17.2-1build2 [159 kB] 197s Get:64 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libecpg-dev s390x 17.2-1build2 [282 kB] 197s Get:65 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libicu-dev s390x 76.1-1ubuntu1 [12.2 MB] 198s Get:66 http://ftpmaster.internal/ubuntu plucky/main s390x libncurses-dev s390x 6.5-2 [404 kB] 198s Get:67 http://ftpmaster.internal/ubuntu plucky/main s390x libtcl8.6 s390x 8.6.15+dfsg-2 [1034 kB] 198s Get:68 http://ftpmaster.internal/ubuntu plucky/main s390x libxml2-dev s390x 2.12.7+dfsg+really2.9.14-0.2build1 [824 kB] 198s Get:69 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 198s Get:70 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-runtime s390x 1:19.1.6-1ubuntu1 [622 kB] 198s Get:71 http://ftpmaster.internal/ubuntu plucky/universe s390x libpfm4 s390x 4.13.0+git83-g91970fe-1 [37.3 kB] 198s Get:72 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19 s390x 1:19.1.6-1ubuntu1 [21.1 MB] 199s Get:73 http://ftpmaster.internal/ubuntu plucky/main s390x libffi-dev s390x 3.4.6-1build1 [58.8 kB] 199s Get:74 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-tools s390x 1:19.1.6-1ubuntu1 [584 kB] 199s Get:75 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-dev s390x 1:19.1.6-1ubuntu1 [50.2 MB] 202s Get:76 http://ftpmaster.internal/ubuntu plucky/universe s390x locales-all s390x 2.40-4ubuntu1 [11.5 MB] 202s Get:77 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-16 s390x 16.4-3 [1294 kB] 202s Get:78 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-16 s390x 16.4-3 [16.3 MB] 203s Get:79 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-server-dev-16 s390x 16.4-3 [1226 kB] 203s Get:80 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-server-dev-all s390x 262 [20.7 kB] 203s Get:81 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-plperl-16 s390x 16.4-3 [65.4 kB] 203s Get:82 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-plpython3-16 s390x 16.4-3 [73.5 kB] 203s Get:83 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-pltcl-16 s390x 16.4-3 [28.3 kB] 203s Get:84 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-all all 262 [1710 B] 203s Get:85 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-doc-16 all 16.4-3 [2098 kB] 203s Get:86 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-doc all 16+262 [11.8 kB] 204s Preconfiguring packages ... 204s Fetched 208 MB in 14s (14.9 MB/s) 204s Selecting previously unselected package libjson-perl. 204s (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 ... 55616 files and directories currently installed.) 204s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 204s Unpacking libjson-perl (4.10000-1) ... 204s Selecting previously unselected package postgresql-client-common. 204s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 204s Unpacking postgresql-client-common (262) ... 204s Selecting previously unselected package ssl-cert. 204s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 204s Unpacking ssl-cert (1.1.3ubuntu1) ... 204s Selecting previously unselected package postgresql-common. 204s Preparing to unpack .../03-postgresql-common_262_all.deb ... 204s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 204s Unpacking postgresql-common (262) ... 204s Selecting previously unselected package m4. 204s Preparing to unpack .../04-m4_1.4.19-4build1_s390x.deb ... 204s Unpacking m4 (1.4.19-4build1) ... 204s Selecting previously unselected package autoconf. 204s Preparing to unpack .../05-autoconf_2.72-3_all.deb ... 204s Unpacking autoconf (2.72-3) ... 204s Selecting previously unselected package autotools-dev. 204s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 204s Unpacking autotools-dev (20220109.1) ... 204s Selecting previously unselected package automake. 204s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 204s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 204s Selecting previously unselected package autopoint. 204s Preparing to unpack .../08-autopoint_0.22.5-3_all.deb ... 204s Unpacking autopoint (0.22.5-3) ... 204s Selecting previously unselected package libisl23:s390x. 204s Preparing to unpack .../09-libisl23_0.27-1_s390x.deb ... 204s Unpacking libisl23:s390x (0.27-1) ... 204s Selecting previously unselected package libmpc3:s390x. 204s Preparing to unpack .../10-libmpc3_1.3.1-1build2_s390x.deb ... 204s Unpacking libmpc3:s390x (1.3.1-1build2) ... 204s Selecting previously unselected package cpp-14-s390x-linux-gnu. 204s Preparing to unpack .../11-cpp-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking cpp-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package cpp-14. 204s Preparing to unpack .../12-cpp-14_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package cpp-s390x-linux-gnu. 204s Preparing to unpack .../13-cpp-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 204s Unpacking cpp-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package cpp. 204s Preparing to unpack .../14-cpp_4%3a14.1.0-2ubuntu1_s390x.deb ... 204s Unpacking cpp (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package libcc1-0:s390x. 204s Preparing to unpack .../15-libcc1-0_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libcc1-0:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package libgomp1:s390x. 204s Preparing to unpack .../16-libgomp1_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libgomp1:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package libitm1:s390x. 204s Preparing to unpack .../17-libitm1_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libitm1:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package libasan8:s390x. 204s Preparing to unpack .../18-libasan8_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libasan8:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package libubsan1:s390x. 204s Preparing to unpack .../19-libubsan1_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libubsan1:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package libgcc-14-dev:s390x. 204s Preparing to unpack .../20-libgcc-14-dev_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking libgcc-14-dev:s390x (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package gcc-14-s390x-linux-gnu. 204s Preparing to unpack .../21-gcc-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking gcc-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package gcc-14. 204s Preparing to unpack .../22-gcc-14_14.2.0-12ubuntu1_s390x.deb ... 204s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 204s Selecting previously unselected package gcc-s390x-linux-gnu. 204s Preparing to unpack .../23-gcc-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 204s Unpacking gcc-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package gcc. 204s Preparing to unpack .../24-gcc_4%3a14.1.0-2ubuntu1_s390x.deb ... 204s Unpacking gcc (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package libstdc++-14-dev:s390x. 205s Preparing to unpack .../25-libstdc++-14-dev_14.2.0-12ubuntu1_s390x.deb ... 205s Unpacking libstdc++-14-dev:s390x (14.2.0-12ubuntu1) ... 205s Selecting previously unselected package g++-14-s390x-linux-gnu. 205s Preparing to unpack .../26-g++-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 205s Unpacking g++-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 205s Selecting previously unselected package g++-14. 205s Preparing to unpack .../27-g++-14_14.2.0-12ubuntu1_s390x.deb ... 205s Unpacking g++-14 (14.2.0-12ubuntu1) ... 205s Selecting previously unselected package g++-s390x-linux-gnu. 205s Preparing to unpack .../28-g++-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 205s Unpacking g++-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 205s Selecting previously unselected package g++. 205s Preparing to unpack .../29-g++_4%3a14.1.0-2ubuntu1_s390x.deb ... 205s Unpacking g++ (4:14.1.0-2ubuntu1) ... 205s Selecting previously unselected package build-essential. 205s Preparing to unpack .../30-build-essential_12.10ubuntu1_s390x.deb ... 205s Unpacking build-essential (12.10ubuntu1) ... 205s Selecting previously unselected package libclang-cpp19. 205s Preparing to unpack .../31-libclang-cpp19_1%3a19.1.6-1ubuntu1_s390x.deb ... 205s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 205s Selecting previously unselected package libgc1:s390x. 205s Preparing to unpack .../32-libgc1_1%3a8.2.8-1_s390x.deb ... 205s Unpacking libgc1:s390x (1:8.2.8-1) ... 205s Selecting previously unselected package libobjc4:s390x. 205s Preparing to unpack .../33-libobjc4_14.2.0-12ubuntu1_s390x.deb ... 205s Unpacking libobjc4:s390x (14.2.0-12ubuntu1) ... 205s Selecting previously unselected package libobjc-14-dev:s390x. 205s Preparing to unpack .../34-libobjc-14-dev_14.2.0-12ubuntu1_s390x.deb ... 205s Unpacking libobjc-14-dev:s390x (14.2.0-12ubuntu1) ... 205s Selecting previously unselected package libclang-common-19-dev:s390x. 205s Preparing to unpack .../35-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_s390x.deb ... 205s Unpacking libclang-common-19-dev:s390x (1:19.1.6-1ubuntu1) ... 205s Selecting previously unselected package llvm-19-linker-tools. 205s Preparing to unpack .../36-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_s390x.deb ... 205s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 205s Selecting previously unselected package clang-19. 205s Preparing to unpack .../37-clang-19_1%3a19.1.6-1ubuntu1_s390x.deb ... 205s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 205s Selecting previously unselected package libdebhelper-perl. 205s Preparing to unpack .../38-libdebhelper-perl_13.20ubuntu1_all.deb ... 205s Unpacking libdebhelper-perl (13.20ubuntu1) ... 205s Selecting previously unselected package libtool. 205s Preparing to unpack .../39-libtool_2.4.7-8_all.deb ... 205s Unpacking libtool (2.4.7-8) ... 205s Selecting previously unselected package dh-autoreconf. 205s Preparing to unpack .../40-dh-autoreconf_20_all.deb ... 205s Unpacking dh-autoreconf (20) ... 205s Selecting previously unselected package libarchive-zip-perl. 205s Preparing to unpack .../41-libarchive-zip-perl_1.68-1_all.deb ... 205s Unpacking libarchive-zip-perl (1.68-1) ... 205s Selecting previously unselected package libfile-stripnondeterminism-perl. 205s Preparing to unpack .../42-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 205s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 205s Selecting previously unselected package dh-strip-nondeterminism. 205s Preparing to unpack .../43-dh-strip-nondeterminism_1.14.0-1_all.deb ... 205s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 205s Selecting previously unselected package debugedit. 205s Preparing to unpack .../44-debugedit_1%3a5.1-1_s390x.deb ... 205s Unpacking debugedit (1:5.1-1) ... 205s Selecting previously unselected package dwz. 205s Preparing to unpack .../45-dwz_0.15-1build6_s390x.deb ... 205s Unpacking dwz (0.15-1build6) ... 205s Selecting previously unselected package gettext. 205s Preparing to unpack .../46-gettext_0.22.5-3_s390x.deb ... 205s Unpacking gettext (0.22.5-3) ... 205s Selecting previously unselected package intltool-debian. 205s Preparing to unpack .../47-intltool-debian_0.35.0+20060710.6_all.deb ... 205s Unpacking intltool-debian (0.35.0+20060710.6) ... 205s Selecting previously unselected package po-debconf. 205s Preparing to unpack .../48-po-debconf_1.0.21+nmu1_all.deb ... 205s Unpacking po-debconf (1.0.21+nmu1) ... 205s Selecting previously unselected package debhelper. 205s Preparing to unpack .../49-debhelper_13.20ubuntu1_all.deb ... 205s Unpacking debhelper (13.20ubuntu1) ... 205s Selecting previously unselected package emacsen-common. 205s Preparing to unpack .../50-emacsen-common_3.0.5_all.deb ... 205s Unpacking emacsen-common (3.0.5) ... 205s Selecting previously unselected package dictionaries-common. 205s Preparing to unpack .../51-dictionaries-common_1.30.2_all.deb ... 206s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 206s Unpacking dictionaries-common (1.30.2) ... 206s Selecting previously unselected package libfakeroot:s390x. 206s Preparing to unpack .../52-libfakeroot_1.36.2-1_s390x.deb ... 206s Unpacking libfakeroot:s390x (1.36.2-1) ... 206s Selecting previously unselected package fakeroot. 206s Preparing to unpack .../53-fakeroot_1.36.2-1_s390x.deb ... 206s Unpacking fakeroot (1.36.2-1) ... 206s Selecting previously unselected package hunspell-en-us. 206s Preparing to unpack .../54-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 206s Unpacking hunspell-en-us (1:2020.12.07-3) ... 206s Selecting previously unselected package libicu76:s390x. 206s Preparing to unpack .../55-libicu76_76.1-1ubuntu1_s390x.deb ... 206s Unpacking libicu76:s390x (76.1-1ubuntu1) ... 206s Selecting previously unselected package icu-devtools. 206s Preparing to unpack .../56-icu-devtools_76.1-1ubuntu1_s390x.deb ... 206s Unpacking icu-devtools (76.1-1ubuntu1) ... 206s Selecting previously unselected package libpgtypes3:s390x. 206s Preparing to unpack .../57-libpgtypes3_17.2-1build2_s390x.deb ... 206s Unpacking libpgtypes3:s390x (17.2-1build2) ... 206s Selecting previously unselected package libpq5:s390x. 206s Preparing to unpack .../58-libpq5_17.2-1build2_s390x.deb ... 206s Unpacking libpq5:s390x (17.2-1build2) ... 206s Selecting previously unselected package libecpg6:s390x. 206s Preparing to unpack .../59-libecpg6_17.2-1build2_s390x.deb ... 206s Unpacking libecpg6:s390x (17.2-1build2) ... 206s Selecting previously unselected package libecpg-compat3:s390x. 206s Preparing to unpack .../60-libecpg-compat3_17.2-1build2_s390x.deb ... 206s Unpacking libecpg-compat3:s390x (17.2-1build2) ... 206s Selecting previously unselected package libssl-dev:s390x. 206s Preparing to unpack .../61-libssl-dev_3.4.0-1ubuntu2_s390x.deb ... 206s Unpacking libssl-dev:s390x (3.4.0-1ubuntu2) ... 206s Selecting previously unselected package libpq-dev. 206s Preparing to unpack .../62-libpq-dev_17.2-1build2_s390x.deb ... 206s Unpacking libpq-dev (17.2-1build2) ... 206s Selecting previously unselected package libecpg-dev. 206s Preparing to unpack .../63-libecpg-dev_17.2-1build2_s390x.deb ... 206s Unpacking libecpg-dev (17.2-1build2) ... 206s Selecting previously unselected package libicu-dev:s390x. 206s Preparing to unpack .../64-libicu-dev_76.1-1ubuntu1_s390x.deb ... 206s Unpacking libicu-dev:s390x (76.1-1ubuntu1) ... 206s Selecting previously unselected package libncurses-dev:s390x. 206s Preparing to unpack .../65-libncurses-dev_6.5-2_s390x.deb ... 206s Unpacking libncurses-dev:s390x (6.5-2) ... 206s Selecting previously unselected package libtcl8.6:s390x. 206s Preparing to unpack .../66-libtcl8.6_8.6.15+dfsg-2_s390x.deb ... 206s Unpacking libtcl8.6:s390x (8.6.15+dfsg-2) ... 206s Selecting previously unselected package libxml2-dev:s390x. 206s Preparing to unpack .../67-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2build1_s390x.deb ... 206s Unpacking libxml2-dev:s390x (2.12.7+dfsg+really2.9.14-0.2build1) ... 206s Selecting previously unselected package libxslt1.1:s390x. 206s Preparing to unpack .../68-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 206s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 206s Selecting previously unselected package llvm-19-runtime. 206s Preparing to unpack .../69-llvm-19-runtime_1%3a19.1.6-1ubuntu1_s390x.deb ... 206s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 206s Selecting previously unselected package libpfm4:s390x. 206s Preparing to unpack .../70-libpfm4_4.13.0+git83-g91970fe-1_s390x.deb ... 206s Unpacking libpfm4:s390x (4.13.0+git83-g91970fe-1) ... 206s Selecting previously unselected package llvm-19. 206s Preparing to unpack .../71-llvm-19_1%3a19.1.6-1ubuntu1_s390x.deb ... 206s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 207s Selecting previously unselected package libffi-dev:s390x. 207s Preparing to unpack .../72-libffi-dev_3.4.6-1build1_s390x.deb ... 207s Unpacking libffi-dev:s390x (3.4.6-1build1) ... 207s Selecting previously unselected package llvm-19-tools. 207s Preparing to unpack .../73-llvm-19-tools_1%3a19.1.6-1ubuntu1_s390x.deb ... 207s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 207s Selecting previously unselected package llvm-19-dev. 207s Preparing to unpack .../74-llvm-19-dev_1%3a19.1.6-1ubuntu1_s390x.deb ... 207s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 208s Selecting previously unselected package locales-all. 208s Preparing to unpack .../75-locales-all_2.40-4ubuntu1_s390x.deb ... 208s Unpacking locales-all (2.40-4ubuntu1) ... 210s Selecting previously unselected package postgresql-client-16. 210s Preparing to unpack .../76-postgresql-client-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-client-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-16. 210s Preparing to unpack .../77-postgresql-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-server-dev-16. 210s Preparing to unpack .../78-postgresql-server-dev-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-server-dev-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-server-dev-all:s390x. 210s Preparing to unpack .../79-postgresql-server-dev-all_262_s390x.deb ... 210s Unpacking postgresql-server-dev-all:s390x (262) ... 210s Selecting previously unselected package postgresql-plperl-16. 210s Preparing to unpack .../80-postgresql-plperl-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-plperl-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-plpython3-16. 210s Preparing to unpack .../81-postgresql-plpython3-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-plpython3-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-pltcl-16. 210s Preparing to unpack .../82-postgresql-pltcl-16_16.4-3_s390x.deb ... 210s Unpacking postgresql-pltcl-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-all. 210s Preparing to unpack .../83-postgresql-all_262_all.deb ... 210s Unpacking postgresql-all (262) ... 210s Selecting previously unselected package postgresql-doc-16. 210s Preparing to unpack .../84-postgresql-doc-16_16.4-3_all.deb ... 210s Unpacking postgresql-doc-16 (16.4-3) ... 210s Selecting previously unselected package postgresql-doc. 210s Preparing to unpack .../85-postgresql-doc_16+262_all.deb ... 210s Unpacking postgresql-doc (16+262) ... 210s Setting up postgresql-client-common (262) ... 210s Setting up libpgtypes3:s390x (17.2-1build2) ... 210s Setting up libncurses-dev:s390x (6.5-2) ... 210s Setting up libclang-common-19-dev:s390x (1:19.1.6-1ubuntu1) ... 210s Setting up postgresql-doc-16 (16.4-3) ... 210s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 210s Setting up libarchive-zip-perl (1.68-1) ... 210s Setting up libdebhelper-perl (13.20ubuntu1) ... 210s Setting up libpq5:s390x (17.2-1build2) ... 210s Setting up m4 (1.4.19-4build1) ... 210s Setting up libgomp1:s390x (14.2.0-12ubuntu1) ... 210s Setting up libffi-dev:s390x (3.4.6-1build1) ... 210s Setting up locales-all (2.40-4ubuntu1) ... 210s Setting up libfakeroot:s390x (1.36.2-1) ... 210s Setting up fakeroot (1.36.2-1) ... 210s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 210s Setting up autotools-dev (20220109.1) ... 210s Setting up libpfm4:s390x (4.13.0+git83-g91970fe-1) ... 210s Setting up emacsen-common (3.0.5) ... 210s Setting up ssl-cert (1.1.3ubuntu1) ... 211s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 211s Setting up libssl-dev:s390x (3.4.0-1ubuntu2) ... 211s Setting up libmpc3:s390x (1.3.1-1build2) ... 211s Setting up libtcl8.6:s390x (8.6.15+dfsg-2) ... 211s Setting up autopoint (0.22.5-3) ... 211s Setting up libgc1:s390x (1:8.2.8-1) ... 211s Setting up autoconf (2.72-3) ... 211s Setting up libubsan1:s390x (14.2.0-12ubuntu1) ... 211s Setting up dwz (0.15-1build6) ... 211s Setting up libasan8:s390x (14.2.0-12ubuntu1) ... 211s Setting up libjson-perl (4.10000-1) ... 211s Setting up postgresql-doc (16+262) ... 211s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 211s Setting up debugedit (1:5.1-1) ... 211s Setting up libecpg6:s390x (17.2-1build2) ... 211s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 211s Setting up libicu76:s390x (76.1-1ubuntu1) ... 211s Setting up libisl23:s390x (0.27-1) ... 211s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 211s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 211s Setting up libcc1-0:s390x (14.2.0-12ubuntu1) ... 211s Setting up libitm1:s390x (14.2.0-12ubuntu1) ... 211s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 211s Setting up automake (1:1.16.5-1.3ubuntu1) ... 211s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 211s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 211s Setting up gettext (0.22.5-3) ... 211s Setting up libecpg-compat3:s390x (17.2-1build2) ... 211s Setting up dictionaries-common (1.30.2) ... 211s Setting up postgresql-client-16 (16.4-3) ... 211s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 211s Setting up libpq-dev (17.2-1build2) ... 211s Setting up libobjc4:s390x (14.2.0-12ubuntu1) ... 211s Setting up libecpg-dev (17.2-1build2) ... 211s Setting up intltool-debian (0.35.0+20060710.6) ... 211s Setting up postgresql-common (262) ... 211s Creating config file /etc/postgresql-common/createcluster.conf with new version 211s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 211s en_us 212s Removing obsolete dictionary files: 212s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 212s Setting up icu-devtools (76.1-1ubuntu1) ... 212s Setting up cpp-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 212s Setting up cpp-14 (14.2.0-12ubuntu1) ... 212s Setting up dh-strip-nondeterminism (1.14.0-1) ... 212s Setting up hunspell-en-us (1:2020.12.07-3) ... 212s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 212s Setting up libgcc-14-dev:s390x (14.2.0-12ubuntu1) ... 212s Setting up libstdc++-14-dev:s390x (14.2.0-12ubuntu1) ... 212s Setting up libicu-dev:s390x (76.1-1ubuntu1) ... 212s Setting up postgresql-16 (16.4-3) ... 212s Creating new PostgreSQL cluster 16/main ... 212s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 212s The files belonging to this database system will be owned by user "postgres". 212s This user must also own the server process. 212s 212s The database cluster will be initialized with locale "C.UTF-8". 212s The default database encoding has accordingly been set to "UTF8". 212s The default text search configuration will be set to "english". 212s 212s Data page checksums are disabled. 212s 212s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 212s creating subdirectories ... ok 212s selecting dynamic shared memory implementation ... posix 212s selecting default max_connections ... 100 213s selecting default shared_buffers ... 128MB 213s selecting default time zone ... Etc/UTC 213s creating configuration files ... ok 213s running bootstrap script ... ok 213s performing post-bootstrap initialization ... ok 213s syncing data to disk ... ok 216s Setting up cpp-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 216s Setting up po-debconf (1.0.21+nmu1) ... 216s Setting up libobjc-14-dev:s390x (14.2.0-12ubuntu1) ... 216s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 216s Setting up gcc-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 216s Setting up libxml2-dev:s390x (2.12.7+dfsg+really2.9.14-0.2build1) ... 216s Setting up gcc-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 216s Setting up g++-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 216s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 216s Setting up postgresql-server-dev-16 (16.4-3) ... 216s Setting up postgresql-plpython3-16 (16.4-3) ... 216s Setting up cpp (4:14.1.0-2ubuntu1) ... 216s Setting up postgresql-plperl-16 (16.4-3) ... 216s Setting up postgresql-server-dev-all:s390x (262) ... 216s Setting up postgresql-pltcl-16 (16.4-3) ... 216s Setting up libtool (2.4.7-8) ... 216s Setting up g++-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 216s Setting up postgresql-all (262) ... 216s Setting up gcc-14 (14.2.0-12ubuntu1) ... 216s Setting up dh-autoreconf (20) ... 216s Setting up g++-14 (14.2.0-12ubuntu1) ... 216s Setting up debhelper (13.20ubuntu1) ... 216s Setting up gcc (4:14.1.0-2ubuntu1) ... 216s Setting up g++ (4:14.1.0-2ubuntu1) ... 216s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 216s Setting up build-essential (12.10ubuntu1) ... 216s Processing triggers for libc-bin (2.40-4ubuntu1) ... 216s Processing triggers for systemd (257-2ubuntu1) ... 216s Processing triggers for man-db (2.13.0-1) ... 217s Processing triggers for install-info (7.1.1-1) ... 217s Processing triggers for dictionaries-common (1.30.2) ... 220s autopkgtest [10:02:46]: test run-testsuite: [----------------------- 221s ====== Running all tests with umask 077 ======= 221s ### PostgreSQL test 001_packages.t ### 221s 1..22 221s ok 1 - /etc/os-release exists 221s ok 2 - OS is ubuntu 221s ok 3 - OS version is 25.04 221s # PostgreSQL versions installed: 16 221s ok 4 - postgresql-16 installed 221s ok 5 # skip No python2 support 221s ok 6 - postgresql-plpython3-16 installed 221s ok 7 - postgresql-plperl-16 installed 221s ok 8 - postgresql-pltcl-16 installed 221s ok 9 - postgresql-server-dev-16 installed 221s ok 10 # skip No postgresql-contrib-16 package for version 16 221s # postgresql-doc-16 installed 221s ok 11 - At least one doc package installed 221s ok 12 - libecpg-dev installed 221s ok 13 - procps installed 221s ok 14 - netcat-openbsd installed 221s ok 15 - hunspell-en-us installed 221s ok 16 - system has a default UTF-8 locale 221s ok 17 - locale ru_RU exists 221s ok 18 - locale ru_RU.UTF-8 exists 221s ok 19 - user postgres in the UNIX group ssl-cert 221s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 221s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 221s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 221s ### End test 001_packages.t ### 221s 221s ### PostgreSQL test 002_existing_clusters.t ### 221s 1..8 221s # Cleanup 221s ok 1 - Cleanup: No clusters left behind 221s ok 2 - No postgres processes left behind 221s ok 3 - No files in /etc/postgresql left behind 221s ok 4 - No files in /var/lib/postgresql left behind 221s ok 5 - No files in /var/run/postgresql left behind 221s ok 6 - No files in /var/log/postgresql left behind 221s ok 7 - PostgreSQL TCP ports are closed 221s ok 8 - Next free port is 5432 221s ### End test 002_existing_clusters.t ### 221s 221s ### PostgreSQL test 003_alternatives.t ### 221s 1..9 221s # Newest PG version installed is 16 221s ok 1 - psql.1.gz link group 221s ok 2 - postmaster.1.gz link group does not exist 221s ok 3 - psql.1.gz alternative 221s ok 4 - pg_dump.1.gz alternative 221s ok 5 - postgres.1.gz alternative 221s ok 6 - pg_ctl.1.gz alternative 221s # Newest PG doc version installed is 16 221s ok 7 - SPI_connect.3.gz link group 221s ok 8 - SPI_connect.3.gz alternative 221s ok 9 - SPI_exec.3.gz alternative 221s ### End test 003_alternatives.t ### 221s 221s ### PostgreSQL test 005_PgCommon.t ### 221s 1..24 221s ok 1 - correctly parsed line 'local all postgres ident sameuser' 221s ok 2 - correctly parsed line 'local foo nobody trust' 221s ok 3 - correctly parsed line 'local foo nobody crypt' 221s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 221s ok 5 - correctly parsed line 'local foo,bar nobody ident' 221s ok 6 - correctly parsed line 'local all +foogrp password' 221s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 221s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 221s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 221s ok 10 - @expected_records has correct number of entries 221s ok 11 - returned read_pg_hba array has correct number of records 221s ok 12 - line 'foo all all md5' parsed as invalid 221s ok 13 - line 'local all all foo' parsed as invalid 221s ok 14 - line 'host all all foo' parsed as invalid 221s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 221s ok 16 - line 'host all all md5' parsed as invalid 221s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 221s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 221s ok 19 - read_conf_file returns empty dict for nonexisting file 221s ok 20 - read_conf_file() parsing 221s ok 21 - read_conf_file() parsing with include directives 221s ok 22 - set_conf_value 221s ok 23 - disable_conf_value 221s ok 24 - replace_conf_value 221s ### End test 005_PgCommon.t ### 221s 221s ### PostgreSQL test 006_next_free_port.t ### 221s 1..5 221s ok 1 - next_free_port is 5432 222s ok 2 - next_free_port detects localhost ipv4 socket 223s ok 3 - next_free_port detects wildcard ipv4 socket 224s ok 4 - next_free_port detects localhost ipv6 socket 225s ok 5 - next_free_port detects wildcard ipv6 socket 225s ### End test 006_next_free_port.t ### 225s 225s ### PostgreSQL test 007_pg_conftool.t ### 225s 1..41 225s # test without cluster 225s ok 1 - pg_conftool show all 225s ok 2 - correct output of pg_conftool show all 225s ok 3 - pg_conftool foo.conf show all 225s ok 4 - correct output of pg_conftool foo.conf show all 225s ok 5 - pg_conftool /tmp/Py0OJvGwx6/different.conf show all 225s ok 6 - correct output of pg_conftool /tmp/Py0OJvGwx6/different.conf show all 226s ok 7 - pg_conftool 9.7 main show all 226s ok 8 - correct output of pg_conftool 9.7 main show all 226s # test show 226s ok 9 - pg_conftool show all 226s ok 10 - correct output of pg_conftool show all 226s ok 11 - pg_conftool other.conf show all 226s ok 12 - correct output of pg_conftool other.conf show all 226s ok 13 - pg_conftool /tmp/Py0OJvGwx6/different.conf show all 226s ok 14 - correct output of pg_conftool /tmp/Py0OJvGwx6/different.conf show all 226s ok 15 - pg_conftool 16 main show all 226s ok 16 - correct output of pg_conftool 16 main show all 226s ok 17 - pg_conftool 16 main other.conf show all 226s ok 18 - correct output of pg_conftool 16 main other.conf show all 226s ok 19 - pg_conftool show a 226s ok 20 - correct output of pg_conftool show a 226s ok 21 - pg_conftool -s show a 226s ok 22 - correct output of pg_conftool -s show a 226s # test set 226s ok 23 - pg_conftool set c 7 226s ok 24 - correct output of pg_conftool set c 7 226s ok 25 - file contains new setting 226s ok 26 - pg_conftool set a 8 226s ok 27 - correct output of pg_conftool set a 8 226s ok 28 - file contains updated setting 226s ok 29 - pg_conftool /tmp/Py0OJvGwx6/different.conf set a 9 226s ok 30 - correct output of pg_conftool /tmp/Py0OJvGwx6/different.conf set a 9 226s ok 31 - file with path contains updated setting 226s # test remove 226s ok 32 - pg_conftool remove a 226s ok 33 - correct output of pg_conftool remove a 226s ok 34 - setting removed from file 226s ok 35 - pg_conftool /tmp/Py0OJvGwx6/different.conf remove a 226s ok 36 - correct output of pg_conftool /tmp/Py0OJvGwx6/different.conf remove a 226s ok 37 - setting removed from file with path 226s # test edit 226s ok 38 - pg_conftool edit 226s ok 39 - correct output of pg_conftool edit 226s ok 40 - pg_conftool /tmp/Py0OJvGwx6/different.conf edit 226s ok 41 - correct output of pg_conftool /tmp/Py0OJvGwx6/different.conf edit 226s ### End test 007_pg_conftool.t ### 226s 226s ### PostgreSQL test 010_defaultport_cluster.t ### 226s 1..14 226s ok 1 - psql --version 226s ok 2 - pg_wrapper selects highest available version number 226s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 226s ok 4 - connecting to localhost fails with no clusters 226s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 226s ok 6 - pg_wrapper uses host and port from PGCLUSTER 226s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 226s ok 8 - pg_wrapper uses --cluster from the command line 226s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 226s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 226s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 226s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 226s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 226s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 226s ### End test 010_defaultport_cluster.t ### 226s 226s ### PostgreSQL test 015_start_stop.t ### 226s 1..71 226s # We are running systemd 226s # Running tests for 16 226s # Cluster does not exist yet 226s ok 1 - cluster 16 main does not exist 226s ok 2 - service postgresql@16-main does not exist 226s ok 3 - systemctl start postgresql 226s ok 4 - cluster 16 main does not exist 226s ok 5 - service postgresql@16-main does not exist 226s ok 6 - systemctl start postgresql@16-main 226s ok 7 - cluster 16 main does not exist 226s ok 8 - service postgresql@16-main does not exist 226s # Start/stop postgresql using system tools 227s ok 9 - pg_createcluster 16 main 227s ok 10 - cluster 16 main is stopped 227s ok 11 - service postgresql@16-main is stopped 229s ok 12 - systemctl start postgresql 229s ok 13 - cluster 16 main is running 229s ok 14 - service postgresql@16-main is running 229s ok 15 - systemctl start postgresql 229s ok 16 - cluster 16 main is already running 229s ok 17 - service postgresql@16-main is already running 229s ok 18 - systemctl stop postgresql 235s ok 19 - cluster 16 main is stopped 235s ok 20 - service postgresql@16-main is stopped 235s ok 21 - systemctl stop postgresql 235s ok 22 - cluster 16 main is already stopped 235s ok 23 - service postgresql@16-main is already stopped 235s # Start/stop specific cluster using system tools 238s ok 24 - systemctl start postgresql@16-main 238s ok 25 - cluster 16 main is running 238s ok 26 - service postgresql@16-main is running 238s ok 27 - systemctl start postgresql@16-main 238s ok 28 - cluster 16 main is running 238s ok 29 - service postgresql@16-main is running 240s ok 30 - systemctl restart postgresql@16-main 240s ok 31 - cluster 16 main is running 240s ok 32 - service postgresql@16-main is running 240s ok 33 - systemctl stop postgresql@16-main 240s ok 34 - cluster 16 main is stopped 240s ok 35 - service postgresql@16-main is stopped 240s ok 36 - systemctl stop postgresql@16-main 240s ok 37 - cluster 16 main is already stopped 240s ok 38 - service postgresql@16-main is already stopped 241s ok 39 - pg_dropcluster 16 main 241s ok 40 - cluster 16 main does not exist 241s ok 41 - service postgresql@16-main does not exist 241s # Start/stop specific cluster using pg_*cluster 241s ok 42 - pg_ctlcluster start 16 main 241s ok 43 - cluster 16 main does not exist 241s ok 44 - service postgresql@16-main does not exist 244s ok 45 - pg_createcluster 16 main --start 245s ok 46 - cluster 16 main is running 245s ok 47 - service postgresql@16-main is running 245s ok 48 - pg_ctlcluster 16 main start 245s ok 49 - cluster 16 main is already running 245s ok 50 - service postgresql@16-main is already running 247s ok 51 - pg_ctlcluster 16-main restart 247s ok 52 - cluster 16 main is running 247s ok 53 - service postgresql@16-main is running 247s ok 54 - pg_ctlcluster 16 main stop 247s ok 55 - cluster 16 main is stopped 247s ok 56 - service postgresql@16-main is stopped 247s ok 57 - pg_ctlcluster 16 main stop 247s ok 58 - cluster 16 main is already stopped 247s ok 59 - service postgresql@16-main is already stopped 250s ok 60 - pg_ctlcluster start 16-main 250s ok 61 - cluster 16 main is running 250s ok 62 - service postgresql@16-main is running 251s ok 63 - pg_dropcluster 16 main --stop 251s # Cleanup 251s ok 64 - Cleanup: No clusters left behind 251s ok 65 - No postgres processes left behind 251s ok 66 - No files in /etc/postgresql left behind 251s ok 67 - No files in /var/lib/postgresql left behind 251s ok 68 - No files in /var/run/postgresql left behind 251s ok 69 - No files in /var/log/postgresql left behind 251s ok 70 - PostgreSQL TCP ports are closed 251s ok 71 - Next free port is 5432 251s ### End test 015_start_stop.t ### 251s 251s ### PostgreSQL test 020_create_sql_remove.t ### 251s 1..147 251s # Running tests for 16 254s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.X3JnMi 254s ok 2 - pg_createcluster 16 main 254s ok 3 - Socket and pid file are in /var/run/postgresql/ 254s ok 4 - xlog/wal directory /tmp/16.xlog.X3JnMi was created 254s ok 5 - local method in pg_hba.conf is peer 254s ok 6 - host method in pg_hba.conf is scram-sha-256 254s ok 7 - Exactly one postgres master process running 256s ok 8 - pg_ctlcluster 16 main restart 256s ok 9 - cluster restarts with new environment file 256s ok 10 - Exactly one postgres master process running 256s ok 11 - correct value of PGEXTRAVAR1 in environment 256s ok 12 - correct value of PGEXTRAVAR2 in environment 256s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 256s ok 14 - createdb --version 256s ok 15 - pg_wrapper+createdb selects version number of cluster 256s ok 16 - psql --version 256s ok 17 - pg_wrapper+psql selects version 16 256s ok 18 - pg_lscluster reports online cluster on port 5432 256s ok 19 - log file is actually used 256s ok 20 - /etc/postgresql is owned by user "postgres" 256s ok 21 - version configuration directory file is owned by user "postgres" 256s ok 22 - configuration directory file is owned by user "postgres" 256s ok 23 - version data directory file is owned by user "postgres" 256s ok 24 - data directory file is owned by user "postgres" 256s ok 25 - log file has 0640 permissions 256s ok 26 - log file is owned by user "postgres" 256s ok 27 - log file is owned by group "adm" 256s ok 28 - no log symlink by default 256s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 256s ok 30 - pg_lsclusters -h 256s ok 31 - correct output of pg_lsclusters -h 256s ok 32 - stopping cluster 259s ok 33 - restarting cluster with nondefault log symlink 259s ok 34 - log target is used as log file 259s ok 35 - default log is not used 259s ok 36 - pg_lsclusters -h 259s ok 37 - correct output of pg_lsclusters -h 259s ok 38 - stopping cluster 262s ok 39 - restarting cluster with explicitly configured log file 262s ok 40 - default log is not used 262s ok 41 - log symlink target is used for startup message 262s ok 42 - exactly one log file 262s ok 43 - custom log is actually used 262s ok 44 - pg_lsclusters -h 262s ok 45 - correct output of pg_lsclusters -h 262s ok 46 - stopping cluster 262s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 262s ok 48 - /etc/postgres-hack was not created 264s ok 49 - restarting cluster 264s ok 50 - ps -o tty -U postgres h 264s ok 51 - postgres processes do not have an associated terminal 264s ok 52 - Server is linked with SSL support 264s ok 53 - SSL is enabled in postgresql.conf 264s ok 54 - psql -l fails for nobody 264s ok 55 - createuser nobody 264s ok 56 - createdb nobodydb 264s ok 57 - psql -ltA succeeds for nobody 264s ok 58 - psql -ltA output 265s ok 59 - SQL command: create table 265s ok 60 - SQL command: insert into table values 265s ok 61 - SQL command: insert into table values 265s ok 62 - primary key violation 265s ok 63 - psql -tAc "select * from phone order by name" nobodydb 265s ok 64 - SQL command output: select -tA 265s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 265s ok 66 - SQL command output: select -tx 265s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 265s ok 68 - SQL command output: select -tAx 265s ok 69 - CREATE EXTENSION plperlu fails for user nobody 265s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 265s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 265s ok 72 - creating PL/PerlU function as user nobody fails 265s ok 73 - creating unsafe PL/Perl function as user postgres fails 265s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 265s ok 75 - creating PL/PerlU function as user postgres succeeds 265s ok 76 - psql nobodydb -Atc "select read_file()" 265s ok 77 - calling PL/PerlU function 265s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 265s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 265s ok 80 - creating unsafe PL/Perl function as user nobody fails 265s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 265s ok 82 - creating PL/Perl function as user nobody succeeds 265s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 265s ok 84 - calling PL/Perl function 265s ok 85 # skip No python2 support 265s ok 86 # skip No python2 support 265s ok 87 # skip No python2 support 265s ok 88 # skip No python2 support 265s ok 89 # skip No python2 support 265s ok 90 # skip No python2 support 265s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 265s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 265s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 265s ok 94 - creating PL/Python3 function as user postgres succeeds 265s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 265s ok 96 - calling PL/Python function 265s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 265s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 265s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 265s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 265s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 265s ok 102 - creating PL/Tcl function as user nobody succeeds 265s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 265s ok 104 - creating PL/TclU function as user postgres succeeds 265s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 265s ok 106 - calling PL/Tcl function 265s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 265s ok 108 - calling PL/TclU function 265s ok 109 - stopping cluster 265s ok 110 - pg_ctlcluster 16 main start 265s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 268s ok 112 - pg_ctlcluster 16 main start 268s ok 113 - cluster restarts with pgdata symlink 268s ok 114 - postgres master has OOM killer protection 268s ok 115 - postgres client backend has no OOM adjustment 268s ok 116 - ps h 6356 268s ok 117 - process title is idle 269s ok 118 - ps h 6356 269s ok 119 - process title is idle in transaction 269s ok 120 - stopping cluster 271s ok 121 - starting cluster as postgres works without a log file 271s ok 122 - log file got recreated and used 271s ok 123 - creating a directory in spc2 271s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.LVZ1Nu'" 271s ok 125 - creating tablespace spc1 271s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 271s ok 127 - creating a table in spc1 271s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.gtAJqC'" 271s ok 129 - creating tablespace spc2 271s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 271s ok 131 - creating a table in spc2 271s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 271s ok 133 - Correct apt NeverAutoRemove config 272s ok 134 - pg_dropcluster removes cluster 272s ok 135 - xlog/wal directory /tmp/16.xlog.X3JnMi was deleted 272s ok 136 - tablespace spc1 was emptied 272s ok 137 - tablespace spc2 was emptied 272s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 272s ok 139 - Correct apt NeverAutoRemove config 272s # Cleanup 272s ok 140 - Cleanup: No clusters left behind 272s ok 141 - No postgres processes left behind 272s ok 142 - No files in /etc/postgresql left behind 272s ok 143 - No files in /var/lib/postgresql left behind 272s ok 144 - No files in /var/run/postgresql left behind 272s ok 145 - No files in /var/log/postgresql left behind 272s ok 146 - PostgreSQL TCP ports are closed 272s ok 147 - Next free port is 5432 272s ### End test 020_create_sql_remove.t ### 272s 272s ### PostgreSQL test 021_pg_renamecluster.t ### 272s 1..20 275s ok 1 - pg_createcluster 16 main 278s ok 2 - pg_renamecluster 16 main donau 278s ok 3 - psql -tAc "show data_directory" 278s ok 4 - cluster is running and data_directory was moved 278s ok 5 - pg_hba.conf location updated 278s ok 6 - pg_ident.conf location updated 278s ok 7 - external_pid_file location updated 278s ok 8 - external_pid_file exists 278s ok 9 # skip no stats_temp_directory in 16 278s ok 10 # skip no stats_temp_directory in 16 278s ok 11 - cluster_name is updated 279s ok 12 - pg_dropcluster removes cluster 279s # Cleanup 279s ok 13 - Cleanup: No clusters left behind 279s ok 14 - No postgres processes left behind 279s ok 15 - No files in /etc/postgresql left behind 279s ok 16 - No files in /var/lib/postgresql left behind 279s ok 17 - No files in /var/run/postgresql left behind 279s ok 18 - No files in /var/log/postgresql left behind 279s ok 19 - PostgreSQL TCP ports are closed 279s ok 20 - Next free port is 5432 279s ### End test 021_pg_renamecluster.t ### 279s 279s ### PostgreSQL test 022_recovery.t ### 279s 1..17 279s # Running tests for 16 282s ok 1 - pg_createcluster 16 main --start >/dev/null 282s ok 2 - pg_ctlcluster 16 main stop -m i 285s ok 3 - pg_ctlcluster 16 main start 285s ok 4 - psql -c '' 285s ok 5 - pg_ctlcluster 16 main stop -m i 285s ok 6 - create write-protected file in data directory 287s ok 7 - pg_ctlcluster 16 main start 287s ok 8 - psql -c '' 288s ok 9 - pg_dropcluster removes cluster 288s # Cleanup 289s ok 10 - Cleanup: No clusters left behind 289s ok 11 - No postgres processes left behind 289s ok 12 - No files in /etc/postgresql left behind 289s ok 13 - No files in /var/lib/postgresql left behind 289s ok 14 - No files in /var/run/postgresql left behind 289s ok 15 - No files in /var/log/postgresql left behind 289s ok 16 - PostgreSQL TCP ports are closed 289s ok 17 - Next free port is 5432 289s ### End test 022_recovery.t ### 289s 289s ### PostgreSQL test 025_logging.t ### 289s 1..55 289s # Logging to /var/log/syslog works 289s # Running tests for 16 292s ok 1 - pg_createcluster 16 main 292s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 292s ok 3 - psql -qc "'foobar_16_7578'" 292s ok 4 - log an error 293s ok 5 - grep --binary-files=text foobar_16_7578 /var/log/postgresql/postgresql-16-main.log 293s ok 6 - error appears in logfile 293s ok 7 - pg_conftool 16 main set log_destination syslog 293s ok 8 - set log_destination syslog 293s ok 9 - pg_ctlcluster 16 main reload 293s ok 10 - 16 main reload 293s ok 11 - psql -Atc "show log_destination" 293s ok 12 - log_destination is syslog 293s ok 13 - pg_lscluster reports syslog 293s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 293s ok 15 - error appears in /var/log/syslog 293s ok 16 - pg_conftool 16 main set logging_collector on 293s ok 17 - set logging_collector on 293s ok 18 - pg_conftool 16 main set log_destination csvlog 293s ok 19 - set log_destination csvlog 296s ok 20 - pg_ctlcluster 16 main restart 296s ok 21 - 16 main restart 296s ok 22 - psql -Atc "show logging_collector" 296s ok 23 - logging_collector is on 296s ok 24 - psql -Atc "show log_destination" 296s ok 25 - log_destination is csvlog 296s ok 26 - pg_lscluster reports csvlog 296s ok 27 - psql -qc "'barbaz_16_7578'" 296s ok 28 - log an error 296s ok 29 - grep --binary-files=text barbaz_16_7578 /var/lib/postgresql/16/main/log/*.csv 296s ok 30 - error appears in log/*.csv 296s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 296s ok 32 - set log_destination stderr,syslog,csvlog 296s ok 33 - pg_ctlcluster 16 main reload 296s ok 34 - 16 main reload 296s ok 35 - psql -Atc "show log_destination" 296s ok 36 - log_destination is stderr,syslog,csvlog 296s ok 37 - pg_lscluster reports stderr,syslog,csvlog 296s ok 38 - psql -qc "'moo_16_7578'" 296s ok 39 - log an error 297s ok 40 - grep --binary-files=text moo_16_7578 /var/lib/postgresql/16/main/log/*.log 297s ok 41 - error appears in log/*.log 297s ok 42 - grep --binary-files=text 'postgres.*moo_16_7578' /var/log/syslog 297s ok 43 - error appears in /var/log/syslog 297s ok 44 - grep --binary-files=text moo_16_7578 /var/lib/postgresql/16/main/log/*.csv 297s ok 45 - error appears in log/*.csv 299s ok 46 - pg_dropcluster 16 main --stop 299s ok 47 - pg_dropcluster removes cluster 299s # Cleanup 299s ok 48 - Cleanup: No clusters left behind 299s ok 49 - No postgres processes left behind 299s ok 50 - No files in /etc/postgresql left behind 299s ok 51 - No files in /var/lib/postgresql left behind 299s ok 52 - No files in /var/run/postgresql left behind 299s ok 53 - No files in /var/log/postgresql left behind 299s ok 54 - PostgreSQL TCP ports are closed 299s ok 55 - Next free port is 5432 299s ### End test 025_logging.t ### 299s 299s ### PostgreSQL test 027_jit.t ### 299s # 16 302s ok 1 - pg_createcluster 16 main --start 302s ok 2 - psql -Xatc 'show jit' 302s ok 3 - JIT is on by default 302s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 302s ok 5 - No JIT on cheap query 302s ok 6 - pg_conftool 16 main set seq_page_cost 100000 302s ok 7 - pg_conftool 16 main set random_page_cost 100000 302s ok 8 - pg_ctlcluster 16 main reload 302s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 302s ok 10 - Expensive query is JITed 303s ok 11 - pg_dropcluster --stop 16 main 303s # Cleanup 303s ok 12 - Cleanup: No clusters left behind 303s ok 13 - No postgres processes left behind 303s ok 14 - No files in /etc/postgresql left behind 303s ok 15 - No files in /var/lib/postgresql left behind 303s ok 16 - No files in /var/run/postgresql left behind 303s ok 17 - No files in /var/log/postgresql left behind 303s ok 18 - PostgreSQL TCP ports are closed 303s ok 19 - Next free port is 5432 303s 1..19 303s ### End test 027_jit.t ### 303s 303s ### PostgreSQL test 030_errors.t ### 303s 1..156 303s ok 1 - pg_lscluster reports cluster without binaries 304s ok 2 - pg_dropcluster 6.3 main 305s ok 3 - pg_createcluster --socketdir 305s ok 4 - pg_lsclusters -h 305s ok 5 - cluster was created 305s ok 6 - Port of created cluster is 5432 305s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 305s ok 8 - pg_createcluster on existing cluster 305s ok 9 - pg_lsclusters -h 305s ok 10 - original cluster still exists 305s ok 11 - pg_createcluster 16 test -p foo 305s ok 12 - pg_createcluster -p checks that port option is numeric 305s ok 13 - pg_createcluster 16 test -p 42 305s ok 14 - pg_createcluster -p checks valid port range 305s ok 15 - pg_ctlcluster 16 main start 305s ok 16 - pg_ctlcluster refuses to start root-owned cluster 305s ok 17 - pg_ctlcluster 16 main start 305s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 305s ok 19 - pg_ctlcluster 16 main start 305s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 305s ok 21 - pg_ctlcluster 16 main start 305s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 308s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 308s ok 24 - No sockets in /var/run/postgresql 308s ok 25 - Socket is in /tmp/postgresql-testsuite/ 308s ok 26 - cluster stops with custom unix_socket_dir 308s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 310s ok 28 - cluster starts after removing unix_socket_dir 310s ok 29 - Socket is in default dir /var/run/postgresql 310s ok 30 - No sockets in /tmp/postgresql-testsuite/ 310s ok 31 - pg_ctlcluster 16 main stop 310s ok 32 - pg_ctlcluster fails with corrupted PID file 310s ok 33 - pg_lsclusters -h 310s ok 34 - cluster is still online 310s ok 35 - pg_ctlcluster succeeds with restored PID file 310s ok 36 - pg_lsclusters -h 310s ok 37 - cluster is down 310s ok 38 - pg_ctlcluster 16 main stop 310s ok 39 - pg_ctlcluster stop fails on stopped cluster 312s ok 40 - pg_ctlcluster 16 main start 312s ok 41 - pg_ctlcluster succeeds with already existing PID file 312s ok 42 - pg_lsclusters -h 312s ok 43 - cluster is online 313s ok 44 - pg_ctlcluster stop succeeds 313s ok 45 - pg_lsclusters -h 313s ok 46 - cluster is down 313s ok 47 - no pid file left 313s ok 48 - pg_ctlcluster 16 main stop 313s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 313s ok 50 - pid file was cleaned up 313s ok 51 - pg_ctlcluster --force 16 main stop 313s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 313s ok 53 - pid file was cleaned up 313s ok 54 - pg_ctlcluster 16 main stop 313s ok 55 - pg_ctlcluster stop succeeds with stale PID file 313s ok 56 - pid file was cleaned up 313s ok 57 - pg_ctlcluster --force 16 main stop 313s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 313s ok 59 - pid file was cleaned up 313s ok 60 - pg_ctlcluster --force 16 main stop 313s ok 61 - pg_ctlcluster stop succeeds with empty PID file 313s ok 62 - pid file was cleaned up 315s ok 63 - pg_ctlcluster 16 main start 315s ok 64 - pg_ctlcluster succeeds with corrupted PID file 315s ok 65 - pg_lsclusters -h 315s ok 66 - cluster is online 315s ok 67 - pg_ctlcluster 16 main start 315s ok 68 - pg_ctlcluster start fails on running cluster 315s ok 69 - pg_ctlcluster stop 315s ok 70 - pg_ctlcluster 16 main start 315s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 315s ok 72 - pg_ctlcluster 16 main stop 315s ok 73 - stopping cluster 322s ok 74 - pg_ctlcluster 16 main start 322s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 322s ok 76 - pg_ctlcluster 16 main stop 322s ok 77 - stopping cluster 322s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 322s ok 79 - pg_dropcluster 16 main 322s ok 80 - pg_dropcluster works as user postgres 322s ok 81 - pg_createcluster succeeds 322s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 322s ok 83 - proper error message for nonexisting /var/lib/postgresql 325s ok 84 - pg_ctlcluster 16 main start 325s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 325s ok 86 - pg_ctlcluster 16 main stop 325s ok 87 - stopping cluster 326s ok 88 - pg_createcluster other 328s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 330s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 330s ok 91 330s ok 92 - pg_ctlcluster 16 other start 330s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 330s ok 94 - pg_ctlcluster 16 main stop 330s ok 95 - stopping main cluster 332s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 333s ok 97 - pg_dropcluster other 334s ok 98 - pg_dropcluster 334s ok 99 - No sockets any more 334s ok 100 - 'pg_lsclusters 4.5 foo' fails 334s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 334s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 334s ok 103 - 'psql --cluster 4.5/foo' fails 334s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 334s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 335s ok 106 - 'psql --cluster 16/foo' fails 335s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 335s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 335s ok 109 - 'pg_dropcluster 4.5 foo' fails 335s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 335s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 335s ok 112 - 'pg_dropcluster 16 foo' fails 335s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 335s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 335s ok 115 - 'pg_upgradecluster 4.5 foo' fails 335s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 335s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 335s ok 118 - 'pg_upgradecluster 16 foo' fails 335s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 335s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 335s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 335s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 335s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 335s ok 124 - 'pg_ctlcluster 16 foo stop' fails 335s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 335s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 335s # Cleanup 335s ok 127 - Cleanup: No clusters left behind 335s ok 128 - No postgres processes left behind 335s ok 129 - No files in /etc/postgresql left behind 335s ok 130 - No files in /var/lib/postgresql left behind 335s ok 131 - No files in /var/run/postgresql left behind 335s ok 132 - No files in /var/log/postgresql left behind 335s ok 133 - PostgreSQL TCP ports are closed 335s ok 134 - Next free port is 5432 336s ok 135 - pg_dropcluster 16 broken 336s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 336s # Cleanup 336s ok 137 - Cleanup: No clusters left behind 336s ok 138 - No postgres processes left behind 336s ok 139 - No files in /etc/postgresql left behind 336s ok 140 - No files in /var/lib/postgresql left behind 336s ok 141 - No files in /var/run/postgresql left behind 336s ok 142 - No files in /var/log/postgresql left behind 336s ok 143 - PostgreSQL TCP ports are closed 336s ok 144 - Next free port is 5432 337s ok 145 - pg_dropcluster 16 broken 337s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 337s ok 147 - /etc/postgresql/16 was removed 337s ok 148 - /var/lib/postgresql/16 was removed 337s # Cleanup 337s ok 149 - Cleanup: No clusters left behind 337s ok 150 - No postgres processes left behind 337s ok 151 - No files in /etc/postgresql left behind 337s ok 152 - No files in /var/lib/postgresql left behind 337s ok 153 - No files in /var/run/postgresql left behind 337s ok 154 - No files in /var/log/postgresql left behind 337s ok 155 - PostgreSQL TCP ports are closed 337s ok 156 - Next free port is 5432 337s ### End test 030_errors.t ### 337s 337s ### PostgreSQL test 031_errors_disk_full.t ### 337s 1..22 337s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 338s ok 1 - script failed 338s ok 2 - pg_createcluster fails due to insufficient disk space 338s ok 3 - does not leave files behind 338s # Cleanup 338s ok 4 - Cleanup: No clusters left behind 338s ok 5 - No postgres processes left behind 338s ok 6 - No files in /etc/postgresql left behind 338s ok 7 - No files in /var/lib/postgresql left behind 338s ok 8 - No files in /var/run/postgresql left behind 338s ok 9 - No files in /var/log/postgresql left behind 338s ok 10 - PostgreSQL TCP ports are closed 338s ok 11 - Next free port is 5432 338s # check disk full conditions on startup 340s ok 12 - script failed 340s ok 13 - pg_ctlcluster prints error message 340s ok 14 - log file has error message 340s # Cleanup 340s ok 15 - Cleanup: No clusters left behind 340s ok 16 - No postgres processes left behind 340s ok 17 - No files in /etc/postgresql left behind 340s ok 18 - No files in /var/lib/postgresql left behind 340s ok 19 - No files in /var/run/postgresql left behind 340s ok 20 - No files in /var/log/postgresql left behind 340s ok 21 - PostgreSQL TCP ports are closed 340s ok 22 - Next free port is 5432 340s ### End test 031_errors_disk_full.t ### 340s 340s ### PostgreSQL test 032_ssl_key_permissions.t ### 340s 1..22 340s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 340s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 340s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 340s # 16 (16.4-3) 341s ok 4 - pg_createcluster 16 main 341s ok 5 - pg_ctlcluster 16 main start 341s ok 6 - ssl key owned by nobody refused 341s ok 7 - pg_ctlcluster 16 main start 341s ok 8 - ssl key with permissions root:root 0644 refused 341s ok 9 - pg_ctlcluster 16 main start 341s ok 10 - ssl key with permissions postgres:postgres 0640 refused 342s ok 11 - pg_dropcluster 16 main --stop 342s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 342s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 342s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 342s # Cleanup 342s ok 15 - Cleanup: No clusters left behind 342s ok 16 - No postgres processes left behind 342s ok 17 - No files in /etc/postgresql left behind 342s ok 18 - No files in /var/lib/postgresql left behind 342s ok 19 - No files in /var/run/postgresql left behind 342s ok 20 - No files in /var/log/postgresql left behind 342s ok 21 - PostgreSQL TCP ports are closed 342s ok 22 - Next free port is 5432 342s ### End test 032_ssl_key_permissions.t ### 342s 342s ### PostgreSQL test 040_upgrade.t ### 342s 1..1 342s ok 1 - only one major version installed, skipping upgrade tests 342s ### End test 040_upgrade.t ### 342s 342s ### PostgreSQL test 041_upgrade_custompaths.t ### 342s 1..1 342s ok 1 - only one major version installed, skipping upgrade tests 342s ### End test 041_upgrade_custompaths.t ### 342s 342s ### PostgreSQL test 042_upgrade_rename.t ### 342s 1..15 342s # PostgreSQL 16 345s ok 1 - pg_createcluster 16 main --start 351s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 351s ok 3 - pg_lsclusters -h 351s ok 4 - correct output of pg_lsclusters -h 351s ok 5 - pg_dropcluster 16 main --stop 353s ok 6 - pg_dropcluster 16 upgr --stop 353s ok 7 - Cleaning pg_upgrade log files 353s # Cleanup 353s ok 8 - Cleanup: No clusters left behind 353s ok 9 - No postgres processes left behind 353s ok 10 - No files in /etc/postgresql left behind 353s ok 11 - No files in /var/lib/postgresql left behind 353s ok 12 - No files in /var/run/postgresql left behind 353s ok 13 - No files in /var/log/postgresql left behind 353s ok 14 - PostgreSQL TCP ports are closed 353s ok 15 - Next free port is 5432 353s ### End test 042_upgrade_rename.t ### 353s 353s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 353s 1..1 353s ok 1 - only one major version installed, skipping upgrade tests 353s ### End test 043_upgrade_ssl_cert.t ### 353s 353s ### PostgreSQL test 045_backup.t ### 353s # We are running systemd 353s # PostgreSQL 16 353s # create cluster 356s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 356s ok 2 - pg_lsclusters -h 356s ok 3 - correct output of pg_lsclusters -h 356s ok 4 - pg_conftool 16 main set work_mem 11MB 356s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 356s ok 6 - psql -c 'alter database mydb set search_path=public' 356s ok 7 - psql -c 'create table foo (t text)' mydb 356s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 356s ok 9 - psql -c 'CREATE USER myuser' 356s ok 10 - psql -c 'grant create on database mydb to myuser' 356s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 356s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 356s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 356s # create directory 356s ok 14 - pg_backupcluster 16 main createdirectory 356s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 356s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 356s # dump 357s ok 17 - systemctl start pg_dump@16-main 357s ok 18 - dump created in /var/backups/postgresql/16-main/2025-01-06T100502Z.dump 357s ok 19 - /var/backups/postgresql/16-main/2025-01-06T100502Z.dump owned by uid postgres 357s ok 20 - /var/backups/postgresql/16-main/2025-01-06T100502Z.dump owned by gid postgres 357s # basebackup 357s ok 21 - systemctl start pg_receivewal@16-main 357s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 357s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 357s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 357s ok 25 - psql -c 'select pg_reload_conf()' 385s ok 26 - systemctl start pg_basebackup@16-main 385s ok 27 - dump created in /var/backups/postgresql/16-main/2025-01-06T100504Z.backup 385s ok 28 - /var/backups/postgresql/16-main/2025-01-06T100504Z.backup owned by uid postgres 385s ok 29 - /var/backups/postgresql/16-main/2025-01-06T100504Z.backup owned by gid postgres 385s # list 385s ok 30 - pg_backupcluster 16 main list 385s ok 31 - correct output of pg_backupcluster 16 main list 385s # more database changes 386s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 386s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 386s ok 34 - retrieve recovery timestamp 386s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 386s ok 36 - systemctl stop pg_receivewal@16-main 386s # restore /var/backups/postgresql/16-main/2025-01-06T100502Z.dump 387s ok 37 - pg_dropcluster 16 main --stop 391s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-06T100502Z.dump --start --datadir /var/lib/postgresql/16/snowflake 391s ok 39 - pg_lsclusters -h 391s ok 40 - correct output of pg_lsclusters -h 391s ok 41 - psql -XAtl 391s ok 42 - mydb locales 391s ok 43 - mydb grants 391s ok 44 - myicudb locales 391s ok 45 - psql -XAtc 'show work_mem' 391s ok 46 - correct output of psql -XAtc 'show work_mem' 391s ok 47 - psql -XAtc 'select * from foo' mydb 391s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 391s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 391s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 391s ok 51 - psql -XAtc '\drds' 391s ok 52 - correct output of psql -XAtc '\drds' 391s # restore /var/backups/postgresql/16-main/2025-01-06T100504Z.backup 393s ok 53 - pg_dropcluster 16 main --stop 395s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-06T100504Z.backup --start --datadir /var/lib/postgresql/16/snowflake 395s ok 55 - pg_lsclusters -h 395s ok 56 - correct output of pg_lsclusters -h 395s ok 57 - psql -XAtl 395s ok 58 - mydb locales 395s ok 59 - mydb grants 395s ok 60 - myicudb locales 396s ok 61 - psql -XAtc 'show work_mem' 396s ok 62 - correct output of psql -XAtc 'show work_mem' 396s ok 63 - psql -XAtc 'select * from foo' mydb 396s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 396s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 396s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 396s ok 67 - psql -XAtc '\drds' 396s ok 68 - correct output of psql -XAtc '\drds' 396s # restore /var/backups/postgresql/16-main/2025-01-06T100504Z.backup with WAL archive 397s ok 69 - pg_dropcluster 16 main --stop 400s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-06T100504Z.backup --start --archive --port 5430 400s ok 71 - pg_lsclusters -h 400s ok 72 - correct output of pg_lsclusters -h 400s ok 73 - psql -XAtc 'select * from foo order by t' mydb 400s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 400s # restore /var/backups/postgresql/16-main/2025-01-06T100504Z.backup with PITR 401s ok 75 - pg_dropcluster 16 main --stop 404s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-06T100504Z.backup --start --pitr '2025-01-06 10:05:32.024205+00 404s # ' 404s ok 77 - pg_lsclusters -h 404s ok 78 - correct output of pg_lsclusters -h 404s ok 79 - psql -XAtc 'select * from foo order by t' mydb 404s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 406s ok 81 - pg_dropcluster 16 main --stop 406s # Cleanup 406s ok 82 - Cleanup: No clusters left behind 406s ok 83 - No postgres processes left behind 406s ok 84 - No files in /etc/postgresql left behind 406s ok 85 - No files in /var/lib/postgresql left behind 406s ok 86 - No files in /var/run/postgresql left behind 406s ok 87 - No files in /var/log/postgresql left behind 406s ok 88 - PostgreSQL TCP ports are closed 406s ok 89 - Next free port is 5432 406s 1..89 406s ### End test 045_backup.t ### 406s 406s ### PostgreSQL test 050_encodings.t ### 406s 1..60 406s # Checking 16 ru_RU 409s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 410s ok 2 - psql -l succeeds 410s ok 3 - template1 is not UTF-8 encoded 410s ok 4 - creating test database 410s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 410s # create table t (x varchar); copy t from stdin" test 410s ok 6 - creating table with ISO-8859-5 characters 410s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 410s ok 8 - correct string in UTF-8 410s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 410s ok 10 - correct string in ISO-8859-5 410s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 410s # delete from t; copy t from stdin" test 410s ok 12 - creating table with UTF-8 characters 410s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 410s ok 14 - correct string in UTF-8 410s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 410s ok 16 - correct string in ISO-8859-1 410s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 410s ok 18 - Server error message has correct language and encoding 412s ok 19 - pg_ctlcluster 16 ru_RU restart 412s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 414s ok 21 - Dropping cluster 414s # Checking 16 ru_RU.UTF-8 417s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 418s ok 23 - psql -l succeeds 418s ok 24 - template1 is UTF-8 encoded 418s ok 25 - creating test database 418s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 418s # create table t (x varchar); copy t from stdin" test 418s ok 27 - creating table with ISO-8859-5 characters 418s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 418s ok 29 - correct string in UTF-8 418s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 418s ok 31 - correct string in ISO-8859-5 418s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 418s # delete from t; copy t from stdin" test 418s ok 33 - creating table with UTF-8 characters 418s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 418s ok 35 - correct string in UTF-8 418s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 418s ok 37 - correct string in ISO-8859-1 418s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 418s ok 39 - Server error message has correct language and encoding 420s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 420s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 420s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 420s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 420s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 420s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 420s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 420s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 422s ok 48 - Dropping cluster 422s # Check 16 locale environment variables 425s ok 49 - pg_createcluster: LC_ALL dominates LANG 425s ok 50 - psql -Atl --cluster 16/main 425s ok 51 - template1 is ASCII encoded 426s ok 52 - Dropping cluster 426s # Cleanup 426s ok 53 - Cleanup: No clusters left behind 426s ok 54 - No postgres processes left behind 426s ok 55 - No files in /etc/postgresql left behind 426s ok 56 - No files in /var/lib/postgresql left behind 426s ok 57 - No files in /var/run/postgresql left behind 426s ok 58 - No files in /var/log/postgresql left behind 426s ok 59 - PostgreSQL TCP ports are closed 426s ok 60 - Next free port is 5432 426s ### End test 050_encodings.t ### 426s 426s ### PostgreSQL test 052_upgrade_encodings.t ### 426s 1..1 426s ok 1 - only one major version installed, skipping upgrade tests 426s ### End test 052_upgrade_encodings.t ### 426s 426s ### PostgreSQL test 060_obsolete_confparams.t ### 426s ok 1 - only one major version installed, skipping upgrade tests 426s 1..1 426s ### End test 060_obsolete_confparams.t ### 426s 426s ### PostgreSQL test 070_non_postgres_clusters.t ### 426s 1..40 427s ok 1 - pg_createcluster 16 main for owner nobody 427s ok 2 - pg_ctlcluster 16 main start 427s ok 3 - start refused when config and data owners mismatch 429s ok 4 - pg_ctlcluster succeeds with owner nobody 429s ok 5 - pg_lsclusters -h 429s ok 6 - pg_lsclusters shows running cluster 429s ok 7 - postgres is running as user nobody 429s ok 8 - ls /tmp/.s.PGSQL.* 429s ok 9 - socket is in /tmp 429s ok 10 - /var/run/postgresql is empty 429s ok 11 - conf dir is owned by user 429s ok 12 - conf dir is owned by user's primary group 429s ok 13 - files are owned by user 429s ok 14 - files are owned by user's primary group 429s ok 15 - log file has 0640 permissions 429s ok 16 - log file is owned by user 429s ok 17 - log file is owned by user's primary group 429s ok 18 - only one major version installed, skipping upgrade test 429s ok 19 - ... 429s ok 20 - ... 429s ok 21 - ... 429s ok 22 - ... 429s ok 23 - ... 429s ok 24 - ... 429s ok 25 - ... 429s ok 26 - ... 429s ok 27 - ... 429s ok 28 - ... 430s ok 29 - pg_dropcluster 430s ok 30 - pg_lsclusters -h 430s ok 31 - No clusters left 430s ok 32 - No postgres processes left 430s # Cleanup 430s ok 33 - Cleanup: No clusters left behind 431s ok 34 - No postgres processes left behind 431s ok 35 - No files in /etc/postgresql left behind 431s ok 36 - No files in /var/lib/postgresql left behind 431s ok 37 - No files in /var/run/postgresql left behind 431s ok 38 - No files in /var/log/postgresql left behind 431s ok 39 - PostgreSQL TCP ports are closed 431s ok 40 - Next free port is 5432 431s ### End test 070_non_postgres_clusters.t ### 431s 431s ### PostgreSQL test 080_start.conf.t ### 431s 1..73 431s ok 1 - pg_createcluster 16 main 431s # start.conf auto 431s ok 2 - get_cluster_start_conf returns auto 431s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 431s ok 4 - start.conf contains auto 431s ok 5 - systemd generator links cluster 431s ok 6 - systemd generator links correct service file 434s ok 7 - /etc/init.d/postgresql start 16 434s ok 8 - correct output of /etc/init.d/postgresql start 16 434s ok 9 - pg_lsclusters -h 434s ok 10 - cluster is online 434s ok 11 - /etc/init.d/postgresql stop 16 434s ok 12 - correct output of /etc/init.d/postgresql stop 16 437s ok 13 - pg_lsclusters -h 437s ok 14 - cluster is down 437s # start.conf manual 437s ok 15 - get_cluster_start_conf returns manual 437s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 437s ok 17 - start.conf contains manual 437s ok 18 - systemd generator doesn't link cluster 437s ok 19 - /etc/init.d/postgresql start 16 437s ok 20 - correct output of /etc/init.d/postgresql start 16 437s ok 21 - pg_lsclusters -h 437s ok 22 - cluster is down 439s ok 23 - pg_ctlcluster 16 main start 439s ok 24 - correct output of pg_ctlcluster 16 main start 439s ok 25 - pg_lsclusters -h 439s ok 26 - cluster is online 439s ok 27 - pg_ctlcluster 16 main stop 439s ok 28 - correct output of pg_ctlcluster 16 main stop 439s ok 29 - pg_lsclusters -h 439s ok 30 - cluster is down 439s # start.conf disabled 439s ok 31 - get_cluster_start_conf returns disabled 440s ok 32 - systemd generator doesn't link cluster 440s ok 33 - /etc/init.d/postgresql start 16 440s ok 34 - correct output of /etc/init.d/postgresql start 16 440s ok 35 - pg_lsclusters -h 440s ok 36 - cluster is down 440s ok 37 - pg_ctlcluster 16 main start 440s ok 38 - correct output of pg_ctlcluster 16 main start 440s ok 39 - pg_lsclusters -h 440s ok 40 - cluster is down 442s ok 41 - pg_ctlcluster 16 main start 442s ok 42 - correct output of pg_ctlcluster 16 main start 442s ok 43 - pg_lsclusters -h 442s ok 44 - cluster is online 442s ok 45 - pg_ctlcluster 16 main stop 442s ok 46 - correct output of pg_ctlcluster 16 main stop 442s ok 47 - pg_lsclusters -h 442s ok 48 - cluster is down 444s ok 49 - pg_ctlcluster 16 main start 444s ok 50 - correct output of pg_ctlcluster 16 main start 444s ok 51 - pg_lsclusters -h 444s ok 52 - cluster is online 444s # test upgrade 444s ok 53 - only one major version installed, skipping upgrade test 444s ok 54 - ... 444s ok 55 - get_cluster_start_conf for old cluster returns manual 444s ok 56 - get_cluster_start_conf for new cluster returns manual 444s ok 57 - ... 445s ok 58 - dropping upgraded cluster 445s ok 59 - pg_lsclusters -h 445s ok 60 - no clusters any more 445s ok 61 - pg_createcluster 16 main --start-conf foo 445s ok 62 - pg_createcluster checks --start-conf validity 446s ok 63 - pg_createcluster checks --start-conf manual 446s ok 64 - get_cluster_start_conf returns manual 447s ok 65 - dropping cluster 447s # Cleanup 447s ok 66 - Cleanup: No clusters left behind 447s ok 67 - No postgres processes left behind 447s ok 68 - No files in /etc/postgresql left behind 447s ok 69 - No files in /var/lib/postgresql left behind 447s ok 70 - No files in /var/run/postgresql left behind 447s ok 71 - No files in /var/log/postgresql left behind 447s ok 72 - PostgreSQL TCP ports are closed 447s ok 73 - Next free port is 5432 447s ### End test 080_start.conf.t ### 447s 447s ### PostgreSQL test 085_pg_ctl.conf.t ### 447s 1..33 447s ok 1 - prlimit --core=0:unlimited --pid=16594 447s ok 2 - set core file size to unlimited 447s ok 3 - sh -c 'ulimit -Hc' 447s ok 4 - core file size is unlimited 448s ok 5 - pg_createcluster 16 main 448s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 450s ok 7 - pg_ctlcluster 16 main start 450s ok 8 - starting cluster as root 450s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 450s ok 10 - soft core size is 0 450s # hard core file size limit of root-started postgres process is unlimited 450s ok 11 - set pg_ctl default option to -c 452s ok 12 - pg_ctlcluster 16 main restart 452s ok 13 - restarting cluster as root 452s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 452s ok 15 - soft core size is unlimited 453s ok 16 - pg_ctlcluster 16 main stop 453s ok 17 - stopping cluster 453s ok 18 - restored pg_ctl default option 455s ok 19 - pg_ctlcluster 16 main start -- -c 455s ok 20 - starting cluster with -c on the command line as postgres 455s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 455s ok 22 - soft core size is unlimited 455s ok 23 - pg_ctlcluster 16 main stop 455s ok 24 - stopping cluster 456s ok 25 - dropping cluster 456s # Cleanup 456s ok 26 - Cleanup: No clusters left behind 456s ok 27 - No postgres processes left behind 456s ok 28 - No files in /etc/postgresql left behind 456s ok 29 - No files in /var/lib/postgresql left behind 456s ok 30 - No files in /var/run/postgresql left behind 456s ok 31 - No files in /var/log/postgresql left behind 456s ok 32 - PostgreSQL TCP ports are closed 456s ok 33 - Next free port is 5432 456s ### End test 085_pg_ctl.conf.t ### 456s 456s ### PostgreSQL test 090_multicluster.t ### 456s 1..125 457s ok 1 - pg_createcluster 16 old 457s ok 2 - pg_createcluster 16 new1 458s ok 3 - pg_createcluster 16 new2 460s ok 4 - starting cluster 16/old 463s ok 5 - starting cluster 16/new1 465s ok 6 - starting cluster 16/new2 465s ok 7 - pg_lsclusters -h | sort -k3 465s ok 8 - clusters have the correct ports, skipping used 5433 465s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 465s ok 10 - createdb --version 465s ok 11 - pg_wrapper selects port 5432 as default cluster 465s ok 12 - createdb --cluster 16/new1 --version 465s ok 13 - pg_wrapper --cluster works 465s ok 14 - createdb --cluster 16/foo --version 465s ok 15 - pg_wrapper --cluster errors out for invalid cluster 465s ok 16 - createdb --cluster 16/new1 test 465s ok 17 - correct output of createdb --cluster 16/new1 test 465s ok 18 - psql -Atl --cluster 16/new1 465s ok 19 - test db appears in cluster new1 465s ok 20 - psql -Atl --cluster 16/new2 465s ok 21 - test db does not appear in cluster new2 465s ok 22 - psql -Atl 465s ok 23 - test db does not appear in default cluster 465s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 465s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 465s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 465s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 465s ok 28 - psql -Atl --cluster 16/localhost:5434 465s ok 29 - test db appears in cluster 16/localhost:5434 465s ok 30 - psql -Atl --cluster 16/localhost:5440 465s ok 31 - test db does not appear in cluster 16/localhost:5440 465s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 465s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 465s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 465s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 465s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 465s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 465s ok 38 - psql -Atl --cluster 6.4/localhost: 465s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 465s ok 40 - psql -Atl 465s ok 41 - PGCLUSTER selection (1) 465s ok 42 - psql -Atl 465s ok 43 - PGCLUSTER selection (2) 465s ok 44 - psql -l 465s ok 45 - invalid PGCLUSTER value 465s ok 46 - createdb --version 465s ok 47 - PGCLUSTER network cluster selection (1) 466s ok 48 - psql -Atl 466s ok 49 - PGCLUSTER network cluster selection (2) 466s ok 50 - psql -Atl 466s ok 51 - PGCLUSTER network cluster selection (3) 466s ok 52 - LC_MESSAGES=C psql -Atl 466s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 466s ok 54 - psql -Atc "show port" template1 466s ok 55 - PGPORT selection (1) 466s ok 56 - psql -Atc "show port" template1 466s ok 57 - PGPORT selection (2) 466s ok 58 - createdb --version 466s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 466s ok 60 - psql -Atc "show port" template1 466s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 466s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 466s ok 63 - PGDATABASE environment variable works 466s ok 64 - createdb --version 466s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 466s ok 66 - createdb --cluster 16/new1 --version 466s ok 67 - pg_wrapper --cluster works with empty user_clusters 466s ok 68 - createdb --version 466s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 466s ok 70 - psql -Atc "select current_database()" 466s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 466s ok 72 - psql -Atc 'select current_database()' 466s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 466s ok 74 - createdb --version 466s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 466s ok 76 - createdb --version 466s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 466s ok 78 - createdb --version 466s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 466s ok 80 - createdb --version 466s ok 81 - pg_wrapper selects correct version with per-user user_clusters 466s ok 82 - createdb --version 466s ok 83 - pg_wrapper selects correct version with per-user user_clusters 466s ok 84 - createdb --version 466s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 466s ok 86 - psql -Atl 466s ok 87 - $PGHOST overrides user_clusters 466s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 466s ok 89 - --cluster overrides $PGHOST 466s ok 90 - createdb --version 466s ok 91 - pg_wrapper ignores invalid lines in user_clusters 466s ok 92 - psql -Atc 'select current_database()' 466s ok 93 - pg_service conf selection 1 466s ok 94 - psql -Atc 'select current_database()' 466s ok 95 - pg_service conf selection 2 466s ok 96 - psql -Atc 'select current_database()' 466s ok 97 - pg_service conf selection 3 466s ok 98 - stopping cluster 16/old 469s ok 99 - restarting cluster 16/old 469s ok 100 - pg_lsclusters -h | sort -k3 469s ok 101 - port of first cluster was successfully changed 469s ok 102 - psql -l 469s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 469s ok 104 - psql -Atl --cluster 16/new1 469s ok 105 - --cluster selects appropriate cluster 469s ok 106 - psql -Atl -p 5434 469s ok 107 - -p selects appropriate cluster 469s ok 108 - psql -Atlp 5434 469s ok 109 - -Atlp selects appropriate cluster 469s ok 110 - psql -Atl --port 5434 469s ok 111 - --port selects appropriate cluster 469s ok 112 - env PGPORT=5434 psql -Atl 469s ok 113 - $PGPORT selects appropriate cluster 469s ok 114 - Restoring original /etc/postgresql-common/user_clusters 470s ok 115 - dropping 16/new1 471s ok 116 - dropping 16/new2 472s ok 117 - dropping 16/old 472s # Cleanup 472s ok 118 - Cleanup: No clusters left behind 472s ok 119 - No postgres processes left behind 472s ok 120 - No files in /etc/postgresql left behind 472s ok 121 - No files in /var/lib/postgresql left behind 472s ok 122 - No files in /var/run/postgresql left behind 472s ok 123 - No files in /var/log/postgresql left behind 472s ok 124 - PostgreSQL TCP ports are closed 472s ok 125 - Next free port is 5432 472s ### End test 090_multicluster.t ### 472s 472s ### PostgreSQL test 110_integrate_cluster.t ### 472s 1..32 473s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/8dVHWdQ9A2/c/postgres 473s ok 2 - creating raw initdb cluster for user postgres 473s ok 3 - pg_createcluster 16 postgres -d /tmp/8dVHWdQ9A2/c/postgres 473s ok 4 - integrating postgres cluster 473s ok 5 - pg_lsclusters 473s ok 6 - correct pg_lsclusters output 476s ok 7 - pg_ctlcluster 16 postgres start 476s ok 8 - starting cluster postgres 476s ok 9 - pg_lsclusters 476s ok 10 - correct pg_lsclusters output 477s ok 11 - dropping cluster postgres 477s ok 12 - No files in temporary cluster dir left behind 477s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/8dVHWdQ9A2/c/nobody 477s ok 14 - creating raw initdb cluster for user nobody 477s ok 15 - pg_createcluster 16 nobody -d /tmp/8dVHWdQ9A2/c/nobody 477s ok 16 - integrating nobody cluster 477s ok 17 - pg_lsclusters 477s ok 18 - correct pg_lsclusters output 480s ok 19 - pg_ctlcluster 16 nobody start 480s ok 20 - starting cluster nobody 480s ok 21 - pg_lsclusters 480s ok 22 - correct pg_lsclusters output 481s ok 23 - dropping cluster nobody 481s ok 24 - No files in temporary cluster dir left behind 481s # Cleanup 481s ok 25 - Cleanup: No clusters left behind 481s ok 26 - No postgres processes left behind 481s ok 27 - No files in /etc/postgresql left behind 481s ok 28 - No files in /var/lib/postgresql left behind 481s ok 29 - No files in /var/run/postgresql left behind 481s ok 30 - No files in /var/log/postgresql left behind 481s ok 31 - PostgreSQL TCP ports are closed 481s ok 32 - Next free port is 5432 481s ### End test 110_integrate_cluster.t ### 481s 481s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 481s 1..1 481s ok 1 - only one major version installed, skipping upgrade tests 481s ### End test 120_pg_upgradecluster_scripts.t ### 481s 481s ### PostgreSQL test 130_nonroot_admin.t ### 481s 1..22 484s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 484s ok 2 - pg_lsclusters -h 484s ok 3 - correct output of pg_lsclusters -h 484s ok 4 - psql -Atl 484s ok 5 - correct output of psql -Atl 484s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 484s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 484s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 484s # Cleanup 484s ok 15 - Cleanup: No clusters left behind 484s ok 16 - No postgres processes left behind 484s ok 17 - No files in /etc/postgresql left behind 484s ok 18 - No files in /var/lib/postgresql left behind 484s ok 19 - No files in /var/run/postgresql left behind 484s ok 20 - No files in /var/log/postgresql left behind 484s ok 21 - PostgreSQL TCP ports are closed 484s ok 22 - Next free port is 5432 484s ### End test 130_nonroot_admin.t ### 484s 484s ### PostgreSQL test 135_pg_virtualenv.t ### 484s 1..20 488s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 488s ok 2 - running pg_virtualenv as root 491s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 491s ok 4 - running pg_virtualenv as postgres 494s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 494s ok 6 - running pg_virtualenv as nobody 497s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 497s ok 8 - running fakeroot pg_virtualenv as root 500s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 500s ok 10 - running fakeroot pg_virtualenv as postgres 503s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 503s ok 12 - running fakeroot pg_virtualenv as nobody 503s # Cleanup 503s ok 13 - Cleanup: No clusters left behind 503s ok 14 - No postgres processes left behind 503s ok 15 - No files in /etc/postgresql left behind 503s ok 16 - No files in /var/lib/postgresql left behind 503s ok 17 - No files in /var/run/postgresql left behind 503s ok 18 - No files in /var/log/postgresql left behind 503s ok 19 - PostgreSQL TCP ports are closed 503s ok 20 - Next free port is 5432 503s ### End test 135_pg_virtualenv.t ### 503s 503s ### PostgreSQL test 140_pg_config.t ### 503s 1..38 503s # Multiarch is enabled 503s # checking version specific output for 16 503s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 503s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 503s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 503s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 503s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 503s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 503s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 503s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 503s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 503s # checking pg_config output (should behave like version 16) 503s ok 15 - pg_config 503s ok 16 - correct output of pg_config 503s ok 17 - pg_config --help 503s ok 18 - correct output of pg_config --help 503s ok 19 - pg_config --pgxs 503s ok 20 - correct output of pg_config --pgxs 503s ok 21 - pg_config --libdir 503s ok 22 - correct output of pg_config --libdir 503s ok 23 - pg_config --pkglibdir 503s ok 24 - correct output of pg_config --pkglibdir 503s ok 25 - pg_config --bindir 503s ok 26 - correct output of pg_config --bindir 503s # checking pg_config.libpq-dev output (should behave like version 17) 503s ok 27 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 503s ok 28 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 503s ok 29 - pg_config.libpq-dev --help 503s ok 30 - correct output of pg_config.libpq-dev --help 503s ok 31 - pg_config.libpq-dev --pgxs 503s ok 32 - correct output of pg_config.libpq-dev --pgxs 503s ok 33 - pg_config.libpq-dev --libdir 503s ok 34 - correct output of pg_config.libpq-dev --libdir 503s ok 35 - pg_config.libpq-dev --pkglibdir 503s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 503s ok 37 - pg_config.libpq-dev --bindir 503s ok 38 - correct output of pg_config.libpq-dev --bindir 503s ### End test 140_pg_config.t ### 503s 503s ### PostgreSQL test 150_tsearch_stemming.t ### 503s 1..37 503s ok 1 - pg_updatedicts succeeded 503s ok 2 - pg_updatedicts created en_us.affix 503s ok 3 - pg_updatedicts created en_us.dict 503s ok 4 - pg_updatedicts created 16 en_us.affix symlink 503s ok 5 - pg_updatedicts created 16 en_us.dict symlink 506s ok 6 - pg_createcluster 16 main 506s ok 7 - createdb fts 506s ok 8 - correct output of createdb fts 506s ok 9 - creating en_US full text search configuration 506s ok 10 - creating data table and search index 507s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 507s ok 12 - stem search of correct word 507s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 507s ok 14 - stem search of correct word 507s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 507s ok 16 - stem search of unknown word 507s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 507s ok 18 - full text search, exact word 507s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 507s ok 20 - full text search for word stem 507s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 507s ok 22 - full text search for word substring fails 507s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 507s ok 24 - full text search, exact unicode word 507s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 507s ok 26 - full text search for unicode word stem 507s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 507s ok 28 - full text search for unicode word substring fails 508s ok 29 508s # Cleanup 508s ok 30 - Cleanup: No clusters left behind 508s ok 31 - No postgres processes left behind 508s ok 32 - No files in /etc/postgresql left behind 508s ok 33 - No files in /var/lib/postgresql left behind 508s ok 34 - No files in /var/run/postgresql left behind 508s ok 35 - No files in /var/log/postgresql left behind 508s ok 36 - PostgreSQL TCP ports are closed 508s ok 37 - Next free port is 5432 508s ### End test 150_tsearch_stemming.t ### 508s 508s ### PostgreSQL test 160_alternate_confroot.t ### 508s 1..28 511s ok 1 511s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 511s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 511s ok 4 - pg_lsclusters -h 511s ok 5 - correct output of pg_lsclusters -h 511s ok 6 - psql -Atl 511s ok 7 - correct output of psql -Atl 511s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 511s ok 9 - ... 511s ok 10 - ... 511s ok 11 - ... 511s ok 12 - ... 511s ok 13 - ... 511s ok 14 - ... 511s ok 15 - pg_dropcluster 16 test --stop 511s ok 16 - correct output of pg_dropcluster 16 test --stop 511s ok 17 - pg_lsclusters -h 511s ok 18 - correct output of pg_lsclusters -h 511s ok 19 - No files in root/data left behind 511s ok 20 - No cruft in root dir left behind 511s # Cleanup 511s ok 21 - Cleanup: No clusters left behind 511s ok 22 - No postgres processes left behind 511s ok 23 - No files in /etc/postgresql left behind 511s ok 24 - No files in /var/lib/postgresql left behind 511s ok 25 - No files in /var/run/postgresql left behind 511s ok 26 - No files in /var/log/postgresql left behind 511s ok 27 - PostgreSQL TCP ports are closed 511s ok 28 - Next free port is 5432 511s ### End test 160_alternate_confroot.t ### 511s 511s ### PostgreSQL test 170_extensions.t ### 511s # Running tests for 16 515s ok 1 - pg_createcluster 16 main 515s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 515s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 515s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 515s ok 5 - extension adminpack installs without error 515s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 515s ok 7 - extension adminpack removes without error 515s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 515s ok 9 - extension amcheck installs without error 515s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 515s ok 11 - extension amcheck removes without error 515s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 515s ok 13 - extension autoinc installs without error 515s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 515s ok 15 - extension autoinc removes without error 515s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 515s ok 17 - extension bloom installs without error 515s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 515s ok 19 - extension bloom removes without error 515s ok 20 - psql -qc 'CREATE EXTENSION plperl' 515s ok 21 - bool_plperl dependency plperl installs without error 515s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 515s ok 23 - extension bool_plperl installs without error 515s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 515s ok 25 - extension bool_plperl removes without error 515s ok 26 - psql -qc 'DROP EXTENSION plperl' 515s ok 27 - bool_plperl dependency extension plperl removes without error 515s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 515s ok 29 - bool_plperlu dependency plperlu installs without error 515s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 515s ok 31 - extension bool_plperlu installs without error 515s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 515s ok 33 - extension bool_plperlu removes without error 515s ok 34 - psql -qc 'DROP EXTENSION plperlu' 515s ok 35 - bool_plperlu dependency extension plperlu removes without error 515s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 515s ok 37 - extension btree_gin installs without error 515s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 515s ok 39 - extension btree_gin removes without error 515s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 515s ok 41 - extension btree_gist installs without error 515s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 515s ok 43 - extension btree_gist removes without error 515s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 515s ok 45 - extension citext installs without error 515s ok 46 - psql -qc 'DROP EXTENSION "citext"' 515s ok 47 - extension citext removes without error 515s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 515s ok 49 - extension cube installs without error 515s ok 50 - psql -qc 'DROP EXTENSION "cube"' 515s ok 51 - extension cube removes without error 515s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 515s ok 53 - extension dblink installs without error 516s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 516s ok 55 - extension dblink removes without error 516s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 516s ok 57 - extension dict_int installs without error 516s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 516s ok 59 - extension dict_int removes without error 516s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 516s ok 61 - extension dict_xsyn installs without error 516s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 516s ok 63 - extension dict_xsyn removes without error 516s ok 64 - psql -qc 'CREATE EXTENSION cube' 516s ok 65 - earthdistance dependency cube installs without error 516s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 516s ok 67 - extension earthdistance installs without error 516s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 516s ok 69 - extension earthdistance removes without error 516s ok 70 - psql -qc 'DROP EXTENSION cube' 516s ok 71 - earthdistance dependency extension cube removes without error 516s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 516s ok 73 - extension file_fdw installs without error 516s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 516s ok 75 - extension file_fdw removes without error 516s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 516s ok 77 - extension fuzzystrmatch installs without error 516s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 516s ok 79 - extension fuzzystrmatch removes without error 516s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 516s ok 81 - extension hstore installs without error 516s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 516s ok 83 - extension hstore removes without error 516s ok 84 - psql -qc 'CREATE EXTENSION hstore' 516s ok 85 - hstore_plperl dependency hstore installs without error 516s ok 86 - psql -qc 'CREATE EXTENSION plperl' 516s ok 87 - hstore_plperl dependency plperl installs without error 516s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 516s ok 89 - extension hstore_plperl installs without error 516s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 516s ok 91 - extension hstore_plperl removes without error 516s ok 92 - psql -qc 'DROP EXTENSION hstore' 516s ok 93 - hstore_plperl dependency extension hstore removes without error 516s ok 94 - psql -qc 'DROP EXTENSION plperl' 516s ok 95 - hstore_plperl dependency extension plperl removes without error 516s ok 96 - psql -qc 'CREATE EXTENSION hstore' 516s ok 97 - hstore_plperlu dependency hstore installs without error 516s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 516s ok 99 - hstore_plperlu dependency plperlu installs without error 516s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 516s ok 101 - extension hstore_plperlu installs without error 516s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 516s ok 103 - extension hstore_plperlu removes without error 516s ok 104 - psql -qc 'DROP EXTENSION hstore' 516s ok 105 - hstore_plperlu dependency extension hstore removes without error 516s ok 106 - psql -qc 'DROP EXTENSION plperlu' 516s ok 107 - hstore_plperlu dependency extension plperlu removes without error 516s ok 108 - psql -qc 'CREATE EXTENSION hstore' 516s ok 109 - hstore_plpython3u dependency hstore installs without error 516s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 516s ok 111 - hstore_plpython3u dependency plpython3u installs without error 516s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 516s ok 113 - extension hstore_plpython3u installs without error 516s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 516s ok 115 - extension hstore_plpython3u removes without error 516s ok 116 - psql -qc 'DROP EXTENSION hstore' 516s ok 117 - hstore_plpython3u dependency extension hstore removes without error 516s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 516s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 517s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 517s ok 121 - extension insert_username installs without error 517s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 517s ok 123 - extension insert_username removes without error 517s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 517s ok 125 - extension intagg installs without error 517s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 517s ok 127 - extension intagg removes without error 517s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 517s ok 129 - extension intarray installs without error 517s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 517s ok 131 - extension intarray removes without error 517s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 517s ok 133 - extension isn installs without error 517s ok 134 - psql -qc 'DROP EXTENSION "isn"' 517s ok 135 - extension isn removes without error 517s ok 136 - psql -qc 'CREATE EXTENSION plperl' 517s ok 137 - jsonb_plperl dependency plperl installs without error 517s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 517s ok 139 - extension jsonb_plperl installs without error 517s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 517s ok 141 - extension jsonb_plperl removes without error 517s ok 142 - psql -qc 'DROP EXTENSION plperl' 517s ok 143 - jsonb_plperl dependency extension plperl removes without error 517s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 517s ok 145 - jsonb_plperlu dependency plperlu installs without error 517s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 517s ok 147 - extension jsonb_plperlu installs without error 517s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 517s ok 149 - extension jsonb_plperlu removes without error 517s ok 150 - psql -qc 'DROP EXTENSION plperlu' 517s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 517s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 517s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 517s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 517s ok 155 - extension jsonb_plpython3u installs without error 517s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 517s ok 157 - extension jsonb_plpython3u removes without error 517s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 517s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 517s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 517s ok 161 - extension lo installs without error 517s ok 162 - psql -qc 'DROP EXTENSION "lo"' 517s ok 163 - extension lo removes without error 517s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 517s ok 165 - extension ltree installs without error 517s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 517s ok 167 - extension ltree removes without error 517s ok 168 - psql -qc 'CREATE EXTENSION ltree' 517s ok 169 - ltree_plpython3u dependency ltree installs without error 517s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 517s ok 171 - ltree_plpython3u dependency plpython3u installs without error 517s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 517s ok 173 - extension ltree_plpython3u installs without error 517s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 517s ok 175 - extension ltree_plpython3u removes without error 517s ok 176 - psql -qc 'DROP EXTENSION ltree' 517s ok 177 - ltree_plpython3u dependency extension ltree removes without error 517s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 517s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 517s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 517s ok 181 - extension moddatetime installs without error 518s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 518s ok 183 - extension moddatetime removes without error 518s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 518s ok 185 - extension old_snapshot installs without error 518s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 518s ok 187 - extension old_snapshot removes without error 518s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 518s ok 189 - extension pageinspect installs without error 518s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 518s ok 191 - extension pageinspect removes without error 518s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 518s ok 193 - extension pg_buffercache installs without error 518s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 518s ok 195 - extension pg_buffercache removes without error 518s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 518s ok 197 - extension pg_freespacemap installs without error 518s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 518s ok 199 - extension pg_freespacemap removes without error 518s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 518s ok 201 - extension pg_prewarm installs without error 518s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 518s ok 203 - extension pg_prewarm removes without error 518s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 518s ok 205 - extension pg_stat_statements installs without error 518s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 518s ok 207 - extension pg_stat_statements removes without error 518s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 518s ok 209 - extension pg_surgery installs without error 518s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 518s ok 211 - extension pg_surgery removes without error 518s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 518s ok 213 - extension pg_trgm installs without error 518s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 518s ok 215 - extension pg_trgm removes without error 518s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 518s ok 217 - extension pg_visibility installs without error 518s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 518s ok 219 - extension pg_visibility removes without error 518s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 518s ok 221 - extension pg_walinspect installs without error 518s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 518s ok 223 - extension pg_walinspect removes without error 518s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 518s ok 225 - extension pgcrypto installs without error 518s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 518s ok 227 - extension pgcrypto removes without error 518s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 518s ok 229 - extension pgrowlocks installs without error 518s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 518s ok 231 - extension pgrowlocks removes without error 518s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 518s ok 233 - extension pgstattuple installs without error 518s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 518s ok 235 - extension pgstattuple removes without error 518s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 518s ok 237 - extension plperl installs without error 518s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 518s ok 239 - extension plperl removes without error 518s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 518s ok 241 - extension plperlu installs without error 518s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 518s ok 243 - extension plperlu removes without error 518s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 518s ok 245 - extension plpython3u installs without error 519s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 519s ok 247 - extension plpython3u removes without error 519s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 519s ok 249 - extension pltcl installs without error 519s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 519s ok 251 - extension pltcl removes without error 519s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 519s ok 253 - extension pltclu installs without error 519s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 519s ok 255 - extension pltclu removes without error 519s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 519s ok 257 - extension postgres_fdw installs without error 519s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 519s ok 259 - extension postgres_fdw removes without error 519s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 519s ok 261 - extension refint installs without error 519s ok 262 - psql -qc 'DROP EXTENSION "refint"' 519s ok 263 - extension refint removes without error 519s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 519s ok 265 - extension seg installs without error 519s ok 266 - psql -qc 'DROP EXTENSION "seg"' 519s ok 267 - extension seg removes without error 519s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 519s ok 269 - extension sslinfo installs without error 519s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 519s ok 271 - extension sslinfo removes without error 519s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 519s ok 273 - extension tablefunc installs without error 519s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 519s ok 275 - extension tablefunc removes without error 519s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 519s ok 277 - extension tcn installs without error 519s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 519s ok 279 - extension tcn removes without error 519s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 519s ok 281 - extension tsm_system_rows installs without error 519s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 519s ok 283 - extension tsm_system_rows removes without error 519s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 519s ok 285 - extension tsm_system_time installs without error 519s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 519s ok 287 - extension tsm_system_time removes without error 519s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 519s ok 289 - extension unaccent installs without error 519s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 519s ok 291 - extension unaccent removes without error 519s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 519s ok 293 - extension uuid-ossp installs without error 519s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 519s ok 295 - extension uuid-ossp removes without error 519s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 519s ok 297 - extension xml2 installs without error 519s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 519s ok 299 - extension xml2 removes without error 521s ok 300 - pg_dropcluster 16 main 521s # Cleanup 521s ok 301 - Cleanup: No clusters left behind 521s ok 302 - No postgres processes left behind 521s ok 303 - No files in /etc/postgresql left behind 521s ok 304 - No files in /var/lib/postgresql left behind 521s ok 305 - No files in /var/run/postgresql left behind 521s ok 306 - No files in /var/log/postgresql left behind 521s ok 307 - PostgreSQL TCP ports are closed 521s ok 308 - Next free port is 5432 521s 1..308 521s ### End test 170_extensions.t ### 521s 521s ### PostgreSQL test 180_ecpg.t ### 521s 1..14 521s ok 1 - ecpg test.pgc 521s ok 2 - ecpg processing 521s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 521s ok 4 - compiling ecpg output 528s ok 5 - pg_virtualenv /tmp/tmp.c8RhCoNlbV/test 528s ok 6 - test program runs and gives correct output 528s # Cleanup 528s ok 7 - Cleanup: No clusters left behind 528s ok 8 - No postgres processes left behind 528s ok 9 - No files in /etc/postgresql left behind 528s ok 10 - No files in /var/lib/postgresql left behind 528s ok 11 - No files in /var/run/postgresql left behind 528s ok 12 - No files in /var/log/postgresql left behind 528s ok 13 - PostgreSQL TCP ports are closed 528s ok 14 - Next free port is 5432 528s ### End test 180_ecpg.t ### 528s 528s ### PostgreSQL test 190_pg_buildext.t ### 528s ok 1 - make clean 528s ok 2 - make tar 528s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 528s # testing 'dh --with pgxs' 530s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 530s ok 5 - postgresql-16-foo_123-1_s390x.deb was built 537s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 537s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 538s ok 8 - dpkg -i postgresql-16-foo_123-1_s390x.deb 545s ok 9 - cd foo-123 && pg_buildext installcheck 545s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 552s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 552s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 559s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 559s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 559s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 559s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 559s ok 17 - dpkg -r postgresql-16-foo 559s # testing 'dh --with pgxs_loop' 559s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 561s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 561s ok 20 - postgresql-16-foo_123-1_s390x.deb was built 561s ok 21 - make clean 561s # testing pg_buildext updatecontrol 561s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 561s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 561s 1..23 561s ### End test 190_pg_buildext.t ### 561s 561s ### PostgreSQL test 200_maintscripts.t ### 561s 1..15 561s # We are running systemd 564s ok 1 - pg_createcluster 16 main --start 564s ok 2 - postmaster PID is 23120 565s ok 3 - apt-get update -q 565s # postgresql-common: 565s # Installed: 262 565s # Candidate: 262 565s # Version table: 565s # 267 100 565s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages 565s # *** 262 500 565s # 500 http://ftpmaster.internal/ubuntu plucky/main s390x Packages 565s # 100 /var/lib/dpkg/status 567s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 567s # postgresql-common: 567s # Installed: 262 567s # Candidate: 262 567s # Version table: 567s # 267 100 567s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages 567s # *** 262 500 567s # 500 http://ftpmaster.internal/ubuntu plucky/main s390x Packages 567s # 100 /var/lib/dpkg/status 567s ok 5 - postmaster PID is 23120 567s ok 6 - postmaster was not restarted 569s ok 7 - pg_dropcluster 16 main --stop 569s # Cleanup 569s ok 8 - Cleanup: No clusters left behind 569s ok 9 - No postgres processes left behind 569s ok 10 - No files in /etc/postgresql left behind 569s ok 11 - No files in /var/lib/postgresql left behind 569s ok 12 - No files in /var/run/postgresql left behind 569s ok 13 - No files in /var/log/postgresql left behind 569s ok 14 - PostgreSQL TCP ports are closed 569s ok 15 - Next free port is 5432 569s ### End test 200_maintscripts.t ### 569s 569s autopkgtest [10:08:35]: test run-testsuite: -----------------------] 570s autopkgtest [10:08:36]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 570s run-testsuite PASS 570s autopkgtest [10:08:36]: @@@@@@@@@@@@@@@@@@@@ summary 570s default-psql PASS 570s run-testsuite PASS 576s nova [W] Using flock in prodstack6-s390x 576s Creating nova instance adt-plucky-s390x-postgresql-common-20250106-095906-juju-7f2275-prod-proposed-migration-environment-2-8345b794-2d04-41ce-ae58-2aa64d9baa91 from image adt/ubuntu-plucky-s390x-server-20250106.img (UUID 5b452c36-3901-4afa-abc7-e21db541e94d)... 576s nova [W] Timed out waiting for 6d09839b-6b39-4975-a6cc-4984b49cc9b5 to get deleted. 576s nova [W] Using flock in prodstack6-s390x 576s Creating nova instance adt-plucky-s390x-postgresql-common-20250106-095906-juju-7f2275-prod-proposed-migration-environment-2-8345b794-2d04-41ce-ae58-2aa64d9baa91 from image adt/ubuntu-plucky-s390x-server-20250106.img (UUID 5b452c36-3901-4afa-abc7-e21db541e94d)... 576s nova [W] Timed out waiting for aa316c9a-8351-4248-a50d-33347631c8ef to get deleted.