0s autopkgtest [13:55:03]: starting date: 2024-03-10 0s autopkgtest [13:55:03]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [13:55:03]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.6mmlvtra/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:sqlite3,src:readline --apt-upgrade pgcopydb --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=sqlite3/3.45.1-1ubuntu1 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-23.secgroup --name adt-noble-arm64-pgcopydb-20240310-135503-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/ 64s autopkgtest [13:56:07]: @@@@@@@@@@@@@@@@@@@@ test bed setup 65s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 65s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 65s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [476 kB] 65s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [37.3 kB] 65s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2649 kB] 66s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [609 kB] 66s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 66s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [20.3 kB] 66s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 66s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [2951 kB] 66s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 66s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [39.6 kB] 66s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 67s Fetched 6914 kB in 2s (4402 kB/s) 68s Reading package lists... 70s Reading package lists... 71s Building dependency tree... 71s Reading state information... 71s Calculating upgrade... 71s The following package was automatically installed and is no longer required: 71s ubuntu-advantage-tools 71s Use 'sudo apt autoremove' to remove it. 71s The following NEW packages will be installed: 71s libnuma1 libsensors-config libsensors5 numactl sysstat 71s The following packages will be upgraded: 71s efibootmgr libsqlite3-0 python3-attr readline-common ubuntu-minimal 71s ubuntu-standard 72s 6 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 72s Need to get 1437 kB of archives. 72s After this operation, 2215 kB of additional disk space will be used. 72s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libsqlite3-0 arm64 3.45.1-1ubuntu1 [704 kB] 72s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 readline-common all 8.2-3.1 [56.4 kB] 72s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-minimal arm64 1.535 [10.5 kB] 72s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libnuma1 arm64 2.0.18-1 [23.5 kB] 72s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-standard arm64 1.535 [10.5 kB] 72s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 efibootmgr arm64 18-1build1 [31.5 kB] 72s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 libsensors-config all 1:3.6.0-9 [5458 B] 72s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 libsensors5 arm64 1:3.6.0-9 [26.9 kB] 72s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 numactl arm64 2.0.18-1 [39.5 kB] 72s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 python3-attr all 23.2.0-2 [48.6 kB] 72s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 sysstat arm64 12.6.1-1ubuntu1 [480 kB] 72s Preconfiguring packages ... 72s Fetched 1437 kB in 1s (2395 kB/s) 73s (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 ... 74662 files and directories currently installed.) 73s Preparing to unpack .../00-libsqlite3-0_3.45.1-1ubuntu1_arm64.deb ... 73s Unpacking libsqlite3-0:arm64 (3.45.1-1ubuntu1) over (3.45.1-1) ... 73s Preparing to unpack .../01-readline-common_8.2-3.1_all.deb ... 73s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 73s Preparing to unpack .../02-ubuntu-minimal_1.535_arm64.deb ... 73s Unpacking ubuntu-minimal (1.535) over (1.534) ... 73s Selecting previously unselected package libnuma1:arm64. 73s Preparing to unpack .../03-libnuma1_2.0.18-1_arm64.deb ... 73s Unpacking libnuma1:arm64 (2.0.18-1) ... 73s Preparing to unpack .../04-ubuntu-standard_1.535_arm64.deb ... 73s Unpacking ubuntu-standard (1.535) over (1.534) ... 73s Preparing to unpack .../05-efibootmgr_18-1build1_arm64.deb ... 73s Unpacking efibootmgr (18-1build1) over (18-1) ... 73s Selecting previously unselected package libsensors-config. 73s Preparing to unpack .../06-libsensors-config_1%3a3.6.0-9_all.deb ... 73s Unpacking libsensors-config (1:3.6.0-9) ... 73s Selecting previously unselected package libsensors5:arm64. 73s Preparing to unpack .../07-libsensors5_1%3a3.6.0-9_arm64.deb ... 73s Unpacking libsensors5:arm64 (1:3.6.0-9) ... 73s Selecting previously unselected package numactl. 73s Preparing to unpack .../08-numactl_2.0.18-1_arm64.deb ... 73s Unpacking numactl (2.0.18-1) ... 73s Preparing to unpack .../09-python3-attr_23.2.0-2_all.deb ... 73s Unpacking python3-attr (23.2.0-2) over (23.2.0-1) ... 73s Selecting previously unselected package sysstat. 73s Preparing to unpack .../10-sysstat_12.6.1-1ubuntu1_arm64.deb ... 73s Unpacking sysstat (12.6.1-1ubuntu1) ... 73s Setting up python3-attr (23.2.0-2) ... 74s Setting up efibootmgr (18-1build1) ... 74s Setting up ubuntu-minimal (1.535) ... 74s Setting up libsqlite3-0:arm64 (3.45.1-1ubuntu1) ... 74s Setting up libsensors-config (1:3.6.0-9) ... 74s Setting up ubuntu-standard (1.535) ... 74s Setting up libsensors5:arm64 (1:3.6.0-9) ... 74s Setting up libnuma1:arm64 (2.0.18-1) ... 74s Setting up readline-common (8.2-3.1) ... 74s Setting up sysstat (12.6.1-1ubuntu1) ... 74s 74s Creating config file /etc/default/sysstat with new version 74s update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode 74s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer. 74s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer. 74s Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service. 76s Setting up numactl (2.0.18-1) ... 76s Processing triggers for man-db (2.12.0-3) ... 77s Processing triggers for install-info (7.1-3) ... 77s Processing triggers for libc-bin (2.39-0ubuntu2) ... 77s Reading package lists... 77s Building dependency tree... 77s Reading state information... 78s The following packages will be REMOVED: 78s ubuntu-advantage-tools* 78s 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 78s After this operation, 71.7 kB disk space will be freed. 79s (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 ... 74755 files and directories currently installed.) 79s Removing ubuntu-advantage-tools (31.1) ... 79s (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 ... 74749 files and directories currently installed.) 79s Purging configuration files for ubuntu-advantage-tools (31.1) ... 80s sh: Attempting to set up Debian/Ubuntu apt sources automatically 80s sh: Distribution appears to be Ubuntu 80s Reading package lists... 81s Building dependency tree... 81s Reading state information... 81s eatmydata is already the newest version (131-1). 81s dbus is already the newest version (1.14.10-4ubuntu1). 81s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 81s Reading package lists... 82s Building dependency tree... 82s Reading state information... 82s rng-tools-debian is already the newest version (2.4). 82s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s Reading package lists... 83s Building dependency tree... 83s Reading state information... 84s haveged is already the newest version (1.9.14-1ubuntu1). 84s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 85s The following packages will be REMOVED: 85s cloud-init* python3-configobj* python3-debconf* 85s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 85s After this operation, 3248 kB disk space will be freed. 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 ... 74748 files and directories currently installed.) 85s Removing cloud-init (24.1-0ubuntu1) ... 86s Removing python3-configobj (5.0.8-3) ... 86s Removing python3-debconf (1.5.86) ... 86s Processing triggers for man-db (2.12.0-3) ... 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 ... 74359 files and directories currently installed.) 86s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 87s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 87s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 87s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s linux-generic is already the newest version (6.8.0-11.11+1). 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 89s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 89s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 89s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 89s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 90s Reading package lists... 90s Reading package lists... 90s Building dependency tree... 90s Reading state information... 90s Calculating upgrade... 91s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 91s Reading package lists... 91s Building dependency tree... 91s Reading state information... 91s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s autopkgtest [13:56:35]: rebooting testbed after setup commands that affected boot 118s autopkgtest [13:57:01]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 118s autopkgtest [13:57:01]: testbed dpkg architecture: arm64 119s autopkgtest [13:57:02]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 122s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (dsc) [2150 B] 122s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (tar) [16.3 MB] 122s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (diff) [4036 B] 122s gpgv: Signature made Wed Jan 10 15:06:56 2024 UTC 122s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 122s gpgv: Can't check signature: No public key 122s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.15-1.dsc: no acceptable signature found 123s autopkgtest [13:57:06]: testing package pgcopydb version 0.15-1 123s autopkgtest [13:57:06]: build not needed 124s autopkgtest [13:57:07]: test copydb: preparing testbed 127s Reading package lists... 127s Building dependency tree... 127s Reading state information... 127s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 127s Starting 2 pkgProblemResolver with broken count: 0 127s Done 128s Done 128s Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 129s The following additional packages will be installed: 129s libjson-perl libllvm17 libpq5 libxslt1.1 pgcopydb postgresql postgresql-16 129s postgresql-client postgresql-client-16 postgresql-client-common 129s postgresql-common ssl-cert 129s Suggested packages: 129s postgresql-doc postgresql-doc-16 129s Recommended packages: 129s libjson-xs-perl 129s The following NEW packages will be installed: 129s libjson-perl libllvm17 libpq5 libxslt1.1 pgcopydb postgresql postgresql-16 129s postgresql-client postgresql-client-16 postgresql-client-common 129s postgresql-common ssl-cert 129s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 129s 1 not fully installed or removed. 129s Need to get 42.4 MB of archives. 129s After this operation, 176 MB of additional disk space will be used. 129s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 libpq5 arm64 16.2-1 [136 kB] 129s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-common all 257 [36.2 kB] 129s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-16 arm64 16.2-1 [1260 kB] 130s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client all 16+257 [11.4 kB] 130s Get:5 http://ftpmaster.internal/ubuntu noble/universe arm64 pgcopydb arm64 0.15-1 [309 kB] 130s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 130s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 130s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-common all 257 [162 kB] 130s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17 arm64 1:17.0.6-5build1 [25.0 MB] 130s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libxslt1.1 arm64 1.1.35-1 [161 kB] 130s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-16 arm64 16.2-1 [15.2 MB] 131s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql all 16+257 [11.4 kB] 131s Preconfiguring packages ... 131s Fetched 42.4 MB in 2s (24.0 MB/s) 131s Selecting previously unselected package libpq5:arm64. 131s (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 ... 74304 files and directories currently installed.) 131s Preparing to unpack .../00-libpq5_16.2-1_arm64.deb ... 131s Unpacking libpq5:arm64 (16.2-1) ... 131s Selecting previously unselected package postgresql-client-common. 131s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 131s Unpacking postgresql-client-common (257) ... 131s Selecting previously unselected package postgresql-client-16. 131s Preparing to unpack .../02-postgresql-client-16_16.2-1_arm64.deb ... 131s Unpacking postgresql-client-16 (16.2-1) ... 131s Selecting previously unselected package postgresql-client. 131s Preparing to unpack .../03-postgresql-client_16+257_all.deb ... 131s Unpacking postgresql-client (16+257) ... 131s Selecting previously unselected package pgcopydb. 131s Preparing to unpack .../04-pgcopydb_0.15-1_arm64.deb ... 131s Unpacking pgcopydb (0.15-1) ... 131s Selecting previously unselected package libjson-perl. 131s Preparing to unpack .../05-libjson-perl_4.10000-1_all.deb ... 131s Unpacking libjson-perl (4.10000-1) ... 132s Selecting previously unselected package ssl-cert. 132s Preparing to unpack .../06-ssl-cert_1.1.2ubuntu1_all.deb ... 132s Unpacking ssl-cert (1.1.2ubuntu1) ... 132s Selecting previously unselected package postgresql-common. 132s Preparing to unpack .../07-postgresql-common_257_all.deb ... 132s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 132s Unpacking postgresql-common (257) ... 132s Selecting previously unselected package libllvm17:arm64. 132s Preparing to unpack .../08-libllvm17_1%3a17.0.6-5build1_arm64.deb ... 132s Unpacking libllvm17:arm64 (1:17.0.6-5build1) ... 132s Selecting previously unselected package libxslt1.1:arm64. 132s Preparing to unpack .../09-libxslt1.1_1.1.35-1_arm64.deb ... 132s Unpacking libxslt1.1:arm64 (1.1.35-1) ... 132s Selecting previously unselected package postgresql-16. 132s Preparing to unpack .../10-postgresql-16_16.2-1_arm64.deb ... 132s Unpacking postgresql-16 (16.2-1) ... 133s Selecting previously unselected package postgresql. 133s Preparing to unpack .../11-postgresql_16+257_all.deb ... 133s Unpacking postgresql (16+257) ... 133s Setting up postgresql-client-common (257) ... 133s Setting up libpq5:arm64 (16.2-1) ... 133s Setting up ssl-cert (1.1.2ubuntu1) ... 134s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 134s Setting up libjson-perl (4.10000-1) ... 134s Setting up libxslt1.1:arm64 (1.1.35-1) ... 134s Setting up libllvm17:arm64 (1:17.0.6-5build1) ... 134s Setting up postgresql-client-16 (16.2-1) ... 135s 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 135s Setting up postgresql-common (257) ... 135s 135s Creating config file /etc/postgresql-common/createcluster.conf with new version 136s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 136s Removing obsolete dictionary files: 136s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 137s Setting up pgcopydb (0.15-1) ... 137s Setting up postgresql-client (16+257) ... 137s Setting up postgresql-16 (16.2-1) ... 137s Creating new PostgreSQL cluster 16/main ... 137s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 137s The files belonging to this database system will be owned by user "postgres". 137s This user must also own the server process. 137s 137s The database cluster will be initialized with locale "C.UTF-8". 137s The default database encoding has accordingly been set to "UTF8". 137s The default text search configuration will be set to "english". 137s 137s Data page checksums are disabled. 137s 137s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 137s creating subdirectories ... ok 137s selecting dynamic shared memory implementation ... posix 137s selecting default max_connections ... 100 137s selecting default shared_buffers ... 128MB 137s selecting default time zone ... Etc/UTC 137s creating configuration files ... ok 137s running bootstrap script ... ok 138s performing post-bootstrap initialization ... ok 138s syncing data to disk ... ok 141s Setting up postgresql (16+257) ... 141s Setting up autopkgtest-satdep (0) ... 141s Processing triggers for man-db (2.12.0-3) ... 143s Processing triggers for libc-bin (2.39-0ubuntu2) ... 146s (Reading database ... 76268 files and directories currently installed.) 146s Removing autopkgtest-satdep (0) ... 147s autopkgtest [13:57:30]: test copydb: [----------------------- 147s + WORKDIR=/tmp/autopkgtest.v4CujW/build.nfh/src/debian/home 147s + pg_virtualenv 147s Creating new PostgreSQL cluster 16/regress ... 150s + createdb src 150s + createdb dst 150s + psql -c 'create table foo as select 123+456' src 151s SELECT 1 151s + rm -rf /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home 151s + HOME=/tmp/autopkgtest.v4CujW/build.nfh/src/debian/home 151s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home 151s 2024-03-10 13:57:33.960 3254 INFO main.c:129 Running pgcopydb version 0.15-1 from "/usr/bin/pgcopydb" 151s 2024-03-10 13:57:33.962 3254 INFO cli_common.c:1312 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 151s 2024-03-10 13:57:33.962 3254 INFO cli_common.c:1313 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 151s 2024-03-10 13:57:33.979 3254 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.v4CujW/build.nfh/src/debian/home" 151s 2024-03-10 13:57:34.005 3254 INFO snapshot.c:100 Exported snapshot "00000003-00000010-1" from the source database 151s 2024-03-10 13:57:34.008 3258 INFO cli_clone_follow.c:518 STEP 1: fetch source database tables, indexes, and sequences 151s 2024-03-10 13:57:34.543 3258 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 151s 2024-03-10 13:57:34.553 3258 INFO copydb_schema.c:831 Fetched information for 0 indexes (supporting 0 constraints) 151s 2024-03-10 13:57:34.555 3258 INFO sequences.c:64 Fetching information for 0 sequences 151s 2024-03-10 13:57:34.567 3258 INFO copydb_schema.c:929 Fetched information for 1 extensions 151s 2024-03-10 13:57:34.704 3258 INFO copydb_schema.c:1300 Found 0 indexes (supporting 0 constraints) in the target database 151s 2024-03-10 13:57:34.721 3258 INFO cli_clone_follow.c:559 STEP 2: dump the source database schema (pre/post data) 151s 2024-03-10 13:57:34.724 3258 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section pre-data --file /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home/schema/pre.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 151s 2024-03-10 13:57:34.793 3258 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section post-data --file /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home/schema/post.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 152s 2024-03-10 13:57:35.112 3258 INFO cli_clone_follow.c:569 STEP 3: restore the pre-data section to the target database 152s 2024-03-10 13:57:35.157 3258 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.v4CujW/build.nfh/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home/schema/pre.dump 152s 2024-03-10 13:57:35.239 3279 INFO table-data.c:649 STEP 4: starting 4 table-data COPY processes 152s 2024-03-10 13:57:35.269 3281 INFO vacuum.c:142 STEP 8: starting 4 VACUUM processes 152s 2024-03-10 13:57:35.279 3280 INFO indexes.c:157 STEP 6: starting 4 CREATE INDEX processes 152s 2024-03-10 13:57:35.279 3280 INFO indexes.c:158 STEP 7: constraints are built by the CREATE INDEX processes 152s 2024-03-10 13:57:35.287 3258 INFO blobs.c:74 Skipping large objects: none found. 152s 2024-03-10 13:57:35.317 3258 INFO sequences.c:155 STEP 9: reset sequences values 152s 2024-03-10 13:57:35.349 3307 INFO sequences.c:245 Reset sequences values on the target database 152s 2024-03-10 13:57:35.650 3258 INFO cli_clone_follow.c:585 STEP 10: restore the post-data section to the target database 152s 2024-03-10 13:57:35.699 3258 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.v4CujW/build.nfh/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.v4CujW/build.nfh/src/debian/home/schema/post.dump 152s 2024-03-10 13:57:35.802 3258 INFO cli_clone_follow.c:616 All step are now done, 1s792 elapsed 152s 2024-03-10 13:57:35.803 3258 INFO summary.c:3161 Printing summary for 1 tables and 0 indexes 152s 152s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 152s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 152s 16386 | public | foo | 1 | 18ms | 4 B | 0 | 0ms 152s 152s 152s Step Connection Duration Transfer Concurrency 152s -------------------------------------------------- ---------- ---------- ---------- ------------ 152s Catalog Queries (table ordering, filtering, etc) source 213ms 1 152s Dump Schema source 358ms 1 152s Prepare Schema target 113ms 1 152s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 386ms 12 152s COPY (cumulative) both 18ms 8192 B 4 152s CREATE INDEX (cumulative) target 0ms 4 152s CONSTRAINTS (cumulative) target 0ms 4 152s VACUUM (cumulative) target 17ms 4 152s Reset Sequences both 99ms 1 152s Large Objects (cumulative) (null) 0ms 0 152s Finalize Schema both 144ms 4 152s -------------------------------------------------- ---------- ---------- ---------- ------------ 152s Total Wall Clock Duration both 1s792 20 152s 153s + pg_dump -t foo dst 153s -- 153s -- PostgreSQL database dump 153s -- 153s 153s -- Dumped from database version 16.2 (Ubuntu 16.2-1) 153s -- Dumped by pg_dump version 16.2 (Ubuntu 16.2-1) 153s 153s SET statement_timeout = 0; 153s SET lock_timeout = 0; 153s SET idle_in_transaction_session_timeout = 0; 153s SET client_encoding = 'UTF8'; 153s SET standard_conforming_strings = on; 153s SELECT pg_catalog.set_config('search_path', '', false); 153s SET check_function_bodies = false; 153s SET xmloption = content; 153s SET client_min_messages = warning; 153s SET row_security = off; 153s 153s SET default_tablespace = ''; 153s 153s SET default_table_access_method = heap; 153s 153s -- 153s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 153s -- 153s 153s CREATE TABLE public.foo ( 153s "?column?" integer 153s ); 153s 153s 153s ALTER TABLE public.foo OWNER TO ubuntu; 153s 153s -- 153s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 153s -- 153s 153s COPY public.foo ("?column?") FROM stdin; 153s 579 153s \. 153s 153s 153s -- 153s -- PostgreSQL database dump complete 153s -- 153s 153s + pg_dump -t foo dst 153s + grep 579 153s 579 153s Dropping cluster 16/regress ... 153s autopkgtest [13:57:36]: test copydb: -----------------------] 154s autopkgtest [13:57:37]: test copydb: - - - - - - - - - - results - - - - - - - - - - 154s copydb PASS 154s autopkgtest [13:57:37]: @@@@@@@@@@@@@@@@@@@@ summary 154s copydb PASS 166s Creating nova instance adt-noble-arm64-pgcopydb-20240310-135503-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-arm64-server-20240308.img (UUID ddbc0ee7-bb97-4aa3-b5e1-9386758c2ba2)...