0s autopkgtest [09:25:57]: starting date: 2024-03-11 0s autopkgtest [09:25:57]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [09:25:57]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.xrba8hqx/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-2@bos03-arm64-12.secgroup --name adt-noble-arm64-sqlsmith-20240311-092557-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 103s autopkgtest [09:27:40]: @@@@@@@@@@@@@@@@@@@@ test bed setup 103s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 104s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [434 kB] 104s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2621 kB] 104s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [37.3 kB] 104s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 104s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [581 kB] 104s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 104s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [20.3 kB] 104s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 104s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [2971 kB] 104s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 104s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [39.6 kB] 104s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 106s Fetched 6837 kB in 2s (4341 kB/s) 106s Reading package lists... 109s Reading package lists... 110s Building dependency tree... 110s Reading state information... 111s Calculating upgrade... 111s The following packages will be upgraded: 111s libsqlite3-0 readline-common 111s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 111s Need to get 760 kB of archives. 111s After this operation, 0 B of additional disk space will be used. 111s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libsqlite3-0 arm64 3.45.1-1ubuntu1 [704 kB] 112s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 readline-common all 8.2-3.1 [56.4 kB] 113s Fetched 760 kB in 1s (1243 kB/s) 113s (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 ... 74748 files and directories currently installed.) 113s Preparing to unpack .../libsqlite3-0_3.45.1-1ubuntu1_arm64.deb ... 113s Unpacking libsqlite3-0:arm64 (3.45.1-1ubuntu1) over (3.45.1-1) ... 113s Preparing to unpack .../readline-common_8.2-3.1_all.deb ... 113s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 113s Setting up libsqlite3-0:arm64 (3.45.1-1ubuntu1) ... 113s Setting up readline-common (8.2-3.1) ... 113s Processing triggers for man-db (2.12.0-3) ... 113s Processing triggers for install-info (7.1-3) ... 114s Processing triggers for libc-bin (2.39-0ubuntu2) ... 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 116s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 116s sh: Attempting to set up Debian/Ubuntu apt sources automatically 116s sh: Distribution appears to be Ubuntu 118s Reading package lists... 118s Building dependency tree... 118s Reading state information... 119s eatmydata is already the newest version (131-1). 119s dbus is already the newest version (1.14.10-4ubuntu1). 119s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 119s Reading package lists... 119s Building dependency tree... 119s Reading state information... 120s rng-tools-debian is already the newest version (2.4). 120s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 120s Reading package lists... 120s Building dependency tree... 120s Reading state information... 121s haveged is already the newest version (1.9.14-1ubuntu1). 121s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 121s Reading package lists... 121s Building dependency tree... 121s Reading state information... 121s The following packages will be REMOVED: 121s cloud-init* python3-configobj* python3-debconf* 122s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 122s After this operation, 3248 kB disk space will be freed. 122s (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 ... 74748 files and directories currently installed.) 122s Removing cloud-init (24.1-0ubuntu1) ... 123s Removing python3-configobj (5.0.8-3) ... 123s Removing python3-debconf (1.5.86) ... 123s Processing triggers for man-db (2.12.0-3) ... 124s (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 ... 74359 files and directories currently installed.) 124s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 125s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 125s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 125s Reading package lists... 126s Building dependency tree... 126s Reading state information... 127s linux-generic is already the newest version (6.8.0-11.11+1). 127s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 128s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 128s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 128s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 128s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 130s Reading package lists... 130s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s Calculating upgrade... 132s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 132s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s autopkgtest [09:28:11]: rebooting testbed after setup commands that affected boot 160s autopkgtest [09:28:37]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 160s autopkgtest [09:28:37]: testbed dpkg architecture: arm64 162s autopkgtest [09:28:39]: @@@@@@@@@@@@@@@@@@@@ apt-source sqlsmith 164s Get:1 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (dsc) [2024 B] 164s Get:2 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (tar) [135 kB] 164s Get:3 http://ftpmaster.internal/ubuntu noble/universe sqlsmith 1.4-1build1 (diff) [2076 B] 164s gpgv: Signature made Sat Oct 28 09:32:16 2023 UTC 164s gpgv: using RSA key 92978A6E195E4921825F7FF0F34F09744E9F5DD9 164s gpgv: Can't check signature: No public key 164s dpkg-source: warning: cannot verify inline signature for ./sqlsmith_1.4-1build1.dsc: no acceptable signature found 164s autopkgtest [09:28:41]: testing package sqlsmith version 1.4-1build1 164s autopkgtest [09:28:41]: build not needed 164s autopkgtest [09:28:41]: test sqlsmith: preparing testbed 172s Reading package lists... 172s Building dependency tree... 172s Reading state information... 172s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 172s Starting 2 pkgProblemResolver with broken count: 0 172s Done 175s Done 175s Starting pkgProblemResolver with broken count: 0 175s Starting 2 pkgProblemResolver with broken count: 0 175s Done 175s The following additional packages will be installed: 175s libjson-perl libllvm17 libpq5 libpqxx-7.8 libxslt1.1 postgresql 175s postgresql-16 postgresql-client-16 postgresql-client-common 175s postgresql-common sqlsmith ssl-cert 175s Suggested packages: 175s postgresql-doc postgresql-doc-16 175s Recommended packages: 175s libjson-xs-perl 175s The following NEW packages will be installed: 175s libjson-perl libllvm17 libpq5 libpqxx-7.8 libxslt1.1 postgresql 175s postgresql-16 postgresql-client-16 postgresql-client-common 175s postgresql-common sqlsmith ssl-cert 175s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 175s 1 not fully installed or removed. 175s Need to get 42.4 MB of archives. 175s After this operation, 176 MB of additional disk space will be used. 175s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 libpq5 arm64 16.2-1 [136 kB] 175s Get:2 http://ftpmaster.internal/ubuntu noble/universe arm64 libpqxx-7.8 arm64 7.8.1-2 [156 kB] 175s Get:3 http://ftpmaster.internal/ubuntu noble/universe arm64 sqlsmith arm64 1.4-1build1 [148 kB] 175s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-common all 257 [36.2 kB] 175s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-client-16 arm64 16.2-1 [1260 kB] 175s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 175s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 175s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-common all 257 [162 kB] 175s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17 arm64 1:17.0.6-5build1 [25.0 MB] 175s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libxslt1.1 arm64 1.1.35-1 [161 kB] 175s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql-16 arm64 16.2-1 [15.2 MB] 175s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 postgresql all 16+257 [11.4 kB] 176s Preconfiguring packages ... 176s Fetched 42.4 MB in 2s (27.0 MB/s) 176s Selecting previously unselected package libpq5:arm64. 176s (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 ... 74304 files and directories currently installed.) 176s Preparing to unpack .../00-libpq5_16.2-1_arm64.deb ... 176s Unpacking libpq5:arm64 (16.2-1) ... 176s Selecting previously unselected package libpqxx-7.8. 176s Preparing to unpack .../01-libpqxx-7.8_7.8.1-2_arm64.deb ... 176s Unpacking libpqxx-7.8 (7.8.1-2) ... 176s Selecting previously unselected package sqlsmith. 176s Preparing to unpack .../02-sqlsmith_1.4-1build1_arm64.deb ... 176s Unpacking sqlsmith (1.4-1build1) ... 176s Selecting previously unselected package postgresql-client-common. 176s Preparing to unpack .../03-postgresql-client-common_257_all.deb ... 176s Unpacking postgresql-client-common (257) ... 176s Selecting previously unselected package postgresql-client-16. 176s Preparing to unpack .../04-postgresql-client-16_16.2-1_arm64.deb ... 176s Unpacking postgresql-client-16 (16.2-1) ... 176s Selecting previously unselected package libjson-perl. 177s Preparing to unpack .../05-libjson-perl_4.10000-1_all.deb ... 177s Unpacking libjson-perl (4.10000-1) ... 177s Selecting previously unselected package ssl-cert. 177s Preparing to unpack .../06-ssl-cert_1.1.2ubuntu1_all.deb ... 177s Unpacking ssl-cert (1.1.2ubuntu1) ... 177s Selecting previously unselected package postgresql-common. 177s Preparing to unpack .../07-postgresql-common_257_all.deb ... 177s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 177s Unpacking postgresql-common (257) ... 177s Selecting previously unselected package libllvm17:arm64. 177s Preparing to unpack .../08-libllvm17_1%3a17.0.6-5build1_arm64.deb ... 177s Unpacking libllvm17:arm64 (1:17.0.6-5build1) ... 177s Selecting previously unselected package libxslt1.1:arm64. 177s Preparing to unpack .../09-libxslt1.1_1.1.35-1_arm64.deb ... 177s Unpacking libxslt1.1:arm64 (1.1.35-1) ... 178s Selecting previously unselected package postgresql-16. 178s Preparing to unpack .../10-postgresql-16_16.2-1_arm64.deb ... 178s Unpacking postgresql-16 (16.2-1) ... 178s Selecting previously unselected package postgresql. 178s Preparing to unpack .../11-postgresql_16+257_all.deb ... 178s Unpacking postgresql (16+257) ... 178s Setting up postgresql-client-common (257) ... 178s Setting up libpq5:arm64 (16.2-1) ... 178s Setting up ssl-cert (1.1.2ubuntu1) ... 179s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 180s Setting up libpqxx-7.8 (7.8.1-2) ... 180s Setting up sqlsmith (1.4-1build1) ... 180s Setting up libjson-perl (4.10000-1) ... 180s Setting up libxslt1.1:arm64 (1.1.35-1) ... 180s Setting up libllvm17:arm64 (1:17.0.6-5build1) ... 180s Setting up postgresql-client-16 (16.2-1) ... 180s 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 180s Setting up postgresql-common (257) ... 180s 180s Creating config file /etc/postgresql-common/createcluster.conf with new version 181s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 181s Removing obsolete dictionary files: 181s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 182s Setting up postgresql-16 (16.2-1) ... 182s Creating new PostgreSQL cluster 16/main ... 182s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 182s The files belonging to this database system will be owned by user "postgres". 182s This user must also own the server process. 182s 182s The database cluster will be initialized with locale "C.UTF-8". 182s The default database encoding has accordingly been set to "UTF8". 182s The default text search configuration will be set to "english". 182s 182s Data page checksums are disabled. 182s 182s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 182s creating subdirectories ... ok 182s selecting dynamic shared memory implementation ... posix 182s selecting default max_connections ... 100 182s selecting default shared_buffers ... 128MB 182s selecting default time zone ... Etc/UTC 182s creating configuration files ... ok 182s running bootstrap script ... ok 182s performing post-bootstrap initialization ... ok 182s syncing data to disk ... ok 186s Setting up postgresql (16+257) ... 186s Setting up autopkgtest-satdep (0) ... 186s Processing triggers for man-db (2.12.0-3) ... 187s Processing triggers for libc-bin (2.39-0ubuntu2) ... 191s (Reading database ... 76260 files and directories currently installed.) 191s Removing autopkgtest-satdep (0) ... 193s autopkgtest [09:29:10]: test sqlsmith: [----------------------- 193s Creating new PostgreSQL cluster 16/regress ... 197s SQLsmith unreleased 197s Loading types...done. 197s Loading tables...done. 197s Loading columns and constraints...done. 197s Loading operators...done. 197s Loading routines...done. 197s Loading routine parameters...done. 197s Loading aggregates...done. 197s Loading aggregate parameters...done. 197s Generating indexes...done. 199s eeee.e.ee...eeeeeeeeee..e.e.e.ee..ee.eeeeeeeeeee.ee.eee.ee...e...e.eee..eeee.e 199s e..e.e.e.eeeee.eeee... 199s queries: 100 199s AST stats (avg): height = 10.97 nodes = 144.18 199s 21 ERROR: argument declared anyrange is not a range type but type anyrange 199s 12 ERROR: argument declared anymultirange is not a multirange type but type anymul 199s 6 ERROR: cannot cast type unknown to anyenum 199s 4 ERROR: operator does not exist: point = point 199s 1 ERROR: COALESCE could not convert type datemultirange to tsmultirange 199s 1 ERROR: COALESCE types oid and bit cannot be matched 199s 1 ERROR: cannot determine element type of "anyarray" argument 199s 1 ERROR: could not identify an ordering operator for type aclitem[] 199s 1 ERROR: could not implement window PARTITION BY 199s 1 ERROR: division by zero 199s 1 ERROR: function pg_catalog.int4multirange(int4range[]) does not exist 199s 1 ERROR: function pg_catalog.jsonb_extract_path(jsonb, text[]) does not exist 199s 1 ERROR: function pg_catalog.nummultirange(numrange[]) does not exist 199s 1 ERROR: operator does not exist: anymultirange @> oidDropping cluster 16/regress ... 199s 199s 1 ERROR: operator does not exist: anyrange <= int4range 199s 1 ERROR: operator does not exist: anyrange @> information_schema.sql_identifier 199s 1 ERROR: operator does not exist: cstring = cstring 199s 1 ERROR: operator does not exist: datemultirange &< tsmultirange 199s 1 ERROR: operator does not exist: daterange << anyrange 199s 1 ERROR: operator does not exist: daterange = anyrange 199s 1 ERROR: operator does not exist: int8range <@ tsmultirange 199s 1 ERROR: operator does not exist: name <@ name 199s 1 ERROR: operator does not exist: name @> name 199s 1 ERROR: operator does not exist: nummultirange >> anymultirange 199s 1 ERROR: operator does not exist: polygon = polygon 199s 1 ERROR: operator does not exist: xml = xml 199s error rate: 0.65 199s impedance report: 199s window_function: 29/9 (bad/ok) 199s comparison_op: 65/33 (bad/ok) 199s bool_term: 56/28 (bad/ok) 199s exists_predicate: 43/12 (bad/ok) 199s null_predicate: 59/26 (bad/ok) 199s coalesce: 47/20 (bad/ok) 199s column_reference: 65/33 (bad/ok) 199s const_expr: 65/34 (bad/ok) 199s funcall: 63/30 (bad/ok) 199s merge_stmt: 0/0 (bad/ok) 199s upsert_stmt: 0/0 (bad/ok) 199s joined_table: 45/18 (bad/ok) 199s table_sample: 59/23 (bad/ok) 199s truth_value: 59/22 (bad/ok) 199s nullif: 45/17 (bad/ok) 199s atomic_subselect: 63/31 (bad/ok) 199s case_expr: 63/27 (bad/ok) 199s query_spec: 65/28 (bad/ok) 199s select_list: 65/33 (bad/ok) 199s insert_stmt: 0/2 (bad/ok) 199s lateral_subquery: 36/10 (bad/ok) 199s delete_returning: 1/1 (bad/ok) 199s update_returning: 0/1 (bad/ok) 199s select_for_update: 21/12 (bad/ok) 199s common_table_expression: 11/3 (bad/ok) 199s from_clause: 65/31 (bad/ok) 199s simple_join_cond: 13/2 (bad/ok) 199s expr_join_cond: 43/18 (bad/ok) 199s table_subquery: 52/19 (bad/ok) 199s table_or_query_name: 56/26 (bad/ok) 200s autopkgtest [09:29:17]: test sqlsmith: -----------------------] 201s autopkgtest [09:29:18]: test sqlsmith: - - - - - - - - - - results - - - - - - - - - - 201s sqlsmith PASS 201s autopkgtest [09:29:18]: @@@@@@@@@@@@@@@@@@@@ summary 201s sqlsmith PASS 214s Creating nova instance adt-noble-arm64-sqlsmith-20240311-092557-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-arm64-server-20240311.img (UUID 900cfff9-7f1a-42c7-81a7-22635cd2a5f9)...