Bugs item #2609050, was opened at 2009-02-17 13:26 Message generated for change (Tracker Item Submitted) made by Item Submitter 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 () ---------------- ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2609050&group_id=232389 _______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
