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

          lgsit Ralf Kilian created issue -
          jplindst Jan Lindström (Inactive) made changes -
          Field Original Value New Value
          Assignee Nirbhay Choubey [ nirbhay_c ]

          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".
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.12 [ 15201 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.11 [ 15200 ]
          Fix Version/s 10.0.12 [ 15201 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.12 [ 15201 ]
          Fix Version/s 10.0.11 [ 15200 ]
          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?
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 38934 ] MariaDB v2 [ 43518 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.13 [ 16000 ]
          Fix Version/s 10.0.12 [ 15201 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Fix Version/s 10.0.13 [ 16300 ]
          Fix Version/s 10.0 [ 16000 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Patch committed : http://lists.askmonty.org/pipermail/commits/2014-August/006392.html
          serg Sergei Golubchik made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] In Review [ 10002 ]

          ok to push

          serg Sergei Golubchik added a comment - ok to push
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          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) made changes -
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43518 ] MariaDB v3 [ 64938 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64938 ] MariaDB v4 [ 147801 ]

          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.