0s autopkgtest [09:53:07]: starting date and time: 2024-11-13 09:53:07+0000 0s autopkgtest [09:53:07]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [09:53:07]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work._vzl339b/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:python3-defaults,src:python3-stdlib-extensions --apt-upgrade powa-collector --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=python3-defaults/3.12.7-1 python3-stdlib-extensions/3.12.7-1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-14.secgroup --name adt-plucky-arm64-powa-collector-20241113-095306-juju-7f2275-prod-proposed-migration-environment-15-27d5440d-6f73-419a-a8d7-0c4e4a65ffab --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 96s autopkgtest [09:54:43]: testbed dpkg architecture: arm64 96s autopkgtest [09:54:43]: testbed apt version: 2.9.8 96s autopkgtest [09:54:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 98s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 98s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.3 kB] 98s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 98s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [76.4 kB] 98s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [849 kB] 98s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [104 kB] 98s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [50.3 kB] 98s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [601 kB] 98s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [17.1 kB] 99s Fetched 1794 kB in 1s (1858 kB/s) 99s Reading package lists... 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 105s Calculating upgrade... 105s The following NEW packages will be installed: 105s python3.13-gdbm 105s The following packages will be upgraded: 105s libpython3-stdlib python3 python3-gdbm python3-minimal 106s 4 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. 106s Need to get 101 kB of archives. 106s After this operation, 141 kB of additional disk space will be used. 106s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 python3-minimal arm64 3.12.7-1 [27.4 kB] 106s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 python3 arm64 3.12.7-1 [24.0 kB] 106s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libpython3-stdlib arm64 3.12.7-1 [10.0 kB] 106s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 python3.13-gdbm arm64 3.13.0-2 [30.7 kB] 106s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 python3-gdbm arm64 3.12.7-1 [8642 B] 106s Fetched 101 kB in 0s (271 kB/s) 107s (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 ... 79924 files and directories currently installed.) 107s Preparing to unpack .../python3-minimal_3.12.7-1_arm64.deb ... 107s Unpacking python3-minimal (3.12.7-1) over (3.12.6-0ubuntu1) ... 107s Setting up python3-minimal (3.12.7-1) ... 107s (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 ... 79924 files and directories currently installed.) 107s Preparing to unpack .../python3_3.12.7-1_arm64.deb ... 107s Unpacking python3 (3.12.7-1) over (3.12.6-0ubuntu1) ... 107s Preparing to unpack .../libpython3-stdlib_3.12.7-1_arm64.deb ... 107s Unpacking libpython3-stdlib:arm64 (3.12.7-1) over (3.12.6-0ubuntu1) ... 107s Selecting previously unselected package python3.13-gdbm. 107s Preparing to unpack .../python3.13-gdbm_3.13.0-2_arm64.deb ... 107s Unpacking python3.13-gdbm (3.13.0-2) ... 107s Preparing to unpack .../python3-gdbm_3.12.7-1_arm64.deb ... 107s Unpacking python3-gdbm:arm64 (3.12.7-1) over (3.12.6-1ubuntu1) ... 107s Setting up python3.13-gdbm (3.13.0-2) ... 107s Setting up libpython3-stdlib:arm64 (3.12.7-1) ... 107s Setting up python3 (3.12.7-1) ... 108s Setting up python3-gdbm:arm64 (3.12.7-1) ... 108s Processing triggers for man-db (2.12.1-3) ... 109s Reading package lists... 109s Building dependency tree... 109s Reading state information... 110s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 110s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 110s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 110s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 111s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 112s Reading package lists... 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 113s Calculating upgrade... 113s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 113s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 121s autopkgtest [09:55:08]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 121s autopkgtest [09:55:08]: @@@@@@@@@@@@@@@@@@@@ apt-source powa-collector 123s Get:1 http://ftpmaster.internal/ubuntu plucky/universe powa-collector 1.2.0-3 (dsc) [2111 B] 123s Get:2 http://ftpmaster.internal/ubuntu plucky/universe powa-collector 1.2.0-3 (tar) [14.2 kB] 123s Get:3 http://ftpmaster.internal/ubuntu plucky/universe powa-collector 1.2.0-3 (diff) [4076 B] 123s gpgv: Signature made Wed May 15 16:11:05 2024 UTC 123s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 123s gpgv: Can't check signature: No public key 123s dpkg-source: warning: cannot verify inline signature for ./powa-collector_1.2.0-3.dsc: no acceptable signature found 124s autopkgtest [09:55:11]: testing package powa-collector version 1.2.0-3 124s autopkgtest [09:55:11]: build not needed 124s autopkgtest [09:55:11]: test collector: preparing testbed 128s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 129s The following additional packages will be installed: 129s libjson-perl libpq5 libxslt1.1 postgresql-16 postgresql-16-powa 129s postgresql-client-16 postgresql-client-common postgresql-common 129s powa-collector python3-psycopg2 ssl-cert 129s Suggested packages: 129s powa-web postgresql-doc-16 python-psycopg2-doc 129s Recommended packages: 129s libjson-xs-perl 129s The following NEW packages will be installed: 129s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql-16 129s postgresql-16-powa postgresql-client-16 postgresql-client-common 129s postgresql-common powa-collector python3-psycopg2 ssl-cert 129s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 129s Need to get 17.1 MB/17.1 MB of archives. 129s After this operation, 58.1 MB of additional disk space will be used. 129s Get:1 /tmp/autopkgtest.SW9PxG/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [716 B] 130s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 130s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 130s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 130s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 130s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.0-1 [248 kB] 130s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu1 [167 kB] 130s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-16 arm64 16.4-3 [1269 kB] 130s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-16 arm64 16.4-3 [15.0 MB] 131s Get:10 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-16-powa arm64 4.2.2-1 [47.8 kB] 131s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-psycopg2 arm64 2.9.9-2 [131 kB] 131s Get:12 http://ftpmaster.internal/ubuntu plucky/universe arm64 powa-collector all 1.2.0-3 [15.9 kB] 131s Preconfiguring packages ... 131s Fetched 17.1 MB in 1s (13.0 MB/s) 131s Selecting previously unselected package libjson-perl. 131s (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 ... 79931 files and directories currently installed.) 131s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 131s Unpacking libjson-perl (4.10000-1) ... 131s Selecting previously unselected package postgresql-client-common. 131s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 131s Unpacking postgresql-client-common (262) ... 131s Selecting previously unselected package ssl-cert. 131s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 131s Unpacking ssl-cert (1.1.2ubuntu2) ... 131s Selecting previously unselected package postgresql-common. 131s Preparing to unpack .../03-postgresql-common_262_all.deb ... 131s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 131s Unpacking postgresql-common (262) ... 131s Selecting previously unselected package libpq5:arm64. 132s Preparing to unpack .../04-libpq5_17.0-1_arm64.deb ... 132s Unpacking libpq5:arm64 (17.0-1) ... 132s Selecting previously unselected package libxslt1.1:arm64. 132s Preparing to unpack .../05-libxslt1.1_1.1.39-0exp1ubuntu1_arm64.deb ... 132s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 132s Selecting previously unselected package postgresql-client-16. 132s Preparing to unpack .../06-postgresql-client-16_16.4-3_arm64.deb ... 132s Unpacking postgresql-client-16 (16.4-3) ... 132s Selecting previously unselected package postgresql-16. 132s Preparing to unpack .../07-postgresql-16_16.4-3_arm64.deb ... 132s Unpacking postgresql-16 (16.4-3) ... 132s Selecting previously unselected package postgresql-16-powa. 133s Preparing to unpack .../08-postgresql-16-powa_4.2.2-1_arm64.deb ... 133s Unpacking postgresql-16-powa (4.2.2-1) ... 133s Selecting previously unselected package python3-psycopg2. 133s Preparing to unpack .../09-python3-psycopg2_2.9.9-2_arm64.deb ... 133s Unpacking python3-psycopg2 (2.9.9-2) ... 133s Selecting previously unselected package powa-collector. 133s Preparing to unpack .../10-powa-collector_1.2.0-3_all.deb ... 133s Unpacking powa-collector (1.2.0-3) ... 133s Selecting previously unselected package autopkgtest-satdep. 133s Preparing to unpack .../11-1-autopkgtest-satdep.deb ... 133s Unpacking autopkgtest-satdep (0) ... 133s Setting up postgresql-client-common (262) ... 133s Setting up libpq5:arm64 (17.0-1) ... 133s Setting up ssl-cert (1.1.2ubuntu2) ... 133s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 134s Setting up python3-psycopg2 (2.9.9-2) ... 134s Setting up libjson-perl (4.10000-1) ... 134s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 134s Setting up postgresql-client-16 (16.4-3) ... 135s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 135s Setting up powa-collector (1.2.0-3) ... 135s info: The home dir /nonexistent you specified can't be accessed: No such file or directory 135s 135s info: Selecting UID from range 100 to 999 ... 135s 135s info: Selecting GID from range 100 to 999 ... 135s info: Adding system user `powa' (UID 107) ... 135s info: Adding new group `powa' (GID 111) ... 135s info: Adding new user `powa' (UID 107) with group `powa' ... 135s info: Not creating `/nonexistent'. 135s Created symlink '/etc/systemd/system/multi-user.target.wants/powa-collector.service' → '/usr/lib/systemd/system/powa-collector.service'. 136s Setting up postgresql-common (262) ... 136s 136s Creating config file /etc/postgresql-common/createcluster.conf with new version 137s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 137s Removing obsolete dictionary files: 137s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 138s Setting up postgresql-16 (16.4-3) ... 138s Creating new PostgreSQL cluster 16/main ... 138s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 138s The files belonging to this database system will be owned by user "postgres". 138s This user must also own the server process. 138s 138s The database cluster will be initialized with locale "C.UTF-8". 138s The default database encoding has accordingly been set to "UTF8". 138s The default text search configuration will be set to "english". 138s 138s Data page checksums are disabled. 138s 138s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 138s creating subdirectories ... ok 138s selecting dynamic shared memory implementation ... posix 138s selecting default max_connections ... 100 138s selecting default shared_buffers ... 128MB 138s selecting default time zone ... Etc/UTC 138s creating configuration files ... ok 139s running bootstrap script ... ok 139s performing post-bootstrap initialization ... ok 139s syncing data to disk ... ok 143s Setting up postgresql-16-powa (4.2.2-1) ... 143s Setting up autopkgtest-satdep (0) ... 143s Processing triggers for man-db (2.12.1-3) ... 145s Processing triggers for libc-bin (2.40-1ubuntu3) ... 148s (Reading database ... 81956 files and directories currently installed.) 148s Removing autopkgtest-satdep (0) ... 149s autopkgtest [09:55:36]: test collector: [----------------------- 149s + : figure out which PG version to use (we depend on 'postgresql-powa' which might have pulled in any version) 149s + version=16/extension/powa.control 149s + version=16 149s + pg_virtualenv -v 16 -o shared_preload_libraries=pg_stat_statements 149s Creating new PostgreSQL cluster 16/regress ... 152s + createdb powa 153s + export PGDATABASE=powa 153s + PGDATABASE=powa 153s + psql -Xc 'CREATE EXTENSION powa CASCADE' 153s NOTICE: installing required extension "pg_stat_statements" 153s NOTICE: installing required extension "btree_gist" 153s CREATE EXTENSION 153s + : register server 153s + psql -Xxc 'SELECT powa_register_server(hostname:='\''localhost'\'', port:='\''5433'\'', username:='\''ubuntu'\'', password:='\''2d11b078624b745a7f1b0c9f91e5a504'\'')' 153s -[ RECORD 1 ]--------+-- 153s powa_register_server | t 153s 153s + psql -Xxc 'SELECT * FROM powa_servers WHERE id <> 0' 153s -[ RECORD 1 ]-------+--------------------------------- 153s id | 1 153s hostname | localhost 153s alias | 153s port | 5433 153s username | ubuntu 153s password | 2d11b078624b745a7f1b0c9f91e5a504 153s dbname | powa 153s frequency | 300 153s powa_coalesce | 100 153s retention | 1 day 153s allow_ui_connection | t 153s version | 153s 153s + psql -Xxc 'SELECT * FROM powa_snapshot_metas WHERE srvid <> 0' 153s -[ RECORD 1 ]+---------- 153s srvid | 1 153s coalesce_seq | 1 153s snapts | -infinity 153s aggts | -infinity 153s purgets | -infinity 153s errors | 153s 153s + : start collector 153s + echo '{ "repository": { "dsn": "postgresql://ubuntu:2d11b078624b745a7f1b0c9f91e5a504@localhost:5433/powa" }, "debug": false }' 153s + powa-collector 153s + sleep 10 153s 2024-11-13 09:55:40,622 - INFO : Starting powa-collector... 153s 2024-11-13 09:55:40,647 localhost:5433 INFO : Starting worker 153s 2024-11-13 09:55:40,648 - INFO : List of workers: 153s 2024-11-13 09:55:40,648 - INFO : localhost:5433: {'host': 'localhost', 'port': 5433, 'user': 'ubuntu', 'password': '2d11b078624b745a7f1b0c9f91e5a504', 'dbname': 'powa'} (no connection to remote server) 163s + kill 4376 163s + : check if snapshot was taken 163s + psql -Xxc 'SELECT * FROM powa_servers WHERE id <> 0' 163s 2024-11-13 09:55:50,552 localhost:5433 INFO : Asked to stop... 163s 2024-11-13 09:55:50,552 localhost:5433 INFO : Disconnecting from remote server 163s 2024-11-13 09:55:50,552 localhost:5433 INFO : stopped 163s -[ RECORD 1 ]-------+--------------------------------- 163s id | 1 163s hostname | localhost 163s alias | 163s port | 5433 163s username | ubuntu 163s password | 2d11b078624b745a7f1b0c9f91e5a504 163s dbname | powa 163s frequency | 300 163s powa_coalesce | 100 163s retention | 1 day 163s allow_ui_connection | t 163s version | 16.4 (Ubuntu 16.4-3) 163s 163s + psql -Xxc 'SELECT * FROM powa_snapshot_metas WHERE srvid <> 0' 163s -[ RECORD 1 ]+------------------------------ 163s srvid | 1 163s coalesce_seq | 2 163s snapts | 2024-11-13 09:55:40.698159+00 163s aggts | -infinity 163s purgets | -infinity 163s errors | 163s 163s ++ psql -XAtc 'SELECT snapts > now() - '\''20s'\''::interval FROM powa_snapshot_metas WHERE srvid <> 0' 163s + '[' t = t ']' 163s Dropping cluster 16/regress ... 164s autopkgtest [09:55:51]: test collector: -----------------------] 164s autopkgtest [09:55:51]: test collector: - - - - - - - - - - results - - - - - - - - - - 164s collector PASS 165s autopkgtest [09:55:52]: @@@@@@@@@@@@@@@@@@@@ summary 165s collector PASS 170s nova [W] Skipping flock in bos03-arm64 170s Creating nova instance adt-plucky-arm64-powa-collector-20241113-095306-juju-7f2275-prod-proposed-migration-environment-15-27d5440d-6f73-419a-a8d7-0c4e4a65ffab from image adt/ubuntu-plucky-arm64-server-20241113.img (UUID 2d7760e6-2439-4200-89d6-5ed33e5c6330)...