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
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

56 views 3 2
Join discussion

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