[MDEV-15080] ASAN heap-use-after-free in Query_tables_list::set_query_tables_list / Sp_handler::sp_cache_package_routine or crash in MDL_key::mdl_namespace Created: 2018-01-26  Updated: 2018-01-27  Resolved: 2018-01-26

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Duplicate Votes: 0
Labels: None
Environment:

bb-10.2-compatibility ec1d5905c54f98f2c1e671a1567d4a42f25e4b5f (build 18296)


Issue Links:
Duplicate
duplicates MDEV-15070 Crash when doing a CREATE VIEW inside... Closed
Relates
relates to MDEV-14949 Crash signal 11 in prepared statement... Closed
relates to MDEV-14950 crash 11 in check, if sql command is ... Closed
relates to MDEV-15028 Crash in open_tables() while calling ... Closed
relates to MDEV-15040 Crash in st_select_lex::cleanup() in ... Closed

 Description   

bb-10.2-compatibility ec1d5905c5

==3493==ERROR: AddressSanitizer: heap-use-after-free on address 0x625000197990 at pc 0x55b5688facf6 bp 0x7f4b2b36ca10 sp 0x7f4b2b36ca08
READ of size 188 at 0x625000197990 thread T28
    #0 0x55b5688facf5 in Query_tables_list::set_query_tables_list(Query_tables_list*) /data/src/bb-10.2-compatibility/sql/sql_lex.h:1419
    #1 0x55b5688d82da in LEX::reset_n_backup_query_tables_list(Query_tables_list*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:3670
    #2 0x55b568808d14 in open_system_tables_for_read(THD*, TABLE_LIST*, Open_tables_backup*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:8570
    #3 0x55b56931ab77 in open_proc_table_for_read(THD*, Open_tables_backup*) /data/src/bb-10.2-compatibility/sql/sp.cc:482
    #4 0x55b56931c2c9 in Sp_handler::db_find_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:676
    #5 0x55b56931cd66 in Sp_handler::db_find_and_cache_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:747
    #6 0x55b56932a072 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2720
    #7 0x55b56932a556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #8 0x55b56932aa41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #9 0x55b569329c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #10 0x55b5687eb0d1 in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3202
    #11 0x55b5687eeb5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #12 0x55b5687f25a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #13 0x55b56876b23e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #14 0x55b568913475 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
    #15 0x55b568926d21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #16 0x55b568756c9d in sp_instr_stmt::exec_core(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
    #17 0x55b56875574a in sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
    #18 0x55b568756567 in sp_instr_stmt::execute(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
    #19 0x55b56874a00f in sp_head::execute(THD*, bool) /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
    #20 0x55b56874ec4b in sp_head::execute_procedure(THD*, List<Item>*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
    #21 0x55b568911eaf in do_execute_sp /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
    #22 0x55b5689137f4 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
    #23 0x55b568926d21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #24 0x55b56893123c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
    #25 0x55b56890c217 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
    #26 0x55b568909258 in do_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
    #27 0x55b568c49595 in do_handle_one_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
    #28 0x55b568c48faa in handle_one_connection /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
    #29 0x55b5696c86df in pfs_spawn_thread /data/src/bb-10.2-compatibility/storage/perfschema/pfs.cc:1862
    #30 0x7f4b47b4d493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
    #31 0x7f4b45f3393e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
 
0x625000197990 is located 144 bytes inside of 8268-byte region [0x625000197900,0x62500019994c)
freed by thread T28 here:
    #0 0x7f4b47db7527 in __interceptor_free (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x54527)
    #1 0x55b56a00520d in free_memory /data/src/bb-10.2-compatibility/mysys/safemalloc.c:279
    #2 0x55b56a00486e in sf_free /data/src/bb-10.2-compatibility/mysys/safemalloc.c:197
    #3 0x55b569fd38c8 in my_free /data/src/bb-10.2-compatibility/mysys/my_malloc.c:224
    #4 0x55b569fb500f in free_root /data/src/bb-10.2-compatibility/mysys/my_alloc.c:416
    #5 0x55b568744546 in sp_head::operator delete(void*, unsigned long) /data/src/bb-10.2-compatibility/sql/sp_head.cc:550
    #6 0x55b568747f44 in sp_head::~sp_head() /data/src/bb-10.2-compatibility/sql/sp_head.cc:890
    #7 0x55b5688ca7d3 in lex_end_stage1(LEX*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:813
    #8 0x55b5688ca3fa in lex_end(LEX*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:784
    #9 0x55b568747fea in sp_package::LexList::cleanup() /data/src/bb-10.2-compatibility/sql/sp_head.cc:898
    #10 0x55b5687454ef in sp_package::~sp_package() /data/src/bb-10.2-compatibility/sql/sp_head.cc:626
    #11 0x55b5687457c7 in sp_package::~sp_package() /data/src/bb-10.2-compatibility/sql/sp_head.cc:632
    #12 0x55b5687416c8 in hash_free_sp_head /data/src/bb-10.2-compatibility/sql/sp_cache.cc:287
    #13 0x55b569f7b666 in my_hash_delete /data/src/bb-10.2-compatibility/mysys/hash.c:626
    #14 0x55b568741ac0 in sp_cache::remove(sp_head*) (/data/bld/bb-10.2-compatibility-asan/bin/mysqld+0xbd9ac0)
    #15 0x55b568741543 in sp_cache_flush_obsolete(sp_cache**, sp_head**) /data/src/bb-10.2-compatibility/sql/sp_cache.cc:236
    #16 0x55b56932a004 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2715
    #17 0x55b56932a556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #18 0x55b56932aa41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #19 0x55b569329c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #20 0x55b5687eb0d1 in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3202
    #21 0x55b5687eeb5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #22 0x55b5687f25a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #23 0x55b56876b23e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #24 0x55b568913475 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
    #25 0x55b568926d21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #26 0x55b568756c9d in sp_instr_stmt::exec_core(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
    #27 0x55b56875574a in sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
    #28 0x55b568756567 in sp_instr_stmt::execute(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
    #29 0x55b56874a00f in sp_head::execute(THD*, bool) /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
 
previously allocated by thread T28 here:
    #0 0x7f4b47db773f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
    #1 0x55b56a004010 in sf_malloc /data/src/bb-10.2-compatibility/mysys/safemalloc.c:118
    #2 0x55b569fd3000 in my_malloc /data/src/bb-10.2-compatibility/mysys/my_malloc.c:101
    #3 0x55b569fb406e in alloc_root /data/src/bb-10.2-compatibility/mysys/my_alloc.c:243
    #4 0x55b5686d26c9 in Sql_alloc::operator new(unsigned long, st_mem_root*) /data/src/bb-10.2-compatibility/sql/sql_list.h:46
    #5 0x55b56874f91d in sp_head::reset_lex(THD*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:2425
    #6 0x55b568e77c77 in ORAparse(THD*) /data/src/bb-10.2-compatibility/sql/sql_yacc_ora.yy:3684
    #7 0x55b56893d7a4 in parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:9997
    #8 0x55b56931d359 in sp_compile /data/src/bb-10.2-compatibility/sql/sp.cc:833
    #9 0x55b56931dc18 in Sp_handler::db_load_routine(THD*, Database_qualified_name const*, sp_head**, unsigned long long, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_sp_chistics const&, AUTHID const&, long long, long long, sp_package*, Stored_program_creation_ctx*) const /data/src/bb-10.2-compatibility/sql/sp.cc:958
    #10 0x55b56931cb28 in Sp_handler::db_find_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:728
    #11 0x55b56931cd66 in Sp_handler::db_find_and_cache_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:747
    #12 0x55b56932a072 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2720
    #13 0x55b56932a556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #14 0x55b56932aa41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #15 0x55b569329c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #16 0x55b5687eb0d1 in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3202
    #17 0x55b5687eeb5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #18 0x55b5687f25a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #19 0x55b56876b23e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #20 0x55b568913475 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
    #21 0x55b568926d21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #22 0x55b56893123c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
    #23 0x55b56890c217 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
    #24 0x55b568909258 in do_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
    #25 0x55b568c49595 in do_handle_one_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
    #26 0x55b568c48faa in handle_one_connection /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
    #27 0x55b5696c86df in pfs_spawn_thread /data/src/bb-10.2-compatibility/storage/perfschema/pfs.cc:1862
    #28 0x7f4b47b4d493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
 
Thread T28 created by T0 here:
    #0 0x7f4b47d86bba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
    #1 0x55b5696c8ca7 in spawn_thread_v1 /data/src/bb-10.2-compatibility/storage/perfschema/pfs.cc:1912
    #2 0x55b5686b173f in inline_mysql_thread_create /data/src/bb-10.2-compatibility/include/mysql/psi/mysql_thread.h:1239
    #3 0x55b5686c6644 in create_thread_to_handle_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/mysqld.cc:6447
    #4 0x55b5686c6d49 in create_new_thread /data/src/bb-10.2-compatibility/sql/mysqld.cc:6517
    #5 0x55b5686c7d5a in handle_connections_sockets() /data/src/bb-10.2-compatibility/sql/mysqld.cc:6792
    #6 0x55b5686c5b91 in mysqld_main(int, char**) /data/src/bb-10.2-compatibility/sql/mysqld.cc:6066
    #7 0x55b5686afc6f in main /data/src/bb-10.2-compatibility/sql/main.cc:25
    #8 0x7f4b45e6b2b0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202b0)
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/bb-10.2-compatibility/sql/sql_lex.h:1419 Query_tables_list::set_query_tables_list(Query_tables_list*)
Shadow bytes around the buggy address:
  0x0c4a8002aee0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8002aef0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8002af00: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8002af10: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8002af20: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
