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

gcol.innodb_virtual_purge failed in buildbot with lock wait timeout

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4
    • 10.4
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/6374

      10.4 f9e53a659c87f1147d4f6d004702077d

      gcol.innodb_virtual_purge 'innodb'       w3 [ fail ]
              Test ended at 2020-06-12 06:59:09
       
      CURRENT_TEST: gcol.innodb_virtual_purge
      mysqltest: At line 170: query 'TRUNCATE TABLE t2' failed: 1205: Lock wait timeout exceeded; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      CREATE TABLE t1 (a VARCHAR(30), b INT, a2 VARCHAR(30) GENERATED ALWAYS AS (a) VIRTUAL);
      CREATE INDEX idx ON t1(a2(10), b, a2(20));
      ERROR 42S21: Duplicate column name 'a2'
      DROP TABLE t1;
      #
      # MDEV-17540 Server crashes in row_purge after TRUNCATE TABLE
      #
      CREATE TABLE t1 (a BIT(14)) ENGINE=InnoDB;
      INSERT INTO t1 VALUES
      (b'01110110101011'),(b'01100111111000'),(b'00001011110100'),
      (b'01110110111010'),(b'10001010101011'),(b'01100111001111');
      CREATE TABLE t2 (
      pk INT DEFAULT 1,
      b YEAR,
      c BIT(14),
      d YEAR AS (b),
      e BIT(14) AS (c),
      UNIQUE(pk),
      KEY(e)
      ) ENGINE=InnoDB;
      

      Attachments

        Activity

          People

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