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.
Adding a second occurrence, which is preceded with errors like these:
------- ------- ------- ------- `table1_ innodb_ compressed_ char`
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`.
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 innodb_ compressed_ char` ( `c33` ) VALUES ( 'q' )
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: Submit a detailed bug report to http:// bugs.mysql. com innodb_ compressed_ char` ( `c33` ) VALUES ( 'q' ) ------- ------- -------
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_
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.