NetWorker: MySQL-säkerhetskopiering misslyckas när "binlog"-filen inte finns

Summary: De första säkerhetskopieringarna i MySQL med NetWorker Module for Databases and Applications (NMDA) slutförs aldrig när binlog-filen inte finns.

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örsta säkerhetskopiering slutar aldrig när "binlog"-filen inte finns i MySQL-databasen.

 

Cause

Eftersom MySQL-binlog-filen inte finns fortsätter NetWorker-klienten inte säkerhetskopieringsaktiviteten.

VIKTIGT! Bevis för den här rotorsaken visas bara när NetWorker-säkerhetskopieringsjobbet utförs med "felsökningsnivå" som är lika med "5".

Från NetWorker-klienten skickas NetWorker-loggfilen (standardplats: /nsr/logs katalogen) rapporterar saknad "binlog" för den MySQL-databasen:

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

Åtgärda problemet genom att rensa alla tidigare missade "binlog" tills den första tillgängliga "binlogen".

VIKTIGT! I följande procedur heter den första tillgängliga "binlogen" "mysql-bin.004585", men detta är bara ett exempel från en labbmiljö för att förklara en möjlig lösning.

Procedur

VARNING: Innan du följer den här proceduren rekommenderar Dell Technologies att du involverar en MySQL-administratör för att validera i förväg innan du tillämpar den här metoden som den bästa möjliga lösningen enligt din miljö.

  1. Logga in på din MySQL-server som "root"-användare.

  2. Anslut till din MySQL-databaskonsol.

  3. Kontrollera aktuell tillgänglighet för "binlog" genom att köra följande 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. Rensa alla missade "binlog" före den första tillgängliga "binlog" genom att köra följande kommando:

    Obs! I det här fallet är "mysql-bin.004585" den första tillgängliga "binlogen". 
    mysql> purge binary logs to 'mysql-bin.004585';
Query OK, 0 rows affected, 4584 warnings (10.12 sec)

  5. Kör säkerhetskopieringsjobbet igen för att verifiera att det slutförs utan fel.

    • Bevis på ett lyckat säkerhetskopieringsjobb (som visas i NetWorker-loggarna från klientsidan):
    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.