On Windows, sometimes slave stops unexpectedlly. log shows the following error.
> 2019-05-30 3:21:55 6 [ERROR] Semisync slave socket fd is 580. select()
> cannot handle if the socket fd is greater than 64 (FD_SETSIZE).
> 2019-05-30 3:21:55 6 [Note] Stopping ack receiver thread
Searched MariaDB implementation, above log message is printed here.
https://github.com/MariaDB/server/blob/dde2ca4aa108b611b5fdfc970146b28461ef08bf/sql/semisync_master_ack_receiver.h#L214-L222
#ifndef WINDOWS
|
if (socket_id > FD_SETSIZE)
|
{
|
sql_print_error("Semisync slave socket fd is %u. "
|
"select() cannot handle if the socket fd is "
|
"greater than %u (FD_SETSIZE).", socket_id, FD_SETSIZE);
|
return 0;
|
}
|
#endif //WINDOWS
|
It seems that #ifndef WINDOWS is incorrect, it should be _WIN32.
Because of incorrect #ifndef definition, needless check is executed on Windows.
It seems that master can't receive ack from slave, slave waits until master response, then it causes timeout and disconnect connection.(maybe)
In contrast to MySQL case, it uses _WIN32.
https://github.com/mysql/mysql-server/blob/8.0/plugin/semisync/semisync_master_socket_listener.h#L114-L120
#ifndef _WIN32
|
if (socket_id > FD_SETSIZE) {
|
LogErr(ERROR_LEVEL, ER_SEMISYNC_FAILED_TO_HANDLE_SOCKET, socket_id,
|
FD_SETSIZE);
|
return false;
|
}
|
#endif // _WIN32
|
{"report":{"fcp":1565.4000005722046,"ttfb":310.6000003814697,"pageVisibility":"visible","entityId":76463,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"580f0cb0-54b2-406b-ab5e-68c7deb09216","navigationType":0,"readyForUser":1678.5,"redirectCount":0,"resourceLoadedEnd":1236.5,"resourceLoadedStart":337.30000019073486,"resourceTiming":[{"duration":235.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":337.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":337.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":572.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":238.10000038146973,"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":337.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":337.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":575.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":753.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":337.80000019073486,"connectEnd":337.80000019073486,"connectStart":337.80000019073486,"domainLookupEnd":337.80000019073486,"domainLookupStart":337.80000019073486,"fetchStart":337.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":582.1999998092651,"responseEnd":1091.1000003814697,"responseStart":637.5,"secureConnectionStart":337.80000019073486},{"duration":898.5,"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":338,"connectEnd":338,"connectStart":338,"domainLookupEnd":338,"domainLookupStart":338,"fetchStart":338,"redirectEnd":0,"redirectStart":0,"requestStart":583.6000003814697,"responseEnd":1236.5,"responseStart":651.4000005722046,"secureConnectionStart":338},{"duration":320.1000003814697,"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":338.19999980926514,"connectEnd":338.19999980926514,"connectStart":338.19999980926514,"domainLookupEnd":338.19999980926514,"domainLookupStart":338.19999980926514,"fetchStart":338.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":583.9000005722046,"responseEnd":658.3000001907349,"responseStart":650.6000003814697,"secureConnectionStart":338.19999980926514},{"duration":328.6000003814697,"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":338.30000019073486,"connectEnd":338.30000019073486,"connectStart":338.30000019073486,"domainLookupEnd":338.30000019073486,"domainLookupStart":338.30000019073486,"fetchStart":338.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":635.5,"responseEnd":666.9000005722046,"responseStart":661.1999998092651,"secureConnectionStart":338.30000019073486},{"duration":320.80000019073486,"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":338.5,"connectEnd":338.5,"connectStart":338.5,"domainLookupEnd":338.5,"domainLookupStart":338.5,"fetchStart":338.5,"redirectEnd":0,"redirectStart":0,"requestStart":585.6999998092651,"responseEnd":659.3000001907349,"responseStart":652.5,"secureConnectionStart":338.5},{"duration":246.70000076293945,"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":338.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":338.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":585.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":334.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":338.9000005722046,"connectEnd":338.9000005722046,"connectStart":338.9000005722046,"domainLookupEnd":338.9000005722046,"domainLookupStart":338.9000005722046,"fetchStart":338.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":636,"responseEnd":673.6999998092651,"responseStart":667.4000005722046,"secureConnectionStart":338.9000005722046},{"duration":282.19999980926514,"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":339,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":339,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":621.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":348.5999994277954,"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":339.1000003814697,"connectEnd":339.1000003814697,"connectStart":339.1000003814697,"domainLookupEnd":339.1000003814697,"domainLookupStart":339.1000003814697,"fetchStart":339.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":636.1999998092651,"responseEnd":687.6999998092651,"responseStart":673.9000005722046,"secureConnectionStart":339.1000003814697},{"duration":892.6999998092651,"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":340,"connectEnd":340,"connectStart":340,"domainLookupEnd":340,"domainLookupStart":340,"fetchStart":340,"redirectEnd":0,"redirectStart":0,"requestStart":1070.1000003814697,"responseEnd":1232.6999998092651,"responseStart":1225.6999998092651,"secureConnectionStart":340},{"duration":890.1999998092651,"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":343,"connectEnd":343,"connectStart":343,"domainLookupEnd":343,"domainLookupStart":343,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":1070.8000001907349,"responseEnd":1233.1999998092651,"responseStart":1227.8000001907349,"secureConnectionStart":343},{"duration":128.0999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1250.6000003814697,"connectEnd":1250.6000003814697,"connectStart":1250.6000003814697,"domainLookupEnd":1250.6000003814697,"domainLookupStart":1250.6000003814697,"fetchStart":1250.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1347.8000001907349,"responseEnd":1378.6999998092651,"responseStart":1377.1000003814697,"secureConnectionStart":1250.6000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":140,"responseStart":310,"responseEnd":342,"domLoading":316,"domInteractive":1749,"domContentLoadedEventStart":1749,"domContentLoadedEventEnd":1815,"domComplete":2924,"loadEventStart":2924,"loadEventEnd":2925,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1728.4000005722046},{"name":"bigPipe.sidebar-id.end","time":1729.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1729.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1730.5},{"name":"activityTabFullyLoaded","time":1829.1000003814697}],"measures":[],"correlationId":"8a8badfb70879a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":89,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
FYI: MySQL fixed this by https://github.com/mysql/mysql-server/commit/ec76a52483c3eec49a878e751341246be66a6802 .