nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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?

cvillemure

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.

kevinr

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

$Photo of fracat71$ fracat71

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