[OpenSIPS-Users] No private memory error

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
20 - 24 September 2010, Frankfurt, Germany
www.voice-system.ro