Actions/Sites with time period doesn't stops


#1

Hello,

i have got the problem that Piwik given’t any results when i run Actions/Sites with a time period.
We have data since 2012.
We have no problem with january.
We have a problem with february.
Is it possible that piwik can’t handle with a time period in the current month?
Because when i want the data from month february i get the results.

Piwik runs in a production environment. So it’s highly necessary to avoid data loss.

Although Piwik runs in a loadbalanced environment with the ssl-termination (nginx) on the loadbalancer. There are some restrictions, so i added the ssl on the webservers themselves.

Some information about the server and services.

OS: Debian 6.0.4
Webserver: Apache2 2.2.16-6+squeeze6
PHP5 5.3.3-7+squeeze8
Database: MySQL 5.1.49-3

  • Piwik CLI:
    Archiving over CLI disabled; runs in a Cron
    Plugin Live! deactivated

  • Piwik Conf


adapter = "MYSQLI"
session_save_handler = dbtable

  • PHP

memory_limit = 2048M
max_execution_time = 0

  • MySQL

max_connections        = 1000
table_cache            = 256
skip-innodb
log_slow_queries        = /var/log/mysql/mysql-slow.log
key_buffer              = 64M
query_cache_size        = 128M

At the beginning i had only problems with SSL and insufficient RAM. I resolved all these problems with the Piwik-FAQ.

I activated the logging per file or screen but i don’t get any failures:


enable_sql_profiler = 1
[log]
logger_message[]                = screen
logger_error[]                  = screen
logger_exception[]              = screen
log_only_when_cli = 1
log_only_when_debug_parameter = 0
logger_file_path                = tmp/logs
logger_api_call[]               = screen

The only interesting thing is that the archive.php logs some warnings for the affected site:


[2012-02-21 09:30:05] [d36ff28c] Archived website id = 1, period = day, Time elapsed: 3.787s
[2012-02-21 09:30:13] [d36ff28c] Archived website id = 1, period = week, 106428 visits, Time elapsed: 7.513s

Notice: unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385
[2012-02-21 09:31:13] [d36ff28c] Archived website id = 1, period = month, 0 visits, Time elapsed: 60.083s

Notice: unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385
[2012-02-21 09:32:13] [d36ff28c] Archived website id = 1, period = year, 0 visits, Time elapsed: 60.070s
[2012-02-21 09:32:13] [d36ff28c] Archived website id = 1, today = 2600 visits, 4 API requests, Time elapsed: 131.455s [1/8 done]

I need further assistance in debugging. I would be helpful to reproduce the failure per command-line to do a trace.

Cheerz


(Matthieu Aubry) #2

Please try this change: http://dev.piwik.org/trac/changeset/5875

it should then output the message that failed to unserialize. Please put the output here?


#3

First try:


php5 /var/www/piwik/misc/cron/archive.php --force-all-websites --force-all-periods
[2012-02-22 09:08:24] [2d76800c] --force-all-periods was detected: the script will run as if it was its first run, and will trigger archiving for all periods.
[2012-02-22 09:08:24] [2d76800c] --force-all-websites was detected: the script will archive all websites and all periods sequentially
[2012-02-22 09:08:24] [2d76800c] ---------------------------
[2012-02-22 09:08:24] [2d76800c] INIT
[2012-02-22 09:08:24] [2d76800c] Querying Piwik API at: https://piwik:443/index.php
[2012-02-22 09:08:24] [2d76800c] Running as Super User: babiel
[2012-02-22 09:08:24] [2d76800c] Notes
[2012-02-22 09:08:24] [2d76800c] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-02-22 09:08:24] [2d76800c] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-02-22 09:08:24] [2d76800c] Will process 9 websites
[2012-02-22 09:08:24] [2d76800c] ---------------------------
[2012-02-22 09:08:24] [2d76800c] START
[2012-02-22 09:08:24] [2d76800c] Starting Piwik reports archiving...
[2012-02-22 09:08:24] [2d76800c] Archived website id = 1, period = day, Time elapsed: 0.467s
[2012-02-22 09:08:25] [2d76800c] Archived website id = 1, period = week, 608880 visits, Time elapsed: 0.797s
PHP Notice:  unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385

Notice: unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385
 </html>nter>nginx</center>me-out</h1></center>d>erializing the following response: <html>
[2012-02-22 09:09:25] [2d76800c] Archived website id = 1, period = month, 0 visits, Time elapsed: 60.084s
PHP Notice:  unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385

Notice: unserialize(): Error at offset 0 of 176 bytes in /var/www/piwik/misc/cron/archive.php on line 385
 </html>nter>nginx</center>me-out</h1></center>d>erializing the following response: <html>
