[DERBY-4922] failure in tests using encryption - fails to rename certain database files

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.7.1.1, 10.7.1.4
• Fix Version/s: 10.7.1.4
• Component/s: Test
• Labels: derby_triage10_8
• Environment: windows XP
• Urgency: Normal
• Bug behavior facts: Regression Test Failure
• Assignee: Unassigned
• Reporter: Myrna van Lunteren
• Created: 30/Nov/10 22:47
• Updated: 01/Mar/12 22:45
• Resolved: 01/Mar/12 21:27

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

• is duplicated by: DERBY-5188 error XBM0S in nstest on attempting re-encryption
• is related to: DERBY-4905 test failure in teardown (removeDir) in upgrade tests related to testSQLRoles
• is related to: DERBY-4915 test failure in OSReadOnlyTest in assertDirectoryDeleted
• is related to: DERBY-4916 Upgrade tests fail in DropDatabaseSetup.tearDown unable to delete a directory
• is related to: DERBY-5123 address a select number of intermittent test issues - goal is to get all nightly tests at trunk running clean for at least 2 weeks