Howdy,
I’ve had a read through the FAQ and a quick look at the issue tracker but I couldn’t find any open bugs or any information if this is how piwik operates normally.
I have a number of reports configured for a site. I’m unable to generate a report on the current day nor am I able to generate a report over a time period that includes the current day.
The two main errors in the logs files are these.
2012/09/05 10:07:19 [error] 21849#0: *2956 FastCGI sent in stderr: “PHP Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 33554432 bytes) in /var/www/piwik/core/DataTable.php on line 371” while reading response header from upstream, client: 10.0.0.24, server: piwik.example.com, request: “POST /index.php HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9000”, host: “piwik.example.com”, referrer: “http://piwik.example.com/index.php?module=PDFReports&action=index&period=range&date=2012-09-03,2012-09-05&idSite=9”
2012/09/05 10:14:02 [error] 21846#0: *3153 FastCGI sent in stderr: “PHP Fatal error: Maximum execution time of 90 seconds exceeded in /var/www/piwik/core/DataTable/Manager.php on line 77” while reading response header from upstream, client: 10.0.0.24, server: piwik.example.com, request: “GET /index.php?module=API&action=index&period=range&date=2012-09-01%2C2012-09-04&idSite=9&token_auth=c9078a63baa9fa5cf2c7d5e9d91a8fd5&method=PDFReports.generateReport&idReport=15&outputType=1&language=en&reportFormat=pdf HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9000”, host: “piwik.example.com”, referrer: "http://piwik.example.com/index.php?module=PDFReports&action=index&period=range&date=2012-09-01,2012-09-04&idSite=9
I’ve increased both memory and execution times inside of nginx and fpm/php.ini up (600 seconds, 2GB etc) and down with no avail.
I’m about to look at How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo but I wanted to see if I was missing anything obvious first.
Thanks!