Re: [OpenSIPS-Users] nathelper memory error

2011-06-27 Thread Dovid Bender
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 
  To: users@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

--


  ___
  Users mailing list
  Users@lists.opensips.org
  http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] nathelper memory error

2011-06-27 Thread 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:bog...@opensips.org
*To:* users@lists.opensips.org mailto:users@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

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] nathelper memory error

2011-06-24 Thread Bogdan-Andrei Iancu

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

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users