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))
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
