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

MariaDB Galera Cluster does not enforce slave_type_conversions

    XMLWordPrintable

    Details

      Description

      Test case on two node cluster:

      -- On node 1
      set global slave_type_conversions='ALL_LOSSY';
      create table testconv (id int primary key);
      set wsrep_osu_method='RSU';
      alter table testconv modify column id bigint unsigned;
      set wsrep_osu_method='TOI';
      -- On node 2
      insert into testconv values(1);

      Failure on node 1:

      160129  9:51:46 [ERROR] Slave SQL: Column 0 of table 'test.testconv' cannot be converted from type 'int' to type 'bigint(20) unsigned', Internal MariaDB error code: 1677
      160129  9:51:46 [Warning] WSREP: RBR event 3 Write_rows_v1 apply warning: 3, 11
      160129  9:51:46 [Warning] WSREP: Failed to apply app buffer: seqno: 11, status: 1

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              tanj Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: