NetWorker: MySQL-sikkerhedskopiering mislykkes, når filen "binlog" ikke findes

Summary: De første MySQL-sikkerhedskopieringer ved hjælp af NetWorker Module for Databases and Applications (NMDA) fuldføres aldrig, når "binlog"-filen ikke findes.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

MySQL første backup slutter aldrig, når "binlog" -filen ikke findes i MySQL-databasen.

 

Cause

Da MySQL-filen "binlog" ikke findes, fortsætter NetWorker-klienten ikke sikkerhedskopieringsaktiviteten.

VIGTIGT: Beviserne vedrørende denne grundlæggende årsag vises kun, når NetWorker-sikkerhedskopieringsjobbet udføres med "Debug Level" lig med "5".

Fra NetWorker-klienten vises NetWorker-logfilen (standardplacering: /nsr/logs directory) rapporterer manglende "binlog" af den MySQL-database:

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.

 

Resolution

For at løse dette problem skal du slette alle tidligere mistede "binlog", indtil den første "binlog" er tilgængelig.

VIGTIGT: I følgende procedure kaldes den første tilgængelige "binlog" "mysql-bin.004585", men dette er blot et eksempel fra et laboratoriemiljø for at forklare en mulig løsning.

Procedure

ANSVARSFRASKRIVELSE: Før du følger denne procedure, anbefaler Dell Technologies , at du involverer en MySQL-administrator, som skal validere på forhånd, før du anvender denne metode, som den bedst mulige løsning i dit miljø.

  1. Log ind på din MySQL-server som "root" bruger.

  2. Opret forbindelse til din MySQL-databasekonsol.

  3. Kontroller den aktuelle tilgængelighed af "binlog" ved at køre følgende kommando:

    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. Ryd alle ubesvarede "binlog" før den første tilgængelige "binlog" ved at køre følgende kommando:

    Bemærk: I dette tilfælde er "mysql-bin.004585" den første "binlog", der er tilgængelig. 
    mysql> purge binary logs to 'mysql-bin.004585';
Query OK, 0 rows affected, 4584 warnings (10.12 sec)

  5. Kør sikkerhedskopieringsjobbet igen for at validere, at det fuldføres uden fejl.

    • Bevis for et vellykket sikkerhedskopieringsjob (som vist i NetWorker-logfilerne fra klientsiden):
    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.

 

Products

NetWorker Module for Databases and Applications
Article Properties
Article Number: 000173788
Article Type: Solution
Last Modified: 06 Mar 2026
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.