General error: 1030 Got error 28 from storage engine


#1

Hi,

I installed piwik and imported a bunch of log files. Then I clicked on the Visitors tab and set my date range to the largest possible one, and after waiting a while, I got this error. Can anyone help?

WARN VisitsSummary[2014-02-25 17:59:11] [745fc] Failed to get data from API: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine#0 /var/www/analytics/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->execute(Array)#1 /var/www/analytics/piwik/core/Db/Adapter/Pdo/Mysql.php(227): Zend_Db_Statement->execute(Array)#2 /var/www/analytics/piwik/plugins/Actions/Archiver.php(276): Piwik\Db\Adapter\Pdo\Mysql->query(’???SELECT???..’, Array)#3 /var/www/analytics/piwik/plugins/Actions/Archiver.php(250): Piwik\Plugins\Actions\Archiver->archiveDayQueryProcess(‘log_action.name…’, Array, 'log_link_visit…’, ’12 DESC, name…’, ‘log_action.idac…’, ‘idaction_name’, Object(Piwik\RankingQuery))#4 /var/www/analytics/piwik/plugins/Actions/Archiver.php(96): Piwik\Plugins\Actions\Archiver->archiveDayActions(‘50000’)#5 /var/www/analytics/piwik/core/ArchiveProcessor/PluginsArchiver.php(95): Piwik\Plugins\Actions\Archiver->aggregateDayReport()#6 /var/www/analytics/piwik/core/ArchiveProcessor/Loader.php(120): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘19’, ‘0’)#7 /var/www/analytics/piwik/core/ArchiveProcessor/Loader.php(74): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)#8 /var/www/analytics/piwik/core/Archive.php(793): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)#9 /var/www/analytics/piwik/core/Archive.php(612): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))#10 /var/www/analytics/piwik/core/Archive.php(554): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#11 /var/www/analytics/piwik/core/Archive.php(494): Piwik\Archive->getArchiveIds(Array)#12 /var/www/analytics/piwik/core/Archive.php(343): Piwik\Archive->get(Array, ‘numeric’)#13 /var/www/analytics/piwik/plugins/VisitsSummary/API.php(62): Piwik\Archive->getDataTableFromNumeric(Array)#14 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘1’, ‘day’, ‘2013-02-23,2014…’, false, ‘nb_uniq_visitor…’)#15 /var/www/analytics/piwik/core/API/Proxy.php(213): call_user_func_array(Array, Array)#16 /var/www/analytics/piwik/plugins/API/API.php(454): Piwik\API\Proxy->call(’\Piwik\Plugins…’, ‘get’, Array)#17 [internal function]: Piwik\Plugins\API\API->get(‘1’, ‘day’, ‘2013-02-23,2014…’, false, false)#18 /var/www/analytics/piwik/core/API/Proxy.php(213): call_user_func_array(Array, Array)#19 /var/www/analytics/piwik/core/API/Request.php(220): Piwik\API\Proxy->call(’\Piwik\Plugins…’, ‘get’, Array)#20 /var/www/analytics/piwik/core/ViewDataTable/Request.php(50): Piwik\API\Request->process()#21 /var/www/analytics/piwik/core/Plugin/ViewDataTable.php(275): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#22 /var/www/analytics/piwik/core/Plugin/Visualization.php(168): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#23 /var/www/analytics/piwik/core/Plugin/ViewDataTable.php(362): Piwik\Plugin\Visualization->buildView()#24 /var/www/analytics/piwik/core/Plugin/Controller.php(202): Piwik\Plugin\ViewDataTable->render()#25 /var/www/analytics/piwik/plugins/VisitsSummary/Controller.php(97): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution))#26 /var/www/analytics/piwik/plugins/VisitsSummary/Controller.php(32): Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph(true, Array)#27 [internal function]: Piwik\Plugins\VisitsSummary\Controller->index()#28 /var/www/analytics/piwik/core/FrontController.php(117): call_user_func_array(Array, Array)#29 /var/www/analytics/piwik/index.php(62): Piwik\FrontController->dispatch()#30 {main}
Piwik # Web Analytics
SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

Thanks,
Dan


(Matthieu Aubry) #2

See mysql - 1030 Got error 28 from storage engine - Stack Overflow