Re: [SR-Users] usrloc db_mode 2 and dropped contacts

On Mar 7, 2020, at 3:19 PM, Henning Westerholt <hw(a)skalatan.de> wrote: Hi Alex, the db_timer_clean is just an additional mechanism to clean-up expired records. Like if you get some errors from time to time in the DB connection, and some deletes are not correctly processed on the DB. Then some stale records should be left in the DB, and you can use this one to clean up. Normally it should be not necessary, as Kamailio will synchronize it just by the normal timer. From the source: /*! * \brief Write-back timer, used for WRITE_BACK db_mode * * Write-back timer, used for WRITE_BACK db_mode. Process * all contacts from the record, delete expired ones from the DB. * Furthermore it updates changed contacts, and also insert new * ones in the DB. * \param _r processed record */ static inline void wb_timer(urecord_t* _r) {..} About the first question, why some registrations are missing in the DB - this needs to be investigated more closely. As a workaround you could try (as already suggested) to use the INSERT instead of UPDATE module parameter, e.g. with db_check_update. Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com -----Original Message----- From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Alex Balashov Sent: Friday, March 6, 2020 7:31 PM To: sr-users(a)lists.kamailio.org Subject: Re: [SR-Users] usrloc db_mode 2 and dropped contacts And another question that goes along with this: Do I need `db_timer_clean` to make db_mode 2 work as expected? A reasonable person would conclude from the documentation for `timer_interval` and `db_mode 2` ... "2 - Write-Back scheme. This is a combination of previous two schemes. All changes are made to memory and database synchronization is done in the timer. The timer deletes all expired contacts and flushes all modified or new contacts to database." "The module uses a timer to delete expired contacts, synchronize with database and other tasks, that need to be run periodically." ... that deletion of expired contacts is propagated to underlying DB storage (passed through the logic of whichever db_mode) in the form of periodic deletions of expired contacts. It appears not to be enabled by default. DELETE statements appear to be issued periodically from usrloc even though it's not enabled. So, what's that setting for? When and why do I need it? -- Alex -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users