Archive reporting error after upgrade to 4.10.1 from 4.7.1

Support & Bugs
1

After upgrading from 4.7.1 to 4.10.1 over the weekend. I get this error hourly when the reports generate. Trying to determine how to resolve.

Response was ‘{“result”:“error”,“message”:"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2195777770’ for key ‘matomo_logtmpsegmentec0f8abc4a40f610d6d2a2ba08c11d22.PRIMARY’ - in plugin VisitFrequency. #0 /www2/WebAnalytics/matomo/core/ArchiveProcessor/Loader.php(284): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins() #1 /www2/WebAnalytics/matomo/core/ArchiveProcessor/Loader.php(176): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive() #2 /www2/WebAnalytics/matomo/core/ArchiveProcessor/Loader.php(159): Piwik\ArchiveProcessor\Loader->insertArchiveData() #3 /www2/WebAnalytics/matomo/core/ArchiveProcessor/Loader.php(99): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl() #4 /www2/WebAnalytics/matomo
/core/
Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}() #5 /www2/WebAnalytics/matomo/core/ArchiveProcessor/Loader.php(103): Piwik\Context::changeIdSite() #6 /www2/WebAnalytics/matomo/plugins/CoreAdminHome/API.php(277): Piwik\ArchiveProcessor\Loader->prepareArchive() #7 [internal function]: Piwik\Plugins\CoreAdminHome\API->archiveReports() #8 /www2/WebAnalytics/matomo/core/API/Proxy.php(244): call_user_func_array() #9 /www2/WebAnalytics/matomo/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #10 /www2/WebAnalytics/matomo/core/API/Proxy.php(335): Piwik\Context::executeWithQueryParameters() #11 /www2/WebAnalytics/matomo/core/API/Request.php(266): Piwik\API\Proxy->call() #12 /www2/WebAnalytics/matomo/plugins/API/Controller.php(45): Piwik\API\Request->process() #13 [internal function]: Piwik\Plugins\API\Controller->index() #14 /www2/WebAnalytics/matomo/co
re/Fron
tController.php(631): call_user_func_array() #15 /www2/WebAnalytics/matomo/core/FrontController.php(169): Piwik\FrontController->doDispatch() #16 /www2/WebAnalytics/matomo/core/dispatch.php(32): Piwik\FrontController->dispatch() #17 /www2/WebAnalytics/matomo/index.php(25): require_once(’/www2/WebAnalyt…’) #18 /www2/WebAnalytics/matomo/core/CliMulti/RequestCommand.php(79): require_once(’/www2/WebAnalyt…’) #19 /www2/WebAnalytics/matomo/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute() #20 /www2/WebAnalytics/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run() #21 /www2/WebAnalytics/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand() #22 [internal function]: Symfony\Component\
Console
\Application->doRun() #23 /www2/WebAnalytics/matomo/core/Console.php(135): call_user_func() #24 /www2/WebAnalytics/matomo/core/Access.php(670): Piwik\Console->Piwik\{closure}() #25 /www2/WebAnalytics/matomo/core/Console.php(136): Piwik\Access::doAsSuperUser() #26 /www2/WebAnalytics/matomo/core/Console.php(87): Piwik\Console->doRunImpl() #27 /www2/WebAnalytics/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun() #28 /www2/WebAnalytics/matomo/console(32): Symfony\Component\Console\Application->run() #29 {main}, caused by: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2195777770’ for key 'matomo_logtmpsegmentec0f8abc4a40f610d6d2a2ba08c11d22

2

Any ideas from the team here? It appears reports are still generating, but maybe not all of them? We have ~2300 sites using our Matomo instance with an large amount of traffic. I want to make sure reporting is still working for those customers.

Thanks
Grant