On 26 Feb 2010, at 08:16, Martinez, Antonio (Antonio) wrote: > 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.
AFAIK it does not, to do that you need to snapshot the jackrabbit disk area on a local machine and truncate the table upto the point of the snapshot. If you don't take a snapshot, new app servers joining the cluster wont be able to build their lucene indexes. ian > > 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
