| Bug #71163 | playing arround with innodb table monitor crashes server | ||
|---|---|---|---|
| Submitted: | 17 Dec 2013 15:19 | Modified: | 17 Dec 2013 16:10 |
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.6.15 | OS: | Linux (Ubuntu 12.04.3 LTS) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | crash, innodb table monitor | ||
[17 Dec 2013 15:19]
Oli Sennhauser
[17 Dec 2013 16:07]
MySQL Verification Team
Hi Oli! Verifying this now with a psuedo random testcase.
---------
drop procedure if exists p1;
delimiter $
create procedure p1()
begin
declare continue handler for sqlexception begin end;
repeat
if rand()*10000 >9999 then drop table if exists innodb_table_monitor; select 'dropped'; end if;
if rand()*100 <20 then create table if not exists innodb_table_monitor(a int)engine=innodb; select 'created'; end if;
if rand()>0.5 then drop table if exists t1; end if;
if rand()>0.5 then create table if not exists t1(a int primary key)partition by key(a) partitions 5; end if;
if rand()>0.1 then replace into t1 values(rand()*100); end if;
if rand()>0.1 then select * from information_schema.INNODB_SYS_TABLESTATS where name like '%t1%'; end if;
if(rand()>0.1 then analyze table t1; end if;
until 1=2 end repeat;
end $
delimiter ;
call p1();
----------
In my 5.6.15 I got assertion:
InnoDB: Assertion failure in thread 5984 in file ha_innodb.cc line 10832
InnoDB: Failing assertion: ib_table->stat_initialized
mysqld.exe!my_sigabrt_handler()[my_thr_init.c:517]
mysqld.exe!raise()[winsig.c:593]
mysqld.exe!abort()[abort.c:81]
mysqld.exe!ha_innobase::info_low()[ha_innodb.cc:10840]
mysqld.exe!get_schema_tables_record()[sql_show.cc:4353]
mysqld.exe!fill_schema_table_by_open()[sql_show.cc:3427]
mysqld.exe!get_all_tables()[sql_show.cc:4087]
mysqld.exe!do_fill_table()[sql_show.cc:7184]
mysqld.exe!get_schema_tables_result()[sql_show.cc:7285]
mysqld.exe!JOIN::prepare_result()[sql_select.cc:823]
mysqld.exe!JOIN::exec()[sql_executor.cc:116]
mysqld.exe!mysql_execute_select()[sql_select.cc:1103]
mysqld.exe!handle_select()[sql_select.cc:110]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5094]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2642]
mysqld.exe!sp_instr_stmt::exec_core()[sp_instr.cc:891]
mysqld.exe!sp_lex_instr::reset_lex_and_exec_core()[sp_instr.cc:390]
mysqld.exe!sp_lex_instr::validate_lex_and_execute_core()[sp_instr.cc:628]
mysqld.exe!sp_instr_stmt::execute()[sp_instr.cc:798]
mysqld.exe!sp_head::execute()[sp_head.cc:645]
mysqld.exe!sp_head::execute_procedure()[sp_head.cc:1315]
mysqld.exe!mysql_execute_command()[sql_parse.cc:4560]
mysqld.exe!mysql_parse()[sql_parse.cc:6240]
mysqld.exe!dispatch_command()[sql_parse.cc:1337]
mysqld.exe!do_command()[sql_parse.cc:1042]
mysqld.exe!do_handle_one_connection()[sql_connect.cc:982]
mysqld.exe!handle_one_connection()[sql_connect.cc:900]
mysqld.exe!pfs_spawn_thread()[pfs.cc:1861]
mysqld.exe!pthread_start()[my_winthread.c:63]
mysqld.exe!_callthreadstartex()[threadex.c:314]
[17 Dec 2013 16:10]
MySQL Verification Team
Duplicate of: http://bugs.mysql.com/bug.php?id=69641
