Hi Henning So I tested. Yesterday I send traffic, around 400 concurrent dialogues over the two DMQ synced instances and stopped the traffic in the evening waiting until today to make sure all calls have ended. None of the two instances was restarted during that testing. I have not seen memory related error messages in the logs. So I guess SHM=1024 is large enough now. This morning: # kamcmd dlg.stats_active { starting: 0 connecting: 0 answering: 0 ongoing: 0 all: 0 } So no more running calls on any of the two instances. But when I look in the local mysql database used to store dialogues: Instance 2: mysql> select count(*) from dialog; select count(*) from dialog_vars; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) +----------+ | count(*) | +----------+ | 271 | +----------+ 1 row in set (0.00 sec) Instance 1: mysql> select count(*) from dialog; select count(*) from dialog_vars; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) +----------+ | count(*) | +----------+ | 472 | +----------+ 1 row in set (0.00 sec) So still, quite some variables left in dialog_vars and not the same count. What could be cause this issue? Mit freundlichen Grüssen -Benoît Panizzon- -- I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________

Hello, thanks for the additional information. It should certainly expire the dialog after some time, even if it's synchronized from DMQ to the first instance. Maybe you can try it with a small dialog timeout variable in a test setup, if possible. If its not expiring, an issue could be opened about it. Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com -----Original Message----- From: Benoit Panizzon <benoit.panizzon(a)imp.ch> Sent: Tuesday, November 15, 2022 3:07 PM To: Henning Westerholt <hw(a)gilawa.com> Cc: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Subject: Re: [SR-Users] dialog_vars accumulating in database? Hmm, I have a suspicion how this happens... I could more or less reproduce the issue: 2 Kamailio instances, synced with DMQ. Both store dialog_vars in a local database for performance. While a dialog is ongoing, stop instance 2. This instance 2 probably has stored dialog information in it's local database. End the dialog. Instance 1 propperly removes dialog_vars from it's local database and forgets about it. Restart Instance 2. No longer existing dialog data from instance 2 is getting DMQ synced to Instance 1. This dialog is sticking around on both instances and never expiring. Mit freundlichen Grüssen -Benoît Panizzon- -- I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________