0s autopkgtest [06:57:45]: starting date and time: 2025-02-22 06:57:45+0000 0s autopkgtest [06:57:45]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:57:45]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work._pvyxudy/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-permissions --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-20@bos03-ppc64el-18.secgroup --name adt-plucky-ppc64el-pg-permissions-20250222-065745-juju-7f2275-prod-proposed-migration-environment-20-30797158-c8a5-416f-acca-7218fe4bd3c8 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --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 [06:59:23]: testbed dpkg architecture: ppc64el 98s autopkgtest [06:59:23]: testbed apt version: 2.9.30ubuntu1 99s autopkgtest [06:59:24]: @@@@@@@@@@@@@@@@@@@@ test bed setup 99s autopkgtest [06:59:24]: testbed release detected to be: None 100s autopkgtest [06:59:25]: updating testbed package index (apt update) 100s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 100s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 100s 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] 101s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 101s Fetched 1276 kB in 1s (1411 kB/s) 102s Reading package lists... 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] 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] 104s Fetched 1221 kB in 1s (1977 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 Reading package lists... 105s Building dependency tree... 105s Reading state information... 106s Solving dependencies... 106s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 106s autopkgtest [06:59:31]: upgrading testbed (apt dist-upgrade and autopurge) 106s Reading package lists... 106s Building dependency tree... 106s 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 107s 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 109s 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:59:36]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 112s autopkgtest [06:59:37]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-permissions 113s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-permissions 1.3-3 (dsc) [2110 B] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-permissions 1.3-3 (tar) [10.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-permissions 1.3-3 (diff) [2180 B] 113s gpgv: Signature made Mon Sep 16 13:43:46 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 ./pg-permissions_1.3-3.dsc: no acceptable signature found 113s autopkgtest [06:59:38]: testing package pg-permissions version 1.3-3 114s autopkgtest [06:59:39]: build not needed 114s autopkgtest [06:59:39]: test installcheck: preparing testbed 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s 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 libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 115s postgresql-17 postgresql-17-pg-permissions postgresql-client-17 115s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 115s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 115s Need to get 51.4 MB of archives. 115s After this operation, 222 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] 115s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 115s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 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/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 116s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 116s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 117s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pg-permissions all 1.3-3 [8098 B] 117s Preconfiguring packages ... 117s Fetched 51.4 MB in 2s (25.0 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) ... 117s Selecting previously unselected package postgresql-client-common. 117s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 117s Unpacking postgresql-client-common (273) ... 117s Selecting previously unselected package libio-pty-perl. 117s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 117s Unpacking libio-pty-perl (1:1.20-1build3) ... 117s Selecting previously unselected package libipc-run-perl. 117s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 117s Unpacking libipc-run-perl (20231003.0-2) ... 117s Selecting previously unselected package postgresql-common-dev. 117s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 117s Unpacking postgresql-common-dev (273) ... 117s Selecting previously unselected package ssl-cert. 117s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 117s Unpacking ssl-cert (1.1.3ubuntu1) ... 117s Selecting previously unselected package postgresql-common. 117s Preparing to unpack .../06-postgresql-common_273_all.deb ... 117s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 117s Unpacking postgresql-common (273) ... 117s Selecting previously unselected package libllvm20:ppc64el. 117s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 117s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 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 libxslt1.1:ppc64el. 118s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 118s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 118s Selecting previously unselected package postgresql-client-17. 118s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 118s Unpacking postgresql-client-17 (17.4-1) ... 118s Selecting previously unselected package postgresql-17. 118s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 118s Unpacking postgresql-17 (17.4-1) ... 119s Selecting previously unselected package postgresql-17-pg-permissions. 119s Preparing to unpack .../12-postgresql-17-pg-permissions_1.3-3_all.deb ... 119s Unpacking postgresql-17-pg-permissions (1.3-3) ... 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 ssl-cert (1.1.3ubuntu1) ... 119s 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) ... 120s 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 120s 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: 121s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 122s Setting up postgresql-17 (17.4-1) ... 123s Creating new PostgreSQL cluster 17/main ... 123s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 123s The files belonging to this database system will be owned by user "postgres". 123s This user must also own the server process. 123s 123s The database cluster will be initialized with locale "C.UTF-8". 123s The default database encoding has accordingly been set to "UTF8". 123s The default text search configuration will be set to "english". 123s 123s Data page checksums are disabled. 123s 123s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 123s creating subdirectories ... ok 123s selecting dynamic shared memory implementation ... posix 123s selecting default "max_connections" ... 100 123s selecting default "shared_buffers" ... 128MB 123s selecting default time zone ... Etc/UTC 123s creating configuration files ... ok 123s running bootstrap script ... ok 124s performing post-bootstrap initialization ... ok 124s syncing data to disk ... ok 127s Setting up postgresql-17-pg-permissions (1.3-3) ... 127s Processing triggers for man-db (2.13.0-1) ... 128s Processing triggers for libc-bin (2.40-4ubuntu1) ... 129s autopkgtest [06:59:54]: test installcheck: [----------------------- 129s ### PostgreSQL 17 installcheck ### 129s Creating new PostgreSQL cluster 17/regress ... 132s 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 sample 132s # +++ regress install-check in +++ 133s # using postmaster on localhost, port 5433 133s ok 1 - sample 260 ms 133s 1..1 133s # All 1 tests passed. 133s Dropping cluster 17/regress ... 133s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 133s ### End 17 installcheck ### 133s autopkgtest [06:59:58]: test installcheck: -----------------------] 134s installcheck PASS 134s autopkgtest [06:59:59]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 134s autopkgtest [06:59:59]: @@@@@@@@@@@@@@@@@@@@ summary 134s installcheck PASS 139s nova [W] Using flock in prodstack6-ppc64el 139s Creating nova instance adt-plucky-ppc64el-pg-permissions-20250222-065745-juju-7f2275-prod-proposed-migration-environment-20-30797158-c8a5-416f-acca-7218fe4bd3c8 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 139s nova [W] Timed out waiting for b8e41876-8381-4a6e-b4cd-7343347b06ef to get deleted.