Bug #70311 fts: Duplicate FTS_DOC_ID value on table / Cannot find index FTS_DOC_ID_INDEX in
Submitted: 12 Sep 2013 8:48 Modified: 2 Jun 2014 12:51
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6.13 OS:Any
Assigned to: CPU Architecture:Any

[12 Sep 2013 8:48] Shane Bester
Description:
5.6/5.7 debug/release builds print out messages during concurrent tests with fulltext table:

[ERROR] InnoDB: Duplicate FTS_DOC_ID value on table test/t1
[ERROR] Cannot find index FTS_DOC_ID_INDEX in InnoDB index translation table.
[Warning] Find index FTS_DOC_ID_INDEX in InnoDB index list but not its MySQL index number It could be an InnoDB internal index.

How to repeat:
Run the procedure p1 from 3 connections on a fast machine.
[12 Sep 2013 8:48] Shane Bester
testcase

Attachment: bug70311.sql (application/octet-stream, text), 807 bytes.

[2 Jun 2014 12:51] Daniel Price
Fixed as of the upcoming 5.6.20, 5.7.5 releases, and here's the changelog entry:

A race condition in "fts_get_next_doc_id" resulted in "Duplicate
FTS_DOC_ID" and "Cannot find index FTS_DOC_ID_INDEX in InnoDB index
translation table" errors. 

Thank you for the bug report.