Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
CentOS 6
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
Issue Links
- relates to
-
-
- Closed
-
- links to
Activity
I forgot that this fix should be applied to 5.5 (you need to remove galera change, galera change only to 5.5-galera).
I ported the MySQL 5.6.35/5.7.17 fix to MariaDB 5.5.65 and reverted our fix because our fix conflicted with a revert that I applied from upstream.
It is possible that due to the fix that I had to revert due to reverting the MySQL 5.6 change we are reintroducing MySQL Bug #88321 into MariaDB. It is also possible that that bug was fixed by reverting the MySQL 5.6 change. Oracle does not always update the public bug reports.
Non-deterministic test case by Laurynas Biveinis from the upstream report (run with --repeat=N):
--source include/have_innodb.inc# Should be != 0SELECT @@innodb_autoinc_lock_mode;CREATE TABLE `test` (`test_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`testcol` varchar(256)) ENGINE=InnoDB;INSERT INTO `test` (`testcol`) VALUES ('aldsldjfhasjk');SET SESSION auto_increment_increment = 2;send INSERT INTO `test` (`testcol`) VALUES ('aldsldjfhasjk');--connect(con1,localhost,root,,)--connection con1SET SESSION auto_increment_increment = 2;send INSERT INTO `test` (`testcol`) VALUES ('aldsldjfhasjk');# --error 0,1062reap;--disconnect con1--connection default# --error 0,1062reap;SELECT * FROM test;DROP TABLE test;