I should also note that I also changed this line in the lcr_mod.c to account for the amount of rows that I have in the lcr database table.
Original #define MAX_NO_OF_LCRS 256
Changed to #define MAX_NO_OF_LCRS 32000
Stagg
On Apr 30, 2009, at 9:46 AM, Henning Westerholt wrote:
On Donnerstag, 30. April 2009, Stagg Shelton wrote:
I am working to get LCR implemented on my migration system, and
when I
try to start kamailio i find the below information in the log file, and kamailio fails to start. My lcr table has 30667 rows in it.
Hi Stagg,
in cr we had the same issue in the past, we solved it by partioning the data loading in the module code. Not sure if this is also possible to do in LCR, probably Juha know here more. What probably happens is that the lcr module try to load all data at once, and storing it temporarly in private memory.
I have read about changing the config.h file to increase the private memory, but my question is how much should I allocate. I forsee going up to more than 200,000 routes within the next 12 month
period.
ERROR:db_mysql:db_mysql_convert_rows: error while converting row
#2808
This suggest that it needs about 1MB of memory to load 2800 rules. So for 200k rules you'd need about 72 MB private memory, but not sure if its can be calculated this way.
Cheers,
Henning