I am trying to run a query on MongoDB through Java Driver and I am getting this error -
"Query failed with error code 2 and error message 'error processing query: ns=Application.Team limit=10Tree: $or
_id == \"TEA000000006\"
TEXT : query=anonoymous, language=english, caseSensitive=0, diacriticSensitive=0, tag=NULL
Sort: { name: 1 }
Proj: { _id: 1, name: 1 }
Collation: { locale: \"en_US\", strength: 1 }
planner returned error: Failed to produce a solution for TEXT under OR -
other non-TEXT clauses under OR have to be indexed as well.' on server
localhost:27017"
There seems to be some problem with the indexing I believe.
If I do not give the sort
or TEXT
, it seems to work. Both together causes problem
I need the query to return records found in text search or if the ID is in the list passed (in this case, TEA0000006)
My Indices are -
{
"v" : 2,
"name" : "myIndex",
"ns" : "Application.Team",
"weights" : {
"$**" : 1,
"_id" : 1,
"name" : 1
},
"default_language" : "english",
"language_override" : "language",
"textIndexVersion" : 3
}
{
"v" : NumberInt(2),
"key" : {
"_id" : NumberInt(1)
},
"name" : "_id_",
"ns" : "Application.Team"
}
This is actually not possible. Refer - https://jira.mongodb.org/browse/SERVER-13803