Bug #89760 mysql server crash at dict0dict.cc:2328
Submitted: 22 Feb 2018 6:49 Modified: 22 Feb 2018 7:21
Reporter: yghmgl yang Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7, 5.7.21 OS:Any
Assigned to: CPU Architecture:Any

[22 Feb 2018 6:49] yghmgl yang 
Description:
(gdb) bt
#0  0x00007f9142bf8741 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000186a78d in my_write_core (sig=6) at /sda/rds-mysql/mysys/stacktrace.c:249
#2  0x0000000000eb1452 in handle_fatal_signal (sig=6) at /sda/rds-mysql/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f91419fc1d7 in raise () from /lib64/libc.so.6
#5  0x00007f91419fd8c8 in abort () from /lib64/libc.so.6
#6  0x0000000001b571d2 in ut_dbg_assertion_failed (expr=0x225a3d8 "!field->prefix_len || field->fixed_len == field->prefix_len", file=0x2259a80 "/sda/rds-mysql/storage/innobase/dict/dict0dict.cc",
    line=2328) at /sda/rds-mysql/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001c02590 in dict_index_node_ptr_max_size (index=0x7f9083411fa0) at /sda/rds-mysql/storage/innobase/dict/dict0dict.cc:2327
#8  0x0000000001b830e6 in btr_cur_search_to_nth_level (index=0x7f9083411fa0, level=0, tuple=0x7f9083411a48, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7f91431be7b0, has_search_latch=0,
    file=0x21fe6c0 "/sda/rds-mysql/storage/innobase/row/row0ins.cc", line=2997, mtr=0x7f91431beb70) at /sda/rds-mysql/storage/innobase/btr/btr0cur.cc:1029
#9  0x0000000001a583a8 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7f9083411fa0, offsets_heap=0x7f9083406e18, heap=0x7f9083407318, entry=0x7f9083411a48, trx_id=0, thr=0x7f90838b8c58,
    dup_chk_only=false) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:2997
#10 0x0000000001a59648 in row_ins_sec_index_entry (index=0x7f9083411fa0, entry=0x7f9083411a48, thr=0x7f90838b8c58, dup_chk_only=false) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:3418
#11 0x0000000001a597f8 in row_ins_index_entry (index=0x7f9083411fa0, entry=0x7f9083411a48, thr=0x7f90838b8c58) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:3467
#12 0x0000000001a59d1d in row_ins_index_entry_step (node=0x7f90838b8608, thr=0x7f90838b8c58) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:3615
#13 0x0000000001a5a0a7 in row_ins (node=0x7f90838b8608, thr=0x7f90838b8c58) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:3757
#14 0x0000000001a5a6cb in row_ins_step (thr=0x7f90838b8c58) at /sda/rds-mysql/storage/innobase/row/row0ins.cc:3942
#15 0x0000000001a78d76 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f90838ebe30 "\377", prebuilt=0x7f90838b80a0) at /sda/rds-mysql/storage/innobase/row/row0mysql.cc:1734
#16 0x0000000001a7930d in row_insert_for_mysql (mysql_rec=0x7f90838ebe30 "\377", prebuilt=0x7f90838b80a0) at /sda/rds-mysql/storage/innobase/row/row0mysql.cc:1858
#17 0x000000000192747c in ha_innobase::write_row (this=0x7f9083410030, record=0x7f90838ebe30 "\377") at /sda/rds-mysql/storage/innobase/handler/ha_innodb.cc:7555
#18 0x0000000000f36117 in handler::ha_write_row (this=0x7f9083410030, buf=0x7f90838ebe30 "\377") at /sda/rds-mysql/sql/handler.cc:7977
#19 0x0000000001755f6e in write_record (thd=0x7f9083828000, table=0x7f90838eb420, info=0x7f91431c09b0, update=0x7f91431c0a30) at /sda/rds-mysql/sql/sql_insert.cc:1871
#20 0x000000000175314c in Sql_cmd_insert::mysql_insert (this=0x7f908390c878, thd=0x7f9083828000, table_list=0x7f908390c2e8) at /sda/rds-mysql/sql/sql_insert.cc:769
#21 0x0000000001759a9f in Sql_cmd_insert::execute (this=0x7f908390c878, thd=0x7f9083828000) at /sda/rds-mysql/sql/sql_insert.cc:3105
#22 0x0000000001532a86 in mysql_execute_command (thd=0x7f9083828000, first_level=true) at /sda/rds-mysql/sql/sql_parse.cc:3571
#23 0x000000000153826e in mysql_parse (thd=0x7f9083828000, parser_state=0x7f91431c1e80) at /sda/rds-mysql/sql/sql_parse.cc:5578
#24 0x000000000152daf2 in dispatch_command (thd=0x7f9083828000, com_data=0x7f91431c25e0, command=COM_QUERY) at /sda/rds-mysql/sql/sql_parse.cc:1462
#25 0x000000000152c9d8 in do_command (thd=0x7f9083828000) at /sda/rds-mysql/sql/sql_parse.cc:1000
#26 0x000000000165d36e in handle_connection (arg=0x7f9099c15180) at /sda/rds-mysql/sql/conn_handler/connection_handler_per_thread.cc:300
#27 0x000000000189e215 in pfs_spawn_thread (arg=0x7f91415c3d20) at /sda/rds-mysql/storage/perfschema/pfs.cc:2190
#28 0x00007f9142bf3dc5 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f9141abe76d in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;
CREATE DATABASE test;
USE test;
CREATE TABLE t1(a CHAR(255)CHARACTER SET UTF32,KEY k1(a(254))) ENGINE=INNODB;
INSERT INTO t1 VALUES(),();
[22 Feb 2018 7:21] MySQL Verification Team 
Hello yghmgl yang,

Thank you for the report.
Observed that 5.7.21 debug build is affected.

Thanks,
Umesh