I’m currently running Piwik version 2.3.0, Apache 2.2.15, and PHP 5.3.3.
I’ve experienced this error for many weeks now and it seems to have started after upgrading to Piwik 2.1. The error is the same, always complaining about DataTable.php line 1155. I’ve tried several of the beta versions since. The error seemed to briefly stop for a about a week, but, has returned and persists even after the latest update to 2.3.0 so I don’t think this is a PHP issue or memory issue as other posts have suggested, though I have tried increasing the memory assigned to PHP and to the server itself, but, this did not help. Additionally, the auto-archive script had been running without issue for many months with the same Apache and PHP versions. Only once I upgraded to Piwik 2.1 did these errors begin.
No, I’m not using suhosin and I’m not too familiar with apache memory settings; it’s set to what the apache configs default to.
Since I’ve been running the same Apache and PHP configs since I first installed Piwik over a year ago and since everything has worked fine up until about a month ago, I’m really not sure this is an actual memory issue. The only thing which has changed are the Piwik versions and if a newer release had a need for higher memory settings in PHP, Apache, etc I would expect this to be clearly documented somewhere.
Additionally, I’ve tried incremental increases of the server memory and PHP memory up to 8GB and with each increase, the bytes exhausted would increase to whatever the memory limit was at that moment. I suspect if I continued testing with 32GB, 64GB, etc the results would be the same. Nowhere do I see documentation stating that 8GB or greater is required for Piwik.
Thanks for the suggestions but I really think the issue lies within Piwik. Any other thoughts?
Can you try and upgrade the python to 2.7.1 at least? I think it is the recommeneded minimum when used by piwik. I dont think it affects cron but perhaps might help.
can you paste the memory setting from the php.ini here?
Do you happen to have any htaccess files that are constrianing things?
I just tried updating to Python 2.7.6 but the error persists. Additionally, the latest version of python available for RHEL 6 is 2.6.6. Many core OS functions rely on python and do not yet support the 2.7 branch. For example, with 2.7.6 installed, it broke yum. I’ve since reverted back to 2.6.6. I am able to install 2.7.6 alongside the existing version, but, this would only be useful if there is a way to tell Piwik only to point to this particular version of python. Regardless, this didn’t seem to help.
Here are the memory_limit settings I’ve tried incrementally in php.ini:
;memory_limit = 128M
;memory_limit = 512M
;memory_limit = 1024M
memory_limit = 2048M
@ lesjokolat: Not sure those apply. To clarify, my log importing cron jobs have always run successfully. Only when doing auto-archiving are these PHP errors reported.
@ matt: I’ve already tried increasing php memory several times, even up to 8GB. Doesn’t matter how much memory I give PHP, the errors still occur. Other threads indicate this doesn’t solve the problem for them either, leading me to think this isn’t really a PHP memory issue.