search

frappe / press

Full service cloud hosting for the Frappe stack - powers Frappe Cloud
https://frappe.cloud
GNU Affero General Public License v3.0
259 stars 187 forks source link

Elasticsearch 'hits' error: illegal_argument_exception: [match_phrase] requires query value #2106

Open casesolved-co-uk opened 1 month ago

casesolved-co-uk commented 1 month ago 
 File "apps/press/press/press/report/mariadb_slow_queries/mariadb_slow_queries.py", line 160, in get_slow_query_logs
      query = {'query': {'bool': {'filter': [{'exists': {'field': 'mysql.slowlog.query'}}, {'match_phrase': {'mysql.slowlog.schema': None}}, {'range': {'@timestamp': {'gt': '2024-08-23T19:52:31+00:00', 'lte': '2024-08-24T19:52:31+00:00'}}}]}}, 'size': 10}
      response = {'error': {'root_cause': [{'type': 'x_content_parse_exception', 'reason': '[1:124] [bool] failed to parse field [filter]'}], 'type': 'x_content_parse_exception', 'reason': '[1:124] [bool] failed to parse field [filter]', 'caused_by': {'type': 'illegal_argument_exception', 'reason': '[match_phrase] requires query value'}}, 'status': 400}
      out = []
builtins.KeyError: 'hits'