<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    to confirm it is timer or not, can you do:<br>
    <br>
    kamctl ps<br>
    <br>
    That will show the type of the process.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <div class="moz-cite-prefix">On 05/10/15 09:29, Maciej Marczyński
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAErZqiPALuyh0H33u5FT26_QhL+45h3qKjak-WE_LKnudfmTYg@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hi, sure:
        <div><br>
        </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">
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [publish.c:75]: msg_presentity_clean(): cleaning expired
            presentity information</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: db_sqlite
            [dbase.c:183]: db_sqlite_submit_query(): submit_query:
            select username,domain,etag,event from presentity where
            expires<?1 AND expires>?2 order by username</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: <core>
            [db_res.c:116]: db_new_result(): allocate 56 bytes for
            result set at 0x7f3dc8e479e8</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [publish.c:116]: msg_presentity_clean(): found n= 0 expires
            messages#012</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: <core>
            [db_res.c:79]: db_free_columns(): freeing 0 columns</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: <core>
            [db_res.c:134]: db_free_result(): freeing result set at
            0x7f3dc8e479e8</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: db_sqlite
            [dbase.c:183]: db_sqlite_submit_query(): submit_query:
            delete from presentity where expires<?1 AND expires>?2</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [subscribe.c:734]: msg_watchers_clean(): cleaning pending
            subscriptions</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: db_sqlite
            [dbase.c:183]: db_sqlite_submit_query(): submit_query:
            delete from watchers where inserted_time<?1 AND status=?2</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [subscribe.c:2318]: timer_db_update(): db_update timer</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [subscribe.c:1984]: update_db_subs_timer_dbnone():
            update_db_subs_timer_dbnone: start</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:115]: printf_subs(): pres_uri: <a
              moz-do-not-send="true"
              href="mailto:sip%3Aaccount2@sip.xyz.com"><a class="moz-txt-link-freetext" href="sip:account2@sip.xyz.com">sip:account2@sip.xyz.com</a></a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:116]: printf_subs(): watcher_user@watcher_domain:
            <a moz-do-not-send="true" href="mailto:account3@sip.xyz.com">account3@sip.xyz.com</a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:117]: printf_subs(): to_user@to_domain: <a
              moz-do-not-send="true" href="mailto:account2@sip.xyz.com"><a class="moz-txt-link-abbreviated" href="mailto:account2@sip.xyz.com">account2@sip.xyz.com</a></a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:118]: printf_subs(): from_user@from_domain: <a
              moz-do-not-send="true" href="mailto:account3@sip.xyz.com"><a class="moz-txt-link-abbreviated" href="mailto:account3@sip.xyz.com">account3@sip.xyz.com</a></a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:119]: printf_subs(): callid/from_tag/to_tag:
GEHx1WHLMkpUoupFOXCVsil0C645AlOM/w89WvllNIi9BUryy9VDt3Zx4Tppz8-J6/a6a1c5f60faecf035a1ae5b6e96e979a-5550</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:120]: printf_subs(): local_cseq/remote_cseq:
            3/30284</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:121]: printf_subs(): local_contact/contact:
<a class="moz-txt-link-freetext" href="sip:172.17.0.1:5060;transport=tcp/sip:account3@172.17.0.7:39388;transport=TCP;ob;alias=172.17.42.1~42912~2">sip:172.17.0.1:5060;transport=tcp/sip:account3@172.17.0.7:39388;transport=TCP;ob;alias=172.17.42.1~42912~2</a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:122]: printf_subs(): record_route:</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:123]: printf_subs(): sockinfo_str: tcp:<a
              moz-do-not-send="true" href="http://172.17.0.1:5060">172.17.0.1:5060</a></blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:125]: printf_subs(): event: presence</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:126]: printf_subs(): status: active</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:127]: printf_subs(): reason:</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:128]: printf_subs(): version: 3</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:129]: printf_subs(): expires: 1444029183</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
            [notify.c:131]: printf_subs(): updated/updated_winfo: 0/0</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: pua
            [pua.c:1098]: db_update(): INSERTDB_FLAG</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: db_sqlite
            [dbase.c:183]: db_sqlite_submit_query(): submit_query:
            insert into pua
            (pres_uri,pres_id,flag,event,watcher_uri,call_id,to_tag,from_tag,etag,tuple_id,cseq,expires,desired_expires,record_route,contact,remote_contact,version,extra_headers
            ) values
            (?1,?2,?3,?4,?5,?6,?7,?8,?9,?10,?11,?12,?13,?14,?15,?16,?17,?18)</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: ERROR: db_sqlite
            [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: NOT
            NULL constraint failed: pua.call_id</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: ERROR: db_sqlite
            [dbase.c:138]: db_sqlite_cleanup_query(): finalize failed:
            NOT NULL constraint failed: pua.call_id</blockquote>
          <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">Oct
             5 07:04:36 028e61eb5dc7 kamailio[286]: ERROR: pua
            [pua.c:1179]: db_update(): while inserting in db table pua</blockquote>
        </blockquote>
        <div><br>
        </div>
        <div>The log appears probably on a timer as there's no SIP
          message at the time. The scenario is: A Subscribes B
          presentity, empty NOTIFY to A, B Registers + NOTIFY to A, B
          Unregister + NOTIFY to A, [...] some time later - bang - above
          logs.</div>
        <div><br>
        </div>
        <div>regards,</div>
        <div>Maciej</div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">2015-10-05 7:30 GMT+02:00
          Daniel-Constantin Mierla <span dir="ltr"><<a
              moz-do-not-send="true" href="mailto:miconda@gmail.com"
              target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></a>></span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
              <br>
              I think that even in db_mode 0 some records are stored in
              database, just that a cache of some data is kept in memory
              (to check if worth querying the database).<br>
              <br>
              Can you set debug=3 and send over the log messages from
              syslog for processing a sip message that ends up in such
              errors?<br>
              <br>
              Cheers,<br>
              Daniel
              <div>
                <div class="h5"><br>
                  <br>
                  <div>On 03/10/15 12:06, Maciej Marczyński wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <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></fieldset>
                    <br>
                  </div>
                </div>
                <pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre>
                <span class="HOEnZb"><font color="#888888"> </font></span></blockquote>
              <span class="HOEnZb"><font color="#888888"> <br>
                  <pre cols="72">-- 
Daniel-Constantin Mierla
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Sep 28-30, 2015, in Berlin - <a moz-do-not-send="true" href="http://asipto.com/u/kat" target="_blank">http://asipto.com/u/kat</a></pre>
                </font></span></div>
            <br>
            _______________________________________________<br>
            SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
            mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
              rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<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>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Sep 28-30, 2015, in Berlin - <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a></pre>
  </body>
</html>