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

Include Error Code in all error log entries

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      I would like to suggest an improvement to the overall system to include an easily identifiable error code with all errors written to the error log, this currently seems to have a random feel to it.
      Oracle database has the ORA- errors
      SQL Server starts each line with Msg followed by a number and other information.

      This would make identifying errors easier allowing errors to easily found in logs and if fed to the likes of Splunk allow other analysis to be done looking for incidents and repeat incidents in some cases.
      The storage engines create a problem non existent in other databases which will need a resolution over the longer term either groupings of errors under the broader mariadb logging it the plugin vendors adopting the error logging style down into their code bases

      This I don't see in the initial activity as a difficult task having only to make a suitable prefix and and the prefixed code into the text in mysqld_ername.h file in the text of every error code. I realise that this is not the solution but com_err needs to be altered to accommodate this change. That is a little more difficult.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Meerkat63 Peter McLarty
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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