[OpenSIPS-Users] Virtual_DB issue with NDBClUSTER

[osiris123d]

I am trying to get OpenSIPS Virtual_DB module to work with a MySQL Cluster
that I have set up.

Instead of the database tables being the usual MyISAM I set them up to be
NDBCLUSTER.

Within the OpenSIPS config I have

# ----- db_virtual params -----
modparam("db_virtual", "db_urls", "define set1 ROUND") 
modparam("db_virtual", "db_urls",
"mysql://********:******@173.***.***.219/opensips")
modparam("db_virtual", "db_urls",
"mysql://********:******@173.***.***.218/opensips")


To test I shut down the database on the 173.***.***.218 server and OpenSIPS
went down.  When I try to restart OpenSIPS I see the following in the syslog

Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to MySQL
server on '173.***.***.218' (111)
Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed
Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:core:db_do_init: could not add connection to the pool
Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:db_virtual:db_virtual_init: cant init db
mysql://****:*****@173.***.***.218/opensips
Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:db_mysql:db_mysql_submit_query: driver error: Got error 157 'Unknown
error code' from NDBCLUSTER
Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:
ERROR:core:db_do_query: error while submitting query
Dec 14 11:17:20 Proxy01 kernel: [235305.342266] opensips[3843]: segfault at
20 ip 00000000004f4e03 sp 00007fffb3965840 error 4 in
opensips[400000+14d000]



Looks like it dumped the core and the core says

(gdb) backtrace
#0  0x00000000004f4e03 in db_table_version (dbf=0x7ffff8d6e470,
connection=0x8175e0, table=0x7f3e124e9b40) at db/db.c:359
#1  0x00000000004f51d1 in db_check_table_version (dbf=0x0, dbh=0x0,
table=0x7f3e124e9b40, version=7) at db/db.c:398
#2  0x00007f3e122e585e in mod_init () at uri_mod.c:265
#3  0x0000000000493514 in init_mod (m=0x798348) at sr_module.c:457
#4  0x00000000004934ac in init_mod (m=0x798418) at sr_module.c:452
#5  0x00000000004934ac in init_mod (m=0x7984e8) at sr_module.c:452
#6  0x00000000004934ac in init_mod (m=0x7985b8) at sr_module.c:452
#7  0x00000000004934ac in init_mod (m=0x798688) at sr_module.c:452
#8  0x00000000004934ac in init_mod (m=0x798758) at sr_module.c:452
#9  0x00000000004934ac in init_mod (m=0x798828) at sr_module.c:452
#10 0x00000000004934ac in init_mod (m=0x7988f8) at sr_module.c:452
#11 0x00000000004934ac in init_mod (m=0x7989c8) at sr_module.c:452
#12 0x00000000004934ac in init_mod (m=0x798a98) at sr_module.c:452
#13 0x00000000004934ac in init_mod (m=0x798b68) at sr_module.c:452
#14 0x00000000004934ac in init_mod (m=0x798c38) at sr_module.c:452
#15 0x00000000004934ac in init_mod (m=0x798d08) at sr_module.c:452
#16 0x00000000004934ac in init_mod (m=0x798dd8) at sr_module.c:452
#17 0x00000000004934ac in init_mod (m=0x798ea8) at sr_module.c:452
#18 0x00000000004934ac in init_mod (m=0x798f78) at sr_module.c:452
#19 0x00000000004934ac in init_mod (m=0x799048) at sr_module.c:452
#20 0x00000000004934ac in init_mod (m=0x799118) at sr_module.c:452
#21 0x00000000004934ac in init_mod (m=0x7991e8) at sr_module.c:452
#22 0x00000000004934ac in init_mod (m=0x799528) at sr_module.c:452
#23 0x00000000004934ac in init_mod (m=0x7996c8) at sr_module.c:452
#24 0x00000000004934ac in init_mod (m=0x799798) at sr_module.c:452
#25 0x00000000004934ac in init_mod (m=0x799868) at sr_module.c:452
#26 0x00000000004934ac in init_mod (m=0x799a70) at sr_module.c:452
#27 0x00000000004934ac in init_mod (m=0x799b40) at sr_module.c:452
#28 0x00000000004934ac in init_mod (m=0x799c10) at sr_module.c:452
#29 0x00000000004934ac in init_mod (m=0x799ce0) at sr_module.c:452
#30 0x00000000004934ac in init_mod (m=0x799db0) at sr_module.c:452
#31 0x00000000004934ac in init_mod (m=0x799e80) at sr_module.c:452
#32 0x00000000004934ac in init_mod (m=0x799f50) at sr_module.c:452
#33 0x00000000004934ac in init_mod (m=0x79a020) at sr_module.c:452
#34 0x000000000042c4f0 in main (argc=<value optimized out>, argv=<value
optimized out>) at main.c:1351


Can you not use NDBCluster with OpenSIPS???
-- 
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Virtual-DB-issue-with-NDBClUSTER-tp5834548p5834548.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.