Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 25741 invoked from network); 8 Mar 2008 23:07:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Mar 2008 23:07:18 -0000 Received: (qmail 66575 invoked by uid 500); 8 Mar 2008 23:07:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 66532 invoked by uid 500); 8 Mar 2008 23:07:09 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 66480 invoked by uid 99); 8 Mar 2008 23:07:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Mar 2008 15:07:09 -0800 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; Sat, 08 Mar 2008 23:06:29 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5FBAE234C094 for ; Sat, 8 Mar 2008 15:05:49 -0800 (PST) Message-ID: <686409539.1205017549391.JavaMail.jira@brutus> Date: Sat, 8 Mar 2008 15:05:49 -0800 (PST) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3493) stress.multi times out waiting on testers with blocked testers waiting on the same statement In-Reply-To: <1511314564.1204650581304.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/DERBY-3493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-3493: -------------------------------------- Derby Info: [Patch Available] > stress.multi times out waiting on testers with blocked testers waiting on the same statement > -------------------------------------------------------------------------------------------- > > Key: DERBY-3493 > URL: https://issues.apache.org/jira/browse/DERBY-3493 > Project: Derby > Issue Type: Bug > Components: Regression Test Failure, SQL, Test > Affects Versions: 10.4.0.0 > Environment: IBM 1.5 Linux > Reporter: Kathey Marsden > Assignee: Knut Anders Hatlen > Attachments: d3493-1a.diff, d3493-1b.diff, threaddump-1204806990660.tdump > > > The diff is: > 7 del > < ...running last checks via final.sql > 7 add > > ...timed out trying to kill all testers, > > skipping last scripts (if any). NOTE: the > > likely cause of the problem killing testers is > > probably not enough VM memory OR test cases that > > run for very long periods of time (so testers do not > > have a chance to notice stop() requests > Test Failed. > The testers that are stuck are stuck on the same statement e.g. > -- > update main2 set y = 'zzz' where x = 5; > ERROR 08000: Connection closed by unknown interrupt. > ERROR XJ001: Java exception: ': java.lang.InterruptedException'. > The interupt exception shows: > java.lang.InterruptedException > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:199) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:195) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConn > ctionContext.java:768) > at > org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606) > at > org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555) > at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329) > at > org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:508) > at > org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:350) > The code at line 195 of GenericStatement shows: > .... > try { > preparedStmt.wait(); > } catch (InterruptedException ie) { > throw StandardException.interrupt(ie); > } > My first guess is that this is perhaps some type of Statement cache > concurrency bug, but perhaps > I am reading it wrong. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.