Re: [Sqlrelay-discussion] connections="0" gives errors, memory leaks when oracle not available

[David M. <dav...@fi...>]

Oracle's OCIServerAttach method appears to leak 192 bytes (on x86_64
linux, oracle version 10.2.0.1) whenever it's called if the db isn't
available.  Since SQL Relay attempts to log every 5 seconds when the db
is unavailable, it can lead to huge memory consumption if the db is
down.

There is apparently a patch or set of patches which fix the problem.
One of my customers is using 10.2.0.4 and doesn't have the problem.

What exactly happens when connections="0", other than the memory leak?

Also, give 0.38 a try.  I did recently make some fixes to the connection
scaling code.

Dave
dav...@fi...

On Tue, 2006-11-07 at 10:15 +0100, Ragnar Rova wrote:
> Hello.

> If I configure an instance to have connections="0" and the
> database is unavailable, sqlrelay seems to run amok for me
> when trying to scale up connections when needed.
> 
> Also I noticed strange memory leaks when an oracle8 database
> went away (sqlr-connection-oracle8 for an unavailable instance consuming
> some 450M memory on hp-ux 11.11i)
> 
> This was using 0.37
> 
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>