MySQL Bugs: #77289: InnoDB: Failing assertion: lock->index == index

Bug #77289	InnoDB: Failing assertion: lock->index == index \| lock0lock.cc line 5573
Submitted:	10 Jun 2015 2:49	Modified:	10 Jun 2015 7:11
Reporter:	Ramesh Sivaraman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	5.6.23, 5.6.25, 5.7.8	OS:	Linux (CentOS 7)
Assigned to:		CPU Architecture:	Any
Tags:	debug

Description:
2015-06-09 22:44:38 7f843885e700  InnoDB: Assertion failure in thread 140205860710144 in file lock0lock.cc line 5573
InnoDB: Failing assertion: lock->index == index

** GDB info

#0  0x00007f84382a5771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000000a980a6 in my_write_core (sig=6) at /sda/mysql-server-5.6/mysys/stacktrace.c:422
#2  0x00000000007277f0 in handle_fatal_signal (sig=6) at /sda/mysql-server-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f84370b15d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f84370b2cc8 in __GI_abort () at abort.c:90
#6  0x0000000000bd602d in lock_rec_queue_validate (locked_lock_trx_sys=0, block=0x7f8427ead600, rec=0x7f8428820070 "supremum", index=0x7f841986c5f8, offsets=0x7f843885ab70) at /sda/mysql-server-5.6/storage/innobase/lock/lock0lock.cc:5573
#7  0x0000000000bd72db in lock_rec_insert_check_and_lock (flags=0, rec=0x7f8428820063 "infimum", block=0x7f8427ead600, index=0x7f841986c5f8, thr=0x7f84199637b8, mtr=0x7f843885b120, inherit=0x7f843885afb0) at /sda/mysql-server-5.6/storage/innobase/lock/lock0lock.cc:6030
#8  0x0000000000d29baf in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7f843885b0a0, entry=0x7f841986cff8, thr=0x7f84199637b8, mtr=0x7f843885b120, inherit=0x7f843885afb0) at /sda/mysql-server-5.6/storage/innobase/btr/btr0cur.cc:1162
#9  0x0000000000d2a2a7 in btr_cur_optimistic_insert (flags=0, cursor=0x7f843885b0a0, offsets=0x7f843885b610, heap=0x7f843885b600, entry=0x7f841986cff8, rec=0x7f843885b5f8, big_rec=0x7f843885b608, n_ext=0, thr=0x7f84199637b8, mtr=0x7f843885b120) at /sda/mysql-server-5.6/storage/innobase/btr/btr0cur.cc:1393
#10 0x0000000000c591ad in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f841986c5f8, n_uniq=1, entry=0x7f841986cff8, n_ext=0, thr=0x7f84199637b8) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:2473
#11 0x0000000000c5a095 in row_ins_clust_index_entry (index=0x7f841986c5f8, entry=0x7f841986cff8, thr=0x7f84199637b8, n_ext=0) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:2867
#12 0x0000000000c5a395 in row_ins_index_entry (index=0x7f841986c5f8, entry=0x7f841986cff8, thr=0x7f84199637b8) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:2965
#13 0x0000000000c5a676 in row_ins_index_entry_step (node=0x7f8419963568, thr=0x7f84199637b8) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:3042
#14 0x0000000000c5a97a in row_ins (node=0x7f8419963568, thr=0x7f84199637b8) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:3182
#15 0x0000000000c5acff in row_ins_step (thr=0x7f84199637b8) at /sda/mysql-server-5.6/storage/innobase/row/row0ins.cc:3307
#16 0x0000000000c71cc2 in row_insert_for_mysql (mysql_rec=0x7f841989ced8 "\376\001", prebuilt=0x7f8419963078) at /sda/mysql-server-5.6/storage/innobase/row/row0mysql.cc:1367
#17 0x0000000000b7e1ce in ha_innobase::write_row (this=0x7f841989cc10, record=0x7f841989ced8 "\376\001") at /sda/mysql-server-5.6/storage/innobase/handler/ha_innodb.cc:6645
#18 0x0000000000645c52 in handler::ha_write_row (this=0x7f841989cc10, buf=0x7f841989ced8 "\376\001") at /sda/mysql-server-5.6/sql/handler.cc:7273
#19 0x00000000007b55d0 in write_record (thd=0x7f8427bf0000, table=0x7f8419972200, info=0x7f843885bb00, update=0x7f843885bb80) at /sda/mysql-server-5.6/sql/sql_insert.cc:1921
#20 0x00000000007b3461 in mysql_insert (thd=0x7f8427bf0000, table_list=0x7f841981f190, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /sda/mysql-server-5.6/sql/sql_insert.cc:1072
#21 0x00000000007d5704 in mysql_execute_command (thd=0x7f8427bf0000) at /sda/mysql-server-5.6/sql/sql_parse.cc:3443
#22 0x00000000007dd54a in mysql_parse (thd=0x7f8427bf0000, rawbuf=0x7f841981f010 "INSERT INTO t1  VALUES (1,'my small mouse'),(2,'la-la-la'),(3,'It is so funny'),(4,'MySQL Tutorial')", length=100, parser_state=0x7f843885ce70) at /sda/mysql-server-5.6/sql/sql_parse.cc:6357
#23 0x00000000007d06bc in dispatch_command (command=COM_QUERY, thd=0x7f8427bf0000, packet=0x7f841998f001 "INSERT INTO t1  VALUES (1,'my small mouse'),(2,'la-la-la'),(3,'It is so funny'),(4,'MySQL Tutorial')", packet_length=100) at /sda/mysql-server-5.6/sql/sql_parse.cc:1332
#24 0x00000000007cf7ab in do_command (thd=0x7f8427bf0000) at /sda/mysql-server-5.6/sql/sql_parse.cc:1034
#25 0x0000000000797b3d in do_handle_one_connection (thd_arg=0x7f8427bf0000) at /sda/mysql-server-5.6/sql/sql_connect.cc:982
#26 0x0000000000797626 in handle_one_connection (arg=0x7f8427bf0000) at /sda/mysql-server-5.6/sql/sql_connect.cc:898
#27 0x0000000000b5d7f0 in pfs_spawn_thread (arg=0x7f8431b3dde0) at /sda/mysql-server-5.6/storage/perfschema/pfs.cc:1860
#28 0x00007f84382a0df5 in start_thread (arg=0x7f843885e700) at pthread_create.c:308
#29 0x00007f84371721ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
The attached tarball gives the testcase as an exact match of our system,
including some handy utilities

{epoch}.sql has SQL info.

$ vi {epoch}_mybase # Update base path in this file (the only change
required!). For non-binary distribution please update SOURCE_DIR
location also.
$ ./{epoch}_init # Initializes the data dir
$ ./{epoch}_start # Starts mysqld
$ ./{epoch}_cl # To check mysqld is up
$ ./{epoch}_run # Run the testcase with pquery binary(produces
output)
$ vi /dev/shm/{epoch}/error.log.out # Verify the error log
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb;
standard and full var gdb stack traces
etc.

Testcase bundle

Attachment: 1433325459_bug_bundle.tar.gz (application/gzip, text), 1.03 MiB.

Hello Ramesh,

Thank you for the report and test case.
Observed that 5.6.23, 5.6.25 and 5.7.8 debug builds are affected(but seeing different asserts than the reported with this test case).

Thanks,
Umesh

// 5.6.25 

scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/77289
bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/77289 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.25/77289/log.err  --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25: bin/mysql -u root -S/tmp/mysql_ushastry.sock  --force < testcases/1433325459.sql
ERROR 1215 (HY000) at line 6: Cannot add foreign key constraint
Table   Op      Msg_type        Msg_text
test.t1 repair  status  OK
..
.
ERROR 2013 (HY000) at line 42: Lost connection to MySQL server during query
ERROR 2006 (HY000) at line 43: MySQL server has gone away
ERROR 2006 (HY000) at line 44: MySQL server has gone away
ERROR 2006 (HY000) at line 45: MySQL server has gone away
[1]+  Aborted                 (core dumped) bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/77289 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.25/77289/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1

