Type:
Task
Priority:
Critical
Resolution:
Fixed
In window functions tree, embedded mtr fails like so:
./mysql-test-run --embedded t/alias.test
...
Installing system database...
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.alias [ fail ]
Test ended at 2016-03-31 13:23:14
CURRENT_TEST: main.alias
mysqltest: Can't initialize MySQL server
The failure comes from here
#0 my_error_register (get_errmsgs=0x555555d69448 <get_server_errmsgs()>, first=1000, last=2001) at /home/psergey/dev-git/10.2-window-funcs-r10/mysys/my_error.c:245
#1 0x0000555555d695ad in init_errmessage () at /home/psergey/dev-git/10.2-window-funcs-r10/sql/derror.cc:106
#2 0x00005555559ceaa7 in init_common_variables () at /home/psergey/dev-git/10.2-window-funcs-r10/libmysqld/../sql/mysqld.cc:4515
#3 0x00005555559d4e9b in init_embedded_server (argc=125, argv=0x5555575b1e18, groups=0x555556ab2300 <embedded_server_groups>) at /home/psergey/dev-git/10.2-window-funcs-r10/libmysqld/lib_sql.cc:559
#4 0x00005555559b9063 in mysql_server_init (argc=7, argv=0x555556ca5540 <embedded_server_args>, groups=0x555556ab2300 <embedded_server_groups>) at /home/psergey/dev-git/10.2-window-funcs-r10/libmysql/libmysql.c:181
#5 0x000055555597c7b3 in main (argc=18, argv=0x7fffffffe018) at /home/psergey/dev-git/10.2-window-funcs-r10/client/mysqltest.cc:8974
We are in
my_error_register (get_errmsgs=0x555555d69448 <get_server_errmsgs()>, first=1000, last=2001)
Trying to register server error messages with codes in [1000, 2000] range.
The problem is that error code 2000 is already used by the client error messages:
(gdb) p my_errmsgs_list->meh_next[0]
$71 = {meh_next = 0x0, get_errmsgs = 0x555555be708d <get_client_errmsgs>, meh_first = 2000, meh_last = 2061}
is part of
MDEV-6115
window functions as in the SQL standard
Closed
{"report":{"fcp":987.5,"ttfb":486.09999990463257,"pageVisibility":"visible","entityId":56316,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b9593b1e-2286-4803-a291-2c5e0bff797b","navigationType":0,"readyForUser":1040.8999998569489,"redirectCount":0,"resourceLoadedEnd":591.5,"resourceLoadedStart":491.5,"resourceTiming":[{"duration":5.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":491.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":491.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":497,"responseStart":0,"secureConnectionStart":0},{"duration":5.400000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":491.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":491.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":497.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":65.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":491.7999999523163,"connectEnd":491.7999999523163,"connectStart":491.7999999523163,"domainLookupEnd":491.7999999523163,"domainLookupStart":491.7999999523163,"fetchStart":491.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":499.89999985694885,"responseEnd":556.8999998569489,"responseStart":514.7999999523163,"secureConnectionStart":491.7999999523163},{"duration":99.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":491.89999985694885,"connectEnd":491.89999985694885,"connectStart":491.89999985694885,"domainLookupEnd":491.89999985694885,"domainLookupStart":491.89999985694885,"fetchStart":491.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":500.5,"responseEnd":591.5,"responseStart":513.8999998569489,"secureConnectionStart":491.89999985694885},{"duration":37.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":492,"connectEnd":492,"connectStart":492,"domainLookupEnd":492,"domainLookupStart":492,"fetchStart":492,"redirectEnd":0,"redirectStart":0,"requestStart":502.09999990463257,"responseEnd":529.5999999046326,"responseStart":528.6999998092651,"secureConnectionStart":492},{"duration":48.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":492.09999990463257,"connectEnd":492.09999990463257,"connectStart":492.09999990463257,"domainLookupEnd":492.09999990463257,"domainLookupStart":492.09999990463257,"fetchStart":492.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":508,"responseEnd":540.5999999046326,"responseStart":539.8999998569489,"secureConnectionStart":492.09999990463257},{"duration":47.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":492.19999980926514,"connectEnd":492.19999980926514,"connectStart":492.19999980926514,"domainLookupEnd":492.19999980926514,"domainLookupStart":492.19999980926514,"fetchStart":492.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":508.19999980926514,"responseEnd":539.7999999523163,"responseStart":539,"secureConnectionStart":492.19999980926514},{"duration":14.700000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":492.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":492.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":507,"responseStart":0,"secureConnectionStart":0},{"duration":70,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":492.39999985694885,"connectEnd":492.39999985694885,"connectStart":492.39999985694885,"domainLookupEnd":492.39999985694885,"domainLookupStart":492.39999985694885,"fetchStart":492.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":508.2999999523163,"responseEnd":562.3999998569489,"responseStart":561.7999999523163,"secureConnectionStart":492.39999985694885},{"duration":14.699999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":492.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":492.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":507.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":57.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":492.59999990463257,"connectEnd":492.59999990463257,"connectStart":492.59999990463257,"domainLookupEnd":492.59999990463257,"domainLookupStart":492.59999990463257,"fetchStart":492.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":508.39999985694885,"responseEnd":550,"responseStart":547.1999998092651,"secureConnectionStart":492.59999990463257},{"duration":22.100000143051147,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":503.39999985694885,"connectEnd":512.3999998569489,"connectStart":512.3999998569489,"domainLookupEnd":512.3999998569489,"domainLookupStart":512.3999998569489,"fetchStart":503.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":512.7999999523163,"responseEnd":525.5,"responseStart":523.8999998569489,"secureConnectionStart":512.3999998569489},{"duration":23.700000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":504.19999980926514,"connectEnd":504.19999980926514,"connectStart":504.19999980926514,"domainLookupEnd":504.19999980926514,"domainLookupStart":504.19999980926514,"fetchStart":504.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":516.1999998092651,"responseEnd":527.8999998569489,"responseStart":526.5999999046326,"secureConnectionStart":504.19999980926514},{"duration":210.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":762.7999999523163,"connectEnd":762.7999999523163,"connectStart":762.7999999523163,"domainLookupEnd":762.7999999523163,"domainLookupStart":762.7999999523163,"fetchStart":762.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":940,"responseEnd":973.5999999046326,"responseStart":972.6999998092651,"secureConnectionStart":762.7999999523163},{"duration":149.30000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":967.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":967.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1116.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":51,"responseStart":486,"responseEnd":503,"domLoading":490,"domInteractive":1095,"domContentLoadedEventStart":1095,"domContentLoadedEventEnd":1129,"domComplete":1461,"loadEventStart":1461,"loadEventEnd":1461,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1077.5999999046326},{"name":"bigPipe.sidebar-id.end","time":1078.3999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":1078.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1079.5999999046326},{"name":"activityTabFullyLoaded","time":1143.5}],"measures":[],"correlationId":"3ca3313875fa6e","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":375,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Discussed with sanja, he has confirmed that this issue exist. The danger of running out of error message codes was discussed by him and either monty or serg.