PHP Fatal error: Allowed memory size

Support & Bugs
1

Ever since upgrading to Piwik 1.8.1 I have been seeing the following error message:

[Wed Aug 01 19:07:04 2012] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /data/search/analytics/piwik_8-1/plugins/Actions/Actions.php on line 777, referer: http://analytics.xxx.xxx/piwik/index.php?module=CoreHome&action=index&idSite=3&period=day&date=today
[Wed Aug 01 19:07:41 2012] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 75 bytes) in /data/search/analytics/piwik_8-1/plugins/Actions/Actions.php on line 960, referer: http://analytics.xxx.xxx/piwik/index.php?module=CoreHome&action=index&idSite=3&period=day&date=today
[Wed Aug 01 19:08:16 2012] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 75 bytes) in /data/search/analytics/piwik_8-1/plugins/Actions/Actions.php on line 960, referer: http://analytics.xxx.xxx/piwik/index.php?module=CoreHome&action=index&idSite=3&period=day&date=today

The steps I have taken to resolve this are:

  1. Set memory_limit = 512M in /etc/php.ini file
  2. Had the RAM in my Piwik server increased from 4G to 8G.
  • I am running a VM Scientific Linux kernel 64 bit with 2 CPUs
  1. I installed PHP APC cache as recommended.

I don’t really think we are a large site yet. We only have had 602 visits and 45971 actions. We have defined 23 websites but only 5 are currently sending tracking data. Any other suggestions before we start building the reports by crontab?

2

The two widgets that seem to time out are:

  1. Last visits graph
  2. Frequency overview - I get the numbers like “6 returing visits” but the graph never displays.
3

Can ou please try to setup: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

if that does not work, please update to 1.8.3 which should improve thingsL: 301 Moved Permanently

4

Ok, so I set up auto archiving and ran the script by hand. It returned instantly with no messages either positive or negatively. In the “piwik-archive.log” there were no messages either. So I went to my Piwik website and everything loaded and looked good.

This morning I logged in and saw that several of the widgets like Visitor browsers, Visits by server time, Most popular internal searches, Length of Visits, etc., etc. showed “There is no data for this report.”
I then set the General Settings to allow Piwik archiving to trigger when reports are viewed from browser to Yes and went back to my website reports and after 10 minutes all of these widgets had data.

I then reset the allow Piwik archiving to trigger to No and went back to my reports and all of the widgets were showing data. Go figure. Is there something I can look at to see what happened? Is there a way to get the archiving script to send debugging output to the Piwik-archive.log?

One last question, you suggested to upgrade to 1.8.3 but that is labeled as “Beta”. When is the beta label coming off?

5

A couple of more items.

  1. I no longer seeing any clicks that in the past triggered a download like viewing an image or PDF file since I started this archiving thing.

  2. After my test above where I allowed the browser to build the reports, I set everything back to only allow the crontab to build the reports and for 4+ hours, I didn’t see any new activity on the sites being monitored. I switched back to allow the browser build the reports and I saw that there was activity on all sites.

I don’t think this archiving is doing anything but again I don’t see any error messages. Please help!!!

6

Did you test the crontab command to check it was working?

7

Yes. I see the file that would capture any messages from the cron have its date/time stamp changed. What I don’t see is the widgets getting any new data OR any messages from the archive script.

Is there a way to turn on verbose and or debug for this script?

8

The Cron should log the output of the script in: /home/www/piwik/archive.php.log
or whatever path you set in the crontab. What contains this file?

Also can you try adding a space between – and url in the command line? such as …archive.php – url=xxxx

9

Yes the Cron should log the output of the script BUT it is not doing it. Thus this thread. I posted above “OR any messages from the archive script”

The file I am outputing the crontab data to is 0 bytes in length. The date is geting updated so I know that the crontab is running. If I run the script from command line instead of the crontab I still see no output messages.

My crontab is “/usr/bin/php /webroot/search/analytics/piwik/misc/cron/archive.php – url=http://analytics.mycompany.com/piwik/ > /webroot/search/analytics/logs/piwik-archive.log”

So again I ask, Is there a way to turn on Verbose output for the archive.php script? And if so, please share that information.

10

