Getting MDM error and results in database hung state and can anyone help on this?

Eight Stars

Getting MDM error and results in database hung state and can anyone help on this?

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
Active Tasks:
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@5ef0672c (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@7905aa65 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@62f60af5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
Pending Tasks:
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@7498d95
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@6dee34ef
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StatementCloseTask@31d56f4b
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask@337dbe7c
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@464d94d
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask@78f6507b
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@731df947
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@34d8df5c
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@a302c1f
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@60a0ac72
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5499a1ed
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3255f9ff
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2a8fee2a
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask@4f5d1d3a

Tags (1)
Eight Stars

Re: Getting MDM error and results in database hung state and can anyone help on this?

@shong@rhall_2_0

 

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 

 

 

 

Sixteen Stars

Re: Getting MDM error and results in database hung state and can anyone help on this?

I'm sorry, I stay as far away from the MDM product as I can, so can't help with this one.

Six Stars

Re: Getting MDM error and results in database hung state and can anyone help on this?

Hi Intri,

 

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.

 

Thanks

Ashok