Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.12, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
Linux OL7
Description
Server generates errors and eventually crashes due to execeeding limit on number of open file descriptors.
This occurs when additional open_table_caches_instances are created. The calculation for open_files_limit does not account for the fact that there may be multiple instances.
I expect (but have not proven) problem could be avoided adjusting setting in config file to limit number of open_table_caches_instances or increasing open_files_limit. Currently neither of these are set in our config.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | need_feedback |
| Attachment | mysqld.error.log.truncated [ 46911 ] | |
| Attachment | my_eye.cnf [ 46912 ] |
| Labels | need_feedback |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Component/s | Configuration [ 13904 ] | |
| Component/s | Server [ 13907 ] | |
| Component/s | Storage Engine - MyISAM [ 10600 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] |
| Assignee | Sergei Golubchik [ serg ] |
| Support case ID | 27934 | |
| Labels | regression regression-10.2 | |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Sergei Golubchik [ serg ] | Sergey Vojtovich [ svoj ] |
| Labels | regression regression-10.2 | need_feedback regression regression-10.2 |
| Labels | need_feedback regression regression-10.2 | regression regression-10.2 |
| Assignee | Sergey Vojtovich [ svoj ] | Oleksandr Byelkin [ sanja ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.2.32 [ 24221 ] | |
| Fix Version/s | 10.3.23 [ 24222 ] | |
| Fix Version/s | 10.4.13 [ 24223 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 91300 ] | MariaDB v4 [ 155376 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 33808 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36125 ] |
| Zendesk Related Tickets | 190105 |