=>0x0c4a8002af30: fd fd[fd]fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8002af40: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8002af50: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8002af60: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8002af70: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8002af80: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
Shadow byte legend (one shadow byte represents 8 application bytes):
  Addressable:           00
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
  Heap right redzone:      fb
  Freed heap region:       fd
  Stack left redzone:      f1
  Stack mid redzone:       f2
  Stack right redzone:     f3
  Stack partial redzone:   f4
  Stack after return:      f5
  Stack use after scope:   f8
  Global redzone:          f9
  Global init order:       f6
  Poisoned by user:        f7
  Contiguous container OOB:fc
  ASan internal:           fe
==3493==ABORTING

--source include/have_innodb.inc
 
SET sql_mode= ORACLE;
 
--delimiter $$
CREATE PACKAGE pkg1 AS
  PROCEDURE pr1;
END $$
 
CREATE PACKAGE BODY pkg1 AS
  PROCEDURE pr1() IS BEGIN END pr1;
END $$
 
CREATE PACKAGE pkg2 AS
  PROCEDURE pr2;
  PROCEDURE pr3;
  FUNCTION func RETURN VARCHAR(30);
END $$
 
CREATE PACKAGE BODY pkg2 AS
  PROCEDURE pr2 IS
  BEGIN
    pkg1.pr1;
    pr3;   
  END pr2;
 
  PROCEDURE pr3 IS BEGIN END pr3;
  FUNCTION func() RETURN VARCHAR(30) IS BEGIN RETURN NULL; END func;
END $$
 
--delimiter ;
 
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12);
 
--connect (con2,localhost,root,,test)
SET sql_mode= ORACLE;
 
--send
	CALL pkg2.pr2();
 
--connection default
CREATE OR REPLACE VIEW v AS SELECT pkg2.func() FROM t1;
SELECT pkg2.func() FROM t1;
 
# Cleanup
--connection con2
--reap
--disconnect con2
--connection default
DROP PACKAGE pkg1;
DROP PACKAGE pkg2;
DROP VIEW v;
DROP TABLE t1;

Note: The test case fails for me pretty much all the time, but it is non-deterministic, run with --repeat if it doesn't fail right away; increasing the number of rows in the table might also help.

On a non-ASAN debug build the same test case causes a crash:

bb-10.2-compatibility ec1d5905c54f

#3  <signal handler called>
#4  0x000055dfd8bec4ce in MDL_key::mdl_namespace (this=0x8f8f8f8f8f8f8faf) at /data/src/bb-10.2-compatibility/sql/mdl.h:320
#5  0x000055dfd8bdf395 in open_and_process_routine (thd=0x7f81f8000b00, prelocking_ctx=0x7f81f803e090, rt=0x8f8f8f8f8f8f8f8f, prelocking_strategy=0x7f8244510cd0, has_prelocking_list=false, ot_ctx=0x7f8244510bc0, need_prelocking=0x7f8244510b5f, routine_modifies_data=0x7f8244510b60) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:3121
#6  0x000055dfd8be1037 in open_tables (thd=0x7f81f8000b00, options=..., start=0x7f8244510c38, counter=0x7f8244510c54, flags=0, prelocking_strategy=0x7f8244510cd0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
#7  0x000055dfd8be268a in open_and_lock_tables (thd=0x7f81f8000b00, options=..., tables=0x0, derived=true, flags=0, prelocking_strategy=0x7f8244510cd0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
#8  0x000055dfd8ba5d2d in open_and_lock_tables (thd=0x7f81f8000b00, tables=0x0, derived=true, flags=0) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#9  0x000055dfd8c5ace7 in Sql_cmd_call::execute (this=0x7f81f8031398, thd=0x7f81f8000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#10 0x000055dfd8c64e3d in mysql_execute_command (thd=0x7f81f8000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#11 0x000055dfd8b9cb26 in sp_instr_stmt::exec_core (this=0x7f81f8031750, thd=0x7f81f8000b00, nextp=0x7f82445121e4) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#12 0x000055dfd8b9c111 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f81f8031798, thd=0x7f81f8000b00, nextp=0x7f82445121e4, open_tables=false, instr=0x7f81f8031750) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#13 0x000055dfd8b9c7d1 in sp_instr_stmt::execute (this=0x7f81f8031750, thd=0x7f81f8000b00, nextp=0x7f82445121e4) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#14 0x000055dfd8b9685f in sp_head::execute (this=0x7f81f802fae8, thd=0x7f81f8000b00, merge_da_on_success=true) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#15 0x000055dfd8b99090 in sp_head::execute_procedure (this=0x7f81f802fae8, thd=0x7f81f8000b00, args=0x7f81f8005530) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#16 0x000055dfd8c5a414 in do_execute_sp (thd=0x7f81f8000b00, sp=0x7f81f802fae8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#17 0x000055dfd8c5aed8 in Sql_cmd_call::execute (this=0x7f81f80117e0, thd=0x7f81f8000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#18 0x000055dfd8c64e3d in mysql_execute_command (thd=0x7f81f8000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#19 0x000055dfd8c6991c in mysql_parse (thd=0x7f81f8000b00, rawbuf=0x7f81f8011438 "CALL pkg2.pr2()", length=15, parser_state=0x7f8244514200, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#20 0x000055dfd8c57609 in dispatch_command (command=COM_QUERY, thd=0x7f81f8000b00, packet=0x7f81f8008c51 "CALL pkg2.pr2()", packet_length=15, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#21 0x000055dfd8c55f4d in do_command (thd=0x7f81f8000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#22 0x000055dfd8da6b94 in do_handle_one_connection (connect=0x55dfdb7a2ac0) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#23 0x000055dfd8da6921 in handle_one_connection (arg=0x55dfdb7a2ac0) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#24 0x000055dfd91fac88 in pfs_spawn_thread (arg=0x55dfdb7c1e30) at /data/src/bb-10.2-compatibility/storage/perfschema/pfs.cc:1862
#25 0x00007f825a75f494 in start_thread (arg=0x7f8244515700) at pthread_create.c:333
#26 0x00007f8258b4593f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Elena Stepanova [ 2018-01-27 ]

Variations of stack traces / crash reports which came from the test set on the same build, and all disappeared after the bugfix for MDEV-15070:

No.1, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x0000564eb0d6c8d5 in Sql_cmd_call::execute (this=this@entry=0x7fa9a8110868, thd=thd@entry=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3131
#4  0x0000564eb0d6d1e7 in Sql_cmd_call::execute (this=0x7fa9a8110868, thd=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#5  0x0000564eb0d72722 in mysql_execute_command (thd=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#6  0x0000564eb0cf2c04 in sp_instr_stmt::exec_core (this=0x7fa9a8054f58, thd=<optimized out>, nextp=0x7fa9f2c88134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#7  0x0000564eb0cfa1a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7fa9a8054fa0, thd=thd@entry=0x7fa9a80009a8, nextp=nextp@entry=0x7fa9f2c88134, open_tables=open_tables@entry=false, instr=instr@entry=0x7fa9a8054f58) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#8  0x0000564eb0cfa7ec in sp_instr_stmt::execute (this=0x7fa9a8054f58, thd=0x7fa9a80009a8, nextp=0x7fa9f2c88134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#9  0x0000564eb0cf64cd in sp_head::execute (this=0x7fa9a810ec30, thd=0x7fa9a80009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#10 0x0000564eb0cf753e in sp_head::execute_procedure (this=0x7fa9a810ec30, thd=0x7fa9a80009a8, args=0x7fa90000001c) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#11 0x0000564eb0d6b31d in do_execute_sp (thd=0x7fa9a80009a8, sp=0x7fa9a81108b0, sp@entry=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#12 0x0000564eb0d6c976 in Sql_cmd_call::execute (this=this@entry=0x7fa9a800fba8, thd=thd@entry=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#13 0x0000564eb0d6d1e7 in Sql_cmd_call::execute (this=0x7fa9a800fba8, thd=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#14 0x0000564eb0d72722 in mysql_execute_command (thd=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#15 0x0000564eb0d7904d in mysql_parse (thd=0x7fa9a80009a8, rawbuf=<optimized out>, length=70, parser_state=0x7fa9f2c8a260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#16 0x0000564eb0d7c555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fa9a80009a8, packet=packet@entry=0x7fa9a8006fa9 " CALL pkg.pr1('2012-12-12')  /* QNO 343 CON_ID 17 */ ", packet_length=packet_length@entry=72, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#17 0x0000564eb0d7ce23 in do_command (thd=0x7fa9a80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#18 0x0000564eb0e45594 in do_handle_one_connection (connect=connect@entry=0x564ebb2ce118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#19 0x0000564eb0e45734 in handle_one_connection (arg=0x564ebb2ce118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#20 0x00007fab5008a494 in start_thread (arg=0x7fa9f2c8b700) at pthread_create.c:333
#21 0x00007fab4e47093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.1, RelWithDebInfo, logfile

180125  5:07:04 [ERROR] mysqld got signal 11 ;
...
stack_bottom = 0x7fa9f2c8ae98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x564eb1406639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x564eb0f31d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fab500940c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x5478d5)[0x564eb0d6c8d5]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x87)[0x564eb0d6d1e7]
mysys/stacktrace.c:268(my_print_stacktrace)[0x564eb0d72722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x564eb0cf2c04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x564eb0cfa1a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x564eb0cfa7ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x564eb0cf64cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x564eb0cf753e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x564eb0d6b31d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x564eb0d6c976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x564eb0d6d1e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x564eb0d72722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564eb0d7904d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564eb0d7c555]
sql/sql_parse.cc:1385(do_command(THD*))[0x564eb0d7ce23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x564eb0e45594]
sql/sql_connect.cc:1243(handle_one_connection)[0x564eb0e45734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fab5008a494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fab4e47093f]

