0s autopkgtest [06:45:02]: starting date and time: 2025-02-22 06:45:02+0000 0s autopkgtest [06:45:02]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:45:02]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.yxbzmojw/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgsql-http --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-s390x-2.secgroup --name adt-plucky-s390x-pgsql-http-20250222-064502-juju-7f2275-prod-proposed-migration-environment-20-538ff477-93de-4930-a6e3-543eca5d3b5e --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --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/ 78s autopkgtest [06:46:20]: testbed dpkg architecture: s390x 79s autopkgtest [06:46:20]: testbed apt version: 2.9.30ubuntu1 79s autopkgtest [06:46:21]: @@@@@@@@@@@@@@@@@@@@ test bed setup 79s autopkgtest [06:46:21]: testbed release detected to be: None 79s autopkgtest [06:46:21]: updating testbed package index (apt update) 80s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 80s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 80s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 80s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 80s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 80s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 80s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 80s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 80s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [125 kB] 80s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [760 B] 80s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [424 kB] 80s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [2816 B] 81s Fetched 1264 kB in 1s (1392 kB/s) 81s Reading package lists... 82s Reading package lists... 82s Building dependency tree... 82s Reading state information... 82s Calculating upgrade... 82s Calculating upgrade... 82s The following packages were automatically installed and are no longer required: 82s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 82s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 82s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 82s linux-tools-6.11.0-8-generic 82s Use 'sudo apt autoremove' to remove them. 82s The following packages will be upgraded: 82s curl libcurl3t64-gnutls libcurl4t64 82s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 82s Need to get 1041 kB of archives. 82s After this operation, 7168 B disk space will be freed. 82s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x curl s390x 8.12.1-2ubuntu1 [251 kB] 83s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl4t64 s390x 8.12.1-2ubuntu1 [397 kB] 83s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl3t64-gnutls s390x 8.12.1-2ubuntu1 [393 kB] 83s Fetched 1041 kB in 1s (1544 kB/s) 83s (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 ... 81030 files and directories currently installed.) 83s Preparing to unpack .../curl_8.12.1-2ubuntu1_s390x.deb ... 83s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 83s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_s390x.deb ... 83s Unpacking libcurl4t64:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 83s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_s390x.deb ... 83s Unpacking libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 83s Setting up libcurl4t64:s390x (8.12.1-2ubuntu1) ... 83s Setting up libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) ... 83s Setting up curl (8.12.1-2ubuntu1) ... 83s Processing triggers for man-db (2.13.0-1) ... 84s Processing triggers for libc-bin (2.40-4ubuntu1) ... 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 84s Solving dependencies... 84s The following packages will be REMOVED: 84s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 84s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 84s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 84s linux-tools-6.11.0-8-generic* 84s 0 upgraded, 0 newly installed, 9 to remove and 0 not upgraded. 84s After this operation, 167 MB disk space will be freed. 84s (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 ... 81030 files and directories currently installed.) 84s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 84s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 84s Removing libpython3.12t64:s390x (3.12.9-1) ... 84s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 84s Removing libnsl2:s390x (1.3.0-3build3) ... 84s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 84s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 84s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 85s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 85s Processing triggers for libc-bin (2.40-4ubuntu1) ... 85s (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 ... 55930 files and directories currently installed.) 85s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 85s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 86s autopkgtest [06:46:28]: upgrading testbed (apt dist-upgrade and autopurge) 86s Reading package lists... 86s Building dependency tree... 86s Reading state information... 86s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 86s Starting 2 pkgProblemResolver with broken count: 0 86s Done 86s Entering ResolveByKeep 86s 86s Calculating upgrade... 86s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s Reading package lists... 87s Building dependency tree... 87s Reading state information... 87s Starting pkgProblemResolver with broken count: 0 87s Starting 2 pkgProblemResolver with broken count: 0 87s Done 87s Solving dependencies... 87s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s autopkgtest [06:46:29]: rebooting testbed after setup commands that affected boot 107s autopkgtest [06:46:49]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 15:05:57 UTC 2025 109s autopkgtest [06:46:51]: @@@@@@@@@@@@@@@@@@@@ apt-source pgsql-http 110s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (dsc) [2129 B] 110s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (tar) [23.8 kB] 110s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (diff) [2284 B] 110s gpgv: Signature made Tue Feb 4 15:22:11 2025 UTC 110s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 110s gpgv: Can't check signature: No public key 110s dpkg-source: warning: cannot verify inline signature for ./pgsql-http_1.6.3-1.dsc: no acceptable signature found 110s autopkgtest [06:46:52]: testing package pgsql-http version 1.6.3-1 111s autopkgtest [06:46:53]: build not needed 111s autopkgtest [06:46:53]: test installcheck: preparing testbed 111s Reading package lists... 111s Building dependency tree... 111s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 112s The following NEW packages will be installed: 112s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 112s postgresql-17 postgresql-17-http postgresql-client-17 112s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 112s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 112s Need to get 49.8 MB of archives. 112s After this operation, 213 MB of additional disk space will be used. 112s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 112s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 273 [47.5 kB] 112s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 112s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 112s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 273 [72.9 kB] 112s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 112s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 273 [101 kB] 112s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 114s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq5 s390x 17.4-1 [147 kB] 114s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 114s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 114s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 115s Get:13 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-17-http s390x 1.6.3-1 [46.3 kB] 115s Preconfiguring packages ... 115s Fetched 49.8 MB in 3s (17.6 MB/s) 115s Selecting previously unselected package libjson-perl. 115s (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 ... 55928 files and directories currently installed.) 115s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 115s Unpacking libjson-perl (4.10000-1) ... 115s Selecting previously unselected package postgresql-client-common. 115s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 115s Unpacking postgresql-client-common (273) ... 115s Selecting previously unselected package libio-pty-perl. 115s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 115s Unpacking libio-pty-perl (1:1.20-1build3) ... 115s Selecting previously unselected package libipc-run-perl. 115s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 115s Unpacking libipc-run-perl (20231003.0-2) ... 115s Selecting previously unselected package postgresql-common-dev. 115s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 115s Unpacking postgresql-common-dev (273) ... 115s Selecting previously unselected package ssl-cert. 115s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 115s Unpacking ssl-cert (1.1.3ubuntu1) ... 115s Selecting previously unselected package postgresql-common. 115s Preparing to unpack .../06-postgresql-common_273_all.deb ... 115s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 115s Unpacking postgresql-common (273) ... 115s Selecting previously unselected package libllvm20:s390x. 115s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 115s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 116s Selecting previously unselected package libpq5:s390x. 116s Preparing to unpack .../08-libpq5_17.4-1_s390x.deb ... 116s Unpacking libpq5:s390x (17.4-1) ... 116s Selecting previously unselected package libxslt1.1:s390x. 116s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 116s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 116s Selecting previously unselected package postgresql-client-17. 116s Preparing to unpack .../10-postgresql-client-17_17.4-1_s390x.deb ... 116s Unpacking postgresql-client-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17. 116s Preparing to unpack .../11-postgresql-17_17.4-1_s390x.deb ... 116s Unpacking postgresql-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17-http. 116s Preparing to unpack .../12-postgresql-17-http_1.6.3-1_s390x.deb ... 116s Unpacking postgresql-17-http (1.6.3-1) ... 116s Setting up postgresql-client-common (273) ... 116s Setting up libio-pty-perl (1:1.20-1build3) ... 116s Setting up libpq5:s390x (17.4-1) ... 116s Setting up ssl-cert (1.1.3ubuntu1) ... 116s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 117s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 117s Setting up libipc-run-perl (20231003.0-2) ... 117s Setting up libjson-perl (4.10000-1) ... 117s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 117s Setting up postgresql-common-dev (273) ... 117s Setting up postgresql-client-17 (17.4-1) ... 117s 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 117s Setting up postgresql-common (273) ... 117s Creating config file /etc/postgresql-common/createcluster.conf with new version 117s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 117s Removing obsolete dictionary files: 118s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 118s Setting up postgresql-17 (17.4-1) ... 119s Creating new PostgreSQL cluster 17/main ... 119s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 119s The files belonging to this database system will be owned by user "postgres". 119s This user must also own the server process. 119s 119s The database cluster will be initialized with locale "C.UTF-8". 119s The default database encoding has accordingly been set to "UTF8". 119s The default text search configuration will be set to "english". 119s 119s Data page checksums are disabled. 119s 119s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 119s creating subdirectories ... ok 119s selecting dynamic shared memory implementation ... posix 119s selecting default "max_connections" ... 100 119s selecting default "shared_buffers" ... 128MB 119s selecting default time zone ... Etc/UTC 119s creating configuration files ... ok 119s running bootstrap script ... ok 119s performing post-bootstrap initialization ... ok 119s syncing data to disk ... ok 122s Setting up postgresql-17-http (1.6.3-1) ... 122s Processing triggers for man-db (2.13.0-1) ... 123s Processing triggers for libc-bin (2.40-4ubuntu1) ... 124s autopkgtest [06:47:06]: test installcheck: [----------------------- 124s + curl -f https://httpbun.org/status/202 124s % Total % Received % Xferd Average Speed Time Time Time Current 124s Dload Upload Total Spent Left Speed 125s 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0{ 125s "code": 202, 125s "description": "Accepted" 125s } 125s 100 47 100 47 0 0 65 0 --:--:-- --:--:-- --:--:-- 65 125s + pg_buildext installcheck 125s ### PostgreSQL 17 installcheck ### 125s Creating new PostgreSQL cluster 17/regress ... 127s make: curl-config: No such file or directory 127s 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 127s # +++ regress install-check in +++ 127s # using postmaster on localhost, port 5433 127s # 1 of 1 tests failed. 127s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.iXCS7l/build.VXJ/src/regression.diffs". 127s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.iXCS7l/build.VXJ/src/regression.out". 127s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 127s not ok 1 - http 30 ms 127s 1..1 127s *** /tmp/pg_virtualenv.BGZDAk/log/postgresql-17-regress.log (last 100 lines) *** 127s 2025-02-22 06:48:35.461 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_get('http://localhost:9080/anything?foo=bar'); 127s 2025-02-22 06:48:35.461 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.461 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'args'->>'this' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 127s 2025-02-22 06:48:35.461 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.461 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->>'args' as args, 127s (content::json)->>'data' as data, 127s content::json->>'url' as url, 127s content::json->>'method' as method 127s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_delete('http://localhost:9080/anything?foo=bar'); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method, 127s content::json->>'data' AS data 127s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->>'data' AS data, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->>'data' AS data, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->>'data' AS data, 127s content::json->'args'->>'foo' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.462 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'form'->>'this' AS args, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s content::json->'form'->>'key1' AS key1, 127s content::json->'form'->>'key2' AS key2, 127s content::json->>'url' AS url, 127s content::json->>'method' AS method 127s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT lower(field) AS field, value 127s FROM ( 127s SELECT (unnest(headers)).* 127s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 127s ) a 127s WHERE field ILIKE 'Abcde'; 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status, 127s (content::json)->>'url' AS url 127s FROM http_get('http://localhost:9080/redirect-to?url=get'); 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.463 UTC [3539] ubuntu@contrib_regression STATEMENT: WITH 127s http AS ( 127s SELECT * FROM http_get('http://localhost:9080/image/png') 127s ), 127s headers AS ( 127s SELECT (unnest(headers)).* FROM http 127s ) 127s SELECT 127s http.content_type, 127s length(text_to_bytea(http.content)) AS length_binary 127s FROM http, headers 127s WHERE field ilike 'Content-Type'; 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression WARNING: Failed to connect 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression WARNING: Failed to connect 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.464 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/status/555'); 127s 2025-02-22 06:48:35.465 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.465 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/delay/7'); 127s 2025-02-22 06:48:35.465 UTC [3539] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 127s 2025-02-22 06:48:35.465 UTC [3539] ubuntu@contrib_regression STATEMENT: SELECT * 127s FROM http_get('http://localhost:9080/delay/7'); 127s Dropping cluster 17/regress ... 128s **** regression.diffs **** 128s diff -U3 /tmp/autopkgtest.iXCS7l/build.VXJ/src/expected/http.out /tmp/autopkgtest.iXCS7l/build.VXJ/src/results/http.out 128s --- /tmp/autopkgtest.iXCS7l/build.VXJ/src/expected/http.out 2025-01-23 23:36:13.000000000 +0000 128s +++ /tmp/autopkgtest.iXCS7l/build.VXJ/src/results/http.out 2025-02-22 06:48:35.456172826 +0000 128s @@ -9,11 +9,7 @@ 128s -- Status code 128s SELECT status 128s FROM http_get('http://localhost:9080/status/202'); 128s - status 128s --------- 128s - 202 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Headers 128s SELECT lower(field) AS field, value 128s FROM ( 128s @@ -21,33 +17,21 @@ 128s FROM http_get('http://localhost:9080/response-headers?Abcde=abcde') 128s ) a 128s WHERE field ILIKE 'Abcde'; 128s - field | value 128s --------+------- 128s - abcde | abcde 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- GET 128s SELECT status, 128s content::json->'args'->>'foo' AS args, 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_get('http://localhost:9080/anything?foo=bar'); 128s - status | args | url | method 128s ---------+------+----------------------------------------+-------- 128s - 200 | bar | http://localhost:9080/anything?foo=bar | GET 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- GET with data 128s SELECT status, 128s content::json->'args'->>'this' AS args, 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 128s - status | args | url | method 128s ---------+------+------------------------------------------+-------- 128s - 200 | that | http://localhost:9080/anything?this=that | GET 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- GET with data 128s SELECT status, 128s content::json->>'args' as args, 128s @@ -55,22 +39,14 @@ 128s content::json->>'url' as url, 128s content::json->>'method' as method 128s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 128s - status | args | data | url | method 128s ---------+------+--------------------+--------------------------------+-------- 128s - 200 | {} | {"search": "toto"} | http://localhost:9080/anything | GET 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- DELETE 128s SELECT status, 128s content::json->'args'->>'foo' AS args, 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_delete('http://localhost:9080/anything?foo=bar'); 128s - status | args | url | method 128s ---------+------+----------------------------------------+-------- 128s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- DELETE with payload 128s SELECT status, 128s content::json->'args'->>'foo' AS args, 128s @@ -78,11 +54,7 @@ 128s content::json->>'method' AS method, 128s content::json->>'data' AS data 128s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 128s - status | args | url | method | data 128s ---------+------+----------------------------------------+--------+--------- 128s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE | payload 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- PUT 128s SELECT status, 128s content::json->>'data' AS data, 128s @@ -90,11 +62,7 @@ 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 128s - status | data | args | url | method 128s ---------+---------+------+----------------------------------------+-------- 128s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | PUT 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- PATCH 128s SELECT status, 128s content::json->>'data' AS data, 128s @@ -102,11 +70,7 @@ 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 128s - status | data | args | url | method 128s ---------+-----------------+------+----------------------------------------+-------- 128s - 200 | {"this":"that"} | bar | http://localhost:9080/anything?foo=bar | PATCH 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- POST 128s SELECT status, 128s content::json->>'data' AS data, 128s @@ -114,22 +78,14 @@ 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 128s - status | data | args | url | method 128s ---------+---------+------+----------------------------------------+-------- 128s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | POST 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- POST with json data 128s SELECT status, 128s content::json->'form'->>'this' AS args, 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 128s - status | args | url | method 128s ---------+------+--------------------------------+-------- 128s - 200 | that | http://localhost:9080/anything | POST 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- POST with data 128s SELECT status, 128s content::json->'form'->>'key1' AS key1, 128s @@ -137,11 +93,7 @@ 128s content::json->>'url' AS url, 128s content::json->>'method' AS method 128s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 128s - status | key1 | key2 | url | method 128s ---------+--------+--------+--------------------------------+-------- 128s - 200 | value1 | value2 | http://localhost:9080/anything | POST 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- HEAD 128s SELECT lower(field) AS field, value 128s FROM ( 128s @@ -149,20 +101,12 @@ 128s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 128s ) a 128s WHERE field ILIKE 'Abcde'; 128s - field | value 128s --------+------- 128s - abcde | abcde 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Follow redirect 128s SELECT status, 128s (content::json)->>'url' AS url 128s FROM http_get('http://localhost:9080/redirect-to?url=get'); 128s - status | url 128s ---------+--------------------------- 128s - 200 | http://localhost:9080/get 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Request image 128s WITH 128s http AS ( 128s @@ -176,11 +120,7 @@ 128s length(text_to_bytea(http.content)) AS length_binary 128s FROM http, headers 128s WHERE field ilike 'Content-Type'; 128s - content_type | length_binary 128s ---------------+--------------- 128s - image/png | 8090 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Alter options and and reset them and throw errors 128s SELECT http_set_curlopt('CURLOPT_PROXY', '127.0.0.1'); 128s http_set_curlopt 128s @@ -217,11 +157,7 @@ 128s 128s -- Now it should work 128s SELECT status FROM http_get('http://localhost:9080/status/555'); 128s - status 128s --------- 128s - 555 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Alter the default timeout and then run a query that is longer than 128s -- the default (5s), but shorter than the new timeout 128s SELECT http_set_curlopt('CURLOPT_TIMEOUT_MS', '10000'); 128s @@ -231,23 +167,19 @@ 128s (1 row) 128s 128s SELECT status FROM http_get('http://localhost:9080/delay/7'); 128s - status 128s --------- 128s - 200 128s -(1 row) 128s - 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s -- Check that statement interruption works 128s SET statement_timeout = 200; 128s CREATE TEMPORARY TABLE timer AS 128s SELECT now() AS start; 128s SELECT * 128s FROM http_get('http://localhost:9080/delay/7'); 128s -ERROR: canceling statement due to user request 128s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 128s SELECT round(extract(epoch FROM now() - start) * 10) AS m 128s FROM timer; 128s m 128s --- 128s - 2 128s + 0 128s (1 row) 128s 128s DROP TABLE timer; 128s ### End 17 installcheck (FAILED with exit code 1) ### 128s autopkgtest [06:47:10]: test installcheck: -----------------------] 128s installcheck FLAKY non-zero exit status 1 128s autopkgtest [06:47:10]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 129s autopkgtest [06:47:11]: @@@@@@@@@@@@@@@@@@@@ summary 129s installcheck FLAKY non-zero exit status 1 146s nova [W] Using flock in prodstack6-s390x 146s Creating nova instance adt-plucky-s390x-pgsql-http-20250222-064502-juju-7f2275-prod-proposed-migration-environment-20-538ff477-93de-4930-a6e3-543eca5d3b5e from image adt/ubuntu-plucky-s390x-server-20250222.img (UUID ae633cda-0dee-481c-9805-d0ef3f3b5166)... 146s nova [W] Timed out waiting for f51eb280-54e8-4374-a29a-9bdd5c680f9b to get deleted.