MariaDB – ERROR 1033 (HY000): Incorrect information in file:

MariaDB/TokuDB – ERROR 1033 (HY000): Incorrect information in file:

While I was testing the TokuDB HotBackup plugin from Percona, I faced some error during a complete database recovery. After the recovery was completed, I tried verifying the table contents.

MariaDB [partitiontest]> select count(*) from salaries;
ERROR 1033 (HY000): Incorrect information in file: './partitiontest/salaries.frm'

Looking at the error message, I was under the impression that the tables were corrupted.

From the logs:

160127 11:10:56 [ERROR] mysql.plugin: 1 client is using or hasn't closed the table properly
160127 11:10:56 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/tokudb_backup.so' (errno: 0, cannot open shared object file: No such file or dir
ectory)
160127 11:10:56 server_audit: MariaDB Audit Plugin version 1.3.0 STARTED.
160127 11:10:56 [Note] Server socket created on IP: '::'.
160127 11:10:56 [Warning] 'user' entry 'root@centos7.local' ignored in --skip-name-resolve mode.
160127 11:10:56 [Warning] 'user' entry '@centos7.local' ignored in --skip-name-resolve mode.
160127 11:10:56 [Warning] 'proxies_priv' entry '@% root@centos7.local' ignored in --skip-name-resolve mode.
160127 11:10:56 [Note] Reading of all Master_info entries succeded
160127 11:10:56 [Note] Added new Master_info '' to hash table
160127 11:10:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.22-MariaDB-enterprise-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Certified Binary
160127 11:11:28 [ERROR] mysqld: Incorrect information in file: './partitiontest/salaries.frm'

The error message above looks really scary. While snooping around Google, I realized that the error is very vague, I decided to look deeper. On examining the logs again, I realized that the following error:

160127 11:10:56 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/tokudb_backup.so' (errno: 0, cannot open shared object file: No such file or dir
ectory)

Once I enabled the TokuDB plugin in /etc/my.cnf.d/tokudb.conf, the recovery works fine. I learnt to be more careful when dealing with such MariaDB errors.

Regards,
Wei Shan

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: