Hello, I found my the problem with the exception. Jackrabbit1.6 has an extra table CLUSTER_LOCAL_REVISIONS that I was not deleting (in case I want to delete all Jackrabbit information and start clean).
Still it would be good to know if Jackrabbit 1.6 takes care of limiting size of CLUSTER_JOURNAL table. Thank-you, Antonio -----Original Message----- From: Martinez, Antonio (Antonio) [mailto:[email protected]] Sent: Thursday, February 25, 2010 3:08 PM To: [email protected] Subject: Cluster table Hello, In Jackrabbit 1.4 the CLUSTER_JOURNAL table kept growing. I had some code to clean it up and leave only the last 1000 entries (in MySql) delete from IDM_JR_CLUSTER_JOURNAL where IDM_JR_CLUSTER_JOURNAL.REVISION_ID < (@CURRENT_ID - 1000) That has been working fine for long time. Now I'm moving to jackrabbit 1.6. I left the same code and after some time of activify I've seen the exceptions seen bellow. So the question is do I still need to delete entries from cluster table manually ? If so any idea what is the cause of this exception ? I also tried not limiting the size, but I have seen it increate at least to 10,000 entries, so I'm not sure if jackrabbit limits it at all. Thank you, Antonio 2010-02-25 09:17:24,624 INFO [IndexMerger]-[org.apache.jackrabbit.core.query.lucene.IndexMerger] merged 122 documents in 233 ms into _16o. 2010-02-25 09:17:31,253 WARN [jmssecondaryApplnJobExecutor-5]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,254 WARN [jmssecondaryApplnJobExecutor-10]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,623 WARN [jmssecondaryApplnJobExecutor-10]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,624 WARN [jmssecondaryApplnJobExecutor-8]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,859 WARN [jmssecondaryApplnJobExecutor-8]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,860 WARN [jmssecondaryApplnJobExecutor-4]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,881 WARN [jmssecondaryApplnJobExecutor-4]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,884 WARN [jmssecondaryApplnJobExecutor-2]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,912 WARN [jmssecondaryApplnJobExecutor-2]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,913 WARN [jmssecondaryApplnJobExecutor-6]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,929 WARN [jmssecondaryApplnJobExecutor-6]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:31,934 WARN [jmssecondaryApplnJobExecutor-1]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:31,955 WARN [jmssecondaryApplnJobExecutor-1]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2010-02-25 09:17:34,551 ERROR [jmssecondaryApplnJobExecutor-5]-[org.apache.jackrabbit.core.cluster.ClusterNode] Unable to create log entry. org.apache.jackrabbit.core.journal.JournalException: No revision available. at org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJournal.java:529) at org.apache.jackrabbit.core.journal.AbstractJournal.lockAndSync(AbstractJournal.java:255) at org.apache.jackrabbit.core.journal.DefaultRecordProducer.append(DefaultRecordProducer.java:51) at org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel.updateCreated(ClusterNode.java:602) at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:554) at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1085) at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1115) at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:351) at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:354) at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:326) at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:325) at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1111) at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:915) at org.apache.jackrabbit.jca.JCASessionHandle.save(JCASessionHandle.java:180) at com.alcatel.axs.app.idm.nelist.InventoryNeListServiceImpl.setCollectionStatus(InventoryNeListServiceImpl.java:268) at com.alcatel.axs.app.idm.nelist.InventoryNeListServiceImpl.collectionEnd(InventoryNeListServiceImpl.java:195) at com.alcatel.axs.app.idm.InventoryDiscoveryServiceImpl.doDiscoveryNow(InventoryDiscoveryServiceImpl.java:268) at sun.reflect.GeneratedMethodAccessor1057.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:36) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:243) at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1074) at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:955) at org.springframework.jmx.export.SpringModelMBean.invoke(SpringModelMBean.java:88) at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) at org.jboss.mx.modelmbean.RequiredModelMBeanInvoker.invoke(RequiredModelMBeanInvoker.java:127) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.server.jmx.LazyMBeanServer.invoke(LazyMBeanServer.java:291) at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288) at $Proxy594.doDiscoveryNow(Unknown Source) at com.alcatel.axs.app.idm.InventoryJob.execute(InventoryJob.java:41) at com.alcatel.axs.container.jobmanager.ManagedJob.run(ManagedJob.java:55) at com.alcatel.axs.container.jobmanager.JMSJobExecutor.onMessage(JMSJobExecutor.java:50) at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:531) at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:466) at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:435) at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:322) at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:260) at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:944) at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:868) at java.lang.Thread.run(Thread.java:619) 2010-02-25 09:17:34,554 WARN [jmssecondaryApplnJobExecutor-5]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record created. 2010-02-25 09:17:34,854 WARN [jmssecondaryApplnJobExecutor-5]-[org.apache.jackrabbit.core.cluster.ClusterNode] No record prepared. 2
