We are developing custom search interfaces in Alfresco Share and we found following issue when ordering results by “cm:versionLabel” property.

The problem can be reproduced by running following sentence.

$ curl -X GET \
  'http://localhost/alfresco/s/slingshot/search?filters=&term=%2A&sort=cm%3AversionLabel%7Ctrue&alf_ticket=TICKET_e1e841e4cfcdde43fe4154c6e8687b89b6541e77' \
  -H 'Authorization: Basic YWRtaW46YWRtaW4='

This query returns 0 results, while the following one (ordering by "cm:name")…

$ curl -X GET   'http://localhost/alfresco/s/slingshot/search?filters=&term=%2A&sort=cm%3Aname%7Ctrue&alf_ticket=TICKET_e1e841e4cfcdde43fe4154c6e8687b89b6541e77’
  -H 'Authorization: Basic YWRtaW46YWRtaW4=‘

… returns the expected results.

Following complain is found at SOLR 6 log file.

solr6_1_6acc8b8daca2 | 2018-11-23 14:27:13.392 ERROR (qtp1205044462-12) [   x:alfresco] o.a.s.s.HttpSolrCall null:java.lang.IllegalStateException: unexpected docvalues type SORTED_SET for field 'text@s__lt@{http://www.alfresco.org/model/content/1.0}versionLabel' (expected=SORTED). Re-index with correct docvalues type.
solr6_1_6acc8b8daca2 | at org.apache.lucene.index.DocValues.checkField(DocValues.java:212)
solr6_1_6acc8b8daca2 | at org.apache.lucene.index.DocValues.getSorted(DocValues.java:264)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.FieldComparator$TermOrdValComparator.getSortedDocValues(FieldComparator.java:762)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.FieldComparator$TermOrdValComparator.getLeafComparator(FieldComparator.java:767)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.FieldValueHitQueue.getComparators(FieldValueHitQueue.java:180)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.TopFieldCollector$SimpleFieldCollector.getLeafCollector(TopFieldCollector.java:100)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.MultiCollector.getLeafCollector(MultiCollector.java:121)
solr6_1_6acc8b8daca2 | at org.apache.solr.search.DelegatingCollector.doSetNextReader(DelegatingCollector.java:79)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.SimpleCollector.getLeafCollector(SimpleCollector.java:33)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:659)
solr6_1_6acc8b8daca2 | at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:472)
solr6_1_6acc8b8daca2 | at org.apache.solr.search.SolrIndexSearcher.buildAndRunCollectorChain(SolrIndexSearcher.java:217)
solr6_1_6acc8b8daca2 | at org.apache.solr.search.SolrIndexSearcher.getDocListAndSetNC(SolrIndexSearcher.java:1678)
solr6_1_6acc8b8daca2 | at org.apache.solr.search.SolrIndexSearcher.getDocListC(SolrIndexSearcher.java:1395)
solr6_1_6acc8b8daca2 | at org.apache.solr.search.SolrIndexSearcher.search(SolrIndexSearcher.java:566)
solr6_1_6acc8b8daca2 | at org.apache.solr.handler.component.QueryComponent.process(QueryComponent.java:545)
solr6_1_6acc8b8daca2 | at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:351)
solr6_1_6acc8b8daca2 | at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:173)
solr6_1_6acc8b8daca2 | at org.apache.solr.core.SolrCore.execute(SolrCore.java:2477)
solr6_1_6acc8b8daca2 | at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:723)
solr6_1_6acc8b8daca2 | at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:529)
solr6_1_6acc8b8daca2 | at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:361)
solr6_1_6acc8b8daca2 | at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:305)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1691)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:582)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.Server.handle(Server.java:534)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
solr6_1_6acc8b8daca2 | at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
solr6_1_6acc8b8daca2 | at java.lang.Thread.run(Thread.java:748)

It seems like there is some problem with “cm:labelVersion” indexation, but don’t identify differences with the other properties indexed.

We made the same test using SOLR 4 and the query works as expected. So it looks like it’s a SOLR 6 related problem.