The following error occurs in exception.log file
exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalog_category_product_index_tmp' doesn't exist' in /www/sites/www.test.com/files/html/lib/Zend/Db/Statement/Pdo.php:228
When I am trying to create the table
catalog_category_product_index_tmp through phpmyadmin after running
php shell/indexer.php reindexall the table is automatically deleted and through the exception like above.