| 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: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
| Version: | OS: | Any | |
| Assigned to: | Satya B | CPU Architecture: | Any |
[2 Nov 2009 22:18]
MySQL Verification Team
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.
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.