OnlineCompressTest failed reporting NullPointerException, actual problem in derby.log is a page checksum error.

• Key: DERBY-2677
• Type: Bug
• Status: Resolved
• Resolution: Duplicate
• Priority: Major
• Assignee: Unassigned
• Reporter: Mike Matrigali
• Component/s: Store
• Affects Version/s: 10.3.1.4

Environment

------------------ Java Information ------------------
Java Version: 1.4.2
Java Vendor: IBM Corporation
Java home: c:\jartest\ibm142\jre
Java classpath: c:/jartest/classes/derby.jar;c:/jartest/classes/derbyLocale_zh_TW.jar;c:/jartest/classes/derbyLocale_zh_CN.jar;c:/jartest/classes/derbyLocale_ru.jar;c:/jartest/classes/derbyLocale_pt_BR.jar;c:/jartest/classes/derbyLocale_pl.jar;c:/jartest/classes/derbyLocale_ko_KR.jar;c:/jartest/classes/derbyLocale_ja_JP.jar;c:/jartest/classes/derbyLocale_it.jar;c:/jartest/classes/derbyLocale_hu.jar;c:/jartest/classes/derbyLocale_fr.jar;c:/jartest/classes/derbyLocale_es.jar;c:/jartest/classes/derbyLocale_de_DE.jar;c:/jartest/classes/derbyLocale_cs.jar;c:/jartest/tools/java/junit.jar;c:/jartest/classes/derbytools.jar;c:/jartest/classes/derbynet.jar;c:/jartest/classes/derbyclient.jar;;c:/jartest/classes/derbyrun.jar;c:/jartest/classes/derbyTesting.jar;c:/jartest/classes/maps.jar;c:/jartest/classes/functionTests.jar;c:/jartest/classes/csext.jar;c:/jartest/tools/java/junit.jar;c:/jartest/tools/java/jndi/fscontext.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: cloudtest
Java user home: C:\Documents and Settings\cloudtest
Java user dir: C:\jartest\JarResults.2007-05-18\ibm142_derbyall
java.specification.name: Java Platform API Specification
java.specification.version: 1.4

Description

The OnlineCompressTest failed in the following nightly test run:
http://people.apache.org/~fuzzylogic/derby_test_results/main/testlog/ibm142/539664-derbyall_diff.txt

The diff reported is:
*** Start: OnlineCompressTest jdk1.4.2 storeall:storemore 2007-05-18 19:53:53 ***
83 del
< Executing test: delete all rows case succeeded.
84 del
< Executing test: end simple deleteAllRows,104000 row test.
85 del
< Ending test: test6
85 add
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> Caused by: java.lang.NullPointerException
> ... 5 more
Test Failed.
*** End: OnlineCompressTest jdk1.4.2 storeall:storemore 2007-05-18 20:12:33 ***

The null pointers look like the result of stuff going on while the system is doing a hard shutdown because it encountered an checksum error,
I'll attach a full derby.log - but here is the stack of interest.

------------ BEGIN SHUTDOWN ERROR STACK -------------
^M
ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1584)), expected=3,548
,973,544, on-disk version=3,871,832,684, page dump follows: Hex dump:
...
00000fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000ff0: 0000 0000 0000 0000 0000 0000 e6c7 7a6c .............?zl
^M
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source
)^M
    at org.apache.derby.impl.store.raw.data.StoredPage.validateChecksum(Unknown
Source)^M
    at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(Unknown Sour
ce)^M
    at org.apache.derby.impl.store.raw.data.AllocPage.initFromData(Unknown Sourc
e)^M
    at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Sourc
e)^M
    at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Sourc
e)^M
    at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown So
urce)^M
    at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)^M
    at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)^M
    at org.apache.derby.impl.store.raw.data.FileContainer.getAllocPage(Unknown S
ource)^M
    at org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown S
ource)^M
    at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unk
nown Source)^M
    at org.apache.derby.impl.store.raw.data.FileContainer.deallocatePagenum(Unkn
own Source)^M
    at org.apache.derby.impl.store.raw.data.FileContainer.deallocatePage(Unknown
 Source)^M
    at org.apache.derby.impl.store.raw.data.BaseContainer.removePage(Unknown Sou
rce)^M
    at org.apache.derby.impl.store.raw.data.BaseContainerHandle.removePage(Unkno
wn Source)^M
    at org.apache.derby.impl.store.access.heap.HeapController.removePage(Unknown
 Source)^M
    at org.apache.derby.impl.store.access.heap.HeapPostCommit.purgeCommittedDele
tes(Unknown Source)^M
    at org.apache.derby.impl.store.access.heap.HeapPostCommit.performWork(Unknow
n Source)^M
    at org.apache.derby.impl.store.raw.xact.Xact.postTermination(Unknown Source)
^M
    at org.apache.derby.impl.store.raw.xact.Xact.completeCommit(Unknown Source)^
M
    at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source)^M
    at org.apache.derby.impl.store.raw.xact.Xact.commit(Unknown Source)^M
    at org.apache.derby.impl.store.access.RAMTransaction.commit(Unknown Source)^
M
    at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doCommit(
Unknown Source)^M
    at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userCommi
t(Unknown Source)^M
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown Source)
^M
    at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source)^M
    at org.apache.derbyTesting.functionTests.tests.store.BaseTest.executeQuery(B
aseTest.java:124)^M
    at org.apache.derbyTesting.functionTests.tests.store.OnlineCompressTest.test
6(OnlineCompressTest.java:1409)^M
    at org.apache.derbyTesting.functionTests.tests.store.OnlineCompressTest.test
List(OnlineCompressTest.java:1448)^M
    at org.apache.derbyTesting.functionTests.tests.store.OnlineCompressTest.main
(OnlineCompressTest.java:1462)^M
^M

------------ END SHUTDOWN ERROR STACK -------------


This test passed in many other environments against this build, so my assumption is that this is intermittent. I have not seen this issue in this test before.