Kibana: Discover not showing histogram bars

[leandrojmp]

Kibana version: 7.5.0-1

Elasticsearch version: 7.5.0-1

Server OS version: CentOS 7.6

Browser version: Chrome 78.0.3904.108

Browser OS version: Ubuntu 18.10

Original install method (e.g. download page, yum, from source, etc.): yum

Describe the bug:
I updated the stack to 7.5 from 7.4 and discover is not showing the histogram bar anymore, I've tested with a data set with timestamp dates spanning years and if the difference from the start date and the end date is wide, it will only show histogram bars when scaling on years. It worked fine on 7.4

Steps to reproduce:

1. Load a dataset with a wide range of start and end dates.
2. Test the scale options (seconds, minutes, hours, daily, weekly, monthly, yearly)

Expected behavior:
Histogram bars rendered in the discover page.

Screenshots (if relevant):

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[timroes]

Hi,

could you please open your browsers dev tools (F12) and check if there are any errors on the "Console"?

Cheers,
Tim

[leandrojmp]

Hi,

could you please open your browsers dev tools (F12) and check if there are any errors on the "Console"?

Cheers,
Tim

I got these errors when selecting the interval that I want and trying to refresh.

[timroes]

cc @markov00 @rshen91

[markov00]

@leandrojmp could you please share the the request and the response of the failing rendering call? It's available from the top left button Inspect

You can omit the hits on the response and share only the aggregate. If that arise any privacy issue, you can just share the aggs query and the range filter on the request. It will appear something like

 "aggs": {
    "2": {
      "date_histogram": {
        "field": "timestamp",
        "calendar_interval": "1w",
        "time_zone": "Europe/Rome",
        "min_doc_count": 1
      }
    }
  },
...
"query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "match_all": {}
        },
        {
          "range": {
            "timestamp": {
              "gte": "2008-01-01T03:00:00.000Z",
              "lte": "2013-01-01T03:30:00.000Z",
              "format": "strict_date_optional_time"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  },

Thanks

[leandrojmp]

Hello,

I have more information about this issue.

My computer is configured to use the America/Sao_Paulo timezone (UTC -0300) and Kibana is using the default configuration for timezone, getting it from the Browser.

So I've made a little test and changed the Kibana timezone to UTC and it rendered the histogram, auto-scaled to 30d, I tested it changing the scale option and almost everything worked, except when I choosed to scale it by monthly, it did not rendered the histogram.

The gif below show this behavior, when the Kibana timezone is set to UTC.

Below is the request made by kibana, I compared the request made using the Browser timezone and the one made using UTC timezone and the only difference is in the time_zone field and in the lte field in the range filter.

{
  "version": true,
  "size": 500,
  "sort": [
    {
      "@timestamp": {
        "order": "desc",
        "unmapped_type": "boolean"
      }
    }
  ],
  "_source": {
    "excludes": []
  },
  "aggs": {
    "2": {
      "date_histogram": {
        "field": "@timestamp",
        "fixed_interval": "30d",
        "time_zone": "America/Sao_Paulo",
        "min_doc_count": 1
      }
    }
  },
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    {
      "field": "@timestamp",
      "format": "date_time"
    },
    {
      "field": "created_at",
      "format": "date_time"
    }
  ],
  "query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "match_all": {}
        },
        {
          "range": {
            "@timestamp": {
              "format": "strict_date_optional_time",
              "gte": "2008-01-01T03:00:00.000Z",
              "lte": "2019-12-10T23:08:42.469Z"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  },
  "highlight": {
    "pre_tags": [
      "@kibana-highlighted-field@"
    ],
    "post_tags": [
      "@/kibana-highlighted-field@"
    ],
    "fields": {
      "*": {}
    },
    "fragment_size": 2147483647
  }
}

[markov00]

thanks @leandrojmp, we identified the root cause and we are going to release the fix possibly on 7.5.1

[markov00]

TO REPRODUCE:
import or generate a dataset that spans few years (containing at least one leap year)

node scripts/makelogs.js -c 2m -d 2200/1

[markov00]

fixed in #52758, will be released on 7.5.1

[leandrojmp]

Updated to 7.5.1 and it is working now, thanks!