<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META content="MSHTML 6.00.6000.17098" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Bogdan,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </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><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bogdan@opensips.org href="mailto:bogdan@opensips.org">Bogdan-Andrei
Iancu</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A 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><BR><PRE class=moz-signature cols="72">--
Bogdan-Andrei Iancu
OpenSIPS solutions and "know-how"</PRE>
<P>
<HR>
<P></P>_______________________________________________<BR>Users mailing
list<BR>Users@lists.opensips.org<BR>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<BR></BLOCKQUOTE></BODY></HTML>