AnsweredAssumed Answered

Error al iniciar segundo nodo de un cluster.

Question asked by carlosjl on Sep 30, 2014
Latest reply on Oct 6, 2014 by williamsilva
Buenos días, he configurado un cluster de 2 nodos con almacenamiento compartido con la versión community 3.4.e según la documentación.
Aparentemente, el cluster está funcionando ya que me conecto a un nodo subo documentación y desde otro navegador conectado al otro nodo veo dicho documento.

Cuando inicio el segundo nodo del cluster obtengo el siguiente error:

ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#302609b3 threw an unhandled Exception:
org.alfresco.error.AlfrescoRuntimeException: 08300000 Reindex failure for org.alfresco.repo.node.index.IndexTransactionTracker
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:315)
   at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:59)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25006]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap. 
— Check the statement (query failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap. 
— Check the statement (query failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() 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.insert(SqlMapClientTemplate.java:364)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.insertServer(NodeDAOImpl.java:198)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:378)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:347)
   at org.alfresco.util.ReadWriteLockExecuter.execute(ReadWriteLockExecuter.java:103)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getServerId(AbstractNodeDAOImpl.java:395)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getTxnsByCommitTimeDescending(AbstractNodeDAOImpl.java:3141)
   at org.alfresco.repo.node.index.IndexTransactionTracker.getLastIndexedCommitTime(IndexTransactionTracker.java:439)
   at org.alfresco.repo.node.index.IndexTransactionTracker.getStartingTxnCommitTime(IndexTransactionTracker.java:411)
   at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:181)
   at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
   at org.alfresco.repo.node.index.IndexTransactionTracker.reindexImpl(IndexTransactionTracker.java:245)
   at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:300)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:310)
   … 3 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap. 
— Check the statement (query failed). 
— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
   at com.ibatis.sqlmap.engine.mapping.statement.SelectKeyStatement.executeQueryWithCallback(SelectKeyStatement.java:90)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.executeSelectKey(SqlMapExecutorDelegate.java:424)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:387)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$8.doInSqlMapClient(SqlMapClientTemplate.java:366)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
   … 18 more
Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:410)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:229)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
   … 25 more


Alguna referencia al respecto.


Un saludo y gracias de antemano.

Outcomes