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)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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