Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4385

Allow option to log maxscale log entries into one line rather than spanning multiple lines.

    XMLWordPrintable

Details

    • MXS-SPRINT-184

    Description

      Some MaxScale log entries span more than one line which makes it difficult for a customer's datadog application to parse and ingest. It would be nice to have a configurable option to allow maxscale to write single row log entries rather than across multiple lines. This appears to occur when maxscale is logging a query. It may be like this because maxscale is preserving the newlines as submitted by the application, but it would still be nice to have an option to put it all in one line.

      Here's a sample log entry with the table and column names obfuscated but the line breaks intact:

      2022-11-01 15:30:29   info   : (850) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 491, type: QUERY_TYPE_READ, stmt: SELECT col1,col2,col3,col4,
      col5, col6, col7,col8,col9,
      col10,col11, col12, col13,
      col14 FROM tbl WHERE col1 IN (12345)
      AND (col2 !=0 OR col3 !=0 OR col4 !=0 OR
      col5 !=0 OR col6 !=0 OR col7 !=0
       OR col8 !=0)
      

      Customer is currently running with MaxScale 6.4.1.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            henry.hwang@mariadb.com Henry Hwang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.