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