4 Feb
2008
4 Feb
'08
3:35 p.m.
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.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
4 Feb
4 Feb
3:37 p.m.
New subject: [OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
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
3:49 p.m.
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(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
3:53 p.m.
New subject: [OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
On Monday 04 February 2008 15:37:36 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?
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
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? 
4:08 p.m.
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:
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?
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?
4:17 p.m.
New subject: [OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
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.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
4:23 p.m.
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:
_______________________________________________
Users mailing list
Users(a)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?
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?
4:38 p.m.
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:
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
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?
4:27 p.m.
New subject: [OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
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
4:30 p.m.
New subject: [OpenSER-Users] ERROR:mysql:db_mysql_convert_row: no private memory
On Monday 04 February 2008 16:27:19 Henning Westerholt wrote:
On Monday 04 February 2008, Iñaki Baz Castillo wrote:
Yes, OpenSer trunk, but not the last version. I'm upgrading just now.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
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..
5941
days inactive
5941
days old
9 comments
4 participants
participants (4)
-
Bogdan-Andrei Iancu -
Henning Westerholt -
Iñaki Baz Castillo -
Norman Brandinger