[MDEV-15545] crash 11 during evaluating an expression Created: 2018-03-12  Updated: 2022-08-17  Resolved: 2018-05-16

Status: Closed
Project: MariaDB Server
Component/s: Stored routines
Affects Version/s: 10.3
Fix Version/s: 10.2.14, 10.3.6

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Oleksandr Byelkin
Resolution: Duplicate Votes: 0
Labels: None
Environment:

MariaDB Enterprise 10.2.13 build 18409 bb_compatibility


Attachments: Text File core_22457.txt     Text File parse_4.txt    
Issue Links:
Duplicate
is duplicated by MDEV-15328 MariaDB 10.2.13 Crashes upon CALL PRO... Closed
Relates
relates to MDEV-29320 MariaDB server crashes in Item::save_... Closed

 Description   

Crash happened during call a SP in oracle compatibility mode

 	
Server version: 10.2.13-MariaDB-log
key_buffer_size=67108864
read_buffer_size=131072
max_used_connections=113
max_threads=2002
thread_count=120
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4465362 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x561a47b90008
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 = 0x7f3030fa2d00 thread_stack 0x40000
(my_addr_resolve failure: fork)
/usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x56192e5813fe]
/usr/sbin/mysqld(handle_fatal_signal+0x355) [0x56192e016fb5]
/lib64/libpthread.so.0(+0xf5e0) [0x7f44cabac5e0]
/usr/sbin/mysqld(THD::sp_eval_expr(Field*, Item**)+0x4b) [0x56192ddd3dcb]
/usr/sbin/mysqld(sp_rcontext::set_variable(THD*, unsigned int, Item**)+0x23) [0x56192dde0f83]
/usr/sbin/mysqld(sp_instr_set::exec_core(THD*, unsigned int*)+0x2f) [0x56192ddd9d3f]
/usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x305) [0x56192ddd9835]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x83e) [0x56192ddd562e]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x73d) [0x56192ddd675d]
/usr/sbin/mysqld(+0x55bbd9) [0x56192de51bd9]
/usr/sbin/mysqld(+0x55d906) [0x56192de53906]
/usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x56192de54100]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x14fb) [0x56192de59c0b]
/usr/sbin/mysqld(Prepared_statement::execute(String*, bool)+0x4de) [0x56192de741ee]
/usr/sbin/mysqld(+0x57e39f) [0x56192de7439f]
/usr/sbin/mysqld(+0x57f1ff) [0x56192de751ff]
/usr/sbin/mysqld(mysqld_stmt_execute(THD*, char*, unsigned int)+0x27) [0x56192de75287]
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x14e8) [0x56192de63f48]
/usr/sbin/mysqld(do_command(THD*)+0x149) [0x56192de657a9]
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x56192df29eba]
/usr/sbin/mysqld(handle_one_connection+0x3d) [0x56192df29fdd]
/usr/sbin/mysqld(+0x8c59ed) [0x56192e1bb9ed]
/lib64/libpthread.so.0(+0x7e25) [0x7f44caba4e25]
/lib64/libc.so.6(clone+0x6d) [0x7f44c91f734d]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x561a567a0020): call PKG_CALCULATION.CALC_RUNNING_BALANCE_TXN('SG','ANSP','20280731','EODATD','201803121308168697','201803121309168754',NULL)
Connection ID (thread ID): 518783
Status: NOT_KILLED
 
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=on,mrr_cost_based=on,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_grouping_derived=on
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file at /mariadb/data/

thread-apply output of the core is attached.



 Comments   
Comment by Oleksandr Byelkin [ 2018-03-12 ]

If the procedure was called with argument which content uncachable function then it is duplicate of https://jira.mariadb.org/browse/MDEV-15328 . could you check it?

Comment by Oleksandr Byelkin [ 2018-03-12 ]

MDEV-15328 fix was just pushed to 10.2 (JFYI)

Comment by Oleksandr Byelkin [ 2018-03-28 ]

Then it is better (IMHO) to close it as a duplicate (our best guess)

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