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
© 2025, Oracle Corporation and/or its affiliates
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