0s autopkgtest [17:08:19]: starting date and time: 2024-03-19 17:08:19+0000 0s autopkgtest [17:08:19]: git checkout: 4a1cd702 l/adt_testbed: don't blame the testbed for unsolvable build deps 0s autopkgtest [17:08:19]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ubv41bny/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:sqlite3,src:readline --apt-upgrade sqlsmith --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=sqlite3/3.45.1-1ubuntu1 readline/8.2-3.1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@bos02-s390x-10.secgroup --name adt-noble-s390x-sqlsmith-20240319-170818-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-3 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 83s autopkgtest [17:09:42]: testbed dpkg architecture: s390x 83s autopkgtest [17:09:42]: testbed apt version: 2.7.12 83s autopkgtest [17:09:42]: @@@@@@@@@@@@@@@@@@@@ test bed setup 84s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 84s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3733 kB] 85s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 85s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [52.7 kB] 85s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [486 kB] 85s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main s390x Packages [642 kB] 85s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main s390x c-n-f Metadata [3032 B] 85s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x Packages [1372 B] 85s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted s390x c-n-f Metadata [116 B] 85s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x Packages [3971 kB] 85s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe s390x c-n-f Metadata [7292 B] 85s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x Packages [34.4 kB] 85s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse s390x c-n-f Metadata [116 B] 89s Fetched 9055 kB in 3s (2853 kB/s) 89s Reading package lists... 92s Reading package lists... 93s Building dependency tree... 93s Reading state information... 93s Calculating upgrade... 93s The following packages will be upgraded: 93s libsqlite3-0 readline-common 94s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 94s Need to get 804 kB of archives. 94s After this operation, 0 B of additional disk space will be used. 94s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main s390x libsqlite3-0 s390x 3.45.1-1ubuntu1 [747 kB] 94s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main s390x readline-common all 8.2-3.1 [56.4 kB] 94s Fetched 804 kB in 1s (1168 kB/s) 95s (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 ... 52171 files and directories currently installed.) 95s Preparing to unpack .../libsqlite3-0_3.45.1-1ubuntu1_s390x.deb ... 95s Unpacking libsqlite3-0:s390x (3.45.1-1ubuntu1) over (3.45.1-1) ... 95s Preparing to unpack .../readline-common_8.2-3.1_all.deb ... 95s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 95s Setting up libsqlite3-0:s390x (3.45.1-1ubuntu1) ... 95s Setting up readline-common (8.2-3.1) ... 95s Processing triggers for man-db (2.12.0-3) ... 95s Processing triggers for install-info (7.1-3) ... 95s Processing triggers for libc-bin (2.39-0ubuntu2) ... 95s Reading package lists... 95s Building dependency tree... 95s Reading state information... 96s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 96s Unknown architecture, assuming PC-style ttyS0 96s sh: Attempting to set up Debian/Ubuntu apt sources automatically 96s Reading package lists...sh: Distribution appears to be Ubuntu 97s 98s Building dependency tree... 98s Reading state information... 98s eatmydata is already the newest version (131-1). 98s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 99s dbus is already the newest version (1.14.10-4ubuntu1). 99s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 99s rng-tools-debian is already the newest version (2.4). 99s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 99s Reading package lists... 100s Building dependency tree... 100s Reading state information... 100s The following packages will be REMOVED: 100s cloud-init* python3-configobj* python3-debconf* 100s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 100s After this operation, 3252 kB disk space will be freed. 100s (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 ... 52171 files and directories currently installed.) 100s Removing cloud-init (24.1.1-0ubuntu1) ... 101s Removing python3-configobj (5.0.8-3) ... 101s Removing python3-debconf (1.5.86) ... 101s Processing triggers for man-db (2.12.0-3) ... 102s (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 ... 51782 files and directories currently installed.) 102s Purging configuration files for cloud-init (24.1.1-0ubuntu1) ... 103s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 103s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 103s invoke-rc.d: policy-rc.d denied execution of try-restart. 103s Reading package lists... 104s Building dependency tree... 104s Reading state information... 104s linux-generic is already the newest version (6.8.0-11.11+1). 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 105s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 105s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 105s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 108s Reading package lists... 108s Reading package lists... 109s Building dependency tree... 109s Reading state information... 109s Calculating upgrade... 109s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 109s Reading package lists... 110s Building dependency tree... 110s Reading state information... 110s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 110s autopkgtest [17:10:09]: rebooting testbed after setup commands that affected boot 132s autopkgtest [17:10:31]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP Tue Feb 13 23:45:46 UTC 2024 135s autopkgtest [17:10:34]: @@@@@@@@@@@@@@@@@@@@ apt-source sqlsmith 137s Get:1 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (dsc) [2024 B] 137s Get:2 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (tar) [135 kB] 137s Get:3 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (diff) [2076 B] 138s gpgv: Signature made Sat Oct 28 09:32:16 2023 UTC 138s gpgv: using RSA key 92978A6E195E4921825F7FF0F34F09744E9F5DD9 138s gpgv: Can't check signature: No public key 138s dpkg-source: warning: cannot verify inline signature for ./sqlsmith_1.4-1build1.dsc: no acceptable signature found 138s autopkgtest [17:10:37]: testing package sqlsmith version 1.4-1build1 138s autopkgtest [17:10:37]: build not needed 139s autopkgtest [17:10:38]: test sqlsmith: preparing testbed 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s Starting pkgProblemResolver with broken count: 0 143s Starting 2 pkgProblemResolver with broken count: 0 143s Done 144s The following additional packages will be installed: 144s libjson-perl libllvm17 libpq5 libpqxx-7.8 libxslt1.1 postgresql 144s postgresql-16 postgresql-client-16 postgresql-client-common 144s postgresql-common sqlsmith ssl-cert 144s Suggested packages: 144s postgresql-doc postgresql-doc-16 144s Recommended packages: 144s libjson-xs-perl 144s The following NEW packages will be installed: 144s autopkgtest-satdep libjson-perl libllvm17 libpq5 libpqxx-7.8 libxslt1.1 144s postgresql postgresql-16 postgresql-client-16 postgresql-client-common 144s postgresql-common sqlsmith ssl-cert 144s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 144s Need to get 50.1 MB/50.1 MB of archives. 144s After this operation, 214 MB of additional disk space will be used. 144s Get:1 /tmp/autopkgtest.Z9v5jA/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [716 B] 144s Get:2 http://ftpmaster.internal/ubuntu noble/main s390x libjson-perl all 4.10000-1 [81.9 kB] 145s Get:3 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-common all 257 [36.2 kB] 145s Get:4 http://ftpmaster.internal/ubuntu noble/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 145s Get:5 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-common all 257 [162 kB] 145s Get:6 http://ftpmaster.internal/ubuntu noble/main s390x libllvm17 s390x 1:17.0.6-5build1 [31.2 MB] 149s Get:7 http://ftpmaster.internal/ubuntu noble/main s390x libpq5 s390x 16.2-1 [143 kB] 149s Get:8 http://ftpmaster.internal/ubuntu noble/universe s390x libpqxx-7.8 s390x 7.8.1-2 [165 kB] 149s Get:9 http://ftpmaster.internal/ubuntu noble/main s390x libxslt1.1 s390x 1.1.35-1 [157 kB] 149s Get:10 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-client-16 s390x 16.2-1 [1295 kB] 149s Get:11 http://ftpmaster.internal/ubuntu noble/main s390x postgresql-16 s390x 16.2-1 [16.7 MB] 149s Get:12 http://ftpmaster.internal/ubuntu noble/main s390x postgresql all 16+257 [11.4 kB] 149s Get:13 http://ftpmaster.internal/ubuntu noble/universe s390x sqlsmith s390x 1.4-1build1 [164 kB] 150s Preconfiguring packages ... 150s Fetched 50.1 MB in 5s (9310 kB/s) 150s Selecting previously unselected package libjson-perl. 150s (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 ... 51727 files and directories currently installed.) 150s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 150s Unpacking libjson-perl (4.10000-1) ... 150s Selecting previously unselected package postgresql-client-common. 150s Preparing to unpack .../01-postgresql-client-common_257_all.deb ... 150s Unpacking postgresql-client-common (257) ... 150s Selecting previously unselected package ssl-cert. 150s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 150s Unpacking ssl-cert (1.1.2ubuntu1) ... 150s Selecting previously unselected package postgresql-common. 150s Preparing to unpack .../03-postgresql-common_257_all.deb ... 150s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 150s Unpacking postgresql-common (257) ... 150s Selecting previously unselected package libllvm17:s390x. 150s Preparing to unpack .../04-libllvm17_1%3a17.0.6-5build1_s390x.deb ... 150s Unpacking libllvm17:s390x (1:17.0.6-5build1) ... 152s Selecting previously unselected package libpq5:s390x. 152s Preparing to unpack .../05-libpq5_16.2-1_s390x.deb ... 152s Unpacking libpq5:s390x (16.2-1) ... 153s Selecting previously unselected package libpqxx-7.8. 153s Preparing to unpack .../06-libpqxx-7.8_7.8.1-2_s390x.deb ... 153s Unpacking libpqxx-7.8 (7.8.1-2) ... 153s Selecting previously unselected package libxslt1.1:s390x. 153s Preparing to unpack .../07-libxslt1.1_1.1.35-1_s390x.deb ... 153s Unpacking libxslt1.1:s390x (1.1.35-1) ... 153s Selecting previously unselected package postgresql-client-16. 153s Preparing to unpack .../08-postgresql-client-16_16.2-1_s390x.deb ... 153s Unpacking postgresql-client-16 (16.2-1) ... 153s Selecting previously unselected package postgresql-16. 153s Preparing to unpack .../09-postgresql-16_16.2-1_s390x.deb ... 153s Unpacking postgresql-16 (16.2-1) ... 154s Selecting previously unselected package postgresql. 154s Preparing to unpack .../10-postgresql_16+257_all.deb ... 154s Unpacking postgresql (16+257) ... 154s Selecting previously unselected package sqlsmith. 154s Preparing to unpack .../11-sqlsmith_1.4-1build1_s390x.deb ... 154s Unpacking sqlsmith (1.4-1build1) ... 154s Selecting previously unselected package autopkgtest-satdep. 154s Preparing to unpack .../12-1-autopkgtest-satdep.deb ... 154s Unpacking autopkgtest-satdep (0) ... 154s Setting up postgresql-client-common (257) ... 154s Setting up libpq5:s390x (16.2-1) ... 154s Setting up ssl-cert (1.1.2ubuntu1) ... 155s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 156s Setting up libpqxx-7.8 (7.8.1-2) ... 156s Setting up sqlsmith (1.4-1build1) ... 156s Setting up libjson-perl (4.10000-1) ... 156s Setting up libxslt1.1:s390x (1.1.35-1) ... 156s Setting up libllvm17:s390x (1:17.0.6-5build1) ... 156s Setting up postgresql-client-16 (16.2-1) ... 156s 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 156s Setting up postgresql-common (257) ... 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: 158s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 159s Setting up postgresql-16 (16.2-1) ... 159s Creating new PostgreSQL cluster 16/main ... 159s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 159s The files belonging to this database system will be owned by user "postgres". 159s This user must also own the server process. 159s 159s The database cluster will be initialized with locale "C.UTF-8". 159s The default database encoding has accordingly been set to "UTF8". 159s The default text search configuration will be set to "english". 159s 159s Data page checksums are disabled. 159s 159s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 159s creating subdirectories ... ok 159s selecting dynamic shared memory implementation ... posix 159s selecting default max_connections ... 100 159s selecting default shared_buffers ... 128MB 159s selecting default time zone ... Etc/UTC 159s creating configuration files ... ok 159s running bootstrap script ... ok 160s performing post-bootstrap initialization ... ok 160s syncing data to disk ... ok 164s Setting up postgresql (16+257) ... 164s Setting up autopkgtest-satdep (0) ... 164s Processing triggers for man-db (2.12.0-3) ... 166s Processing triggers for libc-bin (2.39-0ubuntu2) ... 169s (Reading database ... 53683 files and directories currently installed.) 169s Removing autopkgtest-satdep (0) ... 170s autopkgtest [17:11:09]: test sqlsmith: [----------------------- 171s Creating new PostgreSQL cluster 16/regress ... 174s SQLsmith unreleased 174s Loading types...done. 174s Loading tables...done. 174s Loading columns and constraints...done. 174s Loading operators...done. 174s Loading routines...done. 174s Loading routine parameters...done. 174s Loading aggregates...done. 174s Loading aggregate parameters...done. 174s Generating indexes...done. 176s .ee.ee.eeee..ee.e.e.e...e.eeee.e.e.e.e..ee.eeee.e..ee.eee..e...eeee.eee..e...e 176s .e.....e.e...e.e..e.ee 176s queries: 100 176s AST stats (avg): height = 10.55 nodes = 133.22 176s 23 ERROR: argument declared anymultirange is not a multirange type but type anymul 176s 10 ERROR: argument declared anyrange is not a range type but type anyrange 176s 3 ERROR: cannot cast type unknown to anyenum 176s 2 ERROR: operator does not exist: cstring = cstring 176s 1 ERROR: could not identify an equality operator for type json 176s 1 ERROR: could not identify an ordering operator for type aclitem[] 176s 1 ERROR: function pg_catalog.array_remove(oid[], information_schema.character_dat 176s 1 ERROR: operator does not exist: anyarray <> point 176s 1 ERROR: operator does not exist: anymultirange << tsmultirange 176s 1 ERROR: operator does not exist: anymultirange <@ int8multirange 176s 1 ERROR: operator does not exist: anyrange <@ nummultirange 176s 1 ERROR: operator does not exist: boolean <@ anyrange 176s 1 ERROR: operator does not exist: information_schema.character_data <@ anymultira 176s 1 ERROR: operator does not exist: int8range && anyrange 176s 1 ERROR: operator does not exist: integer <@ anymultirange 176s 1 ERROR: operator does not exist: name && name 176s 1 ERROR: operator does not exist: oid <@ anymultirange 176s 1 ERROR: operator does not exist: polygon = polygon 176s error rate: 0.52 176s impedance report: 176s window_function: 33/12 (bad/ok) 176s comparison_op: 52/43 (bad/ok) 176s bool_term: 49/35 (bad/ok) 176s exists_predicate: 40/23 (bad/ok) 176s null_predicate: 47/39 (bad/ok) 176s coalesce: 39/23 (bad/ok) 176s column_reference: 52/47 (bad/ok) 176s const_expr: 52/45 (bad/ok) 176s funcall: 52/45 (bad/ok) 176s merge_stmt: 0/1 (bad/ok) 176s upsert_stmt: 0/0 (bad/ok) 176s joined_table: 35/24 (bad/ok) 176s table_sample: 48/33 (bad/ok) 176s truth_value: 49/27 (bad/ok) 176s nullif: 36/22 (bad/ok) 176s atomic_subselect: 51/41 (bad/ok) 176s case_expr: 50/35 (bad/ok) 176s query_spec: 51/41 (bad/ok) 176s select_list: 52/47 (bad/ok) 176s insert_stmt: 0/1 (bad/ok) 176s lateral_subquery: 33/11 (bad/ok) 176s delete_returning: 3/0 (bad/ok) 176s update_returning: 0/1 (bad/ok) 176s select_for_update: 19/16 (bad/ok) 176s common_table_expression: 11/1 (bad/ok) 176s from_clause: 51/46 (bad/ok) 176s simple_join_cond: 9/4 (bad/ok) 176s expr_join_cond: 33/24 (bad/ok) 176s table_subquery: 43/28 (bad/ok) 176s table_or_query_name: 46/38 (bad/ok) 176s Dropping cluster 16/regress ... 177s autopkgtest [17:11:16]: test sqlsmith: -----------------------] 177s autopkgtest [17:11:16]: test sqlsmith: - - - - - - - - - - results - - - - - - - - - - 177s sqlsmith PASS 178s autopkgtest [17:11:17]: @@@@@@@@@@@@@@@@@@@@ summary 178s sqlsmith PASS 189s Creating nova instance adt-noble-s390x-sqlsmith-20240319-170818-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-s390x-server-20240319.img (UUID e548347a-8530-49a1-9caa-86a7013f2b8b)...