search_phase_execution_exception on "last_visit" query
https://sentry.softwareheritage.org/organizations/swh/issues/7036/?referrer=phabricator_plugin
Query: last_visit > 2021-01-01 or last_visit < 2020-01-01
RequestError: RequestError(400, 'search_phase_execution_exception', 'failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]: [failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]]')
(7 additional frame(s) were not displayed)
...
File "elasticsearch/client/utils.py", line 84, in _wrapped
return func(*args, params=params, **kwargs)
File "elasticsearch/client/__init__.py", line 811, in search
"GET", _make_path(index, "_search"), params=params, body=body
File "elasticsearch/transport.py", line 358, in perform_request
timeout=timeout,
File "elasticsearch/connection/http_urllib3.py", line 257, in perform_request
self._raise_error(response.status, raw_data)
File "elasticsearch/connection/base.py", line 182, in _raise_error
status_code, error_message, additional_info
RequestError(400, 'search_phase_execution_exception', 'failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]: [failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]]')
{error: {failed_shards: [{"index":"'origin-v0.11'","node":"'aWtTAVJtTf2Pw8xLPGQt3w'","reason":"{'type': 'parse_exception', 'reason': 'failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]: [failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]]', 'caused_by': {'type': 'illegal_argument_exception', 'reason': 'failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]', 'caused_by': {'type': 'date_time_parse_exception', 'reason': 'date_time_parse_exception: Failed to parse with all e...","shard":"0"}], grouped: True, phase: 'query', reason: 'all shards failed', root_cause: [{"reason":"'failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]: [failed to parse date field [2021-01-01 ] with format [strict_date_optional_time||epoch_millis]]'","type":"'parse_exception'"}], type: 'search_phase_execution_exception'}, status: 400}
Migrated from T3941 (view on Phabricator)