Archiving through cronjob fails after update to Matomo 3.13
Cron command is exactly as stated in documenation and worked well for long time.
Now it gives an error, saying :
ERROR [2020-01-06 15:10:03] 21430 Got invalid response from API request: ?module=API&method=API.get&idSite=5&period=day&date=last2&format=php&trigger=archivephp.
Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:20380:"SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegment7daa1fdbbea22b69cf2c6f4cf3de916c' is too long - in plugin Goals #0
For full backtrace see below.
Regards,
Kurt
ERROR [2020-01-06 15:10:03] 21430 Got invalid response from API request: ?module=API&method=API.get&idSite=5&period=day&date=last2&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:20380:"SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegment7daa1fdbbea22b69cf2c6f4cf3de916c' is too long - in plugin Goals #0 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(127): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('35', '0', false) #1 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(77): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive('35', '0') #2 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(63): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl('VisitsSummary') #3 /srv/webapps/webstats.wocat.net/core/Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}() #4 /srv/webapps/webstats.
wocat.net/core/ArchiveProcessor/Loader.php(64): Piwik\Context::changeIdSite(5, Object(Closure)) #5 /srv/webapps/webstats.wocat.net/core/Archive.php(867): Piwik\ArchiveProcessor\Loader->prepareArchive('VisitsSummary') #6 /srv/webapps/webstats.wocat.net/core/Archive.php(677): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #7 /srv/webapps/webstats.wocat.net/core/Archive.php(620): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #8 /srv/webapps/webstats.wocat.net/core/Archive.php(549): Piwik\Archive->getArchiveIds(Array) #9 /srv/webapps/webstats.wocat.net/core/Archive.php(303): Piwik\Archive->get(Array, 'numeric') #10 /srv/webapps/webstats.wocat.net/plugins/VisitsSummary/API.php(36): Piwik\Archive->getDataTableFromNumeric(Array) #11 [internal function]: Piwik\Plugins\VisitsSummary\API->get('5', 'day', 'last2', false, Array) #12 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array) #1
3 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #14 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #15 /srv/webapps/webstats.wocat.net/plugins/API/API.php(435): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #16 [internal function]: Piwik\Plugins\API\API->get('5', 'day', 'last2', false, Array) #17 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array) #18 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #19 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #20 /srv/webapps/webstats.wocat.net/core/API/Request.php(265): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #21 /srv/webapps/webstats.wocat.net/plugins/API/Controller.php(41): Piwik\API\Request->process() #22 [i nternal function]: Piwik\Plugins\API\Controller->index() #23 /srv/webapps/webstats.wocat.net/core/FrontController.php(589): call_user_func_array(Array, Array) #24 /srv/webapps/webstats.wocat.net/core/FrontController.php(165): Piwik\FrontController->doDispatch('API', false, Array) #25 /srv/webapps/webstats.wocat.net/core/dispatch.php(34): Piwik\FrontController->dispatch() #26 /srv/webapps/webstats.wocat.net/index.php(27): require_once('/srv/webapps/we...') #27 /srv/webapps/webstats.wocat.net/core/CliMulti/RequestCommand.php(79): require_once('/srv/webapps/we...') #28 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Ob
ject(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #30 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\CliMulti\RequestCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #31 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #32 /srv/webapps/webstats.wocat.net/core/Console.php(103): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #33 /srv/webapps/webstats.wocat.net/core/Access.php(639): Piwik\Console->Piwik\{closure}() #34 /srv/webapps/webstats.wocat.net/core/Console.php(104): Piwik\Access::doAsSuperUser(Object(Closure)) #35 /srv/webapps/w
ebstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #36 /srv/webapps/webstats.wocat.net/console(27): Symfony\Component\Console\Application->run() #37 {main}, caused by: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegment7daa1fdbbea22b69cf2c6f4cf3de916c' is too long #0 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TEMPORAR...', Array) #3 /srv/webapps/webstats.wocat.net/core/Db/Adapter/Pdo/Mysql.php(309): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TEMPORAR...', Array)
#4 /srv/webapps/webstats.wocat.net/core/DataAccess/
ERROR [2020-01-06 15:10:03] 21430 Empty or invalid response '' for website id 5, Time elapsed: 0.688s, skipping ERROR [2020-01-06 15:10:04] 21430 Got invalid response from API request: ?module=API&method=API.get&idSite=7&period=day&date=last2&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:20380:"SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegmentc47fd44dab7d79f7b017b0652b154b33' is too long - in plugin Goals #0 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(127): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('33', '0', false) #1 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(77): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive('33', '0') #2 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(63): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl('VisitsSummary') #3 /srv/webapps/webstats.wocat.net/core/Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}() #4 /srv/webapps/webstats.
wocat.net/core/ArchiveProcessor/Loader.php(64): Piwik\Context::changeIdSite(7, Object(Closure)) #5 /srv/webapps/webstats.wocat.net/core/Archive.php(867): Piwik\ArchiveProcessor\Loader->prepareArchive('VisitsSummary') #6 /srv/webapps/webstats.wocat.net/core/Archive.php(677): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #7 /srv/webapps/webstats.wocat.net/core/Archive.php(620): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #8 /srv/webapps/webstats.wocat.net/core/Archive.php(549): Piwik\Archive->getArchiveIds(Array) #9 /srv/webapps/webstats.wocat.net/core/Archive.php(303): Piwik\Archive->get(Array, 'numeric') #10 /srv/webapps/webstats.wocat.net/plugins/VisitsSummary/API.php(36): Piwik\Archive->getDataTableFromNumeric(Array) #11 [internal function]: Piwik\Plugins\VisitsSummary\API->get('7', 'day', 'last2', false, Array) #12 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array) #1
3 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #14 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #15 /srv/webapps/webstats.wocat.net/plugins/API/API.php(435): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #16 [internal function]: Piwik\Plugins\API\API->get('7', 'day', 'last2', false, Array) #17 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array) #18 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #19 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #20 /srv/webapps/webstats.wocat.net/core/API/Request.php(265): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #21 /srv/webapps/webstats.wocat.net/plugins/API/Controller.php(41): Piwik\API\Request->process() #22 [i nternal function]: Piwik\Plugins\API\Controller->index() #23 /srv/webapps/webstats.wocat.net/core/FrontController.php(589): call_user_func_array(Array, Array) #24 /srv/webapps/webstats.wocat.net/core/FrontController.php(165): Piwik\FrontController->doDispatch('API', false, Array) #25 /srv/webapps/webstats.wocat.net/core/dispatch.php(34): Piwik\FrontController->dispatch() #26 /srv/webapps/webstats.wocat.net/index.php(27): require_once('/srv/webapps/we...') #27 /srv/webapps/webstats.wocat.net/core/CliMulti/RequestCommand.php(79): require_once('/srv/webapps/we...') #28 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Ob
ject(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #30 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\CliMulti\RequestCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #31 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #32 /srv/webapps/webstats.wocat.net/core/Console.php(103): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #33 /srv/webapps/webstats.wocat.net/core/Access.php(639): Piwik\Console->Piwik\{closure}() #34 /srv/webapps/webstats.wocat.net/core/Console.php(104): Piwik\Access::doAsSuperUser(Object(Closure)) #35 /srv/webapps/w
ebstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #36 /srv/webapps/webstats.wocat.net/console(27): Symfony\Component\Console\Application->run() #37 {main}, caused by: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegmentc47fd44dab7d79f7b017b0652b154b33' is too long #0 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TEMPORAR...', Array) #3 /srv/webapps/webstats.wocat.net/core/Db/Adapter/Pdo/Mysql.php(309): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TEMPORAR...', Array)
#4 /srv/webapps/webstats.wocat.net/core/DataAccess/
ERROR [2020-01-06 15:10:04] 21430 Empty or invalid response '' for website id 7, Time elapsed: 0.647s, skipping ERROR [2020-01-06 15:10:04] 21430 Got invalid response from API request: ?module=API&method=API.get&idSite=8&period=day&date=last2&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:20386:"SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegmentbe682a92e5a707d9b54518d92dfe2bb0' is too long - in plugin Goals #0 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(127): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('123', '0', false) #1 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(77): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive('123', '0') #2 /srv/webapps/webstats.wocat.net/core/ArchiveProcessor/Loader.php(63): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl('VisitsSummary') #3 /srv/webapps/webstats.wocat.net/core/Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}() #4 /srv/webapps/webstat
s.wocat.net/core/ArchiveProcessor/Loader.php(64): Piwik\Context::changeIdSite(8, Object(Closure)) #5 /srv/webapps/webstats.wocat.net/core/Archive.php(867): Piwik\ArchiveProcessor\Loader->prepareArchive('VisitsSummary') #6 /srv/webapps/webstats.wocat.net/core/Archive.php(677): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Day)) #7 /srv/webapps/webstats.wocat.net/core/Archive.php(620): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array) #8 /srv/webapps/webstats.wocat.net/core/Archive.php(549): Piwik\Archive->getArchiveIds(Array) #9 /srv/webapps/webstats.wocat.net/core/Archive.php(303): Piwik\Archive->get(Array, 'numeric') #10 /srv/webapps/webstats.wocat.net/plugins/VisitsSummary/API.php(36): Piwik\Archive->getDataTableFromNumeric(Array) #11 [internal function]: Piwik\Plugins\VisitsSummary\API->get('8', 'day', 'last2', false, Array) #12 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array)
#13 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #14 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #15 /srv/webapps/webstats.wocat.net/plugins/API/API.php(435): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #16 [internal function]: Piwik\Plugins\API\API->get('8', 'day', 'last2', false, Array) #17 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(237): call_user_func_array(Array, Array) #18 /srv/webapps/webstats.wocat.net/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}() #19 /srv/webapps/webstats.wocat.net/core/API/Proxy.php(328): Piwik\Context::executeWithQueryParameters(Array, Object(Closure)) #20 /srv/webapps/webstats.wocat.net/core/API/Request.php(265): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'get', Array) #21 /srv/webapps/webstats.wocat.net/plugins/API/Controller.php(41): Piwik\API\Request->process() #22 [internal function]: Piwik\Plugins\API\Controller->index() #23 /srv/webapps/webstats.wocat.net/core/FrontController.php(589): call_user_func_array(Array, Array) #24 /srv/webapps/webstats.wocat.net/core/FrontController.php(165): Piwik\FrontController->doDispatch('API', false, Array) #25 /srv/webapps/webstats.wocat.net/core/dispatch.php(34): Piwik\FrontController->dispatch() #26 /srv/webapps/webstats.wocat.net/index.php(27): require_once('/srv/webapps/we...') #27 /srv/webapps/webstats.wocat.net/core/CliMulti/RequestCommand.php(79): require_once('/srv/webapps/we...') #28 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(
Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #30 /srv/webapps/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\CliMulti\RequestCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #31 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #32 /srv/webapps/webstats.wocat.net/core/Console.php(103): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #33 /srv/webapps/webstats.wocat.net/core/Access.php(639): Piwik\Console->Piwik\{closure}() #34 /srv/webapps/webstats.wocat.net/core/Console.php(104): Piwik\Access::doAsSuperUser(Object(Closure)) #35 /srv/webapps
/webstats.wocat.net/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #36 /srv/webapps/webstats.wocat.net/console(27): Symfony\Component\Console\Application->run() #37 {main}, caused by: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'user_piwikintegration_logtmpsegmentbe682a92e5a707d9b54518d92dfe2bb0' is too long #0 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /srv/webapps/webstats.wocat.net/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TEMPORAR...', Array) #3 /srv/webapps/webstats.wocat.net/core/Db/Adapter/Pdo/Mysql.php(309): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TEMPORAR...', Arra
y) #4 /srv/webapps/webstats.wocat.net/core/DataAcces
ERROR [2020-01-06 15:10:04] 21430 Empty or invalid response '' for website id 8, Time elapsed: 0.674s, skipping ERROR [2020-01-06 15:10:04] 21430 6 total errors during this script execution, please investigate and try and fix these errors.