Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
10.3 186a998b5b932851d64666c92e3062
mysqld: /home/alice/git/10.3/sql/handler.h:3060: int handler::ha_rnd_init(bool): Assertion `inited==NONE || (inited==RND && scan)' failed.
|
180704 9:16:56 [ERROR] mysqld got signal 6 ;
|
Server version: 10.3.9-MariaDB-debug-log
|
|
Thread pointer: 0x62a00007e270
|
|
stack_bottom = 0x7fd3982ffe40 thread_stack 0x49000
|
/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7fd3c78b9077]
|
/home/alice/git/10.3/sql/mysqld(my_print_stacktrace+0xb3)[0x55f499c4ba64]
|
mysys/stacktrace.c:269(my_print_stacktrace)[0x55f498b8fa8d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fd3c6725390]
|
linux/raise.c:54(__GI_raise)[0x7fd3c5ade428]
|
stdlib/abort.c:91(__GI_abort)[0x7fd3c5ae002a]
|
assert/assert.c:92(__assert_fail_base)[0x7fd3c5ad6bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd3c5ad6c82]
|
sql/handler.h:3061(handler::ha_rnd_init(bool))[0x55f49843d714]
|
sql/handler.cc:2980(handler::ha_rnd_init_with_error(bool))[0x55f498ba6bc3]
|
sql/opt_range.cc:1623(QUICK_ROR_INTERSECT_SELECT::init_ror_merged_scan(bool, st_mem_root*))[0x55f498ed361d]
|
sql/opt_range.cc:1644(QUICK_ROR_INTERSECT_SELECT::reset())[0x55f498ed3891]
|
sql/sql_select.cc:20188(join_init_read_record(st_join_table*))[0x55f4985ebb37]
|
sql/sql_select.cc:20136(join_init_quick_read_record(st_join_table*))[0x55f4985eb2e5]
|
sql/sql_select.cc:19268(sub_select(JOIN*, st_join_table*, bool))[0x55f4985e585d]
|
sql/sql_select.cc:19491(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f4985e6e12]
|
sql/sql_select.cc:19310(sub_select(JOIN*, st_join_table*, bool))[0x55f4985e6094]
|
sql/sql_select.cc:18811(do_select(JOIN*, Procedure*))[0x55f4985e3eb5]
|
sql/sql_select.cc:4021(JOIN::exec_inner())[0x55f4985837dd]
|
sql/sql_select.cc:3816(JOIN::exec())[0x55f498581522]
|
sql/sql_select.cc:4222(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*))[0x55f4985848f4]
|
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f498560139]
|
sql/sql_parse.cc:6542(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f4984e5c8a]
|
sql/sql_parse.cc:3765(mysql_execute_command(THD*))[0x55f4984d449d]
|
sql/sql_parse.cc:8073(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f4984ee598]
|
sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f4984c927f]
|
sql/sql_parse.cc:1392(do_command(THD*))[0x55f4984c6417]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55f498815872]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x55f49881524f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd3c671b6ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd3c5bb041d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x62b000007288): SELECT DISTINCT STRAIGHT_JOIN alias1.`col_int_key` AS field1, alias2.`pk` AS field2, alias2.`col_int_key` AS field3, alias2.`col_int_key` AS field4, alias1.`pk` AS field5 FROM E AS alias1 LEFT OUTER JOIN E AS alias2 ON alias1.`col_int_key` = alias2.`col_int_key` WHERE alias2.`pk` > alias1.`pk` GROUP BY field1, field2, field3, field4, field5 HAVING field1 > 5 ORDER BY field1 /* QNO 20285 CON_ID 16 */
|
Connection ID (thread ID): 16
|
Status: NOT_KILLED
|
Attachments
Issue Links
- duplicates
-
MDEV-6453 Assertion `inited==NONE || (inited==RND && scan)' failed in handler::ha_rnd_init(bool) with InnoDB, joins, AND/OR conditions
- Closed