Article ID: 54274
Article Type: Troubleshooting
Last Modified:
A MySQL restore job of a block-level table level backup with the TokuDB storage engine fails with errors.
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
MySQL server could not find the ha_tokudb.so plugin directory.
--plugin-dir=
For example:
--plugin-dir=/native/tokudb/percona-5.5.30-tokudb-7.0.1-linux-x86_64/lib/mysql/plugin/