Derby
  1. Derby
  2. DERBY-4922

failure in tests using encryption - fails to rename certain database files

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 10.7.1.1, 10.7.1.4
    • Fix Version/s: 10.7.1.4
    • Component/s: Test
    • Environment:
      windows XP
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression Test Failure

      Description

      I've seen 2 test failures related to an attempt by derby to rename database files;

      1: during nightly tests (11/29/2010; svn sync-ed up to 1040394, so 10.7.1.2) with ibm 1.6 SR8, derbyall (dir edited to shorter name & inserted line breaks for readability)

          • Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionOFB 2010-11-30 00:41:14 ***
            74 del
            < 0 rows inserted/updated/deleted
            74a74,76
            > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException:
            ERROR XBM0S: Unable to rename
            file 'C:\test\\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.properties'
            to 'C:\test\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.propertiesold''
            was thrown while evaluating an expression.
            > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename
            file 'C:\test\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.properties'
            to 'C:\test\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.propertiesold':
            org.apache.derby.iapi.error.PassThroughException'.
            > ERROR XBM0S: Unable to rename
            file 'C:\test\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.properties'
            to 'C:\test\derbyall\encryptionAll\encryptionOFB\encryptDatabase\wombat\service.propertiesold'
            .....(many more resulting diffs)...

      2: during DbpPowersTest in test cycle of 10.7.1.1 (build 1040133), with ibm 1.5. SR11 FP1:
      1) testReEncrypt(org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest)
      junit.framework.AssertionFailedError:
      (re)encryption, no authentication expected:<null> but was:
      <java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
      SQLERRMC: Failed to start database 'singleUse/oneuse1e'
      with class loader sun.misc.Launcher$AppClassLoader@2c0a2c0a, see the next exception for details.::
      SQLSTATE: XJ001Java exception:
      'ERROR XBM0S: Unable to rename file 'C:\test\system\singleUse\oneuse1e\service.properties' to
      'C:\test\system\singleUse\oneuse1e\service.propertiesold':
      org.apache.derby.iapi.error.PassThroughException'.::SQLSTATE: XBM0S
      Unable to rename file 'C:\test\system\singleUse\oneuse1e\service.properties'
      to 'C:\test\system\singleUse\oneuse1e\service.propertiesold'>
      at org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest.vetAttempt(DboPowersTest.java:751)
      at org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest.vetEncryptionAttempt(DboPowersTest.java:586)
      at org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest.testReEncrypt(DboPowersTest.java:510)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:23)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:23)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:23)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:23)

      I believe the problems are related to the removeDir issues of DERBY-4905 and DERBY-4915.

        Issue Links

          Activity

          Hide
          Myrna van Lunteren added a comment -

          I believe this is the same issue as DERBY-5574.

          Show
          Myrna van Lunteren added a comment - I believe this is the same issue as DERBY-5574 .
          Hide
          Myrna van Lunteren added a comment -

          These are possibly two very different problems.
          The derbyall failure apparently only occurs on one machine (a windows machine which runs the 10.7 codeline).

          The DboPowersTest failure also has happened on this machine, but less frequently, and has failed also on the machine running the 10.6 codeline.
          I've tried to reproduce this DboPowersTest by running it a number of times but so far no luck.

          Show
          Myrna van Lunteren added a comment - These are possibly two very different problems. The derbyall failure apparently only occurs on one machine (a windows machine which runs the 10.7 codeline). The DboPowersTest failure also has happened on this machine, but less frequently, and has failed also on the machine running the 10.6 codeline. I've tried to reproduce this DboPowersTest by running it a number of times but so far no luck.
          Hide
          Knut Anders Hatlen added a comment -

          Failures to delete log files in the encryption tests in DboPowersTest have also been seen frequently in the Java 7 testing on Windows lately. For example here: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/vista-64/1078053-suitesAll_diff.txt

          Show
          Knut Anders Hatlen added a comment - Failures to delete log files in the encryption tests in DboPowersTest have also been seen frequently in the Java 7 testing on Windows lately. For example here: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/vista-64/1078053-suitesAll_diff.txt
          Hide
          Mike Matrigali added a comment -

          another nightly test failure, the old harness failures are interesting in that there is much less chance for other tests
          to affect them, unlike the junit tests. I assume the rename issue is going to be particular to windows which prevents
          overwriting or deleting open files.

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

              • Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionECB 2011-02-13 00:55:54 ***
                68 del
                < 0 rows inserted/updated/deleted
                68a68,70
                > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression.
                > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'.
                > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'
                74 del
                < 0 rows inserted/updated/deleted
                74a76,78
                > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression.
                > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'.
                > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'
                91,92d94
                < 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.
                94 del
                < ERROR XJ040: Failed to start database 'wombat' with class loader XXXX, see the next exception for details.
                95 del
                < ERROR XBM06: Startup failed. An encrypted database cannot be accessed without the correct boot password.
                96 del
                < ij> connect 'jdbc:derby:wombat;bootPassword=derbypwd';
                97 del
                < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
                97a96,97
                > ij(CONNECTION1)> connect 'jdbc:derby:wombat;bootPassword=derbypwd';
                > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
                101 del
                < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
                101a101
                > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
                105 del
                < ij> – change it again, make sure it trims white spaces
                105a105
                > ij(CONNECTION2)> – 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(CONNECTION2)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'bbderbypwdx, derbypwdxx ');
                > ERROR XBCXA: Wrong boot password.
                > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword');
                114 del
                < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
                114a114
                > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword');
                118 del
                < ij> disconnect;
                118a118
                > ij(CONNECTION2)> 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:encryptionECB 2011-02-13 00:56:04 ***
                          • Diff file derbyall/storeall/storemore/onlineBackupTest2.diff
              • Start: onlineBackupTest2 jdk1.6.0 storeall:storemore 2011-02-13 00:30:43 ***
                79a80,82
                > ERROR XSRS4: Error renaming file (during backup) from extinout\mybackup\wombat to extinout\mybackup\wombat.OLD.
                > ij(C1)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE(
                > 'extinout/mybackup', 1);
                81,83d83
                < ij(C1)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE(
                < 'extinout/mybackup', 1);
                < 0 rows inserted/updated/deleted
                Test Failed.
              • End: onlineBackupTest2 jdk1.6.0 storeall:storemore 2011-02-13 00:31:12 ***
          Show
          Mike Matrigali added a comment - another nightly test failure, the old harness failures are interesting in that there is much less chance for other tests to affect them, unlike the junit tests. I assume the rename issue is going to be particular to windows which prevents overwriting or deleting open files. http://people.apache.org/~myrnavl/derby_test_results/v10_7/windows/testlog/ibm16/1070184-derbyall_diff.txt Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionECB 2011-02-13 00:55:54 *** 68 del < 0 rows inserted/updated/deleted 68a68,70 > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression. > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'. > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold' 74 del < 0 rows inserted/updated/deleted 74a76,78 > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression. > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'. > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-12\ibm16_derbyall\derbyall\encryptionAll\encryptionECB\encryptDatabase\wombat\service.propertiesold' 91,92d94 < 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. 94 del < ERROR XJ040: Failed to start database 'wombat' with class loader XXXX, see the next exception for details. 95 del < ERROR XBM06: Startup failed. An encrypted database cannot be accessed without the correct boot password. 96 del < ij> connect 'jdbc:derby:wombat;bootPassword=derbypwd'; 97 del < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword'); 97a96,97 > ij(CONNECTION1)> connect 'jdbc:derby:wombat;bootPassword=derbypwd'; > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword'); 101 del < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword'); 101a101 > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword'); 105 del < ij> – change it again, make sure it trims white spaces 105a105 > ij(CONNECTION2)> – 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(CONNECTION2)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'bbderbypwdx, derbypwdxx '); > ERROR XBCXA: Wrong boot password. > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('bootPassword'); 114 del < ij> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword'); 114a114 > ij(CONNECTION2)> values SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('encryptedBootPassword'); 118 del < ij> disconnect; 118a118 > ij(CONNECTION2)> 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:encryptionECB 2011-02-13 00:56:04 *** Diff file derbyall/storeall/storemore/onlineBackupTest2.diff Start: onlineBackupTest2 jdk1.6.0 storeall:storemore 2011-02-13 00:30:43 *** 79a80,82 > ERROR XSRS4: Error renaming file (during backup) from extinout\mybackup\wombat to extinout\mybackup\wombat.OLD. > ij(C1)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( > 'extinout/mybackup', 1); 81,83d83 < ij(C1)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE( < 'extinout/mybackup', 1); < 0 rows inserted/updated/deleted Test Failed. End: onlineBackupTest2 jdk1.6.0 storeall:storemore 2011-02-13 00:31:12 ***
          Hide
          Mike Matrigali added a comment -

          another 10.7, windows, ibm16 example:
          http://people.apache.org/~myrnavl/derby_test_results/v10_7/windows/testlog/ibm16/1070375-suites.All_diff.txt

          There was 1 error:
          1) testEncrypt(org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest)java.sql.SQLException: Failed to start database 'dbsqlauth' with class loader sun.misc.Launcher$AppClassLoader@44fa44fa, see the next exception for details.
          at java.lang.Throwable.<init>(Throwable.java:80)
          at java.sql.SQLException.<init>(SQLException.java:153)
          at java.sql.SQLException.<init>(SQLException.java:176)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
          at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
          at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
          at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
          at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
          at java.sql.DriverManager.getConnection(DriverManager.java:322)
          at java.sql.DriverManager.getConnection(DriverManager.java:297)
          at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:81)
          at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:43)
          at org.apache.derbyTesting.junit.TestConfiguration.openDefaultConnection(TestConfiguration.java:1538)
          at org.apache.derbyTesting.junit.BaseJDBCTestSetup.getConnection(BaseJDBCTestSetup.java:72)
          at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:313)
          at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          Caused by: java.sql.SQLException: Failed to start database 'dbsqlauth' with class loader sun.misc.Launcher$AppClassLoader@44fa44fa, see the next exception for details.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          ... 48 more
          Caused by: java.sql.SQLException: cannot create log file at directory F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\log.
          at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
          at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
          at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
          ... 45 more
          Caused by: ERROR XSLAQ: cannot create log file at directory F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\log.
          at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
          at org.apache.derby.impl.store.raw.log.LogToFile.getLogDirectory(Unknown Source)
          at org.apache.derby.impl.store.raw.log.LogToFile.getControlFileName(Unknown Source)
          at org.apache.derby.impl.store.raw.log.LogToFile.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(Unknown Source)
          at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(Unknown Source)
          at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
          at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
          at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
          at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
          at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
          at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
          ... 45 more
          There was 1 failure:
          1) testReEncrypt(org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest)junit.framework.AssertionFailedError: F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\seg0
          at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:116)
          at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:128)
          at org.apache.derbyTesting.junit.DropDatabaseSetup.access$000(DropDatabaseSetup.java:35)
          at org.apache.derbyTesting.junit.DropDatabaseSetup$1.run(DropDatabaseSetup.java:105)
          at java.security.AccessController.doPrivileged(AccessController.java:202)
          at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:102)
          at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:98)
          at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDatabase(DropDatabaseSetup.java:91)
          at org.apache.derbyTesting.junit.TestConfiguration$7.tearDown(TestConfiguration.java:863)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:20)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)
          at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
          at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
          at junit.extensions.TestSetup.run(TestSetup.java:23)

          FAILURES!!!
          Tests run: 13180, Failures: 1, Errors: 1

          Show
          Mike Matrigali added a comment - another 10.7, windows, ibm16 example: http://people.apache.org/~myrnavl/derby_test_results/v10_7/windows/testlog/ibm16/1070375-suites.All_diff.txt There was 1 error: 1) testEncrypt(org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest)java.sql.SQLException: Failed to start database 'dbsqlauth' with class loader sun.misc.Launcher$AppClassLoader@44fa44fa, see the next exception for details. at java.lang.Throwable.<init>(Throwable.java:80) at java.sql.SQLException.<init>(SQLException.java:153) at java.sql.SQLException.<init>(SQLException.java:176) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:322) at java.sql.DriverManager.getConnection(DriverManager.java:297) at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:81) at org.apache.derbyTesting.junit.DriverManagerConnector.openConnection(DriverManagerConnector.java:43) at org.apache.derbyTesting.junit.TestConfiguration.openDefaultConnection(TestConfiguration.java:1538) at org.apache.derbyTesting.junit.BaseJDBCTestSetup.getConnection(BaseJDBCTestSetup.java:72) at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setProperties(DatabasePropertyTestSetup.java:313) at org.apache.derbyTesting.junit.DatabasePropertyTestSetup.setUp(DatabasePropertyTestSetup.java:268) at junit.extensions.TestSetup$1.protect(TestSetup.java:18) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) Caused by: java.sql.SQLException: Failed to start database 'dbsqlauth' with class loader sun.misc.Launcher$AppClassLoader@44fa44fa, see the next exception for details. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 48 more Caused by: java.sql.SQLException: cannot create log file at directory F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\log. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ... 45 more Caused by: ERROR XSLAQ: cannot create log file at directory F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\log. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.getLogDirectory(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.getControlFileName(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(Unknown Source) at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source) ... 45 more There was 1 failure: 1) testReEncrypt(org.apache.derbyTesting.functionTests.tests.jdbcapi.DboPowersTest)junit.framework.AssertionFailedError: F:\jartest\JarResults.2011-02-13\ibm16_suites.All\system\dbsqlauth\seg0 at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:116) at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:128) at org.apache.derbyTesting.junit.DropDatabaseSetup.access$000(DropDatabaseSetup.java:35) at org.apache.derbyTesting.junit.DropDatabaseSetup$1.run(DropDatabaseSetup.java:105) at java.security.AccessController.doPrivileged(AccessController.java:202) at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:102) at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:98) at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDatabase(DropDatabaseSetup.java:91) at org.apache.derbyTesting.junit.TestConfiguration$7.tearDown(TestConfiguration.java:863) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.extensions.TestSetup.run(TestSetup.java:23) FAILURES!!! Tests run: 13180, Failures: 1, Errors: 1
          Hide
          Mike Matrigali added a comment -

          continues to be an issue for nightly regression testing. Here is an example from failure against 10.7, windows, ibm16,

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

              • Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionDES 2011-02-16 00:57:23 ***
                67a68,75
                > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression.
                > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'.
                > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold'
                > ij> – this should fail
                > call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Thursday , derbypwd');
                > ERROR XBCXA: Wrong boot password.
                > ij> – change it again
                > call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Saturday,derbypwd');
                69,74d76
                < ij> – this should fail
                < call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Thursday , derbypwd');
                < ERROR XBCXA: Wrong boot password.
                < ij> – change it again
                < call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Saturday,derbypwd');
                < 0 rows inserted/updated/deleted
                Test Failed.
              • End: encryptDatabase jdk1.6.0 encryptionAll:encryptionDES 2011-02-16 00:57:33 ***
                ------------------------------------------------------
          Show
          Mike Matrigali added a comment - continues to be an issue for nightly regression testing. Here is an example from failure against 10.7, windows, ibm16, http://people.apache.org/~myrnavl/derby_test_results/v10_7/windows/testlog/ibm16/1071131-derbyall_diff.txt Start: encryptDatabase jdk1.6.0 encryptionAll:encryptionDES 2011-02-16 00:57:23 *** 67a68,75 > ERROR 38000: The exception 'org.apache.derby.iapi.error.PassThroughException: ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold'' was thrown while evaluating an expression. > ERROR XJ001: Java exception: 'ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold': org.apache.derby.iapi.error.PassThroughException'. > ERROR XBM0S: Unable to rename file 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.properties' to 'F:\jartest\JarResults.2011-02-15\ibm16_derbyall\derbyall\encryptionAll\encryptionDES\encryptDatabase\wombat\service.propertiesold' > ij> – this should fail > call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Thursday , derbypwd'); > ERROR XBCXA: Wrong boot password. > ij> – change it again > call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Saturday,derbypwd'); 69,74d76 < ij> – this should fail < call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Thursday , derbypwd'); < ERROR XBCXA: Wrong boot password. < ij> – change it again < call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('bootPassword', 'Saturday,derbypwd'); < 0 rows inserted/updated/deleted Test Failed. End: encryptDatabase jdk1.6.0 encryptionAll:encryptionDES 2011-02-16 00:57:33 *** ------------------------------------------------------

            People

            • Assignee:
              Unassigned
              Reporter:
              Myrna van Lunteren
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development