commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Osipov (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DBCP-523) dbcp1.0版本连接mysql数据库时,经常出现线程阻塞的问题
Date Wed, 19 Sep 2018 19:03:00 GMT

     [ https://issues.apache.org/jira/browse/DBCP-523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Michael Osipov closed DBCP-523.
-------------------------------
    Resolution: Invalid

No English, no support.

> dbcp1.0版本连接mysql数据库时,经常出现线程阻塞的问题
> --------------------------------
>
>                 Key: DBCP-523
>                 URL: https://issues.apache.org/jira/browse/DBCP-523
>             Project: Commons DBCP
>          Issue Type: Bug
>    Affects Versions: 1.0
>            Reporter: guominzhi
>            Priority: Blocker
>
> dbcp1.0版本连接mysql数据库时,经常出现线程阻塞的问题,日志信息如下:
> "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
(v7.6.3#76005)

Mime
View raw message