[OpenSIPS-Users] FW: CDRTool - memory problem

[Daniel Conte Laguna]

In reloadRatingTables.php file I found this:
if (!reloadRatingEngineTables()) {                                                                                                                        die("Error: Cannot connect to network Rating Engine $errstr ($errno). \n");                                                               } else {                                                                                                                                              printf ("Rating tables will be reloaded during next normalization. See syslog for more information. \n",$RatingEngine["socketIP"],$RatingEngine["socketPort"]);                                                                                                                                 } 
So the memory have to be released after the normalization.But for some reason the normalization does not release the memory, creating a memory problem when you work with large tables. And if during the normalization is detected any error in the tables, in this case the memory is released, so I think there are a mistake into nomalization process because this release of memory have to be also when reload rating tables, not only when some error is detected.
Daniel

From: danielconte85 at hotmail.com
To: users at lists.opensips.org
Date: Tue, 20 Mar 2012 09:01:25 +0100
Subject: [OpenSIPS-Users] FW:  CDRTool - memory problem










I detected this problem when I was using a table with 150000 records in billing rates history, and 70000 records in destinations table. But I would like use without problems tables with 300000 records or more and i think to put more memory in my server doesn't mean to solve the error. 
With this data tables the server works without problems at the beginning, using 500MB of memory. But when I make the reload, the rating engine doesn't release the memory that used as before so the others applications work slower. In my opinion the rating engine doesn't need keep this memory.
Daniel

From: ag at ag-projects.com
Date: Mon, 19 Mar 2012 19:50:00 +0100
To: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] CDRTool - memory problem



Can you describe more accurately what 'large tables of data' means?
Adrian
On Mar 19, 2012, at 6:31 PM, Daniel Conte Laguna wrote:Hello everybody,
I'm working with CDRTool and I found a problem of memory.I have to work with large tables of data, which increases the memory usage during the execution.
My problem appears when I make any change in the destination table, after this, is enabled Reload rating tables in red. 
After reload of rating tables, ratingengine.php start to use large amount of memory that never be release, causing speed problems on my server. This memory is released only when I stop manually CDRTool. 
Is the problem perhaps here;
function reloadRatingEngineTables () {.........
 // init CDR datasource$CDR_class  = $DATASOURCES[$RatingEngine['cdr_source']]['class'];$CDRS = new $CDR_class($RatingEngine['cdr_source']);//  is the following line necessary - is memcache still used ???
$CDRS->CacheDestinations();
Best regards and thanksDaniel Conte_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 		 	   		  
 		 	   		  

_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120321/d4e6f7b0/attachment.htm>