Graph aborted on hash join operation

CloverDX Platform
1

Hi,

I am trying to join two tables using HASH_JOIN component, and after a long but succeful initialization, I get this log (I have removed duplicate line from log4j) :

---------------------** Start of tracking Log for phase [0] **-------------------
Time: 22/12/05 13:47:52
Node Status Port #Records
---------------------------------------------------------------------------------
oeccp_STR ABORTED
Out:0 6674
obbud_MB ABORTED
Out:0 3
join_on_cgr ABORTED
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:474)
at org.jetel.graph.DirectEdge$EdgeRecordBufferPool.getFullBuffer(DirectEdge.java:352)
at org.jetel.graph.DirectEdge.readRecord(DirectEdge.java:119)
at org.jetel.graph.Edge.readRecord(Edge.java:238)
at org.jetel.graph.Node.readRecord(Node.java:556)
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:406)
at org.jetel.component.DBOutputTable.run(DBOutputTable.java:361)
In:0 3
In:1 6674
Out:0 0
obbud_oeccp FATAL_ERROR
In:0 0
---------------------------------** End of Log **--------------------------------

What is the meaning of this ?

Thanks,
Franck

2

Maybe my problem is related to this description : http://developer.berlios.de/forum/messa … g_id=21202
?

3

Hi,

I presume my problem is bound to short memory, but it is not clear…

Here is my graph :

<?xml version="1.0" encoding="UTF-8"?> select \* from obbud where butobbud = 'MB' and etsobbud = '04TFN' and moiobbud = '20051101' order by etsobbud, cgrobbud select \* from oeccp where chmoeccp = 'STR' and etsoeccp = '04TFN' order by etsoeccp, cgroeccp

Here is the data :

qualtfn=# SELECT count(*) from obbud qualtfn-# where butobbud = ‘MB’
qualtfn-# and etsobbud = ‘04TFN’
qualtfn-# and moiobbud = ‘20051101’;
count
-------
3972
(1 ligne)

qualtfn=# select count(*) from oeccp where chmoeccp = ‘STR’
qualtfn-# and etsoeccp = ‘04TFN’;
count
-------
37341
(1 ligne)

And here is the error log :

[WatchDog] !!! Fatal Error !!! - graph execution is aborting
INFO [WatchDog] - [WatchDog] !!! Fatal Error !!! - graph execution is aborting
Node HASH_JOIN0 finished with fatal error: null
FATAL [WatchDog] - Node HASH_JOIN0 finished with fatal error: null
[WatchDog] Interrupted node: oeccp_STR
INFO [WatchDog] - [WatchDog] Interrupted node: oeccp_STR
[WatchDog] Interrupted node: obbud_MB
INFO [WatchDog] - [WatchDog] Interrupted node: obbud_MB
[WatchDog] Interrupted node: HASH_JOIN0
INFO [WatchDog] - [WatchDog] Interrupted node: HASH_JOIN0
[WatchDog] Interrupted node: obbud_oeccp
INFO [WatchDog] - [WatchDog] Interrupted node: obbud_oeccp
---------------------** Start of tracking Log for phase [0] **-------------------
DEBUG [WatchDog] - ---------------------** Start of tracking Log for phase [0] **-------------------
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:474)
at org.jetel.graph.DirectEdge$EdgeRecordBufferPool.getFullBuffer(DirectEdge.java:352)
at org.jetel.graph.DirectEdge.readRecord(DirectEdge.java:119)
at org.jetel.graph.Edge.readRecord(Edge.java:238)
at org.jetel.graph.Node.readRecord(Node.java:556)
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:406)
at org.jetel.component.DBOutputTable.run(DBOutputTable.java:361)
Failed starting graph !
Time: 23/12/05 09:32:35
DEBUG [WatchDog] - Time: 23/12/05 09:32:35
Node Status Port #Records
DEBUG [WatchDog] - Node Status Port #Records
---------------------------------------------------------------------------------
DEBUG [WatchDog] - ---------------------------------------------------------------------------------
oeccp_STR OK
DEBUG [WatchDog] - oeccp_STR OK
Out:0 37341
DEBUG [WatchDog] - Out:0 37341
obbud_MB FATAL_ERROR
DEBUG [WatchDog] - obbud_MB FATAL_ERROR
Out:0 4
DEBUG [WatchDog] - Out:0 4
HASH_JOIN0 FATAL_ERROR
DEBUG [WatchDog] - HASH_JOIN0 FATAL_ERROR
In:0 4
DEBUG [WatchDog] - In:0 4
In:1 37341
DEBUG [WatchDog] - In:1 37341
Out:0 0
DEBUG [WatchDog] - Out:0 0
obbud_oeccp ABORTED
DEBUG [WatchDog] - obbud_oeccp ABORTED
In:0 0
DEBUG [WatchDog] - In:0 0
---------------------------------** End of Log **--------------------------------
DEBUG [WatchDog] - ---------------------------------** End of Log **--------------------------------

Does this help ?

Thanks
Franck

4

Hello,

I encounter the same problem with Merge Join component. Did you resolve your problem.

Thanks in advance

Alex

5

Hello !

There have been at least two releases of CloverGUI since the post - which one are you using ?

Could you send your failing graph (with some data sample) to david.pavlis centrum.cz

That could help investigate the problem.

David.

6

Hello !

Can you send me the graph layout (XML file) ? It is hard to guess just from the log. It basically means that thread/component waiting for data was suddenly interrupted - should not happen normally.

David.