<div dir="ltr">Hello!<div><br></div><div>Sometimes presence server stops sending SIP NOTIFY events with syslog output below (after Kamailio restarting everything is restored):<br></div><div><br></div><div>Jul 27 17:07:28 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:28 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br>Jul 27 17:07:29 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:29 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br>Jul 27 17:07:37 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:37 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br>Jul 27 17:07:37 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:37 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br>Jul 27 17:07:41 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:41 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br>Jul 27 17:07:41 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: db_mysql [km_dbase.c:602]: db_mysql_start_transaction(): transaction already started<br>Jul 27 17:07:41 prd-sip-presence-2 /usr/sbin/kamailio[4838]: ERROR: kazoo [kz_pua.c:131]: kz_pua_update_presentity(): in start_transaction<br><div><br></div><div>Where is a possible source of the problem?</div><div><br></div><div>Kamailio 5.1.2 with MySQL<br></div><div><br></div><div>modparam("presence", "db_url", DBURL)<br>modparam("presence", "subs_db_mode", 3)<br>modparam("presence", "timeout_rm_subs", 0)<br>modparam("presence", "expires_offset", 0)<br>modparam("presence", "max_expires", 1800)<br>modparam("presence", "db_update_period", 30)<br>modparam("presence", "clean_period", 180)<br>modparam("presence", "send_fast_notify", 1)<br>modparam("presence", "pres_htable_size", 32)<br>modparam("presence", "subs_htable_size", 32)<br>modparam("presence", "publ_cache", 0)<br>modparam("presence", "notifier_processes", 0)<br></div><div><br></div><div>modparam("presence_xml", "db_url", DBURL)<br>modparam("presence_xml", "force_active", 1)<br>modparam("presence_xml", "integrated_xcap_server", 0)<br>modparam("presence_xml", "disable_presence", 1)<br>modparam("presence_xml", "disable_winfo", 1)<br><br>modparam("presence_dialoginfo", "force_single_dialog", 1)<br>modparam("presence_dialoginfo", "force_dummy_dialog", 1)<br><br>modparam("dialog", "dlg_flag", 4)<br>modparam("dialog", "db_mode", 0)<br>modparam("dialog", "dlg_match_mode", 1)<br><br></div><div>modparam("kazoo", "node_hostname", NODE_HOSTNAME)<br></div><div>modparam("kazoo", "amqp_connection", "AMQP_URL")<br>modparam("kazoo", "pua_mode", 1)<br>modparam("kazoo", "db_url", DBURL)<br>modparam("kazoo", "amqp_consumer_processes", 10)<br>modparam("kazoo", "amqp_max_channels", 50)<br></div><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><br><div><div>BR,</div><div>Denys Pozniak<br></div><div><br></div><div><br></div></div></div></div></div></div>