0s autopkgtest [13:38:52]: starting date and time: 2025-02-21 13:38:52+0000 0s autopkgtest [13:38:52]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:38:52]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.fwhukgig/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:build-essential --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=build-essential/12.12 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-7.secgroup --name adt-plucky-arm64-postgresql-common-20250221-133852-juju-7f2275-prod-proposed-migration-environment-2-8fb23a12-1287-4864-92ed-5eea7d7d7fb1 --image adt/ubuntu-plucky-arm64-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,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 141s autopkgtest [13:41:13]: testbed dpkg architecture: arm64 142s autopkgtest [13:41:14]: testbed apt version: 2.9.30ubuntu1 142s autopkgtest [13:41:14]: @@@@@@@@@@@@@@@@@@@@ test bed setup 142s autopkgtest [13:41:14]: testbed release detected to be: None 143s autopkgtest [13:41:15]: updating testbed package index (apt update) 144s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 144s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 144s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 144s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 144s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [90.3 kB] 144s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 144s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [719 kB] 144s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.8 kB] 144s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [132 kB] 144s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [7960 B] 144s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [677 kB] 144s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [10.7 kB] 145s Fetched 1765 kB in 1s (1853 kB/s) 146s Reading package lists... 146s Reading package lists... 146s Building dependency tree... 146s Reading state information... 147s Calculating upgrade... 147s Calculating upgrade... 148s The following packages will be upgraded: 148s base-files cloud-init cloud-init-base gcc-14-base motd-news-config 148s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 148s Need to get 752 kB of archives. 148s After this operation, 19.5 kB of additional disk space will be used. 148s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 motd-news-config all 13.6ubuntu1 [5168 B] 148s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 base-files arm64 13.6ubuntu1 [75.6 kB] 148s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-base arm64 14.2.0-17ubuntu3 [53.6 kB] 148s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 cloud-init-base all 25.1-0ubuntu1 [616 kB] 148s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 cloud-init all 25.1-0ubuntu1 [2088 B] 149s Preconfiguring packages ... 149s Fetched 752 kB in 1s (964 kB/s) 150s (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 ... 116668 files and directories currently installed.) 150s Preparing to unpack .../motd-news-config_13.6ubuntu1_all.deb ... 150s Unpacking motd-news-config (13.6ubuntu1) over (13.5ubuntu3) ... 150s Preparing to unpack .../base-files_13.6ubuntu1_arm64.deb ... 150s Unpacking base-files (13.6ubuntu1) over (13.5ubuntu3) ... 150s Setting up base-files (13.6ubuntu1) ... 150s Updating /root/.profile to current default. 151s motd-news.service is a disabled or a static unit not running, not starting it. 151s (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 ... 116668 files and directories currently installed.) 151s Preparing to unpack .../gcc-14-base_14.2.0-17ubuntu3_arm64.deb ... 151s Unpacking gcc-14-base:arm64 (14.2.0-17ubuntu3) over (14.2.0-17ubuntu1) ... 151s Preparing to unpack .../cloud-init-base_25.1-0ubuntu1_all.deb ... 151s /usr/bin/py3clean:101: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 151s for fn in glob1(directory, "%s.*" % fname): 152s Unpacking cloud-init-base (25.1-0ubuntu1) over (25.1~3geb1965a4-0ubuntu1) ... 152s Preparing to unpack .../cloud-init_25.1-0ubuntu1_all.deb ... 152s Unpacking cloud-init (25.1-0ubuntu1) over (25.1~3geb1965a4-0ubuntu1) ... 152s Setting up motd-news-config (13.6ubuntu1) ... 152s Setting up gcc-14-base:arm64 (14.2.0-17ubuntu3) ... 152s Setting up cloud-init-base (25.1-0ubuntu1) ... 153s Setting up cloud-init (25.1-0ubuntu1) ... 153s Processing triggers for man-db (2.13.0-1) ... 154s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-2ubuntu5) ... 154s Processing triggers for install-info (7.1.1-1) ... 154s Processing triggers for rsyslog (8.2412.0-2ubuntu1) ... 154s Processing triggers for initramfs-tools (0.145ubuntu2) ... 155s update-initramfs: Generating /boot/initrd.img-6.12.0-15-generic 155s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 174s System running in EFI mode, skipping. 174s Reading package lists... 175s Building dependency tree... 175s Reading state information... 175s Solving dependencies... 175s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 175s autopkgtest [13:41:47]: upgrading testbed (apt dist-upgrade and autopurge) 176s Reading package lists... 176s Building dependency tree... 176s Reading state information... 177s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 177s Starting 2 pkgProblemResolver with broken count: 0 177s Done 178s Entering ResolveByKeep 178s 178s Calculating upgrade... 178s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 179s Reading package lists... 179s Building dependency tree... 179s Reading state information... 179s Starting pkgProblemResolver with broken count: 0 180s Starting 2 pkgProblemResolver with broken count: 0 180s Done 180s Solving dependencies... 180s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 181s autopkgtest [13:41:53]: rebooting testbed after setup commands that affected boot 205s autopkgtest [13:42:17]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Tue Feb 4 15:49:33 UTC 2025 208s autopkgtest [13:42:20]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 216s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 273 (dsc) [2385 B] 216s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 273 (tar) [216 kB] 216s gpgv: Signature made Fri Feb 14 14:16:57 2025 UTC 216s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 216s gpgv: Can't check signature: No public key 216s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_273.dsc: no acceptable signature found 216s autopkgtest [13:42:28]: testing package postgresql-common version 273 217s autopkgtest [13:42:29]: build not needed 217s autopkgtest [13:42:29]: test default-psql: preparing testbed 217s Reading package lists... 217s Building dependency tree... 217s Reading state information... 218s Starting pkgProblemResolver with broken count: 0 218s Starting 2 pkgProblemResolver with broken count: 0 218s Done 218s The following NEW packages will be installed: 218s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 218s postgresql-17 postgresql-client-17 postgresql-client-common 218s postgresql-common postgresql-common-dev ssl-cert 219s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 219s Need to get 17.6 MB of archives. 219s After this operation, 58.0 MB of additional disk space will be used. 219s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 219s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 273 [47.5 kB] 219s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 219s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 219s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 273 [72.9 kB] 219s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 219s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 273 [101 kB] 219s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.3-3 [142 kB] 219s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 219s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.3-3 [1342 kB] 220s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.3-3 [15.5 MB] 223s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql all 17+273 [14.3 kB] 223s Preconfiguring packages ... 223s /var/cache/debconf/tmp.ci/postgresql.config.Ivs8bS: 12: pg_lsclusters: not found 223s Fetched 17.6 MB in 4s (4292 kB/s) 223s Selecting previously unselected package libjson-perl. 223s (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 ... 116669 files and directories currently installed.) 223s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 223s Unpacking libjson-perl (4.10000-1) ... 223s Selecting previously unselected package postgresql-client-common. 223s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 223s Unpacking postgresql-client-common (273) ... 223s Selecting previously unselected package libio-pty-perl. 223s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 223s Unpacking libio-pty-perl (1:1.20-1build3) ... 223s Selecting previously unselected package libipc-run-perl. 224s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 224s Unpacking libipc-run-perl (20231003.0-2) ... 224s Selecting previously unselected package postgresql-common-dev. 224s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 224s Unpacking postgresql-common-dev (273) ... 224s Selecting previously unselected package ssl-cert. 224s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 224s Unpacking ssl-cert (1.1.3ubuntu1) ... 224s Selecting previously unselected package postgresql-common. 224s Preparing to unpack .../06-postgresql-common_273_all.deb ... 224s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 224s Unpacking postgresql-common (273) ... 224s Selecting previously unselected package libpq5:arm64. 224s Preparing to unpack .../07-libpq5_17.3-3_arm64.deb ... 224s Unpacking libpq5:arm64 (17.3-3) ... 224s Selecting previously unselected package libxslt1.1:arm64. 224s Preparing to unpack .../08-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 224s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 224s Selecting previously unselected package postgresql-client-17. 224s Preparing to unpack .../09-postgresql-client-17_17.3-3_arm64.deb ... 224s Unpacking postgresql-client-17 (17.3-3) ... 224s Selecting previously unselected package postgresql-17. 224s Preparing to unpack .../10-postgresql-17_17.3-3_arm64.deb ... 224s Unpacking postgresql-17 (17.3-3) ... 224s Selecting previously unselected package postgresql. 224s Preparing to unpack .../11-postgresql_17+273_all.deb ... 224s Unpacking postgresql (17+273) ... 224s Setting up postgresql-client-common (273) ... 224s Setting up libio-pty-perl (1:1.20-1build3) ... 224s Setting up libpq5:arm64 (17.3-3) ... 224s Setting up ssl-cert (1.1.3ubuntu1) ... 225s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 225s Setting up libipc-run-perl (20231003.0-2) ... 225s Setting up libjson-perl (4.10000-1) ... 225s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 225s Setting up postgresql-common-dev (273) ... 225s Setting up postgresql-client-17 (17.3-3) ... 226s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 226s Setting up postgresql-common (273) ... 226s Creating config file /etc/postgresql-common/createcluster.conf with new version 226s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 226s Removing obsolete dictionary files: 227s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 227s Setting up postgresql-17 (17.3-3) ... 228s Creating new PostgreSQL cluster 17/main ... 228s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 228s The files belonging to this database system will be owned by user "postgres". 228s This user must also own the server process. 228s 228s The database cluster will be initialized with locale "C.UTF-8". 228s The default database encoding has accordingly been set to "UTF8". 228s The default text search configuration will be set to "english". 228s 228s Data page checksums are disabled. 228s 228s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 228s creating subdirectories ... ok 228s selecting dynamic shared memory implementation ... posix 228s selecting default "max_connections" ... 100 228s selecting default "shared_buffers" ... 128MB 228s selecting default time zone ... Etc/UTC 228s creating configuration files ... ok 229s running bootstrap script ... ok 229s performing post-bootstrap initialization ... ok 229s syncing data to disk ... ok 232s Setting up postgresql (17+273) ... 232s Processing triggers for man-db (2.13.0-1) ... 234s Processing triggers for libc-bin (2.40-4ubuntu1) ... 235s autopkgtest [13:42:47]: test default-psql: [----------------------- 235s autopkgtest [13:42:47]: test default-psql: -----------------------] 236s autopkgtest [13:42:48]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 236s default-psql PASS 236s autopkgtest [13:42:48]: test run-testsuite: preparing testbed 340s autopkgtest [13:44:32]: testbed dpkg architecture: arm64 341s autopkgtest [13:44:33]: testbed apt version: 2.9.30ubuntu1 341s autopkgtest [13:44:33]: @@@@@@@@@@@@@@@@@@@@ test bed setup 341s autopkgtest [13:44:33]: testbed release detected to be: plucky 343s autopkgtest [13:44:35]: updating testbed package index (apt update) 343s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 343s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 343s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 344s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 344s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.8 kB] 344s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [719 kB] 344s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [90.3 kB] 344s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 344s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [132 kB] 344s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [7960 B] 344s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [677 kB] 344s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [10.7 kB] 344s Fetched 1765 kB in 1s (1876 kB/s) 345s Reading package lists... 346s Reading package lists... 347s Building dependency tree... 347s Reading state information... 348s Calculating upgrade... 348s Calculating upgrade... 349s The following packages will be upgraded: 349s base-files cloud-init cloud-init-base gcc-14-base motd-news-config 349s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 349s Need to get 752 kB of archives. 349s After this operation, 19.5 kB of additional disk space will be used. 349s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 motd-news-config all 13.6ubuntu1 [5168 B] 349s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 base-files arm64 13.6ubuntu1 [75.6 kB] 349s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-base arm64 14.2.0-17ubuntu3 [53.6 kB] 349s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 cloud-init-base all 25.1-0ubuntu1 [616 kB] 349s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 cloud-init all 25.1-0ubuntu1 [2088 B] 350s Preconfiguring packages ... 350s Fetched 752 kB in 1s (1266 kB/s) 350s (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 ... 116668 files and directories currently installed.) 350s Preparing to unpack .../motd-news-config_13.6ubuntu1_all.deb ... 350s Unpacking motd-news-config (13.6ubuntu1) over (13.5ubuntu3) ... 351s Preparing to unpack .../base-files_13.6ubuntu1_arm64.deb ... 351s Unpacking base-files (13.6ubuntu1) over (13.5ubuntu3) ... 351s Setting up base-files (13.6ubuntu1) ... 351s Updating /root/.profile to current default. 352s motd-news.service is a disabled or a static unit not running, not starting it. 352s (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 ... 116668 files and directories currently installed.) 352s Preparing to unpack .../gcc-14-base_14.2.0-17ubuntu3_arm64.deb ... 352s Unpacking gcc-14-base:arm64 (14.2.0-17ubuntu3) over (14.2.0-17ubuntu1) ... 352s Preparing to unpack .../cloud-init-base_25.1-0ubuntu1_all.deb ... 352s /usr/bin/py3clean:101: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 352s for fn in glob1(directory, "%s.*" % fname): 353s Unpacking cloud-init-base (25.1-0ubuntu1) over (25.1~3geb1965a4-0ubuntu1) ... 353s Preparing to unpack .../cloud-init_25.1-0ubuntu1_all.deb ... 353s Unpacking cloud-init (25.1-0ubuntu1) over (25.1~3geb1965a4-0ubuntu1) ... 353s Setting up motd-news-config (13.6ubuntu1) ... 353s Setting up gcc-14-base:arm64 (14.2.0-17ubuntu3) ... 353s Setting up cloud-init-base (25.1-0ubuntu1) ... 355s Setting up cloud-init (25.1-0ubuntu1) ... 355s Processing triggers for man-db (2.13.0-1) ... 356s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-2ubuntu5) ... 356s Processing triggers for install-info (7.1.1-1) ... 356s Processing triggers for rsyslog (8.2412.0-2ubuntu1) ... 357s Processing triggers for initramfs-tools (0.145ubuntu2) ... 357s update-initramfs: Generating /boot/initrd.img-6.12.0-15-generic 357s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 384s System running in EFI mode, skipping. 384s Reading package lists... 385s Building dependency tree... 385s Reading state information... 385s Solving dependencies... 386s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 386s autopkgtest [13:45:18]: upgrading testbed (apt dist-upgrade and autopurge) 387s Reading package lists... 387s Building dependency tree... 387s Reading state information... 388s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 389s Starting 2 pkgProblemResolver with broken count: 0 389s Done 390s Entering ResolveByKeep 391s 391s Calculating upgrade... 392s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 392s Reading package lists... 393s Building dependency tree... 393s Reading state information... 393s Starting pkgProblemResolver with broken count: 0 394s Starting 2 pkgProblemResolver with broken count: 0 394s Done 394s Solving dependencies... 395s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 396s autopkgtest [13:45:28]: rebooting testbed after setup commands that affected boot 425s Reading package lists... 425s Building dependency tree... 425s Reading state information... 426s Starting pkgProblemResolver with broken count: 0 426s Starting 2 pkgProblemResolver with broken count: 0 426s Done 427s The following NEW packages will be installed: 427s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 427s cpp-14 cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 427s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 427s fakeroot g++ g++-14 g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 427s gcc-14 gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext hunspell-en-us 427s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-19-dev 427s libclang-cpp19 libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 427s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev 427s libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 libitm1 427s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 427s libpgtypes3 libpq-dev libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool 427s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-19 llvm-19-dev 427s llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all m4 po-debconf 427s postgresql-17 postgresql-all postgresql-client-17 postgresql-client-common 427s postgresql-common postgresql-common-dev postgresql-doc postgresql-doc-17 427s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 427s postgresql-server-dev-17 postgresql-server-dev-all ssl-cert 427s 0 upgraded, 89 newly installed, 0 to remove and 0 not upgraded. 427s Need to get 183 MB of archives. 427s After this operation, 1096 MB of additional disk space will be used. 427s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 428s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 273 [47.5 kB] 428s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 428s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 428s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 273 [72.9 kB] 428s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 428s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 273 [101 kB] 428s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 m4 arm64 1.4.19-5 [244 kB] 428s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 autoconf all 2.72-3ubuntu1 [383 kB] 428s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 autotools-dev all 20220109.1 [44.9 kB] 428s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 automake all 1:1.17-3ubuntu1 [572 kB] 428s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 autopoint all 0.23.1-1 [619 kB] 428s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 428s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 428s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-17ubuntu3 [10.6 MB] 428s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-17ubuntu3 [1028 B] 428s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [5558 B] 428s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.2.0-1ubuntu1 [22.4 kB] 428s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 15-20250213-1ubuntu1 [44.2 kB] 428s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 15-20250213-1ubuntu1 [146 kB] 428s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 15-20250213-1ubuntu1 [28.0 kB] 429s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 15-20250213-1ubuntu1 [2928 kB] 429s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 15-20250213-1ubuntu1 [1319 kB] 429s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 15-20250213-1ubuntu1 [2695 kB] 429s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 15-20250213-1ubuntu1 [1178 kB] 429s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 15-20250213-1ubuntu1 [1642 kB] 429s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-17ubuntu3 [2593 kB] 429s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-17ubuntu3 [20.9 MB] 429s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-17ubuntu3 [526 kB] 429s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [1200 B] 429s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.2.0-1ubuntu1 [4998 B] 429s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-17ubuntu3 [2499 kB] 429s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-17ubuntu3 [12.1 MB] 430s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-17ubuntu3 [21.8 kB] 430s Get:35 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.2.0-1ubuntu1 [956 B] 430s Get:36 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.2.0-1ubuntu1 [1080 B] 430s Get:37 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 build-essential arm64 12.12 [4610 B] 430s Get:38 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp19 arm64 1:19.1.7-1ubuntu1 [13.8 MB] 430s Get:39 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 430s Get:40 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 15-20250213-1ubuntu1 [45.5 kB] 430s Get:41 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-17ubuntu3 [190 kB] 430s Get:42 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-19-dev arm64 1:19.1.7-1ubuntu1 [743 kB] 430s Get:43 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-linker-tools arm64 1:19.1.7-1ubuntu1 [1231 kB] 430s Get:44 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-19 arm64 1:19.1.7-1ubuntu1 [77.2 kB] 430s Get:45 http://ftpmaster.internal/ubuntu plucky/main arm64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 430s Get:46 http://ftpmaster.internal/ubuntu plucky/main arm64 libtool all 2.5.4-3build1 [168 kB] 430s Get:47 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-autoreconf all 20 [16.1 kB] 430s Get:48 http://ftpmaster.internal/ubuntu plucky/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 430s Get:49 http://ftpmaster.internal/ubuntu plucky/main arm64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 430s Get:50 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 430s Get:51 http://ftpmaster.internal/ubuntu plucky/main arm64 debugedit arm64 1:5.1-2 [46.1 kB] 430s Get:52 http://ftpmaster.internal/ubuntu plucky/main arm64 dwz arm64 0.15-1build6 [113 kB] 430s Get:53 http://ftpmaster.internal/ubuntu plucky/main arm64 gettext arm64 0.23.1-1 [998 kB] 430s Get:54 http://ftpmaster.internal/ubuntu plucky/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 430s Get:55 http://ftpmaster.internal/ubuntu plucky/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 430s Get:56 http://ftpmaster.internal/ubuntu plucky/main arm64 debhelper all 13.24.1ubuntu2 [895 kB] 430s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 emacsen-common all 3.0.5 [12.1 kB] 430s Get:58 http://ftpmaster.internal/ubuntu plucky/main arm64 dictionaries-common all 1.30.5 [177 kB] 430s Get:59 http://ftpmaster.internal/ubuntu plucky/main arm64 libfakeroot arm64 1.37-1 [33.6 kB] 430s Get:60 http://ftpmaster.internal/ubuntu plucky/main arm64 fakeroot arm64 1.37-1 [67.3 kB] 430s Get:61 http://ftpmaster.internal/ubuntu plucky/main arm64 hunspell-en-us all 1:2020.12.07-3 [586 kB] 430s Get:62 http://ftpmaster.internal/ubuntu plucky/main arm64 libpgtypes3 arm64 17.3-3 [43.2 kB] 430s Get:63 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.3-3 [142 kB] 430s Get:64 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg6 arm64 17.3-3 [44.0 kB] 430s Get:65 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-compat3 arm64 17.3-3 [12.4 kB] 430s Get:66 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.1-1ubuntu1 [3287 kB] 430s Get:67 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq-dev arm64 17.3-3 [159 kB] 430s Get:68 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-dev arm64 17.3-3 [263 kB] 430s Get:69 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5+20250125-2 [388 kB] 430s Get:70 http://ftpmaster.internal/ubuntu plucky/main arm64 libtcl8.6 arm64 8.6.16+dfsg-1 [987 kB] 430s Get:71 http://ftpmaster.internal/ubuntu plucky/main arm64 libxml2-dev arm64 2.12.7+dfsg+really2.9.14-0.2ubuntu3 [803 kB] 430s Get:72 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 430s Get:73 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-runtime arm64 1:19.1.7-1ubuntu1 [532 kB] 430s Get:74 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 430s Get:75 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19 arm64 1:19.1.7-1ubuntu1 [17.1 MB] 431s Get:76 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.7-1 [59.5 kB] 431s Get:77 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-tools arm64 1:19.1.7-1ubuntu1 [539 kB] 431s Get:78 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-dev arm64 1:19.1.7-1ubuntu1 [45.1 MB] 432s Get:79 http://ftpmaster.internal/ubuntu plucky/universe arm64 locales-all arm64 2.40-4ubuntu1 [11.1 MB] 432s Get:80 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.3-3 [1342 kB] 432s Get:81 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.3-3 [15.5 MB] 433s Get:82 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-17 arm64 17.3-3 [1390 kB] 433s Get:83 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-all all 273 [1632 B] 433s Get:84 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plperl-17 arm64 17.3-3 [64.6 kB] 433s Get:85 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plpython3-17 arm64 17.3-3 [73.6 kB] 433s Get:86 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-pltcl-17 arm64 17.3-3 [29.6 kB] 433s Get:87 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-all all 273 [1708 B] 433s Get:88 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc-17 all 17.3-3 [2131 kB] 433s Get:89 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc all 17+273 [13.2 kB] 433s Preconfiguring packages ... 434s Fetched 183 MB in 6s (33.1 MB/s) 434s Selecting previously unselected package libjson-perl. 434s (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 ... 116669 files and directories currently installed.) 434s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 434s Unpacking libjson-perl (4.10000-1) ... 434s Selecting previously unselected package postgresql-client-common. 434s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 434s Unpacking postgresql-client-common (273) ... 434s Selecting previously unselected package libio-pty-perl. 434s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 434s Unpacking libio-pty-perl (1:1.20-1build3) ... 434s Selecting previously unselected package libipc-run-perl. 434s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 434s Unpacking libipc-run-perl (20231003.0-2) ... 434s Selecting previously unselected package postgresql-common-dev. 434s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 434s Unpacking postgresql-common-dev (273) ... 435s Selecting previously unselected package ssl-cert. 435s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 435s Unpacking ssl-cert (1.1.3ubuntu1) ... 435s Selecting previously unselected package postgresql-common. 435s Preparing to unpack .../06-postgresql-common_273_all.deb ... 435s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 435s Unpacking postgresql-common (273) ... 435s Selecting previously unselected package m4. 435s Preparing to unpack .../07-m4_1.4.19-5_arm64.deb ... 435s Unpacking m4 (1.4.19-5) ... 435s Selecting previously unselected package autoconf. 435s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 435s Unpacking autoconf (2.72-3ubuntu1) ... 435s Selecting previously unselected package autotools-dev. 435s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 435s Unpacking autotools-dev (20220109.1) ... 435s Selecting previously unselected package automake. 435s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 435s Unpacking automake (1:1.17-3ubuntu1) ... 435s Selecting previously unselected package autopoint. 435s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 435s Unpacking autopoint (0.23.1-1) ... 435s Selecting previously unselected package libisl23:arm64. 435s Preparing to unpack .../12-libisl23_0.27-1_arm64.deb ... 435s Unpacking libisl23:arm64 (0.27-1) ... 435s Selecting previously unselected package libmpc3:arm64. 435s Preparing to unpack .../13-libmpc3_1.3.1-1build2_arm64.deb ... 435s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 435s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 435s Preparing to unpack .../14-cpp-14-aarch64-linux-gnu_14.2.0-17ubuntu3_arm64.deb ... 435s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 436s Selecting previously unselected package cpp-14. 436s Preparing to unpack .../15-cpp-14_14.2.0-17ubuntu3_arm64.deb ... 436s Unpacking cpp-14 (14.2.0-17ubuntu3) ... 436s Selecting previously unselected package cpp-aarch64-linux-gnu. 436s Preparing to unpack .../16-cpp-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 436s Unpacking cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 436s Selecting previously unselected package cpp. 436s Preparing to unpack .../17-cpp_4%3a14.2.0-1ubuntu1_arm64.deb ... 436s Unpacking cpp (4:14.2.0-1ubuntu1) ... 436s Selecting previously unselected package libcc1-0:arm64. 436s Preparing to unpack .../18-libcc1-0_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking libcc1-0:arm64 (15-20250213-1ubuntu1) ... 436s Selecting previously unselected package libgomp1:arm64. 436s Preparing to unpack .../19-libgomp1_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking libgomp1:arm64 (15-20250213-1ubuntu1) ... 436s Selecting previously unselected package libitm1:arm64. 436s Preparing to unpack .../20-libitm1_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking libitm1:arm64 (15-20250213-1ubuntu1) ... 436s Selecting previously unselected package libasan8:arm64. 436s Preparing to unpack .../21-libasan8_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking libasan8:arm64 (15-20250213-1ubuntu1) ... 436s Selecting previously unselected package liblsan0:arm64. 436s Preparing to unpack .../22-liblsan0_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking liblsan0:arm64 (15-20250213-1ubuntu1) ... 436s Selecting previously unselected package libtsan2:arm64. 436s Preparing to unpack .../23-libtsan2_15-20250213-1ubuntu1_arm64.deb ... 436s Unpacking libtsan2:arm64 (15-20250213-1ubuntu1) ... 437s Selecting previously unselected package libubsan1:arm64. 437s Preparing to unpack .../24-libubsan1_15-20250213-1ubuntu1_arm64.deb ... 437s Unpacking libubsan1:arm64 (15-20250213-1ubuntu1) ... 437s Selecting previously unselected package libhwasan0:arm64. 437s Preparing to unpack .../25-libhwasan0_15-20250213-1ubuntu1_arm64.deb ... 437s Unpacking libhwasan0:arm64 (15-20250213-1ubuntu1) ... 437s Selecting previously unselected package libgcc-14-dev:arm64. 437s Preparing to unpack .../26-libgcc-14-dev_14.2.0-17ubuntu3_arm64.deb ... 437s Unpacking libgcc-14-dev:arm64 (14.2.0-17ubuntu3) ... 437s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 437s Preparing to unpack .../27-gcc-14-aarch64-linux-gnu_14.2.0-17ubuntu3_arm64.deb ... 437s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 438s Selecting previously unselected package gcc-14. 438s Preparing to unpack .../28-gcc-14_14.2.0-17ubuntu3_arm64.deb ... 438s Unpacking gcc-14 (14.2.0-17ubuntu3) ... 438s Selecting previously unselected package gcc-aarch64-linux-gnu. 438s Preparing to unpack .../29-gcc-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 438s Unpacking gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 438s Selecting previously unselected package gcc. 438s Preparing to unpack .../30-gcc_4%3a14.2.0-1ubuntu1_arm64.deb ... 438s Unpacking gcc (4:14.2.0-1ubuntu1) ... 438s Selecting previously unselected package libstdc++-14-dev:arm64. 438s Preparing to unpack .../31-libstdc++-14-dev_14.2.0-17ubuntu3_arm64.deb ... 438s Unpacking libstdc++-14-dev:arm64 (14.2.0-17ubuntu3) ... 438s Selecting previously unselected package g++-14-aarch64-linux-gnu. 438s Preparing to unpack .../32-g++-14-aarch64-linux-gnu_14.2.0-17ubuntu3_arm64.deb ... 438s Unpacking g++-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 439s Selecting previously unselected package g++-14. 439s Preparing to unpack .../33-g++-14_14.2.0-17ubuntu3_arm64.deb ... 439s Unpacking g++-14 (14.2.0-17ubuntu3) ... 439s Selecting previously unselected package g++-aarch64-linux-gnu. 439s Preparing to unpack .../34-g++-aarch64-linux-gnu_4%3a14.2.0-1ubuntu1_arm64.deb ... 439s Unpacking g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 439s Selecting previously unselected package g++. 439s Preparing to unpack .../35-g++_4%3a14.2.0-1ubuntu1_arm64.deb ... 439s Unpacking g++ (4:14.2.0-1ubuntu1) ... 439s Selecting previously unselected package build-essential. 439s Preparing to unpack .../36-build-essential_12.12_arm64.deb ... 439s Unpacking build-essential (12.12) ... 439s Selecting previously unselected package libclang-cpp19. 439s Preparing to unpack .../37-libclang-cpp19_1%3a19.1.7-1ubuntu1_arm64.deb ... 439s Unpacking libclang-cpp19 (1:19.1.7-1ubuntu1) ... 440s Selecting previously unselected package libgc1:arm64. 440s Preparing to unpack .../38-libgc1_1%3a8.2.8-1_arm64.deb ... 440s Unpacking libgc1:arm64 (1:8.2.8-1) ... 440s Selecting previously unselected package libobjc4:arm64. 440s Preparing to unpack .../39-libobjc4_15-20250213-1ubuntu1_arm64.deb ... 440s Unpacking libobjc4:arm64 (15-20250213-1ubuntu1) ... 440s Selecting previously unselected package libobjc-14-dev:arm64. 440s Preparing to unpack .../40-libobjc-14-dev_14.2.0-17ubuntu3_arm64.deb ... 440s Unpacking libobjc-14-dev:arm64 (14.2.0-17ubuntu3) ... 440s Selecting previously unselected package libclang-common-19-dev:arm64. 440s Preparing to unpack .../41-libclang-common-19-dev_1%3a19.1.7-1ubuntu1_arm64.deb ... 440s Unpacking libclang-common-19-dev:arm64 (1:19.1.7-1ubuntu1) ... 440s Selecting previously unselected package llvm-19-linker-tools. 440s Preparing to unpack .../42-llvm-19-linker-tools_1%3a19.1.7-1ubuntu1_arm64.deb ... 440s Unpacking llvm-19-linker-tools (1:19.1.7-1ubuntu1) ... 440s Selecting previously unselected package clang-19. 440s Preparing to unpack .../43-clang-19_1%3a19.1.7-1ubuntu1_arm64.deb ... 440s Unpacking clang-19 (1:19.1.7-1ubuntu1) ... 440s Selecting previously unselected package libdebhelper-perl. 440s Preparing to unpack .../44-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 440s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 440s Selecting previously unselected package libtool. 440s Preparing to unpack .../45-libtool_2.5.4-3build1_all.deb ... 440s Unpacking libtool (2.5.4-3build1) ... 440s Selecting previously unselected package dh-autoreconf. 441s Preparing to unpack .../46-dh-autoreconf_20_all.deb ... 441s Unpacking dh-autoreconf (20) ... 441s Selecting previously unselected package libarchive-zip-perl. 441s Preparing to unpack .../47-libarchive-zip-perl_1.68-1_all.deb ... 441s Unpacking libarchive-zip-perl (1.68-1) ... 441s Selecting previously unselected package libfile-stripnondeterminism-perl. 441s Preparing to unpack .../48-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 441s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 441s Selecting previously unselected package dh-strip-nondeterminism. 441s Preparing to unpack .../49-dh-strip-nondeterminism_1.14.1-2_all.deb ... 441s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 441s Selecting previously unselected package debugedit. 441s Preparing to unpack .../50-debugedit_1%3a5.1-2_arm64.deb ... 441s Unpacking debugedit (1:5.1-2) ... 441s Selecting previously unselected package dwz. 441s Preparing to unpack .../51-dwz_0.15-1build6_arm64.deb ... 441s Unpacking dwz (0.15-1build6) ... 441s Selecting previously unselected package gettext. 441s Preparing to unpack .../52-gettext_0.23.1-1_arm64.deb ... 441s Unpacking gettext (0.23.1-1) ... 441s Selecting previously unselected package intltool-debian. 441s Preparing to unpack .../53-intltool-debian_0.35.0+20060710.6_all.deb ... 441s Unpacking intltool-debian (0.35.0+20060710.6) ... 441s Selecting previously unselected package po-debconf. 441s Preparing to unpack .../54-po-debconf_1.0.21+nmu1_all.deb ... 441s Unpacking po-debconf (1.0.21+nmu1) ... 441s Selecting previously unselected package debhelper. 441s Preparing to unpack .../55-debhelper_13.24.1ubuntu2_all.deb ... 441s Unpacking debhelper (13.24.1ubuntu2) ... 441s Selecting previously unselected package emacsen-common. 441s Preparing to unpack .../56-emacsen-common_3.0.5_all.deb ... 441s Unpacking emacsen-common (3.0.5) ... 441s Selecting previously unselected package dictionaries-common. 441s Preparing to unpack .../57-dictionaries-common_1.30.5_all.deb ... 441s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 441s Unpacking dictionaries-common (1.30.5) ... 442s Selecting previously unselected package libfakeroot:arm64. 442s Preparing to unpack .../58-libfakeroot_1.37-1_arm64.deb ... 442s Unpacking libfakeroot:arm64 (1.37-1) ... 442s Selecting previously unselected package fakeroot. 442s Preparing to unpack .../59-fakeroot_1.37-1_arm64.deb ... 442s Unpacking fakeroot (1.37-1) ... 442s Selecting previously unselected package hunspell-en-us. 442s Preparing to unpack .../60-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 442s Unpacking hunspell-en-us (1:2020.12.07-3) ... 442s Selecting previously unselected package libpgtypes3:arm64. 442s Preparing to unpack .../61-libpgtypes3_17.3-3_arm64.deb ... 442s Unpacking libpgtypes3:arm64 (17.3-3) ... 442s Selecting previously unselected package libpq5:arm64. 442s Preparing to unpack .../62-libpq5_17.3-3_arm64.deb ... 442s Unpacking libpq5:arm64 (17.3-3) ... 442s Selecting previously unselected package libecpg6:arm64. 442s Preparing to unpack .../63-libecpg6_17.3-3_arm64.deb ... 442s Unpacking libecpg6:arm64 (17.3-3) ... 442s Selecting previously unselected package libecpg-compat3:arm64. 442s Preparing to unpack .../64-libecpg-compat3_17.3-3_arm64.deb ... 442s Unpacking libecpg-compat3:arm64 (17.3-3) ... 442s Selecting previously unselected package libssl-dev:arm64. 442s Preparing to unpack .../65-libssl-dev_3.4.1-1ubuntu1_arm64.deb ... 442s Unpacking libssl-dev:arm64 (3.4.1-1ubuntu1) ... 442s Selecting previously unselected package libpq-dev. 442s Preparing to unpack .../66-libpq-dev_17.3-3_arm64.deb ... 442s Unpacking libpq-dev (17.3-3) ... 442s Selecting previously unselected package libecpg-dev. 442s Preparing to unpack .../67-libecpg-dev_17.3-3_arm64.deb ... 442s Unpacking libecpg-dev (17.3-3) ... 442s Selecting previously unselected package libncurses-dev:arm64. 442s Preparing to unpack .../68-libncurses-dev_6.5+20250125-2_arm64.deb ... 442s Unpacking libncurses-dev:arm64 (6.5+20250125-2) ... 442s Selecting previously unselected package libtcl8.6:arm64. 442s Preparing to unpack .../69-libtcl8.6_8.6.16+dfsg-1_arm64.deb ... 442s Unpacking libtcl8.6:arm64 (8.6.16+dfsg-1) ... 443s Selecting previously unselected package libxml2-dev:arm64. 443s Preparing to unpack .../70-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu3_arm64.deb ... 443s Unpacking libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2ubuntu3) ... 443s Selecting previously unselected package libxslt1.1:arm64. 443s Preparing to unpack .../71-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 443s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 443s Selecting previously unselected package llvm-19-runtime. 443s Preparing to unpack .../72-llvm-19-runtime_1%3a19.1.7-1ubuntu1_arm64.deb ... 443s Unpacking llvm-19-runtime (1:19.1.7-1ubuntu1) ... 443s Selecting previously unselected package libpfm4:arm64. 443s Preparing to unpack .../73-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 443s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 443s Selecting previously unselected package llvm-19. 443s Preparing to unpack .../74-llvm-19_1%3a19.1.7-1ubuntu1_arm64.deb ... 443s Unpacking llvm-19 (1:19.1.7-1ubuntu1) ... 444s Selecting previously unselected package libffi-dev:arm64. 444s Preparing to unpack .../75-libffi-dev_3.4.7-1_arm64.deb ... 444s Unpacking libffi-dev:arm64 (3.4.7-1) ... 444s Selecting previously unselected package llvm-19-tools. 444s Preparing to unpack .../76-llvm-19-tools_1%3a19.1.7-1ubuntu1_arm64.deb ... 444s Unpacking llvm-19-tools (1:19.1.7-1ubuntu1) ... 444s Selecting previously unselected package llvm-19-dev. 444s Preparing to unpack .../77-llvm-19-dev_1%3a19.1.7-1ubuntu1_arm64.deb ... 444s Unpacking llvm-19-dev (1:19.1.7-1ubuntu1) ... 446s Selecting previously unselected package locales-all. 446s Preparing to unpack .../78-locales-all_2.40-4ubuntu1_arm64.deb ... 446s Unpacking locales-all (2.40-4ubuntu1) ... 449s Selecting previously unselected package postgresql-client-17. 449s Preparing to unpack .../79-postgresql-client-17_17.3-3_arm64.deb ... 449s Unpacking postgresql-client-17 (17.3-3) ... 449s Selecting previously unselected package postgresql-17. 449s Preparing to unpack .../80-postgresql-17_17.3-3_arm64.deb ... 449s Unpacking postgresql-17 (17.3-3) ... 450s Selecting previously unselected package postgresql-server-dev-17. 450s Preparing to unpack .../81-postgresql-server-dev-17_17.3-3_arm64.deb ... 450s Unpacking postgresql-server-dev-17 (17.3-3) ... 450s Selecting previously unselected package postgresql-server-dev-all. 450s Preparing to unpack .../82-postgresql-server-dev-all_273_all.deb ... 450s Unpacking postgresql-server-dev-all (273) ... 450s Selecting previously unselected package postgresql-plperl-17. 450s Preparing to unpack .../83-postgresql-plperl-17_17.3-3_arm64.deb ... 450s Unpacking postgresql-plperl-17 (17.3-3) ... 450s Selecting previously unselected package postgresql-plpython3-17. 450s Preparing to unpack .../84-postgresql-plpython3-17_17.3-3_arm64.deb ... 450s Unpacking postgresql-plpython3-17 (17.3-3) ... 450s Selecting previously unselected package postgresql-pltcl-17. 450s Preparing to unpack .../85-postgresql-pltcl-17_17.3-3_arm64.deb ... 450s Unpacking postgresql-pltcl-17 (17.3-3) ... 450s Selecting previously unselected package postgresql-all. 450s Preparing to unpack .../86-postgresql-all_273_all.deb ... 450s Unpacking postgresql-all (273) ... 451s Selecting previously unselected package postgresql-doc-17. 451s Preparing to unpack .../87-postgresql-doc-17_17.3-3_all.deb ... 451s Unpacking postgresql-doc-17 (17.3-3) ... 451s Selecting previously unselected package postgresql-doc. 451s Preparing to unpack .../88-postgresql-doc_17+273_all.deb ... 451s Unpacking postgresql-doc (17+273) ... 451s Setting up postgresql-client-common (273) ... 451s Setting up libpgtypes3:arm64 (17.3-3) ... 451s Setting up libncurses-dev:arm64 (6.5+20250125-2) ... 451s Setting up libio-pty-perl (1:1.20-1build3) ... 451s Setting up libclang-common-19-dev:arm64 (1:19.1.7-1ubuntu1) ... 451s Setting up libarchive-zip-perl (1.68-1) ... 451s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 451s Setting up postgresql-doc-17 (17.3-3) ... 452s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 452s Setting up libpq5:arm64 (17.3-3) ... 452s Setting up m4 (1.4.19-5) ... 452s Setting up libgomp1:arm64 (15-20250213-1ubuntu1) ... 452s Setting up libffi-dev:arm64 (3.4.7-1) ... 452s Setting up locales-all (2.40-4ubuntu1) ... 452s Setting up libfakeroot:arm64 (1.37-1) ... 452s Setting up fakeroot (1.37-1) ... 452s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 452s Setting up autotools-dev (20220109.1) ... 452s Setting up libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2ubuntu3) ... 452s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 452s Setting up emacsen-common (3.0.5) ... 452s Setting up ssl-cert (1.1.3ubuntu1) ... 453s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 453s Setting up libssl-dev:arm64 (3.4.1-1ubuntu1) ... 453s Setting up libmpc3:arm64 (1.3.1-1build2) ... 453s Setting up libtcl8.6:arm64 (8.6.16+dfsg-1) ... 453s Setting up autopoint (0.23.1-1) ... 453s Setting up libipc-run-perl (20231003.0-2) ... 453s Setting up libgc1:arm64 (1:8.2.8-1) ... 453s Setting up autoconf (2.72-3ubuntu1) ... 453s Setting up libubsan1:arm64 (15-20250213-1ubuntu1) ... 453s Setting up dwz (0.15-1build6) ... 453s Setting up libhwasan0:arm64 (15-20250213-1ubuntu1) ... 453s Setting up libasan8:arm64 (15-20250213-1ubuntu1) ... 453s Setting up libjson-perl (4.10000-1) ... 453s Setting up postgresql-doc (17+273) ... 453s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 453s Setting up debugedit (1:5.1-2) ... 453s Setting up libecpg6:arm64 (17.3-3) ... 453s Setting up llvm-19-linker-tools (1:19.1.7-1ubuntu1) ... 453s Setting up libtsan2:arm64 (15-20250213-1ubuntu1) ... 453s Setting up libisl23:arm64 (0.27-1) ... 453s Setting up llvm-19-runtime (1:19.1.7-1ubuntu1) ... 453s Setting up llvm-19-tools (1:19.1.7-1ubuntu1) ... 453s Setting up libcc1-0:arm64 (15-20250213-1ubuntu1) ... 453s Setting up liblsan0:arm64 (15-20250213-1ubuntu1) ... 453s Setting up libitm1:arm64 (15-20250213-1ubuntu1) ... 453s Setting up libclang-cpp19 (1:19.1.7-1ubuntu1) ... 453s Setting up postgresql-common-dev (273) ... 453s Setting up automake (1:1.17-3ubuntu1) ... 453s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 453s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 453s Setting up gettext (0.23.1-1) ... 453s Setting up libecpg-compat3:arm64 (17.3-3) ... 453s Setting up dictionaries-common (1.30.5) ... 454s Setting up postgresql-client-17 (17.3-3) ... 455s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 456s Setting up libpq-dev (17.3-3) ... 456s Setting up libobjc4:arm64 (15-20250213-1ubuntu1) ... 456s Setting up libecpg-dev (17.3-3) ... 456s Setting up intltool-debian (0.35.0+20060710.6) ... 456s Setting up postgresql-common (273) ... 456s Creating config file /etc/postgresql-common/createcluster.conf with new version 457s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 457s en_us 457s Removing obsolete dictionary files: 458s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 459s Setting up dh-strip-nondeterminism (1.14.1-2) ... 459s Setting up cpp-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 459s Setting up hunspell-en-us (1:2020.12.07-3) ... 459s Setting up llvm-19 (1:19.1.7-1ubuntu1) ... 459s Setting up libgcc-14-dev:arm64 (14.2.0-17ubuntu3) ... 459s Setting up libstdc++-14-dev:arm64 (14.2.0-17ubuntu3) ... 459s Setting up postgresql-17 (17.3-3) ... 461s Creating new PostgreSQL cluster 17/main ... 461s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 461s The files belonging to this database system will be owned by user "postgres". 461s This user must also own the server process. 461s 461s The database cluster will be initialized with locale "C.UTF-8". 461s The default database encoding has accordingly been set to "UTF8". 461s The default text search configuration will be set to "english". 461s 461s Data page checksums are disabled. 461s 461s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 461s creating subdirectories ... ok 461s selecting dynamic shared memory implementation ... posix 461s selecting default "max_connections" ... 100 461s selecting default "shared_buffers" ... 128MB 461s selecting default time zone ... Etc/UTC 461s creating configuration files ... ok 461s running bootstrap script ... ok 462s performing post-bootstrap initialization ... ok 462s syncing data to disk ... ok 465s Setting up po-debconf (1.0.21+nmu1) ... 465s Setting up libobjc-14-dev:arm64 (14.2.0-17ubuntu3) ... 465s Setting up clang-19 (1:19.1.7-1ubuntu1) ... 465s Setting up cpp-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 465s Setting up llvm-19-dev (1:19.1.7-1ubuntu1) ... 465s Setting up cpp-14 (14.2.0-17ubuntu3) ... 465s Setting up postgresql-plpython3-17 (17.3-3) ... 465s Setting up postgresql-plperl-17 (17.3-3) ... 465s Setting up cpp (4:14.2.0-1ubuntu1) ... 465s Setting up gcc-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 465s Setting up gcc-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 465s Setting up postgresql-pltcl-17 (17.3-3) ... 465s Setting up g++-14-aarch64-linux-gnu (14.2.0-17ubuntu3) ... 465s Setting up libtool (2.5.4-3build1) ... 465s Setting up gcc-14 (14.2.0-17ubuntu3) ... 465s Setting up dh-autoreconf (20) ... 465s Setting up postgresql-server-dev-17 (17.3-3) ... 465s Setting up g++-aarch64-linux-gnu (4:14.2.0-1ubuntu1) ... 465s Setting up g++-14 (14.2.0-17ubuntu3) ... 465s Setting up postgresql-server-dev-all (273) ... 465s Setting up debhelper (13.24.1ubuntu2) ... 465s Setting up postgresql-all (273) ... 465s Setting up gcc (4:14.2.0-1ubuntu1) ... 465s Setting up g++ (4:14.2.0-1ubuntu1) ... 465s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 465s Setting up build-essential (12.12) ... 465s Processing triggers for libc-bin (2.40-4ubuntu1) ... 465s Processing triggers for systemd (257.2-3ubuntu1) ... 465s Processing triggers for man-db (2.13.0-1) ... 468s Processing triggers for install-info (7.1.1-1) ... 468s Processing triggers for dictionaries-common (1.30.5) ... 471s autopkgtest [13:46:43]: test run-testsuite: [----------------------- 472s ====== Running all tests with umask 077 ======= 472s ### PostgreSQL test 001_packages.t ### 473s 1..22 473s ok 1 - /etc/os-release exists 473s ok 2 - OS is ubuntu 473s ok 3 - OS version is 25.04 473s # PostgreSQL versions installed: 17 473s ok 4 - postgresql-17 installed 473s ok 5 - postgresql-plpython3-17 installed 473s ok 6 - postgresql-plperl-17 installed 473s ok 7 - postgresql-pltcl-17 installed 473s ok 8 - postgresql-server-dev-17 installed 473s ok 9 # skip No postgresql-contrib-17 package for version 17 473s # postgresql-doc-17 installed 473s ok 10 - At least one doc package installed 473s ok 11 - libecpg-dev installed 473s ok 12 - postgresql-common-dev installed 473s ok 13 - procps installed 473s ok 14 - netcat-openbsd installed 473s ok 15 - hunspell-en-us installed 473s ok 16 - system has a default UTF-8 locale 473s ok 17 - locale ru_RU exists 473s ok 18 - locale ru_RU.UTF-8 exists 473s ok 19 - user postgres in the UNIX group ssl-cert 473s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 473s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 473s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 473s ### End test 001_packages.t ### 473s 473s ### PostgreSQL test 002_existing_clusters.t ### 473s 1..8 473s # Cleanup 473s ok 1 - Cleanup: No clusters left behind 473s ok 2 - No postgres processes left behind 473s ok 3 - No files in /etc/postgresql left behind 473s ok 4 - No files in /var/lib/postgresql left behind 473s ok 5 - No files in /var/run/postgresql left behind 473s ok 6 - No files in /var/log/postgresql left behind 473s ok 7 - PostgreSQL TCP ports are closed 473s ok 8 - Next free port is 5432 473s ### End test 002_existing_clusters.t ### 473s 473s ### PostgreSQL test 003_alternatives.t ### 473s 1..9 473s # Newest PG version installed is 17 473s ok 1 - psql.1.gz link group 473s ok 2 - postmaster.1.gz link group does not exist 473s ok 3 - psql.1.gz alternative 473s ok 4 - pg_dump.1.gz alternative 473s ok 5 - postgres.1.gz alternative 473s ok 6 - pg_ctl.1.gz alternative 473s # Newest PG doc version installed is 17 473s ok 7 - SPI_connect.3.gz link group 473s ok 8 - SPI_connect.3.gz alternative 473s ok 9 - SPI_exec.3.gz alternative 473s ### End test 003_alternatives.t ### 473s 473s ### PostgreSQL test 005_PgCommon.t ### 473s 1..24 473s ok 1 - correctly parsed line 'local all postgres ident sameuser' 473s ok 2 - correctly parsed line 'local foo nobody trust' 473s ok 3 - correctly parsed line 'local foo nobody crypt' 473s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 473s ok 5 - correctly parsed line 'local foo,bar nobody ident' 473s ok 6 - correctly parsed line 'local all +foogrp password' 473s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 473s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 473s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 473s ok 10 - @expected_records has correct number of entries 473s ok 11 - returned read_pg_hba array has correct number of records 473s ok 12 - line 'foo all all md5' parsed as invalid 473s ok 13 - line 'local all all foo' parsed as invalid 473s ok 14 - line 'host all all foo' parsed as invalid 473s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 473s ok 16 - line 'host all all md5' parsed as invalid 473s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 473s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 473s ok 19 - read_conf_file returns empty dict for nonexisting file 473s ok 20 - read_conf_file() parsing 473s ok 21 - read_conf_file() parsing with include directives 473s ok 22 - set_conf_value 473s ok 23 - disable_conf_value 473s ok 24 - replace_conf_value 473s ### End test 005_PgCommon.t ### 473s 473s ### PostgreSQL test 006_next_free_port.t ### 473s 1..5 473s ok 1 - next_free_port is 5432 474s ok 2 - next_free_port detects localhost ipv4 socket 475s ok 3 - next_free_port detects wildcard ipv4 socket 476s ok 4 - next_free_port detects localhost ipv6 socket 477s ok 5 - next_free_port detects wildcard ipv6 socket 477s ### End test 006_next_free_port.t ### 477s 477s ### PostgreSQL test 007_pg_conftool.t ### 477s 1..41 477s # test without cluster 477s ok 1 - pg_conftool show all 477s ok 2 - correct output of pg_conftool show all 477s ok 3 - pg_conftool foo.conf show all 477s ok 4 - correct output of pg_conftool foo.conf show all 477s ok 5 - pg_conftool /tmp/bt7ROPrvOa/different.conf show all 477s ok 6 - correct output of pg_conftool /tmp/bt7ROPrvOa/different.conf show all 478s ok 7 - pg_conftool 9.7 main show all 478s ok 8 - correct output of pg_conftool 9.7 main show all 478s # test show 478s ok 9 - pg_conftool show all 478s ok 10 - correct output of pg_conftool show all 478s ok 11 - pg_conftool other.conf show all 478s ok 12 - correct output of pg_conftool other.conf show all 478s ok 13 - pg_conftool /tmp/bt7ROPrvOa/different.conf show all 478s ok 14 - correct output of pg_conftool /tmp/bt7ROPrvOa/different.conf show all 478s ok 15 - pg_conftool 17 main show all 478s ok 16 - correct output of pg_conftool 17 main show all 478s ok 17 - pg_conftool 17 main other.conf show all 478s ok 18 - correct output of pg_conftool 17 main other.conf show all 478s ok 19 - pg_conftool show a 478s ok 20 - correct output of pg_conftool show a 478s ok 21 - pg_conftool -s show a 478s ok 22 - correct output of pg_conftool -s show a 478s # test set 478s ok 23 - pg_conftool set c 7 478s ok 24 - correct output of pg_conftool set c 7 478s ok 25 - file contains new setting 478s ok 26 - pg_conftool set a 8 478s ok 27 - correct output of pg_conftool set a 8 478s ok 28 - file contains updated setting 478s ok 29 - pg_conftool /tmp/bt7ROPrvOa/different.conf set a 9 478s ok 30 - correct output of pg_conftool /tmp/bt7ROPrvOa/different.conf set a 9 478s ok 31 - file with path contains updated setting 478s # test remove 478s ok 32 - pg_conftool remove a 478s ok 33 - correct output of pg_conftool remove a 478s ok 34 - setting removed from file 478s ok 35 - pg_conftool /tmp/bt7ROPrvOa/different.conf remove a 478s ok 36 - correct output of pg_conftool /tmp/bt7ROPrvOa/different.conf remove a 478s ok 37 - setting removed from file with path 478s # test edit 478s ok 38 - pg_conftool edit 478s ok 39 - correct output of pg_conftool edit 478s ok 40 - pg_conftool /tmp/bt7ROPrvOa/different.conf edit 478s ok 41 - correct output of pg_conftool /tmp/bt7ROPrvOa/different.conf edit 478s ### End test 007_pg_conftool.t ### 478s 478s ### PostgreSQL test 010_defaultport_cluster.t ### 478s 1..14 478s ok 1 - psql --version 478s ok 2 - pg_wrapper selects highest available version number 478s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 478s ok 4 - connecting to localhost fails with no clusters 479s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 479s ok 6 - pg_wrapper uses host and port from PGCLUSTER 479s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 479s ok 8 - pg_wrapper uses --cluster from the command line 479s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 479s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 479s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 479s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 479s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 479s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 479s ### End test 010_defaultport_cluster.t ### 479s 479s ### PostgreSQL test 015_start_stop.t ### 479s 1..71 479s # We are running systemd 479s # Running tests for 17 479s # Cluster does not exist yet 479s ok 1 - cluster 17 main does not exist 479s ok 2 - service postgresql@17-main does not exist 479s ok 3 - systemctl start postgresql 479s ok 4 - cluster 17 main does not exist 479s ok 5 - service postgresql@17-main does not exist 479s ok 6 - systemctl start postgresql@17-main 479s ok 7 - cluster 17 main does not exist 479s ok 8 - service postgresql@17-main does not exist 479s # Start/stop postgresql using system tools 480s ok 9 - pg_createcluster 17 main 480s ok 10 - cluster 17 main is stopped 480s ok 11 - service postgresql@17-main is stopped 482s ok 12 - systemctl start postgresql 482s ok 13 - cluster 17 main is running 482s ok 14 - service postgresql@17-main is running 482s ok 15 - systemctl start postgresql 483s ok 16 - cluster 17 main is already running 483s ok 17 - service postgresql@17-main is already running 483s ok 18 - systemctl stop postgresql 489s ok 19 - cluster 17 main is stopped 489s ok 20 - service postgresql@17-main is stopped 489s ok 21 - systemctl stop postgresql 489s ok 22 - cluster 17 main is already stopped 489s ok 23 - service postgresql@17-main is already stopped 489s # Start/stop specific cluster using system tools 491s ok 24 - systemctl start postgresql@17-main 491s ok 25 - cluster 17 main is running 491s ok 26 - service postgresql@17-main is running 491s ok 27 - systemctl start postgresql@17-main 491s ok 28 - cluster 17 main is running 491s ok 29 - service postgresql@17-main is running 494s ok 30 - systemctl restart postgresql@17-main 494s ok 31 - cluster 17 main is running 494s ok 32 - service postgresql@17-main is running 494s ok 33 - systemctl stop postgresql@17-main 494s ok 34 - cluster 17 main is stopped 494s ok 35 - service postgresql@17-main is stopped 494s ok 36 - systemctl stop postgresql@17-main 494s ok 37 - cluster 17 main is already stopped 494s ok 38 - service postgresql@17-main is already stopped 496s ok 39 - pg_dropcluster 17 main 496s ok 40 - cluster 17 main does not exist 496s ok 41 - service postgresql@17-main does not exist 496s # Start/stop specific cluster using pg_*cluster 496s ok 42 - pg_ctlcluster start 17 main 496s ok 43 - cluster 17 main does not exist 496s ok 44 - service postgresql@17-main does not exist 499s ok 45 - pg_createcluster 17 main --start 499s ok 46 - cluster 17 main is running 499s ok 47 - service postgresql@17-main is running 499s ok 48 - pg_ctlcluster 17 main start 500s ok 49 - cluster 17 main is already running 500s ok 50 - service postgresql@17-main is already running 502s ok 51 - pg_ctlcluster 17-main restart 502s ok 52 - cluster 17 main is running 502s ok 53 - service postgresql@17-main is running 502s ok 54 - pg_ctlcluster 17 main stop 502s ok 55 - cluster 17 main is stopped 502s ok 56 - service postgresql@17-main is stopped 502s ok 57 - pg_ctlcluster 17 main stop 502s ok 58 - cluster 17 main is already stopped 502s ok 59 - service postgresql@17-main is already stopped 505s ok 60 - pg_ctlcluster start 17-main 505s ok 61 - cluster 17 main is running 505s ok 62 - service postgresql@17-main is running 507s ok 63 - pg_dropcluster 17 main --stop 507s # Cleanup 507s ok 64 - Cleanup: No clusters left behind 507s ok 65 - No postgres processes left behind 507s ok 66 - No files in /etc/postgresql left behind 507s ok 67 - No files in /var/lib/postgresql left behind 507s ok 68 - No files in /var/run/postgresql left behind 507s ok 69 - No files in /var/log/postgresql left behind 507s ok 70 - PostgreSQL TCP ports are closed 507s ok 71 - Next free port is 5432 507s ### End test 015_start_stop.t ### 507s 507s ### PostgreSQL test 020_create_sql_remove.t ### 507s 1..141 507s # Running tests for 17 510s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.TPFA9t 510s ok 2 - pg_createcluster 17 main 510s ok 3 - Socket and pid file are in /var/run/postgresql/ 510s ok 4 - xlog/wal directory /tmp/17.xlog.TPFA9t was created 510s ok 5 - local method in pg_hba.conf is peer 510s ok 6 - host method in pg_hba.conf is scram-sha-256 510s ok 7 - Exactly one postgres master process running 513s ok 8 - pg_ctlcluster 17 main restart 513s ok 9 - cluster restarts with new environment file 513s ok 10 - Exactly one postgres master process running 513s ok 11 - correct value of PGEXTRAVAR1 in environment 513s ok 12 - correct value of PGEXTRAVAR2 in environment 513s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 513s ok 14 - createdb --version 513s ok 15 - pg_wrapper+createdb selects version number of cluster 513s ok 16 - psql --version 513s ok 17 - pg_wrapper+psql selects version 17 513s ok 18 - pg_lscluster reports online cluster on port 5432 513s ok 19 - log file is actually used 513s ok 20 - /etc/postgresql is owned by user "postgres" 513s ok 21 - version configuration directory file is owned by user "postgres" 513s ok 22 - configuration directory file is owned by user "postgres" 513s ok 23 - version data directory file is owned by user "postgres" 513s ok 24 - data directory file is owned by user "postgres" 513s ok 25 - log file has 0640 permissions 513s ok 26 - log file is owned by user "postgres" 513s ok 27 - log file is owned by group "adm" 513s ok 28 - no log symlink by default 513s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 513s ok 30 - pg_lsclusters -h 513s ok 31 - correct output of pg_lsclusters -h 513s ok 32 - stopping cluster 516s ok 33 - restarting cluster with nondefault log symlink 516s ok 34 - log target is used as log file 516s ok 35 - default log is not used 516s ok 36 - pg_lsclusters -h 516s ok 37 - correct output of pg_lsclusters -h 516s ok 38 - stopping cluster 519s ok 39 - restarting cluster with explicitly configured log file 519s ok 40 - default log is not used 519s ok 41 - log symlink target is used for startup message 519s ok 42 - exactly one log file 519s ok 43 - custom log is actually used 519s ok 44 - pg_lsclusters -h 519s ok 45 - correct output of pg_lsclusters -h 519s ok 46 - stopping cluster 519s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 519s ok 48 - /etc/postgres-hack was not created 521s ok 49 - restarting cluster 521s ok 50 - ps -o tty -U postgres h 521s ok 51 - postgres processes do not have an associated terminal 521s ok 52 - Server is linked with SSL support 521s ok 53 - SSL is enabled in postgresql.conf 521s ok 54 - psql -l fails for nobody 521s ok 55 - createuser nobody 522s ok 56 - createdb nobodydb 522s ok 57 - psql -ltA succeeds for nobody 522s ok 58 - psql -ltA output 522s ok 59 - SQL command: create table 522s ok 60 - SQL command: insert into table values 522s ok 61 - SQL command: insert into table values 522s ok 62 - primary key violation 522s ok 63 - psql -tAc "select * from phone order by name" nobodydb 522s ok 64 - SQL command output: select -tA 522s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 522s ok 66 - SQL command output: select -tx 522s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 522s ok 68 - SQL command output: select -tAx 522s ok 69 - CREATE EXTENSION plperlu fails for user nobody 522s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 522s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 522s ok 72 - creating PL/PerlU function as user nobody fails 522s ok 73 - creating unsafe PL/Perl function as user postgres fails 522s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 522s ok 75 - creating PL/PerlU function as user postgres succeeds 522s ok 76 - psql nobodydb -Atc "select read_file()" 522s ok 77 - calling PL/PerlU function 522s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 522s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 523s ok 80 - creating unsafe PL/Perl function as user nobody fails 523s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 523s ok 82 - creating PL/Perl function as user nobody succeeds 523s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 523s ok 84 - calling PL/Perl function 523s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 523s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 523s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 523s ok 88 - creating PL/Python3 function as user postgres succeeds 523s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 523s ok 90 - calling PL/Python function 523s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 523s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 523s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 523s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 523s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 523s ok 96 - creating PL/Tcl function as user nobody succeeds 523s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 523s ok 98 - creating PL/TclU function as user postgres succeeds 523s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 523s ok 100 - calling PL/Tcl function 523s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 523s ok 102 - calling PL/TclU function 524s ok 103 - stopping cluster 524s ok 104 - pg_ctlcluster 17 main start 524s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 526s ok 106 - pg_ctlcluster 17 main start 526s ok 107 - cluster restarts with pgdata symlink 526s ok 108 - postgres master has OOM killer protection 526s ok 109 - postgres client backend has no OOM adjustment 526s ok 110 - ps h 6003 526s ok 111 - process title is idle 527s ok 112 - ps h 6003 527s ok 113 - process title is idle in transaction 527s ok 114 - stopping cluster 529s ok 115 - starting cluster as postgres works without a log file 529s ok 116 - log file got recreated and used 529s ok 117 - creating a directory in spc2 529s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.Jo4HdC'" 529s ok 119 - creating tablespace spc1 529s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 529s ok 121 - creating a table in spc1 530s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.jMPBCN'" 530s ok 123 - creating tablespace spc2 530s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 530s ok 125 - creating a table in spc2 530s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 530s ok 127 - Correct apt NeverAutoRemove config 531s ok 128 - pg_dropcluster removes cluster 531s ok 129 - xlog/wal directory /tmp/17.xlog.TPFA9t was deleted 531s ok 130 - tablespace spc1 was emptied 531s ok 131 - tablespace spc2 was emptied 531s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 531s ok 133 - Correct apt NeverAutoRemove config 531s # Cleanup 531s ok 134 - Cleanup: No clusters left behind 531s ok 135 - No postgres processes left behind 531s ok 136 - No files in /etc/postgresql left behind 531s ok 137 - No files in /var/lib/postgresql left behind 531s ok 138 - No files in /var/run/postgresql left behind 531s ok 139 - No files in /var/log/postgresql left behind 531s ok 140 - PostgreSQL TCP ports are closed 531s ok 141 - Next free port is 5432 531s ### End test 020_create_sql_remove.t ### 531s 531s ### PostgreSQL test 021_pg_renamecluster.t ### 531s 1..20 535s ok 1 - pg_createcluster 17 main 538s ok 2 - pg_renamecluster 17 main donau 538s ok 3 - psql -tAc "show data_directory" 538s ok 4 - cluster is running and data_directory was moved 538s ok 5 - pg_hba.conf location updated 538s ok 6 - pg_ident.conf location updated 538s ok 7 - external_pid_file location updated 538s ok 8 - external_pid_file exists 538s ok 9 # skip no stats_temp_directory in 17 538s ok 10 # skip no stats_temp_directory in 17 538s ok 11 - cluster_name is updated 539s ok 12 - pg_dropcluster removes cluster 539s # Cleanup 539s ok 13 - Cleanup: No clusters left behind 540s ok 14 - No postgres processes left behind 540s ok 15 - No files in /etc/postgresql left behind 540s ok 16 - No files in /var/lib/postgresql left behind 540s ok 17 - No files in /var/run/postgresql left behind 540s ok 18 - No files in /var/log/postgresql left behind 540s ok 19 - PostgreSQL TCP ports are closed 540s ok 20 - Next free port is 5432 540s ### End test 021_pg_renamecluster.t ### 540s 540s ### PostgreSQL test 022_recovery.t ### 540s 1..17 540s # Running tests for 17 543s ok 1 - pg_createcluster 17 main --start >/dev/null 543s ok 2 - pg_ctlcluster 17 main stop -m i 546s ok 3 - pg_ctlcluster 17 main start 546s ok 4 - psql -c '' 546s ok 5 - pg_ctlcluster 17 main stop -m i 546s ok 6 - create write-protected file in data directory 548s ok 7 - pg_ctlcluster 17 main start 548s ok 8 - psql -c '' 550s ok 9 - pg_dropcluster removes cluster 550s # Cleanup 550s ok 10 - Cleanup: No clusters left behind 550s ok 11 - No postgres processes left behind 550s ok 12 - No files in /etc/postgresql left behind 550s ok 13 - No files in /var/lib/postgresql left behind 550s ok 14 - No files in /var/run/postgresql left behind 550s ok 15 - No files in /var/log/postgresql left behind 550s ok 16 - PostgreSQL TCP ports are closed 550s ok 17 - Next free port is 5432 550s ### End test 022_recovery.t ### 550s 550s ### PostgreSQL test 025_logging.t ### 550s 1..55 551s # Logging to /var/log/syslog works 551s # Running tests for 17 554s ok 1 - pg_createcluster 17 main 554s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 554s ok 3 - psql -qc "'foobar_17_7237'" 554s ok 4 - log an error 555s ok 5 - grep --binary-files=text foobar_17_7237 /var/log/postgresql/postgresql-17-main.log 555s ok 6 - error appears in logfile 555s ok 7 - pg_conftool 17 main set log_destination syslog 555s ok 8 - set log_destination syslog 555s ok 9 - pg_ctlcluster 17 main reload 555s ok 10 - 17 main reload 555s ok 11 - psql -Atc "show log_destination" 555s ok 12 - log_destination is syslog 555s ok 13 - pg_lscluster reports syslog 555s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 555s ok 15 - error appears in /var/log/syslog 555s ok 16 - pg_conftool 17 main set logging_collector on 555s ok 17 - set logging_collector on 555s ok 18 - pg_conftool 17 main set log_destination csvlog 555s ok 19 - set log_destination csvlog 558s ok 20 - pg_ctlcluster 17 main restart 558s ok 21 - 17 main restart 558s ok 22 - psql -Atc "show logging_collector" 558s ok 23 - logging_collector is on 558s ok 24 - psql -Atc "show log_destination" 558s ok 25 - log_destination is csvlog 558s ok 26 - pg_lscluster reports csvlog 558s ok 27 - psql -qc "'barbaz_17_7237'" 558s ok 28 - log an error 559s ok 29 - grep --binary-files=text barbaz_17_7237 /var/lib/postgresql/17/main/log/*.csv 559s ok 30 - error appears in log/*.csv 559s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 559s ok 32 - set log_destination stderr,syslog,csvlog 559s ok 33 - pg_ctlcluster 17 main reload 559s ok 34 - 17 main reload 559s ok 35 - psql -Atc "show log_destination" 559s ok 36 - log_destination is stderr,syslog,csvlog 559s ok 37 - pg_lscluster reports stderr,syslog,csvlog 559s ok 38 - psql -qc "'moo_17_7237'" 559s ok 39 - log an error 559s ok 40 - grep --binary-files=text moo_17_7237 /var/lib/postgresql/17/main/log/*.log 559s ok 41 - error appears in log/*.log 560s ok 42 - grep --binary-files=text 'postgres.*moo_17_7237' /var/log/syslog 560s ok 43 - error appears in /var/log/syslog 560s ok 44 - grep --binary-files=text moo_17_7237 /var/lib/postgresql/17/main/log/*.csv 560s ok 45 - error appears in log/*.csv 562s ok 46 - pg_dropcluster 17 main --stop 562s ok 47 - pg_dropcluster removes cluster 562s # Cleanup 562s ok 48 - Cleanup: No clusters left behind 562s ok 49 - No postgres processes left behind 562s ok 50 - No files in /etc/postgresql left behind 562s ok 51 - No files in /var/lib/postgresql left behind 562s ok 52 - No files in /var/run/postgresql left behind 562s ok 53 - No files in /var/log/postgresql left behind 562s ok 54 - PostgreSQL TCP ports are closed 562s ok 55 - Next free port is 5432 562s ### End test 025_logging.t ### 562s 562s ### PostgreSQL test 027_jit.t ### 562s # 17 565s ok 1 - pg_createcluster 17 main --start 565s ok 2 - psql -Xatc 'show jit' 565s ok 3 - JIT is on by default 565s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 565s ok 5 - No JIT on cheap query 565s ok 6 - pg_conftool 17 main set seq_page_cost 100000 565s ok 7 - pg_conftool 17 main set random_page_cost 100000 565s ok 8 - pg_ctlcluster 17 main reload 566s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 566s ok 10 - Expensive query is JITed 568s ok 11 - pg_dropcluster --stop 17 main 568s # Cleanup 568s ok 12 - Cleanup: No clusters left behind 568s ok 13 - No postgres processes left behind 568s ok 14 - No files in /etc/postgresql left behind 568s ok 15 - No files in /var/lib/postgresql left behind 568s ok 16 - No files in /var/run/postgresql left behind 568s ok 17 - No files in /var/log/postgresql left behind 568s ok 18 - PostgreSQL TCP ports are closed 568s ok 19 - Next free port is 5432 568s 1..19 568s ### End test 027_jit.t ### 568s 568s ### PostgreSQL test 030_errors.t ### 568s 1..156 568s ok 1 - pg_lscluster reports cluster without binaries 569s ok 2 - pg_dropcluster 6.3 main 570s ok 3 - pg_createcluster --socketdir 570s ok 4 - pg_lsclusters -h 570s ok 5 - cluster was created 570s ok 6 - Port of created cluster is 5432 570s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 570s ok 8 - pg_createcluster on existing cluster 570s ok 9 - pg_lsclusters -h 570s ok 10 - original cluster still exists 570s ok 11 - pg_createcluster 17 test -p foo 570s ok 12 - pg_createcluster -p checks that port option is numeric 570s ok 13 - pg_createcluster 17 test -p 42 570s ok 14 - pg_createcluster -p checks valid port range 570s ok 15 - pg_ctlcluster 17 main start 570s ok 16 - pg_ctlcluster refuses to start root-owned cluster 570s ok 17 - pg_ctlcluster 17 main start 570s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 570s ok 19 - pg_ctlcluster 17 main start 570s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 570s ok 21 - pg_ctlcluster 17 main start 570s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 573s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 573s ok 24 - No sockets in /var/run/postgresql 573s ok 25 - Socket is in /tmp/postgresql-testsuite/ 573s ok 26 - cluster stops with custom unix_socket_dir 573s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 575s ok 28 - cluster starts after removing unix_socket_dir 575s ok 29 - Socket is in default dir /var/run/postgresql 575s ok 30 - No sockets in /tmp/postgresql-testsuite/ 575s ok 31 - pg_ctlcluster 17 main stop 575s ok 32 - pg_ctlcluster fails with corrupted PID file 575s ok 33 - pg_lsclusters -h 575s ok 34 - cluster is still online 576s ok 35 - pg_ctlcluster succeeds with restored PID file 576s ok 36 - pg_lsclusters -h 576s ok 37 - cluster is down 576s ok 38 - pg_ctlcluster 17 main stop 576s ok 39 - pg_ctlcluster stop fails on stopped cluster 578s ok 40 - pg_ctlcluster 17 main start 578s ok 41 - pg_ctlcluster succeeds with already existing PID file 578s ok 42 - pg_lsclusters -h 578s ok 43 - cluster is online 578s ok 44 - pg_ctlcluster stop succeeds 578s ok 45 - pg_lsclusters -h 578s ok 46 - cluster is down 578s ok 47 - no pid file left 578s ok 48 - pg_ctlcluster 17 main stop 578s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 578s ok 50 - pid file was cleaned up 578s ok 51 - pg_ctlcluster --force 17 main stop 578s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 578s ok 53 - pid file was cleaned up 578s ok 54 - pg_ctlcluster 17 main stop 578s ok 55 - pg_ctlcluster stop succeeds with stale PID file 578s ok 56 - pid file was cleaned up 578s ok 57 - pg_ctlcluster --force 17 main stop 578s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 578s ok 59 - pid file was cleaned up 578s ok 60 - pg_ctlcluster --force 17 main stop 578s ok 61 - pg_ctlcluster stop succeeds with empty PID file 578s ok 62 - pid file was cleaned up 581s ok 63 - pg_ctlcluster 17 main start 581s ok 64 - pg_ctlcluster succeeds with corrupted PID file 581s ok 65 - pg_lsclusters -h 581s ok 66 - cluster is online 581s ok 67 - pg_ctlcluster 17 main start 581s ok 68 - pg_ctlcluster start fails on running cluster 581s ok 69 - pg_ctlcluster stop 581s ok 70 - pg_ctlcluster 17 main start 581s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 581s ok 72 - pg_ctlcluster 17 main stop 581s ok 73 - stopping cluster 587s ok 74 - pg_ctlcluster 17 main start 587s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 588s ok 76 - pg_ctlcluster 17 main stop 588s ok 77 - stopping cluster 588s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 588s ok 79 - pg_dropcluster 17 main 588s ok 80 - pg_dropcluster works as user postgres 589s ok 81 - pg_createcluster succeeds 589s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 589s ok 83 - proper error message for nonexisting /var/lib/postgresql 591s ok 84 - pg_ctlcluster 17 main start 591s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 591s ok 86 - pg_ctlcluster 17 main stop 591s ok 87 - stopping cluster 592s ok 88 - pg_createcluster other 594s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 597s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 597s ok 91 597s ok 92 - pg_ctlcluster 17 other start 597s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 597s ok 94 - pg_ctlcluster 17 main stop 597s ok 95 - stopping main cluster 599s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 601s ok 97 - pg_dropcluster other 602s ok 98 - pg_dropcluster 602s ok 99 - No sockets any more 602s ok 100 - 'pg_lsclusters 4.5 foo' fails 602s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 602s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 602s ok 103 - 'psql --cluster 4.5/foo' fails 602s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 602s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 602s ok 106 - 'psql --cluster 17/foo' fails 602s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 602s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 602s ok 109 - 'pg_dropcluster 4.5 foo' fails 602s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 602s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 602s ok 112 - 'pg_dropcluster 17 foo' fails 602s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 602s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 603s ok 115 - 'pg_upgradecluster 4.5 foo' fails 603s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 603s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 603s ok 118 - 'pg_upgradecluster 17 foo' fails 603s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 603s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 603s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 603s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 603s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 603s ok 124 - 'pg_ctlcluster 17 foo stop' fails 603s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 603s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 603s # Cleanup 603s ok 127 - Cleanup: No clusters left behind 603s ok 128 - No postgres processes left behind 603s ok 129 - No files in /etc/postgresql left behind 603s ok 130 - No files in /var/lib/postgresql left behind 603s ok 131 - No files in /var/run/postgresql left behind 603s ok 132 - No files in /var/log/postgresql left behind 603s ok 133 - PostgreSQL TCP ports are closed 603s ok 134 - Next free port is 5432 604s ok 135 - pg_dropcluster 17 broken 604s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 604s # Cleanup 604s ok 137 - Cleanup: No clusters left behind 604s ok 138 - No postgres processes left behind 604s ok 139 - No files in /etc/postgresql left behind 604s ok 140 - No files in /var/lib/postgresql left behind 604s ok 141 - No files in /var/run/postgresql left behind 604s ok 142 - No files in /var/log/postgresql left behind 604s ok 143 - PostgreSQL TCP ports are closed 604s ok 144 - Next free port is 5432 606s ok 145 - pg_dropcluster 17 broken 606s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 606s ok 147 - /etc/postgresql/17 was removed 606s ok 148 - /var/lib/postgresql/17 was removed 606s # Cleanup 606s ok 149 - Cleanup: No clusters left behind 606s ok 150 - No postgres processes left behind 606s ok 151 - No files in /etc/postgresql left behind 606s ok 152 - No files in /var/lib/postgresql left behind 606s ok 153 - No files in /var/run/postgresql left behind 606s ok 154 - No files in /var/log/postgresql left behind 606s ok 155 - PostgreSQL TCP ports are closed 606s ok 156 - Next free port is 5432 606s ### End test 030_errors.t ### 606s 606s ### PostgreSQL test 031_errors_disk_full.t ### 606s 1..22 607s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 607s # Failed test 'script failed' 607s # at ./t/031_errors_disk_full.t line 43. 607s # got: '32' 607s # expected: '0' 607s # Failed test 'pg_createcluster fails due to insufficient disk space' 607s # at ./t/031_errors_disk_full.t line 44. 607s # 'mount: /var/lib/postgresql: permission denied. 607s # dmesg(1) may have more information after failed mount system call. 607s # umount: /var/lib/postgresql: must be superuser to unmount. 607s # ' 607s # doesn't match '(?^i:No space left on device)' 607s # Failed test 'does not leave files behind' 607s # at ./t/031_errors_disk_full.t line 46. 607s # 'mount: /var/lib/postgresql: permission denied. 607s # dmesg(1) may have more information after failed mount system call. 607s # umount: /var/lib/postgresql: must be superuser to unmount. 607s # ' 607s # doesn't match '(?^:\nls>