Unfortunately, since it was prod issue, we had to reload the data to get the app working again. But based on returned score, we can easily say that the below was the one that was making the difference. When issue is present, we get some score of 500, where as we expect to get 10500.
Below is what I see, when its working properly.
{
"value" : 10000.0,
"description" : "A match, join value 1000080000000308213",
"details" : [ ]
}
Below is the has child query, where we expect to get the 10000 boost in score, which we don't get whenever the issue happens. So even though a match is found, due to min score, record will not be returned.
{
"has_child": {
"type": "childrecordtype",
"score_mode": "sum",
"query": {
"bool": {
"should": [
{
"multi_match": {
"query": "AB123",
"fields": [
"attr1^150",
"attr2^140"
]
}
},
{
"terms": {
"visiblecode": {
"index": "secondindex",
"id": "AB123",
"path": "visiblecode"
},
"boost": 10000
}
}
]
}
}
}
}