[2012-02-22 09:10:25] [2d76800c] Archived website id = 1, period = year, 0 visits, Time elapsed: 60.067s
[2012-02-22 09:10:25] [2d76800c] Archived website id = 1, today = 2057 visits, last days = 608879 visits, 4 API requests, Time elapsed: 121.417s [1/9 done]
[2012-02-22 09:10:26] [2d76800c] Archived website id = 2, period = day, Time elapsed: 0.631s
[2012-02-22 09:10:26] [2d76800c] Archived website id = 2, period = week, 11173 visits, Time elapsed: 0.383s
[2012-02-22 09:10:26] [2d76800c] Archived website id = 2, period = month, 11173 visits, Time elapsed: 0.352s
[2012-02-22 09:10:27] [2d76800c] Archived website id = 2, period = year, 11173 visits, Time elapsed: 0.234s
[2012-02-22 09:10:27] [2d76800c] Archived website id = 2, today = 49 visits, last days = 11173 visits, 4 API requests, Time elapsed: 1.603s [2/9 done]
[2012-02-22 09:10:27] [2d76800c] Archived website id = 3, period = day, Time elapsed: 0.300s
[2012-02-22 09:10:28] [2d76800c] Archived website id = 3, period = week, 14676 visits, Time elapsed: 0.984s
[2012-02-22 09:10:32] [2d76800c] Archived website id = 3, period = month, 14676 visits, Time elapsed: 4.286s
[2012-02-22 09:10:34] [2d76800c] Archived website id = 3, period = year, 14676 visits, Time elapsed: 1.783s
[2012-02-22 09:10:34] [2d76800c] Archived website id = 3, today = 43 visits, last days = 14676 visits, 4 API requests, Time elapsed: 7.356s [3/9 done]
[2012-02-22 09:10:34] [2d76800c] Archived website id = 4, period = day, Time elapsed: 0.327s
[2012-02-22 09:10:35] [2d76800c] Archived website id = 4, period = week, 164398 visits, Time elapsed: 0.764s
[2012-02-22 09:10:36] [2d76800c] Archived website id = 4, period = month, 164398 visits, Time elapsed: 0.560s
[2012-02-22 09:10:36] [2d76800c] Archived website id = 4, period = year, 164398 visits, Time elapsed: 0.423s
[2012-02-22 09:10:36] [2d76800c] Archived website id = 4, today = 613 visits, last days = 164398 visits, 4 API requests, Time elapsed: 2.077s [4/9 done]
[2012-02-22 09:10:37] [2d76800c] Archived website id = 5, period = day, Time elapsed: 0.525s
[2012-02-22 09:10:37] [2d76800c] Archived website id = 5, period = week, 4027 visits, Time elapsed: 0.847s
[2012-02-22 09:10:41] [2d76800c] Archived website id = 5, period = month, 4027 visits, Time elapsed: 3.876s
[2012-02-22 09:10:43] [2d76800c] Archived website id = 5, period = year, 4027 visits, Time elapsed: 1.533s
[2012-02-22 09:10:43] [2d76800c] Archived website id = 5, today = 22 visits, last days = 4027 visits, 4 API requests, Time elapsed: 6.785s [5/9 done]
[2012-02-22 09:10:43] [2d76800c] Skipped website id 6, no visits in the last 52 days, Time elapsed: 0.431s
[2012-02-22 09:10:44] [2d76800c] Archived website id = 9, period = day, Time elapsed: 0.478s
[2012-02-22 09:10:45] [2d76800c] Archived website id = 9, period = week, 4020 visits, Time elapsed: 1.352s
[2012-02-22 09:10:49] [2d76800c] Archived website id = 9, period = month, 4020 visits, Time elapsed: 3.626s
[2012-02-22 09:10:50] [2d76800c] Archived website id = 9, period = year, 4020 visits, Time elapsed: 1.518s
[2012-02-22 09:10:50] [2d76800c] Archived website id = 9, today = 20 visits, last days = 4020 visits, 4 API requests, Time elapsed: 6.995s [7/9 done]
[2012-02-22 09:10:51] [2d76800c] Archived website id = 10, period = day, Time elapsed: 0.527s
[2012-02-22 09:10:51] [2d76800c] Archived website id = 10, period = week, 16709 visits, Time elapsed: 0.501s
[2012-02-22 09:10:52] [2d76800c] Archived website id = 10, period = month, 16709 visits, Time elapsed: 0.465s
[2012-02-22 09:10:52] [2d76800c] Archived website id = 10, period = year, 16709 visits, Time elapsed: 0.302s
[2012-02-22 09:10:52] [2d76800c] Archived website id = 10, today = 51 visits, last days = 16709 visits, 4 API requests, Time elapsed: 1.796s [8/9 done]
[2012-02-22 09:10:52] [2d76800c] Archived website id = 11, period = day, Time elapsed: 0.357s
[2012-02-22 09:10:53] [2d76800c] Archived website id = 11, period = week, 843845 visits, Time elapsed: 0.365s
[2012-02-22 09:10:53] [2d76800c] Archived website id = 11, period = month, 843845 visits, Time elapsed: 0.491s
[2012-02-22 09:11:00] [2d76800c] Archived website id = 11, period = year, 843845 visits, Time elapsed: 6.721s
[2012-02-22 09:11:00] [2d76800c] Archived website id = 11, today = 4331 visits, last days = 843845 visits, 4 API requests, Time elapsed: 7.943s [9/9 done]
[2012-02-22 09:11:00] [2d76800c] Done archiving!
[2012-02-22 09:11:00] [2d76800c] ---------------------------
[2012-02-22 09:11:00] [2d76800c] SUMMARY
[2012-02-22 09:11:00] [2d76800c] Total daily visits archived: 7186
[2012-02-22 09:11:00] [2d76800c] Archived today's reports for 8 websites
[2012-02-22 09:11:00] [2d76800c] Archived week/month/year for 8 websites. 
[2012-02-22 09:11:00] [2d76800c] Skipped 1 websites: no new visit since the last script execution
[2012-02-22 09:11:00] [2d76800c] Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
[2012-02-22 09:11:00] [2d76800c] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-02-22 09:11:00] [2d76800c] Total API requests: 33
 '/html>nter>nginx</center>me-out</h1></center>d>7186 v, 8 wtoday, 8 wperiods, 33 req, 156405 ms, 2 errors. eg. 'Error unserializing the following response: <html>
[2012-02-22 09:11:00] [2d76800c] Time elapsed: 156.405s
[2012-02-22 09:11:00] [2d76800c] ---------------------------
[2012-02-22 09:11:00] [2d76800c] SCHEDULED TASKS
[2012-02-22 09:11:00] [2d76800c] Starting Scheduled tasks... 
[2012-02-22 09:11:00] [2d76800c]  No task to run
[2012-02-22 09:11:00] [2d76800c] done
[2012-02-22 09:11:00] [2d76800c] ---------------------------
[2012-02-22 09:11:00] [2d76800c] SUMMARY OF ERRORS
 </html>nter>nginx</center>me-out</h1></center>d>erializing the following response: <html>
 </html>nter>nginx</center>me-out</h1></center>d>erializing the following response: <html>
[2012-02-22 09:11:00] [2d76800c] 2 total errors during this script execution, please investigate and try and fix these errors
Error in the last Piwik archive.php run: 
2 total errors during this script execution, please investigate and try and fix these errors. First error was: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>


 Here is the full output of the script:

--force-all-periods was detected: the script will run as if it was its first run, and will trigger archiving for all periods.
--force-all-websites was detected: the script will archive all websites and all periods sequentially
---------------------------
INIT
Querying Piwik API at: https://piwik:443/index.php
Running as Super User: babiel
Notes
- Reports for today will be processed at most every 1800 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.
Will process 9 websites
---------------------------
START
Starting Piwik reports archiving...
Archived website id = 1, period = day, Time elapsed: 0.467s
Archived website id = 1, period = week, 608880 visits, Time elapsed: 0.797s
ERROR: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>

Archived website id = 1, period = month, 0 visits, Time elapsed: 60.084s
ERROR: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>

Archived website id = 1, period = year, 0 visits, Time elapsed: 60.067s
Archived website id = 2, period = day, Time elapsed: 0.631s
Archived website id = 2, period = week, 11173 visits, Time elapsed: 0.383s
Archived website id = 2, period = month, 11173 visits, Time elapsed: 0.352s
Archived website id = 2, period = year, 11173 visits, Time elapsed: 0.234s
Archived website id = 3, period = day, Time elapsed: 0.300s
Archived website id = 3, period = week, 14676 visits, Time elapsed: 0.984s
Archived website id = 3, period = month, 14676 visits, Time elapsed: 4.286s
Archived website id = 3, period = year, 14676 visits, Time elapsed: 1.783s
Archived website id = 4, period = day, Time elapsed: 0.327s
Archived website id = 4, period = week, 164398 visits, Time elapsed: 0.764s
Archived website id = 4, period = month, 164398 visits, Time elapsed: 0.560s
Archived website id = 4, period = year, 164398 visits, Time elapsed: 0.423s
Archived website id = 5, period = day, Time elapsed: 0.525s
Archived website id = 5, period = week, 4027 visits, Time elapsed: 0.847s
Archived website id = 5, period = month, 4027 visits, Time elapsed: 3.876s
Archived website id = 5, period = year, 4027 visits, Time elapsed: 1.533s
Skipped website id 6, no visits in the last 52 days, Time elapsed: 0.431s
Archived website id = 9, period = day, Time elapsed: 0.478s
Archived website id = 9, period = week, 4020 visits, Time elapsed: 1.352s
Archived website id = 9, period = month, 4020 visits, Time elapsed: 3.626s
Archived website id = 9, period = year, 4020 visits, Time elapsed: 1.518s
Archived website id = 10, period = day, Time elapsed: 0.527s
Archived website id = 10, period = week, 16709 visits, Time elapsed: 0.501s
Archived website id = 10, period = month, 16709 visits, Time elapsed: 0.465s
Archived website id = 10, period = year, 16709 visits, Time elapsed: 0.302s
Archived website id = 11, period = day, Time elapsed: 0.357s
Archived website id = 11, period = week, 843845 visits, Time elapsed: 0.365s
Archived website id = 11, period = month, 843845 visits, Time elapsed: 0.491s
Archived website id = 11, period = year, 843845 visits, Time elapsed: 6.721s
Done archiving!
---------------------------
SUMMARY
Total daily visits archived: 7186
Archived today's reports for 8 websites
Archived week/month/year for 8 websites. 
Skipped 1 websites: no new visit since the last script execution
Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
Total API requests: 33
done: 9/9 100%, 7186 v, 8 wtoday, 8 wperiods, 33 req, 156405 ms, 2 errors. eg. 'Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>
'
Time elapsed: 156.405s
---------------------------
SCHEDULED TASKS
Starting Scheduled tasks... 
 No task to run
done
---------------------------
SUMMARY OF ERRORS
Error: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>

Error: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>

2 total errors during this script execution, please investigate and try and fix these errors
[2012-02-22 09:11:00] [2d76800c] ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Error unseriali </html>nter>nginx</center>me-out</h1></center>d>
PHP Fatal error:  2 total errors during this script execution, please investigate and try and fix these errors. First error was: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>
 in /var/www/piwik/misc/cron/archive.php on line 491

Fatal error: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Error unserializing the following response: <html>
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx</center>
</body>
</html>
 in /var/www/piwik/misc/cron/archive.php on line 491

I imagined that i run piwik in a loadbalanced environment with the ssl-termination (nginx) on the loadbalancer. There are some restrictions, so i added the ssl on the webservers themselves.

Next run:


php5 /var/www/piwik/misc/cron/archive.php
[2012-02-22 09:50:03] [a6f77181] ---------------------------
[2012-02-22 09:50:03] [a6f77181] INIT
[2012-02-22 09:50:03] [a6f77181] Querying Piwik API at: https://piwik/index.php
[2012-02-22 09:50:03] [a6f77181] Running as Super User: babiel
[2012-02-22 09:50:03] [a6f77181] Notes
[2012-02-22 09:50:03] [a6f77181] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-02-22 09:50:03] [a6f77181] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-02-22 09:50:03] [a6f77181] - Archiving was last executed without error 41 Minuten 51s ago
[2012-02-22 09:50:04] [a6f77181] Will process 8 websites with new visits since 41 Minuten 52s , IDs: 1, 2, 3, 4, 5, 9, 10, 11
[2012-02-22 09:50:04] [a6f77181] ---------------------------
[2012-02-22 09:50:04] [a6f77181] START
[2012-02-22 09:50:04] [a6f77181] Starting Piwik reports archiving...
[2012-02-22 09:50:08] [a6f77181] Archived website id = 1, period = day, Time elapsed: 4.606s
[2012-02-22 09:50:08] [a6f77181] Archived website id = 1, today = 2730 visits, 1 API requests, Time elapsed: 4.606s [1/8 done]
[2012-02-22 09:50:09] [a6f77181] Archived website id = 2, period = day, Time elapsed: 0.349s
[2012-02-22 09:50:09] [a6f77181] Archived website id = 2, today = 60 visits, 1 API requests, Time elapsed: 0.349s [2/8 done]
[2012-02-22 09:50:09] [a6f77181] Archived website id = 3, period = day, Time elapsed: 0.680s
[2012-02-22 09:50:09] [a6f77181] Archived website id = 3, today = 59 visits, 1 API requests, Time elapsed: 0.681s [3/8 done]
[2012-02-22 09:50:10] [a6f77181] Archived website id = 4, period = day, Time elapsed: 1.226s
[2012-02-22 09:50:10] [a6f77181] Archived website id = 4, today = 784 visits, 1 API requests, Time elapsed: 1.226s [4/8 done]
[2012-02-22 09:50:11] [a6f77181] Archived website id = 5, period = day, Time elapsed: 0.408s
[2012-02-22 09:50:11] [a6f77181] Archived website id = 5, today = 27 visits, 1 API requests, Time elapsed: 0.408s [5/8 done]
[2012-02-22 09:50:11] [a6f77181] Archived website id = 9, period = day, Time elapsed: 0.397s
[2012-02-22 09:50:11] [a6f77181] Archived website id = 9, today = 23 visits, 1 API requests, Time elapsed: 0.397s [6/8 done]
[2012-02-22 09:50:12] [a6f77181] Archived website id = 10, period = day, Time elapsed: 0.358s
[2012-02-22 09:50:12] [a6f77181] Archived website id = 10, today = 65 visits, 1 API requests, Time elapsed: 0.358s [7/8 done]
[2012-02-22 09:50:18] [a6f77181] Archived website id = 11, period = day, Time elapsed: 6.123s
[2012-02-22 09:50:18] [a6f77181] Archived website id = 11, today = 5327 visits, 1 API requests, Time elapsed: 6.123s [8/8 done]
[2012-02-22 09:50:18] [a6f77181] Done archiving!
[2012-02-22 09:50:18] [a6f77181] ---------------------------
[2012-02-22 09:50:18] [a6f77181] SUMMARY
[2012-02-22 09:50:18] [a6f77181] Total daily visits archived: 9075
[2012-02-22 09:50:18] [a6f77181] Archived today's reports for 8 websites
[2012-02-22 09:50:18] [a6f77181] Archived week/month/year for 0 websites. 
[2012-02-22 09:50:18] [a6f77181] Skipped 1 websites: no new visit since the last script execution
[2012-02-22 09:50:18] [a6f77181] Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
[2012-02-22 09:50:18] [a6f77181] Skipped 8 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-02-22 09:50:18] [a6f77181] Total API requests: 8
[2012-02-22 09:50:18] [a6f77181] done: 8/8 100%, 9075 v, 8 wtoday, 0 wperiods, 8 req, 14149 ms, no error
[2012-02-22 09:50:18] [a6f77181] Time elapsed: 14.149s
[2012-02-22 09:50:18] [a6f77181] ---------------------------
[2012-02-22 09:50:18] [a6f77181] SCHEDULED TASKS
[2012-02-22 09:50:18] [a6f77181] Starting Scheduled tasks... 
[2012-02-22 09:50:18] [a6f77181]  No task to run
[2012-02-22 09:50:18] [a6f77181] done

