Master-Slave Replication breaks with different table structures

[Moody Youssef]

I keep getting this error on my Slave server on the same table and column. Master & slave are both Percona 5.5.30. 

Last_SQL_Error: Column 27 of table 't1' cannot be converted from type 'varchar(100)' to type 'datetime'. 

I thought this bug would be resolved in the latest release? Anyone know a solution? 

[Justin Swanhart]

Hi,

Try set global slave_type_conversions="ALL_NON_LOSSY,ALL_LOSSY";

http://dev.mysql.com/doc/refman/5.5/en/replication-features-differing-tables.html

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Moody Youssef]

Thanks for the reply. Currently it's set to "ALL_NON_LOSSY" only because if ALL_LOSSY is set as well, data that cannot be converted properly will be truncated when being replicated. Otherwise yes that would be the solution.

On Wednesday, May 8, 2013 1:03:28 PM UTC-4, Justin Swanhart wrote:

Hi,

Try set global slave_type_conversions="ALL_NON_LOSSY,ALL_LOSSY";

http://dev.mysql.com/doc/refman/5.5/en/replication-features-differing-tables.html

On Mon, May 6, 2013 at 1:35 PM, Moody Youssef <myou...@zerionsoftware.com> wrote:

I keep getting this error on my Slave server on the same table and column. Master & slave are both Percona 5.5.30. 

Last_SQL_Error: Column 27 of table 't1' cannot be converted from type 'varchar(100)' to type 'datetime'. 

I thought this bug would be resolved in the latest release? Anyone know a solution? 

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to percona-discussion+unsub...@googlegroups.com.