You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using this 'archive.php' script is no longer recommended.
Please use '/path/to/php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/console core:archive --url=http://www.sexblue-box.gr/' instead.
To get help use '/path/to/php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/console core:archive --help'
See also: http://piwik.org/docs/setup-auto-archiving/
If you cannot use the console because it requires CLI
INFO CoreConsole[2015-07-21 11:13:03] ---------------------------
INFO CoreConsole[2015-07-21 11:13:03] INIT
INFO CoreConsole[2015-07-21 11:13:03] Running Piwik 2.14.1 as Super User
INFO CoreConsole[2015-07-21 11:13:03] ---------------------------
INFO CoreConsole[2015-07-21 11:13:03] NOTES
INFO CoreConsole[2015-07-21 11:13:03] - If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archivi ng' in Piwik UI > Settings > General Settings.
INFO CoreConsole[2015-07-21 11:13:03] See the doc at: http://piwik.org/docs/setup-auto-archiving/
INFO CoreConsole[2015-07-21 11:13:03] - Reports for today will be processed at m ost every 150 seconds. You can change this value in Piwik UI > Settings > Genera l Settings.
INFO CoreConsole[2015-07-21 11:13:03] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2015-07-21 11:13:03] - Archiving was last executed without erro r 98 days 11 hours ago
INFO CoreConsole[2015-07-21 11:13:04] - Will process 1 websites with new visits since 98 days 11 hours , IDs: 1
INFO CoreConsole[2015-07-21 11:13:04] - Will process 1 other websites because so me old data reports have been invalidated (eg. using the Log Import script) , ID s: 1
INFO CoreConsole[2015-07-21 11:13:04] ---------------------------
INFO CoreConsole[2015-07-21 11:13:04] START
INFO CoreConsole[2015-07-21 11:13:04] Starting Piwik reports archiving...
INFO CoreConsole[2015-07-21 11:13:04] Will pre-process for website id = 1, perio d = day, date = last52
INFO CoreConsole[2015-07-21 11:13:04] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:15:24] Archived website id = 1, period = day, 0 s egments, 0 visits in last last52 days, 0 visits today, Time elapsed: 0.001s
INFO CoreConsole[2015-07-21 11:15:24] Will pre-process for website id = 1, perio d = week, date = last100
INFO CoreConsole[2015-07-21 11:15:24] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:22:11] Archived website id = 1, period = week, 0 segments, 151298 visits in last last100 weeks, 367 visits this week, Time elapse d: 406.620s
INFO CoreConsole[2015-07-21 11:22:11] Will pre-process for website id = 1, perio d = month, date = last52
INFO CoreConsole[2015-07-21 11:22:11] - pre-processing all visits
ERROR CoreConsole[2015-07-21 11:35:01] Got invalid response from API request: ?m odule=API&method=API.get&idSite=1&period=month&date=last52&format=php&trigger=ar chivephp. The response was empty. This usually means a server error. This soluti on to this error is generally to increase the value of 'memory_limit' in your ph p.ini file. Please check your Web server Error Log file for more details.
INFO CoreConsole[2015-07-21 11:35:01] Archived website id = 1, period = month, 0 segments, 0 visits in last last52 months, 0 visits this month, Time elapsed: 77 0.702s
INFO CoreConsole[2015-07-21 11:35:01] Will pre-process for website id = 1, perio d = year, date = last7
INFO CoreConsole[2015-07-21 11:35:01] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:37:59] Archived website id = 1, period = year, 0 segments, 337176 visits in last last7 years, 39628 visits this year, Time elapse d: 178.132s
[Zend_Db_Statement_Exception]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[PDOException]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
"Using this 'archive.php' script is no longer recommended.
Please use '/path/to/php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/console core:archive --url=http://www.something/' instead."
archive.php cannot finished
every time after 25min I get "General error: 2006 MySQL server has gone away"
I suspect sql command timeout
Any ideas?
here is the console output
[root@zeus ~]# php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/misc/cron/archive.php --url=http://www.sexblue-box.gr/
Using this 'archive.php' script is no longer recommended.
Please use '/path/to/php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/console core:archive --url=http://www.sexblue-box.gr/' instead.
To get help use '/path/to/php /var/www/vhosts/sexblue-box.gr/httpdocs/piwik/console core:archive --help'
See also: http://piwik.org/docs/setup-auto-archiving/
If you cannot use the console because it requires CLI
try 'php archive.php --url=http://your.piwik/path'
INFO CoreConsole[2015-07-21 11:13:03] ---------------------------
INFO CoreConsole[2015-07-21 11:13:03] INIT
INFO CoreConsole[2015-07-21 11:13:03] Running Piwik 2.14.1 as Super User
INFO CoreConsole[2015-07-21 11:13:03] ---------------------------
INFO CoreConsole[2015-07-21 11:13:03] NOTES
INFO CoreConsole[2015-07-21 11:13:03] - If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archivi ng' in Piwik UI > Settings > General Settings.
INFO CoreConsole[2015-07-21 11:13:03] See the doc at: http://piwik.org/docs/setup-auto-archiving/
INFO CoreConsole[2015-07-21 11:13:03] - Reports for today will be processed at m ost every 150 seconds. You can change this value in Piwik UI > Settings > Genera l Settings.
INFO CoreConsole[2015-07-21 11:13:03] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2015-07-21 11:13:03] - Archiving was last executed without erro r 98 days 11 hours ago
INFO CoreConsole[2015-07-21 11:13:04] - Will process 1 websites with new visits since 98 days 11 hours , IDs: 1
INFO CoreConsole[2015-07-21 11:13:04] - Will process 1 other websites because so me old data reports have been invalidated (eg. using the Log Import script) , ID s: 1
INFO CoreConsole[2015-07-21 11:13:04] ---------------------------
INFO CoreConsole[2015-07-21 11:13:04] START
INFO CoreConsole[2015-07-21 11:13:04] Starting Piwik reports archiving...
INFO CoreConsole[2015-07-21 11:13:04] Will pre-process for website id = 1, perio d = day, date = last52
INFO CoreConsole[2015-07-21 11:13:04] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:15:24] Archived website id = 1, period = day, 0 s egments, 0 visits in last last52 days, 0 visits today, Time elapsed: 0.001s
INFO CoreConsole[2015-07-21 11:15:24] Will pre-process for website id = 1, perio d = week, date = last100
INFO CoreConsole[2015-07-21 11:15:24] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:22:11] Archived website id = 1, period = week, 0 segments, 151298 visits in last last100 weeks, 367 visits this week, Time elapse d: 406.620s
INFO CoreConsole[2015-07-21 11:22:11] Will pre-process for website id = 1, perio d = month, date = last52
INFO CoreConsole[2015-07-21 11:22:11] - pre-processing all visits
ERROR CoreConsole[2015-07-21 11:35:01] Got invalid response from API request: ?m odule=API&method=API.get&idSite=1&period=month&date=last52&format=php&trigger=ar chivephp. The response was empty. This usually means a server error. This soluti on to this error is generally to increase the value of 'memory_limit' in your ph p.ini file. Please check your Web server Error Log file for more details.
INFO CoreConsole[2015-07-21 11:35:01] Archived website id = 1, period = month, 0 segments, 0 visits in last last52 months, 0 visits this month, Time elapsed: 77 0.702s
INFO CoreConsole[2015-07-21 11:35:01] Will pre-process for website id = 1, perio d = year, date = last7
INFO CoreConsole[2015-07-21 11:35:01] - pre-processing all visits
INFO CoreConsole[2015-07-21 11:37:59] Archived website id = 1, period = year, 0 segments, 337176 visits in last last7 years, 39628 visits this year, Time elapse d: 178.132s
[Zend_Db_Statement_Exception]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[PDOException]
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
core:archive [--url="..."] [--force-all-websites] [--force-all-periods[="..."]] [--force-timeout-for-periods[="..."]] [--skip-idsites[="..."]] [--skip-all-segme nts] [--force-idsites[="..."]] [--force-periods[="..."]] [--force-date-last-n=". .."] [--force-date-range[="..."]] [--force-idsegments="..."] [--concurrent-reque sts-per-website[="..."]] [--disable-scheduled-tasks] [--accept-invalid-ssl-certi ficate]
The text was updated successfully, but these errors were encountered: