ElasticSearch: fixed_interval problem with long intervals

[alimli]

What happened:
ES returned an error "Elasticsearch error: [1:517] [date_histogram] failed to parse field [fixed_interval]"

What you expected to happen:
Query result is returned without errors.

How to reproduce it (as minimally and precisely as possible):
When setting a "Min Interval" value less than 365days, it is working as expected.However if you sent a longer duration to "Min Interval" (e.g. 365d), the Interval is automatically converted to years. Accordingly ES returns an error because units up to days are supported for fixed_interval as explained here.

Anything else we need to know?:

Environment:

• Grafana version: 9.1.0
• Data source type & version: ES 7.10+
• OS Grafana is installed on: Ubuntu 20.04
• User OS & Browser: MacOS & Firefox
• Grafana plugins: CompareQueries plugin but looks unrelated
• Others:

[gabor]

hi @alimli , this is fixed now, should be available in Grafana9.1.2 .