0s autopkgtest [06:43:55]: starting date and time: 2025-02-22 06:43:55+0000 0s autopkgtest [06:43:55]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:43:55]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.y59l9dfi/out --timeout-copy=6000 -a i386 --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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@lcy02-5.secgroup --name adt-plucky-i386-check-pgactivity-20250222-064355-juju-7f2275-prod-proposed-migration-environment-20-977f28d8-460b-4b9a-8632-90c1aab0e478 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration -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/ 44s autopkgtest [06:44:39]: testbed dpkg architecture: amd64 44s autopkgtest [06:44:39]: testbed apt version: 2.9.30ubuntu1 44s autopkgtest [06:44:39]: @@@@@@@@@@@@@@@@@@@@ test bed setup 44s autopkgtest [06:44:39]: testbed release detected to be: None 44s autopkgtest [06:44:39]: updating testbed package index (apt update) 45s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 45s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 45s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 45s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 45s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 45s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 45s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 45s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 45s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [129 kB] 45s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [98.8 kB] 45s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [7984 B] 45s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2412 B] 45s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [223 kB] 45s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [453 kB] 45s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [8844 B] 45s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [20.9 kB] 45s Fetched 1656 kB in 0s (6062 kB/s) 46s Reading package lists... 46s Reading package lists... 46s Building dependency tree... 46s Reading state information... 47s Calculating upgrade... 47s Calculating upgrade... 47s The following packages will be upgraded: 47s curl libcurl3t64-gnutls libcurl4t64 47s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 47s Need to get 1121 kB of archives. 47s After this operation, 7168 B disk space will be freed. 47s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 curl amd64 8.12.1-2ubuntu1 [251 kB] 47s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl4t64 amd64 8.12.1-2ubuntu1 [437 kB] 47s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl3t64-gnutls amd64 8.12.1-2ubuntu1 [432 kB] 48s Fetched 1121 kB in 0s (22.0 MB/s) 48s (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 ... 108975 files and directories currently installed.) 48s Preparing to unpack .../curl_8.12.1-2ubuntu1_amd64.deb ... 48s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 48s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_amd64.deb ... 48s Unpacking libcurl4t64:amd64 (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 48s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_amd64.deb ... 48s Unpacking libcurl3t64-gnutls:amd64 (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 48s Setting up libcurl4t64:amd64 (8.12.1-2ubuntu1) ... 48s Setting up libcurl3t64-gnutls:amd64 (8.12.1-2ubuntu1) ... 48s Setting up curl (8.12.1-2ubuntu1) ... 48s Processing triggers for man-db (2.13.0-1) ... 49s Processing triggers for libc-bin (2.40-4ubuntu1) ... 49s Reading package lists... 49s Building dependency tree... 49s Reading state information... 49s Solving dependencies... 50s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 50s autopkgtest [06:44:45]: upgrading testbed (apt dist-upgrade and autopurge) 50s Reading package lists... 50s Building dependency tree... 50s Reading state information... 50s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 50s Starting 2 pkgProblemResolver with broken count: 0 50s Done 51s Entering ResolveByKeep 51s 51s Calculating upgrade... 51s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 52s Reading package lists... 52s Building dependency tree... 52s Reading state information... 52s Starting pkgProblemResolver with broken count: 0 52s Starting 2 pkgProblemResolver with broken count: 0 52s Done 52s Solving dependencies... 53s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 53s autopkgtest [06:44:48]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Tue Feb 4 16:02:16 UTC 2025 53s autopkgtest [06:44:48]: @@@@@@@@@@@@@@@@@@@@ apt-source check-pgactivity 54s Get:1 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (dsc) [2065 B] 54s Get:2 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (tar) [153 kB] 54s Get:3 http://ftpmaster.internal/ubuntu plucky/universe check-pgactivity 2.7-1 (diff) [2884 B] 54s gpgv: Signature made Sun Oct 1 07:41:37 2023 UTC 54s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 54s gpgv: Can't check signature: No public key 54s dpkg-source: warning: cannot verify inline signature for ./check-pgactivity_2.7-1.dsc: no acceptable signature found 54s autopkgtest [06:44:49]: testing package check-pgactivity version 2.7-1 54s autopkgtest [06:44:49]: build not needed 54s autopkgtest [06:44:49]: test check-pgactivity: preparing testbed 54s Reading package lists... 54s Building dependency tree... 54s Reading state information... 55s Starting pkgProblemResolver with broken count: 0 55s Starting 2 pkgProblemResolver with broken count: 0 55s Done 55s The following NEW packages will be installed: 55s check-pgactivity libio-pty-perl libipc-run-perl libjson-perl libllvm20 55s libpq5 libxslt1.1 postgresql postgresql-17 postgresql-client 55s postgresql-client-17 postgresql-client-common postgresql-common 55s postgresql-common-dev ssl-cert 55s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 55s Need to get 49.4 MB of archives. 55s After this operation, 200 MB of additional disk space will be used. 55s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 55s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 273 [47.5 kB] 55s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 55s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 55s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common-dev all 273 [72.9 kB] 55s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 55s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 273 [101 kB] 55s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq5 amd64 17.4-1 [155 kB] 55s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 55s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client all 17+273 [13.2 kB] 55s Get:11 http://ftpmaster.internal/ubuntu plucky/universe amd64 check-pgactivity all 2.7-1 [76.8 kB] 55s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libllvm20 amd64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [30.5 MB] 55s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 55s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 55s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql all 17+273 [14.3 kB] 56s Preconfiguring packages ... 56s /var/cache/debconf/tmp.ci/postgresql.config.pz3qoV: 12: pg_lsclusters: not found 56s Fetched 49.4 MB in 0s (136 MB/s) 56s Selecting previously unselected package libjson-perl. 56s (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 ... 108975 files and directories currently installed.) 56s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 56s Unpacking libjson-perl (4.10000-1) ... 56s Selecting previously unselected package postgresql-client-common. 56s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 56s Unpacking postgresql-client-common (273) ... 56s Selecting previously unselected package libio-pty-perl. 56s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 56s Unpacking libio-pty-perl (1:1.20-1build3) ... 56s Selecting previously unselected package libipc-run-perl. 56s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 56s Unpacking libipc-run-perl (20231003.0-2) ... 56s Selecting previously unselected package postgresql-common-dev. 56s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 56s Unpacking postgresql-common-dev (273) ... 56s Selecting previously unselected package ssl-cert. 56s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 56s Unpacking ssl-cert (1.1.3ubuntu1) ... 56s Selecting previously unselected package postgresql-common. 56s Preparing to unpack .../06-postgresql-common_273_all.deb ... 56s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 56s Unpacking postgresql-common (273) ... 56s Selecting previously unselected package libpq5:amd64. 56s Preparing to unpack .../07-libpq5_17.4-1_amd64.deb ... 56s Unpacking libpq5:amd64 (17.4-1) ... 56s Selecting previously unselected package postgresql-client-17. 56s Preparing to unpack .../08-postgresql-client-17_17.4-1_amd64.deb ... 56s Unpacking postgresql-client-17 (17.4-1) ... 56s Selecting previously unselected package postgresql-client. 56s Preparing to unpack .../09-postgresql-client_17+273_all.deb ... 56s Unpacking postgresql-client (17+273) ... 56s Selecting previously unselected package check-pgactivity. 56s Preparing to unpack .../10-check-pgactivity_2.7-1_all.deb ... 56s Unpacking check-pgactivity (2.7-1) ... 56s Selecting previously unselected package libllvm20:amd64. 56s Preparing to unpack .../11-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_amd64.deb ... 56s Unpacking libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 57s Selecting previously unselected package libxslt1.1:amd64. 57s Preparing to unpack .../12-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 57s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 57s Selecting previously unselected package postgresql-17. 57s Preparing to unpack .../13-postgresql-17_17.4-1_amd64.deb ... 57s Unpacking postgresql-17 (17.4-1) ... 57s Selecting previously unselected package postgresql. 57s Preparing to unpack .../14-postgresql_17+273_all.deb ... 57s Unpacking postgresql (17+273) ... 57s Setting up postgresql-client-common (273) ... 58s Setting up libio-pty-perl (1:1.20-1build3) ... 58s Setting up libpq5:amd64 (17.4-1) ... 58s Setting up ssl-cert (1.1.3ubuntu1) ... 58s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 58s Setting up libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 58s Setting up libipc-run-perl (20231003.0-2) ... 58s Setting up libjson-perl (4.10000-1) ... 58s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 58s Setting up postgresql-common-dev (273) ... 58s Setting up postgresql-client-17 (17.4-1) ... 59s 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 59s Setting up check-pgactivity (2.7-1) ... 59s Setting up postgresql-common (273) ... 59s Creating config file /etc/postgresql-common/createcluster.conf with new version 59s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 59s Removing obsolete dictionary files: 60s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 60s Setting up postgresql-17 (17.4-1) ... 61s Creating new PostgreSQL cluster 17/main ... 61s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 61s The files belonging to this database system will be owned by user "postgres". 61s This user must also own the server process. 61s 61s The database cluster will be initialized with locale "C.UTF-8". 61s The default database encoding has accordingly been set to "UTF8". 61s The default text search configuration will be set to "english". 61s 61s Data page checksums are disabled. 61s 61s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 61s creating subdirectories ... ok 61s selecting dynamic shared memory implementation ... posix 61s selecting default "max_connections" ... 100 61s selecting default "shared_buffers" ... 128MB 61s selecting default time zone ... Etc/UTC 61s creating configuration files ... ok 61s running bootstrap script ... ok 62s performing post-bootstrap initialization ... ok 62s syncing data to disk ... ok 65s Setting up postgresql-client (17+273) ... 65s Setting up postgresql (17+273) ... 65s Processing triggers for man-db (2.13.0-1) ... 66s Processing triggers for libc-bin (2.40-4ubuntu1) ... 67s autopkgtest [06:45:02]: testbed environment configured for cross-architecture building 67s autopkgtest [06:45:02]: test check-pgactivity: [----------------------- 67s + pg_virtualenv -omax_connections=10 67s Creating new PostgreSQL cluster 17/regress ... 70s + /usr/lib/nagios/plugins/check_pgactivity -w 2 -c 2 -s backends 70s + grep 'POSTGRES_BACKENDS OK: 1 connection' out 70s POSTGRES_BACKENDS OK: 1 connections on 7 | postgres=1;2;2;0;7 maximum_connections=7;;;0;7 70s + /usr/lib/nagios/plugins/check_pgactivity -w 1 -c 2 -s backends 70s + EXIT=1 70s + '[' 1 = 1 ']' 70s + grep 'POSTGRES_BACKENDS WARNING: 1 connection' out 70s POSTGRES_BACKENDS WARNING: 1 connections on 7 | postgres=1;1;2;0;7 maximum_connections=7;;;0;7 70s Dropping cluster 17/regress ... 70s + rm -f out 70s autopkgtest [06:45:05]: test check-pgactivity: -----------------------] 71s autopkgtest [06:45:06]: test check-pgactivity: - - - - - - - - - - results - - - - - - - - - - 71s check-pgactivity PASS 71s autopkgtest [06:45:06]: @@@@@@@@@@@@@@@@@@@@ summary 71s check-pgactivity PASS 87s nova [W] Skipping flock for amd64 87s Creating nova instance adt-plucky-i386-check-pgactivity-20250222-064355-juju-7f2275-prod-proposed-migration-environment-20-977f28d8-460b-4b9a-8632-90c1aab0e478 from image adt/ubuntu-plucky-amd64-server-20250222.img (UUID aba6fb27-d21c-4f55-a27f-5f98cacbaba1)... 87s nova [W] Timed out waiting for 6dae518c-5a4c-4ce0-a20d-7366eb511230 to get deleted.