1s autopkgtest [22:38:43]: starting date and time: 2025-06-19 22:38:43+0000 2s autopkgtest [22:38:44]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 2s autopkgtest [22:38:44]: host juju-7f2275-prod-proposed-migration-environment-21; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.8p6rtahd/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --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-8ubuntu1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-21@bos03-s390x-8.secgroup --name adt-questing-s390x-postgresql-common-20250619-223839-juju-7f2275-prod-proposed-migration-environment-21-4a55144d-0ad6-4ca9-bc8e-d27ec14f4c4b --image adt/ubuntu-questing-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-21 --net-id=net_prod-proposed-migration-s390x -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 178s autopkgtest [22:41:40]: testbed dpkg architecture: s390x 178s autopkgtest [22:41:40]: testbed apt version: 3.1.2 178s autopkgtest [22:41:40]: @@@@@@@@@@@@@@@@@@@@ test bed setup 179s autopkgtest [22:41:41]: testbed release detected to be: None 179s autopkgtest [22:41:41]: updating testbed package index (apt update) 180s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 180s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 180s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 180s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 180s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 180s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [446 kB] 180s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [33.3 kB] 180s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [6836 B] 180s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main s390x Packages [65.7 kB] 181s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted s390x Packages [960 B] 181s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x Packages [372 kB] 181s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse s390x Packages [6576 B] 181s Fetched 1197 kB in 1s (841 kB/s) 181s Reading package lists... 182s autopkgtest [22:41:44]: upgrading testbed (apt dist-upgrade and autopurge) 182s Reading package lists... 183s Building dependency tree... 183s Reading state information... 183s Calculating upgrade... 183s The following packages will be upgraded: 183s bash libproc2-0 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 183s procps 183s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 183s Need to get 7018 kB of archives. 183s After this operation, 244 kB disk space will be freed. 183s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x bash s390x 5.2.37-2ubuntu4 [840 kB] 184s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main s390x libproc2-0 s390x 2:4.0.4-8ubuntu1 [60.2 kB] 184s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main s390x procps s390x 2:4.0.4-8ubuntu1 [724 kB] 184s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12t64 s390x 3.12.10-1 [2509 kB] 185s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12-stdlib s390x 3.12.10-1 [2049 kB] 185s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12-minimal s390x 3.12.10-1 [836 kB] 186s Fetched 7018 kB in 3s (2655 kB/s) 186s (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 ... 82262 files and directories currently installed.) 186s Preparing to unpack .../bash_5.2.37-2ubuntu4_s390x.deb ... 186s Unpacking bash (5.2.37-2ubuntu4) over (5.2.37-2ubuntu1) ... 186s Setting up bash (5.2.37-2ubuntu4) ... 186s Installing new version of config file /etc/bash.bashrc ... 186s update-alternatives: using /usr/share/man/man7/bash-builtins.7.gz to provide /usr/share/man/man7/builtins.7.gz (builtins.7.gz) in auto mode 186s (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 ... 82262 files and directories currently installed.) 186s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_s390x.deb ... 186s Unpacking libproc2-0:s390x (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 186s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_s390x.deb ... 186s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 186s Preparing to unpack .../libpython3.12t64_3.12.10-1_s390x.deb ... 186s Unpacking libpython3.12t64:s390x (3.12.10-1) over (3.12.8-3) ... 186s Preparing to unpack .../libpython3.12-stdlib_3.12.10-1_s390x.deb ... 186s Unpacking libpython3.12-stdlib:s390x (3.12.10-1) over (3.12.8-3) ... 186s Preparing to unpack .../libpython3.12-minimal_3.12.10-1_s390x.deb ... 186s Unpacking libpython3.12-minimal:s390x (3.12.10-1) over (3.12.8-3) ... 186s Setting up libpython3.12-minimal:s390x (3.12.10-1) ... 186s Setting up libproc2-0:s390x (2:4.0.4-8ubuntu1) ... 186s Setting up procps (2:4.0.4-8ubuntu1) ... 186s Setting up libpython3.12-stdlib:s390x (3.12.10-1) ... 186s Setting up libpython3.12t64:s390x (3.12.10-1) ... 186s Processing triggers for install-info (7.1.1-1) ... 187s Processing triggers for libc-bin (2.41-6ubuntu2) ... 187s Processing triggers for systemd (257.6-1ubuntu1) ... 187s Processing triggers for man-db (2.13.1-1) ... 188s Processing triggers for debianutils (5.23.1) ... 188s Reading package lists... 188s Building dependency tree... 188s Reading state information... 188s Solving dependencies... 188s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 189s autopkgtest [22:41:51]: rebooting testbed after setup commands that affected boot 212s autopkgtest [22:42:14]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 13:39:00 UTC 2025 214s autopkgtest [22:42:16]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 219s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (dsc) [2385 B] 219s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (tar) [218 kB] 219s gpgv: Signature made Thu Jun 12 19:04:12 2025 UTC 219s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 219s gpgv: Can't check signature: No public key 219s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_279.dsc: no acceptable signature found 219s autopkgtest [22:42:21]: testing package postgresql-common version 279 220s autopkgtest [22:42:22]: build not needed 220s autopkgtest [22:42:22]: test default-psql: preparing testbed 220s Reading package lists... 221s Building dependency tree... 221s Reading state information... 221s Solving dependencies... 221s The following NEW packages will be installed: 221s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 221s postgresql-17 postgresql-client-17 postgresql-client-common 221s postgresql-common postgresql-common-dev ssl-cert 221s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 221s Need to get 21.5 MB of archives. 221s After this operation, 73.1 MB of additional disk space will be used. 221s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x libjson-perl all 4.10000-1 [81.9 kB] 221s Get:2 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-common all 279 [48.1 kB] 221s Get:3 http://ftpmaster.internal/ubuntu questing/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 221s Get:4 http://ftpmaster.internal/ubuntu questing/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 221s Get:5 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common-dev all 279 [73.6 kB] 221s Get:6 http://ftpmaster.internal/ubuntu questing/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 221s Get:7 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common all 279 [101 kB] 221s Get:8 http://ftpmaster.internal/ubuntu questing/main s390x libpq5 s390x 17.5-1build1 [257 kB] 221s Get:9 http://ftpmaster.internal/ubuntu questing/main s390x libxslt1.1 s390x 1.1.43-0exp1 [163 kB] 221s Get:10 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-17 s390x 17.5-1build1 [2146 kB] 222s Get:11 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-17 s390x 17.5-1build1 [18.5 MB] 223s Get:12 http://ftpmaster.internal/ubuntu questing/main s390x postgresql all 17+279 [16.6 kB] 224s Preconfiguring packages ... 224s /var/cache/debconf/tmp.ci/postgresql.config.RSU8T2: 12: pg_lsclusters: not found 224s Fetched 21.5 MB in 3s (7655 kB/s) 224s Selecting previously unselected package libjson-perl. 224s (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 ... 82263 files and directories currently installed.) 224s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 224s Unpacking libjson-perl (4.10000-1) ... 224s Selecting previously unselected package postgresql-client-common. 224s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 224s Unpacking postgresql-client-common (279) ... 224s Selecting previously unselected package libio-pty-perl. 224s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 224s Unpacking libio-pty-perl (1:1.20-1build3) ... 224s Selecting previously unselected package libipc-run-perl. 224s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 224s Unpacking libipc-run-perl (20231003.0-2) ... 224s Selecting previously unselected package postgresql-common-dev. 224s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 224s Unpacking postgresql-common-dev (279) ... 224s Selecting previously unselected package ssl-cert. 224s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 224s Unpacking ssl-cert (1.1.3ubuntu1) ... 224s Selecting previously unselected package postgresql-common. 224s Preparing to unpack .../06-postgresql-common_279_all.deb ... 224s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 224s Unpacking postgresql-common (279) ... 224s Selecting previously unselected package libpq5:s390x. 224s Preparing to unpack .../07-libpq5_17.5-1build1_s390x.deb ... 224s Unpacking libpq5:s390x (17.5-1build1) ... 224s Selecting previously unselected package libxslt1.1:s390x. 224s Preparing to unpack .../08-libxslt1.1_1.1.43-0exp1_s390x.deb ... 224s Unpacking libxslt1.1:s390x (1.1.43-0exp1) ... 224s Selecting previously unselected package postgresql-client-17. 224s Preparing to unpack .../09-postgresql-client-17_17.5-1build1_s390x.deb ... 224s Unpacking postgresql-client-17 (17.5-1build1) ... 224s Selecting previously unselected package postgresql-17. 224s Preparing to unpack .../10-postgresql-17_17.5-1build1_s390x.deb ... 224s Unpacking postgresql-17 (17.5-1build1) ... 224s Selecting previously unselected package postgresql. 224s Preparing to unpack .../11-postgresql_17+279_all.deb ... 224s Unpacking postgresql (17+279) ... 224s Setting up postgresql-client-common (279) ... 224s Setting up libio-pty-perl (1:1.20-1build3) ... 224s Setting up libpq5:s390x (17.5-1build1) ... 224s Setting up ssl-cert (1.1.3ubuntu1) ... 225s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 225s Setting up libipc-run-perl (20231003.0-2) ... 225s Setting up libjson-perl (4.10000-1) ... 225s Setting up libxslt1.1:s390x (1.1.43-0exp1) ... 225s Setting up postgresql-common-dev (279) ... 225s Setting up postgresql-client-17 (17.5-1build1) ... 225s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 225s Setting up postgresql-common (279) ... 225s Creating config file /etc/postgresql-common/createcluster.conf with new version 226s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 226s Removing obsolete dictionary files: 226s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 226s Setting up postgresql-17 (17.5-1build1) ... 227s Creating new PostgreSQL cluster 17/main ... 227s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 227s The files belonging to this database system will be owned by user "postgres". 227s This user must also own the server process. 227s 227s The database cluster will be initialized with locale "C.UTF-8". 227s The default database encoding has accordingly been set to "UTF8". 227s The default text search configuration will be set to "english". 227s 227s Data page checksums are disabled. 227s 227s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 227s creating subdirectories ... ok 227s selecting dynamic shared memory implementation ... posix 227s selecting default "max_connections" ... 100 227s selecting default "shared_buffers" ... 128MB 227s selecting default time zone ... Etc/UTC 227s creating configuration files ... ok 227s running bootstrap script ... ok 227s performing post-bootstrap initialization ... ok 227s syncing data to disk ... ok 230s Setting up postgresql (17+279) ... 230s Processing triggers for man-db (2.13.1-1) ... 231s Processing triggers for libc-bin (2.41-6ubuntu2) ... 232s autopkgtest [22:42:34]: test default-psql: [----------------------- 232s ************************************************************************** 232s # A new feature in cloud-init identified possible datasources for # 232s # this system as: # 232s # [] # 232s # However, the datasource used was: OpenStack # 232s # # 232s # In the future, cloud-init will only attempt to use datasources that # 232s # are identified or specifically configured. # 232s # For more information see # 232s # https://bugs.launchpad.net/bugs/1669675 # 232s # # 232s # If you are seeing this message, please file a bug against # 232s # cloud-init at # 232s # https://github.com/canonical/cloud-init/issues # 232s # Make sure to include the cloud provider your instance is # 232s # running on. # 232s # # 232s # After you have filed a bug, you can disable this warning by launching # 232s # your instance with the cloud-config below, or putting that content # 232s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 232s # # 232s # #cloud-config # 232s # warnings: # 232s # dsid_missing_source: off # 232s ************************************************************************** 232s 232s Disable the warnings above by: 232s touch /root/.cloud-warnings.skip 232s or 232s touch /var/lib/cloud/instance/warnings/.skip 232s ************************************************************************** 232s # A new feature in cloud-init identified possible datasources for # 232s # this system as: # 232s # [] # 232s # However, the datasource used was: OpenStack # 232s # # 232s # In the future, cloud-init will only attempt to use datasources that # 232s # are identified or specifically configured. # 232s # For more information see # 232s # https://bugs.launchpad.net/bugs/1669675 # 232s # # 232s # If you are seeing this message, please file a bug against # 232s # cloud-init at # 232s # https://github.com/canonical/cloud-init/issues # 232s # Make sure to include the cloud provider your instance is # 232s # running on. # 232s # # 232s # After you have filed a bug, you can disable this warning by launching # 232s # your instance with the cloud-config below, or putting that content # 232s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 232s # # 232s # #cloud-config # 232s # warnings: # 232s # dsid_missing_source: off # 232s ************************************************************************** 232s 232s Disable the warnings above by: 232s touch /var/lib/postgresql/.cloud-warnings.skip 232s or 232s touch /var/lib/cloud/instance/warnings/.skip 233s autopkgtest [22:42:35]: test default-psql: -----------------------] 233s default-psql FAIL stderr: ************************************************************************** 233s autopkgtest [22:42:35]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 233s autopkgtest [22:42:35]: test default-psql: - - - - - - - - - - stderr - - - - - - - - - - 233s ************************************************************************** 233s # A new feature in cloud-init identified possible datasources for # 233s # this system as: # 233s # [] # 233s # However, the datasource used was: OpenStack # 233s # # 233s # In the future, cloud-init will only attempt to use datasources that # 233s # are identified or specifically configured. # 233s # For more information see # 233s # https://bugs.launchpad.net/bugs/1669675 # 233s # # 233s # If you are seeing this message, please file a bug against # 233s # cloud-init at # 233s # https://github.com/canonical/cloud-init/issues # 233s # Make sure to include the cloud provider your instance is # 233s # running on. # 233s # # 233s # After you have filed a bug, you can disable this warning by launching # 233s # your instance with the cloud-config below, or putting that content # 233s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 233s # # 233s # #cloud-config # 233s # warnings: # 233s # dsid_missing_source: off # 233s ************************************************************************** 233s 233s Disable the warnings above by: 233s touch /var/lib/postgresql/.cloud-warnings.skip 233s or 233s touch /var/lib/cloud/instance/warnings/.skip 234s autopkgtest [22:42:36]: test run-testsuite: preparing testbed 363s autopkgtest [22:44:45]: testbed dpkg architecture: s390x 363s autopkgtest [22:44:45]: testbed apt version: 3.1.2 363s autopkgtest [22:44:45]: @@@@@@@@@@@@@@@@@@@@ test bed setup 363s autopkgtest [22:44:45]: testbed release detected to be: questing 364s autopkgtest [22:44:46]: updating testbed package index (apt update) 364s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 365s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 365s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 365s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 365s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [6836 B] 365s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [446 kB] 365s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [33.3 kB] 365s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 365s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main s390x Packages [65.7 kB] 365s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted s390x Packages [960 B] 365s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x Packages [372 kB] 365s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse s390x Packages [6576 B] 365s Fetched 1197 kB in 1s (1410 kB/s) 366s Reading package lists... 366s autopkgtest [22:44:48]: upgrading testbed (apt dist-upgrade and autopurge) 367s Reading package lists... 367s Building dependency tree... 367s Reading state information... 367s Calculating upgrade... 367s The following packages will be upgraded: 367s bash libproc2-0 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 367s procps 367s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 367s Need to get 7018 kB of archives. 367s After this operation, 244 kB disk space will be freed. 367s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x bash s390x 5.2.37-2ubuntu4 [840 kB] 367s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main s390x libproc2-0 s390x 2:4.0.4-8ubuntu1 [60.2 kB] 367s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main s390x procps s390x 2:4.0.4-8ubuntu1 [724 kB] 367s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12t64 s390x 3.12.10-1 [2509 kB] 368s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12-stdlib s390x 3.12.10-1 [2049 kB] 368s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x libpython3.12-minimal s390x 3.12.10-1 [836 kB] 368s Fetched 7018 kB in 1s (8962 kB/s) 368s (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 ... 82262 files and directories currently installed.) 368s Preparing to unpack .../bash_5.2.37-2ubuntu4_s390x.deb ... 368s Unpacking bash (5.2.37-2ubuntu4) over (5.2.37-2ubuntu1) ... 368s Setting up bash (5.2.37-2ubuntu4) ... 368s Installing new version of config file /etc/bash.bashrc ... 368s update-alternatives: using /usr/share/man/man7/bash-builtins.7.gz to provide /usr/share/man/man7/builtins.7.gz (builtins.7.gz) in auto mode 368s (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 ... 82262 files and directories currently installed.) 368s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_s390x.deb ... 368s Unpacking libproc2-0:s390x (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 368s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_s390x.deb ... 368s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 368s Preparing to unpack .../libpython3.12t64_3.12.10-1_s390x.deb ... 368s Unpacking libpython3.12t64:s390x (3.12.10-1) over (3.12.8-3) ... 368s Preparing to unpack .../libpython3.12-stdlib_3.12.10-1_s390x.deb ... 368s Unpacking libpython3.12-stdlib:s390x (3.12.10-1) over (3.12.8-3) ... 368s Preparing to unpack .../libpython3.12-minimal_3.12.10-1_s390x.deb ... 369s Unpacking libpython3.12-minimal:s390x (3.12.10-1) over (3.12.8-3) ... 369s Setting up libpython3.12-minimal:s390x (3.12.10-1) ... 369s Setting up libproc2-0:s390x (2:4.0.4-8ubuntu1) ... 369s Setting up procps (2:4.0.4-8ubuntu1) ... 369s Setting up libpython3.12-stdlib:s390x (3.12.10-1) ... 369s Setting up libpython3.12t64:s390x (3.12.10-1) ... 369s Processing triggers for install-info (7.1.1-1) ... 369s Processing triggers for libc-bin (2.41-6ubuntu2) ... 369s Processing triggers for systemd (257.6-1ubuntu1) ... 369s Processing triggers for man-db (2.13.1-1) ... 370s Processing triggers for debianutils (5.23.1) ... 370s Reading package lists... 371s Building dependency tree... 371s Reading state information... 371s Solving dependencies... 371s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 371s autopkgtest [22:44:53]: rebooting testbed after setup commands that affected boot 375s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 393s Reading package lists... 393s Building dependency tree... 393s Reading state information... 393s Solving dependencies... 393s The following NEW packages will be installed: 393s autoconf automake autopoint autotools-dev build-essential clang-20 cpp 393s cpp-14 cpp-14-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 393s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 393s fakeroot g++ g++-14 g++-14-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-14 393s gcc-14-base gcc-14-s390x-linux-gnu gcc-s390x-linux-gnu gettext 393s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libcc1-0 393s libclang-common-20-dev libclang1-20 libdebhelper-perl libecpg-compat3 393s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 393s libgc1 libgcc-14-dev libgomp1 libio-pty-perl libipc-run-perl libisl23 393s libitm1 libjson-perl liblzma-dev libmpc3 libncurses-dev libobjc-14-dev 393s libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libssl-dev libstdc++-14-dev 393s libtcl8.6 libtool libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 393s llvm-20-linker-tools llvm-20-runtime llvm-20-tools locales-all m4 po-debconf 394s postgresql-17 postgresql-all postgresql-client-17 postgresql-client-common 394s postgresql-common postgresql-common-dev postgresql-doc postgresql-doc-17 394s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 394s postgresql-server-dev-17 postgresql-server-dev-all ssl-cert zlib1g-dev 394s 0 upgraded, 89 newly installed, 0 to remove and 0 not upgraded. 394s Need to get 180 MB of archives. 394s After this operation, 1108 MB of additional disk space will be used. 394s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x libjson-perl all 4.10000-1 [81.9 kB] 394s Get:2 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-common all 279 [48.1 kB] 394s Get:3 http://ftpmaster.internal/ubuntu questing/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 394s Get:4 http://ftpmaster.internal/ubuntu questing/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 394s Get:5 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common-dev all 279 [73.6 kB] 394s Get:6 http://ftpmaster.internal/ubuntu questing/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 394s Get:7 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common all 279 [101 kB] 394s Get:8 http://ftpmaster.internal/ubuntu questing/main s390x m4 s390x 1.4.19-8 [259 kB] 394s Get:9 http://ftpmaster.internal/ubuntu questing/main s390x autoconf all 2.72-3.1ubuntu1 [384 kB] 394s Get:10 http://ftpmaster.internal/ubuntu questing/main s390x autotools-dev all 20240727.1 [43.4 kB] 394s Get:11 http://ftpmaster.internal/ubuntu questing/main s390x automake all 1:1.17-4ubuntu1 [572 kB] 394s Get:12 http://ftpmaster.internal/ubuntu questing/main s390x autopoint all 0.23.1-2build1 [619 kB] 394s Get:13 http://ftpmaster.internal/ubuntu questing/main s390x gcc-14-base s390x 14.3.0-1ubuntu1 [55.8 kB] 394s Get:14 http://ftpmaster.internal/ubuntu questing/main s390x libisl23 s390x 0.27-1 [704 kB] 394s Get:15 http://ftpmaster.internal/ubuntu questing/main s390x libmpc3 s390x 1.3.1-1build2 [57.8 kB] 394s Get:16 http://ftpmaster.internal/ubuntu questing/main s390x cpp-14-s390x-linux-gnu s390x 14.3.0-1ubuntu1 [9568 kB] 394s Get:17 http://ftpmaster.internal/ubuntu questing/main s390x cpp-14 s390x 14.3.0-1ubuntu1 [1028 B] 394s Get:18 http://ftpmaster.internal/ubuntu questing/main s390x cpp-s390x-linux-gnu s390x 4:14.2.0-1ubuntu1 [5556 B] 394s Get:19 http://ftpmaster.internal/ubuntu questing/main s390x cpp s390x 4:14.2.0-1ubuntu1 [22.4 kB] 394s Get:20 http://ftpmaster.internal/ubuntu questing/main s390x libcc1-0 s390x 15.1.0-5ubuntu1 [49.8 kB] 394s Get:21 http://ftpmaster.internal/ubuntu questing/main s390x libgomp1 s390x 15.1.0-5ubuntu1 [154 kB] 394s Get:22 http://ftpmaster.internal/ubuntu questing/main s390x libitm1 s390x 15.1.0-5ubuntu1 [31.1 kB] 394s Get:23 http://ftpmaster.internal/ubuntu questing/main s390x libasan8 s390x 15.1.0-5ubuntu1 [2970 kB] 394s Get:24 http://ftpmaster.internal/ubuntu questing/main s390x libubsan1 s390x 15.1.0-5ubuntu1 [1210 kB] 395s Get:25 http://ftpmaster.internal/ubuntu questing/main s390x libgcc-14-dev s390x 14.3.0-1ubuntu1 [1036 kB] 395s Get:26 http://ftpmaster.internal/ubuntu questing/main s390x gcc-14-s390x-linux-gnu s390x 14.3.0-1ubuntu1 [18.7 MB] 395s Get:27 http://ftpmaster.internal/ubuntu questing/main s390x gcc-14 s390x 14.3.0-1ubuntu1 [538 kB] 395s Get:28 http://ftpmaster.internal/ubuntu questing/main s390x gcc-s390x-linux-gnu s390x 4:14.2.0-1ubuntu1 [1204 B] 395s Get:29 http://ftpmaster.internal/ubuntu questing/main s390x gcc s390x 4:14.2.0-1ubuntu1 [5004 B] 395s Get:30 http://ftpmaster.internal/ubuntu questing/main s390x libstdc++-14-dev s390x 14.3.0-1ubuntu1 [2935 kB] 395s Get:31 http://ftpmaster.internal/ubuntu questing/main s390x g++-14-s390x-linux-gnu s390x 14.3.0-1ubuntu1 [11.0 MB] 395s Get:32 http://ftpmaster.internal/ubuntu questing/main s390x g++-14 s390x 14.3.0-1ubuntu1 [27.4 kB] 395s Get:33 http://ftpmaster.internal/ubuntu questing/main s390x g++-s390x-linux-gnu s390x 4:14.2.0-1ubuntu1 [956 B] 395s Get:34 http://ftpmaster.internal/ubuntu questing/main s390x g++ s390x 4:14.2.0-1ubuntu1 [1080 B] 395s Get:35 http://ftpmaster.internal/ubuntu questing/main s390x build-essential s390x 12.12ubuntu1 [5090 B] 395s Get:36 http://ftpmaster.internal/ubuntu questing/main s390x libgc1 s390x 1:8.2.8-1 [93.7 kB] 395s Get:37 http://ftpmaster.internal/ubuntu questing/universe s390x libobjc4 s390x 15.1.0-5ubuntu1 [49.8 kB] 395s Get:38 http://ftpmaster.internal/ubuntu questing/universe s390x libobjc-14-dev s390x 14.3.0-1ubuntu1 [193 kB] 395s Get:39 http://ftpmaster.internal/ubuntu questing/universe s390x libclang-common-20-dev s390x 1:20.1.6-0ubuntu1 [775 kB] 395s Get:40 http://ftpmaster.internal/ubuntu questing/universe s390x llvm-20-linker-tools s390x 1:20.1.6-0ubuntu1 [1252 kB] 395s Get:41 http://ftpmaster.internal/ubuntu questing/universe s390x libclang1-20 s390x 1:20.1.6-0ubuntu1 [8447 kB] 396s Get:42 http://ftpmaster.internal/ubuntu questing/universe s390x clang-20 s390x 1:20.1.6-0ubuntu1 [78.0 kB] 396s Get:43 http://ftpmaster.internal/ubuntu questing/main s390x libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 396s Get:44 http://ftpmaster.internal/ubuntu questing/main s390x libtool all 2.5.4-4 [168 kB] 396s Get:45 http://ftpmaster.internal/ubuntu questing/main s390x dh-autoreconf all 20 [16.1 kB] 396s Get:46 http://ftpmaster.internal/ubuntu questing/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 396s Get:47 http://ftpmaster.internal/ubuntu questing/main s390x libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 396s Get:48 http://ftpmaster.internal/ubuntu questing/main s390x dh-strip-nondeterminism all 1.14.1-2 [5064 B] 396s Get:49 http://ftpmaster.internal/ubuntu questing/main s390x debugedit s390x 1:5.1-2 [50.1 kB] 396s Get:50 http://ftpmaster.internal/ubuntu questing/main s390x dwz s390x 0.15-1build6 [122 kB] 396s Get:51 http://ftpmaster.internal/ubuntu questing/main s390x gettext s390x 0.23.1-2build1 [1518 kB] 396s Get:52 http://ftpmaster.internal/ubuntu questing/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 396s Get:53 http://ftpmaster.internal/ubuntu questing/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 396s Get:54 http://ftpmaster.internal/ubuntu questing/main s390x debhelper all 13.24.2ubuntu1 [896 kB] 396s Get:55 http://ftpmaster.internal/ubuntu questing/main s390x emacsen-common all 3.0.8 [13.9 kB] 396s Get:56 http://ftpmaster.internal/ubuntu questing/main s390x dictionaries-common all 1.30.10 [178 kB] 396s Get:57 http://ftpmaster.internal/ubuntu questing/main s390x libfakeroot s390x 1.37.1.2-1 [32.6 kB] 396s Get:58 http://ftpmaster.internal/ubuntu questing/main s390x fakeroot s390x 1.37.1.2-1 [68.0 kB] 396s Get:59 http://ftpmaster.internal/ubuntu questing/main s390x hunspell-en-us all 1:2020.12.07-4 [585 kB] 396s Get:60 http://ftpmaster.internal/ubuntu questing/main s390x libpgtypes3 s390x 17.5-1build1 [50.5 kB] 396s Get:61 http://ftpmaster.internal/ubuntu questing/main s390x libpq5 s390x 17.5-1build1 [257 kB] 396s Get:62 http://ftpmaster.internal/ubuntu questing/main s390x libecpg6 s390x 17.5-1build1 [67.2 kB] 396s Get:63 http://ftpmaster.internal/ubuntu questing/main s390x libecpg-compat3 s390x 17.5-1build1 [17.3 kB] 396s Get:64 http://ftpmaster.internal/ubuntu questing/main s390x libssl-dev s390x 3.5.0-2ubuntu1 [2595 kB] 396s Get:65 http://ftpmaster.internal/ubuntu questing/main s390x libpq-dev s390x 17.5-1build1 [163 kB] 396s Get:66 http://ftpmaster.internal/ubuntu questing/main s390x libecpg-dev s390x 17.5-1build1 [340 kB] 396s Get:67 http://ftpmaster.internal/ubuntu questing/main s390x libncurses-dev s390x 6.5+20250216-2 [407 kB] 396s Get:68 http://ftpmaster.internal/ubuntu questing/main s390x libtcl8.6 s390x 8.6.16+dfsg-1 [1034 kB] 396s Get:69 http://ftpmaster.internal/ubuntu questing/main s390x liblzma-dev s390x 5.8.1-1build1 [184 kB] 396s Get:70 http://ftpmaster.internal/ubuntu questing/main s390x zlib1g-dev s390x 1:1.3.dfsg+really1.3.1-1ubuntu1 [898 kB] 396s Get:71 http://ftpmaster.internal/ubuntu questing/main s390x libxml2-dev s390x 2.14.3+dfsg-0exp3 [68.6 kB] 396s Get:72 http://ftpmaster.internal/ubuntu questing/main s390x libxslt1.1 s390x 1.1.43-0exp1 [163 kB] 396s Get:73 http://ftpmaster.internal/ubuntu questing/universe s390x llvm-20-runtime s390x 1:20.1.6-0ubuntu1 [565 kB] 396s Get:74 http://ftpmaster.internal/ubuntu questing/universe s390x libpfm4 s390x 4.13.0+git99-gc5587f9-1 [38.1 kB] 396s Get:75 http://ftpmaster.internal/ubuntu questing/universe s390x llvm-20 s390x 1:20.1.6-0ubuntu1 [20.2 MB] 397s Get:76 http://ftpmaster.internal/ubuntu questing/main s390x libffi-dev s390x 3.4.8-2 [59.0 kB] 397s Get:77 http://ftpmaster.internal/ubuntu questing/universe s390x llvm-20-tools s390x 1:20.1.6-0ubuntu1 [519 kB] 397s Get:78 http://ftpmaster.internal/ubuntu questing/universe s390x llvm-20-dev s390x 1:20.1.6-0ubuntu1 [49.6 MB] 398s Get:79 http://ftpmaster.internal/ubuntu questing/universe s390x locales-all s390x 2.41-6ubuntu2 [11.5 MB] 399s Get:80 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-17 s390x 17.5-1build1 [2146 kB] 399s Get:81 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-17 s390x 17.5-1build1 [18.5 MB] 399s Get:82 http://ftpmaster.internal/ubuntu questing/universe s390x postgresql-server-dev-17 s390x 17.5-1build1 [1402 kB] 399s Get:83 http://ftpmaster.internal/ubuntu questing/universe s390x postgresql-server-dev-all all 279 [1626 B] 399s Get:84 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-plperl-17 s390x 17.5-1build1 [92.8 kB] 399s Get:85 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-plpython3-17 s390x 17.5-1build1 [118 kB] 399s Get:86 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-pltcl-17 s390x 17.5-1build1 [45.7 kB] 399s Get:87 http://ftpmaster.internal/ubuntu questing/universe s390x postgresql-all all 279 [1706 B] 399s Get:88 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-doc-17 all 17.5-1build1 [2137 kB] 399s Get:89 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-doc all 17+279 [13.8 kB] 400s Preconfiguring packages ... 400s Fetched 180 MB in 6s (31.5 MB/s) 400s Selecting previously unselected package libjson-perl. 400s (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 ... 82263 files and directories currently installed.) 400s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 400s Unpacking libjson-perl (4.10000-1) ... 400s Selecting previously unselected package postgresql-client-common. 400s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 400s Unpacking postgresql-client-common (279) ... 400s Selecting previously unselected package libio-pty-perl. 400s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 400s Unpacking libio-pty-perl (1:1.20-1build3) ... 400s Selecting previously unselected package libipc-run-perl. 400s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 400s Unpacking libipc-run-perl (20231003.0-2) ... 400s Selecting previously unselected package postgresql-common-dev. 400s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 400s Unpacking postgresql-common-dev (279) ... 400s Selecting previously unselected package ssl-cert. 400s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 400s Unpacking ssl-cert (1.1.3ubuntu1) ... 400s Selecting previously unselected package postgresql-common. 400s Preparing to unpack .../06-postgresql-common_279_all.deb ... 400s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 400s Unpacking postgresql-common (279) ... 400s Selecting previously unselected package m4. 400s Preparing to unpack .../07-m4_1.4.19-8_s390x.deb ... 400s Unpacking m4 (1.4.19-8) ... 400s Selecting previously unselected package autoconf. 400s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 400s Unpacking autoconf (2.72-3.1ubuntu1) ... 400s Selecting previously unselected package autotools-dev. 400s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 400s Unpacking autotools-dev (20240727.1) ... 400s Selecting previously unselected package automake. 400s Preparing to unpack .../10-automake_1%3a1.17-4ubuntu1_all.deb ... 400s Unpacking automake (1:1.17-4ubuntu1) ... 400s Selecting previously unselected package autopoint. 400s Preparing to unpack .../11-autopoint_0.23.1-2build1_all.deb ... 400s Unpacking autopoint (0.23.1-2build1) ... 400s Selecting previously unselected package gcc-14-base:s390x. 400s Preparing to unpack .../12-gcc-14-base_14.3.0-1ubuntu1_s390x.deb ... 400s Unpacking gcc-14-base:s390x (14.3.0-1ubuntu1) ... 400s Selecting previously unselected package libisl23:s390x. 400s Preparing to unpack .../13-libisl23_0.27-1_s390x.deb ... 400s Unpacking libisl23:s390x (0.27-1) ... 400s Selecting previously unselected package libmpc3:s390x. 400s Preparing to unpack .../14-libmpc3_1.3.1-1build2_s390x.deb ... 400s Unpacking libmpc3:s390x (1.3.1-1build2) ... 400s Selecting previously unselected package cpp-14-s390x-linux-gnu. 400s Preparing to unpack .../15-cpp-14-s390x-linux-gnu_14.3.0-1ubuntu1_s390x.deb ... 400s Unpacking cpp-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 400s Selecting previously unselected package cpp-14. 400s Preparing to unpack .../16-cpp-14_14.3.0-1ubuntu1_s390x.deb ... 400s Unpacking cpp-14 (14.3.0-1ubuntu1) ... 400s Selecting previously unselected package cpp-s390x-linux-gnu. 400s Preparing to unpack .../17-cpp-s390x-linux-gnu_4%3a14.2.0-1ubuntu1_s390x.deb ... 400s Unpacking cpp-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 400s Selecting previously unselected package cpp. 400s Preparing to unpack .../18-cpp_4%3a14.2.0-1ubuntu1_s390x.deb ... 400s Unpacking cpp (4:14.2.0-1ubuntu1) ... 400s Selecting previously unselected package libcc1-0:s390x. 400s Preparing to unpack .../19-libcc1-0_15.1.0-5ubuntu1_s390x.deb ... 400s Unpacking libcc1-0:s390x (15.1.0-5ubuntu1) ... 400s Selecting previously unselected package libgomp1:s390x. 400s Preparing to unpack .../20-libgomp1_15.1.0-5ubuntu1_s390x.deb ... 400s Unpacking libgomp1:s390x (15.1.0-5ubuntu1) ... 400s Selecting previously unselected package libitm1:s390x. 400s Preparing to unpack .../21-libitm1_15.1.0-5ubuntu1_s390x.deb ... 400s Unpacking libitm1:s390x (15.1.0-5ubuntu1) ... 400s Selecting previously unselected package libasan8:s390x. 400s Preparing to unpack .../22-libasan8_15.1.0-5ubuntu1_s390x.deb ... 400s Unpacking libasan8:s390x (15.1.0-5ubuntu1) ... 400s Selecting previously unselected package libubsan1:s390x. 400s Preparing to unpack .../23-libubsan1_15.1.0-5ubuntu1_s390x.deb ... 400s Unpacking libubsan1:s390x (15.1.0-5ubuntu1) ... 400s Selecting previously unselected package libgcc-14-dev:s390x. 400s Preparing to unpack .../24-libgcc-14-dev_14.3.0-1ubuntu1_s390x.deb ... 400s Unpacking libgcc-14-dev:s390x (14.3.0-1ubuntu1) ... 400s Selecting previously unselected package gcc-14-s390x-linux-gnu. 400s Preparing to unpack .../25-gcc-14-s390x-linux-gnu_14.3.0-1ubuntu1_s390x.deb ... 400s Unpacking gcc-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package gcc-14. 401s Preparing to unpack .../26-gcc-14_14.3.0-1ubuntu1_s390x.deb ... 401s Unpacking gcc-14 (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package gcc-s390x-linux-gnu. 401s Preparing to unpack .../27-gcc-s390x-linux-gnu_4%3a14.2.0-1ubuntu1_s390x.deb ... 401s Unpacking gcc-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 401s Selecting previously unselected package gcc. 401s Preparing to unpack .../28-gcc_4%3a14.2.0-1ubuntu1_s390x.deb ... 401s Unpacking gcc (4:14.2.0-1ubuntu1) ... 401s Selecting previously unselected package libstdc++-14-dev:s390x. 401s Preparing to unpack .../29-libstdc++-14-dev_14.3.0-1ubuntu1_s390x.deb ... 401s Unpacking libstdc++-14-dev:s390x (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package g++-14-s390x-linux-gnu. 401s Preparing to unpack .../30-g++-14-s390x-linux-gnu_14.3.0-1ubuntu1_s390x.deb ... 401s Unpacking g++-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package g++-14. 401s Preparing to unpack .../31-g++-14_14.3.0-1ubuntu1_s390x.deb ... 401s Unpacking g++-14 (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package g++-s390x-linux-gnu. 401s Preparing to unpack .../32-g++-s390x-linux-gnu_4%3a14.2.0-1ubuntu1_s390x.deb ... 401s Unpacking g++-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 401s Selecting previously unselected package g++. 401s Preparing to unpack .../33-g++_4%3a14.2.0-1ubuntu1_s390x.deb ... 401s Unpacking g++ (4:14.2.0-1ubuntu1) ... 401s Selecting previously unselected package build-essential. 401s Preparing to unpack .../34-build-essential_12.12ubuntu1_s390x.deb ... 401s Unpacking build-essential (12.12ubuntu1) ... 401s Selecting previously unselected package libgc1:s390x. 401s Preparing to unpack .../35-libgc1_1%3a8.2.8-1_s390x.deb ... 401s Unpacking libgc1:s390x (1:8.2.8-1) ... 401s Selecting previously unselected package libobjc4:s390x. 401s Preparing to unpack .../36-libobjc4_15.1.0-5ubuntu1_s390x.deb ... 401s Unpacking libobjc4:s390x (15.1.0-5ubuntu1) ... 401s Selecting previously unselected package libobjc-14-dev:s390x. 401s Preparing to unpack .../37-libobjc-14-dev_14.3.0-1ubuntu1_s390x.deb ... 401s Unpacking libobjc-14-dev:s390x (14.3.0-1ubuntu1) ... 401s Selecting previously unselected package libclang-common-20-dev:s390x. 401s Preparing to unpack .../38-libclang-common-20-dev_1%3a20.1.6-0ubuntu1_s390x.deb ... 401s Unpacking libclang-common-20-dev:s390x (1:20.1.6-0ubuntu1) ... 401s Selecting previously unselected package llvm-20-linker-tools. 401s Preparing to unpack .../39-llvm-20-linker-tools_1%3a20.1.6-0ubuntu1_s390x.deb ... 401s Unpacking llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 401s Selecting previously unselected package libclang1-20. 401s Preparing to unpack .../40-libclang1-20_1%3a20.1.6-0ubuntu1_s390x.deb ... 401s Unpacking libclang1-20 (1:20.1.6-0ubuntu1) ... 401s Selecting previously unselected package clang-20. 401s Preparing to unpack .../41-clang-20_1%3a20.1.6-0ubuntu1_s390x.deb ... 401s Unpacking clang-20 (1:20.1.6-0ubuntu1) ... 401s Selecting previously unselected package libdebhelper-perl. 401s Preparing to unpack .../42-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 401s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 401s Selecting previously unselected package libtool. 401s Preparing to unpack .../43-libtool_2.5.4-4_all.deb ... 401s Unpacking libtool (2.5.4-4) ... 401s Selecting previously unselected package dh-autoreconf. 401s Preparing to unpack .../44-dh-autoreconf_20_all.deb ... 401s Unpacking dh-autoreconf (20) ... 401s Selecting previously unselected package libarchive-zip-perl. 401s Preparing to unpack .../45-libarchive-zip-perl_1.68-1_all.deb ... 401s Unpacking libarchive-zip-perl (1.68-1) ... 401s Selecting previously unselected package libfile-stripnondeterminism-perl. 401s Preparing to unpack .../46-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 401s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 401s Selecting previously unselected package dh-strip-nondeterminism. 401s Preparing to unpack .../47-dh-strip-nondeterminism_1.14.1-2_all.deb ... 401s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 401s Selecting previously unselected package debugedit. 401s Preparing to unpack .../48-debugedit_1%3a5.1-2_s390x.deb ... 401s Unpacking debugedit (1:5.1-2) ... 401s Selecting previously unselected package dwz. 401s Preparing to unpack .../49-dwz_0.15-1build6_s390x.deb ... 401s Unpacking dwz (0.15-1build6) ... 401s Selecting previously unselected package gettext. 401s Preparing to unpack .../50-gettext_0.23.1-2build1_s390x.deb ... 401s Unpacking gettext (0.23.1-2build1) ... 401s Selecting previously unselected package intltool-debian. 401s Preparing to unpack .../51-intltool-debian_0.35.0+20060710.6_all.deb ... 401s Unpacking intltool-debian (0.35.0+20060710.6) ... 401s Selecting previously unselected package po-debconf. 401s Preparing to unpack .../52-po-debconf_1.0.21+nmu1_all.deb ... 401s Unpacking po-debconf (1.0.21+nmu1) ... 401s Selecting previously unselected package debhelper. 401s Preparing to unpack .../53-debhelper_13.24.2ubuntu1_all.deb ... 401s Unpacking debhelper (13.24.2ubuntu1) ... 401s Selecting previously unselected package emacsen-common. 401s Preparing to unpack .../54-emacsen-common_3.0.8_all.deb ... 401s Unpacking emacsen-common (3.0.8) ... 401s Selecting previously unselected package dictionaries-common. 401s Preparing to unpack .../55-dictionaries-common_1.30.10_all.deb ... 401s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 401s Unpacking dictionaries-common (1.30.10) ... 401s Selecting previously unselected package libfakeroot:s390x. 401s Preparing to unpack .../56-libfakeroot_1.37.1.2-1_s390x.deb ... 401s Unpacking libfakeroot:s390x (1.37.1.2-1) ... 401s Selecting previously unselected package fakeroot. 401s Preparing to unpack .../57-fakeroot_1.37.1.2-1_s390x.deb ... 401s Unpacking fakeroot (1.37.1.2-1) ... 401s Selecting previously unselected package hunspell-en-us. 401s Preparing to unpack .../58-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 401s Unpacking hunspell-en-us (1:2020.12.07-4) ... 401s Selecting previously unselected package libpgtypes3:s390x. 401s Preparing to unpack .../59-libpgtypes3_17.5-1build1_s390x.deb ... 401s Unpacking libpgtypes3:s390x (17.5-1build1) ... 401s Selecting previously unselected package libpq5:s390x. 401s Preparing to unpack .../60-libpq5_17.5-1build1_s390x.deb ... 401s Unpacking libpq5:s390x (17.5-1build1) ... 401s Selecting previously unselected package libecpg6:s390x. 401s Preparing to unpack .../61-libecpg6_17.5-1build1_s390x.deb ... 401s Unpacking libecpg6:s390x (17.5-1build1) ... 402s Selecting previously unselected package libecpg-compat3:s390x. 402s Preparing to unpack .../62-libecpg-compat3_17.5-1build1_s390x.deb ... 402s Unpacking libecpg-compat3:s390x (17.5-1build1) ... 402s Selecting previously unselected package libssl-dev:s390x. 402s Preparing to unpack .../63-libssl-dev_3.5.0-2ubuntu1_s390x.deb ... 402s Unpacking libssl-dev:s390x (3.5.0-2ubuntu1) ... 402s Selecting previously unselected package libpq-dev. 402s Preparing to unpack .../64-libpq-dev_17.5-1build1_s390x.deb ... 402s Unpacking libpq-dev (17.5-1build1) ... 402s Selecting previously unselected package libecpg-dev. 402s Preparing to unpack .../65-libecpg-dev_17.5-1build1_s390x.deb ... 402s Unpacking libecpg-dev (17.5-1build1) ... 402s Selecting previously unselected package libncurses-dev:s390x. 402s Preparing to unpack .../66-libncurses-dev_6.5+20250216-2_s390x.deb ... 402s Unpacking libncurses-dev:s390x (6.5+20250216-2) ... 402s Selecting previously unselected package libtcl8.6:s390x. 402s Preparing to unpack .../67-libtcl8.6_8.6.16+dfsg-1_s390x.deb ... 402s Unpacking libtcl8.6:s390x (8.6.16+dfsg-1) ... 402s Selecting previously unselected package liblzma-dev:s390x. 402s Preparing to unpack .../68-liblzma-dev_5.8.1-1build1_s390x.deb ... 402s Unpacking liblzma-dev:s390x (5.8.1-1build1) ... 402s Selecting previously unselected package zlib1g-dev:s390x. 402s Preparing to unpack .../69-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_s390x.deb ... 402s Unpacking zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 402s Selecting previously unselected package libxml2-dev:s390x. 402s Preparing to unpack .../70-libxml2-dev_2.14.3+dfsg-0exp3_s390x.deb ... 402s Unpacking libxml2-dev:s390x (2.14.3+dfsg-0exp3) ... 402s Selecting previously unselected package libxslt1.1:s390x. 402s Preparing to unpack .../71-libxslt1.1_1.1.43-0exp1_s390x.deb ... 402s Unpacking libxslt1.1:s390x (1.1.43-0exp1) ... 402s Selecting previously unselected package llvm-20-runtime. 402s Preparing to unpack .../72-llvm-20-runtime_1%3a20.1.6-0ubuntu1_s390x.deb ... 402s Unpacking llvm-20-runtime (1:20.1.6-0ubuntu1) ... 402s Selecting previously unselected package libpfm4:s390x. 402s Preparing to unpack .../73-libpfm4_4.13.0+git99-gc5587f9-1_s390x.deb ... 402s Unpacking libpfm4:s390x (4.13.0+git99-gc5587f9-1) ... 402s Selecting previously unselected package llvm-20. 402s Preparing to unpack .../74-llvm-20_1%3a20.1.6-0ubuntu1_s390x.deb ... 402s Unpacking llvm-20 (1:20.1.6-0ubuntu1) ... 402s Selecting previously unselected package libffi-dev:s390x. 402s Preparing to unpack .../75-libffi-dev_3.4.8-2_s390x.deb ... 402s Unpacking libffi-dev:s390x (3.4.8-2) ... 402s Selecting previously unselected package llvm-20-tools. 402s Preparing to unpack .../76-llvm-20-tools_1%3a20.1.6-0ubuntu1_s390x.deb ... 402s Unpacking llvm-20-tools (1:20.1.6-0ubuntu1) ... 402s Selecting previously unselected package llvm-20-dev. 402s Preparing to unpack .../77-llvm-20-dev_1%3a20.1.6-0ubuntu1_s390x.deb ... 402s Unpacking llvm-20-dev (1:20.1.6-0ubuntu1) ... 404s Selecting previously unselected package locales-all. 404s Preparing to unpack .../78-locales-all_2.41-6ubuntu2_s390x.deb ... 404s Unpacking locales-all (2.41-6ubuntu2) ... 405s Selecting previously unselected package postgresql-client-17. 405s Preparing to unpack .../79-postgresql-client-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-client-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-17. 405s Preparing to unpack .../80-postgresql-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-server-dev-17. 405s Preparing to unpack .../81-postgresql-server-dev-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-server-dev-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-server-dev-all. 405s Preparing to unpack .../82-postgresql-server-dev-all_279_all.deb ... 405s Unpacking postgresql-server-dev-all (279) ... 405s Selecting previously unselected package postgresql-plperl-17. 405s Preparing to unpack .../83-postgresql-plperl-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-plperl-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-plpython3-17. 405s Preparing to unpack .../84-postgresql-plpython3-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-plpython3-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-pltcl-17. 405s Preparing to unpack .../85-postgresql-pltcl-17_17.5-1build1_s390x.deb ... 405s Unpacking postgresql-pltcl-17 (17.5-1build1) ... 405s Selecting previously unselected package postgresql-all. 405s Preparing to unpack .../86-postgresql-all_279_all.deb ... 405s Unpacking postgresql-all (279) ... 405s Selecting previously unselected package postgresql-doc-17. 405s Preparing to unpack .../87-postgresql-doc-17_17.5-1build1_all.deb ... 405s Unpacking postgresql-doc-17 (17.5-1build1) ... 406s Selecting previously unselected package postgresql-doc. 406s Preparing to unpack .../88-postgresql-doc_17+279_all.deb ... 406s Unpacking postgresql-doc (17+279) ... 406s Setting up postgresql-client-common (279) ... 406s Setting up libpgtypes3:s390x (17.5-1build1) ... 406s Setting up libncurses-dev:s390x (6.5+20250216-2) ... 406s Setting up libio-pty-perl (1:1.20-1build3) ... 406s Setting up gcc-14-base:s390x (14.3.0-1ubuntu1) ... 406s Setting up libarchive-zip-perl (1.68-1) ... 406s Setting up libclang-common-20-dev:s390x (1:20.1.6-0ubuntu1) ... 406s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 406s Setting up postgresql-doc-17 (17.5-1build1) ... 406s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 406s Setting up libpq5:s390x (17.5-1build1) ... 406s Setting up m4 (1.4.19-8) ... 406s Setting up llvm-20-runtime (1:20.1.6-0ubuntu1) ... 406s Setting up libgomp1:s390x (15.1.0-5ubuntu1) ... 406s Setting up libffi-dev:s390x (3.4.8-2) ... 406s Setting up locales-all (2.41-6ubuntu2) ... 406s Setting up libfakeroot:s390x (1.37.1.2-1) ... 406s Setting up llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 406s Setting up fakeroot (1.37.1.2-1) ... 406s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 406s Setting up llvm-20-tools (1:20.1.6-0ubuntu1) ... 406s Setting up autotools-dev (20240727.1) ... 406s Setting up libpfm4:s390x (4.13.0+git99-gc5587f9-1) ... 406s Setting up emacsen-common (3.0.8) ... 406s Setting up ssl-cert (1.1.3ubuntu1) ... 406s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 406s Setting up llvm-20 (1:20.1.6-0ubuntu1) ... 406s Setting up libssl-dev:s390x (3.5.0-2ubuntu1) ... 406s Setting up libmpc3:s390x (1.3.1-1build2) ... 406s Setting up libtcl8.6:s390x (8.6.16+dfsg-1) ... 406s Setting up autopoint (0.23.1-2build1) ... 406s Setting up libipc-run-perl (20231003.0-2) ... 406s Setting up libgc1:s390x (1:8.2.8-1) ... 406s Setting up autoconf (2.72-3.1ubuntu1) ... 406s Setting up liblzma-dev:s390x (5.8.1-1build1) ... 406s Setting up libubsan1:s390x (15.1.0-5ubuntu1) ... 406s Setting up zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 406s Setting up dwz (0.15-1build6) ... 406s Setting up libasan8:s390x (15.1.0-5ubuntu1) ... 406s Setting up libjson-perl (4.10000-1) ... 406s Setting up postgresql-doc (17+279) ... 406s Setting up libxslt1.1:s390x (1.1.43-0exp1) ... 406s Setting up debugedit (1:5.1-2) ... 406s Setting up libecpg6:s390x (17.5-1build1) ... 406s Setting up libisl23:s390x (0.27-1) ... 406s Setting up libclang1-20 (1:20.1.6-0ubuntu1) ... 406s Setting up libcc1-0:s390x (15.1.0-5ubuntu1) ... 406s Setting up libitm1:s390x (15.1.0-5ubuntu1) ... 406s Setting up postgresql-common-dev (279) ... 406s Setting up automake (1:1.17-4ubuntu1) ... 406s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 406s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 406s Setting up gettext (0.23.1-2build1) ... 406s Setting up libecpg-compat3:s390x (17.5-1build1) ... 406s Setting up dictionaries-common (1.30.10) ... 407s Setting up postgresql-client-17 (17.5-1build1) ... 407s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 407s Setting up libpq-dev (17.5-1build1) ... 407s Setting up libobjc4:s390x (15.1.0-5ubuntu1) ... 407s Setting up libecpg-dev (17.5-1build1) ... 407s Setting up intltool-debian (0.35.0+20060710.6) ... 407s Setting up libxml2-dev:s390x (2.14.3+dfsg-0exp3) ... 407s Setting up postgresql-common (279) ... 407s Creating config file /etc/postgresql-common/createcluster.conf with new version 407s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 407s en_us 407s Removing obsolete dictionary files: 408s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 408s Setting up llvm-20-dev (1:20.1.6-0ubuntu1) ... 408s Setting up cpp-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 408s Setting up cpp-14 (14.3.0-1ubuntu1) ... 408s Setting up dh-strip-nondeterminism (1.14.1-2) ... 408s Setting up hunspell-en-us (1:2020.12.07-4) ... 408s Setting up libgcc-14-dev:s390x (14.3.0-1ubuntu1) ... 408s Setting up libstdc++-14-dev:s390x (14.3.0-1ubuntu1) ... 408s Setting up postgresql-17 (17.5-1build1) ... 408s Creating new PostgreSQL cluster 17/main ... 408s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 408s The files belonging to this database system will be owned by user "postgres". 408s This user must also own the server process. 408s 408s The database cluster will be initialized with locale "C.UTF-8". 408s The default database encoding has accordingly been set to "UTF8". 408s The default text search configuration will be set to "english". 408s 408s Data page checksums are disabled. 408s 408s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 408s creating subdirectories ... ok 408s selecting dynamic shared memory implementation ... posix 408s selecting default "max_connections" ... 100 408s selecting default "shared_buffers" ... 128MB 408s selecting default time zone ... Etc/UTC 408s creating configuration files ... ok 409s running bootstrap script ... ok 409s performing post-bootstrap initialization ... ok 409s syncing data to disk ... ok 412s Setting up cpp-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 412s Setting up po-debconf (1.0.21+nmu1) ... 412s Setting up libobjc-14-dev:s390x (14.3.0-1ubuntu1) ... 412s Setting up gcc-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 412s Setting up gcc-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 412s Setting up g++-14-s390x-linux-gnu (14.3.0-1ubuntu1) ... 412s Setting up postgresql-plpython3-17 (17.5-1build1) ... 412s Setting up postgresql-plperl-17 (17.5-1build1) ... 412s Setting up cpp (4:14.2.0-1ubuntu1) ... 412s Setting up clang-20 (1:20.1.6-0ubuntu1) ... 412s Setting up postgresql-pltcl-17 (17.5-1build1) ... 412s Setting up libtool (2.5.4-4) ... 412s Setting up g++-s390x-linux-gnu (4:14.2.0-1ubuntu1) ... 412s Setting up gcc-14 (14.3.0-1ubuntu1) ... 412s Setting up dh-autoreconf (20) ... 412s Setting up postgresql-server-dev-17 (17.5-1build1) ... 412s Setting up g++-14 (14.3.0-1ubuntu1) ... 412s Setting up postgresql-server-dev-all (279) ... 412s Setting up debhelper (13.24.2ubuntu1) ... 412s Setting up postgresql-all (279) ... 412s Setting up gcc (4:14.2.0-1ubuntu1) ... 412s Setting up g++ (4:14.2.0-1ubuntu1) ... 412s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 412s Setting up build-essential (12.12ubuntu1) ... 412s Processing triggers for libc-bin (2.41-6ubuntu2) ... 412s Processing triggers for systemd (257.6-1ubuntu1) ... 412s Processing triggers for man-db (2.13.1-1) ... 413s Processing triggers for install-info (7.1.1-1) ... 413s Processing triggers for dictionaries-common (1.30.10) ... 415s autopkgtest [22:45:37]: test run-testsuite: [----------------------- 415s ************************************************************************** 415s # A new feature in cloud-init identified possible datasources for # 415s # this system as: # 415s # [] # 415s # However, the datasource used was: OpenStack # 415s # # 415s # In the future, cloud-init will only attempt to use datasources that # 415s # are identified or specifically configured. # 415s # For more information see # 415s # https://bugs.launchpad.net/bugs/1669675 # 415s # # 415s # If you are seeing this message, please file a bug against # 415s # cloud-init at # 415s # https://github.com/canonical/cloud-init/issues # 415s # Make sure to include the cloud provider your instance is # 415s # running on. # 415s # # 415s # After you have filed a bug, you can disable this warning by launching # 415s # your instance with the cloud-config below, or putting that content # 415s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 415s # # 415s # #cloud-config # 415s # warnings: # 415s # dsid_missing_source: off # 415s ************************************************************************** 415s 415s Disable the warnings above by: 415s touch /root/.cloud-warnings.skip 415s or 415s touch /var/lib/cloud/instance/warnings/.skip 416s ====== Running all tests with umask 077 ======= 416s ### PostgreSQL test 001_packages.t ### 416s 1..23 416s ok 1 - /etc/os-release exists 416s ok 2 - OS is ubuntu 416s ok 3 - OS version is 25.10 416s # PostgreSQL versions installed: 17 416s # 17 416s ok 4 - postgresql-17 installed 416s ok 5 - postgresql-plpython3-17 installed 416s ok 6 - postgresql-plperl-17 installed 416s ok 7 - postgresql-pltcl-17 installed 416s ok 8 # skip No postgresql-17-jit package for version 17 416s ok 9 - postgresql-server-dev-17 installed 416s ok 10 # skip No postgresql-contrib-17 package for version 17 416s # postgresql-doc-17 installed 416s ok 11 - At least one doc package installed 416s ok 12 - libecpg-dev installed 416s ok 13 - postgresql-common-dev installed 416s ok 14 - procps installed 416s ok 15 - netcat-openbsd installed 416s ok 16 - hunspell-en-us installed 416s ok 17 - system has a default UTF-8 locale 416s ok 18 - locale ru_RU exists 416s ok 19 - locale ru_RU.UTF-8 exists 416s ok 20 - user postgres in the UNIX group ssl-cert 416s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 416s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 416s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 416s ### End test 001_packages.t ### 416s 416s ### PostgreSQL test 002_existing_clusters.t ### 416s 1..8 416s # Cleanup 416s ok 1 - Cleanup: No clusters left behind 416s ok 2 - No postgres processes left behind 416s ok 3 - No files in /etc/postgresql left behind 416s ok 4 - No files in /var/lib/postgresql left behind 416s ok 5 - No files in /var/run/postgresql left behind 416s ok 6 - No files in /var/log/postgresql left behind 416s ok 7 - PostgreSQL TCP ports are closed 416s ok 8 - Next free port is 5432 416s ### End test 002_existing_clusters.t ### 416s 416s ### PostgreSQL test 003_alternatives.t ### 416s 1..9 416s # Newest PG version installed is 17 416s ok 1 - psql.1.gz link group 416s ok 2 - postmaster.1.gz link group does not exist 416s ok 3 - psql.1.gz alternative 416s ok 4 - pg_dump.1.gz alternative 416s ok 5 - postgres.1.gz alternative 416s ok 6 - pg_ctl.1.gz alternative 416s # Newest PG doc version installed is 17 416s ok 7 - SPI_connect.3.gz link group 416s ok 8 - SPI_connect.3.gz alternative 416s ok 9 - SPI_exec.3.gz alternative 416s ### End test 003_alternatives.t ### 416s 416s ### PostgreSQL test 005_PgCommon.t ### 416s 1..24 416s ok 1 - correctly parsed line 'local all postgres ident sameuser' 416s ok 2 - correctly parsed line 'local foo nobody trust' 416s ok 3 - correctly parsed line 'local foo nobody crypt' 416s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 416s ok 5 - correctly parsed line 'local foo,bar nobody ident' 416s ok 6 - correctly parsed line 'local all +foogrp password' 416s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 416s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 416s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 416s ok 10 - @expected_records has correct number of entries 416s ok 11 - returned read_pg_hba array has correct number of records 416s ok 12 - line 'foo all all md5' parsed as invalid 416s ok 13 - line 'local all all foo' parsed as invalid 416s ok 14 - line 'host all all foo' parsed as invalid 416s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 416s ok 16 - line 'host all all md5' parsed as invalid 416s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 416s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 416s ok 19 - read_conf_file returns empty dict for nonexisting file 416s ok 20 - read_conf_file() parsing 416s ok 21 - read_conf_file() parsing with include directives 416s ok 22 - set_conf_value 416s ok 23 - disable_conf_value 416s ok 24 - replace_conf_value 416s ### End test 005_PgCommon.t ### 416s 416s ### PostgreSQL test 006_next_free_port.t ### 416s 1..5 416s ok 1 - next_free_port is 5432 417s ok 2 - next_free_port detects localhost ipv4 socket 418s ok 3 - next_free_port detects wildcard ipv4 socket 419s ok 4 - next_free_port detects localhost ipv6 socket 420s ok 5 - next_free_port detects wildcard ipv6 socket 420s ### End test 006_next_free_port.t ### 420s 420s ### PostgreSQL test 007_pg_conftool.t ### 420s 1..41 420s # test without cluster 420s ok 1 - pg_conftool show all 420s ok 2 - correct output of pg_conftool show all 420s ok 3 - pg_conftool foo.conf show all 420s ok 4 - correct output of pg_conftool foo.conf show all 420s ok 5 - pg_conftool /tmp/fNuLwR1muu/different.conf show all 420s ok 6 - correct output of pg_conftool /tmp/fNuLwR1muu/different.conf show all 420s ok 7 - pg_conftool 9.7 main show all 420s ok 8 - correct output of pg_conftool 9.7 main show all 420s # test show 420s ok 9 - pg_conftool show all 420s ok 10 - correct output of pg_conftool show all 420s ok 11 - pg_conftool other.conf show all 420s ok 12 - correct output of pg_conftool other.conf show all 420s ok 13 - pg_conftool /tmp/fNuLwR1muu/different.conf show all 420s ok 14 - correct output of pg_conftool /tmp/fNuLwR1muu/different.conf show all 421s ok 15 - pg_conftool 17 main show all 421s ok 16 - correct output of pg_conftool 17 main show all 421s ok 17 - pg_conftool 17 main other.conf show all 421s ok 18 - correct output of pg_conftool 17 main other.conf show all 421s ok 19 - pg_conftool show a 421s ok 20 - correct output of pg_conftool show a 421s ok 21 - pg_conftool -s show a 421s ok 22 - correct output of pg_conftool -s show a 421s # test set 421s ok 23 - pg_conftool set c 7 421s ok 24 - correct output of pg_conftool set c 7 421s ok 25 - file contains new setting 421s ok 26 - pg_conftool set a 8 421s ok 27 - correct output of pg_conftool set a 8 421s ok 28 - file contains updated setting 421s ok 29 - pg_conftool /tmp/fNuLwR1muu/different.conf set a 9 421s ok 30 - correct output of pg_conftool /tmp/fNuLwR1muu/different.conf set a 9 421s ok 31 - file with path contains updated setting 421s # test remove 421s ok 32 - pg_conftool remove a 421s ok 33 - correct output of pg_conftool remove a 421s ok 34 - setting removed from file 421s ok 35 - pg_conftool /tmp/fNuLwR1muu/different.conf remove a 421s ok 36 - correct output of pg_conftool /tmp/fNuLwR1muu/different.conf remove a 421s ok 37 - setting removed from file with path 421s # test edit 421s ok 38 - pg_conftool edit 421s ok 39 - correct output of pg_conftool edit 421s ok 40 - pg_conftool /tmp/fNuLwR1muu/different.conf edit 421s ok 41 - correct output of pg_conftool /tmp/fNuLwR1muu/different.conf edit 421s ### End test 007_pg_conftool.t ### 421s 421s ### PostgreSQL test 010_defaultport_cluster.t ### 421s 1..14 421s ok 1 - psql --version 421s ok 2 - pg_wrapper selects highest available version number 421s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 421s ok 4 - connecting to localhost fails with no clusters 421s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 421s ok 6 - pg_wrapper uses host and port from PGCLUSTER 421s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 421s ok 8 - pg_wrapper uses --cluster from the command line 421s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 421s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 421s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 421s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 421s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 421s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 421s ### End test 010_defaultport_cluster.t ### 421s 421s ### PostgreSQL test 015_start_stop.t ### 421s 1..71 421s # We are running systemd 421s # Running tests for 17 421s # Cluster does not exist yet 421s ok 1 - cluster 17 main does not exist 421s ok 2 - service postgresql@17-main does not exist 421s ok 3 - systemctl start postgresql 421s ok 4 - cluster 17 main does not exist 421s ok 5 - service postgresql@17-main does not exist 421s ok 6 - systemctl start postgresql@17-main 421s ok 7 - cluster 17 main does not exist 421s ok 8 - service postgresql@17-main does not exist 421s # Start/stop postgresql using system tools 422s ok 9 - pg_createcluster 17 main 422s ok 10 - cluster 17 main is stopped 422s ok 11 - service postgresql@17-main is stopped 424s ok 12 - systemctl start postgresql 424s ok 13 - cluster 17 main is running 424s ok 14 - service postgresql@17-main is running 424s ok 15 - systemctl start postgresql 424s ok 16 - cluster 17 main is already running 424s ok 17 - service postgresql@17-main is already running 424s ok 18 - systemctl stop postgresql 430s ok 19 - cluster 17 main is stopped 430s ok 20 - service postgresql@17-main is stopped 430s ok 21 - systemctl stop postgresql 430s ok 22 - cluster 17 main is already stopped 430s ok 23 - service postgresql@17-main is already stopped 430s # Start/stop specific cluster using system tools 432s ok 24 - systemctl start postgresql@17-main 433s ok 25 - cluster 17 main is running 433s ok 26 - service postgresql@17-main is running 433s ok 27 - systemctl start postgresql@17-main 433s ok 28 - cluster 17 main is running 433s ok 29 - service postgresql@17-main is running 435s ok 30 - systemctl restart postgresql@17-main 435s ok 31 - cluster 17 main is running 435s ok 32 - service postgresql@17-main is running 435s ok 33 - systemctl stop postgresql@17-main 435s ok 34 - cluster 17 main is stopped 435s ok 35 - service postgresql@17-main is stopped 435s ok 36 - systemctl stop postgresql@17-main 435s ok 37 - cluster 17 main is already stopped 435s ok 38 - service postgresql@17-main is already stopped 436s ok 39 - pg_dropcluster 17 main 436s ok 40 - cluster 17 main does not exist 436s ok 41 - service postgresql@17-main does not exist 436s # Start/stop specific cluster using pg_*cluster 436s ok 42 - pg_ctlcluster start 17 main 436s ok 43 - cluster 17 main does not exist 437s ok 44 - service postgresql@17-main does not exist 439s ok 45 - pg_createcluster 17 main --start 440s ok 46 - cluster 17 main is running 440s ok 47 - service postgresql@17-main is running 440s ok 48 - pg_ctlcluster 17 main start 440s ok 49 - cluster 17 main is already running 440s ok 50 - service postgresql@17-main is already running 442s ok 51 - pg_ctlcluster 17-main restart 442s ok 52 - cluster 17 main is running 442s ok 53 - service postgresql@17-main is running 442s ok 54 - pg_ctlcluster 17 main stop 442s ok 55 - cluster 17 main is stopped 442s ok 56 - service postgresql@17-main is stopped 442s ok 57 - pg_ctlcluster 17 main stop 442s ok 58 - cluster 17 main is already stopped 442s ok 59 - service postgresql@17-main is already stopped 445s ok 60 - pg_ctlcluster start 17-main 445s ok 61 - cluster 17 main is running 445s ok 62 - service postgresql@17-main is running 446s ok 63 - pg_dropcluster 17 main --stop 446s # Cleanup 446s ok 64 - Cleanup: No clusters left behind 446s ok 65 - No postgres processes left behind 446s ok 66 - No files in /etc/postgresql left behind 446s ok 67 - No files in /var/lib/postgresql left behind 446s ok 68 - No files in /var/run/postgresql left behind 446s ok 69 - No files in /var/log/postgresql left behind 446s ok 70 - PostgreSQL TCP ports are closed 446s ok 71 - Next free port is 5432 446s ### End test 015_start_stop.t ### 446s 446s ### PostgreSQL test 020_create_sql_remove.t ### 446s 1..141 446s # Running tests for 17 449s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.eiJHKN 449s ok 2 - pg_createcluster 17 main 449s ok 3 - Socket and pid file are in /var/run/postgresql/ 449s ok 4 - xlog/wal directory /tmp/17.xlog.eiJHKN was created 449s ok 5 - local method in pg_hba.conf is peer 449s ok 6 - host method in pg_hba.conf is scram-sha-256 449s ok 7 - Exactly one postgres master process running 451s ok 8 - pg_ctlcluster 17 main restart 451s ok 9 - cluster restarts with new environment file 451s ok 10 - Exactly one postgres master process running 451s ok 11 - correct value of PGEXTRAVAR1 in environment 451s ok 12 - correct value of PGEXTRAVAR2 in environment 451s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 451s ok 14 - createdb --version 451s ok 15 - pg_wrapper+createdb selects version number of cluster 451s ok 16 - psql --version 451s ok 17 - pg_wrapper+psql selects version 17 451s ok 18 - pg_lscluster reports online cluster on port 5432 451s ok 19 - log file is actually used 451s ok 20 - /etc/postgresql is owned by user "postgres" 451s ok 21 - version configuration directory file is owned by user "postgres" 451s ok 22 - configuration directory file is owned by user "postgres" 451s ok 23 - version data directory file is owned by user "postgres" 451s ok 24 - data directory file is owned by user "postgres" 451s ok 25 - log file has 0640 permissions 451s ok 26 - log file is owned by user "postgres" 451s ok 27 - log file is owned by group "adm" 451s ok 28 - no log symlink by default 451s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 451s ok 30 - pg_lsclusters -h 451s ok 31 - correct output of pg_lsclusters -h 451s ok 32 - stopping cluster 454s ok 33 - restarting cluster with nondefault log symlink 454s ok 34 - log target is used as log file 454s ok 35 - default log is not used 454s ok 36 - pg_lsclusters -h 454s ok 37 - correct output of pg_lsclusters -h 454s ok 38 - stopping cluster 457s ok 39 - restarting cluster with explicitly configured log file 457s ok 40 - default log is not used 457s ok 41 - log symlink target is used for startup message 457s ok 42 - exactly one log file 457s ok 43 - custom log is actually used 457s ok 44 - pg_lsclusters -h 457s ok 45 - correct output of pg_lsclusters -h 457s ok 46 - stopping cluster 457s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 457s ok 48 - /etc/postgres-hack was not created 459s ok 49 - restarting cluster 459s ok 50 - ps -o tty -U postgres h 459s ok 51 - postgres processes do not have an associated terminal 459s ok 52 - Server is linked with SSL support 459s ok 53 - SSL is enabled in postgresql.conf 459s ok 54 - psql -l fails for nobody 459s ok 55 - createuser nobody 459s ok 56 - createdb nobodydb 459s ok 57 - psql -ltA succeeds for nobody 459s ok 58 - psql -ltA output 459s ok 59 - SQL command: create table 459s ok 60 - SQL command: insert into table values 460s ok 61 - SQL command: insert into table values 460s ok 62 - primary key violation 460s ok 63 - psql -tAc "select * from phone order by name" nobodydb 460s ok 64 - SQL command output: select -tA 460s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 460s ok 66 - SQL command output: select -tx 460s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 460s ok 68 - SQL command output: select -tAx 460s ok 69 - CREATE EXTENSION plperlu fails for user nobody 460s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 460s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 460s ok 72 - creating PL/PerlU function as user nobody fails 460s ok 73 - creating unsafe PL/Perl function as user postgres fails 460s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 460s ok 75 - creating PL/PerlU function as user postgres succeeds 460s ok 76 - psql nobodydb -Atc "select read_file()" 460s ok 77 - calling PL/PerlU function 460s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 460s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 460s ok 80 - creating unsafe PL/Perl function as user nobody fails 460s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 460s ok 82 - creating PL/Perl function as user nobody succeeds 460s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 460s ok 84 - calling PL/Perl function 460s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 460s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 460s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 460s ok 88 - creating PL/Python3 function as user postgres succeeds 460s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 460s ok 90 - calling PL/Python function 460s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 460s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 460s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 460s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 460s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 460s ok 96 - creating PL/Tcl function as user nobody succeeds 460s ok 97 - 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 98 - creating PL/TclU function as user postgres succeeds 460s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 460s ok 100 - calling PL/Tcl function 460s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 460s ok 102 - calling PL/TclU function 460s ok 103 - stopping cluster 460s ok 104 - pg_ctlcluster 17 main start 460s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 463s ok 106 - pg_ctlcluster 17 main start 463s ok 107 - cluster restarts with pgdata symlink 463s ok 108 - postgres master has OOM killer protection 463s ok 109 - postgres client backend has no OOM adjustment 463s ok 110 - ps h 6138 463s ok 111 - process title is idle 464s ok 112 - ps h 6138 464s ok 113 - process title is idle in transaction 464s ok 114 - stopping cluster 466s ok 115 - starting cluster as postgres works without a log file 466s ok 116 - log file got recreated and used 466s ok 117 - creating a directory in spc2 466s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.9LUmmJ'" 466s ok 119 - creating tablespace spc1 466s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 466s ok 121 - creating a table in spc1 466s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.zKBm6X'" 466s ok 123 - creating tablespace spc2 466s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 466s ok 125 - creating a table in spc2 466s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 466s ok 127 - Correct apt NeverAutoRemove config 467s ok 128 - pg_dropcluster removes cluster 467s ok 129 - xlog/wal directory /tmp/17.xlog.eiJHKN was deleted 467s ok 130 - tablespace spc1 was emptied 467s ok 131 - tablespace spc2 was emptied 467s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 467s ok 133 - Correct apt NeverAutoRemove config 467s # Cleanup 467s ok 134 - Cleanup: No clusters left behind 467s ok 135 - No postgres processes left behind 467s ok 136 - No files in /etc/postgresql left behind 467s ok 137 - No files in /var/lib/postgresql left behind 467s ok 138 - No files in /var/run/postgresql left behind 467s ok 139 - No files in /var/log/postgresql left behind 467s ok 140 - PostgreSQL TCP ports are closed 467s ok 141 - Next free port is 5432 467s ### End test 020_create_sql_remove.t ### 467s 467s ### PostgreSQL test 021_pg_renamecluster.t ### 467s 1..20 470s ok 1 - pg_createcluster 17 main 473s ok 2 - pg_renamecluster 17 main donau 473s ok 3 - psql -tAc "show data_directory" 473s ok 4 - cluster is running and data_directory was moved 473s ok 5 - pg_hba.conf location updated 473s ok 6 - pg_ident.conf location updated 473s ok 7 - external_pid_file location updated 473s ok 8 - external_pid_file exists 473s ok 9 # skip no stats_temp_directory in 17 473s ok 10 # skip no stats_temp_directory in 17 473s ok 11 - cluster_name is updated 474s ok 12 - pg_dropcluster removes cluster 474s # Cleanup 474s ok 13 - Cleanup: No clusters left behind 474s ok 14 - No postgres processes left behind 474s ok 15 - No files in /etc/postgresql left behind 474s ok 16 - No files in /var/lib/postgresql left behind 474s ok 17 - No files in /var/run/postgresql left behind 474s ok 18 - No files in /var/log/postgresql left behind 474s ok 19 - PostgreSQL TCP ports are closed 474s ok 20 - Next free port is 5432 474s ### End test 021_pg_renamecluster.t ### 474s 474s ### PostgreSQL test 022_recovery.t ### 474s 1..17 474s # Running tests for 17 477s ok 1 - pg_createcluster 17 main --start >/dev/null 477s ok 2 - pg_ctlcluster 17 main stop -m i 480s ok 3 - pg_ctlcluster 17 main start 480s ok 4 - psql -c '' 480s ok 5 - pg_ctlcluster 17 main stop -m i 480s ok 6 - create write-protected file in data directory 482s ok 7 - pg_ctlcluster 17 main start 482s ok 8 - psql -c '' 483s ok 9 - pg_dropcluster removes cluster 483s # Cleanup 483s ok 10 - Cleanup: No clusters left behind 483s ok 11 - No postgres processes left behind 483s ok 12 - No files in /etc/postgresql left behind 483s ok 13 - No files in /var/lib/postgresql left behind 483s ok 14 - No files in /var/run/postgresql left behind 483s ok 15 - No files in /var/log/postgresql left behind 483s ok 16 - PostgreSQL TCP ports are closed 483s ok 17 - Next free port is 5432 483s ### End test 022_recovery.t ### 483s 483s ### PostgreSQL test 025_logging.t ### 483s 1..55 484s # Logging to /var/log/syslog works 484s # Running tests for 17 487s ok 1 - pg_createcluster 17 main 487s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 487s ok 3 - psql -qc "'foobar_17_7436'" 487s ok 4 - log an error 487s ok 5 - grep --binary-files=text foobar_17_7436 /var/log/postgresql/postgresql-17-main.log 487s ok 6 - error appears in logfile 487s ok 7 - pg_conftool 17 main set log_destination syslog 487s ok 8 - set log_destination syslog 487s ok 9 - pg_ctlcluster 17 main reload 487s ok 10 - 17 main reload 488s ok 11 - psql -Atc "show log_destination" 488s ok 12 - log_destination is syslog 488s ok 13 - pg_lscluster reports syslog 488s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 488s ok 15 - error appears in /var/log/syslog 488s ok 16 - pg_conftool 17 main set logging_collector on 488s ok 17 - set logging_collector on 488s ok 18 - pg_conftool 17 main set log_destination csvlog 488s ok 19 - set log_destination csvlog 491s ok 20 - pg_ctlcluster 17 main restart 491s ok 21 - 17 main restart 491s ok 22 - psql -Atc "show logging_collector" 491s ok 23 - logging_collector is on 491s ok 24 - psql -Atc "show log_destination" 491s ok 25 - log_destination is csvlog 491s ok 26 - pg_lscluster reports csvlog 491s ok 27 - psql -qc "'barbaz_17_7436'" 491s ok 28 - log an error 491s ok 29 - grep --binary-files=text barbaz_17_7436 /var/lib/postgresql/17/main/log/*.csv 491s ok 30 - error appears in log/*.csv 491s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 491s ok 32 - set log_destination stderr,syslog,csvlog 491s ok 33 - pg_ctlcluster 17 main reload 491s ok 34 - 17 main reload 491s ok 35 - psql -Atc "show log_destination" 491s ok 36 - log_destination is stderr,syslog,csvlog 491s ok 37 - pg_lscluster reports stderr,syslog,csvlog 491s ok 38 - psql -qc "'moo_17_7436'" 491s ok 39 - log an error 492s ok 40 - grep --binary-files=text moo_17_7436 /var/lib/postgresql/17/main/log/*.log 492s ok 41 - error appears in log/*.log 492s ok 42 - grep --binary-files=text 'postgres.*moo_17_7436' /var/log/syslog 492s ok 43 - error appears in /var/log/syslog 492s ok 44 - grep --binary-files=text moo_17_7436 /var/lib/postgresql/17/main/log/*.csv 492s ok 45 - error appears in log/*.csv 494s ok 46 - pg_dropcluster 17 main --stop 494s ok 47 - pg_dropcluster removes cluster 494s # Cleanup 494s ok 48 - Cleanup: No clusters left behind 494s ok 49 - No postgres processes left behind 494s ok 50 - No files in /etc/postgresql left behind 494s ok 51 - No files in /var/lib/postgresql left behind 494s ok 52 - No files in /var/run/postgresql left behind 494s ok 53 - No files in /var/log/postgresql left behind 494s ok 54 - PostgreSQL TCP ports are closed 494s ok 55 - Next free port is 5432 494s ### End test 025_logging.t ### 494s 494s ### PostgreSQL test 027_jit.t ### 494s # 17 497s ok 1 - pg_createcluster 17 main --start 497s ok 2 - psql -Xatc 'show jit' 497s ok 3 - JIT is on by default 497s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 497s ok 5 - No JIT on cheap query 497s ok 6 - pg_conftool 17 main set seq_page_cost 100000 497s ok 7 - pg_conftool 17 main set random_page_cost 100000 497s ok 8 - pg_ctlcluster 17 main reload 497s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 497s ok 10 - Expensive query is JITed 498s ok 11 - pg_dropcluster --stop 17 main 498s # Cleanup 498s ok 12 - Cleanup: No clusters left behind 498s ok 13 - No postgres processes left behind 498s ok 14 - No files in /etc/postgresql left behind 498s ok 15 - No files in /var/lib/postgresql left behind 498s ok 16 - No files in /var/run/postgresql left behind 498s ok 17 - No files in /var/log/postgresql left behind 498s ok 18 - PostgreSQL TCP ports are closed 498s ok 19 - Next free port is 5432 498s 1..19 498s ### End test 027_jit.t ### 498s 498s ### PostgreSQL test 030_errors.t ### 498s 1..156 498s ok 1 - pg_lscluster reports cluster without binaries 499s ok 2 - pg_dropcluster 6.3 main 500s ok 3 - pg_createcluster --socketdir 500s ok 4 - pg_lsclusters -h 500s ok 5 - cluster was created 500s ok 6 - Port of created cluster is 5432 500s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 500s ok 8 - pg_createcluster on existing cluster 500s ok 9 - pg_lsclusters -h 500s ok 10 - original cluster still exists 500s ok 11 - pg_createcluster 17 test -p foo 500s ok 12 - pg_createcluster -p checks that port option is numeric 500s ok 13 - pg_createcluster 17 test -p 42 500s ok 14 - pg_createcluster -p checks valid port range 500s ok 15 - pg_ctlcluster 17 main start 500s ok 16 - pg_ctlcluster refuses to start root-owned cluster 500s ok 17 - pg_ctlcluster 17 main start 500s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 500s ok 19 - pg_ctlcluster 17 main start 500s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 500s ok 21 - pg_ctlcluster 17 main start 500s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 502s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 502s ok 24 - No sockets in /var/run/postgresql 502s ok 25 - Socket is in /tmp/postgresql-testsuite/ 503s ok 26 - cluster stops with custom unix_socket_dir 503s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 505s ok 28 - cluster starts after removing unix_socket_dir 505s ok 29 - Socket is in default dir /var/run/postgresql 505s ok 30 - No sockets in /tmp/postgresql-testsuite/ 505s ok 31 - pg_ctlcluster 17 main stop 505s ok 32 - pg_ctlcluster fails with corrupted PID file 505s ok 33 - pg_lsclusters -h 505s ok 34 - cluster is still online 505s ok 35 - pg_ctlcluster succeeds with restored PID file 505s ok 36 - pg_lsclusters -h 505s ok 37 - cluster is down 505s ok 38 - pg_ctlcluster 17 main stop 505s ok 39 - pg_ctlcluster stop fails on stopped cluster 507s ok 40 - pg_ctlcluster 17 main start 507s ok 41 - pg_ctlcluster succeeds with already existing PID file 507s ok 42 - pg_lsclusters -h 507s ok 43 - cluster is online 507s ok 44 - pg_ctlcluster stop succeeds 507s ok 45 - pg_lsclusters -h 507s ok 46 - cluster is down 507s ok 47 - no pid file left 507s ok 48 - pg_ctlcluster 17 main stop 507s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 507s ok 50 - pid file was cleaned up 507s ok 51 - pg_ctlcluster --force 17 main stop 507s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 507s ok 53 - pid file was cleaned up 507s ok 54 - pg_ctlcluster 17 main stop 507s ok 55 - pg_ctlcluster stop succeeds with stale PID file 507s ok 56 - pid file was cleaned up 507s ok 57 - pg_ctlcluster --force 17 main stop 507s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 507s ok 59 - pid file was cleaned up 507s ok 60 - pg_ctlcluster --force 17 main stop 507s ok 61 - pg_ctlcluster stop succeeds with empty PID file 507s ok 62 - pid file was cleaned up 510s ok 63 - pg_ctlcluster 17 main start 510s ok 64 - pg_ctlcluster succeeds with corrupted PID file 510s ok 65 - pg_lsclusters -h 510s ok 66 - cluster is online 510s ok 67 - pg_ctlcluster 17 main start 510s ok 68 - pg_ctlcluster start fails on running cluster 510s ok 69 - pg_ctlcluster stop 510s ok 70 - pg_ctlcluster 17 main start 510s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 510s ok 72 - pg_ctlcluster 17 main stop 510s ok 73 - stopping cluster 516s ok 74 - pg_ctlcluster 17 main start 516s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 516s ok 76 - pg_ctlcluster 17 main stop 516s ok 77 - stopping cluster 516s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 516s ok 79 - pg_dropcluster 17 main 516s ok 80 - pg_dropcluster works as user postgres 517s ok 81 - pg_createcluster succeeds 517s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 517s ok 83 - proper error message for nonexisting /var/lib/postgresql 519s ok 84 - pg_ctlcluster 17 main start 519s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 519s ok 86 - pg_ctlcluster 17 main stop 519s ok 87 - stopping cluster 520s ok 88 - pg_createcluster other 522s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 524s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 525s ok 91 525s ok 92 - pg_ctlcluster 17 other start 525s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 525s ok 94 - pg_ctlcluster 17 main stop 525s ok 95 - stopping main cluster 527s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 528s ok 97 - pg_dropcluster other 529s ok 98 - pg_dropcluster 529s ok 99 - No sockets any more 529s ok 100 - 'pg_lsclusters 4.5 foo' fails 529s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 529s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 529s ok 103 - 'psql --cluster 4.5/foo' fails 529s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 529s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 529s ok 106 - 'psql --cluster 17/foo' fails 529s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 529s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 529s ok 109 - 'pg_dropcluster 4.5 foo' fails 529s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 529s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 529s ok 112 - 'pg_dropcluster 17 foo' fails 529s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 529s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 529s ok 115 - 'pg_upgradecluster 4.5 foo' fails 529s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 529s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 529s ok 118 - 'pg_upgradecluster 17 foo' fails 529s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 529s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 529s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 529s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 529s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 529s ok 124 - 'pg_ctlcluster 17 foo stop' fails 529s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 529s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 529s # Cleanup 529s ok 127 - Cleanup: No clusters left behind 529s ok 128 - No postgres processes left behind 529s ok 129 - No files in /etc/postgresql left behind 529s ok 130 - No files in /var/lib/postgresql left behind 529s ok 131 - No files in /var/run/postgresql left behind 529s ok 132 - No files in /var/log/postgresql left behind 529s ok 133 - PostgreSQL TCP ports are closed 529s ok 134 - Next free port is 5432 530s ok 135 - pg_dropcluster 17 broken 530s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 530s # Cleanup 530s ok 137 - Cleanup: No clusters left behind 530s ok 138 - No postgres processes left behind 530s ok 139 - No files in /etc/postgresql left behind 530s ok 140 - No files in /var/lib/postgresql left behind 530s ok 141 - No files in /var/run/postgresql left behind 530s ok 142 - No files in /var/log/postgresql left behind 530s ok 143 - PostgreSQL TCP ports are closed 530s ok 144 - Next free port is 5432 531s ok 145 - pg_dropcluster 17 broken 531s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 531s ok 147 - /etc/postgresql/17 was removed 531s ok 148 - /var/lib/postgresql/17 was removed 531s # Cleanup 531s ok 149 - Cleanup: No clusters left behind 531s ok 150 - No postgres processes left behind 531s ok 151 - No files in /etc/postgresql left behind 531s ok 152 - No files in /var/lib/postgresql left behind 531s ok 153 - No files in /var/run/postgresql left behind 531s ok 154 - No files in /var/log/postgresql left behind 531s ok 155 - PostgreSQL TCP ports are closed 531s ok 156 - Next free port is 5432 531s ### End test 030_errors.t ### 531s 531s ### PostgreSQL test 031_errors_disk_full.t ### 531s 1..22 531s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 532s ok 1 - script failed 532s ok 2 - pg_createcluster fails due to insufficient disk space 532s ok 3 - does not leave files behind 532s # Cleanup 532s ok 4 - Cleanup: No clusters left behind 532s ok 5 - No postgres processes left behind 532s ok 6 - No files in /etc/postgresql left behind 532s ok 7 - No files in /var/lib/postgresql left behind 532s ok 8 - No files in /var/run/postgresql left behind 532s ok 9 - No files in /var/log/postgresql left behind 532s ok 10 - PostgreSQL TCP ports are closed 532s ok 11 - Next free port is 5432 532s # check disk full conditions on startup 534s ok 12 - script failed 534s ok 13 - pg_ctlcluster prints error message 534s ok 14 - log file has error message 534s # Cleanup 534s ok 15 - Cleanup: No clusters left behind 534s ok 16 - No postgres processes left behind 534s ok 17 - No files in /etc/postgresql left behind 534s ok 18 - No files in /var/lib/postgresql left behind 534s ok 19 - No files in /var/run/postgresql left behind 534s ok 20 - No files in /var/log/postgresql left behind 534s ok 21 - PostgreSQL TCP ports are closed 534s ok 22 - Next free port is 5432 534s ### End test 031_errors_disk_full.t ### 534s 534s ### PostgreSQL test 032_ssl_key_permissions.t ### 534s 1..22 534s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 534s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 534s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 535s ok 4 - pg_createcluster 17 main 535s ok 5 - pg_ctlcluster 17 main start 535s ok 6 - ssl key owned by nobody refused 535s ok 7 - pg_ctlcluster 17 main start 535s ok 8 - ssl key with permissions root:root 0644 refused 535s ok 9 - pg_ctlcluster 17 main start 535s ok 10 - ssl key with permissions postgres:postgres 0640 refused 536s ok 11 - pg_dropcluster 17 main --stop 536s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 536s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 536s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 536s # Cleanup 536s ok 15 - Cleanup: No clusters left behind 536s ok 16 - No postgres processes left behind 536s ok 17 - No files in /etc/postgresql left behind 536s ok 18 - No files in /var/lib/postgresql left behind 536s ok 19 - No files in /var/run/postgresql left behind 536s ok 20 - No files in /var/log/postgresql left behind 536s ok 21 - PostgreSQL TCP ports are closed 536s ok 22 - Next free port is 5432 536s ### End test 032_ssl_key_permissions.t ### 536s 536s ### PostgreSQL test 040_upgrade.t ### 536s 1..1 536s ok 1 - only one major version installed, skipping upgrade tests 536s ### End test 040_upgrade.t ### 536s 536s ### PostgreSQL test 041_upgrade_custompaths.t ### 536s 1..1 536s ok 1 - only one major version installed, skipping upgrade tests 536s ### End test 041_upgrade_custompaths.t ### 536s 536s ### PostgreSQL test 042_upgrade_rename.t ### 537s 1..15 537s # PostgreSQL 17 539s ok 1 - pg_createcluster 17 main --start 545s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 545s ok 3 - pg_lsclusters -h 545s ok 4 - correct output of pg_lsclusters -h 546s ok 5 - pg_dropcluster 17 main --stop 547s ok 6 - pg_dropcluster 17 upgr --stop 547s ok 7 - Cleaning pg_upgrade log files 547s # Cleanup 547s ok 8 - Cleanup: No clusters left behind 547s ok 9 - No postgres processes left behind 547s ok 10 - No files in /etc/postgresql left behind 547s ok 11 - No files in /var/lib/postgresql left behind 547s ok 12 - No files in /var/run/postgresql left behind 547s ok 13 - No files in /var/log/postgresql left behind 547s ok 14 - PostgreSQL TCP ports are closed 547s ok 15 - Next free port is 5432 547s ### End test 042_upgrade_rename.t ### 547s 547s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 547s 1..1 547s ok 1 - only one major version installed, skipping upgrade tests 547s ### End test 043_upgrade_ssl_cert.t ### 547s 547s ### PostgreSQL test 045_backup.t ### 547s # We are running systemd 547s # PostgreSQL 17 547s # create cluster 550s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 550s ok 2 - pg_lsclusters -h 550s ok 3 - correct output of pg_lsclusters -h 550s ok 4 - pg_conftool 17 main set work_mem 11MB 550s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 550s ok 6 - psql -c 'alter database mydb set search_path=public' 550s ok 7 - psql -c 'create table foo (t text)' mydb 550s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 550s ok 9 - psql -c 'CREATE USER myuser' 550s ok 10 - psql -c 'grant create on database mydb to myuser' 550s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 550s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 550s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 550s # create directory 550s ok 14 - pg_backupcluster 17 main createdirectory 550s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 550s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 550s # dump 551s ok 17 - systemctl start pg_dump@17-main 551s ok 18 - dump created in /var/backups/postgresql/17-main/2025-06-19T224752Z.dump 551s ok 19 - /var/backups/postgresql/17-main/2025-06-19T224752Z.dump owned by uid postgres 551s ok 20 - /var/backups/postgresql/17-main/2025-06-19T224752Z.dump owned by gid postgres 551s # basebackup 551s ok 21 - systemctl start pg_receivewal@17-main 551s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 551s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 551s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 551s ok 25 - psql -c 'select pg_reload_conf()' 578s ok 26 - systemctl start pg_basebackup@17-main 578s ok 27 - dump created in /var/backups/postgresql/17-main/2025-06-19T224753Z.backup 578s ok 28 - /var/backups/postgresql/17-main/2025-06-19T224753Z.backup owned by uid postgres 578s ok 29 - /var/backups/postgresql/17-main/2025-06-19T224753Z.backup owned by gid postgres 578s # list 579s ok 30 - pg_backupcluster 17 main list 579s ok 31 - correct output of pg_backupcluster 17 main list 579s # more database changes 579s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 579s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 579s ok 34 - retrieve recovery timestamp 579s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 579s ok 36 - systemctl stop pg_receivewal@17-main 579s # restore /var/backups/postgresql/17-main/2025-06-19T224752Z.dump 580s ok 37 - pg_dropcluster 17 main --stop 584s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T224752Z.dump --start --datadir /var/lib/postgresql/17/snowflake 584s ok 39 - pg_lsclusters -h 584s ok 40 - correct output of pg_lsclusters -h 584s ok 41 - psql -XAtl 584s ok 42 - mydb locales 584s ok 43 - mydb grants 584s ok 44 - myicudb locales 584s ok 45 - psql -XAtc 'show work_mem' 584s ok 46 - correct output of psql -XAtc 'show work_mem' 584s ok 47 - psql -XAtc 'select * from foo' mydb 584s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 584s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 584s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 584s ok 51 - psql -XAtc '\drds' 584s ok 52 - correct output of psql -XAtc '\drds' 584s # restore /var/backups/postgresql/17-main/2025-06-19T224753Z.backup 585s ok 53 - pg_dropcluster 17 main --stop 588s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T224753Z.backup --start --datadir /var/lib/postgresql/17/snowflake 588s ok 55 - pg_lsclusters -h 588s ok 56 - correct output of pg_lsclusters -h 588s ok 57 - psql -XAtl 588s ok 58 - mydb locales 588s ok 59 - mydb grants 588s ok 60 - myicudb locales 588s ok 61 - psql -XAtc 'show work_mem' 588s ok 62 - correct output of psql -XAtc 'show work_mem' 588s ok 63 - psql -XAtc 'select * from foo' mydb 588s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 588s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 588s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 588s ok 67 - psql -XAtc '\drds' 588s ok 68 - correct output of psql -XAtc '\drds' 588s # restore /var/backups/postgresql/17-main/2025-06-19T224753Z.backup with WAL archive 590s ok 69 - pg_dropcluster 17 main --stop 593s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T224753Z.backup --start --archive --port 5430 593s ok 71 - pg_lsclusters -h 593s ok 72 - correct output of pg_lsclusters -h 593s ok 73 - psql -XAtc 'select * from foo order by t' mydb 593s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 593s # restore /var/backups/postgresql/17-main/2025-06-19T224753Z.backup with PITR 594s ok 75 - pg_dropcluster 17 main --stop 597s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T224753Z.backup --start --pitr '2025-06-19 22:48:21.052202+00 597s # ' 597s ok 77 - pg_lsclusters -h 597s ok 78 - correct output of pg_lsclusters -h 597s ok 79 - psql -XAtc 'select * from foo order by t' mydb 597s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 598s ok 81 - pg_dropcluster 17 main --stop 598s # Cleanup 598s ok 82 - Cleanup: No clusters left behind 598s ok 83 - No postgres processes left behind 598s ok 84 - No files in /etc/postgresql left behind 598s ok 85 - No files in /var/lib/postgresql left behind 598s ok 86 - No files in /var/run/postgresql left behind 598s ok 87 - No files in /var/log/postgresql left behind 598s ok 88 - PostgreSQL TCP ports are closed 598s ok 89 - Next free port is 5432 598s 1..89 598s ### End test 045_backup.t ### 598s 598s ### PostgreSQL test 050_encodings.t ### 598s 1..60 598s # Checking 17 ru_RU 601s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 602s ok 2 - psql -l succeeds 602s ok 3 - template1 is not UTF-8 encoded 602s ok 4 - creating test database 602s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 602s # create table t (x varchar); copy t from stdin" test 602s ok 6 - creating table with ISO-8859-5 characters 602s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 602s ok 8 - correct string in UTF-8 602s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 602s ok 10 - correct string in ISO-8859-5 602s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 602s # delete from t; copy t from stdin" test 602s ok 12 - creating table with UTF-8 characters 602s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 602s ok 14 - correct string in UTF-8 602s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 602s ok 16 - correct string in ISO-8859-1 602s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 602s ok 18 - Server error message has correct language and encoding 605s ok 19 - pg_ctlcluster 17 ru_RU restart 605s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 606s ok 21 - Dropping cluster 606s # Checking 17 ru_RU.UTF-8 609s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 610s ok 23 - psql -l succeeds 610s ok 24 - template1 is UTF-8 encoded 610s ok 25 - creating test database 610s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 610s # create table t (x varchar); copy t from stdin" test 610s ok 27 - creating table with ISO-8859-5 characters 610s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 610s ok 29 - correct string in UTF-8 610s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 610s ok 31 - correct string in ISO-8859-5 610s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 610s # delete from t; copy t from stdin" test 610s ok 33 - creating table with UTF-8 characters 610s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 610s ok 35 - correct string in UTF-8 610s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 610s ok 37 - correct string in ISO-8859-1 610s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 610s ok 39 - Server error message has correct language and encoding 613s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 613s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 613s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 613s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 613s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 613s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 613s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 613s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 614s ok 48 - Dropping cluster 614s # Check 17 locale environment variables 617s ok 49 - pg_createcluster: LC_ALL dominates LANG 617s ok 50 - psql -Atl --cluster 17/main 617s ok 51 - template1 is ASCII encoded 618s ok 52 - Dropping cluster 618s # Cleanup 618s ok 53 - Cleanup: No clusters left behind 618s ok 54 - No postgres processes left behind 618s ok 55 - No files in /etc/postgresql left behind 618s ok 56 - No files in /var/lib/postgresql left behind 618s ok 57 - No files in /var/run/postgresql left behind 618s ok 58 - No files in /var/log/postgresql left behind 618s ok 59 - PostgreSQL TCP ports are closed 618s ok 60 - Next free port is 5432 618s ### End test 050_encodings.t ### 618s 618s ### PostgreSQL test 052_upgrade_encodings.t ### 618s 1..1 618s ok 1 - only one major version installed, skipping upgrade tests 618s ### End test 052_upgrade_encodings.t ### 618s 618s ### PostgreSQL test 060_obsolete_confparams.t ### 618s ok 1 - only one major version installed, skipping upgrade tests 618s 1..1 618s ### End test 060_obsolete_confparams.t ### 618s 618s ### PostgreSQL test 070_non_postgres_clusters.t ### 618s 1..40 619s ok 1 - pg_createcluster 17 main for owner nobody 619s ok 2 - pg_ctlcluster 17 main start 619s ok 3 - start refused when config and data owners mismatch 621s ok 4 - pg_ctlcluster succeeds with owner nobody 621s ok 5 - pg_lsclusters -h 621s ok 6 - pg_lsclusters shows running cluster 621s ok 7 - postgres is running as user nobody 621s ok 8 - ls /tmp/.s.PGSQL.* 621s ok 9 - socket is in /tmp 621s ok 10 - /var/run/postgresql is empty 621s ok 11 - conf dir is owned by user 621s ok 12 - conf dir is owned by user's primary group 621s ok 13 - files are owned by user 621s ok 14 - files are owned by user's primary group 621s ok 15 - log file has 0640 permissions 621s ok 16 - log file is owned by user 621s ok 17 - log file is owned by user's primary group 621s ok 18 - only one major version installed, skipping upgrade test 621s ok 19 - ... 621s ok 20 - ... 621s ok 21 - ... 621s ok 22 - ... 621s ok 23 - ... 621s ok 24 - ... 621s ok 25 - ... 621s ok 26 - ... 621s ok 27 - ... 621s ok 28 - ... 622s ok 29 - pg_dropcluster 622s ok 30 - pg_lsclusters -h 622s ok 31 - No clusters left 622s ok 32 - No postgres processes left 622s # Cleanup 622s ok 33 - Cleanup: No clusters left behind 622s ok 34 - No postgres processes left behind 622s ok 35 - No files in /etc/postgresql left behind 622s ok 36 - No files in /var/lib/postgresql left behind 622s ok 37 - No files in /var/run/postgresql left behind 622s ok 38 - No files in /var/log/postgresql left behind 622s ok 39 - PostgreSQL TCP ports are closed 622s ok 40 - Next free port is 5432 622s ### End test 070_non_postgres_clusters.t ### 622s 622s ### PostgreSQL test 080_start.conf.t ### 623s 1..73 623s ok 1 - pg_createcluster 17 main 623s # start.conf auto 623s ok 2 - get_cluster_start_conf returns auto 623s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 623s ok 4 - start.conf contains auto 623s ok 5 - systemd generator links cluster 623s ok 6 - systemd generator links correct service file 625s ok 7 - /etc/init.d/postgresql start 17 626s ok 8 - correct output of /etc/init.d/postgresql start 17 626s ok 9 - pg_lsclusters -h 626s ok 10 - cluster is online 626s ok 11 - /etc/init.d/postgresql stop 17 626s ok 12 - correct output of /etc/init.d/postgresql stop 17 629s ok 13 - pg_lsclusters -h 629s ok 14 - cluster is down 629s # start.conf manual 629s ok 15 - get_cluster_start_conf returns manual 629s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 629s ok 17 - start.conf contains manual 629s ok 18 - systemd generator doesn't link cluster 629s ok 19 - /etc/init.d/postgresql start 17 629s ok 20 - correct output of /etc/init.d/postgresql start 17 629s ok 21 - pg_lsclusters -h 629s ok 22 - cluster is down 631s ok 23 - pg_ctlcluster 17 main start 631s ok 24 - correct output of pg_ctlcluster 17 main start 631s ok 25 - pg_lsclusters -h 631s ok 26 - cluster is online 631s ok 27 - pg_ctlcluster 17 main stop 631s ok 28 - correct output of pg_ctlcluster 17 main stop 631s ok 29 - pg_lsclusters -h 631s ok 30 - cluster is down 631s # start.conf disabled 631s ok 31 - get_cluster_start_conf returns disabled 631s ok 32 - systemd generator doesn't link cluster 631s ok 33 - /etc/init.d/postgresql start 17 631s ok 34 - correct output of /etc/init.d/postgresql start 17 631s ok 35 - pg_lsclusters -h 631s ok 36 - cluster is down 631s ok 37 - pg_ctlcluster 17 main start 631s ok 38 - correct output of pg_ctlcluster 17 main start 631s ok 39 - pg_lsclusters -h 631s ok 40 - cluster is down 634s ok 41 - pg_ctlcluster 17 main start 634s ok 42 - correct output of pg_ctlcluster 17 main start 634s ok 43 - pg_lsclusters -h 634s ok 44 - cluster is online 634s ok 45 - pg_ctlcluster 17 main stop 634s ok 46 - correct output of pg_ctlcluster 17 main stop 634s ok 47 - pg_lsclusters -h 634s ok 48 - cluster is down 636s ok 49 - pg_ctlcluster 17 main start 636s ok 50 - correct output of pg_ctlcluster 17 main start 636s ok 51 - pg_lsclusters -h 636s ok 52 - cluster is online 636s # test upgrade 636s ok 53 - only one major version installed, skipping upgrade test 636s ok 54 - ... 636s ok 55 - get_cluster_start_conf for old cluster returns manual 636s ok 56 - get_cluster_start_conf for new cluster returns manual 636s ok 57 - ... 637s ok 58 - dropping upgraded cluster 637s ok 59 - pg_lsclusters -h 637s ok 60 - no clusters any more 637s ok 61 - pg_createcluster 17 main --start-conf foo 637s ok 62 - pg_createcluster checks --start-conf validity 638s ok 63 - pg_createcluster checks --start-conf manual 638s ok 64 - get_cluster_start_conf returns manual 639s ok 65 - dropping cluster 639s # Cleanup 639s ok 66 - Cleanup: No clusters left behind 639s ok 67 - No postgres processes left behind 639s ok 68 - No files in /etc/postgresql left behind 639s ok 69 - No files in /var/lib/postgresql left behind 639s ok 70 - No files in /var/run/postgresql left behind 639s ok 71 - No files in /var/log/postgresql left behind 639s ok 72 - PostgreSQL TCP ports are closed 639s ok 73 - Next free port is 5432 639s ### End test 080_start.conf.t ### 639s 639s ### PostgreSQL test 085_pg_ctl.conf.t ### 639s 1..33 639s ok 1 - prlimit --core=0:unlimited --pid=16488 639s ok 2 - set core file size to unlimited 639s ok 3 - sh -c 'ulimit -Hc' 639s ok 4 - core file size is unlimited 639s ok 5 - pg_createcluster 17 main 639s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 642s ok 7 - pg_ctlcluster 17 main start 642s ok 8 - starting cluster as root 642s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 642s ok 10 - soft core size is 0 642s # hard core file size limit of root-started postgres process is unlimited 642s ok 11 - set pg_ctl default option to -c 644s ok 12 - pg_ctlcluster 17 main restart 644s ok 13 - restarting cluster as root 644s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 644s ok 15 - soft core size is unlimited 644s ok 16 - pg_ctlcluster 17 main stop 644s ok 17 - stopping cluster 644s ok 18 - restored pg_ctl default option 646s ok 19 - pg_ctlcluster 17 main start -- -c 646s ok 20 - starting cluster with -c on the command line as postgres 646s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 646s ok 22 - soft core size is unlimited 646s ok 23 - pg_ctlcluster 17 main stop 646s ok 24 - stopping cluster 647s ok 25 - dropping cluster 647s # Cleanup 647s ok 26 - Cleanup: No clusters left behind 647s ok 27 - No postgres processes left behind 647s ok 28 - No files in /etc/postgresql left behind 647s ok 29 - No files in /var/lib/postgresql left behind 647s ok 30 - No files in /var/run/postgresql left behind 647s ok 31 - No files in /var/log/postgresql left behind 647s ok 32 - PostgreSQL TCP ports are closed 647s ok 33 - Next free port is 5432 648s ### End test 085_pg_ctl.conf.t ### 648s 648s ### PostgreSQL test 090_multicluster.t ### 648s 1..125 648s ok 1 - pg_createcluster 17 old 649s ok 2 - pg_createcluster 17 new1 650s ok 3 - pg_createcluster 17 new2 652s ok 4 - starting cluster 17/old 654s ok 5 - starting cluster 17/new1 656s ok 6 - starting cluster 17/new2 656s ok 7 - pg_lsclusters -h | sort -k3 656s ok 8 - clusters have the correct ports, skipping used 5433 656s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 656s ok 10 - createdb --version 656s ok 11 - pg_wrapper selects port 5432 as default cluster 656s ok 12 - createdb --cluster 17/new1 --version 656s ok 13 - pg_wrapper --cluster works 656s ok 14 - createdb --cluster 17/foo --version 656s ok 15 - pg_wrapper --cluster errors out for invalid cluster 656s ok 16 - createdb --cluster 17/new1 test 656s ok 17 - correct output of createdb --cluster 17/new1 test 656s ok 18 - psql -Atl --cluster 17/new1 656s ok 19 - test db appears in cluster new1 656s ok 20 - psql -Atl --cluster 17/new2 656s ok 21 - test db does not appear in cluster new2 657s ok 22 - psql -Atl 657s ok 23 - test db does not appear in default cluster 657s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 657s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 657s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 657s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 657s ok 28 - psql -Atl --cluster 17/localhost:5434 657s ok 29 - test db appears in cluster 17/localhost:5434 657s ok 30 - psql -Atl --cluster 17/localhost:5440 657s ok 31 - test db does not appear in cluster 17/localhost:5440 657s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 657s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 657s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 657s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 657s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 657s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 657s ok 38 - psql -Atl --cluster 6.4/localhost: 657s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 657s ok 40 - psql -Atl 657s ok 41 - PGCLUSTER selection (1) 657s ok 42 - psql -Atl 657s ok 43 - PGCLUSTER selection (2) 657s ok 44 - psql -l 657s ok 45 - invalid PGCLUSTER value 657s ok 46 - createdb --version 657s ok 47 - PGCLUSTER network cluster selection (1) 657s ok 48 - psql -Atl 657s ok 49 - PGCLUSTER network cluster selection (2) 657s ok 50 - psql -Atl 657s ok 51 - PGCLUSTER network cluster selection (3) 657s ok 52 - LC_MESSAGES=C psql -Atl 657s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 657s ok 54 - psql -Atc "show port" template1 657s ok 55 - PGPORT selection (1) 657s ok 56 - psql -Atc "show port" template1 657s ok 57 - PGPORT selection (2) 657s ok 58 - createdb --version 657s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 657s ok 60 - psql -Atc "show port" template1 657s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 657s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 657s ok 63 - PGDATABASE environment variable works 657s ok 64 - createdb --version 657s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 657s ok 66 - createdb --cluster 17/new1 --version 657s ok 67 - pg_wrapper --cluster works with empty user_clusters 657s ok 68 - createdb --version 657s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 657s ok 70 - psql -Atc "select current_database()" 657s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 657s ok 72 - psql -Atc 'select current_database()' 657s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 657s ok 74 - createdb --version 657s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 657s ok 76 - createdb --version 657s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 657s ok 78 - createdb --version 657s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 657s ok 80 - createdb --version 657s ok 81 - pg_wrapper selects correct version with per-user user_clusters 657s ok 82 - createdb --version 657s ok 83 - pg_wrapper selects correct version with per-user user_clusters 657s ok 84 - createdb --version 657s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 657s ok 86 - psql -Atl 657s ok 87 - $PGHOST overrides user_clusters 657s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 657s ok 89 - --cluster overrides $PGHOST 657s ok 90 - createdb --version 657s ok 91 - pg_wrapper ignores invalid lines in user_clusters 657s ok 92 - psql -Atc 'select current_database()' 657s ok 93 - pg_service conf selection 1 657s ok 94 - psql -Atc 'select current_database()' 657s ok 95 - pg_service conf selection 2 657s ok 96 - psql -Atc 'select current_database()' 657s ok 97 - pg_service conf selection 3 658s ok 98 - stopping cluster 17/old 660s ok 99 - restarting cluster 17/old 660s ok 100 - pg_lsclusters -h | sort -k3 660s ok 101 - port of first cluster was successfully changed 660s ok 102 - psql -l 660s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 660s ok 104 - psql -Atl --cluster 17/new1 660s ok 105 - --cluster selects appropriate cluster 660s ok 106 - psql -Atl -p 5434 660s ok 107 - -p selects appropriate cluster 660s ok 108 - psql -Atlp 5434 660s ok 109 - -Atlp selects appropriate cluster 660s ok 110 - psql -Atl --port 5434 660s ok 111 - --port selects appropriate cluster 660s ok 112 - env PGPORT=5434 psql -Atl 660s ok 113 - $PGPORT selects appropriate cluster 660s ok 114 - Restoring original /etc/postgresql-common/user_clusters 661s ok 115 - dropping 17/new1 663s ok 116 - dropping 17/new2 664s ok 117 - dropping 17/old 664s # Cleanup 664s ok 118 - Cleanup: No clusters left behind 664s ok 119 - No postgres processes left behind 664s ok 120 - No files in /etc/postgresql left behind 664s ok 121 - No files in /var/lib/postgresql left behind 664s ok 122 - No files in /var/run/postgresql left behind 664s ok 123 - No files in /var/log/postgresql left behind 664s ok 124 - PostgreSQL TCP ports are closed 664s ok 125 - Next free port is 5432 664s ### End test 090_multicluster.t ### 664s 664s ### PostgreSQL test 110_integrate_cluster.t ### 664s 1..32 665s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/WkMUIUmmJx/c/postgres 665s ok 2 - creating raw initdb cluster for user postgres 665s ok 3 - pg_createcluster 17 postgres -d /tmp/WkMUIUmmJx/c/postgres 665s ok 4 - integrating postgres cluster 665s ok 5 - pg_lsclusters 665s ok 6 - correct pg_lsclusters output 667s ok 7 - pg_ctlcluster 17 postgres start 667s ok 8 - starting cluster postgres 667s ok 9 - pg_lsclusters 667s ok 10 - correct pg_lsclusters output 668s ok 11 - dropping cluster postgres 668s ok 12 - No files in temporary cluster dir left behind 669s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/WkMUIUmmJx/c/nobody 669s ok 14 - creating raw initdb cluster for user nobody 669s ok 15 - pg_createcluster 17 nobody -d /tmp/WkMUIUmmJx/c/nobody 669s ok 16 - integrating nobody cluster 669s ok 17 - pg_lsclusters 669s ok 18 - correct pg_lsclusters output 671s ok 19 - pg_ctlcluster 17 nobody start 671s ok 20 - starting cluster nobody 671s ok 21 - pg_lsclusters 671s ok 22 - correct pg_lsclusters output 672s ok 23 - dropping cluster nobody 672s ok 24 - No files in temporary cluster dir left behind 672s # Cleanup 672s ok 25 - Cleanup: No clusters left behind 672s ok 26 - No postgres processes left behind 672s ok 27 - No files in /etc/postgresql left behind 672s ok 28 - No files in /var/lib/postgresql left behind 672s ok 29 - No files in /var/run/postgresql left behind 672s ok 30 - No files in /var/log/postgresql left behind 672s ok 31 - PostgreSQL TCP ports are closed 672s ok 32 - Next free port is 5432 672s ### End test 110_integrate_cluster.t ### 672s 672s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 673s 1..1 673s ok 1 - only one major version installed, skipping upgrade tests 673s ### End test 120_pg_upgradecluster_scripts.t ### 673s 673s ### PostgreSQL test 130_nonroot_admin.t ### 673s 1..22 675s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 675s ok 2 - pg_lsclusters -h 675s ok 3 - correct output of pg_lsclusters -h 675s ok 4 - psql -Atl 675s ok 5 - correct output of psql -Atl 675s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 675s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 675s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 675s # Cleanup 675s ok 15 - Cleanup: No clusters left behind 675s ok 16 - No postgres processes left behind 675s ok 17 - No files in /etc/postgresql left behind 675s ok 18 - No files in /var/lib/postgresql left behind 675s ok 19 - No files in /var/run/postgresql left behind 675s ok 20 - No files in /var/log/postgresql left behind 675s ok 21 - PostgreSQL TCP ports are closed 675s ok 22 - Next free port is 5432 675s ### End test 130_nonroot_admin.t ### 675s 675s ### PostgreSQL test 135_pg_virtualenv.t ### 675s 1..20 680s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 680s ok 2 - running pg_virtualenv as root 682s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 682s ok 4 - running pg_virtualenv as postgres 685s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 685s ok 6 - running pg_virtualenv as nobody 688s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 688s ok 8 - running fakeroot pg_virtualenv as root 691s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 691s ok 10 - running fakeroot pg_virtualenv as postgres 694s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 694s ok 12 - running fakeroot pg_virtualenv as nobody 694s # Cleanup 694s ok 13 - Cleanup: No clusters left behind 694s ok 14 - No postgres processes left behind 694s ok 15 - No files in /etc/postgresql left behind 694s ok 16 - No files in /var/lib/postgresql left behind 694s ok 17 - No files in /var/run/postgresql left behind 694s ok 18 - No files in /var/log/postgresql left behind 694s ok 19 - PostgreSQL TCP ports are closed 694s ok 20 - Next free port is 5432 694s ### End test 135_pg_virtualenv.t ### 694s 694s ### PostgreSQL test 140_pg_config.t ### 694s 1..38 694s # Multiarch is enabled 694s # checking version specific output for 17 694s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 694s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 694s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 694s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 694s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 694s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 694s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 694s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 694s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 694s # checking pg_config output (should behave like version 17) 694s ok 15 - pg_config 694s ok 16 - correct output of pg_config 694s ok 17 - pg_config --help 694s ok 18 - correct output of pg_config --help 694s ok 19 - pg_config --pgxs 694s ok 20 - correct output of pg_config --pgxs 694s ok 21 - pg_config --libdir 694s ok 22 - correct output of pg_config --libdir 694s ok 23 - pg_config --pkglibdir 694s ok 24 - correct output of pg_config --pkglibdir 694s ok 25 - pg_config --bindir 694s ok 26 - correct output of pg_config --bindir 694s # checking pg_config.libpq-dev output (should behave like version 17) 694s ok 27 - pg_config.libpq-dev 694s ok 28 - correct output of pg_config.libpq-dev 694s ok 29 - pg_config.libpq-dev --help 694s ok 30 - correct output of pg_config.libpq-dev --help 694s ok 31 - pg_config.libpq-dev --pgxs 694s ok 32 - correct output of pg_config.libpq-dev --pgxs 694s ok 33 - pg_config.libpq-dev --libdir 694s ok 34 - correct output of pg_config.libpq-dev --libdir 694s ok 35 - pg_config.libpq-dev --pkglibdir 694s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 694s ok 37 - pg_config.libpq-dev --bindir 694s ok 38 - correct output of pg_config.libpq-dev --bindir 694s ### End test 140_pg_config.t ### 694s 694s ### PostgreSQL test 150_tsearch_stemming.t ### 694s 1..37 694s ok 1 - pg_updatedicts succeeded 694s ok 2 - pg_updatedicts created en_us.affix 694s ok 3 - pg_updatedicts created en_us.dict 694s ok 4 - pg_updatedicts created 17 en_us.affix symlink 694s ok 5 - pg_updatedicts created 17 en_us.dict symlink 697s ok 6 - pg_createcluster 17 main 697s ok 7 - createdb fts 697s ok 8 - correct output of createdb fts 697s ok 9 - creating en_US full text search configuration 697s ok 10 - creating data table and search index 697s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 697s ok 12 - stem search of correct word 698s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 698s ok 14 - stem search of correct word 698s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 698s ok 16 - stem search of unknown word 698s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 698s ok 18 - full text search, exact word 698s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 698s ok 20 - full text search for word stem 698s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 698s ok 22 - full text search for word substring fails 698s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 698s ok 24 - full text search, exact unicode word 698s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 698s ok 26 - full text search for unicode word stem 698s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 698s ok 28 - full text search for unicode word substring fails 699s ok 29 699s # Cleanup 699s ok 30 - Cleanup: No clusters left behind 699s ok 31 - No postgres processes left behind 699s ok 32 - No files in /etc/postgresql left behind 699s ok 33 - No files in /var/lib/postgresql left behind 699s ok 34 - No files in /var/run/postgresql left behind 699s ok 35 - No files in /var/log/postgresql left behind 699s ok 36 - PostgreSQL TCP ports are closed 699s ok 37 - Next free port is 5432 699s ### End test 150_tsearch_stemming.t ### 699s 699s ### PostgreSQL test 160_alternate_confroot.t ### 699s 1..28 702s ok 1 702s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 702s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 702s ok 4 - pg_lsclusters -h 702s ok 5 - correct output of pg_lsclusters -h 702s ok 6 - psql -Atl 702s ok 7 - correct output of psql -Atl 702s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 702s ok 9 - ... 702s ok 10 - ... 702s ok 11 - ... 702s ok 12 - ... 702s ok 13 - ... 702s ok 14 - ... 702s ok 15 - pg_dropcluster 17 test --stop 703s ok 16 - correct output of pg_dropcluster 17 test --stop 703s ok 17 - pg_lsclusters -h 703s ok 18 - correct output of pg_lsclusters -h 703s ok 19 - No files in root/data left behind 703s ok 20 - No cruft in root dir left behind 703s # Cleanup 703s ok 21 - Cleanup: No clusters left behind 703s ok 22 - No postgres processes left behind 703s ok 23 - No files in /etc/postgresql left behind 703s ok 24 - No files in /var/lib/postgresql left behind 703s ok 25 - No files in /var/run/postgresql left behind 703s ok 26 - No files in /var/log/postgresql left behind 703s ok 27 - PostgreSQL TCP ports are closed 703s ok 28 - Next free port is 5432 703s ### End test 160_alternate_confroot.t ### 703s 703s ### PostgreSQL test 170_extensions.t ### 703s # Running tests for 17 705s ok 1 - pg_createcluster 17 main 705s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 705s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 705s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 705s ok 5 - extension amcheck installs without error 705s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 705s ok 7 - extension amcheck removes without error 705s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 705s ok 9 - extension autoinc installs without error 705s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 705s ok 11 - extension autoinc removes without error 705s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 705s ok 13 - extension bloom installs without error 705s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 705s ok 15 - extension bloom removes without error 705s ok 16 - psql -qc 'CREATE EXTENSION plperl' 705s ok 17 - bool_plperl dependency plperl installs without error 705s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 705s ok 19 - extension bool_plperl installs without error 705s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 705s ok 21 - extension bool_plperl removes without error 705s ok 22 - psql -qc 'DROP EXTENSION plperl' 705s ok 23 - bool_plperl dependency extension plperl removes without error 705s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 705s ok 25 - bool_plperlu dependency plperlu installs without error 705s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 705s ok 27 - extension bool_plperlu installs without error 706s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 706s ok 29 - extension bool_plperlu removes without error 706s ok 30 - psql -qc 'DROP EXTENSION plperlu' 706s ok 31 - bool_plperlu dependency extension plperlu removes without error 706s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 706s ok 33 - extension btree_gin installs without error 706s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 706s ok 35 - extension btree_gin removes without error 706s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 706s ok 37 - extension btree_gist installs without error 706s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 706s ok 39 - extension btree_gist removes without error 706s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 706s ok 41 - extension citext installs without error 706s ok 42 - psql -qc 'DROP EXTENSION "citext"' 706s ok 43 - extension citext removes without error 706s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 706s ok 45 - extension cube installs without error 706s ok 46 - psql -qc 'DROP EXTENSION "cube"' 706s ok 47 - extension cube removes without error 706s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 706s ok 49 - extension dblink installs without error 706s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 706s ok 51 - extension dblink removes without error 706s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 706s ok 53 - extension dict_int installs without error 706s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 706s ok 55 - extension dict_int removes without error 706s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 706s ok 57 - extension dict_xsyn installs without error 706s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 706s ok 59 - extension dict_xsyn removes without error 706s ok 60 - psql -qc 'CREATE EXTENSION cube' 706s ok 61 - earthdistance dependency cube installs without error 706s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 706s ok 63 - extension earthdistance installs without error 706s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 706s ok 65 - extension earthdistance removes without error 706s ok 66 - psql -qc 'DROP EXTENSION cube' 706s ok 67 - earthdistance dependency extension cube removes without error 706s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 706s ok 69 - extension file_fdw installs without error 706s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 706s ok 71 - extension file_fdw removes without error 706s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 706s ok 73 - extension fuzzystrmatch installs without error 706s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 706s ok 75 - extension fuzzystrmatch removes without error 706s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 706s ok 77 - extension hstore installs without error 706s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 706s ok 79 - extension hstore removes without error 706s ok 80 - psql -qc 'CREATE EXTENSION hstore' 706s ok 81 - hstore_plperl dependency hstore installs without error 706s ok 82 - psql -qc 'CREATE EXTENSION plperl' 706s ok 83 - hstore_plperl dependency plperl installs without error 706s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 706s ok 85 - extension hstore_plperl installs without error 706s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 706s ok 87 - extension hstore_plperl removes without error 706s ok 88 - psql -qc 'DROP EXTENSION hstore' 706s ok 89 - hstore_plperl dependency extension hstore removes without error 706s ok 90 - psql -qc 'DROP EXTENSION plperl' 706s ok 91 - hstore_plperl dependency extension plperl removes without error 706s ok 92 - psql -qc 'CREATE EXTENSION hstore' 706s ok 93 - hstore_plperlu dependency hstore installs without error 707s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 707s ok 95 - hstore_plperlu dependency plperlu installs without error 707s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 707s ok 97 - extension hstore_plperlu installs without error 707s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 707s ok 99 - extension hstore_plperlu removes without error 707s ok 100 - psql -qc 'DROP EXTENSION hstore' 707s ok 101 - hstore_plperlu dependency extension hstore removes without error 707s ok 102 - psql -qc 'DROP EXTENSION plperlu' 707s ok 103 - hstore_plperlu dependency extension plperlu removes without error 707s ok 104 - psql -qc 'CREATE EXTENSION hstore' 707s ok 105 - hstore_plpython3u dependency hstore installs without error 707s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 707s ok 107 - hstore_plpython3u dependency plpython3u installs without error 707s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 707s ok 109 - extension hstore_plpython3u installs without error 707s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 707s ok 111 - extension hstore_plpython3u removes without error 707s ok 112 - psql -qc 'DROP EXTENSION hstore' 707s ok 113 - hstore_plpython3u dependency extension hstore removes without error 707s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 707s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 707s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 707s ok 117 - extension insert_username installs without error 707s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 707s ok 119 - extension insert_username removes without error 707s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 707s ok 121 - extension intagg installs without error 707s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 707s ok 123 - extension intagg removes without error 707s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 707s ok 125 - extension intarray installs without error 707s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 707s ok 127 - extension intarray removes without error 707s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 707s ok 129 - extension isn installs without error 707s ok 130 - psql -qc 'DROP EXTENSION "isn"' 707s ok 131 - extension isn removes without error 707s ok 132 - psql -qc 'CREATE EXTENSION plperl' 707s ok 133 - jsonb_plperl dependency plperl installs without error 707s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 707s ok 135 - extension jsonb_plperl installs without error 707s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 707s ok 137 - extension jsonb_plperl removes without error 707s ok 138 - psql -qc 'DROP EXTENSION plperl' 707s ok 139 - jsonb_plperl dependency extension plperl removes without error 707s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 707s ok 141 - jsonb_plperlu dependency plperlu installs without error 707s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 707s ok 143 - extension jsonb_plperlu installs without error 707s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 707s ok 145 - extension jsonb_plperlu removes without error 707s ok 146 - psql -qc 'DROP EXTENSION plperlu' 707s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 707s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 707s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 707s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 707s ok 151 - extension jsonb_plpython3u installs without error 707s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 707s ok 153 - extension jsonb_plpython3u removes without error 707s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 707s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 707s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 707s ok 157 - extension lo installs without error 707s ok 158 - psql -qc 'DROP EXTENSION "lo"' 707s ok 159 - extension lo removes without error 707s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 707s ok 161 - extension ltree installs without error 708s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 708s ok 163 - extension ltree removes without error 708s ok 164 - psql -qc 'CREATE EXTENSION ltree' 708s ok 165 - ltree_plpython3u dependency ltree installs without error 708s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 708s ok 167 - ltree_plpython3u dependency plpython3u installs without error 708s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 708s ok 169 - extension ltree_plpython3u installs without error 708s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 708s ok 171 - extension ltree_plpython3u removes without error 708s ok 172 - psql -qc 'DROP EXTENSION ltree' 708s ok 173 - ltree_plpython3u dependency extension ltree removes without error 708s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 708s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 708s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 708s ok 177 - extension moddatetime installs without error 708s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 708s ok 179 - extension moddatetime removes without error 708s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 708s ok 181 - extension pageinspect installs without error 708s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 708s ok 183 - extension pageinspect removes without error 708s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 708s ok 185 - extension pg_buffercache installs without error 708s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 708s ok 187 - extension pg_buffercache removes without error 708s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 708s ok 189 - extension pg_freespacemap installs without error 708s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 708s ok 191 - extension pg_freespacemap removes without error 708s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 708s ok 193 - extension pg_prewarm installs without error 708s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 708s ok 195 - extension pg_prewarm removes without error 708s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 708s ok 197 - extension pg_stat_statements installs without error 708s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 708s ok 199 - extension pg_stat_statements removes without error 708s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 708s ok 201 - extension pg_surgery installs without error 708s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 708s ok 203 - extension pg_surgery removes without error 708s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 708s ok 205 - extension pg_trgm installs without error 708s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 708s ok 207 - extension pg_trgm removes without error 708s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 708s ok 209 - extension pg_visibility installs without error 708s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 708s ok 211 - extension pg_visibility removes without error 708s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 708s ok 213 - extension pg_walinspect installs without error 708s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 708s ok 215 - extension pg_walinspect removes without error 708s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 708s ok 217 - extension pgcrypto installs without error 708s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 708s ok 219 - extension pgcrypto removes without error 708s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 708s ok 221 - extension pgrowlocks installs without error 708s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 708s ok 223 - extension pgrowlocks removes without error 708s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 708s ok 225 - extension pgstattuple installs without error 708s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 708s ok 227 - extension pgstattuple removes without error 708s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 708s ok 229 - extension plperl installs without error 708s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 708s ok 231 - extension plperl removes without error 708s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 708s ok 233 - extension plperlu installs without error 708s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 708s ok 235 - extension plperlu removes without error 709s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 709s ok 237 - extension plpython3u installs without error 709s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 709s ok 239 - extension plpython3u removes without error 709s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 709s ok 241 - extension pltcl installs without error 709s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 709s ok 243 - extension pltcl removes without error 709s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 709s ok 245 - extension pltclu installs without error 709s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 709s ok 247 - extension pltclu removes without error 709s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 709s ok 249 - extension postgres_fdw installs without error 709s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 709s ok 251 - extension postgres_fdw removes without error 709s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 709s ok 253 - extension refint installs without error 709s ok 254 - psql -qc 'DROP EXTENSION "refint"' 709s ok 255 - extension refint removes without error 709s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 709s ok 257 - extension seg installs without error 709s ok 258 - psql -qc 'DROP EXTENSION "seg"' 709s ok 259 - extension seg removes without error 709s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 709s ok 261 - extension sslinfo installs without error 709s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 709s ok 263 - extension sslinfo removes without error 709s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 709s ok 265 - extension tablefunc installs without error 709s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 709s ok 267 - extension tablefunc removes without error 709s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 709s ok 269 - extension tcn installs without error 709s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 709s ok 271 - extension tcn removes without error 709s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 709s ok 273 - extension tsm_system_rows installs without error 709s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 709s ok 275 - extension tsm_system_rows removes without error 709s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 709s ok 277 - extension tsm_system_time installs without error 709s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 709s ok 279 - extension tsm_system_time removes without error 709s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 709s ok 281 - extension unaccent installs without error 709s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 709s ok 283 - extension unaccent removes without error 709s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 709s ok 285 - extension uuid-ossp installs without error 709s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 709s ok 287 - extension uuid-ossp removes without error 709s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 709s ok 289 - extension xml2 installs without error 709s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 709s ok 291 - extension xml2 removes without error 710s ok 292 - pg_dropcluster 17 main 710s # Cleanup 710s ok 293 - Cleanup: No clusters left behind 710s ok 294 - No postgres processes left behind 710s ok 295 - No files in /etc/postgresql left behind 710s ok 296 - No files in /var/lib/postgresql left behind 710s ok 297 - No files in /var/run/postgresql left behind 710s ok 298 - No files in /var/log/postgresql left behind 710s ok 299 - PostgreSQL TCP ports are closed 710s ok 300 - Next free port is 5432 710s 1..300 710s ### End test 170_extensions.t ### 710s 710s ### PostgreSQL test 180_ecpg.t ### 710s 1..14 710s ok 1 - ecpg test.pgc 710s ok 2 - ecpg processing 711s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 711s ok 4 - compiling ecpg output 717s ok 5 - pg_virtualenv /tmp/tmp.hGQe3D9Ivd/test 717s ok 6 - test program runs and gives correct output 717s # Cleanup 717s ok 7 - Cleanup: No clusters left behind 717s ok 8 - No postgres processes left behind 717s ok 9 - No files in /etc/postgresql left behind 717s ok 10 - No files in /var/lib/postgresql left behind 717s ok 11 - No files in /var/run/postgresql left behind 717s ok 12 - No files in /var/log/postgresql left behind 717s ok 13 - PostgreSQL TCP ports are closed 717s ok 14 - Next free port is 5432 717s ### End test 180_ecpg.t ### 717s 717s ### PostgreSQL test 190_pg_buildext.t ### 718s ok 1 - make clean 718s ok 2 - make tar 718s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 718s # testing 'dh --with pgxs' 720s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 720s ok 5 - postgresql-17-foo_123-1_s390x.deb was built 727s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 727s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 727s ok 8 - dpkg -i postgresql-17-foo_123-1_s390x.deb 734s ok 9 - cd foo-123 && pg_buildext installcheck 734s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 741s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 741s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 748s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 748s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 748s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 748s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 748s ok 17 - dpkg -r postgresql-17-foo 748s # testing 'dh --with pgxs_loop' 748s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 750s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 750s ok 20 - postgresql-17-foo_123-1_s390x.deb was built 750s ok 21 - make clean 750s # testing pg_buildext updatecontrol 750s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 750s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 750s 1..23 750s ### End test 190_pg_buildext.t ### 750s 750s ### PostgreSQL test 200_maintscripts.t ### 750s 1..15 750s # We are running systemd 753s ok 1 - pg_createcluster 17 main --start 753s ok 2 - postmaster PID is 22922 754s ok 3 - apt-get update -q 754s # postgresql-common: 754s # Installed: 279 754s # Candidate: 279 754s # Version table: 754s # *** 279 500 754s # 500 http://ftpmaster.internal/ubuntu questing/main s390x Packages 754s # 100 /var/lib/dpkg/status 757s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 757s # postgresql-common: 757s # Installed: 279 757s # Candidate: 279 757s # Version table: 757s # *** 279 500 757s # 500 http://ftpmaster.internal/ubuntu questing/main s390x Packages 757s # 100 /var/lib/dpkg/status 757s ok 5 - postmaster PID is 22922 757s ok 6 - postmaster was not restarted 758s ok 7 - pg_dropcluster 17 main --stop 758s # Cleanup 758s ok 8 - Cleanup: No clusters left behind 758s ok 9 - No postgres processes left behind 758s ok 10 - No files in /etc/postgresql left behind 758s ok 11 - No files in /var/lib/postgresql left behind 758s ok 12 - No files in /var/run/postgresql left behind 758s ok 13 - No files in /var/log/postgresql left behind 758s ok 14 - PostgreSQL TCP ports are closed 758s ok 15 - Next free port is 5432 758s ### End test 200_maintscripts.t ### 758s 758s autopkgtest [22:51:20]: test run-testsuite: -----------------------] 761s autopkgtest [22:51:23]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 761s run-testsuite PASS 764s autopkgtest [22:51:26]: @@@@@@@@@@@@@@@@@@@@ summary 764s default-psql FAIL stderr: ************************************************************************** 764s run-testsuite PASS 807s nova [W] Using flock in prodstack6-s390x 807s Creating nova instance adt-questing-s390x-postgresql-common-20250619-223839-juju-7f2275-prod-proposed-migration-environment-21-4a55144d-0ad6-4ca9-bc8e-d27ec14f4c4b from image adt/ubuntu-questing-s390x-server-20250619.img (UUID b2d9a05b-cfd4-46d9-a087-051a022c2256)... 807s nova [W] Timed out waiting for 1316a59a-4e4e-4d1d-8e93-16e6ed1a6c97 to get deleted. 807s nova [W] Using flock in prodstack6-s390x 807s Creating nova instance adt-questing-s390x-postgresql-common-20250619-223839-juju-7f2275-prod-proposed-migration-environment-21-4a55144d-0ad6-4ca9-bc8e-d27ec14f4c4b from image adt/ubuntu-questing-s390x-server-20250619.img (UUID b2d9a05b-cfd4-46d9-a087-051a022c2256)... 807s nova [W] Timed out waiting for 0a07f633-e3b5-4c2e-835c-76c0799b42b9 to get deleted.