Errors on registering database

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

Errors on registering database

Postby jdegoei » Mon May 10, 2010 2:34 pm

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.
jdegoei
 
Posts: 2
Joined: Mon May 10, 2010 2:21 pm

Postby Lionel » Mon May 10, 2010 9:56 pm

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
Lionel
 
Posts: 155
Joined: Fri Dec 16, 2005 11:09 am

Postby Stephen Harrison » Mon May 10, 2010 11:59 pm

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.
Stephen Harrison
 
Posts: 3
Joined: Sun May 09, 2010 5:28 pm
Location: Cambridge UK

Postby Lionel » Tue May 11, 2010 9:07 pm

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
Lionel
 
Posts: 155
Joined: Fri Dec 16, 2005 11:09 am

Logfile

Postby jdegoei » Fri May 28, 2010 8:26 am

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()
jdegoei
 
Posts: 2
Joined: Mon May 10, 2010 2:21 pm

Unable to cast object of type 'System.DBNull'

Postby bdill » Fri Jan 28, 2011 7:31 am

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: Select all
Unable to cast object of type 'System.DBNull' to type 'System.String'.


Verbose log file...

Code: Select all
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()
bdill
 
Posts: 28
Joined: Tue Feb 15, 2005 10:02 pm
Location: Nashville, TN

Postby Frad » Wed Apr 25, 2012 11:35 am

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.
Frad
 
Posts: 3
Joined: Wed Apr 25, 2012 11:09 am


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 1 guest