713210 - APPS- Unexpected error when trying to sort the apps by name.

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Search, defect, P2)

Description

[Victor Carciu]

Attachment: Attachment

Prerequisites:
FF9

Steps to reproduce:
1.Go to APPS home page in production : https://apps-preview.mozilla.org/
2.Sign in with some valid credentials
3.Type a broad search criteria into the "search for apps" text field(i.e. do a blank search).
4.Try to sort the apps by "More-Name"

Expected results:
Apps are sorted by name without any issue

Actual results:
An error is displayed and apps are not sorted. 
Please see the attached screenshot.

Comment 1

[Christopher Van Wiemeersch [:cvan]]

Traceback:
Failed to execute phase [query], total failure; shardFailures {[1o-efU8BRiCoZ5NiBkkgUw][addons_appspreview][1]: RemoteTransportException[[Infinity][inet[/10.8.81.68:9300]][search/phase/query]]; nested: QueryPhaseExecutionException[[addons_appspreview][1]: query[ConstantScore(*:*)],from[0],size[20],sort[<custom:"name_sort": org.elasticsearch.index.field.data.strings.StringFieldDataType$1@30d8d8d5>]: Query Failed [Failed to execute main query]]; nested: IOException[Can't sort on string types with more than one value per doc, or more than one token per field]; }{[doLwowxQT2yRJMbdQBkulw][addons_appspreview][3]: RemoteTransportException[[Druid][inet[/10.8.81.67:9300]][search/phase/query]]; nested: QueryPhaseExecutionException[[addons_appspreview][3]: query[ConstantScore(*:*)],from[0],size[20],sort[<custom:"name_sort": org.elasticsearch.index.field.data.strings.StringFieldDataType$1@13676fca>]: Query Failed [Failed to execute main query]]; nested: IOException[Can't sort on string types with more than one value per doc, or more than one token per field]; }{[1o-efU8BRiCoZ5NiBkkgUw][addons_appspreview][0]: RemoteTransportException[[Infinity][inet[/10.8.81.68:9300]][search/phase/query]]; nested: QueryPhaseExecutionException[[addons_appspreview][0]: query[ConstantScore(*:*)],from[0],size[20],sort[<custom:"name_sort": org.elasticsearch.index.field.data.strings.StringFieldDataType$1@3c5d654d>]: Query Failed [Failed to execute main query]]; nested: IOException[Can't sort on string types with more than one value per doc, or more than one token per field]; }{[doLwowxQT2yRJMbdQBkulw][addons_appspreview][2]: RemoteTransportException[[Druid][inet[/10.8.81.67:9300]][search/phase/query]]; nested: QueryPhaseExecutionException[[addons_appspreview][2]: query[ConstantScore(*:*)],from[0],size[20],sort[<custom:"name_sort": org.elasticsearch.index.field.data.strings.StringFieldDataType$1@7bda794>]: Query Failed [Failed to execute main query]]; nested: IOException[Can't sort on string types with more than one value per doc, or more than one token per field]; }{[doLwowxQT2yRJMbdQBkulw][addons_appspreview][4]: RemoteTransportException[[Druid][inet[/10.8.81.67:9300]][search/phase/query]]; nested: QueryPhaseExecutionException[[addons_appspreview][4]: query[ConstantScore(*:*)],from[0],size[20],sort[<custom:"name_sort": org.elasticsearch.index.field.data.strings.StringFieldDataType$1@1f50dcfa>]: Query Failed [Failed to execute main query]]; nested: IOException[Can't sort on string types with more than one value per doc, or more than one token per field]; }

http://arecibo1.dmz.phx1.mozilla.com/view/152088/

Somehow, this works fine on -dev: https://apps-preview-dev.allizom.org/en-US/apps/search/?sort=name

Comment 2

[Christopher Van Wiemeersch [:cvan]]

https://github.com/mozilla/zamboni/commit/84184ec

Pushed changes to our elasticsearch admin tool that allows us to rebuild the index and redo the mapping. Will close this once we do an apps-preview push and I recreate the index.

Comment 3

[Christopher Van Wiemeersch [:cvan]]

https://apps-preview.mozilla.org/en-US/apps/search/?sort=name

Works now!

Comment 4

[Victor Carciu]

Verified as fixed.

Comment 5

[Victor Carciu]

Attachment: Postfix screenshot.