Talend DI tMysqlRow-"Lock wait timeout exceeded; try restarting transaction"

[Anonymous]

Hi all,

I have a job with multiple tMysqlRow components linked. tMysqlRow components contain update queries against a large data set.
The flow is like this :

tMysqlRow1  (Updates Table A)
|
OnSubjobOk
|
tMysqlRow2  (Updates Table A itself based on the update happened in tMysqlRow1)
|
OnSubjobOk
|
tMysqlRow3  (Updates Table B)

If the data set is too large, then tMysqlRow2 does not execute. A deadlock happens in MySQL and shows the message in the console that 'Lock wait timeout exceeded; try restarting transaction'.
Without executing update queries written in tMysqlRow2, it will go to tMysqlRow3. In that case, updates in tMysqlRow2 are missed. Seems Talend treats the Mysql Lock wait error as a message and so it won't stop the execution flow. While running Talend in the production server, we won't be knowing that the Lock wait error happened. In my job, tWarn component is available and at the end, tLogCatcher and tSendMail is available. But I am not getting this error in email. But in the case of some other errors like file is not found etc., I am getting the error in email.
Please help me to solve this issue.

Thanks in advance,

Sreedevi

[Anonymous]

All,

Any idea?

Please help.

Thanks in advance,

Sreedevi

[Anonymous]

Hi Sreedevi,

     I believe you have not commited some of the previous transaction and its going to a lock stage.

    Could you please check the details using the commands specified in the below link?

https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transa...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Thanks Nikhil. I will check it.