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

Galera test failure on galera_fk_cascade_delete

    XMLWordPrintable

    Details

      Description

      • http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/11067/steps/mtr-galera/logs/stdio

        galera.galera_fk_cascade_delete 'innodb' w1 [ fail ]
                Test ended at 2020-11-04 09:55:40
         
        CURRENT_TEST: galera.galera_fk_cascade_delete
        mysqltest: At line 43: query 'DELETE FROM grandparent WHERE id = 1' failed: 1213: Deadlock: wsrep aborted transaction
         
        The result from queries just before the failure was:
        < snip >
        CREATE TABLE parent (
        id INT NOT NULL PRIMARY KEY,
        grandparent_id INT,
        FOREIGN KEY (grandparent_id)
        REFERENCES grandparent(id)
        ON DELETE CASCADE
        ) ENGINE=InnoDB;
        CREATE TABLE child (
        id INT NOT NULL PRIMARY KEY, 
        parent_id INT,
        FOREIGN KEY (parent_id) 
        REFERENCES parent(id)
        ON DELETE CASCADE
        ) ENGINE=InnoDB;
        INSERT INTO grandparent VALUES (1),(2);
        INSERT INTO parent VALUES (1,1), (2,2);
        INSERT INTO child VALUES (1,1), (2,2);
        connection node_2;
        set wsrep_sync_wait=0;
        DELETE FROM grandparent WHERE id = 1;
        

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            jplindst Jan Lindström
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration