My Talend Job hangs without producing an error. I have a mysql input and a MS SQl output. After several thousand rows, the job just hands (the rows are not increasing on the output). I have also tried outputting to a csv and get the same issue. I don't see any errors, if I leave it running for a while, it times out. I can't use trace debug because the issue occurs after about 50,000 rows. The trace debug runs very slow it would take a couple of hours to get to the point it hangs. Is there a different way to debug or to force Talend to display an error?
Hi Veer, Does this issue only repro on job 2? What does your job2 and job 3 work flow look like? Could you please indicate what's the build version you are using? Best regards Sabrina
Hi Sabrina,
Many Thanks for your quick response on it. I'm using Talend license Version 6.1.
I have Flow Of Job like this-
JOB1--> It takes Inputs Parameter via command line arguments and validate the Inputs and call job2 for further processing.
Job2--> It creates db Connection based on Input recevied from job2. In the subjob execution it calls to job3. On 'subjob OK' trigger, control Comes back to JOB2 once the execution of job3 completed.
Job3--> It is used to extract data from db and creates XML files in chunks.
In Job2 we merged These XML into single XML then validate the XML file with xsd. after xsd Validation get completed then we push XML file to desired place in the Server. Once all the Task done then we Close db Connection by tpostjob block.
Problem: 1. Once control Comes from job3 to Job2 then sometimes it just hang the Job in between for uncertain very hours.
We observed job's thread in stuck stage via unix command and we also observed db session for same. whcih does not move ahead at all.
2. This is another issue - In the other cases, we also observed old running talend Job threads which are not getting end, though the Job has completed it's desired Task.
Could you please help on this. Though We are closing the db Connections properly at the end of the Job or on Errors.
Regards,
Veer
