0s autopkgtest [14:16:01]: starting date and time: 2025-03-15 14:16:01+0000 0s autopkgtest [14:16:01]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:16:01]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.6fldyz_d/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade pgcopydb --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-3.secgroup --name adt-plucky-arm64-pgcopydb-20250315-141601-juju-7f2275-prod-proposed-migration-environment-15-6715fc95-d95d-4fa3-abf2-72bb3946cc26 --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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,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/ 176s autopkgtest [14:18:57]: testbed dpkg architecture: arm64 176s autopkgtest [14:18:57]: testbed apt version: 2.9.33 177s autopkgtest [14:18:58]: @@@@@@@@@@@@@@@@@@@@ test bed setup 177s autopkgtest [14:18:58]: testbed release detected to be: None 178s autopkgtest [14:18:59]: updating testbed package index (apt update) 178s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 179s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 179s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 179s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 179s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 179s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 179s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 179s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 179s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 179s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 179s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 180s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 180s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 180s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 180s Fetched 1094 kB in 2s (634 kB/s) 181s Reading package lists... 182s + lsb_release --codename --short 182s + RELEASE=plucky 182s + cat 182s + [ plucky != trusty ] 182s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 182s Reading package lists... 182s Building dependency tree... 182s Reading state information... 183s Calculating upgrade... 183s Calculating upgrade... 183s The following packages will be upgraded: 183s python3-jinja2 strace 183s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 183s Need to get 608 kB of archives. 183s After this operation, 11.3 kB of additional disk space will be used. 183s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 184s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 185s Fetched 608 kB in 1s (603 kB/s) 185s (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 ... 117701 files and directories currently installed.) 185s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 185s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 185s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 185s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 186s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 186s Setting up strace (6.13+ds-1ubuntu1) ... 186s Processing triggers for man-db (2.13.0-1) ... 187s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 187s + /usr/lib/apt/apt-helper analyze-pattern ?true 187s + uname -r 187s + sed s/\./\\./g 187s + running_kernel_pattern=^linux-.*6\.14\.0-10-generic.* 187s + apt list ?obsolete 187s + tail -n+2 187s + cut -d/ -f1 187s + grep -v ^linux-.*6\.14\.0-10-generic.* 187s + obsolete_pkgs=linux-headers-6.11.0-8-generic 187s linux-headers-6.11.0-8 187s linux-image-6.11.0-8-generic 187s linux-modules-6.11.0-8-generic 187s linux-tools-6.11.0-8-generic 187s linux-tools-6.11.0-8 187s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove linux-headers-6.11.0-8-generic linux-headers-6.11.0-8 linux-image-6.11.0-8-generic linux-modules-6.11.0-8-generic linux-tools-6.11.0-8-generic linux-tools-6.11.0-8 187s Reading package lists... 187s Building dependency tree... 187s Reading state information... 188s Solving dependencies... 188s The following packages will be REMOVED: 188s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 188s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 188s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 188s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 189s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 189s After this operation, 267 MB disk space will be freed. 189s (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 ... 117701 files and directories currently installed.) 189s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 189s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 189s Removing libpython3.12t64:arm64 (3.12.9-1) ... 189s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 189s Removing libnsl2:arm64 (1.3.0-3build3) ... 189s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 189s Removing libunwind8:arm64 (1.6.2-3.1) ... 189s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 190s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 191s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 192s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 192s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 192s /etc/kernel/postrm.d/initramfs-tools: 192s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 192s /etc/kernel/postrm.d/zz-flash-kernel: 192s flash-kernel: Kernel 6.11.0-8-generic has been removed. 192s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 192s /etc/kernel/postrm.d/zz-update-grub: 192s Sourcing file `/etc/default/grub' 192s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 192s Generating grub configuration file ... 192s Found linux image: /boot/vmlinuz-6.14.0-10-generic 192s Found initrd image: /boot/initrd.img-6.14.0-10-generic 193s Warning: os-prober will not be executed to detect other bootable partitions. 193s Systems on them will not be added to the GRUB boot configuration. 193s Check GRUB_DISABLE_OS_PROBER documentation entry. 193s Adding boot menu entry for UEFI Firmware Settings ... 193s done 193s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 193s Processing triggers for libc-bin (2.41-1ubuntu1) ... 194s (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 ... 81650 files and directories currently installed.) 194s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 194s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 194s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 194s + grep -q trusty /etc/lsb-release 194s + [ ! -d /usr/share/doc/unattended-upgrades ] 194s + [ ! -d /usr/share/doc/lxd ] 194s + [ ! -d /usr/share/doc/lxd-client ] 194s + [ ! -d /usr/share/doc/snapd ] 194s + type iptables 194s + cat 194s + chmod 755 /etc/rc.local 194s + . /etc/rc.local 194s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 194s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 194s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 194s + uname -m 194s + [ aarch64 = ppc64le ] 194s + [ -d /run/systemd/system ] 194s + systemd-detect-virt --quiet --vm 194s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 194s + cat 194s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 194s + echo COMPRESS=lz4 194s autopkgtest [14:19:15]: upgrading testbed (apt dist-upgrade and autopurge) 194s Reading package lists... 195s Building dependency tree... 195s Reading state information... 195s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 195s Starting 2 pkgProblemResolver with broken count: 0 195s Done 196s Entering ResolveByKeep 196s 197s Calculating upgrade... 197s The following packages will be upgraded: 197s libc-bin libc-dev-bin libc6 libc6-dev locales 197s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 197s Need to get 9530 kB of archives. 197s After this operation, 0 B of additional disk space will be used. 197s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 199s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 199s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 203s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 203s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 207s Preconfiguring packages ... 207s Fetched 9530 kB in 10s (982 kB/s) 207s (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 ... 81647 files and directories currently installed.) 207s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 207s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 207s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 207s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 208s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Setting up libc6:arm64 (2.41-1ubuntu2) ... 208s (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 ... 81647 files and directories currently installed.) 208s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 208s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Setting up libc-bin (2.41-1ubuntu2) ... 208s (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 ... 81647 files and directories currently installed.) 208s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 208s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 209s Setting up locales (2.41-1ubuntu2) ... 209s Generating locales (this might take a while)... 211s en_US.UTF-8... done 211s Generation complete. 211s Setting up libc-dev-bin (2.41-1ubuntu2) ... 211s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 211s Processing triggers for man-db (2.13.0-1) ... 212s Processing triggers for systemd (257.3-1ubuntu3) ... 213s Reading package lists... 213s Building dependency tree... 213s Reading state information... 214s Starting pkgProblemResolver with broken count: 0 214s Starting 2 pkgProblemResolver with broken count: 0 214s Done 214s Solving dependencies... 215s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 215s autopkgtest [14:19:36]: rebooting testbed after setup commands that affected boot 238s autopkgtest [14:19:59]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP PREEMPT_DYNAMIC Wed Mar 12 15:45:31 UTC 2025 241s autopkgtest [14:20:02]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 261s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (dsc) [2145 B] 261s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (tar) [19.1 MB] 261s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (diff) [4148 B] 261s gpgv: Signature made Wed Aug 7 13:46:44 2024 UTC 261s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 261s gpgv: Can't check signature: No public key 261s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.17-1.dsc: no acceptable signature found 262s autopkgtest [14:20:23]: testing package pgcopydb version 0.17-1 262s autopkgtest [14:20:23]: build not needed 264s autopkgtest [14:20:25]: test copydb: preparing testbed 264s Reading package lists... 264s Building dependency tree... 264s Reading state information... 265s Starting pkgProblemResolver with broken count: 0 265s Starting 2 pkgProblemResolver with broken count: 0 265s Done 265s The following NEW packages will be installed: 265s libgc1 libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 265s libxslt1.1 pgcopydb postgresql postgresql-17 postgresql-client 265s postgresql-client-17 postgresql-client-common postgresql-common 265s postgresql-common-dev ssl-cert 266s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 266s Need to get 47.7 MB of archives. 266s After this operation, 200 MB of additional disk space will be used. 266s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 266s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 266s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 266s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 266s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 266s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 266s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 266s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 266s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 288s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 288s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 288s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 289s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client all 17+274 [13.3 kB] 289s Get:14 http://ftpmaster.internal/ubuntu plucky/universe arm64 pgcopydb arm64 0.17-1 [793 kB] 290s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 299s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql all 17+274 [14.4 kB] 299s Preconfiguring packages ... 299s /var/cache/debconf/tmp.ci/postgresql.config.GPVbEL: 12: pg_lsclusters: not found 299s Fetched 47.7 MB in 33s (1445 kB/s) 299s Selecting previously unselected package libjson-perl. 299s (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 ... 81647 files and directories currently installed.) 299s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 299s Unpacking libjson-perl (4.10000-1) ... 299s Selecting previously unselected package postgresql-client-common. 299s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 299s Unpacking postgresql-client-common (274) ... 299s Selecting previously unselected package libio-pty-perl. 299s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 299s Unpacking libio-pty-perl (1:1.20-1build3) ... 299s Selecting previously unselected package libipc-run-perl. 299s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 299s Unpacking libipc-run-perl (20231003.0-2) ... 299s Selecting previously unselected package postgresql-common-dev. 299s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 299s Unpacking postgresql-common-dev (274) ... 299s Selecting previously unselected package ssl-cert. 299s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 299s Unpacking ssl-cert (1.1.3ubuntu1) ... 300s Selecting previously unselected package postgresql-common. 300s Preparing to unpack .../06-postgresql-common_274_all.deb ... 300s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 300s Unpacking postgresql-common (274) ... 300s Selecting previously unselected package libgc1:arm64. 300s Preparing to unpack .../07-libgc1_1%3a8.2.8-1_arm64.deb ... 300s Unpacking libgc1:arm64 (1:8.2.8-1) ... 300s Selecting previously unselected package libllvm20:arm64. 300s Preparing to unpack .../08-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 300s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 300s Selecting previously unselected package libpq5:arm64. 300s Preparing to unpack .../09-libpq5_17.4-1_arm64.deb ... 300s Unpacking libpq5:arm64 (17.4-1) ... 300s Selecting previously unselected package libxslt1.1:arm64. 300s Preparing to unpack .../10-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 300s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 300s Selecting previously unselected package postgresql-client-17. 300s Preparing to unpack .../11-postgresql-client-17_17.4-1_arm64.deb ... 300s Unpacking postgresql-client-17 (17.4-1) ... 300s Selecting previously unselected package postgresql-client. 300s Preparing to unpack .../12-postgresql-client_17+274_all.deb ... 300s Unpacking postgresql-client (17+274) ... 301s Selecting previously unselected package pgcopydb. 301s Preparing to unpack .../13-pgcopydb_0.17-1_arm64.deb ... 301s Unpacking pgcopydb (0.17-1) ... 301s Selecting previously unselected package postgresql-17. 301s Preparing to unpack .../14-postgresql-17_17.4-1_arm64.deb ... 301s Unpacking postgresql-17 (17.4-1) ... 301s Selecting previously unselected package postgresql. 301s Preparing to unpack .../15-postgresql_17+274_all.deb ... 301s Unpacking postgresql (17+274) ... 301s Setting up postgresql-client-common (274) ... 301s Setting up libio-pty-perl (1:1.20-1build3) ... 301s Setting up libpq5:arm64 (17.4-1) ... 301s Setting up ssl-cert (1.1.3ubuntu1) ... 301s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 302s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 302s Setting up libipc-run-perl (20231003.0-2) ... 302s Setting up libgc1:arm64 (1:8.2.8-1) ... 302s Setting up libjson-perl (4.10000-1) ... 302s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 302s Setting up postgresql-common-dev (274) ... 302s Setting up postgresql-client-17 (17.4-1) ... 302s 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 302s Setting up postgresql-common (274) ... 303s Creating config file /etc/postgresql-common/createcluster.conf with new version 303s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 303s Removing obsolete dictionary files: 304s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 304s Setting up pgcopydb (0.17-1) ... 304s Setting up postgresql-17 (17.4-1) ... 305s Creating new PostgreSQL cluster 17/main ... 305s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 305s The files belonging to this database system will be owned by user "postgres". 305s This user must also own the server process. 305s 305s The database cluster will be initialized with locale "C.UTF-8". 305s The default database encoding has accordingly been set to "UTF8". 305s The default text search configuration will be set to "english". 305s 305s Data page checksums are disabled. 305s 305s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 305s creating subdirectories ... ok 305s selecting dynamic shared memory implementation ... posix 305s selecting default "max_connections" ... 100 305s selecting default "shared_buffers" ... 128MB 305s selecting default time zone ... Etc/UTC 305s creating configuration files ... ok 305s running bootstrap script ... ok 305s performing post-bootstrap initialization ... ok 305s syncing data to disk ... ok 308s Setting up postgresql-client (17+274) ... 308s Setting up postgresql (17+274) ... 309s Processing triggers for man-db (2.13.0-1) ... 310s Processing triggers for libc-bin (2.41-1ubuntu2) ... 311s autopkgtest [14:21:12]: test copydb: [----------------------- 311s + WORKDIR=/tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home 311s + pg_virtualenv 311s Creating new PostgreSQL cluster 17/regress ... 314s + createdb src 314s + createdb dst 314s + psql -c 'create table foo as select 123+456' src 314s SELECT 1 314s + rm -rf /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home 314s + HOME=/tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home 314s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home 314s 2025-03-15 14:21:15.923 3515 INFO main.c:136 Running pgcopydb version 0.17-1 from "/usr/bin/pgcopydb" 314s 2025-03-15 14:21:15.924 3515 INFO cli_common.c:1225 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 314s 2025-03-15 14:21:15.924 3515 INFO cli_common.c:1226 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 315s 2025-03-15 14:21:15.931 3515 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home" 315s 2025-03-15 14:21:15.952 3515 INFO snapshot.c:107 Exported snapshot "00000007-00000002-1" from the source database 315s 2025-03-15 14:21:15.953 3520 INFO cli_clone_follow.c:543 STEP 1: fetch source database tables, indexes, and sequences 315s 2025-03-15 14:21:16.261 3520 INFO copydb_schema.c:761 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 315s 2025-03-15 14:21:16.267 3520 INFO copydb_schema.c:968 Fetched information for 0 indexes (supporting 0 constraints) 315s 2025-03-15 14:21:16.270 3520 INFO sequences.c:78 Fetching information for 0 sequences 315s 2025-03-15 14:21:16.284 3520 INFO copydb_schema.c:1122 Fetched information for 1 extensions 315s 2025-03-15 14:21:16.380 3520 INFO copydb_schema.c:1538 Found 0 indexes (supporting 0 constraints) in the target database 315s 2025-03-15 14:21:16.387 3520 INFO cli_clone_follow.c:584 STEP 2: dump the source database schema (pre/post data) 315s 2025-03-15 14:21:16.390 3520 INFO pgcmd.c:475 /usr/lib/postgresql/17/bin/pg_dump -Fc --snapshot 00000007-00000002-1 --section=pre-data --section=post-data --file /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home/schema/schema.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 315s 2025-03-15 14:21:16.530 3520 INFO cli_clone_follow.c:592 STEP 3: restore the pre-data section to the target database 315s 2025-03-15 14:21:16.557 3520 INFO pgcmd.c:1008 /usr/lib/postgresql/17/bin/pg_restore --dbname 'postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' --section pre-data --jobs 4 --use-list /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home/schema/schema.dump 315s 2025-03-15 14:21:16.678 3539 INFO table-data.c:656 STEP 4: starting 4 table-data COPY processes 315s 2025-03-15 14:21:16.702 3541 INFO vacuum.c:143 STEP 8: starting 4 VACUUM processes 315s 2025-03-15 14:21:16.739 3540 INFO indexes.c:182 STEP 6: starting 4 CREATE INDEX processes 315s 2025-03-15 14:21:16.739 3540 INFO indexes.c:183 STEP 7: constraints are built by the CREATE INDEX processes 315s 2025-03-15 14:21:16.787 3520 INFO blobs.c:74 Skipping large objects: none found. 315s 2025-03-15 14:21:16.794 3520 INFO sequences.c:194 STEP 9: reset sequences values 315s 2025-03-15 14:21:16.797 3569 INFO sequences.c:290 Set sequences values on the target database 316s 2025-03-15 14:21:17.099 3520 INFO cli_clone_follow.c:608 STEP 10: restore the post-data section to the target database 316s 2025-03-15 14:21:17.108 3520 INFO pgcmd.c:1008 /usr/lib/postgresql/17/bin/pg_restore --dbname 'postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' --section post-data --jobs 4 --use-list /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.OO3hlZ/build.jEQ/src/debian/home/schema/schema.dump 316s 2025-03-15 14:21:17.173 3520 INFO cli_clone_follow.c:639 All step are now done, 785ms elapsed 316s 2025-03-15 14:21:17.173 3520 INFO summary.c:3173 Printing summary for 1 tables and 0 indexes 316s 316s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 316s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 316s 16386 | public | foo | 1 | 31ms | 4 B | 0 | 0ms 316s 316s 316s Step Connection Duration Transfer Concurrency 316s -------------------------------------------------- ---------- ---------- ---------- ------------ 316s Catalog Queries (table ordering, filtering, etc) source 167ms 1 316s Dump Schema source 139ms 1 316s Prepare Schema target 114ms 1 316s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 443ms 12 316s COPY (cumulative) both 31ms 8192 B 4 316s CREATE INDEX (cumulative) target 0ms 4 316s CONSTRAINTS (cumulative) target 0ms 4 316s VACUUM (cumulative) target 12ms 4 316s Reset Sequences both 21ms 1 316s Large Objects (cumulative) (null) 0ms 0 316s Finalize Schema both 67ms 4 316s -------------------------------------------------- ---------- ---------- ---------- ------------ 316s Total Wall Clock Duration both 785ms 20 316s 316s + pg_dump -t foo dst 316s -- 316s -- PostgreSQL database dump 316s -- 316s 316s -- Dumped from database version 17.4 (Ubuntu 17.4-1) 316s -- Dumped by pg_dump version 17.4 (Ubuntu 17.4-1) 316s 316s SET statement_timeout = 0; 316s SET lock_timeout = 0; 316s SET idle_in_transaction_session_timeout = 0; 316s SET transaction_timeout = 0; 316s SET client_encoding = 'UTF8'; 316s SET standard_conforming_strings = on; 316s SELECT pg_catalog.set_config('search_path', '', false); 316s SET check_function_bodies = false; 316s SET xmloption = content; 316s SET client_min_messages = warning; 316s SET row_security = off; 316s 316s SET default_tablespace = ''; 316s 316s SET default_table_access_method = heap; 316s 316s -- 316s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 316s -- 316s 316s CREATE TABLE public.foo ( 316s "?column?" integer 316s ); 316s 316s 316s ALTER TABLE public.foo OWNER TO ubuntu; 316s 316s -- 316s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 316s -- 316s 316s COPY public.foo ("?column?") FROM stdin; 316s 579 316s \. 316s 316s 316s -- 316s -- PostgreSQL database dump complete 316s -- 316s 316s + pg_dump -t foo dst 316s + grep 579 316s 579 316s Dropping cluster 17/regress ... 317s autopkgtest [14:21:18]: test copydb: -----------------------] 317s copydb PASS 317s autopkgtest [14:21:18]: test copydb: - - - - - - - - - - results - - - - - - - - - - 318s autopkgtest [14:21:19]: @@@@@@@@@@@@@@@@@@@@ summary 318s copydb PASS 336s nova [W] Using flock in prodstack6-arm64 336s Creating nova instance adt-plucky-arm64-pgcopydb-20250315-141601-juju-7f2275-prod-proposed-migration-environment-15-6715fc95-d95d-4fa3-abf2-72bb3946cc26 from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 336s nova [W] Timed out waiting for 44d25918-add5-4920-947d-647c159b8a12 to get deleted.