Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19925

Column ... cannot be converted from type 'varchar(20)' to type 'varchar(20)'

    XMLWordPrintable

    Details

      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

            People

            Assignee:
            sujatha.sivakumar Sujatha Sivakumar
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: