MySQL Forums
Forum List  »  Replication

Re: MySQL Slave Error 1677 - cannot be converted from type 'decimal(0,?)' to type 'decimal(12,3)'
Posted by: Rick James
Date: August 30, 2014 11:49AM

Hi Wagner,
This may not be relevant because of the exact versions, but maybe it is a clue:

----- 2013-09-20 5.5.34 -- Bugs Fixed -- Replication -----

A slave using row-based replication was unable to read the rows containing columns of type MYSQL_TYPE_DECIMAL properly (old-style decimal, used prior to MySQL 5.0.3). Now the slave throws an error if it receives this type of data. You can convert the old-style DECIMAL ( http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html ) format to the binary format used in current MySQL releases with ALTER TABLE ( http://dev.mysql.com/doc/refman/5.5/en/alter-table.html ); see Upgrading from MySQL 4.1 to 5.0 ( http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-previous-series.html ), for more information. (Bug #16416302)

(That was simultaneously fixed in 5.6.14 and 5.7.2.)

Also:

----- 2014-01-31 5.6.16 -- Bugs Fixed -- Replication -----

mysqlbinlog did not properly decode DECIMAL ( http://dev.mysql.com/doc/refman/5.6/en/fixed-point-types.html ) values in a row-based binary log. This could cause invalid values to be printed out for DECIMAL columns. (Bug #17544169)

References: See also Bug #14309019.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Slave Error 1677 - cannot be converted from type 'decimal(0,?)' to type 'decimal(12,3)'
5440
August 30, 2014 11:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.