You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2008/07/21 20:45:31 UTC

[jira] Created: (DERBY-3789) Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows
------------------------------------------------------------------------------------------------------

                 Key: DERBY-3789
                 URL: https://issues.apache.org/jira/browse/DERBY-3789
             Project: Derby
          Issue Type: Bug
          Components: Services
    Affects Versions: 10.5.0.0
         Environment: Windows XP 
            Reporter: Kathey Marsden




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3789) Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3789:
----------------------------------

         Description: 
If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
[C:]java EncryptShutdown
Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
        at junit.framework.Assert.fail(Assert.java:47)
        at junit.framework.Assert.assertTrue(Assert.java:20)
        at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
        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:193)
        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.BaseTestCase.removeDirectory(BaseTestCase.java:522)
        at EncryptShutdown.main(EncryptShutdown.java:25)


Apparently all resources are not being released.  It runs fine if the database is not encrypted.

         Environment: 
Windows XP java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
J9VM - 20070131_11312_lHdSMR
JIT  - 20070109_1805ifx1_r8
GC   - 200701_09)
JCL  - 20070131

  was:Windows XP 

    Derby Categories: [High Value Fix]

> Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3789
>                 URL: https://issues.apache.org/jira/browse/DERBY-3789
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.5.0.0
>         Environment: Windows XP java version "1.5.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
> IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
> J9VM - 20070131_11312_lHdSMR
> JIT  - 20070109_1805ifx1_r8
> GC   - 200701_09)
> JCL  - 20070131
>            Reporter: Kathey Marsden
>
> If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
> [C:]java EncryptShutdown
> Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
>         at junit.framework.Assert.fail(Assert.java:47)
>         at junit.framework.Assert.assertTrue(Assert.java:20)
>         at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
>         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:193)
>         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.BaseTestCase.removeDirectory(BaseTestCase.java:522)
>         at EncryptShutdown.main(EncryptShutdown.java:25)
> Apparently all resources are not being released.  It runs fine if the database is not encrypted.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-3789) Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden closed DERBY-3789.
---------------------------------


> Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3789
>                 URL: https://issues.apache.org/jira/browse/DERBY-3789
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.5.0.0
>         Environment: Windows XP java version "1.5.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
> IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
> J9VM - 20070131_11312_lHdSMR
> JIT  - 20070109_1805ifx1_r8
> GC   - 200701_09)
> JCL  - 20070131
>            Reporter: Kathey Marsden
>         Attachments: EncryptShutdown.java
>
>
> If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
> [C:]java EncryptShutdown
> Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
>         at junit.framework.Assert.fail(Assert.java:47)
>         at junit.framework.Assert.assertTrue(Assert.java:20)
>         at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
>         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:193)
>         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.BaseTestCase.removeDirectory(BaseTestCase.java:522)
>         at EncryptShutdown.main(EncryptShutdown.java:25)
> Apparently all resources are not being released.  It runs fine if the database is not encrypted.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3789) Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3789:
----------------------------------

    Attachment: EncryptShutdown.java

> Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3789
>                 URL: https://issues.apache.org/jira/browse/DERBY-3789
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.5.0.0
>         Environment: Windows XP java version "1.5.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
> IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
> J9VM - 20070131_11312_lHdSMR
> JIT  - 20070109_1805ifx1_r8
> GC   - 200701_09)
> JCL  - 20070131
>            Reporter: Kathey Marsden
>         Attachments: EncryptShutdown.java
>
>
> If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
> [C:]java EncryptShutdown
> Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
>         at junit.framework.Assert.fail(Assert.java:47)
>         at junit.framework.Assert.assertTrue(Assert.java:20)
>         at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
>         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:193)
>         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.BaseTestCase.removeDirectory(BaseTestCase.java:522)
>         at EncryptShutdown.main(EncryptShutdown.java:25)
> Apparently all resources are not being released.  It runs fine if the database is not encrypted.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-3789) Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-3789.
-----------------------------------

    Resolution: Invalid

With the latest IBM 1.5 jvm I cannot reproduce this problem.
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20080315 (SR7))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20080315 (JIT enabled)
J9VM - 20080314_17962_lHdSMr
JIT  - 20080130_0718ifx2_r8
GC   - 200802_08)
JCL  - 20080314

It does not reproduce with Sun 1.6, or 1.5 or IBM 1.6 either. Closing as invalid.  Perhaps it was a jvm bug.



> Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3789
>                 URL: https://issues.apache.org/jira/browse/DERBY-3789
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.5.0.0
>         Environment: Windows XP java version "1.5.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
> IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
> J9VM - 20070131_11312_lHdSMR
> JIT  - 20070109_1805ifx1_r8
> GC   - 200701_09)
> JCL  - 20070131
>            Reporter: Kathey Marsden
>         Attachments: EncryptShutdown.java
>
>
> If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
> [C:]java EncryptShutdown
> Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
>         at junit.framework.Assert.fail(Assert.java:47)
>         at junit.framework.Assert.assertTrue(Assert.java:20)
>         at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
>         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:193)
>         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.BaseTestCase.removeDirectory(BaseTestCase.java:522)
>         at EncryptShutdown.main(EncryptShutdown.java:25)
> Apparently all resources are not being released.  It runs fine if the database is not encrypted.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.