topic Re: ReIndexación tras copia de seguridad in Alfresco Archive

ReIndexación tras copia de seguridad

javi_gimeno — Wed, 27 Oct 2010 08:47:01 GMT

Buenos días,siguiendo nuestro plan de contingencia estoy realizando un nuevo entorno para realizar pruebas. Para ello he tomado la copia de seguridad del entorno de producción para restaurar una copia idéntica en este nuevo entorno. Los entornos son los siguientesroducción:W2003 Server 32 Bits + T

Re: ReIndexación tras copia de seguridad

pjcaracuel_2349 — Wed, 27 Oct 2010 13:25:15 GMT

Hola,

Una duda que no tengo claro, cuando restauras, lo normal es borrar el contenido de los indices, todos incluidos los de backup y volver a crearlos, esto con la opcion de FULL o AUTO.

¿Es esto lo que estas haciendo?

Un Saludo

Re: ReIndexación tras copia de seguridad

javi_gimeno — Thu, 28 Oct 2010 06:36:06 GMT

Buenos días pjcaracuel,
el mas grave de mis problemas he conseguido solventarlo. Parece ser que en mi caso al reindexar el índice las prestaciones son pésimas y el tiempo empleado es muy alto. Si te fijas en el trocito de log que te he dejado abajo pasa mucho tiempo desde que empieza la reindexación ( sobre las 14h ) hasta que da el error ( sobre las 19h).

14:01:58,348 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: FULL
14:02:03,455 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Iniciada la recuperación de índices: 205.526 transaciones.
15:42:36,353 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % completado.
19:06:47,530 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.‍‍‍‍‍

Según he estado leyendo, la conexión de la aplicación Alfresco con MySQL tiene un timeout, pasado este tiempo MySQL cierra la conexión imposibilitando a la aplicación realizar operaciones sobre la misma. La variable que establece este timeout en MySQL es wait_timeout

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout'>
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout

He aumentado considerablemente el valor de esta variable y el problema con MySQL parece estar solucionado. Sin embargo aun no he podido realizar una reindexación completa. Cuando la tenga postearé mis resultados para que me aconsejes sobre si los tiempos de restauración son aceptables.

Lo que me comentas que no tienes claro, cuando realizo este proceso, tiro de la copia de seguridad y el contenido de las carpetas lucene-index y backup-lucene-index no lo borro, porque al arrancar alfresco con la opción de recovery FULL borra lucene-index completo, ¿También debería borrar la carpeta backup-lucene-index?

Un saludo.

Re: ReIndexación tras copia de seguridad

pjcaracuel_2349 — Thu, 28 Oct 2010 07:29:59 GMT

Buenos días,

Yo no tengo tiempos estimativos de reindexacion en community, pero en enterprise a partir de la versión 3.x va bastante rapido. Lo del borrado de indices y tambien del backup es porque asi incluso con AUTO te los vuelve a generar y tambien porque evitas problemas de inconsistencias.

Haz la prueba y creo que mejorara el rendimiento.

Un Saludo

Re: ReIndexación tras copia de seguridad

javi_gimeno — Fri, 29 Oct 2010 06:33:36 GMT

Buenos días pjcaracuel,
te voy a pegar los logs que tengo cuando este restaurando el indice.

09:22:39,944 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
09:22:40,012 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
09:22:40,013 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/E:/Alfresco/tomcat/shared/classes/alfresco-global.properties]
09:22:40,445 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
09:24:05,029 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Esquema gestionado por el gestor de base de datos org.hibernate.dialect.MySQLInnoDBDialect.
09:24:14,774 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No se hicieron cambios en el esquema.
09:24:25,500 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: FULL
09:24:30,540 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Iniciada la recuperación de índices: 224.373 transaciones.
09:24:40,276 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [default]
09:24:40,812 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
09:24:52,330 WARN  [org.alfresco.util.OpenOfficeConnectionTester] No se pudo establecer la conexión a OpenOffice
09:24:52,343 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default] complete
11:18:12,820 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % completado.
15:23:46,657 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    20 % completado.
16:12:27,217 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    30 % completado.
17:07:40,724 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    40 % completado.
19:03:59,632 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    50 % completado.
23:51:31,173 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
23:51:31,260 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   291 failed with error: 09280000 Exception in Transaction..
23:52:04,450 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   294 failed with error: 09280001 Exception in Transaction..
23:52:21,298 WARN  [org.springframework.jdbc.support.SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connection com.mysql.jdbc.JDBC4Connection@3830a6d1 is closed.
Caused by: java.sql.SQLException: Connection com.mysql.jdbc.JDBC4Connection@3830a6d1 is closed.
   at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:354)
   at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:310)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getMetaData(PoolingDataSource.java:234)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
   at $Proxy5.getMetaData(Unknown Source)
   at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:189)
   at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:224)
   at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:215)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:133)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:98)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.getDefaultJdbcExceptionTranslator(HibernateTransactionManager.java:741)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:715)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
23:52:47,233 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Application exception overridden by rollback exception
java.lang.Exception
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
23:52:47,243 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.  Normal retry behaviour will resume.
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot release connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Already closed.; nested exception is java.sql.SQLException: Already closed.
Caused by: java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
23:52:47,254 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   295 failed with error: 09280002 Exception in Transaction..
00:08:12,367 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   296 failed with error: 09290003 Exception in Transaction..
01:05:28,350 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   305 failed with error: 09290004 Exception in Transaction..
01:10:29,001 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   307 failed with error: 09290005 Exception in Transaction..
01:10:29,009 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   308 failed with error: 09290006 Exception in Transaction..
01:53:03,049 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
02:05:47,067 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   317 failed with error: 09290007 Exception in Transaction..
02:05:47,073 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   318 failed with error: 09290008 Exception in Transaction..
02:05:47,091 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Application exception overridden by rollback exception
java.lang.Exception
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
02:05:47,092 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.  Normal retry behaviour will resume.
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot release connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Already closed.; nested exception is java.sql.SQLException: Already closed.
Caused by: java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
02:05:47,094 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   319 failed with error: 09290009 Exception in Transaction..
02:46:59,950 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   320 failed with error: 09290010 Exception in Transaction..
03:12:22,123 ERROR [net.sf.ehcache.store.DiskStore] org.alfresco.cache.encodingEntityCache Cache: Could not expire elements from disk due to Java heap space. Continuing…
java.lang.OutOfMemoryError: Java heap space
03:12:58,466 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   321 failed with error: 09290011 Exception in Transaction..
03:12:58,477 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   322 failed with error: 09290012 Exception in Transaction..
03:31:19,913 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   323 failed with error: 09290013 Exception in Transaction..
03:31:19,944 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   324 failed with error: 09290014 Exception in Transaction..
03:31:31,316 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   325 failed with error: 09290015 Exception in Transaction..
03:53:53,882 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   326 failed with error: 09290016 Exception in Transaction..
03:53:53,894 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   327 failed with error: 09290017 Exception in Transaction..
03:53:53,906 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   328 failed with error: 09290018 Exception in Transaction..
03:53:53,914 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   329 failed with error: 09290019 Exception in Transaction..
04:33:01,010 ERROR [net.sf.ehcache.store.DiskStore] org.alfresco.cache.encodingEntityCache Cache: Could not expire elements from disk due to Java heap space. Continuing…
java.lang.OutOfMemoryError: Java heap space
07:12:10,455 ERROR [net.sf.ehcache.store.DiskStore] org.alfresco.cache.encodingEntityCache Cache: Could not expire elements from disk due to Java heap space. Continuing…
java.lang.OutOfMemoryError: Java heap space
07:12:34,989 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   331 failed with error: 09290020 Exception in Transaction..
07:12:34,994 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   330 failed with error: 09290021 Exception in Transaction..
07:12:35,002 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   332 failed with error: 09290022 Exception in Transaction..
07:12:35,018 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   333 failed with error: 09290023 Exception in Transaction..
07:12:35,033 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   334 failed with error: 09290024 Exception in Transaction..
08:11:20,084 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   335 failed with error: 09290025 Exception in Transaction..

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

A todo esto, no es que se nos haya roto nada, sino que haciendo un plan de contingencia y migración, se nos ha ocurrido restaurar todo el repositorio del servidor de producción en uno de pruebas y veo que el rendimiento es muy pobre y si al menos acabara restaurandolo pues se podría asumir. Pero aun no he conseguido restaurar un repositorio grande. Según me he documentado creo que no me estoy dejando ningún paso a la hora de restaurar. Si la razón es que falta máquina, que le debo asignar 8GB al JVM???.

Ahora mismo, aun tengo el tomcat levantado, no se si apagarlo y asignarle mas recursos, si cambiar la base de datos (porque el error parece que siempre viene del MySQL)…..

Re: ReIndexación tras copia de seguridad

pjcaracuel_2349 — Fri, 29 Oct 2010 06:52:54 GMT

Hola Javier,

Yo he restaurado entornos con un volumen aproximado de 4-5 Gb de contenidos y sin problemas. Ademas era relativamente rapido y con menos recursos que tu, la unica diferencia es la bbdd que era Oracle.

Porque no pruebas a poner en log4j a debug las entradas de bbdd a ver si nos dan algo de informacion puesto que todo apunta a que es problema de ella.

Un Saludo

Re: ReIndexación tras copia de seguridad

javi_gimeno — Fri, 29 Oct 2010 07:13:38 GMT

Buena idea, te parece que active estas propiedades??:

# Hibernate
log4j.logger.org.hibernate=error
log4j.logger.org.hibernate.util.JDBCExceptionReporter=fatal
log4j.logger.org.hibernate.event.def.AbstractFlushingEventListener=fatal
log4j.logger.org.hibernate.type=warn
log4j.logger.org.hibernate.cfg.SettingsFactory=warn

# Indexer debugging
log4j.logger.org.alfresco.repo.search.Indexer=error
#log4j.logger.org.alfresco.repo.search.Indexer=debug

log4j.logger.org.alfresco.repo.search.impl.lucene.index=error
#log4j.logger.org.alfresco.repo.search.impl.lucene.index=DEBUG‍‍‍‍‍‍‍‍‍‍‍‍‍

Para que esto funcione tendre que reiniciar Alfresco y empezar de nuevo…
Otra cosa que no tengo muy clara en cuanto a rendimiento es el combo de sistema operativo con base de datos. Por motivos de integración con el resto de sistemas de mi empresa es importante que la instalación de alfresco sea en un entorno windows, por eso en todos los entorno que monto usamos w2003 server o ahora que estoy probando w2008 64bits. Según he leido el rendimiento entre un sistema linux o uno windows es similar, por ello nos hemos decantado por el segundo. También comentan que el combo idoneo suele ser linux + mysql o bien windows + sql server. En mi caso tengo windows + mysql, ya que venía con el paquete por defecto cuando lo instalamos en su día y me he acostumbrado a instalarlo junto a mysql.
¿Crees que sería positivo instalarlo con sql server?. Por eso no tendría problemas, ya que tenemos muchos sistemas con sql server y no sería ningún inconveniente, lo único que la base de datos estaría en otra máquina, cuando ahora lo tengo todo junto en la misma.

Gracias por tu ayuda, recibe un cordial saludo.

Re: ReIndexación tras copia de seguridad

pjcaracuel_2349 — Fri, 29 Oct 2010 11:05:18 GMT

Lo de las trazas estan bien.

De todas formas, para ver el stack recomendado por alfresco, si no lo has hecho ya claro esta:
http://www.alfresco.com/services/subscription/supported-platforms/3-x/

Yo solo trabajo con servidores linux, asi que de windows ando mas pillado.

Un Saludo

Re: ReIndexación tras copia de seguridad

javi_gimeno — Fri, 29 Oct 2010 11:20:28 GMT

Aquí viene el primer crash de hoy!

13:13:33,325 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 4127 objects
13:13:33,326 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 4286 collections
13:13:33,326 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 4227 objects
13:13:33,327 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 4250 collections
13:13:43,261 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
13:13:43,264 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
13:13:43,341 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 5845 objects
13:13:43,341 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 6096 collections
13:14:02,504 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select childassoc0_.id as id7_0_, nodeimpl1_.id as id4_1_, nodeimpl2_.id as id4_2_, childassoc0_.version as version7_0_, childassoc0_.parent_node_id as parent3_7_0_, childassoc0_.type_qname_id as type4_7_0_, childassoc0_.child_node_name_crc as child5_7_0_, childassoc0_.child_node_name as child6_7_0_, childassoc0_.child_node_id as child7_7_0_, childassoc0_.qname_ns_id as qname8_7_0_, childassoc0_.qname_localname as qname9_7_0_, childassoc0_.is_primary as is10_7_0_, childassoc0_.assoc_index as assoc11_7_0_, nodeimpl1_.version as version4_1_, nodeimpl1_.store_id as store3_4_1_, nodeimpl1_.uuid as uuid4_1_, nodeimpl1_.transaction_id as transact5_4_1_, nodeimpl1_.node_deleted as node6_4_1_, nodeimpl1_.type_qname_id as type7_4_1_, nodeimpl1_.acl_id as acl8_4_1_, nodeimpl1_.audit_creator as audit9_4_1_, nodeimpl1_.audit_created as audit10_4_1_, nodeimpl1_.audit_modifier as audit11_4_1_, nodeimpl1_.audit_modified as audit12_4_1_, nodeimpl1_.audit_accessed as audit13_4_1_, nodeimpl2_.version as version4_2_, nodeimpl2_.store_id as store3_4_2_, nodeimpl2_.uuid as uuid4_2_, nodeimpl2_.transaction_id as transact5_4_2_, nodeimpl2_.node_deleted as node6_4_2_, nodeimpl2_.type_qname_id as type7_4_2_, nodeimpl2_.acl_id as acl8_4_2_, nodeimpl2_.audit_creator as audit9_4_2_, nodeimpl2_.audit_created as audit10_4_2_, nodeimpl2_.audit_modifier as audit11_4_2_, nodeimpl2_.audit_modified as audit12_4_2_, nodeimpl2_.audit_accessed as audit13_4_2_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodeimpl2_.id where nodeimpl2_.id=? order by childassoc0_.assoc_index, childassoc0_.id]
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 13365 ms ago.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.doList(Loader.java:2213)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   at org.hibernate.loader.Loader.list(Loader.java:2099)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$31.doInHibernate(HibernateNodeDaoServiceImpl.java:3163)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getParentAssocsInternal(HibernateNodeDaoServiceImpl.java:3166)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getParentAssocs(HibernateNodeDaoServiceImpl.java:3197)
   at sun.reflect.GeneratedMethodAccessor281.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy7.getParentAssocs(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getParentAssocs(DbNodeServiceImpl.java:1404)
   at org.alfresco.repo.node.AbstractNodeServiceImpl.getParentAssocs(AbstractNodeServiceImpl.java:580)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:169)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getParentAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getParentAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy10.getParentAssocs(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.getNodeCounts(ADMLuceneIndexerImpl.java:1322)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:578)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:632)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:657)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.flushPending(AbstractLuceneIndexerImpl.java:789)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.addCommand(AbstractLuceneIndexerImpl.java:691)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.reindex(AbstractLuceneIndexerImpl.java:668)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateNode(ADMLuceneIndexerImpl.java:264)
   at org.alfresco.repo.search.IndexerComponent.updateNode(IndexerComponent.java:80)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindexTransaction(AbstractReindexComponent.java:622)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable$1.execute(AbstractReindexComponent.java:758)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
