0s autopkgtest [06:57:58]: starting date and time: 2025-02-22 06:57:58+0000 0s autopkgtest [06:57:58]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:57:58]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.359876vo/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pg-qualstats --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-2@bos03-ppc64el-4.secgroup --name adt-plucky-ppc64el-pg-qualstats-20250222-065757-juju-7f2275-prod-proposed-migration-environment-2-284b44d9-d9d5-420a-a781-f0b661f57fc6 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --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/ 101s autopkgtest [06:59:39]: testbed dpkg architecture: ppc64el 102s autopkgtest [06:59:40]: testbed apt version: 2.9.30ubuntu1 102s autopkgtest [06:59:40]: @@@@@@@@@@@@@@@@@@@@ test bed setup 102s autopkgtest [06:59:40]: testbed release detected to be: None 103s autopkgtest [06:59:41]: updating testbed package index (apt update) 103s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 103s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 103s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 104s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 104s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 104s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 104s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 104s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 104s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 104s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 104s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 104s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 104s Fetched 1276 kB in 1s (1353 kB/s) 105s Reading package lists... 106s Reading package lists... 106s Building dependency tree... 106s Reading state information... 106s Calculating upgrade... 106s Calculating upgrade... 107s The following packages will be upgraded: 107s curl libcurl3t64-gnutls libcurl4t64 107s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s Need to get 1221 kB of archives. 107s After this operation, 3072 B disk space will be freed. 107s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 107s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 107s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 108s Fetched 1221 kB in 1s (2038 kB/s) 108s (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.) 108s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 108s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 108s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 108s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 108s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 108s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 108s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 108s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 108s Setting up curl (8.12.1-2ubuntu1) ... 108s Processing triggers for man-db (2.13.0-1) ... 109s Processing triggers for libc-bin (2.40-4ubuntu1) ... 109s Reading package lists... 109s Building dependency tree... 109s Reading state information... 109s Solving dependencies... 109s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 109s autopkgtest [06:59:47]: upgrading testbed (apt dist-upgrade and autopurge) 110s Reading package lists... 110s Building dependency tree... 110s Reading state information... 110s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 110s Starting 2 pkgProblemResolver with broken count: 0 110s Done 111s Entering ResolveByKeep 111s 111s Calculating upgrade... 111s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 112s Solving dependencies... 112s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 115s autopkgtest [06:59:53]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 115s autopkgtest [06:59:53]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-qualstats 117s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-qualstats 2.1.1-1 (dsc) [2126 B] 117s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-qualstats 2.1.1-1 (tar) [42.7 kB] 117s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-qualstats 2.1.1-1 (diff) [2920 B] 117s gpgv: Signature made Thu Oct 3 12:57:36 2024 UTC 117s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 117s gpgv: Can't check signature: No public key 117s dpkg-source: warning: cannot verify inline signature for ./pg-qualstats_2.1.1-1.dsc: no acceptable signature found 117s autopkgtest [06:59:55]: testing package pg-qualstats version 2.1.1-1 118s autopkgtest [06:59:56]: build not needed 118s autopkgtest [06:59:56]: test installcheck: preparing testbed 118s Reading package lists... 119s Building dependency tree... 119s Reading state information... 119s Starting pkgProblemResolver with broken count: 0 119s Starting 2 pkgProblemResolver with broken count: 0 119s Done 119s The following NEW packages will be installed: 119s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 119s postgresql-17 postgresql-17-pg-qualstats postgresql-client-17 119s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 119s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 119s Need to get 51.5 MB of archives. 119s After this operation, 222 MB of additional disk space will be used. 119s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 120s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 120s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 120s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 120s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 120s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 120s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 120s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 121s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 121s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 121s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 121s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 121s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pg-qualstats ppc64el 2.1.1-1 [60.1 kB] 122s Preconfiguring packages ... 122s Fetched 51.5 MB in 2s (27.3 MB/s) 122s Selecting previously unselected package libjson-perl. 122s (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.) 122s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 122s Unpacking libjson-perl (4.10000-1) ... 122s Selecting previously unselected package postgresql-client-common. 122s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 122s Unpacking postgresql-client-common (273) ... 122s Selecting previously unselected package libio-pty-perl. 122s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 122s Unpacking libio-pty-perl (1:1.20-1build3) ... 122s Selecting previously unselected package libipc-run-perl. 122s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 122s Unpacking libipc-run-perl (20231003.0-2) ... 122s Selecting previously unselected package postgresql-common-dev. 122s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 122s Unpacking postgresql-common-dev (273) ... 122s Selecting previously unselected package ssl-cert. 122s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 122s Unpacking ssl-cert (1.1.3ubuntu1) ... 122s Selecting previously unselected package postgresql-common. 122s Preparing to unpack .../06-postgresql-common_273_all.deb ... 122s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 122s Unpacking postgresql-common (273) ... 122s Selecting previously unselected package libllvm20:ppc64el. 122s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 122s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 123s Selecting previously unselected package libpq5:ppc64el. 123s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 123s Unpacking libpq5:ppc64el (17.4-1) ... 123s Selecting previously unselected package libxslt1.1:ppc64el. 123s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 123s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 123s Selecting previously unselected package postgresql-client-17. 123s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 123s Unpacking postgresql-client-17 (17.4-1) ... 123s Selecting previously unselected package postgresql-17. 123s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 123s Unpacking postgresql-17 (17.4-1) ... 123s Selecting previously unselected package postgresql-17-pg-qualstats. 123s Preparing to unpack .../12-postgresql-17-pg-qualstats_2.1.1-1_ppc64el.deb ... 123s Unpacking postgresql-17-pg-qualstats (2.1.1-1) ... 123s Setting up postgresql-client-common (273) ... 123s Setting up libio-pty-perl (1:1.20-1build3) ... 123s Setting up libpq5:ppc64el (17.4-1) ... 123s Setting up ssl-cert (1.1.3ubuntu1) ... 124s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 124s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 124s Setting up libipc-run-perl (20231003.0-2) ... 124s Setting up libjson-perl (4.10000-1) ... 124s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 124s Setting up postgresql-common-dev (273) ... 124s Setting up postgresql-client-17 (17.4-1) ... 125s 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 125s Setting up postgresql-common (273) ... 125s Creating config file /etc/postgresql-common/createcluster.conf with new version 126s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 126s Removing obsolete dictionary files: 127s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 127s Setting up postgresql-17 (17.4-1) ... 128s Creating new PostgreSQL cluster 17/main ... 128s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 128s The files belonging to this database system will be owned by user "postgres". 128s This user must also own the server process. 128s 128s The database cluster will be initialized with locale "C.UTF-8". 128s The default database encoding has accordingly been set to "UTF8". 128s The default text search configuration will be set to "english". 128s 128s Data page checksums are disabled. 128s 128s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 128s creating subdirectories ... ok 128s selecting dynamic shared memory implementation ... posix 128s selecting default "max_connections" ... 100 128s selecting default "shared_buffers" ... 128MB 128s selecting default time zone ... Etc/UTC 128s creating configuration files ... ok 128s running bootstrap script ... ok 129s performing post-bootstrap initialization ... ok 129s syncing data to disk ... ok 132s Setting up postgresql-17-pg-qualstats (2.1.1-1) ... 132s Processing triggers for man-db (2.13.0-1) ... 133s Processing triggers for libc-bin (2.40-4ubuntu1) ... 134s autopkgtest [07:00:12]: test installcheck: [----------------------- 134s ### PostgreSQL 17 installcheck ### 135s Creating new PostgreSQL cluster 17/regress ... 138s 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' --inputdir=test --dbname=contrib_regression pg_qualstats 138s # +++ regress install-check in +++ 138s # using postmaster on localhost, port 5433 138s ok 1 - pg_qualstats 231 ms 138s 1..1 138s # All 1 tests passed. 138s Dropping cluster 17/regress ... 139s rm -f pg_qualstats.so pg_qualstats.o \ 139s pg_qualstats.bc 139s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 139s ### End 17 installcheck ### 139s autopkgtest [07:00:17]: test installcheck: -----------------------] 140s installcheck PASS 140s autopkgtest [07:00:18]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 140s autopkgtest [07:00:18]: @@@@@@@@@@@@@@@@@@@@ summary 140s installcheck PASS 158s nova [W] Using flock in prodstack6-ppc64el 158s Creating nova instance adt-plucky-ppc64el-pg-qualstats-20250222-065757-juju-7f2275-prod-proposed-migration-environment-2-284b44d9-d9d5-420a-a781-f0b661f57fc6 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 158s nova [W] Timed out waiting for 3afa462d-3d92-42ff-ba4d-8ccc0526ac5c to get deleted.