jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Hall <c...@hallwaytech.com>
Subject Re: Clustering
Date Mon, 16 Aug 2010 03:20:54 GMT
Now that I'm passed that error, I'm getting the exception below which
results in subsequent exceptions about "Journal initialization failed".  I
end up with only the DATASTORE table in the schema.  I'm starting the server
with a clean Oracle schema.  Any suggestions?

15.08.2010 23:15:32.252 *ERROR* [SCR Component Actor]
org.apache.jackrabbit.core.util.db.ConnectionHelper Failed to execute SQL
(stacktrace on DEBUG log level) java.sql.SQLException: ORA-00902: invalid
datatype

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
        at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)
        at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)
        at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:274)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.access$000(ConnectionHelper.java:65)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:260)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:256)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:450)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:256)
        at
org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89)
        at
org.apache.jackrabbit.core.journal.DatabaseJournal.init(DatabaseJournal.java:265)
        at
org.apache.jackrabbit.core.config.RepositoryConfigurationParser$3.getJournal(RepositoryConfigurationParser.java:888)
        at
org.apache.jackrabbit.core.config.ClusterConfig.getJournal(ClusterConfig.java:86)
        at
org.apache.jackrabbit.core.cluster.ClusterNode.init(ClusterNode.java:204)
        at
org.apache.jackrabbit.core.cluster.ClusterNode.init(ClusterNode.java:190)
        at
org.apache.jackrabbit.core.RepositoryImpl.createClusterNode(RepositoryImpl.java:724)
        at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:346)
        at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673)
        at
org.apache.sling.jcr.jackrabbit.server.impl.SlingServerRepository.acquireRepository(SlingServerRepository.java:141)
        at
org.apache.sling.jcr.base.AbstractSlingRepository.startRepository(AbstractSlingRepository.java:831)
        at
org.apache.sling.jcr.base.AbstractSlingRepository.activate(AbstractSlingRepository.java:640)
15.08.2010 23:15:32.424 *ERROR* [SCR Component Actor]
org.apache.jackrabbit.core.util.db.ConnectionHelper Failed to execute SQL
(stacktrace on DEBUG log level) java.sql.SQLException: ORA-00902: invalid
datatype

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
        at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)
        at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)
        at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:274)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.access$000(ConnectionHelper.java:65)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:260)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:256)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:450)
        at
org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:256)
        at
org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89)
        at
org.apache.jackrabbit.core.journal.DatabaseJournal.init(DatabaseJournal.java:265)
        at
org.apache.jackrabbit.core.config.RepositoryConfigurationParser$3.getJournal(RepositoryConfigurationParser.java:888)
        at
org.apache.jackrabbit.core.config.ClusterConfig.getJournal(ClusterConfig.java:86)
        at
org.apache.jackrabbit.core.cluster.ClusterNode.init(ClusterNode.java:204)
        at
org.apache.jackrabbit.core.cluster.ClusterNode.init(ClusterNode.java:190)
        at
org.apache.jackrabbit.core.RepositoryImpl.createClusterNode(RepositoryImpl.java:724)
        at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:346)
        at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673)
        at
org.apache.sling.jcr.jackrabbit.server.impl.SlingServerRepository.acquireRepository(SlingServerRepository.java:141)
        at
org.apache.sling.jcr.base.AbstractSlingRepository.startRepository(AbstractSlingRepository.java:831)
        at
org.apache.sling.jcr.base.AbstractSlingRepository.activate(AbstractSlingRepository.java:640)


On Sat, Aug 14, 2010 at 2:12 PM, Carl Hall <carl@hallwaytech.com> wrote:

