sqlgrey-users

[Sqlgrey-users] Memory Leak?

[Matteo N. <mat...@st...>]

I'm running sqlgrey 1.7.4 with mysql support on a gentoo linux server
with postfix 2.3.8
I have 3 mysql server, 1 is master and the other are slaves.

I see that each time I restart sqlgrey it uses about 12Mbyte of RAM.
Afterk some days,
3-4, it uses 110Mbyte of RAM. If I don't restart it in a 3 week, it uses
something like
1.1Gbyte of RAM :)

At the moment I use a workaround based on a simple restart of sqlgrey
once a week.

Anyone of you can help me to find the solution to this problem?

Thanks.

Re: [Sqlgrey-users] Memory Leak?

[Lionel B. <lio...@bo...>]

Matteo Niccoli wrote the following on 03.05.2007 18:45 :
> I'm running sqlgrey 1.7.4 with mysql support on a gentoo linux server
> with postfix 2.3.8
> I have 3 mysql server, 1 is master and the other are slaves.
>
> I see that each time I restart sqlgrey it uses about 12Mbyte of RAM.
> Afterk some days,
> 3-4, it uses 110Mbyte of RAM. If I don't restart it in a 3 week, it uses
> something like
> 1.1Gbyte of RAM :)
>
> At the moment I use a workaround based on a simple restart of sqlgrey
> once a week.
>
> Anyone of you can help me to find the solution to this problem?
>   

The problem is usually a bad version of DBI or the MySQL DBD driver. I
tried various methods in SQLgrey to avoid some code I suspected to leak
memory but never managed to solve the problem (in fact I could only make
it worse).
The only thing to do is to try newer or older versions of these perl
libraries (I managed to solve the same problem by reverting to an older
version of the PostgreSQL driver once).

Lionel

Re: [Sqlgrey-users] Memory Leak?

[Andrew D. <and...@gm...>]

Hello Matteo,

This has been discussed on the list a few times.  As I recall the leak
is in DBI somewhere.  You can either backrev your DBI install, or just
keep restarting sqlgrey.  I restart sqlgrey several times a day, just
to make sure.

To get more specifics, search for my name and you'll find the threads.

On Thursday, May 3, 2007, 10:45:58 AM, Matteo Niccoli wrote:

> I'm running sqlgrey 1.7.4 with mysql support on a gentoo linux server
> with postfix 2.3.8
> I have 3 mysql server, 1 is master and the other are slaves.

> I see that each time I restart sqlgrey it uses about 12Mbyte of RAM.
> Afterk some days,
> 3-4, it uses 110Mbyte of RAM. If I don't restart it in a 3 week, it uses
> something like
> 1.1Gbyte of RAM :)

> At the moment I use a workaround based on a simple restart of sqlgrey
> once a week.

> Anyone of you can help me to find the solution to this problem?

> Thanks.

> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users


-- 
Best regards,
 Andrew Diederich 

Re: [Sqlgrey-users] Memory Leak?

[Matteo N. <mat...@st...>]

Andrew Diederich ha scritto:
> Hello Matteo,
>
> This has been discussed on the list a few times.  As I recall the leak
> is in DBI somewhere.  You can either backrev your DBI install, or just
> keep restarting sqlgrey.  I restart sqlgrey several times a day, just
> to make sure.
>
> To get more specifics, search for my name and you'll find the threads.
>   
Thanks to all!