| Anonymous | Login | Signup for a new account | 2020-01-20 06:37 PST |  |
| Main | My View | View Issues | Change Log | Roadmap | Summary | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||
| 0008324 | opensim | [REGION] OpenSim Core | public | 2018-05-26 11:53 | 2018-05-27 14:47 | |||||
| Reporter | claudio | |||||||||
| Assigned To | ||||||||||
| Priority | normal | Severity | major | Reproducibility | always | |||||
| Status | new | Resolution | open | |||||||
| Platform | x86_64 | OS | Linux | OS Version | Linux Mint 18.3 | |||||
| Product Version | 0.9.0 | |||||||||
| Target Version | Fixed in Version | |||||||||
| Summary | 0008324: delete-region command blocks and does not do anything useful | |||||||||
| Description | as 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 Information | using 3 regions: 1 default region (no oar loaded) 1 free mall region 1 conference center region | |||||||||
| Tags | No tags attached. | |||||||||
| Git Revision or version number | ||||||||||
| Run Mode | Standalone (Multiple Regions) | |||||||||
| Physics Engine | BulletSim | |||||||||
| Script Engine | ||||||||||
| Environment | Mono / Linux64 | |||||||||
| Mono Version | Other | |||||||||
| Viewer | alchemy | |||||||||
| Attached Files | ||||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0032683) claudio (reporter) 2018-05-26 11:55 |
using mysql Ver 15.1 Distrib 10.0.34-MariaDB |
|
(0032684) BillBlight (developer) 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) BillBlight (developer) 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 |
|
Notes |
|
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 | BillBlight | 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 | BillBlight | Note Added: 0032687 | |
| 2018-05-27 14:47 | UbitUmarov | Note Added: 0032692 | |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |