Red Gate forums :: View topic - Getting error while trying to synchronize binary data
Return to www.red-gate.com RSS Feed Available

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

Getting error while trying to synchronize binary data

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



Joined: 28 May 2014
Posts: 3

PostPosted: Wed May 28, 2014 5:08 pm    Post subject: Getting error while trying to synchronize binary data Reply with quote

Hello,
I'm having issue when I'm trying to synchronize my data from my preview environment to my testing environment.

Our primary key are BINARY(16) and are UUID. We have some other fields but I'm not sure that's relevant. When I'm trying to synchronize the data (import the data from an environment to another), I'm getting this error :

Bug report generated at 2014-05-28 11:59:31
Program version 1.0.0.473

Quote:
System.Reflection.TargetInvocationException: . ---> System.InvalidCastException: Impossible to cast an obect from type 'Devart.Data.MySql.MySqlBlob' to type 'Devart.Data.MySql.MySqlText'.
at #akmb.#ekmb.#bBmb(IComparable value, #Kkmb datatype)
at #akmb.#ekmb.#ktmb(IComparable value, #Kkmb datatype)
at #2jmb.#aNX.#9eC(#Dkmb statements, #my2 action, #Lzg direction)
--- Fin de la trace de la pile d'exception interne ---
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
à System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at #2jmb.#3jmb.#um()
at #5jmb.#4jmb.#t.#n2Y.#IhE()
at RedGate.Shared.Controls.ProgressDialogEx.e()


Is there anything I'm doing wrong ? I could always drop the table and do a backup restore of the data I want to keep, but it worry me that it's not working.

Regards,
Jonathan
Back to top
View user's profile Send private message
jonathanmg



Joined: 28 May 2014
Posts: 3

PostPosted: Thu May 29, 2014 4:59 pm    Post subject: Reply with quote

After continuing to troubleshoot the problem, I have validated that it's NOT related to the BINARY(16) id, but rather to a TEXT field we have.

If I remove the two TEXT fields from the compare the compare work, however I do not understand why MySQL Data Compare see the TEXT field as a BLOB (as mentionned in the error message).
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Fri May 30, 2014 9:29 am    Post subject: Reply with quote

Thank you for your forum post.

For this table, are the schemas identical? You can check this using MySQL Compare.

I suspect that the column in the source database is using a BLOB data type and the target is using the TEXT data type. The Devart components used by MySQL Data Compare cannot cast data from a MySQLBlob to MySQLText and hence the deployment fails.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
jonathanmg



Joined: 28 May 2014
Posts: 3

PostPosted: Tue Jun 03, 2014 7:27 pm    Post subject: Reply with quote

I used MySQL Compare to make sure, but both table were identical (TEXT), we managed to make it work, but we had to convert both TEXT field to VARCHAR(65,534) and it worked.
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