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

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

ashif2 — Tue, 20 Mar 2018 07:37:24 GMT

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

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

ashif2 — Tue, 20 Mar 2018 11:37:53 GMT

@shong, @rhall

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

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

Anonymous — Tue, 20 Mar 2018 11:46:10 GMT

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

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

ashok5 — Wed, 02 May 2018 00:37:23 GMT

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