[SR-Users] [pua] Question to DB Mode 0
Maciej Marczyński
bamaciej999 at gmail.com
Mon Oct 5 09:29:08 CEST 2015
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
>
> 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
>
> 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 listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://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
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151005/424122de/attachment.html>
More information about the sr-users
mailing list