0s autopkgtest [16:22:21]: starting date and time: 2024-03-18 16:22:21+0000 0s autopkgtest [16:22:21]: git checkout: b506e79c ssh-setup/nova: fix ARCH having two lines of data 0s autopkgtest [16:22:21]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.9fbnwytd/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:openssl --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=openssl/3.0.13-0ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@bos01-arm64-2.secgroup --name adt-noble-arm64-pgloader-20240318-162221-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-3 --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/ 158s autopkgtest [16:24:59]: testbed dpkg architecture: arm64 158s autopkgtest [16:24:59]: testbed apt version: 2.7.12 158s autopkgtest [16:24:59]: @@@@@@@@@@@@@@@@@@@@ test bed setup 159s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 160s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3728 kB] 160s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [485 kB] 160s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [51.4 kB] 160s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 160s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [654 kB] 160s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 160s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [33.6 kB] 160s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 160s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [4102 kB] 160s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 160s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [55.3 kB] 160s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 162s Fetched 9245 kB in 2s (5527 kB/s) 163s Reading package lists... 165s Reading package lists... 165s Building dependency tree... 165s Reading state information... 166s Calculating upgrade... 166s The following packages will be REMOVED: 166s libssl3 166s The following NEW packages will be installed: 166s libssl3t64 166s The following packages will be upgraded: 166s openssl 171s 1 upgraded, 1 newly installed, 1 to remove and 0 not upgraded. 171s Need to get 2777 kB of archives. 171s After this operation, 139 kB of additional disk space will be used. 171s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 openssl arm64 3.0.13-0ubuntu2 [985 kB] 172s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libssl3t64 arm64 3.0.13-0ubuntu2 [1793 kB] 173s Fetched 2777 kB in 7s (397 kB/s) 173s (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 ... 75850 files and directories currently installed.) 173s Preparing to unpack .../openssl_3.0.13-0ubuntu2_arm64.deb ... 173s Unpacking openssl (3.0.13-0ubuntu2) over (3.0.10-1ubuntu4) ... 173s dpkg: libssl3:arm64: dependency problems, but removing anyway as you requested: 173s wget depends on libssl3 (>= 3.0.0). 173s u-boot-tools depends on libssl3 (>= 3.0.0). 173s tnftp depends on libssl3 (>= 3.0.0). 173s tcpdump depends on libssl3 (>= 3.0.0). 173s systemd-resolved depends on libssl3 (>= 3.0.0). 173s systemd depends on libssl3 (>= 3.0.0). 173s sudo depends on libssl3 (>= 3.0.0). 173s sbsigntool depends on libssl3 (>= 3.0.0). 173s rsync depends on libssl3 (>= 3.0.0). 173s python3-cryptography depends on libssl3 (>= 3.0.0). 173s openssh-server depends on libssl3 (>= 3.0.10). 173s openssh-client depends on libssl3 (>= 3.0.10). 173s mtd-utils depends on libssl3 (>= 3.0.0). 173s mokutil depends on libssl3 (>= 3.0.0). 173s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 173s libsystemd-shared:arm64 depends on libssl3 (>= 3.0.0). 173s libssh-4:arm64 depends on libssl3 (>= 3.0.0). 173s libsasl2-modules:arm64 depends on libssl3 (>= 3.0.0). 173s libsasl2-2:arm64 depends on libssl3 (>= 3.0.0). 173s libpython3.12-minimal:arm64 depends on libssl3 (>= 3.0.0). 173s libpython3.11-minimal:arm64 depends on libssl3 (>= 3.0.0). 173s libnvme1 depends on libssl3 (>= 3.0.0). 173s libkrb5-3:arm64 depends on libssl3 (>= 3.0.0). 173s libkmod2:arm64 depends on libssl3 (>= 3.0.0). 173s libfido2-1:arm64 depends on libssl3 (>= 3.0.0). 173s libcurl4:arm64 depends on libssl3 (>= 3.0.0). 173s libcryptsetup12:arm64 depends on libssl3 (>= 3.0.0). 173s kmod depends on libssl3 (>= 3.0.0). 173s dhcpcd-base depends on libssl3 (>= 3.0.0). 173s bind9-libs:arm64 depends on libssl3 (>= 3.0.0). 173s 173s (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 ... 75850 files and directories currently installed.) 173s Removing libssl3:arm64 (3.0.10-1ubuntu4) ... 173s Selecting previously unselected package libssl3t64:arm64. 173s (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 ... 75839 files and directories currently installed.) 173s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu2_arm64.deb ... 173s Unpacking libssl3t64:arm64 (3.0.13-0ubuntu2) ... 174s Setting up libssl3t64:arm64 (3.0.13-0ubuntu2) ... 174s Setting up openssl (3.0.13-0ubuntu2) ... 174s Processing triggers for man-db (2.12.0-3) ... 174s Processing triggers for libc-bin (2.39-0ubuntu2) ... 174s Reading package lists... 174s Building dependency tree... 174s Reading state information... 175s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 176s sh: Attempting to set up Debian/Ubuntu apt sources automatically 176s sh: Distribution appears to be Ubuntu 176s Reading package lists... 176s Building dependency tree... 176s Reading state information... 177s eatmydata is already the newest version (131-1). 177s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 177s Reading package lists... 177s Building dependency tree... 177s Reading state information... 178s dbus is already the newest version (1.14.10-4ubuntu1). 178s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 178s Reading package lists... 178s Building dependency tree... 178s Reading state information... 178s rng-tools-debian is already the newest version (2.4). 178s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 178s Reading package lists... 179s Building dependency tree... 179s Reading state information... 179s The following packages will be REMOVED: 179s cloud-init* python3-configobj* python3-debconf* 179s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 179s After this operation, 3252 kB disk space will be freed. 179s (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 ... 75852 files and directories currently installed.) 179s Removing cloud-init (24.1.1-0ubuntu1) ... 180s Removing python3-configobj (5.0.8-3) ... 180s Removing python3-debconf (1.5.86) ... 180s Processing triggers for man-db (2.12.0-3) ... 180s (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 ... 75463 files and directories currently installed.) 180s Purging configuration files for cloud-init (24.1.1-0ubuntu1) ... 180s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 180s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 180s invoke-rc.d: policy-rc.d denied execution of try-restart. 181s Reading package lists... 181s Building dependency tree... 181s Reading state information... 181s linux-generic is already the newest version (6.8.0-11.11+1). 181s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 182s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 182s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 182s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 184s Reading package lists... 184s Reading package lists... 184s Building dependency tree... 184s Reading state information... 184s Calculating upgrade... 185s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 185s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 186s autopkgtest [16:25:27]: rebooting testbed after setup commands that affected boot 333s autopkgtest [16:27:54]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 336s autopkgtest [16:27:57]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 339s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (dsc) [2802 B] 339s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (tar) [3723 kB] 339s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (diff) [9336 B] 339s gpgv: Signature made Thu Nov 2 17:16:12 2023 UTC 339s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 339s gpgv: Can't check signature: No public key 339s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-1.dsc: no acceptable signature found 339s autopkgtest [16:28:00]: testing package pgloader version 3.6.10-1 339s autopkgtest [16:28:00]: build not needed 340s autopkgtest [16:28:01]: test ssl: preparing testbed 343s Reading package lists... 343s Building dependency tree... 343s Reading state information... 343s Starting pkgProblemResolver with broken count: 0 344s Starting 2 pkgProblemResolver with broken count: 0 344s Done 344s The following additional packages will be installed: 344s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 344s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 344s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 344s cl-usocket freetds-common freetds-dev libct4 libjson-perl libllvm17 libpq5 344s libsybdb5 libxslt1.1 pgloader postgresql postgresql-16 postgresql-client-16 344s postgresql-client-common postgresql-common ssl-cert 344s Suggested packages: 344s postgresql-doc postgresql-doc-16 344s Recommended packages: 344s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 344s libjson-xs-perl 344s The following NEW packages will be installed: 344s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 344s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 344s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 344s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 344s libct4 libjson-perl libllvm17 libpq5 libsybdb5 libxslt1.1 pgloader 344s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 344s postgresql-common ssl-cert 344s 0 upgraded, 34 newly installed, 0 to remove and 0 not upgraded. 344s Need to get 71.4 MB/71.4 MB of archives. 344s After this operation, 224 MB of additional disk space will be used. 344s Get:1 /tmp/autopkgtest.wLVUxK/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [732 B] 344s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 345s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-common all 257 [36.2 kB] 345s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 345s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-common all 257 [162 kB] 345s Get:6 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-alexandria all 20211025.gita67c3a6-1 [212 kB] 345s Get:7 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-rt all 20090812.gita6a7503-1 [13.2 kB] 345s Get:8 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-kmrcl all 1.111-2 [42.7 kB] 345s Get:9 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-base64 all 3.4.0-1 [9304 B] 345s Get:10 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 345s Get:11 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 345s Get:12 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-trivial-gray-streams all 20210117.git2b3823e-1 [10.8 kB] 345s Get:13 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 345s Get:14 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 345s Get:15 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-ironclad all 0.57-3 [1247 kB] 345s Get:16 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 345s Get:17 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-split-sequence all 1:2.0.1-1 [12.2 kB] 345s Get:18 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 345s Get:19 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 346s Get:20 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-usocket all 0.8.3-2 [69.9 kB] 346s Get:21 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-postgres all 20211113.git9d4332f-3 [56.5 kB] 346s Get:22 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-s-sql all 20211113.git9d4332f-3 [61.2 kB] 346s Get:23 http://ftpmaster.internal/ubuntu noble/universe arm64 cl-postmodern all 20211113.git9d4332f-3 [354 kB] 346s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 freetds-common all 1.3.17+ds-2 [26.8 kB] 346s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 libct4 arm64 1.3.17+ds-2 [163 kB] 346s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 libsybdb5 arm64 1.3.17+ds-2 [184 kB] 346s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 freetds-dev arm64 1.3.17+ds-2 [298 kB] 346s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17 arm64 1:17.0.6-5build1 [25.0 MB] 349s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 libpq5 arm64 16.2-1 [136 kB] 349s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 libxslt1.1 arm64 1.1.35-1 [161 kB] 349s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-16 arm64 16.2-1 [1260 kB] 349s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-16 arm64 16.2-1 [15.2 MB] 349s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql all 16+257 [11.4 kB] 349s Get:34 http://ftpmaster.internal/ubuntu noble/universe arm64 pgloader arm64 3.6.10-1 [25.6 MB] 350s Preconfiguring packages ... 351s Fetched 71.4 MB in 6s (11.7 MB/s) 351s Selecting previously unselected package libjson-perl. 351s (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 ... 75408 files and directories currently installed.) 351s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 351s Unpacking libjson-perl (4.10000-1) ... 351s Selecting previously unselected package postgresql-client-common. 351s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 351s Unpacking postgresql-client-common (257) ... 351s Selecting previously unselected package ssl-cert. 351s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 351s Unpacking ssl-cert (1.1.2ubuntu1) ... 351s Selecting previously unselected package postgresql-common. 351s Preparing to unpack .../03-postgresql-common_257_all.deb ... 351s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 351s Unpacking postgresql-common (257) ... 351s Selecting previously unselected package cl-alexandria. 351s Preparing to unpack .../04-cl-alexandria_20211025.gita67c3a6-1_all.deb ... 351s Unpacking cl-alexandria (20211025.gita67c3a6-1) ... 351s Selecting previously unselected package cl-rt. 351s Preparing to unpack .../05-cl-rt_20090812.gita6a7503-1_all.deb ... 351s Unpacking cl-rt (20090812.gita6a7503-1) ... 351s Selecting previously unselected package cl-kmrcl. 351s Preparing to unpack .../06-cl-kmrcl_1.111-2_all.deb ... 351s Unpacking cl-kmrcl (1.111-2) ... 351s Selecting previously unselected package cl-base64. 351s Preparing to unpack .../07-cl-base64_3.4.0-1_all.deb ... 351s Unpacking cl-base64 (3.4.0-1) ... 351s Selecting previously unselected package cl-bordeaux-threads. 351s Preparing to unpack .../08-cl-bordeaux-threads_0.8.8-5_all.deb ... 351s Unpacking cl-bordeaux-threads (0.8.8-5) ... 351s Selecting previously unselected package cl-closer-mop. 351s Preparing to unpack .../09-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 351s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 351s Selecting previously unselected package cl-trivial-gray-streams. 351s Preparing to unpack .../10-cl-trivial-gray-streams_20210117.git2b3823e-1_all.deb ... 351s Unpacking cl-trivial-gray-streams (20210117.git2b3823e-1) ... 351s Selecting previously unselected package cl-flexi-streams. 351s Preparing to unpack .../11-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 351s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 351s Selecting previously unselected package cl-global-vars. 351s Preparing to unpack .../12-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 351s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 351s Selecting previously unselected package cl-ironclad. 351s Preparing to unpack .../13-cl-ironclad_0.57-3_all.deb ... 351s Unpacking cl-ironclad (0.57-3) ... 351s Selecting previously unselected package cl-md5. 351s Preparing to unpack .../14-cl-md5_1%3a20210622.git906593f-1_all.deb ... 351s Unpacking cl-md5 (1:20210622.git906593f-1) ... 351s Selecting previously unselected package cl-split-sequence. 351s Preparing to unpack .../15-cl-split-sequence_1%3a2.0.1-1_all.deb ... 351s Unpacking cl-split-sequence (1:2.0.1-1) ... 351s Selecting previously unselected package cl-ppcre. 351s Preparing to unpack .../16-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 351s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 351s Selecting previously unselected package cl-uax-15. 351s Preparing to unpack .../17-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 351s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 351s Selecting previously unselected package cl-usocket. 351s Preparing to unpack .../18-cl-usocket_0.8.3-2_all.deb ... 351s Unpacking cl-usocket (0.8.3-2) ... 351s Selecting previously unselected package cl-postgres. 351s Preparing to unpack .../19-cl-postgres_20211113.git9d4332f-3_all.deb ... 351s Unpacking cl-postgres (20211113.git9d4332f-3) ... 351s Selecting previously unselected package cl-s-sql. 351s Preparing to unpack .../20-cl-s-sql_20211113.git9d4332f-3_all.deb ... 351s Unpacking cl-s-sql (20211113.git9d4332f-3) ... 351s Selecting previously unselected package cl-postmodern. 351s Preparing to unpack .../21-cl-postmodern_20211113.git9d4332f-3_all.deb ... 351s Unpacking cl-postmodern (20211113.git9d4332f-3) ... 351s Selecting previously unselected package freetds-common. 351s Preparing to unpack .../22-freetds-common_1.3.17+ds-2_all.deb ... 351s Unpacking freetds-common (1.3.17+ds-2) ... 351s Selecting previously unselected package libct4:arm64. 351s Preparing to unpack .../23-libct4_1.3.17+ds-2_arm64.deb ... 351s Unpacking libct4:arm64 (1.3.17+ds-2) ... 351s Selecting previously unselected package libsybdb5:arm64. 351s Preparing to unpack .../24-libsybdb5_1.3.17+ds-2_arm64.deb ... 351s Unpacking libsybdb5:arm64 (1.3.17+ds-2) ... 351s Selecting previously unselected package freetds-dev. 351s Preparing to unpack .../25-freetds-dev_1.3.17+ds-2_arm64.deb ... 351s Unpacking freetds-dev (1.3.17+ds-2) ... 351s Selecting previously unselected package libllvm17:arm64. 351s Preparing to unpack .../26-libllvm17_1%3a17.0.6-5build1_arm64.deb ... 351s Unpacking libllvm17:arm64 (1:17.0.6-5build1) ... 352s Selecting previously unselected package libpq5:arm64. 352s Preparing to unpack .../27-libpq5_16.2-1_arm64.deb ... 352s Unpacking libpq5:arm64 (16.2-1) ... 352s Selecting previously unselected package libxslt1.1:arm64. 352s Preparing to unpack .../28-libxslt1.1_1.1.35-1_arm64.deb ... 352s Unpacking libxslt1.1:arm64 (1.1.35-1) ... 352s Selecting previously unselected package postgresql-client-16. 352s Preparing to unpack .../29-postgresql-client-16_16.2-1_arm64.deb ... 352s Unpacking postgresql-client-16 (16.2-1) ... 352s Selecting previously unselected package postgresql-16. 352s Preparing to unpack .../30-postgresql-16_16.2-1_arm64.deb ... 352s Unpacking postgresql-16 (16.2-1) ... 353s Selecting previously unselected package postgresql. 353s Preparing to unpack .../31-postgresql_16+257_all.deb ... 353s Unpacking postgresql (16+257) ... 353s Selecting previously unselected package pgloader. 353s Preparing to unpack .../32-pgloader_3.6.10-1_arm64.deb ... 353s Unpacking pgloader (3.6.10-1) ... 353s Selecting previously unselected package autopkgtest-satdep. 353s Preparing to unpack .../33-1-autopkgtest-satdep.deb ... 353s Unpacking autopkgtest-satdep (0) ... 353s Setting up postgresql-client-common (257) ... 353s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 353s Setting up libpq5:arm64 (16.2-1) ... 353s Setting up cl-split-sequence (1:2.0.1-1) ... 353s Setting up cl-trivial-gray-streams (20210117.git2b3823e-1) ... 353s Setting up ssl-cert (1.1.2ubuntu1) ... 354s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 354s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 354s Setting up libjson-perl (4.10000-1) ... 354s Setting up libxslt1.1:arm64 (1.1.35-1) ... 354s Setting up cl-alexandria (20211025.gita67c3a6-1) ... 354s Setting up cl-rt (20090812.gita6a7503-1) ... 354s Setting up freetds-common (1.3.17+ds-2) ... 354s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 354s Setting up libllvm17:arm64 (1:17.0.6-5build1) ... 354s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 354s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 354s Setting up postgresql-client-16 (16.2-1) ... 354s 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 355s Setting up libsybdb5:arm64 (1.3.17+ds-2) ... 355s Setting up cl-bordeaux-threads (0.8.8-5) ... 355s Setting up libct4:arm64 (1.3.17+ds-2) ... 355s Setting up cl-kmrcl (1.111-2) ... 355s Setting up postgresql-common (257) ... 355s 355s Creating config file /etc/postgresql-common/createcluster.conf with new version 355s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 355s Removing obsolete dictionary files: 356s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 356s Setting up cl-usocket (0.8.3-2) ... 356s Setting up cl-md5 (1:20210622.git906593f-1) ... 356s Setting up cl-base64 (3.4.0-1) ... 356s Setting up cl-ironclad (0.57-3) ... 356s Setting up postgresql-16 (16.2-1) ... 356s Creating new PostgreSQL cluster 16/main ... 356s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 356s The files belonging to this database system will be owned by user "postgres". 356s This user must also own the server process. 356s 356s The database cluster will be initialized with locale "C.UTF-8". 356s The default database encoding has accordingly been set to "UTF8". 356s The default text search configuration will be set to "english". 356s 356s Data page checksums are disabled. 356s 356s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 356s creating subdirectories ... ok 356s selecting dynamic shared memory implementation ... posix 356s selecting default max_connections ... 100 356s selecting default shared_buffers ... 128MB 356s selecting default time zone ... Etc/UTC 356s creating configuration files ... ok 356s running bootstrap script ... ok 357s performing post-bootstrap initialization ... ok 357s syncing data to disk ... ok 360s Setting up freetds-dev (1.3.17+ds-2) ... 360s Setting up pgloader (3.6.10-1) ... 360s Setting up cl-postgres (20211113.git9d4332f-3) ... 360s Setting up postgresql (16+257) ... 360s Setting up cl-s-sql (20211113.git9d4332f-3) ... 360s Setting up cl-postmodern (20211113.git9d4332f-3) ... 360s Setting up autopkgtest-satdep (0) ... 360s Processing triggers for man-db (2.12.0-3) ... 361s Processing triggers for install-info (7.1-3) ... 361s Processing triggers for libc-bin (2.39-0ubuntu2) ... 364s (Reading database ... 78314 files and directories currently installed.) 364s Removing autopkgtest-satdep (0) ... 365s autopkgtest [16:28:26]: test ssl: [----------------------- 365s + trap rm -rf /tmp/pgloader EXIT 365s + dpkg-query --show --showformat=${Version} cl-postmodern 365s + postmodern=20211113.git9d4332f-3 365s + dpkg --compare-versions 20211113.git9d4332f-3 lt 20200101 365s + pg_virtualenv 365s Creating new PostgreSQL cluster 16/regress ... 368s ++ psql -XAtc 'SHOW hba_file' 368s + HBA=/etc/postgresql/16/regress/pg_hba.conf 368s + sed -i -e 's/^host/hostssl/' /etc/postgresql/16/regress/pg_hba.conf 368s + psql -XAtc 'SELECT pg_reload_conf()' 368s t 368s + createdb pgloader 368s + export PGDATABASE=pgloader 368s + PGDATABASE=pgloader 368s + psql -XAtc 'create schema expected' 368s CREATE SCHEMA 368s + rm -rf /tmp/pgloader 368s + PGHOST=/var/run/postgresql 368s + su -c 'pgloader --debug --regress test/allcols.load' postgres 369s mkdir -p #P"/tmp/pgloader/" 369s pgloader version 3.6.7~devel 369s compiled with SBCL 2.2.9.debian 369s sb-impl::*default-external-format* :UTF-8 369s tmpdir: #P"/tmp/pgloader/" 369s 2024-03-18T16:28:30.007897Z NOTICE Starting pgloader, log system is ready. 369s 2024-03-18T16:28:30.035538Z INFO Starting monitor 369s 2024-03-18T16:28:30.047384Z LOG pgloader version "3.6.7~devel" 369s 2024-03-18T16:28:30.047384Z LOG Data errors in '/tmp/pgloader/' 369s 2024-03-18T16:28:30.047384Z LOG Regression testing: "test/allcols.load" 369s 2024-03-18T16:28:30.047384Z LOG Parsing commands from file #P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/allcols.load" 369s 2024-03-18T16:28:30.094768Z INFO Parsed command: 369s /* 369s * This test is ported from pgloader 2.x where it was defined as: 369s * 369s * [allcols] 369s * table = allcols 369s * format = csv 369s * filename = allcols/allcols.data 369s * field_sep = : 369s * columns = * 369s * pg_option_work_mem = 14MB 369s * 369s */ 369s 369s LOAD CSV 369s FROM inline (a, b, c) 369s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 369s 369s WITH fields optionally enclosed by '"', 369s fields escaped by double-quote, 369s fields terminated by ':' 369s 369s SET client_encoding to 'latin1', 369s work_mem to '14MB', 369s standard_conforming_strings to 'on' 369s 369s BEFORE LOAD DO 369s $$ drop table if exists allcols; $$, 369s $$ create table allcols ( 369s a integer primary key, 369s b date, 369s c text 369s ); 369s $$; 369s 369s 369s 369s 369s 369s 2024-03-18T16:28:30.098717Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 369s 2024-03-18T16:28:30.193485Z DEBUG CONNECTED TO # 369s 2024-03-18T16:28:30.193485Z DEBUG SET client_encoding TO 'utf8' 369s 2024-03-18T16:28:30.193485Z DEBUG SET work_mem TO '14MB' 369s 2024-03-18T16:28:30.193485Z DEBUG SET standard_conforming_strings TO 'on' 369s 2024-03-18T16:28:30.193485Z DEBUG SET application_name TO 'pgloader' 369s 2024-03-18T16:28:30.209279Z NOTICE Executing SQL block for before load 369s 2024-03-18T16:28:30.244817Z DEBUG CONNECTED TO # 369s 2024-03-18T16:28:30.244817Z DEBUG SET client_encoding TO 'utf8' 369s 2024-03-18T16:28:30.244817Z DEBUG SET work_mem TO '14MB' 369s 2024-03-18T16:28:30.244817Z DEBUG SET standard_conforming_strings TO 'on' 369s 2024-03-18T16:28:30.244817Z DEBUG SET application_name TO 'pgloader' 369s 2024-03-18T16:28:30.252715Z DEBUG BEGIN 369s 2024-03-18T16:28:30.252715Z SQL drop table if exists allcols; 369s 2024-03-18T16:28:30.252715Z SQL create table allcols ( 369s a integer primary key, 369s b date, 369s c text 369s ); 369s 2024-03-18T16:28:30.307996Z DEBUG CONNECTED TO # 369s 2024-03-18T16:28:30.307996Z DEBUG SET client_encoding TO 'utf8' 369s 2024-03-18T16:28:30.307996Z DEBUG SET work_mem TO '14MB' 369s 2024-03-18T16:28:30.307996Z DEBUG SET standard_conforming_strings TO 'on' 369s 2024-03-18T16:28:30.307996Z DEBUG SET application_name TO 'pgloader' 369s 2024-03-18T16:28:30.323791Z SQL -- 369s -- get user defined SQL types 369s -- 369s select nt.nspname, 369s extname, 369s typname, 369s case when enum.enumtypid is not null 369s then array_agg(enum.enumlabel order by enumsortorder) 369s end as enumvalues 369s 369s from pg_class c 369s join pg_namespace n on n.oid = c.relnamespace 369s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 369s join pg_type t on t.oid = a.atttypid 369s left join pg_namespace nt on nt.oid = t.typnamespace 369s left join pg_depend d on d.classid = 'pg_type'::regclass 369s and d.refclassid = 'pg_extension'::regclass 369s and d.objid = t.oid 369s left join pg_extension e on refobjid = e.oid 369s left join pg_enum enum on enum.enumtypid = t.oid 369s 369s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 369s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 369s and c.relkind in ('r', 'f', 'p') 369s and ((n.nspname = 'public' and c.relname = 'allcols')) 369s 369s and 369s ( t.typrelid = 0 369s or 369s (select c.relkind = 'c' 369s from pg_class c 369s where c.oid = t.typrelid) 369s ) 369s and not exists 369s ( 369s select 1 369s from pg_type el 369s where el.oid = t.typelem 369s and el.typarray = t.oid 369s ) 369s 369s group by nt.nspname, extname, typname, enumtypid 369s order by nt.nspname, extname, typname, enumtypid; 369s 2024-03-18T16:28:30.331688Z SQL -- params: table-type-name 369s -- including 369s -- filter-list-to-where-clause for including 369s -- excluding 369s -- filter-list-to-where-clause for excluding 369s with seqattr as 369s ( 369s select adrelid, 369s adnum, 369s pg_get_expr(d.adbin, d.adrelid) as adsrc, 369s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 369s then substring(pg_get_expr(d.adbin, d.adrelid) 369s from '''([^'']+)''' 369s ) 369s else null 369s end as seqname 369s from pg_attrdef d 369s ) 369s select nspname, relname, c.oid, attname, 369s t.oid::regtype as type, 369s case when atttypmod > 0 369s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 369s else null 369s end as typmod, 369s attnotnull, 369s case when atthasdef 369s then pg_get_expr(def.adbin, def.adrelid) 369s end as default , 369s case when s.seqname is not null then 'auto_increment' end as extra 369s from pg_class c 369s join pg_namespace n on n.oid = c.relnamespace 369s left join pg_attribute a on c.oid = a.attrelid 369s join pg_type t on t.oid = a.atttypid and attnum > 0 369s left join pg_attrdef def on a.attrelid = def.adrelid 369s and a.attnum = def.adnum 369s and a.atthasdef 369s left join seqattr s on def.adrelid = s.adrelid 369s and def.adnum = s.adnum 369s 369s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 369s and relkind in ('r', 'f', 'p') 369s and ((n.nspname = 'public' and c.relname = 'allcols')) 369s 369s 369s order by nspname, relname, attnum; 369s 2024-03-18T16:28:30.363277Z SQL -- params: including 369s -- filter-list-to-where-clause for including 369s -- excluding 369s -- filter-list-to-where-clause for excluding 369s select n.nspname, 369s i.relname, 369s i.oid, 369s rn.nspname, 369s r.relname, 369s indisprimary, 369s indisunique, 369s (select string_agg(attname, ',') 369s from pg_attribute 369s where attrelid = r.oid 369s and array[attnum::integer] <@ indkey::integer[] 369s ) as cols, 369s pg_get_indexdef(indexrelid), 369s c.conname, 369s pg_get_constraintdef(c.oid) 369s from pg_index x 369s join pg_class i ON i.oid = x.indexrelid 369s join pg_class r ON r.oid = x.indrelid 369s join pg_namespace n ON n.oid = i.relnamespace 369s join pg_namespace rn ON rn.oid = r.relnamespace 369s left join pg_depend d on d.classid = 'pg_class'::regclass 369s and d.objid = i.oid 369s and d.refclassid = 'pg_constraint'::regclass 369s and d.deptype = 'i' 369s left join pg_constraint c ON c.oid = d.refobjid 369s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 369s and ((rn.nspname = 'public' and r.relname = 'allcols')) 369s 369s order by n.nspname, r.relname 369s 2024-03-18T16:28:30.379072Z SQL -- params: including (table) 369s -- filter-list-to-where-clause for including 369s -- excluding (table) 369s -- filter-list-to-where-clause for excluding 369s -- including (ftable) 369s -- filter-list-to-where-clause for including 369s -- excluding (ftable) 369s -- filter-list-to-where-clause for excluding 369s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 369s r.oid, 369s d.refobjid as pkeyoid, 369s conname, 369s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 369s (select string_agg(attname, ',') 369s from pg_attribute 369s where attrelid = r.conrelid 369s and array[attnum::integer] <@ conkey::integer[] 369s ) as conkey, 369s (select string_agg(attname, ',') 369s from pg_attribute 369s where attrelid = r.confrelid 369s and array[attnum::integer] <@ confkey::integer[] 369s ) as confkey, 369s confupdtype, confdeltype, confmatchtype, 369s condeferrable, condeferred 369s from pg_catalog.pg_constraint r 369s JOIN pg_class c on r.conrelid = c.oid 369s JOIN pg_namespace n on c.relnamespace = n.oid 369s JOIN pg_class cf on r.confrelid = cf.oid 369s JOIN pg_namespace nf on cf.relnamespace = nf.oid 369s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 369s and d.objid = r.oid 369s and d.refobjsubid = 0 369s where r.contype = 'f' 369s AND c.relkind in ('r', 'f', 'p') 369s AND cf.relkind in ('r', 'f', 'p') 369s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 369s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 369s and ((n.nspname = 'public' and c.relname = 'allcols')) 369s 369s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 369s 369s 2024-03-18T16:28:30.383020Z SQL -- params pkey-oid-list 369s -- fkey-oild-list 369s with pkeys(oid) as ( 369s values(16391) 369s ), 369s knownfkeys(oid) as ( 369s values(-1) 369s ), 369s pkdeps as ( 369s select pkeys.oid, pg_depend.objid 369s from pg_depend 369s join pkeys on pg_depend.refobjid = pkeys.oid 369s where classid = 'pg_catalog.pg_constraint'::regclass 369s and refclassid = 'pg_catalog.pg_class'::regclass 369s ) 369s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 369s r.oid as conoid, conname, 369s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 369s pkdeps.oid as index_oid 369s from pg_catalog.pg_constraint r 369s JOIN pkdeps on r.oid = pkdeps.objid 369s JOIN pg_class c on r.conrelid = c.oid 369s JOIN pg_namespace n on c.relnamespace = n.oid 369s JOIN pg_class cf on r.confrelid = cf.oid 369s JOIN pg_namespace nf on cf.relnamespace = nf.oid 369s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 369s 2024-03-18T16:28:30.398815Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 369s 2024-03-18T16:28:30.402764Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 369s 2024-03-18T16:28:30.402764Z WARNING That could impact loading performance badly. 369s 2024-03-18T16:28:30.402764Z WARNING Consider the option 'drop indexes'. 369s 2024-03-18T16:28:30.454096Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 369s 2024-03-18T16:28:30.454096Z DEBUG Reader started for "public"."allcols" 369s 2024-03-18T16:28:30.454096Z DEBUG start "public"."allcols" 931827 369s 2024-03-18T16:28:30.473840Z NOTICE Opening (:INLINE 369s (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/allcols.load" . 765)) 369s 2024-03-18T16:28:30.473840Z INFO COPY ON ERROR RESUME NEXT 369s 2024-03-18T16:28:30.493583Z DEBUG Reader for "public"."allcols" is done in 0.035538s 369s 2024-03-18T16:28:30.493583Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.035538s 369s 2024-03-18T16:28:30.513326Z DEBUG CONNECTED TO # 369s 2024-03-18T16:28:30.513326Z DEBUG SET client_encoding TO 'utf8' 369s 2024-03-18T16:28:30.513326Z DEBUG SET work_mem TO '14MB' 369s 2024-03-18T16:28:30.513326Z DEBUG SET standard_conforming_strings TO 'on' 369s 2024-03-18T16:28:30.513326Z DEBUG SET application_name TO 'pgloader' 369s 2024-03-18T16:28:30.513326Z SQL SET search_path TO "public"; 369s 2024-03-18T16:28:30.517275Z INFO pgsql:copy-rows-from-queue[2]: "public"."allcols" ("a" "b" "c") 369s 2024-03-18T16:28:30.525171Z DEBUG send-batch[2] "public"."allcols" 8 rows [ 0.2 kB] in 0.000000s 369s 2024-03-18T16:28:30.525171Z DEBUG stop "public"."allcols" | 931827 .. 998955 = 0.067128d0 369s 2024-03-18T16:28:30.525171Z DEBUG Writer[2] for "public"."allcols" is done in 0.003949s 369s 2024-03-18T16:28:30.525171Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.003949s 369s 2024-03-18T16:28:30.537017Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 369s 2024-03-18T16:28:30.568639Z DEBUG CONNECTED TO # 369s 2024-03-18T16:28:30.568639Z DEBUG SET client_encoding TO 'utf8' 369s 2024-03-18T16:28:30.568639Z DEBUG SET work_mem TO '14MB' 369s 2024-03-18T16:28:30.568639Z DEBUG SET standard_conforming_strings TO 'on' 369s 2024-03-18T16:28:30.568639Z DEBUG SET application_name TO 'pgloader' 369s 2024-03-18T16:28:30.576549Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/allcols.out") 370s 2024-03-18T16:28:30.604235Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:30.608190Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:30.608190Z DEBUG SET work_mem TO '14MB' 370s 2024-03-18T16:28:30.608190Z DEBUG SET standard_conforming_strings TO 'on' 370s 2024-03-18T16:28:30.608190Z DEBUG SET application_name TO 'pgloader' 370s 2024-03-18T16:28:30.608190Z NOTICE drop table if exists expected.allcols; 370s 2024-03-18T16:28:30.608190Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 370s 2024-03-18T16:28:30.608190Z NOTICE create table expected.allcols(like allcols); 370s 2024-03-18T16:28:30.616100Z DEBUG LOAD DATA FROM # 370s 2024-03-18T16:28:30.647740Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:30.647740Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:30.647740Z DEBUG SET application_name TO 'pgloader' 370s 2024-03-18T16:28:30.691246Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:30.691246Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:30.691246Z DEBUG SET application_name TO 'pgloader' 370s 2024-03-18T16:28:30.691246Z SQL -- 370s -- get user defined SQL types 370s -- 370s select nt.nspname, 370s extname, 370s typname, 370s case when enum.enumtypid is not null 370s then array_agg(enum.enumlabel order by enumsortorder) 370s end as enumvalues 370s 370s from pg_class c 370s join pg_namespace n on n.oid = c.relnamespace 370s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 370s join pg_type t on t.oid = a.atttypid 370s left join pg_namespace nt on nt.oid = t.typnamespace 370s left join pg_depend d on d.classid = 'pg_type'::regclass 370s and d.refclassid = 'pg_extension'::regclass 370s and d.objid = t.oid 370s left join pg_extension e on refobjid = e.oid 370s left join pg_enum enum on enum.enumtypid = t.oid 370s 370s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 370s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 370s and c.relkind in ('r', 'f', 'p') 370s and ((n.nspname = 'expected' and c.relname = 'allcols')) 370s 370s and 370s ( t.typrelid = 0 370s or 370s (select c.relkind = 'c' 370s from pg_class c 370s where c.oid = t.typrelid) 370s ) 370s and not exists 370s ( 370s select 1 370s from pg_type el 370s where el.oid = t.typelem 370s and el.typarray = t.oid 370s ) 370s 370s group by nt.nspname, extname, typname, enumtypid 370s order by nt.nspname, extname, typname, enumtypid; 370s 2024-03-18T16:28:30.699157Z SQL -- params: table-type-name 370s -- including 370s -- filter-list-to-where-clause for including 370s -- excluding 370s -- filter-list-to-where-clause for excluding 370s with seqattr as 370s ( 370s select adrelid, 370s adnum, 370s pg_get_expr(d.adbin, d.adrelid) as adsrc, 370s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 370s then substring(pg_get_expr(d.adbin, d.adrelid) 370s from '''([^'']+)''' 370s ) 370s else null 370s end as seqname 370s from pg_attrdef d 370s ) 370s select nspname, relname, c.oid, attname, 370s t.oid::regtype as type, 370s case when atttypmod > 0 370s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 370s else null 370s end as typmod, 370s attnotnull, 370s case when atthasdef 370s then pg_get_expr(def.adbin, def.adrelid) 370s end as default , 370s case when s.seqname is not null then 'auto_increment' end as extra 370s from pg_class c 370s join pg_namespace n on n.oid = c.relnamespace 370s left join pg_attribute a on c.oid = a.attrelid 370s join pg_type t on t.oid = a.atttypid and attnum > 0 370s left join pg_attrdef def on a.attrelid = def.adrelid 370s and a.attnum = def.adnum 370s and a.atthasdef 370s left join seqattr s on def.adrelid = s.adrelid 370s and def.adnum = s.adnum 370s 370s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 370s and relkind in ('r', 'f', 'p') 370s and ((n.nspname = 'expected' and c.relname = 'allcols')) 370s 370s 370s order by nspname, relname, attnum; 370s 2024-03-18T16:28:30.699157Z SQL -- params: including 370s -- filter-list-to-where-clause for including 370s -- excluding 370s -- filter-list-to-where-clause for excluding 370s select n.nspname, 370s i.relname, 370s i.oid, 370s rn.nspname, 370s r.relname, 370s indisprimary, 370s indisunique, 370s (select string_agg(attname, ',') 370s from pg_attribute 370s where attrelid = r.oid 370s and array[attnum::integer] <@ indkey::integer[] 370s ) as cols, 370s pg_get_indexdef(indexrelid), 370s c.conname, 370s pg_get_constraintdef(c.oid) 370s from pg_index x 370s join pg_class i ON i.oid = x.indexrelid 370s join pg_class r ON r.oid = x.indrelid 370s join pg_namespace n ON n.oid = i.relnamespace 370s join pg_namespace rn ON rn.oid = r.relnamespace 370s left join pg_depend d on d.classid = 'pg_class'::regclass 370s and d.objid = i.oid 370s and d.refclassid = 'pg_constraint'::regclass 370s and d.deptype = 'i' 370s left join pg_constraint c ON c.oid = d.refobjid 370s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 370s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 370s 370s order by n.nspname, r.relname 370s 2024-03-18T16:28:30.703112Z SQL -- params: including (table) 370s -- filter-list-to-where-clause for including 370s -- excluding (table) 370s -- filter-list-to-where-clause for excluding 370s -- including (ftable) 370s -- filter-list-to-where-clause for including 370s -- excluding (ftable) 370s -- filter-list-to-where-clause for excluding 370s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 370s r.oid, 370s d.refobjid as pkeyoid, 370s conname, 370s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 370s (select string_agg(attname, ',') 370s from pg_attribute 370s where attrelid = r.conrelid 370s and array[attnum::integer] <@ conkey::integer[] 370s ) as conkey, 370s (select string_agg(attname, ',') 370s from pg_attribute 370s where attrelid = r.confrelid 370s and array[attnum::integer] <@ confkey::integer[] 370s ) as confkey, 370s confupdtype, confdeltype, confmatchtype, 370s condeferrable, condeferred 370s from pg_catalog.pg_constraint r 370s JOIN pg_class c on r.conrelid = c.oid 370s JOIN pg_namespace n on c.relnamespace = n.oid 370s JOIN pg_class cf on r.confrelid = cf.oid 370s JOIN pg_namespace nf on cf.relnamespace = nf.oid 370s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 370s and d.objid = r.oid 370s and d.refobjsubid = 0 370s where r.contype = 'f' 370s AND c.relkind in ('r', 'f', 'p') 370s AND cf.relkind in ('r', 'f', 'p') 370s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 370s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 370s and ((n.nspname = 'expected' and c.relname = 'allcols')) 370s 370s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 370s 370s 2024-03-18T16:28:30.703112Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 370s 2024-03-18T16:28:30.703112Z SQL TRUNCATE "expected"."allcols"; 370s 2024-03-18T16:28:30.722887Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 370s 2024-03-18T16:28:30.722887Z DEBUG Reader started for "expected"."allcols" 370s 2024-03-18T16:28:30.722887Z DEBUG start "expected"."allcols" 1200618 370s 2024-03-18T16:28:30.722887Z NOTICE Opening #P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/allcols.out" 370s 2024-03-18T16:28:30.722887Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 370s 2024-03-18T16:28:30.722887Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 370s 2024-03-18T16:28:30.726842Z INFO COPY ON ERROR RESUME NEXT 370s 2024-03-18T16:28:30.758483Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:30.758483Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:30.758483Z DEBUG SET application_name TO 'pgloader' 370s 2024-03-18T16:28:30.758483Z SQL SET search_path TO "expected"; 370s 2024-03-18T16:28:30.758483Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 370s 2024-03-18T16:28:30.758483Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 370s 2024-03-18T16:28:30.758483Z DEBUG stop "expected"."allcols" | 1200618 .. 1236214 = 0.035596d0 370s 2024-03-18T16:28:30.762438Z DEBUG Writer[1] for "expected"."allcols" is done in 0.000000s 370s 2024-03-18T16:28:30.766393Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 370s 2024-03-18T16:28:30.766393Z LOG report summary reset 370s table name errors read imported bytes total time read write 370s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 370s fetch 0 0 0 0.004s 370s before load 0 2 2 0.043s 370s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 370s "public"."allcols" 0 8 8 0.2 kB 0.067s 0.036s 0.004s 370s "expected"."allcols" 0 8 8 0.2 kB 0.036s 370s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 370s Files Processed 0 2 2 0.059s 370s COPY Threads Completion 0 4 4 0.107s 370s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 370s Total import time ✓ 16 16 0.4 kB 0.166s 370s 2024-03-18T16:28:30.829674Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:30.829674Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:30.833629Z DEBUG SET work_mem TO '14MB' 370s 2024-03-18T16:28:30.833629Z DEBUG SET standard_conforming_strings TO 'on' 370s 2024-03-18T16:28:30.833629Z DEBUG SET application_name TO 'pgloader' 370s 2024-03-18T16:28:30.833629Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 370s 2024-03-18T16:28:30.833629Z NOTICE Got a diff of 0 rows 370s 2024-03-18T16:28:30.833629Z LOG Regress pass. 370s 2024-03-18T16:28:30.833629Z INFO Stopping monitor 370s + rm -rf /tmp/pgloader 370s + PGSSLMODE=require 370s + pgloader --debug --regress test/allcols.load 370s mkdir -p #P"/tmp/pgloader/" 370s pgloader version 3.6.7~devel 370s compiled with SBCL 2.2.9.debian 370s sb-impl::*default-external-format* :UTF-8 370s tmpdir: #P"/tmp/pgloader/" 370s 2024-03-18T16:28:31.007911Z NOTICE Starting pgloader, log system is ready. 370s 2024-03-18T16:28:31.035596Z INFO Starting monitor 370s 2024-03-18T16:28:31.039551Z LOG pgloader version "3.6.7~devel" 370s 2024-03-18T16:28:31.079102Z INFO Parsed command: 370s /* 370s * This test is ported from pgloader 2.x where it was defined as: 370s * 370s * [allcols] 370s * table = allcols 370s * format = csv 370s * filename = allcols/allcols.data 370s * field_sep = : 370s * columns = * 370s * pg_option_work_mem = 14MB 370s * 370s */ 370s 370s LOAD CSV 370s FROM inline (a, b, c) 370s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 370s 370s WITH fields optionally enclosed by '"', 370s fields escaped by double-quote, 370s fields terminated by ':' 370s 370s SET client_encoding to 'latin1', 370s work_mem to '14MB', 370s standard_conforming_strings to 'on' 370s 370s BEFORE LOAD DO 370s $$ drop table if exists allcols; $$, 370s $$ create table allcols ( 370s a integer primary key, 370s b date, 370s c text 370s ); 370s $$; 370s 370s 370s 370s 370s 370s 2024-03-18T16:28:31.087012Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 370s 2024-03-18T16:28:31.268957Z DEBUG CONNECTED TO # 370s 2024-03-18T16:28:31.272919Z DEBUG SET client_encoding TO 'utf8' 370s 2024-03-18T16:28:31.272919Z DEBUG SET work_mem TO '14MB' 370s 2024-03-18T16:28:31.272919Z DEBUG SET standard_conforming_strings TO 'on' 370s 2024-03-18T16:28:31.272919Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.288762Z NOTICE Executing SQL block for before load 371s 2024-03-18T16:28:31.364015Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.364015Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.364015Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:31.364015Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:31.364015Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.371936Z DEBUG BEGIN 371s 2024-03-18T16:28:31.371936Z SQL drop table if exists allcols; 371s 2024-03-18T16:28:31.371936Z SQL create table allcols ( 371s a integer primary key, 371s b date, 371s c text 371s ); 371s 2024-03-18T16:28:31.470954Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.474914Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.474914Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:31.474914Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:31.474914Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.486797Z SQL -- 371s -- get user defined SQL types 371s -- 371s select nt.nspname, 371s extname, 371s typname, 371s case when enum.enumtypid is not null 371s then array_agg(enum.enumlabel order by enumsortorder) 371s end as enumvalues 371s 371s from pg_class c 371s join pg_namespace n on n.oid = c.relnamespace 371s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 371s join pg_type t on t.oid = a.atttypid 371s left join pg_namespace nt on nt.oid = t.typnamespace 371s left join pg_depend d on d.classid = 'pg_type'::regclass 371s and d.refclassid = 'pg_extension'::regclass 371s and d.objid = t.oid 371s left join pg_extension e on refobjid = e.oid 371s left join pg_enum enum on enum.enumtypid = t.oid 371s 371s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 371s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and c.relkind in ('r', 'f', 'p') 371s and ((n.nspname = 'public' and c.relname = 'allcols')) 371s 371s and 371s ( t.typrelid = 0 371s or 371s (select c.relkind = 'c' 371s from pg_class c 371s where c.oid = t.typrelid) 371s ) 371s and not exists 371s ( 371s select 1 371s from pg_type el 371s where el.oid = t.typelem 371s and el.typarray = t.oid 371s ) 371s 371s group by nt.nspname, extname, typname, enumtypid 371s order by nt.nspname, extname, typname, enumtypid; 371s 2024-03-18T16:28:31.490757Z SQL -- params: table-type-name 371s -- including 371s -- filter-list-to-where-clause for including 371s -- excluding 371s -- filter-list-to-where-clause for excluding 371s with seqattr as 371s ( 371s select adrelid, 371s adnum, 371s pg_get_expr(d.adbin, d.adrelid) as adsrc, 371s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 371s then substring(pg_get_expr(d.adbin, d.adrelid) 371s from '''([^'']+)''' 371s ) 371s else null 371s end as seqname 371s from pg_attrdef d 371s ) 371s select nspname, relname, c.oid, attname, 371s t.oid::regtype as type, 371s case when atttypmod > 0 371s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 371s else null 371s end as typmod, 371s attnotnull, 371s case when atthasdef 371s then pg_get_expr(def.adbin, def.adrelid) 371s end as default , 371s case when s.seqname is not null then 'auto_increment' end as extra 371s from pg_class c 371s join pg_namespace n on n.oid = c.relnamespace 371s left join pg_attribute a on c.oid = a.attrelid 371s join pg_type t on t.oid = a.atttypid and attnum > 0 371s left join pg_attrdef def on a.attrelid = def.adrelid 371s and a.attnum = def.adnum 371s and a.atthasdef 371s left join seqattr s on def.adrelid = s.adrelid 371s and def.adnum = s.adnum 371s 371s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and relkind in ('r', 'f', 'p') 371s and ((n.nspname = 'public' and c.relname = 'allcols')) 371s 371s 371s order by nspname, relname, attnum; 371s 2024-03-18T16:28:31.506600Z SQL -- params: including 371s -- filter-list-to-where-clause for including 371s -- excluding 371s -- filter-list-to-where-clause for excluding 371s select n.nspname, 371s i.relname, 371s i.oid, 371s rn.nspname, 371s r.relname, 371s indisprimary, 371s indisunique, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.oid 371s and array[attnum::integer] <@ indkey::integer[] 371s ) as cols, 371s pg_get_indexdef(indexrelid), 371s c.conname, 371s pg_get_constraintdef(c.oid) 371s from pg_index x 371s join pg_class i ON i.oid = x.indexrelid 371s join pg_class r ON r.oid = x.indrelid 371s join pg_namespace n ON n.oid = i.relnamespace 371s join pg_namespace rn ON rn.oid = r.relnamespace 371s left join pg_depend d on d.classid = 'pg_class'::regclass 371s and d.objid = i.oid 371s and d.refclassid = 'pg_constraint'::regclass 371s and d.deptype = 'i' 371s left join pg_constraint c ON c.oid = d.refobjid 371s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and ((rn.nspname = 'public' and r.relname = 'allcols')) 371s 371s order by n.nspname, r.relname 371s 2024-03-18T16:28:31.518482Z SQL -- params: including (table) 371s -- filter-list-to-where-clause for including 371s -- excluding (table) 371s -- filter-list-to-where-clause for excluding 371s -- including (ftable) 371s -- filter-list-to-where-clause for including 371s -- excluding (ftable) 371s -- filter-list-to-where-clause for excluding 371s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 371s r.oid, 371s d.refobjid as pkeyoid, 371s conname, 371s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.conrelid 371s and array[attnum::integer] <@ conkey::integer[] 371s ) as conkey, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.confrelid 371s and array[attnum::integer] <@ confkey::integer[] 371s ) as confkey, 371s confupdtype, confdeltype, confmatchtype, 371s condeferrable, condeferred 371s from pg_catalog.pg_constraint r 371s JOIN pg_class c on r.conrelid = c.oid 371s JOIN pg_namespace n on c.relnamespace = n.oid 371s JOIN pg_class cf on r.confrelid = cf.oid 371s JOIN pg_namespace nf on cf.relnamespace = nf.oid 371s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 371s and d.objid = r.oid 371s and d.refobjsubid = 0 371s where r.contype = 'f' 371s AND c.relkind in ('r', 'f', 'p') 371s AND cf.relkind in ('r', 'f', 'p') 371s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 371s and ((n.nspname = 'public' and c.relname = 'allcols')) 371s 371s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 371s 371s 2024-03-18T16:28:31.522443Z SQL -- params pkey-oid-list 371s -- fkey-oild-list 371s with pkeys(oid) as ( 371s values(16406) 371s ), 371s knownfkeys(oid) as ( 371s values(-1) 371s ), 371s pkdeps as ( 371s select pkeys.oid, pg_depend.objid 371s from pg_depend 371s join pkeys on pg_depend.refobjid = pkeys.oid 371s where classid = 'pg_catalog.pg_constraint'::regclass 371s and refclassid = 'pg_catalog.pg_class'::regclass 371s ) 371s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 371s r.oid as conoid, conname, 371s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 371s pkdeps.oid as index_oid 371s from pg_catalog.pg_constraint r 371s JOIN pkdeps on r.oid = pkdeps.objid 371s JOIN pg_class c on r.conrelid = c.oid 371s JOIN pg_namespace n on c.relnamespace = n.oid 371s JOIN pg_class cf on r.confrelid = cf.oid 371s JOIN pg_namespace nf on cf.relnamespace = nf.oid 371s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 371s 2024-03-18T16:28:31.530364Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 371s 2024-03-18T16:28:31.534325Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 371s 2024-03-18T16:28:31.538286Z WARNING That could impact loading performance badly. 371s 2024-03-18T16:28:31.538286Z WARNING Consider the option 'drop indexes'. 371s 2024-03-18T16:28:31.562050Z NOTICE COPY "public"."allcols" with 0 rows estimated [0/4] 371s 2024-03-18T16:28:31.562050Z DEBUG Reader started for "public"."allcols" 371s 2024-03-18T16:28:31.562050Z DEBUG start "public"."allcols" 989192 371s 2024-03-18T16:28:31.569970Z NOTICE Opening (:INLINE 371s (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/allcols.load" . 765)) 371s 2024-03-18T16:28:31.573931Z INFO COPY ON ERROR RESUME NEXT 371s 2024-03-18T16:28:31.597695Z DEBUG Reader for "public"."allcols" is done in 0.039606s 371s 2024-03-18T16:28:31.597695Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.039606s 371s 2024-03-18T16:28:31.649184Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.649184Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.649184Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:31.649184Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:31.649184Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.649184Z SQL SET search_path TO "public"; 371s 2024-03-18T16:28:31.649184Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 371s 2024-03-18T16:28:31.661066Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.003961s 371s 2024-03-18T16:28:31.665027Z DEBUG stop "public"."allcols" | 989192 .. 1096130 = 0.106938d0 371s 2024-03-18T16:28:31.665027Z DEBUG Writer[1] for "public"."allcols" is done in 0.003961s 371s 2024-03-18T16:28:31.665027Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.003961s 371s 2024-03-18T16:28:31.676909Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 371s 2024-03-18T16:28:31.752162Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.752162Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.752162Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:31.752162Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:31.756123Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.764044Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/allcols.out") 371s 2024-03-18T16:28:31.823455Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.823455Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.823455Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:31.823455Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:31.823455Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.827416Z NOTICE drop table if exists expected.allcols; 371s 2024-03-18T16:28:31.827416Z NOTICE create table expected.allcols(like allcols); 371s 2024-03-18T16:28:31.831376Z DEBUG LOAD DATA FROM # 371s 2024-03-18T16:28:31.902669Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.906629Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.906629Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.977922Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:31.977922Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:31.977922Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:31.977922Z SQL -- 371s -- get user defined SQL types 371s -- 371s select nt.nspname, 371s extname, 371s typname, 371s case when enum.enumtypid is not null 371s then array_agg(enum.enumlabel order by enumsortorder) 371s end as enumvalues 371s 371s from pg_class c 371s join pg_namespace n on n.oid = c.relnamespace 371s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 371s join pg_type t on t.oid = a.atttypid 371s left join pg_namespace nt on nt.oid = t.typnamespace 371s left join pg_depend d on d.classid = 'pg_type'::regclass 371s and d.refclassid = 'pg_extension'::regclass 371s and d.objid = t.oid 371s left join pg_extension e on refobjid = e.oid 371s left join pg_enum enum on enum.enumtypid = t.oid 371s 371s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 371s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and c.relkind in ('r', 'f', 'p') 371s and ((n.nspname = 'expected' and c.relname = 'allcols')) 371s 371s and 371s ( t.typrelid = 0 371s or 371s (select c.relkind = 'c' 371s from pg_class c 371s where c.oid = t.typrelid) 371s ) 371s and not exists 371s ( 371s select 1 371s from pg_type el 371s where el.oid = t.typelem 371s and el.typarray = t.oid 371s ) 371s 371s group by nt.nspname, extname, typname, enumtypid 371s order by nt.nspname, extname, typname, enumtypid; 371s 2024-03-18T16:28:31.985843Z SQL -- params: table-type-name 371s -- including 371s -- filter-list-to-where-clause for including 371s -- excluding 371s -- filter-list-to-where-clause for excluding 371s with seqattr as 371s ( 371s select adrelid, 371s adnum, 371s pg_get_expr(d.adbin, d.adrelid) as adsrc, 371s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 371s then substring(pg_get_expr(d.adbin, d.adrelid) 371s from '''([^'']+)''' 371s ) 371s else null 371s end as seqname 371s from pg_attrdef d 371s ) 371s select nspname, relname, c.oid, attname, 371s t.oid::regtype as type, 371s case when atttypmod > 0 371s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 371s else null 371s end as typmod, 371s attnotnull, 371s case when atthasdef 371s then pg_get_expr(def.adbin, def.adrelid) 371s end as default , 371s case when s.seqname is not null then 'auto_increment' end as extra 371s from pg_class c 371s join pg_namespace n on n.oid = c.relnamespace 371s left join pg_attribute a on c.oid = a.attrelid 371s join pg_type t on t.oid = a.atttypid and attnum > 0 371s left join pg_attrdef def on a.attrelid = def.adrelid 371s and a.attnum = def.adnum 371s and a.atthasdef 371s left join seqattr s on def.adrelid = s.adrelid 371s and def.adnum = s.adnum 371s 371s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and relkind in ('r', 'f', 'p') 371s and ((n.nspname = 'expected' and c.relname = 'allcols')) 371s 371s 371s order by nspname, relname, attnum; 371s 2024-03-18T16:28:31.985843Z SQL -- params: including 371s -- filter-list-to-where-clause for including 371s -- excluding 371s -- filter-list-to-where-clause for excluding 371s select n.nspname, 371s i.relname, 371s i.oid, 371s rn.nspname, 371s r.relname, 371s indisprimary, 371s indisunique, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.oid 371s and array[attnum::integer] <@ indkey::integer[] 371s ) as cols, 371s pg_get_indexdef(indexrelid), 371s c.conname, 371s pg_get_constraintdef(c.oid) 371s from pg_index x 371s join pg_class i ON i.oid = x.indexrelid 371s join pg_class r ON r.oid = x.indrelid 371s join pg_namespace n ON n.oid = i.relnamespace 371s join pg_namespace rn ON rn.oid = r.relnamespace 371s left join pg_depend d on d.classid = 'pg_class'::regclass 371s and d.objid = i.oid 371s and d.refclassid = 'pg_constraint'::regclass 371s and d.deptype = 'i' 371s left join pg_constraint c ON c.oid = d.refobjid 371s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 371s 371s order by n.nspname, r.relname 371s 2024-03-18T16:28:31.989804Z SQL -- params: including (table) 371s -- filter-list-to-where-clause for including 371s -- excluding (table) 371s -- filter-list-to-where-clause for excluding 371s -- including (ftable) 371s -- filter-list-to-where-clause for including 371s -- excluding (ftable) 371s -- filter-list-to-where-clause for excluding 371s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 371s r.oid, 371s d.refobjid as pkeyoid, 371s conname, 371s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.conrelid 371s and array[attnum::integer] <@ conkey::integer[] 371s ) as conkey, 371s (select string_agg(attname, ',') 371s from pg_attribute 371s where attrelid = r.confrelid 371s and array[attnum::integer] <@ confkey::integer[] 371s ) as confkey, 371s confupdtype, confdeltype, confmatchtype, 371s condeferrable, condeferred 371s from pg_catalog.pg_constraint r 371s JOIN pg_class c on r.conrelid = c.oid 371s JOIN pg_namespace n on c.relnamespace = n.oid 371s JOIN pg_class cf on r.confrelid = cf.oid 371s JOIN pg_namespace nf on cf.relnamespace = nf.oid 371s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 371s and d.objid = r.oid 371s and d.refobjsubid = 0 371s where r.contype = 'f' 371s AND c.relkind in ('r', 'f', 'p') 371s AND cf.relkind in ('r', 'f', 'p') 371s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 371s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 371s and ((n.nspname = 'expected' and c.relname = 'allcols')) 371s 371s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 371s 371s 2024-03-18T16:28:31.989804Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 371s 2024-03-18T16:28:31.989804Z SQL TRUNCATE "expected"."allcols"; 371s 2024-03-18T16:28:32.009608Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 371s 2024-03-18T16:28:32.009608Z DEBUG Reader started for "expected"."allcols" 371s 2024-03-18T16:28:32.009608Z DEBUG start "expected"."allcols" 1440711 371s 2024-03-18T16:28:32.009608Z NOTICE Opening #P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/allcols.out" 371s 2024-03-18T16:28:32.009608Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 371s 2024-03-18T16:28:32.013568Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 371s 2024-03-18T16:28:32.013568Z INFO COPY ON ERROR RESUME NEXT 371s 2024-03-18T16:28:32.080900Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:32.080900Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:32.080900Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:32.080900Z SQL SET search_path TO "expected"; 371s 2024-03-18T16:28:32.080900Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 371s 2024-03-18T16:28:32.084861Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 371s 2024-03-18T16:28:32.088822Z DEBUG stop "expected"."allcols" | 1440711 .. 1519925 = 0.079214d0 371s 2024-03-18T16:28:32.088822Z DEBUG Writer[1] for "expected"."allcols" is done in 0.003961s 371s 2024-03-18T16:28:32.092782Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.003961s 371s 2024-03-18T16:28:32.092782Z LOG report summary reset 371s table name errors read imported bytes total time read write 371s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 371s fetch 0 0 0 0.008s 371s before load 0 2 2 0.087s 371s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 371s "public"."allcols" 0 8 8 0.2 kB 0.107s 0.040s 0.004s 371s "expected"."allcols" 0 8 8 0.2 kB 0.079s 0.004s 371s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 371s Files Processed 0 2 2 0.036s 371s COPY Threads Completion 0 4 4 0.178s 371s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 371s Total import time ✓ 16 16 0.4 kB 0.214s 371s 2024-03-18T16:28:32.195760Z DEBUG CONNECTED TO # 371s 2024-03-18T16:28:32.195760Z DEBUG SET client_encoding TO 'utf8' 371s 2024-03-18T16:28:32.199721Z DEBUG SET work_mem TO '14MB' 371s 2024-03-18T16:28:32.199721Z DEBUG SET standard_conforming_strings TO 'on' 371s 2024-03-18T16:28:32.199721Z DEBUG SET application_name TO 'pgloader' 371s 2024-03-18T16:28:32.203682Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 371s 2024-03-18T16:28:32.203682Z NOTICE Got a diff of 0 rows 371s 2024-03-18T16:28:32.203682Z LOG Regress pass. 371s 2024-03-18T16:28:32.203682Z INFO Stopping monitor 371s Dropping cluster 16/regress ... 373s + rm -rf /tmp/pgloader 373s autopkgtest [16:28:34]: test ssl: -----------------------] 374s autopkgtest [16:28:35]: test ssl: - - - - - - - - - - results - - - - - - - - - - 374s ssl PASS 374s autopkgtest [16:28:35]: test testsuite: preparing testbed 488s autopkgtest [16:30:29]: testbed dpkg architecture: arm64 488s autopkgtest [16:30:29]: testbed apt version: 2.7.12 488s autopkgtest [16:30:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 489s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 489s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [485 kB] 490s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 490s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [51.4 kB] 490s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3728 kB] 490s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [654 kB] 490s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 490s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [33.6 kB] 490s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 490s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [4102 kB] 490s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 490s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [55.3 kB] 490s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 492s Fetched 9245 kB in 2s (5154 kB/s) 492s Reading package lists... 495s Reading package lists... 495s Building dependency tree... 495s Reading state information... 495s Calculating upgrade... 496s The following packages will be REMOVED: 496s libssl3 496s The following NEW packages will be installed: 496s libssl3t64 496s The following packages will be upgraded: 496s openssl 496s 1 upgraded, 1 newly installed, 1 to remove and 0 not upgraded. 496s Need to get 2777 kB of archives. 496s After this operation, 139 kB of additional disk space will be used. 496s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 openssl arm64 3.0.13-0ubuntu2 [985 kB] 496s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libssl3t64 arm64 3.0.13-0ubuntu2 [1793 kB] 497s Fetched 2777 kB in 1s (3950 kB/s) 497s (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 ... 75850 files and directories currently installed.) 497s Preparing to unpack .../openssl_3.0.13-0ubuntu2_arm64.deb ... 497s Unpacking openssl (3.0.13-0ubuntu2) over (3.0.10-1ubuntu4) ... 497s dpkg: libssl3:arm64: dependency problems, but removing anyway as you requested: 497s wget depends on libssl3 (>= 3.0.0). 497s u-boot-tools depends on libssl3 (>= 3.0.0). 497s tnftp depends on libssl3 (>= 3.0.0). 497s tcpdump depends on libssl3 (>= 3.0.0). 497s systemd-resolved depends on libssl3 (>= 3.0.0). 497s systemd depends on libssl3 (>= 3.0.0). 497s sudo depends on libssl3 (>= 3.0.0). 497s sbsigntool depends on libssl3 (>= 3.0.0). 497s rsync depends on libssl3 (>= 3.0.0). 497s python3-cryptography depends on libssl3 (>= 3.0.0). 497s openssh-server depends on libssl3 (>= 3.0.10). 497s openssh-client depends on libssl3 (>= 3.0.10). 497s mtd-utils depends on libssl3 (>= 3.0.0). 497s mokutil depends on libssl3 (>= 3.0.0). 497s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 497s libsystemd-shared:arm64 depends on libssl3 (>= 3.0.0). 497s libssh-4:arm64 depends on libssl3 (>= 3.0.0). 497s libsasl2-modules:arm64 depends on libssl3 (>= 3.0.0). 497s libsasl2-2:arm64 depends on libssl3 (>= 3.0.0). 497s libpython3.12-minimal:arm64 depends on libssl3 (>= 3.0.0). 497s libpython3.11-minimal:arm64 depends on libssl3 (>= 3.0.0). 497s libnvme1 depends on libssl3 (>= 3.0.0). 497s libkrb5-3:arm64 depends on libssl3 (>= 3.0.0). 497s libkmod2:arm64 depends on libssl3 (>= 3.0.0). 497s libfido2-1:arm64 depends on libssl3 (>= 3.0.0). 497s libcurl4:arm64 depends on libssl3 (>= 3.0.0). 497s libcryptsetup12:arm64 depends on libssl3 (>= 3.0.0). 497s kmod depends on libssl3 (>= 3.0.0). 497s dhcpcd-base depends on libssl3 (>= 3.0.0). 497s bind9-libs:arm64 depends on libssl3 (>= 3.0.0). 497s 497s (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 ... 75850 files and directories currently installed.) 497s Removing libssl3:arm64 (3.0.10-1ubuntu4) ... 497s Selecting previously unselected package libssl3t64:arm64. 497s (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 ... 75839 files and directories currently installed.) 497s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu2_arm64.deb ... 497s Unpacking libssl3t64:arm64 (3.0.13-0ubuntu2) ... 497s Setting up libssl3t64:arm64 (3.0.13-0ubuntu2) ... 497s Setting up openssl (3.0.13-0ubuntu2) ... 497s Processing triggers for man-db (2.12.0-3) ... 498s Processing triggers for libc-bin (2.39-0ubuntu2) ... 498s Reading package lists... 498s Building dependency tree... 498s Reading state information... 499s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 499s sh: Attempting to set up Debian/Ubuntu apt sources automatically 499s sh: Distribution appears to be Ubuntu 500s Reading package lists... 500s Building dependency tree... 500s Reading state information... 501s eatmydata is already the newest version (131-1). 501s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 501s Reading package lists... 501s Building dependency tree... 501s Reading state information... 502s dbus is already the newest version (1.14.10-4ubuntu1). 502s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 502s Reading package lists... 502s Building dependency tree... 502s Reading state information... 502s rng-tools-debian is already the newest version (2.4). 502s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 502s Reading package lists... 503s Building dependency tree... 503s Reading state information... 503s The following packages will be REMOVED: 503s cloud-init* python3-configobj* python3-debconf* 503s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 503s After this operation, 3252 kB disk space will be freed. 504s (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 ... 75852 files and directories currently installed.) 504s Removing cloud-init (24.1.1-0ubuntu1) ... 504s Removing python3-configobj (5.0.8-3) ... 504s Removing python3-debconf (1.5.86) ... 504s Processing triggers for man-db (2.12.0-3) ... 504s (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 ... 75463 files and directories currently installed.) 504s Purging configuration files for cloud-init (24.1.1-0ubuntu1) ... 505s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 505s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 505s invoke-rc.d: policy-rc.d denied execution of try-restart. 505s Reading package lists... 505s Building dependency tree... 505s Reading state information... 506s linux-generic is already the newest version (6.8.0-11.11+1). 506s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 506s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 506s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 506s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 508s Reading package lists... 508s Reading package lists... 509s Building dependency tree... 509s Reading state information... 509s Calculating upgrade... 509s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 509s Reading package lists... 510s Building dependency tree... 510s Reading state information... 510s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 510s autopkgtest [16:30:51]: rebooting testbed after setup commands that affected boot 664s Reading package lists... 664s Building dependency tree... 664s Reading state information... 664s Starting pkgProblemResolver with broken count: 0 664s Starting 2 pkgProblemResolver with broken count: 0 664s Done 665s The following additional packages will be installed: 665s freetds-common freetds-dev libct4 libjson-perl libllvm17 libpq5 libsybdb5 665s libxslt1.1 pgloader postgresql-16 postgresql-16-ip4r postgresql-client-16 665s postgresql-client-common postgresql-common ssl-cert 665s Suggested packages: 665s postgresql-doc-16 665s Recommended packages: 665s freetds-doc libjson-xs-perl 665s The following NEW packages will be installed: 665s autopkgtest-satdep freetds-common freetds-dev libct4 libjson-perl libllvm17 665s libpq5 libsybdb5 libxslt1.1 pgloader postgresql-16 postgresql-16-ip4r 665s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 665s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 665s Need to get 68.6 MB/68.6 MB of archives. 665s After this operation, 207 MB of additional disk space will be used. 665s Get:1 /tmp/autopkgtest.wLVUxK/2-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [728 B] 665s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 665s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-common all 257 [36.2 kB] 665s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 665s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-common all 257 [162 kB] 665s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 freetds-common all 1.3.17+ds-2 [26.8 kB] 665s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 libct4 arm64 1.3.17+ds-2 [163 kB] 665s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 libsybdb5 arm64 1.3.17+ds-2 [184 kB] 665s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 freetds-dev arm64 1.3.17+ds-2 [298 kB] 666s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17 arm64 1:17.0.6-5build1 [25.0 MB] 668s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 libpq5 arm64 16.2-1 [136 kB] 668s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 libxslt1.1 arm64 1.1.35-1 [161 kB] 668s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-16 arm64 16.2-1 [1260 kB] 668s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-16 arm64 16.2-1 [15.2 MB] 669s Get:15 http://ftpmaster.internal/ubuntu noble/universe arm64 postgresql-16-ip4r arm64 2.4.2-2 [206 kB] 669s Get:16 http://ftpmaster.internal/ubuntu noble/universe arm64 pgloader arm64 3.6.10-1 [25.6 MB] 670s Preconfiguring packages ... 670s Fetched 68.6 MB in 5s (14.3 MB/s) 670s Selecting previously unselected package libjson-perl. 670s (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 ... 75408 files and directories currently installed.) 670s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 670s Unpacking libjson-perl (4.10000-1) ... 670s Selecting previously unselected package postgresql-client-common. 670s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 670s Unpacking postgresql-client-common (257) ... 670s Selecting previously unselected package ssl-cert. 670s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 670s Unpacking ssl-cert (1.1.2ubuntu1) ... 670s Selecting previously unselected package postgresql-common. 670s Preparing to unpack .../03-postgresql-common_257_all.deb ... 670s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 670s Unpacking postgresql-common (257) ... 670s Selecting previously unselected package freetds-common. 670s Preparing to unpack .../04-freetds-common_1.3.17+ds-2_all.deb ... 670s Unpacking freetds-common (1.3.17+ds-2) ... 670s Selecting previously unselected package libct4:arm64. 670s Preparing to unpack .../05-libct4_1.3.17+ds-2_arm64.deb ... 670s Unpacking libct4:arm64 (1.3.17+ds-2) ... 670s Selecting previously unselected package libsybdb5:arm64. 670s Preparing to unpack .../06-libsybdb5_1.3.17+ds-2_arm64.deb ... 670s Unpacking libsybdb5:arm64 (1.3.17+ds-2) ... 670s Selecting previously unselected package freetds-dev. 670s Preparing to unpack .../07-freetds-dev_1.3.17+ds-2_arm64.deb ... 670s Unpacking freetds-dev (1.3.17+ds-2) ... 670s Selecting previously unselected package libllvm17:arm64. 670s Preparing to unpack .../08-libllvm17_1%3a17.0.6-5build1_arm64.deb ... 670s Unpacking libllvm17:arm64 (1:17.0.6-5build1) ... 671s Selecting previously unselected package libpq5:arm64. 671s Preparing to unpack .../09-libpq5_16.2-1_arm64.deb ... 671s Unpacking libpq5:arm64 (16.2-1) ... 671s Selecting previously unselected package libxslt1.1:arm64. 671s Preparing to unpack .../10-libxslt1.1_1.1.35-1_arm64.deb ... 671s Unpacking libxslt1.1:arm64 (1.1.35-1) ... 671s Selecting previously unselected package postgresql-client-16. 671s Preparing to unpack .../11-postgresql-client-16_16.2-1_arm64.deb ... 671s Unpacking postgresql-client-16 (16.2-1) ... 671s Selecting previously unselected package postgresql-16. 671s Preparing to unpack .../12-postgresql-16_16.2-1_arm64.deb ... 671s Unpacking postgresql-16 (16.2-1) ... 672s Selecting previously unselected package postgresql-16-ip4r. 672s Preparing to unpack .../13-postgresql-16-ip4r_2.4.2-2_arm64.deb ... 672s Unpacking postgresql-16-ip4r (2.4.2-2) ... 672s Selecting previously unselected package pgloader. 672s Preparing to unpack .../14-pgloader_3.6.10-1_arm64.deb ... 672s Unpacking pgloader (3.6.10-1) ... 672s Selecting previously unselected package autopkgtest-satdep. 672s Preparing to unpack .../15-2-autopkgtest-satdep.deb ... 672s Unpacking autopkgtest-satdep (0) ... 672s Setting up postgresql-client-common (257) ... 672s Setting up libpq5:arm64 (16.2-1) ... 672s Setting up ssl-cert (1.1.2ubuntu1) ... 672s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 673s Setting up libjson-perl (4.10000-1) ... 673s Setting up libxslt1.1:arm64 (1.1.35-1) ... 673s Setting up freetds-common (1.3.17+ds-2) ... 673s Setting up libllvm17:arm64 (1:17.0.6-5build1) ... 673s Setting up postgresql-client-16 (16.2-1) ... 673s 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 673s Setting up libsybdb5:arm64 (1.3.17+ds-2) ... 673s Setting up libct4:arm64 (1.3.17+ds-2) ... 673s Setting up postgresql-common (257) ... 674s 674s Creating config file /etc/postgresql-common/createcluster.conf with new version 674s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 674s Removing obsolete dictionary files: 674s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 675s Setting up postgresql-16 (16.2-1) ... 675s Creating new PostgreSQL cluster 16/main ... 675s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 675s The files belonging to this database system will be owned by user "postgres". 675s This user must also own the server process. 675s 675s The database cluster will be initialized with locale "C.UTF-8". 675s The default database encoding has accordingly been set to "UTF8". 675s The default text search configuration will be set to "english". 675s 675s Data page checksums are disabled. 675s 675s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 675s creating subdirectories ... ok 675s selecting dynamic shared memory implementation ... posix 675s selecting default max_connections ... 100 675s selecting default shared_buffers ... 128MB 675s selecting default time zone ... Etc/UTC 675s creating configuration files ... ok 675s running bootstrap script ... ok 676s performing post-bootstrap initialization ... ok 676s syncing data to disk ... ok 679s Setting up freetds-dev (1.3.17+ds-2) ... 679s Setting up pgloader (3.6.10-1) ... 679s Setting up postgresql-16-ip4r (2.4.2-2) ... 679s Setting up autopkgtest-satdep (0) ... 679s Processing triggers for man-db (2.12.0-3) ... 680s Processing triggers for libc-bin (2.39-0ubuntu2) ... 682s (Reading database ... 77527 files and directories currently installed.) 682s Removing autopkgtest-satdep (0) ... 688s autopkgtest [16:33:49]: test testsuite: [----------------------- 688s + PGSUPERUSER=ubuntu 688s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 688s Creating new PostgreSQL cluster 16/regress ... 691s make: Entering directory '/tmp/autopkgtest.wLVUxK/build.1s7/src/test' 691s dropdb -U ubuntu pgloader 691s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 691s dropdb -U ubuntu stocks 691s make: [Makefile:67: prepare] Error 1 (ignored) 691s dropdb: error: database removal failed: ERROR: database "stocks" does not exist 691s dropdb -U ubuntu ip4r 691s make: [Makefile:68: prepare] Error 1 (ignored) 691s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 691s createuser -U ubuntu --superuser `whoami` 691s make: [Makefile:69: prepare] Error 1 (ignored) 691s createdb -U ubuntu -O `whoami` pgloader 691s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 691s make: [Makefile:70: prepare] Error 1 (ignored) 691s createdb -U ubuntu -O `whoami` stocks 691s createdb -U ubuntu -O `whoami` ip4r 691s psql -d pgloader -c 'create schema expected' 692s CREATE SCHEMA 692s psql -U ubuntu -d pgloader -c 'create extension ip4r' 692s CREATE EXTENSION 692s psql -U ubuntu -d ip4r -c 'create extension ip4r' 692s CREATE EXTENSION 692s psql -d stocks -f bossa.sql 692s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 692s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 692s DROP TABLE 692s CREATE TABLE 692s CREATE TABLE 692s rm -f regress/out/* 692s pgloader --regress allcols.load 692s 2024-03-18T16:33:53.040873Z LOG pgloader version "3.6.7~devel" 692s 2024-03-18T16:33:53.106268Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 693s 2024-03-18T16:33:53.425070Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 693s 2024-03-18T16:33:53.425070Z WARNING That could impact loading performance badly. 693s 2024-03-18T16:33:53.425070Z WARNING Consider the option 'drop indexes'. 693s 2024-03-18T16:33:53.555689Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 693s 2024-03-18T16:33:53.596452Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/allcols.out") 693s 2024-03-18T16:33:53.633139Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 693s 2024-03-18T16:33:53.796192Z LOG report summary reset 693s table name errors rows bytes total time 693s ----------------------- --------- --------- --------- -------------- 693s fetch 0 0 0.008s 693s before load 0 2 0.045s 693s ----------------------- --------- --------- --------- -------------- 693s "public"."allcols" 0 8 0.2 kB 0.069s 693s "expected"."allcols" 0 8 0.2 kB 0.033s 693s ----------------------- --------- --------- --------- -------------- 693s Files Processed 0 2 0.057s 693s COPY Threads Completion 0 4 0.098s 693s ----------------------- --------- --------- --------- -------------- 693s Total import time ✓ 16 0.4 kB 0.155s 693s 2024-03-18T16:33:53.865489Z LOG Regress pass. 693s touch regress/out/allcols.out 693s pgloader --regress csv-before-after.load 694s 2024-03-18T16:33:54.036687Z LOG pgloader version "3.6.7~devel" 694s 2024-03-18T16:33:54.740530Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-before-after.out") 694s 2024-03-18T16:33:54.777131Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 694s 2024-03-18T16:33:54.976402Z LOG report summary reset 695s table name errors rows bytes total time 695s ----------------------- --------- --------- --------- -------------- 695s fetch 0 0 0.008s 695s before load 0 6 0.045s 695s ----------------------- --------- --------- --------- -------------- 695s "csv"."blocks" 0 460 15.9 kB 0.203s 695s "expected"."blocks" 0 460 12.4 kB 0.085s 695s ----------------------- --------- --------- --------- -------------- 695s Files Processed 0 2 0.057s 695s COPY Threads Completion 0 4 0.277s 695s after load 0 1 0.041s 695s ----------------------- --------- --------- --------- -------------- 695s Total import time ✓ 920 28.2 kB 0.374s 695s 2024-03-18T16:33:55.053671Z LOG Regress pass. 695s touch regress/out/csv-before-after.out 695s pgloader --regress csv-districts.load 695s 2024-03-18T16:33:56.036526Z LOG pgloader version "3.6.7~devel" 696s 2024-03-18T16:33:56.730413Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-districts.out") 696s 2024-03-18T16:33:56.766873Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 696s 2024-03-18T16:33:56.949174Z LOG report summary reset 696s table name errors rows bytes total time 696s ----------------------- --------- --------- --------- -------------- 696s fetch 0 0 0.004s 696s before load 0 2 0.049s 696s ----------------------- --------- --------- --------- -------------- 696s "public"."districts" 0 440 29.3 kB 0.264s 696s "expected"."districts" 0 440 29.1 kB 0.049s 696s ----------------------- --------- --------- --------- -------------- 696s Files Processed 0 2 0.053s 696s COPY Threads Completion 0 4 0.308s 696s ----------------------- --------- --------- --------- -------------- 696s Total import time ✓ 880 58.3 kB 0.361s 696s 2024-03-18T16:33:57.046401Z LOG Regress pass. 696s touch regress/out/csv-districts.out 696s pgloader --regress csv-parse-date.load 696s 2024-03-18T16:33:57.036460Z LOG pgloader version "3.6.7~devel" 697s 2024-03-18T16:33:57.534197Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-parse-date.out") 697s 2024-03-18T16:33:57.570600Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 697s 2024-03-18T16:33:57.724299Z LOG report summary reset 697s table name errors rows bytes total time 697s ----------------------- --------- --------- --------- -------------- 697s fetch 0 0 0.008s 697s before load 0 2 0.044s 697s ----------------------- --------- --------- --------- -------------- 697s "public"."dateformat" 0 4 0.1 kB 0.085s 697s "expected"."dateformat" 0 4 0.1 kB 0.040s 697s ----------------------- --------- --------- --------- -------------- 697s Files Processed 0 2 0.044s 697s COPY Threads Completion 0 4 0.121s 697s ----------------------- --------- --------- --------- -------------- 697s Total import time ✓ 8 0.3 kB 0.166s 697s 2024-03-18T16:33:57.801148Z LOG Regress pass. 697s touch regress/out/csv-parse-date.out 697s pgloader --regress csv-error.load 698s 2024-03-18T16:33:59.032313Z LOG pgloader version "3.6.7~devel" 698s 2024-03-18T16:33:59.464501Z FATAL :ASCII stream decoding error on 698s #: 698s 698s the octet sequence #(195) cannot be decoded. 698s 2024-03-18T16:33:59.480658Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 698s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 698s 2024-03-18T16:33:59.533166Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-error.out") 698s 2024-03-18T16:33:59.569519Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 698s 2024-03-18T16:33:59.727044Z LOG report summary reset 698s table name errors rows bytes total time 698s ----------------------- --------- --------- --------- -------------- 698s fetch 0 0 0.008s 698s before load 0 2 0.040s 698s ----------------------- --------- --------- --------- -------------- 698s "public"."jordane" 3 3 0.1 kB 0.089s 698s "expected"."jordane" 0 3 0.1 kB 0.040s 698s ----------------------- --------- --------- --------- -------------- 698s Files Processed 0 2 0.044s 698s COPY Threads Completion 0 4 0.125s 698s ----------------------- --------- --------- --------- -------------- 698s Total import time 3 6 0.2 kB 0.170s 698s 2024-03-18T16:33:59.799749Z LOG Regress pass. 698s touch regress/out/csv-error.out 698s pgloader --regress csv-escape-mode.load 699s 2024-03-18T16:34:00.032274Z LOG pgloader version "3.6.7~devel" 699s 2024-03-18T16:34:00.383254Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 699s 2024-03-18T16:34:00.383254Z WARNING That could impact loading performance badly. 699s 2024-03-18T16:34:00.383254Z WARNING Consider the option 'drop indexes'. 699s 2024-03-18T16:34:00.572862Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-escape-mode.out") 700s 2024-03-18T16:34:00.609170Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 700s 2024-03-18T16:34:00.770449Z LOG report summary reset 700s table name errors rows bytes total time 700s ---------------------------- --------- --------- --------- -------------- 700s fetch 0 0 0.008s 700s before load 0 2 0.044s 700s ---------------------------- --------- --------- --------- -------------- 700s "public"."csv_escape_mode" 0 5 0.1 kB 0.097s 700s "expected"."csv_escape_mode" 0 5 0.1 kB 0.036s 700s ---------------------------- --------- --------- --------- -------------- 700s Files Processed 0 2 0.044s 700s COPY Threads Completion 0 4 0.129s 700s ---------------------------- --------- --------- --------- -------------- 700s Total import time ✓ 10 0.2 kB 0.173s 700s 2024-03-18T16:34:00.847018Z LOG Regress pass. 700s touch regress/out/csv-escape-mode.out 700s pgloader --regress csv-filename-pattern.load 700s 2024-03-18T16:34:01.036270Z LOG pgloader version "3.6.7~devel" 701s 2024-03-18T16:34:01.644560Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-filename-pattern.out") 701s 2024-03-18T16:34:01.680796Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 701s 2024-03-18T16:34:01.833793Z LOG report summary reset 701s table name errors rows bytes total time 701s ----------------------- --------- --------- --------- -------------- 701s fetch 0 0 0.004s 701s before load 0 2 0.044s 701s ----------------------- --------- --------- --------- -------------- 701s "public"."matching" 0 3 0.0 kB 0.060s 701s "expected"."matching" 0 3 0.0 kB 0.040s 701s ----------------------- --------- --------- --------- -------------- 701s Files Processed 0 4 0.048s 701s COPY Threads Completion 0 8 0.221s 701s ----------------------- --------- --------- --------- -------------- 701s Total import time ✓ 6 0.0 kB 0.270s 701s 2024-03-18T16:34:01.910291Z LOG Regress pass. 701s touch regress/out/csv-filename-pattern.out 701s pgloader --regress csv-guess.load 702s 2024-03-18T16:34:02.036237Z LOG pgloader version "3.6.7~devel" 702s 2024-03-18T16:34:02.386246Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 702s 2024-03-18T16:34:02.390269Z WARNING That could impact loading performance badly. 702s 2024-03-18T16:34:02.390269Z WARNING Consider the option 'drop indexes'. 702s 2024-03-18T16:34:02.885090Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-guess.out") 702s 2024-03-18T16:34:02.921296Z WARNING PostgreSQL warning: table "track" does not exist, skipping 703s 2024-03-18T16:34:03.162592Z LOG report summary reset 703s table name errors rows bytes total time 703s ----------------------- --------- --------- --------- -------------- 703s fetch 0 0 0.008s 703s before load 0 2 0.044s 703s ----------------------- --------- --------- --------- -------------- 703s "csv"."track" 0 3503 366.8 kB 0.398s 703s "expected"."track" 0 3503 366.8 kB 0.117s 703s ----------------------- --------- --------- --------- -------------- 703s Files Processed 0 2 0.056s 703s COPY Threads Completion 0 4 0.511s 703s ----------------------- --------- --------- --------- -------------- 703s Total import time ✓ 7006 733.5 kB 0.567s 703s 2024-03-18T16:34:03.251034Z LOG Regress pass. 703s touch regress/out/csv-guess.out 703s pgloader --regress csv-header.load 703s 2024-03-18T16:34:04.032161Z LOG pgloader version "3.6.7~devel" 704s 2024-03-18T16:34:04.534566Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-header.out") 704s 2024-03-18T16:34:04.570724Z WARNING PostgreSQL warning: table "group" does not exist, skipping 704s 2024-03-18T16:34:04.723391Z LOG report summary reset 704s table name errors rows bytes total time 704s ----------------------- --------- --------- --------- -------------- 704s fetch 0 0 0.004s 704s before load 0 2 0.044s 704s ----------------------- --------- --------- --------- -------------- 704s "public"."group" 0 2 0.0 kB 0.052s 704s "expected"."group" 0 2 0.0 kB 0.040s 704s ----------------------- --------- --------- --------- -------------- 704s Files Processed 0 2 0.072s 704s COPY Threads Completion 0 4 0.092s 704s ----------------------- --------- --------- --------- -------------- 704s Total import time ✓ 4 0.1 kB 0.165s 704s 2024-03-18T16:34:04.799724Z LOG Regress pass. 704s touch regress/out/csv-header.out 704s pgloader --regress csv-json.load 704s 2024-03-18T16:34:05.032140Z LOG pgloader version "3.6.7~devel" 705s 2024-03-18T16:34:05.526089Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-json.out") 705s 2024-03-18T16:34:05.558212Z WARNING PostgreSQL warning: table "json" does not exist, skipping 705s 2024-03-18T16:34:05.714810Z LOG report summary reset 705s table name errors rows bytes total time 705s ----------------------- --------- --------- --------- -------------- 705s fetch 0 0 0.004s 705s before load 0 2 0.044s 705s ----------------------- --------- --------- --------- -------------- 705s "public"."json" 0 15 1.1 kB 0.076s 705s "expected"."json" 0 15 1.1 kB 0.036s 705s ----------------------- --------- --------- --------- -------------- 705s Files Processed 0 2 0.040s 705s COPY Threads Completion 0 4 0.116s 705s ----------------------- --------- --------- --------- -------------- 705s Total import time ✓ 30 2.3 kB 0.157s 705s 2024-03-18T16:34:05.787087Z LOG Regress pass. 705s touch regress/out/csv-json.out 705s pgloader --regress csv-keep-extra-blanks.load 706s 2024-03-18T16:34:07.028094Z LOG pgloader version "3.6.7~devel" 706s 2024-03-18T16:34:07.525762Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-keep-extra-blanks.out") 706s 2024-03-18T16:34:07.553856Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 706s 2024-03-18T16:34:07.710379Z LOG report summary reset 706s table name errors rows bytes total time 706s ----------------------- --------- --------- --------- -------------- 706s fetch 0 0 0.004s 706s before load 0 2 0.044s 706s ----------------------- --------- --------- --------- -------------- 706s "public"."nulls" 0 7 0.3 kB 0.080s 706s "expected"."nulls" 0 6 0.3 kB 0.036s 706s ----------------------- --------- --------- --------- -------------- 706s Files Processed 0 2 0.044s 706s COPY Threads Completion 0 4 0.120s 706s ----------------------- --------- --------- --------- -------------- 706s Total import time ✓ 13 0.6 kB 0.165s 706s 2024-03-18T16:34:07.782621Z LOG Regress pass. 706s touch regress/out/csv-keep-extra-blanks.out 706s pgloader --regress csv-missing-col.load 707s 2024-03-18T16:34:08.036106Z LOG pgloader version "3.6.7~devel" 707s 2024-03-18T16:34:08.473388Z LOG COPY INIT ERROR 707s 2024-03-18T16:34:08.477400Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 707s Database error 42703: column "c" of relation "missingcol" does not exist 707s 2024-03-18T16:34:08.525541Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-missing-col.out") 707s 2024-03-18T16:34:08.561647Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 708s 2024-03-18T16:34:08.718106Z LOG report summary reset 708s table name errors rows bytes total time 708s ----------------------- --------- --------- --------- -------------- 708s fetch 0 0 0.008s 708s before load 0 2 0.040s 708s ----------------------- --------- --------- --------- -------------- 708s "public"."missingcol" 1 0 0.064s 708s "expected"."missingcol" 0 0 0.044s 708s ----------------------- --------- --------- --------- -------------- 708s Files Processed 0 2 0.048s 708s COPY Threads Completion 0 4 0.120s 708s ----------------------- --------- --------- --------- -------------- 708s Total import time 1 0 0.168s 708s 2024-03-18T16:34:08.794307Z LOG Regress pass. 708s touch regress/out/csv-missing-col.out 708s pgloader --regress csv-non-printable.load 708s 2024-03-18T16:34:09.040103Z LOG pgloader version "3.6.7~devel" 709s 2024-03-18T16:34:09.537365Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-non-printable.out") 709s 2024-03-18T16:34:09.569437Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 709s 2024-03-18T16:34:09.725787Z LOG report summary reset 709s table name errors rows bytes total time 709s ----------------------- --------- --------- --------- -------------- 709s fetch 0 0 0.008s 709s before load 0 2 0.040s 709s ----------------------- --------- --------- --------- -------------- 709s "public"."tab_csv" 0 7 0.2 kB 0.080s 709s "expected"."tab_csv" 0 7 0.2 kB 0.036s 709s ----------------------- --------- --------- --------- -------------- 709s Files Processed 0 2 0.044s 709s COPY Threads Completion 0 4 0.116s 709s ----------------------- --------- --------- --------- -------------- 709s Total import time ✓ 14 0.4 kB 0.160s 709s 2024-03-18T16:34:09.797949Z LOG Regress pass. 709s touch regress/out/csv-non-printable.out 709s pgloader --regress csv-nulls.load 709s 2024-03-18T16:34:10.028063Z LOG pgloader version "3.6.7~devel" 710s 2024-03-18T16:34:10.376818Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 710s 2024-03-18T16:34:10.376818Z WARNING That could impact loading performance badly. 710s 2024-03-18T16:34:10.376818Z WARNING Consider the option 'drop indexes'. 710s 2024-03-18T16:34:10.541142Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-nulls.out") 710s 2024-03-18T16:34:10.577213Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 710s 2024-03-18T16:34:10.733519Z LOG report summary reset 710s table name errors rows bytes total time 710s ----------------------- --------- --------- --------- -------------- 710s fetch 0 0 0.008s 710s before load 0 2 0.044s 710s ----------------------- --------- --------- --------- -------------- 710s "public"."nullif" 0 2 0.0 kB 0.068s 710s "expected"."nullif" 0 2 0.0 kB 0.036s 710s ----------------------- --------- --------- --------- -------------- 710s Files Processed 0 2 0.052s 710s COPY Threads Completion 0 4 0.108s 710s ----------------------- --------- --------- --------- -------------- 710s Total import time ✓ 4 0.1 kB 0.160s 710s 2024-03-18T16:34:10.805661Z LOG Regress pass. 710s touch regress/out/csv-nulls.out 710s pgloader --regress csv-temp.load 711s 2024-03-18T16:34:11.036072Z LOG pgloader version "3.6.7~devel" 711s 2024-03-18T16:34:11.528924Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-temp.out") 711s 2024-03-18T16:34:11.568993Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 711s 2024-03-18T16:34:11.725261Z LOG report summary reset 711s table name errors rows bytes total time 711s ----------------------- --------- --------- --------- -------------- 711s fetch 0 0 0.008s 711s before load 0 2 0.040s 711s ----------------------- --------- --------- --------- -------------- 711s "public"."temp" 0 5 0.2 kB 0.080s 711s "expected"."temp" 0 5 0.2 kB 0.036s 711s ----------------------- --------- --------- --------- -------------- 711s Files Processed 0 2 0.048s 711s COPY Threads Completion 0 4 0.116s 711s ----------------------- --------- --------- --------- -------------- 711s Total import time ✓ 10 0.3 kB 0.164s 711s 2024-03-18T16:34:11.793379Z LOG Regress pass. 711s touch regress/out/csv-temp.out 711s pgloader --regress csv-trim-extra-blanks.load 712s 2024-03-18T16:34:13.036055Z LOG pgloader version "3.6.7~devel" 712s 2024-03-18T16:34:13.544820Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-trim-extra-blanks.out") 713s 2024-03-18T16:34:13.745122Z LOG report summary reset 713s table name errors rows bytes total time 713s ----------------------- --------- --------- --------- -------------- 713s fetch 0 0 0.008s 713s before load 0 2 0.044s 713s ----------------------- --------- --------- --------- -------------- 713s "public"."nulls" 0 7 0.3 kB 0.084s 713s "expected"."nulls" 0 7 0.3 kB 0.040s 713s ----------------------- --------- --------- --------- -------------- 713s Files Processed 0 2 0.044s 713s COPY Threads Completion 0 4 0.124s 713s ----------------------- --------- --------- --------- -------------- 713s Total import time ✓ 14 0.6 kB 0.168s 713s 2024-03-18T16:34:13.817223Z LOG Regress pass. 713s touch regress/out/csv-trim-extra-blanks.out 713s pgloader --regress csv-using-sexp.load 713s 2024-03-18T16:34:14.036047Z LOG pgloader version "3.6.7~devel" 714s 2024-03-18T16:34:14.540703Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv-using-sexp.out") 714s 2024-03-18T16:34:14.580748Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 714s 2024-03-18T16:34:14.740933Z LOG report summary reset 714s table name errors rows bytes total time 714s ----------------------- --------- --------- --------- -------------- 714s fetch 0 0 0.008s 714s before load 0 2 0.044s 714s ----------------------- --------- --------- --------- -------------- 714s "public"."sexp" 0 3 0.0 kB 0.080s 714s "expected"."sexp" 0 3 0.0 kB 0.040s 714s ----------------------- --------- --------- --------- -------------- 714s Files Processed 0 2 0.052s 714s COPY Threads Completion 0 4 0.112s 714s ----------------------- --------- --------- --------- -------------- 714s Total import time ✓ 6 0.1 kB 0.164s 714s 2024-03-18T16:34:14.821025Z LOG Regress pass. 714s touch regress/out/csv-using-sexp.out 714s pgloader --regress csv.load 714s 2024-03-18T16:34:15.032037Z LOG pgloader version "3.6.7~devel" 714s 2024-03-18T16:34:15.112129Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 715s 2024-03-18T16:34:15.532564Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 715s 2024-03-18T16:34:15.576607Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/csv.out") 715s 2024-03-18T16:34:15.604635Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 715s 2024-03-18T16:34:15.760793Z LOG report summary reset 715s table name errors rows bytes total time 715s ----------------------- --------- --------- --------- -------------- 715s fetch 0 0 0.008s 715s before load 0 2 0.040s 715s ----------------------- --------- --------- --------- -------------- 715s "public"."csv" 0 6 0.2 kB 0.080s 715s "expected"."csv" 0 6 0.2 kB 0.040s 715s ----------------------- --------- --------- --------- -------------- 715s Files Processed 0 2 0.040s 715s COPY Threads Completion 0 4 0.120s 715s ----------------------- --------- --------- --------- -------------- 715s Total import time ✓ 12 0.4 kB 0.160s 715s 2024-03-18T16:34:15.836870Z LOG Regress pass. 715s touch regress/out/csv.out 715s pgloader --regress copy.load 716s 2024-03-18T16:34:17.032028Z LOG pgloader version "3.6.7~devel" 716s 2024-03-18T16:34:17.084074Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 716s 2024-03-18T16:34:17.656579Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 716s 2024-03-18T16:34:17.692611Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/copy.out") 716s 2024-03-18T16:34:17.728642Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 717s 2024-03-18T16:34:17.968847Z LOG report summary reset 717s table name errors rows bytes total time 717s ----------------------- --------- --------- --------- -------------- 717s fetch 0 0 0.008s 717s before load 0 2 0.044s 717s ----------------------- --------- --------- --------- -------------- 717s "public"."track_full" 0 3503 366.8 kB 0.132s 717s "expected"."track_full" 0 3503 366.8 kB 0.120s 717s ----------------------- --------- --------- --------- -------------- 717s Files Processed 0 2 0.048s 717s COPY Threads Completion 0 4 0.248s 717s Index Build Completion 0 0 0.036s 717s Create Indexes 0 1 0.000s 717s Constraints 0 1 0.000s 717s ----------------------- --------- --------- --------- -------------- 717s Total import time ✓ 7006 733.5 kB 0.332s 717s 2024-03-18T16:34:18.044906Z LOG Regress pass. 717s touch regress/out/copy.out 717s pgloader --regress copy-hex.load 717s 2024-03-18T16:34:18.032025Z LOG pgloader version "3.6.7~devel" 718s 2024-03-18T16:34:18.500380Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/copy-hex.out") 718s 2024-03-18T16:34:18.540407Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 718s 2024-03-18T16:34:18.692509Z LOG report summary reset 718s table name errors rows bytes total time 718s ----------------------- --------- --------- --------- -------------- 718s fetch 0 0 0.004s 718s before load 0 2 0.044s 718s ----------------------- --------- --------- --------- -------------- 718s "public"."copyhex" 0 6 0.0 kB 0.068s 718s "expected"."copyhex" 0 6 0.0 kB 0.040s 718s ----------------------- --------- --------- --------- -------------- 718s Files Processed 0 2 0.036s 718s COPY Threads Completion 0 4 0.104s 718s ----------------------- --------- --------- --------- -------------- 718s Total import time ✓ 12 0.1 kB 0.140s 718s 2024-03-18T16:34:18.764558Z LOG Regress pass. 718s touch regress/out/copy-hex.out 718s pgloader --regress dbf.load 718s 2024-03-18T16:34:19.036024Z LOG pgloader version "3.6.7~devel" 719s 2024-03-18T16:34:19.208141Z LOG Migrating from # 719s 2024-03-18T16:34:19.208141Z LOG Migrating into # 719s 2024-03-18T16:34:19.400274Z WARNING Forcing encoding to CP850, db3 file has ASCII 719s 2024-03-18T16:34:19.540374Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/dbf.out") 719s 2024-03-18T16:34:19.576399Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 719s 2024-03-18T16:34:19.772537Z LOG report summary reset 719s table name errors rows bytes total time 719s ----------------------- --------- --------- --------- -------------- 719s fetch 0 0 0.004s 719s Create Schemas 0 0 0.000s 719s Create SQL Types 0 0 0.012s 719s Create tables 0 2 0.024s 719s ----------------------- --------- --------- --------- -------------- 719s public.reg2013 0 27 1.0 kB 0.056s 719s "expected"."reg2013" 0 27 1.0 kB 0.044s 719s ----------------------- --------- --------- --------- -------------- 719s COPY Threads Completion 0 6 0.088s 719s Create Triggers 0 0 0.000s 719s Install Comments 0 0 0.000s 719s Files Processed 0 1 0.012s 719s ----------------------- --------- --------- --------- -------------- 719s Total import time ✓ 54 1.9 kB 0.100s 719s 2024-03-18T16:34:19.844588Z LOG Regress pass. 719s touch regress/out/dbf.out 719s pgloader --regress errors.load 720s 2024-03-18T16:34:21.028030Z LOG pgloader version "3.6.7~devel" 720s 2024-03-18T16:34:21.088093Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 720s 2024-03-18T16:34:21.372394Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 720s 2024-03-18T16:34:21.372394Z WARNING That could impact loading performance badly. 720s 2024-03-18T16:34:21.372394Z WARNING Consider the option 'drop indexes'. 720s 2024-03-18T16:34:21.464491Z ERROR End of file while collecting quoted item: # 720s 2024-03-18T16:34:21.464491Z FATAL End of file while collecting quoted item: # 720s 2024-03-18T16:34:21.484512Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 720s HINT: Perhaps you need a different "datestyle" setting. 720s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 720s 2024-03-18T16:34:21.484512Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 720s HINT: Perhaps you need a different "datestyle" setting. 720s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 720s 2024-03-18T16:34:21.484512Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 720s HINT: Perhaps you need a different "datestyle" setting. 720s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 720s 2024-03-18T16:34:21.500529Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 720s 2024-03-18T16:34:21.540571Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/errors.out") 720s 2024-03-18T16:34:21.572605Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 720s 2024-03-18T16:34:21.728769Z LOG report summary reset 720s table name errors rows bytes total time 720s ----------------------- --------- --------- --------- -------------- 720s fetch 0 0 0.008s 720s before load 0 4 0.044s 720s ----------------------- --------- --------- --------- -------------- 720s "err"."errors" 8 7 0.3 kB 0.068s 720s "expected"."errors" 0 7 0.2 kB 0.040s 720s ----------------------- --------- --------- --------- -------------- 720s Files Processed 0 2 0.052s 720s COPY Threads Completion 0 4 0.108s 720s ----------------------- --------- --------- --------- -------------- 720s Total import time 8 14 0.6 kB 0.160s 720s 2024-03-18T16:34:21.820866Z LOG Regress pass. 720s touch regress/out/errors.out 720s pgloader --regress fixed.load 721s 2024-03-18T16:34:22.044044Z LOG pgloader version "3.6.7~devel" 721s 2024-03-18T16:34:22.092092Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 721s 2024-03-18T16:34:22.572571Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 721s 2024-03-18T16:34:22.608606Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/fixed.out") 722s 2024-03-18T16:34:22.640638Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 722s 2024-03-18T16:34:22.792785Z LOG report summary reset 722s table name errors rows bytes total time 722s ----------------------- --------- --------- --------- -------------- 722s fetch 0 0 0.008s 722s before load 0 2 0.044s 722s ----------------------- --------- --------- --------- -------------- 722s "public"."fixed" 0 5 0.2 kB 0.056s 722s "expected"."fixed" 0 5 0.2 kB 0.040s 722s ----------------------- --------- --------- --------- -------------- 722s Files Processed 0 2 0.040s 722s COPY Threads Completion 0 4 0.092s 722s Index Build Completion 0 0 0.036s 722s Create Indexes 0 1 0.004s 722s Constraints 0 1 0.000s 722s ----------------------- --------- --------- --------- -------------- 722s Total import time ✓ 10 0.4 kB 0.172s 722s 2024-03-18T16:34:22.868856Z LOG Regress pass. 722s touch regress/out/fixed.out 722s pgloader --regress fields-with-periods.load 722s 2024-03-18T16:34:23.036034Z LOG pgloader version "3.6.7~devel" 723s 2024-03-18T16:34:23.508473Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/fields-with-periods.out") 723s 2024-03-18T16:34:23.708651Z LOG report summary reset 723s table name errors rows bytes total time 723s ----------------------- --------- --------- --------- -------------- 723s fetch 0 0 0.008s 723s before load 0 2 0.044s 723s ----------------------- --------- --------- --------- -------------- 723s "public"."fixed" 0 3 0.0 kB 0.068s 723s "expected"."fixed" 0 3 0.0 kB 0.036s 723s ----------------------- --------- --------- --------- -------------- 723s Files Processed 0 2 0.040s 723s COPY Threads Completion 0 4 0.108s 723s ----------------------- --------- --------- --------- -------------- 723s Total import time ✓ 6 0.0 kB 0.148s 723s 2024-03-18T16:34:23.784718Z LOG Regress pass. 723s touch regress/out/fields-with-periods.out 723s pgloader --regress ixf.load 723s 2024-03-18T16:34:24.028025Z LOG pgloader version "3.6.7~devel" 724s 2024-03-18T16:34:24.240210Z LOG Migrating from # 724s 2024-03-18T16:34:24.240210Z LOG Migrating into # 724s 2024-03-18T16:34:24.580496Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/ixf.out") 724s 2024-03-18T16:34:24.612523Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 724s 2024-03-18T16:34:24.800682Z LOG report summary reset 724s table name errors rows bytes total time 724s ----------------------- --------- --------- --------- -------------- 724s fetch 0 0 0.004s 724s before load 0 3 0.044s 724s Create Schemas 0 0 0.000s 724s Create SQL Types 0 0 0.008s 724s Create tables 0 2 0.028s 724s ----------------------- --------- --------- --------- -------------- 724s nsitra.test1 0 4 0.2 kB 0.048s 724s "expected"."test1" 0 4 0.2 kB 0.040s 724s ----------------------- --------- --------- --------- -------------- 724s COPY Threads Completion 0 6 0.072s 724s Index Build Completion 0 0 0.004s 724s Primary Keys 0 0 0.000s 724s Create Triggers 0 0 0.000s 724s Install Comments 0 0 0.000s 724s Files Processed 0 1 0.016s 724s ----------------------- --------- --------- --------- -------------- 724s Total import time ✓ 8 0.3 kB 0.092s 724s 2024-03-18T16:34:24.872742Z LOG Regress pass. 724s touch regress/out/ixf.out 724s pgloader --regress overflow.load 725s 2024-03-18T16:34:26.032025Z LOG pgloader version "3.6.7~devel" 725s 2024-03-18T16:34:26.468373Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 725s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 725s 2024-03-18T16:34:26.468373Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 725s DETAIL: Failing row contains (12, null). 725s CONTEXT: COPY overflow, line 1: "12 \N" 725s 2024-03-18T16:34:26.520415Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/overflow.out") 725s 2024-03-18T16:34:26.560447Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 725s 2024-03-18T16:34:26.720574Z LOG report summary reset 725s table name errors rows bytes total time 725s ----------------------- --------- --------- --------- -------------- 725s fetch 0 0 0.012s 725s before load 0 2 0.044s 725s ----------------------- --------- --------- --------- -------------- 725s "public"."overflow" 4 0 0.0 kB 0.084s 725s "expected"."overflow" 0 0 0.040s 725s ----------------------- --------- --------- --------- -------------- 725s Files Processed 0 2 0.044s 725s COPY Threads Completion 0 4 0.120s 725s ----------------------- --------- --------- --------- -------------- 725s Total import time 4 0 0.0 kB 0.164s 725s 2024-03-18T16:34:26.796634Z LOG Regress pass. 726s touch regress/out/overflow.out 726s pgloader --regress partial.load 726s 2024-03-18T16:34:27.036027Z LOG pgloader version "3.6.7~devel" 726s 2024-03-18T16:34:27.088066Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 727s 2024-03-18T16:34:27.628474Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 727s 2024-03-18T16:34:27.664499Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/partial.out") 727s 2024-03-18T16:34:27.704528Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 727s 2024-03-18T16:34:27.860640Z LOG report summary reset 727s table name errors rows bytes total time 727s ----------------------- --------- --------- --------- -------------- 727s fetch 0 0 0.008s 727s before load 0 4 0.040s 727s ----------------------- --------- --------- --------- -------------- 727s "csv"."partial" 0 7 0.1 kB 0.068s 727s "expected"."partial" 0 7 0.1 kB 0.040s 727s ----------------------- --------- --------- --------- -------------- 727s Files Processed 0 2 0.048s 727s COPY Threads Completion 0 4 0.108s 727s Index Build Completion 0 0 0.072s 727s Create Indexes 0 2 0.008s 727s Constraints 0 1 0.000s 727s ----------------------- --------- --------- --------- -------------- 727s Total import time ✓ 14 0.2 kB 0.236s 727s 2024-03-18T16:34:27.932691Z LOG Regress pass. 727s touch regress/out/partial.out 727s pgloader --regress serial.load 727s 2024-03-18T16:34:28.032023Z LOG pgloader version "3.6.7~devel" 727s 2024-03-18T16:34:28.088063Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 728s 2024-03-18T16:34:28.388273Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 728s 2024-03-18T16:34:28.388273Z WARNING That could impact loading performance badly. 728s 2024-03-18T16:34:28.388273Z WARNING Consider the option 'drop indexes'. 728s 2024-03-18T16:34:28.516360Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 728s 2024-03-18T16:34:28.552384Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/serial.out") 728s 2024-03-18T16:34:28.592410Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 728s 2024-03-18T16:34:28.748516Z LOG report summary reset 728s table name errors rows bytes total time 728s ----------------------- --------- --------- --------- -------------- 728s fetch 0 0 0.008s 728s before load 0 2 0.044s 728s ----------------------- --------- --------- --------- -------------- 728s "public"."serial" 0 7 0.2 kB 0.072s 728s "expected"."serial" 0 7 0.2 kB 0.040s 728s ----------------------- --------- --------- --------- -------------- 728s Files Processed 0 2 0.052s 728s COPY Threads Completion 0 4 0.108s 728s ----------------------- --------- --------- --------- -------------- 728s Total import time ✓ 14 0.4 kB 0.160s 728s 2024-03-18T16:34:28.828570Z LOG Regress pass. 728s touch regress/out/serial.out 728s pgloader --regress udc.load 729s 2024-03-18T16:34:30.036023Z LOG pgloader version "3.6.7~devel" 729s 2024-03-18T16:34:30.088057Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 729s 2024-03-18T16:34:30.376242Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 729s 2024-03-18T16:34:30.376242Z WARNING That could impact loading performance badly. 729s 2024-03-18T16:34:30.376242Z WARNING Consider the option 'drop indexes'. 729s 2024-03-18T16:34:30.508327Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 729s 2024-03-18T16:34:30.544350Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/udc.out") 729s 2024-03-18T16:34:30.580374Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 729s 2024-03-18T16:34:30.736473Z LOG report summary reset 729s table name errors rows bytes total time 729s ----------------------- --------- --------- --------- -------------- 729s fetch 0 0 0.004s 729s before load 0 2 0.044s 729s ----------------------- --------- --------- --------- -------------- 729s "public"."udc" 0 5 0.1 kB 0.072s 729s "expected"."udc" 0 5 0.1 kB 0.040s 729s ----------------------- --------- --------- --------- -------------- 729s Files Processed 0 2 0.060s 729s COPY Threads Completion 0 4 0.100s 729s ----------------------- --------- --------- --------- -------------- 729s Total import time ✓ 10 0.2 kB 0.160s 729s 2024-03-18T16:34:30.812522Z LOG Regress pass. 729s touch regress/out/udc.out 729s pgloader --regress xzero.load 730s 2024-03-18T16:34:31.032020Z LOG pgloader version "3.6.7~devel" 730s 2024-03-18T16:34:31.084051Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 730s 2024-03-18T16:34:31.380232Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 730s 2024-03-18T16:34:31.380232Z WARNING That could impact loading performance badly. 730s 2024-03-18T16:34:31.380232Z WARNING Consider the option 'drop indexes'. 730s 2024-03-18T16:34:31.508310Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 730s 2024-03-18T16:34:31.548335Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.wLVUxK/build.1s7/src/test/regress/expected/xzero.out") 730s 2024-03-18T16:34:31.584357Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 731s 2024-03-18T16:34:31.740451Z LOG report summary reset 731s table name errors rows bytes total time 731s ----------------------- --------- --------- --------- -------------- 731s fetch 0 0 0.008s 731s before load 0 2 0.044s 731s ----------------------- --------- --------- --------- -------------- 731s "public"."xzero" 0 7 0.2 kB 0.068s 731s "expected"."xzero" 0 7 0.2 kB 0.036s 731s ----------------------- --------- --------- --------- -------------- 731s Files Processed 0 2 0.052s 731s COPY Threads Completion 0 4 0.108s 731s ----------------------- --------- --------- --------- -------------- 731s Total import time ✓ 14 0.4 kB 0.160s 731s 2024-03-18T16:34:31.816495Z LOG Regress pass. 731s touch regress/out/xzero.out 731s make: Leaving directory '/tmp/autopkgtest.wLVUxK/build.1s7/src/test' 731s Dropping cluster 16/regress ... 731s autopkgtest [16:34:32]: test testsuite: -----------------------] 732s autopkgtest [16:34:33]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 732s testsuite PASS 732s autopkgtest [16:34:33]: @@@@@@@@@@@@@@@@@@@@ summary 732s ssl PASS 732s testsuite PASS 748s Creating nova instance adt-noble-arm64-pgloader-20240318-162221-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-arm64-server-20240318.img (UUID c242cc3d-7815-4b21-957f-6c17eccd7f17)... 748s Creating nova instance adt-noble-arm64-pgloader-20240318-162221-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-arm64-server-20240318.img (UUID c242cc3d-7815-4b21-957f-6c17eccd7f17)...