First thing I would like to say is I absolutely hate re-indexing manually on Magento. But as we all Magento Developers have no choice but to fix it and make client and boss happy. We encounter errors that gives more headache if we don't find the solution straight away. Sometimes I have to browse through so many magento forums pages with no luck. So, I'm going to show you how to fix this annoying magento reindexing error. When I tried to re-index products first I got this error.
Cannot initialize the indexer process.
Then again when I re-tried it, I got below error: