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

Duplicate key with auto increment

    XMLWordPrintable

Details

    Description

      I am filing this bug with MariaDB, just for the sake of completeness, as it was already filed with MySQL/InnoDB here (by someone else):

      http://bugs.mysql.com/bug.php?id=76872

      "InnoDB AUTO_INCREMENT produces same value twice"

      "When more than one INSERT is executed concurrently on a non-empty InnoDB table with an AUTO_INCREMENT PK immediately after MySQL start up (before any other INSERTs on the same table) one will often fail with the message like "Duplicate entry '123' for key 'PRIMARY'". This will only happen if innodb_autoinc_lock_mode is 1 or 2 and auto_increment_increment > 1."

      There is much more in the actual bug report, but I didn't want to copy/paste the entire report.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            ccalender Chris Calender (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            13 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.