We're updating the issue view to help you get more done. 

More explanatory ERROR and WARNING messages when loading plugins with plugin-load-add that are already registered at mysql.plugin

Description

In case a plugin is loaded with INSTALL SONAME , and the same plug is configured to be loaded at the configuration with plugin-load-add, there are not clear ERROR and WARNING mesages at the error log file.

example:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 150302 14:00:14 [ERROR] Function 'TokuDB' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_trx' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_trx' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_lock_waits' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_lock_waits' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_locks' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_locks' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_file_map' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_file_map' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_fractal_tree_info' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_fractal_tree_info' with soname 'ha_tokudb.so'. 150302 14:00:14 [ERROR] Function 'TokuDB_fractal_tree_block_map' already exists 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB_fractal_tree_block_map' with soname 'ha_tokudb.so'.

The messages should give the the reason for the errors
Also, the Warnings are misleading, as in fact the TokuDB plugin is loaded properly
example:

1 2 3 4 5 6 7 8 9 10 11 12 13 150302 14:00:14 [Warning] Couldn't load plugin named 'TokuDB' with soname 'ha_tokudb.so'. mysql root@centos-6-5-tckt-8873:[Mon Mar 2 14:17:42 2015][(none)]> pager grep -i tokudb PAGER set to 'grep -i tokudb' mysql root@centos-6-5-tckt-8873:[Mon Mar 2 14:17:47 2015][(none)]> show plugins ; | TokuDB | ACTIVE | STORAGE ENGINE | ha_tokudb.so | GPL | | TokuDB_trx | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | | TokuDB_lock_waits | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | | TokuDB_locks | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | | TokuDB_file_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | | TokuDB_fractal_tree_info | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | | TokuDB_fractal_tree_block_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL | 54 rows in set (0.00 sec)

There should be a documentation change with explanation what will happen in this case at some MariaDB KnowledgeBase pages , so far I can list these ones:

https://mariadb.com/kb/en/mariadb/install-plugin/
https://mariadb.com/kb/en/mariadb/plugin-overview/
https://mariadb.com/kb/en/mariadb/enabling-tokudb/

Environment

All

Status

Assignee

Sergey Vojtovich

Reporter

Stoykov

External issue ID

None

External issue ID

None

Components

Sprint

None

Fix versions

Affects versions

10.0

Priority

Major