Bug #56464 main.csv fails if MTR run with --mysqld=--query-cache-size=1000000
Submitted: 1 Sep 2010 16:47
Reporter: Sveta Smirnova Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D2 (Serious)

[1 Sep 2010 16:47] Sveta Smirnova
Description:
main.csv fails if MTR run with --mysqld=--query-cache-size=1000000

How to repeat:
$./mtr --mysqld=--query-cache-size=1000000 csv
Logging: ./mtr  --mysqld=--query-cache-size=1000000 csv
100901 18:46:06 [Note] Plugin 'FEDERATED' is disabled.
100901 18:46:06 [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 53303

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.csv                                 [ fail ]
        Test ended at 2010-09-01 18:46:07

CURRENT_TEST: main.csv
--- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/csv.result      2010-05-31 10:32:15.000000000 +0300
+++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/csv.reject      2010-09-01 19:46:04.000000000 +0300
@@ -5007,6 +5007,8 @@
 Error  1194    Table 'test_repair_table2' is marked as crashed and should be repaired
 SELECT * from test_repair_table2;
 val
+Warnings:
+Error  1194    Table 'test_repair_table2' is marked as crashed and should be repaired
 CHECK TABLE test_repair_table2;
 Table  Op      Msg_type        Msg_text
 test.test_repair_table2        check   status  OK
@@ -5035,6 +5037,8 @@
 Error  1194    Table 'test_repair_table4' is marked as crashed and should be repaired
 SELECT * FROM test_repair_table4;
 num    magic_no        company_name    founded
+Warnings:
+Error  1194    Table 'test_repair_table4' is marked as crashed and should be repaired
 CHECK TABLE test_repair_table4;
 Table  Op      Msg_type        Msg_text
 test.test_repair_table4        check   status  OK

mysqltest: Result content mismatch