Re: [Sqlrelay-discussion] Oracle bounces causing dead connections
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Oracle bounces causing dead connections
|
From: Firstworks/4access <dav...@fi...> - 2005-10-11 15:25:30
|
What versions of Oracle SQL Relay are you running? I just tried to reproduce this problem using Oracle 10g and current SQL Relay, using a similar setup to yours (including authtier="database"). When I bounced my database, the SQL Relay connection daemons recovered gracefully and I was able to run queries against it again. The connection daemons analyze each error that comes back from the database and recognize certain errors as meaning that the database was bounced. It's possible that I missed one of those errors and that the connection daemon hasn't realized that the database is down and hasn't attempted to reconnect to it. If I send you some code with debug in it, can you rebuild/reinstall SQL Relay and try to reproduce the problem again? Dave dav...@fi... On Thu, 2005-10-06 at 16:26 -0400, Todd Freeman wrote: > 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/password' message... (and yes... it is using the same script using the same username and password that the working ones are using) > > Any help would be appreciated! Ohh yeah... and ROCK ON! > > ##### Relevant conf ##### > <instance id="oracleTEST" port="9000" socket="/tmp/oracleTEST.socket" dbase="oracle8" connections="2" maxconnections="4" maxqueuelength="0" growby="2" ttl="60" endofsession="rollback" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="20" debug="listener_and_connection" authtier="database"> > <users> </users> > <connections> > <connection connectionid="its_proxy" string="user=its_proxy;password=secret;oracle_sid=TEST.world;autocommit=no;" metric="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 mutex > 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 authentication 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 cursors... > 10/06/2005 16:11:50 EDT connection [9268] : done aborting all busy cursors > 10/06/2005 16:11:50 EDT connection [9268] : resetting autocommit behavior... > 10/06/2005 16:11:50 EDT connection [9268] : setting autocommit off... > 10/06/2005 16:11:50 EDT connection [9268] : done setting autocommit off... > 10/06/2005 16:11:50 EDT connection [9268] : done resetting autocommit 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 access... > 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... > 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 access > 10/06/2005 16:11:50 EDT listener [25739] : waiting for an available connection > 10/06/2005 16:11:50 EDT listener [25739] : done waiting for an available connection > 10/06/2005 16:11:50 EDT listener [25739] : handoff=reconnect > 10/06/2005 16:11:50 EDT listener [25739] : socket=/usr/local/firstworks/var/sqlrelay/tmp/sockets/156 port=53973 > 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 access > 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 > ######################### > > |
