Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008324opensim[REGION] OpenSim Corepublic2018-05-26 11:532018-05-27 14:47
Reporterclaudio 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
Platformx86_64OSLinuxOS VersionLinux Mint 18.3
Product Version0.9.0 
Target VersionFixed in Version 
Summary0008324: delete-region command blocks and does not do anything useful
Descriptionas in the summary.

I could not find a way to safely delete a region without dropping the mysql database completely.
Steps To Reproduce# delete-region [region]
Additional Informationusing 3 regions:

1 default region (no oar loaded)
1 free mall region
1 conference center region

TagsNo tags attached.
Git Revision or version number
Run Mode Standalone (Multiple Regions)
Physics EngineBulletSim
EnvironmentMono / Linux64
Mono VersionOther
Vieweralchemy
Attached Files

- Relationships

-  Notes
(0032683)
claudio (reporter)
2018-05-26 11:55

using mysql Ver 15.1 Distrib 10.0.34-MariaDB
(0032684)
watcher64 (reporter)
2018-05-26 11:59

make sure your collation type is UTF8 not utf8mb4, also if you want to drop a region, and the command does not work, just drop that region from the regions table, remove the INI entries for it, and fire the simulator back up, it will not be there .. (if this is a grid, you would also have to restart Robust), but in case of a grid you can deregister the region as well ..
(0032685)
claudio (reporter)
2018-05-27 04:46

Hello, thank you for your answer,

yes, the collation is UTF8, not utf8mb4.

Which tables exactly should I drop from the mysql database, to avoid throwing away the whole opensim database?

Already removing the INIs and the right database tables would make it better for me.. thanks!

Claudio
(0032686)
claudio (reporter)
2018-05-27 04:47

incidentally, the reason I am dropping regions is that some of them I am playing with (freely available ones) seem to trigger errors in persistence.

But this is another topic, as long as I can remove the "offending" regions after experimenting with them I am fine.

Thanks!
(0032687)
watcher64 (reporter)
2018-05-27 07:07

Just remove the ini's and their entries in the region table, find them buy their UUID ..

If you want to be completely through you can also remove all their parcels from the land table (make sure to search buy the region uuid) and estate_map table as well.
(0032692)
UbitUmarov (administrator)
2018-05-27 14:47

not a surprise that command is broken
do it by hand as watcher told
to just not load a region, comente its lines on regions.ini
to full remove them recovering disk space etc, you need to do it by hand on the DB :(

other things to avoid
commands to restart regions
just shutdown the entire simulator and restart it all

this things may work one day, very far in the future

- Issue History
Date Modified Username Field Change
2018-05-26 11:53 claudio New Issue
2018-05-26 11:55 claudio Note Added: 0032683
2018-05-26 11:59 watcher64 Note Added: 0032684
2018-05-27 04:46 claudio Note Added: 0032685
2018-05-27 04:47 claudio Note Added: 0032686
2018-05-27 07:07 watcher64 Note Added: 0032687
2018-05-27 14:47 UbitUmarov Note Added: 0032692


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker