[MDEV-13617] tokudb_parts tests failed in buildbot - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.1
Component/s: Tests
Labels:
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

Assignee:: Alexander Barkov

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2017-08-22 10:02

Updated:: 2017-08-22 16:49

Resolved:: 2017-08-22 16:49

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.