Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
Description
10.3 a33c0e3f34afd024ded83d3e5ec122c50d8b38a2
|
Version: '10.3.11-MariaDB-debug-log'
|
mysqld: /git/10.3/sql/handler.h:3096: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
|
181106 16:46:22 [ERROR] mysqld got signal 6 ;
|
stdlib/abort.c:91(__GI_abort)[0x7ff6000ff02a]
|
assert/assert.c:92(__assert_fail_base)[0x7ff6000f5bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7ff6000f5c82]
|
sql/handler.h:3097(handler::ha_rnd_end())[0x561c35827ef5]
|
sql/ha_partition.cc:4991(ha_partition::rnd_end())[0x561c3704f2a1]
|
sql/ha_partition.cc:4928(ha_partition::rnd_init(bool))[0x561c3704ea4a]
|
sql/handler.h:3089(handler::ha_rnd_init(bool))[0x561c358f1f2a]
|
sql/handler.cc:2981(handler::ha_rnd_init_with_error(bool))[0x561c36061db3]
|
sql/records.cc:298(init_read_record(READ_RECORD*, THD*, TABLE*, SQL_SELECT*, SORT_INFO*, int, bool, bool))[0x561c363f27eb]
|
sql/sql_select.cc:20232(join_init_read_record(st_join_table*))[0x561c35aa01e2]
|
sql/sql_select.cc:19300(sub_select(JOIN*, st_join_table*, bool))[0x561c35a99c09]
|
sql/sql_select.cc:18843(do_select(JOIN*, Procedure*))[0x561c35a98261]
|
sql/sql_select.cc:4035(JOIN::exec_inner())[0x561c35a376df]
|
sql/sql_select.cc:3830(JOIN::exec())[0x561c35a35424]
|
sql/sql_select.cc:4236(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561c35a387f6]
|
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561c35a13bdd]
|
sql/sql_parse.cc:6547(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561c3599a5a2]
|
sql/sql_parse.cc:3769(mysql_execute_command(THD*))[0x561c35988d13]
|
sql/sql_parse.cc:8091(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561c359a2fc7]
|
sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561c3597dae8]
|
sql/sql_parse.cc:1395(do_command(THD*))[0x561c3597ac80]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x561c35cccb89]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x561c35ccc566]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7ff600d3a6ba]
|
x86_64/clone.S:111(clone)[0x7ff6001cf41d]
|
with update or delete:
linux/raise.c:54(__GI_raise)[0x7fb745d56428]
|
stdlib/abort.c:91(__GI_abort)[0x7fb745d5802a]
|
assert/assert.c:92(__assert_fail_base)[0x7fb745d4ebd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb745d4ec82]
|
sql/handler.h:3097(handler::ha_rnd_end())[0x561d2f99cef5]
|
sql/ha_partition.cc:4991(ha_partition::rnd_end())[0x561d311c42a1]
|
sql/ha_partition.cc:4928(ha_partition::rnd_init(bool))[0x561d311c3a4a]
|
sql/handler.h:3089(handler::ha_rnd_init(bool))[0x561d2fa66f2a]
|
sql/handler.cc:2981(handler::ha_rnd_init_with_error(bool))[0x561d301d6db3]
|
sql/records.cc:298(init_read_record(READ_RECORD*, THD*, TABLE*, SQL_SELECT*, SORT_INFO*, int, bool, bool))[0x561d305677eb]
|
sql/sql_update.cc:819(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x561d2fd52298]
|
sql/sql_parse.cc:4581(mysql_execute_command(THD*))[0x561d2fb01bbb]
|
sql/sql_parse.cc:8091(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561d2fb17fc7]
|
sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561d2faf2ae8]
|
sql/sql_parse.cc:1395(do_command(THD*))[0x561d2faefc80]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x561d2fe41b89]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x561d2fe41566]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb7469936ba]
|
x86_64/clone.S:111(clone)[0x7fb745e2841d]
|
Attachments
Issue Links
- relates to
-
MDEV-16241 Assertion `inited==RND' failed in handler::ha_rnd_end() or crash in in ha_innobase::innobase_get_index
-
- Closed
-
Test cases:
--source include/have_partition.inc
# Cleanup
10.3 def2ac209
mysqld: /data/src/10.3/sql/handler.h:3096: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
181112 0:15:19 [ERROR] mysqld got signal 6 ;
#7 0x00007f50707c4ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055c4eec71e00 in handler::ha_rnd_end (this=0x7f5058098218) at /data/src/10.3/sql/handler.h:3096
#9 0x000055c4ef763f13 in ha_partition::rnd_end (this=0x7f50580979b8) at /data/src/10.3/sql/ha_partition.cc:4998
#10 0x000055c4ef763c88 in ha_partition::rnd_init (this=0x7f50580979b8, scan=true) at /data/src/10.3/sql/ha_partition.cc:4932
#11 0x000055c4eecc96d9 in handler::ha_rnd_init (this=0x7f50580979b8, scan=true) at /data/src/10.3/sql/handler.h:3089
#12 0x000055c4ef00349d in handler::ha_rnd_init_with_error (this=0x7f50580979b8, scan=true) at /data/src/10.3/sql/handler.cc:2981
#13 0x000055c4ef1826be in init_read_record (info=0x7f5058017728, thd=0x7f5058000b00, table=0x7f5058096d70, select=0x7f5058017fb0, filesort=0x0, use_record_cache=1, print_error=true, disable_rr_cache=false) at /data/src/10.3/sql/records.cc:298
#14 0x000055c4eed81787 in join_init_read_record (tab=0x7f5058017660) at /data/src/10.3/sql/sql_select.cc:20313
#15 0x000055c4eed7f470 in sub_select (join=0x7f50580159c0, join_tab=0x7f5058017660, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:19381
#16 0x000055c4eed7ea0c in do_select (join=0x7f50580159c0, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18924
#17 0x000055c4eed57603 in JOIN::exec_inner (this=0x7f50580159c0) at /data/src/10.3/sql/sql_select.cc:4028
#18 0x000055c4eed56a44 in JOIN::exec (this=0x7f50580159c0) at /data/src/10.3/sql/sql_select.cc:3822
#19 0x000055c4eed57ce4 in mysql_select (thd=0x7f5058000b00, tables=0x7f5058014f28, wild_num=1, fields=..., conds=0x7f5058015778, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5058015998, unit=0x7f50580049b0, select_lex=0x7f5058005120) at /data/src/10.3/sql/sql_select.cc:4227
#20 0x000055c4eed49c7c in handle_select (thd=0x7f5058000b00, lex=0x7f50580048e8, result=0x7f5058015998, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:385
#21 0x000055c4eed14873 in execute_sqlcom_select (thd=0x7f5058000b00, all_tables=0x7f5058014f28) at /data/src/10.3/sql/sql_parse.cc:6546
#22 0x000055c4eed0aee3 in mysql_execute_command (thd=0x7f5058000b00) at /data/src/10.3/sql/sql_parse.cc:3767
#23 0x000055c4eed1882b in mysql_parse (thd=0x7f5058000b00, rawbuf=0x7f5058014cd8 "SELECT * FROM t1 WHERE MATCH (f2) AGAINST ('bar' IN BOOLEAN MODE)", length=65, parser_state=0x7f506a96b5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
#24 0x000055c4eed059f1 in dispatch_command (command=COM_QUERY, thd=0x7f5058000b00, packet=0x7f505800b1e1 "", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1850
#25 0x000055c4eed04415 in do_command (thd=0x7f5058000b00) at /data/src/10.3/sql/sql_parse.cc:1395
#26 0x000055c4eee6be9c in do_handle_one_connection (connect=0x55c4f2702d20) at /data/src/10.3/sql/sql_connect.cc:1402
#27 0x000055c4eee6bc20 in handle_one_connection (arg=0x55c4f2702d20) at /data/src/10.3/sql/sql_connect.cc:1308
#28 0x000055c4ef2ff999 in pfs_spawn_thread (arg=0x55c4f274f940) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#29 0x00007f507249b494 in start_thread (arg=0x7f506a96c700) at pthread_create.c:333
#30 0x00007f507088193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Query (0x7f5058014cd8): SELECT * FROM t1 WHERE MATCH (f2) AGAINST ('bar' IN BOOLEAN MODE)
Connection ID (thread ID): 4
Status: NOT_KILLED
--source include/have_partition.inc
# Cleanup
mysqld: /data/src/10.3/sql/handler.h:3096: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
181112 0:16:22 [ERROR] mysqld got signal 6 ;
#7 0x00007fa385947ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055e56209de00 in handler::ha_rnd_end (this=0x7fa364098218) at /data/src/10.3/sql/handler.h:3096
#9 0x000055e562b8ff13 in ha_partition::rnd_end (this=0x7fa3640979b8) at /data/src/10.3/sql/ha_partition.cc:4998
#10 0x000055e562b8fc88 in ha_partition::rnd_init (this=0x7fa3640979b8, scan=true) at /data/src/10.3/sql/ha_partition.cc:4932
#11 0x000055e5620f56d9 in handler::ha_rnd_init (this=0x7fa3640979b8, scan=true) at /data/src/10.3/sql/handler.h:3089
#12 0x000055e56242f49d in handler::ha_rnd_init_with_error (this=0x7fa3640979b8, scan=true) at /data/src/10.3/sql/handler.cc:2981
#13 0x000055e5625ae6be in init_read_record (info=0x7fa3802ee170, thd=0x7fa364000b00, table=0x7fa364096d70, select=0x7fa364015bb8, filesort=0x0, use_record_cache=0, print_error=true, disable_rr_cache=false) at /data/src/10.3/sql/records.cc:298
#14 0x000055e562230b93 in mysql_update (thd=0x7fa364000b00, table_list=0x7fa364014e10, fields=..., values=..., conds=0x7fa364015830, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fa3802ee6f0, updated_return=0x7fa3802ee7b0) at /data/src/10.3/sql/sql_update.cc:725
#15 0x000055e56213940f in mysql_execute_command (thd=0x7fa364000b00) at /data/src/10.3/sql/sql_parse.cc:4579
#16 0x000055e56214482b in mysql_parse (thd=0x7fa364000b00, rawbuf=0x7fa364014cd8 "UPDATE t1 SET i=2 WHERE MATCH (f2) AGAINST ('bar' IN BOOLEAN MODE)", length=66, parser_state=0x7fa3802ef5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
#17 0x000055e5621319f1 in dispatch_command (command=COM_QUERY, thd=0x7fa364000b00, packet=0x7fa36400b1e1 "UPDATE t1 SET i=2 WHERE MATCH (f2) AGAINST ('bar' IN BOOLEAN MODE) ", packet_length=68, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1850
#18 0x000055e562130415 in do_command (thd=0x7fa364000b00) at /data/src/10.3/sql/sql_parse.cc:1395
#19 0x000055e562297e9c in do_handle_one_connection (connect=0x55e565f28d00) at /data/src/10.3/sql/sql_connect.cc:1402
#20 0x000055e562297c20 in handle_one_connection (arg=0x55e565f28d00) at /data/src/10.3/sql/sql_connect.cc:1308
#21 0x000055e56272b999 in pfs_spawn_thread (arg=0x55e565f75920) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#22 0x00007fa38761e494 in start_thread (arg=0x7fa3802f0700) at pthread_create.c:333
#23 0x00007fa385a0493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Query (0x7fa364014cd8): UPDATE t1 SET i=2 WHERE MATCH (f2) AGAINST ('bar' IN BOOLEAN MODE)
Connection ID (thread ID): 4
Status: NOT_KILLED