Bugs item #648344, was opened at 2002-12-04 11:52
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648344&group_id=22866
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Bruce Barrow (bruce_b)
Assigned to: Nobody/Anonymous (nobody)
Summary: open-cursors limit reached
Initial Comment:
First 'bug', so bear with me. Some description follows
the trace.
OS: Windows NT 4.0
JDK: 1.4
10:13:49,671 INFO [Server] JBoss Release: JBoss-
3.0.3 CVSTag=JBoss_3_0_3
10:13:49,718 INFO [Server] Home Dir: F:\jboss\jboss-
3.0.3
10:13:49,718 INFO [Server] Home URL:
file:/F:/jboss/jboss-3.0.3/
10:13:49,718 INFO [Server] Library URL:
file:/F:/jboss/jboss-3.0.3/lib/
10:13:49,718 INFO [Server] Patch URL: null
10:13:49,718 INFO [Server] Server Name: efc
10:13:49,718 INFO [Server] Server Home Dir:
F:\jboss\jboss-3.0.3\server\efc
10:13:49,718 INFO [Server] Server Home URL:
file:/F:/jboss/jboss-3.0.3/server/efc/
10:13:49,718 INFO [Server] Server Data Dir:
F:\jboss\jboss-3.0.3\server\efc\db
10:13:49,718 INFO [Server] Server Temp Dir:
F:\jboss\jboss-3.0.3\server\efc\tmp
10:13:49,750 INFO [Server] Server Config URL:
file:/F:/jboss/jboss-3.0.3/server/efc/conf/
10:13:49,750 INFO [Server] Server Library URL:
file:/F:/jboss/jboss-3.0.3/server/efc/lib/
10:13:49,750 INFO [Server] Root Deployemnt Filename:
jboss-service.xml
10:13:49,750 INFO [Server] Starting General Purpose
Architecture (GPA)...
10:13:50,218 INFO [ServerInfo] Java version:
1.4.0_02,Sun Microsystems Inc.
10:13:50,218 INFO [ServerInfo] Java VM: Java HotSpot
(TM) Client VM 1.4.0_02-b02,Sun Microsystems Inc.
10:13:50,218 INFO [ServerInfo] OS-System: Windows
NT 4.0,x86
10:13:50,312 INFO [ServiceController] Controller MBean
online
10:13:50,484 INFO [MainDeployer] Creating
10:13:50,546 INFO [MainDeployer] Created
10:13:50,546 INFO [MainDeployer] Starting
10:13:50,546 INFO [MainDeployer] Started
10:13:50,578 INFO [JARDeployer] Creating
10:13:50,578 INFO [JARDeployer] Created
10:13:50,578 INFO [JARDeployer] Starting
10:13:50,578 INFO [MainDeployer] Adding deployer:
org.jboss.deployment.JARDeployer@808199
10:13:50,578 INFO [JARDeployer] Started
10:13:50,609 INFO [SARDeployer] Creating
10:13:50,609 INFO [SARDeployer] Created
10:13:50,609 INFO [SARDeployer] Starting
10:13:50,609 INFO [MainDeployer] Adding deployer:
org.jboss.deployment.SARDeployer@66a22b
10:13:50,703 INFO [SARDeployer] Started
10:13:50,703 INFO [Server] Core system initialized
10:13:50,718 INFO [MainDeployer] Starting deployment
of package: file:/F:/jboss/jboss-
3.0.3/server/efc/conf/jboss-servi
ce.xml
[...]
10:14:04,562 INFO [jbossweb] Starting Jetty/4.1
10:14:04,593 INFO [jbossweb] Started
org.mortbay.http.NCSARequestLog@8a8ce2
[...]
10:14:31,437 INFO [EjbModule] Started
10:14:31,437 INFO [EjbModule] Starting
10:14:31,484 INFO [EjbModule] Started
10:14:31,484 INFO [MainDeployer] Deployed package:
file:/F:/jboss/jboss-3.0.3/server/efc/deploy/efc.ear
10:14:31,484 INFO [URLDeploymentScanner] Started
10:14:31,500 INFO [MainDeployer] Deployed package:
file:/F:/jboss/jboss-3.0.3/server/efc/conf/jboss-service.xml
10:14:31,500 INFO [Server] JBoss (MX MicroKernel)
[3.0.3 Date:200209301503] Started in 0m:41s:750ms
10:42:25,890 INFO [STDOUT]
CPCBean.registerUserSession
10:42:25,906 INFO [STDOUT]
CPCBean.registerUserSession: Registering
userSession, key="edgar_j:Product Tester [-38522377
2]"
[...]
11:08:20,468 ERROR [STDERR]
{className="WorkspaceDAOOracle"
methodName="readRow"
componentSequenceNumber=203003 severity
=13 errorType=0 errorMessage="An SQL Exception
occurred while trying to execute statement SELECT
<cols_list> FROM <table> WHERE <where> .
The error was 72000
" dynamicContent={" SELECT <cols> FROM
<table> WHERE <etc...> ", "72000
"} nestedException.message="ORA-01000: maximum
open cursors exceeded
" nestedException.stackTrace="java.sql.SQLException:
ORA-01000: maximum open cursors exceeded
Initially, the open_cursors parameter on the database
was set to 250. This was raised to 500, but this was just
putting off the problem - not resolving it.
Querying the database shows that some sessions have
over 250 cursors - these should really expire or be aged
out. Is this a known issue?
Connecting to the JBoss server takes one or two
seconds, because of the work required to determine
access rights, therefore sessions are left connected.
The number of cursors used therefore increases quickly.
Is there a way of configuring JBoss to release cursors
more quickly?
Thanks in advance,
Bruce
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648344&group_id=22866
-------------------------------------------------------
This SF.net email is sponsored by: Microsoft Visual Studio.NET
comprehensive development tool, built to increase your
productivity. Try a free online hosted session at:
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
