[Netarchivesuite-devel] ResourcePool
aponb at gmx.at
aponb at gmx.at
Wed Apr 13 15:04:37 CEST 2011
Hi Nicolas!
Thx for helping!
Here is the complete log:
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
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
13.04.2011 14:11:53 dk.netarkivet.common.utils.ApplicationUtils
logExceptionAndPrint
SCHWERWIEGEND: Could not start class
dk.netarkivet.common.webinterface.GUIWebServer
java.lang.reflect.InvocationTargetException
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: dk.netarkivet.common.exceptions.IOFailure: Error deploying
the webapplications
at
dk.netarkivet.common.webinterface.GUIWebServer.<init>(GUIWebServer.java:105)
at
dk.netarkivet.common.webinterface.GUIWebServer.getInstance(GUIWebServer.java:125)
... 6 more
Caused by: dk.netarkivet.common.exceptions.IOFailure: 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
at
dk.netarkivet.harvester.datamodel.HarvestDBConnection.get(HarvestDBConnection.java:112)
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)
... 7 more
Caused by: 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)
... 12 more
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
13.04.2011 14:11:53 dk.netarkivet.common.utils.CleanupHook run
> 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 <mailto: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
> <mailto: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
> ---------------------------------------------------------------------------------------------
>
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-devel/attachments/20110413/13298954/attachment-0002.html>
More information about the Netarchivesuite-devel
mailing list