[SR-Users] acc Locks

[Borin]

Thanks Alex,
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?

On Tue, May 31, 2011 at 3:54 PM, Alex Balashov <abalashov at evaristesys.com>wrote:

> On 05/31/2011 09:53 AM, Alex Balashov wrote:
>
>> On 05/31/2011 09:52 AM, Borin wrote:
>>
>>  Does that mean that if kamailio does not manage to write acc record for
>>> any reason it does not forward that INVITE/200ok?
>>>
>>
>> It should forward the requests. But SIP worker threads doing the
>> forwarding will block on database requests that block due to locks, so
>> there might be delay.
>>
>
> 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.
>
>
> --
> Alex Balashov - Principal
> Evariste Systems LLC
> 260 Peachtree Street NW
> Suite 2200
> Atlanta, GA 30303
> Tel: +1-678-954-0670
> Fax: +1-404-961-1892
> Web: http://www.evaristesys.com/
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110531/b4336aa7/attachment.htm>