MySQL Bugs: #79417: handle_fatal_signal (sig=11) in st_select_lex::make_active

Bug #79417	handle_fatal_signal (sig=11) in st_select_lex::make_active_options
Submitted:	26 Nov 2015 6:49	Modified:	28 Nov 2019 22:10
Reporter:	Roel Van de Paar	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S6 (Debug Builds)
Version:	5.7.9 GA, 5.7.11	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	debug

Description:
2015-11-26T06:37:35.554084Z 0 [Note] /sda/MS-mysql-5.7.9-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.9-debug'  socket: '/sda/MS-mysql-5.7.9-linux-x86_64-debug/socket.sock'  port: 15079  MySQL Community Server (GPL)
06:37:46 UTC - mysqld got signal 11 ;

+bt
#0  0x00007f54835bf771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001796a78 in my_write_core (sig=11) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000e1dc70 in handle_fatal_signal (sig=11) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x000000000145a94f in st_select_lex::make_active_options (this=0x7f53b894f030, added_options=268435456, removed_options=0) at /git/mysql-server_dbg/sql/sql_lex.cc:2492
#5  0x000000000153b12d in st_select_lex_unit::prepare (this=0x7f53b894f310, thd_arg=0x7f53b8819000, sel_result=0x7f53b89e4030, added_options=0, removed_options=0) at /git/mysql-server_dbg/sql/sql_union.cc:496
#6  0x000000000143f36f in TABLE_LIST::resolve_derived (this=0x7f53b8946a00, thd=0x7f53b8819000, apply_semijoin=true) at /git/mysql-server_dbg/sql/sql_derived.cc:70
#7  0x00000000014d2bf1 in st_select_lex::resolve_derived (this=0x7f53b89460d0, thd=0x7f53b8819000, apply_semijoin=true) at /git/mysql-server_dbg/sql/sql_resolver.cc:850
#8  0x00000000014d0d23 in st_select_lex::prepare (this=0x7f53b89460d0, thd=0x7f53b8819000) at /git/mysql-server_dbg/sql/sql_resolver.cc:127
#9  0x0000000001353343 in subselect_single_select_engine::prepare (this=0x7f53b89470c0) at /git/mysql-server_dbg/sql/item_subselect.cc:2907
#10 0x000000000134b5dc in Item_subselect::fix_fields (this=0x7f53b8946f98, thd=0x7f53b8819000, ref=0x7f53b89471d0) at /git/mysql-server_dbg/sql/item_subselect.cc:381
#11 0x00000000013e0e25 in sp_prepare_func_item (thd=0x7f53b8819000, it_addr=0x7f53b89471d0) at /git/mysql-server_dbg/sql/sp.cc:2670
#12 0x00000000013e0f22 in sp_eval_expr (thd=0x7f53b8819000, result_field=0x7f53b88a4708, expr_item_ptr=0x7f53b89471d0) at /git/mysql-server_dbg/sql/sp.cc:2705
#13 0x00000000013f4b55 in sp_rcontext::set_return_value (this=0x7f53b894d030, thd=0x7f53b8819000, return_value_item=0x7f53b89471d0) at /git/mysql-server_dbg/sql/sp_rcontext.cc:157
#14 0x00000000013ed641 in sp_instr_freturn::exec_core (this=0x7f53b8947108, thd=0x7f53b8819000, nextp=0x7f5483bb5868) at /git/mysql-server_dbg/sql/sp_instr.cc:1332
#15 0x00000000013eb21b in sp_lex_instr::reset_lex_and_exec_core (this=0x7f53b8947108, thd=0x7f53b8819000, nextp=0x7f5483bb5868, open_tables=true) at /git/mysql-server_dbg/sql/sp_instr.cc:364
#16 0x00000000013ebe11 in sp_lex_instr::validate_lex_and_execute_core (this=0x7f53b8947108, thd=0x7f53b8819000, nextp=0x7f5483bb5868, open_tables=true) at /git/mysql-server_dbg/sql/sp_instr.cc:666
#17 0x00000000013eed20 in sp_lex_instr::execute (this=0x7f53b8947108, thd=0x7f53b8819000, nextp=0x7f5483bb5868) at /git/mysql-server_dbg/sql/sp_instr.h:300
#18 0x00000000013e4a04 in sp_head::execute (this=0x7f53b893c030, thd=0x7f53b8819000, merge_da_on_success=true) at /git/mysql-server_dbg/sql/sp_head.cc:789
#19 0x00000000013e5da0 in sp_head::execute_function (this=0x7f53b893c030, thd=0x7f53b8819000, argp=0x7f53b882c1b8, argcount=0, return_value_fld=0x7f53b88a4708) at /git/mysql-server_dbg/sql/sp_head.cc:1280
#20 0x0000000000f33038 in Item_func_sp::execute_impl (this=0x7f53b882c110, thd=0x7f53b8819000) at /git/mysql-server_dbg/sql/item_func.cc:8534
#21 0x0000000000f32db8 in Item_func_sp::execute (this=0x7f53b882c110) at /git/mysql-server_dbg/sql/item_func.cc:8465
#22 0x0000000000f36a56 in Item_func_sp::val_int (this=0x7f53b882c110) at /git/mysql-server_dbg/sql/item_func.h:2710
#23 0x0000000000eb784c in Item::save_in_field_inner (this=0x7f53b882c110, field=0x7f53b88adf40, no_conversions=false) at /git/mysql-server_dbg/sql/item.cc:6832
#24 0x0000000000f19fcd in Item_func::save_possibly_as_json (this=0x7f53b882c110, field=0x7f53b88adf40, no_conversions=false) at /git/mysql-server_dbg/sql/item_func.cc:617
#25 0x0000000000f32d42 in Item_func_sp::save_in_field_inner (this=0x7f53b882c110, field=0x7f53b88adf40, no_conversions=false) at /git/mysql-server_dbg/sql/item_func.cc:8422
#26 0x0000000000eb6f10 in Item::save_in_field (this=0x7f53b882c110, field=0x7f53b88adf40, no_conversions=false) at /git/mysql-server_dbg/sql/item.cc:6702
#27 0x0000000001415e65 in fill_record (thd=0x7f53b8819000, table=0x7f53b885d620, ptr=0x7f53b88adf38, values=..., bitmap=0x0, insert_into_fields_bitmap=0x0) at /git/mysql-server_dbg/sql/sql_base.cc:9419
#28 0x000000000141618a in fill_record_n_invoke_before_triggers (thd=0x7f53b8819000, ptr=0x7f53b88adf30, values=..., table=0x7f53b885d620, event=TRG_EVENT_INSERT, num_fields=1) at /git/mysql-server_dbg/sql/sql_base.cc:9509
#29 0x0000000001689f8e in Sql_cmd_insert::mysql_insert (this=0x7f53b882c468, thd=0x7f53b8819000, table_list=0x7f53b882bb80) at /git/mysql-server_dbg/sql/sql_insert.cc:760
#30 0x0000000001690684 in Sql_cmd_insert::execute (this=0x7f53b882c468, thd=0x7f53b8819000) at /git/mysql-server_dbg/sql/sql_insert.cc:3080
#31 0x000000000148eaa7 in mysql_execute_command (thd=0x7f53b8819000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3359
#32 0x0000000001494305 in mysql_parse (thd=0x7f53b8819000, parser_state=0x7f5483bb8670) at /git/mysql-server_dbg/sql/sql_parse.cc:5357
#33 0x0000000001489caa in dispatch_command (thd=0x7f53b8819000, com_data=0x7f5483bb8dc0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1284
#34 0x0000000001488b76 in do_command (thd=0x7f53b8819000) at /git/mysql-server_dbg/sql/sql_parse.cc:852
#35 0x00000000015b2cdb in handle_connection (arg=0x7f53c0bff240) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:295
#36 0x00000000017c3aa0 in pfs_spawn_thread (arg=0x7f53d1be7820) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#37 0x00007f54835badf5 in start_thread (arg=0x7f5483bb9700) at pthread_create.c:308
#38 0x00007f54822841ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE FUNCTION f1()RETURNS INT RETURN (SELECT * FROM v1);
CREATE VIEW v1(f1,f2,f3,f4)AS SELECT connection_id(),pi(),current_user(),version();
RENAME USER CURRENT_USER TO 'bug48321_2'@0;
CREATE TABLE t1(c1 INT);
INSERT INTO t1 VALUES(f1());
INSERT INTO t1 VALUES(f1());

Hello Roel,

Thank you for the report and test case.
Observed that 5.7.9/5.7.11 debug builds are affected.

Thanks,
Umesh

// 5.7.9  only debug uild affected
rm -rf 79417
bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-5.7.9 --datadir=/export/umesh/server/binaries/mysql-5.7.9/79417 -v
bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.7.9 --datadir=/export/umesh/server/binaries/mysql-5.7.9/79417 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.9/79417/log.err 2>&1 &

(gdb) bt
#0  0x00007f70cec30771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000001803885 in my_write_core (sig=11) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/mysys/stacktrace.c:247
#2  0x0000000000e45850 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00000000014b46ed in st_select_lex::make_active_options (this=0x7f70609dcb70, added_options=268435456, removed_options=0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_lex.cc:2494
#5  0x0000000001599fda in st_select_lex_unit::prepare (this=0x7f70609dce50, thd_arg=0x7f706001a3e0, sel_result=0x7f70609deb80, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_union.cc:496
#6  0x00000000014986fe in TABLE_LIST::resolve_derived (this=0x7f7060960ff0, thd=0x7f706001a3e0, apply_semijoin=true)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_derived.cc:70
#7  0x000000000152efe1 in st_select_lex::resolve_derived (this=0x7f70609606c0, thd=0x7f706001a3e0, apply_semijoin=true)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_resolver.cc:850
#8  0x000000000152d04c in st_select_lex::prepare (this=0x7f70609606c0, thd=0x7f706001a3e0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_resolver.cc:127
#9  0x00000000013a8060 in subselect_single_select_engine::prepare (this=0x7f70609616b0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_subselect.cc:2907
#10 0x000000000139fec1 in Item_subselect::fix_fields (this=0x7f7060961588, thd=0x7f706001a3e0, ref=0x7f70609617c0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_subselect.cc:381
#11 0x0000000001438552 in sp_prepare_func_item (thd=0x7f706001a3e0, it_addr=0x7f70609617c0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp.cc:2669
#12 0x0000000001438655 in sp_eval_expr (thd=0x7f706001a3e0, result_field=0x7f70609d91f8, expr_item_ptr=0x7f70609617c0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp.cc:2705
#13 0x000000000144ca0b in sp_rcontext::set_return_value (this=0x7f70609dab60, thd=0x7f706001a3e0, return_value_item=0x7f70609617c0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_rcontext.cc:157
#14 0x00000000014452c9 in sp_instr_freturn::exec_core (this=0x7f70609616f8, thd=0x7f706001a3e0, nextp=0x7f70a1637198)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_instr.cc:1332
#15 0x0000000001442e1d in sp_lex_instr::reset_lex_and_exec_core (this=0x7f70609616f8, thd=0x7f706001a3e0, nextp=0x7f70a1637198, open_tables=true)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_instr.cc:364
#16 0x0000000001443a73 in sp_lex_instr::validate_lex_and_execute_core (this=0x7f70609616f8, thd=0x7f706001a3e0, nextp=0x7f70a1637198, open_tables=true)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_instr.cc:666
#17 0x0000000001446a34 in sp_lex_instr::execute (this=0x7f70609616f8, thd=0x7f706001a3e0, nextp=0x7f70a1637198)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_instr.h:300
#18 0x000000000143c2c6 in sp_head::execute (this=0x7f706095a5a0, thd=0x7f706001a3e0, merge_da_on_success=true)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_head.cc:789
#19 0x000000000143d790 in sp_head::execute_function (this=0x7f706095a5a0, thd=0x7f706001a3e0, argp=0x7f7060020058, argcount=0, return_value_fld=0x7f70609d91f8)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sp_head.cc:1280
#20 0x0000000000f5fc9b in Item_func_sp::execute_impl (this=0x7f706001ffb0, thd=0x7f706001a3e0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_func.cc:8534
#21 0x0000000000f5fa13 in Item_func_sp::execute (this=0x7f706001ffb0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_func.cc:8465
#22 0x0000000000f636c6 in Item_func_sp::val_int (this=0x7f706001ffb0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_func.h:2710
#23 0x0000000000ee192d in Item::save_in_field_inner (this=0x7f706001ffb0, field=0x7f70600537f0, no_conversions=false)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item.cc:6832
#24 0x0000000000f46d8b in Item_func::save_possibly_as_json (this=0x7f706001ffb0, field=0x7f70600537f0, no_conversions=false)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_func.cc:617
#25 0x0000000000f5f992 in Item_func_sp::save_in_field_inner (this=0x7f706001ffb0, field=0x7f70600537f0, no_conversions=false)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item_func.cc:8422
#26 0x0000000000ee0fe8 in Item::save_in_field (this=0x7f706001ffb0, field=0x7f70600537f0, no_conversions=false)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/item.cc:6702
#27 0x000000000146e499 in fill_record (thd=0x7f706001a3e0, table=0x7f7060052b30, ptr=0x7f70600537e8, values=..., bitmap=0x0, insert_into_fields_bitmap=0x0)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_base.cc:9419
#28 0x000000000146e7ce in fill_record_n_invoke_before_triggers (thd=0x7f706001a3e0, ptr=0x7f70600537e0, values=..., table=0x7f7060052b30, event=TRG_EVENT_INSERT, num_fields=1)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_base.cc:9509
#29 0x00000000016f3b72 in Sql_cmd_insert::mysql_insert (this=0x7f7060020308, thd=0x7f706001a3e0, table_list=0x7f706001fa20)
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_insert.cc:760
#30 0x00000000016fa4ad in Sql_cmd_insert::execute (this=0x7f7060020308, thd=0x7f706001a3e0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_insert.cc:3080
#31 0x00000000014e9d0d in mysql_execute_command (thd=0x7f706001a3e0, first_level=true) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_parse.cc:3359
#32 0x00000000014efd25 in mysql_parse (thd=0x7f706001a3e0, parser_state=0x7f70a163a6a0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_parse.cc:5357
#33 0x00000000014e4930 in dispatch_command (thd=0x7f706001a3e0, com_data=0x7f70a163ae10, command=COM_QUERY)
---Type <return> to continue, or q <return> to quit---
    at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_parse.cc:1284
