[sr-dev] Re: [kamailio/kamailio] kamailio mariadb error lock table active_watcher (#2805)

After the Kamailio code investigation found a request to the `active_watchers` table related to “presence“ module. I think required this module update. Related function [get_subs_db](https://github.com/kamailio/kamailio/blob/16e6bfe4ed950851807c… called from [get_subs_dialog](https://github.com/kamailio/kamailio/blob/16e6bfe4ed950851…. According this code ``` if(pres_subs_dbmode == DB_ONLY) { if(get_subs_db(pres_uri, event, sender, &s_array, &n) < 0) { LM_ERR("getting dialogs from database\n"); goto error; } } else { hash_code = core_case_hash(pres_uri, &event->name, shtable_size); lock_get(&subs_htable[hash_code].lock); ``` To avoid call `get_subs_db` required do not use `pres_subs_dbmode == DB_ONLY`. We changed `subs_db_mode` to 2 and error message do not apper more. ``` modparam("presence", "subs_db_mode", 2) ``` In our use case database is used only by one Kamailio server and this approach works for us. -- Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/2805#issuecomment-1500820783 You are receiving this because you are subscribed to this thread. Message ID: &lt;kamailio/kamailio/issues/2805/1500820783(a)github.com&gt;