| Anonymous | Login | Signup for a new account | 2019-02-20 10:54 PST |  |
| Main | My View | View Issues | Change Log | Roadmap | Summary | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||
| 0005704 | opensim | [GRID] User Service | public | 2011-09-23 05:37 | 2019-02-06 11:46 | |||||
| Reporter | Bo Iwu | |||||||||
| Assigned To | ||||||||||
| Priority | normal | Severity | tweak | Reproducibility | always | |||||
| Status | acknowledged | Resolution | open | |||||||
| Platform | OS | OS Version | ||||||||
| Product Version | ||||||||||
| Target Version | Fixed in Version | |||||||||
| Summary | 0005704: Regulary remove users with zero RegionID from table Presence | |||||||||
| Description | Regularly 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 Information | Running 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. | |||||||||
| Tags | No tags attached. | |||||||||
| Git Revision or version number | any | |||||||||
| Run Mode | Grid (Multiple Regions per Sim) | |||||||||
| Physics Engine | BasicPhysics | |||||||||
| Environment | Mono / Linux32 | |||||||||
| Mono Version | 2.10.2 | |||||||||
| Viewer | Imprudence | |||||||||
| Attached Files | ||||||||||
 Relationships |
||||||
|
||||||
 Relationships |
|
Notes |
|
|
(0034548) 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. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |