0s autopkgtest [01:31:10]: starting date and time: 2025-06-19 01:31:10+0000 0s autopkgtest [01:31:10]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [01:31:10]: host juju-7f2275-prod-proposed-migration-environment-23; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.80c52wxo/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-23@bos03-arm64-19.secgroup --name adt-questing-arm64-postgresql-common-20250619-011316-juju-7f2275-prod-proposed-migration-environment-23-80e35bf6-087e-4e44-874c-d7a138b58420 --image adt/ubuntu-questing-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-23 --net-id=net_prod-proposed-migration -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 97s autopkgtest [01:32:47]: testbed dpkg architecture: arm64 97s autopkgtest [01:32:47]: testbed apt version: 3.1.2 97s autopkgtest [01:32:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 97s autopkgtest [01:32:47]: testbed release detected to be: None 98s autopkgtest [01:32:48]: updating testbed package index (apt update) 98s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 99s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 99s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 99s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 99s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 99s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 99s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 99s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [404 kB] 99s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [65.2 kB] 99s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted arm64 Packages [18.2 kB] 99s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [360 kB] 99s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [23.7 kB] 99s Fetched 1178 kB in 1s (1387 kB/s) 100s Reading package lists... 101s autopkgtest [01:32:51]: upgrading testbed (apt dist-upgrade and autopurge) 101s Reading package lists... 101s Building dependency tree... 101s Reading state information... 101s Calculating upgrade... 102s The following packages will be upgraded: 102s libproc2-0 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 102s procps 102s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 102s Need to get 5949 kB of archives. 102s After this operation, 283 kB disk space will be freed. 102s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 libproc2-0 arm64 2:4.0.4-8ubuntu1 [59.6 kB] 102s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 procps arm64 2:4.0.4-8ubuntu1 [710 kB] 102s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12t64 arm64 3.12.10-1 [2314 kB] 102s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12-stdlib arm64 3.12.10-1 [2029 kB] 103s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12-minimal arm64 3.12.10-1 [836 kB] 103s Fetched 5949 kB in 1s (5854 kB/s) 103s (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 ... 118766 files and directories currently installed.) 103s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_arm64.deb ... 103s Unpacking libproc2-0:arm64 (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 103s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_arm64.deb ... 104s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 104s Preparing to unpack .../libpython3.12t64_3.12.10-1_arm64.deb ... 104s Unpacking libpython3.12t64:arm64 (3.12.10-1) over (3.12.8-3) ... 104s Preparing to unpack .../libpython3.12-stdlib_3.12.10-1_arm64.deb ... 104s Unpacking libpython3.12-stdlib:arm64 (3.12.10-1) over (3.12.8-3) ... 104s Preparing to unpack .../libpython3.12-minimal_3.12.10-1_arm64.deb ... 104s Unpacking libpython3.12-minimal:arm64 (3.12.10-1) over (3.12.8-3) ... 104s Setting up libpython3.12-minimal:arm64 (3.12.10-1) ... 104s Setting up libproc2-0:arm64 (2:4.0.4-8ubuntu1) ... 104s Setting up procps (2:4.0.4-8ubuntu1) ... 104s Setting up libpython3.12-stdlib:arm64 (3.12.10-1) ... 104s Setting up libpython3.12t64:arm64 (3.12.10-1) ... 104s Processing triggers for systemd (257.6-1ubuntu1) ... 105s Processing triggers for man-db (2.13.1-1) ... 106s Processing triggers for libc-bin (2.41-6ubuntu2) ... 106s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s Solving dependencies... 107s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s autopkgtest [01:32:57]: rebooting testbed after setup commands that affected boot 130s autopkgtest [01:33:20]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 133s autopkgtest [01:33:23]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 138s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (dsc) [2385 B] 138s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (tar) [218 kB] 138s gpgv: Signature made Thu Jun 12 19:04:12 2025 UTC 138s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 138s gpgv: Can't check signature: No public key 138s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_279.dsc: no acceptable signature found 138s autopkgtest [01:33:28]: testing package postgresql-common version 279 138s autopkgtest [01:33:28]: build not needed 139s autopkgtest [01:33:29]: test default-psql: preparing testbed 139s Reading package lists... 139s Building dependency tree... 139s Reading state information... 139s Solving dependencies... 140s The following NEW packages will be installed: 140s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 140s postgresql-17 postgresql-client-17 postgresql-client-common 140s postgresql-common postgresql-common-dev ssl-cert 140s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 140s Need to get 20.7 MB of archives. 140s After this operation, 76.6 MB of additional disk space will be used. 140s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 140s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-common all 279 [48.1 kB] 140s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 140s Get:4 http://ftpmaster.internal/ubuntu questing/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 140s Get:5 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common-dev all 279 [73.6 kB] 140s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 140s Get:7 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common all 279 [101 kB] 141s Get:8 http://ftpmaster.internal/ubuntu questing/main arm64 libpq5 arm64 17.5-1build1 [252 kB] 141s Get:9 http://ftpmaster.internal/ubuntu questing/main arm64 libxslt1.1 arm64 1.1.43-0exp1 [161 kB] 141s Get:10 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-17 arm64 17.5-1build1 [2123 kB] 142s Get:11 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-17 arm64 17.5-1build1 [17.7 MB] 148s Get:12 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql all 17+279 [16.6 kB] 148s Preconfiguring packages ... 148s /var/cache/debconf/tmp.ci/postgresql.config.mPraKu: 12: pg_lsclusters: not found 148s Fetched 20.7 MB in 8s (2536 kB/s) 148s Selecting previously unselected package libjson-perl. 149s (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 ... 118766 files and directories currently installed.) 149s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 149s Unpacking libjson-perl (4.10000-1) ... 149s Selecting previously unselected package postgresql-client-common. 149s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 149s Unpacking postgresql-client-common (279) ... 149s Selecting previously unselected package libio-pty-perl. 149s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 149s Unpacking libio-pty-perl (1:1.20-1build3) ... 149s Selecting previously unselected package libipc-run-perl. 149s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 149s Unpacking libipc-run-perl (20231003.0-2) ... 149s Selecting previously unselected package postgresql-common-dev. 149s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 149s Unpacking postgresql-common-dev (279) ... 149s Selecting previously unselected package ssl-cert. 149s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 149s Unpacking ssl-cert (1.1.3ubuntu1) ... 149s Selecting previously unselected package postgresql-common. 149s Preparing to unpack .../06-postgresql-common_279_all.deb ... 149s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 149s Unpacking postgresql-common (279) ... 149s Selecting previously unselected package libpq5:arm64. 149s Preparing to unpack .../07-libpq5_17.5-1build1_arm64.deb ... 149s Unpacking libpq5:arm64 (17.5-1build1) ... 149s Selecting previously unselected package libxslt1.1:arm64. 149s Preparing to unpack .../08-libxslt1.1_1.1.43-0exp1_arm64.deb ... 149s Unpacking libxslt1.1:arm64 (1.1.43-0exp1) ... 149s Selecting previously unselected package postgresql-client-17. 149s Preparing to unpack .../09-postgresql-client-17_17.5-1build1_arm64.deb ... 149s Unpacking postgresql-client-17 (17.5-1build1) ... 149s Selecting previously unselected package postgresql-17. 149s Preparing to unpack .../10-postgresql-17_17.5-1build1_arm64.deb ... 149s Unpacking postgresql-17 (17.5-1build1) ... 150s Selecting previously unselected package postgresql. 150s Preparing to unpack .../11-postgresql_17+279_all.deb ... 150s Unpacking postgresql (17+279) ... 150s Setting up postgresql-client-common (279) ... 150s Setting up libio-pty-perl (1:1.20-1build3) ... 150s Setting up libpq5:arm64 (17.5-1build1) ... 150s Setting up ssl-cert (1.1.3ubuntu1) ... 151s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 151s Setting up libipc-run-perl (20231003.0-2) ... 151s Setting up libjson-perl (4.10000-1) ... 151s Setting up libxslt1.1:arm64 (1.1.43-0exp1) ... 151s Setting up postgresql-common-dev (279) ... 151s Setting up postgresql-client-17 (17.5-1build1) ... 152s 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 152s Setting up postgresql-common (279) ... 152s Creating config file /etc/postgresql-common/createcluster.conf with new version 152s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 152s Removing obsolete dictionary files: 153s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 153s Setting up postgresql-17 (17.5-1build1) ... 154s Creating new PostgreSQL cluster 17/main ... 154s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 154s The files belonging to this database system will be owned by user "postgres". 154s This user must also own the server process. 154s 154s The database cluster will be initialized with locale "C.UTF-8". 154s The default database encoding has accordingly been set to "UTF8". 154s The default text search configuration will be set to "english". 154s 154s Data page checksums are disabled. 154s 154s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 154s creating subdirectories ... ok 154s selecting dynamic shared memory implementation ... posix 154s selecting default "max_connections" ... 100 154s selecting default "shared_buffers" ... 128MB 154s selecting default time zone ... Etc/UTC 154s creating configuration files ... ok 154s running bootstrap script ... ok 155s performing post-bootstrap initialization ... ok 155s syncing data to disk ... ok 158s Setting up postgresql (17+279) ... 158s Processing triggers for man-db (2.13.1-1) ... 159s Processing triggers for libc-bin (2.41-6ubuntu2) ... 160s autopkgtest [01:33:50]: test default-psql: [----------------------- 160s ************************************************************************** 160s # A new feature in cloud-init identified possible datasources for # 160s # this system as: # 160s # [] # 160s # However, the datasource used was: OpenStack # 160s # # 160s # In the future, cloud-init will only attempt to use datasources that # 160s # are identified or specifically configured. # 160s # For more information see # 160s # https://bugs.launchpad.net/bugs/1669675 # 160s # # 160s # If you are seeing this message, please file a bug against # 160s # cloud-init at # 160s # https://github.com/canonical/cloud-init/issues # 160s # Make sure to include the cloud provider your instance is # 160s # running on. # 160s # # 160s # After you have filed a bug, you can disable this warning by launching # 160s # your instance with the cloud-config below, or putting that content # 160s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 160s # # 160s # #cloud-config # 160s # warnings: # 160s # dsid_missing_source: off # 160s ************************************************************************** 160s 160s Disable the warnings above by: 160s touch /root/.cloud-warnings.skip 160s or 160s touch /var/lib/cloud/instance/warnings/.skip 160s ************************************************************************** 160s # A new feature in cloud-init identified possible datasources for # 160s # this system as: # 160s # [] # 160s # However, the datasource used was: OpenStack # 160s # # 160s # In the future, cloud-init will only attempt to use datasources that # 160s # are identified or specifically configured. # 160s # For more information see # 160s # https://bugs.launchpad.net/bugs/1669675 # 160s # # 160s # If you are seeing this message, please file a bug against # 160s # cloud-init at # 160s # https://github.com/canonical/cloud-init/issues # 160s # Make sure to include the cloud provider your instance is # 160s # running on. # 160s # # 160s # After you have filed a bug, you can disable this warning by launching # 160s # your instance with the cloud-config below, or putting that content # 160s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 160s # # 160s # #cloud-config # 160s # warnings: # 160s # dsid_missing_source: off # 160s ************************************************************************** 160s 160s Disable the warnings above by: 160s touch /var/lib/postgresql/.cloud-warnings.skip 160s or 160s touch /var/lib/cloud/instance/warnings/.skip 161s autopkgtest [01:33:51]: test default-psql: -----------------------] 161s default-psql FAIL stderr: ************************************************************************** 161s autopkgtest [01:33:51]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 161s autopkgtest [01:33:51]: test default-psql: - - - - - - - - - - stderr - - - - - - - - - - 161s ************************************************************************** 161s # A new feature in cloud-init identified possible datasources for # 161s # this system as: # 161s # [] # 161s # However, the datasource used was: OpenStack # 161s # # 161s # In the future, cloud-init will only attempt to use datasources that # 161s # are identified or specifically configured. # 161s # For more information see # 161s # https://bugs.launchpad.net/bugs/1669675 # 161s # # 161s # If you are seeing this message, please file a bug against # 161s # cloud-init at # 161s # https://github.com/canonical/cloud-init/issues # 161s # Make sure to include the cloud provider your instance is # 161s # running on. # 161s # # 161s # After you have filed a bug, you can disable this warning by launching # 161s # your instance with the cloud-config below, or putting that content # 161s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 161s # # 161s # #cloud-config # 161s # warnings: # 161s # dsid_missing_source: off # 161s ************************************************************************** 161s 161s Disable the warnings above by: 161s touch /var/lib/postgresql/.cloud-warnings.skip 161s or 161s touch /var/lib/cloud/instance/warnings/.skip 162s autopkgtest [01:33:52]: test run-testsuite: preparing testbed 277s autopkgtest [01:35:47]: testbed dpkg architecture: arm64 277s autopkgtest [01:35:47]: testbed apt version: 3.1.2 277s autopkgtest [01:35:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 278s autopkgtest [01:35:48]: testbed release detected to be: questing 278s autopkgtest [01:35:48]: updating testbed package index (apt update) 279s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 279s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 279s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 279s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 279s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [404 kB] 279s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 279s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 279s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 279s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [65.2 kB] 279s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted arm64 Packages [18.2 kB] 279s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [360 kB] 279s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [23.7 kB] 280s Fetched 1178 kB in 1s (1317 kB/s) 281s Reading package lists... 282s autopkgtest [01:35:52]: upgrading testbed (apt dist-upgrade and autopurge) 282s Reading package lists... 282s Building dependency tree... 282s Reading state information... 282s Calculating upgrade... 283s The following packages will be upgraded: 283s libproc2-0 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 283s procps 283s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 283s Need to get 5949 kB of archives. 283s After this operation, 283 kB disk space will be freed. 283s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 libproc2-0 arm64 2:4.0.4-8ubuntu1 [59.6 kB] 283s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 procps arm64 2:4.0.4-8ubuntu1 [710 kB] 283s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12t64 arm64 3.12.10-1 [2314 kB] 284s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12-stdlib arm64 3.12.10-1 [2029 kB] 284s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 libpython3.12-minimal arm64 3.12.10-1 [836 kB] 284s Fetched 5949 kB in 1s (7752 kB/s) 284s (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 ... 118766 files and directories currently installed.) 284s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_arm64.deb ... 284s Unpacking libproc2-0:arm64 (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 285s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_arm64.deb ... 285s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 285s Preparing to unpack .../libpython3.12t64_3.12.10-1_arm64.deb ... 285s Unpacking libpython3.12t64:arm64 (3.12.10-1) over (3.12.8-3) ... 285s Preparing to unpack .../libpython3.12-stdlib_3.12.10-1_arm64.deb ... 285s Unpacking libpython3.12-stdlib:arm64 (3.12.10-1) over (3.12.8-3) ... 285s Preparing to unpack .../libpython3.12-minimal_3.12.10-1_arm64.deb ... 285s Unpacking libpython3.12-minimal:arm64 (3.12.10-1) over (3.12.8-3) ... 285s Setting up libpython3.12-minimal:arm64 (3.12.10-1) ... 285s Setting up libproc2-0:arm64 (2:4.0.4-8ubuntu1) ... 285s Setting up procps (2:4.0.4-8ubuntu1) ... 286s Setting up libpython3.12-stdlib:arm64 (3.12.10-1) ... 286s Setting up libpython3.12t64:arm64 (3.12.10-1) ... 286s Processing triggers for systemd (257.6-1ubuntu1) ... 286s Processing triggers for man-db (2.13.1-1) ... 288s Processing triggers for libc-bin (2.41-6ubuntu2) ... 288s Reading package lists... 289s Building dependency tree... 289s Reading state information... 289s Solving dependencies... 290s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 291s autopkgtest [01:36:01]: rebooting testbed after setup commands that affected boot 317s Reading package lists... 317s Building dependency tree... 317s Reading state information... 317s Solving dependencies... 317s The following NEW packages will be installed: 317s autoconf automake autopoint autotools-dev build-essential clang-20 cpp 317s cpp-14 cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 317s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 317s fakeroot g++ g++-14 g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 317s gcc-14 gcc-14-aarch64-linux-gnu gcc-14-base gcc-aarch64-linux-gnu gettext 317s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libcc1-0 317s libclang-common-20-dev libclang1-20 libdebhelper-perl libecpg-compat3 317s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 317s libgc1 libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl 317s libisl23 libitm1 libjson-perl liblsan0 liblzma-dev libmpc3 libncurses-dev 317s libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libssl-dev 318s libstdc++-14-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 318s llvm-20 llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools 318s locales-all m4 po-debconf postgresql-17 postgresql-all postgresql-client-17 318s postgresql-client-common postgresql-common postgresql-common-dev 318s postgresql-doc postgresql-doc-17 postgresql-plperl-17 318s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 318s postgresql-server-dev-all ssl-cert zlib1g-dev 318s 0 upgraded, 92 newly installed, 0 to remove and 0 not upgraded. 318s Need to get 187 MB of archives. 318s After this operation, 1141 MB of additional disk space will be used. 318s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 318s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-common all 279 [48.1 kB] 318s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 318s Get:4 http://ftpmaster.internal/ubuntu questing/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 318s Get:5 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common-dev all 279 [73.6 kB] 318s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 318s Get:7 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common all 279 [101 kB] 318s Get:8 http://ftpmaster.internal/ubuntu questing/main arm64 m4 arm64 1.4.19-8 [244 kB] 318s Get:9 http://ftpmaster.internal/ubuntu questing/main arm64 autoconf all 2.72-3.1ubuntu1 [384 kB] 318s Get:10 http://ftpmaster.internal/ubuntu questing/main arm64 autotools-dev all 20240727.1 [43.4 kB] 318s Get:11 http://ftpmaster.internal/ubuntu questing/main arm64 automake all 1:1.17-4ubuntu1 [572 kB] 318s Get:12 http://ftpmaster.internal/ubuntu questing/main arm64 autopoint all 0.23.1-2build1 [619 kB] 318s Get:13 http://ftpmaster.internal/ubuntu questing/main arm64 gcc-14-base arm64 14.3.0-1ubuntu1 [55.8 kB] 318s Get:14 http://ftpmaster.internal/ubuntu questing/main arm64 libisl23 arm64 0.27-1 [676 kB] 318s Get:15 http://ftpmaster.internal/ubuntu questing/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 318s Get:16 http://ftpmaster.internal/ubuntu questing/main arm64 cpp-14-aarch64-linux-gnu arm64 14.3.0-1ubuntu1 [10.6 MB] 319s Get:17 http://ftpmaster.internal/ubuntu questing/main arm64 cpp-14 arm64 14.3.0-1ubuntu1 [1030 B] 319s Get:18 http://ftpmaster.internal/ubuntu questing/main arm64 cpp-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [5558 B] 319s Get:19 http://ftpmaster.internal/ubuntu questing/main arm64 cpp arm64 4:14.2.0-1ubuntu1 [22.4 kB] 319s Get:20 http://ftpmaster.internal/ubuntu questing/main arm64 libcc1-0 arm64 15.1.0-5ubuntu1 [49.1 kB] 319s Get:21 http://ftpmaster.internal/ubuntu questing/main arm64 libgomp1 arm64 15.1.0-5ubuntu1 [147 kB] 319s Get:22 http://ftpmaster.internal/ubuntu questing/main arm64 libitm1 arm64 15.1.0-5ubuntu1 [28.1 kB] 319s Get:23 http://ftpmaster.internal/ubuntu questing/main arm64 libasan8 arm64 15.1.0-5ubuntu1 [2922 kB] 319s Get:24 http://ftpmaster.internal/ubuntu questing/main arm64 liblsan0 arm64 15.1.0-5ubuntu1 [1316 kB] 319s Get:25 http://ftpmaster.internal/ubuntu questing/main arm64 libtsan2 arm64 15.1.0-5ubuntu1 [2688 kB] 319s Get:26 http://ftpmaster.internal/ubuntu questing/main arm64 libubsan1 arm64 15.1.0-5ubuntu1 [1176 kB] 319s Get:27 http://ftpmaster.internal/ubuntu questing/main arm64 libhwasan0 arm64 15.1.0-5ubuntu1 [1638 kB] 319s Get:28 http://ftpmaster.internal/ubuntu questing/main arm64 libgcc-14-dev arm64 14.3.0-1ubuntu1 [2591 kB] 319s Get:29 http://ftpmaster.internal/ubuntu questing/main arm64 gcc-14-aarch64-linux-gnu arm64 14.3.0-1ubuntu1 [20.9 MB] 319s Get:30 http://ftpmaster.internal/ubuntu questing/main arm64 gcc-14 arm64 14.3.0-1ubuntu1 [538 kB] 319s Get:31 http://ftpmaster.internal/ubuntu questing/main arm64 gcc-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [1200 B] 319s Get:32 http://ftpmaster.internal/ubuntu questing/main arm64 gcc arm64 4:14.2.0-1ubuntu1 [4998 B] 319s Get:33 http://ftpmaster.internal/ubuntu questing/main arm64 libstdc++-14-dev arm64 14.3.0-1ubuntu1 [2795 kB] 320s Get:34 http://ftpmaster.internal/ubuntu questing/main arm64 g++-14-aarch64-linux-gnu arm64 14.3.0-1ubuntu1 [12.1 MB] 320s Get:35 http://ftpmaster.internal/ubuntu questing/main arm64 g++-14 arm64 14.3.0-1ubuntu1 [27.4 kB] 320s Get:36 http://ftpmaster.internal/ubuntu questing/main arm64 g++-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [956 B] 320s Get:37 http://ftpmaster.internal/ubuntu questing/main arm64 g++ arm64 4:14.2.0-1ubuntu1 [1080 B] 320s Get:38 http://ftpmaster.internal/ubuntu questing/main arm64 build-essential arm64 12.12ubuntu1 [5082 B] 320s Get:39 http://ftpmaster.internal/ubuntu questing/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 320s Get:40 http://ftpmaster.internal/ubuntu questing/universe arm64 libobjc4 arm64 15.1.0-5ubuntu1 [45.6 kB] 320s Get:41 http://ftpmaster.internal/ubuntu questing/universe arm64 libobjc-14-dev arm64 14.3.0-1ubuntu1 [190 kB] 320s Get:42 http://ftpmaster.internal/ubuntu questing/universe arm64 libclang-common-20-dev arm64 1:20.1.6-0ubuntu1 [778 kB] 320s Get:43 http://ftpmaster.internal/ubuntu questing/universe arm64 llvm-20-linker-tools arm64 1:20.1.6-0ubuntu1 [1242 kB] 320s Get:44 http://ftpmaster.internal/ubuntu questing/universe arm64 libclang1-20 arm64 1:20.1.6-0ubuntu1 [7982 kB] 320s Get:45 http://ftpmaster.internal/ubuntu questing/universe arm64 clang-20 arm64 1:20.1.6-0ubuntu1 [76.5 kB] 320s Get:46 http://ftpmaster.internal/ubuntu questing/main arm64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 320s Get:47 http://ftpmaster.internal/ubuntu questing/main arm64 libtool all 2.5.4-4 [168 kB] 320s Get:48 http://ftpmaster.internal/ubuntu questing/main arm64 dh-autoreconf all 20 [16.1 kB] 320s Get:49 http://ftpmaster.internal/ubuntu questing/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 320s Get:50 http://ftpmaster.internal/ubuntu questing/main arm64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 320s Get:51 http://ftpmaster.internal/ubuntu questing/main arm64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 320s Get:52 http://ftpmaster.internal/ubuntu questing/main arm64 debugedit arm64 1:5.1-2 [46.1 kB] 320s Get:53 http://ftpmaster.internal/ubuntu questing/main arm64 dwz arm64 0.15-1build6 [113 kB] 320s Get:54 http://ftpmaster.internal/ubuntu questing/main arm64 gettext arm64 0.23.1-2build1 [1456 kB] 320s Get:55 http://ftpmaster.internal/ubuntu questing/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 320s Get:56 http://ftpmaster.internal/ubuntu questing/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 320s Get:57 http://ftpmaster.internal/ubuntu questing/main arm64 debhelper all 13.24.2ubuntu1 [896 kB] 320s Get:58 http://ftpmaster.internal/ubuntu questing/main arm64 emacsen-common all 3.0.8 [13.9 kB] 320s Get:59 http://ftpmaster.internal/ubuntu questing/main arm64 dictionaries-common all 1.30.10 [178 kB] 320s Get:60 http://ftpmaster.internal/ubuntu questing/main arm64 libfakeroot arm64 1.37.1.2-1 [33.8 kB] 320s Get:61 http://ftpmaster.internal/ubuntu questing/main arm64 fakeroot arm64 1.37.1.2-1 [67.4 kB] 320s Get:62 http://ftpmaster.internal/ubuntu questing/main arm64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 320s Get:63 http://ftpmaster.internal/ubuntu questing/main arm64 libpgtypes3 arm64 17.5-1build1 [44.3 kB] 320s Get:64 http://ftpmaster.internal/ubuntu questing/main arm64 libpq5 arm64 17.5-1build1 [252 kB] 320s Get:65 http://ftpmaster.internal/ubuntu questing/main arm64 libecpg6 arm64 17.5-1build1 [63.2 kB] 320s Get:66 http://ftpmaster.internal/ubuntu questing/main arm64 libecpg-compat3 arm64 17.5-1build1 [16.5 kB] 320s Get:67 http://ftpmaster.internal/ubuntu questing/main arm64 libssl-dev arm64 3.5.0-2ubuntu1 [3457 kB] 320s Get:68 http://ftpmaster.internal/ubuntu questing/main arm64 libpq-dev arm64 17.5-1build1 [162 kB] 320s Get:69 http://ftpmaster.internal/ubuntu questing/main arm64 libecpg-dev arm64 17.5-1build1 [322 kB] 320s Get:70 http://ftpmaster.internal/ubuntu questing/main arm64 libncurses-dev arm64 6.5+20250216-2 [389 kB] 320s Get:71 http://ftpmaster.internal/ubuntu questing/main arm64 libtcl8.6 arm64 8.6.16+dfsg-1 [987 kB] 320s Get:72 http://ftpmaster.internal/ubuntu questing/main arm64 liblzma-dev arm64 5.8.1-1build1 [181 kB] 320s Get:73 http://ftpmaster.internal/ubuntu questing/main arm64 zlib1g-dev arm64 1:1.3.dfsg+really1.3.1-1ubuntu1 [894 kB] 320s Get:74 http://ftpmaster.internal/ubuntu questing/main arm64 libxml2-dev arm64 2.14.3+dfsg-0exp3 [68.6 kB] 320s Get:75 http://ftpmaster.internal/ubuntu questing/main arm64 libxslt1.1 arm64 1.1.43-0exp1 [161 kB] 320s Get:76 http://ftpmaster.internal/ubuntu questing/universe arm64 llvm-20-runtime arm64 1:20.1.6-0ubuntu1 [537 kB] 320s Get:77 http://ftpmaster.internal/ubuntu questing/universe arm64 libpfm4 arm64 4.13.0+git99-gc5587f9-1 [82.5 kB] 320s Get:78 http://ftpmaster.internal/ubuntu questing/universe arm64 llvm-20 arm64 1:20.1.6-0ubuntu1 [18.9 MB] 321s Get:79 http://ftpmaster.internal/ubuntu questing/main arm64 libffi-dev arm64 3.4.8-2 [59.7 kB] 321s Get:80 http://ftpmaster.internal/ubuntu questing/universe arm64 llvm-20-tools arm64 1:20.1.6-0ubuntu1 [512 kB] 321s Get:81 http://ftpmaster.internal/ubuntu questing/universe arm64 llvm-20-dev arm64 1:20.1.6-0ubuntu1 [48.0 MB] 322s Get:82 http://ftpmaster.internal/ubuntu questing/universe arm64 locales-all arm64 2.41-6ubuntu2 [11.2 MB] 322s Get:83 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-17 arm64 17.5-1build1 [2123 kB] 322s Get:84 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-17 arm64 17.5-1build1 [17.7 MB] 323s Get:85 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-server-dev-17 arm64 17.5-1build1 [1393 kB] 323s Get:86 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-server-dev-all all 279 [1626 B] 323s Get:87 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-plperl-17 arm64 17.5-1build1 [88.4 kB] 323s Get:88 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-plpython3-17 arm64 17.5-1build1 [116 kB] 323s Get:89 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-pltcl-17 arm64 17.5-1build1 [44.0 kB] 323s Get:90 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-all all 279 [1706 B] 323s Get:91 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-doc-17 all 17.5-1build1 [2137 kB] 323s Get:92 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-doc all 17+279 [13.8 kB] 323s Preconfiguring packages ... 324s Fetched 187 MB in 5s (34.9 MB/s) 324s Selecting previously unselected package libjson-perl. 324s (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 ... 118766 files and directories currently installed.) 324s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 324s Unpacking libjson-perl (4.10000-1) ... 324s Selecting previously unselected package postgresql-client-common. 324s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 324s Unpacking postgresql-client-common (279) ... 324s Selecting previously unselected package libio-pty-perl. 324s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 324s Unpacking libio-pty-perl (1:1.20-1build3) ... 324s Selecting previously unselected package libipc-run-perl. 324s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 324s Unpacking libipc-run-perl (20231003.0-2) ... 324s Selecting previously unselected package postgresql-common-dev. 324s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 324s Unpacking postgresql-common-dev (279) ... 324s Selecting previously unselected package ssl-cert. 324s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 324s Unpacking ssl-cert (1.1.3ubuntu1) ... 324s Selecting previously unselected package postgresql-common. 324s Preparing to unpack .../06-postgresql-common_279_all.deb ... 324s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 324s Unpacking postgresql-common (279) ... 324s Selecting previously unselected package m4. 324s Preparing to unpack .../07-m4_1.4.19-8_arm64.deb ... 324s Unpacking m4 (1.4.19-8) ... 324s Selecting previously unselected package autoconf. 324s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 324s Unpacking autoconf (2.72-3.1ubuntu1) ... 324s Selecting previously unselected package autotools-dev. 324s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 324s Unpacking autotools-dev (20240727.1) ... 324s Selecting previously unselected package automake. 325s Preparing to unpack .../10-automake_1%3a1.17-4ubuntu1_all.deb ... 325s Unpacking automake (1:1.17-4ubuntu1) ... 325s Selecting previously unselected package autopoint. 325s Preparing to unpack .../11-autopoint_0.23.1-2build1_all.deb ... 325s Unpacking autopoint (0.23.1-2build1) ... 325s Selecting previously unselected package gcc-14-base:arm64. 325s Preparing to unpack .../12-gcc-14-base_14.3.0-1ubuntu1_arm64.deb ... 325s Unpacking gcc-14-base:arm64 (14.3.0-1ubuntu1) ... 325s Selecting previously unselected package libisl23:arm64. 325s Preparing to unpack .../13-libisl23_0.27-1_arm64.deb ... 325s Unpacking libisl23:arm64 (0.27-1) ... 325s Selecting previously unselected package libmpc3:arm64. 325s Preparing to unpack .../14-libmpc3_1.3.1-1build2_arm64.deb ... 325s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 325s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 325s Preparing to unpack .../15-cpp-14-aarch64-linux-gnu_14.3.0-1ubuntu1_arm64.deb ... 325s Unpacking cpp-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 325s Selecting previously unselected package cpp-14. 325s Preparing to unpack .../16-cpp-14_14.3.0-1ubuntu1_arm64.deb ... 325s Unpacking cpp-14 (14.3.0-1ubuntu1) ... 325s Selecting previously unselected package cpp-aarch64-linux-gnu. 325s Preparing to unpack .../17-cpp-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 325s Unpacking cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 325s Selecting previously unselected package cpp. 325s Preparing to unpack .../18-cpp_4%3a14.2.0-1ubuntu1_arm64.deb ... 325s Unpacking cpp (4:14.2.0-1ubuntu1) ... 325s Selecting previously unselected package libcc1-0:arm64. 325s Preparing to unpack .../19-libcc1-0_15.1.0-5ubuntu1_arm64.deb ... 325s Unpacking libcc1-0:arm64 (15.1.0-5ubuntu1) ... 325s Selecting previously unselected package libgomp1:arm64. 325s Preparing to unpack .../20-libgomp1_15.1.0-5ubuntu1_arm64.deb ... 325s Unpacking libgomp1:arm64 (15.1.0-5ubuntu1) ... 325s Selecting previously unselected package libitm1:arm64. 325s Preparing to unpack .../21-libitm1_15.1.0-5ubuntu1_arm64.deb ... 325s Unpacking libitm1:arm64 (15.1.0-5ubuntu1) ... 325s Selecting previously unselected package libasan8:arm64. 325s Preparing to unpack .../22-libasan8_15.1.0-5ubuntu1_arm64.deb ... 325s Unpacking libasan8:arm64 (15.1.0-5ubuntu1) ... 325s Selecting previously unselected package liblsan0:arm64. 325s Preparing to unpack .../23-liblsan0_15.1.0-5ubuntu1_arm64.deb ... 325s Unpacking liblsan0:arm64 (15.1.0-5ubuntu1) ... 326s Selecting previously unselected package libtsan2:arm64. 326s Preparing to unpack .../24-libtsan2_15.1.0-5ubuntu1_arm64.deb ... 326s Unpacking libtsan2:arm64 (15.1.0-5ubuntu1) ... 326s Selecting previously unselected package libubsan1:arm64. 326s Preparing to unpack .../25-libubsan1_15.1.0-5ubuntu1_arm64.deb ... 326s Unpacking libubsan1:arm64 (15.1.0-5ubuntu1) ... 326s Selecting previously unselected package libhwasan0:arm64. 326s Preparing to unpack .../26-libhwasan0_15.1.0-5ubuntu1_arm64.deb ... 326s Unpacking libhwasan0:arm64 (15.1.0-5ubuntu1) ... 326s Selecting previously unselected package libgcc-14-dev:arm64. 326s Preparing to unpack .../27-libgcc-14-dev_14.3.0-1ubuntu1_arm64.deb ... 326s Unpacking libgcc-14-dev:arm64 (14.3.0-1ubuntu1) ... 326s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 326s Preparing to unpack .../28-gcc-14-aarch64-linux-gnu_14.3.0-1ubuntu1_arm64.deb ... 326s Unpacking gcc-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 326s Selecting previously unselected package gcc-14. 326s Preparing to unpack .../29-gcc-14_14.3.0-1ubuntu1_arm64.deb ... 326s Unpacking gcc-14 (14.3.0-1ubuntu1) ... 326s Selecting previously unselected package gcc-aarch64-linux-gnu. 326s Preparing to unpack .../30-gcc-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 326s Unpacking gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 326s Selecting previously unselected package gcc. 326s Preparing to unpack .../31-gcc_4%3a14.2.0-1ubuntu1_arm64.deb ... 326s Unpacking gcc (4:14.2.0-1ubuntu1) ... 327s Selecting previously unselected package libstdc++-14-dev:arm64. 327s Preparing to unpack .../32-libstdc++-14-dev_14.3.0-1ubuntu1_arm64.deb ... 327s Unpacking libstdc++-14-dev:arm64 (14.3.0-1ubuntu1) ... 327s Selecting previously unselected package g++-14-aarch64-linux-gnu. 327s Preparing to unpack .../33-g++-14-aarch64-linux-gnu_14.3.0-1ubuntu1_arm64.deb ... 327s Unpacking g++-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 327s Selecting previously unselected package g++-14. 327s Preparing to unpack .../34-g++-14_14.3.0-1ubuntu1_arm64.deb ... 327s Unpacking g++-14 (14.3.0-1ubuntu1) ... 327s Selecting previously unselected package g++-aarch64-linux-gnu. 327s Preparing to unpack .../35-g++-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 327s Unpacking g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 327s Selecting previously unselected package g++. 327s Preparing to unpack .../36-g++_4%3a14.2.0-1ubuntu1_arm64.deb ... 327s Unpacking g++ (4:14.2.0-1ubuntu1) ... 327s Selecting previously unselected package build-essential. 327s Preparing to unpack .../37-build-essential_12.12ubuntu1_arm64.deb ... 327s Unpacking build-essential (12.12ubuntu1) ... 327s Selecting previously unselected package libgc1:arm64. 327s Preparing to unpack .../38-libgc1_1%3a8.2.8-1_arm64.deb ... 327s Unpacking libgc1:arm64 (1:8.2.8-1) ... 327s Selecting previously unselected package libobjc4:arm64. 327s Preparing to unpack .../39-libobjc4_15.1.0-5ubuntu1_arm64.deb ... 327s Unpacking libobjc4:arm64 (15.1.0-5ubuntu1) ... 327s Selecting previously unselected package libobjc-14-dev:arm64. 327s Preparing to unpack .../40-libobjc-14-dev_14.3.0-1ubuntu1_arm64.deb ... 327s Unpacking libobjc-14-dev:arm64 (14.3.0-1ubuntu1) ... 327s Selecting previously unselected package libclang-common-20-dev:arm64. 327s Preparing to unpack .../41-libclang-common-20-dev_1%3a20.1.6-0ubuntu1_arm64.deb ... 327s Unpacking libclang-common-20-dev:arm64 (1:20.1.6-0ubuntu1) ... 327s Selecting previously unselected package llvm-20-linker-tools. 328s Preparing to unpack .../42-llvm-20-linker-tools_1%3a20.1.6-0ubuntu1_arm64.deb ... 328s Unpacking llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 328s Selecting previously unselected package libclang1-20. 328s Preparing to unpack .../43-libclang1-20_1%3a20.1.6-0ubuntu1_arm64.deb ... 328s Unpacking libclang1-20 (1:20.1.6-0ubuntu1) ... 328s Selecting previously unselected package clang-20. 328s Preparing to unpack .../44-clang-20_1%3a20.1.6-0ubuntu1_arm64.deb ... 328s Unpacking clang-20 (1:20.1.6-0ubuntu1) ... 328s Selecting previously unselected package libdebhelper-perl. 328s Preparing to unpack .../45-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 328s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 328s Selecting previously unselected package libtool. 328s Preparing to unpack .../46-libtool_2.5.4-4_all.deb ... 328s Unpacking libtool (2.5.4-4) ... 328s Selecting previously unselected package dh-autoreconf. 328s Preparing to unpack .../47-dh-autoreconf_20_all.deb ... 328s Unpacking dh-autoreconf (20) ... 328s Selecting previously unselected package libarchive-zip-perl. 328s Preparing to unpack .../48-libarchive-zip-perl_1.68-1_all.deb ... 328s Unpacking libarchive-zip-perl (1.68-1) ... 328s Selecting previously unselected package libfile-stripnondeterminism-perl. 328s Preparing to unpack .../49-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 328s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 328s Selecting previously unselected package dh-strip-nondeterminism. 328s Preparing to unpack .../50-dh-strip-nondeterminism_1.14.1-2_all.deb ... 328s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 328s Selecting previously unselected package debugedit. 328s Preparing to unpack .../51-debugedit_1%3a5.1-2_arm64.deb ... 328s Unpacking debugedit (1:5.1-2) ... 328s Selecting previously unselected package dwz. 328s Preparing to unpack .../52-dwz_0.15-1build6_arm64.deb ... 328s Unpacking dwz (0.15-1build6) ... 328s Selecting previously unselected package gettext. 328s Preparing to unpack .../53-gettext_0.23.1-2build1_arm64.deb ... 328s Unpacking gettext (0.23.1-2build1) ... 328s Selecting previously unselected package intltool-debian. 328s Preparing to unpack .../54-intltool-debian_0.35.0+20060710.6_all.deb ... 328s Unpacking intltool-debian (0.35.0+20060710.6) ... 328s Selecting previously unselected package po-debconf. 329s Preparing to unpack .../55-po-debconf_1.0.21+nmu1_all.deb ... 329s Unpacking po-debconf (1.0.21+nmu1) ... 329s Selecting previously unselected package debhelper. 329s Preparing to unpack .../56-debhelper_13.24.2ubuntu1_all.deb ... 329s Unpacking debhelper (13.24.2ubuntu1) ... 329s Selecting previously unselected package emacsen-common. 329s Preparing to unpack .../57-emacsen-common_3.0.8_all.deb ... 329s Unpacking emacsen-common (3.0.8) ... 329s Selecting previously unselected package dictionaries-common. 329s Preparing to unpack .../58-dictionaries-common_1.30.10_all.deb ... 329s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 329s Unpacking dictionaries-common (1.30.10) ... 329s Selecting previously unselected package libfakeroot:arm64. 329s Preparing to unpack .../59-libfakeroot_1.37.1.2-1_arm64.deb ... 329s Unpacking libfakeroot:arm64 (1.37.1.2-1) ... 329s Selecting previously unselected package fakeroot. 329s Preparing to unpack .../60-fakeroot_1.37.1.2-1_arm64.deb ... 329s Unpacking fakeroot (1.37.1.2-1) ... 329s Selecting previously unselected package hunspell-en-us. 329s Preparing to unpack .../61-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 329s Unpacking hunspell-en-us (1:2020.12.07-4) ... 329s Selecting previously unselected package libpgtypes3:arm64. 329s Preparing to unpack .../62-libpgtypes3_17.5-1build1_arm64.deb ... 329s Unpacking libpgtypes3:arm64 (17.5-1build1) ... 329s Selecting previously unselected package libpq5:arm64. 329s Preparing to unpack .../63-libpq5_17.5-1build1_arm64.deb ... 329s Unpacking libpq5:arm64 (17.5-1build1) ... 329s Selecting previously unselected package libecpg6:arm64. 329s Preparing to unpack .../64-libecpg6_17.5-1build1_arm64.deb ... 329s Unpacking libecpg6:arm64 (17.5-1build1) ... 329s Selecting previously unselected package libecpg-compat3:arm64. 329s Preparing to unpack .../65-libecpg-compat3_17.5-1build1_arm64.deb ... 329s Unpacking libecpg-compat3:arm64 (17.5-1build1) ... 329s Selecting previously unselected package libssl-dev:arm64. 329s Preparing to unpack .../66-libssl-dev_3.5.0-2ubuntu1_arm64.deb ... 329s Unpacking libssl-dev:arm64 (3.5.0-2ubuntu1) ... 329s Selecting previously unselected package libpq-dev. 329s Preparing to unpack .../67-libpq-dev_17.5-1build1_arm64.deb ... 329s Unpacking libpq-dev (17.5-1build1) ... 329s Selecting previously unselected package libecpg-dev. 329s Preparing to unpack .../68-libecpg-dev_17.5-1build1_arm64.deb ... 329s Unpacking libecpg-dev (17.5-1build1) ... 329s Selecting previously unselected package libncurses-dev:arm64. 329s Preparing to unpack .../69-libncurses-dev_6.5+20250216-2_arm64.deb ... 329s Unpacking libncurses-dev:arm64 (6.5+20250216-2) ... 330s Selecting previously unselected package libtcl8.6:arm64. 330s Preparing to unpack .../70-libtcl8.6_8.6.16+dfsg-1_arm64.deb ... 330s Unpacking libtcl8.6:arm64 (8.6.16+dfsg-1) ... 330s Selecting previously unselected package liblzma-dev:arm64. 330s Preparing to unpack .../71-liblzma-dev_5.8.1-1build1_arm64.deb ... 330s Unpacking liblzma-dev:arm64 (5.8.1-1build1) ... 330s Selecting previously unselected package zlib1g-dev:arm64. 330s Preparing to unpack .../72-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_arm64.deb ... 330s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 330s Selecting previously unselected package libxml2-dev:arm64. 330s Preparing to unpack .../73-libxml2-dev_2.14.3+dfsg-0exp3_arm64.deb ... 330s Unpacking libxml2-dev:arm64 (2.14.3+dfsg-0exp3) ... 330s Selecting previously unselected package libxslt1.1:arm64. 330s Preparing to unpack .../74-libxslt1.1_1.1.43-0exp1_arm64.deb ... 330s Unpacking libxslt1.1:arm64 (1.1.43-0exp1) ... 330s Selecting previously unselected package llvm-20-runtime. 330s Preparing to unpack .../75-llvm-20-runtime_1%3a20.1.6-0ubuntu1_arm64.deb ... 330s Unpacking llvm-20-runtime (1:20.1.6-0ubuntu1) ... 330s Selecting previously unselected package libpfm4:arm64. 330s Preparing to unpack .../76-libpfm4_4.13.0+git99-gc5587f9-1_arm64.deb ... 330s Unpacking libpfm4:arm64 (4.13.0+git99-gc5587f9-1) ... 330s Selecting previously unselected package llvm-20. 330s Preparing to unpack .../77-llvm-20_1%3a20.1.6-0ubuntu1_arm64.deb ... 330s Unpacking llvm-20 (1:20.1.6-0ubuntu1) ... 331s Selecting previously unselected package libffi-dev:arm64. 331s Preparing to unpack .../78-libffi-dev_3.4.8-2_arm64.deb ... 331s Unpacking libffi-dev:arm64 (3.4.8-2) ... 331s Selecting previously unselected package llvm-20-tools. 331s Preparing to unpack .../79-llvm-20-tools_1%3a20.1.6-0ubuntu1_arm64.deb ... 331s Unpacking llvm-20-tools (1:20.1.6-0ubuntu1) ... 331s Selecting previously unselected package llvm-20-dev. 331s Preparing to unpack .../80-llvm-20-dev_1%3a20.1.6-0ubuntu1_arm64.deb ... 331s Unpacking llvm-20-dev (1:20.1.6-0ubuntu1) ... 333s Selecting previously unselected package locales-all. 333s Preparing to unpack .../81-locales-all_2.41-6ubuntu2_arm64.deb ... 333s Unpacking locales-all (2.41-6ubuntu2) ... 334s Selecting previously unselected package postgresql-client-17. 334s Preparing to unpack .../82-postgresql-client-17_17.5-1build1_arm64.deb ... 334s Unpacking postgresql-client-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-17. 335s Preparing to unpack .../83-postgresql-17_17.5-1build1_arm64.deb ... 335s Unpacking postgresql-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-server-dev-17. 335s Preparing to unpack .../84-postgresql-server-dev-17_17.5-1build1_arm64.deb ... 335s Unpacking postgresql-server-dev-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-server-dev-all. 335s Preparing to unpack .../85-postgresql-server-dev-all_279_all.deb ... 335s Unpacking postgresql-server-dev-all (279) ... 335s Selecting previously unselected package postgresql-plperl-17. 335s Preparing to unpack .../86-postgresql-plperl-17_17.5-1build1_arm64.deb ... 335s Unpacking postgresql-plperl-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-plpython3-17. 335s Preparing to unpack .../87-postgresql-plpython3-17_17.5-1build1_arm64.deb ... 335s Unpacking postgresql-plpython3-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-pltcl-17. 335s Preparing to unpack .../88-postgresql-pltcl-17_17.5-1build1_arm64.deb ... 335s Unpacking postgresql-pltcl-17 (17.5-1build1) ... 335s Selecting previously unselected package postgresql-all. 336s Preparing to unpack .../89-postgresql-all_279_all.deb ... 336s Unpacking postgresql-all (279) ... 336s Selecting previously unselected package postgresql-doc-17. 336s Preparing to unpack .../90-postgresql-doc-17_17.5-1build1_all.deb ... 336s Unpacking postgresql-doc-17 (17.5-1build1) ... 336s Selecting previously unselected package postgresql-doc. 336s Preparing to unpack .../91-postgresql-doc_17+279_all.deb ... 336s Unpacking postgresql-doc (17+279) ... 336s Setting up postgresql-client-common (279) ... 336s Setting up libpgtypes3:arm64 (17.5-1build1) ... 336s Setting up libncurses-dev:arm64 (6.5+20250216-2) ... 336s Setting up libio-pty-perl (1:1.20-1build3) ... 336s Setting up gcc-14-base:arm64 (14.3.0-1ubuntu1) ... 336s Setting up libarchive-zip-perl (1.68-1) ... 336s Setting up libclang-common-20-dev:arm64 (1:20.1.6-0ubuntu1) ... 336s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 336s Setting up postgresql-doc-17 (17.5-1build1) ... 336s 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 336s Setting up libpq5:arm64 (17.5-1build1) ... 336s Setting up m4 (1.4.19-8) ... 336s Setting up llvm-20-runtime (1:20.1.6-0ubuntu1) ... 336s Setting up libgomp1:arm64 (15.1.0-5ubuntu1) ... 336s Setting up libffi-dev:arm64 (3.4.8-2) ... 336s Setting up locales-all (2.41-6ubuntu2) ... 336s Setting up libfakeroot:arm64 (1.37.1.2-1) ... 336s Setting up llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 336s Setting up fakeroot (1.37.1.2-1) ... 336s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 336s Setting up llvm-20-tools (1:20.1.6-0ubuntu1) ... 336s Setting up autotools-dev (20240727.1) ... 336s Setting up libpfm4:arm64 (4.13.0+git99-gc5587f9-1) ... 336s Setting up emacsen-common (3.0.8) ... 336s Setting up ssl-cert (1.1.3ubuntu1) ... 337s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 337s Setting up llvm-20 (1:20.1.6-0ubuntu1) ... 337s Setting up libssl-dev:arm64 (3.5.0-2ubuntu1) ... 337s Setting up libmpc3:arm64 (1.3.1-1build2) ... 337s Setting up libtcl8.6:arm64 (8.6.16+dfsg-1) ... 337s Setting up autopoint (0.23.1-2build1) ... 337s Setting up libipc-run-perl (20231003.0-2) ... 337s Setting up libgc1:arm64 (1:8.2.8-1) ... 337s Setting up autoconf (2.72-3.1ubuntu1) ... 337s Setting up liblzma-dev:arm64 (5.8.1-1build1) ... 337s Setting up libubsan1:arm64 (15.1.0-5ubuntu1) ... 337s Setting up zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 337s Setting up dwz (0.15-1build6) ... 337s Setting up libhwasan0:arm64 (15.1.0-5ubuntu1) ... 337s Setting up libasan8:arm64 (15.1.0-5ubuntu1) ... 337s Setting up libjson-perl (4.10000-1) ... 337s Setting up postgresql-doc (17+279) ... 337s Setting up libxslt1.1:arm64 (1.1.43-0exp1) ... 337s Setting up debugedit (1:5.1-2) ... 337s Setting up libecpg6:arm64 (17.5-1build1) ... 337s Setting up libtsan2:arm64 (15.1.0-5ubuntu1) ... 337s Setting up libisl23:arm64 (0.27-1) ... 337s Setting up libclang1-20 (1:20.1.6-0ubuntu1) ... 337s Setting up libcc1-0:arm64 (15.1.0-5ubuntu1) ... 337s Setting up liblsan0:arm64 (15.1.0-5ubuntu1) ... 337s Setting up libitm1:arm64 (15.1.0-5ubuntu1) ... 337s Setting up postgresql-common-dev (279) ... 337s Setting up automake (1:1.17-4ubuntu1) ... 337s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 337s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 337s Setting up gettext (0.23.1-2build1) ... 337s Setting up libecpg-compat3:arm64 (17.5-1build1) ... 337s Setting up dictionaries-common (1.30.10) ... 337s Setting up postgresql-client-17 (17.5-1build1) ... 338s 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 338s Setting up libpq-dev (17.5-1build1) ... 338s Setting up libobjc4:arm64 (15.1.0-5ubuntu1) ... 338s Setting up libecpg-dev (17.5-1build1) ... 338s Setting up intltool-debian (0.35.0+20060710.6) ... 338s Setting up libxml2-dev:arm64 (2.14.3+dfsg-0exp3) ... 338s Setting up postgresql-common (279) ... 339s Creating config file /etc/postgresql-common/createcluster.conf with new version 339s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 339s en_us 339s Removing obsolete dictionary files: 340s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 340s Setting up llvm-20-dev (1:20.1.6-0ubuntu1) ... 340s Setting up dh-strip-nondeterminism (1.14.1-2) ... 340s Setting up cpp-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 340s Setting up hunspell-en-us (1:2020.12.07-4) ... 340s Setting up libgcc-14-dev:arm64 (14.3.0-1ubuntu1) ... 340s Setting up libstdc++-14-dev:arm64 (14.3.0-1ubuntu1) ... 340s Setting up postgresql-17 (17.5-1build1) ... 341s Creating new PostgreSQL cluster 17/main ... 341s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 341s The files belonging to this database system will be owned by user "postgres". 341s This user must also own the server process. 341s 341s The database cluster will be initialized with locale "C.UTF-8". 341s The default database encoding has accordingly been set to "UTF8". 341s The default text search configuration will be set to "english". 341s 341s Data page checksums are disabled. 341s 341s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 341s creating subdirectories ... ok 341s selecting dynamic shared memory implementation ... posix 341s selecting default "max_connections" ... 100 341s selecting default "shared_buffers" ... 128MB 341s selecting default time zone ... Etc/UTC 341s creating configuration files ... ok 342s running bootstrap script ... ok 342s performing post-bootstrap initialization ... ok 342s syncing data to disk ... ok 345s Setting up po-debconf (1.0.21+nmu1) ... 345s Setting up libobjc-14-dev:arm64 (14.3.0-1ubuntu1) ... 345s Setting up cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 345s Setting up cpp-14 (14.3.0-1ubuntu1) ... 345s Setting up postgresql-plpython3-17 (17.5-1build1) ... 345s Setting up postgresql-plperl-17 (17.5-1build1) ... 345s Setting up cpp (4:14.2.0-1ubuntu1) ... 345s Setting up gcc-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 345s Setting up clang-20 (1:20.1.6-0ubuntu1) ... 345s Setting up gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 345s Setting up postgresql-pltcl-17 (17.5-1build1) ... 345s Setting up g++-14-aarch64-linux-gnu (14.3.0-1ubuntu1) ... 345s Setting up libtool (2.5.4-4) ... 345s Setting up gcc-14 (14.3.0-1ubuntu1) ... 345s Setting up dh-autoreconf (20) ... 345s Setting up postgresql-server-dev-17 (17.5-1build1) ... 345s Setting up g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 345s Setting up g++-14 (14.3.0-1ubuntu1) ... 345s Setting up postgresql-server-dev-all (279) ... 345s Setting up debhelper (13.24.2ubuntu1) ... 345s Setting up postgresql-all (279) ... 345s Setting up gcc (4:14.2.0-1ubuntu1) ... 345s Setting up g++ (4:14.2.0-1ubuntu1) ... 345s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 345s Setting up build-essential (12.12ubuntu1) ... 345s Processing triggers for libc-bin (2.41-6ubuntu2) ... 345s Processing triggers for systemd (257.6-1ubuntu1) ... 345s Processing triggers for man-db (2.13.1-1) ... 348s Processing triggers for install-info (7.1.1-1) ... 348s Processing triggers for dictionaries-common (1.30.10) ... 351s autopkgtest [01:37:01]: test run-testsuite: [----------------------- 351s ************************************************************************** 351s # A new feature in cloud-init identified possible datasources for # 351s # this system as: # 351s # [] # 351s # However, the datasource used was: OpenStack # 351s # # 351s # In the future, cloud-init will only attempt to use datasources that # 351s # are identified or specifically configured. # 351s # For more information see # 351s # https://bugs.launchpad.net/bugs/1669675 # 351s # # 351s # If you are seeing this message, please file a bug against # 351s # cloud-init at # 351s # https://github.com/canonical/cloud-init/issues # 351s # Make sure to include the cloud provider your instance is # 351s # running on. # 351s # # 351s # After you have filed a bug, you can disable this warning by launching # 351s # your instance with the cloud-config below, or putting that content # 351s # into /etc/cloud/cloud.cfg.d/99-warnings.cfg # 351s # # 351s # #cloud-config # 351s # warnings: # 351s # dsid_missing_source: off # 351s ************************************************************************** 351s 351s Disable the warnings above by: 351s touch /root/.cloud-warnings.skip 351s or 351s touch /var/lib/cloud/instance/warnings/.skip 351s ====== Running all tests with umask 077 ======= 351s ### PostgreSQL test 001_packages.t ### 351s 1..23 351s ok 1 - /etc/os-release exists 351s ok 2 - OS is ubuntu 351s ok 3 - OS version is 25.10 351s # PostgreSQL versions installed: 17 351s # 17 351s ok 4 - postgresql-17 installed 351s ok 5 - postgresql-plpython3-17 installed 351s ok 6 - postgresql-plperl-17 installed 351s ok 7 - postgresql-pltcl-17 installed 351s ok 8 # skip No postgresql-17-jit package for version 17 351s ok 9 - postgresql-server-dev-17 installed 351s ok 10 # skip No postgresql-contrib-17 package for version 17 351s # postgresql-doc-17 installed 351s ok 11 - At least one doc package installed 351s ok 12 - libecpg-dev installed 351s ok 13 - postgresql-common-dev installed 351s ok 14 - procps installed 351s ok 15 - netcat-openbsd installed 352s ok 16 - hunspell-en-us installed 352s ok 17 - system has a default UTF-8 locale 352s ok 18 - locale ru_RU exists 352s ok 19 - locale ru_RU.UTF-8 exists 352s ok 20 - user postgres in the UNIX group ssl-cert 352s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 352s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 352s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 352s ### End test 001_packages.t ### 352s 352s ### PostgreSQL test 002_existing_clusters.t ### 352s 1..8 352s # Cleanup 352s ok 1 - Cleanup: No clusters left behind 352s ok 2 - No postgres processes left behind 352s ok 3 - No files in /etc/postgresql left behind 352s ok 4 - No files in /var/lib/postgresql left behind 352s ok 5 - No files in /var/run/postgresql left behind 352s ok 6 - No files in /var/log/postgresql left behind 352s ok 7 - PostgreSQL TCP ports are closed 352s ok 8 - Next free port is 5432 352s ### End test 002_existing_clusters.t ### 352s 352s ### PostgreSQL test 003_alternatives.t ### 352s 1..9 352s # Newest PG version installed is 17 352s ok 1 - psql.1.gz link group 352s ok 2 - postmaster.1.gz link group does not exist 352s ok 3 - psql.1.gz alternative 352s ok 4 - pg_dump.1.gz alternative 352s ok 5 - postgres.1.gz alternative 352s ok 6 - pg_ctl.1.gz alternative 352s # Newest PG doc version installed is 17 352s ok 7 - SPI_connect.3.gz link group 352s ok 8 - SPI_connect.3.gz alternative 352s ok 9 - SPI_exec.3.gz alternative 352s ### End test 003_alternatives.t ### 352s 352s ### PostgreSQL test 005_PgCommon.t ### 352s 1..24 352s ok 1 - correctly parsed line 'local all postgres ident sameuser' 352s ok 2 - correctly parsed line 'local foo nobody trust' 352s ok 3 - correctly parsed line 'local foo nobody crypt' 352s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 352s ok 5 - correctly parsed line 'local foo,bar nobody ident' 352s ok 6 - correctly parsed line 'local all +foogrp password' 352s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 352s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 352s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 352s ok 10 - @expected_records has correct number of entries 352s ok 11 - returned read_pg_hba array has correct number of records 352s ok 12 - line 'foo all all md5' parsed as invalid 352s ok 13 - line 'local all all foo' parsed as invalid 352s ok 14 - line 'host all all foo' parsed as invalid 352s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 352s ok 16 - line 'host all all md5' parsed as invalid 352s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 352s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 352s ok 19 - read_conf_file returns empty dict for nonexisting file 352s ok 20 - read_conf_file() parsing 352s ok 21 - read_conf_file() parsing with include directives 352s ok 22 - set_conf_value 352s ok 23 - disable_conf_value 352s ok 24 - replace_conf_value 352s ### End test 005_PgCommon.t ### 352s 352s ### PostgreSQL test 006_next_free_port.t ### 352s 1..5 352s ok 1 - next_free_port is 5432 353s ok 2 - next_free_port detects localhost ipv4 socket 354s ok 3 - next_free_port detects wildcard ipv4 socket 355s ok 4 - next_free_port detects localhost ipv6 socket 356s ok 5 - next_free_port detects wildcard ipv6 socket 356s ### End test 006_next_free_port.t ### 356s 356s ### PostgreSQL test 007_pg_conftool.t ### 356s 1..41 356s # test without cluster 356s ok 1 - pg_conftool show all 356s ok 2 - correct output of pg_conftool show all 356s ok 3 - pg_conftool foo.conf show all 356s ok 4 - correct output of pg_conftool foo.conf show all 356s ok 5 - pg_conftool /tmp/aYe5ZfyF7Q/different.conf show all 356s ok 6 - correct output of pg_conftool /tmp/aYe5ZfyF7Q/different.conf show all 356s ok 7 - pg_conftool 9.7 main show all 356s ok 8 - correct output of pg_conftool 9.7 main show all 356s # test show 356s ok 9 - pg_conftool show all 356s ok 10 - correct output of pg_conftool show all 356s ok 11 - pg_conftool other.conf show all 356s ok 12 - correct output of pg_conftool other.conf show all 356s ok 13 - pg_conftool /tmp/aYe5ZfyF7Q/different.conf show all 356s ok 14 - correct output of pg_conftool /tmp/aYe5ZfyF7Q/different.conf show all 356s ok 15 - pg_conftool 17 main show all 356s ok 16 - correct output of pg_conftool 17 main show all 357s ok 17 - pg_conftool 17 main other.conf show all 357s ok 18 - correct output of pg_conftool 17 main other.conf show all 357s ok 19 - pg_conftool show a 357s ok 20 - correct output of pg_conftool show a 357s ok 21 - pg_conftool -s show a 357s ok 22 - correct output of pg_conftool -s show a 357s # test set 357s ok 23 - pg_conftool set c 7 357s ok 24 - correct output of pg_conftool set c 7 357s ok 25 - file contains new setting 357s ok 26 - pg_conftool set a 8 357s ok 27 - correct output of pg_conftool set a 8 357s ok 28 - file contains updated setting 357s ok 29 - pg_conftool /tmp/aYe5ZfyF7Q/different.conf set a 9 357s ok 30 - correct output of pg_conftool /tmp/aYe5ZfyF7Q/different.conf set a 9 357s ok 31 - file with path contains updated setting 357s # test remove 357s ok 32 - pg_conftool remove a 357s ok 33 - correct output of pg_conftool remove a 357s ok 34 - setting removed from file 357s ok 35 - pg_conftool /tmp/aYe5ZfyF7Q/different.conf remove a 357s ok 36 - correct output of pg_conftool /tmp/aYe5ZfyF7Q/different.conf remove a 357s ok 37 - setting removed from file with path 357s # test edit 357s ok 38 - pg_conftool edit 357s ok 39 - correct output of pg_conftool edit 357s ok 40 - pg_conftool /tmp/aYe5ZfyF7Q/different.conf edit 357s ok 41 - correct output of pg_conftool /tmp/aYe5ZfyF7Q/different.conf edit 357s ### End test 007_pg_conftool.t ### 357s 357s ### PostgreSQL test 010_defaultport_cluster.t ### 357s 1..14 357s ok 1 - psql --version 357s ok 2 - pg_wrapper selects highest available version number 357s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 357s ok 4 - connecting to localhost fails with no clusters 357s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 357s ok 6 - pg_wrapper uses host and port from PGCLUSTER 357s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 357s ok 8 - pg_wrapper uses --cluster from the command line 357s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 357s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 357s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 357s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 357s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 357s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 357s ### End test 010_defaultport_cluster.t ### 357s 357s ### PostgreSQL test 015_start_stop.t ### 357s 1..71 357s # We are running systemd 357s # Running tests for 17 357s # Cluster does not exist yet 357s ok 1 - cluster 17 main does not exist 357s ok 2 - service postgresql@17-main does not exist 357s ok 3 - systemctl start postgresql 357s ok 4 - cluster 17 main does not exist 357s ok 5 - service postgresql@17-main does not exist 357s ok 6 - systemctl start postgresql@17-main 358s ok 7 - cluster 17 main does not exist 358s ok 8 - service postgresql@17-main does not exist 358s # Start/stop postgresql using system tools 359s ok 9 - pg_createcluster 17 main 359s ok 10 - cluster 17 main is stopped 359s ok 11 - service postgresql@17-main is stopped 361s ok 12 - systemctl start postgresql 361s ok 13 - cluster 17 main is running 361s ok 14 - service postgresql@17-main is running 361s ok 15 - systemctl start postgresql 361s ok 16 - cluster 17 main is already running 361s ok 17 - service postgresql@17-main is already running 361s ok 18 - systemctl stop postgresql 367s ok 19 - cluster 17 main is stopped 367s ok 20 - service postgresql@17-main is stopped 367s ok 21 - systemctl stop postgresql 367s ok 22 - cluster 17 main is already stopped 367s ok 23 - service postgresql@17-main is already stopped 367s # Start/stop specific cluster using system tools 370s ok 24 - systemctl start postgresql@17-main 370s ok 25 - cluster 17 main is running 370s ok 26 - service postgresql@17-main is running 370s ok 27 - systemctl start postgresql@17-main 370s ok 28 - cluster 17 main is running 370s ok 29 - service postgresql@17-main is running 372s ok 30 - systemctl restart postgresql@17-main 372s ok 31 - cluster 17 main is running 372s ok 32 - service postgresql@17-main is running 373s ok 33 - systemctl stop postgresql@17-main 373s ok 34 - cluster 17 main is stopped 373s ok 35 - service postgresql@17-main is stopped 373s ok 36 - systemctl stop postgresql@17-main 373s ok 37 - cluster 17 main is already stopped 373s ok 38 - service postgresql@17-main is already stopped 374s ok 39 - pg_dropcluster 17 main 374s ok 40 - cluster 17 main does not exist 374s ok 41 - service postgresql@17-main does not exist 374s # Start/stop specific cluster using pg_*cluster 374s ok 42 - pg_ctlcluster start 17 main 374s ok 43 - cluster 17 main does not exist 374s ok 44 - service postgresql@17-main does not exist 378s ok 45 - pg_createcluster 17 main --start 378s ok 46 - cluster 17 main is running 378s ok 47 - service postgresql@17-main is running 378s ok 48 - pg_ctlcluster 17 main start 378s ok 49 - cluster 17 main is already running 378s ok 50 - service postgresql@17-main is already running 380s ok 51 - pg_ctlcluster 17-main restart 380s ok 52 - cluster 17 main is running 380s ok 53 - service postgresql@17-main is running 381s ok 54 - pg_ctlcluster 17 main stop 381s ok 55 - cluster 17 main is stopped 381s ok 56 - service postgresql@17-main is stopped 381s ok 57 - pg_ctlcluster 17 main stop 381s ok 58 - cluster 17 main is already stopped 381s ok 59 - service postgresql@17-main is already stopped 383s ok 60 - pg_ctlcluster start 17-main 383s ok 61 - cluster 17 main is running 383s ok 62 - service postgresql@17-main is running 385s ok 63 - pg_dropcluster 17 main --stop 385s # Cleanup 385s ok 64 - Cleanup: No clusters left behind 385s ok 65 - No postgres processes left behind 385s ok 66 - No files in /etc/postgresql left behind 385s ok 67 - No files in /var/lib/postgresql left behind 385s ok 68 - No files in /var/run/postgresql left behind 385s ok 69 - No files in /var/log/postgresql left behind 385s ok 70 - PostgreSQL TCP ports are closed 385s ok 71 - Next free port is 5432 385s ### End test 015_start_stop.t ### 385s 385s ### PostgreSQL test 020_create_sql_remove.t ### 385s 1..141 385s # Running tests for 17 388s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.vsgrjn 388s ok 2 - pg_createcluster 17 main 388s ok 3 - Socket and pid file are in /var/run/postgresql/ 388s ok 4 - xlog/wal directory /tmp/17.xlog.vsgrjn was created 388s ok 5 - local method in pg_hba.conf is peer 388s ok 6 - host method in pg_hba.conf is scram-sha-256 388s ok 7 - Exactly one postgres master process running 391s ok 8 - pg_ctlcluster 17 main restart 391s ok 9 - cluster restarts with new environment file 391s ok 10 - Exactly one postgres master process running 391s ok 11 - correct value of PGEXTRAVAR1 in environment 391s ok 12 - correct value of PGEXTRAVAR2 in environment 391s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 391s ok 14 - createdb --version 391s ok 15 - pg_wrapper+createdb selects version number of cluster 391s ok 16 - psql --version 391s ok 17 - pg_wrapper+psql selects version 17 391s ok 18 - pg_lscluster reports online cluster on port 5432 391s ok 19 - log file is actually used 391s ok 20 - /etc/postgresql is owned by user "postgres" 391s ok 21 - version configuration directory file is owned by user "postgres" 391s ok 22 - configuration directory file is owned by user "postgres" 391s ok 23 - version data directory file is owned by user "postgres" 391s ok 24 - data directory file is owned by user "postgres" 391s ok 25 - log file has 0640 permissions 391s ok 26 - log file is owned by user "postgres" 391s ok 27 - log file is owned by group "adm" 391s ok 28 - no log symlink by default 391s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 391s ok 30 - pg_lsclusters -h 391s ok 31 - correct output of pg_lsclusters -h 391s ok 32 - stopping cluster 394s ok 33 - restarting cluster with nondefault log symlink 394s ok 34 - log target is used as log file 394s ok 35 - default log is not used 394s ok 36 - pg_lsclusters -h 394s ok 37 - correct output of pg_lsclusters -h 394s ok 38 - stopping cluster 397s ok 39 - restarting cluster with explicitly configured log file 397s ok 40 - default log is not used 397s ok 41 - log symlink target is used for startup message 397s ok 42 - exactly one log file 397s ok 43 - custom log is actually used 397s ok 44 - pg_lsclusters -h 397s ok 45 - correct output of pg_lsclusters -h 397s ok 46 - stopping cluster 397s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 397s ok 48 - /etc/postgres-hack was not created 399s ok 49 - restarting cluster 399s ok 50 - ps -o tty -U postgres h 399s ok 51 - postgres processes do not have an associated terminal 399s ok 52 - Server is linked with SSL support 399s ok 53 - SSL is enabled in postgresql.conf 399s ok 54 - psql -l fails for nobody 399s ok 55 - createuser nobody 399s ok 56 - createdb nobodydb 399s ok 57 - psql -ltA succeeds for nobody 399s ok 58 - psql -ltA output 399s ok 59 - SQL command: create table 399s ok 60 - SQL command: insert into table values 399s ok 61 - SQL command: insert into table values 399s ok 62 - primary key violation 400s ok 63 - psql -tAc "select * from phone order by name" nobodydb 400s ok 64 - SQL command output: select -tA 400s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 400s ok 66 - SQL command output: select -tx 400s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 400s ok 68 - SQL command output: select -tAx 400s ok 69 - CREATE EXTENSION plperlu fails for user nobody 400s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 400s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 400s ok 72 - creating PL/PerlU function as user nobody fails 400s ok 73 - creating unsafe PL/Perl function as user postgres fails 400s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 400s ok 75 - creating PL/PerlU function as user postgres succeeds 400s ok 76 - psql nobodydb -Atc "select read_file()" 400s ok 77 - calling PL/PerlU function 400s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 400s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 400s ok 80 - creating unsafe PL/Perl function as user nobody fails 400s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 400s ok 82 - creating PL/Perl function as user nobody succeeds 400s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 400s ok 84 - calling PL/Perl function 400s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 400s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 400s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 400s ok 88 - creating PL/Python3 function as user postgres succeeds 400s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 400s ok 90 - calling PL/Python function 401s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 401s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 401s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 401s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 401s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 401s ok 96 - creating PL/Tcl function as user nobody succeeds 401s 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;" 401s ok 98 - creating PL/TclU function as user postgres succeeds 401s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 401s ok 100 - calling PL/Tcl function 401s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 401s ok 102 - calling PL/TclU function 401s ok 103 - stopping cluster 401s ok 104 - pg_ctlcluster 17 main start 401s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 403s ok 106 - pg_ctlcluster 17 main start 403s ok 107 - cluster restarts with pgdata symlink 404s ok 108 - postgres master has OOM killer protection 404s ok 109 - postgres client backend has no OOM adjustment 404s ok 110 - ps h 6089 404s ok 111 - process title is idle 404s ok 112 - ps h 6089 404s ok 113 - process title is idle in transaction 404s ok 114 - stopping cluster 407s ok 115 - starting cluster as postgres works without a log file 407s ok 116 - log file got recreated and used 407s ok 117 - creating a directory in spc2 407s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.MG2S43'" 407s ok 119 - creating tablespace spc1 407s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 407s ok 121 - creating a table in spc1 407s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.USxTYB'" 407s ok 123 - creating tablespace spc2 407s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 407s ok 125 - creating a table in spc2 407s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 407s ok 127 - Correct apt NeverAutoRemove config 408s ok 128 - pg_dropcluster removes cluster 408s ok 129 - xlog/wal directory /tmp/17.xlog.vsgrjn was deleted 408s ok 130 - tablespace spc1 was emptied 408s ok 131 - tablespace spc2 was emptied 408s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 408s ok 133 - Correct apt NeverAutoRemove config 408s # Cleanup 408s ok 134 - Cleanup: No clusters left behind 408s ok 135 - No postgres processes left behind 408s ok 136 - No files in /etc/postgresql left behind 408s ok 137 - No files in /var/lib/postgresql left behind 408s ok 138 - No files in /var/run/postgresql left behind 408s ok 139 - No files in /var/log/postgresql left behind 408s ok 140 - PostgreSQL TCP ports are closed 408s ok 141 - Next free port is 5432 409s ### End test 020_create_sql_remove.t ### 409s 409s ### PostgreSQL test 021_pg_renamecluster.t ### 409s 1..20 412s ok 1 - pg_createcluster 17 main 415s ok 2 - pg_renamecluster 17 main donau 415s ok 3 - psql -tAc "show data_directory" 415s ok 4 - cluster is running and data_directory was moved 415s ok 5 - pg_hba.conf location updated 415s ok 6 - pg_ident.conf location updated 415s ok 7 - external_pid_file location updated 415s ok 8 - external_pid_file exists 415s ok 9 # skip no stats_temp_directory in 17 415s ok 10 # skip no stats_temp_directory in 17 415s ok 11 - cluster_name is updated 416s ok 12 - pg_dropcluster removes cluster 416s # Cleanup 416s ok 13 - Cleanup: No clusters left behind 416s ok 14 - No postgres processes left behind 416s ok 15 - No files in /etc/postgresql left behind 416s ok 16 - No files in /var/lib/postgresql left behind 416s ok 17 - No files in /var/run/postgresql left behind 416s ok 18 - No files in /var/log/postgresql left behind 416s ok 19 - PostgreSQL TCP ports are closed 416s ok 20 - Next free port is 5432 416s ### End test 021_pg_renamecluster.t ### 416s 416s ### PostgreSQL test 022_recovery.t ### 416s 1..17 416s # Running tests for 17 420s ok 1 - pg_createcluster 17 main --start >/dev/null 420s ok 2 - pg_ctlcluster 17 main stop -m i 422s ok 3 - pg_ctlcluster 17 main start 422s ok 4 - psql -c '' 423s ok 5 - pg_ctlcluster 17 main stop -m i 423s ok 6 - create write-protected file in data directory 425s ok 7 - pg_ctlcluster 17 main start 425s ok 8 - psql -c '' 427s ok 9 - pg_dropcluster removes cluster 427s # Cleanup 427s ok 10 - Cleanup: No clusters left behind 427s ok 11 - No postgres processes left behind 427s ok 12 - No files in /etc/postgresql left behind 427s ok 13 - No files in /var/lib/postgresql left behind 427s ok 14 - No files in /var/run/postgresql left behind 427s ok 15 - No files in /var/log/postgresql left behind 427s ok 16 - PostgreSQL TCP ports are closed 427s ok 17 - Next free port is 5432 427s ### End test 022_recovery.t ### 427s 427s ### PostgreSQL test 025_logging.t ### 427s 1..55 427s # Logging to /var/log/syslog works 427s # Running tests for 17 431s ok 1 - pg_createcluster 17 main 431s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 431s ok 3 - psql -qc "'foobar_17_7303'" 431s ok 4 - log an error 431s ok 5 - grep --binary-files=text foobar_17_7303 /var/log/postgresql/postgresql-17-main.log 431s ok 6 - error appears in logfile 431s ok 7 - pg_conftool 17 main set log_destination syslog 431s ok 8 - set log_destination syslog 431s ok 9 - pg_ctlcluster 17 main reload 431s ok 10 - 17 main reload 431s ok 11 - psql -Atc "show log_destination" 431s ok 12 - log_destination is syslog 431s ok 13 - pg_lscluster reports syslog 432s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 432s ok 15 - error appears in /var/log/syslog 432s ok 16 - pg_conftool 17 main set logging_collector on 432s ok 17 - set logging_collector on 432s ok 18 - pg_conftool 17 main set log_destination csvlog 432s ok 19 - set log_destination csvlog 434s ok 20 - pg_ctlcluster 17 main restart 434s ok 21 - 17 main restart 434s ok 22 - psql -Atc "show logging_collector" 434s ok 23 - logging_collector is on 435s ok 24 - psql -Atc "show log_destination" 435s ok 25 - log_destination is csvlog 435s ok 26 - pg_lscluster reports csvlog 435s ok 27 - psql -qc "'barbaz_17_7303'" 435s ok 28 - log an error 435s ok 29 - grep --binary-files=text barbaz_17_7303 /var/lib/postgresql/17/main/log/*.csv 435s ok 30 - error appears in log/*.csv 435s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 435s ok 32 - set log_destination stderr,syslog,csvlog 435s ok 33 - pg_ctlcluster 17 main reload 435s ok 34 - 17 main reload 435s ok 35 - psql -Atc "show log_destination" 435s ok 36 - log_destination is stderr,syslog,csvlog 435s ok 37 - pg_lscluster reports stderr,syslog,csvlog 435s ok 38 - psql -qc "'moo_17_7303'" 435s ok 39 - log an error 436s ok 40 - grep --binary-files=text moo_17_7303 /var/lib/postgresql/17/main/log/*.log 436s ok 41 - error appears in log/*.log 436s ok 42 - grep --binary-files=text 'postgres.*moo_17_7303' /var/log/syslog 436s ok 43 - error appears in /var/log/syslog 436s ok 44 - grep --binary-files=text moo_17_7303 /var/lib/postgresql/17/main/log/*.csv 436s ok 45 - error appears in log/*.csv 438s ok 46 - pg_dropcluster 17 main --stop 438s ok 47 - pg_dropcluster removes cluster 438s # Cleanup 438s ok 48 - Cleanup: No clusters left behind 438s ok 49 - No postgres processes left behind 438s ok 50 - No files in /etc/postgresql left behind 438s ok 51 - No files in /var/lib/postgresql left behind 438s ok 52 - No files in /var/run/postgresql left behind 438s ok 53 - No files in /var/log/postgresql left behind 438s ok 54 - PostgreSQL TCP ports are closed 438s ok 55 - Next free port is 5432 438s ### End test 025_logging.t ### 438s 438s ### PostgreSQL test 027_jit.t ### 438s # 17 442s ok 1 - pg_createcluster 17 main --start 442s ok 2 - psql -Xatc 'show jit' 442s ok 3 - JIT is on by default 442s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 442s ok 5 - No JIT on cheap query 442s ok 6 - pg_conftool 17 main set seq_page_cost 100000 442s ok 7 - pg_conftool 17 main set random_page_cost 100000 442s ok 8 - pg_ctlcluster 17 main reload 443s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 443s ok 10 - Expensive query is JITed 444s ok 11 - pg_dropcluster --stop 17 main 444s # Cleanup 444s ok 12 - Cleanup: No clusters left behind 444s ok 13 - No postgres processes left behind 444s ok 14 - No files in /etc/postgresql left behind 444s ok 15 - No files in /var/lib/postgresql left behind 444s ok 16 - No files in /var/run/postgresql left behind 444s ok 17 - No files in /var/log/postgresql left behind 444s ok 18 - PostgreSQL TCP ports are closed 444s ok 19 - Next free port is 5432 444s 1..19 444s ### End test 027_jit.t ### 444s 444s ### PostgreSQL test 030_errors.t ### 444s 1..156 444s ok 1 - pg_lscluster reports cluster without binaries 446s ok 2 - pg_dropcluster 6.3 main 447s ok 3 - pg_createcluster --socketdir 447s ok 4 - pg_lsclusters -h 447s ok 5 - cluster was created 447s ok 6 - Port of created cluster is 5432 447s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 447s ok 8 - pg_createcluster on existing cluster 447s ok 9 - pg_lsclusters -h 447s ok 10 - original cluster still exists 447s ok 11 - pg_createcluster 17 test -p foo 447s ok 12 - pg_createcluster -p checks that port option is numeric 447s ok 13 - pg_createcluster 17 test -p 42 447s ok 14 - pg_createcluster -p checks valid port range 447s ok 15 - pg_ctlcluster 17 main start 447s ok 16 - pg_ctlcluster refuses to start root-owned cluster 447s ok 17 - pg_ctlcluster 17 main start 447s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 447s ok 19 - pg_ctlcluster 17 main start 447s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 447s ok 21 - pg_ctlcluster 17 main start 447s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 449s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 449s ok 24 - No sockets in /var/run/postgresql 449s ok 25 - Socket is in /tmp/postgresql-testsuite/ 450s ok 26 - cluster stops with custom unix_socket_dir 450s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 452s ok 28 - cluster starts after removing unix_socket_dir 452s ok 29 - Socket is in default dir /var/run/postgresql 452s ok 30 - No sockets in /tmp/postgresql-testsuite/ 452s ok 31 - pg_ctlcluster 17 main stop 452s ok 32 - pg_ctlcluster fails with corrupted PID file 452s ok 33 - pg_lsclusters -h 452s ok 34 - cluster is still online 452s ok 35 - pg_ctlcluster succeeds with restored PID file 452s ok 36 - pg_lsclusters -h 452s ok 37 - cluster is down 452s ok 38 - pg_ctlcluster 17 main stop 452s ok 39 - pg_ctlcluster stop fails on stopped cluster 455s ok 40 - pg_ctlcluster 17 main start 455s ok 41 - pg_ctlcluster succeeds with already existing PID file 455s ok 42 - pg_lsclusters -h 455s ok 43 - cluster is online 455s ok 44 - pg_ctlcluster stop succeeds 455s ok 45 - pg_lsclusters -h 455s ok 46 - cluster is down 455s ok 47 - no pid file left 455s ok 48 - pg_ctlcluster 17 main stop 455s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 455s ok 50 - pid file was cleaned up 455s ok 51 - pg_ctlcluster --force 17 main stop 455s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 455s ok 53 - pid file was cleaned up 455s ok 54 - pg_ctlcluster 17 main stop 455s ok 55 - pg_ctlcluster stop succeeds with stale PID file 455s ok 56 - pid file was cleaned up 455s ok 57 - pg_ctlcluster --force 17 main stop 455s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 455s ok 59 - pid file was cleaned up 455s ok 60 - pg_ctlcluster --force 17 main stop 455s ok 61 - pg_ctlcluster stop succeeds with empty PID file 455s ok 62 - pid file was cleaned up 457s ok 63 - pg_ctlcluster 17 main start 457s ok 64 - pg_ctlcluster succeeds with corrupted PID file 457s ok 65 - pg_lsclusters -h 457s ok 66 - cluster is online 457s ok 67 - pg_ctlcluster 17 main start 457s ok 68 - pg_ctlcluster start fails on running cluster 458s ok 69 - pg_ctlcluster stop 458s ok 70 - pg_ctlcluster 17 main start 458s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 458s ok 72 - pg_ctlcluster 17 main stop 458s ok 73 - stopping cluster 464s ok 74 - pg_ctlcluster 17 main start 464s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 464s ok 76 - pg_ctlcluster 17 main stop 464s ok 77 - stopping cluster 464s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 464s ok 79 - pg_dropcluster 17 main 464s ok 80 - pg_dropcluster works as user postgres 465s ok 81 - pg_createcluster succeeds 466s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 466s ok 83 - proper error message for nonexisting /var/lib/postgresql 468s ok 84 - pg_ctlcluster 17 main start 468s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 468s ok 86 - pg_ctlcluster 17 main stop 468s ok 87 - stopping cluster 469s ok 88 - pg_createcluster other 471s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 473s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 474s ok 91 474s ok 92 - pg_ctlcluster 17 other start 474s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 474s ok 94 - pg_ctlcluster 17 main stop 474s ok 95 - stopping main cluster 476s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 478s ok 97 - pg_dropcluster other 479s ok 98 - pg_dropcluster 479s ok 99 - No sockets any more 479s ok 100 - 'pg_lsclusters 4.5 foo' fails 479s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 479s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 479s ok 103 - 'psql --cluster 4.5/foo' fails 479s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 479s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 479s ok 106 - 'psql --cluster 17/foo' fails 479s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 479s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 479s ok 109 - 'pg_dropcluster 4.5 foo' fails 479s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 479s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 479s ok 112 - 'pg_dropcluster 17 foo' fails 479s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 479s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 479s ok 115 - 'pg_upgradecluster 4.5 foo' fails 479s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 479s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 479s ok 118 - 'pg_upgradecluster 17 foo' fails 479s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 479s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 480s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 480s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 480s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 480s ok 124 - 'pg_ctlcluster 17 foo stop' fails 480s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 480s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 480s # Cleanup 480s ok 127 - Cleanup: No clusters left behind 480s ok 128 - No postgres processes left behind 480s ok 129 - No files in /etc/postgresql left behind 480s ok 130 - No files in /var/lib/postgresql left behind 480s ok 131 - No files in /var/run/postgresql left behind 480s ok 132 - No files in /var/log/postgresql left behind 480s ok 133 - PostgreSQL TCP ports are closed 480s ok 134 - Next free port is 5432 481s ok 135 - pg_dropcluster 17 broken 481s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 481s # Cleanup 481s ok 137 - Cleanup: No clusters left behind 481s ok 138 - No postgres processes left behind 481s ok 139 - No files in /etc/postgresql left behind 481s ok 140 - No files in /var/lib/postgresql left behind 481s ok 141 - No files in /var/run/postgresql left behind 481s ok 142 - No files in /var/log/postgresql left behind 481s ok 143 - PostgreSQL TCP ports are closed 481s ok 144 - Next free port is 5432 482s ok 145 - pg_dropcluster 17 broken 482s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 482s ok 147 - /etc/postgresql/17 was removed 482s ok 148 - /var/lib/postgresql/17 was removed 482s # Cleanup 482s ok 149 - Cleanup: No clusters left behind 482s ok 150 - No postgres processes left behind 482s ok 151 - No files in /etc/postgresql left behind 482s ok 152 - No files in /var/lib/postgresql left behind 482s ok 153 - No files in /var/run/postgresql left behind 482s ok 154 - No files in /var/log/postgresql left behind 482s ok 155 - PostgreSQL TCP ports are closed 482s ok 156 - Next free port is 5432 482s ### End test 030_errors.t ### 482s 482s ### PostgreSQL test 031_errors_disk_full.t ### 482s 1..22 482s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 484s ok 1 - script failed 484s ok 2 - pg_createcluster fails due to insufficient disk space 484s ok 3 - does not leave files behind 484s # Cleanup 484s ok 4 - Cleanup: No clusters left behind 484s ok 5 - No postgres processes left behind 484s ok 6 - No files in /etc/postgresql left behind 484s ok 7 - No files in /var/lib/postgresql left behind 484s ok 8 - No files in /var/run/postgresql left behind 484s ok 9 - No files in /var/log/postgresql left behind 484s ok 10 - PostgreSQL TCP ports are closed 484s ok 11 - Next free port is 5432 484s # check disk full conditions on startup 487s ok 12 - script failed 487s ok 13 - pg_ctlcluster prints error message 487s ok 14 - log file has error message 487s # Cleanup 487s ok 15 - Cleanup: No clusters left behind 487s ok 16 - No postgres processes left behind 487s ok 17 - No files in /etc/postgresql left behind 487s ok 18 - No files in /var/lib/postgresql left behind 487s ok 19 - No files in /var/run/postgresql left behind 487s ok 20 - No files in /var/log/postgresql left behind 487s ok 21 - PostgreSQL TCP ports are closed 487s ok 22 - Next free port is 5432 487s ### End test 031_errors_disk_full.t ### 487s 487s ### PostgreSQL test 032_ssl_key_permissions.t ### 487s 1..22 487s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 487s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 487s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 488s ok 4 - pg_createcluster 17 main 488s ok 5 - pg_ctlcluster 17 main start 488s ok 6 - ssl key owned by nobody refused 488s ok 7 - pg_ctlcluster 17 main start 488s ok 8 - ssl key with permissions root:root 0644 refused 488s ok 9 - pg_ctlcluster 17 main start 488s ok 10 - ssl key with permissions postgres:postgres 0640 refused 490s ok 11 - pg_dropcluster 17 main --stop 490s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 490s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 490s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 490s # Cleanup 490s ok 15 - Cleanup: No clusters left behind 490s ok 16 - No postgres processes left behind 490s ok 17 - No files in /etc/postgresql left behind 490s ok 18 - No files in /var/lib/postgresql left behind 490s ok 19 - No files in /var/run/postgresql left behind 490s ok 20 - No files in /var/log/postgresql left behind 490s ok 21 - PostgreSQL TCP ports are closed 490s ok 22 - Next free port is 5432 490s ### End test 032_ssl_key_permissions.t ### 490s 490s ### PostgreSQL test 040_upgrade.t ### 490s 1..1 490s ok 1 - only one major version installed, skipping upgrade tests 490s ### End test 040_upgrade.t ### 490s 490s ### PostgreSQL test 041_upgrade_custompaths.t ### 490s 1..1 490s ok 1 - only one major version installed, skipping upgrade tests 490s ### End test 041_upgrade_custompaths.t ### 490s 490s ### PostgreSQL test 042_upgrade_rename.t ### 490s 1..15 490s # PostgreSQL 17 494s ok 1 - pg_createcluster 17 main --start 500s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 500s ok 3 - pg_lsclusters -h 500s ok 4 - correct output of pg_lsclusters -h 501s ok 5 - pg_dropcluster 17 main --stop 503s ok 6 - pg_dropcluster 17 upgr --stop 503s ok 7 - Cleaning pg_upgrade log files 503s # Cleanup 503s ok 8 - Cleanup: No clusters left behind 503s ok 9 - No postgres processes left behind 503s ok 10 - No files in /etc/postgresql left behind 503s ok 11 - No files in /var/lib/postgresql left behind 503s ok 12 - No files in /var/run/postgresql left behind 503s ok 13 - No files in /var/log/postgresql left behind 503s ok 14 - PostgreSQL TCP ports are closed 503s ok 15 - Next free port is 5432 503s ### End test 042_upgrade_rename.t ### 503s 503s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 503s 1..1 503s ok 1 - only one major version installed, skipping upgrade tests 503s ### End test 043_upgrade_ssl_cert.t ### 503s 503s ### PostgreSQL test 045_backup.t ### 503s # We are running systemd 503s # PostgreSQL 17 503s # create cluster 507s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 507s ok 2 - pg_lsclusters -h 507s ok 3 - correct output of pg_lsclusters -h 507s ok 4 - pg_conftool 17 main set work_mem 11MB 507s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 507s ok 6 - psql -c 'alter database mydb set search_path=public' 507s ok 7 - psql -c 'create table foo (t text)' mydb 507s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 507s ok 9 - psql -c 'CREATE USER myuser' 507s ok 10 - psql -c 'grant create on database mydb to myuser' 507s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 507s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 507s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 507s # create directory 508s ok 14 - pg_backupcluster 17 main createdirectory 508s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 508s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 508s # dump 508s ok 17 - systemctl start pg_dump@17-main 508s ok 18 - dump created in /var/backups/postgresql/17-main/2025-06-19T013938Z.dump 508s ok 19 - /var/backups/postgresql/17-main/2025-06-19T013938Z.dump owned by uid postgres 508s ok 20 - /var/backups/postgresql/17-main/2025-06-19T013938Z.dump owned by gid postgres 508s # basebackup 508s ok 21 - systemctl start pg_receivewal@17-main 508s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 509s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 509s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 509s ok 25 - psql -c 'select pg_reload_conf()' 537s ok 26 - systemctl start pg_basebackup@17-main 537s ok 27 - dump created in /var/backups/postgresql/17-main/2025-06-19T013939Z.backup 537s ok 28 - /var/backups/postgresql/17-main/2025-06-19T013939Z.backup owned by uid postgres 537s ok 29 - /var/backups/postgresql/17-main/2025-06-19T013939Z.backup owned by gid postgres 537s # list 537s ok 30 - pg_backupcluster 17 main list 537s ok 31 - correct output of pg_backupcluster 17 main list 537s # more database changes 537s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 537s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 537s ok 34 - retrieve recovery timestamp 537s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 537s ok 36 - systemctl stop pg_receivewal@17-main 537s # restore /var/backups/postgresql/17-main/2025-06-19T013938Z.dump 539s ok 37 - pg_dropcluster 17 main --stop 543s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T013938Z.dump --start --datadir /var/lib/postgresql/17/snowflake 543s ok 39 - pg_lsclusters -h 543s ok 40 - correct output of pg_lsclusters -h 544s ok 41 - psql -XAtl 544s ok 42 - mydb locales 544s ok 43 - mydb grants 544s ok 44 - myicudb locales 544s ok 45 - psql -XAtc 'show work_mem' 544s ok 46 - correct output of psql -XAtc 'show work_mem' 544s ok 47 - psql -XAtc 'select * from foo' mydb 544s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 544s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 544s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 544s ok 51 - psql -XAtc '\drds' 544s ok 52 - correct output of psql -XAtc '\drds' 544s # restore /var/backups/postgresql/17-main/2025-06-19T013939Z.backup 545s ok 53 - pg_dropcluster 17 main --stop 549s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T013939Z.backup --start --datadir /var/lib/postgresql/17/snowflake 549s ok 55 - pg_lsclusters -h 549s ok 56 - correct output of pg_lsclusters -h 549s ok 57 - psql -XAtl 549s ok 58 - mydb locales 549s ok 59 - mydb grants 549s ok 60 - myicudb locales 549s ok 61 - psql -XAtc 'show work_mem' 549s ok 62 - correct output of psql -XAtc 'show work_mem' 549s ok 63 - psql -XAtc 'select * from foo' mydb 549s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 549s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 549s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 549s ok 67 - psql -XAtc '\drds' 549s ok 68 - correct output of psql -XAtc '\drds' 549s # restore /var/backups/postgresql/17-main/2025-06-19T013939Z.backup with WAL archive 551s ok 69 - pg_dropcluster 17 main --stop 554s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T013939Z.backup --start --archive --port 5430 555s ok 71 - pg_lsclusters -h 555s ok 72 - correct output of pg_lsclusters -h 555s ok 73 - psql -XAtc 'select * from foo order by t' mydb 555s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 555s # restore /var/backups/postgresql/17-main/2025-06-19T013939Z.backup with PITR 556s ok 75 - pg_dropcluster 17 main --stop 560s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T013939Z.backup --start --pitr '2025-06-19 01:40:07.216889+00 560s # ' 560s ok 77 - pg_lsclusters -h 560s ok 78 - correct output of pg_lsclusters -h 560s ok 79 - psql -XAtc 'select * from foo order by t' mydb 560s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 562s ok 81 - pg_dropcluster 17 main --stop 562s # Cleanup 562s ok 82 - Cleanup: No clusters left behind 562s ok 83 - No postgres processes left behind 562s ok 84 - No files in /etc/postgresql left behind 562s ok 85 - No files in /var/lib/postgresql left behind 562s ok 86 - No files in /var/run/postgresql left behind 562s ok 87 - No files in /var/log/postgresql left behind 562s ok 88 - PostgreSQL TCP ports are closed 562s ok 89 - Next free port is 5432 562s 1..89 562s ### End test 045_backup.t ### 562s 562s ### PostgreSQL test 050_encodings.t ### 562s 1..60 562s # Checking 17 ru_RU 565s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 566s ok 2 - psql -l succeeds 566s ok 3 - template1 is not UTF-8 encoded 566s ok 4 - creating test database 566s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 566s # create table t (x varchar); copy t from stdin" test 566s ok 6 - creating table with ISO-8859-5 characters 567s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 567s ok 8 - correct string in UTF-8 567s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 567s ok 10 - correct string in ISO-8859-5 567s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 567s # delete from t; copy t from stdin" test 567s ok 12 - creating table with UTF-8 characters 567s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 567s ok 14 - correct string in UTF-8 567s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 567s ok 16 - correct string in ISO-8859-1 567s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 567s ok 18 - Server error message has correct language and encoding 569s ok 19 - pg_ctlcluster 17 ru_RU restart 569s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 571s ok 21 - Dropping cluster 571s # Checking 17 ru_RU.UTF-8 574s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 575s ok 23 - psql -l succeeds 575s ok 24 - template1 is UTF-8 encoded 575s ok 25 - creating test database 575s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 575s # create table t (x varchar); copy t from stdin" test 575s ok 27 - creating table with ISO-8859-5 characters 575s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 575s ok 29 - correct string in UTF-8 575s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 575s ok 31 - correct string in ISO-8859-5 576s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 576s # delete from t; copy t from stdin" test 576s ok 33 - creating table with UTF-8 characters 576s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 576s ok 35 - correct string in UTF-8 576s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 576s ok 37 - correct string in ISO-8859-1 576s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 576s ok 39 - Server error message has correct language and encoding 578s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 578s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 578s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 578s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 578s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 578s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 578s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 578s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 580s ok 48 - Dropping cluster 580s # Check 17 locale environment variables 583s ok 49 - pg_createcluster: LC_ALL dominates LANG 583s ok 50 - psql -Atl --cluster 17/main 583s ok 51 - template1 is ASCII encoded 585s ok 52 - Dropping cluster 585s # Cleanup 585s ok 53 - Cleanup: No clusters left behind 585s ok 54 - No postgres processes left behind 585s ok 55 - No files in /etc/postgresql left behind 585s ok 56 - No files in /var/lib/postgresql left behind 585s ok 57 - No files in /var/run/postgresql left behind 585s ok 58 - No files in /var/log/postgresql left behind 585s ok 59 - PostgreSQL TCP ports are closed 585s ok 60 - Next free port is 5432 585s ### End test 050_encodings.t ### 585s 585s ### PostgreSQL test 052_upgrade_encodings.t ### 585s 1..1 585s ok 1 - only one major version installed, skipping upgrade tests 585s ### End test 052_upgrade_encodings.t ### 585s 585s ### PostgreSQL test 060_obsolete_confparams.t ### 585s ok 1 - only one major version installed, skipping upgrade tests 585s 1..1 585s ### End test 060_obsolete_confparams.t ### 585s 585s ### PostgreSQL test 070_non_postgres_clusters.t ### 585s 1..40 586s ok 1 - pg_createcluster 17 main for owner nobody 586s ok 2 - pg_ctlcluster 17 main start 586s ok 3 - start refused when config and data owners mismatch 589s ok 4 - pg_ctlcluster succeeds with owner nobody 589s ok 5 - pg_lsclusters -h 589s ok 6 - pg_lsclusters shows running cluster 589s ok 7 - postgres is running as user nobody 589s ok 8 - ls /tmp/.s.PGSQL.* 589s ok 9 - socket is in /tmp 589s ok 10 - /var/run/postgresql is empty 589s ok 11 - conf dir is owned by user 589s ok 12 - conf dir is owned by user's primary group 589s ok 13 - files are owned by user 589s ok 14 - files are owned by user's primary group 589s ok 15 - log file has 0640 permissions 589s ok 16 - log file is owned by user 589s ok 17 - log file is owned by user's primary group 589s ok 18 - only one major version installed, skipping upgrade test 589s ok 19 - ... 589s ok 20 - ... 589s ok 21 - ... 589s ok 22 - ... 589s ok 23 - ... 589s ok 24 - ... 589s ok 25 - ... 589s ok 26 - ... 589s ok 27 - ... 589s ok 28 - ... 590s ok 29 - pg_dropcluster 590s ok 30 - pg_lsclusters -h 590s ok 31 - No clusters left 590s ok 32 - No postgres processes left 590s # Cleanup 590s ok 33 - Cleanup: No clusters left behind 590s ok 34 - No postgres processes left behind 590s ok 35 - No files in /etc/postgresql left behind 590s ok 36 - No files in /var/lib/postgresql left behind 590s ok 37 - No files in /var/run/postgresql left behind 590s ok 38 - No files in /var/log/postgresql left behind 591s ok 39 - PostgreSQL TCP ports are closed 591s ok 40 - Next free port is 5432 591s ### End test 070_non_postgres_clusters.t ### 591s 591s ### PostgreSQL test 080_start.conf.t ### 591s 1..73 592s ok 1 - pg_createcluster 17 main 592s # start.conf auto 592s ok 2 - get_cluster_start_conf returns auto 592s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 592s ok 4 - start.conf contains auto 592s ok 5 - systemd generator links cluster 592s ok 6 - systemd generator links correct service file 594s ok 7 - /etc/init.d/postgresql start 17 594s ok 8 - correct output of /etc/init.d/postgresql start 17 594s ok 9 - pg_lsclusters -h 594s ok 10 - cluster is online 594s ok 11 - /etc/init.d/postgresql stop 17 594s ok 12 - correct output of /etc/init.d/postgresql stop 17 597s ok 13 - pg_lsclusters -h 597s ok 14 - cluster is down 597s # start.conf manual 597s ok 15 - get_cluster_start_conf returns manual 597s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 597s ok 17 - start.conf contains manual 597s ok 18 - systemd generator doesn't link cluster 597s ok 19 - /etc/init.d/postgresql start 17 597s ok 20 - correct output of /etc/init.d/postgresql start 17 597s ok 21 - pg_lsclusters -h 597s ok 22 - cluster is down 600s ok 23 - pg_ctlcluster 17 main start 600s ok 24 - correct output of pg_ctlcluster 17 main start 600s ok 25 - pg_lsclusters -h 600s ok 26 - cluster is online 600s ok 27 - pg_ctlcluster 17 main stop 600s ok 28 - correct output of pg_ctlcluster 17 main stop 600s ok 29 - pg_lsclusters -h 600s ok 30 - cluster is down 600s # start.conf disabled 600s ok 31 - get_cluster_start_conf returns disabled 600s ok 32 - systemd generator doesn't link cluster 600s ok 33 - /etc/init.d/postgresql start 17 600s ok 34 - correct output of /etc/init.d/postgresql start 17 600s ok 35 - pg_lsclusters -h 600s ok 36 - cluster is down 600s ok 37 - pg_ctlcluster 17 main start 600s ok 38 - correct output of pg_ctlcluster 17 main start 600s ok 39 - pg_lsclusters -h 600s ok 40 - cluster is down 602s ok 41 - pg_ctlcluster 17 main start 602s ok 42 - correct output of pg_ctlcluster 17 main start 603s ok 43 - pg_lsclusters -h 603s ok 44 - cluster is online 603s ok 45 - pg_ctlcluster 17 main stop 603s ok 46 - correct output of pg_ctlcluster 17 main stop 603s ok 47 - pg_lsclusters -h 603s ok 48 - cluster is down 605s ok 49 - pg_ctlcluster 17 main start 605s ok 50 - correct output of pg_ctlcluster 17 main start 605s ok 51 - pg_lsclusters -h 605s ok 52 - cluster is online 605s # test upgrade 605s ok 53 - only one major version installed, skipping upgrade test 605s ok 54 - ... 605s ok 55 - get_cluster_start_conf for old cluster returns manual 605s ok 56 - get_cluster_start_conf for new cluster returns manual 605s ok 57 - ... 606s ok 58 - dropping upgraded cluster 606s ok 59 - pg_lsclusters -h 606s ok 60 - no clusters any more 607s ok 61 - pg_createcluster 17 main --start-conf foo 607s ok 62 - pg_createcluster checks --start-conf validity 607s ok 63 - pg_createcluster checks --start-conf manual 607s ok 64 - get_cluster_start_conf returns manual 609s ok 65 - dropping cluster 609s # Cleanup 609s ok 66 - Cleanup: No clusters left behind 609s ok 67 - No postgres processes left behind 609s ok 68 - No files in /etc/postgresql left behind 609s ok 69 - No files in /var/lib/postgresql left behind 609s ok 70 - No files in /var/run/postgresql left behind 609s ok 71 - No files in /var/log/postgresql left behind 609s ok 72 - PostgreSQL TCP ports are closed 609s ok 73 - Next free port is 5432 609s ### End test 080_start.conf.t ### 609s 609s ### PostgreSQL test 085_pg_ctl.conf.t ### 609s 1..33 609s ok 1 - prlimit --core=0:unlimited --pid=16112 609s ok 2 - set core file size to unlimited 609s ok 3 - sh -c 'ulimit -Hc' 609s ok 4 - core file size is unlimited 610s ok 5 - pg_createcluster 17 main 610s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 612s ok 7 - pg_ctlcluster 17 main start 612s ok 8 - starting cluster as root 612s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 612s ok 10 - soft core size is 0 612s # hard core file size limit of root-started postgres process is unlimited 612s ok 11 - set pg_ctl default option to -c 615s ok 12 - pg_ctlcluster 17 main restart 615s ok 13 - restarting cluster as root 615s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 615s ok 15 - soft core size is unlimited 615s ok 16 - pg_ctlcluster 17 main stop 615s ok 17 - stopping cluster 615s ok 18 - restored pg_ctl default option 617s ok 19 - pg_ctlcluster 17 main start -- -c 617s ok 20 - starting cluster with -c on the command line as postgres 617s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 617s ok 22 - soft core size is unlimited 617s ok 23 - pg_ctlcluster 17 main stop 617s ok 24 - stopping cluster 619s ok 25 - dropping cluster 619s # Cleanup 619s ok 26 - Cleanup: No clusters left behind 619s ok 27 - No postgres processes left behind 619s ok 28 - No files in /etc/postgresql left behind 619s ok 29 - No files in /var/lib/postgresql left behind 619s ok 30 - No files in /var/run/postgresql left behind 619s ok 31 - No files in /var/log/postgresql left behind 619s ok 32 - PostgreSQL TCP ports are closed 619s ok 33 - Next free port is 5432 619s ### End test 085_pg_ctl.conf.t ### 619s 619s ### PostgreSQL test 090_multicluster.t ### 619s 1..125 620s ok 1 - pg_createcluster 17 old 621s ok 2 - pg_createcluster 17 new1 622s ok 3 - pg_createcluster 17 new2 624s ok 4 - starting cluster 17/old 626s ok 5 - starting cluster 17/new1 629s ok 6 - starting cluster 17/new2 629s ok 7 - pg_lsclusters -h | sort -k3 629s ok 8 - clusters have the correct ports, skipping used 5433 629s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 629s ok 10 - createdb --version 629s ok 11 - pg_wrapper selects port 5432 as default cluster 629s ok 12 - createdb --cluster 17/new1 --version 629s ok 13 - pg_wrapper --cluster works 629s ok 14 - createdb --cluster 17/foo --version 629s ok 15 - pg_wrapper --cluster errors out for invalid cluster 629s ok 16 - createdb --cluster 17/new1 test 629s ok 17 - correct output of createdb --cluster 17/new1 test 629s ok 18 - psql -Atl --cluster 17/new1 629s ok 19 - test db appears in cluster new1 629s ok 20 - psql -Atl --cluster 17/new2 629s ok 21 - test db does not appear in cluster new2 629s ok 22 - psql -Atl 629s ok 23 - test db does not appear in default cluster 629s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 629s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 629s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 629s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 629s ok 28 - psql -Atl --cluster 17/localhost:5434 629s ok 29 - test db appears in cluster 17/localhost:5434 629s ok 30 - psql -Atl --cluster 17/localhost:5440 629s ok 31 - test db does not appear in cluster 17/localhost:5440 629s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 629s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 629s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 629s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 629s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 629s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 629s ok 38 - psql -Atl --cluster 6.4/localhost: 629s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 629s ok 40 - psql -Atl 629s ok 41 - PGCLUSTER selection (1) 629s ok 42 - psql -Atl 629s ok 43 - PGCLUSTER selection (2) 629s ok 44 - psql -l 629s ok 45 - invalid PGCLUSTER value 629s ok 46 - createdb --version 629s ok 47 - PGCLUSTER network cluster selection (1) 629s ok 48 - psql -Atl 629s ok 49 - PGCLUSTER network cluster selection (2) 629s ok 50 - psql -Atl 629s ok 51 - PGCLUSTER network cluster selection (3) 630s ok 52 - LC_MESSAGES=C psql -Atl 630s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 630s ok 54 - psql -Atc "show port" template1 630s ok 55 - PGPORT selection (1) 630s ok 56 - psql -Atc "show port" template1 630s ok 57 - PGPORT selection (2) 630s ok 58 - createdb --version 630s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 630s ok 60 - psql -Atc "show port" template1 630s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 630s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 630s ok 63 - PGDATABASE environment variable works 630s ok 64 - createdb --version 630s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 630s ok 66 - createdb --cluster 17/new1 --version 630s ok 67 - pg_wrapper --cluster works with empty user_clusters 630s ok 68 - createdb --version 630s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 630s ok 70 - psql -Atc "select current_database()" 630s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 630s ok 72 - psql -Atc 'select current_database()' 630s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 630s ok 74 - createdb --version 630s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 630s ok 76 - createdb --version 630s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 630s ok 78 - createdb --version 630s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 630s ok 80 - createdb --version 630s ok 81 - pg_wrapper selects correct version with per-user user_clusters 630s ok 82 - createdb --version 630s ok 83 - pg_wrapper selects correct version with per-user user_clusters 630s ok 84 - createdb --version 630s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 630s ok 86 - psql -Atl 630s ok 87 - $PGHOST overrides user_clusters 630s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 630s ok 89 - --cluster overrides $PGHOST 630s ok 90 - createdb --version 630s ok 91 - pg_wrapper ignores invalid lines in user_clusters 630s ok 92 - psql -Atc 'select current_database()' 630s ok 93 - pg_service conf selection 1 630s ok 94 - psql -Atc 'select current_database()' 630s ok 95 - pg_service conf selection 2 630s ok 96 - psql -Atc 'select current_database()' 630s ok 97 - pg_service conf selection 3 631s ok 98 - stopping cluster 17/old 633s ok 99 - restarting cluster 17/old 633s ok 100 - pg_lsclusters -h | sort -k3 633s ok 101 - port of first cluster was successfully changed 633s ok 102 - psql -l 633s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 633s ok 104 - psql -Atl --cluster 17/new1 633s ok 105 - --cluster selects appropriate cluster 633s ok 106 - psql -Atl -p 5434 633s ok 107 - -p selects appropriate cluster 633s ok 108 - psql -Atlp 5434 633s ok 109 - -Atlp selects appropriate cluster 633s ok 110 - psql -Atl --port 5434 633s ok 111 - --port selects appropriate cluster 633s ok 112 - env PGPORT=5434 psql -Atl 633s ok 113 - $PGPORT selects appropriate cluster 633s ok 114 - Restoring original /etc/postgresql-common/user_clusters 636s ok 115 - dropping 17/new1 638s ok 116 - dropping 17/new2 640s ok 117 - dropping 17/old 640s # Cleanup 640s ok 118 - Cleanup: No clusters left behind 640s ok 119 - No postgres processes left behind 640s ok 120 - No files in /etc/postgresql left behind 640s ok 121 - No files in /var/lib/postgresql left behind 640s ok 122 - No files in /var/run/postgresql left behind 640s ok 123 - No files in /var/log/postgresql left behind 640s ok 124 - PostgreSQL TCP ports are closed 640s ok 125 - Next free port is 5432 640s ### End test 090_multicluster.t ### 640s 640s ### PostgreSQL test 110_integrate_cluster.t ### 640s 1..32 641s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/6Ovp7O7Ugj/c/postgres 641s ok 2 - creating raw initdb cluster for user postgres 641s ok 3 - pg_createcluster 17 postgres -d /tmp/6Ovp7O7Ugj/c/postgres 641s ok 4 - integrating postgres cluster 641s ok 5 - pg_lsclusters 641s ok 6 - correct pg_lsclusters output 643s ok 7 - pg_ctlcluster 17 postgres start 643s ok 8 - starting cluster postgres 644s ok 9 - pg_lsclusters 644s ok 10 - correct pg_lsclusters output 645s ok 11 - dropping cluster postgres 645s ok 12 - No files in temporary cluster dir left behind 646s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/6Ovp7O7Ugj/c/nobody 646s ok 14 - creating raw initdb cluster for user nobody 646s ok 15 - pg_createcluster 17 nobody -d /tmp/6Ovp7O7Ugj/c/nobody 646s ok 16 - integrating nobody cluster 646s ok 17 - pg_lsclusters 646s ok 18 - correct pg_lsclusters output 649s ok 19 - pg_ctlcluster 17 nobody start 649s ok 20 - starting cluster nobody 649s ok 21 - pg_lsclusters 649s ok 22 - correct pg_lsclusters output 650s ok 23 - dropping cluster nobody 650s ok 24 - No files in temporary cluster dir left behind 650s # Cleanup 650s ok 25 - Cleanup: No clusters left behind 650s ok 26 - No postgres processes left behind 650s ok 27 - No files in /etc/postgresql left behind 650s ok 28 - No files in /var/lib/postgresql left behind 650s ok 29 - No files in /var/run/postgresql left behind 650s ok 30 - No files in /var/log/postgresql left behind 650s ok 31 - PostgreSQL TCP ports are closed 650s ok 32 - Next free port is 5432 650s ### End test 110_integrate_cluster.t ### 650s 650s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 650s 1..1 650s ok 1 - only one major version installed, skipping upgrade tests 650s ### End test 120_pg_upgradecluster_scripts.t ### 650s 650s ### PostgreSQL test 130_nonroot_admin.t ### 650s 1..22 653s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 653s ok 2 - pg_lsclusters -h 653s ok 3 - correct output of pg_lsclusters -h 653s ok 4 - psql -Atl 653s ok 5 - correct output of psql -Atl 654s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 654s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 654s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 654s # Cleanup 654s ok 15 - Cleanup: No clusters left behind 654s ok 16 - No postgres processes left behind 654s ok 17 - No files in /etc/postgresql left behind 654s ok 18 - No files in /var/lib/postgresql left behind 654s ok 19 - No files in /var/run/postgresql left behind 654s ok 20 - No files in /var/log/postgresql left behind 654s ok 21 - PostgreSQL TCP ports are closed 654s ok 22 - Next free port is 5432 654s ### End test 130_nonroot_admin.t ### 654s 654s ### PostgreSQL test 135_pg_virtualenv.t ### 654s 1..20 659s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 659s ok 2 - running pg_virtualenv as root 662s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 662s ok 4 - running pg_virtualenv as postgres 665s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 665s ok 6 - running pg_virtualenv as nobody 668s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 668s ok 8 - running fakeroot pg_virtualenv as root 672s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 672s ok 10 - running fakeroot pg_virtualenv as postgres 675s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 675s ok 12 - running fakeroot pg_virtualenv as nobody 675s # Cleanup 675s ok 13 - Cleanup: No clusters left behind 675s ok 14 - No postgres processes left behind 675s ok 15 - No files in /etc/postgresql left behind 675s ok 16 - No files in /var/lib/postgresql left behind 675s ok 17 - No files in /var/run/postgresql left behind 675s ok 18 - No files in /var/log/postgresql left behind 675s ok 19 - PostgreSQL TCP ports are closed 675s ok 20 - Next free port is 5432 675s ### End test 135_pg_virtualenv.t ### 675s 675s ### PostgreSQL test 140_pg_config.t ### 675s 1..38 675s # Multiarch is enabled 675s # checking version specific output for 17 675s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 675s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 675s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 675s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 675s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 675s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 675s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 675s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 675s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 675s # checking pg_config output (should behave like version 17) 675s ok 15 - pg_config 675s ok 16 - correct output of pg_config 675s ok 17 - pg_config --help 675s ok 18 - correct output of pg_config --help 675s ok 19 - pg_config --pgxs 675s ok 20 - correct output of pg_config --pgxs 675s ok 21 - pg_config --libdir 675s ok 22 - correct output of pg_config --libdir 675s ok 23 - pg_config --pkglibdir 675s ok 24 - correct output of pg_config --pkglibdir 675s ok 25 - pg_config --bindir 675s ok 26 - correct output of pg_config --bindir 675s # checking pg_config.libpq-dev output (should behave like version 17) 675s ok 27 - pg_config.libpq-dev 675s ok 28 - correct output of pg_config.libpq-dev 675s ok 29 - pg_config.libpq-dev --help 675s ok 30 - correct output of pg_config.libpq-dev --help 675s ok 31 - pg_config.libpq-dev --pgxs 675s ok 32 - correct output of pg_config.libpq-dev --pgxs 675s ok 33 - pg_config.libpq-dev --libdir 675s ok 34 - correct output of pg_config.libpq-dev --libdir 675s ok 35 - pg_config.libpq-dev --pkglibdir 675s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 675s ok 37 - pg_config.libpq-dev --bindir 675s ok 38 - correct output of pg_config.libpq-dev --bindir 675s ### End test 140_pg_config.t ### 675s 675s ### PostgreSQL test 150_tsearch_stemming.t ### 675s 1..37 675s ok 1 - pg_updatedicts succeeded 675s ok 2 - pg_updatedicts created en_us.affix 675s ok 3 - pg_updatedicts created en_us.dict 675s ok 4 - pg_updatedicts created 17 en_us.affix symlink 675s ok 5 - pg_updatedicts created 17 en_us.dict symlink 679s ok 6 - pg_createcluster 17 main 679s ok 7 - createdb fts 679s ok 8 - correct output of createdb fts 679s ok 9 - creating en_US full text search configuration 679s ok 10 - creating data table and search index 679s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 679s ok 12 - stem search of correct word 679s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 679s ok 14 - stem search of correct word 679s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 679s ok 16 - stem search of unknown word 679s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 679s ok 18 - full text search, exact word 679s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 679s ok 20 - full text search for word stem 679s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 679s ok 22 - full text search for word substring fails 680s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 680s ok 24 - full text search, exact unicode word 680s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 680s ok 26 - full text search for unicode word stem 680s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 680s ok 28 - full text search for unicode word substring fails 681s ok 29 681s # Cleanup 681s ok 30 - Cleanup: No clusters left behind 681s ok 31 - No postgres processes left behind 681s ok 32 - No files in /etc/postgresql left behind 681s ok 33 - No files in /var/lib/postgresql left behind 681s ok 34 - No files in /var/run/postgresql left behind 681s ok 35 - No files in /var/log/postgresql left behind 681s ok 36 - PostgreSQL TCP ports are closed 681s ok 37 - Next free port is 5432 681s ### End test 150_tsearch_stemming.t ### 681s 681s ### PostgreSQL test 160_alternate_confroot.t ### 681s 1..28 684s ok 1 684s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 684s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 685s ok 4 - pg_lsclusters -h 685s ok 5 - correct output of pg_lsclusters -h 685s ok 6 - psql -Atl 685s ok 7 - correct output of psql -Atl 685s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 685s ok 9 - ... 685s ok 10 - ... 685s ok 11 - ... 685s ok 12 - ... 685s ok 13 - ... 685s ok 14 - ... 685s ok 15 - pg_dropcluster 17 test --stop 685s ok 16 - correct output of pg_dropcluster 17 test --stop 685s ok 17 - pg_lsclusters -h 685s ok 18 - correct output of pg_lsclusters -h 685s ok 19 - No files in root/data left behind 685s ok 20 - No cruft in root dir left behind 685s # Cleanup 685s ok 21 - Cleanup: No clusters left behind 685s ok 22 - No postgres processes left behind 685s ok 23 - No files in /etc/postgresql left behind 685s ok 24 - No files in /var/lib/postgresql left behind 685s ok 25 - No files in /var/run/postgresql left behind 685s ok 26 - No files in /var/log/postgresql left behind 685s ok 27 - PostgreSQL TCP ports are closed 685s ok 28 - Next free port is 5432 685s ### End test 160_alternate_confroot.t ### 685s 685s ### PostgreSQL test 170_extensions.t ### 685s # Running tests for 17 688s ok 1 - pg_createcluster 17 main 688s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 688s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 688s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 688s ok 5 - extension amcheck installs without error 688s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 688s ok 7 - extension amcheck removes without error 688s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 688s ok 9 - extension autoinc installs without error 689s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 689s ok 11 - extension autoinc removes without error 689s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 689s ok 13 - extension bloom installs without error 689s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 689s ok 15 - extension bloom removes without error 689s ok 16 - psql -qc 'CREATE EXTENSION plperl' 689s ok 17 - bool_plperl dependency plperl installs without error 689s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 689s ok 19 - extension bool_plperl installs without error 689s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 689s ok 21 - extension bool_plperl removes without error 689s ok 22 - psql -qc 'DROP EXTENSION plperl' 689s ok 23 - bool_plperl dependency extension plperl removes without error 689s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 689s ok 25 - bool_plperlu dependency plperlu installs without error 689s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 689s ok 27 - extension bool_plperlu installs without error 689s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 689s ok 29 - extension bool_plperlu removes without error 689s ok 30 - psql -qc 'DROP EXTENSION plperlu' 689s ok 31 - bool_plperlu dependency extension plperlu removes without error 689s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 689s ok 33 - extension btree_gin installs without error 689s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 689s ok 35 - extension btree_gin removes without error 689s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 689s ok 37 - extension btree_gist installs without error 689s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 689s ok 39 - extension btree_gist removes without error 689s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 689s ok 41 - extension citext installs without error 689s ok 42 - psql -qc 'DROP EXTENSION "citext"' 689s ok 43 - extension citext removes without error 689s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 689s ok 45 - extension cube installs without error 690s ok 46 - psql -qc 'DROP EXTENSION "cube"' 690s ok 47 - extension cube removes without error 690s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 690s ok 49 - extension dblink installs without error 690s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 690s ok 51 - extension dblink removes without error 690s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 690s ok 53 - extension dict_int installs without error 690s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 690s ok 55 - extension dict_int removes without error 690s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 690s ok 57 - extension dict_xsyn installs without error 690s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 690s ok 59 - extension dict_xsyn removes without error 690s ok 60 - psql -qc 'CREATE EXTENSION cube' 690s ok 61 - earthdistance dependency cube installs without error 690s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 690s ok 63 - extension earthdistance installs without error 690s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 690s ok 65 - extension earthdistance removes without error 690s ok 66 - psql -qc 'DROP EXTENSION cube' 690s ok 67 - earthdistance dependency extension cube removes without error 690s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 690s ok 69 - extension file_fdw installs without error 690s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 690s ok 71 - extension file_fdw removes without error 690s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 690s ok 73 - extension fuzzystrmatch installs without error 690s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 690s ok 75 - extension fuzzystrmatch removes without error 690s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 690s ok 77 - extension hstore installs without error 690s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 690s ok 79 - extension hstore removes without error 690s ok 80 - psql -qc 'CREATE EXTENSION hstore' 690s ok 81 - hstore_plperl dependency hstore installs without error 690s ok 82 - psql -qc 'CREATE EXTENSION plperl' 690s ok 83 - hstore_plperl dependency plperl installs without error 691s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 691s ok 85 - extension hstore_plperl installs without error 691s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 691s ok 87 - extension hstore_plperl removes without error 691s ok 88 - psql -qc 'DROP EXTENSION hstore' 691s ok 89 - hstore_plperl dependency extension hstore removes without error 691s ok 90 - psql -qc 'DROP EXTENSION plperl' 691s ok 91 - hstore_plperl dependency extension plperl removes without error 691s ok 92 - psql -qc 'CREATE EXTENSION hstore' 691s ok 93 - hstore_plperlu dependency hstore installs without error 691s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 691s ok 95 - hstore_plperlu dependency plperlu installs without error 691s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 691s ok 97 - extension hstore_plperlu installs without error 691s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 691s ok 99 - extension hstore_plperlu removes without error 691s ok 100 - psql -qc 'DROP EXTENSION hstore' 691s ok 101 - hstore_plperlu dependency extension hstore removes without error 691s ok 102 - psql -qc 'DROP EXTENSION plperlu' 691s ok 103 - hstore_plperlu dependency extension plperlu removes without error 691s ok 104 - psql -qc 'CREATE EXTENSION hstore' 691s ok 105 - hstore_plpython3u dependency hstore installs without error 691s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 691s ok 107 - hstore_plpython3u dependency plpython3u installs without error 691s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 691s ok 109 - extension hstore_plpython3u installs without error 691s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 691s ok 111 - extension hstore_plpython3u removes without error 691s ok 112 - psql -qc 'DROP EXTENSION hstore' 691s ok 113 - hstore_plpython3u dependency extension hstore removes without error 691s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 691s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 691s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 691s ok 117 - extension insert_username installs without error 691s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 691s ok 119 - extension insert_username removes without error 691s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 691s ok 121 - extension intagg installs without error 691s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 691s ok 123 - extension intagg removes without error 692s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 692s ok 125 - extension intarray installs without error 692s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 692s ok 127 - extension intarray removes without error 692s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 692s ok 129 - extension isn installs without error 692s ok 130 - psql -qc 'DROP EXTENSION "isn"' 692s ok 131 - extension isn removes without error 692s ok 132 - psql -qc 'CREATE EXTENSION plperl' 692s ok 133 - jsonb_plperl dependency plperl installs without error 692s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 692s ok 135 - extension jsonb_plperl installs without error 692s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 692s ok 137 - extension jsonb_plperl removes without error 692s ok 138 - psql -qc 'DROP EXTENSION plperl' 692s ok 139 - jsonb_plperl dependency extension plperl removes without error 692s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 692s ok 141 - jsonb_plperlu dependency plperlu installs without error 692s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 692s ok 143 - extension jsonb_plperlu installs without error 692s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 692s ok 145 - extension jsonb_plperlu removes without error 692s ok 146 - psql -qc 'DROP EXTENSION plperlu' 692s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 692s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 692s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 692s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 692s ok 151 - extension jsonb_plpython3u installs without error 692s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 692s ok 153 - extension jsonb_plpython3u removes without error 692s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 692s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 692s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 692s ok 157 - extension lo installs without error 692s ok 158 - psql -qc 'DROP EXTENSION "lo"' 692s ok 159 - extension lo removes without error 693s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 693s ok 161 - extension ltree installs without error 693s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 693s ok 163 - extension ltree removes without error 693s ok 164 - psql -qc 'CREATE EXTENSION ltree' 693s ok 165 - ltree_plpython3u dependency ltree installs without error 693s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 693s ok 167 - ltree_plpython3u dependency plpython3u installs without error 693s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 693s ok 169 - extension ltree_plpython3u installs without error 693s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 693s ok 171 - extension ltree_plpython3u removes without error 693s ok 172 - psql -qc 'DROP EXTENSION ltree' 693s ok 173 - ltree_plpython3u dependency extension ltree removes without error 693s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 693s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 693s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 693s ok 177 - extension moddatetime installs without error 693s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 693s ok 179 - extension moddatetime removes without error 693s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 693s ok 181 - extension pageinspect installs without error 693s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 693s ok 183 - extension pageinspect removes without error 693s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 693s ok 185 - extension pg_buffercache installs without error 693s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 693s ok 187 - extension pg_buffercache removes without error 693s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 693s ok 189 - extension pg_freespacemap installs without error 693s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 693s ok 191 - extension pg_freespacemap removes without error 693s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 693s ok 193 - extension pg_prewarm installs without error 693s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 693s ok 195 - extension pg_prewarm removes without error 693s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 693s ok 197 - extension pg_stat_statements installs without error 693s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 693s ok 199 - extension pg_stat_statements removes without error 694s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 694s ok 201 - extension pg_surgery installs without error 694s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 694s ok 203 - extension pg_surgery removes without error 694s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 694s ok 205 - extension pg_trgm installs without error 694s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 694s ok 207 - extension pg_trgm removes without error 694s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 694s ok 209 - extension pg_visibility installs without error 694s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 694s ok 211 - extension pg_visibility removes without error 694s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 694s ok 213 - extension pg_walinspect installs without error 694s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 694s ok 215 - extension pg_walinspect removes without error 694s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 694s ok 217 - extension pgcrypto installs without error 694s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 694s ok 219 - extension pgcrypto removes without error 694s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 694s ok 221 - extension pgrowlocks installs without error 694s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 694s ok 223 - extension pgrowlocks removes without error 694s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 694s ok 225 - extension pgstattuple installs without error 694s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 694s ok 227 - extension pgstattuple removes without error 694s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 694s ok 229 - extension plperl installs without error 694s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 694s ok 231 - extension plperl removes without error 694s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 694s ok 233 - extension plperlu installs without error 694s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 694s ok 235 - extension plperlu removes without error 694s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 694s ok 237 - extension plpython3u installs without error 694s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 694s ok 239 - extension plpython3u removes without error 694s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 694s ok 241 - extension pltcl installs without error 695s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 695s ok 243 - extension pltcl removes without error 695s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 695s ok 245 - extension pltclu installs without error 695s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 695s ok 247 - extension pltclu removes without error 695s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 695s ok 249 - extension postgres_fdw installs without error 695s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 695s ok 251 - extension postgres_fdw removes without error 695s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 695s ok 253 - extension refint installs without error 695s ok 254 - psql -qc 'DROP EXTENSION "refint"' 695s ok 255 - extension refint removes without error 695s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 695s ok 257 - extension seg installs without error 695s ok 258 - psql -qc 'DROP EXTENSION "seg"' 695s ok 259 - extension seg removes without error 695s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 695s ok 261 - extension sslinfo installs without error 695s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 695s ok 263 - extension sslinfo removes without error 695s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 695s ok 265 - extension tablefunc installs without error 695s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 695s ok 267 - extension tablefunc removes without error 695s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 695s ok 269 - extension tcn installs without error 695s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 695s ok 271 - extension tcn removes without error 695s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 695s ok 273 - extension tsm_system_rows installs without error 695s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 695s ok 275 - extension tsm_system_rows removes without error 695s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 695s ok 277 - extension tsm_system_time installs without error 695s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 695s ok 279 - extension tsm_system_time removes without error 695s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 695s ok 281 - extension unaccent installs without error 695s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 695s ok 283 - extension unaccent removes without error 696s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 696s ok 285 - extension uuid-ossp installs without error 696s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 696s ok 287 - extension uuid-ossp removes without error 696s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 696s ok 289 - extension xml2 installs without error 696s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 696s ok 291 - extension xml2 removes without error 697s ok 292 - pg_dropcluster 17 main 697s # Cleanup 697s ok 293 - Cleanup: No clusters left behind 697s ok 294 - No postgres processes left behind 697s ok 295 - No files in /etc/postgresql left behind 697s ok 296 - No files in /var/lib/postgresql left behind 697s ok 297 - No files in /var/run/postgresql left behind 697s ok 298 - No files in /var/log/postgresql left behind 697s ok 299 - PostgreSQL TCP ports are closed 697s ok 300 - Next free port is 5432 697s 1..300 697s ### End test 170_extensions.t ### 697s 697s ### PostgreSQL test 180_ecpg.t ### 697s 1..14 697s ok 1 - ecpg test.pgc 697s ok 2 - ecpg processing 698s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 698s ok 4 - compiling ecpg output 705s ok 5 - pg_virtualenv /tmp/tmp.gWJDt2Km1F/test 705s ok 6 - test program runs and gives correct output 705s # Cleanup 705s ok 7 - Cleanup: No clusters left behind 705s ok 8 - No postgres processes left behind 705s ok 9 - No files in /etc/postgresql left behind 705s ok 10 - No files in /var/lib/postgresql left behind 705s ok 11 - No files in /var/run/postgresql left behind 705s ok 12 - No files in /var/log/postgresql left behind 705s ok 13 - PostgreSQL TCP ports are closed 705s ok 14 - Next free port is 5432 705s ### End test 180_ecpg.t ### 705s 705s ### PostgreSQL test 190_pg_buildext.t ### 705s ok 1 - make clean 705s ok 2 - make tar 705s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 705s # testing 'dh --with pgxs' 709s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 709s ok 5 - postgresql-17-foo_123-1_arm64.deb was built 717s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 717s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 717s ok 8 - dpkg -i postgresql-17-foo_123-1_arm64.deb 725s ok 9 - cd foo-123 && pg_buildext installcheck 725s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 732s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 732s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 740s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 740s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 740s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 740s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 740s ok 17 - dpkg -r postgresql-17-foo 740s # testing 'dh --with pgxs_loop' 740s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 743s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 743s ok 20 - postgresql-17-foo_123-1_arm64.deb was built 743s ok 21 - make clean 743s # testing pg_buildext updatecontrol 744s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 744s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 744s 1..23 744s ### End test 190_pg_buildext.t ### 744s 744s ### PostgreSQL test 200_maintscripts.t ### 744s 1..15 744s # We are running systemd 747s ok 1 - pg_createcluster 17 main --start 747s ok 2 - postmaster PID is 22486 749s ok 3 - apt-get update -q 749s # postgresql-common: 749s # Installed: 279 749s # Candidate: 279 749s # Version table: 749s # *** 279 500 749s # 500 http://ftpmaster.internal/ubuntu questing/main arm64 Packages 749s # 100 /var/lib/dpkg/status 752s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 753s # postgresql-common: 753s # Installed: 279 753s # Candidate: 279 753s # Version table: 753s # *** 279 500 753s # 500 http://ftpmaster.internal/ubuntu questing/main arm64 Packages 753s # 100 /var/lib/dpkg/status 753s ok 5 - postmaster PID is 22486 753s ok 6 - postmaster was not restarted 754s ok 7 - pg_dropcluster 17 main --stop 754s # Cleanup 754s ok 8 - Cleanup: No clusters left behind 754s ok 9 - No postgres processes left behind 754s ok 10 - No files in /etc/postgresql left behind 754s ok 11 - No files in /var/lib/postgresql left behind 754s ok 12 - No files in /var/run/postgresql left behind 754s ok 13 - No files in /var/log/postgresql left behind 754s ok 14 - PostgreSQL TCP ports are closed 754s ok 15 - Next free port is 5432 754s ### End test 200_maintscripts.t ### 754s 755s autopkgtest [01:43:45]: test run-testsuite: -----------------------] 756s autopkgtest [01:43:46]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 756s run-testsuite PASS 756s autopkgtest [01:43:46]: @@@@@@@@@@@@@@@@@@@@ summary 756s default-psql FAIL stderr: ************************************************************************** 756s run-testsuite PASS 774s nova [W] Using flock in prodstack6-arm64 774s Creating nova instance adt-questing-arm64-postgresql-common-20250619-011316-juju-7f2275-prod-proposed-migration-environment-23-80e35bf6-087e-4e44-874c-d7a138b58420 from image adt/ubuntu-questing-arm64-server-20250619.img (UUID 9e826193-3943-4502-8d49-d04976fe922a)... 774s nova [W] Timed out waiting for 44806b4b-82a1-4a8b-8a38-f92ea12a1aca to get deleted. 774s nova [W] Using flock in prodstack6-arm64 774s Creating nova instance adt-questing-arm64-postgresql-common-20250619-011316-juju-7f2275-prod-proposed-migration-environment-23-80e35bf6-087e-4e44-874c-d7a138b58420 from image adt/ubuntu-questing-arm64-server-20250619.img (UUID 9e826193-3943-4502-8d49-d04976fe922a)... 774s nova [W] Timed out waiting for 806a8147-4907-4abb-948c-664ad9736ee7 to get deleted.