# Ttl is enabled but it is not deleting document

**URL:** <https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613>\
**Category:** Elasticsearch\
**Created:** [February 24, 2016, 4:34pm UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613 "2016-02-24T16:34:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [February 24, 2016, 4:34pm UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/1 "2016-02-24T16:34:25Z")

</div>

Hi Experts,

I am using ES 1.7.1, my requirement is to delete document which are 10 days old . So for this I am using ttl mapping something like

```
{
 "template_main":{
    "template" : "abc*",
    "settings" : {
        "index.query.default_field" : "message",
        "index":{
        "analysis":{
           "analyzer":{
              "analyzer_keyword":{
		"type": "custom",
                 "tokenizer":"keyword",
                 "filter":"lowercase"
              }
           }
        }
     }
    },
	 
    "mappings" : {
        "_default_" : {
		"_ttl": {"enabled": true,"default": "10d"},
                "_all" : {"enabled" : false},			
			"properties" : {
			  "rt": {"type": "date"},
                          "spt" :{"type": "integer","doc_values" : true}
				}
			}
		}
	}
}

```

Now when I am creating index based on **rt** (receive time) using LS, documents are not getting deleted which are older than 10 days . I cheeked my data in the log file it is old. Please suggest what I am missing .

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [February 24, 2016, 7:07pm UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/2 "2016-02-24T19:07:42Z")

</div>

I do not understand where is the problem , even I set\*\* indices.ttl.interval\*\* property , but it's still not working .

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 25, 2016, 5:45am UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/3 "2016-02-25T05:45:10Z")

</div>

If you are using LS then why aren't you using time based indices?

is there anything in the ES logs?

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [February 25, 2016, 9:34am UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/4 "2016-02-25T09:34:48Z")

</div>

Actually my index has already been created and it has millions of documents I do not want to reindex whole data .

Now regarding ttl , a very strange thing which I observed is , if I mention ttl:enable and default:3s in the mapping and indices.ttl.interval:3s , then it starts deleting document , but it deletes everything as data is older than 3s . It does not work when I use 1d or 10 min any other perameter, not sure why it is like this .

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 25, 2016, 7:18pm UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/5 "2016-02-25T19:18:44Z")

</div>

> [@vikas\_gopal](#):
>
> millions of documents

This is tiny, it's well worth reindexing to time based indices in this instance.

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [February 26, 2016, 8:55am UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/6 "2016-02-26T08:55:21Z")

</div>

ok, so I am opting this option, thanks again.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:13pm UTC](https://discuss.elastic.co/t/ttl-is-enabled-but-it-is-not-deleting-document/42613/7 "2017-07-05T23:13:21Z")

</div>