Uploaded image for project: 'MariaDB Server'
  1. MDEV-7652

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

    Details

    • Sprint:
      10.0.20, 10.0.21, 5.5.45

      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:

      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:

       
      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/

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                ivan.stoykov@skysql.com Stoykov
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: