Devolutions ForumDevolutions Forum

MariaDB Datasource: Out of sync with server

MariaDB Datasource: Out of sync with server

avatar
(user deleted)
Disabled

So I installed RDM 14.0.9.0 today and DB Upgrade went fine, DatabaseVersion shows 274.
Database: 10.3.11-MariaDB-1:10.3.11+maria~bionic-log
Datasource Connection: MariaDB

However, when I connect to this Datasource, the following error appears:
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of sync with server
at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseStateSubDataSource.GetCheckOut(String connectionID, Boolean canRetry)

I tried to reinstall RDM, to delete the cache and even the datasource itself, nothing works.

Any advice?

All Comments (5)

avatar
Alexandre Roy

Hi,

I am getting an issue with mariaDB at the moment, It doesn't apear to be the same error as you do but they might be related.

I will verify with the engineering team.

Thank you for reporting this.

Best regards,

Alexandre Roy

avatar

Thanks Alexandre!

i got 3 MariaDB datasources, and the error only occours on two of them.

it seems that deactivating "Allow entry states (Lock, Running, Checkout)" (Administration -> Data Source Setting -> General) fixed the problem for now.

avatar
Stéfane Lavergne

Michael,

For now disabling "Allow entry states" is your only option. You are like the fourth person to report this issue, unfortunately we can't reproduce the issue and all are efforts to resolve it has failed (so far). I have one last idea that might work. I hope to get that implemented this week and release a "private" build for testing purposes to those experiencing the issue to see if it actually resolves it.

I will keep you posted.

One quick question. Are all three MariaDB on the same server? If not what are the version numbers of the MariaDB instances?

Best regards,

Stéfane Lavergne

avatar

The three MariaDB instances are on diffrent servers, but they are all the same version 10.3.11-MariaDB-1:10.3.11+maria~bionic-log

avatar
Stéfane Lavergne

Can you please try the latest beta build (v14.0.11.0) it should resolve the issue.

https://remotedesktopmanager.com/home/download#Beta

Best regards,

Stéfane Lavergne