[OSM-dev] Handling 500 errors

[Tom Hughes]

In message <Pine.LNX.4.64.0708311050140.15405 at einer.uio.no>
        Håkon Enger <hakon.enger at fys.uio.no> wrote:

> Right now I'm getting lots of 500 errors on attempted uploads. It may
> be a coincidence, but all the errors appeared when attempting to
> modify (i.e, move) an existing node. Creating new nodes, segments, and
> ways, and modifying existing ways as well as deleting segments seemed
> unproblematic. Probably unrelated, at the same time Potlatch does not
> seem to be able to download any ways at all. Some examples of JOSM
> output:
>
> upload to: http://www.openstreetmap.org/api/0.4/node/15849146
> got return: 500 with id 15849146
> <?xml version='1.0' encoding='UTF-8'?>
> <osm version='0.4' generator='JOSM'>
>   <node id='15849146' timestamp='2006-09-17 18:11:49' user='Håkon'
> visible='true' lat='59.946348663103485' lon='10.764852433686558'>
>     <tag k='created_by' v='JOSM' />
>   </node>
> </osm>

I think this was just caused by lock timeouts, which seems to have
been down to MySQL suddenly deciding to use a very bad execution plan
for one of Potlatch's queries.

That query has been tweaked now and things seem to be running more
smoothly.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/