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

Table is overwriten on Slave when created on Master

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.20, 11.2.2
    • None
    • Replication
    • Linux, n.a.

    Description

      When I have a table test on the Slave which does NOT exist on the Master and later I create the table on the Master the table is dropped and recreated on the Slave!!!
      This is not expected behaviour. We expect that replication stops with an error.
      This is also not the behaviour from a competitive product.

      • Reproduce:
        On Slave:
        create table test (id int, data varchar(255));
        insert into test values (1, 'Some data'), (2, 'Some more data');
        select * from test;
        2 rows in set (0.000 sec)

      On Master:
      create table test (id int);

      On Slave;

      select * from test;
      Empty set (0.001 sec)
      show create table test\G
      *************************** 1. row ***************************
             Table: test
      Create Table: CREATE TABLE `test` (
        `id` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
       
       show slave status\G
                    Slave_IO_Running: Yes
                   Slave_SQL_Running: Yes
                      Last_SQL_Errno: 0
                      Last_SQL_Error: 
      

      Really bad...

      Attachments

        Activity

          People

            Unassigned Unassigned
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.