[MDEV-23463] Recursive procedure call ends with a crash in fil_page_compress instead of SQL error Created: 2020-08-12  Updated: 2020-10-06  Resolved: 2020-08-13

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB, Stored routines
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.1.48, 10.2.35, 10.3.26, 10.4.16, 10.5.7

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 1
Labels: debug, page_compression

Issue Links:
Relates
relates to MDEV-20307 Server crashes with thread_stack=1310... Closed

 Description   

Set to minor because even without the described failure the behavior is ugly, the procedure call throws ER_STACK_OVERRUN_NEED_MORE instead of the pretty ER_SP_RECURSION_LIMIT. However, without InnoDB compression it doesn't crash at least.

--source include/have_innodb.inc
 
 
 
CREATE TABLE t1 (a INT) ENGINE=InnoDB PAGE_COMPRESSED=1;
 
INSERT INTO t1 () VALUES (),();
 
--delimiter $
 
CREATE PROCEDURE sp() BEGIN ALTER TABLE t1 FORCE; CALL sp; END $
 
--delimiter ;
 
 
 
SET max_sp_recursion_depth= 40;
 
--error ER_SP_RECURSION_LIMIT,ER_STACK_OVERRUN_NEED_MORE
 
CALL sp;
 
 
 
# Cleanup
 
DROP PROCEDURE sp;
 
DROP TABLE t1;

10.2 01738d08

 
Program terminated with signal SIGSEGV, Segmentation fault.
 
#0  0x00005567c376104b in fil_page_compress (buf=0x0, out_buf=0x0, level=0, block_size=0, encrypted=false) at /data/src/10.2/storage/innobase/fil/fil0pagecompress.cc:85
 
