http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/2000/steps/test_5/logs/stdio
main.order_by_optimizer_innodb 'xtradb' w1 [ fail ]
|
Test ended at 2016-07-03 04:07:35
|
|
CURRENT_TEST: main.order_by_optimizer_innodb
|
--- /usr/share/mysql/mysql-test/r/order_by_optimizer_innodb.result 2016-07-03 02:45:44.000000000 -0400
|
+++ /dev/shm/var/1/log/order_by_optimizer_innodb.reject 2016-07-03 04:07:35.159355291 -0400
|
@@ -40,7 +40,7 @@
|
# The following should use range(ux_pk1_fd5), two key parts (key_len=5+8=13)
|
EXPLAIN SELECT * FROM t2 USE INDEX(ux_pk1_fd5) WHERE pk1=9 AND fd5 < 500 ORDER BY fd5 DESC LIMIT 10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t2 range ux_pk1_fd5 ux_pk1_fd5 13 NULL 137 Using where
|
+1 SIMPLE t2 ref ux_pk1_fd5 ux_pk1_fd5 4 const 137 Using where
|
# This also must use range, not ref. key_len must be 13
|
EXPLAIN SELECT * FROM t2 WHERE pk1=9 AND fd5 < 500 ORDER BY fd5 DESC LIMIT 10;
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
mysqltest: Result length mismatch
|
- relates to
-
MDEV-7069
Fix buildbot failures in main server trees
-
-
Stalled
Valerii Kravchuk
made changes -
Affects Version/s
|
|
10.4
[ 22408
]
|
Michael Widenius
made changes -
Assignee
|
|
Sergei Petrunia
[ psergey
]
|
Aleksey Midenkov
made changes -
Fix Version/s
|
|
10.3
[ 22126
]
|
Fix Version/s
|
10.1
[ 16100
]
|
|
Affects Version/s
|
|
10.3
[ 22126
]
|
Affects Version/s
|
|
10.5
[ 23123
]
|
Aleksey Midenkov
made changes -
Fix Version/s
|
|
10.1
[ 16100
]
|
Fix Version/s
|
10.3
[ 22126
]
|
|
Marko Mäkelä
made changes -
Fix Version/s
|
|
10.2
[ 14601
]
|
Fix Version/s
|
|
10.3
[ 22126
]
|
Fix Version/s
|
|
10.4
[ 22408
]
|
Fix Version/s
|
|
10.5
[ 23123
]
|
Fix Version/s
|
|
10.6
[ 24028
]
|
Priority
|
Minor
[ 4
]
|
Major
[ 3
]
|
Sergei Golubchik
made changes -
Workflow
|
MariaDB v3
[ 76826
]
|
MariaDB v4
[ 140072
]
|
Ralf Gebhardt
made changes -
Fix Version/s
|
10.2
[ 14601
]
|
|
Julien Fritsch
made changes -
Fix Version/s
|
10.3
[ 22126
]
|
|
Sergei Petrunia
made changes -
Status
|
Open
[ 1
]
|
In Progress
[ 3
]
|
Sergei Petrunia
made changes -
Fix Version/s
|
|
10.4.32
[ 29300
]
|
Fix Version/s
|
|
10.5.23
[ 29012
]
|
Fix Version/s
|
|
10.6.16
[ 29014
]
|
Fix Version/s
|
|
10.10.7
[ 29018
]
|
Fix Version/s
|
|
10.11.6
[ 29020
]
|
Fix Version/s
|
|
11.0.4
[ 29021
]
|
Fix Version/s
|
|
11.1.3
[ 29023
]
|
Fix Version/s
|
|
11.2.2
[ 29035
]
|
Fix Version/s
|
|
11.3.1
[ 29416
]
|
Fix Version/s
|
10.4
[ 22408
]
|
|
Fix Version/s
|
10.5
[ 23123
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
Status
|
In Progress
[ 3
]
|
Closed
[ 6
]
|
{"report":{"fcp":1793,"ttfb":587.3000001907349,"pageVisibility":"visible","entityId":57821,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"3dd86e42-d6bb-4b67-8f11-b70699021b9a","navigationType":0,"readyForUser":1864.5,"redirectCount":0,"resourceLoadedEnd":2205.800000190735,"resourceLoadedStart":593.6000003814697,"resourceTiming":[{"duration":742.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":593.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":593.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1336.5,"responseStart":0,"secureConnectionStart":0},{"duration":742.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":593.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":593.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1336.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":751.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":594.1000003814697,"connectEnd":594.1000003814697,"connectStart":594.1000003814697,"domainLookupEnd":594.1000003814697,"domainLookupStart":594.1000003814697,"fetchStart":594.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":594.1000003814697,"responseEnd":1345.9000005722046,"responseStart":1345.9000005722046,"secureConnectionStart":594.1000003814697},{"duration":788.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":594.1999998092651,"connectEnd":594.1999998092651,"connectStart":594.1999998092651,"domainLookupEnd":594.1999998092651,"domainLookupStart":594.1999998092651,"fetchStart":594.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":594.1999998092651,"responseEnd":1382.8000001907349,"responseStart":1382.8000001907349,"secureConnectionStart":594.1999998092651},{"duration":792.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":594.4000005722046,"connectEnd":594.4000005722046,"connectStart":594.4000005722046,"domainLookupEnd":594.4000005722046,"domainLookupStart":594.4000005722046,"fetchStart":594.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":594.4000005722046,"responseEnd":1386.6000003814697,"responseStart":1386.6000003814697,"secureConnectionStart":594.4000005722046},{"duration":792.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":594.6000003814697,"connectEnd":594.6000003814697,"connectStart":594.6000003814697,"domainLookupEnd":594.6000003814697,"domainLookupStart":594.6000003814697,"fetchStart":594.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":594.6000003814697,"responseEnd":1387.1000003814697,"responseStart":1387.1000003814697,"secureConnectionStart":594.6000003814697},{"duration":792.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":594.8000001907349,"connectEnd":594.8000001907349,"connectStart":594.8000001907349,"domainLookupEnd":594.8000001907349,"domainLookupStart":594.8000001907349,"fetchStart":594.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":594.8000001907349,"responseEnd":1387.4000005722046,"responseStart":1387.4000005722046,"secureConnectionStart":594.8000001907349},{"duration":891.5999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":594.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":594.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1486.5,"responseStart":0,"secureConnectionStart":0},{"duration":793.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":595.1000003814697,"connectEnd":595.1000003814697,"connectStart":595.1000003814697,"domainLookupEnd":595.1000003814697,"domainLookupStart":595.1000003814697,"fetchStart":595.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":595.1000003814697,"responseEnd":1388.4000005722046,"responseStart":1388.4000005722046,"secureConnectionStart":595.1000003814697},{"duration":891.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":595.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":595.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1486.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":793.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":595.5,"connectEnd":595.5,"connectStart":595.5,"domainLookupEnd":595.5,"domainLookupStart":595.5,"fetchStart":595.5,"redirectEnd":0,"redirectStart":0,"requestStart":595.5,"responseEnd":1389,"responseStart":1389,"secureConnectionStart":595.5},{"duration":1402.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":596.1999998092651,"connectEnd":596.1999998092651,"connectStart":596.1999998092651,"domainLookupEnd":596.1999998092651,"domainLookupStart":596.1999998092651,"fetchStart":596.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":596.1999998092651,"responseEnd":1998.5,"responseStart":1998.5,"secureConnectionStart":596.1999998092651},{"duration":1605.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":600.6000003814697,"connectEnd":600.6000003814697,"connectStart":600.6000003814697,"domainLookupEnd":600.6000003814697,"domainLookupStart":600.6000003814697,"fetchStart":600.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":600.6000003814697,"responseEnd":2205.800000190735,"responseStart":2205.800000190735,"secureConnectionStart":600.6000003814697},{"duration":511.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1497.8000001907349,"connectEnd":1497.8000001907349,"connectStart":1497.8000001907349,"domainLookupEnd":1497.8000001907349,"domainLookupStart":1497.8000001907349,"fetchStart":1497.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1497.8000001907349,"responseEnd":2009.3000001907349,"responseStart":2009.3000001907349,"secureConnectionStart":1497.8000001907349},{"duration":423.1000003814697,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1786.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1786.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2209.6000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":352,"responseStart":587,"responseEnd":593,"domLoading":591,"domInteractive":2238,"domContentLoadedEventStart":2238,"domContentLoadedEventEnd":2284,"domComplete":2685,"loadEventStart":2685,"loadEventEnd":2686,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2210.5},{"name":"bigPipe.sidebar-id.end","time":2211.4000005722046},{"name":"bigPipe.activity-panel-pipe-id.start","time":2211.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":2215.699999809265},{"name":"activityTabFullyLoaded","time":2300.9000005722046}],"measures":[],"correlationId":"687e397668e1de","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":149,"dbReadsTimeInMs":24,"dbConnsTimeInMs":34,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}