Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Tue, 20 Sep 2011 04:04:09 +0000 (UTC)
From: "Myrna van Lunteren (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1265326886.44817.1316491449007.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (DERBY-5421) NullPointerException during
 system.nstest.utils.Dbutil.update_one_row
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

NullPointerException during system.nstest.utils.Dbutil.update_one_row
---------------------------------------------------------------------

                 Key: DERBY-5421
                 URL: https://issues.apache.org/jira/browse/DERBY-5421
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.8.2.1
            Reporter: Myrna van Lunteren


The nstest - both embedded (on Windows XP) and client/server configuration (on SUSE Linux 10) ran into a NullPointerException during the call to update_one_row.
The test only ran for 5 days, vs. 10.8.1.2 8 days, and I've never seen this error before:

sample (console) output:
total memory: 20962816 free: 3036264 Wed Sep 14 00:28:00 PDT 2011
TObj -->NULL error message detected
TObj -->Here is the NULL exception - java.lang.NullPointerException
TObj -->Stack trace of the NULL exception - java.lang.NullPointerException
        at org.apache.derbyTesting.system.nstest.utils.DbUtil.update_one_row(DbUtil.java:275)
        at org.apache.derbyTesting.system.nstest.tester.TesterObject.doIUDOperation(TesterObject.java:162)
        at org.apache.derbyTesting.system.nstest.tester.Tester2.startTesting(Tester2.java:109)
        at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:555)
TObj -->At this point - executing update_one_row, exception thrown was : null
TObj -->NULL error message detected
TObj -->Here is the NULL exception - java.lang.NullPointerException
TObj -->Stack trace of the NULL exception - java.lang.NullPointerException
        at org.apache.derbyTesting.system.nstest.utils.DbUtil.update_one_row(DbUtil.java:275)
        at org.apache.derbyTesting.system.nstest.tester.TesterObject.doIUDOperation(TesterObject.java:162)
        at org.apache.derbyTesting.system.nstest.tester.Tester1.startTesting(Tester1.java:118)
        at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:551)
TObj -->At this point - executing update_one_row, exception thrown was : null
 
Looking at the source of nstest.utils.DbUtil.update_one_row it's calling ps2.close():

----------------------------
....
		column = colnames[ind % NUMTYPES]; // randomly gets one of the columns
		// of the table
		
		try {
			
			ps2 = conn.prepareStatement(" update nstesttab set " + column
					+ " = ? " + " where serialkey = " + skey);
			
		} catch (Exception e) {
			ps2.close();
			printException(
					"closing update prepared stmt in dbUtil.update_one_row() ",
					e);
			return rowsUpdated;
		}
....
----------------------------

At first glance, this seems a test issue, but I think it possible the test is hiding something more interesting, so I'm not marking this as component 'test'.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira