Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
-
None
Description
CURRENT_TEST: sys_vars.pseudo_slave_mode_basic
|
--- /home/sanja/maria/git/server/mysql-test/suite/sys_vars/r/pseudo_slave_mode_basic.result 2021-08-04 21:06:51.360558653 +0200
|
+++ /home/sanja/maria/git/server/mysql-test/suite/sys_vars/r/pseudo_slave_mode_basic.reject 2021-08-17 09:12:00.720160187 +0200
|
@@ -4,8 +4,6 @@
|
0
|
'#--------------------FN_DYNVARS_156_01------------------------#'
|
SET @@session.pseudo_slave_mode = 0;
|
-Warnings:
|
-Warning 1231 'pseudo_slave_mode' change was ineffective.
|
SET @@session.pseudo_slave_mode = DEFAULT;
|
Warnings:
|
Warning 1231 'pseudo_slave_mode' change was ineffective.
|
 |
mysqltest: Result length mismatch
|
Here is the sequence which lead to the problem (I can not make it smaller). Also on my computer it is 100% fail, when on Elena's computer with some probability.
perl ./mtr main.func_op main.get_diagnostics main.grant5 main.grant_binlog_replay main.grant_cache_no_prot main.grant_kill main.grant_lowercase_fs main.grant_master_admin main.grant_not_windows main.grant_repair main.grant_slave_admin main.grant_slave_monitor main.greedy_optimizer main.group_by main.group_by_null main.group_min_max main.handler_read_last main.having main.having_cond_pushdown main.help main.implicit_char_to_num_conversion main.in_datetime_241 main.in_subq_cond_pushdown main.index_intersect main.information_schema2 main.information_schema_chmod main.information_schema_db main.information_schema_linux sys_vars.myisam_max_sort_file_size_basic sys_vars.myisam_mmap_size_basic sys_vars.myisam_repair_threads_basic sys_vars.myisam_sort_buffer_size_basic sys_vars.myisam_stats_method_basic sys_vars.myisam_stats_method_func sys_vars.myisam_use_mmap_basic sys_vars.mysql56_temporal_format_basic sys_vars.mysql56_temporal_format_func sys_vars.named_pipe_basic sys_vars.net_buffer_length_basic sys_vars.net_read_timeout_basic sys_vars.net_retry_count_basic sys_vars.net_write_timeout_basic sys_vars.old_alter_table_basic sys_vars.old_basic sys_vars.old_mode_basic sys_vars.old_passwords_basic sys_vars.old_passwords_func sys_vars.open_files_limit_basic sys_vars.optimizer_prune_level_basic sys_vars.optimizer_search_depth_basic sys_vars.optimizer_selectivity_sampling_limit_basic sys_vars.optimizer_switch_basic sys_vars.optimizer_use_condition_selectivity_basic sys_vars.oqgraph_allow_create_integer_latch_basic sys_vars.pfs_digests_size_basic sys_vars.pfs_max_digest_length_basic sys_vars.pid_file_basic sys_vars.plugin_maturity_basic sys_vars.port_basic sys_vars.preload_buffer_size_basic sys_vars.preudo_thread_id_grant sys_vars.profiling_basic sys_vars.profiling_history_size_basic sys_vars.progress_report_time_basic sys_vars.protocol_version_basic sys_vars.proxy_protocol_networks_grant sys_vars.proxy_user_basic sys_vars.pseudo_slave_mode_basic --mem --noreorder
|
On 10.6 this short and full sequences do lead to error.
10.4 lack many of tests which I could not remove from the sequence on 10.5, so it is not surprise that I was not able to repeat on 10.4 (it does not mean that the bug is absent there)