0s autopkgtest [14:24:36]: starting date and time: 2025-03-15 14:24:36+0000 0s autopkgtest [14:24:36]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:24:36]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ogoxmn83/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-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-27.secgroup --name adt-plucky-s390x-pgsql-http-20250315-142436-juju-7f2275-prod-proposed-migration-environment-2-1689982c-a699-4cc4-9fb8-1eaea1b51920 --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-s390x -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/ 152s autopkgtest [14:27:08]: testbed dpkg architecture: s390x 152s autopkgtest [14:27:08]: testbed apt version: 2.9.33 152s autopkgtest [14:27:08]: @@@@@@@@@@@@@@@@@@@@ test bed setup 152s autopkgtest [14:27:08]: testbed release detected to be: None 153s autopkgtest [14:27:09]: updating testbed package index (apt update) 154s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 154s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 154s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 154s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 154s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 154s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 154s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 154s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [80.6 kB] 155s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x c-n-f Metadata [1940 B] 155s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x c-n-f Metadata [116 B] 155s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [342 kB] 155s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x c-n-f Metadata [14.4 kB] 155s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [3776 B] 155s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x c-n-f Metadata [328 B] 155s Fetched 1090 kB in 1s (759 kB/s) 156s Reading package lists... 156s Reading package lists... 156s Building dependency tree... 156s Reading state information... 157s Calculating upgrade... 157s Calculating upgrade... 157s The following packages were automatically installed and are no longer required: 157s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 157s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 157s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 157s linux-tools-6.11.0-8-generic 157s Use 'sudo apt autoremove' to remove them. 157s The following packages will be upgraded: 157s python3-jinja2 strace 157s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 157s Need to get 609 kB of archives. 157s After this operation, 27.6 kB of additional disk space will be used. 157s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x strace s390x 6.13+ds-1ubuntu1 [500 kB] 158s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 158s Fetched 609 kB in 1s (612 kB/s) 158s (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 ... 81428 files and directories currently installed.) 158s Preparing to unpack .../strace_6.13+ds-1ubuntu1_s390x.deb ... 158s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 158s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 158s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 158s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 158s Setting up strace (6.13+ds-1ubuntu1) ... 158s Processing triggers for man-db (2.13.0-1) ... 159s Reading package lists... 159s Building dependency tree... 159s Reading state information... 159s Solving dependencies... 159s The following packages will be REMOVED: 159s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 159s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 159s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 159s linux-tools-6.11.0-8-generic* 159s 0 upgraded, 0 newly installed, 9 to remove and 5 not upgraded. 159s After this operation, 167 MB disk space will be freed. 159s (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 ... 81428 files and directories currently installed.) 159s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 159s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 159s Removing libpython3.12t64:s390x (3.12.9-1) ... 159s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 159s Removing libnsl2:s390x (1.3.0-3build3) ... 159s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 159s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 160s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 160s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 160s Processing triggers for libc-bin (2.41-1ubuntu1) ... 160s (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 ... 56328 files and directories currently installed.) 160s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 160s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 161s autopkgtest [14:27:17]: upgrading testbed (apt dist-upgrade and autopurge) 161s Reading package lists... 161s Building dependency tree... 161s Reading state information... 161s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 161s Starting 2 pkgProblemResolver with broken count: 0 161s Done 161s Entering ResolveByKeep 161s 161s Calculating upgrade... 161s The following packages will be upgraded: 161s libc-bin libc-dev-bin libc6 libc6-dev locales 162s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 162s Need to get 9512 kB of archives. 162s After this operation, 8192 B of additional disk space will be used. 162s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6-dev s390x 2.41-1ubuntu2 [1678 kB] 163s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-dev-bin s390x 2.41-1ubuntu2 [24.3 kB] 163s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6 s390x 2.41-1ubuntu2 [2892 kB] 165s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-bin s390x 2.41-1ubuntu2 [671 kB] 166s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x locales all 2.41-1ubuntu2 [4246 kB] 170s Preconfiguring packages ... 170s Fetched 9512 kB in 8s (1207 kB/s) 170s (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 ... 56326 files and directories currently installed.) 170s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_s390x.deb ... 170s Unpacking libc6-dev:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 170s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_s390x.deb ... 170s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 170s Preparing to unpack .../libc6_2.41-1ubuntu2_s390x.deb ... 170s Unpacking libc6:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 170s Setting up libc6:s390x (2.41-1ubuntu2) ... 170s (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 ... 56326 files and directories currently installed.) 170s Preparing to unpack .../libc-bin_2.41-1ubuntu2_s390x.deb ... 170s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 170s Setting up libc-bin (2.41-1ubuntu2) ... 170s (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 ... 56326 files and directories currently installed.) 170s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 170s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 170s Setting up locales (2.41-1ubuntu2) ... 171s Generating locales (this might take a while)... 171s en_US.UTF-8... done 171s Generation complete. 171s Setting up libc-dev-bin (2.41-1ubuntu2) ... 171s Setting up libc6-dev:s390x (2.41-1ubuntu2) ... 171s Processing triggers for man-db (2.13.0-1) ... 172s Processing triggers for systemd (257.3-1ubuntu3) ... 173s Reading package lists... 173s Building dependency tree... 173s Reading state information... 173s Starting pkgProblemResolver with broken count: 0 173s Starting 2 pkgProblemResolver with broken count: 0 173s Done 173s Solving dependencies... 173s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 174s autopkgtest [14:27:30]: rebooting testbed after setup commands that affected boot 193s autopkgtest [14:27:49]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP Wed Mar 12 14:53:49 UTC 2025 195s autopkgtest [14:27:51]: @@@@@@@@@@@@@@@@@@@@ apt-source pgsql-http 197s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (dsc) [2129 B] 197s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (tar) [23.8 kB] 197s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (diff) [2284 B] 197s gpgv: Signature made Tue Feb 4 15:22:11 2025 UTC 197s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 197s gpgv: Can't check signature: No public key 197s dpkg-source: warning: cannot verify inline signature for ./pgsql-http_1.6.3-1.dsc: no acceptable signature found 197s autopkgtest [14:27:53]: testing package pgsql-http version 1.6.3-1 197s autopkgtest [14:27:53]: build not needed 198s autopkgtest [14:27:54]: test installcheck: preparing testbed 198s Reading package lists... 198s Building dependency tree... 198s Reading state information... 198s Starting pkgProblemResolver with broken count: 0 198s Starting 2 pkgProblemResolver with broken count: 0 198s Done 198s The following NEW packages will be installed: 198s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 198s postgresql-17 postgresql-17-http postgresql-client-17 198s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 198s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 198s Need to get 49.8 MB of archives. 198s After this operation, 213 MB of additional disk space will be used. 198s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 199s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 274 [47.6 kB] 199s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 199s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 199s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 274 [73.0 kB] 199s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 199s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 274 [101 kB] 199s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 226s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x libpq5 s390x 17.4-1 [147 kB] 226s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 227s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 228s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 241s Get:13 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-17-http s390x 1.6.3-1 [46.3 kB] 242s Preconfiguring packages ... 242s Fetched 49.8 MB in 43s (1156 kB/s) 242s Selecting previously unselected package libjson-perl. 242s (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 ... 56326 files and directories currently installed.) 242s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 242s Unpacking libjson-perl (4.10000-1) ... 242s Selecting previously unselected package postgresql-client-common. 242s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 242s Unpacking postgresql-client-common (274) ... 242s Selecting previously unselected package libio-pty-perl. 242s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 242s Unpacking libio-pty-perl (1:1.20-1build3) ... 242s Selecting previously unselected package libipc-run-perl. 242s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 242s Unpacking libipc-run-perl (20231003.0-2) ... 242s Selecting previously unselected package postgresql-common-dev. 242s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 242s Unpacking postgresql-common-dev (274) ... 242s Selecting previously unselected package ssl-cert. 242s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 242s Unpacking ssl-cert (1.1.3ubuntu1) ... 242s Selecting previously unselected package postgresql-common. 242s Preparing to unpack .../06-postgresql-common_274_all.deb ... 242s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 242s Unpacking postgresql-common (274) ... 242s Selecting previously unselected package libllvm20:s390x. 242s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 242s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 242s Selecting previously unselected package libpq5:s390x. 242s Preparing to unpack .../08-libpq5_17.4-1_s390x.deb ... 242s Unpacking libpq5:s390x (17.4-1) ... 242s Selecting previously unselected package libxslt1.1:s390x. 242s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 242s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 242s Selecting previously unselected package postgresql-client-17. 242s Preparing to unpack .../10-postgresql-client-17_17.4-1_s390x.deb ... 242s Unpacking postgresql-client-17 (17.4-1) ... 242s Selecting previously unselected package postgresql-17. 242s Preparing to unpack .../11-postgresql-17_17.4-1_s390x.deb ... 242s Unpacking postgresql-17 (17.4-1) ... 243s Selecting previously unselected package postgresql-17-http. 243s Preparing to unpack .../12-postgresql-17-http_1.6.3-1_s390x.deb ... 243s Unpacking postgresql-17-http (1.6.3-1) ... 243s Setting up postgresql-client-common (274) ... 243s Setting up libio-pty-perl (1:1.20-1build3) ... 243s Setting up libpq5:s390x (17.4-1) ... 243s Setting up ssl-cert (1.1.3ubuntu1) ... 243s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 244s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 244s Setting up libipc-run-perl (20231003.0-2) ... 244s Setting up libjson-perl (4.10000-1) ... 244s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 244s Setting up postgresql-common-dev (274) ... 244s Setting up postgresql-client-17 (17.4-1) ... 244s 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 244s Setting up postgresql-common (274) ... 244s Creating config file /etc/postgresql-common/createcluster.conf with new version 244s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 244s Removing obsolete dictionary files: 245s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 245s Setting up postgresql-17 (17.4-1) ... 245s Creating new PostgreSQL cluster 17/main ... 245s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 245s The files belonging to this database system will be owned by user "postgres". 245s This user must also own the server process. 245s 245s The database cluster will be initialized with locale "C.UTF-8". 245s The default database encoding has accordingly been set to "UTF8". 245s The default text search configuration will be set to "english". 245s 245s Data page checksums are disabled. 245s 245s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 245s creating subdirectories ... ok 245s selecting dynamic shared memory implementation ... posix 245s selecting default "max_connections" ... 100 245s selecting default "shared_buffers" ... 128MB 245s selecting default time zone ... Etc/UTC 245s creating configuration files ... ok 245s running bootstrap script ... ok 246s performing post-bootstrap initialization ... ok 246s syncing data to disk ... ok 248s Setting up postgresql-17-http (1.6.3-1) ... 248s Processing triggers for man-db (2.13.0-1) ... 249s Processing triggers for libc-bin (2.41-1ubuntu2) ... 250s autopkgtest [14:28:46]: test installcheck: [----------------------- 250s + curl -f https://httpbun.org/status/202 251s % Total % Received % Xferd Average Speed Time Time Time Current 251s Dload Upload Total Spent Left Speed 251s 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0{ 251s "code": 202, 251s "description": "Accepted" 251s } 251s 100 47 100 47 0 0 68 0 --:--:-- --:--:-- --:--:-- 68 251s + pg_buildext installcheck 251s ### PostgreSQL 17 installcheck ### 251s Creating new PostgreSQL cluster 17/regress ... 254s make: curl-config: No such file or directory 254s 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 254s # +++ regress install-check in +++ 254s # using postmaster on localhost, port 5433 254s not ok 1 - http 25 ms 254s 1..1 254s # 1 of 1 tests failed. 254s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.mnlGg8/build.tDd/src/regression.diffs". 254s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.mnlGg8/build.tDd/src/regression.out". 254s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 254s *** /tmp/pg_virtualenv.5YJ6bO/log/postgresql-17-regress.log (last 100 lines) *** 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_get('http://localhost:9080/anything?foo=bar'); 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'args'->>'this' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->>'args' as args, 254s (content::json)->>'data' as data, 254s content::json->>'url' as url, 254s content::json->>'method' as method 254s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_delete('http://localhost:9080/anything?foo=bar'); 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method, 254s content::json->>'data' AS data 254s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.422 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->>'data' AS data, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->>'data' AS data, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->>'data' AS data, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'form'->>'this' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s content::json->'form'->>'key1' AS key1, 254s content::json->'form'->>'key2' AS key2, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT lower(field) AS field, value 254s FROM ( 254s SELECT (unnest(headers)).* 254s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 254s ) a 254s WHERE field ILIKE 'Abcde'; 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.423 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status, 254s (content::json)->>'url' AS url 254s FROM http_get('http://localhost:9080/redirect-to?url=get'); 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression STATEMENT: WITH 254s http AS ( 254s SELECT * FROM http_get('http://localhost:9080/image/png') 254s ), 254s headers AS ( 254s SELECT (unnest(headers)).* FROM http 254s ) 254s SELECT 254s http.content_type, 254s length(text_to_bytea(http.content)) AS length_binary 254s FROM http, headers 254s WHERE field ilike 'Content-Type'; 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression WARNING: Failed to connect 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression WARNING: Failed to connect 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/status/555'); 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.424 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/delay/7'); 254s 2025-03-15 14:28:50.425 UTC [3575] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s 2025-03-15 14:28:50.425 UTC [3575] ubuntu@contrib_regression STATEMENT: SELECT * 254s FROM http_get('http://localhost:9080/delay/7'); 254s Dropping cluster 17/regress ... 254s **** regression.diffs **** 254s diff -U3 /tmp/autopkgtest.mnlGg8/build.tDd/src/expected/http.out /tmp/autopkgtest.mnlGg8/build.tDd/src/results/http.out 254s --- /tmp/autopkgtest.mnlGg8/build.tDd/src/expected/http.out 2025-01-23 23:36:13.000000000 +0000 254s +++ /tmp/autopkgtest.mnlGg8/build.tDd/src/results/http.out 2025-03-15 14:28:50.425093677 +0000 254s @@ -9,11 +9,7 @@ 254s -- Status code 254s SELECT status 254s FROM http_get('http://localhost:9080/status/202'); 254s - status 254s --------- 254s - 202 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Headers 254s SELECT lower(field) AS field, value 254s FROM ( 254s @@ -21,33 +17,21 @@ 254s FROM http_get('http://localhost:9080/response-headers?Abcde=abcde') 254s ) a 254s WHERE field ILIKE 'Abcde'; 254s - field | value 254s --------+------- 254s - abcde | abcde 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- GET 254s SELECT status, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_get('http://localhost:9080/anything?foo=bar'); 254s - status | args | url | method 254s ---------+------+----------------------------------------+-------- 254s - 200 | bar | http://localhost:9080/anything?foo=bar | GET 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- GET with data 254s SELECT status, 254s content::json->'args'->>'this' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 254s - status | args | url | method 254s ---------+------+------------------------------------------+-------- 254s - 200 | that | http://localhost:9080/anything?this=that | GET 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- GET with data 254s SELECT status, 254s content::json->>'args' as args, 254s @@ -55,22 +39,14 @@ 254s content::json->>'url' as url, 254s content::json->>'method' as method 254s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 254s - status | args | data | url | method 254s ---------+------+--------------------+--------------------------------+-------- 254s - 200 | {} | {"search": "toto"} | http://localhost:9080/anything | GET 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- DELETE 254s SELECT status, 254s content::json->'args'->>'foo' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_delete('http://localhost:9080/anything?foo=bar'); 254s - status | args | url | method 254s ---------+------+----------------------------------------+-------- 254s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- DELETE with payload 254s SELECT status, 254s content::json->'args'->>'foo' AS args, 254s @@ -78,11 +54,7 @@ 254s content::json->>'method' AS method, 254s content::json->>'data' AS data 254s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 254s - status | args | url | method | data 254s ---------+------+----------------------------------------+--------+--------- 254s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE | payload 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- PUT 254s SELECT status, 254s content::json->>'data' AS data, 254s @@ -90,11 +62,7 @@ 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 254s - status | data | args | url | method 254s ---------+---------+------+----------------------------------------+-------- 254s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | PUT 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- PATCH 254s SELECT status, 254s content::json->>'data' AS data, 254s @@ -102,11 +70,7 @@ 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 254s - status | data | args | url | method 254s ---------+-----------------+------+----------------------------------------+-------- 254s - 200 | {"this":"that"} | bar | http://localhost:9080/anything?foo=bar | PATCH 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- POST 254s SELECT status, 254s content::json->>'data' AS data, 254s @@ -114,22 +78,14 @@ 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 254s - status | data | args | url | method 254s ---------+---------+------+----------------------------------------+-------- 254s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | POST 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- POST with json data 254s SELECT status, 254s content::json->'form'->>'this' AS args, 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 254s - status | args | url | method 254s ---------+------+--------------------------------+-------- 254s - 200 | that | http://localhost:9080/anything | POST 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- POST with data 254s SELECT status, 254s content::json->'form'->>'key1' AS key1, 254s @@ -137,11 +93,7 @@ 254s content::json->>'url' AS url, 254s content::json->>'method' AS method 254s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 254s - status | key1 | key2 | url | method 254s ---------+--------+--------+--------------------------------+-------- 254s - 200 | value1 | value2 | http://localhost:9080/anything | POST 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- HEAD 254s SELECT lower(field) AS field, value 254s FROM ( 254s @@ -149,20 +101,12 @@ 254s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 254s ) a 254s WHERE field ILIKE 'Abcde'; 254s - field | value 254s --------+------- 254s - abcde | abcde 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Follow redirect 254s SELECT status, 254s (content::json)->>'url' AS url 254s FROM http_get('http://localhost:9080/redirect-to?url=get'); 254s - status | url 254s ---------+--------------------------- 254s - 200 | http://localhost:9080/get 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Request image 254s WITH 254s http AS ( 254s @@ -176,11 +120,7 @@ 254s length(text_to_bytea(http.content)) AS length_binary 254s FROM http, headers 254s WHERE field ilike 'Content-Type'; 254s - content_type | length_binary 254s ---------------+--------------- 254s - image/png | 8090 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Alter options and and reset them and throw errors 254s SELECT http_set_curlopt('CURLOPT_PROXY', '127.0.0.1'); 254s http_set_curlopt 254s @@ -217,11 +157,7 @@ 254s 254s -- Now it should work 254s SELECT status FROM http_get('http://localhost:9080/status/555'); 254s - status 254s --------- 254s - 555 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Alter the default timeout and then run a query that is longer than 254s -- the default (5s), but shorter than the new timeout 254s SELECT http_set_curlopt('CURLOPT_TIMEOUT_MS', '10000'); 254s @@ -231,23 +167,19 @@ 254s (1 row) 254s 254s SELECT status FROM http_get('http://localhost:9080/delay/7'); 254s - status 254s --------- 254s - 200 254s -(1 row) 254s - 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s -- Check that statement interruption works 254s SET statement_timeout = 200; 254s CREATE TEMPORARY TABLE timer AS 254s SELECT now() AS start; 254s SELECT * 254s FROM http_get('http://localhost:9080/delay/7'); 254s -ERROR: canceling statement due to user request 254s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 254s SELECT round(extract(epoch FROM now() - start) * 10) AS m 254s FROM timer; 254s m 254s --- 254s - 2 254s + 0 254s (1 row) 254s 254s DROP TABLE timer; 254s ### End 17 installcheck (FAILED with exit code 1) ### 254s autopkgtest [14:28:50]: test installcheck: -----------------------] 255s installcheck FLAKY non-zero exit status 1 255s autopkgtest [14:28:51]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 256s autopkgtest [14:28:52]: @@@@@@@@@@@@@@@@@@@@ summary 256s installcheck FLAKY non-zero exit status 1 262s nova [W] Using flock in prodstack6-s390x 262s Creating nova instance adt-plucky-s390x-pgsql-http-20250315-142436-juju-7f2275-prod-proposed-migration-environment-2-1689982c-a699-4cc4-9fb8-1eaea1b51920 from image adt/ubuntu-plucky-s390x-server-20250315.img (UUID 3d3557fa-fd0f-4bba-9b89-8d5964e09f61)... 262s nova [W] Timed out waiting for 5c574249-09f8-41f3-875e-d456f81b0037 to get deleted.