Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
180116 12:23:24 [ERROR] mysqld got signal 11 ;
|
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.1.19-MariaDB-enterprise
|
key_buffer_size=67108864
|
read_buffer_size=131072
|
max_used_connections=14
|
max_threads=302
|
thread_count=5
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 728870 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7f7c8bb99008
|
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...
|
stack_bottom = 0x7f889612acb0 thread_stack 0x40000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55de13fd5eee]
|
/usr/sbin/mysqld(handle_fatal_signal+0x2d5)[0x55de13af90f5]
|
/lib64/libpthread.so.0(+0xf5e0)[0x7f889bd7a5e0]
|
/usr/sbin/mysqld(_ZN4JOIN19shrink_join_buffersEP13st_join_tableyy+0x3d)[0x55de139a6d7d]
|
/usr/sbin/mysqld(_ZN10JOIN_CACHE12alloc_bufferEv+0x1c2)[0x55de13a6e692]
|
/usr/sbin/mysqld(_ZN10JOIN_CACHE4initEb+0x60)[0x55de13a6eeb0]
|
/usr/sbin/mysqld(_ZN17JOIN_CACHE_HASHED4initEb+0x44)[0x55de13a710a4]
|
/usr/sbin/mysqld(_Z33check_join_cache_usage_for_tablesP4JOINyj+0x745)[0x55de139baf35]
|
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1509)[0x55de139cbae9]
|
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x2f)[0x55de139cd60f]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x8f)[0x55de139cd74f]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x245)[0x55de139ce2b5]
|
/usr/sbin/mysqld(+0x429291)[0x55de1396d291]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5f8f)[0x55de139795bf]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x352)[0x55de1397cf52]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x25db)[0x55de1398042b]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x169)[0x55de13980ca9]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x18a)[0x55de13a4780a]
|
/usr/sbin/mysqld(handle_one_connection+0x40)[0x55de13a479e0]
|
/lib64/libpthread.so.0(+0x7e25)[0x7f889bd72e25]
|
/lib64/libc.so.6(clone+0x6d)[0x7f889a19134d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f7c7f1e4020): select * from grc_db.incdnt_cause where incdnt_num in (select incdnt_num from (SELECT grc_mig.f_ELW_INCDNT_NUM(summ.error_id) incdnt_num, grc_mig.f_ELW_CAUSE_NUM(ROOTCAUSE_CATEGORY2), SUBSTRING(ROOTCAUSE_DESCIPTION,1,1000), substring(description,1,1000), 'Y' FROM grc_mig.elw_error_event_summary summ left join grc_mig.elw_error_event_impact impt on summ.ERROR_ID = impt.ERROR_ID LEFT JOIN (SELECT ERROR_ID, GROUP_CONCAT(DESCRIPTION SEPARATOR ';') AS DESCRIPTION FROM GRC_MIG.ELW_ACTIONITEM_DETAILS WHERE TYPE = 2 GROUP BY ERROR_ID) as details on summ.ERROR_ID = details.ERROR_ID WHERE (error_type = 4 and LOSSIN_SGD > 50000) or (error_type <> 4 and LOSSIN_SGD > 10000) or ror_id in (0,9,1) and ERROR_INITIATOR not in ('weizhongmun','%farahfoo%','carolinesenglh','ryantanweihiong','kokyuencheang','ryanangyiheng') and summ.error_id not in (233285607, 286668596, 286668597, 289170081, 350952945, 362266862, -1701, -1698, 246477401, 450342668) and summ.ERROR_STATUS <> 'Draft'and rootcause_category2 <> 0 and CASE WHEN ROOTCAUSE_CATEGORY1 <> ROOTCAUSE_CATEGORY2 and ROOTCAUSE_CATEGORY2 <> 24 THEN 'R2P'else 'R2S' end = 'R2P' and summ.error_id <> 246477401) a)
|
Connection ID (thread ID): 7998
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=on,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
|
More details are attached with Ticket like output of EXPLAIN ..FORMAT=JSON and Table structures.
Attachments
Issue Links
- relates to
-
MDEV-4626 Setting join_buffer_size causes join buffer not to be used
- Open