AnsweredAssumed Answered

Cannot reindex existing content in Solr 4

Question asked by pamaho on Apr 10, 2015
Latest reply on Apr 14, 2015 by pamaho
I have upgraded from v4.2.e to v5.0.d and when I try to reindex the old installation content I get this error. I don't know what to do, I've tried everything, but am stuck here since last week.

INFORMACIÓN: Server startup in 211764 ms
2015-04-09 21:24:37,873  INFO  [web.site.EditionInterceptor] [http-bio-8080-exec-1] Successfully retrieved license information from Alfresco.
2015-04-09 21:25:42,997  ERROR [extensions.webscripts.AbstractRuntime] [http-bio-8443-exec-16] Exception from executeScript - redirecting to status template error: 03090001 Wrapped Exception (with status template): nested exception is

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.InvalidClassException: java.util.ArrayList; serializable and externalizable flags conflict
### The error may exist in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### SQL: select             node.id                 as node_id,             node.version            as node_version,             prop.qname_id           as qname_id,             prop.locale_id          as locale_id,            

prop.list_index         as list_index,             prop.actual_type_n      as actual_type_n,             prop.persisted_type_n   as persisted_type_n,             prop.boolean_value      as boolean_value,             prop.long_value     

   as long_value,             prop.float_value        as float_value,             prop.double_value       as double_value,             prop.string_value       as string_value,             prop.serializable_value as serializable_value   

           from             alf_node node             join alf_node_properties prop on (prop.node_id = node.id)          WHERE  node_id in                  (                     ?                 ,                     ?                

,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?             

   ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?          

      ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?       

         ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?    

            ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ? 

               ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                    

?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                 

   ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,              

      ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,           

         ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,        

            ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,     

               ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,  

                  ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                

,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?             

   ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?          

      ,                     ?                 ,                     ?                 ,                     ?                 )

Caused by: org.alfresco.error.AlfrescoRuntimeException: 03090059 Nodes with no type are ignored by SOLR
        at org.alfresco.repo.solr.SOLRTrackingComponentImpl.getNodesMetadata(SOLRTrackingComponentImpl.java:793)
        at sun.reflect.GeneratedMethodAccessor534.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at com.sun.proxy.$Proxy167.getNodesMetadata(Unknown Source)
        at org.alfresco.repo.web.scripts.solr.NodesMetaDataGet.executeImpl(NodesMetaDataGet.java:184)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.executeImpl(DeclarativeWebScript.java:235)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
        … 32 more
2015-04-09 21:25:47,795  ERROR [extensions.webscripts.AbstractRuntime] [http-bio-8443-exec-11] Exception from executeScript - redirecting to status template error: 03090005 Wrapped Exception (with status template): nested exception is

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.InvalidClassException: java.util.ArrayList; serializable and externalizable flags conflict
### The error may exist in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### SQL: select             node.id                 as node_id,             node.version            as node_version,             prop.qname_id           as qname_id,             prop.locale_id          as locale_id,            

prop.list_index         as list_index,             prop.actual_type_n      as actual_type_n,             prop.persisted_type_n   as persisted_type_n,             prop.boolean_value      as boolean_value,             prop.long_value     

   as long_value,             prop.float_value        as float_value,             prop.double_value       as double_value,             prop.string_value       as string_value,             prop.serializable_value as serializable_value   

           from             alf_node node             join alf_node_properties prop on (prop.node_id = node.id)          WHERE prop.node_id = ?

Outcomes