API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 4th, 2017
325
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 10.76 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!