0s autopkgtest [07:04:15]: starting date and time: 2025-02-22 07:04:15+0000 0s autopkgtest [07:04:15]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:04:15]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.be_cv02c/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgtt --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-39.secgroup --name adt-plucky-ppc64el-pgtt-20250222-070414-juju-7f2275-prod-proposed-migration-environment-2-d52e393c-0664-42da-8d07-59b06d7d356f --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/ 117s autopkgtest [07:06:12]: testbed dpkg architecture: ppc64el 117s autopkgtest [07:06:12]: testbed apt version: 2.9.30ubuntu1 117s autopkgtest [07:06:12]: @@@@@@@@@@@@@@@@@@@@ test bed setup 118s autopkgtest [07:06:13]: testbed release detected to be: None 118s autopkgtest [07:06:13]: updating testbed package index (apt update) 119s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 119s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 119s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 119s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 119s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 119s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 119s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 119s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 119s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 119s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 119s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 119s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 120s Fetched 1276 kB in 1s (1385 kB/s) 121s Reading package lists... 121s Reading package lists... 122s Building dependency tree... 122s Reading state information... 122s Calculating upgrade... 122s Calculating upgrade... 122s The following packages will be upgraded: 122s curl libcurl3t64-gnutls libcurl4t64 122s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 122s Need to get 1221 kB of archives. 122s After this operation, 3072 B disk space will be freed. 122s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 123s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 123s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 123s Fetched 1221 kB in 1s (2017 kB/s) 123s (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.) 123s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 123s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 123s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 123s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 123s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 123s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 123s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 123s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 123s Setting up curl (8.12.1-2ubuntu1) ... 123s Processing triggers for man-db (2.13.0-1) ... 124s Processing triggers for libc-bin (2.40-4ubuntu1) ... 124s Reading package lists... 124s Building dependency tree... 124s Reading state information... 125s Solving dependencies... 125s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s autopkgtest [07:06:20]: upgrading testbed (apt dist-upgrade and autopurge) 125s Reading package lists... 125s Building dependency tree... 125s Reading state information... 126s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 126s Starting 2 pkgProblemResolver with broken count: 0 126s Done 127s Entering ResolveByKeep 127s 127s Calculating upgrade... 128s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 128s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 129s Solving dependencies... 129s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 132s autopkgtest [07:06:27]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 132s autopkgtest [07:06:27]: @@@@@@@@@@@@@@@@@@@@ apt-source pgtt 134s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgtt 4.0-2 (dsc) [2027 B] 134s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgtt 4.0-2 (tar) [37.4 kB] 134s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgtt 4.0-2 (diff) [2828 B] 134s gpgv: Signature made Sat Sep 14 18:56:30 2024 UTC 134s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 134s gpgv: Can't check signature: No public key 134s dpkg-source: warning: cannot verify inline signature for ./pgtt_4.0-2.dsc: no acceptable signature found 134s autopkgtest [07:06:29]: testing package pgtt version 4.0-2 134s autopkgtest [07:06:29]: build not needed 135s autopkgtest [07:06:30]: test installcheck: preparing testbed 135s Reading package lists... 135s Building dependency tree... 135s Reading state information... 136s Starting pkgProblemResolver with broken count: 0 136s Starting 2 pkgProblemResolver with broken count: 0 136s Done 136s The following NEW packages will be installed: 136s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 136s postgresql-17 postgresql-17-pgtt postgresql-client-17 136s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 136s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 136s Need to get 51.5 MB of archives. 136s After this operation, 222 MB of additional disk space will be used. 136s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 137s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 137s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 137s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 137s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 137s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 137s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 137s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 138s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 138s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 138s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 138s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 138s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgtt ppc64el 4.0-2 [57.5 kB] 138s Preconfiguring packages ... 139s Fetched 51.5 MB in 2s (27.5 MB/s) 139s Selecting previously unselected package libjson-perl. 139s (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.) 139s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 139s Unpacking libjson-perl (4.10000-1) ... 139s Selecting previously unselected package postgresql-client-common. 139s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 139s Unpacking postgresql-client-common (273) ... 139s Selecting previously unselected package libio-pty-perl. 139s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 139s Unpacking libio-pty-perl (1:1.20-1build3) ... 139s Selecting previously unselected package libipc-run-perl. 139s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 139s Unpacking libipc-run-perl (20231003.0-2) ... 139s Selecting previously unselected package postgresql-common-dev. 139s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 139s Unpacking postgresql-common-dev (273) ... 139s Selecting previously unselected package ssl-cert. 139s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 139s Unpacking ssl-cert (1.1.3ubuntu1) ... 139s Selecting previously unselected package postgresql-common. 139s Preparing to unpack .../06-postgresql-common_273_all.deb ... 139s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 139s Unpacking postgresql-common (273) ... 139s Selecting previously unselected package libllvm20:ppc64el. 139s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 139s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 140s Selecting previously unselected package libpq5:ppc64el. 140s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 140s Unpacking libpq5:ppc64el (17.4-1) ... 140s Selecting previously unselected package libxslt1.1:ppc64el. 140s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 140s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 140s Selecting previously unselected package postgresql-client-17. 140s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 140s Unpacking postgresql-client-17 (17.4-1) ... 140s Selecting previously unselected package postgresql-17. 140s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 140s Unpacking postgresql-17 (17.4-1) ... 140s Selecting previously unselected package postgresql-17-pgtt. 140s Preparing to unpack .../12-postgresql-17-pgtt_4.0-2_ppc64el.deb ... 140s Unpacking postgresql-17-pgtt (4.0-2) ... 140s Setting up postgresql-client-common (273) ... 140s Setting up libio-pty-perl (1:1.20-1build3) ... 140s Setting up libpq5:ppc64el (17.4-1) ... 140s Setting up ssl-cert (1.1.3ubuntu1) ... 141s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 141s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 141s Setting up libipc-run-perl (20231003.0-2) ... 141s Setting up libjson-perl (4.10000-1) ... 141s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 141s Setting up postgresql-common-dev (273) ... 141s Setting up postgresql-client-17 (17.4-1) ... 142s 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 142s Setting up postgresql-common (273) ... 142s Creating config file /etc/postgresql-common/createcluster.conf with new version 142s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 142s Removing obsolete dictionary files: 143s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 143s Setting up postgresql-17 (17.4-1) ... 144s Creating new PostgreSQL cluster 17/main ... 144s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 144s The files belonging to this database system will be owned by user "postgres". 144s This user must also own the server process. 144s 144s The database cluster will be initialized with locale "C.UTF-8". 144s The default database encoding has accordingly been set to "UTF8". 144s The default text search configuration will be set to "english". 144s 144s Data page checksums are disabled. 144s 144s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 144s creating subdirectories ... ok 144s selecting dynamic shared memory implementation ... posix 144s selecting default "max_connections" ... 100 144s selecting default "shared_buffers" ... 128MB 144s selecting default time zone ... Etc/UTC 144s creating configuration files ... ok 145s running bootstrap script ... ok 145s performing post-bootstrap initialization ... ok 145s syncing data to disk ... ok 148s Setting up postgresql-17-pgtt (4.0-2) ... 148s Processing triggers for man-db (2.13.0-1) ... 150s Processing triggers for libc-bin (2.40-4ubuntu1) ... 151s autopkgtest [07:06:46]: test installcheck: [----------------------- 151s ### PostgreSQL 17 installcheck ### 151s Creating new PostgreSQL cluster 17/regress ... 154s 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 00_init 01_oncommitdelete 02_oncommitpreserve 03_createontruncate 04_rename 05_useindex 06_createas 07_createlike 08_plplgsql 09_transaction 10_foreignkey 11_after_error 12_droptable 154s # +++ regress install-check in +++ 154s # using postmaster on localhost, port 5433 154s ok 1 - 00_init 42 ms 155s ok 2 - 01_oncommitdelete 1085 ms 155s ok 3 - 02_oncommitpreserve 69 ms 155s ok 4 - 03_createontruncate 118 ms 155s ok 5 - 04_rename 87 ms 156s ok 6 - 05_useindex 110 ms 156s ok 7 - 06_createas 48 ms 156s ok 8 - 07_createlike 70 ms 157s ok 9 - 08_plplgsql 1175 ms 157s ok 10 - 09_transaction 121 ms 157s ok 11 - 10_foreignkey 90 ms 158s ok 12 - 11_after_error 1111 ms 158s ok 13 - 12_droptable 48 ms 158s 1..13 158s # All 13 tests passed. 158s Dropping cluster 17/regress ... 159s rm -f pgtt.so pgtt.o \ 159s pgtt.bc 159s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 159s ### End 17 installcheck ### 159s autopkgtest [07:06:54]: test installcheck: -----------------------] 159s autopkgtest [07:06:54]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 159s installcheck PASS 160s autopkgtest [07:06:55]: @@@@@@@@@@@@@@@@@@@@ summary 160s installcheck PASS 164s nova [W] Using flock in prodstack6-ppc64el 164s Creating nova instance adt-plucky-ppc64el-pgtt-20250222-070414-juju-7f2275-prod-proposed-migration-environment-2-d52e393c-0664-42da-8d07-59b06d7d356f from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 164s nova [W] Timed out waiting for d1348975-3a75-4d80-8ea5-76e897db527b to get deleted.