Reindexer failed to prepare required rollback

[jriker1]

Latest head as of a day or so ago, get the following errors in the logs.  Set to reindex but after done and restart again still gives the same errors.

13:25:02,859  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
13:25:08,417  ERROR [index.AbstractReindexComponent.threads] Reindexer     3 failed with error: 00190001 Failed to prepare: requires rollback.
13:25:08,481  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 00190003 Failed to prepare: requires rollback.
13:25:11,465  ERROR [index.AbstractReindexComponent.threads] Reindexer     6 failed with error: 00190009 Failed to prepare: requires rollback.
13:25:11,482  ERROR [index.AbstractReindexComponent.threads] Reindexer     7 failed with error: 00190007 Failed to prepare: requires rollback.
13:25:13,946  ERROR [index.AbstractReindexComponent.threads] Reindexer     9 failed with error: 00190005 Failed to prepare: requires rollback.
13:25:14,200  INFO  [node.index.FullIndexRecoveryComponent]     10 % complete.
13:25:26,359  INFO  [node.index.FullIndexRecoveryComponent]     20 % complete.
13:25:41,360  INFO  [node.index.FullIndexRecoveryComponent]     30 % complete.
13:25:54,390  INFO  [node.index.FullIndexRecoveryComponent]     40 % complete.
13:26:06,422  INFO  [node.index.FullIndexRecoveryComponent]     50 % complete.
13:26:19,084  INFO  [node.index.FullIndexRecoveryComponent]     60 % complete.
13:26:32,918  INFO  [node.index.FullIndexRecoveryComponent]     70 % complete.
13:26:44,798  INFO  [node.index.FullIndexRecoveryComponent]     80 % complete.
13:27:13,348  INFO  [node.index.FullIndexRecoveryComponent]     90 % complete.
13:27:30,424  INFO  [node.index.FullIndexRecoveryComponent]     100 % complete.
13:27:32,057  INFO  [node.index.FullIndexRecoveryComponent] Index recovery completed.


Any ideas?

Thanks.

JR

[clarencemei]

I have the same problem, how to do it?

[unknown-user]

Has anyone resolved this issue? Same problem here..

[jriker1]

I actually did fix this for me which didn't work for others however the fix for me was to take alfresco offline and fully delete the folder:

/local/alfresco/alf_data/lucene-indexes

then set the index.recovery.mode to FULL in my case in the /srv/tomcat6/shared/classes/alfresco-global.properties file.

Then start it up again.

JR

[liveljack]

I've got the same problem.  But after deleting the lucene-index folder and setting the recovery mode to FULL, it still comes up.

Anyone please help me~

[tim-erwin]

Check the permissions of your alf_data folder. It needs to be writable by the user who executes alfresco.

[sergiofigueras]

I got the same problem.

wow… there's no one that knows this problem, at least a little? Please, can anyone of alfresco team give us a feedback?

[cvillemure]

I Have this problem too, can't find any solution.

I'm running Alfresco 3.2r on windows

I've deleted the content of lucene-indexes and started Alfresco with
index.recovery.mode=FULL

And it comes with this kind of error log :

20:56:10,989 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: FULL
20:56:11,489 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 59,924 transactions.
20:57:13,220 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     2 failed with error: 07240001 Failed to prepare: requires rollback.
20:57:13,220 WARN  [org.alfresco.repo.node.index.AbstractReindexComponent.threads] org.alfresco.repo.search.IndexerException: 07240001 Failed to prepare: requires rollback
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.prepare(AbstractLuceneIndexerAndSearcherFactory.java:807)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:695)
   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:349)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:892)
   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:619)
