Sorry for the late reply.
Today I updated Matomo to 4.12.2.
I have not enabled goals, since we just dont use them right now.
In my config, there is nothing like enable_processing_unique_visitors anywhere.
About our Actions:
Dashboard all Websites (Total: 543.241 Visits, 8.206.301 Pageloads, 8.280.601 Actions)
This is for September (01-30) 2022
Currently, without VisitFrequency (Core)
Plugin enabled, the archiving works fine.
But as soon as I enable it, I still get
Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=day&date=2022-10-19&format=json&trigger=archivephp. Response was '{"result":"error","mes
sage":"Mysqli statement execute error : Too many active concurrent transactions - in plugin VisitFrequency. #0 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(284): Piwik\\ArchiveProcessor\\PluginsArchiver->callAggrega
teAllPlugins(25403, '0', false) #1 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(176): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive(25403, '0') #2 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(159
): Piwik\\ArchiveProcessor\\Loader->insertArchiveData(13130, 0) #3 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(99): Piwik\\ArchiveProcessor\\Loader->prepareArchiveImpl(false) #4 \/var\/www\/html\/core\/Context.p
hp(75): Piwik\\ArchiveProcessor\\Loader->Piwik\\ArchiveProcessor\\{closure}() #5 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(103): Piwik\\Context::changeIdSite(1, Object(Closure)) #6 \/var\/www\/html\/plugins\/Core
AdminHome\/API.php(284): Piwik\\ArchiveProcessor\\Loader->prepareArchive(false) #7 [internal function]: Piwik\\Plugins\\CoreAdminHome\\API->archiveReports('1', Object(Piwik\\Period\\Day), '2022-10-19', false, false, fals
e) #8 \/var\/www\/html\/core\/API\/Proxy.php(244): call_user_func_array(Array, Array) #9 \/var\/www\/html\/core\/Context.php(28): Piwik\\API\\Proxy->Piwik\\API\\{closure}() #10 \/var\/www\/html\/core\/API\/Proxy.php(335): P
iwik\\Context::executeWithQueryParameters(Array, Object(Closure)) #11 \/var\/www\/html\/core\/API\/Request.php(267): Piwik\\API\\Proxy->call('\\\\Piwik\\\\Plugins\\\\...', 'archiveReports', Array) #12 \/var\/www\/html\/plug
ins\/API\/Controller.php(45): Piwik\\API\\Request->process() #13 [internal function]: Piwik\\Plugins\\API\\Controller->index() #14 \/var\/www\/html\/core\/FrontController.php(631): call_user_func_array(Array, Array) #15
\/var\/www\/html\/core\/FrontController.php(169): Piwik\\FrontController->doDispatch('API', false, Array) #16 \/var\/www\/html\/core\/dispatch.php(32): Piwik\\FrontController->dispatch() #17 \/var\/www\/html\/index.php(2
5): require_once('\/var\/www\/html\/c...') #18 \/var\/www\/html\/core\/CliMulti\/RequestCommand.php(79): require_once('\/var\/www\/html\/i...') #19 \/var\/www\/html\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Comma
nd\/Command.php(257): Piwik\\CliMulti\\RequestCommand->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #20 \/var\/www\/html\/vendor\/symfony\/consol
e\/Symfony\/Component\/Console\/Application.php(874): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #21
\/var\/www\/html\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Application.php(195): Symfony\\Component\\Console\\Application->doRunCommand(Object(Piwik\\CliMulti\\RequestCommand), Object(Symfony\\Component\\Cons
ole\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 [internal function]: Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symf
ony\\Component\\Console\\Output\\ConsoleOutput)) #23 \/var\/www\/html\/core\/Console.php(135): call_user_func(Array, Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOut
put)) #24 \/var\/www\/html\/core\/Access.php(670): Piwik\\Console->Piwik\\{closure}() #25 \/var\/www\/html\/core\/Console.php(136): Piwik\\Access::doAsSuperUser(Object(Closure)) #26 \/var\/www\/html\/core\/Console.php(87):
Piwik\\Console->doRunImpl(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 \/var\/www\/html\/vendor\/symfony\/console\/Symfony\/Component\/Console\/Appli
cation.php(126): Piwik\\Console->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #28 \/var\/www\/html\/console(32): Symfony\\Component\\Console\\Appli
cation->run() #29 {main}, caused by: Mysqli statement execute error : Too many active concurrent transactions #0 \/var\/www\/html\/libs\/Zend\/Db\/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array) #1 \/var\/w
ww\/html\/libs\/Zend\/Db\/Adapter\/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 \/var\/www\/html\/core\/DataAccess\/LogAggregator.php(325): Zend_Db_Adapter_Abstract->query('INSERT IGNORE I...', Array) #3 \/var
\/www\/html\/core\/DataAccess\/LogAggregator.php(351): Piwik\\DataAccess\\LogAggregator->createTemporaryTable('logtmpsegmentb1...', 'SELECT \/* trigg...', Array) #4 \/var\/www\/html\/core\/DataAccess\/LogAggregator.php(561)
: Piwik\\DataAccess\\LogAggregator->generateQuery('count(distinct ...', Array, 'log_visit.visit...', '', '') #5 \/var\/www\/html\/core\/ArchiveProcessor\/PluginsArchiver.php(285): Piwik\\DataAccess\\LogAggregator->queryV
isitsByDimension() #6 \/var\/www\/html\/core\/ArchiveProcessor\/PluginsArchiver.php(102): Piwik\\ArchiveProcessor\\PluginsArchiver->aggregateDayVisitsMetrics() #7 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(278): P
iwik\\ArchiveProcessor\\PluginsArchiver->callAggregateCoreMetrics() #8 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(176): Piwik\\ArchiveProcessor\\Loader->prepareAllPluginsArchive(false, false) #9 \/var\/www\/htm
l\/core\/ArchiveProcessor\/Loader.php(159): Piwik\\ArchiveProcessor\\Loader->insertArchiveData(false, false) #10 \/var\/www\/html\/core\/ArchiveProcessor\/Loader.php(99): Piwik\\ArchiveProcessor\\Loader->prepareArchiveIm
pl('VisitsSummary') #11 \/var\/www\/html\/core\/Context.php ... )\n#45 \/var\/www\/html\/console(32): Symfony\\Component\\Console\\Application->run()\n#46 {main}"}'