[Spce-user] MySQL client ran out of memory

[Andrew Pogrebennyk]

Michael,
Please check /etc/init.d/kamailio-proxy, it should have something like:
# raise memlock limit, otherwise mysql client fails to initialize
ulimit -l 524288
before OPTIONS="..." line. Try increasing it by 2x.

Alternatively you can set the fetch_rows usrloc module parameter
http://kamailio.org/docs/modules/3.1.x/modules_k/usrloc.html#id2997066
to something smaller, e.g. 1000:
modparam("usrloc", "fetch_rows", 1000)
in proxy.cfg.customtt.tt2. Let me know if it helps.

On 04/13/2012 10:20 AM, Michael Schoepfer wrote:
> I have about 100 users in the system and about 200 rewrite rules. The
> following appears upon starting the kamailo proxy. I think its related
> to the log entries.

This is suggesting the problem is with usrloc module, not dialplan
(rewrite rules):
> Apr 13 03:13:47 media3 /usr/sbin/kamailio[13380]: ERROR: usrloc
> [ul_mod.c:345]: child(0): failed to connect to database
> Apr 13 03:13:47 media3 /usr/sbin/kamailio[13380]: ERROR: <core>
> [sr_module.c:832]: init_mod_child(): Error while initializing module
> usrloc (/usr/lib/kamailio/modules_k/usrloc.so)