<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
What would be the situation when the query is like SELECT but there
is no result. Is the behaviour as expected with the new patch?<br>
<br>
Anyone here using cassandra having comments? From my point of view
is no problem to push the patch, but I am not using cassandra, so
cannot do a proper review.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 12/03/14 08:53, jay binks wrote:<br>
</div>
<blockquote
cite="mid:CAO47HpfWXbsNDj7X4w0vEKP-i-1ZWtCEx80W9tdw_91Vrjmwiw@mail.gmail.com"
type="cite">
<div dir="ltr">If doing a query that returns no results ( Insert
etc )
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px">db_cassa_raw_query
would cause these ERRORS to be logged</span>
<div>
<span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px"><br>
</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">0(22283)
ERROR: db_cassandra </span><span class=""
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">[dbcassa_base.cpp:739]</span><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">:
db_cassa_raw_query(): The resultype rows was not set, no
point trying to parse result.</span><br
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">
<span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">0(22283)
ERROR: avpops </span><span class=""
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">[avpops_db.c:333]</span><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px">:
db_query_avp(): cannot do the query</span><br>
</div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px"><br>
</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px">db_cassa_raw_query
would also return -1 as a failure code which caused
avpops_db to log the query failure.</span><br>
</div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px"><br>
</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px">my
patch changes the </span><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px">db_cassa_raw_query
log message to debug level, and returns success from the
function.</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px"><br>
</span></div>
<div><font color="#000000" face="Arial, FreeSans, Helvetica,
sans-serif"><span style="line-height:17.000099182128906px">I
had a quick look to see if there was an elegant way to
determine if we should expect results, so we can vary
the response code based on query type, but I was unable
to find anything other than doing string comparisons on
the query, so I opted to not bother with this as it
would be erroneous.</span></font></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px"><br>
</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13.333333969116211px;line-height:17.000099182128906px">Please
find attached patch.</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:13px;line-height:17.000099182128906px"><br>
</span></div>
-- <br>
Sincerely<br>
<br>
Jay
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
sr-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>