No.2, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x00007f3bc70dffcf in raise () from /lib/x86_64-linux-gnu/libc.so.6
#4  0x00007f3bc70e13fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
#5  0x00007f3bc79f60ad in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#6  0x00007f3bc79f4066 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#7  0x00007f3bc79f40b1 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#8  0x00007f3bc79f4b8f in __cxa_pure_virtual () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#9  0x000055b889873cf4 in cmp_type (this=0x7f3a1031e048) at /data/src/bb-10.2-compatibility/sql/item.h:832
#10 sp_eval_expr (thd=thd@entry=0x7f3a100009a8, result_item=result_item@entry=0x7f3a116977d8, result_field=0x7f3a11697700, expr_item_ptr=expr_item_ptr@entry=0x7f3a1031e120) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:418
#11 0x000055b88987fa24 in sp_rcontext::set_variable (this=0x7f3a116bcd10, thd=0x7f3a100009a8, idx=0, value=0x7f3a1031e120) at /data/src/bb-10.2-compatibility/sql/sp_rcontext.cc:649
#12 0x000055b889875f5c in sp_head::execute_procedure (this=0x7f3a107fccc0, thd=0x7f3a100009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2244
#13 0x000055b8898ea31d in do_execute_sp (thd=0x7f3a100009a8, sp=0x2, sp@entry=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#14 0x000055b8898eb976 in Sql_cmd_call::execute (this=this@entry=0x7f3a1031dc80, thd=thd@entry=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#15 0x000055b8898ec1e7 in Sql_cmd_call::execute (this=0x7f3a1031dc80, thd=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#16 0x000055b8898f1722 in mysql_execute_command (thd=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#17 0x000055b889871c04 in sp_instr_stmt::exec_core (this=0x7f3a1031e128, thd=<optimized out>, nextp=0x7f3a785f3134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#18 0x000055b8898791a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f3a1031e170, thd=thd@entry=0x7f3a100009a8, nextp=nextp@entry=0x7f3a785f3134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f3a1031e128) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#19 0x000055b8898797ec in sp_instr_stmt::execute (this=0x7f3a1031e128, thd=0x7f3a100009a8, nextp=0x7f3a785f3134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#20 0x000055b8898754cd in sp_head::execute (this=0x7f3a107992e0, thd=0x7f3a100009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#21 0x000055b88987653e in sp_head::execute_procedure (this=0x7f3a107992e0, thd=0x7f3a100009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#22 0x000055b8898ea31d in do_execute_sp (thd=0x7f3a100009a8, sp=0x2, sp@entry=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#23 0x000055b8898eb976 in Sql_cmd_call::execute (this=this@entry=0x7f3a1000fb98, thd=thd@entry=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#24 0x000055b8898ec1e7 in Sql_cmd_call::execute (this=0x7f3a1000fb98, thd=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#25 0x000055b8898f1722 in mysql_execute_command (thd=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#26 0x000055b8898f804d in mysql_parse (thd=0x7f3a100009a8, rawbuf=<optimized out>, length=63, parser_state=0x7f3a785f5260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#27 0x000055b8898fb555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f3a100009a8, packet=packet@entry=0x7f3a10006fa9 " CALL pkg.pr2(@a)  /* QNO 1818 CON_ID 18 */ ", packet_length=packet_length@entry=65, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#28 0x000055b8898fbe23 in do_command (thd=0x7f3a100009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#29 0x000055b8899c4594 in do_handle_one_connection (connect=connect@entry=0x55b892106a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#30 0x000055b8899c4734 in handle_one_connection (arg=0x55b892106a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#31 0x00007f3bc8daf494 in start_thread (arg=0x7f3a785f6700) at pthread_create.c:333
#32 0x00007f3bc719593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.2, RelWithDebInfo, logfile

Version: '10.2.13-MariaDB-log'  socket: '/data/logs/compat-3/current1_1/mysql.sock'  port: 13000  Source distribution
pure virtual method called
terminate called without an active exception
180125  5:17:01 [ERROR] mysqld got signal 6 ;
...
data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55b889f85639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55b889ab0d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f3bc8db90c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f3bc70dffcf]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f3bc70e13fa]
mysys/stacktrace.c:268(my_print_stacktrace)[0x7f3bc79f60ad]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f066)[0x7f3bc79f4066]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f0b1)[0x7f3bc79f40b1]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8fb8f)[0x7f3bc79f4b8f]
sql/item.h:832(Item::cmp_type() const)[0x55b889873cf4]
sql/sp_rcontext.cc:684(sp_rcontext::set_variable(THD*, unsigned int, Item**))[0x55b88987fa24]
sql/sp_head.cc:2244(sp_head::execute_procedure(THD*, List<Item>*))[0x55b889875f5c]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55b8898ea31d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55b8898eb976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55b8898ec1e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55b8898f1722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55b889871c04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b8898791a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55b8898797ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55b8898754cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55b88987653e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55b8898ea31d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55b8898eb976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55b8898ec1e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55b8898f1722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b8898f804d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b8898fb555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55b8898fbe23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55b8899c4594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55b8899c4734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f3bc8daf494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f3bc719593f]

No.2a, RelWithDebInfo, logfile

stack_bottom = 0x7f01b0178e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x5645971f9639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x564596d24d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f01c46e00c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f01c2a06fcf]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f01c2a083fa]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(_ZN9__gnu_cxx27__verbose_terminate_handlerEv+0x15d)[0x7f01c331d0ad]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f066)[0x7f01c331b066]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f0b1)[0x7f01c331b0b1]
/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8fb8f)[0x7f01c331bb8f]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z12sp_eval_exprP3THDP4ItemP5FieldPS2_+0x94)[0x564596ae7cf4]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN11sp_rcontext12set_variableEP3THDjPP4Item+0x74)[0x564596af3a24]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x14c)[0x564596ae9f5c]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x54631d)[0x564596b5e31d]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x547976)[0x564596b5f976]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x87)[0x564596b601e7]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z21mysql_execute_commandP3THD+0x12e2)[0x564596b65722]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x14)[0x564596ae5c04]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x93)[0x564596aed1a3]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x21c)[0x564596aed7ec]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN7sp_head7executeEP3THDb+0x82d)[0x564596ae94cd]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x72e)[0x564596aea53e]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x54631d)[0x564596b5e31d]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x547976)[0x564596b5f976]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x87)[0x564596b601e7]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z21mysql_execute_commandP3THD+0x12e2)[0x564596b65722]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2ad)[0x564596b6c04d]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2785)[0x564596b6f555]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z10do_commandP3THD+0x133)[0x564596b6fe23]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x234)[0x564596c38594]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_one_connection+0x34)[0x564596c38734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f01c46d6494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f01c2abc93f]

No.3, RelWithDebInfo, gdb

#2  <signal handler called>
#3  placeholder (this=0x677473736967) at /data/src/bb-10.2-compatibility/sql/table.h:2188
#4  mark_real_tables_as_free_for_reuse (table_list=table_list@entry=0x677473736967) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4892
#5  0x000055c3c1833249 in lock_tables (thd=thd@entry=0x7ff0000009a8, tables=0x0, count=<optimized out>, flags=flags@entry=0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:5049
#6  0x000055c3c18345e3 in open_and_lock_tables (thd=thd@entry=0x7ff0000009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7ff07860d9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4754
#7  0x000055c3c18791d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#8  Sql_cmd_call::execute (this=0x7ff0004532d8, thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#9  0x000055c3c187e722 in mysql_execute_command (thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#10 0x000055c3c17fec04 in sp_instr_stmt::exec_core (this=0x7ff000453690, thd=<optimized out>, nextp=0x7ff07860f134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#11 0x000055c3c18061a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7ff0004536d8, thd=thd@entry=0x7ff0000009a8, nextp=nextp@entry=0x7ff07860f134, open_tables=open_tables@entry=false, instr=instr@entry=0x7ff000453690) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#12 0x000055c3c18067ec in sp_instr_stmt::execute (this=0x7ff000453690, thd=0x7ff0000009a8, nextp=0x7ff07860f134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#13 0x000055c3c18024cd in sp_head::execute (this=0x7ff000451bd0, thd=0x7ff0000009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#14 0x000055c3c180353e in sp_head::execute_procedure (this=0x7ff000451bd0, thd=0x7ff0000009a8, args=0x7ff000579140) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#15 0x000055c3c187731d in do_execute_sp (thd=0x7ff0000009a8, sp=0x677473736967, sp@entry=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#16 0x000055c3c1878976 in Sql_cmd_call::execute (this=this@entry=0x7ff000010b98, thd=thd@entry=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#17 0x000055c3c18791e7 in Sql_cmd_call::execute (this=0x7ff000010b98, thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#18 0x000055c3c187e722 in mysql_execute_command (thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#19 0x000055c3c188504d in mysql_parse (thd=0x7ff0000009a8, rawbuf=<optimized out>, length=76, parser_state=0x7ff078611260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#20 0x000055c3c1888555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7ff0000009a8, packet=packet@entry=0x7ff000006fa9 " CALL pkg.pr3(CURRENT_TIMESTAMP)  /* QNO 2612 CON_ID 19 */ ", packet_length=packet_length@entry=78, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#21 0x000055c3c1888e23 in do_command (thd=0x7ff0000009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#22 0x000055c3c1951594 in do_handle_one_connection (connect=connect@entry=0x55c3ca7d2a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#23 0x000055c3c1951734 in handle_one_connection (arg=0x55c3ca7d2a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#24 0x00007ff1a7c23494 in start_thread (arg=0x7ff078612700) at pthread_create.c:333
#25 0x00007ff1a600993f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.3, RelWithDebInfo, logfile

