[sr-dev] [SR-Users] kamailio fail to start when there are many records in DB in location or in pua table

[laura testi]

Thank you very much Daniel!

I will try the patch.


Best Regards,
Laura

On Wed, Nov 30, 2011 at 11:38 AM, Daniel-Constantin Mierla
<miconda at gmail.com> wrote:
> Hello,
>
> many modules have a parameter named fetch_rows that is doing pretty much
> what you are looking for. pua seems not to have it, considering the amount
> of records that can be there, it is indeed a limitation. I will add the
> functionality in the near future.
>
> Cheers,
> Daniel
>
>
> On 11/30/11 10:01 AM, laura testi wrote:
>>
>> Hi all,
>>    when there many records in DB tables like location(usrloc use write
>> back mode), pua etc, kamailio fail to start by complaining "no pkg
>> memory left" when try to load (restore) all records from DB to
>> hashtable of location/pua. The share momory are allocated enough for
>> the hashtable, but the default compilation of the PKG_MEMORY_SIZE is
>> 4MB, which allow only restore several thousands records. I know I can
>> increase the PKG_MEMORY_SIZE, but anyway there is a limitation which
>> may fail to restore all records from DB during the startup of kamailio
>> if it reach the limit of the number of records in DB.
>>
>> Is there anyway to reload the hashtable from table by doing query n
>> rows a time and loop until non more result from DB? this will avoid
>> the kamailio startup problem when there are many records in hashtable
>> which are save also in DB.
>>
>>
>> Thank you very much in advanced!
>>
>> Laura
>>
>> _______________________________________________
>> 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
>
>
> --
> Daniel-Constantin Mierla -- http://www.asipto.com
> Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat
> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>