01:00:46,111 WARN [ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@34b10d34 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
01:00:46,102 WARN [ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@34b10d34 -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Can anyone help me on this. Whenever my data service not able to load data into MDM hub, I am seeing this log.
How to resolve this.
I already gone through the link https://help.talend.com/reader/vjjwM8idT46yr1MQn2TPQg/UneZaWGKeKKku6SzlgjVNA
but not convinced with the Solution and since I am facing this issue in PROD I am thinking for solution which could be acceptable by all
I'm sorry, I stay as far away from the MDM product as I can, so can't help with this one.
what is the underlying data base, we have faced this issues while doing bulk inserts/updates on parallel threads.
In our case DB is oracle. bitmap index has created deadlock issue we have used oracle trace files to identify the object that is causing deadlock.
Avoid doing bulk updates on parallel threads use only single thread. Please disable any additional DB indexes created manually.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.