Thank you Bogdan,<div><br></div><div>I 'm going to try with Drouting.</div><div><br></div><div>Regards,</div><div><br></div><div>Eric<br><br><div class="gmail_quote">2010/8/16 Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Eric,<br>
<br>
I suggest you should the Drouting module as it has a better support for<br>
loading large amounts of data from DB . See:<br>
<br>
<a href="http://www.opensips.org/html/docs/modules/1.6.x/drouting.html#id227321" target="_blank">http://www.opensips.org/html/docs/modules/1.6.x/drouting.html#id227321</a><br>
<br>
Regards,<br>
<font color="#888888">Bogdan<br>
</font><div><div></div><div class="h5"><br>
Eric LI DESTRI wrote:<br>
> Hello,<br>
><br>
> I'm actually confused with carrier route module.<br>
><br>
> When i'm reloading carrierroute with "opensipsctl cr reload" opensips<br>
> crashed with :<br>
><br>
><br>
><br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:core:db_allocate_rows: no memory left<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:db_mysql:db_mysql_convert_rows: no private memory left<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:db_mysql:db_mysql_convert_result: error while converting rows<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:db_mysql:db_mysql_store_result: error while converting result<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:core:db_do_query: error while storing result<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:carrierroute:load_route_data: failed to query database.<br>
> Aug 13 11:54:07 gw-voip-2-cbv1 /usr/sbin/opensips[16328]:<br>
> ERROR:carrierroute:prepare_route_tree: could not load routing data<br>
><br>
><br>
> Because of that I must restart opensips to take changes into account !<br>
><br>
> I have 11000 entries in carrier route and i already have increased<br>
> private memory (x4 from the default value).<br>
><br>
> The problem was occuring rarely at the beginning but with the<br>
> increasing number of entries it is now always occuring.<br>
><br>
> I'm using latest release of the opensips 1.5.x branch<br>
><br>
> Is this problem already known ? i have not seen exactly the same on<br>
> this ML.<br>
><br>
> I don't think increasing again private mem is the good solution. Do<br>
> you have an idea ?<br>
><br>
> Thank you !<br>
><br>
> Eric<br>
</div></div><div><div></div><div class="h5">> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
<br>
--<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Bootcamp<br>
20 - 24 September 2010, Frankfurt, Germany<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>