Skip to content
  • Daogang Qu's avatar
    08b032eb
    Bug #26729602 UPGRADE 5.7->8.0.3: REPLICATION MAY NOT START DUE TO INDEX FILE... · 08b032eb
    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.
    08b032eb
    Bug #26729602 UPGRADE 5.7->8.0.3: REPLICATION MAY NOT START DUE TO INDEX FILE...
    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.
Loading