AnsweredAssumed Answered

APPARENT DEADLOCK!!! Creating emergency threads ...

Question asked by yroffin on Sep 7, 2006
Latest reply on Sep 8, 2006 by yroffin
hi, while using open source alfresco version with mysql 5.x i obtain DEADLOCK

[root@gorkamorka logs]# mysql –version
mysql  Ver 14.12 Distrib 5.0.21, for redhat-linux-gnu (i386) using readline 5.0

jrockit and sun jvm give the same result, and i'm blocked.

someone can help me ?

00:24:28,228 INFO  [hibernate.connection.ConnectionProviderFactory] Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
00:24:29,775 INFO  [v2.c3p0.PoolBackedDataSource] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource@1e126b5[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, allUsers -> [], autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1e0a411, description -> null, driverClass -> org.gjt.mm.mysql.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1e126b5, idleConnectionTestPeriod -> -1, initialPoolSize -> 1, jdbcUrl -> jdbc:mysql://localhost:3306/alfresco, maxIdleTime -> 0, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 1, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
00:24:48,655 WARN  [v2.async.ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@20ac3af – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
00:24:48,679 WARN  [v2.async.ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@20ac3af – APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 1, num_active: 1; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2085d38 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2085d82, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2085d88]
00:25:59,594 WARN  [v2.async.ThreadPoolAsynchronousRunner] Task com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2085d38 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
~

Outcomes