Hi,
Eevery night i am getting the following error:
ERROR CoreConsole[2014-06-25 06:07:31] [28b4c] Got invalid response from API request: http://81.169.xx.xx/piwik/index.php?module=API&method=API.get&idSite=8&period=day&date=last2&format=php&token_auth=xxxxxxxxxxxxxxmy_authxxxxxxxxxxxxc&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:100:"allocateNewArchiveId: Cannot get named lock allocateNewArchiveId.piwikstats_archive_numeric_2014_06.";}'
ERROR CoreConsole[2014-06-25 08:42:27] [28b4c] 1 total errors during this script execution, please investigate and try and fix these errors.
this repeats 6 times/hours.
Moreover the serverload increases dramatically every hour then (see attached file) which makes it unusable in the end. What can be done?
These are my settings and configuraion:
- fresh Ubuntu 12.04 + Plesk 12
- vServer with 6 Cores, 12gb Ram, 2gb available for Piwik 2.3.0
- 9 Websites with all in all only 500 Visitors
- Hourly Cron which finishes in under 10-15 Seconds during the day
I would really like to use the cronjob because the manual archiving via browser is a pain. Does anyone have an idea?
Thank you 