| Bug #56466 | main.ps_4heap fails if MTR run with --mysqld=--query-cache-size=1000000 | ||
|---|---|---|---|
| Submitted: | 1 Sep 2010 16:52 | ||
| 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:19]
Bernt Marius Johnsen
Succeeds at 8G: ./mtr --mysqld=--query-cache-size=8000000000 ps_4heap Logging: /export/home/tmp/mysql/trunk-bugfixing/mysql-test/mysql-test-run.pl --mysqld=--query-cache-size=8000000000 ps_4heap 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 36226 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.ps_4heap [ pass ] 1749 ------------------------------------------------------------ The servers were restarted 0 times Spent 1.749 of 19 seconds executing testcases Completed: All 1 tests were successful.
[21 Sep 2010 11:19]
Bernt Marius Johnsen
Not a test bug, but a MySQL server bug.
[8 Oct 2010 16:09]
Omer Barnir
triage: same values (was triaged as server bug cat was not changed)
Description: main.ps_4heap fails if MTR run with --mysqld=--query-cache-size=1000000 How to repeat: $./mtr --mysqld=--query-cache-size=1000000 ps_4heap Logging: ./mtr --mysqld=--query-cache-size=1000000 ps_4heap 100901 18:50:53 [Note] Plugin 'FEDERATED' is disabled. 100901 18:50:53 [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 34374 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ main.ps_4heap [ fail ] Test ended at 2010-09-01 18:50:54 CURRENT_TEST: main.ps_4heap --- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_4heap.result 2010-05-31 10:32:27.000000000 +0300 +++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_4heap.reject 2010-09-01 19:50:50.000000000 +0300 @@ -1008,7 +1008,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