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

Request: log warnings into SQL_ERROR_LOG

Details

    • 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24, 10.0.28, 10.0.29

    Description

      Could we have a server variable to log warnings into the SQL_ERROR_LOG?
      It would be really useful, while debugging an application.

      I know I could change the SQL_MODE to convert many warnings into errors, but 1) not all warnings, 2) some queries would not work, which is not what I want.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-5313 Improving audit api

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          is duplicated by

          Task - A task that needs to be done. MDEV-7722 Spiral patch 024_mariadb-10.0.15.log_result_errors.diff

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik added a comment -

            The Audit API doesn't support it, unfortunately. The server doesn't report warnings to an audit plugin — and mainly because the Audit API doesn't have a concept of a "warning". If I change the server to report warnings to an audit plugin, the plugin will have no way of distinguishing a warning from an error.

            Extending the Audit API to support warnings is certainly possible, but it's not that easy. Both Oracle and we have already extended it, and differently. This is something we have to fix and at the same time I could add the support of warnings. But at the moment it's not exactly clear how to do that…

            serg Sergei Golubchik added a comment - The Audit API doesn't support it, unfortunately. The server doesn't report warnings to an audit plugin — and mainly because the Audit API doesn't have a concept of a "warning". If I change the server to report warnings to an audit plugin, the plugin will have no way of distinguishing a warning from an error. Extending the Audit API to support warnings is certainly possible, but it's not that easy. Both Oracle and we have already extended it, and differently. This is something we have to fix and at the same time I could add the support of warnings. But at the moment it's not exactly clear how to do that…
            monty Michael Widenius added a comment -

            Pushed into 10.11

            monty Michael Widenius added a comment - Pushed into 10.11

            People

              monty Michael Widenius
              f_razzoli Federico Razzoli
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.