Error Code: [87:83] Log restore operation failed

Article ID: MSQL0006 A MySQL log file restore job fails with Error Code [87:83]

Symptom

A log file restore job fails with the following error message:

Error Code: [87:86]
Description: Failure:[~Error [/usr/bin/mysqlbinlog: unknown option '--no-beep' ] in applying the logs~]

You can also find following error in the MySqlRestore.log file:

44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::CV_CreateProcess() - Command to run [/usr/bin/mysqlbinlog --start-position=120   -d auxdb_1 /clone/3007/21666/testlog.000336 --result-file=/clone/3007/21666/ArchiveEvents.sql]
44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::CV_CreateProcess() - Parent: child process pid= 44241
44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::Wait() - Child died after receiving signal 2
44063 ac1f 02/09 13:09:07 3007 MySqlLogRestore::ApplyTheLogFile() - Wait returned failure
44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - Previous errno = [9].
44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - ReadFile: LastError=0
44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - Got Error /usr/bin/mysqlbinlog: unknown option '--no-beep'
44063 ac1f 02/09 13:09:08 3007 Sending FAILED complete message to JM, 3007

Cause

The no-beep option is present in the MySQL configuration file.

[client]
no-beep

Resolution

Use the following steps to resolve this issue:

  1. Open the MySQL configuration file, and then comment out the no-beep option.
[client]
#no-beep
  1.  Run the log file restore operation again.