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

rpl.rpl_drop_db_fail failed in buildbot, slave failed to start

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.1
    • N/A
    • Replication, Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/11465

      rpl.rpl_drop_db_fail 'stmt,xtradb'       w3 [ fail ]
              Test ended at 2018-07-19 19:37:27
       
      CURRENT_TEST: rpl.rpl_drop_db_fail
       
       
      Failed to start mysqld.2
      mysqltest failed but provided no output
      The result from queries just before the failure was:
      < snip >
      include/master-slave.inc
      [connection master]
      CREATE DATABASE IF NOT EXISTS db1;
      CREATE DATABASE IF NOT EXISTS db2;
      use db1;
      CREATE TABLE a(id INT);
      CREATE VIEW v AS SELECT * FROM a;
      CREATE TABLE table_father(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20)) ENGINE=INNODB;
      use db2;
      CREATE TABLE table_child(id INT PRIMARY KEY, info VARCHAR(20), father_id INT) ENGINE=INNODB;
      ALTER TABLE table_child ADD CONSTRAINT aaa FOREIGN KEY (father_id) REFERENCES db1.table_father(id);
      DROP DATABASE db1;
      ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
      DROP DATABASE db2;
      DROP DATABASE db1;
      include/rpl_end.inc
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.