[MDEV-14657] Crash while trying to find matching condition handler Created: 2017-12-14  Updated: 2020-08-25  Resolved: 2018-07-18

Status: Closed
Project: MariaDB Server
Component/s: Stored routines
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Valerii Kravchuk Assignee: Alexander Barkov
Resolution: Cannot Reproduce Votes: 0
Labels: need_feedback

Issue Links:
Relates
relates to MDEV-14603 signal 11 with short stacktrace Closed

 Description   

The following crash was noted while running MariaDB custom build from bb-10.2-compatibility branch (commit 565c1f592103f5bf40cfa2fbfa994fbe6339c208 tarbuildnum 17025):

Thread pointer: 0x7f35980008c8
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 = 0x7f36a5e33d70 thread_stack 0x40000
(my_addr_resolve failure: fork)
/usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x55c5f7a7144e]
/usr/sbin/mysqld(handle_fatal_signal+0x30d) [0x55c5f75006dd]
/lib64/libpthread.so.0(+0xf5e0) [0x7f4bc33d25e0]
/usr/sbin/mysqld(sp_pcontext::find_handler(Sql_condition_identity const&) const+0x1c) [0x55c5f72cb37c]
/usr/sbin/mysqld(sp_rcontext::handle_sql_condition(THD*, unsigned int*, sp_instr const*)+0x413) [0x55c5f72cd243]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x8f1) [0x55c5f72c1a51]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x737) [0x55c5f72c2a77]
/usr/sbin/mysqld(+0x55a48b) [0x55c5f733d48b]
/usr/sbin/mysqld(+0x55c286) [0x55c5f733f286]
/usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x55c5f733fa80]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x134d) [0x55c5f73453dd]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x36) [0x55c5f72bdca6]
/usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0x99) [0x55c5f72c58e9]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x205) [0x55c5f72c5ee5]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x7ee) [0x55c5f72c194e]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x737) [0x55c5f72c2a77]
/usr/sbin/mysqld(+0x55a48b) [0x55c5f733d48b]
/usr/sbin/mysqld(+0x55c286) [0x55c5f733f286]
/usr/sbin/mysqld(Sql_cmd_call::execute(THD*)+0x90) [0x55c5f733fa80]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x134d) [0x55c5f73453dd]
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)+0x2fe) [0x55c5f734d0fe]
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x2025) [0x55c5f7350085]
/usr/sbin/mysqld(do_command(THD*)+0x149) [0x55c5f7350c89]
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x55c5f74155aa]
/usr/sbin/mysqld(handle_one_connection+0x3d) [0x55c5f74156cd]
/lib64/libpthread.so.0(+0x7e25) [0x7f4bc33cae25]
/lib64/libc.so.6(clone+0x6d) [0x7f4bc1a1d34d]
 
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f359a3565e8): p_l_c( NAME_CONST('p_BusinessDate',TIMESTAMP'2017-11-25 17:38:35'))
Connection ID (thread ID): 78710
Status: NOT_KILLED

It is not clear how to reproduce, code of p_l_c() procedure (name changed) and several other related stored procedures can not be shared here.



 Comments   
Comment by Elena Stepanova [ 2017-12-24 ]

See also MDEV-14603, it's likely to be related.

Comment by Alexander Barkov [ 2018-03-07 ]

Elena, Valerii, can we close this bug report?

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