MySQL Bugs: #73839: InnoDB: unable to purge a record

Bug #73839	InnoDB: unable to purge a record
Submitted:	8 Sep 2014 15:57	Modified:	18 Dec 2014 9:01
Reporter:	Jacky Shu	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.6.19	OS:	Linux (CentOS 2.6.32-279.5.1.el6.x86_64)
Assigned to:		CPU Architecture:	Any

Description:
While checking MySQL error, saw the following 2 errors:

2014-09-06 14:00:11 7f95df62f700  InnoDB: unable to purge a record
InnoDB: tuple DATA TUPLE: 3 fields;
 0: len 4; hex 01f6ec3f; asc    ?;;
 1: len 4; hex 00013deb; asc   = ;;
 2: len 7; hex 31323137373934; asc 1217794;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 4; hex 01f6ec3f; asc    ?;;
 1: len 4; hex 00013deb; asc   = ;;
 2: len 7; hex 31323137373934; asc 1217794;;

space 235 offset 20407 (503 records, index id 1096)
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
2014-09-06 14:13:23 7f95e0a31700  InnoDB: unable to purge a record
InnoDB: tuple DATA TUPLE: 2 fields;
 0: len 1; hex 4e; asc N;;
 1: len 4; hex 82cb5018; asc   P ;;

InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 1; hex 4e; asc N;;
 1: len 4; hex 82cb5018; asc   P ;;

space 735 offset 1247318 (1354 records, index id 2738)
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
2014-09-06 14:22:22 7f95e1432700  InnoDB: unable to purge a record
InnoDB: tuple DATA TUPLE: 5 fields;
 0: len 4; hex 825db22d; asc  ] -;;
 1: len 4; hex 0009f701; asc     ;;
 2: len 4; hex 80000000; asc     ;;
 3: len 4; hex 80106f06; asc   o ;;
 4: len 4; hex 825db22f; asc  ] /;;

InnoDB: record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: len 4; hex 825db22d; asc  ] -;;
 1: len 4; hex 0009f701; asc     ;;
 2: len 4; hex 80000000; asc     ;;
 3: len 4; hex 80106f06; asc   o ;;
 4: len 4; hex 825db22f; asc  ] /;;

space 29888 offset 24191 (494 records, index id 38819)
InnoDB: Submit a detailed bug report to http://bugs.mysql.com

As the error message suggested, I'm filing this as a bug. This happened on our production environment, I can't find which sql caused the problem. 

How to repeat:
Not sure how to reproduce the issue. Any advice is welcome.

related:
http://bugs.mysql.com/bug.php?id=73767 ("Unable to purge a record" with ibuf and varchar fields containing spaces)

Thank you for the report.
This is most likely duplicate of Bug #73767.
Could you please upload complete error log(make it private), any relevant info which you think triggering this issue?

Thanks,
Umesh

Thank you for providing the requested details.
Could you please also provide the table structure of index id 38819?
You could get the db/table details from information_schma, with something like using below query(not tested):

select A.INDEX_ID, B.NAME DB_TABLE from information_schema.INNODB_SYS_INDEXES A,information_schema.INNODB_SYS_TABLES B WHERE A.TABLE_ID=B.TABLE_ID AND A.INDEX_ID=38819;

See, on how to get table name based on index id etc http://dev.mysql.com/doc/refman/5.6/en/innodb-sys-indexes-table.html

Also, pls keep reading related Bug #73767
Looks like others also affected and for more details on this from Dev's..

Compared the data of table with index 38819 between master (5.1) and slave (5.6), didn't find data drift.

Marking as duplicate of Bug #73767