0s autopkgtest [13:32:51]: starting date: 2024-03-09 0s autopkgtest [13:32:51]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [13:32:51]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.323k6su4/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@bos01-s390x-8.secgroup --name adt-noble-s390x-pgcopydb-20240309-133250-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-s390x-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://us.ports.ubuntu.com/ubuntu-ports/ 222s autopkgtest [13:36:33]: @@@@@@@@@@@@@@@@@@@@ test bed setup 222s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 224s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2642 kB] 228s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 228s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [429 kB] 228s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [37.3 kB] 228s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main s390x Packages [558 kB] 229s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main s390x c-n-f Metadata [3032 B] 229s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x Packages [1372 B] 229s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x c-n-f Metadata [116 B] 229s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x Packages [2708 kB] 231s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x c-n-f Metadata [7292 B] 231s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x Packages [23.6 kB] 231s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x c-n-f Metadata [116 B] 233s Fetched 6531 kB in 9s (708 kB/s) 233s Reading package lists... 237s Reading package lists... 237s Building dependency tree... 237s Reading state information... 238s Calculating upgrade... 238s The following packages will be upgraded: 238s libsqlite3-0 readline-common 238s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 238s Need to get 804 kB of archives. 238s After this operation, 0 B of additional disk space will be used. 238s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main s390x libsqlite3-0 s390x 3.45.1-1ubuntu1 [747 kB] 238s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main s390x readline-common all 8.2-3.1 [56.4 kB] 239s Fetched 804 kB in 1s (1438 kB/s) 239s (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 ... 51693 files and directories currently installed.) 239s Preparing to unpack .../libsqlite3-0_3.45.1-1ubuntu1_s390x.deb ... 239s Unpacking libsqlite3-0:s390x (3.45.1-1ubuntu1) over (3.45.1-1) ... 239s Preparing to unpack .../readline-common_8.2-3.1_all.deb ... 239s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 239s Setting up libsqlite3-0:s390x (3.45.1-1ubuntu1) ... 239s Setting up readline-common (8.2-3.1) ... 239s Processing triggers for man-db (2.12.0-3) ... 239s Processing triggers for install-info (7.1-3) ... 240s Processing triggers for libc-bin (2.39-0ubuntu2) ... 240s Reading package lists... 241s Building dependency tree... 241s Reading state information... 241s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 241s Unknown architecture, assuming PC-style ttyS0 241s sh: Attempting to set up Debian/Ubuntu apt sources automatically 241s sh: Distribution appears to be Ubuntu 243s Reading package lists... 243s Building dependency tree... 243s Reading state information... 243s eatmydata is already the newest version (131-1). 243s dbus is already the newest version (1.14.10-4ubuntu1). 243s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 244s Reading package lists... 244s Building dependency tree... 244s Reading state information... 244s rng-tools-debian is already the newest version (2.4). 244s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 244s Reading package lists... 245s Building dependency tree... 245s Reading state information... 245s haveged is already the newest version (1.9.14-1ubuntu1). 245s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 245s Reading package lists... 246s Building dependency tree... 246s Reading state information... 246s The following packages will be REMOVED: 246s cloud-init* python3-configobj* python3-debconf* 246s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 246s After this operation, 3248 kB disk space will be freed. 247s (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 ... 51693 files and directories currently installed.) 247s Removing cloud-init (24.1-0ubuntu1) ... 247s Removing python3-configobj (5.0.8-3) ... 247s Removing python3-debconf (1.5.86) ... 247s Processing triggers for man-db (2.12.0-3) ... 248s (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 ... 51304 files and directories currently installed.) 248s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 249s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 249s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 249s Reading package lists... 250s Building dependency tree... 250s Reading state information... 250s linux-generic is already the newest version (6.8.0-11.11+1). 250s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 251s Get:1 http://ftpmaster.internal/ubuntu noble InRelease [255 kB] 251s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 251s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 251s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 252s Get:5 http://ftpmaster.internal/ubuntu noble/main Sources [1387 kB] 252s Get:6 http://ftpmaster.internal/ubuntu noble/universe Sources [20.0 MB] 254s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x Packages [1367 kB] 254s Get:8 http://ftpmaster.internal/ubuntu noble/universe s390x Packages [14.7 MB] 255s Get:9 http://ftpmaster.internal/ubuntu noble/multiverse s390x Packages [167 kB] 262s Fetched 37.8 MB in 11s (3359 kB/s) 263s Reading package lists... 264s Reading package lists... 264s Building dependency tree... 264s Reading state information... 264s Calculating upgrade... 265s The following package was automatically installed and is no longer required: 265s ubuntu-advantage-tools 265s Use 'sudo apt autoremove' to remove it. 265s The following NEW packages will be installed: 265s libnuma1 libsensors-config libsensors5 numactl sysstat 265s The following packages will be upgraded: 265s ubuntu-minimal ubuntu-standard 265s 2 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 265s Need to get 582 kB of archives. 265s After this operation, 1711 kB of additional disk space will be used. 265s Get:1 http://ftpmaster.internal/ubuntu noble/main s390x ubuntu-minimal s390x 1.535 [10.5 kB] 265s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x libnuma1 s390x 2.0.18-1 [25.0 kB] 265s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x ubuntu-standard s390x 1.535 [10.5 kB] 265s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x libsensors-config all 1:3.6.0-9 [5458 B] 265s Get:5 http://ftpmaster.internal/ubuntu noble/main s390x libsensors5 s390x 1:3.6.0-9 [27.2 kB] 265s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x numactl s390x 2.0.18-1 [40.0 kB] 265s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x sysstat s390x 12.6.1-1ubuntu1 [463 kB] 266s Preconfiguring packages ... 266s Fetched 582 kB in 1s (1050 kB/s) 266s (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 ... 51247 files and directories currently installed.) 266s Preparing to unpack .../0-ubuntu-minimal_1.535_s390x.deb ... 266s Unpacking ubuntu-minimal (1.535) over (1.534) ... 266s Selecting previously unselected package libnuma1:s390x. 266s Preparing to unpack .../1-libnuma1_2.0.18-1_s390x.deb ... 266s Unpacking libnuma1:s390x (2.0.18-1) ... 266s Preparing to unpack .../2-ubuntu-standard_1.535_s390x.deb ... 266s Unpacking ubuntu-standard (1.535) over (1.534) ... 266s Selecting previously unselected package libsensors-config. 266s Preparing to unpack .../3-libsensors-config_1%3a3.6.0-9_all.deb ... 266s Unpacking libsensors-config (1:3.6.0-9) ... 266s Selecting previously unselected package libsensors5:s390x. 266s Preparing to unpack .../4-libsensors5_1%3a3.6.0-9_s390x.deb ... 266s Unpacking libsensors5:s390x (1:3.6.0-9) ... 266s Selecting previously unselected package numactl. 266s Preparing to unpack .../5-numactl_2.0.18-1_s390x.deb ... 266s Unpacking numactl (2.0.18-1) ... 266s Selecting previously unselected package sysstat. 266s Preparing to unpack .../6-sysstat_12.6.1-1ubuntu1_s390x.deb ... 266s Unpacking sysstat (12.6.1-1ubuntu1) ... 266s Setting up ubuntu-minimal (1.535) ... 266s Setting up libsensors-config (1:3.6.0-9) ... 266s Setting up ubuntu-standard (1.535) ... 266s Setting up libsensors5:s390x (1:3.6.0-9) ... 266s Setting up libnuma1:s390x (2.0.18-1) ... 266s Setting up sysstat (12.6.1-1ubuntu1) ... 267s 267s Creating config file /etc/default/sysstat with new version 267s update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode 267s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer. 268s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer. 268s Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service. 270s Setting up numactl (2.0.18-1) ... 270s Processing triggers for man-db (2.12.0-3) ... 271s Processing triggers for libc-bin (2.39-0ubuntu2) ... 272s Reading package lists... 272s Building dependency tree... 272s Reading state information... 272s The following packages will be REMOVED: 272s ubuntu-advantage-tools* 273s 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 273s After this operation, 71.7 kB disk space will be freed. 273s (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 ... 51340 files and directories currently installed.) 273s Removing ubuntu-advantage-tools (31.1) ... 273s (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 ... 51334 files and directories currently installed.) 273s Purging configuration files for ubuntu-advantage-tools (31.1) ... 274s autopkgtest [13:37:25]: rebooting testbed after setup commands that affected boot 298s autopkgtest [13:37:49]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Tue Feb 13 23:45:46 UTC 2024 299s autopkgtest [13:37:50]: testbed dpkg architecture: s390x 300s autopkgtest [13:37:51]: @@@@@@@@@@@@@@@@@@@@ apt-source pgcopydb 304s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (dsc) [2150 B] 304s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (tar) [16.3 MB] 304s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgcopydb 0.15-1 (diff) [4036 B] 304s gpgv: Signature made Wed Jan 10 15:06:56 2024 UTC 304s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 304s gpgv: Can't check signature: No public key 304s dpkg-source: warning: cannot verify inline signature for ./pgcopydb_0.15-1.dsc: no acceptable signature found 304s autopkgtest [13:37:55]: testing package pgcopydb version 0.15-1 304s autopkgtest [13:37:55]: build not needed 306s autopkgtest [13:37:57]: test copydb: preparing testbed 308s Reading package lists... 308s Building dependency tree... 308s Reading state information... 309s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 309s Starting 2 pkgProblemResolver with broken count: 0 309s Done 309s Done 309s Starting pkgProblemResolver with broken count: 0 309s Starting 2 pkgProblemResolver with broken count: 0 309s Done 310s The following additional packages will be installed: 310s libjson-perl libllvm17 libpq5 libxslt1.1 pgcopydb postgresql postgresql-16 310s postgresql-client postgresql-client-16 postgresql-client-common 310s postgresql-common ssl-cert 310s Suggested packages: 310s postgresql-doc postgresql-doc-16 310s Recommended packages: 310s libjson-xs-perl 310s The following NEW packages will be installed: 310s libjson-perl libllvm17 libpq5 libxslt1.1 pgcopydb postgresql postgresql-16 310s postgresql-client postgresql-client-16 postgresql-client-common 310s postgresql-common ssl-cert 310s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 310s 1 not fully installed or removed. 310s Need to get 50.1 MB of archives. 310s After this operation, 214 MB of additional disk space will be used. 310s Get:1 http://ftpmaster.internal/ubuntu noble/main s390x libpq5 s390x 16.2-1 [143 kB] 310s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-common all 257 [36.2 kB] 310s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-16 s390x 16.2-1 [1295 kB] 311s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client all 16+257 [11.4 kB] 311s Get:5 http://ftpmaster.internal/ubuntu noble/universe s390x pgcopydb s390x 0.15-1 [311 kB] 311s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x libjson-perl all 4.10000-1 [81.9 kB] 311s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 311s Get:8 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-common all 257 [162 kB] 311s Get:9 http://ftpmaster.internal/ubuntu noble/main s390x libllvm17 s390x 1:17.0.6-5build1 [31.2 MB] 312s Get:10 http://ftpmaster.internal/ubuntu noble/main s390x libxslt1.1 s390x 1.1.35-1 [157 kB] 312s Get:11 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-16 s390x 16.2-1 [16.7 MB] 313s Get:12 http://ftpmaster.internal/ubuntu noble/main s390x postgresql all 16+257 [11.4 kB] 314s Preconfiguring packages ... 314s Fetched 50.1 MB in 3s (16.0 MB/s) 314s Selecting previously unselected package libpq5:s390x. 314s (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 ... 51333 files and directories currently installed.) 314s Preparing to unpack .../00-libpq5_16.2-1_s390x.deb ... 314s Unpacking libpq5:s390x (16.2-1) ... 314s Selecting previously unselected package postgresql-client-common. 314s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 314s Unpacking postgresql-client-common (257) ... 314s Selecting previously unselected package postgresql-client-16. 314s Preparing to unpack .../02-postgresql-client-16_16.2-1_s390x.deb ... 314s Unpacking postgresql-client-16 (16.2-1) ... 314s Selecting previously unselected package postgresql-client. 314s Preparing to unpack .../03-postgresql-client_16+257_all.deb ... 314s Unpacking postgresql-client (16+257) ... 314s Selecting previously unselected package pgcopydb. 314s Preparing to unpack .../04-pgcopydb_0.15-1_s390x.deb ... 314s Unpacking pgcopydb (0.15-1) ... 314s Selecting previously unselected package libjson-perl. 314s Preparing to unpack .../05-libjson-perl_4.10000-1_all.deb ... 314s Unpacking libjson-perl (4.10000-1) ... 314s Selecting previously unselected package ssl-cert. 314s Preparing to unpack .../06-ssl-cert_1.1.2ubuntu1_all.deb ... 314s Unpacking ssl-cert (1.1.2ubuntu1) ... 314s Selecting previously unselected package postgresql-common. 314s Preparing to unpack .../07-postgresql-common_257_all.deb ... 314s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 314s Unpacking postgresql-common (257) ... 314s Selecting previously unselected package libllvm17:s390x. 314s Preparing to unpack .../08-libllvm17_1%3a17.0.6-5build1_s390x.deb ... 314s Unpacking libllvm17:s390x (1:17.0.6-5build1) ... 315s Selecting previously unselected package libxslt1.1:s390x. 315s Preparing to unpack .../09-libxslt1.1_1.1.35-1_s390x.deb ... 315s Unpacking libxslt1.1:s390x (1.1.35-1) ... 315s Selecting previously unselected package postgresql-16. 315s Preparing to unpack .../10-postgresql-16_16.2-1_s390x.deb ... 315s Unpacking postgresql-16 (16.2-1) ... 316s Selecting previously unselected package postgresql. 316s Preparing to unpack .../11-postgresql_16+257_all.deb ... 316s Unpacking postgresql (16+257) ... 316s Setting up postgresql-client-common (257) ... 316s Setting up libpq5:s390x (16.2-1) ... 316s Setting up ssl-cert (1.1.2ubuntu1) ... 317s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 318s Setting up libjson-perl (4.10000-1) ... 318s Setting up libxslt1.1:s390x (1.1.35-1) ... 318s Setting up libllvm17:s390x (1:17.0.6-5build1) ... 318s Setting up postgresql-client-16 (16.2-1) ... 318s 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 318s Setting up postgresql-common (257) ... 319s 319s Creating config file /etc/postgresql-common/createcluster.conf with new version 319s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 319s Removing obsolete dictionary files: 320s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 320s Setting up pgcopydb (0.15-1) ... 320s Setting up postgresql-client (16+257) ... 320s Setting up postgresql-16 (16.2-1) ... 321s Creating new PostgreSQL cluster 16/main ... 321s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 321s The files belonging to this database system will be owned by user "postgres". 321s This user must also own the server process. 321s 321s The database cluster will be initialized with locale "C.UTF-8". 321s The default database encoding has accordingly been set to "UTF8". 321s The default text search configuration will be set to "english". 321s 321s Data page checksums are disabled. 321s 321s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 321s creating subdirectories ... ok 321s selecting dynamic shared memory implementation ... posix 321s selecting default max_connections ... 100 321s selecting default shared_buffers ... 128MB 321s selecting default time zone ... Etc/UTC 321s creating configuration files ... ok 321s running bootstrap script ... ok 322s performing post-bootstrap initialization ... ok 322s syncing data to disk ... ok 326s Setting up postgresql (16+257) ... 326s Setting up autopkgtest-satdep (0) ... 326s Processing triggers for man-db (2.12.0-3) ... 328s Processing triggers for libc-bin (2.39-0ubuntu2) ... 332s (Reading database ... 53297 files and directories currently installed.) 332s Removing autopkgtest-satdep (0) ... 333s autopkgtest [13:38:24]: test copydb: [----------------------- 333s + WORKDIR=/tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home 333s + pg_virtualenv 333s Creating new PostgreSQL cluster 16/regress ... 337s + createdb src 337s + createdb dst 337s + psql -c 'create table foo as select 123+456' src 337s SELECT 1 337s + rm -rf /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home 337s + HOME=/tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home 337s + pgcopydb clone --source dbname=src --target dbname=dst --dir /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home 337s 2024-03-09 13:38:28.476 3323 INFO main.c:129 Running pgcopydb version 0.15-1 from "/usr/bin/pgcopydb" 337s 2024-03-09 13:38:28.480 3323 INFO cli_common.c:1312 [SOURCE] Copying database from "postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 337s 2024-03-09 13:38:28.480 3323 INFO cli_common.c:1313 [TARGET] Copying database into "postgres:///dst?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60" 337s 2024-03-09 13:38:28.494 3323 INFO copydb.c:105 Using work dir "/tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home" 337s 2024-03-09 13:38:28.515 3323 INFO snapshot.c:100 Exported snapshot "00000003-00000010-1" from the source database 337s 2024-03-09 13:38:28.517 3327 INFO cli_clone_follow.c:518 STEP 1: fetch source database tables, indexes, and sequences 337s 2024-03-09 13:38:28.832 3327 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 337s 2024-03-09 13:38:28.839 3327 INFO copydb_schema.c:831 Fetched information for 0 indexes (supporting 0 constraints) 337s 2024-03-09 13:38:28.840 3327 INFO sequences.c:64 Fetching information for 0 sequences 337s 2024-03-09 13:38:28.847 3327 INFO copydb_schema.c:929 Fetched information for 1 extensions 337s 2024-03-09 13:38:28.938 3327 INFO copydb_schema.c:1300 Found 0 indexes (supporting 0 constraints) in the target database 337s 2024-03-09 13:38:28.952 3327 INFO cli_clone_follow.c:559 STEP 2: dump the source database schema (pre/post data) 337s 2024-03-09 13:38:28.954 3327 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section pre-data --file /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home/schema/pre.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 338s 2024-03-09 13:38:29.025 3327 INFO pgcmd.c:504 /usr/lib/postgresql/16/bin/pg_dump -Fc --snapshot 00000003-00000010-1 --section post-data --file /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home/schema/post.dump 'postgres:///src?keepalives=1&keepalives_idle=10&keepalives_interval=10&keepalives_count=60' 338s 2024-03-09 13:38:29.099 3327 INFO cli_clone_follow.c:569 STEP 3: restore the pre-data section to the target database 338s 2024-03-09 13:38:29.122 3327 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.FrX6Jt/build.pcb/src/debian/home/schema/pre-filtered.list /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home/schema/pre.dump 338s 2024-03-09 13:38:29.267 3348 INFO table-data.c:649 STEP 4: starting 4 table-data COPY processes 338s 2024-03-09 13:38:29.375 3353 INFO vacuum.c:142 STEP 8: starting 4 VACUUM processes 338s 2024-03-09 13:38:29.430 3352 INFO indexes.c:157 STEP 6: starting 4 CREATE INDEX processes 338s 2024-03-09 13:38:29.430 3352 INFO indexes.c:158 STEP 7: constraints are built by the CREATE INDEX processes 338s 2024-03-09 13:38:29.432 3327 INFO blobs.c:74 Skipping large objects: none found. 338s 2024-03-09 13:38:29.468 3327 INFO sequences.c:155 STEP 9: reset sequences values 338s 2024-03-09 13:38:29.539 3373 INFO sequences.c:245 Reset sequences values on the target database 339s 2024-03-09 13:38:30.021 3327 INFO cli_clone_follow.c:585 STEP 10: restore the post-data section to the target database 339s 2024-03-09 13:38:30.051 3327 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.FrX6Jt/build.pcb/src/debian/home/schema/post-filtered.list /tmp/autopkgtest.FrX6Jt/build.pcb/src/debian/home/schema/post.dump 339s 339s OID | Schema | Name | Parts | copy duration | transmitted bytes | indexes | create index duration 339s ------+--------+------+-------+---------------+-------------------+---------+---------------------- 339s 16386 | public | foo | 1 | 92ms | 4 B | 0 | 0ms 339s 339s 339s Step Connection Duration Transfer Concurrency 339s -------------------------------------------------- ---------- ---------- ---------- ------------ 339s Catalog Queries (table ordering, filtering, etc) source 148ms 1 339s Dump Schema source 144ms 1 339s Prepare Schema target 154ms 1 339s COPY, INDEX, CONSTRAINTS, VACUUM (wall clock) both 745ms 12 339s COPY (cumulative) both 92ms 8192 B 4 339s CREATE INDEX (cumulative) target 0ms 4 339s CONSTRAINTS (cumulative) target 0ms 4 339s VACUUM (cumulative) target 49ms 4 339s Reset Sequences both 500ms 1 339s Large Objects (cumulative) (null) 0ms 0 339s Finalize Schema both 238ms 4 339s -------------------------------------------------- ---------- ---------- ---------- ------------ 339s Total Wall Clock Duration both 1s929 20 339s 339s 2024-03-09 13:38:30.451 3327 INFO cli_clone_follow.c:616 All step are now done, 1s929 elapsed 339s 2024-03-09 13:38:30.452 3327 INFO summary.c:3161 Printing summary for 1 tables and 0 indexes 339s + pg_dump -t foo dst 339s -- 339s -- PostgreSQL database dump 339s -- 339s 339s -- Dumped from database version 16.2 (Ubuntu 16.2-1) 339s -- Dumped by pg_dump version 16.2 (Ubuntu 16.2-1) 339s 339s SET statement_timeout = 0; 339s SET lock_timeout = 0; 339s SET idle_in_transaction_session_timeout = 0; 339s SET client_encoding = 'UTF8'; 339s SET standard_conforming_strings = on; 339s SELECT pg_catalog.set_config('search_path', '', false); 339s SET check_function_bodies = false; 339s SET xmloption = content; 339s SET client_min_messages = warning; 339s SET row_security = off; 339s 339s SET default_tablespace = ''; 339s 339s SET default_table_access_method = heap; 339s 339s -- 339s -- Name: foo; Type: TABLE; Schema: public; Owner: ubuntu 339s -- 339s 339s CREATE TABLE public.foo ( 339s "?column?" integer 339s ); 339s 339s 339s ALTER TABLE public.foo OWNER TO ubuntu; 339s 339s -- 339s -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: ubuntu 339s -- 339s 339s COPY public.foo ("?column?") FROM stdin; 339s 579 339s \. 339s 339s 339s -- 339s -- PostgreSQL database dump complete 339s -- 339s 339s + pg_dump -t foo dst 339s + grep 579 339s 579 339s Dropping cluster 16/regress ... 340s autopkgtest [13:38:31]: test copydb: -----------------------] 341s autopkgtest [13:38:32]: test copydb: - - - - - - - - - - results - - - - - - - - - - 341s copydb PASS 341s autopkgtest [13:38:32]: @@@@@@@@@@@@@@@@@@@@ summary 341s copydb PASS 356s Creating nova instance adt-noble-s390x-pgcopydb-20240309-133250-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-s390x-server-20240308.img (UUID e6fbc012-c584-48d2-bb28-6fdcebac759f)...