[MDEV-14583] innodb.innodb-index-online failed in buildbot Created: 2017-12-05  Updated: 2018-05-06  Resolved: 2018-05-06

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.3
Fix Version/s: 10.3.3

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-15020 Server hangs due to InnoDB persistent... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/10654/steps/mtr_nm/logs/stdio

innodb.innodb-index-online '16k,crypt,innodb' w1 [ fail ]
        Test ended at 2017-12-05 01:51:57
 
CURRENT_TEST: innodb.innodb-index-online
mysqltest: At line 135: query 'UPDATE mysql.innodb_index_stats SET stat_value = 5
WHERE database_name = 'test' AND table_name= 't1' AND index_name = 'PRIMARY'
AND stat_value = 6' failed: 1146: Table 'mysql.innodb_index_stats' doesn't exist
 
The result from queries just before the failure was:
< snip >
SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
name	count
ddl_background_drop_indexes	0
ddl_background_drop_tables	0
ddl_online_create_index	0
ddl_pending_alter_table	0
ddl_sort_file_alter_table	0
ddl_log_file_alter_table	0
connection default;
INSERT INTO t1 VALUES(6,3,1);
ERROR 23000: Duplicate entry '3' for key 'c2'
INSERT INTO t1 VALUES(7,4,2);
ERROR 23000: Duplicate entry '4' for key 'c2'
ALTER TABLE t1 STATS_PERSISTENT=1;
ANALYZE TABLE t1;
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
UPDATE mysql.innodb_index_stats SET stat_value = 5
WHERE database_name = 'test' AND table_name= 't1' AND index_name = 'PRIMARY'
AND stat_value = 6;



 Comments   
Comment by Thirunarayanan Balathandayuthapani [ 2018-05-06 ]

This bug is caused by
commit 1af2d7ba235305ffd4c24a47cccafd5fe6815d9e
Author: Vesa Pentti <vesa.pentti@mariadb.net>
Date: Fri Nov 24 21:56:13 2017 +0000

MDEV-12501 – set --maturity-level by default

It creates index_stats and table_stats in mysql database instead of innodb_index_stats and innodb_table_stats.

It is fixed by the following commit:

commit 5868a184fadc84265916c7d273e610d3fa4952e6
Author: Vesa Pentti <vesa.pentti@mariadb.net>
Date: Tue Dec 5 08:49:28 2017 +0000

Revert "MDEV-12501 – set --maturity-level by default"

This reverts commit 1af2d7ba235305ffd4c24a47cccafd5fe6815d9e.

Generated at Thu Feb 08 08:14:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.