[
https://issues.apache.org/jira/browse/DERBY-5421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13115124#comment-13115124
]
Myrna van Lunteren commented on DERBY-5421:
-------------------------------------------
I was didn't notice this last comment, and have run a couple of days with every
ps.close() in DbUtils.java framed by a if (ps != n ull)
ps.close()
(or ps2, if that's what it was).
This run showed a ton of 40001 errors DERBY-5428 - not sure if that's what was
going on before, but also further NullPointerExceptions like this:
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.tester.TesterObject.doSelectOpe
ration(TesterObject.java:239)
at org.apache.derbyTesting.system.nstest.tester.Tester1.startTesting(Tes
ter1.java:102)
at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:551)
TObj -->At this point - processing ResultSet during row data retrieval, exceptio
n thrown was : null
--> Isolation Level is TRANSACTION_READ_UNCOMMITTED, hence SHOULD NOT FAIL *****
**** doSelect in thread Tester1Thread 2 threw java.lang.NullPointerException
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.tester.TesterObject.doSelectOpe
ration(TesterObject.java:298)
at org.apache.derbyTesting.system.nstest.tester.Tester1.startTesting(Tes
ter1.java:102)
at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:551)
TObj -->At this point - doSelectOperation(), exception thrown was : null
java.lang.NullPointerException
at org.apache.derbyTesting.system.nstest.tester.TesterObject.doSelectOpe
ration(TesterObject.java:298)
at org.apache.derbyTesting.system.nstest.tester.Tester1.startTesting(Tes
ter1.java:102)
at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:551)
> 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
> Environment: Windows XP (embedded), SUSE Linux (10) (client/server),
> both with ibm 1.6 SR9 FP1
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
