[
https://issues.apache.org/jira/browse/DBCP-524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621418#comment-16621418
]
Gary D. Gregory edited comment on DBCP-524 at 10/26/21, 9:06 PM:
-----------------------------------------------------------------
Please try version 2.9.0. You'll have to update package imports and possibly
some source if you are still on 1.x.
was (Author: garydgregory):
Please try with version 2.5.0.
> Thread is blocked when i using dbcp 1.0 to connect mysql
> --------------------------------------------------------
>
> Key: DBCP-524
> URL: https://issues.apache.org/jira/browse/DBCP-524
> Project: Commons DBCP
> Issue Type: Bug
> Affects Versions: 1.0
> Reporter: guominzhi
> Priority: Blocker
>
> when I use dbcp 1.0 to connect to mysql, one thread is always blocked by
> other thread.
> The log is blow:
> "schedulerFactoryBean_Worker-8" J9VMThread:0x0000000004047300,
> j9thread_t:0x00007F66B7232200, java/lang/Thread:0x00000007E90CBA48, state:R,
> prio=5
> 3XMJAVALTHREAD (java/lang/Thread getId:0x8A, isDaemon:false)
> 3XMTHREADINFO1 (native thread ID:0x2452, native priority:0x5, native
> policy:UNKNOWN)
> 3XMTHREADINFO2 (native stack address range from:0x00007F66B6FE9000,
> to:0x00007F66B702A000, size:0x41000)
> 3XMHEAPALLOC Heap bytes allocated since last GC cycle=0 (0x0)
> 3XMTHREADINFO3 Java callstack:
> 4XESTACKTRACE at java/net/SocketInputStream.socketRead0(Native Method)
> 4XESTACKTRACE at
> java/net/SocketInputStream.read(SocketInputStream.java:140(Compiled Code))
> 4XESTACKTRACE at com/mysql/jdbc/MysqlIO.readFully(MysqlIO.java:1391(Compiled
> Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/MysqlIO.reuseAndReadPacket(MysqlIO.java:1538(Compiled Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/MysqlIO.checkErrorPacket(MysqlIO.java:1929(Compiled Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/MysqlIO.sendCommand(MysqlIO.java:1167(Compiled Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/MysqlIO.sqlQueryDirect(MysqlIO.java:1278(Compiled Code))
> 4XESTACKTRACE at com/mysql/jdbc/MysqlIO.sqlQuery(MysqlIO.java:1224(Compiled
> Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/Connection.execSQL(Connection.java:2248(Compiled Code))
> 5XESTACKTRACE (entered lock: java/lang/Object@0x00000007EB01D990, entry
> count: 2)
> 4XESTACKTRACE at
> com/mysql/jdbc/Connection.execSQL(Connection.java:2196(Compiled Code))
> 4XESTACKTRACE at
> com/mysql/jdbc/Statement.executeQuery(Statement.java:1163(Compiled Code))
> 5XESTACKTRACE (entered lock: java/lang/Object@0x00000007EB01D990, entry
> count: 1)
> 5XESTACKTRACE (entered lock: com/mysql/jdbc/Statement@0x00000007EA1168C0,
> entry count: 1)
> 4XESTACKTRACE at
> org/apache/commons/dbcp/DelegatingStatement.executeQuery(DelegatingStatement.java:162(Compiled
> Code))
> 4XESTACKTRACE at
> org/apache/commons/dbcp/PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:221(Compiled
> Code))
> 5XESTACKTRACE (entered lock:
> org/apache/commons/dbcp/PoolableConnectionFactory@0x00000007EB01D3F8, entry
> count: 1)
> 4XESTACKTRACE at
> org/apache/commons/pool/impl/GenericObjectPool.addObjectToPool(GenericObjectPool.java:1415(Compiled
> Code))
> 4XESTACKTRACE at
> org/apache/commons/pool/impl/GenericObjectPool.returnObject(GenericObjectPool.java:1381(Compiled
> Code))
> 4XESTACKTRACE at
> org/apache/commons/dbcp/AbandonedObjectPool.returnObject(AbandonedObjectPool.java:140(Compiled
> Code))
> 5XESTACKTRACE (entered lock:
> org/apache/commons/dbcp/AbandonedObjectPool@0x00000007EB01D368, entry count:
> 1)
> 4XESTACKTRACE at
> org/apache/commons/dbcp/PoolableConnection.close(PoolableConnection.java:110(Compiled
> Code))
> 4XESTACKTRACE at
> com/sms/baseclasses/BaseJdbcDAO.query(BaseJdbcDAO.java:49(Compiled Code))
> 4XESTACKTRACE at
> com/sms/service/GatewayJdbcService.QueryBySqlEx(GatewayJdbcService.java:124(Compiled
> Code))
> 4XESTACKTRACE at
> com/sms/gateway/SmsChanneMASlImpl.receiveRPTs(SmsChanneMASlImpl.java:114(Compiled
> Code))
> 4XESTACKTRACE at
> com/sms/service/SmsReceiveSentReportService.receiveReports(SmsReceiveSentReportService.java:54(Compiled
> Code))
> 4XESTACKTRACE at
> com/sms/service/SmsReceiveSentReportService$$FastClassByCGLIB$$5201ea4.invoke(<generated>(Compiled
> Code))
> 4XESTACKTRACE at
> net/sf/cglib/proxy/MethodProxy.invoke(MethodProxy.java:149(Compiled Code))
> 4XESTACKTRACE at
> org/springframework/aop/framework/Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/aop/framework/ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/transaction/interceptor/TransactionInterceptor.invoke(TransactionInterceptor.java:106(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/aop/framework/ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/aop/framework/Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635(Compiled
> Code))
> 4XESTACKTRACE at
> com/sms/service/SmsReceiveSentReportService$$EnhancerByCGLIB$$c660d003.receiveReports(<generated>)
> 4XESTACKTRACE at
> com/sms/job/SmsReceiveSentReportJob.execute(SmsReceiveSentReportJob.java:70(Compiled
> Code))
> 4XESTACKTRACE at sun/reflect/GeneratedMethodAccessor258.invoke(Bytecode
> PC:36(Compiled Code))
> 4XESTACKTRACE at
> sun/reflect/DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37(Compiled
> Code))
> 4XESTACKTRACE at java/lang/reflect/Method.invoke(Method.java:611(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/util/MethodInvoker.invoke(MethodInvoker.java:276(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/scheduling/quartz/MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260(Compiled
> Code))
> 4XESTACKTRACE at
> org/springframework/scheduling/quartz/QuartzJobBean.execute(QuartzJobBean.java:86(Compiled
> Code))
> 4XESTACKTRACE at
> org/quartz/core/JobRunShell.run(JobRunShell.java:202(Compiled Code))
> 4XESTACKTRACE at
> org/quartz/simpl/SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529(Compiled
> Code))
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
