Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007300opensim[GRID] Other Servicepublic2014-08-11 09:512020-11-19 10:25
Assigned Totampa 
StatusresolvedResolutionunable to reproduce 
PlatformOperating SystemOperating System Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0007300: Estate managers and users table fill with multiple duplicate entries
DescriptionEvery now and then a user reports their viewer crashes when they open the Region/Estate dialog box in the viewer. The cause of the crash is due to multiple duplicate entries in the estate_managers and estate_users table of the estate database. A given combination of estate ID and UUID have been seen in the database table thousands(!) of times.

I just had another instance of this problem where I had to remove over 1,500 duplicate entries from the estate_managers table and over 11,500 duplicate entries from the estate_users table.
Steps To ReproduceI have no idea how to reproduce the problem. It doesn't show up very often but it has been around for a while. I have seen it in 0.7.6-post-fixes and it might even go back as far as the 0.7.2 release.
Additional InformationIf there was a unique index that combined the EstateID and uuid fields on the estate_managers and estate_users table it would prevent the duplicates from getting saved in the database tables. It wouldn't solve the reason for this happening but it would prevent the problems it causes by preventing the saving of duplicate entries in the tables.
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (1 Region per Sim)
Physics EngineBulletSim
Script Engine
Environment.NET / Windows64
Mono VersionNone
Attached Files

- Relationships

-  Notes
kcozens (administrator)
2014-08-12 12:47

When trying to add unique indexes I discovered there were several duplicates in each table where a pair of values appeared twice. I cleaned out duplicates from the estate_managers and estate_users by doing an export of the table data, truncating the two tables, edited the table dumps to use "INSERT IGNORE", added UNIQUE indexes, and imported the data from the dumps.

The following SQL statements add indexes that will prevent duplicate data from being saved.

ALTER TABLE `estate`.`estate_managers` ADD UNIQUE `EstateManager` (`EstateID`, `uuid`) COMMENT '';
ALTER TABLE `estate`.`estate_users` ADD UNIQUE `EstateUser` (`EstateID`, `uuid`) COMMENT '';

It is possible that this may result in exceptions when the code tries to save duplicates. If so, that might help pin down the cause of the problem. The additional indexes are a work around and prevent viewer crashes when accessing Region and/or estate data.

- Issue History
Date Modified Username Field Change
2014-08-11 09:51 kcozens New Issue
2014-08-12 12:47 kcozens Note Added: 0026738
2020-11-19 10:25 tampa Status new => resolved
2020-11-19 10:25 tampa Resolution open => unable to reproduce
2020-11-19 10:25 tampa Assigned To => tampa

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker