Rebuilding indexes does not work 'as fine as it did

miguel_gil_mart — Fri, 17 Aug 2007 09:25:40 GMT

Hello.I have been "losing users" for a few of days. When I tried to log in as an user, Alfresco said that this user did not exist. I rebuilt indexes and Alfresco worked right. Yesterday I tried to log in as admin and system rejected me. I tried to log in as another user and it was impossible. Some o

Re: Rebuilding indexes does not work 'as fine as it did

andy — Wed, 05 Sep 2007 11:08:04 GMT

Hi

From a quick look I do not see an obvious issue in the code.

Have you got custom models defined?
What database are you using?

ndy

Re: Rebuilding indexes does not work 'as fine as it did

miguel_gil_mart — Wed, 05 Sep 2007 11:34:13 GMT

Hi

From a quick look I do not see an obvious issue in the code.

Have you got custom models defined?
What database are you using?

ndy

Yes, I have custom models,… and they work very fine. I am using MySQL 5.
I resolved my problem recovering repository and migrating to 2.1. I wrote a PHP script to rebuild Alfresco folders to a 'real' folder tree. As you know, Alfresco uses /year/month/day/hour/min to save files. Well, I have written a PHP script to search in database and restore these files to 'space=directory' folder tree. I will upload this script to alfresco forge as soon as I can.
Thank you for your help.

Re: Rebuilding indexes does not work 'as fine as it did

vycitalr — Wed, 26 Sep 2007 18:39:58 GMT

Hello,
I have a similliar problem. I am running sort of user synchronization, where I create, delete, update and move users among groups. There are
few big groups that should contain a lot of users. Simply said, I iterate through current alfresco users (I have them in hashtable,
there areabout 20000 of them) and process them one by one. This processing is mostly an update of its data (firstname, lastname etc) and moving from/to groups. This processing for one user is happening in one transaction. So typically there is one (or none) call to PersonService.setPersonProperties()
and several calls to AuthorityDAO.addAuthority(String parentName, String childName) and AuthorityService.removeAuthority(groupName, userName) in the transaction, and this is executed in a loop for all users.

This works fine from the begining, some users (eg hundreds) are processed and then I get the following exception:


2007-09-26 17:53:21,952 DEBUG [com.cleverbee.alfsynchro.backend.AlfrescoManager] updateGroupMemebershipForUser(, userName=bartajir
2007-09-26 17:53:21,953 DEBUG [com.cleverbee.alfsynchro.backend.AlfrescoManager] addMemberToGroup(), group=Z-Ãƒâ€žÃ…Å¡VUT <= bartajir
2007-09-26 17:53:22,646 DEBUG [com.cleverbee.alfsynchro.backend.AlfrescoManager] findActualMembershipForUser(, userName=holoutat
2007-09-26 17:53:22,660 DEBUG [com.cleverbee.alfsynchro.backend.AlfrescoManager] updateGroupMemebershipForUser(, userName=holoutat
2007-09-26 17:53:22,660 DEBUG [com.cleverbee.alfsynchro.backend.AlfrescoManager] addMemberToGroup(), group=Z-Ãƒâ€žÃ…Å¡VUT <= holoutat
2007-09-26 17:53:22,677 ERROR [com.cleverbee.alfsynchro.backend.AlfrescoManager] Unexepcted error:
java.lang.NullPointerException
   at org.alfresco.repo.domain.PropertyValue$ValueType.convert(PropertyValue.java:331)
   at org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:771)
   at org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:689)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperty(DbNodeServiceImpl.java:963)
   at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy2.getProperty(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy3.getProperty(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:145)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy2.getProperty(Unknown Source)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.addAuthority(AuthorityDAOImpl.java:121)
   at com.cleverbee.alfsynchro.backend.AlfrescoManager.addAuthority(AlfrescoManager.java:930)
   at com.cleverbee.alfsynchro.backend.AlfrescoManager.addMemberToGroup(AlfrescoManager.java:900)
   at com.cleverbee.alfsynchro.backend.AlfrescoManager.updateGroupMemebershipForUser(AlfrescoManager.java:621)
   at com.cleverbee.alfsynchro.backend.SynchManager.processActive(SynchManager.java:226)
   at com.cleverbee.alfsynchro.backend.SynchManager.refreshMembershipInternal(SynchManager.java:592)
   at com.cleverbee.alfsynchro.backend.SynchManager.refreshMembershipFull_new(SynchManager.java:422)
   at com.cleverbee.alfsynchro.backend.SynchManager.refreshMembershipFull(SynchManager.java:630)
   at com.cleverbee.alfsynchro.webclient.ClbAdminBean.mainAction(ClbAdminBean.java:91)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
   at javax.faces.component.UICommand.broadcast(UICommand.java:89)
   at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
   at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
   at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
   at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
   at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.alfresco.web.app.servlet.AdminAuthenticationFilter.doFilter(AdminAuthenticationFilter.java:80)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
   at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
   at java.lang.Thread.run(Thread.java:595)

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

After examination I found that corrupted data in DB, given by this query (which I think should return no data):

select * from alf_node_properties where
qname = '{http://www.alfresco.org/model/user/1.0}members'
and serializable_value is null

But in my case it does return data. I suppose, if there exists the '{http://www.alfresco.org/model/user/1.0}members' for a node,
it is expected the serializable_value contains somewhat encoded members, but I have it here null.
When I looked at these appropriate groups via web-client I got the same error. Also a FULL reinedex could NOT be run as well. If I deleted the results of the query above I could run the FULL reindex, see the groups (empty) and re-run my process. But after a while it got corrupted again.

Another issue is, this happened repeatedly on linux machine with oracle DB, but I did not meet with this on Windows (with oracle). But this might be only a coincidence.

From my point of view, I just call alfresco's api in a loop, and cannot find a problem in my code.
I am using Alfresco 2.1 Comunity Edition with Oracle database.

This is quite an urgent issue. Thank you very much for any comments.

topic Rebuilding indexes does not work 'as fine as it did in Alfresco Archive

Rebuilding indexes does not work 'as fine as it did

Re: Rebuilding indexes does not work 'as fine as it did

Re: Rebuilding indexes does not work 'as fine as it did

Re: Rebuilding indexes does not work 'as fine as it did