042118314 Access Denied. The system is currently in read-onl

[ankurkhandelwal]

Hi to all,

I am using Alfresco 3.4d Enterprise Edition.
I am getting an error as Unable to delete File due to system error: 042118314 Access Denied. The system is currently in read-only mode..
when i am trying to delete any document in alfresco repository.

The error logs in catalina.out shows me the following logs

12:54:34,904  ERROR [repo.action.AsynchronousActionExecutionQueueImpl] Failed to execute asynchronous action: Action[ id=a91d1102-fa19-445a-b6b1-1104b4c8e0f6, node=null ]
org.alfresco.repo.security.permissions.AccessDeniedException: 042118247 Access Denied.  The system is currently in read-only mode.
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:295)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:412)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:415)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:662)
12:54:35,683  ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25006]; error code [0];  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   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.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:378)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:388)
   at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.updateLock(LockDAOImpl.java:144)
   at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:130)
   at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:451)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
   at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:503)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:457)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:220)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:211)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:226)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:156)
   at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:380)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:1)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
   … 15 more
Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:100)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
   … 20 more
12:55:05,695  ERROR [activities.feed.AbstractFeedGenerator] Exception during generation of feeds
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25006]; error code [0];  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   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.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:378)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:388)
   at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.updateLock(LockDAOImpl.java:144)
   at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:130)
   at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:451)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
   at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:503)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:457)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:220)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:211)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:226)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:156)
   at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred while applying a parameter map. 
— Check the alfresco.lock.update_Lock-InlineParameterMap. 
— Check the statement (update failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:380)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:1)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
   … 15 more
Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:100)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
   … 20 more



Request for urgent help.

[mitpatoliya]

your license is expired.
check  the logs during startup you will see license expired message.
You must be using the trial version.
You have to install it again in that case.

[mrogers]

3.4.d Enterprise edition does not exist. :!:    

I can't see in your extract from your log file above where it says that the license has expired, certainly that's one possibility, but there are others, including a failed upgrade.
However I agree with the advice to look earlier in the log file.

[ankurkhandelwal]

Hi mrogers,

I am using alfresco 3.4 enterprise version.I have checked and found that my license has not expired.
17:51:44,813  INFO  [service.descriptor.DescriptorService] Alfresco license: Enterprise - v3.4 granted to *********************** Co Ltd (does not expire)

Kindly help as what else can be checked by me.

It goes again and again into read only mode.
When I am trying to delete a document by repository I am getting this error.

Unable to delete File due to system error: 052625561 Access Denied. The system is currently in read-only mode

Request for your urgent help.

Regards,
Ankur

[mrogers]

Please contact alfresco support.   The first thing they will ask you for are your log files.