0s autopkgtest [06:36:15]: starting date and time: 2025-02-22 06:36:15+0000 0s autopkgtest [06:36:15]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:36:15]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.qoepc_o5/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade check-pgactivity --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-16.secgroup --name adt-plucky-ppc64el-check-pgactivity-20250222-063615-juju-7f2275-prod-proposed-migration-environment-20-10396333-9294-4d82-a5d3-c323fdbdee79 --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/ 79s autopkgtest [06:37:34]: testbed dpkg architecture: ppc64el 79s autopkgtest [06:37:34]: testbed apt version: 2.9.30ubuntu1 79s autopkgtest [06:37:34]: @@@@@@@@@@@@@@@@@@@@ test bed setup 79s autopkgtest [06:37:34]: testbed release detected to be: None 80s autopkgtest [06:37:35]: updating testbed package index (apt update) 80s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 81s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 81s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 81s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 81s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 81s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 81s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 81s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 81s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 81s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 81s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 81s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 82s Fetched 1276 kB in 1s (1304 kB/s) 84s Reading package lists... 84s Reading package lists... 85s Building dependency tree... 85s Reading state information... 85s Calculating upgrade... 85s Calculating upgrade... 85s The following packages will be upgraded: 85s curl libcurl3t64-gnutls libcurl4t64 86s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 86s Need to get 1221 kB of archives. 86s After this operation, 3072 B disk space will be freed. 86s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 86s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 86s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 87s Fetched 1221 kB in 1s (1907 kB/s) 87s (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.) 87s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 87s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 87s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 87s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 87s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 87s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 87s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 87s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 87s Setting up curl (8.12.1-2ubuntu1) ... 87s Processing triggers for man-db (2.13.0-1) ... 87s Processing triggers for libc-bin (2.40-4ubuntu1) ... 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s Solving dependencies... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 88s autopkgtest [06:37:43]: upgrading testbed (apt dist-upgrade and autopurge) 88s Reading package lists... 89s Building dependency tree... 89s Reading state information... 89s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 90s Entering ResolveByKeep 90s 91s Calculating upgrade... 91s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 91s Reading package lists... 91s Building dependency tree... 91s Reading state information... 92s Starting pkgProblemResolver with broken count: 0 92s Starting 2 pkgProblemResolver with broken count: 0 92s Done 92s Solving dependencies... 92s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 95s autopkgtest [06:37:50]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 95s autopkgtest [06:37:50]: @@@@@@@@@@@@@@@@@@@@ apt-source check-pgactivity 97s Get:1 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (dsc) [2065 B] 97s Get:2 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (tar) [153 kB] 97s Get:3 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (diff) [2884 B] 97s gpgv: Signature made Sun Oct 1 07:41:37 2023 UTC 97s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 97s gpgv: Can't check signature: No public key 97s dpkg-source: warning: cannot verify inline signature for ./check-pgactivity_2.7-1.dsc: no acceptable signature found 97s autopkgtest [06:37:52]: testing package check-pgactivity version 2.7-1 97s autopkgtest [06:37:52]: build not needed 98s autopkgtest [06:37:53]: test check-pgactivity: preparing testbed 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 99s Starting pkgProblemResolver with broken count: 0 99s Starting 2 pkgProblemResolver with broken count: 0 99s Done 99s The following NEW packages will be installed: 99s check-pgactivity libio-pty-perl libipc-run-perl libjson-perl libllvm20 99s libpq5 libxslt1.1 postgresql postgresql-17 postgresql-client 99s postgresql-client-17 postgresql-client-common postgresql-common 99s postgresql-common-dev ssl-cert 100s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 100s Need to get 51.5 MB of archives. 100s After this operation, 222 MB of additional disk space will be used. 100s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 100s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 100s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 100s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 100s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 100s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 100s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 100s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 100s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 100s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client all 17+273 [13.2 kB] 100s Get:11 http://ftpmaster.internal/ubuntu plucky/universe ppc64el check-pgactivity all 2.7-1 [76.8 kB] 100s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 101s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 101s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 101s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql all 17+273 [14.3 kB] 102s Preconfiguring packages ... 102s /var/cache/debconf/tmp.ci/postgresql.config.eYdiKw: 12: pg_lsclusters: not found 102s Fetched 51.5 MB in 2s (25.3 MB/s) 102s Selecting previously unselected package libjson-perl. 102s (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.) 102s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 102s Unpacking libjson-perl (4.10000-1) ... 102s Selecting previously unselected package postgresql-client-common. 102s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 102s Unpacking postgresql-client-common (273) ... 102s Selecting previously unselected package libio-pty-perl. 102s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 102s Unpacking libio-pty-perl (1:1.20-1build3) ... 102s Selecting previously unselected package libipc-run-perl. 102s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 102s Unpacking libipc-run-perl (20231003.0-2) ... 102s Selecting previously unselected package postgresql-common-dev. 102s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 102s Unpacking postgresql-common-dev (273) ... 102s Selecting previously unselected package ssl-cert. 102s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 102s Unpacking ssl-cert (1.1.3ubuntu1) ... 102s Selecting previously unselected package postgresql-common. 102s Preparing to unpack .../06-postgresql-common_273_all.deb ... 102s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 102s Unpacking postgresql-common (273) ... 102s Selecting previously unselected package libpq5:ppc64el. 102s Preparing to unpack .../07-libpq5_17.4-1_ppc64el.deb ... 102s Unpacking libpq5:ppc64el (17.4-1) ... 102s Selecting previously unselected package postgresql-client-17. 102s Preparing to unpack .../08-postgresql-client-17_17.4-1_ppc64el.deb ... 102s Unpacking postgresql-client-17 (17.4-1) ... 102s Selecting previously unselected package postgresql-client. 102s Preparing to unpack .../09-postgresql-client_17+273_all.deb ... 102s Unpacking postgresql-client (17+273) ... 102s Selecting previously unselected package check-pgactivity. 102s Preparing to unpack .../10-check-pgactivity_2.7-1_all.deb ... 102s Unpacking check-pgactivity (2.7-1) ... 102s Selecting previously unselected package libllvm20:ppc64el. 102s Preparing to unpack .../11-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 102s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 103s Selecting previously unselected package libxslt1.1:ppc64el. 103s Preparing to unpack .../12-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 103s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 103s Selecting previously unselected package postgresql-17. 103s Preparing to unpack .../13-postgresql-17_17.4-1_ppc64el.deb ... 103s Unpacking postgresql-17 (17.4-1) ... 103s Selecting previously unselected package postgresql. 103s Preparing to unpack .../14-postgresql_17+273_all.deb ... 103s Unpacking postgresql (17+273) ... 103s Setting up postgresql-client-common (273) ... 103s Setting up libio-pty-perl (1:1.20-1build3) ... 103s Setting up libpq5:ppc64el (17.4-1) ... 103s Setting up ssl-cert (1.1.3ubuntu1) ... 104s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 104s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 104s Setting up libipc-run-perl (20231003.0-2) ... 104s Setting up libjson-perl (4.10000-1) ... 104s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 104s Setting up postgresql-common-dev (273) ... 104s Setting up postgresql-client-17 (17.4-1) ... 105s 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 105s Setting up check-pgactivity (2.7-1) ... 105s Setting up postgresql-common (273) ... 105s Creating config file /etc/postgresql-common/createcluster.conf with new version 105s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 105s Removing obsolete dictionary files: 106s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 107s Setting up postgresql-17 (17.4-1) ... 108s Creating new PostgreSQL cluster 17/main ... 108s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 108s The files belonging to this database system will be owned by user "postgres". 108s This user must also own the server process. 108s 108s The database cluster will be initialized with locale "C.UTF-8". 108s The default database encoding has accordingly been set to "UTF8". 108s The default text search configuration will be set to "english". 108s 108s Data page checksums are disabled. 108s 108s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 108s creating subdirectories ... ok 108s selecting dynamic shared memory implementation ... posix 108s selecting default "max_connections" ... 100 108s selecting default "shared_buffers" ... 128MB 108s selecting default time zone ... Etc/UTC 108s creating configuration files ... ok 108s running bootstrap script ... ok 109s performing post-bootstrap initialization ... ok 109s syncing data to disk ... ok 112s Setting up postgresql-client (17+273) ... 112s Setting up postgresql (17+273) ... 112s Processing triggers for man-db (2.13.0-1) ... 113s Processing triggers for libc-bin (2.40-4ubuntu1) ... 114s autopkgtest [06:38:09]: test check-pgactivity: [----------------------- 115s + pg_virtualenv -omax_connections=10 115s Creating new PostgreSQL cluster 17/regress ... 118s + /usr/lib/nagios/plugins/check_pgactivity -w 2 -c 2 -s backends 118s + grep 'POSTGRES_BACKENDS OK: 1 connection' out 118s POSTGRES_BACKENDS OK: 1 connections on 7 | postgres=1;2;2;0;7 maximum_connections=7;;;0;7 118s + /usr/lib/nagios/plugins/check_pgactivity -w 1 -c 2 -s backends 118s + EXIT=1 118s + '[' 1 = 1 ']' 118s + grep 'POSTGRES_BACKENDS WARNING: 1 connection' out 118s POSTGRES_BACKENDS WARNING: 1 connections on 7 | postgres=1;1;2;0;7 maximum_connections=7;;;0;7 118s Dropping cluster 17/regress ... 118s + rm -f out 119s autopkgtest [06:38:14]: test check-pgactivity: -----------------------] 119s check-pgactivity PASS 119s autopkgtest [06:38:14]: test check-pgactivity: - - - - - - - - - - results - - - - - - - - - - 120s autopkgtest [06:38:15]: @@@@@@@@@@@@@@@@@@@@ summary 120s check-pgactivity PASS 124s nova [W] Using flock in prodstack6-ppc64el 124s Creating nova instance adt-plucky-ppc64el-check-pgactivity-20250222-063615-juju-7f2275-prod-proposed-migration-environment-20-10396333-9294-4d82-a5d3-c323fdbdee79 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 124s nova [W] Timed out waiting for 403d292f-65ba-48b0-8fa3-249fa369825b to get deleted.