Logging: ./mtr --suite=sys_vars --force MySQL Version 5.1.52 Checking supported features... - skipping ndbcluster - SSL connections supported Collecting tests... vardir: /export/home/tmp/mysql/5.1-bugteam/mysql-test/var Checking leftover processes... - found old pid 23473 in 'mysqld.1.pid', killing it... process did not exist! Removing old var directory... Creating var directory '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var'... Installing system database... Using server port 52883 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 sys_vars.max_binlog_cache_size_basic_32 [ disabled ] bug#56408 2010-08-31 Horst sys_vars.max_binlog_cache_size_basic_64 [ disabled ] bug#56408 2010-08-31 Horst sys_vars.tx_isolation_func [ pass ] 31608 sys_vars.sql_log_off_func [ pass ] 2 sys_vars.autocommit_func [ pass ] 810 sys_vars.identity_func [ pass ] 1113 sys_vars.last_insert_id_func [ pass ] 1032 sys_vars.storage_engine_basic [ pass ] 3 sys_vars.innodb_autoinc_lock_mode_func [ pass ] 473 sys_vars.innodb_commit_concurrency_basic [ pass ] 3 sys_vars.rpl_max_binlog_size_func [ pass ] 890 sys_vars.myisam_data_pointer_size_func [ pass ] 1725 sys_vars.slow_query_log_file_func [ pass ] 1 sys_vars.slow_query_log_file_basic [ pass ] 183 MTR's internal check of the test case 'sys_vars.slow_query_log_file_basic' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result 2010-10-25 14:49:49.576986214 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.reject 2010-10-25 14:49:49.846986767 +0300 @@ -199,7 +199,7 @@ SLAVE_TRANSACTION_RETRIES 10 SLOW_LAUNCH_TIME 2 SLOW_QUERY_LOG ON -SLOW_QUERY_LOG_FILE slowtest.log +SLOW_QUERY_LOG_FILE /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/run/mysqld-slow.log SOCKET /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/mysqld.1.sock SORT_BUFFER_SIZE 262144 SQL_AUTO_IS_NULL ON mysqltest: Result content mismatch not ok sys_vars.general_log_file_func [ pass ] 106 sys_vars.general_log_file_basic [ pass ] 364 MTR's internal check of the test case 'sys_vars.general_log_file_basic' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result 2010-10-25 14:49:50.676962869 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.reject 2010-10-25 14:49:51.126962415 +0300 @@ -46,7 +46,7 @@ FT_QUERY_EXPANSION_LIMIT 20 FT_STOPWORD_FILE (built-in) GENERAL_LOG ON -GENERAL_LOG_FILE test.log +GENERAL_LOG_FILE /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/run/mysqld.log GROUP_CONCAT_MAX_LEN 1024 HAVE_COMMUNITY_FEATURES YES HAVE_COMPRESS YES mysqltest: Result content mismatch not ok sys_vars.delay_key_write_func [ pass ] 266 sys_vars.secure_auth_func [ pass ] 2 sys_vars.secure_file_priv [ pass ] 92 sys_vars.timestamp_sysdate_is_now_func [ pass ] 1 sys_vars.auto_commit_basic [ pass ] 4 sys_vars.auto_increment_increment_basic [ pass ] 5 sys_vars.auto_increment_increment_func [ pass ] 337 sys_vars.auto_increment_offset_basic [ pass ] 5 sys_vars.auto_increment_offset_func [ pass ] 237 sys_vars.automatic_sp_privileges_basic [ pass ] 3 sys_vars.automatic_sp_privileges_func [ pass ] 83 sys_vars.basedir_basic [ pass ] 2 sys_vars.big_tables_basic [ pass ] 3 sys_vars.binlog_cache_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.binlog_cache_size_basic_64 [ pass ] 3 sys_vars.binlog_format_basic [ pass ] 2 sys_vars.bulk_insert_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.bulk_insert_buffer_size_basic_64 [ pass ] 5 sys_vars.character_set_client_basic [ pass ] 16 sys_vars.character_set_client_func [ pass ] 81 sys_vars.character_set_connection_basic [ pass ] 13 sys_vars.character_set_connection_func [ pass ] 87 sys_vars.character_set_database_basic [ pass ] 12 sys_vars.character_set_database_func [ pass ] 442 sys_vars.character_set_filesystem_basic [ pass ] 12 sys_vars.character_set_results_basic [ pass ] 14 sys_vars.character_set_results_func [ pass ] 87 sys_vars.character_set_server_basic [ pass ] 13 sys_vars.character_set_server_func [ pass ] 3 sys_vars.character_set_system_basic [ pass ] 1 sys_vars.collation_connection_basic [ pass ] 29 sys_vars.collation_connection_func [ pass ] 104 sys_vars.collation_database_basic [ pass ] 28 sys_vars.collation_database_func [ pass ] 556 sys_vars.collation_server_basic [ pass ] 28 sys_vars.collation_server_func [ pass ] 596 sys_vars.completion_type_basic [ pass ] 4 sys_vars.concurrent_insert_basic [ pass ] 3 sys_vars.concurrent_insert_func [ pass ] 86 sys_vars.connect_timeout_basic [ pass ] 4 sys_vars.datadir_basic [ pass ] 1 sys_vars.default_week_format_basic [ pass ] 4 sys_vars.default_week_format_func [ pass ] 1 sys_vars.delay_key_write_basic [ pass ] 2 sys_vars.delayed_insert_limit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.delayed_insert_limit_basic_64 [ pass ] 4 sys_vars.delayed_insert_limit_func [ pass ] 652 sys_vars.delayed_insert_timeout_basic [ pass ] 3 sys_vars.delayed_queue_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.delayed_queue_size_basic_64 [ pass ] 4 sys_vars.div_precision_increment_basic [ pass ] 5 sys_vars.div_precision_increment_func [ fail ] Test ended at 2010-10-25 13:50:03 CURRENT_TEST: sys_vars.div_precision_increment_func mysqltest: At line 22: Spurious text after `query` expression - saving '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.div_precision_increment_func/' to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.div_precision_increment_func/' Retrying test, attempt(2/3)... sys_vars.div_precision_increment_func [ retry-fail ] Test ended at 2010-10-25 13:50:03 CURRENT_TEST: sys_vars.div_precision_increment_func mysqltest: At line 22: Spurious text after `query` expression - saving '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.div_precision_increment_func/' to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/log/sys_vars.div_precision_increment_func/' Test has failed 2 times, no more retries! sys_vars.engine_condition_pushdown_basic [ pass ] 5 sys_vars.error_count_basic [ pass ] 1 sys_vars.event_scheduler_basic [ pass ] 4 sys_vars.expire_logs_days_basic [ pass ] 4 sys_vars.flush_basic [ pass ] 3 sys_vars.foreign_key_checks_basic [ pass ] 3 sys_vars.ft_boolean_syntax_basic [ pass ] 4 sys_vars.ft_boolean_syntax_func [ pass ] 85 sys_vars.general_log_basic [ pass ] 184 sys_vars.general_log_func [ pass ] 408 MTR's internal check of the test case 'sys_vars.general_log_func' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result 2010-10-25 14:50:05.556988881 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.reject 2010-10-25 14:50:06.036966928 +0300 @@ -99,7 +99,7 @@ LOWER_CASE_FILE_SYSTEM OFF LOWER_CASE_TABLE_NAMES 0 LOW_PRIORITY_UPDATES OFF -MAX_ALLOWED_PACKET 1048576 +MAX_ALLOWED_PACKET 1073741824 MAX_BINLOG_CACHE_SIZE 18446744073709547520 MAX_BINLOG_SIZE 1073741824 MAX_CONNECTIONS 151 mysqltest: Result content mismatch not ok sys_vars.group_concat_max_len_basic [ pass ] 4 sys_vars.group_concat_max_len_func [ pass ] 86 sys_vars.have_compress_basic [ pass ] 2 sys_vars.have_crypt_basic [ pass ] 1 sys_vars.have_csv_basic [ pass ] 1 sys_vars.have_dynamic_loading_basic [ pass ] 2 sys_vars.have_geometry_basic [ pass ] 1 sys_vars.have_innodb_basic [ pass ] 1 sys_vars.have_ndbcluster_basic [ pass ] 1 sys_vars.have_openssl_basic [ pass ] 1 sys_vars.have_partitioning_basic [ pass ] 2 sys_vars.have_query_cache_basic [ pass ] 2 sys_vars.have_rtree_keys_basic [ pass ] 1 sys_vars.have_ssl_basic [ pass ] 1 sys_vars.have_symlink_basic [ pass ] 1 sys_vars.hostname_basic [ pass ] 2 sys_vars.identity_basic [ pass ] 3 sys_vars.init_connect_basic [ pass ] 3 sys_vars.init_slave_basic [ pass ] 3 sys_vars.insert_id_basic [ pass ] 3 sys_vars.insert_id_func [ pass ] 75 sys_vars.interactive_timeout_basic [ pass ] 5 sys_vars.interactive_timeout_func [ pass ] 2070 sys_vars.join_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.join_buffer_size_basic_64 [ fail ] Test ended at 2010-10-25 13:50: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-10-25 14:15:27.755366488 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.reject 2010-10-25 14:50:12.006992435 +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/' Retrying test, attempt(2/3)... sys_vars.join_buffer_size_basic_64 [ retry-fail ] Test ended at 2010-10-25 13:50: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-10-25 14:15:27.755366488 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.reject 2010-10-25 14:50:12.316994449 +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/' Test has failed 2 times, no more retries! sys_vars.keep_files_on_create_basic [ pass ] 4 sys_vars.key_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.key_buffer_size_basic_64 [ pass ] 4 sys_vars.key_buffer_size_func [ pass ] 203 sys_vars.key_cache_age_threshold_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.key_cache_age_threshold_basic_64 [ pass ] 4 sys_vars.key_cache_block_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.key_cache_block_size_basic_64 [ pass ] 4 sys_vars.key_cache_division_limit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.key_cache_division_limit_basic_64 [ pass ] 4 sys_vars.lc_time_names_basic [ pass ] 24 sys_vars.lc_time_names_func [ pass ] 2 sys_vars.license_basic [ pass ] 1 sys_vars.local_infile_basic [ pass ] 3 sys_vars.local_infile_func [ pass ] 165 sys_vars.log_basic [ pass ] 238 sys_vars.log_bin_trust_function_creators_basic [ pass ] 3 sys_vars.log_bin_trust_routine_creators_basic [ pass ] 4 sys_vars.log_output_basic [ pass ] 11 sys_vars.log_output_func [ pass ] 890 MTR's internal check of the test case 'sys_vars.log_output_func' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.result 2010-10-25 14:50:15.726988007 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/tmp/check-mysqld_1.reject 2010-10-25 14:50:16.686950165 +0300 @@ -46,7 +46,7 @@ FT_QUERY_EXPANSION_LIMIT 20 FT_STOPWORD_FILE (built-in) GENERAL_LOG ON -GENERAL_LOG_FILE /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/mysqld.1/mysqld.log +GENERAL_LOG_FILE /export/home/tmp/mysql/5.1-bugteam/mysql-test/var/run/mysqld.log GROUP_CONCAT_MAX_LEN 1024 HAVE_COMMUNITY_FEATURES YES HAVE_COMPRESS YES mysqltest: Result content mismatch not ok sys_vars.log_queries_not_using_indexes_basic [ pass ] 2 sys_vars.log_warnings_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.log_warnings_basic_64 [ pass ] 5 sys_vars.long_query_time_basic [ pass ] 5 sys_vars.low_priority_updates_basic [ pass ] 4 sys_vars.max_allowed_packet_basic [ pass ] 5 sys_vars.max_allowed_packet_func [ pass ] 70 sys_vars.max_binlog_size_basic [ pass ] 4 sys_vars.max_connect_errors_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_connect_errors_basic_64 [ pass ] 4 sys_vars.max_connections_basic [ pass ] 4 sys_vars.max_delayed_threads_basic [ pass ] 4 sys_vars.max_error_count_basic [ pass ] 4 sys_vars.max_heap_table_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_heap_table_size_basic_64 [ pass ] 5 sys_vars.max_insert_delayed_threads_basic [ pass ] 5 sys_vars.max_join_size_func [ pass ] 132 sys_vars.max_length_for_sort_data_basic [ pass ] 5 sys_vars.max_prepared_stmt_count_basic [ pass ] 4 sys_vars.max_prepared_stmt_count_func [ pass ] 2 sys_vars.max_relay_log_size_basic [ pass ] 3 sys_vars.max_seeks_for_key_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_seeks_for_key_basic_64 [ pass ] 5 sys_vars.max_seeks_for_key_func [ pass ] 110 sys_vars.max_sort_length_basic [ pass ] 5 sys_vars.max_sort_length_func [ pass ] 708 sys_vars.max_sp_recursion_depth_basic [ pass ] 5 sys_vars.max_sp_recursion_depth_func [ pass ] 5 sys_vars.max_tmp_tables_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_tmp_tables_basic_64 [ pass ] 5 sys_vars.max_user_connections_basic [ pass ] 3 sys_vars.max_user_connections_func [ pass ] 103 sys_vars.max_write_lock_count_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_write_lock_count_basic_64 [ pass ] 4 sys_vars.min_examined_row_limit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.min_examined_row_limit_basic_64 [ pass ] 4 sys_vars.multi_range_count_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.multi_range_count_basic_64 [ pass ] 5 sys_vars.myisam_data_pointer_size_basic [ pass ] 5 sys_vars.myisam_max_sort_file_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.myisam_max_sort_file_size_basic_64 [ pass ] 4 sys_vars.myisam_repair_threads_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.myisam_repair_threads_basic_64 [ pass ] 5 sys_vars.myisam_sort_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.myisam_sort_buffer_size_basic_64 [ pass ] 5 sys_vars.myisam_stats_method_basic [ pass ] 4 sys_vars.myisam_stats_method_func [ pass ] 194 sys_vars.myisam_use_mmap_basic [ pass ] 2 sys_vars.ndb_log_update_as_write_basic [ pass ] 2 sys_vars.ndb_log_updated_only_basic [ pass ] 2 sys_vars.net_buffer_length_basic [ pass ] 4 sys_vars.net_read_timeout_basic [ pass ] 4 sys_vars.net_retry_count_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.net_retry_count_basic_64 [ pass ] 5 sys_vars.net_write_timeout_basic [ pass ] 4 sys_vars.new_basic [ pass ] 4 sys_vars.old_passwords_basic [ pass ] 5 sys_vars.old_passwords_func [ pass ] 4 sys_vars.optimizer_prune_level_basic [ pass ] 5 sys_vars.optimizer_search_depth_basic [ pass ] 5 sys_vars.preload_buffer_size_basic [ pass ] 5 sys_vars.query_alloc_block_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.query_alloc_block_size_basic_64 [ pass ] 5 sys_vars.query_cache_limit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.query_cache_limit_basic_64 [ pass ] 4 sys_vars.query_cache_limit_func [ pass ] 122 sys_vars.query_cache_min_res_unit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.query_cache_min_res_unit_basic_64 [ pass ] 4 sys_vars.query_cache_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.query_cache_size_basic_64 [ pass ] 5 sys_vars.query_cache_type_basic [ pass ] 4 sys_vars.query_cache_type_func [ pass ] 98 sys_vars.query_cache_wlock_invalidate_basic [ pass ] 4 sys_vars.query_cache_wlock_invalidate_func [ pass ] 106 sys_vars.query_prealloc_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.query_prealloc_size_basic_64 [ pass ] 5 sys_vars.query_prealloc_size_func [ pass ] 76 sys_vars.range_alloc_block_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.range_alloc_block_size_basic_64 [ pass ] 5 sys_vars.read_buffer_size_basic [ fail ] Test ended at 2010-10-25 13:50:29 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-10-25 14:15:29.515350390 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_buffer_size_basic.reject 2010-10-25 14:50:28.856984141 +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/' Retrying test, attempt(2/3)... sys_vars.read_buffer_size_basic [ retry-fail ] Test ended at 2010-10-25 13:50:29 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-10-25 14:15:29.515350390 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_buffer_size_basic.reject 2010-10-25 14:50:29.156959552 +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/' Test has failed 2 times, no more retries! sys_vars.read_only_basic [ pass ] 3 sys_vars.read_only_func [ pass ] 171 sys_vars.read_rnd_buffer_size_basic [ fail ] Test ended at 2010-10-25 13:50:30 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-10-25 14:15:29.515350390 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.reject 2010-10-25 14:50:29.936988444 +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/' Retrying test, attempt(2/3)... sys_vars.read_rnd_buffer_size_basic [ retry-fail ] Test ended at 2010-10-25 13:50:30 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-10-25 14:15:29.515350390 +0300 +++ /export/home/tmp/mysql/5.1-bugteam/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.reject 2010-10-25 14:50:30.246995037 +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/' Test has failed 2 times, no more retries! sys_vars.relay_log_purge_basic [ pass ] 3 sys_vars.rpl_recovery_rank_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.rpl_recovery_rank_basic_64 [ pass ] 3 sys_vars.secure_auth_basic [ pass ] 4 sys_vars.server_id_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.server_id_basic_64 [ pass ] 124 sys_vars.slave_allow_batching_basic [ pass ] 1 sys_vars.slave_compressed_protocol_basic [ pass ] 4 sys_vars.slave_exec_mode_basic [ pass ] 1 sys_vars.slave_net_timeout_basic [ pass ] 4 sys_vars.slave_transaction_retries_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.slave_transaction_retries_basic_64 [ pass ] 4 sys_vars.slow_launch_time_basic [ pass ] 4 sys_vars.slow_launch_time_func [ pass ] 2 sys_vars.slow_query_log_basic [ pass ] 213 sys_vars.slow_query_log_func [ pass ] 19690 sys_vars.sort_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.sort_buffer_size_basic_64 [ pass ] 5 sys_vars.sql_auto_is_null_basic [ pass ] 1 sys_vars.sql_big_selects_basic [ pass ] 4 sys_vars.sql_big_selects_func [ pass ] 3 sys_vars.sql_big_tables_basic [ pass ] 4 sys_vars.sql_big_tables_func [ pass ] 277 sys_vars.sql_buffer_result_basic [ pass ] 3 sys_vars.sql_buffer_result_func [ pass ] 4 sys_vars.sql_log_bin_basic [ pass ] 3 sys_vars.sql_log_off_basic [ pass ] 4 sys_vars.sql_low_priority_updates_basic [ pass ] 5 sys_vars.sql_low_priority_updates_func [ pass ] 296 sys_vars.sql_max_join_size_func [ pass ] 5 sys_vars.sql_mode_basic [ pass ] 10 sys_vars.sql_mode_func [ pass ] 5 sys_vars.sql_notes_basic [ pass ] 3 sys_vars.sql_notes_func [ pass ] 3 sys_vars.sql_quote_show_create_basic [ pass ] 4 sys_vars.sql_quote_show_create_func [ pass ] 2 sys_vars.sql_safe_updates_basic [ pass ] 3 sys_vars.sql_safe_updates_func [ pass ] 5 sys_vars.sql_select_limit_func [ pass ] 6 sys_vars.sql_slave_skip_counter_basic [ pass ] 2 sys_vars.sql_warnings_basic [ pass ] 3 sys_vars.sql_warnings_func [ pass ] 3 sys_vars.ssl_ca_basic [ pass ] 1 sys_vars.ssl_capath_basic [ pass ] 1 sys_vars.ssl_cert_basic [ pass ] 2 sys_vars.ssl_cipher_basic [ pass ] 1 sys_vars.ssl_key_basic [ pass ] 2 sys_vars.sync_binlog_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.sync_binlog_basic_64 [ pass ] 3 sys_vars.sync_frm_basic [ pass ] 3 sys_vars.system_time_zone_basic [ pass ] 1 sys_vars.table_definition_cache_basic [ pass ] 4 sys_vars.table_lock_wait_timeout_basic [ pass ] 3 sys_vars.table_open_cache_basic [ pass ] 3 sys_vars.thread_cache_size_func [ pass ] 4 sys_vars.thread_handling_basic [ pass ] 1 sys_vars.time_zone_basic [ pass ] 6 sys_vars.time_zone_func [ pass ] 345 sys_vars.timed_mutexes_basic [ pass ] 3 sys_vars.timestamp_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.timestamp_basic_64 [ pass ] 3 sys_vars.timestamp_func [ pass ] 1 sys_vars.tmp_table_size_basic [ pass ] 5 sys_vars.tmpdir_basic [ pass ] 1 sys_vars.transaction_alloc_block_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.transaction_alloc_block_size_basic_64 [ pass ] 5 sys_vars.transaction_prealloc_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.transaction_prealloc_size_basic_64 [ pass ] 4 sys_vars.tx_isolation_basic [ pass ] 5 sys_vars.unique_checks_basic [ pass ] 3 sys_vars.updatable_views_with_limit_basic [ pass ] 5 sys_vars.updatable_views_with_limit_func [ pass ] 265 sys_vars.version_basic [ pass ] 1 sys_vars.version_comment_basic [ pass ] 1 sys_vars.version_compile_machine_basic [ pass ] 1 sys_vars.version_compile_os_basic [ pass ] 1 sys_vars.wait_timeout_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.wait_timeout_basic_64 [ pass ] 4 sys_vars.wait_timeout_func [ pass ] 4929 sys_vars.warning_count_basic [ pass ] 1 sys_vars.log_bin_trust_function_creators_func [ pass ] 457 sys_vars.completion_type_func [ pass ] 1175 sys_vars.foreign_key_checks_func [ pass ] 4565 sys_vars.innodb_additional_mem_pool_size_basic [ pass ] 1 sys_vars.innodb_autoextend_increment_basic [ pass ] 3 sys_vars.innodb_autoinc_lock_mode_basic [ pass ] 2 sys_vars.innodb_buffer_pool_size_basic [ pass ] 1 sys_vars.innodb_checksums_basic [ pass ] 1 sys_vars.innodb_concurrency_tickets_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.innodb_concurrency_tickets_basic_64 [ pass ] 4 sys_vars.innodb_data_file_path_basic [ pass ] 2 sys_vars.innodb_data_home_dir_basic [ pass ] 1 sys_vars.innodb_doublewrite_basic [ pass ] 2 sys_vars.innodb_fast_shutdown_basic [ pass ] 4 sys_vars.innodb_file_io_threads_basic [ pass ] 1 sys_vars.innodb_file_per_table_basic [ pass ] 1 sys_vars.innodb_flush_log_at_trx_commit_basic [ pass ] 3 sys_vars.innodb_flush_method_basic [ pass ] 1 sys_vars.innodb_force_recovery_basic [ pass ] 1 sys_vars.innodb_lock_wait_timeout_basic [ pass ] 2 sys_vars.innodb_locks_unsafe_for_binlog_basic [ pass ] 2 sys_vars.innodb_log_buffer_size_basic [ pass ] 2 sys_vars.innodb_log_file_size_basic [ pass ] 2 sys_vars.innodb_log_files_in_group_basic [ pass ] 1 sys_vars.innodb_log_group_home_dir_basic [ pass ] 1 sys_vars.innodb_max_dirty_pages_pct_basic [ pass ] 3 sys_vars.innodb_max_dirty_pages_pct_func [ pass ] 1826 sys_vars.innodb_max_purge_lag_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.innodb_max_purge_lag_basic_64 [ pass ] 3 sys_vars.innodb_mirrored_log_groups_basic [ pass ] 1 sys_vars.innodb_open_files_basic [ pass ] 1 sys_vars.innodb_rollback_on_timeout_basic [ pass ] 1 sys_vars.innodb_support_xa_basic [ pass ] 5 sys_vars.innodb_support_xa_func [ pass ] 959 sys_vars.innodb_sync_spin_loops_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.innodb_sync_spin_loops_basic_64 [ pass ] 4 sys_vars.innodb_table_locks_basic [ pass ] 4 sys_vars.innodb_table_locks_func [ pass ] 489 sys_vars.innodb_thread_concurrency_basic [ pass ] 3 sys_vars.rpl_init_slave_func [ pass ] 3415 ------------------------------------------------------------ The servers were restarted 28 times Spent 88.190 of 176 seconds executing testcases Check of testcase failed for: sys_vars.log_output_func sys_vars.slow_query_log_file_basic sys_vars.general_log_file_basic sys_vars.general_log_func Completed: Failed 4/285 tests, 98.60% were successful. Failing test(s): sys_vars.div_precision_increment_func 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