[SR-Users] Problem reloading carrierroute

[marius zbihlei]

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