[OpenSIPS-Devel] [ opensips-Bugs-2558584 ] broken prepared statements in mysql / siptrace

SourceForge.net noreply at sourceforge.net
Wed Feb 4 19:57:23 CET 2009


Bugs item #2558584, was opened at 2009-02-03 00:57
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2558584&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: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: broken prepared statements in mysql / siptrace

Initial Comment:
Recent commits to the devel/head version of OpenSIPS 1.5 have broken my sip trace. I believe this is due to new prepared statement functionality included with the db_mysql module.

Below is a except from syslog

Feb  2 16:23:43 sip opensips[10558]: DBG:siptrace:trace_onreply_out: storing info... 
Feb  2 16:23:43 sip opensips[10558]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace 
Feb  2 16:23:43 sip opensips[10558]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run 
Feb  2 16:23:43 sip opensips[10558]: ERROR:db_mysql:db_mysql_val2str_nq: destination buffer too short 
Feb  2 16:23:43 sip opensips[10558]: ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1) 
Feb  2 16:23:43 sip opensips[10558]: ERROR:siptrace:trace_onreply_out: error storing trace 


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

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-02-03 12:06

Message:
Indeed, the problem seems to be the too short val buffer used for preparing
the statement - I will investigate the possibility of increasing the buffer
and what are the possible side effects for it. If not possible, I will
disable the prepared statements for the siptrace module as this module is
using large amount of date to transfer to DB (the sip messages).

Thanks and regards,
Bogdan

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2558584&group_id=232389



More information about the Devel mailing list