Article - CS331538
Unable to log in ThingWorx with error "APPARENT DEADLOCK" in ThingWorx
Modified: 05-Oct-2020
Applies To
- ThingWorx Platform 8.4
Description
- End user unable to log into ThingWorx
ApplicationLog shows
Thingworx Server Application...ON
Datastore database...INITIALIZED
Thingworx Server Application...ON
Datastore database...INITIALIZED
which indicate it is started but soon after
C3P0PooledConnectionPoolManager com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@2077b626 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks
- Thread dump shows BLOCKED thread on
"TWEventProcessor-13" tid=0xc8 in BLOCKEDBlocked: 148[-1ms], Waited: 67[-1ms]
User CPU: 12s110ms
- synchronizer <0x2a7761c2> (a java.util.concurrent.ThreadPoolExecutor$Worker)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:256)
- waiting on <0x7c6314e> (a com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache), held by TWEventProcessor-15
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinStatement(NewPooledConnection.java:326)
- locked <0x1e541a57> (a com.mchange.v2.c3p0.impl.NewPooledConnection)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1705)
at com.thingworx.persistence.common.sql.SqlEntryIterator.close(SqlEntryIterator.java:73)
at com.thingworx.persistence.postgres.dataprovider.PostgresDataTableDataProvider.queryEntries(PostgresDataTableDataProvider.java:138)
at com.thingworx.persistence.common.DataTableEngine.lambda$searchEntries$8(DataTableEngine.java:189)
at com.thingworx.persistence.common.DataTableEngine$$Lambda$152/806024100.get(Unknown Source)
at com.thingworx.persistence.TransactionFactory.createDataTransactionAndReturn(TransactionFactory.java:161)
at com.thingworx.persistence.common.BaseEngine.createTransactionAndReturn(BaseEngine.java:176)
at com.thingworx.persistence.common.DataTableEngine.searchEntries(DataTableEngine.java:186)
at com.thingworx.persistence.common.DataTableEngine.queryEntries(DataTableEngine.java:261)
at com.thingworx.datatables.DataTableThing.QueryDataTableEntries(DataTableThing.java:1150)
at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
User CPU: 12s110ms
- synchronizer <0x2a7761c2> (a java.util.concurrent.ThreadPoolExecutor$Worker)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:256)
- waiting on <0x7c6314e> (a com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache), held by TWEventProcessor-15
at com.mchange.v2.c3p0.impl.NewPooledConnection.checkinStatement(NewPooledConnection.java:326)
- locked <0x1e541a57> (a com.mchange.v2.c3p0.impl.NewPooledConnection)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.close(NewProxyPreparedStatement.java:1705)
at com.thingworx.persistence.common.sql.SqlEntryIterator.close(SqlEntryIterator.java:73)
at com.thingworx.persistence.postgres.dataprovider.PostgresDataTableDataProvider.queryEntries(PostgresDataTableDataProvider.java:138)
at com.thingworx.persistence.common.DataTableEngine.lambda$searchEntries$8(DataTableEngine.java:189)
at com.thingworx.persistence.common.DataTableEngine$$Lambda$152/806024100.get(Unknown Source)
at com.thingworx.persistence.TransactionFactory.createDataTransactionAndReturn(TransactionFactory.java:161)
at com.thingworx.persistence.common.BaseEngine.createTransactionAndReturn(BaseEngine.java:176)
at com.thingworx.persistence.common.DataTableEngine.searchEntries(DataTableEngine.java:186)
at com.thingworx.persistence.common.DataTableEngine.queryEntries(DataTableEngine.java:261)
at com.thingworx.datatables.DataTableThing.QueryDataTableEntries(DataTableThing.java:1150)
at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
This is a printer-friendly version of Article 331538 and may be out of date. For the latest version click CS331538