Control: forwarded -1 https://jira.mariadb.org/browse/MDEV-30518
Latest upload is failing now on different errors: https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=ppc64&ver=1%3A10.11.1-4&stamp=1675982284&raw=0 main.stat_tables_innodb 'innodb' w3 [ fail ] Test ended at 2023-02-09 22:34:39 CURRENT_TEST: main.stat_tables_innodb --- /<<PKGBUILDDIR>>/mysql-test/main/stat_tables_innodb.result 2022-11-14 18:10:21.000000000 +0000 +++ /<<PKGBUILDDIR>>/mysql-test/main/stat_tables_innodb.reject 2023-02-09 22:34:38.487409059 +0000 @@ -672,49 +672,36 @@ set optimizer_switch='extended_keys=off'; select * from mysql.table_stats; db_name table_name cardinality -dbt3_s001 lineitem 6005 select * from mysql.index_stats; db_name table_name index_name prefix_arity avg_frequency -dbt3_s001 lineitem PRIMARY 1 4.0033 -dbt3_s001 lineitem PRIMARY 2 1.0000 -dbt3_s001 lineitem i_l_shipdate 1 2.6500 -dbt3_s001 lineitem i_l_suppkey_partkey 1 30.0250 -dbt3_s001 lineitem i_l_suppkey_partkey 2 8.5786 -dbt3_s001 lineitem i_l_partkey 1 30.0250 -dbt3_s001 lineitem i_l_suppkey 1 600.5000 -dbt3_s001 lineitem i_l_receiptdate 1 2.6477 -dbt3_s001 lineitem i_l_orderkey 1 4.0033 -dbt3_s001 lineitem i_l_orderkey_quantity 1 4.0033 -dbt3_s001 lineitem i_l_orderkey_quantity 2 1.0404 -dbt3_s001 lineitem i_l_commitdate 1 2.7160 SHOW INDEXES FROM lineitem; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored -lineitem 0 PRIMARY 1 l_orderkey A 1500 NULL NULL BTREE NO +lineitem 0 PRIMARY 1 l_orderkey A 3002 NULL NULL BTREE NO lineitem 0 PRIMARY 2 l_linenumber A 6005 NULL NULL BTREE NO -lineitem 1 i_l_shipdate 1 l_shipDATE A 2266 NULL NULL YES BTREE NO -lineitem 1 i_l_suppkey_partkey 1 l_partkey A 200 NULL NULL YES BTREE NO -lineitem 1 i_l_suppkey_partkey 2 l_suppkey A 699 NULL NULL YES BTREE NO -lineitem 1 i_l_partkey 1 l_partkey A 200 NULL NULL YES BTREE NO -lineitem 1 i_l_suppkey 1 l_suppkey A 10 NULL NULL YES BTREE NO -lineitem 1 i_l_receiptdate 1 l_receiptDATE A 2268 NULL NULL YES BTREE NO -lineitem 1 i_l_orderkey 1 l_orderkey A 1500 NULL NULL BTREE NO -lineitem 1 i_l_orderkey_quantity 1 l_orderkey A 1500 NULL NULL BTREE NO -lineitem 1 i_l_orderkey_quantity 2 l_quantity A 5771 NULL NULL YES BTREE NO -lineitem 1 i_l_commitdate 1 l_commitDATE A 2210 NULL NULL YES BTREE NO +lineitem 1 i_l_shipdate 1 l_shipDATE A 6005 NULL NULL YES BTREE NO +lineitem 1 i_l_suppkey_partkey 1 l_partkey A 400 NULL NULL YES BTREE NO +lineitem 1 i_l_suppkey_partkey 2 l_suppkey A 1501 NULL NULL YES BTREE NO +lineitem 1 i_l_partkey 1 l_partkey A 400 NULL NULL YES BTREE NO +lineitem 1 i_l_suppkey 1 l_suppkey A 6 NULL NULL YES BTREE NO +lineitem 1 i_l_receiptdate 1 l_receiptDATE A 6005 NULL NULL YES BTREE NO +lineitem 1 i_l_orderkey 1 l_orderkey A 3002 NULL NULL BTREE NO +lineitem 1 i_l_orderkey_quantity 1 l_orderkey A 3002 NULL NULL BTREE NO +lineitem 1 i_l_orderkey_quantity 2 l_quantity A 6005 NULL NULL YES BTREE NO +lineitem 1 i_l_commitdate 1 l_commitDATE A 6005 NULL NULL YES BTREE NO SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE table_name='lineitem'; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IGNORED -def dbt3_s001 lineitem 0 dbt3_s001 PRIMARY 1 l_orderkey A 1500 NULL NULL BTREE NO +def dbt3_s001 lineitem 0 dbt3_s001 PRIMARY 1 l_orderkey A 3002 NULL NULL BTREE NO def dbt3_s001 lineitem 0 dbt3_s001 PRIMARY 2 l_linenumber A 6005 NULL NULL BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_shipdate 1 l_shipDATE A 2266 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey_partkey 1 l_partkey A 200 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey_partkey 2 l_suppkey A 699 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_partkey 1 l_partkey A 200 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey 1 l_suppkey A 10 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_receiptdate 1 l_receiptDATE A 2268 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey 1 l_orderkey A 1500 NULL NULL BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey_quantity 1 l_orderkey A 1500 NULL NULL BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey_quantity 2 l_quantity A 5771 NULL NULL YES BTREE NO -def dbt3_s001 lineitem 1 dbt3_s001 i_l_commitdate 1 l_commitDATE A 2210 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_shipdate 1 l_shipDATE A 6005 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey_partkey 1 l_partkey A 400 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey_partkey 2 l_suppkey A 1501 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_partkey 1 l_partkey A 400 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_suppkey 1 l_suppkey A 6 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_receiptdate 1 l_receiptDATE A 6005 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey 1 l_orderkey A 3002 NULL NULL BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey_quantity 1 l_orderkey A 3002 NULL NULL BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_orderkey_quantity 2 l_quantity A 6005 NULL NULL YES BTREE NO +def dbt3_s001 lineitem 1 dbt3_s001 i_l_commitdate 1 l_commitDATE A 6005 NULL NULL YES BTREE NO SELECT COUNT(DISTINCT l_orderkey), COUNT(DISTINCT l_orderkey,l_linenumber), COUNT(DISTINCT l_shipDATE), mysqltest: Result length mismatch ***Warnings generated in error logs during shutdown after running tests: main.stat_tables_innodb 2023-02-09 22:34:31 4 [ERROR] InnoDB: Database page corruption on disk or a failed read of file './dbt3_s001/lineitem.ibd' page [page id: space=26, page number=91]. You may have to recover from a backup. 2023-02-09 22:34:31 4 [ERROR] InnoDB: File './dbt3_s001/lineitem.ibd' is corrupted 2023-02-09 22:34:31 4 [ERROR] InnoDB: Database page corruption on disk or a failed read of file './dbt3_s001/lineitem.ibd' page [page id: space=26, page number=91]. You may have to recover from a backup. 2023-02-09 22:34:31 4 [ERROR] InnoDB: Database page corruption on disk or a failed read of file './dbt3_s001/lineitem.ibd' page [page id: space=26, page number=91]. You may have to recover from a backup. 2023-02-09 22:34:31 4 [ERROR] InnoDB: Database page corruption on disk or a failed read of file './dbt3_s001/lineitem.ibd' page [page id: space=26, page number=91]. You may have to recover from a backup. 2023-02-09 22:34:31 4 [ERROR] InnoDB: Database page corruption on disk or a failed read of file './dbt3_s001/lineitem.ibd' page [page id: space=26, page number=91]. You may have to recover from a backup.