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
            f_razzoli Federico Razzoli created issue -
            f_razzoli Federico Razzoli made changes -
            Field Original Value New Value
            Description Could we have a server variables to log warnings in 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.             		Could we have a server variable to log warnings in 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.
            f_razzoli Federico Razzoli made changes -
            Description Could we have a server variable to log warnings in 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.             		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.
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0 [ 16000 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            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…
            serg Sergei Golubchik made changes -
            holyfoot Alexey Botchkov made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 59087 ] MariaDB v3 [ 64651 ]
            serg Sergei Golubchik made changes -
            Sprint 10.0.20 [ 5 ]
            serg Sergei Golubchik made changes -
            Sprint 10.0.20 [ 5 ] 10.0.20, 10.1.6-1 [ 5, 6 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Sprint 10.0.20, 10.1.6-1 [ 5, 6 ] 10.0.20 [ 5 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20 [ 5 ] 10.0.20, 10.0.22 [ 5, 17 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22 [ 5, 17 ] 10.0.20, 10.0.22, 10.1.9 [ 5, 17, 18 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            holyfoot Alexey Botchkov made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-1 [ 5, 17, 18 ] 10.0.20, 10.0.22, 10.1.9-2 [ 5, 17, 19 ]
            holyfoot Alexey Botchkov made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2 [ 5, 17, 19 ] 10.0.20, 10.0.22, 10.1.9-2, 10.1.9-3 [ 5, 17, 19, 20 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2, 10.1.9-3 [ 5, 17, 19, 20 ] 10.0.20, 10.0.22, 10.1.9-2 [ 5, 17, 19 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2 [ 5, 17, 19 ] 10.0.20, 10.0.22, 10.1.9-2, 10.0.23-1 [ 5, 17, 19, 23 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2, 10.0.23 [ 5, 17, 19, 23 ] 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24-0 [ 5, 17, 19, 23, 35 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24 [ 5, 17, 19, 23, 35 ] 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24, 10.0.28 [ 5, 17, 19, 23, 35, 107 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24, 10.0.28 [ 5, 17, 19, 23, 35, 107 ] 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24, 10.0.28, 10.0.29 [ 5, 17, 19, 23, 35, 107, 128 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            monty Michael Widenius made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64651 ] MariaDB v4 [ 130298 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0 [ 16000 ]
            monty Michael Widenius made changes -
            Assignee Alexey Botchkov [ holyfoot ] Michael Widenius [ monty ]
            monty Michael Widenius made changes -
            Fix Version/s 10.11 [ 27614 ]
            monty Michael Widenius made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            monty Michael Widenius added a comment -

            Pushed into 10.11

            monty Michael Widenius added a comment - Pushed into 10.11
            monty Michael Widenius made changes -
            issue.field.resolutiondate 2023-05-24 12:01:53.0 2023-05-24 12:01:53.645
            monty Michael Widenius made changes -
            Fix Version/s 10.11.4 [ 28918 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.11.5 [ 29019 ]
            Fix Version/s 10.11.4 [ 28918 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.3.1 [ 29416 ]
            Fix Version/s 11.2.1 [ 29034 ]
            Fix Version/s 11.1.2 [ 28921 ]
            Fix Version/s 11.0.3 [ 28920 ]

            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.