-
Daogang Qu authored
Bug #26729602 UPGRADE 5.7->8.0.3: REPLICATION MAY NOT START DUE TO INDEX FILE NEW DEFAULT NAME - post fix Problem 1 ========= main.binlog_partial_json_warnings 2017-09-12T02:26:28.880667Z 0 [Warning] [003784] You need to use --log-bin to make --binlog-format work. Analyze 1 ========= The main.binlog_partial_json_warnings is reporting the above warning with --binlog_format=mixed on weekly-trunk, since it restarts the server with --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL --skip-log-bin --skip-log-slave-updates --skip-slave-preserve-commit-order. Fix 1 ===== To fix the problem, suppress the warning in the test. Problem 2 ========= CURRENT_TEST: sys_vars.log_bin_basic select @@global.log_bin; @@global.log_bin -1 +0 select @@session.log_bin; ERROR HY000: Variable 'log_bin' is a GLOBAL variable show global variables like 'log_bin'; Variable_name Value -log_bin ON +log_bin OFF show session variables like 'log_bin'; Variable_name Value -log_bin ON +log_bin OFF select * from performance_schema.global_variables where variable_name='log_bin'; VARIABLE_NAME VARIABLE_VALUE -log_bin ON +log_bin OFF select * from performance_schema.session_variables where variable_name='log_bin'; VARIABLE_NAME VARIABLE_VALUE -log_bin ON +log_bin OFF Analyze 2 ========= The main.binlog_partial_json_warnings is reporting the above mismatch on weekly-trunk, since it runs test with --mysqld=--skip-log-bin --mysqld=--skip-log-slave-updates --mysqld=--skip-slave-preserve-commit-order. Fix 2 ===== To fix the problem, source have_log_bin.inc in the test. Problem 3 ========= main.binlog_partial_json_warnings 2017-09-09T14:20:50.365565Z 0 [Warning] [003786] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=siv28-bin' to avoid this problem. Analyze 3 ========= The main.binlog_partial_json_warnings is reporting the above warning with --mysqld=--skip-log-bin --mysqld=--skip-log-slave-updates --mysqld=--skip-slave-preserve-commit-order on weekly-trunk, since it restarts the server with --log-bin --binlog-format=statement --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL. Fix 3 ===== To fix the problem, suppress the warning in the test.
Daogang Qu authoredBug #26729602 UPGRADE 5.7->8.0.3: REPLICATION MAY NOT START DUE TO INDEX FILE NEW DEFAULT NAME - post fix Problem 1 ========= main.binlog_partial_json_warnings 2017-09-12T02:26:28.880667Z 0 [Warning] [003784] You need to use --log-bin to make --binlog-format work. Analyze 1 ========= The main.binlog_partial_json_warnings is reporting the above warning with --binlog_format=mixed on weekly-trunk, since it restarts the server with --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL --skip-log-bin --skip-log-slave-updates --skip-slave-preserve-commit-order. Fix 1 ===== To fix the problem, suppress the warning in the test. Problem 2 ========= CURRENT_TEST: sys_vars.log_bin_basic select @@global.log_bin; @@global.log_bin -1 +0 select @@session.log_bin; ERROR HY000: Variable 'log_bin' is a GLOBAL variable show global variables like 'log_bin'; Variable_name Value -log_bin ON +log_bin OFF show session variables like 'log_bin'; Variable_name Value -log_bin ON +log_bin OFF select * from performance_schema.global_variables where variable_name='log_bin'; VARIABLE_NAME VARIABLE_VALUE -log_bin ON +log_bin OFF select * from performance_schema.session_variables where variable_name='log_bin'; VARIABLE_NAME VARIABLE_VALUE -log_bin ON +log_bin OFF Analyze 2 ========= The main.binlog_partial_json_warnings is reporting the above mismatch on weekly-trunk, since it runs test with --mysqld=--skip-log-bin --mysqld=--skip-log-slave-updates --mysqld=--skip-slave-preserve-commit-order. Fix 2 ===== To fix the problem, source have_log_bin.inc in the test. Problem 3 ========= main.binlog_partial_json_warnings 2017-09-09T14:20:50.365565Z 0 [Warning] [003786] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=siv28-bin' to avoid this problem. Analyze 3 ========= The main.binlog_partial_json_warnings is reporting the above warning with --mysqld=--skip-log-bin --mysqld=--skip-log-slave-updates --mysqld=--skip-slave-preserve-commit-order on weekly-trunk, since it restarts the server with --log-bin --binlog-format=statement --binlog-row-value-options=PARTIAL_JSON --binlog-row-image=MINIMAL. Fix 3 ===== To fix the problem, suppress the warning in the test.
Loading