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

              nirbhay_c Nirbhay Choubey (Inactive)
              tanj Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.