"Starting of aux server failed": A block-level restore job or a clone restore job fails

Article ID: MSQL0015 A MySQL restore job of a block-level backup with the TokuDB storage engine fails with errors.

Symptom

A block-level restore job or a clone restore job fails with the following error message:

Error Code: [87:18]
Description: MySQL Database: [~Starting of aux server failed~] Restore Failed.
Source: 172_2, Process: MYSQLBLOCKRESTORE

You can see the following error logs in the MYSQLBLOCKRESTORE.log file:

14305 37e1 01/16 12:46:11 1214 MySqlBlockRetores::CreateNewMySqlServer() -  New server cmd [/native/tokudb/percona-5.5.30-tokudb-7.0.1-linux-x86_64/bin/mysqld_safe --datadir=/opt/commvault2/MediaAgent/SnapVolumeMounts/SnapMnt_1_2_1613_2_395/tokudb/percona-5.5.30-tokudb-7.0.1-linux-x86_64/data --socket=/mclone1/mysql.sock --port=38220 --pid-file=/mclone1/my2_1214.pid --log-error=/mclone1/mysql_1214.log --log-bin ]
14305 37e1 01/16 12:46:11 1214 MySqlChildProcess::Initialize() - Impersonating User [ root ]
14305 37e1 01/16 12:46:17 1214 GetMySqlInfoExt::ConnectToDB() - Cannot connect.GetConnection failed()
14305 37e1 01/16 12:46:17 1214 GetMySqlInfoExt::ConnectToDB() - MySqlInterface::LoadAndInitialize() failed:Can't connect to local MySQL server through socket '/mclone1/mysql.sock' (2) Failed to execute mysql_real_connect

 You can find the following logs in the Mysql_error_log file:

170116 12:46:11 [ERROR] Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/local/mysql/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory)
170116 12:46:11 [Warning] Couldn't load plugin named 'tokudb' with soname 'ha_tokudb.so'.

170116 12:46:13 [ERROR] Unknown/unsupported storage engine: TokuDB
170116 12:46:13 [ERROR] Aborting

Cause

MySQL server could not find the ha_tokudb.so plugin directory.

Resolution

  1. Create the additional setting sAdvancedStartServerOptions, and set its value as shown below:
--plugin-dir=<plugin_directory_path>

For example:

--plugin-dir=/native/tokudb/percona-5.5.30-tokudb-7.0.1-linux-x86_64/lib/mysql/plugin/
  1. Run the restore operation again.