Bug #657

New problems with trend count

Added by bo over 2 years ago. Updated over 2 years ago.

Status:Closed Start date:10/05/2009
Priority:Normal Due date:
Assignee:psychonic % Done:

0%

Category:Daemon
Target version:1.6.2
Affected Version: Blocking Target Version:

Description

Tracking 63,733 players (+57,540 new players last 24h) with 4,562,383 kills (+8,388 last 24h) and 62,085 headshots (1.36%) on 3 servers

:P


Related issues

related to HLstatsX: CE - Task #898: Server groups showing +4000 new players last 24h Rejected 12/07/2009

Associated revisions

Revision 12:cc1d32d1f160
Added by psychonic over 2 years ago

[svn r1384] Moved tf2 hit_by_train action detection from superlogs:tf2 log line to daemon.
Minor optimizations in superlogs:tf2.
Fixed crash errors in daemon caused by invalid server object, probably fixed #638 (BoNzO).
Event insertion queries now get prepared and reused to severely cut down on overall time spent in queries as noted in issue #543 (agent86).
Attempted to revert trend recording to old method (but keeping bugfix that came with change), hopefully resolves #657.
Fixed potential array out of bounds error in hlstatsx.sp.
Added logic to hlstatsx.sp to detect (from manual list of games) whether or not game can use html motds to hide menu options that would be unavailable.
Possibly fixed more miscolorings of names in hlstatsx.sp.
Other minor optimizations in hlstatsx.sp.

Revision 11:cc1d32d1f160
Added by nshastings over 2 years ago

[svn r1384] Moved tf2 hit_by_train action detection from superlogs:tf2 log line to daemon.
Minor optimizations in superlogs:tf2.
Fixed crash errors in daemon caused by invalid server object, probably fixed #638 (BoNzO).
Event insertion queries now get prepared and reused to severely cut down on overall time spent in queries as noted in issue #543 (agent86).
Attempted to revert trend recording to old method (but keeping bugfix that came with change), hopefully resolves #657.
Fixed potential array out of bounds error in hlstatsx.sp.
Added logic to hlstatsx.sp to detect (from manual list of games) whether or not game can use html motds to hide menu options that would be unavailable.
Possibly fixed more miscolorings of names in hlstatsx.sp.
Other minor optimizations in hlstatsx.sp.

Revision 4:a93bf6fe0be2
Added by nshastings over 2 years ago

[svn r1384] Moved tf2 hit_by_train action detection from superlogs:tf2 log line to daemon.
Minor optimizations in superlogs:tf2.
Fixed crash errors in daemon caused by invalid server object, probably fixed #638 (BoNzO).
Event insertion queries now get prepared and reused to severely cut down on overall time spent in queries as noted in issue #543 (agent86).
Attempted to revert trend recording to old method (but keeping bugfix that came with change), hopefully resolves #657.
Fixed potential array out of bounds error in hlstatsx.sp.
Added logic to hlstatsx.sp to detect (from manual list of games) whether or not game can use html motds to hide menu options that would be unavailable.
Possibly fixed more miscolorings of names in hlstatsx.sp.
Other minor optimizations in hlstatsx.sp.

Revision 32:a92245ecd9bc
Added by psychonic over 2 years ago

[svn r1420] Really fixed player trend count issue (will take 24h to correct itself). Finally resolves issue #657.
Added pruning of hlstats_Trend to hlstats-awards.pl. Now saves only 48h of data (only up to 24h + one record is ever used). Resolves issue #773.
Added filling of createdate column in hlstats_Players.
Removed some unused OnTakeDamage ext files (source still available).
Clarified more output in hlstats-awards.pl.
Added initial population of new createdate field in hlstats_Players for existing players.
Added simple batch script to check syntax of all perl files to use before commit/release.

Revision 31:a92245ecd9bc
Added by nshastings over 2 years ago

[svn r1420] Really fixed player trend count issue (will take 24h to correct itself). Finally resolves issue #657.
Added pruning of hlstats_Trend to hlstats-awards.pl. Now saves only 48h of data (only up to 24h + one record is ever used). Resolves issue #773.
Added filling of createdate column in hlstats_Players.
Removed some unused OnTakeDamage ext files (source still available).
Clarified more output in hlstats-awards.pl.
Added initial population of new createdate field in hlstats_Players for existing players.
Added simple batch script to check syntax of all perl files to use before commit/release.

Revision 9:f9f2e28e5d88
Added by nshastings over 2 years ago

[svn r1420] Really fixed player trend count issue (will take 24h to correct itself). Finally resolves issue #657.
Added pruning of hlstats_Trend to hlstats-awards.pl. Now saves only 48h of data (only up to 24h + one record is ever used). Resolves issue #773.
Added filling of createdate column in hlstats_Players.
Removed some unused OnTakeDamage ext files (source still available).
Clarified more output in hlstats-awards.pl.
Added initial population of new createdate field in hlstats_Players for existing players.
Added simple batch script to check syntax of all perl files to use before commit/release.

History

#1 Updated by psychonic over 2 years ago

  • Category changed from Web to Daemon

I'm relatively sure this is related to the recent (1.6.0) changes to how the data in hlstats_Trend is recorded.

#2 Updated by psychonic over 2 years ago

  • Status changed from New to Assigned

#3 Updated by psychonic over 2 years ago

  • Assignee deleted (psychonic)

#4 Updated by psychonic over 2 years ago

  • Status changed from Assigned to UserFeedback

I committed an attempt at this in r1384. I made the patch a couple weeks ago and just hadn't committed it yet, and I'm not positive that it fixes the issue since I was never experiencing it myself.

Someone who is having the issue should try out the fix and see if the count has adjusted to normal after 24h have passed.

#5 Updated by psychonic over 2 years ago

  • Status changed from UserFeedback to Closed
  • Assignee set to psychonic

Finally found/fixed in r1420. Will take 24 hours after fix to correct itself.

Also available in: Atom PDF