Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Roll-up broken on timefields not rolled up in the same time zone as Kibana #35494

Closed
timroes opened this issue Apr 23, 2019 · 3 comments · Fixed by #35536
Closed

Roll-up broken on timefields not rolled up in the same time zone as Kibana #35494

timroes opened this issue Apr 23, 2019 · 3 comments · Fixed by #35536
Assignees
Labels
blocker bug Fixes for quality problems that affect the customer experience Feature:Aggregations Aggregation infrastructure (AggConfig, esaggs, ...) regression Team:Visualizations Visualization editors, elastic-charts and infrastructure v6.7.2 v7.0.1 v7.2.0

Comments

@timroes
Copy link
Contributor

timroes commented Apr 23, 2019

If you're currently trying to create a visualization on a rolled up index, while your Kibana is configured on a different timezone then the data was rolled up on (e.g. data was rolled up in UTC and you're anywhere outside UTC) the visualization will just fail.

This happens to us (in another fix) not serializing the time_zone of the AggConfig anymore when serializing to JSON so it's no longer stored in the saved object (see #34795). This unfortunately broke roll-up support, because the JSON serialization also happens to copy over the AggConfigs into some other place that actually does the query, so we're losing the time_zone already for the query.

We need to properly separate volatile parameters from "not serialized" parameters (which also effect the query).

We're still investigating if that would appear in 6.7.2, so we would mark this as a blocker, too.

@timroes timroes added bug Fixes for quality problems that affect the customer experience blocker Feature:Aggregations Aggregation infrastructure (AggConfig, esaggs, ...) Team:Visualizations Visualization editors, elastic-charts and infrastructure :AppArch v7.2.0 v7.0.1 labels Apr 23, 2019
@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-app

@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-app-arch

@lukeelmers
Copy link
Member

Looks like this issue is present on the 6.7.2 branch, as well as master. Error message in the UI:

Rollup search error: [illegal_argument_exception] There is not a rollup job that has a [date_histogram] agg on field [@timestamp] which also satisfies all requirements of query.

To reproduce:

  • Use a fresh kibana install with kibana_sample_data_logs
  • Configure a rollup job on kibana_sample_data_logs, keeping the default utc timestamp
  • Create index pattern for the new rollup index
  • Try creating a visualization with, for example, a date histogram on the rolled up timestamp
  • Error appears in the UI
  • Now go to Advanced Settings and change your timezone preference to UTC
  • Return to visualization, everything works as expected

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
blocker bug Fixes for quality problems that affect the customer experience Feature:Aggregations Aggregation infrastructure (AggConfig, esaggs, ...) regression Team:Visualizations Visualization editors, elastic-charts and infrastructure v6.7.2 v7.0.1 v7.2.0
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants