Latitude Error Upon Reindexing

ES: 5.4.1

I'm looking for a way to debug this issue, as it is non-standard and likely doesn't have an easy fix..

I'm trying to get all my data in the same form, including geolocation data, yet receiving the following error upon attempting to reindex my daily indices:

illegal latitude value [269.9593658745289] for nginxgeolocation

Which is obviously an incorrect latitude value (too large). However, when I look at the data specific to that unique ID, there is no illegal Latitude value:

When attempting to reindex my daily indices using the below script (found in the docs), I'm getting the following errors:

Reindexing Attempt:

Command

POST _reindex
{
  "source": {
    "index": "nginx-2017.04.*"
  },
  "dest": {
    "index": "nginx"
  },
  "script": {
    "lang": "painless",
    "inline": "ctx._index = 'nginx' + (ctx._index.substring('nginx'.length(), ctx._index.length())) + '-1'"
  }
}

Response

  "failures": [

    {
      "index": "nginx-2017.04.25-1",
      "type": "nginx-access",
      "id": "AVul3FYdQjKzt0lCbTJQ",
      "cause": {
        "type": "mapper_parsing_exception",
        "reason": "failed to parse",
        "caused_by": {
          "type": "illegal_argument_exception",
          "reason": "illegal latitude value [269.9593658745289] for nginxgeolocation"
        }
      },
      "status": 400
    },
...
]

Mapping:

{
  "nginx": {
    "order": 0,
    "template": "nginx-*",
    "settings": {
      "index": {
        "number_of_shards": "3",
        "number_of_replicas": "1",
        "routing": {
          "allocation": {
            "require": {
              "box_type": "hot"
            }
          }
        }
      }
    },
    "mappings": {
      "nginx-access": {
        "properties": {
          "nginxgeolocation": {
            "type": "geo_point"
          },
          "nginxgeo1": {
            "type": "geo_point"
          }
        }
      }
    },
    "aliases": {}
  }
}

I'm seeing this error outlined here in Stack Overflow. Not really seeing a straightforward way to resolve it though, nor does any of the math I can find online check out..

If my latitude is being correctly interpreted by Kibana as '37.65...', how am I getting back '269.96...' from Elasticsearch?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.