0s autopkgtest [12:26:48]: starting date and time: 2025-05-03 12:26:48+0000 0s autopkgtest [12:26:48]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [12:26:48]: host juju-7f2275-prod-proposed-migration-environment-23; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.xfewz2op/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 builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-23@bos03-7.secgroup --name adt-questing-amd64-pg-fact-loader-20250503-122648-juju-7f2275-prod-proposed-migration-environment-23-8690cdd2-b3a6-4f9d-a3c5-0babbe334dea --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-23 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 68s autopkgtest [12:27:56]: testbed dpkg architecture: amd64 68s autopkgtest [12:27:56]: testbed apt version: 3.0.0 68s autopkgtest [12:27:56]: @@@@@@@@@@@@@@@@@@@@ test bed setup 68s autopkgtest [12:27:56]: testbed release detected to be: None 69s autopkgtest [12:27:57]: updating testbed package index (apt update) 69s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 70s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 70s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 70s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 70s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [155 kB] 70s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.6 kB] 70s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1655 kB] 70s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [146 kB] 70s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [198 kB] 70s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [1372 kB] 70s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [562 kB] 70s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [13.2 kB] 70s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [15.0 kB] 70s Fetched 4272 kB in 1s (3944 kB/s) 71s Reading package lists... 72s autopkgtest [12:28:00]: upgrading testbed (apt dist-upgrade and autopurge) 72s Reading package lists... 72s Building dependency tree... 72s Reading state information... 73s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 73s Starting 2 pkgProblemResolver with broken count: 0 73s Done 74s Entering ResolveByKeep 74s 74s Calculating upgrade... 74s The following packages will be upgraded: 74s debianutils libnftnl11 make python3-lazr.restfulclient 74s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 74s Need to get 410 kB of archives. 74s After this operation, 56.3 kB disk space will be freed. 74s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 debianutils amd64 5.22 [93.0 kB] 75s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 libnftnl11 amd64 1.2.9-1 [69.1 kB] 75s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 make amd64 4.4.1-2 [197 kB] 75s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 75s Fetched 410 kB in 0s (992 kB/s) 75s (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 ... 80514 files and directories currently installed.) 75s Preparing to unpack .../debianutils_5.22_amd64.deb ... 75s Unpacking debianutils (5.22) over (5.21) ... 75s Setting up debianutils (5.22) ... 75s (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 ... 80514 files and directories currently installed.) 75s Preparing to unpack .../libnftnl11_1.2.9-1_amd64.deb ... 75s Unpacking libnftnl11:amd64 (1.2.9-1) over (1.2.8-1) ... 75s Preparing to unpack .../make_4.4.1-2_amd64.deb ... 75s Unpacking make (4.4.1-2) over (4.4.1-1) ... 75s Preparing to unpack .../python3-lazr.restfulclient_0.14.6-3_all.deb ... 76s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 76s Setting up libnftnl11:amd64 (1.2.9-1) ... 76s Setting up make (4.4.1-2) ... 76s Setting up python3-lazr.restfulclient (0.14.6-3) ... 76s Processing triggers for man-db (2.13.0-1) ... 77s Processing triggers for libc-bin (2.41-6ubuntu1) ... 77s Reading package lists... 78s Building dependency tree... 78s Reading state information... 78s Starting pkgProblemResolver with broken count: 0 78s Starting 2 pkgProblemResolver with broken count: 0 78s Done 78s Solving dependencies... 78s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 81s autopkgtest [12:28:09]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 81s autopkgtest [12:28:09]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-fact-loader 83s Get:1 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (dsc) [2295 B] 83s Get:2 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (tar) [277 kB] 83s Get:3 http://ftpmaster.internal/ubuntu questing/universe pg-fact-loader 2.0.1-4 (diff) [3756 B] 83s gpgv: Signature made Tue Sep 17 16:27:43 2024 UTC 83s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 83s gpgv: Can't check signature: No public key 83s dpkg-source: warning: cannot verify inline signature for ./pg-fact-loader_2.0.1-4.dsc: no acceptable signature found 83s autopkgtest [12:28:11]: testing package pg-fact-loader version 2.0.1-4 83s autopkgtest [12:28:11]: build not needed 84s autopkgtest [12:28:12]: test installcheck: preparing testbed 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 85s Starting pkgProblemResolver with broken count: 0 85s Starting 2 pkgProblemResolver with broken count: 0 85s Done 85s The following NEW packages will be installed: 85s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 85s postgresql-17 postgresql-17-pg-fact-loader postgresql-17-pglogical 85s postgresql-17-pglogical-ticker postgresql-client-17 postgresql-client-common 85s postgresql-common postgresql-common-dev ssl-cert 85s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 85s Need to get 49.7 MB of archives. 85s After this operation, 202 MB of additional disk space will be used. 85s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 85s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-common all 274 [47.6 kB] 85s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 85s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 85s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common-dev all 274 [73.0 kB] 85s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 85s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common all 274 [101 kB] 85s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 86s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.4-1 [155 kB] 86s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 86s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 86s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 87s Get:13 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-17-pg-fact-loader amd64 2.0.1-4 [42.2 kB] 87s Get:14 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-17-pglogical amd64 2.4.5-1 [379 kB] 87s Get:15 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-17-pglogical-ticker amd64 1.4.1-8 [21.5 kB] 87s Preconfiguring packages ... 87s Fetched 49.7 MB in 2s (27.4 MB/s) 87s Selecting previously unselected package libjson-perl. 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 ... 80514 files and directories currently installed.) 87s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 87s Unpacking libjson-perl (4.10000-1) ... 87s Selecting previously unselected package postgresql-client-common. 87s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 87s Unpacking postgresql-client-common (274) ... 87s Selecting previously unselected package libio-pty-perl. 87s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 87s Unpacking libio-pty-perl (1:1.20-1build3) ... 87s Selecting previously unselected package libipc-run-perl. 87s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 87s Unpacking libipc-run-perl (20231003.0-2) ... 87s Selecting previously unselected package postgresql-common-dev. 87s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 87s Unpacking postgresql-common-dev (274) ... 87s Selecting previously unselected package ssl-cert. 87s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 87s Unpacking ssl-cert (1.1.3ubuntu1) ... 87s Selecting previously unselected package postgresql-common. 87s Preparing to unpack .../06-postgresql-common_274_all.deb ... 87s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 87s Unpacking postgresql-common (274) ... 87s Selecting previously unselected package libllvm20:amd64. 87s Preparing to unpack .../07-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 87s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 88s Selecting previously unselected package libpq5:amd64. 88s Preparing to unpack .../08-libpq5_17.4-1_amd64.deb ... 88s Unpacking libpq5:amd64 (17.4-1) ... 88s Selecting previously unselected package libxslt1.1:amd64. 88s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 88s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 88s Selecting previously unselected package postgresql-client-17. 88s Preparing to unpack .../10-postgresql-client-17_17.4-1_amd64.deb ... 88s Unpacking postgresql-client-17 (17.4-1) ... 88s Selecting previously unselected package postgresql-17. 88s Preparing to unpack .../11-postgresql-17_17.4-1_amd64.deb ... 88s Unpacking postgresql-17 (17.4-1) ... 88s Selecting previously unselected package postgresql-17-pg-fact-loader. 88s Preparing to unpack .../12-postgresql-17-pg-fact-loader_2.0.1-4_amd64.deb ... 88s Unpacking postgresql-17-pg-fact-loader (2.0.1-4) ... 88s Selecting previously unselected package postgresql-17-pglogical. 88s Preparing to unpack .../13-postgresql-17-pglogical_2.4.5-1_amd64.deb ... 88s Unpacking postgresql-17-pglogical (2.4.5-1) ... 89s Selecting previously unselected package postgresql-17-pglogical-ticker. 89s Preparing to unpack .../14-postgresql-17-pglogical-ticker_1.4.1-8_amd64.deb ... 89s Unpacking postgresql-17-pglogical-ticker (1.4.1-8) ... 89s Setting up postgresql-client-common (274) ... 89s Setting up libio-pty-perl (1:1.20-1build3) ... 89s Setting up libpq5:amd64 (17.4-1) ... 89s Setting up ssl-cert (1.1.3ubuntu1) ... 89s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 89s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 89s Setting up libipc-run-perl (20231003.0-2) ... 89s Setting up libjson-perl (4.10000-1) ... 89s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 89s Setting up postgresql-common-dev (274) ... 89s Setting up postgresql-client-17 (17.4-1) ... 90s 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 90s Setting up postgresql-common (274) ... 90s Creating config file /etc/postgresql-common/createcluster.conf with new version 90s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 90s Removing obsolete dictionary files: 91s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 91s Setting up postgresql-17 (17.4-1) ... 92s Creating new PostgreSQL cluster 17/main ... 92s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 92s The files belonging to this database system will be owned by user "postgres". 92s This user must also own the server process. 92s 92s The database cluster will be initialized with locale "C.UTF-8". 92s The default database encoding has accordingly been set to "UTF8". 92s The default text search configuration will be set to "english". 92s 92s Data page checksums are disabled. 92s 92s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 92s creating subdirectories ... ok 92s selecting dynamic shared memory implementation ... posix 92s selecting default "max_connections" ... 100 92s selecting default "shared_buffers" ... 128MB 92s selecting default time zone ... Etc/UTC 92s creating configuration files ... ok 92s running bootstrap script ... ok 93s performing post-bootstrap initialization ... ok 93s syncing data to disk ... ok 96s Setting up postgresql-17-pglogical (2.4.5-1) ... 96s Setting up postgresql-17-pg-fact-loader (2.0.1-4) ... 96s Setting up postgresql-17-pglogical-ticker (1.4.1-8) ... 96s Processing triggers for man-db (2.13.0-1) ... 96s Processing triggers for libc-bin (2.41-6ubuntu1) ... 97s autopkgtest [12:28:25]: test installcheck: [----------------------- 98s ### PostgreSQL 17 installcheck ### 98s Creating new PostgreSQL cluster 17/regress ... 100s 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 100s # +++ regress install-check in +++ 100s # using postmaster on localhost, port 5433 101s ok 1 - 01_create_ext 184 ms 101s ok 2 - 02_schema 101 ms 101s ok 3 - 03_audit 45 ms 101s ok 4 - 04_seeds 99 ms 101s ok 5 - 05_pgl_setup 35 ms 108s ok 6 - 06_basic_workers 7274 ms 109s ok 7 - 07_launch_worker 807 ms 111s ok 8 - 08_fact_table_deps 2198 ms 111s ok 9 - 09_purge 173 ms 123s ok 10 - 10_delete 11682 ms 128s ok 11 - 11_more_data 5220 ms 137s ok 12 - 12_no_proid 8949 ms 193s ok 13 - 13_cutoff_no_dep_on_filter 55904 ms 224s ok 14 - 14_null_key 30900 ms 224s ok 15 - 15_source_change_date 117 ms 230s ok 16 - 16_1_2_features 5403 ms 230s ok 17 - 17_1_3_features 247 ms 230s 1..17 230s # All 17 tests passed. 230s Dropping cluster 17/regress ... 230s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 230s ### End 17 installcheck ### 231s autopkgtest [12:30:39]: test installcheck: -----------------------] 231s installcheck PASS 231s autopkgtest [12:30:39]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 231s autopkgtest [12:30:39]: @@@@@@@@@@@@@@@@@@@@ summary 231s installcheck PASS 248s nova [W] Skipping flock for amd64 248s Creating nova instance adt-questing-amd64-pg-fact-loader-20250503-122648-juju-7f2275-prod-proposed-migration-environment-23-8690cdd2-b3a6-4f9d-a3c5-0babbe334dea from image adt/ubuntu-questing-amd64-server-20250503.img (UUID 57b7c1b6-ad80-4bdb-b031-36f045f7f3b3)... 248s nova [W] Timed out waiting for 37fae640-f244-4433-83ef-bae0c305f815 to get deleted.