Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5856

ERROR XSDB6:Another instance of Derby may have already booted the database under multiple JVM environment

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: None
    • Component/s: Eclipse Plug-in
    • Labels:
      None
    • Environment:
      Windows, eclipse
    • Urgency:
      Urgent
    • Bug behavior facts:
      Embedded/Client difference

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sgaint mwu
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: