[Sqlrelay-discussion] Not all connections are used

[Renat S. <sr...@st...>]

Hello!

Today I've seen strange situation with sqlrelay-0.40.

Sqlr-scaler started 12 connections, as max as it can. But only 2 client 
connections were processed in time, and other requests were queued  in 
forked listeners. Where were other 10 connections and what were they 
doing? From the Oracle side these sessions were doing  nothing.

Take a look at sqlr-status output:

--begin--
   Open   Server Connections:  12
   Opened Server Connections:  427

   Open   Client Connections:  2
   Opened Client Connections:  76590

   Open   Server Cursors:      120
   Opened Server Cursors:      80739

   Times  New Cursor Used:     0
   Times  Cursor Reused:       9273202

   Total  Queries:             4706353
   Total  Errors:              16756

   Forked Listeners:           9
--end--

config:
     <instance id="ow_admin" port="19003" 
socket="/onyma/sqlrelay/var/sqlrelay_ow_admin.socket"
               addresses="0.0.0.0" dbase="oracle8" connections="1" 
maxconnections="12"
               maxqueuelength="0" growby="1" ttl="60" 
endofsession="rollback"
               sessiontimeout="600" runasuser="onyma" runasgroup="onyma"
               cursors="10" authtier="listener" handoff="pass" deniedips=""
               allowedips="" debug="none" maxquerysize="65536"
               maxstringbindvaluelength="32767" 
maxlobbindvaluelength="71680"
               idleclienttimeout="120" maxlisteners="64" 
listenertimeout="60"
               maxsessioncount="256">
         <users>
             <user user="ow_admin" password="ow_admin"/>
         </users>
         <connections>
             <connection connectionid="ow_admin"
 
string="user=ow_admin;password=ow_admin;oracle_sid=rdbms1;nls_lang=AMERICAN_AMERICA.UTF8;"
                         metric="1"/>
         </connections>
     </instance>



-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...