[DERBY-5856] ERROR XSDB6:Another instance of Derby may have already booted the database under multiple JVM environment

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 10.5.1.1
• Component/s: Eclipse Plug-in
• Environment: Windows, eclipse
• Urgency: Urgent
• Bug behavior facts: Embedded/Client difference
• Assignee: Unassigned
• Reporter: mwu
• Created: 12/Jul/12 04:50
• Updated: 13/Jul/12 09:23
• Resolved: 13/Jul/12 09:23

Description

There are 2 JVM lauched in my environment, one JVM is trying to access the derby database with url jdbc:derby:d:\location1\sample, another JVM is trying to access the another derby db with url jdbc:derby:d:\location2\sample.
For each JVM, will create multiple connection during runtime. When one JVM has create serveral connections from database, only one connection is allowed for another JVM. If I tried to create more connection for another JVM, it will throw the exception:

Caused by: java.sql.SQLException: Failed to start database 'd:\location2\sample.', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 71 more
Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database d:\location2\sample.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 68 more
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database d:\location2\sample.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)