[TRAFODION-907] LP Bug: 1412630 - Not all logs on all nodes are processed by event log reader UDF

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.0 (pre-incubation)
• External issue URL: https://bugs.launchpad.net/bugs/1412630
• Assignee: Hans Zeller
• Reporter: Gao, Rui-Xian
• Created: 22/Jul/15 18:18
• Updated: 29/Aug/15 03:36
• Resolved: 29/Aug/15 03:36

Description

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-rr- 1 trafodion trafodion 258 Jan 18 20:35 master_exec_0_7476.log
rw-rr- 1 trafodion trafodion 258 Jan 18 20:30 master_exec_0_7487.log
rw-rr- 1 trafodion trafodion 136 Jan 18 19:42 master_exec_0_7851.log
rw-rr- 1 trafodion trafodion 5281 Jan 18 21:09 master_exec_1_15592.log
rw-rr- 1 trafodion trafodion 7216 Jan 18 20:35 master_exec_1_15605.log
rw-rr- 1 trafodion trafodion 259 Jan 18 21:25 master_exec_3_2078.log
rw-rr- 1 trafodion trafodion 258 Jan 18 20:27 master_exec_4_15691.log
rw-rr- 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.