[DERBY-6930] Embedded driver database remains locked after close

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: 10.12.1.1
• Component/s: Miscellaneous
• Environment: OS X and Ubuntu
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Alastair Rae
• Created: 01/Apr/17 15:04
• Updated: 02/Apr/17 15:33
• Resolved: 02/Apr/17 15:33

Description

1 Open and close a local embedded database in one process.
2 Open the database from another process - it fails with ERROR XJ040
Simple test program:

public static void main(String[] args) {
        Properties p = new Properties();
        p.setProperty("user", "dummy");
        p.setProperty("password", "dummy");
        String url = "jdbc:derby:/tmp/database;create=true";
        try {
            Connection c = DriverManager.getConnection(url, p);
            c.close();
            System.out.println("closed");
            Thread.sleep(10000L);
            System.out.println("ok");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

After the first close I can see:

$ fuser /tmp/database/*
/tmp/database/dbex.lck: 13060