Dear Piwik Team
Recently our Piwik UI has started to display various error messages when selecting monthly or date range reports. Errors range between Oops… there was a problem during the request & a few MySql errors i.e 126 Incorrect key file for table ‘/tmp/#’;
here is an extract from the piwik log file:
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] Failed to get data from API: SQLSTATE[HY000]: General error: 126 Incorrect key file for table ‘/tmp/#sql_10e1_22.MYI’; try to repair it - caused by plugin Actions
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #0 /var/www/piwik/core/ArchiveProcessor/Loader.php(126): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘496497’, ‘0’)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #1 /var/www/piwik/core/ArchiveProcessor/Loader.php(74): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #2 /var/www/piwik/core/Archive.php(901): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #3 /var/www/piwik/core/Archive.php(715): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #4 /var/www/piwik/core/Archive.php(667): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #5 /var/www/piwik/core/Archive.php(605): Piwik\Archive->getArchiveIds(Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #6 /var/www/piwik/core/Archive.php(332): Piwik\Archive->get(Array, ‘numeric’)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #7 /var/www/piwik/plugins/VisitsSummary/API.php(35): Piwik\Archive->getDataTableFromNumeric(Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #8 [internal function]: Piwik\Plugins\VisitsSummary\API->get(‘3’, ‘day’, ‘2016-11-01,2016…’, false, ‘nb_visits’)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #9 /var/www/piwik/core/API/Proxy.php(208): call_user_func_array(Array, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #10 /var/www/piwik/plugins/API/API.php(408): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #11 [internal function]: Piwik\Plugins\API\API->get(‘3’, ‘day’, ‘2016-11-01,2016…’, false, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #12 /var/www/piwik/core/API/Proxy.php(208): call_user_func_array(Array, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #13 /var/www/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘get’, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #14 /var/www/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI()
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #15 /var/www/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #16 /var/www/piwik/core/Plugin/Controller.php(248): Piwik\Plugin\ViewDataTable->render()
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #17 /var/www/piwik/plugins/VisitsSummary/Controller.php(125): Piwik\Plugin\Controller->renderView(Object(Piwik\Plugins\CoreVisualizations\Visualizations\JqplotGraph\Evolution))
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #18 [internal function]: Piwik\Plugins\VisitsSummary\Controller->getEvolutionGraph()
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #19 /var/www/piwik/core/FrontController.php(495): call_user_func_array(Array, Array)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #20 /var/www/piwik/core/FrontController.php(99): Piwik\FrontController->doDispatch(NULL, NULL, NULL)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #21 /var/www/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #22 /var/www/piwik/index.php(27): require_once(’/var/www/piwik/…’)
ERROR VisitsSummary[2017-01-17 14:15:13] [b6ead] #23 {main}
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] Failed to get data from API: SQLSTATE[HY000]: General error: 126 Incorrect key file for table ‘/tmp/#sql_10e1_77.MYI’; try to repair it - caused by plugin Actions
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #0 /var/www/piwik/core/ArchiveProcessor/Loader.php(126): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(‘496497’, ‘0’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #1 /var/www/piwik/core/ArchiveProcessor/Loader.php(74): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #2 /var/www/piwik/core/Archive.php(901): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #3 /var/www/piwik/core/Archive.php(715): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day))
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #4 /var/www/piwik/core/Archive.php(667): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #5 /var/www/piwik/core/Archive.php(605): Piwik\Archive->getArchiveIds(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #6 /var/www/piwik/core/Archive.php(332): Piwik\Archive->get(Array, ‘numeric’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #7 /var/www/piwik/core/ArchiveProcessor.php(559): Piwik\Archive->getDataTableFromNumeric(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #8 /var/www/piwik/core/ArchiveProcessor.php(256): Piwik\ArchiveProcessor->getAggregatedNumericMetrics(Array, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #9 /var/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(236): Piwik\ArchiveProcessor->aggregateNumericMetrics(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #10 /var/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(76): Piwik\ArchiveProcessor\PluginsArchiver->aggregateMultipleVisitsMetrics()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #11 /var/www/piwik/core/ArchiveProcessor/Loader.php(118): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateCoreMetrics()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #12 /var/www/piwik/core/ArchiveProcessor/Loader.php(74): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(false, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #13 /var/www/piwik/core/Archive.php(901): Piwik\ArchiveProcessor\Loader->prepareArchive(‘VisitsSummary’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #14 /var/www/piwik/core/Archive.php(715): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Month))
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #15 /var/www/piwik/core/Archive.php(667): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #16 /var/www/piwik/core/Archive.php(605): Piwik\Archive->getArchiveIds(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #17 /var/www/piwik/core/Archive.php(332): Piwik\Archive->get(Array, ‘numeric’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #18 /var/www/piwik/core/ArchiveProcessor.php(559): Piwik\Archive->getDataTableFromNumeric(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #19 /var/www/piwik/core/ArchiveProcessor.php(256): Piwik\ArchiveProcessor->getAggregatedNumericMetrics(Array, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #20 /var/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(236): Piwik\ArchiveProcessor->aggregateNumericMetrics(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #21 /var/www/piwik/core/ArchiveProcessor/PluginsArchiver.php(76): Piwik\ArchiveProcessor\PluginsArchiver->aggregateMultipleVisitsMetrics()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #22 /var/www/piwik/core/ArchiveProcessor/Loader.php(99): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateCoreMetrics()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #23 /var/www/piwik/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareCoreMetricsArchive(false, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #24 /var/www/piwik/core/Archive.php(901): Piwik\ArchiveProcessor\Loader->prepareArchive(‘DevicesDetectio…’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #25 /var/www/piwik/core/Archive.php(715): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Range))
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #26 /var/www/piwik/core/Archive.php(667): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #27 /var/www/piwik/core/Archive.php(605): Piwik\Archive->getArchiveIds(Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #28 /var/www/piwik/core/Archive.php(377): Piwik\Archive->get(‘DevicesDetectio…’, ‘blob’, NULL)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #29 /var/www/piwik/plugins/DevicesDetection/API.php(36): Piwik\Archive->getDataTable(‘DevicesDetectio…’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #30 /var/www/piwik/plugins/DevicesDetection/API.php(237): Piwik\Plugins\DevicesDetection\API->getDataTable(‘DevicesDetectio…’, ‘3’, ‘range’, ‘2016-11-01,2016…’, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #31 [internal function]: Piwik\Plugins\DevicesDetection\API->getBrowsers(‘3’, ‘range’, ‘2016-11-01,2016…’, false)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #32 /var/www/piwik/core/API/Proxy.php(208): call_user_func_array(Array, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #33 /var/www/piwik/core/Plugin/Visualization.php(259): Piwik\API\Proxy->call(’\Piwik\Plugins\…’, ‘getBrowsers’, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #34 /var/www/piwik/core/Plugin/Visualization.php(180): Piwik\Plugin\Visualization->loadDataTableFromAPI()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #35 /var/www/piwik/core/Plugin/ViewDataTable.php(414): Piwik\Plugin\Visualization->buildView()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #36 /var/www/piwik/core/Plugin/Report.php(338): Piwik\Plugin\ViewDataTable->render()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #37 /var/www/piwik/plugins/CoreHome/Controller.php(78): Piwik\Plugin\Report->render()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #38 [internal function]: Piwik\Plugins\CoreHome\Controller->renderReportWidget(Object(Piwik\Plugins\DevicesDetection\Reports\GetBrowsers))
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #39 /var/www/piwik/core/FrontController.php(495): call_user_func_array(Array, Array)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #40 /var/www/piwik/core/FrontController.php(99): Piwik\FrontController->doDispatch(NULL, NULL, NULL)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #41 /var/www/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch()
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #42 /var/www/piwik/index.php(27): require_once(’/var/www/piwik/…’)
ERROR CoreHome[2017-01-17 14:15:13] [8e95d] #43 {main}
Has anyone any idea what the cause can be ?
I have already increased memory and tmp disk space.
Thanks
Dibs