stack_bottom = 0x7ff078611e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55c3c1f12639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55c3c1a3dd8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7ff1a7c2d0c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x4fc6a5)[0x55c3c182d6a5]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjj+0x439)[0x55c3c1833249]
mysys/stacktrace.c:268(my_print_stacktrace)[0x55c3c18345e3]
sql/sql_parse.cc:3123(Sql_cmd_call::execute(THD*))[0x55c3c18791d8]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55c3c187e722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c3c17fec04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c3c18061a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c3c18067ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55c3c18024cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55c3c180353e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55c3c187731d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55c3c1878976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55c3c18791e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55c3c187e722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c3c188504d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c3c1888555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55c3c1888e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55c3c1951594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55c3c1951734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7ff1a7c23494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7ff1a600993f]

No.4, RelWithDebInfo, gdb

#2  <signal handler called>
#3  st_select_lex::cleanup (this=0x7f2500000000) at /data/src/bb-10.2-compatibility/sql/sql_union.cc:1902
#4  0x000055e7465846a8 in st_select_lex_unit::cleanup (this=0x7f2500000000) at /data/src/bb-10.2-compatibility/sql/sql_union.cc:1741
#5  0x000055e7464ebad8 in mysql_execute_command (thd=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6279
#6  0x000055e74646cc04 in sp_instr_stmt::exec_core (this=0x7f25a0085668, thd=<optimized out>, nextp=0x7f2738201134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#7  0x000055e7464741a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f25a00856b0, thd=thd@entry=0x7f25a00009a8, nextp=nextp@entry=0x7f2738201134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f25a0085668) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#8  0x000055e7464747ec in sp_instr_stmt::execute (this=0x7f25a0085668, thd=0x7f25a00009a8, nextp=0x7f2738201134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#9  0x000055e7464704cd in sp_head::execute (this=0x7f25a04b7e80, thd=0x7f25a00009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#10 0x000055e74647153e in sp_head::execute_procedure (this=0x7f25a04b7e80, thd=0x7f25a00009a8, args=0x58) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#11 0x000055e7464e531d in do_execute_sp (thd=0x7f25a00009a8, sp=0x7f2500000000, sp@entry=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#12 0x000055e7464e6976 in Sql_cmd_call::execute (this=this@entry=0x7f25a000fb98, thd=thd@entry=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#13 0x000055e7464e71e7 in Sql_cmd_call::execute (this=0x7f25a000fb98, thd=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#14 0x000055e7464ec722 in mysql_execute_command (thd=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#15 0x000055e7464f304d in mysql_parse (thd=0x7f25a00009a8, rawbuf=<optimized out>, length=63, parser_state=0x7f2738203260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#16 0x000055e7464f6555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f25a00009a8, packet=packet@entry=0x7f25a0006fa9 " CALL pkg.pr4(NOW())  /* QNO 608 CON_ID 16 */ ", packet_length=packet_length@entry=65, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#17 0x000055e7464f6e23 in do_command (thd=0x7f25a00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#18 0x000055e7465bf594 in do_handle_one_connection (connect=connect@entry=0x55e750acda18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#19 0x000055e7465bf734 in handle_one_connection (arg=0x55e750acda18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#20 0x00007f274e853494 in start_thread (arg=0x7f2738204700) at pthread_create.c:333
#21 0x00007f274cc3993f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.4, RelWithDebInfo, logfile

stack_bottom = 0x7f2738203e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55e746b80639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55e7466abd8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f274e85d0c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN13st_select_lex7cleanupEv+0xb)[0x55e74658453b]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN18st_select_lex_unit7cleanupEv+0x38)[0x55e7465846a8]
mysys/stacktrace.c:268(my_print_stacktrace)[0x55e7464ebad8]
sql/sql_parse.cc:6281(mysql_execute_command(THD*))[0x55e74646cc04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55e7464741a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55e7464747ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55e7464704cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55e74647153e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55e7464e531d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55e7464e6976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55e7464e71e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55e7464ec722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55e7464f304d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e7464f6555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55e7464f6e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55e7465bf594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55e7465bf734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f274e853494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f274cc3993f]

No.5, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x0000559dfa56a9aa in open_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., start=start@entry=0x7f5c3414a9a8, counter=counter@entry=0x7f5c3414a9bc, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4053
#4  0x0000559dfa56b58d in open_and_lock_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
#5  0x0000559dfa5b01d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#6  Sql_cmd_call::execute (this=0x7f5bcca24580, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#7  0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#8  0x0000559dfa535c04 in sp_instr_stmt::exec_core (this=0x7f5bcca24a28, thd=<optimized out>, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#9  0x0000559dfa53d1a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f5bcca24a70, thd=thd@entry=0x7f5bcc0009a8, nextp=nextp@entry=0x7f5c3414c134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f5bcca24a28) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#10 0x0000559dfa53d7ec in sp_instr_stmt::execute (this=0x7f5bcca24a28, thd=0x7f5bcc0009a8, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#11 0x0000559dfa5394cd in sp_head::execute (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#12 0x0000559dfa53a53e in sp_head::execute_procedure (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#13 0x0000559dfa5ae31d in do_execute_sp (thd=0x7f5bcc0009a8, sp=sp@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#14 0x0000559dfa5af976 in Sql_cmd_call::execute (this=this@entry=0x7f5bcc00fba8, thd=thd@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#15 0x0000559dfa5b01e7 in Sql_cmd_call::execute (this=0x7f5bcc00fba8, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#16 0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#17 0x0000559dfa5bc04d in mysql_parse (thd=0x7f5bcc0009a8, rawbuf=<optimized out>, length=65, parser_state=0x7f5c3414e260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#18 0x0000559dfa5bf555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f5bcc0009a8, packet=packet@entry=0x7f5bcc006fa9 " CALL pkg.pr5(NOW())  /* QNO 969 CON_ID 17 */ ", packet_length=packet_length@entry=67, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#19 0x0000559dfa5bfe23 in do_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#20 0x0000559dfa688594 in do_handle_one_connection (connect=connect@entry=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#21 0x0000559dfa688734 in handle_one_connection (arg=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#22 0x00007f5d724e7494 in start_thread (arg=0x7f5c3414f700) at pthread_create.c:333
#23 0x00007f5d708cd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.5, RelWithDebInfo, logfile

stack_bottom = 0x7f5c3414ee98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x559dfac49639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x559dfa774d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f5d724f10c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0x4fa)[0x559dfa56a9aa]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x3d)[0x559dfa56b58d]
mysys/stacktrace.c:268(my_print_stacktrace)[0x559dfa5b01d8]
sql/sql_parse.cc:3123(Sql_cmd_call::execute(THD*))[0x559dfa5b5722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559dfa535c04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559dfa53d1a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x559dfa53d7ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x559dfa5394cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x559dfa53a53e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x559dfa5ae31d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x559dfa5af976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x559dfa5b01e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x559dfa5b5722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559dfa5bc04d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559dfa5bf555]
sql/sql_parse.cc:1385(do_command(THD*))[0x559dfa5bfe23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x559dfa688594]
sql/sql_connect.cc:1243(handle_one_connection)[0x559dfa688734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f5d724e7494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f5d708cd93f]

No.6, RelWithDebInfo, gdb

