0s autopkgtest [19:51:01]: starting date and time: 2024-03-24 19:51:01+0000 0s autopkgtest [19:51:01]: git checkout: 4a1cd702 l/adt_testbed: don't blame the testbed for unsolvable build deps 0s autopkgtest [19:51:01]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.86dq08jl/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:procps --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=procps/2:4.0.4-4ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos02-ppc64el-5.secgroup --name adt-noble-ppc64el-postgresql-common-20240324-195101-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 196s autopkgtest [19:54:17]: testbed dpkg architecture: ppc64el 196s autopkgtest [19:54:17]: testbed apt version: 2.7.12 196s autopkgtest [19:54:17]: @@@@@@@@@@@@@@@@@@@@ test bed setup 197s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 197s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3981 kB] 198s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 198s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [57.3 kB] 198s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [495 kB] 198s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el Packages [700 kB] 198s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el c-n-f Metadata [3116 B] 198s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el Packages [1372 B] 198s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el c-n-f Metadata [116 B] 198s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el Packages [4263 kB] 198s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el c-n-f Metadata [8652 B] 198s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el Packages [61.1 kB] 198s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el c-n-f Metadata [116 B] 205s Fetched 9694 kB in 2s (3907 kB/s) 205s Reading package lists... 211s Reading package lists... 211s Building dependency tree... 211s Reading state information... 211s Calculating upgrade... 211s The following packages will be upgraded: 211s libproc2-0 procps 211s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 211s Need to get 804 kB of archives. 211s After this operation, 4096 B of additional disk space will be used. 211s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el libproc2-0 ppc64el 2:4.0.4-4ubuntu2 [68.8 kB] 211s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el procps ppc64el 2:4.0.4-4ubuntu2 [736 kB] 211s Fetched 804 kB in 1s (1508 kB/s) 211s (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 ... 70156 files and directories currently installed.) 211s Preparing to unpack .../libproc2-0_2%3a4.0.4-4ubuntu2_ppc64el.deb ... 211s Unpacking libproc2-0:ppc64el (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 211s Preparing to unpack .../procps_2%3a4.0.4-4ubuntu2_ppc64el.deb ... 211s Unpacking procps (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 211s Setting up libproc2-0:ppc64el (2:4.0.4-4ubuntu2) ... 211s Setting up procps (2:4.0.4-4ubuntu2) ... 211s Processing triggers for man-db (2.12.0-3) ... 211s Processing triggers for libc-bin (2.39-0ubuntu6) ... 211s Reading package lists... 211s Building dependency tree... 211s Reading state information... 211s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 212s sh: Attempting to set up Debian/Ubuntu apt sources automatically 212s sh: Distribution appears to be Ubuntu 213s Reading package lists... 213s Building dependency tree... 213s Reading state information... 213s eatmydata is already the newest version (131-1). 213s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 213s Reading package lists... 214s Building dependency tree... 214s Reading state information... 214s dbus is already the newest version (1.14.10-4ubuntu1). 214s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 214s Reading package lists... 214s Building dependency tree... 214s Reading state information... 214s rng-tools-debian is already the newest version (2.4). 214s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 214s Reading package lists... 214s Building dependency tree... 214s Reading state information... 215s The following packages will be REMOVED: 215s cloud-init* python3-configobj* python3-debconf* 215s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 215s After this operation, 3256 kB disk space will be freed. 215s (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 ... 70157 files and directories currently installed.) 215s Removing cloud-init (24.1.2-0ubuntu1) ... 215s Removing python3-configobj (5.0.8-3) ... 216s Removing python3-debconf (1.5.86) ... 216s Processing triggers for man-db (2.12.0-3) ... 216s (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 ... 69768 files and directories currently installed.) 216s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 217s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 217s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 217s invoke-rc.d: policy-rc.d denied execution of try-restart. 217s Reading package lists... 217s Building dependency tree... 217s Reading state information... 217s linux-generic is already the newest version (6.8.0-11.11+1). 217s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 217s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 218s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 218s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 220s Reading package lists... 220s Reading package lists... 220s Building dependency tree... 220s Reading state information... 221s Calculating upgrade... 221s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 221s Reading package lists... 221s Building dependency tree... 221s Reading state information... 221s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 221s autopkgtest [19:54:42]: rebooting testbed after setup commands that affected boot 387s autopkgtest [19:57:28]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Wed Feb 14 00:33:03 UTC 2024 389s autopkgtest [19:57:30]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 394s Get:1 http://ftpmaster.internal/ubuntu noble/main postgresql-common 257 (dsc) [2383 B] 394s Get:2 http://ftpmaster.internal/ubuntu noble/main postgresql-common 257 (tar) [217 kB] 395s gpgv: Signature made Thu Feb 8 12:33:31 2024 UTC 395s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 395s gpgv: Can't check signature: No public key 395s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_257.dsc: no acceptable signature found 395s autopkgtest [19:57:36]: testing package postgresql-common version 257 395s autopkgtest [19:57:36]: build not needed 395s autopkgtest [19:57:36]: test default-psql: preparing testbed 401s Reading package lists... 401s Building dependency tree... 401s Reading state information... 401s Starting pkgProblemResolver with broken count: 0 401s Starting 2 pkgProblemResolver with broken count: 0 401s Done 401s The following additional packages will be installed: 401s libjson-perl libllvm17 libpq5 libxslt1.1 postgresql postgresql-16 401s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 401s Suggested packages: 401s postgresql-doc postgresql-doc-16 401s Recommended packages: 401s libjson-xs-perl 401s The following NEW packages will be installed: 401s autopkgtest-satdep libjson-perl libllvm17 libpq5 libxslt1.1 postgresql 401s postgresql-16 postgresql-client-16 postgresql-client-common 401s postgresql-common ssl-cert 401s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 401s Need to get 46.2 MB/46.2 MB of archives. 401s After this operation, 199 MB of additional disk space will be used. 401s Get:1 /tmp/autopkgtest.xQuOmB/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [704 B] 401s Get:2 http://ftpmaster.internal/ubuntu noble/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 402s Get:3 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-common all 257 [36.2 kB] 402s Get:4 http://ftpmaster.internal/ubuntu noble/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 402s Get:5 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-common all 257 [162 kB] 402s Get:6 http://ftpmaster.internal/ubuntu noble/main ppc64el libllvm17 ppc64el 1:17.0.6-5build1 [27.3 MB] 403s Get:7 http://ftpmaster.internal/ubuntu noble/main ppc64el libpq5 ppc64el 16.2-1 [170 kB] 403s Get:8 http://ftpmaster.internal/ubuntu noble/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1 [192 kB] 403s Get:9 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-16 ppc64el 16.2-1 [1399 kB] 403s Get:10 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-16 ppc64el 16.2-1 [16.9 MB] 403s Get:11 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql all 16+257 [11.4 kB] 403s Preconfiguring packages ... 403s Fetched 46.2 MB in 2s (23.4 MB/s) 403s Selecting previously unselected package libjson-perl. 404s (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 ... 69713 files and directories currently installed.) 404s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 404s Unpacking libjson-perl (4.10000-1) ... 404s Selecting previously unselected package postgresql-client-common. 404s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 404s Unpacking postgresql-client-common (257) ... 404s Selecting previously unselected package ssl-cert. 404s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 404s Unpacking ssl-cert (1.1.2ubuntu1) ... 404s Selecting previously unselected package postgresql-common. 404s Preparing to unpack .../03-postgresql-common_257_all.deb ... 404s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 404s Unpacking postgresql-common (257) ... 404s Selecting previously unselected package libllvm17:ppc64el. 404s Preparing to unpack .../04-libllvm17_1%3a17.0.6-5build1_ppc64el.deb ... 404s Unpacking libllvm17:ppc64el (1:17.0.6-5build1) ... 405s Selecting previously unselected package libpq5:ppc64el. 405s Preparing to unpack .../05-libpq5_16.2-1_ppc64el.deb ... 405s Unpacking libpq5:ppc64el (16.2-1) ... 405s Selecting previously unselected package libxslt1.1:ppc64el. 405s Preparing to unpack .../06-libxslt1.1_1.1.39-0exp1_ppc64el.deb ... 405s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1) ... 405s Selecting previously unselected package postgresql-client-16. 405s Preparing to unpack .../07-postgresql-client-16_16.2-1_ppc64el.deb ... 405s Unpacking postgresql-client-16 (16.2-1) ... 405s Selecting previously unselected package postgresql-16. 405s Preparing to unpack .../08-postgresql-16_16.2-1_ppc64el.deb ... 405s Unpacking postgresql-16 (16.2-1) ... 405s Selecting previously unselected package postgresql. 405s Preparing to unpack .../09-postgresql_16+257_all.deb ... 405s Unpacking postgresql (16+257) ... 405s Selecting previously unselected package autopkgtest-satdep. 405s Preparing to unpack .../10-1-autopkgtest-satdep.deb ... 405s Unpacking autopkgtest-satdep (0) ... 405s Setting up postgresql-client-common (257) ... 405s Setting up libpq5:ppc64el (16.2-1) ... 405s Setting up ssl-cert (1.1.2ubuntu1) ... 406s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 407s Setting up libjson-perl (4.10000-1) ... 407s Setting up libxslt1.1:ppc64el (1.1.39-0exp1) ... 407s Setting up libllvm17:ppc64el (1:17.0.6-5build1) ... 407s Setting up postgresql-client-16 (16.2-1) ... 407s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 407s Setting up postgresql-common (257) ... 407s 407s Creating config file /etc/postgresql-common/createcluster.conf with new version 407s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 407s Removing obsolete dictionary files: 408s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 409s Setting up postgresql-16 (16.2-1) ... 409s Creating new PostgreSQL cluster 16/main ... 409s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 409s The files belonging to this database system will be owned by user "postgres". 409s This user must also own the server process. 409s 409s The database cluster will be initialized with locale "C.UTF-8". 409s The default database encoding has accordingly been set to "UTF8". 409s The default text search configuration will be set to "english". 409s 409s Data page checksums are disabled. 409s 409s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 409s creating subdirectories ... ok 409s selecting dynamic shared memory implementation ... posix 409s selecting default max_connections ... 100 409s selecting default shared_buffers ... 128MB 409s selecting default time zone ... Etc/UTC 409s creating configuration files ... ok 409s running bootstrap script ... ok 410s performing post-bootstrap initialization ... ok 410s syncing data to disk ... ok 413s Setting up postgresql (16+257) ... 413s Setting up autopkgtest-satdep (0) ... 413s Processing triggers for man-db (2.12.0-3) ... 415s Processing triggers for libc-bin (2.39-0ubuntu6) ... 417s (Reading database ... 71658 files and directories currently installed.) 417s Removing autopkgtest-satdep (0) ... 418s autopkgtest [19:57:59]: test default-psql: [----------------------- 418s autopkgtest [19:57:59]: test default-psql: -----------------------] 419s autopkgtest [19:58:00]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 419s default-psql PASS 420s autopkgtest [19:58:01]: test run-testsuite: preparing testbed 563s autopkgtest [20:00:24]: testbed dpkg architecture: ppc64el 563s autopkgtest [20:00:24]: testbed apt version: 2.7.12 563s autopkgtest [20:00:24]: @@@@@@@@@@@@@@@@@@@@ test bed setup 564s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 565s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [57.3 kB] 565s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 565s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [495 kB] 565s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3981 kB] 565s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el Packages [700 kB] 565s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el c-n-f Metadata [3116 B] 565s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el Packages [1372 B] 565s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el c-n-f Metadata [116 B] 565s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el Packages [4263 kB] 565s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el c-n-f Metadata [8652 B] 565s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el Packages [61.1 kB] 565s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el c-n-f Metadata [116 B] 569s Fetched 9694 kB in 3s (3846 kB/s) 569s Reading package lists... 572s Reading package lists... 572s Building dependency tree... 572s Reading state information... 572s Calculating upgrade... 572s The following packages will be upgraded: 572s libproc2-0 procps 572s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 572s Need to get 804 kB of archives. 572s After this operation, 4096 B of additional disk space will be used. 572s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el libproc2-0 ppc64el 2:4.0.4-4ubuntu2 [68.8 kB] 573s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el procps ppc64el 2:4.0.4-4ubuntu2 [736 kB] 573s Fetched 804 kB in 1s (1487 kB/s) 573s (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 ... 70156 files and directories currently installed.) 573s Preparing to unpack .../libproc2-0_2%3a4.0.4-4ubuntu2_ppc64el.deb ... 573s Unpacking libproc2-0:ppc64el (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 573s Preparing to unpack .../procps_2%3a4.0.4-4ubuntu2_ppc64el.deb ... 573s Unpacking procps (2:4.0.4-4ubuntu2) over (2:4.0.4-4ubuntu1) ... 573s Setting up libproc2-0:ppc64el (2:4.0.4-4ubuntu2) ... 573s Setting up procps (2:4.0.4-4ubuntu2) ... 574s Processing triggers for man-db (2.12.0-3) ... 575s Processing triggers for libc-bin (2.39-0ubuntu6) ... 575s Reading package lists... 575s Building dependency tree... 575s Reading state information... 576s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 576s sh: Attempting to set up Debian/Ubuntu apt sources automatically 576s sh: Distribution appears to be Ubuntu 577s Reading package lists... 577s Building dependency tree... 577s Reading state information... 578s eatmydata is already the newest version (131-1). 578s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 578s Reading package lists... 578s Building dependency tree... 578s Reading state information... 578s dbus is already the newest version (1.14.10-4ubuntu1). 578s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 578s Reading package lists... 578s Building dependency tree... 578s Reading state information... 578s rng-tools-debian is already the newest version (2.4). 578s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 578s Reading package lists... 579s Building dependency tree... 579s Reading state information... 579s The following packages will be REMOVED: 579s cloud-init* python3-configobj* python3-debconf* 579s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 579s After this operation, 3256 kB disk space will be freed. 579s (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 ... 70157 files and directories currently installed.) 579s Removing cloud-init (24.1.2-0ubuntu1) ... 580s Removing python3-configobj (5.0.8-3) ... 580s Removing python3-debconf (1.5.86) ... 580s Processing triggers for man-db (2.12.0-3) ... 580s (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 ... 69768 files and directories currently installed.) 580s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 581s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 581s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 581s invoke-rc.d: policy-rc.d denied execution of try-restart. 581s Reading package lists... 581s Building dependency tree... 581s Reading state information... 581s linux-generic is already the newest version (6.8.0-11.11+1). 581s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 582s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 582s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 582s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 584s Reading package lists... 584s Reading package lists... 585s Building dependency tree... 585s Reading state information... 585s Calculating upgrade... 585s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 585s Reading package lists... 585s Building dependency tree... 585s Reading state information... 585s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 586s autopkgtest [20:00:47]: rebooting testbed after setup commands that affected boot 634s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 650s Reading package lists... 650s Building dependency tree... 650s Reading state information... 650s Starting pkgProblemResolver with broken count: 0 650s Starting 2 pkgProblemResolver with broken count: 0 650s Done 650s The following additional packages will be installed: 650s autoconf automake autopoint autotools-dev build-essential clang-17 cpp 650s cpp-13 cpp-13-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu debhelper 650s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 650s emacsen-common fakeroot g++ g++-13 g++-13-powerpc64le-linux-gnu 650s g++-powerpc64le-linux-gnu gcc gcc-13 gcc-13-powerpc64le-linux-gnu 650s gcc-powerpc64le-linux-gnu gettext hunspell-en-us icu-devtools 650s intltool-debian libarchive-zip-perl libasan8 libatomic1 libc-dev-bin 650s libc6-dev libcc1-0 libclang-common-17-dev libclang-cpp17 libclang1-17 650s libcrypt-dev libdebhelper-perl libdw1 libecpg-compat3 libecpg-dev libecpg6 650s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev 650s libgomp1 libicu-dev libisl23 libitm1 libjson-perl libllvm17 liblsan0 libmpc3 650s libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 650s libpython3.12 libquadmath0 libssl-dev libstdc++-13-dev libsub-override-perl 650s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 650s libz3-dev linux-libc-dev llvm-17 llvm-17-dev llvm-17-linker-tools 650s llvm-17-runtime llvm-17-tools locales-all m4 po-debconf postgresql-16 650s postgresql-all postgresql-client-16 postgresql-client-common 650s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 650s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 650s postgresql-server-dev-all rpcsvc-proto ssl-cert 650s Suggested packages: 650s autoconf-archive gnu-standards autoconf-doc clang-17-doc wasi-libc cpp-doc 650s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 650s gcc-13-doc gcc-multilib manpages-dev flex bison gdb gcc-doc 650s gdb-powerpc64le-linux-gnu gettext-doc libasprintf-dev libgettextpo-dev 650s hunspell openoffice.org-hunspell | openoffice.org-core glibc-doc icu-doc 650s ncurses-doc libssl-doc libstdc++-13-doc tcl8.6 libtool-doc gfortran 650s | fortran95-compiler gcj-jdk pkg-config llvm-17-doc m4-doc libmail-box-perl 650s Recommended packages: 650s manpages manpages-dev libc-devtools libclang-rt-17-dev libarchive-cpio-perl 650s libjson-xs-perl libltdl-dev libmail-sendmail-perl 650s The following NEW packages will be installed: 650s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 650s clang-17 cpp cpp-13 cpp-13-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu 650s debhelper debugedit dh-autoreconf dh-strip-nondeterminism 650s dictionaries-common dwz emacsen-common fakeroot g++ g++-13 650s g++-13-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-13 650s gcc-13-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu gettext 650s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 650s libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-17-dev 650s libclang-cpp17 libclang1-17 libcrypt-dev libdebhelper-perl libdw1 650s libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 650s libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 libicu-dev 650s libisl23 libitm1 libjson-perl libllvm17 liblsan0 libmpc3 libncurses-dev 650s libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.12 650s libquadmath0 libssl-dev libstdc++-13-dev libsub-override-perl libtcl8.6 650s libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev 650s linux-libc-dev llvm-17 llvm-17-dev llvm-17-linker-tools llvm-17-runtime 650s llvm-17-tools locales-all m4 po-debconf postgresql-16 postgresql-all 650s postgresql-client-16 postgresql-client-common postgresql-common 650s postgresql-doc postgresql-doc-16 postgresql-plperl-16 650s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 650s postgresql-server-dev-all rpcsvc-proto ssl-cert 650s 0 upgraded, 102 newly installed, 0 to remove and 0 not upgraded. 650s Need to get 251 MB/251 MB of archives. 650s After this operation, 1457 MB of additional disk space will be used. 650s Get:1 /tmp/autopkgtest.xQuOmB/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [796 B] 650s Get:2 http://ftpmaster.internal/ubuntu noble/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 651s Get:3 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-common all 257 [36.2 kB] 651s Get:4 http://ftpmaster.internal/ubuntu noble/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 651s Get:5 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-common all 257 [162 kB] 651s Get:6 http://ftpmaster.internal/ubuntu noble/main ppc64el m4 ppc64el 1.4.19-4 [275 kB] 651s Get:7 http://ftpmaster.internal/ubuntu noble/main ppc64el autoconf all 2.71-3 [339 kB] 651s Get:8 http://ftpmaster.internal/ubuntu noble/main ppc64el autotools-dev all 20220109.1 [44.9 kB] 651s Get:9 http://ftpmaster.internal/ubuntu noble/main ppc64el automake all 1:1.16.5-1.3ubuntu1 [558 kB] 651s Get:10 http://ftpmaster.internal/ubuntu noble/main ppc64el autopoint all 0.21-14ubuntu1 [422 kB] 651s Get:11 http://ftpmaster.internal/ubuntu noble/main ppc64el libc-dev-bin ppc64el 2.39-0ubuntu6 [21.3 kB] 651s Get:12 http://ftpmaster.internal/ubuntu noble/main ppc64el linux-libc-dev ppc64el 6.8.0-11.11 [1585 kB] 651s Get:13 http://ftpmaster.internal/ubuntu noble/main ppc64el libcrypt-dev ppc64el 1:4.4.36-4 [167 kB] 651s Get:14 http://ftpmaster.internal/ubuntu noble/main ppc64el rpcsvc-proto ppc64el 1.4.2-0ubuntu6 [82.3 kB] 651s Get:15 http://ftpmaster.internal/ubuntu noble/main ppc64el libc6-dev ppc64el 2.39-0ubuntu6 [2102 kB] 651s Get:16 http://ftpmaster.internal/ubuntu noble/main ppc64el libisl23 ppc64el 0.26-3 [864 kB] 651s Get:17 http://ftpmaster.internal/ubuntu noble/main ppc64el libmpc3 ppc64el 1.3.1-1 [61.2 kB] 651s Get:18 http://ftpmaster.internal/ubuntu noble/main ppc64el cpp-13-powerpc64le-linux-gnu ppc64el 13.2.0-17ubuntu2 [10.7 MB] 651s Get:19 http://ftpmaster.internal/ubuntu noble/main ppc64el cpp-13 ppc64el 13.2.0-17ubuntu2 [1038 B] 651s Get:20 http://ftpmaster.internal/ubuntu noble/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [5330 B] 651s Get:21 http://ftpmaster.internal/ubuntu noble/main ppc64el cpp ppc64el 4:13.2.0-7ubuntu1 [22.5 kB] 651s Get:22 http://ftpmaster.internal/ubuntu noble/main ppc64el libcc1-0 ppc64el 14-20240303-1ubuntu1 [48.1 kB] 651s Get:23 http://ftpmaster.internal/ubuntu noble/main ppc64el libgomp1 ppc64el 14-20240303-1ubuntu1 [161 kB] 651s Get:24 http://ftpmaster.internal/ubuntu noble/main ppc64el libitm1 ppc64el 14-20240303-1ubuntu1 [32.4 kB] 651s Get:25 http://ftpmaster.internal/ubuntu noble/main ppc64el libatomic1 ppc64el 14-20240303-1ubuntu1 [10.7 kB] 651s Get:26 http://ftpmaster.internal/ubuntu noble/main ppc64el libasan8 ppc64el 14-20240303-1ubuntu1 [2973 kB] 652s Get:27 http://ftpmaster.internal/ubuntu noble/main ppc64el liblsan0 ppc64el 14-20240303-1ubuntu1 [1325 kB] 652s Get:28 http://ftpmaster.internal/ubuntu noble/main ppc64el libtsan2 ppc64el 14-20240303-1ubuntu1 [2734 kB] 652s Get:29 http://ftpmaster.internal/ubuntu noble/main ppc64el libubsan1 ppc64el 14-20240303-1ubuntu1 [1194 kB] 652s Get:30 http://ftpmaster.internal/ubuntu noble/main ppc64el libquadmath0 ppc64el 14-20240303-1ubuntu1 [158 kB] 652s Get:31 http://ftpmaster.internal/ubuntu noble/main ppc64el libgcc-13-dev ppc64el 13.2.0-17ubuntu2 [1581 kB] 652s Get:32 http://ftpmaster.internal/ubuntu noble/main ppc64el gcc-13-powerpc64le-linux-gnu ppc64el 13.2.0-17ubuntu2 [20.6 MB] 652s Get:33 http://ftpmaster.internal/ubuntu noble/main ppc64el gcc-13 ppc64el 13.2.0-17ubuntu2 [477 kB] 652s Get:34 http://ftpmaster.internal/ubuntu noble/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [1224 B] 652s Get:35 http://ftpmaster.internal/ubuntu noble/main ppc64el gcc ppc64el 4:13.2.0-7ubuntu1 [5022 B] 652s Get:36 http://ftpmaster.internal/ubuntu noble/main ppc64el libstdc++-13-dev ppc64el 13.2.0-17ubuntu2 [2445 kB] 652s Get:37 http://ftpmaster.internal/ubuntu noble/main ppc64el g++-13-powerpc64le-linux-gnu ppc64el 13.2.0-17ubuntu2 [12.2 MB] 653s Get:38 http://ftpmaster.internal/ubuntu noble/main ppc64el g++-13 ppc64el 13.2.0-17ubuntu2 [14.5 kB] 653s Get:39 http://ftpmaster.internal/ubuntu noble/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [968 B] 653s Get:40 http://ftpmaster.internal/ubuntu noble/main ppc64el g++ ppc64el 4:13.2.0-7ubuntu1 [1086 B] 653s Get:41 http://ftpmaster.internal/ubuntu noble/main ppc64el build-essential ppc64el 12.10ubuntu1 [4936 B] 653s Get:42 http://ftpmaster.internal/ubuntu noble/main ppc64el libllvm17 ppc64el 1:17.0.6-5build1 [27.3 MB] 653s Get:43 http://ftpmaster.internal/ubuntu noble/universe ppc64el libclang-cpp17 ppc64el 1:17.0.6-5build1 [13.7 MB] 654s Get:44 http://ftpmaster.internal/ubuntu noble/main ppc64el libgc1 ppc64el 1:8.2.6-1 [114 kB] 654s Get:45 http://ftpmaster.internal/ubuntu noble/universe ppc64el libobjc4 ppc64el 14-20240303-1ubuntu1 [53.1 kB] 654s Get:46 http://ftpmaster.internal/ubuntu noble/universe ppc64el libobjc-13-dev ppc64el 13.2.0-17ubuntu2 [201 kB] 654s Get:47 http://ftpmaster.internal/ubuntu noble/universe ppc64el libclang-common-17-dev all 1:17.0.6-5build1 [690 kB] 654s Get:48 http://ftpmaster.internal/ubuntu noble/universe ppc64el llvm-17-linker-tools ppc64el 1:17.0.6-5build1 [1376 kB] 654s Get:49 http://ftpmaster.internal/ubuntu noble/universe ppc64el libclang1-17 ppc64el 1:17.0.6-5build1 [8167 kB] 654s Get:50 http://ftpmaster.internal/ubuntu noble/universe ppc64el clang-17 ppc64el 1:17.0.6-5build1 [82.7 kB] 654s Get:51 http://ftpmaster.internal/ubuntu noble/main ppc64el libdebhelper-perl all 13.14.1ubuntu1 [89.5 kB] 654s Get:52 http://ftpmaster.internal/ubuntu noble/main ppc64el libtool all 2.4.7-7 [166 kB] 654s Get:53 http://ftpmaster.internal/ubuntu noble/main ppc64el dh-autoreconf all 20 [16.1 kB] 654s Get:54 http://ftpmaster.internal/ubuntu noble/main ppc64el libarchive-zip-perl all 1.68-1 [90.2 kB] 654s Get:55 http://ftpmaster.internal/ubuntu noble/main ppc64el libsub-override-perl all 0.10-1 [10.0 kB] 654s Get:56 http://ftpmaster.internal/ubuntu noble/main ppc64el libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 654s Get:57 http://ftpmaster.internal/ubuntu noble/main ppc64el dh-strip-nondeterminism all 1.13.1-1 [5362 B] 654s Get:58 http://ftpmaster.internal/ubuntu noble/main ppc64el libdw1 ppc64el 0.190-1 [294 kB] 654s Get:59 http://ftpmaster.internal/ubuntu noble/main ppc64el debugedit ppc64el 1:5.0-5 [51.1 kB] 654s Get:60 http://ftpmaster.internal/ubuntu noble/main ppc64el dwz ppc64el 0.15-1 [139 kB] 654s Get:61 http://ftpmaster.internal/ubuntu noble/main ppc64el gettext ppc64el 0.21-14ubuntu1 [979 kB] 654s Get:62 http://ftpmaster.internal/ubuntu noble/main ppc64el intltool-debian all 0.35.0+20060710.6 [23.2 kB] 654s Get:63 http://ftpmaster.internal/ubuntu noble/main ppc64el po-debconf all 1.0.21+nmu1 [233 kB] 654s Get:64 http://ftpmaster.internal/ubuntu noble/main ppc64el debhelper all 13.14.1ubuntu1 [869 kB] 654s Get:65 http://ftpmaster.internal/ubuntu noble/main ppc64el emacsen-common all 3.0.5 [12.1 kB] 654s Get:66 http://ftpmaster.internal/ubuntu noble/main ppc64el dictionaries-common all 1.29.7 [188 kB] 654s Get:67 http://ftpmaster.internal/ubuntu noble/main ppc64el libfakeroot ppc64el 1.33-1 [34.4 kB] 654s Get:68 http://ftpmaster.internal/ubuntu noble/main ppc64el fakeroot ppc64el 1.33-1 [69.2 kB] 654s Get:69 http://ftpmaster.internal/ubuntu noble/main ppc64el hunspell-en-us all 1:2020.12.07-2 [280 kB] 654s Get:70 http://ftpmaster.internal/ubuntu noble/main ppc64el icu-devtools ppc64el 74.2-1ubuntu1 [246 kB] 654s Get:71 http://ftpmaster.internal/ubuntu noble/main ppc64el libpgtypes3 ppc64el 16.2-1 [49.4 kB] 654s Get:72 http://ftpmaster.internal/ubuntu noble/main ppc64el libpq5 ppc64el 16.2-1 [170 kB] 654s Get:73 http://ftpmaster.internal/ubuntu noble/main ppc64el libecpg6 ppc64el 16.2-1 [54.6 kB] 654s Get:74 http://ftpmaster.internal/ubuntu noble/main ppc64el libecpg-compat3 ppc64el 16.2-1 [19.7 kB] 654s Get:75 http://ftpmaster.internal/ubuntu noble/main ppc64el libssl-dev ppc64el 3.0.10-1ubuntu4 [2664 kB] 654s Get:76 http://ftpmaster.internal/ubuntu noble/main ppc64el libpq-dev ppc64el 16.2-1 [172 kB] 654s Get:77 http://ftpmaster.internal/ubuntu noble/main ppc64el libecpg-dev ppc64el 16.2-1 [282 kB] 654s Get:78 http://ftpmaster.internal/ubuntu noble/main ppc64el libicu-dev ppc64el 74.2-1ubuntu1 [12.5 MB] 654s Get:79 http://ftpmaster.internal/ubuntu noble/main ppc64el libncurses-dev ppc64el 6.4+20240113-1ubuntu1 [485 kB] 654s Get:80 http://ftpmaster.internal/ubuntu noble/main ppc64el libpython3.12 ppc64el 3.12.2-1 [2575 kB] 654s Get:81 http://ftpmaster.internal/ubuntu noble/main ppc64el libtcl8.6 ppc64el 8.6.13+dfsg-2 [1179 kB] 655s Get:82 http://ftpmaster.internal/ubuntu noble/main ppc64el libxml2-dev ppc64el 2.9.14+dfsg-1.3ubuntu1 [923 kB] 655s Get:83 http://ftpmaster.internal/ubuntu noble/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1 [192 kB] 655s Get:84 http://ftpmaster.internal/ubuntu noble/universe ppc64el llvm-17-runtime ppc64el 1:17.0.6-5build1 [573 kB] 655s Get:85 http://ftpmaster.internal/ubuntu noble/universe ppc64el libpfm4 ppc64el 4.13.0+git32-g0d4ed0e-1 [189 kB] 655s Get:86 http://ftpmaster.internal/ubuntu noble/universe ppc64el llvm-17 ppc64el 1:17.0.6-5build1 [27.6 MB] 655s Get:87 http://ftpmaster.internal/ubuntu noble/main ppc64el libffi-dev ppc64el 3.4.6-1 [67.4 kB] 655s Get:88 http://ftpmaster.internal/ubuntu noble/universe ppc64el llvm-17-tools ppc64el 1:17.0.6-5build1 [629 kB] 655s Get:89 http://ftpmaster.internal/ubuntu noble/universe ppc64el libz3-4 ppc64el 4.8.12-3.1 [5983 kB] 655s Get:90 http://ftpmaster.internal/ubuntu noble/universe ppc64el libz3-dev ppc64el 4.8.12-3.1 [72.2 kB] 655s Get:91 http://ftpmaster.internal/ubuntu noble/universe ppc64el llvm-17-dev ppc64el 1:17.0.6-5build1 [43.0 MB] 656s Get:92 http://ftpmaster.internal/ubuntu noble/universe ppc64el locales-all ppc64el 2.39-0ubuntu6 [11.0 MB] 657s Get:93 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-16 ppc64el 16.2-1 [1399 kB] 657s Get:94 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-16 ppc64el 16.2-1 [16.9 MB] 657s Get:95 http://ftpmaster.internal/ubuntu noble/universe ppc64el postgresql-server-dev-16 ppc64el 16.2-1 [1269 kB] 657s Get:96 http://ftpmaster.internal/ubuntu noble/universe ppc64el postgresql-server-dev-all ppc64el 257 [20.3 kB] 657s Get:97 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-plperl-16 ppc64el 16.2-1 [75.2 kB] 657s Get:98 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-plpython3-16 ppc64el 16.2-1 [78.7 kB] 657s Get:99 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-pltcl-16 ppc64el 16.2-1 [31.2 kB] 657s Get:100 http://ftpmaster.internal/ubuntu noble/universe ppc64el postgresql-all all 257 [1714 B] 657s Get:101 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-doc-16 all 16.2-1 [2093 kB] 657s Get:102 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-doc all 16+257 [11.4 kB] 657s Preconfiguring packages ... 658s Fetched 251 MB in 7s (36.7 MB/s) 658s Selecting previously unselected package libjson-perl. 658s (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 ... 69713 files and directories currently installed.) 658s Preparing to unpack .../000-libjson-perl_4.10000-1_all.deb ... 658s Unpacking libjson-perl (4.10000-1) ... 658s Selecting previously unselected package postgresql-client-common. 658s Preparing to unpack .../001-postgresql-client-common_257_all.deb ... 658s Unpacking postgresql-client-common (257) ... 658s Selecting previously unselected package ssl-cert. 658s Preparing to unpack .../002-ssl-cert_1.1.2ubuntu1_all.deb ... 658s Unpacking ssl-cert (1.1.2ubuntu1) ... 658s Selecting previously unselected package postgresql-common. 658s Preparing to unpack .../003-postgresql-common_257_all.deb ... 658s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 658s Unpacking postgresql-common (257) ... 658s Selecting previously unselected package m4. 658s Preparing to unpack .../004-m4_1.4.19-4_ppc64el.deb ... 658s Unpacking m4 (1.4.19-4) ... 658s Selecting previously unselected package autoconf. 658s Preparing to unpack .../005-autoconf_2.71-3_all.deb ... 658s Unpacking autoconf (2.71-3) ... 658s Selecting previously unselected package autotools-dev. 658s Preparing to unpack .../006-autotools-dev_20220109.1_all.deb ... 658s Unpacking autotools-dev (20220109.1) ... 658s Selecting previously unselected package automake. 658s Preparing to unpack .../007-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 658s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 658s Selecting previously unselected package autopoint. 658s Preparing to unpack .../008-autopoint_0.21-14ubuntu1_all.deb ... 658s Unpacking autopoint (0.21-14ubuntu1) ... 658s Selecting previously unselected package libc-dev-bin. 658s Preparing to unpack .../009-libc-dev-bin_2.39-0ubuntu6_ppc64el.deb ... 658s Unpacking libc-dev-bin (2.39-0ubuntu6) ... 658s Selecting previously unselected package linux-libc-dev:ppc64el. 658s Preparing to unpack .../010-linux-libc-dev_6.8.0-11.11_ppc64el.deb ... 658s Unpacking linux-libc-dev:ppc64el (6.8.0-11.11) ... 658s Selecting previously unselected package libcrypt-dev:ppc64el. 658s Preparing to unpack .../011-libcrypt-dev_1%3a4.4.36-4_ppc64el.deb ... 658s Unpacking libcrypt-dev:ppc64el (1:4.4.36-4) ... 658s Selecting previously unselected package rpcsvc-proto. 658s Preparing to unpack .../012-rpcsvc-proto_1.4.2-0ubuntu6_ppc64el.deb ... 658s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 658s Selecting previously unselected package libc6-dev:ppc64el. 658s Preparing to unpack .../013-libc6-dev_2.39-0ubuntu6_ppc64el.deb ... 658s Unpacking libc6-dev:ppc64el (2.39-0ubuntu6) ... 658s Selecting previously unselected package libisl23:ppc64el. 658s Preparing to unpack .../014-libisl23_0.26-3_ppc64el.deb ... 658s Unpacking libisl23:ppc64el (0.26-3) ... 658s Selecting previously unselected package libmpc3:ppc64el. 658s Preparing to unpack .../015-libmpc3_1.3.1-1_ppc64el.deb ... 658s Unpacking libmpc3:ppc64el (1.3.1-1) ... 658s Selecting previously unselected package cpp-13-powerpc64le-linux-gnu. 658s Preparing to unpack .../016-cpp-13-powerpc64le-linux-gnu_13.2.0-17ubuntu2_ppc64el.deb ... 658s Unpacking cpp-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 659s Selecting previously unselected package cpp-13. 659s Preparing to unpack .../017-cpp-13_13.2.0-17ubuntu2_ppc64el.deb ... 659s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 659s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 659s Preparing to unpack .../018-cpp-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 659s Unpacking cpp-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 659s Selecting previously unselected package cpp. 659s Preparing to unpack .../019-cpp_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 659s Unpacking cpp (4:13.2.0-7ubuntu1) ... 659s Selecting previously unselected package libcc1-0:ppc64el. 659s Preparing to unpack .../020-libcc1-0_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libcc1-0:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libgomp1:ppc64el. 659s Preparing to unpack .../021-libgomp1_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libgomp1:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libitm1:ppc64el. 659s Preparing to unpack .../022-libitm1_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libitm1:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libatomic1:ppc64el. 659s Preparing to unpack .../023-libatomic1_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libatomic1:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libasan8:ppc64el. 659s Preparing to unpack .../024-libasan8_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libasan8:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package liblsan0:ppc64el. 659s Preparing to unpack .../025-liblsan0_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking liblsan0:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libtsan2:ppc64el. 659s Preparing to unpack .../026-libtsan2_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libtsan2:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libubsan1:ppc64el. 659s Preparing to unpack .../027-libubsan1_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libubsan1:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libquadmath0:ppc64el. 659s Preparing to unpack .../028-libquadmath0_14-20240303-1ubuntu1_ppc64el.deb ... 659s Unpacking libquadmath0:ppc64el (14-20240303-1ubuntu1) ... 659s Selecting previously unselected package libgcc-13-dev:ppc64el. 659s Preparing to unpack .../029-libgcc-13-dev_13.2.0-17ubuntu2_ppc64el.deb ... 659s Unpacking libgcc-13-dev:ppc64el (13.2.0-17ubuntu2) ... 659s Selecting previously unselected package gcc-13-powerpc64le-linux-gnu. 659s Preparing to unpack .../030-gcc-13-powerpc64le-linux-gnu_13.2.0-17ubuntu2_ppc64el.deb ... 659s Unpacking gcc-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 660s Selecting previously unselected package gcc-13. 660s Preparing to unpack .../031-gcc-13_13.2.0-17ubuntu2_ppc64el.deb ... 660s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 660s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 660s Preparing to unpack .../032-gcc-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 660s Unpacking gcc-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 660s Selecting previously unselected package gcc. 660s Preparing to unpack .../033-gcc_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 660s Unpacking gcc (4:13.2.0-7ubuntu1) ... 660s Selecting previously unselected package libstdc++-13-dev:ppc64el. 660s Preparing to unpack .../034-libstdc++-13-dev_13.2.0-17ubuntu2_ppc64el.deb ... 660s Unpacking libstdc++-13-dev:ppc64el (13.2.0-17ubuntu2) ... 660s Selecting previously unselected package g++-13-powerpc64le-linux-gnu. 660s Preparing to unpack .../035-g++-13-powerpc64le-linux-gnu_13.2.0-17ubuntu2_ppc64el.deb ... 660s Unpacking g++-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 660s Selecting previously unselected package g++-13. 660s Preparing to unpack .../036-g++-13_13.2.0-17ubuntu2_ppc64el.deb ... 660s Unpacking g++-13 (13.2.0-17ubuntu2) ... 660s Selecting previously unselected package g++-powerpc64le-linux-gnu. 660s Preparing to unpack .../037-g++-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 660s Unpacking g++-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 660s Selecting previously unselected package g++. 660s Preparing to unpack .../038-g++_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 660s Unpacking g++ (4:13.2.0-7ubuntu1) ... 660s Selecting previously unselected package build-essential. 660s Preparing to unpack .../039-build-essential_12.10ubuntu1_ppc64el.deb ... 660s Unpacking build-essential (12.10ubuntu1) ... 660s Selecting previously unselected package libllvm17:ppc64el. 660s Preparing to unpack .../040-libllvm17_1%3a17.0.6-5build1_ppc64el.deb ... 660s Unpacking libllvm17:ppc64el (1:17.0.6-5build1) ... 661s Selecting previously unselected package libclang-cpp17. 661s Preparing to unpack .../041-libclang-cpp17_1%3a17.0.6-5build1_ppc64el.deb ... 661s Unpacking libclang-cpp17 (1:17.0.6-5build1) ... 662s Selecting previously unselected package libgc1:ppc64el. 662s Preparing to unpack .../042-libgc1_1%3a8.2.6-1_ppc64el.deb ... 662s Unpacking libgc1:ppc64el (1:8.2.6-1) ... 662s Selecting previously unselected package libobjc4:ppc64el. 662s Preparing to unpack .../043-libobjc4_14-20240303-1ubuntu1_ppc64el.deb ... 662s Unpacking libobjc4:ppc64el (14-20240303-1ubuntu1) ... 662s Selecting previously unselected package libobjc-13-dev:ppc64el. 662s Preparing to unpack .../044-libobjc-13-dev_13.2.0-17ubuntu2_ppc64el.deb ... 662s Unpacking libobjc-13-dev:ppc64el (13.2.0-17ubuntu2) ... 662s Selecting previously unselected package libclang-common-17-dev. 662s Preparing to unpack .../045-libclang-common-17-dev_1%3a17.0.6-5build1_all.deb ... 662s Unpacking libclang-common-17-dev (1:17.0.6-5build1) ... 662s Selecting previously unselected package llvm-17-linker-tools. 662s Preparing to unpack .../046-llvm-17-linker-tools_1%3a17.0.6-5build1_ppc64el.deb ... 662s Unpacking llvm-17-linker-tools (1:17.0.6-5build1) ... 662s Selecting previously unselected package libclang1-17. 662s Preparing to unpack .../047-libclang1-17_1%3a17.0.6-5build1_ppc64el.deb ... 662s Unpacking libclang1-17 (1:17.0.6-5build1) ... 662s Selecting previously unselected package clang-17. 662s Preparing to unpack .../048-clang-17_1%3a17.0.6-5build1_ppc64el.deb ... 662s Unpacking clang-17 (1:17.0.6-5build1) ... 662s Selecting previously unselected package libdebhelper-perl. 662s Preparing to unpack .../049-libdebhelper-perl_13.14.1ubuntu1_all.deb ... 662s Unpacking libdebhelper-perl (13.14.1ubuntu1) ... 662s Selecting previously unselected package libtool. 662s Preparing to unpack .../050-libtool_2.4.7-7_all.deb ... 662s Unpacking libtool (2.4.7-7) ... 663s Selecting previously unselected package dh-autoreconf. 663s Preparing to unpack .../051-dh-autoreconf_20_all.deb ... 663s Unpacking dh-autoreconf (20) ... 663s Selecting previously unselected package libarchive-zip-perl. 663s Preparing to unpack .../052-libarchive-zip-perl_1.68-1_all.deb ... 663s Unpacking libarchive-zip-perl (1.68-1) ... 663s Selecting previously unselected package libsub-override-perl. 663s Preparing to unpack .../053-libsub-override-perl_0.10-1_all.deb ... 663s Unpacking libsub-override-perl (0.10-1) ... 663s Selecting previously unselected package libfile-stripnondeterminism-perl. 663s Preparing to unpack .../054-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 663s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 663s Selecting previously unselected package dh-strip-nondeterminism. 663s Preparing to unpack .../055-dh-strip-nondeterminism_1.13.1-1_all.deb ... 663s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 663s Selecting previously unselected package libdw1:ppc64el. 663s Preparing to unpack .../056-libdw1_0.190-1_ppc64el.deb ... 663s Unpacking libdw1:ppc64el (0.190-1) ... 663s Selecting previously unselected package debugedit. 663s Preparing to unpack .../057-debugedit_1%3a5.0-5_ppc64el.deb ... 663s Unpacking debugedit (1:5.0-5) ... 663s Selecting previously unselected package dwz. 663s Preparing to unpack .../058-dwz_0.15-1_ppc64el.deb ... 663s Unpacking dwz (0.15-1) ... 663s Selecting previously unselected package gettext. 663s Preparing to unpack .../059-gettext_0.21-14ubuntu1_ppc64el.deb ... 663s Unpacking gettext (0.21-14ubuntu1) ... 663s Selecting previously unselected package intltool-debian. 663s Preparing to unpack .../060-intltool-debian_0.35.0+20060710.6_all.deb ... 663s Unpacking intltool-debian (0.35.0+20060710.6) ... 663s Selecting previously unselected package po-debconf. 663s Preparing to unpack .../061-po-debconf_1.0.21+nmu1_all.deb ... 663s Unpacking po-debconf (1.0.21+nmu1) ... 663s Selecting previously unselected package debhelper. 663s Preparing to unpack .../062-debhelper_13.14.1ubuntu1_all.deb ... 663s Unpacking debhelper (13.14.1ubuntu1) ... 663s Selecting previously unselected package emacsen-common. 663s Preparing to unpack .../063-emacsen-common_3.0.5_all.deb ... 663s Unpacking emacsen-common (3.0.5) ... 663s Selecting previously unselected package dictionaries-common. 663s Preparing to unpack .../064-dictionaries-common_1.29.7_all.deb ... 663s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 663s Unpacking dictionaries-common (1.29.7) ... 663s Selecting previously unselected package libfakeroot:ppc64el. 663s Preparing to unpack .../065-libfakeroot_1.33-1_ppc64el.deb ... 663s Unpacking libfakeroot:ppc64el (1.33-1) ... 663s Selecting previously unselected package fakeroot. 663s Preparing to unpack .../066-fakeroot_1.33-1_ppc64el.deb ... 663s Unpacking fakeroot (1.33-1) ... 663s Selecting previously unselected package hunspell-en-us. 663s Preparing to unpack .../067-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 663s Unpacking hunspell-en-us (1:2020.12.07-2) ... 663s Selecting previously unselected package icu-devtools. 663s Preparing to unpack .../068-icu-devtools_74.2-1ubuntu1_ppc64el.deb ... 663s Unpacking icu-devtools (74.2-1ubuntu1) ... 663s Selecting previously unselected package libpgtypes3:ppc64el. 663s Preparing to unpack .../069-libpgtypes3_16.2-1_ppc64el.deb ... 663s Unpacking libpgtypes3:ppc64el (16.2-1) ... 663s Selecting previously unselected package libpq5:ppc64el. 663s Preparing to unpack .../070-libpq5_16.2-1_ppc64el.deb ... 663s Unpacking libpq5:ppc64el (16.2-1) ... 663s Selecting previously unselected package libecpg6:ppc64el. 663s Preparing to unpack .../071-libecpg6_16.2-1_ppc64el.deb ... 663s Unpacking libecpg6:ppc64el (16.2-1) ... 663s Selecting previously unselected package libecpg-compat3:ppc64el. 663s Preparing to unpack .../072-libecpg-compat3_16.2-1_ppc64el.deb ... 663s Unpacking libecpg-compat3:ppc64el (16.2-1) ... 663s Selecting previously unselected package libssl-dev:ppc64el. 663s Preparing to unpack .../073-libssl-dev_3.0.10-1ubuntu4_ppc64el.deb ... 663s Unpacking libssl-dev:ppc64el (3.0.10-1ubuntu4) ... 663s Selecting previously unselected package libpq-dev. 663s Preparing to unpack .../074-libpq-dev_16.2-1_ppc64el.deb ... 663s Unpacking libpq-dev (16.2-1) ... 663s Selecting previously unselected package libecpg-dev. 663s Preparing to unpack .../075-libecpg-dev_16.2-1_ppc64el.deb ... 663s Unpacking libecpg-dev (16.2-1) ... 663s Selecting previously unselected package libicu-dev:ppc64el. 663s Preparing to unpack .../076-libicu-dev_74.2-1ubuntu1_ppc64el.deb ... 663s Unpacking libicu-dev:ppc64el (74.2-1ubuntu1) ... 664s Selecting previously unselected package libncurses-dev:ppc64el. 664s Preparing to unpack .../077-libncurses-dev_6.4+20240113-1ubuntu1_ppc64el.deb ... 664s Unpacking libncurses-dev:ppc64el (6.4+20240113-1ubuntu1) ... 664s Selecting previously unselected package libpython3.12:ppc64el. 664s Preparing to unpack .../078-libpython3.12_3.12.2-1_ppc64el.deb ... 664s Unpacking libpython3.12:ppc64el (3.12.2-1) ... 664s Selecting previously unselected package libtcl8.6:ppc64el. 664s Preparing to unpack .../079-libtcl8.6_8.6.13+dfsg-2_ppc64el.deb ... 664s Unpacking libtcl8.6:ppc64el (8.6.13+dfsg-2) ... 664s Selecting previously unselected package libxml2-dev:ppc64el. 664s Preparing to unpack .../080-libxml2-dev_2.9.14+dfsg-1.3ubuntu1_ppc64el.deb ... 664s Unpacking libxml2-dev:ppc64el (2.9.14+dfsg-1.3ubuntu1) ... 664s Selecting previously unselected package libxslt1.1:ppc64el. 664s Preparing to unpack .../081-libxslt1.1_1.1.39-0exp1_ppc64el.deb ... 664s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1) ... 664s Selecting previously unselected package llvm-17-runtime. 664s Preparing to unpack .../082-llvm-17-runtime_1%3a17.0.6-5build1_ppc64el.deb ... 664s Unpacking llvm-17-runtime (1:17.0.6-5build1) ... 664s Selecting previously unselected package libpfm4:ppc64el. 664s Preparing to unpack .../083-libpfm4_4.13.0+git32-g0d4ed0e-1_ppc64el.deb ... 664s Unpacking libpfm4:ppc64el (4.13.0+git32-g0d4ed0e-1) ... 664s Selecting previously unselected package llvm-17. 664s Preparing to unpack .../084-llvm-17_1%3a17.0.6-5build1_ppc64el.deb ... 664s Unpacking llvm-17 (1:17.0.6-5build1) ... 665s Selecting previously unselected package libffi-dev:ppc64el. 665s Preparing to unpack .../085-libffi-dev_3.4.6-1_ppc64el.deb ... 665s Unpacking libffi-dev:ppc64el (3.4.6-1) ... 665s Selecting previously unselected package llvm-17-tools. 665s Preparing to unpack .../086-llvm-17-tools_1%3a17.0.6-5build1_ppc64el.deb ... 665s Unpacking llvm-17-tools (1:17.0.6-5build1) ... 665s Selecting previously unselected package libz3-4:ppc64el. 665s Preparing to unpack .../087-libz3-4_4.8.12-3.1_ppc64el.deb ... 665s Unpacking libz3-4:ppc64el (4.8.12-3.1) ... 665s Selecting previously unselected package libz3-dev:ppc64el. 665s Preparing to unpack .../088-libz3-dev_4.8.12-3.1_ppc64el.deb ... 665s Unpacking libz3-dev:ppc64el (4.8.12-3.1) ... 665s Selecting previously unselected package llvm-17-dev. 665s Preparing to unpack .../089-llvm-17-dev_1%3a17.0.6-5build1_ppc64el.deb ... 665s Unpacking llvm-17-dev (1:17.0.6-5build1) ... 668s Selecting previously unselected package locales-all. 668s Preparing to unpack .../090-locales-all_2.39-0ubuntu6_ppc64el.deb ... 668s Unpacking locales-all (2.39-0ubuntu6) ... 672s Selecting previously unselected package postgresql-client-16. 672s Preparing to unpack .../091-postgresql-client-16_16.2-1_ppc64el.deb ... 672s Unpacking postgresql-client-16 (16.2-1) ... 672s Selecting previously unselected package postgresql-16. 672s Preparing to unpack .../092-postgresql-16_16.2-1_ppc64el.deb ... 672s Unpacking postgresql-16 (16.2-1) ... 672s Selecting previously unselected package postgresql-server-dev-16. 672s Preparing to unpack .../093-postgresql-server-dev-16_16.2-1_ppc64el.deb ... 672s Unpacking postgresql-server-dev-16 (16.2-1) ... 673s Selecting previously unselected package postgresql-server-dev-all:ppc64el. 673s Preparing to unpack .../094-postgresql-server-dev-all_257_ppc64el.deb ... 673s Unpacking postgresql-server-dev-all:ppc64el (257) ... 673s Selecting previously unselected package postgresql-plperl-16. 673s Preparing to unpack .../095-postgresql-plperl-16_16.2-1_ppc64el.deb ... 673s Unpacking postgresql-plperl-16 (16.2-1) ... 673s Selecting previously unselected package postgresql-plpython3-16. 673s Preparing to unpack .../096-postgresql-plpython3-16_16.2-1_ppc64el.deb ... 673s Unpacking postgresql-plpython3-16 (16.2-1) ... 673s Selecting previously unselected package postgresql-pltcl-16. 673s Preparing to unpack .../097-postgresql-pltcl-16_16.2-1_ppc64el.deb ... 673s Unpacking postgresql-pltcl-16 (16.2-1) ... 673s Selecting previously unselected package postgresql-all. 673s Preparing to unpack .../098-postgresql-all_257_all.deb ... 673s Unpacking postgresql-all (257) ... 673s Selecting previously unselected package postgresql-doc-16. 673s Preparing to unpack .../099-postgresql-doc-16_16.2-1_all.deb ... 673s Unpacking postgresql-doc-16 (16.2-1) ... 673s Selecting previously unselected package postgresql-doc. 673s Preparing to unpack .../100-postgresql-doc_16+257_all.deb ... 673s Unpacking postgresql-doc (16+257) ... 673s Selecting previously unselected package autopkgtest-satdep. 673s Preparing to unpack .../101-2-autopkgtest-satdep.deb ... 673s Unpacking autopkgtest-satdep (0) ... 673s Setting up postgresql-client-common (257) ... 673s Setting up libpgtypes3:ppc64el (16.2-1) ... 673s Setting up libdw1:ppc64el (0.190-1) ... 673s Setting up postgresql-doc-16 (16.2-1) ... 673s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 673s Setting up libarchive-zip-perl (1.68-1) ... 673s Setting up libdebhelper-perl (13.14.1ubuntu1) ... 673s Setting up libpq5:ppc64el (16.2-1) ... 673s Setting up linux-libc-dev:ppc64el (6.8.0-11.11) ... 673s Setting up m4 (1.4.19-4) ... 673s Setting up libgomp1:ppc64el (14-20240303-1ubuntu1) ... 673s Setting up libffi-dev:ppc64el (3.4.6-1) ... 673s Setting up locales-all (2.39-0ubuntu6) ... 673s Setting up libfakeroot:ppc64el (1.33-1) ... 673s Setting up fakeroot (1.33-1) ... 673s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 673s Setting up autotools-dev (20220109.1) ... 673s Setting up libz3-4:ppc64el (4.8.12-3.1) ... 673s Setting up libpfm4:ppc64el (4.13.0+git32-g0d4ed0e-1) ... 673s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 673s Setting up emacsen-common (3.0.5) ... 673s Setting up ssl-cert (1.1.2ubuntu1) ... 674s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 674s Setting up libquadmath0:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up libssl-dev:ppc64el (3.0.10-1ubuntu4) ... 674s Setting up libmpc3:ppc64el (1.3.1-1) ... 674s Setting up libatomic1:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up libtcl8.6:ppc64el (8.6.13+dfsg-2) ... 674s Setting up autopoint (0.21-14ubuntu1) ... 674s Setting up icu-devtools (74.2-1ubuntu1) ... 674s Setting up libgc1:ppc64el (1:8.2.6-1) ... 674s Setting up autoconf (2.71-3) ... 674s Setting up libubsan1:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up llvm-17-tools (1:17.0.6-5build1) ... 674s Setting up dwz (0.15-1) ... 674s Setting up libclang-common-17-dev (1:17.0.6-5build1) ... 674s Setting up libcrypt-dev:ppc64el (1:4.4.36-4) ... 674s Setting up libasan8:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up libjson-perl (4.10000-1) ... 674s Setting up postgresql-doc (16+257) ... 674s Setting up libxslt1.1:ppc64el (1.1.39-0exp1) ... 674s Setting up debugedit (1:5.0-5) ... 674s Setting up libecpg6:ppc64el (16.2-1) ... 674s Setting up libsub-override-perl (0.10-1) ... 674s Setting up libtsan2:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up libisl23:ppc64el (0.26-3) ... 674s Setting up libc-dev-bin (2.39-0ubuntu6) ... 674s Setting up cpp-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 674s Setting up libllvm17:ppc64el (1:17.0.6-5build1) ... 674s Setting up libpython3.12:ppc64el (3.12.2-1) ... 674s Setting up libcc1-0:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up liblsan0:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up libitm1:ppc64el (14-20240303-1ubuntu1) ... 674s Setting up cpp-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 674s Setting up automake (1:1.16.5-1.3ubuntu1) ... 674s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 674s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 674s Setting up libz3-dev:ppc64el (4.8.12-3.1) ... 674s Setting up gettext (0.21-14ubuntu1) ... 674s Setting up llvm-17-linker-tools (1:17.0.6-5build1) ... 674s Setting up libecpg-compat3:ppc64el (16.2-1) ... 674s Setting up cpp-13 (13.2.0-17ubuntu2) ... 674s Setting up dictionaries-common (1.29.7) ... 675s Setting up libclang1-17 (1:17.0.6-5build1) ... 675s Setting up postgresql-client-16 (16.2-1) ... 675s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 675s Setting up libpq-dev (16.2-1) ... 675s Setting up libobjc4:ppc64el (14-20240303-1ubuntu1) ... 675s Setting up libecpg-dev (16.2-1) ... 675s Setting up intltool-debian (0.35.0+20060710.6) ... 675s Setting up postgresql-common (257) ... 676s 676s Creating config file /etc/postgresql-common/createcluster.conf with new version 676s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 676s en_us 676s Removing obsolete dictionary files: 676s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 677s Setting up dh-strip-nondeterminism (1.13.1-1) ... 677s Setting up libgcc-13-dev:ppc64el (13.2.0-17ubuntu2) ... 677s Setting up cpp (4:13.2.0-7ubuntu1) ... 677s Setting up llvm-17-runtime (1:17.0.6-5build1) ... 677s Setting up hunspell-en-us (1:2020.12.07-2) ... 677s Setting up libc6-dev:ppc64el (2.39-0ubuntu6) ... 677s Setting up libclang-cpp17 (1:17.0.6-5build1) ... 677s Setting up llvm-17 (1:17.0.6-5build1) ... 677s Setting up libicu-dev:ppc64el (74.2-1ubuntu1) ... 677s Setting up libobjc-13-dev:ppc64el (13.2.0-17ubuntu2) ... 677s Setting up libstdc++-13-dev:ppc64el (13.2.0-17ubuntu2) ... 677s Setting up libncurses-dev:ppc64el (6.4+20240113-1ubuntu1) ... 677s Setting up postgresql-16 (16.2-1) ... 677s Creating new PostgreSQL cluster 16/main ... 677s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 677s The files belonging to this database system will be owned by user "postgres". 677s This user must also own the server process. 677s 677s The database cluster will be initialized with locale "C.UTF-8". 677s The default database encoding has accordingly been set to "UTF8". 677s The default text search configuration will be set to "english". 677s 677s Data page checksums are disabled. 677s 677s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 677s creating subdirectories ... ok 677s selecting dynamic shared memory implementation ... posix 677s selecting default max_connections ... 100 677s selecting default shared_buffers ... 128MB 677s selecting default time zone ... Etc/UTC 677s creating configuration files ... ok 677s running bootstrap script ... ok 678s performing post-bootstrap initialization ... ok 678s syncing data to disk ... ok 682s Setting up po-debconf (1.0.21+nmu1) ... 682s Setting up clang-17 (1:17.0.6-5build1) ... 682s Setting up libxml2-dev:ppc64el (2.9.14+dfsg-1.3ubuntu1) ... 682s Setting up gcc-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 682s Setting up gcc-13 (13.2.0-17ubuntu2) ... 682s Setting up postgresql-plpython3-16 (16.2-1) ... 682s Setting up postgresql-plperl-16 (16.2-1) ... 682s Setting up llvm-17-dev (1:17.0.6-5build1) ... 682s Setting up postgresql-pltcl-16 (16.2-1) ... 682s Setting up libtool (2.4.7-7) ... 682s Setting up g++-13-powerpc64le-linux-gnu (13.2.0-17ubuntu2) ... 682s Setting up dh-autoreconf (20) ... 682s Setting up gcc-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 682s Setting up postgresql-server-dev-16 (16.2-1) ... 682s Setting up postgresql-server-dev-all:ppc64el (257) ... 682s Setting up g++-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 682s Setting up g++-13 (13.2.0-17ubuntu2) ... 682s Setting up debhelper (13.14.1ubuntu1) ... 682s Setting up postgresql-all (257) ... 682s Setting up gcc (4:13.2.0-7ubuntu1) ... 682s Setting up g++ (4:13.2.0-7ubuntu1) ... 682s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 682s Setting up build-essential (12.10ubuntu1) ... 682s Setting up autopkgtest-satdep (0) ... 682s Processing triggers for systemd (255.2-3ubuntu2) ... 682s Processing triggers for man-db (2.12.0-3) ... 684s Processing triggers for install-info (7.1-3) ... 684s Processing triggers for libc-bin (2.39-0ubuntu6) ... 684s Processing triggers for dictionaries-common (1.29.7) ... 686s (Reading database ... 89444 files and directories currently installed.) 686s Removing autopkgtest-satdep (0) ... 688s autopkgtest [20:02:29]: test run-testsuite: [----------------------- 689s ====== Running all tests with umask 077 ======= 689s ### PostgreSQL test 001_packages.t ### 689s 1..22 689s ok 1 - /etc/os-release exists 689s ok 2 - OS is ubuntu 689s ok 3 - OS version is 24.04 689s # PostgreSQL versions installed: 16 689s ok 4 - postgresql-16 installed 689s ok 5 # skip No python2 support 689s ok 6 - postgresql-plpython3-16 installed 689s ok 7 - postgresql-plperl-16 installed 689s ok 8 - postgresql-pltcl-16 installed 689s ok 9 - postgresql-server-dev-16 installed 689s ok 10 # skip No postgresql-contrib-16 package for version 16 689s # postgresql-doc-16 installed 689s ok 11 - At least one doc package installed 689s ok 12 - libecpg-dev installed 689s ok 13 - procps installed 689s ok 14 - netcat-openbsd installed 689s ok 15 - hunspell-en-us installed 689s ok 16 - system has a default UTF-8 locale 689s ok 17 - locale ru_RU exists 689s ok 18 - locale ru_RU.UTF-8 exists 689s ok 19 - user postgres in the UNIX group ssl-cert 689s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 689s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 689s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 689s ### End test 001_packages.t ### 689s 689s ### PostgreSQL test 002_existing_clusters.t ### 689s 1..8 689s # Cleanup 689s ok 1 - Cleanup: No clusters left behind 689s ok 2 - No postgres processes left behind 689s ok 3 - No files in /etc/postgresql left behind 689s ok 4 - No files in /var/lib/postgresql left behind 689s ok 5 - No files in /var/run/postgresql left behind 689s ok 6 - No files in /var/log/postgresql left behind 689s ok 7 - PostgreSQL TCP ports are closed 689s ok 8 - Next free port is 5432 689s ### End test 002_existing_clusters.t ### 689s 689s ### PostgreSQL test 003_alternatives.t ### 689s 1..9 689s # Newest PG version installed is 16 689s ok 1 - psql.1.gz link group 689s ok 2 - postmaster.1.gz link group does not exist 689s ok 3 - psql.1.gz alternative 689s ok 4 - pg_dump.1.gz alternative 689s ok 5 - postgres.1.gz alternative 689s ok 6 - pg_ctl.1.gz alternative 689s # Newest PG doc version installed is 16 689s ok 7 - SPI_connect.3.gz link group 689s ok 8 - SPI_connect.3.gz alternative 689s ok 9 - SPI_exec.3.gz alternative 689s ### End test 003_alternatives.t ### 689s 689s ### PostgreSQL test 005_PgCommon.t ### 689s 1..24 689s ok 1 - correctly parsed line 'local all postgres ident sameuser' 689s ok 2 - correctly parsed line 'local foo nobody trust' 689s ok 3 - correctly parsed line 'local foo nobody crypt' 689s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 689s ok 5 - correctly parsed line 'local foo,bar nobody ident' 689s ok 6 - correctly parsed line 'local all +foogrp password' 689s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 689s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 689s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 689s ok 10 - @expected_records has correct number of entries 689s ok 11 - returned read_pg_hba array has correct number of records 689s ok 12 - line 'foo all all md5' parsed as invalid 689s ok 13 - line 'local all all foo' parsed as invalid 689s ok 14 - line 'host all all foo' parsed as invalid 689s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 689s ok 16 - line 'host all all md5' parsed as invalid 689s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 689s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 689s ok 19 - read_conf_file returns empty dict for nonexisting file 689s ok 20 - read_conf_file() parsing 689s ok 21 - read_conf_file() parsing with include directives 689s ok 22 - set_conf_value 689s ok 23 - disable_conf_value 689s ok 24 - replace_conf_value 689s ### End test 005_PgCommon.t ### 689s 689s ### PostgreSQL test 006_next_free_port.t ### 689s 1..5 689s ok 1 - next_free_port is 5432 690s ok 2 - next_free_port detects localhost ipv4 socket 691s ok 3 - next_free_port detects wildcard ipv4 socket 692s ok 4 - next_free_port detects localhost ipv6 socket 693s ok 5 - next_free_port detects wildcard ipv6 socket 693s ### End test 006_next_free_port.t ### 693s 693s ### PostgreSQL test 007_pg_conftool.t ### 693s 1..41 693s # test without cluster 694s ok 1 - pg_conftool show all 694s ok 2 - correct output of pg_conftool show all 694s ok 3 - pg_conftool foo.conf show all 694s ok 4 - correct output of pg_conftool foo.conf show all 694s ok 5 - pg_conftool /tmp/OC4k100JjQ/different.conf show all 694s ok 6 - correct output of pg_conftool /tmp/OC4k100JjQ/different.conf show all 694s ok 7 - pg_conftool 9.7 main show all 694s ok 8 - correct output of pg_conftool 9.7 main show all 694s # test show 694s ok 9 - pg_conftool show all 694s ok 10 - correct output of pg_conftool show all 694s ok 11 - pg_conftool other.conf show all 694s ok 12 - correct output of pg_conftool other.conf show all 694s ok 13 - pg_conftool /tmp/OC4k100JjQ/different.conf show all 694s ok 14 - correct output of pg_conftool /tmp/OC4k100JjQ/different.conf show all 694s ok 15 - pg_conftool 16 main show all 694s ok 16 - correct output of pg_conftool 16 main show all 694s ok 17 - pg_conftool 16 main other.conf show all 694s ok 18 - correct output of pg_conftool 16 main other.conf show all 694s ok 19 - pg_conftool show a 694s ok 20 - correct output of pg_conftool show a 694s ok 21 - pg_conftool -s show a 694s ok 22 - correct output of pg_conftool -s show a 694s # test set 694s ok 23 - pg_conftool set c 7 694s ok 24 - correct output of pg_conftool set c 7 694s ok 25 - file contains new setting 694s ok 26 - pg_conftool set a 8 694s ok 27 - correct output of pg_conftool set a 8 694s ok 28 - file contains updated setting 694s ok 29 - pg_conftool /tmp/OC4k100JjQ/different.conf set a 9 694s ok 30 - correct output of pg_conftool /tmp/OC4k100JjQ/different.conf set a 9 694s ok 31 - file with path contains updated setting 694s # test remove 694s ok 32 - pg_conftool remove a 694s ok 33 - correct output of pg_conftool remove a 694s ok 34 - setting removed from file 694s ok 35 - pg_conftool /tmp/OC4k100JjQ/different.conf remove a 694s ok 36 - correct output of pg_conftool /tmp/OC4k100JjQ/different.conf remove a 694s ok 37 - setting removed from file with path 694s # test edit 694s ok 38 - pg_conftool edit 694s ok 39 - correct output of pg_conftool edit 694s ok 40 - pg_conftool /tmp/OC4k100JjQ/different.conf edit 694s ok 41 - correct output of pg_conftool /tmp/OC4k100JjQ/different.conf edit 694s ### End test 007_pg_conftool.t ### 694s 694s ### PostgreSQL test 010_defaultport_cluster.t ### 694s 1..14 694s ok 1 - psql --version 694s ok 2 - pg_wrapper selects highest available version number 694s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 694s ok 4 - connecting to localhost fails with no clusters 694s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 694s ok 6 - pg_wrapper uses host and port from PGCLUSTER 694s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 694s ok 8 - pg_wrapper uses --cluster from the command line 695s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 695s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 695s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 695s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 695s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 695s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 695s ### End test 010_defaultport_cluster.t ### 695s 695s ### PostgreSQL test 015_start_stop.t ### 695s 1..71 695s # We are running systemd 695s # Running tests for 16 695s # Cluster does not exist yet 695s ok 1 - cluster 16 main does not exist 695s ok 2 - service postgresql@16-main does not exist 695s ok 3 - systemctl start postgresql 695s ok 4 - cluster 16 main does not exist 695s ok 5 - service postgresql@16-main does not exist 695s ok 6 - systemctl start postgresql@16-main 695s ok 7 - cluster 16 main does not exist 695s ok 8 - service postgresql@16-main does not exist 695s # Start/stop postgresql using system tools 696s ok 9 - pg_createcluster 16 main 696s ok 10 - cluster 16 main is stopped 696s ok 11 - service postgresql@16-main is stopped 698s ok 12 - systemctl start postgresql 699s ok 13 - cluster 16 main is running 699s ok 14 - service postgresql@16-main is running 699s ok 15 - systemctl start postgresql 699s ok 16 - cluster 16 main is already running 699s ok 17 - service postgresql@16-main is already running 699s ok 18 - systemctl stop postgresql 705s ok 19 - cluster 16 main is stopped 705s ok 20 - service postgresql@16-main is stopped 705s ok 21 - systemctl stop postgresql 705s ok 22 - cluster 16 main is already stopped 705s ok 23 - service postgresql@16-main is already stopped 705s # Start/stop specific cluster using system tools 707s ok 24 - systemctl start postgresql@16-main 707s ok 25 - cluster 16 main is running 707s ok 26 - service postgresql@16-main is running 707s ok 27 - systemctl start postgresql@16-main 707s ok 28 - cluster 16 main is running 707s ok 29 - service postgresql@16-main is running 710s ok 30 - systemctl restart postgresql@16-main 710s ok 31 - cluster 16 main is running 710s ok 32 - service postgresql@16-main is running 710s ok 33 - systemctl stop postgresql@16-main 710s ok 34 - cluster 16 main is stopped 710s ok 35 - service postgresql@16-main is stopped 710s ok 36 - systemctl stop postgresql@16-main 710s ok 37 - cluster 16 main is already stopped 710s ok 38 - service postgresql@16-main is already stopped 712s ok 39 - pg_dropcluster 16 main 712s ok 40 - cluster 16 main does not exist 712s ok 41 - service postgresql@16-main does not exist 712s # Start/stop specific cluster using pg_*cluster 712s ok 42 - pg_ctlcluster start 16 main 712s ok 43 - cluster 16 main does not exist 712s ok 44 - service postgresql@16-main does not exist 716s ok 45 - pg_createcluster 16 main --start 716s ok 46 - cluster 16 main is running 716s ok 47 - service postgresql@16-main is running 716s ok 48 - pg_ctlcluster 16 main start 716s ok 49 - cluster 16 main is already running 716s ok 50 - service postgresql@16-main is already running 718s ok 51 - pg_ctlcluster 16-main restart 718s ok 52 - cluster 16 main is running 718s ok 53 - service postgresql@16-main is running 718s ok 54 - pg_ctlcluster 16 main stop 718s ok 55 - cluster 16 main is stopped 718s ok 56 - service postgresql@16-main is stopped 719s ok 57 - pg_ctlcluster 16 main stop 719s ok 58 - cluster 16 main is already stopped 719s ok 59 - service postgresql@16-main is already stopped 721s ok 60 - pg_ctlcluster start 16-main 721s ok 61 - cluster 16 main is running 721s ok 62 - service postgresql@16-main is running 723s ok 63 - pg_dropcluster 16 main --stop 723s # Cleanup 723s ok 64 - Cleanup: No clusters left behind 723s ok 65 - No postgres processes left behind 723s ok 66 - No files in /etc/postgresql left behind 723s ok 67 - No files in /var/lib/postgresql left behind 723s ok 68 - No files in /var/run/postgresql left behind 723s ok 69 - No files in /var/log/postgresql left behind 723s ok 70 - PostgreSQL TCP ports are closed 723s ok 71 - Next free port is 5432 723s ### End test 015_start_stop.t ### 723s 723s ### PostgreSQL test 020_create_sql_remove.t ### 723s 1..147 723s # Running tests for 16 727s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.7sS7K7 727s ok 2 - pg_createcluster 16 main 727s ok 3 - Socket and pid file are in /var/run/postgresql/ 727s ok 4 - xlog/wal directory /tmp/16.xlog.7sS7K7 was created 727s ok 5 - local method in pg_hba.conf is peer 727s ok 6 - host method in pg_hba.conf is scram-sha-256 727s ok 7 - Exactly one postgres master process running 729s ok 8 - pg_ctlcluster 16 main restart 729s ok 9 - cluster restarts with new environment file 729s ok 10 - Exactly one postgres master process running 729s ok 11 - correct value of PGEXTRAVAR1 in environment 729s ok 12 - correct value of PGEXTRAVAR2 in environment 729s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 729s ok 14 - createdb --version 729s ok 15 - pg_wrapper+createdb selects version number of cluster 729s ok 16 - psql --version 729s ok 17 - pg_wrapper+psql selects version 16 729s ok 18 - pg_lscluster reports online cluster on port 5432 729s ok 19 - log file is actually used 729s ok 20 - /etc/postgresql is owned by user "postgres" 729s ok 21 - version configuration directory file is owned by user "postgres" 729s ok 22 - configuration directory file is owned by user "postgres" 729s ok 23 - version data directory file is owned by user "postgres" 729s ok 24 - data directory file is owned by user "postgres" 729s ok 25 - log file has 0640 permissions 729s ok 26 - log file is owned by user "postgres" 729s ok 27 - log file is owned by group "adm" 729s ok 28 - no log symlink by default 729s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 729s ok 30 - pg_lsclusters -h 729s ok 31 - correct output of pg_lsclusters -h 729s ok 32 - stopping cluster 732s ok 33 - restarting cluster with nondefault log symlink 732s ok 34 - log target is used as log file 732s ok 35 - default log is not used 732s ok 36 - pg_lsclusters -h 732s ok 37 - correct output of pg_lsclusters -h 732s ok 38 - stopping cluster 735s ok 39 - restarting cluster with explicitly configured log file 735s ok 40 - default log is not used 735s ok 41 - log symlink target is used for startup message 735s ok 42 - exactly one log file 735s ok 43 - custom log is actually used 735s ok 44 - pg_lsclusters -h 735s ok 45 - correct output of pg_lsclusters -h 735s ok 46 - stopping cluster 735s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 735s ok 48 - /etc/postgres-hack was not created 737s ok 49 - restarting cluster 737s ok 50 - ps -o tty -U postgres h 737s ok 51 - postgres processes do not have an associated terminal 737s ok 52 - Server is linked with SSL support 737s ok 53 - SSL is enabled in postgresql.conf 737s ok 54 - psql -l fails for nobody 738s ok 55 - createuser nobody 738s ok 56 - createdb nobodydb 738s ok 57 - psql -ltA succeeds for nobody 738s ok 58 - psql -ltA output 738s ok 59 - SQL command: create table 738s ok 60 - SQL command: insert into table values 738s ok 61 - SQL command: insert into table values 738s ok 62 - primary key violation 738s ok 63 - psql -tAc "select * from phone order by name" nobodydb 738s ok 64 - SQL command output: select -tA 738s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 738s ok 66 - SQL command output: select -tx 738s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 738s ok 68 - SQL command output: select -tAx 738s ok 69 - CREATE EXTENSION plperlu fails for user nobody 738s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 738s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 738s ok 72 - creating PL/PerlU function as user nobody fails 738s ok 73 - creating unsafe PL/Perl function as user postgres fails 738s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 738s ok 75 - creating PL/PerlU function as user postgres succeeds 738s ok 76 - psql nobodydb -Atc "select read_file()" 738s ok 77 - calling PL/PerlU function 738s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 738s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 738s ok 80 - creating unsafe PL/Perl function as user nobody fails 738s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 738s ok 82 - creating PL/Perl function as user nobody succeeds 739s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 739s ok 84 - calling PL/Perl function 739s ok 85 # skip No python2 support 739s ok 86 # skip No python2 support 739s ok 87 # skip No python2 support 739s ok 88 # skip No python2 support 739s ok 89 # skip No python2 support 739s ok 90 # skip No python2 support 739s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 739s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 739s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 739s ok 94 - creating PL/Python3 function as user postgres succeeds 739s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 739s ok 96 - calling PL/Python function 739s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 739s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 739s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 739s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 739s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 739s ok 102 - creating PL/Tcl function as user nobody succeeds 739s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 739s ok 104 - creating PL/TclU function as user postgres succeeds 739s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 739s ok 106 - calling PL/Tcl function 739s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 739s ok 108 - calling PL/TclU function 739s ok 109 - stopping cluster 739s ok 110 - pg_ctlcluster 16 main start 739s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 741s ok 112 - pg_ctlcluster 16 main start 741s ok 113 - cluster restarts with pgdata symlink 742s ok 114 - postgres master has OOM killer protection 742s ok 115 - postgres client backend has no OOM adjustment 742s ok 116 - ps h 5913 742s ok 117 - process title is idle 742s ok 118 - ps h 5913 742s ok 119 - process title is idle in transaction 743s ok 120 - stopping cluster 745s ok 121 - starting cluster as postgres works without a log file 745s ok 122 - log file got recreated and used 745s ok 123 - creating a directory in spc2 745s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.w58wK1'" 745s ok 125 - creating tablespace spc1 745s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 745s ok 127 - creating a table in spc1 745s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.lV0zc6'" 745s ok 129 - creating tablespace spc2 745s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 745s ok 131 - creating a table in spc2 745s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 745s ok 133 - Correct apt NeverAutoRemove config 747s ok 134 - pg_dropcluster removes cluster 747s ok 135 - xlog/wal directory /tmp/16.xlog.7sS7K7 was deleted 747s ok 136 - tablespace spc1 was emptied 747s ok 137 - tablespace spc2 was emptied 747s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 747s ok 139 - Correct apt NeverAutoRemove config 747s # Cleanup 747s ok 140 - Cleanup: No clusters left behind 747s ok 141 - No postgres processes left behind 747s ok 142 - No files in /etc/postgresql left behind 747s ok 143 - No files in /var/lib/postgresql left behind 747s ok 144 - No files in /var/run/postgresql left behind 747s ok 145 - No files in /var/log/postgresql left behind 747s ok 146 - PostgreSQL TCP ports are closed 747s ok 147 - Next free port is 5432 747s ### End test 020_create_sql_remove.t ### 747s 747s ### PostgreSQL test 021_pg_renamecluster.t ### 747s 1..20 751s ok 1 - pg_createcluster 16 main 754s ok 2 - pg_renamecluster 16 main donau 754s ok 3 - psql -tAc "show data_directory" 754s ok 4 - cluster is running and data_directory was moved 754s ok 5 - pg_hba.conf location updated 754s ok 6 - pg_ident.conf location updated 754s ok 7 - external_pid_file location updated 754s ok 8 - external_pid_file exists 754s ok 9 # skip no stats_temp_directory in 16 754s ok 10 # skip no stats_temp_directory in 16 754s ok 11 - cluster_name is updated 756s ok 12 - pg_dropcluster removes cluster 756s # Cleanup 756s ok 13 - Cleanup: No clusters left behind 756s ok 14 - No postgres processes left behind 756s ok 15 - No files in /etc/postgresql left behind 756s ok 16 - No files in /var/lib/postgresql left behind 756s ok 17 - No files in /var/run/postgresql left behind 756s ok 18 - No files in /var/log/postgresql left behind 756s ok 19 - PostgreSQL TCP ports are closed 756s ok 20 - Next free port is 5432 756s ### End test 021_pg_renamecluster.t ### 756s 756s ### PostgreSQL test 022_recovery.t ### 756s 1..17 756s # Running tests for 16 760s ok 1 - pg_createcluster 16 main --start >/dev/null 760s ok 2 - pg_ctlcluster 16 main stop -m i 762s ok 3 - pg_ctlcluster 16 main start 762s ok 4 - psql -c '' 762s ok 5 - pg_ctlcluster 16 main stop -m i 762s ok 6 - create write-protected file in data directory 765s ok 7 - pg_ctlcluster 16 main start 765s ok 8 - psql -c '' 767s ok 9 - pg_dropcluster removes cluster 767s # Cleanup 767s ok 10 - Cleanup: No clusters left behind 767s ok 11 - No postgres processes left behind 767s ok 12 - No files in /etc/postgresql left behind 767s ok 13 - No files in /var/lib/postgresql left behind 767s ok 14 - No files in /var/run/postgresql left behind 767s ok 15 - No files in /var/log/postgresql left behind 767s ok 16 - PostgreSQL TCP ports are closed 767s ok 17 - Next free port is 5432 767s ### End test 022_recovery.t ### 767s 767s ### PostgreSQL test 025_logging.t ### 767s 1..55 767s # Logging to /var/log/syslog works 767s # Running tests for 16 771s ok 1 - pg_createcluster 16 main 771s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 771s ok 3 - psql -qc "'foobar_16_6992'" 771s ok 4 - log an error 772s ok 5 - grep --binary-files=text foobar_16_6992 /var/log/postgresql/postgresql-16-main.log 772s ok 6 - error appears in logfile 772s ok 7 - pg_conftool 16 main set log_destination syslog 772s ok 8 - set log_destination syslog 772s ok 9 - pg_ctlcluster 16 main reload 772s ok 10 - 16 main reload 772s ok 11 - psql -Atc "show log_destination" 772s ok 12 - log_destination is syslog 772s ok 13 - pg_lscluster reports syslog 772s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 772s ok 15 - error appears in /var/log/syslog 772s ok 16 - pg_conftool 16 main set logging_collector on 772s ok 17 - set logging_collector on 772s ok 18 - pg_conftool 16 main set log_destination csvlog 772s ok 19 - set log_destination csvlog 775s ok 20 - pg_ctlcluster 16 main restart 775s ok 21 - 16 main restart 775s ok 22 - psql -Atc "show logging_collector" 775s ok 23 - logging_collector is on 775s ok 24 - psql -Atc "show log_destination" 775s ok 25 - log_destination is csvlog 775s ok 26 - pg_lscluster reports csvlog 775s ok 27 - psql -qc "'barbaz_16_6992'" 775s ok 28 - log an error 775s ok 29 - grep --binary-files=text barbaz_16_6992 /var/lib/postgresql/16/main/log/*.csv 775s ok 30 - error appears in log/*.csv 776s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 776s ok 32 - set log_destination stderr,syslog,csvlog 776s ok 33 - pg_ctlcluster 16 main reload 776s ok 34 - 16 main reload 776s ok 35 - psql -Atc "show log_destination" 776s ok 36 - log_destination is stderr,syslog,csvlog 776s ok 37 - pg_lscluster reports stderr,syslog,csvlog 776s ok 38 - psql -qc "'moo_16_6992'" 776s ok 39 - log an error 776s ok 40 - grep --binary-files=text moo_16_6992 /var/lib/postgresql/16/main/log/*.log 776s ok 41 - error appears in log/*.log 777s ok 42 - grep --binary-files=text 'postgres.*moo_16_6992' /var/log/syslog 777s ok 43 - error appears in /var/log/syslog 777s ok 44 - grep --binary-files=text moo_16_6992 /var/lib/postgresql/16/main/log/*.csv 777s ok 45 - error appears in log/*.csv 779s ok 46 - pg_dropcluster 16 main --stop 779s ok 47 - pg_dropcluster removes cluster 779s # Cleanup 779s ok 48 - Cleanup: No clusters left behind 779s ok 49 - No postgres processes left behind 779s ok 50 - No files in /etc/postgresql left behind 779s ok 51 - No files in /var/lib/postgresql left behind 779s ok 52 - No files in /var/run/postgresql left behind 779s ok 53 - No files in /var/log/postgresql left behind 779s ok 54 - PostgreSQL TCP ports are closed 779s ok 55 - Next free port is 5432 779s ### End test 025_logging.t ### 779s 779s ### PostgreSQL test 030_errors.t ### 779s 1..156 779s ok 1 - pg_lscluster reports cluster without binaries 781s ok 2 - pg_dropcluster 6.3 main 782s ok 3 - pg_createcluster --socketdir 782s ok 4 - pg_lsclusters -h 782s ok 5 - cluster was created 782s ok 6 - Port of created cluster is 5432 782s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 782s ok 8 - pg_createcluster on existing cluster 782s ok 9 - pg_lsclusters -h 782s ok 10 - original cluster still exists 782s ok 11 - pg_createcluster 16 test -p foo 782s ok 12 - pg_createcluster -p checks that port option is numeric 782s ok 13 - pg_createcluster 16 test -p 42 782s ok 14 - pg_createcluster -p checks valid port range 782s ok 15 - pg_ctlcluster 16 main start 782s ok 16 - pg_ctlcluster refuses to start root-owned cluster 782s ok 17 - pg_ctlcluster 16 main start 782s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 782s ok 19 - pg_ctlcluster 16 main start 782s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 782s ok 21 - pg_ctlcluster 16 main start 782s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 785s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 785s ok 24 - No sockets in /var/run/postgresql 785s ok 25 - Socket is in /tmp/postgresql-testsuite/ 785s ok 26 - cluster stops with custom unix_socket_dir 785s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 787s ok 28 - cluster starts after removing unix_socket_dir 787s ok 29 - Socket is in default dir /var/run/postgresql 787s ok 30 - No sockets in /tmp/postgresql-testsuite/ 787s ok 31 - pg_ctlcluster 16 main stop 787s ok 32 - pg_ctlcluster fails with corrupted PID file 787s ok 33 - pg_lsclusters -h 787s ok 34 - cluster is still online 787s ok 35 - pg_ctlcluster succeeds with restored PID file 787s ok 36 - pg_lsclusters -h 787s ok 37 - cluster is down 788s ok 38 - pg_ctlcluster 16 main stop 788s ok 39 - pg_ctlcluster stop fails on stopped cluster 790s ok 40 - pg_ctlcluster 16 main start 790s ok 41 - pg_ctlcluster succeeds with already existing PID file 790s ok 42 - pg_lsclusters -h 790s ok 43 - cluster is online 790s ok 44 - pg_ctlcluster stop succeeds 790s ok 45 - pg_lsclusters -h 790s ok 46 - cluster is down 790s ok 47 - no pid file left 790s ok 48 - pg_ctlcluster 16 main stop 790s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 790s ok 50 - pid file was cleaned up 790s ok 51 - pg_ctlcluster --force 16 main stop 790s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 790s ok 53 - pid file was cleaned up 790s ok 54 - pg_ctlcluster 16 main stop 790s ok 55 - pg_ctlcluster stop succeeds with stale PID file 790s ok 56 - pid file was cleaned up 790s ok 57 - pg_ctlcluster --force 16 main stop 790s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 790s ok 59 - pid file was cleaned up 790s ok 60 - pg_ctlcluster --force 16 main stop 790s ok 61 - pg_ctlcluster stop succeeds with empty PID file 790s ok 62 - pid file was cleaned up 792s ok 63 - pg_ctlcluster 16 main start 792s ok 64 - pg_ctlcluster succeeds with corrupted PID file 793s ok 65 - pg_lsclusters -h 793s ok 66 - cluster is online 793s ok 67 - pg_ctlcluster 16 main start 793s ok 68 - pg_ctlcluster start fails on running cluster 793s ok 69 - pg_ctlcluster stop 793s ok 70 - pg_ctlcluster 16 main start 793s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 793s ok 72 - pg_ctlcluster 16 main stop 793s ok 73 - stopping cluster 799s ok 74 - pg_ctlcluster 16 main start 799s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 799s ok 76 - pg_ctlcluster 16 main stop 799s ok 77 - stopping cluster 799s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 799s ok 79 - pg_dropcluster 16 main 799s ok 80 - pg_dropcluster works as user postgres 801s ok 81 - pg_createcluster succeeds 801s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 801s ok 83 - proper error message for nonexisting /var/lib/postgresql 803s ok 84 - pg_ctlcluster 16 main start 803s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 803s ok 86 - pg_ctlcluster 16 main stop 803s ok 87 - stopping cluster 804s ok 88 - pg_createcluster other 807s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 809s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 809s ok 91 809s ok 92 - pg_ctlcluster 16 other start 809s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 809s ok 94 - pg_ctlcluster 16 main stop 809s ok 95 - stopping main cluster 811s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 813s ok 97 - pg_dropcluster other 815s ok 98 - pg_dropcluster 815s ok 99 - No sockets any more 815s ok 100 - 'pg_lsclusters 4.5 foo' fails 815s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 815s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 815s ok 103 - 'psql --cluster 4.5/foo' fails 815s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 815s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 815s ok 106 - 'psql --cluster 16/foo' fails 815s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 815s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 815s ok 109 - 'pg_dropcluster 4.5 foo' fails 815s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 815s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 815s ok 112 - 'pg_dropcluster 16 foo' fails 815s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 815s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 816s ok 115 - 'pg_upgradecluster 4.5 foo' fails 816s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 816s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 816s ok 118 - 'pg_upgradecluster 16 foo' fails 816s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 816s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 816s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 816s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 816s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 816s ok 124 - 'pg_ctlcluster 16 foo stop' fails 816s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 816s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 816s # Cleanup 816s ok 127 - Cleanup: No clusters left behind 816s ok 128 - No postgres processes left behind 816s ok 129 - No files in /etc/postgresql left behind 816s ok 130 - No files in /var/lib/postgresql left behind 816s ok 131 - No files in /var/run/postgresql left behind 816s ok 132 - No files in /var/log/postgresql left behind 816s ok 133 - PostgreSQL TCP ports are closed 816s ok 134 - Next free port is 5432 817s ok 135 - pg_dropcluster 16 broken 817s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 817s # Cleanup 817s ok 137 - Cleanup: No clusters left behind 817s ok 138 - No postgres processes left behind 817s ok 139 - No files in /etc/postgresql left behind 817s ok 140 - No files in /var/lib/postgresql left behind 817s ok 141 - No files in /var/run/postgresql left behind 817s ok 142 - No files in /var/log/postgresql left behind 817s ok 143 - PostgreSQL TCP ports are closed 817s ok 144 - Next free port is 5432 819s ok 145 - pg_dropcluster 16 broken 819s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 819s ok 147 - /etc/postgresql/16 was removed 819s ok 148 - /var/lib/postgresql/16 was removed 819s # Cleanup 819s ok 149 - Cleanup: No clusters left behind 819s ok 150 - No postgres processes left behind 819s ok 151 - No files in /etc/postgresql left behind 819s ok 152 - No files in /var/lib/postgresql left behind 819s ok 153 - No files in /var/run/postgresql left behind 819s ok 154 - No files in /var/log/postgresql left behind 819s ok 155 - PostgreSQL TCP ports are closed 819s ok 156 - Next free port is 5432 819s ### End test 030_errors.t ### 819s 819s ### PostgreSQL test 031_errors_disk_full.t ### 819s 1..22 819s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 821s ok 1 - script failed 821s ok 2 - pg_createcluster fails due to insufficient disk space 821s ok 3 - does not leave files behind 821s # Cleanup 821s ok 4 - Cleanup: No clusters left behind 821s ok 5 - No postgres processes left behind 821s ok 6 - No files in /etc/postgresql left behind 821s ok 7 - No files in /var/lib/postgresql left behind 821s ok 8 - No files in /var/run/postgresql left behind 821s ok 9 - No files in /var/log/postgresql left behind 821s ok 10 - PostgreSQL TCP ports are closed 821s ok 11 - Next free port is 5432 821s # check disk full conditions on startup 825s ok 12 - script failed 825s ok 13 - pg_ctlcluster prints error message 825s ok 14 - log file has error message 825s # Cleanup 825s ok 15 - Cleanup: No clusters left behind 825s ok 16 - No postgres processes left behind 825s ok 17 - No files in /etc/postgresql left behind 825s ok 18 - No files in /var/lib/postgresql left behind 825s ok 19 - No files in /var/run/postgresql left behind 825s ok 20 - No files in /var/log/postgresql left behind 825s ok 21 - PostgreSQL TCP ports are closed 825s ok 22 - Next free port is 5432 825s ### End test 031_errors_disk_full.t ### 825s 825s ### PostgreSQL test 032_ssl_key_permissions.t ### 825s 1..22 825s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 825s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 825s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 825s # 16 (16.2-1) 826s ok 4 - pg_createcluster 16 main 826s ok 5 - pg_ctlcluster 16 main start 826s ok 6 - ssl key owned by nobody refused 826s ok 7 - pg_ctlcluster 16 main start 826s ok 8 - ssl key with permissions root:root 0644 refused 827s ok 9 - pg_ctlcluster 16 main start 827s ok 10 - ssl key with permissions postgres:postgres 0640 refused 829s ok 11 - pg_dropcluster 16 main --stop 829s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 829s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 829s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 829s # Cleanup 829s ok 15 - Cleanup: No clusters left behind 829s ok 16 - No postgres processes left behind 829s ok 17 - No files in /etc/postgresql left behind 829s ok 18 - No files in /var/lib/postgresql left behind 829s ok 19 - No files in /var/run/postgresql left behind 829s ok 20 - No files in /var/log/postgresql left behind 829s ok 21 - PostgreSQL TCP ports are closed 829s ok 22 - Next free port is 5432 829s ### End test 032_ssl_key_permissions.t ### 829s 829s ### PostgreSQL test 040_upgrade.t ### 829s 1..1 829s ok 1 - only one major version installed, skipping upgrade tests 829s ### End test 040_upgrade.t ### 829s 829s ### PostgreSQL test 041_upgrade_custompaths.t ### 829s 1..1 829s ok 1 - only one major version installed, skipping upgrade tests 829s ### End test 041_upgrade_custompaths.t ### 829s 829s ### PostgreSQL test 042_upgrade_rename.t ### 829s 1..15 829s # PostgreSQL 16 833s ok 1 - pg_createcluster 16 main --start 840s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 840s ok 3 - pg_lsclusters -h 840s ok 4 - correct output of pg_lsclusters -h 841s ok 5 - pg_dropcluster 16 main --stop 844s ok 6 - pg_dropcluster 16 upgr --stop 844s ok 7 - Cleaning pg_upgrade log files 844s # Cleanup 844s ok 8 - Cleanup: No clusters left behind 844s ok 9 - No postgres processes left behind 844s ok 10 - No files in /etc/postgresql left behind 844s ok 11 - No files in /var/lib/postgresql left behind 844s ok 12 - No files in /var/run/postgresql left behind 844s ok 13 - No files in /var/log/postgresql left behind 844s ok 14 - PostgreSQL TCP ports are closed 844s ok 15 - Next free port is 5432 844s ### End test 042_upgrade_rename.t ### 844s 844s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 844s 1..1 844s ok 1 - only one major version installed, skipping upgrade tests 844s ### End test 043_upgrade_ssl_cert.t ### 844s 844s ### PostgreSQL test 045_backup.t ### 844s # We are running systemd 844s # PostgreSQL 16 844s # create cluster 847s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 847s ok 2 - pg_lsclusters -h 847s ok 3 - correct output of pg_lsclusters -h 847s ok 4 - pg_conftool 16 main set work_mem 11MB 847s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 847s ok 6 - psql -c 'alter database mydb set search_path=public' 847s ok 7 - psql -c 'create table foo (t text)' mydb 847s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 847s ok 9 - psql -c 'CREATE USER myuser' 848s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 848s ok 11 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 848s ok 12 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 848s # create directory 848s ok 13 - pg_backupcluster 16 main createdirectory 848s ok 14 - /var/backups/postgresql/16-main owned by uid postgres 848s ok 15 - /var/backups/postgresql/16-main owned by gid postgres 848s # dump 848s ok 16 - systemctl start pg_dump@16-main 848s ok 17 - dump created in /var/backups/postgresql/16-main/2024-03-24T200509Z.dump 848s ok 18 - /var/backups/postgresql/16-main/2024-03-24T200509Z.dump owned by uid postgres 848s ok 19 - /var/backups/postgresql/16-main/2024-03-24T200509Z.dump owned by gid postgres 848s # basebackup 849s ok 20 - systemctl start pg_receivewal@16-main 849s ok 21 - psql -c 'create table poke_receivewal (t text)' mydb 849s ok 22 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 1040s ok 23 - systemctl start pg_basebackup@16-main 1040s ok 24 - dump created in /var/backups/postgresql/16-main/2024-03-24T200510Z.backup 1040s ok 25 - /var/backups/postgresql/16-main/2024-03-24T200510Z.backup owned by uid postgres 1040s ok 26 - /var/backups/postgresql/16-main/2024-03-24T200510Z.backup owned by gid postgres 1040s # list 1040s ok 27 - pg_backupcluster 16 main list 1040s ok 28 - correct output of pg_backupcluster 16 main list 1040s # more database changes 1040s ok 29 - psql -c "insert into foo values ('data later deleted')" mydb 1040s ok 30 - psql -c "insert into foo values ('data from archive')" mydb 1040s ok 31 - retrieve recovery timestamp 1040s ok 32 - psql -c "delete from foo where t = 'data later deleted'" mydb 1041s ok 33 - systemctl stop pg_receivewal@16-main 1041s # restore /var/backups/postgresql/16-main/2024-03-24T200509Z.dump 1043s ok 34 - pg_dropcluster 16 main --stop 1048s ok 35 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200509Z.dump --start --datadir /var/lib/postgresql/16/snowflake 1048s ok 36 - pg_lsclusters -h 1048s ok 37 - correct output of pg_lsclusters -h 1048s ok 38 - psql -XAtl 1048s ok 39 - mydb locales 1048s ok 40 - myicudb locales 1048s ok 41 - psql -XAtc 'show work_mem' 1048s ok 42 - correct output of psql -XAtc 'show work_mem' 1048s ok 43 - psql -XAtc 'select * from foo' mydb 1048s ok 44 - correct output of psql -XAtc 'select * from foo' mydb 1048s ok 45 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1048s ok 46 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1048s ok 47 - psql -XAtc '\drds' 1048s ok 48 - correct output of psql -XAtc '\drds' 1048s # restore /var/backups/postgresql/16-main/2024-03-24T200510Z.backup 1050s ok 49 - pg_dropcluster 16 main --stop 1054s ok 50 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200510Z.backup --start --datadir /var/lib/postgresql/16/snowflake 1054s ok 51 - pg_lsclusters -h 1054s ok 52 - correct output of pg_lsclusters -h 1054s ok 53 - psql -XAtl 1054s ok 54 - mydb locales 1054s ok 55 - myicudb locales 1054s ok 56 - psql -XAtc 'show work_mem' 1054s ok 57 - correct output of psql -XAtc 'show work_mem' 1054s ok 58 - psql -XAtc 'select * from foo' mydb 1054s ok 59 - correct output of psql -XAtc 'select * from foo' mydb 1054s ok 60 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1054s ok 61 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1054s ok 62 - psql -XAtc '\drds' 1054s ok 63 - correct output of psql -XAtc '\drds' 1054s # restore /var/backups/postgresql/16-main/2024-03-24T200510Z.backup with WAL archive 1056s ok 64 - pg_dropcluster 16 main --stop 1060s ok 65 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200510Z.backup --start --archive --port 5430 1060s ok 66 - pg_lsclusters -h 1060s ok 67 - correct output of pg_lsclusters -h 1060s ok 68 - psql -XAtc 'select * from foo order by t' mydb 1060s ok 69 - correct output of psql -XAtc 'select * from foo order by t' mydb 1060s # restore /var/backups/postgresql/16-main/2024-03-24T200510Z.backup with PITR 1062s ok 70 - pg_dropcluster 16 main --stop 1066s ok 71 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-03-24T200510Z.backup --start --pitr '2024-03-24 20:08:21.635229+00 1066s # ' 1066s ok 72 - pg_lsclusters -h 1066s ok 73 - correct output of pg_lsclusters -h 1066s ok 74 - psql -XAtc 'select * from foo order by t' mydb 1066s ok 75 - correct output of psql -XAtc 'select * from foo order by t' mydb 1069s ok 76 - pg_dropcluster 16 main --stop 1069s # Cleanup 1069s ok 77 - Cleanup: No clusters left behind 1069s ok 78 - No postgres processes left behind 1069s ok 79 - No files in /etc/postgresql left behind 1069s ok 80 - No files in /var/lib/postgresql left behind 1069s ok 81 - No files in /var/run/postgresql left behind 1069s ok 82 - No files in /var/log/postgresql left behind 1069s ok 83 - PostgreSQL TCP ports are closed 1069s ok 84 - Next free port is 5432 1069s 1..84 1069s ### End test 045_backup.t ### 1069s 1069s ### PostgreSQL test 050_encodings.t ### 1069s 1..60 1069s # Checking 16 ru_RU 1072s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 1073s ok 2 - psql -l succeeds 1073s ok 3 - template1 is not UTF-8 encoded 1073s ok 4 - creating test database 1073s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 1073s # create table t (x varchar); copy t from stdin" test 1073s ok 6 - creating table with ISO-8859-5 characters 1073s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1073s ok 8 - correct string in UTF-8 1074s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1074s ok 10 - correct string in ISO-8859-5 1074s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 1074s # delete from t; copy t from stdin" test 1074s ok 12 - creating table with UTF-8 characters 1074s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1074s ok 14 - correct string in UTF-8 1074s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1074s ok 16 - correct string in ISO-8859-1 1074s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 1074s ok 18 - Server error message has correct language and encoding 1077s ok 19 - pg_ctlcluster 16 ru_RU restart 1077s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 1078s ok 21 - Dropping cluster 1078s # Checking 16 ru_RU.UTF-8 1083s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 1083s ok 23 - psql -l succeeds 1083s ok 24 - template1 is UTF-8 encoded 1083s ok 25 - creating test database 1083s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 1083s # create table t (x varchar); copy t from stdin" test 1083s ok 27 - creating table with ISO-8859-5 characters 1083s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1083s ok 29 - correct string in UTF-8 1083s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1083s ok 31 - correct string in ISO-8859-5 1083s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 1083s # delete from t; copy t from stdin" test 1083s ok 33 - creating table with UTF-8 characters 1083s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1083s ok 35 - correct string in UTF-8 1083s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1083s ok 37 - correct string in ISO-8859-1 1083s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 1083s ok 39 - Server error message has correct language and encoding 1086s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 1086s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 1086s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 1086s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 1086s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 1086s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 1086s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 1086s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 1088s ok 48 - Dropping cluster 1088s # Check 16 locale environment variables 1091s ok 49 - pg_createcluster: LC_ALL dominates LANG 1091s ok 50 - psql -Atl --cluster 16/main 1091s ok 51 - template1 is ASCII encoded 1094s ok 52 - Dropping cluster 1094s # Cleanup 1094s ok 53 - Cleanup: No clusters left behind 1094s ok 54 - No postgres processes left behind 1094s ok 55 - No files in /etc/postgresql left behind 1094s ok 56 - No files in /var/lib/postgresql left behind 1094s ok 57 - No files in /var/run/postgresql left behind 1094s ok 58 - No files in /var/log/postgresql left behind 1094s ok 59 - PostgreSQL TCP ports are closed 1094s ok 60 - Next free port is 5432 1094s ### End test 050_encodings.t ### 1094s 1094s ### PostgreSQL test 052_upgrade_encodings.t ### 1094s 1..1 1094s ok 1 - only one major version installed, skipping upgrade tests 1094s ### End test 052_upgrade_encodings.t ### 1094s 1094s ### PostgreSQL test 060_obsolete_confparams.t ### 1094s ok 1 - only one major version installed, skipping upgrade tests 1094s 1..1 1094s ### End test 060_obsolete_confparams.t ### 1094s 1094s ### PostgreSQL test 070_non_postgres_clusters.t ### 1094s 1..40 1095s ok 1 - pg_createcluster 16 main for owner nobody 1095s ok 2 - pg_ctlcluster 16 main start 1095s ok 3 - start refused when config and data owners mismatch 1097s ok 4 - pg_ctlcluster succeeds with owner nobody 1097s ok 5 - pg_lsclusters -h 1097s ok 6 - pg_lsclusters shows running cluster 1097s ok 7 - postgres is running as user nobody 1097s ok 8 - ls /tmp/.s.PGSQL.* 1097s ok 9 - socket is in /tmp 1097s ok 10 - /var/run/postgresql is empty 1097s ok 11 - conf dir is owned by user 1097s ok 12 - conf dir is owned by user's primary group 1097s ok 13 - files are owned by user 1097s ok 14 - files are owned by user's primary group 1097s ok 15 - log file has 0640 permissions 1097s ok 16 - log file is owned by user 1097s ok 17 - log file is owned by user's primary group 1097s ok 18 - only one major version installed, skipping upgrade test 1097s ok 19 - ... 1097s ok 20 - ... 1097s ok 21 - ... 1097s ok 22 - ... 1097s ok 23 - ... 1097s ok 24 - ... 1097s ok 25 - ... 1097s ok 26 - ... 1097s ok 27 - ... 1097s ok 28 - ... 1100s ok 29 - pg_dropcluster 1100s ok 30 - pg_lsclusters -h 1100s ok 31 - No clusters left 1100s ok 32 - No postgres processes left 1100s # Cleanup 1100s ok 33 - Cleanup: No clusters left behind 1100s ok 34 - No postgres processes left behind 1100s ok 35 - No files in /etc/postgresql left behind 1100s ok 36 - No files in /var/lib/postgresql left behind 1100s ok 37 - No files in /var/run/postgresql left behind 1100s ok 38 - No files in /var/log/postgresql left behind 1100s ok 39 - PostgreSQL TCP ports are closed 1100s ok 40 - Next free port is 5432 1100s ### End test 070_non_postgres_clusters.t ### 1100s 1100s ### PostgreSQL test 080_start.conf.t ### 1100s 1..73 1102s ok 1 - pg_createcluster 16 main 1102s # start.conf auto 1102s ok 2 - get_cluster_start_conf returns auto 1102s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 1102s ok 4 - start.conf contains auto 1102s ok 5 - systemd generator links cluster 1102s ok 6 - systemd generator links correct service file 1103s ok 7 - /etc/init.d/postgresql start 16 1103s ok 8 - correct output of /etc/init.d/postgresql start 16 1103s ok 9 - pg_lsclusters -h 1103s ok 10 - cluster is online 1103s ok 11 - /etc/init.d/postgresql stop 16 1103s ok 12 - correct output of /etc/init.d/postgresql stop 16 1106s ok 13 - pg_lsclusters -h 1106s ok 14 - cluster is down 1106s # start.conf manual 1106s ok 15 - get_cluster_start_conf returns manual 1106s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 1106s ok 17 - start.conf contains manual 1107s ok 18 - systemd generator doesn't link cluster 1107s ok 19 - /etc/init.d/postgresql start 16 1107s ok 20 - correct output of /etc/init.d/postgresql start 16 1107s ok 21 - pg_lsclusters -h 1107s ok 22 - cluster is down 1109s ok 23 - pg_ctlcluster 16 main start 1109s ok 24 - correct output of pg_ctlcluster 16 main start 1109s ok 25 - pg_lsclusters -h 1109s ok 26 - cluster is online 1109s ok 27 - pg_ctlcluster 16 main stop 1109s ok 28 - correct output of pg_ctlcluster 16 main stop 1109s ok 29 - pg_lsclusters -h 1109s ok 30 - cluster is down 1109s # start.conf disabled 1109s ok 31 - get_cluster_start_conf returns disabled 1110s ok 32 - systemd generator doesn't link cluster 1110s ok 33 - /etc/init.d/postgresql start 16 1110s ok 34 - correct output of /etc/init.d/postgresql start 16 1110s ok 35 - pg_lsclusters -h 1110s ok 36 - cluster is down 1110s ok 37 - pg_ctlcluster 16 main start 1110s ok 38 - correct output of pg_ctlcluster 16 main start 1110s ok 39 - pg_lsclusters -h 1110s ok 40 - cluster is down 1112s ok 41 - pg_ctlcluster 16 main start 1112s ok 42 - correct output of pg_ctlcluster 16 main start 1112s ok 43 - pg_lsclusters -h 1112s ok 44 - cluster is online 1112s ok 45 - pg_ctlcluster 16 main stop 1112s ok 46 - correct output of pg_ctlcluster 16 main stop 1112s ok 47 - pg_lsclusters -h 1112s ok 48 - cluster is down 1115s ok 49 - pg_ctlcluster 16 main start 1115s ok 50 - correct output of pg_ctlcluster 16 main start 1115s ok 51 - pg_lsclusters -h 1115s ok 52 - cluster is online 1115s # test upgrade 1115s ok 53 - only one major version installed, skipping upgrade test 1115s ok 54 - ... 1115s ok 55 - get_cluster_start_conf for old cluster returns manual 1115s ok 56 - get_cluster_start_conf for new cluster returns manual 1115s ok 57 - ... 1116s ok 58 - dropping upgraded cluster 1116s ok 59 - pg_lsclusters -h 1116s ok 60 - no clusters any more 1117s ok 61 - pg_createcluster 16 main --start-conf foo 1117s ok 62 - pg_createcluster checks --start-conf validity 1117s ok 63 - pg_createcluster checks --start-conf manual 1117s ok 64 - get_cluster_start_conf returns manual 1119s ok 65 - dropping cluster 1119s # Cleanup 1119s ok 66 - Cleanup: No clusters left behind 1119s ok 67 - No postgres processes left behind 1119s ok 68 - No files in /etc/postgresql left behind 1119s ok 69 - No files in /var/lib/postgresql left behind 1119s ok 70 - No files in /var/run/postgresql left behind 1119s ok 71 - No files in /var/log/postgresql left behind 1119s ok 72 - PostgreSQL TCP ports are closed 1119s ok 73 - Next free port is 5432 1119s ### End test 080_start.conf.t ### 1119s 1119s ### PostgreSQL test 085_pg_ctl.conf.t ### 1119s 1..33 1119s ok 1 - prlimit --core=0:unlimited --pid=14448 1119s ok 2 - set core file size to unlimited 1119s ok 3 - sh -c 'ulimit -Hc' 1119s ok 4 - core file size is unlimited 1120s ok 5 - pg_createcluster 16 main 1120s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 1123s ok 7 - pg_ctlcluster 16 main start 1123s ok 8 - starting cluster as root 1123s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1123s ok 10 - soft core size is 0 1123s # hard core file size limit of root-started postgres process is unlimited 1123s ok 11 - set pg_ctl default option to -c 1125s ok 12 - pg_ctlcluster 16 main restart 1125s ok 13 - restarting cluster as root 1125s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1125s ok 15 - soft core size is unlimited 1125s ok 16 - pg_ctlcluster 16 main stop 1125s ok 17 - stopping cluster 1125s ok 18 - restored pg_ctl default option 1128s ok 19 - pg_ctlcluster 16 main start -- -c 1128s ok 20 - starting cluster with -c on the command line as postgres 1128s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1128s ok 22 - soft core size is unlimited 1128s ok 23 - pg_ctlcluster 16 main stop 1128s ok 24 - stopping cluster 1130s ok 25 - dropping cluster 1130s # Cleanup 1130s ok 26 - Cleanup: No clusters left behind 1130s ok 27 - No postgres processes left behind 1130s ok 28 - No files in /etc/postgresql left behind 1130s ok 29 - No files in /var/lib/postgresql left behind 1130s ok 30 - No files in /var/run/postgresql left behind 1130s ok 31 - No files in /var/log/postgresql left behind 1130s ok 32 - PostgreSQL TCP ports are closed 1130s ok 33 - Next free port is 5432 1130s ### End test 085_pg_ctl.conf.t ### 1130s 1130s ### PostgreSQL test 090_multicluster.t ### 1130s 1..125 1131s ok 1 - pg_createcluster 16 old 1132s ok 2 - pg_createcluster 16 new1 1134s ok 3 - pg_createcluster 16 new2 1136s ok 4 - starting cluster 16/old 1138s ok 5 - starting cluster 16/new1 1140s ok 6 - starting cluster 16/new2 1140s ok 7 - pg_lsclusters -h | sort -k3 1140s ok 8 - clusters have the correct ports, skipping used 5433 1140s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 1140s ok 10 - createdb --version 1140s ok 11 - pg_wrapper selects port 5432 as default cluster 1140s ok 12 - createdb --cluster 16/new1 --version 1140s ok 13 - pg_wrapper --cluster works 1141s ok 14 - createdb --cluster 16/foo --version 1141s ok 15 - pg_wrapper --cluster errors out for invalid cluster 1141s ok 16 - createdb --cluster 16/new1 test 1141s ok 17 - correct output of createdb --cluster 16/new1 test 1141s ok 18 - psql -Atl --cluster 16/new1 1141s ok 19 - test db appears in cluster new1 1141s ok 20 - psql -Atl --cluster 16/new2 1141s ok 21 - test db does not appear in cluster new2 1141s ok 22 - psql -Atl 1141s ok 23 - test db does not appear in default cluster 1141s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 1141s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 1141s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 1141s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 1141s ok 28 - psql -Atl --cluster 16/localhost:5434 1141s ok 29 - test db appears in cluster 16/localhost:5434 1141s ok 30 - psql -Atl --cluster 16/localhost:5440 1141s ok 31 - test db does not appear in cluster 16/localhost:5440 1141s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 1141s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 1141s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 1141s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 1141s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 1141s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 1141s ok 38 - psql -Atl --cluster 6.4/localhost: 1141s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 1141s ok 40 - psql -Atl 1141s ok 41 - PGCLUSTER selection (1) 1141s ok 42 - psql -Atl 1141s ok 43 - PGCLUSTER selection (2) 1141s ok 44 - psql -l 1141s ok 45 - invalid PGCLUSTER value 1141s ok 46 - createdb --version 1141s ok 47 - PGCLUSTER network cluster selection (1) 1141s ok 48 - psql -Atl 1141s ok 49 - PGCLUSTER network cluster selection (2) 1141s ok 50 - psql -Atl 1141s ok 51 - PGCLUSTER network cluster selection (3) 1141s ok 52 - LC_MESSAGES=C psql -Atl 1141s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 1141s ok 54 - psql -Atc "show port" template1 1141s ok 55 - PGPORT selection (1) 1141s ok 56 - psql -Atc "show port" template1 1141s ok 57 - PGPORT selection (2) 1141s ok 58 - createdb --version 1141s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 1142s ok 60 - psql -Atc "show port" template1 1142s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 1142s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 1142s ok 63 - PGDATABASE environment variable works 1142s ok 64 - createdb --version 1142s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 1142s ok 66 - createdb --cluster 16/new1 --version 1142s ok 67 - pg_wrapper --cluster works with empty user_clusters 1142s ok 68 - createdb --version 1142s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 1142s ok 70 - psql -Atc "select current_database()" 1142s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 1142s ok 72 - psql -Atc 'select current_database()' 1142s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 1142s ok 74 - createdb --version 1142s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 1142s ok 76 - createdb --version 1142s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 1142s ok 78 - createdb --version 1142s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 1142s ok 80 - createdb --version 1142s ok 81 - pg_wrapper selects correct version with per-user user_clusters 1142s ok 82 - createdb --version 1142s ok 83 - pg_wrapper selects correct version with per-user user_clusters 1142s ok 84 - createdb --version 1142s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 1142s ok 86 - psql -Atl 1142s ok 87 - $PGHOST overrides user_clusters 1142s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 1142s ok 89 - --cluster overrides $PGHOST 1142s ok 90 - createdb --version 1142s ok 91 - pg_wrapper ignores invalid lines in user_clusters 1142s ok 92 - psql -Atc 'select current_database()' 1142s ok 93 - pg_service conf selection 1 1142s ok 94 - psql -Atc 'select current_database()' 1142s ok 95 - pg_service conf selection 2 1142s ok 96 - psql -Atc 'select current_database()' 1142s ok 97 - pg_service conf selection 3 1143s ok 98 - stopping cluster 16/old 1145s ok 99 - restarting cluster 16/old 1145s ok 100 - pg_lsclusters -h | sort -k3 1145s ok 101 - port of first cluster was successfully changed 1145s ok 102 - psql -l 1145s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 1145s ok 104 - psql -Atl --cluster 16/new1 1145s ok 105 - --cluster selects appropriate cluster 1145s ok 106 - psql -Atl -p 5434 1145s ok 107 - -p selects appropriate cluster 1145s ok 108 - psql -Atlp 5434 1145s ok 109 - -Atlp selects appropriate cluster 1145s ok 110 - psql -Atl --port 5434 1145s ok 111 - --port selects appropriate cluster 1145s ok 112 - env PGPORT=5434 psql -Atl 1145s ok 113 - $PGPORT selects appropriate cluster 1145s ok 114 - Restoring original /etc/postgresql-common/user_clusters 1148s ok 115 - dropping 16/new1 1149s ok 116 - dropping 16/new2 1152s ok 117 - dropping 16/old 1152s # Cleanup 1152s ok 118 - Cleanup: No clusters left behind 1152s ok 119 - No postgres processes left behind 1152s ok 120 - No files in /etc/postgresql left behind 1152s ok 121 - No files in /var/lib/postgresql left behind 1152s ok 122 - No files in /var/run/postgresql left behind 1152s ok 123 - No files in /var/log/postgresql left behind 1152s ok 124 - PostgreSQL TCP ports are closed 1152s ok 125 - Next free port is 5432 1152s ### End test 090_multicluster.t ### 1152s 1152s ### PostgreSQL test 110_integrate_cluster.t ### 1152s 1..32 1153s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/xNlIEGv_P9/c/postgres 1153s ok 2 - creating raw initdb cluster for user postgres 1153s ok 3 - pg_createcluster 16 postgres -d /tmp/xNlIEGv_P9/c/postgres 1153s ok 4 - integrating postgres cluster 1153s ok 5 - pg_lsclusters 1153s ok 6 - correct pg_lsclusters output 1156s ok 7 - pg_ctlcluster 16 postgres start 1156s ok 8 - starting cluster postgres 1156s ok 9 - pg_lsclusters 1156s ok 10 - correct pg_lsclusters output 1157s ok 11 - dropping cluster postgres 1157s ok 12 - No files in temporary cluster dir left behind 1158s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/xNlIEGv_P9/c/nobody 1158s ok 14 - creating raw initdb cluster for user nobody 1159s ok 15 - pg_createcluster 16 nobody -d /tmp/xNlIEGv_P9/c/nobody 1159s ok 16 - integrating nobody cluster 1159s ok 17 - pg_lsclusters 1159s ok 18 - correct pg_lsclusters output 1161s ok 19 - pg_ctlcluster 16 nobody start 1161s ok 20 - starting cluster nobody 1161s ok 21 - pg_lsclusters 1161s ok 22 - correct pg_lsclusters output 1163s ok 23 - dropping cluster nobody 1163s ok 24 - No files in temporary cluster dir left behind 1163s # Cleanup 1163s ok 25 - Cleanup: No clusters left behind 1163s ok 26 - No postgres processes left behind 1163s ok 27 - No files in /etc/postgresql left behind 1163s ok 28 - No files in /var/lib/postgresql left behind 1163s ok 29 - No files in /var/run/postgresql left behind 1163s ok 30 - No files in /var/log/postgresql left behind 1163s ok 31 - PostgreSQL TCP ports are closed 1163s ok 32 - Next free port is 5432 1163s ### End test 110_integrate_cluster.t ### 1163s 1163s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 1163s 1..1 1163s ok 1 - only one major version installed, skipping upgrade tests 1163s ### End test 120_pg_upgradecluster_scripts.t ### 1163s 1163s ### PostgreSQL test 130_nonroot_admin.t ### 1164s 1..22 1167s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 1167s ok 2 - pg_lsclusters -h 1167s ok 3 - correct output of pg_lsclusters -h 1167s ok 4 - psql -Atl 1167s ok 5 - correct output of psql -Atl 1167s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 1167s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 1167s # Cleanup 1167s ok 15 - Cleanup: No clusters left behind 1167s ok 16 - No postgres processes left behind 1167s ok 17 - No files in /etc/postgresql left behind 1167s ok 18 - No files in /var/lib/postgresql left behind 1167s ok 19 - No files in /var/run/postgresql left behind 1167s ok 20 - No files in /var/log/postgresql left behind 1167s ok 21 - PostgreSQL TCP ports are closed 1167s ok 22 - Next free port is 5432 1167s ### End test 130_nonroot_admin.t ### 1167s 1167s ### PostgreSQL test 135_pg_virtualenv.t ### 1167s 1..20 1173s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1173s ok 2 - running pg_virtualenv as root 1176s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1176s ok 4 - running pg_virtualenv as postgres 1179s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1179s ok 6 - running pg_virtualenv as nobody 1183s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1183s ok 8 - running fakeroot pg_virtualenv as root 1186s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1186s ok 10 - running fakeroot pg_virtualenv as postgres 1189s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1189s ok 12 - running fakeroot pg_virtualenv as nobody 1189s # Cleanup 1189s ok 13 - Cleanup: No clusters left behind 1189s ok 14 - No postgres processes left behind 1189s ok 15 - No files in /etc/postgresql left behind 1189s ok 16 - No files in /var/lib/postgresql left behind 1189s ok 17 - No files in /var/run/postgresql left behind 1189s ok 18 - No files in /var/log/postgresql left behind 1190s ok 19 - PostgreSQL TCP ports are closed 1190s ok 20 - Next free port is 5432 1190s ### End test 135_pg_virtualenv.t ### 1190s 1190s ### PostgreSQL test 140_pg_config.t ### 1190s 1..38 1190s # Multiarch is enabled 1190s # checking version specific output for 16 1190s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 1190s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 1190s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 1190s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 1190s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 1190s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 1190s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 1190s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 1190s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1190s # checking pg_config output (should behave like version 16) 1190s ok 15 - pg_config 1190s ok 16 - correct output of pg_config 1190s ok 17 - pg_config --help 1190s ok 18 - correct output of pg_config --help 1190s ok 19 - pg_config --pgxs 1190s ok 20 - correct output of pg_config --pgxs 1190s ok 21 - pg_config --libdir 1190s ok 22 - correct output of pg_config --libdir 1190s ok 23 - pg_config --pkglibdir 1190s ok 24 - correct output of pg_config --pkglibdir 1190s ok 25 - pg_config --bindir 1190s ok 26 - correct output of pg_config --bindir 1190s # checking pg_config.libpq-dev output (should behave like version 16) 1190s ok 27 - pg_config.libpq-dev 1190s ok 28 - correct output of pg_config.libpq-dev 1190s ok 29 - pg_config.libpq-dev --help 1190s ok 30 - correct output of pg_config.libpq-dev --help 1190s ok 31 - pg_config.libpq-dev --pgxs 1190s ok 32 - correct output of pg_config.libpq-dev --pgxs 1190s ok 33 - pg_config.libpq-dev --libdir 1190s ok 34 - correct output of pg_config.libpq-dev --libdir 1190s ok 35 - pg_config.libpq-dev --pkglibdir 1190s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 1190s ok 37 - pg_config.libpq-dev --bindir 1190s ok 38 - correct output of pg_config.libpq-dev --bindir 1190s ### End test 140_pg_config.t ### 1190s 1190s ### PostgreSQL test 150_tsearch_stemming.t ### 1190s 1..37 1190s ok 1 - pg_updatedicts succeeded 1190s ok 2 - pg_updatedicts created en_us.affix 1190s ok 3 - pg_updatedicts created en_us.dict 1190s ok 4 - pg_updatedicts created 16 en_us.affix symlink 1190s ok 5 - pg_updatedicts created 16 en_us.dict symlink 1194s ok 6 - pg_createcluster 16 main 1194s ok 7 - createdb fts 1194s ok 8 - correct output of createdb fts 1194s ok 9 - creating en_US full text search configuration 1194s ok 10 - creating data table and search index 1194s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 1194s ok 12 - stem search of correct word 1194s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 1194s ok 14 - stem search of correct word 1194s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 1194s ok 16 - stem search of unknown word 1194s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 1194s ok 18 - full text search, exact word 1194s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 1194s ok 20 - full text search for word stem 1194s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 1194s ok 22 - full text search for word substring fails 1194s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 1194s ok 24 - full text search, exact unicode word 1194s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 1194s ok 26 - full text search for unicode word stem 1194s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 1194s ok 28 - full text search for unicode word substring fails 1197s ok 29 1197s # Cleanup 1197s ok 30 - Cleanup: No clusters left behind 1197s ok 31 - No postgres processes left behind 1197s ok 32 - No files in /etc/postgresql left behind 1197s ok 33 - No files in /var/lib/postgresql left behind 1197s ok 34 - No files in /var/run/postgresql left behind 1197s ok 35 - No files in /var/log/postgresql left behind 1197s ok 36 - PostgreSQL TCP ports are closed 1197s ok 37 - Next free port is 5432 1197s ### End test 150_tsearch_stemming.t ### 1197s 1197s ### PostgreSQL test 160_alternate_confroot.t ### 1197s 1..28 1200s ok 1 1200s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1200s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1200s ok 4 - pg_lsclusters -h 1200s ok 5 - correct output of pg_lsclusters -h 1200s ok 6 - psql -Atl 1200s ok 7 - correct output of psql -Atl 1200s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 1200s ok 9 - ... 1200s ok 10 - ... 1200s ok 11 - ... 1200s ok 12 - ... 1200s ok 13 - ... 1200s ok 14 - ... 1200s ok 15 - pg_dropcluster 16 test --stop 1200s ok 16 - correct output of pg_dropcluster 16 test --stop 1200s ok 17 - pg_lsclusters -h 1200s ok 18 - correct output of pg_lsclusters -h 1200s ok 19 - No files in root/data left behind 1200s ok 20 - No cruft in root dir left behind 1200s # Cleanup 1200s ok 21 - Cleanup: No clusters left behind 1200s ok 22 - No postgres processes left behind 1200s ok 23 - No files in /etc/postgresql left behind 1200s ok 24 - No files in /var/lib/postgresql left behind 1200s ok 25 - No files in /var/run/postgresql left behind 1200s ok 26 - No files in /var/log/postgresql left behind 1200s ok 27 - PostgreSQL TCP ports are closed 1200s ok 28 - Next free port is 5432 1200s ### End test 160_alternate_confroot.t ### 1200s 1200s ### PostgreSQL test 170_extensions.t ### 1201s # Running tests for 16 1204s ok 1 - pg_createcluster 16 main 1204s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 1204s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 1204s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 1204s ok 5 - extension adminpack installs without error 1204s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 1204s ok 7 - extension adminpack removes without error 1204s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 1204s ok 9 - extension amcheck installs without error 1204s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 1204s ok 11 - extension amcheck removes without error 1204s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 1204s ok 13 - extension autoinc installs without error 1204s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 1204s ok 15 - extension autoinc removes without error 1204s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 1204s ok 17 - extension bloom installs without error 1204s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 1204s ok 19 - extension bloom removes without error 1204s ok 20 - psql -qc 'CREATE EXTENSION plperl' 1204s ok 21 - bool_plperl dependency plperl installs without error 1205s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 1205s ok 23 - extension bool_plperl installs without error 1205s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 1205s ok 25 - extension bool_plperl removes without error 1205s ok 26 - psql -qc 'DROP EXTENSION plperl' 1205s ok 27 - bool_plperl dependency extension plperl removes without error 1205s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 1205s ok 29 - bool_plperlu dependency plperlu installs without error 1205s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 1205s ok 31 - extension bool_plperlu installs without error 1205s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 1205s ok 33 - extension bool_plperlu removes without error 1205s ok 34 - psql -qc 'DROP EXTENSION plperlu' 1205s ok 35 - bool_plperlu dependency extension plperlu removes without error 1205s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 1205s ok 37 - extension btree_gin installs without error 1205s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 1205s ok 39 - extension btree_gin removes without error 1205s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 1205s ok 41 - extension btree_gist installs without error 1205s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 1205s ok 43 - extension btree_gist removes without error 1205s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 1205s ok 45 - extension citext installs without error 1205s ok 46 - psql -qc 'DROP EXTENSION "citext"' 1205s ok 47 - extension citext removes without error 1205s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 1205s ok 49 - extension cube installs without error 1205s ok 50 - psql -qc 'DROP EXTENSION "cube"' 1205s ok 51 - extension cube removes without error 1205s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 1205s ok 53 - extension dblink installs without error 1205s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 1205s ok 55 - extension dblink removes without error 1206s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 1206s ok 57 - extension dict_int installs without error 1206s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 1206s ok 59 - extension dict_int removes without error 1206s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 1206s ok 61 - extension dict_xsyn installs without error 1206s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 1206s ok 63 - extension dict_xsyn removes without error 1206s ok 64 - psql -qc 'CREATE EXTENSION cube' 1206s ok 65 - earthdistance dependency cube installs without error 1206s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 1206s ok 67 - extension earthdistance installs without error 1206s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 1206s ok 69 - extension earthdistance removes without error 1206s ok 70 - psql -qc 'DROP EXTENSION cube' 1206s ok 71 - earthdistance dependency extension cube removes without error 1206s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 1206s ok 73 - extension file_fdw installs without error 1206s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 1206s ok 75 - extension file_fdw removes without error 1206s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 1206s ok 77 - extension fuzzystrmatch installs without error 1206s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 1206s ok 79 - extension fuzzystrmatch removes without error 1206s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 1206s ok 81 - extension hstore installs without error 1206s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 1206s ok 83 - extension hstore removes without error 1206s ok 84 - psql -qc 'CREATE EXTENSION hstore' 1206s ok 85 - hstore_plperl dependency hstore installs without error 1206s ok 86 - psql -qc 'CREATE EXTENSION plperl' 1206s ok 87 - hstore_plperl dependency plperl installs without error 1206s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 1206s ok 89 - extension hstore_plperl installs without error 1206s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 1206s ok 91 - extension hstore_plperl removes without error 1206s ok 92 - psql -qc 'DROP EXTENSION hstore' 1206s ok 93 - hstore_plperl dependency extension hstore removes without error 1206s ok 94 - psql -qc 'DROP EXTENSION plperl' 1206s ok 95 - hstore_plperl dependency extension plperl removes without error 1207s ok 96 - psql -qc 'CREATE EXTENSION hstore' 1207s ok 97 - hstore_plperlu dependency hstore installs without error 1207s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 1207s ok 99 - hstore_plperlu dependency plperlu installs without error 1207s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 1207s ok 101 - extension hstore_plperlu installs without error 1207s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 1207s ok 103 - extension hstore_plperlu removes without error 1207s ok 104 - psql -qc 'DROP EXTENSION hstore' 1207s ok 105 - hstore_plperlu dependency extension hstore removes without error 1207s ok 106 - psql -qc 'DROP EXTENSION plperlu' 1207s ok 107 - hstore_plperlu dependency extension plperlu removes without error 1207s ok 108 - psql -qc 'CREATE EXTENSION hstore' 1207s ok 109 - hstore_plpython3u dependency hstore installs without error 1207s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 1207s ok 111 - hstore_plpython3u dependency plpython3u installs without error 1207s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 1207s ok 113 - extension hstore_plpython3u installs without error 1207s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 1207s ok 115 - extension hstore_plpython3u removes without error 1207s ok 116 - psql -qc 'DROP EXTENSION hstore' 1207s ok 117 - hstore_plpython3u dependency extension hstore removes without error 1207s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 1207s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 1207s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 1207s ok 121 - extension insert_username installs without error 1207s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 1207s ok 123 - extension insert_username removes without error 1207s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 1207s ok 125 - extension intagg installs without error 1207s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 1207s ok 127 - extension intagg removes without error 1207s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 1207s ok 129 - extension intarray installs without error 1207s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 1207s ok 131 - extension intarray removes without error 1207s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 1207s ok 133 - extension isn installs without error 1208s ok 134 - psql -qc 'DROP EXTENSION "isn"' 1208s ok 135 - extension isn removes without error 1208s ok 136 - psql -qc 'CREATE EXTENSION plperl' 1208s ok 137 - jsonb_plperl dependency plperl installs without error 1208s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 1208s ok 139 - extension jsonb_plperl installs without error 1208s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 1208s ok 141 - extension jsonb_plperl removes without error 1208s ok 142 - psql -qc 'DROP EXTENSION plperl' 1208s ok 143 - jsonb_plperl dependency extension plperl removes without error 1208s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 1208s ok 145 - jsonb_plperlu dependency plperlu installs without error 1208s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 1208s ok 147 - extension jsonb_plperlu installs without error 1208s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 1208s ok 149 - extension jsonb_plperlu removes without error 1208s ok 150 - psql -qc 'DROP EXTENSION plperlu' 1208s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 1208s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 1208s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 1208s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 1208s ok 155 - extension jsonb_plpython3u installs without error 1208s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 1208s ok 157 - extension jsonb_plpython3u removes without error 1208s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 1208s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 1208s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 1208s ok 161 - extension lo installs without error 1208s ok 162 - psql -qc 'DROP EXTENSION "lo"' 1208s ok 163 - extension lo removes without error 1208s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 1208s ok 165 - extension ltree installs without error 1208s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 1208s ok 167 - extension ltree removes without error 1208s ok 168 - psql -qc 'CREATE EXTENSION ltree' 1208s ok 169 - ltree_plpython3u dependency ltree installs without error 1208s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 1208s ok 171 - ltree_plpython3u dependency plpython3u installs without error 1209s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 1209s ok 173 - extension ltree_plpython3u installs without error 1209s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 1209s ok 175 - extension ltree_plpython3u removes without error 1209s ok 176 - psql -qc 'DROP EXTENSION ltree' 1209s ok 177 - ltree_plpython3u dependency extension ltree removes without error 1209s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 1209s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 1209s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 1209s ok 181 - extension moddatetime installs without error 1209s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 1209s ok 183 - extension moddatetime removes without error 1209s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 1209s ok 185 - extension old_snapshot installs without error 1209s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 1209s ok 187 - extension old_snapshot removes without error 1209s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 1209s ok 189 - extension pageinspect installs without error 1209s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 1209s ok 191 - extension pageinspect removes without error 1209s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 1209s ok 193 - extension pg_buffercache installs without error 1209s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 1209s ok 195 - extension pg_buffercache removes without error 1209s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 1209s ok 197 - extension pg_freespacemap installs without error 1209s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 1209s ok 199 - extension pg_freespacemap removes without error 1209s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 1209s ok 201 - extension pg_prewarm installs without error 1209s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 1209s ok 203 - extension pg_prewarm removes without error 1209s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 1209s ok 205 - extension pg_stat_statements installs without error 1209s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 1209s ok 207 - extension pg_stat_statements removes without error 1209s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 1209s ok 209 - extension pg_surgery installs without error 1209s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 1209s ok 211 - extension pg_surgery removes without error 1210s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 1210s ok 213 - extension pg_trgm installs without error 1210s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 1210s ok 215 - extension pg_trgm removes without error 1210s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 1210s ok 217 - extension pg_visibility installs without error 1210s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 1210s ok 219 - extension pg_visibility removes without error 1210s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 1210s ok 221 - extension pg_walinspect installs without error 1210s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 1210s ok 223 - extension pg_walinspect removes without error 1210s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 1210s ok 225 - extension pgcrypto installs without error 1210s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 1210s ok 227 - extension pgcrypto removes without error 1210s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 1210s ok 229 - extension pgrowlocks installs without error 1210s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 1210s ok 231 - extension pgrowlocks removes without error 1210s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 1210s ok 233 - extension pgstattuple installs without error 1210s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 1210s ok 235 - extension pgstattuple removes without error 1210s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 1210s ok 237 - extension plperl installs without error 1210s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 1210s ok 239 - extension plperl removes without error 1210s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 1210s ok 241 - extension plperlu installs without error 1210s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 1210s ok 243 - extension plperlu removes without error 1210s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 1210s ok 245 - extension plpython3u installs without error 1210s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 1210s ok 247 - extension plpython3u removes without error 1210s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 1210s ok 249 - extension pltcl installs without error 1211s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 1211s ok 251 - extension pltcl removes without error 1211s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 1211s ok 253 - extension pltclu installs without error 1211s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 1211s ok 255 - extension pltclu removes without error 1211s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 1211s ok 257 - extension postgres_fdw installs without error 1211s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 1211s ok 259 - extension postgres_fdw removes without error 1211s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 1211s ok 261 - extension refint installs without error 1211s ok 262 - psql -qc 'DROP EXTENSION "refint"' 1211s ok 263 - extension refint removes without error 1211s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 1211s ok 265 - extension seg installs without error 1211s ok 266 - psql -qc 'DROP EXTENSION "seg"' 1211s ok 267 - extension seg removes without error 1211s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 1211s ok 269 - extension sslinfo installs without error 1211s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 1211s ok 271 - extension sslinfo removes without error 1211s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 1211s ok 273 - extension tablefunc installs without error 1211s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 1211s ok 275 - extension tablefunc removes without error 1211s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 1211s ok 277 - extension tcn installs without error 1211s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 1211s ok 279 - extension tcn removes without error 1211s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 1211s ok 281 - extension tsm_system_rows installs without error 1211s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 1211s ok 283 - extension tsm_system_rows removes without error 1211s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 1211s ok 285 - extension tsm_system_time installs without error 1211s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 1211s ok 287 - extension tsm_system_time removes without error 1211s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 1211s ok 289 - extension unaccent installs without error 1211s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 1211s ok 291 - extension unaccent removes without error 1212s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 1212s ok 293 - extension uuid-ossp installs without error 1212s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 1212s ok 295 - extension uuid-ossp removes without error 1212s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 1212s ok 297 - extension xml2 installs without error 1212s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 1212s ok 299 - extension xml2 removes without error 1214s ok 300 - pg_dropcluster 16 main 1214s # Cleanup 1214s ok 301 - Cleanup: No clusters left behind 1214s ok 302 - No postgres processes left behind 1214s ok 303 - No files in /etc/postgresql left behind 1214s ok 304 - No files in /var/lib/postgresql left behind 1214s ok 305 - No files in /var/run/postgresql left behind 1214s ok 306 - No files in /var/log/postgresql left behind 1214s ok 307 - PostgreSQL TCP ports are closed 1214s ok 308 - Next free port is 5432 1214s 1..308 1214s ### End test 170_extensions.t ### 1214s 1214s ### PostgreSQL test 180_ecpg.t ### 1214s 1..14 1214s ok 1 - ecpg test.pgc 1214s ok 2 - ecpg processing 1214s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 1214s ok 4 - compiling ecpg output 1222s ok 5 - pg_virtualenv /tmp/tmp.IOqwaScmjF/test 1222s ok 6 - test program runs and gives correct output 1222s # Cleanup 1222s ok 7 - Cleanup: No clusters left behind 1222s ok 8 - No postgres processes left behind 1222s ok 9 - No files in /etc/postgresql left behind 1222s ok 10 - No files in /var/lib/postgresql left behind 1222s ok 11 - No files in /var/run/postgresql left behind 1222s ok 12 - No files in /var/log/postgresql left behind 1222s ok 13 - PostgreSQL TCP ports are closed 1222s ok 14 - Next free port is 5432 1222s ### End test 180_ecpg.t ### 1222s 1222s ### PostgreSQL test 190_pg_buildext.t ### 1222s ok 1 - make clean 1222s ok 2 - make tar 1222s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 1222s # testing 'dh --with pgxs' 1226s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 1226s ok 5 - postgresql-16-foo_123-1_ppc64el.deb was built 1233s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1233s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1233s ok 8 - dpkg -i postgresql-16-foo_123-1_ppc64el.deb 1241s ok 9 - cd foo-123 && pg_buildext installcheck 1241s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 1249s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1249s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1256s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1256s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1256s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 1256s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 1256s ok 17 - dpkg -r postgresql-16-foo 1256s # testing 'dh --with pgxs_loop' 1256s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 1260s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 1260s ok 20 - postgresql-16-foo_123-1_ppc64el.deb was built 1260s ok 21 - make clean 1260s # testing pg_buildext updatecontrol 1260s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 1260s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 1260s 1..23 1260s ### End test 190_pg_buildext.t ### 1260s 1260s ### PostgreSQL test 200_maintscripts.t ### 1260s 1..15 1260s # We are running systemd 1263s ok 1 - pg_createcluster 16 main --start 1263s ok 2 - postmaster PID is 20448 1265s ok 3 - apt-get update -q 1265s # postgresql-common: 1265s # Installed: 257 1265s # Candidate: 257 1265s # Version table: 1265s # *** 257 990 1265s # 990 http://ftpmaster.internal/ubuntu noble/main ppc64el Packages 1265s # 100 /var/lib/dpkg/status 1269s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 1269s # postgresql-common: 1269s # Installed: 257 1269s # Candidate: 257 1269s # Version table: 1269s # *** 257 990 1269s # 990 http://ftpmaster.internal/ubuntu noble/main ppc64el Packages 1269s # 100 /var/lib/dpkg/status 1269s ok 5 - postmaster PID is 20448 1269s ok 6 - postmaster was not restarted 1272s ok 7 - pg_dropcluster 16 main --stop 1272s # Cleanup 1272s ok 8 - Cleanup: No clusters left behind 1272s ok 9 - No postgres processes left behind 1272s ok 10 - No files in /etc/postgresql left behind 1272s ok 11 - No files in /var/lib/postgresql left behind 1272s ok 12 - No files in /var/run/postgresql left behind 1272s ok 13 - No files in /var/log/postgresql left behind 1272s ok 14 - PostgreSQL TCP ports are closed 1272s ok 15 - Next free port is 5432 1272s ### End test 200_maintscripts.t ### 1272s 1273s autopkgtest [20:12:14]: test run-testsuite: -----------------------] 1274s autopkgtest [20:12:14]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 1274s run-testsuite PASS 1274s autopkgtest [20:12:15]: @@@@@@@@@@@@@@@@@@@@ summary 1274s default-psql PASS 1274s run-testsuite PASS 1320s Creating nova instance adt-noble-ppc64el-postgresql-common-20240324-195101-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-ppc64el-server-20240324.img (UUID 456c38b1-f024-4aa9-9fc9-7cea731b220e)... 1320s Creating nova instance adt-noble-ppc64el-postgresql-common-20240324-195101-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-ppc64el-server-20240324.img (UUID 456c38b1-f024-4aa9-9fc9-7cea731b220e)...