Caused by: java.net.SocketException: Connection reset
   at java.net.SocketInputStream.read(SocketInputStream.java:168)
   at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
   at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
   at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
   at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2452)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)
   … 81 more
13:14:02,530 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select nodeimpl0_.id as id4_0_, dbaccessco1_.id as id14_1_, nodeimpl0_.version as version4_0_, nodeimpl0_.store_id as store3_4_0_, nodeimpl0_.uuid as uuid4_0_, nodeimpl0_.transaction_id as transact5_4_0_, nodeimpl0_.node_deleted as node6_4_0_, nodeimpl0_.type_qname_id as type7_4_0_, nodeimpl0_.acl_id as acl8_4_0_, nodeimpl0_.audit_creator as audit9_4_0_, nodeimpl0_.audit_created as audit10_4_0_, nodeimpl0_.audit_modifier as audit11_4_0_, nodeimpl0_.audit_modified as audit12_4_0_, nodeimpl0_.audit_accessed as audit13_4_0_, dbaccessco1_.version as version14_1_, dbaccessco1_.acl_id as acl3_14_1_, dbaccessco1_.latest as latest14_1_, dbaccessco1_.acl_version as acl5_14_1_, dbaccessco1_.inherits as inherits14_1_, dbaccessco1_.inherits_from as inherits7_14_1_, dbaccessco1_.type as type14_1_, dbaccessco1_.inherited_acl as inherited9_14_1_, dbaccessco1_.is_versioned as is10_14_1_, dbaccessco1_.requires_version as requires11_14_1_, dbaccessco1_.acl_change_set as acl12_14_1_ from alf_node nodeimpl0_ left outer join alf_access_control_list dbaccessco1_ on nodeimpl0_.acl_id=dbaccessco1_.id where nodeimpl0_.store_id=? and nodeimpl0_.uuid=?]
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 13365 ms ago.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.doList(Loader.java:2213)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   at org.hibernate.loader.Loader.list(Loader.java:2099)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$6.doInHibernate(HibernateNodeDaoServiceImpl.java:797)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeOrNull(HibernateNodeDaoServiceImpl.java:800)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeRefStatus(HibernateNodeDaoServiceImpl.java:744)
   at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy7.getNodeRefStatus(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getNodeStatus(DbNodeServiceImpl.java:181)
   at sun.reflect.GeneratedMethodAccessor230.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:169)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getNodeStatus(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor230.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getNodeStatus(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor230.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy10.getNodeStatus(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor230.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getNodeStatus(Unknown Source)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindexTransaction(AbstractReindexComponent.java:603)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable$1.execute(AbstractReindexComponent.java:758)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
Caused by: java.net.SocketException: Connection reset
   at java.net.SocketInputStream.read(SocketInputStream.java:168)
   at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
   at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
   at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
   at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2452)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)
   … 88 more
13:14:02,504 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select nodeimpl0_.id as id4_0_, dbaccessco1_.id as id14_1_, nodeimpl0_.version as version4_0_, nodeimpl0_.store_id as store3_4_0_, nodeimpl0_.uuid as uuid4_0_, nodeimpl0_.transaction_id as transact5_4_0_, nodeimpl0_.node_deleted as node6_4_0_, nodeimpl0_.type_qname_id as type7_4_0_, nodeimpl0_.acl_id as acl8_4_0_, nodeimpl0_.audit_creator as audit9_4_0_, nodeimpl0_.audit_created as audit10_4_0_, nodeimpl0_.audit_modifier as audit11_4_0_, nodeimpl0_.audit_modified as audit12_4_0_, nodeimpl0_.audit_accessed as audit13_4_0_, dbaccessco1_.version as version14_1_, dbaccessco1_.acl_id as acl3_14_1_, dbaccessco1_.latest as latest14_1_, dbaccessco1_.acl_version as acl5_14_1_, dbaccessco1_.inherits as inherits14_1_, dbaccessco1_.inherits_from as inherits7_14_1_, dbaccessco1_.type as type14_1_, dbaccessco1_.inherited_acl as inherited9_14_1_, dbaccessco1_.is_versioned as is10_14_1_, dbaccessco1_.requires_version as requires11_14_1_, dbaccessco1_.acl_change_set as acl12_14_1_ from alf_node nodeimpl0_ left outer join alf_access_control_list dbaccessco1_ on nodeimpl0_.acl_id=dbaccessco1_.id where nodeimpl0_.store_id=? and nodeimpl0_.uuid=?]
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 13367 ms ago.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.doList(Loader.java:2213)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   at org.hibernate.loader.Loader.list(Loader.java:2099)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$6.doInHibernate(HibernateNodeDaoServiceImpl.java:797)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeOrNull(HibernateNodeDaoServiceImpl.java:800)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodePair(HibernateNodeDaoServiceImpl.java:1161)
   at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy7.getNodePair(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getNodePairNotNull(DbNodeServiceImpl.java:155)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getParentAssocs(DbNodeServiceImpl.java:1400)
   at org.alfresco.repo.node.AbstractNodeServiceImpl.getParentAssocs(AbstractNodeServiceImpl.java:580)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:169)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getParentAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getParentAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy10.getParentAssocs(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.getNodeCounts(ADMLuceneIndexerImpl.java:1322)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:578)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:632)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:657)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.flushPending(AbstractLuceneIndexerImpl.java:789)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.addCommand(AbstractLuceneIndexerImpl.java:691)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.reindex(AbstractLuceneIndexerImpl.java:668)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateNode(ADMLuceneIndexerImpl.java:264)
   at org.alfresco.repo.search.IndexerComponent.updateNode(IndexerComponent.java:80)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindexTransaction(AbstractReindexComponent.java:622)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable$1.execute(AbstractReindexComponent.java:758)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
