Timelion visualization not working after upgrading from ES 7 to 8

Elastic Stack Kibana
1

After upgrading my elasticsearch and kibana instance from 7 to 8.18.4 my Timelion visualizations that where previously working are getting the following error:

Unable to load visualization
Error: [timelion_vis] > Timelion request error:  in cell #1: status_exception
	Caused by:
		search_phase_execution_exception: all shards failed

Did it something changed for Timelion?

2

Hi @oskrdt

that looks like an ES error message.
Would it be possible to share the Timelion expression?

3

Here is the timelion expression

.es(index=ai4i_issues,timefield="Date Created", metric=cardinality:_id).cusum().subtract(.es(index=ai4i_issues,timefield="Date Resolved", metric=cardinality:_id).cusum()).label('Backlog')
4

Hello @oskrdt

Also as per the below error message could you please check if all is OK with the index ai4i_issues

Error : Caused by: search_phase_execution_exception: all shards failed)

GET _cluster/health => What is the health of the cluster?
GET _cat/indices/ai4i_issues?v => What is the health of this index?
GET /_cat/shards/ai4i_issues?v&h=index,shard,prirep,state,store,ip,node => Are all shards STARTED?

Thanks!!

5

Hi @Tortoise
Here are the responses of the health requests (this is a single node instance):

GET _cluster/health

{
  "cluster_name": "elasticsearch",
  "status": "yellow",
  "timed_out": false,
  "number_of_nodes": 1,
  "number_of_data_nodes": 1,
  "active_primary_shards": 58,
  "active_shards": 58,
  "relocating_shards": 0,
  "initializing_shards": 0,
  "unassigned_shards": 3,
  "unassigned_primary_shards": 0,
  "delayed_unassigned_shards": 0,
  "number_of_pending_tasks": 0,
  "number_of_in_flight_fetch": 0,
  "task_max_waiting_in_queue_millis": 0,
  "active_shards_percent_as_number": 95.08196721311475
}

GET _cat/indices/ai4i_issues?v

health status index       uuid                   pri rep docs.count docs.deleted store.size pri.store.size dataset.size
yellow open   ai4i_issues ntouE0WBR_iexMTO7Qxaxg   1   1       3499            0     12.1mb         12.1mb       12.1mb

GET /_cat/shards/ai4i_issues?v&h=index,shard,prirep,state,store,ip,node

index       shard prirep state       store ip            node
ai4i_issues 0     p      STARTED    12.1mb 9.114.203.200 vm-2220
ai4i_issues 0     r      UNASSIGNED
6

Thank you @oskrdt for sharing the details.

As this is a single node instance, we can make the replicas = 0 for this index :

PUT /ai4i_issues/_settings
{
  "index": {
    "number_of_replicas": 0
  }
}

After this maybe try to see if the Timelion visualization is working or not?

Thanks!!

7

I just did the change to de index and these are the new health output

GET _cat/indices/ai4i_issues?v

health status index       uuid                   pri rep docs.count docs.deleted store.size pri.store.size dataset.size
green  open   ai4i_issues ntouE0WBR_iexMTO7Qxaxg   1   0       3499            0     12.1mb         12.1mb       12.1mb

GET /_cat/shards/ai4i_issues?v&h=index,shard,prirep,state,store,ip,node

index       shard prirep state    store ip            node
ai4i_issues 0     p      STARTED 12.1mb 9.114.203.200 vm-2220

It was a nice try, but it seems the error persists.

1 Like