[MDEV-9985] UDF error return code causes DB to crash Created: 2016-04-25  Updated: 2016-06-24  Resolved: 2016-06-24

Status: Closed
Project: MariaDB Server
Component/s: Plugins, Triggers
Affects Version/s: 10.1.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Aaron Lager Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

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,



 Comments   
Comment by Elena Stepanova [ 2016-04-29 ]

Please provide an example of a statement showing which exactly function and in which context need to be executed. If there are any tables and other structures involved (as you mentioned triggers in the Component field), please paste the output of SHOW ... for all of them.

If possible, please also obtain an all threads' stack trace from a debug build.

Thanks.

Comment by Elena Stepanova [ 2016-05-27 ]

aaronl, any news on the issue?

Comment by Aaron Lager [ 2016-05-27 ]

Sorry I got wrapped up in work. I'll see if I can't get some of this on Tuesday.

Comment by Elena Stepanova [ 2016-06-24 ]

Please comment to re-open if you have further information on this issue.

Generated at Thu Feb 08 07:38:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.