|Anonymous | Login | Signup for a new account||2020-01-22 05:33 PST|
|Main | My View | View Issues | Change Log | Roadmap | Summary | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0008439||opensim||[REGION] OpenSim Core||public||2019-01-01 07:58||2019-02-06 07:56|
|Product Version||master (dev code)|
|Target Version||master (dev code)||Fixed in Version|
|Summary||0008439: Region maptiles - can previous tiles be removed from database as they are replaced by later versions|
|Description||Region 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_%";
|Tags||No tags attached.|
|Git Revision or version number||opensim-0.9.0.1-685-g9c043fe.zip|
|Run Mode||Grid (Multiple Regions per Sim)|
|Environment||.NET / Windows64|
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.
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
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?
|AllowRemoteDeleteAllTypes should stay false <--- or all types can be deleted|
|What was the reasoning for setting the default to false?|
|reason lost in time..|
|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?|
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.
paela argus (reporter)
because if you use fsassets is not needed AllowRemoteDelete = true
use old db think for assets at this years why ?
|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|