Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 76770 invoked from network); 31 Jul 2009 18:10:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 31 Jul 2009 18:10:37 -0000 Received: (qmail 52417 invoked by uid 500); 31 Jul 2009 18:10:37 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 52366 invoked by uid 500); 31 Jul 2009 18:10:37 -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 52358 invoked by uid 99); 31 Jul 2009 18:10:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Jul 2009 18:10:37 +0000 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, 31 Jul 2009 18:10:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 163DC234C046 for ; Fri, 31 Jul 2009 11:10:15 -0700 (PDT) Message-ID: <611954760.1249063815076.JavaMail.jira@brutus> Date: Fri, 31 Jul 2009 11:10:15 -0700 (PDT) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-4330) NullPointerException or assert failure when re-executing PreparedStatement after lock timeout MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org NullPointerException or assert failure when re-executing PreparedStatement after lock timeout --------------------------------------------------------------------------------------------- Key: DERBY-4330 URL: https://issues.apache.org/jira/browse/DERBY-4330 Project: Derby Issue Type: Bug Components: SQL Affects Versions: 10.5.1.1, 10.4.2.0, 10.4.1.3, 10.3.3.0, 10.3.2.1, 10.3.1.4, 10.5.2.0, 10.6.0.0 Reporter: Knut Anders Hatlen I came across a query that failed with a NullPointerException (insane jars) or an assert failure (sane jars) when a PreparedStatement was re-executed after a lock timeout. I'm able to reproduce this on 10.3.1.4 and later. 10.2.2.0 and earlier don't fail. Another fallout from DERBY-827? I've also seen other manifestations of the problem, apparently depending on the actual rows in the tables, including "No current connection" and "The heap container with container id Container(0, 1120) is closed". Stack trace for the assert failure: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED JoinResultSet already open at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:120) at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(JoinResultSet.java:144) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(ProjectRestrictResultSet.java:169) at org.apache.derby.impl.sql.execute.SortResultSet.openCore(SortResultSet.java:248) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(ProjectRestrictResultSet.java:169) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(BasicNoPutResultSetImpl.java:248) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1675) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1330) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.