Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
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;
|
Attachments
Issue Links
- relates to
-
MDEV-15020 Server hangs due to InnoDB persistent statistics or innodb_stats_auto_recalc
- Closed