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 PrattelnFax +41 61 826 93 01 Schweiz Web http://www.imp.ch __ __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] dialog_vars accumulating in database?
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 PrattelnFax +41 61 826 93 01 Schweiz Web http://www.imp.ch __ __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] dialog_vars accumulating in database?
Hi Henning > does it happens during run-time, or maybe after a few restarts of the > server? Normally they should be removed if the dialog ended or > expired. Thank you. I have to observe this more closely. As active development is performed, restarts are performed frequently, even while calls-tests are running. I just wanted to make sure there is not need to specifically clear dialog variables at the end of a dialogue. -- Mit freundlichen Grüssen -Benoît Panizzon- @ HomeOffice und normal erreichbar -- I m p r o W a r e A G-Leiter Commerce Kunden __ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 PrattelnFax +41 61 826 93 01 Schweiz Web http://www.imp.ch __ __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] dialog_vars accumulating in database?
Hello, does it happens during run-time, or maybe after a few restarts of the server? Normally they should be removed if the dialog ended or expired. Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com -Original Message- From: sr-users On Behalf Of Benoit Panizzon Sent: Tuesday, November 8, 2022 11:56 AM To: Kamailio (SER) - Users Mailing List Subject: [SR-Users] dialog_vars accumulating in database? Hi List I noticed that the database is accumulating entries on dialog_vars. I don't know when and why this is happening. Are there any special measures that have to be taken like making sure to unset variables after using them to prevent this? Or is this something which is supposed to happen when kamailio is restarted? 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 PrattelnFax +41 61 826 93 01 Schweiz Web http://www.imp.ch __ __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] dialog_vars accumulating in database?
Hi List I noticed that the database is accumulating entries on dialog_vars. I don't know when and why this is happening. Are there any special measures that have to be taken like making sure to unset variables after using them to prevent this? Or is this something which is supposed to happen when kamailio is restarted? 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 PrattelnFax +41 61 826 93 01 Schweiz Web http://www.imp.ch __ __ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users