0s autopkgtest [12:44:36]: starting date and time: 2024-03-26 12:44:36+0000 0s autopkgtest [12:44:36]: git checkout: 4a1cd702 l/adt_testbed: don't blame the testbed for unsolvable build deps 0s autopkgtest [12:44:36]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.yndxq8k6/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed --apt-upgrade pspg --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-16/16.2-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@bos02-s390x-25.secgroup --name adt-noble-s390x-pspg-20240326-124436-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-3 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 86s autopkgtest [12:46:02]: testbed dpkg architecture: s390x 86s autopkgtest [12:46:02]: testbed apt version: 2.7.12 86s autopkgtest [12:46:02]: @@@@@@@@@@@@@@@@@@@@ test bed setup 87s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 88s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [4019 kB] 90s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [496 kB] 90s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [56.0 kB] 90s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [8504 B] 90s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main s390x Packages [690 kB] 91s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main s390x c-n-f Metadata [3032 B] 91s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x Packages [1372 B] 91s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x c-n-f Metadata [116 B] 91s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x Packages [4128 kB] 91s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x c-n-f Metadata [7292 B] 91s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x Packages [47.8 kB] 91s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x c-n-f Metadata [116 B] 93s Fetched 9575 kB in 5s (1889 kB/s) 93s Reading package lists... 96s Reading package lists... 96s Building dependency tree... 96s Reading state information... 96s Calculating upgrade... 96s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 96s Reading package lists... 97s Building dependency tree... 97s Reading state information... 97s 0 upgraded, 0 newly installed, 0 to remove and 244 not upgraded. 97s Unknown architecture, assuming PC-style ttyS0 97s sh: Attempting to set up Debian/Ubuntu apt sources automatically 97s sh: Distribution appears to be Ubuntu 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 98s eatmydata is already the newest version (131-1). 98s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 99s dbus is already the newest version (1.14.10-4ubuntu1). 99s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 99s rng-tools-debian is already the newest version (2.4). 99s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s The following packages will be REMOVED: 100s cloud-init* python3-configobj* python3-debconf* 100s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 100s After this operation, 3256 kB disk space will be freed. 100s (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 ... 52170 files and directories currently installed.) 100s Removing cloud-init (24.1.2-0ubuntu1) ... 100s Removing python3-configobj (5.0.8-3) ... 100s Removing python3-debconf (1.5.86) ... 100s Processing triggers for man-db (2.12.0-3) ... 101s (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 ... 51781 files and directories currently installed.) 101s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 101s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 101s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 101s invoke-rc.d: policy-rc.d denied execution of try-restart. 102s Reading package lists... 102s Building dependency tree... 102s Reading state information... 102s linux-generic is already the newest version (6.8.0-11.11+1). 102s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 102s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 102s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 103s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 104s Reading package lists... 104s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s Calculating upgrade... 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 105s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 105s autopkgtest [12:46:21]: rebooting testbed after setup commands that affected boot 123s autopkgtest [12:46:39]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Tue Feb 13 23:45:46 UTC 2024 126s autopkgtest [12:46:42]: @@@@@@@@@@@@@@@@@@@@ apt-source pspg 128s Get:1 http://ftpmaster.internal/ubuntu noble/universe pspg 5.8.1-1 (dsc) [2055 B] 128s Get:2 http://ftpmaster.internal/ubuntu noble/universe pspg 5.8.1-1 (tar) [2442 kB] 128s Get:3 http://ftpmaster.internal/ubuntu noble/universe pspg 5.8.1-1 (diff) [4204 B] 128s gpgv: Signature made Sat Nov 25 14:11:38 2023 UTC 128s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 128s gpgv: Can't check signature: No public key 128s dpkg-source: warning: cannot verify inline signature for ./pspg_5.8.1-1.dsc: no acceptable signature found 128s autopkgtest [12:46:44]: testing package pspg version 5.8.1-1 129s autopkgtest [12:46:45]: build not needed 132s autopkgtest [12:46:48]: test pspg: preparing testbed 134s Reading package lists... 134s Building dependency tree... 134s Reading state information... 134s Starting pkgProblemResolver with broken count: 0 134s Starting 2 pkgProblemResolver with broken count: 0 134s Done 134s The following additional packages will be installed: 134s libjson-perl libllvm17 libpq5 libxslt1.1 postgresql postgresql-16 134s postgresql-client-16 postgresql-client-common postgresql-common pspg 134s ssl-cert 134s Suggested packages: 134s postgresql-doc postgresql-doc-16 134s Recommended packages: 134s libjson-xs-perl 134s The following NEW packages will be installed: 134s autopkgtest-satdep libjson-perl libllvm17 libpq5 libxslt1.1 postgresql 134s postgresql-16 postgresql-client-16 postgresql-client-common 134s postgresql-common pspg ssl-cert 134s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 134s Need to get 50.0 MB/50.0 MB of archives. 134s After this operation, 213 MB of additional disk space will be used. 134s Get:1 /tmp/autopkgtest.kJ0Xzy/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [708 B] 135s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x libjson-perl all 4.10000-1 [81.9 kB] 135s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-common all 257 [36.2 kB] 135s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 135s Get:5 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-common all 257 [162 kB] 135s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x libllvm17 s390x 1:17.0.6-5build1 [31.2 MB] 139s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x libpq5 s390x 16.2-1 [143 kB] 139s Get:8 http://ftpmaster.internal/ubuntu noble/main s390x libxslt1.1 s390x 1.1.39-0exp1 [170 kB] 139s Get:9 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-16 s390x 16.2-1 [1295 kB] 139s Get:10 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-16 s390x 16.2-1 [16.7 MB] 139s Get:11 http://ftpmaster.internal/ubuntu noble/main s390x postgresql all 16+257 [11.4 kB] 139s Get:12 http://ftpmaster.internal/ubuntu noble/universe s390x pspg s390x 5.8.1-1 [163 kB] 139s Preconfiguring packages ... 140s Fetched 50.0 MB in 5s (10.4 MB/s) 140s Selecting previously unselected package libjson-perl. 140s (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 ... 51726 files and directories currently installed.) 140s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 140s Unpacking libjson-perl (4.10000-1) ... 140s Selecting previously unselected package postgresql-client-common. 140s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 140s Unpacking postgresql-client-common (257) ... 140s Selecting previously unselected package ssl-cert. 140s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 140s Unpacking ssl-cert (1.1.2ubuntu1) ... 140s Selecting previously unselected package postgresql-common. 140s Preparing to unpack .../03-postgresql-common_257_all.deb ... 140s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 140s Unpacking postgresql-common (257) ... 140s Selecting previously unselected package libllvm17:s390x. 140s Preparing to unpack .../04-libllvm17_1%3a17.0.6-5build1_s390x.deb ... 140s Unpacking libllvm17:s390x (1:17.0.6-5build1) ... 141s Selecting previously unselected package libpq5:s390x. 141s Preparing to unpack .../05-libpq5_16.2-1_s390x.deb ... 141s Unpacking libpq5:s390x (16.2-1) ... 141s Selecting previously unselected package libxslt1.1:s390x. 141s Preparing to unpack .../06-libxslt1.1_1.1.39-0exp1_s390x.deb ... 141s Unpacking libxslt1.1:s390x (1.1.39-0exp1) ... 141s Selecting previously unselected package postgresql-client-16. 141s Preparing to unpack .../07-postgresql-client-16_16.2-1_s390x.deb ... 141s Unpacking postgresql-client-16 (16.2-1) ... 141s Selecting previously unselected package postgresql-16. 141s Preparing to unpack .../08-postgresql-16_16.2-1_s390x.deb ... 141s Unpacking postgresql-16 (16.2-1) ... 141s Selecting previously unselected package postgresql. 141s Preparing to unpack .../09-postgresql_16+257_all.deb ... 141s Unpacking postgresql (16+257) ... 141s Selecting previously unselected package pspg. 141s Preparing to unpack .../10-pspg_5.8.1-1_s390x.deb ... 141s Unpacking pspg (5.8.1-1) ... 141s Selecting previously unselected package autopkgtest-satdep. 141s Preparing to unpack .../11-1-autopkgtest-satdep.deb ... 141s Unpacking autopkgtest-satdep (0) ... 141s Setting up postgresql-client-common (257) ... 141s Setting up libpq5:s390x (16.2-1) ... 141s Setting up pspg (5.8.1-1) ... 141s Setting up ssl-cert (1.1.2ubuntu1) ... 143s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 143s Setting up libjson-perl (4.10000-1) ... 143s Setting up libxslt1.1:s390x (1.1.39-0exp1) ... 143s Setting up libllvm17:s390x (1:17.0.6-5build1) ... 143s Setting up postgresql-client-16 (16.2-1) ... 143s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 143s Setting up postgresql-common (257) ... 144s 144s Creating config file /etc/postgresql-common/createcluster.conf with new version 144s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 144s Removing obsolete dictionary files: 145s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 145s Setting up postgresql-16 (16.2-1) ... 145s Creating new PostgreSQL cluster 16/main ... 145s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 145s The files belonging to this database system will be owned by user "postgres". 145s This user must also own the server process. 145s 145s The database cluster will be initialized with locale "C.UTF-8". 145s The default database encoding has accordingly been set to "UTF8". 145s The default text search configuration will be set to "english". 145s 145s Data page checksums are disabled. 145s 145s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 145s creating subdirectories ... ok 145s selecting dynamic shared memory implementation ... posix 145s selecting default max_connections ... 100 145s selecting default shared_buffers ... 128MB 145s selecting default time zone ... Etc/UTC 145s creating configuration files ... ok 146s running bootstrap script ... ok 146s performing post-bootstrap initialization ... ok 146s syncing data to disk ... ok 150s Setting up postgresql (16+257) ... 150s Setting up autopkgtest-satdep (0) ... 150s Processing triggers for man-db (2.12.0-3) ... 150s Processing triggers for libc-bin (2.39-0ubuntu6) ... 153s (Reading database ... 53677 files and directories currently installed.) 153s Removing autopkgtest-satdep (0) ... 153s autopkgtest [12:47:09]: test pspg: [----------------------- 154s + pg_virtualenv 154s Creating new PostgreSQL cluster 16/regress ... 157s + LC_ALL=C 157s + pspg -q 'select 1 a, 2 b, 3 c' --ni 157s + cat test.out 157s +---+---+---+ 157s | a | b | c | 157s +---+---+---+ 157s | 1 | 2 | 3 | 157s +---+---+---+ 157s (1 rows) 157s + fgrep '| 1 | 2 | 3 |' test.out 157s | 1 | 2 | 3 | 157s Dropping cluster 16/regress ... 157s + rm -f test.out 157s autopkgtest [12:47:13]: test pspg: -----------------------] 158s autopkgtest [12:47:14]: test pspg: - - - - - - - - - - results - - - - - - - - - - 158s pspg PASS 158s autopkgtest [12:47:14]: @@@@@@@@@@@@@@@@@@@@ summary 158s pspg PASS 170s Creating nova instance adt-noble-s390x-pspg-20240326-124436-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-s390x-server-20240326.img (UUID c527e0e4-2e65-4e86-ad63-05d7f665f2fb)...