Lucene Orphaned Attachments

Identify Orhpaned Attachment

In order to find the orphaned attachment, you'll need to open the index using the Luke tool. Once you've opened the index, click the Search tab.  Select the KeywordAnalyzer and enter id.page:"" in the seawrch box.

Take note of the id.file value for each result returned from search.  These files are orphaned and need to be manually marked as deleted in the database.

Mark Orphaned Attachment as Deleted

For each file, we need to run some sql queries to mark it as deleted.

1) verify that the parent page doesn't exist.  In this example file_id is 1 (see previous step)

select page_id, page_title from pages where page_id =
 (select resrev_parent_page_id from resources where res_id = 
   (select resource_id from resourcefilemap where file_id = 1)
 );

2) mark the resource as deleted

update resourcerevs set resrev_deleted=1 where resrev_res_id =
   (select resource_id from resourcefilemap where file_id = 1); 

update resources set res_deleted=1 where res_id = (select resource_id from resourcefilemap where file_id = 1);

Once this is done, you should be able to go to Control Panel >> Deleted Files and the orphaned file will show up in the deleted files list.

Fix Lucene Index

To remove the bad data from the index you have two options

1) rebuild the index via Control Panel >> Cache Management

or

2) using the deleteTerm.exe tool

TODO: document this