looks like some process starting and not releasing a transaction. i don’t see kz_pua as the origin of the problem.
> On 28 Jul 2020, at 09:25, Denys Pozniak <[email protected]> wrote: > > Hello! > > Sometimes presence server stops sending SIP NOTIFY events with syslog output > below (after Kamailio restarting everything is restored): > > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > > Where is a possible source of the problem? > > Kamailio 5.1.2 with MySQL > > modparam("presence", "db_url", DBURL) > modparam("presence", "subs_db_mode", 3) > modparam("presence", "timeout_rm_subs", 0) > modparam("presence", "expires_offset", 0) > modparam("presence", "max_expires", 1800) > modparam("presence", "db_update_period", 30) > modparam("presence", "clean_period", 180) > modparam("presence", "send_fast_notify", 1) > modparam("presence", "pres_htable_size", 32) > modparam("presence", "subs_htable_size", 32) > modparam("presence", "publ_cache", 0) > modparam("presence", "notifier_processes", 0) > > modparam("presence_xml", "db_url", DBURL) > modparam("presence_xml", "force_active", 1) > modparam("presence_xml", "integrated_xcap_server", 0) > modparam("presence_xml", "disable_presence", 1) > modparam("presence_xml", "disable_winfo", 1) > > modparam("presence_dialoginfo", "force_single_dialog", 1) > modparam("presence_dialoginfo", "force_dummy_dialog", 1) > > modparam("dialog", "dlg_flag", 4) > modparam("dialog", "db_mode", 0) > modparam("dialog", "dlg_match_mode", 1) > > modparam("kazoo", "node_hostname", NODE_HOSTNAME) > modparam("kazoo", "amqp_connection", "AMQP_URL") > modparam("kazoo", "pua_mode", 1) > modparam("kazoo", "db_url", DBURL) > modparam("kazoo", "amqp_consumer_processes", 10) > modparam("kazoo", "amqp_max_channels", 50) > > -- > > BR, > Denys Pozniak > > > _______________________________________________ > Kamailio (SER) - Users Mailing List > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
