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
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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=09c9abb0... http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1970f091...
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@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@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
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@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@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@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
-
Daniel-Constantin Mierla -
laura testi