| Bug #56497 | ps_3innodb fails if MTR run with --mysqld=--query-cache-size=1000000 | ||
|---|---|---|---|
| Submitted: | 2 Sep 2010 13:23 | ||
| Reporter: | Sveta Smirnova | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[21 Sep 2010 11:03]
Bernt Marius Johnsen
The cache size must be larger than 7G for the test to pass: [atum15:/export/home/tmp/mysql/trunk-bugfixing/compile/mysql-test] ./mtr --mysqld=--query-cache-size=8000000000 ps_3innodb Logging: /export/home/tmp/mysql/trunk-bugfixing/mysql-test/mysql-test-run.pl --mysqld=--query-cache-size=8000000000 ps_3innodb MySQL Version 5.6.1 Checking supported features... - skipping ndbcluster, mysqld not compiled with ndbcluster - skipping SSL, mysqld not compiled with SSL Collecting tests... vardir: /export/home/tmp/mysql/trunk-bugfixing/compile/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/export/home/tmp/mysql/trunk-bugfixing/compile/mysql-test/var'... Installing system database... Using server port 51735 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.ps_3innodb [ pass ] 68447 ------------------------------------------------------------ The servers were restarted 0 times Spent 68.447 of 84 seconds executing testcases Completed: All 1 tests were successful.
[21 Sep 2010 11:08]
Bernt Marius Johnsen
This is a MySQL Server bug, not a Test bug.
[8 Oct 2010 16:07]
Omer Barnir
triage: - same values (was triaged as server bug cat was not changed)
Description: ps_3innodb fails if MTR run with --mysqld=--query-cache-size=1000000 How to repeat: $./mtr --mysqld=--query-cache-size=1000000 ps_3innodb Logging: ./mtr --mysqld=--query-cache-size=1000000 ps_3innodb 100902 15:02:25 [Note] Plugin 'FEDERATED' is disabled. 100902 15:02:25 [Note] Plugin 'ndbcluster' is disabled. MySQL Version 5.1.51 Checking supported features... - using ndbcluster when necessary, mysqld supports it - SSL connections supported - binaries are debug compiled Collecting tests... vardir: /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var Checking leftover processes... Removing old var directory... - WARNING: Using the 'mysql-test/var' symlink Creating var directory '/users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var'... Installing system database... Using server port 34692 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ main.ps_3innodb [ fail ] Test ended at 2010-09-02 15:02:26 CURRENT_TEST: main.ps_3innodb --- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_3innodb.result 2010-05-31 10:32:27.000000000 +0300 +++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_3innodb.reject 2010-09-02 16:02:22.000000000 +0300 @@ -1007,7 +1007,7 @@ union distinct select ? FROM t1 where a=1 ' ; execute stmt1 using @arg00; -1 +? 1 set @arg00='a' ; select @arg00 FROM t1 where a=1 mysqltest: Result content mismatch