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)
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.6.13
• OS: Any
• 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] MySQL Verification Team

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.