0s autopkgtest [07:01:08]: starting date and time: 2025-02-22 07:01:08+0000 0s autopkgtest [07:01:08]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:01:08]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.7q9qmwxp/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgcopydb --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-10.secgroup --name adt-plucky-ppc64el-pgcopydb-20250222-070108-juju-7f2275-prod-proposed-migration-environment-2-e9561170-5c9d-4a8c-804a-c1b453d2d84c --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-ppc64el -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/ 78s autopkgtest [07:02:26]: testbed dpkg architecture: ppc64el 78s autopkgtest [07:02:26]: testbed apt version: 2.9.30ubuntu1 78s autopkgtest [07:02:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 78s autopkgtest [07:02:26]: testbed release detected to be: None 79s autopkgtest [07:02:27]: updating testbed package index (apt update) 79s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 80s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 80s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 80s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 80s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 80s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 80s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 80s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 80s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 80s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 80s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 80s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 80s Fetched 1276 kB in 1s (1422 kB/s) 81s Reading package lists... 82s Reading package lists... 82s Building dependency tree... 82s Reading state information... 82s Calculating upgrade... 82s Calculating upgrade... 83s The following packages will be upgraded: 83s curl libcurl3t64-gnutls libcurl4t64 83s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s Need to get 1221 kB of archives. 83s After this operation, 3072 B disk space will be freed. 83s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 83s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 83s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 84s Fetched 1221 kB in 1s (1933 kB/s) 84s (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 ... 106371 files and directories currently installed.) 84s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 84s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 84s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 84s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 84s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 84s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 84s Setting up curl (8.12.1-2ubuntu1) ... 84s Processing triggers for man-db (2.13.0-1) ... 84s Processing triggers for libc-bin (2.40-4ubuntu1) ... 85s Reading package lists... 85s Building dependency tree... 85s Reading state information... 85s Solving dependencies... 85s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 85s autopkgtest [07:02:33]: upgrading testbed (apt dist-upgrade and autopurge) 85s Reading package lists... 86s Building dependency tree... 86s Reading state information... 86s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 86s Starting 2 pkgProblemResolver with broken count: 0 86s Done 86s Entering ResolveByKeep 87s 87s Calculating upgrade... 87s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s Reading package lists... 87s Building dependency tree... 87s Reading state information... 87s Starting pkgProblemResolver with broken count: 0 87s Starting 2 pkgProblemResolver with broken count: 0 87s Done 88s Solving dependencies... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 90s autopkgtest [07:02:38]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 91s autopkgtest [07:02:39]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 93s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (dsc) [2145 B] 93s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (tar) [19.1 MB] 93s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (diff) [4148 B] 93s gpgv: Signature made Wed Aug 7 13:46:44 2024 UTC 93s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 93s gpgv: Can't check signature: No public key 93s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.17-1.dsc: no acceptable signature found 94s autopkgtest [07:02:42]: testing package pgcopydb version 0.17-1 94s autopkgtest [07:02:42]: build not needed 96s autopkgtest [07:02:44]: test copydb: preparing testbed 97s Reading package lists... 97s Building dependency tree... 97s Reading state information... 97s Starting pkgProblemResolver with broken count: 0 97s Starting 2 pkgProblemResolver with broken count: 0 97s Done 98s The following NEW packages will be installed: 98s libgc1 libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 98s libxslt1.1 pgcopydb postgresql postgresql-17 postgresql-client 98s postgresql-client-17 postgresql-client-common postgresql-common 98s postgresql-common-dev ssl-cert 98s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 98s Need to get 52.6 MB of archives. 98s After this operation, 225 MB of additional disk space will be used. 98s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 98s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 98s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 98s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 98s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 98s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 98s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 98s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 98s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 101s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 101s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 101s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 101s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client all 17+273 [13.2 kB] 101s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgcopydb ppc64el 0.17-1 [1039 kB] 101s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 102s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql all 17+273 [14.3 kB] 102s Preconfiguring packages ... 102s /var/cache/debconf/tmp.ci/postgresql.config.JhEflK: 12: pg_lsclusters: not found 102s Fetched 52.6 MB in 4s (12.3 MB/s) 102s Selecting previously unselected package libjson-perl. 102s (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 ... 106371 files and directories currently installed.) 102s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 102s Unpacking libjson-perl (4.10000-1) ... 102s Selecting previously unselected package postgresql-client-common. 102s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 102s Unpacking postgresql-client-common (273) ... 102s Selecting previously unselected package libio-pty-perl. 102s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 102s Unpacking libio-pty-perl (1:1.20-1build3) ... 102s Selecting previously unselected package libipc-run-perl. 102s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 102s Unpacking libipc-run-perl (20231003.0-2) ... 102s Selecting previously unselected package postgresql-common-dev. 102s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 102s Unpacking postgresql-common-dev (273) ... 102s Selecting previously unselected package ssl-cert. 102s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 102s Unpacking ssl-cert (1.1.3ubuntu1) ... 102s Selecting previously unselected package postgresql-common. 102s Preparing to unpack .../06-postgresql-common_273_all.deb ... 102s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 102s Unpacking postgresql-common (273) ... 102s Selecting previously unselected package libgc1:ppc64el. 102s Preparing to unpack .../07-libgc1_1%3a8.2.8-1_ppc64el.deb ... 102s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 102s Selecting previously unselected package libllvm20:ppc64el. 102s Preparing to unpack .../08-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 102s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 103s Selecting previously unselected package libpq5:ppc64el. 103s Preparing to unpack .../09-libpq5_17.4-1_ppc64el.deb ... 103s Unpacking libpq5:ppc64el (17.4-1) ... 103s Selecting previously unselected package libxslt1.1:ppc64el. 103s Preparing to unpack .../10-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 103s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 103s Selecting previously unselected package postgresql-client-17. 103s Preparing to unpack .../11-postgresql-client-17_17.4-1_ppc64el.deb ... 103s Unpacking postgresql-client-17 (17.4-1) ... 103s Selecting previously unselected package postgresql-client. 103s Preparing to unpack .../12-postgresql-client_17+273_all.deb ... 103s Unpacking postgresql-client (17+273) ... 103s Selecting previously unselected package pgcopydb. 103s Preparing to unpack .../13-pgcopydb_0.17-1_ppc64el.deb ... 103s Unpacking pgcopydb (0.17-1) ... 103s Selecting previously unselected package postgresql-17. 103s Preparing to unpack .../14-postgresql-17_17.4-1_ppc64el.deb ... 103s Unpacking postgresql-17 (17.4-1) ... 104s Selecting previously unselected package postgresql. 104s Preparing to unpack .../15-postgresql_17+273_all.deb ... 104s Unpacking postgresql (17+273) ... 104s Setting up postgresql-client-common (273) ... 104s Setting up libio-pty-perl (1:1.20-1build3) ... 104s Setting up libpq5:ppc64el (17.4-1) ... 104s Setting up ssl-cert (1.1.3ubuntu1) ... 104s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 105s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 105s Setting up libipc-run-perl (20231003.0-2) ... 105s Setting up libgc1:ppc64el (1:8.2.8-1) ... 105s Setting up libjson-perl (4.10000-1) ... 105s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 105s Setting up postgresql-common-dev (273) ... 105s Setting up postgresql-client-17 (17.4-1) ... 105s 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 105s Setting up postgresql-common (273) ... 105s Creating config file /etc/postgresql-common/createcluster.conf with new version 105s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 105s Removing obsolete dictionary files: 106s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 107s Setting up pgcopydb (0.17-1) ... 107s Setting up postgresql-17 (17.4-1) ... 107s Creating new PostgreSQL cluster 17/main ... 107s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 107s The files belonging to this database system will be owned by user "postgres". 107s This user must also own the server process. 107s 107s The database cluster will be initialized with locale "C.UTF-8". 107s The default database encoding has accordingly been set to "UTF8". 107s The default text search configuration will be set to "english". 107s 107s Data page checksums are disabled. 107s 107s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 107s creating subdirectories ... ok 107s selecting dynamic shared memory implementation ... posix 107s selecting default "max_connections" ... 100 107s selecting default "shared_buffers" ... 128MB 108s selecting default time zone ... Etc/UTC 108s creating configuration files ... ok 108s running bootstrap script ... ok 108s performing post-bootstrap initialization ... ok 108s syncing data to disk ... ok 111s Setting up postgresql-client (17+273) ... 111s Setting up postgresql (17+273) ... 111s Processing triggers for man-db (2.13.0-1) ... 113s Processing triggers for libc-bin (2.40-4ubuntu1) ... 114s autopkgtest [07:03:02]: test copydb: [----------------------- 114s + WORKDIR=/tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home 114s + pg_virtualenv 114s Creating new PostgreSQL cluster 17/regress ... 117s + createdb src 117s + createdb dst 117s + psql -c 'create table foo as select 123+456' src 117s SELECT 1 117s + rm -rf /tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home 117s + HOME=/tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home 117s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home 117s 2025-02-22 07:03:05.943 4102 INFO main.c:136 Running pgcopydb version 0.17-1 from "/usr/bin/pgcopydb" 117s 2025-02-22 07:03:05.944 4102 INFO cli_common.c:1225 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 117s 2025-02-22 07:03:05.944 4102 INFO cli_common.c:1226 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 117s 2025-02-22 07:03:05.948 4102 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home" 118s 2025-02-22 07:03:05.983 4102 INFO snapshot.c:107 Exported snapshot "00000007-00000002-1" from the source database 118s 2025-02-22 07:03:05.985 4107 INFO cli_clone_follow.c:543 STEP 1: fetch source database tables, indexes, and sequences 118s 2025-02-22 07:03:06.186 4107 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 118s 2025-02-22 07:03:06.190 4107 INFO copydb_schema.c:968 Fetched information for 0 indexes (supporting 0 constraints) 118s 2025-02-22 07:03:06.191 4107 INFO sequences.c:78 Fetching information for 0 sequences 118s 2025-02-22 07:03:06.198 4107 INFO copydb_schema.c:1122 Fetched information for 1 extensions 118s 2025-02-22 07:03:06.249 4107 INFO copydb_schema.c:1538 Found 0 indexes (supporting 0 constraints) in the target database 118s 2025-02-22 07:03:06.252 4107 INFO cli_clone_follow.c:584 STEP 2: dump the source database schema (pre/post data) 118s 2025-02-22 07:03:06.254 4107 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.1NVNzz/build.yOu/src/debian/home/schema/schema.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 118s 2025-02-22 07:03:06.325 4107 INFO cli_clone_follow.c:592 STEP 3: restore the pre-data section to the target database 118s 2025-02-22 07:03:06.344 4107 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.1NVNzz/build.yOu/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home/schema/schema.dump 118s 2025-02-22 07:03:06.429 4126 INFO table-data.c:656 STEP 4: starting 4 table-data COPY processes 118s 2025-02-22 07:03:06.445 4128 INFO vacuum.c:143 STEP 8: starting 4 VACUUM processes 118s 2025-02-22 07:03:06.451 4127 INFO indexes.c:182 STEP 6: starting 4 CREATE INDEX processes 118s 2025-02-22 07:03:06.451 4127 INFO indexes.c:183 STEP 7: constraints are built by the CREATE INDEX processes 118s 2025-02-22 07:03:06.516 4107 INFO blobs.c:74 Skipping large objects: none found. 118s 2025-02-22 07:03:06.520 4107 INFO sequences.c:194 STEP 9: reset sequences values 118s 2025-02-22 07:03:06.526 4157 INFO sequences.c:290 Set sequences values on the target database 118s 2025-02-22 07:03:06.926 4107 INFO cli_clone_follow.c:608 STEP 10: restore the post-data section to the target database 118s 2025-02-22 07:03:06.933 4107 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.1NVNzz/build.yOu/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.1NVNzz/build.yOu/src/debian/home/schema/schema.dump 119s 2025-02-22 07:03:07.022 4107 INFO cli_clone_follow.c:639 All step are now done, 769ms elapsed 119s 2025-02-22 07:03:07.023 4107 INFO summary.c:3173 Printing summary for 1 tables and 0 indexes 119s 119s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 119s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 119s 16386 | public | foo | 1 | 7ms | 4 B | 0 | 0ms 119s 119s 119s Step Connection Duration Transfer Concurrency 119s -------------------------------------------------- ---------- ---------- ---------- ------------ 119s Catalog Queries (table ordering, filtering, etc) source 105ms 1 119s Dump Schema source 72ms 1 119s Prepare Schema target 88ms 1 119s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 506ms 12 119s COPY (cumulative) both 7ms 8192 B 4 119s CREATE INDEX (cumulative) target 0ms 4 119s CONSTRAINTS (cumulative) target 0ms 4 119s VACUUM (cumulative) target 60ms 4 119s Reset Sequences both 54ms 1 119s Large Objects (cumulative) (null) 0ms 0 119s Finalize Schema both 92ms 4 119s -------------------------------------------------- ---------- ---------- ---------- ------------ 119s Total Wall Clock Duration both 769ms 20 119s 119s + pg_dump -t foo dst 119s -- 119s -- PostgreSQL database dump 119s -- 119s 119s -- Dumped from database version 17.4 (Ubuntu 17.4-1) 119s -- Dumped by pg_dump version 17.4 (Ubuntu 17.4-1) 119s 119s SET statement_timeout = 0; 119s SET lock_timeout = 0; 119s SET idle_in_transaction_session_timeout = 0; 119s SET transaction_timeout = 0; 119s SET client_encoding = 'UTF8'; 119s SET standard_conforming_strings = on; 119s SELECT pg_catalog.set_config('search_path', '', false); 119s SET check_function_bodies = false; 119s SET xmloption = content; 119s SET client_min_messages = warning; 119s SET row_security = off; 119s 119s SET default_tablespace = ''; 119s 119s SET default_table_access_method = heap; 119s 119s -- 119s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 119s -- 119s 119s CREATE TABLE public.foo ( 119s "?column?" integer 119s ); 119s 119s 119s ALTER TABLE public.foo OWNER TO ubuntu; 119s 119s -- 119s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 119s -- 119s 119s COPY public.foo ("?column?") FROM stdin; 119s 579 119s \. 119s 119s 119s -- 119s -- PostgreSQL database dump complete 119s -- 119s 119s + pg_dump -t foo dst 119s + grep 579 119s 579 119s Dropping cluster 17/regress ... 120s autopkgtest [07:03:08]: test copydb: -----------------------] 120s autopkgtest [07:03:08]: test copydb: - - - - - - - - - - results - - - - - - - - - - 120s copydb PASS 120s autopkgtest [07:03:08]: @@@@@@@@@@@@@@@@@@@@ summary 120s copydb PASS 126s nova [W] Using flock in prodstack6-ppc64el 126s Creating nova instance adt-plucky-ppc64el-pgcopydb-20250222-070108-juju-7f2275-prod-proposed-migration-environment-2-e9561170-5c9d-4a8c-804a-c1b453d2d84c from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 126s nova [W] Timed out waiting for 7ba17750-c437-4d34-9ae2-6cb6697d257a to get deleted.