You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/09/11 17:10:46 UTC
[jira] [Commented] (TRAFODION-1488) Master exec log files do not
have timestamps with the logged events
[ https://issues.apache.org/jira/browse/TRAFODION-1488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14740957#comment-14740957 ]
ASF GitHub Bot commented on TRAFODION-1488:
-------------------------------------------
GitHub user robertamarton opened a pull request:
https://github.com/apache/incubator-trafodion/pull/79
[TRAFODION-1488] Master exec log files missing timestamps
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/robertamarton/incubator-trafodion fixes
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/79.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #79
----
commit 324ab95e3ea11492b42b695feea79e1c73faf7b4
Author: Roberta Marton <ro...@esgyn.com>
Date: 2015-09-11T15:05:29Z
JIRA TRAFODION-1488
Fixed several issues related to logging:
log4cxx.trafodion.masterexe.config changes:
- The timestamp was not being reported in the log4cxx files
- Messages were being displayed twice
- Turned on debug logging for privilege manager events
SQL logging mechanism:
- Messages were not being displayed when expected
Regression test logging:
- changed TEST009 to log hive requests to a rundir log. This test is
failing during daily runs and this change will help isolate the issue.
----
> Master exec log files do not have timestamps with the logged events
> -------------------------------------------------------------------
>
> Key: TRAFODION-1488
> URL: https://issues.apache.org/jira/browse/TRAFODION-1488
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 2.0-incubating
> Reporter: Weishiun Tsai
> Assignee: Roberta Marton
>
> Unlike the rest of the log files, master exec log files do not have any timestamps associated with the event logging in the file. This makes it really difficult to correlate the events with the timeline. This will particularly make customer support difficult if we get a set of log files from customers but can’t re-establish the event timeline. Since this problem does not exist in other types of log files generated using the same mechanism into the same directory. It’s assumed that it’s not a log4cpp problem in general, but how the master exec uses it instead.
> To see this problem, issue a ‘cdl’ command on the shell prompt where your instance runs to go to the Trafodion log directory, and check the master exec log files with names like this: master_exec_*.log
> Here is an example of a UDR log file, which has the proper timestamps:
> [trafodion@nap001 logs]$ cat udr_0_19278.log
> 2015-08-17 16:22:52,679, INFO, SQL.UDR, Node Number: 0, CPU: 0, PIN: 37461, Process Name: $Z000VKB,,, A udrserver process is launched.
> 2015-08-17 16:22:52,679, INFO, SQL.UDR, Node Number: 0, CPU: 0, PIN: 37461, Process Name: $Z000VKB,,, A udrserver process is launched.
> 2015-08-17 16:24:19,579, INFO, SQL.UDR, Node Number: 0, CPU: 0, PIN: 38117, Process Name: $Z000W42,,, A udrserver process is launched.
> 2015-08-17 16:24:19,579, INFO, SQL.UDR, Node Number: 0, CPU: 0, PIN: 38117, Process Name: $Z000W42,,, A udrserver process is launched.
> Here is an example of a master exec log file. It does not have any timestamps with the events.
> [trafodion@nap001 logs]$ cat master_exec_0_14790.log
> Node Number: 0, CPU: 0, PIN: 14790, Process Name: $Z000C2K,,, An executor process is launched.
> Node Number: 0, CPU: 0, PIN: 14790, Process Name: $Z000C2K,,, An executor process is launched.
> Node Number: 0, CPU: 0, PIN: 14790, Process Name: $Z000C2K, SQLCODE: 4082, QID: MXID11000014790212306885622799967000000000206U3333300_15___SQLCI_DML_LAST__, *** ERROR[4082] Object TRAFODION.SEABASE.DOESNOTEXIST does not exist or is inaccessible.
> Node Number: 0, CPU: 0, PIN: 14790, Process Name: $Z000C2K, SQLCODE: 4082, QID: MXID11000014790212306885622799967000000000206U3333300_15___SQLCI_DML_LAST__, *** ERROR[4082] Object TRAFODION.SEABASE.DOESNOTEXIST does not exist or is inaccessible.
>
> There is another JIRA report describing incorrect timestamps at https://issues.apache.org/jira/browse/TRAFODION-912 [^] ‘LP Bug: 1412806 - log4cpp : incorrect timestamp in logs for SQL info’. But the 2 problems are different. This bug report is created to track this particular missing timestamp issue.
> ---------------------------------------------------------------------------------
> Here are the steps to see this problem:
> (1) issue cdl from the shell prompt where your instance runs.
> (2) Look at the master exec log files with names like master_exec_*.log
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)