Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.13
-
ubutnu 14.04lts, maria 10.1.13
Description
When using the STOMP UDF plugin from http://www.mysqludf.org/ code located here: https://github.com/mysqludf/lib_mysqludf_stomp if the return code is not "success", then the DB crashes.
EDIT: To be more specific, if the host name lookup fails for the message queue server, then it crashes. We didn't have a host entry for our new message broker, and kept crashing the DB until we added that entry.
Here is the syslog output:
Apr 22 20:59:08 avc2-wus1-db07 mysqld: 160422 20:59:08 [ERROR] mysqld got signal 11 ;
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: This could be because you hit a bug. It is also possible that this binary
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: We will try our best to scrape up some info that will hopefully help
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: diagnose the problem, but since we have already crashed,
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: something is definitely wrong and this may fail.
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Server version: 10.0.24-MariaDB-1~trusty-wsrep
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: key_buffer_size=18874368
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: read_buffer_size=2097152
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: max_used_connections=35
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: max_threads=502
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: thread_count=16
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: It is possible that mysqld could use up to
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2084749 K bytes of memory
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Thread pointer: 0x0x7f8b4962a008
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Attempting backtrace. You can use the following information to find out
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: where mysqld died. If you see no messages after this, something went
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: terribly wrong...
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: stack_bottom = 0x7f8c32cc9dc0 thread_stack 0x48000
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7f8c3571644e]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x457)[0x7f8c352455f7]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7f8c339e4340]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN11udf_handler10fix_fieldsEP3THDP17Item_result_fieldjPP4Item+0x224)[0x7f8c352b06e4]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN13Item_udf_func10fix_fieldsEP3THDPP4Item+0x25)[0x7f8c352bb9a5]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z12setup_fieldsP3THDPP4ItemR4ListIS1_E17enum_mark_columnsPS5_b+0x17c)[0x7f8c3506928c]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z8mysql_doP3THDR4ListI4ItemE+0x1f)[0x7f8c3538ba8f]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x66c5)[0x7f8c350bbe45]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x7f8c3536df45]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x83)[0x7f8c353758b3]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x155)[0x7f8c35375ce5]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x786)[0x7f8c35372766]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN7sp_head15execute_triggerEP3THDPK19st_mysql_lex_stringS4_P13st_grant_info+0x195)[0x7f8c35372bc5]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x132)[0x7f8c35152202]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x10bb)[0x7f8c3538a6ab]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3377)[0x7f8c350b8af7]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(+0x415feb)[0x7f8c350bffeb]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1fa1)[0x7f8c350c25f1]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x28f)[0x7f8c350c32ff]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x32b)[0x7f8c3519342b]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7f8c35193510]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /usr/sbin/mysqld(+0x74a69d)[0x7f8c353f469d]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7f8c339dc182]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f8c330ff47d]
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Trying to get some variables.
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Some pointers may be invalid and cause the dump to abort.
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Query (0x7f8bd067e020): is an invalid pointer
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Connection ID (thread ID): 10211
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: Status: NOT_KILLED
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld:
|
Apr 22 20:59:08 avc2-wus1-db07 mysqld: 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,
|