[
https://issues.apache.org/jira/browse/TRAFODION-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15974931#comment-15974931
]
ASF GitHub Bot commented on TRAFODION-2594:
-------------------------------------------
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1068#discussion_r112238169
--- Diff: core/sqf/conf/log4cxx.trafodion.masterexe.config ---
@@ -43,19 +38,10 @@ log4j.appender.mxoAppender.addPid=false
log4j.appender.mxoAppender.layout=org.apache.log4j.PatternLayout
log4j.appender.mxoAppender.layout.ConversionPattern=%d, %p, %c, %m%n
+log4j.additive.mxoAppender=false
+
#MXOSRVR
log4j.logger.MXOSRVR=ERROR, mxoAppender
# SQL
-# uncomment the following line if you want to enable debug logging
-#log4j.logger.SQL.EXE=DEBUG
-log4j.logger.SQL=INFO
-log4j.logger.SQL.COMP=ERROR
-log4j.logger.SQL.EXE.Memory=INFO
-log4j.logger.SQL.ESP=ERROR
-log4j.logger.SQL.PRIVMGR=INFO
-#
-log4j.logger.SQL.HDFS.JniTop=FATAL
-log4j.logger.SQL.HDFS.SeqFileReader=FATAL
-log4j.logger.SQL.HDFS.SeqFileWriter=FATAL
-log4j.logger.SQL.HBase=FATAL
+log4j.logger.SQL=INFO, mxoAppender
--- End diff --
Yes. We will change these sqmxevents to DEBUG or TRACE level as and when
we come across messages that are becoming dominating in the logs. INFO will be
the production level setting.
> Trafodion logs the same message twice in most of its log4j and log4cxx logs
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-2594
> URL: https://issues.apache.org/jira/browse/TRAFODION-2594
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
>
> For an example the SSMP process logs as follows
> 2016-12-11 01:33:11,994, INFO, SQL.SSMP, Node Number: 0, CPU: 0, PIN: 20666,
> Process Name: $ZSM000,,, An ssmp process is launched.
> 2016-12-11 01:33:11,994, INFO, SQL.SSMP, Node Number: 0, CPU: 0, PIN: 20666,
> Process Name: $ZSM000,,, An ssmp process is launched.
> 2016-12-12 02:55:02,141, INFO, SQL.SSMP, Node Number: 0, CPU: 0, PIN: 20666,
> Process Name: $ZSM000,,,Early reply to query started message from
> $Z000MQW:466 to attempt graceful cancel of query
> MXID11000027856212348271213304001000000000206U3333300_415_S1. Explain
> Sequence Number: 0 FILE: ../runtimestats/CancelBroker.cpp LINE: 149
> 2016-12-12 02:55:02,141, INFO, SQL.SSMP, Node Number: 0, CPU: 0, PIN: 20666,
> Process Name: $ZSM000,,,Early reply to query started message from
> $Z000MQW:466 to attempt graceful cancel of query
> MXID11000027856212348271213304001000000000206U3333300_415_S1. Explain
> Sequence Number: 0 FILE: ../runtimestats/CancelBroker.cpp LINE: 149
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
