0s autopkgtest [07:00:00]: starting date and time: 2025-02-22 07:00:00+0000 0s autopkgtest [07:00:00]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:00:00]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.niep1n00/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-wait-sampling --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-16.secgroup --name adt-plucky-ppc64el-pg-wait-sampling-20250222-070000-juju-7f2275-prod-proposed-migration-environment-15-20c242f7-fc69-4bef-bdbf-73db8421a4f7 --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/ 143s autopkgtest [07:02:23]: testbed dpkg architecture: ppc64el 143s autopkgtest [07:02:23]: testbed apt version: 2.9.30ubuntu1 144s autopkgtest [07:02:24]: @@@@@@@@@@@@@@@@@@@@ test bed setup 144s autopkgtest [07:02:24]: testbed release detected to be: None 145s autopkgtest [07:02:25]: updating testbed package index (apt update) 145s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 145s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 145s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 145s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 145s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 146s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 146s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 146s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 146s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 146s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 146s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 146s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 146s Fetched 1276 kB in 1s (1317 kB/s) 147s Reading package lists... 148s + lsb_release --codename --short 148s + RELEASE=plucky 148s + cat 148s + [ plucky != trusty ] 148s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 148s Reading package lists... 148s Building dependency tree... 148s Reading state information... 148s Calculating upgrade... 148s Calculating upgrade... 148s The following packages will be upgraded: 148s curl libcurl3t64-gnutls libcurl4t64 149s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 149s Need to get 1221 kB of archives. 149s After this operation, 3072 B disk space will be freed. 149s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 149s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 149s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 150s Fetched 1221 kB in 1s (2051 kB/s) 150s (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.) 150s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 150s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 150s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 150s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 150s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 150s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 150s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 150s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 150s Setting up curl (8.12.1-2ubuntu1) ... 150s Processing triggers for man-db (2.13.0-1) ... 151s Processing triggers for libc-bin (2.40-4ubuntu1) ... 151s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 151s + /usr/lib/apt/apt-helper analyze-pattern ?true 151s + uname -r 151s + sed s/\./\\./g 151s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 151s + apt list ?obsolete 151s + grep -v ^linux-.*6\.12\.0-15-generic.* 151s + tail -n+2 151s + cut -d/ -f1 151s + true 151s + obsolete_pkgs= 151s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 151s Reading package lists... 151s Building dependency tree... 151s Reading state information... 152s Solving dependencies... 152s + grep -q trusty /etc/lsb-release 152s + 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 152s [ ! -d /usr/share/doc/unattended-upgrades ] 152s + [ ! -d /usr/share/doc/lxd ] 152s + [ ! -d /usr/share/doc/lxd-client ] 152s + [ ! -d /usr/share/doc/snapd ] 152s + type iptables 152s + cat 152s + chmod 755 /etc/rc.local 152s + . /etc/rc.local 152s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 152s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 152s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 152s + uname -m 152s + [ ppc64le = ppc64le ] 152s + systemctl is-active keyboard-setup.service 152s + [ active = failed ] 152s + [ -d /run/systemd/system ] 152s + systemd-detect-virt --quiet --vm 152s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 152s + cat 152s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 152s + echo COMPRESS=lz4 152s autopkgtest [07:02:32]: upgrading testbed (apt dist-upgrade and autopurge) 152s Reading package lists... 152s Building dependency tree... 152s Reading state information... 153s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 153s Starting 2 pkgProblemResolver with broken count: 0 153s Done 153s Entering ResolveByKeep 153s 153s Calculating upgrade... 154s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 154s Reading package lists... 154s Building dependency tree... 154s Reading state information... 154s Starting pkgProblemResolver with broken count: 0 154s Starting 2 pkgProblemResolver with broken count: 0 154s Done 155s Solving dependencies... 155s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 157s autopkgtest [07:02:37]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 158s autopkgtest [07:02:38]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-wait-sampling 159s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-wait-sampling 1.1.7-1 (dsc) [2189 B] 159s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-wait-sampling 1.1.7-1 (tar) [17.9 kB] 159s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-wait-sampling 1.1.7-1 (diff) [2396 B] 160s gpgv: Signature made Tue Feb 11 10:22:32 2025 UTC 160s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 160s gpgv: Can't check signature: No public key 160s dpkg-source: warning: cannot verify inline signature for ./pg-wait-sampling_1.1.7-1.dsc: no acceptable signature found 160s autopkgtest [07:02:40]: testing package pg-wait-sampling version 1.1.7-1 160s autopkgtest [07:02:40]: build not needed 160s autopkgtest [07:02:40]: test installcheck: preparing testbed 161s Reading package lists... 161s Building dependency tree... 161s Reading state information... 161s Starting pkgProblemResolver with broken count: 0 161s Starting 2 pkgProblemResolver with broken count: 0 161s Done 161s The following NEW packages will be installed: 161s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 161s postgresql-17 postgresql-17-pg-wait-sampling postgresql-client-17 161s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 162s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 162s Need to get 51.4 MB of archives. 162s After this operation, 222 MB of additional disk space will be used. 162s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 162s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 162s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 162s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 162s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 162s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 162s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 162s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 163s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 163s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 163s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 163s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 163s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pg-wait-sampling ppc64el 1.1.7-1 [43.2 kB] 164s Preconfiguring packages ... 164s Fetched 51.4 MB in 2s (25.3 MB/s) 164s Selecting previously unselected package libjson-perl. 164s (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.) 164s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 164s Unpacking libjson-perl (4.10000-1) ... 164s Selecting previously unselected package postgresql-client-common. 164s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 164s Unpacking postgresql-client-common (273) ... 164s Selecting previously unselected package libio-pty-perl. 164s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 164s Unpacking libio-pty-perl (1:1.20-1build3) ... 164s Selecting previously unselected package libipc-run-perl. 164s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 164s Unpacking libipc-run-perl (20231003.0-2) ... 164s Selecting previously unselected package postgresql-common-dev. 164s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 164s Unpacking postgresql-common-dev (273) ... 164s Selecting previously unselected package ssl-cert. 164s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 164s Unpacking ssl-cert (1.1.3ubuntu1) ... 164s Selecting previously unselected package postgresql-common. 164s Preparing to unpack .../06-postgresql-common_273_all.deb ... 164s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 164s Unpacking postgresql-common (273) ... 164s Selecting previously unselected package libllvm20:ppc64el. 164s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 164s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 165s Selecting previously unselected package libpq5:ppc64el. 165s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 165s Unpacking libpq5:ppc64el (17.4-1) ... 165s Selecting previously unselected package libxslt1.1:ppc64el. 165s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 165s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 165s Selecting previously unselected package postgresql-client-17. 165s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 165s Unpacking postgresql-client-17 (17.4-1) ... 165s Selecting previously unselected package postgresql-17. 165s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 165s Unpacking postgresql-17 (17.4-1) ... 166s Selecting previously unselected package postgresql-17-pg-wait-sampling. 166s Preparing to unpack .../12-postgresql-17-pg-wait-sampling_1.1.7-1_ppc64el.deb ... 166s Unpacking postgresql-17-pg-wait-sampling (1.1.7-1) ... 166s Setting up postgresql-client-common (273) ... 166s Setting up libio-pty-perl (1:1.20-1build3) ... 166s Setting up libpq5:ppc64el (17.4-1) ... 166s Setting up ssl-cert (1.1.3ubuntu1) ... 166s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 167s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 167s Setting up libipc-run-perl (20231003.0-2) ... 167s Setting up libjson-perl (4.10000-1) ... 167s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 167s Setting up postgresql-common-dev (273) ... 167s Setting up postgresql-client-17 (17.4-1) ... 167s 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 167s Setting up postgresql-common (273) ... 168s Creating config file /etc/postgresql-common/createcluster.conf with new version 168s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 168s Removing obsolete dictionary files: 169s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 169s Setting up postgresql-17 (17.4-1) ... 170s Creating new PostgreSQL cluster 17/main ... 170s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 170s The files belonging to this database system will be owned by user "postgres". 170s This user must also own the server process. 170s 170s The database cluster will be initialized with locale "C.UTF-8". 170s The default database encoding has accordingly been set to "UTF8". 170s The default text search configuration will be set to "english". 170s 170s Data page checksums are disabled. 170s 170s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 170s creating subdirectories ... ok 170s selecting dynamic shared memory implementation ... posix 170s selecting default "max_connections" ... 100 170s selecting default "shared_buffers" ... 128MB 170s selecting default time zone ... Etc/UTC 170s creating configuration files ... ok 171s running bootstrap script ... ok 171s performing post-bootstrap initialization ... ok 171s syncing data to disk ... ok 174s Setting up postgresql-17-pg-wait-sampling (1.1.7-1) ... 174s Processing triggers for man-db (2.13.0-1) ... 176s Processing triggers for libc-bin (2.40-4ubuntu1) ... 177s autopkgtest [07:02:57]: test installcheck: [----------------------- 177s ### PostgreSQL 17 installcheck ### 177s Creating new PostgreSQL cluster 17/regress ... 180s 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' --temp-config=/usr/lib/postgresql/17/lib/pgxs/src/makefiles/../..//conf.add --dbname=contrib_regression load queries 180s # +++ regress install-check in +++ 180s # using postmaster on localhost, port 5433 180s ok 1 - load 33 ms 180s ok 2 - queries 30 ms 180s 1..2 180s # All 2 tests passed. 180s Dropping cluster 17/regress ... 181s rm -f pg_wait_sampling.so libpg_wait_sampling.a libpg_wait_sampling.pc 181s rm -f pg_wait_sampling.o collector.o pg_wait_sampling.bc collector.bc 181s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 181s ### End 17 installcheck ### 181s autopkgtest [07:03:01]: test installcheck: -----------------------] 181s autopkgtest [07:03:01]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 181s installcheck PASS 182s autopkgtest [07:03:02]: @@@@@@@@@@@@@@@@@@@@ summary 182s installcheck PASS 199s nova [W] Using flock in prodstack6-ppc64el 199s Creating nova instance adt-plucky-ppc64el-pg-wait-sampling-20250222-070000-juju-7f2275-prod-proposed-migration-environment-15-20c242f7-fc69-4bef-bdbf-73db8421a4f7 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 199s nova [W] Timed out waiting for 8d48da34-0758-4e23-afc1-457ea770b984 to get deleted.