0s autopkgtest [14:17:49]: starting date and time: 2025-03-15 14:17:49+0000 0s autopkgtest [14:17:49]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:17:49]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.o4riq8_d/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade pgsql-http --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-18.secgroup --name adt-plucky-arm64-pgsql-http-20250315-141749-juju-7f2275-prod-proposed-migration-environment-2-d42b4255-9a83-4a98-b178-e72e7f1e43cf --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/ 157s autopkgtest [14:20:26]: testbed dpkg architecture: arm64 157s autopkgtest [14:20:26]: testbed apt version: 2.9.33 157s autopkgtest [14:20:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 158s autopkgtest [14:20:27]: testbed release detected to be: None 158s autopkgtest [14:20:27]: updating testbed package index (apt update) 159s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 159s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 159s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 159s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 159s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 160s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 160s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 160s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 160s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 160s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 160s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 160s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 160s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 160s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 161s Fetched 1094 kB in 2s (693 kB/s) 162s Reading package lists... 162s Reading package lists... 163s Building dependency tree... 163s Reading state information... 164s Calculating upgrade... 164s Calculating upgrade... 165s The following packages will be upgraded: 165s python3-jinja2 strace 165s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 165s Need to get 608 kB of archives. 165s After this operation, 11.3 kB of additional disk space will be used. 165s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 165s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 166s Fetched 608 kB in 1s (593 kB/s) 166s (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 ... 117701 files and directories currently installed.) 166s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 166s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 166s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 167s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 167s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 167s Setting up strace (6.13+ds-1ubuntu1) ... 167s Processing triggers for man-db (2.13.0-1) ... 168s Reading package lists... 168s Building dependency tree... 168s Reading state information... 168s Solving dependencies... 168s The following packages will be REMOVED: 168s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 168s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 168s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 168s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 169s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 169s After this operation, 267 MB disk space will be freed. 169s (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 ... 117701 files and directories currently installed.) 169s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 169s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 169s Removing libpython3.12t64:arm64 (3.12.9-1) ... 169s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 169s Removing libnsl2:arm64 (1.3.0-3build3) ... 169s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 169s Removing libunwind8:arm64 (1.6.2-3.1) ... 169s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 170s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 171s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 171s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 171s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 171s /etc/kernel/postrm.d/initramfs-tools: 171s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 171s /etc/kernel/postrm.d/zz-flash-kernel: 171s flash-kernel: Kernel 6.11.0-8-generic has been removed. 171s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 172s /etc/kernel/postrm.d/zz-update-grub: 172s Sourcing file `/etc/default/grub' 172s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 172s Generating grub configuration file ... 172s Found linux image: /boot/vmlinuz-6.14.0-10-generic 172s Found initrd image: /boot/initrd.img-6.14.0-10-generic 172s Warning: os-prober will not be executed to detect other bootable partitions. 172s Systems on them will not be added to the GRUB boot configuration. 172s Check GRUB_DISABLE_OS_PROBER documentation entry. 172s Adding boot menu entry for UEFI Firmware Settings ... 172s done 172s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 172s Processing triggers for libc-bin (2.41-1ubuntu1) ... 173s (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 ... 81650 files and directories currently installed.) 173s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 173s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 173s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 173s autopkgtest [14:20:42]: upgrading testbed (apt dist-upgrade and autopurge) 173s Reading package lists... 173s Building dependency tree... 173s Reading state information... 174s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 174s Starting 2 pkgProblemResolver with broken count: 0 174s Done 175s Entering ResolveByKeep 175s 175s Calculating upgrade... 175s The following packages will be upgraded: 175s libc-bin libc-dev-bin libc6 libc6-dev locales 176s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 176s Need to get 9530 kB of archives. 176s After this operation, 0 B of additional disk space will be used. 176s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 178s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 178s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 180s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 181s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 185s Preconfiguring packages ... 185s Fetched 9530 kB in 9s (1013 kB/s) 185s (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 ... 81647 files and directories currently installed.) 185s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 185s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 186s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 186s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 186s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 186s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 186s Setting up libc6:arm64 (2.41-1ubuntu2) ... 187s (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 ... 81647 files and directories currently installed.) 187s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 187s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 187s Setting up libc-bin (2.41-1ubuntu2) ... 187s (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 ... 81647 files and directories currently installed.) 187s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 187s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 187s Setting up locales (2.41-1ubuntu2) ... 188s Generating locales (this might take a while)... 190s en_US.UTF-8... done 190s Generation complete. 190s Setting up libc-dev-bin (2.41-1ubuntu2) ... 190s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 190s Processing triggers for man-db (2.13.0-1) ... 191s Processing triggers for systemd (257.3-1ubuntu3) ... 192s Reading package lists... 192s Building dependency tree... 192s Reading state information... 193s Starting pkgProblemResolver with broken count: 0 193s Starting 2 pkgProblemResolver with broken count: 0 193s Done 193s Solving dependencies... 194s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 194s autopkgtest [14:21:03]: rebooting testbed after setup commands that affected boot 218s autopkgtest [14:21:27]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP PREEMPT_DYNAMIC Wed Mar 12 15:45:31 UTC 2025 221s autopkgtest [14:21:30]: @@@@@@@@@@@@@@@@@@@@ apt-source pgsql-http 223s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (dsc) [2129 B] 223s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (tar) [23.8 kB] 223s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (diff) [2284 B] 223s gpgv: Signature made Tue Feb 4 15:22:11 2025 UTC 223s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 223s gpgv: Can't check signature: No public key 223s dpkg-source: warning: cannot verify inline signature for ./pgsql-http_1.6.3-1.dsc: no acceptable signature found 224s autopkgtest [14:21:33]: testing package pgsql-http version 1.6.3-1 224s autopkgtest [14:21:33]: build not needed 224s autopkgtest [14:21:33]: test installcheck: preparing testbed 225s Reading package lists... 225s Building dependency tree... 225s Reading state information... 225s Starting pkgProblemResolver with broken count: 0 225s Starting 2 pkgProblemResolver with broken count: 0 225s Done 226s The following NEW packages will be installed: 226s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 226s postgresql-17 postgresql-17-http postgresql-client-17 226s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 226s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 226s Need to get 46.9 MB of archives. 226s After this operation, 197 MB of additional disk space will be used. 226s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 226s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 226s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 226s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 227s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 227s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 227s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 227s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 253s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 253s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 253s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 255s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 271s Get:13 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-http arm64 1.6.3-1 [45.2 kB] 271s Preconfiguring packages ... 271s Fetched 46.9 MB in 45s (1038 kB/s) 272s Selecting previously unselected package libjson-perl. 272s (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 ... 81647 files and directories currently installed.) 272s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 272s Unpacking libjson-perl (4.10000-1) ... 272s Selecting previously unselected package postgresql-client-common. 272s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 272s Unpacking postgresql-client-common (274) ... 272s Selecting previously unselected package libio-pty-perl. 272s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 272s Unpacking libio-pty-perl (1:1.20-1build3) ... 272s Selecting previously unselected package libipc-run-perl. 272s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 272s Unpacking libipc-run-perl (20231003.0-2) ... 272s Selecting previously unselected package postgresql-common-dev. 272s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 272s Unpacking postgresql-common-dev (274) ... 272s Selecting previously unselected package ssl-cert. 272s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 272s Unpacking ssl-cert (1.1.3ubuntu1) ... 272s Selecting previously unselected package postgresql-common. 272s Preparing to unpack .../06-postgresql-common_274_all.deb ... 272s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 272s Unpacking postgresql-common (274) ... 272s Selecting previously unselected package libllvm20:arm64. 272s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 272s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 273s Selecting previously unselected package libpq5:arm64. 273s Preparing to unpack .../08-libpq5_17.4-1_arm64.deb ... 273s Unpacking libpq5:arm64 (17.4-1) ... 273s Selecting previously unselected package libxslt1.1:arm64. 273s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 273s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 273s Selecting previously unselected package postgresql-client-17. 273s Preparing to unpack .../10-postgresql-client-17_17.4-1_arm64.deb ... 273s Unpacking postgresql-client-17 (17.4-1) ... 273s Selecting previously unselected package postgresql-17. 273s Preparing to unpack .../11-postgresql-17_17.4-1_arm64.deb ... 273s Unpacking postgresql-17 (17.4-1) ... 273s Selecting previously unselected package postgresql-17-http. 273s Preparing to unpack .../12-postgresql-17-http_1.6.3-1_arm64.deb ... 273s Unpacking postgresql-17-http (1.6.3-1) ... 273s Setting up postgresql-client-common (274) ... 273s Setting up libio-pty-perl (1:1.20-1build3) ... 273s Setting up libpq5:arm64 (17.4-1) ... 273s Setting up ssl-cert (1.1.3ubuntu1) ... 274s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 274s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 274s Setting up libipc-run-perl (20231003.0-2) ... 274s Setting up libjson-perl (4.10000-1) ... 274s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 274s Setting up postgresql-common-dev (274) ... 274s Setting up postgresql-client-17 (17.4-1) ... 275s 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 275s Setting up postgresql-common (274) ... 275s Creating config file /etc/postgresql-common/createcluster.conf with new version 275s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 275s Removing obsolete dictionary files: 276s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 276s Setting up postgresql-17 (17.4-1) ... 277s Creating new PostgreSQL cluster 17/main ... 277s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 277s The files belonging to this database system will be owned by user "postgres". 277s This user must also own the server process. 277s 277s The database cluster will be initialized with locale "C.UTF-8". 277s The default database encoding has accordingly been set to "UTF8". 277s The default text search configuration will be set to "english". 277s 277s Data page checksums are disabled. 277s 277s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 277s creating subdirectories ... ok 277s selecting dynamic shared memory implementation ... posix 277s selecting default "max_connections" ... 100 277s selecting default "shared_buffers" ... 128MB 277s selecting default time zone ... Etc/UTC 277s creating configuration files ... ok 277s running bootstrap script ... ok 277s performing post-bootstrap initialization ... ok 277s syncing data to disk ... ok 280s Setting up postgresql-17-http (1.6.3-1) ... 280s Processing triggers for man-db (2.13.0-1) ... 282s Processing triggers for libc-bin (2.41-1ubuntu2) ... 283s autopkgtest [14:22:32]: test installcheck: [----------------------- 283s + curl -f https://httpbun.org/status/202 283s % Total % Received % Xferd Average Speed Time Time Time Current 283s Dload Upload Total Spent Left Speed 284s 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 47 100 47 0 0 55 0 --:--:-- --:--:-- --:--:-- 55 284s + pg_buildext installcheck 284s { 284s "code": 202, 284s "description": "Accepted" 284s } 284s ### PostgreSQL 17 installcheck ### 284s Creating new PostgreSQL cluster 17/regress ... 287s make: curl-config: No such file or directory 287s echo "# +++ regress install-check in +++" && /usr/lib/postgresql/17/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/17/bin' --dbname=contrib_regression http 287s # +++ regress install-check in +++ 287s # using postmaster on localhost, port 5433 287s not ok 1 - http 40 ms 287s 1..1 287s # 1 of 1 tests failed. 287s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.qi2lnh/build.BGT/src/regression.diffs". 287s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.qi2lnh/build.BGT/src/regression.out". 287s *** /tmp/pg_virtualenv.OENYag/log/postgresql-17-regress.log (last 100 lines) *** 287s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 287s 2025-03-15 14:22:36.683 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_get('http://localhost:9080/anything?foo=bar'); 287s 2025-03-15 14:22:36.684 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.684 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'args'->>'this' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 287s 2025-03-15 14:22:36.684 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.684 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->>'args' as args, 287s (content::json)->>'data' as data, 287s content::json->>'url' as url, 287s content::json->>'method' as method 287s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 287s 2025-03-15 14:22:36.685 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.685 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_delete('http://localhost:9080/anything?foo=bar'); 287s 2025-03-15 14:22:36.685 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.685 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method, 287s content::json->>'data' AS data 287s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->>'data' AS data, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->>'data' AS data, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.686 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->>'data' AS data, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 287s 2025-03-15 14:22:36.687 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.687 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'form'->>'this' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 287s 2025-03-15 14:22:36.687 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.687 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s content::json->'form'->>'key1' AS key1, 287s content::json->'form'->>'key2' AS key2, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 287s 2025-03-15 14:22:36.688 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.688 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT lower(field) AS field, value 287s FROM ( 287s SELECT (unnest(headers)).* 287s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 287s ) a 287s WHERE field ILIKE 'Abcde'; 287s 2025-03-15 14:22:36.688 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.688 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status, 287s (content::json)->>'url' AS url 287s FROM http_get('http://localhost:9080/redirect-to?url=get'); 287s 2025-03-15 14:22:36.689 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.689 UTC [3490] ubuntu@contrib_regression STATEMENT: WITH 287s http AS ( 287s SELECT * FROM http_get('http://localhost:9080/image/png') 287s ), 287s headers AS ( 287s SELECT (unnest(headers)).* FROM http 287s ) 287s SELECT 287s http.content_type, 287s length(text_to_bytea(http.content)) AS length_binary 287s FROM http, headers 287s WHERE field ilike 'Content-Type'; 287s 2025-03-15 14:22:36.690 UTC [3490] ubuntu@contrib_regression WARNING: Failed to connect 287s 2025-03-15 14:22:36.690 UTC [3490] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 287s 2025-03-15 14:22:36.690 UTC [3490] ubuntu@contrib_regression WARNING: Failed to connect 287s 2025-03-15 14:22:36.690 UTC [3490] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 287s 2025-03-15 14:22:36.691 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.691 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/status/555'); 287s 2025-03-15 14:22:36.691 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.691 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/delay/7'); 287s 2025-03-15 14:22:36.692 UTC [3490] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s 2025-03-15 14:22:36.692 UTC [3490] ubuntu@contrib_regression STATEMENT: SELECT * 287s FROM http_get('http://localhost:9080/delay/7'); 287s Dropping cluster 17/regress ... 287s **** regression.diffs **** 287s diff -U3 /tmp/autopkgtest.qi2lnh/build.BGT/src/expected/http.out /tmp/autopkgtest.qi2lnh/build.BGT/src/results/http.out 287s --- /tmp/autopkgtest.qi2lnh/build.BGT/src/expected/http.out 2025-01-23 23:36:13.000000000 +0000 287s +++ /tmp/autopkgtest.qi2lnh/build.BGT/src/results/http.out 2025-03-15 14:22:36.692424206 +0000 287s @@ -9,11 +9,7 @@ 287s -- Status code 287s SELECT status 287s FROM http_get('http://localhost:9080/status/202'); 287s - status 287s --------- 287s - 202 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Headers 287s SELECT lower(field) AS field, value 287s FROM ( 287s @@ -21,33 +17,21 @@ 287s FROM http_get('http://localhost:9080/response-headers?Abcde=abcde') 287s ) a 287s WHERE field ILIKE 'Abcde'; 287s - field | value 287s --------+------- 287s - abcde | abcde 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- GET 287s SELECT status, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_get('http://localhost:9080/anything?foo=bar'); 287s - status | args | url | method 287s ---------+------+----------------------------------------+-------- 287s - 200 | bar | http://localhost:9080/anything?foo=bar | GET 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- GET with data 287s SELECT status, 287s content::json->'args'->>'this' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 287s - status | args | url | method 287s ---------+------+------------------------------------------+-------- 287s - 200 | that | http://localhost:9080/anything?this=that | GET 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- GET with data 287s SELECT status, 287s content::json->>'args' as args, 287s @@ -55,22 +39,14 @@ 287s content::json->>'url' as url, 287s content::json->>'method' as method 287s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 287s - status | args | data | url | method 287s ---------+------+--------------------+--------------------------------+-------- 287s - 200 | {} | {"search": "toto"} | http://localhost:9080/anything | GET 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- DELETE 287s SELECT status, 287s content::json->'args'->>'foo' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_delete('http://localhost:9080/anything?foo=bar'); 287s - status | args | url | method 287s ---------+------+----------------------------------------+-------- 287s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- DELETE with payload 287s SELECT status, 287s content::json->'args'->>'foo' AS args, 287s @@ -78,11 +54,7 @@ 287s content::json->>'method' AS method, 287s content::json->>'data' AS data 287s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 287s - status | args | url | method | data 287s ---------+------+----------------------------------------+--------+--------- 287s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE | payload 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- PUT 287s SELECT status, 287s content::json->>'data' AS data, 287s @@ -90,11 +62,7 @@ 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 287s - status | data | args | url | method 287s ---------+---------+------+----------------------------------------+-------- 287s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | PUT 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- PATCH 287s SELECT status, 287s content::json->>'data' AS data, 287s @@ -102,11 +70,7 @@ 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 287s - status | data | args | url | method 287s ---------+-----------------+------+----------------------------------------+-------- 287s - 200 | {"this":"that"} | bar | http://localhost:9080/anything?foo=bar | PATCH 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- POST 287s SELECT status, 287s content::json->>'data' AS data, 287s @@ -114,22 +78,14 @@ 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 287s - status | data | args | url | method 287s ---------+---------+------+----------------------------------------+-------- 287s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | POST 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- POST with json data 287s SELECT status, 287s content::json->'form'->>'this' AS args, 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 287s - status | args | url | method 287s ---------+------+--------------------------------+-------- 287s - 200 | that | http://localhost:9080/anything | POST 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- POST with data 287s SELECT status, 287s content::json->'form'->>'key1' AS key1, 287s @@ -137,11 +93,7 @@ 287s content::json->>'url' AS url, 287s content::json->>'method' AS method 287s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 287s - status | key1 | key2 | url | method 287s ---------+--------+--------+--------------------------------+-------- 287s - 200 | value1 | value2 | http://localhost:9080/anything | POST 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- HEAD 287s SELECT lower(field) AS field, value 287s FROM ( 287s @@ -149,20 +101,12 @@ 287s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 287s ) a 287s WHERE field ILIKE 'Abcde'; 287s - field | value 287s --------+------- 287s - abcde | abcde 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Follow redirect 287s SELECT status, 287s (content::json)->>'url' AS url 287s FROM http_get('http://localhost:9080/redirect-to?url=get'); 287s - status | url 287s ---------+--------------------------- 287s - 200 | http://localhost:9080/get 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Request image 287s WITH 287s http AS ( 287s @@ -176,11 +120,7 @@ 287s length(text_to_bytea(http.content)) AS length_binary 287s FROM http, headers 287s WHERE field ilike 'Content-Type'; 287s - content_type | length_binary 287s ---------------+--------------- 287s - image/png | 8090 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Alter options and and reset them and throw errors 287s SELECT http_set_curlopt('CURLOPT_PROXY', '127.0.0.1'); 287s http_set_curlopt 287s @@ -217,11 +157,7 @@ 287s 287s -- Now it should work 287s SELECT status FROM http_get('http://localhost:9080/status/555'); 287s - status 287s --------- 287s - 555 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Alter the default timeout and then run a query that is longer than 287s -- the default (5s), but shorter than the new timeout 287s SELECT http_set_curlopt('CURLOPT_TIMEOUT_MS', '10000'); 287s @@ -231,23 +167,19 @@ 287s (1 row) 287s 287s SELECT status FROM http_get('http://localhost:9080/delay/7'); 287s - status 287s --------- 287s - 200 287s -(1 row) 287s - 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s -- Check that statement interruption works 287s SET statement_timeout = 200; 287s CREATE TEMPORARY TABLE timer AS 287s SELECT now() AS start; 287s SELECT * 287s FROM http_get('http://localhost:9080/delay/7'); 287s -ERROR: canceling statement due to user request 287s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 287s SELECT round(extract(epoch FROM now() - start) * 10) AS m 287s FROM timer; 287s m 287s --- 287s - 2 287s + 0 287s (1 row) 287s 287s DROP TABLE timer; 287s ### End 17 installcheck (FAILED with exit code 1) ### 288s autopkgtest [14:22:37]: test installcheck: -----------------------] 288s installcheck FLAKY non-zero exit status 1 288s autopkgtest [14:22:37]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 289s autopkgtest [14:22:38]: @@@@@@@@@@@@@@@@@@@@ summary 289s installcheck FLAKY non-zero exit status 1 307s nova [W] Using flock in prodstack6-arm64 307s flock: timeout while waiting to get lock 307s Creating nova instance adt-plucky-arm64-pgsql-http-20250315-141749-juju-7f2275-prod-proposed-migration-environment-2-d42b4255-9a83-4a98-b178-e72e7f1e43cf from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 307s nova [W] Timed out waiting for 86f51770-71b5-4b0d-99e0-559b406a6149 to get deleted.