NetWorker：「binlog」ファイルが存在しない場合にMySQLバックアップが失敗する

「binlog」ファイルがMySQLデータベースに存在しない場合、MySQLの最初のバックアップは終了しません。

MySQLの「binlog」ファイルが存在しないため、NetWorkerクライアントはバックアップ アクティビティを続行しません。

NetWorkerクライアントから、NetWorkerログ ファイル(デフォルトの場所: /nsr/logsディレクトリー)は、そのMySQLデータベースの「binlog」がないことを報告します。

mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000331' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000332' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000333' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000334' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000335' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000336' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000337' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000338' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000339' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000340' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000341' does not exist. It could have been purged. PITR will not be possible from this backup.
  ...
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.004583' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.004584' does not exist. It could have been purged. PITR will not be possible from this backup.
 200901 14:37:32 mysqlbackup: INFO: Copying /data/mysql/mysql-bin.004585. <-- Activity log stuck in this step and backup does not send any new data.The backup job must be canceled manually or wait to timeout (in this case it was after 8 hours running).
 mysqlbackup: Progress in MB: 383400
 mysqlbackup: ERROR: Signal 15 received.

この問題に対処するには、最初の「binlog」が使用可能になるまで、以前に欠落したすべての「binlog」をパージします。

手順

1. MySQLサーバーに「root」ユーザーとしてログインします。

2. MySQLデータベース コンソールに接続します。

3. 次のコマンドを実行して、"binlog" の現在の可用性を確認します。

   mysql> show master logs;  <-- Name of the DB that contains the information from the logs missed.
   
   | mysql-bin.004580 |          0 |
   | mysql-bin.004581 |          0 |
   | mysql-bin.004582 |          0 |
   | mysql-bin.004583 |          0 |
   | mysql-bin.004584 |          0 | <-- Last missed log.
   | mysql-bin.004585 | 1064394753 |

4. 次のコマンドを実行して、使用可能な最初の「binlog」の前に、欠落した「binlog」をすべてパージします。

   注：この場合、「mysql-bin.004585」が使用可能な最初の「binlog」です。

   mysql> purge binary logs to 'mysql-bin.004585';
   Query OK, 0 rows affected, 4584 warnings (10.12 sec)

5. バックアップ ジョブを再実行して、エラーなしで完了したことを確認します。

   • バックアップ ジョブが正常に完了した証拠(クライアント側からNetWorkerログに表示される):

   200903 09:38:14 mysqlbackup: INFO: Backup image created successfully.
   mysqlbackup: INFO: Image Path = sbt:MYSQL:/MySQLTest
   200903 09:38:14 mysqlbackup: INFO: MySQL binlog position: filename mysql-bin.004957, position 154
   
   -------------------------------------------------------------
      Parameters Summary
   -------------------------------------------------------------
      Start LSN                  : 15597868102656
      End LSN                    : 15597868102712
   -------------------------------------------------------------
   mysqlbackup completed OK! with 2 warnings.