AnsweredAssumed Answered

Mise à jour depuis 4.2.c vers 4.2.e

Question asked by bob.sauvage on Jan 10, 2014
Latest reply on Jan 10, 2014 by bob.sauvage
Bonjour à tous,

Après avoir mis à jour Alfresco et l'avoir lancé, voici ce que je trouve dans les logs:

2014-01-10 14:11:00,160  INFO  [alfresco.util.OpenOfficeConnectionTester] [DefaultScheduler_Worker-7] The OpenOffice connection was re-established.
2014-01-10 14:11:11,817  ERROR [repo.cache.AbstractAsynchronouslyRefreshedCache] [asynchronouslyRefreshedCacheThreadPool1] Cache update failed (webScriptsRegistryCache).
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database.  Cause: java.sql.SQLException: MaxOpenPreparedStatements limit reached
### The error may exist in alfresco/ibatis/#resource.dialect#/node-select-children-SqlMap.xml
### The error may involve alfresco.node.select.children.select_ChildAssocsOfParent_Limited
### The error occurred while executing a query
### SQL: select             assoc.id                    as id,             parentNode.id               as parentNodeId,             parentNode.version          as parentNodeVersion,             parentStore.protocol        as parentNodeProtocol,             parentStore.identifier      as parentNodeIdentifier,             parentNode.uuid             as parentNodeUuid,             childNode.id                as childNodeId,             childNode.version           as childNodeVersion,             childStore.protocol         as childNodeProtocol,             childStore.identifier       as childNodeIdentifier,             childNode.uuid              as childNodeUuid,             assoc.type_qname_id         as type_qname_id,             assoc.child_node_name_crc   as child_node_name_crc,             assoc.child_node_name       as child_node_name,             assoc.qname_ns_id           as qname_ns_id,             assoc.qname_localname       as qname_localname,             assoc.is_primary            as is_primary,             assoc.assoc_index           as assoc_index                         from             alf_child_assoc assoc             join alf_node parentNode on (parentNode.id = assoc.parent_node_id)             join alf_store parentStore on (parentStore.id = parentNode.store_id)             join alf_node childNode on (childNode.id = assoc.child_node_id)             join alf_store childStore on (childStore.id = childNode.store_id)               where             parentNode.id = ?                                                                                                                                                                                                     and 1=1                                 order by             assoc.assoc_index ASC,             assoc.id ASC
### Cause: java.sql.SQLException: MaxOpenPreparedStatements limit reached
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; MaxOpenPreparedStatements limit reached; nested exception is java.sql.SQLException: MaxOpenPreparedStatements limit reached
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
        at $Proxy5.selectList(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:196)
        at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectChildAssocs(NodeDAOImpl.java:1100)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getChildAssocs(AbstractNodeDAOImpl.java:3417)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1871)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1815)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1803)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.getChildAssocs(AbstractNodeServiceImpl.java:794)
        at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy8.getChildAssocs(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
        at $Proxy27.getChildAssocs(Unknown Source)
        at org.alfresco.repo.search.DocumentNavigator.getChildAxisIterator(DocumentNavigator.java:433)
        at org.jaxen.util.DescendantAxisIterator.next(DescendantAxisIterator.java:129)
        at org.jaxen.expr.DefaultStep.evaluate(DefaultStep.java:154)
        at org.jaxen.expr.DefaultLocationPath.evaluate(DefaultLocationPath.java:140)
        at org.jaxen.expr.DefaultAbsoluteLocationPath.evaluate(DefaultAbsoluteLocationPath.java:113)
        at org.jaxen.expr.DefaultXPathExpr.asList(DefaultXPathExpr.java:102)
        at org.jaxen.BaseXPath.selectNodesForContext(BaseXPath.java:677)
        at org.jaxen.BaseXPath.selectNodes(BaseXPath.java:216)
        at org.alfresco.repo.search.NodeServiceXPath.selectNodes(NodeServiceXPath.java:188)
        at org.alfresco.repo.search.impl.NodeSearcher.selectNodes(NodeSearcher.java:130)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.selectNodes(ADMLuceneSearcherImpl.java:497)
        at org.alfresco.repo.search.SearcherComponent.selectNodes(SearcherComponent.java:101)
        at sun.reflect.GeneratedMethodAccessor349.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy29.selectNodes(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor349.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at $Proxy29.selectNodes(Unknown Source)
        at org.alfresco.repo.web.scripts.RepoStore$3$1.execute(RepoStore.java:439)
        at org.alfresco.repo.web.scripts.RepoStore$3$1.execute(RepoStore.java:431)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
        at org.alfresco.repo.web.scripts.RepoStore$3.doWork(RepoStore.java:430)
        at org.alfresco.repo.web.scripts.RepoStore$3.doWork(RepoStore.java:427)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.web.scripts.RepoStore.getDocumentPaths(RepoStore.java:426)
        at org.springframework.extensions.webscripts.DeclarativeRegistry.initWebScripts(DeclarativeRegistry.java:231)
        at org.springframework.extensions.webscripts.DeclarativeRegistry.reset(DeclarativeRegistry.java:183)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.doBuildCache(RegistryAsynchronouslyRefreshedCache.java:83)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.access$000(RegistryAsynchronouslyRefreshedCache.java:41)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache$1.execute(RegistryAsynchronouslyRefreshedCache.java:72)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache$1.execute(RegistryAsynchronouslyRefreshedCache.java:68)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.buildCache(RegistryAsynchronouslyRefreshedCache.java:67)
        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.buildCache(RegistryAsynchronouslyRefreshedCache.java:41)
        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.doRefresh(AbstractAsynchronouslyRefreshedCache.java:464)
        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.doCall(AbstractAsynchronouslyRefreshedCache.java:449)
        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.call(AbstractAsynchronouslyRefreshedCache.java:414)
        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.call(AbstractAsynchronouslyRefreshedCache.java:45)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: MaxOpenPreparedStatements limit reached
        at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:109)
        at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
        at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:56)
        at $Proxy4.prepareStatement(Unknown Source)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50)
        at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39)
        at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55)
        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)
        at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
        … 83 more
Caused by: java.util.NoSuchElementException: Pool exhausted
        at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1130)
        at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
        … 102 more

Est-ce que ça dit quelque chose à quelqu'un ?

Merci d'avance,

Outcomes