MongoDB text index required for $text query

Question

I tried to find an answer to my question but i couldn't find anything with my specific problem. When i try to do a simple text search on my collection with TextCriteria i have the error :

Query failed with error code 27 and error message 'text index required for $text query'

I know for sure it is a mongo error on my part but i am not able to solve the problem.

Sample of my collection implementation :

@Document(collection = "mission")
@Getter
@Setter
@JsonInclude(Include.NON_NULL)
public class Mission {
    @Id
    @JsonProperty("_id")
    private String id;

    @JsonProperty("secteur")
    private String secteur;

    @JsonProperty("client")
    private String client;

    @Field
    @TextIndexed
    @JsonProperty("poste")
    private String poste;
    
    @Field
    @TextIndexed
    @JsonProperty("competences")
    private List<Competence> competences;

    @Field
    @TextIndexed
    @JsonProperty("description")
    private String description;

The method i use to retrieve my list :

@Override
public Collection<Mission> findAllByCriteria() {
    return missionDao.findAllBy(TextCriteria.forDefaultLanguage().matchingAny("angular"));
}

H3AR7B3A7 · Accepted Answer · 2021-10-22 21:52:35Z

2

If anyone else runs into this problem, try this property in application.yml:

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

Or in application.properties:

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

This way spring will automatically set the text index, and you don't need to use the shell.

answered Oct 22, 2021 at 21:52

H3AR7B3A7

5,3593 gold badges22 silver badges42 bronze badges

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

Comments

Sam Gregory · Accepted Answer · 2020-10-08 21:31:21Z

1

Does this specific collection have the appropriate text index created in the first place? Without knowing how the DB was created it's possible it doesn't and you'll have to create it yourself. If you're already using the same code to persist this entity into the DB then Mongo should create the text indexes for you.

See Mongo documentation on text indexes, and check this post.

answered Oct 8, 2020 at 21:31

Sam Gregory

3471 silver badge10 bronze badges

1 Comment

Rekome Over a year ago

Thank you a lot for your help. For some reasons the annotation didn't work even if i insert my collection with to persist it. But i managed to resolve my issue by adding the text index manually with mongo shell thanks to the documentation.

Collectives™ on Stack Overflow

MongoDB text index required for $text query

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related