Networker: MySQL first backup using NMDA never completes when "binlog" does not exist.
Summary: MySQL backups using NetWorker Module for Databases and Applications (NMDA) never completes when the "binlog" file does not exist.
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.
Symptoms
MySQL first backup never ends when "binlog" file/s does not exist in the MySQL database.
Cause
MySQL "binlog" file/s does not exist, therefore NetWorker client will not continue with the backup activity.
IMPORTANT: The evidence regarding this root cause is shown only when the NetWorker backup job is executed with "Debug Level" equal to "5".
From the NetWorker client, the NetWorker log file/s (default location: /nsr/logs directory) reports missing "binlog/s" of that 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.
IMPORTANT: The evidence regarding this root cause is shown only when the NetWorker backup job is executed with "Debug Level" equal to "5".
From the NetWorker client, the NetWorker log file/s (default location: /nsr/logs directory) reports missing "binlog/s" of that 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
To address this issue, purge all previous missed "binlog/s" until the first "binlog" available.
IMPORTANT: In the following procedure the first "binlog" available is named "mysql-bin.004585", but this is just an example from a lab environment to explain a possible solution.
Procedure
DISCLAIMER: Before following this procedure, Dell Technologies recommend involving a MySQL administrator to validate in advance before applying this method as the best possible solution according to your environment.
IMPORTANT: In the following procedure the first "binlog" available is named "mysql-bin.004585", but this is just an example from a lab environment to explain a possible solution.
Procedure
DISCLAIMER: Before following this procedure, Dell Technologies recommend involving a MySQL administrator to validate in advance before applying this method as the best possible solution according to your environment.
- Log in to your MySQL server as "root" user.
- Connect to your MySQL database console.
- Check the current availability of "binlog" by executing the following command:
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 |
| 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 |
- Purge all missed "binlog/s", previous to the first "binlog" available by executing the following command:
Note: In this case, "mysql-bin.004585" is the first "binlog" available.
mysql> purge binary logs to 'mysql-bin.004585';
Query OK, 0 rows affected, 4584 warnings (10.12 sec)
Query OK, 0 rows affected, 4584 warnings (10.12 sec)
- Re-run the backup job to validate that it completes without errors.
- Evidence of a successful backup job (as shown in the Networker logs from the client-side):
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
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.
Parameters Summary
-------------------------------------------------------------
Start LSN : 15597868102656
End LSN : 15597868102712
-------------------------------------------------------------
mysqlbackup completed OK! with 2 warnings.
Products
NetWorker Module for Databases and ApplicationsArticle Properties
Article Number: 000173788
Article Type: Solution
Last Modified: 06 Jul 2021
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.