Statistics does not record after upgrade to 1.8.2 :(


#1

Hello after upgrading my 1.7.2 to 1.8.2 piwik this is not recording the statistics of my sites. Live recording seems to be working.

It may be a bug?

[attachment 674 captura.png]


#2

I have problem to run cron/archive.php, my log file is:


sudo su www-data -c "/usr/bin/php5 /home/sites/estadistica/public_html/misc/cron/archive.php --url=http://portalacademico.cch.unam.mx/piwik"
[2012-06-06 16:57:39] [9959cb90] ---------------------------
[2012-06-06 16:57:39] [9959cb90] INIT
[2012-06-06 16:57:39] [9959cb90] Querying Piwik API at: http://portalacademico.cch.unam.mx/piwik/index.php
[2012-06-06 16:57:39] [9959cb90] Running as Super User: admin
[2012-06-06 16:57:39] [9959cb90] Notes
[2012-06-06 16:57:39] [9959cb90] - Reports for today will be processed at most every 10 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-06-06 16:57:39] [9959cb90] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-06-06 16:57:39] [9959cb90] --force-all-periods was detected: we will process websites with visits in the last 7 días 0 horas
[2012-06-06 16:57:40] [9959cb90] Will process 7 websites with new visits since 7 días 0 horas , IDs: 1, 2, 3, 4, 5, 6, 7
[2012-06-06 16:57:40] [9959cb90] Will process 1 other websites because the last time they were archived was on a different day (in the website's timezone) , IDs: 8
[2012-06-06 16:57:40] [9959cb90] ---------------------------
[2012-06-06 16:57:40] [9959cb90] START
[2012-06-06 16:57:40] [9959cb90] Starting Piwik reports archiving...
[2012-06-06 17:00:29] [9959cb90] Archived website id = 1, period = day, Time elapsed: 169.579s
[2012-06-06 17:03:30] [9959cb90] Archived website id = 1, period = week, 354027 visits, Time elapsed: 180.641s
[2012-06-06 17:07:58] [9959cb90] Archived website id = 1, period = month, 483182 visits, Time elapsed: 267.829s
[2012-06-06 17:08:13] [9959cb90] Archived website id = 1, period = year, 475090 visits, Time elapsed: 15.429s
[2012-06-06 17:08:13] [9959cb90] ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error in the last Piwik archive.php run: 
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

 Here is the full output of the script:

---------------------------
INIT
Querying Piwik API at: http://portalacademico.cch.unam.mx/piwik/index.php
Running as Super User: admin
Notes
- Reports for today will be processed at most every 10 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 días 0 horas
Will process 7 websites with new visits since 7 días 0 horas , IDs: 1, 2, 3, 4, 5, 6, 7
Will process 1 other websites because the last time they were archived was on a different day (in the website's timezone) , IDs: 8
---------------------------
START
Starting Piwik reports archiving...
Archived website id = 1, period = day, Time elapsed: 169.579s
Archived website id = 1, period = week, 354027 visits, Time elapsed: 180.641s
Archived website id = 1, period = month, 483182 visits, Time elapsed: 267.829s
Archived website id = 1, period = year, 475090 visits, Time elapsed: 15.429s
ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
PHP Fatal error:  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/sites/estadistica/public_html/misc/cron/archive.php on line 555



(Matthieu Aubry) #3

Mysql server has gone away error can be fixed with info from this page:
http://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-away-error-2006.html


#4

Hi matt thanks for your answer.

My MySQL has:

max_allowed_packet = 64M

but it is showing me the error sometimes when running the cron.


Error in the last Piwik archive.php run: 
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

 Here is the full output of the script:

---------------------------
INIT
Querying Piwik API at: http://portalacademico.cch.unam.mx/piwik/index.php
Running as Super User: admin
Notes
- Reports for today will be processed at most every 10 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.
- Archiving was last executed without error 5 horas 54 min ago
Will process 7 websites with new visits since 5 horas 54 min , IDs: 1, 2, 3, 4, 5, 6, 7
---------------------------
START
Starting Piwik reports archiving...
Archived website id = 1, period = day, Time elapsed: 120.164s
Archived website id = 1, period = week, 15925 visits, Time elapsed: 184.330s
Archived website id = 1, period = month, 61200 visits, Time elapsed: 340.890s
Archived website id = 1, period = year, 426586 visits, Time elapsed: 15.354s
ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
PHP Fatal error:  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/sites/estadistica/public_html/misc/cron/archive.php on line 555



(Matthieu Aubry) #5

try bumping to more like 128 maybe?


#6

Thank you for your help.

These are my new parameters:

wait_timeout = 6000
max_allowed_packet = 64M