Why I got such error message when trying to create a ttl index in azure cosmosdb?

Question

I'm trying to create some TTL indexes in azure cosmosdb collections (mongo API), these collection's elements are all string or integer, but when I use the index spec

{
 "expireAfterSeconds":1000,
 "key": {"_ts":1}
 }

to create TTL indexes, some collections can be created correctly, but some tables return such error message: "{"Errors":["Fields in 'spatialIndexes' are only allowed with newer API versions. Update your API version from '2018-06-18' to '2018-09-17' leverage this new feature."

but I do nothing about spatialIndexes, so why I got this error?

The cosmosdb version is 3.2

Caker Pang
– Caker Pang

2022-01-09 07:37:47 +00:00
Commented Jan 9, 2022 at 7:37 — Caker Pang
– Caker Pang, Commented Jan 9, 2022 at 7:37

Sajeetharan · Accepted Answer · 2022-01-10 05:18:11Z

0

Looks like something upgraded the index. Upgrading to 3.6 or 4.0 should solve the issue.

answered Jan 10, 2022 at 5:18

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Caker Pang Over a year ago

I'm curious about why other collections in the same DB can be created correctly

Sajeetharan Over a year ago

Not sure, need to see the activity logs if something was created already on this collection. You may create a support request

Collectives™ on Stack Overflow

Why I got such error message when trying to create a ttl index in azure cosmosdb?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related