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

innodb_zip.innodb_prefix_index_liftedlimit failed with timeout in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.1(EOL)
    • 10.1.20
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/9096

      innodb_zip.innodb_prefix_index_liftedlimit 'xtradb' w4 [ fail ]  timeout after 9000 seconds
              Test ended at 2016-07-28 06:17:14
       
      Test case timeout after 9000 seconds
       
      == /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/4/log/innodb_prefix_index_liftedlimit.log == 
      DROP TABLE worklog5743_key4;
      CREATE TABLE worklog5743_key8 (
      col_1_blob BLOB (4000) , col_2_blob BLOB (4000) ,
      PRIMARY KEY (col_1_blob(3072))
      ) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, engine = innodb;
      INSERT INTO worklog5743_key8 VALUES(REPEAT("a", 4000) , REPEAT("o", 4000));
      INSERT INTO worklog5743_key8 VALUES(REPEAT("b", 4000) , REPEAT("p", 4000));
      SELECT col_1_blob  = REPEAT("a", 4000) , col_2_blob = REPEAT("o", 4000)
      FROM worklog5743_key8;
      col_1_blob  = REPEAT("a", 4000)	col_2_blob = REPEAT("o", 4000)
      1	1
      0	0
      UPDATE worklog5743_key8 SET col_1_blob = REPEAT("c", 4000)
      WHERE col_1_blob = REPEAT("a", 4000) AND col_2_blob = REPEAT("o", 4000);
      SELECT col_1_blob = REPEAT("b", 3500) FROM worklog5743_key8
      WHERE col_1_blob = REPEAT("c", 4000) AND col_2_blob = REPEAT("o", 4000);
      col_1_blob = REPEAT("b", 3500)
      0
      INSERT INTO worklog5743_key8 VALUES(REPEAT("a", 4000),REPEAT("o", 4000));
      DELETE FROM worklog5743_key8 WHERE col_1_blob = REPEAT("b", 4000);
      

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              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.