[OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
Norman Brandinger
norm at goes.com
Mon Feb 4 16:08:46 CET 2008
I'm also receiving the out of memory errors.
Created a little shell script and have it executed by cron regularly.
/etc/syslog.conf:
local6.* -/var/log/openser.log
openser.cfg:
log_facility=LOG_LOCAL6
ctontab:
1,15,30,45 * * * * /usr/local/bin/openser_mem_checker
/usr/local/bin/openser_mem_checker:
#!/bin/sh
ERRORCOUNT=`grep 'out of pkg memory' /var/log/openser.log | wc -l`
if [ $ERRORCOUNT -gt 0 ] ; then
echo "OpenSER is having a memory problem. Restarting."
/usr/sbin/logrotate -f /etc/logrotate.d/openser
PID=`cat /var/run/syslogd.pid`
kill -HUP $PID
/etc/init.d/openser restart
fi
</snip>
Regards,
Norm
Iñaki Baz Castillo wrote:
> On Monday 04 February 2008 15:37:36 Henning Westerholt wrote:
>
>> On Monday 04 February 2008, Iñaki Baz Castillo wrote:
>>
>>> Hi, why could this error occur? It has ocurred me now several times but
>>> never seen it before ¿?
>>>
>>>
>>> Feb 4 15:31:31 [27228] ERROR:mysql:db_mysql_convert_row: no private
>>> memory left
>>>
>> Hi Iñaki,
>>
>> this means that the mysql driver could not allocate memory for its internal
>> usage, skipping the query. What version of the server do you use?
>>
>
> I use Debian Sid with mysql-server-5.0 (5.0.51-1).
> Do you mean that this is a database bug? or OpenSer mysql driver bug?
>
>
>
>
More information about the Users
mailing list