[OpenSIPS-Devel] [ opensips-Bugs-2609050 ] Segmentation fault in presence module related to MySQL

[SourceForge.net]

Bugs item #2609050, was opened at 2009-02-17 14:26
Message generated for change (Comment added) made by anca_vamanu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2609050&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Iñaki Baz (ibc_sf)
Assigned to: Nobody/Anonymous (nobody)
Summary: Segmentation fault in presence module related to MySQL

Initial Comment:
After upgrading to OpenSIPS rev 5320 a server acting as presence server crashes very often.
There is no traffic at all, just 4 users so very log presence traffic.


syslog:
----------
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:presence:search_event: start event= [dialog]
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:presence:handle_publish: SIP-If-Match header found
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:presence:handle_publish: existing etag  = a.1234829890.9781.1.1
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:presence:handle_publish: Expires header found, value= 8484
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_do_prepared_query: new query=|select body,sender from presentity where domain=? AND username=? AND
event=? AND etag=?|
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_do_prepared_query: prepared statement successfully set...
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=9; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=3; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=21; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7205]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_do_prepared_query: prepared statement successfully set...
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=21; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=4; type=3; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=4; type=3; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=9; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=3; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=6; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=21; type=254; is_null=0
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7204]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
Feb 17 11:41:26 presence_server /usr/sbin/opensips_presence[7222]: CRITICAL:core:receive_fd: EOF on 9
----------------


coredump:
----------------
#0  0x00002ae413496588 in mysql_stmt_prepare () from /usr/lib/libmysqlclient.so.15
#1  0x00002ae4134989dc in cli_stmt_execute () from /usr/lib/libmysqlclient.so.15
#2  0x00002ae413498495 in mysql_stmt_execute () from /usr/lib/libmysqlclient.so.15
#3  0x00002ae41332322c in db_mysql_free_result () from /usr/lib/opensips/modules/db_mysql.so
#4  0x00002ae41332453f in db_mysql_update () from /usr/lib/opensips/modules/db_mysql.so
#5  0x00002ae414a31185 in update_presentity () from /usr/lib/opensips/modules/presence.so
#6  0x00002ae414a342d5 in handle_publish () from /usr/lib/opensips/modules/presence.so
#7  0x000000000040f894 in do_action ()
#8  0x000000000040e0f3 in run_action_list ()
#9  0x0000000000411df5 in do_action ()
#10 0x000000000040e0f3 in run_action_list ()
#11 0x000000000041176f in do_action ()
#12 0x000000000040e0f3 in run_action_list ()
#13 0x0000000000411df5 in do_action ()
#14 0x000000000040e0f3 in run_action_list ()
#15 0x000000000041093a in do_action ()
#16 0x000000000040e0f3 in run_action_list ()
#17 0x000000000041176f in do_action ()
#18 0x000000000040e0f3 in run_action_list ()
#19 0x000000000040e480 in run_top_route ()
#20 0x0000000000441b4c in receive_msg ()
#21 0x0000000000472990 in udp_rcv_loop ()
#22 0x0000000000423917 in main ()
----------------

----------------------------------------------------------------------

>Comment By: Anca Vamanu (anca_vamanu)
Date: 2009-02-17 15:00

Message:
Hi Inaki,

I also noticed that there are problems with prepare statements and
operations in presentity table. But I thought that they occur only when
querying, because prepare statements put the result in a static buffer.
Just a couple of minutes ago I took out using prepare statements with
queries.