InnoDB: Failing assertion: 0 in file row0upd.cc line 1800 | abort in row_upd_sec_index_entry

[Roel Van de Paar]

2013-09-14 17:11:44 24765 [Note] /ssd/Percona-Server-5.6.13-rc60.5-434-debug.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.13-rc60.5-debug-log' socket: '/ssd//572281/current1_1/tmp/master.sock' port: 13000 Percona Server with XtraDB (GPL), Release rc60.5, Revision 434-debug
2013-09-14 17:12:11 24765 [Warning] Could not remove temporary table: '/ssd/572281/current1_1/tmp/#sql60bd_9_1', error: 0
InnoDB: error in sec index entry update in
InnoDB: index `c13` of table `test`.`table10_innodb_default`
InnoDB: tuple DATA TUPLE: 2 fields;
 0: len 1; hex ff; asc ;;
 1: len 1; hex 00; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 32
 0: len 1; hex 80; asc ;;
 1: len 1; hex 00; asc ;;

TRANSACTION 55136, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 9, OS thread handle 0x7f02db8fd700, query id 4223 127.0.0.1 root update
REPLACE INTO `table10_innodb_default` ( `c14` ) VALUES ( '2004-10-16' )

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
2013-09-14 17:13:02 7f02db8fd700 InnoDB: Assertion failure in thread 139650250299136 in file row0upd.cc line 1800
InnoDB: Failing assertion: 0
[...]
Some pointers may be invalid and cause the dump to abort.
Query (7f02b8004c10): REPLACE INTO `table10_innodb_default` ( `c14` ) VALUES ( '2004-10-16' )
Connection ID (thread ID): 9
Status: NOT_KILLED

================

Thread 1 (LWP 24800):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000af96fc in row_upd_sec_index_entry (node=<optimized out>, thr=0x7f02b81f56c0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:1800
#6 0x0000000000afbef7 in row_upd_sec_step (thr=0x7f02b81f56c0, node=0x7f02b81f4ec0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:1872
#7 row_upd (thr=0x7f02b81f56c0, node=0x7f02b81f4ec0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2604
#8 row_upd_step (thr=0x7f02b81f56c0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0upd.cc:2721
#9 0x0000000000acceeb in row_update_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7f02b81f3a58) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0mysql.cc:1729
#10 0x0000000000a04e87 in ha_innobase::delete_row (this=0x7f02b8174030, record=0x7f02b820d6b0 "\377\377#") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:7529
#11 0x00000000005c1375 in handler::ha_delete_row (this=0x7f02b8174030, buf=0x7f02b820d6b0 "\377\377#") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/handler.cc:7508
#12 0x00000000007050ed in write_record (thd=0x2e2ba10, table=0x7f02b82206e0, info=0x7f02db8fb260, update=0x7f02db8fb1e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_insert.cc:1890
#13 0x000000000070c949 in mysql_insert (thd=0x2e2ba10, table_list=0x7f02b8004db8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_insert.cc:1073
#14 0x0000000000724bf9 in mysql_execute_command (thd=0x2e2ba10) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:3649
#15 0x0000000000728628 in mysql_parse (thd=0x2e2ba10, rawbuf=0x2e2ddd0 "P\303\070\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#16 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x2e2ba10, packet=0x7f02db8fca90 "\020\272\342\002", packet_length=71) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#17 0x000000000072a987 in do_command (thd=0x2e2ba10) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#18 0x00000000006ee1ef in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#19 0x00000000006ee2d7 in handle_one_connection (arg=0x2e2ba10) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#20 0x00000000009e033a in pfs_spawn_thread (arg=0x2db9930) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#21 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#22 0x0000003636ee890d in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

RQG @ 908 <email address hidden>
PS @ Percona-Server-5.6.13-rc60.5-434-debug.Linux.x86_64 (5.6-QA tree)

[Roel Van de Paar (roel11)]

See bug 1226538

[Roel Van de Paar (roel11)]

This is not fake changes, see bug 1226538. Marking this as a dup of that one.