Logging: ./mtr --force --retry=0 sys_vars.join_buffer_size_basic_64 sys_vars.read_buffer_size_basic sys_vars.read_rnd_buffer_size_basic MySQL Version 5.1.54 Checking supported features... - skipping ndbcluster - SSL connections supported Collecting tests... vardir: /export/home/tmp/mysql/5.1-bugteam/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var'... Installing system database... Using server port 46790 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 sys_vars.join_buffer_size_basic_64 [ fail ] Test ended at 2010-11-18 16:11:12 CURRENT_TEST: sys_vars.join_buffer_size_basic_64 --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result 2010-11-18 17:37:43.311404974 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.reject 2010-11-18 18:11:12.320631140 +0300 @@ -8,15 +8,11 @@ 131072 '#--------------------FN_DYNVARS_053_01-------------------------#' SET @@global.join_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect join_buffer_size value: '8200' SET @@global.join_buffer_size = DEFAULT; SELECT @@global.join_buffer_size; @@global.join_buffer_size 131072 SET @@session.join_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect join_buffer_size value: '8200' SET @@session.join_buffer_size = DEFAULT; SELECT @@session.join_buffer_size; @@session.join_buffer_size @@ -32,8 +28,6 @@ 1 '#--------------------FN_DYNVARS_053_03-------------------------#' SET @@global.join_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect join_buffer_size value: '8200' SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228; @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228 1 @@ -48,8 +42,6 @@ 'Bug # 34837: Errors are not coming on assigning invalid values to variable' '#--------------------FN_DYNVARS_053_04-------------------------#' SET @@session.join_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect join_buffer_size value: '8200' SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228; @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228 1 mysqltest: Result content mismatch - saving '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' sys_vars.read_buffer_size_basic [ fail ] Test ended at 2010-11-18 16:11:12 CURRENT_TEST: sys_vars.read_buffer_size_basic --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_buffer_size_basic.result 2010-11-18 17:37:44.850421028 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_buffer_size_basic.reject 2010-11-18 18:11:12.631608761 +0300 @@ -32,14 +32,10 @@ 1 '#--------------------FN_DYNVARS_138_03-------------------------#' SET @@global.read_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_buffer_size value: '8201' SELECT @@global.read_buffer_size= 8200 OR @@global.read_buffer_size= 8228 ; @@global.read_buffer_size= 8200 OR @@global.read_buffer_size= 8228 1 SET @@global.read_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_buffer_size value: '8200' SELECT @@global.read_buffer_size= 8200 OR @@global.read_buffer_size= 8228 ; @@global.read_buffer_size= 8200 OR @@global.read_buffer_size= 8228 1 @@ -53,14 +49,10 @@ 2147475456 '#--------------------FN_DYNVARS_138_04-------------------------#' SET @@session.read_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_buffer_size value: '8200' SELECT @@session.read_buffer_size= 8200 OR @@session.read_buffer_size= 8228 ; @@session.read_buffer_size= 8200 OR @@session.read_buffer_size= 8228 1 SET @@session.read_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_buffer_size value: '8201' SELECT @@session.read_buffer_size= 8200 OR @@session.read_buffer_size= 8228 ; @@session.read_buffer_size= 8200 OR @@session.read_buffer_size= 8228 1 mysqltest: Result content mismatch - saving '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.read_buffer_size_basic/' to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.read_buffer_size_basic/' sys_vars.read_rnd_buffer_size_basic [ fail ] Test ended at 2010-11-18 16:11:13 CURRENT_TEST: sys_vars.read_rnd_buffer_size_basic --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.result 2010-11-18 17:37:44.860993854 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.reject 2010-11-18 18:11:12.931561621 +0300 @@ -33,14 +33,10 @@ 'Bug# 34876: This variable has invalid default value as compared to documentation'; '#--------------------FN_DYNVARS_140_03-------------------------#' SET @@global.read_rnd_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 1 SET @@global.read_rnd_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 1 @@ -55,14 +51,10 @@ 'Bug# 34877: Invalid Values are coming in variable on assigning valid values'; '#--------------------FN_DYNVARS_140_04-------------------------#' SET @@session.read_rnd_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 1 SET @@session.read_rnd_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 1 mysqltest: Result content mismatch - saving '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' ------------------------------------------------------------ The servers were restarted 2 times Spent 0.000 of 5 seconds executing testcases Completed: Failed 3/3 tests, 0.00% were successful. Failing test(s): sys_vars.join_buffer_size_basic_64 sys_vars.read_buffer_size_basic sys_vars.read_rnd_buffer_size_basic The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html