0s autopkgtest [15:13:56]: starting date and time: 2025-03-15 15:13:56+0000 0s autopkgtest [15:13:56]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [15:13:56]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.s55mb7oj/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_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\n" >> /etc/environment' --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 -- lxd -r lxd-armhf-10.145.243.171 lxd-armhf-10.145.243.171:autopkgtest/ubuntu/plucky/armhf 22s autopkgtest [15:14:18]: testbed dpkg architecture: armhf 24s autopkgtest [15:14:20]: testbed apt version: 2.9.33 28s autopkgtest [15:14:24]: @@@@@@@@@@@@@@@@@@@@ test bed setup 30s autopkgtest [15:14:26]: testbed release detected to be: None 39s autopkgtest [15:14:35]: updating testbed package index (apt update) 40s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 41s Get:2 http://ftpmaster.internal/ubuntu plucky InRelease [257 kB] 41s Get:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease [126 kB] 41s Get:4 http://ftpmaster.internal/ubuntu plucky-security InRelease [126 kB] 41s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 41s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 42s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 42s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf Packages [81.0 kB] 42s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf c-n-f Metadata [1944 B] 42s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted armhf c-n-f Metadata [116 B] 42s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe armhf Packages [326 kB] 42s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe armhf c-n-f Metadata [12.1 kB] 42s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse armhf Packages [3472 B] 42s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse armhf c-n-f Metadata [332 B] 42s Get:15 http://ftpmaster.internal/ubuntu plucky/universe Sources [21.0 MB] 60s Get:16 http://ftpmaster.internal/ubuntu plucky/main Sources [1400 kB] 61s Get:17 http://ftpmaster.internal/ubuntu plucky/multiverse Sources [299 kB] 62s Get:18 http://ftpmaster.internal/ubuntu plucky/main armhf Packages [1378 kB] 63s Get:19 http://ftpmaster.internal/ubuntu plucky/main armhf c-n-f Metadata [29.4 kB] 63s Get:20 http://ftpmaster.internal/ubuntu plucky/restricted armhf c-n-f Metadata [108 B] 63s Get:21 http://ftpmaster.internal/ubuntu plucky/universe armhf Packages [15.1 MB] 78s Get:22 http://ftpmaster.internal/ubuntu plucky/multiverse armhf Packages [172 kB] 79s Fetched 41.0 MB in 39s (1057 kB/s) 80s Reading package lists... 86s autopkgtest [15:15:22]: upgrading testbed (apt dist-upgrade and autopurge) 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 89s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 90s Entering ResolveByKeep 90s 91s Calculating upgrade... 91s The following packages will be upgraded: 91s libc-bin libc6 locales python3-jinja2 sos strace 92s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s Need to get 8642 kB of archives. 92s After this operation, 23.6 kB of additional disk space will be used. 92s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf libc6 armhf 2.41-1ubuntu2 [2932 kB] 95s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf libc-bin armhf 2.41-1ubuntu2 [545 kB] 95s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf locales all 2.41-1ubuntu2 [4246 kB] 99s Get:4 http://ftpmaster.internal/ubuntu plucky/main armhf strace armhf 6.13+ds-1ubuntu1 [445 kB] 100s Get:5 http://ftpmaster.internal/ubuntu plucky/main armhf python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 100s Get:6 http://ftpmaster.internal/ubuntu plucky/main armhf sos all 4.9.0-5 [365 kB] 101s Preconfiguring packages ... 101s Fetched 8642 kB in 9s (958 kB/s) 101s (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 ... 64655 files and directories currently installed.) 101s Preparing to unpack .../libc6_2.41-1ubuntu2_armhf.deb ... 101s Unpacking libc6:armhf (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 101s Setting up libc6:armhf (2.41-1ubuntu2) ... 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 ... 64655 files and directories currently installed.) 102s Preparing to unpack .../libc-bin_2.41-1ubuntu2_armhf.deb ... 102s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 102s Setting up libc-bin (2.41-1ubuntu2) ... 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 ... 64655 files and directories currently installed.) 102s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 102s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 102s Preparing to unpack .../strace_6.13+ds-1ubuntu1_armhf.deb ... 102s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 102s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 102s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 102s Preparing to unpack .../archives/sos_4.9.0-5_all.deb ... 103s Unpacking sos (4.9.0-5) over (4.9.0-4) ... 103s Setting up sos (4.9.0-5) ... 103s Setting up locales (2.41-1ubuntu2) ... 104s Generating locales (this might take a while)... 107s en_US.UTF-8... done 107s Generation complete. 107s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 107s Setting up strace (6.13+ds-1ubuntu1) ... 107s Processing triggers for man-db (2.13.0-1) ... 108s Processing triggers for systemd (257.3-1ubuntu3) ... 110s Reading package lists... 111s Building dependency tree... 111s Reading state information... 111s Starting pkgProblemResolver with broken count: 0 111s Starting 2 pkgProblemResolver with broken count: 0 111s Done 112s Solving dependencies... 112s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 114s autopkgtest [15:15:50]: rebooting testbed after setup commands that affected boot 156s autopkgtest [15:16:32]: testbed running kernel: Linux 6.8.0-52-generic #53~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Jan 15 18:10:51 UTC 2 181s autopkgtest [15:16:57]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 206s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (dsc) [2145 B] 206s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (tar) [19.1 MB] 206s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgcopydb 0.17-1 (diff) [4148 B] 206s gpgv: Signature made Wed Aug 7 13:46:44 2024 UTC 206s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 206s gpgv: Can't check signature: No public key 206s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.17-1.dsc: no acceptable signature found 206s autopkgtest [15:17:22]: testing package pgcopydb version 0.17-1 210s autopkgtest [15:17:26]: build not needed 217s autopkgtest [15:17:33]: test copydb: preparing testbed 219s Reading package lists... 219s Building dependency tree... 219s Reading state information... 220s Starting pkgProblemResolver with broken count: 0 220s Starting 2 pkgProblemResolver with broken count: 0 220s Done 221s The following NEW packages will be installed: 221s libgc1 libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 221s libxslt1.1 pgcopydb postgresql postgresql-17 postgresql-client 221s postgresql-client-17 postgresql-client-common postgresql-common 221s postgresql-common-dev ssl-cert 221s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 221s Need to get 47.3 MB of archives. 221s After this operation, 184 MB of additional disk space will be used. 221s Get:1 http://ftpmaster.internal/ubuntu plucky/main armhf libjson-perl all 4.10000-1 [81.9 kB] 221s Get:2 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-common all 274 [47.6 kB] 221s Get:3 http://ftpmaster.internal/ubuntu plucky/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 221s Get:4 http://ftpmaster.internal/ubuntu plucky/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 221s Get:5 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common-dev all 274 [73.0 kB] 221s Get:6 http://ftpmaster.internal/ubuntu plucky/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 221s Get:7 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common all 274 [101 kB] 222s Get:8 http://ftpmaster.internal/ubuntu plucky/main armhf libgc1 armhf 1:8.2.8-1 [81.2 kB] 222s Get:9 http://ftpmaster.internal/ubuntu plucky/main armhf libllvm20 armhf 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.6 MB] 242s Get:10 http://ftpmaster.internal/ubuntu plucky/main armhf libpq5 armhf 17.4-1 [125 kB] 242s Get:11 http://ftpmaster.internal/ubuntu plucky/main armhf libxslt1.1 armhf 1.1.39-0exp1ubuntu2 [152 kB] 243s Get:12 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-17 armhf 17.4-1 [1285 kB] 243s Get:13 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client all 17+274 [13.3 kB] 243s Get:14 http://ftpmaster.internal/ubuntu plucky/universe armhf pgcopydb armhf 0.17-1 [733 kB] 244s Get:15 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-17 armhf 17.4-1 [14.8 MB] 249s Get:16 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql all 17+274 [14.4 kB] 249s Preconfiguring packages ... 249s /var/cache/debconf/tmp.ci/postgresql.config.dNPSa2: 12: pg_lsclusters: not found 249s Fetched 47.3 MB in 28s (1701 kB/s) 249s Selecting previously unselected package libjson-perl. 249s (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 ... 64655 files and directories currently installed.) 249s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 249s Unpacking libjson-perl (4.10000-1) ... 249s Selecting previously unselected package postgresql-client-common. 249s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 249s Unpacking postgresql-client-common (274) ... 249s Selecting previously unselected package libio-pty-perl. 249s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 249s Unpacking libio-pty-perl (1:1.20-1build3) ... 249s Selecting previously unselected package libipc-run-perl. 249s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 249s Unpacking libipc-run-perl (20231003.0-2) ... 249s Selecting previously unselected package postgresql-common-dev. 249s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 249s Unpacking postgresql-common-dev (274) ... 249s Selecting previously unselected package ssl-cert. 250s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 250s Unpacking ssl-cert (1.1.3ubuntu1) ... 250s Selecting previously unselected package postgresql-common. 250s Preparing to unpack .../06-postgresql-common_274_all.deb ... 250s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 250s Unpacking postgresql-common (274) ... 250s Selecting previously unselected package libgc1:armhf. 250s Preparing to unpack .../07-libgc1_1%3a8.2.8-1_armhf.deb ... 250s Unpacking libgc1:armhf (1:8.2.8-1) ... 250s Selecting previously unselected package libllvm20:armhf. 250s Preparing to unpack .../08-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_armhf.deb ... 250s Unpacking libllvm20:armhf (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 251s Selecting previously unselected package libpq5:armhf. 251s Preparing to unpack .../09-libpq5_17.4-1_armhf.deb ... 251s Unpacking libpq5:armhf (17.4-1) ... 251s Selecting previously unselected package libxslt1.1:armhf. 251s Preparing to unpack .../10-libxslt1.1_1.1.39-0exp1ubuntu2_armhf.deb ... 251s Unpacking libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 251s Selecting previously unselected package postgresql-client-17. 251s Preparing to unpack .../11-postgresql-client-17_17.4-1_armhf.deb ... 251s Unpacking postgresql-client-17 (17.4-1) ... 251s Selecting previously unselected package postgresql-client. 251s Preparing to unpack .../12-postgresql-client_17+274_all.deb ... 251s Unpacking postgresql-client (17+274) ... 251s Selecting previously unselected package pgcopydb. 251s Preparing to unpack .../13-pgcopydb_0.17-1_armhf.deb ... 251s Unpacking pgcopydb (0.17-1) ... 251s Selecting previously unselected package postgresql-17. 251s Preparing to unpack .../14-postgresql-17_17.4-1_armhf.deb ... 251s Unpacking postgresql-17 (17.4-1) ... 251s Selecting previously unselected package postgresql. 252s Preparing to unpack .../15-postgresql_17+274_all.deb ... 252s Unpacking postgresql (17+274) ... 252s Setting up postgresql-client-common (274) ... 252s Setting up libio-pty-perl (1:1.20-1build3) ... 252s Setting up libpq5:armhf (17.4-1) ... 252s Setting up ssl-cert (1.1.3ubuntu1) ... 252s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 253s Setting up libllvm20:armhf (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 253s Setting up libipc-run-perl (20231003.0-2) ... 253s Setting up libgc1:armhf (1:8.2.8-1) ... 253s Setting up libjson-perl (4.10000-1) ... 253s Setting up libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 253s Setting up postgresql-common-dev (274) ... 253s Setting up postgresql-client-17 (17.4-1) ... 253s 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 254s Setting up postgresql-common (274) ... 254s Creating config file /etc/postgresql-common/createcluster.conf with new version 254s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 254s Removing obsolete dictionary files: 255s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 255s Setting up pgcopydb (0.17-1) ... 255s Setting up postgresql-17 (17.4-1) ... 257s Creating new PostgreSQL cluster 17/main ... 257s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 257s The files belonging to this database system will be owned by user "postgres". 257s This user must also own the server process. 257s 257s The database cluster will be initialized with locale "C.UTF-8". 257s The default database encoding has accordingly been set to "UTF8". 257s The default text search configuration will be set to "english". 257s 257s Data page checksums are disabled. 257s 257s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 257s creating subdirectories ... ok 257s selecting dynamic shared memory implementation ... posix 257s selecting default "max_connections" ... 100 257s selecting default "shared_buffers" ... 128MB 257s selecting default time zone ... Etc/UTC 257s creating configuration files ... ok 257s running bootstrap script ... ok 257s performing post-bootstrap initialization ... ok 257s syncing data to disk ... ok 260s Setting up postgresql-client (17+274) ... 260s Setting up postgresql (17+274) ... 261s Processing triggers for man-db (2.13.0-1) ... 262s Processing triggers for libc-bin (2.41-1ubuntu2) ... 270s autopkgtest [15:18:26]: test copydb: [----------------------- 272s + WORKDIR=/tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home 272s + pg_virtualenv 272s Creating new PostgreSQL cluster 17/regress ... 275s + createdb src 276s + createdb dst 276s + psql -c 'create table foo as select 123+456' src 276s SELECT 1 276s + rm -rf /tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home 276s + HOME=/tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home 276s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home 276s 2025-03-15 15:18:32.143 3046 INFO main.c:136 Running pgcopydb version 0.17-1 from "/usr/bin/pgcopydb" 276s 2025-03-15 15:18:32.145 3046 INFO cli_common.c:1225 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 276s 2025-03-15 15:18:32.145 3046 INFO cli_common.c:1226 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 276s 2025-03-15 15:18:32.154 3046 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home" 276s 2025-03-15 15:18:32.184 3046 INFO snapshot.c:107 Exported snapshot "00000007-00000002-1" from the source database 276s 2025-03-15 15:18:32.186 3051 INFO cli_clone_follow.c:543 STEP 1: fetch source database tables, indexes, and sequences 276s 2025-03-15 15:18:32.522 3051 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 276s 2025-03-15 15:18:32.526 3051 INFO copydb_schema.c:968 Fetched information for 0 indexes (supporting 0 constraints) 276s 2025-03-15 15:18:32.528 3051 INFO sequences.c:78 Fetching information for 0 sequences 276s 2025-03-15 15:18:32.541 3051 INFO copydb_schema.c:1122 Fetched information for 1 extensions 276s 2025-03-15 15:18:32.626 3051 INFO copydb_schema.c:1538 Found 0 indexes (supporting 0 constraints) in the target database 276s 2025-03-15 15:18:32.631 3051 INFO cli_clone_follow.c:584 STEP 2: dump the source database schema (pre/post data) 276s 2025-03-15 15:18:32.634 3051 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.GNTxRT/build.WIy/src/debian/home/schema/schema.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 276s 2025-03-15 15:18:32.726 3051 INFO cli_clone_follow.c:592 STEP 3: restore the pre-data section to the target database 276s 2025-03-15 15:18:32.747 3051 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.GNTxRT/build.WIy/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home/schema/schema.dump 276s 2025-03-15 15:18:32.846 3070 INFO table-data.c:656 STEP 4: starting 4 table-data COPY processes 276s 2025-03-15 15:18:32.871 3072 INFO vacuum.c:143 STEP 8: starting 4 VACUUM processes 276s 2025-03-15 15:18:32.879 3051 INFO blobs.c:74 Skipping large objects: none found. 276s 2025-03-15 15:18:32.880 3071 INFO indexes.c:182 STEP 6: starting 4 CREATE INDEX processes 276s 2025-03-15 15:18:32.880 3071 INFO indexes.c:183 STEP 7: constraints are built by the CREATE INDEX processes 276s 2025-03-15 15:18:32.891 3051 INFO sequences.c:194 STEP 9: reset sequences values 276s 2025-03-15 15:18:32.893 3096 INFO sequences.c:290 Set sequences values on the target database 277s 2025-03-15 15:18:33.200 3051 INFO cli_clone_follow.c:608 STEP 10: restore the post-data section to the target database 277s 2025-03-15 15:18:33.215 3051 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.GNTxRT/build.WIy/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.GNTxRT/build.WIy/src/debian/home/schema/schema.dump 277s 2025-03-15 15:18:33.289 3051 INFO cli_clone_follow.c:639 All step are now done, 657ms elapsed 277s 2025-03-15 15:18:33.290 3051 INFO summary.c:3173 Printing summary for 1 tables and 0 indexes 277s 277s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 277s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 277s 16386 | public | foo | 1 | 12ms | 4 B | 0 | 0ms 277s 277s 277s Step Connection Duration Transfer Concurrency 277s -------------------------------------------------- ---------- ---------- ---------- ------------ 277s Catalog Queries (table ordering, filtering, etc) source 140ms 1 277s Dump Schema source 93ms 1 277s Prepare Schema target 94ms 1 277s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 367ms 12 277s COPY (cumulative) both 12ms 8192 B 4 277s CREATE INDEX (cumulative) target 0ms 4 277s CONSTRAINTS (cumulative) target 0ms 4 277s VACUUM (cumulative) target 14ms 4 277s Reset Sequences both 27ms 1 277s Large Objects (cumulative) (null) 0ms 0 277s Finalize Schema both 78ms 4 277s -------------------------------------------------- ---------- ---------- ---------- ------------ 277s Total Wall Clock Duration both 657ms 20 277s 277s + pg_dump -t foo dst 277s -- 277s -- PostgreSQL database dump 277s -- 277s 277s -- Dumped from database version 17.4 (Ubuntu 17.4-1) 277s -- Dumped by pg_dump version 17.4 (Ubuntu 17.4-1) 277s 277s SET statement_timeout = 0; 277s SET lock_timeout = 0; 277s SET idle_in_transaction_session_timeout = 0; 277s SET transaction_timeout = 0; 277s SET client_encoding = 'UTF8'; 277s SET standard_conforming_strings = on; 277s SELECT pg_catalog.set_config('search_path', '', false); 277s SET check_function_bodies = false; 277s SET xmloption = content; 277s SET client_min_messages = warning; 277s SET row_security = off; 277s 277s SET default_tablespace = ''; 277s 277s SET default_table_access_method = heap; 277s 277s -- 277s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 277s -- 277s 277s CREATE TABLE public.foo ( 277s "?column?" integer 277s ); 277s 277s 277s ALTER TABLE public.foo OWNER TO ubuntu; 277s 277s -- 277s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 277s -- 277s 277s COPY public.foo ("?column?") FROM stdin; 277s 579 277s \. 277s 277s 277s -- 277s -- PostgreSQL database dump complete 277s -- 277s 277s + pg_dump -t foo dst 277s + grep 579 277s 579 277s Dropping cluster 17/regress ... 278s autopkgtest [15:18:34]: test copydb: -----------------------] 283s autopkgtest [15:18:39]: test copydb: - - - - - - - - - - results - - - - - - - - - - 283s copydb PASS 287s autopkgtest [15:18:43]: @@@@@@@@@@@@@@@@@@@@ summary 287s copydb PASS