Bug #79801 handle_fatal_signal (sig=6) in Item_func_sp::val_json
Submitted: 29 Dec 2015 10:26 Modified: 10 May 2017 1:26
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: JSON Severity:S6 (Debug Builds)
Version:5.7.10, 5.7.11, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[29 Dec 2015 10:26] Roel Van de Paar
Description:
2015-12-29T10:12:31.645820Z 0 [Note] /sdc/MS-mysql-5.7.10-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.10-debug'  socket: '/sdc/MS-mysql-5.7.10-linux-x86_64-debug/socket.sock'  port: 10357  MySQL Community Server (GPL)
10:14:57 UTC - mysqld got signal 6 ;

+bt
#0  0x00007fd044590771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x00000000017ef4b0 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000e58274 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fd04292a5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007fd04292bcc8 in __GI_abort () at abort.c:90
#6  0x0000000000f77160 in Item_func_sp::val_json (this=0x7fcf7742c3f0, result=0x7fd044b81f00) at /git/mysql-server_dbg/sql/item_func.cc:8431
#7  0x0000000000f5e332 in Item_func::save_possibly_as_json (this=0x7fcf7742c3f0, field=0x7fcf774aa830, no_conversions=false) at /git/mysql-server_dbg/sql/item_func.cc:606
#8  0x0000000000f77198 in Item_func_sp::save_in_field_inner (this=0x7fcf7742c3f0, field=0x7fcf774aa830, no_conversions=false) at /git/mysql-server_dbg/sql/item_func.cc:8441
#9  0x0000000000efae3a in Item::save_in_field (this=0x7fcf7742c3f0, field=0x7fcf774aa830, no_conversions=false) at /git/mysql-server_dbg/sql/item.cc:6723
#10 0x000000000146bed2 in fill_record (thd=0x7fcf77419000, table=0x7fcf7745ba20, ptr=0x7fcf774aaf48, values=..., bitmap=0x0, insert_into_fields_bitmap=0x0) at /git/mysql-server_dbg/sql/sql_base.cc:9456
#11 0x000000000146c1a7 in fill_record_n_invoke_before_triggers (thd=0x7fcf77419000, ptr=0x7fcf774aaf40, values=..., table=0x7fcf7745ba20, event=TRG_EVENT_INSERT, num_fields=1) at /git/mysql-server_dbg/sql/sql_base.cc:9538
#12 0x00000000016e6530 in Query_result_insert::store_values (this=0x7fcf7742ccb0, values=...) at /git/mysql-server_dbg/sql/sql_insert.cc:2297
#13 0x00000000016e61ae in Query_result_insert::send_data (this=0x7fcf7742ccb0, values=...) at /git/mysql-server_dbg/sql/sql_insert.cc:2228
#14 0x000000000149a4da in JOIN::exec (this=0x7fcf774a3390) at /git/mysql-server_dbg/sql/sql_executor.cc:158
#15 0x00000000015339ca in handle_query (thd=0x7fcf77419000, lex=0x7fcf7741b2e8, result=0x7fcf7742ccb0, added_options=1342177280, removed_options=0) at /git/mysql-server_dbg/sql/sql_select.cc:184
#16 0x00000000016e8dc5 in Sql_cmd_insert_select::execute (this=0x7fcf7742c758, thd=0x7fcf77419000) at /git/mysql-server_dbg/sql/sql_insert.cc:3180
#17 0x00000000014e5b0f in mysql_execute_command (thd=0x7fcf77419000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3510
#18 0x00000000014eb36d in mysql_parse (thd=0x7fcf77419000, parser_state=0x7fd044b83560) at /git/mysql-server_dbg/sql/sql_parse.cc:5508
#19 0x00000000014e0ca7 in dispatch_command (thd=0x7fcf77419000, com_data=0x7fd044b83cb0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1425
#20 0x00000000014dfb71 in do_command (thd=0x7fcf77419000) at /git/mysql-server_dbg/sql/sql_parse.cc:993
#21 0x000000000160ad5b in handle_connection (arg=0x7fcf90b8d820) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#22 0x000000000181b8fc in pfs_spawn_thread (arg=0x7fcf90fe8020) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#23 0x00007fd04458bdf5 in start_thread (arg=0x7fd044b84700) at pthread_create.c:308
#24 0x00007fd0429eb1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t2(j2 JSON);
CREATE FUNCTION f1(a int)RETURNS INT RETURN a;
insert into t2 select f1(3);
[29 Dec 2015 10:49] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that 5.7.11 debug build is affected.

Thanks,
Umesh
[20 Jan 2016 13:12] Jon Stephens
Fixed in 5.8.0.

Internal changes/debugging only. No changelog entry needed. Closed.
[18 Jun 2016 21:35] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0
[10 May 2017 1:26] Roel Van de Paar
Please fix in 5.7 also, ref bug 86249