Undefined index in ArchivingDbAdapter

SubJunk · January 19, 2021, 5:02am

This showed up on my install today and I am following its instructions to post on the forum:

WARNING: core/DataAccess/ArchivingDbAdapter.php(46): Notice - Undefined index: archiving_query_max_execution_time - Matomo 4.1.1 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already) (Module: Actions, Action: getPageUrls, Method: Actions.getPageUrls, In CLI mode: false)

Lukas · January 19, 2021, 10:28am

Hi,

It sounds a bit like your last update didn’t properly replace the config/global.ini.php.

Can you check the integrity check in the system check to see if any other files are invalid or outdated and replace them all with the ones from the latest matomo.zip.

This section specifically is the one I think you are missing (it was added in the last update)

github.com

matomo-org/matomo/blob/4.1.1/config/global.ini.php#L359-L362


; If configured, archiving queries will be aborted after the configured amount of seconds. Set it to -1 if the query time
; should not be limited. Note: This feature requires a recent MySQL version (5.7 or newer). Some MySQL forks like MariaDB
; might not support this feature which uses the MAX_EXECUTION_TIME hint.
archiving_query_max_execution_time = 7200