#3  first_not_own_table (this=0x7feaa44f67f8) at /data/src/bb-10.2-compatibility/sql/sql_lex.h:1443
#4  lock_tables (thd=thd@entry=0x7feaa40009a8, tables=0x0, count=<optimized out>, flags=flags@entry=0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:5018
#5  0x000055d3259c25e3 in open_and_lock_tables (thd=thd@entry=0x7feaa40009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7fec440d09f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4754
#6  0x000055d325a071d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#7  Sql_cmd_call::execute (this=0x7feaa40884a8, thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#8  0x000055d325a0c722 in mysql_execute_command (thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#9  0x000055d32598cc04 in sp_instr_stmt::exec_core (this=0x7feaa44e9868, thd=<optimized out>, nextp=0x7fec440d2134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#10 0x000055d3259941a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7feaa44e98b0, thd=thd@entry=0x7feaa40009a8, nextp=nextp@entry=0x7fec440d2134, open_tables=open_tables@entry=false, instr=instr@entry=0x7feaa44e9868) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#11 0x000055d3259947ec in sp_instr_stmt::execute (this=0x7feaa44e9868, thd=0x7feaa40009a8, nextp=0x7fec440d2134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#12 0x000055d3259904cd in sp_head::execute (this=0x7feaa4086870, thd=0x7feaa40009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#13 0x000055d32599153e in sp_head::execute_procedure (this=0x7feaa4086870, thd=0x7feaa40009a8, args=0x7feaa44f67f0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#14 0x000055d325a0531d in do_execute_sp (thd=0x7feaa40009a8, sp=0x0, sp@entry=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#15 0x000055d325a06976 in Sql_cmd_call::execute (this=this@entry=0x7feaa4010b78, thd=thd@entry=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#16 0x000055d325a071e7 in Sql_cmd_call::execute (this=0x7feaa4010b78, thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#17 0x000055d325a0c722 in mysql_execute_command (thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#18 0x000055d325a1304d in mysql_parse (thd=0x7feaa40009a8, rawbuf=<optimized out>, length=63, parser_state=0x7fec440d4260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#19 0x000055d325a16555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7feaa40009a8, packet=packet@entry=0x7feaa4006fa9 " CALL pkg.pr6(NOW())  /* QNO 618 CON_ID 20 */ ", packet_length=packet_length@entry=65, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#20 0x000055d325a16e23 in do_command (thd=0x7feaa40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#21 0x000055d325adf594 in do_handle_one_connection (connect=connect@entry=0x55d32e322a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#22 0x000055d325adf734 in handle_one_connection (arg=0x55d32e322a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#23 0x00007fec5b07a494 in start_thread (arg=0x7fec440d5700) at pthread_create.c:333
#24 0x00007fec5946093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.6, RelWithDebInfo, logfile

stack_bottom = 0x7fec440d4e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55d3260a0639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55d325bcbd8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fec5b0840c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjj+0x32f)[0x55d3259c113f]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x93)[0x55d3259c25e3]
mysys/stacktrace.c:268(my_print_stacktrace)[0x55d325a071d8]
sql/sql_parse.cc:3123(Sql_cmd_call::execute(THD*))[0x55d325a0c722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55d32598cc04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55d3259941a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55d3259947ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55d3259904cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55d32599153e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55d325a0531d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55d325a06976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55d325a071e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55d325a0c722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d325a1304d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d325a16555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55d325a16e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55d325adf594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55d325adf734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fec5b07a494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fec5946093f]

No.7, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x0000000000000000 in ?? ()
#4  0x0000563e066018db in Sql_cmd_call::execute (this=this@entry=0x7f80945e80b0, thd=thd@entry=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3131
#5  0x0000563e066021e7 in Sql_cmd_call::execute (this=0x7f80945e80b0, thd=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#6  0x0000563e06607722 in mysql_execute_command (thd=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#7  0x0000563e06587c04 in sp_instr_stmt::exec_core (this=0x7f80945e8558, thd=<optimized out>, nextp=0x7f80ce742134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#8  0x0000563e0658f1a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f80945e85a0, thd=thd@entry=0x7f80940009a8, nextp=nextp@entry=0x7f80ce742134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f80945e8558) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#9  0x0000563e0658f7ec in sp_instr_stmt::execute (this=0x7f80945e8558, thd=0x7f80940009a8, nextp=0x7f80ce742134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#10 0x0000563e0658b4cd in sp_head::execute (this=0x7f809449c450, thd=0x7f80940009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#11 0x0000563e0658c53e in sp_head::execute_procedure (this=0x7f809449c450, thd=0x7f80940009a8, args=0x7f80945e8050) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#12 0x0000563e0660031d in do_execute_sp (thd=0x7f80940009a8, sp=0x563e07616500 <end_of_list>, sp@entry=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#13 0x0000563e06601976 in Sql_cmd_call::execute (this=this@entry=0x7f8094010b98, thd=thd@entry=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#14 0x0000563e066021e7 in Sql_cmd_call::execute (this=0x7f8094010b98, thd=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#15 0x0000563e06607722 in mysql_execute_command (thd=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#16 0x0000563e0660e04d in mysql_parse (thd=0x7f80940009a8, rawbuf=<optimized out>, length=78, parser_state=0x7f80ce744260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#17 0x0000563e06611555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f80940009a8, packet=packet@entry=0x7f8094006fa9 " CALL pkg.pr7(CURRENT_TIMESTAMP)  /* QNO 1687 CON_ID 16 */ ", packet_length=packet_length@entry=80, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#18 0x0000563e06611e23 in do_command (thd=0x7f80940009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#19 0x0000563e066da594 in do_handle_one_connection (connect=connect@entry=0x563e106fa118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#20 0x0000563e066da734 in handle_one_connection (arg=0x563e106fa118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#21 0x00007f823b894494 in start_thread (arg=0x7f80ce745700) at pthread_create.c:333
#22 0x00007f8239c7a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.7, RelWithDebInfo, logfile

180125  6:42:38 [ERROR] mysqld got signal 11 ;
 
...
 
Thread pointer: 0x7f80940009a8
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 = 0x7f80ce744e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x563e06c9b639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x563e067c6d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f823b89e0c0]
 
Trying to get some variables.

No.8, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x00005645f1d27a2a in is_log_table_write_query (command=1767937768) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:900
#4  0x00005645f1fb95aa in lock_tables_check (flags=0, count=0, tables=0x7fe86aa58600, thd=thd@entry=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/lock.cc:117
#5  mysql_lock_tables (thd=thd@entry=0x7fe8680009a8, tables=0x7fe86aa58600, count=0, flags=0) at /data/src/bb-10.2-compatibility/sql/lock.cc:294
#6  0x00005645f1ce3114 in lock_tables (thd=thd@entry=0x7fe8680009a8, tables=0x0, count=<optimized out>, flags=flags@entry=0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:5010
#7  0x00005645f1ce45e3 in open_and_lock_tables (thd=thd@entry=0x7fe8680009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7fe9e80609f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4754
#8  0x00005645f1d291d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#9  Sql_cmd_call::execute (this=0x7fe86960ade0, thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#10 0x00005645f1d2e722 in mysql_execute_command (thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#11 0x00005645f1caec04 in sp_instr_stmt::exec_core (this=0x7fe86960b288, thd=<optimized out>, nextp=0x7fe9e8062134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#12 0x00005645f1cb61a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7fe86960b2d0, thd=thd@entry=0x7fe8680009a8, nextp=nextp@entry=0x7fe9e8062134, open_tables=open_tables@entry=false, instr=instr@entry=0x7fe86960b288) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#13 0x00005645f1cb67ec in sp_instr_stmt::execute (this=0x7fe86960b288, thd=0x7fe8680009a8, nextp=0x7fe9e8062134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#14 0x00005645f1cb24cd in sp_head::execute (this=0x7fe8694bf180, thd=0x7fe8680009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#15 0x00005645f1cb353e in sp_head::execute_procedure (this=0x7fe8694bf180, thd=0x7fe8680009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#16 0x00005645f1d2731d in do_execute_sp (thd=0x7fe8680009a8, sp=0x696096e8, sp@entry=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#17 0x00005645f1d28976 in Sql_cmd_call::execute (this=this@entry=0x7fe86800ff48, thd=thd@entry=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#18 0x00005645f1d291e7 in Sql_cmd_call::execute (this=0x7fe86800ff48, thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#19 0x00005645f1d2e722 in mysql_execute_command (thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#20 0x00005645f1d3504d in mysql_parse (thd=0x7fe8680009a8, rawbuf=<optimized out>, length=65, parser_state=0x7fe9e8064260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#21 0x00005645f1d38555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fe8680009a8, packet=packet@entry=0x7fe868006fa9 " CALL pkg.pr8(NULL)  /* QNO 2581 CON_ID 15 */ ", packet_length=packet_length@entry=67, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#22 0x00005645f1d38e23 in do_command (thd=0x7fe8680009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#23 0x00005645f1e01594 in do_handle_one_connection (connect=connect@entry=0x5645fc2e0c88) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#24 0x00005645f1e01734 in handle_one_connection (arg=0x5645fc2e0c88) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#25 0x00007fe9edac1494 in start_thread (arg=0x7fe9e8065700) at pthread_create.c:333
#26 0x00007fe9ebea793f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.8, RelWithDebInfo, logfile

/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x5645f23c2639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x5645f1eedd8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fe9edacb0c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z24is_log_table_write_query16enum_sql_command+0xa)[0x5645f1d27a2a]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z17mysql_lock_tablesP3THDPP5TABLEjj+0x3a)[0x5645f1fb95aa]
mysys/stacktrace.c:268(my_print_stacktrace)[0x5645f1ce3114]
sql/sql_parse.cc:900(is_log_table_write_query(enum_sql_command))[0x5645f1ce45e3]
sql/sql_parse.cc:3123(Sql_cmd_call::execute(THD*))[0x5645f1d291d8]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x5645f1d2e722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5645f1caec04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5645f1cb61a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x5645f1cb67ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x5645f1cb24cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x5645f1cb353e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x5645f1d2731d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x5645f1d28976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x5645f1d291e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x5645f1d2e722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5645f1d3504d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5645f1d38555]
sql/sql_parse.cc:1385(do_command(THD*))[0x5645f1d38e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x5645f1e01594]
sql/sql_connect.cc:1243(handle_one_connection)[0x5645f1e01734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fe9edac1494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fe9ebea793f]

