Dear Bogdan and Team, Cloud you please reply on this as we tested with another server and this issue is persisting continue. -- Regards Virendra Bhati Lead- Architecture and Software Solutions
On Thu, Nov 14, 2019 at 10:37 AM Virendra Bhati <[email protected]> wrote: > Dear Team, > Does anyone face such issue of "crash of OS at the time of MariDB > connection"? > -- > Regards > Virendra Bhati > Lead- Architecture and Software Solutions > > > On Wed, Oct 30, 2019 at 9:30 PM <[email protected]> wrote: > >> Send Users mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> or, via email, send a message with subject or body 'help' to >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Users digest..." >> >> >> Today's Topics: >> >> 1. Opensips crash while connecting mariadb (Virendra Bhati) >> 2. Re: Example of configuration "Full Sharing" Topology with >> NoSQL (Liviu Chircu) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Wed, 30 Oct 2019 13:26:44 +0530 >> From: Virendra Bhati <[email protected]> >> To: [email protected] >> Subject: [OpenSIPS-Users] Opensips crash while connecting mariadb >> Message-ID: >> <CAB= >> [email protected]> >> Content-Type: text/plain; charset="utf-8" >> >> Dear Team, >> >> We are using opensips 3.0.1 with mariadb 10.4.8 . We are facing issue at >> starting opensips. As opensips crash with below given message: >> >> Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found <db_bind_api> in >> module db_mysql [/usr/local/lib64/opensips/modules/] >> Oct 15 03:27:17 [22849] DBG:core:db_bind_mod: using db bind api for >> db_mysql >> Oct 15 03:27:17 [22849] DBG:core:db_do_init: connection 0x7fba0e093510 not >> found in pool >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: >> 2000 >> >> I have attached logs and backtrace from core so please provide your >> suggestions. Please note credentials given in db_url are working while >> using from mysql client >> >> >> -- >> Regards >> Virendra Bhati >> Lead- Architecture and Software Solutions >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.opensips.org/pipermail/users/attachments/20191030/dfb9da26/attachment-0001.html >> > >> -------------- next part -------------- >> Oct 15 03:27:17 [22849] INFO:core:evi_publish_event: Registered event >> <E_DLG_STATE_CHANGED(11)> >> Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found <load_tm> in >> module tm [/usr/local/lib64/opensips/modules/] >> Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found <load_rr> in >> module rr [/usr/local/lib64/opensips/modules/] >> Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found <db_bind_api> in >> module db_mysql [/usr/local/lib64/opensips/modules/] >> Oct 15 03:27:17 [22849] DBG:core:db_bind_mod: using db bind api for >> db_mysql >> Oct 15 03:27:17 [22849] DBG:core:db_do_init: connection 0x7fba0e093510 >> not found in pool >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> Got ERROR: "InnoDB: Unable to lock /var/lib/mysql/ibdata1 error: 11" >> errno: 2000 >> >> Got ERROR: "InnoDB: Operating system error number 11 in a file >> operation." errno: 2000 >> Got ERROR: "InnoDB: Error number 11 means 'Resource temporarily >> unavailable'" errno: 2000 >> Got ERROR: "InnoDB: Cannot open datafile '/var/lib/mysql/ibdata1'" errno: >> 2000 >> 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 >> Got ERROR: "InnoDB: Plugin initialization aborted with error Cannot open >> a file" errno: 2000 >> Got ERROR: "Plugin 'InnoDB' init function returned error." errno: 2000 >> Got ERROR: "Plugin 'InnoDB' registration as a STORAGE ENGINE failed." >> errno: 2000 >> 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 >> >> >> >> ^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 >> Got ERROR: "Plugin 'Aria' init function returned error." errno: 2000 >> Got ERROR: "Plugin 'Aria' registration as a STORAGE ENGINE failed." >> errno: 2000 >> Got ERROR: "Unknown/unsupported storage engine: InnoDB" errno: 2000 >> DBG:db_mysql:db_mysql_connect: opening connection: >> mysql://xxxx:xxxx@localhost/cc_master >> CRITICAL:core:sig_usr: segfault in attendant (starter) process! >> DBG:core:restore_segv_handler: restoring SIGSEGV handler... >> DBG:core:restore_segv_handler: successfully restored system SIGSEGV >> handler >> ^CSegmentation fault (core dumped) >> >> -------------- next part -------------- >> (gdb) bt full >> #0 intern_plugin_lock (lex=0x0, state_mask=14, rc=0x0) >> at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_plugin.cc:948 >> pi = 0x0 >> #1 plugin_thdvar_init (thd=0x28af578) at >> /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_plugin.cc:3155 >> old_table_plugin = 0x0 >> old_tmp_table_plugin = 0x0 >> old_enforced_table_plugin = 0x0 >> #2 0x00007fc7d58722b1 in THD::init (this=this@entry=0x28af578) >> at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:1177 >> No locals. >> #3 0x00007fc7d587310a in THD::THD (this=0x28af578, id=<optimized out>, >> is_wsrep_applier=<optimized out>) >> at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:798 >> tmp = <optimized out> >> #4 0x00007fc7d57f2bdc in create_embedded_thd >> (client_flag=client_flag@entry=-2143837683) >> at /usr/src/debug/MariaDB-10.3.18/src_0/libmysqld/lib_sql.cc:685 >> thd = 0x7fff689c20b0 >> #5 0x00007fc7d57fa1e4 in mysql_real_connect (mysql=0x7fc7da7190b0, >> host=<optimized out>, user=<optimized out>, >> passwd=<optimized out>, db=0x7fc7da717620 "cc_master", port=port@entry=0, >> unix_socket=unix_socket@entry=0x0, >> client_flag=2151129613, client_flag@entry=2147549184) >> at /usr/src/debug/MariaDB-10.3.18/src_0/libmysqld/libmysqld.c:179 >> 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"... >> #6 0x00007fc7d70e8a63 in db_mysql_connect (ptr=ptr@entry=0x7fc7da717668) >> at my_con.c:105 >> reconnect = 0 '\000' >> ---Type <return> to continue, or q <return> to quit--- >> __FUNCTION__ = "db_mysql_connect" >> #7 0x00007fc7d70e94ff in db_mysql_new_connection (id=0x7fc7da717510) at >> my_con.c:165 >> ptr = 0x7fc7da717668 >> __FUNCTION__ = "db_mysql_new_connection" >> #8 0x00000000005ec4ba in db_do_init (url=<optimized out>, >> new_connection=0x7fc7d70e9417 <db_mysql_new_connection>) at >> db/db.c:338 >> id = 0x7fc7da717510 >> con = <optimized out> >> res = 0x7fc7da717468 >> con_size = <optimized out> >> __FUNCTION__ = "db_do_init" >> #9 0x00007fc7d01044cd in dlg_connect_db (db_url=db_url@entry=0x7fc7d0340610 >> <db_url>) at dlg_db_handler.c:135 >> __FUNCTION__ = "dlg_connect_db" >> #10 0x00007fc7d0104511 in init_dlg_db (db_url=db_url@entry=0x7fc7d0340610 >> <db_url>, >> dlg_hash_size=<optimized out>, db_update_period=60) at >> dlg_db_handler.c:176 >> __FUNCTION__ = "init_dlg_db" >> #11 0x00007fc7d0100c27 in mod_init () at dialog.c:900 >> n = <optimized out> >> __FUNCTION__ = "mod_init" >> #12 0x000000000050bfa7 in init_mod (m=0x7fc7da6face0, >> skip_others=skip_others@entry=0) at sr_module.c:697 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #13 0x000000000050c028 in init_mod (m=0x7fc7da6fb970, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #14 0x000000000050c028 in init_mod (m=0x7fc7da6fbd28, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> ---Type <return> to continue, or q <return> to quit--- >> #15 0x000000000050c028 in init_mod (m=0x7fc7da6fbeb8, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #16 0x000000000050c028 in init_mod (m=0x7fc7da6fc0c0, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #17 0x000000000050c028 in init_mod (m=0x7fc7da6fc340, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #18 0x000000000050c028 in init_mod (m=0x7fc7da6fc4d8, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #19 0x000000000050c028 in init_mod (m=0x7fc7da6fd488, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #20 0x000000000050c028 in init_mod (m=0x7fc7da6fde20, >> skip_others=skip_others@entry=0) at sr_module.c:678 >> dep = <optimized out> >> __FUNCTION__ = "init_mod" >> #21 0x000000000050f45d in init_modules () at sr_module.c:759 >> currentMod = 0x0 >> ret = <optimized out> >> __FUNCTION__ = "init_modules" >> #22 0x0000000000420351 in main (argc=<optimized out>, argv=<optimized >> out>) at main.c:1421 >> c = <optimized out> >> r = <optimized out> >> tmp = 0x1 <Address 0x1 out of bounds> >> tmp_len = <optimized out> >> port = <optimized out> >> ---Type <return> to continue, or q <return> to quit--- >> proto = <optimized out> >> protos_no = <optimized out> >> options = 0x67e9f8 >> "f:cCm:M:b:l:n:N:rRvdDFEVhw:t:u:g:p:P:G:W:o:a:k:s:" >> ret = -1 >> seed = 961253727 >> rfd = <optimized out> >> __FUNCTION__ = "main" >> >> >> ------------------------------ >> >> Message: 2 >> Date: Wed, 30 Oct 2019 11:34:19 -0400 >> From: Liviu Chircu <[email protected]> >> To: OpenSIPS users mailling list <[email protected]> >> Subject: Re: [OpenSIPS-Users] Example of configuration "Full Sharing" >> Topology with NoSQL >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=utf-8; format=flowed >> >> Can you rather tell us more about the problem you are trying to solve, >> rather than >> inquiring about various (random) solutions? For example: >> >> * will your platform have 1 POP or multiple POPs? >> * do you want high availability for the user location nodes? >> >> Regards, >> >> -- >> Liviu Chircu >> OpenSIPS Developer >> http://www.opensips-solutions.com >> >> On 10/28/19 10:27 AM, Social Boh wrote: >> > >> > Hello, >> > >> > if i don't want use a SBC how can I known is a node of cluster is up >> > or down? which method do you advise? >> > >> > Thank you >> > >> >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> ------------------------------ >> >> End of Users Digest, Vol 135, Issue 41 >> ************************************** >> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
