Stuff…

Had a problem with Magento stores not loading and the following errors were being presented when going to the site.

Error:

SQLSTATE[HY000]: General error: 145 Table ‘./magento/log_visitor_info’ is marked as crashed and should be repaired
Trace:
#0 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo…’, Array)
#3 /var/www/vhosts/magento/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo…’, Array)
#4 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo…’, Array)
#5 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(125): Zend_Db_Adapter_Abstract->insert(‘log_visitor_inf…’, Array)
#6 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(79): Mage_Log_Model_Mysql4_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor))
#7 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(373): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#8 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Visitor.php(159): Mage_Core_Model_Abstract->save()
#10 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/App.php(1239): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#11 /var/www/vhosts/magento/httpdocs/app/Mage.php(303): Mage_Core_Model_App->dispatchEvent(‘controller_acti…’, Array)
#12 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(454): Mage::dispatchEvent(‘controller_acti…’, Array)
#13 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Front/Action.php(45): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(365): Mage_Core_Controller_Front_Action->preDispatch()
#15 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#16 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /var/www/vhosts/magento/httpdocs/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#18 /var/www/vhosts/magento/httpdocs/index.php(65): Mage::run()
#19 {main}

SQLSTATE[HY000]: General error: 145 Table ‘./magento/log_url_info’ is marked as crashed and should be repaired
Trace:
#0 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo…’, Array)
#3 /var/www/vhosts/magento/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo…’, Array)
#4 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo…’, Array)
#5 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(63): Zend_Db_Adapter_Abstract->insert(‘log_url_info’, Array)
#6 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(71): Mage_Log_Model_Mysql4_Visitor->_saveUrlInfo(Object(Mage_Log_Model_Visitor))
#7 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(349): Mage_Log_Model_Mysql4_Visitor->_beforeSave(Object(Mage_Log_Model_Visitor))
#8 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Visitor.php(179): Mage_Core_Model_Abstract->save()
#10 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/App.php(1239): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#11 /var/www/vhosts/magento/httpdocs/app/Mage.php(303): Mage_Core_Model_App->dispatchEvent(‘controller_acti…’, Array)
#12 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(483): Mage::dispatchEvent(‘controller_acti…’, Array)
#13 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Front/Action.php(56): Mage_Core_Controller_Varien_Action->postDispatch()
#14 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(380): Mage_Core_Controller_Front_Action->postDispatch()
#15 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#16 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /var/www/vhosts/magento/httpdocs/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#18 /var/www/vhosts/magento/httpdocs/index.php(65): Mage::run()
#19 {main}

SQLSTATE[HY000]: General error: 145 Table ‘./magento/log_url’ is marked as crashed and should be repaired
Trace:
#0 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo…’, Array)
#3 /var/www/vhosts/magento/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo…’, Array)
#4 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo…’, Array)
#5 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(142): Zend_Db_Adapter_Abstract->insert(‘log_url’, Array)
#6 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(83): Mage_Log_Model_Mysql4_Visitor->_saveVisitorUrl(Object(Mage_Log_Model_Visitor))
#7 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(373): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#8 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Visitor.php(179): Mage_Core_Model_Abstract->save()
#10 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Model/App.php(1239): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#11 /var/www/vhosts/magento/httpdocs/app/Mage.php(303): Mage_Core_Model_App->dispatchEvent(‘controller_acti…’, Array)
#12 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(483): Mage::dispatchEvent(‘controller_acti…’, Array)
#13 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Front/Action.php(56): Mage_Core_Controller_Varien_Action->postDispatch()
#14 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(380): Mage_Core_Controller_Front_Action->postDispatch()
#15 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#16 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /var/www/vhosts/magento/httpdocs/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#18 /var/www/vhosts/magento/httpdocs/index.php(65): Mage::run()
#19 {main}

Most likely has broken tables and they need fixing:

root@server:/var/lib/mysql/magento# myisamchk -c log_visitor_info.MYI
Checking MyISAM file: log_visitor_info.MYI
Data records:  269208   Deleted blocks:       0
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 client is using or hasn’t closed the table properly
- check file-size
myisamchk: error: Size of indexfile is: 3863552         Should be: 3864576
myisamchk: error: Size of datafile is: 41476900          Should be: 41480516
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 3862528 that points to record outside datafile
- check record links
myisamchk: error: Record-count is not ok; is 269182       Should be: 269208
myisamchk: warning: Found     269182 parts                Should be: 269208 parts
MyISAM-table ‘log_visitor_info.MYI’ is corrupted
Fix it using switch “-r” or “-o”

root@server:/var/lib/mysql/magento# myisamchk -r log_visitor_info.MYI
- recovering (with sort) MyISAM-table ‘log_visitor_info.MYI’
Data records: 269208
- Fixing index 1
Data records: 269182

Same with following tables:  log_url_info.MYI, log_url.MYI