Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
|
bb-10.0-monty 820e895895981 |
mysqld: /data/src/bb-10.0-monty/sql/rpl_mi.cc:1122: Master_info* get_master_info(LEX_STRING*, Sql_condition::enum_warning_level): Assertion `0' failed.
|
170203 3:52:36 [ERROR] mysqld got signal 6 ;
|
|
|
#5 0x00007f2afa1a9448 in __GI_abort () at abort.c:89
|
#6 0x00007f2afa1a1266 in __assert_fail_base (fmt=0x7f2afa2da238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x14c68f1 "0", file=file@entry=0x14c62c0 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=line@entry=1122, function=function@entry=0x14c6d40 <get_master_info(st_mysql_lex_string*, Sql_condition::enum_warning_level)::__PRETTY_FUNCTION__> "Master_info* get_master_info(LEX_STRING*, Sql_condition::enum_warning_level)") at assert.c:92
|
#7 0x00007f2afa1a1312 in __GI___assert_fail (assertion=0x14c68f1 "0", file=0x14c62c0 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=1122, function=0x14c6d40 <get_master_info(st_mysql_lex_string*, Sql_condition::enum_warning_level)::__PRETTY_FUNCTION__> "Master_info* get_master_info(LEX_STRING*, Sql_condition::enum_warning_level)") at assert.c:101
|
#8 0x000000000088eab3 in get_master_info (connection_name=0x7f2ae181a9e0, warning=Sql_condition::WARN_LEVEL_NOTE) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1122
|
#9 0x0000000000599b8f in show_heartbeat_period (thd=0x7f2ae181a070, var=0x7f2afc36b550, buff=0x7f2afc36b150 "0") at /data/src/bb-10.0-monty/sql/mysqld.cc:7298
|
#10 0x00000000007a4bb7 in show_status_array (thd=0x7f2ae181a070, wild=0x0, variables=0x7f2af9865c88, value_type=OPT_SESSION, status_var=0x7f2afc36c590, prefix=0x14aa168 "", table=0x7f2acf869088, ucase_names=false, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:3057
|
#11 0x00000000007bdce7 in fill_status (thd=0x7f2ae181a070, tables=0x7f2acf8223d8, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:7490
|
#12 0x00000000007c18da in get_schema_tables_result (join=0x7f2acf822dc0, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.0-monty/sql/sql_show.cc:8291
|
#13 0x000000000072e240 in JOIN::exec_inner (this=0x7f2acf822dc0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2543
|
#14 0x000000000072d240 in JOIN::exec (this=0x7f2acf822dc0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2378
|
#15 0x0000000000732378 in mysql_select (thd=0x7f2ae181a070, rref_pointer_array=0x7f2ae181e370, tables=0x7f2acf8223d8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684652288, result=0x7f2acf822da0, unit=0x7f2ae181da08, select_lex=0x7f2ae181e0f8) at /data/src/bb-10.0-monty/sql/sql_select.cc:3314
|
#16 0x00000000007229fe in handle_select (thd=0x7f2ae181a070, lex=0x7f2ae181d940, result=0x7f2acf822da0, setup_tables_done_option=0) at /data/src/bb-10.0-monty/sql/sql_select.cc:373
|
#17 0x00000000006da29a in execute_sqlcom_select (thd=0x7f2ae181a070, all_tables=0x7f2acf8223d8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5287
|
#18 0x00000000006da49e in execute_show_status (thd=0x7f2ae181a070, all_tables=0x7f2acf8223d8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5308
|
#19 0x00000000006ccae5 in mysql_execute_command (thd=0x7f2ae181a070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2493
|
#20 0x00000000006deaac in mysql_parse (thd=0x7f2ae181a070, rawbuf=0x7f2acf822088 "SHOW STATUS /* QNO 22624 CON_ID 8 */", length=36, parser_state=0x7f2afc36d6a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6569
|
#21 0x00000000006c8248 in dispatch_command (command=COM_QUERY, thd=0x7f2ae181a070, packet=0x7f2ae1820071 "SHOW STATUS /* QNO 22624 CON_ID 8 */ ", packet_length=37) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
|
#22 0x00000000006c6c39 in do_command (thd=0x7f2ae181a070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#23 0x000000000089c30e in do_handle_one_connection (thd_arg=0x7f2ae181a070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#24 0x000000000089be60 in handle_one_connection (arg=0x7f2ae181a070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#25 0x00007f2afc0a30a4 in start_thread (arg=0x7f2afc36e700) at pthread_create.c:309
|
#26 0x00007f2afa25b87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
In the test case below neither procedure nor event are important, they are just to make things easier in MTR. Important parts are SHOW STATUS and restart of the slave server (the stack trace above is from a concurrent test, where SHOW STATUS was run directly, without an event).
--source include/master-slave.inc
|
--source include/have_binlog_format_mixed.inc
|
|
|
CREATE TABLE t1 (i INT) ENGINE=MyISAM; |
--delimiter $
|
CREATE PROCEDURE pr() |
BEGIN
|
LOOP
|
INSERT INTO t1 VALUES (1); |
END LOOP; |
END $ |
--delimiter ;
|
|
|
--sync_slave_with_master
|
|
|
--disable_query_log
|
--echo # Create events...
|
--let $events=200
|
while ($events)
|
{
|
eval CREATE EVENT ev$events ON SCHEDULE EVERY 1 SECOND DO SHOW STATUS; |
dec $events; |
}
|
--enable_query_log
|
SET GLOBAL event_scheduler=ON; |
|
|
--connection master1
|
--send CALL pr()
|
|
|
--let $run= 100
|
|
|
while ($run)
|
{
|
--connection master |
--sleep 1 |
--let $rpl_server_number= 2 |
--let $rpl_server_parameters= --event_scheduler=ON |
--source include/rpl_restart_server.inc |
--dec $run |
--connection slave |
--echo # Check that there was no assertion failure |
--error 1,2,255 |
--exec grep 'Assertion' $MYSQLTEST_VARDIR/log/mysqld.2.err |
}
|