Opened 11 years ago

Closed 11 years ago

#2152 closed defect (fixed)

Update ERROR: integer out of range

Reported by: katpatuka Owned by: zerebubuth@…
Priority: major Milestone:
Component: api Version:
Keywords: Cc:


When trying to change name of the Russian boundary relation (60189) from "Border Mongolia-Russia" to just the correct "Russia" I get the following error (both in potlatch and josm):

An unusual error happened (in 'putrelation' 60189.0). The server said: PGError: ERROR: integer out of range : UPDATE "changesets" SET "max_lat" = 856333894, "min_lat" = 402736352, "closed_at" = '2009-08-09 16:43:41.043280', "num_changes" = 1, "max_lon" = 2154151951, "min_lon" = -1804611535 WHERE "id" = 2086459

Change History (2)

comment:1 Changed 11 years ago by Tom Hughes

Owner: changed from Tom Hughes to zerebubuth@…

I think I've finally worked this out... This relation is very wide - the longitude range of the objects in it extends from -179.9999999 to 179.9999837 which covers pretty much the entire planet.

This interacts badly with an "optimisation" in the changeset bounding box update code which tries to over-expand the bounding box by 10% to avoid having to do too many updates as the bbox winds up getting expanded to a size beyond the correct bounds.

comment:2 Changed 11 years ago by Matt

Resolution: fixed
Status: newclosed

Fixed in changeset 17073, which adds some tests too.

Note: See TracTickets for help on using tickets.