Guest User

Untitled

a guest
Sep 4th, 2017
115
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. osm2pgsql SVN version 0.88.1 (64bit id space)
  2.  
  3. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  4. Using projection SRS 900913 (Spherical Mercator)
  5. Setting up table: planet_osm_point
  6. Setting up table: planet_osm_line
  7. Setting up table: planet_osm_polygon
  8. Setting up table: planet_osm_roads
  9. Allocating memory for dense node cache
  10. Allocating dense node cache in one big chunk
  11. Allocating memory for sparse node cache
  12. Sharing dense sparse
  13. Node-cache: cache=16000MB, maxblocks=2048000*8192, allocation method=11
  14. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  15. Allocated space for persistent node cache file
  16. Maximum node in persistent node cache: 0
  17. Mid: pgsql, scale=100 cache=16000
  18. Setting up table: planet_osm_nodes
  19. Setting up table: planet_osm_ways
  20. Setting up table: planet_osm_rels
  21.  
  22. Reading in file: /mnt/db/planet.osm.pbf
  23. Processing: Node(4035672k 631.6k/s) Way(431724k 8.57k/s) Relation(4999460 162.88/s)
  24. Standard exception processing relation id=7301465: TopologyException: side location conflict at 8275559.8899999997 6486836.4299999997
  25. Processing: Node(4035672k 631.6k/s) Way(431724k 8.57k/s) Relation(5175690 165.03/s)  parse time: 88114s
  26. Node stats: total(4035672578), max(5047121925) in 6390s
  27. Way stats: total(431724615), max(517122423) in 50362s
  28. Relation stats: total(5175696), max(7492976) in 31362s
  29. Maximum node in persistent node cache: 5047844863
  30. Committing transaction for planet_osm_point
  31. Committing transaction for planet_osm_line
  32. Committing transaction for planet_osm_polygon
  33. Committing transaction for planet_osm_roads
  34. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  35. Maximum node in persistent node cache: 5047844863
  36. Setting up table: planet_osm_nodes
  37. Setting up table: planet_osm_ways
  38. Setting up table: planet_osm_rels
  39. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  40. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  41. Maximum node in persistent node cache: 5047844863
  42. Setting up table: planet_osm_nodes
  43. Setting up table: planet_osm_ways
  44. Setting up table: planet_osm_rels
  45. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  46. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  47. Maximum node in persistent node cache: 5047844863
  48. Setting up table: planet_osm_nodes
  49. Setting up table: planet_osm_ways
  50. Setting up table: planet_osm_rels
  51. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  52. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  53. Maximum node in persistent node cache: 5047844863
  54. Setting up table: planet_osm_nodes
  55. Setting up table: planet_osm_ways
  56. Setting up table: planet_osm_rels
  57. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  58. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  59. Maximum node in persistent node cache: 5047844863
  60. Setting up table: planet_osm_nodes
  61. Setting up table: planet_osm_ways
  62. Setting up table: planet_osm_rels
  63. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  64. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  65. Maximum node in persistent node cache: 5047844863
  66. Setting up table: planet_osm_nodes
  67. Setting up table: planet_osm_ways
  68. Setting up table: planet_osm_rels
  69. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  70. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  71. Maximum node in persistent node cache: 5047844863
  72. Setting up table: planet_osm_nodes
  73. Setting up table: planet_osm_ways
  74. Setting up table: planet_osm_rels
  75. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  76. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  77. Maximum node in persistent node cache: 5047844863
  78. Setting up table: planet_osm_nodes
  79. Setting up table: planet_osm_ways
  80. Setting up table: planet_osm_rels
  81. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  82.  
  83. Going over pending ways...
  84.     287961768 ways are pending
  85.  
  86. Using 8 helper-processes
  87. Finished processing 287961768 ways in 28225 sec
  88.  
  89. 287961768 Pending ways took 28225s at a rate of 10202.37/s
  90. Committing transaction for planet_osm_point
  91. Committing transaction for planet_osm_line
  92. Committing transaction for planet_osm_polygon
  93. Committing transaction for planet_osm_roads
  94. Committing transaction for planet_osm_point
  95. Committing transaction for planet_osm_line
  96. Committing transaction for planet_osm_polygon
  97. Committing transaction for planet_osm_roads
  98. Committing transaction for planet_osm_point
  99. Committing transaction for planet_osm_line
  100. Committing transaction for planet_osm_polygon
  101. Committing transaction for planet_osm_roads
  102. Committing transaction for planet_osm_point
  103. Committing transaction for planet_osm_line
  104. Committing transaction for planet_osm_polygon
  105. Committing transaction for planet_osm_roads
  106. Committing transaction for planet_osm_point
  107. Committing transaction for planet_osm_line
  108. Committing transaction for planet_osm_polygon
  109. Committing transaction for planet_osm_roads
  110. Committing transaction for planet_osm_point
  111. Committing transaction for planet_osm_line
  112. Committing transaction for planet_osm_polygon
  113. Committing transaction for planet_osm_roads
  114. Committing transaction for planet_osm_point
  115. Committing transaction for planet_osm_line
  116. Committing transaction for planet_osm_polygon
  117. Committing transaction for planet_osm_roads
  118. Committing transaction for planet_osm_point
  119. Committing transaction for planet_osm_line
  120. Committing transaction for planet_osm_polygon
  121. Committing transaction for planet_osm_roads
  122.  
  123. Going over pending relations...
  124.     0 relations are pending
  125.  
  126. Using 8 helper-processes
  127. Finished processing 0 relations in 0 sec
  128.  
  129. Committing transaction for planet_osm_point
  130. WARNING:  there is no transaction in progress
  131. Committing transaction for planet_osm_line
  132. WARNING:  there is no transaction in progress
  133. Committing transaction for planet_osm_polygon
  134. WARNING:  there is no transaction in progress
  135. Committing transaction for planet_osm_roads
  136. WARNING:  there is no transaction in progress
  137. Committing transaction for planet_osm_point
  138. WARNING:  there is no transaction in progress
  139. Committing transaction for planet_osm_line
  140. WARNING:  there is no transaction in progress
  141. Committing transaction for planet_osm_polygon
  142. WARNING:  there is no transaction in progress
  143. Committing transaction for planet_osm_roads
  144. WARNING:  there is no transaction in progress
  145. Committing transaction for planet_osm_point
  146. WARNING:  there is no transaction in progress
  147. Committing transaction for planet_osm_line
  148. WARNING:  there is no transaction in progress
  149. Committing transaction for planet_osm_polygon
  150. WARNING:  there is no transaction in progress
  151. Committing transaction for planet_osm_roads
  152. WARNING:  there is no transaction in progress
  153. Committing transaction for planet_osm_point
  154. WARNING:  there is no transaction in progress
  155. Committing transaction for planet_osm_line
  156. WARNING:  there is no transaction in progress
  157. Committing transaction for planet_osm_polygon
  158. WARNING:  there is no transaction in progress
  159. Committing transaction for planet_osm_roads
  160. WARNING:  there is no transaction in progress
  161. Committing transaction for planet_osm_point
  162. WARNING:  there is no transaction in progress
  163. Committing transaction for planet_osm_line
  164. WARNING:  there is no transaction in progress
  165. Committing transaction for planet_osm_polygon
  166. WARNING:  there is no transaction in progress
  167. Committing transaction for planet_osm_roads
  168. WARNING:  there is no transaction in progress
  169. Committing transaction for planet_osm_point
  170. WARNING:  there is no transaction in progress
  171. Committing transaction for planet_osm_line
  172. WARNING:  there is no transaction in progress
  173. Committing transaction for planet_osm_polygon
  174. WARNING:  there is no transaction in progress
  175. Committing transaction for planet_osm_roads
  176. WARNING:  there is no transaction in progress
  177. Committing transaction for planet_osm_point
  178. WARNING:  there is no transaction in progress
  179. Committing transaction for planet_osm_line
  180. WARNING:  there is no transaction in progress
  181. Committing transaction for planet_osm_polygon
  182. WARNING:  there is no transaction in progress
  183. Committing transaction for planet_osm_roads
  184. WARNING:  there is no transaction in progress
  185. Committing transaction for planet_osm_point
  186. WARNING:  there is no transaction in progress
  187. Committing transaction for planet_osm_line
  188. WARNING:  there is no transaction in progress
  189. Committing transaction for planet_osm_polygon
  190. WARNING:  there is no transaction in progress
  191. Committing transaction for planet_osm_roads
  192. WARNING:  there is no transaction in progress
  193. Sorting data and creating indexes for planet_osm_point
  194. Sorting data and creating indexes for planet_osm_line
  195. Sorting data and creating indexes for planet_osm_roads
  196. Sorting data and creating indexes for planet_osm_polygon
  197. Stopping table: planet_osm_nodes
  198. Stopping table: planet_osm_ways
  199. Building index on table: planet_osm_ways
  200. Stopping table: planet_osm_rels
  201. Building index on table: planet_osm_rels
  202. Stopped table: planet_osm_nodes in 0s
  203. Stopped table: planet_osm_rels in 835s
  204. Copying planet_osm_roads to cluster by geometry finished
  205. Creating geometry index on  planet_osm_roads
  206. Creating osm_id index on  planet_osm_roads
  207. Creating indexes on  planet_osm_roads finished
  208. All indexes on  planet_osm_roads created  in 2197s
  209. Completed planet_osm_roads
  210. Copying planet_osm_point to cluster by geometry finished
  211. Creating geometry index on  planet_osm_point
  212. Copying planet_osm_line to cluster by geometry finished
  213. Creating geometry index on  planet_osm_line
  214. Creating osm_id index on  planet_osm_point
  215. Creating indexes on  planet_osm_point finished
  216. All indexes on  planet_osm_point created  in 9394s
  217. Completed planet_osm_point
  218. Copying planet_osm_polygon to cluster by geometry finished
  219. Creating geometry index on  planet_osm_polygon
  220. Creating osm_id index on  planet_osm_line
  221. Creating indexes on  planet_osm_line finished
  222. All indexes on  planet_osm_line created  in 14928s
  223. Completed planet_osm_line
  224. Creating osm_id index on  planet_osm_polygon
  225. Creating indexes on  planet_osm_polygon finished
  226. All indexes on  planet_osm_polygon created  in 28676s
  227. Completed planet_osm_polygon
  228. Stopped table: planet_osm_ways in 58390s
  229. Maximum node in persistent node cache: 5047844863
  230. Maximum node in persistent node cache: 5047844863
  231. Maximum node in persistent node cache: 5047844863
  232. Maximum node in persistent node cache: 5047844863
  233. Maximum node in persistent node cache: 5047844863
  234. Maximum node in persistent node cache: 5047844863
  235. Maximum node in persistent node cache: 5047844863
  236. Maximum node in persistent node cache: 5047844863
  237. node cache: stored: 1967950472(48.76%), storage efficiency: 93.84% (dense blocks: 1859179, sparse nodes: 96676751), hit rate: -156.74%
  238.  
  239. Osm2pgsql took 174848s overall
RAW Paste Data