0s autopkgtest [06:51:05]: starting date and time: 2025-02-22 06:51:05+0000 0s autopkgtest [06:51:05]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:51:05]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.retcou_u/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade londiste-sql --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-londiste-sql-20250222-065105-juju-7f2275-prod-proposed-migration-environment-15-a03a40e4-c88e-4178-9129-6030faed0fd4 --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/ 97s autopkgtest [06:52:42]: testbed dpkg architecture: ppc64el 97s autopkgtest [06:52:42]: testbed apt version: 2.9.30ubuntu1 98s autopkgtest [06:52:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 98s autopkgtest [06:52:43]: testbed release detected to be: None 99s autopkgtest [06:52:44]: updating testbed package index (apt update) 99s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 99s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 99s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 100s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 100s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 100s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 100s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 100s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 100s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 100s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 100s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 100s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 100s Fetched 1276 kB in 1s (1335 kB/s) 101s Reading package lists... 102s + lsb_release --codename --short 102s + RELEASE=plucky 102s + cat 102s + [ plucky != trusty ] 102s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 102s Reading package lists... 102s Building dependency tree... 102s Reading state information... 103s Calculating upgrade... 103s Calculating upgrade... 103s The following packages will be upgraded: 103s curl libcurl3t64-gnutls libcurl4t64 103s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s Need to get 1221 kB of archives. 103s After this operation, 3072 B disk space will be freed. 103s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 103s 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] 104s Fetched 1221 kB in 1s (2047 kB/s) 104s (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.) 104s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 104s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 104s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 104s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 104s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 104s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 104s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 104s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 104s Setting up curl (8.12.1-2ubuntu1) ... 104s Processing triggers for man-db (2.13.0-1) ... 105s Processing triggers for libc-bin (2.40-4ubuntu1) ... 105s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 105s + /usr/lib/apt/apt-helper analyze-pattern ?true 105s + uname -r 105s + sed s/\./\\./g 105s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 105s + apt list ?obsolete 105s + tail -n+2 105s + + grep -v ^linux-.*6\.12\.0-15-generic.* 105s cut -d/ -f1 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... 106s Solving dependencies... 106s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 106s + grep -q trusty /etc/lsb-release 106s + [ ! -d /usr/share/doc/unattended-upgrades ] 106s + [ ! -d /usr/share/doc/lxd ] 106s + [ ! -d /usr/share/doc/lxd-client ] 106s + [ ! -d /usr/share/doc/snapd ] 106s + type iptables 106s + cat 106s + chmod 755 /etc/rc.local 106s + . /etc/rc.local 106s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 106s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 106s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 106s + uname -m 106s + [ ppc64le = ppc64le ] 106s + systemctl is-active keyboard-setup.service 106s + [ active = failed ] 106s + [ -d /run/systemd/system ] 106s + systemd-detect-virt --quiet --vm 106s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 106s + cat 106s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 106s + echo COMPRESS=lz4 106s autopkgtest [06:52:51]: upgrading testbed (apt dist-upgrade and autopurge) 106s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 107s Starting 2 pkgProblemResolver with broken count: 0 107s Done 107s Entering ResolveByKeep 108s 108s Calculating upgrade... 108s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s Reading package lists... 108s Building dependency tree... 108s Reading state information... 108s Starting pkgProblemResolver with broken count: 0 108s Starting 2 pkgProblemResolver with broken count: 0 109s Done 109s Solving dependencies... 109s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s autopkgtest [06:52:56]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 112s autopkgtest [06:52:57]: @@@@@@@@@@@@@@@@@@@@ apt-source londiste-sql 113s Get:1 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (dsc) [2119 B] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (tar) [46.2 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (diff) [2152 B] 113s gpgv: Signature made Thu Sep 19 11:35:28 2024 UTC 113s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 113s gpgv: Can't check signature: No public key 113s dpkg-source: warning: cannot verify inline signature for ./londiste-sql_3.8-6.dsc: no acceptable signature found 113s autopkgtest [06:52:58]: testing package londiste-sql version 3.8-6 114s autopkgtest [06:52:59]: build not needed 114s autopkgtest [06:52:59]: test installcheck: preparing testbed 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 115s Starting pkgProblemResolver with broken count: 0 115s Starting 2 pkgProblemResolver with broken count: 0 115s Done 115s The following NEW packages will be installed: 115s libevent-2.1-7t64 libio-pty-perl libipc-run-perl libjson-perl libllvm20 115s libpq5 libxslt1.1 pgqd postgresql-17 postgresql-17-londiste-sql 115s postgresql-17-pgq-node postgresql-17-pgq3 postgresql-client-17 115s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 115s 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. 115s Need to get 51.8 MB of archives. 115s After this operation, 226 MB of additional disk space will be used. 115s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 115s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 115s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 115s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 115s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 115s 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 libevent-2.1-7t64 ppc64el 2.1.12-stable-10 [172 kB] 116s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 116s Get:10 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgqd ppc64el 3.5-2 [33.6 kB] 116s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 116s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 116s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 116s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 117s Get:15 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgq3 ppc64el 3.5-4 [137 kB] 117s Get:16 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgq-node all 3.5-7 [12.9 kB] 117s Get:17 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-londiste-sql all 3.8-6 [20.8 kB] 117s Preconfiguring packages ... 117s Fetched 51.8 MB in 2s (25.6 MB/s) 117s Selecting previously unselected package libjson-perl. 117s (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.) 117s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 117s Unpacking libjson-perl (4.10000-1) ... 118s Selecting previously unselected package postgresql-client-common. 118s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 118s Unpacking postgresql-client-common (273) ... 118s Selecting previously unselected package libio-pty-perl. 118s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 118s Unpacking libio-pty-perl (1:1.20-1build3) ... 118s Selecting previously unselected package libipc-run-perl. 118s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 118s Unpacking libipc-run-perl (20231003.0-2) ... 118s Selecting previously unselected package postgresql-common-dev. 118s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 118s Unpacking postgresql-common-dev (273) ... 118s Selecting previously unselected package ssl-cert. 118s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 118s Unpacking ssl-cert (1.1.3ubuntu1) ... 118s Selecting previously unselected package postgresql-common. 118s Preparing to unpack .../06-postgresql-common_273_all.deb ... 118s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 118s Unpacking postgresql-common (273) ... 118s Selecting previously unselected package libevent-2.1-7t64:ppc64el. 118s Preparing to unpack .../07-libevent-2.1-7t64_2.1.12-stable-10_ppc64el.deb ... 118s Unpacking libevent-2.1-7t64:ppc64el (2.1.12-stable-10) ... 118s Selecting previously unselected package libpq5:ppc64el. 118s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 118s Unpacking libpq5:ppc64el (17.4-1) ... 118s Selecting previously unselected package pgqd. 118s Preparing to unpack .../09-pgqd_3.5-2_ppc64el.deb ... 118s Unpacking pgqd (3.5-2) ... 118s Selecting previously unselected package libllvm20:ppc64el. 118s Preparing to unpack .../10-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 118s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 119s Selecting previously unselected package libxslt1.1:ppc64el. 119s Preparing to unpack .../11-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 .../12-postgresql-client-17_17.4-1_ppc64el.deb ... 119s Unpacking postgresql-client-17 (17.4-1) ... 119s Selecting previously unselected package postgresql-17. 119s Preparing to unpack .../13-postgresql-17_17.4-1_ppc64el.deb ... 119s Unpacking postgresql-17 (17.4-1) ... 119s Selecting previously unselected package postgresql-17-pgq3. 119s Preparing to unpack .../14-postgresql-17-pgq3_3.5-4_ppc64el.deb ... 119s Unpacking postgresql-17-pgq3 (3.5-4) ... 119s Selecting previously unselected package postgresql-17-pgq-node. 119s Preparing to unpack .../15-postgresql-17-pgq-node_3.5-7_all.deb ... 119s Unpacking postgresql-17-pgq-node (3.5-7) ... 119s Selecting previously unselected package postgresql-17-londiste-sql. 119s Preparing to unpack .../16-postgresql-17-londiste-sql_3.8-6_all.deb ... 119s Unpacking postgresql-17-londiste-sql (3.8-6) ... 119s Setting up postgresql-client-common (273) ... 119s Setting up libio-pty-perl (1:1.20-1build3) ... 119s Setting up libpq5:ppc64el (17.4-1) ... 119s Setting up libevent-2.1-7t64:ppc64el (2.1.12-stable-10) ... 119s Setting up ssl-cert (1.1.3ubuntu1) ... 120s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 120s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 120s Setting up libipc-run-perl (20231003.0-2) ... 120s Setting up libjson-perl (4.10000-1) ... 120s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 120s Setting up postgresql-common-dev (273) ... 120s 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) ... 121s Creating config file /etc/postgresql-common/createcluster.conf with new version 121s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 121s Removing obsolete dictionary files: 122s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 123s Setting up pgqd (3.5-2) ... 123s Created symlink '/etc/systemd/system/multi-user.target.wants/pgqd.service' → '/usr/lib/systemd/system/pgqd.service'. 124s Setting up postgresql-17 (17.4-1) ... 125s Creating new PostgreSQL cluster 17/main ... 125s /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 126s performing post-bootstrap initialization ... ok 126s syncing data to disk ... ok 129s Setting up postgresql-17-pgq3 (3.5-4) ... 129s Setting up postgresql-17-pgq-node (3.5-7) ... 129s Setting up postgresql-17-londiste-sql (3.8-6) ... 129s Processing triggers for man-db (2.13.0-1) ... 130s Processing triggers for libc-bin (2.40-4ubuntu1) ... 131s autopkgtest [06:53:16]: 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=regression --dbname=regression init_ext londiste_provider londiste_subscriber londiste_fkeys londiste_execute londiste_seqs londiste_merge londiste_leaf londiste_create_part londiste_merge_fkeys 134s # +++ regress install-check in +++ 134s # using postmaster on localhost, port 5433 135s ok 1 - init_ext 142 ms 135s ok 2 - londiste_provider 104 ms 135s ok 3 - londiste_subscriber 69 ms 135s ok 4 - londiste_fkeys 91 ms 135s ok 5 - londiste_execute 32 ms 135s ok 6 - londiste_seqs 104 ms 135s ok 7 - londiste_merge 443 ms 136s ok 8 - londiste_leaf 66 ms 136s ok 9 - londiste_create_part 60 ms 136s ok 10 - londiste_merge_fkeys 91 ms 136s 1..10 136s # All 10 tests passed. 136s Dropping cluster 17/regress ... 136s rm -rf docs/html docs/Data docs/sql 136s rm -f londiste--3.8.sql londiste--unpackaged--3.8.sql londiste--3.2--3.8.sql londiste--3.2.3--3.8.sql londiste--3.2.4--3.8.sql londiste--3.4--3.8.sql londiste--3.4.1--3.8.sql londiste--3.5--3.8.sql londiste--3.6--3.8.sql londiste--3.7--3.8.sql 136s rm -rf londiste.sql londiste.upgrade.sql structure/newgrants_londiste.sql structure/oldgrants_londiste.sql test.dump 136s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 136s ### End 17 installcheck ### 136s autopkgtest [06:53:21]: test installcheck: -----------------------] 137s autopkgtest [06:53:22]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 137s installcheck PASS 137s autopkgtest [06:53:22]: @@@@@@@@@@@@@@@@@@@@ summary 137s installcheck PASS 155s nova [W] Using flock in prodstack6-ppc64el 155s Creating nova instance adt-plucky-ppc64el-londiste-sql-20250222-065105-juju-7f2275-prod-proposed-migration-environment-15-a03a40e4-c88e-4178-9129-6030faed0fd4 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 155s nova [W] Timed out waiting for b50f036d-9837-41f8-92a3-9292d34d3e7b to get deleted.