<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Hello Robert,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">this was briefly discussed on our devel meeting today. It seems that the DB_REDIS module does not implement the necessary delete all API from the redis library. You can have a look to
the module and see if you can extend it – alternatively open a feature request about it on our tracker.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Henning<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">-- <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Henning Westerholt –
</span><span style="mso-fareast-language:EN-US"><a href="https://skalatan.de/blog/"><span lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Kamailio services –
</span><span style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span lang="EN-GB" style="color:#0563C1">https://gilawa.com</span></a></span><span style="mso-fareast-language:EN-US">
<span lang="EN-GB"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span lang="EN-GB">Kamailio Merchandising – </span><a href="https://skalatan.de/merchandising"><span lang="EN-GB" style="color:#0563C1">https://skalatan.de/merchandising</span></a>
<span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b> sr-dev <sr-dev-bounces@lists.kamailio.org>
<b>On Behalf Of </b>Robert Boisvert<br>
<b>Sent:</b> Thursday, November 14, 2019 5:55 PM<br>
<b>To:</b> sr-dev@lists.kamailio.org<br>
<b>Subject:</b> [sr-dev] DB_REDIS Doesn't Seem to Work With Unfiltered Deletes<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Greetings,<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">I'm using the delete record feature as described in section
<a href="http://www.asipto.com/pub/kamailio-devel-guide/#c09f_delete">9.2.9</a> of the Kamailio SIP Server v3.2.0 Development Guide. When I try to delete the entire table without any filtering, as shown in the code below, DB_REDIS fails. Is this a bug?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Thank you in advance for your help,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Bob<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><b>Log</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="font-family:"Courier New"">DEBUG: db_redis [redis_connection.c:118]: db_redis_connect(): connecting to redis at
<a href="http://127.0.0.1:6379">127.0.0.1:6379</a><br>
DEBUG: db_redis [redis_connection.c:171]: db_redis_connect(): connection opened to redis://<a href="http://127.0.0.1:6379/5">127.0.0.1:6379/5</a><br>
DEBUG: db_redis [redis_connection.c:232]: db_redis_new_connection(): connection opened to redis://<a href="http://127.0.0.1:6379/5">127.0.0.1:6379/5</a><br>
DEBUG: db_redis [redis_dbase.c:2019]: db_redis_delete(): deleting from prefix (table) 'mohqcalls'<br>
DEBUG: db_redis [redis_dbase.c:524]: db_redis_build_query_keys(): build query keys<br>
DEBUG: db_redis [redis_dbase.c:295]: db_redis_find_query_key(): checking for existence of entry key 'call_id' in query<br>
DEBUG: db_redis [redis_dbase.c:306]: db_redis_find_query_key(): found key in entry key<br>
DEBUG: db_redis [redis_dbase.c:123]: db_redis_val2str(): converting string value '<a href="mailto:a1960c88-640f2e0f-bf639d1a@10.197.126.143">a1960c88-640f2e0f-bf639d1a@10.197.126.143</a>' with len 41 to str<br>
DEBUG: db_redis [redis_dbase.c:338]: db_redis_find_query_key(): entry key so far is '<a href="mailto:mohqcalls%3Aentry%3A%3Aa1960c88-640f2e0f-bf639d1a@10.197.126.143">mohqcalls:entry::a1960c88-640f2e0f-bf639d1a@10.197.126.143</a>'<br>
DEBUG: db_redis [redis_dbase.c:543]: db_redis_build_query_keys(): found suitable entry key '<a href="mailto:mohqcalls%3Aentry%3A%3Aa1960c88-640f2e0f-bf639d1a@10.197.126.143">mohqcalls:entry::a1960c88-640f2e0f-bf639d1a@10.197.126.143</a>' for query<br>
DEBUG: db_redis [redis_dbase.c:617]: db_redis_build_query_keys(): building manual keys<br>
DEBUG: db_redis [redis_dbase.c:254]: db_redis_build_entry_manual_keys(): checking for existence of entry key 'call_id' in query to get manual key<br>
DEBUG: db_redis [redis_dbase.c:259]: db_redis_build_entry_manual_keys(): found key in entry key<br>
DEBUG: db_redis [redis_dbase.c:1297]: db_redis_perform_delete(): delete all keys<br>
DEBUG: db_redis [redis_dbase.c:1303]: db_redis_perform_delete(): delete key '<a href="mailto:mohqcalls%3Aentry%3A%3Aa1960c88-640f2e0f-bf639d1a@10.197.126.143">mohqcalls:entry::a1960c88-640f2e0f-bf639d1a@10.197.126.143</a>'<br>
DEBUG: db_redis [redis_connection.c:32]: print_query(): Query dump:<br>
DEBUG: db_redis [redis_connection.c:34]: print_query(): EXISTS<br>
DEBUG: db_redis [redis_connection.c:34]: print_query(): <a href="mailto:mohqcalls%3Aentry%3A%3Aa1960c88-640f2e0f-bf639d1a@10.197.126.143">
mohqcalls:entry::a1960c88-640f2e0f-bf639d1a@10.197.126.143</a><br>
DEBUG: db_redis [redis_table.c:154]: db_redis_key_list2arr(): returning 2 entries<br>
DEBUG: db_redis [redis_connection.c:279]: db_redis_command_argv(): query has 2 args<br>
DEBUG: db_redis [redis_connection.c:32]: print_query(): Query dump:<br>
DEBUG: db_redis [redis_connection.c:34]: print_query(): HMGET<br>
DEBUG: db_redis [redis_connection.c:34]: print_query(): <a href="mailto:mohqcalls%3Aentry%3A%3Aa1960c88-640f2e0f-bf639d1a@10.197.126.143">
mohqcalls:entry::a1960c88-640f2e0f-bf639d1a@10.197.126.143</a><br>
DEBUG: db_redis [redis_table.c:154]: db_redis_key_list2arr(): returning 2 entries<br>
DEBUG: db_redis [redis_connection.c:279]: db_redis_command_argv(): query has 2 args<br>
ERROR: db_redis [redis_dbase.c:1352]: db_redis_perform_delete(): Failed to fetch type entry: ERR wrong number of arguments for 'hmget' command<br>
ERROR: db_redis [redis_dbase.c:1460]: db_redis_perform_delete(): failed to perform the delete<br>
ERROR: db_redis [redis_dbase.c:2076]: db_redis_delete(): failed to do the query<br>
WARNING: mohqueue [mohq_db.c:278]: delete_call_rec(): delete_call_rec: Unable to delete row from mohqcalls</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><b>Code</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="font-family:"Courier New"">db_func_t *pdb = pmod_data->pdb;<br>
pdb->use_table (pconn, &pmod_data->pcfg->db_ctable);<br>
if (pdb->delete (pconn, 0, 0, 0, 0) < 0)<br>
{<br>
LM_WARN ("%sUnable to delete all rows from %s\n", pfncname,<br>
pmod_data->pcfg->db_ctable.s);<br>
}</span><o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>