GET _transform/last-ping-by-entity-id/_stats
{
"count" : 1,
"transforms" : [
{
"id" : "last-ping-by-entity-id",
"state" : "failed",
"reason" : "task encountered irrecoverable failure: Failed to execute phase [query], Partial shards failure; shardFailures {[61SMzV9PS5yHxMSjDcuhRw][my-source-index-2017][0]: RemoteTransportException[[instance-0000000000][172.17.0.5:19484][indices:data/read/search[phase/query]]]; nested: IllegalArgumentException[invalid value, expected string, got Long]; }; [invalid value, expected string, got Long]; nested: IllegalArgumentException[invalid value, expected string, got Long];; java.lang.IllegalArgumentException: invalid value, expected string, got Long",
"node" : {
"id" : "Fya0HXoDRC2RaRcxXEYPUg",
"name" : "instance-0000000003",
"ephemeral_id" : "bnHdBBsFQu2DftjjLtGqxg",
"transport_address" : "10.11.132.241:19708",
"attributes" : { }
},
"stats" : {
"pages_processed" : 1,
"documents_processed" : 24562,
"documents_indexed" : 500,
"trigger_count" : 1,
"index_time_in_ms" : 99,
"index_total" : 1,
"index_failures" : 0,
"search_time_in_ms" : 337,
"search_total" : 1,
"search_failures" : 1,
"processing_time_in_ms" : 4,
"processing_total" : 1,
"exponential_avg_checkpoint_duration_ms" : 0.0,
"exponential_avg_documents_indexed" : 0.0,
"exponential_avg_documents_processed" : 0.0
},
"checkpointing" : {
"last" : {
"checkpoint" : 0
},
"next" : {
"checkpoint" : 1,
"position" : {
"indexer_position" : {
"entity_id" : 1293846176892
}
},
"checkpoint_progress" : {
"docs_remaining" : 132094793,
"total_docs" : 132119355,
"percent_complete" : 0.018590765902543195,
"docs_indexed" : 500,
"docs_processed" : 24562
},
"timestamp_millis" : 1603111944169,
"time_upper_bound_millis" : 1603111884169
},
"operations_behind" : 157699154
}
}
]
}
Job was created like that:
PUT _transform/last-ping-by-entity-id
{
"source": {
"index": [
"search-all-entity-pings"
],
"query": {
"exists": {
"field": "entity_id"
}
}
},
"dest": {
"index": "pings-unique-entities"
},
"sync": {
"time": {
"field": "timestamp",
"delay": "60s"
}
},
"pivot": {
"group_by": {
"entity_id": {
"terms": {
"field": "entity_id"
}
}
},
"aggregations": {
"first_ping_timestamp": {
"min": {
"field": "timestamp"
}
},
"last_ping_timestamp": {
"max": {
"field": "timestamp"
}
}
}
},
"description": "Group pings by entity_id"
}
Here is the mapping of the my-source-index-2017:
GET /my-source-index-2017
{
"my-source-index-2017" : {
"aliases" : {
"search-all-entity-pings" : { }
},
"mappings" : {
"properties" : {
"xxx_mode_used" : {
"type" : "boolean"
},
"days_of_use" : {
"type" : "long"
},
"days_since_installation" : {
"type" : "long"
},
"host_version" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"entity_product" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"entity_version" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"timestamp" : {
"type" : "date"
},
"type" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
}
}
},
"settings" : {
"index" : {
"creation_date" : "1589892473078",
"number_of_shards" : "1",
"number_of_replicas" : "1",
"uuid" : "-RzxudpDTMO0x3xS4vtDWw",
"version" : {
"created" : "7070099"
},
"provided_name" : "my-source-index-2017"
}
}
}
}
As you can see, in this old index, no documents were having the creation_time
field, so no entity_id
either.
Maybe there is an issue if one index in the source pattern/alias has no matches?