How to enable USER command logging with COMMAND_LOG

[sanjeev.gour]

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.

[rareddy]

That seems odd, both DATA and USER commands use same logging context and same level. May be ASYNC handler did not flush by the time you are viewing. Try FILE handler and see you see the same. You can link them by request-id and execution-id

Ramesh..

[sanjeev.gour]

Tried with the FILE handler as well, didn't seem to work. I still get only the SRC commands logged.

[rareddy]

The only option I can think of is debugging the code and see what is happening. There code is in DQPCore.java in method "logMMCommand". BTW what is the server version you are using?

[sanjeev.gour]

Sure, will debug through those classes. We are testing this on  AS 7 and Teiid 8.1.

Thanks Ramesh.

[sanjeev.gour]

We get the proper log message, both USER COMMAND and the SRC COMMAND in Teiid 8.7 but they don't seem to work with Teiid 8.1. 8.1 only prints the SRC COMMAND not the USER COMMAND.

Do you think there is a possible bug in 8.1?

[sanjeev.gour]

Hi Ramesh-

How much performance hit we would get when we enable the COMMAND LOG? Is there a way to enable it for certain queries and not for all?

Thanks.