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

innodb.truncate_foreign failed in buildbot with wrong error code

    XMLWordPrintable

    Details

      Description

      Note: Possibly it has already been fixed, but I don't see a clear indication of it.

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3972

      bb-10.2-release f509169d342e1395ae80581ca1056515 2020-05-06 21:09:56

      innodb.truncate_foreign 'innodb'         w2 [ fail ]
              Test ended at 2020-05-06 18:44:48
       
      CURRENT_TEST: innodb.truncate_foreign
      mysqltest: At line 41: query 'TRUNCATE TABLE child' succeeded - should have failed with errno 1205...
       
      The result from queries just before the failure was:
      < snip >
      a
      2
      connect  dml,localhost,root;
      SET DEBUG_SYNC='foreign_constraint_update_cascade SIGNAL fk WAIT_FOR go';
      UPDATE parent SET a=3;
      connection default;
      SET DEBUG_SYNC='now WAIT_FOR fk';
      SET lock_wait_timeout=1;
      TRUNCATE TABLE child;
      ERROR HY000: Lock wait timeout exceeded; try restarting transaction
      SET DEBUG_SYNC='now SIGNAL go';
      connection dml;
      SELECT * FROM child;
      a
      3
      SET DEBUG_SYNC='foreign_constraint_check_for_update SIGNAL fk WAIT_FOR go';
      DELETE FROM parent;
      connection default;
      SET DEBUG_SYNC='now WAIT_FOR fk';
      TRUNCATE TABLE child;
      

        Attachments

          Activity

            People

            Assignee:
            thiru Thirunarayanan Balathandayuthapani
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: