[debian-mysql] Bug#1029374: Acknowledgement (mariadb: FTBFS on ppc64: main.func_json_notembedded very long output and crash)

[Otto Kekäläinen]

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.