> Your 'fix' works for me, too!  Copying over just the namespace files you
> mentioned and my repository.xml allows subsequent nodes to start up cleanly.
>  I'll go through the archive to see Thomas's alternative.  Thanks!
>
>
> On Sat, Aug 14, 2010 at 12:53 PM, Justin Edelson <justinedelson@gmail.com>wrote:
>
>> The only 'fix' was to copy ns_reg.properties and ns_idx.properties from
>> one node to another. I didn't modify any other files in the repository
>> directory. In general, it seems like a bad idea to manually edit the files
>> in rep.home.
>>
>> Thomas Mueller suggested an alternate (and better) fix, but I haven't be
>> able to try it. Check the list archives for his email.
>>
>> Justin
>>
>> On Aug 14, 2010, at 12:31 PM, Carl Hall <carl@hallwaytech.com> wrote:
>>
>> > This is the only exception I see in the log which happens repeatedly, so
>> it
>> > could be covering something else that can't start.
>> >
>> > If it means anything, the repository/index is not created when this
>> happens.
>> >
>> > I set the contents of jackrabbit/repository/meta/rootUUID
>> > to cafebabe-cafe-babe-cafe-babecafebabf
>> > (was: cafebabe-cafe-babe-cafe-babecafebabe) but that didn't seem to help
>> > anything.
>> >
>> > Is there a fix for namespace indexing that I should/could try?
>> >
>> >
>> > On Sat, Aug 14, 2010 at 12:17 PM, Justin Edelson <
>> justinedelson@gmail.com>wrote:
>> >
>> >> Is this the only error in the log?
>> >>
>> >> You might be running into the namespace index problem I reported a few
>> >> weeks ago, but that had a different error.
>> >>
>> >> On Aug 14, 2010, at 11:31 AM, Carl Hall <carl@hallwaytech.com> wrote:
>> >>
>> >>> The ID of node 1 is 3AKAI.NYU.NODE1.  The ID of node 2 is
>> >> 3AKAI.NYU.NODE2.
>> >>> I'll keep digging.
>> >>>
>> >>> On Sat, Aug 14, 2010 at 11:08 AM, Justin Edelson <
>> >> justinedelson@gmail.com>wrote:
>> >>>
>> >>>> Perhaps you are not using a unique cluster ID?
>> >>>>
>> >>>> As I understand it, you should not need to manually copy anything
>> >> between
>> >>>> nodes.
>> >>>>
>> >>>> On Aug 14, 2010, at 9:10 AM, Carl Hall <carl@hallwaytech.com>
wrote:
>> >>>>
>> >>>>> I've been able to cluster JackRabbit backed by Oracle but I
have a
>> >>>> question
>> >>>>> about something I've observed.  In getting things setup, using
this
>> [1]
>> >>>>> config, the first node (against a clean Oracle schema) always
comes
>> up
>> >>>>> clean.  The second and subsequent nodes startup with a lot of
these
>> >>>> errors:
>> >>>>>
>> >>>>> 14.08.2010 09:04:17.504 *ERROR* [Repository Pinger]
>> >>>>> org.apache.sling.jcr.jackrabbit.server acquireRepository: Repository
>> >>>> problem
>> >>>>> starting repository from
>> >> file:/home/chall/sling/jackrabbit/repository.xml
>> >>>> in
>> >>>>> /home/chall/sling/jackrabbit (javax.jcr.RepositoryException:
failed
>> to
>> >>>>> instantiate shared item state manager)
>> javax.jcr.RepositoryException:
>> >>>> failed
>> >>>>> to instantiate shared item state manager
>> >>>>> at
>> >>>>>
>> >>>>
>> >>
>> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2052)
>> >>>>> at
>> >>>>>
>> >>>>
>> >>
>> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1997)
>> >>>>> at
>> >>>>>
>> >>>>
>> >>
>> org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:535)
>> >>>>> at
>> >>>>
>> >>
>> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:366)
>> >>>>> at
>> >>>>>
>> >>
>> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673)
>> >>>>> at
>> >>>>>
>> >>>>
>> >>
>> org.apache.sling.jcr.jackrabbit.server.impl.SlingServerRepository.acquireRepository(SlingServerRepository.java:141)
>> >>>>> ...
>> >>>>> Caused by: org.apache.jackrabbit.core.state.ItemStateException:
>> failed
>> >> to
>> >>>>> write bundle: cafebabe-cafe-babe-cafe-babecafebabe
>> >>>>> ...
>> >>>>> Caused by: org.apache.jackrabbit.core.state.ItemStateException:
>> failed
>> >> to
>> >>>>> write bundle: cafebabe-cafe-babe-cafe-babecafebabe
>> >>>>> ...
>> >>>>> Caused by: java.sql.SQLException: ORA-00001: unique constraint
>> >>>>> (SAWG_SSO_CLUSTER.DEFAULT_BUNDLE_IDX) violated
>> >>>>>
>> >>>>> To get around this, I copy the repository directory from the
first
>> node
>> >>>> to
>> >>>>> the other nodes and they are able to startup cleanly.  Is copying
>> >>>>> repository/ an expected step or am I missing something?
>> >>>>>
>> >>>>> 1 http://pastebin.com/Yc7PSb1n
>> >>>>
>> >>
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message