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

Replication ignores --slave_skip_error option and stops with "CONNECT Unsupported command"

    XMLWordPrintable

Details

    Description

      To reproduce in mtr run test case from MDEV-15498 +
      add an option file with --slave_skip_errors=1148 or --slave_skip_errors=all

      --source include/master-slave.inc
      --source include/have_innodb.inc
      --source include/have_binlog_format_row.inc
       
      connection slave;
      show variables like 'slave_skip_errors';
      CREATE USER u@'%' IDENTIFIED BY 'password';
      GRANT ALL ON db1.* TO u@'%' IDENTIFIED BY 'password';
      flush privileges;
       
      create database db1;
      CREATE TABLE db1.t1c ( id int primary key, msg varchar(100)) ENGINE=innodb;
      INSERT INTO  db1.t1c VALUES (1, 'initial');
       
      connection master;
       
      eval CREATE TABLE test.t1 ( id int primary key, msg varchar(100))
      ENGINE=CONNECT DEFAULT CHARSET=utf8 
        CONNECTION='mysql://u:password@127.0.0.1:$SLAVE_MYPORT/db1/t1c'
        TABLE_TYPE=MYSQL;
       
      select * from test.t1;
       
      connection master;
      --sync_slave_with_master
       
      select * from test.t1;
       
      connection master;
       
      insert into test.t1 VALUES(2,'test');
      select * from test.t1; 
       
      --sync_slave_with_master
       
      select * from test.t1;
      select * from db1.t1c;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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