[OpenSIPS-Users] No private memory error

[Eric LI DESTRI]

Thank you Bogdan,

I 'm going to try with Drouting.

Regards,

Eric

2010/8/16 Bogdan-Andrei Iancu <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
> > 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
> 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/20100817/b31af8ff/attachment.htm