[ https://issues.apache.org/jira/browse/JCR-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13194970#comment-13194970 ]
Jukka Zitting commented on JCR-3221: ------------------------------------ Sounds like you may have some other Jackrabbit instance concurrently accessing the same database backend. Make sure that you start with a clean database and only run a single Jackrabbit instance at a time. If you you're setting up a cluster, note that you need to explicitly configure all nodes instead of just sharing the same repository.xml configuration file. See http://wiki.apache.org/jackrabbit/Clustering for details. > Jackrabbit in Sling won't bootstrap against oracle > -------------------------------------------------- > > Key: JCR-3221 > URL: https://issues.apache.org/jira/browse/JCR-3221 > Project: Jackrabbit Content Repository > Issue Type: Test > Components: config > Affects Versions: 2.2.10 > Environment: Windows 7, Java JRE 1.6.0_29 > Reporter: Rohit Nijhawan > Original Estimate: 48h > Remaining Estimate: 48h > > 1. Trying to use jackrabbit persistence config to Oracle under Sling > 2. Trying to run the jackrabbit standalone server against Oracle > in Sling, seeing this error repeatedly. If I run a DELETE FROM > JCR_DEFAULT_BUNDLE, the server starts up in sling but only 28/75 bundles are > active and only 101/152 services launch after all the bundles are manually > made active by pressing the |>| play button beside them. > AuthenticationSupport service never runs. I can log in but not upload content. > And in the the jackrabbit standalone server, if I delete from > JCR_DEFAULT_BUNDLE, the server never starts up fully. It stays at Starting > the server... > I have tried both: the pool.OraclePersistenceManager and > bundle.OraclePersistenceManager classes. I've seen similar issues with > 'writing the bundle' error but not one that was enforced on a unique > constraint from an index. > 2012-01-26 10:32:14.533 ERROR [main] BundleDbPersistenceManager.java:1108 > FATAL error while writing the bundle: deadbeef-cafe-babe-cafe-babecafebabe > java.sql.SQLException: ORA-00001: unique constraint > (MIC_COMMON_SB.JCR_DEFAULT_BUNDLE_IDX) violated > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) ~[na:Oracle > JDBC Driver version - "10.2.0.5.0"] > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:972) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3521) > ~[na:Oracle JDBC Driver version - "10.2.0.5.0"] > at > org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:474) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:335) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:323) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:319) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:487) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:319) > ~[jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1095) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:699) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:641) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:518) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:479) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1679) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:212) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1379) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2025) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1998) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:533) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:342) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:605) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.apache.jackrabbit.servlet.jackrabbit.JackrabbitRepositoryServlet.init(JackrabbitRepositoryServlet.java:103) > [jackrabbit-standalone-2.2.10.jar:na] > at javax.servlet.GenericServlet.init(GenericServlet.java:241) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:263) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:685) > [jackrabbit-standalone-2.2.10.jar:na] > at org.mortbay.jetty.servlet.Context.startContext(Context.java:140) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:467) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.handler.RequestLogHandler.doStart(RequestLogHandler.java:115) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) > [jackrabbit-standalone-2.2.10.jar:na] > at org.mortbay.jetty.Server.doStart(Server.java:224) > [jackrabbit-standalone-2.2.10.jar:na] > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > [jackrabbit-standalone-2.2.10.jar:na] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira