Bug #75648 | Assertion `length <= max_data_length()' failed in Field_blob::store_to_mem | ||
---|---|---|---|
Submitted: | 27 Jan 2015 10:04 | Modified: | 27 Jan 2015 11:06 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6.21-debug, 5.6.24, 5.7.6 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any |
[27 Jan 2015 10:04]
Ramesh Sivaraman
[27 Jan 2015 11:06]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the report and test case. Observed that 5.6.24 debug build is affected. Thanks, Umesh
[27 Jan 2015 11:06]
MySQL Verification Team
// Build used commit: 3e1a0f1ef8c8a11a77f9e22677170c832ee13ca5 date: 2015-01-19 20:12:44 +0530 build-date: 2015-01-19 15:53:59 +0100 short: 3e1a0f1 branch: mysql-5.6 MySQL source 5.6.24 // snippet from error log mysqld-debug: /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/field.cc:7728: type_conversion_status Field_blob::store_to_mem(const char*, uint, const CHARSET_INFO*, ui nt, Blob_mem_storage*): Assertion `length <= max_data_length()' failed. 11:03:23 UTC - mysqld got signal 6 ; (gdb) bt #0 0x00007ffb60c75771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ade2df in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/mysys/stacktrace.c:422 #2 0x000000000074540e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007ffb5f87b5c9 in raise () from /lib64/libc.so.6 #5 0x00007ffb5f87ccd8 in abort () from /lib64/libc.so.6 #6 0x00007ffb5f874536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007ffb5f8745e2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000936e1c in Field_blob::store_to_mem (this=0x7ffb0801ad78, from=0x7ffb080a5500 "", length=100000, cs=0x1844f20 <my_charset_utf16_danish_uca_ci>, max_length=1024, blob_storage=0x7ffb0801deb0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/field.cc:7728 #9 0x0000000000936fdd in Field_blob::store (this=0x7ffb0801ad78, from=0x7ffb080a5500 "", length=100000, cs=0x1844f20 <my_charset_utf16_danish_uca_ci>) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/field.cc:7839 #10 0x0000000000668c57 in Item::save_in_field (this=0x7ffb08006720, field=0x7ffb0801ad78, no_conversions=true) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item.cc:6307 #11 0x000000000067cec7 in Item_result_field::save_in_result_field (this=0x7ffb08006720, no_conversions=true) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item.h:3112 #12 0x00000000007c4e8b in copy_funcs (func_ptr=0x7ffb08018dd0, thd=0x36e2f50) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:553 #13 0x00000000007009e1 in Item_func_group_concat::add (this=0x7ffb080055e0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item_sum.cc:3384 #14 0x0000000000709098 in Aggregator_simple::add (this=0x7ffb08006ee0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item_sum.h:656 #15 0x0000000000708f12 in Item_sum::aggregator_add (this=0x7ffb080055e0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item_sum.h:500 #16 0x0000000000708f36 in Item_sum::reset_and_add (this=0x7ffb080055e0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/item_sum.h:408 #17 0x00000000007c4dbe in init_sum_functions (func_ptr=0x7ffb08006848, end_ptr=0x7ffb08006850) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:508 #18 0x00000000007ca036 in end_send_group (join=0x7ffb08006128, join_tab=0x7ffb0801da60, end_of_records=false) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:2961 #19 0x00000000007c8f10 in evaluate_join_record (join=0x7ffb08006128, join_tab=0x7ffb0801d760) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:1601 #20 0x00000000007cd160 in sub_select (join=0x7ffb08006128, join_tab=0x7ffb0801d760, end_of_records=false) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:1276 #21 0x00000000007cea0b in do_select (join=0x7ffb08006128) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:933 #22 0x00000000007cf317 in JOIN::exec (this=0x7ffb08006128) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_executor.cc:194 #23 0x0000000000831960 in mysql_execute_select (thd=0x36e2f50, select_lex=0x36e57d0, free_join=true) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_select.cc:1100 #24 0x000000000083231f in mysql_select (thd=0x36e2f50, tables=0x7ffb08005ae8, wild_num=0, fields=..., conds=0x0, order=0x36e5998, group=0x36e58d0, having=0x0, select_options=2147748608, result=0x7ffb08006100, unit=0x36e5188, select_lex=0x36e57d0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_select.cc:1221 #25 0x000000000083251b in handle_select (thd=0x36e2f50, result=0x7ffb08006100, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_select.cc:110 #26 0x00000000007f86ac in execute_sqlcom_select (thd=0x36e2f50, all_tables=0x7ffb08005ae8) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_parse.cc:5103 #27 0x00000000007f9bd7 in mysql_execute_command (thd=0x36e2f50) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_parse.cc:2649 #28 0x0000000000801175 in mysql_parse (thd=0x36e2f50, rawbuf=0x7ffb08004fd0 "SELECT GROUP_CONCAT(DISTINCT b,a ORDER BY a,b)FROM t1", length=53, parser_state=0x7ffb3663e700) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_parse.cc:6357 #29 0x0000000000802d1f in dispatch_command (command=COM_QUERY, thd=0x36e2f50, packet=0x3810fb1 "", packet_length=53) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_parse.cc:1332 #30 0x0000000000804559 in do_command (thd=0x36e2f50) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_parse.cc:1034 #31 0x00000000007ba34d in do_handle_one_connection (thd_arg=0x36e2f50) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_connect.cc:982 #32 0x00000000007ba413 in handle_one_connection (arg=0x36e2f50) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/sql/sql_connect.cc:898 #33 0x0000000000b90202 in pfs_spawn_thread (arg=0x3708470) at /export/home/pb2/build/sb_0-14137409-1421680653.55/mysqlcom-pro-5.6.24/storage/perfschema/pfs.cc:1860 #34 0x00007ffb60c70df3 in start_thread () from /lib64/libpthread.so.0 #35 0x00007ffb5f93c47d in clone () from /lib64/libc.so.6
[27 Jan 2015 11:10]
MySQL Verification Team
// build details commit: 7d93e60fbb5f03364c8c40386dcc979138fe956c date: 2015-01-19 20:14:13 +0530 build-date: 2015-01-19 17:02:01 +0100 short: 7d93e60 branch: mysql-trunk MySQL source 5.7.6 (gdb) bt #0 0x00007f5d2319b771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000fedc88 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247 #2 0x0000000000980532 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007f5d21da15c9 in raise () from /lib64/libc.so.6 #5 0x00007f5d21da2cd8 in abort () from /lib64/libc.so.6 #6 0x00007f5d21d9a536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f5d21d9a5e2 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000009c114c in Field_blob::store_to_mem (this=0x7f5ca803f600, from=0x7f5ca808c990 "", length=100000, cs=0x218f6c0 <my_charset_utf16_danish_uca_ci>, max_length=1024, blob_storage=0x7f5ca80291b0) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/field.cc:7860 #9 0x00000000009c1687 in Field_blob::store (this=0x7f5ca803f600, from=0x7f5ca808c990 "", length=100000, cs=0x218f6c0 <my_charset_utf16_danish_uca_ci>) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/field.cc:7961 #10 0x0000000000a0d1f6 in Item::save_in_field (this=0x7f5ca8028470, field=0x7f5ca803f600, no_conversions=true) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item.cc:6369 #11 0x0000000000a1b6c1 in Item_result_field::save_in_result_field (this=0x7f5ca8028470, no_conversions=true) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item.h:3634 #12 0x0000000000cc77d2 in copy_funcs (func_ptr=0x7f5ca803f520, thd=0x7f5ca8000c00) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:557 #13 0x0000000000c136e8 in Item_func_group_concat::add (this=0x7f5ca8006058) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item_sum.cc:3502 #14 0x0000000000c157d3 in Aggregator_simple::add (this=0x7f5ca8028f68) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item_sum.h:665 #15 0x0000000000c1565f in Item_sum::aggregator_add (this=0x7f5ca8006058) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item_sum.h:509 #16 0x0000000000c154c4 in Item_sum::reset_and_add (this=0x7f5ca8006058) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/item_sum.h:413 #17 0x0000000000cc76ea in init_sum_functions (func_ptr=0x7f5ca8028950, end_ptr=0x7f5ca8028958) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:512 #18 0x0000000000ccd323 in end_send_group (join=0x7f5ca8028580, qep_tab=0x7f5ca8028de8, end_of_records=false) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:3033 #19 0x0000000000cc99e3 in evaluate_join_record (join=0x7f5ca8028580, qep_tab=0x7f5ca8028c70) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:1617 #20 0x0000000000cc8e44 in sub_select (join=0x7f5ca8028580, qep_tab=0x7f5ca8028c70, end_of_records=false) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:1279 #21 0x0000000000cc86b0 in do_select (join=0x7f5ca8028580) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:932 #22 0x0000000000cc6631 in JOIN::exec (this=0x7f5ca8028580) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_executor.cc:197 #23 0x0000000000d48e39 in handle_query (thd=0x7f5ca8000c00, lex=0x7f5ca8002ec0, result=0x7f5ca8007260, added_options=0, removed_options=0) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_select.cc:180 #24 0x0000000000d12e0e in execute_sqlcom_select (thd=0x7f5ca8000c00, all_tables=0x7f5ca8006c28) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:4983 #25 0x0000000000d0baf5 in mysql_execute_command (thd=0x7f5ca8000c00) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:2486 #26 0x0000000000d13d33 in mysql_parse (thd=0x7f5ca8000c00, parser_state=0x7f5d0cc84e50) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5384 #27 0x0000000000d08b53 in dispatch_command (command=COM_QUERY, thd=0x7f5ca8000c00, packet=0x7f5ca8009961 "", packet_length=53) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1245 #28 0x0000000000d078a2 in do_command (thd=0x7f5ca8000c00) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:832 #29 0x0000000000e12768 in handle_connection (arg=0x322b210) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298 #30 0x0000000001027637 in pfs_spawn_thread (arg=0x3263d90) at /export/home/pb2/build/sb_0-14139055-1421684443.33/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137 #31 0x00007f5d23196df3 in start_thread () from /lib64/libpthread.so.0 #32 0x00007f5d21e6247d in clone () from /lib64/libc.so.6
[27 Jan 2015 11:12]
MySQL Verification Team
// 5.7.6 debug build affected