[MDEV-16106] Record in index was not found on rollback, trying to insert: TUPLE Created: 2018-05-07  Updated: 2018-05-08  Resolved: 2018-05-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.15, 10.3.7
Fix Version/s: 10.2.15, 10.3.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Attachments: File mdev-16106-10.3v1.patch    
Issue Links:
Relates
relates to MDEV-15374 Server hangs and aborts with long sem... Closed

 Description   

--source include/have_innodb.inc
 
CREATE TEMPORARY TABLE t1 (i INT, KEY (i)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (NULL),(NULL);
UPDATE t1 SET i = 0;
START TRANSACTION;
UPDATE t1 SET i = 4;
UPDATE t1 SET i = 0;
ROLLBACK;

10.2 e44ca6cc9c

2018-05-07 18:09:02 139988084655872 [Warning] InnoDB: Record in index `i` of table `mysqld.1`.`#sql3893_9_0` was not found on rollback, trying to insert: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000000),[6]      (0x000000000201)} at: COMPACT RECORD(info_bits=32, 2 fields): {NULL,[6]      (0x000000000201)}
2018-05-07 18:09:02 139988084655872 [Warning] InnoDB: Record in index `i` of table `mysqld.1`.`#sql3893_9_0` was not found on rollback, trying to insert: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000000),[6]      (0x000000000200)} at: COMPACT RECORD(info_bits=32, 2 fields): {NULL,[6]      (0x000000000201)}



 Comments   
Comment by Thirunarayanan Balathandayuthapani [ 2018-05-08 ]

mdev-16106-10.3v1.patch

Attached patch will solve the issue.

Comment by Marko Mäkelä [ 2018-05-08 ]

OK to push.

Generated at Thu Feb 08 08:26:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.