Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.3.16
-
Windows Server 2012 R2 64Bit InnoDB
Description
Query uses :
ORDER BY MAX(servicedefectoroosevent = 'SERVICE_DEFECT') OVER (PARTITION BY deviceid)
190726 15:23:39 [ERROR] mysqld got exception 0xc0000005 ; |
This could be because you hit a bug. It is also possible that this binary |
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs |
|
We will try our best to scrape up some info that will hopefully help |
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail. |
|
Server version: 10.3.16-MariaDB |
key_buffer_size=134217728 |
read_buffer_size=67108864 |
max_used_connections=39 |
max_threads=65537 |
thread_count=14 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 266065 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x9e5688f128 |
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!filesort()[filesort.cc:205] |
mysqld.exe!create_sort_index()[sql_select.cc:22692] |
mysqld.exe!Window_funcs_sort::exec()[sql_window.cc:2994] |
mysqld.exe!Window_funcs_computation::exec()[sql_window.cc:3126] |
mysqld.exe!AGGR_OP::end_send()[sql_select.cc:27555] |
mysqld.exe!sub_select_postjoin_aggr()[sql_select.cc:19198] |
mysqld.exe!do_select()[sql_select.cc:19023] |
mysqld.exe!JOIN::exec_inner()[sql_select.cc:4043] |
mysqld.exe!JOIN::exec()[sql_select.cc:3838] |
mysqld.exe!mysql_select()[sql_select.cc:4244] |
mysqld.exe!st_select_lex_unit::exec()[sql_union.cc:1624] |
mysqld.exe!mysql_union()[sql_union.cc:41] |
mysqld.exe!handle_select()[sql_select.cc:390] |
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6281] |
mysqld.exe!mysql_execute_command()[sql_parse.cc:3818] |
mysqld.exe!mysql_parse()[sql_parse.cc:7829] |
mysqld.exe!dispatch_command()[sql_parse.cc:1860] |
mysqld.exe!do_command()[sql_parse.cc:1403] |
mysqld.exe!threadpool_process_request()[threadpool_common.cc:358] |
mysqld.exe!tp_callback()[threadpool_common.cc:186] |
ntdll.dll!RtlFreeUnicodeString()
|
ntdll.dll!RtlFreeUnicodeString()
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
Attachments
Issue Links
- duplicates
-
MDEV-15178 Filesort::make_sortorder: Assertion `pos->field != __null || pos->item != __null' failed | SIGSEGV in sortlength (on optimized builds)
- Closed