[DERBY-5574] encryption test in encryption nightly suite test fails with ERROR XBM0S: Unable to rename file error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.4
• Fix Version/s: 10.7.1.4, 10.8.3.0, 10.9.1.0
• Component/s: Test

Environment

------------------ Java Information ------------------
Java Version: 1.6.0
Java Vendor: IBM Corporation
Java home: F:\jartest\ibm16\jre
Java classpath: F:\jartest/tools/java/jakarta-oro-2.0.8.jar;F:\jartest/junit/junit.jar;;F:\jartest/classes/derbyrun.jar;F:\jartest/classes/derbyTesting.jar;F:\jartest/junit/junit.jar;F:\jartest/tools/java/jakarta-oro-2.0.8.jar;F:\jartest/tools/java/geronimo-spec-servlet-2.4-rc4.jar;F:\jartest/tools/java/xalan.jar;F:\jartest/tools/java/xercesImpl.jar;
OS name: Windows XP
OS architecture: x86
OS version: 5.1 build 2600 Service Pack 3
Java user name: cloudtest
Java user home: C:\Documents and Settings\cloudtest
Java user dir: F:\jartest\JarResults.2012-01-13\ibm16_derbyall
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
java.runtime.version: jvmwi3260sr9-20110203_74623
java.fullversion: 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
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[F:\jartest\classes\derby.jar] 10.7.1.4 - (1231439)
[F:\jartest\classes\derbytools.jar] 10.7.1.4 - (1231439)
[F:\jartest\classes\derbynet.jar] 10.7.1.4 - (1231439)
[F:\jartest\classes\derbyclient.jar] 10.7.1.4 - (1231439)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.7.1.4 - (1231439)
Found support for locale: [de_DE]
version: 10.7.1.4 - (1231439)
Found support for locale: [es]
version: 10.7.1.4 - (1231439)
Found support for locale: [fr]
version: 10.7.1.4 - (1231439)
Found support for locale: [hu]
version: 10.7.1.4 - (1231439)
Found support for locale: [it]
version: 10.7.1.4 - (1231439)
Found support for locale: [ja_JP]
version: 10.7.1.4 - (1231439)
Found support for locale: [ko_KR]
version: 10.7.1.4 - (1231439)
Found support for locale: [pl]
version: 10.7.1.4 - (1231439)
Found support for locale: [pt_BR]
version: 10.7.1.4 - (1231439)
Found support for locale: [ru]
version: 10.7.1.4 - (1231439)
Found support for locale: [zh_CN]
version: 10.7.1.4 - (1231439)
Found support for locale: [zh_TW]
version: 10.7.1.4 - (1231439)
------------------------------------------------------

• Bug behavior facts: Regression Test Failure
• Assignee: Mike Matrigali
• Reporter: Mike Matrigali
• Created: 19/Jan/12 00:00
• Updated: 19/Jun/13 17:19
• Resolved: 14/Feb/12 22:43

Description

encryption tests in nightly are intermittently failing. The suite runs same set of tests with a number of different
encryption algorithms. Different ones of these runs sometimes fail.

What has changed on this nightly platform is that we are now running each jvm set of tests concurrently to
get better throughput. This has changed load on machine and timing of operations. Each JVM puts results
into a different part of file system.

At least after the fact the file being renamed still exists and the destination file does not exist.

nightly test failure, jdk16, current 10.7 branch, windows.

http://people.apache.org/~myrnavl/derby_test_results/v10_7/windows/testlog/ibm16/1231439-derbyall_diff.txt

Failure Details:

• • • • • • • • • Diff file derbyall/derbynetclientmats/DerbyNetClient/encodingTests/TestEnc.diff
    • Start: TestEnc jdk1.6.0 DerbyNetClient derbynetclientmats:encodingTests 2012-01-14 01:42:10 ***
      derbyTesting.encoding can only be used with jdk15, skipping test
    • End: TestEnc jdk1.6.0 DerbyNetClient derbynetclientmats:encodingTests 2012-01-14 01:42:10 ***
      • • • • • • Diff file derbyall/encryptionAll/encryptionAES/encryptDatabase.diff
    • Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionAES 2012-01-14 01:51:40 ***
      74 del
      < 0 rows inserted/updated/deleted
      74a74,76
      > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: encryptionAll:encryptionAES 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression.
      > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'.
      > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2012-01-13\ibm16_derbyall\derbyall\encryptionAll\encryptionAES\encryptDatabase\wombat\service.propertiesold'
      94,95d95
      < ERROR XJ040: Failed to start database 'wombat' with class loader XXXX, see the next exception for details.
      < ERROR XBM06: Startup failed. An encrypted database cannot be accessed without the correct boot password.
      97 del
      < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
      97a97
      > ij(CONNECTION1)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
      101 del
      < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
      101a101
      > ij(CONNECTION1)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
      105 del
      < ij> – change it again, make sure it trims white spaces
      105a105
      > ij(CONNECTION1)> – change it again, make sure it trims white spaces
      107 del
      < 0 rows inserted/updated/deleted
      108 del
      < ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'bbderbypwdx, derbypwdxx ');
      109 del
      < 0 rows inserted/updated/deleted
      110 del
      < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
      110a107,110
      > ERROR XBCXA: Wrong boot password.
      > ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'bbderbypwdx, derbypwdxx ');
      > ERROR XBCXA: Wrong boot password.
      > ij(CONNECTION1)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
      114 del
      < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
      114a114
      > ij(CONNECTION1)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
      118 del
      < ij> disconnect;
      118a118
      > ij(CONNECTION1)> disconnect;
      124a125,126
      > ERROR XJ040: Failed to start database 'wombat' with class loader XXXX, see the next exception for details.
      > ERROR XBM06: Startup failed. An encrypted database cannot be accessed without the correct boot password.
      126 del
      < A
      127 del
      < --------------------
      128 del
      < hello world
      128a128
      > IJ ERROR: Unable to establish connection
      132 del
      < ERROR XBCXD: The encryption algorithm cannot be changed after the database is created.
      132a132
      > IJ ERROR: Unable to establish connection
      134 del
      < ERROR XBCXE: The encryption provider cannot be changed after the database is created.
      134a134
      > IJ ERROR: Unable to establish connection
      Test Failed.
    • End: encryptDatabase jdk1.6.0 encryptionAll:encryptionAES 2012-01-14 01:51:49 ***
      ------------------------------------------------------

Issue Links

• is duplicated by: DERBY-5188 error XBM0S in nstest on attempting re-encryption