0s autopkgtest [16:54:27]: starting date: 2024-03-11 0s autopkgtest [16:54:27]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [16:54:27]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work._d4n0yti/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:postgresql-16,src:db5.3,src:gdbm,src:llvm-toolchain-17,src:mmdebstrap,src:openssl,src:perl,src:python3.12,src:readline --apt-upgrade pgcopydb --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=postgresql-16/16.2-1ubuntu2 db5.3/5.3.28+dfsg2-5 gdbm/1.23-5.1 llvm-toolchain-17/1:17.0.6-8ubuntu1.1 mmdebstrap/1.4.3-6 openssl/3.0.13-0ubuntu1 perl/5.38.2-3.2 python3.12/3.12.2-4build2 readline/8.2-3.1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-11.secgroup --name adt-noble-arm64-pgcopydb-20240311-165427-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -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,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 70s autopkgtest [16:55:37]: @@@@@@@@@@@@@@@@@@@@ test bed setup 70s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 71s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [38.0 kB] 71s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [452 kB] 71s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 71s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2667 kB] 71s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [593 kB] 71s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 71s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [20.3 kB] 71s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 71s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [2971 kB] 72s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 72s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [39.6 kB] 72s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 73s Fetched 6914 kB in 2s (4149 kB/s) 73s Reading package lists... 77s Reading package lists... 77s Building dependency tree... 77s Reading state information... 78s Calculating upgrade... 78s The following packages will be REMOVED: 78s libdb5.3 libgdbm-compat4 libgdbm6 libperl5.38 libreadline8 libssl3 78s The following NEW packages will be installed: 78s libdb5.3t64 libgdbm-compat4t64 libgdbm6t64 libperl5.38t64 libreadline8t64 78s libssl3t64 78s The following packages will be upgraded: 78s klibc-utils libklibc libpython3.12-minimal libpython3.12-stdlib openssl perl 78s perl-base perl-modules-5.38 python3.12 python3.12-minimal readline-common 79s 11 upgraded, 6 newly installed, 6 to remove and 0 not upgraded. 79s Need to get 19.4 MB of archives. 79s After this operation, 275 kB of additional disk space will be used. 79s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 openssl arm64 3.0.13-0ubuntu1 [983 kB] 79s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libssl3t64 arm64 3.0.13-0ubuntu1 [1770 kB] 79s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 python3.12 arm64 3.12.2-4build2 [645 kB] 79s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 python3.12-minimal arm64 3.12.2-4build2 [2189 kB] 79s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpython3.12-minimal arm64 3.12.2-4build2 [829 kB] 79s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libreadline8t64 arm64 8.2-3.1 [153 kB] 79s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpython3.12-stdlib arm64 3.12.2-4build2 [2002 kB] 79s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libdb5.3t64 arm64 5.3.28+dfsg2-5 [719 kB] 79s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm6t64 arm64 1.23-5.1 [34.3 kB] 79s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm-compat4t64 arm64 1.23-5.1 [6576 B] 79s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libperl5.38t64 arm64 5.38.2-3.2 [4771 kB] 80s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl arm64 5.38.2-3.2 [231 kB] 80s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-base arm64 5.38.2-3.2 [1777 kB] 80s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-modules-5.38 all 5.38.2-3.2 [3110 kB] 80s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 readline-common all 8.2-3.1 [56.4 kB] 80s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 klibc-utils arm64 2.0.13-4 [114 kB] 80s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libklibc arm64 2.0.13-4 [51.4 kB] 81s Fetched 19.4 MB in 1s (14.3 MB/s) 81s (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 ... 74748 files and directories currently installed.) 81s Preparing to unpack .../openssl_3.0.13-0ubuntu1_arm64.deb ... 81s Unpacking openssl (3.0.13-0ubuntu1) over (3.0.10-1ubuntu4) ... 81s dpkg: libssl3:arm64: dependency problems, but removing anyway as you requested: 81s wget depends on libssl3 (>= 3.0.0). 81s u-boot-tools depends on libssl3 (>= 3.0.0). 81s tnftp depends on libssl3 (>= 3.0.0). 81s tcpdump depends on libssl3 (>= 3.0.0). 81s systemd-resolved depends on libssl3 (>= 3.0.0). 81s systemd depends on libssl3 (>= 3.0.0). 81s sudo depends on libssl3 (>= 3.0.0). 81s sbsigntool depends on libssl3 (>= 3.0.0). 81s rsync depends on libssl3 (>= 3.0.0). 81s python3-cryptography depends on libssl3 (>= 3.0.0). 81s openssh-server depends on libssl3 (>= 3.0.10). 81s openssh-client depends on libssl3 (>= 3.0.10). 81s mtd-utils depends on libssl3 (>= 3.0.0). 81s mokutil depends on libssl3 (>= 3.0.0). 81s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 81s libsystemd-shared:arm64 depends on libssl3 (>= 3.0.0). 81s libssh-4:arm64 depends on libssl3 (>= 3.0.0). 81s libsasl2-modules:arm64 depends on libssl3 (>= 3.0.0). 81s libsasl2-2:arm64 depends on libssl3 (>= 3.0.0). 81s libpython3.12-minimal:arm64 depends on libssl3 (>= 3.0.0). 81s libnvme1 depends on libssl3 (>= 3.0.0). 81s libkrb5-3:arm64 depends on libssl3 (>= 3.0.0). 81s libkmod2:arm64 depends on libssl3 (>= 3.0.0). 81s libfido2-1:arm64 depends on libssl3 (>= 3.0.0). 81s libcurl4:arm64 depends on libssl3 (>= 3.0.0). 81s libcryptsetup12:arm64 depends on libssl3 (>= 3.0.0). 81s kmod depends on libssl3 (>= 3.0.0). 81s dhcpcd-base depends on libssl3 (>= 3.0.0). 81s bind9-libs:arm64 depends on libssl3 (>= 3.0.0). 81s 81s (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 ... 74748 files and directories currently installed.) 81s Removing libssl3:arm64 (3.0.10-1ubuntu4) ... 81s Selecting previously unselected package libssl3t64:arm64. 82s (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 ... 74737 files and directories currently installed.) 82s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu1_arm64.deb ... 82s Unpacking libssl3t64:arm64 (3.0.13-0ubuntu1) ... 82s Preparing to unpack .../python3.12_3.12.2-4build2_arm64.deb ... 82s Unpacking python3.12 (3.12.2-4build2) over (3.12.2-1) ... 83s Preparing to unpack .../python3.12-minimal_3.12.2-4build2_arm64.deb ... 83s Unpacking python3.12-minimal (3.12.2-4build2) over (3.12.2-1) ... 84s Preparing to unpack .../libpython3.12-minimal_3.12.2-4build2_arm64.deb ... 85s Unpacking libpython3.12-minimal:arm64 (3.12.2-4build2) over (3.12.2-1) ... 85s dpkg: libreadline8:arm64: dependency problems, but removing anyway as you requested: 85s parted depends on libreadline8 (>= 6.0). 85s libpython3.12-stdlib:arm64 depends on libreadline8 (>= 7.0~beta). 85s gpgsm depends on libreadline8 (>= 6.0). 85s gpgconf depends on libreadline8 (>= 6.0). 85s gpg depends on libreadline8 (>= 6.0). 85s gawk depends on libreadline8 (>= 6.0). 85s fdisk depends on libreadline8 (>= 6.0). 85s 85s (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 ... 74750 files and directories currently installed.) 85s Removing libreadline8:arm64 (8.2-3) ... 85s Selecting previously unselected package libreadline8t64:arm64. 85s (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 ... 74738 files and directories currently installed.) 85s Preparing to unpack .../libreadline8t64_8.2-3.1_arm64.deb ... 85s Adding 'diversion of /lib/aarch64-linux-gnu/libhistory.so.8 to /lib/aarch64-linux-gnu/libhistory.so.8.usr-is-merged by libreadline8t64' 85s Adding 'diversion of /lib/aarch64-linux-gnu/libhistory.so.8.2 to /lib/aarch64-linux-gnu/libhistory.so.8.2.usr-is-merged by libreadline8t64' 85s Adding 'diversion of /lib/aarch64-linux-gnu/libreadline.so.8 to /lib/aarch64-linux-gnu/libreadline.so.8.usr-is-merged by libreadline8t64' 85s Adding 'diversion of /lib/aarch64-linux-gnu/libreadline.so.8.2 to /lib/aarch64-linux-gnu/libreadline.so.8.2.usr-is-merged by libreadline8t64' 85s Unpacking libreadline8t64:arm64 (8.2-3.1) ... 86s Preparing to unpack .../libpython3.12-stdlib_3.12.2-4build2_arm64.deb ... 86s Unpacking libpython3.12-stdlib:arm64 (3.12.2-4build2) over (3.12.2-1) ... 86s dpkg: libperl5.38:arm64: dependency problems, but removing anyway as you requested: 86s perl depends on libperl5.38 (= 5.38.2-3). 86s 86s (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 ... 74756 files and directories currently installed.) 86s Removing libperl5.38:arm64 (5.38.2-3) ... 86s dpkg: libdb5.3:arm64: dependency problems, but removing anyway as you requested: 86s libsasl2-modules-db:arm64 depends on libdb5.3. 86s libpam-modules:arm64 depends on libdb5.3. 86s iproute2 depends on libdb5.3. 86s apt-utils depends on libdb5.3. 86s 86s Removing libdb5.3:arm64 (5.3.28+dfsg2-4) ... 86s Selecting previously unselected package libdb5.3t64:arm64. 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 ... 74221 files and directories currently installed.) 87s Preparing to unpack .../libdb5.3t64_5.3.28+dfsg2-5_arm64.deb ... 87s Unpacking libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 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 ... 74227 files and directories currently installed.) 87s Removing libgdbm-compat4:arm64 (1.23-5) ... 87s dpkg: libgdbm6:arm64: dependency problems, but removing anyway as you requested: 87s python3-gdbm:arm64 depends on libgdbm6 (>= 1.16). 87s man-db depends on libgdbm6 (>= 1.16). 87s 87s Removing libgdbm6:arm64 (1.23-5) ... 87s Selecting previously unselected package libgdbm6t64:arm64. 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 ... 74217 files and directories currently installed.) 87s Preparing to unpack .../libgdbm6t64_1.23-5.1_arm64.deb ... 87s Unpacking libgdbm6t64:arm64 (1.23-5.1) ... 87s Selecting previously unselected package libgdbm-compat4t64:arm64. 88s Preparing to unpack .../libgdbm-compat4t64_1.23-5.1_arm64.deb ... 88s Unpacking libgdbm-compat4t64:arm64 (1.23-5.1) ... 88s Selecting previously unselected package libperl5.38t64:arm64. 88s Preparing to unpack .../libperl5.38t64_5.38.2-3.2_arm64.deb ... 88s Unpacking libperl5.38t64:arm64 (5.38.2-3.2) ... 89s Preparing to unpack .../perl_5.38.2-3.2_arm64.deb ... 89s Unpacking perl (5.38.2-3.2) over (5.38.2-3) ... 89s Preparing to unpack .../perl-base_5.38.2-3.2_arm64.deb ... 89s Unpacking perl-base (5.38.2-3.2) over (5.38.2-3) ... 89s Setting up perl-base (5.38.2-3.2) ... 89s (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 ... 74758 files and directories currently installed.) 89s Preparing to unpack .../perl-modules-5.38_5.38.2-3.2_all.deb ... 89s Unpacking perl-modules-5.38 (5.38.2-3.2) over (5.38.2-3) ... 90s Preparing to unpack .../readline-common_8.2-3.1_all.deb ... 90s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 90s Preparing to unpack .../klibc-utils_2.0.13-4_arm64.deb ... 90s Unpacking klibc-utils (2.0.13-4) over (2.0.13-2ubuntu1) ... 90s Preparing to unpack .../libklibc_2.0.13-4_arm64.deb ... 90s Unpacking libklibc:arm64 (2.0.13-4) over (2.0.13-2ubuntu1) ... 90s Setting up libgdbm6t64:arm64 (1.23-5.1) ... 90s Setting up libgdbm-compat4t64:arm64 (1.23-5.1) ... 90s Setting up libssl3t64:arm64 (3.0.13-0ubuntu1) ... 90s Setting up libpython3.12-minimal:arm64 (3.12.2-4build2) ... 90s Setting up libklibc:arm64 (2.0.13-4) ... 90s Setting up perl-modules-5.38 (5.38.2-3.2) ... 90s Setting up libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 90s Setting up libperl5.38t64:arm64 (5.38.2-3.2) ... 90s Setting up klibc-utils (2.0.13-4) ... 90s Setting up openssl (3.0.13-0ubuntu1) ... 90s Setting up readline-common (8.2-3.1) ... 90s Setting up python3.12-minimal (3.12.2-4build2) ... 91s Setting up perl (5.38.2-3.2) ... 91s Setting up libreadline8t64:arm64 (8.2-3.1) ... 91s Setting up libpython3.12-stdlib:arm64 (3.12.2-4build2) ... 91s Setting up python3.12 (3.12.2-4build2) ... 92s Processing triggers for systemd (255.2-3ubuntu2) ... 93s Processing triggers for man-db (2.12.0-3) ... 93s Processing triggers for install-info (7.1-3) ... 94s Processing triggers for initramfs-tools (0.142ubuntu20) ... 94s update-initramfs: Generating /boot/initrd.img-6.8.0-11-generic 94s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 113s System running in EFI mode, skipping. 113s Processing triggers for libc-bin (2.39-0ubuntu2) ... 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 115s sh: Attempting to set up Debian/Ubuntu apt sources automatically 115s sh: Distribution appears to be Ubuntu 116s Reading package lists... 116s Building dependency tree... 116s Reading state information... 117s eatmydata is already the newest version (131-1). 117s dbus is already the newest version (1.14.10-4ubuntu1). 117s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 117s Reading package lists... 117s Building dependency tree... 117s Reading state information... 118s rng-tools-debian is already the newest version (2.4). 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... 119s haveged is already the newest version (1.9.14-1ubuntu1). 119s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 119s Reading package lists... 119s Building dependency tree... 119s Reading state information... 120s The following packages will be REMOVED: 120s cloud-init* python3-configobj* python3-debconf* 120s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 120s After this operation, 3248 kB disk space will be freed. 120s (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 ... 74758 files and directories currently installed.) 120s Removing cloud-init (24.1-0ubuntu1) ... 121s Removing python3-configobj (5.0.8-3) ... 121s Removing python3-debconf (1.5.86) ... 121s Processing triggers for man-db (2.12.0-3) ... 122s (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 ... 74369 files and directories currently installed.) 122s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 123s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 123s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 123s Reading package lists... 123s Building dependency tree... 123s Reading state information... 124s linux-generic is already the newest version (6.8.0-11.11+1). 124s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 125s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 125s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 125s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 126s Reading package lists... 126s Reading package lists... 126s Building dependency tree... 126s Reading state information... 127s Calculating upgrade... 127s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 127s Reading package lists... 127s Building dependency tree... 127s Reading state information... 128s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 128s autopkgtest [16:56:35]: rebooting testbed after setup commands that affected boot 338s autopkgtest [17:00:05]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 338s autopkgtest [17:00:05]: testbed dpkg architecture: arm64 339s autopkgtest [17:00:06]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 342s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (dsc) [2150 B] 342s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (tar) [16.3 MB] 342s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (diff) [4036 B] 343s gpgv: Signature made Wed Jan 10 15:06:56 2024 UTC 343s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 343s gpgv: Can't check signature: No public key 343s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.15-1.dsc: no acceptable signature found 344s autopkgtest [17:00:10]: testing package pgcopydb version 0.15-1 344s autopkgtest [17:00:11]: build not needed 346s autopkgtest [17:00:13]: test copydb: preparing testbed 349s Reading package lists... 349s Building dependency tree... 349s Reading state information... 349s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 349s Starting 2 pkgProblemResolver with broken count: 0 349s Done 350s Done 350s Starting pkgProblemResolver with broken count: 0 350s Starting 2 pkgProblemResolver with broken count: 0 350s Done 351s The following additional packages will be installed: 351s libjson-perl libllvm17t64 libpq5 libxslt1.1 pgcopydb postgresql 351s postgresql-16 postgresql-client postgresql-client-16 351s postgresql-client-common postgresql-common ssl-cert 351s Suggested packages: 351s postgresql-doc postgresql-doc-16 351s Recommended packages: 351s libjson-xs-perl 351s The following NEW packages will be installed: 351s libjson-perl libllvm17t64 libpq5 libxslt1.1 pgcopydb postgresql 351s postgresql-16 postgresql-client postgresql-client-16 351s postgresql-client-common postgresql-common ssl-cert 351s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 351s 1 not fully installed or removed. 351s Need to get 42.4 MB of archives. 351s After this operation, 176 MB of additional disk space will be used. 351s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpq5 arm64 16.2-1ubuntu2 [137 kB] 352s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-common all 257 [36.2 kB] 352s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 postgresql-client-16 arm64 16.2-1ubuntu2 [1261 kB] 352s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client all 16+257 [11.4 kB] 352s Get:5 http://ftpmaster.internal/ubuntu noble/universe arm64 pgcopydb arm64 0.15-1 [309 kB] 352s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 352s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 352s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-common all 257 [162 kB] 352s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libllvm17t64 arm64 1:17.0.6-8ubuntu1.1 [25.0 MB] 352s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libxslt1.1 arm64 1.1.35-1 [161 kB] 352s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 postgresql-16 arm64 16.2-1ubuntu2 [15.2 MB] 353s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql all 16+257 [11.4 kB] 353s Preconfiguring packages ... 353s Fetched 42.4 MB in 2s (22.7 MB/s) 353s Selecting previously unselected package libpq5:arm64. 353s (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 ... 74314 files and directories currently installed.) 353s Preparing to unpack .../00-libpq5_16.2-1ubuntu2_arm64.deb ... 353s Unpacking libpq5:arm64 (16.2-1ubuntu2) ... 353s Selecting previously unselected package postgresql-client-common. 353s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 353s Unpacking postgresql-client-common (257) ... 353s Selecting previously unselected package postgresql-client-16. 353s Preparing to unpack .../02-postgresql-client-16_16.2-1ubuntu2_arm64.deb ... 353s Unpacking postgresql-client-16 (16.2-1ubuntu2) ... 354s Selecting previously unselected package postgresql-client. 354s Preparing to unpack .../03-postgresql-client_16+257_all.deb ... 354s Unpacking postgresql-client (16+257) ... 354s Selecting previously unselected package pgcopydb. 354s Preparing to unpack .../04-pgcopydb_0.15-1_arm64.deb ... 354s Unpacking pgcopydb (0.15-1) ... 354s Selecting previously unselected package libjson-perl. 354s Preparing to unpack .../05-libjson-perl_4.10000-1_all.deb ... 354s Unpacking libjson-perl (4.10000-1) ... 354s Selecting previously unselected package ssl-cert. 354s Preparing to unpack .../06-ssl-cert_1.1.2ubuntu1_all.deb ... 354s Unpacking ssl-cert (1.1.2ubuntu1) ... 354s Selecting previously unselected package postgresql-common. 354s Preparing to unpack .../07-postgresql-common_257_all.deb ... 354s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 354s Unpacking postgresql-common (257) ... 354s Selecting previously unselected package libllvm17t64:arm64. 354s Preparing to unpack .../08-libllvm17t64_1%3a17.0.6-8ubuntu1.1_arm64.deb ... 354s Unpacking libllvm17t64:arm64 (1:17.0.6-8ubuntu1.1) ... 355s Selecting previously unselected package libxslt1.1:arm64. 355s Preparing to unpack .../09-libxslt1.1_1.1.35-1_arm64.deb ... 355s Unpacking libxslt1.1:arm64 (1.1.35-1) ... 355s Selecting previously unselected package postgresql-16. 355s Preparing to unpack .../10-postgresql-16_16.2-1ubuntu2_arm64.deb ... 355s Unpacking postgresql-16 (16.2-1ubuntu2) ... 355s Selecting previously unselected package postgresql. 355s Preparing to unpack .../11-postgresql_16+257_all.deb ... 355s Unpacking postgresql (16+257) ... 355s Setting up postgresql-client-common (257) ... 355s Setting up libpq5:arm64 (16.2-1ubuntu2) ... 355s Setting up libllvm17t64:arm64 (1:17.0.6-8ubuntu1.1) ... 355s Setting up ssl-cert (1.1.2ubuntu1) ... 359s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 360s Setting up libjson-perl (4.10000-1) ... 360s Setting up libxslt1.1:arm64 (1.1.35-1) ... 360s Setting up postgresql-client-16 (16.2-1ubuntu2) ... 360s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 360s Setting up postgresql-common (257) ... 361s 361s Creating config file /etc/postgresql-common/createcluster.conf with new version 361s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 361s Removing obsolete dictionary files: 362s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 363s Setting up pgcopydb (0.15-1) ... 363s Setting up postgresql-client (16+257) ... 363s Setting up postgresql-16 (16.2-1ubuntu2) ... 363s Creating new PostgreSQL cluster 16/main ... 363s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 363s The files belonging to this database system will be owned by user "postgres". 363s This user must also own the server process. 363s 363s The database cluster will be initialized with locale "C.UTF-8". 363s The default database encoding has accordingly been set to "UTF8". 363s The default text search configuration will be set to "english". 363s 363s Data page checksums are disabled. 363s 363s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 363s creating subdirectories ... ok 363s selecting dynamic shared memory implementation ... posix 363s selecting default max_connections ... 100 363s selecting default shared_buffers ... 128MB 363s selecting default time zone ... Etc/UTC 363s creating configuration files ... ok 363s running bootstrap script ... ok 364s performing post-bootstrap initialization ... ok 364s syncing data to disk ... ok 369s Setting up postgresql (16+257) ... 369s Setting up autopkgtest-satdep (0) ... 370s Processing triggers for man-db (2.12.0-3) ... 371s Processing triggers for libc-bin (2.39-0ubuntu2) ... 374s (Reading database ... 76278 files and directories currently installed.) 374s Removing autopkgtest-satdep (0) ... 375s autopkgtest [17:00:42]: test copydb: [----------------------- 375s + WORKDIR=/tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home 375s + pg_virtualenv 376s Creating new PostgreSQL cluster 16/regress ... 379s + createdb src 379s + createdb dst 379s + psql -c 'create table foo as select 123+456' src 379s SELECT 1 379s + rm -rf /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home 379s + HOME=/tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home 379s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home 379s 2024-03-11 17:00:46.918 3248 INFO main.c:129 Running pgcopydb version 0.15-1 from "/usr/bin/pgcopydb" 379s 2024-03-11 17:00:46.919 3248 INFO cli_common.c:1312 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 379s 2024-03-11 17:00:46.919 3248 INFO cli_common.c:1313 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 379s 2024-03-11 17:00:46.931 3248 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home" 379s 2024-03-11 17:00:46.949 3248 INFO snapshot.c:100 Exported snapshot "00000003-00000010-1" from the source database 379s 2024-03-11 17:00:46.950 3252 INFO cli_clone_follow.c:518 STEP 1: fetch source database tables, indexes, and sequences 380s 2024-03-11 17:00:47.405 3252 INFO copydb_schema.c:668 Fetched information for 1 tables (including 0 tables split in 0 partitions total), with an estimated total of 18 quintillion tuples and 8192 B on-disk 380s 2024-03-11 17:00:47.415 3252 INFO copydb_schema.c:831 Fetched information for 0 indexes (supporting 0 constraints) 380s 2024-03-11 17:00:47.416 3252 INFO sequences.c:64 Fetching information for 0 sequences 380s 2024-03-11 17:00:47.426 3252 INFO copydb_schema.c:929 Fetched information for 1 extensions 380s 2024-03-11 17:00:47.559 3252 INFO copydb_schema.c:1300 Found 0 indexes (supporting 0 constraints) in the target database 380s 2024-03-11 17:00:47.568 3252 INFO cli_clone_follow.c:559 STEP 2: dump the source database schema (pre/post data) 380s 2024-03-11 17:00:47.572 3252 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section pre-data --file /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/pre.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 380s 2024-03-11 17:00:47.641 3252 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section post-data --file /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/post.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 380s 2024-03-11 17:00:47.706 3252 INFO cli_clone_follow.c:569 STEP 3: restore the pre-data section to the target database 380s 2024-03-11 17:00:47.739 3252 INFO pgcmd.c:974 /usr/lib/postgresql/16/bin/pg_restore --dbname 'postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' --jobs 4 --use-list /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/pre.dump 380s 2024-03-11 17:00:47.867 3273 INFO table-data.c:649 STEP 4: starting 4 table-data COPY processes 380s 2024-03-11 17:00:47.901 3275 INFO vacuum.c:142 STEP 8: starting 4 VACUUM processes 380s 2024-03-11 17:00:47.917 3252 INFO blobs.c:74 Skipping large objects: none found. 380s 2024-03-11 17:00:47.918 3274 INFO indexes.c:157 STEP 6: starting 4 CREATE INDEX processes 380s 2024-03-11 17:00:47.918 3274 INFO indexes.c:158 STEP 7: constraints are built by the CREATE INDEX processes 380s 2024-03-11 17:00:47.936 3252 INFO sequences.c:155 STEP 9: reset sequences values 381s 2024-03-11 17:00:47.982 3297 INFO sequences.c:245 Reset sequences values on the target database 381s 2024-03-11 17:00:48.353 3252 INFO cli_clone_follow.c:585 STEP 10: restore the post-data section to the target database 381s 2024-03-11 17:00:48.369 3252 INFO pgcmd.c:974 /usr/lib/postgresql/16/bin/pg_restore --dbname 'postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' --jobs 4 --use-list /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.ZhGlpM/build.o67/src/debian/home/schema/post.dump 381s 2024-03-11 17:00:48.468 3252 INFO cli_clone_follow.c:616 All step are now done, 1s513 elapsed 381s 2024-03-11 17:00:48.469 3252 INFO summary.c:3161 Printing summary for 1 tables and 0 indexes 381s 381s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 381s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 381s 16386 | public | foo | 1 | 40ms | 4 B | 0 | 0ms 381s 381s 381s Step Connection Duration Transfer Concurrency 381s -------------------------------------------------- ---------- ---------- ---------- ------------ 381s Catalog Queries (table ordering, filtering, etc) source 200ms 1 381s Dump Schema source 135ms 1 381s Prepare Schema target 148ms 1 381s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 490ms 12 381s COPY (cumulative) both 40ms 8192 B 4 381s CREATE INDEX (cumulative) target 0ms 4 381s CONSTRAINTS (cumulative) target 0ms 4 381s VACUUM (cumulative) target 23ms 4 381s Reset Sequences both 219ms 1 381s Large Objects (cumulative) (null) 0ms 0 381s Finalize Schema both 105ms 4 381s -------------------------------------------------- ---------- ---------- ---------- ------------ 381s Total Wall Clock Duration both 1s513 20 381s 381s + pg_dump -t foo dst 381s -- 381s -- PostgreSQL database dump 381s -- 381s 381s -- Dumped from database version 16.2 (Ubuntu 16.2-1ubuntu2) 381s -- Dumped by pg_dump version 16.2 (Ubuntu 16.2-1ubuntu2) 381s 381s SET statement_timeout = 0; 381s SET lock_timeout = 0; 381s SET idle_in_transaction_session_timeout = 0; 381s SET client_encoding = 'UTF8'; 381s SET standard_conforming_strings = on; 381s SELECT pg_catalog.set_config('search_path', '', false); 381s SET check_function_bodies = false; 381s SET xmloption = content; 381s SET client_min_messages = warning; 381s SET row_security = off; 381s 381s SET default_tablespace = ''; 381s 381s SET default_table_access_method = heap; 381s 381s -- 381s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 381s -- 381s 381s CREATE TABLE public.foo ( 381s "?column?" integer 381s ); 381s 381s 381s ALTER TABLE public.foo OWNER TO ubuntu; 381s 381s -- 381s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 381s -- 381s 381s COPY public.foo ("?column?") FROM stdin; 381s 579 381s \. 381s 381s 381s -- 381s -- PostgreSQL database dump complete 381s -- 381s 381s + pg_dump -t foo dst 381s + grep 579 382s 579 382s Dropping cluster 16/regress ... 382s autopkgtest [17:00:49]: test copydb: -----------------------] 383s autopkgtest [17:00:50]: test copydb: - - - - - - - - - - results - - - - - - - - - - 383s copydb PASS 383s autopkgtest [17:00:50]: @@@@@@@@@@@@@@@@@@@@ summary 383s copydb PASS 395s Creating nova instance adt-noble-arm64-pgcopydb-20240311-165427-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-arm64-server-20240311.img (UUID 900cfff9-7f1a-42c7-81a7-22635cd2a5f9)...