[OSM-dev] Import planet.osm to rails

[Brett Henderson]

Just to confirm, I get exactly the same error.  It occurs on one of the 
way queries.  Nodes and segments use a single query so they work even 
though they run dog slow.  I use three separate queries for ways and 
combine the results in code, a timeout occurs between issuing each of 
the queries such that the first query times out while I'm waiting for 
the second to respond.

This may be difficult to solve.  I'd like to find a way of increasing 
the timeout for reading query data as a workaround.  Note that timeouts 
don't occur for long running queries themselves, the timeout seems to 
occur if you issue a query but don't read data from it for a long period 
of time.

I could cheat and simply read entire tables and filter in code, but 
there should be a better way of doing it.

Al Wold wrote:
> Yeah, I will use planet.rb.  I turned on general query logging on 
> mysql, but it didn't show any errors.  I'll keep poking around and let 
> you know if I find a fix.
>
> -Al
>
> On 8/2/07, *Brett Henderson* <brett at bretth.com 
> <mailto:brett at bretth.com>> wrote:
>
>     I don't think I've seen that specific error but I get timeout errors
>     when trying to dump large data sets.  The --read-mysql task still
>     needs
>     work.  I've just imported a full planet into my test databases and am
>     planning to get it working over the next couple of days.
>