// gdb

(gdb) bt
#0  0x00007f94ebba0771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000ab0b17 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/mysys/stacktrace.c:422
#2  0x0000000000716112 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f94ea7a65c9 in raise () from /lib64/libc.so.6
#5  0x00007f94ea7a7cd8 in abort () from /lib64/libc.so.6
#6  0x0000000000cfb644 in fseg_inode_get (header=0x7f94c8d14054 "", space=0, zip_size=0, mtr=0x7f94c1413550)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/fsp/fsp0fsp.cc:1849
#7  0x0000000000cfcae9 in fseg_n_reserved_pages (header=0x7f94c8d14054 "", used=0x7f94c1413480, mtr=0x7f94c1413550)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/fsp/fsp0fsp.cc:2178
#8  0x0000000000c5fcff in btr_get_size (index=0x7f948408c048, flag=2, mtr=0x7f94c1413550) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/btr/btr0btr.cc:1219
#9  0x0000000000cdfacc in dict_stats_analyze_index (index=0x7f948408c048) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/dict/dict0stats.cc:1910
#10 0x0000000000ce055e in dict_stats_update_persistent (table=0x7f948407c4c8) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/dict/dict0stats.cc:2209
#11 0x0000000000ce2753 in dict_stats_update (table=0x7f948407c4c8, stats_upd_option=DICT_STATS_RECALC_PERSISTENT)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/dict/dict0stats.cc:3127
#12 0x0000000000ce2a2c in dict_stats_update (table=0x7f948407c4c8, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/dict/dict0stats.cc:3248
#13 0x0000000000acda17 in dict_stats_init (table=0x7f948407c4c8) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/include/dict0stats.ic:174
#14 0x0000000000adcc88 in ha_innobase::open (this=0x7f94840776b0, name=0x7f9484087008 "./test/t1", mode=2, test_if_locked=2)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/innobase/handler/ha_innodb.cc:4859
#15 0x00000000006229f7 in handler::ha_open (this=0x7f94840776b0, table_arg=0x7f948408a4a0, name=0x7f9484087008 "./test/t1", mode=2, test_if_locked=2)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/handler.cc:2505
#16 0x0000000000890a4b in open_table_from_share (thd=0x2100b70, share=0x7f9484086ce0, alias=0x7f9484026010 "t1", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f948408a4a0,
    is_create_table=false) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/table.cc:2355
#17 0x00000000007635a3 in open_table (thd=0x2100b70, table_list=0x7f9484026018, ot_ctx=0x7f94c1414c80) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_base.cc:3167
#18 0x0000000000764412 in open_and_process_table (thd=0x2100b70, lex=0x2102930, tables=0x7f9484026018, counter=0x21029e0, flags=0, prelocking_strategy=0x7f94c1414dc0,
    has_prelocking_list=false, ot_ctx=0x7f94c1414c80) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_base.cc:4662
#19 0x0000000000764be0 in open_tables (thd=0x2100b70, start=0x7f94c1414d80, counter=0x21029e0, flags=0, prelocking_strategy=0x7f94c1414dc0)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_base.cc:5095
#20 0x00000000007651dc in open_normal_and_derived_tables (thd=0x2100b70, tables=0x7f9484026018, flags=0) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_base.cc:5791
#21 0x00000000007cc935 in mysql_execute_command (thd=0x2100b70) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_parse.cc:3507
#22 0x00000000007d1bae in mysql_parse (thd=0x2100b70, rawbuf=0x7f9484025f20 "INSERT INTO t1  SELECT * FROM t1", length=32, parser_state=0x7f94c1416700)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_parse.cc:6386
#23 0x00000000007d37d2 in dispatch_command (command=COM_QUERY, thd=0x2100b70, packet=0x21e65e1 "INSERT INTO t1  SELECT * FROM t1", packet_length=32)
    at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_parse.cc:1340
