main.partition_pruning unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.7 |
New
|
Undecided
|
Unassigned |
Bug Description
Somewhat difficult to reproduce reliably. I saw it on one loacl mtr run, then was able to get it again with this mtr incantation:
> ./mtr --big-test --repeat=3 --parallel=8 t/partition_
ing.test t/partition_
Logging: ./mtr --force --retry=0 --retry-failure=0 --max-test-fail=0 --no-warnings --testcase-
MySQL Version 5.7.17
Checking supported features...
- SSL connections supported
- binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/ssd/percona/
Installing system database...
Using parallel: 8
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
=======
TEST WORKER RESULT TIME (ms) or COMMENT
-------
worker[6] Using MTR_BUILD_THREAD 303, with reserved ports 13030..13039
worker[4] Using MTR_BUILD_THREAD 304, with reserved ports 13040..13049
worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 13010..13019
worker[8] Using MTR_BUILD_THREAD 305, with reserved ports 13050..13059
worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 13020..13029
worker[5] Using MTR_BUILD_THREAD 306, with reserved ports 13060..13069
worker[7] Using MTR_BUILD_THREAD 307, with reserved ports 13070..13079
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
Test ended at 2017-03-28 13:18:02
CURRENT_TEST: main.partition_
--- /ssd/percona/
+++ /ssd/percona/
@@ -4856,7 +4856,7 @@
insert into t1 values ('aa'),
explain partitions select * from t1 where s1 = 0 or s1 is null;
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
-1 SIMPLE t1 p0 ALL NULL NULL NULL NULL # 55.56 Using where
+1 SIMPLE t1 p0 ALL NULL NULL NULL NULL # 43.75 Using where
Warnings:
Warning 1681 'PARTITIONS' is deprecated and will be removed in a future release.
Note 1003 /* select#1 */ select `test`.`t1`.`s1` AS `s1` from `test`.`t1` where ((`test`.`t1`.`s1` = 0) or isnull(
mysqltest: Result content mismatch
safe_process[
Server [mysqld.1 - pid: 12605, winpid: 12605] log:
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------
- the logfile can be found in '/ssd/percona/
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
Test ended at 2017-03-28 13:18:20
CURRENT_TEST: main.partition_
--- /ssd/percona/
+++ /ssd/percona/
@@ -2702,7 +2702,7 @@
EXPLAIN PARTITIONS SELECT * FROM t1
WHERE b = CAST('2009-04-02 23:59:59' AS DATETIME);
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
-1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 33.33 Using where
+1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 25.00 Using where
Warnings:
Warning 1681 'PARTITIONS' is deprecated and will be removed in a future release.
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`b` = <cache>
@@ -2794,7 +2794,7 @@
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`b` <= '2009-04-02 23:59:59')
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE b = '2009-04-02 23:59:59';
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
-1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 33.33 Using where
+1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 25.00 Using where
Warnings:
Warning 1681 'PARTITIONS' is deprecated and will be removed in a future release.
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`b` = '2009-04-02 23:59:59')
@@ -2892,7 +2892,7 @@
EXPLAIN PARTITIONS SELECT * FROM t1
WHERE b = CAST('2009-04-02 23:59:58' AS DATETIME);
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
-1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 33.33 Using where
+1 SIMPLE t1 p20090402 ALL NULL NULL NULL NULL # 25.00 Using where
Warnings:
Warning 1681 'PARTITIONS' is deprecated and will be removed in a future release.
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`b` = <cache>
mysqltest: Result content mismatch
safe_process[
Server [mysqld.1 - pid: 12604, winpid: 12604] log:
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------
- the logfile can be found in '/ssd/percona/
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
main.partition_
-------
The servers were restarted 2 times
Spent 813.277 of 123 seconds executing testcases
Completed: Failed 2/48 tests, 95.83% were successful.
Failing test(s): main.partition_
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://
mysql-test-run: *** ERROR: there were failing test cases
tags: | added: ci |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3670