Question

This could be corruption of the Bug table. Try repairing the table.

If that didn't work, it could be the result of a giant case. If the error message gives you a case number, such as "Type: Bug ID: 17558" Try the following:

1. First reset the search index in Admin -> Site -> Search

2. If that doesn't fix it, run the following SQL on your database:

   SELECT ixBug, ixBugEvent, LENGTH(s)
   FROM BugEvent
   ORDER BY LENGTH(s) DESC
   LIMIT 20;
   

   or, for SQL Server:

   SELECT TOP 20 ixBug, ixBugEvent, DATALENGTH(s)
   FROM BugEvent
   ORDER BY DATALENGTH(s) DESC
   

This will help you see if there's a huge bug event that might be choking your indexer.