topic Error al iniciar segundo nodo de un cluster. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209197#M162327 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Cuando inicio el segundo nodo del cluster obtengo el siguiente error:</SPAN><BR /><BR /><SPAN>ERROR [quartz.core.JobRunShell] Job DEFAULT.org.springframework.scheduling.quartz.JobDetailBean#302609b3 threw an unhandled Exception: </SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: 08300000 Reindex failure for org.alfresco.repo.node.index.IndexTransactionTracker</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:315)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:59)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25006]; error code [0];&nbsp;&nbsp; </SPAN><BR /><SPAN>— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.&nbsp; </SPAN><BR /><SPAN>— The error occurred while applying a parameter map.&nbsp; </SPAN><BR /><SPAN>— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap.&nbsp; </SPAN><BR /><SPAN>— Check the statement (query failed).&nbsp; </SPAN><BR /><SPAN>— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; </SPAN><BR /><SPAN>— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.&nbsp; </SPAN><BR /><SPAN>— The error occurred while applying a parameter map.&nbsp; </SPAN><BR /><SPAN>— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap.&nbsp; </SPAN><BR /><SPAN>— Check the statement (query failed).&nbsp; </SPAN><BR /><SPAN>— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:364)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.insertServer(NodeDAOImpl.java:198)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:378)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:347)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.ReadWriteLockExecuter.execute(ReadWriteLockExecuter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getServerId(AbstractNodeDAOImpl.java:395)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getTxnsByCommitTimeDescending(AbstractNodeDAOImpl.java:3141)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexTransactionTracker.getLastIndexedCommitTime(IndexTransactionTracker.java:439)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexTransactionTracker.getStartingTxnCommitTime(IndexTransactionTracker.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:178)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.IndexTransactionTracker.reindexImpl(IndexTransactionTracker.java:245)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:300)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 3 more</SPAN><BR /><SPAN>Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; </SPAN><BR /><SPAN>— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.&nbsp; </SPAN><BR /><SPAN>— The error occurred while applying a parameter map.&nbsp; </SPAN><BR /><SPAN>— Check the alfresco.node.insert_Server-SelectKey-InlineParameterMap.&nbsp; </SPAN><BR /><SPAN>— Check the statement (query failed).&nbsp; </SPAN><BR /><SPAN>— Cause: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.SelectKeyStatement.executeQueryWithCallback(SelectKeyStatement.java:90)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.executeSelectKey(SqlMapExecutorDelegate.java:424)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:387)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate$8.doInSqlMapClient(SqlMapClientTemplate.java:366)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 18 more</SPAN><BR /><SPAN>Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:410)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:229)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 25 more</SPAN><BR /><BR /><BR /><SPAN>Alguna referencia al respecto.</SPAN><BR /><BR /><BR /><SPAN>Un saludo y gracias de antemano.</SPAN></BODY></HTML> Tue, 30 Sep 2014 07:43:14 GMT carlosjl 2014-09-30T07:43:14Z Error al iniciar segundo nodo de un cluster. https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209197#M162327 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 ini Tue, 30 Sep 2014 07:43:14 GMT https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209197#M162327 carlosjl 2014-09-30T07:43:14Z Re: Error al iniciar segundo nodo de un cluster. https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209198#M162328 <HTML><HEAD></HEAD><BODY><SPAN>CarlosJL, no se puede montar un clúster en Alfresco Community. Esa es una de las </SPAN><A href="http://blyx.com/2012/10/19/diferencias-entre-alfresco-enterprise-y-community/" rel="nofollow noopener noreferrer">diferencias entre Alfresco Comunity y Enterprise</A><SPAN>. Quizás sea por eso tu error.&nbsp; </SPAN><BR /><BR /><SPAN>Un saludo.</SPAN></BODY></HTML> Sat, 04 Oct 2014 19:32:34 GMT https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209198#M162328 cristinamr 2014-10-04T19:32:34Z Re: Error al iniciar segundo nodo de un cluster. https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209199#M162329 <HTML><HEAD></HEAD><BODY><SPAN>Olá </SPAN><BR /><SPAN>As tecnoogias responsáveis pelos clusters eram o " Ehcache e JGroups", porém eles foram retiradas após a versão do Alfresco Community&nbsp; 4.0.</SPAN><BR /><SPAN>Vejá esse recurso :</SPAN><BR /><A href="http://www.severalnines.com/blog/active-active-alfresco-cluster-mysql-galera-and-glusterfs" rel="nofollow noopener noreferrer">http://www.severalnines.com/blog/active-active-alfresco-cluster-mysql-galera-and-glusterfs</A><BR /></BODY></HTML> Mon, 06 Oct 2014 19:55:17 GMT https://connect.hyland.com/t5/alfresco-archive/error-al-iniciar-segundo-nodo-de-un-cluster/m-p/209199#M162329 williamsilva 2014-10-06T19:55:17Z