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
-
Yet another one, similar to Matthias'es, but without versioning and with the stack trace:
--source include/have_partition.inc
# Cleanup
10.3 462d6893
mysqld: /data/src/10.3/sql/handler.h:3105: int handler::ha_rnd_end(): Assertion `inited==RND' failed.
190518 17:15:37 [ERROR] mysqld got signal 6 ;
#7 0x00007f5e5755af12 in __GI___assert_fail (assertion=0x563a7bfcaebd "inited==RND", file=0x563a7bfcae5f "/data/src/10.3/sql/handler.h", line=3105, function=0x563a7bfcf310 <handler::ha_rnd_end()::__PRETTY_FUNCTION__> "int handler::ha_rnd_end()") at assert.c:101
#8 0x0000563a7b3e252e in handler::ha_rnd_end (this=0x7f5e40097148) at /data/src/10.3/sql/handler.h:3105
#9 0x0000563a7bed5064 in ha_partition::rnd_end (this=0x7f5e400968e8) at /data/src/10.3/sql/ha_partition.cc:4999
#10 0x0000563a7bed4dd0 in ha_partition::rnd_init (this=0x7f5e400968e8, scan=true) at /data/src/10.3/sql/ha_partition.cc:4933
#11 0x0000563a7b439a2e in handler::ha_rnd_init (this=0x7f5e400968e8, scan=true) at /data/src/10.3/sql/handler.h:3098
#12 0x0000563a7b77ba8f in handler::ha_rnd_init_with_error (this=0x7f5e400968e8, scan=true) at /data/src/10.3/sql/handler.cc:3029
#13 0x0000563a7b8f7289 in init_read_record (info=0x7f5e517566f0, thd=0x7f5e40000b00, table=0x7f5e40095ca0, select=0x0, filesort=0x0, use_record_cache=1, print_error=true, disable_rr_cache=false) at /data/src/10.3/sql/records.cc:298
#14 0x0000563a7b55cf96 in copy_data_between_tables (thd=0x7f5e40000b00, from=0x7f5e40095ca0, to=0x7f5e40171a10, create=..., ignore=false, order_num=0, order=0x0, copied=0x7f5e517570d8, deleted=0x7f5e517570e0, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7f5e517578d0) at /data/src/10.3/sql/sql_table.cc:10388
#15 0x0000563a7b55b3eb in mysql_alter_table (thd=0x7f5e40000b00, new_db=0x7f5e400051d8, new_name=0x7f5e40005598, create_info=0x7f5e517584c0, table_list=0x7f5e400128e0, alter_info=0x7f5e51758400, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9899
#16 0x0000563a7b5e279d in Sql_cmd_alter_table::execute (this=0x7f5e40012f30, thd=0x7f5e40000b00) at /data/src/10.3/sql/sql_alter.cc:488
#17 0x0000563a7b483ea7 in mysql_execute_command (thd=0x7f5e40000b00) at /data/src/10.3/sql/sql_parse.cc:6292
#18 0x0000563a7b4891b8 in mysql_parse (thd=0x7f5e40000b00, rawbuf=0x7f5e40012808 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f5e517595f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8098
#19 0x0000563a7b4761fa in dispatch_command (command=COM_QUERY, thd=0x7f5e40000b00, packet=0x7f5e40008c61 "ALTER TABLE t1 FORCE", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1858
#20 0x0000563a7b474c1d in do_command (thd=0x7f5e40000b00) at /data/src/10.3/sql/sql_parse.cc:1403
#21 0x0000563a7b5dcd65 in do_handle_one_connection (connect=0x563a7d7b20e0) at /data/src/10.3/sql/sql_connect.cc:1402
#22 0x0000563a7b5dcadc in handle_one_connection (arg=0x563a7d7b20e0) at /data/src/10.3/sql/sql_connect.cc:1308
#23 0x0000563a7beb2650 in pfs_spawn_thread (arg=0x563a7d7ccfe0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#24 0x00007f5e590cf4a4 in start_thread (arg=0x7f5e5175a700) at pthread_create.c:456
#25 0x00007f5e57617d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97