Quite good. Next run:


php5 /var/www/piwik/misc/cron/archive.php --force-all-websites --force-all-periods
[2012-02-22 09:50:33] [aa113faa] --force-all-periods was detected: the script will run as if it was its first run, and will trigger archiving for all periods.
[2012-02-22 09:50:33] [aa113faa] --force-all-websites was detected: the script will archive all websites and all periods sequentially
[2012-02-22 09:50:33] [aa113faa] ---------------------------
[2012-02-22 09:50:33] [aa113faa] INIT
[2012-02-22 09:50:33] [aa113faa] Querying Piwik API at: https://piwik/index.php
[2012-02-22 09:50:33] [aa113faa] Running as Super User: babiel
[2012-02-22 09:50:33] [aa113faa] Notes
[2012-02-22 09:50:33] [aa113faa] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-02-22 09:50:33] [aa113faa] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-02-22 09:50:33] [aa113faa] Will process 9 websites
[2012-02-22 09:50:33] [aa113faa] ---------------------------
[2012-02-22 09:50:33] [aa113faa] START
[2012-02-22 09:50:33] [aa113faa] Starting Piwik reports archiving...
[2012-02-22 09:50:34] [aa113faa] Archived website id = 1, period = day, Time elapsed: 0.502s
[2012-02-22 09:50:48] [aa113faa] Archived website id = 1, period = week, 609553 visits, Time elapsed: 14.387s
[2012-02-22 09:51:59] [aa113faa] ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 09:51:59] [aa113faa] Archived website id = 1, period = month, 0 visits, Time elapsed: 70.904s
[2012-02-22 09:53:08] [aa113faa] ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 09:53:08] [aa113faa] Archived website id = 1, period = year, 0 visits, Time elapsed: 68.682s
[2012-02-22 09:53:08] [aa113faa] Archived website id = 1, today = 2730 visits, last days = 609552 visits, 4 API requests, Time elapsed: 154.476s [1/9 done]
^[[D[2012-02-22 09:53:08] [aa113faa] Archived website id = 2, period = day, Time elapsed: 0.561s
[2012-02-22 09:53:10] [aa113faa] Archived website id = 2, period = week, 11184 visits, Time elapsed: 1.334s
[2012-02-22 09:53:15] [aa113faa] Archived website id = 2, period = month, 11184 visits, Time elapsed: 5.612s
[2012-02-22 09:53:20] [aa113faa] Archived website id = 2, period = year, 11184 visits, Time elapsed: 5.056s
[2012-02-22 09:53:20] [aa113faa] Archived website id = 2, today = 60 visits, last days = 11184 visits, 4 API requests, Time elapsed: 12.564s [2/9 done]
[2012-02-22 09:53:21] [aa113faa] Archived website id = 3, period = day, Time elapsed: 0.393s
[2012-02-22 09:53:22] [aa113faa] Archived website id = 3, period = week, 14692 visits, Time elapsed: 1.345s
[2012-02-22 09:53:29] [aa113faa] Archived website id = 3, period = month, 14692 visits, Time elapsed: 7.003s
[2012-02-22 09:53:32] [aa113faa] Archived website id = 3, period = year, 14692 visits, Time elapsed: 2.538s
[2012-02-22 09:53:32] [aa113faa] Archived website id = 3, today = 59 visits, last days = 14692 visits, 4 API requests, Time elapsed: 11.282s [3/9 done]
[2012-02-22 09:53:32] [aa113faa] Archived website id = 4, period = day, Time elapsed: 0.470s
[2012-02-22 09:53:35] [aa113faa] Archived website id = 4, period = week, 164569 visits, Time elapsed: 3.304s
[2012-02-22 09:54:11] [aa113faa] Archived website id = 4, period = month, 164569 visits, Time elapsed: 35.182s
[2012-02-22 09:54:29] [aa113faa] Archived website id = 4, period = year, 164569 visits, Time elapsed: 18.460s
[2012-02-22 09:54:29] [aa113faa] Archived website id = 4, today = 784 visits, last days = 164569 visits, 4 API requests, Time elapsed: 57.419s [4/9 done]
[2012-02-22 09:54:30] [aa113faa] Archived website id = 5, period = day, Time elapsed: 0.485s
[2012-02-22 09:54:31] [aa113faa] Archived website id = 5, period = week, 4032 visits, Time elapsed: 1.441s
[2012-02-22 09:54:35] [aa113faa] Archived website id = 5, period = month, 4032 visits, Time elapsed: 4.365s
[2012-02-22 09:54:37] [aa113faa] Archived website id = 5, period = year, 4032 visits, Time elapsed: 1.603s
[2012-02-22 09:54:37] [aa113faa] Archived website id = 5, today = 27 visits, last days = 4032 visits, 4 API requests, Time elapsed: 7.896s [5/9 done]
[2012-02-22 09:54:37] [aa113faa] Skipped website id 6, no visits in the last 52 days, Time elapsed: 0.379s
[2012-02-22 09:54:38] [aa113faa] Archived website id = 9, period = day, Time elapsed: 0.525s
[2012-02-22 09:54:39] [aa113faa] Archived website id = 9, period = week, 4023 visits, Time elapsed: 1.020s
[2012-02-22 09:54:43] [aa113faa] Archived website id = 9, period = month, 4023 visits, Time elapsed: 3.669s
[2012-02-22 09:54:43] [aa113faa] Archived website id = 9, period = year, 4023 visits, Time elapsed: 0.774s
[2012-02-22 09:54:43] [aa113faa] Archived website id = 9, today = 23 visits, last days = 4023 visits, 4 API requests, Time elapsed: 6.023s [7/9 done]
[2012-02-22 09:54:44] [aa113faa] Archived website id = 10, period = day, Time elapsed: 0.444s
[2012-02-22 09:54:45] [aa113faa] Archived website id = 10, period = week, 16723 visits, Time elapsed: 1.109s
[2012-02-22 09:54:49] [aa113faa] Archived website id = 10, period = month, 16723 visits, Time elapsed: 4.329s
[2012-02-22 09:54:51] [aa113faa] Archived website id = 10, period = year, 16723 visits, Time elapsed: 1.843s
[2012-02-22 09:54:51] [aa113faa] Archived website id = 10, today = 65 visits, last days = 16723 visits, 4 API requests, Time elapsed: 7.730s [8/9 done]
[2012-02-22 09:54:51] [aa113faa] Archived website id = 11, period = day, Time elapsed: 0.322s
[2012-02-22 09:54:57] [aa113faa] Archived website id = 11, period = week, 844841 visits, Time elapsed: 5.387s
[2012-02-22 09:56:03] [aa113faa] Archived website id = 11, period = month, 844841 visits, Time elapsed: 66.400s
[2012-02-22 09:56:10] [aa113faa] Archived website id = 11, period = year, 844841 visits, Time elapsed: 7.026s
[2012-02-22 09:56:10] [aa113faa] Archived website id = 11, today = 5327 visits, last days = 844841 visits, 4 API requests, Time elapsed: 79.154s [9/9 done]
[2012-02-22 09:56:10] [aa113faa] Done archiving!
[2012-02-22 09:56:10] [aa113faa] ---------------------------
[2012-02-22 09:56:10] [aa113faa] SUMMARY
[2012-02-22 09:56:10] [aa113faa] Total daily visits archived: 9075
[2012-02-22 09:56:10] [aa113faa] Archived today's reports for 8 websites
[2012-02-22 09:56:10] [aa113faa] Archived week/month/year for 8 websites. 
[2012-02-22 09:56:10] [aa113faa] Skipped 1 websites: no new visit since the last script execution
[2012-02-22 09:56:10] [aa113faa] Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
[2012-02-22 09:56:10] [aa113faa] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-02-22 09:56:10] [aa113faa] Total API requests: 33
[2012-02-22 09:56:10] [aa113faa] done: 9/9 100%, 9075 v, 8 wtoday, 8 wperiods, 33 req, 336924 ms, 2 errors. eg. 'Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was '''
[2012-02-22 09:56:10] [aa113faa] Time elapsed: 336.925s
[2012-02-22 09:56:10] [aa113faa] ---------------------------
[2012-02-22 09:56:10] [aa113faa] SCHEDULED TASKS
[2012-02-22 09:56:10] [aa113faa] Starting Scheduled tasks... 
[2012-02-22 09:56:10] [aa113faa]  No task to run
[2012-02-22 09:56:10] [aa113faa] done
[2012-02-22 09:56:10] [aa113faa] ---------------------------
[2012-02-22 09:56:10] [aa113faa] SUMMARY OF ERRORS
[2012-02-22 09:56:10] [aa113faa] Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 09:56:10] [aa113faa] Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 09:56:10] [aa113faa] 2 total errors during this script execution, please investigate and try and fix these errors
Error in the last Piwik archive.php run: 
2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''

 Here is the full output of the script:

