1. Home
  2. Support
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
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)


 
This is a printer-friendly version of Article 331538 and may be out of date. For the latest version click CS331538