Forum / Password Vault Manager - Support

PVM MySQL Exception - unable to load sessions

Dear,

I am unable to open my PVM due to an exception when loading sessions for one week now.
Follows the given error and the actions taken.


NullReferenceException - Object reference not set to an instance of an object.

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlDataReader.Dispose()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.cca8119a110bebd9f7c66a9b8aa671a9c(IDbCommand c469787a81372d641f189d46c8cbb1738, List`1& c8b9dc1f68940a43e7cd099cb1e4646fe, Byte[]& c9bd301a2fd1db0ad012d647646537ec1, Int32& c0d10ab04b5b18d594b7605de6eda18b5, Nullable`1& c6c7922f70bc4ad6a683a9f6baa3f4b7d)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnections()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.ca4799bebd8b706f34eea94a778843b55(BaseConnectionDataSource c01af917dca3518ff73ed69848f95f91a, Boolean cfe205b02d73750f8fd14d199343fe545)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.RefreshConnections()
at Devolutions.RemoteDesktopManager.Forms.FrmMainRibbonBase.RefreshAllConnectionView(Boolean saveState, Boolean checkOnline)
at Devolutions.RemoteDesktopManager.Managers.MainFormManager.DoFirstLoad(IMainForm mainform)
at Devolutions.RemoteDesktopManager.Forms.FrmMainDocumentManager.cae3b4c7c167cf0d9747ac4fee11ac00a(Object c19f185fd70cefc696ba148af1c4faf54, EventArgs cf1018bb83ec7debd818319fd3cb4844e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

- uninstalled PVM and removed all its files and folders also from user/appdata
- rebooted
- uninstalled
- created another profile

- I also have RDM which loads fine.

Can you help me with this issue?

Best,

Clock7 mths

Hi,
Have you tried to use another database user? It's an exception in the MySQL driver.

Regards

David Hervieux

signaturesignature

Clock7 mths

David Hervieux wrote:

Hi,
Have you tried to use another database user? It's an exception in the MySQL driver.

Regards

Hi David, Yes I did with no success, in adittion in another machines it works pretty fine.
I have no clue on what can be causing this. It is about one week struggling.

Thanks

Clock7 mths

Could you try to recreate the data source configuration?

Regards

David Hervieux

signaturesignature

Clock7 mths

David Hervieux wrote:

Could you try to recreate the data source configuration?

Regards


Yep during the last days, made it 3 times after uninstalling the PVM removing all files, passing ccleaner rebooting installing / creating new data source... and so on...

Clock7 mths

Hi,
Could you try to replace this dll?

David Hervieux

signaturesignature

MySql.Data.zip
Clock7 mths

Thanks David, I tried and got the same results, same mysql exception.

Clock7 mths

The MySql.Data.dll file from your RDM installation is working correctly.

Could you try to copy it into your PVM folder to see if that changes anything?

Stefane Lavergne

signaturesignature

Clock7 mths

Hi Stefane,

I copied MySql.Data.dll from RDM to PVM and the problem stills.
I think it is related to the data transfer.
Some of the packets get broken and we have the exception. It seems to happen randomly during the stream transfer.
Maybe the code could check the packet and retry in case of the exception.

Thanks and regards,

Clock7 mths

In addition, the data transfer takes a lot of time, maybe there is a maximum stream size/timeslice?

Clock7 mths

System.NullReferenceException: Object reference not set to an instance of an object.
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlDataReader.Dispose()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.cca8119a110bebd9f7c66a9b8aa671a9c(IDbCommand c469787a81372d641f189d46c8cbb1738, List`1& c8b9dc1f68940a43e7cd099cb1e4646fe, Byte[]& c9bd301a2fd1db0ad012d647646537ec1, Int32& c0d10ab04b5b18d594b7605de6eda18b5)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnections()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.ca4799bebd8b706f34eea94a778843b55(BaseConnectionDataSource c01af917dca3518ff73ed69848f95f91a)

Clock7 mths

I made a test connecting using another ISP and it went fine this time.
I believe there is a problem in the dll regarding internet packet losses.

Best

Clock7 mths

The internals of the MySQL driver is not controlled by us. It's provided by https://dev.mysql.com/downloads/connector/net/

I've searched their bugs database and have not found anything relevant to your issue. https://bugs.mysql.com/

The version you currently have should be v6.9.10.0, a newer v6.10.5.0 it might resolve your issue.

Attached the newest version of the .dll. Can you please try with this version?

Stefane Lavergne

signaturesignature

MySql.Data.zip
Clock7 mths