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

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

    XMLWordPrintable

    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 (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: