Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11.7
-
None
-
Windows 11 64Bit Intel
Description
Hi.
An exception Error by "Sorry, we probably made a mistake, and this is a bug." thing.
mini dump extracted.
Plus, when you investigate the issue,
also consider that from H/W failure that memory error which one of my headache to check.
Thank you in advance.
server.dll!my_uca_scanner_next_no_contractions_utf8mb4()[ctype-uca-scanner_next.inl:148]
|
server.dll!my_uca_strnncollsp_onelevel_no_contractions_utf8mb4()[ctype-uca.inl:235]
|
server.dll!my_uca_strnncollsp_no_contractions_utf8mb4()[ctype-uca.inl:282]
|
server.dll!cmp_data()[rem0cmp.cc:294]
|
server.dll!cmp_dtuple_rec_with_match_low()[rem0cmp.cc:405]
|
server.dll!row_search_mvcc()[row0sel.cc:5067]
|
server.dll!ha_innobase::index_read()[ha_innodb.cc:9037]
|
server.dll!handler::ha_index_read_map()[handler.cc:3520]
|
server.dll!ha_partition::handle_unordered_scan_next_partition()[ha_partition.cc:7834]
|
server.dll!handler::ha_index_read_map()[handler.cc:3520]
|
server.dll!join_read_key2()[sql_select.cc:23025]
|
server.dll!sub_select()[sql_select.cc:22336]
|
server.dll!evaluate_join_record()[sql_select.cc:22570]
|
server.dll!sub_select()[sql_select.cc:22339]
|
server.dll!evaluate_join_record()[sql_select.cc:22570]
|
server.dll!sub_select()[sql_select.cc:22378]
|
server.dll!do_select()[sql_select.cc:21862]
|
server.dll!JOIN::exec_inner()[sql_select.cc:4910]
|
server.dll!mysql_select()[sql_select.cc:5168]
|
server.dll!handle_select()[sql_select.cc:588]
|
server.dll!mysql_execute_command()[sql_parse.cc:4756]
|
server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
|
server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
|
server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
|
server.dll!sp_head::execute()[sp_head.cc:1463]
|
server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
|
server.dll!do_execute_sp()[sql_parse.cc:3060]
|
server.dll!Sql_cmd_call::execute()[sql_parse.cc:3302]
|
server.dll!mysql_execute_command()[sql_parse.cc:6104]
|
server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
|
server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
|
server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
|
server.dll!sp_head::execute()[sp_head.cc:1463]
|
server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
|
server.dll!do_execute_sp()[sql_parse.cc:3060]
|
server.dll!Sql_cmd_call::execute()[sql_parse.cc:3302]
|
server.dll!mysql_execute_command()[sql_parse.cc:6104]
|
server.dll!Prepared_statement::execute()[sql_prepare.cc:5273]
|
server.dll!Prepared_statement::execute_loop()[sql_prepare.cc:4674]
|
server.dll!mysql_sql_stmt_execute()[sql_prepare.cc:3701]
|
server.dll!mysql_execute_command()[sql_parse.cc:3997]
|
server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3923]
|
server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3646]
|
server.dll!sp_instr_stmt::execute()[sp_head.cc:3827]
|
server.dll!sp_head::execute()[sp_head.cc:1463]
|
server.dll!sp_head::execute_procedure()[sp_head.cc:2479]
|
server.dll!Event_job_data::execute()[event_data_objects.cc:1482]
|
server.dll!event_worker_thread()[event_scheduler.cc:268]
|
server.dll!pfs_spawn_thread()[pfs.cc:2204]
|
server.dll!pthread_start()[my_winthread.c:62]
|
ucrtbase.dll!_recalloc()
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
Attachments
Activity
Can you let me know any of specific funtion name?
for example, that utf conversion function name since have no idea what the code pointing at due to there is non of code conversion in SQL statements.
And...
Have no idea that what statement of procedure launches
since there is tons of prcedure executing(which no explitcit utf conversion.).
Give me some function name and any name that you expecting from dump file.
With the stack frame, I have investigate already, no function indicates I'm using. (so report to you guys.)
I cannot see it from the stack trace. But look in the error log after the stack trace, there should be the query that caused the crash, that should help.
Then...the stacktrace sequence seems okay?
Isn't there any non-sense path you can see? For example, impossible to get called between each link.
If stacktrace it self seems not weird,you can close the issue. Let's treat the issue as H/W failure then.
Thank you everytime.
analyze.txt
Stacktrace seems OK. The attached analyze.txt I made out of memory dump is mostly the same, and contains exception record so we know that exception happened while trying to read from address 0xC000 , exact location of the crash
server!my_uca_scanner_set_weight+0x8 [inlined in server!my_uca_scanner_next_no_contractions_utf8mb4+0xd1]:
|
00007ffc`948d9781 498901 mov qword ptr [r9],rax ds:00000022`a1df7770={server!nochar (00007ffc`950eae6c)}
|
and thread context.
But the memory dump is minimal, and mostly has stack in it, and no heap. So it does not have the SQL query . Error log does have the SQL query.
Thanks for the sharing.
Only last question is that what do you think about 'server!nochar (00007ffc`950eae6c)'?
Is that kinda "not a charactor to convert" a cause of the crash? like null pointer?
or
Any possiblity of a table partition broken should be cause of the crash?
server!nochar (00007ffc`950eae6c) refers to this array
static const uint16 nochar[]= {0,0}; |
Do you have any more information you can provide? Stack trace shows that you had an EVENT that used dynamic SQL — EXECUTE — to CALL a stored procedure that selected from a partitioned InnoDB table and at the end if crashed in the utf8mb4 string comparison code.
Can you provide the code for the event and the stored procedure, and the said table definition?