0008549: [LAND MANAGEMENT MODULE] does not work anymore after Windows 1903 update

Description

[LAND MANAGEMENT MODULE]

I have a OpenSim grid for Windows named Dreamgrid from Fred K. Beckhusen.
It worked fine but now I have a problem I don't know why or what happened.
Maybe the reason is my win10 x64 1809 update to 1903.

If I open the land info in Firestorm Viewer I can all modify.
Normally if we close the window from land info it saves the changes but now, no more. By all old regions/sim I can't change the setings in land info
if I create a new sim I can't change anything. What is wrong in settings? What can I do? Or do you know of problems with MS Win 10 version May 1903 and the OS?
Fred Beckhusen says its not a Dreamgrid fault it comes from OpenSim. It happens on 4 different PC's and 4 different viewers.

"190520 3:28:46 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
190520 3:28:56 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
190520 3:29:06 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error."

There are a lot of those, appears windows has locked the files for some reason, this has been known to cause all kinds of issues ..

Thank you BillBlight for your answer. I have horror for my work 52 regions same problem.
So as i think it begins with update win 10 May 1903 nothing other change and it's the only one different of two pc, grid2 there i don't have this problem.

OK i never change to lower_case_table_names=1
I think it hapen by update win 10 v1809 to v1903

OK and please what i can do for stop and fix this?
Where can I change this? Help please i have no plan :(

If I try to make a change to the properties of my region, such as renaming a parcel, or changing the checkbox to allow or deny public access, the operation appears to go smoothly while in Firestorm. However, if I close the Land window and reopen it, the changes are reverted as though they never happened.

The Opensim console on my host PC shows the error "[LAND MANAGEMENT MODULE]: Unable to find parcelID 0" every time I attempt to make one of these changes.

Things like adding individual names to the access list work just fine, and don't trigger the error.

This issue has occurred while using:

-The most recent "Dreamgrid" version posted at Outworldz
-The current version of Opensim hosted at OSGrid (osgrid-opensim-05142019.v.9.0.1.0e2adbe)
-The previous version of OSGrid's provided download (osgrid-opensim-03242019.v0.9.1.481d715)

In relation to the OSGrid versions, I've also tried it with both the default SQLite install, as well as after migrating over to MariaDB. New/Clean regions were created in all three versions, and the issue appeared in each one.

Its absolut the same problem as mine 1:1 it begins with Dreamgrid update 2.96
and then 3.0, Fred says me it's not here update it's an OS code problem.

Excuse, you mean truly 10 Pro v1803 or 1903? I have 2 grid one on win 10 pro 1809 run fine and one on pc win 10 pro 1903 with this problem. The problem begins with Dreamgrid update v2.96, v3.0 and win update 1903 don't fix this problem.

I post my mysql.log my grid is on M:\grid1 why i have all this logs with drive
C:\?? My grid run still of my PC or by Outworldz PC? It is no more so clear for my if i study this log. After 40 year IT it says me it can't by normal or correct me please. I will belive on Dreamgrid i like it but it's just hard at momenth.

Price question, what now? Throw everything away and start over? I honestly do not know how to continue. :-( I am thankful for all help what fix this problem. I work now 72 hour on it with 6 hour sleep.. I fight for my half year work.

I totally agree with you BillBlight that it is not an OS error. I have googled this endlessly but can't get any further. It is chewed endlessly but I do not see a solution there.

I did not blame it. Only win 10 pro 1903 and dreamgrid 2.96 + 3.0 update made. So how does that happen and what do I have to fix it? Please specific help I have no more way. All 54 sim / regions have the same problem. This can not be.
See me mysql.log why i have logs hdd C:\ if all grid OS is only on hdd M:\?https://www.rakisworld.ch/logs/mysql.log.rtf [^]

Please what can I do? I am not a developer or programmer.
I was a motivated OS user and now a bit frustrated. All stand for the OUT.
What will you do with a grid what dont save your land info changes? Garbage or?

Which log files would you use to see more? If you alow my ask.
I see you are a developer and think you have the right perspective.

Maybe i go back to win 1809 and delete the updste. The badest in win 10 ever.
I have a pc more with 1903 but a P4 8GB memory it's not so much but maybe for short try it go. I try to save my work. But its not easy. I have not enough developer knowhow ;)

How table and database names are stored on disk and used in MySQL is affected by the lower_case_table_names system variable, which you can set when starting mysqld. lower_case_table_names can take the values shown in the following table. This variable does not affect case sensitivity of trigger identifiers. On Unix, the default value of lower_case_table_names is 0. On Windows, the default value is 1. On macOS, the default value is 2.

"You should never have parceID 0, it should be a valid UUID , if it is not that will for sure fail when trying to update it .."

I would tend to agree, given what I've seen so far.

Can you think of any reason why something would be giving a parcel ID of 0? I dug into my opensim log, and there are instances of the land manager module being "unable to find parcel ID 0" as far back as May 22nd, when I first installed the most current version downloaded from OSGrid. At the same time, there are ALSO instances where land manager returned a proper parcel ID when performing other operations. I'm at my desk @ work right now but I'll remote into my system later to grab the log and pull some examples.

I also thought maybe it was firestorm related...maybe the viewer was sending information that wasn't being "understood". I gave Singularity a try, but got the same result (parcel ID 0 not found).

And again, while I can't speak for Rakis, I've had this happen with the dreamgrid OS package as well as two versions downloaded from OSGrid - and it's happened while running the default SQLite as well as MariaDB.

As first i will say thank you to all for your help and patience.
Fred Beckhusen, BillBlight, citizen059

After win update i had problems with mysql service can't change to start manualy so i set, sc stop Mysql and sc delete Mysql. Set back win 1903 to 1809 and check it in registry. After downgrade i check win and start Freds batch install it as a sercvice bat mysql don't work. OK restart the pc again and it workt now fine.

I check before all 54 regions i had all so, exemple:
RAKis World Office UUID bcfd6aca-2d3b-4276-81aa-d780bb943539
ParcellID 00e80300-00e8-0300-8000-000080000000

I think parceID 0 and more was a fake log the grid had problems i think we had see it on my logs ;) all work now normal and stabile again. As if nothing had ever happened.
Rakis Heron is happy and the show can go on ;-)

