[SR-Users] Problem reloading carrierroute

[marius zbihlei]

On 01/24/2011 10:52 PM, Morten Isaksen wrote:
> Hi,
>
> That solved my problem for now. Thanks.
>
> Do you think i could increase fetch_rows if I also increased the private memory?
>
> /Morten
>
>    

Hello,

Yes, increasing pkg_mem will also allow to increase the fetch_row param. 
Keep in mind that this is used only on kamailio startup and on 
cr_reload_routes, and has no impact on performance. A 10-15 MB private 
mem size should suffice.

Marius
> On Mon, Jan 24, 2011 at 4:27 PM, marius zbihlei<marius.zbihlei at 1and1.ro>  wrote:
>    
>> On 01/24/2011 05:15 PM, Morten Isaksen wrote:
>>      
>>> Hi,
>>>
>>> Kamailio 3.0.3.
>>>
>>>
>>>        
>> Hello
>>
>>      
>>> A few days ago we got a problem when "kamctl cr reload" was executed.
>>>
>>> Jan 24 08:50:27 sip-core-2 /usr/local/sbin/kamailio[1639]: ERROR:
>>> db_mysql [km_dbase.c:346]: no memory left
>>> Jan 24 08:50:27 sip-core-2 /usr/local/sbin/kamailio[1639]: ERROR:
>>> carrierroute [cr_db.c:331]: Fetching rows failed
>>> Jan 24 08:50:27 sip-core-2 /usr/local/sbin/kamailio[1639]: ERROR:
>>> carrierroute [cr_data.c:181]: could not load routing data
>>>
>>> I tried to increase the shared memory from 32M to 64M but that did not
>>> seem to help. It failed again after a few hours.
>>>
>>> The last thing I tried was to insert
>>>
>>> modparam("carrierroute", "fetch_rows", 2000) into kamailio.cfg and is
>>> waiting to see if that helped.
>>>
>>> The carrierroute table is about 16K rows.
>>>
>>> Is it private og shared memory that is missing? Any other ideas how to fix
>>> this?
>>>
>>>
>>>        
>> It seems there is a problem with the private memory(maybe a leak somewhere).
>> you can decrease the fetch_rows parameters to 500 and test if it works this
>> way.
>>
>>      
>> Marius
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>      
>
>
>