<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;color:#0000ff">Dear Team,</div><div class="gmail_default" style="font-family:verdana,sans-serif;color:#0000ff">Does anyone face such issue of "crash of OS at the time of MariDB connection"?</div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><font color="#0000ff"><font size="2"><font face="verdana,sans-serif">--</font></font></font></div><div><font color="#0000ff"><font size="2"><font face="verdana,sans-serif">Regards</font></font></font></div><div><font color="#0000ff"><font size="2"><font face="verdana,sans-serif">Virendra Bhati<br></font></font></font></div><div><font color="#0000ff"><font size="2"><font face="verdana,sans-serif">Lead- Architecture and Software Solutions<br></font></font></font></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 30, 2019 at 9:30 PM <<a href="mailto:users-request@lists.opensips.org">users-request@lists.opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send Users mailing list submissions to<br>
<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:users-request@lists.opensips.org" target="_blank">users-request@lists.opensips.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:users-owner@lists.opensips.org" target="_blank">users-owner@lists.opensips.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Opensips crash while connecting mariadb (Virendra Bhati)<br>
2. Re: Example of configuration "Full Sharing" Topology with<br>
NoSQL (Liviu Chircu)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 30 Oct 2019 13:26:44 +0530<br>
From: Virendra Bhati <<a href="mailto:virendra@cloud-connect.in" target="_blank">virendra@cloud-connect.in</a>><br>
To: <a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a><br>
Subject: [OpenSIPS-Users] Opensips crash while connecting mariadb<br>
Message-ID:<br>
<CAB=<a href="mailto:dTEeKNT7w9fDZMAqZmORTSJGOT5QK3RZAcLmpiWU2vHPL1A@mail.gmail.com" target="_blank">dTEeKNT7w9fDZMAqZmORTSJGOT5QK3RZAcLmpiWU2vHPL1A@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Dear Team,<br>
<br>
We are using opensips 3.0.1 with mariadb 10.4.8 . We are facing issue at<br>
starting opensips. As opensips crash with below given message:<br>
<br>
Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found <db_bind_api> in<br>
module db_mysql [/usr/local/lib64/opensips/modules/]<br>
Oct 15 03:27:17 [22849] DBG:core:db_bind_mod: using db bind api for db_mysql<br>
Oct 15 03:27:17 [22849] DBG:core:db_do_init: connection 0x7fba0e093510 not<br>
found in pool<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno:<br>
2000<br>
<br>
I have attached logs and backtrace from core so please provide your<br>
suggestions. Please note credentials given in db_url are working while<br>
using from mysql client<br>
<br>
<br>
--<br>
Regards<br>
Virendra Bhati<br>
Lead- Architecture and Software Solutions<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.opensips.org/pipermail/users/attachments/20191030/dfb9da26/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.opensips.org/pipermail/users/attachments/20191030/dfb9da26/attachment-0001.html</a>><br>
-------------- next part --------------<br>
Oct 15 03:27:17 [22849] INFO:core:evi_publish_event: Registered event <E_DLG_STATE_CHANGED(11)><br>
Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found <load_tm> in module tm [/usr/local/lib64/opensips/modules/]<br>
Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found <load_rr> in module rr [/usr/local/lib64/opensips/modules/]<br>
Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found <db_bind_api> in module db_mysql [/usr/local/lib64/opensips/modules/]<br>
Oct 15 03:27:17 [22849] DBG:core:db_bind_mod: using db bind api for db_mysql<br>
Oct 15 03:27:17 [22849] DBG:core:db_do_init: connection 0x7fba0e093510 not found in pool<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" errno: 2000<br>
<br>
Got ERROR: "InnoDB: Operating system error number 11 in a file operation." errno: 2000<br>
Got ERROR: "InnoDB: Error number 11 means 'Resource temporarily unavailable'" errno: 2000<br>
Got ERROR: "InnoDB: Cannot open datafile '/var/lib/mysql/ibdata1'" errno: 2000<br>
Got ERROR: "InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!" errno: 2000<br>
Got ERROR: "InnoDB: Plugin initialization aborted with error Cannot open a file" errno: 2000<br>
Got ERROR: "Plugin 'InnoDB' init function returned error." errno: 2000<br>
Got ERROR: "Plugin 'InnoDB' registration as a STORAGE ENGINE failed." errno: 2000<br>
Got ERROR: "unknown: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds" errno: 2000<br>
<br>
<br>
<br>
^C^CGot ERROR: "unknown: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'" errno: 2000<br>
Got ERROR: "Plugin 'Aria' init function returned error." errno: 2000<br>
Got ERROR: "Plugin 'Aria' registration as a STORAGE ENGINE failed." errno: 2000<br>
Got ERROR: "Unknown/unsupported storage engine: InnoDB" errno: 2000<br>
DBG:db_mysql:db_mysql_connect: opening connection: mysql://xxxx:xxxx@localhost/cc_master<br>
CRITICAL:core:sig_usr: segfault in attendant (starter) process!<br>
DBG:core:restore_segv_handler: restoring SIGSEGV handler...<br>
DBG:core:restore_segv_handler: successfully restored system SIGSEGV handler<br>
^CSegmentation fault (core dumped)<br>
<br>
-------------- next part --------------<br>
(gdb) bt full<br>
#0 intern_plugin_lock (lex=0x0, state_mask=14, rc=0x0)<br>
at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_plugin.cc:948<br>
pi = 0x0<br>
#1 plugin_thdvar_init (thd=0x28af578) at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_plugin.cc:3155<br>
old_table_plugin = 0x0<br>
old_tmp_table_plugin = 0x0<br>
old_enforced_table_plugin = 0x0<br>
#2 0x00007fc7d58722b1 in THD::init (this=this@entry=0x28af578)<br>
at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:1177<br>
No locals.<br>
#3 0x00007fc7d587310a in THD::THD (this=0x28af578, id=<optimized out>, is_wsrep_applier=<optimized out>)<br>
at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:798<br>
tmp = <optimized out><br>
#4 0x00007fc7d57f2bdc in create_embedded_thd (client_flag=client_flag@entry=-2143837683)<br>
at /usr/src/debug/MariaDB-10.3.18/src_0/libmysqld/lib_sql.cc:685<br>
thd = 0x7fff689c20b0<br>
#5 0x00007fc7d57fa1e4 in mysql_real_connect (mysql=0x7fc7da7190b0, host=<optimized out>, user=<optimized out>, <br>
passwd=<optimized out>, db=0x7fc7da717620 "cc_master", port=port@entry=0, unix_socket=unix_socket@entry=0x0, <br>
client_flag=2151129613, client_flag@entry=2147549184)<br>
at /usr/src/debug/MariaDB-10.3.18/src_0/libmysqld/libmysqld.c:179<br>
name_buff = "\200\314|\326\307\177\000\000\060!\234h\377\177\000\000 !\234h\377\177\000\000\060!\234h\377\177\000\000\200\314|\326\307\177\000\000\001\000\000\000\000\000\000\000\340r\242\000\000\000\000\000p\251\215\000\000\000\000\000\340r\242\000\000\000\000\000\270\"\234h\377\177\000\000 vq\332\307\177\000\000\362\344s\333\307\177\000\000\000\000\000\000\000\000\000\000\060\000\000\000\060\000\000\000\060\"\234h\377\177\000\000P!\234h\377\177", '\000' <repeats 26 times>, "\224*\207\333\307\177\000\000\005+\207\333\307\177\000\000\300\061\253\333\307\177\000\000\200\363\252\333\307\177\000\000c\226u\333\307\177\000\000 vq\332\307\177\000\000"...<br>
#6 0x00007fc7d70e8a63 in db_mysql_connect (ptr=ptr@entry=0x7fc7da717668) at my_con.c:105<br>
reconnect = 0 '\000'<br>
---Type <return> to continue, or q <return> to quit---<br>
__FUNCTION__ = "db_mysql_connect"<br>
#7 0x00007fc7d70e94ff in db_mysql_new_connection (id=0x7fc7da717510) at my_con.c:165<br>
ptr = 0x7fc7da717668<br>
__FUNCTION__ = "db_mysql_new_connection"<br>
#8 0x00000000005ec4ba in db_do_init (url=<optimized out>, <br>
new_connection=0x7fc7d70e9417 <db_mysql_new_connection>) at db/db.c:338<br>
id = 0x7fc7da717510<br>
con = <optimized out><br>
res = 0x7fc7da717468<br>
con_size = <optimized out><br>
__FUNCTION__ = "db_do_init"<br>
#9 0x00007fc7d01044cd in dlg_connect_db (db_url=db_url@entry=0x7fc7d0340610 <db_url>) at dlg_db_handler.c:135<br>
__FUNCTION__ = "dlg_connect_db"<br>
#10 0x00007fc7d0104511 in init_dlg_db (db_url=db_url@entry=0x7fc7d0340610 <db_url>, <br>
dlg_hash_size=<optimized out>, db_update_period=60) at dlg_db_handler.c:176<br>
__FUNCTION__ = "init_dlg_db"<br>
#11 0x00007fc7d0100c27 in mod_init () at dialog.c:900<br>
n = <optimized out><br>
__FUNCTION__ = "mod_init"<br>
#12 0x000000000050bfa7 in init_mod (m=0x7fc7da6face0, skip_others=skip_others@entry=0) at sr_module.c:697<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#13 0x000000000050c028 in init_mod (m=0x7fc7da6fb970, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#14 0x000000000050c028 in init_mod (m=0x7fc7da6fbd28, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
---Type <return> to continue, or q <return> to quit---<br>
#15 0x000000000050c028 in init_mod (m=0x7fc7da6fbeb8, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#16 0x000000000050c028 in init_mod (m=0x7fc7da6fc0c0, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#17 0x000000000050c028 in init_mod (m=0x7fc7da6fc340, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#18 0x000000000050c028 in init_mod (m=0x7fc7da6fc4d8, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#19 0x000000000050c028 in init_mod (m=0x7fc7da6fd488, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#20 0x000000000050c028 in init_mod (m=0x7fc7da6fde20, skip_others=skip_others@entry=0) at sr_module.c:678<br>
dep = <optimized out><br>
__FUNCTION__ = "init_mod"<br>
#21 0x000000000050f45d in init_modules () at sr_module.c:759<br>
currentMod = 0x0<br>
ret = <optimized out><br>
__FUNCTION__ = "init_modules"<br>
#22 0x0000000000420351 in main (argc=<optimized out>, argv=<optimized out>) at main.c:1421<br>
c = <optimized out><br>
r = <optimized out><br>
tmp = 0x1 <Address 0x1 out of bounds><br>
tmp_len = <optimized out><br>
port = <optimized out><br>
---Type <return> to continue, or q <return> to quit---<br>
proto = <optimized out><br>
protos_no = <optimized out><br>
options = 0x67e9f8 "f:cCm:M:b:l:n:N:rRvdDFEVhw:t:u:g:p:P:G:W:o:a:k:s:"<br>
ret = -1<br>
seed = 961253727<br>
rfd = <optimized out><br>
__FUNCTION__ = "main"<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 30 Oct 2019 11:34:19 -0400<br>
From: Liviu Chircu <<a href="mailto:liviu@opensips.org" target="_blank">liviu@opensips.org</a>><br>
To: OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a>><br>
Subject: Re: [OpenSIPS-Users] Example of configuration "Full Sharing"<br>
Topology with NoSQL<br>
Message-ID: <<a href="mailto:33579d6f-a9ef-6e4d-5ab9-535450c25714@opensips.org" target="_blank">33579d6f-a9ef-6e4d-5ab9-535450c25714@opensips.org</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
Can you rather tell us more about the problem you are trying to solve, <br>
rather than<br>
inquiring about various (random) solutions? For example:<br>
<br>
* will your platform have 1 POP or multiple POPs?<br>
* do you want high availability for the user location nodes?<br>
<br>
Regards,<br>
<br>
-- <br>
Liviu Chircu<br>
OpenSIPS Developer<br>
<a href="http://www.opensips-solutions.com" rel="noreferrer" target="_blank">http://www.opensips-solutions.com</a><br>
<br>
On 10/28/19 10:27 AM, Social Boh wrote:<br>
><br>
> Hello,<br>
><br>
> if i don't want use a SBC how can I known is a node of cluster is up <br>
> or down? which method do you advise?<br>
><br>
> Thank you<br>
><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Users Digest, Vol 135, Issue 41<br>
**************************************<br>
</blockquote></div>