Derby
  1. Derby
  2. DERBY-5574

encryption test in encryption nightly suite test fails with ERROR XBM0S: Unable to rename file error

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
    • Labels:
      None
    • Environment:
    • Bug behavior facts:
      Regression Test Failure

      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 ***
            ------------------------------------------------------
      1. derby5574.diff
        3 kB
        Mike Matrigali
      2. derby.log
        132 kB
        Mike Matrigali

        Issue Links

          Activity

          Mike Matrigali created issue -
          Mike Matrigali made changes -
          Field Original Value New Value
          Summary encryptionAll:encryptionAES nightly test fails with ERROR XBM0S: Unable to rename file error encryption test in encryption nightly suite test fails with ERROR XBM0S: Unable to rename file error
          Description 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 ***
          ------------------------------------------------------
          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 ***
          ------------------------------------------------------
          Mike Matrigali made changes -
          Attachment derby.log [ 12511144 ]
          Mike Matrigali made changes -
          Attachment derby5574.diff [ 12511549 ]
          Mike Matrigali made changes -
          Assignee Mike Matrigali [ mikem ]
          Mike Matrigali made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.1.4 [ 12315902 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Link This issue is duplicated by DERBY-5188 [ DERBY-5188 ]
          Kathey Marsden made changes -
          Fix Version/s 10.8.3.0 [ 12323456 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Mike Matrigali made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12649617 ] Default workflow, editable Closed status [ 12796773 ]

            People

            • Assignee:
              Mike Matrigali
              Reporter:
              Mike Matrigali
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development