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 Feb 4 15:31:31 [27228] ERROR:mysql:db_mysql_convert_rows: error while converting row #1 Feb 4 15:31:31 [27228] ERROR:mysql:db_mysql_convert_result: error while converting rows Feb 4 15:31:31 [27228] ERROR:mysql:db_mysql_store_result: error while converting result Feb 4 15:31:31 [27228] ERROR:core:db_do_raw_query: error while storing resultFeb 4 15:31:31 [27228] ERROR:usrloc:get_all_db_ucontacts: raw_query failed
I will investigate it but any comment will be welcome. Thanks.
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?
Cheers,
Henning
Hi Henning,
Just to eliminate any confusion - the error refers to openser private memory (pkg_mem) and it is generated by the code from mysql module from openser.
Regards, Bogdan
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?
Cheers,
Henning
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
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?
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?
On Monday 04 February 2008 16:08:46 Norman Brandinger wrote:
I'm also receiving the out of memory errors.
Created a little shell script and have it executed by cron regularly.
Now I have just 3 users registered, each of them subscribed to presence of 4~5 contacts, no more. For each SUBSCRIBE I run a very long DB query (more than 1024 bytes --> I had to increase AVP buffer arrays in OpenSer code and recompile it), but never had this problem.
Now I've restarted OpenSer and after 4 seconds I receive 3 SUBSCRIBE and the error appears.
What could I investigate?
Thanks a lot for any help.
Hi Norm,
have you tried to see if the memory errors are because of a leak or because of load??
Regards, Bogdan
Norman Brandinger wrote:
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?
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Should have mentioned that I'm running "trunk". Don't know if the problem is present on 1.3.
The system is lightly used, so it's probably not load related.
Haven't had time to investigate the problem (haven't recompiled with the extra memory flags). http://www.openser.org/dokuwiki/doku.php/troubleshooting:memory
For the benefit of the list: The info provided below is just one method of addressing the symptoms of the problem. It should not be relied on as a long term solution. That said, it does offer an example of how someone can get cron, the OpenSER logs, and OpenSER to work together.
Bogdan-Andrei Iancu wrote:
Hi Norm,
have you tried to see if the memory errors are because of a leak or because of load??
Regards, Bogdan
Norman Brandinger wrote:
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?
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
On Monday 04 February 2008, Iñaki Baz Castillo wrote:
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?
Sorry for the confusion,
i mean what version of openser do you use? Trunk is probably a little bit unstable on the db side at the moment because of my work..
Cheers,
Henning
On Monday 04 February 2008 16:27:19 Henning Westerholt wrote:
On Monday 04 February 2008, Iñaki Baz Castillo wrote:
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?
Sorry for the confusion,
i mean what version of openser do you use? Trunk is probably a little bit unstable on the db side at the moment because of my work..
Yes, OpenSer trunk, but not the last version. I'm upgrading just now.
-
Bogdan-Andrei Iancu -
Henning Westerholt -
Iñaki Baz Castillo -
Norman Brandinger