0s autopkgtest [00:33:05]: starting date and time: 2025-05-02 00:33:05+0000 0s autopkgtest [00:33:05]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [00:33:05]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.vszjhkjh/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-2.secgroup --name adt-questing-arm64-pg-fact-loader-20250502-003304-juju-7f2275-prod-proposed-migration-environment-15-533abd5c-d0d7-4cb8-86bd-c61e217a92fc --image adt/ubuntu-questing-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 122s autopkgtest [00:35:07]: testbed dpkg architecture: arm64 122s autopkgtest [00:35:07]: testbed apt version: 3.0.0 123s autopkgtest [00:35:08]: @@@@@@@@@@@@@@@@@@@@ test bed setup 123s autopkgtest [00:35:08]: testbed release detected to be: None 124s autopkgtest [00:35:09]: updating testbed package index (apt update) 124s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 124s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 124s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 124s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 124s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [179 kB] 125s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 125s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2255 kB] 125s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [196 kB] 125s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [567 kB] 125s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [3024 B] 125s Fetched 3367 kB in 1s (2334 kB/s) 126s Reading package lists... 127s autopkgtest [00:35:12]: upgrading testbed (apt dist-upgrade and autopurge) 127s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 129s Entering ResolveByKeep 129s 129s Calculating upgrade... 130s The following packages will be upgraded: 130s dpkg dpkg-dev libdpkg-perl make 130s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 130s Need to get 2852 kB of archives. 130s After this operation, 1024 B of additional disk space will be used. 130s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 dpkg arm64 1.22.18ubuntu3 [1288 kB] 131s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 dpkg-dev all 1.22.18ubuntu3 [1089 kB] 131s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libdpkg-perl all 1.22.18ubuntu3 [281 kB] 131s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 make arm64 4.4.1-2 [194 kB] 132s Fetched 2852 kB in 1s (2152 kB/s) 132s (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 ... 117820 files and directories currently installed.) 132s Preparing to unpack .../dpkg_1.22.18ubuntu3_arm64.deb ... 132s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 132s Setting up dpkg (1.22.18ubuntu3) ... 133s (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 ... 117820 files and directories currently installed.) 133s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 133s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 133s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 133s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 133s Preparing to unpack .../make_4.4.1-2_arm64.deb ... 133s Unpacking make (4.4.1-2) over (4.4.1-1) ... 133s Setting up make (4.4.1-2) ... 133s Setting up libdpkg-perl (1.22.18ubuntu3) ... 133s Setting up dpkg-dev (1.22.18ubuntu3) ... 133s Processing triggers for man-db (2.13.0-1) ... 135s Reading package lists... 136s Building dependency tree... 136s Reading state information... 136s Starting pkgProblemResolver with broken count: 0 136s Starting 2 pkgProblemResolver with broken count: 0 136s Done 137s Solving dependencies... 137s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 137s autopkgtest [00:35:22]: rebooting testbed after setup commands that affected boot 162s autopkgtest [00:35:47]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 164s autopkgtest [00:35:49]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-fact-loader 167s Get:1 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (dsc) [2295 B] 167s Get:2 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (tar) [277 kB] 167s Get:3 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (diff) [3756 B] 167s gpgv: Signature made Tue Sep 17 16:27:43 2024 UTC 167s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 167s gpgv: Can't check signature: No public key 167s dpkg-source: warning: cannot verify inline signature for ./pg-fact-loader_2.0.1-4.dsc: no acceptable signature found 167s autopkgtest [00:35:52]: testing package pg-fact-loader version 2.0.1-4 168s autopkgtest [00:35:53]: build not needed 168s autopkgtest [00:35:53]: test installcheck: preparing testbed 169s Reading package lists... 169s Building dependency tree... 169s Reading state information... 169s Starting pkgProblemResolver with broken count: 0 169s Starting 2 pkgProblemResolver with broken count: 0 169s Done 170s The following NEW packages will be installed: 170s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 170s postgresql-17 postgresql-17-pg-fact-loader postgresql-17-pglogical 170s postgresql-17-pglogical-ticker postgresql-client-17 postgresql-client-common 170s postgresql-common postgresql-common-dev ssl-cert 170s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 170s Need to get 47.3 MB of archives. 170s After this operation, 200 MB of additional disk space will be used. 170s Get:1 http://ftpmaster.internal/ubuntu questing/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 170s Get:2 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-common all 274 [47.6 kB] 170s Get:3 http://ftpmaster.internal/ubuntu questing/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 170s Get:4 http://ftpmaster.internal/ubuntu questing/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 170s Get:5 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common-dev all 274 [73.0 kB] 171s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 171s Get:7 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-common all 274 [101 kB] 171s Get:8 http://ftpmaster.internal/ubuntu questing/main arm64 libllvm20 arm64 1:20.1.2-0ubuntu1 [29.1 MB] 174s Get:9 http://ftpmaster.internal/ubuntu questing/main arm64 libpq5 arm64 17.4-1 [142 kB] 174s Get:10 http://ftpmaster.internal/ubuntu questing/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu4 [168 kB] 174s Get:11 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 174s Get:12 http://ftpmaster.internal/ubuntu questing/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 174s Get:13 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-17-pg-fact-loader arm64 2.0.1-4 [42.2 kB] 174s Get:14 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-17-pglogical arm64 2.4.5-1 [370 kB] 174s Get:15 http://ftpmaster.internal/ubuntu questing/universe arm64 postgresql-17-pglogical-ticker arm64 1.4.1-8 [21.5 kB] 175s Preconfiguring packages ... 175s Fetched 47.3 MB in 4s (10.8 MB/s) 175s Selecting previously unselected package libjson-perl. 175s (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 ... 117820 files and directories currently installed.) 175s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 175s Unpacking libjson-perl (4.10000-1) ... 175s Selecting previously unselected package postgresql-client-common. 175s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 175s Unpacking postgresql-client-common (274) ... 175s Selecting previously unselected package libio-pty-perl. 175s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 175s Unpacking libio-pty-perl (1:1.20-1build3) ... 175s Selecting previously unselected package libipc-run-perl. 175s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 175s Unpacking libipc-run-perl (20231003.0-2) ... 176s Selecting previously unselected package postgresql-common-dev. 176s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 176s Unpacking postgresql-common-dev (274) ... 176s Selecting previously unselected package ssl-cert. 176s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 176s Unpacking ssl-cert (1.1.3ubuntu1) ... 176s Selecting previously unselected package postgresql-common. 176s Preparing to unpack .../06-postgresql-common_274_all.deb ... 176s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 176s Unpacking postgresql-common (274) ... 176s Selecting previously unselected package libllvm20:arm64. 176s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_arm64.deb ... 176s Unpacking libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 177s Selecting previously unselected package libpq5:arm64. 177s Preparing to unpack .../08-libpq5_17.4-1_arm64.deb ... 177s Unpacking libpq5:arm64 (17.4-1) ... 177s Selecting previously unselected package libxslt1.1:arm64. 177s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_arm64.deb ... 177s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 177s Selecting previously unselected package postgresql-client-17. 177s Preparing to unpack .../10-postgresql-client-17_17.4-1_arm64.deb ... 177s Unpacking postgresql-client-17 (17.4-1) ... 177s Selecting previously unselected package postgresql-17. 177s Preparing to unpack .../11-postgresql-17_17.4-1_arm64.deb ... 177s Unpacking postgresql-17 (17.4-1) ... 177s Selecting previously unselected package postgresql-17-pg-fact-loader. 177s Preparing to unpack .../12-postgresql-17-pg-fact-loader_2.0.1-4_arm64.deb ... 177s Unpacking postgresql-17-pg-fact-loader (2.0.1-4) ... 177s Selecting previously unselected package postgresql-17-pglogical. 177s Preparing to unpack .../13-postgresql-17-pglogical_2.4.5-1_arm64.deb ... 177s Unpacking postgresql-17-pglogical (2.4.5-1) ... 177s Selecting previously unselected package postgresql-17-pglogical-ticker. 177s Preparing to unpack .../14-postgresql-17-pglogical-ticker_1.4.1-8_arm64.deb ... 177s Unpacking postgresql-17-pglogical-ticker (1.4.1-8) ... 177s Setting up postgresql-client-common (274) ... 177s Setting up libio-pty-perl (1:1.20-1build3) ... 177s Setting up libpq5:arm64 (17.4-1) ... 177s Setting up ssl-cert (1.1.3ubuntu1) ... 178s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 178s Setting up libllvm20:arm64 (1:20.1.2-0ubuntu1) ... 178s Setting up libipc-run-perl (20231003.0-2) ... 178s Setting up libjson-perl (4.10000-1) ... 178s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu4) ... 178s Setting up postgresql-common-dev (274) ... 178s Setting up postgresql-client-17 (17.4-1) ... 179s 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 179s Setting up postgresql-common (274) ... 179s Creating config file /etc/postgresql-common/createcluster.conf with new version 180s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 180s Removing obsolete dictionary files: 180s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 181s Setting up postgresql-17 (17.4-1) ... 182s Creating new PostgreSQL cluster 17/main ... 182s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 182s The files belonging to this database system will be owned by user "postgres". 182s This user must also own the server process. 182s 182s The database cluster will be initialized with locale "C.UTF-8". 182s The default database encoding has accordingly been set to "UTF8". 182s The default text search configuration will be set to "english". 182s 182s Data page checksums are disabled. 182s 182s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 182s creating subdirectories ... ok 182s selecting dynamic shared memory implementation ... posix 182s selecting default "max_connections" ... 100 182s selecting default "shared_buffers" ... 128MB 182s selecting default time zone ... Etc/UTC 182s creating configuration files ... ok 182s running bootstrap script ... ok 182s performing post-bootstrap initialization ... ok 182s syncing data to disk ... ok 186s Setting up postgresql-17-pglogical (2.4.5-1) ... 186s Setting up postgresql-17-pg-fact-loader (2.0.1-4) ... 186s Setting up postgresql-17-pglogical-ticker (1.4.1-8) ... 186s Processing triggers for man-db (2.13.0-1) ... 187s Processing triggers for libc-bin (2.41-6ubuntu1) ... 189s autopkgtest [00:36:14]: test installcheck: [----------------------- 189s ### PostgreSQL 17 installcheck ### 189s Creating new PostgreSQL cluster 17/regress ... 192s 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 192s # +++ regress install-check in +++ 192s # using postmaster on localhost, port 5433 195s ok 1 - 01_create_ext 2659 ms 195s ok 2 - 02_schema 127 ms 195s ok 3 - 03_audit 59 ms 195s ok 4 - 04_seeds 93 ms 195s ok 5 - 05_pgl_setup 45 ms 211s ok 6 - 06_basic_workers 15774 ms 212s ok 7 - 07_launch_worker 1644 ms 217s ok 8 - 08_fact_table_deps 4716 ms 217s ok 9 - 09_purge 293 ms 240s ok 10 - 10_delete 22875 ms 251s ok 11 - 11_more_data 11111 ms 271s ok 12 - 12_no_proid 19680 ms 316s ok 13 - 13_cutoff_no_dep_on_filter 45162 ms 317s ok 14 - 14_null_key 350 ms 317s ok 15 - 15_source_change_date 142 ms 322s ok 16 - 16_1_2_features 5323 ms 322s ok 17 - 17_1_3_features 310 ms 322s 1..17 322s # All 17 tests passed. 322s Dropping cluster 17/regress ... 323s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 323s ### End 17 installcheck ### 323s autopkgtest [00:38:28]: test installcheck: -----------------------] 323s autopkgtest [00:38:28]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 323s installcheck PASS 324s autopkgtest [00:38:29]: @@@@@@@@@@@@@@@@@@@@ summary 324s installcheck PASS 381s nova [W] Using flock in prodstack6-arm64 381s Creating nova instance adt-questing-arm64-pg-fact-loader-20250502-003304-juju-7f2275-prod-proposed-migration-environment-15-533abd5c-d0d7-4cb8-86bd-c61e217a92fc from image adt/ubuntu-questing-arm64-server-20250501.img (UUID a16a0402-3b0c-4b8f-ba85-1dd4107760ca)... 381s nova [W] Timed out waiting for aa6e04f7-046f-49d2-b441-9ea6c4d0a287 to get deleted.