#24 0x00000000007d505e in do_command (thd=0x2100b70) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_parse.cc:1037
#25 0x000000000078aa91 in do_handle_one_connection (thd_arg=0x2100b70) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_connect.cc:982
#26 0x000000000078ab57 in handle_one_connection (arg=0x2100b70) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/sql/sql_connect.cc:898
#27 0x0000000000d7ed74 in pfs_spawn_thread (arg=0x219ddb0) at /export/home/pb2/build/sb_0-15205200-1430827248.7/mysql-5.6.25/storage/perfschema/pfs.cc:1860
#28 0x00007f94ebb9bdf3 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f94ea86747d in clone () from /lib64/libc.so.6
(gdb)

// 5.7.8 

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/77289 -v
2015-06-10 09:04:33 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2015-06-10 09:04:33 [NOTE]    Creating data directory /export/umesh/server/binaries/mysql-5.7.8/77289
2015-06-10 09:04:33 [NOTE]    Executing /export/umesh/server/binaries/mysql-5.7.8/bin/mysqld --bootstrap --datadir=/export/umesh/server/binaries/mysql-5.7.8/77289 --lc-messages-dir=/export/umesh/server/binaries/mysql-5.7.8/share --lc-messages=en_US --basedir=/export/umesh/server/binaries/mysql-5.7.8
bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/77289 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.8/77289/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --server_id=1 2>&1 &

.

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/77289 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.8/77289/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --server_id=1 2>&1 &
[1] 27660
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: 2015-06-10T07:04:36.938021Z 0 [Warning] option 'transaction_alloc_block_size': unsigned value 1048576 adjusted to 131072
2015-06-10T07:04:36.938085Z 0 [Warning] option 'transaction_prealloc_size': unsigned value 1048576 adjusted to 131072
2015-06-10T07:04:36.938133Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-10T07:04:36.938154Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2015-06-10T07:04:36.938224Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-06-10T07:04:36.938301Z 0 [Note] bin/mysqld-debug (mysqld 5.7.8-rc-enterprise-commercial-advanced-debug-log) starting as process 27660 ...

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysql -u root -S/tmp/mysql_ushastry.sock  --force < ../mysql-5.6.25/testcases/1433325459.sql
.
.
ERROR 2013 (HY000) at line 32: Lost connection to MySQL server during query
ERROR 2006 (HY000) at line 33: MySQL server has gone away
.
ERROR 2006 (HY000) at line 45: MySQL server has gone away
[1]+  Aborted                 (core dumped) bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.7.8 --datadir=/export/umesh/server/binaries/mysql-5.7.8/77289 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.7.8/77289/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --server_id=1 2>&1
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8:

(gdb) bt
#0  0x00007f5487c8c771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000016bf1e9 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247
#2  0x0000000000d915a0 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f54868925c9 in raise () from /lib64/libc.so.6
#5  0x00007f5486893cd8 in abort () from /lib64/libc.so.6
#6  0x00007f548688b536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f548688b5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x000000000134cbdd in THD::send_statement_status (this=0x7f53e4000bc0) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/sql/sql_class.cc:4774
#9  0x00000000013a3f3f in dispatch_command (thd=0x7f53e4000bc0, com_data=0x7f545a65ae10, command=COM_QUERY)
    at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1692
#10 0x00000000013a14c7 in do_command (thd=0x7f53e4000bc0) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#11 0x00000000014cc078 in handle_connection (arg=0x4784fe0) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299
#12 0x0000000001a61acd in pfs_spawn_thread (arg=0x491b550) at /export/home/pb2/build/sb_0-15472861-1433389453.06/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2178
#13 0x00007f5487c87df3 in start_thread () from /lib64/libpthread.so.0
#14 0x00007f548695347d in clone () from /lib64/libc.so.6
(gdb)