Index Queue Count

In the viewindexqueue.action, from where is the count fetched from ? Is it from Database or any other action.

Example: Number of items in queue: 784960

From where is the data fetched "784960" ?

Intention is to set up alert when count increases 1000. 

1 answer

0 votes
Ann Worley Atlassian Team Jan 18, 2018

The index queue number is from the database, it is the number of items in the database that have not been stored on the file system in the index directories yet.

The number of queued items in your example is quite large. You shouldn't have to set an alert for 1000 items under most circumstances. Please let me know:

  • Is the index job running every minute as it should? Please check the History link next to the Flush Local Task Queue in the Scheduled Jobs admin page. If the job is not running as expected, this page has some possible causes: Searching and Indexing Troubleshooting
  • Is your instance quite large so that over 1000 content changes are being made in less than a minute?
  • What version of Confluence are you seeing this issue on? (The indexing functionality has been changed over time and some of our docs are no longer relevant to later versions.) 
  • Have you reindexed from scratch lately? How to Rebuild the Content Indexes From Scratch on Confluence Server

I look forward to hearing more about your instance and the indexing issue you are experiencing.



The issue with one of our plugins. Can you please let me know which DB table has Index queue number. 

Ann Worley Atlassian Team Jan 19, 2018

The journalentry table. If you need to log what exact queries Confluence is running to fetch the count, please enable SQL logging as described in: Enabling Detailed SQL Logging

I look forward to hearing how it goes.

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,479 views 4 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