[OpenSIPS-Users] No private memory error

[Bogdan-Andrei Iancu]

OK, if you need help, just let me know.

Regards,
Bogdan

Eric LI DESTRI wrote:
> Thank you Bogdan,
>
> I 'm going to try with Drouting.
>
> Regards,
>
> Eric
>
> 2010/8/16 Bogdan-Andrei Iancu <bogdan at voice-system.ro 
> <mailto:bogdan at voice-system.ro>>
>
>     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 <mailto: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 <http://www.voice-system.ro>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto: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
>   


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