For the past several days I’ve been receiving the following error when running the auto-archive script from a scheduled cron task using the new format:
/usr/bin/php /apps/piwik/console core:archive --url=https://piwik.foo.com/
ERROR CoreConsole[2014-05-13 17:57:22]  Got invalid response from API request: https://piwik.foo.com/index.php?module=API&method=API.get&idSite=5&period=month&date=last5&format=php&token_auth=...&trigger=archivephp. Response was 'PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 8208 bytes) in /apps/piwik/core/DataTable.php on line 1155 '
This issue seems to have just started after I upgraded to Piwik 2.2.2 on May 8th. Prior to this the auto archiving script had worked correctly since I first installed Piwik over a year ago.
My issue seems very similar to this ongoing issue: http://forum.piwik.org/read.php?2,113069[/url] and this one from a few months ago [url=http://forum.piwik.org/read.php?5,109990,109990#msg-109990]http://forum.piwik.org/read.php?5,109990,109990#msg-109990.
My Apache 2.2 and PHP 5.3.3 configurations haven’t changed since first installed. I’ve also tried increasing the memory limit in PHP per the obvious recommendations, however, this did not resolve the issue. The server has 6GB of RAM and the PHP memory limit is currently set to 2GB. It doesn’t seem to matter how much memory I throw at it. I’ve also verified that the timezone is set correctly in PHP as suggested in other posts.
Apache error logs do not report any issues. I can’t find any other errors except what is shown above. I’ve also just tried upgrading to the latest beta release of 2.2.3-B4 yet the issue persists.