0s autopkgtest [04:27:57]: starting date and time: 2024-11-15 04:27:57+0000 0s autopkgtest [04:27:57]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [04:27:57]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.812hixt6/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/266 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-21.secgroup --name adt-plucky-ppc64el-pgloader-20241115-042756-juju-7f2275-prod-proposed-migration-environment-20-5a80db18-6867-4c91-ac82-66fe86807979 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 59s autopkgtest [04:28:56]: testbed dpkg architecture: ppc64el 59s autopkgtest [04:28:56]: testbed apt version: 2.9.8 59s autopkgtest [04:28:56]: @@@@@@@@@@@@@@@@@@@@ test bed setup 60s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 60s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 60s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 60s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.3 kB] 60s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1027 kB] 61s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [176 kB] 61s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [768 kB] 61s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [8632 B] 61s Fetched 2175 kB in 1s (2118 kB/s) 61s Reading package lists... 63s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s Calculating upgrade... 64s The following packages will be upgraded: 64s bpfcc-tools bpftrace firmware-sof-signed libbpfcc libcap-ng0 libexpat1 64s libgnutls30t64 libjson-glib-1.0-0 libjson-glib-1.0-common libnewt0.52 64s libutempter0 lxd-installer man-db pastebinit python3-bpfcc python3-newt 64s python3-systemd whiptail xfsprogs 64s 19 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s Need to get 14.2 MB of archives. 64s After this operation, 623 kB of additional disk space will be used. 64s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 65s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcap-ng0 ppc64el 0.8.5-3build1 [16.3 kB] 65s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgnutls30t64 ppc64el 3.8.8-2ubuntu1 [1072 kB] 65s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libexpat1 ppc64el 2.6.4-1 [98.1 kB] 65s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-newt ppc64el 0.52.24-2ubuntu4 [21.8 kB] 65s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libnewt0.52 ppc64el 0.52.24-2ubuntu4 [62.1 kB] 65s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el whiptail ppc64el 0.52.24-2ubuntu4 [19.5 kB] 65s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el man-db ppc64el 2.13.0-1 [1361 kB] 65s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el libbpfcc ppc64el 0.30.0+ds-1ubuntu5 [696 kB] 65s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-bpfcc all 0.30.0+ds-1ubuntu5 [40.4 kB] 65s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpfcc-tools all 0.30.0+ds-1ubuntu5 [697 kB] 65s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpftrace ppc64el 0.21.2-2ubuntu2 [1898 kB] 65s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-common all 1.10.0+ds-3 [5586 B] 65s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-0 ppc64el 1.10.0+ds-3 [76.0 kB] 65s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el libutempter0 ppc64el 1.2.1-4 [9850 B] 65s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el lxd-installer all 9 [5084 B] 65s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el pastebinit all 1.7.1-1 [14.9 kB] 65s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-systemd ppc64el 235-1build5 [48.7 kB] 65s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el xfsprogs ppc64el 6.8.0-2.2ubuntu2 [995 kB] 65s Preconfiguring packages ... 66s Fetched 14.2 MB in 1s (11.6 MB/s) 66s (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 ... 73767 files and directories currently installed.) 66s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 66s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 66s Preparing to unpack .../libcap-ng0_0.8.5-3build1_ppc64el.deb ... 66s Unpacking libcap-ng0:ppc64el (0.8.5-3build1) over (0.8.5-1) ... 66s Setting up libcap-ng0:ppc64el (0.8.5-3build1) ... 66s (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 ... 73793 files and directories currently installed.) 66s Preparing to unpack .../libgnutls30t64_3.8.8-2ubuntu1_ppc64el.deb ... 66s Unpacking libgnutls30t64:ppc64el (3.8.8-2ubuntu1) over (3.8.6-2ubuntu1) ... 66s Setting up libgnutls30t64:ppc64el (3.8.8-2ubuntu1) ... 66s (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 ... 73793 files and directories currently installed.) 66s Preparing to unpack .../00-libexpat1_2.6.4-1_ppc64el.deb ... 66s Unpacking libexpat1:ppc64el (2.6.4-1) over (2.6.2-2) ... 66s Preparing to unpack .../01-python3-newt_0.52.24-2ubuntu4_ppc64el.deb ... 66s Unpacking python3-newt:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 66s Preparing to unpack .../02-libnewt0.52_0.52.24-2ubuntu4_ppc64el.deb ... 66s Unpacking libnewt0.52:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 66s Preparing to unpack .../03-whiptail_0.52.24-2ubuntu4_ppc64el.deb ... 66s Unpacking whiptail (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 66s Preparing to unpack .../04-man-db_2.13.0-1_ppc64el.deb ... 66s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 66s Preparing to unpack .../05-libbpfcc_0.30.0+ds-1ubuntu5_ppc64el.deb ... 66s Unpacking libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 66s Preparing to unpack .../06-python3-bpfcc_0.30.0+ds-1ubuntu5_all.deb ... 67s Unpacking python3-bpfcc (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 67s Preparing to unpack .../07-bpfcc-tools_0.30.0+ds-1ubuntu5_all.deb ... 67s Unpacking bpfcc-tools (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 67s Preparing to unpack .../08-bpftrace_0.21.2-2ubuntu2_ppc64el.deb ... 67s Unpacking bpftrace (0.21.2-2ubuntu2) over (0.21.2-2) ... 67s Preparing to unpack .../09-libjson-glib-1.0-common_1.10.0+ds-3_all.deb ... 67s Unpacking libjson-glib-1.0-common (1.10.0+ds-3) over (1.10.0+ds-2) ... 67s Preparing to unpack .../10-libjson-glib-1.0-0_1.10.0+ds-3_ppc64el.deb ... 67s Unpacking libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) over (1.10.0+ds-2) ... 67s Preparing to unpack .../11-libutempter0_1.2.1-4_ppc64el.deb ... 67s Unpacking libutempter0:ppc64el (1.2.1-4) over (1.2.1-3build1) ... 67s Preparing to unpack .../12-lxd-installer_9_all.deb ... 67s Unpacking lxd-installer (9) over (8) ... 67s Preparing to unpack .../13-pastebinit_1.7.1-1_all.deb ... 67s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 67s Preparing to unpack .../14-python3-systemd_235-1build5_ppc64el.deb ... 67s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 67s Preparing to unpack .../15-xfsprogs_6.8.0-2.2ubuntu2_ppc64el.deb ... 67s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 67s Setting up libexpat1:ppc64el (2.6.4-1) ... 67s Setting up libnewt0.52:ppc64el (0.52.24-2ubuntu4) ... 67s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 67s Setting up pastebinit (1.7.1-1) ... 67s Setting up python3-newt:ppc64el (0.52.24-2ubuntu4) ... 67s Setting up man-db (2.13.0-1) ... 67s Updating database of manual pages ... 70s man-db.service is a disabled or a static unit not running, not starting it. 70s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 70s update-initramfs: deferring update (trigger activated) 71s Setting up lxd-installer (9) ... 71s Setting up libutempter0:ppc64el (1.2.1-4) ... 71s Setting up whiptail (0.52.24-2ubuntu4) ... 71s Setting up libjson-glib-1.0-common (1.10.0+ds-3) ... 71s Setting up libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) ... 71s Setting up python3-bpfcc (0.30.0+ds-1ubuntu5) ... 71s Setting up python3-systemd (235-1build5) ... 71s Setting up bpftrace (0.21.2-2ubuntu2) ... 71s Setting up libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) ... 71s Setting up bpfcc-tools (0.30.0+ds-1ubuntu5) ... 71s Processing triggers for libc-bin (2.40-1ubuntu3) ... 71s Processing triggers for initramfs-tools (0.142ubuntu34) ... 71s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 72s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 80s Reading package lists... 80s Building dependency tree... 80s Reading state information... 80s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 81s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 81s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 81s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 81s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 82s Reading package lists... 82s Reading package lists... 82s Building dependency tree... 82s Reading state information... 82s Calculating upgrade... 83s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s Reading package lists... 83s Building dependency tree... 83s Reading state information... 83s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s autopkgtest [04:29:20]: rebooting testbed after setup commands that affected boot 87s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 117s autopkgtest [04:29:54]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 13:49:23 UTC 2024 120s autopkgtest [04:29:57]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 122s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (dsc) [2932 B] 122s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (tar) [3723 kB] 122s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (diff) [9880 B] 123s gpgv: Signature made Mon Oct 28 11:35:26 2024 UTC 123s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 123s gpgv: Can't check signature: No public key 123s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-4.dsc: no acceptable signature found 123s autopkgtest [04:30:00]: testing package pgloader version 3.6.10-4 123s autopkgtest [04:30:00]: build not needed 124s autopkgtest [04:30:01]: test ssl: preparing testbed 127s Reading package lists... 127s Building dependency tree... 127s Reading state information... 127s Starting pkgProblemResolver with broken count: 0 127s Starting 2 pkgProblemResolver with broken count: 0 127s Done 128s The following additional packages will be installed: 128s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 128s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 128s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 128s cl-usocket freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 128s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql postgresql-17 128s postgresql-client-17 postgresql-client-common postgresql-common ssl-cert 128s Suggested packages: 128s postgresql-doc postgresql-doc-17 128s Recommended packages: 128s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 128s libjson-xs-perl 128s The following NEW packages will be installed: 128s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 128s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 128s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 128s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 128s libct4 libio-pty-perl libipc-run-perl libjson-perl libpq5 libsybdb5 128s libxslt1.1 pgloader postgresql postgresql-17 postgresql-client-17 128s postgresql-client-common postgresql-common ssl-cert 128s 0 upgraded, 35 newly installed, 0 to remove and 0 not upgraded. 128s Need to get 52.0 MB/52.0 MB of archives. 128s After this operation, 134 MB of additional disk space will be used. 128s Get:1 /tmp/autopkgtest.8mC8bw/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [736 B] 128s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 128s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 128s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 128s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-common all 266 [37.0 kB] 128s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.2ubuntu2 [18.0 kB] 128s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-common all 266 [162 kB] 128s Get:8 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-alexandria all 20240125.git8514d8e-1 [204 kB] 128s Get:9 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-rt all 20090812.gita6a7503-1 [13.2 kB] 128s Get:10 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-kmrcl all 1.111-2 [42.7 kB] 128s Get:11 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-base64 all 3.4.0-1 [9304 B] 128s Get:12 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 128s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 128s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-trivial-gray-streams all 20240217.gita7ead68-1 [9956 B] 128s Get:15 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 128s Get:16 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 128s Get:17 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-ironclad all 0.60-2 [1243 kB] 129s Get:18 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 129s Get:19 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-split-sequence all 1:2.0.1-1 [12.2 kB] 129s Get:20 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 129s Get:21 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 129s Get:22 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-usocket all 0.8.3-3 [70.5 kB] 129s Get:23 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-postgres all 20211113.git9d4332f-5 [56.8 kB] 129s Get:24 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-s-sql all 20211113.git9d4332f-5 [61.1 kB] 129s Get:25 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-postmodern all 20211113.git9d4332f-5 [354 kB] 129s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-common all 1.3.17+ds-2build3 [26.9 kB] 129s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el libct4 ppc64el 1.3.17+ds-2build3 [211 kB] 129s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2build3 [238 kB] 129s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-dev ppc64el 1.3.17+ds-2build3 [364 kB] 129s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.0-1 [280 kB] 129s Get:31 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu1 [191 kB] 129s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.0-1 [2251 kB] 129s Get:33 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.0-1 [19.3 MB] 129s Get:34 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql all 17+266 [12.1 kB] 129s Get:35 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgloader ppc64el 3.6.10-4 [25.7 MB] 130s Preconfiguring packages ... 130s Fetched 52.0 MB in 2s (27.0 MB/s) 130s Selecting previously unselected package libjson-perl. 130s (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 ... 73800 files and directories currently installed.) 130s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 130s Unpacking libjson-perl (4.10000-1) ... 130s Selecting previously unselected package libio-pty-perl. 130s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 130s Unpacking libio-pty-perl (1:1.20-1build3) ... 130s Selecting previously unselected package libipc-run-perl. 130s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 130s Unpacking libipc-run-perl (20231003.0-2) ... 131s Selecting previously unselected package postgresql-client-common. 131s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 131s Unpacking postgresql-client-common (266) ... 131s Selecting previously unselected package ssl-cert. 131s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 131s Unpacking ssl-cert (1.1.2ubuntu2) ... 131s Selecting previously unselected package postgresql-common. 131s Preparing to unpack .../05-postgresql-common_266_all.deb ... 131s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 131s Unpacking postgresql-common (266) ... 131s Selecting previously unselected package cl-alexandria. 131s Preparing to unpack .../06-cl-alexandria_20240125.git8514d8e-1_all.deb ... 131s Unpacking cl-alexandria (20240125.git8514d8e-1) ... 131s Selecting previously unselected package cl-rt. 131s Preparing to unpack .../07-cl-rt_20090812.gita6a7503-1_all.deb ... 131s Unpacking cl-rt (20090812.gita6a7503-1) ... 131s Selecting previously unselected package cl-kmrcl. 131s Preparing to unpack .../08-cl-kmrcl_1.111-2_all.deb ... 131s Unpacking cl-kmrcl (1.111-2) ... 131s Selecting previously unselected package cl-base64. 131s Preparing to unpack .../09-cl-base64_3.4.0-1_all.deb ... 131s Unpacking cl-base64 (3.4.0-1) ... 131s Selecting previously unselected package cl-bordeaux-threads. 131s Preparing to unpack .../10-cl-bordeaux-threads_0.8.8-5_all.deb ... 131s Unpacking cl-bordeaux-threads (0.8.8-5) ... 131s Selecting previously unselected package cl-closer-mop. 131s Preparing to unpack .../11-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 131s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 131s Selecting previously unselected package cl-trivial-gray-streams. 131s Preparing to unpack .../12-cl-trivial-gray-streams_20240217.gita7ead68-1_all.deb ... 131s Unpacking cl-trivial-gray-streams (20240217.gita7ead68-1) ... 131s Selecting previously unselected package cl-flexi-streams. 131s Preparing to unpack .../13-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 131s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 131s Selecting previously unselected package cl-global-vars. 131s Preparing to unpack .../14-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 131s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 131s Selecting previously unselected package cl-ironclad. 131s Preparing to unpack .../15-cl-ironclad_0.60-2_all.deb ... 131s Unpacking cl-ironclad (0.60-2) ... 131s Selecting previously unselected package cl-md5. 131s Preparing to unpack .../16-cl-md5_1%3a20210622.git906593f-1_all.deb ... 131s Unpacking cl-md5 (1:20210622.git906593f-1) ... 131s Selecting previously unselected package cl-split-sequence. 131s Preparing to unpack .../17-cl-split-sequence_1%3a2.0.1-1_all.deb ... 131s Unpacking cl-split-sequence (1:2.0.1-1) ... 131s Selecting previously unselected package cl-ppcre. 131s Preparing to unpack .../18-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 131s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 131s Selecting previously unselected package cl-uax-15. 131s Preparing to unpack .../19-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 131s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 131s Selecting previously unselected package cl-usocket. 131s Preparing to unpack .../20-cl-usocket_0.8.3-3_all.deb ... 131s Unpacking cl-usocket (0.8.3-3) ... 131s Selecting previously unselected package cl-postgres. 131s Preparing to unpack .../21-cl-postgres_20211113.git9d4332f-5_all.deb ... 131s Unpacking cl-postgres (20211113.git9d4332f-5) ... 131s Selecting previously unselected package cl-s-sql. 131s Preparing to unpack .../22-cl-s-sql_20211113.git9d4332f-5_all.deb ... 131s Unpacking cl-s-sql (20211113.git9d4332f-5) ... 131s Selecting previously unselected package cl-postmodern. 131s Preparing to unpack .../23-cl-postmodern_20211113.git9d4332f-5_all.deb ... 131s Unpacking cl-postmodern (20211113.git9d4332f-5) ... 131s Selecting previously unselected package freetds-common. 131s Preparing to unpack .../24-freetds-common_1.3.17+ds-2build3_all.deb ... 131s Unpacking freetds-common (1.3.17+ds-2build3) ... 131s Selecting previously unselected package libct4:ppc64el. 131s Preparing to unpack .../25-libct4_1.3.17+ds-2build3_ppc64el.deb ... 131s Unpacking libct4:ppc64el (1.3.17+ds-2build3) ... 131s Selecting previously unselected package libsybdb5:ppc64el. 131s Preparing to unpack .../26-libsybdb5_1.3.17+ds-2build3_ppc64el.deb ... 131s Unpacking libsybdb5:ppc64el (1.3.17+ds-2build3) ... 131s Selecting previously unselected package freetds-dev. 131s Preparing to unpack .../27-freetds-dev_1.3.17+ds-2build3_ppc64el.deb ... 131s Unpacking freetds-dev (1.3.17+ds-2build3) ... 131s Selecting previously unselected package libpq5:ppc64el. 131s Preparing to unpack .../28-libpq5_17.0-1_ppc64el.deb ... 131s Unpacking libpq5:ppc64el (17.0-1) ... 131s Selecting previously unselected package libxslt1.1:ppc64el. 131s Preparing to unpack .../29-libxslt1.1_1.1.39-0exp1ubuntu1_ppc64el.deb ... 131s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 131s Selecting previously unselected package postgresql-client-17. 131s Preparing to unpack .../30-postgresql-client-17_17.0-1_ppc64el.deb ... 131s Unpacking postgresql-client-17 (17.0-1) ... 131s Selecting previously unselected package postgresql-17. 131s Preparing to unpack .../31-postgresql-17_17.0-1_ppc64el.deb ... 131s Unpacking postgresql-17 (17.0-1) ... 132s Selecting previously unselected package postgresql. 132s Preparing to unpack .../32-postgresql_17+266_all.deb ... 132s Unpacking postgresql (17+266) ... 132s Selecting previously unselected package pgloader. 132s Preparing to unpack .../33-pgloader_3.6.10-4_ppc64el.deb ... 132s Unpacking pgloader (3.6.10-4) ... 132s Selecting previously unselected package autopkgtest-satdep. 132s Preparing to unpack .../34-1-autopkgtest-satdep.deb ... 132s Unpacking autopkgtest-satdep (0) ... 132s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 132s Setting up libio-pty-perl (1:1.20-1build3) ... 132s Setting up libpq5:ppc64el (17.0-1) ... 132s Setting up cl-split-sequence (1:2.0.1-1) ... 132s Setting up cl-trivial-gray-streams (20240217.gita7ead68-1) ... 132s Setting up ssl-cert (1.1.2ubuntu2) ... 133s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 133s Setting up libipc-run-perl (20231003.0-2) ... 133s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 133s Setting up libjson-perl (4.10000-1) ... 133s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 133s Setting up cl-alexandria (20240125.git8514d8e-1) ... 133s Setting up cl-rt (20090812.gita6a7503-1) ... 133s Setting up freetds-common (1.3.17+ds-2build3) ... 133s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 133s Setting up postgresql-client-common (266) ... 133s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 133s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 133s Setting up postgresql-client-17 (17.0-1) ... 133s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 133s Setting up libsybdb5:ppc64el (1.3.17+ds-2build3) ... 133s Setting up cl-bordeaux-threads (0.8.8-5) ... 133s Setting up libct4:ppc64el (1.3.17+ds-2build3) ... 133s Setting up cl-kmrcl (1.111-2) ... 133s Setting up postgresql-common (266) ... 134s 134s Creating config file /etc/postgresql-common/createcluster.conf with new version 134s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 134s Removing obsolete dictionary files: 135s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 135s Setting up cl-usocket (0.8.3-3) ... 135s Setting up cl-md5 (1:20210622.git906593f-1) ... 135s Setting up cl-base64 (3.4.0-1) ... 135s Setting up cl-ironclad (0.60-2) ... 135s Setting up postgresql-17 (17.0-1) ... 135s Creating new PostgreSQL cluster 17/main ... 135s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 136s The files belonging to this database system will be owned by user "postgres". 136s This user must also own the server process. 136s 136s The database cluster will be initialized with locale "C.UTF-8". 136s The default database encoding has accordingly been set to "UTF8". 136s The default text search configuration will be set to "english". 136s 136s Data page checksums are disabled. 136s 136s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 136s creating subdirectories ... ok 136s selecting dynamic shared memory implementation ... posix 136s selecting default "max_connections" ... 100 136s selecting default "shared_buffers" ... 128MB 136s selecting default time zone ... Etc/UTC 136s creating configuration files ... ok 136s running bootstrap script ... ok 136s performing post-bootstrap initialization ... ok 136s syncing data to disk ... ok 140s Setting up freetds-dev (1.3.17+ds-2build3) ... 140s Setting up pgloader (3.6.10-4) ... 140s Setting up cl-postgres (20211113.git9d4332f-5) ... 140s Setting up postgresql (17+266) ... 140s Setting up cl-s-sql (20211113.git9d4332f-5) ... 140s Setting up cl-postmodern (20211113.git9d4332f-5) ... 140s Setting up autopkgtest-satdep (0) ... 140s Processing triggers for man-db (2.13.0-1) ... 142s Processing triggers for install-info (7.1.1-1) ... 142s Processing triggers for libc-bin (2.40-1ubuntu3) ... 145s (Reading database ... 77124 files and directories currently installed.) 145s Removing autopkgtest-satdep (0) ... 146s autopkgtest [04:30:23]: test ssl: [----------------------- 146s + trap rm -rf /tmp/pgloader EXIT 146s + dpkg-query --show --showformat=${Version} cl-postmodern 146s + postmodern=20211113.git9d4332f-5 146s + dpkg --compare-versions 20211113.git9d4332f-5 lt 20200101 146s + pg_virtualenv 146s Creating new PostgreSQL cluster 17/regress ... 150s ++ psql -XAtc 'SHOW hba_file' 150s + HBA=/etc/postgresql/17/regress/pg_hba.conf 150s + sed -i -e 's/^host/hostssl/' /etc/postgresql/17/regress/pg_hba.conf 150s + psql -XAtc 'SELECT pg_reload_conf()' 150s t 150s + createdb pgloader 150s + export PGDATABASE=pgloader 150s + PGDATABASE=pgloader 150s + psql -XAtc 'create schema expected' 150s CREATE SCHEMA 150s + rm -rf /tmp/pgloader 150s + PGHOST=/var/run/postgresql 150s + su -c 'pgloader --debug --regress test/allcols.load' postgres 150s mkdir -p #P"/tmp/pgloader/" 150s pgloader version 3.6.10~devel 150s compiled with SBCL 2.4.7.debian 150s sb-impl::*default-external-format* :UTF-8 150s tmpdir: #P"/tmp/pgloader/" 150s 2024-11-15T04:30:27.007999Z NOTICE Starting pgloader, log system is ready. 150s 2024-11-15T04:30:27.023995Z INFO Starting monitor 150s 2024-11-15T04:30:27.027994Z LOG pgloader version "3.6.10~devel" 150s 2024-11-15T04:30:27.027994Z LOG Data errors in '/tmp/pgloader/' 150s 2024-11-15T04:30:27.027994Z LOG Regression testing: "test/allcols.load" 150s 2024-11-15T04:30:27.027994Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/allcols.load" 151s 2024-11-15T04:30:27.087981Z INFO Parsed command: 151s /* 151s * This test is ported from pgloader 2.x where it was defined as: 151s * 151s * [allcols] 151s * table = allcols 151s * format = csv 151s * filename = allcols/allcols.data 151s * field_sep = : 151s * columns = * 151s * pg_option_work_mem = 14MB 151s * 151s */ 151s 151s LOAD CSV 151s FROM inline (a, b, c) 151s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 151s 151s WITH fields optionally enclosed by '"', 151s fields escaped by double-quote, 151s fields terminated by ':' 151s 151s SET client_encoding to 'latin1', 151s work_mem to '14MB', 151s standard_conforming_strings to 'on' 151s 151s BEFORE LOAD DO 151s $$ drop table if exists allcols; $$, 151s $$ create table allcols ( 151s a integer primary key, 151s b date, 151s c text 151s ); 151s $$; 151s 151s 151s 151s 151s 151s 2024-11-15T04:30:27.091980Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 151s 2024-11-15T04:30:27.147969Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.147969Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.147969Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.147969Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.147969Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.167965Z NOTICE Executing SQL block for before load 151s 2024-11-15T04:30:27.183962Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.183962Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.183962Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.183962Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.183962Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.187961Z DEBUG BEGIN 151s 2024-11-15T04:30:27.187961Z SQL drop table if exists allcols; 151s 2024-11-15T04:30:27.187961Z SQL create table allcols ( 151s a integer primary key, 151s b date, 151s c text 151s ); 151s 2024-11-15T04:30:27.231953Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.231953Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.231953Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.235952Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.235952Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.255948Z SQL -- 151s -- get user defined SQL types 151s -- 151s select nt.nspname, 151s extname, 151s typname, 151s case when enum.enumtypid is not null 151s then array_agg(enum.enumlabel order by enumsortorder) 151s end as enumvalues 151s 151s from pg_class c 151s join pg_namespace n on n.oid = c.relnamespace 151s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 151s join pg_type t on t.oid = a.atttypid 151s left join pg_namespace nt on nt.oid = t.typnamespace 151s left join pg_depend d on d.classid = 'pg_type'::regclass 151s and d.refclassid = 'pg_extension'::regclass 151s and d.objid = t.oid 151s left join pg_extension e on refobjid = e.oid 151s left join pg_enum enum on enum.enumtypid = t.oid 151s 151s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 151s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and c.relkind in ('r', 'f', 'p') 151s and ((n.nspname = 'public' and c.relname = 'allcols')) 151s 151s and 151s ( t.typrelid = 0 151s or 151s (select c.relkind = 'c' 151s from pg_class c 151s where c.oid = t.typrelid) 151s ) 151s and not exists 151s ( 151s select 1 151s from pg_type el 151s where el.oid = t.typelem 151s and el.typarray = t.oid 151s ) 151s 151s group by nt.nspname, extname, typname, enumtypid 151s order by nt.nspname, extname, typname, enumtypid; 151s 2024-11-15T04:30:27.259948Z SQL -- params: table-type-name 151s -- including 151s -- filter-list-to-where-clause for including 151s -- excluding 151s -- filter-list-to-where-clause for excluding 151s with seqattr as 151s ( 151s select adrelid, 151s adnum, 151s pg_get_expr(d.adbin, d.adrelid) as adsrc, 151s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 151s then substring(pg_get_expr(d.adbin, d.adrelid) 151s from '''([^'']+)''' 151s ) 151s else null 151s end as seqname 151s from pg_attrdef d 151s ) 151s select nspname, relname, c.oid, attname, 151s t.oid::regtype as type, 151s case when atttypmod > 0 151s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 151s else null 151s end as typmod, 151s attnotnull, 151s case when atthasdef 151s then pg_get_expr(def.adbin, def.adrelid) 151s end as default , 151s case when s.seqname is not null then 'auto_increment' end as extra 151s from pg_class c 151s join pg_namespace n on n.oid = c.relnamespace 151s left join pg_attribute a on c.oid = a.attrelid 151s join pg_type t on t.oid = a.atttypid and attnum > 0 151s left join pg_attrdef def on a.attrelid = def.adrelid 151s and a.attnum = def.adnum 151s and a.atthasdef 151s left join seqattr s on def.adrelid = s.adrelid 151s and def.adnum = s.adnum 151s 151s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and relkind in ('r', 'f', 'p') 151s and ((n.nspname = 'public' and c.relname = 'allcols')) 151s 151s 151s order by nspname, relname, attnum; 151s 2024-11-15T04:30:27.303939Z SQL -- params: including 151s -- filter-list-to-where-clause for including 151s -- excluding 151s -- filter-list-to-where-clause for excluding 151s select n.nspname, 151s i.relname, 151s i.oid, 151s rn.nspname, 151s r.relname, 151s indisprimary, 151s indisunique, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.oid 151s and array[attnum::integer] <@ indkey::integer[] 151s ) as cols, 151s pg_get_indexdef(indexrelid), 151s c.conname, 151s pg_get_constraintdef(c.oid) 151s from pg_index x 151s join pg_class i ON i.oid = x.indexrelid 151s join pg_class r ON r.oid = x.indrelid 151s join pg_namespace n ON n.oid = i.relnamespace 151s join pg_namespace rn ON rn.oid = r.relnamespace 151s left join pg_depend d on d.classid = 'pg_class'::regclass 151s and d.objid = i.oid 151s and d.refclassid = 'pg_constraint'::regclass 151s and d.deptype = 'i' 151s left join pg_constraint c ON c.oid = d.refobjid 151s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and ((rn.nspname = 'public' and r.relname = 'allcols')) 151s 151s order by n.nspname, r.relname 151s 2024-11-15T04:30:27.323935Z SQL -- params: including (table) 151s -- filter-list-to-where-clause for including 151s -- excluding (table) 151s -- filter-list-to-where-clause for excluding 151s -- including (ftable) 151s -- filter-list-to-where-clause for including 151s -- excluding (ftable) 151s -- filter-list-to-where-clause for excluding 151s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 151s r.oid, 151s d.refobjid as pkeyoid, 151s conname, 151s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.conrelid 151s and array[attnum::integer] <@ conkey::integer[] 151s ) as conkey, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.confrelid 151s and array[attnum::integer] <@ confkey::integer[] 151s ) as confkey, 151s confupdtype, confdeltype, confmatchtype, 151s condeferrable, condeferred 151s from pg_catalog.pg_constraint r 151s JOIN pg_class c on r.conrelid = c.oid 151s JOIN pg_namespace n on c.relnamespace = n.oid 151s JOIN pg_class cf on r.confrelid = cf.oid 151s JOIN pg_namespace nf on cf.relnamespace = nf.oid 151s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 151s and d.objid = r.oid 151s and d.refobjsubid = 0 151s where r.contype = 'f' 151s AND c.relkind in ('r', 'f', 'p') 151s AND cf.relkind in ('r', 'f', 'p') 151s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 151s and ((n.nspname = 'public' and c.relname = 'allcols')) 151s 151s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 151s 151s 2024-11-15T04:30:27.335932Z SQL -- params pkey-oid-list 151s -- fkey-oild-list 151s with pkeys(oid) as ( 151s values(16391) 151s ), 151s knownfkeys(oid) as ( 151s values(-1) 151s ), 151s pkdeps as ( 151s select pkeys.oid, pg_depend.objid 151s from pg_depend 151s join pkeys on pg_depend.refobjid = pkeys.oid 151s where classid = 'pg_catalog.pg_constraint'::regclass 151s and refclassid = 'pg_catalog.pg_class'::regclass 151s ) 151s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 151s r.oid as conoid, conname, 151s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 151s pkdeps.oid as index_oid 151s from pg_catalog.pg_constraint r 151s JOIN pkdeps on r.oid = pkdeps.objid 151s JOIN pg_class c on r.conrelid = c.oid 151s JOIN pg_namespace n on c.relnamespace = n.oid 151s JOIN pg_class cf on r.confrelid = cf.oid 151s JOIN pg_namespace nf on cf.relnamespace = nf.oid 151s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 151s 2024-11-15T04:30:27.355928Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 151s 2024-11-15T04:30:27.359927Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 151s 2024-11-15T04:30:27.359927Z WARNING That could impact loading performance badly. 151s 2024-11-15T04:30:27.359927Z WARNING Consider the option 'drop indexes'. 151s 2024-11-15T04:30:27.399919Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 151s 2024-11-15T04:30:27.399919Z DEBUG Reader started for "public"."allcols" 151s 2024-11-15T04:30:27.419915Z DEBUG start "public"."allcols" 643866 151s 2024-11-15T04:30:27.419915Z INFO COPY ON ERROR RESUME NEXT 151s 2024-11-15T04:30:27.423914Z NOTICE Opening (:INLINE 151s (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/allcols.load" . 765)) 151s 2024-11-15T04:30:27.427914Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.427914Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.427914Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.427914Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.427914Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.427914Z SQL SET search_path TO "public"; 151s 2024-11-15T04:30:27.427914Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 151s 2024-11-15T04:30:27.431913Z DEBUG Reader for "public"."allcols" is done in 0.035993s 151s 2024-11-15T04:30:27.431913Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.035993s 151s 2024-11-15T04:30:27.435912Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.003999s 151s 2024-11-15T04:30:27.435912Z DEBUG stop "public"."allcols" | 643866 .. 683858 = 0.039992d0 151s 2024-11-15T04:30:27.435912Z DEBUG Writer[1] for "public"."allcols" is done in 0.007998s 151s 2024-11-15T04:30:27.435912Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.007998s 151s 2024-11-15T04:30:27.451909Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 151s 2024-11-15T04:30:27.475904Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.475904Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.475904Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.475904Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.475904Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.475904Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/allcols.out") 151s 2024-11-15T04:30:27.491901Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.491901Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.491901Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.491901Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.491901Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.491901Z NOTICE drop table if exists expected.allcols; 151s 2024-11-15T04:30:27.495900Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 151s 2024-11-15T04:30:27.495900Z NOTICE create table expected.allcols(like allcols); 151s 2024-11-15T04:30:27.495900Z DEBUG LOAD DATA FROM # 151s 2024-11-15T04:30:27.523894Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.523894Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.523894Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.555888Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.555888Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.555888Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.555888Z SQL -- 151s -- get user defined SQL types 151s -- 151s select nt.nspname, 151s extname, 151s typname, 151s case when enum.enumtypid is not null 151s then array_agg(enum.enumlabel order by enumsortorder) 151s end as enumvalues 151s 151s from pg_class c 151s join pg_namespace n on n.oid = c.relnamespace 151s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 151s join pg_type t on t.oid = a.atttypid 151s left join pg_namespace nt on nt.oid = t.typnamespace 151s left join pg_depend d on d.classid = 'pg_type'::regclass 151s and d.refclassid = 'pg_extension'::regclass 151s and d.objid = t.oid 151s left join pg_extension e on refobjid = e.oid 151s left join pg_enum enum on enum.enumtypid = t.oid 151s 151s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 151s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and c.relkind in ('r', 'f', 'p') 151s and ((n.nspname = 'expected' and c.relname = 'allcols')) 151s 151s and 151s ( t.typrelid = 0 151s or 151s (select c.relkind = 'c' 151s from pg_class c 151s where c.oid = t.typrelid) 151s ) 151s and not exists 151s ( 151s select 1 151s from pg_type el 151s where el.oid = t.typelem 151s and el.typarray = t.oid 151s ) 151s 151s group by nt.nspname, extname, typname, enumtypid 151s order by nt.nspname, extname, typname, enumtypid; 151s 2024-11-15T04:30:27.563886Z SQL -- params: table-type-name 151s -- including 151s -- filter-list-to-where-clause for including 151s -- excluding 151s -- filter-list-to-where-clause for excluding 151s with seqattr as 151s ( 151s select adrelid, 151s adnum, 151s pg_get_expr(d.adbin, d.adrelid) as adsrc, 151s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 151s then substring(pg_get_expr(d.adbin, d.adrelid) 151s from '''([^'']+)''' 151s ) 151s else null 151s end as seqname 151s from pg_attrdef d 151s ) 151s select nspname, relname, c.oid, attname, 151s t.oid::regtype as type, 151s case when atttypmod > 0 151s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 151s else null 151s end as typmod, 151s attnotnull, 151s case when atthasdef 151s then pg_get_expr(def.adbin, def.adrelid) 151s end as default , 151s case when s.seqname is not null then 'auto_increment' end as extra 151s from pg_class c 151s join pg_namespace n on n.oid = c.relnamespace 151s left join pg_attribute a on c.oid = a.attrelid 151s join pg_type t on t.oid = a.atttypid and attnum > 0 151s left join pg_attrdef def on a.attrelid = def.adrelid 151s and a.attnum = def.adnum 151s and a.atthasdef 151s left join seqattr s on def.adrelid = s.adrelid 151s and def.adnum = s.adnum 151s 151s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and relkind in ('r', 'f', 'p') 151s and ((n.nspname = 'expected' and c.relname = 'allcols')) 151s 151s 151s order by nspname, relname, attnum; 151s 2024-11-15T04:30:27.563886Z SQL -- params: including 151s -- filter-list-to-where-clause for including 151s -- excluding 151s -- filter-list-to-where-clause for excluding 151s select n.nspname, 151s i.relname, 151s i.oid, 151s rn.nspname, 151s r.relname, 151s indisprimary, 151s indisunique, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.oid 151s and array[attnum::integer] <@ indkey::integer[] 151s ) as cols, 151s pg_get_indexdef(indexrelid), 151s c.conname, 151s pg_get_constraintdef(c.oid) 151s from pg_index x 151s join pg_class i ON i.oid = x.indexrelid 151s join pg_class r ON r.oid = x.indrelid 151s join pg_namespace n ON n.oid = i.relnamespace 151s join pg_namespace rn ON rn.oid = r.relnamespace 151s left join pg_depend d on d.classid = 'pg_class'::regclass 151s and d.objid = i.oid 151s and d.refclassid = 'pg_constraint'::regclass 151s and d.deptype = 'i' 151s left join pg_constraint c ON c.oid = d.refobjid 151s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 151s 151s order by n.nspname, r.relname 151s 2024-11-15T04:30:27.567886Z SQL -- params: including (table) 151s -- filter-list-to-where-clause for including 151s -- excluding (table) 151s -- filter-list-to-where-clause for excluding 151s -- including (ftable) 151s -- filter-list-to-where-clause for including 151s -- excluding (ftable) 151s -- filter-list-to-where-clause for excluding 151s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 151s r.oid, 151s d.refobjid as pkeyoid, 151s conname, 151s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.conrelid 151s and array[attnum::integer] <@ conkey::integer[] 151s ) as conkey, 151s (select string_agg(attname, ',') 151s from pg_attribute 151s where attrelid = r.confrelid 151s and array[attnum::integer] <@ confkey::integer[] 151s ) as confkey, 151s confupdtype, confdeltype, confmatchtype, 151s condeferrable, condeferred 151s from pg_catalog.pg_constraint r 151s JOIN pg_class c on r.conrelid = c.oid 151s JOIN pg_namespace n on c.relnamespace = n.oid 151s JOIN pg_class cf on r.confrelid = cf.oid 151s JOIN pg_namespace nf on cf.relnamespace = nf.oid 151s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 151s and d.objid = r.oid 151s and d.refobjsubid = 0 151s where r.contype = 'f' 151s AND c.relkind in ('r', 'f', 'p') 151s AND cf.relkind in ('r', 'f', 'p') 151s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 151s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 151s and ((n.nspname = 'expected' and c.relname = 'allcols')) 151s 151s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 151s 151s 2024-11-15T04:30:27.567886Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 151s 2024-11-15T04:30:27.567886Z SQL TRUNCATE "expected"."allcols"; 151s 2024-11-15T04:30:27.587881Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 151s 2024-11-15T04:30:27.587881Z DEBUG Reader started for "expected"."allcols" 151s 2024-11-15T04:30:27.587881Z DEBUG start "expected"."allcols" 835827 151s 2024-11-15T04:30:27.587881Z NOTICE Opening #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/allcols.out" 151s 2024-11-15T04:30:27.587881Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 151s 2024-11-15T04:30:27.587881Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 151s 2024-11-15T04:30:27.591881Z INFO COPY ON ERROR RESUME NEXT 151s 2024-11-15T04:30:27.611877Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.611877Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.611877Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.611877Z SQL SET search_path TO "expected"; 151s 2024-11-15T04:30:27.611877Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 151s 2024-11-15T04:30:27.611877Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 151s 2024-11-15T04:30:27.611877Z DEBUG stop "expected"."allcols" | 835827 .. 859823 = 0.023996d0 151s 2024-11-15T04:30:27.611877Z DEBUG Writer[1] for "expected"."allcols" is done in 0.000000s 151s 2024-11-15T04:30:27.611877Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 151s 2024-11-15T04:30:27.611877Z LOG report summary reset 151s table name errors read imported bytes total time read write 151s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 151s fetch 0 0 0 0.012s 151s before load 0 2 2 0.024s 151s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 151s "public"."allcols" 0 8 8 0.2 kB 0.040s 0.036s 0.008s 151s "expected"."allcols" 0 8 8 0.2 kB 0.024s 151s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 151s Files Processed 0 2 2 0.044s 151s COPY Threads Completion 0 4 4 0.064s 151s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 151s Total import time ✓ 16 16 0.4 kB 0.108s 151s 2024-11-15T04:30:27.699859Z DEBUG CONNECTED TO # 151s 2024-11-15T04:30:27.699859Z DEBUG SET client_encoding TO 'utf8' 151s 2024-11-15T04:30:27.699859Z DEBUG SET work_mem TO '14MB' 151s 2024-11-15T04:30:27.699859Z DEBUG SET standard_conforming_strings TO 'on' 151s 2024-11-15T04:30:27.699859Z DEBUG SET application_name TO 'pgloader' 151s 2024-11-15T04:30:27.699859Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 151s 2024-11-15T04:30:27.699859Z NOTICE Got a diff of 0 rows 151s 2024-11-15T04:30:27.699859Z LOG Regress pass. 151s 2024-11-15T04:30:27.699859Z INFO Stopping monitor 151s + rm -rf /tmp/pgloader 151s + PGSSLMODE=require 151s + pgloader --debug --regress test/allcols.load 151s mkdir -p #P"/tmp/pgloader/" 151s pgloader version 3.6.10~devel 151s compiled with SBCL 2.4.7.debian 151s sb-impl::*default-external-format* :UTF-8 151s tmpdir: #P"/tmp/pgloader/" 151s 2024-11-15T04:30:28.003999Z NOTICE Starting pgloader, log system is ready. 151s 2024-11-15T04:30:28.015996Z INFO Starting monitor 151s 2024-11-15T04:30:28.019996Z LOG pgloader version "3.6.10~devel" 151s 2024-11-15T04:30:28.019996Z LOG Data errors in '/tmp/pgloader/' 151s 2024-11-15T04:30:28.019996Z LOG Regression testing: "test/allcols.load" 151s 2024-11-15T04:30:28.019996Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/allcols.load" 151s 2024-11-15T04:30:28.079983Z INFO Parsed command: 151s /* 151s * This test is ported from pgloader 2.x where it was defined as: 151s * 151s * [allcols] 151s * table = allcols 151s * format = csv 151s * filename = allcols/allcols.data 151s * field_sep = : 151s * columns = * 151s * pg_option_work_mem = 14MB 151s * 151s */ 151s 151s LOAD CSV 151s FROM inline (a, b, c) 151s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 151s 151s WITH fields optionally enclosed by '"', 151s fields escaped by double-quote, 151s fields terminated by ':' 151s 151s SET client_encoding to 'latin1', 151s work_mem to '14MB', 151s standard_conforming_strings to 'on' 151s 151s BEFORE LOAD DO 151s $$ drop table if exists allcols; $$, 151s $$ create table allcols ( 151s a integer primary key, 151s b date, 151s c text 151s ); 151s $$; 151s 151s 151s 151s 151s 151s 2024-11-15T04:30:28.083983Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 152s 2024-11-15T04:30:28.287945Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:28.287945Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:28.287945Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:28.287945Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:28.287945Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:28.303941Z NOTICE Executing SQL block for before load 152s 2024-11-15T04:30:28.403923Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:28.403923Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:28.403923Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:28.403923Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:28.403923Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:28.411921Z DEBUG BEGIN 152s 2024-11-15T04:30:28.411921Z SQL drop table if exists allcols; 152s 2024-11-15T04:30:28.415920Z SQL create table allcols ( 152s a integer primary key, 152s b date, 152s c text 152s ); 152s 2024-11-15T04:30:28.555894Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:28.555894Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:28.555894Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:28.555894Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:28.555894Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:28.575890Z SQL -- 152s -- get user defined SQL types 152s -- 152s select nt.nspname, 152s extname, 152s typname, 152s case when enum.enumtypid is not null 152s then array_agg(enum.enumlabel order by enumsortorder) 152s end as enumvalues 152s 152s from pg_class c 152s join pg_namespace n on n.oid = c.relnamespace 152s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 152s join pg_type t on t.oid = a.atttypid 152s left join pg_namespace nt on nt.oid = t.typnamespace 152s left join pg_depend d on d.classid = 'pg_type'::regclass 152s and d.refclassid = 'pg_extension'::regclass 152s and d.objid = t.oid 152s left join pg_extension e on refobjid = e.oid 152s left join pg_enum enum on enum.enumtypid = t.oid 152s 152s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 152s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 152s and c.relkind in ('r', 'f', 'p') 152s and ((n.nspname = 'public' and c.relname = 'allcols')) 152s 152s and 152s ( t.typrelid = 0 152s or 152s (select c.relkind = 'c' 152s from pg_class c 152s where c.oid = t.typrelid) 152s ) 152s and not exists 152s ( 152s select 1 152s from pg_type el 152s where el.oid = t.typelem 152s and el.typarray = t.oid 152s ) 152s 152s group by nt.nspname, extname, typname, enumtypid 152s order by nt.nspname, extname, typname, enumtypid; 152s 2024-11-15T04:30:28.579889Z SQL -- params: table-type-name 152s -- including 152s -- filter-list-to-where-clause for including 152s -- excluding 152s -- filter-list-to-where-clause for excluding 152s with seqattr as 152s ( 152s select adrelid, 152s adnum, 152s pg_get_expr(d.adbin, d.adrelid) as adsrc, 152s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 152s then substring(pg_get_expr(d.adbin, d.adrelid) 152s from '''([^'']+)''' 152s ) 152s else null 152s end as seqname 152s from pg_attrdef d 152s ) 152s select nspname, relname, c.oid, attname, 152s t.oid::regtype as type, 152s case when atttypmod > 0 152s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 152s else null 152s end as typmod, 152s attnotnull, 152s case when atthasdef 152s then pg_get_expr(def.adbin, def.adrelid) 152s end as default , 152s case when s.seqname is not null then 'auto_increment' end as extra 152s from pg_class c 152s join pg_namespace n on n.oid = c.relnamespace 152s left join pg_attribute a on c.oid = a.attrelid 152s join pg_type t on t.oid = a.atttypid and attnum > 0 152s left join pg_attrdef def on a.attrelid = def.adrelid 152s and a.attnum = def.adnum 152s and a.atthasdef 152s left join seqattr s on def.adrelid = s.adrelid 152s and def.adnum = s.adnum 152s 152s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 152s and relkind in ('r', 'f', 'p') 152s and ((n.nspname = 'public' and c.relname = 'allcols')) 152s 152s 152s order by nspname, relname, attnum; 152s 2024-11-15T04:30:28.623881Z SQL -- params: including 152s -- filter-list-to-where-clause for including 152s -- excluding 152s -- filter-list-to-where-clause for excluding 152s select n.nspname, 152s i.relname, 152s i.oid, 152s rn.nspname, 152s r.relname, 152s indisprimary, 152s indisunique, 152s (select string_agg(attname, ',') 152s from pg_attribute 152s where attrelid = r.oid 152s and array[attnum::integer] <@ indkey::integer[] 152s ) as cols, 152s pg_get_indexdef(indexrelid), 152s c.conname, 152s pg_get_constraintdef(c.oid) 152s from pg_index x 152s join pg_class i ON i.oid = x.indexrelid 152s join pg_class r ON r.oid = x.indrelid 152s join pg_namespace n ON n.oid = i.relnamespace 152s join pg_namespace rn ON rn.oid = r.relnamespace 152s left join pg_depend d on d.classid = 'pg_class'::regclass 152s and d.objid = i.oid 152s and d.refclassid = 'pg_constraint'::regclass 152s and d.deptype = 'i' 152s left join pg_constraint c ON c.oid = d.refobjid 152s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 152s and ((rn.nspname = 'public' and r.relname = 'allcols')) 152s 152s order by n.nspname, r.relname 152s 2024-11-15T04:30:28.643877Z SQL -- params: including (table) 152s -- filter-list-to-where-clause for including 152s -- excluding (table) 152s -- filter-list-to-where-clause for excluding 152s -- including (ftable) 152s -- filter-list-to-where-clause for including 152s -- excluding (ftable) 152s -- filter-list-to-where-clause for excluding 152s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 152s r.oid, 152s d.refobjid as pkeyoid, 152s conname, 152s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 152s (select string_agg(attname, ',') 152s from pg_attribute 152s where attrelid = r.conrelid 152s and array[attnum::integer] <@ conkey::integer[] 152s ) as conkey, 152s (select string_agg(attname, ',') 152s from pg_attribute 152s where attrelid = r.confrelid 152s and array[attnum::integer] <@ confkey::integer[] 152s ) as confkey, 152s confupdtype, confdeltype, confmatchtype, 152s condeferrable, condeferred 152s from pg_catalog.pg_constraint r 152s JOIN pg_class c on r.conrelid = c.oid 152s JOIN pg_namespace n on c.relnamespace = n.oid 152s JOIN pg_class cf on r.confrelid = cf.oid 152s JOIN pg_namespace nf on cf.relnamespace = nf.oid 152s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 152s and d.objid = r.oid 152s and d.refobjsubid = 0 152s where r.contype = 'f' 152s AND c.relkind in ('r', 'f', 'p') 152s AND cf.relkind in ('r', 'f', 'p') 152s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 152s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 152s and ((n.nspname = 'public' and c.relname = 'allcols')) 152s 152s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 152s 152s 2024-11-15T04:30:28.651876Z SQL -- params pkey-oid-list 152s -- fkey-oild-list 152s with pkeys(oid) as ( 152s values(16406) 152s ), 152s knownfkeys(oid) as ( 152s values(-1) 152s ), 152s pkdeps as ( 152s select pkeys.oid, pg_depend.objid 152s from pg_depend 152s join pkeys on pg_depend.refobjid = pkeys.oid 152s where classid = 'pg_catalog.pg_constraint'::regclass 152s and refclassid = 'pg_catalog.pg_class'::regclass 152s ) 152s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 152s r.oid as conoid, conname, 152s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 152s pkdeps.oid as index_oid 152s from pg_catalog.pg_constraint r 152s JOIN pkdeps on r.oid = pkdeps.objid 152s JOIN pg_class c on r.conrelid = c.oid 152s JOIN pg_namespace n on c.relnamespace = n.oid 152s JOIN pg_class cf on r.confrelid = cf.oid 152s JOIN pg_namespace nf on cf.relnamespace = nf.oid 152s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 152s 2024-11-15T04:30:28.675871Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 152s 2024-11-15T04:30:28.675871Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 152s 2024-11-15T04:30:28.675871Z WARNING That could impact loading performance badly. 152s 2024-11-15T04:30:28.675871Z WARNING Consider the option 'drop indexes'. 152s 2024-11-15T04:30:28.707865Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 152s 2024-11-15T04:30:28.711864Z DEBUG Reader started for "public"."allcols" 152s 2024-11-15T04:30:28.727861Z DEBUG start "public"."allcols" 955815 152s 2024-11-15T04:30:28.727861Z INFO COPY ON ERROR RESUME NEXT 152s 2024-11-15T04:30:28.727861Z NOTICE Opening (:INLINE 152s (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/allcols.load" . 765)) 152s 2024-11-15T04:30:28.755855Z DEBUG Reader for "public"."allcols" is done in 0.047990s 152s 2024-11-15T04:30:28.755855Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.047990s 152s 2024-11-15T04:30:28.815844Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:28.815844Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:28.815844Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:28.815844Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:28.815844Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:28.815844Z SQL SET search_path TO "public"; 152s 2024-11-15T04:30:28.815844Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 152s 2024-11-15T04:30:28.823842Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.007998s 152s 2024-11-15T04:30:28.827842Z DEBUG stop "public"."allcols" | 955815 .. 1075792 = 0.119977d0 152s 2024-11-15T04:30:28.827842Z DEBUG Writer[1] for "public"."allcols" is done in 0.007998s 152s 2024-11-15T04:30:28.827842Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.007998s 152s 2024-11-15T04:30:28.843839Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 152s 2024-11-15T04:30:28.955817Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:28.955817Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:28.955817Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:28.955817Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:28.955817Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:28.959817Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/allcols.out") 152s 2024-11-15T04:30:29.067796Z DEBUG CONNECTED TO # 152s 2024-11-15T04:30:29.067796Z DEBUG SET client_encoding TO 'utf8' 152s 2024-11-15T04:30:29.067796Z DEBUG SET work_mem TO '14MB' 152s 2024-11-15T04:30:29.067796Z DEBUG SET standard_conforming_strings TO 'on' 152s 2024-11-15T04:30:29.067796Z DEBUG SET application_name TO 'pgloader' 152s 2024-11-15T04:30:29.071796Z NOTICE drop table if exists expected.allcols; 152s 2024-11-15T04:30:29.071796Z NOTICE create table expected.allcols(like allcols); 152s 2024-11-15T04:30:29.075795Z DEBUG LOAD DATA FROM # 153s 2024-11-15T04:30:29.191774Z DEBUG CONNECTED TO # 153s 2024-11-15T04:30:29.191774Z DEBUG SET client_encoding TO 'utf8' 153s 2024-11-15T04:30:29.191774Z DEBUG SET application_name TO 'pgloader' 153s 2024-11-15T04:30:29.311753Z DEBUG CONNECTED TO # 153s 2024-11-15T04:30:29.311753Z DEBUG SET client_encoding TO 'utf8' 153s 2024-11-15T04:30:29.311753Z DEBUG SET application_name TO 'pgloader' 153s 2024-11-15T04:30:29.315753Z SQL -- 153s -- get user defined SQL types 153s -- 153s select nt.nspname, 153s extname, 153s typname, 153s case when enum.enumtypid is not null 153s then array_agg(enum.enumlabel order by enumsortorder) 153s end as enumvalues 153s 153s from pg_class c 153s join pg_namespace n on n.oid = c.relnamespace 153s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 153s join pg_type t on t.oid = a.atttypid 153s left join pg_namespace nt on nt.oid = t.typnamespace 153s left join pg_depend d on d.classid = 'pg_type'::regclass 153s and d.refclassid = 'pg_extension'::regclass 153s and d.objid = t.oid 153s left join pg_extension e on refobjid = e.oid 153s left join pg_enum enum on enum.enumtypid = t.oid 153s 153s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 153s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 153s and c.relkind in ('r', 'f', 'p') 153s and ((n.nspname = 'expected' and c.relname = 'allcols')) 153s 153s and 153s ( t.typrelid = 0 153s or 153s (select c.relkind = 'c' 153s from pg_class c 153s where c.oid = t.typrelid) 153s ) 153s and not exists 153s ( 153s select 1 153s from pg_type el 153s where el.oid = t.typelem 153s and el.typarray = t.oid 153s ) 153s 153s group by nt.nspname, extname, typname, enumtypid 153s order by nt.nspname, extname, typname, enumtypid; 153s 2024-11-15T04:30:29.323751Z SQL -- params: table-type-name 153s -- including 153s -- filter-list-to-where-clause for including 153s -- excluding 153s -- filter-list-to-where-clause for excluding 153s with seqattr as 153s ( 153s select adrelid, 153s adnum, 153s pg_get_expr(d.adbin, d.adrelid) as adsrc, 153s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 153s then substring(pg_get_expr(d.adbin, d.adrelid) 153s from '''([^'']+)''' 153s ) 153s else null 153s end as seqname 153s from pg_attrdef d 153s ) 153s select nspname, relname, c.oid, attname, 153s t.oid::regtype as type, 153s case when atttypmod > 0 153s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 153s else null 153s end as typmod, 153s attnotnull, 153s case when atthasdef 153s then pg_get_expr(def.adbin, def.adrelid) 153s end as default , 153s case when s.seqname is not null then 'auto_increment' end as extra 153s from pg_class c 153s join pg_namespace n on n.oid = c.relnamespace 153s left join pg_attribute a on c.oid = a.attrelid 153s join pg_type t on t.oid = a.atttypid and attnum > 0 153s left join pg_attrdef def on a.attrelid = def.adrelid 153s and a.attnum = def.adnum 153s and a.atthasdef 153s left join seqattr s on def.adrelid = s.adrelid 153s and def.adnum = s.adnum 153s 153s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 153s and relkind in ('r', 'f', 'p') 153s and ((n.nspname = 'expected' and c.relname = 'allcols')) 153s 153s 153s order by nspname, relname, attnum; 153s 2024-11-15T04:30:29.327750Z SQL -- params: including 153s -- filter-list-to-where-clause for including 153s -- excluding 153s -- filter-list-to-where-clause for excluding 153s select n.nspname, 153s i.relname, 153s i.oid, 153s rn.nspname, 153s r.relname, 153s indisprimary, 153s indisunique, 153s (select string_agg(attname, ',') 153s from pg_attribute 153s where attrelid = r.oid 153s and array[attnum::integer] <@ indkey::integer[] 153s ) as cols, 153s pg_get_indexdef(indexrelid), 153s c.conname, 153s pg_get_constraintdef(c.oid) 153s from pg_index x 153s join pg_class i ON i.oid = x.indexrelid 153s join pg_class r ON r.oid = x.indrelid 153s join pg_namespace n ON n.oid = i.relnamespace 153s join pg_namespace rn ON rn.oid = r.relnamespace 153s left join pg_depend d on d.classid = 'pg_class'::regclass 153s and d.objid = i.oid 153s and d.refclassid = 'pg_constraint'::regclass 153s and d.deptype = 'i' 153s left join pg_constraint c ON c.oid = d.refobjid 153s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 153s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 153s 153s order by n.nspname, r.relname 153s 2024-11-15T04:30:29.331750Z SQL -- params: including (table) 153s -- filter-list-to-where-clause for including 153s -- excluding (table) 153s -- filter-list-to-where-clause for excluding 153s -- including (ftable) 153s -- filter-list-to-where-clause for including 153s -- excluding (ftable) 153s -- filter-list-to-where-clause for excluding 153s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 153s r.oid, 153s d.refobjid as pkeyoid, 153s conname, 153s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 153s (select string_agg(attname, ',') 153s from pg_attribute 153s where attrelid = r.conrelid 153s and array[attnum::integer] <@ conkey::integer[] 153s ) as conkey, 153s (select string_agg(attname, ',') 153s from pg_attribute 153s where attrelid = r.confrelid 153s and array[attnum::integer] <@ confkey::integer[] 153s ) as confkey, 153s confupdtype, confdeltype, confmatchtype, 153s condeferrable, condeferred 153s from pg_catalog.pg_constraint r 153s JOIN pg_class c on r.conrelid = c.oid 153s JOIN pg_namespace n on c.relnamespace = n.oid 153s JOIN pg_class cf on r.confrelid = cf.oid 153s JOIN pg_namespace nf on cf.relnamespace = nf.oid 153s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 153s and d.objid = r.oid 153s and d.refobjsubid = 0 153s where r.contype = 'f' 153s AND c.relkind in ('r', 'f', 'p') 153s AND cf.relkind in ('r', 'f', 'p') 153s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 153s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 153s and ((n.nspname = 'expected' and c.relname = 'allcols')) 153s 153s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 153s 153s 2024-11-15T04:30:29.331750Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 153s 2024-11-15T04:30:29.331750Z SQL TRUNCATE "expected"."allcols"; 153s 2024-11-15T04:30:29.351746Z NOTICE COPY "expected"."allcols" with 0 rows estimated [3/4] 153s 2024-11-15T04:30:29.351746Z DEBUG Reader started for "expected"."allcols" 153s 2024-11-15T04:30:29.351746Z DEBUG start "expected"."allcols" 1599696 153s 2024-11-15T04:30:29.351746Z NOTICE Opening #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/allcols.out" 153s 2024-11-15T04:30:29.351746Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 153s 2024-11-15T04:30:29.351746Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 153s 2024-11-15T04:30:29.355746Z INFO COPY ON ERROR RESUME NEXT 153s 2024-11-15T04:30:29.459727Z DEBUG CONNECTED TO # 153s 2024-11-15T04:30:29.459727Z DEBUG SET client_encoding TO 'utf8' 153s 2024-11-15T04:30:29.459727Z DEBUG SET application_name TO 'pgloader' 153s 2024-11-15T04:30:29.459727Z SQL SET search_path TO "expected"; 153s 2024-11-15T04:30:29.463726Z INFO pgsql:copy-rows-from-queue[2]: "expected"."allcols" ("a" "b" "c") 153s 2024-11-15T04:30:29.463726Z DEBUG send-batch[2] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 153s 2024-11-15T04:30:29.467726Z DEBUG stop "expected"."allcols" | 1599696 .. 1711676 = 0.11198d0 153s 2024-11-15T04:30:29.467726Z DEBUG Writer[2] for "expected"."allcols" is done in 0.000000s 153s 2024-11-15T04:30:29.467726Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 153s 2024-11-15T04:30:29.467726Z LOG report summary reset 153s table name errors read imported bytes total time read write 153s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 153s fetch 0 0 0 0.008s 153s before load 0 2 2 0.116s 153s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 153s "public"."allcols" 0 8 8 0.2 kB 0.120s 0.048s 0.008s 153s "expected"."allcols" 0 8 8 0.2 kB 0.112s 153s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 153s Files Processed 0 2 2 0.040s 153s COPY Threads Completion 0 4 4 0.228s 153s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 153s Total import time ✓ 16 16 0.4 kB 0.268s 153s 2024-11-15T04:30:29.571707Z DEBUG CONNECTED TO # 153s 2024-11-15T04:30:29.571707Z DEBUG SET client_encoding TO 'utf8' 153s 2024-11-15T04:30:29.571707Z DEBUG SET work_mem TO '14MB' 153s 2024-11-15T04:30:29.571707Z DEBUG SET standard_conforming_strings TO 'on' 153s 2024-11-15T04:30:29.571707Z DEBUG SET application_name TO 'pgloader' 153s 2024-11-15T04:30:29.575707Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 153s 2024-11-15T04:30:29.575707Z NOTICE Got a diff of 0 rows 153s 2024-11-15T04:30:29.575707Z LOG Regress pass. 153s 2024-11-15T04:30:29.575707Z INFO Stopping monitor 153s Dropping cluster 17/regress ... 155s + rm -rf /tmp/pgloader 155s autopkgtest [04:30:32]: test ssl: -----------------------] 156s autopkgtest [04:30:33]: test ssl: - - - - - - - - - - results - - - - - - - - - - 156s ssl PASS 156s autopkgtest [04:30:33]: test testsuite: preparing testbed 269s autopkgtest [04:32:26]: testbed dpkg architecture: ppc64el 269s autopkgtest [04:32:26]: testbed apt version: 2.9.8 269s autopkgtest [04:32:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 270s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 270s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1027 kB] 270s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.3 kB] 270s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 270s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 270s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [176 kB] 270s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [768 kB] 270s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [8632 B] 271s Fetched 2175 kB in 1s (2363 kB/s) 271s Reading package lists... 273s Reading package lists... 273s Building dependency tree... 273s Reading state information... 274s Calculating upgrade... 274s The following packages will be upgraded: 274s bpfcc-tools bpftrace firmware-sof-signed libbpfcc libcap-ng0 libexpat1 274s libgnutls30t64 libjson-glib-1.0-0 libjson-glib-1.0-common libnewt0.52 274s libutempter0 lxd-installer man-db pastebinit python3-bpfcc python3-newt 274s python3-systemd whiptail xfsprogs 274s 19 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 274s Need to get 14.2 MB of archives. 274s After this operation, 623 kB of additional disk space will be used. 274s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 275s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcap-ng0 ppc64el 0.8.5-3build1 [16.3 kB] 275s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgnutls30t64 ppc64el 3.8.8-2ubuntu1 [1072 kB] 275s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libexpat1 ppc64el 2.6.4-1 [98.1 kB] 275s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-newt ppc64el 0.52.24-2ubuntu4 [21.8 kB] 275s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libnewt0.52 ppc64el 0.52.24-2ubuntu4 [62.1 kB] 275s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el whiptail ppc64el 0.52.24-2ubuntu4 [19.5 kB] 275s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el man-db ppc64el 2.13.0-1 [1361 kB] 275s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el libbpfcc ppc64el 0.30.0+ds-1ubuntu5 [696 kB] 275s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-bpfcc all 0.30.0+ds-1ubuntu5 [40.4 kB] 275s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpfcc-tools all 0.30.0+ds-1ubuntu5 [697 kB] 275s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpftrace ppc64el 0.21.2-2ubuntu2 [1898 kB] 275s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-common all 1.10.0+ds-3 [5586 B] 275s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-0 ppc64el 1.10.0+ds-3 [76.0 kB] 275s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el libutempter0 ppc64el 1.2.1-4 [9850 B] 275s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el lxd-installer all 9 [5084 B] 275s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el pastebinit all 1.7.1-1 [14.9 kB] 275s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-systemd ppc64el 235-1build5 [48.7 kB] 275s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el xfsprogs ppc64el 6.8.0-2.2ubuntu2 [995 kB] 275s Preconfiguring packages ... 276s Fetched 14.2 MB in 1s (10.4 MB/s) 276s (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 ... 73767 files and directories currently installed.) 276s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 276s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 276s Preparing to unpack .../libcap-ng0_0.8.5-3build1_ppc64el.deb ... 276s Unpacking libcap-ng0:ppc64el (0.8.5-3build1) over (0.8.5-1) ... 276s Setting up libcap-ng0:ppc64el (0.8.5-3build1) ... 276s (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 ... 73793 files and directories currently installed.) 276s Preparing to unpack .../libgnutls30t64_3.8.8-2ubuntu1_ppc64el.deb ... 276s Unpacking libgnutls30t64:ppc64el (3.8.8-2ubuntu1) over (3.8.6-2ubuntu1) ... 276s Setting up libgnutls30t64:ppc64el (3.8.8-2ubuntu1) ... 276s (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 ... 73793 files and directories currently installed.) 276s Preparing to unpack .../00-libexpat1_2.6.4-1_ppc64el.deb ... 276s Unpacking libexpat1:ppc64el (2.6.4-1) over (2.6.2-2) ... 276s Preparing to unpack .../01-python3-newt_0.52.24-2ubuntu4_ppc64el.deb ... 276s Unpacking python3-newt:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 276s Preparing to unpack .../02-libnewt0.52_0.52.24-2ubuntu4_ppc64el.deb ... 276s Unpacking libnewt0.52:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 276s Preparing to unpack .../03-whiptail_0.52.24-2ubuntu4_ppc64el.deb ... 276s Unpacking whiptail (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 276s Preparing to unpack .../04-man-db_2.13.0-1_ppc64el.deb ... 276s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 277s Preparing to unpack .../05-libbpfcc_0.30.0+ds-1ubuntu5_ppc64el.deb ... 277s Unpacking libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 277s Preparing to unpack .../06-python3-bpfcc_0.30.0+ds-1ubuntu5_all.deb ... 277s Unpacking python3-bpfcc (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 277s Preparing to unpack .../07-bpfcc-tools_0.30.0+ds-1ubuntu5_all.deb ... 277s Unpacking bpfcc-tools (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 277s Preparing to unpack .../08-bpftrace_0.21.2-2ubuntu2_ppc64el.deb ... 277s Unpacking bpftrace (0.21.2-2ubuntu2) over (0.21.2-2) ... 277s Preparing to unpack .../09-libjson-glib-1.0-common_1.10.0+ds-3_all.deb ... 277s Unpacking libjson-glib-1.0-common (1.10.0+ds-3) over (1.10.0+ds-2) ... 277s Preparing to unpack .../10-libjson-glib-1.0-0_1.10.0+ds-3_ppc64el.deb ... 277s Unpacking libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) over (1.10.0+ds-2) ... 277s Preparing to unpack .../11-libutempter0_1.2.1-4_ppc64el.deb ... 277s Unpacking libutempter0:ppc64el (1.2.1-4) over (1.2.1-3build1) ... 277s Preparing to unpack .../12-lxd-installer_9_all.deb ... 277s Unpacking lxd-installer (9) over (8) ... 277s Preparing to unpack .../13-pastebinit_1.7.1-1_all.deb ... 277s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 277s Preparing to unpack .../14-python3-systemd_235-1build5_ppc64el.deb ... 277s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 277s Preparing to unpack .../15-xfsprogs_6.8.0-2.2ubuntu2_ppc64el.deb ... 277s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 277s Setting up libexpat1:ppc64el (2.6.4-1) ... 277s Setting up libnewt0.52:ppc64el (0.52.24-2ubuntu4) ... 277s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 277s Setting up pastebinit (1.7.1-1) ... 277s Setting up python3-newt:ppc64el (0.52.24-2ubuntu4) ... 278s Setting up man-db (2.13.0-1) ... 278s Updating database of manual pages ... 280s man-db.service is a disabled or a static unit not running, not starting it. 280s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 280s update-initramfs: deferring update (trigger activated) 281s Setting up lxd-installer (9) ... 281s Setting up libutempter0:ppc64el (1.2.1-4) ... 281s Setting up whiptail (0.52.24-2ubuntu4) ... 281s Setting up libjson-glib-1.0-common (1.10.0+ds-3) ... 281s Setting up libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) ... 281s Setting up python3-bpfcc (0.30.0+ds-1ubuntu5) ... 282s Setting up python3-systemd (235-1build5) ... 282s Setting up bpftrace (0.21.2-2ubuntu2) ... 282s Setting up libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) ... 282s Setting up bpfcc-tools (0.30.0+ds-1ubuntu5) ... 282s Processing triggers for libc-bin (2.40-1ubuntu3) ... 282s Processing triggers for initramfs-tools (0.142ubuntu34) ... 282s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 282s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 291s Reading package lists... 291s Building dependency tree... 291s Reading state information... 292s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 292s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 292s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 292s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 292s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 293s Reading package lists... 293s Reading package lists... 294s Building dependency tree... 294s Reading state information... 294s Calculating upgrade... 294s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 294s Reading package lists... 294s Building dependency tree... 294s Reading state information... 294s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 295s autopkgtest [04:32:52]: rebooting testbed after setup commands that affected boot 338s Reading package lists... 338s Building dependency tree... 338s Reading state information... 338s Starting pkgProblemResolver with broken count: 0 338s Starting 2 pkgProblemResolver with broken count: 0 338s Done 338s The following additional packages will be installed: 338s freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 338s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql-17 338s postgresql-17-ip4r postgresql-client-17 postgresql-client-common 338s postgresql-common ssl-cert 338s Suggested packages: 338s postgresql-doc-17 338s Recommended packages: 338s freetds-doc libjson-xs-perl 338s The following NEW packages will be installed: 338s autopkgtest-satdep freetds-common freetds-dev libct4 libio-pty-perl 338s libipc-run-perl libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader 338s postgresql-17 postgresql-17-ip4r postgresql-client-17 338s postgresql-client-common postgresql-common ssl-cert 338s 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. 338s Need to get 49.2 MB/49.2 MB of archives. 338s After this operation, 117 MB of additional disk space will be used. 338s Get:1 /tmp/autopkgtest.8mC8bw/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [728 B] 339s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 339s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 339s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 339s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-common all 266 [37.0 kB] 339s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.2ubuntu2 [18.0 kB] 339s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-common all 266 [162 kB] 339s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-common all 1.3.17+ds-2build3 [26.9 kB] 339s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el libct4 ppc64el 1.3.17+ds-2build3 [211 kB] 339s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2build3 [238 kB] 339s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-dev ppc64el 1.3.17+ds-2build3 [364 kB] 339s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.0-1 [280 kB] 339s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu1 [191 kB] 339s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.0-1 [2251 kB] 339s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.0-1 [19.3 MB] 340s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el postgresql-17-ip4r ppc64el 2.4.2-3 [194 kB] 340s Get:17 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgloader ppc64el 3.6.10-4 [25.7 MB] 341s Preconfiguring packages ... 341s Fetched 49.2 MB in 3s (18.5 MB/s) 341s Selecting previously unselected package libjson-perl. 342s (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 ... 73800 files and directories currently installed.) 342s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 342s Unpacking libjson-perl (4.10000-1) ... 342s Selecting previously unselected package libio-pty-perl. 342s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 342s Unpacking libio-pty-perl (1:1.20-1build3) ... 342s Selecting previously unselected package libipc-run-perl. 342s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 342s Unpacking libipc-run-perl (20231003.0-2) ... 342s Selecting previously unselected package postgresql-client-common. 342s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 342s Unpacking postgresql-client-common (266) ... 342s Selecting previously unselected package ssl-cert. 342s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 342s Unpacking ssl-cert (1.1.2ubuntu2) ... 342s Selecting previously unselected package postgresql-common. 342s Preparing to unpack .../05-postgresql-common_266_all.deb ... 342s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 342s Unpacking postgresql-common (266) ... 342s Selecting previously unselected package freetds-common. 342s Preparing to unpack .../06-freetds-common_1.3.17+ds-2build3_all.deb ... 342s Unpacking freetds-common (1.3.17+ds-2build3) ... 342s Selecting previously unselected package libct4:ppc64el. 342s Preparing to unpack .../07-libct4_1.3.17+ds-2build3_ppc64el.deb ... 342s Unpacking libct4:ppc64el (1.3.17+ds-2build3) ... 342s Selecting previously unselected package libsybdb5:ppc64el. 342s Preparing to unpack .../08-libsybdb5_1.3.17+ds-2build3_ppc64el.deb ... 342s Unpacking libsybdb5:ppc64el (1.3.17+ds-2build3) ... 342s Selecting previously unselected package freetds-dev. 342s Preparing to unpack .../09-freetds-dev_1.3.17+ds-2build3_ppc64el.deb ... 342s Unpacking freetds-dev (1.3.17+ds-2build3) ... 342s Selecting previously unselected package libpq5:ppc64el. 342s Preparing to unpack .../10-libpq5_17.0-1_ppc64el.deb ... 342s Unpacking libpq5:ppc64el (17.0-1) ... 342s Selecting previously unselected package libxslt1.1:ppc64el. 342s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu1_ppc64el.deb ... 342s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 342s Selecting previously unselected package postgresql-client-17. 342s Preparing to unpack .../12-postgresql-client-17_17.0-1_ppc64el.deb ... 342s Unpacking postgresql-client-17 (17.0-1) ... 342s Selecting previously unselected package postgresql-17. 342s Preparing to unpack .../13-postgresql-17_17.0-1_ppc64el.deb ... 342s Unpacking postgresql-17 (17.0-1) ... 343s Selecting previously unselected package postgresql-17-ip4r. 343s Preparing to unpack .../14-postgresql-17-ip4r_2.4.2-3_ppc64el.deb ... 343s Unpacking postgresql-17-ip4r (2.4.2-3) ... 343s Selecting previously unselected package pgloader. 343s Preparing to unpack .../15-pgloader_3.6.10-4_ppc64el.deb ... 343s Unpacking pgloader (3.6.10-4) ... 343s Selecting previously unselected package autopkgtest-satdep. 343s Preparing to unpack .../16-2-autopkgtest-satdep.deb ... 343s Unpacking autopkgtest-satdep (0) ... 343s Setting up libio-pty-perl (1:1.20-1build3) ... 343s Setting up libpq5:ppc64el (17.0-1) ... 343s Setting up ssl-cert (1.1.2ubuntu2) ... 343s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 344s Setting up libipc-run-perl (20231003.0-2) ... 344s Setting up libjson-perl (4.10000-1) ... 344s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 344s Setting up freetds-common (1.3.17+ds-2build3) ... 344s Setting up postgresql-client-common (266) ... 344s Setting up postgresql-client-17 (17.0-1) ... 344s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 344s Setting up libsybdb5:ppc64el (1.3.17+ds-2build3) ... 344s Setting up libct4:ppc64el (1.3.17+ds-2build3) ... 344s Setting up postgresql-common (266) ... 345s 345s Creating config file /etc/postgresql-common/createcluster.conf with new version 345s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 345s Removing obsolete dictionary files: 345s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 346s Setting up postgresql-17 (17.0-1) ... 346s Creating new PostgreSQL cluster 17/main ... 346s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 346s The files belonging to this database system will be owned by user "postgres". 346s This user must also own the server process. 346s 346s The database cluster will be initialized with locale "C.UTF-8". 346s The default database encoding has accordingly been set to "UTF8". 346s The default text search configuration will be set to "english". 346s 346s Data page checksums are disabled. 346s 346s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 346s creating subdirectories ... ok 346s selecting dynamic shared memory implementation ... posix 346s selecting default "max_connections" ... 100 346s selecting default "shared_buffers" ... 128MB 346s selecting default time zone ... Etc/UTC 346s creating configuration files ... ok 346s running bootstrap script ... ok 347s performing post-bootstrap initialization ... ok 347s syncing data to disk ... ok 351s Setting up freetds-dev (1.3.17+ds-2build3) ... 351s Setting up postgresql-17-ip4r (2.4.2-3) ... 351s Setting up pgloader (3.6.10-4) ... 351s Setting up autopkgtest-satdep (0) ... 351s Processing triggers for man-db (2.13.0-1) ... 352s Processing triggers for libc-bin (2.40-1ubuntu3) ... 355s (Reading database ... 76337 files and directories currently installed.) 355s Removing autopkgtest-satdep (0) ... 357s autopkgtest [04:33:54]: test testsuite: [----------------------- 357s + PGSUPERUSER=ubuntu 357s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 357s Creating new PostgreSQL cluster 17/regress ... 360s make: Entering directory '/tmp/autopkgtest.8mC8bw/build.bBo/src/test' 360s dropdb -U ubuntu pgloader 360s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 360s dropdb -U ubuntu stocks 360s make: [Makefile:67: prepare] Error 1 (ignored) 360s dropdb: error: database removal failed: ERROR: database "stocks" does not exist 360s make: [Makefile:68: prepare] Error 1 (ignored) 360s dropdb -U ubuntu ip4r 360s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 360s createuser -U ubuntu --superuser `whoami` 360s make: [Makefile:69: prepare] Error 1 (ignored) 360s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 360s make: [Makefile:70: prepare] Error 1 (ignored) 360s createdb -U ubuntu -O `whoami` pgloader 360s createdb -U ubuntu -O `whoami` stocks 361s createdb -U ubuntu -O `whoami` ip4r 361s psql -d pgloader -c 'create schema expected' 361s CREATE SCHEMA 361s psql -U ubuntu -d pgloader -c 'create extension ip4r' 361s CREATE EXTENSION 361s psql -U ubuntu -d ip4r -c 'create extension ip4r' 361s CREATE EXTENSION 361s psql -d stocks -f bossa.sql 361s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 361s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 361s DROP TABLE 361s CREATE TABLE 361s CREATE TABLE 361s rm -f regress/out/* 361s pgloader --regress allcols.load 361s 2024-11-15T04:33:58.015796Z LOG pgloader version "3.6.10~devel" 361s 2024-11-15T04:33:58.023694Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/allcols.load" 361s 2024-11-15T04:33:58.075031Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 361s 2024-11-15T04:33:58.315944Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 361s 2024-11-15T04:33:58.315944Z WARNING That could impact loading performance badly. 361s 2024-11-15T04:33:58.315944Z WARNING Consider the option 'drop indexes'. 362s 2024-11-15T04:33:58.402962Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 362s 2024-11-15T04:33:58.426694Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/allcols.out") 362s 2024-11-15T04:33:58.446471Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 362s 2024-11-15T04:33:58.533489Z LOG report summary reset 362s table name errors rows bytes total time 362s ----------------------- --------- --------- --------- -------------- 362s fetch 0 0 0.012s 362s before load 0 2 0.028s 362s ----------------------- --------- --------- --------- -------------- 362s "public"."allcols" 0 8 0.2 kB 0.047s 362s "expected"."allcols" 0 8 0.2 kB 0.016s 362s ----------------------- --------- --------- --------- -------------- 362s Files Processed 0 2 0.032s 362s COPY Threads Completion 0 4 0.067s 362s ----------------------- --------- --------- --------- -------------- 362s Total import time ✓ 16 0.4 kB 0.099s 362s 2024-11-15T04:33:58.584908Z LOG Regress pass. 362s touch regress/out/allcols.out 362s pgloader --regress csv-before-after.load 362s 2024-11-15T04:33:59.015821Z LOG pgloader version "3.6.10~devel" 363s 2024-11-15T04:33:59.700433Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-before-after.out") 363s 2024-11-15T04:33:59.728160Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 363s 2024-11-15T04:33:59.839065Z LOG report summary reset 363s table name errors rows bytes total time 363s ----------------------- --------- --------- --------- -------------- 363s fetch 0 0 0.012s 363s before load 0 6 0.024s 363s ----------------------- --------- --------- --------- -------------- 363s "csv"."blocks" 0 460 15.9 kB 0.321s 363s "expected"."blocks" 0 460 12.4 kB 0.032s 363s ----------------------- --------- --------- --------- -------------- 363s Files Processed 0 2 0.032s 363s COPY Threads Completion 0 4 0.356s 363s after load 0 1 0.020s 363s ----------------------- --------- --------- --------- -------------- 363s Total import time ✓ 920 28.2 kB 0.408s 363s 2024-11-15T04:33:59.894518Z LOG Regress pass. 363s touch regress/out/csv-before-after.out 363s pgloader --regress csv-districts.load 363s 2024-11-15T04:34:00.015844Z LOG pgloader version "3.6.10~devel" 364s 2024-11-15T04:34:00.535003Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-districts.out") 364s 2024-11-15T04:34:00.550867Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 364s 2024-11-15T04:34:00.650012Z LOG report summary reset 364s table name errors rows bytes total time 364s ----------------------- --------- --------- --------- -------------- 364s fetch 0 0 0.004s 364s before load 0 2 0.028s 364s ----------------------- --------- --------- --------- -------------- 364s "public"."districts" 0 440 29.3 kB 0.194s 364s "expected"."districts" 0 440 29.1 kB 0.028s 364s ----------------------- --------- --------- --------- -------------- 364s Files Processed 0 2 0.032s 364s COPY Threads Completion 0 4 0.226s 364s ----------------------- --------- --------- --------- -------------- 364s Total import time ✓ 880 58.3 kB 0.258s 364s 2024-11-15T04:34:00.713465Z LOG Regress pass. 364s touch regress/out/csv-districts.out 364s pgloader --regress csv-parse-date.load 364s 2024-11-15T04:34:01.015864Z LOG pgloader version "3.6.10~devel" 365s 2024-11-15T04:34:01.376785Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-parse-date.out") 365s 2024-11-15T04:34:01.400605Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 365s 2024-11-15T04:34:01.499859Z LOG report summary reset 365s table name errors rows bytes total time 365s ----------------------- --------- --------- --------- -------------- 365s fetch 0 0 0.008s 365s before load 0 2 0.024s 365s ----------------------- --------- --------- --------- -------------- 365s "public"."dateformat" 0 4 0.1 kB 0.048s 365s "expected"."dateformat" 0 4 0.1 kB 0.020s 365s ----------------------- --------- --------- --------- -------------- 365s Files Processed 0 2 0.032s 365s COPY Threads Completion 0 4 0.067s 365s ----------------------- --------- --------- --------- -------------- 365s Total import time ✓ 8 0.3 kB 0.099s 365s 2024-11-15T04:34:01.551470Z LOG Regress pass. 365s touch regress/out/csv-parse-date.out 365s pgloader --regress csv-error.load 365s 2024-11-15T04:34:02.015880Z LOG pgloader version "3.6.10~devel" 365s 2024-11-15T04:34:02.019850Z LOG Regression testing: "csv-error.load" 365s 2024-11-15T04:34:02.019850Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-error.load" 365s 2024-11-15T04:34:02.353337Z FATAL :ASCII stream decoding error on 365s #: 365s 365s the octet sequence #(195) cannot be decoded. 365s 2024-11-15T04:34:02.361277Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 365s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 365s 2024-11-15T04:34:02.404948Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-error.out") 365s 2024-11-15T04:34:02.424799Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 365s 2024-11-15T04:34:02.520081Z LOG report summary reset 366s table name errors rows bytes total time 366s ----------------------- --------- --------- --------- -------------- 366s fetch 0 0 0.004s 366s before load 0 2 0.024s 366s ----------------------- --------- --------- --------- -------------- 366s "public"."jordane" 3 3 0.1 kB 0.056s 366s "expected"."jordane" 0 3 0.1 kB 0.016s 366s ----------------------- --------- --------- --------- -------------- 366s Files Processed 0 2 0.032s 366s COPY Threads Completion 0 4 0.075s 366s ----------------------- --------- --------- --------- -------------- 366s Total import time 3 6 0.2 kB 0.107s 366s 2024-11-15T04:34:02.571724Z LOG Regress pass. 366s touch regress/out/csv-error.out 366s pgloader --regress csv-escape-mode.load 366s 2024-11-15T04:34:03.015896Z LOG pgloader version "3.6.10~devel" 366s 2024-11-15T04:34:03.282142Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 366s 2024-11-15T04:34:03.282142Z WARNING That could impact loading performance badly. 366s 2024-11-15T04:34:03.282142Z WARNING Consider the option 'drop indexes'. 366s 2024-11-15T04:34:03.425199Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-escape-mode.out") 366s 2024-11-15T04:34:03.445068Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 366s 2024-11-15T04:34:03.532493Z 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.020s 366s ---------------------------- --------- --------- --------- -------------- 366s "public"."csv_escape_mode" 0 5 0.1 kB 0.087s 366s "expected"."csv_escape_mode" 0 5 0.1 kB 0.020s 366s ---------------------------- --------- --------- --------- -------------- 366s Files Processed 0 2 0.036s 366s COPY Threads Completion 0 4 0.103s 366s ---------------------------- --------- --------- --------- -------------- 366s Total import time ✓ 10 0.2 kB 0.139s 366s 2024-11-15T04:34:03.584152Z LOG Regress pass. 366s touch regress/out/csv-escape-mode.out 366s pgloader --regress csv-filename-pattern.load 367s 2024-11-15T04:34:04.019885Z LOG pgloader version "3.6.10~devel" 367s 2024-11-15T04:34:04.473274Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-filename-pattern.out") 367s 2024-11-15T04:34:04.497137Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 367s 2024-11-15T04:34:04.596564Z LOG report summary reset 367s table name errors rows bytes total time 367s ----------------------- --------- --------- --------- -------------- 367s fetch 0 0 0.008s 367s before load 0 2 0.028s 367s ----------------------- --------- --------- --------- -------------- 367s "public"."matching" 0 3 0.0 kB 0.028s 367s "expected"."matching" 0 3 0.0 kB 0.016s 367s ----------------------- --------- --------- --------- -------------- 367s Files Processed 0 4 0.040s 367s COPY Threads Completion 0 8 0.115s 367s ----------------------- --------- --------- --------- -------------- 367s Total import time ✓ 6 0.0 kB 0.155s 367s 2024-11-15T04:34:04.644289Z LOG Regress pass. 367s touch regress/out/csv-filename-pattern.out 367s pgloader --regress csv-guess.load 368s 2024-11-15T04:34:05.011940Z LOG pgloader version "3.6.10~devel" 368s 2024-11-15T04:34:05.015920Z LOG Data errors in '/tmp/pgloader/' 368s 2024-11-15T04:34:05.015920Z LOG Regression testing: "csv-guess.load" 368s 2024-11-15T04:34:05.015920Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-guess.load" 368s 2024-11-15T04:34:05.298498Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 368s 2024-11-15T04:34:05.298498Z WARNING That could impact loading performance badly. 368s 2024-11-15T04:34:05.298498Z WARNING Consider the option 'drop indexes'. 369s 2024-11-15T04:34:06.134391Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-guess.out") 369s 2024-11-15T04:34:06.154303Z WARNING PostgreSQL warning: table "track" does not exist, skipping 369s 2024-11-15T04:34:06.297672Z 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.028s 369s ----------------------- --------- --------- --------- -------------- 369s "csv"."track" 0 3503 366.8 kB 0.776s 369s "expected"."track" 0 3503 366.8 kB 0.064s 369s ----------------------- --------- --------- --------- -------------- 369s Files Processed 0 2 0.028s 369s COPY Threads Completion 0 4 0.840s 369s ----------------------- --------- --------- --------- -------------- 369s Total import time ✓ 7006 733.5 kB 0.868s 369s 2024-11-15T04:34:06.349444Z LOG Regress pass. 369s touch regress/out/csv-guess.out 369s pgloader --regress csv-header.load 369s 2024-11-15T04:34:06.015930Z LOG pgloader version "3.6.10~devel" 370s 2024-11-15T04:34:06.406239Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-header.out") 370s 2024-11-15T04:34:06.422177Z WARNING PostgreSQL warning: table "group" does not exist, skipping 370s 2024-11-15T04:34:06.513825Z LOG report summary reset 370s table name errors rows bytes total time 370s ----------------------- --------- --------- --------- -------------- 370s fetch 0 0 0.004s 370s before load 0 2 0.032s 370s ----------------------- --------- --------- --------- -------------- 370s "public"."group" 0 2 0.0 kB 0.028s 370s "expected"."group" 0 2 0.0 kB 0.024s 370s ----------------------- --------- --------- --------- -------------- 370s Files Processed 0 2 0.052s 370s COPY Threads Completion 0 4 0.060s 370s ----------------------- --------- --------- --------- -------------- 370s Total import time ✓ 4 0.1 kB 0.112s 370s 2024-11-15T04:34:06.557656Z LOG Regress pass. 370s touch regress/out/csv-header.out 370s pgloader --regress csv-json.load 370s 2024-11-15T04:34:07.027893Z LOG pgloader version "3.6.10~devel" 370s 2024-11-15T04:34:07.390496Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-json.out") 370s 2024-11-15T04:34:07.406435Z WARNING PostgreSQL warning: table "json" does not exist, skipping 370s 2024-11-15T04:34:07.506051Z LOG report summary reset 371s table name errors rows bytes total time 371s ----------------------- --------- --------- --------- -------------- 371s fetch 0 0 0.008s 371s before load 0 2 0.024s 371s ----------------------- --------- --------- --------- -------------- 371s "public"."json" 0 15 1.1 kB 0.048s 371s "expected"."json" 0 15 1.1 kB 0.020s 371s ----------------------- --------- --------- --------- -------------- 371s Files Processed 0 2 0.028s 371s COPY Threads Completion 0 4 0.068s 371s ----------------------- --------- --------- --------- -------------- 371s Total import time ✓ 30 2.3 kB 0.096s 371s 2024-11-15T04:34:07.561845Z LOG Regress pass. 371s touch regress/out/csv-json.out 371s pgloader --regress csv-keep-extra-blanks.load 371s 2024-11-15T04:34:08.015946Z LOG pgloader version "3.6.10~devel" 371s 2024-11-15T04:34:08.019933Z LOG Regression testing: "csv-keep-extra-blanks.load" 371s 2024-11-15T04:34:08.019933Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-keep-extra-blanks.load" 371s 2024-11-15T04:34:08.406630Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-keep-extra-blanks.out") 371s 2024-11-15T04:34:08.426563Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 371s 2024-11-15T04:34:08.522241Z LOG report summary reset 371s table name errors rows bytes total time 371s ----------------------- --------- --------- --------- -------------- 371s fetch 0 0 0.008s 371s before load 0 2 0.028s 371s ----------------------- --------- --------- --------- -------------- 371s "public"."nulls" 0 7 0.3 kB 0.056s 371s "expected"."nulls" 0 6 0.3 kB 0.024s 371s ----------------------- --------- --------- --------- -------------- 371s Files Processed 0 2 0.032s 371s COPY Threads Completion 0 4 0.080s 371s ----------------------- --------- --------- --------- -------------- 371s Total import time ✓ 13 0.6 kB 0.112s 371s 2024-11-15T04:34:08.574067Z LOG Regress pass. 371s touch regress/out/csv-keep-extra-blanks.out 371s pgloader --regress csv-missing-col.load 372s 2024-11-15T04:34:09.015953Z LOG pgloader version "3.6.10~devel" 372s 2024-11-15T04:34:09.015953Z LOG Data errors in '/tmp/pgloader/' 372s 2024-11-15T04:34:09.015953Z LOG Regression testing: "csv-missing-col.load" 372s 2024-11-15T04:34:09.015953Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-missing-col.load" 372s 2024-11-15T04:34:09.378884Z LOG COPY INIT ERROR 372s 2024-11-15T04:34:09.378884Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 372s Database error 42703: column "c" of relation "missingcol" does not exist 372s 2024-11-15T04:34:09.406802Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-missing-col.out") 372s 2024-11-15T04:34:09.426743Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 372s 2024-11-15T04:34:09.530438Z LOG report summary reset 372s table name errors rows bytes total time 372s ----------------------- --------- --------- --------- -------------- 372s fetch 0 0 0.012s 372s before load 0 2 0.024s 372s ----------------------- --------- --------- --------- -------------- 372s "public"."missingcol" 1 0 0.048s 372s "expected"."missingcol" 0 0 0.020s 372s ----------------------- --------- --------- --------- -------------- 372s Files Processed 0 2 0.028s 372s COPY Threads Completion 0 4 0.076s 372s ----------------------- --------- --------- --------- -------------- 372s Total import time 1 0 0.104s 372s 2024-11-15T04:34:09.582285Z LOG Regress pass. 372s touch regress/out/csv-missing-col.out 372s pgloader --regress csv-non-printable.load 372s 2024-11-15T04:34:09.015953Z LOG pgloader version "3.6.10~devel" 372s 2024-11-15T04:34:09.019941Z LOG Data errors in '/tmp/pgloader/' 372s 2024-11-15T04:34:09.019941Z LOG Regression testing: "csv-non-printable.load" 372s 2024-11-15T04:34:09.019941Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-non-printable.load" 373s 2024-11-15T04:34:09.442837Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-non-printable.out") 373s 2024-11-15T04:34:09.458796Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 373s 2024-11-15T04:34:09.546570Z LOG report summary reset 373s table name errors rows bytes total time 373s ----------------------- --------- --------- --------- -------------- 373s fetch 0 0 0.012s 373s before load 0 2 0.028s 373s ----------------------- --------- --------- --------- -------------- 373s "public"."tab_csv" 0 7 0.2 kB 0.056s 373s "expected"."tab_csv" 0 7 0.2 kB 0.020s 373s ----------------------- --------- --------- --------- -------------- 373s Files Processed 0 2 0.032s 373s COPY Threads Completion 0 4 0.076s 373s ----------------------- --------- --------- --------- -------------- 373s Total import time ✓ 14 0.4 kB 0.108s 373s 2024-11-15T04:34:09.594447Z LOG Regress pass. 373s touch regress/out/csv-non-printable.out 373s pgloader --regress csv-nulls.load 373s 2024-11-15T04:34:10.027928Z LOG pgloader version "3.6.10~devel" 373s 2024-11-15T04:34:10.031918Z LOG Data errors in '/tmp/pgloader/' 373s 2024-11-15T04:34:10.031918Z LOG Regression testing: "csv-nulls.load" 373s 2024-11-15T04:34:10.031918Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-nulls.load" 374s 2024-11-15T04:34:10.323202Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 374s 2024-11-15T04:34:10.327193Z WARNING That could impact loading performance badly. 374s 2024-11-15T04:34:10.327193Z WARNING Consider the option 'drop indexes'. 374s 2024-11-15T04:34:10.438941Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-nulls.out") 374s 2024-11-15T04:34:10.458896Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 374s 2024-11-15T04:34:10.574635Z 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.024s 374s ----------------------- --------- --------- --------- -------------- 374s "public"."nullif" 0 2 0.0 kB 0.056s 374s "expected"."nullif" 0 2 0.0 kB 0.028s 374s ----------------------- --------- --------- --------- -------------- 374s Files Processed 0 2 0.032s 374s COPY Threads Completion 0 4 0.084s 374s ----------------------- --------- --------- --------- -------------- 374s Total import time ✓ 4 0.1 kB 0.116s 374s 2024-11-15T04:34:10.634500Z LOG Regress pass. 374s touch regress/out/csv-nulls.out 374s pgloader --regress csv-temp.load 374s 2024-11-15T04:34:11.015964Z LOG pgloader version "3.6.10~devel" 374s 2024-11-15T04:34:11.015964Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/csv-temp.load" 375s 2024-11-15T04:34:11.383154Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-temp.out") 375s 2024-11-15T04:34:11.403115Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 375s 2024-11-15T04:34:11.506911Z LOG report summary reset 375s table name errors rows bytes total time 375s ----------------------- --------- --------- --------- -------------- 375s fetch 0 0 0.008s 375s before load 0 2 0.020s 375s ----------------------- --------- --------- --------- -------------- 375s "public"."temp" 0 5 0.2 kB 0.048s 375s "expected"."temp" 0 5 0.2 kB 0.028s 375s ----------------------- --------- --------- --------- -------------- 375s Files Processed 0 2 0.036s 375s COPY Threads Completion 0 4 0.080s 375s ----------------------- --------- --------- --------- -------------- 375s Total import time ✓ 10 0.3 kB 0.116s 375s 2024-11-15T04:34:11.570785Z LOG Regress pass. 375s touch regress/out/csv-temp.out 375s pgloader --regress csv-trim-extra-blanks.load 375s 2024-11-15T04:34:12.027945Z LOG pgloader version "3.6.10~devel" 375s 2024-11-15T04:34:12.407197Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-trim-extra-blanks.out") 376s 2024-11-15T04:34:12.518981Z LOG report summary reset 376s table name errors rows bytes total time 376s ----------------------- --------- --------- --------- -------------- 376s fetch 0 0 0.008s 376s before load 0 2 0.028s 376s ----------------------- --------- --------- --------- -------------- 376s "public"."nulls" 0 7 0.3 kB 0.052s 376s "expected"."nulls" 0 7 0.3 kB 0.024s 376s ----------------------- --------- --------- --------- -------------- 376s Files Processed 0 2 0.028s 376s COPY Threads Completion 0 4 0.076s 376s ----------------------- --------- --------- --------- -------------- 376s Total import time ✓ 14 0.6 kB 0.104s 376s 2024-11-15T04:34:12.574885Z LOG Regress pass. 376s touch regress/out/csv-trim-extra-blanks.out 376s pgloader --regress csv-using-sexp.load 376s 2024-11-15T04:34:13.015973Z LOG pgloader version "3.6.10~devel" 376s 2024-11-15T04:34:13.367367Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv-using-sexp.out") 376s 2024-11-15T04:34:13.383339Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 376s 2024-11-15T04:34:13.479174Z LOG report summary reset 376s table name errors rows bytes total time 376s ----------------------- --------- --------- --------- -------------- 376s fetch 0 0 0.004s 376s before load 0 2 0.024s 376s ----------------------- --------- --------- --------- -------------- 376s "public"."sexp" 0 3 0.0 kB 0.048s 376s "expected"."sexp" 0 3 0.0 kB 0.020s 376s ----------------------- --------- --------- --------- -------------- 376s Files Processed 0 2 0.032s 376s COPY Threads Completion 0 4 0.068s 376s ----------------------- --------- --------- --------- -------------- 376s Total import time ✓ 6 0.1 kB 0.100s 376s 2024-11-15T04:34:13.527091Z LOG Regress pass. 376s touch regress/out/csv-using-sexp.out 376s pgloader --regress csv.load 377s 2024-11-15T04:34:14.011982Z LOG pgloader version "3.6.10~devel" 377s 2024-11-15T04:34:14.071892Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 377s 2024-11-15T04:34:14.371440Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 377s 2024-11-15T04:34:14.391410Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/csv.out") 377s 2024-11-15T04:34:14.411380Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 377s 2024-11-15T04:34:14.511229Z LOG report summary reset 377s table name errors rows bytes total time 377s ----------------------- --------- --------- --------- -------------- 377s fetch 0 0 0.004s 377s before load 0 2 0.024s 377s ----------------------- --------- --------- --------- -------------- 377s "public"."csv" 0 6 0.2 kB 0.048s 377s "expected"."csv" 0 6 0.2 kB 0.020s 377s ----------------------- --------- --------- --------- -------------- 377s Files Processed 0 2 0.036s 377s COPY Threads Completion 0 4 0.068s 377s ----------------------- --------- --------- --------- -------------- 377s Total import time ✓ 12 0.4 kB 0.104s 377s 2024-11-15T04:34:14.567145Z LOG Regress pass. 377s touch regress/out/csv.out 377s pgloader --regress copy.load 377s 2024-11-15T04:34:14.015976Z LOG pgloader version "3.6.10~devel" 378s 2024-11-15T04:34:14.071891Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 378s 2024-11-15T04:34:14.511312Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 378s 2024-11-15T04:34:14.531286Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/copy.out") 378s 2024-11-15T04:34:14.551259Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 378s 2024-11-15T04:34:14.739011Z LOG report summary reset 378s table name errors rows bytes total time 378s ----------------------- --------- --------- --------- -------------- 378s fetch 0 0 0.004s 378s before load 0 2 0.024s 378s ----------------------- --------- --------- --------- -------------- 378s "public"."track_full" 0 3503 366.8 kB 0.124s 378s "expected"."track_full" 0 3503 366.8 kB 0.112s 378s ----------------------- --------- --------- --------- -------------- 378s Files Processed 0 2 0.036s 378s COPY Threads Completion 0 4 0.232s 378s Index Build Completion 0 0 0.024s 378s Create Indexes 0 1 0.000s 378s Constraints 0 1 0.000s 378s ----------------------- --------- --------- --------- -------------- 378s Total import time ✓ 7006 733.5 kB 0.292s 378s 2024-11-15T04:34:14.790942Z LOG Regress pass. 378s touch regress/out/copy.out 378s pgloader --regress copy-hex.load 379s 2024-11-15T04:34:15.027964Z LOG pgloader version "3.6.10~devel" 379s 2024-11-15T04:34:15.035955Z LOG Data errors in '/tmp/pgloader/' 379s 2024-11-15T04:34:15.035955Z LOG Regression testing: "copy-hex.load" 379s 2024-11-15T04:34:15.035955Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/copy-hex.load" 379s 2024-11-15T04:34:15.407527Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/copy-hex.out") 379s 2024-11-15T04:34:15.431499Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 379s 2024-11-15T04:34:15.527388Z 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.024s 379s ----------------------- --------- --------- --------- -------------- 379s "public"."copyhex" 0 6 0.0 kB 0.040s 379s "expected"."copyhex" 0 6 0.0 kB 0.024s 379s ----------------------- --------- --------- --------- -------------- 379s Files Processed 0 2 0.028s 379s COPY Threads Completion 0 4 0.068s 379s ----------------------- --------- --------- --------- -------------- 379s Total import time ✓ 12 0.1 kB 0.096s 379s 2024-11-15T04:34:15.579328Z LOG Regress pass. 379s touch regress/out/copy-hex.out 379s pgloader --regress dbf.load 379s 2024-11-15T04:34:16.015982Z LOG pgloader version "3.6.10~devel" 379s 2024-11-15T04:34:16.015982Z LOG Data errors in '/tmp/pgloader/' 379s 2024-11-15T04:34:16.015982Z LOG Regression testing: "dbf.load" 379s 2024-11-15T04:34:16.015982Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/dbf.load" 380s 2024-11-15T04:34:16.159816Z LOG Migrating from # 380s 2024-11-15T04:34:16.159816Z LOG Migrating into # 380s 2024-11-15T04:34:16.331640Z WARNING Forcing encoding to CP850, db3 file has ASCII 380s 2024-11-15T04:34:16.427543Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/dbf.out") 380s 2024-11-15T04:34:16.451519Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 380s 2024-11-15T04:34:16.627341Z LOG report summary reset 380s table name errors rows bytes total time 380s ----------------------- --------- --------- --------- -------------- 380s fetch 0 0 0.008s 380s Create Schemas 0 0 0.000s 380s Create SQL Types 0 0 0.008s 380s Create tables 0 2 0.028s 380s ----------------------- --------- --------- --------- -------------- 380s public.reg2013 0 27 1.0 kB 0.028s 380s "expected"."reg2013" 0 27 1.0 kB 0.028s 380s ----------------------- --------- --------- --------- -------------- 380s COPY Threads Completion 0 6 0.060s 380s Create Triggers 0 0 0.000s 380s Install Comments 0 0 0.000s 380s Files Processed 0 1 0.012s 380s ----------------------- --------- --------- --------- -------------- 380s Total import time ✓ 54 1.9 kB 0.072s 380s 2024-11-15T04:34:16.675293Z LOG Regress pass. 380s touch regress/out/dbf.out 380s pgloader --regress errors.load 380s 2024-11-15T04:34:17.011988Z LOG pgloader version "3.6.10~devel" 380s 2024-11-15T04:34:17.015984Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/errors.load" 380s 2024-11-15T04:34:17.071928Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 381s 2024-11-15T04:34:17.295706Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 381s 2024-11-15T04:34:17.295706Z WARNING That could impact loading performance badly. 381s 2024-11-15T04:34:17.295706Z WARNING Consider the option 'drop indexes'. 381s 2024-11-15T04:34:17.359650Z ERROR End of file while collecting quoted item: # 381s 2024-11-15T04:34:17.359650Z FATAL End of file while collecting quoted item: # 381s 2024-11-15T04:34:17.367643Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 381s HINT: Perhaps you need a different "datestyle" setting. 381s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 381s 2024-11-15T04:34:17.371640Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 381s HINT: Perhaps you need a different "datestyle" setting. 381s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 381s 2024-11-15T04:34:17.371640Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 381s HINT: Perhaps you need a different "datestyle" setting. 381s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 381s 2024-11-15T04:34:17.387626Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 381s 2024-11-15T04:34:17.407608Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/errors.out") 381s 2024-11-15T04:34:17.423594Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 381s 2024-11-15T04:34:17.519509Z LOG report summary reset 381s table name errors rows bytes total time 381s ----------------------- --------- --------- --------- -------------- 381s fetch 0 0 0.004s 381s before load 0 4 0.028s 381s ----------------------- --------- --------- --------- -------------- 381s "err"."errors" 8 7 0.3 kB 0.052s 381s "expected"."errors" 0 7 0.2 kB 0.020s 381s ----------------------- --------- --------- --------- -------------- 381s Files Processed 0 2 0.032s 381s COPY Threads Completion 0 4 0.076s 381s ----------------------- --------- --------- --------- -------------- 381s Total import time 8 14 0.6 kB 0.108s 381s 2024-11-15T04:34:17.579456Z LOG Regress pass. 381s touch regress/out/errors.out 381s pgloader --regress fixed.load 381s 2024-11-15T04:34:18.019982Z LOG pgloader version "3.6.10~devel" 381s 2024-11-15T04:34:18.023979Z LOG Data errors in '/tmp/pgloader/' 381s 2024-11-15T04:34:18.023979Z LOG Regression testing: "fixed.load" 381s 2024-11-15T04:34:18.023979Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/fixed.load" 381s 2024-11-15T04:34:18.083926Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 382s 2024-11-15T04:34:18.439616Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 382s 2024-11-15T04:34:18.459600Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/fixed.out") 382s 2024-11-15T04:34:18.475588Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 382s 2024-11-15T04:34:18.583506Z LOG report summary reset 382s table name errors rows bytes total time 382s ----------------------- --------- --------- --------- -------------- 382s fetch 0 0 0.008s 382s before load 0 2 0.028s 382s ----------------------- --------- --------- --------- -------------- 382s "public"."fixed" 0 5 0.2 kB 0.040s 382s "expected"."fixed" 0 5 0.2 kB 0.032s 382s ----------------------- --------- --------- --------- -------------- 382s Files Processed 0 2 0.032s 382s COPY Threads Completion 0 4 0.072s 382s Index Build Completion 0 0 0.020s 382s Create Indexes 0 1 0.004s 382s Constraints 0 1 0.000s 382s ----------------------- --------- --------- --------- -------------- 382s Total import time ✓ 10 0.4 kB 0.128s 382s 2024-11-15T04:34:18.639462Z LOG Regress pass. 382s touch regress/out/fixed.out 382s pgloader --regress fields-with-periods.load 382s 2024-11-15T04:34:19.011990Z LOG pgloader version "3.6.10~devel" 382s 2024-11-15T04:34:19.383703Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/fields-with-periods.out") 383s 2024-11-15T04:34:19.511607Z 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.024s 383s ----------------------- --------- --------- --------- -------------- 383s "public"."fixed" 0 3 0.0 kB 0.036s 383s "expected"."fixed" 0 3 0.0 kB 0.024s 383s ----------------------- --------- --------- --------- -------------- 383s Files Processed 0 2 0.036s 383s COPY Threads Completion 0 4 0.056s 383s ----------------------- --------- --------- --------- -------------- 383s Total import time ✓ 6 0.0 kB 0.092s 383s 2024-11-15T04:34:19.563572Z LOG Regress pass. 383s touch regress/out/fields-with-periods.out 383s pgloader --regress ixf.load 383s 2024-11-15T04:34:20.011991Z LOG pgloader version "3.6.10~devel" 383s 2024-11-15T04:34:20.015989Z LOG Data errors in '/tmp/pgloader/' 383s 2024-11-15T04:34:20.015989Z LOG Regression testing: "ixf.load" 383s 2024-11-15T04:34:20.015989Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/ixf.load" 383s 2024-11-15T04:34:20.155894Z LOG Migrating from # 383s 2024-11-15T04:34:20.155894Z LOG Migrating into # 383s 2024-11-15T04:34:20.415718Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/ixf.out") 383s 2024-11-15T04:34:20.431707Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 383s 2024-11-15T04:34:20.587602Z LOG report summary reset 384s table name errors rows bytes total time 384s ----------------------- --------- --------- --------- -------------- 384s fetch 0 0 0.008s 384s before load 0 3 0.020s 384s Create Schemas 0 0 0.000s 384s Create SQL Types 0 0 0.008s 384s Create tables 0 2 0.028s 384s ----------------------- --------- --------- --------- -------------- 384s nsitra.test1 0 4 0.2 kB 0.024s 384s "expected"."test1" 0 4 0.2 kB 0.032s 384s ----------------------- --------- --------- --------- -------------- 384s COPY Threads Completion 0 6 0.068s 384s Index Build Completion 0 0 0.008s 384s Primary Keys 0 0 0.000s 384s Create Triggers 0 0 0.000s 384s Install Comments 0 0 0.000s 384s Files Processed 0 1 0.012s 384s ----------------------- --------- --------- --------- -------------- 384s Total import time ✓ 8 0.3 kB 0.088s 384s 2024-11-15T04:34:20.635570Z LOG Regress pass. 384s touch regress/out/ixf.out 384s pgloader --regress overflow.load 384s 2024-11-15T04:34:21.011993Z LOG pgloader version "3.6.10~devel" 384s 2024-11-15T04:34:21.015991Z LOG Data errors in '/tmp/pgloader/' 384s 2024-11-15T04:34:21.015991Z LOG Regression testing: "overflow.load" 384s 2024-11-15T04:34:21.015991Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/overflow.load" 384s 2024-11-15T04:34:21.351792Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 384s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 384s 2024-11-15T04:34:21.355790Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 384s DETAIL: Failing row contains (12, null). 384s CONTEXT: COPY overflow, line 1: "12 \N" 384s 2024-11-15T04:34:21.387771Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/overflow.out") 384s 2024-11-15T04:34:21.407759Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 384s 2024-11-15T04:34:21.511698Z LOG report summary reset 384s table name errors rows bytes total time 384s ----------------------- --------- --------- --------- -------------- 384s fetch 0 0 0.008s 384s before load 0 2 0.020s 384s ----------------------- --------- --------- --------- -------------- 384s "public"."overflow" 4 0 0.0 kB 0.048s 384s "expected"."overflow" 0 0 0.020s 384s ----------------------- --------- --------- --------- -------------- 384s Files Processed 0 2 0.036s 384s COPY Threads Completion 0 4 0.072s 384s ----------------------- --------- --------- --------- -------------- 384s Total import time 4 0 0.0 kB 0.108s 384s 2024-11-15T04:34:21.559669Z LOG Regress pass. 384s touch regress/out/overflow.out 384s pgloader --regress partial.load 385s 2024-11-15T04:34:22.015991Z LOG pgloader version "3.6.10~devel" 385s 2024-11-15T04:34:22.019989Z LOG Data errors in '/tmp/pgloader/' 385s 2024-11-15T04:34:22.019989Z LOG Regression testing: "partial.load" 385s 2024-11-15T04:34:22.019989Z LOG Parsing commands from file #P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/partial.load" 385s 2024-11-15T04:34:22.079958Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-11-15T04:34:22.455753Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-11-15T04:34:22.471745Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/partial.out") 385s 2024-11-15T04:34:22.487736Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 385s 2024-11-15T04:34:22.579686Z LOG report summary reset 385s table name errors rows bytes total time 385s ----------------------- --------- --------- --------- -------------- 385s fetch 0 0 0.008s 385s before load 0 4 0.024s 385s ----------------------- --------- --------- --------- -------------- 385s "csv"."partial" 0 7 0.1 kB 0.044s 385s "expected"."partial" 0 7 0.1 kB 0.024s 385s ----------------------- --------- --------- --------- -------------- 385s Files Processed 0 2 0.040s 385s COPY Threads Completion 0 4 0.076s 385s Index Build Completion 0 0 0.020s 385s Create Indexes 0 2 0.008s 385s Constraints 0 1 0.004s 385s ----------------------- --------- --------- --------- -------------- 385s Total import time ✓ 14 0.2 kB 0.148s 385s 2024-11-15T04:34:22.631658Z LOG Regress pass. 385s touch regress/out/partial.out 385s pgloader --regress serial.load 385s 2024-11-15T04:34:22.019989Z LOG pgloader version "3.6.10~devel" 386s 2024-11-15T04:34:22.075963Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 386s 2024-11-15T04:34:22.299910Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 386s 2024-11-15T04:34:22.299910Z WARNING That could impact loading performance badly. 386s 2024-11-15T04:34:22.299910Z WARNING Consider the option 'drop indexes'. 386s 2024-11-15T04:34:22.383890Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 386s 2024-11-15T04:34:22.399886Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/serial.out") 386s 2024-11-15T04:34:22.419881Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 386s 2024-11-15T04:34:22.511859Z LOG report summary reset 386s table name errors rows bytes total time 386s ----------------------- --------- --------- --------- -------------- 386s fetch 0 0 0.008s 386s before load 0 2 0.028s 386s ----------------------- --------- --------- --------- -------------- 386s "public"."serial" 0 7 0.2 kB 0.044s 386s "expected"."serial" 0 7 0.2 kB 0.016s 386s ----------------------- --------- --------- --------- -------------- 386s Files Processed 0 2 0.032s 386s COPY Threads Completion 0 4 0.068s 386s ----------------------- --------- --------- --------- -------------- 386s Total import time ✓ 14 0.4 kB 0.100s 386s 2024-11-15T04:34:22.563847Z LOG Regress pass. 386s touch regress/out/serial.out 386s pgloader --regress udc.load 386s 2024-11-15T04:34:23.019995Z LOG pgloader version "3.6.10~devel" 386s 2024-11-15T04:34:23.083980Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 387s 2024-11-15T04:34:23.291930Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 387s 2024-11-15T04:34:23.291930Z WARNING That could impact loading performance badly. 387s 2024-11-15T04:34:23.291930Z WARNING Consider the option 'drop indexes'. 387s 2024-11-15T04:34:23.383910Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 387s 2024-11-15T04:34:23.407905Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/udc.out") 387s 2024-11-15T04:34:23.427900Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 387s 2024-11-15T04:34:23.539875Z 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.024s 387s ----------------------- --------- --------- --------- -------------- 387s "public"."udc" 0 5 0.1 kB 0.044s 387s "expected"."udc" 0 5 0.1 kB 0.024s 387s ----------------------- --------- --------- --------- -------------- 387s Files Processed 0 2 0.032s 387s COPY Threads Completion 0 4 0.072s 387s ----------------------- --------- --------- --------- -------------- 387s Total import time ✓ 10 0.2 kB 0.104s 387s 2024-11-15T04:34:23.599861Z LOG Regress pass. 387s touch regress/out/udc.out 387s pgloader --regress xzero.load 387s 2024-11-15T04:34:24.019995Z LOG pgloader version "3.6.10~devel" 387s 2024-11-15T04:34:24.071984Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 387s 2024-11-15T04:34:24.283935Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 387s 2024-11-15T04:34:24.283935Z WARNING That could impact loading performance badly. 387s 2024-11-15T04:34:24.283935Z WARNING Consider the option 'drop indexes'. 388s 2024-11-15T04:34:24.359918Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 388s 2024-11-15T04:34:24.375915Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.8mC8bw/build.bBo/src/test/regress/expected/xzero.out") 388s 2024-11-15T04:34:24.395910Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 388s 2024-11-15T04:34:24.487890Z 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.024s 388s ----------------------- --------- --------- --------- -------------- 388s "public"."xzero" 0 7 0.2 kB 0.036s 388s "expected"."xzero" 0 7 0.2 kB 0.016s 388s ----------------------- --------- --------- --------- -------------- 388s Files Processed 0 2 0.028s 388s COPY Threads Completion 0 4 0.056s 388s ----------------------- --------- --------- --------- -------------- 388s Total import time ✓ 14 0.4 kB 0.084s 388s 2024-11-15T04:34:24.547878Z LOG Regress pass. 388s touch regress/out/xzero.out 388s make: Leaving directory '/tmp/autopkgtest.8mC8bw/build.bBo/src/test' 388s Dropping cluster 17/regress ... 388s autopkgtest [04:34:25]: test testsuite: -----------------------] 389s autopkgtest [04:34:26]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 389s testsuite PASS 389s autopkgtest [04:34:26]: @@@@@@@@@@@@@@@@@@@@ summary 389s ssl PASS 389s testsuite PASS 394s nova [W] Using flock in prodstack6-ppc64el 394s Creating nova instance adt-plucky-ppc64el-pgloader-20241115-042756-juju-7f2275-prod-proposed-migration-environment-20-5a80db18-6867-4c91-ac82-66fe86807979 from image adt/ubuntu-plucky-ppc64el-server-20241113.img (UUID 0c5715b6-5cca-4485-b8bf-b85dfd917a5f)... 394s nova [W] Using flock in prodstack6-ppc64el 394s Creating nova instance adt-plucky-ppc64el-pgloader-20241115-042756-juju-7f2275-prod-proposed-migration-environment-20-5a80db18-6867-4c91-ac82-66fe86807979 from image adt/ubuntu-plucky-ppc64el-server-20241113.img (UUID 0c5715b6-5cca-4485-b8bf-b85dfd917a5f)...