And I just enabled log_level=4 It connects to db (mysql 8.0.26-1debian11) and converting password string to val, then segfault Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f6d33facd80 (tail=140107000235208) MC=0x7f6d33fac560 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: new query=|select password,rpid from subscriber where username=?| Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:re_init_statement: query is <select password,rpid from subscriber where username=?>, ptr=(nil) Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: new statement(0x7f6d33faf978) on connection: (0x7f6d33facd80) 0x7f6d33fac4c8 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=10; type=254; is_null=0 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: prepared statement has 2 columns in result Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_do_prepared_query: doing to BIND_PARAM out ... Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_new_result: allocate 48 bytes for result set at 0x7f6d33fadf68 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_allocate_columns: allocate 56 bytes for result columns at 0x7f6d33faf060 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f6d33faf070)[0]=[password] Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f6d33faf080)[1]=[rpid] Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:core:db_allocate_rows: allocate 80 bytes for result rows and values at 0x7f6d33fb0450 Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: DBG:db_mysql:db_mysql_str2val: converting STRING [my@password] Sep 17 14:33:23 ip-10-20-12-22 /usr/sbin/opensips[188225]: CRITICAL:core:sig_usr: segfault in process pid: 188225, id: 15
-- Regards, William Jin ________________________________ From: Users <[email protected]> on behalf of William Jin <[email protected]> Sent: Friday, 17 September 2021 2:19 PM To: Liviu Chircu <[email protected]>; OpenSIPS users mailling list <[email protected]> Subject: Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye And just further investigation, looks like it's crashed only after I register my test user. (which can register on debian 10 before upgraded to debian 11 using zoiper softphone) And the backtrack also indicate the crash from auth_db?? -- Regards, William Jin ________________________________ From: Users <[email protected]> on behalf of William Jin <[email protected]> Sent: Friday, 17 September 2021 9:12 AM To: Liviu Chircu <[email protected]>; OpenSIPS users mailling list <[email protected]> Subject: Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye Hi Liviu, I attached the backtrace in the init email. I've attached it again. -- Regards, William Jin ________________________________ From: Liviu Chircu <[email protected]> Sent: Thursday, 16 September 2021 5:12 PM To: OpenSIPS users mailling list <[email protected]>; William Jin <[email protected]> Subject: Re: [OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye On 16.09.2021 02:16, William Jin wrote: > Anyone has any chance to look into this? Hi William, There is not enough info to look into anything, really: * how are you reproducing this crash? can you share a basic opensips.cfg that causes it? * are there any useful logs _before_ those "signal 11" logs? * can you obtain a backtrace out of this crash? See this guide [1] for some help here [1]: https://www.opensips.org/Documentation/TroubleShooting-Crash Best, -- Liviu Chircu www.twitter.com/liviuchircu<http://www.twitter.com/liviuchircu> | www.opensips-solutions.com<http://www.opensips-solutions.com>
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
