db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6247) updatelocksJDBC30 test failing in nightly regression tests
Date Thu, 02 Oct 2014 03:43:34 GMT

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

Myrna van Lunteren commented on DERBY-6247:
-------------------------------------------

I think  the problems can be prevented, or at least we can get better control over the test
if the test gets converted to junit.

I think this can be achieved by adding parameters to the current methods in the UpdateLocksTest
- which has already been converted.

I found the following differences between the original (I looked at the 10.7 branch versions)
updatelocks.sql and updatelocksJDBC30.sql and related files:
- the cursors in updatelocksJDBC30.sql were created as 'get hold cursor'
- the test did not execute any of the 'non cursor' runs
- the test did not execute a section for READ_UNCOMMITTED
- the test did not have any wait_for_post_commit calls

I think it is feasible to integrate the two tests now.

Also, I think the test should run in client-server mode as well as in embedded mode.
Finally the test needs to run in an encryption as well, the original test ran in storemats
which is part of the encryption suite, which has the following properties:
  testEncryptionAlgorithm=DESede/CBC/NoPadding
  testJavaFlags=testDataEncryption=Thursday
It looks like the encryption part has fallen by the wayside during the conversion of updatelocks.sql.
(Note: I tried to run the UpdateLocksTest.suite as part of EncryptionSuite, similar to how
AccessTest.suite() is run there, but UpdateLocksTest needs SQL objects set up and requires
a SystemPropertySetup for the pagesize, or all scans flop to be tablescans. So I'll try it
as part of the test itself).

> updatelocksJDBC30 test failing in nightly regression tests
> ----------------------------------------------------------
>
>                 Key: DERBY-6247
>                 URL: https://issues.apache.org/jira/browse/DERBY-6247
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.11.1.1
>         Environment: ------------------ Java Information ------------------
> Java Version:    1.6.0
> Java Vendor:     IBM Corporation
> Java home:       C:\jartest\ibm16\jre
> Java classpath:  C:/jartest/jars/derbyrun.jar;C:/jartest/jars/derbyTesting.jar;c:/jartest/tools/java/jakarta-oro-2.0.8.jar;c:/jartest/junit/junit.jar;
> OS name:         Windows Server 2008 R2
> OS architecture: x86
> OS version:      6.1 build 7601 Service Pack 1
> Java user name:  cloudtest
> Java user home:  C:\Users\cloudtest
> Java user dir:   C:\jartest\JarResults.2013-05-31\ibm16_derbyall
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.6
> java.runtime.version: pwi3260sr13fp1-20130325_01 (SR13 FP1)
> java.fullversion: JRE 1.6.0 IBM J9 2.4 Windows Server 2008 R2 x86-32 jvmwi3260sr13-20130114_134867
(JIT enabled, AOT enabled)
> J9VM - 20130114_134867
> JIT  - r9_20130108_31100
> GC   - 20121212_AA
> --------- Derby Information --------
> [C:\jartest\jars\derby.jar] 10.11.0.0 alpha - (1488447)
> [C:\jartest\jars\derbytools.jar] 10.11.0.0 alpha - (1488447)
> [C:\jartest\jars\derbynet.jar] 10.11.0.0 alpha - (1488447)
> [C:\jartest\jars\derbyclient.jar] 10.11.0.0 alpha - (1488447)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale :  [English/United States [en_US]]
> Found support for locale: [cs]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [de_DE]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [es]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [fr]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [hu]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [it]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [ja_JP]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [ko_KR]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [pl]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [pt_BR]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [ru]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [zh_CN]
> 	 version: 10.11.0.0 alpha - (1488447)
> Found support for locale: [zh_TW]
> 	 version: 10.11.0.0 alpha - (1488447)
>            Reporter: Mike Matrigali
>            Assignee: Myrna van Lunteren
>
> updatelocksJDBC30 test failed intermittently  in nightly regression tests, trunk, ibm16
> http://people.apache.org/~myrnavl/derby_test_results/main/windows/testlog/ibm16/1488447-derbyall_diff.txt
> ********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocksJDBC30.diff
> *** Start: updatelocksJDBC30 jdk1.6.0 storemats:storemats 2013-05-31 19:48:20 ***
> 15110d15109
> < APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> 15112a15112
> > APP     |UserTransaction|ROW     |2   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> 15125d15124
> < APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> 15129a15129
> > APP     |UserTransaction|ROW     |2   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> 15138d15137
> < APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> 15142a15142
> > APP     |UserTransaction|ROW     |2   |U   |A           |(1,7)     |GRANT|ACTIVE
 
> Test Failed.
> *** End:   updatelocksJDBC30 jdk1.6.0 storemats:storemats 2013-05-31 19:48:32 ***



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message