0s autopkgtest [06:47:29]: starting date and time: 2025-02-22 06:47:29+0000 0s autopkgtest [06:47:29]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:47:29]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.u9lbcox0/out --timeout-copy=6000 -a i386 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade londiste-sql --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 builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-20.secgroup --name adt-plucky-i386-londiste-sql-20250222-064729-juju-7f2275-prod-proposed-migration-environment-15-0dde65df-0d43-4e9c-89a2-4752c4c162d4 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -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/ 110s autopkgtest [06:49:19]: testbed dpkg architecture: amd64 111s autopkgtest [06:49:20]: testbed apt version: 2.9.30ubuntu1 111s autopkgtest [06:49:20]: @@@@@@@@@@@@@@@@@@@@ test bed setup 111s autopkgtest [06:49:20]: testbed release detected to be: None 112s autopkgtest [06:49:21]: updating testbed package index (apt update) 112s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 113s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 113s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 113s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 113s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 113s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 113s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 113s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 113s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [98.8 kB] 113s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [129 kB] 113s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [7984 B] 113s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2412 B] 113s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [223 kB] 113s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [453 kB] 113s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [8844 B] 113s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [20.9 kB] 113s Fetched 1656 kB in 1s (1791 kB/s) 114s Reading package lists... 115s + lsb_release --codename --short 115s + RELEASE=plucky 115s + cat 115s + [ plucky != trusty ] 115s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 115s Reading package lists... 115s Building dependency tree... 115s Reading state information... 115s Calculating upgrade... 115s Calculating upgrade... 115s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 115s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 115s + /usr/lib/apt/apt-helper analyze-pattern ?true 115s + uname -r 115s + sed s/\./\\./g 115s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 115s + apt list ?obsolete 115s + tail -n+2 115s + cut -d/ -f1 115s + grep -v ^linux-.*6\.12\.0-15-generic.* 116s + true 116s + obsolete_pkgs= 116s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 116s Reading package lists... 116s Building dependency tree... 116s Reading state information... 116s Solving dependencies... 116s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 116s + grep -q trusty /etc/lsb-release 116s + [ ! -d /usr/share/doc/unattended-upgrades ] 116s + [ ! -d /usr/share/doc/lxd ] 116s + [ ! -d /usr/share/doc/lxd-client ] 116s + [ ! -d /usr/share/doc/snapd ] 116s + type iptables 116s + cat 116s + chmod 755 /etc/rc.local 116s + . /etc/rc.local 116s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 116s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 116s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 116s + uname -m 116s + [ x86_64 = ppc64le ] 116s + [ -d /run/systemd/system ] 116s + systemd-detect-virt --quiet --vm 116s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 116s + cat 116s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 116s + echo COMPRESS=lz4 116s autopkgtest [06:49:25]: upgrading testbed (apt dist-upgrade and autopurge) 116s Reading package lists... 117s Building dependency tree... 117s Reading state information... 117s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 117s Starting 2 pkgProblemResolver with broken count: 0 117s Done 117s Entering ResolveByKeep 117s 118s Calculating upgrade... 118s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 118s Reading package lists... 118s Building dependency tree... 118s Reading state information... 118s Starting pkgProblemResolver with broken count: 0 118s Starting 2 pkgProblemResolver with broken count: 0 118s Done 119s Solving dependencies... 119s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 121s autopkgtest [06:49:30]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Tue Feb 4 16:02:16 UTC 2025 121s autopkgtest [06:49:30]: @@@@@@@@@@@@@@@@@@@@ apt-source londiste-sql 123s Get:1 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (dsc) [2119 B] 123s Get:2 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (tar) [46.2 kB] 123s Get:3 http://ftpmaster.internal/ubuntu plucky/universe londiste-sql 3.8-6 (diff) [2152 B] 123s gpgv: Signature made Thu Sep 19 11:35:28 2024 UTC 123s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 123s gpgv: Can't check signature: No public key 123s dpkg-source: warning: cannot verify inline signature for ./londiste-sql_3.8-6.dsc: no acceptable signature found 123s autopkgtest [06:49:32]: testing package londiste-sql version 3.8-6 123s autopkgtest [06:49:32]: build not needed 124s autopkgtest [06:49:33]: test installcheck: preparing testbed 124s Reading package lists... 124s Building dependency tree... 124s Reading state information... 124s Starting pkgProblemResolver with broken count: 0 124s Starting 2 pkgProblemResolver with broken count: 0 124s Done 125s The following NEW packages will be installed: 125s libevent-2.1-7t64 libio-pty-perl libipc-run-perl libjson-perl libllvm20 125s libpq5 libxslt1.1 pgqd postgresql-17 postgresql-17-londiste-sql 125s postgresql-17-pgq-node postgresql-17-pgq3 postgresql-client-17 125s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 125s 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. 125s Need to get 49.6 MB of archives. 125s After this operation, 204 MB of additional disk space will be used. 125s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 125s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 273 [47.5 kB] 125s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 125s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 125s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common-dev all 273 [72.9 kB] 125s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 125s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 273 [101 kB] 125s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 libevent-2.1-7t64 amd64 2.1.12-stable-10 [144 kB] 125s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq5 amd64 17.4-1 [155 kB] 125s Get:10 http://ftpmaster.internal/ubuntu plucky/universe amd64 pgqd amd64 3.5-2 [28.5 kB] 125s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 libllvm20 amd64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [30.5 MB] 126s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 126s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 126s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 126s Get:15 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-pgq3 amd64 3.5-4 [132 kB] 126s Get:16 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-pgq-node all 3.5-7 [12.9 kB] 126s Get:17 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-londiste-sql all 3.8-6 [20.8 kB] 127s Preconfiguring packages ... 127s Fetched 49.6 MB in 2s (27.6 MB/s) 127s Selecting previously unselected package libjson-perl. 127s (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 ... 108975 files and directories currently installed.) 127s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 127s Unpacking libjson-perl (4.10000-1) ... 127s Selecting previously unselected package postgresql-client-common. 127s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 127s Unpacking postgresql-client-common (273) ... 127s Selecting previously unselected package libio-pty-perl. 127s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 127s Unpacking libio-pty-perl (1:1.20-1build3) ... 127s Selecting previously unselected package libipc-run-perl. 127s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 127s Unpacking libipc-run-perl (20231003.0-2) ... 127s Selecting previously unselected package postgresql-common-dev. 127s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 127s Unpacking postgresql-common-dev (273) ... 127s Selecting previously unselected package ssl-cert. 127s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 127s Unpacking ssl-cert (1.1.3ubuntu1) ... 127s Selecting previously unselected package postgresql-common. 127s Preparing to unpack .../06-postgresql-common_273_all.deb ... 127s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 127s Unpacking postgresql-common (273) ... 127s Selecting previously unselected package libevent-2.1-7t64:amd64. 127s Preparing to unpack .../07-libevent-2.1-7t64_2.1.12-stable-10_amd64.deb ... 127s Unpacking libevent-2.1-7t64:amd64 (2.1.12-stable-10) ... 127s Selecting previously unselected package libpq5:amd64. 127s Preparing to unpack .../08-libpq5_17.4-1_amd64.deb ... 127s Unpacking libpq5:amd64 (17.4-1) ... 127s Selecting previously unselected package pgqd. 127s Preparing to unpack .../09-pgqd_3.5-2_amd64.deb ... 127s Unpacking pgqd (3.5-2) ... 127s Selecting previously unselected package libllvm20:amd64. 127s Preparing to unpack .../10-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_amd64.deb ... 127s Unpacking libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 128s Selecting previously unselected package libxslt1.1:amd64. 128s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 128s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 128s Selecting previously unselected package postgresql-client-17. 128s Preparing to unpack .../12-postgresql-client-17_17.4-1_amd64.deb ... 128s Unpacking postgresql-client-17 (17.4-1) ... 128s Selecting previously unselected package postgresql-17. 128s Preparing to unpack .../13-postgresql-17_17.4-1_amd64.deb ... 128s Unpacking postgresql-17 (17.4-1) ... 129s Selecting previously unselected package postgresql-17-pgq3. 129s Preparing to unpack .../14-postgresql-17-pgq3_3.5-4_amd64.deb ... 129s Unpacking postgresql-17-pgq3 (3.5-4) ... 129s Selecting previously unselected package postgresql-17-pgq-node. 129s Preparing to unpack .../15-postgresql-17-pgq-node_3.5-7_all.deb ... 129s Unpacking postgresql-17-pgq-node (3.5-7) ... 129s Selecting previously unselected package postgresql-17-londiste-sql. 129s Preparing to unpack .../16-postgresql-17-londiste-sql_3.8-6_all.deb ... 129s Unpacking postgresql-17-londiste-sql (3.8-6) ... 129s Setting up postgresql-client-common (273) ... 129s Setting up libio-pty-perl (1:1.20-1build3) ... 129s Setting up libpq5:amd64 (17.4-1) ... 129s Setting up libevent-2.1-7t64:amd64 (2.1.12-stable-10) ... 129s Setting up ssl-cert (1.1.3ubuntu1) ... 129s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 129s Setting up libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 129s Setting up libipc-run-perl (20231003.0-2) ... 129s Setting up libjson-perl (4.10000-1) ... 129s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 129s Setting up postgresql-common-dev (273) ... 129s Setting up postgresql-client-17 (17.4-1) ... 130s 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 130s Setting up postgresql-common (273) ... 130s Creating config file /etc/postgresql-common/createcluster.conf with new version 130s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 130s Removing obsolete dictionary files: 131s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 131s Setting up pgqd (3.5-2) ... 132s Created symlink '/etc/systemd/system/multi-user.target.wants/pgqd.service' → '/usr/lib/systemd/system/pgqd.service'. 132s Setting up postgresql-17 (17.4-1) ... 132s Creating new PostgreSQL cluster 17/main ... 132s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 132s The files belonging to this database system will be owned by user "postgres". 132s This user must also own the server process. 132s 132s The database cluster will be initialized with locale "C.UTF-8". 133s The default database encoding has accordingly been set to "UTF8". 133s The default text search configuration will be set to "english". 133s 133s Data page checksums are disabled. 133s 133s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 133s creating subdirectories ... ok 133s selecting dynamic shared memory implementation ... posix 133s selecting default "max_connections" ... 100 133s selecting default "shared_buffers" ... 128MB 133s selecting default time zone ... Etc/UTC 133s creating configuration files ... ok 133s running bootstrap script ... ok 133s performing post-bootstrap initialization ... ok 133s syncing data to disk ... ok 136s Setting up postgresql-17-pgq3 (3.5-4) ... 136s Setting up postgresql-17-pgq-node (3.5-7) ... 136s Setting up postgresql-17-londiste-sql (3.8-6) ... 136s Processing triggers for man-db (2.13.0-1) ... 137s Processing triggers for libc-bin (2.40-4ubuntu1) ... 138s autopkgtest [06:49:47]: testbed environment configured for cross-architecture building 138s autopkgtest [06:49:47]: test installcheck: [----------------------- 139s ### PostgreSQL 17 installcheck ### 139s Creating new PostgreSQL cluster 17/regress ... 142s 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=regression --dbname=regression init_ext londiste_provider londiste_subscriber londiste_fkeys londiste_execute londiste_seqs londiste_merge londiste_leaf londiste_create_part londiste_merge_fkeys 142s # +++ regress install-check in +++ 142s # using postmaster on localhost, port 5433 142s ok 1 - init_ext 84 ms 142s ok 2 - londiste_provider 92 ms 142s ok 3 - londiste_subscriber 60 ms 142s ok 4 - londiste_fkeys 46 ms 142s ok 5 - londiste_execute 18 ms 142s ok 6 - londiste_seqs 61 ms 143s ok 7 - londiste_merge 258 ms 143s ok 8 - londiste_leaf 34 ms 143s ok 9 - londiste_create_part 34 ms 143s ok 10 - londiste_merge_fkeys 57 ms 143s 1..10 143s # All 10 tests passed. 143s Dropping cluster 17/regress ... 143s rm -rf docs/html docs/Data docs/sql 143s rm -f londiste--3.8.sql londiste--unpackaged--3.8.sql londiste--3.2--3.8.sql londiste--3.2.3--3.8.sql londiste--3.2.4--3.8.sql londiste--3.4--3.8.sql londiste--3.4.1--3.8.sql londiste--3.5--3.8.sql londiste--3.6--3.8.sql londiste--3.7--3.8.sql 143s rm -rf londiste.sql londiste.upgrade.sql structure/newgrants_londiste.sql structure/oldgrants_londiste.sql test.dump 143s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 143s ### End 17 installcheck ### 143s autopkgtest [06:49:52]: test installcheck: -----------------------] 144s autopkgtest [06:49:53]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 144s installcheck PASS 144s autopkgtest [06:49:53]: @@@@@@@@@@@@@@@@@@@@ summary 144s installcheck PASS 286s nova [W] Skipping flock for amd64 286s Creating nova instance adt-plucky-i386-londiste-sql-20250222-064729-juju-7f2275-prod-proposed-migration-environment-15-0dde65df-0d43-4e9c-89a2-4752c4c162d4 from image adt/ubuntu-plucky-amd64-server-20250222.img (UUID 16f5f362-6b73-4ce4-aa83-c13d69c08def)... 286s nova [W] Timed out waiting for b59ec685-5029-430f-9d02-15db0b389799 to get deleted.