--force-all-periods was detected: the script will run as if it was its first run, and will trigger archiving for all periods.
--force-all-websites was detected: the script will archive all websites and all periods sequentially
---------------------------
INIT
Querying Piwik API at: https://piwik/index.php
Running as Super User: babiel
Notes
- Reports for today will be processed at most every 1800 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.
Will process 9 websites
---------------------------
START
Starting Piwik reports archiving...
Archived website id = 1, period = day, Time elapsed: 0.502s
Archived website id = 1, period = week, 609553 visits, Time elapsed: 14.387s
ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
Archived website id = 1, period = month, 0 visits, Time elapsed: 70.904s
ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
Archived website id = 1, period = year, 0 visits, Time elapsed: 68.682s
Archived website id = 2, period = day, Time elapsed: 0.561s
Archived website id = 2, period = week, 11184 visits, Time elapsed: 1.334s
Archived website id = 2, period = month, 11184 visits, Time elapsed: 5.612s
Archived website id = 2, period = year, 11184 visits, Time elapsed: 5.056s
Archived website id = 3, period = day, Time elapsed: 0.393s
Archived website id = 3, period = week, 14692 visits, Time elapsed: 1.345s
Archived website id = 3, period = month, 14692 visits, Time elapsed: 7.003s
Archived website id = 3, period = year, 14692 visits, Time elapsed: 2.538s
Archived website id = 4, period = day, Time elapsed: 0.470s
Archived website id = 4, period = week, 164569 visits, Time elapsed: 3.304s
Archived website id = 4, period = month, 164569 visits, Time elapsed: 35.182s
Archived website id = 4, period = year, 164569 visits, Time elapsed: 18.460s
Archived website id = 5, period = day, Time elapsed: 0.485s
Archived website id = 5, period = week, 4032 visits, Time elapsed: 1.441s
Archived website id = 5, period = month, 4032 visits, Time elapsed: 4.365s
Archived website id = 5, period = year, 4032 visits, Time elapsed: 1.603s
Skipped website id 6, no visits in the last 52 days, Time elapsed: 0.379s
Archived website id = 9, period = day, Time elapsed: 0.525s
Archived website id = 9, period = week, 4023 visits, Time elapsed: 1.020s
Archived website id = 9, period = month, 4023 visits, Time elapsed: 3.669s
Archived website id = 9, period = year, 4023 visits, Time elapsed: 0.774s
Archived website id = 10, period = day, Time elapsed: 0.444s
Archived website id = 10, period = week, 16723 visits, Time elapsed: 1.109s
Archived website id = 10, period = month, 16723 visits, Time elapsed: 4.329s
Archived website id = 10, period = year, 16723 visits, Time elapsed: 1.843s
Archived website id = 11, period = day, Time elapsed: 0.322s
Archived website id = 11, period = week, 844841 visits, Time elapsed: 5.387s
Archived website id = 11, period = month, 844841 visits, Time elapsed: 66.400s
Archived website id = 11, period = year, 844841 visits, Time elapsed: 7.026s
Done archiving!
---------------------------
SUMMARY
Total daily visits archived: 9075
Archived today's reports for 8 websites
Archived week/month/year for 8 websites. 
Skipped 1 websites: no new visit since the last script execution
Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
Total API requests: 33
done: 9/9 100%, 9075 v, 8 wtoday, 8 wperiods, 33 req, 336924 ms, 2 errors. eg. 'Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was '''
Time elapsed: 336.925s
---------------------------
SCHEDULED TASKS
Starting Scheduled tasks... 
 No task to run
