Bug #76784 Mysqlbackup checksum error during verifiacation

• Submitted: 22 Apr 2015 8:22
• Modified: 27 May 2016 13:01
• Reporter: Anton V
• Status: Verified
• Category: MySQL Enterprise Backup
• Severity: S1 (Critical)
• Version: 3.12
• OS: Linux
• CPU Architecture: Any

[22 Apr 2015 8:22] Anton V

Description:
We are using MEB 3.12 + Netbackup for preparation  backups ( made as images ) to remote storage 

by recommendation that were made here
https://www.mysql.com/why-mysql/white-papers/mysql-enterprise-backup-and-symantec-netbackup/ 

We got a critical problem with with MEB 
Full backup finishes successfully , but verification process is failed with error 
mysqlbackup: ERROR: Checksum mis-match found on the file datadir/fo/online_log.ibd.

The problem appears in the large tables that are updated very intensively .

[root@dc02-srv-swdb-01 swdb]# ll -h mysql/fo/online_log.*
-rw-rw---- 1 mysql mysql  15K Апр  6 01:42 mysql/fo/online_log.frm
-rw-rw---- 1 mysql mysql 104G Апр 17 15:44 mysql/fo/online_log.ibd
-rw-rw---- 1 mysql mysql  558 Апр  6 01:27 mysql/fo/online_log.TRG

And the most important  that impossible to restore database from this backup.
During restore process appears the same  error:
 mysqlbackup: ERROR: Checksum mis-match found on the file datadir/fo/online_log.ibd.
mysqlbackup failed with errors!

I've attached  log files (with trace=3) with examples of backup and restore processes .

How to repeat:

Create a large innodb table with , that is updated very often .
Create full backup of database as image .
Make verification of this backup .

For full imitation of the case need to use symantec netbackup

[22 Apr 2015 8:24] Anton V

Backup log file

Attachment: dc02_mysql_swdb.backup.log (application/octet-stream, text), 1.60 MiB.

[22 Apr 2015 8:26] Anton V

Restore log file

Attachment: dc02_mysql_swdb.restore.log (application/octet-stream, text), 5.83 KiB.

[27 May 2016 13:01] Chiranjeevi Battula

Hello Anton,

Thank you for the bug report.

Thanks,
Chiranjeevi.