At last i learn very much on this way thanks for help me to fix it my friends.

And thy for help a Dreamgrid user but at last OS Grid or Dreamgrid its the same source and goal. Together we are strong.

Thousand thanks again for your patience and help. I hope one day i can help too.

So with the Parcel ID 0 I am interested and I will pursue this further here. Because I have no plan how that should be possible. Unless it's a fake log because in certain situations the system has no other default from the programmer. See Microsoft. Unknown error to unknown. World famous lol.

OS is a huge software and that's still understated. No wonder, if it coughs for a moment. But I have noticed, if you give it some time, it repairs and corrects much of the same. A tremendous achievement.

The ParcelID on those messages is region local parcel ID, a simple integer.
So 0 is a valid number (not necessary a valid parcel local id).
Maybe we should change those messages :)
This issue does sound related to MySQL issues.

Thanks for this tip and your attention Ubit Umarov, I thought so.
My only problem was that the [LAND MANAGEMENT MODULE] did not save anymore.
No tragedy, but it makes a grid worthless lol.

There are only two reasons for me. You can not run InstallAsAService.bat twice. I'll ask Fred if this can install and run two MySQL instances on Windows. That would be an explanation for me.

@REM Program to run Mysql as a Service
mysqld.exe --install Mysql --defaults-file="M:/grid1/OutworldzFiles/mysql/my.ini"
net start Mysql

Or the error was the worst Win 10 update ever. Or it was just a bad update installation. The Win 10 pro was so virgin newly set up. It could not be better.

But I am very grateful for all the tips here. It has once again shown that this forum works and solves problems.

OpenSim is a great software, I am amazed more and more.
Even Dreamgrid users are taken seriously. My respect.
Fred K. Beckhusen brings Unix and Windows closer together with Dreamgrid.
However, Windows will NEVER run like Unix.
But Bill Gates has made the Weld compatible.
Too bad that Linus Torvalds overslept this earlier.
The world would be better today. ;-)

I will update my website soon.
There will also be a logo and link from Opensimulator on my top page.

The problem here seems to be the viewer seems to think the region UUID is zero, when it is not. The few times I have seen things similar to this are due to lossy UDP packets from bad routers (Dlink comes to mind), or viewers set to over 500 kbps.

Just for the record, DreamGrid has always been unmodified core Opensimulator with extra non-core modules, such as Icecast, Birds, Diva, Search, Apache and PHP bundled with a GUI, into a (mostly) auto-configured WAMP platform. The only changes are in INI files and one environment variable so that a single bin folder can support multiple instances and multiple regions in multiple modes (UbODE and Bullet, for example), in various ways - Grid mode, Region Server mode, OsGrid Region Server, or Metro Server modes. Run once, and you can then run Robust, Icecast, MySQL and any region instance(s) from the provided batch files with no GUI at all.

