Databases
StackOverflow2013
Postsdbo
POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
    primarykey
    data
    text
    <p>I am using mysql with mybatis and I am greeting this error on our live server</p> <pre><code>com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@6538f8f2 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! </code></pre> <p>I don't understand why this error is coming is this because of my C3P0 setting? My C3P0 settings are like this </p> <p>----start Updated-----</p> <p>below is my spring-servlet.xml configuration</p> <p>I <strong>updated</strong> datasource bean as </p> <pre><code>&lt;bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" p:driverClass="com.mysql.jdbc.Driver" p:jdbcUrl="jdbc:mysql://localhost/jdb" p:user="root" p:password="root" p:acquireIncrement="10" p:idleConnectionTestPeriod="60" p:maxPoolSize="100" p:maxStatements="0" p:minPoolSize="10" p:initialPoolSize="10" p:statementCacheNumDeferredCloseThreads="1" /&gt; &lt;!-- Declare a transaction manager --&gt; &lt;bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" p:dataSource-ref="datasource" /&gt; &lt;bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"&gt; &lt;property name="dataSource" ref="datasource" /&gt; &lt;/bean&gt; &lt;!-- scan for mappers and will automatically scan the whole classpath for xmls --&gt; &lt;bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"&gt; &lt;property name="sqlSessionFactory" ref="sqlSessionFactory" /&gt; &lt;property name="basePackage" value="com.mycom.myproject.db.mybatis.dao" /&gt; &lt;/bean&gt; </code></pre> <p>and from my Dao class I call mapper method like </p> <pre><code> myDao.updateRecords() </code></pre> <p>This is my service class method</p> <pre><code>@Override public List&lt;UserDetailedBean&gt; selectAllUsersDetail(long groupId, List&lt;Long&gt; ids) { List&lt;UserDetailedBean&gt; usersDetailList = null; try { usersDetailList = userDao.selectAllUsersDetail(groupId, ids); } catch (Exception e) { e.printStackTrace(); } return usersDetailList; } </code></pre> <p>In Dao class I just inject the mapper. </p> <pre><code>@Resource private UserMapper userMapper; @Override public List&lt;UserDetailedBean&gt; selectAllUsersDetail(long groupId, List&lt;Long&gt; ids) { return userMapper.selectAllUsersDetail(groupId,ids); } </code></pre> <p>---end updated------</p> <p>please let me know if any other information is required.</p> <p>This is the complete stack trace</p> <pre><code>[ WARN] 2013-01-08 20:13:39 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@70497e11 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! [ WARN] 2013-01-08 20:13:39 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@70497e11 -- APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3 Active Threads: 3 Active Tasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2e81b8c5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0) com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@4689a55d (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2) com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@76c7a0d8 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1) Pending Tasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2c1101d4 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@108f1be6 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2370a188 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@377cf9e5 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@6dfa45d8 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@49ffa050 com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2d760a24 Pool thread stack traces: Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main] java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.read(SocketInputStream.java:150) java.net.SocketInputStream.read(SocketInputStream.java:121) com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114) com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161) com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189) com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2549) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3002) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2991) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3532) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557) com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4984) com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:51) com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4962) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62) com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310) com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999) com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main] java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.read(SocketInputStream.java:150) java.net.SocketInputStream.read(SocketInputStream.java:121) com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114) com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161) com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189) com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2549) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3002) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2991) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3532) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557) com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4984) com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:51) com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4962) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62) com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310) com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999) com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main] java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.read(SocketInputStream.java:150) java.net.SocketInputStream.read(SocketInputStream.java:121) com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114) com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161) com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189) com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2549) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3002) com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2991) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3532) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557) com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4984) com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:51) com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4962) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery(DefaultConnectionTester.java:185) com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:62) com.mchange.v2.c3p0.AbstractConnectionTester.activeCheckConnection(AbstractConnectionTester.java:67) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:368) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:310) com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1999) com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) </code></pre> <p><strong>---Updated----</strong></p> <p>when I added p:statementCacheNumDeferredCloseThreads="1" to datasouce bean I am getting the below error</p> <pre><code> Error creating bean with name 'sqlSessionFactory' defined in ServletContext resource [/WEB-INF/spring-servlet.xml]: Cannot resolve reference to bean 'datasource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datasource' defined in ServletContext resource [/WEB-INF/spring-servlet.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'statementCacheNumDeferredCloseThreads' of bean class [com.mchange.v2.c3p0.ComboPooledDataSource]: Bean property 'statementCacheNumDeferredCloseThreads' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter? </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTaky
    1. USuser965884
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. USuser965884
      1. VTBountyStart
    2. VO
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COPlease show for example updateRecords() dao method implementation.
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. USTaky
    2. COHi Taky, just update my question. please check and let me know if anything else is required. thanks
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. USuser965884
    3. COAlso please show how do you create mappers in your DAO. How many mappers in your application?
      singulars
      1. POAPPARENT DEADLOCK Creating emergency threads for unassigned pending tasks
      1. USTaky
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload