[prev in list] [next in list] [prev in thread] [next in thread]
List: openser-users
Subject: Re: [SR-Users] Kamailio not responding in heavy load
From: Henning Westerholt <hw () gilawa ! com>
Date: 2022-08-17 9:40:04
Message-ID: AM6PR05MB5409983EF1C612384F5137A0BF6A9 () AM6PR05MB5409 ! eurprd05 ! prod ! outlook ! com
[Download RAW message or body]
Hello,
I'd suggest have a look to the PostgreSQL database, like the processlist of the \
current running queries. You can also do some network tracing for the SQL queries \
that are used, or look to the slow query log (don't know how this is called in \
PostgreSQL).
Then start some optimization, e.g. use some caching or similar, to get better \
throughput.
Cheers,
Henning
--
Henning Westerholt - https://skalatan.de/blog/
Kamailio services - https://gilawa.com<https://gilawa.com/>
From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Ali Taher
Sent: Wednesday, August 17, 2022 11:34 AM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] Kamailio not responding in heavy load
Hello all,
I'm using sqlops module to connect to postgres and get the routing of calls from \
postgresql database.
In order to troubleshoot issues in case they happened, I added each call details to \
Kamailio log.
In some cases, when there is heavy traffic load (around 100 cps), I don't find some \
calls in Kamailio log, knowing that I can find them on the switch log (switch sending \
the invite packets to Kamailio).
When checking the traces on these calls taken by the switch, it's clear that Kamailio \
is not responding to the invite packets sent by the switch. It could be because there \
are no available process to handle the call at this moment (I have set fork=14)
Is it possible to check if there are calls pending in the queue?
Regards,
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span \
style="mso-fareast-language:EN-US">Hello,<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">I’d \
suggest have a look to the PostgreSQL database, like the processlist of the current \
running queries. You can also do some network tracing for the SQL queries that are \
used, or look to the slow query log (don’t know how this is called in \
PostgreSQL). <o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Then start \
some optimization, e.g. use some caching or similar, to get better \
throughput.<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Cheers,<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <div>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">-- <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Henning \
Westerholt – </span><span style="mso-fareast-language:EN-US"><a \
href="https://skalatan.de/blog/"><span \
lang="EN-GB">https://skalatan.de/blog/</span></a></span><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB" style="mso-fareast-language:EN-US">Kamailio services – \
</span><span style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span \
lang="EN-GB">https://gilawa.com</span></a></span><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p></o:p></span></p> </div>
<p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b> sr-users \
<sr-users-bounces@lists.kamailio.org> <b>On Behalf Of </b>Ali Taher<br>
<b>Sent:</b> Wednesday, August 17, 2022 11:34 AM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List \
<sr-users@lists.kamailio.org><br> <b>Subject:</b> [SR-Users] Kamailio not \
responding in heavy load<o:p></o:p></p> </div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">Hello \
all,<o:p></o:p></span></p> <p class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-US"><o:p> </o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US">I’m using sqlops module to \
connect to postgres and get the routing of calls from postgresql \
database.<o:p></o:p></span></p> <p class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-US"><o:p> </o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US">In order to troubleshoot issues in case \
they happened, I added each call details to Kamailio log.<o:p></o:p></span></p> <p \
class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-US"><o:p> </o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US">In some cases, when there is heavy \
traffic load (around 100 cps), I don’t find some calls in Kamailio log, knowing \
that I can find them on the switch log (switch sending the invite packets to \
Kamailio).<o:p></o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">When checking the \
traces on these calls taken by the switch, it’s clear that Kamailio is not \
responding to the invite packets sent by the switch. It could be because there are no \
available process to handle the call at this moment (I have set \
fork=14)<o:p></o:p></span></p> <p class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-US"><o:p> </o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US">Is it possible to check if there are \
calls pending in the queue?<o:p></o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-US">Regards,<o:p></o:p></span></p> </div>
</body>
</html>
__________________________________________________________
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
--===============0312302557==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic