[SR-Users] [pua] Question to DB Mode 0

Maciej Marczyński bamaciej999 at gmail.com
Mon Oct 5 20:09:44 CEST 2015


The process is: |slow timer|

Thanks,
Maciej
W dniu 2015-10-05 o 15:23, Daniel-Constantin Mierla pisze:
> Hello,
>
> to confirm it is timer or not, can you do:
>
> kamctl ps
>
> That will show the type of the process.
>
> Cheers,
> Daniel
>
> On 05/10/15 09:29, Maciej Marczyński wrote:
>> Hi, sure:
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [publish.c:75]: msg_presentity_clean(): cleaning expired
>>         presentity information
>>
>>         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
>>
>>         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
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [publish.c:116]: msg_presentity_clean(): found n= 0 expires
>>         messages#012
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: <core>
>>         [db_res.c:79]: db_free_columns(): freeing 0 columns
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: <core>
>>         [db_res.c:134]: db_free_result(): freeing result set at
>>         0x7f3dc8e479e8
>>
>>         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
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [subscribe.c:734]: msg_watchers_clean(): cleaning pending
>>         subscriptions
>>
>>         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
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [subscribe.c:2318]: timer_db_update(): db_update timer
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [subscribe.c:1984]: update_db_subs_timer_dbnone():
>>         update_db_subs_timer_dbnone: start
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:115]: printf_subs(): pres_uri: sip:account2 at sip.xyz.com
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:116]: printf_subs(): watcher_user at watcher_domain:
>>         account3 at sip.xyz.com <mailto:account3 at sip.xyz.com>
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:117]: printf_subs(): to_user at to_domain:
>>         account2 at sip.xyz.com
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:118]: printf_subs(): from_user at from_domain:
>>         account3 at sip.xyz.com
>>
>>         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
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:120]: printf_subs(): local_cseq/remote_cseq: 3/30284
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:121]: printf_subs(): local_contact/contact:
>>         sip:172.17.0.1:5060;transport=tcp/sip:account3 at 172.17.0.7:39388;transport=TCP;ob;alias=172.17.42.1~42912~2
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:122]: printf_subs(): record_route:
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:123]: printf_subs(): sockinfo_str:
>>         tcp:172.17.0.1:5060 <http://172.17.0.1:5060>
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:125]: printf_subs(): event: presence
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:126]: printf_subs(): status: active
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:127]: printf_subs(): reason:
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:128]: printf_subs(): version: 3
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:129]: printf_subs(): expires: 1444029183
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: presence
>>         [notify.c:131]: printf_subs(): updated/updated_winfo: 0/0
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: DEBUG: pua
>>         [pua.c:1098]: db_update(): INSERTDB_FLAG
>>
>>         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)
>>
>>         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
>>
>>         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
>>
>>         Oct  5 07:04:36 028e61eb5dc7 kamailio[286]: ERROR: pua
>>         [pua.c:1179]: db_update(): while inserting in db table pua
>>
>>
>> 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.
>>
>> regards,
>> Maciej
>>
>> 2015-10-05 7:30 GMT+02:00 Daniel-Constantin Mierla <miconda at gmail.com>:
>>
>>     Hello,
>>
>>     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).
>>
>>     Can you set debug=3 and send over the log messages from syslog
>>     for processing a sip message that ends up in such errors?
>>
>>     Cheers,
>>     Daniel
>>
>>
>>     On 03/10/15 12:06, Maciej Marczyński wrote:
>>>     Hi Guys,
>>>     I have a question regarding pua module parameter 'db mode'.
>>>     I run Kamailio (4.3.2) with sqlite and I tried to set the
>>>     parameter to 0 but even then I received:
>>>
>>>         |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|
>>>
>>>     As far as I checked the documentation, it says that '0' means:
>>>
>>>         high speed memory based storage
>>>
>>>     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?
>>>
>>>     The second thing is the reason of the ERRORs above. Why does pua
>>>     think that my call_id is null?
>>>
>>>
>>>     If you need any more information please let me know.
>>>
>>>     Best regards and have a good weekend,
>>>     Maciej
>>>
>>>
>>>     _______________________________________________
>>>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>     sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>     -- 
>>     Daniel-Constantin Mierla
>>     http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>>     Book: SIP Routing With Kamailio -http://www.asipto.com
>>     Kamailio Advanced Training, Sep 28-30, 2015, in Berlin -http://asipto.com/u/kat
>>
>>
>>     _______________________________________________
>>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
>>     mailing list
>>     sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>
> -- 
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda  -http://www.linkedin.com/in/miconda
> Book: SIP Routing With Kamailio -http://www.asipto.com
> Kamailio Advanced Training, Sep 28-30, 2015, in Berlin -http://asipto.com/u/kat

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151005/65652e8a/attachment.html>


More information about the sr-users mailing list