No.9, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x00007fa4dc0009a8 in ?? ()
#4  0x0000557070336e19 in sql_set_variables (thd=0x7fa4d00009a8, var_list=var_list@entry=0x7fa4d0996b00, free=free@entry=false) at /data/src/bb-10.2-compatibility/sql/set_var.cc:732
#5  0x00005570703b53af in LEX::restore_set_statement_var (this=0x7fa4d0995c98) at /data/src/bb-10.2-compatibility/sql/sql_lex.cc:4880
#6  0x000055707034f22b in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7fa4d0997880, thd=thd@entry=0x7fa4d00009a8, nextp=nextp@entry=0x7fa66c138134, open_tables=open_tables@entry=false, instr=instr@entry=0x7fa4d0997838) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3418
#7  0x000055707034f7ec in sp_instr_stmt::execute (this=0x7fa4d0997838, thd=0x7fa4d00009a8, nextp=0x7fa66c138134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#8  0x000055707034b4cd in sp_head::execute (this=0x7fa4d07ae6b0, thd=0x7fa4d00009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#9  0x000055707034c53e in sp_head::execute_procedure (this=0x7fa4d07ae6b0, thd=0x7fa4d00009a8, args=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#10 0x00005570703c031d in do_execute_sp (thd=0x7fa4d00009a8, sp=0x7fa4d40009b8, sp@entry=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#11 0x00005570703c1976 in Sql_cmd_call::execute (this=this@entry=0x7fa4d000fba8, thd=thd@entry=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#12 0x00005570703c21e7 in Sql_cmd_call::execute (this=0x7fa4d000fba8, thd=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#13 0x00005570703c7722 in mysql_execute_command (thd=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#14 0x00005570703ce04d in mysql_parse (thd=0x7fa4d00009a8, rawbuf=<optimized out>, length=65, parser_state=0x7fa66c13a260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#15 0x00005570703d1555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fa4d00009a8, packet=packet@entry=0x7fa4d0006fa9 " CALL pkg.pr9(NOW())  /* QNO 560 CON_ID 19 */ ", packet_length=packet_length@entry=67, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#16 0x00005570703d1e23 in do_command (thd=0x7fa4d00009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#17 0x000055707049a594 in do_handle_one_connection (connect=connect@entry=0x557079a8ba18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#18 0x000055707049a734 in handle_one_connection (arg=0x557079a8ba18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#19 0x00007fa680ed9494 in start_thread (arg=0x7fa66c13b700) at pthread_create.c:333
#20 0x00007fa67f2bf93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.9, RelWithDebInfo, logfile

180125  7:35:31 [ERROR] mysqld got signal 11 ;
 
...
 
Thread pointer: 0x7fa4d00009a8
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 = 0x7fa66c13ae98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x557070a5b639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x557070586d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fa680ee30c0]
[0x7fa4dc0009a8]
 
Trying to get some variables.

No.10, RelWithDebInfo, gdb

#2  <signal handler called>
#3  0x000055c5637ae7ba in mysql_handle_derived (lex=0x7f74f8a14e48, phases=phases@entry=1) at /data/src/bb-10.2-compatibility/sql/sql_derived.cc:95
#4  0x000055c56378e609 in open_and_lock_tables (thd=thd@entry=0x7f74f80009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f76881b89f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4761
#5  0x000055c5637d31d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#6  Sql_cmd_call::execute (this=0x7f74f8a16540, thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#7  0x000055c5637d8722 in mysql_execute_command (thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#8  0x000055c563758c04 in sp_instr_stmt::exec_core (this=0x7f74f8a169e8, thd=<optimized out>, nextp=0x7f76881ba134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#9  0x000055c5637601a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f74f8a16a30, thd=thd@entry=0x7f74f80009a8, nextp=nextp@entry=0x7f76881ba134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f74f8a169e8) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#10 0x000055c5637607ec in sp_instr_stmt::execute (this=0x7f74f8a169e8, thd=0x7f74f80009a8, nextp=0x7f76881ba134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#11 0x000055c56375c4cd in sp_head::execute (this=0x7f74f8db07c0, thd=0x7f74f80009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#12 0x000055c56375d53e in sp_head::execute_procedure (this=0x7f74f8db07c0, thd=0x7f74f80009a8, args=0x55c5647e7500 <end_of_list>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#13 0x000055c5637d131d in do_execute_sp (thd=0x7f74f80009a8, sp=0x7f74f8a15650, sp@entry=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#14 0x000055c5637d2976 in Sql_cmd_call::execute (this=this@entry=0x7f74f800fbb8, thd=thd@entry=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#15 0x000055c5637d31e7 in Sql_cmd_call::execute (this=0x7f74f800fbb8, thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#16 0x000055c5637d8722 in mysql_execute_command (thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#17 0x000055c5637df04d in mysql_parse (thd=0x7f74f80009a8, rawbuf=<optimized out>, length=77, parser_state=0x7f76881bc260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#18 0x000055c5637e2555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f74f80009a8, packet=packet@entry=0x7f74f8006fa9 " CALL pkg.pr10(CURRENT_TIMESTAMP)  /* QNO 302 CON_ID 16 */ ", packet_length=packet_length@entry=79, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#19 0x000055c5637e2e23 in do_command (thd=0x7f74f80009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#20 0x000055c5638ab594 in do_handle_one_connection (connect=connect@entry=0x55c56c320a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#21 0x000055c5638ab734 in handle_one_connection (arg=0x55c56c320a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#22 0x00007f769ceaf494 in start_thread (arg=0x7f76881bd700) at pthread_create.c:333
#23 0x00007f769b29593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.10, RelWithDebInfo, logfile

stack_bottom = 0x7f76881bce98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55c563e6c639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55c563997d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f769ceb90c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z20mysql_handle_derivedP3LEXj+0x14a)[0x55c5637ae7ba]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0xb9)[0x55c56378e609]
mysys/stacktrace.c:268(my_print_stacktrace)[0x55c5637d31d8]
sql/sql_parse.cc:3123(Sql_cmd_call::execute(THD*))[0x55c5637d8722]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c563758c04]
sql/sp_head.cc:3336(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c5637601a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c5637607ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55c56375c4cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55c56375d53e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55c5637d131d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55c5637d2976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55c5637d31e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55c5637d8722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c5637df04d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c5637e2555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55c5637e2e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55c5638ab594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55c5638ab734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f769ceaf494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f769b29593f]

No.11, RelWithDebInfo, gdb

#2  <signal handler called>
#3  Sql_cmd_call::execute (this=this@entry=0x7f973042f9f8, thd=thd@entry=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3131
#4  0x000055c4ebda31e7 in Sql_cmd_call::execute (this=0x7f973042f9f8, thd=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#5  0x000055c4ebda8722 in mysql_execute_command (thd=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#6  0x000055c4ebd28c04 in sp_instr_stmt::exec_core (this=0x7f9730431468, thd=<optimized out>, nextp=0x7f98cc06c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#7  0x000055c4ebd301a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f97304314b0, thd=thd@entry=0x7f97300009a8, nextp=nextp@entry=0x7f98cc06c134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f9730431468) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#8  0x000055c4ebd307ec in sp_instr_stmt::execute (this=0x7f9730431468, thd=0x7f97300009a8, nextp=0x7f98cc06c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#9  0x000055c4ebd2c4cd in sp_head::execute (this=0x7f973042ddc0, thd=0x7f97300009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#10 0x000055c4ebd2d53e in sp_head::execute_procedure (this=0x7f973042ddc0, thd=0x7f97300009a8, args=0x7f973042f9f8) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#11 0x000055c4ebda131d in do_execute_sp (thd=0x7f97300009a8, sp=0x55c400000000, sp@entry=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#12 0x000055c4ebda2976 in Sql_cmd_call::execute (this=this@entry=0x7f973000fba8, thd=thd@entry=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#13 0x000055c4ebda31e7 in Sql_cmd_call::execute (this=0x7f973000fba8, thd=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#14 0x000055c4ebda8722 in mysql_execute_command (thd=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#15 0x000055c4ebdaf04d in mysql_parse (thd=0x7f97300009a8, rawbuf=<optimized out>, length=70, parser_state=0x7f98cc06e260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#16 0x000055c4ebdb2555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f97300009a8, packet=packet@entry=0x7f9730006fa9 " CALL pkg.pr11('2012-12-12')  /* QNO 611 CON_ID 16 */ ", packet_length=packet_length@entry=72, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#17 0x000055c4ebdb2e23 in do_command (thd=0x7f97300009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#18 0x000055c4ebe7b594 in do_handle_one_connection (connect=connect@entry=0x55c4f4741a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#19 0x000055c4ebe7b734 in handle_one_connection (arg=0x55c4f4741a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#20 0x00007f98e121b494 in start_thread (arg=0x7f98cc06f700) at pthread_create.c:333
#21 0x00007f98df60193f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.11, RelWithDebInfo, logfile

stack_bottom = 0x7f98cc06ee98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x55c4ec43c639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x55c4ebf67d8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f98e12250c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(+0x5478d2)[0x55c4ebda28d2]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x87)[0x55c4ebda31e7]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z21mysql_execute_commandP3THD+0x12e2)[0x55c4ebda8722]
mysys/stacktrace.c:268(my_print_stacktrace)[0x55c4ebd28c04]
sql/sp_head.cc:3593(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c4ebd301a3]
sql/sp_head.cc:3508(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c4ebd307ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x55c4ebd2c4cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x55c4ebd2d53e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x55c4ebda131d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x55c4ebda2976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x55c4ebda31e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x55c4ebda8722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c4ebdaf04d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c4ebdb2555]
sql/sql_parse.cc:1385(do_command(THD*))[0x55c4ebdb2e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55c4ebe7b594]
sql/sql_connect.cc:1243(handle_one_connection)[0x55c4ebe7b734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f98e121b494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f98df60193f]

