Hi,
I have a problem in getting the reports in piwik from a date range greater than 180 days on ‘row evolution panel’.
When I want to access it, this error occurs.
Requests are blocked after 60 seconds, the timeout seems actually tied to webseal, whereas on webseals the timeout is 90 seconds, moreover we would like to know If there is a piwik timeout request on config file.
Thanks
Hi there,
can you check your server error log file for more information? Piwik does not enforce a timeout so this timeout must be in your server or other software.
These are piwik error logs:
mysqld.log
150203 15:19:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist
150203 15:19:49 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
150203 15:19:49 InnoDB: Initializing buffer pool, size = 8.0M
150203 15:19:49 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
150203 15:19:49 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
150203 15:19:50 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
150203 15:19:50 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
150203 15:19:50 InnoDB: Started; log sequence number 0 0
150203 15:19:50 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
150203 15:19:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150203 15:20:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist
150203 15:20:49 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
150203 15:20:49 InnoDB: Initializing buffer pool, size = 8.0M
150203 15:20:49 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
150203 15:20:49 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
150203 15:20:49 InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percents: 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150203 15:20:49 InnoDB: Started; log sequence number 0 44233
150203 15:20:49 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
150203 15:20:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150203 15:22:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150203 15:22:32 InnoDB: Initializing buffer pool, size = 8.0M
150203 15:22:32 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
150203 15:22:32 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
150203 15:22:32 InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percents: 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150203 15:22:32 InnoDB: Started; log sequence number 0 44233
150203 15:22:32 [Note] Event Scheduler: Loaded 0 events
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘"sqlpiwikprd) Where user=‘root’’ at line 1
150203 15:22:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
150203 15:31:08 [Note] /usr/libexec/mysqld: Normal shutdown
150203 15:31:08 [Note] Event Scheduler: Purging the queue. 0 events
150203 15:31:08 InnoDB: Starting shutdown…
150203 15:31:13 InnoDB: Shutdown completed; log sequence number 0 44233
150203 15:31:13 [Note] /usr/libexec/mysqld: Shutdown complete
150203 15:31:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150203 15:31:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150203 15:31:18 InnoDB: Initializing buffer pool, size = 8.0M
150203 15:31:18 InnoDB: Completed initialization of buffer pool
150203 15:31:18 InnoDB: Started; log sequence number 0 44233
150203 15:31:18 [Note] Event Scheduler: Loaded 0 events
150203 15:31:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
150901 11:34:12 [Note] /usr/libexec/mysqld: Normal shutdown
150901 11:34:12 [Note] Event Scheduler: Purging the queue. 0 events
150901 11:34:12 InnoDB: Starting shutdown…
150901 11:34:14 InnoDB: Shutdown completed; log sequence number 0 1669626938
150901 11:34:14 [Note] /usr/libexec/mysqld: Shutdown complete
150901 11:34:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150902 17:00:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150902 17:00:11 InnoDB: Initializing buffer pool, size = 8.0M
150902 17:00:11 InnoDB: Completed initialization of buffer pool
150902 17:00:11 InnoDB: Started; log sequence number 0 1669626938
150902 17:00:11 [Note] Event Scheduler: Loaded 0 events
150902 17:00:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
160224 17:31:47 [Note] /usr/libexec/mysqld: Normal shutdown
160224 17:31:47 [Note] Event Scheduler: Purging the queue. 0 events
160224 17:31:48 InnoDB: Starting shutdown…
160224 17:31:52 InnoDB: Shutdown completed; log sequence number 4 983065529
160224 17:31:52 [Note] /usr/libexec/mysqld: Shutdown complete
160224 17:31:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160224 17:31:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160224 17:31:53 InnoDB: Initializing buffer pool, size = 8.0M
160224 17:31:53 InnoDB: Completed initialization of buffer pool
160224 17:31:53 InnoDB: Started; log sequence number 4 983065529
160224 17:31:54 [Note] Event Scheduler: Loaded 0 events
160224 17:31:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
160224 18:09:20 [Note] /usr/libexec/mysqld: Normal shutdown
160224 18:09:20 [Note] Event Scheduler: Purging the queue. 0 events
160224 18:09:20 InnoDB: Starting shutdown…
160224 18:09:22 InnoDB: Shutdown completed; log sequence number 4 983084614
160224 18:09:22 [Note] /usr/libexec/mysqld: Shutdown complete
160224 18:09:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160224 18:09:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160224 18:09:28 InnoDB: Initializing buffer pool, size = 2.0G
160224 18:09:29 InnoDB: Completed initialization of buffer pool
160224 18:09:29 InnoDB: Started; log sequence number 4 983084614
160224 18:09:29 [Note] Event Scheduler: Loaded 0 events
160224 18:09:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
160224 18:15:10 [Note] /usr/libexec/mysqld: Normal shutdown
160224 18:15:10 [Note] Event Scheduler: Purging the queue. 0 events
160224 18:15:10 InnoDB: Starting shutdown…
160224 18:15:14 InnoDB: Shutdown completed; log sequence number 4 983133796
160224 18:15:14 [Note] /usr/libexec/mysqld: Shutdown complete
160224 18:15:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160224 18:22:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160224 18:22:59 InnoDB: Initializing buffer pool, size = 1.0G
160224 18:22:59 InnoDB: Completed initialization of buffer pool
160224 18:23:00 InnoDB: Started; log sequence number 4 983133796
160224 18:23:00 [Note] Event Scheduler: Loaded 0 events
160224 18:23:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.66’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
piwik_report.log
INFO CoreConsole[2016-04-06 15:30:02] ---------------------------
INFO CoreConsole[2016-04-06 15:30:02] INIT
INFO CoreConsole[2016-04-06 15:30:02] Piwik is installed at: https://intrapiwik.gbbper.priv/piwik/index.php
INFO CoreConsole[2016-04-06 15:30:02] Running Piwik 2.10.0 as Super User
INFO CoreConsole[2016-04-06 15:30:02] ---------------------------
INFO CoreConsole[2016-04-06 15:30:02] NOTES
INFO CoreConsole[2016-04-06 15:30:02] - Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2016-04-06 15:30:02] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2016-04-06 15:30:02] - Archiving was last executed without error 59 min 59s ago
INFO CoreConsole[2016-04-06 15:30:03] - Will process 1 websites with new visits since 59 min 59s , IDs: 1
INFO CoreConsole[2016-04-06 15:30:03] ---------------------------
INFO CoreConsole[2016-04-06 15:30:03] START
INFO CoreConsole[2016-04-06 15:30:03] Starting Piwik reports archiving…
INFO CoreConsole[2016-04-06 15:30:19] Archived website id = 1, period = day, 41896 visits in last last2 days, 20631 visits today, Time elapsed: 15.914s
INFO CoreConsole[2016-04-06 15:30:25] Archived website id = 1, period = week, 138998 visits in last last2 weeks, 63721 visits this week, Time elapsed: 6.361s
INFO CoreConsole[2016-04-06 15:30:31] Archived website id = 1, period = month, 518517 visits in last last2 months, 82666 visits this month, Time elapsed: 5.559s
INFO CoreConsole[2016-04-06 15:30:45] Archived website id = 1, period = year, 2344083 visits in last last2 years, 1193237 visits this year, Time elapsed: 14.231s
INFO CoreConsole[2016-04-06 15:30:53] Archived website id = 1, period = range, 417515 visits in last last30 ranges, 417515 visits this range, Time elapsed: 7.959s
INFO CoreConsole[2016-04-06 15:30:53] Archived website id = 1, 5 API requests, Time elapsed: 50.032s [1/1 done]
INFO CoreConsole[2016-04-06 15:30:53] Done archiving!
INFO CoreConsole[2016-04-06 15:30:53] ---------------------------
INFO CoreConsole[2016-04-06 15:30:53] SUMMARY
INFO CoreConsole[2016-04-06 15:30:53] Total visits for today across archived websites: 20631
INFO CoreConsole[2016-04-06 15:30:53] Archived today’s reports for 1 websites
INFO CoreConsole[2016-04-06 15:30:53] Archived week/month/year for 1 websites
INFO CoreConsole[2016-04-06 15:30:53] Skipped 0 websites: no new visit since the last script execution
INFO CoreConsole[2016-04-06 15:30:53] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
INFO CoreConsole[2016-04-06 15:30:53] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO CoreConsole[2016-04-06 15:30:53] Total API requests: 5
INFO CoreConsole[2016-04-06 15:30:53] done: 1/1 100%, 20631 vtoday, 1 wtoday, 1 wperiods, 5 req, 50098 ms, no error
INFO CoreConsole[2016-04-06 15:30:53] Time elapsed: 50.098s
INFO CoreConsole[2016-04-06 15:30:53] ---------------------------
INFO CoreConsole[2016-04-06 15:30:53] SCHEDULED TASKS
INFO CoreConsole[2016-04-06 15:30:53] Starting Scheduled tasks…
INFO CoreConsole[2016-04-06 15:30:54] task,output
Piwik\Plugins\ExamplePlugin\Tasks.myTask,Time elapsed: 0.000s
INFO CoreConsole[2016-04-06 15:30:54] done
INFO CoreConsole[2016-04-06 15:30:54] ---------------------------
php-errors.log
[24-Feb-2016 16:49:07 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/piwik/core/Plugin/Manager.php on line 370
[24-Feb-2016 16:49:07 UTC] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Maximum execution time of 30 seconds exceeded’ in /var/www/html/piwik/plugins/CorePluginsAdmin/Controller.php:350
Stack trace:
0 [internal function]: Piwik\Plugins\CorePluginsAdmin\Controller->safemode(Array)
1 /var/www/html/piwik/core/FrontController.php(586): call_user_func_array(Array, Array)
2 /var/www/html/piwik/core/FrontController.php(96): Piwik\FrontController->doDispatch(‘CorePluginsAdmi…’, ‘safemode’, Array)
3 /var/www/html/piwik/core/FrontController.php(258): Piwik\FrontController->dispatch(‘CorePluginsAdmi…’, ‘safemode’, Array)
4 [internal function]: Piwik\FrontController::triggerSafeModeWhenError()
5 {main}
thrown in /var/www/html/piwik/plugins/CorePluginsAdmin/Controller.php on line 350
Hi matthieu,
can you give me support?
Thanks
