• Sujatha Sivakumar's avatar
    Bug#13833962:DISABLE [NOTE] START BINLOG_DUMP TO SLAVE_SERVER(0) MESSAGES · dcd4fa3f
    Sujatha Sivakumar authored
    IN THE ERROR LOG
          
    Problem:
    Using mysqlbinlog with the --read-from-remote-server option as shown below
    prints a message in error log for each call. This happens for 5.5 and above
    versions
          
    mysqlbinlog -uroot -p --read-from-remote-server --host=localhost test
          
    Message in error log file is given below:
    120312 10:27:57 [Note] Start binlog_dump to slave_server(0), pos(test, 4)
          
    The problem is that it can fill up the error log if the command is called
    very often.
          
    Analysis:
    The below mentioned print function is called from "mysql_binlog_send" function
    which causes the "Start binlog_dump..." string to be printed in error log file.
    
    sql_print_information("Start binlog_dump to master_thread_id(%lu) 
    slave_server(%d)..."
          
    Fix:
    A condition has been added in such a way that the 'sql_print_information' 
    will be invoked only when the "log_warnings" variable is set to >1 
    otherwise don't call the 'sql_print_information' function.
    
    dcd4fa3f
sql_repl.cc 62.5 KB