Hi, That solved my problem for now. Thanks.
Do you think i could increase fetch_rows if I also increased the private memory? /Morten On Mon, Jan 24, 2011 at 4:27 PM, marius zbihlei <marius.zbih...@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@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > -- Morten Isaksen _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users