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

Request: log warnings into SQL_ERROR_LOG

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: 10.0
        • Component/s: Plugin - SQL_ERROR_LOG
        • Labels:
          None
        • Sprint:
          10.0.20

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Task - A task that needs to be done. MDEV-5313 merge audit api changes from 5.5.34

                • Major - Major loss of function.
                • Open

                  Activity

                  Hide
                  Permalink
                  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…

                  Show
                  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…

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      f_razzoli Federico Razzoli
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:

                        Agile