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

Add more warnings to be able to better diagnose network issues

Details

    Description

      The purpose if this task is to add more warnings, when log_warnings has a value of 4 or more, to get a better understanding of why connections are disconnected.

      When having global.log_warnings >=4, one will get the following errors log in case of communications issues:

      2024-03-02 16:17:40 8 [ERROR] mariadbd: Could not read packet: fd: 52 closed: 0 alarmed: 0 remain: 4 errno: 104 vio_errno: 1158 length: -1
      2024-03-02 16:18:09 7 [ERROR] mariadbd: Could not write packet: fd: 20 closed: 0 alarmed: 0 errno: 32 vio_errno: 1160 length: 182

      In addition, all communication errors are written to the general log if global.log_warnings >=4.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34473 Enhanced network logging information shown as error instead of warning

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34799 "Could not write packet" err message args off by 1

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-34168 Extend perror utility to print link to knowledge page

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius added a comment -

            Added more logging of network errors when using --log-warnings=4

            monty Michael Widenius added a comment - Added more logging of network errors when using --log-warnings=4
            monty Michael Widenius added a comment - - edited

            I have changed the error to a warning in the log

            How to interpret:
            errno 104 is the system error code
            ((/my/maria-10.6)) perror 104
            OS error code 104: Connection reset by peer

            This means the connection was aborted by the application/user.
            vio_errno: 1158 is our internal error code which stands for ER_NET_READ_ERROR "Got an error reading communication packets"
            I have created MDEV-34168 about extending perror to also print server error messages.

            monty Michael Widenius added a comment - - edited I have changed the error to a warning in the log How to interpret: errno 104 is the system error code ((/my/maria-10.6)) perror 104 OS error code 104: Connection reset by peer This means the connection was aborted by the application/user. vio_errno: 1158 is our internal error code which stands for ER_NET_READ_ERROR "Got an error reading communication packets" I have created MDEV-34168 about extending perror to also print server error messages.
            pandi.gurusamy Pandikrishnan Gurusamy added a comment -

            KB updated, explaining new warning messages
            https://mariadb.com/kb/en/e1158/

            pandi.gurusamy Pandikrishnan Gurusamy added a comment - KB updated, explaining new warning messages https://mariadb.com/kb/en/e1158/
            Richard Richard Stracke added a comment -

            Same for
            https://mariadb.com/kb/en/e1160/

            Richard Richard Stracke added a comment - Same for https://mariadb.com/kb/en/e1160/

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.