0s autopkgtest [14:42:13]: starting date and time: 2025-05-03 14:42:13+0000 0s autopkgtest [14:42:13]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [14:42:13]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.naovd1nw/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 builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-8.secgroup --name adt-questing-amd64-pspg-20250503-144213-juju-7f2275-prod-proposed-migration-environment-15-33e8f409-e738-4897-ac8c-649e6c565c94 --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 60s autopkgtest [14:43:13]: testbed dpkg architecture: amd64 60s autopkgtest [14:43:13]: testbed apt version: 3.0.0 60s autopkgtest [14:43:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 60s autopkgtest [14:43:13]: testbed release detected to be: None 61s autopkgtest [14:43:14]: updating testbed package index (apt update) 61s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 62s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 62s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 62s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 62s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1597 kB] 62s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [150 kB] 62s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [38.8 kB] 62s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [145 kB] 62s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [202 kB] 62s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [615 kB] 62s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [1515 kB] 62s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [54.1 kB] 62s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [25.3 kB] 62s Fetched 4453 kB in 1s (4070 kB/s) 63s Reading package lists... 64s autopkgtest [14:43:17]: upgrading testbed (apt dist-upgrade and autopurge) 64s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 64s Starting 2 pkgProblemResolver with broken count: 0 64s Done 65s Entering ResolveByKeep 65s 65s Calculating upgrade... 65s The following packages will be upgraded: 65s debianutils libmbim-glib4 libmbim-proxy libnftnl11 libqmi-glib5 libqmi-proxy 65s python3-lazr.restfulclient 65s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 65s Need to get 1378 kB of archives. 65s After this operation, 139 kB disk space will be freed. 65s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 debianutils amd64 5.22 [93.0 kB] 65s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 libnftnl11 amd64 1.2.9-1 [69.1 kB] 65s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-proxy amd64 1.32.0-1 [6276 B] 65s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-glib4 amd64 1.32.0-1 [233 kB] 65s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-proxy amd64 1.36.0-1 [6220 B] 65s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-glib5 amd64 1.36.0-1 [920 kB] 66s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 66s Fetched 1378 kB in 1s (2516 kB/s) 66s (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 ... 80514 files and directories currently installed.) 66s Preparing to unpack .../debianutils_5.22_amd64.deb ... 66s Unpacking debianutils (5.22) over (5.21) ... 66s Setting up debianutils (5.22) ... 66s (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 ... 80514 files and directories currently installed.) 66s Preparing to unpack .../0-libnftnl11_1.2.9-1_amd64.deb ... 66s Unpacking libnftnl11:amd64 (1.2.9-1) over (1.2.8-1) ... 66s Preparing to unpack .../1-libmbim-proxy_1.32.0-1_amd64.deb ... 66s Unpacking libmbim-proxy (1.32.0-1) over (1.31.2-0ubuntu4) ... 66s Preparing to unpack .../2-libmbim-glib4_1.32.0-1_amd64.deb ... 66s Unpacking libmbim-glib4:amd64 (1.32.0-1) over (1.31.2-0ubuntu4) ... 66s Preparing to unpack .../3-libqmi-proxy_1.36.0-1_amd64.deb ... 66s Unpacking libqmi-proxy (1.36.0-1) over (1.35.6-1) ... 66s Preparing to unpack .../4-libqmi-glib5_1.36.0-1_amd64.deb ... 66s Unpacking libqmi-glib5:amd64 (1.36.0-1) over (1.35.6-1) ... 66s Preparing to unpack .../5-python3-lazr.restfulclient_0.14.6-3_all.deb ... 66s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 67s Setting up libnftnl11:amd64 (1.2.9-1) ... 67s Setting up python3-lazr.restfulclient (0.14.6-3) ... 67s Setting up libmbim-glib4:amd64 (1.32.0-1) ... 67s Setting up libmbim-proxy (1.32.0-1) ... 67s Setting up libqmi-glib5:amd64 (1.36.0-1) ... 67s Setting up libqmi-proxy (1.36.0-1) ... 67s Processing triggers for libc-bin (2.41-6ubuntu1) ... 67s Processing triggers for man-db (2.13.0-1) ... 68s Reading package lists... 68s Building dependency tree... 68s Reading state information... 68s Starting pkgProblemResolver with broken count: 0 68s Starting 2 pkgProblemResolver with broken count: 0 68s Done 69s Solving dependencies... 69s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 71s autopkgtest [14:43:24]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 71s autopkgtest [14:43:24]: @@@@@@@@@@@@@@@@@@@@ apt-source pspg 73s Get:1 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (dsc) [2052 B] 73s Get:2 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (tar) [2446 kB] 73s Get:3 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (diff) [4288 B] 73s gpgv: Signature made Wed Mar 12 10:23:14 2025 UTC 73s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 73s gpgv: Can't check signature: No public key 73s dpkg-source: warning: cannot verify inline signature for ./pspg_5.8.8-1.dsc: no acceptable signature found 73s autopkgtest [14:43:26]: testing package pspg version 5.8.8-1 74s autopkgtest [14:43:27]: build not needed 75s autopkgtest [14:43:28]: test pspg: preparing testbed 75s Reading package lists... 75s Building dependency tree... 75s Reading state information... 75s Starting pkgProblemResolver with broken count: 0 75s Starting 2 pkgProblemResolver with broken count: 0 75s Done 76s The following NEW packages will be installed: 76s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 76s postgresql postgresql-17 postgresql-client-17 postgresql-client-common 76s postgresql-common postgresql-common-dev pspg ssl-cert 76s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 76s Need to get 49.4 MB of archives. 76s After this operation, 200 MB of additional disk space will be used. 76s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 76s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-client-common all 277 [48.0 kB] 76s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 76s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 76s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common-dev all 277 [73.4 kB] 76s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 76s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common all 277 [101 kB] 76s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 77s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.4-1 [155 kB] 77s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 77s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 77s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 77s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql all 17+277 [16.5 kB] 77s Get:14 http://ftpmaster.internal/ubuntu questing/universe amd64 pspg amd64 5.8.8-1 [177 kB] 78s Preconfiguring packages ... 78s /var/cache/debconf/tmp.ci/postgresql.config.OAX0Vq: 12: pg_lsclusters: not found 78s Fetched 49.4 MB in 2s (28.4 MB/s) 78s Selecting previously unselected package libjson-perl. 78s (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 ... 80514 files and directories currently installed.) 78s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 78s Unpacking libjson-perl (4.10000-1) ... 78s Selecting previously unselected package postgresql-client-common. 78s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 78s Unpacking postgresql-client-common (277) ... 78s Selecting previously unselected package libio-pty-perl. 78s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 78s Unpacking libio-pty-perl (1:1.20-1build3) ... 78s Selecting previously unselected package libipc-run-perl. 78s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 78s Unpacking libipc-run-perl (20231003.0-2) ... 78s Selecting previously unselected package postgresql-common-dev. 78s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 78s Unpacking postgresql-common-dev (277) ... 78s Selecting previously unselected package ssl-cert. 78s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 78s Unpacking ssl-cert (1.1.3ubuntu1) ... 78s Selecting previously unselected package postgresql-common. 78s Preparing to unpack .../06-postgresql-common_277_all.deb ... 78s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 78s Unpacking postgresql-common (277) ... 78s Selecting previously unselected package libllvm20:amd64. 78s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 78s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 79s Selecting previously unselected package libpq5:amd64. 79s Preparing to unpack .../08-libpq5_17.4-1_amd64.deb ... 79s Unpacking libpq5:amd64 (17.4-1) ... 79s Selecting previously unselected package libxslt1.1:amd64. 79s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 79s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 79s Selecting previously unselected package postgresql-client-17. 79s Preparing to unpack .../10-postgresql-client-17_17.4-1_amd64.deb ... 79s Unpacking postgresql-client-17 (17.4-1) ... 79s Selecting previously unselected package postgresql-17. 79s Preparing to unpack .../11-postgresql-17_17.4-1_amd64.deb ... 79s Unpacking postgresql-17 (17.4-1) ... 79s Selecting previously unselected package postgresql. 79s Preparing to unpack .../12-postgresql_17+277_all.deb ... 79s Unpacking postgresql (17+277) ... 79s Selecting previously unselected package pspg. 79s Preparing to unpack .../13-pspg_5.8.8-1_amd64.deb ... 79s Unpacking pspg (5.8.8-1) ... 79s Setting up postgresql-client-common (277) ... 79s Setting up libio-pty-perl (1:1.20-1build3) ... 79s Setting up libpq5:amd64 (17.4-1) ... 79s Setting up pspg (5.8.8-1) ... 79s Setting up ssl-cert (1.1.3ubuntu1) ... 79s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 80s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 80s Setting up libipc-run-perl (20231003.0-2) ... 80s Setting up libjson-perl (4.10000-1) ... 80s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 80s Setting up postgresql-common-dev (277) ... 80s Setting up postgresql-client-17 (17.4-1) ... 80s 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 80s Setting up postgresql-common (277) ... 80s Creating config file /etc/postgresql-common/createcluster.conf with new version 81s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 81s Removing obsolete dictionary files: 81s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 81s Setting up postgresql-17 (17.4-1) ... 82s Creating new PostgreSQL cluster 17/main ... 82s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 82s The files belonging to this database system will be owned by user "postgres". 82s This user must also own the server process. 82s 82s The database cluster will be initialized with locale "C.UTF-8". 82s The default database encoding has accordingly been set to "UTF8". 82s The default text search configuration will be set to "english". 82s 82s Data page checksums are disabled. 82s 82s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 82s creating subdirectories ... ok 82s selecting dynamic shared memory implementation ... posix 82s selecting default "max_connections" ... 100 82s selecting default "shared_buffers" ... 128MB 82s selecting default time zone ... Etc/UTC 82s creating configuration files ... ok 82s running bootstrap script ... ok 83s performing post-bootstrap initialization ... ok 83s syncing data to disk ... ok 85s Setting up postgresql (17+277) ... 86s Processing triggers for man-db (2.13.0-1) ... 86s Processing triggers for libc-bin (2.41-6ubuntu1) ... 87s autopkgtest [14:43:40]: test pspg: [----------------------- 88s + pg_virtualenv 88s Creating new PostgreSQL cluster 17/regress ... 90s + LC_ALL=C 90s + pspg -q 'select 1 a, 2 b, 3 c' --ni 90s + cat test.out 90s +---+---+---+ 90s | a | b | c | 90s +---+---+---+ 90s | 1 | 2 | 3 | 90s +---+---+---+ 90s (1 rows) 90s + fgrep '| 1 | 2 | 3 |' test.out 90s | 1 | 2 | 3 | 90s Dropping cluster 17/regress ... 90s + rm -f test.out 91s autopkgtest [14:43:44]: test pspg: -----------------------] 91s autopkgtest [14:43:44]: test pspg: - - - - - - - - - - results - - - - - - - - - - 91s pspg PASS 92s autopkgtest [14:43:45]: @@@@@@@@@@@@@@@@@@@@ summary 92s pspg PASS 96s nova [W] Skipping flock for amd64 96s Creating nova instance adt-questing-amd64-pspg-20250503-144213-juju-7f2275-prod-proposed-migration-environment-15-33e8f409-e738-4897-ac8c-649e6c565c94 from image adt/ubuntu-questing-amd64-server-20250503.img (UUID 57b7c1b6-ad80-4bdb-b031-36f045f7f3b3)... 96s nova [W] Timed out waiting for 99974050-65a5-4d5a-a95c-072d51b3c736 to get deleted.