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

gcol.innodb_virtual_basic failed in buildbot with wrong result, sporadic

    XMLWordPrintable

Details

    Description

      https://buildbot.mariadb.org/#/builders/862/builds/15798/steps/17/logs/stdio

      gcol.innodb_virtual_basic                w8 [ fail ]
              Test ended at 2026-07-17 19:53:14
      CURRENT_TEST: gcol.innodb_virtual_basic
      mysqltest: At line 519: The result of the 1st execution does not match with 
      the result of the 2nd execution of ps-protocol:
       1st:
      a	c
      NULL	NULL
      11	14
      18	19
      28	29
       2nd:
       a	c
      11	14
      18	19
      28	29
      NULL	NULL
      The result from queries just before the failure was:
      < snip >
      `e` INT(11) GENERATED ALWAYS AS (10) VIRTUAL,
      `h` INT(11) NOT NULL,
      PRIMARY KEY (`h`),
      KEY `m3` (`m3`),
      KEY `c` (`c`(100)),
      KEY `e` (`e`,`d`(20))
      ) ENGINE=InnoDB;
      INSERT INTO t VALUES (1, 2, DEFAULT, 3, "aaa", DEFAULT, REPEAT('g', 10000), REPEAT('x', 2800), DEFAULT, DEFAULT, DEFAULT, 1);
      INSERT INTO t VALUES (11, 21, DEFAULT, 31, "bbb", DEFAULT, REPEAT('a', 9000), REPEAT('b', 2000), DEFAULT, DEFAULT, DEFAULT, 2);
      INSERT INTO t VALUES (21, 31, DEFAULT, 41, "zzz", DEFAULT, REPEAT('m', 8000), REPEAT('n', 3000), DEFAULT, DEFAULT, DEFAULT, 3);
      ALTER TABLE t DROP COLUMN c;
      DELETE FROM t;
      DROP TABLE t;
      CREATE TABLE t (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10));
      INSERT INTO t VALUES (11, 3, DEFAULT, 'mm');
      INSERT INTO t VALUES (18, 1, DEFAULT, 'mm');
      INSERT INTO t VALUES (28, 1, DEFAULT, 'mm');
      INSERT INTO t VALUES (null, null, DEFAULT, 'mm');
      CREATE INDEX idx ON t(a, c);
      SELECT a, c FROM t;
      More results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/8/log/innodb_virtual_basic.log
       - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/8/log/gcol.innodb_virtual_basic/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/gcol.innodb_virtual_basic/'
      Retrying test gcol.innodb_virtual_basic, attempt(2/3)...
      

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.