[jira] [Updated] (TRAFODION-912) LP Bug: 1412806 - log4cpp : incorrect timestamp in logs for SQL info

2018-03-06 Thread Suresh Subbiah (JIRA) 

 [ 
https://issues.apache.org/jira/browse/TRAFODION-912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Suresh Subbiah updated TRAFODION-912:
-
Fix Version/s: (was: 2.2.0)

> LP Bug: 1412806 - log4cpp : incorrect timestamp in logs for SQL info
> 
>
> Key: TRAFODION-912
> URL: https://issues.apache.org/jira/browse/TRAFODION-912
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-exe
>Reporter: Gao, Rui-Xian
>Assignee: Sandhya Sundaresan
>Priority: Major
>
> There are messages which have LOG_TS later than current timestamp logged into 
> the log file.
> current time is '2015-01-20 05:43:05', but there are messges have '2015-01-20 
> 13:16:16' in the log, only for SQL INFO.
> [trafodion@centos-mapr1 logs]$ date
> Tue Jan 20 05:43:05 PST 2015
> SQL>select * from udf(event_log_reader('f')) where log_ts > 
> timestamp'2015-01-20 06:00:00.00' order by 1;
> LOG_TS SEVERITY   COMPONENTNODE_NUMBER 
> CPU PIN PROCESS_NAME SQL_CODEQUERY_ID 
>   
>   MESSAGE 
>  
> LOG_FILE_NODE LOG_FILE_NAME   
>  
> LOG_FILE_LINE PARSE_STATUS
> -- --  --- 
> --- ---  --- 
> 
>  
> 
>  - 
> 
>  - 
> 2015-01-20 06:57:16.974000 INFO   SQL.ESP0
>5   26257 $Z050LF7NULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:16.974000 INFO   SQL.ESP0
>5   26257 $Z050LF7NULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>

[jira] [Updated] (TRAFODION-912) LP Bug: 1412806 - log4cpp : incorrect timestamp in logs for SQL info

2018-03-04 Thread Pierre Smits (JIRA) 

 [ 
https://issues.apache.org/jira/browse/TRAFODION-912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated TRAFODION-912:
---
Fix Version/s: (was: 2.1-incubating)
   2.2.0

> LP Bug: 1412806 - log4cpp : incorrect timestamp in logs for SQL info
> 
>
> Key: TRAFODION-912
> URL: https://issues.apache.org/jira/browse/TRAFODION-912
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-exe
>Reporter: Gao, Rui-Xian
>Assignee: Sandhya Sundaresan
>Priority: Major
> Fix For: 2.2.0
>
>
> There are messages which have LOG_TS later than current timestamp logged into 
> the log file.
> current time is '2015-01-20 05:43:05', but there are messges have '2015-01-20 
> 13:16:16' in the log, only for SQL INFO.
> [trafodion@centos-mapr1 logs]$ date
> Tue Jan 20 05:43:05 PST 2015
> SQL>select * from udf(event_log_reader('f')) where log_ts > 
> timestamp'2015-01-20 06:00:00.00' order by 1;
> LOG_TS SEVERITY   COMPONENTNODE_NUMBER 
> CPU PIN PROCESS_NAME SQL_CODEQUERY_ID 
>   
>   MESSAGE 
>  
> LOG_FILE_NODE LOG_FILE_NAME   
>  
> LOG_FILE_LINE PARSE_STATUS
> -- --  --- 
> --- ---  --- 
> 
>  
> 
>  - 
> 
>  - 
> 2015-01-20 06:57:16.974000 INFO   SQL.ESP0
>5   26257 $Z050LF7NULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:16.974000 INFO   SQL.ESP0
>5   26257 $Z050LF7NULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log  
>  1
> 2015-01-20 06:57:17.011000 INFO   SQL.ESP0
>31982 $Z0301LMNULL NULL
>   
>An ESP process is launched.
>   
> 0 master_exec_1_3719.log