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
Re: JRun hangs - possible problem in interraction with Oracle ?!?
Jos� Vicente N��ez Zuleta Wed, 25 Apr 2001 21:49:27 -0700
- JRun hangs - possible problem in interraction wi... Cristian Satnic
- Re: JRun hangs - possible problem in interr... Jos� Vicente N��ez Zuleta
- please recompile it with -DEAPI--help me Jos� Vicente N��ez Zuleta
- please recompile it with -DEAPI--help m... Venkata Sudheer Buddiga
