[Building Sakai] sitestats - problem

[Nuno Fernandes]

Hi Peter,
This is a very strange behavior! To help me track this down, could you
please give me further details such as:

   - DB used (MySQL/Oracle)
   - if you ever clean (remove/move) SAKAI_EVENT entries
   - Last entries from SST_JOB_RUN (eventually, the ones related with the
   log entries you sent)
   - Additional related log entries (if any)
   - The SiteStats related configuration from sakai.properties

Thank you,
Nuno


2009/10/19 Peter Krooks <Peter.Krooks at umdac.umu.se>

> 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
>



-- 
Nuno Fernandes  [linkedin.com/in/nfgrilo | codingwithcoffee.com]
Analyst/Programmer - UFP-UV  [elearning.ufp.pt]
Software Developer - Sakai Foundation  [sakaiproject.org]
Sakai Fellow 2008 - Sakai Foundation  [confluence.sakaiproject.org//x/6oCTAQ
]

Universidade Fernando Pessoa  [www.ufp.pt]
Praça 9 de Abril, 349
4249-004 Porto
tel: + 351 22 507 13 00
fax: + 351 22 550 82 69
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20091019/73f9805a/attachment.html