Bug #76784 Mysqlbackup checksum error during verifiacation
Submitted: 22 Apr 2015 8:22 Modified: 27 May 2016 13:01
Reporter: Anton V Email Updates:
Status: Verified Impact on me:
Category:MySQL Enterprise Backup Severity:S1 (Critical)
Version:3.12 OS:Linux
Assigned to: CPU Architecture:Any

[22 Apr 2015 8:22] Anton V
We are using MEB 3.12 + Netbackup for preparation  backups ( made as images ) to remote storage 

by recommendation that were made here

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.