Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
gostkov opened this issue Nov 14, 2024 · 0 comments
Open

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

gostkov opened this issue Nov 14, 2024 · 0 comments

Comments

@gostkov
Copy link

gostkov commented Nov 14, 2024

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@gostkov