Elasticsearch Index Status is ‘yellow’ or ‘red’

WARNING
MySQL catalog search engine will be removed in Adobe Commerce 2.4.0. You must have Elasticsearch host setup and configured prior to installing version 2.4.0. Refer to Install and configure Elasticsearch.

The article provides a fix for when the Elasticsearch Index Status is not ‘green’. ‘yellow’ indicates normal, and ‘red’ indicates bad. The ‘yellow’ or ‘red’ status may occur in conjunction with missing products or the display of old product information.

Affected versions and products

  • Adobe Commerce on cloud infrastructure 2.2.x, 2.3.x
  • Adobe Commerce on-premise 2.2.x, 2.3.x

Issue

The Elasticsearch catalog search index is slow, resulting in a status of ‘yellow’ or ‘red’ rather than ‘green’. You may also experience missing changes on the frontend.

Cause

There can be several potential causes. One cause is the Elasticsearch instance running out of disk space. Another cause is duplicated indices.

Solution

Create a fresh mysql dump before following these steps and perform them outside of business hours to avoid potentially affecting your clients:

  1. Switch temporarily to MySQL search – enable MySQL search. (Note: Remember to switch back to Elasticsearch or you may experience performance issues).

  2. To identify duplicated indexes run the following command:

    code language-none
    curl --silent -X GET localhost:9200/_cat/indices?v
    
  3. To delete indexes:

    code language-none
    curl -XDELETE localhost:9200/[your_index_name_here]
    
  4. Reenable Elasticsearch.

  5. Run full re-index.

  6. Check indexes status by running the following command:

    code language-none
    curl --silent -X GET localhost:9200/_cat/indices?v
    

If these steps don’t work, submit a support ticket.

To learn more, refer to Elasticsearch Cluster health API.

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a