Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005704opensim[GRID] User Servicepublic2011-09-23 05:372019-02-06 11:46
ReporterBo Iwu 
Assigned To 
PlatformOperating SystemOperating System Version
Product Version 
Target VersionFixed in Version 
Summary0005704: Regulary remove users with zero RegionID from table Presence
DescriptionRegularly run equivalent of this query:
DELETE FROM Presence WHERE RegionID = '00000000-0000-0000-0000-000000000000';

Verified result:
zombie agents who crashed in middle of TP lure are no more shown as online to other grid users.
Additional InformationRunning this query as a daemon for more than week and have no longer trouble with friends who are falsely indicated as online.

After removing the zero region entry the grid indicates change of the status to online users within 5 minutes.
TagsNo tags attached.
Git Revision or version numberany
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBasicPhysics
Script Engine
EnvironmentMono / Linux32
Mono Version2.10.2
Attached Files

- Relationships
related to 0004959closedjustincc Avatar online presence indicators in friends list show them online even though they are definitely logged off 

-  Notes
tampa (reporter)
2019-02-06 11:46

While this can be done using a simple cron it really should be part of robust. However, this query should only be executed in certain conditions:

1. If the condition exists for a few minutes, as during transfer over hg the regionid may become nullkey
2. If the condition exists and the user has attempted to login multiple times.

- Issue History
Date Modified Username Field Change
2011-09-23 05:37 Bo Iwu New Issue
2011-09-23 05:37 Bo Iwu Git Revision => any
2011-09-23 05:37 Bo Iwu Run Mode => Grid (Multiple Regions per Sim)
2011-09-23 05:37 Bo Iwu Physics Engine => BasicPhysics
2011-09-23 05:37 Bo Iwu Environment => Mono / Linux32
2011-09-23 05:37 Bo Iwu Mono Version => 2.10.2
2011-09-23 05:37 Bo Iwu Viewer => Imprudence
2011-09-23 06:36 Bo Iwu Relationship added related to 0004959
2019-02-06 11:46 tampa Note Added: 0034548
2019-02-06 11:46 tampa Status new => acknowledged

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker