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

[Daniel-Constantin Mierla]

Hello,

just committed the addition to pua module -- there are two patches in 
git master branch:

http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=09c9abb0f7907132d9afee4580f0475a2e46cadc
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1970f091041474bf6633e6b4d90e753021d0cfff

There is a new module parameter fetch_rows, default value is 500 (not 
yet documented, I'll do it later, have to go out for a while).

Can you try and see if all starts fine now?

Thanks,
Daniel

On 11/30/11 11:38 AM, Daniel-Constantin Mierla 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