Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
-
MariaDB Enterprise 10.2.13 build 18409 bb_compatibility
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.
Attachments
Issue Links
- is duplicated by
-
MDEV-15328 MariaDB 10.2.13 Crashes upon CALL PROCEDURE PARAM LAST_INSERT_ID ()
- Closed
- relates to
-
MDEV-29320 MariaDB server crashes in Item::save_in_field() when executing stored procedure
- Closed