elasticsearchelastic-stackilm

Please help me with manual deletion of Elastic index


I am using ECK 8.14 and here is the reflected Index Lifecycle Policies(ILM) content:

PUT _ilm/policy/ECK-ILM
{
  "policy": {
    "phases": {
      "hot": {
        "min_age": "0ms",
        "actions": {
          "set_priority": {
            "priority": 100
          },
          "rollover": {
            "max_primary_shard_size": "5gb"
          }
        }
      }
    }
  }
}

Please help me organize INDEX manually I want to delete INDEX manually because ILM policy doesn't seem to reflect properly. For example,

enter image description here

DELETE /.ds-logs-elastic_agent-default-2025.01.06-000004
or
POST /.ds-logs-elastic_agent-default-2025.01.06-000004/_delete_by_query?conflicts= approved
{
  "query": {
    "match_all": {}
  }
}

I'd appreciate it if you could let me know what works The index settings are as follows. If you know why ILM can't be applied, please help

{
  "settings": {
    "index": {
      "mapping": {
        "total_fields": {
          "limit": "1000",
          "ignore_dynamic_beyond_limit": "true"
        },
        "ignore_malformed": "true"
      },
      "hidden": "true",
      "provided_name": ".ds-logs-elastic_agent-default-2025.01.06-000004",
      "final_pipeline": ".fleet_final_pipeline-1",
      "creation_date": "1736164437660",
      "number_of_replicas": "1",
      "uuid": "LrRPlGf8RRK0iG1JgBnacA",
      "version": {
        "created": "8505000"
      },
      "lifecycle": {
        "name": "logs",
        "indexing_complete": "true"
      },
      "codec": "best_compression",
      "routing": {
        "allocation": {
          "include": {
            "_tier_preference": "data_hot"
          }
        }
      },
      "number_of_shards": "1",
      "default_pipeline": "logs-elastic_agent-2.0.3"
    }
  },
  "defaults": {
    "index": {
      "flush_after_merge": "512mb",
      "time_series": {
        "end_time": "9999-12-31T23:59:59.999Z",
        "start_time": "-9999-01-01T00:00:00Z",
        "es87tsdb_codec": {
          "enabled": "true"
        }
      },
      "max_inner_result_window": "100",
      "unassigned": {
        "node_left": {
          "delayed_timeout": "1m"
        }
      },
      "max_terms_count": "65536",
      "rollup": {
        "source": {
          "name": "",
          "uuid": ""
        }
      },
      "lifecycle": {
        "parse_origination_date": "false",
        "prefer_ilm": "true",
        "step": {
          "wait_time_threshold": "12h"
        },
        "rollover_alias": "",
        "origination_date": "-1"
      },
      "mode": "standard",
      "routing_partition_size": "1",
      "force_memory_term_dictionary": "false",
      "max_docvalue_fields_search": "100",
      "merge": {
        "scheduler": {
          "max_thread_count": "4",
          "auto_throttle": "true",
          "max_merge_count": "9"
        },
        "policy": {
          "merge_factor": "32",
          "floor_segment": "2mb",
          "max_merge_at_once_explicit": "30",
          "max_merge_at_once": "10",
          "max_merged_segment": "0b",
          "expunge_deletes_allowed": "10.0",
          "segments_per_tier": "10.0",
          "type": "UNSET",
          "deletes_pct_allowed": "20.0"
        }
      },
      "max_refresh_listeners": "1000",
      "max_regex_length": "1000",
      "load_fixed_bitset_filters_eagerly": "true",
      "number_of_routing_shards": "1",
      "write": {
        "wait_for_active_shards": "1"
      },
      "verified_before_close": "false",
      "mapping": {
        "coerce": "false",
        "nested_fields": {
          "limit": "50"
        },
        "nested_objects": {
          "limit": "10000"
        },
        "depth": {
          "limit": "20"
        },
        "field_name_length": {
          "limit": "9223372036854775807"
        },
        "dimension_fields": {
          "limit": "32768"
        }
      },
      "source_only": "false",
      "soft_deletes": {
        "enabled": "true",
        "retention": {
          "operations": "0"
        },
        "retention_lease": {
          "period": "12h"
        }
      },
      "max_script_fields": "32",
      "query": {
        "default_field": [
          "*"
        ],
        "parse": {
          "allow_unmapped_fields": "true"
        }
      },
      "format": "0",
      "frozen": "false",
      "sort": {
        "missing": [],
        "mode": [],
        "field": [],
        "order": []
      },
      "priority": "1",
      "routing_path": [],
      "version": {
        "compatibility": "8505000"
      },
      "max_rescore_window": "10000",
      "bloom_filter_for_id_field": {
        "enabled": "true"
      },
      "max_adjacency_matrix_filters": "100",
      "analyze": {
        "max_token_count": "10000"
      },
      "gc_deletes": "60s",
      "top_metrics_max_size": "10",
      "optimize_auto_generated_id": "true",
      "max_ngram_diff": "1",
      "translog": {
        "flush_threshold_age": "1m",
        "generation_threshold_size": "64mb",
        "flush_threshold_size": "10gb",
        "sync_interval": "5s",
        "retention": {
          "size": "-1",
          "age": "-1"
        },
        "durability": "REQUEST"
      },
      "auto_expand_replicas": "false",
      "fast_refresh": "false",
      "recovery": {
        "type": ""
      },
      "requests": {
        "cache": {
          "enable": "true"
        }
      },
      "data_path": "",
      "highlight": {
        "max_analyzed_offset": "1000000",
        "weight_matches_mode": {
          "enabled": "true"
        }
      },
      "look_back_time": "2h",
      "routing": {
        "rebalance": {
          "enable": "all"
        },
        "allocation": {
          "disk": {
            "watermark": {
              "ignore": "false"
            }
          },
          "enable": "all",
          "total_shards_per_node": "-1"
        }
      },
      "search": {
        "slowlog": {
          "include": {
            "user": "false"
          },
          "level": "TRACE",
          "threshold": {
            "fetch": {
              "warn": "-1",
              "trace": "-1",
              "debug": "-1",
              "info": "-1"
            },
            "query": {
              "warn": "-1",
              "trace": "-1",
              "debug": "-1",
              "info": "-1"
            }
          }
        },
        "idle": {
          "after": "30s"
        },
        "throttled": "false"
      },
      "fielddata": {
        "cache": "node"
      },
      "look_ahead_time": "30m",
      "max_slices_per_scroll": "1024",
      "shard": {
        "check_on_startup": "false"
      },
      "xpack": {
        "watcher": {
          "template": {
            "version": ""
          }
        },
        "version": "",
        "ccr": {
          "following_index": "false"
        }
      },
      "percolator": {
        "map_unmapped_fields_as_text": "false"
      },
      "allocation": {
        "max_retries": "5",
        "existing_shards_allocator": "gateway_allocator"
      },
      "refresh_interval": "1s",
      "indexing": {
        "slowlog": {
          "include": {
            "user": "false"
          },
          "reformat": "true",
          "threshold": {
            "index": {
              "warn": "-1",
              "trace": "-1",
              "debug": "-1",
              "info": "-1"
            }
          },
          "source": "1000",
          "level": "TRACE"
        }
      },
      "compound_format": "1gb",
      "blocks": {
        "metadata": "false",
        "read": "false",
        "read_only_allow_delete": "false",
        "read_only": "false",
        "write": "false"
      },
      "max_result_window": "10000",
      "store": {
        "stats_refresh_interval": "10s",
        "type": "",
        "fs": {
          "fs_lock": "native"
        },
        "preload": [],
        "snapshot": {
          "snapshot_name": "",
          "index_uuid": "",
          "cache": {
            "prewarm": {
              "enabled": "true"
            },
            "enabled": "true",
            "excluded_file_types": []
          },
          "repository_uuid": "",
          "uncached_chunk_size": "-1b",
          "delete_searchable_snapshot": "false",
          "index_name": "",
          "partial": "false",
          "blob_cache": {
            "metadata_files": {
              "max_length": "64kb"
            }
          },
          "repository_name": "",
          "snapshot_uuid": ""
        }
      },
      "queries": {
        "cache": {
          "enabled": "true"
        }
      },
      "shard_limit": {
        "group": "normal"
      },
      "warmer": {
        "enabled": "true"
      },
      "downsample": {
        "interval": "",
        "source": {
          "name": "",
          "uuid": ""
        },
        "origin": {
          "name": "",
          "uuid": ""
        },
        "status": "unknown"
      },
      "override_write_load_forecast": "0.0",
      "max_shingle_diff": "3",
      "query_string": {
        "lenient": "false"
      }
    }
  }
}

