[BUG] active_watchers entries not removed on timeout or expiration from mysql table

[gostkov]

Hello! I use presence module for BLF. I have caught a problem, sometimes records are not deleted from the active_watchers table.
Situation 1:

1. The phone send SUBSCRIBE - opensips save info in the active_watchers - everyting is good.
2. I turn off the phone, turn on, it send new SUBSCRIBE, and opensips save new record in the active_watchers table. And old record will store while I not remove them.
   I saw similar issue in kamailio [presence] active_watchers entries not removed on timeout or expiration (db only mode) kamailio/kamailio#3074

Situation 2:
Some phones send new the SUBSCRIBE request with new call-id everytime and as a consequence active_watchers is growing.

This is my presence configuration:

modparam("presence", "cluster_id", 1)
modparam("presence", "cluster_federation_mode", "full-sharing")
modparam("presence", "mix_dialog_presence", 1)
modparam("presence", "db_url", "mysql://user:password@ip/opensips")
modparam("presence", "db_update_period", 10)
modparam("presence", "fallback2db", 1)
modparam("presence", "clean_period", 10)
modparam("presence", "cluster_pres_events" ,"presence , dialog;sla")
modparam("presence", "waiting_subs_daysno", 1)
modparam("presence", "max_expires_subscribe", 4800)

OpenSIPS version

version: opensips 3.4.9 (x86_64/linux)
flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, HP_MALLOC, DBG_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll, sigio_rt, select.
git revision: cd02af8d9
main.c compiled on  with gcc 12

OS/environment information

• Operating System: Debian 12.7
• OpenSIPS installation: apt.opensips.org bookworm 3.4-releases

[github-actions]

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.

[gostkov]

no feedback :(

[github-actions]

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.