cancel
Showing results for 
Search instead for 
Did you mean: 

APPARENT DEADLOCK!!! Creating emergency threads ...

yroffin
Champ in-the-making
Champ in-the-making
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().
~
3 REPLIES 3

derek
Star Contributor
Star Contributor
Hi,

Are you sure about the validity of
jdbc:mysql://localhost:3306/alfresco
?

Regards

marcus
Champ in-the-making
Champ in-the-making
The only time I've had this problem is when the user I'm trying to connect as didn't have access to connect from that host, but I was supplying the correct credentials.

yroffin
Champ in-the-making
Champ in-the-making
yes i'm sure, if a place a bad password i obtain

20:52:43,847 WARN  [v2.async.ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1f6c3af – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
20:52:43,871 WARN  [v2.async.ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1f6c3af – APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 1, num_active: 1; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f45e38 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f45e82, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f45e88]
20:52:55,692 WARN  [v2.resourcepool.BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f45e38 – Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'alfresco'@'gorkamorka.hd.free.fr' (using password: YES)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.