Can you try with a different file maybe ? is it same behavior ?

11

What do you mean by “different file”? Since there has been no answer to my question, “Is there a way to turn on Verbose output for the archive.php script?” The answer is either no or we are not going to tell you.

12

By default verbose is on. If there is no ouput it means it’s failing even before Piwik starts, mayb esome PHP failure?

13

Ok. So today I ran the script twice. First with the /usr/bin/php and then just the script without the explicit path to the PHP. Here is what I saw.

  1. [search@linsrchweban1o ~]$ /usr/bin/php /webroot/search/analytics/piwik/misc/cron/archive.php – url=http://analytics.mysite.com/piwik/

  2. [search@linsrchweban1o ~]$ /webroot/search/analytics/piwik/misc/cron/archive.php – url=http://analytics.mysite.com/piwik/
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 1: ?php: No such file or directory
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 2: =: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 35: /bin: is a directory
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 36: Ideas: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 37: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 38: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 39: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 40: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 41: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 42: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 43: -: command not found
    /webroot/search/analytics/piwik/misc/cron/archive.php: line 44: syntax error near unexpected token (' /webroot/search/analytics/piwik/misc/cron/archive.php: line 44: - Possible performance improvement: Run first websites which are faster to process (weighted by visits and/or time to generate the last daily report)’

Doing a “which php” I get
/usr/bin/php

So, the first on masks any errors and the second one shows some issues. Can you give me any ideas where to look. I didn’t change the archive.php script at all from the install.

14

We updated Piwik to 1.8.3 and now the archive script shows output. Still getting errors on the memory limit even through I have it set to 1024M. Here is the output. Please help

/usr/bin/php /webroot/search/analytics/piwik/misc/cron/archive.php – url=http://analytics.mysite.com/piwik/
[2012-08-17 14:24:40] [56a105f2] ---------------------------
[2012-08-17 14:24:40] [56a105f2] INIT
[2012-08-17 14:24:40] [56a105f2] Querying Piwik API at: http://analytics.mysite.com/piwik/index.php
[2012-08-17 14:24:40] [56a105f2] Running as Super User: piwiksu
[2012-08-17 14:24:40] [56a105f2] Notes
[2012-08-17 14:24:40] [56a105f2] - Reports for today will be processed at most every 1500 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-08-17 14:24:40] [56a105f2] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-08-17 14:24:40] [56a105f2] --force-all-periods was detected: we will process websites with visits in the last 7 days 0 hours
[2012-08-17 14:24:41] [56a105f2] Will process 4 websites with new visits since 7 days 0 hours , IDs: 3, 143, 153, 203
[2012-08-17 14:24:41] [56a105f2] Will process 22 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 13, 23, 33, 43, 53, 63, 73, 83, 93, 103, 113, 123, 133, 163, 173, 183, 193, 213, 223, 233, 243, 253
[2012-08-17 14:24:41] [56a105f2] ---------------------------
[2012-08-17 14:24:41] [56a105f2] START
[2012-08-17 14:24:41] [56a105f2] Starting Piwik reports archiving…
[2012-08-17 14:26:15] [56a105f2] ERROR: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Please check your Web server Error Log file for more details.
[2012-08-17 14:26:15] [56a105f2] WARNING: Empty or invalid response ‘’ for website id 3, Time elapsed: 94.279s, skipping
[2012-08-17 14:26:15] [56a105f2] Skipped website id 143, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
[2012-08-17 14:26:15] [56a105f2] Skipped website id 153, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
[2012-08-17 14:26:15] [56a105f2] Skipped website id 203, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 13, period = day, Time elapsed: 0.073s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 13, period = week, 3 visits, Time elapsed: 0.115s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 13, period = month, 15 visits, Time elapsed: 0.123s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 13, period = year, 47 visits, Time elapsed: 0.123s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 13, today = 0 visits, 4 API requests, Time elapsed: 0.437s [5/26 done]
[2012-08-17 14:26:15] [56a105f2] Archived website id = 23, period = day, Time elapsed: 0.071s
[2012-08-17 14:26:15] [56a105f2] Archived website id = 23, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 23, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 23, period = year, 7 visits, Time elapsed: 0.123s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 23, today = 0 visits, 4 API requests, Time elapsed: 0.433s [6/26 done]
[2012-08-17 14:26:16] [56a105f2] Archived website id = 33, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 33, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 33, period = month, 98 visits, Time elapsed: 0.123s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 33, period = year, 5529 visits, Time elapsed: 0.123s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 33, today = 0 visits, 4 API requests, Time elapsed: 0.441s [7/26 done]
[2012-08-17 14:26:16] [56a105f2] Archived website id = 43, period = day, Time elapsed: 0.079s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 43, period = week, 2 visits, Time elapsed: 0.113s
[2012-08-17 14:26:16] [56a105f2] Archived website id = 43, period = month, 363 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 43, period = year, 27428 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 43, today = 0 visits, 4 API requests, Time elapsed: 0.440s [8/26 done]
[2012-08-17 14:26:17] [56a105f2] Archived website id = 53, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 53, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 53, period = month, 53 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 53, period = year, 2241 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 53, today = 0 visits, 4 API requests, Time elapsed: 0.431s [9/26 done]
[2012-08-17 14:26:17] [56a105f2] Archived website id = 63, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 63, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 63, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 63, period = year, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:17] [56a105f2] Archived website id = 63, today = 0 visits, 4 API requests, Time elapsed: 0.431s [10/26 done]
[2012-08-17 14:26:17] [56a105f2] Archived website id = 73, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 73, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 73, period = month, 28 visits, Time elapsed: 0.123s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 73, period = year, 934 visits, Time elapsed: 0.123s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 73, today = 0 visits, 4 API requests, Time elapsed: 0.431s [11/26 done]
[2012-08-17 14:26:18] [56a105f2] Archived website id = 83, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 83, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 83, period = month, 266 visits, Time elapsed: 0.123s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 83, period = year, 2444 visits, Time elapsed: 0.123s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 83, today = 0 visits, 4 API requests, Time elapsed: 0.432s [12/26 done]
[2012-08-17 14:26:18] [56a105f2] Archived website id = 93, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:18] [56a105f2] Archived website id = 93, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 93, period = month, 16 visits, Time elapsed: 0.123s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 93, period = year, 736 visits, Time elapsed: 0.133s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 93, today = 0 visits, 4 API requests, Time elapsed: 0.452s [13/26 done]
[2012-08-17 14:26:19] [56a105f2] Archived website id = 103, period = day, Time elapsed: 0.078s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 103, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 103, period = month, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 103, period = year, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 103, today = 0 visits, 4 API requests, Time elapsed: 0.472s [14/26 done]
[2012-08-17 14:26:19] [56a105f2] Archived website id = 113, period = day, Time elapsed: 0.082s
[2012-08-17 14:26:19] [56a105f2] Archived website id = 113, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 113, period = month, 55 visits, Time elapsed: 0.123s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 113, period = year, 4170 visits, Time elapsed: 0.133s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 113, today = 0 visits, 4 API requests, Time elapsed: 0.465s [15/26 done]
[2012-08-17 14:26:20] [56a105f2] Archived website id = 123, period = day, Time elapsed: 0.081s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 123, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 123, period = month, 31 visits, Time elapsed: 0.133s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 123, period = year, 1126 visits, Time elapsed: 0.123s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 123, today = 0 visits, 4 API requests, Time elapsed: 0.463s [16/26 done]
[2012-08-17 14:26:20] [56a105f2] Archived website id = 133, period = day, Time elapsed: 0.079s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 133, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:20] [56a105f2] Archived website id = 133, period = month, 12 visits, Time elapsed: 0.123s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 133, period = year, 263 visits, Time elapsed: 0.133s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 133, today = 0 visits, 4 API requests, Time elapsed: 0.461s [17/26 done]
[2012-08-17 14:26:21] [56a105f2] Archived website id = 163, period = day, Time elapsed: 0.078s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 163, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 163, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 163, period = year, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 163, today = 0 visits, 4 API requests, Time elapsed: 0.459s [18/26 done]
[2012-08-17 14:26:21] [56a105f2] Archived website id = 173, period = day, Time elapsed: 0.078s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 173, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:21] [56a105f2] Archived website id = 173, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 173, period = year, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 173, today = 0 visits, 4 API requests, Time elapsed: 0.460s [19/26 done]
[2012-08-17 14:26:22] [56a105f2] Archived website id = 183, period = day, Time elapsed: 0.271s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 183, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 183, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 183, period = year, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 183, today = 0 visits, 4 API requests, Time elapsed: 0.643s [20/26 done]
[2012-08-17 14:26:22] [56a105f2] Archived website id = 193, period = day, Time elapsed: 0.076s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 193, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:22] [56a105f2] Archived website id = 193, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 193, period = year, 14 visits, Time elapsed: 0.133s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 193, today = 0 visits, 4 API requests, Time elapsed: 0.458s [21/26 done]
[2012-08-17 14:26:23] [56a105f2] Archived website id = 213, period = day, Time elapsed: 0.070s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 213, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 213, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 213, period = year, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 213, today = 0 visits, 4 API requests, Time elapsed: 0.442s [22/26 done]
[2012-08-17 14:26:23] [56a105f2] Archived website id = 223, period = day, Time elapsed: 0.083s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 223, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:23] [56a105f2] Archived website id = 223, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 223, period = year, 0 visits, Time elapsed: 0.133s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 223, today = 0 visits, 4 API requests, Time elapsed: 0.466s [23/26 done]
[2012-08-17 14:26:24] [56a105f2] Archived website id = 233, period = day, Time elapsed: 0.082s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 233, period = week, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 233, period = month, 0 visits, Time elapsed: 0.163s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 233, period = year, 0 visits, Time elapsed: 0.153s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 233, today = 0 visits, 4 API requests, Time elapsed: 0.525s [24/26 done]
[2012-08-17 14:26:24] [56a105f2] Archived website id = 243, period = day, Time elapsed: 0.079s
[2012-08-17 14:26:24] [56a105f2] Archived website id = 243, period = week, 1 visits, Time elapsed: 0.123s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 243, period = month, 24 visits, Time elapsed: 0.335s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 243, period = year, 24 visits, Time elapsed: 0.123s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 243, today = 0 visits, 4 API requests, Time elapsed: 0.662s [25/26 done]
[2012-08-17 14:26:25] [56a105f2] Archived website id = 253, period = day, Time elapsed: 0.068s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 253, period = week, 0 visits, Time elapsed: 0.113s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 253, period = month, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 253, period = year, 0 visits, Time elapsed: 0.123s
[2012-08-17 14:26:25] [56a105f2] Archived website id = 253, today = 0 visits, 4 API requests, Time elapsed: 0.429s [26/26 done]
[2012-08-17 14:26:25] [56a105f2] Done archiving!
[2012-08-17 14:26:25] [56a105f2] ---------------------------
[2012-08-17 14:26:25] [56a105f2] SUMMARY
[2012-08-17 14:26:25] [56a105f2] Total daily visits archived: 0
[2012-08-17 14:26:25] [56a105f2] Archived today’s reports for 22 websites
[2012-08-17 14:26:25] [56a105f2] Archived week/month/year for 22 websites.
[2012-08-17 14:26:25] [56a105f2] Skipped 4 websites: no new visit since the last script execution
[2012-08-17 14:26:25] [56a105f2] Skipped 3 websites day archiving: existing daily reports are less than 1500 seconds old
[2012-08-17 14:26:25] [56a105f2] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-08-17 14:26:25] [56a105f2] Total API requests: 88
[2012-08-17 14:26:25] [56a105f2] done: 22/26 85%, 0 v, 22 wtoday, 22 wperiods, 88 req, 104619 ms, 1 errors. eg. ‘Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea’
[2012-08-17 14:26:25] [56a105f2] Time elapsed: 104.619s
[2012-08-17 14:26:25] [56a105f2] ---------------------------
[2012-08-17 14:26:25] [56a105f2] SCHEDULED TASKS
[2012-08-17 14:26:25] [56a105f2] Starting Scheduled tasks…
[2012-08-17 14:26:25] [56a105f2] No task to run
[2012-08-17 14:26:25] [56a105f2] done
[2012-08-17 14:26:25] [56a105f2] ---------------------------
[2012-08-17 14:26:25] [56a105f2] SUMMARY OF ERRORS
[2012-08-17 14:26:25] [56a105f2] Error: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea
[2012-08-17 14:26:25] [56a105f2] 1 total errors during this script execution, please investigate and try and fix these errors
[2012-08-17 14:26:25] [56a105f2] ERROR: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea
Error in the last Piwik archive.php run:
1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea

Here is the full errors output:

INIT
Querying Piwik API at: http://analytics.mysite.com/piwik/index.php
Running as Super User: piwiksu
Notes

  • Reports for today will be processed at most every 1500 seconds. You can change this value in Piwik UI > Settings > General Settings.
  • Reports for the current week/month/year will be refreshed at most every 3600 seconds.
    –force-all-periods was detected: we will process websites with visits in the last 7 days 0 hours
    Will process 4 websites with new visits since 7 days 0 hours , IDs: 3, 143, 153, 203
    Will process 22 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 13, 23, 33, 43, 53, 63, 73, 83, 93, 103, 113, 123, 133, 163, 173, 183, 193, 213, 223, 233, 243, 253

START
Starting Piwik reports archiving…
ERROR: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Please check your Web server Error Log file for more details.
WARNING: Empty or invalid response ‘’ for website id 3, Time elapsed: 94.279s, skipping
Skipped website id 143, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
Skipped website id 153, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
Skipped website id 203, already processed today’s report in recent run, 23 min 59s ago, Time elapsed: 0.001s
Archived website id = 13, period = day, Time elapsed: 0.073s
Archived website id = 13, period = week, 3 visits, Time elapsed: 0.115s
Archived website id = 13, period = month, 15 visits, Time elapsed: 0.123s
Archived website id = 13, period = year, 47 visits, Time elapsed: 0.123s
Archived website id = 23, period = day, Time elapsed: 0.071s
Archived website id = 23, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 23, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 23, period = year, 7 visits, Time elapsed: 0.123s
Archived website id = 33, period = day, Time elapsed: 0.070s
Archived website id = 33, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 33, period = month, 98 visits, Time elapsed: 0.123s
Archived website id = 33, period = year, 5529 visits, Time elapsed: 0.123s
Archived website id = 43, period = day, Time elapsed: 0.079s
Archived website id = 43, period = week, 2 visits, Time elapsed: 0.113s
Archived website id = 43, period = month, 363 visits, Time elapsed: 0.123s
Archived website id = 43, period = year, 27428 visits, Time elapsed: 0.123s
Archived website id = 53, period = day, Time elapsed: 0.070s
Archived website id = 53, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 53, period = month, 53 visits, Time elapsed: 0.123s
Archived website id = 53, period = year, 2241 visits, Time elapsed: 0.123s
Archived website id = 63, period = day, Time elapsed: 0.070s
Archived website id = 63, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 63, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 63, period = year, 0 visits, Time elapsed: 0.123s
Archived website id = 73, period = day, Time elapsed: 0.070s
Archived website id = 73, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 73, period = month, 28 visits, Time elapsed: 0.123s
Archived website id = 73, period = year, 934 visits, Time elapsed: 0.123s
Archived website id = 83, period = day, Time elapsed: 0.070s
Archived website id = 83, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 83, period = month, 266 visits, Time elapsed: 0.123s
Archived website id = 83, period = year, 2444 visits, Time elapsed: 0.123s
Archived website id = 93, period = day, Time elapsed: 0.070s
Archived website id = 93, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 93, period = month, 16 visits, Time elapsed: 0.123s
Archived website id = 93, period = year, 736 visits, Time elapsed: 0.133s
Archived website id = 103, period = day, Time elapsed: 0.078s
Archived website id = 103, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 103, period = month, 0 visits, Time elapsed: 0.133s
Archived website id = 103, period = year, 0 visits, Time elapsed: 0.133s
Archived website id = 113, period = day, Time elapsed: 0.082s
Archived website id = 113, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 113, period = month, 55 visits, Time elapsed: 0.123s
Archived website id = 113, period = year, 4170 visits, Time elapsed: 0.133s
Archived website id = 123, period = day, Time elapsed: 0.081s
Archived website id = 123, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 123, period = month, 31 visits, Time elapsed: 0.133s
Archived website id = 123, period = year, 1126 visits, Time elapsed: 0.123s
Archived website id = 133, period = day, Time elapsed: 0.079s
Archived website id = 133, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 133, period = month, 12 visits, Time elapsed: 0.123s
Archived website id = 133, period = year, 263 visits, Time elapsed: 0.133s
Archived website id = 163, period = day, Time elapsed: 0.078s
Archived website id = 163, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 163, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 163, period = year, 0 visits, Time elapsed: 0.133s
Archived website id = 173, period = day, Time elapsed: 0.078s
Archived website id = 173, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 173, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 173, period = year, 0 visits, Time elapsed: 0.133s
Archived website id = 183, period = day, Time elapsed: 0.271s
Archived website id = 183, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 183, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 183, period = year, 0 visits, Time elapsed: 0.123s
Archived website id = 193, period = day, Time elapsed: 0.076s
Archived website id = 193, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 193, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 193, period = year, 14 visits, Time elapsed: 0.133s
Archived website id = 213, period = day, Time elapsed: 0.070s
Archived website id = 213, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 213, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 213, period = year, 0 visits, Time elapsed: 0.133s
Archived website id = 223, period = day, Time elapsed: 0.083s
Archived website id = 223, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 223, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 223, period = year, 0 visits, Time elapsed: 0.133s
Archived website id = 233, period = day, Time elapsed: 0.082s
Archived website id = 233, period = week, 0 visits, Time elapsed: 0.123s
Archived website id = 233, period = month, 0 visits, Time elapsed: 0.163s
Archived website id = 233, period = year, 0 visits, Time elapsed: 0.153s
Archived website id = 243, period = day, Time elapsed: 0.079s
Archived website id = 243, period = week, 1 visits, Time elapsed: 0.123s
Archived website id = 243, period = month, 24 visits, Time elapsed: 0.335s
Archived website id = 243, period = year, 24 visits, Time elapsed: 0.123s
Archived website id = 253, period = day, Time elapsed: 0.068s
Archived website id = 253, period = week, 0 visits, Time elapsed: 0.113s
Archived website id = 253, period = month, 0 visits, Time elapsed: 0.123s
Archived website id = 253, period = year, 0 visits, Time elapsed: 0.123s
Done archiving!

