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

[Ragnar R. <rr...@mi...>]

How to build sqlrelay-0.38 on hp-ux 11.11 using oracle instant client 10.2.0.2?

On Tue, Nov 07, 2006 at 09:34 -0500 David Muse wrote:
> 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
> > 
> 
> 
> -------------------------------------------------------------------------
> 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