| Bug #48482 | innodb-autoinc.test fails with results difference | ||
|---|---|---|---|
| Submitted: | 2 Nov 18:46 | Modified: | 2 Dec 9:04 |
| Reporter: | Sergey Vojtovich | ||
| Status: | Documenting | ||
| Category: | Server: InnoDB | Severity: | S1 (Critical) |
| Version: | OS: | Any | |
| Assigned to: | Satya B | Target Version: | 5.1+ |
| Triage: | Triaged: D3 (Medium) | ||
[2 Nov 23: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 10: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 10:17]
Satya B
patch queued to mysql-5.1-bugteam and NULL merged to 6.0
[2 Dec 9: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)
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.