[
https://issues.apache.org/jira/browse/DERBY-4922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12996142#comment-12996142
]
Mike Matrigali commented on DERBY-4922:
---------------------------------------
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 ***
> failure in tests using encryption - fails to rename certain database files
> --------------------------------------------------------------------------
>
> Key: DERBY-4922
> URL: https://issues.apache.org/jira/browse/DERBY-4922
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.7.1.1, 10.7.1.3
> Environment: windows XP
> Reporter: Myrna van Lunteren
>
> 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.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
