Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.30
-
Ubuntu Xenial 64 bit.
Description
Since upgrading to 10.1.30 we've encountered a crash. Attached is the mysql.log containing the backtrace.
Attachments
Issue Links
- duplicates
-
-
- Closed
-
Activity
From the error log:
180102 2:07:12 [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.30-MariaDB-1~xenial
|
key_buffer_size=1048576
|
read_buffer_size=1048576
|
max_used_connections=5
|
max_threads=102
|
thread_count=6
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 525365 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7f75d1032008
|
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 = 0x7f75e0c5001f thread_stack 0x48400
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55770103cffe]
|
/usr/sbin/mysqld(handle_fatal_signal+0x2f5)[0x557700b85725]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f75e29fa390]
|
/usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x557700ae4b00]
|
/usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x557700ae4be3]
|
/usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb50)[0x557700a45940]
|
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xc3)[0x557700a4b4e3]
|
/usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0xa5)[0x5577009cc4b5]
|
/usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x1ba)[0x5577009ccf1a]
|
/usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5577009e5977]
|
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0xa6)[0x557700a478d6]
|
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x29)[0x557700a4b449]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x8f1)[0x557700a4bdf1]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x139)[0x557700a4bfb9]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x83fb)[0x5577009f6d1b]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x557700c86985]
|
/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x83)[0x557700c8dad3]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x557700c8e085]
|
/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ae)[0x557700c89e5e]
|
/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x3b8)[0x557700c8b378]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x673a)[0x5577009f505a]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x557700c86985]
|
/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x83)[0x557700c8dad3]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x557700c8e085]
|
/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ae)[0x557700c89e5e]
|
/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x739)[0x557700c8b6f9]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x673a)[0x5577009f505a]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x557700c86985]
|
/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x83)[0x557700c8dad3]
|
/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x557700c8e085]
|
/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ae)[0x557700c89e5e]
|
/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x3b8)[0x557700c8b378]
|
/usr/sbin/mysqld(_ZN14Event_job_data7executeEP3THDb+0xa43)[0x557700ab2d53]
|
/usr/sbin/mysqld(_ZN19Event_worker_thread3runEP3THDP28Event_queue_element_for_exec+0xe7)[0x557700cbef57]
|
/usr/sbin/mysqld(event_worker_thread+0x4d)[0x557700cbeffd]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f75e29f06ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f75e209b3dd]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f758504e020): insert into pai_db_log(log_name,log_text) select log_name,concat(log_cnt,' Rows pending in UX table') log_text from ( select 'beacon_post_service_entries' log_name,count(*) log_cnt from pai_beacon_service_entries_ux ) as x
|
Connection ID (thread ID): 10016
|
Status: NOT_KILLED
|
This is a duplicate of MDEV-14857. Please track further progress there.
Please attach your cnf file(s) and provide the output of
Thanks.