[SAK-33437] Sitestats treats event_id as Integer Created: 09-Oct-2017  Updated: 16-Oct-2017  Resolved: 09-Oct-2017

Status: Verified
Project: Sakai
Component/s: Sitestats
Affects Version/s: 11.2
Fix Version/s: 11.5 [Tentative], 12.0, 19.0

Type: Bug Priority: Critical
Reporter: Ashley Willis Assignee: Sam Ottenhoff
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

12 status: Resolved
11 status: Resolved
Test Plan:

Please add a Test Plan here.


Our site stats quit processing. The job was running but not processing any records. The log entries look like:
09-Oct-2017 13:35:20.316 INFO [QuartzScheduler_Worker-3] org.sakaiproject.sitestats.impl.StatsAggregateJobImpl.execute Summary: 0 events processed in 0s (no entry will be added to SST_JOB_RUN; only events associated with a session are processed)
The last event it successfully processed was event_id 2147483647 which happens to be the max value for Integer.
It turns out org.sakaiproject.sitestats.impl.StatsAggregateJobImpl is getting event_id from the resultset as an Integer:

lastProcessedEventId = rs.getInt("EVENT_ID");
Should be:
lastProcessedEventId = rs.getLong("EVENT_ID");

Generated at Sat Jan 18 05:19:52 CST 2020 using Jira 8.0.3#800011-sha1:073e8b433c2c0e389c609c14a045ffa7abaca10d.