|Anonymous | Login | Signup for a new account||2020-01-21 03:30 PST|
|Main | My View | View Issues | Change Log | Roadmap | Summary | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0007300||opensim||[GRID] Other Service||public||2014-08-11 09:51||2014-08-12 12:47|
|Product Version||master (dev code)|
|Target Version||Fixed in Version|
|Summary||0007300: Estate managers and users table fill with multiple duplicate entries|
|Description||Every 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 Reproduce||I 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 Information||If 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.|
|Tags||No tags attached.|
|Git Revision or version number|
|Run Mode||Grid (1 Region per Sim)|
|Environment||.NET / Windows64|
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.
|2014-08-11 09:51||kcozens||New Issue|
|2014-08-12 12:47||kcozens||Note Added: 0026738|
|Copyright © 2000 - 2012 MantisBT Group|