InnoDB: Unable To Purge A Record (Doc ID 1950542.1)

Last updated on AUGUST 21, 2015

Applies to:

MySQL Server - Version 5.6 to 5.7 [Release 5.6 to 5.7]
Information in this document applies to any platform.

Symptoms

When the innodb change buffering is enabled, the error log occasionally has errors:

2014-10-02 20:23:56 1d14 InnoDB: unable to purge a record
InnoDB: tuple DATA TUPLE: 4 fields;
0: len 4; hex 80000035; asc 5;;
1: len 0; hex ; asc ;;
2: len 2; hex 80b4; asc ;;
3: len 1; hex 03; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 4; compact format; info bits 0
0: len 4; hex 80000035; asc 5;;
1: len 0; hex ; asc ;;
2: len 2; hex 80b4; asc ;;
3: len 1; hex 03; asc ;;

space 9 offset 431 (865 records, index id 29)
InnoDB: Submit a detailed bug report to http://bugs.mysql.com

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms