<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Dovid,<br>
<br>
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.<br>
<br>
Regards,<br>
Bogdan<br>
<br>
On 06/27/2011 10:30 AM, Dovid Bender wrote:
<blockquote
cite="mid:CCDD35C40EB5400BA22EB159F09CA6EA@mypbxmanager.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta content="MSHTML 6.00.6000.17098" name="GENERATOR">
<div><font face="Arial" size="2">Bogdan,</font></div>
<div> </div>
<div><font face="Arial" size="2">We have on average 2500-2600
registerd users. Once it goes over 2800-2900 we start seeing
the error.</font></div>
<div> </div>
<div><font face="Arial" size="2">Regards,</font></div>
<div> </div>
<div><font face="Arial" size="2">Dovid</font></div>
<div> </div>
<div> </div>
<div>----- Original Message ----- </div>
<blockquote style="padding-right: 0px; padding-left: 5px;
margin-left: 5px; border-left: 2px solid rgb(0, 0, 0);
margin-right: 0px;">
<div style="background: none repeat scroll 0% 0% rgb(228, 228,
228); font: 10pt arial;"><b>From:</b> <a
moz-do-not-send="true" title="bogdan@opensips.org"
href="mailto:bogdan@opensips.org">Bogdan-Andrei Iancu</a> </div>
<div style="font: 10pt arial;"><b>To:</b> <a
moz-do-not-send="true" title="users@lists.opensips.org"
href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>
</div>
<div style="font: 10pt arial;"><b>Sent:</b> Friday, June 24,
2011 17:43</div>
<div style="font: 10pt arial;"><b>Subject:</b> Re:
[OpenSIPS-Users] nathelper memory error</div>
<div><br>
</div>
Hi Dovid,<br>
<br>
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 ?<br>
<br>
Regards,<br>
Bogdan<br>
<br>
On 06/15/2011 05:53 AM, Dovid Bender wrote:
<blockquote
cite="mid:B45BD6C9DA7F458DA541976A6B0B1D94@mypbxmanager.net"
type="cite">
<meta content="MSHTML 6.00.6000.17097" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi,</font></div>
<div> </div>
<div><font face="Arial" size="2">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:</font></div>
<div> </div>
<div><font face="Arial" size="2">Jun 14 20:12:14 peter
/sbin/opensips[4434]:
ERROR:db_mysql:db_mysql_convert_rows: no private memory
left <br>
Jun 14 20:12:15 peter /sbin/opensips[4434]:
ERROR:nathelper:nh_timer: out of pkg memory <br>
Jun 14 20:12:16 peter /sbin/opensips[4434]:
ERROR:nathelper:nh_timer: out of pkg memory <br>
Jun 14 20:12:20 peter /sbin/opensips[4434]:
ERROR:nathelper:nh_timer: out of pkg memory <br>
Jun 14 20:12:51 peter /sbin/opensips[4434]:
ERROR:nathelper:nh_timer: out of pkg memory <br>
</font></div>
<div><font face="Arial" size="2">We have fork set to 24 and
modparam( "usrloc", "fetch_rows", 500 ).</font></div>
<div> </div>
<div><font face="Arial" size="2">TIA.</font></div>
<div> </div>
<div><font face="Arial" size="2">Dovid</font></div>
</blockquote>
<br>
</blockquote>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Bogdan-Andrei Iancu
OpenSIPS solutions and "know-how"</pre>
</body>
</html>