6 Replies Latest reply on Jul 31, 2014 9:04 AM by Sanjeev Gour

    How to enable USER command logging with COMMAND_LOG

    Sanjeev Gour Novice

      Hello-

       

      We are trying to figure out the time a user submitted query takes to execute using the COMMAND_LOG configuration. With the following configuration, we are only seeing the START DATA SRC COMMAND and END SRC COMMAND captured in the logs and not the START USER COMMAND and END USER COMMAND.

       

                  <size-rotating-file-handler name="FILE">

                      <formatter>

                          <pattern-formatter pattern="%d{dd MMM yyyy HH:mm:ss,SSS z} %-5p [%c] (%t) %s%E%n"/>

                      </formatter>

                      <file relative-to="jboss.server.log.dir" path="server.log"/>

                      <rotate-size value="50m"/>

                      <max-backup-index value="5"/>

                      <append value="true"/>

                  </size-rotating-file-handler>

       

                  <async-handler name="ASYNC">

                      <level name="DEBUG" />

                      <queue-length value="1024" />

                      <overflow-action value="block" />

                      <subhandlers>

                          <handler name="FILE" />

                      </subhandlers>

                  </async-handler>

       

                  <logger category="org.teiid.COMMAND_LOG">

                      <level name="DEBUG" />

                      <handlers>

                          <handler name="ASYNC" />

                      </handlers>

                  </logger>

      How can we get the USER COMMAND captured in the logs and how to link them with the SRC COMMAND (basically understand which all SRC COMMANDs belog the submitted USER COMMAND)?

       

      Thanks.