<!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>
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 http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<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>
</body>
</html>