Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33368

Warnings about aborted connections vs. monitoring

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.11.4
    • None
    • None
    • None
    • Debian GNU/Linux 12 (bookworm)

    Description

      Our monitoring opens a TCP connection to the mariadb server to check if the server is available (without credentials). This happens multiple times a day and every time MariaDB logs the following message:

      [Warning] Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication)
      

      I'd like to get rid of these messages as they flood the log file and potentially obscure real problems. As a workaround, I configured rsyslog to simply drop those messages.

      Preferred solution would be to have an option in the MariaDB configuration to specify one or more hosts for which unauthenticated closed connections would not be logged.

      See also https://dba.stackexchange.com/questions/321719/ for another issue this might solve (host is blocked because of many connection errors).

      Attachments

        Activity

          People

            Unassigned Unassigned
            larsen Jon Doe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.