SUMMARY
Total daily visits archived: 0
Archived today’s reports for 22 websites
Archived week/month/year for 22 websites.
Skipped 4 websites: no new visit since the last script execution
Skipped 3 websites day archiving: existing daily reports are less than 1500 seconds old
Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
Total API requests: 88
done: 22/26 85%, 0 v, 22 wtoday, 22 wperiods, 88 req, 104619 ms, 1 errors. eg. 'Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea’
Time elapsed: 104.619s

SCHEDULED TASKS
Starting Scheduled tasks…
No task to run
done

SUMMARY OF ERRORS
Error: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea
1 total errors during this script execution, please investigate and try and fix these errors
ERROR: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea
PHP Fatal error: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://analytics.mysite.com/piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=3&period=day&date=last52&format=php&token_auth=dab9cd0bd2a4af3128d297aca352b5d2&trigger=archivephp. The response was empty. This usually means a server error. This solution to this error is generally to increase the value of ‘memory_limit’ in your php.ini file. Plea in /data/search/analytics/piwik_8-3/misc/cron/archive.php on line 556
[search@linsrchweban1o ~]$

15

Do you see an error in your web server error log?

16

Yes

[Wed Aug 22 22:20:21 2012] [error] [client 555.555.555.555] PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 71 bytes) in /data/search/analytics/piwik_8-3/core/DataTable/Row.php on line 74

17

Image of my dashboard letting the crontab build the reports. Notice that I show visitors in the “Visitors in real-time” webpart but no visitors in the “Last Visit Graph”.

After switching to let the reports build in the browser, I get hits in the Last Visit Graph and in my error log file I see:

PHP Fatal error: Maximum execution time of 30 seconds exceeded in /data/search/analytics/piwik_8-3/core/DataTable/Row.php on line 78, referer: http://analytics.mysite.com/piwik/index.php?module=CoreHome&action=index&idSite=3&period=day&date=today