Duplicate results in query


(Georgi Ivanov) #1

Hi ,
I have some strange issue .
I get duplicate documents when querying:

GET track_2011*/_search
{
"query": {
"bool": {
"must": [
{
"range": {
"ts": {
"gte": "2011-08-30T00:00:00Z",
"lte": "2011-08-31T23:59:00Z"
}
}
},
{
"term": {
"entity_id": {
"value": "298082"
}
}
}
]
}
}
,
"sort": [
{
"ts": {
"order": "asc"
}
}
],
"size": 90

}

Result (there are more, just showing duplicates):
{
"_index": "track_201108",
"_type": "position",
"_id": "298082_1314758608000_1302",
"_score": null,
"_source": {
"ts": 1314758608000,
"entity_id": 298082,
"loc": {
"type": "point",
"coordinates": [
103.694783333,
1.23463333333
]
}
},
"sort": [
1314758608000
]
},
{
"_index": "track_201108",
"_type": "position",
"_id": "298082_1314758608000_1302",
"_score": null,
"_source": {
"ts": 1314758608000,
"entity_id": 298082,
"loc": {
"type": "point",
"coordinates": [
103.694783333,
1.23463333333
]
}
},
"sort": [
1314758608000
]
}

But if i get the document :

curl -s es01.vesseltracker.com:9200/track_201108/position/298082_1314758608000_1302
| json_pp
{
"found" : true,
"_version" : 1,
"_type" : "position",
"_index" : "track_201108",
"_source" : {
"hourly" : false,
"loc" : {
"type" : "point",
"coordinates" : [
103.694783333,
1.23463333333
]
},
"ts" : 1314758608000,
"entity_id" : 298082
},
"_id" : "298082_1314758608000_1302"
}

So i have only one document (and it was never updated as version is 1 ).

I don't understand what is going on here .

No special routing, no parent/child relations.

Any ideas ?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0e9d61e9-ef34-47e8-925c-15addb510850%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #2