0s autopkgtest [00:39:28]: starting date and time: 2025-05-02 00:39:28+0000 0s autopkgtest [00:39:28]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [00:39:28]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.e2abuu_w/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:make-dfsg --apt-upgrade pgq --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=make-dfsg/4.4.1-2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-2.secgroup --name adt-questing-arm64-pgq-20250502-003928-juju-7f2275-prod-proposed-migration-environment-15-b451d578-936e-4ecf-a663-2457195f8f44 --image adt/ubuntu-questing-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 154s autopkgtest [00:42:02]: testbed dpkg architecture: arm64 155s autopkgtest [00:42:03]: testbed apt version: 3.0.0 155s autopkgtest [00:42:03]: @@@@@@@@@@@@@@@@@@@@ test bed setup 155s autopkgtest [00:42:03]: testbed release detected to be: None 156s autopkgtest [00:42:04]: updating testbed package index (apt update) 156s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 157s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 157s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 157s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 157s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 157s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2255 kB] 157s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [179 kB] 157s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [196 kB] 157s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [567 kB] 157s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [3024 B] 157s Fetched 3367 kB in 1s (2873 kB/s) 159s Reading package lists... 160s autopkgtest [00:42:08]: upgrading testbed (apt dist-upgrade and autopurge) 160s Reading package lists... 161s Building dependency tree... 161s Reading state information... 163s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 163s Starting 2 pkgProblemResolver with broken count: 0 163s Done 165s Entering ResolveByKeep 166s 166s Calculating upgrade... 168s The following packages will be upgraded: 168s dpkg dpkg-dev libdpkg-perl make 168s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 168s Need to get 2852 kB of archives. 168s After this operation, 1024 B of additional disk space will be used. 168s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 dpkg arm64 1.22.18ubuntu3 [1288 kB] 168s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 dpkg-dev all 1.22.18ubuntu3 [1089 kB] 168s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libdpkg-perl all 1.22.18ubuntu3 [281 kB] 168s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 make arm64 4.4.1-2 [194 kB] 169s Fetched 2852 kB in 1s (4132 kB/s) 170s (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 ... 117820 files and directories currently installed.) 170s Preparing to unpack .../dpkg_1.22.18ubuntu3_arm64.deb ... 170s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 170s Setting up dpkg (1.22.18ubuntu3) ... 170s (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 ... 117820 files and directories currently installed.) 170s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 170s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 170s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 170s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 170s Preparing to unpack .../make_4.4.1-2_arm64.deb ... 170s Unpacking make (4.4.1-2) over (4.4.1-1) ... 171s Setting up make (4.4.1-2) ... 171s Setting up libdpkg-perl (1.22.18ubuntu3) ... 171s Setting up dpkg-dev (1.22.18ubuntu3) ... 171s Processing triggers for man-db (2.13.0-1) ... 173s Reading package lists... 174s Building dependency tree... 174s Reading state information... 174s Starting pkgProblemResolver with broken count: 0 174s Starting 2 pkgProblemResolver with broken count: 0 174s Done 175s Solving dependencies... 175s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 176s autopkgtest [00:42:24]: rebooting testbed after setup commands that affected boot 200s autopkgtest [00:42:48]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 202s autopkgtest [00:42:50]: @@@@@@@@@@@@@@@@@@@@ apt-source pgq 204s Get:1 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (dsc) [2008 B] 204s Get:2 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (tar) [73.6 kB] 204s Get:3 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (diff) [2816 B] 204s gpgv: Signature made Thu Sep 12 09:58:42 2024 UTC 204s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 204s gpgv: Can't check signature: No public key 204s dpkg-source: warning: cannot verify inline signature for ./pgq_3.5-4.dsc: no acceptable signature found 204s autopkgtest [00:42:52]: testing package pgq version 3.5-4 205s autopkgtest [00:42:53]: build not needed 205s autopkgtest [00:42:53]: test installcheck: preparing testbed 205s Reading package lists... 206s Building dependency tree... 206s Reading state information... 206s Starting pkgProblemResolver with broken count: 0 206s Starting 2 pkgProblemResolver with broken count: 0 206s Done 207s The following NEW packages will be installed: 207s libevent-2.1-7t64 libio-pty-perl libipc-run-perl libjson-perl libllvm20 207s libpq5 libxslt1.1 pgqd postgresql-17 postgresql-17-pgq3 postgresql-client-17 207s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 207s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 207s Need to get 47.1 MB of archives. 207s After this operation, 200 MB of additional disk space will be used. 207s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 207s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-common all 274 [47.6 kB] 207s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 207s Get:4 http://ftpmaster.internal/ubuntu questing/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 207s Get:5 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common-dev all 274 [73.0 kB] 207s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 207s Get:7 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common all 274 [101 kB] 208s Get:8 http://ftpmaster.internal/ubuntu questing/main arm64 libevent-2.1-7t64 arm64 2.1.12-stable-10 [140 kB] 208s Get:9 http://ftpmaster.internal/ubuntu questing/main arm64 libpq5 arm64 17.4-1 [142 kB] 208s Get:10 http://ftpmaster.internal/ubuntu questing/universe arm64 pgqd arm64 3.5-2 [28.6 kB] 208s Get:11 http://ftpmaster.internal/ubuntu questing/main arm64 libllvm20 arm64 1:20.1.2-0ubuntu1 [29.1 MB] 208s Get:12 http://ftpmaster.internal/ubuntu questing/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu4 [168 kB] 208s Get:13 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 208s Get:14 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 209s Get:15 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-17-pgq3 arm64 3.5-4 [130 kB] 209s Preconfiguring packages ... 209s Fetched 47.1 MB in 2s (27.8 MB/s) 209s Selecting previously unselected package libjson-perl. 210s (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 ... 117820 files and directories currently installed.) 210s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 210s Unpacking libjson-perl (4.10000-1) ... 210s Selecting previously unselected package postgresql-client-common. 210s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 210s Unpacking postgresql-client-common (274) ... 210s Selecting previously unselected package libio-pty-perl. 210s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 210s Unpacking libio-pty-perl (1:1.20-1build3) ... 210s Selecting previously unselected package libipc-run-perl. 210s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 210s Unpacking libipc-run-perl (20231003.0-2) ... 210s Selecting previously unselected package postgresql-common-dev. 210s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 210s Unpacking postgresql-common-dev (274) ... 210s Selecting previously unselected package ssl-cert. 210s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 210s Unpacking ssl-cert (1.1.3ubuntu1) ... 210s Selecting previously unselected package postgresql-common. 210s Preparing to unpack .../06-postgresql-common_274_all.deb ... 210s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 210s Unpacking postgresql-common (274) ... 210s Selecting previously unselected package libevent-2.1-7t64:arm64. 210s Preparing to unpack .../07-libevent-2.1-7t64_2.1.12-stable-10_arm64.deb ... 210s Unpacking libevent-2.1-7t64:arm64 (2.1.12-stable-10) ... 210s Selecting previously unselected package libpq5:arm64. 210s Preparing to unpack .../08-libpq5_17.4-1_arm64.deb ... 210s Unpacking libpq5:arm64 (17.4-1) ... 210s Selecting previously unselected package pgqd. 210s Preparing to unpack .../09-pgqd_3.5-2_arm64.deb ... 210s Unpacking pgqd (3.5-2) ... 210s Selecting previously unselected package libllvm20:arm64. 210s Preparing to unpack .../10-libllvm20_1%3a20.1.2-0ubuntu1_arm64.deb ... 210s Unpacking libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 211s Selecting previously unselected package libxslt1.1:arm64. 211s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu4_arm64.deb ... 211s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 211s Selecting previously unselected package postgresql-client-17. 211s Preparing to unpack .../12-postgresql-client-17_17.4-1_arm64.deb ... 211s Unpacking postgresql-client-17 (17.4-1) ... 212s Selecting previously unselected package postgresql-17. 212s Preparing to unpack .../13-postgresql-17_17.4-1_arm64.deb ... 212s Unpacking postgresql-17 (17.4-1) ... 212s Selecting previously unselected package postgresql-17-pgq3. 212s Preparing to unpack .../14-postgresql-17-pgq3_3.5-4_arm64.deb ... 212s Unpacking postgresql-17-pgq3 (3.5-4) ... 212s Setting up postgresql-client-common (274) ... 212s Setting up libio-pty-perl (1:1.20-1build3) ... 212s Setting up libpq5:arm64 (17.4-1) ... 212s Setting up libevent-2.1-7t64:arm64 (2.1.12-stable-10) ... 212s Setting up ssl-cert (1.1.3ubuntu1) ... 213s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 213s Setting up libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 213s Setting up libipc-run-perl (20231003.0-2) ... 213s Setting up libjson-perl (4.10000-1) ... 213s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 213s Setting up postgresql-common-dev (274) ... 213s Setting up postgresql-client-17 (17.4-1) ... 214s 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 214s Setting up postgresql-common (274) ... 214s Creating config file /etc/postgresql-common/createcluster.conf with new version 214s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 214s Removing obsolete dictionary files: 215s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 215s Setting up pgqd (3.5-2) ... 216s Created symlink '/etc/systemd/system/multi-user.target.wants/pgqd.service' → '/usr/lib/systemd/system/pgqd.service'. 216s Setting up postgresql-17 (17.4-1) ... 217s Creating new PostgreSQL cluster 17/main ... 217s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 217s The files belonging to this database system will be owned by user "postgres". 217s This user must also own the server process. 217s 217s The database cluster will be initialized with locale "C.UTF-8". 217s The default database encoding has accordingly been set to "UTF8". 217s The default text search configuration will be set to "english". 217s 217s Data page checksums are disabled. 217s 217s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 217s creating subdirectories ... ok 217s selecting dynamic shared memory implementation ... posix 217s selecting default "max_connections" ... 100 217s selecting default "shared_buffers" ... 128MB 217s selecting default time zone ... Etc/UTC 217s creating configuration files ... ok 217s running bootstrap script ... ok 218s performing post-bootstrap initialization ... ok 218s syncing data to disk ... ok 221s Setting up postgresql-17-pgq3 (3.5-4) ... 221s Processing triggers for man-db (2.13.0-1) ... 223s Processing triggers for libc-bin (2.41-6ubuntu1) ... 224s autopkgtest [00:43:12]: test installcheck: [----------------------- 224s ### PostgreSQL 17 installcheck ### 224s Creating new PostgreSQL cluster 17/regress ... 227s python3 mk/grantfu.py -r -d structure/grants.ini > structure/newgrants_pgq.sql 227s 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_init_ext pgq_core pgq_core_disabled pgq_core_tx_limit pgq_session_role pgq_perms trigger_base trigger_sess_role trigger_types trigger_trunc trigger_ignore trigger_pkey trigger_deny trigger_when trigger_extra_args trigger_extra_cols trigger_backup clean_ext pgq_init_ext switch_plonly pgq_core pgq_core_disabled pgq_session_role pgq_perms trigger_base trigger_sess_role trigger_types trigger_trunc trigger_ignore trigger_pkey trigger_deny trigger_when trigger_extra_args trigger_extra_cols trigger_backup 227s # +++ regress install-check in +++ 227s # using postmaster on localhost, port 5433 227s ok 1 - pgq_init_ext 124 ms 227s ok 2 - pgq_core 111 ms 227s ok 3 - pgq_core_disabled 41 ms 228s ok 4 - pgq_core_tx_limit 45 ms 228s ok 5 - pgq_session_role 65 ms 228s ok 6 - pgq_perms 92 ms 228s ok 7 - trigger_base 42 ms 228s ok 8 - trigger_sess_role 91 ms 228s ok 9 - trigger_types 91 ms 228s ok 10 - trigger_trunc 44 ms 228s ok 11 - trigger_ignore 22 ms 228s ok 12 - trigger_pkey 24 ms 228s ok 13 - trigger_deny 27 ms 228s ok 14 - trigger_when 23 ms 228s ok 15 - trigger_extra_args 22 ms 228s ok 16 - trigger_extra_cols 21 ms 228s ok 17 - trigger_backup 21 ms 228s ok 18 - clean_ext 19 ms 228s ok 19 - pgq_init_ext 150 ms 228s ok 20 - switch_plonly 21 ms 229s ok 21 - pgq_core 129 ms 229s ok 22 - pgq_core_disabled 42 ms 229s ok 23 - pgq_session_role 64 ms 229s ok 24 - pgq_perms 95 ms 229s ok 25 - trigger_base 80 ms 229s ok 26 - trigger_sess_role 94 ms 229s ok 27 - trigger_types 508 ms 229s ok 28 - trigger_trunc 51 ms 230s ok 29 - trigger_ignore 48 ms 230s ok 30 - trigger_pkey 38 ms 230s ok 31 - trigger_deny 35 ms 230s ok 32 - trigger_when 38 ms 230s ok 33 - trigger_extra_args 44 ms 230s ok 34 - trigger_extra_cols 43 ms 230s ok 35 - trigger_backup 34 ms 230s 1..35 230s # All 35 tests passed. 230s Dropping cluster 17/regress ... 230s rm -rf docs/html docs/Data docs/sql 230s for dir in lowlevel triggers; do \ 230s make -C $dir clean \ 230s DESTDIR= \ 230s PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config \ 230s || exit 1; \ 230s done 230s make[1]: Entering directory '/tmp/autopkgtest.RNGLhE/build.4kV/src/lowlevel' 230s rm -f pgq_lowlevel.so libpgq_lowlevel.a libpgq_lowlevel.pc 230s rm -f insert_event.o insert_event.bc 230s make[1]: Leaving directory '/tmp/autopkgtest.RNGLhE/build.4kV/src/lowlevel' 230s make[1]: Entering directory '/tmp/autopkgtest.RNGLhE/build.4kV/src/triggers' 230s rm -f pgq_triggers.so libpgq_triggers.a libpgq_triggers.pc 230s rm -f logtriga.o logutriga.o sqltriga.o jsontriga.o common.o makesql.o stringutil.o parsesql.o qbuilder.o logtriga.bc logutriga.bc sqltriga.bc jsontriga.bc common.bc makesql.bc stringutil.bc parsesql.bc qbuilder.bc 230s make[1]: Leaving directory '/tmp/autopkgtest.RNGLhE/build.4kV/src/triggers' 230s rm -f pgq--3.5.sql pgq--unpackaged--3.5.sql pgq--3.2--3.5.sql pgq--3.2.3--3.5.sql pgq--3.2.6--3.5.sql pgq--3.3.1--3.5.sql pgq--3.4--3.5.sql pgq--3.4.1--3.5.sql pgq--3.4.2--3.5.sql 230s rm -rf pgq_pl_only.sql pgq_pl_only.upgrade.sql pgq.sql pgq.upgrade.sql structure/newgrants_pgq.sql structure/oldgrants_pgq.sql test.dump 230s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 230s ### End 17 installcheck ### 230s autopkgtest [00:43:18]: test installcheck: -----------------------] 231s installcheck PASS 231s autopkgtest [00:43:19]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 231s autopkgtest [00:43:19]: @@@@@@@@@@@@@@@@@@@@ summary 231s installcheck PASS 236s nova [W] Using flock in prodstack6-arm64 236s Creating nova instance adt-questing-arm64-pgq-20250502-003928-juju-7f2275-prod-proposed-migration-environment-15-b451d578-936e-4ecf-a663-2457195f8f44 from image adt/ubuntu-questing-arm64-server-20250501.img (UUID a16a0402-3b0c-4b8f-ba85-1dd4107760ca)... 236s nova [W] Timed out waiting for 00cdc1f5-c940-4b99-a799-c04f85797961 to get deleted.