Type:
Priority:
Resolution:
Fixed
Affects Version/s:
N/A
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/37418/steps/mtr_nm/logs/stdio
3b3ce1fbca32cae713fd15b6199b4fe420b42701
sys_vars.sysvars_server_notembedded '32bit,unix' w2 [ fail ]
Test ended at 2022-09-12 15:52:37
CURRENT_TEST: sys_vars.sysvars_server_notembedded
--- /mnt/buildbot/build/mariadb-10.11.0/mysql-test/suite/sys_vars/r/sysvars_server_notembedded,32bit.result~ 2022-09-12 15:52:36.587663767 -0400
+++ /mnt/buildbot/build/mariadb-10.11.0/mysql-test/suite/sys_vars/r/sysvars_server_notembedded,32bit.reject 2022-09-12 15:52:36.995664139 -0400
@@ -1844,7 +1844,7 @@
COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME LOG_SLOW_MIN_EXAMINED_ROW_LIMIT
VARIABLE_SCOPE SESSION
-VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_TYPE INT UNSIGNED
VARIABLE_COMMENT Don't write queries to slow log that examine fewer rows than that
NUMERIC_MIN_VALUE 0
NUMERIC_MAX_VALUE 4294967295
@@ -2067,14 +2067,14 @@
VARIABLE_TYPE BIGINT UNSIGNED
VARIABLE_COMMENT Don't allow creation of heap tables bigger than this
NUMERIC_MIN_VALUE 16384
-NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_MAX_VALUE 4294967295
NUMERIC_BLOCK_SIZE 1024
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME MAX_INSERT_DELAYED_THREADS
VARIABLE_SCOPE SESSION
-VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_TYPE INT UNSIGNED
VARIABLE_COMMENT Alias for max_delayed_threads. Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used
NUMERIC_MIN_VALUE 0
NUMERIC_MAX_VALUE 16384
@@ -2254,7 +2254,7 @@
COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT
VARIABLE_SCOPE SESSION
-VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_TYPE INT UNSIGNED
VARIABLE_COMMENT Alias for log_slow_min_examined_row_limit. Don't write queries to slow log that examine fewer rows than that
NUMERIC_MIN_VALUE 0
NUMERIC_MAX_VALUE 4294967295
mysqltest: Result length mismatch
is caused by
MDEV-7567
rename slow queries variables
Closed
made changes -
2022-09-21 15:20
Link
This issue relates to TODO-3604
[ TODO-3604
]
made changes -
2022-09-21 15:27
Component/s
Variables
[ 13903
]
made changes -
2022-09-26 17:42
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2022-09-26 17:42
Status
In Progress
[ 3
]
In Testing
[ 10301
]
made changes -
2022-10-04 11:22
Fix Version/s
10.11.1
[ 28454
]
Fix Version/s
10.11
[ 27614
]
Resolution
Fixed
[ 1
]
Status
In Testing
[ 10301
]
Closed
[ 6
]
{"report":{"fcp":1366.4000005722046,"ttfb":398.70000076293945,"pageVisibility":"visible","entityId":114862,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"16236ea1-5722-4962-a007-fbd3c531d214","navigationType":0,"readyForUser":1606.1000003814697,"redirectCount":0,"resourceLoadedEnd":2539,"resourceLoadedStart":404.6000003814697,"resourceTiming":[{"duration":120.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":404.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":404.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":525.2000007629395,"responseStart":0,"secureConnectionStart":0},{"duration":121.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":405,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":405,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":189.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":405.20000076293945,"connectEnd":405.20000076293945,"connectStart":405.20000076293945,"domainLookupEnd":405.20000076293945,"domainLookupStart":405.20000076293945,"fetchStart":405.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":405.20000076293945,"responseEnd":594.4000005722046,"responseStart":594.4000005722046,"secureConnectionStart":405.20000076293945},{"duration":315.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":405.4000005722046,"connectEnd":405.4000005722046,"connectStart":405.4000005722046,"domainLookupEnd":405.4000005722046,"domainLookupStart":405.4000005722046,"fetchStart":405.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":405.4000005722046,"responseEnd":720.6000003814697,"responseStart":720.6000003814697,"secureConnectionStart":405.4000005722046},{"duration":319.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":405.70000076293945,"connectEnd":405.70000076293945,"connectStart":405.70000076293945,"domainLookupEnd":405.70000076293945,"domainLookupStart":405.70000076293945,"fetchStart":405.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":405.70000076293945,"responseEnd":724.9000005722046,"responseStart":724.9000005722046,"secureConnectionStart":405.70000076293945},{"duration":319.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":405.9000005722046,"connectEnd":405.9000005722046,"connectStart":405.9000005722046,"domainLookupEnd":405.9000005722046,"domainLookupStart":405.9000005722046,"fetchStart":405.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":405.9000005722046,"responseEnd":725.4000005722046,"responseStart":725.4000005722046,"secureConnectionStart":405.9000005722046},{"duration":319.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":406.1000003814697,"connectEnd":406.1000003814697,"connectStart":406.1000003814697,"domainLookupEnd":406.1000003814697,"domainLookupStart":406.1000003814697,"fetchStart":406.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":406.1000003814697,"responseEnd":725.7000007629395,"responseStart":725.7000007629395,"secureConnectionStart":406.1000003814697},{"duration":391.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":406.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":406.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":798,"responseStart":0,"secureConnectionStart":0},{"duration":319.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":406.5,"connectEnd":406.5,"connectStart":406.5,"domainLookupEnd":406.5,"domainLookupStart":406.5,"fetchStart":406.5,"redirectEnd":0,"redirectStart":0,"requestStart":406.5,"responseEnd":726.3000001907349,"responseStart":726.3000001907349,"secureConnectionStart":406.5},{"duration":391.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":406.70000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":406.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":798.5,"responseStart":0,"secureConnectionStart":0},{"duration":320,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":406.80000019073486,"connectEnd":406.80000019073486,"connectStart":406.80000019073486,"domainLookupEnd":406.80000019073486,"domainLookupStart":406.80000019073486,"fetchStart":406.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":406.80000019073486,"responseEnd":726.8000001907349,"responseStart":726.8000001907349,"secureConnectionStart":406.80000019073486},{"duration":890.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":412.20000076293945,"connectEnd":412.20000076293945,"connectStart":412.20000076293945,"domainLookupEnd":412.20000076293945,"domainLookupStart":412.20000076293945,"fetchStart":412.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":412.20000076293945,"responseEnd":1302.4000005722046,"responseStart":1302.3000001907349,"secureConnectionStart":412.20000076293945},{"duration":2117,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":422,"connectEnd":422,"connectStart":422,"domainLookupEnd":422,"domainLookupStart":422,"fetchStart":422,"redirectEnd":0,"redirectStart":0,"requestStart":422,"responseEnd":2539,"responseStart":2539,"secureConnectionStart":422},{"duration":435.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":867.4000005722046,"connectEnd":867.4000005722046,"connectStart":867.4000005722046,"domainLookupEnd":867.4000005722046,"domainLookupStart":867.4000005722046,"fetchStart":867.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":867.4000005722046,"responseEnd":1302.7000007629395,"responseStart":1302.7000007629395,"secureConnectionStart":867.4000005722046}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":206,"responseStart":399,"responseEnd":414,"domLoading":402,"domInteractive":2564,"domContentLoadedEventStart":2564,"domContentLoadedEventEnd":2617,"domComplete":4888,"loadEventStart":4888,"loadEventEnd":4889,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2540.800000190735},{"name":"bigPipe.sidebar-id.end","time":2541.7000007629395},{"name":"bigPipe.activity-panel-pipe-id.start","time":2541.9000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":2544},{"name":"activityTabFullyLoaded","time":2636.5}],"measures":[],"correlationId":"3959cc1696a0eb","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":128,"dbReadsTimeInMs":22,"dbConnsTimeInMs":41,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-7567 rename slow queries variables