<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"Стандартный HTML Знак";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTML
{mso-style-name:"Стандартный HTML Знак";
mso-style-priority:99;
mso-style-link:"Стандартный HTML";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Courier New";
color:#1F497D;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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]--></head><body bgcolor=white lang=RU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-family:"Courier New";color:#1F497D'>Ok, thank you, I will try<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> Bogdan-Andrei Iancu [mailto:bogdan@opensips.org] <br><b>Sent:</b> Wednesday, December 28, 2011 5:05 PM<br><b>To:</b> OpenSIPS users mailling list<br><b>Cc:</b> dpa<br><b>Subject:</b> Re: [OpenSIPS-Users] drouting and free memory<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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: <o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Hello!</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>There is such problem</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Opensips 1.6.4-2</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>I am using drouting module to relay any calls.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>modparam("drouting", "fetch_rows", 40000)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>When I am try using fifo dr_reload I see such error </span><o:p></o:p></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</span><o:p></o:p></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</span><o:p></o:p></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”</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>And I cannot see any problem with memory</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>“shmem:total_size = 104857600</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>shmem:used_size = 34574448</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>shmem:real_used_size = 38811912”</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>“pkmem:0-total_size = 5242880</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>pkmem:0-used_size = 591616</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>pkmem:0-real_used_size = 717016</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>pkmem:0-max_used_size = 919520</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>pkmem:0-free_size = 4525864</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>pkmem:0-fragments = 2”</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>Thank you for any help</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br><br><br><o:p></o:p></span></p><pre>-- <o:p></o:p></pre><pre>Bogdan-Andrei Iancu<o:p></o:p></pre><pre>OpenSIPS Founder and Developer<o:p></o:p></pre><pre>OpenSIPS solutions and "know-how"<o:p></o:p></pre></div></body></html>