Cron job error and strange behavior


#1

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 :slight_smile:


#2

Hi,

Would you please try to increase the time from 100000 ms to 2000000 ms in the file core/CliMulti.php in the
private function requestUrls(array $piwikUrls)
[…]
usleep(100000); // 100 * 1000 = 100ms
[…]

Regards,

Christoph