B4BY.588

: / usr / share / mysql-test / include /
Filename : show_all_relay_logs.inc
back
# ==== Purpose ====
#
# Print the contents of all relay logs to the result log. This must
# only be used for debugging.
#
# ==== Usage ====
#
# [--let $output_file= FILENAME]
# [--let $append= 1]
# [--let $rpl_debug= 1]
# --source include/show_all_binlogs.inc
#
# Parameters:
#
#   $output_file
#     By default, output is printed to the result log.  If you need to
#     print it to a specific file, specify the filename with this
#     parameter.
#
#   $append
#     By default, if $output_file is specified and the file exists,
#     this script truncates the file before it writes to it.  If
#     $append is specified, the file is not truncated and the contents
#     of the binary log is appended to the end.
#
#   $rpl_debug
#     See rpl_init.inc

--let $include_filename= show_all_relay_logs.inc
--source include/begin_include_file.inc


--disable_query_log

if ($output_file == '')
{
  --echo DO_NOT_CHECK_IN_THIS_LINE: include/show_all_relay_logs.inc should only be used for debugging. Never check in a test that calls it on success.
}

--let $last_relay_log_file= query_get_value(SHOW SLAVE STATUS, Relay_Log_File, 1)
--let $relay_log_base= `SELECT SUBSTRING_INDEX('$last_relay_log_file', '.', 1)`
--let $relay_log_count= `SELECT CONCAT('1', SUBSTRING_INDEX('$last_relay_log_file', '.', -1)) - 1000000`
--let $number= 1
while ($number <= $relay_log_count)
{
  --let $padded_number= `SELECT LPAD('$number', 6, '0')`
  --let $statement= SHOW RELAYLOG EVENTS IN '$relay_log_base.$padded_number'
  --let $header= ======== $statement ========

  if ($output_file != '')
  {
    --let $write_to_file= $output_file
    --let $write_var= $header
    --let $allow_error= 1
    --source include/write_var_to_file.inc

    --source include/write_result_to_file.inc
  }
  if ($output_file == '')
  {
    --echo $header
    --error 0, 1220 # 1220 = ER_ERROR_WHEN_EXECUTING_COMMAND
    eval $statement;
  }

  --inc $number
}


--source include/end_include_file.inc