[Building Sakai] sitestats - problem

[Peter Krooks]

Hi,
Umea University (running Sakai 2.5.4) is having a big problem with the site-stats tool.

The "Last updated on:"-info in Sitestats keeps popping back in time and only old statistics is available.

We are running a SiteStats job/Event Aggregator in quartz job scehduler every 10 minutes.  SAKAI_EVENTS currently holds  7 500 000 lines.

The log shows that when the quartz job reaches the last event and has 0 events to process it flips and starts from eventid 0 and "last updated" pops back.

   INFO: Summary: 6 events processed (ids: 4590947 - 4590952) in 0s        (2009-09-23 03:20:00,036 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
   INFO: Summary: 15 events processed (ids: 4590971 - 4590985) in 0s      (2009-09-23 03:50:00,356 QuartzScheduler_Worker-4_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
   INFO: Summary: 0 events processed (ids: 0 - 0) in 0s                                    (2009-09-23 04:00:00,027 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
   INFO: Summary: 50000 events processed (ids: 108 - 54003) in 98s (2009-09-23 04:11:38,026 QuartzScheduler_Worker-0_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
   INFO: Summary: 50000 events processed (ids: 305604 - 355853) in 87s (2009-09-23 05:11:27,681 QuartzScheduler_Worker-4_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)


We applied patch : http://jira.sakaiproject.org/browse/STAT-97 to no use.

Any ideas or advice on  this would be greatly appreciated!

Thanks!
Regards,
Peter Krooks
Umdac, Umea University