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 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
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.045 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: ** GDB info #0 0x00007f4ef9ba7771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000a954ea in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422 #2 0x0000000000726494 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f4ef89b35c9 in raise () from /lib64/libc.so.6 #5 0x00007f4ef89b4cd8 in abort () from /lib64/libc.so.6 #6 0x00007f4ef89ac536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f4ef89ac5e2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000905579 in Field_blob::store_to_mem (this=0x7f4e5cc990b8, from=0x7f4e5cdd3000 "", length=100000, cs=0x1733ae0 <my_charset_utf16_danish_ uca_ci>, max_length=1024, blob_storage=0x7f4e5cd558e0) at /ssd/ramesh/mysql-server/mysql-5.6/sql/field.cc:7728 #9 0x0000000000905aea in Field_blob::store (this=0x7f4e5cc990b8, from=0x7f4e5cdd3000 "", length=100000, cs=0x1733ae0 <my_charset_utf16_danish_uca_ci>) at /ssd/ramesh/mysql-server/mysql-5.6/sql/field.cc:7839 #10 0x000000000065e0d0 in Item::save_in_field (this=0x7f4e5cc20760, field=0x7f4e5cc990b8, no_conversions=true) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item.cc:6288 #11 0x000000000066ce03 in Item_result_field::save_in_result_field (this=0x7f4e5cc20760, no_conversions=true) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item.h:3112 #12 0x00000000007a1eea in copy_funcs (func_ptr=0x7f4e5cc95c60, thd=0x7f4e6675d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:553 #13 0x00000000006ea270 in Item_func_group_concat::add (this=0x7f4e5cc1f620) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item_sum.cc:3384 #14 0x00000000006ebfed in Aggregator_simple::add (this=0x7f4e5cc20f20) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item_sum.h:656 #15 0x00000000006ebe79 in Item_sum::aggregator_add (this=0x7f4e5cc1f620) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item_sum.h:500 #16 0x00000000006ebcc4 in Item_sum::reset_and_add (this=0x7f4e5cc1f620) at /ssd/ramesh/mysql-server/mysql-5.6/sql/item_sum.h:408 #17 0x00000000007a1e24 in init_sum_functions (func_ptr=0x7f4e5cc20888, end_ptr=0x7f4e5cc20890) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:508 #18 0x00000000007a72c6 in end_send_group (join=0x7f4e5cc20168, join_tab=0x7f4e5cd55490, end_of_records=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:2961 #19 0x00000000007a3f6e in evaluate_join_record (join=0x7f4e5cc20168, join_tab=0x7f4e5cd55190) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:1601 #20 0x00000000007a3550 in sub_select (join=0x7f4e5cc20168, join_tab=0x7f4e5cd55190, end_of_records=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:1276 #21 0x00000000007a2e1d in do_select (join=0x7f4e5cc20168) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:933 #22 0x00000000007a0d79 in JOIN::exec (this=0x7f4e5cc20168) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_executor.cc:194 #23 0x0000000000800fa7 in mysql_execute_select (thd=0x7f4e6675d000, select_lex=0x7f4e6675f878, free_join=true) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_select.cc:1100 #24 0x00000000008012a3 in mysql_select (thd=0x7f4e6675d000, tables=0x7f4e5cc1fb28, wild_num=0, fields=..., conds=0x0, order=0x7f4e6675fa40, group=0x7f4e6675f978, having=0x0, select_options=2147748608, result=0x7f4e5cc20140, unit=0x7f4e6675f230, select_lex=0x7f4e6675f878) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_select.cc:1221 #25 0x00000000007ff32b in handle_select (thd=0x7f4e6675d000, result=0x7f4e5cc20140, setup_tables_done_option=0) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_select.cc:110 #26 0x00000000007d9633 in execute_sqlcom_select (thd=0x7f4e6675d000, all_tables=0x7f4e5cc1fb28) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:5103 #27 0x00000000007d23e3 in mysql_execute_command (thd=0x7f4e6675d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:2649 #28 0x00000000007dbdbc in mysql_parse (thd=0x7f4e6675d000, rawbuf=0x7f4e5cc1f010 "SELECT GROUP_CONCAT(DISTINCT b,a ORDER BY a,b)FROM t1", length=53, parser_state=0x7f4efa15ce70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245 #29 0x00000000007cf36f in dispatch_command (command=COM_QUERY, thd=0x7f4e6675d000, packet=0x7f4e5b266001 "", packet_length=53) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332 #30 0x00000000007ce45e in do_command (thd=0x7f4e6675d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034 #31 0x0000000000796879 in do_handle_one_connection (thd_arg=0x7f4e6675d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982 #32 0x0000000000796362 in handle_one_connection (arg=0x7f4e6675d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898 #33 0x0000000000d71288 in pfs_spawn_thread (arg=0x7f4ef5ffea60) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860 #34 0x00007f4ef9ba2df3 in start_thread () from /lib64/libpthread.so.0 #35 0x00007f4ef8a741ad in clone () from /lib64/libc.so.6 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; create table t1(a text,b text); ALTER TABLE t1 MODIFY a CHAR(1)CHARACTER SET utf16 COLLATE utf16_danish_ci; INSERT INTO t1 VALUES(3,REPEAT('c',50000)); SELECT GROUP_CONCAT(DISTINCT b,a ORDER BY a,b)FROM t1;