[OSM-dev] is it ok to have multiple threads accessing the db while just one user edits the map?
Alexandru
icidrop at yahoo.com
Mon Nov 14 11:40:49 GMT 2011
I have a private osm server, so i'm sure i was the only one trying to access it. While potlatch was loading data i was monitoring the output. When the server printed the output i noticed that there was an inconsistency in time so i assume there is more then one thread working. Please analyze this outcome and tell me what you think: (to put it in a short way, we can see that from 13:30:29 it goes to 13:30:30 then again to 13:30:29)
[2011-11-14 13:29:33.439333 #9368] SQL (0.3ms) SET client_min_messages TO 'panic'
[2011-11-14 13:29:33.441844 #9368] SQL (0.3ms) SET standard_conforming_strings = on
[2011-11-14 13:29:33.442459 #9368] SQL (0.2ms) SET client_min_messages TO 'notice'
[2011-11-14 13:29:33.458488 #9368] Processing ApiController#map (for 192.168.0.101 at 2011-11-14 13:29:33) [GET]
[2011-11-14 13:29:33.458832 #9368] Parameters: {"bbox"=>"28.809954977416993,46.9924148867863,28.90584502258301,47.04197924500181"}
[2011-11-14 13:30:19.497500 #9368] Node Load (59.8ms) SELECT * FROM "current_nodes" WHERE ("current_nodes"."visible" = 't') AND (( tile BETWEEN 3525606323 AND 3525606327 OR tile BETWEEN 3525606331 AND 3525606335 OR tile BETWEEN 3525606368 AND 3525606399 OR tile BETWEEN 3525607072 AND 3525607103 OR tile BETWEEN 3525628179 AND 3525628183 OR tile BETWEEN 3525628187 AND 3525628191 OR tile BETWEEN 3525628211 AND 3525628215 OR tile BETWEEN 3525628219 AND 3525628287 OR tile BETWEEN 3525628307 AND 3525628311 OR tile BETWEEN 3525628315 AND 3525628319 OR tile BETWEEN 3525628339 AND 3525628343 OR tile BETWEEN 3525628348 AND 3525628349 OR tile BETWEEN 3525628352 AND 3525628393 OR tile BETWEEN 3525628396 AND 3525628397 OR tile BETWEEN 3525628400 AND 3525628409 OR tile BETWEEN 3525628412 AND 3525628413 OR tile BETWEEN 3525628928 AND 3525628991 OR tile BETWEEN 3525629056 AND 3525629097 OR tile BETWEEN 3525629100 AND 3525629101 OR tile BETWEEN 3525629104 AND
3525629113 OR tile BETWEEN 3525629116 AND 3525629117 OR tile IN (3525606321,3525606329,3525628177,3525628185,3525628209,3525628217,3525628305,3525628313,3525628337,3525628345) ) AND latitude BETWEEN 469924149 AND 470419792 AND longitude BETWEEN 288099550 AND 289058450) LIMIT 50001
[2011-11-14 13:30:24.570644 #9368] NodeTag Load (0.9ms) SELECT "current_node_tags".* FROM "current_node_tags" WHERE ("current_node_tags".id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,16))
[2011-11-14 13:30:29.639529 #9368] WayNode Load (0.9ms) SELECT * FROM "current_way_nodes" WHERE ("current_way_nodes"."node_id" IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,16))
[2011-11-14 13:30:34.713060 #9368] Way Load (0.7ms) SELECT * FROM "current_ways" WHERE ("current_ways"."id" IN (1,2,3))
[2011-11-14 13:30:39.775507 #9368] WayNode Load (1.3ms) SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE ("current_way_nodes".id IN (1,2,3)) ORDER BY sequence_id
[2011-11-14 13:30:39.784691 #9368] WayTag Load (0.7ms) SELECT "current_way_tags".* FROM "current_way_tags" WHERE ("current_way_tags".id IN (1,2,3))
[2011-11-14 13:29:33.439333 #9368] SQL (0.3ms) SET client_min_messages TO 'panic'
[2011-11-14 13:29:33.441844 #9368] SQL (0.3ms) SET standard_conforming_strings = on
[2011-11-14 13:29:33.442459 #9368] SQL (0.2ms) SET client_min_messages TO 'notice'
[2011-11-14 13:29:33.458488 #9368] Processing ApiController#map (for 192.168.0.101 at 2011-11-14 13:29:33) [GET]
[2011-11-14 13:29:33.458832 #9368] Parameters: {"bbox"=>"28.809954977416993,46.9924148867863,28.90584502258301,47.04197924500181"}
[2011-11-14 13:30:19.497500 #9368] Node Load (59.8ms) SELECT * FROM "current_nodes" WHERE ("current_nodes"."visible" = 't') AND (( tile BETWEEN 3525606323 AND 3525606327 OR tile BETWEEN 3525606331 AND 3525606335 OR tile BETWEEN 3525606368 AND 3525606399 OR tile BETWEEN 3525607072 AND 3525607103 OR tile BE[2011-11-14 13:29:33.439333 #9368] SQL (0.3ms) SET client_min_messages TO 'panic'
[2011-11-14 13:29:33.441844 #9368] SQL (0.3ms) SET standard_conforming_strings = on
[2011-11-14 13:29:33.442459 #9368] SQL (0.2ms) SET client_min_messages TO 'notice'
[2011-11-14 13:29:33.458488 #9368] Processing ApiController#map (for 192.168.0.101 at 2011-11-14 13:29:33) [GET]
[2011-11-14 13:29:33.458832 #9368] Parameters: {"bbox"=>"28.809954977416993,46.9924148867863,28.90584502258301,47.04197924500181"}
[2011-11-14 13:30:19.497500 #9368] Node Load (59.8ms) SELECT * FROM "current_nodes" WHERE ("current_nodes"."visible" = 't') AND (( tile BETWEEN 3525606323 AND 3525606327 OR tile BETWEEN 3525606331 AND 3525606335 OR tile BETWEEN 3525606368 AND 3525606399 OR tile BETWEEN 3525607072 AND 3525607103 OR tile BETWEEN 3525628179 AND 3525628183 OR tile BETWEEN 3525628187 AND 3525628191 OR tile BETWEEN 3525628211 AND 3525628215 OR tile BETWEEN 3525628219 AND 3525628287 OR tile BETWEEN 3525628307 AND 3525628311 OR tile BETWEEN 3525628315 AND 3525628319 OR tile BETWEEN 3525628339 AND 3525628343 OR tile BETWEEN 3525628348 AND 3525628349 OR tile BETWEEN 3525628352 AND 3525628393 OR tile BETWEEN 3525628396 AND 3525628397 OR tile BETWEEN 3525628400 AND 3525628409 OR tile BETWEEN 3525628412 AND 3525628413 OR tile BETWEEN 3525628928 AND 3525628991 OR tile BETWEEN 3525629056 AND 3525629097 OR tile BETWEEN 3525629100 AND 3525629101 OR tile BETWEEN 3525629104 AND
3525629113 OR tile BETWEEN 3525629116 AND 3525629117 OR tile IN (3525606321,3525606329,3525628177,3525628185,3525628209,3525628217,3525628305,3525628313,3525628337,3525628345) ) AND latitude BETWEEN 469924149 AND 470419792 AND longitude BETWEEN 288099550 AND 289058450) LIMIT 50001
[2011-11-14 13:30:24.570644 #9368] NodeTag Load (0.9ms) SELECT "current_node_tags".* FROM "current_node_tags" WHERE ("current_node_tags".id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,16))
[2011-11-14 13:30:29.639529 #9368] WayNode Load (0.9ms) SELECT * FROM "current_way_nodes" WHERE ("current_way_nodes"."node_id" IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,16))
[2011-11-14 13:30:34.713060 #9368] Way Load (0.7ms) SELECT * FROM "current_ways" WHERE ("current_ways"."id" IN (1,2,3))
[2011-11-14 13:30:39.775507 #9368] WayNode Load (1.3ms) SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE ("current_way_nodes".id IN (1,2,3)) ORDER BY sequence_id
[2011-11-14 13:30:39.784691 #9368] WayTag Load (0.7ms) SELECT "current_way_tags".* FROM "current_way_tags" WHERE ("current_way_tags".id IN (1,2,3))
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20111114/43e675e8/attachment.html>
More information about the dev
mailing list