No.12, RelWithDebInfo, gdb

#2  <signal handler called>
#3  next_fast (this=<synthetic pointer>) at /data/src/bb-10.2-compatibility/sql/sql_list.h:464
#4  operator++ (this=<synthetic pointer>) at /data/src/bb-10.2-compatibility/sql/sql_list.h:583
#5  sql_set_variables (thd=0x7fc7a40009a8, var_list=var_list@entry=0x7fc7a4490d30, free=free@entry=false) at /data/src/bb-10.2-compatibility/sql/set_var.cc:730
#6  0x000056400002c3af in LEX::restore_set_statement_var (this=0x7fc7a448fec8) at /data/src/bb-10.2-compatibility/sql/sql_lex.cc:4880
#7  0x0000563ffffc622b in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7fc7a4491ab0, thd=thd@entry=0x7fc7a40009a8, nextp=nextp@entry=0x7fc80aaf7134, open_tables=open_tables@entry=false, instr=instr@entry=0x7fc7a4491a68) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3418
#8  0x0000563ffffc67ec in sp_instr_stmt::execute (this=0x7fc7a4491a68, thd=0x7fc7a40009a8, nextp=0x7fc80aaf7134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#9  0x0000563ffffc24cd in sp_head::execute (this=0x7fc7a4345960, thd=0x7fc7a40009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#10 0x0000563ffffc353e in sp_head::execute_procedure (this=0x7fc7a4345960, thd=0x7fc7a40009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#11 0x000056400003731d in do_execute_sp (thd=0x7fc7a40009a8, sp=sp@entry=0x7fc7a40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#12 0x0000564000038976 in Sql_cmd_call::execute (this=this@entry=0x7fc7a4010b88, thd=thd@entry=0x7fc7a40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#13 0x00005640000391e7 in Sql_cmd_call::execute (this=0x7fc7a4010b88, thd=0x7fc7a40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
#14 0x000056400003e722 in mysql_execute_command (thd=0x7fc7a40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#15 0x000056400004504d in mysql_parse (thd=0x7fc7a40009a8, rawbuf=<optimized out>, length=66, parser_state=0x7fc80aaf9260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#16 0x0000564000048555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc7a40009a8, packet=packet@entry=0x7fc7a4006fa9 " CALL pkg.pr12(NOW())  /* QNO 4997 CON_ID 20 */ ", packet_length=packet_length@entry=68, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#17 0x0000564000048e23 in do_command (thd=0x7fc7a40009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#18 0x0000564000111594 in do_handle_one_connection (connect=connect@entry=0x564008b20118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#19 0x0000564000111734 in handle_one_connection (arg=0x564008b20118) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#20 0x00007fc94ff76494 in start_thread (arg=0x7fc80aafa700) at pthread_create.c:333
#21 0x00007fc94e35c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

No.12, RelWithDebInfo, logfile

stack_bottom = 0x7fc80aaf9e98 thread_stack 0x40000
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(my_print_stacktrace+0x29)[0x5640006d2639]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(handle_fatal_signal+0x33d)[0x5640001fdd8d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fc94ff800c0]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_Z17sql_set_variablesP3THDP4ListI12set_var_baseEb+0x43)[0x563ffffade23]
/data/bld/bb-10.2-compatibility-rel/bin/mysqld(_ZN3LEX25restore_set_statement_varEv+0x2f)[0x56400002c3af]
mysys/stacktrace.c:268(my_print_stacktrace)[0x563ffffc622b]
sql/sql_list.h:182(base_list::empty())[0x563ffffc67ec]
sql/sp_head.cc:1394(sp_head::execute(THD*, bool))[0x563ffffc24cd]
sql/sp_head.cc:2313(sp_head::execute_procedure(THD*, List<Item>*))[0x563ffffc353e]
sql/sql_parse.cc:2932(do_execute_sp(THD*, sp_head*))[0x56400003731d]
sql/sql_parse.cc:3169(Sql_cmd_call::execute(THD*))[0x564000038976]
sql/sql_parse.cc:3173(Sql_cmd_call::execute(THD*))[0x5640000391e7]
sql/sql_parse.cc:6254(mysql_execute_command(THD*))[0x56400003e722]
sql/sql_parse.cc:7974(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56400004504d]
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564000048555]
sql/sql_parse.cc:1385(do_command(THD*))[0x564000048e23]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x564000111594]
sql/sql_connect.cc:1243(handle_one_connection)[0x564000111734]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fc94ff76494]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc94e35c93f]

ASAN

==19983==ERROR: AddressSanitizer: heap-use-after-free on address 0x625002431190 at pc 0x5562d3db2cf6 bp 0x7f130771aa60 sp 0x7f130771aa58
READ of size 188 at 0x625002431190 thread T46
    #0 0x5562d3db2cf5 in Query_tables_list::set_query_tables_list(Query_tables_list*) /data/src/bb-10.2-compatibility/sql/sql_lex.h:1419
    #1 0x5562d3d902da in LEX::reset_n_backup_query_tables_list(Query_tables_list*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:3670
    #2 0x5562d3cc0d14 in open_system_tables_for_read(THD*, TABLE_LIST*, Open_tables_backup*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:8570
    #3 0x5562d47d2b77 in open_proc_table_for_read(THD*, Open_tables_backup*) /data/src/bb-10.2-compatibility/sql/sp.cc:482
    #4 0x5562d47d42c9 in Sp_handler::db_find_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:676
    #5 0x5562d47d4d66 in Sp_handler::db_find_and_cache_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:747
    #6 0x5562d47e2072 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2720
    #7 0x5562d47e2556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #8 0x5562d47e2a41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #9 0x5562d47e1c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #10 0x5562d3ca30d1 in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3202
    #11 0x5562d3ca6b5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #12 0x5562d3caa5a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #13 0x5562d3c2323e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #14 0x5562d3dcb475 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
    #15 0x5562d3dded21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #16 0x5562d3c0ec9d in sp_instr_stmt::exec_core(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
    #17 0x5562d3c0d74a in sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
    #18 0x5562d3c0e567 in sp_instr_stmt::execute(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
    #19 0x5562d3c0200f in sp_head::execute(THD*, bool) /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
    #20 0x5562d3c06c4b in sp_head::execute_procedure(THD*, List<Item>*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
    #21 0x5562d3dc9eaf in do_execute_sp /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
    #22 0x5562d3dcb7f4 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
    #23 0x5562d3dded21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #24 0x5562d3de923c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
    #25 0x5562d3dc4217 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
    #26 0x5562d3dc1258 in do_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
    #27 0x5562d4101595 in do_handle_one_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
    #28 0x5562d4100faa in handle_one_connection /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
    #29 0x7f1437087493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
    #30 0x7f143546d93e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
 
0x625002431190 is located 144 bytes inside of 8268-byte region [0x625002431100,0x62500243314c)
freed by thread T46 here:
    #0 0x7f14372f1527 in __interceptor_free (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x54527)
    #1 0x5562d54bd20d in free_memory /data/src/bb-10.2-compatibility/mysys/safemalloc.c:279
    #2 0x5562d54bc86e in sf_free /data/src/bb-10.2-compatibility/mysys/safemalloc.c:197
    #3 0x5562d548b8c8 in my_free /data/src/bb-10.2-compatibility/mysys/my_malloc.c:224
    #4 0x5562d546cf04 in free_root /data/src/bb-10.2-compatibility/mysys/my_alloc.c:407
    #5 0x5562d3bfc546 in sp_head::operator delete(void*, unsigned long) /data/src/bb-10.2-compatibility/sql/sp_head.cc:550
    #6 0x5562d3bfff44 in sp_head::~sp_head() /data/src/bb-10.2-compatibility/sql/sp_head.cc:890
    #7 0x5562d3d827d3 in lex_end_stage1(LEX*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:813
    #8 0x5562d3d823fa in lex_end(LEX*) /data/src/bb-10.2-compatibility/sql/sql_lex.cc:784
    #9 0x5562d3bfffea in sp_package::LexList::cleanup() /data/src/bb-10.2-compatibility/sql/sp_head.cc:898
    #10 0x5562d3bfd4ef in sp_package::~sp_package() /data/src/bb-10.2-compatibility/sql/sp_head.cc:626
    #11 0x5562d3bfd7c7 in sp_package::~sp_package() /data/src/bb-10.2-compatibility/sql/sp_head.cc:632
    #12 0x5562d3bf96c8 in hash_free_sp_head /data/src/bb-10.2-compatibility/sql/sp_cache.cc:287
    #13 0x5562d5433666 in my_hash_delete /data/src/bb-10.2-compatibility/mysys/hash.c:626
    #14 0x5562d3bf9ac0 in sp_cache::remove(sp_head*) (/data/bld/bb-10.2-compatibility-asan/bin/mysqld+0xbd9ac0)
    #15 0x5562d3bf9543 in sp_cache_flush_obsolete(sp_cache**, sp_head**) /data/src/bb-10.2-compatibility/sql/sp_cache.cc:236
    #16 0x5562d47e2004 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2715
    #17 0x5562d47e2556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #18 0x5562d47e2a41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #19 0x5562d47e1c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #20 0x5562d3ca30d1 in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3202
    #21 0x5562d3ca6b5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #22 0x5562d3caa5a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #23 0x5562d3c2323e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #24 0x5562d3dcb475 in Sql_cmd_call::execute(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
    #25 0x5562d3dded21 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
    #26 0x5562d3c0ec9d in sp_instr_stmt::exec_core(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
    #27 0x5562d3c0d74a in sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
    #28 0x5562d3c0e567 in sp_instr_stmt::execute(THD*, unsigned int*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
    #29 0x5562d3c0200f in sp_head::execute(THD*, bool) /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
 
previously allocated by thread T46 here:
    #0 0x7f14372f173f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
    #1 0x5562d54bc010 in sf_malloc /data/src/bb-10.2-compatibility/mysys/safemalloc.c:118
    #2 0x5562d548b000 in my_malloc /data/src/bb-10.2-compatibility/mysys/my_malloc.c:101
    #3 0x5562d546c06e in alloc_root /data/src/bb-10.2-compatibility/mysys/my_alloc.c:243
    #4 0x5562d3b8a6c9 in Sql_alloc::operator new(unsigned long, st_mem_root*) /data/src/bb-10.2-compatibility/sql/sql_list.h:46
    #5 0x5562d3c0791d in sp_head::reset_lex(THD*) /data/src/bb-10.2-compatibility/sql/sp_head.cc:2425
    #6 0x5562d432fc77 in ORAparse(THD*) /data/src/bb-10.2-compatibility/sql/sql_yacc_ora.yy:3684
    #7 0x5562d3df57a4 in parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:9997
    #8 0x5562d47d5359 in sp_compile /data/src/bb-10.2-compatibility/sql/sp.cc:833
    #9 0x5562d47d5c18 in Sp_handler::db_load_routine(THD*, Database_qualified_name const*, sp_head**, unsigned long long, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_sp_chistics const&, AUTHID const&, long long, long long, sp_package*, Stored_program_creation_ctx*) const /data/src/bb-10.2-compatibility/sql/sp.cc:958
    #10 0x5562d47d4b28 in Sp_handler::db_find_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:728
    #11 0x5562d47d4d66 in Sp_handler::db_find_and_cache_routine(THD*, Database_qualified_name const*, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:747
    #12 0x5562d47e2072 in Sp_handler::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2720
    #13 0x5562d47e2556 in Sp_handler::sp_cache_package_routine(THD*, st_mysql_const_lex_string const&, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2766
    #14 0x5562d47e2a41 in Sp_handler_package_procedure::sp_cache_routine(THD*, Database_qualified_name const*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2791
    #15 0x5562d47e1c98 in Sroutine_hash_entry::sp_cache_routine(THD*, bool, sp_head**) const /data/src/bb-10.2-compatibility/sql/sp.cc:2673
    #16 0x5562d3ca2e0f in open_and_process_routine /data/src/bb-10.2-compatibility/sql/sql_base.cc:3161
    #17 0x5562d3ca6b5f in open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
    #18 0x5562d3caa5a0 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
    #19 0x5562d3c2323e in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/src/bb-10.2-compatibility/sql/sql_base.h:496
    #20 0x5562d3d54a50 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) /data/src/bb-10.2-compatibility/sql/sql_insert.cc:760
    #21 0x5562d3dd3db6 in mysql_execute_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:4689
    #22 0x5562d3de923c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
    #23 0x5562d3dc4217 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
    #24 0x5562d3dc1258 in do_command(THD*) /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
    #25 0x5562d4101595 in do_handle_one_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
    #26 0x5562d4100faa in handle_one_connection /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
    #27 0x7f1437087493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
 
Thread T46 created by T0 here:
    #0 0x7f14372c0bba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
    #1 0x5562d54e63f7 in spawn_thread_noop /data/src/bb-10.2-compatibility/mysys/psi_noop.c:187
    #2 0x5562d3b6973f in inline_mysql_thread_create /data/src/bb-10.2-compatibility/include/mysql/psi/mysql_thread.h:1239
    #3 0x5562d3b7e644 in create_thread_to_handle_connection(CONNECT*) /data/src/bb-10.2-compatibility/sql/mysqld.cc:6447
    #4 0x5562d3b7ed49 in create_new_thread /data/src/bb-10.2-compatibility/sql/mysqld.cc:6517
    #5 0x5562d3b7fd5a in handle_connections_sockets() /data/src/bb-10.2-compatibility/sql/mysqld.cc:6792
    #6 0x5562d3b7db91 in mysqld_main(int, char**) /data/src/bb-10.2-compatibility/sql/mysqld.cc:6066
    #7 0x5562d3b67c6f in main /data/src/bb-10.2-compatibility/sql/main.cc:25
    #8 0x7f14353a52b0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202b0)
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/bb-10.2-compatibility/sql/sql_lex.h:1419 Query_tables_list::set_query_tables_list(Query_tables_list*)
Shadow bytes around the buggy address:
  0x0c4a8047e1e0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8047e1f0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8047e200: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8047e210: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
  0x0c4a8047e220: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
=>0x0c4a8047e230: fd fd[fd]fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8047e240: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8047e250: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8047e260: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8047e270: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
  0x0c4a8047e280: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
Shadow byte legend (one shadow byte represents 8 application bytes):
  Addressable:           00
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
  Heap right redzone:      fb
  Freed heap region:       fd
  Stack left redzone:      f1
  Stack mid redzone:       f2
  Stack right redzone:     f3
  Stack partial redzone:   f4
  Stack after return:      f5
  Stack use after scope:   f8
  Global redzone:          f9
  Global init order:       f6
  Poisoned by user:        f7
  Contiguous container OOB:fc
  ASan internal:           fe
==19983==ABORTING

Debug, gdb

#3  <signal handler called>
#4  0x0000563717d114ce in MDL_key::mdl_namespace (this=0x8f8f8f8f8f8f8faf) at /data/src/bb-10.2-compatibility/sql/mdl.h:320
#5  0x0000563717d04395 in open_and_process_routine (thd=0x7fbe60000b00, prelocking_ctx=0x7fbe608f1e80, rt=0x8f8f8f8f8f8f8f8f, prelocking_strategy=0x7fbed3899d20, has_prelocking_list=false, ot_ctx=0
x7fbed3899c10, need_prelocking=0x7fbed3899baf, routine_modifies_data=0x7fbed3899bb0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:3121
#6  0x0000563717d06037 in open_tables (thd=0x7fbe60000b00, options=..., start=0x7fbed3899c88, counter=0x7fbed3899ca4, flags=0, prelocking_strategy=0x7fbed3899d20) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4063
#7  0x0000563717d0768a in open_and_lock_tables (thd=0x7fbe60000b00, options=..., tables=0x0, derived=true, flags=0, prelocking_strategy=0x7fbed3899d20) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
#8  0x0000563717ccad2d in open_and_lock_tables (thd=0x7fbe60000b00, tables=0x0, derived=true, flags=0) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
#9  0x0000563717d7fce7 in Sql_cmd_call::execute (this=0x7fbe600814d8, thd=0x7fbe60000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
#10 0x0000563717d89e3d in mysql_execute_command (thd=0x7fbe60000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#11 0x0000563717cc1b26 in sp_instr_stmt::exec_core (this=0x7fbe600a5cc0, thd=0x7fbe60000b00, nextp=0x7fbed389b234) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
#12 0x0000563717cc1111 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fbe600a5d08, thd=0x7fbe60000b00, nextp=0x7fbed389b234, open_tables=false, instr=0x7fbe600a5cc0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
#13 0x0000563717cc17d1 in sp_instr_stmt::execute (this=0x7fbe600a5cc0, thd=0x7fbe60000b00, nextp=0x7fbed389b234) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
#14 0x0000563717cbb85f in sp_head::execute (this=0x7fbe6007f898, thd=0x7fbe60000b00, merge_da_on_success=true) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
#15 0x0000563717cbe090 in sp_head::execute_procedure (this=0x7fbe6007f898, thd=0x7fbe60000b00, args=0x7fbe60005530) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
#16 0x0000563717d7f414 in do_execute_sp (thd=0x7fbe60000b00, sp=0x7fbe6007f898) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
#17 0x0000563717d7fed8 in Sql_cmd_call::execute (this=0x7fbe60012e60, thd=0x7fbe60000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
#18 0x0000563717d89e3d in mysql_execute_command (thd=0x7fbe60000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
#19 0x0000563717d8e91c in mysql_parse (thd=0x7fbe60000b00, rawbuf=0x7fbe60011ce8 "CALL pkg.prx(CURRENT_TIMESTAMP)  /* QNO 301 CON_ID 16 */", length=75, parser_state=0x7fbed389d250, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
#20 0x0000563717d7c609 in dispatch_command (command=COM_QUERY, thd=0x7fbe60000b00, packet=0x7fbe60008b51 " CALL pkg.prx(CURRENT_TIMESTAMP)  /* QNO 301 CON_ID 16 */ ", packet_length=77, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
#21 0x0000563717d7af4d in do_command (thd=0x7fbe60000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
#22 0x0000563717ecbb94 in do_handle_one_connection (connect=0x5637268501e0) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
#23 0x0000563717ecb921 in handle_one_connection (arg=0x5637268501e0) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
#24 0x00007fc008c8c494 in start_thread (arg=0x7fbed389e700) at pthread_create.c:333
#25 0x00007fc00707293f in clone () from /lib/x86_64-linux-gnu/libc.so.6

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