0s autopkgtest [23:25:42]: starting date and time: 2024-11-03 23:25:42+0000 0s autopkgtest [23:25:42]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [23:25:42]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.rscqjwe6/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:pgq-node,src:pgq --apt-upgrade pgq-node --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=pgq-node/3.5-7 pgq/3.5-4' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@lcy02-36.secgroup --name adt-plucky-amd64-pgq-node-20241103-232542-juju-7f2275-prod-proposed-migration-environment-15-e015c2a6-c8cb-4a78-b86b-7af8d50cbf1d --image adt/ubuntu-plucky-amd64-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/ 46s autopkgtest [23:26:28]: testbed dpkg architecture: amd64 46s autopkgtest [23:26:28]: testbed apt version: 2.9.8 46s autopkgtest [23:26:28]: @@@@@@@@@@@@@@@@@@@@ test bed setup 46s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 46s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [2268 kB] 46s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [177 kB] 46s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [31.2 kB] 46s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 46s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [165 kB] 46s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [238 kB] 46s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [32.6 kB] 46s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [1715 kB] 47s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [833 kB] 47s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [58.6 kB] 47s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [18.1 kB] 47s Fetched 5618 kB in 1s (8229 kB/s) 47s Reading package lists... 49s Reading package lists... 49s Building dependency tree... 49s Reading state information... 50s Calculating upgrade... 50s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 50s Reading package lists... 50s Building dependency tree... 50s Reading state information... 51s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 51s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 51s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 51s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 51s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 53s Reading package lists... 53s Reading package lists... 53s Building dependency tree... 53s Reading state information... 53s Calculating upgrade... 54s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 54s Reading package lists... 54s Building dependency tree... 54s Reading state information... 55s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 55s autopkgtest [23:26:37]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 55s autopkgtest [23:26:37]: @@@@@@@@@@@@@@@@@@@@ apt-source pgq-node 56s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/universe pgq-node 3.5-7 (dsc) [2009 B] 56s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe pgq-node 3.5-7 (tar) [27.2 kB] 56s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe pgq-node 3.5-7 (diff) [2488 B] 56s gpgv: Signature made Thu Sep 19 08:19:35 2024 UTC 56s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 56s gpgv: Can't check signature: No public key 56s dpkg-source: warning: cannot verify inline signature for ./pgq-node_3.5-7.dsc: no acceptable signature found 56s autopkgtest [23:26:38]: testing package pgq-node version 3.5-7 57s autopkgtest [23:26:39]: build not needed 57s autopkgtest [23:26:39]: test installcheck: preparing testbed 57s Reading package lists... 57s Building dependency tree... 57s Reading state information... 58s Starting pkgProblemResolver with broken count: 0 58s Starting 2 pkgProblemResolver with broken count: 0 58s Done 59s The following additional packages will be installed: 59s libevent-2.1-7t64 libjson-perl libpq5 libxslt1.1 pgqd postgresql-17 59s postgresql-17-pgq-node postgresql-17-pgq3 postgresql-client-17 59s postgresql-client-common postgresql-common ssl-cert 59s Suggested packages: 59s postgresql-doc-17 59s Recommended packages: 59s libjson-xs-perl 59s The following NEW packages will be installed: 59s autopkgtest-satdep libevent-2.1-7t64 libjson-perl libpq5 libxslt1.1 pgqd 59s postgresql-17 postgresql-17-pgq-node postgresql-17-pgq3 postgresql-client-17 59s postgresql-client-common postgresql-common ssl-cert 59s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 59s Need to get 21.1 MB/21.1 MB of archives. 59s After this operation, 74.6 MB of additional disk space will be used. 59s Get:1 /tmp/autopkgtest.KWLGSs/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [720 B] 59s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 59s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 59s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 59s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 59s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libevent-2.1-7t64 amd64 2.1.12-stable-10 [144 kB] 59s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.0-1 [249 kB] 59s Get:8 http://ftpmaster.internal/ubuntu plucky/universe amd64 pgqd amd64 3.5-2 [28.5 kB] 59s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 59s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.0-1 [2111 kB] 59s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.0-1 [17.9 MB] 59s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-pgq3 amd64 3.5-4 [132 kB] 59s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-pgq-node all 3.5-7 [12.9 kB] 59s Preconfiguring packages ... 60s Fetched 21.1 MB in 0s (73.7 MB/s) 60s Selecting previously unselected package libjson-perl. 60s (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 ... 75323 files and directories currently installed.) 60s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 60s Unpacking libjson-perl (4.10000-1) ... 60s Selecting previously unselected package postgresql-client-common. 60s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 60s Unpacking postgresql-client-common (262) ... 60s Selecting previously unselected package ssl-cert. 60s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 60s Unpacking ssl-cert (1.1.2ubuntu2) ... 60s Selecting previously unselected package postgresql-common. 60s Preparing to unpack .../03-postgresql-common_262_all.deb ... 60s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 60s Unpacking postgresql-common (262) ... 60s Selecting previously unselected package libevent-2.1-7t64:amd64. 60s Preparing to unpack .../04-libevent-2.1-7t64_2.1.12-stable-10_amd64.deb ... 60s Unpacking libevent-2.1-7t64:amd64 (2.1.12-stable-10) ... 60s Selecting previously unselected package libpq5:amd64. 60s Preparing to unpack .../05-libpq5_17.0-1_amd64.deb ... 60s Unpacking libpq5:amd64 (17.0-1) ... 60s Selecting previously unselected package pgqd. 60s Preparing to unpack .../06-pgqd_3.5-2_amd64.deb ... 60s Unpacking pgqd (3.5-2) ... 60s Selecting previously unselected package libxslt1.1:amd64. 60s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 60s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 60s Selecting previously unselected package postgresql-client-17. 60s Preparing to unpack .../08-postgresql-client-17_17.0-1_amd64.deb ... 60s Unpacking postgresql-client-17 (17.0-1) ... 60s Selecting previously unselected package postgresql-17. 60s Preparing to unpack .../09-postgresql-17_17.0-1_amd64.deb ... 60s Unpacking postgresql-17 (17.0-1) ... 61s Selecting previously unselected package postgresql-17-pgq3. 61s Preparing to unpack .../10-postgresql-17-pgq3_3.5-4_amd64.deb ... 61s Unpacking postgresql-17-pgq3 (3.5-4) ... 61s Selecting previously unselected package postgresql-17-pgq-node. 61s Preparing to unpack .../11-postgresql-17-pgq-node_3.5-7_all.deb ... 61s Unpacking postgresql-17-pgq-node (3.5-7) ... 61s Selecting previously unselected package autopkgtest-satdep. 61s Preparing to unpack .../12-1-autopkgtest-satdep.deb ... 61s Unpacking autopkgtest-satdep (0) ... 61s Setting up postgresql-client-common (262) ... 61s Setting up libpq5:amd64 (17.0-1) ... 61s Setting up libevent-2.1-7t64:amd64 (2.1.12-stable-10) ... 61s Setting up ssl-cert (1.1.2ubuntu2) ... 62s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 62s Setting up libjson-perl (4.10000-1) ... 62s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 62s Setting up postgresql-client-17 (17.0-1) ... 63s 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 63s Setting up postgresql-common (262) ... 63s 63s Creating config file /etc/postgresql-common/createcluster.conf with new version 63s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 63s Removing obsolete dictionary files: 64s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 65s Setting up pgqd (3.5-2) ... 65s Created symlink '/etc/systemd/system/multi-user.target.wants/pgqd.service' → '/usr/lib/systemd/system/pgqd.service'. 66s Setting up postgresql-17 (17.0-1) ... 66s Creating new PostgreSQL cluster 17/main ... 66s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 66s The files belonging to this database system will be owned by user "postgres". 66s This user must also own the server process. 66s 66s The database cluster will be initialized with locale "C.UTF-8". 66s The default database encoding has accordingly been set to "UTF8". 66s The default text search configuration will be set to "english". 66s 66s Data page checksums are disabled. 66s 66s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 66s creating subdirectories ... ok 66s selecting dynamic shared memory implementation ... posix 66s selecting default "max_connections" ... 100 66s selecting default "shared_buffers" ... 128MB 66s selecting default time zone ... Etc/UTC 66s creating configuration files ... ok 66s running bootstrap script ... ok 67s performing post-bootstrap initialization ... ok 67s syncing data to disk ... ok 71s Setting up postgresql-17-pgq3 (3.5-4) ... 71s Setting up postgresql-17-pgq-node (3.5-7) ... 71s Setting up autopkgtest-satdep (0) ... 71s Processing triggers for man-db (2.12.1-3) ... 72s Processing triggers for libc-bin (2.40-1ubuntu3) ... 74s (Reading database ... 77767 files and directories currently installed.) 74s Removing autopkgtest-satdep (0) ... 74s autopkgtest [23:26:56]: test installcheck: [----------------------- 74s ### PostgreSQL 17 installcheck ### 74s Creating new PostgreSQL cluster 17/regress ... 78s echo "# +++ regress install-check in +++" && /usr/lib/postgresql/17/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/17/bin' --dbname=regression --dbname=regression pgq_node_init_ext pgq_node_test 78s # +++ regress install-check in +++ 78s # using postmaster on localhost, port 5433 78s ok 1 - pgq_node_init_ext 81 ms 78s ok 2 - pgq_node_test 135 ms 78s 1..2 78s # All 2 tests passed. 78s Dropping cluster 17/regress ... 78s rm -rf docs/html docs/Data docs/sql 78s rm -f pgq_node--3.5.sql pgq_node--unpackaged--3.5.sql pgq_node--3.2--3.5.sql pgq_node--3.2.5--3.5.sql pgq_node--3.3.1--3.5.sql pgq_node--3.4--3.5.sql 78s rm -rf pgq_node.sql pgq_node.upgrade.sql structure/newgrants_pgq_node.sql structure/oldgrants_pgq_node.sql test.dump 78s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 78s ### End 17 installcheck ### 78s autopkgtest [23:27:00]: test installcheck: -----------------------] 79s autopkgtest [23:27:01]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 79s installcheck PASS 79s autopkgtest [23:27:01]: @@@@@@@@@@@@@@@@@@@@ summary 79s installcheck PASS 95s nova [W] Skipping flock for amd64 95s Creating nova instance adt-plucky-amd64-pgq-node-20241103-232542-juju-7f2275-prod-proposed-migration-environment-15-e015c2a6-c8cb-4a78-b86b-7af8d50cbf1d from image adt/ubuntu-plucky-amd64-server-20241103.img (UUID 35ab818c-a1b8-49b0-b1ec-61e6c5b42b5f)...