done
---------------------------
SUMMARY OF ERRORS
Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
2 total errors during this script execution, please investigate and try and fix these errors
[2012-02-22 09:56:10] [aa113faa] ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
PHP Fatal error:  2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was '' in /var/www/piwik/misc/cron/archive.php on line 491

Fatal error: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was '' in /var/www/piwik/misc/cron/archive.php on line 491


#4

I updated my first entry? Did you get these changes?
I have no much experience with forums :slight_smile:


#5

Normal run:


[2012-02-22 11:00:02] [aeb4253b] ---------------------------
[2012-02-22 11:00:02] [aeb4253b] INIT
[2012-02-22 11:00:02] [aeb4253b] Querying Piwik API at: https://piwik/index.php
[2012-02-22 11:00:02] [aeb4253b] Running as Super User: babiel
[2012-02-22 11:00:02] [aeb4253b] Notes
[2012-02-22 11:00:02] [aeb4253b] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-02-22 11:00:02] [aeb4253b] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-02-22 11:00:02] [aeb4253b] - Archiving was last executed without error 1 Stunden 9 Minuten ago
[2012-02-22 11:00:02] [aeb4253b] Will process 8 websites with new visits since 1 Stunden 9 Minuten , IDs: 1, 2, 3, 4, 5, 9, 10, 11
[2012-02-22 11:00:02] [aeb4253b] ---------------------------
[2012-02-22 11:00:02] [aeb4253b] START
[2012-02-22 11:00:02] [aeb4253b] Starting Piwik reports archiving...
[2012-02-22 11:00:07] [aeb4253b] Archived website id = 1, period = day, Time elapsed: 4.321s
[2012-02-22 11:00:25] [aeb4253b] Archived website id = 1, period = week, 120114 visits, Time elapsed: 17.974s
[2012-02-22 11:01:36] [aeb4253b] ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ' Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/piwik/core/DataTable/Row.php on line 163 '
[2012-02-22 11:01:36] [aeb4253b] Archived website id = 1, period = month, 0 visits, Time elapsed: 70.939s
[2012-02-22 11:02:45] [aeb4253b] ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 11:02:45] [aeb4253b] Archived website id = 1, period = year, 0 visits, Time elapsed: 69.451s
[2012-02-22 11:02:45] [aeb4253b] Archived website id = 1, today = 3744 visits, 4 API requests, Time elapsed: 162.685s [1/8 done]
[2012-02-22 11:02:46] [aeb4253b] Archived website id = 2, period = day, Time elapsed: 0.550s
[2012-02-22 11:02:47] [aeb4253b] Archived website id = 2, period = week, 2065 visits, Time elapsed: 1.043s
[2012-02-22 11:02:52] [aeb4253b] Archived website id = 2, period = month, 11204 visits, Time elapsed: 5.272s
[2012-02-22 11:02:54] [aeb4253b] Archived website id = 2, period = year, 11204 visits, Time elapsed: 2.030s
[2012-02-22 11:02:54] [aeb4253b] Archived website id = 2, today = 80 visits, 4 API requests, Time elapsed: 8.898s [2/8 done]
[2012-02-22 11:02:55] [aeb4253b] Archived website id = 3, period = day, Time elapsed: 1.301s
[2012-02-22 11:02:56] [aeb4253b] Archived website id = 3, period = week, 2172 visits, Time elapsed: 1.077s
[2012-02-22 11:03:02] [aeb4253b] Archived website id = 3, period = month, 14727 visits, Time elapsed: 5.923s
[2012-02-22 11:03:04] [aeb4253b] Archived website id = 3, period = year, 14727 visits, Time elapsed: 1.554s
[2012-02-22 11:03:04] [aeb4253b] Archived website id = 3, today = 94 visits, 4 API requests, Time elapsed: 9.856s [3/8 done]
[2012-02-22 11:03:05] [aeb4253b] Archived website id = 4, period = day, Time elapsed: 1.405s
[2012-02-22 11:03:08] [aeb4253b] Archived website id = 4, period = week, 41427 visits, Time elapsed: 2.952s
[2012-02-22 11:03:42] [aeb4253b] Archived website id = 4, period = month, 164832 visits, Time elapsed: 34.274s
[2012-02-22 11:04:00] [aeb4253b] Archived website id = 4, period = year, 164832 visits, Time elapsed: 17.070s
[2012-02-22 11:04:00] [aeb4253b] Archived website id = 4, today = 1047 visits, 4 API requests, Time elapsed: 55.704s [4/8 done]
[2012-02-22 11:04:00] [aeb4253b] Archived website id = 5, period = day, Time elapsed: 0.435s
[2012-02-22 11:04:01] [aeb4253b] Archived website id = 5, period = week, 867 visits, Time elapsed: 1.089s
[2012-02-22 11:04:05] [aeb4253b] Archived website id = 5, period = month, 4036 visits, Time elapsed: 4.174s
[2012-02-22 11:04:07] [aeb4253b] Archived website id = 5, period = year, 4036 visits, Time elapsed: 1.606s
[2012-02-22 11:04:07] [aeb4253b] Archived website id = 5, today = 31 visits, 4 API requests, Time elapsed: 7.304s [5/8 done]
[2012-02-22 11:04:07] [aeb4253b] Archived website id = 9, period = day, Time elapsed: 0.431s
[2012-02-22 11:04:08] [aeb4253b] Archived website id = 9, period = week, 594 visits, Time elapsed: 1.000s
[2012-02-22 11:04:11] [aeb4253b] Archived website id = 9, period = month, 4029 visits, Time elapsed: 3.019s
[2012-02-22 11:04:12] [aeb4253b] Archived website id = 9, period = year, 4029 visits, Time elapsed: 1.048s
[2012-02-22 11:04:12] [aeb4253b] Archived website id = 9, today = 29 visits, 4 API requests, Time elapsed: 5.500s [6/8 done]
[2012-02-22 11:04:13] [aeb4253b] Archived website id = 10, period = day, Time elapsed: 0.504s
[2012-02-22 11:04:14] [aeb4253b] Archived website id = 10, period = week, 3030 visits, Time elapsed: 0.961s
[2012-02-22 11:04:19] [aeb4253b] Archived website id = 10, period = month, 16753 visits, Time elapsed: 5.300s
[2012-02-22 11:04:21] [aeb4253b] Archived website id = 10, period = year, 16753 visits, Time elapsed: 1.568s
[2012-02-22 11:04:21] [aeb4253b] Archived website id = 10, today = 95 visits, 4 API requests, Time elapsed: 8.335s [7/8 done]
[2012-02-22 11:04:28] [aeb4253b] Archived website id = 11, period = day, Time elapsed: 7.313s
[2012-02-22 11:04:34] [aeb4253b] Archived website id = 11, period = week, 291442 visits, Time elapsed: 5.827s
[2012-02-22 11:05:40] [aeb4253b] Archived website id = 11, period = month, 846473 visits, Time elapsed: 66.018s
[2012-02-22 11:05:47] [aeb4253b] Archived website id = 11, period = year, 846473 visits, Time elapsed: 7.521s
[2012-02-22 11:05:47] [aeb4253b] Archived website id = 11, today = 6959 visits, 4 API requests, Time elapsed: 86.680s [8/8 done]
[2012-02-22 11:05:47] [aeb4253b] Done archiving!
[2012-02-22 11:05:47] [aeb4253b] ---------------------------
[2012-02-22 11:05:47] [aeb4253b] SUMMARY
[2012-02-22 11:05:47] [aeb4253b] Total daily visits archived: 12079
[2012-02-22 11:05:47] [aeb4253b] Archived today's reports for 8 websites
[2012-02-22 11:05:47] [aeb4253b] Archived week/month/year for 8 websites. 
[2012-02-22 11:05:47] [aeb4253b] Skipped 1 websites: no new visit since the last script execution
[2012-02-22 11:05:47] [aeb4253b] Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
[2012-02-22 11:05:47] [aeb4253b] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-02-22 11:05:47] [aeb4253b] Total API requests: 32
[2012-02-22 11:05:47] [aeb4253b] done: 8/8 100%, 12079 v, 8 wtoday, 8 wperiods, 32 req, 344963 ms, 2 errors. eg. 'Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ' Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/piwik/core/DataTable/Row.php on line 163 ''
[2012-02-22 11:05:47] [aeb4253b] Time elapsed: 344.963s
[2012-02-22 11:05:47] [aeb4253b] ---------------------------
[2012-02-22 11:05:47] [aeb4253b] SCHEDULED TASKS
[2012-02-22 11:05:47] [aeb4253b] Starting Scheduled tasks... 
[2012-02-22 11:05:47] [aeb4253b]  No task to run
[2012-02-22 11:05:47] [aeb4253b] done
[2012-02-22 11:05:47] [aeb4253b] ---------------------------
[2012-02-22 11:05:47] [aeb4253b] SUMMARY OF ERRORS
[2012-02-22 11:05:47] [aeb4253b] Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ' Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/piwik/core/DataTable/Row.php on line 163 '
[2012-02-22 11:05:47] [aeb4253b] Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ''
[2012-02-22 11:05:47] [aeb4253b] 2 total errors during this script execution, please investigate and try and fix these errors
[2012-02-22 11:05:47] [aeb4253b] ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was ' Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/piwik/core/DataTable/Row.php on line 163 '

