[MDEV-12676] InnoDB FTS duplicate key error - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.29
Fix Version/s: 10.0.33, 10.1.29, 10.2.10, 10.3.3
Component/s: Full-text Search, Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
- upstream

Description

We have a customer continuously getting this in their error log:

InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.

I haven't been able to reproduce this issue on my side. But looking through the source code, it doesn't seem like this type of error should be reported in the error log. Perhaps it could be better handled internally (silently ignored?).

This is a problem because it uselessly fills up the error log.

Thanks,
-will

2017-08-10 - A careful code review would be needed to answer the question if this has any user-visible impact, or why this occurs in the first place.

Attachments

Issue Links

relates to

MDEV-12636 SELECT UNION writes garbage tail of VARCHAR column into internal temporary table

Closed

MDEV-15237 "Can't write; duplicate key in table" when updating some rows in a transaction

Closed

MDEV-19073 FTS row mismatch after crash recovery

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Will Fong

Votes:: 2 Vote for this issue

Watchers:: 10 Start watching this issue

Dates

Created:: 2017-05-04 01:34

Updated:: 2020-08-25 16:36

Resolved:: 2017-10-16 18:01

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.