Details about this thread
  • State Verified Answer
  • Replies 10 replies
  • Subscribers 317 subscribers
  • Views 7855 views
  • Users 0 members are here

ELASTIC SEARCH->SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures

sidhu sidhu

Hi All,

           I was trying to make the global search work for my crm version 7.7x

when i click on the test in the crm admin->search i get a popup like 'do system indexing'.

I have set up a cron for every five minutes and done indexing

The thing is i am unable to figure out if the

1.indexing is done or not.

2.i am getting SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures

Elastic search is not returning any records in the global search and when i click on the full search icon on global search i get the SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures.

I am in very bad need to fix this and any help would make my day. Tevfik Tümer Lori F 

Regards

Sidhu

Parents
  • 0 Sugar Employee Badge

    Take a look at your config.php file and copy the value for the entry labeled 'unique_key.'

    Assuming you are at a machine that should be able to directly access Elasticsearch, open your browser and go to:

    http://{your_elastic_address}:9200/{unique_key}/_status

    That would at least help you take a look at the index to see if it actually indexed.

    I would also recommend that you check the amount of free disk space available on the Elasticsearch servers. You should allocate approximately 2.5 times the size of the Sugar database.

  • 0 in reply to Angel Magana

    Hi Angel Magana

    unique key is 769027ef17559b741fc2b2670e97c

    I have performed a system indexing

    I dont think it has changed as i get the following.

                I get this Result:{"error":"IndexMissingException[[769027ef17559b741fc2b2670e97c] missing]","status":404}.

    When i have ran http://{your_elastic_address}:9200/{unique_key}/_status.

    Regards

    Sidhu

Reply Children
  • 0 Sugar Employee Badge in reply to sidhu sidhu

    My apologies, I noticed I had a typo in the URL I provided earlier. It should be /_stats at the end of the URL, versus /_status

    Also, the newer versions of Sugar use '{unique_key}_shared' as the name, where in the past we only used the unique key value. Thus it should actually be like this:

    http://{your_elastic_address}:9200/{unique_key}_shared/_stats

    Try making those two adjustments and if you get the same error, that would seem to indicate that the index did not get created.

    Sorry for the confusion, I didn't take into account the point about it being 7.7.