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

Add command to log any string to error log e.g.: LOG_ERROR(' Start ALTER TABLE');

    XMLWordPrintable

Details

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

    Description

      I think it would be very welcome a function to have the server log an arbitrary (length limited) message in the error log.
      Useful for debugging from SPs, checking log rotation, checking if connected to the proper instance, etc

      It could be:

      LOG_ERROR(<any string>);
      SELECT COUNT(*) FROM t1 INTO @total_count;
      LOG_ERROR(@total_count);
      

      Timestamp generated by the server and category not sure, maybe 'user' ?

      2019-10-04  9:45:03 139884892247808 [User] 23456 
      

      Currently to achieve something similar is a real pain of workarounds.

      Attachments

        Activity

          People

            Unassigned Unassigned
            claudio.nanni Claudio Nanni
            Votes:
            2 Vote for this issue
            Watchers:
            5 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.