[OSM-dev] Rail Port timeout problem.

[Tom Hughes]

On 06/08/09 12:24, Marcos Lois Bermúdez wrote:

> - I see that now it uses postgresql but in the rails port instructions i
> don't see any reference to postgis, so in my understand the database
> that holds osm data is not using postGIS at all, is this true? or the
> postgis extension are only used for mapnik as ia see in their
> installation instructions?

Correct. The API database uses straight Postgres, the mapnik rendering 
database uses PostGIS.

> - I load the spain data into a postgres database setup for test, so i
> tune a bit the pg server, and install the rails port with the
> instructions of the wiki, so i get a lot of timeout problems triing to
> dowload a area form JOSM, it's a small area and i don't know how this
> get a long time, here the message that i recive for rail log:
>
> [2009-08-06 13:00:51.754388 #4672] Processing ApiController#map (for
> 192.168.0.104 at 2009-08-06 13:00:51) [GET]
> [2009-08-06 13:00:51.754713 #4672]   Parameters:
> {"bbox"=>"-8.845367431640623,42.16493029974573,-8.553543090820312,42.27375234246751"}
> ...
> ...
> [2009-08-06 13:20:52.237979 #4672] Completed in 1200483ms (View: 1, DB:
> 1055) | 408 Request Timeout
> [http://192.168.0.144/api/0.6/map?bbox=-8.845367431640623,42.16493029974573,-8.553543090820312,42.27375234246751]
>
> So i try with smallest one, and it get completed but i take a long time
> to download the data, the server a virtual machine running the database
> and the rails_port.

Sounds like you have something serious wrong with your database. Run 
rails in the development environment and look in logs/development.log to 
see what queries are being run and then try those by hand to see how 
long they are taking. Also try adding "explain" to the front to see what 
the query planner is doing.

The most critical thing is probably to make sure that your current_nodes 
table is correctly indexed on the tile number.

Tom

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