Error while running script in elastic search , gateway timeout

Question

while running script in elastic search, I got 504 Gateway timeout error.

 {
      "query": {
        "bool": {
          "filter": {
            "script": {
              "script": " doc['creted_date'].date.getMonthOfYear() == 12 "
            }
          }
        }
      },
      "aggs": {
        "test": {
          "date_histogram": {
            "field": "creted_date",
            "interval": "month",
            "format": "MMM"

          },
          "aggs": {
            "cost": {
              "sum": {
                "field": "cost"
              }
            }
          }
        }
      }
    }

Error result :

 {
      "statusCode": 504,
      "error": "Gateway Time-out",
      "message": "Client request timeout"
    }

whenever I am running this script over index having small number of documents , it gives perfect output. but on index having large number of documents , it gives above error.

Can we manually set the timeout for request in elastic search ? or Is there any other solution for this problem ?

score -1 · Answer 1 · answered Sep 24 '18 at 11:16

-1

Try this.

{
  "query": {
    "bool": {
      "filter": {
        "script": {
          "lang": "expression",
          "script": "doc['creted_date'].getMonth() == month-1",
          "params": {
            "month": 12
          }
        }
      }
    }
  }
}

answered Sep 24 '18 at 11:16

Ashwani Shakya

419
4
11

not working ."type": "parsing_exception", "reason": "[script] query does not support [lang]" – kavi Sep 24 '18 at 11:42
which Elasticsearch version you are using ? – Ashwani Shakya Sep 24 '18 at 11:44
I am using elastic search 6.0 – kavi Sep 24 '18 at 11:45
Ok. try my below answer for elasticsearch 6.x. – Ashwani Shakya Sep 24 '18 at 15:22
Thanks for reply.But there is no mistake in my query. Its perfect. The problem is the timeout for the query request in elastic search. Can we change the timeout ? Yes. then How ? – kavi Sep 25 '18 at 04:51

score -1 · Accepted Answer · answered Sep 24 '18 at 15:23

-1

Try this for Elasticsearch 6.x.

{
  "query": {
    "bool": {
      "filter": {
        "script": {
          "script": {
            "source":  "doc['created_on'].date.getMonthOfYear() == params.month",
              "params": {
                "month": 5
              }
          }
        }
      }
    }
  }
}

answered Sep 24 '18 at 15:23

Ashwani Shakya

419
4
11

1

I am not asking for the query. My query is perfectly working for the index having small no of documents. But the problem is timeout. Is there any configuration we need to do in elastic search ? – kavi Sep 25 '18 at 04:54
It's not what kavi was asking about. – Petr Aleksandrov Apr 26 '22 at 17:54

Error while running script in elastic search , gateway timeout

2 Answers2