0s autopkgtest [11:40:49]: starting date and time: 2025-05-03 11:40:49+0000 0s autopkgtest [11:40:49]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [11:40:49]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.mwxkjqkt/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:make-dfsg --apt-upgrade pg-fact-loader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=make-dfsg/4.4.1-2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-8.secgroup --name adt-questing-ppc64el-pg-fact-loader-20250503-114049-juju-7f2275-prod-proposed-migration-environment-2-e499b713-c87b-4175-b7eb-f776bd8ec3ab --image adt/ubuntu-questing-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 89s autopkgtest [11:42:18]: testbed dpkg architecture: ppc64el 89s autopkgtest [11:42:18]: testbed apt version: 3.0.0 90s autopkgtest [11:42:19]: @@@@@@@@@@@@@@@@@@@@ test bed setup 90s autopkgtest [11:42:19]: testbed release detected to be: None 91s autopkgtest [11:42:20]: updating testbed package index (apt update) 91s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 91s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 91s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 91s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 91s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.6 kB] 91s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1655 kB] 92s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [155 kB] 92s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el Packages [187 kB] 92s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe ppc64el Packages [1285 kB] 92s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse ppc64el Packages [14.1 kB] 92s Fetched 3452 kB in 1s (2596 kB/s) 93s Reading package lists... 94s autopkgtest [11:42:23]: upgrading testbed (apt dist-upgrade and autopurge) 94s Reading package lists... 94s Building dependency tree... 94s Reading state information... 95s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 95s Entering ResolveByKeep 95s 96s Calculating upgrade... 96s The following packages will be upgraded: 96s debianutils libnftnl11 make python3-lazr.restfulclient 96s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 96s Need to get 455 kB of archives. 96s After this operation, 1024 B of additional disk space will be used. 96s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el debianutils ppc64el 5.22 [93.9 kB] 96s Get:2 http://ftpmaster.internal/ubuntu questing/main ppc64el libnftnl11 ppc64el 1.2.9-1 [77.1 kB] 96s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el make ppc64el 4.4.1-2 [233 kB] 96s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 97s Fetched 455 kB in 0s (951 kB/s) 97s (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 ... 107205 files and directories currently installed.) 97s Preparing to unpack .../debianutils_5.22_ppc64el.deb ... 97s Unpacking debianutils (5.22) over (5.21) ... 97s Setting up debianutils (5.22) ... 97s (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 ... 107205 files and directories currently installed.) 97s Preparing to unpack .../libnftnl11_1.2.9-1_ppc64el.deb ... 97s Unpacking libnftnl11:ppc64el (1.2.9-1) over (1.2.8-1) ... 97s Preparing to unpack .../make_4.4.1-2_ppc64el.deb ... 97s Unpacking make (4.4.1-2) over (4.4.1-1) ... 97s Preparing to unpack .../python3-lazr.restfulclient_0.14.6-3_all.deb ... 97s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 97s Setting up libnftnl11:ppc64el (1.2.9-1) ... 97s Setting up make (4.4.1-2) ... 97s Setting up python3-lazr.restfulclient (0.14.6-3) ... 97s Processing triggers for man-db (2.13.0-1) ... 99s Processing triggers for libc-bin (2.41-6ubuntu1) ... 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s Starting pkgProblemResolver with broken count: 0 100s Starting 2 pkgProblemResolver with broken count: 0 100s Done 100s Solving dependencies... 100s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s autopkgtest [11:42:32]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 14:52:42 UTC 2025 103s autopkgtest [11:42:32]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-fact-loader 105s Get:1 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (dsc) [2295 B] 105s Get:2 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (tar) [277 kB] 105s Get:3 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (diff) [3756 B] 105s gpgv: Signature made Tue Sep 17 16:27:43 2024 UTC 105s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 105s gpgv: Can't check signature: No public key 105s dpkg-source: warning: cannot verify inline signature for ./pg-fact-loader_2.0.1-4.dsc: no acceptable signature found 105s autopkgtest [11:42:34]: testing package pg-fact-loader version 2.0.1-4 106s autopkgtest [11:42:35]: build not needed 106s autopkgtest [11:42:35]: test installcheck: preparing testbed 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 107s Starting pkgProblemResolver with broken count: 0 107s Starting 2 pkgProblemResolver with broken count: 0 107s Done 107s The following NEW packages will be installed: 107s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 107s postgresql-17 postgresql-17-pg-fact-loader postgresql-17-pglogical 107s postgresql-17-pglogical-ticker postgresql-client-17 postgresql-client-common 107s postgresql-common postgresql-common-dev ssl-cert 108s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 108s Need to get 51.9 MB of archives. 108s After this operation, 224 MB of additional disk space will be used. 108s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 108s Get:2 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-common all 274 [47.6 kB] 108s Get:3 http://ftpmaster.internal/ubuntu questing/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 108s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 108s Get:5 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common-dev all 274 [73.0 kB] 108s Get:6 http://ftpmaster.internal/ubuntu questing/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 108s Get:7 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common all 274 [101 kB] 108s Get:8 http://ftpmaster.internal/ubuntu questing/main ppc64el libllvm20 ppc64el 1:20.1.2-0ubuntu1 [32.0 MB] 109s Get:9 http://ftpmaster.internal/ubuntu questing/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 109s Get:10 http://ftpmaster.internal/ubuntu questing/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu4 [191 kB] 109s Get:11 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 109s Get:12 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 109s Get:13 http://ftpmaster.internal/ubuntu questing/universe ppc64el postgresql-17-pg-fact-loader ppc64el 2.0.1-4 [42.2 kB] 109s Get:14 http://ftpmaster.internal/ubuntu questing/universe ppc64el postgresql-17-pglogical ppc64el 2.4.5-1 [394 kB] 109s Get:15 http://ftpmaster.internal/ubuntu questing/universe ppc64el postgresql-17-pglogical-ticker ppc64el 1.4.1-8 [23.0 kB] 110s Preconfiguring packages ... 110s Fetched 51.9 MB in 2s (27.0 MB/s) 110s Selecting previously unselected package libjson-perl. 110s (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 ... 107205 files and directories currently installed.) 110s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 110s Unpacking libjson-perl (4.10000-1) ... 110s Selecting previously unselected package postgresql-client-common. 110s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 110s Unpacking postgresql-client-common (274) ... 110s Selecting previously unselected package libio-pty-perl. 110s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 110s Unpacking libio-pty-perl (1:1.20-1build3) ... 110s Selecting previously unselected package libipc-run-perl. 110s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 110s Unpacking libipc-run-perl (20231003.0-2) ... 110s Selecting previously unselected package postgresql-common-dev. 110s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 110s Unpacking postgresql-common-dev (274) ... 110s Selecting previously unselected package ssl-cert. 110s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 110s Unpacking ssl-cert (1.1.3ubuntu1) ... 110s Selecting previously unselected package postgresql-common. 110s Preparing to unpack .../06-postgresql-common_274_all.deb ... 110s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 110s Unpacking postgresql-common (274) ... 110s Selecting previously unselected package libllvm20:ppc64el. 110s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 110s Unpacking libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 111s Selecting previously unselected package libpq5:ppc64el. 111s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 111s Unpacking libpq5:ppc64el (17.4-1) ... 111s Selecting previously unselected package libxslt1.1:ppc64el. 111s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_ppc64el.deb ... 111s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 111s Selecting previously unselected package postgresql-client-17. 111s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 111s Unpacking postgresql-client-17 (17.4-1) ... 111s Selecting previously unselected package postgresql-17. 111s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 111s Unpacking postgresql-17 (17.4-1) ... 111s Selecting previously unselected package postgresql-17-pg-fact-loader. 111s Preparing to unpack .../12-postgresql-17-pg-fact-loader_2.0.1-4_ppc64el.deb ... 111s Unpacking postgresql-17-pg-fact-loader (2.0.1-4) ... 111s Selecting previously unselected package postgresql-17-pglogical. 111s Preparing to unpack .../13-postgresql-17-pglogical_2.4.5-1_ppc64el.deb ... 111s Unpacking postgresql-17-pglogical (2.4.5-1) ... 111s Selecting previously unselected package postgresql-17-pglogical-ticker. 111s Preparing to unpack .../14-postgresql-17-pglogical-ticker_1.4.1-8_ppc64el.deb ... 111s Unpacking postgresql-17-pglogical-ticker (1.4.1-8) ... 111s Setting up postgresql-client-common (274) ... 111s Setting up libio-pty-perl (1:1.20-1build3) ... 111s Setting up libpq5:ppc64el (17.4-1) ... 111s Setting up ssl-cert (1.1.3ubuntu1) ... 112s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 112s Setting up libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 112s Setting up libipc-run-perl (20231003.0-2) ... 112s Setting up libjson-perl (4.10000-1) ... 112s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 112s Setting up postgresql-common-dev (274) ... 112s Setting up postgresql-client-17 (17.4-1) ... 112s 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 112s Setting up postgresql-common (274) ... 113s Creating config file /etc/postgresql-common/createcluster.conf with new version 113s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 113s Removing obsolete dictionary files: 114s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 114s Setting up postgresql-17 (17.4-1) ... 115s Creating new PostgreSQL cluster 17/main ... 115s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 115s The files belonging to this database system will be owned by user "postgres". 115s This user must also own the server process. 115s 115s The database cluster will be initialized with locale "C.UTF-8". 115s The default database encoding has accordingly been set to "UTF8". 115s The default text search configuration will be set to "english". 115s 115s Data page checksums are disabled. 115s 115s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 115s creating subdirectories ... ok 115s selecting dynamic shared memory implementation ... posix 115s selecting default "max_connections" ... 100 115s selecting default "shared_buffers" ... 128MB 115s selecting default time zone ... Etc/UTC 115s creating configuration files ... ok 115s running bootstrap script ... ok 116s performing post-bootstrap initialization ... ok 116s syncing data to disk ... ok 119s Setting up postgresql-17-pglogical (2.4.5-1) ... 119s Setting up postgresql-17-pg-fact-loader (2.0.1-4) ... 119s Setting up postgresql-17-pglogical-ticker (1.4.1-8) ... 119s Processing triggers for man-db (2.13.0-1) ... 119s Processing triggers for libc-bin (2.41-6ubuntu1) ... 120s autopkgtest [11:42:49]: test installcheck: [----------------------- 120s ### PostgreSQL 17 installcheck ### 120s Creating new PostgreSQL cluster 17/regress ... 123s 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_schema 03_audit 04_seeds 05_pgl_setup 06_basic_workers 07_launch_worker 08_fact_table_deps 09_purge 10_delete 11_more_data 12_no_proid 13_cutoff_no_dep_on_filter 14_null_key 15_source_change_date 16_1_2_features 17_1_3_features 123s # +++ regress install-check in +++ 123s # using postmaster on localhost, port 5433 123s ok 1 - 01_create_ext 265 ms 123s ok 2 - 02_schema 147 ms 124s ok 3 - 03_audit 57 ms 124s ok 4 - 04_seeds 98 ms 124s ok 5 - 05_pgl_setup 45 ms 138s ok 6 - 06_basic_workers 14219 ms 139s ok 7 - 07_launch_worker 1330 ms 143s ok 8 - 08_fact_table_deps 4125 ms 144s ok 9 - 09_purge 243 ms 163s ok 10 - 10_delete 18976 ms 172s ok 11 - 11_more_data 9098 ms 187s ok 12 - 12_no_proid 15514 ms 244s ok 13 - 13_cutoff_no_dep_on_filter 57003 ms 245s ok 14 - 14_null_key 312 ms 245s ok 15 - 15_source_change_date 127 ms 250s ok 16 - 16_1_2_features 5295 ms 250s ok 17 - 17_1_3_features 288 ms 250s 1..17 250s # All 17 tests passed. 250s Dropping cluster 17/regress ... 251s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 251s ### End 17 installcheck ### 251s autopkgtest [11:45:00]: test installcheck: -----------------------] 251s installcheck PASS 251s autopkgtest [11:45:00]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 252s autopkgtest [11:45:01]: @@@@@@@@@@@@@@@@@@@@ summary 252s installcheck PASS 257s nova [W] Using flock in prodstack6-ppc64el 257s Creating nova instance adt-questing-ppc64el-pg-fact-loader-20250503-114049-juju-7f2275-prod-proposed-migration-environment-2-e499b713-c87b-4175-b7eb-f776bd8ec3ab from image adt/ubuntu-questing-ppc64el-server-20250503.img (UUID 1e63be20-33d6-474d-9c56-b247a2188377)... 257s nova [W] Timed out waiting for b81531c2-54cf-4096-a2d2-6821091a8ca6 to get deleted.