[MDEV-11983] [bb-10.0-monty] Assertion `0' failed in sql/rpl_mi.cc:1122: Master_info* get_master_info Created: 2017-02-03  Updated: 2017-02-03  Resolved: 2017-02-03

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: 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
}



 Comments   
Comment by Michael Widenius [ 2017-02-03 ]

Wrong assert, ok to ignore. Will fix on next push

Generated at Thu Feb 08 07:54:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.