There was a problem with reindexing process

Today, when I was trying to setup a Magento store for a customer , I saw the products were not coming up on the frontend. So, I went to SYSTEM > INDEX MANAGEMENT , to reindex all the data..

But when I did that, it dint go through and said,

“There was a problem with reindexing process”

So, here is what I did to fix the problem,

1. Did a File Permissions Reset using this . Another solution is using Magento Clean Up Tool.

2. Went to var/cache folder on Magento root and cleaned the whole cache folder. Also made sure that cache folder is writable.

3. The best and ultimate way to fix this issue is by repairing the database.