[Spce-user] MySQL client ran out of memory

[Michael Schoepfer]

And the  bufferpoolsize: 3064M

(Also the default value)

Michael

Am 13. April 2012 11:52 schrieb Michael Schoepfer <
michael.schoepfer at gmail.com>:

> Hi,
>
> i checked the system there is 6 GB ram.
>
> Michael
>
> Am 13. April 2012 11:34 schrieb Michael Schoepfer <
> michael.schoepfer at gmail.com>:
>
> 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/mailman/private/spce-user_lists.sipwise.com/attachments/20120413/142618c5/attachment.html>