I am hoping someone in this community can help me figure out how to solve an issue we’re having that is rendering our instance of SuiteCRM almost useless to us.
This morning we came in and found that the advanced search was not working, the results screen was completely blank it didn’t even show the “no results” message. An examination of the suitecrm.log file revealed that the index located at modules/AOD_Index/Index/Index was corrupt. Following some instructions that we found on the these forums we backed up that directory and then deleted it. We then also truncated the aod_index and aod_indexevent tables. This immediately stopped the errors from showing up in the suitecrm.log file and the advanced search started showing “no results” instead of being blank.
Of course, it was not returning any results at this point no matter what you searched for. I assumed that this was just because the index was not rebuilt yet so I went to /index.php?module=AOD_Index on our instance and told it to run almost right away I started seeing a few results being indexed. I thought everything was going to be good but we quickly noticed that it was indexing records at a rate of about 1 every few seconds. If it continues at that rate it will take a huge amount of time to index everything.
We then noticed that the only things we could get search results for coincided with records found in the aod_indexevent table. Those records only seem to get there when something is created or edited in the database. If that is true then someone would need to go to and edit every record in our database which has tens of thousands of just accounts not to mention all the related data such as notes.
We can see the cron job running which seems to be involved in updating the Index:
15 hours after we cleared out the index it still has a LONG way to go:
Questions:
- Am I mistaken or not understanding how the system works or will it only re-index records that are created or updated after the index was cleared out?
- Most importantly, is there a way to force it to re-index everything in the database right now? We don’t care if it hammers the CPU because at this point the CRM is basically useless to us if we can use this search tool.