[OpenSIPS-Users] nathelper memory error

[Bogdan-Andrei Iancu]

Hi Dovid,

yeah, that will be a bit too much for a single query - as said, in db 
mode 3 (DB ONLY), each time there is a need for NAT pinging, all 
contacts from DB are loaded. This query does not have "fetch support" 
(progressive loading into memory), so it loads everything at once. If 
you cannot use a different DB mode , please open a bug report on this.

Regards,
Bogdan

On 06/27/2011 10:30 AM, Dovid Bender wrote:
> Bogdan,
> We have on average 2500-2600 registerd users. Once it goes over 
> 2800-2900 we start seeing the error.
> Regards,
> Dovid
> ----- Original Message -----
>
>     *From:* Bogdan-Andrei Iancu <mailto:bogdan at opensips.org>
>     *To:* users at lists.opensips.org <mailto:users at lists.opensips.org>
>     *Sent:* Friday, June 24, 2011 17:43
>     *Subject:* Re: [OpenSIPS-Users] nathelper memory error
>
>     Hi Dovid,
>
>     db_mode 3 has some inefficient way of doing things, like NAT
>     pinging - in order to do it, it has to query in DB for all nated
>     records - probably in your case, you have too many registered
>     users for a single query to handle . How many records do you
>     actually have ?
>
>     Regards,
>     Bogdan
>
>     On 06/15/2011 05:53 AM, Dovid Bender wrote:
>>     Hi,
>>     We are using OpenSIPs (opensips-1.4.3-tls yes I know we should
>>     upgrade...) and it seems that ever since we set db_mode to 3 we
>>     started getting the erros below:
>>     Jun 14 20:12:14 peter /sbin/opensips[4434]:
>>     ERROR:db_mysql:db_mysql_convert_rows: no private memory left
>>     Jun 14 20:12:15 peter /sbin/opensips[4434]:
>>     ERROR:nathelper:nh_timer: out of pkg memory
>>     Jun 14 20:12:16 peter /sbin/opensips[4434]:
>>     ERROR:nathelper:nh_timer: out of pkg memory
>>     Jun 14 20:12:20 peter /sbin/opensips[4434]:
>>     ERROR:nathelper:nh_timer: out of pkg memory
>>     Jun 14 20:12:51 peter /sbin/opensips[4434]:
>>     ERROR:nathelper:nh_timer: out of pkg memory
>>     We have fork set to 24 and modparam( "usrloc", "fetch_rows", 500 ).
>>     TIA.
>>     Dovid
>

-- 
Bogdan-Andrei Iancu
OpenSIPS solutions and "know-how"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110627/63404a8a/attachment.htm>