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

Attempting to use cassandra storage engine causes "service 'my_snprintf_service' interface version mismatch"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.1
    • Fix Version/s: 10.0.7
    • Component/s: None
    • Labels:
      None
    • Environment:
      mariadb-10.0.1-linux-x86_64.tar.gz (requires GLIBC_2.14+) md5sum: ded866cc9b950dca9a5d472a3a6b320a,
      trying to run on Fedora release 16 (Verne)

      Description

      I am using binary tarball of 10.0.1. I am unable to load the Cassandra storage engine plugin:

      MariaDB [test]> INSTALL PLUGIN cassandra SONAME 'ha_cassandra.so' ;
      ERROR 1126 (HY000): Can't open shared library '/data0/psergey/nodev/mariadb-10.0.1-linux-x86_64/lib/plugin/ha_cassandra.so' (errno: 0 service 'my_snprintf_service' interface version mismatch)
      

      I've tried other plugin and it seemed to work:

      MariaDB [test]> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';
      Query OK, 0 rows affected (0.00 sec)
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            Works on Fedora 17 (earlier I tried Fedora 18, it worked too), I'll check Fedora 16 next if I find an image.

            MariaDB [test]> install plugin cassandra soname 'ha_cassandra.so';
            Query OK, 0 rows affected (0.00 sec)

            MariaDB [test]> show plugins;
            ----------------------------------------------------------------------------

            Name Status Type Library License

            ----------------------------------------------------------------------------
            ...

            CASSANDRA ACTIVE STORAGE ENGINE ha_cassandra.so GPL

            ----------------------------------------------------------------------------
            41 rows in set (0.00 sec)

            MariaDB [test]> show engines;
            -------------------------------------------------------------------------------------------------------------------+

            Engine Support Comment Transactions XA Savepoints

            -------------------------------------------------------------------------------------------------------------------+
            ...

            CASSANDRA YES Cassandra storage engine NO NO NO

            -------------------------------------------------------------------------------------------------------------------+
            11 rows in set (0.00 sec)

            MariaDB [test]> show variables like 'version%';
            ---------------------------------------+

            Variable_name Value

            ---------------------------------------+

            version 10.0.1-MariaDB
            version_comment MariaDB Server
            version_compile_machine x86_64
            version_compile_os Linux

            ---------------------------------------+
            4 rows in set (0.00 sec)

            Tarball in use:
            rw-rw-r-. 1 elenst elenst 298066045 Apr 18 21:48 mariadb-10.0.1-linux-x86_64.tar.gz

            [elenst@fedora17-64 mariadb-10.0.1-linux-x86_64]$ ldd bin/mysqld
            linux-vdso.so.1 => (0x00007fff6f478000)
            libaio.so.1 => /lib64/libaio.so.1 (0x0000003c72200000)
            librt.so.1 => /lib64/librt.so.1 (0x0000003c73200000)
            libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003c72a00000)
            libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003c7e600000)
            libdl.so.2 => /lib64/libdl.so.2 (0x0000003c72e00000)
            libstdc+.so.6 => /lib64/libstdc+.so.6 (0x0000003c7d600000)
            libm.so.6 => /lib64/libm.so.6 (0x0000003c73a00000)
            libc.so.6 => /lib64/libc.so.6 (0x0000003c72600000)
            /lib64/ld-linux-x86-64.so.2 (0x0000003c71e00000)
            libfreebl3.so => /lib64/libfreebl3.so (0x0000003c7fe00000)
            libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003c76600000)

            [elenst@fedora17-64 mariadb-10.0.1-linux-x86_64]$ ldd lib/plugin/ha_cassandra.so
            linux-vdso.so.1 => (0x00007fffec251000)
            libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f447cfcc000)
            libstdc+.so.6 => /lib64/libstdc+.so.6 (0x00007f447ccc9000)
            libc.so.6 => /lib64/libc.so.6 (0x00007f447c911000)
            /lib64/ld-linux-x86-64.so.2 (0x0000003c71e00000)
            libm.so.6 => /lib64/libm.so.6 (0x00007f447c616000)
            libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f447c401000)

            Show
            elenst Elena Stepanova added a comment - Works on Fedora 17 (earlier I tried Fedora 18, it worked too), I'll check Fedora 16 next if I find an image. MariaDB [test] > install plugin cassandra soname 'ha_cassandra.so'; Query OK, 0 rows affected (0.00 sec) MariaDB [test] > show plugins; --------------------------- -------- ------------------ --------------- -------- Name Status Type Library License --------------------------- -------- ------------------ --------------- -------- ... CASSANDRA ACTIVE STORAGE ENGINE ha_cassandra.so GPL --------------------------- -------- ------------------ --------------- -------- 41 rows in set (0.00 sec) MariaDB [test] > show engines; ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ Engine Support Comment Transactions XA Savepoints ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ ... CASSANDRA YES Cassandra storage engine NO NO NO ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ 11 rows in set (0.00 sec) MariaDB [test] > show variables like 'version%'; ------------------------ ---------------+ Variable_name Value ------------------------ ---------------+ version 10.0.1-MariaDB version_comment MariaDB Server version_compile_machine x86_64 version_compile_os Linux ------------------------ ---------------+ 4 rows in set (0.00 sec) Tarball in use: rw-rw-r -. 1 elenst elenst 298066045 Apr 18 21:48 mariadb-10.0.1-linux-x86_64.tar.gz [elenst@fedora17-64 mariadb-10.0.1-linux-x86_64] $ ldd bin/mysqld linux-vdso.so.1 => (0x00007fff6f478000) libaio.so.1 => /lib64/libaio.so.1 (0x0000003c72200000) librt.so.1 => /lib64/librt.so.1 (0x0000003c73200000) libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003c72a00000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003c7e600000) libdl.so.2 => /lib64/libdl.so.2 (0x0000003c72e00000) libstdc+ .so.6 => /lib64/libstdc +.so.6 (0x0000003c7d600000) libm.so.6 => /lib64/libm.so.6 (0x0000003c73a00000) libc.so.6 => /lib64/libc.so.6 (0x0000003c72600000) /lib64/ld-linux-x86-64.so.2 (0x0000003c71e00000) libfreebl3.so => /lib64/libfreebl3.so (0x0000003c7fe00000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003c76600000) [elenst@fedora17-64 mariadb-10.0.1-linux-x86_64] $ ldd lib/plugin/ha_cassandra.so linux-vdso.so.1 => (0x00007fffec251000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f447cfcc000) libstdc+ .so.6 => /lib64/libstdc +.so.6 (0x00007f447ccc9000) libc.so.6 => /lib64/libc.so.6 (0x00007f447c911000) /lib64/ld-linux-x86-64.so.2 (0x0000003c71e00000) libm.so.6 => /lib64/libm.so.6 (0x00007f447c616000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f447c401000)
            Hide
            elenst Elena Stepanova added a comment -

            Assigning to myself to check on earlier versions of Fedora.

            Show
            elenst Elena Stepanova added a comment - Assigning to myself to check on earlier versions of Fedora.
            Hide
            elenst Elena Stepanova added a comment -

            I'm getting the same error when I'm trying to install Cassandra for the second time, e.g. install - uninstall - install. It doesn't happen with e.g. sphinx:

            MariaDB [test]> show engines;
            -------------------------------------------------------------------------------------------------------------------+

            Engine Support Comment Transactions XA Savepoints

            -------------------------------------------------------------------------------------------------------------------+

            InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES
            CSV YES CSV storage engine NO NO NO
            MyISAM YES MyISAM storage engine NO NO NO
            BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO
            FEDERATED YES FederatedX pluggable storage engine YES NO YES
            MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
            ARCHIVE YES Archive storage engine NO NO NO
            MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
            PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
            Aria YES Crash-safe tables with MyISAM heritage NO NO NO

            -------------------------------------------------------------------------------------------------------------------+
            10 rows in set (0.00 sec)

            MariaDB [test]> install soname 'ha_cassandra.so';
            Query OK, 0 rows affected (0.01 sec)

            MariaDB [test]> show engines;
            -------------------------------------------------------------------------------------------------------------------+

            Engine Support Comment Transactions XA Savepoints

            -------------------------------------------------------------------------------------------------------------------+

            InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES
            CSV YES CSV storage engine NO NO NO
            MyISAM YES MyISAM storage engine NO NO NO
            BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO
            FEDERATED YES FederatedX pluggable storage engine YES NO YES
            MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
            ARCHIVE YES Archive storage engine NO NO NO
            MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
            PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
            Aria YES Crash-safe tables with MyISAM heritage NO NO NO
            CASSANDRA YES Cassandra storage engine NO NO NO

            -------------------------------------------------------------------------------------------------------------------+
            11 rows in set (0.00 sec)

            MariaDB [test]> uninstall plugin cassandra;
            Query OK, 0 rows affected (0.01 sec)

            MariaDB [test]> install soname 'ha_cassandra.so';
            ERROR 1126 (HY000): Can't open shared library '/home/elenst/mariadb-10.0.2-linux-x86_64/lib/plugin/ha_cassandra.so' (errno: 0 service 'my_snprintf_service' interface version mismatch)
            MariaDB [test]> install soname 'ha_sphinx.so';
            Query OK, 0 rows affected (0.01 sec)

            MariaDB [test]> uninstall plugin sphinx;
            Query OK, 0 rows affected (0.00 sec)

            MariaDB [test]> install soname 'ha_sphinx.so';
            Query OK, 0 rows affected (0.00 sec)

            MariaDB [test]> show engines;
            -------------------------------------------------------------------------------------------------------------------+

            Engine Support Comment Transactions XA Savepoints

            -------------------------------------------------------------------------------------------------------------------+

            InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES
            CSV YES CSV storage engine NO NO NO
            MyISAM YES MyISAM storage engine NO NO NO
            BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO
            FEDERATED YES FederatedX pluggable storage engine YES NO YES
            SPHINX YES Sphinx storage engine NO NO NO
            MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
            ARCHIVE YES Archive storage engine NO NO NO
            MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
            PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
            Aria YES Crash-safe tables with MyISAM heritage NO NO NO

            -------------------------------------------------------------------------------------------------------------------+
            11 rows in set (0.00 sec)

            Could it be that you encountered the error in similar circumstances?

            Show
            elenst Elena Stepanova added a comment - I'm getting the same error when I'm trying to install Cassandra for the second time , e.g. install - uninstall - install. It doesn't happen with e.g. sphinx: MariaDB [test] > show engines; ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ Engine Support Comment Transactions XA Savepoints ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES CSV YES CSV storage engine NO NO NO MyISAM YES MyISAM storage engine NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO FEDERATED YES FederatedX pluggable storage engine YES NO YES MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO ARCHIVE YES Archive storage engine NO NO NO MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO PERFORMANCE_SCHEMA YES Performance Schema NO NO NO Aria YES Crash-safe tables with MyISAM heritage NO NO NO ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ 10 rows in set (0.00 sec) MariaDB [test] > install soname 'ha_cassandra.so'; Query OK, 0 rows affected (0.01 sec) MariaDB [test] > show engines; ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ Engine Support Comment Transactions XA Savepoints ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES CSV YES CSV storage engine NO NO NO MyISAM YES MyISAM storage engine NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO FEDERATED YES FederatedX pluggable storage engine YES NO YES MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO ARCHIVE YES Archive storage engine NO NO NO MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO PERFORMANCE_SCHEMA YES Performance Schema NO NO NO Aria YES Crash-safe tables with MyISAM heritage NO NO NO CASSANDRA YES Cassandra storage engine NO NO NO ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ 11 rows in set (0.00 sec) MariaDB [test] > uninstall plugin cassandra; Query OK, 0 rows affected (0.01 sec) MariaDB [test] > install soname 'ha_cassandra.so'; ERROR 1126 (HY000): Can't open shared library '/home/elenst/mariadb-10.0.2-linux-x86_64/lib/plugin/ha_cassandra.so' (errno: 0 service 'my_snprintf_service' interface version mismatch) MariaDB [test] > install soname 'ha_sphinx.so'; Query OK, 0 rows affected (0.01 sec) MariaDB [test] > uninstall plugin sphinx; Query OK, 0 rows affected (0.00 sec) MariaDB [test] > install soname 'ha_sphinx.so'; Query OK, 0 rows affected (0.00 sec) MariaDB [test] > show engines; ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ Engine Support Comment Transactions XA Savepoints ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES CSV YES CSV storage engine NO NO NO MyISAM YES MyISAM storage engine NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO FEDERATED YES FederatedX pluggable storage engine YES NO YES SPHINX YES Sphinx storage engine NO NO NO MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO ARCHIVE YES Archive storage engine NO NO NO MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO PERFORMANCE_SCHEMA YES Performance Schema NO NO NO Aria YES Crash-safe tables with MyISAM heritage NO NO NO ------------------- ------- -------------------------------------------------------------- ------------ ---- -----------+ 11 rows in set (0.00 sec) Could it be that you encountered the error in similar circumstances?
            Hide
            psergey Sergei Petrunia added a comment -

            It's difficult for me to recollect the exact circumstances I got the error the first time.

            I've now tried with 10.0.2, on the same Fedora 16 machine. I now used binary tarball mariadb-10.0.2-linux-x86_64.tar.gz, 87d368cd292a90882cdfadc1a31110e6.

            I observe the same problem as you - first plugin installation succeeds, but if I uninstall/and then install back, I get an error:

            MariaDB [test]> install plugin cassandra soname 'ha_cassandra.so';
            Query OK, 0 rows affected (0.01 sec)

            MariaDB [test]> show plugins;
            ----------------------------------------------------------------------------

            Name Status Type Library License

            ----------------------------------------------------------------------------

            binlog ACTIVE STORAGE ENGINE NULL GPL

            ...

            CASSANDRA ACTIVE STORAGE ENGINE ha_cassandra.so GPL

            ----------------------------------------------------------------------------
            41 rows in set (0.00 sec)

            MariaDB [test]> uninstall plugin cassandra;
            Query OK, 0 rows affected (0.00 sec)

            MariaDB [test]> install plugin cassandra soname 'ha_cassandra.so';
            ERROR 1126 (HY000): Can't open shared library '/data0/psergey/nodev/mariadb-10.0.2-linux-x86_64/lib/plugin/ha_cassandra.so' (errno: 0 service 'my_snprintf_service' interface version mismatch)

            Show
            psergey Sergei Petrunia added a comment - It's difficult for me to recollect the exact circumstances I got the error the first time. I've now tried with 10.0.2, on the same Fedora 16 machine. I now used binary tarball mariadb-10.0.2-linux-x86_64.tar.gz, 87d368cd292a90882cdfadc1a31110e6. I observe the same problem as you - first plugin installation succeeds, but if I uninstall/and then install back, I get an error: MariaDB [test] > install plugin cassandra soname 'ha_cassandra.so'; Query OK, 0 rows affected (0.01 sec) MariaDB [test] > show plugins; --------------------------- -------- ------------------ --------------- -------- Name Status Type Library License --------------------------- -------- ------------------ --------------- -------- binlog ACTIVE STORAGE ENGINE NULL GPL ... CASSANDRA ACTIVE STORAGE ENGINE ha_cassandra.so GPL --------------------------- -------- ------------------ --------------- -------- 41 rows in set (0.00 sec) MariaDB [test] > uninstall plugin cassandra; Query OK, 0 rows affected (0.00 sec) MariaDB [test] > install plugin cassandra soname 'ha_cassandra.so'; ERROR 1126 (HY000): Can't open shared library '/data0/psergey/nodev/mariadb-10.0.2-linux-x86_64/lib/plugin/ha_cassandra.so' (errno: 0 service 'my_snprintf_service' interface version mismatch)
            Hide
            psergey Sergei Petrunia added a comment -

            I think, when INSTALL PLUGIN works for the first time but not for the second - it looks like a bug in plugin system.

            Show
            psergey Sergei Petrunia added a comment - I think, when INSTALL PLUGIN works for the first time but not for the second - it looks like a bug in plugin system.
            Hide
            svoj Sergey Vojtovich added a comment -

            Ok to push.

            Show
            svoj Sergey Vojtovich added a comment - Ok to push.

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours
                  5h