Article ID: 114157, created on Jun 20, 2012, last review on May 11, 2014

  • Applies to:
  • Odin Business Automation Standard

Symptoms

PBAS backup with the hspc-mn-backup utility fails with the following error:

/bin/tar: /var/lib/mysql/ibdata1: file changed as we read it
/bin/tar: /var/lib/mysql/ibdata3: file changed as we read it
/bin/tar: /var/lib/mysql/ibdata2: file changed as we read it

Cause

This error appears if the hspc-mn-backup utility is executed with the '--no-pre' or '-p' options. With this option backup utility does not perform pre-backup actions. Pre-backup actions include temporary shutting down of some services, including MySQL. If you omit pre-backup actions, the MySQL service is not being stopped prior to the hspc-mn-backup utility execution and MySQL database files /var/lib/mysql/ibdata* are being changed during the backup or migration procedure causing the latter to fail.

Resolution

Run the hspc-mn-backup utility without the '--no-pre' or '-p' options. In this case the utility will stop the MySQL service automatically.

Please note that it is recommended to schedule a maintenance window for that for PBAS will not be operable during the procedure which can take hours to complete.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF