db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4922) failure in tests using encryption - fails to rename certain database files
Date Thu, 17 Feb 2011 22:59:12 GMT

    [ 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

        

Mime
View raw message