[ https://issues.apache.org/jira/browse/TRAFODION-909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller updated TRAFODION-909:
----------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> LP Bug: 1412641 - log4cpp -- Node number in master*.log is always 0
> -------------------------------------------------------------------
>
> Key: TRAFODION-909
> URL: https://issues.apache.org/jira/browse/TRAFODION-909
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Gao, Rui-Xian
> Assignee: Sandhya Sundaresan
> Fix For: 2.1-incubating
>
>
> Node number in master*.log is always 0, tm.log has correct number.
> SQL>select [first 5] * from udf(event_log_reader('f')) where log_file_name='master_exec_0_7476.log';
> LOG_TS SEVERITY COMPONENT NODE_NUMBER CPU PIN PROCESS_NAME SQL_CODE QUERY_ID MESSAGE LOG_FILE_NODE LOG_FILE_NAME LOG_FILE_LINE PARSE_STATUS
> -------------------------- ---------- ------------------------ ----------- ----------- ----------- ------------ ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------
> 2015-01-19 04:29:53.454000 INFO SQL.ESP 0 2 24361 $Z020JW1 NULL NULL An ESP process is launched. 0 master_exec_0_7476.log 1
> 2015-01-19 04:29:53.462000 INFO SQL.ESP 0 2 24360 $Z020JW0 NULL NULL An ESP process is launched. 0 master_exec_0_7476.log 2
> 2015-01-19 04:29:53.452000 INFO SQL.ESP 0 5 31881 $Z050R0W NULL NULL An ESP process is launched. 0 master_exec_0_7476.log 1
> 2015-01-19 04:35:23.101000 INFO SQL.ESP 0 5 1892 $Z0501J2 NULL NULL An ESP process is launched. 0 master_exec_0_7476.log 2
> 2015-01-19 04:29:53.454000 INFO SQL.ESP 0 2 24361 $Z020JW1 NULL NULL An ESP process is launched. 0 master_exec_0_7476.log 1
> --- 5 row(s) selected.
> SQL>select [first 5] * from udf(event_log_reader('f')) where log_file_name like 'tm%';
> LOG_TS SEVERITY COMPONENT NODE_NUMBER CPU PIN PROCESS_NAME SQL_CODE QUERY_ID MESSAGE LOG_FILE_NODE LOG_FILE_NAME LOG_FILE_LINE PARSE_STATUS
> -------------------------- ---------- ------------------------ ----------- ----------- ----------- ------------ ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------
> 2015-01-19 03:42:19.803000 INFO TM 2 2 4052 $TM2 NULL NULL Message: DTM_TM_PROCESS_STARTUP 0 tm.log 1
> 2015-01-19 03:42:31.193000 INFO TM 2 2 4052 $TM2 NULL NULL Message: DTM_RECOV_SYSRECOV_COMPLETE 0 tm.log 2
> 2015-01-19 03:42:21.090000 INFO TM 5 5 10604 $TM5 NULL NULL Message: DTM_TM_PROCESS_STARTUP 0 tm.log 1
> 2015-01-19 03:42:31.216000 INFO TM 5 5 10604 $TM5 NULL NULL Message: DTM_RECOV_SYSRECOV_COMPLETE 0 tm.log 2
> 2015-01-19 03:42:19.803000 INFO TM 2 2 4052 $TM2 NULL NULL Message: DTM_TM_PROCESS_STARTUP 0 tm.log 1
> --- 5 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)