0s autopkgtest [06:51:51]: starting date and time: 2025-02-22 06:51:51+0000 0s autopkgtest [06:51:51]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:51:51]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.d5quueo1/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-plproxy --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-2.secgroup --name adt-plucky-s390x-postgresql-plproxy-20250222-065151-juju-7f2275-prod-proposed-migration-environment-20-183cd2b6-bf86-45ae-ae56-edd9f0b5b47d --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/ 81s autopkgtest [06:53:12]: testbed dpkg architecture: s390x 81s autopkgtest [06:53:12]: testbed apt version: 2.9.30ubuntu1 81s autopkgtest [06:53:12]: @@@@@@@@@@@@@@@@@@@@ test bed setup 81s autopkgtest [06:53:12]: testbed release detected to be: None 82s autopkgtest [06:53:13]: updating testbed package index (apt update) 82s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 83s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 83s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 83s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 83s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 83s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 83s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 83s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 83s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [125 kB] 83s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [760 B] 83s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [424 kB] 83s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [2816 B] 83s Fetched 1264 kB in 1s (1476 kB/s) 84s Reading package lists... 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 85s Calculating upgrade... 85s Calculating upgrade... 85s The following packages were automatically installed and are no longer required: 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 Use 'sudo apt autoremove' to remove them. 85s The following packages will be upgraded: 85s curl libcurl3t64-gnutls libcurl4t64 85s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 85s Need to get 1041 kB of archives. 85s After this operation, 7168 B disk space will be freed. 85s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x curl s390x 8.12.1-2ubuntu1 [251 kB] 85s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl4t64 s390x 8.12.1-2ubuntu1 [397 kB] 85s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libcurl3t64-gnutls s390x 8.12.1-2ubuntu1 [393 kB] 85s Fetched 1041 kB in 1s (1969 kB/s) 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 Preparing to unpack .../curl_8.12.1-2ubuntu1_s390x.deb ... 86s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 86s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_s390x.deb ... 86s Unpacking libcurl4t64:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 86s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_s390x.deb ... 86s Unpacking libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 86s Setting up libcurl4t64:s390x (8.12.1-2ubuntu1) ... 86s Setting up libcurl3t64-gnutls:s390x (8.12.1-2ubuntu1) ... 86s Setting up curl (8.12.1-2ubuntu1) ... 86s Processing triggers for man-db (2.13.0-1) ... 86s Processing triggers for libc-bin (2.40-4ubuntu1) ... 86s Reading package lists... 86s Building dependency tree... 86s Reading state information... 86s Solving dependencies... 87s The following packages will be REMOVED: 87s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 87s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 87s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 87s linux-tools-6.11.0-8-generic* 87s 0 upgraded, 0 newly installed, 9 to remove and 0 not upgraded. 87s After this operation, 167 MB disk space will be freed. 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 ... 81030 files and directories currently installed.) 87s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 87s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 87s Removing libpython3.12t64:s390x (3.12.9-1) ... 87s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 87s Removing libnsl2:s390x (1.3.0-3build3) ... 87s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 87s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 87s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 88s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 88s Processing triggers for libc-bin (2.40-4ubuntu1) ... 88s (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.) 88s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 88s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 88s autopkgtest [06:53:19]: upgrading testbed (apt dist-upgrade and autopurge) 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 88s Starting 2 pkgProblemResolver with broken count: 0 88s Done 89s Entering ResolveByKeep 89s 89s Calculating upgrade... 89s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 89s Reading package lists... 89s Building dependency tree... 89s Reading state information... 89s Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 90s Solving dependencies... 90s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 90s autopkgtest [06:53:21]: rebooting testbed after setup commands that affected boot 109s autopkgtest [06:53:40]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 15:05:57 UTC 2025 111s autopkgtest [06:53:42]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-plproxy 113s Get:1 http://ftpmaster.internal/ubuntu plucky/universe postgresql-plproxy 2.11.0-12 (dsc) [2230 B] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/universe postgresql-plproxy 2.11.0-12 (tar) [78.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/universe postgresql-plproxy 2.11.0-12 (diff) [4484 B] 113s gpgv: Signature made Sat Sep 14 21:50:33 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-plproxy_2.11.0-12.dsc: no acceptable signature found 113s autopkgtest [06:53:44]: testing package postgresql-plproxy version 2.11.0-12 113s autopkgtest [06:53:44]: build not needed 113s autopkgtest [06:53:44]: 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-plproxy 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.9 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] 115s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 273 [47.5 kB] 115s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 115s 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] 116s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 116s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 116s 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-plproxy s390x 2.11.0-12 [137 kB] 117s Preconfiguring packages ... 117s Fetched 49.9 MB in 3s (17.4 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. 118s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 118s Unpacking libipc-run-perl (20231003.0-2) ... 118s Selecting previously unselected package postgresql-common-dev. 118s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 118s Unpacking postgresql-common-dev (273) ... 118s Selecting previously unselected package ssl-cert. 118s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 118s Unpacking ssl-cert (1.1.3ubuntu1) ... 118s Selecting previously unselected package postgresql-common. 118s Preparing to unpack .../06-postgresql-common_273_all.deb ... 118s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 118s Unpacking postgresql-common (273) ... 118s Selecting previously unselected package libllvm20:s390x. 118s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 118s 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) ... 119s Selecting previously unselected package postgresql-17-plproxy. 119s Preparing to unpack .../12-postgresql-17-plproxy_2.11.0-12_s390x.deb ... 119s Unpacking postgresql-17-plproxy (2.11.0-12) ... 119s Setting up postgresql-client-common (273) ... 119s Setting up libio-pty-perl (1:1.20-1build3) ... 119s Setting up libpq5:s390x (17.4-1) ... 119s Setting up ssl-cert (1.1.3ubuntu1) ... 119s 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) ... 120s Creating config file /etc/postgresql-common/createcluster.conf with new version 120s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 120s 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) ... 121s Creating new PostgreSQL cluster 17/main ... 121s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 121s The files belonging to this database system will be owned by user "postgres". 121s This user must also own the server process. 121s 121s The database cluster will be initialized with locale "C.UTF-8". 121s The default database encoding has accordingly been set to "UTF8". 121s The default text search configuration will be set to "english". 121s 121s Data page checksums are disabled. 121s 121s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 121s creating subdirectories ... ok 121s selecting dynamic shared memory implementation ... posix 121s selecting default "max_connections" ... 100 121s selecting default "shared_buffers" ... 128MB 121s selecting default time zone ... Etc/UTC 121s creating configuration files ... ok 121s running bootstrap script ... ok 121s performing post-bootstrap initialization ... ok 121s syncing data to disk ... ok 124s Setting up postgresql-17-plproxy (2.11.0-12) ... 124s Processing triggers for man-db (2.13.0-1) ... 125s Processing triggers for libc-bin (2.40-4ubuntu1) ... 126s autopkgtest [06:53:57]: test installcheck: [----------------------- 127s ### PostgreSQL 17 installcheck ### 127s Creating new PostgreSQL cluster 17/regress ... 130s make: Entering directory '/tmp/autopkgtest.0xwNRo/build.0AZ/src/test' 130s echo "# +++ regress install-check in +++" && /usr/lib/postgresql/17/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=/tmp/autopkgtest.0xwNRo/build.0AZ/src --bindir='/usr/lib/postgresql/17/bin' --inputdir=test --dbname=regression plproxy_init plproxy_test plproxy_select plproxy_many plproxy_errors plproxy_clustermap plproxy_dynamic_record plproxy_encoding plproxy_split plproxy_target plproxy_alter plproxy_cancel plproxy_range plproxy_sqlmed plproxy_table plproxy_modular 130s # +++ regress install-check in +++ 130s # using postmaster on localhost, port 5432 130s ok 1 - plproxy_init 97 ms 130s ok 2 - plproxy_test 356 ms 130s ok 3 - plproxy_select 86 ms 130s ok 4 - plproxy_many 90 ms 130s ok 5 - plproxy_errors 37 ms 130s ok 6 - plproxy_clustermap 36 ms 130s ok 7 - plproxy_dynamic_record 33 ms 131s ok 8 - plproxy_encoding 255 ms 131s ok 9 - plproxy_split 91 ms 131s ok 10 - plproxy_target 47 ms 131s ok 11 - plproxy_alter 105 ms 132s ok 12 - plproxy_cancel 1070 ms 132s ok 13 - plproxy_range 42 ms 132s ok 14 - plproxy_sqlmed 99 ms 132s ok 15 - plproxy_table 36 ms 132s ok 16 - plproxy_modular 36 ms 132s 1..16 132s # All 16 tests passed. 132s make: Leaving directory '/tmp/autopkgtest.0xwNRo/build.0AZ/src/test' 132s Dropping cluster 17/regress ... 132s ### End 17 installcheck ### 133s autopkgtest [06:54:04]: test installcheck: -----------------------] 133s installcheck PASS 133s autopkgtest [06:54:04]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 133s autopkgtest [06:54:04]: @@@@@@@@@@@@@@@@@@@@ summary 133s installcheck PASS 151s nova [W] Using flock in prodstack6-s390x 151s Creating nova instance adt-plucky-s390x-postgresql-plproxy-20250222-065151-juju-7f2275-prod-proposed-migration-environment-20-183cd2b6-bf86-45ae-ae56-edd9f0b5b47d from image adt/ubuntu-plucky-s390x-server-20250222.img (UUID ae633cda-0dee-481c-9805-d0ef3f3b5166)... 151s nova [W] Timed out waiting for 6426e5f3-1eac-4dd2-a8db-b74f5f5ee358 to get deleted.