test-run and swap_builtin_innodb.patch conflict and run tests for builtin incompatible with plugin with xtradb
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Critical
|
Alexey Kopytov | ||
5.1 |
Fix Released
|
Critical
|
Alexey Kopytov | ||
5.5 |
Invalid
|
Critical
|
Alexey Kopytov |
Bug Description
The innodb test suite is not supposed to be run with InnoDB plugin or XtraDB. In this particular case there are two different versions of the test case in suite/innodb/
In MySQL mysql-test-run automatically runs the server with either builtin InnoDB or the the plugin based on the test case contents. In Percona Server, mysql-test-run is confused by innodb_
So there is a problem with mysql-test-run or innodb_
innodb.
Test ended at 2010-12-02 09:30:55
CURRENT_TEST: innodb.
mysqltest: At line 13: query 'CREATE TABLE `bug56143` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`),
KEY `c` (`c`),
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
....
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
CONSTRAINT `aaaaaaaaaaaaaa
) ENGINE=InnoDB' failed: 1005: Can't create table 'test.bug56143' (errno: 150)
- saving '/home/
Retrying test innodb.
Changed in percona-server: | |
milestone: | none → 5.1.53-11.7 |
Changed in percona-server: | |
importance: | Undecided → High |
assignee: | nobody → Alexey Kopytov (akopytov) |
Changed in percona-server: | |
status: | New → In Progress |
Changed in percona-server: | |
milestone: | 5.1.53-11.7 → 5.1.53-11.8 |
Changed in percona-server: | |
milestone: | 5.1.53-11.8 → none |
Changed in percona-server: | |
milestone: | none → 5.1.58-12.9 |
The innodb test suite is not supposed to be run with InnoDB plugin or XtraDB. In this particular case there are two different versions of the test case in suite/innodb/ t/innodb_ bug56143. test and suite/innodb_ plugin/ t/innodb_ bug56143. test, because the syntax accepted by the built-in version is not compatible with the plugin.
In MySQL mysql-test-run automatically runs the server with either builtin InnoDB or the the plugin based on the test case contents. In Percona Server, mysql-test-run is confused by innodb_ swap_builtin_ plugin. patch, so it seems to always run the server with XtraDB regardless of the test case contents.
So there is a problem with mysql-test-run or innodb_ swap_builtin_ plugin. patch that should be fixed, but this particular test failure is harmless and can be ignored.