InnoDB AUTO_INCREMENT produces same value twice
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
High
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Unassigned |
Bug Description
Upstream bug http://
How to repeat:
Follow instructions from comment "[30 Apr 15:39] Sinisa Milivojevic ":
sveta@thinkie:
[2] 8296
sveta@thinkie:
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at ./mtr line 495.
(Maybe you should just omit the defined()?)
Subroutine lldb_arguments redefined at ./mtr line 5824.
Logging: ./mtr --start innodb --mysqld=
150820 0:22:49 [Note] /home/sveta/
MySQL Version 5.5.44
Checking supported features...
- skipping SSL, mysqld not compiled with SSL
- binaries are debug compiled
Collecting tests...
Checking leftover processes...
- found old pid 5235 in 'mysqld.2.pid', killing it...
process did not exist!
- found old pid 5232 in 'mysqld.1.pid', killing it...
process did not exist!
Removing old var directory...
Creating var directory '/home/
Installing system database...
=======
TEST RESULT TIME (ms) or COMMENT
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1]
Started [mysqld.1 - pid: 8329, winpid: 8329]
worker[1] Using config for test innodb.innodb
worker[1] Port and socket path for server(s):
worker[1] mysqld.1 13001 /home/sveta/
worker[1] Waiting for server(s) to exit...
sveta@thinkie:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.44-
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create table t3(test_id int not null auto_increment primary key, testcol varchar(255)) engine=innodb;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into t3(testcol) values(
Query OK, 1 row affected (0.05 sec)
mysql> select * from t3;
+------
| test_id | testcol |
+------
| 1 | aldsldjfhasjk |
+------
1 row in set (0.00 sec)
mysql> \q
Bye
sveta@thinkie:
sveta@thinkie:
sveta@thinkie:
mysql-test-run: *** ERROR: Test suite aborted
[2]+ Exit 1 ./mtr --start innodb --mysqld=
sveta@thinkie:
[2] 8377
sveta@thinkie:
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at ./mtr line 495.
(Maybe you should just omit the defined()?)
Subroutine lldb_arguments redefined at ./mtr line 5824.
Logging: ./mtr --start-dirty innodb --mysqld=
150820 0:23:35 [Note] /home/sveta/
MySQL Version 5.5.44
Checking supported features...
- skipping SSL, mysqld not compiled with SSL
- binaries are debug compiled
Collecting tests...
Checking leftover processes...
=======
TEST RESULT TIME (ms) or COMMENT
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1]
Started [mysqld.1 - pid: 8385, winpid: 8385]
worker[1] Using config for test innodb.innodb
worker[1] Port and socket path for server(s):
worker[1] mysqld.1 13001 /home/sveta/
worker[1] Waiting for server(s) to exit...
sveta@thinkie:
[3] 8408
[4] 8410
[5] 8412
[6] 8414
[7] 8417
sveta@thinkie:
[3] Done echo "INSERT INTO test.t3 (testcol) VALUES ('aldsldjfhasjk')" | ../bin/mysql -uroot -h127.0.0.1 -P13000 -P13001 > /dev/null
[4] Exit 1 echo "INSERT INTO test.t3 (testcol) VALUES ('aldsldjfhasjk')" | ../bin/mysql -uroot -h127.0.0.1 -P13000 -P13001 > /dev/null
[5] Done echo "INSERT INTO test.t3 (testcol) VALUES ('aldsldjfhasjk')" | ../bin/mysql -uroot -h127.0.0.1 -P13000 -P13001 > /dev/null
[6]- Done echo "INSERT INTO test.t3 (testcol) VALUES ('aldsldjfhasjk')" | ../bin/mysql -uroot -h127.0.0.1 -P13000 -P13001 > /dev/null
[7]+ Done echo "INSERT INTO test.t3 (testcol) VALUES ('aldsldjfhasjk')" | ../bin/mysql -uroot -h127.0.0.1 -P13000 -P13001 > /dev/null
Changed in percona-server: | |
status: | New → Confirmed |
tags: | added: upstream |
Experimental fix at https:/ /github. com/laurynas- biveinis/ percona- server/ commit/ bd9d2eb05db41a4 3141988221f5d86 a4303a3b36 for 5.5 and https:/ /github. com/laurynas- biveinis/ percona- server/ commit/ c0b58a3f546633e 9c00fb0523a7539 2a7acd1b76 for 5.6.