db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5209) 10.8 upgrade and compatibility testing
Date Thu, 22 Sep 2011 18:15:26 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13112781#comment-13112781
] 

Kathey Marsden commented on DERBY-5209:
---------------------------------------

Attaching My notes and test output for soft upgrade testing from 10.5 with 10.8.2.1
10_5SoftupgradeNotes.txt and 10_5SoftupgradeTestOutput.txt 

Created database with 10.5.3.0. Ran tests with 10.8.2.1 RC1  product jars and 10.5 derbyTesting.jar
against a soft upgraded database created with 10.5.3.0 in order to  identify potential soft
upgrade impact and behavior changes that should be documented.

I ran with IBM JDK 1.6
$ java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build pwi3260sr9fp1-20110208_03(SR9 FP1))
IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr9-20110203_74623 (JIT
enabled, AOT enabled)
J9VM - 20110203_074623
JIT  - r9_20101028_17488ifx3
GC   - 20101027_AA)
JCL  - 20110203_01


There were 192 Failures 109 Errors in the following categories:

The most serious issue is DERBY-5427 which I filed, but I also need to file issues for the
issues in the notes marked with asterisks


*3) NullPointerException in AuthentcationTest.testSystemShutdown(). Did not reproduce on rerun
of the individual test.

testSystemShutdown Exception in thread "DRDAConnThread_898" java.lang.NullPointerException
	at org.apache.derby.iapi.services.monitor.Monitor.getStream(Unknown Source)
	at org.apache.derby.iapi.services.monitor.Monitor.logMessage(Unknown Source)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.consoleMessage(Unknown Source)
	at org.apache.derby.impl.drda.NetworkServerControlImpl.consoleExceptionPrintTrace(Unknown
Source)
	at org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
used 1500 ms .

**10) testFunctionNullHandling(org.apache.derbyTesting.functionTests.tests.lang.RoutineTest)junit.framework.AssertionFailedError:
Column value mismatch @ column '1', row 1:
    Expected: >11:00:00<
    Found:    >null<
	at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:109...
	at org.apache.derbyTesting.functionTests.tests.lang.RoutineTest.testFunctionNullHandling(RoutineTest.java:575)
Needs investigation. I don't see a specific change to the assertion  since 10.5. 



*13) testUpdateXXXWithAllDatatypes(org.apache.derbyTesting.functionTests.tests.lang.UpdatableResultSetTest)junit.framework.AssertionFailedError:
The expected SQL state must be five characters long caused by 
	at org.apache.derbyTesting.functionTests.tests.lang.UpdatableResultSetTest.runTestUpdateXXXWithAllDatatypes(UpdatableResultSetTest.java:2726)
Caused by: java.sql.SQLException: Stream or LOB value cannot be retrieved more than once
The new error is expected but I am surprised that the SQLState would not be five characters.
Needs Investigation.


*22) Needs investigation.   Test has not changed in years.
testGreekCharacters(org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest)junit.framework.AssertionFailedError:
Connection should've been refused/failed
	at org.apache.derbyTesting.functionTests.tests.jdbcapi.DriverMgrAuthenticationTest.assertConnectionFail(DriverMgrAuthenticationTest.java:116)



> 10.8 upgrade and compatibility testing
> --------------------------------------
>
>                 Key: DERBY-5209
>                 URL: https://issues.apache.org/jira/browse/DERBY-5209
>             Project: Derby
>          Issue Type: Task
>          Components: Test
>    Affects Versions: 10.8.2.0
>            Reporter: Kathey Marsden
>         Attachments: test10_8SoftUpgradeFrom10_5.out
>
>
> I am doing some upgrade, client/server and  test compatibility testing with 10.8 and
am using this issue for tracking tests and results.  
> The first test was to create the system/wombat database with 10.5 and run Suites.All
with 10.8 product jars and 10.5 derbyTesting.jar Then I verified I could reconnect with 10.5
and perform a few operations.
> derbyTesting.jar.  Environment for reference is:
> export JAVA_HOME="/ibmsvn/ntsoftware/ibm16"
> export PATH="$JAVA_HOME/bin:$PATH"
> LIB="c:/cygwin/home/kmarsden/projects/10.8.1testing/db-derby-10.8.1.2-lib/lib"
> TOOLS="C:/cygwin/svn4/trunka/tools/java"
> LIB_105="C:/cygwin/svnreleases/jars/10.5.3.0"
> export CLASSPATH="$LIB/derbyrun.jar;$LIB_105/derbyTesting.jar;$TOOLS/junit.jar;
> TOOLS/jakarta-oro-2.0.8.jar"
> Output attached as test10_8SoftUpgradeFrom10_5.out. There were  Failures: 188,  Errors:
109 which haven't been analyzed yet, but I skimmed them and didn't see anything that looked
like data corruption.
> Will also run
> 10.7 derbyclient.jar, derbyTesting.jar 10.8 other product jars
> 10.7 derbynet.jar derbyTesting.jar 10.8 other product jars.

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

        

Mime
View raw message