[Netarchivesuite-devel] ResourcePool

[Nicolas Giraud]

Hi Andreas,

Please have a look at issue NAS-1563<https://sbforge.org/jira/browse/NAS-1563>.
The connection to the harvest database now relies on a c3p0 connection pool.
There are a few new options to configure it. However it should work just
fine with MySQL... Do you have more details in the actual stack trace found
in the log?

I'll make a MySQL test on my side.

Cheers,

Nicolas Giraud

2011/4/13 <aponb at gmx.at>

> Hi!
>
> Any quick hint what the reason is?
> Just checked out, rebuilt and deployed with my deploy_standalone.xml
> settings from last version.
>
> Regards
> a.
>
>
> 13.04.2011 14:11:24
> dk.netarkivet.harvester.datamodel.HarvestDBConnection initDataSource
> INFO: Connection pool initialized with the following values:
> - minPoolSize=5
> - maxPoolSize=10
> - acquireIncrement=5
> - maxStatements=0
> - maxStatementsPerConnection=0
> 13.04.2011 14:11:53
> dk.netarkivet.harvester.datamodel.HarvestDBConnection get
> WARNUNG: Can't connect to database with DBurl:
> 'jdbc:mysql://localhost:3306/fullhddb?user=xxx&password=xxx' using
> driver 'com.mysql.jdbc.Driver'
> SQLException trace:
> SQL State:null
> Error Code:0
> java.sql.SQLException: Connections could not be acquired from the
> underlying database!
>         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
>         at
>
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
>         at
>
> com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
>         at
>
> dk.netarkivet.harvester.datamodel.HarvestDBConnection.get(HarvestDBConnection.java:103)
>         at
>
> dk.netarkivet.harvester.datamodel.TemplateDBDAO.<init>(TemplateDBDAO.java:64)
>         at
>
> dk.netarkivet.harvester.datamodel.TemplateDAO.getInstance(TemplateDAO.java:53)
>         at
>
> dk.netarkivet.harvester.webinterface.DefinitionsSiteSection.initialize(DefinitionsSiteSection.java:92)
>         at
>
> dk.netarkivet.common.webinterface.GUIWebServer.addWebApplication(GUIWebServer.java:161)
>         at
>
> dk.netarkivet.common.webinterface.GUIWebServer.<init>(GUIWebServer.java:102)
>         at
>
> dk.netarkivet.common.webinterface.GUIWebServer.getInstance(GUIWebServer.java:125)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
>
> dk.netarkivet.common.utils.ApplicationUtils.startApp(ApplicationUtils.java:170)
>         at
>
> dk.netarkivet.common.webinterface.GUIApplication.main(GUIApplication.java:39)
> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A
> ResourcePool could not acquire a resource from its primary factory or
> source.
>         at
>
> com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
>         at
>
> com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
>         at
>
> com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
>         at
>
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
>         ... 14 more
> End of SQLException trace
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>



-- 
Nicolas Giraud
---------------------------------------------------------------------------------------------
Développeur Archives du Web - Bibliothèque Nationale de France
Web Archiving Developper - National Library of France
---------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.gforge.statsbiblioteket.dk/pipermail/netarchivesuite-devel/attachments/20110413/8e182761/attachment-0001.html