[Sqlrelay-discussion] Oracle bounces causing dead connections

[Todd F. <fr...@an...>]

Howdy all!

Am having great fun with sqlrelay...  works great... except (you knew that =
was coming didn't you :} )  when the database bounces I am getting at least=
 1 connection that 'hangs'.

The symptoms are that some of my perl progs just run on fine...  but others=
 connecting to this connection get 'Broken Pipe'

Below are the conf... the logs from the connection and the listener it says=
 it is debugging to. The only odd thing I see is the 'invalid login/passwor=
d' message... (and yes... it is using the same script using the same userna=
me and password that the working ones are using)

Any help would be appreciated! Ohh yeah... and ROCK ON!

##### Relevant conf #####
        <instance id=3D"oracleTEST" port=3D"9000" socket=3D"/tmp/oracleTEST=
=2Esocket" dbase=3D"oracle8" connections=3D"2" maxconnections=3D"4" maxqueu=
elength=3D"0" growby=3D"2" ttl=3D"60" endofsession=3D"rollback" sessiontime=
out=3D"600" runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"20" debug=
=3D"listener_and_connection" authtier=3D"database">
                <users> </users>
                <connections>
                        <connection connectionid=3D"its_proxy" string=3D"us=
er=3Dits_proxy;password=3Dsecret;oracle_sid=3DTEST.world;autocommit=3Dno;" =
metric=3D"1"/>
               </connections>
        </instance>
#########################

##### /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9268 #####
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.25739
10/06/2005 16:11:50 EDT connection [9268] :     done waiting for listener
10/06/2005 16:11:50 EDT connection [9268] :     releasing announce mutex
10/06/2005 16:11:50 EDT connection [9268] :     done releasing announce mut=
ex
10/06/2005 16:11:50 EDT connection [9268] : done announcing availability...
10/06/2005 16:11:50 EDT connection [9268] : waiting for client...
10/06/2005 16:11:50 EDT connection [9268] :     reconnect succeeded
10/06/2005 16:11:50 EDT connection [9268] : done waiting for client
10/06/2005 16:11:50 EDT connection [9268] : client session...
10/06/2005 16:11:50 EDT connection [9268] :     getting command...
10/06/2005 16:11:50 EDT connection [9268] :     done getting command
10/06/2005 16:11:50 EDT connection [9268] :     authenticate
10/06/2005 16:11:50 EDT connection [9268] :     authenticate...
10/06/2005 16:11:50 EDT connection [9268] :     database-based authenticati=
on failed: invalid user/password
10/06/2005 16:11:50 EDT connection [9268] :             ending session...
10/06/2005 16:11:50 EDT connection [9268] :             aborting all busy c=
ursors...
10/06/2005 16:11:50 EDT connection [9268] :             done aborting all b=
usy cursors
10/06/2005 16:11:50 EDT connection [9268] :             resetting autocommi=
t behavior...
10/06/2005 16:11:50 EDT connection [9268] :                     setting aut=
ocommit off...
10/06/2005 16:11:50 EDT connection [9268] :                     done settin=
g autocommit off...
10/06/2005 16:11:50 EDT connection [9268] :             done resetting auto=
commit behavior...
#########################

##### /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.25739 #####
10/06/2005 16:11:50 EDT listener [25739] : getting authentication...
10/06/2005 16:11:50 EDT listener [25739] : done getting authentication
10/06/2005 16:11:50 EDT listener [25739] : incrementing session count...
10/06/2005 16:11:50 EDT listener [25739] :      waiting for exclusive acces=
s...
10/06/2005 16:11:50 EDT listener [25739] :      done waiting for exclusive =
access...
10/06/2005 16:11:50 EDT listener [25739] :      3
10/06/2005 16:11:50 EDT listener [25739] :      waiting for the scaler...
10/06/2005 16:11:50 EDT listener [25739] :      done waiting for the scaler=
=2E..
10/06/2005 16:11:50 EDT listener [25739] : done incrementing session count
10/06/2005 16:11:50 EDT listener [25739] : getting a connection...
10/06/2005 16:11:50 EDT listener [25739] : acquiring exclusive shm access
10/06/2005 16:11:50 EDT listener [25739] : done acquiring exclusive shm acc=
ess
10/06/2005 16:11:50 EDT listener [25739] : waiting for an available connect=
ion
10/06/2005 16:11:50 EDT listener [25739] : done waiting for an available co=
nnection
10/06/2005 16:11:50 EDT listener [25739] :      handoff=3Dreconnect
10/06/2005 16:11:50 EDT listener [25739] :      socket=3D/usr/local/firstwo=
rks/var/sqlrelay/tmp/sockets/156  port=3D53973
10/06/2005 16:11:50 EDT listener [25739] : signalling connection that we've=
 read
10/06/2005 16:11:50 EDT listener [25739] : done signalling connection that =
we've read
10/06/2005 16:11:50 EDT listener [25739] : releasing exclusive shm access
10/06/2005 16:11:50 EDT listener [25739] : done releasing exclusive shm acc=
ess
10/06/2005 16:11:50 EDT listener [25739] :      done getting a connection
10/06/2005 16:11:50 EDT listener [25739] : decrementing busy listeners
10/06/2005 16:11:50 EDT listener [25739] : done decrementing busy listeners
#########################


--=20
Todd Freeman  Ext 6103                   .^.    Don't fear the penguins!
Programming Department                   /V\
Andrews University                      // \\    http://www.linux.org/
http://www.andrews.edu/~freeman/       /(   )\   http://www.debian.org/
                                        ^^ ^^