Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12676

InnoDB FTS duplicate key error

Details

    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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12636 SELECT UNION writes garbage tail of VARCHAR column into internal temporary table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15237 "Can't write; duplicate key in table" when updating some rows in a transaction

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19073 FTS row mismatch after crash recovery

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            		130d 12h 58m 1
            Marko Mäkelä made transition -
            Confirmed In Progress
            		34d 18h 51m 1
            Marko Mäkelä made transition -
            In Progress Closed
            		8h 37m 1

            People

              marko Marko Mäkelä
              wfong Will Fong
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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