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

Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3, 10.4
    • Fix Version/s: 10.3, 10.4
    • Component/s: Replication
    • Labels:
      None

      Description

      Test case 1

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t1 (a BLOB);
      INSERT INTO t1 VALUES (0);
      SET SQL_MODE= 'ORACLE';
      CREATE TABLE t2 SELECT * FROM t1;
      --sync_slave_with_master
       
      # Cleanup
      --connection master
      DROP TABLE t1, t2;
      --source include/rpl_end.inc
      

      10.3 617d34ae

      2019-05-29 15:19:53 13 [ERROR] Slave SQL: Column 0 of table 'test.t2' cannot be converted from type 'tinyblob' to type 'longblob', Gtid 0-1-3, Internal MariaDB error code: 1677
      2019-05-29 15:19:53 13 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 708
      

      master-bin.000001	708	Gtid	1	750	BEGIN GTID 0-1-3
      master-bin.000001	750	Query	1	862	use `test`; CREATE TABLE "t2" (
        "a" blob DEFAULT NULL
      )
      master-bin.000001	862	Annotate_rows	1	917	CREATE TABLE t2 SELECT * FROM t1
      master-bin.000001	917	Table_map	1	963	table_id: 33 (test.t2)
      master-bin.000001	963	Write_rows_v1	1	1000	table_id: 33 flags: STMT_END_F
      master-bin.000001	1000	Query	1	1073	COMMIT
      

      Same idea, different types:

      Test case 2

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t1 (a DATE);
      INSERT INTO t1 VALUES (NULL);
      SET SQL_MODE= 'ORACLE';
      CREATE TABLE t2 SELECT * FROM t1;
      --sync_slave_with_master
       
      # Cleanup
      --connection master
      DROP TABLE t1, t2;
      --source include/rpl_end.inc
      

      2019-05-29 19:53:05 13 [ERROR] Slave SQL: Column 0 of table 'test.t2' cannot be converted from type 'date' to type 'datetime', Gtid 0-1-3, Internal MariaDB error code: 1677
      2019-05-29 19:53:05 13 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 707
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sujatha.sivakumar Sujatha Sivakumar
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: