0s autopkgtest [14:16:35]: starting date and time: 2025-05-02 14:16:35+0000 0s autopkgtest [14:16:35]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [14:16:35]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.n5hsi_or/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_proxy=127.0.0.1,127.0.1.1,localhost,localdomain,internal,login.ubuntu.com,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com\n" >> /etc/environment' --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 -- lxd -r lxd-armhf-10.145.243.239 lxd-armhf-10.145.243.239:autopkgtest/ubuntu/questing/armhf 21s autopkgtest [14:16:55]: testbed dpkg architecture: armhf 22s autopkgtest [14:16:57]: testbed apt version: 3.0.0 26s autopkgtest [14:17:01]: @@@@@@@@@@@@@@@@@@@@ test bed setup 28s autopkgtest [14:17:03]: testbed release detected to be: None 36s autopkgtest [14:17:11]: updating testbed package index (apt update) 38s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 38s Get:2 http://ftpmaster.internal/ubuntu questing InRelease [110 kB] 38s Get:3 http://ftpmaster.internal/ubuntu questing-updates InRelease [110 kB] 38s Get:4 http://ftpmaster.internal/ubuntu questing-security InRelease [110 kB] 38s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [171 kB] 38s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.4 kB] 38s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2029 kB] 38s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main armhf Packages [197 kB] 38s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe armhf Packages [1391 kB] 38s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse armhf Packages [13.7 kB] 38s Get:11 http://ftpmaster.internal/ubuntu questing/main Sources [1385 kB] 38s Get:12 http://ftpmaster.internal/ubuntu questing/multiverse Sources [299 kB] 38s Get:13 http://ftpmaster.internal/ubuntu questing/universe Sources [21.1 MB] 39s Get:14 http://ftpmaster.internal/ubuntu questing/main armhf Packages [1358 kB] 39s Get:15 http://ftpmaster.internal/ubuntu questing/universe armhf Packages [15.3 MB] 40s Get:16 http://ftpmaster.internal/ubuntu questing/multiverse armhf Packages [173 kB] 43s Fetched 43.9 MB in 6s (7974 kB/s) 44s Reading package lists... 50s autopkgtest [14:17:25]: upgrading testbed (apt dist-upgrade and autopurge) 52s Reading package lists... 52s Building dependency tree... 52s Reading state information... 52s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 53s Starting 2 pkgProblemResolver with broken count: 0 53s Done 53s Entering ResolveByKeep 54s 54s Calculating upgrade... 54s The following packages will be upgraded: 54s base-files distro-info-data dpkg dpkg-dev htop libdpkg-perl libnpth0t64 54s motd-news-config nano ubuntu-pro-client ubuntu-pro-client-l10n usb.ids 55s 12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 55s Need to get 3645 kB of archives. 55s After this operation, 57.3 kB of additional disk space will be used. 55s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf motd-news-config all 13.7ubuntu1 [5260 B] 55s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf base-files armhf 13.7ubuntu1 [75.4 kB] 55s Get:3 http://ftpmaster.internal/ubuntu questing/main armhf dpkg armhf 1.22.18ubuntu3 [1254 kB] 55s Get:4 http://ftpmaster.internal/ubuntu questing/main armhf libnpth0t64 armhf 1.8-3 [7716 B] 55s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf distro-info-data all 0.64 [6664 B] 55s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf ubuntu-pro-client-l10n armhf 35.1ubuntu0 [19.7 kB] 55s Get:7 http://ftpmaster.internal/ubuntu questing/main armhf ubuntu-pro-client armhf 35.1ubuntu0 [258 kB] 55s Get:8 http://ftpmaster.internal/ubuntu questing/main armhf nano armhf 8.4-1 [278 kB] 55s Get:9 http://ftpmaster.internal/ubuntu questing/main armhf usb.ids all 2025.04.01-1 [223 kB] 55s Get:10 http://ftpmaster.internal/ubuntu questing/main armhf dpkg-dev all 1.22.18ubuntu3 [1089 kB] 55s Get:11 http://ftpmaster.internal/ubuntu questing/main armhf libdpkg-perl all 1.22.18ubuntu3 [281 kB] 55s Get:12 http://ftpmaster.internal/ubuntu questing/main armhf htop armhf 3.4.1-4 [147 kB] 56s Fetched 3645 kB in 1s (4737 kB/s) 56s (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 ... 63953 files and directories currently installed.) 56s Preparing to unpack .../motd-news-config_13.7ubuntu1_all.deb ... 56s Unpacking motd-news-config (13.7ubuntu1) over (13.6ubuntu2) ... 56s Preparing to unpack .../base-files_13.7ubuntu1_armhf.deb ... 56s Unpacking base-files (13.7ubuntu1) over (13.6ubuntu2) ... 56s Setting up base-files (13.7ubuntu1) ... 56s Installing new version of config file /etc/issue ... 56s Installing new version of config file /etc/issue.net ... 56s Installing new version of config file /etc/lsb-release ... 57s motd-news.service is a disabled or a static unit not running, not starting it. 57s (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 ... 63953 files and directories currently installed.) 57s Preparing to unpack .../dpkg_1.22.18ubuntu3_armhf.deb ... 57s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 57s Setting up dpkg (1.22.18ubuntu3) ... 58s (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 ... 63953 files and directories currently installed.) 58s Preparing to unpack .../libnpth0t64_1.8-3_armhf.deb ... 58s Unpacking libnpth0t64:armhf (1.8-3) over (1.8-2) ... 58s Setting up libnpth0t64:armhf (1.8-3) ... 58s (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 ... 63953 files and directories currently installed.) 58s Preparing to unpack .../0-distro-info-data_0.64_all.deb ... 58s Unpacking distro-info-data (0.64) over (0.63) ... 58s Preparing to unpack .../1-ubuntu-pro-client-l10n_35.1ubuntu0_armhf.deb ... 58s Unpacking ubuntu-pro-client-l10n (35.1ubuntu0) over (35) ... 58s Preparing to unpack .../2-ubuntu-pro-client_35.1ubuntu0_armhf.deb ... 58s Unpacking ubuntu-pro-client (35.1ubuntu0) over (35) ... 58s Preparing to unpack .../3-nano_8.4-1_armhf.deb ... 58s Unpacking nano (8.4-1) over (8.3-1) ... 58s Preparing to unpack .../4-usb.ids_2025.04.01-1_all.deb ... 58s Unpacking usb.ids (2025.04.01-1) over (2025.01.14-1) ... 58s Preparing to unpack .../5-dpkg-dev_1.22.18ubuntu3_all.deb ... 58s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 58s Preparing to unpack .../6-libdpkg-perl_1.22.18ubuntu3_all.deb ... 58s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 58s Preparing to unpack .../7-htop_3.4.1-4_armhf.deb ... 58s Unpacking htop (3.4.1-4) over (3.4.0-2) ... 58s Setting up motd-news-config (13.7ubuntu1) ... 58s Setting up distro-info-data (0.64) ... 58s Setting up htop (3.4.1-4) ... 58s Setting up usb.ids (2025.04.01-1) ... 58s Setting up libdpkg-perl (1.22.18ubuntu3) ... 58s Setting up nano (8.4-1) ... 58s Installing new version of config file /etc/nanorc ... 58s Setting up ubuntu-pro-client (35.1ubuntu0) ... 58s apparmor_parser: Unable to replace "ubuntu_pro_apt_news". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 58s 59s apparmor_parser: Unable to replace "apt_methods". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 59s 59s apparmor_parser: Unable to replace "ubuntu_pro_esm_cache". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 59s 60s Setting up ubuntu-pro-client-l10n (35.1ubuntu0) ... 60s Setting up dpkg-dev (1.22.18ubuntu3) ... 60s Processing triggers for install-info (7.1.1-1) ... 60s Processing triggers for libc-bin (2.41-6ubuntu1) ... 60s Processing triggers for man-db (2.13.0-1) ... 62s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-2ubuntu7) ... 62s Processing triggers for initramfs-tools (0.147ubuntu1) ... 64s Reading package lists... 64s Building dependency tree... 64s Reading state information... 65s Starting pkgProblemResolver with broken count: 0 65s Starting 2 pkgProblemResolver with broken count: 0 65s Done 65s Solving dependencies... 66s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 68s autopkgtest [14:17:43]: rebooting testbed after setup commands that affected boot 108s autopkgtest [14:18:23]: testbed running kernel: Linux 6.8.0-58-generic #60~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 28 14:48:37 UTC 2 132s autopkgtest [14:18:47]: @@@@@@@@@@@@@@@@@@@@ apt-source pspg 142s Get:1 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (dsc) [2052 B] 142s Get:2 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (tar) [2446 kB] 142s Get:3 http://ftpmaster.internal/ubuntu questing/universe pspg 5.8.8-1 (diff) [4288 B] 142s gpgv: Signature made Wed Mar 12 10:23:14 2025 UTC 142s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 142s gpgv: Can't check signature: No public key 142s dpkg-source: warning: cannot verify inline signature for ./pspg_5.8.8-1.dsc: no acceptable signature found 143s autopkgtest [14:18:58]: testing package pspg version 5.8.8-1 145s autopkgtest [14:19:00]: build not needed 147s autopkgtest [14:19:02]: test pspg: preparing testbed 149s Reading package lists... 149s Building dependency tree... 149s Reading state information... 150s Starting pkgProblemResolver with broken count: 0 150s Starting 2 pkgProblemResolver with broken count: 0 150s Done 150s The following NEW packages will be installed: 150s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 150s postgresql postgresql-17 postgresql-client-17 postgresql-client-common 150s postgresql-common postgresql-common-dev pspg ssl-cert 151s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 151s Need to get 46.6 MB of archives. 151s After this operation, 182 MB of additional disk space will be used. 151s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf libjson-perl all 4.10000-1 [81.9 kB] 151s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main armhf postgresql-client-common all 277 [48.0 kB] 151s Get:3 http://ftpmaster.internal/ubuntu questing/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 151s Get:4 http://ftpmaster.internal/ubuntu questing/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 151s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main armhf postgresql-common-dev all 277 [73.4 kB] 151s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 151s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main armhf postgresql-common all 277 [101 kB] 151s Get:8 http://ftpmaster.internal/ubuntu questing/main armhf libllvm20 armhf 1:20.1.2-0ubuntu1 [29.6 MB] 152s Get:9 http://ftpmaster.internal/ubuntu questing/main armhf libpq5 armhf 17.4-1 [125 kB] 152s Get:10 http://ftpmaster.internal/ubuntu questing/main armhf libxslt1.1 armhf 1.1.39-0exp1ubuntu4 [151 kB] 152s Get:11 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-client-17 armhf 17.4-1 [1285 kB] 152s Get:12 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-17 armhf 17.4-1 [14.8 MB] 152s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/main armhf postgresql all 17+277 [16.5 kB] 152s Get:14 http://ftpmaster.internal/ubuntu questing/universe armhf pspg armhf 5.8.8-1 [142 kB] 153s Preconfiguring packages ... 153s /var/cache/debconf/tmp.ci/postgresql.config.Cqblbo: 12: pg_lsclusters: not found 153s Fetched 46.6 MB in 2s (26.8 MB/s) 153s Selecting previously unselected package libjson-perl. 153s (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 ... 63953 files and directories currently installed.) 153s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 153s Unpacking libjson-perl (4.10000-1) ... 153s Selecting previously unselected package postgresql-client-common. 153s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 153s Unpacking postgresql-client-common (277) ... 153s Selecting previously unselected package libio-pty-perl. 153s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 153s Unpacking libio-pty-perl (1:1.20-1build3) ... 153s Selecting previously unselected package libipc-run-perl. 153s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 153s Unpacking libipc-run-perl (20231003.0-2) ... 153s Selecting previously unselected package postgresql-common-dev. 153s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 153s Unpacking postgresql-common-dev (277) ... 153s Selecting previously unselected package ssl-cert. 153s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 153s Unpacking ssl-cert (1.1.3ubuntu1) ... 153s Selecting previously unselected package postgresql-common. 153s Preparing to unpack .../06-postgresql-common_277_all.deb ... 153s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 153s Unpacking postgresql-common (277) ... 153s Selecting previously unselected package libllvm20:armhf. 153s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_armhf.deb ... 153s Unpacking libllvm20:armhf (1:20.1.2-0ubuntu1) ... 154s Selecting previously unselected package libpq5:armhf. 154s Preparing to unpack .../08-libpq5_17.4-1_armhf.deb ... 154s Unpacking libpq5:armhf (17.4-1) ... 154s Selecting previously unselected package libxslt1.1:armhf. 154s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_armhf.deb ... 154s Unpacking libxslt1.1:armhf (1.1.39-0exp1ubuntu4) ... 154s Selecting previously unselected package postgresql-client-17. 154s Preparing to unpack .../10-postgresql-client-17_17.4-1_armhf.deb ... 154s Unpacking postgresql-client-17 (17.4-1) ... 154s Selecting previously unselected package postgresql-17. 154s Preparing to unpack .../11-postgresql-17_17.4-1_armhf.deb ... 154s Unpacking postgresql-17 (17.4-1) ... 155s Selecting previously unselected package postgresql. 155s Preparing to unpack .../12-postgresql_17+277_all.deb ... 155s Unpacking postgresql (17+277) ... 155s Selecting previously unselected package pspg. 155s Preparing to unpack .../13-pspg_5.8.8-1_armhf.deb ... 155s Unpacking pspg (5.8.8-1) ... 155s Setting up postgresql-client-common (277) ... 155s Setting up libio-pty-perl (1:1.20-1build3) ... 155s Setting up libpq5:armhf (17.4-1) ... 155s Setting up pspg (5.8.8-1) ... 155s Setting up ssl-cert (1.1.3ubuntu1) ... 156s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 156s Setting up libllvm20:armhf (1:20.1.2-0ubuntu1) ... 156s Setting up libipc-run-perl (20231003.0-2) ... 156s Setting up libjson-perl (4.10000-1) ... 156s Setting up libxslt1.1:armhf (1.1.39-0exp1ubuntu4) ... 156s Setting up postgresql-common-dev (277) ... 156s Setting up postgresql-client-17 (17.4-1) ... 157s 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 157s Setting up postgresql-common (277) ... 157s Creating config file /etc/postgresql-common/createcluster.conf with new version 157s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 157s Removing obsolete dictionary files: 158s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 158s Setting up postgresql-17 (17.4-1) ... 159s Creating new PostgreSQL cluster 17/main ... 159s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 159s The files belonging to this database system will be owned by user "postgres". 159s This user must also own the server process. 159s 159s The database cluster will be initialized with locale "C.UTF-8". 159s The default database encoding has accordingly been set to "UTF8". 159s The default text search configuration will be set to "english". 159s 159s Data page checksums are disabled. 159s 159s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 159s creating subdirectories ... ok 159s selecting dynamic shared memory implementation ... posix 159s selecting default "max_connections" ... 100 159s selecting default "shared_buffers" ... 128MB 159s selecting default time zone ... Etc/UTC 159s creating configuration files ... ok 160s running bootstrap script ... ok 160s performing post-bootstrap initialization ... ok 160s syncing data to disk ... ok 163s Setting up postgresql (17+277) ... 163s Processing triggers for man-db (2.13.0-1) ... 164s Processing triggers for libc-bin (2.41-6ubuntu1) ... 172s autopkgtest [14:19:27]: test pspg: [----------------------- 174s + pg_virtualenv 174s Creating new PostgreSQL cluster 17/regress ... 177s + LC_ALL=C 177s + pspg -q 'select 1 a, 2 b, 3 c' --ni 177s + cat test.out 177s +---+---+---+ 177s | a | b | c | 177s +---+---+---+ 177s | 1 | 2 | 3 | 177s +---+---+---+ 177s (1 rows) 177s + fgrep '| 1 | 2 | 3 |' test.out 177s | 1 | 2 | 3 | 177s Dropping cluster 17/regress ... 177s + rm -f test.out 177s autopkgtest [14:19:32]: test pspg: -----------------------] 181s pspg PASS 181s autopkgtest [14:19:36]: test pspg: - - - - - - - - - - results - - - - - - - - - - 185s autopkgtest [14:19:40]: @@@@@@@@@@@@@@@@@@@@ summary 185s pspg PASS