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@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
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
