0s autopkgtest [04:17:39]: starting date and time: 2024-05-01 04:17:39+0000 0s autopkgtest [04:17:39]: git checkout: 699e7f9f ssh-setup/nova: explicitely set 'fqdn' in cloud-init 0s autopkgtest [04:17:39]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.um3_3gwa/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade pgagroal --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.39-0ubuntu8.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos01-arm64-13.secgroup --name adt-oracular-arm64-pgagroal-20240501-041739-juju-7f2275-prod-proposed-migration-environment-2-2a297db7-b7f7-40e7-84f8-e20a076504bc --image adt/ubuntu-oracular-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --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://us.ports.ubuntu.com/ubuntu-ports/ 333s autopkgtest [04:23:12]: testbed dpkg architecture: arm64 333s autopkgtest [04:23:12]: testbed apt version: 2.7.14build2 333s autopkgtest [04:23:12]: @@@@@@@@@@@@@@@@@@@@ test bed setup 334s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [64.7 kB] 334s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [1964 B] 334s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [21.1 kB] 334s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [1680 B] 334s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [197 kB] 334s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main arm64 Packages [39.4 kB] 334s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted arm64 Packages [12.3 kB] 334s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe arm64 Packages [124 kB] 334s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse arm64 Packages [756 B] 334s Fetched 462 kB in 1s (712 kB/s) 334s Reading package lists... 337s Reading package lists... 337s Building dependency tree... 337s Reading state information... 337s Calculating upgrade... 337s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 337s Reading package lists... 338s Building dependency tree... 338s Reading state information... 338s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 338s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 338s Get:2 http://ftpmaster.internal/ubuntu oracular InRelease [64.6 kB] 339s Get:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease [64.6 kB] 339s Get:4 http://ftpmaster.internal/ubuntu oracular-security InRelease [64.6 kB] 339s Get:5 http://ftpmaster.internal/ubuntu oracular/main arm64 Packages [1377 kB] 339s Get:6 http://ftpmaster.internal/ubuntu oracular/universe arm64 Packages [15.3 MB] 341s Get:7 http://ftpmaster.internal/ubuntu oracular/multiverse arm64 Packages [223 kB] 342s Fetched 17.1 MB in 4s (4107 kB/s) 343s Reading package lists... 343s Reading package lists... 343s Building dependency tree... 343s Reading state information... 343s Calculating upgrade... 344s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 344s Reading package lists... 344s Building dependency tree... 344s Reading state information... 344s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 347s autopkgtest [04:23:26]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 02:32:42 UTC 2024 347s autopkgtest [04:23:26]: @@@@@@@@@@@@@@@@@@@@ apt-source pgagroal 349s Get:1 http://ftpmaster.internal/ubuntu oracular/universe pgagroal 1.6.0-1build2 (dsc) [2183 B] 349s Get:2 http://ftpmaster.internal/ubuntu oracular/universe pgagroal 1.6.0-1build2 (tar) [310 kB] 349s Get:3 http://ftpmaster.internal/ubuntu oracular/universe pgagroal 1.6.0-1build2 (diff) [4860 B] 349s gpgv: Signature made Mon Apr 1 07:08:55 2024 UTC 349s gpgv: using RSA key A089FB36AAFBDAD5ACC1325069F790171A210984 349s gpgv: Can't check signature: No public key 349s dpkg-source: warning: cannot verify inline signature for ./pgagroal_1.6.0-1build2.dsc: no acceptable signature found 349s autopkgtest [04:23:28]: testing package pgagroal version 1.6.0-1build2 349s autopkgtest [04:23:28]: build not needed 350s autopkgtest [04:23:29]: test connect: preparing testbed 351s Reading package lists... 351s Building dependency tree... 351s Reading state information... 351s Starting pkgProblemResolver with broken count: 0 351s Starting 2 pkgProblemResolver with broken count: 0 351s Done 352s The following additional packages will be installed: 352s libcjson1 libev4t64 libjson-perl libllvm17t64 libpq5 libxslt1.1 pgagroal 352s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 352s postgresql-common ssl-cert 352s Suggested packages: 352s postgresql-doc postgresql-doc-16 352s Recommended packages: 352s libjson-xs-perl 352s The following NEW packages will be installed: 352s autopkgtest-satdep libcjson1 libev4t64 libjson-perl libllvm17t64 libpq5 352s libxslt1.1 pgagroal postgresql postgresql-16 postgresql-client-16 352s postgresql-client-common postgresql-common ssl-cert 352s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 352s Need to get 42.4 MB/42.4 MB of archives. 352s After this operation, 176 MB of additional disk space will be used. 352s Get:1 /tmp/autopkgtest.Jo6jg2/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [716 B] 352s Get:2 http://ftpmaster.internal/ubuntu oracular/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 352s Get:3 http://ftpmaster.internal/ubuntu oracular/main arm64 postgresql-client-common all 257build1 [36.3 kB] 352s Get:4 http://ftpmaster.internal/ubuntu oracular/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 352s Get:5 http://ftpmaster.internal/ubuntu oracular/main arm64 postgresql-common all 257build1 [161 kB] 352s Get:6 http://ftpmaster.internal/ubuntu oracular/universe arm64 libcjson1 arm64 1.7.17-1 [25.1 kB] 352s Get:7 http://ftpmaster.internal/ubuntu oracular/universe arm64 libev4t64 arm64 1:4.33-2.1build1 [30.5 kB] 352s Get:8 http://ftpmaster.internal/ubuntu oracular/main arm64 libllvm17t64 arm64 1:17.0.6-9ubuntu1 [25.0 MB] 354s Get:9 http://ftpmaster.internal/ubuntu oracular/main arm64 libpq5 arm64 16.2-1ubuntu4 [137 kB] 354s Get:10 http://ftpmaster.internal/ubuntu oracular/main arm64 libxslt1.1 arm64 1.1.39-0exp1build1 [166 kB] 354s Get:11 http://ftpmaster.internal/ubuntu oracular/universe arm64 pgagroal arm64 1.6.0-1build2 [248 kB] 354s Get:12 http://ftpmaster.internal/ubuntu oracular/main arm64 postgresql-client-16 arm64 16.2-1ubuntu4 [1261 kB] 354s Get:13 http://ftpmaster.internal/ubuntu oracular/main arm64 postgresql-16 arm64 16.2-1ubuntu4 [15.2 MB] 354s Get:14 http://ftpmaster.internal/ubuntu oracular/main arm64 postgresql all 16+257build1 [11.5 kB] 354s Preconfiguring packages ... 354s Fetched 42.4 MB in 2s (17.0 MB/s) 354s Selecting previously unselected package libjson-perl. 354s (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 ... 77894 files and directories currently installed.) 354s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 354s Unpacking libjson-perl (4.10000-1) ... 354s Selecting previously unselected package postgresql-client-common. 354s Preparing to unpack .../01-postgresql-client-common_257build1_all.deb ... 354s Unpacking postgresql-client-common (257build1) ... 355s Selecting previously unselected package ssl-cert. 355s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 355s Unpacking ssl-cert (1.1.2ubuntu1) ... 355s Selecting previously unselected package postgresql-common. 355s Preparing to unpack .../03-postgresql-common_257build1_all.deb ... 355s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 355s Unpacking postgresql-common (257build1) ... 355s Selecting previously unselected package libcjson1:arm64. 355s Preparing to unpack .../04-libcjson1_1.7.17-1_arm64.deb ... 355s Unpacking libcjson1:arm64 (1.7.17-1) ... 355s Selecting previously unselected package libev4t64:arm64. 355s Preparing to unpack .../05-libev4t64_1%3a4.33-2.1build1_arm64.deb ... 355s Unpacking libev4t64:arm64 (1:4.33-2.1build1) ... 355s Selecting previously unselected package libllvm17t64:arm64. 355s Preparing to unpack .../06-libllvm17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 355s Unpacking libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 355s Selecting previously unselected package libpq5:arm64. 355s Preparing to unpack .../07-libpq5_16.2-1ubuntu4_arm64.deb ... 355s Unpacking libpq5:arm64 (16.2-1ubuntu4) ... 355s Selecting previously unselected package libxslt1.1:arm64. 355s Preparing to unpack .../08-libxslt1.1_1.1.39-0exp1build1_arm64.deb ... 355s Unpacking libxslt1.1:arm64 (1.1.39-0exp1build1) ... 355s Selecting previously unselected package pgagroal. 355s Preparing to unpack .../09-pgagroal_1.6.0-1build2_arm64.deb ... 355s Unpacking pgagroal (1.6.0-1build2) ... 355s Selecting previously unselected package postgresql-client-16. 355s Preparing to unpack .../10-postgresql-client-16_16.2-1ubuntu4_arm64.deb ... 355s Unpacking postgresql-client-16 (16.2-1ubuntu4) ... 355s Selecting previously unselected package postgresql-16. 355s Preparing to unpack .../11-postgresql-16_16.2-1ubuntu4_arm64.deb ... 355s Unpacking postgresql-16 (16.2-1ubuntu4) ... 356s Selecting previously unselected package postgresql. 356s Preparing to unpack .../12-postgresql_16+257build1_all.deb ... 356s Unpacking postgresql (16+257build1) ... 356s Selecting previously unselected package autopkgtest-satdep. 356s Preparing to unpack .../13-1-autopkgtest-satdep.deb ... 356s Unpacking autopkgtest-satdep (0) ... 356s Setting up postgresql-client-common (257build1) ... 356s Setting up libev4t64:arm64 (1:4.33-2.1build1) ... 356s Setting up libpq5:arm64 (16.2-1ubuntu4) ... 356s Setting up libcjson1:arm64 (1.7.17-1) ... 356s Setting up libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 356s Setting up ssl-cert (1.1.2ubuntu1) ... 357s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 357s Setting up libjson-perl (4.10000-1) ... 357s Setting up libxslt1.1:arm64 (1.1.39-0exp1build1) ... 357s Setting up postgresql-client-16 (16.2-1ubuntu4) ... 357s 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 357s Setting up postgresql-common (257build1) ... 358s 358s Creating config file /etc/postgresql-common/createcluster.conf with new version 358s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 358s Removing obsolete dictionary files: 358s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 359s Setting up postgresql-16 (16.2-1ubuntu4) ... 359s Creating new PostgreSQL cluster 16/main ... 359s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 359s The files belonging to this database system will be owned by user "postgres". 359s This user must also own the server process. 359s 359s The database cluster will be initialized with locale "C.UTF-8". 359s The default database encoding has accordingly been set to "UTF8". 359s The default text search configuration will be set to "english". 359s 359s Data page checksums are disabled. 359s 359s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 359s creating subdirectories ... ok 359s selecting dynamic shared memory implementation ... posix 359s selecting default max_connections ... 100 359s selecting default shared_buffers ... 128MB 359s selecting default time zone ... Etc/UTC 359s creating configuration files ... ok 359s running bootstrap script ... ok 360s performing post-bootstrap initialization ... ok 360s syncing data to disk ... ok 363s Setting up pgagroal (1.6.0-1build2) ... 363s Created symlink /etc/systemd/system/sockets.target.wants/pgagroal.socket → /usr/lib/systemd/system/pgagroal.socket. 363s Setting up postgresql (16+257build1) ... 363s Setting up autopkgtest-satdep (0) ... 363s Processing triggers for man-db (2.12.0-4build2) ... 364s Processing triggers for libc-bin (2.39-0ubuntu8.1) ... 366s (Reading database ... 79897 files and directories currently installed.) 366s Removing autopkgtest-satdep (0) ... 367s autopkgtest [04:23:46]: test connect: [----------------------- 367s + trap bailout EXIT 367s + service postgresql stop 368s + test -d /run/systemd/system 368s + systemctl start pgagroal.socket 368s + pg_virtualenv -oport=5432 368s Creating new PostgreSQL cluster 16/regress ... 371s + PW=agroalpass 371s + su -c '( echo agroalpass; echo agroalpass ) | createuser --pwprompt agroaltestuser' postgres 371s Enter password for new role: 371s Enter it again: 371s + PGPASSWORD=agroalpass 371s + grep 42 371s + psql -h /run/postgresql -p 2345 -U agroaltestuser -c 'select 6*7' postgres 371s 42 371s Dropping cluster 16/regress ... 372s + bailout 372s + test -d /run/systemd/system 372s + systemctl stop pgagroal pgagroal.socket 373s autopkgtest [04:23:52]: test connect: -----------------------] 373s connect PASS 373s autopkgtest [04:23:52]: test connect: - - - - - - - - - - results - - - - - - - - - - 374s autopkgtest [04:23:53]: @@@@@@@@@@@@@@@@@@@@ summary 374s connect PASS 387s Creating nova instance adt-oracular-arm64-pgagroal-20240501-041739-juju-7f2275-prod-proposed-migration-environment-2-2a297db7-b7f7-40e7-84f8-e20a076504bc from image adt/ubuntu-oracular-arm64-server-20240430.img (UUID fb6d8ea1-b7d1-4a36-a3b1-5cf77ba30c05)...