[OpenSIPS-Users] Virtual_DB issue with NDBClUSTER

[Duane Larson]

I am afraid I don't.  Looks like I must have deleted it.

On Wed, Dec 22, 2010 at 4:02 AM, Bogdan-Andrei Iancu <bogdan at voice-system.ro
> wrote:

> Hi Duane,
>
> Do you still have the core file ? I would be interested in getting some
> info from there.
>
> Regards,
> Bogdan
>
>
> osiris123d wrote:
>
>> 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???
>>
>>
>
>
> --
> Bogdan-Andrei Iancu
> OpenSIPS Event - expo, conf, social, bootcamp
> 2 - 4 February 2011, ITExpo, Miami,  USA
> www.voice-system.ro
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101227/e187ac8f/attachment.html>