jira.codehaus.org

  • Log In Access more options
    • Online Help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What?s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Archiva
  • MRM-1014

Database corrupt on restart

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Duplicate
  • Affects Version/s: 1.2-M1
  • Fix Version/s: None
  • Component/s: system
  • Labels:
    None
  • Environment:
    Redhat Linux, JDK 6, War distro in Tomcat 6

Description

I installed the WAR distribution of 1.2-M1 on a tomcat 6 instance.

It starts up fine, but when tomcat is restarted archive can no longer access the derby database.
This may be caused by a crash (Archive seemed to stop responding and failed on restart)

Here is what looks like the important part of the stack trace:

Caused by: java.sql.SQLException: Failed to start database '/var/emineo/archiva/users', 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)
... 96 more
Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /var/emineo/archiva/users.
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)
... 93 more
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /var/emineo/archiva/users.
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)

Issue Links

duplicates

Bug - A problem which impairs or prevents the functions of the product. MRM-724 Unable to restart Archiva after restarting Tomcat : "SQL Exception: Failed to start database"

  • Blocker - Blocks development and/or testing work, production could not run
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

Ascending order - Click to sort in descending order
  • All
  • Comments
  • Work Log
  • History
  • Activity
Hide
Permalink
Brill Pappin added a comment - 19/Nov/08 3:44 PM - edited

One other thing, this is using derby-10.4.2.0.jar
although it also happened with the recommended version from the war installation docs so I ssupect something is not getting cleaned up properly

Show
Brill Pappin added a comment - 19/Nov/08 3:44 PM - edited One other thing, this is using derby-10.4.2.0.jar although it also happened with the recommended version from the war installation docs so I ssupect something is not getting cleaned up properly
Hide
Permalink
Brett Porter added a comment - 20/Nov/08 11:43 PM

I believe removing db.lck from that directory will resolve the problem.

If you can think of a good place to express this in the documentation, we'd welcome a patch

Show
Brett Porter added a comment - 20/Nov/08 11:43 PM I believe removing db.lck from that directory will resolve the problem. If you can think of a good place to express this in the documentation, we'd welcome a patch

People

  • Assignee:
    Unassigned
    Reporter:
    Brill Pappin
Vote (0)
Watch (2)

Dates

  • Created:
    19/Nov/08 3:41 PM
    Updated:
    21/Nov/08 12:32 AM
    Resolved:
    21/Nov/08 12:32 AM
  • Atlassian JIRA (v5.0.4#731-sha1:3aa7374)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.