Re: [GeoNetwork-devel] "unable to open resource main-db"

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Simon,

I've confirmed that your fix below does work for our Tomcat/Oracle 
configuration -- many thanks!

--Rich

Sim...@cs... said the following on 03/05/2010 11:16 PM:
> Hi Rich,
>
> In 2.4.2 a change was made to improve perf of metadata display by moving the popularity/rating update into a separate thread (see src/org/fao/geonet/services/metadata/Show.java) - however whilst the thread opens a database connection from the pool to so the update it doesn't close it again so eventually the connection pool is exhausted - the fix is to add:
>
> context.getResourceManager().close();
>
> as the last thing done by the thread run method. (See also this code in branches/2.4.x).
>
> I reckon this would explain why things were fine in 2.4.1 etc.
>
> Cheers,
> Simon
>
>   
> ________________________________________
> From: Richard Fozzard [Ric...@no...]
> Sent: Saturday, 6 March 2010 11:03 AM
> To: geo...@li...
> Subject: Re: [GeoNetwork-devel] "unable to open resource main-db"
>
> We're seeing the same "unable to open resource main-db" error using
> Geonetwork 2.4.2 when doing repeated editing of records (FGDC and ISO both).
> We also see three other kinds of errors in the tomcat logs:
>
> (1)
> ClientAbortException:  java.net.SocketException: Broken pipe
>         at net.sf.saxon.event.XMLEmitter.close(XMLEmitter.java:265)
>         at net.sf.saxon.event.ProxyReceiver.close(ProxyReceiver.java:90)
>         at net.sf.saxon.event.ProxyReceiver.close(ProxyReceiver.java:90)
>         ...
>
> (2)
> reconnecting: 15024035>=1 ms since last connection
> reconnecting: 2>=1 ms since last connection
> reconnecting: 1>=1 ms since last connection
> reconnecting: 2>=1 ms since last connection
>
> (3)
> java.sql.SQLRecoverableException: Io exception: Connection reset
>         at
> oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
>         at
> oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
>         at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
>         ...
>
> We are running Geonetwork 2.4.2, Tomcat 5.5.25, and Oracle 10.2.0.4. We've
> also seen the errors on Tomcat 6. Watching the connections to Oracle, it
> does seem related to the "popularity" index being updated.
>
> Curiously, we DO NOT see this error in Geonetwork 2.4.1! Did something
> change in connection handling in 2.4.2?
>
> We'd sure hate to have to downgrade to get our Geonetwork working :-(
>
> Thanks for any help,
> --Rich
>
> --
>
> Richard Fozzard, Computer Scientist
>   Geospatial Metadata at NGDC: http://www.ngdc.noaa.gov/metadata
>
> Cooperative Institute for Research in Environmental Sciences (CIRES)
> Univ. Colorado & NOAA National Geophysical Data Center, Enterprise Data
> Systems
> 325 S. Broadway, Skaggs 1B-305, Boulder, CO 80305
> Office: 303-497-6487, Cell: 303-579-5615, Email: ric...@no...
>
>
>
> Hi Hoan-Vu,
>
> I'll take a look at the info you've provided (thanks) and get back later
> this week - just got back from a trip away.
>
> Cheers and thanks,
> Simon
>
> hvtranho wrote:
>   
>> Hi Simon,
>>
>> I am using the branches 2.4.x revision 5685, database is MySQL, the
>> setting
>> for the connection pool is poolSize=10, reconnectTime=undefined. I use
>> JMeter to do some stress test on the CSW interface. The methods called are
>> getCapabilities, getRecords, and getRecordsByID. The first couple of runs
>> don't show any problems, but after a pause, let say 20 minutes, these
>> exceptions raise:
>>
>> 2010-01-12 12:47:30,186 ERROR [jeeves.webapp.csw] - Raised :
>> java.lang.Exception: unable to open resource main-db after 20attempts:
>> null
>> 2010-01-12 12:47:30,188 ERROR [jeeves.webapp.csw] -  (C) Stacktrace is
>> java.lang.Exception: unable to open resource main-db after 20attempts:
>> null
>>       at jeeves.resources.dbms.DbmsPool.open(DbmsPool.java:159)
>>       at jeeves.server.resources.ResourceManager.open(ResourceManager.java:68)
>>       at
>> org.fao.geonet.kernel.csw.services.GetRecordById.execute(GetRecordById.java:91)
>>         ...
>>     
>
> --
> View this message in context: http://n2.nabble.com/unable-to-open-resource-main-db-tp3728570p4684295.html
> Sent from the GeoNetwork developer mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> GeoNetwork-devel mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
>   