how to check if IndexAgent is in hung state ?

Hi,

Is there any way to check whether index agent is in hung state ?

Regards

Sanjay

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

KSMatson

Yes indeed it does, you can use the following query to get a count of failed and warning queue items

select task_state, count(*) as cnt_of_queue_item from dmi_queue_item where name = 'dm_fulltext_index_user' group by name, task_state;

All comments

KSMatson

There is no flag in DA or Index Agent admin page that would indicate a hung state, either the state of the Index Agent is running or stopped.

You will have to look at the Index Agent logs to see if there are any issues with the Index Agent, or write a script that parses the log file for exceptions/Timeouts etc.
Another alternative is to write a method/job that queries the dmi_queue_item table regularly for dm_fulltext_index_user and if the queue item table grows unusually large then that could be a hint that either Index Agent or Index Server is not functioning properly.

msk

Thanks Khurram..

I have once additional query on index agent...

Does index agent update's the dmi_queue_item table with waring and failed queue items in batches after processing ?

KSMatson

Yes indeed it does, you can use the following query to get a count of failed and warning queue items

select task_state, count(*) as cnt_of_queue_item from dmi_queue_item where name = 'dm_fulltext_index_user' group by name, task_state;

msk

Is there any way to find out which objects metadata got indexed but not the content ?

KSMatson

I check the task_state attribute to see if the document got indexed or not, and when the task_state is set as 'warning' it usually means that the metadate got indexed by the content was not successfully indexed.

Select * from dmi_queue_item where task_state = 'warning';

You can run the ftintegrity tool to reindex the documents that were not successfully indexed. Search for it in the forums on how to run the ftintegrity tool or look in the 5.3 FAST fulltext admin guide for a detailed explanation.

msk

Yes, i ran ftintegrity and able to get the objects which are not indexed. But the issue is, if metadata got indexed then ftintegrity tool shows it as indexed.

Do you think, resubmit of warnings should be a good idea in this case ?

KSMatson

It is not a bad idea to resubmite those items for reindexing, but warning state could be due to many reasons, look at the 'message' for these items to see what caused such a state,

select r_object_id, item_name, item_type, event, message from dmi_queue_item where task_state = 'warning';

msk

Yes, you are right..

Thanks Khurram for your help on this..