Fatal error: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was '
Fatal error: Maximum execution time of 0 seconds exceeded in /var/www/piwik/core/DataTable/Row.php on line 163 ' in /var/www/piwik/misc/cron/archive.php on line 491

Confusing: Maximum execution time of 0
Solution: http://foolswisdom.com/php-fatal-error-maximum-execution-time-of-infinity-exceeded/

So i changed “max_input_time = -1” in PHP for Apache and CLI.

Next run successful:


[2012-02-22 11:13:53] [8caa6fb3] ---------------------------
[2012-02-22 11:13:53] [8caa6fb3] INIT
[2012-02-22 11:13:53] [8caa6fb3] Querying Piwik API at: https://piwik/index.php
[2012-02-22 11:13:53] [8caa6fb3] Running as Super User: babiel
[2012-02-22 11:13:53] [8caa6fb3] Notes
[2012-02-22 11:13:53] [8caa6fb3] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-02-22 11:13:53] [8caa6fb3] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-02-22 11:13:53] [8caa6fb3] - Archiving was last executed without error 1 Stunden 23 Minuten ago
[2012-02-22 11:13:54] [8caa6fb3] Will process 8 websites with new visits since 1 Stunden 23 Minuten , IDs: 1, 2, 3, 4, 5, 9, 10, 11
[2012-02-22 11:13:54] [8caa6fb3] ---------------------------
[2012-02-22 11:13:54] [8caa6fb3] START
[2012-02-22 11:13:54] [8caa6fb3] Starting Piwik reports archiving...
[2012-02-22 11:13:54] [8caa6fb3] Archived website id = 1, period = day, Time elapsed: 0.202s
[2012-02-22 11:13:55] [8caa6fb3] Archived website id = 1, period = week, 120114 visits, Time elapsed: 0.222s
[2012-02-22 11:13:55] [8caa6fb3] Archived website id = 1, period = month, 610566 visits, Time elapsed: 0.211s
[2012-02-22 11:16:13] [8caa6fb3] Archived website id = 1, period = year, 610567 visits, Time elapsed: 138.519s
[2012-02-22 11:16:13] [8caa6fb3] Archived website id = 1, today = 3744 visits, 4 API requests, Time elapsed: 139.157s [1/8 done]
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 2, already processed today's report in recent run, 13 Minuten 28s ago, Time elapsed: 0.002s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 3, already processed today's report in recent run, 13 Minuten 19s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 4, already processed today's report in recent run, 13 Minuten 9s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 5, already processed today's report in recent run, 12 Minuten 13s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 9, already processed today's report in recent run, 12 Minuten 6s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 10, already processed today's report in recent run, 12 Minuten 1s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Skipped website id 11, already processed today's report in recent run, 11 Minuten 52s ago, Time elapsed: 0.001s
[2012-02-22 11:16:13] [8caa6fb3] Done archiving!
[2012-02-22 11:16:13] [8caa6fb3] ---------------------------
[2012-02-22 11:16:13] [8caa6fb3] SUMMARY
[2012-02-22 11:16:13] [8caa6fb3] Total daily visits archived: 3744
[2012-02-22 11:16:13] [8caa6fb3] Archived today's reports for 1 websites
[2012-02-22 11:16:13] [8caa6fb3] Archived week/month/year for 1 websites. 
[2012-02-22 11:16:13] [8caa6fb3] Skipped 8 websites: no new visit since the last script execution
[2012-02-22 11:16:13] [8caa6fb3] Skipped 7 websites day archiving: existing daily reports are less than 1800 seconds old
[2012-02-22 11:16:13] [8caa6fb3] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-02-22 11:16:13] [8caa6fb3] Total API requests: 4
[2012-02-22 11:16:13] [8caa6fb3] done: 1/8 13%, 3744 v, 1 wtoday, 1 wperiods, 4 req, 139169 ms, no error
[2012-02-22 11:16:13] [8caa6fb3] Time elapsed: 139.169s
[2012-02-22 11:16:13] [8caa6fb3] ---------------------------
[2012-02-22 11:16:13] [8caa6fb3] SCHEDULED TASKS
[2012-02-22 11:16:13] [8caa6fb3] Starting Scheduled tasks... 
[2012-02-22 11:16:14] [8caa6fb3]  No task to run
[2012-02-22 11:16:14] [8caa6fb3] done

