0s autopkgtest [06:53:02]: starting date and time: 2025-02-22 06:53:02+0000 0s autopkgtest [06:53:02]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:53:02]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.60c0d20o/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade postgresql-set-user --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-s390x-24.secgroup --name adt-plucky-s390x-postgresql-set-user-20250222-065301-juju-7f2275-prod-proposed-migration-environment-20-fe884aea-da77-4473-a733-6f21fea393a0 --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-s390x -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,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 80s autopkgtest [06:54:22]: testbed dpkg architecture: s390x 80s autopkgtest [06:54:22]: testbed apt version: 2.9.30ubuntu1 80s autopkgtest [06:54:22]: @@@@@@@@@@@@@@@@@@@@ test bed setup 80s autopkgtest [06:54:22]: testbed release detected to be: None 81s autopkgtest [06:54:23]: updating testbed package index (apt update) 81s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 81s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 82s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 82s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 82s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 82s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 82s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 82s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 82s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [125 kB] 82s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [760 B] 82s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [424 kB] 82s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [2816 B] 82s Fetched 1264 kB in 1s (1493 kB/s) 83s Reading package lists... 83s Reading package lists... 83s Building dependency tree... 83s Reading state information... 83s Calculating upgrade... 83s Calculating upgrade... 84s The following packages were automatically installed and are no longer required: 84s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 84s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 84s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 84s linux-tools-6.11.0-8-generic 84s Use 'sudo apt autoremove' to remove them. 84s The following packages will be upgraded: 84s curl libcurl3t64-gnutls libcurl4t64 84s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 84s Need to get 1041 kB of archives. 84s After this operation, 7168 B disk space will be freed. 84s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x curl s390x 8.12.1-2ubuntu1 [251 kB] 84s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl4t64 s390x 8.12.1-2ubuntu1 [397 kB] 84s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl3t64-gnutls s390x 8.12.1-2ubuntu1 [393 kB] 84s Fetched 1041 kB in 1s (1898 kB/s) 84s (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 ... 81030 files and directories currently installed.) 84s Preparing to unpack .../curl_8.12.1-2ubuntu1_s390x.deb ... 84s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_s390x.deb ... 84s Unpacking libcurl4t64:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_s390x.deb ... 84s Unpacking libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Setting up libcurl4t64:s390x (8.12.1-2ubuntu1) ... 84s Setting up libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) ... 84s Setting up curl (8.12.1-2ubuntu1) ... 84s Processing triggers for man-db (2.13.0-1) ... 85s Processing triggers for libc-bin (2.40-4ubuntu1) ... 85s Reading package lists... 85s Building dependency tree... 85s Reading state information... 85s Solving dependencies... 85s The following packages will be REMOVED: 85s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 85s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 85s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 85s linux-tools-6.11.0-8-generic* 85s 0 upgraded, 0 newly installed, 9 to remove and 0 not upgraded. 85s After this operation, 167 MB disk space will be freed. 86s (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 ... 81030 files and directories currently installed.) 86s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 86s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 86s Removing libpython3.12t64:s390x (3.12.9-1) ... 86s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 86s Removing libnsl2:s390x (1.3.0-3build3) ... 86s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 86s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 86s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 86s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 86s Processing triggers for libc-bin (2.40-4ubuntu1) ... 87s (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 ... 55930 files and directories currently installed.) 87s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 87s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 87s autopkgtest [06:54:29]: upgrading testbed (apt dist-upgrade and autopurge) 87s Reading package lists... 87s Building dependency tree... 87s Reading state information... 87s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 87s Starting 2 pkgProblemResolver with broken count: 0 87s Done 87s Entering ResolveByKeep 87s 87s Calculating upgrade... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s Starting pkgProblemResolver with broken count: 0 88s Starting 2 pkgProblemResolver with broken count: 0 88s Done 88s Solving dependencies... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 88s autopkgtest [06:54:30]: rebooting testbed after setup commands that affected boot 109s autopkgtest [06:54:51]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 15:05:57 UTC 2025 111s autopkgtest [06:54:53]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-set-user 113s Get:1 http://ftpmaster.internal/ubuntu plucky/universe postgresql-set-user 4.1.0-1 (dsc) [2188 B] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/universe postgresql-set-user 4.1.0-1 (tar) [23.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/universe postgresql-set-user 4.1.0-1 (diff) [2824 B] 113s gpgv: Signature made Sun Sep 15 11:53:12 2024 UTC 113s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 113s gpgv: Can't check signature: No public key 113s dpkg-source: warning: cannot verify inline signature for ./postgresql-set-user_4.1.0-1.dsc: no acceptable signature found 113s autopkgtest [06:54:55]: testing package postgresql-set-user version 4.1.0-1 113s autopkgtest [06:54:55]: build not needed 113s autopkgtest [06:54:55]: test installcheck: preparing testbed 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s Starting pkgProblemResolver with broken count: 0 114s Starting 2 pkgProblemResolver with broken count: 0 114s Done 114s The following NEW packages will be installed: 114s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 114s postgresql-17 postgresql-17-set-user postgresql-client-17 114s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 114s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 114s Need to get 49.8 MB of archives. 114s After this operation, 213 MB of additional disk space will be used. 114s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 114s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 273 [47.5 kB] 114s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 114s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 115s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 273 [72.9 kB] 115s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 115s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 273 [101 kB] 115s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 115s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libpq5 s390x 17.4-1 [147 kB] 115s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 115s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 115s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 117s Get:13 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-17-set-user s390x 4.1.0-1 [36.3 kB] 117s Preconfiguring packages ... 117s Fetched 49.8 MB in 3s (19.3 MB/s) 117s Selecting previously unselected package libjson-perl. 117s (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 ... 55928 files and directories currently installed.) 117s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 117s Unpacking libjson-perl (4.10000-1) ... 117s Selecting previously unselected package postgresql-client-common. 117s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 117s Unpacking postgresql-client-common (273) ... 117s Selecting previously unselected package libio-pty-perl. 117s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 117s Unpacking libio-pty-perl (1:1.20-1build3) ... 117s Selecting previously unselected package libipc-run-perl. 117s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 117s Unpacking libipc-run-perl (20231003.0-2) ... 117s Selecting previously unselected package postgresql-common-dev. 117s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 117s Unpacking postgresql-common-dev (273) ... 117s Selecting previously unselected package ssl-cert. 117s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 117s Unpacking ssl-cert (1.1.3ubuntu1) ... 117s Selecting previously unselected package postgresql-common. 117s Preparing to unpack .../06-postgresql-common_273_all.deb ... 117s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 117s Unpacking postgresql-common (273) ... 117s Selecting previously unselected package libllvm20:s390x. 117s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 117s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 118s Selecting previously unselected package libpq5:s390x. 118s Preparing to unpack .../08-libpq5_17.4-1_s390x.deb ... 118s Unpacking libpq5:s390x (17.4-1) ... 118s Selecting previously unselected package libxslt1.1:s390x. 118s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 118s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 118s Selecting previously unselected package postgresql-client-17. 118s Preparing to unpack .../10-postgresql-client-17_17.4-1_s390x.deb ... 118s Unpacking postgresql-client-17 (17.4-1) ... 118s Selecting previously unselected package postgresql-17. 118s Preparing to unpack .../11-postgresql-17_17.4-1_s390x.deb ... 118s Unpacking postgresql-17 (17.4-1) ... 118s Selecting previously unselected package postgresql-17-set-user. 118s Preparing to unpack .../12-postgresql-17-set-user_4.1.0-1_s390x.deb ... 118s Unpacking postgresql-17-set-user (4.1.0-1) ... 118s Setting up postgresql-client-common (273) ... 118s Setting up libio-pty-perl (1:1.20-1build3) ... 118s Setting up libpq5:s390x (17.4-1) ... 118s Setting up ssl-cert (1.1.3ubuntu1) ... 118s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 119s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 119s Setting up libipc-run-perl (20231003.0-2) ... 119s Setting up libjson-perl (4.10000-1) ... 119s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 119s Setting up postgresql-common-dev (273) ... 119s Setting up postgresql-client-17 (17.4-1) ... 119s 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 119s Setting up postgresql-common (273) ... 119s Creating config file /etc/postgresql-common/createcluster.conf with new version 119s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 119s Removing obsolete dictionary files: 120s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 120s Setting up postgresql-17 (17.4-1) ... 120s Creating new PostgreSQL cluster 17/main ... 120s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 120s The files belonging to this database system will be owned by user "postgres". 120s This user must also own the server process. 120s 120s The database cluster will be initialized with locale "C.UTF-8". 120s The default database encoding has accordingly been set to "UTF8". 120s The default text search configuration will be set to "english". 120s 120s Data page checksums are disabled. 120s 120s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 120s creating subdirectories ... ok 120s selecting dynamic shared memory implementation ... posix 120s selecting default "max_connections" ... 100 120s selecting default "shared_buffers" ... 128MB 120s selecting default time zone ... Etc/UTC 120s creating configuration files ... ok 120s running bootstrap script ... ok 121s performing post-bootstrap initialization ... ok 121s syncing data to disk ... ok 123s Setting up postgresql-17-set-user (4.1.0-1) ... 123s Processing triggers for man-db (2.13.0-1) ... 124s Processing triggers for libc-bin (2.40-4ubuntu1) ... 125s autopkgtest [06:55:07]: test installcheck: [----------------------- 125s ### PostgreSQL 17 installcheck ### 125s Creating new PostgreSQL cluster 17/regress ... 132s Warning: connection to the database failed, disabling startup checks: 132s psql: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed: FATAL: role "ubuntu" does not exist 132s 132s echo "# +++ regress install-check in +++" && /usr/lib/postgresql/17/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/17/bin' --dbname=contrib_regression set_user 132s # +++ regress install-check in +++ 132s # using postmaster on localhost, port 5433 132s ok 1 - set_user 27 ms 132s 1..1 132s # All 1 tests passed. 132s Dropping cluster 17/regress ... 132s rm -f src/set_user.so src/set_user.o \ 132s src/set_user.bc 132s rm -rf extension/set_user--4.1.0.sql 132s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 132s ### End 17 installcheck ### 133s autopkgtest [06:55:15]: test installcheck: -----------------------] 133s installcheck PASS 133s autopkgtest [06:55:15]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 133s autopkgtest [06:55:15]: @@@@@@@@@@@@@@@@@@@@ summary 133s installcheck PASS 150s nova [W] Using flock in prodstack6-s390x 150s Creating nova instance adt-plucky-s390x-postgresql-set-user-20250222-065301-juju-7f2275-prod-proposed-migration-environment-20-fe884aea-da77-4473-a733-6f21fea393a0 from image adt/ubuntu-plucky-s390x-server-20250222.img (UUID ae633cda-0dee-481c-9805-d0ef3f3b5166)... 150s nova [W] Timed out waiting for 0bfcfc7e-a107-41cf-90bf-17c6b91761d6 to get deleted.