The reason of the Restore Failed exit status is due to restore executing the following statement:
LOCK TABLES `transaction_registry` WRITE;
The statement was generated and included in the mysqldump backup.
Running the statement will fail with the following error message:
You can't use locks with log tables
This error, results in the job setting the flag to Restore Failed. However, other statements would be not affected. I.e., restores of other tables included in the restore are not affected. Restore of the table transaction_registry is not affected as well.
I.e., in this case Restore Failed status is not equivalent to a failed restore. It signifies that a particular statement failed to execute. And in this case the statement that is failing is an unnecessary statement that shall not be included in the mysqldump backup in the first place.
