A MySQL Log Restore Operation Fails

Article ID: MSQL0021 A MySQL log restore operation fails with an error message in the MySqlRestore.log file.

Symptom

A MySQL log restore operation fails with the following error message in the MySqlRestore.log file:

7305 1c89 06/01 21:06:05 42348 MySqlChildProcess::Wait() - Child died after receiving signal 1
7305 1c89 06/01 21:06:05 42348 MySqlLogRestore::ApplyTheLogFile() - Wait returned failure
7305 1c89 06/01 21:06:05 42348 MySqlChildProcess::ReadErrBuf() - Previous errno = [9].
7305 1c89 06/01 21:06:05 42348 MySqlChildProcess::ReadErrBuf() - ReadFile: LastError=0
7305 1c89 06/01 21:06:05 42348 MySqlChildProcess::ReadErrBuf() - Got Error ERROR at line 12048323 in file: '/var/db/mysql/42348/74791/ArchiveEvents.sql': ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected.

Cause

The data that you are restoring includes binary data.

Resolution

To the client computer, add the nBinaryMode additional setting as shown in the following table, and then resubmit both the data and log restore operations.

For instructions about adding additional settings from the CommCell Console, see the Adding or Modifying and Additional Setting topic in the Commvault documentation.

Additional setting Value
Name nBinaryMode
Category MySQL
Type Integer
Value 1