0s autopkgtest [21:47:11]: starting date: 2024-03-18 0s autopkgtest [21:47:11]: git checkout: d9c0295b adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [21:47:11]: host juju-7f2275-prod-proposed-migration-environment-4; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.tjfi3ez6/out --timeout-copy=6000 --setup-commands 'sed -i "s/ports.ubuntu.com/ftpmaster.internal/; s/ubuntu-ports/ubuntu/" /etc/apt/sources.list `ls /etc/apt/sources.list.d/*.list 2>/dev/null || true`; ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_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,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com\n" >> /etc/environment' --apt-pocket=proposed=src:openssl --apt-upgrade pgagroal --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=openssl/3.0.13-0ubuntu2 -- lxd -r lxd-armhf-10.44.124.216 lxd-armhf-10.44.124.216:autopkgtest/ubuntu/noble/armhf 58s autopkgtest [21:48:09]: @@@@@@@@@@@@@@@@@@@@ test bed setup 61s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 62s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3720 kB] 64s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 64s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [485 kB] 64s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [52.0 kB] 64s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main armhf Packages [578 kB] 65s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main armhf c-n-f Metadata [2492 B] 65s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted armhf Packages [1372 B] 65s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted armhf c-n-f Metadata [116 B] 65s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe armhf Packages [3577 kB] 66s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe armhf c-n-f Metadata [7776 B] 66s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse armhf Packages [35.6 kB] 66s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse armhf c-n-f Metadata [116 B] 78s Fetched 8583 kB in 7s (1167 kB/s) 79s Reading package lists... 99s tee: /proc/self/fd/2: Permission denied 142s Hit:1 http://ports.ubuntu.com/ubuntu-ports noble InRelease 142s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 142s Hit:3 http://ports.ubuntu.com/ubuntu-ports noble-updates InRelease 142s Hit:4 http://ftpmaster.internal/ubuntu noble-updates InRelease 142s Hit:5 http://ports.ubuntu.com/ubuntu-ports noble-backports InRelease 142s Hit:6 http://ftpmaster.internal/ubuntu noble-security InRelease 142s Hit:7 http://ports.ubuntu.com/ubuntu-ports noble-security InRelease 142s Hit:8 http://ftpmaster.internal/ubuntu noble-proposed InRelease 149s Reading package lists... 150s Reading package lists... 150s Building dependency tree... 150s Reading state information... 152s Calculating upgrade... 153s The following packages have been kept back: 153s openssl 154s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 154s Reading package lists... 155s Building dependency tree... 155s Reading state information... 157s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 159s autopkgtest [21:49:50]: rebooting testbed after setup commands that affected boot 196s autopkgtest [21:50:27]: testbed running kernel: Linux 5.4.0-173-generic #191-Ubuntu SMP Fri Feb 2 13:54:37 UTC 2024 200s autopkgtest [21:50:31]: testbed dpkg architecture: armhf 215s autopkgtest [21:50:46]: @@@@@@@@@@@@@@@@@@@@ apt-source pgagroal 223s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgagroal 1.6.0-1 (dsc) [2080 B] 223s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgagroal 1.6.0-1 (tar) [310 kB] 223s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgagroal 1.6.0-1 (diff) [4700 B] 223s gpgv: Signature made Fri Feb 23 15:06:16 2024 UTC 223s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 223s gpgv: Can't check signature: No public key 223s dpkg-source: warning: cannot verify inline signature for ./pgagroal_1.6.0-1.dsc: no acceptable signature found 224s autopkgtest [21:50:55]: testing package pgagroal version 1.6.0-1 224s autopkgtest [21:50:55]: build not needed 232s autopkgtest [21:51:03]: test connect: preparing testbed 249s Reading package lists... 250s Building dependency tree... 250s Reading state information... 251s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 252s Starting 2 pkgProblemResolver with broken count: 0 252s Done 253s Done 254s Starting pkgProblemResolver with broken count: 0 254s Starting 2 pkgProblemResolver with broken count: 0 254s Done 256s The following additional packages will be installed: 256s libcjson1 libev4 libjson-perl libllvm17 libpq5 libxslt1.1 pgagroal 256s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 256s postgresql-common ssl-cert 256s Suggested packages: 256s postgresql-doc postgresql-doc-16 256s Recommended packages: 256s libjson-xs-perl 257s The following NEW packages will be installed: 257s libcjson1 libev4 libjson-perl libllvm17 libpq5 libxslt1.1 pgagroal 257s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 257s postgresql-common ssl-cert 257s 0 upgraded, 13 newly installed, 0 to remove and 1 not upgraded. 257s 1 not fully installed or removed. 257s Need to get 42.0 MB of archives. 257s After this operation, 158 MB of additional disk space will be used. 257s Get:1 http://ftpmaster.internal/ubuntu noble/main armhf libpq5 armhf 16.2-1 [122 kB] 257s Get:2 http://ftpmaster.internal/ubuntu noble/main armhf postgresql-client-common all 257 [36.2 kB] 257s Get:3 http://ftpmaster.internal/ubuntu noble/main armhf postgresql-client-16 armhf 16.2-1 [1228 kB] 258s Get:4 http://ftpmaster.internal/ubuntu noble/main armhf libjson-perl all 4.10000-1 [81.9 kB] 258s Get:5 http://ftpmaster.internal/ubuntu noble/main armhf ssl-cert all 1.1.2ubuntu1 [17.8 kB] 258s Get:6 http://ftpmaster.internal/ubuntu noble/main armhf postgresql-common all 257 [162 kB] 258s Get:7 http://ftpmaster.internal/ubuntu noble/main armhf libllvm17 armhf 1:17.0.6-5build1 [25.3 MB] 261s Get:8 http://ftpmaster.internal/ubuntu noble/main armhf libxslt1.1 armhf 1.1.35-1 [147 kB] 261s Get:9 http://ftpmaster.internal/ubuntu noble/main armhf postgresql-16 armhf 16.2-1 [14.5 MB] 262s Get:10 http://ftpmaster.internal/ubuntu noble/main armhf postgresql all 16+257 [11.4 kB] 262s Get:11 http://ftpmaster.internal/ubuntu noble/universe armhf libcjson1 armhf 1.7.17-1 [19.0 kB] 262s Get:12 http://ftpmaster.internal/ubuntu noble/universe armhf libev4 armhf 1:4.33-2 [25.2 kB] 262s Get:13 http://ftpmaster.internal/ubuntu noble/universe armhf pgagroal armhf 1.6.0-1 [242 kB] 263s Preconfiguring packages ... 263s Fetched 42.0 MB in 5s (8276 kB/s) 263s Selecting previously unselected package libpq5:armhf. 263s (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 ... 58620 files and directories currently installed.) 263s Preparing to unpack .../00-libpq5_16.2-1_armhf.deb ... 263s Unpacking libpq5:armhf (16.2-1) ... 263s Selecting previously unselected package postgresql-client-common. 264s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 264s Unpacking postgresql-client-common (257) ... 264s Selecting previously unselected package postgresql-client-16. 264s Preparing to unpack .../02-postgresql-client-16_16.2-1_armhf.deb ... 264s Unpacking postgresql-client-16 (16.2-1) ... 264s Selecting previously unselected package libjson-perl. 264s Preparing to unpack .../03-libjson-perl_4.10000-1_all.deb ... 264s Unpacking libjson-perl (4.10000-1) ... 264s Selecting previously unselected package ssl-cert. 264s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu1_all.deb ... 264s Unpacking ssl-cert (1.1.2ubuntu1) ... 264s Selecting previously unselected package postgresql-common. 264s Preparing to unpack .../05-postgresql-common_257_all.deb ... 264s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 264s Unpacking postgresql-common (257) ... 264s Selecting previously unselected package libllvm17:armhf. 264s Preparing to unpack .../06-libllvm17_1%3a17.0.6-5build1_armhf.deb ... 264s Unpacking libllvm17:armhf (1:17.0.6-5build1) ... 267s Selecting previously unselected package libxslt1.1:armhf. 267s Preparing to unpack .../07-libxslt1.1_1.1.35-1_armhf.deb ... 267s Unpacking libxslt1.1:armhf (1.1.35-1) ... 267s Selecting previously unselected package postgresql-16. 267s Preparing to unpack .../08-postgresql-16_16.2-1_armhf.deb ... 267s Unpacking postgresql-16 (16.2-1) ... 269s Selecting previously unselected package postgresql. 269s Preparing to unpack .../09-postgresql_16+257_all.deb ... 269s Unpacking postgresql (16+257) ... 269s Selecting previously unselected package libcjson1:armhf. 269s Preparing to unpack .../10-libcjson1_1.7.17-1_armhf.deb ... 269s Unpacking libcjson1:armhf (1.7.17-1) ... 269s Selecting previously unselected package libev4:armhf. 269s Preparing to unpack .../11-libev4_1%3a4.33-2_armhf.deb ... 269s Unpacking libev4:armhf (1:4.33-2) ... 270s Selecting previously unselected package pgagroal. 270s Preparing to unpack .../12-pgagroal_1.6.0-1_armhf.deb ... 270s Unpacking pgagroal (1.6.0-1) ... 270s Setting up postgresql-client-common (257) ... 270s Setting up libev4:armhf (1:4.33-2) ... 270s Setting up libpq5:armhf (16.2-1) ... 270s Setting up libcjson1:armhf (1.7.17-1) ... 270s Setting up ssl-cert (1.1.2ubuntu1) ... 273s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 274s Setting up libjson-perl (4.10000-1) ... 274s Setting up libxslt1.1:armhf (1.1.35-1) ... 274s Setting up libllvm17:armhf (1:17.0.6-5build1) ... 274s Setting up postgresql-client-16 (16.2-1) ... 277s 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 277s Setting up postgresql-common (257) ... 279s 279s Creating config file /etc/postgresql-common/createcluster.conf with new version 280s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 280s Removing obsolete dictionary files: 282s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 283s Setting up postgresql-16 (16.2-1) ... 284s Creating new PostgreSQL cluster 16/main ... 284s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 284s The files belonging to this database system will be owned by user "postgres". 284s This user must also own the server process. 284s 284s The database cluster will be initialized with locale "C.UTF-8". 284s The default database encoding has accordingly been set to "UTF8". 284s The default text search configuration will be set to "english". 284s 284s Data page checksums are disabled. 284s 284s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 284s creating subdirectories ... ok 284s selecting dynamic shared memory implementation ... posix 285s selecting default max_connections ... 100 285s selecting default shared_buffers ... 128MB 285s selecting default time zone ... Etc/UTC 285s creating configuration files ... ok 285s running bootstrap script ... ok 287s performing post-bootstrap initialization ... ok 287s syncing data to disk ... ok 295s Setting up pgagroal (1.6.0-1) ... 296s Created symlink /etc/systemd/system/sockets.target.wants/pgagroal.socket → /usr/lib/systemd/system/pgagroal.socket. 297s Setting up postgresql (16+257) ... 297s Setting up autopkgtest-satdep (0) ... 297s Processing triggers for man-db (2.12.0-3) ... 300s Processing triggers for libc-bin (2.39-0ubuntu2) ... 319s (Reading database ... 60622 files and directories currently installed.) 319s Removing autopkgtest-satdep (0) ... 331s autopkgtest [21:52:42]: test connect: [----------------------- 334s + trap bailout EXIT 334s + service postgresql stop 338s + test -d /run/systemd/system 338s + systemctl start pgagroal.socket 338s + pg_virtualenv -oport=5432 338s Creating new PostgreSQL cluster 16/regress ... 345s + PW=agroalpass 345s + su -c '( echo agroalpass; echo agroalpass ) | createuser --pwprompt agroaltestuser' postgres 345s Enter password for new role: 345s Enter it again: 345s + PGPASSWORD=agroalpass 345s + psql -h /run/postgresql -p 2345 -U agroaltestuser -c 'select 6*7' postgres 345s + grep 42 345s 42 345s Dropping cluster 16/regress ... 351s + bailout 351s + test -d /run/systemd/system 351s + systemctl stop pgagroal pgagroal.socket 351s autopkgtest [21:53:02]: test connect: -----------------------] 356s connect PASS 356s autopkgtest [21:53:07]: test connect: - - - - - - - - - - results - - - - - - - - - - 360s autopkgtest [21:53:11]: @@@@@@@@@@@@@@@@@@@@ summary 360s connect PASS