0s autopkgtest [02:25:00]: starting date and time: 2024-03-19 02:25:00+0000 0s autopkgtest [02:25:00]: git checkout: b506e79c ssh-setup/nova: fix ARCH having two lines of data 0s autopkgtest [02:25:00]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.8482hywq/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --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-2@bos02-ppc64el-10.secgroup --name adt-noble-ppc64el-pgloader-20240319-022500-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 105s autopkgtest [02:26:45]: testbed dpkg architecture: ppc64el 106s autopkgtest [02:26:46]: testbed apt version: 2.7.12 106s autopkgtest [02:26:46]: @@@@@@@@@@@@@@@@@@@@ test bed setup 107s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 107s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [486 kB] 107s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [52.0 kB] 107s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3753 kB] 108s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 108s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el Packages [646 kB] 108s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el c-n-f Metadata [3116 B] 108s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el Packages [1372 B] 108s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el c-n-f Metadata [116 B] 108s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el Packages [4025 kB] 109s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el c-n-f Metadata [8652 B] 109s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el Packages [47.3 kB] 109s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el c-n-f Metadata [116 B] 112s Fetched 9146 kB in 3s (3058 kB/s) 112s Reading package lists... 115s Reading package lists... 115s Building dependency tree... 115s Reading state information... 115s Calculating upgrade... 115s The following packages will be REMOVED: 115s libssl3 115s The following NEW packages will be installed: 115s libssl3t64 115s The following packages will be upgraded: 115s openssl 115s 1 upgraded, 1 newly installed, 1 to remove and 0 not upgraded. 115s Need to get 3151 kB of archives. 115s After this operation, 73.7 kB of additional disk space will be used. 115s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el openssl ppc64el 3.0.13-0ubuntu2 [1026 kB] 116s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el libssl3t64 ppc64el 3.0.13-0ubuntu2 [2125 kB] 117s Fetched 3151 kB in 2s (1568 kB/s) 118s (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 ... 70095 files and directories currently installed.) 118s Preparing to unpack .../openssl_3.0.13-0ubuntu2_ppc64el.deb ... 118s Unpacking openssl (3.0.13-0ubuntu2) over (3.0.10-1ubuntu4) ... 118s dpkg: libssl3:ppc64el: dependency problems, but removing anyway as you requested: 118s wget depends on libssl3 (>= 3.0.0). 118s tnftp depends on libssl3 (>= 3.0.0). 118s tcpdump depends on libssl3 (>= 3.0.0). 118s systemd-resolved depends on libssl3 (>= 3.0.0). 118s systemd depends on libssl3 (>= 3.0.0). 118s sudo depends on libssl3 (>= 3.0.0). 118s rsync depends on libssl3 (>= 3.0.0). 118s python3-cryptography depends on libssl3 (>= 3.0.0). 118s openssh-server depends on libssl3 (>= 3.0.10). 118s openssh-client depends on libssl3 (>= 3.0.10). 118s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 118s libsystemd-shared:ppc64el depends on libssl3 (>= 3.0.0). 118s libssh-4:ppc64el depends on libssl3 (>= 3.0.0). 118s libsasl2-modules:ppc64el depends on libssl3 (>= 3.0.0). 118s libsasl2-2:ppc64el depends on libssl3 (>= 3.0.0). 118s libpython3.12-minimal:ppc64el depends on libssl3 (>= 3.0.0). 118s libpython3.11-minimal:ppc64el depends on libssl3 (>= 3.0.0). 118s libnvme1 depends on libssl3 (>= 3.0.0). 118s libkrb5-3:ppc64el depends on libssl3 (>= 3.0.0). 118s libkmod2:ppc64el depends on libssl3 (>= 3.0.0). 118s libfido2-1:ppc64el depends on libssl3 (>= 3.0.0). 118s libcurl4:ppc64el depends on libssl3 (>= 3.0.0). 118s libcryptsetup12:ppc64el depends on libssl3 (>= 3.0.0). 118s kmod depends on libssl3 (>= 3.0.0). 118s dhcpcd-base depends on libssl3 (>= 3.0.0). 118s bind9-libs:ppc64el depends on libssl3 (>= 3.0.0). 118s 118s (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 ... 70095 files and directories currently installed.) 118s Removing libssl3:ppc64el (3.0.10-1ubuntu4) ... 118s Selecting previously unselected package libssl3t64:ppc64el. 118s (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 ... 70084 files and directories currently installed.) 118s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu2_ppc64el.deb ... 118s Unpacking libssl3t64:ppc64el (3.0.13-0ubuntu2) ... 118s Setting up libssl3t64:ppc64el (3.0.13-0ubuntu2) ... 118s Setting up openssl (3.0.13-0ubuntu2) ... 118s Processing triggers for man-db (2.12.0-3) ... 119s Processing triggers for libc-bin (2.39-0ubuntu2) ... 119s Reading package lists... 119s Building dependency tree... 119s Reading state information... 119s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 120s Hit:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease 120s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 120s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 120s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 121s Reading package lists... 121s Reading package lists... 121s Building dependency tree... 121s Reading state information... 121s Calculating upgrade... 121s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 121s Reading package lists... 122s Building dependency tree... 122s Reading state information... 122s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s autopkgtest [02:27:05]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Wed Feb 14 00:33:03 UTC 2024 125s autopkgtest [02:27:05]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 128s Get:1 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (dsc) [2802 B] 128s Get:2 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (tar) [3723 kB] 128s Get:3 http://ftpmaster.internal/ubuntu noble/universe pgloader 3.6.10-1 (diff) [9336 B] 128s gpgv: Signature made Thu Nov 2 17:16:12 2023 UTC 128s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 128s gpgv: Can't check signature: No public key 128s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-1.dsc: no acceptable signature found 128s autopkgtest [02:27:08]: testing package pgloader version 3.6.10-1 128s autopkgtest [02:27:08]: build not needed 133s autopkgtest [02:27:13]: test ssl: preparing testbed 137s Reading package lists... 137s Building dependency tree... 137s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 137s Starting 2 pkgProblemResolver with broken count: 0 137s Done 137s The following additional packages will be installed: 137s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 137s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 137s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 137s cl-usocket freetds-common freetds-dev libct4 libjson-perl libllvm17 libpq5 137s libsybdb5 libxslt1.1 pgloader postgresql postgresql-16 postgresql-client-16 137s postgresql-client-common postgresql-common ssl-cert 137s Suggested packages: 137s postgresql-doc postgresql-doc-16 137s Recommended packages: 137s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 137s libjson-xs-perl 137s The following NEW packages will be installed: 137s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 137s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 137s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 137s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 137s libct4 libjson-perl libllvm17 libpq5 libsybdb5 libxslt1.1 pgloader 137s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 137s postgresql-common ssl-cert 137s 0 upgraded, 34 newly installed, 0 to remove and 0 not upgraded. 137s Need to get 76.1 MB/76.1 MB of archives. 137s After this operation, 249 MB of additional disk space will be used. 137s Get:1 /tmp/autopkgtest.v1wWEU/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [736 B] 138s Get:2 http://ftpmaster.internal/ubuntu noble/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 138s Get:3 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-common all 257 [36.2 kB] 138s Get:4 http://ftpmaster.internal/ubuntu noble/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 138s Get:5 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-common all 257 [162 kB] 138s Get:6 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-alexandria all 20211025.gita67c3a6-1 [212 kB] 138s Get:7 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-rt all 20090812.gita6a7503-1 [13.2 kB] 138s Get:8 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-kmrcl all 1.111-2 [42.7 kB] 138s Get:9 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-base64 all 3.4.0-1 [9304 B] 138s Get:10 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 138s Get:11 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 138s Get:12 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-trivial-gray-streams all 20210117.git2b3823e-1 [10.8 kB] 138s Get:13 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 138s Get:14 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 138s Get:15 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-ironclad all 0.57-3 [1247 kB] 139s Get:16 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 139s Get:17 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-split-sequence all 1:2.0.1-1 [12.2 kB] 139s Get:18 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 139s Get:19 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 139s Get:20 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-usocket all 0.8.3-2 [69.9 kB] 139s Get:21 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-postgres all 20211113.git9d4332f-3 [56.5 kB] 139s Get:22 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-s-sql all 20211113.git9d4332f-3 [61.2 kB] 139s Get:23 http://ftpmaster.internal/ubuntu noble/universe ppc64el cl-postmodern all 20211113.git9d4332f-3 [354 kB] 139s Get:24 http://ftpmaster.internal/ubuntu noble/main ppc64el freetds-common all 1.3.17+ds-2 [26.8 kB] 139s Get:25 http://ftpmaster.internal/ubuntu noble/main ppc64el libct4 ppc64el 1.3.17+ds-2 [213 kB] 139s Get:26 http://ftpmaster.internal/ubuntu noble/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2 [240 kB] 139s Get:27 http://ftpmaster.internal/ubuntu noble/main ppc64el freetds-dev ppc64el 1.3.17+ds-2 [357 kB] 139s Get:28 http://ftpmaster.internal/ubuntu noble/main ppc64el libllvm17 ppc64el 1:17.0.6-5build1 [27.3 MB] 142s Get:29 http://ftpmaster.internal/ubuntu noble/main ppc64el libpq5 ppc64el 16.2-1 [170 kB] 142s Get:30 http://ftpmaster.internal/ubuntu noble/main ppc64el libxslt1.1 ppc64el 1.1.35-1 [185 kB] 142s Get:31 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-16 ppc64el 16.2-1 [1399 kB] 142s Get:32 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-16 ppc64el 16.2-1 [16.9 MB] 142s Get:33 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql all 16+257 [11.4 kB] 142s Get:34 http://ftpmaster.internal/ubuntu noble/universe ppc64el pgloader ppc64el 3.6.10-1 [26.0 MB] 144s Preconfiguring packages ... 144s Fetched 76.1 MB in 6s (12.9 MB/s) 144s Selecting previously unselected package libjson-perl. 144s (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 ... 70097 files and directories currently installed.) 144s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 144s Unpacking libjson-perl (4.10000-1) ... 144s Selecting previously unselected package postgresql-client-common. 144s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 144s Unpacking postgresql-client-common (257) ... 144s Selecting previously unselected package ssl-cert. 144s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 144s Unpacking ssl-cert (1.1.2ubuntu1) ... 144s Selecting previously unselected package postgresql-common. 144s Preparing to unpack .../03-postgresql-common_257_all.deb ... 144s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 144s Unpacking postgresql-common (257) ... 144s Selecting previously unselected package cl-alexandria. 144s Preparing to unpack .../04-cl-alexandria_20211025.gita67c3a6-1_all.deb ... 144s Unpacking cl-alexandria (20211025.gita67c3a6-1) ... 144s Selecting previously unselected package cl-rt. 144s Preparing to unpack .../05-cl-rt_20090812.gita6a7503-1_all.deb ... 144s Unpacking cl-rt (20090812.gita6a7503-1) ... 144s Selecting previously unselected package cl-kmrcl. 144s Preparing to unpack .../06-cl-kmrcl_1.111-2_all.deb ... 144s Unpacking cl-kmrcl (1.111-2) ... 144s Selecting previously unselected package cl-base64. 144s Preparing to unpack .../07-cl-base64_3.4.0-1_all.deb ... 144s Unpacking cl-base64 (3.4.0-1) ... 144s Selecting previously unselected package cl-bordeaux-threads. 144s Preparing to unpack .../08-cl-bordeaux-threads_0.8.8-5_all.deb ... 144s Unpacking cl-bordeaux-threads (0.8.8-5) ... 144s Selecting previously unselected package cl-closer-mop. 144s Preparing to unpack .../09-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 144s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 144s Selecting previously unselected package cl-trivial-gray-streams. 144s Preparing to unpack .../10-cl-trivial-gray-streams_20210117.git2b3823e-1_all.deb ... 144s Unpacking cl-trivial-gray-streams (20210117.git2b3823e-1) ... 144s Selecting previously unselected package cl-flexi-streams. 144s Preparing to unpack .../11-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 144s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 144s Selecting previously unselected package cl-global-vars. 144s Preparing to unpack .../12-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 144s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 144s Selecting previously unselected package cl-ironclad. 144s Preparing to unpack .../13-cl-ironclad_0.57-3_all.deb ... 144s Unpacking cl-ironclad (0.57-3) ... 144s Selecting previously unselected package cl-md5. 144s Preparing to unpack .../14-cl-md5_1%3a20210622.git906593f-1_all.deb ... 144s Unpacking cl-md5 (1:20210622.git906593f-1) ... 144s Selecting previously unselected package cl-split-sequence. 144s Preparing to unpack .../15-cl-split-sequence_1%3a2.0.1-1_all.deb ... 144s Unpacking cl-split-sequence (1:2.0.1-1) ... 144s Selecting previously unselected package cl-ppcre. 144s Preparing to unpack .../16-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 144s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 144s Selecting previously unselected package cl-uax-15. 144s Preparing to unpack .../17-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 144s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 144s Selecting previously unselected package cl-usocket. 144s Preparing to unpack .../18-cl-usocket_0.8.3-2_all.deb ... 144s Unpacking cl-usocket (0.8.3-2) ... 144s Selecting previously unselected package cl-postgres. 144s Preparing to unpack .../19-cl-postgres_20211113.git9d4332f-3_all.deb ... 144s Unpacking cl-postgres (20211113.git9d4332f-3) ... 144s Selecting previously unselected package cl-s-sql. 144s Preparing to unpack .../20-cl-s-sql_20211113.git9d4332f-3_all.deb ... 144s Unpacking cl-s-sql (20211113.git9d4332f-3) ... 144s Selecting previously unselected package cl-postmodern. 144s Preparing to unpack .../21-cl-postmodern_20211113.git9d4332f-3_all.deb ... 144s Unpacking cl-postmodern (20211113.git9d4332f-3) ... 144s Selecting previously unselected package freetds-common. 144s Preparing to unpack .../22-freetds-common_1.3.17+ds-2_all.deb ... 144s Unpacking freetds-common (1.3.17+ds-2) ... 144s Selecting previously unselected package libct4:ppc64el. 144s Preparing to unpack .../23-libct4_1.3.17+ds-2_ppc64el.deb ... 144s Unpacking libct4:ppc64el (1.3.17+ds-2) ... 144s Selecting previously unselected package libsybdb5:ppc64el. 144s Preparing to unpack .../24-libsybdb5_1.3.17+ds-2_ppc64el.deb ... 144s Unpacking libsybdb5:ppc64el (1.3.17+ds-2) ... 144s Selecting previously unselected package freetds-dev. 144s Preparing to unpack .../25-freetds-dev_1.3.17+ds-2_ppc64el.deb ... 144s Unpacking freetds-dev (1.3.17+ds-2) ... 144s Selecting previously unselected package libllvm17:ppc64el. 144s Preparing to unpack .../26-libllvm17_1%3a17.0.6-5build1_ppc64el.deb ... 144s Unpacking libllvm17:ppc64el (1:17.0.6-5build1) ... 145s Selecting previously unselected package libpq5:ppc64el. 145s Preparing to unpack .../27-libpq5_16.2-1_ppc64el.deb ... 145s Unpacking libpq5:ppc64el (16.2-1) ... 145s Selecting previously unselected package libxslt1.1:ppc64el. 145s Preparing to unpack .../28-libxslt1.1_1.1.35-1_ppc64el.deb ... 145s Unpacking libxslt1.1:ppc64el (1.1.35-1) ... 145s Selecting previously unselected package postgresql-client-16. 145s Preparing to unpack .../29-postgresql-client-16_16.2-1_ppc64el.deb ... 145s Unpacking postgresql-client-16 (16.2-1) ... 145s Selecting previously unselected package postgresql-16. 145s Preparing to unpack .../30-postgresql-16_16.2-1_ppc64el.deb ... 145s Unpacking postgresql-16 (16.2-1) ... 146s Selecting previously unselected package postgresql. 146s Preparing to unpack .../31-postgresql_16+257_all.deb ... 146s Unpacking postgresql (16+257) ... 146s Selecting previously unselected package pgloader. 146s Preparing to unpack .../32-pgloader_3.6.10-1_ppc64el.deb ... 146s Unpacking pgloader (3.6.10-1) ... 146s Selecting previously unselected package autopkgtest-satdep. 146s Preparing to unpack .../33-1-autopkgtest-satdep.deb ... 146s Unpacking autopkgtest-satdep (0) ... 146s Setting up postgresql-client-common (257) ... 146s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 146s Setting up libpq5:ppc64el (16.2-1) ... 146s Setting up cl-split-sequence (1:2.0.1-1) ... 146s Setting up cl-trivial-gray-streams (20210117.git2b3823e-1) ... 146s Setting up ssl-cert (1.1.2ubuntu1) ... 147s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 147s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 147s Setting up libjson-perl (4.10000-1) ... 147s Setting up libxslt1.1:ppc64el (1.1.35-1) ... 147s Setting up cl-alexandria (20211025.gita67c3a6-1) ... 147s Setting up cl-rt (20090812.gita6a7503-1) ... 147s Setting up freetds-common (1.3.17+ds-2) ... 147s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 147s Setting up libllvm17:ppc64el (1:17.0.6-5build1) ... 147s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 147s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 147s Setting up postgresql-client-16 (16.2-1) ... 147s 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 147s Setting up libsybdb5:ppc64el (1.3.17+ds-2) ... 147s Setting up cl-bordeaux-threads (0.8.8-5) ... 147s Setting up libct4:ppc64el (1.3.17+ds-2) ... 147s Setting up cl-kmrcl (1.111-2) ... 147s Setting up postgresql-common (257) ... 148s 148s Creating config file /etc/postgresql-common/createcluster.conf with new version 148s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 148s Removing obsolete dictionary files: 149s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 149s Setting up cl-usocket (0.8.3-2) ... 149s Setting up cl-md5 (1:20210622.git906593f-1) ... 149s Setting up cl-base64 (3.4.0-1) ... 149s Setting up cl-ironclad (0.57-3) ... 149s Setting up postgresql-16 (16.2-1) ... 149s Creating new PostgreSQL cluster 16/main ... 149s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 149s The files belonging to this database system will be owned by user "postgres". 149s This user must also own the server process. 149s 149s The database cluster will be initialized with locale "C.UTF-8". 149s The default database encoding has accordingly been set to "UTF8". 149s The default text search configuration will be set to "english". 149s 149s Data page checksums are disabled. 149s 149s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 149s creating subdirectories ... ok 149s selecting dynamic shared memory implementation ... posix 149s selecting default max_connections ... 100 149s selecting default shared_buffers ... 128MB 149s selecting default time zone ... Etc/UTC 149s creating configuration files ... ok 150s running bootstrap script ... ok 150s performing post-bootstrap initialization ... ok 150s syncing data to disk ... ok 154s Setting up freetds-dev (1.3.17+ds-2) ... 154s Setting up pgloader (3.6.10-1) ... 154s Setting up cl-postgres (20211113.git9d4332f-3) ... 154s Setting up postgresql (16+257) ... 154s Setting up cl-s-sql (20211113.git9d4332f-3) ... 154s Setting up cl-postmodern (20211113.git9d4332f-3) ... 154s Setting up autopkgtest-satdep (0) ... 154s Processing triggers for man-db (2.12.0-3) ... 155s Processing triggers for install-info (7.1-3) ... 155s Processing triggers for libc-bin (2.39-0ubuntu2) ... 158s (Reading database ... 73003 files and directories currently installed.) 158s Removing autopkgtest-satdep (0) ... 159s autopkgtest [02:27:39]: test ssl: [----------------------- 159s + trap rm -rf /tmp/pgloader EXIT 159s + dpkg-query --show --showformat=${Version} cl-postmodern 159s + postmodern=20211113.git9d4332f-3 159s + dpkg --compare-versions 20211113.git9d4332f-3 lt 20200101 159s + pg_virtualenv 159s Creating new PostgreSQL cluster 16/regress ... 163s ++ psql -XAtc 'SHOW hba_file' 163s + HBA=/etc/postgresql/16/regress/pg_hba.conf 163s + sed -i -e 's/^host/hostssl/' /etc/postgresql/16/regress/pg_hba.conf 163s + psql -XAtc 'SELECT pg_reload_conf()' 163s t 163s + createdb pgloader 163s + export PGDATABASE=pgloader 163s + PGDATABASE=pgloader 163s + psql -XAtc 'create schema expected' 163s CREATE SCHEMA 163s + rm -rf /tmp/pgloader 163s + PGHOST=/var/run/postgresql 163s + su -c 'pgloader --debug --regress test/allcols.load' postgres 163s mkdir -p #P"/tmp/pgloader/" 163s pgloader version 3.6.7~devel 163s compiled with SBCL 2.2.9.debian 163s sb-impl::*default-external-format* :UTF-8 163s tmpdir: #P"/tmp/pgloader/" 163s 2024-03-19T02:27:43.007995Z NOTICE Starting pgloader, log system is ready. 163s 2024-03-19T02:27:43.027981Z INFO Starting monitor 163s 2024-03-19T02:27:43.039972Z LOG pgloader version "3.6.7~devel" 163s 2024-03-19T02:27:43.079944Z INFO Parsed command: 163s /* 163s * This test is ported from pgloader 2.x where it was defined as: 163s * 163s * [allcols] 163s * table = allcols 163s * format = csv 163s * filename = allcols/allcols.data 163s * field_sep = : 163s * columns = * 163s * pg_option_work_mem = 14MB 163s * 163s */ 163s 163s LOAD CSV 163s FROM inline (a, b, c) 163s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 163s 163s WITH fields optionally enclosed by '"', 163s fields escaped by double-quote, 163s fields terminated by ':' 163s 163s SET client_encoding to 'latin1', 163s work_mem to '14MB', 163s standard_conforming_strings to 'on' 163s 163s BEFORE LOAD DO 163s $$ drop table if exists allcols; $$, 163s $$ create table allcols ( 163s a integer primary key, 163s b date, 163s c text 163s ); 163s $$; 163s 163s 163s 163s 163s 163s 2024-03-19T02:27:43.087939Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 163s 2024-03-19T02:27:43.227841Z DEBUG CONNECTED TO # 163s 2024-03-19T02:27:43.231838Z DEBUG SET client_encoding TO 'utf8' 163s 2024-03-19T02:27:43.231838Z DEBUG SET work_mem TO '14MB' 163s 2024-03-19T02:27:43.231838Z DEBUG SET standard_conforming_strings TO 'on' 163s 2024-03-19T02:27:43.231838Z DEBUG SET application_name TO 'pgloader' 163s 2024-03-19T02:27:43.247827Z NOTICE Executing SQL block for before load 163s 2024-03-19T02:27:43.303787Z DEBUG CONNECTED TO # 163s 2024-03-19T02:27:43.303787Z DEBUG SET client_encoding TO 'utf8' 163s 2024-03-19T02:27:43.303787Z DEBUG SET work_mem TO '14MB' 163s 2024-03-19T02:27:43.303787Z DEBUG SET standard_conforming_strings TO 'on' 163s 2024-03-19T02:27:43.303787Z DEBUG SET application_name TO 'pgloader' 163s 2024-03-19T02:27:43.311782Z DEBUG BEGIN 163s 2024-03-19T02:27:43.311782Z SQL drop table if exists allcols; 163s 2024-03-19T02:27:43.311782Z SQL create table allcols ( 163s a integer primary key, 163s b date, 163s c text 163s ); 164s 2024-03-19T02:27:43.423706Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.423706Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.423706Z DEBUG SET work_mem TO '14MB' 164s 2024-03-19T02:27:43.423706Z DEBUG SET standard_conforming_strings TO 'on' 164s 2024-03-19T02:27:43.423706Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.451687Z SQL -- 164s -- get user defined SQL types 164s -- 164s select nt.nspname, 164s extname, 164s typname, 164s case when enum.enumtypid is not null 164s then array_agg(enum.enumlabel order by enumsortorder) 164s end as enumvalues 164s 164s from pg_class c 164s join pg_namespace n on n.oid = c.relnamespace 164s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 164s join pg_type t on t.oid = a.atttypid 164s left join pg_namespace nt on nt.oid = t.typnamespace 164s left join pg_depend d on d.classid = 'pg_type'::regclass 164s and d.refclassid = 'pg_extension'::regclass 164s and d.objid = t.oid 164s left join pg_extension e on refobjid = e.oid 164s left join pg_enum enum on enum.enumtypid = t.oid 164s 164s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 164s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and c.relkind in ('r', 'f', 'p') 164s and ((n.nspname = 'public' and c.relname = 'allcols')) 164s 164s and 164s ( t.typrelid = 0 164s or 164s (select c.relkind = 'c' 164s from pg_class c 164s where c.oid = t.typrelid) 164s ) 164s and not exists 164s ( 164s select 1 164s from pg_type el 164s where el.oid = t.typelem 164s and el.typarray = t.oid 164s ) 164s 164s group by nt.nspname, extname, typname, enumtypid 164s order by nt.nspname, extname, typname, enumtypid; 164s 2024-03-19T02:27:43.451687Z SQL -- params: table-type-name 164s -- including 164s -- filter-list-to-where-clause for including 164s -- excluding 164s -- filter-list-to-where-clause for excluding 164s with seqattr as 164s ( 164s select adrelid, 164s adnum, 164s pg_get_expr(d.adbin, d.adrelid) as adsrc, 164s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 164s then substring(pg_get_expr(d.adbin, d.adrelid) 164s from '''([^'']+)''' 164s ) 164s else null 164s end as seqname 164s from pg_attrdef d 164s ) 164s select nspname, relname, c.oid, attname, 164s t.oid::regtype as type, 164s case when atttypmod > 0 164s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 164s else null 164s end as typmod, 164s attnotnull, 164s case when atthasdef 164s then pg_get_expr(def.adbin, def.adrelid) 164s end as default , 164s case when s.seqname is not null then 'auto_increment' end as extra 164s from pg_class c 164s join pg_namespace n on n.oid = c.relnamespace 164s left join pg_attribute a on c.oid = a.attrelid 164s join pg_type t on t.oid = a.atttypid and attnum > 0 164s left join pg_attrdef def on a.attrelid = def.adrelid 164s and a.attnum = def.adnum 164s and a.atthasdef 164s left join seqattr s on def.adrelid = s.adrelid 164s and def.adnum = s.adnum 164s 164s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and relkind in ('r', 'f', 'p') 164s and ((n.nspname = 'public' and c.relname = 'allcols')) 164s 164s 164s order by nspname, relname, attnum; 164s 2024-03-19T02:27:43.487663Z SQL -- params: including 164s -- filter-list-to-where-clause for including 164s -- excluding 164s -- filter-list-to-where-clause for excluding 164s select n.nspname, 164s i.relname, 164s i.oid, 164s rn.nspname, 164s r.relname, 164s indisprimary, 164s indisunique, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.oid 164s and array[attnum::integer] <@ indkey::integer[] 164s ) as cols, 164s pg_get_indexdef(indexrelid), 164s c.conname, 164s pg_get_constraintdef(c.oid) 164s from pg_index x 164s join pg_class i ON i.oid = x.indexrelid 164s join pg_class r ON r.oid = x.indrelid 164s join pg_namespace n ON n.oid = i.relnamespace 164s join pg_namespace rn ON rn.oid = r.relnamespace 164s left join pg_depend d on d.classid = 'pg_class'::regclass 164s and d.objid = i.oid 164s and d.refclassid = 'pg_constraint'::regclass 164s and d.deptype = 'i' 164s left join pg_constraint c ON c.oid = d.refobjid 164s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and ((rn.nspname = 'public' and r.relname = 'allcols')) 164s 164s order by n.nspname, r.relname 164s 2024-03-19T02:27:43.507650Z SQL -- params: including (table) 164s -- filter-list-to-where-clause for including 164s -- excluding (table) 164s -- filter-list-to-where-clause for excluding 164s -- including (ftable) 164s -- filter-list-to-where-clause for including 164s -- excluding (ftable) 164s -- filter-list-to-where-clause for excluding 164s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 164s r.oid, 164s d.refobjid as pkeyoid, 164s conname, 164s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.conrelid 164s and array[attnum::integer] <@ conkey::integer[] 164s ) as conkey, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.confrelid 164s and array[attnum::integer] <@ confkey::integer[] 164s ) as confkey, 164s confupdtype, confdeltype, confmatchtype, 164s condeferrable, condeferred 164s from pg_catalog.pg_constraint r 164s JOIN pg_class c on r.conrelid = c.oid 164s JOIN pg_namespace n on c.relnamespace = n.oid 164s JOIN pg_class cf on r.confrelid = cf.oid 164s JOIN pg_namespace nf on cf.relnamespace = nf.oid 164s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 164s and d.objid = r.oid 164s and d.refobjsubid = 0 164s where r.contype = 'f' 164s AND c.relkind in ('r', 'f', 'p') 164s AND cf.relkind in ('r', 'f', 'p') 164s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 164s and ((n.nspname = 'public' and c.relname = 'allcols')) 164s 164s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 164s 164s 2024-03-19T02:27:43.515645Z SQL -- params pkey-oid-list 164s -- fkey-oild-list 164s with pkeys(oid) as ( 164s values(16391) 164s ), 164s knownfkeys(oid) as ( 164s values(-1) 164s ), 164s pkdeps as ( 164s select pkeys.oid, pg_depend.objid 164s from pg_depend 164s join pkeys on pg_depend.refobjid = pkeys.oid 164s where classid = 'pg_catalog.pg_constraint'::regclass 164s and refclassid = 'pg_catalog.pg_class'::regclass 164s ) 164s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 164s r.oid as conoid, conname, 164s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 164s pkdeps.oid as index_oid 164s from pg_catalog.pg_constraint r 164s JOIN pkdeps on r.oid = pkdeps.objid 164s JOIN pg_class c on r.conrelid = c.oid 164s JOIN pg_namespace n on c.relnamespace = n.oid 164s JOIN pg_class cf on r.confrelid = cf.oid 164s JOIN pg_namespace nf on cf.relnamespace = nf.oid 164s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 164s 2024-03-19T02:27:43.539630Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 164s 2024-03-19T02:27:43.543627Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 164s 2024-03-19T02:27:43.547625Z WARNING That could impact loading performance badly. 164s 2024-03-19T02:27:43.547625Z WARNING Consider the option 'drop indexes'. 164s 2024-03-19T02:27:43.587598Z NOTICE COPY "public"."allcols" with 0 rows estimated [0/4] 164s 2024-03-19T02:27:43.587598Z DEBUG Reader started for "public"."allcols" 164s 2024-03-19T02:27:43.599590Z DEBUG start "public"."allcols" 835424 164s 2024-03-19T02:27:43.607585Z INFO COPY ON ERROR RESUME NEXT 164s 2024-03-19T02:27:43.615580Z NOTICE Opening (:INLINE 164s (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/allcols.load" . 765)) 164s 2024-03-19T02:27:43.663548Z DEBUG Reader for "public"."allcols" is done in 0.075949s 164s 2024-03-19T02:27:43.663548Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.075949s 164s 2024-03-19T02:27:43.687532Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.687532Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.691529Z DEBUG SET work_mem TO '14MB' 164s 2024-03-19T02:27:43.691529Z DEBUG SET standard_conforming_strings TO 'on' 164s 2024-03-19T02:27:43.691529Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.691529Z SQL SET search_path TO "public"; 164s 2024-03-19T02:27:43.691529Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 164s 2024-03-19T02:27:43.699524Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.007995s 164s 2024-03-19T02:27:43.707519Z DEBUG stop "public"."allcols" | 835424 .. 951347 = 0.115923d0 164s 2024-03-19T02:27:43.707519Z DEBUG Writer[1] for "public"."allcols" is done in 0.007995s 164s 2024-03-19T02:27:43.707519Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.007995s 164s 2024-03-19T02:27:43.723508Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 164s 2024-03-19T02:27:43.783467Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.783467Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.787465Z DEBUG SET work_mem TO '14MB' 164s 2024-03-19T02:27:43.787465Z DEBUG SET standard_conforming_strings TO 'on' 164s 2024-03-19T02:27:43.787465Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.791462Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/allcols.out") 164s 2024-03-19T02:27:43.847425Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.847425Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.851422Z DEBUG SET work_mem TO '14MB' 164s 2024-03-19T02:27:43.851422Z DEBUG SET standard_conforming_strings TO 'on' 164s 2024-03-19T02:27:43.851422Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.851422Z NOTICE drop table if exists expected.allcols; 164s 2024-03-19T02:27:43.851422Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 164s 2024-03-19T02:27:43.851422Z NOTICE create table expected.allcols(like allcols); 164s 2024-03-19T02:27:43.859417Z DEBUG LOAD DATA FROM # 164s 2024-03-19T02:27:43.919377Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.919377Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.919377Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.991329Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:43.991329Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:43.991329Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:43.991329Z SQL -- 164s -- get user defined SQL types 164s -- 164s select nt.nspname, 164s extname, 164s typname, 164s case when enum.enumtypid is not null 164s then array_agg(enum.enumlabel order by enumsortorder) 164s end as enumvalues 164s 164s from pg_class c 164s join pg_namespace n on n.oid = c.relnamespace 164s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 164s join pg_type t on t.oid = a.atttypid 164s left join pg_namespace nt on nt.oid = t.typnamespace 164s left join pg_depend d on d.classid = 'pg_type'::regclass 164s and d.refclassid = 'pg_extension'::regclass 164s and d.objid = t.oid 164s left join pg_extension e on refobjid = e.oid 164s left join pg_enum enum on enum.enumtypid = t.oid 164s 164s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 164s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and c.relkind in ('r', 'f', 'p') 164s and ((n.nspname = 'expected' and c.relname = 'allcols')) 164s 164s and 164s ( t.typrelid = 0 164s or 164s (select c.relkind = 'c' 164s from pg_class c 164s where c.oid = t.typrelid) 164s ) 164s and not exists 164s ( 164s select 1 164s from pg_type el 164s where el.oid = t.typelem 164s and el.typarray = t.oid 164s ) 164s 164s group by nt.nspname, extname, typname, enumtypid 164s order by nt.nspname, extname, typname, enumtypid; 164s 2024-03-19T02:27:43.999324Z SQL -- params: table-type-name 164s -- including 164s -- filter-list-to-where-clause for including 164s -- excluding 164s -- filter-list-to-where-clause for excluding 164s with seqattr as 164s ( 164s select adrelid, 164s adnum, 164s pg_get_expr(d.adbin, d.adrelid) as adsrc, 164s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 164s then substring(pg_get_expr(d.adbin, d.adrelid) 164s from '''([^'']+)''' 164s ) 164s else null 164s end as seqname 164s from pg_attrdef d 164s ) 164s select nspname, relname, c.oid, attname, 164s t.oid::regtype as type, 164s case when atttypmod > 0 164s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 164s else null 164s end as typmod, 164s attnotnull, 164s case when atthasdef 164s then pg_get_expr(def.adbin, def.adrelid) 164s end as default , 164s case when s.seqname is not null then 'auto_increment' end as extra 164s from pg_class c 164s join pg_namespace n on n.oid = c.relnamespace 164s left join pg_attribute a on c.oid = a.attrelid 164s join pg_type t on t.oid = a.atttypid and attnum > 0 164s left join pg_attrdef def on a.attrelid = def.adrelid 164s and a.attnum = def.adnum 164s and a.atthasdef 164s left join seqattr s on def.adrelid = s.adrelid 164s and def.adnum = s.adnum 164s 164s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and relkind in ('r', 'f', 'p') 164s and ((n.nspname = 'expected' and c.relname = 'allcols')) 164s 164s 164s order by nspname, relname, attnum; 164s 2024-03-19T02:27:43.999324Z SQL -- params: including 164s -- filter-list-to-where-clause for including 164s -- excluding 164s -- filter-list-to-where-clause for excluding 164s select n.nspname, 164s i.relname, 164s i.oid, 164s rn.nspname, 164s r.relname, 164s indisprimary, 164s indisunique, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.oid 164s and array[attnum::integer] <@ indkey::integer[] 164s ) as cols, 164s pg_get_indexdef(indexrelid), 164s c.conname, 164s pg_get_constraintdef(c.oid) 164s from pg_index x 164s join pg_class i ON i.oid = x.indexrelid 164s join pg_class r ON r.oid = x.indrelid 164s join pg_namespace n ON n.oid = i.relnamespace 164s join pg_namespace rn ON rn.oid = r.relnamespace 164s left join pg_depend d on d.classid = 'pg_class'::regclass 164s and d.objid = i.oid 164s and d.refclassid = 'pg_constraint'::regclass 164s and d.deptype = 'i' 164s left join pg_constraint c ON c.oid = d.refobjid 164s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 164s 164s order by n.nspname, r.relname 164s 2024-03-19T02:27:44.003322Z SQL -- params: including (table) 164s -- filter-list-to-where-clause for including 164s -- excluding (table) 164s -- filter-list-to-where-clause for excluding 164s -- including (ftable) 164s -- filter-list-to-where-clause for including 164s -- excluding (ftable) 164s -- filter-list-to-where-clause for excluding 164s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 164s r.oid, 164s d.refobjid as pkeyoid, 164s conname, 164s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.conrelid 164s and array[attnum::integer] <@ conkey::integer[] 164s ) as conkey, 164s (select string_agg(attname, ',') 164s from pg_attribute 164s where attrelid = r.confrelid 164s and array[attnum::integer] <@ confkey::integer[] 164s ) as confkey, 164s confupdtype, confdeltype, confmatchtype, 164s condeferrable, condeferred 164s from pg_catalog.pg_constraint r 164s JOIN pg_class c on r.conrelid = c.oid 164s JOIN pg_namespace n on c.relnamespace = n.oid 164s JOIN pg_class cf on r.confrelid = cf.oid 164s JOIN pg_namespace nf on cf.relnamespace = nf.oid 164s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 164s and d.objid = r.oid 164s and d.refobjsubid = 0 164s where r.contype = 'f' 164s AND c.relkind in ('r', 'f', 'p') 164s AND cf.relkind in ('r', 'f', 'p') 164s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 164s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 164s and ((n.nspname = 'expected' and c.relname = 'allcols')) 164s 164s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 164s 164s 2024-03-19T02:27:44.007319Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 164s 2024-03-19T02:27:44.007319Z SQL TRUNCATE "expected"."allcols"; 164s 2024-03-19T02:27:44.031303Z NOTICE COPY "expected"."allcols" with 0 rows estimated [1/4] 164s 2024-03-19T02:27:44.031303Z DEBUG Reader started for "expected"."allcols" 164s 2024-03-19T02:27:44.031303Z DEBUG start "expected"."allcols" 1283126 164s 2024-03-19T02:27:44.031303Z NOTICE Opening #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/allcols.out" 164s 2024-03-19T02:27:44.031303Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 164s 2024-03-19T02:27:44.031303Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 164s 2024-03-19T02:27:44.031303Z INFO COPY ON ERROR RESUME NEXT 164s 2024-03-19T02:27:44.091263Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:44.091263Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:44.091263Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:44.091263Z SQL SET search_path TO "expected"; 164s 2024-03-19T02:27:44.091263Z INFO pgsql:copy-rows-from-queue[0]: "expected"."allcols" ("a" "b" "c") 164s 2024-03-19T02:27:44.095261Z DEBUG send-batch[0] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 164s 2024-03-19T02:27:44.095261Z DEBUG stop "expected"."allcols" | 1283126 .. 1343086 = 0.05996d0 164s 2024-03-19T02:27:44.095261Z DEBUG Writer[0] for "expected"."allcols" is done in 0.000000s 164s 2024-03-19T02:27:44.095261Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 164s 2024-03-19T02:27:44.095261Z LOG report summary reset 164s table name errors read imported bytes total time read write 164s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 164s fetch 0 0 0 0.008s 164s before load 0 2 2 0.072s 164s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 164s "public"."allcols" 0 8 8 0.2 kB 0.116s 0.076s 0.008s 164s "expected"."allcols" 0 8 8 0.2 kB 0.060s 164s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 164s Files Processed 0 2 2 0.048s 164s COPY Threads Completion 0 4 4 0.184s 164s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 164s Total import time ✓ 16 16 0.4 kB 0.232s 164s 2024-03-19T02:27:44.219178Z DEBUG CONNECTED TO # 164s 2024-03-19T02:27:44.219178Z DEBUG SET client_encoding TO 'utf8' 164s 2024-03-19T02:27:44.219178Z DEBUG SET work_mem TO '14MB' 164s 2024-03-19T02:27:44.223176Z DEBUG SET standard_conforming_strings TO 'on' 164s 2024-03-19T02:27:44.223176Z DEBUG SET application_name TO 'pgloader' 164s 2024-03-19T02:27:44.223176Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 164s 2024-03-19T02:27:44.223176Z NOTICE Got a diff of 0 rows 164s 2024-03-19T02:27:44.223176Z LOG Regress pass. 164s 2024-03-19T02:27:44.223176Z INFO Stopping monitor 164s + rm -rf /tmp/pgloader 164s + PGSSLMODE=require 164s + pgloader --debug --regress test/allcols.load 165s mkdir -p #P"/tmp/pgloader/" 165s pgloader version 3.6.7~devel 165s compiled with SBCL 2.2.9.debian 165s sb-impl::*default-external-format* :UTF-8 165s tmpdir: #P"/tmp/pgloader/" 165s 2024-03-19T02:27:45.007995Z NOTICE Starting pgloader, log system is ready. 165s 2024-03-19T02:27:45.027983Z INFO Starting monitor 165s 2024-03-19T02:27:45.039975Z LOG pgloader version "3.6.7~devel" 165s 2024-03-19T02:27:45.079951Z INFO Parsed command: 165s /* 165s * This test is ported from pgloader 2.x where it was defined as: 165s * 165s * [allcols] 165s * table = allcols 165s * format = csv 165s * filename = allcols/allcols.data 165s * field_sep = : 165s * columns = * 165s * pg_option_work_mem = 14MB 165s * 165s */ 165s 165s LOAD CSV 165s FROM inline (a, b, c) 165s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 165s 165s WITH fields optionally enclosed by '"', 165s fields escaped by double-quote, 165s fields terminated by ':' 165s 165s SET client_encoding to 'latin1', 165s work_mem to '14MB', 165s standard_conforming_strings to 'on' 165s 165s BEFORE LOAD DO 165s $$ drop table if exists allcols; $$, 165s $$ create table allcols ( 165s a integer primary key, 165s b date, 165s c text 165s ); 165s $$; 165s 165s 165s 165s 165s 165s 2024-03-19T02:27:45.083949Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 165s 2024-03-19T02:27:45.311806Z DEBUG CONNECTED TO # 165s 2024-03-19T02:27:45.311806Z DEBUG SET client_encoding TO 'utf8' 165s 2024-03-19T02:27:45.311806Z DEBUG SET work_mem TO '14MB' 165s 2024-03-19T02:27:45.315803Z DEBUG SET standard_conforming_strings TO 'on' 165s 2024-03-19T02:27:45.315803Z DEBUG SET application_name TO 'pgloader' 165s 2024-03-19T02:27:45.327795Z NOTICE Executing SQL block for before load 165s 2024-03-19T02:27:45.427733Z DEBUG CONNECTED TO # 165s 2024-03-19T02:27:45.427733Z DEBUG SET client_encoding TO 'utf8' 165s 2024-03-19T02:27:45.431730Z DEBUG SET work_mem TO '14MB' 165s 2024-03-19T02:27:45.431730Z DEBUG SET standard_conforming_strings TO 'on' 165s 2024-03-19T02:27:45.431730Z DEBUG SET application_name TO 'pgloader' 165s 2024-03-19T02:27:45.435728Z DEBUG BEGIN 165s 2024-03-19T02:27:45.435728Z SQL drop table if exists allcols; 165s 2024-03-19T02:27:45.439725Z SQL create table allcols ( 165s a integer primary key, 165s b date, 165s c text 165s ); 165s 2024-03-19T02:27:45.555652Z DEBUG CONNECTED TO # 165s 2024-03-19T02:27:45.555652Z DEBUG SET client_encoding TO 'utf8' 165s 2024-03-19T02:27:45.555652Z DEBUG SET work_mem TO '14MB' 165s 2024-03-19T02:27:45.555652Z DEBUG SET standard_conforming_strings TO 'on' 165s 2024-03-19T02:27:45.555652Z DEBUG SET application_name TO 'pgloader' 165s 2024-03-19T02:27:45.575640Z SQL -- 165s -- get user defined SQL types 165s -- 165s select nt.nspname, 165s extname, 165s typname, 165s case when enum.enumtypid is not null 165s then array_agg(enum.enumlabel order by enumsortorder) 165s end as enumvalues 165s 165s from pg_class c 165s join pg_namespace n on n.oid = c.relnamespace 165s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 165s join pg_type t on t.oid = a.atttypid 165s left join pg_namespace nt on nt.oid = t.typnamespace 165s left join pg_depend d on d.classid = 'pg_type'::regclass 165s and d.refclassid = 'pg_extension'::regclass 165s and d.objid = t.oid 165s left join pg_extension e on refobjid = e.oid 165s left join pg_enum enum on enum.enumtypid = t.oid 165s 165s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 165s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 165s and c.relkind in ('r', 'f', 'p') 165s and ((n.nspname = 'public' and c.relname = 'allcols')) 165s 165s and 165s ( t.typrelid = 0 165s or 165s (select c.relkind = 'c' 165s from pg_class c 165s where c.oid = t.typrelid) 165s ) 165s and not exists 165s ( 165s select 1 165s from pg_type el 165s where el.oid = t.typelem 165s and el.typarray = t.oid 165s ) 165s 165s group by nt.nspname, extname, typname, enumtypid 165s order by nt.nspname, extname, typname, enumtypid; 165s 2024-03-19T02:27:45.579637Z SQL -- params: table-type-name 165s -- including 165s -- filter-list-to-where-clause for including 165s -- excluding 165s -- filter-list-to-where-clause for excluding 165s with seqattr as 165s ( 165s select adrelid, 165s adnum, 165s pg_get_expr(d.adbin, d.adrelid) as adsrc, 165s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 165s then substring(pg_get_expr(d.adbin, d.adrelid) 165s from '''([^'']+)''' 165s ) 165s else null 165s end as seqname 165s from pg_attrdef d 165s ) 165s select nspname, relname, c.oid, attname, 165s t.oid::regtype as type, 165s case when atttypmod > 0 165s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 165s else null 165s end as typmod, 165s attnotnull, 165s case when atthasdef 165s then pg_get_expr(def.adbin, def.adrelid) 165s end as default , 165s case when s.seqname is not null then 'auto_increment' end as extra 165s from pg_class c 165s join pg_namespace n on n.oid = c.relnamespace 165s left join pg_attribute a on c.oid = a.attrelid 165s join pg_type t on t.oid = a.atttypid and attnum > 0 165s left join pg_attrdef def on a.attrelid = def.adrelid 165s and a.attnum = def.adnum 165s and a.atthasdef 165s left join seqattr s on def.adrelid = s.adrelid 165s and def.adnum = s.adnum 165s 165s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 165s and relkind in ('r', 'f', 'p') 165s and ((n.nspname = 'public' and c.relname = 'allcols')) 165s 165s 165s order by nspname, relname, attnum; 165s 2024-03-19T02:27:45.611617Z SQL -- params: including 165s -- filter-list-to-where-clause for including 165s -- excluding 165s -- filter-list-to-where-clause for excluding 165s select n.nspname, 165s i.relname, 165s i.oid, 165s rn.nspname, 165s r.relname, 165s indisprimary, 165s indisunique, 165s (select string_agg(attname, ',') 165s from pg_attribute 165s where attrelid = r.oid 165s and array[attnum::integer] <@ indkey::integer[] 165s ) as cols, 165s pg_get_indexdef(indexrelid), 165s c.conname, 165s pg_get_constraintdef(c.oid) 165s from pg_index x 165s join pg_class i ON i.oid = x.indexrelid 165s join pg_class r ON r.oid = x.indrelid 165s join pg_namespace n ON n.oid = i.relnamespace 165s join pg_namespace rn ON rn.oid = r.relnamespace 165s left join pg_depend d on d.classid = 'pg_class'::regclass 165s and d.objid = i.oid 165s and d.refclassid = 'pg_constraint'::regclass 165s and d.deptype = 'i' 165s left join pg_constraint c ON c.oid = d.refobjid 165s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 165s and ((rn.nspname = 'public' and r.relname = 'allcols')) 165s 165s order by n.nspname, r.relname 165s 2024-03-19T02:27:45.631605Z SQL -- params: including (table) 165s -- filter-list-to-where-clause for including 165s -- excluding (table) 165s -- filter-list-to-where-clause for excluding 165s -- including (ftable) 165s -- filter-list-to-where-clause for including 165s -- excluding (ftable) 165s -- filter-list-to-where-clause for excluding 165s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 165s r.oid, 165s d.refobjid as pkeyoid, 165s conname, 165s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 165s (select string_agg(attname, ',') 165s from pg_attribute 165s where attrelid = r.conrelid 165s and array[attnum::integer] <@ conkey::integer[] 165s ) as conkey, 165s (select string_agg(attname, ',') 165s from pg_attribute 165s where attrelid = r.confrelid 165s and array[attnum::integer] <@ confkey::integer[] 165s ) as confkey, 165s confupdtype, confdeltype, confmatchtype, 165s condeferrable, condeferred 165s from pg_catalog.pg_constraint r 165s JOIN pg_class c on r.conrelid = c.oid 165s JOIN pg_namespace n on c.relnamespace = n.oid 165s JOIN pg_class cf on r.confrelid = cf.oid 165s JOIN pg_namespace nf on cf.relnamespace = nf.oid 165s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 165s and d.objid = r.oid 165s and d.refobjsubid = 0 165s where r.contype = 'f' 165s AND c.relkind in ('r', 'f', 'p') 165s AND cf.relkind in ('r', 'f', 'p') 165s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 165s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 165s and ((n.nspname = 'public' and c.relname = 'allcols')) 165s 165s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 165s 165s 2024-03-19T02:27:45.635602Z SQL -- params pkey-oid-list 165s -- fkey-oild-list 165s with pkeys(oid) as ( 165s values(16406) 165s ), 165s knownfkeys(oid) as ( 165s values(-1) 165s ), 165s pkdeps as ( 165s select pkeys.oid, pg_depend.objid 165s from pg_depend 165s join pkeys on pg_depend.refobjid = pkeys.oid 165s where classid = 'pg_catalog.pg_constraint'::regclass 165s and refclassid = 'pg_catalog.pg_class'::regclass 165s ) 165s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 165s r.oid as conoid, conname, 165s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 165s pkdeps.oid as index_oid 165s from pg_catalog.pg_constraint r 165s JOIN pkdeps on r.oid = pkdeps.objid 165s JOIN pg_class c on r.conrelid = c.oid 165s JOIN pg_namespace n on c.relnamespace = n.oid 165s JOIN pg_class cf on r.confrelid = cf.oid 165s JOIN pg_namespace nf on cf.relnamespace = nf.oid 165s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 165s 2024-03-19T02:27:45.651592Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 165s 2024-03-19T02:27:45.659587Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 165s 2024-03-19T02:27:45.659587Z WARNING That could impact loading performance badly. 165s 2024-03-19T02:27:45.659587Z WARNING Consider the option 'drop indexes'. 165s 2024-03-19T02:27:45.691567Z NOTICE COPY "public"."allcols" with 0 rows estimated [0/4] 165s 2024-03-19T02:27:45.691567Z DEBUG Reader started for "public"."allcols" 165s 2024-03-19T02:27:45.707557Z DEBUG start "public"."allcols" 919419 165s 2024-03-19T02:27:45.715552Z INFO COPY ON ERROR RESUME NEXT 165s 2024-03-19T02:27:45.715552Z NOTICE Opening (:INLINE 165s (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/allcols.load" . 765)) 165s 2024-03-19T02:27:45.763522Z DEBUG Reader for "public"."allcols" is done in 0.063960s 165s 2024-03-19T02:27:45.763522Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.063960s 165s 2024-03-19T02:27:45.831478Z DEBUG CONNECTED TO # 165s 2024-03-19T02:27:45.831478Z DEBUG SET client_encoding TO 'utf8' 165s 2024-03-19T02:27:45.831478Z DEBUG SET work_mem TO '14MB' 165s 2024-03-19T02:27:45.835476Z DEBUG SET standard_conforming_strings TO 'on' 165s 2024-03-19T02:27:45.835476Z DEBUG SET application_name TO 'pgloader' 165s 2024-03-19T02:27:45.835476Z SQL SET search_path TO "public"; 165s 2024-03-19T02:27:45.835476Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 165s 2024-03-19T02:27:45.839473Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.003997s 165s 2024-03-19T02:27:45.843471Z DEBUG stop "public"."allcols" | 919419 .. 1071323 = 0.151904d0 166s 2024-03-19T02:27:45.851466Z DEBUG Writer[1] for "public"."allcols" is done in 0.003997s 166s 2024-03-19T02:27:45.851466Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.003997s 166s 2024-03-19T02:27:45.867456Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 166s 2024-03-19T02:27:45.963398Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:45.963398Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:45.967395Z DEBUG SET work_mem TO '14MB' 166s 2024-03-19T02:27:45.967395Z DEBUG SET standard_conforming_strings TO 'on' 166s 2024-03-19T02:27:45.967395Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:45.971393Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/allcols.out") 166s 2024-03-19T02:27:46.067337Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:46.067337Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:46.067337Z DEBUG SET work_mem TO '14MB' 166s 2024-03-19T02:27:46.067337Z DEBUG SET standard_conforming_strings TO 'on' 166s 2024-03-19T02:27:46.071335Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:46.071335Z NOTICE drop table if exists expected.allcols; 166s 2024-03-19T02:27:46.071335Z NOTICE create table expected.allcols(like allcols); 166s 2024-03-19T02:27:46.075332Z DEBUG LOAD DATA FROM # 166s 2024-03-19T02:27:46.183268Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:46.183268Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:46.183268Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:46.295201Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:46.295201Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:46.295201Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:46.295201Z SQL -- 166s -- get user defined SQL types 166s -- 166s select nt.nspname, 166s extname, 166s typname, 166s case when enum.enumtypid is not null 166s then array_agg(enum.enumlabel order by enumsortorder) 166s end as enumvalues 166s 166s from pg_class c 166s join pg_namespace n on n.oid = c.relnamespace 166s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 166s join pg_type t on t.oid = a.atttypid 166s left join pg_namespace nt on nt.oid = t.typnamespace 166s left join pg_depend d on d.classid = 'pg_type'::regclass 166s and d.refclassid = 'pg_extension'::regclass 166s and d.objid = t.oid 166s left join pg_extension e on refobjid = e.oid 166s left join pg_enum enum on enum.enumtypid = t.oid 166s 166s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 166s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 166s and c.relkind in ('r', 'f', 'p') 166s and ((n.nspname = 'expected' and c.relname = 'allcols')) 166s 166s and 166s ( t.typrelid = 0 166s or 166s (select c.relkind = 'c' 166s from pg_class c 166s where c.oid = t.typrelid) 166s ) 166s and not exists 166s ( 166s select 1 166s from pg_type el 166s where el.oid = t.typelem 166s and el.typarray = t.oid 166s ) 166s 166s group by nt.nspname, extname, typname, enumtypid 166s order by nt.nspname, extname, typname, enumtypid; 166s 2024-03-19T02:27:46.299199Z SQL -- params: table-type-name 166s -- including 166s -- filter-list-to-where-clause for including 166s -- excluding 166s -- filter-list-to-where-clause for excluding 166s with seqattr as 166s ( 166s select adrelid, 166s adnum, 166s pg_get_expr(d.adbin, d.adrelid) as adsrc, 166s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 166s then substring(pg_get_expr(d.adbin, d.adrelid) 166s from '''([^'']+)''' 166s ) 166s else null 166s end as seqname 166s from pg_attrdef d 166s ) 166s select nspname, relname, c.oid, attname, 166s t.oid::regtype as type, 166s case when atttypmod > 0 166s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 166s else null 166s end as typmod, 166s attnotnull, 166s case when atthasdef 166s then pg_get_expr(def.adbin, def.adrelid) 166s end as default , 166s case when s.seqname is not null then 'auto_increment' end as extra 166s from pg_class c 166s join pg_namespace n on n.oid = c.relnamespace 166s left join pg_attribute a on c.oid = a.attrelid 166s join pg_type t on t.oid = a.atttypid and attnum > 0 166s left join pg_attrdef def on a.attrelid = def.adrelid 166s and a.attnum = def.adnum 166s and a.atthasdef 166s left join seqattr s on def.adrelid = s.adrelid 166s and def.adnum = s.adnum 166s 166s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 166s and relkind in ('r', 'f', 'p') 166s and ((n.nspname = 'expected' and c.relname = 'allcols')) 166s 166s 166s order by nspname, relname, attnum; 166s 2024-03-19T02:27:46.303197Z SQL -- params: including 166s -- filter-list-to-where-clause for including 166s -- excluding 166s -- filter-list-to-where-clause for excluding 166s select n.nspname, 166s i.relname, 166s i.oid, 166s rn.nspname, 166s r.relname, 166s indisprimary, 166s indisunique, 166s (select string_agg(attname, ',') 166s from pg_attribute 166s where attrelid = r.oid 166s and array[attnum::integer] <@ indkey::integer[] 166s ) as cols, 166s pg_get_indexdef(indexrelid), 166s c.conname, 166s pg_get_constraintdef(c.oid) 166s from pg_index x 166s join pg_class i ON i.oid = x.indexrelid 166s join pg_class r ON r.oid = x.indrelid 166s join pg_namespace n ON n.oid = i.relnamespace 166s join pg_namespace rn ON rn.oid = r.relnamespace 166s left join pg_depend d on d.classid = 'pg_class'::regclass 166s and d.objid = i.oid 166s and d.refclassid = 'pg_constraint'::regclass 166s and d.deptype = 'i' 166s left join pg_constraint c ON c.oid = d.refobjid 166s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 166s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 166s 166s order by n.nspname, r.relname 166s 2024-03-19T02:27:46.307194Z SQL -- params: including (table) 166s -- filter-list-to-where-clause for including 166s -- excluding (table) 166s -- filter-list-to-where-clause for excluding 166s -- including (ftable) 166s -- filter-list-to-where-clause for including 166s -- excluding (ftable) 166s -- filter-list-to-where-clause for excluding 166s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 166s r.oid, 166s d.refobjid as pkeyoid, 166s conname, 166s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 166s (select string_agg(attname, ',') 166s from pg_attribute 166s where attrelid = r.conrelid 166s and array[attnum::integer] <@ conkey::integer[] 166s ) as conkey, 166s (select string_agg(attname, ',') 166s from pg_attribute 166s where attrelid = r.confrelid 166s and array[attnum::integer] <@ confkey::integer[] 166s ) as confkey, 166s confupdtype, confdeltype, confmatchtype, 166s condeferrable, condeferred 166s from pg_catalog.pg_constraint r 166s JOIN pg_class c on r.conrelid = c.oid 166s JOIN pg_namespace n on c.relnamespace = n.oid 166s JOIN pg_class cf on r.confrelid = cf.oid 166s JOIN pg_namespace nf on cf.relnamespace = nf.oid 166s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 166s and d.objid = r.oid 166s and d.refobjsubid = 0 166s where r.contype = 'f' 166s AND c.relkind in ('r', 'f', 'p') 166s AND cf.relkind in ('r', 'f', 'p') 166s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 166s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 166s and ((n.nspname = 'expected' and c.relname = 'allcols')) 166s 166s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 166s 166s 2024-03-19T02:27:46.307194Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 166s 2024-03-19T02:27:46.307194Z SQL TRUNCATE "expected"."allcols"; 166s 2024-03-19T02:27:46.327182Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 166s 2024-03-19T02:27:46.331180Z DEBUG Reader started for "expected"."allcols" 166s 2024-03-19T02:27:46.331180Z DEBUG start "expected"."allcols" 1555034 166s 2024-03-19T02:27:46.331180Z NOTICE Opening #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/allcols.out" 166s 2024-03-19T02:27:46.331180Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 166s 2024-03-19T02:27:46.331180Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 166s 2024-03-19T02:27:46.331180Z INFO COPY ON ERROR RESUME NEXT 166s 2024-03-19T02:27:46.431120Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:46.431120Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:46.431120Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:46.435118Z SQL SET search_path TO "expected"; 166s 2024-03-19T02:27:46.435118Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 166s 2024-03-19T02:27:46.435118Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 166s 2024-03-19T02:27:46.439116Z DEBUG stop "expected"."allcols" | 1555034 .. 1666968 = 0.111934d0 166s 2024-03-19T02:27:46.439116Z DEBUG Writer[1] for "expected"."allcols" is done in 0.000000s 166s 2024-03-19T02:27:46.443113Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 166s 2024-03-19T02:27:46.443113Z LOG report summary reset 166s table name errors read imported bytes total time read write 166s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 166s fetch 0 0 0 0.004s 166s before load 0 2 2 0.116s 166s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 166s "public"."allcols" 0 8 8 0.2 kB 0.152s 0.064s 0.004s 166s "expected"."allcols" 0 8 8 0.2 kB 0.112s 166s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 166s Files Processed 0 2 2 0.044s 166s COPY Threads Completion 0 4 4 0.256s 166s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 166s Total import time ✓ 16 16 0.4 kB 0.300s 166s 2024-03-19T02:27:46.599021Z DEBUG CONNECTED TO # 166s 2024-03-19T02:27:46.599021Z DEBUG SET client_encoding TO 'utf8' 166s 2024-03-19T02:27:46.599021Z DEBUG SET work_mem TO '14MB' 166s 2024-03-19T02:27:46.599021Z DEBUG SET standard_conforming_strings TO 'on' 166s 2024-03-19T02:27:46.599021Z DEBUG SET application_name TO 'pgloader' 166s 2024-03-19T02:27:46.603018Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 166s 2024-03-19T02:27:46.603018Z NOTICE Got a diff of 0 rows 166s 2024-03-19T02:27:46.603018Z LOG Regress pass. 166s 2024-03-19T02:27:46.603018Z INFO Stopping monitor 166s Dropping cluster 16/regress ... 168s + rm -rf /tmp/pgloader 169s autopkgtest [02:27:49]: test ssl: -----------------------] 169s ssl PASS 169s autopkgtest [02:27:49]: test ssl: - - - - - - - - - - results - - - - - - - - - - 170s autopkgtest [02:27:50]: test testsuite: preparing testbed 286s autopkgtest [02:29:46]: testbed dpkg architecture: ppc64el 286s autopkgtest [02:29:46]: testbed apt version: 2.7.12 286s autopkgtest [02:29:46]: @@@@@@@@@@@@@@@@@@@@ test bed setup 287s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 288s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [486 kB] 288s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [52.0 kB] 288s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3753 kB] 289s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 289s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el Packages [646 kB] 290s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el c-n-f Metadata [3116 B] 290s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el Packages [1372 B] 290s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted ppc64el c-n-f Metadata [116 B] 290s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el Packages [4025 kB] 290s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe ppc64el c-n-f Metadata [8652 B] 290s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el Packages [47.3 kB] 290s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse ppc64el c-n-f Metadata [116 B] 293s Fetched 9146 kB in 4s (2442 kB/s) 293s Reading package lists... 298s Reading package lists... 298s Building dependency tree... 298s Reading state information... 298s Calculating upgrade... 298s The following packages will be REMOVED: 298s libssl3 298s The following NEW packages will be installed: 298s libssl3t64 298s The following packages will be upgraded: 298s openssl 299s 1 upgraded, 1 newly installed, 1 to remove and 0 not upgraded. 299s Need to get 3151 kB of archives. 299s After this operation, 73.7 kB of additional disk space will be used. 299s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el openssl ppc64el 3.0.13-0ubuntu2 [1026 kB] 299s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main ppc64el libssl3t64 ppc64el 3.0.13-0ubuntu2 [2125 kB] 300s Fetched 3151 kB in 1s (3205 kB/s) 300s (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 ... 70095 files and directories currently installed.) 300s Preparing to unpack .../openssl_3.0.13-0ubuntu2_ppc64el.deb ... 300s Unpacking openssl (3.0.13-0ubuntu2) over (3.0.10-1ubuntu4) ... 300s dpkg: libssl3:ppc64el: dependency problems, but removing anyway as you requested: 300s wget depends on libssl3 (>= 3.0.0). 300s tnftp depends on libssl3 (>= 3.0.0). 300s tcpdump depends on libssl3 (>= 3.0.0). 300s systemd-resolved depends on libssl3 (>= 3.0.0). 300s systemd depends on libssl3 (>= 3.0.0). 300s sudo depends on libssl3 (>= 3.0.0). 300s rsync depends on libssl3 (>= 3.0.0). 300s python3-cryptography depends on libssl3 (>= 3.0.0). 300s openssh-server depends on libssl3 (>= 3.0.10). 300s openssh-client depends on libssl3 (>= 3.0.10). 300s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 300s libsystemd-shared:ppc64el depends on libssl3 (>= 3.0.0). 300s libssh-4:ppc64el depends on libssl3 (>= 3.0.0). 300s libsasl2-modules:ppc64el depends on libssl3 (>= 3.0.0). 300s libsasl2-2:ppc64el depends on libssl3 (>= 3.0.0). 300s libpython3.12-minimal:ppc64el depends on libssl3 (>= 3.0.0). 300s libpython3.11-minimal:ppc64el depends on libssl3 (>= 3.0.0). 300s libnvme1 depends on libssl3 (>= 3.0.0). 300s libkrb5-3:ppc64el depends on libssl3 (>= 3.0.0). 300s libkmod2:ppc64el depends on libssl3 (>= 3.0.0). 300s libfido2-1:ppc64el depends on libssl3 (>= 3.0.0). 300s libcurl4:ppc64el depends on libssl3 (>= 3.0.0). 300s libcryptsetup12:ppc64el depends on libssl3 (>= 3.0.0). 300s kmod depends on libssl3 (>= 3.0.0). 300s dhcpcd-base depends on libssl3 (>= 3.0.0). 300s bind9-libs:ppc64el depends on libssl3 (>= 3.0.0). 300s 300s (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 ... 70095 files and directories currently installed.) 300s Removing libssl3:ppc64el (3.0.10-1ubuntu4) ... 300s Selecting previously unselected package libssl3t64:ppc64el. 300s (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 ... 70084 files and directories currently installed.) 300s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu2_ppc64el.deb ... 300s Unpacking libssl3t64:ppc64el (3.0.13-0ubuntu2) ... 300s Setting up libssl3t64:ppc64el (3.0.13-0ubuntu2) ... 300s Setting up openssl (3.0.13-0ubuntu2) ... 300s Processing triggers for man-db (2.12.0-3) ... 301s Processing triggers for libc-bin (2.39-0ubuntu2) ... 301s Reading package lists... 301s Building dependency tree... 301s Reading state information... 301s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 302s Hit:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease 302s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 302s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 302s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 303s Reading package lists... 303s Reading package lists... 304s Building dependency tree... 304s Reading state information... 304s Calculating upgrade... 304s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 304s Reading package lists... 304s Building dependency tree... 304s Reading state information... 304s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 310s Reading package lists... 311s Building dependency tree... 311s Reading state information... 311s Starting pkgProblemResolver with broken count: 0 311s Starting 2 pkgProblemResolver with broken count: 0 311s Done 311s The following additional packages will be installed: 311s freetds-common freetds-dev libct4 libjson-perl libllvm17 libpq5 libsybdb5 311s libxslt1.1 pgloader postgresql-16 postgresql-16-ip4r postgresql-client-16 311s postgresql-client-common postgresql-common ssl-cert 311s Suggested packages: 311s postgresql-doc-16 311s Recommended packages: 311s freetds-doc libjson-xs-perl 311s The following NEW packages will be installed: 311s autopkgtest-satdep freetds-common freetds-dev libct4 libjson-perl libllvm17 311s libpq5 libsybdb5 libxslt1.1 pgloader postgresql-16 postgresql-16-ip4r 311s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 311s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 311s Need to get 73.3 MB/73.3 MB of archives. 311s After this operation, 233 MB of additional disk space will be used. 311s Get:1 /tmp/autopkgtest.v1wWEU/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [728 B] 311s Get:2 http://ftpmaster.internal/ubuntu noble/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 312s Get:3 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-common all 257 [36.2 kB] 312s Get:4 http://ftpmaster.internal/ubuntu noble/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 312s Get:5 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-common all 257 [162 kB] 312s Get:6 http://ftpmaster.internal/ubuntu noble/main ppc64el freetds-common all 1.3.17+ds-2 [26.8 kB] 312s Get:7 http://ftpmaster.internal/ubuntu noble/main ppc64el libct4 ppc64el 1.3.17+ds-2 [213 kB] 312s Get:8 http://ftpmaster.internal/ubuntu noble/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2 [240 kB] 312s Get:9 http://ftpmaster.internal/ubuntu noble/main ppc64el freetds-dev ppc64el 1.3.17+ds-2 [357 kB] 312s Get:10 http://ftpmaster.internal/ubuntu noble/main ppc64el libllvm17 ppc64el 1:17.0.6-5build1 [27.3 MB] 314s Get:11 http://ftpmaster.internal/ubuntu noble/main ppc64el libpq5 ppc64el 16.2-1 [170 kB] 314s Get:12 http://ftpmaster.internal/ubuntu noble/main ppc64el libxslt1.1 ppc64el 1.1.35-1 [185 kB] 314s Get:13 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-client-16 ppc64el 16.2-1 [1399 kB] 314s Get:14 http://ftpmaster.internal/ubuntu noble/main ppc64el postgresql-16 ppc64el 16.2-1 [16.9 MB] 315s Get:15 http://ftpmaster.internal/ubuntu noble/universe ppc64el postgresql-16-ip4r ppc64el 2.4.2-2 [213 kB] 315s Get:16 http://ftpmaster.internal/ubuntu noble/universe ppc64el pgloader ppc64el 3.6.10-1 [26.0 MB] 316s Preconfiguring packages ... 316s Fetched 73.3 MB in 5s (15.6 MB/s) 316s Selecting previously unselected package libjson-perl. 316s (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 ... 70097 files and directories currently installed.) 316s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 316s Unpacking libjson-perl (4.10000-1) ... 316s Selecting previously unselected package postgresql-client-common. 316s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 316s Unpacking postgresql-client-common (257) ... 316s Selecting previously unselected package ssl-cert. 316s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 316s Unpacking ssl-cert (1.1.2ubuntu1) ... 316s Selecting previously unselected package postgresql-common. 316s Preparing to unpack .../03-postgresql-common_257_all.deb ... 316s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 316s Unpacking postgresql-common (257) ... 316s Selecting previously unselected package freetds-common. 316s Preparing to unpack .../04-freetds-common_1.3.17+ds-2_all.deb ... 316s Unpacking freetds-common (1.3.17+ds-2) ... 316s Selecting previously unselected package libct4:ppc64el. 316s Preparing to unpack .../05-libct4_1.3.17+ds-2_ppc64el.deb ... 316s Unpacking libct4:ppc64el (1.3.17+ds-2) ... 316s Selecting previously unselected package libsybdb5:ppc64el. 316s Preparing to unpack .../06-libsybdb5_1.3.17+ds-2_ppc64el.deb ... 316s Unpacking libsybdb5:ppc64el (1.3.17+ds-2) ... 316s Selecting previously unselected package freetds-dev. 316s Preparing to unpack .../07-freetds-dev_1.3.17+ds-2_ppc64el.deb ... 316s Unpacking freetds-dev (1.3.17+ds-2) ... 316s Selecting previously unselected package libllvm17:ppc64el. 316s Preparing to unpack .../08-libllvm17_1%3a17.0.6-5build1_ppc64el.deb ... 316s Unpacking libllvm17:ppc64el (1:17.0.6-5build1) ... 317s Selecting previously unselected package libpq5:ppc64el. 317s Preparing to unpack .../09-libpq5_16.2-1_ppc64el.deb ... 317s Unpacking libpq5:ppc64el (16.2-1) ... 317s Selecting previously unselected package libxslt1.1:ppc64el. 317s Preparing to unpack .../10-libxslt1.1_1.1.35-1_ppc64el.deb ... 317s Unpacking libxslt1.1:ppc64el (1.1.35-1) ... 317s Selecting previously unselected package postgresql-client-16. 317s Preparing to unpack .../11-postgresql-client-16_16.2-1_ppc64el.deb ... 317s Unpacking postgresql-client-16 (16.2-1) ... 317s Selecting previously unselected package postgresql-16. 317s Preparing to unpack .../12-postgresql-16_16.2-1_ppc64el.deb ... 317s Unpacking postgresql-16 (16.2-1) ... 318s Selecting previously unselected package postgresql-16-ip4r. 318s Preparing to unpack .../13-postgresql-16-ip4r_2.4.2-2_ppc64el.deb ... 318s Unpacking postgresql-16-ip4r (2.4.2-2) ... 318s Selecting previously unselected package pgloader. 318s Preparing to unpack .../14-pgloader_3.6.10-1_ppc64el.deb ... 318s Unpacking pgloader (3.6.10-1) ... 318s Selecting previously unselected package autopkgtest-satdep. 318s Preparing to unpack .../15-2-autopkgtest-satdep.deb ... 318s Unpacking autopkgtest-satdep (0) ... 318s Setting up postgresql-client-common (257) ... 318s Setting up libpq5:ppc64el (16.2-1) ... 318s Setting up ssl-cert (1.1.2ubuntu1) ... 319s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 320s Setting up libjson-perl (4.10000-1) ... 320s Setting up libxslt1.1:ppc64el (1.1.35-1) ... 320s Setting up freetds-common (1.3.17+ds-2) ... 320s Setting up libllvm17:ppc64el (1:17.0.6-5build1) ... 320s Setting up postgresql-client-16 (16.2-1) ... 320s 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 320s Setting up libsybdb5:ppc64el (1.3.17+ds-2) ... 320s Setting up libct4:ppc64el (1.3.17+ds-2) ... 320s Setting up postgresql-common (257) ... 320s 320s Creating config file /etc/postgresql-common/createcluster.conf with new version 321s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 321s Removing obsolete dictionary files: 321s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 322s Setting up postgresql-16 (16.2-1) ... 322s Creating new PostgreSQL cluster 16/main ... 322s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 322s The files belonging to this database system will be owned by user "postgres". 322s This user must also own the server process. 322s 322s The database cluster will be initialized with locale "C.UTF-8". 322s The default database encoding has accordingly been set to "UTF8". 322s The default text search configuration will be set to "english". 322s 322s Data page checksums are disabled. 322s 322s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 322s creating subdirectories ... ok 322s selecting dynamic shared memory implementation ... posix 322s selecting default max_connections ... 100 322s selecting default shared_buffers ... 128MB 322s selecting default time zone ... Etc/UTC 322s creating configuration files ... ok 322s running bootstrap script ... ok 323s performing post-bootstrap initialization ... ok 323s syncing data to disk ... ok 326s Setting up freetds-dev (1.3.17+ds-2) ... 326s Setting up pgloader (3.6.10-1) ... 326s Setting up postgresql-16-ip4r (2.4.2-2) ... 326s Setting up autopkgtest-satdep (0) ... 326s Processing triggers for man-db (2.12.0-3) ... 327s Processing triggers for libc-bin (2.39-0ubuntu2) ... 329s (Reading database ... 72216 files and directories currently installed.) 329s Removing autopkgtest-satdep (0) ... 342s autopkgtest [02:30:42]: test testsuite: [----------------------- 343s + PGSUPERUSER=ubuntu 343s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 343s Creating new PostgreSQL cluster 16/regress ... 346s make: Entering directory '/tmp/autopkgtest.v1wWEU/build.XJW/src/test' 346s dropdb -U ubuntu pgloader 346s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 346s make: [Makefile:67: prepare] Error 1 (ignored) 346s dropdb -U ubuntu stocks 346s dropdb: dropdb -U ubuntu ip4r 346s error: database removal failed: ERROR: database "stocks" does not exist 346s make: [Makefile:68: prepare] Error 1 (ignored) 346s createuser -U ubuntu --superuser `whoami` 346s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 346s make: [Makefile:69: prepare] Error 1 (ignored) 346s createdb -U ubuntu -O `whoami` pgloader 346s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 346s make: [Makefile:70: prepare] Error 1 (ignored) 346s createdb -U ubuntu -O `whoami` stocks 346s createdb -U ubuntu -O `whoami` ip4r 346s psql -d pgloader -c 'create schema expected' 346s CREATE SCHEMA 346s psql -U ubuntu -d pgloader -c 'create extension ip4r' 346s CREATE EXTENSION 346s psql -U ubuntu -d ip4r -c 'create extension ip4r' 346s CREATE EXTENSION 346s psql -d stocks -f bossa.sql 346s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 346s psql:DROP TABLE 346s bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 346s CREATE TABLE 346s CREATE TABLE 346s rm -f regress/out/* 346s pgloader --regress allcols.load 347s 2024-03-19T02:30:46.024010Z LOG pgloader version "3.6.7~devel" 347s 2024-03-19T02:30:46.072030Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 347s 2024-03-19T02:30:46.460186Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 347s 2024-03-19T02:30:46.460186Z WARNING That could impact loading performance badly. 347s 2024-03-19T02:30:46.460186Z WARNING Consider the option 'drop indexes'. 347s 2024-03-19T02:30:46.616249Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 347s 2024-03-19T02:30:46.672271Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/allcols.out") 347s 2024-03-19T02:30:46.728294Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 347s 2024-03-19T02:30:46.976392Z LOG report summary reset 348s table name errors rows bytes total time 348s ----------------------- --------- --------- --------- -------------- 348s fetch 0 0 0.004s 348s before load 0 2 0.064s 348s ----------------------- --------- --------- --------- -------------- 348s "public"."allcols" 0 8 0.2 kB 0.100s 348s "expected"."allcols" 0 8 0.2 kB 0.076s 348s ----------------------- --------- --------- --------- -------------- 348s Files Processed 0 2 0.048s 348s COPY Threads Completion 0 4 0.180s 348s ----------------------- --------- --------- --------- -------------- 348s Total import time ✓ 16 0.4 kB 0.228s 348s 2024-03-19T02:30:47.116447Z LOG Regress pass. 348s touch regress/out/allcols.out 348s pgloader --regress csv-before-after.load 348s 2024-03-19T02:30:48.028011Z LOG pgloader version "3.6.7~devel" 349s 2024-03-19T02:30:48.980367Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-before-after.out") 349s 2024-03-19T02:30:49.036387Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 349s 2024-03-19T02:30:49.304483Z LOG report summary reset 349s table name errors rows bytes total time 349s ----------------------- --------- --------- --------- -------------- 349s fetch 0 0 0.008s 349s before load 0 6 0.060s 349s ----------------------- --------- --------- --------- -------------- 349s "csv"."blocks" 0 460 15.9 kB 0.336s 349s "expected"."blocks" 0 460 12.4 kB 0.104s 349s ----------------------- --------- --------- --------- -------------- 349s Files Processed 0 2 0.040s 349s COPY Threads Completion 0 4 0.444s 349s after load 0 1 0.060s 349s ----------------------- --------- --------- --------- -------------- 349s Total import time ✓ 920 28.2 kB 0.544s 349s 2024-03-19T02:30:49.436531Z LOG Regress pass. 349s touch regress/out/csv-before-after.out 349s pgloader --regress csv-districts.load 350s 2024-03-19T02:30:50.032011Z LOG pgloader version "3.6.7~devel" 350s 2024-03-19T02:30:50.928318Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-districts.out") 351s 2024-03-19T02:30:50.988338Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 351s 2024-03-19T02:30:51.228418Z LOG report summary reset 351s table name errors rows bytes total time 351s ----------------------- --------- --------- --------- -------------- 351s fetch 0 0 0.008s 351s before load 0 2 0.064s 351s ----------------------- --------- --------- --------- -------------- 351s "public"."districts" 0 440 29.3 kB 0.352s 351s "expected"."districts" 0 440 29.1 kB 0.072s 351s ----------------------- --------- --------- --------- -------------- 351s Files Processed 0 2 0.056s 351s COPY Threads Completion 0 4 0.416s 351s ----------------------- --------- --------- --------- -------------- 351s Total import time ✓ 880 58.3 kB 0.472s 351s 2024-03-19T02:30:51.352458Z LOG Regress pass. 351s touch regress/out/csv-districts.out 351s pgloader --regress csv-parse-date.load 351s 2024-03-19T02:30:51.024007Z LOG pgloader version "3.6.7~devel" 352s 2024-03-19T02:30:51.652209Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-parse-date.out") 352s 2024-03-19T02:30:51.708226Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 352s 2024-03-19T02:30:51.928293Z LOG report summary reset 352s table name errors rows bytes total time 352s ----------------------- --------- --------- --------- -------------- 352s fetch 0 0 0.004s 352s before load 0 2 0.064s 352s ----------------------- --------- --------- --------- -------------- 352s "public"."dateformat" 0 4 0.1 kB 0.108s 352s "expected"."dateformat" 0 4 0.1 kB 0.056s 352s ----------------------- --------- --------- --------- -------------- 352s Files Processed 0 2 0.060s 352s COPY Threads Completion 0 4 0.156s 352s ----------------------- --------- --------- --------- -------------- 352s Total import time ✓ 8 0.3 kB 0.216s 352s 2024-03-19T02:30:52.044329Z LOG Regress pass. 352s touch regress/out/csv-parse-date.out 352s pgloader --regress csv-error.load 352s 2024-03-19T02:30:52.028008Z LOG pgloader version "3.6.7~devel" 353s 2024-03-19T02:30:52.564169Z FATAL :ASCII stream decoding error on 353s #: 353s 353s the octet sequence #(195) cannot be decoded. 353s 2024-03-19T02:30:52.596178Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 353s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 353s 2024-03-19T02:30:52.672200Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-error.out") 353s 2024-03-19T02:30:52.728217Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 353s 2024-03-19T02:30:52.948281Z LOG report summary reset 353s table name errors rows bytes total time 353s ----------------------- --------- --------- --------- -------------- 353s fetch 0 0 0.008s 353s before load 0 2 0.068s 353s ----------------------- --------- --------- --------- -------------- 353s "public"."jordane" 3 3 0.1 kB 0.104s 353s "expected"."jordane" 0 3 0.1 kB 0.060s 353s ----------------------- --------- --------- --------- -------------- 353s Files Processed 0 2 0.056s 353s COPY Threads Completion 0 4 0.152s 353s ----------------------- --------- --------- --------- -------------- 353s Total import time 3 6 0.2 kB 0.208s 353s 2024-03-19T02:30:53.064315Z LOG Regress pass. 354s touch regress/out/csv-error.out 354s pgloader --regress csv-escape-mode.load 354s 2024-03-19T02:30:54.028008Z LOG pgloader version "3.6.7~devel" 354s 2024-03-19T02:30:54.452126Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 354s 2024-03-19T02:30:54.452126Z WARNING That could impact loading performance badly. 354s 2024-03-19T02:30:54.452126Z WARNING Consider the option 'drop indexes'. 354s 2024-03-19T02:30:54.712199Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-escape-mode.out") 354s 2024-03-19T02:30:54.764214Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 355s 2024-03-19T02:30:54.972269Z LOG report summary reset 355s table name errors rows bytes total time 355s ---------------------------- --------- --------- --------- -------------- 355s fetch 0 0 0.004s 355s before load 0 2 0.064s 355s ---------------------------- --------- --------- --------- -------------- 355s "public"."csv_escape_mode" 0 5 0.1 kB 0.148s 355s "expected"."csv_escape_mode" 0 5 0.1 kB 0.056s 355s ---------------------------- --------- --------- --------- -------------- 355s Files Processed 0 2 0.048s 355s COPY Threads Completion 0 4 0.204s 355s ---------------------------- --------- --------- --------- -------------- 355s Total import time ✓ 10 0.2 kB 0.252s 355s 2024-03-19T02:30:55.088301Z LOG Regress pass. 355s touch regress/out/csv-escape-mode.out 355s pgloader --regress csv-filename-pattern.load 355s 2024-03-19T02:30:55.032009Z LOG pgloader version "3.6.7~devel" 356s 2024-03-19T02:30:55.812213Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-filename-pattern.out") 356s 2024-03-19T02:30:55.868227Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 356s 2024-03-19T02:30:56.116291Z LOG report summary reset 356s table name errors rows bytes total time 356s ----------------------- --------- --------- --------- -------------- 356s fetch 0 0 0.008s 356s before load 0 2 0.060s 356s ----------------------- --------- --------- --------- -------------- 356s "public"."matching" 0 3 0.0 kB 0.100s 356s "expected"."matching" 0 3 0.0 kB 0.080s 356s ----------------------- --------- --------- --------- -------------- 356s Files Processed 0 4 0.060s 356s COPY Threads Completion 0 8 0.332s 356s ----------------------- --------- --------- --------- -------------- 356s Total import time ✓ 6 0.0 kB 0.392s 356s 2024-03-19T02:30:56.236321Z LOG Regress pass. 356s touch regress/out/csv-filename-pattern.out 356s pgloader --regress csv-guess.load 357s 2024-03-19T02:30:56.024006Z LOG pgloader version "3.6.7~devel" 357s 2024-03-19T02:30:56.444109Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 357s 2024-03-19T02:30:56.444109Z WARNING That could impact loading performance badly. 357s 2024-03-19T02:30:56.444109Z WARNING Consider the option 'drop indexes'. 358s 2024-03-19T02:30:57.436345Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-guess.out") 358s 2024-03-19T02:30:57.492358Z WARNING PostgreSQL warning: table "track" does not exist, skipping 358s 2024-03-19T02:30:57.836437Z LOG report summary reset 358s table name errors rows bytes total time 358s ----------------------- --------- --------- --------- -------------- 358s fetch 0 0 0.008s 358s before load 0 2 0.064s 358s ----------------------- --------- --------- --------- -------------- 358s "csv"."track" 0 3503 366.8 kB 0.880s 358s "expected"."track" 0 3503 366.8 kB 0.180s 358s ----------------------- --------- --------- --------- -------------- 358s Files Processed 0 2 0.040s 358s COPY Threads Completion 0 4 1.068s 358s ----------------------- --------- --------- --------- -------------- 358s Total import time ✓ 7006 733.5 kB 1.108s 359s 2024-03-19T02:30:57.968468Z LOG Regress pass. 359s touch regress/out/csv-guess.out 359s pgloader --regress csv-header.load 359s 2024-03-19T02:30:59.020005Z LOG pgloader version "3.6.7~devel" 359s 2024-03-19T02:30:59.740165Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-header.out") 360s 2024-03-19T02:30:59.796176Z WARNING PostgreSQL warning: table "group" does not exist, skipping 360s 2024-03-19T02:31:00.056233Z LOG report summary reset 360s table name errors rows bytes total time 360s ----------------------- --------- --------- --------- -------------- 360s fetch 0 0 0.008s 360s before load 0 2 0.068s 360s ----------------------- --------- --------- --------- -------------- 360s "public"."group" 0 2 0.0 kB 0.088s 360s "expected"."group" 0 2 0.0 kB 0.064s 360s ----------------------- --------- --------- --------- -------------- 360s Files Processed 0 2 0.116s 360s COPY Threads Completion 0 4 0.144s 360s ----------------------- --------- --------- --------- -------------- 360s Total import time ✓ 4 0.1 kB 0.260s 360s 2024-03-19T02:31:00.172257Z LOG Regress pass. 360s touch regress/out/csv-header.out 360s pgloader --regress csv-json.load 360s 2024-03-19T02:31:00.020004Z LOG pgloader version "3.6.7~devel" 361s 2024-03-19T02:31:00.636134Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-json.out") 361s 2024-03-19T02:31:00.692145Z WARNING PostgreSQL warning: table "json" does not exist, skipping 361s 2024-03-19T02:31:00.904188Z LOG report summary reset 361s table name errors rows bytes total time 361s ----------------------- --------- --------- --------- -------------- 361s fetch 0 0 0.004s 361s before load 0 2 0.064s 361s ----------------------- --------- --------- --------- -------------- 361s "public"."json" 0 15 1.1 kB 0.096s 361s "expected"."json" 0 15 1.1 kB 0.056s 361s ----------------------- --------- --------- --------- -------------- 361s Files Processed 0 2 0.052s 361s COPY Threads Completion 0 4 0.144s 361s ----------------------- --------- --------- --------- -------------- 361s Total import time ✓ 30 2.3 kB 0.196s 361s 2024-03-19T02:31:01.024212Z LOG Regress pass. 361s touch regress/out/csv-json.out 361s pgloader --regress csv-keep-extra-blanks.load 361s 2024-03-19T02:31:01.024005Z LOG pgloader version "3.6.7~devel" 362s 2024-03-19T02:31:01.664132Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-keep-extra-blanks.out") 362s 2024-03-19T02:31:01.720143Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 362s 2024-03-19T02:31:01.940185Z LOG report summary reset 362s table name errors rows bytes total time 362s ----------------------- --------- --------- --------- -------------- 362s fetch 0 0 0.008s 362s before load 0 2 0.064s 362s ----------------------- --------- --------- --------- -------------- 362s "public"."nulls" 0 7 0.3 kB 0.116s 362s "expected"."nulls" 0 6 0.3 kB 0.056s 362s ----------------------- --------- --------- --------- -------------- 362s Files Processed 0 2 0.052s 362s COPY Threads Completion 0 4 0.172s 362s ----------------------- --------- --------- --------- -------------- 362s Total import time ✓ 13 0.6 kB 0.224s 362s 2024-03-19T02:31:02.056207Z LOG Regress pass. 363s touch regress/out/csv-keep-extra-blanks.out 363s pgloader --regress csv-missing-col.load 363s 2024-03-19T02:31:03.024005Z LOG pgloader version "3.6.7~devel" 363s 2024-03-19T02:31:03.568107Z LOG COPY INIT ERROR 363s 2024-03-19T02:31:03.576109Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 363s Database error 42703: column "c" of relation "missingcol" does not exist 363s 2024-03-19T02:31:03.648122Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-missing-col.out") 363s 2024-03-19T02:31:03.704133Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 364s 2024-03-19T02:31:03.932174Z LOG report summary reset 364s table name errors rows bytes total time 364s ----------------------- --------- --------- --------- -------------- 364s fetch 0 0 0.008s 364s before load 0 2 0.060s 364s ----------------------- --------- --------- --------- -------------- 364s "public"."missingcol" 1 0 0.072s 364s "expected"."missingcol" 0 0 0.056s 364s ----------------------- --------- --------- --------- -------------- 364s Files Processed 0 2 0.056s 364s COPY Threads Completion 0 4 0.156s 364s ----------------------- --------- --------- --------- -------------- 364s Total import time 1 0 0.212s 364s 2024-03-19T02:31:04.044195Z LOG Regress pass. 364s touch regress/out/csv-missing-col.out 364s pgloader --regress csv-non-printable.load 364s 2024-03-19T02:31:04.020003Z LOG pgloader version "3.6.7~devel" 365s 2024-03-19T02:31:04.660118Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-non-printable.out") 365s 2024-03-19T02:31:04.720129Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 365s 2024-03-19T02:31:04.944167Z LOG report summary reset 365s table name errors rows bytes total time 365s ----------------------- --------- --------- --------- -------------- 365s fetch 0 0 0.004s 365s before load 0 2 0.060s 365s ----------------------- --------- --------- --------- -------------- 365s "public"."tab_csv" 0 7 0.2 kB 0.112s 365s "expected"."tab_csv" 0 7 0.2 kB 0.056s 365s ----------------------- --------- --------- --------- -------------- 365s Files Processed 0 2 0.060s 365s COPY Threads Completion 0 4 0.156s 365s ----------------------- --------- --------- --------- -------------- 365s Total import time ✓ 14 0.4 kB 0.216s 365s 2024-03-19T02:31:05.060187Z LOG Regress pass. 365s touch regress/out/csv-non-printable.out 365s pgloader --regress csv-nulls.load 365s 2024-03-19T02:31:05.028005Z LOG pgloader version "3.6.7~devel" 365s 2024-03-19T02:31:05.036006Z LOG Data errors in '/tmp/pgloader/' 365s 2024-03-19T02:31:05.036006Z LOG Regression testing: "csv-nulls.load" 365s 2024-03-19T02:31:05.036006Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/csv-nulls.load" 366s 2024-03-19T02:31:05.452078Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 366s 2024-03-19T02:31:05.452078Z WARNING That could impact loading performance badly. 366s 2024-03-19T02:31:05.452078Z WARNING Consider the option 'drop indexes'. 366s 2024-03-19T02:31:05.668114Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-nulls.out") 366s 2024-03-19T02:31:05.724123Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 366s 2024-03-19T02:31:05.940158Z LOG report summary reset 366s table name errors rows bytes total time 366s ----------------------- --------- --------- --------- -------------- 366s fetch 0 0 0.008s 366s before load 0 2 0.064s 366s ----------------------- --------- --------- --------- -------------- 366s "public"."nullif" 0 2 0.0 kB 0.108s 366s "expected"."nullif" 0 2 0.0 kB 0.056s 366s ----------------------- --------- --------- --------- -------------- 366s Files Processed 0 2 0.040s 366s COPY Threads Completion 0 4 0.168s 366s ----------------------- --------- --------- --------- -------------- 366s Total import time ✓ 4 0.1 kB 0.208s 366s 2024-03-19T02:31:06.056178Z LOG Regress pass. 366s touch regress/out/csv-nulls.out 366s pgloader --regress csv-temp.load 367s 2024-03-19T02:31:07.028005Z LOG pgloader version "3.6.7~devel" 367s 2024-03-19T02:31:07.648105Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-temp.out") 367s 2024-03-19T02:31:07.704114Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 368s 2024-03-19T02:31:07.928149Z LOG report summary reset 368s table name errors rows bytes total time 368s ----------------------- --------- --------- --------- -------------- 368s fetch 0 0 0.008s 368s before load 0 2 0.060s 368s ----------------------- --------- --------- --------- -------------- 368s "public"."temp" 0 5 0.2 kB 0.108s 368s "expected"."temp" 0 5 0.2 kB 0.056s 368s ----------------------- --------- --------- --------- -------------- 368s Files Processed 0 2 0.068s 368s COPY Threads Completion 0 4 0.152s 368s ----------------------- --------- --------- --------- -------------- 368s Total import time ✓ 10 0.3 kB 0.220s 368s 2024-03-19T02:31:08.044167Z LOG Regress pass. 368s touch regress/out/csv-temp.out 368s pgloader --regress csv-trim-extra-blanks.load 368s 2024-03-19T02:31:08.020003Z LOG pgloader version "3.6.7~devel" 369s 2024-03-19T02:31:08.660102Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-trim-extra-blanks.out") 369s 2024-03-19T02:31:08.936144Z LOG report summary reset 369s table name errors rows bytes total time 369s ----------------------- --------- --------- --------- -------------- 369s fetch 0 0 0.008s 369s before load 0 2 0.064s 369s ----------------------- --------- --------- --------- -------------- 369s "public"."nulls" 0 7 0.3 kB 0.108s 369s "expected"."nulls" 0 7 0.3 kB 0.060s 369s ----------------------- --------- --------- --------- -------------- 369s Files Processed 0 2 0.060s 369s COPY Threads Completion 0 4 0.152s 369s ----------------------- --------- --------- --------- -------------- 369s Total import time ✓ 14 0.6 kB 0.212s 369s 2024-03-19T02:31:09.052161Z LOG Regress pass. 369s touch regress/out/csv-trim-extra-blanks.out 369s pgloader --regress csv-using-sexp.load 369s 2024-03-19T02:31:09.028004Z LOG pgloader version "3.6.7~devel" 370s 2024-03-19T02:31:09.644096Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv-using-sexp.out") 370s 2024-03-19T02:31:09.700104Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 370s 2024-03-19T02:31:09.920135Z LOG report summary reset 370s table name errors rows bytes total time 370s ----------------------- --------- --------- --------- -------------- 370s fetch 0 0 0.008s 370s before load 0 2 0.060s 370s ----------------------- --------- --------- --------- -------------- 370s "public"."sexp" 0 3 0.0 kB 0.104s 370s "expected"."sexp" 0 3 0.0 kB 0.056s 370s ----------------------- --------- --------- --------- -------------- 370s Files Processed 0 2 0.052s 370s COPY Threads Completion 0 4 0.156s 370s ----------------------- --------- --------- --------- -------------- 370s Total import time ✓ 6 0.1 kB 0.208s 370s 2024-03-19T02:31:10.032151Z LOG Regress pass. 370s touch regress/out/csv-using-sexp.out 370s pgloader --regress csv.load 370s 2024-03-19T02:31:10.020003Z LOG pgloader version "3.6.7~devel" 371s 2024-03-19T02:31:10.076011Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 371s 2024-03-19T02:31:10.620088Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 371s 2024-03-19T02:31:10.676096Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/csv.out") 371s 2024-03-19T02:31:10.736104Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 371s 2024-03-19T02:31:10.964135Z LOG report summary reset 372s table name errors rows bytes total time 372s ----------------------- --------- --------- --------- -------------- 372s fetch 0 0 0.008s 372s before load 0 2 0.064s 372s ----------------------- --------- --------- --------- -------------- 372s "public"."csv" 0 6 0.2 kB 0.116s 372s "expected"."csv" 0 6 0.2 kB 0.060s 372s ----------------------- --------- --------- --------- -------------- 372s Files Processed 0 2 0.060s 372s COPY Threads Completion 0 4 0.164s 372s ----------------------- --------- --------- --------- -------------- 372s Total import time ✓ 12 0.4 kB 0.224s 372s 2024-03-19T02:31:11.088152Z LOG Regress pass. 372s touch regress/out/csv.out 372s pgloader --regress copy.load 372s 2024-03-19T02:31:12.020003Z LOG pgloader version "3.6.7~devel" 372s 2024-03-19T02:31:12.032004Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/copy.load" 372s 2024-03-19T02:31:12.076010Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 373s 2024-03-19T02:31:12.852114Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 373s 2024-03-19T02:31:12.908121Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/copy.out") 373s 2024-03-19T02:31:12.964129Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 373s 2024-03-19T02:31:13.292172Z LOG report summary reset 373s table name errors rows bytes total time 373s ----------------------- --------- --------- --------- -------------- 373s fetch 0 0 0.008s 373s before load 0 2 0.064s 373s ----------------------- --------- --------- --------- -------------- 373s "public"."track_full" 0 3503 366.8 kB 0.208s 373s "expected"."track_full" 0 3503 366.8 kB 0.172s 373s ----------------------- --------- --------- --------- -------------- 373s Files Processed 0 2 0.028s 373s COPY Threads Completion 0 4 0.384s 373s Index Build Completion 0 0 0.064s 373s Create Indexes 0 1 0.004s 373s Constraints 0 1 0.000s 373s ----------------------- --------- --------- --------- -------------- 373s Total import time ✓ 7006 733.5 kB 0.480s 373s 2024-03-19T02:31:13.420189Z LOG Regress pass. 373s touch regress/out/copy.out 373s pgloader --regress copy-hex.load 373s 2024-03-19T02:31:13.028004Z LOG pgloader version "3.6.7~devel" 374s 2024-03-19T02:31:13.624081Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/copy-hex.out") 374s 2024-03-19T02:31:13.680088Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 374s 2024-03-19T02:31:13.888113Z LOG report summary reset 374s table name errors rows bytes total time 374s ----------------------- --------- --------- --------- -------------- 374s fetch 0 0 0.008s 374s before load 0 2 0.060s 374s ----------------------- --------- --------- --------- -------------- 374s "public"."copyhex" 0 6 0.0 kB 0.080s 374s "expected"."copyhex" 0 6 0.0 kB 0.056s 374s ----------------------- --------- --------- --------- -------------- 374s Files Processed 0 2 0.036s 374s COPY Threads Completion 0 4 0.140s 375s ----------------------- --------- --------- --------- -------------- 375s Total import time ✓ 12 0.1 kB 0.176s 375s 2024-03-19T02:31:14.008129Z LOG Regress pass. 375s touch regress/out/copy-hex.out 375s pgloader --regress dbf.load 375s 2024-03-19T02:31:15.028005Z LOG pgloader version "3.6.7~devel" 375s 2024-03-19T02:31:15.232030Z LOG Migrating from # 375s 2024-03-19T02:31:15.232030Z LOG Migrating into # 375s 2024-03-19T02:31:15.452057Z WARNING Forcing encoding to CP850, db3 file has ASCII 375s 2024-03-19T02:31:15.668084Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/dbf.out") 375s 2024-03-19T02:31:15.724091Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 376s 2024-03-19T02:31:16.004124Z LOG report summary reset 376s table name errors rows bytes total time 376s ----------------------- --------- --------- --------- -------------- 376s fetch 0 0 0.008s 376s Create Schemas 0 0 0.000s 376s Create SQL Types 0 0 0.008s 376s Create tables 0 2 0.032s 376s ----------------------- --------- --------- --------- -------------- 376s public.reg2013 0 27 1.0 kB 0.080s 376s "expected"."reg2013" 0 27 1.0 kB 0.064s 376s ----------------------- --------- --------- --------- -------------- 376s COPY Threads Completion 0 6 0.140s 376s Create Triggers 0 0 0.000s 376s Install Comments 0 0 0.000s 376s Files Processed 0 1 0.016s 376s ----------------------- --------- --------- --------- -------------- 376s Total import time ✓ 54 1.9 kB 0.156s 376s 2024-03-19T02:31:16.132141Z LOG Regress pass. 376s touch regress/out/dbf.out 376s pgloader --regress errors.load 376s 2024-03-19T02:31:16.020003Z LOG pgloader version "3.6.7~devel" 376s 2024-03-19T02:31:16.076010Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 377s 2024-03-19T02:31:16.456055Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 377s 2024-03-19T02:31:16.456055Z WARNING That could impact loading performance badly. 377s 2024-03-19T02:31:16.456055Z WARNING Consider the option 'drop indexes'. 377s 2024-03-19T02:31:16.568068Z ERROR End of file while collecting quoted item: # 377s 2024-03-19T02:31:16.568068Z FATAL End of file while collecting quoted item: # 377s 2024-03-19T02:31:16.596072Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 377s HINT: Perhaps you need a different "datestyle" setting. 377s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 377s 2024-03-19T02:31:16.596072Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 377s HINT: Perhaps you need a different "datestyle" setting. 377s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 377s 2024-03-19T02:31:16.596072Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 377s HINT: Perhaps you need a different "datestyle" setting. 377s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 377s 2024-03-19T02:31:16.620075Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 377s 2024-03-19T02:31:16.680083Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/errors.out") 377s 2024-03-19T02:31:16.736089Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 377s 2024-03-19T02:31:16.960114Z LOG report summary reset 377s table name errors rows bytes total time 377s ----------------------- --------- --------- --------- -------------- 377s fetch 0 0 0.008s 377s before load 0 4 0.060s 377s ----------------------- --------- --------- --------- -------------- 377s "err"."errors" 8 7 0.3 kB 0.108s 377s "expected"."errors" 0 7 0.2 kB 0.060s 377s ----------------------- --------- --------- --------- -------------- 377s Files Processed 0 2 0.044s 377s COPY Threads Completion 0 4 0.172s 377s ----------------------- --------- --------- --------- -------------- 377s Total import time 8 14 0.6 kB 0.216s 377s 2024-03-19T02:31:17.080128Z LOG Regress pass. 377s touch regress/out/errors.out 377s pgloader --regress fixed.load 377s 2024-03-19T02:31:17.020003Z LOG pgloader version "3.6.7~devel" 377s 2024-03-19T02:31:17.076009Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 378s 2024-03-19T02:31:17.724084Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 378s 2024-03-19T02:31:17.784090Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/fixed.out") 378s 2024-03-19T02:31:17.840097Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 378s 2024-03-19T02:31:18.060122Z LOG report summary reset 379s table name errors rows bytes total time 379s ----------------------- --------- --------- --------- -------------- 379s fetch 0 0 0.008s 379s before load 0 2 0.064s 379s ----------------------- --------- --------- --------- -------------- 379s "public"."fixed" 0 5 0.2 kB 0.088s 379s "expected"."fixed" 0 5 0.2 kB 0.056s 379s ----------------------- --------- --------- --------- -------------- 379s Files Processed 0 2 0.036s 379s COPY Threads Completion 0 4 0.148s 379s Index Build Completion 0 0 0.056s 379s Create Indexes 0 1 0.000s 379s Constraints 0 1 0.000s 379s ----------------------- --------- --------- --------- -------------- 379s Total import time ✓ 10 0.4 kB 0.240s 379s 2024-03-19T02:31:18.180135Z LOG Regress pass. 379s touch regress/out/fixed.out 379s pgloader --regress fields-with-periods.load 379s 2024-03-19T02:31:19.028004Z LOG pgloader version "3.6.7~devel" 379s 2024-03-19T02:31:19.036004Z LOG Data errors in '/tmp/pgloader/' 379s 2024-03-19T02:31:19.036004Z LOG Regression testing: "fields-with-periods.load" 379s 2024-03-19T02:31:19.036004Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/fields-with-periods.load" 379s 2024-03-19T02:31:19.644072Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/fields-with-periods.out") 380s 2024-03-19T02:31:19.948105Z LOG report summary reset 380s table name errors rows bytes total time 380s ----------------------- --------- --------- --------- -------------- 380s fetch 0 0 0.008s 380s before load 0 2 0.064s 380s ----------------------- --------- --------- --------- -------------- 380s "public"."fixed" 0 3 0.0 kB 0.080s 380s "expected"."fixed" 0 3 0.0 kB 0.060s 380s ----------------------- --------- --------- --------- -------------- 380s Files Processed 0 2 0.056s 380s COPY Threads Completion 0 4 0.132s 380s ----------------------- --------- --------- --------- -------------- 380s Total import time ✓ 6 0.0 kB 0.188s 380s 2024-03-19T02:31:20.068118Z LOG Regress pass. 380s touch regress/out/fields-with-periods.out 380s pgloader --regress ixf.load 380s 2024-03-19T02:31:20.024002Z LOG pgloader version "3.6.7~devel" 380s 2024-03-19T02:31:20.284031Z LOG Migrating from # 380s 2024-03-19T02:31:20.288031Z LOG Migrating into # 381s 2024-03-19T02:31:20.724079Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/ixf.out") 381s 2024-03-19T02:31:20.776083Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 381s 2024-03-19T02:31:21.056113Z LOG report summary reset 381s table name errors rows bytes total time 381s ----------------------- --------- --------- --------- -------------- 381s fetch 0 0 0.008s 381s before load 0 3 0.060s 381s Create Schemas 0 0 0.000s 381s Create SQL Types 0 0 0.008s 381s Create tables 0 2 0.036s 381s ----------------------- --------- --------- --------- -------------- 381s nsitra.test1 0 4 0.2 kB 0.072s 381s "expected"."test1" 0 4 0.2 kB 0.060s 381s ----------------------- --------- --------- --------- -------------- 381s COPY Threads Completion 0 6 0.132s 381s Index Build Completion 0 0 0.008s 381s Primary Keys 0 0 0.000s 381s Create Triggers 0 0 0.000s 381s Install Comments 0 0 0.000s 381s Files Processed 0 1 0.020s 381s ----------------------- --------- --------- --------- -------------- 381s Total import time ✓ 8 0.3 kB 0.160s 381s 2024-03-19T02:31:21.168125Z LOG Regress pass. 381s touch regress/out/ixf.out 381s pgloader --regress overflow.load 382s 2024-03-19T02:31:22.024002Z LOG pgloader version "3.6.7~devel" 382s 2024-03-19T02:31:22.560059Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 382s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 382s 2024-03-19T02:31:22.564060Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 382s DETAIL: Failing row contains (12, null). 382s CONTEXT: COPY overflow, line 1: "12 \N" 382s 2024-03-19T02:31:22.640067Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/overflow.out") 382s 2024-03-19T02:31:22.696073Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 382s 2024-03-19T02:31:22.908094Z LOG report summary reset 383s table name errors rows bytes total time 383s ----------------------- --------- --------- --------- -------------- 383s fetch 0 0 0.008s 383s before load 0 2 0.060s 383s ----------------------- --------- --------- --------- -------------- 383s "public"."overflow" 4 0 0.0 kB 0.100s 383s "expected"."overflow" 0 0 0.052s 383s ----------------------- --------- --------- --------- -------------- 383s Files Processed 0 2 0.056s 383s COPY Threads Completion 0 4 0.148s 383s ----------------------- --------- --------- --------- -------------- 383s Total import time 4 0 0.0 kB 0.204s 383s 2024-03-19T02:31:23.024106Z LOG Regress pass. 383s touch regress/out/overflow.out 383s pgloader --regress partial.load 383s 2024-03-19T02:31:23.024003Z LOG pgloader version "3.6.7~devel" 383s 2024-03-19T02:31:23.032004Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/partial.load" 383s 2024-03-19T02:31:23.076008Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 384s 2024-03-19T02:31:23.800081Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 384s 2024-03-19T02:31:23.856086Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/partial.out") 384s 2024-03-19T02:31:23.912092Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 384s 2024-03-19T02:31:24.152117Z LOG report summary reset 384s table name errors rows bytes total time 384s ----------------------- --------- --------- --------- -------------- 384s fetch 0 0 0.004s 384s before load 0 4 0.064s 384s ----------------------- --------- --------- --------- -------------- 384s "csv"."partial" 0 7 0.1 kB 0.104s 384s "expected"."partial" 0 7 0.1 kB 0.072s 384s ----------------------- --------- --------- --------- -------------- 384s Files Processed 0 2 0.044s 384s COPY Threads Completion 0 4 0.180s 384s Index Build Completion 0 0 0.112s 384s Create Indexes 0 2 0.008s 384s Constraints 0 1 0.000s 384s ----------------------- --------- --------- --------- -------------- 384s Total import time ✓ 14 0.2 kB 0.344s 384s 2024-03-19T02:31:24.276129Z LOG Regress pass. 384s touch regress/out/partial.out 384s pgloader --regress serial.load 384s 2024-03-19T02:31:24.024002Z LOG pgloader version "3.6.7~devel" 384s 2024-03-19T02:31:24.072007Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-03-19T02:31:24.476048Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 385s 2024-03-19T02:31:24.476048Z WARNING That could impact loading performance badly. 385s 2024-03-19T02:31:24.476048Z WARNING Consider the option 'drop indexes'. 385s 2024-03-19T02:31:24.648064Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-03-19T02:31:24.708070Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/serial.out") 385s 2024-03-19T02:31:24.768075Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 385s 2024-03-19T02:31:25.000098Z LOG report summary reset 385s table name errors rows bytes total time 385s ----------------------- --------- --------- --------- -------------- 386s fetch 0 0 0.004s 386s before load 0 2 0.068s 386s ----------------------- --------- --------- --------- -------------- 386s "public"."serial" 0 7 0.2 kB 0.112s 386s "expected"."serial" 0 7 0.2 kB 0.056s 386s ----------------------- --------- --------- --------- -------------- 386s Files Processed 0 2 0.048s 386s COPY Threads Completion 0 4 0.172s 386s ----------------------- --------- --------- --------- -------------- 386s Total import time ✓ 14 0.4 kB 0.220s 386s 2024-03-19T02:31:25.124110Z LOG Regress pass. 386s touch regress/out/serial.out 386s pgloader --regress udc.load 386s 2024-03-19T02:31:26.028002Z LOG pgloader version "3.6.7~devel" 386s 2024-03-19T02:31:26.036003Z LOG Data errors in '/tmp/pgloader/' 386s 2024-03-19T02:31:26.036003Z LOG Regression testing: "udc.load" 386s 2024-03-19T02:31:26.036003Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/udc.load" 386s 2024-03-19T02:31:26.088008Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 386s 2024-03-19T02:31:26.492047Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 386s 2024-03-19T02:31:26.492047Z WARNING That could impact loading performance badly. 386s 2024-03-19T02:31:26.492047Z WARNING Consider the option 'drop indexes'. 386s 2024-03-19T02:31:26.656063Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 386s 2024-03-19T02:31:26.720069Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/udc.out") 387s 2024-03-19T02:31:26.780074Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 387s 2024-03-19T02:31:27.012097Z LOG report summary reset 387s table name errors rows bytes total time 387s ----------------------- --------- --------- --------- -------------- 387s fetch 0 0 0.008s 387s before load 0 2 0.068s 387s ----------------------- --------- --------- --------- -------------- 387s "public"."udc" 0 5 0.1 kB 0.108s 387s "expected"."udc" 0 5 0.1 kB 0.060s 387s ----------------------- --------- --------- --------- -------------- 387s Files Processed 0 2 0.048s 387s COPY Threads Completion 0 4 0.172s 387s ----------------------- --------- --------- --------- -------------- 387s Total import time ✓ 10 0.2 kB 0.220s 387s 2024-03-19T02:31:27.128107Z LOG Regress pass. 387s touch regress/out/udc.out 387s pgloader --regress xzero.load 387s 2024-03-19T02:31:27.028003Z LOG pgloader version "3.6.7~devel" 387s 2024-03-19T02:31:27.040004Z LOG Data errors in '/tmp/pgloader/' 387s 2024-03-19T02:31:27.040004Z LOG Regression testing: "xzero.load" 387s 2024-03-19T02:31:27.040004Z LOG Parsing commands from file #P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/xzero.load" 387s 2024-03-19T02:31:27.076007Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 388s 2024-03-19T02:31:27.460043Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 388s 2024-03-19T02:31:27.460043Z WARNING That could impact loading performance badly. 388s 2024-03-19T02:31:27.460043Z WARNING Consider the option 'drop indexes'. 388s 2024-03-19T02:31:27.612059Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 388s 2024-03-19T02:31:27.672064Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.v1wWEU/build.XJW/src/test/regress/expected/xzero.out") 388s 2024-03-19T02:31:27.728069Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 388s 2024-03-19T02:31:27.948089Z LOG report summary reset 388s table name errors rows bytes total time 388s ----------------------- --------- --------- --------- -------------- 388s fetch 0 0 0.008s 388s before load 0 2 0.060s 388s ----------------------- --------- --------- --------- -------------- 388s "public"."xzero" 0 7 0.2 kB 0.100s 388s "expected"."xzero" 0 7 0.2 kB 0.056s 388s ----------------------- --------- --------- --------- -------------- 388s Files Processed 0 2 0.044s 388s COPY Threads Completion 0 4 0.164s 388s ----------------------- --------- --------- --------- -------------- 388s Total import time ✓ 14 0.4 kB 0.208s 388s 2024-03-19T02:31:28.072100Z LOG Regress pass. 388s touch regress/out/xzero.out 388s make: Leaving directory '/tmp/autopkgtest.v1wWEU/build.XJW/src/test' 388s Dropping cluster 16/regress ... 389s autopkgtest [02:31:29]: test testsuite: -----------------------] 389s testsuite PASS 389s autopkgtest [02:31:29]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 390s autopkgtest [02:31:30]: @@@@@@@@@@@@@@@@@@@@ summary 390s ssl PASS 390s testsuite PASS 404s Creating nova instance adt-noble-ppc64el-pgloader-20240319-022500-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-ppc64el-server-20240319.img (UUID 6e7a6c13-d651-45a1-a24f-48d9d59effd9)... 404s Creating nova instance adt-noble-ppc64el-pgloader-20240319-022500-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-ppc64el-server-20240319.img (UUID 6e7a6c13-d651-45a1-a24f-48d9d59effd9)...