Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008439opensim[REGION] OpenSim Corepublic2019-01-01 07:582019-02-06 07:56
Reporteraiaustin 
Assigned To 
PrioritynormalSeveritytweakReproducibilityalways
StatusnewResolutionopen 
PlatformPCOSWindowsOS Version10
Product Versionmaster (dev code) 
Target Versionmaster (dev code)Fixed in Version 
Summary0008439: Region maptiles - can previous tiles be removed from database as they are replaced by later versions
DescriptionRegion maptiles are stored in the opensim.assets data table each time they are produced. But, as far as I understand, previous copies will never be used again. A good time to tidy the data base would seem to be at exactly the time that a new tile is stored, with older versions for that region UUID being deleted at that time.

Note that at present I occasionally do the following mysql console command while the grid is stopped and sometimes thousands of these are deleted... even on a simple grid.

DELETE FROM opensim.assets WHERE name LIKE "terrainImage_%";
TagsNo tags attached.
Git Revision or version numberopensim-0.9.0.1-685-g9c043fe.zip
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
Environment.NET / Windows64
Mono VersionNone
ViewerN/A
Attached Files

- Relationships

-  Notes
(0034325)
tampa (reporter)
2019-02-05 13:37

Actually a very good question. The map tiles seem to be entered into the database as new asset even if their hash is identical. I believe they are in there for robust to be able to serve them directly, but why it creates new entries each time... strange.

I have fields for the creation date in my tables, perhaps a query to clear all but the newest tile would make more sense, then again ideally the entry in the database would be updated instead of new ones being created.
(0034326)
UbitUmarov (administrator)
2019-02-05 14:58
edited on: 2019-02-05 14:59

commands to delete old terrain image and parcel image are actually issued on map generation.
but they are currently ignored unless you set AllowRemoteDelete = true on robust.ini.
AllowRemoteDeleteAllTypes should stay false

(0034327)
tampa (reporter)
2019-02-05 15:10

Doesn't AllowRemoteDelete also enable deletion of other assets though or just the maptiles?

Why do we still store them that way if they are stored in maptiles folder, just for v1 viewers? Should those still be supported at this point?

I just issued a delete on all these entries I have on my assets table, so far nothing has caught fire, you sure these are actively used still?
(0034328)
UbitUmarov (administrator)
2019-02-05 15:12

AllowRemoteDeleteAllTypes should stay false <--- or all types can be deleted
(0034330)
tampa (reporter)
2019-02-05 15:20

What was the reasoning for setting the default to false?
(0034331)
UbitUmarov (administrator)
2019-02-05 15:20

reason lost in time..
(0034332)
tampa (reporter)
2019-02-05 15:28

So then why not change this and prevent blowing up asset tables with useless older versions of maptiles that are never even going to be used even if they happen to be requested by a v1 viewer, because I suppose that also only fetches the most current version?
(0034334)
aiaustin (developer)
2019-02-06 02:06

Thanks for pointing out this Robust[.HG].ini setting which I did not know about. I changed it to AllowRemoteDelete = true on the Openvue and Ailand grid.

Would it be worth setting this parameter to true by default now as these data base entries do build up.
(0034337)
paela argus (reporter)
2019-02-06 07:56

because if you use fsassets is not needed AllowRemoteDelete = true
use old db think for assets at this years why ?

- Issue History
Date Modified Username Field Change
2019-01-01 07:58 aiaustin New Issue
2019-01-01 07:59 aiaustin Description Updated View Revisions
2019-01-01 10:51 aiaustin Description Updated View Revisions
2019-02-05 13:37 tampa Note Added: 0034325
2019-02-05 14:58 UbitUmarov Note Added: 0034326
2019-02-05 14:59 UbitUmarov Note Edited: 0034326 View Revisions
2019-02-05 15:10 tampa Note Added: 0034327
2019-02-05 15:12 UbitUmarov Note Added: 0034328
2019-02-05 15:20 tampa Note Added: 0034330
2019-02-05 15:20 UbitUmarov Note Added: 0034331
2019-02-05 15:28 tampa Note Added: 0034332
2019-02-06 02:06 aiaustin Note Added: 0034334
2019-02-06 07:56 paela argus Note Added: 0034337


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker