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

SQL Error Log plug-in lacks Connection ID

Details

    Description

      SQL Error Log plug-in lacks Connection ID.

      All other MariaDB logs contain the Connection ID (sometimes also called thread_id) except the SQL Error Log plug-in. To track errors via the Connection ID it would be great having it as well there.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27087 Add thread ID and database / table, where the error occured to SQL error plugin

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is duplicated by

          Task - A task that needs to be done. MDEV-32632 Add more fields to the SQL Error plugin

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            oli Oli Sennhauser added a comment - - edited

            Probably this would do the job:
            96 logger_printf(logfile, "%04d-%02d-%02d %2d:%02d:%02d "

            • "%d "*
              97 "%s ERROR %d: %s : %s\n",
              98 t.tm_year + 1900, t.tm_mon + 1,
              99 t.tm_mday, t.tm_hour, t.tm_min, t.tm_sec,
              event->general_thread_id,
              100 event->general_user, event->general_error_code,
              101 event->general_command, event->general_query);
            oli Oli Sennhauser added a comment - - edited Probably this would do the job: 96 logger_printf(logfile, "%04d-%02d-%02d %2d:%02d:%02d " "%d "* 97 "%s ERROR %d: %s : %s\n", 98 t.tm_year + 1900, t.tm_mon + 1, 99 t.tm_mday, t.tm_hour, t.tm_min, t.tm_sec, event->general_thread_id, 100 event->general_user, event->general_error_code, 101 event->general_command, event->general_query);
            monty Michael Widenius added a comment - - edited

            Duplicate of MDEV-32632, which will be implemented shortly in 11.4

            monty Michael Widenius added a comment - - edited Duplicate of MDEV-32632 , which will be implemented shortly in 11.4

            People

              Unassigned Unassigned
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.