1s autopkgtest [14:16:44]: starting date and time: 2025-03-15 14:16:44+0000 1s autopkgtest [14:16:44]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [14:16:44]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.1489khla/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-34.secgroup --name adt-plucky-arm64-pgloader-20250315-141643-juju-7f2275-prod-proposed-migration-environment-2-e931c76e-eccd-4d2e-b759-3165043e9c37 --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 172s autopkgtest [14:19:35]: testbed dpkg architecture: arm64 173s autopkgtest [14:19:36]: testbed apt version: 2.9.33 173s autopkgtest [14:19:36]: @@@@@@@@@@@@@@@@@@@@ test bed setup 173s autopkgtest [14:19:36]: testbed release detected to be: None 174s autopkgtest [14:19:37]: updating testbed package index (apt update) 175s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 175s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 175s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 175s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 175s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 175s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 175s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 176s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 176s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 176s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 176s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 176s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 176s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 176s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 176s Fetched 1094 kB in 2s (707 kB/s) 178s Reading package lists... 179s Reading package lists... 180s Building dependency tree... 180s Reading state information... 181s Calculating upgrade... 181s Calculating upgrade... 182s The following packages will be upgraded: 182s python3-jinja2 strace 182s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 182s Need to get 608 kB of archives. 182s After this operation, 11.3 kB of additional disk space will be used. 182s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 183s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 183s Fetched 608 kB in 1s (693 kB/s) 183s (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 ... 117701 files and directories currently installed.) 183s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 183s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 184s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 184s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 184s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 184s Setting up strace (6.13+ds-1ubuntu1) ... 184s Processing triggers for man-db (2.13.0-1) ... 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 186s Solving dependencies... 187s The following packages will be REMOVED: 187s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 187s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 187s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 187s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 187s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 187s After this operation, 267 MB disk space will be freed. 188s (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 ... 117701 files and directories currently installed.) 188s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 188s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 188s Removing libpython3.12t64:arm64 (3.12.9-1) ... 188s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 188s Removing libnsl2:arm64 (1.3.0-3build3) ... 188s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 188s Removing libunwind8:arm64 (1.6.2-3.1) ... 188s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 188s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 190s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 190s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 190s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 190s /etc/kernel/postrm.d/initramfs-tools: 190s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 190s /etc/kernel/postrm.d/zz-flash-kernel: 190s flash-kernel: Kernel 6.11.0-8-generic has been removed. 190s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 191s /etc/kernel/postrm.d/zz-update-grub: 191s Sourcing file `/etc/default/grub' 191s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 191s Generating grub configuration file ... 191s Found linux image: /boot/vmlinuz-6.14.0-10-generic 191s Found initrd image: /boot/initrd.img-6.14.0-10-generic 192s Warning: os-prober will not be executed to detect other bootable partitions. 192s Systems on them will not be added to the GRUB boot configuration. 192s Check GRUB_DISABLE_OS_PROBER documentation entry. 192s Adding boot menu entry for UEFI Firmware Settings ... 192s done 192s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 192s Processing triggers for libc-bin (2.41-1ubuntu1) ... 192s (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 ... 81650 files and directories currently installed.) 192s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 192s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 192s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 193s autopkgtest [14:19:56]: upgrading testbed (apt dist-upgrade and autopurge) 193s Reading package lists... 193s Building dependency tree... 193s Reading state information... 194s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 194s Starting 2 pkgProblemResolver with broken count: 0 194s Done 195s Entering ResolveByKeep 195s 196s Calculating upgrade... 196s The following packages will be upgraded: 196s libc-bin libc-dev-bin libc6 libc6-dev locales 197s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 197s Need to get 9530 kB of archives. 197s After this operation, 0 B of additional disk space will be used. 197s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 198s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 198s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 201s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 202s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 206s Preconfiguring packages ... 206s Fetched 9530 kB in 9s (1026 kB/s) 207s (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 ... 81647 files and directories currently installed.) 207s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 207s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 207s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 207s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 207s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 207s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Setting up libc6:arm64 (2.41-1ubuntu2) ... 208s (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 ... 81647 files and directories currently installed.) 208s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 208s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Setting up libc-bin (2.41-1ubuntu2) ... 208s (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 ... 81647 files and directories currently installed.) 208s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 208s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 208s Setting up locales (2.41-1ubuntu2) ... 210s Generating locales (this might take a while)... 212s en_US.UTF-8... done 212s Generation complete. 212s Setting up libc-dev-bin (2.41-1ubuntu2) ... 212s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 212s Processing triggers for man-db (2.13.0-1) ... 213s Processing triggers for systemd (257.3-1ubuntu3) ... 214s Reading package lists... 214s Building dependency tree... 214s Reading state information... 215s Starting pkgProblemResolver with broken count: 0 215s Starting 2 pkgProblemResolver with broken count: 0 215s Done 216s Solving dependencies... 217s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 217s autopkgtest [14:20:20]: rebooting testbed after setup commands that affected boot 242s autopkgtest [14:20:45]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP PREEMPT_DYNAMIC Wed Mar 12 15:45:31 UTC 2025 244s autopkgtest [14:20:47]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 250s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (dsc) [2932 B] 250s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (tar) [3723 kB] 250s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (diff) [9880 B] 250s gpgv: Signature made Mon Oct 28 11:35:26 2024 UTC 250s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 250s gpgv: Can't check signature: No public key 250s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-4.dsc: no acceptable signature found 250s autopkgtest [14:20:53]: testing package pgloader version 3.6.10-4 251s autopkgtest [14:20:54]: build not needed 252s autopkgtest [14:20:55]: test ssl: preparing testbed 253s Reading package lists... 253s Building dependency tree... 253s Reading state information... 254s Starting pkgProblemResolver with broken count: 0 254s Starting 2 pkgProblemResolver with broken count: 0 254s Done 256s The following NEW packages will be installed: 256s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 256s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 256s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-features 256s cl-trivial-garbage cl-trivial-gray-streams cl-uax-15 cl-usocket 256s freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 256s libjson-perl libllvm20 libpq5 libsybdb5 libxslt1.1 pgloader postgresql 256s postgresql-17 postgresql-client-17 postgresql-client-common 256s postgresql-common postgresql-common-dev ssl-cert 256s 0 upgraded, 38 newly installed, 0 to remove and 0 not upgraded. 256s Need to get 76.2 MB of archives. 256s After this operation, 247 MB of additional disk space will be used. 256s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 256s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 256s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 256s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 257s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 257s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 257s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 257s Get:8 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-alexandria all 20240125.git8514d8e-1 [204 kB] 257s Get:9 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-rt all 20090812.gita6a7503-1 [13.2 kB] 257s Get:10 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-kmrcl all 1.111-2 [42.7 kB] 257s Get:11 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-base64 all 3.4.0-1 [9304 B] 257s Get:12 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 257s Get:13 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-trivial-features all 20230607.gitd249a62-1 [10.6 kB] 257s Get:14 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-trivial-garbage all 20231018.git3474f64-1 [8924 B] 257s Get:15 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-bordeaux-threads all 0.9.4-1 [35.5 kB] 257s Get:16 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-closer-mop all 2:20241031.git875f4b7-1 [24.5 kB] 257s Get:17 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-trivial-gray-streams all 20240217.gita7ead68-1 [9956 B] 257s Get:18 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-flexi-streams all 20240427.git4951d57-1 [209 kB] 257s Get:19 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-ironclad all 0.61-4 [1247 kB] 259s Get:20 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 259s Get:21 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-split-sequence all 1:2.0.1-1 [12.2 kB] 259s Get:22 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-ppcre all 20240427.git80fb19d-1 [108 kB] 259s Get:23 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-uax-15 all 0~20240127.git2226aa3-1 [581 kB] 260s Get:24 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-usocket all 0.8.8-3 [75.1 kB] 260s Get:25 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-postgres all 20211113.git9d4332f-5 [56.8 kB] 260s Get:26 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-s-sql all 20211113.git9d4332f-5 [61.1 kB] 260s Get:27 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-postmodern all 20211113.git9d4332f-5 [354 kB] 260s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 260s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 libct4 arm64 1.3.17+ds-2build3 [163 kB] 261s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 libsybdb5 arm64 1.3.17+ds-2build3 [186 kB] 261s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-dev arm64 1.3.17+ds-2build3 [300 kB] 261s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 288s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 288s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 288s Get:35 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 290s Get:36 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 304s Get:37 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql all 17+274 [14.4 kB] 304s Get:38 http://ftpmaster.internal/ubuntu plucky/universe arm64 pgloader arm64 3.6.10-4 [25.6 MB] 329s Preconfiguring packages ... 329s /var/cache/debconf/tmp.ci/postgresql.config.gIziZF: 12: pg_lsclusters: not found 329s Fetched 76.2 MB in 1min 13s (1046 kB/s) 329s Selecting previously unselected package libjson-perl. 330s (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 ... 81647 files and directories currently installed.) 330s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 330s Unpacking libjson-perl (4.10000-1) ... 330s Selecting previously unselected package postgresql-client-common. 330s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 330s Unpacking postgresql-client-common (274) ... 330s Selecting previously unselected package libio-pty-perl. 330s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 330s Unpacking libio-pty-perl (1:1.20-1build3) ... 330s Selecting previously unselected package libipc-run-perl. 330s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 330s Unpacking libipc-run-perl (20231003.0-2) ... 330s Selecting previously unselected package postgresql-common-dev. 330s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 330s Unpacking postgresql-common-dev (274) ... 330s Selecting previously unselected package ssl-cert. 330s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 330s Unpacking ssl-cert (1.1.3ubuntu1) ... 330s Selecting previously unselected package postgresql-common. 330s Preparing to unpack .../06-postgresql-common_274_all.deb ... 330s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 330s Unpacking postgresql-common (274) ... 330s Selecting previously unselected package cl-alexandria. 330s Preparing to unpack .../07-cl-alexandria_20240125.git8514d8e-1_all.deb ... 330s Unpacking cl-alexandria (20240125.git8514d8e-1) ... 330s Selecting previously unselected package cl-rt. 330s Preparing to unpack .../08-cl-rt_20090812.gita6a7503-1_all.deb ... 330s Unpacking cl-rt (20090812.gita6a7503-1) ... 330s Selecting previously unselected package cl-kmrcl. 330s Preparing to unpack .../09-cl-kmrcl_1.111-2_all.deb ... 330s Unpacking cl-kmrcl (1.111-2) ... 330s Selecting previously unselected package cl-base64. 330s Preparing to unpack .../10-cl-base64_3.4.0-1_all.deb ... 330s Unpacking cl-base64 (3.4.0-1) ... 330s Selecting previously unselected package cl-global-vars. 330s Preparing to unpack .../11-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 330s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 330s Selecting previously unselected package cl-trivial-features. 330s Preparing to unpack .../12-cl-trivial-features_20230607.gitd249a62-1_all.deb ... 330s Unpacking cl-trivial-features (20230607.gitd249a62-1) ... 330s Selecting previously unselected package cl-trivial-garbage. 330s Preparing to unpack .../13-cl-trivial-garbage_20231018.git3474f64-1_all.deb ... 330s Unpacking cl-trivial-garbage (20231018.git3474f64-1) ... 330s Selecting previously unselected package cl-bordeaux-threads. 330s Preparing to unpack .../14-cl-bordeaux-threads_0.9.4-1_all.deb ... 330s Unpacking cl-bordeaux-threads (0.9.4-1) ... 330s Selecting previously unselected package cl-closer-mop. 330s Preparing to unpack .../15-cl-closer-mop_2%3a20241031.git875f4b7-1_all.deb ... 330s Unpacking cl-closer-mop (2:20241031.git875f4b7-1) ... 330s Selecting previously unselected package cl-trivial-gray-streams. 330s Preparing to unpack .../16-cl-trivial-gray-streams_20240217.gita7ead68-1_all.deb ... 330s Unpacking cl-trivial-gray-streams (20240217.gita7ead68-1) ... 330s Selecting previously unselected package cl-flexi-streams. 330s Preparing to unpack .../17-cl-flexi-streams_20240427.git4951d57-1_all.deb ... 330s Unpacking cl-flexi-streams (20240427.git4951d57-1) ... 330s Selecting previously unselected package cl-ironclad. 330s Preparing to unpack .../18-cl-ironclad_0.61-4_all.deb ... 330s Unpacking cl-ironclad (0.61-4) ... 331s Selecting previously unselected package cl-md5. 331s Preparing to unpack .../19-cl-md5_1%3a20210622.git906593f-1_all.deb ... 331s Unpacking cl-md5 (1:20210622.git906593f-1) ... 331s Selecting previously unselected package cl-split-sequence. 331s Preparing to unpack .../20-cl-split-sequence_1%3a2.0.1-1_all.deb ... 331s Unpacking cl-split-sequence (1:2.0.1-1) ... 331s Selecting previously unselected package cl-ppcre. 331s Preparing to unpack .../21-cl-ppcre_20240427.git80fb19d-1_all.deb ... 331s Unpacking cl-ppcre (20240427.git80fb19d-1) ... 331s Selecting previously unselected package cl-uax-15. 331s Preparing to unpack .../22-cl-uax-15_0~20240127.git2226aa3-1_all.deb ... 331s Unpacking cl-uax-15 (0~20240127.git2226aa3-1) ... 331s Selecting previously unselected package cl-usocket. 331s Preparing to unpack .../23-cl-usocket_0.8.8-3_all.deb ... 331s Unpacking cl-usocket (0.8.8-3) ... 331s Selecting previously unselected package cl-postgres. 331s Preparing to unpack .../24-cl-postgres_20211113.git9d4332f-5_all.deb ... 331s Unpacking cl-postgres (20211113.git9d4332f-5) ... 331s Selecting previously unselected package cl-s-sql. 331s Preparing to unpack .../25-cl-s-sql_20211113.git9d4332f-5_all.deb ... 331s Unpacking cl-s-sql (20211113.git9d4332f-5) ... 331s Selecting previously unselected package cl-postmodern. 331s Preparing to unpack .../26-cl-postmodern_20211113.git9d4332f-5_all.deb ... 331s Unpacking cl-postmodern (20211113.git9d4332f-5) ... 331s Selecting previously unselected package freetds-common. 331s Preparing to unpack .../27-freetds-common_1.3.17+ds-2build3_all.deb ... 331s Unpacking freetds-common (1.3.17+ds-2build3) ... 331s Selecting previously unselected package libct4:arm64. 331s Preparing to unpack .../28-libct4_1.3.17+ds-2build3_arm64.deb ... 331s Unpacking libct4:arm64 (1.3.17+ds-2build3) ... 331s Selecting previously unselected package libsybdb5:arm64. 331s Preparing to unpack .../29-libsybdb5_1.3.17+ds-2build3_arm64.deb ... 331s Unpacking libsybdb5:arm64 (1.3.17+ds-2build3) ... 331s Selecting previously unselected package freetds-dev. 331s Preparing to unpack .../30-freetds-dev_1.3.17+ds-2build3_arm64.deb ... 331s Unpacking freetds-dev (1.3.17+ds-2build3) ... 331s Selecting previously unselected package libllvm20:arm64. 331s Preparing to unpack .../31-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 331s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 332s Selecting previously unselected package libpq5:arm64. 332s Preparing to unpack .../32-libpq5_17.4-1_arm64.deb ... 332s Unpacking libpq5:arm64 (17.4-1) ... 332s Selecting previously unselected package libxslt1.1:arm64. 332s Preparing to unpack .../33-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 332s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 332s Selecting previously unselected package postgresql-client-17. 332s Preparing to unpack .../34-postgresql-client-17_17.4-1_arm64.deb ... 332s Unpacking postgresql-client-17 (17.4-1) ... 332s Selecting previously unselected package postgresql-17. 332s Preparing to unpack .../35-postgresql-17_17.4-1_arm64.deb ... 332s Unpacking postgresql-17 (17.4-1) ... 333s Selecting previously unselected package postgresql. 333s Preparing to unpack .../36-postgresql_17+274_all.deb ... 333s Unpacking postgresql (17+274) ... 333s Selecting previously unselected package pgloader. 333s Preparing to unpack .../37-pgloader_3.6.10-4_arm64.deb ... 333s Unpacking pgloader (3.6.10-4) ... 333s Setting up postgresql-client-common (274) ... 333s Setting up cl-trivial-garbage (20231018.git3474f64-1) ... 333s Setting up cl-closer-mop (2:20241031.git875f4b7-1) ... 333s Setting up libio-pty-perl (1:1.20-1build3) ... 333s Setting up libpq5:arm64 (17.4-1) ... 333s Setting up cl-trivial-features (20230607.gitd249a62-1) ... 333s Setting up cl-split-sequence (1:2.0.1-1) ... 333s Setting up cl-trivial-gray-streams (20240217.gita7ead68-1) ... 333s Setting up ssl-cert (1.1.3ubuntu1) ... 334s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 334s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 334s Setting up libipc-run-perl (20231003.0-2) ... 334s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 334s Setting up libjson-perl (4.10000-1) ... 334s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 334s Setting up cl-alexandria (20240125.git8514d8e-1) ... 334s Setting up cl-rt (20090812.gita6a7503-1) ... 334s Setting up freetds-common (1.3.17+ds-2build3) ... 334s Setting up cl-ppcre (20240427.git80fb19d-1) ... 334s Setting up postgresql-common-dev (274) ... 334s Setting up cl-flexi-streams (20240427.git4951d57-1) ... 334s Setting up cl-uax-15 (0~20240127.git2226aa3-1) ... 334s Setting up postgresql-client-17 (17.4-1) ... 335s 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 335s Setting up libsybdb5:arm64 (1.3.17+ds-2build3) ... 335s Setting up cl-bordeaux-threads (0.9.4-1) ... 335s Setting up libct4:arm64 (1.3.17+ds-2build3) ... 335s Setting up cl-kmrcl (1.111-2) ... 335s Setting up postgresql-common (274) ... 336s Creating config file /etc/postgresql-common/createcluster.conf with new version 336s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 336s Removing obsolete dictionary files: 337s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 337s Setting up cl-usocket (0.8.8-3) ... 337s Setting up cl-md5 (1:20210622.git906593f-1) ... 337s Setting up cl-base64 (3.4.0-1) ... 337s Setting up cl-ironclad (0.61-4) ... 337s Setting up postgresql-17 (17.4-1) ... 338s Creating new PostgreSQL cluster 17/main ... 338s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 338s The files belonging to this database system will be owned by user "postgres". 338s This user must also own the server process. 338s 338s The database cluster will be initialized with locale "C.UTF-8". 338s The default database encoding has accordingly been set to "UTF8". 338s The default text search configuration will be set to "english". 338s 338s Data page checksums are disabled. 338s 338s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 338s creating subdirectories ... ok 338s selecting dynamic shared memory implementation ... posix 338s selecting default "max_connections" ... 100 338s selecting default "shared_buffers" ... 128MB 338s selecting default time zone ... Etc/UTC 338s creating configuration files ... ok 338s running bootstrap script ... ok 339s performing post-bootstrap initialization ... ok 339s syncing data to disk ... ok 342s Setting up freetds-dev (1.3.17+ds-2build3) ... 342s Setting up pgloader (3.6.10-4) ... 342s Setting up cl-postgres (20211113.git9d4332f-5) ... 342s Setting up postgresql (17+274) ... 342s Setting up cl-s-sql (20211113.git9d4332f-5) ... 342s Setting up cl-postmodern (20211113.git9d4332f-5) ... 342s Processing triggers for man-db (2.13.0-1) ... 344s Processing triggers for install-info (7.1.1-1) ... 344s Processing triggers for libc-bin (2.41-1ubuntu2) ... 345s autopkgtest [14:22:28]: test ssl: [----------------------- 345s + trap rm -rf /tmp/pgloader EXIT 345s + dpkg-query --show --showformat=${Version} cl-postmodern 345s + postmodern=20211113.git9d4332f-5 345s + dpkg --compare-versions 20211113.git9d4332f-5 lt 20200101 345s + pg_virtualenv 345s Creating new PostgreSQL cluster 17/regress ... 349s ++ psql -XAtc 'SHOW hba_file' 349s + HBA=/etc/postgresql/17/regress/pg_hba.conf 349s + sed -i -e 's/^host/hostssl/' /etc/postgresql/17/regress/pg_hba.conf 349s + psql -XAtc 'SELECT pg_reload_conf()' 349s t 349s + createdb pgloader 349s + export PGDATABASE=pgloader 349s + PGDATABASE=pgloader 349s + psql -XAtc 'create schema expected' 349s CREATE SCHEMA 349s + rm -rf /tmp/pgloader 349s + PGHOST=/var/run/postgresql 349s + su -c 'pgloader --debug --regress test/allcols.load' postgres 350s mkdir -p #P"/tmp/pgloader/" 350s pgloader version 3.6.10~devel 350s compiled with SBCL 2.2.9.debian 350s sb-impl::*default-external-format* :UTF-8 350s tmpdir: #P"/tmp/pgloader/" 350s 2025-03-15T14:22:33.010000Z NOTICE Starting pgloader, log system is ready. 350s 2025-03-15T14:22:33.035000Z INFO Starting monitor 350s 2025-03-15T14:22:33.045000Z LOG pgloader version "3.6.10~devel" 350s 2025-03-15T14:22:33.142001Z INFO Parsed command: 350s /* 350s * This test is ported from pgloader 2.x where it was defined as: 350s * 350s * [allcols] 350s * table = allcols 350s * format = csv 350s * filename = allcols/allcols.data 350s * field_sep = : 350s * columns = * 350s * pg_option_work_mem = 14MB 350s * 350s */ 350s 350s LOAD CSV 350s FROM inline (a, b, c) 350s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 350s 350s WITH fields optionally enclosed by '"', 350s fields escaped by double-quote, 350s fields terminated by ':' 350s 350s SET client_encoding to 'latin1', 350s work_mem to '14MB', 350s standard_conforming_strings to 'on' 350s 350s BEFORE LOAD DO 350s $$ drop table if exists allcols; $$, 350s $$ create table allcols ( 350s a integer primary key, 350s b date, 350s c text 350s ); 350s $$; 350s 350s 350s 350s 350s 350s 2025-03-15T14:22:33.152000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 350s 2025-03-15T14:22:33.223000Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.223000Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.224000Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.224000Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.225000Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.246000Z NOTICE Executing SQL block for before load 350s 2025-03-15T14:22:33.263000Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.263000Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.264000Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.264000Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.264000Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.272000Z DEBUG BEGIN 350s 2025-03-15T14:22:33.272000Z SQL drop table if exists allcols; 350s 2025-03-15T14:22:33.273000Z SQL create table allcols ( 350s a integer primary key, 350s b date, 350s c text 350s ); 350s 2025-03-15T14:22:33.323001Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.324001Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.324001Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.324001Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.324001Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.352001Z SQL -- 350s -- get user defined SQL types 350s -- 350s select nt.nspname, 350s extname, 350s typname, 350s case when enum.enumtypid is not null 350s then array_agg(enum.enumlabel order by enumsortorder) 350s end as enumvalues 350s 350s from pg_class c 350s join pg_namespace n on n.oid = c.relnamespace 350s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 350s join pg_type t on t.oid = a.atttypid 350s left join pg_namespace nt on nt.oid = t.typnamespace 350s left join pg_depend d on d.classid = 'pg_type'::regclass 350s and d.refclassid = 'pg_extension'::regclass 350s and d.objid = t.oid 350s left join pg_extension e on refobjid = e.oid 350s left join pg_enum enum on enum.enumtypid = t.oid 350s 350s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 350s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and c.relkind in ('r', 'f', 'p') 350s and ((n.nspname = 'public' and c.relname = 'allcols')) 350s 350s and 350s ( t.typrelid = 0 350s or 350s (select c.relkind = 'c' 350s from pg_class c 350s where c.oid = t.typrelid) 350s ) 350s and not exists 350s ( 350s select 1 350s from pg_type el 350s where el.oid = t.typelem 350s and el.typarray = t.oid 350s ) 350s 350s group by nt.nspname, extname, typname, enumtypid 350s order by nt.nspname, extname, typname, enumtypid; 350s 2025-03-15T14:22:33.358001Z SQL -- params: table-type-name 350s -- including 350s -- filter-list-to-where-clause for including 350s -- excluding 350s -- filter-list-to-where-clause for excluding 350s with seqattr as 350s ( 350s select adrelid, 350s adnum, 350s pg_get_expr(d.adbin, d.adrelid) as adsrc, 350s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 350s then substring(pg_get_expr(d.adbin, d.adrelid) 350s from '''([^'']+)''' 350s ) 350s else null 350s end as seqname 350s from pg_attrdef d 350s ) 350s select nspname, relname, c.oid, attname, 350s t.oid::regtype as type, 350s case when atttypmod > 0 350s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 350s else null 350s end as typmod, 350s attnotnull, 350s case when atthasdef 350s then pg_get_expr(def.adbin, def.adrelid) 350s end as default , 350s case when s.seqname is not null then 'auto_increment' end as extra 350s from pg_class c 350s join pg_namespace n on n.oid = c.relnamespace 350s left join pg_attribute a on c.oid = a.attrelid 350s join pg_type t on t.oid = a.atttypid and attnum > 0 350s left join pg_attrdef def on a.attrelid = def.adrelid 350s and a.attnum = def.adnum 350s and a.atthasdef 350s left join seqattr s on def.adrelid = s.adrelid 350s and def.adnum = s.adnum 350s 350s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and relkind in ('r', 'f', 'p') 350s and ((n.nspname = 'public' and c.relname = 'allcols')) 350s 350s 350s order by nspname, relname, attnum; 350s 2025-03-15T14:22:33.409001Z SQL -- params: including 350s -- filter-list-to-where-clause for including 350s -- excluding 350s -- filter-list-to-where-clause for excluding 350s select n.nspname, 350s i.relname, 350s i.oid, 350s rn.nspname, 350s r.relname, 350s indisprimary, 350s indisunique, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.oid 350s and array[attnum::integer] <@ indkey::integer[] 350s ) as cols, 350s pg_get_indexdef(indexrelid), 350s c.conname, 350s pg_get_constraintdef(c.oid) 350s from pg_index x 350s join pg_class i ON i.oid = x.indexrelid 350s join pg_class r ON r.oid = x.indrelid 350s join pg_namespace n ON n.oid = i.relnamespace 350s join pg_namespace rn ON rn.oid = r.relnamespace 350s left join pg_depend d on d.classid = 'pg_class'::regclass 350s and d.objid = i.oid 350s and d.refclassid = 'pg_constraint'::regclass 350s and d.deptype = 'i' 350s left join pg_constraint c ON c.oid = d.refobjid 350s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and ((rn.nspname = 'public' and r.relname = 'allcols')) 350s 350s order by n.nspname, r.relname 350s 2025-03-15T14:22:33.433001Z SQL -- params: including (table) 350s -- filter-list-to-where-clause for including 350s -- excluding (table) 350s -- filter-list-to-where-clause for excluding 350s -- including (ftable) 350s -- filter-list-to-where-clause for including 350s -- excluding (ftable) 350s -- filter-list-to-where-clause for excluding 350s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 350s r.oid, 350s d.refobjid as pkeyoid, 350s conname, 350s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.conrelid 350s and array[attnum::integer] <@ conkey::integer[] 350s ) as conkey, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.confrelid 350s and array[attnum::integer] <@ confkey::integer[] 350s ) as confkey, 350s confupdtype, confdeltype, confmatchtype, 350s condeferrable, condeferred 350s from pg_catalog.pg_constraint r 350s JOIN pg_class c on r.conrelid = c.oid 350s JOIN pg_namespace n on c.relnamespace = n.oid 350s JOIN pg_class cf on r.confrelid = cf.oid 350s JOIN pg_namespace nf on cf.relnamespace = nf.oid 350s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 350s and d.objid = r.oid 350s and d.refobjsubid = 0 350s where r.contype = 'f' 350s AND c.relkind in ('r', 'f', 'p') 350s AND cf.relkind in ('r', 'f', 'p') 350s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 350s and ((n.nspname = 'public' and c.relname = 'allcols')) 350s 350s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 350s 350s 2025-03-15T14:22:33.443001Z SQL -- params pkey-oid-list 350s -- fkey-oild-list 350s with pkeys(oid) as ( 350s values(16391) 350s ), 350s knownfkeys(oid) as ( 350s values(-1) 350s ), 350s pkdeps as ( 350s select pkeys.oid, pg_depend.objid 350s from pg_depend 350s join pkeys on pg_depend.refobjid = pkeys.oid 350s where classid = 'pg_catalog.pg_constraint'::regclass 350s and refclassid = 'pg_catalog.pg_class'::regclass 350s ) 350s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 350s r.oid as conoid, conname, 350s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 350s pkdeps.oid as index_oid 350s from pg_catalog.pg_constraint r 350s JOIN pkdeps on r.oid = pkdeps.objid 350s JOIN pg_class c on r.conrelid = c.oid 350s JOIN pg_namespace n on c.relnamespace = n.oid 350s JOIN pg_class cf on r.confrelid = cf.oid 350s JOIN pg_namespace nf on cf.relnamespace = nf.oid 350s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 350s 2025-03-15T14:22:33.466001Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 350s 2025-03-15T14:22:33.476001Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 350s 2025-03-15T14:22:33.476001Z WARNING That could impact loading performance badly. 350s 2025-03-15T14:22:33.476001Z WARNING Consider the option 'drop indexes'. 350s 2025-03-15T14:22:33.539002Z NOTICE COPY "public"."allcols" with 0 rows estimated [0/4] 350s 2025-03-15T14:22:33.539002Z DEBUG Reader started for "public"."allcols" 350s 2025-03-15T14:22:33.550002Z DEBUG start "public"."allcols" 1390006 350s 2025-03-15T14:22:33.550002Z INFO COPY ON ERROR RESUME NEXT 350s 2025-03-15T14:22:33.554002Z NOTICE Opening (:INLINE 350s (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/allcols.load" . 765)) 350s 2025-03-15T14:22:33.559002Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.559002Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.559002Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.559002Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.559002Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.560002Z SQL SET search_path TO "public"; 350s 2025-03-15T14:22:33.560002Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 350s 2025-03-15T14:22:33.573002Z DEBUG Reader for "public"."allcols" is done in 0.033000s 350s 2025-03-15T14:22:33.574002Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.033000s 350s 2025-03-15T14:22:33.581002Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.006000s 350s 2025-03-15T14:22:33.581002Z DEBUG stop "public"."allcols" | 1390006 .. 1429006 = 0.039d0 350s 2025-03-15T14:22:33.581002Z DEBUG Writer[1] for "public"."allcols" is done in 0.006000s 350s 2025-03-15T14:22:33.581002Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.006000s 350s 2025-03-15T14:22:33.598002Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 350s 2025-03-15T14:22:33.614002Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.614002Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.615002Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.615002Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.616002Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.620002Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/allcols.out") 350s 2025-03-15T14:22:33.634002Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.635002Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.635002Z DEBUG SET work_mem TO '14MB' 350s 2025-03-15T14:22:33.635002Z DEBUG SET standard_conforming_strings TO 'on' 350s 2025-03-15T14:22:33.635002Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.636002Z NOTICE drop table if exists expected.allcols; 350s 2025-03-15T14:22:33.637002Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 350s 2025-03-15T14:22:33.637002Z NOTICE create table expected.allcols(like allcols); 350s 2025-03-15T14:22:33.641002Z DEBUG LOAD DATA FROM # 350s 2025-03-15T14:22:33.659002Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.659002Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.660002Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.687002Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.688002Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.688002Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.690002Z SQL -- 350s -- get user defined SQL types 350s -- 350s select nt.nspname, 350s extname, 350s typname, 350s case when enum.enumtypid is not null 350s then array_agg(enum.enumlabel order by enumsortorder) 350s end as enumvalues 350s 350s from pg_class c 350s join pg_namespace n on n.oid = c.relnamespace 350s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 350s join pg_type t on t.oid = a.atttypid 350s left join pg_namespace nt on nt.oid = t.typnamespace 350s left join pg_depend d on d.classid = 'pg_type'::regclass 350s and d.refclassid = 'pg_extension'::regclass 350s and d.objid = t.oid 350s left join pg_extension e on refobjid = e.oid 350s left join pg_enum enum on enum.enumtypid = t.oid 350s 350s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 350s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and c.relkind in ('r', 'f', 'p') 350s and ((n.nspname = 'expected' and c.relname = 'allcols')) 350s 350s and 350s ( t.typrelid = 0 350s or 350s (select c.relkind = 'c' 350s from pg_class c 350s where c.oid = t.typrelid) 350s ) 350s and not exists 350s ( 350s select 1 350s from pg_type el 350s where el.oid = t.typelem 350s and el.typarray = t.oid 350s ) 350s 350s group by nt.nspname, extname, typname, enumtypid 350s order by nt.nspname, extname, typname, enumtypid; 350s 2025-03-15T14:22:33.695002Z SQL -- params: table-type-name 350s -- including 350s -- filter-list-to-where-clause for including 350s -- excluding 350s -- filter-list-to-where-clause for excluding 350s with seqattr as 350s ( 350s select adrelid, 350s adnum, 350s pg_get_expr(d.adbin, d.adrelid) as adsrc, 350s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 350s then substring(pg_get_expr(d.adbin, d.adrelid) 350s from '''([^'']+)''' 350s ) 350s else null 350s end as seqname 350s from pg_attrdef d 350s ) 350s select nspname, relname, c.oid, attname, 350s t.oid::regtype as type, 350s case when atttypmod > 0 350s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 350s else null 350s end as typmod, 350s attnotnull, 350s case when atthasdef 350s then pg_get_expr(def.adbin, def.adrelid) 350s end as default , 350s case when s.seqname is not null then 'auto_increment' end as extra 350s from pg_class c 350s join pg_namespace n on n.oid = c.relnamespace 350s left join pg_attribute a on c.oid = a.attrelid 350s join pg_type t on t.oid = a.atttypid and attnum > 0 350s left join pg_attrdef def on a.attrelid = def.adrelid 350s and a.attnum = def.adnum 350s and a.atthasdef 350s left join seqattr s on def.adrelid = s.adrelid 350s and def.adnum = s.adnum 350s 350s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and relkind in ('r', 'f', 'p') 350s and ((n.nspname = 'expected' and c.relname = 'allcols')) 350s 350s 350s order by nspname, relname, attnum; 350s 2025-03-15T14:22:33.698002Z SQL -- params: including 350s -- filter-list-to-where-clause for including 350s -- excluding 350s -- filter-list-to-where-clause for excluding 350s select n.nspname, 350s i.relname, 350s i.oid, 350s rn.nspname, 350s r.relname, 350s indisprimary, 350s indisunique, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.oid 350s and array[attnum::integer] <@ indkey::integer[] 350s ) as cols, 350s pg_get_indexdef(indexrelid), 350s c.conname, 350s pg_get_constraintdef(c.oid) 350s from pg_index x 350s join pg_class i ON i.oid = x.indexrelid 350s join pg_class r ON r.oid = x.indrelid 350s join pg_namespace n ON n.oid = i.relnamespace 350s join pg_namespace rn ON rn.oid = r.relnamespace 350s left join pg_depend d on d.classid = 'pg_class'::regclass 350s and d.objid = i.oid 350s and d.refclassid = 'pg_constraint'::regclass 350s and d.deptype = 'i' 350s left join pg_constraint c ON c.oid = d.refobjid 350s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 350s 350s order by n.nspname, r.relname 350s 2025-03-15T14:22:33.701002Z SQL -- params: including (table) 350s -- filter-list-to-where-clause for including 350s -- excluding (table) 350s -- filter-list-to-where-clause for excluding 350s -- including (ftable) 350s -- filter-list-to-where-clause for including 350s -- excluding (ftable) 350s -- filter-list-to-where-clause for excluding 350s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 350s r.oid, 350s d.refobjid as pkeyoid, 350s conname, 350s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.conrelid 350s and array[attnum::integer] <@ conkey::integer[] 350s ) as conkey, 350s (select string_agg(attname, ',') 350s from pg_attribute 350s where attrelid = r.confrelid 350s and array[attnum::integer] <@ confkey::integer[] 350s ) as confkey, 350s confupdtype, confdeltype, confmatchtype, 350s condeferrable, condeferred 350s from pg_catalog.pg_constraint r 350s JOIN pg_class c on r.conrelid = c.oid 350s JOIN pg_namespace n on c.relnamespace = n.oid 350s JOIN pg_class cf on r.confrelid = cf.oid 350s JOIN pg_namespace nf on cf.relnamespace = nf.oid 350s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 350s and d.objid = r.oid 350s and d.refobjsubid = 0 350s where r.contype = 'f' 350s AND c.relkind in ('r', 'f', 'p') 350s AND cf.relkind in ('r', 'f', 'p') 350s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 350s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 350s and ((n.nspname = 'expected' and c.relname = 'allcols')) 350s 350s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 350s 350s 2025-03-15T14:22:33.703002Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 350s 2025-03-15T14:22:33.703002Z SQL TRUNCATE "expected"."allcols"; 350s 2025-03-15T14:22:33.733003Z NOTICE COPY "expected"."allcols" with 0 rows estimated [3/4] 350s 2025-03-15T14:22:33.734003Z DEBUG Reader started for "expected"."allcols" 350s 2025-03-15T14:22:33.734003Z DEBUG start "expected"."allcols" 1583007 350s 2025-03-15T14:22:33.734003Z NOTICE Opening #P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/allcols.out" 350s 2025-03-15T14:22:33.734003Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 350s 2025-03-15T14:22:33.734003Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 350s 2025-03-15T14:22:33.735003Z INFO COPY ON ERROR RESUME NEXT 350s 2025-03-15T14:22:33.750004Z DEBUG CONNECTED TO # 350s 2025-03-15T14:22:33.750004Z DEBUG SET client_encoding TO 'utf8' 350s 2025-03-15T14:22:33.750004Z DEBUG SET application_name TO 'pgloader' 350s 2025-03-15T14:22:33.751004Z SQL SET search_path TO "expected"; 350s 2025-03-15T14:22:33.751004Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 350s 2025-03-15T14:22:33.752004Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.001000s 350s 2025-03-15T14:22:33.752004Z DEBUG stop "expected"."allcols" | 1583007 .. 1602008 = 0.019001d0 350s 2025-03-15T14:22:33.752004Z DEBUG Writer[1] for "expected"."allcols" is done in 0.001000s 350s 2025-03-15T14:22:33.754004Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.001000s 350s 2025-03-15T14:22:33.754004Z LOG report summary reset 351s table name errors read imported bytes total time read write 351s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 351s fetch 0 0 0 0.011s 351s before load 0 2 2 0.031s 351s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 351s "public"."allcols" 0 8 8 0.2 kB 0.039s 0.033s 0.006s 351s "expected"."allcols" 0 8 8 0.2 kB 0.019s 0.001s 351s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 351s Files Processed 0 2 2 0.075s 351s COPY Threads Completion 0 4 4 0.061s 351s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 351s Total import time ✓ 16 16 0.4 kB 0.136s 351s 2025-03-15T14:22:33.799004Z DEBUG CONNECTED TO # 351s 2025-03-15T14:22:33.799004Z DEBUG SET client_encoding TO 'utf8' 351s 2025-03-15T14:22:33.799004Z DEBUG SET work_mem TO '14MB' 351s 2025-03-15T14:22:33.799004Z DEBUG SET standard_conforming_strings TO 'on' 351s 2025-03-15T14:22:33.799004Z DEBUG SET application_name TO 'pgloader' 351s 2025-03-15T14:22:33.799004Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 351s 2025-03-15T14:22:33.799004Z NOTICE Got a diff of 0 rows 351s 2025-03-15T14:22:33.799004Z LOG Regress pass. 351s 2025-03-15T14:22:33.799004Z INFO Stopping monitor 351s + rm -rf /tmp/pgloader 351s + PGSSLMODE=require 351s + pgloader --debug --regress test/allcols.load 351s mkdir -p #P"/tmp/pgloader/" 351s pgloader version 3.6.10~devel 351s compiled with SBCL 2.2.9.debian 351s sb-impl::*default-external-format* :UTF-8 351s tmpdir: #P"/tmp/pgloader/" 351s 2025-03-15T14:22:34.010000Z NOTICE Starting pgloader, log system is ready. 351s 2025-03-15T14:22:34.032000Z INFO Starting monitor 351s 2025-03-15T14:22:34.042000Z LOG pgloader version "3.6.10~devel" 351s 2025-03-15T14:22:34.139000Z INFO Parsed command: 351s /* 351s * This test is ported from pgloader 2.x where it was defined as: 351s * 351s * [allcols] 351s * table = allcols 351s * format = csv 351s * filename = allcols/allcols.data 351s * field_sep = : 351s * columns = * 351s * pg_option_work_mem = 14MB 351s * 351s */ 351s 351s LOAD CSV 351s FROM inline (a, b, c) 351s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 351s 351s WITH fields optionally enclosed by '"', 351s fields escaped by double-quote, 351s fields terminated by ':' 351s 351s SET client_encoding to 'latin1', 351s work_mem to '14MB', 351s standard_conforming_strings to 'on' 351s 351s BEFORE LOAD DO 351s $$ drop table if exists allcols; $$, 351s $$ create table allcols ( 351s a integer primary key, 351s b date, 351s c text 351s ); 351s $$; 351s 351s 351s 351s 351s 351s 2025-03-15T14:22:34.149000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 352s 2025-03-15T14:22:34.400001Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:34.400001Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:34.400001Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:34.400001Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:34.401001Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:34.449002Z NOTICE Executing SQL block for before load 352s 2025-03-15T14:22:34.564002Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:34.564002Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:34.564002Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:34.566002Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:34.566002Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:34.574002Z DEBUG BEGIN 352s 2025-03-15T14:22:34.575002Z SQL drop table if exists allcols; 352s 2025-03-15T14:22:34.577002Z SQL create table allcols ( 352s a integer primary key, 352s b date, 352s c text 352s ); 352s 2025-03-15T14:22:34.709003Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:34.709003Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:34.709003Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:34.710003Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:34.710003Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:34.725003Z SQL -- 352s -- get user defined SQL types 352s -- 352s select nt.nspname, 352s extname, 352s typname, 352s case when enum.enumtypid is not null 352s then array_agg(enum.enumlabel order by enumsortorder) 352s end as enumvalues 352s 352s from pg_class c 352s join pg_namespace n on n.oid = c.relnamespace 352s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 352s join pg_type t on t.oid = a.atttypid 352s left join pg_namespace nt on nt.oid = t.typnamespace 352s left join pg_depend d on d.classid = 'pg_type'::regclass 352s and d.refclassid = 'pg_extension'::regclass 352s and d.objid = t.oid 352s left join pg_extension e on refobjid = e.oid 352s left join pg_enum enum on enum.enumtypid = t.oid 352s 352s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 352s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 352s and c.relkind in ('r', 'f', 'p') 352s and ((n.nspname = 'public' and c.relname = 'allcols')) 352s 352s and 352s ( t.typrelid = 0 352s or 352s (select c.relkind = 'c' 352s from pg_class c 352s where c.oid = t.typrelid) 352s ) 352s and not exists 352s ( 352s select 1 352s from pg_type el 352s where el.oid = t.typelem 352s and el.typarray = t.oid 352s ) 352s 352s group by nt.nspname, extname, typname, enumtypid 352s order by nt.nspname, extname, typname, enumtypid; 352s 2025-03-15T14:22:34.732003Z SQL -- params: table-type-name 352s -- including 352s -- filter-list-to-where-clause for including 352s -- excluding 352s -- filter-list-to-where-clause for excluding 352s with seqattr as 352s ( 352s select adrelid, 352s adnum, 352s pg_get_expr(d.adbin, d.adrelid) as adsrc, 352s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 352s then substring(pg_get_expr(d.adbin, d.adrelid) 352s from '''([^'']+)''' 352s ) 352s else null 352s end as seqname 352s from pg_attrdef d 352s ) 352s select nspname, relname, c.oid, attname, 352s t.oid::regtype as type, 352s case when atttypmod > 0 352s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 352s else null 352s end as typmod, 352s attnotnull, 352s case when atthasdef 352s then pg_get_expr(def.adbin, def.adrelid) 352s end as default , 352s case when s.seqname is not null then 'auto_increment' end as extra 352s from pg_class c 352s join pg_namespace n on n.oid = c.relnamespace 352s left join pg_attribute a on c.oid = a.attrelid 352s join pg_type t on t.oid = a.atttypid and attnum > 0 352s left join pg_attrdef def on a.attrelid = def.adrelid 352s and a.attnum = def.adnum 352s and a.atthasdef 352s left join seqattr s on def.adrelid = s.adrelid 352s and def.adnum = s.adnum 352s 352s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 352s and relkind in ('r', 'f', 'p') 352s and ((n.nspname = 'public' and c.relname = 'allcols')) 352s 352s 352s order by nspname, relname, attnum; 352s 2025-03-15T14:22:34.754003Z SQL -- params: including 352s -- filter-list-to-where-clause for including 352s -- excluding 352s -- filter-list-to-where-clause for excluding 352s select n.nspname, 352s i.relname, 352s i.oid, 352s rn.nspname, 352s r.relname, 352s indisprimary, 352s indisunique, 352s (select string_agg(attname, ',') 352s from pg_attribute 352s where attrelid = r.oid 352s and array[attnum::integer] <@ indkey::integer[] 352s ) as cols, 352s pg_get_indexdef(indexrelid), 352s c.conname, 352s pg_get_constraintdef(c.oid) 352s from pg_index x 352s join pg_class i ON i.oid = x.indexrelid 352s join pg_class r ON r.oid = x.indrelid 352s join pg_namespace n ON n.oid = i.relnamespace 352s join pg_namespace rn ON rn.oid = r.relnamespace 352s left join pg_depend d on d.classid = 'pg_class'::regclass 352s and d.objid = i.oid 352s and d.refclassid = 'pg_constraint'::regclass 352s and d.deptype = 'i' 352s left join pg_constraint c ON c.oid = d.refobjid 352s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 352s and ((rn.nspname = 'public' and r.relname = 'allcols')) 352s 352s order by n.nspname, r.relname 352s 2025-03-15T14:22:34.765003Z SQL -- params: including (table) 352s -- filter-list-to-where-clause for including 352s -- excluding (table) 352s -- filter-list-to-where-clause for excluding 352s -- including (ftable) 352s -- filter-list-to-where-clause for including 352s -- excluding (ftable) 352s -- filter-list-to-where-clause for excluding 352s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 352s r.oid, 352s d.refobjid as pkeyoid, 352s conname, 352s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 352s (select string_agg(attname, ',') 352s from pg_attribute 352s where attrelid = r.conrelid 352s and array[attnum::integer] <@ conkey::integer[] 352s ) as conkey, 352s (select string_agg(attname, ',') 352s from pg_attribute 352s where attrelid = r.confrelid 352s and array[attnum::integer] <@ confkey::integer[] 352s ) as confkey, 352s confupdtype, confdeltype, confmatchtype, 352s condeferrable, condeferred 352s from pg_catalog.pg_constraint r 352s JOIN pg_class c on r.conrelid = c.oid 352s JOIN pg_namespace n on c.relnamespace = n.oid 352s JOIN pg_class cf on r.confrelid = cf.oid 352s JOIN pg_namespace nf on cf.relnamespace = nf.oid 352s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 352s and d.objid = r.oid 352s and d.refobjsubid = 0 352s where r.contype = 'f' 352s AND c.relkind in ('r', 'f', 'p') 352s AND cf.relkind in ('r', 'f', 'p') 352s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 352s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 352s and ((n.nspname = 'public' and c.relname = 'allcols')) 352s 352s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 352s 352s 2025-03-15T14:22:34.771003Z SQL -- params pkey-oid-list 352s -- fkey-oild-list 352s with pkeys(oid) as ( 352s values(16406) 352s ), 352s knownfkeys(oid) as ( 352s values(-1) 352s ), 352s pkdeps as ( 352s select pkeys.oid, pg_depend.objid 352s from pg_depend 352s join pkeys on pg_depend.refobjid = pkeys.oid 352s where classid = 'pg_catalog.pg_constraint'::regclass 352s and refclassid = 'pg_catalog.pg_class'::regclass 352s ) 352s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 352s r.oid as conoid, conname, 352s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 352s pkdeps.oid as index_oid 352s from pg_catalog.pg_constraint r 352s JOIN pkdeps on r.oid = pkdeps.objid 352s JOIN pg_class c on r.conrelid = c.oid 352s JOIN pg_namespace n on c.relnamespace = n.oid 352s JOIN pg_class cf on r.confrelid = cf.oid 352s JOIN pg_namespace nf on cf.relnamespace = nf.oid 352s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 352s 2025-03-15T14:22:34.781003Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 352s 2025-03-15T14:22:34.785003Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 352s 2025-03-15T14:22:34.785003Z WARNING That could impact loading performance badly. 352s 2025-03-15T14:22:34.785003Z WARNING Consider the option 'drop indexes'. 352s 2025-03-15T14:22:34.829003Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 352s 2025-03-15T14:22:34.829003Z DEBUG Reader started for "public"."allcols" 352s 2025-03-15T14:22:34.847003Z DEBUG start "public"."allcols" 1571006 352s 2025-03-15T14:22:34.849003Z NOTICE Opening (:INLINE 352s (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/allcols.load" . 765)) 352s 2025-03-15T14:22:34.849003Z INFO COPY ON ERROR RESUME NEXT 352s 2025-03-15T14:22:34.851003Z DEBUG Reader for "public"."allcols" is done in 0.021000s 352s 2025-03-15T14:22:34.851003Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.021000s 352s 2025-03-15T14:22:34.935004Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:34.935004Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:34.935004Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:34.935004Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:34.935004Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:34.936004Z SQL SET search_path TO "public"; 352s 2025-03-15T14:22:34.937004Z INFO pgsql:copy-rows-from-queue[0]: "public"."allcols" ("a" "b" "c") 352s 2025-03-15T14:22:34.942004Z DEBUG send-batch[0] "public"."allcols" 8 rows [ 0.2 kB] in 0.005000s 352s 2025-03-15T14:22:34.944004Z DEBUG stop "public"."allcols" | 1571006 .. 1686007 = 0.115001d0 352s 2025-03-15T14:22:34.944004Z DEBUG Writer[0] for "public"."allcols" is done in 0.006000s 352s 2025-03-15T14:22:34.944004Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.006000s 352s 2025-03-15T14:22:34.963004Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 352s 2025-03-15T14:22:35.066004Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:35.066004Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:35.067004Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:35.067004Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:35.068004Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:35.074004Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/allcols.out") 352s 2025-03-15T14:22:35.157005Z DEBUG CONNECTED TO # 352s 2025-03-15T14:22:35.157005Z DEBUG SET client_encoding TO 'utf8' 352s 2025-03-15T14:22:35.158005Z DEBUG SET work_mem TO '14MB' 352s 2025-03-15T14:22:35.159005Z DEBUG SET standard_conforming_strings TO 'on' 352s 2025-03-15T14:22:35.159005Z DEBUG SET application_name TO 'pgloader' 352s 2025-03-15T14:22:35.160005Z NOTICE drop table if exists expected.allcols; 352s 2025-03-15T14:22:35.162005Z NOTICE create table expected.allcols(like allcols); 352s 2025-03-15T14:22:35.171005Z DEBUG LOAD DATA FROM # 353s 2025-03-15T14:22:35.258005Z DEBUG CONNECTED TO # 353s 2025-03-15T14:22:35.258005Z DEBUG SET client_encoding TO 'utf8' 353s 2025-03-15T14:22:35.258005Z DEBUG SET application_name TO 'pgloader' 353s 2025-03-15T14:22:35.368006Z DEBUG CONNECTED TO # 353s 2025-03-15T14:22:35.368006Z DEBUG SET client_encoding TO 'utf8' 353s 2025-03-15T14:22:35.368006Z DEBUG SET application_name TO 'pgloader' 353s 2025-03-15T14:22:35.370006Z SQL -- 353s -- get user defined SQL types 353s -- 353s select nt.nspname, 353s extname, 353s typname, 353s case when enum.enumtypid is not null 353s then array_agg(enum.enumlabel order by enumsortorder) 353s end as enumvalues 353s 353s from pg_class c 353s join pg_namespace n on n.oid = c.relnamespace 353s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 353s join pg_type t on t.oid = a.atttypid 353s left join pg_namespace nt on nt.oid = t.typnamespace 353s left join pg_depend d on d.classid = 'pg_type'::regclass 353s and d.refclassid = 'pg_extension'::regclass 353s and d.objid = t.oid 353s left join pg_extension e on refobjid = e.oid 353s left join pg_enum enum on enum.enumtypid = t.oid 353s 353s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 353s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 353s and c.relkind in ('r', 'f', 'p') 353s and ((n.nspname = 'expected' and c.relname = 'allcols')) 353s 353s and 353s ( t.typrelid = 0 353s or 353s (select c.relkind = 'c' 353s from pg_class c 353s where c.oid = t.typrelid) 353s ) 353s and not exists 353s ( 353s select 1 353s from pg_type el 353s where el.oid = t.typelem 353s and el.typarray = t.oid 353s ) 353s 353s group by nt.nspname, extname, typname, enumtypid 353s order by nt.nspname, extname, typname, enumtypid; 353s 2025-03-15T14:22:35.375006Z SQL -- params: table-type-name 353s -- including 353s -- filter-list-to-where-clause for including 353s -- excluding 353s -- filter-list-to-where-clause for excluding 353s with seqattr as 353s ( 353s select adrelid, 353s adnum, 353s pg_get_expr(d.adbin, d.adrelid) as adsrc, 353s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 353s then substring(pg_get_expr(d.adbin, d.adrelid) 353s from '''([^'']+)''' 353s ) 353s else null 353s end as seqname 353s from pg_attrdef d 353s ) 353s select nspname, relname, c.oid, attname, 353s t.oid::regtype as type, 353s case when atttypmod > 0 353s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 353s else null 353s end as typmod, 353s attnotnull, 353s case when atthasdef 353s then pg_get_expr(def.adbin, def.adrelid) 353s end as default , 353s case when s.seqname is not null then 'auto_increment' end as extra 353s from pg_class c 353s join pg_namespace n on n.oid = c.relnamespace 353s left join pg_attribute a on c.oid = a.attrelid 353s join pg_type t on t.oid = a.atttypid and attnum > 0 353s left join pg_attrdef def on a.attrelid = def.adrelid 353s and a.attnum = def.adnum 353s and a.atthasdef 353s left join seqattr s on def.adrelid = s.adrelid 353s and def.adnum = s.adnum 353s 353s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 353s and relkind in ('r', 'f', 'p') 353s and ((n.nspname = 'expected' and c.relname = 'allcols')) 353s 353s 353s order by nspname, relname, attnum; 353s 2025-03-15T14:22:35.380006Z SQL -- params: including 353s -- filter-list-to-where-clause for including 353s -- excluding 353s -- filter-list-to-where-clause for excluding 353s select n.nspname, 353s i.relname, 353s i.oid, 353s rn.nspname, 353s r.relname, 353s indisprimary, 353s indisunique, 353s (select string_agg(attname, ',') 353s from pg_attribute 353s where attrelid = r.oid 353s and array[attnum::integer] <@ indkey::integer[] 353s ) as cols, 353s pg_get_indexdef(indexrelid), 353s c.conname, 353s pg_get_constraintdef(c.oid) 353s from pg_index x 353s join pg_class i ON i.oid = x.indexrelid 353s join pg_class r ON r.oid = x.indrelid 353s join pg_namespace n ON n.oid = i.relnamespace 353s join pg_namespace rn ON rn.oid = r.relnamespace 353s left join pg_depend d on d.classid = 'pg_class'::regclass 353s and d.objid = i.oid 353s and d.refclassid = 'pg_constraint'::regclass 353s and d.deptype = 'i' 353s left join pg_constraint c ON c.oid = d.refobjid 353s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 353s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 353s 353s order by n.nspname, r.relname 353s 2025-03-15T14:22:35.382006Z SQL -- params: including (table) 353s -- filter-list-to-where-clause for including 353s -- excluding (table) 353s -- filter-list-to-where-clause for excluding 353s -- including (ftable) 353s -- filter-list-to-where-clause for including 353s -- excluding (ftable) 353s -- filter-list-to-where-clause for excluding 353s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 353s r.oid, 353s d.refobjid as pkeyoid, 353s conname, 353s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 353s (select string_agg(attname, ',') 353s from pg_attribute 353s where attrelid = r.conrelid 353s and array[attnum::integer] <@ conkey::integer[] 353s ) as conkey, 353s (select string_agg(attname, ',') 353s from pg_attribute 353s where attrelid = r.confrelid 353s and array[attnum::integer] <@ confkey::integer[] 353s ) as confkey, 353s confupdtype, confdeltype, confmatchtype, 353s condeferrable, condeferred 353s from pg_catalog.pg_constraint r 353s JOIN pg_class c on r.conrelid = c.oid 353s JOIN pg_namespace n on c.relnamespace = n.oid 353s JOIN pg_class cf on r.confrelid = cf.oid 353s JOIN pg_namespace nf on cf.relnamespace = nf.oid 353s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 353s and d.objid = r.oid 353s and d.refobjsubid = 0 353s where r.contype = 'f' 353s AND c.relkind in ('r', 'f', 'p') 353s AND cf.relkind in ('r', 'f', 'p') 353s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 353s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 353s and ((n.nspname = 'expected' and c.relname = 'allcols')) 353s 353s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 353s 353s 2025-03-15T14:22:35.385006Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 353s 2025-03-15T14:22:35.385006Z SQL TRUNCATE "expected"."allcols"; 353s 2025-03-15T14:22:35.413006Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 353s 2025-03-15T14:22:35.413006Z DEBUG Reader started for "expected"."allcols" 353s 2025-03-15T14:22:35.413006Z DEBUG start "expected"."allcols" 2155009 353s 2025-03-15T14:22:35.413006Z NOTICE Opening #P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/allcols.out" 353s 2025-03-15T14:22:35.413006Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 353s 2025-03-15T14:22:35.415006Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 353s 2025-03-15T14:22:35.415006Z INFO COPY ON ERROR RESUME NEXT 353s 2025-03-15T14:22:35.501006Z DEBUG CONNECTED TO # 353s 2025-03-15T14:22:35.501006Z DEBUG SET client_encoding TO 'utf8' 353s 2025-03-15T14:22:35.501006Z DEBUG SET application_name TO 'pgloader' 353s 2025-03-15T14:22:35.502006Z SQL SET search_path TO "expected"; 353s 2025-03-15T14:22:35.503006Z INFO pgsql:copy-rows-from-queue[3]: "expected"."allcols" ("a" "b" "c") 353s 2025-03-15T14:22:35.504006Z DEBUG send-batch[3] "expected"."allcols" 8 rows [ 0.2 kB] in 0.001000s 353s 2025-03-15T14:22:35.505006Z DEBUG stop "expected"."allcols" | 2155009 .. 2247009 = 0.092d0 353s 2025-03-15T14:22:35.505006Z DEBUG Writer[3] for "expected"."allcols" is done in 0.002000s 353s 2025-03-15T14:22:35.506006Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.002000s 353s 2025-03-15T14:22:35.508006Z LOG report summary reset 353s table name errors read imported bytes total time read write 353s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 353s fetch 0 0 0 0.012s 353s before load 0 2 2 0.134s 353s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 353s "public"."allcols" 0 8 8 0.2 kB 0.115s 0.021s 0.006s 353s "expected"."allcols" 0 8 8 0.2 kB 0.092s 0.002s 353s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 353s Files Processed 0 2 2 0.049s 353s COPY Threads Completion 0 4 4 0.210s 353s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 353s Total import time ✓ 16 16 0.4 kB 0.259s 353s 2025-03-15T14:22:35.592007Z DEBUG CONNECTED TO # 353s 2025-03-15T14:22:35.592007Z DEBUG SET client_encoding TO 'utf8' 353s 2025-03-15T14:22:35.592007Z DEBUG SET work_mem TO '14MB' 353s 2025-03-15T14:22:35.593007Z DEBUG SET standard_conforming_strings TO 'on' 353s 2025-03-15T14:22:35.593007Z DEBUG SET application_name TO 'pgloader' 353s 2025-03-15T14:22:35.600007Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 353s 2025-03-15T14:22:35.600007Z NOTICE Got a diff of 0 rows 353s 2025-03-15T14:22:35.600007Z LOG Regress pass. 353s 2025-03-15T14:22:35.600007Z INFO Stopping monitor 353s Dropping cluster 17/regress ... 354s + rm -rf /tmp/pgloader 355s autopkgtest [14:22:38]: test ssl: -----------------------] 355s ssl PASS 355s autopkgtest [14:22:38]: test ssl: - - - - - - - - - - results - - - - - - - - - - 356s autopkgtest [14:22:39]: test testsuite: preparing testbed 534s autopkgtest [14:25:37]: testbed dpkg architecture: arm64 534s autopkgtest [14:25:37]: testbed apt version: 2.9.33 534s autopkgtest [14:25:37]: @@@@@@@@@@@@@@@@@@@@ test bed setup 535s autopkgtest [14:25:38]: testbed release detected to be: plucky 535s autopkgtest [14:25:38]: updating testbed package index (apt update) 536s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 536s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 536s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 536s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 536s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 537s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 537s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 537s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 537s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 537s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 537s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 537s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 537s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 537s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 538s Fetched 1094 kB in 2s (715 kB/s) 539s Reading package lists... 540s Reading package lists... 541s Building dependency tree... 541s Reading state information... 542s Calculating upgrade... 542s Calculating upgrade... 542s The following packages will be upgraded: 542s python3-jinja2 strace 543s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 543s Need to get 608 kB of archives. 543s After this operation, 11.3 kB of additional disk space will be used. 543s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 543s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 544s Fetched 608 kB in 1s (595 kB/s) 544s (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 ... 117701 files and directories currently installed.) 544s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 544s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 545s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 545s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 545s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 545s Setting up strace (6.13+ds-1ubuntu1) ... 545s Processing triggers for man-db (2.13.0-1) ... 546s Reading package lists... 546s Building dependency tree... 546s Reading state information... 547s Solving dependencies... 547s The following packages will be REMOVED: 547s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 547s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 547s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 547s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 547s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 547s After this operation, 267 MB disk space will be freed. 548s (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 ... 117701 files and directories currently installed.) 548s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 548s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 548s Removing libpython3.12t64:arm64 (3.12.9-1) ... 548s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 548s Removing libnsl2:arm64 (1.3.0-3build3) ... 548s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 548s Removing libunwind8:arm64 (1.6.2-3.1) ... 548s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 548s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 550s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 550s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 550s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 550s /etc/kernel/postrm.d/initramfs-tools: 550s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 551s /etc/kernel/postrm.d/zz-flash-kernel: 551s flash-kernel: Kernel 6.11.0-8-generic has been removed. 551s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 551s /etc/kernel/postrm.d/zz-update-grub: 551s Sourcing file `/etc/default/grub' 551s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 551s Generating grub configuration file ... 551s Found linux image: /boot/vmlinuz-6.14.0-10-generic 551s Found initrd image: /boot/initrd.img-6.14.0-10-generic 552s Warning: os-prober will not be executed to detect other bootable partitions. 552s Systems on them will not be added to the GRUB boot configuration. 552s Check GRUB_DISABLE_OS_PROBER documentation entry. 552s Adding boot menu entry for UEFI Firmware Settings ... 552s done 552s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 552s Processing triggers for libc-bin (2.41-1ubuntu1) ... 552s (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 ... 81650 files and directories currently installed.) 552s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 552s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 552s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 552s autopkgtest [14:25:55]: upgrading testbed (apt dist-upgrade and autopurge) 553s Reading package lists... 553s Building dependency tree... 553s Reading state information... 554s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 554s Starting 2 pkgProblemResolver with broken count: 0 554s Done 555s Entering ResolveByKeep 555s 555s Calculating upgrade... 556s The following packages will be upgraded: 556s libc-bin libc-dev-bin libc6 libc6-dev locales 556s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 556s Need to get 9530 kB of archives. 556s After this operation, 0 B of additional disk space will be used. 556s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 558s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 558s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 561s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 562s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 566s Preconfiguring packages ... 566s Fetched 9530 kB in 9s (1006 kB/s) 566s (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 ... 81647 files and directories currently installed.) 566s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 566s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 566s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 566s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 566s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 567s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 567s Setting up libc6:arm64 (2.41-1ubuntu2) ... 567s (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 ... 81647 files and directories currently installed.) 567s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 567s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 567s Setting up libc-bin (2.41-1ubuntu2) ... 567s (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 ... 81647 files and directories currently installed.) 567s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 567s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 568s Setting up locales (2.41-1ubuntu2) ... 569s Generating locales (this might take a while)... 571s en_US.UTF-8... done 571s Generation complete. 571s Setting up libc-dev-bin (2.41-1ubuntu2) ... 571s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 571s Processing triggers for man-db (2.13.0-1) ... 572s Processing triggers for systemd (257.3-1ubuntu3) ... 573s Reading package lists... 573s Building dependency tree... 573s Reading state information... 574s Starting pkgProblemResolver with broken count: 0 574s Starting 2 pkgProblemResolver with broken count: 0 574s Done 574s Solving dependencies... 575s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 575s autopkgtest [14:26:18]: rebooting testbed after setup commands that affected boot 602s Reading package lists... 603s Building dependency tree... 603s Reading state information... 603s Starting pkgProblemResolver with broken count: 0 603s Starting 2 pkgProblemResolver with broken count: 0 603s Done 604s The following NEW packages will be installed: 604s freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 604s libjson-perl libllvm20 libpq5 libsybdb5 libxslt1.1 pgloader postgresql-17 604s postgresql-17-ip4r postgresql-client-17 postgresql-client-common 604s postgresql-common postgresql-common-dev ssl-cert 604s 0 upgraded, 18 newly installed, 0 to remove and 0 not upgraded. 604s Need to get 73.3 MB of archives. 604s After this operation, 229 MB of additional disk space will be used. 604s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 604s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 604s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 604s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 604s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 604s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 604s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 605s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 605s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libct4 arm64 1.3.17+ds-2build3 [163 kB] 605s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libsybdb5 arm64 1.3.17+ds-2build3 [186 kB] 605s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-dev arm64 1.3.17+ds-2build3 [300 kB] 605s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 630s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 630s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 630s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 631s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 642s Get:17 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-ip4r arm64 2.4.2-3 [190 kB] 642s Get:18 http://ftpmaster.internal/ubuntu plucky/universe arm64 pgloader arm64 3.6.10-4 [25.6 MB] 656s Preconfiguring packages ... 657s Fetched 73.3 MB in 52s (1403 kB/s) 657s Selecting previously unselected package libjson-perl. 657s (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 ... 81647 files and directories currently installed.) 657s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 657s Unpacking libjson-perl (4.10000-1) ... 657s Selecting previously unselected package postgresql-client-common. 657s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 657s Unpacking postgresql-client-common (274) ... 657s Selecting previously unselected package libio-pty-perl. 657s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 657s Unpacking libio-pty-perl (1:1.20-1build3) ... 657s Selecting previously unselected package libipc-run-perl. 657s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 657s Unpacking libipc-run-perl (20231003.0-2) ... 657s Selecting previously unselected package postgresql-common-dev. 657s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 657s Unpacking postgresql-common-dev (274) ... 657s Selecting previously unselected package ssl-cert. 657s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 657s Unpacking ssl-cert (1.1.3ubuntu1) ... 657s Selecting previously unselected package postgresql-common. 657s Preparing to unpack .../06-postgresql-common_274_all.deb ... 657s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 657s Unpacking postgresql-common (274) ... 657s Selecting previously unselected package freetds-common. 657s Preparing to unpack .../07-freetds-common_1.3.17+ds-2build3_all.deb ... 657s Unpacking freetds-common (1.3.17+ds-2build3) ... 657s Selecting previously unselected package libct4:arm64. 657s Preparing to unpack .../08-libct4_1.3.17+ds-2build3_arm64.deb ... 657s Unpacking libct4:arm64 (1.3.17+ds-2build3) ... 657s Selecting previously unselected package libsybdb5:arm64. 657s Preparing to unpack .../09-libsybdb5_1.3.17+ds-2build3_arm64.deb ... 657s Unpacking libsybdb5:arm64 (1.3.17+ds-2build3) ... 657s Selecting previously unselected package freetds-dev. 657s Preparing to unpack .../10-freetds-dev_1.3.17+ds-2build3_arm64.deb ... 657s Unpacking freetds-dev (1.3.17+ds-2build3) ... 657s Selecting previously unselected package libllvm20:arm64. 657s Preparing to unpack .../11-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 657s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 658s Selecting previously unselected package libpq5:arm64. 658s Preparing to unpack .../12-libpq5_17.4-1_arm64.deb ... 658s Unpacking libpq5:arm64 (17.4-1) ... 658s Selecting previously unselected package libxslt1.1:arm64. 658s Preparing to unpack .../13-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 658s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 658s Selecting previously unselected package postgresql-client-17. 658s Preparing to unpack .../14-postgresql-client-17_17.4-1_arm64.deb ... 658s Unpacking postgresql-client-17 (17.4-1) ... 658s Selecting previously unselected package postgresql-17. 658s Preparing to unpack .../15-postgresql-17_17.4-1_arm64.deb ... 658s Unpacking postgresql-17 (17.4-1) ... 659s Selecting previously unselected package postgresql-17-ip4r. 659s Preparing to unpack .../16-postgresql-17-ip4r_2.4.2-3_arm64.deb ... 659s Unpacking postgresql-17-ip4r (2.4.2-3) ... 659s Selecting previously unselected package pgloader. 659s Preparing to unpack .../17-pgloader_3.6.10-4_arm64.deb ... 659s Unpacking pgloader (3.6.10-4) ... 659s Setting up postgresql-client-common (274) ... 659s Setting up libio-pty-perl (1:1.20-1build3) ... 659s Setting up libpq5:arm64 (17.4-1) ... 659s Setting up ssl-cert (1.1.3ubuntu1) ... 659s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 660s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 660s Setting up libipc-run-perl (20231003.0-2) ... 660s Setting up libjson-perl (4.10000-1) ... 660s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 660s Setting up freetds-common (1.3.17+ds-2build3) ... 660s Setting up postgresql-common-dev (274) ... 660s Setting up postgresql-client-17 (17.4-1) ... 660s 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 660s Setting up libsybdb5:arm64 (1.3.17+ds-2build3) ... 660s Setting up libct4:arm64 (1.3.17+ds-2build3) ... 660s Setting up postgresql-common (274) ... 661s Creating config file /etc/postgresql-common/createcluster.conf with new version 661s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 661s Removing obsolete dictionary files: 661s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 662s Setting up postgresql-17 (17.4-1) ... 663s Creating new PostgreSQL cluster 17/main ... 663s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 663s The files belonging to this database system will be owned by user "postgres". 663s This user must also own the server process. 663s 663s The database cluster will be initialized with locale "C.UTF-8". 663s The default database encoding has accordingly been set to "UTF8". 663s The default text search configuration will be set to "english". 663s 663s Data page checksums are disabled. 663s 663s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 663s creating subdirectories ... ok 663s selecting dynamic shared memory implementation ... posix 663s selecting default "max_connections" ... 100 663s selecting default "shared_buffers" ... 128MB 663s selecting default time zone ... Etc/UTC 663s creating configuration files ... ok 663s running bootstrap script ... ok 664s performing post-bootstrap initialization ... ok 664s syncing data to disk ... ok 667s Setting up freetds-dev (1.3.17+ds-2build3) ... 667s Setting up postgresql-17-ip4r (2.4.2-3) ... 667s Setting up pgloader (3.6.10-4) ... 667s Processing triggers for man-db (2.13.0-1) ... 668s Processing triggers for libc-bin (2.41-1ubuntu2) ... 672s autopkgtest [14:27:55]: test testsuite: [----------------------- 673s + PGSUPERUSER=ubuntu 673s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 673s Creating new PostgreSQL cluster 17/regress ... 676s make: Entering directory '/tmp/autopkgtest.Z8pY72/build.Yph/src/test' 676s dropdb -U ubuntu pgloader 676s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 676s make: [Makefile:67: prepare] Error 1 (ignored) 676s dropdb -U ubuntu stocks 676s dropdb: error: database removal failed: ERROR: database "stocks" does not exist 676s make: [Makefile:68: prepare] Error 1 (ignored) 676s dropdb -U ubuntu ip4r 676s createuser -U ubuntu --superuser `whoami` 676s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 676s make: [Makefile:69: prepare] Error 1 (ignored) 677s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 677s make: [Makefile:70: prepare] Error 1 (ignored) 677s createdb -U ubuntu -O `whoami` pgloader 677s createdb -U ubuntu -O `whoami` stocks 677s createdb -U ubuntu -O `whoami` ip4r 677s psql -d pgloader -c 'create schema expected' 677s CREATE SCHEMA 677s psql -U ubuntu -d pgloader -c 'create extension ip4r' 677s CREATE EXTENSION 677s psql -U ubuntu -d ip4r -c 'create extension ip4r' 677s CREATE EXTENSION 677s psql -d stocks -f bossa.sql 677s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 677s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 677s DROP TABLE 677s CREATE TABLE 677s CREATE TABLE 677s rm -f regress/out/* 677s pgloader --regress allcols.load 678s 2025-03-15T14:28:01.044994Z LOG pgloader version "3.6.10~devel" 678s 2025-03-15T14:28:01.151978Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 679s 2025-03-15T14:28:01.501933Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 679s 2025-03-15T14:28:01.501933Z WARNING That could impact loading performance badly. 679s 2025-03-15T14:28:01.503933Z WARNING Consider the option 'drop indexes'. 679s 2025-03-15T14:28:01.633917Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 679s 2025-03-15T14:28:01.656914Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/allcols.out") 679s 2025-03-15T14:28:01.672912Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 679s 2025-03-15T14:28:01.785898Z LOG report summary reset 679s table name errors rows bytes total time 679s ----------------------- --------- --------- --------- -------------- 679s fetch 0 0 0.012s 679s before load 0 2 0.029s 679s ----------------------- --------- --------- --------- -------------- 679s "public"."allcols" 0 8 0.2 kB 0.048s 679s "expected"."allcols" 0 8 0.2 kB 0.020s 679s ----------------------- --------- --------- --------- -------------- 679s Files Processed 0 2 0.075s 679s COPY Threads Completion 0 4 0.071s 679s ----------------------- --------- --------- --------- -------------- 679s Total import time ✓ 16 0.4 kB 0.146s 679s 2025-03-15T14:28:01.869888Z LOG Regress pass. 679s touch regress/out/allcols.out 679s pgloader --regress csv-before-after.load 680s 2025-03-15T14:28:03.057994Z LOG pgloader version "3.6.10~devel" 681s 2025-03-15T14:28:04.000885Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-before-after.out") 681s 2025-03-15T14:28:04.025882Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 681s 2025-03-15T14:28:04.203864Z LOG report summary reset 681s table name errors rows bytes total time 681s ----------------------- --------- --------- --------- -------------- 681s fetch 0 0 0.010s 681s before load 0 6 0.035s 681s ----------------------- --------- --------- --------- -------------- 681s "csv"."blocks" 0 460 15.9 kB 0.196s 681s "expected"."blocks" 0 460 12.4 kB 0.073s 681s ----------------------- --------- --------- --------- -------------- 681s Files Processed 0 2 0.115s 681s COPY Threads Completion 0 4 0.270s 681s after load 0 1 0.030s 681s ----------------------- --------- --------- --------- -------------- 681s Total import time ✓ 920 28.2 kB 0.415s 681s 2025-03-15T14:28:04.246859Z LOG Regress pass. 681s touch regress/out/csv-before-after.out 681s pgloader --regress csv-districts.load 682s 2025-03-15T14:28:05.069994Z LOG pgloader version "3.6.10~devel" 683s 2025-03-15T14:28:05.814918Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-districts.out") 683s 2025-03-15T14:28:05.828916Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 683s 2025-03-15T14:28:06.008899Z LOG report summary reset 683s table name errors rows bytes total time 683s ----------------------- --------- --------- --------- -------------- 683s fetch 0 0 0.011s 683s before load 0 2 0.025s 683s ----------------------- --------- --------- --------- -------------- 683s "public"."districts" 0 440 29.3 kB 0.220s 683s "expected"."districts" 0 440 29.1 kB 0.068s 683s ----------------------- --------- --------- --------- -------------- 683s Files Processed 0 2 0.087s 683s COPY Threads Completion 0 4 0.289s 683s ----------------------- --------- --------- --------- -------------- 683s Total import time ✓ 880 58.3 kB 0.376s 683s 2025-03-15T14:28:06.091892Z LOG Regress pass. 683s touch regress/out/csv-districts.out 683s pgloader --regress csv-parse-date.load 684s 2025-03-15T14:28:07.027997Z LOG pgloader version "3.6.10~devel" 684s 2025-03-15T14:28:07.650941Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-parse-date.out") 684s 2025-03-15T14:28:07.666939Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 685s 2025-03-15T14:28:07.776930Z LOG report summary reset 685s table name errors rows bytes total time 685s ----------------------- --------- --------- --------- -------------- 685s fetch 0 0 0.013s 685s before load 0 2 0.031s 685s ----------------------- --------- --------- --------- -------------- 685s "public"."dateformat" 0 4 0.1 kB 0.059s 685s "expected"."dateformat" 0 4 0.1 kB 0.019s 685s ----------------------- --------- --------- --------- -------------- 685s Files Processed 0 2 0.074s 685s COPY Threads Completion 0 4 0.081s 685s ----------------------- --------- --------- --------- -------------- 685s Total import time ✓ 8 0.3 kB 0.155s 685s 2025-03-15T14:28:07.817926Z LOG Regress pass. 685s touch regress/out/csv-parse-date.out 685s pgloader --regress csv-error.load 685s 2025-03-15T14:28:08.026998Z LOG pgloader version "3.6.10~devel" 686s 2025-03-15T14:28:08.496959Z FATAL :ASCII stream decoding error on 686s #: 686s 686s the octet sequence #(195) cannot be decoded. 686s 2025-03-15T14:28:08.501958Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 686s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 686s 2025-03-15T14:28:08.535955Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-error.out") 686s 2025-03-15T14:28:08.548954Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 686s 2025-03-15T14:28:08.645947Z LOG report summary reset 686s table name errors rows bytes total time 686s ----------------------- --------- --------- --------- -------------- 686s fetch 0 0 0.010s 686s before load 0 2 0.025s 686s ----------------------- --------- --------- --------- -------------- 686s "public"."jordane" 3 3 0.1 kB 0.052s 686s "expected"."jordane" 0 3 0.1 kB 0.018s 686s ----------------------- --------- --------- --------- -------------- 686s Files Processed 0 2 0.067s 686s COPY Threads Completion 0 4 0.071s 686s ----------------------- --------- --------- --------- -------------- 686s Total import time 3 6 0.2 kB 0.138s 686s 2025-03-15T14:28:08.691944Z LOG Regress pass. 686s touch regress/out/csv-error.out 686s pgloader --regress csv-escape-mode.load 687s 2025-03-15T14:28:10.028997Z LOG pgloader version "3.6.10~devel" 687s 2025-03-15T14:28:10.421968Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 687s 2025-03-15T14:28:10.422968Z WARNING That could impact loading performance badly. 687s 2025-03-15T14:28:10.422968Z WARNING Consider the option 'drop indexes'. 687s 2025-03-15T14:28:10.580956Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-escape-mode.out") 687s 2025-03-15T14:28:10.595955Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 688s 2025-03-15T14:28:10.693947Z LOG report summary reset 688s table name errors rows bytes total time 688s ---------------------------- --------- --------- --------- -------------- 688s fetch 0 0 0.011s 688s before load 0 2 0.026s 688s ---------------------------- --------- --------- --------- -------------- 688s "public"."csv_escape_mode" 0 5 0.1 kB 0.067s 688s "expected"."csv_escape_mode" 0 5 0.1 kB 0.017s 688s ---------------------------- --------- --------- --------- -------------- 688s Files Processed 0 2 0.066s 688s COPY Threads Completion 0 4 0.085s 688s ---------------------------- --------- --------- --------- -------------- 688s Total import time ✓ 10 0.2 kB 0.151s 688s 2025-03-15T14:28:10.736944Z LOG Regress pass. 688s touch regress/out/csv-escape-mode.out 688s pgloader --regress csv-filename-pattern.load 688s 2025-03-15T14:28:11.028998Z LOG pgloader version "3.6.10~devel" 689s 2025-03-15T14:28:11.553961Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-filename-pattern.out") 689s 2025-03-15T14:28:11.567960Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 689s 2025-03-15T14:28:11.666953Z LOG report summary reset 689s table name errors rows bytes total time 689s ----------------------- --------- --------- --------- -------------- 689s fetch 0 0 0.009s 689s before load 0 2 0.026s 689s ----------------------- --------- --------- --------- -------------- 689s "public"."matching" 0 3 0.0 kB 0.024s 689s "expected"."matching" 0 3 0.0 kB 0.018s 689s ----------------------- --------- --------- --------- -------------- 689s Files Processed 0 4 0.077s 689s COPY Threads Completion 0 8 0.081s 689s ----------------------- --------- --------- --------- -------------- 689s Total import time ✓ 6 0.0 kB 0.158s 689s 2025-03-15T14:28:11.707951Z LOG Regress pass. 689s touch regress/out/csv-filename-pattern.out 689s pgloader --regress csv-guess.load 690s 2025-03-15T14:28:13.026998Z LOG pgloader version "3.6.10~devel" 690s 2025-03-15T14:28:13.448972Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 690s 2025-03-15T14:28:13.448972Z WARNING That could impact loading performance badly. 690s 2025-03-15T14:28:13.448972Z WARNING Consider the option 'drop indexes'. 691s 2025-03-15T14:28:13.853947Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-guess.out") 691s 2025-03-15T14:28:13.868946Z WARNING PostgreSQL warning: table "track" does not exist, skipping 691s 2025-03-15T14:28:14.029937Z LOG report summary reset 691s table name errors rows bytes total time 691s ----------------------- --------- --------- --------- -------------- 691s fetch 0 0 0.009s 691s before load 0 2 0.027s 691s ----------------------- --------- --------- --------- -------------- 691s "csv"."track" 0 3503 366.8 kB 0.312s 691s "expected"."track" 0 3503 366.8 kB 0.083s 691s ----------------------- --------- --------- --------- -------------- 691s Files Processed 0 2 0.068s 691s COPY Threads Completion 0 4 0.396s 691s ----------------------- --------- --------- --------- -------------- 691s Total import time ✓ 7006 733.5 kB 0.464s 691s 2025-03-15T14:28:14.081934Z LOG Regress pass. 691s touch regress/out/csv-guess.out 691s pgloader --regress csv-header.load 692s 2025-03-15T14:28:14.029999Z LOG pgloader version "3.6.10~devel" 692s 2025-03-15T14:28:14.548970Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-header.out") 692s 2025-03-15T14:28:14.562970Z WARNING PostgreSQL warning: table "group" does not exist, skipping 692s 2025-03-15T14:28:14.664964Z LOG report summary reset 692s table name errors rows bytes total time 692s ----------------------- --------- --------- --------- -------------- 692s fetch 0 0 0.010s 692s before load 0 2 0.028s 692s ----------------------- --------- --------- --------- -------------- 692s "public"."group" 0 2 0.0 kB 0.023s 692s "expected"."group" 0 2 0.0 kB 0.017s 692s ----------------------- --------- --------- --------- -------------- 692s Files Processed 0 2 0.099s 692s COPY Threads Completion 0 4 0.042s 692s ----------------------- --------- --------- --------- -------------- 692s Total import time ✓ 4 0.1 kB 0.141s 692s 2025-03-15T14:28:14.701962Z LOG Regress pass. 692s touch regress/out/csv-header.out 692s pgloader --regress csv-json.load 693s 2025-03-15T14:28:16.027999Z LOG pgloader version "3.6.10~devel" 694s 2025-03-15T14:28:16.529973Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-json.out") 694s 2025-03-15T14:28:16.543972Z WARNING PostgreSQL warning: table "json" does not exist, skipping 694s 2025-03-15T14:28:16.645967Z LOG report summary reset 694s table name errors rows bytes total time 694s ----------------------- --------- --------- --------- -------------- 694s fetch 0 0 0.010s 694s before load 0 2 0.027s 694s ----------------------- --------- --------- --------- -------------- 694s "public"."json" 0 15 1.1 kB 0.045s 694s "expected"."json" 0 15 1.1 kB 0.017s 694s ----------------------- --------- --------- --------- -------------- 694s Files Processed 0 2 0.059s 694s COPY Threads Completion 0 4 0.064s 694s ----------------------- --------- --------- --------- -------------- 694s Total import time ✓ 30 2.3 kB 0.123s 694s 2025-03-15T14:28:16.684966Z LOG Regress pass. 694s touch regress/out/csv-json.out 694s pgloader --regress csv-keep-extra-blanks.load 694s 2025-03-15T14:28:17.026999Z LOG pgloader version "3.6.10~devel" 695s 2025-03-15T14:28:17.554974Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-keep-extra-blanks.out") 695s 2025-03-15T14:28:17.569973Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 695s 2025-03-15T14:28:17.671969Z LOG report summary reset 695s table name errors rows bytes total time 695s ----------------------- --------- --------- --------- -------------- 695s fetch 0 0 0.011s 695s before load 0 2 0.028s 695s ----------------------- --------- --------- --------- -------------- 695s "public"."nulls" 0 7 0.3 kB 0.056s 695s "expected"."nulls" 0 6 0.3 kB 0.019s 695s ----------------------- --------- --------- --------- -------------- 695s Files Processed 0 2 0.058s 695s COPY Threads Completion 0 4 0.078s 695s ----------------------- --------- --------- --------- -------------- 695s Total import time ✓ 13 0.6 kB 0.136s 695s 2025-03-15T14:28:17.711968Z LOG Regress pass. 695s touch regress/out/csv-keep-extra-blanks.out 695s pgloader --regress csv-missing-col.load 696s 2025-03-15T14:28:19.027999Z LOG pgloader version "3.6.10~devel" 696s 2025-03-15T14:28:19.499979Z LOG COPY INIT ERROR 696s 2025-03-15T14:28:19.501979Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 696s Database error 42703: column "c" of relation "missingcol" does not exist 696s 2025-03-15T14:28:19.534978Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-missing-col.out") 696s 2025-03-15T14:28:19.547977Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 696s 2025-03-15T14:28:19.646973Z LOG report summary reset 696s table name errors rows bytes total time 696s ----------------------- --------- --------- --------- -------------- 696s fetch 0 0 0.010s 696s before load 0 2 0.026s 696s ----------------------- --------- --------- --------- -------------- 696s "public"."missingcol" 1 0 0.047s 696s "expected"."missingcol" 0 0 0.018s 696s ----------------------- --------- --------- --------- -------------- 696s Files Processed 0 2 0.059s 696s COPY Threads Completion 0 4 0.072s 696s ----------------------- --------- --------- --------- -------------- 697s Total import time 1 0 0.131s 697s 2025-03-15T14:28:19.686971Z LOG Regress pass. 697s touch regress/out/csv-missing-col.out 697s pgloader --regress csv-non-printable.load 697s 2025-03-15T14:28:20.029998Z LOG pgloader version "3.6.10~devel" 698s 2025-03-15T14:28:20.532978Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-non-printable.out") 698s 2025-03-15T14:28:20.545978Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 698s 2025-03-15T14:28:20.647974Z LOG report summary reset 698s table name errors rows bytes total time 698s ----------------------- --------- --------- --------- -------------- 698s fetch 0 0 0.010s 698s before load 0 2 0.025s 698s ----------------------- --------- --------- --------- -------------- 698s "public"."tab_csv" 0 7 0.2 kB 0.051s 698s "expected"."tab_csv" 0 7 0.2 kB 0.017s 698s ----------------------- --------- --------- --------- -------------- 698s Files Processed 0 2 0.056s 698s COPY Threads Completion 0 4 0.069s 698s ----------------------- --------- --------- --------- -------------- 698s Total import time ✓ 14 0.4 kB 0.125s 698s 2025-03-15T14:28:20.690972Z LOG Regress pass. 698s touch regress/out/csv-non-printable.out 698s pgloader --regress csv-nulls.load 699s 2025-03-15T14:28:22.029999Z LOG pgloader version "3.6.10~devel" 699s 2025-03-15T14:28:22.512982Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 699s 2025-03-15T14:28:22.512982Z WARNING That could impact loading performance badly. 699s 2025-03-15T14:28:22.512982Z WARNING Consider the option 'drop indexes'. 699s 2025-03-15T14:28:22.669977Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-nulls.out") 699s 2025-03-15T14:28:22.686976Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 699s 2025-03-15T14:28:22.787973Z LOG report summary reset 699s table name errors rows bytes total time 699s ----------------------- --------- --------- --------- -------------- 699s fetch 0 0 0.011s 699s before load 0 2 0.027s 699s ----------------------- --------- --------- --------- -------------- 699s "public"."nullif" 0 2 0.0 kB 0.040s 699s "expected"."nullif" 0 2 0.0 kB 0.017s 699s ----------------------- --------- --------- --------- -------------- 699s Files Processed 0 2 0.099s 699s COPY Threads Completion 0 4 0.055s 699s ----------------------- --------- --------- --------- -------------- 699s Total import time ✓ 4 0.1 kB 0.154s 699s 2025-03-15T14:28:22.830971Z LOG Regress pass. 700s touch regress/out/csv-nulls.out 700s pgloader --regress csv-temp.load 700s 2025-03-15T14:28:23.031999Z LOG pgloader version "3.6.10~devel" 701s 2025-03-15T14:28:23.547981Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-temp.out") 701s 2025-03-15T14:28:23.562981Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 701s 2025-03-15T14:28:23.662978Z LOG report summary reset 701s table name errors rows bytes total time 701s ----------------------- --------- --------- --------- -------------- 701s fetch 0 0 0.011s 701s before load 0 2 0.024s 701s ----------------------- --------- --------- --------- -------------- 701s "public"."temp" 0 5 0.2 kB 0.049s 701s "expected"."temp" 0 5 0.2 kB 0.018s 701s ----------------------- --------- --------- --------- -------------- 701s Files Processed 0 2 0.068s 701s COPY Threads Completion 0 4 0.068s 701s ----------------------- --------- --------- --------- -------------- 701s Total import time ✓ 10 0.3 kB 0.136s 701s 2025-03-15T14:28:23.704977Z LOG Regress pass. 701s touch regress/out/csv-temp.out 701s pgloader --regress csv-trim-extra-blanks.load 702s 2025-03-15T14:28:25.026999Z LOG pgloader version "3.6.10~devel" 702s 2025-03-15T14:28:25.550985Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-trim-extra-blanks.out") 702s 2025-03-15T14:28:25.667981Z LOG report summary reset 702s table name errors rows bytes total time 702s ----------------------- --------- --------- --------- -------------- 702s fetch 0 0 0.010s 702s before load 0 2 0.030s 702s ----------------------- --------- --------- --------- -------------- 702s "public"."nulls" 0 7 0.3 kB 0.055s 702s "expected"."nulls" 0 7 0.3 kB 0.018s 702s ----------------------- --------- --------- --------- -------------- 702s Files Processed 0 2 0.063s 702s COPY Threads Completion 0 4 0.074s 702s ----------------------- --------- --------- --------- -------------- 702s Total import time ✓ 14 0.6 kB 0.137s 702s 2025-03-15T14:28:25.707980Z LOG Regress pass. 702s touch regress/out/csv-trim-extra-blanks.out 702s pgloader --regress csv-using-sexp.load 703s 2025-03-15T14:28:26.030999Z LOG pgloader version "3.6.10~devel" 704s 2025-03-15T14:28:26.551985Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv-using-sexp.out") 704s 2025-03-15T14:28:26.565984Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 704s 2025-03-15T14:28:26.666982Z LOG report summary reset 704s table name errors rows bytes total time 704s ----------------------- --------- --------- --------- -------------- 704s fetch 0 0 0.010s 704s before load 0 2 0.026s 704s ----------------------- --------- --------- --------- -------------- 704s "public"."sexp" 0 3 0.0 kB 0.054s 704s "expected"."sexp" 0 3 0.0 kB 0.017s 704s ----------------------- --------- --------- --------- -------------- 704s Files Processed 0 2 0.059s 704s COPY Threads Completion 0 4 0.071s 704s ----------------------- --------- --------- --------- -------------- 704s Total import time ✓ 6 0.1 kB 0.130s 704s 2025-03-15T14:28:26.711981Z LOG Regress pass. 704s touch regress/out/csv-using-sexp.out 704s pgloader --regress csv.load 705s 2025-03-15T14:28:28.030999Z LOG pgloader version "3.6.10~devel" 705s 2025-03-15T14:28:28.143996Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 705s 2025-03-15T14:28:28.545987Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 705s 2025-03-15T14:28:28.562987Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/csv.out") 705s 2025-03-15T14:28:28.576986Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 705s 2025-03-15T14:28:28.674984Z LOG report summary reset 705s table name errors rows bytes total time 705s ----------------------- --------- --------- --------- -------------- 705s fetch 0 0 0.010s 705s before load 0 2 0.026s 705s ----------------------- --------- --------- --------- -------------- 705s "public"."csv" 0 6 0.2 kB 0.059s 705s "expected"."csv" 0 6 0.2 kB 0.017s 705s ----------------------- --------- --------- --------- -------------- 705s Files Processed 0 2 0.061s 705s COPY Threads Completion 0 4 0.074s 705s ----------------------- --------- --------- --------- -------------- 705s Total import time ✓ 12 0.4 kB 0.135s 705s 2025-03-15T14:28:28.718983Z LOG Regress pass. 705s touch regress/out/csv.out 705s pgloader --regress copy.load 706s 2025-03-15T14:28:29.028999Z LOG pgloader version "3.6.10~devel" 706s 2025-03-15T14:28:29.126998Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 707s 2025-03-15T14:28:29.617986Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 707s 2025-03-15T14:28:29.633986Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/copy.out") 707s 2025-03-15T14:28:29.647985Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 707s 2025-03-15T14:28:29.796982Z LOG report summary reset 707s table name errors rows bytes total time 707s ----------------------- --------- --------- --------- -------------- 707s fetch 0 0 0.010s 707s before load 0 2 0.026s 707s ----------------------- --------- --------- --------- -------------- 707s "public"."track_full" 0 3503 366.8 kB 0.095s 707s "expected"."track_full" 0 3503 366.8 kB 0.084s 707s ----------------------- --------- --------- --------- -------------- 707s Files Processed 0 2 0.055s 707s COPY Threads Completion 0 4 0.179s 707s Index Build Completion 0 0 0.018s 707s Create Indexes 0 1 0.003s 707s Constraints 0 1 0.002s 707s ----------------------- --------- --------- --------- -------------- 707s Total import time ✓ 7006 733.5 kB 0.257s 707s 2025-03-15T14:28:29.837982Z LOG Regress pass. 707s touch regress/out/copy.out 707s pgloader --regress copy-hex.load 708s 2025-03-15T14:28:30.028000Z LOG pgloader version "3.6.10~devel" 708s 2025-03-15T14:28:30.486990Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/copy-hex.out") 708s 2025-03-15T14:28:30.501989Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 708s 2025-03-15T14:28:30.591989Z LOG report summary reset 708s table name errors rows bytes total time 708s ----------------------- --------- --------- --------- -------------- 708s fetch 0 0 0.011s 708s before load 0 2 0.024s 708s ----------------------- --------- --------- --------- -------------- 708s "public"."copyhex" 0 6 0.0 kB 0.039s 708s "expected"."copyhex" 0 6 0.0 kB 0.017s 708s ----------------------- --------- --------- --------- -------------- 708s Files Processed 0 2 0.049s 708s COPY Threads Completion 0 4 0.055s 708s ----------------------- --------- --------- --------- -------------- 708s Total import time ✓ 12 0.1 kB 0.104s 708s 2025-03-15T14:28:30.631988Z LOG Regress pass. 708s touch regress/out/copy-hex.out 708s pgloader --regress dbf.load 709s 2025-03-15T14:28:32.029000Z LOG pgloader version "3.6.10~devel" 709s 2025-03-15T14:28:32.225996Z LOG Migrating from # 709s 2025-03-15T14:28:32.225996Z LOG Migrating into # 709s 2025-03-15T14:28:32.464992Z WARNING Forcing encoding to CP850, db3 file has ASCII 709s 2025-03-15T14:28:32.538990Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/dbf.out") 709s 2025-03-15T14:28:32.553990Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 710s 2025-03-15T14:28:32.694988Z LOG report summary reset 710s table name errors rows bytes total time 710s ----------------------- --------- --------- --------- -------------- 710s fetch 0 0 0.005s 710s Create Schemas 0 0 0.001s 710s Create SQL Types 0 0 0.012s 710s Create tables 0 2 0.040s 710s ----------------------- --------- --------- --------- -------------- 710s public.reg2013 0 27 1.0 kB 0.022s 710s "expected"."reg2013" 0 27 1.0 kB 0.021s 710s ----------------------- --------- --------- --------- -------------- 710s COPY Threads Completion 0 6 0.045s 710s Create Triggers 0 0 0.000s 710s Install Comments 0 0 0.000s 710s Files Processed 0 1 0.012s 710s ----------------------- --------- --------- --------- -------------- 710s Total import time ✓ 54 1.9 kB 0.057s 710s 2025-03-15T14:28:32.733987Z LOG Regress pass. 710s touch regress/out/dbf.out 710s pgloader --regress errors.load 710s 2025-03-15T14:28:33.028999Z LOG pgloader version "3.6.10~devel" 710s 2025-03-15T14:28:33.147997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 711s 2025-03-15T14:28:33.443992Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 711s 2025-03-15T14:28:33.443992Z WARNING That could impact loading performance badly. 711s 2025-03-15T14:28:33.443992Z WARNING Consider the option 'drop indexes'. 711s 2025-03-15T14:28:33.528990Z ERROR End of file while collecting quoted item: # 711s 2025-03-15T14:28:33.528990Z FATAL End of file while collecting quoted item: # 711s 2025-03-15T14:28:33.533990Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 711s HINT: Perhaps you need a different "datestyle" setting. 711s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 711s 2025-03-15T14:28:33.535990Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 711s HINT: Perhaps you need a different "datestyle" setting. 711s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 711s 2025-03-15T14:28:33.536990Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 711s HINT: Perhaps you need a different "datestyle" setting. 711s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 711s 2025-03-15T14:28:33.553990Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 711s 2025-03-15T14:28:33.568990Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/errors.out") 711s 2025-03-15T14:28:33.583989Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 711s 2025-03-15T14:28:33.680988Z LOG report summary reset 711s table name errors rows bytes total time 711s ----------------------- --------- --------- --------- -------------- 711s fetch 0 0 0.011s 711s before load 0 4 0.029s 711s ----------------------- --------- --------- --------- -------------- 711s "err"."errors" 8 7 0.3 kB 0.035s 711s "expected"."errors" 0 7 0.2 kB 0.018s 711s ----------------------- --------- --------- --------- -------------- 711s Files Processed 0 2 0.067s 711s COPY Threads Completion 0 4 0.056s 711s ----------------------- --------- --------- --------- -------------- 711s Total import time 8 14 0.6 kB 0.123s 711s 2025-03-15T14:28:33.718987Z LOG Regress pass. 711s touch regress/out/errors.out 711s pgloader --regress fixed.load 712s 2025-03-15T14:28:35.028000Z LOG pgloader version "3.6.10~devel" 712s 2025-03-15T14:28:35.130998Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 712s 2025-03-15T14:28:35.571991Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 712s 2025-03-15T14:28:35.589991Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/fixed.out") 712s 2025-03-15T14:28:35.602991Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 712s 2025-03-15T14:28:35.696990Z LOG report summary reset 712s table name errors rows bytes total time 712s ----------------------- --------- --------- --------- -------------- 712s fetch 0 0 0.010s 712s before load 0 2 0.027s 712s ----------------------- --------- --------- --------- -------------- 712s "public"."fixed" 0 5 0.2 kB 0.033s 712s "expected"."fixed" 0 5 0.2 kB 0.019s 712s ----------------------- --------- --------- --------- -------------- 712s Files Processed 0 2 0.067s 713s COPY Threads Completion 0 4 0.049s 713s Index Build Completion 0 0 0.021s 713s Create Indexes 0 1 0.002s 713s Constraints 0 1 0.002s 713s ----------------------- --------- --------- --------- -------------- 713s Total import time ✓ 10 0.4 kB 0.141s 713s 2025-03-15T14:28:35.735989Z LOG Regress pass. 713s touch regress/out/fixed.out 713s pgloader --regress fields-with-periods.load 713s 2025-03-15T14:28:36.030000Z LOG pgloader version "3.6.10~devel" 714s 2025-03-15T14:28:36.501992Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/fields-with-periods.out") 714s 2025-03-15T14:28:36.612991Z LOG report summary reset 714s table name errors rows bytes total time 714s ----------------------- --------- --------- --------- -------------- 714s fetch 0 0 0.010s 714s before load 0 2 0.025s 714s ----------------------- --------- --------- --------- -------------- 714s "public"."fixed" 0 3 0.0 kB 0.038s 714s "expected"."fixed" 0 3 0.0 kB 0.017s 714s ----------------------- --------- --------- --------- -------------- 714s Files Processed 0 2 0.053s 714s COPY Threads Completion 0 4 0.056s 714s ----------------------- --------- --------- --------- -------------- 714s Total import time ✓ 6 0.0 kB 0.109s 714s 2025-03-15T14:28:36.651990Z LOG Regress pass. 714s touch regress/out/fields-with-periods.out 714s pgloader --regress ixf.load 715s 2025-03-15T14:28:37.026000Z LOG pgloader version "3.6.10~devel" 715s 2025-03-15T14:28:37.252997Z LOG Migrating from # 715s 2025-03-15T14:28:37.253997Z LOG Migrating into # 715s 2025-03-15T14:28:37.557993Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/ixf.out") 715s 2025-03-15T14:28:37.569993Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 715s 2025-03-15T14:28:37.701991Z LOG report summary reset 715s table name errors rows bytes total time 715s ----------------------- --------- --------- --------- -------------- 715s fetch 0 0 0.004s 715s before load 0 3 0.022s 715s Create Schemas 0 0 0.001s 715s Create SQL Types 0 0 0.013s 715s Create tables 0 2 0.039s 715s ----------------------- --------- --------- --------- -------------- 715s nsitra.test1 0 4 0.2 kB 0.022s 715s "expected"."test1" 0 4 0.2 kB 0.018s 715s ----------------------- --------- --------- --------- -------------- 715s COPY Threads Completion 0 6 0.043s 715s Index Build Completion 0 0 0.004s 715s Primary Keys 0 0 0.000s 715s Create Triggers 0 0 0.000s 715s Install Comments 0 0 0.000s 715s Files Processed 0 1 0.010s 715s ----------------------- --------- --------- --------- -------------- 715s Total import time ✓ 8 0.3 kB 0.057s 715s 2025-03-15T14:28:37.740991Z LOG Regress pass. 715s touch regress/out/ixf.out 715s pgloader --regress overflow.load 716s 2025-03-15T14:28:39.026999Z LOG pgloader version "3.6.10~devel" 716s 2025-03-15T14:28:39.498994Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 716s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 716s 2025-03-15T14:28:39.500994Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 716s DETAIL: Failing row contains (12, null). 716s CONTEXT: COPY overflow, line 1: "12 \N" 716s 2025-03-15T14:28:39.531993Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/overflow.out") 717s 2025-03-15T14:28:39.546993Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 717s 2025-03-15T14:28:39.640992Z LOG report summary reset 717s table name errors rows bytes total time 717s ----------------------- --------- --------- --------- -------------- 717s fetch 0 0 0.012s 717s before load 0 2 0.025s 717s ----------------------- --------- --------- --------- -------------- 717s "public"."overflow" 4 0 0.0 kB 0.055s 717s "expected"."overflow" 0 0 0.017s 717s ----------------------- --------- --------- --------- -------------- 717s Files Processed 0 2 0.059s 717s COPY Threads Completion 0 4 0.074s 717s ----------------------- --------- --------- --------- -------------- 717s Total import time 4 0 0.0 kB 0.133s 717s 2025-03-15T14:28:39.681992Z LOG Regress pass. 717s touch regress/out/overflow.out 717s pgloader --regress partial.load 717s 2025-03-15T14:28:40.028000Z LOG pgloader version "3.6.10~devel" 717s 2025-03-15T14:28:40.128999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 718s 2025-03-15T14:28:40.566993Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 718s 2025-03-15T14:28:40.584993Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/partial.out") 718s 2025-03-15T14:28:40.597993Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 718s 2025-03-15T14:28:40.686992Z LOG report summary reset 718s table name errors rows bytes total time 718s ----------------------- --------- --------- --------- -------------- 718s fetch 0 0 0.010s 718s before load 0 4 0.027s 718s ----------------------- --------- --------- --------- -------------- 718s "csv"."partial" 0 7 0.1 kB 0.033s 718s "expected"."partial" 0 7 0.1 kB 0.019s 718s ----------------------- --------- --------- --------- -------------- 718s Files Processed 0 2 0.064s 718s COPY Threads Completion 0 4 0.049s 718s Index Build Completion 0 0 0.021s 718s Create Indexes 0 2 0.003s 718s Constraints 0 1 0.001s 718s ----------------------- --------- --------- --------- -------------- 718s Total import time ✓ 14 0.2 kB 0.138s 718s 2025-03-15T14:28:40.722992Z LOG Regress pass. 718s touch regress/out/partial.out 718s pgloader --regress serial.load 719s 2025-03-15T14:28:42.028000Z LOG pgloader version "3.6.10~devel" 719s 2025-03-15T14:28:42.127999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 719s 2025-03-15T14:28:42.409996Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 719s 2025-03-15T14:28:42.410996Z WARNING That could impact loading performance badly. 719s 2025-03-15T14:28:42.410996Z WARNING Consider the option 'drop indexes'. 719s 2025-03-15T14:28:42.515995Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 719s 2025-03-15T14:28:42.530995Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/serial.out") 719s 2025-03-15T14:28:42.545995Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 719s 2025-03-15T14:28:42.641994Z LOG report summary reset 719s table name errors rows bytes total time 719s ----------------------- --------- --------- --------- -------------- 719s fetch 0 0 0.009s 719s before load 0 2 0.027s 719s ----------------------- --------- --------- --------- -------------- 719s "public"."serial" 0 7 0.2 kB 0.032s 719s "expected"."serial" 0 7 0.2 kB 0.018s 719s ----------------------- --------- --------- --------- -------------- 719s Files Processed 0 2 0.065s 719s COPY Threads Completion 0 4 0.050s 719s ----------------------- --------- --------- --------- -------------- 719s Total import time ✓ 14 0.4 kB 0.115s 719s 2025-03-15T14:28:42.681993Z LOG Regress pass. 719s touch regress/out/serial.out 719s pgloader --regress udc.load 720s 2025-03-15T14:28:43.027000Z LOG pgloader version "3.6.10~devel" 720s 2025-03-15T14:28:43.129999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 721s 2025-03-15T14:28:43.414995Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 721s 2025-03-15T14:28:43.415995Z WARNING That could impact loading performance badly. 721s 2025-03-15T14:28:43.417995Z WARNING Consider the option 'drop indexes'. 721s 2025-03-15T14:28:43.523996Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 721s 2025-03-15T14:28:43.538996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/udc.out") 721s 2025-03-15T14:28:43.554996Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 721s 2025-03-15T14:28:43.653997Z LOG report summary reset 721s table name errors rows bytes total time 721s ----------------------- --------- --------- --------- -------------- 721s fetch 0 0 0.011s 721s before load 0 2 0.027s 721s ----------------------- --------- --------- --------- -------------- 721s "public"."udc" 0 5 0.1 kB 0.033s 721s "expected"."udc" 0 5 0.1 kB 0.018s 721s ----------------------- --------- --------- --------- -------------- 721s Files Processed 0 2 0.069s 721s COPY Threads Completion 0 4 0.051s 721s ----------------------- --------- --------- --------- -------------- 721s Total import time ✓ 10 0.2 kB 0.120s 721s 2025-03-15T14:28:43.693997Z LOG Regress pass. 721s touch regress/out/udc.out 721s pgloader --regress xzero.load 722s 2025-03-15T14:28:44.027000Z LOG pgloader version "3.6.10~devel" 722s 2025-03-15T14:28:44.130000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 722s 2025-03-15T14:28:44.411001Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 722s 2025-03-15T14:28:44.411001Z WARNING That could impact loading performance badly. 722s 2025-03-15T14:28:44.412001Z WARNING Consider the option 'drop indexes'. 722s 2025-03-15T14:28:44.516002Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 722s 2025-03-15T14:28:44.533002Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.Z8pY72/build.Yph/src/test/regress/expected/xzero.out") 722s 2025-03-15T14:28:44.546002Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 722s 2025-03-15T14:28:44.644004Z LOG report summary reset 722s table name errors rows bytes total time 722s ----------------------- --------- --------- --------- -------------- 722s fetch 0 0 0.010s 722s before load 0 2 0.026s 722s ----------------------- --------- --------- --------- -------------- 722s "public"."xzero" 0 7 0.2 kB 0.027s 722s "expected"."xzero" 0 7 0.2 kB 0.017s 722s ----------------------- --------- --------- --------- -------------- 722s Files Processed 0 2 0.067s 722s COPY Threads Completion 0 4 0.044s 722s ----------------------- --------- --------- --------- -------------- 722s Total import time ✓ 14 0.4 kB 0.111s 722s 2025-03-15T14:28:44.683004Z LOG Regress pass. 722s touch regress/out/xzero.out 722s make: Leaving directory '/tmp/autopkgtest.Z8pY72/build.Yph/src/test' 722s Dropping cluster 17/regress ... 723s autopkgtest [14:28:46]: test testsuite: -----------------------] 723s autopkgtest [14:28:46]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 723s testsuite PASS 724s autopkgtest [14:28:47]: @@@@@@@@@@@@@@@@@@@@ summary 724s ssl PASS 724s testsuite PASS 743s nova [W] Using flock in prodstack6-arm64 743s Creating nova instance adt-plucky-arm64-pgloader-20250315-141643-juju-7f2275-prod-proposed-migration-environment-2-e931c76e-eccd-4d2e-b759-3165043e9c37 from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 743s nova [W] Timed out waiting for 3e3c7f87-cb2c-4b32-892b-eb80633478ba to get deleted. 743s nova [W] Using flock in prodstack6-arm64 743s flock: timeout while waiting to get lock 743s Creating nova instance adt-plucky-arm64-pgloader-20250315-141643-juju-7f2275-prod-proposed-migration-environment-2-e931c76e-eccd-4d2e-b759-3165043e9c37 from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 743s nova [W] Timed out waiting for 9f4111ba-8385-4291-8214-023930caa6bf to get deleted.