<div dir="ltr">Hi Demian,<div><br></div><div>You need to configure your BRMS in clustering mode to use same database for two Guvnor repositories.</div><div><br></div><div>Thanks,</div><div>Srivats</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Sat, Nov 9, 2013 at 9:28 AM, Demian Calcaprina <span dir="ltr"><<a href="mailto:calcacuervo@gmail.com" target="_blank">calcacuervo@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi Guys,<div><br></div><div>I have two guvnor instances. They are using a mysql db repository. I would like both to point to the same database.</div><div><br></div><div>I configured them both to use the same database in the repository.xml, but it starting throwing errors and they were not in sync.</div>
<div><br></div><div>Errors are like this</div><div><br></div><div><div>11:43:29,597 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX 0:ffff7f000101:55ee0fc5:527e486a:3f in state RUN</div>
<div>11:43:29,599 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012095: Abort of action id 0:ffff7f000101:55ee0fc5:527e486a:3f invoked while multiple threads active within it.</div><div>11:43:29,601 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012108: CheckedAction::check - atomic action 0:ffff7f000101:55ee0fc5:527e486a:3f aborting with 1 threads active!</div>
<div>11:43:29,602 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff7f000101:55ee0fc5:527e486a:3f</div>
<div>11:44:37,245 INFO [org.apache.jackrabbit.core.query.lucene.IndexMerger] (jackrabbit-pool-5) merged 791 documents in 568 ms into _p.</div><div>11:44:37,377 INFO [org.apache.jackrabbit.core.query.lucene.IndexMerger] (jackrabbit-pool-2) merged 1370 documents in 709 ms into _o.</div>
<div>11:48:07,300 WARN [org.jboss.seam.transaction.TransactionServletListener] (http--127.0.0.1-8080-5) Error starting the transaction: javax.transaction.NotSupportedException: BaseTransaction.checkTransactionState - ARJUNA016051: thread is already associated with a transaction!</div>
<div><span style="white-space:pre-wrap"> </span>at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.begin(BaseTransaction.java:63)</div><div><span style="white-space:pre-wrap"> </span>at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.begin(BaseTransactionManagerDelegate.java:65)</div>
<div><span style="white-space:pre-wrap"> </span>at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.begin(ServerVMClientUserTransaction.java:142)</div><div><span style="white-space:pre-wrap"> </span>at org.jboss.seam.transaction.UTTransaction.begin(UTTransaction.java:51) [seam-transaction-3.1.0.Final.jar:3.1.0.Final]</div>
<div><span style="white-space:pre-wrap"> </span>at org.jboss.seam.transaction.DefaultSeamTransaction.begin(DefaultSeamTransaction.java:88) [seam-transaction-3.1.0.Final.jar:3.1.0.Final]</div><div><span style="white-space:pre-wrap"> </span>at org.jboss.seam.transaction.TransactionServletListener.requestInitialized(TransactionServletListener.java:110) [seam-transaction-3.1.0.Final.jar:3.1.0.Final]</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [jbossweb-7.0.13.Final.jar:]</div><div><span style="white-space:pre-wrap"> </span>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]</div><div><span style="white-space:pre-wrap"> </span>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]</div><div><span style="white-space:pre-wrap"> </span>at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]</div><div><span style="white-space:pre-wrap"> </span>at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]</div>
<div>Caused by: java.lang.IllegalStateException: BaseTransaction.checkTransactionState - ARJUNA016051: thread is already associated with a transaction!</div><div><span style="white-space:pre-wrap"> </span>at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.checkTransactionState(BaseTransaction.java:257)</div>
<div><span style="white-space:pre-wrap"> </span>at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.begin(BaseTransaction.java:59)</div><div><span style="white-space:pre-wrap"> </span>... 13 more</div>
<div><br></div><div>I also tried both instances to also share the repository folder, both this is failing because it lockes the file</div><div>Caused by: javax.jcr.RepositoryException: The repository home /home/calcacuervo/development appears to be in use since the file named .lock is locked by another process.</div>
<div><span style="white-space:pre-wrap"> </span>at org.apache.jackrabbit.core.util.RepositoryLock.tryLock(RepositoryLock.java:166)</div><div><br></div><div><br></div><div>Any idea on how could I do it?</div>
<div><br></div><div>Thanks!</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Demian </div></font></span></div></div>
<br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br></blockquote></div><br></div>