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

[laura testi]

Tested the new pua module with the patch. the fetch_rows works!

Thank you very much!


Best Regards,
Laura

On Thu, Dec 1, 2011 at 2:01 PM, laura testi <lau.testi at gmail.com> wrote:
> 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
>>