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 <http://www.voip.pt/>* Tel.: +351 <callto:+351+91+104+12+66>21 130 71 77 Email : *[email protected] <[email protected]>* 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 <[email protected]> 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 [email protected] > Important: keep the mailing list in the recipients, do not reply only to > the sender! > Edit mailing list options or unsubscribe: >
__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to [email protected] Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
