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

2015-10-09 Thread Asgaroth
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 Log: Oct 9 11:06:27 kam_proxy01[20890]: ERROR: db_sqlite [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: constraint fail

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

2015-10-06 Thread Maciej Marczyński
Great, please let me know if you find anything or if you need any further information. Regards, Maciej 2015-10-06 8:03 GMT+02:00 Daniel-Constantin Mierla : > OK -- it is clear now where to look in the code, I will do it as soon as I > get a chance. > > Daniel > > > On 05/10/15 20:09, Maciej Marc

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

2015-10-05 Thread Daniel-Constantin Mierla
OK -- it is clear now where to look in the code, I will do it as soon as I get a chance. Daniel On 05/10/15 20:09, Maciej Marczyński wrote: > 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 no

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

2015-10-05 Thread Maciej Marczyński
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

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

2015-10-05 Thread Daniel-Constantin Mierla
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(): c

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

2015-10-05 Thread Maciej Marczyński
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,dom

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

2015-10-04 Thread Daniel-Constantin Mierla
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,

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

2015-10-03 Thread Maciej Marczyński
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