Hi all,
Recently I have upgraded from Alfresco community 5.0.b to 5.2 sucessfully. My current enviroment :
CentOS Linux release 7.3.1611 (Core)
Alfresco 5.2 community install from all-in-one alfresco-community-installer-201707-linux-x64.bin
mysql-community-server-5.7.31-1.el7.x86_64
Alfresco Search Services 1.2.0.1 using Apache Solr 6.6.0 , installation follow https://docs.alfresco.com/search-community/tasks/solr-install-withoutSSL.html
solr4 has been disabled , removed indexes.
I actually only use Alfresco content management feature at simple level : Scanner capture a specific area on document then create pdf file with unique file name. upload soft files from scanner to ECM , store and search them later when needed.
Alfresco and search service are started successfully athough there are some error in solr.log
2020-10-30 05:14:02.023 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@7b993c65_Worker-29) [ ] o.a.s.t.AbstractTracker Tracking failed for AclTracker - archive
java.net.SocketException: Connection reset
2020-10-30 05:14:02.375 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@7b993c65_Worker-11) [ ] o.a.s.t.AbstractTracker Tracking failed for MetadataTracker - archive
java.io.IOException: org.alfresco.solr.TrackerStateException: 09300000 The trackers work was rolled back by another tracker error
at org.alfresco.solr.tracker.MetadataTracker.trackTransactions(MetadataTracker.java:758)
at org.alfresco.solr.tracker.MetadataTracker.trackRepository(MetadataTracker.java:185)
at org.alfresco.solr.tracker.MetadataTracker.doTrack(MetadataTracker.java:113)
at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:215)
at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.solr.TrackerStateException: 09300000 The trackers work was rolled back by another tracker error
at org.alfresco.solr.SolrInformationServer.canUpdate(SolrInformationServer.java:4029)
at org.alfresco.solr.SolrInformationServer.indexTransaction(SolrInformationServer.java:3607)
at org.alfresco.solr.tracker.MetadataTracker.indexTransactionsAfterAsynchronous(MetadataTracker.java:791)
at org.alfresco.solr.tracker.MetadataTracker.trackTransactions(MetadataTracker.java:749)
... 6 moreNewest files which are upload after using 5.2 can be searched with filename successfully.
But old files , which older than 1 month cannot be searched (no result)
These are some screenshots about my solr6
I found a similar case , so I tried to force solr6 to perform a full index , I update the alfresco-search-services/solrhome/conf/shared.properties (uncomment)
alfresco.suggestable.property.0={http://www.alfresco.org/model/content/1.0}name
alfresco.suggestable.property.1={http://www.alfresco.org/model/content/1.0}title
alfresco.suggestable.property.2={http://www.alfresco.org/model/content/1.0}description
alfresco.suggestable.property.3={http://www.alfresco.org/model/content/1.0}contentstop solr6 rm -f /opt/alfresco-search-services/solrhome/archive/index/* rm -f /opt/alfresco-search-services/solrhome/alfresco/index/* rm -f /opt/alfresco-search-services/solrhome/alfrescoModels/* rm -rf /opt/alfresco-search-services/contentstore/_DEFAULT_/db/* start solr6
After restart solr6 , it consumes CPU load for awhile (solr6 perform full index) , when CPU load back to normal (full index done) , I try to search old file again, but still no result , here screenshots
Please help.
1 ACCEPTED ANSWER
Hi kaynezhang, thanks for your reply.
I will try alfresco search service 1.4 next week, but I read this https://docs.alfresco.com/5.2/concepts/supported-platforms-ACS.html , Alfresco 5.2 only support alfresco search service 1.3 maximum ?
For now I'm back to solr4 , it takes several days to index full (not finished yet), here some screenshot :
After restart solr6 + alfresco and force index full again yesterday, the solr results looked much better
# I uncomment these options in /opt/alfresco-search-services/solrhome/conf/shared.properties
# Data types that support cross locale/word splitting/token patterns if tokenised
alfresco.cross.locale.datatype.0={http://www.alfresco.org/model/dictionary/1.0}text
alfresco.cross.locale.datatype.1={http://www.alfresco.org/model/dictionary/1.0}content
alfresco.cross.locale.datatype.2={http://www.alfresco.org/model/dictionary/1.0}mltext
But the search results still do not satisfy me, should I wait longer so solr6 index all my files ? Or restart alfresco and solr6 again ?
Can anyone help me with this issue ? Alfresco search service does not work correctly cause huge trouble to us since we have million documents in repository and we cannot find correct one when we need, for example you can see these screenshots and solr6 query result:
{
"responseHeader":{
"status":0,
"QTime":1,
"params":{
"q":"FVNSGN102000374410",
"indent":"on",
"wt":"json",
"_":"1604305060927"}},
"_original_parameters_":{
"q":"FVNSGN102000374410",
"defType":"afts",
"df":"suggest",
"indent":"on",
"echoParams":"explicit",
"rows":"10",
"wt":"json",
"_":"1604305060927"},
"_field_mappings_":{},
"_date_mappings_":{},
"_range_mappings_":{},
"_pivot_mappings_":{},
"_interval_mappings_":{},
"_stats_field_mappings_":{},
"_stats_facet_mappings_":{},
"_facet_function_mappings_":{},
"lastIndexedTx":8006076,
"lastIndexedTxTime":1604306057527,
"txRemaining":0,
"response":{"numFound":0,"start":0,"docs":[]
},
"processedDenies":false}
I can view my document , but the search result return is differrent.
And this is another case, newer file , result return correctly
{
"responseHeader":{
"status":0,
"QTime":2,
"params":{
"q":"FVNSGN102000438410",
"indent":"on",
"wt":"json",
"_":"1604305060927"}},
"_original_parameters_":{
"q":"FVNSGN102000438410",
"defType":"afts",
"df":"suggest",
"indent":"on",
"echoParams":"explicit",
"rows":"10",
"wt":"json",
"_":"1604305060927"},
"_field_mappings_":{},
"_date_mappings_":{},
"_range_mappings_":{},
"_pivot_mappings_":{},
"_interval_mappings_":{},
"_stats_field_mappings_":{},
"_stats_facet_mappings_":{},
"_facet_function_mappings_":{},
"lastIndexedTx":8006042,
"lastIndexedTxTime":1604305498374,
"txRemaining":0,
"response":{"numFound":1,"start":0,"docs":[
{
"id":"_DEFAULT_!80000000000028d3!8000000002740221",
"_version_":0,
"DBID":41157153}]
},
"processedDenies":false}
Hi kaynezhang, thanks for your reply.
I will try alfresco search service 1.4 next week, but I read this https://docs.alfresco.com/5.2/concepts/supported-platforms-ACS.html , Alfresco 5.2 only support alfresco search service 1.3 maximum ?
For now I'm back to solr4 , it takes several days to index full (not finished yet), here some screenshot :
