Hello

We got that problem once, we were using the
OracleCacheImpl (you can find the info with the Oracle
8i) on Solaris 2.6 and Jrun 3.0 SP2.

The problem was a Synchronized modificator on the
method that required new connections to the database
(we put a wrapper around the  OracleCacheImpl). After
we removed that (because the Oracle code is thread
safe) we resolved the problem.


Didi you checked the metalink databse for a similar
problem description (http://metalink.oracle.com)?

I hope this helps.

Jos� Vicente

--- Cristian Satnic <[EMAIL PROTECTED]>
escribi�: > Hi all,
> 
> I have a very weird problem that I can't really
> figure out.  Here are the
> details:  from time to time, our app (runs on Jrun
> 3, no service packs,
> oracle 8i, jdk 1.3, solaris 8) seems to just hang. 
> Oracle is fine - I can
> connect to it and run stuff but Jrun will only come
> back with a restart of
> the default server.
> 
> The last time it happened, I got a stack trace. 
> There were many threads
> with entries similar to the one below:
> 
> "jcp-1128" prio=5 tid=0x44d128 nid=0x498 waiting for
> monitor entry
> [0xd1680000..0xd16819e0]
>         at
>
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:435)
>         at
> dbBeans.dataBean.getRecordSet(dataBean.java:115)
>         at
>
structureBeans.displayBidSpec.checkMultSpecGroups(displayBidSpec.java:120)
>         at
>
jrun__jsp__displaybidspec2ejsp17._jspService(jrun__jsp__displaybidspec2ejsp1
> 7.java:245)
>         at
>
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:40)
>         at
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
>         at
>
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
>         at
>
allaire.jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:34
> )
>         at
>
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:174)
>         at
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
>         at
>
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
>         at
>
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.jav
> a:88)
>         at
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1131)
>         at
>
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:330)
>         at
>
allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:354)
>         at
> allaire.jrun.ThreadPool.run(ThreadPool.java:267)
>         at
> allaire.jrun.WorkerThread.run(WorkerThread.java:74)
> 
> 
> Basically, threads seem to be stuck in
>
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:435)
> 
> Here are some more numbers which trouble me:
> 
> - when the last hangup happened, there were about 35
> jrun sessions.  However
> in the stack trace the JVM for the default server
> had about 151 jcp threads
> out of which 82 were similar to the one above (stuck
> in the close statement)
> (full stack trace is available is somebody cares to
> see it)
> 
> On the oracle site there were about 115 sessions
> (here's the nasty part): 5
> active, 10 inactive, some oracle processes and about
> 80 sessions with the
> 'killed' status (the app is not perfect yet - some
> oracle connections are
> left open by jsp pages so we have a stored procedure
> which kills idle oracle
> sessions after some time of inactivity). 
> 
> We are working on making sure that all open db
> connections get closed
> properly.  However, I still don't understand if this
> is necessarily what the
> problem is here.  What were all those threads doing
> with statement.close
> statements if only 35 users were logged on?  And,
> while oracle was running
> fine (I could connect to it and do stuff), why did
> JRun hang and complain?
> 
> Can somebody give me some clues here or tell me
> anything that could help me?
> Thanks in advance.
> 
> Cristian
> 
> 
> ----------------------------------
> Cristian Satnic
> Sr. Consultant
> Tigris Consulting
> 212.481.1174 x10
> [EMAIL PROTECTED]
>  
> Archives:
>
http://www.mail-archive.com/[email protected]/
> Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists


=====
Jos� Vicente Nu�ez Zuleta
Lider de desarrollo para el 
diario El Universal
(http://www.eluniversal.com)
Divisi�n de nuevos medios.
[EMAIL PROTECTED]
Tlf: 582-505-2139
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to