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

          Transition Time In Source Status Execution Times
          Elena Stepanova made transition -
          Open Confirmed
          18h 54m 1
          Jan Lindström (Inactive) made transition -
          Confirmed In Progress
          64d 12h 26m 1
          Sergei Golubchik made transition -
          In Progress In Review
          4d 13h 3m 1
          Sergei Golubchik made transition -
          In Review Stalled
          26m 4s 1
          Sergei Golubchik made transition -
          Stalled In Progress
          4d 14h 55m 1
          Sergei Golubchik made transition -
          In Progress Closed
          2d 23h 15m 1

          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.