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