[
https://issues.apache.org/jira/browse/TRAFODION-907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-907.
------------------------------------
> LP Bug: 1412630 - Not all logs on all nodes are processed by event log reader
> UDF
> ---------------------------------------------------------------------------------
>
> Key: TRAFODION-907
> URL: https://issues.apache.org/jira/browse/TRAFODION-907
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Gao, Rui-Xian
> Assignee: Hans Zeller
> Priority: Blocker
> Fix For: 1.0 (pre-incubation)
>
>
> select * from udf(event_log_reader('f')) should return all records in logs on
> all nodes, however , seems logs on some nodes are not being processed.
> Tried on centos-mapr1.hpl.hp.com:37800
> SQL>select * from udf(event_log_reader('f')) where cpu=0 and
> log_file_name='master_exec_0_7476.log';
> --- 0 row(s) selected.
> SQL>select distinct cpu from udf(event_log_reader('f')) where
> log_file_name='master_exec_0_7476.log';
> CPU
> -----------
> 2
> 5
> 3
> 4
> --- 4 row(s) selected.
> The result didn’t get cpu 0 and cpu 1 , but we do have logs on
> those nodes.
> Check node1(centos-mapr2) –
> [trafodion@centos-mapr2 logs]$ ll master*.log
> -rw-r--r-- 1 trafodion trafodion 258 Jan 18 20:35
> master_exec_0_7476.log
> -rw-r--r-- 1 trafodion trafodion 258 Jan 18 20:30
> master_exec_0_7487.log
> -rw-r--r-- 1 trafodion trafodion 136 Jan 18 19:42
> master_exec_0_7851.log
> -rw-r--r-- 1 trafodion trafodion 5281 Jan 18 21:09
> master_exec_1_15592.log
> -rw-r--r-- 1 trafodion trafodion 7216 Jan 18 20:35
> master_exec_1_15605.log
> -rw-r--r-- 1 trafodion trafodion 259 Jan 18 21:25
> master_exec_3_2078.log
> -rw-r--r-- 1 trafodion trafodion 258 Jan 18 20:27
> master_exec_4_15691.log
> -rw-r--r-- 1 trafodion trafodion 130 Jan 18 20:03
> master_exec_5_11066.log
> Cat master_exec_0_7476.log –
> 2015-01-19 04:29:53,454, INFO, SQL.ESP, Node Number: 0, CPU: 1, PIN:
> 3309, Process Name: $Z0102PJ,,, An ESP process is launched.
> 2015-01-19 04:35:23,103, INFO, SQL.ESP, Node Number: 0, CPU: 1, PIN:
> 6333, Process Name: $Z01055Y,,, An ESP process is launched.
> 2015-01-19 05:31:34,150, INFO, SQL.ESP, Node Number: 0, CPU: 1, PIN: 30036,
> Process Name: $Z010PI6,,, An ESP process is launched.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
