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

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

Hello.

Sorry, but I am unable to reproduce the error I described
previously.

Here are some notes on getting sqlrelay to work on HP-UX 11.11.

I switched to sqlrelay-0.38 and upgraded the oracle client to instant client
10.2.0.2

I have attached a patch for rudiments-0.30, it probably
breaks some functionality but it compiles and works for me.

For sqlrelay-0.38, I had to set ORACLE_HOME to a Oracle 9i
directory and replace all instances of $ORACLE_HOME/lib with
$ORACLE_HOME/lib32 in sqlrelay-0.38/configure

After running ./configure I had to edit config.mk
and replace the paths with references to an oracle instant client 10.2.0.2
installation because of the new directory structure.

changes to config.mk:
------
ORACLEVERSION = 10g
ORACLEINCLUDES = -I/usr/app/oracle/instantclient/10.2.0.2/sdk/include/
ORACLELIBS = -L/usr/app/oracle/instantclient/10.2.0.2/ -lclntsh
-l:libcl.sl -l:librt.sl -lpthread -l:libnss_dns.1 -l:libdld.sl
ORACLELIBSPATH = /usr/app/oracle/instantclient/10.2.0.2/
ORACLESTATIC =
ORACLEUSERPATH = yes
------

because of a missing shared libgcc I had to modify sqlrelay-0.38/libtool

--- libtool.orig        2006-11-15 11:03:33 +0100
+++ libtool     2006-11-14 19:01:33 +0100
@@ -7037,7 +7037,7 @@

 # Dependencies to place after the objects being linked to create a
 # shared library.
-postdeps="-lstdc++ -lm -lgcc -lgcc"
+postdeps="-lstdc++ -lm"

 # The library search path used internally by the compiler when linking
 # a shared library.


--
In src/api/perl/Connection/Makefile,
src/api/perl/Cursor/Makefile
and src/api/php/Makefile

I replaced all occurrences of ".so" with ".sl" to get it to build.

The php and perl interpreters crash when I try to use the respective
sqlrelay APIs. But the "query" and "sqlrsh" command line tools
work fine.

Also attached a sqlrelay rc script for init. sqlr-stop would not
always kill all processes (although this was only observed in 0.37)

On Tue, November 7, 2006 15:34, 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=12164
>> 2
>> _______________________________________________
>> 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
>
>