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?