H5W3
当前位置:H5W3 > 问答 > 正文

mariadb 意外crash ,自动重启,什么原因?

/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.

回答

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

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

未经允许不得转载:H5W3 » mariadb 意外crash ,自动重启,什么原因?

赞 (0)

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址