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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.