#34 0x00000000014e37ea in do_command (thd=0x7f706001a3e0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/sql_parse.cc:852
#35 0x0000000001613d77 in handle_connection (arg=0x47f8820) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/sql/conn_handler/connection_handler_per_thread.cc:295
#36 0x000000000188fd80 in pfs_spawn_thread (arg=0x493c7f0) at /export/home/pb2/build/sb_0-16729453-1444633651.02/mysql-5.7.9/storage/perfschema/pfs.cc:2192
#37 0x00007f70cec2bdf5 in start_thread () from /lib64/libpthread.so.0
#38 0x00007f70cd8f760d in clone () from /lib64/libc.so.6
(gdb)

// 5.7.11 - only debug uild affected

rm -rf 79417
bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.11 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.11/79417 -v
bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.11 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.11/79417 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.11/79417/log.err 2>&1 &

(gdb) bt
#0  0x00007f3411778771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018a36cd in my_write_core (sig=11) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/mysys/stacktrace.c:247
#2  0x0000000000ebbe1c in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x0000000001550f65 in st_select_lex::make_active_options (this=0x7f33909cc060, added_options=268435456, removed_options=0)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_lex.cc:2494
#5  0x0000000001637ef2 in st_select_lex_unit::prepare (this=0x7f33909cc340, thd_arg=0x7f3390000b70, sel_result=0x7f33909ce070, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_union.cc:500
#6  0x0000000001534fa2 in TABLE_LIST::resolve_derived (this=0x7f339094f858, thd=0x7f3390000b70, apply_semijoin=true)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_derived.cc:70
#7  0x00000000015cc9d9 in st_select_lex::resolve_derived (this=0x7f339094ef40, thd=0x7f3390000b70, apply_semijoin=true)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_resolver.cc:850
#8  0x00000000015caa44 in st_select_lex::prepare (this=0x7f339094ef40, thd=0x7f3390000b70) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_resolver.cc:127
#9  0x0000000001445120 in subselect_single_select_engine::prepare (this=0x7f339094ff08) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_subselect.cc:2922
#10 0x000000000143cf41 in Item_subselect::fix_fields (this=0x7f339094fde0, thd=0x7f3390000b70, ref=0x7f3390950018)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_subselect.cc:382
#11 0x00000000014d524a in sp_prepare_func_item (thd=0x7f3390000b70, it_addr=0x7f3390950018) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp.cc:2669
#12 0x00000000014d534d in sp_eval_expr (thd=0x7f3390000b70, result_field=0x7f33909c86b0, expr_item_ptr=0x7f3390950018)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp.cc:2705
#13 0x00000000014e9703 in sp_rcontext::set_return_value (this=0x7f33909ca050, thd=0x7f3390000b70, return_value_item=0x7f3390950018)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_rcontext.cc:157
#14 0x00000000014e1fc1 in sp_instr_freturn::exec_core (this=0x7f339094ff50, thd=0x7f3390000b70, nextp=0x7f33e4166188)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_instr.cc:1349
#15 0x00000000014dfafa in sp_lex_instr::reset_lex_and_exec_core (this=0x7f339094ff50, thd=0x7f3390000b70, nextp=0x7f33e4166188, open_tables=true)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_instr.cc:373
#16 0x00000000014e0775 in sp_lex_instr::validate_lex_and_execute_core (this=0x7f339094ff50, thd=0x7f3390000b70, nextp=0x7f33e4166188, open_tables=true)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_instr.cc:676
#17 0x00000000014e372c in sp_lex_instr::execute (this=0x7f339094ff50, thd=0x7f3390000b70, nextp=0x7f33e4166188)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_instr.h:300
#18 0x00000000014d8fbe in sp_head::execute (this=0x7f3390948e20, thd=0x7f3390000b70, merge_da_on_success=true)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_head.cc:789
#19 0x00000000014da488 in sp_head::execute_function (this=0x7f3390948e20, thd=0x7f3390000b70, argp=0x7f33900066e8, argcount=0, return_value_fld=0x7f33909c86b0)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sp_head.cc:1280
#20 0x0000000000fe0d43 in Item_func_sp::execute_impl (this=0x7f3390006640, thd=0x7f3390000b70) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_func.cc:8594
#21 0x0000000000fe0abb in Item_func_sp::execute (this=0x7f3390006640) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_func.cc:8525
#22 0x0000000000fe476e in Item_func_sp::val_int (this=0x7f3390006640) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_func.h:2717
#23 0x0000000000f62123 in Item::save_in_field_inner (this=0x7f3390006640, field=0x7f3390048780, no_conversions=false)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item.cc:6853
#24 0x0000000000fc7b97 in Item_func::save_possibly_as_json (this=0x7f3390006640, field=0x7f3390048780, no_conversions=false)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_func.cc:618
#25 0x0000000000fe0a3a in Item_func_sp::save_in_field_inner (this=0x7f3390006640, field=0x7f3390048780, no_conversions=false)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item_func.cc:8482
#26 0x0000000000f617de in Item::save_in_field (this=0x7f3390006640, field=0x7f3390048780, no_conversions=false)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/item.cc:6723
#27 0x000000000150af81 in fill_record (thd=0x7f3390000b70, table=0x7f339003fd70, ptr=0x7f3390048778, values=..., bitmap=0x0, insert_into_fields_bitmap=0x0)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_base.cc:9429
#28 0x000000000150b269 in fill_record_n_invoke_before_triggers (thd=0x7f3390000b70, ptr=0x7f3390048770, values=..., table=0x7f339003fd70, event=TRG_EVENT_INSERT, num_fields=1)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_base.cc:9511
#29 0x0000000001792d08 in Sql_cmd_insert::mysql_insert (this=0x7f3390006998, thd=0x7f3390000b70, table_list=0x7f33900060b0)
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_insert.cc:762
#30 0x0000000001799643 in Sql_cmd_insert::execute (this=0x7f3390006998, thd=0x7f3390000b70) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_insert.cc:3082
#31 0x00000000015876bb in mysql_execute_command (thd=0x7f3390000b70, first_level=true) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_parse.cc:3516
#32 0x000000000158d6d3 in mysql_parse (thd=0x7f3390000b70, parser_state=0x7f33e4169690) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_parse.cc:5514
#33 0x00000000015821fc in dispatch_command (thd=0x7f3390000b70, com_data=0x7f33e4169e00, command=COM_QUERY)
---Type <return> to continue, or q <return> to quit---
    at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_parse.cc:1425
#34 0x00000000015810b4 in do_command (thd=0x7f3390000b70) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/sql_parse.cc:993
#35 0x00000000016b29f3 in handle_connection (arg=0x3e9c310) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/sql/conn_handler/connection_handler_per_thread.cc:301
#36 0x000000000192ef8c in pfs_spawn_thread (arg=0x4009b60) at /export/home/pb2/build/sb_0-17148744-1448296996.98/mysqlcom-pro-5.7.11/storage/perfschema/pfs.cc:2192
#37 0x00007f3411773df5 in start_thread () from /lib64/libpthread.so.0
#38 0x00007f341043f60d in clone () from /lib64/libc.so.6
(gdb)

// 5.6.27 debug/release not affected

Posted by developer:
 
Not reproducible in 5.7.29