Content indexing stops working

On our Confluence 5.2.3 the content indexing stops working after some time. After restarting confluence the index is rebuild.

I tried rebuilding the index from scratch, but after about 1 week the problem was back again.

Do you have any hints to resolve this problem?

3 answers

Is there any errors related to "index" in the logs? I'd suggest to enable index debug logging. To do this, from Administration >> Logging and Profiling, add the following package, and set to DEBUG:
Then,  let's try to rebuild the index from scratch and observe the situation if it makes any difference afterwards. You can refer to this documentation on how to rebuild it

I've enabled index debug logging and will check if there are any messages in the log.

I've checked the debug output. There were no errors. Rebuild the index from scratch helped only for a about a week. After that time the problem occurs again. I've got no idea what it could be. Every thing seems to be OK.

Did you see something like this from the logs:

2013-10-08 08:21:15,531 DEBUG [Indexer: 2] [] indexCollection Progress: 17762 of 17762 total objects.
2013-10-08 08:21:15,531 DEBUG [Indexer: 2] [] run Worker finished

This indicates that index has been completed for all objects which also means that the index has completed successfully instead of broken halfway.

This issue could have been caused by a third-party plugin too. To check, temporarily enable Plugin Safe Mode and see if it makes any difference. This will disabled all user-installed plugins at once. So if the issue does not occur again, it is caused by one of the third-party plugins installed. This may need to be done during non-peak hours as disabling third-party plugins would cause users unable to perform some operations provided by those plugins. Once the test has been carried out, disable this mode.

Hi, Please refer to our KB documentation on Confluence fails to process index queue automatically.

Hope this helps.

I've checked the file and the database table. There are no dates in the future.

same problem since 1 year, if I stop using the apps about 6-12h, automatic queue is stopping.

rebuilt index from scratch is not working

no futur date in database (lastmodate)...

After checking the log files of Confluence again i've found some SQL-Exceptions saying something about connection problems.

I've added these two lines to confluence.cfg.xml:

<property name="hibernate.c3p0.validate">true</property>
<property name="hibernate.c3p0.preferredTestQuery">select 1</property>
The index process stopped working again after about one week.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,416 views 3 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you