It is currently V3.0 Opensim Master 6-8-2019 #38e937f91b08a2e52, and the Source is at https://github.com/Outworldz/DreamWorld [^] - standard Visual Studio anywhere from 2012 to 2019 works. If you copy .git from Opensim git master into the correct spot, you can compile Opensim, too, and it requires no mods and will just work. I am mentioning this simply because its easy to change into various configurations with a few clicks for testing Opensim in Windows in case anyone wants to give it a shot.

Problem No- 1 the worst win 10 update 1903! The 2. i am not so sure i can't see it in ProcessExplorer from MS. After win update mysql service dont start after PC reboot so i activate the batch again i think it install a 2. mysql instance. After sc stop Mysql and sc delete Mysql. Set back win 1903 to 1809 and install mysql service new it work fine now.

UbitUmarov say it so:
The ParcelID on those messages is region local parcel ID, a simple integer.
So 0 is a valid number (not necessary a valid parcel local id).
Maybe we should change those messages :)
This issue does sound related to MySQL issues.

Maybe it helps, Deinstall Mysql service. Robuster dosbox, sc stop Mysql and sc delete Mysql. After this install Mysql service new with Freds batch in mysql\bin\IntallAsAService.bat. But important before you install new you MUST uninstall first not install two time.

This issue has arisen for me on update from Windows 10 Pro version 1809 to version 1903 on all regions on my two grids (AiLand and Openvue) and for my addon OSGrid regions.

I note that changes in most tabs (e.g. changes I tried in General, tickboxes in Options, URL in Media, etc.) do not persist when the "About Land" tool is closed. But for some reason a change to the auto return time in the "Objects" tab does persist.

In all cases no errors appear in the OpenSim.exe console. But I do see a yellow warning..

[LAND MANAGEMENT MODULE]: Unable to find parcelID 0

Bill, I checked and I did not explicitly set lower_case_table_names in My.ini. In the MySQL Options File viewer it shows as unset (and value 0).

Ok, so I spent a couple of hours installing and uninstalling updates ...

It appears that KB4486153 is the offending update ...

If you feel adventurous try uninstalling it and and see if it helps ..

(ok one machine had that KB the other one never had it, the one that never had it still gets the error, the one that I removed it from now does not get the error, so I am confused, MS is playing games again.)

.NET Framework 4.8. Patch KB4486153 appears to be for Windows versions up to 1809. It seems a fully updated .NET 4.8 was incorporated into the released version of Windows 10 version 1903... so after installing Windows 10 version 1903 the KB4486153 patch does not show as a separate Windows update that can be uninstalled.

In the last 24 hours a new .NET patch (KB4506991)has been provided via Windows Update... and this changes things, but not for the better. Now "About Land" does not seem to even be able to access the previously stored land information.

Does OpenSim require IIS 6 Management Compatibility? It is turned off in Windows 1903 and in the separate Update patch KB4486153 for earlier Windows versions, and it seems it can't be reenabled on 1903 via "Turn Windows Features on or Off".

I was suicidal and did update to .net4.8
And yes, very broken. libopenmetaverse OSD types fail unless I do compile it under .net4.8 and both the lib and opensim are compiled in Debug mode. Otherwise
all decode of messages send by viewer in LLSDxml or JSON just fails.
JIT seems to lose information about fields, failing to do proper overrides of virtual functions.
No idea of impact on other code paths...
a very bad crap

It seems some other packages are failing with the same patch or major Windows updates, and its happened before... that's why I asked about IIS 6 Web Management Compatibility - which is being removed by Microsoft. Even packages that don't explicitly use IIS 6 appear to be impacted due to "other environmental factors involved". E.g. see

> The Patch and major 1903 updates disables IIS 6 Management Compatibility
> as part of deprecation of IIS 6. If we re-enable IIS 6 on the workstation,
> Technician Client works normally.
>
> Technician Client normally does not require any version of IIS, so there
> are apparently other environmental factors involved.

Unfortunately the workaround to re-enable IIS 6 web management compatibility does not work on Windows 10 1903, so I have not been able to try that. And the patch is not available separately after update to 1903 to reverse that specific update.

I have been trying to find out if Microsoft is aware of this specific issue and whether it is being addressed. I see some relevant information on .NET version migration at for example the second section in the JIT part of this web page ...

in .net4.6 they added a new JIT from .net core branch. .net.4.8 includes a update to that new JIT.
Back then they where not that secure about the new JIT, so included the old one and that option, both still around.

BUT... looks like a new problem has been introduced with that change... related to the URIs in a teleport request. This was via an object that when touched calls osTeleportAgent on for example "http://hg.osgrid.org:80/ [^] Vue-Port".

This problem goes away if I revert to the dev master immediately before the LibOMV .dlls using the config files amended.