Forum / Remote Desktop Manager Mac - Support

Database problems after upgrade

  • Create an Issue
  • Cancel

Hi,

i can't connect to our datasource after upgrading the database scheme. RDM crashes right after trying to connect to the datasource. Cleaning the cache and creating a new data source does not help.

RDM 6.0.0.0

Error:
Unable to Connect to your Data Source
Fatal error encountered during command execution.

i can't click any button (e.g. details) because RDM hangs for good.

please help smile

greetings

Clock2 mths

Tried a manual database upgrade - after the upgrade we could connect again but suddenly after 5 minutes the error was back and RDM crashes right after starting again.

It was possible to fetch the error details:

MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.
at MySql.Data.MySqlClient.MySqlStream.ReadFully (System.IO.Stream stream, System.Byte[] buffer, System.Int32 offset, System.Int32 count) [0x00015] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x00076] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x000a5] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int32& insertedId) [0x0001e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int32& insertedId) [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00022] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x000d2] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x001f3] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x001ea] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x002ac] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.Driver.ReportWarnings (MySql.Data.MySqlClient.MySqlConnection connection) [0x00019] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.CloseQuery (MySql.Data.MySqlClient.MySqlConnection connection, System.Int32 statementId) [0x0000e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.Close (MySql.Data.MySqlClient.MySqlDataReader reader) [0x00053] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.Close(MySql.Data.MySqlClient.MySqlDataReader)
at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x0008e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at System.Data.Common.DbDataReader.Dispose (System.Boolean disposing) [0x00003] in <bbe64cb6cb954b0c8bf8dbf03087621a>:0
at System.Data.Common.DbDataReader.Dispose () [0x00000] in <bbe64cb6cb954b0c8bf8dbf03087621a>:0
at A.c8bb832eaa4caed25b50caade71232a37.cc36fefaaceb5acfdf3c4a14f7813df4d () [0x00140] in <9cceae2923fd466e8cbe314df4acd410>:0

Clock2 mths

Hello,

Thank you for contacting our support service. To better assist you, we require more information about the issue

What type of data source are you using? (File – My Data source information, use the "send to support" button.)
Is the connection still work for your colleagues or from another computer?

Best regards,



David Grandolfo

signaturesignature

Clock2 mths

Hello again,

As soon as I post my question I saw your error. Could you send us the Database Schema of you MySQL database please?

Normally, under File -- Data source when you edit MySQL data source configuration you should see Email Schema to support.

Have you the option?

Best regards,



David Grandolfo

signaturesignature

Clock2 mths

Hi,

https://www.dropbox.com/s/81qjdi57ulnp5ns/Devolutions.RemoteDesktopManager.Mac.6.0.0.1540408097.dmg?dl=0


Could you also try this version when you get a chance?

Best regards,

Xavier Fortin

signaturesignature

Clock2 mths

Hi,

No worries - i can't send the schema to support, I think its because i'm not (can't) connect to the DB.

The Version from Mr. Fortin seems to be working! I will give it a proper testdrive today. (Do you still need the schema?)

Thank you both!

Greetings

Clock2 mths

Out of sync with server Error is back:

MySql.Data.MySqlClient.MySqlException (0x80004005): Out of sync with server
at MySql.Data.MySqlClient.NativeDriver.ReadOk (System.Boolean read) [0x00097] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.NativeDriver.SetDatabase (System.String dbName) [0x0003c] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.SetDatabase (System.String dbName) [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase (System.String databaseName) [0x00087] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0019d] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at A.c8bb832eaa4caed25b50caade71232a37.cea9773bcf34f5a19ac6169d5f601a034 (System.String c3a7c71f30053a5a40fc3b4f66e72b871, System.Boolean c1b4a1fa885a8033610f52375d3643a7c) [0x00125] in <5550828c379a4180b5d5540eb56c73a4>:0

Clock2 mths

Full schema dump error:

Schema dump failed with error:
Value cannot be null.
Parameter name: value


Test Schema and Test Host are successful.

Clock2 mths

Hi,

The schema error should be fixed. I'll release a patch soon.

As for the Out of sync error, we've found an similar issue on the MariaDB issue tracking service. You haven't mentioned it, but are you using MariaDB?

Best regards,

Xavier Fortin

signaturesignature

Clock2 mths

Hi,

thank you!

Oh, yes a colleague switched it to MariaDB and i forgot about it (Sorry, nice find). I tried it with the MariaDB connector but still get the same error. Should we switch back to MySQL?

Greetings

MariaDB connector error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Out of sync with server
at MySql.Data.MySqlClient.NativeDriver.ReadOk (System.Boolean read) [0x00097] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.NativeDriver.SetDatabase (System.String dbName) [0x0003c] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.SetDatabase (System.String dbName) [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase (System.String databaseName) [0x00087] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0019d] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at A.c8bb832eaa4caed25b50caade71232a37.cea9773bcf34f5a19ac6169d5f601a034 (System.String c3a7c71f30053a5a40fc3b4f66e72b871, System.Boolean c1b4a1fa885a8033610f52375d3643a7c) [0x00125] in <5550828c379a4180b5d5540eb56c73a4>:0

Clock2 mths

Well, it depends on your urgency.

Here is the issue in question: https://jira.mariadb.org/browse/MDEV-16308

You might want to follow it.

If the issue prevent you from working, it might be better for you to go back to MySQL, as I do not know when a fix will be made in MariaDB.

Best regards,

Xavier Fortin

signaturesignature

Clock2 mths

Thank you for your help and identifying the issue!

We will wait until next week and see if there is any progress.

Thank you!

Greetings

Clock2 mths