Creating segment never finishes 'Loading data'


We are using Piwik 2.14.0 to track multiple sites. The biggest site gets about 8,000 hits a day. The piwik_log_visit table has about 11 million rows in it.

When I attempt to create a new segment, everything works fine until I click the Save and Apply button. After clicking the button, it displays the ‘Loading data’ message but, never completes.

I changed logging to DEBUG in the config.ini.php but, nothing shows up as a problem. I don’t see anything related to UI activity in the Apache error log, the access log, or the mysqld log.

Does anyone have any suggestions on troubleshooting this, aside from upgrading to 2.16.0?


Update to Piwik 2.16 and disable realtime segments (the archiving process will do the job). Here are the settings (add this in the [General] section in your config.ini.php):

browser_archiving_disabled_enforce = 1 enable_create_realtime_segments = 0

If you don’t have archiving set up, see also How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo