Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
10.0.17
-
Windows Server 2012 R2, 64x, 12gb of ram
Description
When attempting to execute this query
SELECT SQL_NO_CACHE data1, data2, data3 FROM table WHERE MATCH (index) AGAINST('"phrase"' IN BOOLEAN MODE) AND data2 > 0 ORDER BY data2 DESC |
if any results are found, the entire mysql instance simply crashes.
There is no crash log, note it only crashes IF you find results. Table cooloation is utf8 unicode
My table is 2gb large with 6.3m rows.
EDIT:
I was able to produce a stack trace
Thread pointer: 0x0x1fe234c088
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
mysqld.exe!maria_ft_boolean_read_next()[ma_ft_boolean_search.c:833]
|
mysqld.exe!ha_maria::ft_read()[ha_maria.cc:3270]
|
mysqld.exe!FT_SELECT::get_next()[opt_range.h:1042]
|
mysqld.exe!find_all_keys()[filesort.cc:745]
|
mysqld.exe!filesort()[filesort.cc:298]
|
mysqld.exe!create_sort_index()[sql_select.cc:20760]
|
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3051]
|
mysqld.exe!JOIN::exec()[sql_select.cc:2372]
|
mysqld.exe!mysql_select()[sql_select.cc:3312]
|
mysqld.exe!handle_select()[sql_select.cc:373]
|
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5258]
|
mysqld.exe!mysql_execute_command()[sql_parse.cc:2546]
|
mysqld.exe!mysql_parse()[sql_parse.cc:6518]
|
mysqld.exe!dispatch_command()[sql_parse.cc:1303]
|
mysqld.exe!do_command()[sql_parse.cc:1003]
|
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
|
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
|
KERNEL32.DLL!VirtualUnlock()
|
ntdll.dll!LdrResolveDelayLoadedAPI()
|
ntdll.dll!RtlFreeUnicodeString()
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|