Error Code: [87:86] A MySQL Backup Operation Fails with an Error Message

Article ID: 62643

Article Type: Troubleshooting

Last Modified:

A backup operation for MySQL fails with Error Code: [87:86]

Symptoms

A backup operation for MySQL databases fails with the following error on the client computer.

ERROR CODE [87:86]: Failure:[~Current Version of MySQL has product bug [http://bugs.mysql.com/bug.php?id=72598]. Please upgrade MySQL to continue with backups.~]

Causes

The backup operation fails because of a MySQL bug or a MariaDB bug. If it is a MySQL bug [http://bugs.mysql.com/bug.php?id=72598], then execution of the FLUSH LOGS command fails when both --syslog for mysqld_safe and --log-error for mysqld are enabled in the MySQL config file. If it is a MariaDB bug [https://jira.mariadb.org/browse/MDEV-10241], then execution of the FLUSH LOGS command fails when the absolute path is used for the log-error parameter in the MariaDB config file.

Resolution

If it is a MySQL bug, then you need to remove one of the parameters from the corresponding MySQL config file, either --syslog from the mysqld_safe section or log-error from the mysqld section. If it is a MariaDB bug, then you need to update the value of the log-error parameter to the relative path in the MariaDB config file, and then restart the MariaDB services.

1 Commvault Way, Tinton Falls, NJ 07724 Sitemap | Legal Notices | Trademarks | Privacy Policy
Copyright © Commvault | All Rights Reserved.