But the error in the post before should be fixed.


(Matthieu Aubry) #6

Check your error logs - I suspect that the archiving requests are failing due to some kind of memory errors maybe?


#7

The problem with the archiving.php seems to be solved.
We don’t get any further errors.

But the main problem still exists.
When i select the time period 20120201 - 20120224 for site 1 and choose actions/sites i don’t get any output. The funny thing is, when i choose the time period for the month 02, then i will get an output immediately.

So which logs should i check?

  • PHP
  • Apache
  • Piwik

(Matthieu Aubry) #8

The “custom date ranges” are not pre-processed, so if they don’t show up it means the server crashes (check your error logs)


#9

I activated the debug log in apache and php.
I activated the slow-log in mysql.
I activated the log in piwik.
I don’t get any errors.

Piwik can display the “custom date ranges” 20120201 - 20120226 for actions/sites.
But it can’t display 20120201 - 20120225 or 20120201 - 20120225. I get nothing or it says the there are no data available. Funny.

There must be a bug or i do something wrong.

Should always_archive_data_range be activated?

Please help.


(Matthieu Aubry) #10

Should always_archive_data_range be activated?
No, but you can also enable it for tests (it will ALWAYS archive so will be slow - remember to disable after tests)

When you get a blank response, it means the server crashed. See my tips on checking your error logs works 301 Moved Permanently


#11

The logging works fine.
I don’t get a blank site.
The piwik doesn’t stops to load.


(Matthieu Aubry) #12

Check your error logs


#13

I don’t get any errors in the logs.

Please correct me if I’m wrong.
I did the following changes to activate logging:

  • Apache:

        LogLevel debug
        CustomLog ${APACHE_LOG_DIR}/access.log combined
        ErrorLog ${APACHE_LOG_DIR}/error.log

  • PHP:

error_reporting = E_ALL
display_errors = On
log_errors = On
report_memleaks = On
error_log = /tmp/php_errors.log

  • Piwik global.ini.php:

enable_sql_profiler = 1
logger_message[]               = file
logger_error[]                 = file
logger_exception[]             = file

Is there more to activate?


(Matthieu Aubry) #14

IF you create a file test.php <?php echo bla();
Does it log the error in apache error log?


#15

The logging of php errors is running fine.

I got an error :slight_smile:


There is an error. Please report the message and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Warning: Division by zero in /var/www/piwik/core/Piwik.php on line 1217

Backtrace -->
#0 Piwik_ErrorHandler(...) called at [/var/www/piwik/core/Piwik.php:1217]#1 Piwik::printSqlProfilingReportZend(...) called at [/var/www/piwik/core/FrontController.php:176]#2 Piwik_FrontController->__destruct(...) called at [:]

After that the request was successful.


Called: Piwik_Actions_API.getPageUrls (took 204452.132ms)
Parameters: idSite = '1', period = 'range', date = '2012-02-01,2012-02-27', segment = , expanded = , idSubtable = , 


#16

I’ve updatet to Piwik 1.7.1.
Not i have problems with the archiving:


[28-Feb-2012 11:30:18] 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: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=11&period=day&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp. Response was 'curl_exec: Empty reply from server' in /var/www/piwik/misc/cron/archive.php on line 519


#17

When i do:


curl https://piwik.bpa2011.bundesregierung.de/index.php?module=API&method=VisitsSummary.getVisits&idSite=11&period=day&date=last2&format=php&token_auth=9058b925924ade1718609601559e7472&trigger=archivephp

i get


<result>
	<error message="The parameter 'method' isn't set in the Request, and a default value wasn't provided." />
</result>


#18

I did a trace on the archive.php and i got this:


nanosleep({0, 10000000}, NULL)          = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
clock_gettime(CLOCK_MONOTONIC, {13494, 864035047}) = 0
clock_gettime(CLOCK_MONOTONIC, {13494, 864035047}) = 0
clock_gettime(CLOCK_MONOTONIC, {13494, 864035047}) = 0

Is this a normal behavior?


(Matthieu Aubry) #19

you forgot double quotes around URL


#20

I corrrected the parameter. I wait till tomorrow.