#929: Run GeoNetwork with empty ORACLE database and ApacheDBCPool resource
provider causes ORA-01000: maximum open cursors exceeded
---------------------+------------------------------------------------------
Reporter: simonp | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------
Simon Pigot: Found that this was caused by Jeeves ApacheDBCPool resource
provider using DBCP parameter maxOpenPreparedStatements which tries to
cache the many sql statements that fill the empty GeoNetwork tables and
consumes all available cursors in oracle db.
Problem will also occur if this DBCP parameter is used with Jeeves
JNDIPool resource provider.
Fix is to allow the user to config this parameter in ApacheDBCPool (with
default being off) and provide advice in docs that the prepared statement
cache should not be config'd until after GeoNetwork database tables have
been created and filled.
At some stage the database creation scripts used by GeoNetwork could be
modified to use parameterized sql instead of many hundreds of individual
sql statements.
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/929>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.
#929: Run GeoNetwork with empty ORACLE database and ApacheDBCPool resource
provider causes ORA-01000: maximum open cursors exceeded
---------------------+------------------------------------------------------
Reporter: simonp | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------
Comment(by simonp):
Error was reported by ianwallen@...22... - thanks Ian!
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/929#comment:1>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.
#929: Run GeoNetwork with empty ORACLE database and ApacheDBCPool resource
provider causes ORA-01000: maximum open cursors exceeded
----------------------+-----------------------------------------------------
Reporter: simonp | Owner: geonetwork-devel@…
Type: defect | Status: closed
Priority: major | Milestone: v2.7.0
Component: General | Version:
Resolution: fixed | Keywords:
----------------------+-----------------------------------------------------
Changes (by simonp):
* status: new => closed
* resolution: => fixed
Comment:
Fixed in svn revision 9180
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/929#comment:2>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.