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

Weird behaviour with failing plugin library.

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.5.41
    • Fix Version/s: 5.5
    • Component/s: Plugins
    • Labels:
      None

      Description

      install plugin server_audit soname "server_audit.so";
      ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/plugin/server_audit.so' (errno: 13 /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/local/mysql/lib/plugin/server_audit.so))
      So the plugin library cannot be loaded.
      Still we have something set in the plugins table:
      install plugin server_audit SONAME "server_audit.so";
      ERROR 1062 (23000): Duplicate entry 'server_audit' for key 'PRIMARY'
      

      though:

      uninstall plugin server_audit;
      ERROR 1305 (42000): PLUGIN server_audit does not exist
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            Doesn't fail like that for me:

            MariaDB [test]> install plugin server_audit soname 'server_audit.so';
            ERROR 1126 (HY000): Can't open shared library '/data/releases/mariadb-5.5.41-linux-x86_64/lib/plugin/server_audit.so' (errno: 2, /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.14' not found (required by /data/releases/mariadb-5.5.41-linux-x86_64/lib/plug)
            MariaDB [test]> select * from mysql.plugin;
            Empty set (0.00 sec)
            
            MariaDB [test]> exit
            Bye
            elenst@wheezy-64:/data/releases/mariadb-5.5.41-linux-x86_64$ cp server_audit.so lib/plugin/
            elenst@wheezy-64:/data/releases/mariadb-5.5.41-linux-x86_64$ ml test --port=3310
            Welcome to the MariaDB monitor.  Commands end with ; or \g.
            Your MariaDB connection id is 2
            Server version: 5.5.41-MariaDB MariaDB Server
            
            Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
            
            Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
            
            MariaDB [test]> install plugin server_audit soname 'server_audit.so';
            Query OK, 0 rows affected (0.00 sec)
            
            MariaDB [test]> select @@version;
            +----------------+
            | @@version      |
            +----------------+
            | 5.5.41-MariaDB |
            +----------------+
            1 row in set (0.00 sec)
            

            Do you actually have something in mysql.plugin? Did you have anything there before the failed attempt?

            Show
            elenst Elena Stepanova added a comment - Doesn't fail like that for me: MariaDB [test]> install plugin server_audit soname 'server_audit.so'; ERROR 1126 (HY000): Can't open shared library '/data/releases/mariadb-5.5.41-linux-x86_64/lib/plugin/server_audit.so' (errno: 2, /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.14' not found (required by /data/releases/mariadb-5.5.41-linux-x86_64/lib/plug) MariaDB [test]> select * from mysql.plugin; Empty set (0.00 sec) MariaDB [test]> exit Bye elenst@wheezy-64:/data/releases/mariadb-5.5.41-linux-x86_64$ cp server_audit.so lib/plugin/ elenst@wheezy-64:/data/releases/mariadb-5.5.41-linux-x86_64$ ml test --port=3310 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.41-MariaDB MariaDB Server Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [test]> install plugin server_audit soname 'server_audit.so'; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> select @@version; +----------------+ | @@version | +----------------+ | 5.5.41-MariaDB | +----------------+ 1 row in set (0.00 sec) Do you actually have something in mysql.plugin? Did you have anything there before the failed attempt?
            Hide
            serg Sergei Golubchik added a comment -

            What is this bug report about? The "version `GLIBC_2.14' not found" error? Or how INSTALL/UNINSTALL behave when plugin installation fails? Or both?

            Show
            serg Sergei Golubchik added a comment - What is this bug report about? The "version `GLIBC_2.14' not found" error? Or how INSTALL/UNINSTALL behave when plugin installation fails? Or both?
            Hide
            elenst Elena Stepanova added a comment -

            To my understanding it's about the inconsistent state that the plugin ends up after the failed installation attempt (something is written to mysql.plugin, although the plugin was not installed and hence cannot be uninstalled). But I couldn't reproduce it so far.

            Show
            elenst Elena Stepanova added a comment - To my understanding it's about the inconsistent state that the plugin ends up after the failed installation attempt (something is written to mysql.plugin, although the plugin was not installed and hence cannot be uninstalled). But I couldn't reproduce it so far.

              People

              • Assignee:
                holyfoot Alexey Botchkov
                Reporter:
                holyfoot Alexey Botchkov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: