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