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
Environment: Windows 7, Java JRE 1.6.0_29
Reporter: Rohit Nijhawan
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
