[SR-Users] [pua] Question to DB Mode 0
Daniel-Constantin Mierla
miconda at gmail.com
Mon Oct 5 15:23:01 CEST 2015
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 <mailto:sip%3Aaccount2 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 <mailto: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 <mailto: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
> <mailto: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/bdcb6946/attachment.html>
More information about the sr-users
mailing list