Hi,
Kamailio 3.0.3.
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?
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
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.zbihlei@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
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 zbihleimarius.zbihlei@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
-
marius zbihlei -
Morten Isaksen