bug: Exception thrown: 'System.FormatException' in System.Private.CoreLib.dll

Question

bug: Exception thrown: 'System.FormatException' in System.Private.CoreLib.dll

Closed this issue a year ago · 11 comments

OwsInstanceManagement is continuously throwing this exception, likely every second.

Exception thrown: 'System.FormatException' in System.Private.CoreLib.dll

Mysql , UE5 is used . .net 6.0.7

Everything is fully configured and all the functionality is working. So , that is not an urgent case , but still It hides the real misconfiguration problems - for the project, and it gets much harder to configure everything. Also it is very hard to find where that bug appears.

If you get this error , and your project does not work , be sure to not have other misconfiguration problems.

Answer 1 · 2022-08-02T08:44:01.000Z

Does this only happen with MySQL version or also with MSSQL?

Answer 2 · 2022-08-02T19:28:00.000Z

I will also test with posgresql , or even try to find the root cause and update you. I do not have mssql .

Answer 3 · 2022-08-03T01:02:15.000Z

A few questions:

Does this happen even prior to loading a 'worldserver' via the dotnet command line?
Is there anything else around the exception that might indicate a line number?

If you are running with docker-compose can you share your .env file (replacing IP/Passwords with dummy etc).

I'm running this in Docker (directly rather than docker-compose) with the following environment variables set and do not see the same issues (but I'm not running a world server currently) (host names blanked out):

Answer 4 · 2022-08-03T05:58:20.000Z

Does this happen even prior to loading a 'worldserver' via the dotnet command line?
Yes
Is there anything else around the exception that might indicate a line number?
No.

I'm running this in Docker (directly rather than docker-compose) with the following environment variables set and do not see the same issues (but I'm not running a world server currently) (host names blanked out):

Only from visual studio logs at debug mode .

Answer 5 · 2022-08-03T06:29:36.000Z

Strange, could you upload the .env file so we can check it out? It could be an issue, and it's the only thing I can think of at this time.

Answer 6 · 2022-08-03T07:08:39.000Z

Let me find out what's happening, maybe I will be able to solve that. If you can not replicate , maybe it is because of platform differences..

Answer 7 · 2022-08-03T07:10:34.000Z

Also, if you prefer, I am over on the official discord server too and I can also help out there.

Answer 8 · 2022-08-03T07:46:33.000Z

If you are using the latest version of the source code. Have you ran all of the scripts in https://github.com/Dartanlla/OWS/tree/main/Databases/MySQL/UpdateScripts against the database? These are not run automatically and users/devs need to run these against the databases manually at the moment. Just thinking this could be due to a Column change made a few weeks ago.

Answer 9 · 2022-08-03T08:58:58.000Z

sure, else it does not work already.

Have you ran all of the scripts in https://github.com/Dartanlla/OWS/tree/main/Databases/MySQL/UpdateScripts against the database? These

Answer 10 · 2022-08-04T16:26:46.000Z

@CanisHelix , I moved to postgresql again and it is same again.

SELECT * FROM public.owsversion
20220613

It does not differ if I have started the instancelauncher or not.
I am on a macbook m1 , and .net 5 does not work, so I upgraded the dependency libraries to 6.0.7.

I needed also to change DbQuery to DbSet, however , they are not exactly same. check this (possibly the root cause of it on .net 6.0.7 ) :dotnet/efcore#15656

Answer 11 · 2023-06-24T20:43:00.000Z

Kevin said EF doesn't support M1.