0s autopkgtest [07:03:26]: starting date and time: 2025-02-22 07:03:26+0000 0s autopkgtest [07:03:26]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:03:26]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.xx33bzi1/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-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-10.secgroup --name adt-plucky-ppc64el-pgsql-http-20250222-070326-juju-7f2275-prod-proposed-migration-environment-20-a9710df2-7f3e-4beb-b536-448952873b20 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -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/ 80s autopkgtest [07:04:46]: testbed dpkg architecture: ppc64el 80s autopkgtest [07:04:46]: testbed apt version: 2.9.30ubuntu1 80s autopkgtest [07:04:46]: @@@@@@@@@@@@@@@@@@@@ test bed setup 80s autopkgtest [07:04:46]: testbed release detected to be: None 81s autopkgtest [07:04:47]: updating testbed package index (apt update) 81s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 82s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 82s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 82s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 82s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 82s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 82s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 82s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 82s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 82s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 82s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 82s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 82s Fetched 1276 kB in 1s (1471 kB/s) 83s Reading package lists... 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 84s Calculating upgrade... 84s Calculating upgrade... 84s The following packages will be upgraded: 84s curl libcurl3t64-gnutls libcurl4t64 84s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 84s Need to get 1221 kB of archives. 84s After this operation, 3072 B disk space will be freed. 84s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 85s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 85s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 85s Fetched 1221 kB in 1s (2008 kB/s) 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 ... 106371 files and directories currently installed.) 85s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 85s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 85s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 85s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 85s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 85s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 85s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 85s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 85s Setting up curl (8.12.1-2ubuntu1) ... 85s Processing triggers for man-db (2.13.0-1) ... 86s Processing triggers for libc-bin (2.40-4ubuntu1) ... 86s Reading package lists... 87s Building dependency tree... 87s Reading state information... 87s Solving dependencies... 87s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s autopkgtest [07:04:53]: upgrading testbed (apt dist-upgrade and autopurge) 87s Reading package lists... 87s Building dependency tree... 87s Reading state information... 88s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 88s Starting 2 pkgProblemResolver with broken count: 0 88s Done 88s Entering ResolveByKeep 88s 88s Calculating upgrade... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 89s Reading package lists... 89s Building dependency tree... 89s Reading state information... 89s Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 89s Solving dependencies... 89s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s autopkgtest [07:04:58]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 92s autopkgtest [07:04:58]: @@@@@@@@@@@@@@@@@@@@ apt-source pgsql-http 94s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (dsc) [2129 B] 94s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (tar) [23.8 kB] 94s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgsql-http 1.6.3-1 (diff) [2284 B] 94s gpgv: Signature made Tue Feb 4 15:22:11 2025 UTC 94s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 94s gpgv: Can't check signature: No public key 94s dpkg-source: warning: cannot verify inline signature for ./pgsql-http_1.6.3-1.dsc: no acceptable signature found 94s autopkgtest [07:05:00]: testing package pgsql-http version 1.6.3-1 94s autopkgtest [07:05:00]: build not needed 94s autopkgtest [07:05:00]: test installcheck: preparing testbed 95s Reading package lists... 95s Building dependency tree... 95s Reading state information... 95s Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 95s The following NEW packages will be installed: 95s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 95s postgresql-17 postgresql-17-http postgresql-client-17 95s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 95s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 95s Need to get 51.4 MB of archives. 95s After this operation, 222 MB of additional disk space will be used. 95s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 96s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 96s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 96s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 96s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 96s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 96s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 96s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 97s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 97s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 97s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 97s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 97s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-http ppc64el 1.6.3-1 [47.7 kB] 98s Preconfiguring packages ... 98s Fetched 51.4 MB in 2s (25.3 MB/s) 98s Selecting previously unselected package libjson-perl. 98s (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 ... 106371 files and directories currently installed.) 98s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 98s Unpacking libjson-perl (4.10000-1) ... 98s Selecting previously unselected package postgresql-client-common. 98s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 98s Unpacking postgresql-client-common (273) ... 98s Selecting previously unselected package libio-pty-perl. 98s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 98s Unpacking libio-pty-perl (1:1.20-1build3) ... 98s Selecting previously unselected package libipc-run-perl. 98s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 98s Unpacking libipc-run-perl (20231003.0-2) ... 98s Selecting previously unselected package postgresql-common-dev. 98s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 98s Unpacking postgresql-common-dev (273) ... 98s Selecting previously unselected package ssl-cert. 98s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 98s Unpacking ssl-cert (1.1.3ubuntu1) ... 98s Selecting previously unselected package postgresql-common. 98s Preparing to unpack .../06-postgresql-common_273_all.deb ... 98s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 98s Unpacking postgresql-common (273) ... 98s Selecting previously unselected package libllvm20:ppc64el. 98s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 98s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 99s Selecting previously unselected package libpq5:ppc64el. 99s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 99s Unpacking libpq5:ppc64el (17.4-1) ... 99s Selecting previously unselected package libxslt1.1:ppc64el. 99s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 99s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 99s Selecting previously unselected package postgresql-client-17. 99s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 99s Unpacking postgresql-client-17 (17.4-1) ... 99s Selecting previously unselected package postgresql-17. 99s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 99s Unpacking postgresql-17 (17.4-1) ... 99s Selecting previously unselected package postgresql-17-http. 99s Preparing to unpack .../12-postgresql-17-http_1.6.3-1_ppc64el.deb ... 99s Unpacking postgresql-17-http (1.6.3-1) ... 99s Setting up postgresql-client-common (273) ... 99s Setting up libio-pty-perl (1:1.20-1build3) ... 99s Setting up libpq5:ppc64el (17.4-1) ... 99s Setting up ssl-cert (1.1.3ubuntu1) ... 100s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 100s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 100s Setting up libipc-run-perl (20231003.0-2) ... 100s Setting up libjson-perl (4.10000-1) ... 100s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 100s Setting up postgresql-common-dev (273) ... 100s Setting up postgresql-client-17 (17.4-1) ... 100s 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 100s Setting up postgresql-common (273) ... 101s Creating config file /etc/postgresql-common/createcluster.conf with new version 101s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 101s Removing obsolete dictionary files: 102s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 102s Setting up postgresql-17 (17.4-1) ... 103s Creating new PostgreSQL cluster 17/main ... 103s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 103s The files belonging to this database system will be owned by user "postgres". 103s This user must also own the server process. 103s 103s The database cluster will be initialized with locale "C.UTF-8". 103s The default database encoding has accordingly been set to "UTF8". 103s The default text search configuration will be set to "english". 103s 103s Data page checksums are disabled. 103s 103s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 103s creating subdirectories ... ok 103s selecting dynamic shared memory implementation ... posix 103s selecting default "max_connections" ... 100 103s selecting default "shared_buffers" ... 128MB 103s selecting default time zone ... Etc/UTC 103s creating configuration files ... ok 103s running bootstrap script ... ok 104s performing post-bootstrap initialization ... ok 104s syncing data to disk ... ok 107s Setting up postgresql-17-http (1.6.3-1) ... 107s Processing triggers for man-db (2.13.0-1) ... 108s Processing triggers for libc-bin (2.40-4ubuntu1) ... 109s autopkgtest [07:05:15]: test installcheck: [----------------------- 109s + curl -f https://httpbun.org/status/202 109s % Total % Received % Xferd Average Speed Time Time Time Current 109s Dload Upload Total Spent Left Speed 110s 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0{ 110s "code": 202, 110s "description": "Accepted" 110s } 110s 100 47 100 47 0 0 68 0 --:--:-- --:--:-- --:--:-- 68 110s + pg_buildext installcheck 110s ### PostgreSQL 17 installcheck ### 110s Creating new PostgreSQL cluster 17/regress ... 113s make: curl-config: No such file or directory 113s 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 113s # +++ regress install-check in +++ 113s # using postmaster on localhost, port 5433 113s # 1 of 1 tests failed. 113s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.EvNzI0/build.hjI/src/regression.diffs". 113s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.EvNzI0/build.hjI/src/regression.out". 113s not ok 1 - http 53 ms 113s 1..1 113s *** /tmp/pg_virtualenv.UxqOOV/log/postgresql-17-regress.log (last 100 lines) *** 113s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 113s 2025-02-22 07:05:19.615 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_get('http://localhost:9080/anything?foo=bar'); 113s 2025-02-22 07:05:19.615 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.615 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'args'->>'this' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 113s 2025-02-22 07:05:19.615 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.615 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->>'args' as args, 113s (content::json)->>'data' as data, 113s content::json->>'url' as url, 113s content::json->>'method' as method 113s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_delete('http://localhost:9080/anything?foo=bar'); 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method, 113s content::json->>'data' AS data 113s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.616 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->>'data' AS data, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->>'data' AS data, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->>'data' AS data, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.617 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'form'->>'this' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s content::json->'form'->>'key1' AS key1, 113s content::json->'form'->>'key2' AS key2, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT lower(field) AS field, value 113s FROM ( 113s SELECT (unnest(headers)).* 113s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 113s ) a 113s WHERE field ILIKE 'Abcde'; 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.618 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status, 113s (content::json)->>'url' AS url 113s FROM http_get('http://localhost:9080/redirect-to?url=get'); 113s 2025-02-22 07:05:19.619 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.619 UTC [4089] ubuntu@contrib_regression STATEMENT: WITH 113s http AS ( 113s SELECT * FROM http_get('http://localhost:9080/image/png') 113s ), 113s headers AS ( 113s SELECT (unnest(headers)).* FROM http 113s ) 113s SELECT 113s http.content_type, 113s length(text_to_bytea(http.content)) AS length_binary 113s FROM http, headers 113s WHERE field ilike 'Content-Type'; 113s 2025-02-22 07:05:19.619 UTC [4089] ubuntu@contrib_regression WARNING: Failed to connect 113s 2025-02-22 07:05:19.619 UTC [4089] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression WARNING: Failed to connect 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 6 at RAISE 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/status/555'); 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.620 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT status FROM http_get('http://localhost:9080/delay/7'); 113s 2025-02-22 07:05:19.621 UTC [4089] ubuntu@contrib_regression ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s 2025-02-22 07:05:19.621 UTC [4089] ubuntu@contrib_regression STATEMENT: SELECT * 113s FROM http_get('http://localhost:9080/delay/7'); 113s Dropping cluster 17/regress ... 113s **** regression.diffs **** 113s diff -U3 /tmp/autopkgtest.EvNzI0/build.hjI/src/expected/http.out /tmp/autopkgtest.EvNzI0/build.hjI/src/results/http.out 113s --- /tmp/autopkgtest.EvNzI0/build.hjI/src/expected/http.out 2025-01-23 23:36:13.000000000 +0000 113s +++ /tmp/autopkgtest.EvNzI0/build.hjI/src/results/http.out 2025-02-22 07:05:19.616421079 +0000 113s @@ -9,11 +9,7 @@ 113s -- Status code 113s SELECT status 113s FROM http_get('http://localhost:9080/status/202'); 113s - status 113s --------- 113s - 202 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Headers 113s SELECT lower(field) AS field, value 113s FROM ( 113s @@ -21,33 +17,21 @@ 113s FROM http_get('http://localhost:9080/response-headers?Abcde=abcde') 113s ) a 113s WHERE field ILIKE 'Abcde'; 113s - field | value 113s --------+------- 113s - abcde | abcde 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- GET 113s SELECT status, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_get('http://localhost:9080/anything?foo=bar'); 113s - status | args | url | method 113s ---------+------+----------------------------------------+-------- 113s - 200 | bar | http://localhost:9080/anything?foo=bar | GET 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- GET with data 113s SELECT status, 113s content::json->'args'->>'this' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_get('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 113s - status | args | url | method 113s ---------+------+------------------------------------------+-------- 113s - 200 | that | http://localhost:9080/anything?this=that | GET 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- GET with data 113s SELECT status, 113s content::json->>'args' as args, 113s @@ -55,22 +39,14 @@ 113s content::json->>'url' as url, 113s content::json->>'method' as method 113s FROM http(('GET', 'http://localhost:9080/anything', NULL, 'application/json', '{"search": "toto"}')); 113s - status | args | data | url | method 113s ---------+------+--------------------+--------------------------------+-------- 113s - 200 | {} | {"search": "toto"} | http://localhost:9080/anything | GET 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- DELETE 113s SELECT status, 113s content::json->'args'->>'foo' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_delete('http://localhost:9080/anything?foo=bar'); 113s - status | args | url | method 113s ---------+------+----------------------------------------+-------- 113s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- DELETE with payload 113s SELECT status, 113s content::json->'args'->>'foo' AS args, 113s @@ -78,11 +54,7 @@ 113s content::json->>'method' AS method, 113s content::json->>'data' AS data 113s FROM http_delete('http://localhost:9080/anything?foo=bar', 'payload', 'text/plain'); 113s - status | args | url | method | data 113s ---------+------+----------------------------------------+--------+--------- 113s - 200 | bar | http://localhost:9080/anything?foo=bar | DELETE | payload 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- PUT 113s SELECT status, 113s content::json->>'data' AS data, 113s @@ -90,11 +62,7 @@ 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_put('http://localhost:9080/anything?foo=bar','payload','text/plain'); 113s - status | data | args | url | method 113s ---------+---------+------+----------------------------------------+-------- 113s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | PUT 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- PATCH 113s SELECT status, 113s content::json->>'data' AS data, 113s @@ -102,11 +70,7 @@ 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_patch('http://localhost:9080/anything?foo=bar','{"this":"that"}','application/json'); 113s - status | data | args | url | method 113s ---------+-----------------+------+----------------------------------------+-------- 113s - 200 | {"this":"that"} | bar | http://localhost:9080/anything?foo=bar | PATCH 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- POST 113s SELECT status, 113s content::json->>'data' AS data, 113s @@ -114,22 +78,14 @@ 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything?foo=bar','payload','text/plain'); 113s - status | data | args | url | method 113s ---------+---------+------+----------------------------------------+-------- 113s - 200 | payload | bar | http://localhost:9080/anything?foo=bar | POST 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- POST with json data 113s SELECT status, 113s content::json->'form'->>'this' AS args, 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything', jsonb_build_object('this', 'that')); 113s - status | args | url | method 113s ---------+------+--------------------------------+-------- 113s - 200 | that | http://localhost:9080/anything | POST 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- POST with data 113s SELECT status, 113s content::json->'form'->>'key1' AS key1, 113s @@ -137,11 +93,7 @@ 113s content::json->>'url' AS url, 113s content::json->>'method' AS method 113s FROM http_post('http://localhost:9080/anything', 'key1=value1&key2=value2','application/x-www-form-urlencoded'); 113s - status | key1 | key2 | url | method 113s ---------+--------+--------+--------------------------------+-------- 113s - 200 | value1 | value2 | http://localhost:9080/anything | POST 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- HEAD 113s SELECT lower(field) AS field, value 113s FROM ( 113s @@ -149,20 +101,12 @@ 113s FROM http_head('http://localhost:9080/response-headers?Abcde=abcde') 113s ) a 113s WHERE field ILIKE 'Abcde'; 113s - field | value 113s --------+------- 113s - abcde | abcde 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Follow redirect 113s SELECT status, 113s (content::json)->>'url' AS url 113s FROM http_get('http://localhost:9080/redirect-to?url=get'); 113s - status | url 113s ---------+--------------------------- 113s - 200 | http://localhost:9080/get 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Request image 113s WITH 113s http AS ( 113s @@ -176,11 +120,7 @@ 113s length(text_to_bytea(http.content)) AS length_binary 113s FROM http, headers 113s WHERE field ilike 'Content-Type'; 113s - content_type | length_binary 113s ---------------+--------------- 113s - image/png | 8090 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Alter options and and reset them and throw errors 113s SELECT http_set_curlopt('CURLOPT_PROXY', '127.0.0.1'); 113s http_set_curlopt 113s @@ -217,11 +157,7 @@ 113s 113s -- Now it should work 113s SELECT status FROM http_get('http://localhost:9080/status/555'); 113s - status 113s --------- 113s - 555 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Alter the default timeout and then run a query that is longer than 113s -- the default (5s), but shorter than the new timeout 113s SELECT http_set_curlopt('CURLOPT_TIMEOUT_MS', '10000'); 113s @@ -231,23 +167,19 @@ 113s (1 row) 113s 113s SELECT status FROM http_get('http://localhost:9080/delay/7'); 113s - status 113s --------- 113s - 200 113s -(1 row) 113s - 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s -- Check that statement interruption works 113s SET statement_timeout = 200; 113s CREATE TEMPORARY TABLE timer AS 113s SELECT now() AS start; 113s SELECT * 113s FROM http_get('http://localhost:9080/delay/7'); 113s -ERROR: canceling statement due to user request 113s +ERROR: Failed to connect to localhost port 9080 after 0 ms: Could not connect to server 113s SELECT round(extract(epoch FROM now() - start) * 10) AS m 113s FROM timer; 113s m 113s --- 113s - 2 113s + 0 113s (1 row) 113s 113s DROP TABLE timer; 113s ### End 17 installcheck (FAILED with exit code 1) ### 114s autopkgtest [07:05:20]: test installcheck: -----------------------] 114s installcheck FLAKY non-zero exit status 1 114s autopkgtest [07:05:20]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 115s autopkgtest [07:05:21]: @@@@@@@@@@@@@@@@@@@@ summary 115s installcheck FLAKY non-zero exit status 1 119s nova [W] Using flock in prodstack6-ppc64el 119s Creating nova instance adt-plucky-ppc64el-pgsql-http-20250222-070326-juju-7f2275-prod-proposed-migration-environment-20-a9710df2-7f3e-4beb-b536-448952873b20 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 119s nova [W] Timed out waiting for 7c104533-b88a-4220-b9df-899fbb8f3a3c to get deleted.