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

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(a)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(a)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 >