0s autopkgtest [07:01:32]: starting date and time: 2025-02-22 07:01:32+0000 0s autopkgtest [07:01:32]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:01:32]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.0vtk_zsu/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgl-ddl-deploy --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-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-5.secgroup --name adt-plucky-ppc64el-pgl-ddl-deploy-20250222-070131-juju-7f2275-prod-proposed-migration-environment-20-f03cc11e-e31a-440a-a268-ad748ece5cbd --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -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/ 95s autopkgtest [07:03:07]: testbed dpkg architecture: ppc64el 96s autopkgtest [07:03:08]: testbed apt version: 2.9.30ubuntu1 96s autopkgtest [07:03:08]: @@@@@@@@@@@@@@@@@@@@ test bed setup 96s autopkgtest [07:03:08]: testbed release detected to be: None 97s autopkgtest [07:03:09]: updating testbed package index (apt update) 97s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 98s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 98s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 98s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 98s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 98s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 98s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 98s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 98s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 98s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 98s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 98s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 98s Fetched 1276 kB in 1s (1355 kB/s) 99s Reading package lists... 100s Reading package lists... 100s Building dependency tree... 100s Reading state information... 100s Calculating upgrade... 100s Calculating upgrade... 100s The following packages will be upgraded: 100s curl libcurl3t64-gnutls libcurl4t64 101s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 101s Need to get 1221 kB of archives. 101s After this operation, 3072 B disk space will be freed. 101s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 101s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 101s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 102s Fetched 1221 kB in 1s (1953 kB/s) 102s (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 ... 106371 files and directories currently installed.) 102s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 102s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 102s Setting up curl (8.12.1-2ubuntu1) ... 102s Processing triggers for man-db (2.13.0-1) ... 103s Processing triggers for libc-bin (2.40-4ubuntu1) ... 103s Reading package lists... 103s Building dependency tree... 103s Reading state information... 103s Solving dependencies... 103s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s autopkgtest [07:03:15]: upgrading testbed (apt dist-upgrade and autopurge) 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 104s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 104s Starting 2 pkgProblemResolver with broken count: 0 104s Done 105s Entering ResolveByKeep 105s 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... 106s Starting pkgProblemResolver with broken count: 0 106s Starting 2 pkgProblemResolver with broken count: 0 106s Done 106s Solving dependencies... 106s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s autopkgtest [07:03:20]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 109s autopkgtest [07:03:21]: @@@@@@@@@@@@@@@@@@@@ apt-source pgl-ddl-deploy 111s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgl-ddl-deploy 2.2.1-2 (dsc) [2281 B] 111s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgl-ddl-deploy 2.2.1-2 (tar) [360 kB] 111s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgl-ddl-deploy 2.2.1-2 (diff) [3840 B] 111s gpgv: Signature made Tue Sep 17 14:29:44 2024 UTC 111s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 111s gpgv: Can't check signature: No public key 111s dpkg-source: warning: cannot verify inline signature for ./pgl-ddl-deploy_2.2.1-2.dsc: no acceptable signature found 111s autopkgtest [07:03:23]: testing package pgl-ddl-deploy version 2.2.1-2 111s autopkgtest [07:03:23]: build not needed 112s autopkgtest [07:03:24]: test installcheck: preparing testbed 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 113s The following NEW packages will be installed: 113s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 113s postgresql-17 postgresql-17-pgl-ddl-deploy postgresql-17-pglogical 113s postgresql-client-17 postgresql-client-common postgresql-common 113s postgresql-common-dev ssl-cert 113s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 113s Need to get 51.9 MB of archives. 113s After this operation, 225 MB of additional disk space will be used. 113s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 113s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 113s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 113s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 113s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 113s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 114s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 114s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 114s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 114s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 115s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgl-ddl-deploy ppc64el 2.2.1-2 [55.4 kB] 115s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pglogical ppc64el 2.4.5-1 [394 kB] 115s Preconfiguring packages ... 115s Fetched 51.9 MB in 2s (27.9 MB/s) 115s Selecting previously unselected package libjson-perl. 115s (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 ... 106371 files and directories currently installed.) 115s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 115s Unpacking libjson-perl (4.10000-1) ... 115s Selecting previously unselected package postgresql-client-common. 115s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 115s Unpacking postgresql-client-common (273) ... 115s Selecting previously unselected package libio-pty-perl. 115s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 115s Unpacking libio-pty-perl (1:1.20-1build3) ... 115s Selecting previously unselected package libipc-run-perl. 115s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 115s Unpacking libipc-run-perl (20231003.0-2) ... 115s Selecting previously unselected package postgresql-common-dev. 115s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 115s Unpacking postgresql-common-dev (273) ... 115s Selecting previously unselected package ssl-cert. 115s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 115s Unpacking ssl-cert (1.1.3ubuntu1) ... 115s Selecting previously unselected package postgresql-common. 115s Preparing to unpack .../06-postgresql-common_273_all.deb ... 115s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 115s Unpacking postgresql-common (273) ... 115s Selecting previously unselected package libllvm20:ppc64el. 115s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 115s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 116s Selecting previously unselected package libpq5:ppc64el. 116s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 116s Unpacking libpq5:ppc64el (17.4-1) ... 116s Selecting previously unselected package libxslt1.1:ppc64el. 116s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 116s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 116s Selecting previously unselected package postgresql-client-17. 116s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 116s Unpacking postgresql-client-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17. 116s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 116s Unpacking postgresql-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17-pgl-ddl-deploy. 116s Preparing to unpack .../12-postgresql-17-pgl-ddl-deploy_2.2.1-2_ppc64el.deb ... 116s Unpacking postgresql-17-pgl-ddl-deploy (2.2.1-2) ... 116s Selecting previously unselected package postgresql-17-pglogical. 116s Preparing to unpack .../13-postgresql-17-pglogical_2.4.5-1_ppc64el.deb ... 116s Unpacking postgresql-17-pglogical (2.4.5-1) ... 116s Setting up postgresql-client-common (273) ... 116s Setting up libio-pty-perl (1:1.20-1build3) ... 116s Setting up libpq5:ppc64el (17.4-1) ... 116s Setting up ssl-cert (1.1.3ubuntu1) ... 117s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 118s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 118s Setting up libipc-run-perl (20231003.0-2) ... 118s Setting up libjson-perl (4.10000-1) ... 118s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 118s Setting up postgresql-common-dev (273) ... 118s Setting up postgresql-client-17 (17.4-1) ... 118s 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 118s 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: 119s 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 122s performing post-bootstrap initialization ... ok 122s syncing data to disk ... ok 125s Setting up postgresql-17-pglogical (2.4.5-1) ... 125s Setting up postgresql-17-pgl-ddl-deploy (2.2.1-2) ... 125s Processing triggers for man-db (2.13.0-1) ... 126s Processing triggers for libc-bin (2.40-4ubuntu1) ... 127s autopkgtest [07:03:39]: test installcheck: [----------------------- 127s ### PostgreSQL 17 installcheck ### 128s Creating new PostgreSQL cluster 17/regress ... 135s Warning: connection to the database failed, disabling startup checks: 135s psql: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed: FATAL: role "ubuntu" does not exist 135s 135s 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 01_create_ext 02_setup 03_add_configs 04_deploy 04_deploy_update 05_allowed 06_multi 07_edges 08_ignored 09_unsupported 10_no_create_user 11_override 12_sql_command_tags 13_transaction 15_new_set_behavior 16_multi_set_tags 17_include_only_repset_tables_1 18_include_only_repset_tables_2 19_include_only_repset_tables_3 20_include_only_repset_tables_4 21_unprivileged_users 22_is_deployed 23_1_4_features 24_sub_retries 25_1_5_features 26_new_setup 27_raise_message 28_1_6_features 29_create_ext 30_setup 31_add_configs 32_deploy_update 33_allowed 34_multi 35_edges 36_ignored 37_unsupported 38_no_create_user 39_override 40_sql_command_tags 41_transaction 43_new_set_behavior 44_multi_set_tags 45_include_only_repset_tables_1 46_include_only_repset_tables_2 47_include_only_repset_tables_3 48_include_only_repset_tables_4 49_unprivileged_users 50_is_deployed 51_1_4_features 52_sub_retries 53_1_5_features 54_new_setup 55_raise_message 56_1_6_features 57_native_features 135s # +++ regress install-check in +++ 135s # using postmaster on localhost, port 5433 135s ok 1 - 01_create_ext 130 ms 135s ok 2 - 02_setup 44 ms 135s ok 3 - 03_add_configs 26 ms 135s ok 4 - 04_deploy 155 ms 136s ok 5 - 04_deploy_update 260 ms 136s ok 6 - 05_allowed 309 ms 137s ok 7 - 06_multi 1264 ms 137s ok 8 - 07_edges 120 ms 137s ok 9 - 08_ignored 118 ms 138s ok 10 - 09_unsupported 73 ms 138s ok 11 - 10_no_create_user 61 ms 138s ok 12 - 11_override 29 ms 138s ok 13 - 12_sql_command_tags 22 ms 138s ok 14 - 13_transaction 144 ms 138s ok 15 - 15_new_set_behavior 148 ms 138s ok 16 - 16_multi_set_tags 99 ms 138s ok 17 - 17_include_only_repset_tables_1 84 ms 138s ok 18 - 18_include_only_repset_tables_2 105 ms 138s ok 19 - 19_include_only_repset_tables_3 160 ms 139s ok 20 - 20_include_only_repset_tables_4 217 ms 139s ok 21 - 21_unprivileged_users 54 ms 139s ok 22 - 22_is_deployed 270 ms 139s ok 23 - 23_1_4_features 174 ms 139s ok 24 - 24_sub_retries 198 ms 165s ok 25 - 25_1_5_features 25423 ms 165s ok 26 - 26_new_setup 262 ms 165s ok 27 - 27_raise_message 35 ms 165s ok 28 - 28_1_6_features 143 ms 165s ok 29 - 29_create_ext 144 ms 165s ok 30 - 30_setup 45 ms 165s ok 31 - 31_add_configs 41 ms 166s ok 32 - 32_deploy_update 245 ms 166s ok 33 - 33_allowed 360 ms 167s ok 34 - 34_multi 1073 ms 167s ok 35 - 35_edges 113 ms 167s ok 36 - 36_ignored 62 ms 167s ok 37 - 37_unsupported 66 ms 167s ok 38 - 38_no_create_user 47 ms 167s ok 39 - 39_override 25 ms 167s ok 40 - 40_sql_command_tags 22 ms 168s ok 41 - 41_transaction 191 ms 168s ok 42 - 43_new_set_behavior 138 ms 168s ok 43 - 44_multi_set_tags 105 ms 168s ok 44 - 45_include_only_repset_tables_1 74 ms 168s ok 45 - 46_include_only_repset_tables_2 102 ms 168s ok 46 - 47_include_only_repset_tables_3 120 ms 168s ok 47 - 48_include_only_repset_tables_4 272 ms 169s ok 48 - 49_unprivileged_users 45 ms 169s ok 49 - 50_is_deployed 342 ms 169s ok 50 - 51_1_4_features 185 ms 169s ok 51 - 52_sub_retries 192 ms 195s ok 52 - 53_1_5_features 25502 ms 195s ok 53 - 54_new_setup 203 ms 195s ok 54 - 55_raise_message 26 ms 195s ok 55 - 56_1_6_features 95 ms 195s ok 56 - 57_native_features 151 ms 195s 1..56 195s # All 56 tests passed. 195s Dropping cluster 17/regress ... 196s rm -f pgl_ddl_deploy.so ddl_deparse.so pgl_ddl_deploy.o ddl_deparse.o \ 196s pgl_ddl_deploy.bc ddl_deparse.bc 196s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 196s ### End 17 installcheck ### 196s autopkgtest [07:04:48]: test installcheck: -----------------------] 196s installcheck PASS 196s autopkgtest [07:04:48]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 197s autopkgtest [07:04:49]: @@@@@@@@@@@@@@@@@@@@ summary 197s installcheck PASS 213s nova [W] Using flock in prodstack6-ppc64el 213s Creating nova instance adt-plucky-ppc64el-pgl-ddl-deploy-20250222-070131-juju-7f2275-prod-proposed-migration-environment-20-f03cc11e-e31a-440a-a268-ad748ece5cbd from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 213s nova [W] Timed out waiting for f396224d-3413-4226-8272-a4829a29e372 to get deleted.