0s autopkgtest [06:09:41]: starting date and time: 2025-05-02 06:09:41+0000 0s autopkgtest [06:09:41]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [06:09:41]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.iu7h132r/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade pspg --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/277 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-s390x-2.secgroup --name adt-questing-s390x-pspg-20250502-060941-juju-7f2275-prod-proposed-migration-environment-20-73775afe-1297-48bb-a631-046e5eea9400 --image adt/ubuntu-questing-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-s390x -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 85s autopkgtest [06:11:06]: testbed dpkg architecture: s390x 85s autopkgtest [06:11:06]: testbed apt version: 3.0.0 86s autopkgtest [06:11:07]: @@@@@@@@@@@@@@@@@@@@ test bed setup 86s autopkgtest [06:11:07]: testbed release detected to be: None 86s autopkgtest [06:11:07]: updating testbed package index (apt update) 87s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 87s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 87s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 87s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 87s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [184 kB] 87s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2202 kB] 88s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 88s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main s390x Packages [216 kB] 88s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe s390x Packages [1083 kB] 88s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse s390x Packages [15.9 kB] 89s Fetched 3868 kB in 2s (2044 kB/s) 89s Reading package lists... 90s autopkgtest [06:11:11]: upgrading testbed (apt dist-upgrade and autopurge) 90s Reading package lists... 90s Building dependency tree... 90s Reading state information... 90s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 90s Starting 2 pkgProblemResolver with broken count: 0 90s Done 91s Entering ResolveByKeep 91s 91s Calculating upgrade... 91s The following packages will be upgraded: 91s dpkg dpkg-dev libdpkg-perl 91s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 91s Need to get 2667 kB of archives. 91s After this operation, 1024 B of additional disk space will be used. 91s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x dpkg s390x 1.22.18ubuntu3 [1297 kB] 92s Get:2 http://ftpmaster.internal/ubuntu questing/main s390x dpkg-dev all 1.22.18ubuntu3 [1089 kB] 92s Get:3 http://ftpmaster.internal/ubuntu questing/main s390x libdpkg-perl all 1.22.18ubuntu3 [281 kB] 93s Fetched 2667 kB in 1s (1884 kB/s) 93s (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 ... 81472 files and directories currently installed.) 93s Preparing to unpack .../dpkg_1.22.18ubuntu3_s390x.deb ... 93s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 93s Setting up dpkg (1.22.18ubuntu3) ... 93s (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 ... 81472 files and directories currently installed.) 93s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 93s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 93s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 93s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 93s Setting up libdpkg-perl (1.22.18ubuntu3) ... 93s Setting up dpkg-dev (1.22.18ubuntu3) ... 93s Processing triggers for man-db (2.13.0-1) ... 95s Reading package lists... 95s Building dependency tree... 95s Reading state information... 95s Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 95s Solving dependencies... 96s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 96s autopkgtest [06:11:17]: rebooting testbed after setup commands that affected boot 117s autopkgtest [06:11:38]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 13:39:00 UTC 2025 120s autopkgtest [06:11:41]: @@@@@@@@@@@@@@@@@@@@ apt-source pspg 123s Get:1 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (dsc) [2052 B] 123s Get:2 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (tar) [2446 kB] 123s Get:3 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (diff) [4288 B] 123s gpgv: Signature made Wed Mar 12 10:23:14 2025 UTC 123s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 123s gpgv: Can't check signature: No public key 123s dpkg-source: warning: cannot verify inline signature for ./pspg_5.8.8-1.dsc: no acceptable signature found 123s autopkgtest [06:11:44]: testing package pspg version 5.8.8-1 123s autopkgtest [06:11:44]: build not needed 124s autopkgtest [06:11:45]: test pspg: preparing testbed 125s Reading package lists... 125s Building dependency tree... 125s Reading state information... 126s Starting pkgProblemResolver with broken count: 0 126s Starting 2 pkgProblemResolver with broken count: 0 126s Done 126s The following NEW packages will be installed: 126s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 126s postgresql postgresql-17 postgresql-client-17 postgresql-client-common 126s postgresql-common postgresql-common-dev pspg ssl-cert 126s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 126s Need to get 50.0 MB of archives. 126s After this operation, 213 MB of additional disk space will be used. 126s Get:1 http://ftpmaster.internal/ubuntu questing/main s390x libjson-perl all 4.10000-1 [81.9 kB] 126s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main s390x postgresql-client-common all 277 [48.0 kB] 126s Get:3 http://ftpmaster.internal/ubuntu questing/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 126s Get:4 http://ftpmaster.internal/ubuntu questing/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 126s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main s390x postgresql-common-dev all 277 [73.4 kB] 126s Get:6 http://ftpmaster.internal/ubuntu questing/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 126s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main s390x postgresql-common all 277 [101 kB] 126s Get:8 http://ftpmaster.internal/ubuntu questing/main s390x libllvm20 s390x 1:20.1.2-0ubuntu1 [31.4 MB] 129s Get:9 http://ftpmaster.internal/ubuntu questing/main s390x libpq5 s390x 17.4-1 [147 kB] 129s Get:10 http://ftpmaster.internal/ubuntu questing/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu4 [170 kB] 129s Get:11 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 129s Get:12 http://ftpmaster.internal/ubuntu questing/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 130s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/main s390x postgresql all 17+277 [16.5 kB] 130s Get:14 http://ftpmaster.internal/ubuntu questing/universe s390x pspg s390x 5.8.8-1 [169 kB] 130s Preconfiguring packages ... 130s /var/cache/debconf/tmp.ci/postgresql.config.M1wsMs: 12: pg_lsclusters: not found 130s Fetched 50.0 MB in 4s (11.4 MB/s) 130s Selecting previously unselected package libjson-perl. 130s (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 ... 81472 files and directories currently installed.) 130s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 130s Unpacking libjson-perl (4.10000-1) ... 130s Selecting previously unselected package postgresql-client-common. 130s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 130s Unpacking postgresql-client-common (277) ... 130s Selecting previously unselected package libio-pty-perl. 130s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 130s Unpacking libio-pty-perl (1:1.20-1build3) ... 130s Selecting previously unselected package libipc-run-perl. 130s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 130s Unpacking libipc-run-perl (20231003.0-2) ... 130s Selecting previously unselected package postgresql-common-dev. 130s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 130s Unpacking postgresql-common-dev (277) ... 130s Selecting previously unselected package ssl-cert. 130s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 130s Unpacking ssl-cert (1.1.3ubuntu1) ... 130s Selecting previously unselected package postgresql-common. 130s Preparing to unpack .../06-postgresql-common_277_all.deb ... 130s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 130s Unpacking postgresql-common (277) ... 130s Selecting previously unselected package libllvm20:s390x. 130s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_s390x.deb ... 130s Unpacking libllvm20:s390x (1:20.1.2-0ubuntu1) ... 131s Selecting previously unselected package libpq5:s390x. 131s Preparing to unpack .../08-libpq5_17.4-1_s390x.deb ... 131s Unpacking libpq5:s390x (17.4-1) ... 131s Selecting previously unselected package libxslt1.1:s390x. 131s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_s390x.deb ... 131s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu4) ... 131s Selecting previously unselected package postgresql-client-17. 131s Preparing to unpack .../10-postgresql-client-17_17.4-1_s390x.deb ... 131s Unpacking postgresql-client-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-17. 131s Preparing to unpack .../11-postgresql-17_17.4-1_s390x.deb ... 131s Unpacking postgresql-17 (17.4-1) ... 131s Selecting previously unselected package postgresql. 131s Preparing to unpack .../12-postgresql_17+277_all.deb ... 131s Unpacking postgresql (17+277) ... 131s Selecting previously unselected package pspg. 131s Preparing to unpack .../13-pspg_5.8.8-1_s390x.deb ... 131s Unpacking pspg (5.8.8-1) ... 131s Setting up postgresql-client-common (277) ... 131s Setting up libio-pty-perl (1:1.20-1build3) ... 131s Setting up libpq5:s390x (17.4-1) ... 131s Setting up pspg (5.8.8-1) ... 131s Setting up ssl-cert (1.1.3ubuntu1) ... 131s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 132s Setting up libllvm20:s390x (1:20.1.2-0ubuntu1) ... 132s Setting up libipc-run-perl (20231003.0-2) ... 132s Setting up libjson-perl (4.10000-1) ... 132s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu4) ... 132s Setting up postgresql-common-dev (277) ... 132s Setting up postgresql-client-17 (17.4-1) ... 132s 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 132s Setting up postgresql-common (277) ... 132s Creating config file /etc/postgresql-common/createcluster.conf with new version 132s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 132s Removing obsolete dictionary files: 133s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 133s Setting up postgresql-17 (17.4-1) ... 133s Creating new PostgreSQL cluster 17/main ... 133s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 133s The files belonging to this database system will be owned by user "postgres". 133s This user must also own the server process. 133s 133s The database cluster will be initialized with locale "C.UTF-8". 133s The default database encoding has accordingly been set to "UTF8". 133s The default text search configuration will be set to "english". 133s 133s Data page checksums are disabled. 133s 133s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 133s creating subdirectories ... ok 133s selecting dynamic shared memory implementation ... posix 133s selecting default "max_connections" ... 100 133s selecting default "shared_buffers" ... 128MB 133s selecting default time zone ... Etc/UTC 133s creating configuration files ... ok 134s running bootstrap script ... ok 134s performing post-bootstrap initialization ... ok 134s syncing data to disk ... ok 137s Setting up postgresql (17+277) ... 137s Processing triggers for man-db (2.13.0-1) ... 138s Processing triggers for libc-bin (2.41-6ubuntu1) ... 139s autopkgtest [06:12:00]: test pspg: [----------------------- 139s + pg_virtualenv 139s Creating new PostgreSQL cluster 17/regress ... 142s + LC_ALL=C 142s + pspg -q 'select 1 a, 2 b, 3 c' --ni 142s + cat test.out 142s +---+---+---+ 142s | a | b | c | 142s +---+---+---+ 142s | 1 | 2 | 3 | 142s +---+---+---+ 142s (1 rows) 142s | 1 | 2 | 3 | 142s Dropping cluster 17/regress ... 142s + fgrep '| 1 | 2 | 3 |' test.out 142s + rm -f test.out 143s autopkgtest [06:12:04]: test pspg: -----------------------] 143s autopkgtest [06:12:04]: test pspg: - - - - - - - - - - results - - - - - - - - - - 143s pspg PASS 143s autopkgtest [06:12:04]: @@@@@@@@@@@@@@@@@@@@ summary 143s pspg PASS 162s nova [W] Using flock in prodstack6-s390x 162s Creating nova instance adt-questing-s390x-pspg-20250502-060941-juju-7f2275-prod-proposed-migration-environment-20-73775afe-1297-48bb-a631-046e5eea9400 from image adt/ubuntu-questing-s390x-server-20250501.img (UUID 06a11845-48a4-4c28-9288-51dd7b757c52)... 162s nova [W] Timed out waiting for 803ac215-7da4-4f20-b7eb-8a6c46ee10e0 to get deleted.