<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I can confirm I am seeing the same issue, I'm not setting db_mode
parameter, but according to the docs it defaults to 0 (caching
mode). I'm running kamailio v4.3.3<br>
<br>
Log:<br>
Oct 9 11:06:27 kam_proxy01[20890]: ERROR: db_sqlite [dbase.c:489]:
db_sqlite_commit(): sqlite commit failed: constraint failed<br>
Oct 9 11:06:27 kam_proxy01[20890]: ERROR: db_sqlite [dbase.c:138]:
db_sqlite_cleanup_query(): finalize failed: pua.call_id may not be
NULL<br>
Oct 9 11:06:27 kam_proxy01[20890]: ERROR: pua [pua.c:1179]:
db_update(): while inserting in db table pua<br>
<br>
Associated Process:<br>
Process:: ID=76 PID=20890 Type=slow timer<br>
<br>
Kamailio Version:<br>
version: kamailio 4.3.3 (x86_64/linux) e275bc<br>
<br>
Thanks<br>
<br>
<br>
<div class="moz-cite-prefix">On 03/10/2015 11:06, Maciej Marczyński
wrote:<br>
</div>
<blockquote
cite="mid:CAErZqiNN_5-cGVQqVRCVEpDRaBNhK-AEzywA2bMeJ4QyhOw3JQ@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Guys,
<div>I have a question regarding pua module parameter 'db mode'.</div>
<div>I run Kamailio (4.3.2) with sqlite and I tried to set the
parameter to 0 but even then I received:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<pre style="overflow:auto;font-family:Consolas,'Liberation Mono',Menlo,Courier,monospace;font-size:11.9px;margin-top:0px;margin-bottom:16px;font-stretch:normal;line-height:1.45;padding:16px;border-radius:3px;word-wrap:normal;color:rgb(51,51,51);background-color:rgb(247,247,247)"><code style="font-family:Consolas,'Liberation Mono',Menlo,Courier,monospace;font-size:11.9px;padding:0px;margin:0px;border-radius:3px;border:0px;display:inline;max-width:initial;overflow:initial;line-height:inherit;word-wrap:normal;background:transparent">ERROR: db_sqlite [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: NOT NULL constraint failed: pua.call_id
ERROR: db_sqlite [dbase.c:138]: db_sqlite_cleanup_query(): finalize failed: NOT NULL constraint failed: pua.call_id
ERROR: pua [pua.c:1179]: db_update(): while inserting in db table pua</code></pre>
</blockquote>
<div>As far as I checked the documentation, it says that '0'
means:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12px;text-align:justify">high
speed memory based storage</span></blockquote>
<div>Does it still writes to DB anyway (on timer or whatever?)
or just keep it in memory? Is there any way to disable writing
to DB?</div>
<div><br>
</div>
<div>The second thing is the reason of the ERRORs above. Why
does pua think that my call_id is null?</div>
<div><br>
</div>
<div><br>
</div>
<div>If you need any more information please let me know.</div>
<div><br>
</div>
<div>Best regards and have a good weekend,</div>
<div>Maciej</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
</body>
</html>