Please tell me how to handle Index Lifecycle Policy (ILM) or delete index manually.


Solution

  • Your ILM name,aka index.lifecycle.name, is logs but you shared the ECK-ILM ILM policy. This is why your ILM is not applied.

    To check the current ILM you can use the following API call.

    GET .ds-logs-elastic_agent-default-2025.01.06-000004/_ilm/explain
    

    To update the ILM:

    1. remove the current ILM

    POST .ds-logs-elastic_agent-default-2025.01.06-000004/_ilm/remove
    

    https://www.elastic.co/guide/en/elasticsearch/reference/current/ilm-remove-policy.html

    1. Add the new ILM

    PUT .ds-logs-elastic_agent-default-2025.01.06-000004/_settings
    {
      "index.lifecycle.name": "ECK-ILM"
    }
    

    To add the delete phase into the ILM

    #delete after 30 days
    PUT _ilm/policy/ECK-ILM
    {
      "policy": {
        "phases": {
          "hot": {
            "min_age": "0ms",
            "actions": {
              "rollover": {
                "max_primary_shard_size": "35gb"
              }
            }
          },
          "delete": {
            "min_age": "30d",
            "actions": {
              "delete": { }
            }
          }
        }
      }
    }
    

    https://www.elastic.co/guide/en/elasticsearch/reference/current/ilm-delete.html