<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Bogdan.</p>
<p><br>
</p>
<p>I have just analyzed some more information about the case, as you asked me. See below the queries that cause the error. </p>
<p>In addiction, in the past I had changed the file that you can find attached in this message (it is for sqlite). There was an error in such file that prevented me to execute these complex queiries. After discussing in this list, a solution was proposed to
such file, as you can see. Could you inspect the file and tell me if there is some problem there? Any hint will be very helpful!</p>
<p><br>
</p>
<p>P.S.: before the error for the queries there is no another error just before as seen in the log.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>route{<br>
...<br>
if (has_totag()) {<br>
<br>
if (loose_route()) { <br>
...<br>
<br>
} else {<br>
<br>
if ( is_method("ACK") ) {<br>
if ( t_check_trans() ) {<br>
# non loose-route, but stateful ACK; must be an ACK after <br>
# a 487 or e.g. 404 from upstream server<br>
<br>
t_relay();<br>
<br>
<b> # if a call is rejected or the caller gives up waiting for an answer, we have this 2 queries being executed:</b><br>
<span style="color: rgb(0, 111, 201);"> avp_db_query("DELETE FROM acc WHERE time IN (SELECT time FROM acc UNION SELECT time FROM missed_calls ORDER BY time DESC LIMIT 300 OFFSET 150)");</span><br>
<span style="color: rgb(0, 111, 201);"> avp_db_query("DELETE FROM missed_calls WHERE time IN (SELECT time FROM acc UNION SELECT time FROM missed_calls ORDER BY time DESC LIMIT 300 OFFSET 150)");</span><br>
<br>
exit;<br>
} else {<br>
# ACK without matching transaction -><br>
# ignore and discard<br>
exit;<br>
}<br>
}<br>
sl_send_reply("404","Not here");<br>
}<br>
<br>
<br>
exit;<br>
}<br>
<br>
...<br>
<br>
if (is_method("INVITE")) {<br>
<br>
...<br>
<br>
}<br>
<br>
<br>
if (is_method("REGISTER")) <br>
{<br>
<br>
...<br>
<br>
<b># this query executes whenever the client does a SIP REGISTER:</b><br>
<span style="color: rgb(0, 111, 201);"> avp_db_query("UPDATE location SET callerName='$fn' WHERE id = last_insert_rowid()");</span><br>
<br>
exit;<br>
}<br>
<br>
if ($rU==NULL) {<br>
<br>
... <br>
<br>
# when routing via usrloc, log the missed calls also<br>
if (($fU==$avp(I_A)) || ($fU==$avp(I_B)) ){ <br>
setflag(ACC_MISSED);<br>
}<br>
route(relay);<br>
}<br>
<br>
</p>
<p><br>
</p>
<p><br>
route[relay] {<br>
# for INVITEs enable some additional helper routes<br>
if (is_method("INVITE")) {<br>
<br>
#if (isflagset(NAT)) {<br>
#rtpproxy_offer("ro");<br>
#}<br>
<br>
t_on_branch("per_branch_ops");<br>
t_on_reply("handle_nat");<br>
t_on_failure("missed_call");<br>
}<br>
<br>
...<br>
<br>
<b> #this queries execute whenever a peer is calling, or a peer answer, o a call is terminated.</b><br>
<b><span style="color: rgb(0, 111, 201);"> avp_db_query("DELETE FROM acc WHERE time IN (SELECT time FROM acc UNION SELECT time FROM missed_calls ORDER BY time DESC LIMIT 300 OFFSET 150)");</span><br>
<span style="color: rgb(0, 111, 201);"> avp_db_query("DELETE FROM missed_calls WHERE time IN (SELECT time FROM acc UNION SELECT time FROM missed_calls ORDER BY time DESC LIMIT 300 OFFSET 150)");</span></b><br>
<br>
exit;<br>
}<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>Thanks a lot!<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>De:</b> users-bounces@lists.opensips.org <users-bounces@lists.opensips.org> em nome de Rodrigo Pimenta Carvalho <pimenta@inatel.br><br>
<b>Enviado:</b> quarta-feira, 24 de fevereiro de 2016 09:07<br>
<b>Para:</b> Bogdan-Andrei Iancu; OpenSIPS users mailling list<br>
<b>Cc:</b> Daniel Lopes Fússia<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] Avp_db_query causing error with invalid parameter value. How to fix it?</font>
<div> </div>
</div>
<div>
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi Bogdan.</p>
<p><br>
</p>
<p>I will do this check and let you know the result. Wait some minutes, please.</p>
<p><br>
</p>
<p>Thanks.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>De:</b> Bogdan-Andrei Iancu <bogdan@opensips.org><br>
<b>Enviado:</b> terça-feira, 23 de fevereiro de 2016 19:19<br>
<b>Para:</b> OpenSIPS users mailling list<br>
<b>Cc:</b> Daniel Lopes Fússia; Rodrigo Pimenta Carvalho<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] Avp_db_query causing error with invalid parameter value. How to fix it?</font>
<div> </div>
</div>
<div><tt>Hi Rodrigo,<br>
<br>
Can you identify the actual query (like maybe printing something in the script via xlog) that generates this error ? also, are there any previous errors just above this one ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a id="LPlnk305075" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div id="LPBorder_GT_14563155481640.2263392499328455" style="margin-bottom:20px; overflow:auto; width:100%; text-indent:0px">
<table id="LPContainer_14563155481590.09107872377266224" style="width:90%; background-color:rgb(255,255,255); overflow:auto; padding-top:20px; padding-bottom:20px; margin-top:20px; border-top:1px dotted rgb(200,200,200); border-bottom:1px dotted rgb(200,200,200)" cellspacing="0">
<tbody>
<tr style="border-spacing:0px" valign="top">
<td colspan="1" id="ImageCell_14563155481610.33604081500259264" style="width:250px; display:table-cell; padding-right:20px">
<div id="LPImageContainer_14563155481610.7812640414731009" style="background-color:rgb(255,255,255); height:0px; margin:auto; display:table; width:0px">
<a target="_blank" href="http://www.opensips-solutions.com/" id="LPImageAnchor_14563155481610.4295562563765397" style="display:table-cell; text-align:center"><img style="display:inline-block; margin-left:auto; margin-right:auto; max-width:250px; max-height:250px; height:38px; width:116px; border-width:0px; vertical-align:bottom" height="38" width="116" src="http://www.opensips-solutions.com/imgs/opensips-solutions-logo.gif"></a></div>
</td>
<td colspan="2" id="TextCell_14563155481620.08827108704766096" style="vertical-align: top; padding: 0px; display: table-cell; position: relative;">
<div id="LPRemovePreviewContainer_14563155481620.9340795412980267"></div>
<div id="LPTitle_14563155481620.4541290431294517" style="top:0px; color:rgb(0,120,215); font-weight:400; font-size:21px; font-family:"wf_segoe-ui_light","Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; line-height:21px">
<a target="_blank" href="http://www.opensips-solutions.com/" id="LPUrlAnchor_14563155481630.9672552597533473" style="text-decoration:none">Home — OpenSIPS Solutions</a></div>
<div id="LPMetadata_14563155481630.004401956624995873" style="margin:10px 0px 16px; color:rgb(102,102,102); font-weight:400; font-family:"wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size:14px; line-height:14px">
www.opensips-solutions.com</div>
<div id="LPDescription_14563155481630.22878661263551292" style="display:block; color:rgb(102,102,102); font-weight:400; font-family:"wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size:14px; line-height:20px; max-height:100px; overflow:hidden">
OpenSIPS is a mature Open Source implementation of a SIP server. OpenSIPS is more than a SIP proxy/router as it includes application-level functionalities.</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">On 23.02.2016 22:06, Rodrigo Pimenta Carvalho wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<p><br>
</p>
<p>Hi.</p>
<p><br>
</p>
<p>Most of my queries in avp_db_query is causing the following error:<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>"ERROR:db_sqlite:db_sqlite_free_result: invalid parameter value"</p>
<p><br>
</p>
<p>How to fix it? I'm sure that all SQL queries is correct, as I have tested it in an isolated way direct over the database. In addiction, all SQL commands with avp_db_query can change the data in the database correctly. The unique issue is the "ERROR" seen
in the log.</p>
<p><br>
</p>
<p>The documentation doesn't comment on it.<br>
</p>
<p><br>
</p>
<p>Any hint will be very helpful!</p>
<p><br>
</p>
<p>Thanks a lot.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset> <br>
<pre>_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>