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

Can't replicate multiple DATETIME columns from 10.2 to 5.5

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 5.5, 10.2.13
    • N/A
    • Data types
    • None
    • Linux

    Description

      When executing the below on a 10.2 master, a 5.5 slave will fail:

      DROP TABLE IF EXISTS _repfailuretest4;
      CREATE TABLE _repfailuretest4 (
      dt1 DATETIME,
      dt2 DATETIME
      )ENGINE=INNODB ROW_FORMAT=COMPACT;
      INSERT INTO _repfailuretest4 VALUES ('2018-03-27 00:00:00', '2018-03-28 00:00:00');

      180327 14:54:01 [ERROR] Slave SQL: Column 0 of table 'entdata_utf8._repfailuretest4' cannot be converted from type '<unknown type>' to type 'datetime', Error_code: 1677
      180327 14:54:01 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.004139' position 730736627

      xref https://bugs.mysql.com/bug.php?id=70124 where it is discussed that something like this symptom is resolvable under MySQL 5.6.20 using certain slave_type_conversions values, but I am unable to determine if/how this applies to MariaDB versions, and/or if a particular slave_type_conversions value would help my case.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dvanhollen Doug Van Hollen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.