jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dominique Pfister" <dominique.pfis...@day.com>
Subject Re: Clustering problem using DB
Date Tue, 05 Jun 2007 14:06:41 GMT
Hi Luca,

looking at the root cause, I can only guess that somehow the Oracle
JDBC connection has been dropped, possibly because some timeout
elapsed or due to some network glitch. Is the error reproduceable on
every try? Or does it only happen after some time of inactivity has
passed?

Kind regards
Dominique

On 6/5/07, Luca Fiscato <luca.fiscato@eng.it> wrote:
> Hi Dominique,
>
> thanks for your reply,
>
> the entire exception is reported  below (at the end there's the cause
> exception)
> I hope it will be usefull.
>
> Cheers
> Luca
>
>
> Unable to create log entry.
> org.apache.jackrabbit.core.journal.JournalException: Unable to set
> autocommit to
>  false.
>         at
> org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJou
> rnal.java:227)
>         at
> org.apache.jackrabbit.core.journal.AbstractJournal.lockAndSync(Abstra
> ctJournal.java:238)
>         at
> org.apache.jackrabbit.core.journal.DefaultRecordProducer.append(Defau
> ltRecordProducer.java:51)
>         at
> org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel
> .updateCreated(ClusterNode.java:466)
>         at
> org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(
> SharedItemStateManager.java:530)
>         at
> org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(S
> haredItemStateManager.java:825)
>         at
> org.apache.jackrabbit.core.state.SharedItemStateManager.update(Shared
> ItemStateManager.java:855)
>         at
> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalIt
> emStateManager.java:326)
>         at
> org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStat
> eManager.java:313)
>         at
> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalIt
> emStateManager.java:302)
>         at
> org.apache.jackrabbit.core.state.SessionItemStateManager.update(Sessi
> onItemStateManager.java:306)
>         at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1214)
>         at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:849)
>
> ...... tomcat stacktrace
>
> Caused by: java.sql.SQLException: Eccezione IO: Software caused
> connection abort
> : socket write error
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
>         at
> oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.ja
> va:1260)
>         at
> org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJou
> rnal.java:224)
>         ... 95 more
> 10:45:02,131 [ClusterNode-node2] ERROR ClusterNode : Periodic sync of
> journal fa
> iled: Unable to return record iterater.
> 10:45:16,362 [ClusterNode-node2] ERROR ClusterNode : Periodic sync of
> journal fa
> iled: Unable to return record iterater.
> 10:45:35,179 [ClusterNode-node2] ERROR ClusterNode : Periodic sync of
> journal fa
> iled: Unable to return record iterater.
> 10:45:40,196 [ClusterNode-node2] ERROR ClusterNode : Periodic sync of
> journal fa
> iled: Unable to return record iterater.
>
>
>
>
>
>
> Dominique Pfister ha scritto:
> > Hi Luca,
> >
> > the actual SQL exception that caused this exception is contained as
> > "cause" in this JournalException and should therefore be reported as
> > well. This might shed more light on the issue you're experiencing.
> >
> > Kind regards
> > Dominique
> >
> > On 6/4/07, Luca Fiscato <luca.fiscato@eng.it> wrote:
> >> Hi all,
> >>
> >> I tried to configure Jackrabbit in a cluster environment.
> >> First I configure it to store the journal into File System and it
> >> worked.
> >> Then, since I don't want to use the file system, I tried to configure it
> >> using a database for the journal.
> >> I tried with mysql and oracle but it doesn't work, the exception is
> >> reported below.
> >> Anyone knows the problem ? Maybe a configuration problem ?
> >>
> >> Thanks
> >> Luca
> >>
> >> 10:28:05,199 [http-9090-Processor23] ERROR
> >> ClusterNode$WorkspaceUpdateChannel :
> >> Unable to create log entry.
> >> org.apache.jackrabbit.core.journal.JournalException: Unable to set
> >> autocommit to false.
> >>        at
> >> org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJou
> >> rnal.java:227)
> >>        at
> >> org.apache.jackrabbit.core.journal.AbstractJournal.lockAndSync(Abstra
> >> ctJournal.java:238)
> >>        at
> >> org.apache.jackrabbit.core.journal.DefaultRecordProducer.append(Defau
> >> ltRecordProducer.java:51)
> >>        at
> >> org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel
> >> .updateCreated(ClusterNode.java:466)
> >>        at
> >> org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(
> >> SharedItemStateManager.java:530)
> >>        at
> >> org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(S
> >> haredItemStateManager.java:825)
> >>        at
> >> org.apache.jackrabbit.core.state.SharedItemStateManager.update(Shared
> >> ItemStateManager.java:855)
> >>        at
> >> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalIt
> >> emStateManager.java:326)
> >>        at
> >> org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStat
> >> eManager.java:313)
> >>        at
> >> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalIt
> >> emStateManager.java:302)
> >>        at
> >> org.apache.jackrabbit.core.state.SessionItemStateManager.update(Sessi
> >> onItemStateManager.java:306)
> >>        at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1214)
> >>        at
> >> org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:849)
> >>        at
> >> it.eng.spago.cms.exec.DeleteObjectImpl.execute(DeleteObjectImpl.java:
> >> 80)
> >>        at
> >> it.eng.spago.cms.exec.InProcessOperationExecutor.doDeleteOperation(In
> >>
> >>
> >>
> >>
> >
> >
>
>

Mime
View raw message