0s autopkgtest [06:36:58]: starting date and time: 2025-02-22 06:36:58+0000 0s autopkgtest [06:36:58]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:36:58]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.zjo763bf/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-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-s390x-17.secgroup --name adt-plucky-s390x-check-pgactivity-20250222-063658-juju-7f2275-prod-proposed-migration-environment-20-63d2febc-7756-4821-9bce-ff83da0e20cd --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-s390x -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/ 99s autopkgtest [06:38:37]: testbed dpkg architecture: s390x 99s autopkgtest [06:38:37]: testbed apt version: 2.9.30ubuntu1 100s autopkgtest [06:38:38]: @@@@@@@@@@@@@@@@@@@@ test bed setup 100s autopkgtest [06:38:38]: testbed release detected to be: None 100s autopkgtest [06:38:38]: updating testbed package index (apt update) 101s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 101s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 101s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 101s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 101s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 101s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 101s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 101s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 101s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [125 kB] 101s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [760 B] 101s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [424 kB] 101s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [2816 B] 102s Fetched 1264 kB in 1s (1487 kB/s) 102s Reading package lists... 103s Reading package lists... 103s Building dependency tree... 103s Reading state information... 103s Calculating upgrade... 103s Calculating upgrade... 103s The following packages were automatically installed and are no longer required: 103s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 103s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 103s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 103s linux-tools-6.11.0-8-generic 103s Use 'sudo apt autoremove' to remove them. 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 1041 kB of archives. 103s After this operation, 7168 B disk space will be freed. 103s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x curl s390x 8.12.1-2ubuntu1 [251 kB] 103s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl4t64 s390x 8.12.1-2ubuntu1 [397 kB] 104s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl3t64-gnutls s390x 8.12.1-2ubuntu1 [393 kB] 104s Fetched 1041 kB in 1s (1934 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 ... 81030 files and directories currently installed.) 104s Preparing to unpack .../curl_8.12.1-2ubuntu1_s390x.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_s390x.deb ... 104s Unpacking libcurl4t64:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 104s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_s390x.deb ... 104s Unpacking libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 104s Setting up libcurl4t64:s390x (8.12.1-2ubuntu1) ... 104s Setting up libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) ... 104s Setting up curl (8.12.1-2ubuntu1) ... 104s Processing triggers for man-db (2.13.0-1) ... 104s Processing triggers for libc-bin (2.40-4ubuntu1) ... 105s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s Solving dependencies... 105s The following packages will be REMOVED: 105s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 105s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 105s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 105s linux-tools-6.11.0-8-generic* 105s 0 upgraded, 0 newly installed, 9 to remove and 0 not upgraded. 105s After this operation, 167 MB disk space will be freed. 105s (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 ... 81030 files and directories currently installed.) 105s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 105s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 105s Removing libpython3.12t64:s390x (3.12.9-1) ... 105s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 105s Removing libnsl2:s390x (1.3.0-3build3) ... 105s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 105s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 105s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 106s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 106s Processing triggers for libc-bin (2.40-4ubuntu1) ... 106s (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 ... 55930 files and directories currently installed.) 106s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 106s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 106s autopkgtest [06:38:44]: 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 107s 107s Calculating upgrade... 107s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 108s Starting pkgProblemResolver with broken count: 0 108s Starting 2 pkgProblemResolver with broken count: 0 108s Done 108s Solving dependencies... 108s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s autopkgtest [06:38:46]: rebooting testbed after setup commands that affected boot 126s autopkgtest [06:39:04]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 15:05:57 UTC 2025 129s autopkgtest [06:39:07]: @@@@@@@@@@@@@@@@@@@@ apt-source check-pgactivity 130s Get:1 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (dsc) [2065 B] 130s Get:2 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (tar) [153 kB] 130s Get:3 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (diff) [2884 B] 130s gpgv: Signature made Sun Oct 1 07:41:37 2023 UTC 130s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 130s gpgv: Can't check signature: No public key 130s dpkg-source: warning: cannot verify inline signature for ./check-pgactivity_2.7-1.dsc: no acceptable signature found 130s autopkgtest [06:39:08]: testing package check-pgactivity version 2.7-1 131s autopkgtest [06:39:09]: build not needed 131s autopkgtest [06:39:09]: test check-pgactivity: preparing testbed 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 132s Starting pkgProblemResolver with broken count: 0 132s Starting 2 pkgProblemResolver with broken count: 0 132s Done 132s The following NEW packages will be installed: 132s check-pgactivity libio-pty-perl libipc-run-perl libjson-perl libllvm20 132s libpq5 libxslt1.1 postgresql postgresql-17 postgresql-client 132s postgresql-client-17 postgresql-client-common postgresql-common 132s postgresql-common-dev ssl-cert 132s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 132s Need to get 49.9 MB of archives. 132s After this operation, 213 MB of additional disk space will be used. 132s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 132s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 273 [47.5 kB] 132s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 132s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 132s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 273 [72.9 kB] 132s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 132s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 273 [101 kB] 132s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq5 s390x 17.4-1 [147 kB] 133s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 133s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client all 17+273 [13.2 kB] 133s Get:11 http://ftpmaster.internal/ubuntu plucky/universe s390x check-pgactivity all 2.7-1 [76.8 kB] 134s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 139s Get:13 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 139s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 141s Get:15 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql all 17+273 [14.3 kB] 142s Preconfiguring packages ... 142s /var/cache/debconf/tmp.ci/postgresql.config.aYlTdg: 12: pg_lsclusters: not found 142s Fetched 49.9 MB in 10s (5177 kB/s) 142s Selecting previously unselected package libjson-perl. 142s (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 ... 55928 files and directories currently installed.) 142s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 142s Unpacking libjson-perl (4.10000-1) ... 142s Selecting previously unselected package postgresql-client-common. 142s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 142s Unpacking postgresql-client-common (273) ... 142s Selecting previously unselected package libio-pty-perl. 142s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 142s Unpacking libio-pty-perl (1:1.20-1build3) ... 142s Selecting previously unselected package libipc-run-perl. 142s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 142s Unpacking libipc-run-perl (20231003.0-2) ... 142s Selecting previously unselected package postgresql-common-dev. 142s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 142s Unpacking postgresql-common-dev (273) ... 142s Selecting previously unselected package ssl-cert. 142s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 142s Unpacking ssl-cert (1.1.3ubuntu1) ... 142s Selecting previously unselected package postgresql-common. 142s Preparing to unpack .../06-postgresql-common_273_all.deb ... 142s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 142s Unpacking postgresql-common (273) ... 142s Selecting previously unselected package libpq5:s390x. 142s Preparing to unpack .../07-libpq5_17.4-1_s390x.deb ... 142s Unpacking libpq5:s390x (17.4-1) ... 142s Selecting previously unselected package postgresql-client-17. 142s Preparing to unpack .../08-postgresql-client-17_17.4-1_s390x.deb ... 142s Unpacking postgresql-client-17 (17.4-1) ... 142s Selecting previously unselected package postgresql-client. 142s Preparing to unpack .../09-postgresql-client_17+273_all.deb ... 142s Unpacking postgresql-client (17+273) ... 142s Selecting previously unselected package check-pgactivity. 142s Preparing to unpack .../10-check-pgactivity_2.7-1_all.deb ... 142s Unpacking check-pgactivity (2.7-1) ... 142s Selecting previously unselected package libllvm20:s390x. 142s Preparing to unpack .../11-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 142s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 143s Selecting previously unselected package libxslt1.1:s390x. 143s Preparing to unpack .../12-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 143s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 143s Selecting previously unselected package postgresql-17. 143s Preparing to unpack .../13-postgresql-17_17.4-1_s390x.deb ... 143s Unpacking postgresql-17 (17.4-1) ... 143s Selecting previously unselected package postgresql. 143s Preparing to unpack .../14-postgresql_17+273_all.deb ... 143s Unpacking postgresql (17+273) ... 143s Setting up postgresql-client-common (273) ... 143s Setting up libio-pty-perl (1:1.20-1build3) ... 143s Setting up libpq5:s390x (17.4-1) ... 143s Setting up ssl-cert (1.1.3ubuntu1) ... 143s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 143s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 143s Setting up libipc-run-perl (20231003.0-2) ... 143s Setting up libjson-perl (4.10000-1) ... 143s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 143s Setting up postgresql-common-dev (273) ... 143s Setting up postgresql-client-17 (17.4-1) ... 144s 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 144s Setting up check-pgactivity (2.7-1) ... 144s Setting up postgresql-common (273) ... 144s Creating config file /etc/postgresql-common/createcluster.conf with new version 144s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 144s Removing obsolete dictionary files: 144s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 145s Setting up postgresql-17 (17.4-1) ... 145s Creating new PostgreSQL cluster 17/main ... 145s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 145s The files belonging to this database system will be owned by user "postgres". 145s This user must also own the server process. 145s 145s The database cluster will be initialized with locale "C.UTF-8". 145s The default database encoding has accordingly been set to "UTF8". 145s The default text search configuration will be set to "english". 145s 145s Data page checksums are disabled. 145s 145s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 145s creating subdirectories ... ok 145s selecting dynamic shared memory implementation ... posix 145s selecting default "max_connections" ... 100 145s selecting default "shared_buffers" ... 128MB 145s selecting default time zone ... Etc/UTC 145s creating configuration files ... ok 145s running bootstrap script ... ok 146s performing post-bootstrap initialization ... ok 146s syncing data to disk ... ok 148s Setting up postgresql-client (17+273) ... 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 [06:39:29]: test check-pgactivity: [----------------------- 151s + pg_virtualenv -omax_connections=10 151s Creating new PostgreSQL cluster 17/regress ... 154s + /usr/lib/nagios/plugins/check_pgactivity -w 2 -c 2 -s backends 154s POSTGRES_BACKENDS OK: 1 connections on 7 | postgres=1;2;2;0;7 maximum_connections=7;;;0;7 154s + grep 'POSTGRES_BACKENDS OK: 1 connection' out 154s + /usr/lib/nagios/plugins/check_pgactivity -w 1 -c 2 -s backends 154s + EXIT=1 154s + '[' 1 = 1 ']' 154s + grep 'POSTGRES_BACKENDS WARNING: 1 connection' out 154s POSTGRES_BACKENDS WARNING: 1 connections on 7 | postgres=1;1;2;0;7 maximum_connections=7;;;0;7 154s Dropping cluster 17/regress ... 154s + rm -f out 155s autopkgtest [06:39:33]: test check-pgactivity: -----------------------] 155s check-pgactivity PASS 155s autopkgtest [06:39:33]: test check-pgactivity: - - - - - - - - - - results - - - - - - - - - - 156s autopkgtest [06:39:34]: @@@@@@@@@@@@@@@@@@@@ summary 156s check-pgactivity PASS 173s nova [W] Using flock in prodstack6-s390x 173s Creating nova instance adt-plucky-s390x-check-pgactivity-20250222-063658-juju-7f2275-prod-proposed-migration-environment-20-63d2febc-7756-4821-9bce-ff83da0e20cd from image adt/ubuntu-plucky-s390x-server-20250222.img (UUID ae633cda-0dee-481c-9805-d0ef3f3b5166)... 173s nova [W] Timed out waiting for f4ead26c-054c-457a-8f02-8d80e37a780f to get deleted.