Re: [Sqlrelay-discussion] connections="0" gives errors, memory leaks when oracle not available
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2006-11-07 14:34:13
|
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 > |