nerdexam
CompTIA

XK0-005 · Question #562

Users report that connections to a MariaDB service are being closed unexpectedly. A systems administrator troubleshoots the issue and finds the following message in /var/log/messages: Which of the…

The correct answer is B. The server is running out of file descriptors. The message in /var/log/messages indicates that the server is running out of file descriptors. A file descriptor is a non-negative integer identifier for an open file in Linux. Each process has a table of open file descriptors where a new entry is appended upon opening a new…

Troubleshooting

Question

Users report that connections to a MariaDB service are being closed unexpectedly. A systems administrator troubleshoots the issue and finds the following message in /var/log/messages:

Which of the following is causing the connection issue?

Options

  • AThe process mysqld is using too many semaphores.
  • BThe server is running out of file descriptors.
  • CSomething is starving the server resources.
  • DThe amount of RAM allocated to the server is too high.

How the community answered

(59 responses)
  • A
    7% (4)
  • B
    80% (47)
  • C
    3% (2)
  • D
    10% (6)

Explanation

The message in /var/log/messages indicates that the server is running out of file descriptors. A file descriptor is a non-negative integer identifier for an open file in Linux. Each process has a table of open file descriptors where a new entry is appended upon opening a new file. There is a limit on how many file descriptors a process can open at a time, which depends on the system configuration and the user privileges. If a process tries to open more files than the limit, it will fail with an error message like "Too many open files". This could cause connections to be closed unexpectedly or other problems with the application.

Topics

#MariaDB#File descriptors#System limits#Troubleshooting

Community Discussion

No community discussion yet for this question.

Full XK0-005 Practice