Red Gate forums :: View topic - Errors on registering database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

Errors on registering database

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
jdegoei



Joined: 10 May 2010
Posts: 2

PostPosted: Mon May 10, 2010 2:34 pm    Post subject: Errors on registering database Reply with quote

I'm retrieving 2 different (perhaps related) errors while registering de left-hand database. (credentials are ok, errors occur in MySQL Compare form at the second step).

First I got a time out expired (is it possible to set the time out somewhere)?

Second a conversion error type System.DBNull to System.String.

I'm trying to compare a local development-database with a remote production-database.
Back to top
View user's profile Send private message
Lionel



Joined: 16 Dec 2005
Posts: 170

PostPosted: Mon May 10, 2010 9:56 pm    Post subject: Reply with quote

Hi

Unfortunately there is no way setting the connection timeout at the moment. If you enable verbose logging (which you can do by clicking the icon in the top left hand corner of the window and using the menu item to set the log level) and then try and connect to the database again the error should get added to the log. If you could post the exception I will try and track it down and get you a fixed version. I am afraid you might have to wait until next week til I can get you a fix as I am on holiday at the moment.

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
Stephen Harrison



Joined: 09 May 2010
Posts: 3
Location: Cambridge UK

PostPosted: Mon May 10, 2010 11:59 pm    Post subject: Reply with quote

I had a similar problem with a local database being slow to register.

It appears that during my upgrade of MySQL from V4.1 to V5 (so I could use MySQL Compare) some of my databases got a bit, well, broken fortunately they are only development ones so I was able to delete them.

A quick check in the MySQL error file (something like C:\ProgramData\MySQL\MySQL Server 5.1\data\<computername>.err) showed the problem.

Deleting the corrupt databases solved the slow registering problem.

What was a little concerning is that the databases I was comparing were not the ones with the problems, so something MySQL Compare is doing to enumerate things gets affected by other databases.

Steve.
Back to top
View user's profile Send private message
Lionel



Joined: 16 Dec 2005
Posts: 170

PostPosted: Tue May 11, 2010 9:07 pm    Post subject: Reply with quote

Hi

MySQL Compare uses the INFORMATION_SCHEMA tables to get the schema information about the two databases in the comparison. Since the information_schema tables hold information about all the databases on the server I suspect that MySQL is trying to load the information about the corupt databases even though I am filtering out that information. Not sure how much I will be able to do about fixing the slow registration problem as it is sounds like a MySQL issue. I will try and see if I can track the problem down and think of a way round the it.

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
jdegoei



Joined: 10 May 2010
Posts: 2

PostPosted: Fri May 28, 2010 8:26 am    Post subject: Logfile Reply with quote

Hi Lionel,

Below the output of my logfile after setting verbose logging.
I'm not getting any timeouts anymore, the only error now seems to be a cast-exception.

With kind regards,

Jamie.

-----

09:16:44.933|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
09:17:28.424|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidCastException: Kan een object van het type System.Byte[] niet converteren naar het type System.String.
bij r.i()
bij r.b()
bij RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.a(IPopulator )
bij RedGate.Shared.Controls.ProgressDialogEx.e()
09:18:38.709|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidCastException: Kan een object van het type System.Byte[] niet converteren naar het type System.String.
bij r.i()
bij r.b()
bij RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.a(IPopulator )
bij RedGate.Shared.Controls.ProgressDialogEx.e()
Back to top
View user's profile Send private message
bdill



Joined: 15 Feb 2005
Posts: 28
Location: Nashville, TN

PostPosted: Fri Jan 28, 2011 7:31 am    Post subject: Unable to cast object of type 'System.DBNull' Reply with quote

I have a similar error. One of my databases compare just fine, but most give the following error when registering the 2nd (and remote) database:

Code:
Unable to cast object of type 'System.DBNull' to type 'System.String'.


Verbose log file...

Code:
00:21:37.488|Info   |Logging             |1  |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
00:21:52.301|Error  |Engine Service      |1  |:Exception in progress dialog
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
   at r.i()
   at r.b()
   at RedGate.MySQL.ObjectModel.Population.LivePopulator.Populate()
   at RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.a(IPopulator )
   at RedGate.MySQL.ObjectModel.Population.DatabasePopulationHelper.PopulateDatabase2()
   at RedGate.Shared.Controls.ProgressDialogEx.e()
Back to top
View user's profile Send private message
Frad



Joined: 25 Apr 2012
Posts: 3

PostPosted: Wed Apr 25, 2012 11:35 am    Post subject: Reply with quote

Hi dear if you are facing Errors on registering database then first option for you that you can check your coading if you are unable to fix your problem then contact with good tech team which help you.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group