85      {
 
[Current thread is 1 (Thread 0x7fc0aeec6700 (LWP 26573))]
 
 
 
Thread 1 (Thread 0x7fc0aeec6700 (LWP 26573)):
 
#0  0x00005567c376104b in fil_page_compress (buf=0x0, out_buf=0x0, level=0, block_size=0, encrypted=false) at /data/src/10.2/storage/innobase/fil/fil0pagecompress.cc:85
 
#1  0x00005567c36d9fd9 in buf_page_encrypt_before_write (space=0x7fc05c3386e0, bpage=0x7fc0af199a00, src_frame=0x7fc0af6b8000 "\030\215\344\322") at /data/src/10.2/storage/innobase/buf/buf0buf.cc:7444
 
#2  0x00005567c36e823d in buf_flush_write_block_low (bpage=0x7fc0af199a00, flush_type=BUF_FLUSH_SINGLE_PAGE, sync=false) at /data/src/10.2/storage/innobase/buf/buf0flu.cc:1065
 
#3  0x00005567c36e8954 in buf_flush_page (buf_pool=0x5567c53a8fb0, bpage=0x7fc0af199a00, flush_type=BUF_FLUSH_SINGLE_PAGE, sync=false) at /data/src/10.2/storage/innobase/buf/buf0flu.cc:1233
 
#4  0x00005567c36f26c9 in buf_flush_or_remove_page (buf_pool=0x5567c53a8fb0, bpage=0x7fc0af199a00, flush=true) at /data/src/10.2/storage/innobase/buf/buf0lru.cc:373
 
#5  0x00005567c36f2911 in buf_flush_or_remove_pages (buf_pool=0x5567c53a8fb0, id=43, observer=0x7fc05c32a180, first=0) at /data/src/10.2/storage/innobase/buf/buf0lru.cc:439
 
#6  0x00005567c36f2a9f in buf_flush_dirty_pages (buf_pool=0x5567c53a8fb0, id=43, observer=0x7fc05c32a180, first=0) at /data/src/10.2/storage/innobase/buf/buf0lru.cc:533
 
#7  0x00005567c36f2c2c in buf_LRU_flush_or_remove_pages (id=43, observer=0x7fc05c32a180, first=0) at /data/src/10.2/storage/innobase/buf/buf0lru.cc:565
 
#8  0x00005567c36efc3b in FlushObserver::flush (this=0x7fc05c32a180) at /data/src/10.2/storage/innobase/buf/buf0flu.cc:3768
 
#9  0x00005567c3598b1f in row_merge_build_indexes (trx=0x7fc0afa87140, old_table=0x7fc05c328150, new_table=0x7fc05c31af40, online=true, indexes=0x7fc05c31acb8, key_numbers=0x7fc05c31acc0, n_indexes=1, table=0x7fc05c27f520, add_cols=0x0, col_map=0x7fc05c31ace8, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7fc05c0f97f0, add_v=0x0, eval_table=0x7fc05c27f520) at /data/src/10.2/storage/innobase/row/row0merge.cc:5018
 
#10 0x00005567c349db6c in ha_innobase::inplace_alter_table (this=0x7fc05c2c1358, altered_table=0x7fc05c27f520, ha_alter_info=0x7fc0aee9d150) at /data/src/10.2/storage/innobase/handler/handler0alter.cc:6277
 
#11 0x00005567c30c5967 in handler::ha_inplace_alter_table (this=0x7fc05c2c1358, altered_table=0x7fc05c27f520, ha_alter_info=0x7fc0aee9d150) at /data/src/10.2/sql/handler.h:3790
 
#12 0x00005567c30baf7f in mysql_inplace_alter_table (thd=0x7fc05c000af0, table_list=0x7fc05c32bfc8, table=0x7fc05c270e90, altered_table=0x7fc05c27f520, ha_alter_info=0x7fc0aee9d150, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fc0aee9d1e0, alter_ctx=0x7fc0aee9d790) at /data/src/10.2/sql/sql_table.cc:7453
 
#13 0x00005567c30c0d55 in mysql_alter_table (thd=0x7fc05c000af0, new_db=0x7fc05c32bbf8 "test", new_name=0x0, create_info=0x7fc0aee9e3b0, table_list=0x7fc05c32bfc8, alter_info=0x7fc0aee9e300, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9622
 
#14 0x00005567c313d70a in Sql_cmd_alter_table::execute (this=0x7fc05c32c5e0, thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_alter.cc:333
 
#15 0x00005567c2ff038c in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5964
 
#16 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c32c5f8, thd=0x7fc05c000af0, nextp=0x7fc0aee9f68c) at /data/src/10.2/sql/sp_head.cc:3332
 
#17 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c32c638, thd=0x7fc05c000af0, nextp=0x7fc0aee9f68c, open_tables=false, instr=0x7fc05c32c5f8) at /data/src/10.2/sql/sp_head.cc:3095
 
#18 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c32c5f8, thd=0x7fc05c000af0, nextp=0x7fc0aee9f68c) at /data/src/10.2/sql/sp_head.cc:3248
 
#19 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c32b238, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#20 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c32b238, thd=0x7fc05c000af0, args=0x7fc05c322e30) at /data/src/10.2/sql/sp_head.cc:2202
 
#21 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c32b238) at /data/src/10.2/sql/sql_parse.cc:2946
 
#22 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#23 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c31d570, thd=0x7fc05c000af0, nextp=0x7fc0aeea061c) at /data/src/10.2/sql/sp_head.cc:3332
 
#24 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c31d5b0, thd=0x7fc05c000af0, nextp=0x7fc0aeea061c, open_tables=false, instr=0x7fc05c31d570) at /data/src/10.2/sql/sp_head.cc:3095
 
#25 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c31d570, thd=0x7fc05c000af0, nextp=0x7fc0aeea061c) at /data/src/10.2/sql/sp_head.cc:3248
 
#26 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c31beb8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#27 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c31beb8, thd=0x7fc05c000af0, args=0x7fc05c313cd0) at /data/src/10.2/sql/sp_head.cc:2202
 
#28 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c31beb8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#29 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#30 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c30e410, thd=0x7fc05c000af0, nextp=0x7fc0aeea15ac) at /data/src/10.2/sql/sp_head.cc:3332
 
#31 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c30e450, thd=0x7fc05c000af0, nextp=0x7fc0aeea15ac, open_tables=false, instr=0x7fc05c30e410) at /data/src/10.2/sql/sp_head.cc:3095
 
#32 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c30e410, thd=0x7fc05c000af0, nextp=0x7fc0aeea15ac) at /data/src/10.2/sql/sp_head.cc:3248
 
#33 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c30cd58, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#34 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c30cd58, thd=0x7fc05c000af0, args=0x7fc05c307460) at /data/src/10.2/sql/sp_head.cc:2202
 
#35 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c30cd58) at /data/src/10.2/sql/sql_parse.cc:2946
 
#36 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#37 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2fe9e0, thd=0x7fc05c000af0, nextp=0x7fc0aeea253c) at /data/src/10.2/sql/sp_head.cc:3332
 
#38 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2fea20, thd=0x7fc05c000af0, nextp=0x7fc0aeea253c, open_tables=false, instr=0x7fc05c2fe9e0) at /data/src/10.2/sql/sp_head.cc:3095
 
#39 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2fe9e0, thd=0x7fc05c000af0, nextp=0x7fc0aeea253c) at /data/src/10.2/sql/sp_head.cc:3248
 
#40 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2fd328, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#41 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2fd328, thd=0x7fc05c000af0, args=0x7fc05c2f4a10) at /data/src/10.2/sql/sp_head.cc:2202
 
#42 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2fd328) at /data/src/10.2/sql/sql_parse.cc:2946
 
#43 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#44 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2eef50, thd=0x7fc05c000af0, nextp=0x7fc0aeea34cc) at /data/src/10.2/sql/sp_head.cc:3332
 
#45 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2eef90, thd=0x7fc05c000af0, nextp=0x7fc0aeea34cc, open_tables=false, instr=0x7fc05c2eef50) at /data/src/10.2/sql/sp_head.cc:3095
 
#46 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2eef50, thd=0x7fc05c000af0, nextp=0x7fc0aeea34cc) at /data/src/10.2/sql/sp_head.cc:3248
 
#47 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2ed898, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#48 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2ed898, thd=0x7fc05c000af0, args=0x7fc05c2e5380) at /data/src/10.2/sql/sp_head.cc:2202
 
#49 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2ed898) at /data/src/10.2/sql/sql_parse.cc:2946
 
#50 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#51 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2dfac0, thd=0x7fc05c000af0, nextp=0x7fc0aeea445c) at /data/src/10.2/sql/sp_head.cc:3332
 
#52 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2dfb00, thd=0x7fc05c000af0, nextp=0x7fc0aeea445c, open_tables=false, instr=0x7fc05c2dfac0) at /data/src/10.2/sql/sp_head.cc:3095
 
#53 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2dfac0, thd=0x7fc05c000af0, nextp=0x7fc0aeea445c) at /data/src/10.2/sql/sp_head.cc:3248
 
#54 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2de408, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#55 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2de408, thd=0x7fc05c000af0, args=0x7fc05c2d6ec0) at /data/src/10.2/sql/sp_head.cc:2202
 
#56 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2de408) at /data/src/10.2/sql/sql_parse.cc:2946
 
#57 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#58 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2cffb0, thd=0x7fc05c000af0, nextp=0x7fc0aeea53ec) at /data/src/10.2/sql/sp_head.cc:3332
 
#59 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2cfff0, thd=0x7fc05c000af0, nextp=0x7fc0aeea53ec, open_tables=false, instr=0x7fc05c2cffb0) at /data/src/10.2/sql/sp_head.cc:3095
 
#60 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2cffb0, thd=0x7fc05c000af0, nextp=0x7fc0aeea53ec) at /data/src/10.2/sql/sp_head.cc:3248
 
#61 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2ce8f8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#62 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2ce8f8, thd=0x7fc05c000af0, args=0x7fc05c2c8340) at /data/src/10.2/sql/sp_head.cc:2202
 
#63 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2ce8f8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#64 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#65 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2c0970, thd=0x7fc05c000af0, nextp=0x7fc0aeea637c) at /data/src/10.2/sql/sp_head.cc:3332
 
#66 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2c09b0, thd=0x7fc05c000af0, nextp=0x7fc0aeea637c, open_tables=false, instr=0x7fc05c2c0970) at /data/src/10.2/sql/sp_head.cc:3095
 
#67 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2c0970, thd=0x7fc05c000af0, nextp=0x7fc0aeea637c) at /data/src/10.2/sql/sp_head.cc:3248
 
#68 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2bf2b8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#69 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2bf2b8, thd=0x7fc05c000af0, args=0x7fc05c2b6ba0) at /data/src/10.2/sql/sp_head.cc:2202
 
#70 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2bf2b8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#71 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#72 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2b12e0, thd=0x7fc05c000af0, nextp=0x7fc0aeea730c) at /data/src/10.2/sql/sp_head.cc:3332
 
#73 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2b1320, thd=0x7fc05c000af0, nextp=0x7fc0aeea730c, open_tables=false, instr=0x7fc05c2b12e0) at /data/src/10.2/sql/sp_head.cc:3095
 
#74 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2b12e0, thd=0x7fc05c000af0, nextp=0x7fc0aeea730c) at /data/src/10.2/sql/sp_head.cc:3248
 
#75 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2afc28, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#76 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2afc28, thd=0x7fc05c000af0, args=0x7fc05c2a7730) at /data/src/10.2/sql/sp_head.cc:2202
 
#77 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2afc28) at /data/src/10.2/sql/sql_parse.cc:2946
 
#78 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#79 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2a1e70, thd=0x7fc05c000af0, nextp=0x7fc0aeea829c) at /data/src/10.2/sql/sp_head.cc:3332
 
#80 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c2a1eb0, thd=0x7fc05c000af0, nextp=0x7fc0aeea829c, open_tables=false, instr=0x7fc05c2a1e70) at /data/src/10.2/sql/sp_head.cc:3095
 
#81 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2a1e70, thd=0x7fc05c000af0, nextp=0x7fc0aeea829c) at /data/src/10.2/sql/sp_head.cc:3248
 
#82 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2a07b8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#83 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2a07b8, thd=0x7fc05c000af0, args=0x7fc05c2982d0) at /data/src/10.2/sql/sp_head.cc:2202
 
#84 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2a07b8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#85 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#86 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c292a10, thd=0x7fc05c000af0, nextp=0x7fc0aeea922c) at /data/src/10.2/sql/sp_head.cc:3332
 
#87 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c292a50, thd=0x7fc05c000af0, nextp=0x7fc0aeea922c, open_tables=false, instr=0x7fc05c292a10) at /data/src/10.2/sql/sp_head.cc:3095
 
#88 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c292a10, thd=0x7fc05c000af0, nextp=0x7fc0aeea922c) at /data/src/10.2/sql/sp_head.cc:3248
 
#89 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c291358, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#90 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c291358, thd=0x7fc05c000af0, args=0x7fc05c28ba60) at /data/src/10.2/sql/sp_head.cc:2202
 
#91 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c291358) at /data/src/10.2/sql/sql_parse.cc:2946
 
#92 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#93 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c282a90, thd=0x7fc05c000af0, nextp=0x7fc0aeeaa1bc) at /data/src/10.2/sql/sp_head.cc:3332
 
#94 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c282ad0, thd=0x7fc05c000af0, nextp=0x7fc0aeeaa1bc, open_tables=false, instr=0x7fc05c282a90) at /data/src/10.2/sql/sp_head.cc:3095
 
#95 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c282a90, thd=0x7fc05c000af0, nextp=0x7fc0aeeaa1bc) at /data/src/10.2/sql/sp_head.cc:3248
 
#96 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2813d8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#97 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2813d8, thd=0x7fc05c000af0, args=0x7fc05c278db0) at /data/src/10.2/sql/sp_head.cc:2202
 
#98 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2813d8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#99 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#100 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2732f0, thd=0x7fc05c000af0, nextp=0x7fc0aeeab14c) at /data/src/10.2/sql/sp_head.cc:3332
 
#101 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c273330, thd=0x7fc05c000af0, nextp=0x7fc0aeeab14c, open_tables=false, instr=0x7fc05c2732f0) at /data/src/10.2/sql/sp_head.cc:3095
 
#102 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2732f0, thd=0x7fc05c000af0, nextp=0x7fc0aeeab14c) at /data/src/10.2/sql/sp_head.cc:3248
 
#103 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c271c38, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#104 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c271c38, thd=0x7fc05c000af0, args=0x7fc05c269830) at /data/src/10.2/sql/sp_head.cc:2202
 
#105 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c271c38) at /data/src/10.2/sql/sql_parse.cc:2946
 
#106 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#107 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c263f70, thd=0x7fc05c000af0, nextp=0x7fc0aeeac0dc) at /data/src/10.2/sql/sp_head.cc:3332
 
#108 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c263fb0, thd=0x7fc05c000af0, nextp=0x7fc0aeeac0dc, open_tables=false, instr=0x7fc05c263f70) at /data/src/10.2/sql/sp_head.cc:3095
 
#109 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c263f70, thd=0x7fc05c000af0, nextp=0x7fc0aeeac0dc) at /data/src/10.2/sql/sp_head.cc:3248
 
#110 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2628b8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#111 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2628b8, thd=0x7fc05c000af0, args=0x7fc05c25a760) at /data/src/10.2/sql/sp_head.cc:2202
 
#112 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2628b8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#113 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#114 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c254ea0, thd=0x7fc05c000af0, nextp=0x7fc0aeead06c) at /data/src/10.2/sql/sp_head.cc:3332
 
#115 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c254ee0, thd=0x7fc05c000af0, nextp=0x7fc0aeead06c, open_tables=false, instr=0x7fc05c254ea0) at /data/src/10.2/sql/sp_head.cc:3095
 
#116 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c254ea0, thd=0x7fc05c000af0, nextp=0x7fc0aeead06c) at /data/src/10.2/sql/sp_head.cc:3248
 
#117 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2537e8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#118 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2537e8, thd=0x7fc05c000af0, args=0x7fc05c24def0) at /data/src/10.2/sql/sp_head.cc:2202
 
#119 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2537e8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#120 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#121 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c244f70, thd=0x7fc05c000af0, nextp=0x7fc0aeeadffc) at /data/src/10.2/sql/sp_head.cc:3332
 
#122 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c244fb0, thd=0x7fc05c000af0, nextp=0x7fc0aeeadffc, open_tables=false, instr=0x7fc05c244f70) at /data/src/10.2/sql/sp_head.cc:3095
 
#123 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c244f70, thd=0x7fc05c000af0, nextp=0x7fc0aeeadffc) at /data/src/10.2/sql/sp_head.cc:3248
 
#124 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2438b8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#125 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2438b8, thd=0x7fc05c000af0, args=0x7fc05c23b1a0) at /data/src/10.2/sql/sp_head.cc:2202
 
#126 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2438b8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#127 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#128 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c2356e0, thd=0x7fc05c000af0, nextp=0x7fc0aeeaef8c) at /data/src/10.2/sql/sp_head.cc:3332
 
#129 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c235720, thd=0x7fc05c000af0, nextp=0x7fc0aeeaef8c, open_tables=false, instr=0x7fc05c2356e0) at /data/src/10.2/sql/sp_head.cc:3095
 
#130 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c2356e0, thd=0x7fc05c000af0, nextp=0x7fc0aeeaef8c) at /data/src/10.2/sql/sp_head.cc:3248
 
#131 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c234028, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#132 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c234028, thd=0x7fc05c000af0, args=0x7fc05c22bcc0) at /data/src/10.2/sql/sp_head.cc:2202
 
#133 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c234028) at /data/src/10.2/sql/sql_parse.cc:2946
 
#134 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#135 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c226400, thd=0x7fc05c000af0, nextp=0x7fc0aeeaff1c) at /data/src/10.2/sql/sp_head.cc:3332
 
#136 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c226440, thd=0x7fc05c000af0, nextp=0x7fc0aeeaff1c, open_tables=false, instr=0x7fc05c226400) at /data/src/10.2/sql/sp_head.cc:3095
 
#137 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c226400, thd=0x7fc05c000af0, nextp=0x7fc0aeeaff1c) at /data/src/10.2/sql/sp_head.cc:3248
 
#138 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c224d48, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#139 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c224d48, thd=0x7fc05c000af0, args=0x7fc05c21c8c0) at /data/src/10.2/sql/sp_head.cc:2202
 
#140 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c224d48) at /data/src/10.2/sql/sql_parse.cc:2946
 
#141 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#142 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c217000, thd=0x7fc05c000af0, nextp=0x7fc0aeeb0eac) at /data/src/10.2/sql/sp_head.cc:3332
 
#143 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c217040, thd=0x7fc05c000af0, nextp=0x7fc0aeeb0eac, open_tables=false, instr=0x7fc05c217000) at /data/src/10.2/sql/sp_head.cc:3095
 
#144 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c217000, thd=0x7fc05c000af0, nextp=0x7fc0aeeb0eac) at /data/src/10.2/sql/sp_head.cc:3248
 
#145 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c215948, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#146 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c215948, thd=0x7fc05c000af0, args=0x7fc05c20d660) at /data/src/10.2/sql/sp_head.cc:2202
 
#147 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c215948) at /data/src/10.2/sql/sql_parse.cc:2946
 
#148 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#149 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c207da0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb1e3c) at /data/src/10.2/sql/sp_head.cc:3332
 
#150 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c207de0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb1e3c, open_tables=false, instr=0x7fc05c207da0) at /data/src/10.2/sql/sp_head.cc:3095
 
#151 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c207da0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb1e3c) at /data/src/10.2/sql/sp_head.cc:3248
 
#152 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c2066e8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#153 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c2066e8, thd=0x7fc05c000af0, args=0x7fc05c1fe1b0) at /data/src/10.2/sql/sp_head.cc:2202
 
#154 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c2066e8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#155 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#156 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1f88f0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb2dcc) at /data/src/10.2/sql/sp_head.cc:3332
 
#157 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1f8930, thd=0x7fc05c000af0, nextp=0x7fc0aeeb2dcc, open_tables=false, instr=0x7fc05c1f88f0) at /data/src/10.2/sql/sp_head.cc:3095
 
#158 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1f88f0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb2dcc) at /data/src/10.2/sql/sp_head.cc:3248
 
#159 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1f7238, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#160 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1f7238, thd=0x7fc05c000af0, args=0x7fc05c1efed0) at /data/src/10.2/sql/sp_head.cc:2202
 
#161 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1f7238) at /data/src/10.2/sql/sql_parse.cc:2946
 
#162 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#163 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1e8cd0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb3d5c) at /data/src/10.2/sql/sp_head.cc:3332
 
#164 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1e8d10, thd=0x7fc05c000af0, nextp=0x7fc0aeeb3d5c, open_tables=false, instr=0x7fc05c1e8cd0) at /data/src/10.2/sql/sp_head.cc:3095
 
#165 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1e8cd0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb3d5c) at /data/src/10.2/sql/sp_head.cc:3248
 
#166 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1e7618, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#167 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1e7618, thd=0x7fc05c000af0, args=0x7fc05c1df280) at /data/src/10.2/sql/sp_head.cc:2202
 
#168 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1e7618) at /data/src/10.2/sql/sql_parse.cc:2946
 
#169 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#170 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1d97c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb4cec) at /data/src/10.2/sql/sp_head.cc:3332
 
#171 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1d9800, thd=0x7fc05c000af0, nextp=0x7fc0aeeb4cec, open_tables=false, instr=0x7fc05c1d97c0) at /data/src/10.2/sql/sp_head.cc:3095
 
#172 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1d97c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb4cec) at /data/src/10.2/sql/sp_head.cc:3248
 
#173 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1d8108, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#174 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1d8108, thd=0x7fc05c000af0, args=0x7fc05c1cfd00) at /data/src/10.2/sql/sp_head.cc:2202
 
#175 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1d8108) at /data/src/10.2/sql/sql_parse.cc:2946
 
#176 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#177 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1ca440, thd=0x7fc05c000af0, nextp=0x7fc0aeeb5c7c) at /data/src/10.2/sql/sp_head.cc:3332
 
#178 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1ca480, thd=0x7fc05c000af0, nextp=0x7fc0aeeb5c7c, open_tables=false, instr=0x7fc05c1ca440) at /data/src/10.2/sql/sp_head.cc:3095
 
#179 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1ca440, thd=0x7fc05c000af0, nextp=0x7fc0aeeb5c7c) at /data/src/10.2/sql/sp_head.cc:3248
 
#180 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1c8d88, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#181 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1c8d88, thd=0x7fc05c000af0, args=0x7fc05c1c1cb0) at /data/src/10.2/sql/sp_head.cc:2202
 
#182 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1c8d88) at /data/src/10.2/sql/sql_parse.cc:2946
 
#183 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#184 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1baf90, thd=0x7fc05c000af0, nextp=0x7fc0aeeb6c0c) at /data/src/10.2/sql/sp_head.cc:3332
 
#185 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1bafd0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb6c0c, open_tables=false, instr=0x7fc05c1baf90) at /data/src/10.2/sql/sp_head.cc:3095
 
#186 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1baf90, thd=0x7fc05c000af0, nextp=0x7fc0aeeb6c0c) at /data/src/10.2/sql/sp_head.cc:3248
 
#187 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1b98d8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#188 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1b98d8, thd=0x7fc05c000af0, args=0x7fc05c1b3090) at /data/src/10.2/sql/sp_head.cc:2202
 
#189 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1b98d8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#190 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#191 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1ab6c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb7b9c) at /data/src/10.2/sql/sp_head.cc:3332
 
#192 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1ab700, thd=0x7fc05c000af0, nextp=0x7fc0aeeb7b9c, open_tables=false, instr=0x7fc05c1ab6c0) at /data/src/10.2/sql/sp_head.cc:3095
 
#193 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1ab6c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb7b9c) at /data/src/10.2/sql/sp_head.cc:3248
 
#194 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1aa008, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#195 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1aa008, thd=0x7fc05c000af0, args=0x7fc05c1a1990) at /data/src/10.2/sql/sp_head.cc:2202
 
#196 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1aa008) at /data/src/10.2/sql/sql_parse.cc:2946
 
#197 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#198 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c19c0d0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb8b2c) at /data/src/10.2/sql/sp_head.cc:3332
 
#199 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c19c110, thd=0x7fc05c000af0, nextp=0x7fc0aeeb8b2c, open_tables=false, instr=0x7fc05c19c0d0) at /data/src/10.2/sql/sp_head.cc:3095
 
#200 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c19c0d0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb8b2c) at /data/src/10.2/sql/sp_head.cc:3248
 
#201 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c19aa18, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#202 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c19aa18, thd=0x7fc05c000af0, args=0x7fc05c192a70) at /data/src/10.2/sql/sp_head.cc:2202
 
#203 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c19aa18) at /data/src/10.2/sql/sql_parse.cc:2946
 
#204 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#205 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0fb6c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb9abc) at /data/src/10.2/sql/sp_head.cc:3332
 
#206 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0fb700, thd=0x7fc05c000af0, nextp=0x7fc0aeeb9abc, open_tables=false, instr=0x7fc05c0fb6c0) at /data/src/10.2/sql/sp_head.cc:3095
 
#207 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0fb6c0, thd=0x7fc05c000af0, nextp=0x7fc0aeeb9abc) at /data/src/10.2/sql/sp_head.cc:3248
 
#208 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0fa008, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#209 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0fa008, thd=0x7fc05c000af0, args=0x7fc05c0f3780) at /data/src/10.2/sql/sp_head.cc:2202
 
#210 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0fa008) at /data/src/10.2/sql/sql_parse.cc:2946
 
#211 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#212 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0ebd30, thd=0x7fc05c000af0, nextp=0x7fc0aeebaa4c) at /data/src/10.2/sql/sp_head.cc:3332
 
#213 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0ebd70, thd=0x7fc05c000af0, nextp=0x7fc0aeebaa4c, open_tables=false, instr=0x7fc05c0ebd30) at /data/src/10.2/sql/sp_head.cc:3095
 
#214 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0ebd30, thd=0x7fc05c000af0, nextp=0x7fc0aeebaa4c) at /data/src/10.2/sql/sp_head.cc:3248
 
#215 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0ea678, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#216 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0ea678, thd=0x7fc05c000af0, args=0x7fc05c0e2cf0) at /data/src/10.2/sql/sp_head.cc:2202
 
#217 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0ea678) at /data/src/10.2/sql/sql_parse.cc:2946
 
#218 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#219 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0dd430, thd=0x7fc05c000af0, nextp=0x7fc0aeebb9dc) at /data/src/10.2/sql/sp_head.cc:3332
 
#220 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0dd470, thd=0x7fc05c000af0, nextp=0x7fc0aeebb9dc, open_tables=false, instr=0x7fc05c0dd430) at /data/src/10.2/sql/sp_head.cc:3095
 
#221 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0dd430, thd=0x7fc05c000af0, nextp=0x7fc0aeebb9dc) at /data/src/10.2/sql/sp_head.cc:3248
 
#222 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0dbd78, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#223 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0dbd78, thd=0x7fc05c000af0, args=0x7fc05c113e50) at /data/src/10.2/sql/sp_head.cc:2202
 
#224 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0dbd78) at /data/src/10.2/sql/sql_parse.cc:2946
 
#225 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#226 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c10e590, thd=0x7fc05c000af0, nextp=0x7fc0aeebc96c) at /data/src/10.2/sql/sp_head.cc:3332
 
#227 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c10e5d0, thd=0x7fc05c000af0, nextp=0x7fc0aeebc96c, open_tables=false, instr=0x7fc05c10e590) at /data/src/10.2/sql/sp_head.cc:3095
 
#228 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c10e590, thd=0x7fc05c000af0, nextp=0x7fc0aeebc96c) at /data/src/10.2/sql/sp_head.cc:3248
 
#229 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c10ced8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#230 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c10ced8, thd=0x7fc05c000af0, args=0x7fc05c104550) at /data/src/10.2/sql/sp_head.cc:2202
 
#231 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c10ced8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#232 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#233 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0fec90, thd=0x7fc05c000af0, nextp=0x7fc0aeebd8fc) at /data/src/10.2/sql/sp_head.cc:3332
 
#234 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0fecd0, thd=0x7fc05c000af0, nextp=0x7fc0aeebd8fc, open_tables=false, instr=0x7fc05c0fec90) at /data/src/10.2/sql/sp_head.cc:3095
 
#235 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0fec90, thd=0x7fc05c000af0, nextp=0x7fc0aeebd8fc) at /data/src/10.2/sql/sp_head.cc:3248
 
#236 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0fd5d8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#237 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0fd5d8, thd=0x7fc05c000af0, args=0x7fc05c0d1f60) at /data/src/10.2/sql/sp_head.cc:2202
 
#238 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0fd5d8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#239 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#240 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0cae60, thd=0x7fc05c000af0, nextp=0x7fc0aeebe88c) at /data/src/10.2/sql/sp_head.cc:3332
 
#241 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0caea0, thd=0x7fc05c000af0, nextp=0x7fc0aeebe88c, open_tables=false, instr=0x7fc05c0cae60) at /data/src/10.2/sql/sp_head.cc:3095
 
#242 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0cae60, thd=0x7fc05c000af0, nextp=0x7fc0aeebe88c) at /data/src/10.2/sql/sp_head.cc:3248
 
#243 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0c97a8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#244 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0c97a8, thd=0x7fc05c000af0, args=0x7fc05c0c1650) at /data/src/10.2/sql/sp_head.cc:2202
 
#245 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0c97a8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#246 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#247 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0bb950, thd=0x7fc05c000af0, nextp=0x7fc0aeebf81c) at /data/src/10.2/sql/sp_head.cc:3332
 
#248 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0bb990, thd=0x7fc05c000af0, nextp=0x7fc0aeebf81c, open_tables=false, instr=0x7fc05c0bb950) at /data/src/10.2/sql/sp_head.cc:3095
 
#249 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0bb950, thd=0x7fc05c000af0, nextp=0x7fc0aeebf81c) at /data/src/10.2/sql/sp_head.cc:3248
 
#250 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0ba298, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#251 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0ba298, thd=0x7fc05c000af0, args=0x7fc05c0b1a00) at /data/src/10.2/sql/sp_head.cc:2202
 
#252 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0ba298) at /data/src/10.2/sql/sql_parse.cc:2946
 
#253 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#254 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c0ac140, thd=0x7fc05c000af0, nextp=0x7fc0aeec07ac) at /data/src/10.2/sql/sp_head.cc:3332
 
#255 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c0ac180, thd=0x7fc05c000af0, nextp=0x7fc0aeec07ac, open_tables=false, instr=0x7fc05c0ac140) at /data/src/10.2/sql/sp_head.cc:3095
 
#256 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c0ac140, thd=0x7fc05c000af0, nextp=0x7fc0aeec07ac) at /data/src/10.2/sql/sp_head.cc:3248
 
#257 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c0aaa88, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#258 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c0aaa88, thd=0x7fc05c000af0, args=0x7fc05c060220) at /data/src/10.2/sql/sp_head.cc:2202
 
#259 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c0aaa88) at /data/src/10.2/sql/sql_parse.cc:2946
 
#260 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#261 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c05a350, thd=0x7fc05c000af0, nextp=0x7fc0aeec173c) at /data/src/10.2/sql/sp_head.cc:3332
 
#262 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c05a390, thd=0x7fc05c000af0, nextp=0x7fc0aeec173c, open_tables=false, instr=0x7fc05c05a350) at /data/src/10.2/sql/sp_head.cc:3095
 
#263 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c05a350, thd=0x7fc05c000af0, nextp=0x7fc0aeec173c) at /data/src/10.2/sql/sp_head.cc:3248
 
#264 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c058c98, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#265 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c058c98, thd=0x7fc05c000af0, args=0x7fc05c04edb0) at /data/src/10.2/sql/sp_head.cc:2202
 
#266 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c058c98) at /data/src/10.2/sql/sql_parse.cc:2946
 
#267 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#268 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c04b120, thd=0x7fc05c000af0, nextp=0x7fc0aeec26cc) at /data/src/10.2/sql/sp_head.cc:3332
 
#269 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c04b160, thd=0x7fc05c000af0, nextp=0x7fc0aeec26cc, open_tables=false, instr=0x7fc05c04b120) at /data/src/10.2/sql/sp_head.cc:3095
 
#270 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c04b120, thd=0x7fc05c000af0, nextp=0x7fc0aeec26cc) at /data/src/10.2/sql/sp_head.cc:3248
 
#271 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c049a68, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#272 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c049a68, thd=0x7fc05c000af0, args=0x7fc05c042b50) at /data/src/10.2/sql/sp_head.cc:2202
 
#273 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c049a68) at /data/src/10.2/sql/sql_parse.cc:2946
 
#274 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#275 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c184d10, thd=0x7fc05c000af0, nextp=0x7fc0aeec365c) at /data/src/10.2/sql/sp_head.cc:3332
 
#276 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c184d50, thd=0x7fc05c000af0, nextp=0x7fc0aeec365c, open_tables=false, instr=0x7fc05c184d10) at /data/src/10.2/sql/sp_head.cc:3095
 
#277 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c184d10, thd=0x7fc05c000af0, nextp=0x7fc0aeec365c) at /data/src/10.2/sql/sp_head.cc:3248
 
#278 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c183658, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#279 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c183658, thd=0x7fc05c000af0, args=0x7fc05c088e50) at /data/src/10.2/sql/sp_head.cc:2202
 
#280 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c183658) at /data/src/10.2/sql/sql_parse.cc:2946
 
#281 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#282 0x00005567c2f3c9bc in sp_instr_stmt::exec_core (this=0x7fc05c1878a0, thd=0x7fc05c000af0, nextp=0x7fc0aeec45ec) at /data/src/10.2/sql/sp_head.cc:3332
 
#283 0x00005567c2f3c035 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fc05c1878e0, thd=0x7fc05c000af0, nextp=0x7fc0aeec45ec, open_tables=false, instr=0x7fc05c1878a0) at /data/src/10.2/sql/sp_head.cc:3095
 
#284 0x00005567c2f3c66d in sp_instr_stmt::execute (this=0x7fc05c1878a0, thd=0x7fc05c000af0, nextp=0x7fc0aeec45ec) at /data/src/10.2/sql/sp_head.cc:3248
 
#285 0x00005567c2f376c7 in sp_head::execute (this=0x7fc05c1861e8, thd=0x7fc05c000af0, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1326
 
#286 0x00005567c2f398b4 in sp_head::execute_procedure (this=0x7fc05c1861e8, thd=0x7fc05c000af0, args=0x7fc05c005430) at /data/src/10.2/sql/sp_head.cc:2202
 
#287 0x00005567c2fe63fa in do_execute_sp (thd=0x7fc05c000af0, sp=0x7fc05c1861e8) at /data/src/10.2/sql/sql_parse.cc:2946
 
#288 0x00005567c2feec7d in mysql_execute_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:5564
 
#289 0x00005567c2ff530d in mysql_parse (thd=0x7fc05c000af0, rawbuf=0x7fc05c012458 "CALL sp", length=7, parser_state=0x7fc0aeec5610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733
 
#290 0x00005567c2fe3639 in dispatch_command (command=COM_QUERY, thd=0x7fc05c000af0, packet=0x7fc05c095911 "CALL sp", packet_length=7, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
 
#291 0x00005567c2fe20b4 in do_command (thd=0x7fc05c000af0) at /data/src/10.2/sql/sql_parse.cc:1377
 
#292 0x00005567c31382a1 in do_handle_one_connection (connect=0x5567c58ad720) at /data/src/10.2/sql/sql_connect.cc:1336
 
#293 0x00005567c313800c in handle_one_connection (arg=0x5567c58ad720) at /data/src/10.2/sql/sql_connect.cc:1241
 
#294 0x00005567c394ed62 in pfs_spawn_thread (arg=0x5567c57fa750) at /data/src/10.2/storage/perfschema/pfs.cc:1869
 
#295 0x00007fc0b67fd4a4 in start_thread (arg=0x7fc0aeec6700) at pthread_create.c:456
 
#296 0x00007fc0b4931d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

Reproducible for me on 10.2-10.4 debug builds.
Not reproducible on 10.5. Not reproducible on non-debug builds.

 Comments   
Comment by Marko Mäkelä [ 2020-08-13 ]

In MariaDB Server 10.5, MDEV-19747 deprecated and ignored the setting innodb_log_optimize_ddl, which we had introduced in MDEV-16809 so that this problematic functionality that was inherited from MySQL 5.7 could be disabled.

The test will not crash if innodb_log_optimize_ddl=off is set.

The biggest culprit is some debug code that will allocate 128KiB from a stack frame:

(gdb) set $top=$sp
 
(gdb) faas p $sp-$top

10.2 182e2d4a6ce502ca623ba0baf358cac271e9e425

 
#4  0x00005555560d0274 in fil_page_compress (buf=<optimized out>, 
    out_buf=0x7fffa0088000 "ޭ\276", <incomplete sequence \357>, 
    level=<optimized out>, block_size=4096, encrypted=<optimized out>)
 
    at /mariadb/10.2o/storage/innobase/fil/fil0pagecompress.cc:251
 
$5 = 768
 
#5  0x00005555560493cd in buf_page_encrypt_before_write (
 
    space=0x7fffa01ff4f0, bpage=0x7ffff180b200, 
    src_frame=0x7ffff18c0000 "ThIE")
 
    at /mariadb/10.2o/storage/innobase/buf/buf0buf.cc:7440
 
$6 = 131920


	/* Verify that page can be decompressed */
 
	{
 
		page_t tmp_buf[UNIV_PAGE_SIZE_MAX];
 
		page_t page[UNIV_PAGE_SIZE_MAX];
 
		memcpy(page, out_buf, srv_page_size);
 
		ut_ad(fil_page_decompress(tmp_buf, page));
 
		ut_ad(!buf_page_is_corrupted(false, page, univ_page_size,
 
					     NULL));
 
	}
 
#endif /* UNIV_DEBUG */

That debug code could very well use heap-allocated memory. Even more, such code only serves to unnecessarily slow down the debug build. We should have enough test coverage for reading back page_compressed pages from data files, either after buffer pool eviction or after server restart.

Earlier, MDEV-20307 removed a similar useless debug check in fil_space_encrypt().

Comment by Marko Mäkelä [ 2020-08-13 ]

In 10.4, the useless debug check exists in both fil_page_compress_for_non_full_crc32() and fil_page_compress(). In my optimized debug build, only 128KiB instead of 256KiB were allocated from the stack, but I could imagine that it could be 256KiB with different build options.

After I removed the useless check, the test passed for me with the maximum setting

SET max_sp_recursion_depth= 255;

in 10.2 and 10.4.

Comment by Marko Mäkelä [ 2020-08-13 ]

I merged the fix (and other unmerged changes) up to 10.4, so that I was able to remove the debug code also for innodb_checksum_algorithm=full_crc32, which was introduced in MDEV-12026.

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