<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
DR module use private memory (pkg mem) in order to load info from
DB. Usually OpenSIPS has 2M of pkg memory (which is also used by
other module aside DR), so maybe that available amount of mem is not
enough for loading a 40K rows at a time. <br>
<br>
Try to decrease the "fetch_rows" param to 1000 for example, to see
if ok. This will have no side effect, it will simply load data via
multiple chunks.<br>
<br>
Regards,<br>
Bogdan<br>
<br>
On 12/28/2011 02:58 PM, dpa wrote:
<blockquote cite="mid:015301ccc560$70cc6f00$52654d00$@ru"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:2.0cm 42.5pt 2.0cm 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">There is such problem<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Opensips 1.6.4-2<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I am using drouting
module to relay any calls.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">modparam("drouting",
"fetch_rows", 40000)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When I am try using fifo
dr_reload I see such error <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“Dec 28 16:38:24
opensips /usr/local/opensips1.6.4-2/sbin/opensips[27360]:
ERROR:core:db_allocate_rows: no memory left<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Dec 28 16:38:24 opensips
/usr/local/opensips1.6.4-2/sbin/opensips[27360]:
ERROR:db_mysql:db_mysql_fetch_result: no memory left<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Dec 28 16:38:24 opensips
/usr/local/opensips1.6.4-2/sbin/opensips[27360]:
ERROR:drouting:dr_load_routing_info: Error fetching rows”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And I cannot see any
problem with memory<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“shmem:total_size =
104857600<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">shmem:used_size =
34574448<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">shmem:real_used_size =
38811912”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“pkmem:0-total_size =
5242880<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">pkmem:0-used_size =
591616<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">pkmem:0-real_used_size =
717016<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">pkmem:0-max_used_size =
919520<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">pkmem:0-free_size =
4525864<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">pkmem:0-fragments = 2”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank you for any help<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
OpenSIPS solutions and "know-how"</pre>
</body>
</html>