Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <2071950353.1119504070558.JavaMail.jira@ajax.apache.org>
Date: Thu, 23 Jun 2005 07:21:10 +0200 (CEST)
From: "A B (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-388) Intermittent failures when executing
 UPDATE trigger statements
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Intermittent failures when executing UPDATE trigger statements
--------------------------------------------------------------

         Key: DERBY-388
         URL: http://issues.apache.org/jira/browse/DERBY-388
     Project: Derby
        Type: Bug
    Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0    
    Reporter: A B
 Assigned to: A B 
     Fix For: 10.0.2.2


If I define an UPDATE trigger and then I repeatedly perform a table update that fires the trigger over many rows, I occasionally see intermittent failures of two kinds: 1) a null pointer exception, and/or 2) a syntax error.

The NPE stack trace is this:

The syntax error stack trace is this:

In both cases, it looks like the error happens when Derby decides (internally) to recompile the trigger-action statement in the middle of trigger processing--depending on the state of the underlying Statement object that performs the trigger action, the result will be an NPE or a syntax error.

I'm working on writing up a simplified reproduction and will post soon...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira