From issues-return-69730-archive-asf-public=cust-asf.ponee.io@commons.apache.org Thu Sep 20 03:18:04 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 200BD180677 for ; Thu, 20 Sep 2018 03:18:03 +0200 (CEST) Received: (qmail 84900 invoked by uid 500); 20 Sep 2018 01:18:03 -0000 Mailing-List: contact issues-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: issues@commons.apache.org Delivered-To: mailing list issues@commons.apache.org Received: (qmail 84840 invoked by uid 99); 20 Sep 2018 01:18:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Sep 2018 01:18:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 60529185CE1 for ; Thu, 20 Sep 2018 01:18:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id KlQ0Ib1Wl79C for ; Thu, 20 Sep 2018 01:18:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id D92F75F1D3 for ; Thu, 20 Sep 2018 01:18:00 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 61FCCE00E1 for ; Thu, 20 Sep 2018 01:18:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 0885B23F9E for ; Thu, 20 Sep 2018 01:18:00 +0000 (UTC) Date: Thu, 20 Sep 2018 01:18:00 +0000 (UTC) From: "guominzhi (JIRA)" To: issues@commons.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DBCP-524) Thread is blocked when i using dbcp 1.0 to connect mysql MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 guominzhi created DBCP-524: ------------------------------ Summary: 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 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((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() 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)