Error: "Percona XtraBackup finished with errors" when running MySQL backup

Last Modified

Fri May 01 10:55 GMT 2020

Description

  • Error: "Percona XtraBackup finished with errors" when running MySQL backup
  • MySQL Backup fails with error: "Backup of server at 127.0.0.1:3306 failed: Percona XtraBackup finished with errors"
  • The following can be found in the debug logs:
    [W] [19884] [MySqlServerPerconaSerializer] 160208 19:54:48 InnoDB: Error: Write to file C:/Windows/Temp/MySQL_Temp_BKF_CDA4E58CBAE841FEA0865CA790474858/ibdata1 failed at offset 0 4035969024.
    [W] [19884] [MySqlServerPerconaSerializer] InnoDB: 1048576 bytes should have been written, only 0 were written.
  • More information about debug logs can be found here.

Environment

  • N-able Backup
  • MySQL

Solution

  • The errors mean that there is not enough free space to write the bkf file to the temp folder:
    • You can free up more space on the volume where the temp folder is located (usually C:\ volume).
    • You can move the temp folder to another location.