<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi there</div><div><br data-mce-bogus="1"></div><div>My config is a primary:secondary DNS srv failover Kamailio 5.2 setup using DMQ for syncing Location, Presence, HTable etc.</div><div><br data-mce-bogus="1"></div><div>For Presence db_mode set to 0 on both servers.</div><div><br data-mce-bogus="1"></div><div>This works fine on the primary server but on the secondary server I get repeated mysql deadlock errors. I seem to be missing a config setting to turn off db_mode fully for presence but I cant see where. Error seems to occur on message-summary updates from master that are being replicated to slave via DMQ.</div><div><br data-mce-bogus="1"></div><div>Mar 08 13:52:39 /usr/sbin/kamailio[17493]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query<br>Mar 08 13:52:39 /usr/sbin/kamailio[17493]: ERROR: db_mysql [km_dbase.c:714]: db_mysql_end_transaction(): executing raw_query<br>Mar 08 13:52:39 /usr/sbin/kamailio[17493]: ERROR: presence [presentity.c:1299]: update_presentity(): in end_transaction<br>Mar 08 13:52:40 /usr/sbin/kamailio[17493]: ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Deadlock found when trying to get lock; try restarting transaction (1213)<br></div><div><br data-mce-bogus="1"></div><div>I am using the following presence related modules</div><div><br data-mce-bogus="1"></div><div>loadmodule "presence.so"<br>loadmodule "presence_mwi.so"<br>loadmodule "presence_xml.so"<br>loadmodule "pua.so"<br>loadmodule "rls.so"<br>loadmodule "xcap_server.so"<br>loadmodule "xcap_client.so"</div><div><br data-mce-bogus="1"></div><div>params are set as below</div><div><br data-mce-bogus="1"></div><div><br>loadmodule "presence.so"<br>loadmodule "presence_mwi.so"<br>loadmodule "presence_xml.so"<br>loadmodule "pua.so"<br>loadmodule "rls.so"<br>loadmodule "xcap_server.so"<br>loadmodule "xcap_client.so"<br><br>params are set as below with PRESENCEDBMODE set to 0 on both servers.<br><br>#!ifdef WITH_PRESENCE<br># ----- presence params -----<br>modparam("presence", "db_url", DBURL)<br>modparam("presence", "db_update_period", 5)<br>modparam("presence", "server_address", "sip:myserver.com")<br>modparam("presence", "subs_db_mode", PRESENCEDBMODE)<br>modparam("presence", "send_fast_notify", 1)<br>modparam("presence", "timeout_rm_subs", 0)<br>modparam("presence", "db_table_lock_type", 0)<br>modparam("presence", "notifier_processes", 3)<br>modparam("presence", "local_log_level", 3)<br>modparam("presence", "publ_cache", 1)<br>#!ifdef WITH_DMQ<br>modparam("presence", "enable_dmq", 1)<br>#!else<br>modparam("presence", "enable_dmq", 0)<br>#!endif<br><br>#!ifdef WITH_BUDDY<br># ----- presence_xml params -----<br>modparam("presence_xml", "db_url", DBURL)<br>modparam("presence_xml", "passive_mode", 1)<br>modparam("presence_xml", "integrated_xcap_server", 1)<br>modparam("presence_xml", "xcap_server", "https://xcap.myserver.com/xcap-root")<br>modparam("presence_xml", "force_dummy_presence", 1)<br>modparam("pua", "db_url", DBURL)<br>modparam("pua", "db_mode", PRESENCEDBMODE)<br>modparam("pua", "db_table_lock_write", 0)<br>modparam("pua", "check_remote_contact", 0)<br><br>modparam("rls", "db_url", DBURL)<br>modparam("rls", "db_mode", PRESENCEDBMODE)<br>modparam("rls", "notifier_processes", 2)<br>modparam("rls", "integrated_xcap_server", 1)<br>modparam("rls", "xcap_root", "https://xcap.myserver.com/xcap-root")<br>modparam("rls", "server_address", "sip:rls@myserver.com")<br>modparam("rls", "outbound_proxy", "sip:myserver.com")<br>modparam("rls", "disable_remote_presence", 0)<br>modparam("rls", "max_backend_subs", 1000)<br>modparam("rls", "to_presence_code", 10)<br>modparam("rls", "rls_event", "presence")<br>modparam("rls", "rls_event", "presence.winfo")<br>modparam("xcap_server", "db_url", DBURL)<br>modparam("xcap_server", "directory_scheme", -1)<br>modparam("xcap_server", "xcap_root", "/xcap-root/")<br>modparam("xcap_client", "db_url", DBURL)<br>modparam("xcap_client", "query_period", 50)<br></div><div><br data-mce-bogus="1"></div><div>Any ideas?</div><div><br data-mce-bogus="1"></div><div>thanks</div><div>Paul</div></div></body></html>