You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Brill Pappin (JIRA)" <ji...@codehaus.org> on 2008/11/19 22:42:41 UTC

[jira] Created: (MRM-1014) Database corrupt on restart

Database corrupt on restart
---------------------------

                 Key: MRM-1014
                 URL: http://jira.codehaus.org/browse/MRM-1014
             Project: Archiva
          Issue Type: Bug
          Components: system
    Affects Versions: 1.2-M1
         Environment: Redhat Linux, JDK 6, War distro in Tomcat 6
            Reporter: Brill Pappin
            Priority: Blocker


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)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (MRM-1014) Database corrupt on restart

Posted by "Brill Pappin (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/MRM-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=154787#action_154787 ] 

Brill Pappin commented on MRM-1014:
-----------------------------------

One other thing, this is using derby-10.4.2.0.jar

> Database corrupt on restart
> ---------------------------
>
>                 Key: MRM-1014
>                 URL: http://jira.codehaus.org/browse/MRM-1014
>             Project: Archiva
>          Issue Type: Bug
>          Components: system
>    Affects Versions: 1.2-M1
>         Environment: Redhat Linux, JDK 6, War distro in Tomcat 6
>            Reporter: Brill Pappin
>            Priority: Blocker
>
> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Issue Comment Edited: (MRM-1014) Database corrupt on restart

Posted by "Brill Pappin (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/MRM-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=154787#action_154787 ] 

brill edited comment on MRM-1014 at 11/19/08 3:45 PM:
-------------------------------------------------------------

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


      was (Author: brill):
    One other thing, this is using derby-10.4.2.0.jar
  
> Database corrupt on restart
> ---------------------------
>
>                 Key: MRM-1014
>                 URL: http://jira.codehaus.org/browse/MRM-1014
>             Project: Archiva
>          Issue Type: Bug
>          Components: system
>    Affects Versions: 1.2-M1
>         Environment: Redhat Linux, JDK 6, War distro in Tomcat 6
>            Reporter: Brill Pappin
>            Priority: Blocker
>
> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (MRM-1014) Database corrupt on restart

Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/MRM-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=154941#action_154941 ] 

Brett Porter commented on MRM-1014:
-----------------------------------

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 :)

> Database corrupt on restart
> ---------------------------
>
>                 Key: MRM-1014
>                 URL: http://jira.codehaus.org/browse/MRM-1014
>             Project: Archiva
>          Issue Type: Bug
>          Components: system
>    Affects Versions: 1.2-M1
>         Environment: Redhat Linux, JDK 6, War distro in Tomcat 6
>            Reporter: Brill Pappin
>            Priority: Blocker
>
> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Closed: (MRM-1014) Database corrupt on restart

Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
     [ http://jira.codehaus.org/browse/MRM-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brett Porter closed MRM-1014.
-----------------------------

    Resolution: Duplicate

> Database corrupt on restart
> ---------------------------
>
>                 Key: MRM-1014
>                 URL: http://jira.codehaus.org/browse/MRM-1014
>             Project: Archiva
>          Issue Type: Bug
>          Components: system
>    Affects Versions: 1.2-M1
>         Environment: Redhat Linux, JDK 6, War distro in Tomcat 6
>            Reporter: Brill Pappin
>            Priority: Blocker
>
> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira