0s autopkgtest [14:31:10]: starting date and time: 2024-11-15 14:31:10+0000 0s autopkgtest [14:31:10]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [14:31:10]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.cdxmvlak/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade pgloader --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/266 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-19.secgroup --name adt-plucky-amd64-pgloader-20241115-143110-juju-7f2275-prod-proposed-migration-environment-15-9a86c284-b33a-482d-bfa8-b1a7196afce9 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -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/ 44s autopkgtest [14:31:54]: testbed dpkg architecture: amd64 44s autopkgtest [14:31:54]: testbed apt version: 2.9.8 44s autopkgtest [14:31:54]: @@@@@@@@@@@@@@@@@@@@ test bed setup 45s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 45s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1062 kB] 46s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 46s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 46s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [94.2 kB] 46s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [174 kB] 46s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [108 kB] 46s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [32.6 kB] 46s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [300 kB] 46s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [840 kB] 46s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [9416 B] 46s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [740 B] 46s Fetched 2718 kB in 1s (3388 kB/s) 46s Reading package lists... 48s Reading package lists... 48s Building dependency tree... 48s Reading state information... 48s Calculating upgrade... 49s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 49s Reading package lists... 49s Building dependency tree... 49s Reading state information... 49s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 49s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 49s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 49s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 50s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 50s Reading package lists... 50s Reading package lists... 51s Building dependency tree... 51s Reading state information... 51s Calculating upgrade... 51s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 51s Reading package lists... 51s Building dependency tree... 51s Reading state information... 51s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 54s autopkgtest [14:32:04]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 54s autopkgtest [14:32:04]: @@@@@@@@@@@@@@@@@@@@ apt-source pgloader 56s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (dsc) [2932 B] 56s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (tar) [3723 kB] 56s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgloader 3.6.10-4 (diff) [9880 B] 56s gpgv: Signature made Mon Oct 28 11:35:26 2024 UTC 56s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 56s gpgv: Can't check signature: No public key 56s dpkg-source: warning: cannot verify inline signature for ./pgloader_3.6.10-4.dsc: no acceptable signature found 56s autopkgtest [14:32:06]: testing package pgloader version 3.6.10-4 57s autopkgtest [14:32:07]: build not needed 58s autopkgtest [14:32:08]: test ssl: preparing testbed 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 61s Starting pkgProblemResolver with broken count: 0 61s Starting 2 pkgProblemResolver with broken count: 0 61s Done 62s The following additional packages will be installed: 62s cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop cl-flexi-streams 62s cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres cl-postmodern 62s cl-ppcre cl-rt cl-s-sql cl-split-sequence cl-trivial-gray-streams cl-uax-15 62s cl-usocket freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 62s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql postgresql-17 62s postgresql-client-17 postgresql-client-common postgresql-common ssl-cert 62s Suggested packages: 62s postgresql-doc postgresql-doc-17 62s Recommended packages: 62s cl-fiveam cl-plus-ssl cl-simple-date cl-local-time libjs-mathjax freetds-doc 62s libjson-xs-perl 62s The following NEW packages will be installed: 62s autopkgtest-satdep cl-alexandria cl-base64 cl-bordeaux-threads cl-closer-mop 62s cl-flexi-streams cl-global-vars cl-ironclad cl-kmrcl cl-md5 cl-postgres 62s cl-postmodern cl-ppcre cl-rt cl-s-sql cl-split-sequence 62s cl-trivial-gray-streams cl-uax-15 cl-usocket freetds-common freetds-dev 62s libct4 libio-pty-perl libipc-run-perl libjson-perl libpq5 libsybdb5 62s libxslt1.1 pgloader postgresql postgresql-17 postgresql-client-17 62s postgresql-client-common postgresql-common ssl-cert 62s 0 upgraded, 35 newly installed, 0 to remove and 0 not upgraded. 62s Need to get 49.7 MB/49.7 MB of archives. 62s After this operation, 120 MB of additional disk space will be used. 62s Get:1 /tmp/autopkgtest.7hBcH9/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [732 B] 62s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 62s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 62s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 62s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-common all 266 [37.0 kB] 62s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 62s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-common all 266 [162 kB] 62s Get:8 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-alexandria all 20240125.git8514d8e-1 [204 kB] 62s Get:9 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-rt all 20090812.gita6a7503-1 [13.2 kB] 62s Get:10 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-kmrcl all 1.111-2 [42.7 kB] 62s Get:11 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-base64 all 3.4.0-1 [9304 B] 62s Get:12 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-bordeaux-threads all 0.8.8-5 [23.7 kB] 62s Get:13 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-closer-mop all 2:20220227.giteabdf6a-1 [25.7 kB] 62s Get:14 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-trivial-gray-streams all 20240217.gita7ead68-1 [9956 B] 62s Get:15 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-flexi-streams all 20210728.git41af5dc-1 [219 kB] 62s Get:16 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-global-vars all 0~20141013.gitc749f32-2 [5156 B] 62s Get:17 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-ironclad all 0.60-2 [1243 kB] 62s Get:18 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-md5 all 1:20210622.git906593f-1 [15.2 kB] 62s Get:19 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-split-sequence all 1:2.0.1-1 [12.2 kB] 62s Get:20 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-ppcre all 20220126.gitb4056c5-1 [110 kB] 62s Get:21 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-uax-15 all 0~20211021.git75c8a87-3 [536 kB] 62s Get:22 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-usocket all 0.8.3-3 [70.5 kB] 62s Get:23 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-postgres all 20211113.git9d4332f-5 [56.8 kB] 62s Get:24 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-s-sql all 20211113.git9d4332f-5 [61.1 kB] 62s Get:25 http://ftpmaster.internal/ubuntu plucky/universe amd64 cl-postmodern all 20211113.git9d4332f-5 [354 kB] 62s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 62s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 libct4 amd64 1.3.17+ds-2build3 [169 kB] 62s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 libsybdb5 amd64 1.3.17+ds-2build3 [192 kB] 62s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 freetds-dev amd64 1.3.17+ds-2build3 [305 kB] 63s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.0-1 [249 kB] 63s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 63s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.0-1 [2111 kB] 63s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.0-1 [17.9 MB] 63s Get:34 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql all 17+266 [12.1 kB] 63s Get:35 http://ftpmaster.internal/ubuntu plucky/universe amd64 pgloader amd64 3.6.10-4 [25.2 MB] 65s Preconfiguring packages ... 65s Fetched 49.7 MB in 3s (16.9 MB/s) 65s Selecting previously unselected package libjson-perl. 65s (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 ... 75576 files and directories currently installed.) 65s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 65s Unpacking libjson-perl (4.10000-1) ... 65s Selecting previously unselected package libio-pty-perl. 65s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 65s Unpacking libio-pty-perl (1:1.20-1build3) ... 65s Selecting previously unselected package libipc-run-perl. 65s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 65s Unpacking libipc-run-perl (20231003.0-2) ... 65s Selecting previously unselected package postgresql-client-common. 65s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 65s Unpacking postgresql-client-common (266) ... 65s Selecting previously unselected package ssl-cert. 65s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 65s Unpacking ssl-cert (1.1.2ubuntu2) ... 65s Selecting previously unselected package postgresql-common. 65s Preparing to unpack .../05-postgresql-common_266_all.deb ... 65s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 65s Unpacking postgresql-common (266) ... 65s Selecting previously unselected package cl-alexandria. 65s Preparing to unpack .../06-cl-alexandria_20240125.git8514d8e-1_all.deb ... 65s Unpacking cl-alexandria (20240125.git8514d8e-1) ... 65s Selecting previously unselected package cl-rt. 65s Preparing to unpack .../07-cl-rt_20090812.gita6a7503-1_all.deb ... 65s Unpacking cl-rt (20090812.gita6a7503-1) ... 65s Selecting previously unselected package cl-kmrcl. 65s Preparing to unpack .../08-cl-kmrcl_1.111-2_all.deb ... 65s Unpacking cl-kmrcl (1.111-2) ... 65s Selecting previously unselected package cl-base64. 65s Preparing to unpack .../09-cl-base64_3.4.0-1_all.deb ... 65s Unpacking cl-base64 (3.4.0-1) ... 65s Selecting previously unselected package cl-bordeaux-threads. 65s Preparing to unpack .../10-cl-bordeaux-threads_0.8.8-5_all.deb ... 65s Unpacking cl-bordeaux-threads (0.8.8-5) ... 65s Selecting previously unselected package cl-closer-mop. 65s Preparing to unpack .../11-cl-closer-mop_2%3a20220227.giteabdf6a-1_all.deb ... 65s Unpacking cl-closer-mop (2:20220227.giteabdf6a-1) ... 66s Selecting previously unselected package cl-trivial-gray-streams. 66s Preparing to unpack .../12-cl-trivial-gray-streams_20240217.gita7ead68-1_all.deb ... 66s Unpacking cl-trivial-gray-streams (20240217.gita7ead68-1) ... 66s Selecting previously unselected package cl-flexi-streams. 66s Preparing to unpack .../13-cl-flexi-streams_20210728.git41af5dc-1_all.deb ... 66s Unpacking cl-flexi-streams (20210728.git41af5dc-1) ... 66s Selecting previously unselected package cl-global-vars. 66s Preparing to unpack .../14-cl-global-vars_0~20141013.gitc749f32-2_all.deb ... 66s Unpacking cl-global-vars (0~20141013.gitc749f32-2) ... 66s Selecting previously unselected package cl-ironclad. 66s Preparing to unpack .../15-cl-ironclad_0.60-2_all.deb ... 66s Unpacking cl-ironclad (0.60-2) ... 66s Selecting previously unselected package cl-md5. 66s Preparing to unpack .../16-cl-md5_1%3a20210622.git906593f-1_all.deb ... 66s Unpacking cl-md5 (1:20210622.git906593f-1) ... 66s Selecting previously unselected package cl-split-sequence. 66s Preparing to unpack .../17-cl-split-sequence_1%3a2.0.1-1_all.deb ... 66s Unpacking cl-split-sequence (1:2.0.1-1) ... 66s Selecting previously unselected package cl-ppcre. 66s Preparing to unpack .../18-cl-ppcre_20220126.gitb4056c5-1_all.deb ... 66s Unpacking cl-ppcre (20220126.gitb4056c5-1) ... 66s Selecting previously unselected package cl-uax-15. 66s Preparing to unpack .../19-cl-uax-15_0~20211021.git75c8a87-3_all.deb ... 66s Unpacking cl-uax-15 (0~20211021.git75c8a87-3) ... 66s Selecting previously unselected package cl-usocket. 66s Preparing to unpack .../20-cl-usocket_0.8.3-3_all.deb ... 66s Unpacking cl-usocket (0.8.3-3) ... 66s Selecting previously unselected package cl-postgres. 66s Preparing to unpack .../21-cl-postgres_20211113.git9d4332f-5_all.deb ... 66s Unpacking cl-postgres (20211113.git9d4332f-5) ... 66s Selecting previously unselected package cl-s-sql. 66s Preparing to unpack .../22-cl-s-sql_20211113.git9d4332f-5_all.deb ... 66s Unpacking cl-s-sql (20211113.git9d4332f-5) ... 66s Selecting previously unselected package cl-postmodern. 66s Preparing to unpack .../23-cl-postmodern_20211113.git9d4332f-5_all.deb ... 66s Unpacking cl-postmodern (20211113.git9d4332f-5) ... 66s Selecting previously unselected package freetds-common. 66s Preparing to unpack .../24-freetds-common_1.3.17+ds-2build3_all.deb ... 66s Unpacking freetds-common (1.3.17+ds-2build3) ... 66s Selecting previously unselected package libct4:amd64. 66s Preparing to unpack .../25-libct4_1.3.17+ds-2build3_amd64.deb ... 66s Unpacking libct4:amd64 (1.3.17+ds-2build3) ... 66s Selecting previously unselected package libsybdb5:amd64. 66s Preparing to unpack .../26-libsybdb5_1.3.17+ds-2build3_amd64.deb ... 66s Unpacking libsybdb5:amd64 (1.3.17+ds-2build3) ... 66s Selecting previously unselected package freetds-dev. 66s Preparing to unpack .../27-freetds-dev_1.3.17+ds-2build3_amd64.deb ... 66s Unpacking freetds-dev (1.3.17+ds-2build3) ... 66s Selecting previously unselected package libpq5:amd64. 66s Preparing to unpack .../28-libpq5_17.0-1_amd64.deb ... 66s Unpacking libpq5:amd64 (17.0-1) ... 66s Selecting previously unselected package libxslt1.1:amd64. 66s Preparing to unpack .../29-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 66s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 66s Selecting previously unselected package postgresql-client-17. 66s Preparing to unpack .../30-postgresql-client-17_17.0-1_amd64.deb ... 66s Unpacking postgresql-client-17 (17.0-1) ... 66s Selecting previously unselected package postgresql-17. 66s Preparing to unpack .../31-postgresql-17_17.0-1_amd64.deb ... 66s Unpacking postgresql-17 (17.0-1) ... 67s Selecting previously unselected package postgresql. 67s Preparing to unpack .../32-postgresql_17+266_all.deb ... 67s Unpacking postgresql (17+266) ... 67s Selecting previously unselected package pgloader. 67s Preparing to unpack .../33-pgloader_3.6.10-4_amd64.deb ... 67s Unpacking pgloader (3.6.10-4) ... 67s Selecting previously unselected package autopkgtest-satdep. 67s Preparing to unpack .../34-1-autopkgtest-satdep.deb ... 67s Unpacking autopkgtest-satdep (0) ... 67s Setting up cl-closer-mop (2:20220227.giteabdf6a-1) ... 67s Setting up libio-pty-perl (1:1.20-1build3) ... 67s Setting up libpq5:amd64 (17.0-1) ... 67s Setting up cl-split-sequence (1:2.0.1-1) ... 67s Setting up cl-trivial-gray-streams (20240217.gita7ead68-1) ... 67s Setting up ssl-cert (1.1.2ubuntu2) ... 67s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 67s Setting up libipc-run-perl (20231003.0-2) ... 67s Setting up cl-global-vars (0~20141013.gitc749f32-2) ... 67s Setting up libjson-perl (4.10000-1) ... 67s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 67s Setting up cl-alexandria (20240125.git8514d8e-1) ... 67s Setting up cl-rt (20090812.gita6a7503-1) ... 67s Setting up freetds-common (1.3.17+ds-2build3) ... 67s Setting up cl-ppcre (20220126.gitb4056c5-1) ... 67s Setting up postgresql-client-common (266) ... 67s Setting up cl-flexi-streams (20210728.git41af5dc-1) ... 67s Setting up cl-uax-15 (0~20211021.git75c8a87-3) ... 67s Setting up postgresql-client-17 (17.0-1) ... 68s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 68s Setting up libsybdb5:amd64 (1.3.17+ds-2build3) ... 68s Setting up cl-bordeaux-threads (0.8.8-5) ... 68s Setting up libct4:amd64 (1.3.17+ds-2build3) ... 68s Setting up cl-kmrcl (1.111-2) ... 68s Setting up postgresql-common (266) ... 68s 68s Creating config file /etc/postgresql-common/createcluster.conf with new version 68s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 68s Removing obsolete dictionary files: 69s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 69s Setting up cl-usocket (0.8.3-3) ... 69s Setting up cl-md5 (1:20210622.git906593f-1) ... 69s Setting up cl-base64 (3.4.0-1) ... 69s Setting up cl-ironclad (0.60-2) ... 69s Setting up postgresql-17 (17.0-1) ... 69s Creating new PostgreSQL cluster 17/main ... 69s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 69s The files belonging to this database system will be owned by user "postgres". 69s This user must also own the server process. 69s 69s The database cluster will be initialized with locale "C.UTF-8". 69s The default database encoding has accordingly been set to "UTF8". 69s The default text search configuration will be set to "english". 69s 69s Data page checksums are disabled. 69s 69s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 69s creating subdirectories ... ok 69s selecting dynamic shared memory implementation ... posix 69s selecting default "max_connections" ... 100 69s selecting default "shared_buffers" ... 128MB 69s selecting default time zone ... Etc/UTC 69s creating configuration files ... ok 70s running bootstrap script ... ok 70s performing post-bootstrap initialization ... ok 70s syncing data to disk ... ok 73s Setting up freetds-dev (1.3.17+ds-2build3) ... 73s Setting up pgloader (3.6.10-4) ... 73s Setting up cl-postgres (20211113.git9d4332f-5) ... 73s Setting up postgresql (17+266) ... 73s Setting up cl-s-sql (20211113.git9d4332f-5) ... 73s Setting up cl-postmodern (20211113.git9d4332f-5) ... 73s Setting up autopkgtest-satdep (0) ... 73s Processing triggers for man-db (2.13.0-1) ... 75s Processing triggers for install-info (7.1.1-1) ... 75s Processing triggers for libc-bin (2.40-1ubuntu3) ... 77s (Reading database ... 78900 files and directories currently installed.) 77s Removing autopkgtest-satdep (0) ... 78s autopkgtest [14:32:28]: test ssl: [----------------------- 78s + trap rm -rf /tmp/pgloader EXIT 78s + dpkg-query --show --showformat=${Version} cl-postmodern 78s + postmodern=20211113.git9d4332f-5 78s + dpkg --compare-versions 20211113.git9d4332f-5 lt 20200101 78s + pg_virtualenv 78s Creating new PostgreSQL cluster 17/regress ... 81s ++ psql -XAtc 'SHOW hba_file' 81s + HBA=/etc/postgresql/17/regress/pg_hba.conf 81s + sed -i -e 's/^host/hostssl/' /etc/postgresql/17/regress/pg_hba.conf 81s + psql -XAtc 'SELECT pg_reload_conf()' 81s t 81s + createdb pgloader 81s + export PGDATABASE=pgloader 81s + PGDATABASE=pgloader 81s + psql -XAtc 'create schema expected' 81s + rm -rf /tmp/pgloader 81s + PGHOST=/var/run/postgresql 81s + su -c 'pgloader --debug --regress test/allcols.load' postgres 81s CREATE SCHEMA 82s mkdir -p #P"/tmp/pgloader/" 82s pgloader version 3.6.10~devel 82s compiled with SBCL 2.4.7.debian 82s sb-impl::*default-external-format* :UTF-8 82s tmpdir: #P"/tmp/pgloader/" 82s 2024-11-15T14:32:32.002001Z NOTICE Starting pgloader, log system is ready. 82s 2024-11-15T14:32:32.008003Z INFO Starting monitor 82s 2024-11-15T14:32:32.009004Z LOG pgloader version "3.6.10~devel" 82s 2024-11-15T14:32:32.034013Z INFO Parsed command: 82s /* 82s * This test is ported from pgloader 2.x where it was defined as: 82s * 82s * [allcols] 82s * table = allcols 82s * format = csv 82s * filename = allcols/allcols.data 82s * field_sep = : 82s * columns = * 82s * pg_option_work_mem = 14MB 82s * 82s */ 82s 82s LOAD CSV 82s FROM inline (a, b, c) 82s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 82s 82s WITH fields optionally enclosed by '"', 82s fields escaped by double-quote, 82s fields terminated by ':' 82s 82s SET client_encoding to 'latin1', 82s work_mem to '14MB', 82s standard_conforming_strings to 'on' 82s 82s BEFORE LOAD DO 82s $$ drop table if exists allcols; $$, 82s $$ create table allcols ( 82s a integer primary key, 82s b date, 82s c text 82s ); 82s $$; 82s 82s 82s 82s 82s 82s 2024-11-15T14:32:32.036013Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 83s 2024-11-15T14:32:32.062023Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.062023Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.062023Z DEBUG SET work_mem TO '14MB' 83s + rm -rf /tmp/pgloader 83s 2024-11-15T14:32:32.062023Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.062023Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.069025Z NOTICE Executing SQL block for before load 83s 2024-11-15T14:32:32.078028Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.078028Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.078028Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.079029Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.079029Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.081029Z DEBUG BEGIN 83s 2024-11-15T14:32:32.081029Z SQL drop table if exists allcols; 83s 2024-11-15T14:32:32.081029Z SQL create table allcols ( 83s a integer primary key, 83s b date, 83s c text 83s ); 83s 2024-11-15T14:32:32.099036Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.099036Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.099036Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.099036Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.100036Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.108039Z SQL -- 83s -- get user defined SQL types 83s -- 83s select nt.nspname, 83s extname, 83s typname, 83s case when enum.enumtypid is not null 83s then array_agg(enum.enumlabel order by enumsortorder) 83s end as enumvalues 83s 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 83s join pg_type t on t.oid = a.atttypid 83s left join pg_namespace nt on nt.oid = t.typnamespace 83s left join pg_depend d on d.classid = 'pg_type'::regclass 83s and d.refclassid = 'pg_extension'::regclass 83s and d.objid = t.oid 83s left join pg_extension e on refobjid = e.oid 83s left join pg_enum enum on enum.enumtypid = t.oid 83s 83s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 83s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and c.relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s and 83s ( t.typrelid = 0 83s or 83s (select c.relkind = 'c' 83s from pg_class c 83s where c.oid = t.typrelid) 83s ) 83s and not exists 83s ( 83s select 1 83s from pg_type el 83s where el.oid = t.typelem 83s and el.typarray = t.oid 83s ) 83s 83s group by nt.nspname, extname, typname, enumtypid 83s order by nt.nspname, extname, typname, enumtypid; 83s 2024-11-15T14:32:32.112041Z SQL -- params: table-type-name 83s -- including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s with seqattr as 83s ( 83s select adrelid, 83s adnum, 83s pg_get_expr(d.adbin, d.adrelid) as adsrc, 83s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 83s then substring(pg_get_expr(d.adbin, d.adrelid) 83s from '''([^'']+)''' 83s ) 83s else null 83s end as seqname 83s from pg_attrdef d 83s ) 83s select nspname, relname, c.oid, attname, 83s t.oid::regtype as type, 83s case when atttypmod > 0 83s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 83s else null 83s end as typmod, 83s attnotnull, 83s case when atthasdef 83s then pg_get_expr(def.adbin, def.adrelid) 83s end as default , 83s case when s.seqname is not null then 'auto_increment' end as extra 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid 83s join pg_type t on t.oid = a.atttypid and attnum > 0 83s left join pg_attrdef def on a.attrelid = def.adrelid 83s and a.attnum = def.adnum 83s and a.atthasdef 83s left join seqattr s on def.adrelid = s.adrelid 83s and def.adnum = s.adnum 83s 83s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s 83s order by nspname, relname, attnum; 83s 2024-11-15T14:32:32.128046Z SQL -- params: including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, 83s i.relname, 83s i.oid, 83s rn.nspname, 83s r.relname, 83s indisprimary, 83s indisunique, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.oid 83s and array[attnum::integer] <@ indkey::integer[] 83s ) as cols, 83s pg_get_indexdef(indexrelid), 83s c.conname, 83s pg_get_constraintdef(c.oid) 83s from pg_index x 83s join pg_class i ON i.oid = x.indexrelid 83s join pg_class r ON r.oid = x.indrelid 83s join pg_namespace n ON n.oid = i.relnamespace 83s join pg_namespace rn ON rn.oid = r.relnamespace 83s left join pg_depend d on d.classid = 'pg_class'::regclass 83s and d.objid = i.oid 83s and d.refclassid = 'pg_constraint'::regclass 83s and d.deptype = 'i' 83s left join pg_constraint c ON c.oid = d.refobjid 83s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and ((rn.nspname = 'public' and r.relname = 'allcols')) 83s 83s order by n.nspname, r.relname 83s 2024-11-15T14:32:32.135049Z SQL -- params: including (table) 83s -- filter-list-to-where-clause for including 83s -- excluding (table) 83s -- filter-list-to-where-clause for excluding 83s -- including (ftable) 83s -- filter-list-to-where-clause for including 83s -- excluding (ftable) 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid, 83s d.refobjid as pkeyoid, 83s conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.conrelid 83s and array[attnum::integer] <@ conkey::integer[] 83s ) as conkey, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.confrelid 83s and array[attnum::integer] <@ confkey::integer[] 83s ) as confkey, 83s confupdtype, confdeltype, confmatchtype, 83s condeferrable, condeferred 83s from pg_catalog.pg_constraint r 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 83s and d.objid = r.oid 83s and d.refobjsubid = 0 83s where r.contype = 'f' 83s AND c.relkind in ('r', 'f', 'p') 83s AND cf.relkind in ('r', 'f', 'p') 83s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 83s 83s 2024-11-15T14:32:32.139050Z SQL -- params pkey-oid-list 83s -- fkey-oild-list 83s with pkeys(oid) as ( 83s values(16391) 83s ), 83s knownfkeys(oid) as ( 83s values(-1) 83s ), 83s pkdeps as ( 83s select pkeys.oid, pg_depend.objid 83s from pg_depend 83s join pkeys on pg_depend.refobjid = pkeys.oid 83s where classid = 'pg_catalog.pg_constraint'::regclass 83s and refclassid = 'pg_catalog.pg_class'::regclass 83s ) 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid as conoid, conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s pkdeps.oid as index_oid 83s from pg_catalog.pg_constraint r 83s JOIN pkdeps on r.oid = pkdeps.objid 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 83s 2024-11-15T14:32:32.146053Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 83s 2024-11-15T14:32:32.148054Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 83s 2024-11-15T14:32:32.148054Z WARNING That could impact loading performance badly. 83s 2024-11-15T14:32:32.148054Z WARNING Consider the option 'drop indexes'. 83s 2024-11-15T14:32:32.162059Z NOTICE COPY "public"."allcols" with 0 rows estimated [3/4] 83s 2024-11-15T14:32:32.162059Z DEBUG Reader started for "public"."allcols" 83s 2024-11-15T14:32:32.172062Z DEBUG start "public"."allcols" 339123 83s 2024-11-15T14:32:32.172062Z NOTICE Opening (:INLINE 83s (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/allcols.load" . 765)) 83s 2024-11-15T14:32:32.172062Z INFO COPY ON ERROR RESUME NEXT 83s 2024-11-15T14:32:32.176064Z DEBUG Reader for "public"."allcols" is done in 0.014005s 83s 2024-11-15T14:32:32.176064Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.014005s 83s 2024-11-15T14:32:32.179065Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.179065Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.179065Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.179065Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.179065Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.179065Z SQL SET search_path TO "public"; 83s 2024-11-15T14:32:32.180065Z INFO pgsql:copy-rows-from-queue[0]: "public"."allcols" ("a" "b" "c") 83s 2024-11-15T14:32:32.183066Z DEBUG send-batch[0] "public"."allcols" 8 rows [ 0.2 kB] in 0.003001s 83s 2024-11-15T14:32:32.183066Z DEBUG stop "public"."allcols" | 339123 .. 360130 = 0.021007d0 83s 2024-11-15T14:32:32.183066Z DEBUG Writer[0] for "public"."allcols" is done in 0.003001s 83s 2024-11-15T14:32:32.183066Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.003001s 83s 2024-11-15T14:32:32.192069Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 83s 2024-11-15T14:32:32.201073Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.201073Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.201073Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.201073Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.202073Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.203073Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/allcols.out") 83s 2024-11-15T14:32:32.212077Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.212077Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.212077Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.213077Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.213077Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.213077Z NOTICE drop table if exists expected.allcols; 83s 2024-11-15T14:32:32.214077Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 83s 2024-11-15T14:32:32.215078Z NOTICE create table expected.allcols(like allcols); 83s 2024-11-15T14:32:32.215078Z DEBUG LOAD DATA FROM # 83s 2024-11-15T14:32:32.228082Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.228082Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.228082Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.241087Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.241087Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.241087Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.241087Z SQL -- 83s -- get user defined SQL types 83s -- 83s select nt.nspname, 83s extname, 83s typname, 83s case when enum.enumtypid is not null 83s then array_agg(enum.enumlabel order by enumsortorder) 83s end as enumvalues 83s 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 83s join pg_type t on t.oid = a.atttypid 83s left join pg_namespace nt on nt.oid = t.typnamespace 83s left join pg_depend d on d.classid = 'pg_type'::regclass 83s and d.refclassid = 'pg_extension'::regclass 83s and d.objid = t.oid 83s left join pg_extension e on refobjid = e.oid 83s left join pg_enum enum on enum.enumtypid = t.oid 83s 83s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 83s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and c.relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s and 83s ( t.typrelid = 0 83s or 83s (select c.relkind = 'c' 83s from pg_class c 83s where c.oid = t.typrelid) 83s ) 83s and not exists 83s ( 83s select 1 83s from pg_type el 83s where el.oid = t.typelem 83s and el.typarray = t.oid 83s ) 83s 83s group by nt.nspname, extname, typname, enumtypid 83s order by nt.nspname, extname, typname, enumtypid; 83s 2024-11-15T14:32:32.246089Z SQL -- params: table-type-name 83s -- including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s with seqattr as 83s ( 83s select adrelid, 83s adnum, 83s pg_get_expr(d.adbin, d.adrelid) as adsrc, 83s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 83s then substring(pg_get_expr(d.adbin, d.adrelid) 83s from '''([^'']+)''' 83s ) 83s else null 83s end as seqname 83s from pg_attrdef d 83s ) 83s select nspname, relname, c.oid, attname, 83s t.oid::regtype as type, 83s case when atttypmod > 0 83s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 83s else null 83s end as typmod, 83s attnotnull, 83s case when atthasdef 83s then pg_get_expr(def.adbin, def.adrelid) 83s end as default , 83s case when s.seqname is not null then 'auto_increment' end as extra 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid 83s join pg_type t on t.oid = a.atttypid and attnum > 0 83s left join pg_attrdef def on a.attrelid = def.adrelid 83s and a.attnum = def.adnum 83s and a.atthasdef 83s left join seqattr s on def.adrelid = s.adrelid 83s and def.adnum = s.adnum 83s 83s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s 83s order by nspname, relname, attnum; 83s 2024-11-15T14:32:32.248090Z SQL -- params: including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, 83s i.relname, 83s i.oid, 83s rn.nspname, 83s r.relname, 83s indisprimary, 83s indisunique, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.oid 83s and array[attnum::integer] <@ indkey::integer[] 83s ) as cols, 83s pg_get_indexdef(indexrelid), 83s c.conname, 83s pg_get_constraintdef(c.oid) 83s from pg_index x 83s join pg_class i ON i.oid = x.indexrelid 83s join pg_class r ON r.oid = x.indrelid 83s join pg_namespace n ON n.oid = i.relnamespace 83s join pg_namespace rn ON rn.oid = r.relnamespace 83s left join pg_depend d on d.classid = 'pg_class'::regclass 83s and d.objid = i.oid 83s and d.refclassid = 'pg_constraint'::regclass 83s and d.deptype = 'i' 83s left join pg_constraint c ON c.oid = d.refobjid 83s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 83s 83s order by n.nspname, r.relname 83s 2024-11-15T14:32:32.249090Z SQL -- params: including (table) 83s -- filter-list-to-where-clause for including 83s -- excluding (table) 83s -- filter-list-to-where-clause for excluding 83s -- including (ftable) 83s -- filter-list-to-where-clause for including 83s -- excluding (ftable) 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid, 83s d.refobjid as pkeyoid, 83s conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.conrelid 83s and array[attnum::integer] <@ conkey::integer[] 83s ) as conkey, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.confrelid 83s and array[attnum::integer] <@ confkey::integer[] 83s ) as confkey, 83s confupdtype, confdeltype, confmatchtype, 83s condeferrable, condeferred 83s from pg_catalog.pg_constraint r 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 83s and d.objid = r.oid 83s and d.refobjsubid = 0 83s where r.contype = 'f' 83s AND c.relkind in ('r', 'f', 'p') 83s AND cf.relkind in ('r', 'f', 'p') 83s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 83s 83s 2024-11-15T14:32:32.251091Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 83s 2024-11-15T14:32:32.251091Z SQL TRUNCATE "expected"."allcols"; 83s 2024-11-15T14:32:32.258093Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 83s 2024-11-15T14:32:32.258093Z DEBUG Reader started for "expected"."allcols" 83s 2024-11-15T14:32:32.258093Z DEBUG start "expected"."allcols" 435157 83s 2024-11-15T14:32:32.258093Z NOTICE Opening #P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/allcols.out" 83s 2024-11-15T14:32:32.258093Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 83s 2024-11-15T14:32:32.259094Z INFO COPY ON ERROR RESUME NEXT 83s 2024-11-15T14:32:32.260094Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 83s 2024-11-15T14:32:32.269097Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.269097Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.269097Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.270098Z SQL SET search_path TO "expected"; 83s 2024-11-15T14:32:32.270098Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 83s 2024-11-15T14:32:32.270098Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 83s 2024-11-15T14:32:32.270098Z DEBUG stop "expected"."allcols" | 435157 .. 447162 = 0.012005d0 83s 2024-11-15T14:32:32.270098Z DEBUG Writer[1] for "expected"."allcols" is done in 0.000000s 83s 2024-11-15T14:32:32.273099Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 83s 2024-11-15T14:32:32.273099Z LOG report summary reset 83s table name errors read imported bytes total time read write 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s fetch 0 0 0 0.003s 83s before load 0 2 2 0.014s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s "public"."allcols" 0 8 8 0.2 kB 0.021s 0.014s 0.003s 83s "expected"."allcols" 0 8 8 0.2 kB 0.012s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s Files Processed 0 2 2 0.017s 83s COPY Threads Completion 0 4 4 0.031s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s Total import time ✓ 16 16 0.4 kB 0.048s 83s 2024-11-15T14:32:32.289104Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.290105Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.290105Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.290105Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.290105Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.290105Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 83s 2024-11-15T14:32:32.290105Z NOTICE Got a diff of 0 rows 83s 2024-11-15T14:32:32.290105Z LOG Regress pass. 83s 2024-11-15T14:32:32.290105Z INFO Stopping monitor 83s mkdir -p #P"/tmp/pgloader/" 83s pgloader version 3.6.10~devel 83s compiled with SBCL 2.4.7.debian 83s sb-impl::*default-external-format* :UTF-8 83s tmpdir: #P"/tmp/pgloader/" 83s 2024-11-15T14:32:32.002001Z NOTICE Starting pgloader, log system is ready. 83s 2024-11-15T14:32:32.008003Z INFO Starting monitor 83s 2024-11-15T14:32:32.010003Z LOG pgloader version "3.6.10~devel" 83s 2024-11-15T14:32:32.033013Z INFO Parsed command: 83s /* 83s * This test is ported from pgloader 2.x where it was defined as: 83s * 83s * [allcols] 83s * table = allcols 83s * format = csv 83s * filename = allcols/allcols.data 83s * field_sep = : 83s * columns = * 83s * pg_option_work_mem = 14MB 83s * 83s */ 83s 83s LOAD CSV 83s FROM inline (a, b, c) 83s INTO postgresql:///pgloader?allcols (a, b, c text using (subseq c 0)) 83s 83s WITH fields optionally enclosed by '"', 83s fields escaped by double-quote, 83s fields terminated by ':' 83s 83s SET client_encoding to 'latin1', 83s work_mem to '14MB', 83s standard_conforming_strings to 'on' 83s 83s BEFORE LOAD DO 83s $$ drop table if exists allcols; $$, 83s $$ create table allcols ( 83s a integer primary key, 83s b date, 83s c text 83s ); 83s $$; 83s 83s 83s 83s 83s 83s 2024-11-15T14:32:32.036014Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 83s 2024-11-15T14:32:32.148054Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.148054Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.148054Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.148054Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.149055Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.157057Z NOTICE Executing SQL block for before load 83s 2024-11-15T14:32:32.225082Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.225082Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.225082Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.225082Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.226082Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.228083Z DEBUG BEGIN 83s 2024-11-15T14:32:32.229083Z SQL drop table if exists allcols; 83s 2024-11-15T14:32:32.230084Z SQL create table allcols ( 83s a integer primary key, 83s b date, 83s c text 83s ); 83s 2024-11-15T14:32:32.308112Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.308112Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.308112Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.308112Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.309112Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.318115Z SQL -- 83s -- get user defined SQL types 83s -- 83s select nt.nspname, 83s extname, 83s typname, 83s case when enum.enumtypid is not null 83s then array_agg(enum.enumlabel order by enumsortorder) 83s end as enumvalues 83s 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 83s join pg_type t on t.oid = a.atttypid 83s left join pg_namespace nt on nt.oid = t.typnamespace 83s left join pg_depend d on d.classid = 'pg_type'::regclass 83s and d.refclassid = 'pg_extension'::regclass 83s and d.objid = t.oid 83s left join pg_extension e on refobjid = e.oid 83s left join pg_enum enum on enum.enumtypid = t.oid 83s 83s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 83s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and c.relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s and 83s ( t.typrelid = 0 83s or 83s (select c.relkind = 'c' 83s from pg_class c 83s where c.oid = t.typrelid) 83s ) 83s and not exists 83s ( 83s select 1 83s from pg_type el 83s where el.oid = t.typelem 83s and el.typarray = t.oid 83s ) 83s 83s group by nt.nspname, extname, typname, enumtypid 83s order by nt.nspname, extname, typname, enumtypid; 83s 2024-11-15T14:32:32.322117Z SQL -- params: table-type-name 83s -- including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s with seqattr as 83s ( 83s select adrelid, 83s adnum, 83s pg_get_expr(d.adbin, d.adrelid) as adsrc, 83s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 83s then substring(pg_get_expr(d.adbin, d.adrelid) 83s from '''([^'']+)''' 83s ) 83s else null 83s end as seqname 83s from pg_attrdef d 83s ) 83s select nspname, relname, c.oid, attname, 83s t.oid::regtype as type, 83s case when atttypmod > 0 83s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 83s else null 83s end as typmod, 83s attnotnull, 83s case when atthasdef 83s then pg_get_expr(def.adbin, def.adrelid) 83s end as default , 83s case when s.seqname is not null then 'auto_increment' end as extra 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid 83s join pg_type t on t.oid = a.atttypid and attnum > 0 83s left join pg_attrdef def on a.attrelid = def.adrelid 83s and a.attnum = def.adnum 83s and a.atthasdef 83s left join seqattr s on def.adrelid = s.adrelid 83s and def.adnum = s.adnum 83s 83s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s 83s order by nspname, relname, attnum; 83s 2024-11-15T14:32:32.339123Z SQL -- params: including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, 83s i.relname, 83s i.oid, 83s rn.nspname, 83s r.relname, 83s indisprimary, 83s indisunique, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.oid 83s and array[attnum::integer] <@ indkey::integer[] 83s ) as cols, 83s pg_get_indexdef(indexrelid), 83s c.conname, 83s pg_get_constraintdef(c.oid) 83s from pg_index x 83s join pg_class i ON i.oid = x.indexrelid 83s join pg_class r ON r.oid = x.indrelid 83s join pg_namespace n ON n.oid = i.relnamespace 83s join pg_namespace rn ON rn.oid = r.relnamespace 83s left join pg_depend d on d.classid = 'pg_class'::regclass 83s and d.objid = i.oid 83s and d.refclassid = 'pg_constraint'::regclass 83s and d.deptype = 'i' 83s left join pg_constraint c ON c.oid = d.refobjid 83s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and ((rn.nspname = 'public' and r.relname = 'allcols')) 83s 83s order by n.nspname, r.relname 83s 2024-11-15T14:32:32.346126Z SQL -- params: including (table) 83s -- filter-list-to-where-clause for including 83s -- excluding (table) 83s -- filter-list-to-where-clause for excluding 83s -- including (ftable) 83s -- filter-list-to-where-clause for including 83s -- excluding (ftable) 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid, 83s d.refobjid as pkeyoid, 83s conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.conrelid 83s and array[attnum::integer] <@ conkey::integer[] 83s ) as conkey, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.confrelid 83s and array[attnum::integer] <@ confkey::integer[] 83s ) as confkey, 83s confupdtype, confdeltype, confmatchtype, 83s condeferrable, condeferred 83s from pg_catalog.pg_constraint r 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 83s and d.objid = r.oid 83s and d.refobjsubid = 0 83s where r.contype = 'f' 83s AND c.relkind in ('r', 'f', 'p') 83s AND cf.relkind in ('r', 'f', 'p') 83s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 83s and ((n.nspname = 'public' and c.relname = 'allcols')) 83s 83s and ((nf.nspname = 'public' and cf.relname = 'allcols')) 83s 83s 2024-11-15T14:32:32.349127Z SQL -- params pkey-oid-list 83s -- fkey-oild-list 83s with pkeys(oid) as ( 83s values(16406) 83s ), 83s knownfkeys(oid) as ( 83s values(-1) 83s ), 83s pkdeps as ( 83s select pkeys.oid, pg_depend.objid 83s from pg_depend 83s join pkeys on pg_depend.refobjid = pkeys.oid 83s where classid = 'pg_catalog.pg_constraint'::regclass 83s and refclassid = 'pg_catalog.pg_class'::regclass 83s ) 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid as conoid, conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s pkdeps.oid as index_oid 83s from pg_catalog.pg_constraint r 83s JOIN pkdeps on r.oid = pkdeps.objid 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s where NOT EXISTS (select 1 from knownfkeys where oid = r.oid) 83s 2024-11-15T14:32:32.355129Z DEBUG fetch-pgsql-catalog: 1 tables, 1 indexes, 0+0 fkeys 83s 2024-11-15T14:32:32.357129Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 83s 2024-11-15T14:32:32.357129Z WARNING That could impact loading performance badly. 83s 2024-11-15T14:32:32.357129Z WARNING Consider the option 'drop indexes'. 83s 2024-11-15T14:32:32.370134Z NOTICE COPY "public"."allcols" with 0 rows estimated [1/4] 83s 2024-11-15T14:32:32.370134Z DEBUG Reader started for "public"."allcols" 83s 2024-11-15T14:32:32.372135Z DEBUG start "public"."allcols" 543196 83s 2024-11-15T14:32:32.377137Z INFO COPY ON ERROR RESUME NEXT 83s 2024-11-15T14:32:32.377137Z NOTICE Opening (:INLINE 83s (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/allcols.load" . 765)) 83s 2024-11-15T14:32:32.384139Z DEBUG Reader for "public"."allcols" is done in 0.014005s 83s 2024-11-15T14:32:32.384139Z DEBUG Finished processing READER for "\"public\".\"allcols\"" 0.014005s 83s 2024-11-15T14:32:32.441159Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.441159Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.441159Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.441159Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.441159Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.442159Z SQL SET search_path TO "public"; 83s 2024-11-15T14:32:32.442159Z INFO pgsql:copy-rows-from-queue[0]: "public"."allcols" ("a" "b" "c") 83s 2024-11-15T14:32:32.445160Z DEBUG send-batch[0] "public"."allcols" 8 rows [ 0.2 kB] in 0.003001s 83s 2024-11-15T14:32:32.448162Z DEBUG stop "public"."allcols" | 543196 .. 619223 = 0.076027d0 83s 2024-11-15T14:32:32.448162Z DEBUG Writer[0] for "public"."allcols" is done in 0.003001s 83s 2024-11-15T14:32:32.448162Z DEBUG Finished processing WRITER for "\"public\".\"allcols\"" 0.003001s 83s 2024-11-15T14:32:32.453163Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 83s 2024-11-15T14:32:32.524188Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.524188Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.524188Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.524188Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.525188Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.527189Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/allcols.out") 83s 2024-11-15T14:32:32.593211Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.593211Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.593211Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.594212Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.594212Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.594212Z NOTICE drop table if exists expected.allcols; 83s 2024-11-15T14:32:32.596212Z NOTICE create table expected.allcols(like allcols); 83s 2024-11-15T14:32:32.599213Z DEBUG LOAD DATA FROM # 83s 2024-11-15T14:32:32.665236Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.665236Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.666236Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.740262Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.740262Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.740262Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.741262Z SQL -- 83s -- get user defined SQL types 83s -- 83s select nt.nspname, 83s extname, 83s typname, 83s case when enum.enumtypid is not null 83s then array_agg(enum.enumlabel order by enumsortorder) 83s end as enumvalues 83s 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid and a.attnum > 0 83s join pg_type t on t.oid = a.atttypid 83s left join pg_namespace nt on nt.oid = t.typnamespace 83s left join pg_depend d on d.classid = 'pg_type'::regclass 83s and d.refclassid = 'pg_extension'::regclass 83s and d.objid = t.oid 83s left join pg_extension e on refobjid = e.oid 83s left join pg_enum enum on enum.enumtypid = t.oid 83s 83s where nt.nspname !~ '^pg_' and nt.nspname <> 'information_schema' 83s and n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and c.relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s and 83s ( t.typrelid = 0 83s or 83s (select c.relkind = 'c' 83s from pg_class c 83s where c.oid = t.typrelid) 83s ) 83s and not exists 83s ( 83s select 1 83s from pg_type el 83s where el.oid = t.typelem 83s and el.typarray = t.oid 83s ) 83s 83s group by nt.nspname, extname, typname, enumtypid 83s order by nt.nspname, extname, typname, enumtypid; 83s 2024-11-15T14:32:32.746264Z SQL -- params: table-type-name 83s -- including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s with seqattr as 83s ( 83s select adrelid, 83s adnum, 83s pg_get_expr(d.adbin, d.adrelid) as adsrc, 83s case when pg_get_expr(d.adbin, d.adrelid) ~ 'nextval' 83s then substring(pg_get_expr(d.adbin, d.adrelid) 83s from '''([^'']+)''' 83s ) 83s else null 83s end as seqname 83s from pg_attrdef d 83s ) 83s select nspname, relname, c.oid, attname, 83s t.oid::regtype as type, 83s case when atttypmod > 0 83s then substring(format_type(t.oid, atttypmod) from '\d+(?:,\d+)?') 83s else null 83s end as typmod, 83s attnotnull, 83s case when atthasdef 83s then pg_get_expr(def.adbin, def.adrelid) 83s end as default , 83s case when s.seqname is not null then 'auto_increment' end as extra 83s from pg_class c 83s join pg_namespace n on n.oid = c.relnamespace 83s left join pg_attribute a on c.oid = a.attrelid 83s join pg_type t on t.oid = a.atttypid and attnum > 0 83s left join pg_attrdef def on a.attrelid = def.adrelid 83s and a.attnum = def.adnum 83s and a.atthasdef 83s left join seqattr s on def.adrelid = s.adrelid 83s and def.adnum = s.adnum 83s 83s where nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and relkind in ('r', 'f', 'p') 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s 83s order by nspname, relname, attnum; 83s 2024-11-15T14:32:32.748264Z SQL -- params: including 83s -- filter-list-to-where-clause for including 83s -- excluding 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, 83s i.relname, 83s i.oid, 83s rn.nspname, 83s r.relname, 83s indisprimary, 83s indisunique, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.oid 83s and array[attnum::integer] <@ indkey::integer[] 83s ) as cols, 83s pg_get_indexdef(indexrelid), 83s c.conname, 83s pg_get_constraintdef(c.oid) 83s from pg_index x 83s join pg_class i ON i.oid = x.indexrelid 83s join pg_class r ON r.oid = x.indrelid 83s join pg_namespace n ON n.oid = i.relnamespace 83s join pg_namespace rn ON rn.oid = r.relnamespace 83s left join pg_depend d on d.classid = 'pg_class'::regclass 83s and d.objid = i.oid 83s and d.refclassid = 'pg_constraint'::regclass 83s and d.deptype = 'i' 83s left join pg_constraint c ON c.oid = d.refobjid 83s where n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s and ((rn.nspname = 'expected' and r.relname = 'allcols')) 83s 83s order by n.nspname, r.relname 83s 2024-11-15T14:32:32.750265Z SQL -- params: including (table) 83s -- filter-list-to-where-clause for including 83s -- excluding (table) 83s -- filter-list-to-where-clause for excluding 83s -- including (ftable) 83s -- filter-list-to-where-clause for including 83s -- excluding (ftable) 83s -- filter-list-to-where-clause for excluding 83s select n.nspname, c.relname, nf.nspname, cf.relname as frelname, 83s r.oid, 83s d.refobjid as pkeyoid, 83s conname, 83s pg_catalog.pg_get_constraintdef(r.oid, true) as condef, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.conrelid 83s and array[attnum::integer] <@ conkey::integer[] 83s ) as conkey, 83s (select string_agg(attname, ',') 83s from pg_attribute 83s where attrelid = r.confrelid 83s and array[attnum::integer] <@ confkey::integer[] 83s ) as confkey, 83s confupdtype, confdeltype, confmatchtype, 83s condeferrable, condeferred 83s from pg_catalog.pg_constraint r 83s JOIN pg_class c on r.conrelid = c.oid 83s JOIN pg_namespace n on c.relnamespace = n.oid 83s JOIN pg_class cf on r.confrelid = cf.oid 83s JOIN pg_namespace nf on cf.relnamespace = nf.oid 83s JOIN pg_depend d on d.classid = 'pg_constraint'::regclass 83s and d.objid = r.oid 83s and d.refobjsubid = 0 83s where r.contype = 'f' 83s AND c.relkind in ('r', 'f', 'p') 83s AND cf.relkind in ('r', 'f', 'p') 83s AND n.nspname !~ '^pg_' and n.nspname <> 'information_schema' 83s AND nf.nspname !~ '^pg_' and nf.nspname <> 'information_schema' 83s and ((n.nspname = 'expected' and c.relname = 'allcols')) 83s 83s and ((nf.nspname = 'expected' and cf.relname = 'allcols')) 83s 83s 2024-11-15T14:32:32.752266Z DEBUG fetch-pgsql-catalog: 1 tables, 0 indexes, 0+0 fkeys 83s 2024-11-15T14:32:32.752266Z SQL TRUNCATE "expected"."allcols"; 83s 2024-11-15T14:32:32.761269Z INFO COPY ON ERROR RESUME NEXT 83s 2024-11-15T14:32:32.761269Z NOTICE COPY "expected"."allcols" with 0 rows estimated [0/4] 83s 2024-11-15T14:32:32.761269Z DEBUG Reader started for "expected"."allcols" 83s 2024-11-15T14:32:32.761269Z DEBUG start "expected"."allcols" 934331 83s 2024-11-15T14:32:32.761269Z NOTICE Opening #P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/allcols.out" 83s 2024-11-15T14:32:32.761269Z DEBUG Reader for "expected"."allcols" is done in 0.000000s 83s 2024-11-15T14:32:32.761269Z DEBUG Finished processing READER for "\"expected\".\"allcols\"" 0.000000s 83s 2024-11-15T14:32:32.824291Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.825291Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.825291Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.825291Z SQL SET search_path TO "expected"; 83s 2024-11-15T14:32:32.826291Z INFO pgsql:copy-rows-from-queue[1]: "expected"."allcols" ("a" "b" "c") 83s 2024-11-15T14:32:32.827291Z DEBUG send-batch[1] "expected"."allcols" 8 rows [ 0.2 kB] in 0.000000s 83s 2024-11-15T14:32:32.827291Z DEBUG stop "expected"."allcols" | 934331 .. 1000353 = 0.066022d0 83s 2024-11-15T14:32:32.830292Z DEBUG Writer[1] for "expected"."allcols" is done in 0.000000s 83s 2024-11-15T14:32:32.830292Z DEBUG Finished processing WRITER for "\"expected\".\"allcols\"" 0.000000s 83s 2024-11-15T14:32:32.830292Z LOG report summary reset 83s table name errors read imported bytes total time read write 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s fetch 0 0 0 0.004s 83s before load 0 2 2 0.076s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s "public"."allcols" 0 8 8 0.2 kB 0.076s 0.014s 0.003s 83s "expected"."allcols" 0 8 8 0.2 kB 0.066s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s Files Processed 0 2 2 0.014s 83s COPY Threads Completion 0 4 4 0.145s 83s ----------------------- --------- --------- --------- --------- -------------- --------- --------- 83s Total import time ✓ 16 16 0.4 kB 0.159s 83s 2024-11-15T14:32:32.893313Z DEBUG CONNECTED TO # 83s 2024-11-15T14:32:32.893313Z DEBUG SET client_encoding TO 'utf8' 83s 2024-11-15T14:32:32.893313Z DEBUG SET work_mem TO '14MB' 83s 2024-11-15T14:32:32.894314Z DEBUG SET standard_conforming_strings TO 'on' 83s 2024-11-15T14:32:32.894314Z DEBUG SET application_name TO 'pgloader' 83s 2024-11-15T14:32:32.897315Z NOTICE select count(*) from (select "a", "b", "c" from expected.allcols except select "a", "b", "c" from allcols) ss 83s 2024-11-15T14:32:32.897315Z NOTICE Got a diff of 0 rows 83s 2024-11-15T14:32:32.897315Z LOG Regress pass. 83s 2024-11-15T14:32:32.898315Z INFO Stopping monitor 83s Dropping cluster 17/regress ... 83s + PGSSLMODE=require 83s + pgloader --debug --regress test/allcols.load 85s + rm -rf /tmp/pgloader 85s autopkgtest [14:32:35]: test ssl: -----------------------] 85s autopkgtest [14:32:35]: test ssl: - - - - - - - - - - results - - - - - - - - - - 85s ssl PASS 86s autopkgtest [14:32:36]: test testsuite: preparing testbed 138s autopkgtest [14:33:28]: testbed dpkg architecture: amd64 139s autopkgtest [14:33:29]: testbed apt version: 2.9.8 139s autopkgtest [14:33:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 139s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 140s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 140s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 140s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [94.2 kB] 140s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1062 kB] 140s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [108 kB] 140s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [174 kB] 140s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [32.6 kB] 140s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [840 kB] 140s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [300 kB] 140s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [9416 B] 140s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [740 B] 140s Fetched 2718 kB in 1s (3112 kB/s) 140s Reading package lists... 145s Reading package lists... 145s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 145s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 145s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 145s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 145s Reading package lists...Building dependency tree... 145s Reading state information... 145s Calculating upgrade... 145s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 145s Reading package lists... 145s Building dependency tree... 145s Reading state information... 145s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 145s 145s Reading package lists... 145s Building dependency tree... 145s Reading state information... 145s Calculating upgrade... 145s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 145s Reading package lists... 146s Building dependency tree... 146s Reading state information... 146s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 151s Reading package lists... 151s Building dependency tree... 151s Reading state information... 151s Starting pkgProblemResolver with broken count: 0 151s Starting 2 pkgProblemResolver with broken count: 0 151s Done 151s The following additional packages will be installed: 151s freetds-common freetds-dev libct4 libio-pty-perl libipc-run-perl 151s libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader postgresql-17 151s postgresql-17-ip4r postgresql-client-17 postgresql-client-common 151s postgresql-common ssl-cert 151s Suggested packages: 151s postgresql-doc-17 151s Recommended packages: 151s freetds-doc libjson-xs-perl 151s The following NEW packages will be installed: 151s autopkgtest-satdep freetds-common freetds-dev libct4 libio-pty-perl 151s libipc-run-perl libjson-perl libpq5 libsybdb5 libxslt1.1 pgloader 151s postgresql-17 postgresql-17-ip4r postgresql-client-17 151s postgresql-client-common postgresql-common ssl-cert 151s 0 upgraded, 17 newly installed, 0 to remove and 0 not upgraded. 151s Need to get 46.9 MB/46.9 MB of archives. 151s After this operation, 103 MB of additional disk space will be used. 151s Get:1 /tmp/autopkgtest.7hBcH9/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [724 B] 151s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 152s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 152s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 152s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-common all 266 [37.0 kB] 152s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 152s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-common all 266 [162 kB] 152s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 freetds-common all 1.3.17+ds-2build3 [26.9 kB] 152s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 libct4 amd64 1.3.17+ds-2build3 [169 kB] 152s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libsybdb5 amd64 1.3.17+ds-2build3 [192 kB] 152s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 freetds-dev amd64 1.3.17+ds-2build3 [305 kB] 152s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.0-1 [249 kB] 152s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 152s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.0-1 [2111 kB] 152s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.0-1 [17.9 MB] 153s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-ip4r amd64 2.4.2-3 [194 kB] 153s Get:17 http://ftpmaster.internal/ubuntu plucky/universe amd64 pgloader amd64 3.6.10-4 [25.2 MB] 154s Preconfiguring packages ... 154s Fetched 46.9 MB in 2s (20.5 MB/s) 154s Selecting previously unselected package libjson-perl. 154s (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 ... 75576 files and directories currently installed.) 154s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 154s Unpacking libjson-perl (4.10000-1) ... 154s Selecting previously unselected package libio-pty-perl. 154s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 154s Unpacking libio-pty-perl (1:1.20-1build3) ... 154s Selecting previously unselected package libipc-run-perl. 154s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 154s Unpacking libipc-run-perl (20231003.0-2) ... 154s Selecting previously unselected package postgresql-client-common. 154s Preparing to unpack .../03-postgresql-client-common_266_all.deb ... 154s Unpacking postgresql-client-common (266) ... 154s Selecting previously unselected package ssl-cert. 154s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 154s Unpacking ssl-cert (1.1.2ubuntu2) ... 154s Selecting previously unselected package postgresql-common. 154s Preparing to unpack .../05-postgresql-common_266_all.deb ... 154s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 154s Unpacking postgresql-common (266) ... 154s Selecting previously unselected package freetds-common. 154s Preparing to unpack .../06-freetds-common_1.3.17+ds-2build3_all.deb ... 154s Unpacking freetds-common (1.3.17+ds-2build3) ... 154s Selecting previously unselected package libct4:amd64. 154s Preparing to unpack .../07-libct4_1.3.17+ds-2build3_amd64.deb ... 154s Unpacking libct4:amd64 (1.3.17+ds-2build3) ... 154s Selecting previously unselected package libsybdb5:amd64. 154s Preparing to unpack .../08-libsybdb5_1.3.17+ds-2build3_amd64.deb ... 154s Unpacking libsybdb5:amd64 (1.3.17+ds-2build3) ... 154s Selecting previously unselected package freetds-dev. 154s Preparing to unpack .../09-freetds-dev_1.3.17+ds-2build3_amd64.deb ... 154s Unpacking freetds-dev (1.3.17+ds-2build3) ... 154s Selecting previously unselected package libpq5:amd64. 155s Preparing to unpack .../10-libpq5_17.0-1_amd64.deb ... 155s Unpacking libpq5:amd64 (17.0-1) ... 155s Selecting previously unselected package libxslt1.1:amd64. 155s Preparing to unpack .../11-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 155s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 155s Selecting previously unselected package postgresql-client-17. 155s Preparing to unpack .../12-postgresql-client-17_17.0-1_amd64.deb ... 155s Unpacking postgresql-client-17 (17.0-1) ... 155s Selecting previously unselected package postgresql-17. 155s Preparing to unpack .../13-postgresql-17_17.0-1_amd64.deb ... 155s Unpacking postgresql-17 (17.0-1) ... 155s Selecting previously unselected package postgresql-17-ip4r. 155s Preparing to unpack .../14-postgresql-17-ip4r_2.4.2-3_amd64.deb ... 155s Unpacking postgresql-17-ip4r (2.4.2-3) ... 155s Selecting previously unselected package pgloader. 155s Preparing to unpack .../15-pgloader_3.6.10-4_amd64.deb ... 155s Unpacking pgloader (3.6.10-4) ... 155s Selecting previously unselected package autopkgtest-satdep. 155s Preparing to unpack .../16-2-autopkgtest-satdep.deb ... 155s Unpacking autopkgtest-satdep (0) ... 155s Setting up libio-pty-perl (1:1.20-1build3) ... 155s Setting up libpq5:amd64 (17.0-1) ... 155s Setting up ssl-cert (1.1.2ubuntu2) ... 156s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 156s Setting up libipc-run-perl (20231003.0-2) ... 156s Setting up libjson-perl (4.10000-1) ... 156s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 156s Setting up freetds-common (1.3.17+ds-2build3) ... 156s Setting up postgresql-client-common (266) ... 156s Setting up postgresql-client-17 (17.0-1) ... 156s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 156s Setting up libsybdb5:amd64 (1.3.17+ds-2build3) ... 156s Setting up libct4:amd64 (1.3.17+ds-2build3) ... 156s Setting up postgresql-common (266) ... 157s 157s Creating config file /etc/postgresql-common/createcluster.conf with new version 157s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 157s Removing obsolete dictionary files: 157s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 158s Setting up postgresql-17 (17.0-1) ... 158s Creating new PostgreSQL cluster 17/main ... 158s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 158s The files belonging to this database system will be owned by user "postgres". 158s This user must also own the server process. 158s 158s The database cluster will be initialized with locale "C.UTF-8". 158s The default database encoding has accordingly been set to "UTF8". 158s The default text search configuration will be set to "english". 158s 158s Data page checksums are disabled. 158s 158s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 158s creating subdirectories ... ok 158s selecting dynamic shared memory implementation ... posix 158s selecting default "max_connections" ... 100 158s selecting default "shared_buffers" ... 128MB 158s selecting default time zone ... Etc/UTC 158s creating configuration files ... ok 158s running bootstrap script ... ok 159s performing post-bootstrap initialization ... ok 159s syncing data to disk ... ok 162s Setting up freetds-dev (1.3.17+ds-2build3) ... 162s Setting up postgresql-17-ip4r (2.4.2-3) ... 162s Setting up pgloader (3.6.10-4) ... 162s Setting up autopkgtest-satdep (0) ... 162s Processing triggers for man-db (2.13.0-1) ... 163s Processing triggers for libc-bin (2.40-1ubuntu3) ... 166s (Reading database ... 78113 files and directories currently installed.) 166s Removing autopkgtest-satdep (0) ... 168s autopkgtest [14:33:58]: test testsuite: [----------------------- 168s + PGSUPERUSER=ubuntu 168s + PGLOADER=pgloader PGSUPERUSER=ubuntu pg_virtualenv -i-Atrust make -C test prepare regress 168s Creating new PostgreSQL cluster 17/regress ... 171s make: Entering directory '/tmp/autopkgtest.7hBcH9/build.xE9/src/test' 171s dropdb -U ubuntu pgloader 171s dropdb -U ubuntu stocks 171s dropdb: error: database removal failed: ERROR: database "pgloader" does not exist 171s make: [Makefile:67: prepare] Error 1 (ignored) 171s dropdb:dropdb -U ubuntu ip4r 171s error: database removal failed: ERROR: database "stocks" does not exist 171s make: [Makefile:68: prepare] Error 1 (ignored) 171s dropdb: error: database removal failed: ERROR: database "ip4r" does not exist 171s createuser -U ubuntu --superuser `whoami` 171s make: [Makefile:69: prepare] Error 1 (ignored) 171s createuser: error: creation of new role failed: ERROR: role "ubuntu" already exists 171s createdb -U ubuntu -O `whoami` pgloader 171s make: [Makefile:70: prepare] Error 1 (ignored) 171s createdb -U ubuntu -O `whoami` stocks 171s createdb -U ubuntu -O `whoami` ip4r 171s psql -d pgloader -c 'create schema expected' 171s CREATE SCHEMA 171s psql -U ubuntu -d pgloader -c 'create extension ip4r' 171s CREATE EXTENSION 171s psql -U ubuntu -d ip4r -c 'create extension ip4r' 171s CREATE EXTENSION 171s psql -d stocks -f bossa.sql 171s DROP TABLE 171s psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping 171s psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping 171s CREATE TABLE 171s CREATE TABLE 171s rm -f regress/out/* 171s pgloader --regress allcols.load 172s 2024-11-15T14:34:02.013000Z LOG pgloader version "3.6.10~devel" 172s 2024-11-15T14:34:02.042000Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 172s 2024-11-15T14:34:02.161001Z WARNING Target table "\"public\".\"allcols\"" has 1 indexes defined against it. 172s 2024-11-15T14:34:02.161001Z WARNING That could impact loading performance badly. 172s 2024-11-15T14:34:02.161001Z WARNING Consider the option 'drop indexes'. 172s 2024-11-15T14:34:02.208002Z WARNING pgloader always talk to PostgreSQL in utf-8, client_encoding has been forced to 'utf8'. 172s 2024-11-15T14:34:02.222002Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/allcols.out") 172s 2024-11-15T14:34:02.231002Z WARNING PostgreSQL warning: table "allcols" does not exist, skipping 172s 2024-11-15T14:34:02.292002Z LOG report summary reset 172s table name errors rows bytes total time 172s ----------------------- --------- --------- --------- -------------- 172s fetch 0 0 0.004s 172s before load 0 2 0.015s 172s ----------------------- --------- --------- --------- -------------- 172s "public"."allcols" 0 8 0.2 kB 0.022s 172s "expected"."allcols" 0 8 0.2 kB 0.015s 172s ----------------------- --------- --------- --------- -------------- 172s Files Processed 0 2 0.018s 172s COPY Threads Completion 0 4 0.041s 172s ----------------------- --------- --------- --------- -------------- 172s Total import time ✓ 16 0.4 kB 0.059s 172s 2024-11-15T14:34:02.313004Z LOG Regress pass. 172s touch regress/out/allcols.out 172s pgloader --regress csv-before-after.load 172s 2024-11-15T14:34:02.010000Z LOG pgloader version "3.6.10~devel" 173s 2024-11-15T14:34:02.402003Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-before-after.out") 173s 2024-11-15T14:34:02.422003Z WARNING PostgreSQL warning: table "blocks" does not exist, skipping 173s 2024-11-15T14:34:02.505004Z LOG report summary reset 173s table name errors rows bytes total time 173s ----------------------- --------- --------- --------- -------------- 173s fetch 0 0 0.004s 173s before load 0 6 0.015s 173s ----------------------- --------- --------- --------- -------------- 173s "csv"."blocks" 0 460 15.9 kB 0.183s 173s "expected"."blocks" 0 460 12.4 kB 0.015s 173s ----------------------- --------- --------- --------- -------------- 173s Files Processed 0 2 0.020s 173s COPY Threads Completion 0 4 0.198s 173s after load 0 1 0.024s 173s ----------------------- --------- --------- --------- -------------- 173s Total import time ✓ 920 28.2 kB 0.242s 173s 2024-11-15T14:34:02.523004Z LOG Regress pass. 173s touch regress/out/csv-before-after.out 173s pgloader --regress csv-districts.load 173s 2024-11-15T14:34:03.010000Z LOG pgloader version "3.6.10~devel" 173s 2024-11-15T14:34:03.270003Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-districts.out") 173s 2024-11-15T14:34:03.285003Z WARNING PostgreSQL warning: table "districts" does not exist, skipping 173s 2024-11-15T14:34:03.358003Z LOG report summary reset 173s table name errors rows bytes total time 173s ----------------------- --------- --------- --------- -------------- 173s fetch 0 0 0.004s 173s before load 0 2 0.015s 173s ----------------------- --------- --------- --------- -------------- 173s "public"."districts" 0 440 29.3 kB 0.080s 173s "expected"."districts" 0 440 29.1 kB 0.018s 173s ----------------------- --------- --------- --------- -------------- 173s Files Processed 0 2 0.021s 173s COPY Threads Completion 0 4 0.098s 173s ----------------------- --------- --------- --------- -------------- 173s Total import time ✓ 880 58.3 kB 0.119s 173s 2024-11-15T14:34:03.384004Z LOG Regress pass. 173s touch regress/out/csv-districts.out 173s pgloader --regress csv-parse-date.load 174s 2024-11-15T14:34:03.008000Z LOG pgloader version "3.6.10~devel" 174s 2024-11-15T14:34:03.253002Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-parse-date.out") 174s 2024-11-15T14:34:03.261002Z WARNING PostgreSQL warning: table "dateformat" does not exist, skipping 174s 2024-11-15T14:34:03.321002Z LOG report summary reset 174s table name errors rows bytes total time 174s ----------------------- --------- --------- --------- -------------- 174s fetch 0 0 0.005s 174s before load 0 2 0.013s 174s ----------------------- --------- --------- --------- -------------- 174s "public"."dateformat" 0 4 0.1 kB 0.025s 174s "expected"."dateformat" 0 4 0.1 kB 0.016s 174s ----------------------- --------- --------- --------- -------------- 174s Files Processed 0 2 0.017s 174s COPY Threads Completion 0 4 0.044s 174s ----------------------- --------- --------- --------- -------------- 174s Total import time ✓ 8 0.3 kB 0.061s 174s 2024-11-15T14:34:03.348002Z LOG Regress pass. 174s touch regress/out/csv-parse-date.out 174s pgloader --regress csv-error.load 174s 2024-11-15T14:34:04.010000Z LOG pgloader version "3.6.10~devel" 174s 2024-11-15T14:34:04.012000Z LOG Data errors in '/tmp/pgloader/' 174s 2024-11-15T14:34:04.012000Z LOG Regression testing: "csv-error.load" 174s 2024-11-15T14:34:04.012000Z LOG Parsing commands from file #P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/csv-error.load" 174s 2024-11-15T14:34:04.190001Z FATAL :ASCII stream decoding error on 174s #: 174s 174s the octet sequence #(195) cannot be decoded. 174s 2024-11-15T14:34:04.195001Z ERROR PostgreSQL ["\"public\".\"jordane\""] Database error 22001: value too long for type character(20) 174s CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 174s 2024-11-15T14:34:04.217001Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-error.out") 174s 2024-11-15T14:34:04.227001Z WARNING PostgreSQL warning: table "jordane" does not exist, skipping 174s 2024-11-15T14:34:04.302002Z LOG report summary reset 174s table name errors rows bytes total time 174s ----------------------- --------- --------- --------- -------------- 174s fetch 0 0 0.004s 174s before load 0 2 0.015s 174s ----------------------- --------- --------- --------- -------------- 174s "public"."jordane" 3 3 0.1 kB 0.026s 174s "expected"."jordane" 0 3 0.1 kB 0.014s 174s ----------------------- --------- --------- --------- -------------- 174s Files Processed 0 2 0.021s 174s COPY Threads Completion 0 4 0.037s 174s ----------------------- --------- --------- --------- -------------- 174s Total import time 3 6 0.2 kB 0.058s 174s 2024-11-15T14:34:04.322002Z LOG Regress pass. 174s touch regress/out/csv-error.out 174s pgloader --regress csv-escape-mode.load 175s 2024-11-15T14:34:05.014000Z LOG pgloader version "3.6.10~devel" 175s 2024-11-15T14:34:05.016000Z LOG Data errors in '/tmp/pgloader/' 175s 2024-11-15T14:34:05.016000Z LOG Regression testing: "csv-escape-mode.load" 175s 2024-11-15T14:34:05.016000Z LOG Parsing commands from file #P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/csv-escape-mode.load" 175s 2024-11-15T14:34:05.164001Z WARNING Target table "\"public\".\"csv_escape_mode\"" has 1 indexes defined against it. 175s 2024-11-15T14:34:05.164001Z WARNING That could impact loading performance badly. 175s 2024-11-15T14:34:05.164001Z WARNING Consider the option 'drop indexes'. 175s 2024-11-15T14:34:05.253001Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-escape-mode.out") 175s 2024-11-15T14:34:05.263001Z WARNING PostgreSQL warning: table "csv_escape_mode" does not exist, skipping 175s 2024-11-15T14:34:05.321002Z LOG report summary reset 175s table name errors rows bytes total time 175s ---------------------------- --------- --------- --------- -------------- 175s fetch 0 0 0.003s 175s before load 0 2 0.017s 175s ---------------------------- --------- --------- --------- -------------- 175s "public"."csv_escape_mode" 0 5 0.1 kB 0.055s 175s "expected"."csv_escape_mode" 0 5 0.1 kB 0.012s 175s ---------------------------- --------- --------- --------- -------------- 175s Files Processed 0 2 0.017s 175s COPY Threads Completion 0 4 0.070s 175s ---------------------------- --------- --------- --------- -------------- 175s Total import time ✓ 10 0.2 kB 0.087s 175s 2024-11-15T14:34:05.341002Z LOG Regress pass. 175s touch regress/out/csv-escape-mode.out 175s pgloader --regress csv-filename-pattern.load 175s 2024-11-15T14:34:05.010000Z LOG pgloader version "3.6.10~devel" 175s 2024-11-15T14:34:05.012000Z LOG Data errors in '/tmp/pgloader/' 175s 2024-11-15T14:34:05.012000Z LOG Regression testing: "csv-filename-pattern.load" 175s 2024-11-15T14:34:05.012000Z LOG Parsing commands from file #P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/csv-filename-pattern.load" 175s 2024-11-15T14:34:05.261001Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-filename-pattern.out") 175s 2024-11-15T14:34:05.271001Z WARNING PostgreSQL warning: table "matching" does not exist, skipping 175s 2024-11-15T14:34:05.333002Z LOG report summary reset 176s table name errors rows bytes total time 176s ----------------------- --------- --------- --------- -------------- 176s fetch 0 0 0.004s 176s before load 0 2 0.016s 176s ----------------------- --------- --------- --------- -------------- 176s "public"."matching" 0 3 0.0 kB 0.055s 176s "expected"."matching" 0 3 0.0 kB 0.015s 176s ----------------------- --------- --------- --------- -------------- 176s Files Processed 0 4 0.021s 176s COPY Threads Completion 0 8 0.072s 176s ----------------------- --------- --------- --------- -------------- 176s Total import time ✓ 6 0.0 kB 0.093s 176s 2024-11-15T14:34:05.352002Z LOG Regress pass. 176s touch regress/out/csv-filename-pattern.out 176s pgloader --regress csv-guess.load 176s 2024-11-15T14:34:06.010000Z LOG pgloader version "3.6.10~devel" 176s 2024-11-15T14:34:06.181001Z WARNING Target table "\"csv\".\"track\"" has 1 indexes defined against it. 176s 2024-11-15T14:34:06.181001Z WARNING That could impact loading performance badly. 176s 2024-11-15T14:34:06.181001Z WARNING Consider the option 'drop indexes'. 176s 2024-11-15T14:34:06.469003Z LOG Comparing loaded data against (#P"/tmp/autopkgtest.7hBcH9/build.xE9/src/test/regress/expected/csv-guess.out") 176s 2024-11-15T14:34:06.483004Z WARNING PostgreSQL warning: table "track" does not exist, skipping 176s 2024-11-15T14:34:06.610004Z LOG report summary reset 176s table name errors rows bytes total time 176s ----------------------- --------- --------- --------- -------------- 176s fetch 0 0 0.004s 176s before load 0 2 0.021s 176s ----------------------- --------- --------- --------- -------------- 176s "csv"."track" 0 3503 366.8 kB 0.248s 176s "expected"."track" 0 3503 366.8 kB 0.074s 176s ----------------------- --------- --------- --------- -------------- 176s Files Processed 0 2 0.020s 176s COPY Threads Completion 0 4 0.320s 176s ----------------------- --------- --------- --------- -------------- 176s Total import time ✓ 7006 733.5 kB 0.340s 176s 2024-11-15T14:34:06.629004Z LOG Regress pass. 176s touch regress/out/csv-guess.out 176s pgloader --regress csv-header.load 177s FATAL: Failed to start the monitor thread. 177s 177s The value 177s 17592186044416 177s is not of type 177s (UNSIGNED-BYTE 44) 177s 177s make: Leaving directory '/tmp/autopkgtest.7hBcH9/build.xE9/src/test' 177s make: *** [Makefile:125: regress/out/csv-header.out] Error 1 177s *** /tmp/pg_virtualenv.uF4McF/log/postgresql-17-regress.log (last 100 lines) *** 177s 2024-11-15 14:33:59.176 UTC [4121] LOG: starting PostgreSQL 17.0 (Ubuntu 17.0-1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 14.2.0-7ubuntu1) 14.2.0, 64-bit 177s 2024-11-15 14:33:59.176 UTC [4121] LOG: listening on IPv6 address "::1", port 5433 177s 2024-11-15 14:33:59.176 UTC [4121] LOG: listening on IPv4 address "127.0.0.1", port 5433 177s 2024-11-15 14:33:59.176 UTC [4121] LOG: listening on Unix socket "/tmp/.s.PGSQL.5433" 177s 2024-11-15 14:33:59.179 UTC [4124] LOG: database system was shut down at 2024-11-15 14:33:59 UTC 177s 2024-11-15 14:33:59.185 UTC [4121] LOG: database system is ready to accept connections 177s 2024-11-15 14:34:01.392 UTC [4142] ubuntu@postgres ERROR: database "pgloader" does not exist 177s 2024-11-15 14:34:01.392 UTC [4142] ubuntu@postgres STATEMENT: DROP DATABASE pgloader; 177s 2024-11-15 14:34:01.424 UTC [4144] ubuntu@postgres ERROR: database "stocks" does not exist 177s 2024-11-15 14:34:01.424 UTC [4144] ubuntu@postgres STATEMENT: DROP DATABASE stocks; 177s 2024-11-15 14:34:01.457 UTC [4146] ubuntu@postgres ERROR: database "ip4r" does not exist 177s 2024-11-15 14:34:01.457 UTC [4146] ubuntu@postgres STATEMENT: DROP DATABASE ip4r; 177s 2024-11-15 14:34:01.495 UTC [4150] ubuntu@postgres ERROR: role "ubuntu" already exists 177s 2024-11-15 14:34:01.495 UTC [4150] ubuntu@postgres STATEMENT: CREATE ROLE ubuntu SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS; 177s 2024-11-15 14:34:04.742 UTC [4280] ubuntu@pgloader ERROR: value too long for type character(20) 177s 2024-11-15 14:34:04.742 UTC [4280] ubuntu@pgloader CONTEXT: COPY jordane, line 4, column PRENOM: "testprenombe~aucouptroplong" 177s 2024-11-15 14:34:04.742 UTC [4280] ubuntu@pgloader STATEMENT: 177s copy "public"."jordane" ("NOM","PRENOM") FROM STDIN 177s Dropping cluster 17/regress ... 177s autopkgtest [14:34:07]: test testsuite: -----------------------] 178s testsuite FAIL non-zero exit status 2 178s autopkgtest [14:34:08]: test testsuite: - - - - - - - - - - results - - - - - - - - - - 179s autopkgtest [14:34:09]: @@@@@@@@@@@@@@@@@@@@ summary 179s ssl PASS 179s testsuite FAIL non-zero exit status 2 183s nova [W] Skipping flock for amd64 183s Creating nova instance adt-plucky-amd64-pgloader-20241115-143110-juju-7f2275-prod-proposed-migration-environment-15-9a86c284-b33a-482d-bfa8-b1a7196afce9 from image adt/ubuntu-plucky-amd64-server-20241115.img (UUID 9bb4dd9c-454f-45da-a125-77b9d27ed145)... 183s nova [W] Skipping flock for amd64 183s Creating nova instance adt-plucky-amd64-pgloader-20241115-143110-juju-7f2275-prod-proposed-migration-environment-15-9a86c284-b33a-482d-bfa8-b1a7196afce9 from image adt/ubuntu-plucky-amd64-server-20241115.img (UUID 9bb4dd9c-454f-45da-a125-77b9d27ed145)...