mariadb 意外crash ，自动重启，什么原因？

Question

/lib64/libpthread.so.0(+0x7dd5)[0x7fce09bdbdd5]
/lib64/libc.so.6(clone+0x6d)[0x7fce08199ead]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fb2fb01c5f0): is an invalid pointer
Connection ID (thread ID): 95752809
Status: KILL_CONNECTION

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=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_w
ith_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination
=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on

The manual page at http://dev.mysql.com/doc/mysq... contains
information that should help you find out what is causing the crash.

We think the query pointer is invalid, but we will try to print it anyway.

Answer 1

这个,你是不是用了 mariadb 的测试版本或者最新版本啊,感觉你这是触发了 bug,你到官网的 bug 平台上去看下有没有同类型的反馈以及解决访问, 建议你安装下稳定的长期支持版本看看

Answer 2

找到原因了，好像是窗口函数的问题，row_number() over(partition by a.aging order by sum(b.repay_sum) desc) 排名，去掉就没问题了，还在进一步排查中