0s autopkgtest [07:04:02]: starting date and time: 2025-02-22 07:04:02+0000 0s autopkgtest [07:04:02]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:04:02]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.rni64jxh/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgstat --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-15.secgroup --name adt-plucky-ppc64el-pgstat-20250222-070402-juju-7f2275-prod-proposed-migration-environment-2-c61a5874-68d7-4d7e-a49e-4391ee463933 --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/ 120s autopkgtest [07:06:02]: testbed dpkg architecture: ppc64el 120s autopkgtest [07:06:02]: testbed apt version: 2.9.30ubuntu1 120s autopkgtest [07:06:02]: @@@@@@@@@@@@@@@@@@@@ test bed setup 121s autopkgtest [07:06:03]: testbed release detected to be: None 121s autopkgtest [07:06:03]: updating testbed package index (apt update) 122s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 122s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 122s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 122s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 122s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 122s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 122s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 122s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 122s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 122s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 122s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 122s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 123s Fetched 1276 kB in 1s (1440 kB/s) 123s Reading package lists... 124s Reading package lists... 124s Building dependency tree... 124s Reading state information... 124s Calculating upgrade... 124s Calculating upgrade... 125s The following packages will be upgraded: 125s curl libcurl3t64-gnutls libcurl4t64 125s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s Need to get 1221 kB of archives. 125s After this operation, 3072 B disk space will be freed. 125s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 125s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 125s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 126s Fetched 1221 kB in 1s (2043 kB/s) 126s (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.) 126s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 126s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 126s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 126s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 126s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 126s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 126s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 126s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 126s Setting up curl (8.12.1-2ubuntu1) ... 126s Processing triggers for man-db (2.13.0-1) ... 127s Processing triggers for libc-bin (2.40-4ubuntu1) ... 127s Reading package lists... 127s Building dependency tree... 127s Reading state information... 127s Solving dependencies... 127s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 127s autopkgtest [07:06:09]: upgrading testbed (apt dist-upgrade and autopurge) 127s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 128s Entering ResolveByKeep 129s 129s Calculating upgrade... 129s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 129s Reading package lists... 129s Building dependency tree... 129s Reading state information... 130s Starting pkgProblemResolver with broken count: 0 130s Starting 2 pkgProblemResolver with broken count: 0 130s Done 130s Solving dependencies... 130s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s autopkgtest [07:06:15]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 133s autopkgtest [07:06:15]: @@@@@@@@@@@@@@@@@@@@ apt-source pgstat 134s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgstat 1.4.0-1 (dsc) [1993 B] 134s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgstat 1.4.0-1 (tar) [55.3 kB] 134s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgstat 1.4.0-1 (diff) [2900 B] 135s gpgv: Signature made Tue Oct 15 12:50:06 2024 UTC 135s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 135s gpgv: Can't check signature: No public key 135s dpkg-source: warning: cannot verify inline signature for ./pgstat_1.4.0-1.dsc: no acceptable signature found 135s autopkgtest [07:06:17]: testing package pgstat version 1.4.0-1 135s autopkgtest [07:06:17]: build not needed 135s autopkgtest [07:06:17]: test pgstat: preparing testbed 135s Reading package lists... 136s Building dependency tree... 136s 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 pgstat postgresql postgresql-17 postgresql-client-17 136s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 136s 0 upgraded, 14 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/universe ppc64el pgstat ppc64el 1.4.0-1 [50.5 kB] 138s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 138s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 139s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql all 17+273 [14.3 kB] 139s Preconfiguring packages ... 139s /var/cache/debconf/tmp.ci/postgresql.config.FHhoIC: 12: pg_lsclusters: not found 139s Fetched 51.5 MB in 2s (23.1 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 pgstat. 140s Preparing to unpack .../10-pgstat_1.4.0-1_ppc64el.deb ... 140s Unpacking pgstat (1.4.0-1) ... 140s Selecting previously unselected package postgresql-client-17. 140s Preparing to unpack .../11-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 .../12-postgresql-17_17.4-1_ppc64el.deb ... 140s Unpacking postgresql-17 (17.4-1) ... 140s Selecting previously unselected package postgresql. 140s Preparing to unpack .../13-postgresql_17+273_all.deb ... 140s Unpacking postgresql (17+273) ... 140s Setting up postgresql-client-common (273) ... 141s Setting up libio-pty-perl (1:1.20-1build3) ... 141s Setting up libpq5:ppc64el (17.4-1) ... 141s Setting up pgstat (1.4.0-1) ... 141s 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 144s running bootstrap script ... ok 145s performing post-bootstrap initialization ... ok 145s syncing data to disk ... ok 148s Setting up postgresql (17+273) ... 148s Processing triggers for man-db (2.13.0-1) ... 149s Processing triggers for libc-bin (2.40-4ubuntu1) ... 151s autopkgtest [07:06:33]: test pgstat: [----------------------- 151s Creating new PostgreSQL cluster 17/regress ... 154s + pgstat 1 5 158s -------------- buffers ------------- 158s clean alloc maxwritten 158s 0 93 0 158s 0 120 0 158s 0 0 0 158s 0 0 0 158s 0 0 0 158s + cat pgstat.out 158s + grep maxwritten pgstat.out 158s clean alloc maxwritten 158s + grep '0.*0.*0' pgstat.out 158s 0 120 0 158s 0 0 0 158s 0 0 0 158s 0 0 0 158s Dropping cluster 17/regress ... 159s autopkgtest [07:06:41]: test pgstat: -----------------------] 159s autopkgtest [07:06:41]: test pgstat: - - - - - - - - - - results - - - - - - - - - - 159s pgstat PASS 160s autopkgtest [07:06:42]: @@@@@@@@@@@@@@@@@@@@ summary 160s pgstat PASS 164s nova [W] Using flock in prodstack6-ppc64el 164s Creating nova instance adt-plucky-ppc64el-pgstat-20250222-070402-juju-7f2275-prod-proposed-migration-environment-2-c61a5874-68d7-4d7e-a49e-4391ee463933 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 164s nova [W] Timed out waiting for e188d16a-1ade-40f7-adee-610dba937f6f to get deleted.