Spring boot / mongo wont create index with the index annotation

Question

I have the following:

@Document(collection = "linkmetadata")
public class LinkMetaData {
@Indexed(unique = true)
private String url;
...
}

But whenever it creates the collection it doesn't create any index for the url field, it's like it just ignores the annotation. Any idea why this is?

Edit: no index is created upon insertion of data either. And when I try to fetch data for a specific url it throws an error that the url key is not unique if I entered the same url twice, but it doesn't care about inserting the unique key since there is no index..

Check out this answer if none of the above works for you.

Wiktor
– Wiktor

2022-07-25 20:58:31 +00:00
Commented Jul 25, 2022 at 20:58 — Wiktor
– Wiktor, Commented Jul 25, 2022 at 20:58

Afridi · Accepted Answer · 2024-04-04 10:57:16Z

49

Add below line in your application.properties

spring.data.mongodb.auto-index-creation: true

edited Apr 4, 2024 at 10:57

Afridi

6,9422 gold badges22 silver badges32 bronze badges

answered Jun 30, 2020 at 10:11

Dipak

4914 silver badges2 bronze badges

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

5 Comments

seekle Over a year ago

this property needs to be enabled, after 3.0

Pradipta Sarma Over a year ago

You deserve a medal

Ugnes Over a year ago

Does this property create (re-create) the indexes every time the service is started or works like data migration and don't re-create is already present?

zhrgci Over a year ago

Idk if anyone else got it, but when I add that line in my application.properties. It gives me a UnsatisfiedDependencyException

IcedDante Over a year ago

Note that creating indices in this manner is not recommended. Especially if you are running an enterprise application that propagates through multiple environments, has reverts and rollbacks, you are much better off explicitly creating your own indices by integrating a migration tool like Mongock

Jonas B · Accepted Answer · 2018-10-26 10:46:18Z

5

I found the problem. I had another collection also with a url field marked as unqiue. I had to specify the name of the index on one of them otherwise it seems that it considered that the index already exists even though it was on two different collections

@Indexed(name = "meta_url_index_unique", unique = true)
private String url;

answered Oct 26, 2018 at 10:46

Jonas B

2,4012 gold badges19 silver badges27 bronze badges

Comments

Ebram Sherif · Accepted Answer · 2018-10-26 10:41:03Z

3

Edit: This answer was before the author updates his question

I believe you need to use the @Document annotation on top the class declaration

So your class should be

@Document
public class LinkMetaData {
@Indexed(unique = true)
private String url;
...
}

edited Oct 26, 2018 at 10:41

answered Oct 26, 2018 at 10:37

Ebram Sherif

1872 silver badges14 bronze badges

5 Comments

Jonas B Over a year ago

I did i just didn't include eveyrthing on top, ill update the question

Ebram Sherif Over a year ago

Thanks for the clarification! Can you include the configuration you used to enable mongo

Jonas B Over a year ago

The configuration is on our config server I don't have access to it at this very moment. But it works with other collections in the same service that have unique indexes created by annotations.

Jonas B Over a year ago

I figured it out, posted an answer

vinicius gati Over a year ago

really thanks bro, didint know @Document was obligatory

Sheshan Gamage · Accepted Answer · 2020-12-05 14:47:48Z

2

I Also had the same issue. The one that solved my issue was adding the index from the mongo db level

db.city.createIndex( { "name": 1 }, { unique: true } );

answered Dec 5, 2020 at 14:47

Sheshan Gamage

63413 silver badges22 bronze badges

Comments

Oscar Ngxongwana · Accepted Answer · 2023-09-22 08:59:00Z

0

There's a high chance that you already have duplicates in your collection hence failing to create the index.

Check if you have duplicate URL values, if so, that should be your issue. Then you can drop the collection if it's not "PROD" data/ collection", then re-try, it should go through.

answered Sep 22, 2023 at 8:59

Oscar Ngxongwana

511 silver badge2 bronze badges

Comments

Charles · Accepted Answer · 2025-10-16 09:23:27Z

0

Did you created the repository class?

interface LinkMetaDataRepository : MongoRepository<LinkMetaData, String>

answered Oct 16 at 9:23

Charles

1211 silver badge5 bronze badges

Collectives™ on Stack Overflow

Spring boot / mongo wont create index with the index annotation

6 Answers 6

5 Comments

Comments

5 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

5 Comments

Comments

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related