Bug #48482 innodb-autoinc.test fails with results difference
Submitted: 2 Nov 2009 17:46 Modified: 12 Mar 2010 16:56
Reporter: Sergey Vojtovich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version: OS:Any
Assigned to: Satya B CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[2 Nov 2009 17:46] Sergey Vojtovich
Description:
Fails after applying 5.1-ss6129 (currently only in 5.1-bugteam):

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

main.innodb-autoinc                      [ fail ]
        Test ended at 2009-11-02 21:42:57

CURRENT_TEST: main.innodb-autoinc
--- /home/svoj/devel/innodb-snapshots/mysql-5.1-bugteam/mysql-test/r/innodb-autoinc.result	2009-11-02 20:40:57.000000000 +0300
+++ /home/svoj/devel/innodb-snapshots/mysql-5.1-bugteam/mysql-test/r/innodb-autoinc.reject	2009-11-02 20:42:57.000000000 +0300
@@ -875,11 +875,11 @@
 SELECT * FROM t1;
 d1
 1
-3
+2
 SELECT * FROM t1;
 d1
 1
-3
+2
 INSERT INTO t1 VALUES(null);
 Got one of the listed errors
 ALTER TABLE t1 AUTO_INCREMENT = 3;
@@ -888,13 +888,13 @@
 t1	CREATE TABLE `t1` (
   `d1` int(11) NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`d1`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
 INSERT INTO t1 VALUES(null);
 SELECT * FROM t1;
 d1
 1
+2
 3
-4
 DROP TABLE t1;
 SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
 SHOW VARIABLES LIKE "%auto_inc%";

mysqltest: Result content mismatch

How to repeat:
See description.
[2 Nov 2009 22:18] Miguel Solorzano
Thank you for the bug report.

c:\bzr\5.1-bugteam\mysql-test>perl mysql-test-run.pl innodb-autoinc
Found handle.exe version 3.42
Logging: mysql-test-run.pl  innodb-autoinc
091102 20:13:10 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.1.41
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: c:/bzr/5.1-bugteam/mysql-test/var
Removing old var directory...
Creating var directory 'c:/bzr/5.1-bugteam/mysql-test/var'...
Installing system database...
Using server port 49603

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.innodb-autoinc                      [ fail ]  Found warnings/errors in server log file!
        Test ended at 2009-11-02 20:13:54
[30 Nov 2009 9:09] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/92032

3217 Satya B	2009-11-30
      Applying InnoDB snapshot 5.1-ss6242, part 6. Fixes BUG#48482
      
      1. BUG#48482 - innodb-autoinc.test fails with results difference
      
      2. enable the disabled test
      
      Detailed revision comments:
      
      r6230 | sunny | 2009-11-24 23:52:43 +0200 (Tue, 24 Nov 2009) | 3 lines
      branches/5.1: Fix autoinc failing test results.
      (this should be skipped when merging 5.1 into zip)
[1 Dec 2009 9:17] Satya B
patch queued to mysql-5.1-bugteam and NULL merged to 6.0
[2 Dec 2009 8:04] Bugs System
Pushed into 5.1.42 (revid:joro@sun.com-20091202080033-mndu4sxwx19lz2zs) (version source revid:satya.bn@sun.com-20091130090841-qp34o2vsd8zgh9lf) (merge vers: 5.1.42) (pib:13)
[15 Dec 2009 2:20] Paul Dubois
Changes to test case. No changelog entry needed.
[16 Dec 2009 8:39] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091216083311-xorsasf5kopjxshf) (version source revid:alik@sun.com-20091214191830-wznm8245ku8xo702) (merge vers: 6.0.14-alpha) (pib:14)
[16 Dec 2009 8:46] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091216082430-s0gtzibcgkv4pqul) (version source revid:satya.bn@sun.com-20091202114649-zt975apdali0jy3c) (merge vers: 5.5.0-beta) (pib:14)
[16 Dec 2009 8:53] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20091216083231-rp8ecpnvkkbhtb27) (version source revid:alik@sun.com-20091212203859-fx4rx5uab47wwuzd) (merge vers: 5.6.0-beta) (pib:14)
[18 Dec 2009 2:05] Paul Dubois
Changes to test case. No changelog entry needed.
[12 Mar 2010 14:14] Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:30] Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:46] Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[12 Mar 2010 16:56] Paul Dubois
No changelog entry needed.