[OpenSIPS-Users] opensips 3.2.2 Segfault on debian 11 bullseye

[William Jin]

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 at 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 <users-bounces at lists.opensips.org> on behalf of William Jin <williamj at exetel.com.au>
Sent: Friday, 17 September 2021 2:19 PM
To: Liviu Chircu <liviu at opensips.org>; OpenSIPS users mailling list <users at lists.opensips.org>
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 <users-bounces at lists.opensips.org> on behalf of William Jin <williamj at exetel.com.au>
Sent: Friday, 17 September 2021 9:12 AM
To: Liviu Chircu <liviu at opensips.org>; OpenSIPS users mailling list <users at lists.opensips.org>
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 <liviu at opensips.org>
Sent: Thursday, 16 September 2021 5:12 PM
To: OpenSIPS users mailling list <users at lists.opensips.org>; William Jin <williamj at exetel.com.au>
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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20210917/cd319367/attachment-0001.html>