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

tokudb_parts tests failed in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3
    • 10.3.1
    • Tests
    • None

    Description

      tokudb_parts.part_supported_sql_func_tokudb, partition_alter2_1_1_tokudb, partition_alter2_1_2_tokudb, partition_alter1_1_2_tokudb, partition_alter1_1_tokudb failed with "Result length mismatch" http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1161/steps/test_2/logs/stdio

      tokudb_parts.part_supported_sql_func_tokudb w2 [ fail ]
              Test ended at 2017-08-21 23:29:06
       
      CURRENT_TEST: tokudb_parts.part_supported_sql_func_tokudb
      --- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/part_supported_sql_func_tokudb.result	2017-08-20 14:24:55.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/part_supported_sql_func_tokudb.reject	2017-08-21 23:29:05.618693633 -0400
      @@ -2318,7 +2318,7 @@
         `col1` int(11) DEFAULT NULL
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
        PARTITION BY LIST (`colint`)
      -SUBPARTITION BY HASH (`col1` % 10)
      +SUBPARTITION BY HASH (`col1` MOD 10)
       SUBPARTITIONS 5
       (PARTITION `p0` VALUES IN (1,2,3,4,5,6,7,8,9,10) ENGINE = TokuDB,
        PARTITION `p1` VALUES IN (11,12,13,14,15,16,17,18,19,20) ENGINE = TokuDB,
       
      mysqltest: Result length mismatch
      

      tokudb_parts.partition_alter1_1_2_tokudb w2 [ fail ]
              Test ended at 2017-08-21 23:39:43
       
      CURRENT_TEST: tokudb_parts.partition_alter1_1_2_tokudb
      --- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_2_tokudb.result	2017-08-20 14:24:55.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_2_tokudb.reject	2017-08-21 23:39:42.419002751 -0400
      @@ -1067,7 +1067,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -3084,7 +3084,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -3592,7 +3592,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -5081,7 +5081,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -7098,7 +7098,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -7606,7 +7606,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -9128,7 +9128,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -11209,7 +11209,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -11733,7 +11733,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -13270,7 +13270,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -15351,7 +15351,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -15875,7 +15875,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -17384,7 +17384,7 @@
         PRIMARY KEY (`f_int2`,`f_int1`),
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -19405,7 +19405,7 @@
         PRIMARY KEY (`f_int2`,`f_int1`),
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -19914,7 +19914,7 @@
         PRIMARY KEY (`f_int2`,`f_int1`),
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -21406,7 +21406,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -23427,7 +23427,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -23936,7 +23936,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -25428,7 +25428,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
      + PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -27449,7 +27449,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int2` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -27958,7 +27958,7 @@
         PRIMARY KEY (`f_int1`,`f_int2`),
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int2`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
       
      mysqltest: Result length mismatch
      

      tokudb_parts.partition_alter1_1_tokudb   w2 [ fail ]
              Test ended at 2017-08-21 23:50:26
       
      CURRENT_TEST: tokudb_parts.partition_alter1_1_tokudb
      --- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_tokudb.result	2017-08-20 14:24:55.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_tokudb.reject	2017-08-21 23:50:25.295140189 -0400
      @@ -1385,7 +1385,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (`f_int1` % 4)
      + PARTITION BY LIST (`f_int1` MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -3404,7 +3404,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int1` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -3912,7 +3912,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int1`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -5401,7 +5401,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (`f_int1` % 4)
      + PARTITION BY LIST (`f_int1` MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -7420,7 +7420,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int1` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -7928,7 +7928,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         PRIMARY KEY (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int1`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -9450,7 +9450,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (`f_int1` % 4)
      + PARTITION BY LIST (`f_int1` MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -11533,7 +11533,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int1` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -12057,7 +12057,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int1`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
      @@ -13594,7 +13594,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (`f_int1` % 4)
      + PARTITION BY LIST (`f_int1` MOD 4)
       (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
        PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
        PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
      @@ -15677,7 +15677,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 3))
      + PARTITION BY LIST (abs(`f_int1` MOD 3))
       SUBPARTITION BY HASH (`f_int1` + 1)
       (PARTITION `part1` VALUES IN (0)
        (SUBPARTITION `sp11` ENGINE = TokuDB,
      @@ -16201,7 +16201,7 @@
         `f_charbig` varchar(1000) DEFAULT NULL,
         UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
       ) ENGINE=TokuDB DEFAULT CHARSET=latin1
      - PARTITION BY LIST (abs(`f_int1` % 2))
      + PARTITION BY LIST (abs(`f_int1` MOD 2))
       SUBPARTITION BY KEY (`f_int1`)
       SUBPARTITIONS 3
       (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          People

            bar Alexander Barkov
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.