Magento site keeps crashing inconsistently

Question

My magento site has started crashing. Recently while accessing the site mostly shows the following error message

There has been an error processing your request  
Exception printing is disabled by default for security reasons.
Error log record number: xxxxxxxxxxxx

After refreshing the site several times the normal page is displayed again.

The error report written to var/reports/<error log record numer> begins as follows:

a:5:{i:0;s:82:"Category Products Index process is working now. Please try run this process later.";i:1;s:2099:"#0 /home/krishbal/public_html/app/code/core/Mage/Index/Model/Process.php(162): Mage::throwException('Category Produc...')

Has anybody stumbled upon this before?

Answer 1

I agree with @zpea. Please provide the content of the report file and we can help. Also try to look into var/log/system.log and var/log/exception.log in your magento install folder.

Answer 2

Delete the contents of var/lock folder and double check the permissions.

Answer 3

Process Name ID Code

Product Attributes 1 catalog_product_attribute

Product Prices 2 catalog_product_price

Catalog URL Rewrites 3 catalog_url

Product Flat Data 4 catalog_product_flat

Category Flat Data 5 catalog_category_flat

Category Products 6 catalog_category_product

Catalog Search Index 7 catalogsearch_stock

Stock Status 8 cataloginventory_stock

Tag Aggregation Data 9 tag_summary

for ($i = 1; $i <= 9; $i++) {

$process = Mage::getModel('index/process')->load($i);

$process->reindexAll();

}