[Spce-user] MySQL client ran out of memory

[Michael Schoepfer]

Hi,

this was set to:

ulimit -c unlimited

and i changed it to:

ulimit -l 524288

Now it seems to work. Thanks for that. But i didn't change the value
originally?

Michael





Am 13. April 2012 11:19 schrieb Andrew Pogrebennyk <apogrebennyk at sipwise.com
>:

> 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)
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120413/57099a94/attachment-0001.html>