Logging: ./mtr --suite=sys_vars --force MySQL Version 5.1.54 Checking supported features... - skipping ndbcluster - SSL connections supported Collecting tests... vardir: /export/home/tmp/mysql/Bug52501/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/export/home/tmp/mysql/Bug52501/mysql-test/var'... Installing system database... Using server port 44446 ============================================================================== 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 ] 31680 sys_vars.sql_log_off_func [ pass ] 2 sys_vars.autocommit_func [ pass ] 836 sys_vars.identity_func [ pass ] 1073 sys_vars.last_insert_id_func [ pass ] 839 sys_vars.storage_engine_basic [ pass ] 4 sys_vars.innodb_autoinc_lock_mode_func [ pass ] 727 sys_vars.innodb_commit_concurrency_basic [ pass ] 3 sys_vars.rpl_max_binlog_size_func [ pass ] 518 sys_vars.myisam_data_pointer_size_func [ pass ] 1585 sys_vars.slow_query_log_file_func [ pass ] sys_vars.slow_query_log_file_basic [ pass ] 231 sys_vars.general_log_file_func [ pass ] 115 sys_vars.general_log_file_basic [ pass ] 322 sys_vars.delay_key_write_func [ pass ] 375 sys_vars.secure_auth_func [ pass ] 3 sys_vars.secure_file_priv [ pass ] 107 sys_vars.timestamp_sysdate_is_now_func [ pass ] 2 sys_vars.auto_commit_basic [ pass ] 3 sys_vars.auto_increment_increment_basic [ pass ] 4 sys_vars.auto_increment_increment_func [ pass ] 516 sys_vars.auto_increment_offset_basic [ pass ] 5 sys_vars.auto_increment_offset_func [ pass ] 325 sys_vars.automatic_sp_privileges_basic [ pass ] 4 sys_vars.automatic_sp_privileges_func [ pass ] 107 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 ] 1 sys_vars.bulk_insert_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.bulk_insert_buffer_size_basic_64 [ pass ] 4 sys_vars.character_set_client_basic [ pass ] 16 sys_vars.character_set_client_func [ pass ] 98 sys_vars.character_set_connection_basic [ pass ] 14 sys_vars.character_set_connection_func [ pass ] 145 sys_vars.character_set_database_basic [ pass ] 13 sys_vars.character_set_database_func [ pass ] 299 sys_vars.character_set_filesystem_basic [ pass ] 12 sys_vars.character_set_results_basic [ pass ] 14 sys_vars.character_set_results_func [ pass ] 130 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 ] 31 sys_vars.collation_connection_func [ pass ] 142 sys_vars.collation_database_basic [ pass ] 28 sys_vars.collation_database_func [ pass ] 595 sys_vars.collation_server_basic [ pass ] 31 sys_vars.collation_server_func [ pass ] 451 sys_vars.completion_type_basic [ pass ] 4 sys_vars.concurrent_insert_basic [ pass ] 3 sys_vars.concurrent_insert_func [ pass ] 198 sys_vars.connect_timeout_basic [ pass ] 3 sys_vars.datadir_basic [ pass ] 2 sys_vars.default_week_format_basic [ pass ] 5 sys_vars.default_week_format_func [ pass ] 1 sys_vars.delay_key_write_basic [ pass ] 3 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 ] 754 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 ] 3 sys_vars.div_precision_increment_basic [ pass ] 6 sys_vars.div_precision_increment_func [ fail ] Test ended at 2010-11-10 14:07:57 CURRENT_TEST: sys_vars.div_precision_increment_func mysqltest: At line 22: Spurious text after `query` expression - saving '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.div_precision_increment_func/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.div_precision_increment_func/' Retrying test sys_vars.div_precision_increment_func, attempt(2/3)... sys_vars.div_precision_increment_func [ retry-fail ] Test ended at 2010-11-10 14:07:58 CURRENT_TEST: sys_vars.div_precision_increment_func mysqltest: At line 22: Spurious text after `query` expression - saving '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.div_precision_increment_func/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.div_precision_increment_func/' Test sys_vars.div_precision_increment_func 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 ] 5 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 ] 121 sys_vars.general_log_basic [ pass ] 269 sys_vars.general_log_func [ pass ] 419 sys_vars.group_concat_max_len_basic [ pass ] 4 sys_vars.group_concat_max_len_func [ pass ] 221 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 ] 1 sys_vars.have_geometry_basic [ pass ] 1 sys_vars.have_innodb_basic [ pass ] 2 sys_vars.have_ndbcluster_basic [ pass ] 1 sys_vars.have_openssl_basic [ pass ] 1 sys_vars.have_partitioning_basic [ pass ] 1 sys_vars.have_query_cache_basic [ pass ] 2 sys_vars.have_rtree_keys_basic [ pass ] 1 sys_vars.have_ssl_basic [ pass ] 2 sys_vars.have_symlink_basic [ pass ] 1 sys_vars.hostname_basic [ pass ] 1 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 ] 116 sys_vars.interactive_timeout_basic [ pass ] 4 sys_vars.interactive_timeout_func [ pass ] 2111 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-11-10 14:08:06 CURRENT_TEST: sys_vars.join_buffer_size_basic_64 --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result 2010-11-10 15:31:28.761630851 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.reject 2010-11-10 16:08:06.411608408 +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/Bug52501/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' Retrying test sys_vars.join_buffer_size_basic_64, attempt(2/3)... sys_vars.join_buffer_size_basic_64 [ retry-fail ] Test ended at 2010-11-10 14:08:06 CURRENT_TEST: sys_vars.join_buffer_size_basic_64 --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result 2010-11-10 15:31:28.761630851 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.reject 2010-11-10 16:08:06.711564172 +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/Bug52501/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.join_buffer_size_basic_64/' Test sys_vars.join_buffer_size_basic_64 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 ] 247 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 ] 6 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 ] 23 sys_vars.lc_time_names_func [ pass ] 1 sys_vars.license_basic [ pass ] 1 sys_vars.local_infile_basic [ pass ] 3 sys_vars.local_infile_func [ pass ] 222 sys_vars.log_basic [ pass ] 179 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 ] 14 sys_vars.log_output_func [ fail ] Test ended at 2010-11-10 14:08:11 CURRENT_TEST: sys_vars.log_output_func --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/log_output_func.result 2010-11-10 15:31:28.001030338 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/log_output_func.reject 2010-11-10 16:08:11.300983705 +0300 @@ -52,7 +52,7 @@ DROP TABLE t1; connection default; SET @@global.general_log= 'OFF'; -SET @@global.general_log_file= '/home/horst/bzr/5.1-52501/mysql-test/var/mysqld.1/mysqld.log'; +SET @@global.general_log_file= '/export/home/tmp/mysql/Bug52501/mysql-test/var/mysqld.1/mysqld.log'; SET @@global.log_output= @start_value; SET @@global.general_log= @start_general_log; SET @@global.general_log= 'ON'; mysqltest: Result content mismatch - saving '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.log_output_func/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.log_output_func/' Retrying test sys_vars.log_output_func, attempt(2/3)... sys_vars.log_output_func [ retry-fail ] Test ended at 2010-11-10 14:08:13 CURRENT_TEST: sys_vars.log_output_func --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/log_output_func.result 2010-11-10 15:31:28.001030338 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/log_output_func.reject 2010-11-10 16:08:12.851637099 +0300 @@ -52,7 +52,7 @@ DROP TABLE t1; connection default; SET @@global.general_log= 'OFF'; -SET @@global.general_log_file= '/home/horst/bzr/5.1-52501/mysql-test/var/mysqld.1/mysqld.log'; +SET @@global.general_log_file= '/export/home/tmp/mysql/Bug52501/mysql-test/var/mysqld.1/mysqld.log'; SET @@global.log_output= @start_value; SET @@global.general_log= @start_general_log; SET @@global.general_log= 'ON'; mysqltest: Result content mismatch - saving '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.log_output_func/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.log_output_func/' Test sys_vars.log_output_func has failed 2 times, no more retries! sys_vars.log_queries_not_using_indexes_basic [ pass ] 3 sys_vars.log_warnings_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.log_warnings_basic_64 [ pass ] 4 sys_vars.long_query_time_basic [ pass ] 5 sys_vars.low_priority_updates_basic [ pass ] 5 sys_vars.max_allowed_packet_basic [ pass ] 5 sys_vars.max_allowed_packet_func [ pass ] 125 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 ] 5 sys_vars.max_error_count_basic [ pass ] 5 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 ] 197 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 ] 3 sys_vars.max_relay_log_size_basic [ pass ] 4 sys_vars.max_seeks_for_key_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.max_seeks_for_key_basic_64 [ pass ] 4 sys_vars.max_seeks_for_key_func [ pass ] 160 sys_vars.max_sort_length_basic [ pass ] 6 sys_vars.max_sort_length_func [ pass ] 297 sys_vars.max_sp_recursion_depth_basic [ pass ] 5 sys_vars.max_sp_recursion_depth_func [ pass ] 7 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 ] 4 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 ] 3 sys_vars.min_examined_row_limit_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.min_examined_row_limit_basic_64 [ pass ] 6 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 ] 4 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 ] 223 sys_vars.myisam_use_mmap_basic [ pass ] 2 sys_vars.ndb_log_update_as_write_basic [ pass ] 1 sys_vars.ndb_log_updated_only_basic [ pass ] 2 sys_vars.net_buffer_length_basic [ pass ] 4 sys_vars.net_read_timeout_basic [ pass ] 5 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 ] 5 sys_vars.old_passwords_basic [ pass ] 5 sys_vars.old_passwords_func [ pass ] 4 sys_vars.optimizer_prune_level_basic [ pass ] 4 sys_vars.optimizer_search_depth_basic [ pass ] 4 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 ] 6 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 ] 165 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 ] 102 sys_vars.query_cache_wlock_invalidate_basic [ pass ] 5 sys_vars.query_cache_wlock_invalidate_func [ pass ] 121 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 ] 112 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-11-10 14:08:25 CURRENT_TEST: sys_vars.read_buffer_size_basic --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_buffer_size_basic.result 2010-11-10 15:31:30.510982373 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_buffer_size_basic.reject 2010-11-10 16:08:25.001609052 +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/Bug52501/mysql-test/var/log/sys_vars.read_buffer_size_basic/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.read_buffer_size_basic/' Retrying test sys_vars.read_buffer_size_basic, attempt(2/3)... sys_vars.read_buffer_size_basic [ retry-fail ] Test ended at 2010-11-10 14:08:25 CURRENT_TEST: sys_vars.read_buffer_size_basic --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_buffer_size_basic.result 2010-11-10 15:31:30.510982373 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_buffer_size_basic.reject 2010-11-10 16:08:25.311583036 +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/Bug52501/mysql-test/var/log/sys_vars.read_buffer_size_basic/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.read_buffer_size_basic/' Test sys_vars.read_buffer_size_basic has failed 2 times, no more retries! sys_vars.read_only_basic [ pass ] 3 sys_vars.read_only_func [ pass ] 220 sys_vars.read_rnd_buffer_size_basic [ fail ] Test ended at 2010-11-10 14:08:26 CURRENT_TEST: sys_vars.read_rnd_buffer_size_basic --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.result 2010-11-10 15:31:30.510982373 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.reject 2010-11-10 16:08:26.120980877 +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/Bug52501/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' Retrying test sys_vars.read_rnd_buffer_size_basic, attempt(2/3)... sys_vars.read_rnd_buffer_size_basic [ retry-fail ] Test ended at 2010-11-10 14:08:26 CURRENT_TEST: sys_vars.read_rnd_buffer_size_basic --- /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.result 2010-11-10 15:31:30.510982373 +0300 +++ /export/home/tmp/mysql/Bug52501/mysql-test/suite/sys_vars/r/read_rnd_buffer_size_basic.reject 2010-11-10 16:08:26.459417545 +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/Bug52501/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' to '/export/home/tmp/mysql/Bug52501/mysql-test/var/log/sys_vars.read_rnd_buffer_size_basic/' Test sys_vars.read_rnd_buffer_size_basic 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 ] 4 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 ] 358 sys_vars.slave_allow_batching_basic [ pass ] 1 sys_vars.slave_compressed_protocol_basic [ pass ] 3 sys_vars.slave_exec_mode_basic [ pass ] 1 sys_vars.slave_net_timeout_basic [ pass ] 3 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 ] 3 sys_vars.slow_query_log_basic [ pass ] 209 sys_vars.slow_query_log_func [ pass ] 19937 sys_vars.sort_buffer_size_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.sort_buffer_size_basic_64 [ pass ] 4 sys_vars.sql_auto_is_null_basic [ pass ] 1 sys_vars.sql_big_selects_basic [ pass ] 3 sys_vars.sql_big_selects_func [ pass ] 3 sys_vars.sql_big_tables_basic [ pass ] 4 sys_vars.sql_big_tables_func [ pass ] 125 sys_vars.sql_buffer_result_basic [ pass ] 3 sys_vars.sql_buffer_result_func [ pass ] 4 sys_vars.sql_log_bin_basic [ pass ] 4 sys_vars.sql_log_off_basic [ pass ] 3 sys_vars.sql_low_priority_updates_basic [ pass ] 4 sys_vars.sql_low_priority_updates_func [ pass ] 139 sys_vars.sql_max_join_size_func [ pass ] 4 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 ] 3 sys_vars.sql_quote_show_create_func [ pass ] 2 sys_vars.sql_safe_updates_basic [ pass ] 4 sys_vars.sql_safe_updates_func [ pass ] 4 sys_vars.sql_select_limit_func [ pass ] 5 sys_vars.sql_slave_skip_counter_basic [ pass ] 2 sys_vars.sql_warnings_basic [ pass ] 4 sys_vars.sql_warnings_func [ pass ] 2 sys_vars.ssl_ca_basic [ pass ] 1 sys_vars.ssl_capath_basic [ pass ] 2 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 ] 3 sys_vars.time_zone_basic [ pass ] 6 sys_vars.time_zone_func [ pass ] 237 sys_vars.timed_mutexes_basic [ pass ] 4 sys_vars.timestamp_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.timestamp_basic_64 [ pass ] 2 sys_vars.timestamp_func [ pass ] 1 sys_vars.tmp_table_size_basic [ pass ] 4 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 ] 5 sys_vars.tx_isolation_basic [ pass ] 5 sys_vars.unique_checks_basic [ pass ] 3 sys_vars.updatable_views_with_limit_basic [ pass ] 7 sys_vars.updatable_views_with_limit_func [ pass ] 647 sys_vars.version_basic [ pass ] 2 sys_vars.version_comment_basic [ pass ] 2 sys_vars.version_compile_machine_basic [ pass ] 2 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 ] 5936 sys_vars.warning_count_basic [ pass ] 2 sys_vars.log_bin_trust_function_creators_func [ pass ] 455 sys_vars.completion_type_func [ pass ] 1215 sys_vars.foreign_key_checks_func [ pass ] 4469 sys_vars.innodb_additional_mem_pool_size_basic [ pass ] 2 sys_vars.innodb_autoextend_increment_basic [ pass ] 4 sys_vars.innodb_autoinc_lock_mode_basic [ pass ] 2 sys_vars.innodb_buffer_pool_size_basic [ pass ] 1 sys_vars.innodb_checksums_basic [ pass ] 2 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 ] 1 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 ] 2 sys_vars.innodb_force_recovery_basic [ pass ] 1 sys_vars.innodb_lock_wait_timeout_basic [ pass ] 1 sys_vars.innodb_locks_unsafe_for_binlog_basic [ pass ] 1 sys_vars.innodb_log_buffer_size_basic [ pass ] 2 sys_vars.innodb_log_file_size_basic [ pass ] 1 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 ] 1422 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 ] 2 sys_vars.innodb_support_xa_basic [ pass ] 6 sys_vars.innodb_support_xa_func [ pass ] 1007 sys_vars.innodb_sync_spin_loops_basic_32 [ skipped ] Need a 32 bit machine/binary sys_vars.innodb_sync_spin_loops_basic_64 [ pass ] 3 sys_vars.innodb_table_locks_basic [ pass ] 5 sys_vars.innodb_table_locks_func [ pass ] 720 sys_vars.innodb_thread_concurrency_basic [ pass ] 3 sys_vars.rpl_init_slave_func [ pass ] 5025 ------------------------------------------------------------ The servers were restarted 28 times Spent 90.684 of 182 seconds executing testcases Completed: Failed 5/285 tests, 98.25% were successful. Failing test(s): sys_vars.div_precision_increment_func sys_vars.join_buffer_size_basic_64 sys_vars.log_output_func 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