Hi!
assuming you're using Mysql, you can execute in Mysql CLI:
> SHOW FULL PROCESSLIST\G

This will list all queries running at that moment, and who is executing the query.
Depending on the query, if you are using table locks, this is normal behaviour.
But I do not think this is a Kamailio issue.

Sérgio Charrua


www.voip.pt
Tel.: +351 21 130 71 77

Email : sergio.charrua@voip.pt

This message and any files or documents attached are strictly confidential or otherwise legally protected. 

It is intended only for the individual or entity named. If you are not the named addressee or have received this email in error, please inform the sender immediately, delete it from your system and do not copy or disclose it or its contents or use it for any purpose. Please also note that transmission cannot be guaranteed to be secure or error-free.

 

 





On Fri, Dec 23, 2022 at 5:40 AM Waqar 40 <waqarbhai796@gmail.com> wrote:
Dear All,

I have three Kamailio in my production environment and I have written some code in Kamailio.cfg using SqlOps to insert data into the database on another remote server for every call. I deployed the code in one of the Kamailio and it inserted data perfectly fine into the database but as soon as I deployed it in the other two Kamailios. All three Kamailio's become unreachable or lagging in asterisk. I don't know if it has anything to do with SqlOps or queries being stuck somewhere as I am receiving logs consistently for every call in Kamailios.
How can I identify if the queries are being stuck somewhere and that is why Kamailio is unreachable or lagging? Calls are not dependent on that database, this I know because even if I stop the mysql service calls will still be dialed. If it is due to the SqlOps, is there any other way to save information on every call without Kamailio being stuck?
Regards
VIcky
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to sr-users-leave@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe: