topic Re: Reindexer failed to prepare required rollback in Alfresco Archive

Reindexer failed to prepare required rollback

jriker1 — Tue, 19 Jan 2010 13:28:33 GMT

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] complete13:25:

Re: Reindexer failed to prepare required rollback

clarencemei — Mon, 08 Feb 2010 01:58:08 GMT

I have the same problem, how to do it?

Re: Reindexer failed to prepare required rollback

unknown-user — Fri, 26 Mar 2010 14:15:04 GMT

Has anyone resolved this issue? Same problem here..

Re: Reindexer failed to prepare required rollback

jriker1 — Fri, 26 Mar 2010 15:58:20 GMT

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

Re: Reindexer failed to prepare required rollback

liveljack — Sat, 26 Jun 2010 02:47:28 GMT

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~

Re: Reindexer failed to prepare required rollback

tim-erwin — Fri, 30 Jul 2010 08:57:52 GMT

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

Re: Reindexer failed to prepare required rollback

sergiofigueras — Fri, 20 Aug 2010 12:39:23 GMT

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?

Re: Reindexer failed to prepare required rollback

cvillemure — Tue, 24 Aug 2010 21:08:05 GMT

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?

Re: Reindexer failed to prepare required rollback

lynnders — Tue, 31 Aug 2010 13:01:09 GMT

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.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Reindexer failed to prepare required rollback

nicola_peluchet — Tue, 21 Sep 2010 15:58:44 GMT

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

Re: Reindexer failed to prepare required rollback

cvillemure — Thu, 21 Oct 2010 18:33:04 GMT

Doing the forced reindex worked with Alfresco 3.3g

However, since we were not ready to upgrade to 3.3g yet, i've written a webscript that parse my structure node by node and try to search the nodes with lucene. If lucene do not find the node, I then know there's a index corruption. When i find that kind of node, i add a tag to that node and the remove it, which force lucene to reindex this node.

Parsing my entire tree with the above scripts, also resolved my index problem.

Re: Reindexer failed to prepare required rollback

kevinr — Fri, 22 Oct 2010 09:39:21 GMT

Hi,

I think this was posted in the wrong forum which is why you haven't had much of a response! Share Developers aren't going to be much use with a repo indexer issue :shock:

From what I can see, it looks like this issue should be resolved by upgrading to 3.3, delete the indexes and perform FULL reindex.

Thanks,

Kev

Re: Reindexer failed to prepare required rollback

fracat71 — Tue, 04 Jan 2011 10:07:07 GMT

Hi,
i know that is not the rigth place of the thread but i have a similar problem.
The situation is a clusterd environment with a node down for 1 moth so i think a full reindex is needed.

17:46:38,968  ERROR [index.AbstractReindexComponent.threads] Reindexer    12 failed with error: 00030009 Failed to prepare: requires rollback.
17:46:39,122  ERROR [index.AbstractReindexComponent.threads] Reindexer    13 failed with error: 00030005 Failed to prepare: requires rollback.
17:46:39,186  ERROR [index.AbstractReindexComponent.threads] Reindexer    14 failed with error: 00030003 Failed to prepare: requires rollback.
17:46:39,263  ERROR [index.AbstractReindexComponent.threads] Reindexer    15 failed with error: 00030007 Failed to prepare: requires rollback.
18:13:22,357  INFO  [node.index.FullIndexRecoveryComponent]    10 % complete.
18:43:59,711  INFO  [node.index.FullIndexRecoveryComponent]    20 % complete.
19:14:26,183  INFO  [node.index.FullIndexRecoveryComponent]    30 % complete.
19:43:27,238  INFO  [node.index.FullIndexRecoveryComponent]    40 % complete.
20:14:08,026  INFO  [node.index.FullIndexRecoveryComponent]    50 % complete.
20:43:13,312  INFO  [node.index.FullIndexRecoveryComponent]    60 % complete.
21:10:57,492  INFO  [node.index.FullIndexRecoveryComponent]    70 % complete.
21:39:40,309  INFO  [node.index.FullIndexRecoveryComponent]    80 % complete.
22:08:08,288  INFO  [node.index.FullIndexRecoveryComponent]    90 % complete.
22:41:14,791  INFO  [node.index.FullIndexRecoveryComponent]    100 % complete.
22:41:51,916  INFO  [node.index.FullIndexRecoveryComponent] Index recovery completed.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