| Bug #74664 | Assertion: len <= col->len || col->mtype==5 || (col->len == 0 && col->mtype ==1) | ||
|---|---|---|---|
| Submitted: | 3 Nov 2014 7:03 | Modified: | 3 Nov 2014 8:41 |
| Reporter: | Ramesh Sivaraman | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
| Version: | 5.6.20-debug, 5.5.41, 5.6.22, 5.7.6 | OS: | Linux (CentOS 7) |
| Assigned to: | CPU Architecture: | Any | |
[3 Nov 2014 8:41]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the bug report and test case. Confirmed that latest 5.5/5.6/5.7 debug builds asserts. Thanks, Umes
[3 Nov 2014 8:42]
MySQL Verification Team
// 5.5.41 Debug build
(gdb) bt
#0 0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000007daa89 in my_write_core (sig=6) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/mysys/stacktrace.c:433
#2 0x00000000006a397e in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/signal_handler.cc:247
#3 <signal handler called>
#4 0x0000003deac32625 in raise () from /lib64/libc.so.6
#5 0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6 0x0000000000996cc3 in rec_get_converted_size_comp_prefix_low (index=0x7f54d8016f68, fields=<value optimized out>, n_fields=4, extra=0x0, temp=0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/rem/rem0rec.c:832
#7 0x0000000000997074 in rec_get_converted_size_comp (index=0x7f54d8016f68, status=<value optimized out>, fields=0x7f54d8016d20, n_fields=4, extra=0x0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/rem/rem0rec.c:945
#8 0x00000000008ceac7 in rec_get_converted_size (index=0x7f54d8016f68, dtuple=0x7f54d8016ce8, n_ext=0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/include/rem0rec.ic:1607
#9 0x00000000008cf616 in btr_cur_optimistic_insert (flags=0, cursor=0x7f54e73631c0, entry=0x7f54d8016ce8, rec=0x7f54e73631b8, big_rec=0x7f54e73631b0, n_ext=0, thr=0x7f54d801c1c0,
mtr=0x7f54e7362cd0) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/btr/btr0cur.c:1230
#10 0x000000000099f99c in row_ins_index_entry_low (mode=2, index=0x7f54d8016f68, entry=0x7f54d8016ce8, n_ext=0, thr=0x7f54d801c1c0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0ins.c:2163
#11 0x00000000009a0d16 in row_ins_index_entry (index=0x7f54d8016f68, entry=0x7f54d8016ce8, n_ext=0, foreign=<value optimized out>, thr=0x7f54d801c1c0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0ins.c:2261
#12 0x00000000009a1874 in row_ins_index_entry_step (thr=0x7f54d801c1c0) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0ins.c:2349
#13 row_ins (thr=0x7f54d801c1c0) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0ins.c:2481
#14 row_ins_step (thr=0x7f54d801c1c0) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0ins.c:2598
#15 0x000000000086c332 in row_insert_for_mysql (mysql_rec=0x7f54d801a880 "\004", prebuilt=0x7f54d801bb38)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/row/row0mysql.c:1240
#16 0x0000000000853430 in ha_innobase::write_row (this=0x7f54d8013890, record=0x7f54d801a880 "\004")
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/storage/innobase/handler/ha_innodb.cc:5239
#17 0x00000000006a5754 in handler::ha_write_row (this=0x7f54d8013890, buf=0x7f54d801a880 "\004") at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/handler.cc:5200
#18 0x000000000058061c in write_record (thd=0x6d7d430, table=0x7f54d80163a0, info=0x7f54e73636b0) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_insert.cc:1732
#19 0x0000000000587e16 in mysql_insert (thd=0x6d7d430, table_list=0x7f54d8004d10, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_insert.cc:929
#20 0x00000000005984c4 in mysql_execute_command (thd=0x6d7d430) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_parse.cc:2940
#21 0x000000000059bfd3 in mysql_parse (thd=0x6d7d430, rawbuf=0x7f54d8004bf0 "insert INTO t1 values(date_format('2001-01-01','%W'))", length=<value optimized out>, parser_state=0x7f54e7364aa0)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_parse.cc:5777
#22 0x000000000059d52e in dispatch_command (command=COM_QUERY, thd=0x6d7d430, packet=<value optimized out>, packet_length=53)
at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_parse.cc:1038
#23 0x000000000059f1ce in do_command (thd=0x6d7d430) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_parse.cc:773
#24 0x0000000000640cc7 in do_handle_one_connection (thd_arg=<value optimized out>) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_connect.cc:862
#25 0x0000000000640d8d in handle_one_connection (arg=0x6d7d430) at /pb2/build/sb_0-13564596-1414709788.54/mysql-5.5.41/sql/sql_connect.cc:781
#26 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#27 0x0000003deace89dd in clone () from /lib64/libc.so.6
[3 Nov 2014 8:42]
MySQL Verification Team
// 5.6.22 - Debug build
(gdb) bt
#0 0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000b0011b in my_write_core (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/mysys/stacktrace.c:422
#2 0x000000000077ecb8 in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/signal_handler.cc:230
#3 <signal handler called>
#4 0x0000003deac32625 in raise () from /lib64/libc.so.6
#5 0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6 0x0000000000c54ae3 in rec_get_converted_size_comp_prefix_low (index=0x7f6fd803ff98, fields=0x7f6fd803dc90, n_fields=4, extra=0x0, temp=false)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/rem/rem0rec.cc:844
#7 0x0000000000c54f8f in rec_get_converted_size_comp (index=0x7f6fd803ff98, status=0, fields=0x7f6fd803dc90, n_fields=4, extra=0x0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/rem/rem0rec.cc:956
#8 0x0000000000d4076a in rec_get_converted_size (index=0x7f6fd803ff98, dtuple=0x7f6fd803dc58, n_ext=0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/include/rem0rec.ic:1606
#9 0x0000000000d45cb4 in btr_cur_optimistic_insert (flags=0, cursor=0x7f6ffa3797f0, offsets=0x7f6ffa379890, heap=0x7f6ffa379880, entry=0x7f6fd803dc58, rec=0x7f6ffa379878,
big_rec=0x7f6ffa379888, n_ext=0, thr=0x7f6fd8060a90, mtr=0x7f6ffa379320) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:1284
#10 0x0000000000c73e80 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f6fd803ff98, n_uniq=0, entry=0x7f6fd803dc58, n_ext=0, thr=0x7f6fd8060a90)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:2473
#11 0x0000000000c74da3 in row_ins_clust_index_entry (index=0x7f6fd803ff98, entry=0x7f6fd803dc58, thr=0x7f6fd8060a90, n_ext=0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:2867
#12 0x0000000000c750af in row_ins_index_entry (index=0x7f6fd803ff98, entry=0x7f6fd803dc58, thr=0x7f6fd8060a90)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:2965
#13 0x0000000000c753a3 in row_ins_index_entry_step (node=0x7f6fd8060870, thr=0x7f6fd8060a90) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:3042
#14 0x0000000000c756ae in row_ins (node=0x7f6fd8060870, thr=0x7f6fd8060a90) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:3182
#15 0x0000000000c75a37 in row_ins_step (thr=0x7f6fd8060a90) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0ins.cc:3307
#16 0x0000000000c8ca4b in row_insert_for_mysql (mysql_rec=0x7f6fd8066308 "\004", prebuilt=0x7f6fd80603b8)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0mysql.cc:1366
#17 0x0000000000b990e4 in ha_innobase::write_row (this=0x7f6fd8066040, record=0x7f6fd8066308 "\004")
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:6666
#18 0x0000000000699b3c in handler::ha_write_row (this=0x7f6fd8066040, buf=0x7f6fd8066308 "\004") at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/handler.cc:7273
#19 0x000000000080f414 in write_record (thd=0x8da6c70, table=0x7f6fd8040650, info=0x7f6ffa379e80, update=0x7f6ffa379e00)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_insert.cc:1921
#20 0x000000000080d21b in mysql_insert (thd=0x8da6c70, table_list=0x7f6fd8006ea0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_insert.cc:1072
#21 0x000000000082fe71 in mysql_execute_command (thd=0x8da6c70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:3443
#22 0x00000000008380e1 in mysql_parse (thd=0x8da6c70, rawbuf=0x7f6fd8006d80 "insert INTO t1 values(date_format('2001-01-01','%W'))", length=53, parser_state=0x7f6ffa37b680)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6357
#23 0x000000000082aa63 in dispatch_command (command=COM_QUERY, thd=0x8da6c70, packet=0x8ed5d11 "insert INTO t1 values(date_format('2001-01-01','%W'))", packet_length=53)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332
#24 0x0000000000829ac8 in do_command (thd=0x8da6c70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034
#25 0x00000000007f0f17 in do_handle_one_connection (thd_arg=0x8da6c70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982
#26 0x00000000007f09e8 in handle_one_connection (arg=0x8da6c70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898
#27 0x0000000000e64c25 in pfs_spawn_thread (arg=0x8e99440) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860
#28 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#29 0x0000003deace89dd in clone () from /lib64/libc.so.6
[3 Nov 2014 8:42]
MySQL Verification Team
// 5.7.6 - debug build
(gdb) bt
#0 0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2 0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3 <signal handler called>
#4 0x0000003deac32625 in raise () from /lib64/libc.so.6
#5 0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6 0x000000000121b81b in ut_dbg_assertion_failed (
expr=0x1713810 "len <= col->len || ((col->mtype) == 5 || (col->mtype) == 16 || (col->mtype) == 14) || (((col->mtype) == 15 || (col->mtype) == 16) && len == 2 * 2 * sizeof(double)) || (col->len == 0 && col->mtype == 1"..., file=0x1713578 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/rem/rem0rec.cc", line=856)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001118d1e in rec_get_converted_size_comp_prefix_low (index=0x7fce64021ce8, fields=0x7fce640200c0, n_fields=4, extra=0x0, temp=false)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/rem/rem0rec.cc:853
#8 0x00000000011191ce in rec_get_converted_size_comp (index=0x7fce64021ce8, status=0, fields=0x7fce640200c0, n_fields=4, extra=0x0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/rem/rem0rec.cc:964
#9 0x0000000001241f6e in rec_get_converted_size (index=0x7fce64021ce8, dtuple=0x7fce64020088, n_ext=0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/include/rem0rec.ic:1621
#10 0x000000000124c765 in btr_cur_optimistic_insert (flags=0, cursor=0x7fce9ca39880, offsets=0x7fce9ca399a0, heap=0x7fce9ca399a8, entry=0x7fce64020088, rec=0x7fce9ca39998,
big_rec=0x7fce9ca399b0, n_ext=0, thr=0x7fce64020cb0, mtr=0x7fce9ca39050) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3039
#11 0x000000000113c189 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fce64021ce8, n_uniq=0, entry=0x7fce64020088, n_ext=0, thr=0x7fce64020cb0, dup_chk_only=false)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:2448
#12 0x000000000113e18a in row_ins_clust_index_entry (index=0x7fce64021ce8, entry=0x7fce64020088, thr=0x7fce64020cb0, n_ext=0, dup_chk_only=false)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3158
#13 0x000000000113e626 in row_ins_index_entry (index=0x7fce64021ce8, entry=0x7fce64020088, thr=0x7fce64020cb0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3281
#14 0x000000000113eab2 in row_ins_index_entry_step (node=0x7fce64020a68, thr=0x7fce64020cb0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3422
#15 0x000000000113ee40 in row_ins (node=0x7fce64020a68, thr=0x7fce64020cb0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3564
#16 0x000000000113f3b3 in row_ins_step (thr=0x7fce64020cb0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3735
#17 0x000000000115b0fa in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7fce64024e60 "\004", prebuilt=0x7fce64020578)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1570
#18 0x000000000115b5cd in row_insert_for_mysql (mysql_rec=0x7fce64024e60 "\004", prebuilt=0x7fce64020578)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1681
#19 0x000000000103d3e1 in ha_innobase::write_row (this=0x7fce64024b90, record=0x7fce64024e60 "\004")
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:6697
#20 0x000000000099f23c in handler::ha_write_row (this=0x7fce64024b90, buf=0x7fce64024e60 "\004") at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:7443
#21 0x0000000000e92911 in write_record (thd=0x7fce64000d30, table=0x7fce640227a0, info=0x7fce9ca3aca0, update=0x7fce9ca3ac20)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:1680
#22 0x0000000000e901a1 in mysql_insert (thd=0x7fce64000d30, table_list=0x7fce64005df8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:708
#23 0x0000000000cb6855 in mysql_execute_command (thd=0x7fce64000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3338
#24 0x0000000000cbce6a in mysql_parse (thd=0x7fce64000d30, parser_state=0x7fce9ca3c660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#25 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7fce64000d30, packet=0x7fce64009a61 "insert INTO t1 values(date_format('2001-01-01','%W'))", packet_length=53)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#26 0x0000000000cafbd4 in do_command (thd=0x7fce64000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#27 0x0000000000dbe89c in handle_connection (arg=0xd3dd7c0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#28 0x000000000138347f in pfs_spawn_thread (arg=0xd333420) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#29 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#30 0x0000003deace89dd in clone () from /lib64/libc.so.6
[29 Dec 2015 7:11]
Roel Van de Paar
Maybe fix together with bug 79794
[9 Sep 2016 2:34]
Roel Van de Paar
Any possibility of getting this charset bug fixed? Thank you
Description: 2014-11-03 06:54:32 7f364239d700 InnoDB: Assertion failure in thread 139871016048384 in file rem0rec.cc line 845 InnoDB: Failing assertion: len <= col->len || col->mtype == 5 || (col->len == 0 && col->mtype == 1 *** GDB #0 0x00007f3641da4771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000a9035e in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422 #2 0x0000000000723688 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f3640bb05c9 in raise () from /lib64/libc.so.6 #5 0x00007f3640bb1cd8 in abort () from /lib64/libc.so.6 #6 0x0000000000c0a25c in rec_get_converted_size_comp_prefix_low (index=0x7f35a486d778, fields=0x7f35a486d030, n_fields=4, extra=0x0, temp=false) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/rem/rem0rec.cc:844 #7 0x0000000000c0a6fd in rec_get_converted_size_comp (index=0x7f35a486d778, status=0, fields=0x7f35a486d030, n_fields=4, extra=0x0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/rem/rem0rec.cc:956 #8 0x0000000000cf4482 in rec_get_converted_size (index=0x7f35a486d778, dtuple=0x7f35a486cff8, n_ext=0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/include/rem0rec.ic:1606 #9 0x0000000000cf98d7 in btr_cur_optimistic_insert (flags=0, cursor=0x7f364239a0a0, offsets=0x7f364239a610, heap=0x7f364239a600, entry=0x7f35a486cff8, rec=0x7f364239a5f8, big_rec=0x7f364239a608, n_ext=0, thr=0x7f35a496f538, mtr=0x7f364239a120) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/btr/btr0cur.cc:1284 #10 0x0000000000c2959a in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f35a486d778, n_uniq=0, entry=0x7f35a486cff8, n_ext=0, thr=0x7f35a496f538) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:2483 #11 0x0000000000c2a482 in row_ins_clust_index_entry (index=0x7f35a486d778, entry=0x7f35a486cff8, thr=0x7f35a496f538, n_ext=0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:2877 #12 0x0000000000c2a782 in row_ins_index_entry (index=0x7f35a486d778, entry=0x7f35a486cff8, thr=0x7f35a496f538) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:2975 #13 0x0000000000c2aa63 in row_ins_index_entry_step (node=0x7f35a496f318, thr=0x7f35a496f538) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:3052 #14 0x0000000000c2ad67 in row_ins (node=0x7f35a496f318, thr=0x7f35a496f538) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:3192 #15 0x0000000000c2b0ec in row_ins_step (thr=0x7f35a496f538) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ins.cc:3317 #16 0x0000000000c41e4c in row_insert_for_mysql (mysql_rec=0x7f35a4898010 "\004", prebuilt=0x7f35a496ee78) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0mysql.cc:1315 #17 0x0000000000b4f13a in ha_innobase::write_row (this=0x7f35a487d010, record=0x7f35a4898010 "\004") at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/handler/ha_innodb.cc:6625 #18 0x0000000000641f37 in handler::ha_write_row (this=0x7f35a487d010, buf=0x7f35a4898010 "\004") at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:7273 #19 0x00000000007b14e8 in write_record (thd=0x7f35aeb67000, table=0x7f35a4852600, info=0x7f364239ab00, update=0x7f364239ab80) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1921 #20 0x00000000007af379 in mysql_insert (thd=0x7f35aeb67000, table_list=0x7f35a4822130, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1072 #21 0x00000000007d159f in mysql_execute_command (thd=0x7f35aeb67000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:3443 #22 0x00000000007d8fa4 in mysql_parse (thd=0x7f35aeb67000, rawbuf=0x7f35a4822010 "insert INTO t1 values(date_format('2001-01-01','%W'))", length=53, parser_state=0x7f364239be70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245 #23 0x00000000007cc557 in dispatch_command (command=COM_QUERY, thd=0x7f35aeb67000, packet=0x7f35aeb70001 "insert INTO t1 values(date_format('2001-01-01','%W'))", packet_length=53) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332 #24 0x00000000007cb646 in do_command (thd=0x7f35aeb67000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034 #25 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7f35aeb67000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982 #26 0x000000000079354a in handle_one_connection (arg=0x7f35aeb67000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898 #27 0x0000000000ad4b5c in pfs_spawn_thread (arg=0x7f363e3fec40) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860 #28 0x00007f3641d9fdf3 in start_thread () from /lib64/libpthread.so.0 #29 0x00007f3640c7101d in clone () from /lib64/libc.so.6 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; set character_set_connection=ucs2; create TABLE t1 select if(0=0,'Y','N'); insert INTO t1 values(date_format('2001-01-01','%W'));