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:[email protected]>
*To:* [email protected] <mailto:[email protected]>
*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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
