Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.15
-
None
Description
Row based replication stopped with
Last_Errno: 1677
|
Last_Error: Column 23 of table 'HALLEY.ANANCHC' cannot be converted from type 'varchar(20)' to type 'varchar(20)'
|
unless
slave_type_conversion=ALL_NON_LOSSY
|
was enabled.
The types in the error message are both `varchar(20)`, and `SHOW CREATE TABLE` output and even `.frm` file contents are exactly the same on master and slave.
There was a BINLOG'...' provided that indeed contained encoded length for the col #23 as 20 (bytes). The actual column on slave has it 60, due to UTF8.
Attachments
Activity
Transition | Time In Source Status | Execution Times |
---|
|
7d 2h 46m | 1 |
|
1d 23h 45m | 1 |
|
1d 2h | 1 |
|
2d 22h 7m | 1 |
|
2d 19h 51m | 1 |
|
35d 22h 44m | 1 |
|
4d 1h 19m | 2 |