Hi Daniel,

It looks like this may be a result of DERBY-4894 <https://issues.apache.org/jira/browse/DERBY-4894> which affects Derby 1.5 (more recent versions of Artifactory bundle Derby 1.6).


Yes, I would highly recommend moving to MySQL as a robust production option, you can follow the instructions here: http://wiki.jfrog.org/confluence/display/RTF/Changing+the+Default+Storage.

Then use a clean export/backup to import your artifacts to the new instance.


HTH,


Tomer


On 12/07/2010 05:17 PM, danieln wrote:

Hi,

We run artifactory on a linux server with the default Derby DB. We noticed
that it stopped working and tried to restart the tomcat server, but it does
not come up and we notice the exception following.
Does that mean that the DB is corrupted? Can we somehow connect to it
externally, find out the particular problem (table, record) and delete if?
If not, do we have to completely purge it? How do we do that, and is it
recommended moving to mysql?

Thanks in advance,

Daniel

javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.persistence.pool.DerbyPersistenceManager
         at
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1464)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl.access$800(RepositoryImpl.java:129)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2045)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:2028)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:555)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:386)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:704)
[jackrabbit-core-jfrog-2.1.0.jar:2.1.0]
         at
org.artifactory.jcr.JcrRepoInitHelper.createJcrRepository(JcrRepoInitHelper.java:113)
[artifactory-core-2.2.4.jar:na]
         at
org.artifactory.jcr.JcrServiceImpl.initJcrRepository(JcrServiceImpl.java:229)
[artifactory-core-2.2.4.jar:na]
         at
org.artifactory.jcr.JcrServiceImpl.initJcrRepository(JcrServiceImpl.java:215)
[artifactory-core-2.2.4.jar:na]
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[na:1.6.0_14]
         at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[na:1.6.0_14]
         at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[na:1.6.0_14]
         at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_14]
         at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor

It goes on and on for miles.... and then there is:

Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Failed to start
database '/opt/artifactory_home/data/db', see the next exception for
details.
         at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) [derby-10.5.3.0.jar:na]
         at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) [derby-10.5.3.0.jar:na]
         ... 96 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Unexpected
exception on in-memory page Page(23,Container(0, 1041))
         at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) [derby-10.5.3.0.jar:na]
         at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) [derby-10.5.3.0.jar:na]
         at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source) [derby-10.5.3.0.jar:na]
         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) [derby-10.5.3.0.jar:na]
         ... 93 common frames omitted



------------------------------------------------------------------------------
What happens now with your Lotus Notes apps - do you make another costly 
upgrade, or settle for being marooned without product support? Time to move
off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
use, and manage than apps on traditional platforms. Sign up for the Lotus 
Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
_______________________________________________
Artifactory-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/artifactory-users

Reply via email to