Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 51060 invoked from network); 18 Apr 2008 13:31:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Apr 2008 13:31:37 -0000 Received: (qmail 15941 invoked by uid 500); 18 Apr 2008 13:31:36 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 15856 invoked by uid 500); 18 Apr 2008 13:31:36 -0000 Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ibatis.apache.org Delivered-To: mailing list dev@ibatis.apache.org Received: (qmail 15795 invoked by uid 99); 18 Apr 2008 13:31:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Apr 2008 06:31:35 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Apr 2008 13:31:00 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 1DF1B234C0E1 for ; Fri, 18 Apr 2008 06:28:24 -0700 (PDT) Message-ID: <99639117.1208525304121.JavaMail.jira@brutus> Date: Fri, 18 Apr 2008 06:28:24 -0700 (PDT) From: "Clinton Begin (JIRA)" To: dev@ibatis.apache.org Subject: [jira] Closed: (IBATIS-502) Stuck threads and hang forever In-Reply-To: <518675391.1208496682830.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Clinton Begin closed IBATIS-502. -------------------------------- Resolution: Invalid You're likely not properly ending your database transactions in a fault tolerant way: try { ..startTransaction(); .... ..endTransaction(); } finally { ..closeTransaction(); } > Stuck threads and hang forever > ------------------------------ > > Key: IBATIS-502 > URL: https://issues.apache.org/jira/browse/IBATIS-502 > Project: iBatis for Java > Issue Type: Bug > Environment: Solaris 9, ibatis 2.3.0.677, Weblogic 8.1 SP3, Oracle 9i > Reporter: win hwang > Original Estimate: 24h > Remaining Estimate: 24h > > my page hang forever and I found the stuck threads all stop at the same place from thread dump. > I am at my final stage of testing before rolling out the apps. > Please help, thanks! > "ExecuteThread: '12' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x004ca408 nid=0x18 runnable [dd5fe000..dd5ffc28] > at java.sql.SQLException.setNextException(SQLException.java:149) > - waiting to lock <0xe3802990> (a java.sql.SQLWarning) > at java.sql.SQLWarning.setNextWarning(SQLWarning.java:107) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:752) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:734) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:787) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:806) > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:187) > at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:602) > at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:265) > - locked <0xe3802de0> (a oracle.jdbc.driver.T4CConnection) > at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:197) > - locked <0xe3802f50> (a oracle.jdbc.driver.OracleResultSetImpl) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:380) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:190) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > at com.ibatis.sqlmap.engine.mapping.statement.CachingStatement.executeQueryForList(CachingStatement.java:97) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) > at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) > at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95) > at com.csminc.dw.dao.CifBoDao.getData(CifBoDao.java:109) > at com.csminc.dw.dao.KpiMgr.getData(KpiMgr.java:48) > at com.csminc.dw.dao.KpiMgr.select(KpiMgr.java:74) > at jsp_servlet._bizdashboard.__qry_bk_bl_fcst_dtl._jspService(__qry_bk_bl_fcst_dtl.java:166) > at weblogic.servlet.jsp.JspBase.service(JspBase.java:33) > at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) > at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) > at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) > at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661) > at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) > "ExecuteThread: '17' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x006fd360 nid=0x1d runnable [dd0fe000..dd0ffc28] > at java.sql.SQLException.setNextException(SQLException.java:149) > - waiting to lock <0xe860b1b0> (a java.sql.SQLWarning) > at java.sql.SQLWarning.setNextWarning(SQLWarning.java:107) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:752) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:734) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:787) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:806) > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:187) > at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:602) > at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:265) > - locked <0xe860b288> (a oracle.jdbc.driver.T4CConnection) > at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:197) > - locked <0xe3802580> (a oracle.jdbc.driver.OracleResultSetImpl) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:380) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:190) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > at com.ibatis.sqlmap.engine.mapping.statement.CachingStatement.executeQueryForList(CachingStatement.java:97) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) > at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) > at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95) > at com.csminc.dw.dao.CifBoDao.getData(CifBoDao.java:109) > at com.csminc.dw.dao.KpiMgr.getData(KpiMgr.java:48) > at com.csminc.dw.dao.KpiMgr.select(KpiMgr.java:74) > at jsp_servlet._bizdashboard.__qry_bk_bl_fcst_dtl._jspService(__qry_bk_bl_fcst_dtl.java:166) > at weblogic.servlet.jsp.JspBase.service(JspBase.java:33) > at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) > at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) > at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) > at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661) > at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) > "ExecuteThread: '22' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x005a9ba8 nid=0x22 runnable [dcbfe000..dcbffc28] > at java.sql.SQLException.setNextException(SQLException.java:149) > - waiting to lock <0xe38003a0> (a java.sql.SQLWarning) > at java.sql.SQLWarning.setNextWarning(SQLWarning.java:107) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:752) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:734) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:787) > at oracle.jdbc.driver.DatabaseError.addSqlWarning(DatabaseError.java:806) > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:187) > at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:602) > at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:265) > - locked <0xe38007f0> (a oracle.jdbc.driver.T4CConnection) > at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:197) > - locked <0xe3800960> (a oracle.jdbc.driver.OracleResultSetImpl) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:380) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301) > at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:190) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) > at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > at com.ibatis.sqlmap.engine.mapping.statement.CachingStatement.executeQueryForList(CachingStatement.java:97) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) > at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) > at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) > at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95) > at com.csminc.dw.dao.CifBoDao.getData(CifBoDao.java:109) > at com.csminc.dw.dao.KpiMgr.getData(KpiMgr.java:48) > at com.csminc.dw.dao.KpiMgr.select(KpiMgr.java:74) > at jsp_servlet._bizdashboard.__qry_bk_bl_fcst_dtl._jspService(__qry_bk_bl_fcst_dtl.java:166) > at weblogic.servlet.jsp.JspBase.service(JspBase.java:33) > at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) > at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) > at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) > at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661) > at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.