Caused by: java.net.SocketException: Connection reset
   at java.net.SocketInputStream.read(SocketInputStream.java:168)
   at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
   at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
   at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
   at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2452)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)
   … 83 more
13:14:02,689 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01
13:14:02,620 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01
13:14:02,617 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01
13:14:02,752 ERROR [org.hibernate.util.JDBCExceptionReporter] Communications link failure

Last packet sent to the server was 13365 ms ago.
13:14:02,753 ERROR [org.hibernate.util.JDBCExceptionReporter] Communications link failure

Last packet sent to the server was 13367 ms ago.
13:14:02,756 ERROR [org.hibernate.util.JDBCExceptionReporter] Communications link failure

Last packet sent to the server was 13365 ms ago.
13:14:02,886 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:02,904 DEBUG [org.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:02,906 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
13:14:02,906 ERROR [org.hibernate.util.JDBCExceptionReporter] Already closed.
13:14:02,908 DEBUG [org.hibernate.util.JDBCExceptionReporter] Cannot release connection [???]
java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:02,908 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
13:14:02,909 ERROR [org.hibernate.util.JDBCExceptionReporter] Already closed.
13:14:02,918 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:02,948 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:03,001 DEBUG [org.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
13:14:03,002 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
13:14:03,002 ERROR [org.hibernate.util.JDBCExceptionReporter] Already closed.
13:14:03,002 DEBUG [org.hibernate.util.JDBCExceptionReporter] Cannot release connection [???]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: ReIndexación tras copia de seguridad

pjcaracuel_2349 — Fri, 29 Oct 2010 11:43:28 GMT

El error apunta a que se cae la bbdd no? LA query que aparece en el log, la podrias lanzar contra la bbdd y ver si te peta o no.

Un Saludo

Re: ReIndexación tras copia de seguridad

javi_gimeno — Fri, 29 Oct 2010 12:14:29 GMT

Sería lo lógico pero si te fijas en la consulta hay un parametro que recibirá por algún lado:

where nodeimpl2_.id=? order by childassoc0_.assoc_index, childassoc0_.id‍

No obstante en producción donde tengo la versión de 32 bits nunca me había ocurrido que Alfresco tumbara el MySQL. Bueno, realmente no creo que lo tumbe, sino que la conexión la corta por timeout….

Re: ReIndexación tras copia de seguridad

mikel_asla1 — Wed, 03 Nov 2010 17:30:30 GMT

Esto tiene toda la pinta de configuración de Mysql en Windows, ya que el Indexer no esta diciendo nada, parece un problema puramente de perdida de sesión con la bbdd, ¿Donde has leído que Windows da el mismo rendimiento que Linux?
Por poner un ejemplo tontaco te diré, que sobre el papel, el modulo VTI funciona igual en Windows que en Linux, sin embargo, hasta que no modificas unas entradas en el registro de Windows, no funciona
Este tipo de cosas no están documentadas, etc, en Linux simplemente funciona, y punto.

Re: ReIndexación tras copia de seguridad

javi_gimeno — Thu, 04 Nov 2010 08:32:35 GMT

Hola Mikel,
en primer lugar comentarte que en mi empresa el entorno mayoritario es microsoft, por ello entre otras cosas instalamos en el servidor de producción windows 2003 server. Las pruebas que estoy realizando es para realizar la migración a 64bits a ser posible con un windows 2008 server 64bits, ambos sistemas operativos certificados por Alfresco. Lo que me comentas del rendimiento, creo haberlo leido en un libro de alfresco que tiene una flor amarilla en la portada, ahora mismo no recuerdo su nombre. En cualquier caso si el rendimiento en windows es un 5% (por ejemplo) peor que en linux es algo que podemos asumir en beneficio de una mejor integración con nuestro sistema.
No obstante no me caso con nadie, y creo que para cada ámbito tienes que adecuarte a la mejor opción posible. No dudo que un entorno linux te proporcione un sistema mas robusto, fiable y seguro, pero intento amoldarme a lo que tengo en la empresa.

Estoy contigo en que el error proviene de la base de datos, que por algún motivo corta la conexión… estoy haciendo pruebas intentando dar con la solución… por ello en un siguiente paso no se si probar migrar la bbdd de mysql a sql server y lanzar el proceso de nuevo (pensando en una posible mejor integración windows sql server), o bien tirar este servidor virtual con w2008 a la basura y realizar una instalación limpia con una distro de linux 64 con mysql y ver el rendimiento…
¿que me aconsejáis?.

Gracias y un saludo.

Re: ReIndexación tras copia de seguridad

javi_gimeno — Thu, 04 Nov 2010 08:59:02 GMT

En mi última prueba, arrancando alfresco con estos parametros

set JAVA_OPTS=-server -Xcomp -Xbatch -Xss1M -Xms2G -Xmx4G -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=1G -XX:MaxPermSize=512M -XX:CMSInitiatingOccupancyFraction=80

Y le estoy dando a MySQL 2Gb de RAM…


09:53:30,772 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Iniciada la recuperación de índices: 224.373 transaciones.‍‍

va pasando el tiempo….

16:40:26,159 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    40 % completado.
16:53:49,454 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
16:53:49,456 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
16:53:49,499 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2883 objects
16:53:49,500 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 3576 collections
16:55:01,824 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
16:55:01,830 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
16:55:01,930 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2633 objects
16:55:01,931 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 2582 collections
16:57:21,540 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
16:57:21,543 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
16:57:21,582 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2918 objects
16:57:21,583 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 3158 collections
17:05:49,921 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:05:49,923 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:05:49,957 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2698 objects
17:05:49,957 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 3260 collections
17:08:45,486 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:08:45,488 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:08:45,523 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2993 objects
17:08:45,524 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 3816 collections
17:09:03,444 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:09:03,447 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:09:03,488 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2482 objects
17:09:03,488 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 2948 collections
17:11:10,351 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:11:10,354 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:11:10,388 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2449 objects
17:11:10,388 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 2732 collections
17:21:11,373 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:21:11,377 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:21:11,700 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 5887 objects
17:21:11,713 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 11616 collections
17:49:15,671 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:49:15,674 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:49:15,709 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 3220 objects
17:49:15,710 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 4272 collections
17:51:20,085 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
17:51:20,088 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
17:51:20,125 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2620 objects
17:51:20,125 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 2580 collections
17:59:37,045 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    50 % completado.
19:11:21,194 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
19:11:21,204 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
19:11:21,232 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 2655 objects
19:11:21,232 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 3054 collections
19:22:34,125 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    60 % completado.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

me parte el fichero de logs… y en el siguiente fichero, PUM

00:52:43,333 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index cleaner failed with 
java.lang.OutOfMemoryError: Java heap space
00:52:43,416 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select childassoc0_.id as id7_0_, nodeimpl1_.id as id4_1_, nodeimpl2_.id as id4_2_, childassoc0_.version as version7_0_, childassoc0_.parent_node_id as parent3_7_0_, childassoc0_.type_qname_id as type4_7_0_, childassoc0_.child_node_name_crc as child5_7_0_, childassoc0_.child_node_name as child6_7_0_, childassoc0_.child_node_id as child7_7_0_, childassoc0_.qname_ns_id as qname8_7_0_, childassoc0_.qname_localname as qname9_7_0_, childassoc0_.is_primary as is10_7_0_, childassoc0_.assoc_index as assoc11_7_0_, nodeimpl1_.version as version4_1_, nodeimpl1_.store_id as store3_4_1_, nodeimpl1_.uuid as uuid4_1_, nodeimpl1_.transaction_id as transact5_4_1_, nodeimpl1_.node_deleted as node6_4_1_, nodeimpl1_.type_qname_id as type7_4_1_, nodeimpl1_.acl_id as acl8_4_1_, nodeimpl1_.audit_creator as audit9_4_1_, nodeimpl1_.audit_created as audit10_4_1_, nodeimpl1_.audit_modifier as audit11_4_1_, nodeimpl1_.audit_modified as audit12_4_1_, nodeimpl1_.audit_accessed as audit13_4_1_, nodeimpl2_.version as version4_2_, nodeimpl2_.store_id as store3_4_2_, nodeimpl2_.uuid as uuid4_2_, nodeimpl2_.transaction_id as transact5_4_2_, nodeimpl2_.node_deleted as node6_4_2_, nodeimpl2_.type_qname_id as type7_4_2_, nodeimpl2_.acl_id as acl8_4_2_, nodeimpl2_.audit_creator as audit9_4_2_, nodeimpl2_.audit_created as audit10_4_2_, nodeimpl2_.audit_modifier as audit11_4_2_, nodeimpl2_.audit_modified as audit12_4_2_, nodeimpl2_.audit_accessed as audit13_4_2_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodeimpl2_.id where nodeimpl2_.id=? order by childassoc0_.assoc_index, childassoc0_.id]
java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:430)
   at com.mysql.jdbc.PreparedStatement.getInstance(PreparedStatement.java:561)
   at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1395)
   at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4178)
   at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4077)
   at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
   at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
   at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
   at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
   at org.hibernate.loader.Loader.doQuery(Loader.java:673)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.doList(Loader.java:2213)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
   at org.hibernate.loader.Loader.list(Loader.java:2099)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$31.doInHibernate(HibernateNodeDaoServiceImpl.java:3163)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getParentAssocsInternal(HibernateNodeDaoServiceImpl.java:3166)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getParentAssocs(HibernateNodeDaoServiceImpl.java:3197)
   at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy7.getParentAssocs(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.prependPaths(DbNodeServiceImpl.java:1767)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.prependPaths(DbNodeServiceImpl.java:1863)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPaths(DbNodeServiceImpl.java:1899)
   at sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:169)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getPaths(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getPaths(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy10.getPaths(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:584)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:632)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:657)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.flushPending(AbstractLuceneIndexerImpl.java:789)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.doPrepare(ADMLuceneIndexerImpl.java:1633)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.prepare(AbstractLuceneIndexerImpl.java:472)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.prepare(AbstractLuceneIndexerAndSearcherFactory.java:792)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:667)
   at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:835)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:645)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:467)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:340)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   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)
