[MDEV-4403] Attempting to use cassandra storage engine causes "service 'my_snprintf_service' interface version mismatch" - Jira

Details

Type: Bug
Status: Closed (View Workflow)
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)

Attachments

Activity

Ascending order - Click to sort in descending order

Sergei Petrunia created issue - 2013-04-17 15:06

Sergei Petrunia made changes - 2013-04-17 15:07

Field	Original Value	New Value
Description	I am unable to make use of Cassandra engine in: {noformat} 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) {noformat} {noformat} MariaDB [test]> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; Query OK, 0 rows affected (0.00 sec) {noformat}	I am using binary tarball of 10.0.1. I am unable to load the Cassandra storage engine plugin: {noformat} 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) {noformat} I've tried other plugin and it seemed to work: {noformat} MariaDB [test]> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; Query OK, 0 rows affected (0.00 sec) {noformat}

Sergei Petrunia made changes - 2013-04-17 15:53

Environment

mariadb-10.0.1-linux-x86_64.tar.gz (requires GLIBC_2.14+) md5sum: ded866cc9b950dca9a5d472a3a6b320a

mariadb-10.0.1-linux-x86_64.tar.gz (requires GLIBC_2.14+) md5sum: ded866cc9b950dca9a5d472a3a6b320a,
trying to run on Fedora release 16 (Verne)

Elena Stepanova added a comment - 2013-04-18 20:57

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

Savepoints

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

CASSANDRA

YES

Cassandra storage engine

-------------------------------------------------------------------------------------------------------------------+
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)

Elena Stepanova added a comment - 2013-04-18 20:57 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)

Elena Stepanova added a comment - 2013-04-22 01:41

Assigning to myself to check on earlier versions of Fedora.

Elena Stepanova added a comment - 2013-04-22 01:41 Assigning to myself to check on earlier versions of Fedora.

Elena Stepanova made changes - 2013-04-22 01:41

Assignee

Elena Stepanova [ elenst ]

Elena Stepanova added a comment - 2013-04-24 17:49

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

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

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

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?

Elena Stepanova added a comment - 2013-04-24 17:49 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?

Elena Stepanova made changes - 2013-04-24 17:50

Assignee

Elena Stepanova [ elenst ]

Sergei Petrunia [ psergey ]

Sergei Petrunia added a comment - 2013-05-02 05:54

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)

Sergei Petrunia added a comment - 2013-05-02 05:54 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)

Sergei Petrunia added a comment - 2013-05-02 05:56

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

Sergei Petrunia added a comment - 2013-05-02 05:56 I think, when INSTALL PLUGIN works for the first time but not for the second - it looks like a bug in plugin system.

Sergei Golubchik made changes - 2013-12-04 22:46

Assignee

Sergei Petrunia [ psergey ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2013-12-04 22:46

Fix Version/s

10.0.7 [ 14100 ]

Sergei Golubchik made changes - 2013-12-05 14:23

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2013-12-09 14:15

Assignee

Sergei Golubchik [ serg ]

Sergey Vojtovich [ svoj ]

Sergey Vojtovich made changes - 2013-12-10 11:37

Assignee

Sergey Vojtovich [ svoj ]

Sergei Golubchik [ serg ]

Sergey Vojtovich added a comment - 2013-12-10 11:37

Ok to push.

Sergey Vojtovich added a comment - 2013-12-10 11:37 Ok to push.

Sergei Golubchik made changes - 2013-12-12 22:20

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 27009 ]

MariaDB v2 [ 43883 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43883 ]

MariaDB v3 [ 63106 ]

Sergei Golubchik made changes - 2021-12-06 21:38

Workflow

MariaDB v3 [ 63106 ]

MariaDB v4 [ 146610 ]

People

Assignee:: Sergei Golubchik

Reporter:: Sergei Petrunia

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2013-04-17 15:06

Updated:: 2013-12-12 22:20

Resolved:: 2013-12-12 22:20

Git Integration

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