Circuit Breaker in Visualization

[umay_fb]

i want to get a visualization table, but i get a error and this response.

reason": {
"type": "circuit_breaking_exception",
"reason": "[parent] Data too large, data for [<agg [7]>] would be [66133455312/61.5gb], which is larger than the limit of [65092927488/60.6gb], real usage: [66133450192/61.5gb], new bytes reserved: [5120/5kb], usages [request=853145488/813.6mb, fielddata=3297127034/3gb, in_flight_requests=39238/38.3kb, accounting=844650279/805.5mb]",
"bytes_wanted": 66133455312,
"bytes_limit": 65092927488,
"durability": "PERMANENT"
}
}

why its happend and how to fix it?

[warkolm (Mark Walkom)]

What is the aggregation you are running?

[umay_fb]

i just create a sum aggreagat in data table viuslization

[warkolm (Mark Walkom)]

Can you show us the config you have used for it?

[umay_fb]

confiq oh visualisasi? or elastic? i had 1 index with 1 shard and the size 900Gb

[Christian_Dahlqvist]

What is the full output of the cluster stats API?

[umay_fb]

{
"_nodes" : {
"total" : 1,
"successful" : 1,
"failed" : 0
},
"cluster_name" : "elasticsearch",
"cluster_uuid" : "xxxxxxxxx_AAjVD7463Q",
"timestamp" : 1600922100839,
"status" : "green",
"indices" : {
"count" : 87,
"shards" : {
"total" : 183,
"primaries" : 183,
"replication" : 0.0,
"index" : {
"shards" : {
"min" : 1,
"max" : 5,
"avg" : 2.103448275862069
},
"primaries" : {
"min" : 1,
"max" : 5,
"avg" : 2.103448275862069
},
"replication" : {
"min" : 0.0,
"max" : 0.0,
"avg" : 0.0
}
}
},
"docs" : {
"count" : 776260233,
"deleted" : 221230416
},
"store" : {
"size_in_bytes" : 1236779781981
},
"fielddata" : {
"memory_size_in_bytes" : 3266895136,
"evictions" : 0
},
"query_cache" : {
"memory_size_in_bytes" : 317338136,
"total_count" : 2020488,
"hit_count" : 334806,
"miss_count" : 1685682,
"cache_size" : 13340,
"cache_count" : 50746,
"evictions" : 37406
},
"completion" : {
"size_in_bytes" : 0
},
"segments" : {
"count" : 1617,
"memory_in_bytes" : 861778842,
"terms_memory_in_bytes" : 290801026,
"stored_fields_memory_in_bytes" : 414232920,
"term_vectors_memory_in_bytes" : 0,
"norms_memory_in_bytes" : 3473152,
"points_memory_in_bytes" : 142003722,
"doc_values_memory_in_bytes" : 11268022,
"index_writer_memory_in_bytes" : 1418721284,
"version_map_memory_in_bytes" : 135450620,
"fixed_bit_set_memory_in_bytes" : 876392,
"max_unsafe_auto_id_timestamp" : -1,
"file_sizes" : { }
}
},
"nodes" : {
"count" : {
"total" : 1,
"coordinating_only" : 0,
"data" : 1,
"ingest" : 1,
"master" : 1,
"ml" : 0,
"voting_only" : 0
},
"versions" : [
"7.5.0"
],
"os" : {
"available_processors" : 48,
"allocated_processors" : 48,
"names" : [
{
"name" : "Linux",
"count" : 1
}
],
"pretty_names" : [
{
"pretty_name" : "Ubuntu 18.04.3 LTS",
"count" : 1
}
],
"mem" : {
"total_in_bytes" : 200385101824,
"free_in_bytes" : 1788088320,
"used_in_bytes" : 198597013504,
"free_percent" : 1,
"used_percent" : 99
}
},
"process" : {
"cpu" : {
"percent" : 5
},
"open_file_descriptors" : {
"min" : 2994,
"max" : 2994,
"avg" : 2994
}
},
"jvm" : {
"max_uptime_in_millis" : 244625486,
"versions" : [
{
"version" : "13.0.1",
"vm_name" : "OpenJDK 64-Bit Server VM",
"vm_version" : "13.0.1+9",
"vm_vendor" : "AdoptOpenJDK",
"bundled_jdk" : true,
"using_bundled_jdk" : true,
"count" : 1
}
],
"mem" : {
"heap_used_in_bytes" : 52633066160,
"heap_max_in_bytes" : 102791380992
},
"threads" : 348
},
"fs" : {
"total_in_bytes" : 2081727836160,
"free_in_bytes" : 822640066560,
"available_in_bytes" : 822623289344
},
"plugins" : ,
"network_types" : {
"transport_types" : {
"security4" : 1
},
"http_types" : {
"security4" : 1
}
},
"discovery_types" : {
"single-node" : 1
},
"packaging_types" : [
{
"flavor" : "default",
"type" : "deb",
"count" : 1
}
]
}
}

its full output of cluster stats