<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Deployment hangs on 'in progress' state in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/deployment-hangs-on-in-progress-state/m-p/238083#M191213</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello there.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I've been having problems trying to deploy to FSR. I have this scenario: 3 FSRs, 2 of them on the local network and another one to which I deploy through a WAN (let's call this one the &lt;/SPAN&gt;&lt;STRONG&gt;distant, slow FSR&lt;/STRONG&gt;&lt;SPAN&gt;). Deploying a small content succeeds on all of them. So far so good. The problem is that whenever I attempt to deploy a not so small content to the distant, slow FSR (not big also, say 15 or 20 megabytes), the deployment never finishes, Alfresco Explorer shows "in progress" forever and nothing else happens, even though it works just fine on the other 2 FSRs (the ones on the LAN). Checking the depdata directory on the FSR machine, I can see that all of the files have been uploaded and are there sitting and waiting to be moved to the target directory. Checking the logs, I get the following stacktrace regarding the action:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;10:41:29,248 ERROR [org.alfresco.repo.avm.actions.AVMDeploySnapshotAction] org.hibernate.exception.LockAcquisitionException: could not execute query&lt;BR /&gt;10:41:29,326 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed&lt;BR /&gt;java.sql.SQLException: Conexão Fechada&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:519)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:487)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:292)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:166)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:267)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.Thread.run(Thread.java:619)&lt;BR /&gt;10:41:29,326 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Application exception overridden by rollback exception&lt;BR /&gt;java.lang.Exception&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:487)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:292)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:166)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:267)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.Thread.run(Thread.java:619)&lt;BR /&gt;10:41:29,326 ERROR [org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl] Failed to execute asynchronous action: Action[ id=240bc0fb-5b43-11de-bf16-e94486ade990, node=null ]&lt;BR /&gt;org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Cannot release connection&lt;BR /&gt;Caused by: org.hibernate.exception.GenericJDBCException: Cannot release connection&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:449)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:400)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:287)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:221)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:519)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:487)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:292)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:166)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:267)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.Thread.run(Thread.java:619)&lt;BR /&gt;Caused by: java.sql.SQLException: Already closed.&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:445)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 16 more&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;By the DB errors on the stack, I figured it could be related to the database connection timing out after an idle period (since it's a bigger deployment to a distant FSR), so I changed oracle's idle timeout to 60min and tested it again with a ~10min deployment only to incur on the same problem.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Does anyone have any idea of what might be happening and how to fix it?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks in advance,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Diego&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 17 Jun 2009 15:22:45 GMT</pubDate>
    <dc:creator>diegovilar</dc:creator>
    <dc:date>2009-06-17T15:22:45Z</dc:date>
    <item>
      <title>Deployment hangs on 'in progress' state</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/deployment-hangs-on-in-progress-state/m-p/238083#M191213</link>
      <description>Hello there.I've been having problems trying to deploy to FSR. I have this scenario: 3 FSRs, 2 of them on the local network and another one to which I deploy through a WAN (let's call this one the distant, slow FSR). Deploying a small content succeeds on all of them. So far so good. The problem is t</description>
      <pubDate>Wed, 17 Jun 2009 15:22:45 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/deployment-hangs-on-in-progress-state/m-p/238083#M191213</guid>
      <dc:creator>diegovilar</dc:creator>
      <dc:date>2009-06-17T15:22:45Z</dc:date>
    </item>
    <item>
      <title>Re: Deployment hangs on 'in progress' state</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/deployment-hangs-on-in-progress-state/m-p/238084#M191214</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Alfresco 2.9 is not a version I'm familiar with.&amp;nbsp;&amp;nbsp;&amp;nbsp; But I can see from the stack trace that you provided that the problem is in createSnapshot on the authoring environment which is suffering from some sort of timeout or deadlock.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The easiest solution is probably to upgrade to a more recent version of Alfresco.&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;But if that's not an option then you may be able to&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a) Snapshot the store before attempting to deploy in parallel and pass this snapshotID into deployment rather than -1 (latest version).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;b) Control deployment such that only one deployment is done at a time.&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;A step forward would be to check that deployment to your slow FSR works if you don't have interference from your two fast FSRs.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 19 Jun 2009 17:16:24 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/deployment-hangs-on-in-progress-state/m-p/238084#M191214</guid>
      <dc:creator>mrogers</dc:creator>
      <dc:date>2009-06-19T17:16:24Z</dc:date>
    </item>
  </channel>
</rss>

