Comment 9 for bug 1226538

Revision history for this message
Roel Van de Paar (roel11) wrote : Re: InnoDB: Failing assertion: 0 in file row0upd.cc line 1803 | abort (sig=6) in row_upd_sec_index_entry | InnoDB: error in sec index entry update in index `c23` of table `test`.`table1_innodb_default_char` tuple DATA TUPLE: 2 fields;

Adding a second occurrence, which is preceded with errors like these:

----------------------------
2013-09-16 17:13:06 12583 [Warning] InnoDB could not find index c4 key no 0 for table tmp/#sql3127_9_19 through its index translation table
2013-09-16 17:13:06 12583 [ERROR] Cannot find index c4 in InnoDB index translation table.
[...]
2013-09-16 17:13:12 12583 [Warning] InnoDB could not find index c4 key no 0 for table tmp/#sql3127_9_1c through its index translation table
InnoDB: error in sec index entry update in
InnoDB: index `c16` of table `test`.`table1_innodb_compressed_char`
InnoDB: tuple DATA TUPLE: 2 fields;
 0: len 1; hex ff; asc ;;
 1: len 1; hex 20; asc ;;

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

TRANSACTION 93340, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 9, OS thread handle 0x7f07e4855700, query id 8688 127.0.0.1 root update
REPLACE INTO `table1_innodb_compressed_char` ( `c33` ) VALUES ( 'q' )

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
2013-09-16 17:13:20 7f07e4855700 InnoDB: Assertion failure in thread 139671875442432 in file row0upd.cc line 1803
InnoDB: Failing assertion: 0
[...]
Query (7f07c00ecce0): REPLACE INTO `table1_innodb_compressed_char` ( `c33` ) VALUES ( 'q' )
Connection ID (thread ID): 9
Status: NOT_KILLED
----------------------------

The aforementioned errors are a like those in bug 1226525, however the final assert (and final preceding errors) are like the ones in this bug.