0s autopkgtest [06:40:43]: starting date and time: 2025-02-22 06:40:43+0000 0s autopkgtest [06:40:43]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:40:43]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.glz2cwiz/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade first-last-agg --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-15@bos03-ppc64el-14.secgroup --name adt-plucky-ppc64el-first-last-agg-20250222-064043-juju-7f2275-prod-proposed-migration-environment-15-3e35788a-6be2-40da-8ccd-50f486cdaae5 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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/ 106s autopkgtest [06:42:29]: testbed dpkg architecture: ppc64el 106s autopkgtest [06:42:29]: testbed apt version: 2.9.30ubuntu1 106s autopkgtest [06:42:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 107s autopkgtest [06:42:30]: testbed release detected to be: None 107s autopkgtest [06:42:30]: updating testbed package index (apt update) 108s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 108s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 108s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 108s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 108s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 108s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 108s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 108s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 108s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 108s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 108s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 108s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 109s Fetched 1276 kB in 1s (1338 kB/s) 110s Reading package lists... 110s + lsb_release --codename --short 110s + RELEASE=plucky 110s + cat 110s + [ plucky != trusty ] 110s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 110s Reading package lists... 111s Building dependency tree... 111s Reading state information... 111s Calculating upgrade... 111s Calculating upgrade... 111s The following packages will be upgraded: 111s curl libcurl3t64-gnutls libcurl4t64 111s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s Need to get 1221 kB of archives. 111s After this operation, 3072 B disk space will be freed. 111s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 112s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 112s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 112s Fetched 1221 kB in 1s (1974 kB/s) 112s (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.) 112s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 112s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 112s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 112s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 112s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 112s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 112s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 112s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 112s Setting up curl (8.12.1-2ubuntu1) ... 112s Processing triggers for man-db (2.13.0-1) ... 113s Processing triggers for libc-bin (2.40-4ubuntu1) ... 113s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 113s + /usr/lib/apt/apt-helper analyze-pattern ?true 113s + + sed s/\./\\./g 113s uname -r 113s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 113s + apt list ?obsolete 113s + tail -n+2 113s + + grep -v ^linux-.*6\.12\.0-15-generic.* 113s cut -d/ -f1 114s + true 114s + obsolete_pkgs= 114s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s Solving dependencies... 114s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 114s + grep -q trusty /etc/lsb-release 114s + [ ! -d /usr/share/doc/unattended-upgrades ] 114s + [ ! -d /usr/share/doc/lxd ] 114s + [ ! -d /usr/share/doc/lxd-client ] 114s + [ ! -d /usr/share/doc/snapd ] 114s + type iptables 114s + cat 114s + chmod 755 /etc/rc.local 114s + . /etc/rc.local 114s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 114s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 114s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 114s + uname -m 114s + [ ppc64le = ppc64le ] 114s + systemctl is-active keyboard-setup.service 114s + [ active = failed ] 114s + [ -d /run/systemd/system ] 114s + systemd-detect-virt --quiet --vm 114s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 114s + cat 114s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 114s + echo COMPRESS=lz4 114s autopkgtest [06:42:37]: upgrading testbed (apt dist-upgrade and autopurge) 114s Reading package lists... 115s Building dependency tree... 115s Reading state information... 115s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 115s Starting 2 pkgProblemResolver with broken count: 0 115s Done 115s Entering ResolveByKeep 116s 116s Calculating upgrade... 116s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 116s Reading package lists... 116s Building dependency tree... 116s Reading state information... 117s Starting pkgProblemResolver with broken count: 0 117s Starting 2 pkgProblemResolver with broken count: 0 117s Done 117s Solving dependencies... 117s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 120s autopkgtest [06:42:43]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 120s autopkgtest [06:42:43]: @@@@@@@@@@@@@@@@@@@@ apt-source first-last-agg 122s Get:1 http://ftpmaster.internal/ubuntu plucky/universe first-last-agg 0.1.4-4-gd63ea3b-8 (dsc) [2245 B] 122s Get:2 http://ftpmaster.internal/ubuntu plucky/universe first-last-agg 0.1.4-4-gd63ea3b-8 (tar) [3480 B] 122s Get:3 http://ftpmaster.internal/ubuntu plucky/universe first-last-agg 0.1.4-4-gd63ea3b-8 (diff) [2520 B] 122s gpgv: Signature made Wed Sep 11 15:43:26 2024 UTC 122s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 122s gpgv: Can't check signature: No public key 122s dpkg-source: warning: cannot verify inline signature for ./first-last-agg_0.1.4-4-gd63ea3b-8.dsc: no acceptable signature found 122s autopkgtest [06:42:45]: testing package first-last-agg version 0.1.4-4-gd63ea3b-8 122s autopkgtest [06:42:45]: build not needed 123s autopkgtest [06:42:46]: test installcheck: preparing testbed 123s Reading package lists... 123s Building dependency tree... 123s Reading state information... 123s Starting pkgProblemResolver with broken count: 0 123s Starting 2 pkgProblemResolver with broken count: 0 123s Done 124s The following NEW packages will be installed: 124s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 124s postgresql-17 postgresql-17-first-last-agg postgresql-client-17 124s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 124s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 124s Need to get 51.4 MB of archives. 124s After this operation, 222 MB of additional disk space will be used. 124s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 124s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 124s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 124s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 124s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 124s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 124s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 124s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 125s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 125s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 125s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 125s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 126s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-first-last-agg ppc64el 0.1.4-4-gd63ea3b-8 [9458 B] 126s Preconfiguring packages ... 126s Fetched 51.4 MB in 2s (26.4 MB/s) 126s Selecting previously unselected package libjson-perl. 126s (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.) 126s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 126s Unpacking libjson-perl (4.10000-1) ... 126s Selecting previously unselected package postgresql-client-common. 126s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 126s Unpacking postgresql-client-common (273) ... 126s Selecting previously unselected package libio-pty-perl. 126s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 126s Unpacking libio-pty-perl (1:1.20-1build3) ... 126s Selecting previously unselected package libipc-run-perl. 126s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 126s Unpacking libipc-run-perl (20231003.0-2) ... 126s Selecting previously unselected package postgresql-common-dev. 126s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 126s Unpacking postgresql-common-dev (273) ... 126s Selecting previously unselected package ssl-cert. 126s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 126s Unpacking ssl-cert (1.1.3ubuntu1) ... 126s Selecting previously unselected package postgresql-common. 126s Preparing to unpack .../06-postgresql-common_273_all.deb ... 126s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 126s Unpacking postgresql-common (273) ... 126s Selecting previously unselected package libllvm20:ppc64el. 126s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 126s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 127s Selecting previously unselected package libpq5:ppc64el. 127s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 127s Unpacking libpq5:ppc64el (17.4-1) ... 127s Selecting previously unselected package libxslt1.1:ppc64el. 127s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 127s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 127s Selecting previously unselected package postgresql-client-17. 127s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 127s Unpacking postgresql-client-17 (17.4-1) ... 127s Selecting previously unselected package postgresql-17. 127s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 127s Unpacking postgresql-17 (17.4-1) ... 128s Selecting previously unselected package postgresql-17-first-last-agg. 128s Preparing to unpack .../12-postgresql-17-first-last-agg_0.1.4-4-gd63ea3b-8_ppc64el.deb ... 128s Unpacking postgresql-17-first-last-agg (0.1.4-4-gd63ea3b-8) ... 128s Setting up postgresql-client-common (273) ... 128s Setting up libio-pty-perl (1:1.20-1build3) ... 128s Setting up libpq5:ppc64el (17.4-1) ... 128s Setting up ssl-cert (1.1.3ubuntu1) ... 128s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 129s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 129s Setting up libipc-run-perl (20231003.0-2) ... 129s Setting up libjson-perl (4.10000-1) ... 129s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 129s Setting up postgresql-common-dev (273) ... 129s Setting up postgresql-client-17 (17.4-1) ... 129s 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 129s Setting up postgresql-common (273) ... 130s Creating config file /etc/postgresql-common/createcluster.conf with new version 130s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 130s Removing obsolete dictionary files: 131s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 132s Setting up postgresql-17 (17.4-1) ... 132s Creating new PostgreSQL cluster 17/main ... 132s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 133s The files belonging to this database system will be owned by user "postgres". 133s This user must also own the server process. 133s 133s The database cluster will be initialized with locale "C.UTF-8". 133s The default database encoding has accordingly been set to "UTF8". 133s The default text search configuration will be set to "english". 133s 133s Data page checksums are disabled. 133s 133s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 133s creating subdirectories ... ok 133s selecting dynamic shared memory implementation ... posix 133s selecting default "max_connections" ... 100 133s selecting default "shared_buffers" ... 128MB 133s selecting default time zone ... Etc/UTC 133s creating configuration files ... ok 133s running bootstrap script ... ok 133s performing post-bootstrap initialization ... ok 133s syncing data to disk ... ok 136s Setting up postgresql-17-first-last-agg (0.1.4-4-gd63ea3b-8) ... 136s Processing triggers for man-db (2.13.0-1) ... 138s Processing triggers for libc-bin (2.40-4ubuntu1) ... 139s autopkgtest [06:43:02]: test installcheck: [----------------------- 139s ### PostgreSQL 17 installcheck ### 139s Creating new PostgreSQL cluster 17/regress ... 142s 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 agg 142s # +++ regress install-check in +++ 142s # using postmaster on localhost, port 5433 142s ok 1 - agg 49 ms 142s 1..1 142s # All 1 tests passed. 142s Dropping cluster 17/regress ... 143s rm -f src/first_last_agg.so src/first_last_agg.o \ 143s src/first_last_agg.bc 143s rm -f sql/first_last_agg--0.1.4.sql 143s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 143s ### End 17 installcheck ### 143s autopkgtest [06:43:06]: test installcheck: -----------------------] 143s installcheck PASS 143s autopkgtest [06:43:06]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 144s autopkgtest [06:43:07]: @@@@@@@@@@@@@@@@@@@@ summary 144s installcheck PASS 148s nova [W] Using flock in prodstack6-ppc64el 148s Creating nova instance adt-plucky-ppc64el-first-last-agg-20250222-064043-juju-7f2275-prod-proposed-migration-environment-15-3e35788a-6be2-40da-8ccd-50f486cdaae5 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 148s nova [W] Timed out waiting for b064c1dc-6cff-48ff-a164-b777209c9546 to get deleted.