23 Dec
2022
23 Dec
'22
8:17 a.m.
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
23 Dec
23 Dec
12:57 p.m.
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 : *sergio.charrua(a)voip.pt <sergio.charrua(a)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(a)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(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to
the sender!
Edit mailing list options or unsubscribe:
700
days inactive
700
days old
1 comments
2 participants
participants (2)
-
Sergio Charrua -
Waqar 40