Bug #80681 Failing assertion: len <= fixed_len in in file rem0rec.cc line 886
Submitted: 10 Mar 2016 7:24 Modified: 11 Mar 2016 7:59
Reporter: Ramesh Sivaraman (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.7.11 OS:CentOS
Assigned to: CPU Architecture:Any
Tags: debug

[10 Mar 2016 7:24] Ramesh Sivaraman
Description:
Error info

2016-02-02 07:33:13 0x7fa8ebeb7700 InnoDB: Assertion failure in thread 140363489310464 in file rem0rec.cc line 886
InnoDB: Failing assertion: len <= fixed_len

GDB info

#0  0x00007fe878dc6771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000180fa8c in my_write_core (sig=6) at /sda/ps57/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000e6af64 in handle_fatal_signal (sig=6) at /sda/ps57/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fe876f525c9 in raise () from /lib64/libc.so.6
#5  0x00007fe876f53cd8 in abort () from /lib64/libc.so.6
#6  0x0000000001afc33f in ut_dbg_assertion_failed (expr=0x20a9b1a "len <= fixed_len", file=0x20a9778 "/sda/ps57/mysql-server_dbg/storage/innobase/rem/rem0rec.cc", line=886) at /sda/ps57/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000019db127 in rec_get_converted_size_comp_prefix_low (index=0x7fe80c036f20, fields=0x7fe80ca3c588, n_fields=5, v_entry=0x0, extra=0x0, temp=false) at /sda/ps57/mysql-server_dbg/storage/innobase/rem/rem0rec.cc:886
#8  0x00000000019db6ab in rec_get_converted_size_comp (index=0x7fe80c036f20, status=0, fields=0x7fe80ca3c588, n_fields=5, extra=0x0) at /sda/ps57/mysql-server_dbg/storage/innobase/rem/rem0rec.cc:1020
#9  0x0000000001b22b67 in rec_get_converted_size (index=0x7fe80c036f20, dtuple=0x7fe80ca3c540, n_ext=0) at /sda/ps57/mysql-server_dbg/storage/innobase/include/rem0rec.ic:1653
#10 0x0000000001b2d2b5 in btr_cur_optimistic_insert (flags=3, cursor=0x7fe84e51a180, offsets=0x7fe84e51a558, heap=0x7fe84e51a560, entry=0x7fe80ca3c540, rec=0x7fe84e51a550, big_rec=0x7fe84e51a548, n_ext=0, thr=0x7fe80ca41fc8, mtr=0x7fe80ca3d640) at /sda/ps57/mysql-server_dbg/storage/innobase/btr/btr0cur.cc:3104
#11 0x0000000001a009a8 in row_ins_sorted_clust_index_entry (mode=2, index=0x7fe80c036f20, entry=0x7fe80ca3c540, n_ext=0, thr=0x7fe80ca41fc8) at /sda/ps57/mysql-server_dbg/storage/innobase/row/row0ins.cc:2590
#12 0x0000000001a02387 in row_ins_clust_index_entry (index=0x7fe80c036f20, entry=0x7fe80ca3c540, thr=0x7fe80ca41fc8, n_ext=0, dup_chk_only=false) at /sda/ps57/mysql-server_dbg/storage/innobase/row/row0ins.cc:3158
#13 0x0000000001a2149b in row_insert_for_mysql_using_cursor (mysql_rec=0x7fe80c02d718 "\377", prebuilt=0x7fe80ca403d0) at /sda/ps57/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1590
#14 0x0000000001a22038 in row_insert_for_mysql (mysql_rec=0x7fe80c02d718 "\377", prebuilt=0x7fe80ca403d0) at /sda/ps57/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1848
#15 0x00000000018d0ee3 in ha_innobase::intrinsic_table_write_row (this=0x7fe80c035b20, record=0x7fe80c02d718 "\377") at /sda/ps57/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7304
#16 0x00000000018d0fa8 in ha_innobase::write_row (this=0x7fe80c035b20, record=0x7fe80c02d718 "\377") at /sda/ps57/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7328
#17 0x0000000000ef2115 in handler::ha_write_row (this=0x7fe80c035b20, buf=0x7fe80c02d718 "\377") at /sda/ps57/mysql-server_dbg/sql/handler.cc:7779
#18 0x000000000158fa80 in create_ondisk_from_heap (thd=0x7fe80c000b70, table=0x7fe80c02b830, start_recinfo=0x7fe80c02c688, recinfo=0x7fe80c0073a0, error=135, ignore_last_dup=true, is_duplicate=0x0) at /sda/ps57/mysql-server_dbg/sql/sql_tmp_table.cc:2565
#19 0x000000000159ee7a in Query_result_update::send_data (this=0x7fe80c007240, not_used_values=...) at /sda/ps57/mysql-server_dbg/sql/sql_update.cc:2400
#20 0x00000000014a3e3d in end_send (join=0x7fe80c029da8, qep_tab=0x7fe80c02acc0, end_of_records=false) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:2897
#21 0x00000000014a0bdc in evaluate_join_record (join=0x7fe80c029da8, qep_tab=0x7fe80c02ab48) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:1636
#22 0x00000000014a0051 in sub_select (join=0x7fe80c029da8, qep_tab=0x7fe80c02ab48, end_of_records=false) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:1291
#23 0x00000000014a0bdc in evaluate_join_record (join=0x7fe80c029da8, qep_tab=0x7fe80c02a9d0) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:1636
#24 0x00000000014a0051 in sub_select (join=0x7fe80c029da8, qep_tab=0x7fe80c02a9d0, end_of_records=false) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:1291
#25 0x000000000149f8d2 in do_select (join=0x7fe80c029da8) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:944
#26 0x000000000149d853 in JOIN::exec (this=0x7fe80c029da8) at /sda/ps57/mysql-server_dbg/sql/sql_executor.cc:199
#27 0x00000000015368a6 in handle_query (thd=0x7fe80c000b70, lex=0x7fe80c002e60, result=0x7fe80c007240, added_options=1342177408, removed_options=131072) at /sda/ps57/mysql-server_dbg/sql/sql_select.cc:184
#28 0x000000000159c59b in mysql_multi_update (thd=0x7fe80c000b70, fields=0x7fe80c0058a8, values=0x7fe80c006480, handle_duplicates=DUP_ERROR, select_lex=0x7fe80c005770, result=0x7fe84e51c358) at /sda/ps57/mysql-server_dbg/sql/sql_update.cc:1672
#29 0x00000000015a082e in Sql_cmd_update::execute_multi_table_update (this=0x7fe80c006470, thd=0x7fe80c000b70) at /sda/ps57/mysql-server_dbg/sql/sql_update.cc:2979
#30 0x00000000015a0986 in Sql_cmd_update::execute (this=0x7fe80c006470, thd=0x7fe80c000b70) at /sda/ps57/mysql-server_dbg/sql/sql_update.cc:3006
#31 0x00000000014e88b3 in mysql_execute_command (thd=0x7fe80c000b70, first_level=true) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:3529
#32 0x00000000014ee081 in mysql_parse (thd=0x7fe80c000b70, parser_state=0x7fe84e51d5a0) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:5518
#33 0x00000000014e393b in dispatch_command (thd=0x7fe80c000b70, com_data=0x7fe84e51dcf0, command=COM_QUERY) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:1428
#34 0x00000000014e2805 in do_command (thd=0x7fe80c000b70) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:996
#35 0x000000000160ecc7 in handle_connection (arg=0x3eeaaa0) at /sda/ps57/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#36 0x0000000001845888 in pfs_spawn_thread (arg=0x3f4ba40) at /sda/ps57/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#37 0x00007fe878dc1df3 in start_thread () from /lib64/libpthread.so.0
#38 0x00007fe8770131ad in clone () from /lib64/libc.so.6

How to repeat:
Start MTR with below option and execute testcase

 perl mysql-test-run.pl \
   --start-and-exit \
   --skip-ndb \
   --vardir=/tmp/tc \
   --mysqld=--port=10010 \
   --mysqld=--core-file \
   --mysqld=--sql_mode=ONLY_FULL_GROUP_BY \
   --mysqld=--maximum-sort_buffer_size=1M \
   --mysqld=--maximum-tmp_table_size=1M \
   --mysqld=--log-output=none \
   --mysqld=--secure-file-priv= \
   1st

Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@session.tmp_table_size=4294967295;
create TABLE t1(a varchar(334)character set utf16 key);
INSERT INTO t1 VALUES(1),(2),(3),(4),(5),(6), (7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
UPDATE t1 AS ta1,t1 AS ta2 SET ta1.a='aaaaaaaaaaaaaaaa';
[10 Mar 2016 7:25] Ramesh Sivaraman
I think the issue is similar to Bug#79794 and Bug#74664
[11 Mar 2016 7:59] MySQL Verification Team
Hello Ramesh,

Thank you for the report and test case.
Observed that 5.7.11 debug build is affected.

Thanks,
Umesh