InnoDB: Failing assertion: *cursor->index->name == TEMP_INDEX_PREFIX in file row0ins.cc line 275

[Alexey Bychko]

2013-06-25 07:24:59 7f07ead54700 InnoDB: Assertion failure in thread 139671981344512 in file row0ins.cc line 275
InnoDB: Failing assertion: *cursor->index->name == TEMP_INDEX_PREFIX
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
04:24:59 UTC - mysqld got signal 6 ;

+bt
#0 0x00007f0804c2469c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000661f9e in handle_fatal_signal (sig=6) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x00007f08032dc8a5 in raise () from /lib64/libc.so.6
#4 0x00007f08032de085 in abort () from /lib64/libc.so.6
#5 0x000000000096d82a in row_ins_sec_index_entry_by_modify (mtr=0x7f07ead518d0, thr=0x7f078401ac80, entry=0x7f075402ccc8, heap=0x7f0754020130, offsets_heap=0x7f0754029cc0, offsets=0x7f07ead51ee8, cursor=0x7f07ead51e50, mode=2, flags=0) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:275
#6 row_ins_sec_index_entry_low (flags=0, mode=2, index=<optimized out>, offsets_heap=0x7f0754029cc0, heap=0x7f0754020130, entry=0x7f075402ccc8, trx_id=0, thr=0x7f078401ac80) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:2754
#7 0x000000000097141d in row_ins_sec_index_entry (index=0x7f07c06682f8, entry=0x7f075402ccc8, thr=0x7f078401ac80) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:2948
#8 0x00000000009719bf in row_ins_index_entry (entry=<optimized out>, index=0x7f07c06682f8, thr=0x7f078401ac80) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:2983
#9 row_ins_index_entry_step (thr=0x7f078401ac80, node=0x7f078401a640) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:3058
#10 row_ins (thr=0x7f078401ac80, node=0x7f078401a640) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:3198
#11 row_ins_step (thr=0x7f078401ac80) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0ins.cc:3323
#12 0x000000000097e300 in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=<optimized out>) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/row/row0mysql.cc:1312
#13 0x00000000008f2028 in ha_innobase::write_row (this=0x7f0784012ba0, record=0x7f078400a2b8 "\377\377\377") at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc:6929
#14 0x00000000005adb9f in handler::ha_write_row (this=0x7f0784012ba0, buf=0x7f078400a2b8 "\377\377\377") at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/handler.cc:7414
#15 0x0000000000b0cc5c in ha_partition::write_row (this=0x7f0784010800, buf=0x7f078400a2b8 "\377\377\377") at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/ha_partition.cc:3927
#16 0x00000000005adb4b in handler::ha_write_row (this=0x7f0784010800, buf=0x7f078400a2b8 "\377\377\377") at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/handler.cc:7414
#17 0x00000000006c1cfb in write_record (thd=0x26274d0, table=0x7f078400ff10, info=0x7f07ead52500, update=0x7f07ead52480) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_insert.cc:1650
#18 0x00000000006c9287 in mysql_insert (thd=0x26274d0, table_list=0x7f0754004ed8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_UPDATE, ignore=true) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_insert.cc:1054
#19 0x00000000006de0b5 in mysql_execute_command (thd=0x26274d0) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:3634
#20 0x00000000006e1588 in mysql_parse (thd=0x26274d0, rawbuf=<optimized out>, length=40015960, parser_state=<optimized out>) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:6451
#21 0x00000000006e2441 in dispatch_command (command=COM_QUERY, thd=0x26274d0, packet=0x262b741 "INSERT IGNORE INTO `table500_innodb_compressed_key_pk_parts_2_int` ( `pk` ) VALUES ( LOAD_FILE('/sdd/randgen/data/earth2kb.jpg') ) ON DUPLICATE KEY UPDATE `c0` = '2000-07-07 10:52:07.037142'", packet_length=191) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:1376
#22 0x00000000006b008f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_connect.cc:1615
#23 0x00000000006b0167 in handle_one_connection (arg=<optimized out>) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/sql/sql_connect.cc:1526
#24 0x0000000000ab05d9 in pfs_spawn_thread (arg=0x2515440) at /bzr/5.6_opt/Percona-Server-5.6.11-rc60.3/storage/perfschema/pfs.cc:1853
#25 0x00007f0804c1f851 in start_thread () from /lib64/libpthread.so.0
#26 0x00007f080339290d in clone () from /lib64/libc.so.6

[Laurynas Biveinis (laurynas-biveinis)]

Most likely this is an upstream bug. Thus, it needs a run on upstream server with the Percona grammar with Percona features removed, and it should show up there. Then it can be reported to Oracle.

[Ramesh Sivaraman (rameshvs02)]

Got one testcase for this issue....

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a CHAR(4)CHARACTER SET utf8,KEY key_a(a(3)));
create index t1a1 on t1(a(1));
INSERT INTO t1 VALUES('01:00:00.000008');
SET innodb_fake_changes=1;
UPDATE t1 SET a=0;

I could not reproduce it with MS after removing "SET innodb_fake_changes=1;"

[Ramesh Sivaraman (rameshvs02)]

*** GDB info (Comment #5)

+bt
#0 0x00007f7e18c43771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000067640d in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-6
9.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00007f7e178475c9 in raise () from /lib64/libc.so.6
#4 0x00007f7e17848cd8 in abort () from /lib64/libc.so.6
#5 0x0000000000994ac2 in row_ins_sec_index_entry_by_modify (mtr=0x7f7e19232b40, thr=0x7f7d601318e0, entry=0x7f7d600ab868, heap=0x7f7e16c1ae00, offsets_he
ap=0x7f7d600a9500, offsets=0x7f7e192329a0, cursor=0x7f7e192329e0, mode=2, flags=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0ins.cc:277
#6 row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=2, index=index@entry=0x7f7d6006bee8, offsets_heap=offsets_heap@entry=0x7f7d600a9500, heap=heap@entry=0x7f7e16c1ae00, entry=entry@entry=0x7f7d600ab868, trx_id=trx_id@entry=0, thr=thr@entry=0x7f7d601318e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0ins.cc:2764
#7 0x00000000009969db in row_ins_sec_index_entry (index=index@entry=0x7f7d6006bee8, entry=0x7f7d600ab868, thr=thr@entry=0x7f7d601318e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0ins.cc:2958
#8 0x00000000009bb266 in row_upd_sec_index_entry (node=node@entry=0x7f7d60131658, thr=thr@entry=0x7f7d601318e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:1839
#9 0x00000000009bf31c in row_upd_sec_step (thr=<optimized out>, node=0x7f7d60131658) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:1866
#10 row_upd (thr=0x7f7d601318e0, node=0x7f7d60131658) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:2569
#11 row_upd_step (thr=thr@entry=0x7f7d601318e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0upd.cc:2686
#12 0x00000000009a2e77 in row_update_for_mysql (mysql_rec=mysql_rec@entry=0x7f7d6009a020 "\375\060\061:0 ", prebuilt=0x7f7d60130c68) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0mysql.cc:1791
#13 0x000000000090af19 in ha_innobase::update_row (this=0x7f7d600a9f10, old_row=0x7f7d6009a020 "\375\060\061:0 ", new_row=0x7f7d6009a010 "\375\060", ' ' <repeats 11 times>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:7768
#14 0x00000000005c1864 in handler::ha_update_row (this=0x7f7d600a9f10, old_data=0x7f7d6009a020 "\375\060\061:0 ", new_data=0x7f7d6009a010 "\375\060", ' ' <repeats 11 times>) at /mnt/workspace/percona-server-5.6-binaries...