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

Add status variable that gets incremented if connection is aborted prior to authentication

Details

    Description

      If a connection is aborted prior to authentication, then the only status variable that gets incremented is Aborted_connects. The Aborted_connects status variable gets incremented for a lot of reasons though, so there is no status variable that can be used to determine how many connections have gotten aborted prior to authentication.

      You can reproduce this by doing something like using telnet to connect to the MariaDB port, and then killing the telnet process:

      $ telnet 127.0.0.1 3306
      Trying 127.0.0.1...
      Connected to 127.0.0.1.
      Escape character is '^]'.
      Y
      5.5.5-10.1.38-MariaDB@TcxOay_?▒MFWbhc931>#4mysql_native_password^CConnection closed by foreign host
      

      The only status variable that is incremented from this is Aborted_connects:

      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Aborted%';
      +------------------+-------+
      | Variable_name    | Value |
      +------------------+-------+
      | Aborted_clients  | 0     |
      | Aborted_connects | 1     |
      +------------------+-------+
      2 rows in set (0.00 sec)
       
      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Access_denied%';
      +----------------------+-------+
      | Variable_name        | Value |
      +----------------------+-------+
      | Access_denied_errors | 0     |
      +----------------------+-------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'Connection_errors%';
      +-----------------------------------+-------+
      | Variable_name                     | Value |
      +-----------------------------------+-------+
      | Connection_errors_accept          | 0     |
      | Connection_errors_internal        | 0     |
      | Connection_errors_max_connections | 0     |
      | Connection_errors_peer_address    | 0     |
      | Connection_errors_select          | 0     |
      | Connection_errors_tcpwrap         | 0     |
      +-----------------------------------+-------+
      6 rows in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            21d 6h 32m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            3h 7m 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            3d 23h 6m 1
            Oleksandr Byelkin made transition -
            In Progress In Review
            22h 22m 1
            Vladislav Vaintroub made transition -
            In Review Stalled
            5h 32m 1
            Oleksandr Byelkin made transition -
            Stalled Closed
            2h 1

            People

              sanja Oleksandr Byelkin
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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