[Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024

All MAMP discussions around troubleshooting and anything related to MAMP. Be as detailed as possible here when posting an issue.
Post Reply
mampsupportmod
Site Admin
Posts: 156
Joined: Wed Jan 20, 2021 3:06 am

[Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024

Post by mampsupportmod »

Saw a bunch of these errors in mysql_error.log and then MySQL died. I saw it's potentially a bug in 5.7 here and it's fixed in version 8.

I also saw some posts that Mac OS X has too many open files and you may need to raise the file descriptor limits here and here and a restart is required. Not sure how safe this is though.

Another solution is to set the MySQL interactive and wait timeout's to a lower value (versus default of 8 hours) so they release descriptors more quickly. The settings below are both for 5 minutes, but you might want to tighten that a bit more if you are running a production environment.


My.CNF:

Code: Select all

interactive_timeout = 300
wait_timeout = 300
Anyone have experience with this?

Mac OS X 10.14.2
MAMP Pro 5.2
MySQL 5.7.23


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
2019-01-23T12:03:54.305484-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.306341-06:00 0 [Warning] File Descriptor 1036 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.307217-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.310512-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:54.311865-06:00 0 [Warning] File Descriptor 1037 exceeded FD_SETSIZE=1024
2019-01-23T12:03:55.075392-06:00 0 [Warning] File Descriptor 1038 exceeded FD_SETSIZE=1024
2019-01-23T12:03:55.084937-06:00 0 [Warning] File Descriptor 1039 exceeded FD_SETSIZE=1024
2019-01-23T14:46:43.370416-06:00 0 [Warning] File Descriptor 1031 exceeded FD_SETSIZE=1024
2019-01-23T14:46:43.380674-06:00 0 [Warning] File Descriptor 1031 exceeded FD_SETSIZE=1024
2019-01-23T15:17:32.993687-06:00 0 [Warning] File Descriptor 1029 exceeded FD_SETSIZE=1024
2019-01-23T15:17:33.003711-06:00 0 [Warning] File Descriptor 1029 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.168848-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.178195-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.258724-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.269156-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.413230-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:41.422540-06:00 0 [Warning] File Descriptor 1026 exceeded FD_SETSIZE=1024
2019-01-23T22:52:42.388568-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024
2019-01-23T22:52:42.397778-06:00 0 [Warning] File Descriptor 1032 exceeded FD_SETSIZE=1024
MAMP Support Forums is an unofficial support forum covering MAMP & MAMP Pro solution stacks.
Post Reply