Cannot reindex existing content in Solr 4

[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 = ?

[rjohnson]

I do not know if this is relevant or not, but when you did the upgrade did you go through each version 4.2e -> f -> 5.0a -> b -> c -> d

If you didn't this could (only could) be the issue.

[pamaho]

Thanks for your help. I upgraded from 4.2.e to 5.0.d directly, but I suppose that this is not relevant because I found this page in the documentation where explain the Upgrade paths.

http://docs.alfresco.com/5.0/concepts/upgrade-path.html

Sorry for my poor english.

[g_rathod]

Hi Pamaho,

Do one thing as you are upgrading from 4.x to 5.x , first step is to install vanilla 5.x installation wizard having both solr 1.4 (older that 4.x uses) and new one 4.2.

First enalble only older solr and sync all the stuff or index full.
Once you satisfied, disconnect and use new solr.

That may solve your problem.

[g_rathod]

Hi pamaho,

First of all index all your stuff using older solr 1.4.
Meanwhile you using solr 1.4, start sync on solr 4.2, once all index all synced, switch to new solr and disconnect older solr 1.4 from configuration.

Hope this helps.

[pamaho]

Thank you, I will try what you say and I tell you if I could resolve the problem.