00:52:43,334 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index cleaner failed with 
java.lang.OutOfMemoryError: Java heap space
00:52:43,334 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index merger failed with 
java.lang.OutOfMemoryError: Java heap space
   at org.apache.lucene.index.TermBuffer.toTerm(TermBuffer.java:122)
   at org.apache.lucene.index.SegmentTermEnum.term(SegmentTermEnum.java:167)
   at org.apache.lucene.index.TermInfosReader.ensureIndexIsRead(TermInfosReader.java:178)
   at org.apache.lucene.index.TermInfosReader.get(TermInfosReader.java:225)
   at org.apache.lucene.index.TermInfosReader.get(TermInfosReader.java:218)
   at org.apache.lucene.index.SegmentTermDocs.seek(SegmentTermDocs.java:55)
   at org.apache.lucene.index.IndexReader.termDocs(IndexReader.java:780)
   at org.apache.lucene.index.IndexReader.deleteDocuments(IndexReader.java:868)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.mergeDeletions(IndexInfo.java:3433)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.runImpl(IndexInfo.java:3155)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$AbstractSchedulable.run(IndexInfo.java:2995)
   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)
00:53:03,906 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index cleaner recovered from 
java.lang.OutOfMemoryError: Java heap space
00:53:03,880 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: S1000
00:52:43,547 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index cleaner recovered from 
java.lang.OutOfMemoryError: Java heap space
00:53:03,968 ERROR [org.hibernate.util.JDBCExceptionReporter] java.lang.OutOfMemoryError: Java heap space
00:53:24,407 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=87b472ba-a5cc-4f03-b98d-0b64d1fe13cc Type=INDEX Status=COMMITTED Docs=1815260 Deletions=0 
00:53:24,408 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=1362b5ce-c5e8-40b3-abbf-8da22d057848 Type=INDEX Status=COMMITTED Docs=621218 Deletions=0 
00:53:24,408 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=1fcdb575-8420-42cd-9f21-4278a61febfa Type=INDEX Status=COMMITTED Docs=130823 Deletions=0 
00:53:24,408 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=38639dbf-071f-4471-b1d3-b63f8d5b70c2 Type=INDEX Status=COMMITTED Docs=6655 Deletions=0 
00:53:24,408 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=079c55cc-6246-49ca-8d1b-3eea1d26e66a Type=INDEX Status=COMMITTED Docs=6332 Deletions=0 
00:53:24,408 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=81c3da3a-8c04-402a-ac85-18bec3b247aa Type=DELTA Status=COMMITTED_DELETING Docs=326 Deletions=179 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=af656326-cfe9-4f95-9f8a-2ec773b6fd17 Type=DELTA Status=COMMITTED_DELETING Docs=501 Deletions=294 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=0f2d1e23-c2e7-4837-8346-75282e71686f Type=DELTA Status=COMMITTED_DELETING Docs=496 Deletions=293 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=2c5ce077-b841-4266-96aa-d6b8c612c8c1 Type=DELTA Status=COMMITTED_DELETING Docs=465 Deletions=277 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=46e500b0-c35d-474b-ae41-f433fda4fa16 Type=DELTA Status=COMMITTED_DELETING Docs=637 Deletions=392 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=8d84aaf9-e296-432b-9684-b4778864134f Type=DELTA Status=COMMITTED_DELETING Docs=324 Deletions=178 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: Resetting merge and committed_deleting to committed  Name=1a5e0fb7-91f3-4656-b393-8843baf59c89 Type=DELTA Status=COMMITTED_DELETING Docs=350 Deletions=193 
00:53:24,409 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=71b396ca-3d80-4ae3-a28b-5b983847d16a Type=DELTA Status=PREPARING Docs=0 Deletions=0 
00:53:24,412 INFO  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Roll back merge: leaving index entry  Name=0e175f7c-77b9-4084-a51b-6af021695253 Type=DELTA Status=PREPARING Docs=0 Deletions=0 
00:53:24,432 WARN  [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index merger recovered from 
java.lang.OutOfMemoryError: Java heap space‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

lo último que esperaba era un java heap space… son 4Gb… debo asignarle mas memoria a alfresco y quitarsela a mysql??, no son excesivos 4Gb para recuperar este índice…. no acabo de entender muy bien lo que estoy viendo.

Re: ReIndexación tras copia de seguridad

fegor — Tue, 09 Nov 2010 09:30:10 GMT

¿Has probado a reindexar tu Alfresco nativo?, o sea, el que tienes en win2k3. Haz antes una copia de tu lucene-indexes y luego borra ese directorio y haces un FULL.

Si te funciona, todo correcto, es decir, no hay problema de inconsistencias de ningún tipo, por tanto te quedan dos cosas a mi entender.

1. La base de datos, por algún motivo deja de responder, eso es configuración de esta y del win2k8 que puede ser que cierre puertos, ya que como sabes Alfresco se comunica con mysql por TCP, generalmente el TCP3306.

2. La configuración de máquina JVM, no depende de la heap solamente, sino también de equilibrar bien la memoria de pila y la Perm. Prueba con otra configuración a ver que pasa, por ejemplo:


set JAVA_OPTS=-Xss128k -Xms1536m -Xmx1536m -XX:PermSize=256m -XX:MaxPermSize=256m -server 
‍‍‍

Se que tu máquina es 64 bits y por tanto la -Xmx podría ser mayor de 1,5Gb. pero es para adecuarlo más a tu entorno original y por otra parte, porque creo que no necesitas tanta heap para eso.

Un saludo.

Re: ReIndexación tras copia de seguridad

javi_gimeno — Tue, 09 Nov 2010 10:06:05 GMT

Hola Fernando, gracias por tu respuesta. Lo ideal sería realizar la reindexación en un entorno exactamente idéntico. Si te digo la verdad, solo de pensar que tengo que hacer la reindexación en producción me entra canguelo solo de pensarlo. Es un servicio que se utiliza todos los días y no sería muy conveniente tenerlo parado mucho tiempo, además nadie me garantiza que se recupere correctamente.
Por esto estamos desarrollando un plan de contingencia para estos casos, para agilizar las pruebas trabajamos con máquina virtuales. He realizado pruebas de recuperación en caso de perdida del entorno de desarrollo que tengo (con win2k3) y con muchísimos menos datos y ha funcionado correctamente. Para hacer lo que tu me recomiendas, tengo una máquina virtual con un win2k3, pero no se porque razón no me deja asignar mas de unos 750mb al jvm. En cualquier caso las pruebas que vaya realizando las postearé por si son de ayuda para demás usuarios.

Re: ReIndexación tras copia de seguridad

mikel_asla1 — Tue, 09 Nov 2010 10:28:11 GMT

Una cosa, sigues con 4 Gigas de RAM?, si le estas dando toda la memoria de la maquina al proceso Java….. malo. La verdad es que el volumen de repositorio que comentas no me parece tan grande para dar los problemas que estas teniendo, yo he restaurado entornos "pareecidos" sin grandes problemas, eso si, siempre en Linux. Windows es muy dado a poner limites por todos lados en su registro, yo pensaría en cosas sencillas de estas, ya que con la configuración que te ha propuesto Fernando, debería ser más que suficiente.

Bueno a ver si entre todos podemos dar con la clave.
Un saludo