Caused by: org.alfresco.repo.search.IndexerException: 07240000 TX Already active b0a52d2c-84c5-49ae-860b-4acc664fa73a
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$ActiveTransition.transition(IndexInfo.java:1782)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.setStatus(IndexInfo.java:1340)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.initialise(AbstractLuceneBase.java:111)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.getSearcher(ADMLuceneSearcherImpl.java:147)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerAndSearcherFactory.getSearcher(ADMLuceneIndexerAndSearcherFactory.java:119)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:474)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:90)
   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.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy35.getSearcher(Unknown Source)
   at org.alfresco.repo.search.SearcherComponent.selectNodes(SearcherComponent.java:106)
   at org.alfresco.repo.search.AbstractSearcherComponent.selectNodes(AbstractSearcherComponent.java:66)
   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.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 net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy24.selectNodes(Unknown Source)
   at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.onDictionaryInit(DictionaryRepositoryBootstrap.java:246)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.initDictionaryRegistry(DictionaryDAOImpl.java:254)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.access$100(DictionaryDAOImpl.java:66)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl$1.doWork(DictionaryDAOImpl.java:196)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl$1.doWork(DictionaryDAOImpl.java:189)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.initDictionary(DictionaryDAOImpl.java:187)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.getDictionaryRegistry(DictionaryDAOImpl.java:983)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.getUriToModels(DictionaryDAOImpl.java:1085)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.getModelsForUri(DictionaryDAOImpl.java:431)
   at org.alfresco.repo.dictionary.DictionaryDAOImpl.getProperty(DictionaryDAOImpl.java:701)
   at org.alfresco.repo.dictionary.DictionaryComponent.getProperty(DictionaryComponent.java:346)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.convertToPublicProperties(HibernateNodeDaoServiceImpl.java:5114)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeProperties(HibernateNodeDaoServiceImpl.java:1420)
   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.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:419)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
   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.getNodeProperties(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:1144)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:1135)
   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.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 $Proxy11.getProperties(Unknown Source)
   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.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy12.getProperties(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocumentsImpl(ADMLuceneIndexerImpl.java:601)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:590)
   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:799)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.doPrepare(ADMLuceneIndexerImpl.java:1658)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.prepare(AbstractLuceneIndexerImpl.java:472)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.prepare(AbstractLuceneIndexerAndSearcherFactory.java:802)
   … 12 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Anyone found a solution for this?

[lynnders]

I get the same error. I've tried changing folder permissions, delete lucene-indexes and set recovery mode to FULL - with no success.

I'm running Alfresco 3.2r on Fedora. I initially thought it was due to my upgrade path from 3.0 to 3.2r.

Has anyone raised this in JIRA or found a solution?

11:21:31,310  ERROR [index.AbstractReindexComponent.threads] Reindexer     2 failed with error: 07310004 Failed to prepare: requires rollback.
11:21:31,317  ERROR [index.AbstractReindexComponent.threads] Reindexer     3 failed with error: 07310003 Failed to prepare: requires rollback.
11:21:31,346  ERROR [index.AbstractReindexComponent.threads] Reindexer     4 failed with error: 07310005 Failed to prepare: requires rollback.
11:21:31,351  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 07310007 Failed to prepare: requires rollback.
11:21:39,809  INFO  [node.index.FullIndexRecoveryComponent]     10 % complete.
11:21:50,992  INFO  [node.index.FullIndexRecoveryComponent]     20 % complete.
11:22:00,248  INFO  [node.index.FullIndexRecoveryComponent]     30 % complete.
11:22:06,195  INFO  [node.index.FullIndexRecoveryComponent]     40 % complete.
11:22:14,598  INFO  [node.index.FullIndexRecoveryComponent]     50 % complete.
11:22:22,893  INFO  [node.index.FullIndexRecoveryComponent]     60 % complete.
11:22:29,071  INFO  [node.index.FullIndexRecoveryComponent]     70 % complete.
11:22:37,748  INFO  [node.index.FullIndexRecoveryComponent]     80 % complete.
11:22:48,767  INFO  [node.index.FullIndexRecoveryComponent]     90 % complete.
11:31:32,216  INFO  [node.index.FullIndexRecoveryComponent]     100 % complete.
11:31:35,919  INFO  [node.index.FullIndexRecoveryComponent] Index recovery completed.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[nicola_peluchet]

I'm having the same problem. I tried everything and i still get those errors. Has anyone found a solution?