[MDEV-4403] Attempting to use cassandra storage engine causes "service 'my_snprintf_service' interface version mismatch" Created: 2013-04-17  Updated: 2013-12-12  Resolved: 2013-12-12

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1
Fix Version/s: 10.0.7

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
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)



 Comments   
Comment by Elena Stepanova [ 2013-04-18 ]

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)

Comment by Elena Stepanova [ 2013-04-22 ]

Assigning to myself to check on earlier versions of Fedora.

Comment by Elena Stepanova [ 2013-04-24 ]

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?

Comment by Sergei Petrunia [ 2013-05-02 ]

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)

Comment by Sergei Petrunia [ 2013-05-02 ]

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

Comment by Sergey Vojtovich [ 2013-12-10 ]

Ok to push.

Generated at Thu Feb 08 06:56:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.