MySQL Forums
Forum List  »  Newbie

[Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
Posted by: Robert Tee
Date: February 23, 2020 09:27AM

Hello,
I am struggling with a prevalent error in MySQL 5.7.25 for Mac OS X 10.14.6 in high-traffic environment. It has been documented online and noted as a bug in MySQL 5.7 here: https://bugs.mysql.com/bug.php?id=79125

I have already increased my shell maxfiles size to 64000 524288 but as I understand this does not matter.

CNF Config:
table_open_cache = 500
max_connections = 300
interactive_timeout = 300
wait_timeout = 300

The error begins to backlog in MySQL error log for a few hours before MySQL dies and I need to force-quit and restart it.

At this point, I cannot update MySQL because of my Solution Stack (MAMP) requirements.

2019-01-22T09:56:18.753656-06:00 0 [Warning] File Descriptor 1028 exceeded FD_SETSIZE=1024
2019-01-22T09:56:18.762894-06:00 0 [Warning] File Descriptor 1028 exceeded FD_SETSIZE=1024
2019-01-22T21:16:23.931825-06:00 0 [Warning] File Descriptor 1033 exceeded FD_SETSIZE=1024
2019-01-22T21:16:23.942062-06:00 0 [Warning] File Descriptor 1033 exceeded FD_SETSIZE=1024
2019-01-23T02:40:46.794219-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T02:40:46.802768-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T07:32:28.304186-06:00 0 [Warning] File Descriptor 1030 exceeded FD_SETSIZE=1024
2019-01-23T07:32:28.313331-06:00 0 [Warning] File Descriptor 1040 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.291382-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.302778-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.303748-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.304614-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024


Also:

https://mampsupportforum.com/forums/latest/warning-file-descriptor-1032-exceeded-fd-setsize-1024

Options: ReplyQuote


Subject
Written By
Posted
[Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
February 23, 2020 09:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.