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

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

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.7
    • 10.0.13
    • None
    • None
    • 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)

      Attachments

        Activity

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

          jplindst Jan Lindström (Inactive) added a comment - Let us research can we support CONNECT engine on Galera and if we can how to enable the installation.

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

          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".
          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?

          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?
          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Patch committed : http://lists.askmonty.org/pipermail/commits/2014-August/006392.html

          ok to push

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

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            lgsit Ralf Kilian
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.