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

          Ascending order - Click to sort in descending order
          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.

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

          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

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Patch committed : http://lists.askmonty.org/pipermail/commits/2014-August/006392.html
          serg Sergei Golubchik added a comment -

          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

          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.