0s autopkgtest [02:48:33]: starting date and time: 2024-11-15 02:48:33+0000 0s autopkgtest [02:48:33]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [02:48:33]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.7ho1qi59/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/266 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-arm64-4.secgroup --name adt-plucky-arm64-pgloader-20241115-024833-juju-7f2275-prod-proposed-migration-environment-20-9f4b3077-fe41-4f36-8f01-547efe43be9a --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --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'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 71s autopkgtest [02:49:44]: testbed dpkg architecture: arm64 71s autopkgtest [02:49:44]: testbed apt version: 2.9.8 71s autopkgtest [02:49:44]: @@@@@@@@@@@@@@@@@@@@ test bed setup 72s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 73s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 73s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1030 kB] 73s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 73s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 73s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [164 kB] 73s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [50.3 kB] 73s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [773 kB] 73s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [6116 B] 73s Fetched 2221 kB in 1s (2461 kB/s) 73s Reading package lists... 76s Reading package lists... 76s Building dependency tree... 76s Reading state information... 76s Calculating upgrade... 77s The following packages will be upgraded: 77s firmware-sof-signed libcap-ng0 libexpat1 lxd-installer man-db pastebinit 77s python3-systemd xfsprogs 77s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 77s Need to get 9481 kB of archives. 77s After this operation, 549 kB of additional disk space will be used. 77s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 78s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libcap-ng0 arm64 0.8.5-3build1 [15.0 kB] 78s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libexpat1 arm64 2.6.4-1 [76.6 kB] 78s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 man-db arm64 2.13.0-1 [1320 kB] 78s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 lxd-installer all 9 [5084 B] 78s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 pastebinit all 1.7.1-1 [14.9 kB] 78s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-systemd arm64 235-1build5 [46.7 kB] 78s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 xfsprogs arm64 6.8.0-2.2ubuntu2 [919 kB] 78s Preconfiguring packages ... 78s Fetched 9481 kB in 1s (9758 kB/s) 78s (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 ... 79925 files and directories currently installed.) 78s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 78s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 79s Preparing to unpack .../libcap-ng0_0.8.5-3build1_arm64.deb ... 79s Unpacking libcap-ng0:arm64 (0.8.5-3build1) over (0.8.5-1) ... 79s Setting up libcap-ng0:arm64 (0.8.5-3build1) ... 79s (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 ... 79951 files and directories currently installed.) 79s Preparing to unpack .../0-libexpat1_2.6.4-1_arm64.deb ... 79s Unpacking libexpat1:arm64 (2.6.4-1) over (2.6.2-2) ... 79s Preparing to unpack .../1-man-db_2.13.0-1_arm64.deb ... 79s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 79s Preparing to unpack .../2-lxd-installer_9_all.deb ... 79s Unpacking lxd-installer (9) over (8) ... 79s Preparing to unpack .../3-pastebinit_1.7.1-1_all.deb ... 79s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 79s Preparing to unpack .../4-python3-systemd_235-1build5_arm64.deb ... 79s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 79s Preparing to unpack .../5-xfsprogs_6.8.0-2.2ubuntu2_arm64.deb ... 79s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 79s Setting up libexpat1:arm64 (2.6.4-1) ... 79s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 79s Setting up pastebinit (1.7.1-1) ... 79s Setting up man-db (2.13.0-1) ... 79s Updating database of manual pages ... 82s man-db.service is a disabled or a static unit not running, not starting it. 82s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 82s update-initramfs: deferring update (trigger activated) 82s Setting up lxd-installer (9) ... 82s Setting up python3-systemd (235-1build5) ... 83s Processing triggers for libc-bin (2.40-1ubuntu3) ... 83s Processing triggers for initramfs-tools (0.142ubuntu34) ... 83s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 83s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 98s System running in EFI mode, skipping. 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 100s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 100s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 100s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 100s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 101s Reading package lists... 101s Reading package lists... 101s Building dependency tree... 101s Reading state information... 102s Calculating upgrade... 102s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 102s Reading package lists... 102s Building dependency tree... 102s Reading state information... 103s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s autopkgtest [02:50:16]: rebooting testbed after setup commands that affected boot 127s autopkgtest [02:50:40]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 130s autopkgtest [02:50:43]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 132s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (dsc) [2932 B] 132s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (tar) [3723 kB] 132s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (diff) [9880 B] 132s gpgv: Signature made Mon Oct 28 11:35:26 2024 UTC 132s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 132s gpgv: Can't check signature: No public key 132s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-4.dsc: no acceptable signature found 132s autopkgtest [02:50:45]: testing package pgloader version 3.6.10-4 133s autopkgtest [02:50:46]: build not needed 134s autopkgtest [02:50:47]: test ssl: preparing testbed 136s Reading package lists... 136s Building dependency tree... 136s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 137s Starting 2 pkgProblemResolver with broken count: 0 137s Done 137s The following additional packages will be installed: 137s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 137s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 137s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 137s cl-usocket freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 137s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql postgresql-17 137s postgresql-client-17 postgresql-client-common postgresql-common ssl-cert 137s Suggested packages: 137s postgresql-doc postgresql-doc-17 137s Recommended packages: 137s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 137s libjson-xs-perl 137s The following NEW packages will be installed: 137s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 137s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 137s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 137s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 138s libct4 libio-pty-perl libipc-run-perl libjson-perl libpq5 libsybdb5 138s libxslt1.1 pgloader postgresql postgresql-17 postgresql-client-17 138s postgresql-client-common postgresql-common ssl-cert 138s 0 upgraded, 35 newly installed, 0 to remove and 0 not upgraded. 138s Need to get 50.0 MB/50.0 MB of archives. 138s After this operation, 124 MB of additional disk space will be used. 138s Get:1 /tmp/autopkgtest.C0mysu/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [736 B] 138s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 138s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 138s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 138s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-client-common all 266 [37.0 kB] 138s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 138s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-common all 266 [162 kB] 138s Get:8 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-alexandria all 20240125.git8514d8e-1 [204 kB] 138s Get:9 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-rt all 20090812.gita6a7503-1 [13.2 kB] 138s Get:10 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-kmrcl all 1.111-2 [42.7 kB] 138s Get:11 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-base64 all 3.4.0-1 [9304 B] 138s Get:12 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 138s Get:13 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 138s Get:14 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-trivial-gray-streams all 20240217.gita7ead68-1 [9956 B] 138s Get:15 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 138s Get:16 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 138s Get:17 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-ironclad all 0.60-2 [1243 kB] 138s Get:18 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 138s Get:19 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-split-sequence all 1:2.0.1-1 [12.2 kB] 138s Get:20 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 138s Get:21 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 138s Get:22 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-usocket all 0.8.3-3 [70.5 kB] 138s Get:23 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-postgres all 20211113.git9d4332f-5 [56.8 kB] 138s Get:24 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-s-sql all 20211113.git9d4332f-5 [61.1 kB] 138s Get:25 http://ftpmaster.internal/ubuntu plucky/universe arm64 cl-postmodern all 20211113.git9d4332f-5 [354 kB] 138s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 138s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 libct4 arm64 1.3.17+ds-2build3 [163 kB] 138s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 libsybdb5 arm64 1.3.17+ds-2build3 [186 kB] 138s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-dev arm64 1.3.17+ds-2build3 [300 kB] 138s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.0-1 [248 kB] 138s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu1 [167 kB] 138s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.0-1 [2102 kB] 138s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.0-1 [17.7 MB] 139s Get:34 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql all 17+266 [12.1 kB] 139s Get:35 http://ftpmaster.internal/ubuntu plucky/universe arm64 pgloader arm64 3.6.10-4 [25.6 MB] 140s Preconfiguring packages ... 140s Fetched 50.0 MB in 2s (22.0 MB/s) 140s Selecting previously unselected package libjson-perl. 141s (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 ... 79957 files and directories currently installed.) 141s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 141s Unpacking libjson-perl (4.10000-1) ... 141s Selecting previously unselected package libio-pty-perl. 141s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 141s Unpacking libio-pty-perl (1:1.20-1build3) ... 141s Selecting previously unselected package libipc-run-perl. 141s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 141s Unpacking libipc-run-perl (20231003.0-2) ... 141s Selecting previously unselected package postgresql-client-common. 141s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 141s Unpacking postgresql-client-common (266) ... 141s Selecting previously unselected package ssl-cert. 141s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 141s Unpacking ssl-cert (1.1.2ubuntu2) ... 141s Selecting previously unselected package postgresql-common. 141s Preparing to unpack .../05-postgresql-common_266_all.deb ... 141s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 141s Unpacking postgresql-common (266) ... 141s Selecting previously unselected package cl-alexandria. 141s Preparing to unpack .../06-cl-alexandria_20240125.git8514d8e-1_all.deb ... 141s Unpacking cl-alexandria (20240125.git8514d8e-1) ... 141s Selecting previously unselected package cl-rt. 141s Preparing to unpack .../07-cl-rt_20090812.gita6a7503-1_all.deb ... 141s Unpacking cl-rt (20090812.gita6a7503-1) ... 141s Selecting previously unselected package cl-kmrcl. 141s Preparing to unpack .../08-cl-kmrcl_1.111-2_all.deb ... 141s Unpacking cl-kmrcl (1.111-2) ... 141s Selecting previously unselected package cl-base64. 141s Preparing to unpack .../09-cl-base64_3.4.0-1_all.deb ... 141s Unpacking cl-base64 (3.4.0-1) ... 141s Selecting previously unselected package cl-bordeaux-threads. 141s Preparing to unpack .../10-cl-bordeaux-threads_0.8.8-5_all.deb ... 141s Unpacking cl-bordeaux-threads (0.8.8-5) ... 141s Selecting previously unselected package cl-closer-mop. 141s Preparing to unpack .../11-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 141s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 141s Selecting previously unselected package cl-trivial-gray-streams. 141s Preparing to unpack .../12-cl-trivial-gray-streams_20240217.gita7ead68-1_all.deb ... 141s Unpacking cl-trivial-gray-streams (20240217.gita7ead68-1) ... 141s Selecting previously unselected package cl-flexi-streams. 141s Preparing to unpack .../13-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 141s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 141s Selecting previously unselected package cl-global-vars. 141s Preparing to unpack .../14-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 141s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 141s Selecting previously unselected package cl-ironclad. 141s Preparing to unpack .../15-cl-ironclad_0.60-2_all.deb ... 141s Unpacking cl-ironclad (0.60-2) ... 141s Selecting previously unselected package cl-md5. 141s Preparing to unpack .../16-cl-md5_1%3a20210622.git906593f-1_all.deb ... 141s Unpacking cl-md5 (1:20210622.git906593f-1) ... 141s Selecting previously unselected package cl-split-sequence. 141s Preparing to unpack .../17-cl-split-sequence_1%3a2.0.1-1_all.deb ... 141s Unpacking cl-split-sequence (1:2.0.1-1) ... 141s Selecting previously unselected package cl-ppcre. 141s Preparing to unpack .../18-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 141s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 141s Selecting previously unselected package cl-uax-15. 141s Preparing to unpack .../19-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 141s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 141s Selecting previously unselected package cl-usocket. 141s Preparing to unpack .../20-cl-usocket_0.8.3-3_all.deb ... 141s Unpacking cl-usocket (0.8.3-3) ... 141s Selecting previously unselected package cl-postgres. 141s Preparing to unpack .../21-cl-postgres_20211113.git9d4332f-5_all.deb ... 141s Unpacking cl-postgres (20211113.git9d4332f-5) ... 141s Selecting previously unselected package cl-s-sql. 141s Preparing to unpack .../22-cl-s-sql_20211113.git9d4332f-5_all.deb ... 141s Unpacking cl-s-sql (20211113.git9d4332f-5) ... 141s Selecting previously unselected package cl-postmodern. 141s Preparing to unpack .../23-cl-postmodern_20211113.git9d4332f-5_all.deb ... 141s Unpacking cl-postmodern (20211113.git9d4332f-5) ... 142s Selecting previously unselected package freetds-common. 142s Preparing to unpack .../24-freetds-common_1.3.17+ds-2build3_all.deb ... 142s Unpacking freetds-common (1.3.17+ds-2build3) ... 142s Selecting previously unselected package libct4:arm64. 142s Preparing to unpack .../25-libct4_1.3.17+ds-2build3_arm64.deb ... 142s Unpacking libct4:arm64 (1.3.17+ds-2build3) ... 142s Selecting previously unselected package libsybdb5:arm64. 142s Preparing to unpack .../26-libsybdb5_1.3.17+ds-2build3_arm64.deb ... 142s Unpacking libsybdb5:arm64 (1.3.17+ds-2build3) ... 142s Selecting previously unselected package freetds-dev. 142s Preparing to unpack .../27-freetds-dev_1.3.17+ds-2build3_arm64.deb ... 142s Unpacking freetds-dev (1.3.17+ds-2build3) ... 142s Selecting previously unselected package libpq5:arm64. 142s Preparing to unpack .../28-libpq5_17.0-1_arm64.deb ... 142s Unpacking libpq5:arm64 (17.0-1) ... 142s Selecting previously unselected package libxslt1.1:arm64. 142s Preparing to unpack .../29-libxslt1.1_1.1.39-0exp1ubuntu1_arm64.deb ... 142s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 142s Selecting previously unselected package postgresql-client-17. 142s Preparing to unpack .../30-postgresql-client-17_17.0-1_arm64.deb ... 142s Unpacking postgresql-client-17 (17.0-1) ... 142s Selecting previously unselected package postgresql-17. 142s Preparing to unpack .../31-postgresql-17_17.0-1_arm64.deb ... 142s Unpacking postgresql-17 (17.0-1) ... 142s Selecting previously unselected package postgresql. 142s Preparing to unpack .../32-postgresql_17+266_all.deb ... 142s Unpacking postgresql (17+266) ... 142s Selecting previously unselected package pgloader. 142s Preparing to unpack .../33-pgloader_3.6.10-4_arm64.deb ... 142s Unpacking pgloader (3.6.10-4) ... 142s Selecting previously unselected package autopkgtest-satdep. 142s Preparing to unpack .../34-1-autopkgtest-satdep.deb ... 142s Unpacking autopkgtest-satdep (0) ... 142s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 142s Setting up libio-pty-perl (1:1.20-1build3) ... 142s Setting up libpq5:arm64 (17.0-1) ... 142s Setting up cl-split-sequence (1:2.0.1-1) ... 142s Setting up cl-trivial-gray-streams (20240217.gita7ead68-1) ... 142s Setting up ssl-cert (1.1.2ubuntu2) ... 143s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 143s Setting up libipc-run-perl (20231003.0-2) ... 143s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 143s Setting up libjson-perl (4.10000-1) ... 143s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 143s Setting up cl-alexandria (20240125.git8514d8e-1) ... 143s Setting up cl-rt (20090812.gita6a7503-1) ... 143s Setting up freetds-common (1.3.17+ds-2build3) ... 143s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 143s Setting up postgresql-client-common (266) ... 143s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 143s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 143s Setting up postgresql-client-17 (17.0-1) ... 144s 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 144s Setting up libsybdb5:arm64 (1.3.17+ds-2build3) ... 144s Setting up cl-bordeaux-threads (0.8.8-5) ... 144s Setting up libct4:arm64 (1.3.17+ds-2build3) ... 144s Setting up cl-kmrcl (1.111-2) ... 144s Setting up postgresql-common (266) ... 144s 145s Creating config file /etc/postgresql-common/createcluster.conf with new version 145s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 145s Removing obsolete dictionary files: 145s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 145s Setting up cl-usocket (0.8.3-3) ... 145s Setting up cl-md5 (1:20210622.git906593f-1) ... 145s Setting up cl-base64 (3.4.0-1) ... 145s Setting up cl-ironclad (0.60-2) ... 145s Setting up postgresql-17 (17.0-1) ... 146s Creating new PostgreSQL cluster 17/main ... 146s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 146s The files belonging to this database system will be owned by user "postgres". 146s This user must also own the server process. 146s 146s The database cluster will be initialized with locale "C.UTF-8". 146s The default database encoding has accordingly been set to "UTF8". 146s The default text search configuration will be set to "english". 146s 146s Data page checksums are disabled. 146s 146s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 146s creating subdirectories ... ok 146s selecting dynamic shared memory implementation ... posix 146s selecting default "max_connections" ... 100 146s selecting default "shared_buffers" ... 128MB 146s selecting default time zone ... Etc/UTC 146s creating configuration files ... ok 146s running bootstrap script ... ok 146s performing post-bootstrap initialization ... ok 146s syncing data to disk ... ok 150s Setting up freetds-dev (1.3.17+ds-2build3) ... 150s Setting up pgloader (3.6.10-4) ... 150s Setting up cl-postgres (20211113.git9d4332f-5) ... 150s Setting up postgresql (17+266) ... 150s Setting up cl-s-sql (20211113.git9d4332f-5) ... 150s Setting up cl-postmodern (20211113.git9d4332f-5) ... 150s Setting up autopkgtest-satdep (0) ... 150s Processing triggers for man-db (2.13.0-1) ... 151s Processing triggers for install-info (7.1.1-1) ... 151s Processing triggers for libc-bin (2.40-1ubuntu3) ... 155s (Reading database ... 83281 files and directories currently installed.) 155s Removing autopkgtest-satdep (0) ... 155s autopkgtest [02:51:08]: test ssl: [----------------------- 156s + trap rm -rf /tmp/pgloader EXIT 156s + dpkg-query --show --showformat=${Version} cl-postmodern 156s Creating new PostgreSQL cluster 17/regress ... 156s + postmodern=20211113.git9d4332f-5 156s + dpkg --compare-versions 20211113.git9d4332f-5 lt 20200101 156s + pg_virtualenv 159s ++ psql -XAtc 'SHOW hba_file' 159s + HBA=/etc/postgresql/17/regress/pg_hba.conf 159s + sed -i -e 's/^host/hostssl/' /etc/postgresql/17/regress/pg_hba.conf 159s + psql -XAtc 'SELECT pg_reload_conf()' 159s t 159s + createdb pgloader 159s + export PGDATABASE=pgloader 159s + PGDATABASE=pgloader 159s + psql -XAtc 'create schema expected' 159s CREATE SCHEMA 159s + rm -rf /tmp/pgloader 159s + PGHOST=/var/run/postgresql 159s + su -c 'pgloader --debug --regress test/allcols.load' postgres 160s mkdir -p #P"/tmp/pgloader/" 160s pgloader version 3.6.10~devel 160s compiled with SBCL 2.2.9.debian 160s sb-impl::*default-external-format* :UTF-8 160s tmpdir: #P"/tmp/pgloader/" 160s 2024-11-15T02:51:13.008000Z NOTICE Starting pgloader, log system is ready. 160s 2024-11-15T02:51:13.028000Z INFO Starting monitor 160s 2024-11-15T02:51:13.036000Z LOG pgloader version "3.6.10~devel" 160s 2024-11-15T02:51:13.125000Z INFO Parsed command: 160s /* 160s * This test is ported from pgloader 2.x where it was defined as: 160s * 160s * [allcols] 160s * table = allcols 160s * format = csv 160s * filename = allcols/allcols.data 160s * field_sep = : 160s * columns = * 160s * pg_option_work_mem = 14MB 160s * 160s */ 160s 160s LOAD CSV 160s FROM inline (a, b, c) 160s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 160s 160s WITH fields optionally enclosed by '"', 160s fields escaped by double-quote, 160s fields terminated by ':' 160s 160s SET client_encoding to 'latin1', 160s work_mem to '14MB', 160s standard_conforming_strings to 'on' 160s 160s BEFORE LOAD DO 160s $$ drop table if exists allcols; $$, 160s $$ create table allcols ( 160s a integer primary key, 160s b date, 160s c text 160s ); 160s $$; 160s 160s 160s 160s 160s 160s 2024-11-15T02:51:13.134000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 160s 2024-11-15T02:51:13.197000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.197000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.197000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.197000Z DEBUG SET standard_conforming_strings TO 'on' 160s 2024-11-15T02:51:13.198000Z DEBUG SET application_name TO 'pgloader' 160s 2024-11-15T02:51:13.218000Z NOTICE Executing SQL block for before load 160s 2024-11-15T02:51:13.232000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.232000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.232000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.232000Z DEBUG SET standard_conforming_strings TO 'on' 160s 2024-11-15T02:51:13.232000Z DEBUG SET application_name TO 'pgloader' 160s 2024-11-15T02:51:13.239000Z DEBUG BEGIN 160s 2024-11-15T02:51:13.239000Z SQL drop table if exists allcols; 160s 2024-11-15T02:51:13.240000Z SQL create table allcols ( 160s a integer primary key, 160s b date, 160s c text 160s ); 160s 2024-11-15T02:51:13.291000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.291000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.292000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.292000Z DEBUG SET standard_conforming_strings TO 'on' 160s 2024-11-15T02:51:13.292000Z DEBUG SET application_name TO 'pgloader' 160s 2024-11-15T02:51:13.318000Z SQL -- 160s -- get user defined SQL types 160s -- 160s select nt.nspname, 160s extname, 160s typname, 160s case when enum.enumtypid is not null 160s then array_agg(enum.enumlabel order by enumsortorder) 160s end as enumvalues 160s 160s from pg_class c 160s join pg_namespace n on n.oid = c.relnamespace 160s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 160s join pg_type t on t.oid = a.atttypid 160s left join pg_namespace nt on nt.oid = t.typnamespace 160s left join pg_depend d on d.classid = 'pg_type'::regclass 160s and d.refclassid = 'pg_extension'::regclass 160s and d.objid = t.oid 160s left join pg_extension e on refobjid = e.oid 160s left join pg_enum enum on enum.enumtypid = t.oid 160s 160s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 160s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 160s and c.relkind in ('r', 'f', 'p') 160s and ((n.nspname = 'public' and c.relname = 'allcols')) 160s 160s and 160s ( t.typrelid = 0 160s or 160s (select c.relkind = 'c' 160s from pg_class c 160s where c.oid = t.typrelid) 160s ) 160s and not exists 160s ( 160s select 1 160s from pg_type el 160s where el.oid = t.typelem 160s and el.typarray = t.oid 160s ) 160s 160s group by nt.nspname, extname, typname, enumtypid 160s order by nt.nspname, extname, typname, enumtypid; 160s 2024-11-15T02:51:13.323000Z SQL -- params: table-type-name 160s -- including 160s -- filter-list-to-where-clause for including 160s -- excluding 160s -- filter-list-to-where-clause for excluding 160s with seqattr as 160s ( 160s select adrelid, 160s adnum, 160s pg_get_expr(d.adbin, d.adrelid) as adsrc, 160s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 160s then substring(pg_get_expr(d.adbin, d.adrelid) 160s from '''([^'']+)''' 160s ) 160s else null 160s end as seqname 160s from pg_attrdef d 160s ) 160s select nspname, relname, c.oid, attname, 160s t.oid::regtype as type, 160s case when atttypmod > 0 160s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 160s else null 160s end as typmod, 160s attnotnull, 160s case when atthasdef 160s then pg_get_expr(def.adbin, def.adrelid) 160s end as default , 160s case when s.seqname is not null then 'auto_increment' end as extra 160s from pg_class c 160s join pg_namespace n on n.oid = c.relnamespace 160s left join pg_attribute a on c.oid = a.attrelid 160s join pg_type t on t.oid = a.atttypid and attnum > 0 160s left join pg_attrdef def on a.attrelid = def.adrelid 160s and a.attnum = def.adnum 160s and a.atthasdef 160s left join seqattr s on def.adrelid = s.adrelid 160s and def.adnum = s.adnum 160s 160s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 160s and relkind in ('r', 'f', 'p') 160s and ((n.nspname = 'public' and c.relname = 'allcols')) 160s 160s 160s order by nspname, relname, attnum; 160s 2024-11-15T02:51:13.367000Z SQL -- params: including 160s -- filter-list-to-where-clause for including 160s -- excluding 160s -- filter-list-to-where-clause for excluding 160s select n.nspname, 160s i.relname, 160s i.oid, 160s rn.nspname, 160s r.relname, 160s indisprimary, 160s indisunique, 160s (select string_agg(attname, ',') 160s from pg_attribute 160s where attrelid = r.oid 160s and array[attnum::integer] <@ indkey::integer[] 160s ) as cols, 160s pg_get_indexdef(indexrelid), 160s c.conname, 160s pg_get_constraintdef(c.oid) 160s from pg_index x 160s join pg_class i ON i.oid = x.indexrelid 160s join pg_class r ON r.oid = x.indrelid 160s join pg_namespace n ON n.oid = i.relnamespace 160s join pg_namespace rn ON rn.oid = r.relnamespace 160s left join pg_depend d on d.classid = 'pg_class'::regclass 160s and d.objid = i.oid 160s and d.refclassid = 'pg_constraint'::regclass 160s and d.deptype = 'i' 160s left join pg_constraint c ON c.oid = d.refobjid 160s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 160s and ((rn.nspname = 'public' and r.relname = 'allcols')) 160s 160s order by n.nspname, r.relname 160s 2024-11-15T02:51:13.389000Z SQL -- params: including (table) 160s -- filter-list-to-where-clause for including 160s -- excluding (table) 160s -- filter-list-to-where-clause for excluding 160s -- including (ftable) 160s -- filter-list-to-where-clause for including 160s -- excluding (ftable) 160s -- filter-list-to-where-clause for excluding 160s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 160s r.oid, 160s d.refobjid as pkeyoid, 160s conname, 160s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 160s (select string_agg(attname, ',') 160s from pg_attribute 160s where attrelid = r.conrelid 160s and array[attnum::integer] <@ conkey::integer[] 160s ) as conkey, 160s (select string_agg(attname, ',') 160s from pg_attribute 160s where attrelid = r.confrelid 160s and array[attnum::integer] <@ confkey::integer[] 160s ) as confkey, 160s confupdtype, confdeltype, confmatchtype, 160s condeferrable, condeferred 160s from pg_catalog.pg_constraint r 160s JOIN pg_class c on r.conrelid = c.oid 160s JOIN pg_namespace n on c.relnamespace = n.oid 160s JOIN pg_class cf on r.confrelid = cf.oid 160s JOIN pg_namespace nf on cf.relnamespace = nf.oid 160s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 160s and d.objid = r.oid 160s and d.refobjsubid = 0 160s where r.contype = 'f' 160s AND c.relkind in ('r', 'f', 'p') 160s AND cf.relkind in ('r', 'f', 'p') 160s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 160s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 160s and ((n.nspname = 'public' and c.relname = 'allcols')) 160s 160s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 160s 160s 2024-11-15T02:51:13.398000Z SQL -- params pkey-oid-list 160s -- fkey-oild-list 160s with pkeys(oid) as ( 160s values(16391) 160s ), 160s knownfkeys(oid) as ( 160s values(-1) 160s ), 160s pkdeps as ( 160s select pkeys.oid, pg_depend.objid 160s from pg_depend 160s join pkeys on pg_depend.refobjid = pkeys.oid 160s where classid = 'pg_catalog.pg_constraint'::regclass 160s and refclassid = 'pg_catalog.pg_class'::regclass 160s ) 160s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 160s r.oid as conoid, conname, 160s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 160s pkdeps.oid as index_oid 160s from pg_catalog.pg_constraint r 160s JOIN pkdeps on r.oid = pkdeps.objid 160s JOIN pg_class c on r.conrelid = c.oid 160s JOIN pg_namespace n on c.relnamespace = n.oid 160s JOIN pg_class cf on r.confrelid = cf.oid 160s JOIN pg_namespace nf on cf.relnamespace = nf.oid 160s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 160s 2024-11-15T02:51:13.419000Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 160s 2024-11-15T02:51:13.429000Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 160s 2024-11-15T02:51:13.429000Z WARNING That could impact loading performance badly. 160s 2024-11-15T02:51:13.429000Z WARNING Consider the option 'drop indexes'. 160s 2024-11-15T02:51:13.488000Z NOTICE COPY "public"."allcols" with 0 rows estimated [1/4] 160s 2024-11-15T02:51:13.488000Z DEBUG Reader started for "public"."allcols" 160s 2024-11-15T02:51:13.499000Z DEBUG start "public"."allcols" 1351000 160s 2024-11-15T02:51:13.499000Z INFO COPY ON ERROR RESUME NEXT 160s 2024-11-15T02:51:13.499000Z NOTICE Opening (:INLINE 160s (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/allcols.load" . 765)) 160s 2024-11-15T02:51:13.508000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.508000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.508000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.508000Z DEBUG SET standard_conforming_strings TO 'on' 160s 2024-11-15T02:51:13.508000Z DEBUG SET application_name TO 'pgloader' 160s 2024-11-15T02:51:13.508000Z SQL SET search_path TO "public"; 160s 2024-11-15T02:51:13.509000Z INFO pgsql:copy-rows-from-queue[0]: "public"."allcols" ("a" "b" "c") 160s 2024-11-15T02:51:13.517000Z DEBUG Reader for "public"."allcols" is done in 0.029000s 160s 2024-11-15T02:51:13.520000Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.029000s 160s 2024-11-15T02:51:13.522000Z DEBUG send-batch[0] "public"."allcols" 8 rows [ 0.2 kB] in 0.004000s 160s 2024-11-15T02:51:13.522000Z DEBUG stop "public"."allcols" | 1351000 .. 1385000 = 0.034d0 160s 2024-11-15T02:51:13.522000Z DEBUG Writer[0] for "public"."allcols" is done in 0.004000s 160s 2024-11-15T02:51:13.523000Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.004000s 160s 2024-11-15T02:51:13.535000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 160s 2024-11-15T02:51:13.549000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.550000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.550000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.550000Z DEBUG SET standard_conforming_strings TO 'on' 160s 2024-11-15T02:51:13.550000Z DEBUG SET application_name TO 'pgloader' 160s 2024-11-15T02:51:13.551000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/allcols.out") 160s 2024-11-15T02:51:13.564000Z DEBUG CONNECTED TO # 160s 2024-11-15T02:51:13.565000Z DEBUG SET client_encoding TO 'utf8' 160s 2024-11-15T02:51:13.565000Z DEBUG SET work_mem TO '14MB' 160s 2024-11-15T02:51:13.565000Z DEBUG SET standard_conforming_strings TO 'on' 161s 2024-11-15T02:51:13.565000Z DEBUG SET application_name TO 'pgloader' 161s 2024-11-15T02:51:13.565000Z NOTICE drop table if exists expected.allcols; 161s 2024-11-15T02:51:13.566000Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 161s 2024-11-15T02:51:13.566000Z NOTICE create table expected.allcols(like allcols); 161s 2024-11-15T02:51:13.568000Z DEBUG LOAD DATA FROM # 161s 2024-11-15T02:51:13.583000Z DEBUG CONNECTED TO # 161s 2024-11-15T02:51:13.584000Z DEBUG SET client_encoding TO 'utf8' 161s 2024-11-15T02:51:13.584000Z DEBUG SET application_name TO 'pgloader' 161s 2024-11-15T02:51:13.605000Z DEBUG CONNECTED TO # 161s 2024-11-15T02:51:13.606000Z DEBUG SET client_encoding TO 'utf8' 161s 2024-11-15T02:51:13.606000Z DEBUG SET application_name TO 'pgloader' 161s 2024-11-15T02:51:13.606000Z SQL -- 161s -- get user defined SQL types 161s -- 161s select nt.nspname, 161s extname, 161s typname, 161s case when enum.enumtypid is not null 161s then array_agg(enum.enumlabel order by enumsortorder) 161s end as enumvalues 161s 161s from pg_class c 161s join pg_namespace n on n.oid = c.relnamespace 161s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 161s join pg_type t on t.oid = a.atttypid 161s left join pg_namespace nt on nt.oid = t.typnamespace 161s left join pg_depend d on d.classid = 'pg_type'::regclass 161s and d.refclassid = 'pg_extension'::regclass 161s and d.objid = t.oid 161s left join pg_extension e on refobjid = e.oid 161s left join pg_enum enum on enum.enumtypid = t.oid 161s 161s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 161s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 161s and c.relkind in ('r', 'f', 'p') 161s and ((n.nspname = 'expected' and c.relname = 'allcols')) 161s 161s and 161s ( t.typrelid = 0 161s or 161s (select c.relkind = 'c' 161s from pg_class c 161s where c.oid = t.typrelid) 161s ) 161s and not exists 161s ( 161s select 1 161s from pg_type el 161s where el.oid = t.typelem 161s and el.typarray = t.oid 161s ) 161s 161s group by nt.nspname, extname, typname, enumtypid 161s order by nt.nspname, extname, typname, enumtypid; 161s 2024-11-15T02:51:13.612000Z SQL -- params: table-type-name 161s -- including 161s -- filter-list-to-where-clause for including 161s -- excluding 161s -- filter-list-to-where-clause for excluding 161s with seqattr as 161s ( 161s select adrelid, 161s adnum, 161s pg_get_expr(d.adbin, d.adrelid) as adsrc, 161s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 161s then substring(pg_get_expr(d.adbin, d.adrelid) 161s from '''([^'']+)''' 161s ) 161s else null 161s end as seqname 161s from pg_attrdef d 161s ) 161s select nspname, relname, c.oid, attname, 161s t.oid::regtype as type, 161s case when atttypmod > 0 161s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 161s else null 161s end as typmod, 161s attnotnull, 161s case when atthasdef 161s then pg_get_expr(def.adbin, def.adrelid) 161s end as default , 161s case when s.seqname is not null then 'auto_increment' end as extra 161s from pg_class c 161s join pg_namespace n on n.oid = c.relnamespace 161s left join pg_attribute a on c.oid = a.attrelid 161s join pg_type t on t.oid = a.atttypid and attnum > 0 161s left join pg_attrdef def on a.attrelid = def.adrelid 161s and a.attnum = def.adnum 161s and a.atthasdef 161s left join seqattr s on def.adrelid = s.adrelid 161s and def.adnum = s.adnum 161s 161s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 161s and relkind in ('r', 'f', 'p') 161s and ((n.nspname = 'expected' and c.relname = 'allcols')) 161s 161s 161s order by nspname, relname, attnum; 161s 2024-11-15T02:51:13.614000Z SQL -- params: including 161s -- filter-list-to-where-clause for including 161s -- excluding 161s -- filter-list-to-where-clause for excluding 161s select n.nspname, 161s i.relname, 161s i.oid, 161s rn.nspname, 161s r.relname, 161s indisprimary, 161s indisunique, 161s (select string_agg(attname, ',') 161s from pg_attribute 161s where attrelid = r.oid 161s and array[attnum::integer] <@ indkey::integer[] 161s ) as cols, 161s pg_get_indexdef(indexrelid), 161s c.conname, 161s pg_get_constraintdef(c.oid) 161s from pg_index x 161s join pg_class i ON i.oid = x.indexrelid 161s join pg_class r ON r.oid = x.indrelid 161s join pg_namespace n ON n.oid = i.relnamespace 161s join pg_namespace rn ON rn.oid = r.relnamespace 161s left join pg_depend d on d.classid = 'pg_class'::regclass 161s and d.objid = i.oid 161s and d.refclassid = 'pg_constraint'::regclass 161s and d.deptype = 'i' 161s left join pg_constraint c ON c.oid = d.refobjid 161s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 161s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 161s 161s order by n.nspname, r.relname 161s 2024-11-15T02:51:13.616000Z SQL -- params: including (table) 161s -- filter-list-to-where-clause for including 161s -- excluding (table) 161s -- filter-list-to-where-clause for excluding 161s -- including (ftable) 161s -- filter-list-to-where-clause for including 161s -- excluding (ftable) 161s -- filter-list-to-where-clause for excluding 161s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 161s r.oid, 161s d.refobjid as pkeyoid, 161s conname, 161s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 161s (select string_agg(attname, ',') 161s from pg_attribute 161s where attrelid = r.conrelid 161s and array[attnum::integer] <@ conkey::integer[] 161s ) as conkey, 161s (select string_agg(attname, ',') 161s from pg_attribute 161s where attrelid = r.confrelid 161s and array[attnum::integer] <@ confkey::integer[] 161s ) as confkey, 161s confupdtype, confdeltype, confmatchtype, 161s condeferrable, condeferred 161s from pg_catalog.pg_constraint r 161s JOIN pg_class c on r.conrelid = c.oid 161s JOIN pg_namespace n on c.relnamespace = n.oid 161s JOIN pg_class cf on r.confrelid = cf.oid 161s JOIN pg_namespace nf on cf.relnamespace = nf.oid 161s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 161s and d.objid = r.oid 161s and d.refobjsubid = 0 161s where r.contype = 'f' 161s AND c.relkind in ('r', 'f', 'p') 161s AND cf.relkind in ('r', 'f', 'p') 161s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 161s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 161s and ((n.nspname = 'expected' and c.relname = 'allcols')) 161s 161s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 161s 161s 2024-11-15T02:51:13.618000Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 161s 2024-11-15T02:51:13.619000Z SQL TRUNCATE "expected"."allcols"; 161s 2024-11-15T02:51:13.648000Z NOTICE COPY "expected"."allcols" with 0 rows estimated [3/4] 161s 2024-11-15T02:51:13.648000Z DEBUG Reader started for "expected"."allcols" 161s 2024-11-15T02:51:13.648000Z DEBUG start "expected"."allcols" 1511000 161s 2024-11-15T02:51:13.648000Z NOTICE Opening #P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/allcols.out" 161s 2024-11-15T02:51:13.648000Z INFO COPY ON ERROR RESUME NEXT 161s 2024-11-15T02:51:13.648000Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 161s 2024-11-15T02:51:13.648000Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 161s 2024-11-15T02:51:13.661000Z DEBUG CONNECTED TO # 161s 2024-11-15T02:51:13.662000Z DEBUG SET client_encoding TO 'utf8' 161s 2024-11-15T02:51:13.662000Z DEBUG SET application_name TO 'pgloader' 161s 2024-11-15T02:51:13.663000Z SQL SET search_path TO "expected"; 161s 2024-11-15T02:51:13.663000Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 161s 2024-11-15T02:51:13.664000Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.001000s 161s 2024-11-15T02:51:13.664000Z DEBUG stop "expected"."allcols" | 1511000 .. 1527000 = 0.016d0 161s 2024-11-15T02:51:13.664000Z DEBUG Writer[1] for "expected"."allcols" is done in 0.001000s 161s 2024-11-15T02:51:13.664000Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.001000s 161s 2024-11-15T02:51:13.664000Z LOG report summary reset 161s table name errors read imported bytes total time read write 161s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 161s fetch 0 0 0 0.011s 161s before load 0 2 2 0.025s 161s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 161s "public"."allcols" 0 8 8 0.2 kB 0.034s 0.029s 0.004s 161s "expected"."allcols" 0 8 8 0.2 kB 0.016s 0.001s 161s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 161s Files Processed 0 2 2 0.068s 161s COPY Threads Completion 0 4 4 0.050s 161s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 161s Total import time ✓ 16 16 0.4 kB 0.118s 161s 2024-11-15T02:51:13.702000Z DEBUG CONNECTED TO # 161s 2024-11-15T02:51:13.702000Z DEBUG SET client_encoding TO 'utf8' 161s 2024-11-15T02:51:13.702000Z DEBUG SET work_mem TO '14MB' 161s 2024-11-15T02:51:13.702000Z DEBUG SET standard_conforming_strings TO 'on' 161s 2024-11-15T02:51:13.702000Z DEBUG SET application_name TO 'pgloader' 161s 2024-11-15T02:51:13.702000Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 161s 2024-11-15T02:51:13.702000Z NOTICE Got a diff of 0 rows 161s 2024-11-15T02:51:13.702000Z LOG Regress pass. 161s 2024-11-15T02:51:13.702000Z INFO Stopping monitor 161s + rm -rf /tmp/pgloader 161s + PGSSLMODE=require 161s + pgloader --debug --regress test/allcols.load 161s mkdir -p #P"/tmp/pgloader/" 161s pgloader version 3.6.10~devel 161s compiled with SBCL 2.2.9.debian 161s sb-impl::*default-external-format* :UTF-8 161s tmpdir: #P"/tmp/pgloader/" 161s 2024-11-15T02:51:14.009000Z NOTICE Starting pgloader, log system is ready. 161s 2024-11-15T02:51:14.031000Z INFO Starting monitor 161s 2024-11-15T02:51:14.039000Z LOG pgloader version "3.6.10~devel" 162s 2024-11-15T02:51:14.128000Z INFO Parsed command: 162s /* 162s * This test is ported from pgloader 2.x where it was defined as: 162s * 162s * [allcols] 162s * table = allcols 162s * format = csv 162s * filename = allcols/allcols.data 162s * field_sep = : 162s * columns = * 162s * pg_option_work_mem = 14MB 162s * 162s */ 162s 162s LOAD CSV 162s FROM inline (a, b, c) 162s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 162s 162s WITH fields optionally enclosed by '"', 162s fields escaped by double-quote, 162s fields terminated by ':' 162s 162s SET client_encoding to 'latin1', 162s work_mem to '14MB', 162s standard_conforming_strings to 'on' 162s 162s BEFORE LOAD DO 162s $$ drop table if exists allcols; $$, 162s $$ create table allcols ( 162s a integer primary key, 162s b date, 162s c text 162s ); 162s $$; 162s 162s 162s 162s 162s 162s 2024-11-15T02:51:14.136000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 162s 2024-11-15T02:51:14.368000Z DEBUG CONNECTED TO # 162s 2024-11-15T02:51:14.368000Z DEBUG SET client_encoding TO 'utf8' 162s 2024-11-15T02:51:14.368000Z DEBUG SET work_mem TO '14MB' 162s 2024-11-15T02:51:14.368000Z DEBUG SET standard_conforming_strings TO 'on' 162s 2024-11-15T02:51:14.368000Z DEBUG SET application_name TO 'pgloader' 162s 2024-11-15T02:51:14.390000Z NOTICE Executing SQL block for before load 162s 2024-11-15T02:51:14.508000Z DEBUG CONNECTED TO # 162s 2024-11-15T02:51:14.508000Z DEBUG SET client_encoding TO 'utf8' 162s 2024-11-15T02:51:14.508000Z DEBUG SET work_mem TO '14MB' 162s 2024-11-15T02:51:14.509000Z DEBUG SET standard_conforming_strings TO 'on' 162s 2024-11-15T02:51:14.509000Z DEBUG SET application_name TO 'pgloader' 162s 2024-11-15T02:51:14.519000Z DEBUG BEGIN 162s 2024-11-15T02:51:14.520000Z SQL drop table if exists allcols; 162s 2024-11-15T02:51:14.522000Z SQL create table allcols ( 162s a integer primary key, 162s b date, 162s c text 162s ); 162s 2024-11-15T02:51:14.653000Z DEBUG CONNECTED TO # 162s 2024-11-15T02:51:14.653000Z DEBUG SET client_encoding TO 'utf8' 162s 2024-11-15T02:51:14.654000Z DEBUG SET work_mem TO '14MB' 162s 2024-11-15T02:51:14.654000Z DEBUG SET standard_conforming_strings TO 'on' 162s 2024-11-15T02:51:14.654000Z DEBUG SET application_name TO 'pgloader' 162s 2024-11-15T02:51:14.667000Z SQL -- 162s -- get user defined SQL types 162s -- 162s select nt.nspname, 162s extname, 162s typname, 162s case when enum.enumtypid is not null 162s then array_agg(enum.enumlabel order by enumsortorder) 162s end as enumvalues 162s 162s from pg_class c 162s join pg_namespace n on n.oid = c.relnamespace 162s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 162s join pg_type t on t.oid = a.atttypid 162s left join pg_namespace nt on nt.oid = t.typnamespace 162s left join pg_depend d on d.classid = 'pg_type'::regclass 162s and d.refclassid = 'pg_extension'::regclass 162s and d.objid = t.oid 162s left join pg_extension e on refobjid = e.oid 162s left join pg_enum enum on enum.enumtypid = t.oid 162s 162s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 162s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 162s and c.relkind in ('r', 'f', 'p') 162s and ((n.nspname = 'public' and c.relname = 'allcols')) 162s 162s and 162s ( t.typrelid = 0 162s or 162s (select c.relkind = 'c' 162s from pg_class c 162s where c.oid = t.typrelid) 162s ) 162s and not exists 162s ( 162s select 1 162s from pg_type el 162s where el.oid = t.typelem 162s and el.typarray = t.oid 162s ) 162s 162s group by nt.nspname, extname, typname, enumtypid 162s order by nt.nspname, extname, typname, enumtypid; 162s 2024-11-15T02:51:14.672000Z SQL -- params: table-type-name 162s -- including 162s -- filter-list-to-where-clause for including 162s -- excluding 162s -- filter-list-to-where-clause for excluding 162s with seqattr as 162s ( 162s select adrelid, 162s adnum, 162s pg_get_expr(d.adbin, d.adrelid) as adsrc, 162s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 162s then substring(pg_get_expr(d.adbin, d.adrelid) 162s from '''([^'']+)''' 162s ) 162s else null 162s end as seqname 162s from pg_attrdef d 162s ) 162s select nspname, relname, c.oid, attname, 162s t.oid::regtype as type, 162s case when atttypmod > 0 162s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 162s else null 162s end as typmod, 162s attnotnull, 162s case when atthasdef 162s then pg_get_expr(def.adbin, def.adrelid) 162s end as default , 162s case when s.seqname is not null then 'auto_increment' end as extra 162s from pg_class c 162s join pg_namespace n on n.oid = c.relnamespace 162s left join pg_attribute a on c.oid = a.attrelid 162s join pg_type t on t.oid = a.atttypid and attnum > 0 162s left join pg_attrdef def on a.attrelid = def.adrelid 162s and a.attnum = def.adnum 162s and a.atthasdef 162s left join seqattr s on def.adrelid = s.adrelid 162s and def.adnum = s.adnum 162s 162s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 162s and relkind in ('r', 'f', 'p') 162s and ((n.nspname = 'public' and c.relname = 'allcols')) 162s 162s 162s order by nspname, relname, attnum; 162s 2024-11-15T02:51:14.695000Z SQL -- params: including 162s -- filter-list-to-where-clause for including 162s -- excluding 162s -- filter-list-to-where-clause for excluding 162s select n.nspname, 162s i.relname, 162s i.oid, 162s rn.nspname, 162s r.relname, 162s indisprimary, 162s indisunique, 162s (select string_agg(attname, ',') 162s from pg_attribute 162s where attrelid = r.oid 162s and array[attnum::integer] <@ indkey::integer[] 162s ) as cols, 162s pg_get_indexdef(indexrelid), 162s c.conname, 162s pg_get_constraintdef(c.oid) 162s from pg_index x 162s join pg_class i ON i.oid = x.indexrelid 162s join pg_class r ON r.oid = x.indrelid 162s join pg_namespace n ON n.oid = i.relnamespace 162s join pg_namespace rn ON rn.oid = r.relnamespace 162s left join pg_depend d on d.classid = 'pg_class'::regclass 162s and d.objid = i.oid 162s and d.refclassid = 'pg_constraint'::regclass 162s and d.deptype = 'i' 162s left join pg_constraint c ON c.oid = d.refobjid 162s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 162s and ((rn.nspname = 'public' and r.relname = 'allcols')) 162s 162s order by n.nspname, r.relname 162s 2024-11-15T02:51:14.709000Z SQL -- params: including (table) 162s -- filter-list-to-where-clause for including 162s -- excluding (table) 162s -- filter-list-to-where-clause for excluding 162s -- including (ftable) 162s -- filter-list-to-where-clause for including 162s -- excluding (ftable) 162s -- filter-list-to-where-clause for excluding 162s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 162s r.oid, 162s d.refobjid as pkeyoid, 162s conname, 162s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 162s (select string_agg(attname, ',') 162s from pg_attribute 162s where attrelid = r.conrelid 162s and array[attnum::integer] <@ conkey::integer[] 162s ) as conkey, 162s (select string_agg(attname, ',') 162s from pg_attribute 162s where attrelid = r.confrelid 162s and array[attnum::integer] <@ confkey::integer[] 162s ) as confkey, 162s confupdtype, confdeltype, confmatchtype, 162s condeferrable, condeferred 162s from pg_catalog.pg_constraint r 162s JOIN pg_class c on r.conrelid = c.oid 162s JOIN pg_namespace n on c.relnamespace = n.oid 162s JOIN pg_class cf on r.confrelid = cf.oid 162s JOIN pg_namespace nf on cf.relnamespace = nf.oid 162s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 162s and d.objid = r.oid 162s and d.refobjsubid = 0 162s where r.contype = 'f' 162s AND c.relkind in ('r', 'f', 'p') 162s AND cf.relkind in ('r', 'f', 'p') 162s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 162s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 162s and ((n.nspname = 'public' and c.relname = 'allcols')) 162s 162s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 162s 162s 2024-11-15T02:51:14.715000Z SQL -- params pkey-oid-list 162s -- fkey-oild-list 162s with pkeys(oid) as ( 162s values(16406) 162s ), 162s knownfkeys(oid) as ( 162s values(-1) 162s ), 162s pkdeps as ( 162s select pkeys.oid, pg_depend.objid 162s from pg_depend 162s join pkeys on pg_depend.refobjid = pkeys.oid 162s where classid = 'pg_catalog.pg_constraint'::regclass 162s and refclassid = 'pg_catalog.pg_class'::regclass 162s ) 162s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 162s r.oid as conoid, conname, 162s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 162s pkdeps.oid as index_oid 162s from pg_catalog.pg_constraint r 162s JOIN pkdeps on r.oid = pkdeps.objid 162s JOIN pg_class c on r.conrelid = c.oid 162s JOIN pg_namespace n on c.relnamespace = n.oid 162s JOIN pg_class cf on r.confrelid = cf.oid 162s JOIN pg_namespace nf on cf.relnamespace = nf.oid 162s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 162s 2024-11-15T02:51:14.727000Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 162s 2024-11-15T02:51:14.731000Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 162s 2024-11-15T02:51:14.731000Z WARNING That could impact loading performance badly. 162s 2024-11-15T02:51:14.731000Z WARNING Consider the option 'drop indexes'. 162s 2024-11-15T02:51:14.758000Z NOTICE COPY "public"."allcols" with 0 rows estimated [0/4] 162s 2024-11-15T02:51:14.758000Z DEBUG Reader started for "public"."allcols" 162s 2024-11-15T02:51:14.765000Z DEBUG start "public"."allcols" 1513000 162s 2024-11-15T02:51:14.765000Z INFO COPY ON ERROR RESUME NEXT 162s 2024-11-15T02:51:14.769000Z NOTICE Opening (:INLINE 162s (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/allcols.load" . 765)) 162s 2024-11-15T02:51:14.785000Z DEBUG Reader for "public"."allcols" is done in 0.027000s 162s 2024-11-15T02:51:14.785000Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.027000s 162s 2024-11-15T02:51:14.850000Z DEBUG CONNECTED TO # 162s 2024-11-15T02:51:14.851000Z DEBUG SET client_encoding TO 'utf8' 162s 2024-11-15T02:51:14.851000Z DEBUG SET work_mem TO '14MB' 162s 2024-11-15T02:51:14.851000Z DEBUG SET standard_conforming_strings TO 'on' 162s 2024-11-15T02:51:14.852000Z DEBUG SET application_name TO 'pgloader' 162s 2024-11-15T02:51:14.853000Z SQL SET search_path TO "public"; 162s 2024-11-15T02:51:14.854000Z INFO pgsql:copy-rows-from-queue[3]: "public"."allcols" ("a" "b" "c") 162s 2024-11-15T02:51:14.858000Z DEBUG send-batch[3] "public"."allcols" 8 rows [ 0.2 kB] in 0.004000s 162s 2024-11-15T02:51:14.860000Z DEBUG stop "public"."allcols" | 1513000 .. 1615000 = 0.102d0 162s 2024-11-15T02:51:14.860000Z DEBUG Writer[3] for "public"."allcols" is done in 0.005000s 162s 2024-11-15T02:51:14.860000Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.005000s 162s 2024-11-15T02:51:14.875000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 162s 2024-11-15T02:51:14.990000Z DEBUG CONNECTED TO # 162s 2024-11-15T02:51:14.990000Z DEBUG SET client_encoding TO 'utf8' 162s 2024-11-15T02:51:14.991000Z DEBUG SET work_mem TO '14MB' 162s 2024-11-15T02:51:14.991000Z DEBUG SET standard_conforming_strings TO 'on' 162s 2024-11-15T02:51:14.992000Z DEBUG SET application_name TO 'pgloader' 162s 2024-11-15T02:51:15.000000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/allcols.out") 163s 2024-11-15T02:51:15.088000Z DEBUG CONNECTED TO # 163s 2024-11-15T02:51:15.088000Z DEBUG SET client_encoding TO 'utf8' 163s 2024-11-15T02:51:15.088000Z DEBUG SET work_mem TO '14MB' 163s 2024-11-15T02:51:15.089000Z DEBUG SET standard_conforming_strings TO 'on' 163s 2024-11-15T02:51:15.089000Z DEBUG SET application_name TO 'pgloader' 163s 2024-11-15T02:51:15.090000Z NOTICE drop table if exists expected.allcols; 163s 2024-11-15T02:51:15.092000Z NOTICE create table expected.allcols(like allcols); 163s 2024-11-15T02:51:15.096000Z DEBUG LOAD DATA FROM # 163s 2024-11-15T02:51:15.191000Z DEBUG CONNECTED TO # 163s 2024-11-15T02:51:15.191000Z DEBUG SET client_encoding TO 'utf8' 163s 2024-11-15T02:51:15.191000Z DEBUG SET application_name TO 'pgloader' 163s 2024-11-15T02:51:15.290000Z DEBUG CONNECTED TO # 163s 2024-11-15T02:51:15.290000Z DEBUG SET client_encoding TO 'utf8' 163s 2024-11-15T02:51:15.291000Z DEBUG SET application_name TO 'pgloader' 163s 2024-11-15T02:51:15.293000Z SQL -- 163s -- get user defined SQL types 163s -- 163s select nt.nspname, 163s extname, 163s typname, 163s case when enum.enumtypid is not null 163s then array_agg(enum.enumlabel order by enumsortorder) 163s end as enumvalues 163s 163s from pg_class c 163s join pg_namespace n on n.oid = c.relnamespace 163s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 163s join pg_type t on t.oid = a.atttypid 163s left join pg_namespace nt on nt.oid = t.typnamespace 163s left join pg_depend d on d.classid = 'pg_type'::regclass 163s and d.refclassid = 'pg_extension'::regclass 163s and d.objid = t.oid 163s left join pg_extension e on refobjid = e.oid 163s left join pg_enum enum on enum.enumtypid = t.oid 163s 163s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 163s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 163s and c.relkind in ('r', 'f', 'p') 163s and ((n.nspname = 'expected' and c.relname = 'allcols')) 163s 163s and 163s ( t.typrelid = 0 163s or 163s (select c.relkind = 'c' 163s from pg_class c 163s where c.oid = t.typrelid) 163s ) 163s and not exists 163s ( 163s select 1 163s from pg_type el 163s where el.oid = t.typelem 163s and el.typarray = t.oid 163s ) 163s 163s group by nt.nspname, extname, typname, enumtypid 163s order by nt.nspname, extname, typname, enumtypid; 163s 2024-11-15T02:51:15.305000Z SQL -- params: table-type-name 163s -- including 163s -- filter-list-to-where-clause for including 163s -- excluding 163s -- filter-list-to-where-clause for excluding 163s with seqattr as 163s ( 163s select adrelid, 163s adnum, 163s pg_get_expr(d.adbin, d.adrelid) as adsrc, 163s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 163s then substring(pg_get_expr(d.adbin, d.adrelid) 163s from '''([^'']+)''' 163s ) 163s else null 163s end as seqname 163s from pg_attrdef d 163s ) 163s select nspname, relname, c.oid, attname, 163s t.oid::regtype as type, 163s case when atttypmod > 0 163s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 163s else null 163s end as typmod, 163s attnotnull, 163s case when atthasdef 163s then pg_get_expr(def.adbin, def.adrelid) 163s end as default , 163s case when s.seqname is not null then 'auto_increment' end as extra 163s from pg_class c 163s join pg_namespace n on n.oid = c.relnamespace 163s left join pg_attribute a on c.oid = a.attrelid 163s join pg_type t on t.oid = a.atttypid and attnum > 0 163s left join pg_attrdef def on a.attrelid = def.adrelid 163s and a.attnum = def.adnum 163s and a.atthasdef 163s left join seqattr s on def.adrelid = s.adrelid 163s and def.adnum = s.adnum 163s 163s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 163s and relkind in ('r', 'f', 'p') 163s and ((n.nspname = 'expected' and c.relname = 'allcols')) 163s 163s 163s order by nspname, relname, attnum; 163s 2024-11-15T02:51:15.311000Z SQL -- params: including 163s -- filter-list-to-where-clause for including 163s -- excluding 163s -- filter-list-to-where-clause for excluding 163s select n.nspname, 163s i.relname, 163s i.oid, 163s rn.nspname, 163s r.relname, 163s indisprimary, 163s indisunique, 163s (select string_agg(attname, ',') 163s from pg_attribute 163s where attrelid = r.oid 163s and array[attnum::integer] <@ indkey::integer[] 163s ) as cols, 163s pg_get_indexdef(indexrelid), 163s c.conname, 163s pg_get_constraintdef(c.oid) 163s from pg_index x 163s join pg_class i ON i.oid = x.indexrelid 163s join pg_class r ON r.oid = x.indrelid 163s join pg_namespace n ON n.oid = i.relnamespace 163s join pg_namespace rn ON rn.oid = r.relnamespace 163s left join pg_depend d on d.classid = 'pg_class'::regclass 163s and d.objid = i.oid 163s and d.refclassid = 'pg_constraint'::regclass 163s and d.deptype = 'i' 163s left join pg_constraint c ON c.oid = d.refobjid 163s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 163s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 163s 163s order by n.nspname, r.relname 163s 2024-11-15T02:51:15.317000Z SQL -- params: including (table) 163s -- filter-list-to-where-clause for including 163s -- excluding (table) 163s -- filter-list-to-where-clause for excluding 163s -- including (ftable) 163s -- filter-list-to-where-clause for including 163s -- excluding (ftable) 163s -- filter-list-to-where-clause for excluding 163s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 163s r.oid, 163s d.refobjid as pkeyoid, 163s conname, 163s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 163s (select string_agg(attname, ',') 163s from pg_attribute 163s where attrelid = r.conrelid 163s and array[attnum::integer] <@ conkey::integer[] 163s ) as conkey, 163s (select string_agg(attname, ',') 163s from pg_attribute 163s where attrelid = r.confrelid 163s and array[attnum::integer] <@ confkey::integer[] 163s ) as confkey, 163s confupdtype, confdeltype, confmatchtype, 163s condeferrable, condeferred 163s from pg_catalog.pg_constraint r 163s JOIN pg_class c on r.conrelid = c.oid 163s JOIN pg_namespace n on c.relnamespace = n.oid 163s JOIN pg_class cf on r.confrelid = cf.oid 163s JOIN pg_namespace nf on cf.relnamespace = nf.oid 163s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 163s and d.objid = r.oid 163s and d.refobjsubid = 0 163s where r.contype = 'f' 163s AND c.relkind in ('r', 'f', 'p') 163s AND cf.relkind in ('r', 'f', 'p') 163s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 163s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 163s and ((n.nspname = 'expected' and c.relname = 'allcols')) 163s 163s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 163s 163s 2024-11-15T02:51:15.321000Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 163s 2024-11-15T02:51:15.321000Z SQL TRUNCATE "expected"."allcols"; 163s 2024-11-15T02:51:15.352000Z NOTICE COPY "expected"."allcols" with 0 rows estimated [3/4] 163s 2024-11-15T02:51:15.352000Z DEBUG Reader started for "expected"."allcols" 163s 2024-11-15T02:51:15.352000Z DEBUG start "expected"."allcols" 2107000 163s 2024-11-15T02:51:15.352000Z NOTICE Opening #P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/allcols.out" 163s 2024-11-15T02:51:15.352000Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 163s 2024-11-15T02:51:15.352000Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 163s 2024-11-15T02:51:15.355000Z INFO COPY ON ERROR RESUME NEXT 163s 2024-11-15T02:51:15.442000Z DEBUG CONNECTED TO # 163s 2024-11-15T02:51:15.442000Z DEBUG SET client_encoding TO 'utf8' 163s 2024-11-15T02:51:15.443000Z DEBUG SET application_name TO 'pgloader' 163s 2024-11-15T02:51:15.445000Z SQL SET search_path TO "expected"; 163s 2024-11-15T02:51:15.447000Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 163s 2024-11-15T02:51:15.450000Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.004000s 163s 2024-11-15T02:51:15.453000Z DEBUG stop "expected"."allcols" | 2107000 .. 2207000 = 0.1d0 163s 2024-11-15T02:51:15.454000Z DEBUG Writer[1] for "expected"."allcols" is done in 0.004000s 163s 2024-11-15T02:51:15.454000Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.004000s 163s 2024-11-15T02:51:15.454000Z LOG report summary reset 163s table name errors read imported bytes total time read write 163s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 163s fetch 0 0 0 0.011s 163s before load 0 2 2 0.137s 163s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 163s "public"."allcols" 0 8 8 0.2 kB 0.102s 0.027s 0.005s 163s "expected"."allcols" 0 8 8 0.2 kB 0.100s 0.004s 163s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 163s Files Processed 0 2 2 0.036s 163s COPY Threads Completion 0 4 4 0.201s 163s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 163s Total import time ✓ 16 16 0.4 kB 0.237s 163s 2024-11-15T02:51:15.555000Z DEBUG CONNECTED TO # 163s 2024-11-15T02:51:15.555000Z DEBUG SET client_encoding TO 'utf8' 163s 2024-11-15T02:51:15.556000Z DEBUG SET work_mem TO '14MB' 163s 2024-11-15T02:51:15.556000Z DEBUG SET standard_conforming_strings TO 'on' 163s 2024-11-15T02:51:15.557000Z DEBUG SET application_name TO 'pgloader' 163s 2024-11-15T02:51:15.568000Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 163s 2024-11-15T02:51:15.569000Z NOTICE Got a diff of 0 rows 163s 2024-11-15T02:51:15.569000Z LOG Regress pass. 163s 2024-11-15T02:51:15.573000Z INFO Stopping monitor 163s Dropping cluster 17/regress ... 164s + rm -rf /tmp/pgloader 165s autopkgtest [02:51:18]: test ssl: -----------------------] 165s autopkgtest [02:51:18]: test ssl: - - - - - - - - - - results - - - - - - - - - - 165s ssl PASS 166s autopkgtest [02:51:19]: test testsuite: preparing testbed 287s autopkgtest [02:53:20]: testbed dpkg architecture: arm64 287s autopkgtest [02:53:20]: testbed apt version: 2.9.8 287s autopkgtest [02:53:20]: @@@@@@@@@@@@@@@@@@@@ test bed setup 288s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 289s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1030 kB] 289s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 289s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 289s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 289s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [164 kB] 289s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [50.3 kB] 289s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [773 kB] 289s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [6116 B] 291s Fetched 2220 kB in 1s (2533 kB/s) 291s Reading package lists... 293s Reading package lists... 293s Building dependency tree... 293s Reading state information... 294s Calculating upgrade... 294s The following packages will be upgraded: 294s firmware-sof-signed libcap-ng0 libexpat1 lxd-installer man-db pastebinit 294s python3-systemd xfsprogs 294s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 294s Need to get 9481 kB of archives. 294s After this operation, 549 kB of additional disk space will be used. 294s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 295s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libcap-ng0 arm64 0.8.5-3build1 [15.0 kB] 295s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libexpat1 arm64 2.6.4-1 [76.6 kB] 295s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 man-db arm64 2.13.0-1 [1320 kB] 295s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 lxd-installer all 9 [5084 B] 295s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 pastebinit all 1.7.1-1 [14.9 kB] 295s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-systemd arm64 235-1build5 [46.7 kB] 295s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 xfsprogs arm64 6.8.0-2.2ubuntu2 [919 kB] 295s Preconfiguring packages ... 295s Fetched 9481 kB in 1s (9856 kB/s) 296s (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 ... 79925 files and directories currently installed.) 296s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 296s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 296s Preparing to unpack .../libcap-ng0_0.8.5-3build1_arm64.deb ... 296s Unpacking libcap-ng0:arm64 (0.8.5-3build1) over (0.8.5-1) ... 296s Setting up libcap-ng0:arm64 (0.8.5-3build1) ... 296s (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 ... 79951 files and directories currently installed.) 296s Preparing to unpack .../0-libexpat1_2.6.4-1_arm64.deb ... 296s Unpacking libexpat1:arm64 (2.6.4-1) over (2.6.2-2) ... 296s Preparing to unpack .../1-man-db_2.13.0-1_arm64.deb ... 296s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 296s Preparing to unpack .../2-lxd-installer_9_all.deb ... 296s Unpacking lxd-installer (9) over (8) ... 296s Preparing to unpack .../3-pastebinit_1.7.1-1_all.deb ... 296s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 297s Preparing to unpack .../4-python3-systemd_235-1build5_arm64.deb ... 297s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 297s Preparing to unpack .../5-xfsprogs_6.8.0-2.2ubuntu2_arm64.deb ... 297s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 297s Setting up libexpat1:arm64 (2.6.4-1) ... 297s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 297s Setting up pastebinit (1.7.1-1) ... 297s Setting up man-db (2.13.0-1) ... 297s Updating database of manual pages ... 299s man-db.service is a disabled or a static unit not running, not starting it. 299s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 299s update-initramfs: deferring update (trigger activated) 300s Setting up lxd-installer (9) ... 300s Setting up python3-systemd (235-1build5) ... 301s Processing triggers for libc-bin (2.40-1ubuntu3) ... 301s Processing triggers for initramfs-tools (0.142ubuntu34) ... 301s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 301s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 321s System running in EFI mode, skipping. 321s Reading package lists... 321s Building dependency tree... 321s Reading state information... 322s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 322s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 322s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 323s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 323s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 324s Reading package lists... 324s Reading package lists... 324s Building dependency tree... 324s Reading state information... 325s Calculating upgrade... 325s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 325s Reading package lists... 326s Building dependency tree... 326s Reading state information... 326s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 326s autopkgtest [02:53:59]: rebooting testbed after setup commands that affected boot 330s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 360s Reading package lists... 360s Building dependency tree... 360s Reading state information... 360s Starting pkgProblemResolver with broken count: 0 360s Starting 2 pkgProblemResolver with broken count: 0 360s Done 361s The following additional packages will be installed: 361s freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 361s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql-17 361s postgresql-17-ip4r postgresql-client-17 postgresql-client-common 361s postgresql-common ssl-cert 361s Suggested packages: 361s postgresql-doc-17 361s Recommended packages: 361s freetds-doc libjson-xs-perl 361s The following NEW packages will be installed: 361s autopkgtest-satdep freetds-common freetds-dev libct4 libio-pty-perl 361s libipc-run-perl libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader 361s postgresql-17 postgresql-17-ip4r postgresql-client-17 361s postgresql-client-common postgresql-common ssl-cert 361s 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. 361s Need to get 47.1 MB/47.1 MB of archives. 361s After this operation, 107 MB of additional disk space will be used. 361s Get:1 /tmp/autopkgtest.C0mysu/2-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [728 B] 361s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 362s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 362s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 362s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-client-common all 266 [37.0 kB] 362s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 362s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-common all 266 [162 kB] 362s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 362s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libct4 arm64 1.3.17+ds-2build3 [163 kB] 362s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libsybdb5 arm64 1.3.17+ds-2build3 [186 kB] 362s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 freetds-dev arm64 1.3.17+ds-2build3 [300 kB] 362s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.0-1 [248 kB] 362s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu1 [167 kB] 362s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.0-1 [2102 kB] 362s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.0-1 [17.7 MB] 362s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 postgresql-17-ip4r arm64 2.4.2-3 [190 kB] 362s Get:17 http://ftpmaster.internal/ubuntu plucky/universe arm64 pgloader arm64 3.6.10-4 [25.6 MB] 364s Preconfiguring packages ... 364s Fetched 47.1 MB in 2s (24.7 MB/s) 364s Selecting previously unselected package libjson-perl. 364s (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 ... 79957 files and directories currently installed.) 364s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 364s Unpacking libjson-perl (4.10000-1) ... 364s Selecting previously unselected package libio-pty-perl. 364s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 364s Unpacking libio-pty-perl (1:1.20-1build3) ... 364s Selecting previously unselected package libipc-run-perl. 364s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 364s Unpacking libipc-run-perl (20231003.0-2) ... 364s Selecting previously unselected package postgresql-client-common. 364s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 364s Unpacking postgresql-client-common (266) ... 364s Selecting previously unselected package ssl-cert. 364s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 364s Unpacking ssl-cert (1.1.2ubuntu2) ... 364s Selecting previously unselected package postgresql-common. 364s Preparing to unpack .../05-postgresql-common_266_all.deb ... 364s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 364s Unpacking postgresql-common (266) ... 364s Selecting previously unselected package freetds-common. 364s Preparing to unpack .../06-freetds-common_1.3.17+ds-2build3_all.deb ... 364s Unpacking freetds-common (1.3.17+ds-2build3) ... 364s Selecting previously unselected package libct4:arm64. 364s Preparing to unpack .../07-libct4_1.3.17+ds-2build3_arm64.deb ... 364s Unpacking libct4:arm64 (1.3.17+ds-2build3) ... 364s Selecting previously unselected package libsybdb5:arm64. 364s Preparing to unpack .../08-libsybdb5_1.3.17+ds-2build3_arm64.deb ... 364s Unpacking libsybdb5:arm64 (1.3.17+ds-2build3) ... 364s Selecting previously unselected package freetds-dev. 364s Preparing to unpack .../09-freetds-dev_1.3.17+ds-2build3_arm64.deb ... 364s Unpacking freetds-dev (1.3.17+ds-2build3) ... 364s Selecting previously unselected package libpq5:arm64. 364s Preparing to unpack .../10-libpq5_17.0-1_arm64.deb ... 364s Unpacking libpq5:arm64 (17.0-1) ... 364s Selecting previously unselected package libxslt1.1:arm64. 364s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu1_arm64.deb ... 364s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 364s Selecting previously unselected package postgresql-client-17. 364s Preparing to unpack .../12-postgresql-client-17_17.0-1_arm64.deb ... 364s Unpacking postgresql-client-17 (17.0-1) ... 365s Selecting previously unselected package postgresql-17. 365s Preparing to unpack .../13-postgresql-17_17.0-1_arm64.deb ... 365s Unpacking postgresql-17 (17.0-1) ... 365s Selecting previously unselected package postgresql-17-ip4r. 365s Preparing to unpack .../14-postgresql-17-ip4r_2.4.2-3_arm64.deb ... 365s Unpacking postgresql-17-ip4r (2.4.2-3) ... 365s Selecting previously unselected package pgloader. 365s Preparing to unpack .../15-pgloader_3.6.10-4_arm64.deb ... 365s Unpacking pgloader (3.6.10-4) ... 365s Selecting previously unselected package autopkgtest-satdep. 365s Preparing to unpack .../16-2-autopkgtest-satdep.deb ... 365s Unpacking autopkgtest-satdep (0) ... 365s Setting up libio-pty-perl (1:1.20-1build3) ... 365s Setting up libpq5:arm64 (17.0-1) ... 365s Setting up ssl-cert (1.1.2ubuntu2) ... 366s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 366s Setting up libipc-run-perl (20231003.0-2) ... 366s Setting up libjson-perl (4.10000-1) ... 366s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 366s Setting up freetds-common (1.3.17+ds-2build3) ... 366s Setting up postgresql-client-common (266) ... 366s Setting up postgresql-client-17 (17.0-1) ... 367s 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 367s Setting up libsybdb5:arm64 (1.3.17+ds-2build3) ... 367s Setting up libct4:arm64 (1.3.17+ds-2build3) ... 367s Setting up postgresql-common (266) ... 367s 367s Creating config file /etc/postgresql-common/createcluster.conf with new version 367s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 367s Removing obsolete dictionary files: 368s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 368s Setting up postgresql-17 (17.0-1) ... 368s Creating new PostgreSQL cluster 17/main ... 368s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 368s The files belonging to this database system will be owned by user "postgres". 368s This user must also own the server process. 368s 368s The database cluster will be initialized with locale "C.UTF-8". 368s The default database encoding has accordingly been set to "UTF8". 368s The default text search configuration will be set to "english". 368s 368s Data page checksums are disabled. 368s 368s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 368s creating subdirectories ... ok 368s selecting dynamic shared memory implementation ... posix 369s selecting default "max_connections" ... 100 369s selecting default "shared_buffers" ... 128MB 369s selecting default time zone ... Etc/UTC 369s creating configuration files ... ok 369s running bootstrap script ... ok 369s performing post-bootstrap initialization ... ok 369s syncing data to disk ... ok 373s Setting up freetds-dev (1.3.17+ds-2build3) ... 373s Setting up postgresql-17-ip4r (2.4.2-3) ... 373s Setting up pgloader (3.6.10-4) ... 373s Setting up autopkgtest-satdep (0) ... 373s Processing triggers for man-db (2.13.0-1) ... 374s Processing triggers for libc-bin (2.40-1ubuntu3) ... 377s (Reading database ... 82494 files and directories currently installed.) 377s Removing autopkgtest-satdep (0) ... 380s autopkgtest [02:54:53]: test testsuite: [----------------------- 380s + PGSUPERUSER=ubuntu 380s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 380s Creating new PostgreSQL cluster 17/regress ... 383s make: Entering directory '/tmp/autopkgtest.C0mysu/build.mwh/src/test' 383s dropdb -U ubuntu pgloader 383s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 383s dropdb -U ubuntu stocks 383s make: [Makefile:67: prepare] Error 1 (ignored) 383s dropdb: error: database removal failed: ERROR: database "stocks" does not exist 383s dropdb -U ubuntu ip4r 383s make: [Makefile:68: prepare] Error 1 (ignored) 383s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 383s createuser -U ubuntu --superuser `whoami` 383s make: [Makefile:69: prepare] Error 1 (ignored) 383s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 383s make: [Makefile:70: prepare] Error 1 (ignored) 383s createdb -U ubuntu -O `whoami` pgloader 383s createdb -U ubuntu -O `whoami` stocks 383s createdb -U ubuntu -O `whoami` ip4r 383s psql -d pgloader -c 'create schema expected' 384s CREATE SCHEMA 384s psql -U ubuntu -d pgloader -c 'create extension ip4r' 384s CREATE EXTENSION 384s psql -U ubuntu -d ip4r -c 'create extension ip4r' 384s CREATE EXTENSION 384s psql -d stocks -f bossa.sql 384s DROP TABLE 384s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 384s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 384s CREATE TABLE 384s CREATE TABLE 384s rm -f regress/out/* 384s pgloader --regress allcols.load 384s 2024-11-15T02:54:57.028000Z LOG pgloader version "3.6.10~devel" 385s 2024-11-15T02:54:57.134000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-11-15T02:54:57.426000Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 385s 2024-11-15T02:54:57.426000Z WARNING That could impact loading performance badly. 385s 2024-11-15T02:54:57.426000Z WARNING Consider the option 'drop indexes'. 385s 2024-11-15T02:54:57.536000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 385s 2024-11-15T02:54:57.555000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/allcols.out") 385s 2024-11-15T02:54:57.568000Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 385s 2024-11-15T02:54:57.670000Z LOG report summary reset 385s table name errors rows bytes total time 385s ----------------------- --------- --------- --------- -------------- 385s fetch 0 0 0.010s 385s before load 0 2 0.024s 385s ----------------------- --------- --------- --------- -------------- 385s "public"."allcols" 0 8 0.2 kB 0.032s 385s "expected"."allcols" 0 8 0.2 kB 0.020s 385s ----------------------- --------- --------- --------- -------------- 385s Files Processed 0 2 0.069s 385s COPY Threads Completion 0 4 0.053s 385s ----------------------- --------- --------- --------- -------------- 385s Total import time ✓ 16 0.4 kB 0.122s 385s 2024-11-15T02:54:57.707000Z LOG Regress pass. 385s touch regress/out/allcols.out 385s pgloader --regress csv-before-after.load 386s 2024-11-15T02:54:59.028000Z LOG pgloader version "3.6.10~devel" 387s 2024-11-15T02:54:59.717000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-before-after.out") 387s 2024-11-15T02:54:59.730000Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 387s 2024-11-15T02:54:59.875000Z LOG report summary reset 387s table name errors rows bytes total time 387s ----------------------- --------- --------- --------- -------------- 387s fetch 0 0 0.010s 387s before load 0 6 0.026s 387s ----------------------- --------- --------- --------- -------------- 387s "csv"."blocks" 0 460 15.9 kB 0.158s 387s "expected"."blocks" 0 460 12.4 kB 0.060s 387s ----------------------- --------- --------- --------- -------------- 387s Files Processed 0 2 0.066s 387s COPY Threads Completion 0 4 0.222s 387s after load 0 1 0.018s 387s ----------------------- --------- --------- --------- -------------- 387s Total import time ✓ 920 28.2 kB 0.306s 387s 2024-11-15T02:54:59.913000Z LOG Regress pass. 387s touch regress/out/csv-before-after.out 387s pgloader --regress csv-districts.load 387s 2024-11-15T02:55:00.027000Z LOG pgloader version "3.6.10~devel" 388s 2024-11-15T02:55:00.736000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-districts.out") 388s 2024-11-15T02:55:00.751000Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 388s 2024-11-15T02:55:00.930000Z LOG report summary reset 388s table name errors rows bytes total time 388s ----------------------- --------- --------- --------- -------------- 388s fetch 0 0 0.010s 388s before load 0 2 0.025s 388s ----------------------- --------- --------- --------- -------------- 388s "public"."districts" 0 440 29.3 kB 0.230s 388s "expected"."districts" 0 440 29.1 kB 0.070s 388s ----------------------- --------- --------- --------- -------------- 388s Files Processed 0 2 0.073s 388s COPY Threads Completion 0 4 0.300s 388s ----------------------- --------- --------- --------- -------------- 388s Total import time ✓ 880 58.3 kB 0.373s 388s 2024-11-15T02:55:01.014000Z LOG Regress pass. 388s touch regress/out/csv-districts.out 388s pgloader --regress csv-parse-date.load 389s 2024-11-15T02:55:02.029000Z LOG pgloader version "3.6.10~devel" 390s 2024-11-15T02:55:02.539000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-parse-date.out") 390s 2024-11-15T02:55:02.556000Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 390s 2024-11-15T02:55:02.660000Z LOG report summary reset 390s table name errors rows bytes total time 390s ----------------------- --------- --------- --------- -------------- 390s fetch 0 0 0.010s 390s before load 0 2 0.027s 390s ----------------------- --------- --------- --------- -------------- 390s "public"."dateformat" 0 4 0.1 kB 0.057s 390s "expected"."dateformat" 0 4 0.1 kB 0.020s 390s ----------------------- --------- --------- --------- -------------- 390s Files Processed 0 2 0.058s 390s COPY Threads Completion 0 4 0.077s 390s ----------------------- --------- --------- --------- -------------- 390s Total import time ✓ 8 0.3 kB 0.135s 390s 2024-11-15T02:55:02.708000Z LOG Regress pass. 390s touch regress/out/csv-parse-date.out 390s pgloader --regress csv-error.load 391s 2024-11-15T02:55:04.046000Z LOG pgloader version "3.6.10~devel" 391s 2024-11-15T02:55:04.645000Z FATAL :ASCII stream decoding error on 391s #: 391s 391s the octet sequence #(195) cannot be decoded. 391s 2024-11-15T02:55:04.651000Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 391s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 391s 2024-11-15T02:55:04.682000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-error.out") 391s 2024-11-15T02:55:04.696000Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 392s 2024-11-15T02:55:04.802000Z LOG report summary reset 392s table name errors rows bytes total time 392s ----------------------- --------- --------- --------- -------------- 392s fetch 0 0 0.017s 392s before load 0 2 0.029s 392s ----------------------- --------- --------- --------- -------------- 392s "public"."jordane" 3 3 0.1 kB 0.053s 392s "expected"."jordane" 0 3 0.1 kB 0.017s 392s ----------------------- --------- --------- --------- -------------- 392s Files Processed 0 2 0.065s 392s COPY Threads Completion 0 4 0.070s 392s ----------------------- --------- --------- --------- -------------- 392s Total import time 3 6 0.2 kB 0.135s 392s 2024-11-15T02:55:04.845000Z LOG Regress pass. 392s touch regress/out/csv-error.out 392s pgloader --regress csv-escape-mode.load 392s 2024-11-15T02:55:05.033000Z LOG pgloader version "3.6.10~devel" 393s 2024-11-15T02:55:05.498000Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 393s 2024-11-15T02:55:05.498000Z WARNING That could impact loading performance badly. 393s 2024-11-15T02:55:05.498000Z WARNING Consider the option 'drop indexes'. 393s 2024-11-15T02:55:05.656000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-escape-mode.out") 393s 2024-11-15T02:55:05.669000Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 393s 2024-11-15T02:55:05.773000Z LOG report summary reset 393s table name errors rows bytes total time 393s ---------------------------- --------- --------- --------- -------------- 393s fetch 0 0 0.011s 393s before load 0 2 0.028s 393s ---------------------------- --------- --------- --------- -------------- 393s "public"."csv_escape_mode" 0 5 0.1 kB 0.052s 393s "expected"."csv_escape_mode" 0 5 0.1 kB 0.018s 393s ---------------------------- --------- --------- --------- -------------- 393s Files Processed 0 2 0.078s 393s COPY Threads Completion 0 4 0.072s 393s ---------------------------- --------- --------- --------- -------------- 393s Total import time ✓ 10 0.2 kB 0.150s 393s 2024-11-15T02:55:05.815000Z LOG Regress pass. 393s touch regress/out/csv-escape-mode.out 393s pgloader --regress csv-filename-pattern.load 394s 2024-11-15T02:55:07.048000Z LOG pgloader version "3.6.10~devel" 395s 2024-11-15T02:55:07.684000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-filename-pattern.out") 395s 2024-11-15T02:55:07.699000Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 395s 2024-11-15T02:55:07.801000Z LOG report summary reset 395s table name errors rows bytes total time 395s ----------------------- --------- --------- --------- -------------- 395s fetch 0 0 0.012s 395s before load 0 2 0.025s 395s ----------------------- --------- --------- --------- -------------- 395s "public"."matching" 0 3 0.0 kB 0.024s 395s "expected"."matching" 0 3 0.0 kB 0.017s 395s ----------------------- --------- --------- --------- -------------- 395s Files Processed 0 4 0.071s 395s COPY Threads Completion 0 8 0.110s 395s ----------------------- --------- --------- --------- -------------- 395s Total import time ✓ 6 0.0 kB 0.181s 395s 2024-11-15T02:55:07.843000Z LOG Regress pass. 395s touch regress/out/csv-filename-pattern.out 395s pgloader --regress csv-guess.load 396s 2024-11-15T02:55:09.031000Z LOG pgloader version "3.6.10~devel" 396s 2024-11-15T02:55:09.469000Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 396s 2024-11-15T02:55:09.469000Z WARNING That could impact loading performance badly. 396s 2024-11-15T02:55:09.470000Z WARNING Consider the option 'drop indexes'. 396s 2024-11-15T02:55:09.896000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-guess.out") 396s 2024-11-15T02:55:09.908000Z WARNING PostgreSQL warning: table "track" does not exist, skipping 397s 2024-11-15T02:55:10.077000Z LOG report summary reset 397s table name errors rows bytes total time 397s ----------------------- --------- --------- --------- -------------- 397s fetch 0 0 0.011s 397s before load 0 2 0.027s 397s ----------------------- --------- --------- --------- -------------- 397s "csv"."track" 0 3503 366.8 kB 0.321s 397s "expected"."track" 0 3503 366.8 kB 0.084s 397s ----------------------- --------- --------- --------- -------------- 397s Files Processed 0 2 0.075s 397s COPY Threads Completion 0 4 0.406s 397s ----------------------- --------- --------- --------- -------------- 397s Total import time ✓ 7006 733.5 kB 0.481s 397s 2024-11-15T02:55:10.133000Z LOG Regress pass. 397s touch regress/out/csv-guess.out 397s pgloader --regress csv-header.load 397s 2024-11-15T02:55:10.028000Z LOG pgloader version "3.6.10~devel" 398s 2024-11-15T02:55:10.562000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-header.out") 398s 2024-11-15T02:55:10.576000Z WARNING PostgreSQL warning: table "group" does not exist, skipping 398s 2024-11-15T02:55:10.681000Z LOG report summary reset 398s table name errors rows bytes total time 398s ----------------------- --------- --------- --------- -------------- 398s fetch 0 0 0.012s 398s before load 0 2 0.029s 398s ----------------------- --------- --------- --------- -------------- 398s "public"."group" 0 2 0.0 kB 0.028s 398s "expected"."group" 0 2 0.0 kB 0.018s 398s ----------------------- --------- --------- --------- -------------- 398s Files Processed 0 2 0.102s 398s COPY Threads Completion 0 4 0.047s 398s ----------------------- --------- --------- --------- -------------- 398s Total import time ✓ 4 0.1 kB 0.149s 398s 2024-11-15T02:55:10.720000Z LOG Regress pass. 398s touch regress/out/csv-header.out 398s pgloader --regress csv-json.load 399s 2024-11-15T02:55:12.029000Z LOG pgloader version "3.6.10~devel" 399s 2024-11-15T02:55:12.533000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-json.out") 399s 2024-11-15T02:55:12.548000Z WARNING PostgreSQL warning: table "json" does not exist, skipping 400s 2024-11-15T02:55:12.650000Z LOG report summary reset 400s table name errors rows bytes total time 400s ----------------------- --------- --------- --------- -------------- 400s fetch 0 0 0.010s 400s before load 0 2 0.025s 400s ----------------------- --------- --------- --------- -------------- 400s "public"."json" 0 15 1.1 kB 0.049s 400s "expected"."json" 0 15 1.1 kB 0.018s 400s ----------------------- --------- --------- --------- -------------- 400s Files Processed 0 2 0.060s 400s COPY Threads Completion 0 4 0.072s 400s ----------------------- --------- --------- --------- -------------- 400s Total import time ✓ 30 2.3 kB 0.132s 400s 2024-11-15T02:55:12.689000Z LOG Regress pass. 400s touch regress/out/csv-json.out 400s pgloader --regress csv-keep-extra-blanks.load 400s 2024-11-15T02:55:13.031000Z LOG pgloader version "3.6.10~devel" 401s 2024-11-15T02:55:13.544000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-keep-extra-blanks.out") 401s 2024-11-15T02:55:13.559000Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 401s 2024-11-15T02:55:13.659000Z LOG report summary reset 401s table name errors rows bytes total time 401s ----------------------- --------- --------- --------- -------------- 401s fetch 0 0 0.010s 401s before load 0 2 0.028s 401s ----------------------- --------- --------- --------- -------------- 401s "public"."nulls" 0 7 0.3 kB 0.048s 401s "expected"."nulls" 0 6 0.3 kB 0.018s 401s ----------------------- --------- --------- --------- -------------- 401s Files Processed 0 2 0.059s 401s COPY Threads Completion 0 4 0.069s 401s ----------------------- --------- --------- --------- -------------- 401s Total import time ✓ 13 0.6 kB 0.128s 401s 2024-11-15T02:55:13.699000Z LOG Regress pass. 401s touch regress/out/csv-keep-extra-blanks.out 401s pgloader --regress csv-missing-col.load 402s 2024-11-15T02:55:15.028000Z LOG pgloader version "3.6.10~devel" 402s 2024-11-15T02:55:15.497000Z LOG COPY INIT ERROR 402s 2024-11-15T02:55:15.501000Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 402s Database error 42703: column "c" of relation "missingcol" does not exist 402s 2024-11-15T02:55:15.533000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-missing-col.out") 402s 2024-11-15T02:55:15.545000Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 402s 2024-11-15T02:55:15.646000Z LOG report summary reset 402s table name errors rows bytes total time 402s ----------------------- --------- --------- --------- -------------- 402s fetch 0 0 0.010s 402s before load 0 2 0.024s 402s ----------------------- --------- --------- --------- -------------- 402s "public"."missingcol" 1 0 0.043s 402s "expected"."missingcol" 0 0 0.017s 402s ----------------------- --------- --------- --------- -------------- 402s Files Processed 0 2 0.059s 402s COPY Threads Completion 0 4 0.066s 402s ----------------------- --------- --------- --------- -------------- 403s Total import time 1 0 0.125s 403s 2024-11-15T02:55:15.684000Z LOG Regress pass. 403s touch regress/out/csv-missing-col.out 403s pgloader --regress csv-non-printable.load 403s 2024-11-15T02:55:16.028000Z LOG pgloader version "3.6.10~devel" 404s 2024-11-15T02:55:16.539000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-non-printable.out") 404s 2024-11-15T02:55:16.551000Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 404s 2024-11-15T02:55:16.651000Z LOG report summary reset 404s table name errors rows bytes total time 404s ----------------------- --------- --------- --------- -------------- 404s fetch 0 0 0.011s 404s before load 0 2 0.023s 404s ----------------------- --------- --------- --------- -------------- 404s "public"."tab_csv" 0 7 0.2 kB 0.051s 404s "expected"."tab_csv" 0 7 0.2 kB 0.018s 404s ----------------------- --------- --------- --------- -------------- 404s Files Processed 0 2 0.059s 404s COPY Threads Completion 0 4 0.072s 404s ----------------------- --------- --------- --------- -------------- 404s Total import time ✓ 14 0.4 kB 0.131s 404s 2024-11-15T02:55:16.690000Z LOG Regress pass. 404s touch regress/out/csv-non-printable.out 404s pgloader --regress csv-nulls.load 405s 2024-11-15T02:55:18.029000Z LOG pgloader version "3.6.10~devel" 405s 2024-11-15T02:55:18.410000Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 405s 2024-11-15T02:55:18.410000Z WARNING That could impact loading performance badly. 405s 2024-11-15T02:55:18.410000Z WARNING Consider the option 'drop indexes'. 405s 2024-11-15T02:55:18.534000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-nulls.out") 405s 2024-11-15T02:55:18.548000Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 405s 2024-11-15T02:55:18.648000Z LOG report summary reset 405s table name errors rows bytes total time 405s ----------------------- --------- --------- --------- -------------- 405s fetch 0 0 0.010s 405s before load 0 2 0.025s 405s ----------------------- --------- --------- --------- -------------- 405s "public"."nullif" 0 2 0.0 kB 0.035s 405s "expected"."nullif" 0 2 0.0 kB 0.017s 405s ----------------------- --------- --------- --------- -------------- 405s Files Processed 0 2 0.065s 405s COPY Threads Completion 0 4 0.057s 405s ----------------------- --------- --------- --------- -------------- 405s Total import time ✓ 4 0.1 kB 0.122s 405s 2024-11-15T02:55:18.687000Z LOG Regress pass. 405s touch regress/out/csv-nulls.out 405s pgloader --regress csv-temp.load 406s 2024-11-15T02:55:19.028000Z LOG pgloader version "3.6.10~devel" 407s 2024-11-15T02:55:19.517000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-temp.out") 407s 2024-11-15T02:55:19.531000Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 407s 2024-11-15T02:55:19.629000Z LOG report summary reset 407s table name errors rows bytes total time 407s ----------------------- --------- --------- --------- -------------- 407s fetch 0 0 0.010s 407s before load 0 2 0.024s 407s ----------------------- --------- --------- --------- -------------- 407s "public"."temp" 0 5 0.2 kB 0.045s 407s "expected"."temp" 0 5 0.2 kB 0.017s 407s ----------------------- --------- --------- --------- -------------- 407s Files Processed 0 2 0.065s 407s COPY Threads Completion 0 4 0.062s 407s ----------------------- --------- --------- --------- -------------- 407s Total import time ✓ 10 0.3 kB 0.127s 407s 2024-11-15T02:55:19.666000Z LOG Regress pass. 407s touch regress/out/csv-temp.out 407s pgloader --regress csv-trim-extra-blanks.load 407s 2024-11-15T02:55:20.028000Z LOG pgloader version "3.6.10~devel" 408s 2024-11-15T02:55:20.519000Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-trim-extra-blanks.out") 408s 2024-11-15T02:55:20.635000Z LOG report summary reset 408s table name errors rows bytes total time 408s ----------------------- --------- --------- --------- -------------- 408s fetch 0 0 0.011s 408s before load 0 2 0.027s 408s ----------------------- --------- --------- --------- -------------- 408s "public"."nulls" 0 7 0.3 kB 0.053s 408s "expected"."nulls" 0 7 0.3 kB 0.017s 408s ----------------------- --------- --------- --------- -------------- 408s Files Processed 0 2 0.056s 408s COPY Threads Completion 0 4 0.073s 408s ----------------------- --------- --------- --------- -------------- 408s Total import time ✓ 14 0.6 kB 0.129s 408s 2024-11-15T02:55:20.672000Z LOG Regress pass. 408s touch regress/out/csv-trim-extra-blanks.out 408s pgloader --regress csv-using-sexp.load 409s 2024-11-15T02:55:22.027996Z LOG pgloader version "3.6.10~devel" 409s 2024-11-15T02:55:22.525939Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv-using-sexp.out") 409s 2024-11-15T02:55:22.539938Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 409s 2024-11-15T02:55:22.643926Z LOG report summary reset 409s table name errors rows bytes total time 409s ----------------------- --------- --------- --------- -------------- 409s fetch 0 0 0.010s 409s before load 0 2 0.026s 409s ----------------------- --------- --------- --------- -------------- 409s "public"."sexp" 0 3 0.0 kB 0.051s 409s "expected"."sexp" 0 3 0.0 kB 0.018s 409s ----------------------- --------- --------- --------- -------------- 409s Files Processed 0 2 0.056s 410s COPY Threads Completion 0 4 0.071s 410s ----------------------- --------- --------- --------- -------------- 410s Total import time ✓ 6 0.1 kB 0.127s 410s 2024-11-15T02:55:22.686921Z LOG Regress pass. 410s touch regress/out/csv-using-sexp.out 410s pgloader --regress csv.load 410s 2024-11-15T02:55:23.030997Z LOG pgloader version "3.6.10~devel" 410s 2024-11-15T02:55:23.140985Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 411s 2024-11-15T02:55:23.524944Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 411s 2024-11-15T02:55:23.540943Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/csv.out") 411s 2024-11-15T02:55:23.554941Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 411s 2024-11-15T02:55:23.654931Z LOG report summary reset 411s table name errors rows bytes total time 411s ----------------------- --------- --------- --------- -------------- 411s fetch 0 0 0.011s 411s before load 0 2 0.025s 411s ----------------------- --------- --------- --------- -------------- 411s "public"."csv" 0 6 0.2 kB 0.046s 411s "expected"."csv" 0 6 0.2 kB 0.017s 411s ----------------------- --------- --------- --------- -------------- 411s Files Processed 0 2 0.056s 411s COPY Threads Completion 0 4 0.064s 411s ----------------------- --------- --------- --------- -------------- 411s Total import time ✓ 12 0.4 kB 0.120s 411s 2024-11-15T02:55:23.690928Z LOG Regress pass. 411s touch regress/out/csv.out 411s pgloader --regress copy.load 412s 2024-11-15T02:55:25.030997Z LOG pgloader version "3.6.10~devel" 412s 2024-11-15T02:55:25.149986Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 412s 2024-11-15T02:55:25.620941Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 412s 2024-11-15T02:55:25.635940Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/copy.out") 412s 2024-11-15T02:55:25.649939Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 412s 2024-11-15T02:55:25.805924Z LOG report summary reset 413s table name errors rows bytes total time 413s ----------------------- --------- --------- --------- -------------- 413s fetch 0 0 0.010s 413s before load 0 2 0.026s 413s ----------------------- --------- --------- --------- -------------- 413s "public"."track_full" 0 3503 366.8 kB 0.054s 413s "expected"."track_full" 0 3503 366.8 kB 0.085s 413s ----------------------- --------- --------- --------- -------------- 413s Files Processed 0 2 0.059s 413s COPY Threads Completion 0 4 0.137s 413s Index Build Completion 0 0 0.020s 413s Create Indexes 0 1 0.004s 413s Constraints 0 1 0.001s 413s ----------------------- --------- --------- --------- -------------- 413s Total import time ✓ 7006 733.5 kB 0.221s 413s 2024-11-15T02:55:25.844920Z LOG Regress pass. 413s touch regress/out/copy.out 413s pgloader --regress copy-hex.load 413s 2024-11-15T02:55:26.029997Z LOG pgloader version "3.6.10~devel" 414s 2024-11-15T02:55:26.505955Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/copy-hex.out") 414s 2024-11-15T02:55:26.520954Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 414s 2024-11-15T02:55:26.615946Z LOG report summary reset 414s table name errors rows bytes total time 414s ----------------------- --------- --------- --------- -------------- 414s fetch 0 0 0.010s 414s before load 0 2 0.023s 414s ----------------------- --------- --------- --------- -------------- 414s "public"."copyhex" 0 6 0.0 kB 0.041s 414s "expected"."copyhex" 0 6 0.0 kB 0.019s 414s ----------------------- --------- --------- --------- -------------- 414s Files Processed 0 2 0.047s 414s COPY Threads Completion 0 4 0.063s 414s ----------------------- --------- --------- --------- -------------- 414s Total import time ✓ 12 0.1 kB 0.110s 414s 2024-11-15T02:55:26.653943Z LOG Regress pass. 414s touch regress/out/copy-hex.out 414s pgloader --regress dbf.load 415s 2024-11-15T02:55:28.030998Z LOG pgloader version "3.6.10~devel" 415s 2024-11-15T02:55:28.231982Z LOG Migrating from # 415s 2024-11-15T02:55:28.231982Z LOG Migrating into # 415s 2024-11-15T02:55:28.466963Z WARNING Forcing encoding to CP850, db3 file has ASCII 415s 2024-11-15T02:55:28.538958Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/dbf.out") 415s 2024-11-15T02:55:28.553957Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 415s 2024-11-15T02:55:28.690946Z LOG report summary reset 415s table name errors rows bytes total time 415s ----------------------- --------- --------- --------- -------------- 415s fetch 0 0 0.004s 415s Create Schemas 0 0 0.000s 415s Create SQL Types 0 0 0.014s 415s Create tables 0 2 0.040s 415s ----------------------- --------- --------- --------- -------------- 415s public.reg2013 0 27 1.0 kB 0.024s 415s "expected"."reg2013" 0 27 1.0 kB 0.018s 415s ----------------------- --------- --------- --------- -------------- 415s COPY Threads Completion 0 6 0.044s 415s Create Triggers 0 0 0.000s 415s Install Comments 0 0 0.000s 415s Files Processed 0 1 0.011s 415s ----------------------- --------- --------- --------- -------------- 415s Total import time ✓ 54 1.9 kB 0.055s 415s 2024-11-15T02:55:28.728944Z LOG Regress pass. 415s touch regress/out/dbf.out 415s pgloader --regress errors.load 416s 2024-11-15T02:55:29.025998Z LOG pgloader version "3.6.10~devel" 416s 2024-11-15T02:55:29.127992Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 416s 2024-11-15T02:55:29.402971Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 416s 2024-11-15T02:55:29.402971Z WARNING That could impact loading performance badly. 416s 2024-11-15T02:55:29.403971Z WARNING Consider the option 'drop indexes'. 417s 2024-11-15T02:55:29.486965Z ERROR End of file while collecting quoted item: # 417s 2024-11-15T02:55:29.487965Z FATAL End of file while collecting quoted item: # 417s 2024-11-15T02:55:29.492964Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 417s HINT: Perhaps you need a different "datestyle" setting. 417s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 417s 2024-11-15T02:55:29.492964Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 417s HINT: Perhaps you need a different "datestyle" setting. 417s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 417s 2024-11-15T02:55:29.493964Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 417s HINT: Perhaps you need a different "datestyle" setting. 417s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 417s 2024-11-15T02:55:29.508963Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 417s 2024-11-15T02:55:29.527962Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/errors.out") 417s 2024-11-15T02:55:29.539961Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 417s 2024-11-15T02:55:29.645954Z LOG report summary reset 417s table name errors rows bytes total time 417s ----------------------- --------- --------- --------- -------------- 417s fetch 0 0 0.010s 417s before load 0 4 0.026s 417s ----------------------- --------- --------- --------- -------------- 417s "err"."errors" 8 7 0.3 kB 0.037s 417s "expected"."errors" 0 7 0.2 kB 0.022s 417s ----------------------- --------- --------- --------- -------------- 417s Files Processed 0 2 0.064s 417s COPY Threads Completion 0 4 0.062s 417s ----------------------- --------- --------- --------- -------------- 417s Total import time 8 14 0.6 kB 0.126s 417s 2024-11-15T02:55:29.681951Z LOG Regress pass. 417s touch regress/out/errors.out 417s pgloader --regress fixed.load 417s 2024-11-15T02:55:30.027998Z LOG pgloader version "3.6.10~devel" 418s 2024-11-15T02:55:30.134990Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 418s 2024-11-15T02:55:30.568962Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 418s 2024-11-15T02:55:30.583961Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/fixed.out") 418s 2024-11-15T02:55:30.597960Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 418s 2024-11-15T02:55:30.689954Z LOG report summary reset 418s table name errors rows bytes total time 418s ----------------------- --------- --------- --------- -------------- 418s fetch 0 0 0.010s 418s before load 0 2 0.025s 418s ----------------------- --------- --------- --------- -------------- 418s "public"."fixed" 0 5 0.2 kB 0.027s 418s "expected"."fixed" 0 5 0.2 kB 0.017s 418s ----------------------- --------- --------- --------- -------------- 418s Files Processed 0 2 0.063s 418s COPY Threads Completion 0 4 0.045s 418s Index Build Completion 0 0 0.017s 418s Create Indexes 0 1 0.001s 418s Constraints 0 1 0.001s 418s ----------------------- --------- --------- --------- -------------- 418s Total import time ✓ 10 0.4 kB 0.127s 418s 2024-11-15T02:55:30.727952Z LOG Regress pass. 418s touch regress/out/fixed.out 418s pgloader --regress fields-with-periods.load 419s 2024-11-15T02:55:32.027998Z LOG pgloader version "3.6.10~devel" 419s 2024-11-15T02:55:32.507969Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/fields-with-periods.out") 420s 2024-11-15T02:55:32.625962Z LOG report summary reset 420s table name errors rows bytes total time 420s ----------------------- --------- --------- --------- -------------- 420s fetch 0 0 0.011s 420s before load 0 2 0.024s 420s ----------------------- --------- --------- --------- -------------- 420s "public"."fixed" 0 3 0.0 kB 0.049s 420s "expected"."fixed" 0 3 0.0 kB 0.018s 420s ----------------------- --------- --------- --------- -------------- 420s Files Processed 0 2 0.051s 420s COPY Threads Completion 0 4 0.068s 420s ----------------------- --------- --------- --------- -------------- 420s Total import time ✓ 6 0.0 kB 0.119s 420s 2024-11-15T02:55:32.670960Z LOG Regress pass. 420s touch regress/out/fields-with-periods.out 420s pgloader --regress ixf.load 420s 2024-11-15T02:55:33.032998Z LOG pgloader version "3.6.10~devel" 421s 2024-11-15T02:55:33.270985Z LOG Migrating from # 421s 2024-11-15T02:55:33.271985Z LOG Migrating into # 421s 2024-11-15T02:55:33.588967Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/ixf.out") 421s 2024-11-15T02:55:33.603966Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 421s 2024-11-15T02:55:33.744959Z LOG report summary reset 421s table name errors rows bytes total time 421s ----------------------- --------- --------- --------- -------------- 421s fetch 0 0 0.004s 421s before load 0 3 0.023s 421s Create Schemas 0 0 0.001s 421s Create SQL Types 0 0 0.013s 421s Create tables 0 2 0.043s 421s ----------------------- --------- --------- --------- -------------- 421s nsitra.test1 0 4 0.2 kB 0.022s 421s "expected"."test1" 0 4 0.2 kB 0.020s 421s ----------------------- --------- --------- --------- -------------- 421s COPY Threads Completion 0 6 0.048s 421s Index Build Completion 0 0 0.003s 421s Primary Keys 0 0 0.000s 421s Create Triggers 0 0 0.000s 421s Install Comments 0 0 0.000s 421s Files Processed 0 1 0.010s 421s ----------------------- --------- --------- --------- -------------- 421s Total import time ✓ 8 0.3 kB 0.061s 421s 2024-11-15T02:55:33.788956Z LOG Regress pass. 421s touch regress/out/ixf.out 421s pgloader --regress overflow.load 422s 2024-11-15T02:55:35.027998Z LOG pgloader version "3.6.10~devel" 422s 2024-11-15T02:55:35.495975Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 422s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 422s 2024-11-15T02:55:35.497975Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 422s DETAIL: Failing row contains (12, null). 422s CONTEXT: COPY overflow, line 1: "12 \N" 422s 2024-11-15T02:55:35.528974Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/overflow.out") 422s 2024-11-15T02:55:35.540973Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 422s 2024-11-15T02:55:35.641968Z LOG report summary reset 422s table name errors rows bytes total time 422s ----------------------- --------- --------- --------- -------------- 422s fetch 0 0 0.009s 422s before load 0 2 0.026s 422s ----------------------- --------- --------- --------- -------------- 422s "public"."overflow" 4 0 0.0 kB 0.056s 422s "expected"."overflow" 0 0 0.019s 422s ----------------------- --------- --------- --------- -------------- 422s Files Processed 0 2 0.058s 422s COPY Threads Completion 0 4 0.077s 422s ----------------------- --------- --------- --------- -------------- 422s Total import time 4 0 0.0 kB 0.135s 422s 2024-11-15T02:55:35.678966Z LOG Regress pass. 423s touch regress/out/overflow.out 423s pgloader --regress partial.load 423s 2024-11-15T02:55:36.028998Z LOG pgloader version "3.6.10~devel" 423s 2024-11-15T02:55:36.138993Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 424s 2024-11-15T02:55:36.607971Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 424s 2024-11-15T02:55:36.622971Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/partial.out") 424s 2024-11-15T02:55:36.637970Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 424s 2024-11-15T02:55:36.726966Z LOG report summary reset 424s table name errors rows bytes total time 424s ----------------------- --------- --------- --------- -------------- 424s fetch 0 0 0.011s 424s before load 0 4 0.027s 424s ----------------------- --------- --------- --------- -------------- 424s "csv"."partial" 0 7 0.1 kB 0.031s 424s "expected"."partial" 0 7 0.1 kB 0.019s 424s ----------------------- --------- --------- --------- -------------- 424s Files Processed 0 2 0.066s 424s COPY Threads Completion 0 4 0.049s 424s Index Build Completion 0 0 0.021s 424s Create Indexes 0 2 0.004s 424s Constraints 0 1 0.002s 424s ----------------------- --------- --------- --------- -------------- 424s Total import time ✓ 14 0.2 kB 0.142s 424s 2024-11-15T02:55:36.761965Z LOG Regress pass. 424s touch regress/out/partial.out 424s pgloader --regress serial.load 425s 2024-11-15T02:55:38.026999Z LOG pgloader version "3.6.10~devel" 425s 2024-11-15T02:55:38.126995Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 425s 2024-11-15T02:55:38.407983Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 425s 2024-11-15T02:55:38.407983Z WARNING That could impact loading performance badly. 425s 2024-11-15T02:55:38.407983Z WARNING Consider the option 'drop indexes'. 425s 2024-11-15T02:55:38.509980Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 425s 2024-11-15T02:55:38.527979Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/serial.out") 425s 2024-11-15T02:55:38.539978Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 425s 2024-11-15T02:55:38.634975Z LOG report summary reset 425s table name errors rows bytes total time 425s ----------------------- --------- --------- --------- -------------- 425s fetch 0 0 0.010s 425s before load 0 2 0.025s 425s ----------------------- --------- --------- --------- -------------- 425s "public"."serial" 0 7 0.2 kB 0.027s 425s "expected"."serial" 0 7 0.2 kB 0.016s 425s ----------------------- --------- --------- --------- -------------- 425s Files Processed 0 2 0.070s 425s COPY Threads Completion 0 4 0.045s 425s ----------------------- --------- --------- --------- -------------- 425s Total import time ✓ 14 0.4 kB 0.115s 425s 2024-11-15T02:55:38.672973Z LOG Regress pass. 425s touch regress/out/serial.out 425s pgloader --regress udc.load 426s 2024-11-15T02:55:39.030999Z LOG pgloader version "3.6.10~devel" 426s 2024-11-15T02:55:39.143995Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 427s 2024-11-15T02:55:39.441983Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 427s 2024-11-15T02:55:39.441983Z WARNING That could impact loading performance badly. 427s 2024-11-15T02:55:39.441983Z WARNING Consider the option 'drop indexes'. 427s 2024-11-15T02:55:39.549979Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 427s 2024-11-15T02:55:39.567978Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/udc.out") 427s 2024-11-15T02:55:39.583978Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 427s 2024-11-15T02:55:39.684974Z LOG report summary reset 427s table name errors rows bytes total time 427s ----------------------- --------- --------- --------- -------------- 427s fetch 0 0 0.011s 427s before load 0 2 0.026s 427s ----------------------- --------- --------- --------- -------------- 427s "public"."udc" 0 5 0.1 kB 0.029s 427s "expected"."udc" 0 5 0.1 kB 0.016s 427s ----------------------- --------- --------- --------- -------------- 427s Files Processed 0 2 0.071s 427s COPY Threads Completion 0 4 0.048s 427s ----------------------- --------- --------- --------- -------------- 427s Total import time ✓ 10 0.2 kB 0.119s 427s 2024-11-15T02:55:39.722973Z LOG Regress pass. 427s touch regress/out/udc.out 427s pgloader --regress xzero.load 428s 2024-11-15T02:55:41.026999Z LOG pgloader version "3.6.10~devel" 428s 2024-11-15T02:55:41.140996Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 428s 2024-11-15T02:55:41.427985Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 428s 2024-11-15T02:55:41.427985Z WARNING That could impact loading performance badly. 428s 2024-11-15T02:55:41.427985Z WARNING Consider the option 'drop indexes'. 428s 2024-11-15T02:55:41.535982Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 428s 2024-11-15T02:55:41.553982Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.C0mysu/build.mwh/src/test/regress/expected/xzero.out") 428s 2024-11-15T02:55:41.566981Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 428s 2024-11-15T02:55:41.663978Z LOG report summary reset 428s table name errors rows bytes total time 428s ----------------------- --------- --------- --------- -------------- 428s fetch 0 0 0.010s 428s before load 0 2 0.026s 428s ----------------------- --------- --------- --------- -------------- 428s "public"."xzero" 0 7 0.2 kB 0.027s 428s "expected"."xzero" 0 7 0.2 kB 0.018s 428s ----------------------- --------- --------- --------- -------------- 428s Files Processed 0 2 0.070s 428s COPY Threads Completion 0 4 0.049s 428s ----------------------- --------- --------- --------- -------------- 428s Total import time ✓ 14 0.4 kB 0.119s 428s 2024-11-15T02:55:41.701977Z LOG Regress pass. 428s touch regress/out/xzero.out 428s make: Leaving directory '/tmp/autopkgtest.C0mysu/build.mwh/src/test' 428s Dropping cluster 17/regress ... 429s autopkgtest [02:55:42]: test testsuite: -----------------------] 429s testsuite PASS 429s autopkgtest [02:55:42]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 430s autopkgtest [02:55:43]: @@@@@@@@@@@@@@@@@@@@ summary 430s ssl PASS 430s testsuite PASS 442s nova [W] Skipping flock in bos03-arm64 442s Creating nova instance adt-plucky-arm64-pgloader-20241115-024833-juju-7f2275-prod-proposed-migration-environment-20-9f4b3077-fe41-4f36-8f01-547efe43be9a from image adt/ubuntu-plucky-arm64-server-20241114.img (UUID 4472f5f7-859f-4441-9e8e-9550fb35f210)... 442s nova [W] Skipping flock in bos03-arm64 442s Creating nova instance adt-plucky-arm64-pgloader-20241115-024833-juju-7f2275-prod-proposed-migration-environment-20-9f4b3077-fe41-4f36-8f01-547efe43be9a from image adt/ubuntu-plucky-arm64-server-20241114.img (UUID 4472f5f7-859f-4441-9e8e-9550fb35f210)...