Thanks Alex, <br>that is a big Problem for us. We have usually about 300 calls running through kamailio at the same time..and kamailio does not process all of them while DELETE procedure is running. Probably could you recommend how to deal with this? we still need to remove some old data from the table time to time and need services not to be interrupted. Later I will put an index on the time column in acc, that should help to reduce the time for executing a query. But probably is there another solution?<br>
<br><div class="gmail_quote">On Tue, May 31, 2011 at 3:54 PM, Alex Balashov <span dir="ltr"><<a href="mailto:abalashov@evaristesys.com">abalashov@evaristesys.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">On 05/31/2011 09:53 AM, Alex Balashov wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
On 05/31/2011 09:52 AM, Borin wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Does that mean that if kamailio does not manage to write acc record for<br>
any reason it does not forward that INVITE/200ok?<br>
</blockquote>
<br>
It should forward the requests. But SIP worker threads doing the<br>
forwarding will block on database requests that block due to locks, so<br>
there might be delay.<br>
</blockquote>
<br></div>
Also, there is a relatively small number of SIP worker threads. If all of them block on database operations, further requests may not be processed in time.<div><div></div><div class="h5"><br>
<br>
-- <br>
Alex Balashov - Principal<br>
Evariste Systems LLC<br>
260 Peachtree Street NW<br>
Suite 2200<br>
Atlanta, GA 30303<br>
Tel: +1-678-954-0670<br>
Fax: +1-404-961-1892<br>
Web: <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a><br>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</div></div></blockquote></div><br>