Re: [Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] sqlr-listener-0.4X dies with Oracle10g x86_64
|
From: Benoit C. <ben...@fr...> - 2009-05-11 15:48:21
|
Hi,
I also had a lot a problems with sqlrelay 0-4x and oracle 10G, (sqlrelay
running out of cursors or segfault).
Actually, I'm still using 0.39.4 for production
I had reported it and David M. is working on it (your changelog's quote).
I'm waiting for a new release.
For your problem, you can try looking at :
- the simplest one : is
/usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/ writable by
"sqlrelay user" (depends on your sqlrelay.conf file).
- i also had a similar problem by having a miswritten sqlrelay.conf file
with a single instance. Have a look at your file (maybe post it here)
and try to define a second instance
- i'm using oracle full client. instantclient causes me lots of troubles
:) you can try to compile sqlrelay with the oracle full client but if it
works actually fine with instant client and 0.39.4 i dont think i would
change something.
- the sqlr-scaler process only start if in your conf file your have
different values betwin connections and maxconnections
I understand your using sqlrelay 0.39.4 rpm. You can try to recompile
0.39.4 see if it's working fine with your way. If not, may be you doing
something wrong.
But I think there is some kind of problems with sqlrelay 0.40 / 0.41 and
oracle
Best regards.
Benoit Cattié
Ignacio Barrancos a écrit :
> Hi,
>
> This weekend, I tried to compile sqlrelay 0.41 in a 32bits server, using:
>
> Oracle server: Oracle XE 10.2.0.1
> Operative System: RHEL4U3 i386
> GCC version: 3.4.5 20051201 (Red Hat 3.4.5-2)
> Rudiments version: 0.32
> Oracle Client: oracle-instantclient-basic-10.2.0.3-1.i386.rpm
> oracle-instantclient-devel-10.2.0.3-1.i386.rpm
> oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
> oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm
>
> And I got the same result: 0.39.4 Works fine, sqlr-listener startup
> and all ok. 0.41 doesn't work ... when i execute "sqlr-start -id
> oracletest" ... sqlr-listener dies, and sqlr-scaler can't start.
>
>
> May be exists some problem with Oracle and later versions than sqlrelay-39.4 ?
>
> Thanks in advance,
> Ignacio.
>
>
>
> 2009/5/7, Ignacio Barrancos <ign...@gm...>:
>
>> Hi guys,
>>
>> I'm using sqlrelay-0.39.4 on my 64bits server:
>>
>> Operative System: RHEL5U2 x86_64
>> GCC version: 4.1.2 20071124 (Red Hat 4.1.2-42)
>> Rudiments version: 0.31
>> Oracle Client: oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
>> oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
>> oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
>> oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm
>>
>>
>> This version works fine on my web server (i have installed in
>> /usr/local/firstworks), but sometimes, after has many visits
>> simultaneous and CPU load is high, i must restart apache2, and
>> sqlr-connection-oracle8 proccess hangs and then i can't stop sqlrelay
>> (sqlr-stop)
>>
>> I have read the ChangeLog of new versions, i want test these news
>> version: I'm trying run sqlrelay-0.41, sqlrelay-0.40, and
>> sqlrelay-CVS_HEAD compiled with-oracle support on my server, like i
>> done for sqlrelay-0.39.4 and using the same programs and libraries.
>>
>> I'm using "stow" command for the compilation, because i can test
>> diferent versions.
>>
>> The Oracle Instantclient x86_64 installs the libraries at
>> /usr/lib/oracle/10.2.0.3/client64/lib/ and the includes at
>> /usr/include/oracle/10.2.0.3/client64. I have edit to "configure"
>> file (after tar xzvf VERSION_SQLRELAY.tgz) and apply this patch:
>>
>>
>> --------8<-- Patch_on_configure ------8<---------------
>> 22994c22994
>> < if ( test -r
>> "/usr/lib/oracle/$version/client/lib/libclntsh.$SOSUFFIX" -a -r
>> "/usr/include/oracle/$version/client/oci.h" )
>> ---
>> > if ( test -r "/usr/lib/oracle/$version/client64/lib/libclntsh.$SOSUFFIX" -a -r "/usr/include/oracle/$version/client64/oci.h" )
>> 22997,22999c22997,22999
>> < ORACLELIBSPATH="/usr/lib/oracle/$version/client/lib"
>> < ORACLELIBS="-L/usr/lib/oracle/$version/client/lib -lclntsh -lnnz10"
>> < ORACLEINCLUDES="-I/usr/include/oracle/$version/client"
>> ---
>> > ORACLELIBSPATH="/usr/lib/oracle/$version/client64/lib"
>> > ORACLELIBS="-L/usr/lib/oracle/$version/client64/lib -lclntsh -lnnz10"
>> > ORACLEINCLUDES="-I/usr/include/oracle/$version/client64"
>> --------8<-- Patch_on_configure ------8<---------------
>>
>>
>>
>> Then, for compile 0.41, i executed:
>>
>>
>>
>>
>> --------8<---- commands for compile -------8<-------------
>>
>> ./configure --prefix=/usr/local/stow/sqlrelay-0.41 --disable-python
>> --disable-mysql --disable-postgresql --disable-sqlite
>> --disable-freetds --disable-sybase --disable-odbc --disable-db2
>> --disable-firebird --disable-mdbtools --disable-perl --disable-zope
>> --disable-ruby --disable-java --disable-tcl --disable-gtk
>>
>> make
>> make install
>>
>> # With these lines i can install on /usr/local/bin, /usr/local/lib,
>> etc, with stow.
>>
>> cd /usr/local/stow
>> cp /usr/local/firstworks/etc/sqlrelay.conf sqlrelay-0.41/etc/
>>
>> stow sqlrelay-0.41
>>
>> --------8<---- commands for compile -------8<-------------
>>
>>
>>
>> Then, execute these commands to launch SQLRelay
>>
>>
>> -------8<-------launch sqlrelay ----------8<--------------
>> export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client64/lib:/usr/local/lib:${LD_LIBRARY_PATH}
>> export TNS_ADMIN=/home
>> export NLS_LANG=American_America.WE8ISO8859P1
>>
>> sqlr-start -id oracletest
>> -------8<-------launch sqlrelay ----------8<--------------
>>
>>
>>
>> And i obtain this output....
>>
>>
>>
>> -------8<-------output--------------------8<--------------
>> Starting listener:
>> sqlr-listener -id oracletest -config
>> /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>> Starting 5 connections to oracletest :
>> sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>> -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>> sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>> -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>> sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>> -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>> sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>> -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>> sqlr-connection-oracle8 -id oracletest -connectionid oracletest
>> -config /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>> Starting scaler:
>> sqlr-scaler -id oracletest -config
>> /usr/local/stow/sqlrelay-0.41/etc/sqlrelay.conf
>>
>> sqlr-scaler error:
>> The file /usr/local/stow/sqlrelay-0.41/var/sqlrelay/tmp/pids/sqlr-listener-oracletest
>> was not found.
>> This usually means that the sqlr-listener is not running.
>> The sqlr-listener must be running for the sqlr-scaler to start.
>>
>>
>> sqlr-scaler failed to start.
>>
>>
>> Thanks to MP3.com for sponsoring:
>> Clustered/Replicated database support.
>> Perl API.
>> Thanks to FeedLounge for sponsoring:
>> Query routing and filtering.
>>
>> -------8<-------output--------------------8<--------------
>>
>>
>>
>> It seems that, when start the maximum sqlr-connection-oracle8
>> connections that i have configured in sqlrelay.conf (five in my case)
>> , the sqlr-listener proccess dies, and then sqlr-scaler startup fails,
>> because it can't found sqlr-listener-oracletest.
>>
>> I have try some versions: sqlrelay-0.41, sqlrelay-0.40, and
>> sqlrelay-CVS_HEAD, and most recents Oracle Instants clients for 64bits
>> (10.2.0.4) and all versions upper than 0.39.4, i obtained de same
>> result, in the same server ...
>>
>>
>> - what am I doing wrong?
>> - Is a bug?
>> - what can I do to debug if it's a configuration problem?
>>
>>
>> thanks in advance,
>>
>>
>> Ignacio Barrancos.
>>
>>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
|
