[OpenSIPS-Users] Opensips crash while connecting mariadb
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 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 Oct 15 03:27:17 [22849] INFO:core:evi_publish_event: Registered event Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found in module tm [/usr/local/lib64/opensips/modules/] Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found in module rr [/usr/local/lib64/opensips/modules/] Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found 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://:@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) (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 0x7fc7d58722b1 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 0x7fc7d587310a in THD::THD (this=0x28af578, id=, is_wsrep_applier=) at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:798 tmp = #4 0x7fc7d57f2bdc 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 0x7fc7d57fa1e4 in mysql_real_connect (mysql=0x7fc7da7190b0, host=, user=, passwd=, 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\
[OpenSIPS-Users] Opensips crash while connecting mariadb
Hello all, i am using opensips 3.0.1 with mariadb 10.4.8 and i am facing issue in starting opensips. As opensips crash with below given message: ct 15 03:27:17 [22849] DBG:core:find_mod_export: found 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 back trace from core so please provide your suggestions. please note credentials given in db_url are working while using from msyql client Thanks in advance. Ravindra Bhatt Oct 15 03:27:17 [22849] INFO:core:evi_publish_event: Registered event Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found in module tm [/usr/local/lib64/opensips/modules/] Oct 15 03:27:17 [22849] DBG:core:find_cmd_export_t: found in module rr [/usr/local/lib64/opensips/modules/] Oct 15 03:27:17 [22849] DBG:core:find_mod_export: found 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://:@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) (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 0x7fc7d58722b1 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 0x7fc7d587310a in THD::THD (this=0x28af578, id=, is_wsrep_applier=) at /usr/src/debug/MariaDB-10.3.18/src_0/sql/sql_class.cc:798 tmp = #4 0x7fc7d57f2bdc 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 0x7fc7d57fa1e4 in mysql_real_connect (mysql=0x7fc7da7190b0, host=, user=, passwd=, 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