0s autopkgtest [03:19:25]: starting date and time: 2025-05-02 03:19:25+0000 0s autopkgtest [03:19:25]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [03:19:25]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ipeetj_x/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-cpu2-ram4-disk20-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@sto01-s390x-6.secgroup --name adt-questing-s390x-pgq-20250502-031924-juju-7f2275-prod-proposed-migration-environment-2-f64bbb9b-191e-4576-80bb-34badc4c031d --image adt/ubuntu-questing-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-autopkgtest-workers-s390x -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 146s autopkgtest [03:21:51]: testbed dpkg architecture: s390x 147s autopkgtest [03:21:52]: testbed apt version: 3.0.0 147s autopkgtest [03:21:52]: @@@@@@@@@@@@@@@@@@@@ test bed setup 147s autopkgtest [03:21:52]: testbed release detected to be: None 148s autopkgtest [03:21:53]: updating testbed package index (apt update) 148s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 148s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 148s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 148s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 148s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2281 kB] 154s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [190 kB] 154s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 154s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main s390x Packages [216 kB] 154s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x Packages [1061 kB] 155s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse s390x Packages [15.9 kB] 157s Fetched 3931 kB in 9s (454 kB/s) 161s Reading package lists... 164s autopkgtest [03:22:09]: upgrading testbed (apt dist-upgrade and autopurge) 164s Reading package lists... 166s Building dependency tree... 166s Reading state information... 167s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 167s Starting 2 pkgProblemResolver with broken count: 0 167s Done 170s Entering ResolveByKeep 171s 172s Calculating upgrade... 173s The following packages will be upgraded: 173s libperl5.40 make perl perl-base perl-modules-5.40 173s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 173s Need to get 10.6 MB of archives. 173s After this operation, 8192 B disk space will be freed. 173s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main s390x libperl5.40 s390x 5.40.1-3 [4972 kB] 179s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main s390x perl s390x 5.40.1-3 [262 kB] 179s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main s390x perl-base s390x 5.40.1-3 [1954 kB] 181s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main s390x perl-modules-5.40 all 5.40.1-3 [3217 kB] 185s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main s390x make s390x 4.4.1-2 [214 kB] 186s Fetched 10.6 MB in 12s (894 kB/s) 187s (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 ... 59826 files and directories currently installed.) 187s Preparing to unpack .../libperl5.40_5.40.1-3_s390x.deb ... 187s Unpacking libperl5.40:s390x (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 187s Preparing to unpack .../perl_5.40.1-3_s390x.deb ... 187s Unpacking perl (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 187s Preparing to unpack .../perl-base_5.40.1-3_s390x.deb ... 187s Unpacking perl-base (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 188s Setting up perl-base (5.40.1-3) ... 189s (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 ... 59826 files and directories currently installed.) 189s Preparing to unpack .../perl-modules-5.40_5.40.1-3_all.deb ... 189s Unpacking perl-modules-5.40 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 192s Preparing to unpack .../make_4.4.1-2_s390x.deb ... 192s Unpacking make (4.4.1-2) over (4.4.1-1) ... 192s Setting up make (4.4.1-2) ... 192s Setting up perl-modules-5.40 (5.40.1-3) ... 192s Setting up libperl5.40:s390x (5.40.1-3) ... 192s Setting up perl (5.40.1-3) ... 192s Processing triggers for man-db (2.13.0-1) ... 195s Processing triggers for libc-bin (2.41-6ubuntu1) ... 196s Reading package lists... 196s Building dependency tree... 196s Reading state information... 198s Starting pkgProblemResolver with broken count: 0 198s Starting 2 pkgProblemResolver with broken count: 0 198s Done 199s Solving dependencies... 200s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 206s autopkgtest [03:22:51]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 13:39:00 UTC 2025 207s autopkgtest [03:22:52]: @@@@@@@@@@@@@@@@@@@@ apt-source pgq 212s Get:1 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (dsc) [2008 B] 212s Get:2 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (tar) [73.6 kB] 212s Get:3 http://ftpmaster.internal/ubuntu questing/universe pgq 3.5-4 (diff) [2816 B] 213s gpgv: Signature made Thu Sep 12 09:58:42 2024 UTC 213s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 213s gpgv: Can't check signature: No public key 213s dpkg-source: warning: cannot verify inline signature for ./pgq_3.5-4.dsc: no acceptable signature found 213s autopkgtest [03:22:58]: testing package pgq version 3.5-4 213s autopkgtest [03:22:58]: build not needed 214s autopkgtest [03:22:59]: test installcheck: preparing testbed 215s Reading package lists... 216s Building dependency tree... 216s Reading state information... 217s Starting pkgProblemResolver with broken count: 0 217s Starting 2 pkgProblemResolver with broken count: 0 217s Done 218s The following NEW packages will be installed: 218s libevent-2.1-7t64 libio-pty-perl libipc-run-perl libjson-perl libllvm20 218s libpq5 libxslt1.1 pgqd postgresql-17 postgresql-17-pgq3 postgresql-client-17 218s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 218s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 218s Need to get 50.1 MB of archives. 218s After this operation, 215 MB of additional disk space will be used. 218s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x libjson-perl all 4.10000-1 [81.9 kB] 218s Get:2 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-common all 274 [47.6 kB] 218s Get:3 http://ftpmaster.internal/ubuntu questing/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 218s Get:4 http://ftpmaster.internal/ubuntu questing/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 218s Get:5 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common-dev all 274 [73.0 kB] 218s Get:6 http://ftpmaster.internal/ubuntu questing/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 218s Get:7 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-common all 274 [101 kB] 218s Get:8 http://ftpmaster.internal/ubuntu questing/main s390x libevent-2.1-7t64 s390x 2.1.12-stable-10 [145 kB] 218s Get:9 http://ftpmaster.internal/ubuntu questing/main s390x libpq5 s390x 17.4-1 [147 kB] 218s Get:10 http://ftpmaster.internal/ubuntu questing/universe s390x pgqd s390x 3.5-2 [29.0 kB] 218s Get:11 http://ftpmaster.internal/ubuntu questing/main s390x libllvm20 s390x 1:20.1.2-0ubuntu1 [31.4 MB] 259s Get:12 http://ftpmaster.internal/ubuntu questing/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu4 [170 kB] 259s Get:13 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 261s Get:14 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 281s Get:15 http://ftpmaster.internal/ubuntu questing/universe s390x postgresql-17-pgq3 s390x 3.5-4 [132 kB] 282s Preconfiguring packages ... 284s Fetched 50.1 MB in 1min 3s (802 kB/s) 284s Selecting previously unselected package libjson-perl. 284s (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 ... 59826 files and directories currently installed.) 284s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 284s Unpacking libjson-perl (4.10000-1) ... 285s Selecting previously unselected package postgresql-client-common. 285s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 285s Unpacking postgresql-client-common (274) ... 285s Selecting previously unselected package libio-pty-perl. 285s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 285s Unpacking libio-pty-perl (1:1.20-1build3) ... 286s Selecting previously unselected package libipc-run-perl. 286s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 286s Unpacking libipc-run-perl (20231003.0-2) ... 286s Selecting previously unselected package postgresql-common-dev. 286s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 286s Unpacking postgresql-common-dev (274) ... 286s Selecting previously unselected package ssl-cert. 286s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 286s Unpacking ssl-cert (1.1.3ubuntu1) ... 286s Selecting previously unselected package postgresql-common. 286s Preparing to unpack .../06-postgresql-common_274_all.deb ... 286s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 286s Unpacking postgresql-common (274) ... 286s Selecting previously unselected package libevent-2.1-7t64:s390x. 286s Preparing to unpack .../07-libevent-2.1-7t64_2.1.12-stable-10_s390x.deb ... 286s Unpacking libevent-2.1-7t64:s390x (2.1.12-stable-10) ... 287s Selecting previously unselected package libpq5:s390x. 287s Preparing to unpack .../08-libpq5_17.4-1_s390x.deb ... 287s Unpacking libpq5:s390x (17.4-1) ... 287s Selecting previously unselected package pgqd. 287s Preparing to unpack .../09-pgqd_3.5-2_s390x.deb ... 287s Unpacking pgqd (3.5-2) ... 288s Selecting previously unselected package libllvm20:s390x. 288s Preparing to unpack .../10-libllvm20_1%3a20.1.2-0ubuntu1_s390x.deb ... 288s Unpacking libllvm20:s390x (1:20.1.2-0ubuntu1) ... 295s Selecting previously unselected package libxslt1.1:s390x. 295s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu4_s390x.deb ... 295s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu4) ... 295s Selecting previously unselected package postgresql-client-17. 295s Preparing to unpack .../12-postgresql-client-17_17.4-1_s390x.deb ... 295s Unpacking postgresql-client-17 (17.4-1) ... 296s Selecting previously unselected package postgresql-17. 296s Preparing to unpack .../13-postgresql-17_17.4-1_s390x.deb ... 296s Unpacking postgresql-17 (17.4-1) ... 301s Selecting previously unselected package postgresql-17-pgq3. 301s Preparing to unpack .../14-postgresql-17-pgq3_3.5-4_s390x.deb ... 301s Unpacking postgresql-17-pgq3 (3.5-4) ... 301s Setting up postgresql-client-common (274) ... 301s Setting up libio-pty-perl (1:1.20-1build3) ... 301s Setting up libpq5:s390x (17.4-1) ... 301s Setting up libevent-2.1-7t64:s390x (2.1.12-stable-10) ... 301s Setting up ssl-cert (1.1.3ubuntu1) ... 305s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 307s Setting up libllvm20:s390x (1:20.1.2-0ubuntu1) ... 307s Setting up libipc-run-perl (20231003.0-2) ... 307s Setting up libjson-perl (4.10000-1) ... 307s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu4) ... 307s Setting up postgresql-common-dev (274) ... 307s Setting up postgresql-client-17 (17.4-1) ... 309s 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 309s Setting up postgresql-common (274) ... 311s Creating config file /etc/postgresql-common/createcluster.conf with new version 311s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 311s Removing obsolete dictionary files: 313s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 315s Setting up pgqd (3.5-2) ... 317s Created symlink '/etc/systemd/system/multi-user.target.wants/pgqd.service' → '/usr/lib/systemd/system/pgqd.service'. 319s Setting up postgresql-17 (17.4-1) ... 324s Creating new PostgreSQL cluster 17/main ... 324s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 325s The files belonging to this database system will be owned by user "postgres". 325s This user must also own the server process. 325s 325s The database cluster will be initialized with locale "C.UTF-8". 325s The default database encoding has accordingly been set to "UTF8". 325s The default text search configuration will be set to "english". 325s 325s Data page checksums are disabled. 325s 325s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 325s creating subdirectories ... ok 325s selecting dynamic shared memory implementation ... posix 325s selecting default "max_connections" ... 100 325s selecting default "shared_buffers" ... 128MB 325s selecting default time zone ... Etc/UTC 325s creating configuration files ... ok 326s running bootstrap script ... ok 331s performing post-bootstrap initialization ... ok 331s syncing data to disk ... ok 340s Setting up postgresql-17-pgq3 (3.5-4) ... 340s Processing triggers for man-db (2.13.0-1) ... 345s Processing triggers for libc-bin (2.41-6ubuntu1) ... 348s autopkgtest [03:25:13]: test installcheck: [----------------------- 348s ### PostgreSQL 17 installcheck ### 349s Creating new PostgreSQL cluster 17/regress ... 357s python3 mk/grantfu.py -r -d structure/grants.ini > structure/newgrants_pgq.sql 358s 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 358s # +++ regress install-check in +++ 358s # using postmaster on localhost, port 5433 359s ok 1 - pgq_init_ext 764 ms 359s ok 2 - pgq_core 182 ms 360s ok 3 - pgq_core_disabled 424 ms 360s ok 4 - pgq_core_tx_limit 75 ms 360s ok 5 - pgq_session_role 340 ms 360s ok 6 - pgq_perms 353 ms 360s ok 7 - trigger_base 101 ms 361s ok 8 - trigger_sess_role 706 ms 362s ok 9 - trigger_types 427 ms 362s ok 10 - trigger_trunc 79 ms 362s ok 11 - trigger_ignore 56 ms 362s ok 12 - trigger_pkey 8 ms 362s ok 13 - trigger_deny 10 ms 362s ok 14 - trigger_when 20 ms 362s ok 15 - trigger_extra_args 90 ms 362s ok 16 - trigger_extra_cols 20 ms 362s ok 17 - trigger_backup 15 ms 362s ok 18 - clean_ext 12 ms 362s ok 19 - pgq_init_ext 221 ms 362s ok 20 - switch_plonly 18 ms 363s ok 21 - pgq_core 600 ms 363s ok 22 - pgq_core_disabled 187 ms 364s ok 23 - pgq_session_role 605 ms 364s ok 24 - pgq_perms 503 ms 364s ok 25 - trigger_base 154 ms 365s ok 26 - trigger_sess_role 162 ms 367s ok 27 - trigger_types 2647 ms 367s ok 28 - trigger_trunc 100 ms 368s ok 29 - trigger_ignore 529 ms 368s ok 30 - trigger_pkey 317 ms 369s ok 31 - trigger_deny 153 ms 369s ok 32 - trigger_when 18 ms 369s ok 33 - trigger_extra_args 21 ms 369s ok 34 - trigger_extra_cols 292 ms 369s ok 35 - trigger_backup 52 ms 369s 1..35 369s # All 35 tests passed. 369s Dropping cluster 17/regress ... 370s rm -rf docs/html docs/Data docs/sql 370s for dir in lowlevel triggers; do \ 370s make -C $dir clean \ 370s DESTDIR= \ 370s PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config \ 370s || exit 1; \ 370s done 370s make[1]: Entering directory '/tmp/autopkgtest.eGe31i/build.kTd/src/lowlevel' 371s rm -f pgq_lowlevel.so libpgq_lowlevel.a libpgq_lowlevel.pc 371s rm -f insert_event.o insert_event.bc 371s make[1]: Leaving directory '/tmp/autopkgtest.eGe31i/build.kTd/src/lowlevel' 371s make[1]: Entering directory '/tmp/autopkgtest.eGe31i/build.kTd/src/triggers' 371s rm -f pgq_triggers.so libpgq_triggers.a libpgq_triggers.pc 371s 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 371s make[1]: Leaving directory '/tmp/autopkgtest.eGe31i/build.kTd/src/triggers' 371s 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 371s 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 371s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 371s ### End 17 installcheck ### 372s autopkgtest [03:25:37]: test installcheck: -----------------------] 372s installcheck PASS 372s autopkgtest [03:25:37]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 373s autopkgtest [03:25:38]: @@@@@@@@@@@@@@@@@@@@ summary 373s installcheck PASS 388s nova [W] Using flock in prodstack7-s390x 388s Creating nova instance adt-questing-s390x-pgq-20250502-031924-juju-7f2275-prod-proposed-migration-environment-2-f64bbb9b-191e-4576-80bb-34badc4c031d from image adt/ubuntu-questing-s390x-server-20250501.img (UUID 2a693762-e567-4bbe-9838-630e77f0775f)... 388s nova [W] Timed out waiting for b1bad19b-802b-41ef-a811-3941bd6f8230 to get deleted.