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

Unable to install "MariaDB-connect-engine" when using "MariaDB-Galera-server"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.7
    • Fix Version/s: 10.0.13
    • Component/s: None
    • Labels:
      None
    • Environment:
      Main system:
      - CentOS 6.3 x64
      - MariaDB-Galera-server-10.0.7-1.x86_64
      - galera-25.3.2-1.rhel6.x86_64

      Description

      When I try to install the package MariaDB-connect-engine via yum, it determines its dependencies. These dependencies also contain the package MariaDB-server which conflicts with MariaDB-Galera-server:

      Transaction Check Error:
        file /etc/init.d/mysql conflicts between attempted installs of MariaDB-server-10.0.10-1.el6.x86_64 and MariaDB-Galera-server-10.0.7-1.x86_64
        file /usr/bin/aria_chk conflicts between attempted installs of MariaDB-server-10.0.10-1.el6.x86_64 and MariaDB-Galera-server-10.0.7-1.x86_64
        file /usr/bin/aria_dump_log conflicts between attempted installs of MariaDB-server-10.0.10-1.el6.x86_64 and MariaDB-Galera-server-10.0.7-1.x86_64
      ...
      (65 conflicts total, see attached file for details)
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            jplindst Jan Lindström added a comment -

            Let us research can we support CONNECT engine on Galera and if we can how to enable the installation.

            Show
            jplindst Jan Lindström added a comment - Let us research can we support CONNECT engine on Galera and if we can how to enable the installation.
            Hide
            serg Sergei Golubchik added a comment -

            I suppose, plugins should require not "MariaDB-server" directly, but something that both MariaDB-server and MariaDB-galera-server provide. For example, "MariaDB".

            Show
            serg Sergei Golubchik added a comment - I suppose, plugins should require not "MariaDB-server" directly, but something that both MariaDB-server and MariaDB-galera-server provide. For example, "MariaDB".
            Hide
            UweB Uwe Beierlein added a comment - - edited

            Hello,

            as a workaround I've tried to copy the connector from another installation to a Galery Node:

            1. Installed the connector on an (identical RHEL6/x64 system) with MariaDB-Server (without Galera) installed.
            Tested the existance of that connector via mysql "show plugins;"
            2. Installed dependent libraries (obtained via "yum deplist MariaDB-connect-engine"
            and "ldd -v /usr/lib64/mysql/plugin/ha_connect.so"):
            yum install glibc libstdc++ zlib libxml2 unixODBC
            3. Copied the libaries and config file (obtained via "repoquery -lq MariaDB-connect-engine"):
            cp ha_connect.so /usr/lib64/mysql/plugin/ha_connect.so
            chmod 0755 /usr/lib64/mysql/plugin/ha_connect.so
            chgrp root:root /usr/lib64/mysql/plugin/ha_connect.so
            4. Copied libmysqld (not avaiable on galera cluster nodes):
            cp libmysqld.so.18 /usr/lib64/libmysqld.so.18
            chmod 0755 /usr/lib64/libmysqld.so.18
            cd /usr/lib64
            ln -s libmysqld.so.18 libmysqld.so
            5. Restarted the Galera Cluster Node:
            service mysql restart

            But unfortuately, there is still an unresolved (late bound) dependency:
            140526 9:23:49 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/ha_connect.so' (errno: 0, undefined symbol: _ZN7handler13set_lock_typeE13thr_lock_type)
            140526 9:23:49 [ERROR] Couldn't load plugins from 'ha_connect.so'.

            As of now I did not find the library providing that method.
            Is there a way to workaround that issue and to get the connector working without the "MariaDB-server" package?

            Show
            UweB Uwe Beierlein added a comment - - edited Hello, as a workaround I've tried to copy the connector from another installation to a Galery Node: 1. Installed the connector on an (identical RHEL6/x64 system) with MariaDB-Server (without Galera) installed. Tested the existance of that connector via mysql "show plugins;" 2. Installed dependent libraries (obtained via "yum deplist MariaDB-connect-engine" and "ldd -v /usr/lib64/mysql/plugin/ha_connect.so"): yum install glibc libstdc++ zlib libxml2 unixODBC 3. Copied the libaries and config file (obtained via "repoquery -lq MariaDB-connect-engine"): cp ha_connect.so /usr/lib64/mysql/plugin/ha_connect.so chmod 0755 /usr/lib64/mysql/plugin/ha_connect.so chgrp root:root /usr/lib64/mysql/plugin/ha_connect.so 4. Copied libmysqld (not avaiable on galera cluster nodes): cp libmysqld.so.18 /usr/lib64/libmysqld.so.18 chmod 0755 /usr/lib64/libmysqld.so.18 cd /usr/lib64 ln -s libmysqld.so.18 libmysqld.so 5. Restarted the Galera Cluster Node: service mysql restart But unfortuately, there is still an unresolved (late bound) dependency: 140526 9:23:49 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/ha_connect.so' (errno: 0, undefined symbol: _ZN7handler13set_lock_typeE13thr_lock_type) 140526 9:23:49 [ERROR] Couldn't load plugins from 'ha_connect.so'. As of now I did not find the library providing that method. Is there a way to workaround that issue and to get the connector working without the "MariaDB-server" package?
            Show
            nirbhay_c Nirbhay Choubey added a comment - Patch committed : http://lists.askmonty.org/pipermail/commits/2014-August/006392.html
            Hide
            serg Sergei Golubchik added a comment -

            ok to push

            Show
            serg Sergei Golubchik added a comment - ok to push
            Show
            nirbhay_c Nirbhay Choubey added a comment - Fix pushed to 10.0 branch. http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4340

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey
                Reporter:
                lgsit Ralf Kilian
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: