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