0s autopkgtest [03:12:31]: starting date and time: 2025-05-02 03:12:31+0000 0s autopkgtest [03:12:31]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [03:12:31]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.jdhj8sbk/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-cpu2-ram4-disk20-arm64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@sto01-arm64-1.secgroup --name adt-questing-arm64-pspg-20250502-031231-juju-7f2275-prod-proposed-migration-environment-2-f638f61a-84fb-4149-b76e-7c168dfb5565 --image adt/ubuntu-questing-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-autopkgtest-workers-arm64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 78s autopkgtest [03:13:49]: testbed dpkg architecture: arm64 78s autopkgtest [03:13:49]: testbed apt version: 3.0.0 78s autopkgtest [03:13:49]: @@@@@@@@@@@@@@@@@@@@ test bed setup 78s autopkgtest [03:13:49]: testbed release detected to be: None 79s autopkgtest [03:13:50]: updating testbed package index (apt update) 79s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 79s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 79s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 79s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 79s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [190 kB] 79s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2281 kB] 82s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 82s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [227 kB] 82s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [1341 kB] 84s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [16.5 kB] 84s Fetched 4223 kB in 4s (962 kB/s) 84s Reading package lists... 85s autopkgtest [03:13:56]: upgrading testbed (apt dist-upgrade and autopurge) 85s Reading package lists... 85s Building dependency tree... 85s Reading state information... 86s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 86s Starting 2 pkgProblemResolver with broken count: 0 86s Done 86s Entering ResolveByKeep 87s 87s Calculating upgrade... 87s The following packages will be upgraded: 87s libperl5.40 perl perl-base perl-modules-5.40 87s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s Need to get 10.0 MB of archives. 87s After this operation, 0 B of additional disk space will be used. 87s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 libperl5.40 arm64 5.40.1-3 [4780 kB] 92s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl arm64 5.40.1-3 [262 kB] 92s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl-base arm64 5.40.1-3 [1786 kB] 94s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl-modules-5.40 all 5.40.1-3 [3217 kB] 97s Fetched 10.0 MB in 9s (1075 kB/s) 97s (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 ... 85224 files and directories currently installed.) 97s Preparing to unpack .../libperl5.40_5.40.1-3_arm64.deb ... 97s Unpacking libperl5.40:arm64 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 97s Preparing to unpack .../perl_5.40.1-3_arm64.deb ... 97s Unpacking perl (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 97s Preparing to unpack .../perl-base_5.40.1-3_arm64.deb ... 97s Unpacking perl-base (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 97s Setting up perl-base (5.40.1-3) ... 98s (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 ... 85224 files and directories currently installed.) 98s Preparing to unpack .../perl-modules-5.40_5.40.1-3_all.deb ... 98s Unpacking perl-modules-5.40 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 98s Setting up perl-modules-5.40 (5.40.1-3) ... 98s Setting up libperl5.40:arm64 (5.40.1-3) ... 98s Setting up perl (5.40.1-3) ... 98s Processing triggers for man-db (2.13.0-1) ... 98s Processing triggers for libc-bin (2.41-6ubuntu1) ... 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 99s Starting pkgProblemResolver with broken count: 0 99s Starting 2 pkgProblemResolver with broken count: 0 99s Done 100s Solving dependencies... 100s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 102s autopkgtest [03:14:13]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 102s autopkgtest [03:14:13]: @@@@@@@@@@@@@@@@@@@@ apt-source pspg 104s Get:1 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (dsc) [2052 B] 104s Get:2 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (tar) [2446 kB] 104s Get:3 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (diff) [4288 B] 104s gpgv: Signature made Wed Mar 12 10:23:14 2025 UTC 104s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 104s gpgv: Can't check signature: No public key 104s dpkg-source: warning: cannot verify inline signature for ./pspg_5.8.8-1.dsc: no acceptable signature found 104s autopkgtest [03:14:15]: testing package pspg version 5.8.8-1 105s autopkgtest [03:14:16]: build not needed 105s autopkgtest [03:14:16]: test pspg: preparing testbed 105s Reading package lists... 106s Building dependency tree... 106s Reading state information... 106s Starting pkgProblemResolver with broken count: 0 106s Starting 2 pkgProblemResolver with broken count: 0 106s Done 107s The following NEW packages will be installed: 107s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 107s postgresql postgresql-17 postgresql-client-17 postgresql-client-common 107s postgresql-common postgresql-common-dev pspg ssl-cert 107s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 107s Need to get 47.0 MB of archives. 107s After this operation, 198 MB of additional disk space will be used. 107s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 107s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 postgresql-client-common all 277 [48.0 kB] 107s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 107s Get:4 http://ftpmaster.internal/ubuntu questing/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 107s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 postgresql-common-dev all 277 [73.4 kB] 107s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 107s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 postgresql-common all 277 [101 kB] 107s Get:8 http://ftpmaster.internal/ubuntu questing/main arm64 libllvm20 arm64 1:20.1.2-0ubuntu1 [29.1 MB] 121s Get:9 http://ftpmaster.internal/ubuntu questing/main arm64 libpq5 arm64 17.4-1 [142 kB] 121s Get:10 http://ftpmaster.internal/ubuntu questing/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu4 [168 kB] 121s Get:11 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 122s Get:12 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 129s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 postgresql all 17+277 [16.5 kB] 129s Get:14 http://ftpmaster.internal/ubuntu questing/universe arm64 pspg arm64 5.8.8-1 [156 kB] 130s Preconfiguring packages ... 130s /var/cache/debconf/tmp.ci/postgresql.config.GGO1qM: 12: pg_lsclusters: not found 130s Fetched 47.0 MB in 23s (2064 kB/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 ... 85224 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_arm64.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:arm64. 130s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_arm64.deb ... 130s Unpacking libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 131s Selecting previously unselected package libpq5:arm64. 131s Preparing to unpack .../08-libpq5_17.4-1_arm64.deb ... 131s Unpacking libpq5:arm64 (17.4-1) ... 131s Selecting previously unselected package libxslt1.1:arm64. 131s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_arm64.deb ... 131s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 131s Selecting previously unselected package postgresql-client-17. 131s Preparing to unpack .../10-postgresql-client-17_17.4-1_arm64.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_arm64.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_arm64.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:arm64 (17.4-1) ... 131s Setting up pspg (5.8.8-1) ... 131s Setting up ssl-cert (1.1.3ubuntu1) ... 132s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 132s Setting up libllvm20:arm64 (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:arm64 (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) ... 133s Creating config file /etc/postgresql-common/createcluster.conf with new version 133s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 133s Removing obsolete dictionary files: 133s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 134s Setting up postgresql-17 (17.4-1) ... 135s Creating new PostgreSQL cluster 17/main ... 135s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 135s The files belonging to this database system will be owned by user "postgres". 135s This user must also own the server process. 135s 135s The database cluster will be initialized with locale "C.UTF-8". 135s The default database encoding has accordingly been set to "UTF8". 135s The default text search configuration will be set to "english". 135s 135s Data page checksums are disabled. 135s 135s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 135s creating subdirectories ... ok 135s selecting dynamic shared memory implementation ... posix 135s selecting default "max_connections" ... 100 135s selecting default "shared_buffers" ... 128MB 135s selecting default time zone ... Etc/UTC 135s creating configuration files ... ok 135s running bootstrap script ... ok 135s performing post-bootstrap initialization ... ok 135s syncing data to disk ... ok 138s Setting up postgresql (17+277) ... 138s Processing triggers for man-db (2.13.0-1) ... 139s Processing triggers for libc-bin (2.41-6ubuntu1) ... 140s autopkgtest [03:14:51]: test pspg: [----------------------- 140s + pg_virtualenv 140s Creating new PostgreSQL cluster 17/regress ... 143s + LC_ALL=C 143s + pspg -q 'select 1 a, 2 b, 3 c' --ni 143s + cat test.out 143s +---+---+---+ 143s | a | b | c | 143s +---+---+---+ 143s | 1 | 2 | 3 | 143s +---+---+---+ 143s (1 rows) 143s + fgrep '| 1 | 2 | 3 |' test.out 143s | 1 | 2 | 3 | 143s Dropping cluster 17/regress ... 143s + rm -f test.out 143s autopkgtest [03:14:54]: test pspg: -----------------------] 144s autopkgtest [03:14:55]: test pspg: - - - - - - - - - - results - - - - - - - - - - 144s pspg PASS 144s autopkgtest [03:14:55]: @@@@@@@@@@@@@@@@@@@@ summary 144s pspg PASS 159s nova [W] Using flock in prodstack7-arm64 159s Creating nova instance adt-questing-arm64-pspg-20250502-031231-juju-7f2275-prod-proposed-migration-environment-2-f638f61a-84fb-4149-b76e-7c168dfb5565 from image adt/ubuntu-questing-arm64-server-20250501.img (UUID 137c3127-57d2-4bf2-a106-d904ad6e43f4)... 159s nova [W] Timed out waiting for db2d53af-804b-4f5b-9b62-cd96cff631b7 to get deleted.