0s autopkgtest [18:16:21]: starting date and time: 2024-11-01 18:16:21+0000 0s autopkgtest [18:16:21]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [18:16:21]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.0653dw3v/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:ip4r --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=ip4r/2.4.2-3 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-ppc64el-27.secgroup --name adt-plucky-ppc64el-pgloader-20241101-181621-juju-7f2275-prod-proposed-migration-environment-15-97ada375-4e68-4533-afcf-43b4ebd8ebac --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 148s autopkgtest [18:18:49]: testbed dpkg architecture: ppc64el 149s autopkgtest [18:18:50]: testbed apt version: 2.9.8 149s autopkgtest [18:18:50]: @@@@@@@@@@@@@@@@@@@@ test bed setup 150s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 151s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [44.0 kB] 151s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [2775 kB] 152s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [183 kB] 152s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 152s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [221 kB] 152s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [1753 kB] 153s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [23.2 kB] 153s Fetched 5081 kB in 3s (1926 kB/s) 153s Reading package lists... 156s Reading package lists... 156s Building dependency tree... 156s Reading state information... 156s Calculating upgrade... 156s The following packages will be upgraded: 156s libevdev2 libftdi1-2 libinih1 nano python3-lazr.uri 156s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 156s Need to get 422 kB of archives. 156s After this operation, 17.4 kB of additional disk space will be used. 156s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libevdev2 ppc64el 1.13.3+dfsg-1 [39.2 kB] 156s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el nano ppc64el 8.2-1 [329 kB] 157s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libftdi1-2 ppc64el 1.5-7 [32.1 kB] 157s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libinih1 ppc64el 58-1ubuntu1 [7816 B] 157s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-lazr.uri all 1.0.6-4 [13.6 kB] 157s Fetched 422 kB in 0s (884 kB/s) 157s (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 ... 73549 files and directories currently installed.) 157s Preparing to unpack .../libevdev2_1.13.3+dfsg-1_ppc64el.deb ... 157s Unpacking libevdev2:ppc64el (1.13.3+dfsg-1) over (1.13.2+dfsg-1) ... 157s Preparing to unpack .../nano_8.2-1_ppc64el.deb ... 157s Unpacking nano (8.2-1) over (8.1-1) ... 158s Preparing to unpack .../libftdi1-2_1.5-7_ppc64el.deb ... 158s Unpacking libftdi1-2:ppc64el (1.5-7) over (1.5-6build5) ... 158s Preparing to unpack .../libinih1_58-1ubuntu1_ppc64el.deb ... 158s Unpacking libinih1:ppc64el (58-1ubuntu1) over (55-1ubuntu2) ... 158s Preparing to unpack .../python3-lazr.uri_1.0.6-4_all.deb ... 158s Unpacking python3-lazr.uri (1.0.6-4) over (1.0.6-3) ... 158s Setting up libinih1:ppc64el (58-1ubuntu1) ... 158s Setting up python3-lazr.uri (1.0.6-4) ... 158s Setting up libftdi1-2:ppc64el (1.5-7) ... 158s Setting up nano (8.2-1) ... 158s Setting up libevdev2:ppc64el (1.13.3+dfsg-1) ... 158s Processing triggers for man-db (2.12.1-3) ... 159s Processing triggers for install-info (7.1.1-1) ... 159s Processing triggers for libc-bin (2.40-1ubuntu3) ... 160s Reading package lists... 160s Building dependency tree... 160s Reading state information... 160s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 161s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 161s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 161s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 161s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 163s Reading package lists... 163s Reading package lists... 163s Building dependency tree... 163s Reading state information... 164s Calculating upgrade... 164s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 164s Reading package lists... 164s Building dependency tree... 164s Reading state information... 165s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 168s autopkgtest [18:19:09]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 13:49:23 UTC 2024 168s autopkgtest [18:19:09]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 170s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-3 (dsc) [2846 B] 170s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-3 (tar) [3723 kB] 170s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-3 (diff) [9508 B] 170s gpgv: Signature made Sat Jul 27 07:39:03 2024 UTC 170s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 170s gpgv: Can't check signature: No public key 170s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-3.dsc: no acceptable signature found 170s autopkgtest [18:19:11]: testing package pgloader version 3.6.10-3 171s autopkgtest [18:19:12]: build not needed 172s autopkgtest [18:19:13]: test ssl: preparing testbed 174s Reading package lists... 175s Building dependency tree... 175s Reading state information... 175s Starting pkgProblemResolver with broken count: 0 175s Starting 2 pkgProblemResolver with broken count: 0 175s Done 176s The following additional packages will be installed: 176s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 176s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 176s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 176s cl-usocket freetds-common freetds-dev libct4 libjson-perl libpq5 libsybdb5 176s libxslt1.1 pgloader postgresql postgresql-16 postgresql-client-16 176s postgresql-client-common postgresql-common ssl-cert 176s Suggested packages: 176s postgresql-doc postgresql-doc-16 176s Recommended packages: 176s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 176s libjson-xs-perl 176s The following NEW packages will be installed: 176s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 176s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 176s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 176s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 176s libct4 libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql 176s postgresql-16 postgresql-client-16 postgresql-client-common 176s postgresql-common ssl-cert 176s 0 upgraded, 33 newly installed, 0 to remove and 0 not upgraded. 176s Need to get 48.3 MB/48.3 MB of archives. 176s After this operation, 114 MB of additional disk space will be used. 176s Get:1 /tmp/autopkgtest.pn6qe9/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [736 B] 176s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 176s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 262 [36.7 kB] 176s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.2ubuntu2 [18.0 kB] 176s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 262 [162 kB] 176s Get:6 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-alexandria all 20240125.git8514d8e-1 [204 kB] 176s Get:7 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-rt all 20090812.gita6a7503-1 [13.2 kB] 176s Get:8 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-kmrcl all 1.111-2 [42.7 kB] 176s Get:9 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-base64 all 3.4.0-1 [9304 B] 176s Get:10 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 176s Get:11 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 176s Get:12 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-trivial-gray-streams all 20240217.gita7ead68-1 [9956 B] 176s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 176s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 176s Get:15 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-ironclad all 0.60-2 [1243 kB] 176s Get:16 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 176s Get:17 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-split-sequence all 1:2.0.1-1 [12.2 kB] 176s Get:18 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 176s Get:19 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 176s Get:20 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-usocket all 0.8.3-2 [69.9 kB] 176s Get:21 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-postgres all 20211113.git9d4332f-5 [56.8 kB] 176s Get:22 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-s-sql all 20211113.git9d4332f-5 [61.1 kB] 176s Get:23 http://ftpmaster.internal/ubuntu plucky/universe ppc64el cl-postmodern all 20211113.git9d4332f-5 [354 kB] 176s Get:24 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-common all 1.3.17+ds-2build3 [26.9 kB] 176s Get:25 http://ftpmaster.internal/ubuntu plucky/main ppc64el libct4 ppc64el 1.3.17+ds-2build3 [211 kB] 176s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2build3 [238 kB] 176s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-dev ppc64el 1.3.17+ds-2build3 [364 kB] 176s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.0-1 [280 kB] 176s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu1 [191 kB] 176s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-16 ppc64el 16.4-3 [1400 kB] 177s Get:31 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-16 ppc64el 16.4-3 [16.6 MB] 177s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql all 16+262 [11.8 kB] 177s Get:33 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgloader ppc64el 3.6.10-3 [25.7 MB] 179s Preconfiguring packages ... 179s Fetched 48.3 MB in 3s (15.2 MB/s) 179s Selecting previously unselected package libjson-perl. 179s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 73549 files and directories currently installed.) 179s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 179s Unpacking libjson-perl (4.10000-1) ... 179s Selecting previously unselected package postgresql-client-common. 179s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 179s Unpacking postgresql-client-common (262) ... 179s Selecting previously unselected package ssl-cert. 179s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 179s Unpacking ssl-cert (1.1.2ubuntu2) ... 179s Selecting previously unselected package postgresql-common. 179s Preparing to unpack .../03-postgresql-common_262_all.deb ... 179s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 179s Unpacking postgresql-common (262) ... 179s Selecting previously unselected package cl-alexandria. 179s Preparing to unpack .../04-cl-alexandria_20240125.git8514d8e-1_all.deb ... 179s Unpacking cl-alexandria (20240125.git8514d8e-1) ... 180s Selecting previously unselected package cl-rt. 180s Preparing to unpack .../05-cl-rt_20090812.gita6a7503-1_all.deb ... 180s Unpacking cl-rt (20090812.gita6a7503-1) ... 180s Selecting previously unselected package cl-kmrcl. 180s Preparing to unpack .../06-cl-kmrcl_1.111-2_all.deb ... 180s Unpacking cl-kmrcl (1.111-2) ... 180s Selecting previously unselected package cl-base64. 180s Preparing to unpack .../07-cl-base64_3.4.0-1_all.deb ... 180s Unpacking cl-base64 (3.4.0-1) ... 180s Selecting previously unselected package cl-bordeaux-threads. 180s Preparing to unpack .../08-cl-bordeaux-threads_0.8.8-5_all.deb ... 180s Unpacking cl-bordeaux-threads (0.8.8-5) ... 180s Selecting previously unselected package cl-closer-mop. 180s Preparing to unpack .../09-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 180s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 180s Selecting previously unselected package cl-trivial-gray-streams. 180s Preparing to unpack .../10-cl-trivial-gray-streams_20240217.gita7ead68-1_all.deb ... 180s Unpacking cl-trivial-gray-streams (20240217.gita7ead68-1) ... 180s Selecting previously unselected package cl-flexi-streams. 180s Preparing to unpack .../11-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 180s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 180s Selecting previously unselected package cl-global-vars. 180s Preparing to unpack .../12-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 180s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 180s Selecting previously unselected package cl-ironclad. 180s Preparing to unpack .../13-cl-ironclad_0.60-2_all.deb ... 180s Unpacking cl-ironclad (0.60-2) ... 180s Selecting previously unselected package cl-md5. 180s Preparing to unpack .../14-cl-md5_1%3a20210622.git906593f-1_all.deb ... 180s Unpacking cl-md5 (1:20210622.git906593f-1) ... 180s Selecting previously unselected package cl-split-sequence. 180s Preparing to unpack .../15-cl-split-sequence_1%3a2.0.1-1_all.deb ... 180s Unpacking cl-split-sequence (1:2.0.1-1) ... 180s Selecting previously unselected package cl-ppcre. 180s Preparing to unpack .../16-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 180s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 180s Selecting previously unselected package cl-uax-15. 180s Preparing to unpack .../17-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 180s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 180s Selecting previously unselected package cl-usocket. 180s Preparing to unpack .../18-cl-usocket_0.8.3-2_all.deb ... 180s Unpacking cl-usocket (0.8.3-2) ... 180s Selecting previously unselected package cl-postgres. 180s Preparing to unpack .../19-cl-postgres_20211113.git9d4332f-5_all.deb ... 180s Unpacking cl-postgres (20211113.git9d4332f-5) ... 180s Selecting previously unselected package cl-s-sql. 180s Preparing to unpack .../20-cl-s-sql_20211113.git9d4332f-5_all.deb ... 180s Unpacking cl-s-sql (20211113.git9d4332f-5) ... 180s Selecting previously unselected package cl-postmodern. 180s Preparing to unpack .../21-cl-postmodern_20211113.git9d4332f-5_all.deb ... 180s Unpacking cl-postmodern (20211113.git9d4332f-5) ... 180s Selecting previously unselected package freetds-common. 180s Preparing to unpack .../22-freetds-common_1.3.17+ds-2build3_all.deb ... 180s Unpacking freetds-common (1.3.17+ds-2build3) ... 180s Selecting previously unselected package libct4:ppc64el. 180s Preparing to unpack .../23-libct4_1.3.17+ds-2build3_ppc64el.deb ... 180s Unpacking libct4:ppc64el (1.3.17+ds-2build3) ... 180s Selecting previously unselected package libsybdb5:ppc64el. 180s Preparing to unpack .../24-libsybdb5_1.3.17+ds-2build3_ppc64el.deb ... 180s Unpacking libsybdb5:ppc64el (1.3.17+ds-2build3) ... 180s Selecting previously unselected package freetds-dev. 180s Preparing to unpack .../25-freetds-dev_1.3.17+ds-2build3_ppc64el.deb ... 180s Unpacking freetds-dev (1.3.17+ds-2build3) ... 180s Selecting previously unselected package libpq5:ppc64el. 180s Preparing to unpack .../26-libpq5_17.0-1_ppc64el.deb ... 180s Unpacking libpq5:ppc64el (17.0-1) ... 180s Selecting previously unselected package libxslt1.1:ppc64el. 180s Preparing to unpack .../27-libxslt1.1_1.1.39-0exp1ubuntu1_ppc64el.deb ... 180s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 180s Selecting previously unselected package postgresql-client-16. 180s Preparing to unpack .../28-postgresql-client-16_16.4-3_ppc64el.deb ... 180s Unpacking postgresql-client-16 (16.4-3) ... 180s Selecting previously unselected package postgresql-16. 180s Preparing to unpack .../29-postgresql-16_16.4-3_ppc64el.deb ... 180s Unpacking postgresql-16 (16.4-3) ... 181s Selecting previously unselected package postgresql. 181s Preparing to unpack .../30-postgresql_16+262_all.deb ... 181s Unpacking postgresql (16+262) ... 181s Selecting previously unselected package pgloader. 181s Preparing to unpack .../31-pgloader_3.6.10-3_ppc64el.deb ... 181s Unpacking pgloader (3.6.10-3) ... 181s Selecting previously unselected package autopkgtest-satdep. 181s Preparing to unpack .../32-1-autopkgtest-satdep.deb ... 181s Unpacking autopkgtest-satdep (0) ... 181s Setting up postgresql-client-common (262) ... 181s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 181s Setting up libpq5:ppc64el (17.0-1) ... 181s Setting up cl-split-sequence (1:2.0.1-1) ... 181s Setting up cl-trivial-gray-streams (20240217.gita7ead68-1) ... 181s Setting up ssl-cert (1.1.2ubuntu2) ... 182s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 182s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 182s Setting up libjson-perl (4.10000-1) ... 182s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 182s Setting up cl-alexandria (20240125.git8514d8e-1) ... 182s Setting up cl-rt (20090812.gita6a7503-1) ... 182s Setting up freetds-common (1.3.17+ds-2build3) ... 182s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 182s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 182s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 182s Setting up postgresql-client-16 (16.4-3) ... 183s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 183s Setting up libsybdb5:ppc64el (1.3.17+ds-2build3) ... 183s Setting up cl-bordeaux-threads (0.8.8-5) ... 183s Setting up libct4:ppc64el (1.3.17+ds-2build3) ... 183s Setting up cl-kmrcl (1.111-2) ... 183s Setting up postgresql-common (262) ... 184s 184s Creating config file /etc/postgresql-common/createcluster.conf with new version 184s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 184s Removing obsolete dictionary files: 185s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 186s Setting up cl-usocket (0.8.3-2) ... 186s Setting up cl-md5 (1:20210622.git906593f-1) ... 186s Setting up cl-base64 (3.4.0-1) ... 186s Setting up cl-ironclad (0.60-2) ... 186s Setting up postgresql-16 (16.4-3) ... 186s Creating new PostgreSQL cluster 16/main ... 186s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 186s The files belonging to this database system will be owned by user "postgres". 186s This user must also own the server process. 186s 186s The database cluster will be initialized with locale "C.UTF-8". 186s The default database encoding has accordingly been set to "UTF8". 186s The default text search configuration will be set to "english". 186s 186s Data page checksums are disabled. 186s 186s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 186s creating subdirectories ... ok 186s selecting dynamic shared memory implementation ... posix 186s selecting default max_connections ... 100 186s selecting default shared_buffers ... 128MB 186s selecting default time zone ... Etc/UTC 186s creating configuration files ... ok 186s running bootstrap script ... ok 187s performing post-bootstrap initialization ... ok 187s syncing data to disk ... ok 191s Setting up freetds-dev (1.3.17+ds-2build3) ... 191s Setting up pgloader (3.6.10-3) ... 191s Setting up cl-postgres (20211113.git9d4332f-5) ... 191s Setting up postgresql (16+262) ... 191s Setting up cl-s-sql (20211113.git9d4332f-5) ... 191s Setting up cl-postmodern (20211113.git9d4332f-5) ... 191s Setting up autopkgtest-satdep (0) ... 191s Processing triggers for man-db (2.12.1-3) ... 192s Processing triggers for install-info (7.1.1-1) ... 192s Processing triggers for libc-bin (2.40-1ubuntu3) ... 197s (Reading database ... 76468 files and directories currently installed.) 197s Removing autopkgtest-satdep (0) ... 198s autopkgtest [18:19:39]: test ssl: [----------------------- 198s + trap rm -rf /tmp/pgloader EXIT 198s + dpkg-query --show --showformat=${Version} cl-postmodern 198s + postmodern=20211113.git9d4332f-5 198s + dpkg --compare-versions 20211113.git9d4332f-5 lt 20200101 198s + pg_virtualenv 198s Creating new PostgreSQL cluster 16/regress ... 202s ++ psql -XAtc 'SHOW hba_file' 202s + HBA=/etc/postgresql/16/regress/pg_hba.conf 202s + sed -i -e 's/^host/hostssl/' /etc/postgresql/16/regress/pg_hba.conf 202s + psql -XAtc 'SELECT pg_reload_conf()' 202s + createdb pgloader 202s t 202s + export PGDATABASE=pgloader 202s + PGDATABASE=pgloader 202s + psql -XAtc 'create schema expected' 202s CREATE SCHEMA 202s + rm -rf /tmp/pgloader 202s + PGHOST=/var/run/postgresql 202s + su -c 'pgloader --debug --regress test/allcols.load' postgres 202s mkdir -p #P"/tmp/pgloader/" 202s pgloader version 3.6.7~devel 202s compiled with SBCL 2.4.7~git20240721.1.7a19681d9.debian 202s sb-impl::*default-external-format* :UTF-8 202s tmpdir: #P"/tmp/pgloader/" 202s 2024-11-01T18:19:43.008000Z NOTICE Starting pgloader, log system is ready. 202s 2024-11-01T18:19:43.016000Z INFO Starting monitor 202s 2024-11-01T18:19:43.020000Z LOG pgloader version "3.6.7~devel" 202s 2024-11-01T18:19:43.076002Z INFO Parsed command: 202s /* 202s * This test is ported from pgloader 2.x where it was defined as: 202s * 202s * [allcols] 202s * table = allcols 202s * format = csv 202s * filename = allcols/allcols.data 202s * field_sep = : 202s * columns = * 202s * pg_option_work_mem = 14MB 202s * 202s */ 202s 202s LOAD CSV 202s FROM inline (a, b, c) 202s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 202s 202s WITH fields optionally enclosed by '"', 202s fields escaped by double-quote, 202s fields terminated by ':' 202s 202s SET client_encoding to 'latin1', 202s work_mem to '14MB', 202s standard_conforming_strings to 'on' 202s 202s BEFORE LOAD DO 202s $$ drop table if exists allcols; $$, 202s $$ create table allcols ( 202s a integer primary key, 202s b date, 202s c text 202s ); 202s $$; 202s 202s 202s 202s 202s 202s 2024-11-01T18:19:43.080002Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 203s 2024-11-01T18:19:43.132003Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.132003Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.132003Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.132003Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.132003Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.144004Z NOTICE Executing SQL block for before load 203s 2024-11-01T18:19:43.164004Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.164004Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.164004Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.164004Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.164004Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.168004Z DEBUG BEGIN 203s 2024-11-01T18:19:43.168004Z SQL drop table if exists allcols; 203s 2024-11-01T18:19:43.168004Z SQL create table allcols ( 203s a integer primary key, 203s b date, 203s c text 203s ); 203s 2024-11-01T18:19:43.200005Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.200005Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.200005Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.200005Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.200005Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.216005Z SQL -- 203s -- get user defined SQL types 203s -- 203s select nt.nspname, 203s extname, 203s typname, 203s case when enum.enumtypid is not null 203s then array_agg(enum.enumlabel order by enumsortorder) 203s end as enumvalues 203s 203s from pg_class c 203s join pg_namespace n on n.oid = c.relnamespace 203s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 203s join pg_type t on t.oid = a.atttypid 203s left join pg_namespace nt on nt.oid = t.typnamespace 203s left join pg_depend d on d.classid = 'pg_type'::regclass 203s and d.refclassid = 'pg_extension'::regclass 203s and d.objid = t.oid 203s left join pg_extension e on refobjid = e.oid 203s left join pg_enum enum on enum.enumtypid = t.oid 203s 203s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 203s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and c.relkind in ('r', 'f', 'p') 203s and ((n.nspname = 'public' and c.relname = 'allcols')) 203s 203s and 203s ( t.typrelid = 0 203s or 203s (select c.relkind = 'c' 203s from pg_class c 203s where c.oid = t.typrelid) 203s ) 203s and not exists 203s ( 203s select 1 203s from pg_type el 203s where el.oid = t.typelem 203s and el.typarray = t.oid 203s ) 203s 203s group by nt.nspname, extname, typname, enumtypid 203s order by nt.nspname, extname, typname, enumtypid; 203s 2024-11-01T18:19:43.224006Z SQL -- params: table-type-name 203s -- including 203s -- filter-list-to-where-clause for including 203s -- excluding 203s -- filter-list-to-where-clause for excluding 203s with seqattr as 203s ( 203s select adrelid, 203s adnum, 203s pg_get_expr(d.adbin, d.adrelid) as adsrc, 203s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 203s then substring(pg_get_expr(d.adbin, d.adrelid) 203s from '''([^'']+)''' 203s ) 203s else null 203s end as seqname 203s from pg_attrdef d 203s ) 203s select nspname, relname, c.oid, attname, 203s t.oid::regtype as type, 203s case when atttypmod > 0 203s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 203s else null 203s end as typmod, 203s attnotnull, 203s case when atthasdef 203s then pg_get_expr(def.adbin, def.adrelid) 203s end as default , 203s case when s.seqname is not null then 'auto_increment' end as extra 203s from pg_class c 203s join pg_namespace n on n.oid = c.relnamespace 203s left join pg_attribute a on c.oid = a.attrelid 203s join pg_type t on t.oid = a.atttypid and attnum > 0 203s left join pg_attrdef def on a.attrelid = def.adrelid 203s and a.attnum = def.adnum 203s and a.atthasdef 203s left join seqattr s on def.adrelid = s.adrelid 203s and def.adnum = s.adnum 203s 203s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and relkind in ('r', 'f', 'p') 203s and ((n.nspname = 'public' and c.relname = 'allcols')) 203s 203s 203s order by nspname, relname, attnum; 203s 2024-11-01T18:19:43.256006Z SQL -- params: including 203s -- filter-list-to-where-clause for including 203s -- excluding 203s -- filter-list-to-where-clause for excluding 203s select n.nspname, 203s i.relname, 203s i.oid, 203s rn.nspname, 203s r.relname, 203s indisprimary, 203s indisunique, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.oid 203s and array[attnum::integer] <@ indkey::integer[] 203s ) as cols, 203s pg_get_indexdef(indexrelid), 203s c.conname, 203s pg_get_constraintdef(c.oid) 203s from pg_index x 203s join pg_class i ON i.oid = x.indexrelid 203s join pg_class r ON r.oid = x.indrelid 203s join pg_namespace n ON n.oid = i.relnamespace 203s join pg_namespace rn ON rn.oid = r.relnamespace 203s left join pg_depend d on d.classid = 'pg_class'::regclass 203s and d.objid = i.oid 203s and d.refclassid = 'pg_constraint'::regclass 203s and d.deptype = 'i' 203s left join pg_constraint c ON c.oid = d.refobjid 203s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and ((rn.nspname = 'public' and r.relname = 'allcols')) 203s 203s order by n.nspname, r.relname 203s 2024-11-01T18:19:43.272007Z SQL -- params: including (table) 203s -- filter-list-to-where-clause for including 203s -- excluding (table) 203s -- filter-list-to-where-clause for excluding 203s -- including (ftable) 203s -- filter-list-to-where-clause for including 203s -- excluding (ftable) 203s -- filter-list-to-where-clause for excluding 203s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 203s r.oid, 203s d.refobjid as pkeyoid, 203s conname, 203s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.conrelid 203s and array[attnum::integer] <@ conkey::integer[] 203s ) as conkey, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.confrelid 203s and array[attnum::integer] <@ confkey::integer[] 203s ) as confkey, 203s confupdtype, confdeltype, confmatchtype, 203s condeferrable, condeferred 203s from pg_catalog.pg_constraint r 203s JOIN pg_class c on r.conrelid = c.oid 203s JOIN pg_namespace n on c.relnamespace = n.oid 203s JOIN pg_class cf on r.confrelid = cf.oid 203s JOIN pg_namespace nf on cf.relnamespace = nf.oid 203s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 203s and d.objid = r.oid 203s and d.refobjsubid = 0 203s where r.contype = 'f' 203s AND c.relkind in ('r', 'f', 'p') 203s AND cf.relkind in ('r', 'f', 'p') 203s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 203s and ((n.nspname = 'public' and c.relname = 'allcols')) 203s 203s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 203s 203s 2024-11-01T18:19:43.276007Z SQL -- params pkey-oid-list 203s -- fkey-oild-list 203s with pkeys(oid) as ( 203s values(16391) 203s ), 203s knownfkeys(oid) as ( 203s values(-1) 203s ), 203s pkdeps as ( 203s select pkeys.oid, pg_depend.objid 203s from pg_depend 203s join pkeys on pg_depend.refobjid = pkeys.oid 203s where classid = 'pg_catalog.pg_constraint'::regclass 203s and refclassid = 'pg_catalog.pg_class'::regclass 203s ) 203s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 203s r.oid as conoid, conname, 203s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 203s pkdeps.oid as index_oid 203s from pg_catalog.pg_constraint r 203s JOIN pkdeps on r.oid = pkdeps.objid 203s JOIN pg_class c on r.conrelid = c.oid 203s JOIN pg_namespace n on c.relnamespace = n.oid 203s JOIN pg_class cf on r.confrelid = cf.oid 203s JOIN pg_namespace nf on cf.relnamespace = nf.oid 203s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 203s 2024-11-01T18:19:43.292007Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 203s 2024-11-01T18:19:43.296007Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 203s 2024-11-01T18:19:43.296007Z WARNING That could impact loading performance badly. 203s 2024-11-01T18:19:43.296007Z WARNING Consider the option 'drop indexes'. 203s 2024-11-01T18:19:43.328008Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 203s 2024-11-01T18:19:43.328008Z DEBUG Reader started for "public"."allcols" 203s 2024-11-01T18:19:43.352009Z DEBUG start "public"."allcols" 576014 203s 2024-11-01T18:19:43.352009Z INFO COPY ON ERROR RESUME NEXT 203s 2024-11-01T18:19:43.352009Z NOTICE Opening (:INLINE 203s (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/allcols.load" . 765)) 203s 2024-11-01T18:19:43.360009Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.360009Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.360009Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.360009Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.360009Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.360009Z SQL SET search_path TO "public"; 203s 2024-11-01T18:19:43.360009Z INFO pgsql:copy-rows-from-queue[0]: "public"."allcols" ("a" "b" "c") 203s 2024-11-01T18:19:43.360009Z DEBUG Reader for "public"."allcols" is done in 0.036001s 203s 2024-11-01T18:19:43.368009Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.036001s 203s 2024-11-01T18:19:43.368009Z DEBUG send-batch[0] "public"."allcols" 8 rows [ 0.2 kB] in 0.008000s 203s 2024-11-01T18:19:43.368009Z DEBUG stop "public"."allcols" | 576014 .. 620015 = 0.044001d0 203s 2024-11-01T18:19:43.372009Z DEBUG Writer[0] for "public"."allcols" is done in 0.008000s 203s 2024-11-01T18:19:43.372009Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.008000s 203s 2024-11-01T18:19:43.388009Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 203s 2024-11-01T18:19:43.404010Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.404010Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.404010Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.404010Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.404010Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.404010Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/allcols.out") 203s 2024-11-01T18:19:43.424010Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.424010Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.424010Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.424010Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.424010Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.424010Z NOTICE drop table if exists expected.allcols; 203s 2024-11-01T18:19:43.428010Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 203s 2024-11-01T18:19:43.428010Z NOTICE create table expected.allcols(like allcols); 203s 2024-11-01T18:19:43.428010Z DEBUG LOAD DATA FROM # 203s 2024-11-01T18:19:43.448011Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.448011Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.448011Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.480013Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.480013Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.480013Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.484013Z SQL -- 203s -- get user defined SQL types 203s -- 203s select nt.nspname, 203s extname, 203s typname, 203s case when enum.enumtypid is not null 203s then array_agg(enum.enumlabel order by enumsortorder) 203s end as enumvalues 203s 203s from pg_class c 203s join pg_namespace n on n.oid = c.relnamespace 203s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 203s join pg_type t on t.oid = a.atttypid 203s left join pg_namespace nt on nt.oid = t.typnamespace 203s left join pg_depend d on d.classid = 'pg_type'::regclass 203s and d.refclassid = 'pg_extension'::regclass 203s and d.objid = t.oid 203s left join pg_extension e on refobjid = e.oid 203s left join pg_enum enum on enum.enumtypid = t.oid 203s 203s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 203s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and c.relkind in ('r', 'f', 'p') 203s and ((n.nspname = 'expected' and c.relname = 'allcols')) 203s 203s and 203s ( t.typrelid = 0 203s or 203s (select c.relkind = 'c' 203s from pg_class c 203s where c.oid = t.typrelid) 203s ) 203s and not exists 203s ( 203s select 1 203s from pg_type el 203s where el.oid = t.typelem 203s and el.typarray = t.oid 203s ) 203s 203s group by nt.nspname, extname, typname, enumtypid 203s order by nt.nspname, extname, typname, enumtypid; 203s 2024-11-01T18:19:43.484013Z SQL -- params: table-type-name 203s -- including 203s -- filter-list-to-where-clause for including 203s -- excluding 203s -- filter-list-to-where-clause for excluding 203s with seqattr as 203s ( 203s select adrelid, 203s adnum, 203s pg_get_expr(d.adbin, d.adrelid) as adsrc, 203s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 203s then substring(pg_get_expr(d.adbin, d.adrelid) 203s from '''([^'']+)''' 203s ) 203s else null 203s end as seqname 203s from pg_attrdef d 203s ) 203s select nspname, relname, c.oid, attname, 203s t.oid::regtype as type, 203s case when atttypmod > 0 203s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 203s else null 203s end as typmod, 203s attnotnull, 203s case when atthasdef 203s then pg_get_expr(def.adbin, def.adrelid) 203s end as default , 203s case when s.seqname is not null then 'auto_increment' end as extra 203s from pg_class c 203s join pg_namespace n on n.oid = c.relnamespace 203s left join pg_attribute a on c.oid = a.attrelid 203s join pg_type t on t.oid = a.atttypid and attnum > 0 203s left join pg_attrdef def on a.attrelid = def.adrelid 203s and a.attnum = def.adnum 203s and a.atthasdef 203s left join seqattr s on def.adrelid = s.adrelid 203s and def.adnum = s.adnum 203s 203s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and relkind in ('r', 'f', 'p') 203s and ((n.nspname = 'expected' and c.relname = 'allcols')) 203s 203s 203s order by nspname, relname, attnum; 203s 2024-11-01T18:19:43.488013Z SQL -- params: including 203s -- filter-list-to-where-clause for including 203s -- excluding 203s -- filter-list-to-where-clause for excluding 203s select n.nspname, 203s i.relname, 203s i.oid, 203s rn.nspname, 203s r.relname, 203s indisprimary, 203s indisunique, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.oid 203s and array[attnum::integer] <@ indkey::integer[] 203s ) as cols, 203s pg_get_indexdef(indexrelid), 203s c.conname, 203s pg_get_constraintdef(c.oid) 203s from pg_index x 203s join pg_class i ON i.oid = x.indexrelid 203s join pg_class r ON r.oid = x.indrelid 203s join pg_namespace n ON n.oid = i.relnamespace 203s join pg_namespace rn ON rn.oid = r.relnamespace 203s left join pg_depend d on d.classid = 'pg_class'::regclass 203s and d.objid = i.oid 203s and d.refclassid = 'pg_constraint'::regclass 203s and d.deptype = 'i' 203s left join pg_constraint c ON c.oid = d.refobjid 203s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 203s 203s order by n.nspname, r.relname 203s 2024-11-01T18:19:43.488013Z SQL -- params: including (table) 203s -- filter-list-to-where-clause for including 203s -- excluding (table) 203s -- filter-list-to-where-clause for excluding 203s -- including (ftable) 203s -- filter-list-to-where-clause for including 203s -- excluding (ftable) 203s -- filter-list-to-where-clause for excluding 203s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 203s r.oid, 203s d.refobjid as pkeyoid, 203s conname, 203s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.conrelid 203s and array[attnum::integer] <@ conkey::integer[] 203s ) as conkey, 203s (select string_agg(attname, ',') 203s from pg_attribute 203s where attrelid = r.confrelid 203s and array[attnum::integer] <@ confkey::integer[] 203s ) as confkey, 203s confupdtype, confdeltype, confmatchtype, 203s condeferrable, condeferred 203s from pg_catalog.pg_constraint r 203s JOIN pg_class c on r.conrelid = c.oid 203s JOIN pg_namespace n on c.relnamespace = n.oid 203s JOIN pg_class cf on r.confrelid = cf.oid 203s JOIN pg_namespace nf on cf.relnamespace = nf.oid 203s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 203s and d.objid = r.oid 203s and d.refobjsubid = 0 203s where r.contype = 'f' 203s AND c.relkind in ('r', 'f', 'p') 203s AND cf.relkind in ('r', 'f', 'p') 203s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 203s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 203s and ((n.nspname = 'expected' and c.relname = 'allcols')) 203s 203s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 203s 203s + rm -rf /tmp/pgloader 203s + PGSSLMODE=require 203s + pgloader --debug --regress test/allcols.load 203s 2024-11-01T18:19:43.492013Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 203s 2024-11-01T18:19:43.492013Z SQL TRUNCATE "expected"."allcols"; 203s 2024-11-01T18:19:43.508013Z NOTICE COPY "expected"."allcols" with 0 rows estimated [1/4] 203s 2024-11-01T18:19:43.508013Z DEBUG Reader started for "expected"."allcols" 203s 2024-11-01T18:19:43.508013Z DEBUG start "expected"."allcols" 760019 203s 2024-11-01T18:19:43.508013Z NOTICE Opening #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/allcols.out" 203s 2024-11-01T18:19:43.508013Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 203s 2024-11-01T18:19:43.508013Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 203s 2024-11-01T18:19:43.512013Z INFO COPY ON ERROR RESUME NEXT 203s 2024-11-01T18:19:43.528014Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.528014Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.528014Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.528014Z SQL SET search_path TO "expected"; 203s 2024-11-01T18:19:43.528014Z INFO pgsql:copy-rows-from-queue[2]: "expected"."allcols" ("a" "b" "c") 203s 2024-11-01T18:19:43.532014Z DEBUG send-batch[2] "expected"."allcols" 8 rows [ 0.2 kB] in 0.004000s 203s 2024-11-01T18:19:43.532014Z DEBUG stop "expected"."allcols" | 760019 .. 784020 = 0.024001d0 203s 2024-11-01T18:19:43.532014Z DEBUG Writer[2] for "expected"."allcols" is done in 0.004000s 203s 2024-11-01T18:19:43.536014Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.004000s 203s 2024-11-01T18:19:43.536014Z LOG report summary reset 203s table name errors read imported bytes total time read write 203s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 203s fetch 0 0 0 0.008s 203s before load 0 2 2 0.028s 203s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 203s "public"."allcols" 0 8 8 0.2 kB 0.044s 0.036s 0.008s 203s "expected"."allcols" 0 8 8 0.2 kB 0.024s 0.004s 203s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 203s Files Processed 0 2 2 0.040s 203s COPY Threads Completion 0 4 4 0.072s 203s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 203s Total import time ✓ 16 16 0.4 kB 0.112s 203s 2024-11-01T18:19:43.600015Z DEBUG CONNECTED TO # 203s 2024-11-01T18:19:43.600015Z DEBUG SET client_encoding TO 'utf8' 203s 2024-11-01T18:19:43.600015Z DEBUG SET work_mem TO '14MB' 203s 2024-11-01T18:19:43.600015Z DEBUG SET standard_conforming_strings TO 'on' 203s 2024-11-01T18:19:43.600015Z DEBUG SET application_name TO 'pgloader' 203s 2024-11-01T18:19:43.600015Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 203s 2024-11-01T18:19:43.600015Z NOTICE Got a diff of 0 rows 203s 2024-11-01T18:19:43.600015Z LOG Regress pass. 203s 2024-11-01T18:19:43.600015Z INFO Stopping monitor 203s mkdir -p #P"/tmp/pgloader/" 203s pgloader version 3.6.7~devel 203s compiled with SBCL 2.4.7~git20240721.1.7a19681d9.debian 203s sb-impl::*default-external-format* :UTF-8 203s tmpdir: #P"/tmp/pgloader/" 203s 2024-11-01T18:19:44.008001Z NOTICE Starting pgloader, log system is ready. 203s 2024-11-01T18:19:44.020001Z INFO Starting monitor 203s 2024-11-01T18:19:44.024001Z LOG pgloader version "3.6.7~devel" 203s 2024-11-01T18:19:44.024001Z LOG Data errors in '/tmp/pgloader/' 203s 2024-11-01T18:19:44.024001Z LOG Regression testing: "test/allcols.load" 203s 2024-11-01T18:19:44.024001Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/allcols.load" 203s 2024-11-01T18:19:44.076002Z INFO Parsed command: 203s /* 203s * This test is ported from pgloader 2.x where it was defined as: 203s * 203s * [allcols] 203s * table = allcols 203s * format = csv 203s * filename = allcols/allcols.data 203s * field_sep = : 203s * columns = * 203s * pg_option_work_mem = 14MB 203s * 203s */ 203s 203s LOAD CSV 203s FROM inline (a, b, c) 203s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 203s 203s WITH fields optionally enclosed by '"', 203s fields escaped by double-quote, 203s fields terminated by ':' 203s 203s SET client_encoding to 'latin1', 203s work_mem to '14MB', 203s standard_conforming_strings to 'on' 203s 203s BEFORE LOAD DO 203s $$ drop table if exists allcols; $$, 203s $$ create table allcols ( 203s a integer primary key, 203s b date, 203s c text 203s ); 203s $$; 203s 203s 203s 203s 203s 203s 2024-11-01T18:19:44.080002Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 204s 2024-11-01T18:19:44.280007Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:44.280007Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:44.280007Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:44.280007Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:44.280007Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:44.300008Z NOTICE Executing SQL block for before load 204s 2024-11-01T18:19:44.404010Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:44.404010Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:44.408010Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:44.408010Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:44.408010Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:44.412010Z DEBUG BEGIN 204s 2024-11-01T18:19:44.412010Z SQL drop table if exists allcols; 204s 2024-11-01T18:19:44.416010Z SQL create table allcols ( 204s a integer primary key, 204s b date, 204s c text 204s ); 204s 2024-11-01T18:19:44.548013Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:44.548013Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:44.548013Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:44.548013Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:44.548013Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:44.568014Z SQL -- 204s -- get user defined SQL types 204s -- 204s select nt.nspname, 204s extname, 204s typname, 204s case when enum.enumtypid is not null 204s then array_agg(enum.enumlabel order by enumsortorder) 204s end as enumvalues 204s 204s from pg_class c 204s join pg_namespace n on n.oid = c.relnamespace 204s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 204s join pg_type t on t.oid = a.atttypid 204s left join pg_namespace nt on nt.oid = t.typnamespace 204s left join pg_depend d on d.classid = 'pg_type'::regclass 204s and d.refclassid = 'pg_extension'::regclass 204s and d.objid = t.oid 204s left join pg_extension e on refobjid = e.oid 204s left join pg_enum enum on enum.enumtypid = t.oid 204s 204s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 204s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 204s and c.relkind in ('r', 'f', 'p') 204s and ((n.nspname = 'public' and c.relname = 'allcols')) 204s 204s and 204s ( t.typrelid = 0 204s or 204s (select c.relkind = 'c' 204s from pg_class c 204s where c.oid = t.typrelid) 204s ) 204s and not exists 204s ( 204s select 1 204s from pg_type el 204s where el.oid = t.typelem 204s and el.typarray = t.oid 204s ) 204s 204s group by nt.nspname, extname, typname, enumtypid 204s order by nt.nspname, extname, typname, enumtypid; 204s 2024-11-01T18:19:44.576014Z SQL -- params: table-type-name 204s -- including 204s -- filter-list-to-where-clause for including 204s -- excluding 204s -- filter-list-to-where-clause for excluding 204s with seqattr as 204s ( 204s select adrelid, 204s adnum, 204s pg_get_expr(d.adbin, d.adrelid) as adsrc, 204s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 204s then substring(pg_get_expr(d.adbin, d.adrelid) 204s from '''([^'']+)''' 204s ) 204s else null 204s end as seqname 204s from pg_attrdef d 204s ) 204s select nspname, relname, c.oid, attname, 204s t.oid::regtype as type, 204s case when atttypmod > 0 204s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 204s else null 204s end as typmod, 204s attnotnull, 204s case when atthasdef 204s then pg_get_expr(def.adbin, def.adrelid) 204s end as default , 204s case when s.seqname is not null then 'auto_increment' end as extra 204s from pg_class c 204s join pg_namespace n on n.oid = c.relnamespace 204s left join pg_attribute a on c.oid = a.attrelid 204s join pg_type t on t.oid = a.atttypid and attnum > 0 204s left join pg_attrdef def on a.attrelid = def.adrelid 204s and a.attnum = def.adnum 204s and a.atthasdef 204s left join seqattr s on def.adrelid = s.adrelid 204s and def.adnum = s.adnum 204s 204s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 204s and relkind in ('r', 'f', 'p') 204s and ((n.nspname = 'public' and c.relname = 'allcols')) 204s 204s 204s order by nspname, relname, attnum; 204s 2024-11-01T18:19:44.616016Z SQL -- params: including 204s -- filter-list-to-where-clause for including 204s -- excluding 204s -- filter-list-to-where-clause for excluding 204s select n.nspname, 204s i.relname, 204s i.oid, 204s rn.nspname, 204s r.relname, 204s indisprimary, 204s indisunique, 204s (select string_agg(attname, ',') 204s from pg_attribute 204s where attrelid = r.oid 204s and array[attnum::integer] <@ indkey::integer[] 204s ) as cols, 204s pg_get_indexdef(indexrelid), 204s c.conname, 204s pg_get_constraintdef(c.oid) 204s from pg_index x 204s join pg_class i ON i.oid = x.indexrelid 204s join pg_class r ON r.oid = x.indrelid 204s join pg_namespace n ON n.oid = i.relnamespace 204s join pg_namespace rn ON rn.oid = r.relnamespace 204s left join pg_depend d on d.classid = 'pg_class'::regclass 204s and d.objid = i.oid 204s and d.refclassid = 'pg_constraint'::regclass 204s and d.deptype = 'i' 204s left join pg_constraint c ON c.oid = d.refobjid 204s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 204s and ((rn.nspname = 'public' and r.relname = 'allcols')) 204s 204s order by n.nspname, r.relname 204s 2024-11-01T18:19:44.636016Z SQL -- params: including (table) 204s -- filter-list-to-where-clause for including 204s -- excluding (table) 204s -- filter-list-to-where-clause for excluding 204s -- including (ftable) 204s -- filter-list-to-where-clause for including 204s -- excluding (ftable) 204s -- filter-list-to-where-clause for excluding 204s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 204s r.oid, 204s d.refobjid as pkeyoid, 204s conname, 204s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 204s (select string_agg(attname, ',') 204s from pg_attribute 204s where attrelid = r.conrelid 204s and array[attnum::integer] <@ conkey::integer[] 204s ) as conkey, 204s (select string_agg(attname, ',') 204s from pg_attribute 204s where attrelid = r.confrelid 204s and array[attnum::integer] <@ confkey::integer[] 204s ) as confkey, 204s confupdtype, confdeltype, confmatchtype, 204s condeferrable, condeferred 204s from pg_catalog.pg_constraint r 204s JOIN pg_class c on r.conrelid = c.oid 204s JOIN pg_namespace n on c.relnamespace = n.oid 204s JOIN pg_class cf on r.confrelid = cf.oid 204s JOIN pg_namespace nf on cf.relnamespace = nf.oid 204s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 204s and d.objid = r.oid 204s and d.refobjsubid = 0 204s where r.contype = 'f' 204s AND c.relkind in ('r', 'f', 'p') 204s AND cf.relkind in ('r', 'f', 'p') 204s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 204s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 204s and ((n.nspname = 'public' and c.relname = 'allcols')) 204s 204s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 204s 204s 2024-11-01T18:19:44.644016Z SQL -- params pkey-oid-list 204s -- fkey-oild-list 204s with pkeys(oid) as ( 204s values(16406) 204s ), 204s knownfkeys(oid) as ( 204s values(-1) 204s ), 204s pkdeps as ( 204s select pkeys.oid, pg_depend.objid 204s from pg_depend 204s join pkeys on pg_depend.refobjid = pkeys.oid 204s where classid = 'pg_catalog.pg_constraint'::regclass 204s and refclassid = 'pg_catalog.pg_class'::regclass 204s ) 204s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 204s r.oid as conoid, conname, 204s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 204s pkdeps.oid as index_oid 204s from pg_catalog.pg_constraint r 204s JOIN pkdeps on r.oid = pkdeps.objid 204s JOIN pg_class c on r.conrelid = c.oid 204s JOIN pg_namespace n on c.relnamespace = n.oid 204s JOIN pg_class cf on r.confrelid = cf.oid 204s JOIN pg_namespace nf on cf.relnamespace = nf.oid 204s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 204s 2024-11-01T18:19:44.664017Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 204s 2024-11-01T18:19:44.668017Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 204s 2024-11-01T18:19:44.668017Z WARNING That could impact loading performance badly. 204s 2024-11-01T18:19:44.668017Z WARNING Consider the option 'drop indexes'. 204s 2024-11-01T18:19:44.712018Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 204s 2024-11-01T18:19:44.712018Z DEBUG Reader started for "public"."allcols" 204s 2024-11-01T18:19:44.716018Z DEBUG start "public"."allcols" 960023 204s 2024-11-01T18:19:44.724018Z INFO COPY ON ERROR RESUME NEXT 204s 2024-11-01T18:19:44.728018Z NOTICE Opening (:INLINE 204s (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/allcols.load" . 765)) 204s 2024-11-01T18:19:44.744019Z DEBUG Reader for "public"."allcols" is done in 0.032001s 204s 2024-11-01T18:19:44.748019Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.032001s 204s 2024-11-01T18:19:44.820019Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:44.824019Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:44.824019Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:44.824019Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:44.824019Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:44.824019Z SQL SET search_path TO "public"; 204s 2024-11-01T18:19:44.824019Z INFO pgsql:copy-rows-from-queue[1]: "public"."allcols" ("a" "b" "c") 204s 2024-11-01T18:19:44.828019Z DEBUG send-batch[1] "public"."allcols" 8 rows [ 0.2 kB] in 0.004000s 204s 2024-11-01T18:19:44.832019Z DEBUG stop "public"."allcols" | 960023 .. 1076024 = 0.116001d0 204s 2024-11-01T18:19:44.832019Z DEBUG Writer[1] for "public"."allcols" is done in 0.004000s 204s 2024-11-01T18:19:44.832019Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.004000s 204s 2024-11-01T18:19:44.844020Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 204s 2024-11-01T18:19:44.956022Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:44.956022Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:44.956022Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:44.956022Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:44.956022Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:44.964022Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/allcols.out") 204s 2024-11-01T18:19:45.076025Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:45.076025Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:45.076025Z DEBUG SET work_mem TO '14MB' 204s 2024-11-01T18:19:45.076025Z DEBUG SET standard_conforming_strings TO 'on' 204s 2024-11-01T18:19:45.076025Z DEBUG SET application_name TO 'pgloader' 204s 2024-11-01T18:19:45.076025Z NOTICE drop table if exists expected.allcols; 204s 2024-11-01T18:19:45.076025Z NOTICE create table expected.allcols(like allcols); 204s 2024-11-01T18:19:45.080025Z DEBUG LOAD DATA FROM # 204s 2024-11-01T18:19:45.208028Z DEBUG CONNECTED TO # 204s 2024-11-01T18:19:45.208028Z DEBUG SET client_encoding TO 'utf8' 204s 2024-11-01T18:19:45.208028Z DEBUG SET application_name TO 'pgloader' 205s 2024-11-01T18:19:45.328031Z DEBUG CONNECTED TO # 205s 2024-11-01T18:19:45.328031Z DEBUG SET client_encoding TO 'utf8' 205s 2024-11-01T18:19:45.328031Z DEBUG SET application_name TO 'pgloader' 205s 2024-11-01T18:19:45.332031Z SQL -- 205s -- get user defined SQL types 205s -- 205s select nt.nspname, 205s extname, 205s typname, 205s case when enum.enumtypid is not null 205s then array_agg(enum.enumlabel order by enumsortorder) 205s end as enumvalues 205s 205s from pg_class c 205s join pg_namespace n on n.oid = c.relnamespace 205s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 205s join pg_type t on t.oid = a.atttypid 205s left join pg_namespace nt on nt.oid = t.typnamespace 205s left join pg_depend d on d.classid = 'pg_type'::regclass 205s and d.refclassid = 'pg_extension'::regclass 205s and d.objid = t.oid 205s left join pg_extension e on refobjid = e.oid 205s left join pg_enum enum on enum.enumtypid = t.oid 205s 205s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 205s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 205s and c.relkind in ('r', 'f', 'p') 205s and ((n.nspname = 'expected' and c.relname = 'allcols')) 205s 205s and 205s ( t.typrelid = 0 205s or 205s (select c.relkind = 'c' 205s from pg_class c 205s where c.oid = t.typrelid) 205s ) 205s and not exists 205s ( 205s select 1 205s from pg_type el 205s where el.oid = t.typelem 205s and el.typarray = t.oid 205s ) 205s 205s group by nt.nspname, extname, typname, enumtypid 205s order by nt.nspname, extname, typname, enumtypid; 205s 2024-11-01T18:19:45.340031Z SQL -- params: table-type-name 205s -- including 205s -- filter-list-to-where-clause for including 205s -- excluding 205s -- filter-list-to-where-clause for excluding 205s with seqattr as 205s ( 205s select adrelid, 205s adnum, 205s pg_get_expr(d.adbin, d.adrelid) as adsrc, 205s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 205s then substring(pg_get_expr(d.adbin, d.adrelid) 205s from '''([^'']+)''' 205s ) 205s else null 205s end as seqname 205s from pg_attrdef d 205s ) 205s select nspname, relname, c.oid, attname, 205s t.oid::regtype as type, 205s case when atttypmod > 0 205s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 205s else null 205s end as typmod, 205s attnotnull, 205s case when atthasdef 205s then pg_get_expr(def.adbin, def.adrelid) 205s end as default , 205s case when s.seqname is not null then 'auto_increment' end as extra 205s from pg_class c 205s join pg_namespace n on n.oid = c.relnamespace 205s left join pg_attribute a on c.oid = a.attrelid 205s join pg_type t on t.oid = a.atttypid and attnum > 0 205s left join pg_attrdef def on a.attrelid = def.adrelid 205s and a.attnum = def.adnum 205s and a.atthasdef 205s left join seqattr s on def.adrelid = s.adrelid 205s and def.adnum = s.adnum 205s 205s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 205s and relkind in ('r', 'f', 'p') 205s and ((n.nspname = 'expected' and c.relname = 'allcols')) 205s 205s 205s order by nspname, relname, attnum; 205s 2024-11-01T18:19:45.344031Z SQL -- params: including 205s -- filter-list-to-where-clause for including 205s -- excluding 205s -- filter-list-to-where-clause for excluding 205s select n.nspname, 205s i.relname, 205s i.oid, 205s rn.nspname, 205s r.relname, 205s indisprimary, 205s indisunique, 205s (select string_agg(attname, ',') 205s from pg_attribute 205s where attrelid = r.oid 205s and array[attnum::integer] <@ indkey::integer[] 205s ) as cols, 205s pg_get_indexdef(indexrelid), 205s c.conname, 205s pg_get_constraintdef(c.oid) 205s from pg_index x 205s join pg_class i ON i.oid = x.indexrelid 205s join pg_class r ON r.oid = x.indrelid 205s join pg_namespace n ON n.oid = i.relnamespace 205s join pg_namespace rn ON rn.oid = r.relnamespace 205s left join pg_depend d on d.classid = 'pg_class'::regclass 205s and d.objid = i.oid 205s and d.refclassid = 'pg_constraint'::regclass 205s and d.deptype = 'i' 205s left join pg_constraint c ON c.oid = d.refobjid 205s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 205s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 205s 205s order by n.nspname, r.relname 205s 2024-11-01T18:19:45.348031Z SQL -- params: including (table) 205s -- filter-list-to-where-clause for including 205s -- excluding (table) 205s -- filter-list-to-where-clause for excluding 205s -- including (ftable) 205s -- filter-list-to-where-clause for including 205s -- excluding (ftable) 205s -- filter-list-to-where-clause for excluding 205s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 205s r.oid, 205s d.refobjid as pkeyoid, 205s conname, 205s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 205s (select string_agg(attname, ',') 205s from pg_attribute 205s where attrelid = r.conrelid 205s and array[attnum::integer] <@ conkey::integer[] 205s ) as conkey, 205s (select string_agg(attname, ',') 205s from pg_attribute 205s where attrelid = r.confrelid 205s and array[attnum::integer] <@ confkey::integer[] 205s ) as confkey, 205s confupdtype, confdeltype, confmatchtype, 205s condeferrable, condeferred 205s from pg_catalog.pg_constraint r 205s JOIN pg_class c on r.conrelid = c.oid 205s JOIN pg_namespace n on c.relnamespace = n.oid 205s JOIN pg_class cf on r.confrelid = cf.oid 205s JOIN pg_namespace nf on cf.relnamespace = nf.oid 205s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 205s and d.objid = r.oid 205s and d.refobjsubid = 0 205s where r.contype = 'f' 205s AND c.relkind in ('r', 'f', 'p') 205s AND cf.relkind in ('r', 'f', 'p') 205s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 205s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 205s and ((n.nspname = 'expected' and c.relname = 'allcols')) 205s 205s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 205s 205s 2024-11-01T18:19:45.356031Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 205s 2024-11-01T18:19:45.356031Z SQL TRUNCATE "expected"."allcols"; 205s 2024-11-01T18:19:45.376032Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 205s 2024-11-01T18:19:45.376032Z DEBUG Reader started for "expected"."allcols" 205s 2024-11-01T18:19:45.376032Z DEBUG start "expected"."allcols" 1624037 205s 2024-11-01T18:19:45.376032Z NOTICE Opening #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/allcols.out" 205s 2024-11-01T18:19:45.376032Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 205s 2024-11-01T18:19:45.376032Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 205s 2024-11-01T18:19:45.380032Z INFO COPY ON ERROR RESUME NEXT 205s 2024-11-01T18:19:45.492034Z DEBUG CONNECTED TO # 205s 2024-11-01T18:19:45.492034Z DEBUG SET client_encoding TO 'utf8' 205s 2024-11-01T18:19:45.492034Z DEBUG SET application_name TO 'pgloader' 205s 2024-11-01T18:19:45.492034Z SQL SET search_path TO "expected"; 205s 2024-11-01T18:19:45.492034Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 205s 2024-11-01T18:19:45.500034Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.004000s 205s 2024-11-01T18:19:45.500034Z DEBUG stop "expected"."allcols" | 1624037 .. 1744039 = 0.120002d0 205s 2024-11-01T18:19:45.500034Z DEBUG Writer[1] for "expected"."allcols" is done in 0.004000s 205s 2024-11-01T18:19:45.500034Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.004000s 205s 2024-11-01T18:19:45.500034Z LOG report summary reset 205s table name errors read imported bytes total time read write 205s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 205s fetch 0 0 0 0.008s 205s before load 0 2 2 0.120s 205s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 205s "public"."allcols" 0 8 8 0.2 kB 0.116s 0.032s 0.004s 205s "expected"."allcols" 0 8 8 0.2 kB 0.120s 0.004s 205s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 205s Files Processed 0 2 2 0.048s 205s COPY Threads Completion 0 4 4 0.244s 205s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 205s Total import time ✓ 16 16 0.4 kB 0.292s 205s 2024-11-01T18:19:45.624038Z DEBUG CONNECTED TO # 205s 2024-11-01T18:19:45.624038Z DEBUG SET client_encoding TO 'utf8' 205s 2024-11-01T18:19:45.624038Z DEBUG SET work_mem TO '14MB' 205s 2024-11-01T18:19:45.624038Z DEBUG SET standard_conforming_strings TO 'on' 205s 2024-11-01T18:19:45.624038Z DEBUG SET application_name TO 'pgloader' 205s 2024-11-01T18:19:45.632038Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 205s 2024-11-01T18:19:45.632038Z NOTICE Got a diff of 0 rows 205s 2024-11-01T18:19:45.632038Z LOG Regress pass. 205s 2024-11-01T18:19:45.632038Z INFO Stopping monitor 205s Dropping cluster 16/regress ... 207s + rm -rf /tmp/pgloader 207s autopkgtest [18:19:48]: test ssl: -----------------------] 209s ssl PASS 209s autopkgtest [18:19:50]: test ssl: - - - - - - - - - - results - - - - - - - - - - 209s autopkgtest [18:19:50]: test testsuite: preparing testbed 343s autopkgtest [18:22:04]: testbed dpkg architecture: ppc64el 343s autopkgtest [18:22:04]: testbed apt version: 2.9.8 343s autopkgtest [18:22:04]: @@@@@@@@@@@@@@@@@@@@ test bed setup 344s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 344s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 344s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [2775 kB] 345s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [44.0 kB] 345s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [183 kB] 345s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [221 kB] 345s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [1753 kB] 345s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [23.2 kB] 346s Fetched 5081 kB in 2s (3090 kB/s) 346s Reading package lists... 348s Reading package lists... 348s Building dependency tree... 348s Reading state information... 348s Calculating upgrade... 349s The following packages will be upgraded: 349s libevdev2 libftdi1-2 libinih1 nano python3-lazr.uri 349s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 349s Need to get 422 kB of archives. 349s After this operation, 17.4 kB of additional disk space will be used. 349s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libevdev2 ppc64el 1.13.3+dfsg-1 [39.2 kB] 349s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el nano ppc64el 8.2-1 [329 kB] 349s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libftdi1-2 ppc64el 1.5-7 [32.1 kB] 349s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libinih1 ppc64el 58-1ubuntu1 [7816 B] 349s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-lazr.uri all 1.0.6-4 [13.6 kB] 349s Fetched 422 kB in 0s (879 kB/s) 350s (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 ... 73549 files and directories currently installed.) 350s Preparing to unpack .../libevdev2_1.13.3+dfsg-1_ppc64el.deb ... 350s Unpacking libevdev2:ppc64el (1.13.3+dfsg-1) over (1.13.2+dfsg-1) ... 350s Preparing to unpack .../nano_8.2-1_ppc64el.deb ... 350s Unpacking nano (8.2-1) over (8.1-1) ... 350s Preparing to unpack .../libftdi1-2_1.5-7_ppc64el.deb ... 350s Unpacking libftdi1-2:ppc64el (1.5-7) over (1.5-6build5) ... 350s Preparing to unpack .../libinih1_58-1ubuntu1_ppc64el.deb ... 350s Unpacking libinih1:ppc64el (58-1ubuntu1) over (55-1ubuntu2) ... 350s Preparing to unpack .../python3-lazr.uri_1.0.6-4_all.deb ... 350s Unpacking python3-lazr.uri (1.0.6-4) over (1.0.6-3) ... 350s Setting up libinih1:ppc64el (58-1ubuntu1) ... 350s Setting up python3-lazr.uri (1.0.6-4) ... 350s Setting up libftdi1-2:ppc64el (1.5-7) ... 350s Setting up nano (8.2-1) ... 350s Setting up libevdev2:ppc64el (1.13.3+dfsg-1) ... 350s Processing triggers for man-db (2.12.1-3) ... 352s Processing triggers for install-info (7.1.1-1) ... 352s Processing triggers for libc-bin (2.40-1ubuntu3) ... 352s Reading package lists... 352s Building dependency tree... 352s Reading state information... 353s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 353s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 353s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 353s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 353s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 355s Reading package lists... 355s Reading package lists... 355s Building dependency tree... 355s Reading state information... 355s Calculating upgrade... 355s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 355s Reading package lists... 355s Building dependency tree... 355s Reading state information... 356s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 361s Reading package lists... 361s Building dependency tree... 361s Reading state information... 361s Starting pkgProblemResolver with broken count: 0 361s Starting 2 pkgProblemResolver with broken count: 0 361s Done 361s The following additional packages will be installed: 361s freetds-common freetds-dev libct4 libjson-perl libpq5 libsybdb5 libxslt1.1 361s pgloader postgresql-16 postgresql-16-ip4r postgresql-client-16 361s postgresql-client-common postgresql-common ssl-cert 361s Suggested packages: 361s postgresql-doc-16 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 libjson-perl libpq5 361s libsybdb5 libxslt1.1 pgloader postgresql-16 postgresql-16-ip4r 361s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 361s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 361s Need to get 45.5 MB/45.5 MB of archives. 361s After this operation, 96.9 MB of additional disk space will be used. 361s Get:1 /tmp/autopkgtest.pn6qe9/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [732 B] 362s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 362s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 262 [36.7 kB] 362s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.2ubuntu2 [18.0 kB] 362s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 262 [162 kB] 362s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-common all 1.3.17+ds-2build3 [26.9 kB] 362s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el libct4 ppc64el 1.3.17+ds-2build3 [211 kB] 362s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsybdb5 ppc64el 1.3.17+ds-2build3 [238 kB] 362s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el freetds-dev ppc64el 1.3.17+ds-2build3 [364 kB] 362s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.0-1 [280 kB] 362s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu1 [191 kB] 362s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-16 ppc64el 16.4-3 [1400 kB] 362s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-16 ppc64el 16.4-3 [16.6 MB] 363s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-16-ip4r ppc64el 2.4.2-2 [213 kB] 363s Get:15 http://ftpmaster.internal/ubuntu plucky/universe ppc64el pgloader ppc64el 3.6.10-3 [25.7 MB] 366s Preconfiguring packages ... 366s Fetched 45.5 MB in 4s (11.7 MB/s) 366s Selecting previously unselected package libjson-perl. 366s (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 ... 73549 files and directories currently installed.) 366s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 366s Unpacking libjson-perl (4.10000-1) ... 366s Selecting previously unselected package postgresql-client-common. 366s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 366s Unpacking postgresql-client-common (262) ... 366s Selecting previously unselected package ssl-cert. 366s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 366s Unpacking ssl-cert (1.1.2ubuntu2) ... 366s Selecting previously unselected package postgresql-common. 366s Preparing to unpack .../03-postgresql-common_262_all.deb ... 366s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 366s Unpacking postgresql-common (262) ... 366s Selecting previously unselected package freetds-common. 366s Preparing to unpack .../04-freetds-common_1.3.17+ds-2build3_all.deb ... 366s Unpacking freetds-common (1.3.17+ds-2build3) ... 366s Selecting previously unselected package libct4:ppc64el. 366s Preparing to unpack .../05-libct4_1.3.17+ds-2build3_ppc64el.deb ... 366s Unpacking libct4:ppc64el (1.3.17+ds-2build3) ... 366s Selecting previously unselected package libsybdb5:ppc64el. 366s Preparing to unpack .../06-libsybdb5_1.3.17+ds-2build3_ppc64el.deb ... 366s Unpacking libsybdb5:ppc64el (1.3.17+ds-2build3) ... 366s Selecting previously unselected package freetds-dev. 366s Preparing to unpack .../07-freetds-dev_1.3.17+ds-2build3_ppc64el.deb ... 366s Unpacking freetds-dev (1.3.17+ds-2build3) ... 366s Selecting previously unselected package libpq5:ppc64el. 366s Preparing to unpack .../08-libpq5_17.0-1_ppc64el.deb ... 366s Unpacking libpq5:ppc64el (17.0-1) ... 366s Selecting previously unselected package libxslt1.1:ppc64el. 366s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu1_ppc64el.deb ... 366s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 366s Selecting previously unselected package postgresql-client-16. 366s Preparing to unpack .../10-postgresql-client-16_16.4-3_ppc64el.deb ... 366s Unpacking postgresql-client-16 (16.4-3) ... 366s Selecting previously unselected package postgresql-16. 366s Preparing to unpack .../11-postgresql-16_16.4-3_ppc64el.deb ... 366s Unpacking postgresql-16 (16.4-3) ... 366s Selecting previously unselected package postgresql-16-ip4r. 366s Preparing to unpack .../12-postgresql-16-ip4r_2.4.2-2_ppc64el.deb ... 366s Unpacking postgresql-16-ip4r (2.4.2-2) ... 366s Selecting previously unselected package pgloader. 366s Preparing to unpack .../13-pgloader_3.6.10-3_ppc64el.deb ... 366s Unpacking pgloader (3.6.10-3) ... 367s Selecting previously unselected package autopkgtest-satdep. 367s Preparing to unpack .../14-2-autopkgtest-satdep.deb ... 367s Unpacking autopkgtest-satdep (0) ... 367s Setting up postgresql-client-common (262) ... 367s Setting up libpq5:ppc64el (17.0-1) ... 367s Setting up ssl-cert (1.1.2ubuntu2) ... 367s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 368s Setting up libjson-perl (4.10000-1) ... 368s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 368s Setting up freetds-common (1.3.17+ds-2build3) ... 368s Setting up postgresql-client-16 (16.4-3) ... 368s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 368s Setting up libsybdb5:ppc64el (1.3.17+ds-2build3) ... 368s Setting up libct4:ppc64el (1.3.17+ds-2build3) ... 368s Setting up postgresql-common (262) ... 369s 369s Creating config file /etc/postgresql-common/createcluster.conf with new version 369s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 369s Removing obsolete dictionary files: 370s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 370s Setting up postgresql-16 (16.4-3) ... 370s Creating new PostgreSQL cluster 16/main ... 370s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 370s The files belonging to this database system will be owned by user "postgres". 370s This user must also own the server process. 370s 370s The database cluster will be initialized with locale "C.UTF-8". 370s The default database encoding has accordingly been set to "UTF8". 370s The default text search configuration will be set to "english". 370s 370s Data page checksums are disabled. 370s 370s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 370s creating subdirectories ... ok 370s selecting dynamic shared memory implementation ... posix 370s selecting default max_connections ... 100 371s selecting default shared_buffers ... 128MB 371s selecting default time zone ... Etc/UTC 371s creating configuration files ... ok 371s running bootstrap script ... ok 371s performing post-bootstrap initialization ... ok 371s syncing data to disk ... ok 375s Setting up freetds-dev (1.3.17+ds-2build3) ... 375s Setting up pgloader (3.6.10-3) ... 375s Setting up postgresql-16-ip4r (2.4.2-2) ... 375s Setting up autopkgtest-satdep (0) ... 375s Processing triggers for man-db (2.12.1-3) ... 377s Processing triggers for libc-bin (2.40-1ubuntu3) ... 379s (Reading database ... 75681 files and directories currently installed.) 379s Removing autopkgtest-satdep (0) ... 382s autopkgtest [18:22:43]: test testsuite: [----------------------- 382s + PGSUPERUSER=ubuntu 382s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 382s Creating new PostgreSQL cluster 16/regress ... 385s make: Entering directory '/tmp/autopkgtest.pn6qe9/build.O9V/src/test' 385s dropdb -U ubuntu pgloader 385s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 385s dropdb -U ubuntu stocks 385s make: [Makefile:67: prepare] Error 1 (ignored) 385s dropdb: error: database removal failed: ERROR: database "stocks" does not exist 385s make: [Makefile:68: prepare] Error 1 (ignored) 385s dropdb -U ubuntu ip4r 386s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 386s make: [Makefile:69: prepare] Error 1 (ignored) 386s createuser -U ubuntu --superuser `whoami` 386s createdb -U ubuntu -O `whoami` pgloader 386s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 386s make: [Makefile:70: prepare] Error 1 (ignored) 386s createdb -U ubuntu -O `whoami` stocks 386s createdb -U ubuntu -O `whoami` ip4r 386s psql -d pgloader -c 'create schema expected' 386s CREATE SCHEMA 386s psql -U ubuntu -d pgloader -c 'create extension ip4r' 386s CREATE EXTENSION 386s psql -U ubuntu -d ip4r -c 'create extension ip4r' 386s CREATE EXTENSION 386s psql -d stocks -f bossa.sql 386s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 386s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 386s DROP TABLE 386s CREATE TABLE 386s CREATE TABLE 386s rm -f regress/out/* 386s pgloader --regress allcols.load 386s 2024-11-01T18:22:47.019999Z LOG pgloader version "3.6.7~devel" 386s 2024-11-01T18:22:47.023999Z LOG Regression testing: "allcols.load" 386s 2024-11-01T18:22:47.027999Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/allcols.load" 386s 2024-11-01T18:22:47.099998Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 387s 2024-11-01T18:22:47.335997Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 387s 2024-11-01T18:22:47.335997Z WARNING That could impact loading performance badly. 387s 2024-11-01T18:22:47.335997Z WARNING Consider the option 'drop indexes'. 387s 2024-11-01T18:22:47.431996Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 387s 2024-11-01T18:22:47.451995Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/allcols.out") 387s 2024-11-01T18:22:47.471995Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 387s 2024-11-01T18:22:47.591994Z LOG report summary reset 387s table name errors rows bytes total time 387s ----------------------- --------- --------- --------- -------------- 387s fetch 0 0 0.004s 387s before load 0 2 0.028s 387s ----------------------- --------- --------- --------- -------------- 387s "public"."allcols" 0 8 0.2 kB 0.052s 387s "expected"."allcols" 0 8 0.2 kB 0.032s 387s ----------------------- --------- --------- --------- -------------- 387s Files Processed 0 2 0.036s 387s COPY Threads Completion 0 4 0.084s 387s ----------------------- --------- --------- --------- -------------- 387s Total import time ✓ 16 0.4 kB 0.120s 387s 2024-11-01T18:22:47.667993Z LOG Regress pass. 387s touch regress/out/allcols.out 387s pgloader --regress csv-before-after.load 387s 2024-11-01T18:22:48.039999Z LOG pgloader version "3.6.7~devel" 388s 2024-11-01T18:22:48.803991Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-before-after.out") 388s 2024-11-01T18:22:48.827991Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 388s 2024-11-01T18:22:48.955989Z LOG report summary reset 388s table name errors rows bytes total time 388s ----------------------- --------- --------- --------- -------------- 388s fetch 0 0 0.008s 388s before load 0 6 0.028s 388s ----------------------- --------- --------- --------- -------------- 388s "csv"."blocks" 0 460 15.9 kB 0.360s 388s "expected"."blocks" 0 460 12.4 kB 0.028s 388s ----------------------- --------- --------- --------- -------------- 388s Files Processed 0 2 0.044s 388s COPY Threads Completion 0 4 0.392s 388s after load 0 1 0.028s 388s ----------------------- --------- --------- --------- -------------- 388s Total import time ✓ 920 28.2 kB 0.464s 388s 2024-11-01T18:22:49.015989Z LOG Regress pass. 388s touch regress/out/csv-before-after.out 388s pgloader --regress csv-districts.load 389s 2024-11-01T18:22:50.020000Z LOG pgloader version "3.6.7~devel" 389s 2024-11-01T18:22:50.024000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-districts.load" 389s 2024-11-01T18:22:50.615994Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-districts.out") 389s 2024-11-01T18:22:50.635994Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 389s 2024-11-01T18:22:50.795992Z LOG report summary reset 389s table name errors rows bytes total time 389s ----------------------- --------- --------- --------- -------------- 389s fetch 0 0 0.008s 389s before load 0 2 0.024s 389s ----------------------- --------- --------- --------- -------------- 389s "public"."districts" 0 440 29.3 kB 0.256s 389s "expected"."districts" 0 440 29.1 kB 0.060s 389s ----------------------- --------- --------- --------- -------------- 389s Files Processed 0 2 0.048s 389s COPY Threads Completion 0 4 0.316s 389s ----------------------- --------- --------- --------- -------------- 389s Total import time ✓ 880 58.3 kB 0.364s 389s 2024-11-01T18:22:50.859991Z LOG Regress pass. 389s touch regress/out/csv-districts.out 389s pgloader --regress csv-parse-date.load 390s 2024-11-01T18:22:51.012000Z LOG pgloader version "3.6.7~devel" 390s 2024-11-01T18:22:51.403996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-parse-date.out") 390s 2024-11-01T18:22:51.423996Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 390s 2024-11-01T18:22:51.547994Z LOG report summary reset 390s table name errors rows bytes total time 390s ----------------------- --------- --------- --------- -------------- 390s fetch 0 0 0.008s 390s before load 0 2 0.028s 390s ----------------------- --------- --------- --------- -------------- 390s "public"."dateformat" 0 4 0.1 kB 0.044s 390s "expected"."dateformat" 0 4 0.1 kB 0.024s 390s ----------------------- --------- --------- --------- -------------- 390s Files Processed 0 2 0.040s 390s COPY Threads Completion 0 4 0.068s 390s ----------------------- --------- --------- --------- -------------- 390s Total import time ✓ 8 0.3 kB 0.108s 390s 2024-11-01T18:22:51.607994Z LOG Regress pass. 390s touch regress/out/csv-parse-date.out 390s pgloader --regress csv-error.load 391s 2024-11-01T18:22:52.016000Z LOG pgloader version "3.6.7~devel" 391s 2024-11-01T18:22:52.363998Z FATAL :ASCII stream decoding error on 391s #: 391s 391s the octet sequence #(195) cannot be decoded. 391s 2024-11-01T18:22:52.363998Z 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-01T18:22:52.403997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-error.out") 391s 2024-11-01T18:22:52.427997Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 391s 2024-11-01T18:22:52.535996Z LOG report summary reset 391s table name errors rows bytes total time 391s ----------------------- --------- --------- --------- -------------- 391s fetch 0 0 0.004s 391s before load 0 2 0.028s 391s ----------------------- --------- --------- --------- -------------- 391s "public"."jordane" 3 3 0.1 kB 0.048s 391s "expected"."jordane" 0 3 0.1 kB 0.020s 391s ----------------------- --------- --------- --------- -------------- 391s Files Processed 0 2 0.036s 391s COPY Threads Completion 0 4 0.072s 391s ----------------------- --------- --------- --------- -------------- 391s Total import time 3 6 0.2 kB 0.108s 391s 2024-11-01T18:22:52.595995Z LOG Regress pass. 391s touch regress/out/csv-error.out 391s pgloader --regress csv-escape-mode.load 392s 2024-11-01T18:22:52.012000Z LOG pgloader version "3.6.7~devel" 392s 2024-11-01T18:22:52.016000Z LOG Regression testing: "csv-escape-mode.load" 392s 2024-11-01T18:22:52.016000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-escape-mode.load" 392s 2024-11-01T18:22:52.335998Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 392s 2024-11-01T18:22:52.335998Z WARNING That could impact loading performance badly. 392s 2024-11-01T18:22:52.335998Z WARNING Consider the option 'drop indexes'. 392s 2024-11-01T18:22:52.499996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-escape-mode.out") 392s 2024-11-01T18:22:52.519996Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 392s 2024-11-01T18:22:52.619995Z LOG report summary reset 392s table name errors rows bytes total time 392s ---------------------------- --------- --------- --------- -------------- 392s fetch 0 0 0.004s 392s before load 0 2 0.048s 392s ---------------------------- --------- --------- --------- -------------- 392s "public"."csv_escape_mode" 0 5 0.1 kB 0.096s 392s "expected"."csv_escape_mode" 0 5 0.1 kB 0.020s 392s ---------------------------- --------- --------- --------- -------------- 392s Files Processed 0 2 0.044s 392s COPY Threads Completion 0 4 0.112s 392s ---------------------------- --------- --------- --------- -------------- 392s Total import time ✓ 10 0.2 kB 0.156s 392s 2024-11-01T18:22:52.671995Z LOG Regress pass. 392s touch regress/out/csv-escape-mode.out 392s pgloader --regress csv-filename-pattern.load 393s 2024-11-01T18:22:53.040000Z LOG pgloader version "3.6.7~devel" 393s 2024-11-01T18:22:53.056000Z LOG Data errors in '/tmp/pgloader/' 393s 2024-11-01T18:22:53.056000Z LOG Regression testing: "csv-filename-pattern.load" 393s 2024-11-01T18:22:53.056000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-filename-pattern.load" 393s 2024-11-01T18:22:53.487997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-filename-pattern.out") 393s 2024-11-01T18:22:53.511996Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 393s 2024-11-01T18:22:53.651995Z LOG report summary reset 393s table name errors rows bytes total time 393s ----------------------- --------- --------- --------- -------------- 393s fetch 0 0 0.008s 393s before load 0 2 0.020s 393s ----------------------- --------- --------- --------- -------------- 393s "public"."matching" 0 3 0.0 kB 0.032s 393s "expected"."matching" 0 3 0.0 kB 0.028s 393s ----------------------- --------- --------- --------- -------------- 393s Files Processed 0 4 0.048s 393s COPY Threads Completion 0 8 0.128s 393s ----------------------- --------- --------- --------- -------------- 393s Total import time ✓ 6 0.0 kB 0.176s 393s 2024-11-01T18:22:53.707995Z LOG Regress pass. 393s touch regress/out/csv-filename-pattern.out 393s pgloader --regress csv-guess.load 394s 2024-11-01T18:22:54.024000Z LOG pgloader version "3.6.7~devel" 394s 2024-11-01T18:22:54.028000Z LOG Data errors in '/tmp/pgloader/' 394s 2024-11-01T18:22:54.028000Z LOG Regression testing: "csv-guess.load" 394s 2024-11-01T18:22:54.028000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-guess.load" 394s 2024-11-01T18:22:54.315998Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 394s 2024-11-01T18:22:54.315998Z WARNING That could impact loading performance badly. 394s 2024-11-01T18:22:54.315998Z WARNING Consider the option 'drop indexes'. 395s 2024-11-01T18:22:55.231990Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-guess.out") 395s 2024-11-01T18:22:55.251990Z WARNING PostgreSQL warning: table "track" does not exist, skipping 395s 2024-11-01T18:22:55.467988Z LOG report summary reset 395s table name errors rows bytes total time 395s ----------------------- --------- --------- --------- -------------- 395s fetch 0 0 0.004s 395s before load 0 2 0.036s 395s ----------------------- --------- --------- --------- -------------- 395s "csv"."track" 0 3503 366.8 kB 0.832s 395s "expected"."track" 0 3503 366.8 kB 0.120s 395s ----------------------- --------- --------- --------- -------------- 395s Files Processed 0 2 0.040s 395s COPY Threads Completion 0 4 0.952s 395s ----------------------- --------- --------- --------- -------------- 395s Total import time ✓ 7006 733.5 kB 0.992s 395s 2024-11-01T18:22:55.535988Z LOG Regress pass. 395s touch regress/out/csv-guess.out 395s pgloader --regress csv-header.load 395s 2024-11-01T18:22:56.040000Z LOG pgloader version "3.6.7~devel" 396s 2024-11-01T18:22:56.455998Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-header.out") 396s 2024-11-01T18:22:56.475997Z WARNING PostgreSQL warning: table "group" does not exist, skipping 396s 2024-11-01T18:22:56.595997Z LOG report summary reset 396s table name errors rows bytes total time 396s ----------------------- --------- --------- --------- -------------- 396s fetch 0 0 0.004s 396s before load 0 2 0.032s 396s ----------------------- --------- --------- --------- -------------- 396s "public"."group" 0 2 0.0 kB 0.040s 396s "expected"."group" 0 2 0.0 kB 0.032s 396s ----------------------- --------- --------- --------- -------------- 396s Files Processed 0 2 0.064s 396s COPY Threads Completion 0 4 0.064s 396s ----------------------- --------- --------- --------- -------------- 396s Total import time ✓ 4 0.1 kB 0.128s 396s 2024-11-01T18:22:56.667996Z LOG Regress pass. 396s touch regress/out/csv-header.out 396s pgloader --regress csv-json.load 396s 2024-11-01T18:22:57.036000Z LOG pgloader version "3.6.7~devel" 397s 2024-11-01T18:22:57.495997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-json.out") 397s 2024-11-01T18:22:57.519997Z WARNING PostgreSQL warning: table "json" does not exist, skipping 397s 2024-11-01T18:22:57.663996Z LOG report summary reset 397s table name errors rows bytes total time 397s ----------------------- --------- --------- --------- -------------- 397s fetch 0 0 0.012s 397s before load 0 2 0.036s 397s ----------------------- --------- --------- --------- -------------- 397s "public"."json" 0 15 1.1 kB 0.064s 397s "expected"."json" 0 15 1.1 kB 0.028s 397s ----------------------- --------- --------- --------- -------------- 397s Files Processed 0 2 0.060s 397s COPY Threads Completion 0 4 0.092s 397s ----------------------- --------- --------- --------- -------------- 397s Total import time ✓ 30 2.3 kB 0.152s 397s 2024-11-01T18:22:57.715996Z LOG Regress pass. 397s touch regress/out/csv-json.out 397s pgloader --regress csv-keep-extra-blanks.load 397s 2024-11-01T18:22:58.032000Z LOG pgloader version "3.6.7~devel" 398s 2024-11-01T18:22:58.427997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-keep-extra-blanks.out") 398s 2024-11-01T18:22:58.443998Z WARNING PostgreSQL warning: table "nulls" does not exist, skipping 398s 2024-11-01T18:22:58.567997Z LOG report summary reset 398s table name errors rows bytes total time 398s ----------------------- --------- --------- --------- -------------- 398s fetch 0 0 0.020s 398s before load 0 2 0.032s 398s ----------------------- --------- --------- --------- -------------- 398s "public"."nulls" 0 7 0.3 kB 0.060s 398s "expected"."nulls" 0 6 0.3 kB 0.024s 398s ----------------------- --------- --------- --------- -------------- 398s Files Processed 0 2 0.032s 398s COPY Threads Completion 0 4 0.084s 398s ----------------------- --------- --------- --------- -------------- 398s Total import time ✓ 13 0.6 kB 0.116s 398s 2024-11-01T18:22:58.615997Z LOG Regress pass. 398s touch regress/out/csv-keep-extra-blanks.out 398s pgloader --regress csv-missing-col.load 398s 2024-11-01T18:22:59.023999Z LOG pgloader version "3.6.7~devel" 398s 2024-11-01T18:22:59.027999Z LOG Data errors in '/tmp/pgloader/' 398s 2024-11-01T18:22:59.027999Z LOG Regression testing: "csv-missing-col.load" 398s 2024-11-01T18:22:59.027999Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-missing-col.load" 399s 2024-11-01T18:22:59.371997Z LOG COPY INIT ERROR 399s 2024-11-01T18:22:59.375997Z FATAL Can't init COPY to "public"."missingcol"("a", "b", "c", "d", "e", "f", "g"): 399s Database error 42703: column "c" of relation "missingcol" does not exist 399s 2024-11-01T18:22:59.423996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-missing-col.out") 399s 2024-11-01T18:22:59.451996Z WARNING PostgreSQL warning: table "missingcol" does not exist, skipping 399s 2024-11-01T18:22:59.583996Z LOG report summary reset 399s table name errors rows bytes total time 399s ----------------------- --------- --------- --------- -------------- 399s fetch 0 0 0.008s 399s before load 0 2 0.024s 399s ----------------------- --------- --------- --------- -------------- 399s "public"."missingcol" 1 0 0.048s 399s "expected"."missingcol" 0 0 0.036s 399s ----------------------- --------- --------- --------- -------------- 399s Files Processed 0 2 0.052s 399s COPY Threads Completion 0 4 0.092s 399s ----------------------- --------- --------- --------- -------------- 399s Total import time 1 0 0.144s 399s 2024-11-01T18:22:59.659996Z LOG Regress pass. 399s touch regress/out/csv-missing-col.out 399s pgloader --regress csv-non-printable.load 399s 2024-11-01T18:23:00.016000Z LOG pgloader version "3.6.7~devel" 399s 2024-11-01T18:23:00.020000Z LOG Data errors in '/tmp/pgloader/' 399s 2024-11-01T18:23:00.020000Z LOG Regression testing: "csv-non-printable.load" 399s 2024-11-01T18:23:00.020000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-non-printable.load" 399s 2024-11-01T18:23:00.431996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-non-printable.out") 400s 2024-11-01T18:23:00.447996Z WARNING PostgreSQL warning: table "tab_csv" does not exist, skipping 400s 2024-11-01T18:23:00.571995Z LOG report summary reset 400s table name errors rows bytes total time 400s ----------------------- --------- --------- --------- -------------- 400s fetch 0 0 0.008s 400s before load 0 2 0.024s 400s ----------------------- --------- --------- --------- -------------- 400s "public"."tab_csv" 0 7 0.2 kB 0.056s 400s "expected"."tab_csv" 0 7 0.2 kB 0.028s 400s ----------------------- --------- --------- --------- -------------- 400s Files Processed 0 2 0.036s 400s COPY Threads Completion 0 4 0.088s 400s ----------------------- --------- --------- --------- -------------- 400s Total import time ✓ 14 0.4 kB 0.124s 400s 2024-11-01T18:23:00.619995Z LOG Regress pass. 400s touch regress/out/csv-non-printable.out 400s pgloader --regress csv-nulls.load 400s 2024-11-01T18:23:01.015999Z LOG pgloader version "3.6.7~devel" 400s 2024-11-01T18:23:01.343997Z WARNING Target table "\"public\".\"nullif\"" has 1 indexes defined against it. 400s 2024-11-01T18:23:01.343997Z WARNING That could impact loading performance badly. 400s 2024-11-01T18:23:01.343997Z WARNING Consider the option 'drop indexes'. 400s 2024-11-01T18:23:01.475996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-nulls.out") 400s 2024-11-01T18:23:01.491996Z WARNING PostgreSQL warning: table "nullif" does not exist, skipping 401s 2024-11-01T18:23:01.647995Z LOG report summary reset 401s table name errors rows bytes total time 401s ----------------------- --------- --------- --------- -------------- 401s fetch 0 0 0.008s 401s before load 0 2 0.028s 401s ----------------------- --------- --------- --------- -------------- 401s "public"."nullif" 0 2 0.0 kB 0.060s 401s "expected"."nullif" 0 2 0.0 kB 0.032s 401s ----------------------- --------- --------- --------- -------------- 401s Files Processed 0 2 0.032s 401s COPY Threads Completion 0 4 0.104s 401s ----------------------- --------- --------- --------- -------------- 401s Total import time ✓ 4 0.1 kB 0.136s 401s 2024-11-01T18:23:01.715994Z LOG Regress pass. 401s touch regress/out/csv-nulls.out 401s pgloader --regress csv-temp.load 401s 2024-11-01T18:23:02.016000Z LOG pgloader version "3.6.7~devel" 401s 2024-11-01T18:23:02.435997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-temp.out") 401s 2024-11-01T18:23:02.459997Z WARNING PostgreSQL warning: table "temp" does not exist, skipping 402s 2024-11-01T18:23:02.571996Z LOG report summary reset 402s table name errors rows bytes total time 402s ----------------------- --------- --------- --------- -------------- 402s fetch 0 0 0.008s 402s before load 0 2 0.028s 402s ----------------------- --------- --------- --------- -------------- 402s "public"."temp" 0 5 0.2 kB 0.048s 402s "expected"."temp" 0 5 0.2 kB 0.028s 402s ----------------------- --------- --------- --------- -------------- 402s Files Processed 0 2 0.040s 402s COPY Threads Completion 0 4 0.080s 402s ----------------------- --------- --------- --------- -------------- 402s Total import time ✓ 10 0.3 kB 0.120s 402s 2024-11-01T18:23:02.619995Z LOG Regress pass. 402s touch regress/out/csv-temp.out 402s pgloader --regress csv-trim-extra-blanks.load 402s 2024-11-01T18:23:03.019999Z LOG pgloader version "3.6.7~devel" 402s 2024-11-01T18:23:03.023999Z LOG Data errors in '/tmp/pgloader/' 402s 2024-11-01T18:23:03.023999Z LOG Regression testing: "csv-trim-extra-blanks.load" 402s 2024-11-01T18:23:03.023999Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/csv-trim-extra-blanks.load" 402s 2024-11-01T18:23:03.455996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-trim-extra-blanks.out") 402s 2024-11-01T18:23:03.599995Z LOG report summary reset 403s table name errors rows bytes total time 403s ----------------------- --------- --------- --------- -------------- 403s fetch 0 0 0.008s 403s before load 0 2 0.036s 403s ----------------------- --------- --------- --------- -------------- 403s "public"."nulls" 0 7 0.3 kB 0.048s 403s "expected"."nulls" 0 7 0.3 kB 0.020s 403s ----------------------- --------- --------- --------- -------------- 403s Files Processed 0 2 0.036s 403s COPY Threads Completion 0 4 0.080s 403s ----------------------- --------- --------- --------- -------------- 403s Total import time ✓ 14 0.6 kB 0.116s 403s 2024-11-01T18:23:03.651995Z LOG Regress pass. 403s touch regress/out/csv-trim-extra-blanks.out 403s pgloader --regress csv-using-sexp.load 403s 2024-11-01T18:23:04.027999Z LOG pgloader version "3.6.7~devel" 403s 2024-11-01T18:23:04.435997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv-using-sexp.out") 403s 2024-11-01T18:23:04.467996Z WARNING PostgreSQL warning: table "sexp" does not exist, skipping 403s 2024-11-01T18:23:04.595996Z LOG report summary reset 403s table name errors rows bytes total time 403s ----------------------- --------- --------- --------- -------------- 403s fetch 0 0 0.004s 403s before load 0 2 0.028s 403s ----------------------- --------- --------- --------- -------------- 403s "public"."sexp" 0 3 0.0 kB 0.060s 403s "expected"."sexp" 0 3 0.0 kB 0.024s 403s ----------------------- --------- --------- --------- -------------- 403s Files Processed 0 2 0.040s 403s COPY Threads Completion 0 4 0.080s 403s ----------------------- --------- --------- --------- -------------- 403s Total import time ✓ 6 0.1 kB 0.120s 403s 2024-11-01T18:23:04.655995Z LOG Regress pass. 403s touch regress/out/csv-using-sexp.out 404s pgloader --regress csv.load 404s 2024-11-01T18:23:05.020000Z LOG pgloader version "3.6.7~devel" 404s 2024-11-01T18:23:05.091999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 404s 2024-11-01T18:23:05.431997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 404s 2024-11-01T18:23:05.455997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/csv.out") 404s 2024-11-01T18:23:05.479997Z WARNING PostgreSQL warning: table "csv" does not exist, skipping 404s 2024-11-01T18:23:05.615996Z LOG report summary reset 404s table name errors rows bytes total time 404s ----------------------- --------- --------- --------- -------------- 404s fetch 0 0 0.008s 404s before load 0 2 0.028s 404s ----------------------- --------- --------- --------- -------------- 404s "public"."csv" 0 6 0.2 kB 0.064s 404s "expected"."csv" 0 6 0.2 kB 0.028s 404s ----------------------- --------- --------- --------- -------------- 404s Files Processed 0 2 0.032s 404s COPY Threads Completion 0 4 0.088s 404s ----------------------- --------- --------- --------- -------------- 404s Total import time ✓ 12 0.4 kB 0.120s 404s 2024-11-01T18:23:05.679995Z LOG Regress pass. 404s touch regress/out/csv.out 404s pgloader --regress copy.load 405s 2024-11-01T18:23:06.020001Z LOG pgloader version "3.6.7~devel" 405s 2024-11-01T18:23:06.120000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 405s 2024-11-01T18:23:06.575997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 405s 2024-11-01T18:23:06.595997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/copy.out") 405s 2024-11-01T18:23:06.615997Z WARNING PostgreSQL warning: table "track_full" does not exist, skipping 406s 2024-11-01T18:23:06.823995Z LOG report summary reset 406s table name errors rows bytes total time 406s ----------------------- --------- --------- --------- -------------- 406s fetch 0 0 0.008s 406s before load 0 2 0.032s 406s ----------------------- --------- --------- --------- -------------- 406s "public"."track_full" 0 3503 366.8 kB 0.084s 406s "expected"."track_full" 0 3503 366.8 kB 0.112s 406s ----------------------- --------- --------- --------- -------------- 406s Files Processed 0 2 0.036s 406s COPY Threads Completion 0 4 0.196s 406s Index Build Completion 0 0 0.024s 406s Create Indexes 0 1 0.004s 406s Constraints 0 1 0.004s 406s ----------------------- --------- --------- --------- -------------- 406s Total import time ✓ 7006 733.5 kB 0.264s 406s 2024-11-01T18:23:06.879994Z LOG Regress pass. 406s touch regress/out/copy.out 406s pgloader --regress copy-hex.load 406s 2024-11-01T18:23:07.012000Z LOG pgloader version "3.6.7~devel" 406s 2024-11-01T18:23:07.455997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/copy-hex.out") 406s 2024-11-01T18:23:07.475997Z WARNING PostgreSQL warning: table "copyhex" does not exist, skipping 406s 2024-11-01T18:23:07.607996Z LOG report summary reset 407s table name errors rows bytes total time 407s ----------------------- --------- --------- --------- -------------- 407s fetch 0 0 0.016s 407s before load 0 2 0.040s 407s ----------------------- --------- --------- --------- -------------- 407s "public"."copyhex" 0 6 0.0 kB 0.048s 407s "expected"."copyhex" 0 6 0.0 kB 0.028s 407s ----------------------- --------- --------- --------- -------------- 407s Files Processed 0 2 0.040s 407s COPY Threads Completion 0 4 0.072s 407s ----------------------- --------- --------- --------- -------------- 407s Total import time ✓ 12 0.1 kB 0.112s 407s 2024-11-01T18:23:07.671996Z LOG Regress pass. 407s touch regress/out/copy-hex.out 407s pgloader --regress dbf.load 407s 2024-11-01T18:23:08.012000Z LOG pgloader version "3.6.7~devel" 407s 2024-11-01T18:23:08.147999Z LOG Migrating from # 407s 2024-11-01T18:23:08.151999Z LOG Migrating into # 407s 2024-11-01T18:23:08.431997Z WARNING Forcing encoding to CP850, db3 file has ASCII 407s 2024-11-01T18:23:08.563996Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/dbf.out") 407s 2024-11-01T18:23:08.595996Z WARNING PostgreSQL warning: table "reg2013" does not exist, skipping 408s 2024-11-01T18:23:08.863994Z LOG report summary reset 408s table name errors rows bytes total time 408s ----------------------- --------- --------- --------- -------------- 408s fetch 0 0 0.016s 408s Create Schemas 0 0 0.004s 408s Create SQL Types 0 0 0.016s 408s Create tables 0 2 0.064s 408s ----------------------- --------- --------- --------- -------------- 408s public.reg2013 0 27 1.0 kB 0.032s 408s "expected"."reg2013" 0 27 1.0 kB 0.040s 408s ----------------------- --------- --------- --------- -------------- 408s COPY Threads Completion 0 6 0.076s 408s Create Triggers 0 0 0.000s 408s Install Comments 0 0 0.000s 408s Files Processed 0 1 0.016s 408s ----------------------- --------- --------- --------- -------------- 408s Total import time ✓ 54 1.9 kB 0.092s 408s 2024-11-01T18:23:08.931994Z LOG Regress pass. 408s touch regress/out/dbf.out 408s pgloader --regress errors.load 408s 2024-11-01T18:23:09.040000Z LOG pgloader version "3.6.7~devel" 408s 2024-11-01T18:23:09.083999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 408s 2024-11-01T18:23:09.307998Z WARNING Target table "\"err\".\"errors\"" has 1 indexes defined against it. 408s 2024-11-01T18:23:09.307998Z WARNING That could impact loading performance badly. 408s 2024-11-01T18:23:09.307998Z WARNING Consider the option 'drop indexes'. 408s 2024-11-01T18:23:09.395998Z ERROR End of file while collecting quoted item: # 408s 2024-11-01T18:23:09.395998Z FATAL End of file while collecting quoted item: # 408s 2024-11-01T18:23:09.407997Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-11" 408s HINT: Perhaps you need a different "datestyle" setting. 408s CONTEXT: COPY errors, line 3, column b: "2006-13-11" 408s 2024-11-01T18:23:09.415997Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-16-4" 408s HINT: Perhaps you need a different "datestyle" setting. 408s CONTEXT: COPY errors, line 1, column b: "2006-16-4" 408s 2024-11-01T18:23:09.415997Z ERROR PostgreSQL ["\"err\".\"errors\""] Database error 22008: date/time field value out of range: "2006-13-10" 408s HINT: Perhaps you need a different "datestyle" setting. 408s CONTEXT: COPY errors, line 2, column b: "2006-13-10" 408s 2024-11-01T18:23:09.435997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 409s 2024-11-01T18:23:09.463997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/errors.out") 409s 2024-11-01T18:23:09.491997Z WARNING PostgreSQL warning: table "errors" does not exist, skipping 409s 2024-11-01T18:23:09.659997Z LOG report summary reset 409s table name errors rows bytes total time 409s ----------------------- --------- --------- --------- -------------- 409s fetch 0 0 0.004s 409s before load 0 4 0.028s 409s ----------------------- --------- --------- --------- -------------- 409s "err"."errors" 8 7 0.3 kB 0.072s 409s "expected"."errors" 0 7 0.2 kB 0.048s 409s ----------------------- --------- --------- --------- -------------- 409s Files Processed 0 2 0.036s 409s COPY Threads Completion 0 4 0.144s 409s ----------------------- --------- --------- --------- -------------- 409s Total import time 8 14 0.6 kB 0.180s 409s 2024-11-01T18:23:09.751995Z LOG Regress pass. 409s touch regress/out/errors.out 409s pgloader --regress fixed.load 409s 2024-11-01T18:23:10.032000Z LOG pgloader version "3.6.7~devel" 409s 2024-11-01T18:23:10.036000Z LOG Data errors in '/tmp/pgloader/' 409s 2024-11-01T18:23:10.036000Z LOG Regression testing: "fixed.load" 409s 2024-11-01T18:23:10.036000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/fixed.load" 409s 2024-11-01T18:23:10.127999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 410s 2024-11-01T18:23:10.567997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 410s 2024-11-01T18:23:10.611997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/fixed.out") 410s 2024-11-01T18:23:10.635997Z WARNING PostgreSQL warning: table "fixed" does not exist, skipping 410s 2024-11-01T18:23:10.811995Z LOG report summary reset 410s table name errors rows bytes total time 410s ----------------------- --------- --------- --------- -------------- 410s fetch 0 0 0.004s 410s before load 0 2 0.044s 410s ----------------------- --------- --------- --------- -------------- 410s "public"."fixed" 0 5 0.2 kB 0.060s 410s "expected"."fixed" 0 5 0.2 kB 0.060s 410s ----------------------- --------- --------- --------- -------------- 410s Files Processed 0 2 0.052s 410s COPY Threads Completion 0 4 0.120s 410s Index Build Completion 0 0 0.032s 410s Create Indexes 0 1 0.004s 410s Constraints 0 1 0.000s 410s ----------------------- --------- --------- --------- -------------- 410s Total import time ✓ 10 0.4 kB 0.208s 410s 2024-11-01T18:23:10.895995Z LOG Regress pass. 410s touch regress/out/fixed.out 410s pgloader --regress fields-with-periods.load 410s 2024-11-01T18:23:11.032000Z LOG pgloader version "3.6.7~devel" 411s 2024-11-01T18:23:11.463999Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/fields-with-periods.out") 411s 2024-11-01T18:23:11.639997Z LOG report summary reset 411s table name errors rows bytes total time 411s ----------------------- --------- --------- --------- -------------- 411s fetch 0 0 0.012s 411s before load 0 2 0.024s 411s ----------------------- --------- --------- --------- -------------- 411s "public"."fixed" 0 3 0.0 kB 0.048s 411s "expected"."fixed" 0 3 0.0 kB 0.060s 411s ----------------------- --------- --------- --------- -------------- 411s Files Processed 0 2 0.032s 411s COPY Threads Completion 0 4 0.108s 411s ----------------------- --------- --------- --------- -------------- 411s Total import time ✓ 6 0.0 kB 0.140s 411s 2024-11-01T18:23:11.759996Z LOG Regress pass. 411s touch regress/out/fields-with-periods.out 411s pgloader --regress ixf.load 412s 2024-11-01T18:23:12.020000Z LOG pgloader version "3.6.7~devel" 412s 2024-11-01T18:23:12.020000Z LOG Data errors in '/tmp/pgloader/' 412s 2024-11-01T18:23:12.020000Z LOG Regression testing: "ixf.load" 412s 2024-11-01T18:23:12.020000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/ixf.load" 412s 2024-11-01T18:23:12.211999Z LOG Migrating from # 412s 2024-11-01T18:23:12.211999Z LOG Migrating into # 412s 2024-11-01T18:23:12.547998Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/ixf.out") 412s 2024-11-01T18:23:12.571998Z WARNING PostgreSQL warning: table "test1" does not exist, skipping 412s 2024-11-01T18:23:12.747996Z LOG report summary reset 412s table name errors rows bytes total time 412s ----------------------- --------- --------- --------- -------------- 412s fetch 0 0 0.008s 412s before load 0 3 0.028s 412s Create Schemas 0 0 0.000s 412s Create SQL Types 0 0 0.012s 412s Create tables 0 2 0.036s 412s ----------------------- --------- --------- --------- -------------- 412s nsitra.test1 0 4 0.2 kB 0.040s 412s "expected"."test1" 0 4 0.2 kB 0.032s 412s ----------------------- --------- --------- --------- -------------- 412s COPY Threads Completion 0 6 0.088s 412s Index Build Completion 0 0 0.004s 412s Primary Keys 0 0 0.000s 412s Create Triggers 0 0 0.004s 412s Install Comments 0 0 0.000s 412s Files Processed 0 1 0.008s 412s ----------------------- --------- --------- --------- -------------- 412s Total import time ✓ 8 0.3 kB 0.104s 412s 2024-11-01T18:23:12.807995Z LOG Regress pass. 412s touch regress/out/ixf.out 412s pgloader --regress overflow.load 413s 2024-11-01T18:23:14.012000Z LOG pgloader version "3.6.7~devel" 413s 2024-11-01T18:23:14.599995Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 22003: value "18446744073709551596" is out of range for type integer 413s CONTEXT: COPY overflow, line 1, column id: "18446744073709551596" 413s 2024-11-01T18:23:14.603995Z ERROR PostgreSQL ["\"public\".\"overflow\""] Database error 23502: null value in column "f1" of relation "overflow" violates not-null constraint 413s DETAIL: Failing row contains (12, null). 413s CONTEXT: COPY overflow, line 1: "12 \N" 413s 2024-11-01T18:23:14.651995Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/overflow.out") 414s 2024-11-01T18:23:14.675995Z WARNING PostgreSQL warning: table "overflow" does not exist, skipping 414s 2024-11-01T18:23:14.839994Z LOG report summary reset 414s table name errors rows bytes total time 414s ----------------------- --------- --------- --------- -------------- 414s fetch 0 0 0.012s 414s before load 0 2 0.040s 414s ----------------------- --------- --------- --------- -------------- 414s "public"."overflow" 4 0 0.0 kB 0.076s 414s "expected"."overflow" 0 0 0.040s 414s ----------------------- --------- --------- --------- -------------- 414s Files Processed 0 2 0.044s 414s COPY Threads Completion 0 4 0.120s 414s ----------------------- --------- --------- --------- -------------- 414s Total import time 4 0 0.0 kB 0.164s 414s 2024-11-01T18:23:14.903995Z LOG Regress pass. 414s touch regress/out/overflow.out 414s pgloader --regress partial.load 414s 2024-11-01T18:23:15.028000Z LOG pgloader version "3.6.7~devel" 414s 2024-11-01T18:23:15.032000Z LOG Parsing commands from file #P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/partial.load" 414s 2024-11-01T18:23:15.083999Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 415s 2024-11-01T18:23:15.495997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 415s 2024-11-01T18:23:15.515997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/partial.out") 415s 2024-11-01T18:23:15.531997Z WARNING PostgreSQL warning: table "partial" does not exist, skipping 415s 2024-11-01T18:23:15.671997Z LOG report summary reset 415s table name errors rows bytes total time 415s ----------------------- --------- --------- --------- -------------- 415s fetch 0 0 0.008s 415s before load 0 4 0.028s 415s ----------------------- --------- --------- --------- -------------- 415s "csv"."partial" 0 7 0.1 kB 0.036s 415s "expected"."partial" 0 7 0.1 kB 0.028s 415s ----------------------- --------- --------- --------- -------------- 415s Files Processed 0 2 0.036s 415s COPY Threads Completion 0 4 0.068s 415s Index Build Completion 0 0 0.040s 415s Create Indexes 0 2 0.004s 415s Constraints 0 1 0.000s 415s ----------------------- --------- --------- --------- -------------- 415s Total import time ✓ 14 0.2 kB 0.148s 415s 2024-11-01T18:23:15.739996Z LOG Regress pass. 415s touch regress/out/partial.out 415s pgloader --regress serial.load 415s 2024-11-01T18:23:16.028000Z LOG pgloader version "3.6.7~devel" 415s 2024-11-01T18:23:16.096000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 415s 2024-11-01T18:23:16.395998Z WARNING Target table "\"public\".\"serial\"" has 1 indexes defined against it. 415s 2024-11-01T18:23:16.395998Z WARNING That could impact loading performance badly. 415s 2024-11-01T18:23:16.395998Z WARNING Consider the option 'drop indexes'. 416s 2024-11-01T18:23:16.491997Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 416s 2024-11-01T18:23:16.515997Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/serial.out") 416s 2024-11-01T18:23:16.547997Z WARNING PostgreSQL warning: table "serial" does not exist, skipping 416s 2024-11-01T18:23:16.743997Z LOG report summary reset 416s table name errors rows bytes total time 416s ----------------------- --------- --------- --------- -------------- 416s fetch 0 0 0.012s 416s before load 0 2 0.044s 416s ----------------------- --------- --------- --------- -------------- 416s "public"."serial" 0 7 0.2 kB 0.048s 416s "expected"."serial" 0 7 0.2 kB 0.044s 416s ----------------------- --------- --------- --------- -------------- 416s Files Processed 0 2 0.040s 416s COPY Threads Completion 0 4 0.088s 416s ----------------------- --------- --------- --------- -------------- 416s Total import time ✓ 14 0.4 kB 0.128s 416s 2024-11-01T18:23:16.827996Z LOG Regress pass. 416s touch regress/out/serial.out 416s pgloader --regress udc.load 416s 2024-11-01T18:23:17.020000Z LOG pgloader version "3.6.7~devel" 416s 2024-11-01T18:23:17.100000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 417s 2024-11-01T18:23:17.331998Z WARNING Target table "\"public\".\"udc\"" has 1 indexes defined against it. 417s 2024-11-01T18:23:17.331998Z WARNING That could impact loading performance badly. 417s 2024-11-01T18:23:17.331998Z WARNING Consider the option 'drop indexes'. 417s 2024-11-01T18:23:17.415998Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 417s 2024-11-01T18:23:17.435998Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/udc.out") 417s 2024-11-01T18:23:17.463998Z WARNING PostgreSQL warning: table "udc" does not exist, skipping 417s 2024-11-01T18:23:17.563998Z LOG report summary reset 417s table name errors rows bytes total time 417s ----------------------- --------- --------- --------- -------------- 417s fetch 0 0 0.008s 417s before load 0 2 0.028s 417s ----------------------- --------- --------- --------- -------------- 417s "public"."udc" 0 5 0.1 kB 0.044s 417s "expected"."udc" 0 5 0.1 kB 0.024s 417s ----------------------- --------- --------- --------- -------------- 417s Files Processed 0 2 0.032s 417s COPY Threads Completion 0 4 0.076s 417s ----------------------- --------- --------- --------- -------------- 417s Total import time ✓ 10 0.2 kB 0.108s 417s 2024-11-01T18:23:17.627998Z LOG Regress pass. 417s touch regress/out/udc.out 417s pgloader --regress xzero.load 417s 2024-11-01T18:23:18.028000Z LOG pgloader version "3.6.7~devel" 417s 2024-11-01T18:23:18.072000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 417s 2024-11-01T18:23:18.299999Z WARNING Target table "\"public\".\"xzero\"" has 1 indexes defined against it. 417s 2024-11-01T18:23:18.299999Z WARNING That could impact loading performance badly. 417s 2024-11-01T18:23:18.299999Z WARNING Consider the option 'drop indexes'. 417s 2024-11-01T18:23:18.403998Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 417s 2024-11-01T18:23:18.423998Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.pn6qe9/build.O9V/src/test/regress/expected/xzero.out") 418s 2024-11-01T18:23:18.443998Z WARNING PostgreSQL warning: table "xzero" does not exist, skipping 418s 2024-11-01T18:23:18.583997Z LOG report summary reset 418s table name errors rows bytes total time 418s ----------------------- --------- --------- --------- -------------- 418s fetch 0 0 0.008s 418s before load 0 2 0.028s 418s ----------------------- --------- --------- --------- -------------- 418s "public"."xzero" 0 7 0.2 kB 0.060s 418s "expected"."xzero" 0 7 0.2 kB 0.044s 418s ----------------------- --------- --------- --------- -------------- 418s Files Processed 0 2 0.032s 418s COPY Threads Completion 0 4 0.116s 418s ----------------------- --------- --------- --------- -------------- 418s Total import time ✓ 14 0.4 kB 0.148s 418s 2024-11-01T18:23:18.659998Z LOG Regress pass. 418s touch regress/out/xzero.out 418s make: Leaving directory '/tmp/autopkgtest.pn6qe9/build.O9V/src/test' 418s Dropping cluster 16/regress ... 418s autopkgtest [18:23:19]: test testsuite: -----------------------] 419s autopkgtest [18:23:20]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 419s testsuite PASS 419s autopkgtest [18:23:20]: @@@@@@@@@@@@@@@@@@@@ summary 419s ssl PASS 419s testsuite PASS 431s nova [W] Using flock in prodstack6-ppc64el 431s Creating nova instance adt-plucky-ppc64el-pgloader-20241101-181621-juju-7f2275-prod-proposed-migration-environment-15-97ada375-4e68-4533-afcf-43b4ebd8ebac from image adt/ubuntu-plucky-ppc64el-server-20241101.img (UUID d479b61b-bfab-4ebe-8e06-591f77402620)... 431s nova [W] Using flock in prodstack6-ppc64el 431s Creating nova instance adt-plucky-ppc64el-pgloader-20241101-181621-juju-7f2275-prod-proposed-migration-environment-15-97ada375-4e68-4533-afcf-43b4ebd8ebac from image adt/ubuntu-plucky-ppc64el-server-20241101.img (UUID d479b61b-bfab-4ebe-8e06-591f77402620)...