0s autopkgtest [19:55:59]: starting date and time: 2024-03-24 19:55:59+0000 0s autopkgtest [19:55:59]: git checkout: 4a1cd702 l/adt_testbed: don't blame the testbed for unsolvable build deps 0s autopkgtest [19:55:59]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.pjme7ndz/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:procps --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=procps/2:4.0.4-4ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos02-s390x-7.secgroup --name adt-noble-s390x-postgresql-common-20240324-195559-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -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,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 92s autopkgtest [19:57:31]: testbed dpkg architecture: s390x 92s autopkgtest [19:57:31]: testbed apt version: 2.7.12 92s autopkgtest [19:57:31]: @@@@@@@@@@@@@@@@@@@@ test bed setup 93s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 94s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3981 kB] 94s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [57.3 kB] 94s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [495 kB] 94s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 94s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main s390x Packages [692 kB] 94s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main s390x c-n-f Metadata [3032 B] 94s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x Packages [1372 B] 94s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x c-n-f Metadata [116 B] 94s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x Packages [4195 kB] 94s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x c-n-f Metadata [7292 B] 94s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x Packages [47.2 kB] 94s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x c-n-f Metadata [116 B] 96s Fetched 9603 kB in 2s (3997 kB/s) 97s Reading package lists... 100s Reading package lists... 100s Building dependency tree... 100s Reading state information... 100s Calculating upgrade... 100s The following packages will be upgraded: 100s libproc2-0 procps 100s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 100s Need to get 784 kB of archives. 100s After this operation, 4096 B of additional disk space will be used. 100s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main s390x libproc2-0 s390x 2:4.0.4-4ubuntu2 [60.1 kB] 100s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main s390x procps s390x 2:4.0.4-4ubuntu2 [724 kB] 100s Fetched 784 kB in 1s (1457 kB/s) 101s (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 ... 52170 files and directories currently installed.) 101s Preparing to unpack .../libproc2-0_2%3a4.0.4-4ubuntu2_s390x.deb ... 101s Unpacking libproc2-0:s390x (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 101s Preparing to unpack .../procps_2%3a4.0.4-4ubuntu2_s390x.deb ... 101s Unpacking procps (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 101s Setting up libproc2-0:s390x (2:4.0.4-4ubuntu2) ... 101s Setting up procps (2:4.0.4-4ubuntu2) ... 101s Processing triggers for man-db (2.12.0-3) ... 102s Processing triggers for libc-bin (2.39-0ubuntu6) ... 102s Reading package lists... 102s Building dependency tree... 102s Reading state information... 103s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s Unknown architecture, assuming PC-style ttyS0 103s sh: Attempting to set up Debian/Ubuntu apt sources automatically 103s sh: Distribution appears to be Ubuntu 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 104s eatmydata is already the newest version (131-1). 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 104s dbus is already the newest version (1.14.10-4ubuntu1). 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 104s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s rng-tools-debian is already the newest version (2.4). 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 105s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s The following packages will be REMOVED: 105s cloud-init* python3-configobj* python3-debconf* 105s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 105s After this operation, 3256 kB disk space will be freed. 105s (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 ... 52171 files and directories currently installed.) 105s Removing cloud-init (24.1.2-0ubuntu1) ... 106s Removing python3-configobj (5.0.8-3) ... 106s Removing python3-debconf (1.5.86) ... 106s Processing triggers for man-db (2.12.0-3) ... 106s (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 ... 51782 files and directories currently installed.) 106s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 107s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 107s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 107s invoke-rc.d: policy-rc.d denied execution of try-restart. 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s linux-generic is already the newest version (6.8.0-11.11+1). 107s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 108s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 108s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 109s Reading package lists... 109s Reading package lists... 109s Building dependency tree... 109s Reading state information... 110s Calculating upgrade... 110s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 110s Reading package lists... 110s Building dependency tree... 110s Reading state information... 110s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s autopkgtest [19:57:49]: rebooting testbed after setup commands that affected boot 125s autopkgtest [19:58:04]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Tue Feb 13 23:45:46 UTC 2024 128s autopkgtest [19:58:07]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 133s Get:1 http://ftpmaster.internal/ubuntu noble/main postgresql-common 257 (dsc) [2383 B] 133s Get:2 http://ftpmaster.internal/ubuntu noble/main postgresql-common 257 (tar) [217 kB] 133s gpgv: Signature made Thu Feb 8 12:33:31 2024 UTC 133s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 133s gpgv: Can't check signature: No public key 133s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_257.dsc: no acceptable signature found 133s autopkgtest [19:58:12]: testing package postgresql-common version 257 133s autopkgtest [19:58:12]: build not needed 134s autopkgtest [19:58:13]: test default-psql: preparing testbed 139s Reading package lists... 139s Building dependency tree... 139s Reading state information... 139s Starting pkgProblemResolver with broken count: 0 139s Starting 2 pkgProblemResolver with broken count: 0 139s Done 139s The following additional packages will be installed: 139s libjson-perl libllvm17 libpq5 libxslt1.1 postgresql postgresql-16 139s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 139s Suggested packages: 139s postgresql-doc postgresql-doc-16 139s Recommended packages: 139s libjson-xs-perl 139s The following NEW packages will be installed: 139s autopkgtest-satdep libjson-perl libllvm17 libpq5 libxslt1.1 postgresql 139s postgresql-16 postgresql-client-16 postgresql-client-common 139s postgresql-common ssl-cert 139s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 139s Need to get 49.8 MB/49.8 MB of archives. 139s After this operation, 213 MB of additional disk space will be used. 139s Get:1 /tmp/autopkgtest.chtxJJ/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [704 B] 139s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x libjson-perl all 4.10000-1 [81.9 kB] 139s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-common all 257 [36.2 kB] 139s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 139s Get:5 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-common all 257 [162 kB] 140s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x libllvm17 s390x 1:17.0.6-5build1 [31.2 MB] 141s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x libpq5 s390x 16.2-1 [143 kB] 141s Get:8 http://ftpmaster.internal/ubuntu noble/main s390x libxslt1.1 s390x 1.1.39-0exp1 [170 kB] 141s Get:9 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-16 s390x 16.2-1 [1295 kB] 141s Get:10 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-16 s390x 16.2-1 [16.7 MB] 141s Get:11 http://ftpmaster.internal/ubuntu noble/main s390x postgresql all 16+257 [11.4 kB] 141s Preconfiguring packages ... 141s Fetched 49.8 MB in 2s (26.3 MB/s) 141s Selecting previously unselected package libjson-perl. 141s (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 ... 51727 files and directories currently installed.) 141s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 141s Unpacking libjson-perl (4.10000-1) ... 141s Selecting previously unselected package postgresql-client-common. 141s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 141s Unpacking postgresql-client-common (257) ... 141s Selecting previously unselected package ssl-cert. 141s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 141s Unpacking ssl-cert (1.1.2ubuntu1) ... 141s Selecting previously unselected package postgresql-common. 141s Preparing to unpack .../03-postgresql-common_257_all.deb ... 141s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 141s Unpacking postgresql-common (257) ... 142s Selecting previously unselected package libllvm17:s390x. 142s Preparing to unpack .../04-libllvm17_1%3a17.0.6-5build1_s390x.deb ... 142s Unpacking libllvm17:s390x (1:17.0.6-5build1) ... 143s Selecting previously unselected package libpq5:s390x. 143s Preparing to unpack .../05-libpq5_16.2-1_s390x.deb ... 143s Unpacking libpq5:s390x (16.2-1) ... 143s Selecting previously unselected package libxslt1.1:s390x. 143s Preparing to unpack .../06-libxslt1.1_1.1.39-0exp1_s390x.deb ... 143s Unpacking libxslt1.1:s390x (1.1.39-0exp1) ... 143s Selecting previously unselected package postgresql-client-16. 143s Preparing to unpack .../07-postgresql-client-16_16.2-1_s390x.deb ... 143s Unpacking postgresql-client-16 (16.2-1) ... 143s Selecting previously unselected package postgresql-16. 143s Preparing to unpack .../08-postgresql-16_16.2-1_s390x.deb ... 143s Unpacking postgresql-16 (16.2-1) ... 143s Selecting previously unselected package postgresql. 143s Preparing to unpack .../09-postgresql_16+257_all.deb ... 143s Unpacking postgresql (16+257) ... 143s Selecting previously unselected package autopkgtest-satdep. 143s Preparing to unpack .../10-1-autopkgtest-satdep.deb ... 143s Unpacking autopkgtest-satdep (0) ... 143s Setting up postgresql-client-common (257) ... 143s Setting up libpq5:s390x (16.2-1) ... 143s Setting up ssl-cert (1.1.2ubuntu1) ... 144s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 144s Setting up libjson-perl (4.10000-1) ... 144s Setting up libxslt1.1:s390x (1.1.39-0exp1) ... 144s Setting up libllvm17:s390x (1:17.0.6-5build1) ... 144s Setting up postgresql-client-16 (16.2-1) ... 145s 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 145s Setting up postgresql-common (257) ... 145s 145s Creating config file /etc/postgresql-common/createcluster.conf with new version 145s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 145s Removing obsolete dictionary files: 146s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 146s Setting up postgresql-16 (16.2-1) ... 146s Creating new PostgreSQL cluster 16/main ... 146s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 146s The files belonging to this database system will be owned by user "postgres". 146s This user must also own the server process. 146s 146s The database cluster will be initialized with locale "C.UTF-8". 146s The default database encoding has accordingly been set to "UTF8". 146s The default text search configuration will be set to "english". 146s 146s Data page checksums are disabled. 146s 146s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 146s creating subdirectories ... ok 146s selecting dynamic shared memory implementation ... posix 146s selecting default max_connections ... 100 146s selecting default shared_buffers ... 128MB 146s selecting default time zone ... Etc/UTC 146s creating configuration files ... ok 147s running bootstrap script ... ok 147s performing post-bootstrap initialization ... ok 147s syncing data to disk ... ok 150s Setting up postgresql (16+257) ... 150s Setting up autopkgtest-satdep (0) ... 150s Processing triggers for man-db (2.12.0-3) ... 151s Processing triggers for libc-bin (2.39-0ubuntu6) ... 153s (Reading database ... 53672 files and directories currently installed.) 153s Removing autopkgtest-satdep (0) ... 154s autopkgtest [19:58:33]: test default-psql: [----------------------- 154s autopkgtest [19:58:33]: test default-psql: -----------------------] 155s default-psql PASS 155s autopkgtest [19:58:34]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 155s autopkgtest [19:58:34]: test run-testsuite: preparing testbed 285s autopkgtest [20:00:44]: testbed dpkg architecture: s390x 285s autopkgtest [20:00:44]: testbed apt version: 2.7.12 285s autopkgtest [20:00:44]: @@@@@@@@@@@@@@@@@@@@ test bed setup 286s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 287s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [495 kB] 287s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3981 kB] 288s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [57.3 kB] 288s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 288s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main s390x Packages [692 kB] 288s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main s390x c-n-f Metadata [3032 B] 288s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x Packages [1372 B] 288s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x c-n-f Metadata [116 B] 288s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x Packages [4195 kB] 288s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x c-n-f Metadata [7292 B] 288s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x Packages [47.2 kB] 288s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x c-n-f Metadata [116 B] 292s Fetched 9603 kB in 4s (2375 kB/s) 292s Reading package lists... 295s Reading package lists... 296s Building dependency tree... 296s Reading state information... 296s Calculating upgrade... 297s The following packages will be upgraded: 297s libproc2-0 procps 297s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 297s Need to get 784 kB of archives. 297s After this operation, 4096 B of additional disk space will be used. 297s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main s390x libproc2-0 s390x 2:4.0.4-4ubuntu2 [60.1 kB] 297s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main s390x procps s390x 2:4.0.4-4ubuntu2 [724 kB] 298s Fetched 784 kB in 1s (1413 kB/s) 298s (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 ... 52170 files and directories currently installed.) 298s Preparing to unpack .../libproc2-0_2%3a4.0.4-4ubuntu2_s390x.deb ... 298s Unpacking libproc2-0:s390x (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 298s Preparing to unpack .../procps_2%3a4.0.4-4ubuntu2_s390x.deb ... 298s Unpacking procps (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 298s Setting up libproc2-0:s390x (2:4.0.4-4ubuntu2) ... 298s Setting up procps (2:4.0.4-4ubuntu2) ... 299s Processing triggers for man-db (2.12.0-3) ... 300s Processing triggers for libc-bin (2.39-0ubuntu6) ... 301s Reading package lists... 301s Building dependency tree... 301s Reading state information... 301s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 302s Unknown architecture, assuming PC-style ttyS0 302s sh: Attempting to set up Debian/Ubuntu apt sources automatically 302s sh: Distribution appears to be Ubuntu 303s Reading package lists... 303s Building dependency tree... 303s Reading state information... 304s eatmydata is already the newest version (131-1). 304s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 304s Reading package lists... 304s Building dependency tree... 304s Reading state information... 305s dbus is already the newest version (1.14.10-4ubuntu1). 305s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 305s Reading package lists... 305s Building dependency tree... 305s Reading state information... 305s rng-tools-debian is already the newest version (2.4). 305s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 305s Reading package lists... 306s Building dependency tree... 306s Reading state information... 306s The following packages will be REMOVED: 306s cloud-init* python3-configobj* python3-debconf* 307s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 307s After this operation, 3256 kB disk space will be freed. 307s (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 ... 52171 files and directories currently installed.) 307s Removing cloud-init (24.1.2-0ubuntu1) ... 307s Removing python3-configobj (5.0.8-3) ... 307s Removing python3-debconf (1.5.86) ... 308s Processing triggers for man-db (2.12.0-3) ... 308s (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 ... 51782 files and directories currently installed.) 308s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 309s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 309s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 309s invoke-rc.d: policy-rc.d denied execution of try-restart. 309s Reading package lists... 310s Building dependency tree... 310s Reading state information... 310s linux-generic is already the newest version (6.8.0-11.11+1). 310s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 310s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 310s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 311s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 314s Reading package lists... 314s Reading package lists... 314s Building dependency tree... 314s Reading state information... 315s Calculating upgrade... 315s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 315s Reading package lists... 316s Building dependency tree... 316s Reading state information... 316s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 316s autopkgtest [20:01:15]: rebooting testbed after setup commands that affected boot 339s Reading package lists... 339s Building dependency tree... 339s Reading state information... 339s Starting pkgProblemResolver with broken count: 0 339s Starting 2 pkgProblemResolver with broken count: 0 339s Done 340s The following additional packages will be installed: 340s autoconf automake autopoint autotools-dev build-essential clang-17 cpp 340s cpp-13 cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 340s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 340s fakeroot g++ g++-13 g++-13-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-13 340s gcc-13-s390x-linux-gnu gcc-s390x-linux-gnu gettext hunspell-en-us 340s icu-devtools intltool-debian libarchive-zip-perl libasan8 libatomic1 340s libc-dev-bin libc6-dev libcc1-0 libclang-common-17-dev libclang-cpp17 340s libclang1-17 libcrypt-dev libdebhelper-perl libdw1 libecpg-compat3 340s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 340s libgc1 libgcc-13-dev libgomp1 libicu-dev libisl23 libitm1 libjson-perl 340s libllvm17 libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 340s libpq-dev libpq5 libpython3.12 libssl-dev libstdc++-13-dev 340s libsub-override-perl libtcl8.6 libtool libubsan1 libxml2-dev libxslt1.1 340s libz3-4 libz3-dev linux-libc-dev llvm-17 llvm-17-dev llvm-17-linker-tools 340s llvm-17-runtime llvm-17-tools locales-all m4 po-debconf postgresql-16 340s postgresql-all postgresql-client-16 postgresql-client-common 340s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 340s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 340s postgresql-server-dev-all rpcsvc-proto ssl-cert 340s Suggested packages: 340s autoconf-archive gnu-standards autoconf-doc clang-17-doc wasi-libc cpp-doc 340s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 340s g++-multilib g++-13-multilib gcc-13-doc gcc-multilib manpages-dev flex bison 340s gdb gcc-doc gcc-13-multilib gdb-s390x-linux-gnu gettext-doc libasprintf-dev 340s libgettextpo-dev hunspell openoffice.org-hunspell | openoffice.org-core 340s glibc-doc icu-doc ncurses-doc libssl-doc libstdc++-13-doc tcl8.6 libtool-doc 340s gfortran | fortran95-compiler gcj-jdk pkg-config llvm-17-doc m4-doc 340s libmail-box-perl 340s Recommended packages: 340s manpages manpages-dev libc-devtools libclang-rt-17-dev libarchive-cpio-perl 340s libjson-xs-perl libltdl-dev libmail-sendmail-perl 340s The following NEW packages will be installed: 340s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 340s clang-17 cpp cpp-13 cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper 340s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 340s emacsen-common fakeroot g++ g++-13 g++-13-s390x-linux-gnu 340s g++-s390x-linux-gnu gcc gcc-13 gcc-13-s390x-linux-gnu gcc-s390x-linux-gnu 340s gettext hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl 340s libasan8 libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-17-dev 340s libclang-cpp17 libclang1-17 libcrypt-dev libdebhelper-perl libdw1 340s libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 340s libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 libicu-dev 340s libisl23 libitm1 libjson-perl libllvm17 libmpc3 libncurses-dev 340s libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.12 340s libssl-dev libstdc++-13-dev libsub-override-perl libtcl8.6 libtool libubsan1 340s libxml2-dev libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-17 llvm-17-dev 340s llvm-17-linker-tools llvm-17-runtime llvm-17-tools locales-all m4 po-debconf 340s postgresql-16 postgresql-all postgresql-client-16 postgresql-client-common 340s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 340s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 340s postgresql-server-dev-all rpcsvc-proto ssl-cert 340s 0 upgraded, 99 newly installed, 0 to remove and 0 not upgraded. 340s Need to get 250 MB/250 MB of archives. 340s After this operation, 1430 MB of additional disk space will be used. 340s Get:1 /tmp/autopkgtest.chtxJJ/2-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [796 B] 340s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x libjson-perl all 4.10000-1 [81.9 kB] 340s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-common all 257 [36.2 kB] 340s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 340s Get:5 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-common all 257 [162 kB] 341s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x m4 s390x 1.4.19-4 [255 kB] 341s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x autoconf all 2.71-3 [339 kB] 341s Get:8 http://ftpmaster.internal/ubuntu noble/main s390x autotools-dev all 20220109.1 [44.9 kB] 341s Get:9 http://ftpmaster.internal/ubuntu noble/main s390x automake all 1:1.16.5-1.3ubuntu1 [558 kB] 341s Get:10 http://ftpmaster.internal/ubuntu noble/main s390x autopoint all 0.21-14ubuntu1 [422 kB] 341s Get:11 http://ftpmaster.internal/ubuntu noble/main s390x libc-dev-bin s390x 2.39-0ubuntu6 [20.2 kB] 341s Get:12 http://ftpmaster.internal/ubuntu noble/main s390x linux-libc-dev s390x 6.8.0-11.11 [1590 kB] 342s Get:13 http://ftpmaster.internal/ubuntu noble/main s390x libcrypt-dev s390x 1:4.4.36-4 [135 kB] 342s Get:14 http://ftpmaster.internal/ubuntu noble/main s390x rpcsvc-proto s390x 1.4.2-0ubuntu6 [64.7 kB] 342s Get:15 http://ftpmaster.internal/ubuntu noble/main s390x libc6-dev s390x 2.39-0ubuntu6 [1629 kB] 342s Get:16 http://ftpmaster.internal/ubuntu noble/main s390x libisl23 s390x 0.26-3 [722 kB] 342s Get:17 http://ftpmaster.internal/ubuntu noble/main s390x libmpc3 s390x 1.3.1-1 [54.9 kB] 342s Get:18 http://ftpmaster.internal/ubuntu noble/main s390x cpp-13-s390x-linux-gnu s390x 13.2.0-17ubuntu2 [9929 kB] 344s Get:19 http://ftpmaster.internal/ubuntu noble/main s390x cpp-13 s390x 13.2.0-17ubuntu2 [1026 B] 344s Get:20 http://ftpmaster.internal/ubuntu noble/main s390x cpp-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [5308 B] 344s Get:21 http://ftpmaster.internal/ubuntu noble/main s390x cpp s390x 4:13.2.0-7ubuntu1 [22.4 kB] 344s Get:22 http://ftpmaster.internal/ubuntu noble/main s390x libcc1-0 s390x 14-20240303-1ubuntu1 [49.9 kB] 344s Get:23 http://ftpmaster.internal/ubuntu noble/main s390x libgomp1 s390x 14-20240303-1ubuntu1 [151 kB] 344s Get:24 http://ftpmaster.internal/ubuntu noble/main s390x libitm1 s390x 14-20240303-1ubuntu1 [31.1 kB] 344s Get:25 http://ftpmaster.internal/ubuntu noble/main s390x libatomic1 s390x 14-20240303-1ubuntu1 [9392 B] 344s Get:26 http://ftpmaster.internal/ubuntu noble/main s390x libasan8 s390x 14-20240303-1ubuntu1 [2998 kB] 344s Get:27 http://ftpmaster.internal/ubuntu noble/main s390x libubsan1 s390x 14-20240303-1ubuntu1 [1186 kB] 344s Get:28 http://ftpmaster.internal/ubuntu noble/main s390x libgcc-13-dev s390x 13.2.0-17ubuntu2 [1003 kB] 344s Get:29 http://ftpmaster.internal/ubuntu noble/main s390x gcc-13-s390x-linux-gnu s390x 13.2.0-17ubuntu2 [19.1 MB] 345s Get:30 http://ftpmaster.internal/ubuntu noble/main s390x gcc-13 s390x 13.2.0-17ubuntu2 [467 kB] 345s Get:31 http://ftpmaster.internal/ubuntu noble/main s390x gcc-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [1208 B] 345s Get:32 http://ftpmaster.internal/ubuntu noble/main s390x gcc s390x 4:13.2.0-7ubuntu1 [5014 B] 345s Get:33 http://ftpmaster.internal/ubuntu noble/main s390x libstdc++-13-dev s390x 13.2.0-17ubuntu2 [2430 kB] 345s Get:34 http://ftpmaster.internal/ubuntu noble/main s390x g++-13-s390x-linux-gnu s390x 13.2.0-17ubuntu2 [11.3 MB] 345s Get:35 http://ftpmaster.internal/ubuntu noble/main s390x g++-13 s390x 13.2.0-17ubuntu2 [14.4 kB] 345s Get:36 http://ftpmaster.internal/ubuntu noble/main s390x g++-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [956 B] 346s Get:37 http://ftpmaster.internal/ubuntu noble/main s390x g++ s390x 4:13.2.0-7ubuntu1 [1096 B] 346s Get:38 http://ftpmaster.internal/ubuntu noble/main s390x build-essential s390x 12.10ubuntu1 [4930 B] 346s Get:39 http://ftpmaster.internal/ubuntu noble/main s390x libllvm17 s390x 1:17.0.6-5build1 [31.2 MB] 347s Get:40 http://ftpmaster.internal/ubuntu noble/universe s390x libclang-cpp17 s390x 1:17.0.6-5build1 [15.3 MB] 347s Get:41 http://ftpmaster.internal/ubuntu noble/main s390x libgc1 s390x 1:8.2.6-1 [95.0 kB] 347s Get:42 http://ftpmaster.internal/ubuntu noble/universe s390x libobjc4 s390x 14-20240303-1ubuntu1 [50.4 kB] 347s Get:43 http://ftpmaster.internal/ubuntu noble/universe s390x libobjc-13-dev s390x 13.2.0-17ubuntu2 [194 kB] 347s Get:44 http://ftpmaster.internal/ubuntu noble/universe s390x libclang-common-17-dev all 1:17.0.6-5build1 [690 kB] 347s Get:45 http://ftpmaster.internal/ubuntu noble/universe s390x llvm-17-linker-tools s390x 1:17.0.6-5build1 [1514 kB] 347s Get:46 http://ftpmaster.internal/ubuntu noble/universe s390x libclang1-17 s390x 1:17.0.6-5build1 [8710 kB] 347s Get:47 http://ftpmaster.internal/ubuntu noble/universe s390x clang-17 s390x 1:17.0.6-5build1 [79.6 kB] 347s Get:48 http://ftpmaster.internal/ubuntu noble/main s390x libdebhelper-perl all 13.14.1ubuntu1 [89.5 kB] 347s Get:49 http://ftpmaster.internal/ubuntu noble/main s390x libtool all 2.4.7-7 [166 kB] 347s Get:50 http://ftpmaster.internal/ubuntu noble/main s390x dh-autoreconf all 20 [16.1 kB] 347s Get:51 http://ftpmaster.internal/ubuntu noble/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 347s Get:52 http://ftpmaster.internal/ubuntu noble/main s390x libsub-override-perl all 0.10-1 [10.0 kB] 347s Get:53 http://ftpmaster.internal/ubuntu noble/main s390x libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 347s Get:54 http://ftpmaster.internal/ubuntu noble/main s390x dh-strip-nondeterminism all 1.13.1-1 [5362 B] 347s Get:55 http://ftpmaster.internal/ubuntu noble/main s390x libdw1 s390x 0.190-1 [282 kB] 347s Get:56 http://ftpmaster.internal/ubuntu noble/main s390x debugedit s390x 1:5.0-5 [47.5 kB] 348s Get:57 http://ftpmaster.internal/ubuntu noble/main s390x dwz s390x 0.15-1 [108 kB] 348s Get:58 http://ftpmaster.internal/ubuntu noble/main s390x gettext s390x 0.21-14ubuntu1 [917 kB] 348s Get:59 http://ftpmaster.internal/ubuntu noble/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 348s Get:60 http://ftpmaster.internal/ubuntu noble/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 348s Get:61 http://ftpmaster.internal/ubuntu noble/main s390x debhelper all 13.14.1ubuntu1 [869 kB] 348s Get:62 http://ftpmaster.internal/ubuntu noble/main s390x emacsen-common all 3.0.5 [12.1 kB] 348s Get:63 http://ftpmaster.internal/ubuntu noble/main s390x dictionaries-common all 1.29.7 [188 kB] 348s Get:64 http://ftpmaster.internal/ubuntu noble/main s390x libfakeroot s390x 1.33-1 [31.9 kB] 348s Get:65 http://ftpmaster.internal/ubuntu noble/main s390x fakeroot s390x 1.33-1 [67.5 kB] 348s Get:66 http://ftpmaster.internal/ubuntu noble/main s390x hunspell-en-us all 1:2020.12.07-2 [280 kB] 348s Get:67 http://ftpmaster.internal/ubuntu noble/main s390x icu-devtools s390x 74.2-1ubuntu1 [224 kB] 348s Get:68 http://ftpmaster.internal/ubuntu noble/main s390x libpgtypes3 s390x 16.2-1 [48.3 kB] 348s Get:69 http://ftpmaster.internal/ubuntu noble/main s390x libpq5 s390x 16.2-1 [143 kB] 348s Get:70 http://ftpmaster.internal/ubuntu noble/main s390x libecpg6 s390x 16.2-1 [47.7 kB] 348s Get:71 http://ftpmaster.internal/ubuntu noble/main s390x libecpg-compat3 s390x 16.2-1 [18.7 kB] 348s Get:72 http://ftpmaster.internal/ubuntu noble/main s390x libssl-dev s390x 3.0.10-1ubuntu4 [2128 kB] 348s Get:73 http://ftpmaster.internal/ubuntu noble/main s390x libpq-dev s390x 16.2-1 [155 kB] 348s Get:74 http://ftpmaster.internal/ubuntu noble/main s390x libecpg-dev s390x 16.2-1 [280 kB] 348s Get:75 http://ftpmaster.internal/ubuntu noble/main s390x libicu-dev s390x 74.2-1ubuntu1 [11.9 MB] 348s Get:76 http://ftpmaster.internal/ubuntu noble/main s390x libncurses-dev s390x 6.4+20240113-1ubuntu1 [412 kB] 348s Get:77 http://ftpmaster.internal/ubuntu noble/main s390x libpython3.12 s390x 3.12.2-1 [2561 kB] 348s Get:78 http://ftpmaster.internal/ubuntu noble/main s390x libtcl8.6 s390x 8.6.13+dfsg-2 [948 kB] 348s Get:79 http://ftpmaster.internal/ubuntu noble/main s390x libxml2-dev s390x 2.9.14+dfsg-1.3ubuntu1 [833 kB] 348s Get:80 http://ftpmaster.internal/ubuntu noble/main s390x libxslt1.1 s390x 1.1.39-0exp1 [170 kB] 348s Get:81 http://ftpmaster.internal/ubuntu noble/universe s390x llvm-17-runtime s390x 1:17.0.6-5build1 [605 kB] 348s Get:82 http://ftpmaster.internal/ubuntu noble/universe s390x libpfm4 s390x 4.13.0+git32-g0d4ed0e-1 [38.8 kB] 348s Get:83 http://ftpmaster.internal/ubuntu noble/universe s390x llvm-17 s390x 1:17.0.6-5build1 [27.8 MB] 349s Get:84 http://ftpmaster.internal/ubuntu noble/main s390x libffi-dev s390x 3.4.6-1 [58.8 kB] 349s Get:85 http://ftpmaster.internal/ubuntu noble/universe s390x llvm-17-tools s390x 1:17.0.6-5build1 [563 kB] 349s Get:86 http://ftpmaster.internal/ubuntu noble/universe s390x libz3-4 s390x 4.8.12-3.1 [5366 kB] 349s Get:87 http://ftpmaster.internal/ubuntu noble/universe s390x libz3-dev s390x 4.8.12-3.1 [72.2 kB] 349s Get:88 http://ftpmaster.internal/ubuntu noble/universe s390x llvm-17-dev s390x 1:17.0.6-5build1 [46.7 MB] 351s Get:89 http://ftpmaster.internal/ubuntu noble/universe s390x locales-all s390x 2.39-0ubuntu6 [11.3 MB] 351s Get:90 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-16 s390x 16.2-1 [1295 kB] 351s Get:91 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-16 s390x 16.2-1 [16.7 MB] 352s Get:92 http://ftpmaster.internal/ubuntu noble/universe s390x postgresql-server-dev-16 s390x 16.2-1 [1231 kB] 352s Get:93 http://ftpmaster.internal/ubuntu noble/universe s390x postgresql-server-dev-all s390x 257 [20.3 kB] 352s Get:94 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-plperl-16 s390x 16.2-1 [69.6 kB] 352s Get:95 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-plpython3-16 s390x 16.2-1 [76.3 kB] 352s Get:96 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-pltcl-16 s390x 16.2-1 [30.9 kB] 352s Get:97 http://ftpmaster.internal/ubuntu noble/universe s390x postgresql-all all 257 [1714 B] 352s Get:98 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-doc-16 all 16.2-1 [2093 kB] 352s Get:99 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-doc all 16+257 [11.4 kB] 353s Preconfiguring packages ... 353s Fetched 250 MB in 12s (20.8 MB/s) 353s Selecting previously unselected package libjson-perl. 353s (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 ... 51727 files and directories currently installed.) 353s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 353s Unpacking libjson-perl (4.10000-1) ... 353s Selecting previously unselected package postgresql-client-common. 353s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 353s Unpacking postgresql-client-common (257) ... 353s Selecting previously unselected package ssl-cert. 353s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 353s Unpacking ssl-cert (1.1.2ubuntu1) ... 353s Selecting previously unselected package postgresql-common. 353s Preparing to unpack .../03-postgresql-common_257_all.deb ... 353s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 353s Unpacking postgresql-common (257) ... 353s Selecting previously unselected package m4. 353s Preparing to unpack .../04-m4_1.4.19-4_s390x.deb ... 353s Unpacking m4 (1.4.19-4) ... 353s Selecting previously unselected package autoconf. 353s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 353s Unpacking autoconf (2.71-3) ... 353s Selecting previously unselected package autotools-dev. 354s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 354s Unpacking autotools-dev (20220109.1) ... 354s Selecting previously unselected package automake. 354s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 354s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 354s Selecting previously unselected package autopoint. 354s Preparing to unpack .../08-autopoint_0.21-14ubuntu1_all.deb ... 354s Unpacking autopoint (0.21-14ubuntu1) ... 354s Selecting previously unselected package libc-dev-bin. 354s Preparing to unpack .../09-libc-dev-bin_2.39-0ubuntu6_s390x.deb ... 354s Unpacking libc-dev-bin (2.39-0ubuntu6) ... 354s Selecting previously unselected package linux-libc-dev:s390x. 354s Preparing to unpack .../10-linux-libc-dev_6.8.0-11.11_s390x.deb ... 354s Unpacking linux-libc-dev:s390x (6.8.0-11.11) ... 354s Selecting previously unselected package libcrypt-dev:s390x. 354s Preparing to unpack .../11-libcrypt-dev_1%3a4.4.36-4_s390x.deb ... 354s Unpacking libcrypt-dev:s390x (1:4.4.36-4) ... 354s Selecting previously unselected package rpcsvc-proto. 354s Preparing to unpack .../12-rpcsvc-proto_1.4.2-0ubuntu6_s390x.deb ... 354s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 354s Selecting previously unselected package libc6-dev:s390x. 354s Preparing to unpack .../13-libc6-dev_2.39-0ubuntu6_s390x.deb ... 354s Unpacking libc6-dev:s390x (2.39-0ubuntu6) ... 354s Selecting previously unselected package libisl23:s390x. 354s Preparing to unpack .../14-libisl23_0.26-3_s390x.deb ... 354s Unpacking libisl23:s390x (0.26-3) ... 354s Selecting previously unselected package libmpc3:s390x. 354s Preparing to unpack .../15-libmpc3_1.3.1-1_s390x.deb ... 354s Unpacking libmpc3:s390x (1.3.1-1) ... 354s Selecting previously unselected package cpp-13-s390x-linux-gnu. 354s Preparing to unpack .../16-cpp-13-s390x-linux-gnu_13.2.0-17ubuntu2_s390x.deb ... 354s Unpacking cpp-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 355s Selecting previously unselected package cpp-13. 355s Preparing to unpack .../17-cpp-13_13.2.0-17ubuntu2_s390x.deb ... 355s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 355s Selecting previously unselected package cpp-s390x-linux-gnu. 355s Preparing to unpack .../18-cpp-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 355s Unpacking cpp-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 355s Selecting previously unselected package cpp. 355s Preparing to unpack .../19-cpp_4%3a13.2.0-7ubuntu1_s390x.deb ... 355s Unpacking cpp (4:13.2.0-7ubuntu1) ... 355s Selecting previously unselected package libcc1-0:s390x. 355s Preparing to unpack .../20-libcc1-0_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libcc1-0:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libgomp1:s390x. 355s Preparing to unpack .../21-libgomp1_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libgomp1:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libitm1:s390x. 355s Preparing to unpack .../22-libitm1_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libitm1:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libatomic1:s390x. 355s Preparing to unpack .../23-libatomic1_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libatomic1:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libasan8:s390x. 355s Preparing to unpack .../24-libasan8_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libasan8:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libubsan1:s390x. 355s Preparing to unpack .../25-libubsan1_14-20240303-1ubuntu1_s390x.deb ... 355s Unpacking libubsan1:s390x (14-20240303-1ubuntu1) ... 355s Selecting previously unselected package libgcc-13-dev:s390x. 355s Preparing to unpack .../26-libgcc-13-dev_13.2.0-17ubuntu2_s390x.deb ... 355s Unpacking libgcc-13-dev:s390x (13.2.0-17ubuntu2) ... 355s Selecting previously unselected package gcc-13-s390x-linux-gnu. 355s Preparing to unpack .../27-gcc-13-s390x-linux-gnu_13.2.0-17ubuntu2_s390x.deb ... 355s Unpacking gcc-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 356s Selecting previously unselected package gcc-13. 356s Preparing to unpack .../28-gcc-13_13.2.0-17ubuntu2_s390x.deb ... 356s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 356s Selecting previously unselected package gcc-s390x-linux-gnu. 356s Preparing to unpack .../29-gcc-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 356s Unpacking gcc-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 356s Selecting previously unselected package gcc. 356s Preparing to unpack .../30-gcc_4%3a13.2.0-7ubuntu1_s390x.deb ... 356s Unpacking gcc (4:13.2.0-7ubuntu1) ... 356s Selecting previously unselected package libstdc++-13-dev:s390x. 356s Preparing to unpack .../31-libstdc++-13-dev_13.2.0-17ubuntu2_s390x.deb ... 356s Unpacking libstdc++-13-dev:s390x (13.2.0-17ubuntu2) ... 357s Selecting previously unselected package g++-13-s390x-linux-gnu. 357s Preparing to unpack .../32-g++-13-s390x-linux-gnu_13.2.0-17ubuntu2_s390x.deb ... 357s Unpacking g++-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 357s Selecting previously unselected package g++-13. 357s Preparing to unpack .../33-g++-13_13.2.0-17ubuntu2_s390x.deb ... 357s Unpacking g++-13 (13.2.0-17ubuntu2) ... 357s Selecting previously unselected package g++-s390x-linux-gnu. 357s Preparing to unpack .../34-g++-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 357s Unpacking g++-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 357s Selecting previously unselected package g++. 357s Preparing to unpack .../35-g++_4%3a13.2.0-7ubuntu1_s390x.deb ... 357s Unpacking g++ (4:13.2.0-7ubuntu1) ... 357s Selecting previously unselected package build-essential. 357s Preparing to unpack .../36-build-essential_12.10ubuntu1_s390x.deb ... 357s Unpacking build-essential (12.10ubuntu1) ... 357s Selecting previously unselected package libllvm17:s390x. 357s Preparing to unpack .../37-libllvm17_1%3a17.0.6-5build1_s390x.deb ... 357s Unpacking libllvm17:s390x (1:17.0.6-5build1) ... 359s Selecting previously unselected package libclang-cpp17. 359s Preparing to unpack .../38-libclang-cpp17_1%3a17.0.6-5build1_s390x.deb ... 359s Unpacking libclang-cpp17 (1:17.0.6-5build1) ... 360s Selecting previously unselected package libgc1:s390x. 360s Preparing to unpack .../39-libgc1_1%3a8.2.6-1_s390x.deb ... 360s Unpacking libgc1:s390x (1:8.2.6-1) ... 360s Selecting previously unselected package libobjc4:s390x. 360s Preparing to unpack .../40-libobjc4_14-20240303-1ubuntu1_s390x.deb ... 360s Unpacking libobjc4:s390x (14-20240303-1ubuntu1) ... 360s Selecting previously unselected package libobjc-13-dev:s390x. 360s Preparing to unpack .../41-libobjc-13-dev_13.2.0-17ubuntu2_s390x.deb ... 360s Unpacking libobjc-13-dev:s390x (13.2.0-17ubuntu2) ... 360s Selecting previously unselected package libclang-common-17-dev. 360s Preparing to unpack .../42-libclang-common-17-dev_1%3a17.0.6-5build1_all.deb ... 360s Unpacking libclang-common-17-dev (1:17.0.6-5build1) ... 361s Selecting previously unselected package llvm-17-linker-tools. 361s Preparing to unpack .../43-llvm-17-linker-tools_1%3a17.0.6-5build1_s390x.deb ... 361s Unpacking llvm-17-linker-tools (1:17.0.6-5build1) ... 361s Selecting previously unselected package libclang1-17. 361s Preparing to unpack .../44-libclang1-17_1%3a17.0.6-5build1_s390x.deb ... 361s Unpacking libclang1-17 (1:17.0.6-5build1) ... 361s Selecting previously unselected package clang-17. 361s Preparing to unpack .../45-clang-17_1%3a17.0.6-5build1_s390x.deb ... 361s Unpacking clang-17 (1:17.0.6-5build1) ... 361s Selecting previously unselected package libdebhelper-perl. 361s Preparing to unpack .../46-libdebhelper-perl_13.14.1ubuntu1_all.deb ... 361s Unpacking libdebhelper-perl (13.14.1ubuntu1) ... 361s Selecting previously unselected package libtool. 361s Preparing to unpack .../47-libtool_2.4.7-7_all.deb ... 361s Unpacking libtool (2.4.7-7) ... 361s Selecting previously unselected package dh-autoreconf. 361s Preparing to unpack .../48-dh-autoreconf_20_all.deb ... 361s Unpacking dh-autoreconf (20) ... 361s Selecting previously unselected package libarchive-zip-perl. 361s Preparing to unpack .../49-libarchive-zip-perl_1.68-1_all.deb ... 361s Unpacking libarchive-zip-perl (1.68-1) ... 362s Selecting previously unselected package libsub-override-perl. 362s Preparing to unpack .../50-libsub-override-perl_0.10-1_all.deb ... 362s Unpacking libsub-override-perl (0.10-1) ... 362s Selecting previously unselected package libfile-stripnondeterminism-perl. 362s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 362s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 362s Selecting previously unselected package dh-strip-nondeterminism. 362s Preparing to unpack .../52-dh-strip-nondeterminism_1.13.1-1_all.deb ... 362s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 362s Selecting previously unselected package libdw1:s390x. 362s Preparing to unpack .../53-libdw1_0.190-1_s390x.deb ... 362s Unpacking libdw1:s390x (0.190-1) ... 362s Selecting previously unselected package debugedit. 362s Preparing to unpack .../54-debugedit_1%3a5.0-5_s390x.deb ... 362s Unpacking debugedit (1:5.0-5) ... 362s Selecting previously unselected package dwz. 362s Preparing to unpack .../55-dwz_0.15-1_s390x.deb ... 362s Unpacking dwz (0.15-1) ... 362s Selecting previously unselected package gettext. 362s Preparing to unpack .../56-gettext_0.21-14ubuntu1_s390x.deb ... 362s Unpacking gettext (0.21-14ubuntu1) ... 362s Selecting previously unselected package intltool-debian. 362s Preparing to unpack .../57-intltool-debian_0.35.0+20060710.6_all.deb ... 362s Unpacking intltool-debian (0.35.0+20060710.6) ... 362s Selecting previously unselected package po-debconf. 362s Preparing to unpack .../58-po-debconf_1.0.21+nmu1_all.deb ... 362s Unpacking po-debconf (1.0.21+nmu1) ... 362s Selecting previously unselected package debhelper. 362s Preparing to unpack .../59-debhelper_13.14.1ubuntu1_all.deb ... 362s Unpacking debhelper (13.14.1ubuntu1) ... 362s Selecting previously unselected package emacsen-common. 362s Preparing to unpack .../60-emacsen-common_3.0.5_all.deb ... 362s Unpacking emacsen-common (3.0.5) ... 362s Selecting previously unselected package dictionaries-common. 362s Preparing to unpack .../61-dictionaries-common_1.29.7_all.deb ... 362s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 362s Unpacking dictionaries-common (1.29.7) ... 362s Selecting previously unselected package libfakeroot:s390x. 362s Preparing to unpack .../62-libfakeroot_1.33-1_s390x.deb ... 362s Unpacking libfakeroot:s390x (1.33-1) ... 362s Selecting previously unselected package fakeroot. 362s Preparing to unpack .../63-fakeroot_1.33-1_s390x.deb ... 362s Unpacking fakeroot (1.33-1) ... 362s Selecting previously unselected package hunspell-en-us. 362s Preparing to unpack .../64-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 362s Unpacking hunspell-en-us (1:2020.12.07-2) ... 362s Selecting previously unselected package icu-devtools. 362s Preparing to unpack .../65-icu-devtools_74.2-1ubuntu1_s390x.deb ... 362s Unpacking icu-devtools (74.2-1ubuntu1) ... 362s Selecting previously unselected package libpgtypes3:s390x. 362s Preparing to unpack .../66-libpgtypes3_16.2-1_s390x.deb ... 362s Unpacking libpgtypes3:s390x (16.2-1) ... 362s Selecting previously unselected package libpq5:s390x. 362s Preparing to unpack .../67-libpq5_16.2-1_s390x.deb ... 362s Unpacking libpq5:s390x (16.2-1) ... 362s Selecting previously unselected package libecpg6:s390x. 362s Preparing to unpack .../68-libecpg6_16.2-1_s390x.deb ... 362s Unpacking libecpg6:s390x (16.2-1) ... 362s Selecting previously unselected package libecpg-compat3:s390x. 362s Preparing to unpack .../69-libecpg-compat3_16.2-1_s390x.deb ... 362s Unpacking libecpg-compat3:s390x (16.2-1) ... 362s Selecting previously unselected package libssl-dev:s390x. 362s Preparing to unpack .../70-libssl-dev_3.0.10-1ubuntu4_s390x.deb ... 362s Unpacking libssl-dev:s390x (3.0.10-1ubuntu4) ... 362s Selecting previously unselected package libpq-dev. 363s Preparing to unpack .../71-libpq-dev_16.2-1_s390x.deb ... 363s Unpacking libpq-dev (16.2-1) ... 363s Selecting previously unselected package libecpg-dev. 363s Preparing to unpack .../72-libecpg-dev_16.2-1_s390x.deb ... 363s Unpacking libecpg-dev (16.2-1) ... 363s Selecting previously unselected package libicu-dev:s390x. 363s Preparing to unpack .../73-libicu-dev_74.2-1ubuntu1_s390x.deb ... 363s Unpacking libicu-dev:s390x (74.2-1ubuntu1) ... 363s Selecting previously unselected package libncurses-dev:s390x. 363s Preparing to unpack .../74-libncurses-dev_6.4+20240113-1ubuntu1_s390x.deb ... 363s Unpacking libncurses-dev:s390x (6.4+20240113-1ubuntu1) ... 363s Selecting previously unselected package libpython3.12:s390x. 363s Preparing to unpack .../75-libpython3.12_3.12.2-1_s390x.deb ... 363s Unpacking libpython3.12:s390x (3.12.2-1) ... 363s Selecting previously unselected package libtcl8.6:s390x. 363s Preparing to unpack .../76-libtcl8.6_8.6.13+dfsg-2_s390x.deb ... 363s Unpacking libtcl8.6:s390x (8.6.13+dfsg-2) ... 363s Selecting previously unselected package libxml2-dev:s390x. 363s Preparing to unpack .../77-libxml2-dev_2.9.14+dfsg-1.3ubuntu1_s390x.deb ... 363s Unpacking libxml2-dev:s390x (2.9.14+dfsg-1.3ubuntu1) ... 363s Selecting previously unselected package libxslt1.1:s390x. 363s Preparing to unpack .../78-libxslt1.1_1.1.39-0exp1_s390x.deb ... 363s Unpacking libxslt1.1:s390x (1.1.39-0exp1) ... 363s Selecting previously unselected package llvm-17-runtime. 363s Preparing to unpack .../79-llvm-17-runtime_1%3a17.0.6-5build1_s390x.deb ... 363s Unpacking llvm-17-runtime (1:17.0.6-5build1) ... 364s Selecting previously unselected package libpfm4:s390x. 364s Preparing to unpack .../80-libpfm4_4.13.0+git32-g0d4ed0e-1_s390x.deb ... 364s Unpacking libpfm4:s390x (4.13.0+git32-g0d4ed0e-1) ... 364s Selecting previously unselected package llvm-17. 364s Preparing to unpack .../81-llvm-17_1%3a17.0.6-5build1_s390x.deb ... 364s Unpacking llvm-17 (1:17.0.6-5build1) ... 365s Selecting previously unselected package libffi-dev:s390x. 365s Preparing to unpack .../82-libffi-dev_3.4.6-1_s390x.deb ... 365s Unpacking libffi-dev:s390x (3.4.6-1) ... 365s Selecting previously unselected package llvm-17-tools. 365s Preparing to unpack .../83-llvm-17-tools_1%3a17.0.6-5build1_s390x.deb ... 365s Unpacking llvm-17-tools (1:17.0.6-5build1) ... 365s Selecting previously unselected package libz3-4:s390x. 365s Preparing to unpack .../84-libz3-4_4.8.12-3.1_s390x.deb ... 365s Unpacking libz3-4:s390x (4.8.12-3.1) ... 366s Selecting previously unselected package libz3-dev:s390x. 366s Preparing to unpack .../85-libz3-dev_4.8.12-3.1_s390x.deb ... 366s Unpacking libz3-dev:s390x (4.8.12-3.1) ... 366s Selecting previously unselected package llvm-17-dev. 366s Preparing to unpack .../86-llvm-17-dev_1%3a17.0.6-5build1_s390x.deb ... 366s Unpacking llvm-17-dev (1:17.0.6-5build1) ... 370s Selecting previously unselected package locales-all. 370s Preparing to unpack .../87-locales-all_2.39-0ubuntu6_s390x.deb ... 370s Unpacking locales-all (2.39-0ubuntu6) ... 376s Selecting previously unselected package postgresql-client-16. 376s Preparing to unpack .../88-postgresql-client-16_16.2-1_s390x.deb ... 376s Unpacking postgresql-client-16 (16.2-1) ... 376s Selecting previously unselected package postgresql-16. 376s Preparing to unpack .../89-postgresql-16_16.2-1_s390x.deb ... 376s Unpacking postgresql-16 (16.2-1) ... 377s Selecting previously unselected package postgresql-server-dev-16. 377s Preparing to unpack .../90-postgresql-server-dev-16_16.2-1_s390x.deb ... 377s Unpacking postgresql-server-dev-16 (16.2-1) ... 377s Selecting previously unselected package postgresql-server-dev-all:s390x. 377s Preparing to unpack .../91-postgresql-server-dev-all_257_s390x.deb ... 377s Unpacking postgresql-server-dev-all:s390x (257) ... 377s Selecting previously unselected package postgresql-plperl-16. 377s Preparing to unpack .../92-postgresql-plperl-16_16.2-1_s390x.deb ... 377s Unpacking postgresql-plperl-16 (16.2-1) ... 377s Selecting previously unselected package postgresql-plpython3-16. 377s Preparing to unpack .../93-postgresql-plpython3-16_16.2-1_s390x.deb ... 377s Unpacking postgresql-plpython3-16 (16.2-1) ... 377s Selecting previously unselected package postgresql-pltcl-16. 377s Preparing to unpack .../94-postgresql-pltcl-16_16.2-1_s390x.deb ... 377s Unpacking postgresql-pltcl-16 (16.2-1) ... 377s Selecting previously unselected package postgresql-all. 377s Preparing to unpack .../95-postgresql-all_257_all.deb ... 377s Unpacking postgresql-all (257) ... 377s Selecting previously unselected package postgresql-doc-16. 377s Preparing to unpack .../96-postgresql-doc-16_16.2-1_all.deb ... 377s Unpacking postgresql-doc-16 (16.2-1) ... 378s Selecting previously unselected package postgresql-doc. 378s Preparing to unpack .../97-postgresql-doc_16+257_all.deb ... 378s Unpacking postgresql-doc (16+257) ... 378s Selecting previously unselected package autopkgtest-satdep. 378s Preparing to unpack .../98-2-autopkgtest-satdep.deb ... 378s Unpacking autopkgtest-satdep (0) ... 378s Setting up postgresql-client-common (257) ... 378s Setting up libpgtypes3:s390x (16.2-1) ... 378s Setting up libdw1:s390x (0.190-1) ... 378s Setting up postgresql-doc-16 (16.2-1) ... 378s 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 378s Setting up libarchive-zip-perl (1.68-1) ... 378s Setting up libdebhelper-perl (13.14.1ubuntu1) ... 378s Setting up libpq5:s390x (16.2-1) ... 378s Setting up linux-libc-dev:s390x (6.8.0-11.11) ... 378s Setting up m4 (1.4.19-4) ... 378s Setting up libgomp1:s390x (14-20240303-1ubuntu1) ... 378s Setting up libffi-dev:s390x (3.4.6-1) ... 378s Setting up locales-all (2.39-0ubuntu6) ... 378s Setting up libfakeroot:s390x (1.33-1) ... 378s Setting up fakeroot (1.33-1) ... 378s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 378s Setting up autotools-dev (20220109.1) ... 378s Setting up libz3-4:s390x (4.8.12-3.1) ... 378s Setting up libpfm4:s390x (4.13.0+git32-g0d4ed0e-1) ... 378s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 378s Setting up emacsen-common (3.0.5) ... 378s Setting up ssl-cert (1.1.2ubuntu1) ... 380s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 380s Setting up libssl-dev:s390x (3.0.10-1ubuntu4) ... 380s Setting up libmpc3:s390x (1.3.1-1) ... 380s Setting up libatomic1:s390x (14-20240303-1ubuntu1) ... 381s Setting up libtcl8.6:s390x (8.6.13+dfsg-2) ... 381s Setting up autopoint (0.21-14ubuntu1) ... 381s Setting up icu-devtools (74.2-1ubuntu1) ... 381s Setting up libgc1:s390x (1:8.2.6-1) ... 381s Setting up autoconf (2.71-3) ... 381s Setting up libubsan1:s390x (14-20240303-1ubuntu1) ... 381s Setting up llvm-17-tools (1:17.0.6-5build1) ... 381s Setting up dwz (0.15-1) ... 381s Setting up libclang-common-17-dev (1:17.0.6-5build1) ... 381s Setting up libcrypt-dev:s390x (1:4.4.36-4) ... 381s Setting up libasan8:s390x (14-20240303-1ubuntu1) ... 381s Setting up libjson-perl (4.10000-1) ... 381s Setting up postgresql-doc (16+257) ... 381s Setting up libxslt1.1:s390x (1.1.39-0exp1) ... 381s Setting up debugedit (1:5.0-5) ... 381s Setting up libecpg6:s390x (16.2-1) ... 381s Setting up libsub-override-perl (0.10-1) ... 381s Setting up libisl23:s390x (0.26-3) ... 381s Setting up libc-dev-bin (2.39-0ubuntu6) ... 381s Setting up libllvm17:s390x (1:17.0.6-5build1) ... 381s Setting up libpython3.12:s390x (3.12.2-1) ... 381s Setting up libcc1-0:s390x (14-20240303-1ubuntu1) ... 381s Setting up libitm1:s390x (14-20240303-1ubuntu1) ... 381s Setting up automake (1:1.16.5-1.3ubuntu1) ... 381s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 381s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 381s Setting up libz3-dev:s390x (4.8.12-3.1) ... 381s Setting up gettext (0.21-14ubuntu1) ... 381s Setting up llvm-17-linker-tools (1:17.0.6-5build1) ... 381s Setting up libecpg-compat3:s390x (16.2-1) ... 381s Setting up dictionaries-common (1.29.7) ... 381s Setting up libclang1-17 (1:17.0.6-5build1) ... 381s Setting up postgresql-client-16 (16.2-1) ... 382s 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 382s Setting up libpq-dev (16.2-1) ... 382s Setting up libobjc4:s390x (14-20240303-1ubuntu1) ... 382s Setting up libecpg-dev (16.2-1) ... 382s Setting up intltool-debian (0.35.0+20060710.6) ... 382s Setting up cpp-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 382s Setting up postgresql-common (257) ... 383s 383s Creating config file /etc/postgresql-common/createcluster.conf with new version 383s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 383s en_us 383s Removing obsolete dictionary files: 384s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 385s Setting up dh-strip-nondeterminism (1.13.1-1) ... 385s Setting up libgcc-13-dev:s390x (13.2.0-17ubuntu2) ... 385s Setting up llvm-17-runtime (1:17.0.6-5build1) ... 385s Setting up hunspell-en-us (1:2020.12.07-2) ... 385s Setting up libc6-dev:s390x (2.39-0ubuntu6) ... 385s Setting up libclang-cpp17 (1:17.0.6-5build1) ... 385s Setting up llvm-17 (1:17.0.6-5build1) ... 385s Setting up libicu-dev:s390x (74.2-1ubuntu1) ... 385s Setting up libobjc-13-dev:s390x (13.2.0-17ubuntu2) ... 385s Setting up libstdc++-13-dev:s390x (13.2.0-17ubuntu2) ... 385s Setting up libncurses-dev:s390x (6.4+20240113-1ubuntu1) ... 385s Setting up postgresql-16 (16.2-1) ... 385s Creating new PostgreSQL cluster 16/main ... 386s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 386s The files belonging to this database system will be owned by user "postgres". 386s This user must also own the server process. 386s 386s The database cluster will be initialized with locale "C.UTF-8". 386s The default database encoding has accordingly been set to "UTF8". 386s The default text search configuration will be set to "english". 386s 386s Data page checksums are disabled. 386s 386s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 386s creating subdirectories ... ok 386s selecting dynamic shared memory implementation ... posix 386s selecting default max_connections ... 100 386s selecting default shared_buffers ... 128MB 386s selecting default time zone ... Etc/UTC 386s creating configuration files ... ok 386s running bootstrap script ... ok 387s performing post-bootstrap initialization ... ok 387s syncing data to disk ... ok 391s Setting up cpp-13 (13.2.0-17ubuntu2) ... 391s Setting up cpp-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 391s Setting up po-debconf (1.0.21+nmu1) ... 391s Setting up clang-17 (1:17.0.6-5build1) ... 391s Setting up libxml2-dev:s390x (2.9.14+dfsg-1.3ubuntu1) ... 391s Setting up gcc-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 391s Setting up gcc-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 391s Setting up g++-13-s390x-linux-gnu (13.2.0-17ubuntu2) ... 391s Setting up gcc-13 (13.2.0-17ubuntu2) ... 391s Setting up postgresql-plpython3-16 (16.2-1) ... 391s Setting up cpp (4:13.2.0-7ubuntu1) ... 391s Setting up postgresql-plperl-16 (16.2-1) ... 392s Setting up llvm-17-dev (1:17.0.6-5build1) ... 392s Setting up g++-13 (13.2.0-17ubuntu2) ... 392s Setting up postgresql-pltcl-16 (16.2-1) ... 392s Setting up libtool (2.4.7-7) ... 392s Setting up g++-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 392s Setting up gcc (4:13.2.0-7ubuntu1) ... 392s Setting up dh-autoreconf (20) ... 392s Setting up postgresql-server-dev-16 (16.2-1) ... 392s Setting up g++ (4:13.2.0-7ubuntu1) ... 392s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 392s Setting up build-essential (12.10ubuntu1) ... 392s Setting up postgresql-server-dev-all:s390x (257) ... 392s Setting up debhelper (13.14.1ubuntu1) ... 392s Setting up postgresql-all (257) ... 392s Setting up autopkgtest-satdep (0) ... 392s Processing triggers for systemd (255.2-3ubuntu2) ... 392s Processing triggers for man-db (2.12.0-3) ... 394s Processing triggers for install-info (7.1-3) ... 394s Processing triggers for libc-bin (2.39-0ubuntu6) ... 394s Processing triggers for dictionaries-common (1.29.7) ... 398s (Reading database ... 71419 files and directories currently installed.) 398s Removing autopkgtest-satdep (0) ... 401s autopkgtest [20:02:40]: test run-testsuite: [----------------------- 401s ====== Running all tests with umask 077 ======= 401s ### PostgreSQL test 001_packages.t ### 402s 1..22 402s ok 1 - /etc/os-release exists 402s ok 2 - OS is ubuntu 402s ok 3 - OS version is 24.04 402s # PostgreSQL versions installed: 16 402s ok 4 - postgresql-16 installed 402s ok 5 # skip No python2 support 402s ok 6 - postgresql-plpython3-16 installed 402s ok 7 - postgresql-plperl-16 installed 402s ok 8 - postgresql-pltcl-16 installed 402s ok 9 - postgresql-server-dev-16 installed 402s ok 10 # skip No postgresql-contrib-16 package for version 16 402s # postgresql-doc-16 installed 402s ok 11 - At least one doc package installed 402s ok 12 - libecpg-dev installed 402s ok 13 - procps installed 402s ok 14 - netcat-openbsd installed 402s ok 15 - hunspell-en-us installed 402s ok 16 - system has a default UTF-8 locale 402s ok 17 - locale ru_RU exists 402s ok 18 - locale ru_RU.UTF-8 exists 402s ok 19 - user postgres in the UNIX group ssl-cert 402s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 402s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 402s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 402s ### End test 001_packages.t ### 402s 402s ### PostgreSQL test 002_existing_clusters.t ### 402s 1..8 402s # Cleanup 402s ok 1 - Cleanup: No clusters left behind 402s ok 2 - No postgres processes left behind 402s ok 3 - No files in /etc/postgresql left behind 402s ok 4 - No files in /var/lib/postgresql left behind 402s ok 5 - No files in /var/run/postgresql left behind 402s ok 6 - No files in /var/log/postgresql left behind 402s ok 7 - PostgreSQL TCP ports are closed 402s ok 8 - Next free port is 5432 402s ### End test 002_existing_clusters.t ### 402s 402s ### PostgreSQL test 003_alternatives.t ### 402s 1..9 402s # Newest PG version installed is 16 402s ok 1 - psql.1.gz link group 402s ok 2 - postmaster.1.gz link group does not exist 402s ok 3 - psql.1.gz alternative 402s ok 4 - pg_dump.1.gz alternative 402s ok 5 - postgres.1.gz alternative 402s ok 6 - pg_ctl.1.gz alternative 402s # Newest PG doc version installed is 16 402s ok 7 - SPI_connect.3.gz link group 402s ok 8 - SPI_connect.3.gz alternative 402s ok 9 - SPI_exec.3.gz alternative 402s ### End test 003_alternatives.t ### 402s 402s ### PostgreSQL test 005_PgCommon.t ### 402s 1..24 402s ok 1 - correctly parsed line 'local all postgres ident sameuser' 402s ok 2 - correctly parsed line 'local foo nobody trust' 402s ok 3 - correctly parsed line 'local foo nobody crypt' 402s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 402s ok 5 - correctly parsed line 'local foo,bar nobody ident' 402s ok 6 - correctly parsed line 'local all +foogrp password' 402s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 402s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 402s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 402s ok 10 - @expected_records has correct number of entries 402s ok 11 - returned read_pg_hba array has correct number of records 402s ok 12 - line 'foo all all md5' parsed as invalid 402s ok 13 - line 'local all all foo' parsed as invalid 402s ok 14 - line 'host all all foo' parsed as invalid 402s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 402s ok 16 - line 'host all all md5' parsed as invalid 402s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 402s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 402s ok 19 - read_conf_file returns empty dict for nonexisting file 402s ok 20 - read_conf_file() parsing 402s ok 21 - read_conf_file() parsing with include directives 402s ok 22 - set_conf_value 402s ok 23 - disable_conf_value 402s ok 24 - replace_conf_value 402s ### End test 005_PgCommon.t ### 402s 402s ### PostgreSQL test 006_next_free_port.t ### 402s 1..5 402s ok 1 - next_free_port is 5432 403s ok 2 - next_free_port detects localhost ipv4 socket 404s ok 3 - next_free_port detects wildcard ipv4 socket 405s ok 4 - next_free_port detects localhost ipv6 socket 406s ok 5 - next_free_port detects wildcard ipv6 socket 406s ### End test 006_next_free_port.t ### 406s 406s ### PostgreSQL test 007_pg_conftool.t ### 406s 1..41 407s # test without cluster 407s ok 1 - pg_conftool show all 407s ok 2 - correct output of pg_conftool show all 407s ok 3 - pg_conftool foo.conf show all 407s ok 4 - correct output of pg_conftool foo.conf show all 407s ok 5 - pg_conftool /tmp/5P0ijdF7FR/different.conf show all 407s ok 6 - correct output of pg_conftool /tmp/5P0ijdF7FR/different.conf show all 407s ok 7 - pg_conftool 9.7 main show all 407s ok 8 - correct output of pg_conftool 9.7 main show all 407s # test show 407s ok 9 - pg_conftool show all 407s ok 10 - correct output of pg_conftool show all 407s ok 11 - pg_conftool other.conf show all 407s ok 12 - correct output of pg_conftool other.conf show all 407s ok 13 - pg_conftool /tmp/5P0ijdF7FR/different.conf show all 407s ok 14 - correct output of pg_conftool /tmp/5P0ijdF7FR/different.conf show all 407s ok 15 - pg_conftool 16 main show all 407s ok 16 - correct output of pg_conftool 16 main show all 407s ok 17 - pg_conftool 16 main other.conf show all 407s ok 18 - correct output of pg_conftool 16 main other.conf show all 407s ok 19 - pg_conftool show a 407s ok 20 - correct output of pg_conftool show a 407s ok 21 - pg_conftool -s show a 407s ok 22 - correct output of pg_conftool -s show a 407s # test set 407s ok 23 - pg_conftool set c 7 407s ok 24 - correct output of pg_conftool set c 7 407s ok 25 - file contains new setting 407s ok 26 - pg_conftool set a 8 407s ok 27 - correct output of pg_conftool set a 8 407s ok 28 - file contains updated setting 407s ok 29 - pg_conftool /tmp/5P0ijdF7FR/different.conf set a 9 407s ok 30 - correct output of pg_conftool /tmp/5P0ijdF7FR/different.conf set a 9 407s ok 31 - file with path contains updated setting 407s # test remove 407s ok 32 - pg_conftool remove a 407s ok 33 - correct output of pg_conftool remove a 407s ok 34 - setting removed from file 407s ok 35 - pg_conftool /tmp/5P0ijdF7FR/different.conf remove a 407s ok 36 - correct output of pg_conftool /tmp/5P0ijdF7FR/different.conf remove a 407s ok 37 - setting removed from file with path 407s # test edit 407s ok 38 - pg_conftool edit 407s ok 39 - correct output of pg_conftool edit 407s ok 40 - pg_conftool /tmp/5P0ijdF7FR/different.conf edit 407s ok 41 - correct output of pg_conftool /tmp/5P0ijdF7FR/different.conf edit 407s ### End test 007_pg_conftool.t ### 407s 407s ### PostgreSQL test 010_defaultport_cluster.t ### 408s 1..14 408s ok 1 - psql --version 408s ok 2 - pg_wrapper selects highest available version number 408s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 408s ok 4 - connecting to localhost fails with no clusters 408s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 408s ok 6 - pg_wrapper uses host and port from PGCLUSTER 408s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 408s ok 8 - pg_wrapper uses --cluster from the command line 408s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 408s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 408s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 408s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 408s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 408s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 408s ### End test 010_defaultport_cluster.t ### 408s 408s ### PostgreSQL test 015_start_stop.t ### 408s 1..71 408s # We are running systemd 408s # Running tests for 16 408s # Cluster does not exist yet 408s ok 1 - cluster 16 main does not exist 408s ok 2 - service postgresql@16-main does not exist 408s ok 3 - systemctl start postgresql 408s ok 4 - cluster 16 main does not exist 408s ok 5 - service postgresql@16-main does not exist 408s ok 6 - systemctl start postgresql@16-main 408s ok 7 - cluster 16 main does not exist 409s ok 8 - service postgresql@16-main does not exist 409s # Start/stop postgresql using system tools 410s ok 9 - pg_createcluster 16 main 410s ok 10 - cluster 16 main is stopped 410s ok 11 - service postgresql@16-main is stopped 413s ok 12 - systemctl start postgresql 413s ok 13 - cluster 16 main is running 413s ok 14 - service postgresql@16-main is running 413s ok 15 - systemctl start postgresql 413s ok 16 - cluster 16 main is already running 413s ok 17 - service postgresql@16-main is already running 413s ok 18 - systemctl stop postgresql 419s ok 19 - cluster 16 main is stopped 419s ok 20 - service postgresql@16-main is stopped 419s ok 21 - systemctl stop postgresql 419s ok 22 - cluster 16 main is already stopped 419s ok 23 - service postgresql@16-main is already stopped 419s # Start/stop specific cluster using system tools 421s ok 24 - systemctl start postgresql@16-main 422s ok 25 - cluster 16 main is running 422s ok 26 - service postgresql@16-main is running 422s ok 27 - systemctl start postgresql@16-main 422s ok 28 - cluster 16 main is running 422s ok 29 - service postgresql@16-main is running 424s ok 30 - systemctl restart postgresql@16-main 424s ok 31 - cluster 16 main is running 424s ok 32 - service postgresql@16-main is running 425s ok 33 - systemctl stop postgresql@16-main 425s ok 34 - cluster 16 main is stopped 425s ok 35 - service postgresql@16-main is stopped 425s ok 36 - systemctl stop postgresql@16-main 425s ok 37 - cluster 16 main is already stopped 425s ok 38 - service postgresql@16-main is already stopped 427s ok 39 - pg_dropcluster 16 main 428s ok 40 - cluster 16 main does not exist 428s ok 41 - service postgresql@16-main does not exist 428s # Start/stop specific cluster using pg_*cluster 428s ok 42 - pg_ctlcluster start 16 main 428s ok 43 - cluster 16 main does not exist 428s ok 44 - service postgresql@16-main does not exist 432s ok 45 - pg_createcluster 16 main --start 432s ok 46 - cluster 16 main is running 432s ok 47 - service postgresql@16-main is running 432s ok 48 - pg_ctlcluster 16 main start 432s ok 49 - cluster 16 main is already running 432s ok 50 - service postgresql@16-main is already running 435s ok 51 - pg_ctlcluster 16-main restart 435s ok 52 - cluster 16 main is running 435s ok 53 - service postgresql@16-main is running 436s ok 54 - pg_ctlcluster 16 main stop 436s ok 55 - cluster 16 main is stopped 436s ok 56 - service postgresql@16-main is stopped 436s ok 57 - pg_ctlcluster 16 main stop 436s ok 58 - cluster 16 main is already stopped 436s ok 59 - service postgresql@16-main is already stopped 438s ok 60 - pg_ctlcluster start 16-main 438s ok 61 - cluster 16 main is running 438s ok 62 - service postgresql@16-main is running 441s ok 63 - pg_dropcluster 16 main --stop 441s # Cleanup 441s ok 64 - Cleanup: No clusters left behind 441s ok 65 - No postgres processes left behind 441s ok 66 - No files in /etc/postgresql left behind 441s ok 67 - No files in /var/lib/postgresql left behind 441s ok 68 - No files in /var/run/postgresql left behind 441s ok 69 - No files in /var/log/postgresql left behind 441s ok 70 - PostgreSQL TCP ports are closed 441s ok 71 - Next free port is 5432 442s ### End test 015_start_stop.t ### 442s 442s ### PostgreSQL test 020_create_sql_remove.t ### 442s 1..147 442s # Running tests for 16 446s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.ejwwCf 446s ok 2 - pg_createcluster 16 main 446s ok 3 - Socket and pid file are in /var/run/postgresql/ 446s ok 4 - xlog/wal directory /tmp/16.xlog.ejwwCf was created 446s ok 5 - local method in pg_hba.conf is peer 446s ok 6 - host method in pg_hba.conf is scram-sha-256 446s ok 7 - Exactly one postgres master process running 448s ok 8 - pg_ctlcluster 16 main restart 448s ok 9 - cluster restarts with new environment file 448s ok 10 - Exactly one postgres master process running 448s ok 11 - correct value of PGEXTRAVAR1 in environment 448s ok 12 - correct value of PGEXTRAVAR2 in environment 448s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 448s ok 14 - createdb --version 448s ok 15 - pg_wrapper+createdb selects version number of cluster 448s ok 16 - psql --version 448s ok 17 - pg_wrapper+psql selects version 16 449s ok 18 - pg_lscluster reports online cluster on port 5432 449s ok 19 - log file is actually used 449s ok 20 - /etc/postgresql is owned by user "postgres" 449s ok 21 - version configuration directory file is owned by user "postgres" 449s ok 22 - configuration directory file is owned by user "postgres" 449s ok 23 - version data directory file is owned by user "postgres" 449s ok 24 - data directory file is owned by user "postgres" 449s ok 25 - log file has 0640 permissions 449s ok 26 - log file is owned by user "postgres" 449s ok 27 - log file is owned by group "adm" 449s ok 28 - no log symlink by default 449s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 449s ok 30 - pg_lsclusters -h 449s ok 31 - correct output of pg_lsclusters -h 449s ok 32 - stopping cluster 452s ok 33 - restarting cluster with nondefault log symlink 452s ok 34 - log target is used as log file 452s ok 35 - default log is not used 452s ok 36 - pg_lsclusters -h 452s ok 37 - correct output of pg_lsclusters -h 452s ok 38 - stopping cluster 455s ok 39 - restarting cluster with explicitly configured log file 455s ok 40 - default log is not used 455s ok 41 - log symlink target is used for startup message 455s ok 42 - exactly one log file 455s ok 43 - custom log is actually used 455s ok 44 - pg_lsclusters -h 455s ok 45 - correct output of pg_lsclusters -h 455s ok 46 - stopping cluster 455s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 455s ok 48 - /etc/postgres-hack was not created 457s ok 49 - restarting cluster 457s ok 50 - ps -o tty -U postgres h 457s ok 51 - postgres processes do not have an associated terminal 457s ok 52 - Server is linked with SSL support 457s ok 53 - SSL is enabled in postgresql.conf 458s ok 54 - psql -l fails for nobody 458s ok 55 - createuser nobody 458s ok 56 - createdb nobodydb 458s ok 57 - psql -ltA succeeds for nobody 458s ok 58 - psql -ltA output 458s ok 59 - SQL command: create table 458s ok 60 - SQL command: insert into table values 458s ok 61 - SQL command: insert into table values 458s ok 62 - primary key violation 458s ok 63 - psql -tAc "select * from phone order by name" nobodydb 458s ok 64 - SQL command output: select -tA 458s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 458s ok 66 - SQL command output: select -tx 458s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 458s ok 68 - SQL command output: select -tAx 458s ok 69 - CREATE EXTENSION plperlu fails for user nobody 459s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 459s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 459s ok 72 - creating PL/PerlU function as user nobody fails 459s ok 73 - creating unsafe PL/Perl function as user postgres fails 459s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 459s ok 75 - creating PL/PerlU function as user postgres succeeds 459s ok 76 - psql nobodydb -Atc "select read_file()" 459s ok 77 - calling PL/PerlU function 459s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 459s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 459s ok 80 - creating unsafe PL/Perl function as user nobody fails 459s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 459s ok 82 - creating PL/Perl function as user nobody succeeds 459s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 459s ok 84 - calling PL/Perl function 459s ok 85 # skip No python2 support 459s ok 86 # skip No python2 support 459s ok 87 # skip No python2 support 459s ok 88 # skip No python2 support 459s ok 89 # skip No python2 support 459s ok 90 # skip No python2 support 459s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 459s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 460s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 460s ok 94 - creating PL/Python3 function as user postgres succeeds 460s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 460s ok 96 - calling PL/Python function 460s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 460s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 460s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 460s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 460s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 460s ok 102 - creating PL/Tcl function as user nobody succeeds 460s 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;" 460s ok 104 - creating PL/TclU function as user postgres succeeds 460s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 460s ok 106 - calling PL/Tcl function 460s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 460s ok 108 - calling PL/TclU function 460s ok 109 - stopping cluster 460s ok 110 - pg_ctlcluster 16 main start 460s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 463s ok 112 - pg_ctlcluster 16 main start 463s ok 113 - cluster restarts with pgdata symlink 463s ok 114 - postgres master has OOM killer protection 463s ok 115 - postgres client backend has no OOM adjustment 463s ok 116 - ps h 5825 463s ok 117 - process title is idle 464s ok 118 - ps h 5825 464s ok 119 - process title is idle in transaction 464s ok 120 - stopping cluster 466s ok 121 - starting cluster as postgres works without a log file 466s ok 122 - log file got recreated and used 466s ok 123 - creating a directory in spc2 466s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.jCjtNK'" 466s ok 125 - creating tablespace spc1 466s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 466s ok 127 - creating a table in spc1 467s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.WoO2fr'" 467s ok 129 - creating tablespace spc2 467s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 467s ok 131 - creating a table in spc2 467s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 467s ok 133 - Correct apt NeverAutoRemove config 470s ok 134 - pg_dropcluster removes cluster 470s ok 135 - xlog/wal directory /tmp/16.xlog.ejwwCf was deleted 470s ok 136 - tablespace spc1 was emptied 470s ok 137 - tablespace spc2 was emptied 470s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 470s ok 139 - Correct apt NeverAutoRemove config 470s # Cleanup 470s ok 140 - Cleanup: No clusters left behind 470s ok 141 - No postgres processes left behind 470s ok 142 - No files in /etc/postgresql left behind 470s ok 143 - No files in /var/lib/postgresql left behind 470s ok 144 - No files in /var/run/postgresql left behind 470s ok 145 - No files in /var/log/postgresql left behind 470s ok 146 - PostgreSQL TCP ports are closed 470s ok 147 - Next free port is 5432 470s ### End test 020_create_sql_remove.t ### 470s 470s ### PostgreSQL test 021_pg_renamecluster.t ### 470s 1..20 475s ok 1 - pg_createcluster 16 main 478s ok 2 - pg_renamecluster 16 main donau 478s ok 3 - psql -tAc "show data_directory" 478s ok 4 - cluster is running and data_directory was moved 478s ok 5 - pg_hba.conf location updated 478s ok 6 - pg_ident.conf location updated 478s ok 7 - external_pid_file location updated 478s ok 8 - external_pid_file exists 478s ok 9 # skip no stats_temp_directory in 16 478s ok 10 # skip no stats_temp_directory in 16 478s ok 11 - cluster_name is updated 481s ok 12 - pg_dropcluster removes cluster 481s # Cleanup 481s ok 13 - Cleanup: No clusters left behind 481s ok 14 - No postgres processes left behind 481s ok 15 - No files in /etc/postgresql left behind 481s ok 16 - No files in /var/lib/postgresql left behind 481s ok 17 - No files in /var/run/postgresql left behind 481s ok 18 - No files in /var/log/postgresql left behind 481s ok 19 - PostgreSQL TCP ports are closed 481s ok 20 - Next free port is 5432 481s ### End test 021_pg_renamecluster.t ### 481s 481s ### PostgreSQL test 022_recovery.t ### 481s 1..17 481s # Running tests for 16 485s ok 1 - pg_createcluster 16 main --start >/dev/null 486s ok 2 - pg_ctlcluster 16 main stop -m i 488s ok 3 - pg_ctlcluster 16 main start 488s ok 4 - psql -c '' 489s ok 5 - pg_ctlcluster 16 main stop -m i 489s ok 6 - create write-protected file in data directory 491s ok 7 - pg_ctlcluster 16 main start 491s ok 8 - psql -c '' 494s ok 9 - pg_dropcluster removes cluster 494s # Cleanup 494s ok 10 - Cleanup: No clusters left behind 494s ok 11 - No postgres processes left behind 494s ok 12 - No files in /etc/postgresql left behind 494s ok 13 - No files in /var/lib/postgresql left behind 494s ok 14 - No files in /var/run/postgresql left behind 494s ok 15 - No files in /var/log/postgresql left behind 494s ok 16 - PostgreSQL TCP ports are closed 494s ok 17 - Next free port is 5432 494s ### End test 022_recovery.t ### 494s 494s ### PostgreSQL test 025_logging.t ### 494s 1..55 494s # Logging to /var/log/syslog works 494s # Running tests for 16 498s ok 1 - pg_createcluster 16 main 498s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 498s ok 3 - psql -qc "'foobar_16_6958'" 498s ok 4 - log an error 499s ok 5 - grep --binary-files=text foobar_16_6958 /var/log/postgresql/postgresql-16-main.log 499s ok 6 - error appears in logfile 499s ok 7 - pg_conftool 16 main set log_destination syslog 499s ok 8 - set log_destination syslog 499s ok 9 - pg_ctlcluster 16 main reload 499s ok 10 - 16 main reload 499s ok 11 - psql -Atc "show log_destination" 499s ok 12 - log_destination is syslog 499s ok 13 - pg_lscluster reports syslog 500s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 500s ok 15 - error appears in /var/log/syslog 500s ok 16 - pg_conftool 16 main set logging_collector on 500s ok 17 - set logging_collector on 500s ok 18 - pg_conftool 16 main set log_destination csvlog 500s ok 19 - set log_destination csvlog 502s ok 20 - pg_ctlcluster 16 main restart 502s ok 21 - 16 main restart 502s ok 22 - psql -Atc "show logging_collector" 502s ok 23 - logging_collector is on 502s ok 24 - psql -Atc "show log_destination" 502s ok 25 - log_destination is csvlog 502s ok 26 - pg_lscluster reports csvlog 502s ok 27 - psql -qc "'barbaz_16_6958'" 502s ok 28 - log an error 503s ok 29 - grep --binary-files=text barbaz_16_6958 /var/lib/postgresql/16/main/log/*.csv 503s ok 30 - error appears in log/*.csv 503s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 503s ok 32 - set log_destination stderr,syslog,csvlog 503s ok 33 - pg_ctlcluster 16 main reload 503s ok 34 - 16 main reload 503s ok 35 - psql -Atc "show log_destination" 503s ok 36 - log_destination is stderr,syslog,csvlog 503s ok 37 - pg_lscluster reports stderr,syslog,csvlog 503s ok 38 - psql -qc "'moo_16_6958'" 503s ok 39 - log an error 504s ok 40 - grep --binary-files=text moo_16_6958 /var/lib/postgresql/16/main/log/*.log 504s ok 41 - error appears in log/*.log 504s ok 42 - grep --binary-files=text 'postgres.*moo_16_6958' /var/log/syslog 504s ok 43 - error appears in /var/log/syslog 504s ok 44 - grep --binary-files=text moo_16_6958 /var/lib/postgresql/16/main/log/*.csv 504s ok 45 - error appears in log/*.csv 507s ok 46 - pg_dropcluster 16 main --stop 507s ok 47 - pg_dropcluster removes cluster 507s # Cleanup 507s ok 48 - Cleanup: No clusters left behind 507s ok 49 - No postgres processes left behind 507s ok 50 - No files in /etc/postgresql left behind 507s ok 51 - No files in /var/lib/postgresql left behind 507s ok 52 - No files in /var/run/postgresql left behind 507s ok 53 - No files in /var/log/postgresql left behind 507s ok 54 - PostgreSQL TCP ports are closed 507s ok 55 - Next free port is 5432 507s ### End test 025_logging.t ### 507s 507s ### PostgreSQL test 030_errors.t ### 507s 1..156 507s ok 1 - pg_lscluster reports cluster without binaries 509s ok 2 - pg_dropcluster 6.3 main 511s ok 3 - pg_createcluster --socketdir 511s ok 4 - pg_lsclusters -h 511s ok 5 - cluster was created 511s ok 6 - Port of created cluster is 5432 511s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 511s ok 8 - pg_createcluster on existing cluster 511s ok 9 - pg_lsclusters -h 511s ok 10 - original cluster still exists 511s ok 11 - pg_createcluster 16 test -p foo 511s ok 12 - pg_createcluster -p checks that port option is numeric 512s ok 13 - pg_createcluster 16 test -p 42 512s ok 14 - pg_createcluster -p checks valid port range 512s ok 15 - pg_ctlcluster 16 main start 512s ok 16 - pg_ctlcluster refuses to start root-owned cluster 512s ok 17 - pg_ctlcluster 16 main start 512s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 512s ok 19 - pg_ctlcluster 16 main start 512s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 512s ok 21 - pg_ctlcluster 16 main start 512s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 514s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 514s ok 24 - No sockets in /var/run/postgresql 514s ok 25 - Socket is in /tmp/postgresql-testsuite/ 515s ok 26 - cluster stops with custom unix_socket_dir 515s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 517s ok 28 - cluster starts after removing unix_socket_dir 517s ok 29 - Socket is in default dir /var/run/postgresql 517s ok 30 - No sockets in /tmp/postgresql-testsuite/ 517s ok 31 - pg_ctlcluster 16 main stop 517s ok 32 - pg_ctlcluster fails with corrupted PID file 517s ok 33 - pg_lsclusters -h 517s ok 34 - cluster is still online 517s ok 35 - pg_ctlcluster succeeds with restored PID file 517s ok 36 - pg_lsclusters -h 517s ok 37 - cluster is down 517s ok 38 - pg_ctlcluster 16 main stop 517s ok 39 - pg_ctlcluster stop fails on stopped cluster 520s ok 40 - pg_ctlcluster 16 main start 520s ok 41 - pg_ctlcluster succeeds with already existing PID file 520s ok 42 - pg_lsclusters -h 520s ok 43 - cluster is online 520s ok 44 - pg_ctlcluster stop succeeds 520s ok 45 - pg_lsclusters -h 520s ok 46 - cluster is down 520s ok 47 - no pid file left 520s ok 48 - pg_ctlcluster 16 main stop 520s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 520s ok 50 - pid file was cleaned up 520s ok 51 - pg_ctlcluster --force 16 main stop 520s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 520s ok 53 - pid file was cleaned up 520s ok 54 - pg_ctlcluster 16 main stop 520s ok 55 - pg_ctlcluster stop succeeds with stale PID file 520s ok 56 - pid file was cleaned up 520s ok 57 - pg_ctlcluster --force 16 main stop 520s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 520s ok 59 - pid file was cleaned up 520s ok 60 - pg_ctlcluster --force 16 main stop 520s ok 61 - pg_ctlcluster stop succeeds with empty PID file 520s ok 62 - pid file was cleaned up 522s ok 63 - pg_ctlcluster 16 main start 522s ok 64 - pg_ctlcluster succeeds with corrupted PID file 522s ok 65 - pg_lsclusters -h 522s ok 66 - cluster is online 523s ok 67 - pg_ctlcluster 16 main start 523s ok 68 - pg_ctlcluster start fails on running cluster 523s ok 69 - pg_ctlcluster stop 523s ok 70 - pg_ctlcluster 16 main start 523s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 523s ok 72 - pg_ctlcluster 16 main stop 523s ok 73 - stopping cluster 529s ok 74 - pg_ctlcluster 16 main start 529s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 530s ok 76 - pg_ctlcluster 16 main stop 530s ok 77 - stopping cluster 530s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 530s ok 79 - pg_dropcluster 16 main 530s ok 80 - pg_dropcluster works as user postgres 531s ok 81 - pg_createcluster succeeds 531s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 531s ok 83 - proper error message for nonexisting /var/lib/postgresql 534s ok 84 - pg_ctlcluster 16 main start 534s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 534s ok 86 - pg_ctlcluster 16 main stop 534s ok 87 - stopping cluster 535s ok 88 - pg_createcluster other 537s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 540s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 540s ok 91 540s ok 92 - pg_ctlcluster 16 other start 540s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 540s ok 94 - pg_ctlcluster 16 main stop 540s ok 95 - stopping main cluster 542s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 545s ok 97 - pg_dropcluster other 547s ok 98 - pg_dropcluster 547s ok 99 - No sockets any more 547s ok 100 - 'pg_lsclusters 4.5 foo' fails 547s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 547s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 547s ok 103 - 'psql --cluster 4.5/foo' fails 547s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 547s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 547s ok 106 - 'psql --cluster 16/foo' fails 547s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 547s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 547s ok 109 - 'pg_dropcluster 4.5 foo' fails 547s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 547s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 547s ok 112 - 'pg_dropcluster 16 foo' fails 547s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 547s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 548s ok 115 - 'pg_upgradecluster 4.5 foo' fails 548s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 548s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 548s ok 118 - 'pg_upgradecluster 16 foo' fails 548s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 548s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 548s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 548s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 548s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 548s ok 124 - 'pg_ctlcluster 16 foo stop' fails 548s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 548s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 548s # Cleanup 548s ok 127 - Cleanup: No clusters left behind 548s ok 128 - No postgres processes left behind 548s ok 129 - No files in /etc/postgresql left behind 548s ok 130 - No files in /var/lib/postgresql left behind 548s ok 131 - No files in /var/run/postgresql left behind 548s ok 132 - No files in /var/log/postgresql left behind 548s ok 133 - PostgreSQL TCP ports are closed 548s ok 134 - Next free port is 5432 549s ok 135 - pg_dropcluster 16 broken 549s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 549s # Cleanup 549s ok 137 - Cleanup: No clusters left behind 549s ok 138 - No postgres processes left behind 549s ok 139 - No files in /etc/postgresql left behind 549s ok 140 - No files in /var/lib/postgresql left behind 549s ok 141 - No files in /var/run/postgresql left behind 549s ok 142 - No files in /var/log/postgresql left behind 549s ok 143 - PostgreSQL TCP ports are closed 549s ok 144 - Next free port is 5432 552s ok 145 - pg_dropcluster 16 broken 552s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 552s ok 147 - /etc/postgresql/16 was removed 552s ok 148 - /var/lib/postgresql/16 was removed 552s # Cleanup 552s ok 149 - Cleanup: No clusters left behind 552s ok 150 - No postgres processes left behind 552s ok 151 - No files in /etc/postgresql left behind 552s ok 152 - No files in /var/lib/postgresql left behind 552s ok 153 - No files in /var/run/postgresql left behind 552s ok 154 - No files in /var/log/postgresql left behind 552s ok 155 - PostgreSQL TCP ports are closed 552s ok 156 - Next free port is 5432 552s ### End test 030_errors.t ### 552s 552s ### PostgreSQL test 031_errors_disk_full.t ### 552s 1..22 552s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 554s ok 1 - script failed 554s ok 2 - pg_createcluster fails due to insufficient disk space 554s ok 3 - does not leave files behind 554s # Cleanup 554s ok 4 - Cleanup: No clusters left behind 554s ok 5 - No postgres processes left behind 554s ok 6 - No files in /etc/postgresql left behind 554s ok 7 - No files in /var/lib/postgresql left behind 554s ok 8 - No files in /var/run/postgresql left behind 554s ok 9 - No files in /var/log/postgresql left behind 554s ok 10 - PostgreSQL TCP ports are closed 554s ok 11 - Next free port is 5432 554s # check disk full conditions on startup 558s ok 12 - script failed 558s ok 13 - pg_ctlcluster prints error message 558s ok 14 - log file has error message 558s # Cleanup 558s ok 15 - Cleanup: No clusters left behind 558s ok 16 - No postgres processes left behind 558s ok 17 - No files in /etc/postgresql left behind 558s ok 18 - No files in /var/lib/postgresql left behind 558s ok 19 - No files in /var/run/postgresql left behind 558s ok 20 - No files in /var/log/postgresql left behind 558s ok 21 - PostgreSQL TCP ports are closed 558s ok 22 - Next free port is 5432 558s ### End test 031_errors_disk_full.t ### 558s 558s ### PostgreSQL test 032_ssl_key_permissions.t ### 558s 1..22 558s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 558s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 558s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 558s # 16 (16.2-1) 559s ok 4 - pg_createcluster 16 main 560s ok 5 - pg_ctlcluster 16 main start 560s ok 6 - ssl key owned by nobody refused 560s ok 7 - pg_ctlcluster 16 main start 560s ok 8 - ssl key with permissions root:root 0644 refused 560s ok 9 - pg_ctlcluster 16 main start 560s ok 10 - ssl key with permissions postgres:postgres 0640 refused 562s ok 11 - pg_dropcluster 16 main --stop 562s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 562s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 562s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 562s # Cleanup 562s ok 15 - Cleanup: No clusters left behind 562s ok 16 - No postgres processes left behind 562s ok 17 - No files in /etc/postgresql left behind 562s ok 18 - No files in /var/lib/postgresql left behind 562s ok 19 - No files in /var/run/postgresql left behind 562s ok 20 - No files in /var/log/postgresql left behind 562s ok 21 - PostgreSQL TCP ports are closed 562s ok 22 - Next free port is 5432 562s ### End test 032_ssl_key_permissions.t ### 562s 562s ### PostgreSQL test 040_upgrade.t ### 562s 1..1 563s ok 1 - only one major version installed, skipping upgrade tests 563s ### End test 040_upgrade.t ### 563s 563s ### PostgreSQL test 041_upgrade_custompaths.t ### 563s 1..1 563s ok 1 - only one major version installed, skipping upgrade tests 563s ### End test 041_upgrade_custompaths.t ### 563s 563s ### PostgreSQL test 042_upgrade_rename.t ### 563s 1..15 563s # PostgreSQL 16 567s ok 1 - pg_createcluster 16 main --start 575s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 575s ok 3 - pg_lsclusters -h 575s ok 4 - correct output of pg_lsclusters -h 578s ok 5 - pg_dropcluster 16 main --stop 580s ok 6 - pg_dropcluster 16 upgr --stop 580s ok 7 - Cleaning pg_upgrade log files 580s # Cleanup 581s ok 8 - Cleanup: No clusters left behind 581s ok 9 - No postgres processes left behind 581s ok 10 - No files in /etc/postgresql left behind 581s ok 11 - No files in /var/lib/postgresql left behind 581s ok 12 - No files in /var/run/postgresql left behind 581s ok 13 - No files in /var/log/postgresql left behind 581s ok 14 - PostgreSQL TCP ports are closed 581s ok 15 - Next free port is 5432 581s ### End test 042_upgrade_rename.t ### 581s 581s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 581s 1..1 581s ok 1 - only one major version installed, skipping upgrade tests 581s ### End test 043_upgrade_ssl_cert.t ### 581s 581s ### PostgreSQL test 045_backup.t ### 581s # We are running systemd 581s # PostgreSQL 16 581s # create cluster 585s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 585s ok 2 - pg_lsclusters -h 585s ok 3 - correct output of pg_lsclusters -h 585s ok 4 - pg_conftool 16 main set work_mem 11MB 585s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 585s ok 6 - psql -c 'alter database mydb set search_path=public' 585s ok 7 - psql -c 'create table foo (t text)' mydb 585s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 585s ok 9 - psql -c 'CREATE USER myuser' 585s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 586s ok 11 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 586s ok 12 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 586s # create directory 586s ok 13 - pg_backupcluster 16 main createdirectory 586s ok 14 - /var/backups/postgresql/16-main owned by uid postgres 586s ok 15 - /var/backups/postgresql/16-main owned by gid postgres 586s # dump 587s ok 16 - systemctl start pg_dump@16-main 587s ok 17 - dump created in /var/backups/postgresql/16-main/2024-03-24T200545Z.dump 587s ok 18 - /var/backups/postgresql/16-main/2024-03-24T200545Z.dump owned by uid postgres 587s ok 19 - /var/backups/postgresql/16-main/2024-03-24T200545Z.dump owned by gid postgres 587s # basebackup 587s ok 20 - systemctl start pg_receivewal@16-main 587s ok 21 - psql -c 'create table poke_receivewal (t text)' mydb 588s ok 22 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 780s ok 23 - systemctl start pg_basebackup@16-main 780s ok 24 - dump created in /var/backups/postgresql/16-main/2024-03-24T200547Z.backup 780s ok 25 - /var/backups/postgresql/16-main/2024-03-24T200547Z.backup owned by uid postgres 780s ok 26 - /var/backups/postgresql/16-main/2024-03-24T200547Z.backup owned by gid postgres 780s # list 780s ok 27 - pg_backupcluster 16 main list 780s ok 28 - correct output of pg_backupcluster 16 main list 780s # more database changes 780s ok 29 - psql -c "insert into foo values ('data later deleted')" mydb 780s ok 30 - psql -c "insert into foo values ('data from archive')" mydb 780s ok 31 - retrieve recovery timestamp 780s ok 32 - psql -c "delete from foo where t = 'data later deleted'" mydb 781s ok 33 - systemctl stop pg_receivewal@16-main 781s # restore /var/backups/postgresql/16-main/2024-03-24T200545Z.dump 783s ok 34 - pg_dropcluster 16 main --stop 789s ok 35 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200545Z.dump --start --datadir /var/lib/postgresql/16/snowflake 789s ok 36 - pg_lsclusters -h 789s ok 37 - correct output of pg_lsclusters -h 789s ok 38 - psql -XAtl 789s ok 39 - mydb locales 789s ok 40 - myicudb locales 789s ok 41 - psql -XAtc 'show work_mem' 789s ok 42 - correct output of psql -XAtc 'show work_mem' 789s ok 43 - psql -XAtc 'select * from foo' mydb 789s ok 44 - correct output of psql -XAtc 'select * from foo' mydb 790s ok 45 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 790s ok 46 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 790s ok 47 - psql -XAtc '\drds' 790s ok 48 - correct output of psql -XAtc '\drds' 790s # restore /var/backups/postgresql/16-main/2024-03-24T200547Z.backup 792s ok 49 - pg_dropcluster 16 main --stop 797s ok 50 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200547Z.backup --start --datadir /var/lib/postgresql/16/snowflake 797s ok 51 - pg_lsclusters -h 797s ok 52 - correct output of pg_lsclusters -h 797s ok 53 - psql -XAtl 797s ok 54 - mydb locales 797s ok 55 - myicudb locales 797s ok 56 - psql -XAtc 'show work_mem' 797s ok 57 - correct output of psql -XAtc 'show work_mem' 797s ok 58 - psql -XAtc 'select * from foo' mydb 797s ok 59 - correct output of psql -XAtc 'select * from foo' mydb 797s ok 60 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 797s ok 61 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 797s ok 62 - psql -XAtc '\drds' 797s ok 63 - correct output of psql -XAtc '\drds' 797s # restore /var/backups/postgresql/16-main/2024-03-24T200547Z.backup with WAL archive 799s ok 64 - pg_dropcluster 16 main --stop 803s ok 65 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200547Z.backup --start --archive --port 5430 803s ok 66 - pg_lsclusters -h 803s ok 67 - correct output of pg_lsclusters -h 803s ok 68 - psql -XAtc 'select * from foo order by t' mydb 803s ok 69 - correct output of psql -XAtc 'select * from foo order by t' mydb 803s # restore /var/backups/postgresql/16-main/2024-03-24T200547Z.backup with PITR 806s ok 70 - pg_dropcluster 16 main --stop 810s ok 71 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200547Z.backup --start --pitr '2024-03-24 20:08:59.44763+00 810s # ' 810s ok 72 - pg_lsclusters -h 810s ok 73 - correct output of pg_lsclusters -h 810s ok 74 - psql -XAtc 'select * from foo order by t' mydb 810s ok 75 - correct output of psql -XAtc 'select * from foo order by t' mydb 813s ok 76 - pg_dropcluster 16 main --stop 813s # Cleanup 813s ok 77 - Cleanup: No clusters left behind 813s ok 78 - No postgres processes left behind 813s ok 79 - No files in /etc/postgresql left behind 813s ok 80 - No files in /var/lib/postgresql left behind 813s ok 81 - No files in /var/run/postgresql left behind 813s ok 82 - No files in /var/log/postgresql left behind 813s ok 83 - PostgreSQL TCP ports are closed 813s ok 84 - Next free port is 5432 813s 1..84 813s ### End test 045_backup.t ### 813s 813s ### PostgreSQL test 050_encodings.t ### 813s 1..60 813s # Checking 16 ru_RU 817s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 818s ok 2 - psql -l succeeds 818s ok 3 - template1 is not UTF-8 encoded 818s ok 4 - creating test database 819s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 819s # create table t (x varchar); copy t from stdin" test 819s ok 6 - creating table with ISO-8859-5 characters 819s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 819s ok 8 - correct string in UTF-8 819s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 819s ok 10 - correct string in ISO-8859-5 819s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 819s # delete from t; copy t from stdin" test 819s ok 12 - creating table with UTF-8 characters 819s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 819s ok 14 - correct string in UTF-8 819s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 819s ok 16 - correct string in ISO-8859-1 819s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 819s ok 18 - Server error message has correct language and encoding 822s ok 19 - pg_ctlcluster 16 ru_RU restart 822s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 824s ok 21 - Dropping cluster 824s # Checking 16 ru_RU.UTF-8 830s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 831s ok 23 - psql -l succeeds 831s ok 24 - template1 is UTF-8 encoded 831s ok 25 - creating test database 831s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 831s # create table t (x varchar); copy t from stdin" test 831s ok 27 - creating table with ISO-8859-5 characters 831s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 831s ok 29 - correct string in UTF-8 831s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 831s ok 31 - correct string in ISO-8859-5 831s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 831s # delete from t; copy t from stdin" test 831s ok 33 - creating table with UTF-8 characters 831s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 831s ok 35 - correct string in UTF-8 831s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 831s ok 37 - correct string in ISO-8859-1 831s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 831s ok 39 - Server error message has correct language and encoding 833s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 833s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 833s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 833s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 833s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 833s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 833s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 833s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 836s ok 48 - Dropping cluster 836s # Check 16 locale environment variables 840s ok 49 - pg_createcluster: LC_ALL dominates LANG 840s ok 50 - psql -Atl --cluster 16/main 840s ok 51 - template1 is ASCII encoded 842s ok 52 - Dropping cluster 842s # Cleanup 842s ok 53 - Cleanup: No clusters left behind 842s ok 54 - No postgres processes left behind 842s ok 55 - No files in /etc/postgresql left behind 842s ok 56 - No files in /var/lib/postgresql left behind 842s ok 57 - No files in /var/run/postgresql left behind 842s ok 58 - No files in /var/log/postgresql left behind 842s ok 59 - PostgreSQL TCP ports are closed 842s ok 60 - Next free port is 5432 842s ### End test 050_encodings.t ### 842s 842s ### PostgreSQL test 052_upgrade_encodings.t ### 842s 1..1 842s ok 1 - only one major version installed, skipping upgrade tests 842s ### End test 052_upgrade_encodings.t ### 842s 842s ### PostgreSQL test 060_obsolete_confparams.t ### 843s ok 1 - only one major version installed, skipping upgrade tests 843s 1..1 843s ### End test 060_obsolete_confparams.t ### 843s 843s ### PostgreSQL test 070_non_postgres_clusters.t ### 843s 1..40 844s ok 1 - pg_createcluster 16 main for owner nobody 844s ok 2 - pg_ctlcluster 16 main start 844s ok 3 - start refused when config and data owners mismatch 847s ok 4 - pg_ctlcluster succeeds with owner nobody 847s ok 5 - pg_lsclusters -h 847s ok 6 - pg_lsclusters shows running cluster 847s ok 7 - postgres is running as user nobody 847s ok 8 - ls /tmp/.s.PGSQL.* 847s ok 9 - socket is in /tmp 847s ok 10 - /var/run/postgresql is empty 847s ok 11 - conf dir is owned by user 847s ok 12 - conf dir is owned by user's primary group 847s ok 13 - files are owned by user 847s ok 14 - files are owned by user's primary group 847s ok 15 - log file has 0640 permissions 847s ok 16 - log file is owned by user 847s ok 17 - log file is owned by user's primary group 847s ok 18 - only one major version installed, skipping upgrade test 847s ok 19 - ... 847s ok 20 - ... 847s ok 21 - ... 847s ok 22 - ... 847s ok 23 - ... 847s ok 24 - ... 847s ok 25 - ... 847s ok 26 - ... 847s ok 27 - ... 847s ok 28 - ... 850s ok 29 - pg_dropcluster 850s ok 30 - pg_lsclusters -h 850s ok 31 - No clusters left 850s ok 32 - No postgres processes left 850s # Cleanup 850s ok 33 - Cleanup: No clusters left behind 850s ok 34 - No postgres processes left behind 850s ok 35 - No files in /etc/postgresql left behind 850s ok 36 - No files in /var/lib/postgresql left behind 850s ok 37 - No files in /var/run/postgresql left behind 850s ok 38 - No files in /var/log/postgresql left behind 850s ok 39 - PostgreSQL TCP ports are closed 850s ok 40 - Next free port is 5432 850s ### End test 070_non_postgres_clusters.t ### 850s 850s ### PostgreSQL test 080_start.conf.t ### 850s 1..73 851s ok 1 - pg_createcluster 16 main 851s # start.conf auto 851s ok 2 - get_cluster_start_conf returns auto 851s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 851s ok 4 - start.conf contains auto 851s ok 5 - systemd generator links cluster 851s ok 6 - systemd generator links correct service file 854s ok 7 - /etc/init.d/postgresql start 16 854s ok 8 - correct output of /etc/init.d/postgresql start 16 854s ok 9 - pg_lsclusters -h 854s ok 10 - cluster is online 854s ok 11 - /etc/init.d/postgresql stop 16 854s ok 12 - correct output of /etc/init.d/postgresql stop 16 857s ok 13 - pg_lsclusters -h 857s ok 14 - cluster is down 857s # start.conf manual 857s ok 15 - get_cluster_start_conf returns manual 857s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 857s ok 17 - start.conf contains manual 858s ok 18 - systemd generator doesn't link cluster 858s ok 19 - /etc/init.d/postgresql start 16 858s ok 20 - correct output of /etc/init.d/postgresql start 16 858s ok 21 - pg_lsclusters -h 858s ok 22 - cluster is down 860s ok 23 - pg_ctlcluster 16 main start 860s ok 24 - correct output of pg_ctlcluster 16 main start 860s ok 25 - pg_lsclusters -h 860s ok 26 - cluster is online 860s ok 27 - pg_ctlcluster 16 main stop 860s ok 28 - correct output of pg_ctlcluster 16 main stop 860s ok 29 - pg_lsclusters -h 860s ok 30 - cluster is down 860s # start.conf disabled 860s ok 31 - get_cluster_start_conf returns disabled 860s ok 32 - systemd generator doesn't link cluster 860s ok 33 - /etc/init.d/postgresql start 16 860s ok 34 - correct output of /etc/init.d/postgresql start 16 861s ok 35 - pg_lsclusters -h 861s ok 36 - cluster is down 861s ok 37 - pg_ctlcluster 16 main start 861s ok 38 - correct output of pg_ctlcluster 16 main start 861s ok 39 - pg_lsclusters -h 861s ok 40 - cluster is down 863s ok 41 - pg_ctlcluster 16 main start 863s ok 42 - correct output of pg_ctlcluster 16 main start 863s ok 43 - pg_lsclusters -h 863s ok 44 - cluster is online 863s ok 45 - pg_ctlcluster 16 main stop 863s ok 46 - correct output of pg_ctlcluster 16 main stop 863s ok 47 - pg_lsclusters -h 863s ok 48 - cluster is down 866s ok 49 - pg_ctlcluster 16 main start 866s ok 50 - correct output of pg_ctlcluster 16 main start 866s ok 51 - pg_lsclusters -h 866s ok 52 - cluster is online 866s # test upgrade 866s ok 53 - only one major version installed, skipping upgrade test 866s ok 54 - ... 866s ok 55 - get_cluster_start_conf for old cluster returns manual 866s ok 56 - get_cluster_start_conf for new cluster returns manual 866s ok 57 - ... 868s ok 58 - dropping upgraded cluster 868s ok 59 - pg_lsclusters -h 868s ok 60 - no clusters any more 868s ok 61 - pg_createcluster 16 main --start-conf foo 868s ok 62 - pg_createcluster checks --start-conf validity 869s ok 63 - pg_createcluster checks --start-conf manual 869s ok 64 - get_cluster_start_conf returns manual 871s ok 65 - dropping cluster 871s # Cleanup 872s ok 66 - Cleanup: No clusters left behind 872s ok 67 - No postgres processes left behind 872s ok 68 - No files in /etc/postgresql left behind 872s ok 69 - No files in /var/lib/postgresql left behind 872s ok 70 - No files in /var/run/postgresql left behind 872s ok 71 - No files in /var/log/postgresql left behind 872s ok 72 - PostgreSQL TCP ports are closed 872s ok 73 - Next free port is 5432 872s ### End test 080_start.conf.t ### 872s 872s ### PostgreSQL test 085_pg_ctl.conf.t ### 872s 1..33 872s ok 1 - prlimit --core=0:unlimited --pid=14567 872s ok 2 - set core file size to unlimited 872s ok 3 - sh -c 'ulimit -Hc' 872s ok 4 - core file size is unlimited 873s ok 5 - pg_createcluster 16 main 873s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 876s ok 7 - pg_ctlcluster 16 main start 876s ok 8 - starting cluster as root 876s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 876s ok 10 - soft core size is 0 876s # hard core file size limit of root-started postgres process is unlimited 876s ok 11 - set pg_ctl default option to -c 878s ok 12 - pg_ctlcluster 16 main restart 878s ok 13 - restarting cluster as root 878s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 878s ok 15 - soft core size is unlimited 879s ok 16 - pg_ctlcluster 16 main stop 879s ok 17 - stopping cluster 879s ok 18 - restored pg_ctl default option 881s ok 19 - pg_ctlcluster 16 main start -- -c 881s ok 20 - starting cluster with -c on the command line as postgres 881s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 881s ok 22 - soft core size is unlimited 881s ok 23 - pg_ctlcluster 16 main stop 881s ok 24 - stopping cluster 883s ok 25 - dropping cluster 883s # Cleanup 883s ok 26 - Cleanup: No clusters left behind 883s ok 27 - No postgres processes left behind 883s ok 28 - No files in /etc/postgresql left behind 883s ok 29 - No files in /var/lib/postgresql left behind 883s ok 30 - No files in /var/run/postgresql left behind 883s ok 31 - No files in /var/log/postgresql left behind 883s ok 32 - PostgreSQL TCP ports are closed 883s ok 33 - Next free port is 5432 883s ### End test 085_pg_ctl.conf.t ### 883s 883s ### PostgreSQL test 090_multicluster.t ### 884s 1..125 885s ok 1 - pg_createcluster 16 old 886s ok 2 - pg_createcluster 16 new1 888s ok 3 - pg_createcluster 16 new2 891s ok 4 - starting cluster 16/old 893s ok 5 - starting cluster 16/new1 896s ok 6 - starting cluster 16/new2 896s ok 7 - pg_lsclusters -h | sort -k3 896s ok 8 - clusters have the correct ports, skipping used 5433 896s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 896s ok 10 - createdb --version 896s ok 11 - pg_wrapper selects port 5432 as default cluster 896s ok 12 - createdb --cluster 16/new1 --version 896s ok 13 - pg_wrapper --cluster works 896s ok 14 - createdb --cluster 16/foo --version 896s ok 15 - pg_wrapper --cluster errors out for invalid cluster 896s ok 16 - createdb --cluster 16/new1 test 896s ok 17 - correct output of createdb --cluster 16/new1 test 896s ok 18 - psql -Atl --cluster 16/new1 896s ok 19 - test db appears in cluster new1 896s ok 20 - psql -Atl --cluster 16/new2 896s ok 21 - test db does not appear in cluster new2 896s ok 22 - psql -Atl 896s ok 23 - test db does not appear in default cluster 896s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 896s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 896s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 896s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 896s ok 28 - psql -Atl --cluster 16/localhost:5434 896s ok 29 - test db appears in cluster 16/localhost:5434 896s ok 30 - psql -Atl --cluster 16/localhost:5440 896s ok 31 - test db does not appear in cluster 16/localhost:5440 896s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 896s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 896s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 896s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 896s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 896s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 897s ok 38 - psql -Atl --cluster 6.4/localhost: 897s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 897s ok 40 - psql -Atl 897s ok 41 - PGCLUSTER selection (1) 897s ok 42 - psql -Atl 897s ok 43 - PGCLUSTER selection (2) 897s ok 44 - psql -l 897s ok 45 - invalid PGCLUSTER value 897s ok 46 - createdb --version 897s ok 47 - PGCLUSTER network cluster selection (1) 897s ok 48 - psql -Atl 897s ok 49 - PGCLUSTER network cluster selection (2) 897s ok 50 - psql -Atl 897s ok 51 - PGCLUSTER network cluster selection (3) 897s ok 52 - LC_MESSAGES=C psql -Atl 897s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 897s ok 54 - psql -Atc "show port" template1 897s ok 55 - PGPORT selection (1) 897s ok 56 - psql -Atc "show port" template1 897s ok 57 - PGPORT selection (2) 897s ok 58 - createdb --version 897s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 897s ok 60 - psql -Atc "show port" template1 897s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 897s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 897s ok 63 - PGDATABASE environment variable works 897s ok 64 - createdb --version 897s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 897s ok 66 - createdb --cluster 16/new1 --version 897s ok 67 - pg_wrapper --cluster works with empty user_clusters 897s ok 68 - createdb --version 897s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 897s ok 70 - psql -Atc "select current_database()" 897s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 897s ok 72 - psql -Atc 'select current_database()' 897s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 898s ok 74 - createdb --version 898s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 898s ok 76 - createdb --version 898s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 898s ok 78 - createdb --version 898s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 898s ok 80 - createdb --version 898s ok 81 - pg_wrapper selects correct version with per-user user_clusters 898s ok 82 - createdb --version 898s ok 83 - pg_wrapper selects correct version with per-user user_clusters 898s ok 84 - createdb --version 898s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 898s ok 86 - psql -Atl 898s ok 87 - $PGHOST overrides user_clusters 898s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 898s ok 89 - --cluster overrides $PGHOST 898s ok 90 - createdb --version 898s ok 91 - pg_wrapper ignores invalid lines in user_clusters 898s ok 92 - psql -Atc 'select current_database()' 898s ok 93 - pg_service conf selection 1 898s ok 94 - psql -Atc 'select current_database()' 898s ok 95 - pg_service conf selection 2 898s ok 96 - psql -Atc 'select current_database()' 898s ok 97 - pg_service conf selection 3 898s ok 98 - stopping cluster 16/old 901s ok 99 - restarting cluster 16/old 901s ok 100 - pg_lsclusters -h | sort -k3 901s ok 101 - port of first cluster was successfully changed 901s ok 102 - psql -l 901s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 902s ok 104 - psql -Atl --cluster 16/new1 902s ok 105 - --cluster selects appropriate cluster 902s ok 106 - psql -Atl -p 5434 902s ok 107 - -p selects appropriate cluster 902s ok 108 - psql -Atlp 5434 902s ok 109 - -Atlp selects appropriate cluster 902s ok 110 - psql -Atl --port 5434 902s ok 111 - --port selects appropriate cluster 902s ok 112 - env PGPORT=5434 psql -Atl 902s ok 113 - $PGPORT selects appropriate cluster 902s ok 114 - Restoring original /etc/postgresql-common/user_clusters 904s ok 115 - dropping 16/new1 907s ok 116 - dropping 16/new2 909s ok 117 - dropping 16/old 909s # Cleanup 909s ok 118 - Cleanup: No clusters left behind 909s ok 119 - No postgres processes left behind 909s ok 120 - No files in /etc/postgresql left behind 909s ok 121 - No files in /var/lib/postgresql left behind 909s ok 122 - No files in /var/run/postgresql left behind 909s ok 123 - No files in /var/log/postgresql left behind 909s ok 124 - PostgreSQL TCP ports are closed 909s ok 125 - Next free port is 5432 909s ### End test 090_multicluster.t ### 909s 909s ### PostgreSQL test 110_integrate_cluster.t ### 909s 1..32 911s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/20Aq_Mb8c6/c/postgres 911s ok 2 - creating raw initdb cluster for user postgres 911s ok 3 - pg_createcluster 16 postgres -d /tmp/20Aq_Mb8c6/c/postgres 911s ok 4 - integrating postgres cluster 911s ok 5 - pg_lsclusters 911s ok 6 - correct pg_lsclusters output 913s ok 7 - pg_ctlcluster 16 postgres start 913s ok 8 - starting cluster postgres 914s ok 9 - pg_lsclusters 914s ok 10 - correct pg_lsclusters output 915s ok 11 - dropping cluster postgres 915s ok 12 - No files in temporary cluster dir left behind 917s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/20Aq_Mb8c6/c/nobody 917s ok 14 - creating raw initdb cluster for user nobody 917s ok 15 - pg_createcluster 16 nobody -d /tmp/20Aq_Mb8c6/c/nobody 917s ok 16 - integrating nobody cluster 917s ok 17 - pg_lsclusters 917s ok 18 - correct pg_lsclusters output 919s ok 19 - pg_ctlcluster 16 nobody start 919s ok 20 - starting cluster nobody 919s ok 21 - pg_lsclusters 919s ok 22 - correct pg_lsclusters output 922s ok 23 - dropping cluster nobody 922s ok 24 - No files in temporary cluster dir left behind 922s # Cleanup 922s ok 25 - Cleanup: No clusters left behind 922s ok 26 - No postgres processes left behind 922s ok 27 - No files in /etc/postgresql left behind 922s ok 28 - No files in /var/lib/postgresql left behind 922s ok 29 - No files in /var/run/postgresql left behind 922s ok 30 - No files in /var/log/postgresql left behind 922s ok 31 - PostgreSQL TCP ports are closed 922s ok 32 - Next free port is 5432 922s ### End test 110_integrate_cluster.t ### 922s 922s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 922s 1..1 922s ok 1 - only one major version installed, skipping upgrade tests 922s ### End test 120_pg_upgradecluster_scripts.t ### 922s 922s ### PostgreSQL test 130_nonroot_admin.t ### 922s 1..22 926s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 926s ok 2 - pg_lsclusters -h 926s ok 3 - correct output of pg_lsclusters -h 926s ok 4 - psql -Atl 926s ok 5 - correct output of psql -Atl 926s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 926s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 926s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 926s # Cleanup 926s ok 15 - Cleanup: No clusters left behind 926s ok 16 - No postgres processes left behind 926s ok 17 - No files in /etc/postgresql left behind 926s ok 18 - No files in /var/lib/postgresql left behind 926s ok 19 - No files in /var/run/postgresql left behind 926s ok 20 - No files in /var/log/postgresql left behind 926s ok 21 - PostgreSQL TCP ports are closed 926s ok 22 - Next free port is 5432 926s ### End test 130_nonroot_admin.t ### 926s 926s ### PostgreSQL test 135_pg_virtualenv.t ### 926s 1..20 932s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 932s ok 2 - running pg_virtualenv as root 936s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 936s ok 4 - running pg_virtualenv as postgres 940s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 940s ok 6 - running pg_virtualenv as nobody 944s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 944s ok 8 - running fakeroot pg_virtualenv as root 948s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 948s ok 10 - running fakeroot pg_virtualenv as postgres 951s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 951s ok 12 - running fakeroot pg_virtualenv as nobody 951s # Cleanup 951s ok 13 - Cleanup: No clusters left behind 951s ok 14 - No postgres processes left behind 951s ok 15 - No files in /etc/postgresql left behind 951s ok 16 - No files in /var/lib/postgresql left behind 951s ok 17 - No files in /var/run/postgresql left behind 951s ok 18 - No files in /var/log/postgresql left behind 951s ok 19 - PostgreSQL TCP ports are closed 951s ok 20 - Next free port is 5432 951s ### End test 135_pg_virtualenv.t ### 951s 951s ### PostgreSQL test 140_pg_config.t ### 951s 1..38 951s # Multiarch is enabled 951s # checking version specific output for 16 951s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 951s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 951s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 951s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 951s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 951s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 951s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 951s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 951s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 951s # checking pg_config output (should behave like version 16) 951s ok 15 - pg_config 951s ok 16 - correct output of pg_config 951s ok 17 - pg_config --help 951s ok 18 - correct output of pg_config --help 951s ok 19 - pg_config --pgxs 951s ok 20 - correct output of pg_config --pgxs 951s ok 21 - pg_config --libdir 951s ok 22 - correct output of pg_config --libdir 951s ok 23 - pg_config --pkglibdir 951s ok 24 - correct output of pg_config --pkglibdir 951s ok 25 - pg_config --bindir 951s ok 26 - correct output of pg_config --bindir 951s # checking pg_config.libpq-dev output (should behave like version 16) 951s ok 27 - pg_config.libpq-dev 951s ok 28 - correct output of pg_config.libpq-dev 951s ok 29 - pg_config.libpq-dev --help 951s ok 30 - correct output of pg_config.libpq-dev --help 951s ok 31 - pg_config.libpq-dev --pgxs 951s ok 32 - correct output of pg_config.libpq-dev --pgxs 951s ok 33 - pg_config.libpq-dev --libdir 951s ok 34 - correct output of pg_config.libpq-dev --libdir 951s ok 35 - pg_config.libpq-dev --pkglibdir 951s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 951s ok 37 - pg_config.libpq-dev --bindir 951s ok 38 - correct output of pg_config.libpq-dev --bindir 951s ### End test 140_pg_config.t ### 951s 951s ### PostgreSQL test 150_tsearch_stemming.t ### 952s 1..37 952s ok 1 - pg_updatedicts succeeded 952s ok 2 - pg_updatedicts created en_us.affix 952s ok 3 - pg_updatedicts created en_us.dict 952s ok 4 - pg_updatedicts created 16 en_us.affix symlink 952s ok 5 - pg_updatedicts created 16 en_us.dict symlink 955s ok 6 - pg_createcluster 16 main 955s ok 7 - createdb fts 955s ok 8 - correct output of createdb fts 956s ok 9 - creating en_US full text search configuration 956s ok 10 - creating data table and search index 956s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 956s ok 12 - stem search of correct word 956s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 956s ok 14 - stem search of correct word 956s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 956s ok 16 - stem search of unknown word 956s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 956s ok 18 - full text search, exact word 956s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 956s ok 20 - full text search for word stem 957s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 957s ok 22 - full text search for word substring fails 957s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 957s ok 24 - full text search, exact unicode word 957s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 957s ok 26 - full text search for unicode word stem 957s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 957s ok 28 - full text search for unicode word substring fails 959s ok 29 959s # Cleanup 959s ok 30 - Cleanup: No clusters left behind 959s ok 31 - No postgres processes left behind 959s ok 32 - No files in /etc/postgresql left behind 959s ok 33 - No files in /var/lib/postgresql left behind 959s ok 34 - No files in /var/run/postgresql left behind 959s ok 35 - No files in /var/log/postgresql left behind 959s ok 36 - PostgreSQL TCP ports are closed 959s ok 37 - Next free port is 5432 959s ### End test 150_tsearch_stemming.t ### 959s 959s ### PostgreSQL test 160_alternate_confroot.t ### 959s 1..28 963s ok 1 963s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 963s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 963s ok 4 - pg_lsclusters -h 963s ok 5 - correct output of pg_lsclusters -h 963s ok 6 - psql -Atl 963s ok 7 - correct output of psql -Atl 963s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 963s ok 9 - ... 963s ok 10 - ... 963s ok 11 - ... 963s ok 12 - ... 963s ok 13 - ... 963s ok 14 - ... 963s ok 15 - pg_dropcluster 16 test --stop 963s ok 16 - correct output of pg_dropcluster 16 test --stop 963s ok 17 - pg_lsclusters -h 963s ok 18 - correct output of pg_lsclusters -h 963s ok 19 - No files in root/data left behind 963s ok 20 - No cruft in root dir left behind 963s # Cleanup 963s ok 21 - Cleanup: No clusters left behind 963s ok 22 - No postgres processes left behind 963s ok 23 - No files in /etc/postgresql left behind 963s ok 24 - No files in /var/lib/postgresql left behind 963s ok 25 - No files in /var/run/postgresql left behind 963s ok 26 - No files in /var/log/postgresql left behind 963s ok 27 - PostgreSQL TCP ports are closed 963s ok 28 - Next free port is 5432 963s ### End test 160_alternate_confroot.t ### 963s 963s ### PostgreSQL test 170_extensions.t ### 963s # Running tests for 16 967s ok 1 - pg_createcluster 16 main 967s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 967s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 967s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 967s ok 5 - extension adminpack installs without error 967s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 967s ok 7 - extension adminpack removes without error 967s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 967s ok 9 - extension amcheck installs without error 967s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 967s ok 11 - extension amcheck removes without error 967s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 967s ok 13 - extension autoinc installs without error 967s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 967s ok 15 - extension autoinc removes without error 968s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 968s ok 17 - extension bloom installs without error 968s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 968s ok 19 - extension bloom removes without error 968s ok 20 - psql -qc 'CREATE EXTENSION plperl' 968s ok 21 - bool_plperl dependency plperl installs without error 968s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 968s ok 23 - extension bool_plperl installs without error 968s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 968s ok 25 - extension bool_plperl removes without error 968s ok 26 - psql -qc 'DROP EXTENSION plperl' 968s ok 27 - bool_plperl dependency extension plperl removes without error 968s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 968s ok 29 - bool_plperlu dependency plperlu installs without error 968s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 968s ok 31 - extension bool_plperlu installs without error 968s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 968s ok 33 - extension bool_plperlu removes without error 968s ok 34 - psql -qc 'DROP EXTENSION plperlu' 968s ok 35 - bool_plperlu dependency extension plperlu removes without error 968s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 968s ok 37 - extension btree_gin installs without error 968s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 968s ok 39 - extension btree_gin removes without error 968s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 968s ok 41 - extension btree_gist installs without error 968s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 968s ok 43 - extension btree_gist removes without error 969s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 969s ok 45 - extension citext installs without error 969s ok 46 - psql -qc 'DROP EXTENSION "citext"' 969s ok 47 - extension citext removes without error 969s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 969s ok 49 - extension cube installs without error 969s ok 50 - psql -qc 'DROP EXTENSION "cube"' 969s ok 51 - extension cube removes without error 969s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 969s ok 53 - extension dblink installs without error 969s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 969s ok 55 - extension dblink removes without error 969s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 969s ok 57 - extension dict_int installs without error 969s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 969s ok 59 - extension dict_int removes without error 969s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 969s ok 61 - extension dict_xsyn installs without error 969s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 969s ok 63 - extension dict_xsyn removes without error 969s ok 64 - psql -qc 'CREATE EXTENSION cube' 969s ok 65 - earthdistance dependency cube installs without error 969s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 969s ok 67 - extension earthdistance installs without error 969s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 969s ok 69 - extension earthdistance removes without error 970s ok 70 - psql -qc 'DROP EXTENSION cube' 970s ok 71 - earthdistance dependency extension cube removes without error 970s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 970s ok 73 - extension file_fdw installs without error 970s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 970s ok 75 - extension file_fdw removes without error 970s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 970s ok 77 - extension fuzzystrmatch installs without error 970s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 970s ok 79 - extension fuzzystrmatch removes without error 970s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 970s ok 81 - extension hstore installs without error 970s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 970s ok 83 - extension hstore removes without error 970s ok 84 - psql -qc 'CREATE EXTENSION hstore' 970s ok 85 - hstore_plperl dependency hstore installs without error 970s ok 86 - psql -qc 'CREATE EXTENSION plperl' 970s ok 87 - hstore_plperl dependency plperl installs without error 970s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 970s ok 89 - extension hstore_plperl installs without error 970s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 970s ok 91 - extension hstore_plperl removes without error 970s ok 92 - psql -qc 'DROP EXTENSION hstore' 970s ok 93 - hstore_plperl dependency extension hstore removes without error 971s ok 94 - psql -qc 'DROP EXTENSION plperl' 971s ok 95 - hstore_plperl dependency extension plperl removes without error 971s ok 96 - psql -qc 'CREATE EXTENSION hstore' 971s ok 97 - hstore_plperlu dependency hstore installs without error 971s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 971s ok 99 - hstore_plperlu dependency plperlu installs without error 971s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 971s ok 101 - extension hstore_plperlu installs without error 971s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 971s ok 103 - extension hstore_plperlu removes without error 971s ok 104 - psql -qc 'DROP EXTENSION hstore' 971s ok 105 - hstore_plperlu dependency extension hstore removes without error 971s ok 106 - psql -qc 'DROP EXTENSION plperlu' 971s ok 107 - hstore_plperlu dependency extension plperlu removes without error 971s ok 108 - psql -qc 'CREATE EXTENSION hstore' 971s ok 109 - hstore_plpython3u dependency hstore installs without error 971s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 971s ok 111 - hstore_plpython3u dependency plpython3u installs without error 971s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 971s ok 113 - extension hstore_plpython3u installs without error 971s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 971s ok 115 - extension hstore_plpython3u removes without error 972s ok 116 - psql -qc 'DROP EXTENSION hstore' 972s ok 117 - hstore_plpython3u dependency extension hstore removes without error 972s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 972s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 972s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 972s ok 121 - extension insert_username installs without error 972s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 972s ok 123 - extension insert_username removes without error 972s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 972s ok 125 - extension intagg installs without error 972s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 972s ok 127 - extension intagg removes without error 972s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 972s ok 129 - extension intarray installs without error 972s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 972s ok 131 - extension intarray removes without error 972s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 972s ok 133 - extension isn installs without error 972s ok 134 - psql -qc 'DROP EXTENSION "isn"' 972s ok 135 - extension isn removes without error 972s ok 136 - psql -qc 'CREATE EXTENSION plperl' 972s ok 137 - jsonb_plperl dependency plperl installs without error 972s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 972s ok 139 - extension jsonb_plperl installs without error 972s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 972s ok 141 - extension jsonb_plperl removes without error 973s ok 142 - psql -qc 'DROP EXTENSION plperl' 973s ok 143 - jsonb_plperl dependency extension plperl removes without error 973s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 973s ok 145 - jsonb_plperlu dependency plperlu installs without error 973s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 973s ok 147 - extension jsonb_plperlu installs without error 973s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 973s ok 149 - extension jsonb_plperlu removes without error 973s ok 150 - psql -qc 'DROP EXTENSION plperlu' 973s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 973s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 973s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 973s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 973s ok 155 - extension jsonb_plpython3u installs without error 973s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 973s ok 157 - extension jsonb_plpython3u removes without error 973s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 973s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 973s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 973s ok 161 - extension lo installs without error 973s ok 162 - psql -qc 'DROP EXTENSION "lo"' 973s ok 163 - extension lo removes without error 973s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 973s ok 165 - extension ltree installs without error 973s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 973s ok 167 - extension ltree removes without error 973s ok 168 - psql -qc 'CREATE EXTENSION ltree' 973s ok 169 - ltree_plpython3u dependency ltree installs without error 973s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 973s ok 171 - ltree_plpython3u dependency plpython3u installs without error 974s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 974s ok 173 - extension ltree_plpython3u installs without error 974s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 974s ok 175 - extension ltree_plpython3u removes without error 974s ok 176 - psql -qc 'DROP EXTENSION ltree' 974s ok 177 - ltree_plpython3u dependency extension ltree removes without error 974s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 974s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 974s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 974s ok 181 - extension moddatetime installs without error 974s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 974s ok 183 - extension moddatetime removes without error 974s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 974s ok 185 - extension old_snapshot installs without error 974s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 974s ok 187 - extension old_snapshot removes without error 974s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 974s ok 189 - extension pageinspect installs without error 974s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 974s ok 191 - extension pageinspect removes without error 974s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 974s ok 193 - extension pg_buffercache installs without error 974s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 974s ok 195 - extension pg_buffercache removes without error 974s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 974s ok 197 - extension pg_freespacemap installs without error 974s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 974s ok 199 - extension pg_freespacemap removes without error 974s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 974s ok 201 - extension pg_prewarm installs without error 974s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 974s ok 203 - extension pg_prewarm removes without error 975s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 975s ok 205 - extension pg_stat_statements installs without error 975s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 975s ok 207 - extension pg_stat_statements removes without error 975s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 975s ok 209 - extension pg_surgery installs without error 975s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 975s ok 211 - extension pg_surgery removes without error 975s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 975s ok 213 - extension pg_trgm installs without error 975s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 975s ok 215 - extension pg_trgm removes without error 975s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 975s ok 217 - extension pg_visibility installs without error 976s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 976s ok 219 - extension pg_visibility removes without error 976s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 976s ok 221 - extension pg_walinspect installs without error 976s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 976s ok 223 - extension pg_walinspect removes without error 976s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 976s ok 225 - extension pgcrypto installs without error 976s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 976s ok 227 - extension pgcrypto removes without error 976s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 976s ok 229 - extension pgrowlocks installs without error 976s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 976s ok 231 - extension pgrowlocks removes without error 976s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 976s ok 233 - extension pgstattuple installs without error 976s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 976s ok 235 - extension pgstattuple removes without error 976s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 976s ok 237 - extension plperl installs without error 976s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 976s ok 239 - extension plperl removes without error 976s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 976s ok 241 - extension plperlu installs without error 976s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 976s ok 243 - extension plperlu removes without error 976s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 976s ok 245 - extension plpython3u installs without error 976s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 976s ok 247 - extension plpython3u removes without error 976s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 976s ok 249 - extension pltcl installs without error 976s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 976s ok 251 - extension pltcl removes without error 976s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 976s ok 253 - extension pltclu installs without error 976s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 976s ok 255 - extension pltclu removes without error 976s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 976s ok 257 - extension postgres_fdw installs without error 976s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 976s ok 259 - extension postgres_fdw removes without error 976s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 976s ok 261 - extension refint installs without error 976s ok 262 - psql -qc 'DROP EXTENSION "refint"' 976s ok 263 - extension refint removes without error 976s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 976s ok 265 - extension seg installs without error 977s ok 266 - psql -qc 'DROP EXTENSION "seg"' 977s ok 267 - extension seg removes without error 977s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 977s ok 269 - extension sslinfo installs without error 977s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 977s ok 271 - extension sslinfo removes without error 977s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 977s ok 273 - extension tablefunc installs without error 977s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 977s ok 275 - extension tablefunc removes without error 977s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 977s ok 277 - extension tcn installs without error 977s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 977s ok 279 - extension tcn removes without error 977s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 977s ok 281 - extension tsm_system_rows installs without error 977s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 977s ok 283 - extension tsm_system_rows removes without error 977s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 977s ok 285 - extension tsm_system_time installs without error 977s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 977s ok 287 - extension tsm_system_time removes without error 977s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 977s ok 289 - extension unaccent installs without error 977s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 977s ok 291 - extension unaccent removes without error 977s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 977s ok 293 - extension uuid-ossp installs without error 977s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 977s ok 295 - extension uuid-ossp removes without error 978s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 978s ok 297 - extension xml2 installs without error 978s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 978s ok 299 - extension xml2 removes without error 980s ok 300 - pg_dropcluster 16 main 980s # Cleanup 980s ok 301 - Cleanup: No clusters left behind 980s ok 302 - No postgres processes left behind 980s ok 303 - No files in /etc/postgresql left behind 980s ok 304 - No files in /var/lib/postgresql left behind 980s ok 305 - No files in /var/run/postgresql left behind 980s ok 306 - No files in /var/log/postgresql left behind 980s ok 307 - PostgreSQL TCP ports are closed 980s ok 308 - Next free port is 5432 980s 1..308 980s ### End test 170_extensions.t ### 980s 980s ### PostgreSQL test 180_ecpg.t ### 980s 1..14 980s ok 1 - ecpg test.pgc 980s ok 2 - ecpg processing 980s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 980s ok 4 - compiling ecpg output 988s ok 5 - pg_virtualenv /tmp/tmp.5IXMc0BL7x/test 988s ok 6 - test program runs and gives correct output 988s # Cleanup 988s ok 7 - Cleanup: No clusters left behind 988s ok 8 - No postgres processes left behind 988s ok 9 - No files in /etc/postgresql left behind 988s ok 10 - No files in /var/lib/postgresql left behind 988s ok 11 - No files in /var/run/postgresql left behind 988s ok 12 - No files in /var/log/postgresql left behind 988s ok 13 - PostgreSQL TCP ports are closed 988s ok 14 - Next free port is 5432 988s ### End test 180_ecpg.t ### 988s 988s ### PostgreSQL test 190_pg_buildext.t ### 988s ok 1 - make clean 988s ok 2 - make tar 988s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 988s # testing 'dh --with pgxs' 993s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 993s ok 5 - postgresql-16-foo_123-1_s390x.deb was built 1001s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1001s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1001s ok 8 - dpkg -i postgresql-16-foo_123-1_s390x.deb 1009s ok 9 - cd foo-123 && pg_buildext installcheck 1009s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 1017s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1017s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1025s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1025s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1025s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 1025s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 1025s ok 17 - dpkg -r postgresql-16-foo 1025s # testing 'dh --with pgxs_loop' 1025s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 1029s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 1029s ok 20 - postgresql-16-foo_123-1_s390x.deb was built 1029s ok 21 - make clean 1029s # testing pg_buildext updatecontrol 1029s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 1029s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 1029s 1..23 1029s ### End test 190_pg_buildext.t ### 1029s 1029s ### PostgreSQL test 200_maintscripts.t ### 1029s 1..15 1029s # We are running systemd 1034s ok 1 - pg_createcluster 16 main --start 1034s ok 2 - postmaster PID is 20620 1036s ok 3 - apt-get update -q 1036s # postgresql-common: 1036s # Installed: 257 1036s # Candidate: 257 1036s # Version table: 1036s # *** 257 990 1036s # 990 http://ftpmaster.internal/ubuntu noble/main s390x Packages 1036s # 100 /var/lib/dpkg/status 1040s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 1040s # postgresql-common: 1040s # Installed: 257 1040s # Candidate: 257 1040s # Version table: 1040s # *** 257 990 1040s # 990 http://ftpmaster.internal/ubuntu noble/main s390x Packages 1040s # 100 /var/lib/dpkg/status 1040s ok 5 - postmaster PID is 20620 1040s ok 6 - postmaster was not restarted 1042s ok 7 - pg_dropcluster 16 main --stop 1042s # Cleanup 1042s ok 8 - Cleanup: No clusters left behind 1042s ok 9 - No postgres processes left behind 1042s ok 10 - No files in /etc/postgresql left behind 1042s ok 11 - No files in /var/lib/postgresql left behind 1042s ok 12 - No files in /var/run/postgresql left behind 1042s ok 13 - No files in /var/log/postgresql left behind 1042s ok 14 - PostgreSQL TCP ports are closed 1042s ok 15 - Next free port is 5432 1042s ### End test 200_maintscripts.t ### 1042s 1042s autopkgtest [20:13:21]: test run-testsuite: -----------------------] 1043s autopkgtest [20:13:22]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 1044s run-testsuite PASS 1045s autopkgtest [20:13:24]: @@@@@@@@@@@@@@@@@@@@ summary 1045s default-psql PASS 1045s run-testsuite PASS 1056s Creating nova instance adt-noble-s390x-postgresql-common-20240324-195559-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-s390x-server-20240324.img (UUID e13d5247-1289-46d4-b3a9-3aa9fa45fdc9)... 1056s Creating nova instance adt-noble-s390x-postgresql-common-20240324-195559-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-s390x-server-20240324.img (UUID e13d5247-1289-46d4-b3a9-3aa9fa45fdc9)...