Advertisement
Guest User

BTREE VS GIST ISSUE

a guest
Oct 24th, 2011
484
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alexandru@alex-lap:~$ cd ~/.osm/rail_port/rails/
  2. alexandru@alex-lap:~/.osm/rail_port/rails$ sudo su prostgres
  3. [sudo] password for alexandru:
  4. Unknown id: prostgres
  5. alexandru@alex-lap:~/.osm/rail_port/rails$ sudo su postgres
  6. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb openstreetmap
  7. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb osm_test
  8. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb osm
  9. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap openstreetmap
  10. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap osm_testpostgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap osm
  11. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ psql -d openstreetmap < /usr/share/postgresql/8.4/contrib/btree_gist.sql
  12. SET
  13. NOTICE:  type "gbtreekey4" is not yet defined
  14. DETAIL:  Creating a shell type definition.
  15. CREATE FUNCTION
  16. NOTICE:  argument type gbtreekey4 is only a shell
  17. CREATE FUNCTION
  18. CREATE TYPE
  19. NOTICE:  type "gbtreekey8" is not yet defined
  20. DETAIL:  Creating a shell type definition.
  21. CREATE FUNCTION
  22. NOTICE:  argument type gbtreekey8 is only a shell
  23. CREATE FUNCTION
  24. CREATE TYPE
  25. NOTICE:  type "gbtreekey16" is not yet defined
  26. DETAIL:  Creating a shell type definition.
  27. CREATE FUNCTION
  28. NOTICE:  argument type gbtreekey16 is only a shell
  29. CREATE FUNCTION
  30. CREATE TYPE
  31. NOTICE:  type "gbtreekey32" is not yet defined
  32. DETAIL:  Creating a shell type definition.
  33. CREATE FUNCTION
  34. NOTICE:  argument type gbtreekey32 is only a shell
  35. CREATE FUNCTION
  36. CREATE TYPE
  37. NOTICE:  type "gbtreekey_var" is not yet defined
  38. DETAIL:  Creating a shell type definition.
  39. CREATE FUNCTION
  40. NOTICE:  argument type gbtreekey_var is only a shell
  41. CREATE FUNCTION
  42. CREATE TYPE
  43. CREATE FUNCTION
  44. CREATE FUNCTION
  45. CREATE FUNCTION
  46. CREATE FUNCTION
  47. CREATE FUNCTION
  48. CREATE FUNCTION
  49. CREATE FUNCTION
  50. CREATE FUNCTION
  51. CREATE OPERATOR CLASS
  52. CREATE FUNCTION
  53. CREATE FUNCTION
  54. CREATE FUNCTION
  55. CREATE FUNCTION
  56. CREATE FUNCTION
  57. CREATE FUNCTION
  58. CREATE OPERATOR CLASS
  59. CREATE FUNCTION
  60. CREATE FUNCTION
  61. CREATE FUNCTION
  62. CREATE FUNCTION
  63. CREATE FUNCTION
  64. CREATE FUNCTION
  65. CREATE OPERATOR CLASS
  66. CREATE FUNCTION
  67. CREATE FUNCTION
  68. CREATE FUNCTION
  69. CREATE FUNCTION
  70. CREATE FUNCTION
  71. CREATE FUNCTION
  72. CREATE OPERATOR CLASS
  73. CREATE FUNCTION
  74. CREATE FUNCTION
  75. CREATE FUNCTION
  76. CREATE FUNCTION
  77. CREATE FUNCTION
  78. CREATE FUNCTION
  79. CREATE OPERATOR CLASS
  80. CREATE FUNCTION
  81. CREATE FUNCTION
  82. CREATE FUNCTION
  83. CREATE FUNCTION
  84. CREATE FUNCTION
  85. CREATE FUNCTION
  86. CREATE OPERATOR CLASS
  87. CREATE FUNCTION
  88. CREATE FUNCTION
  89. CREATE FUNCTION
  90. CREATE FUNCTION
  91. CREATE FUNCTION
  92. CREATE FUNCTION
  93. CREATE FUNCTION
  94. CREATE FUNCTION
  95. CREATE OPERATOR CLASS
  96. CREATE OPERATOR CLASS
  97. CREATE FUNCTION
  98. CREATE FUNCTION
  99. CREATE FUNCTION
  100. CREATE FUNCTION
  101. CREATE FUNCTION
  102. CREATE FUNCTION
  103. CREATE FUNCTION
  104. CREATE FUNCTION
  105. CREATE OPERATOR CLASS
  106. CREATE OPERATOR CLASS
  107. CREATE FUNCTION
  108. CREATE FUNCTION
  109. CREATE FUNCTION
  110. CREATE FUNCTION
  111. CREATE FUNCTION
  112. CREATE FUNCTION
  113. CREATE OPERATOR CLASS
  114. CREATE FUNCTION
  115. CREATE FUNCTION
  116. CREATE FUNCTION
  117. CREATE FUNCTION
  118. CREATE FUNCTION
  119. CREATE FUNCTION
  120. CREATE FUNCTION
  121. CREATE OPERATOR CLASS
  122. CREATE FUNCTION
  123. CREATE FUNCTION
  124. CREATE FUNCTION
  125. CREATE FUNCTION
  126. CREATE FUNCTION
  127. CREATE FUNCTION
  128. CREATE OPERATOR CLASS
  129. CREATE FUNCTION
  130. CREATE FUNCTION
  131. CREATE FUNCTION
  132. CREATE FUNCTION
  133. CREATE FUNCTION
  134. CREATE FUNCTION
  135. CREATE OPERATOR CLASS
  136. CREATE FUNCTION
  137. CREATE FUNCTION
  138. CREATE FUNCTION
  139. CREATE FUNCTION
  140. CREATE FUNCTION
  141. CREATE FUNCTION
  142. CREATE FUNCTION
  143. CREATE FUNCTION
  144. CREATE OPERATOR CLASS
  145. CREATE OPERATOR CLASS
  146. CREATE FUNCTION
  147. CREATE FUNCTION
  148. CREATE FUNCTION
  149. CREATE FUNCTION
  150. CREATE FUNCTION
  151. CREATE FUNCTION
  152. CREATE OPERATOR CLASS
  153. CREATE FUNCTION
  154. CREATE FUNCTION
  155. CREATE FUNCTION
  156. CREATE FUNCTION
  157. CREATE FUNCTION
  158. CREATE FUNCTION
  159. CREATE OPERATOR CLASS
  160. CREATE FUNCTION
  161. CREATE FUNCTION
  162. CREATE FUNCTION
  163. CREATE FUNCTION
  164. CREATE FUNCTION
  165. CREATE FUNCTION
  166. CREATE OPERATOR CLASS
  167. CREATE OPERATOR CLASS
  168. CREATE FUNCTION
  169. CREATE FUNCTION
  170. CREATE FUNCTION
  171. CREATE FUNCTION
  172. CREATE FUNCTION
  173. CREATE FUNCTION
  174. CREATE OPERATOR CLASS
  175. CREATE OPERATOR CLASS
  176. postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ exit
  177. exit
  178. alexandru@alex-lap:~/.osm/rail_port/rails$ rake gems:install
  179. WARNING: 'require 'rake/rdoctask'' is deprecated.  Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
  180.     at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
  181. Loaded suite /usr/bin/rake
  182. Started
  183.  
  184. Finished in 0.00253 seconds.
  185.  
  186. 0 tests, 0 assertions, 0 failures, 0 errors
  187. alexandru@alex-lap:~/.osm/rail_port/rails$ rake db:migrate
  188. WARNING: 'require 'rake/rdoctask'' is deprecated.  Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
  189.     at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
  190. ==  CreateOsmDb: migrating ====================================================
  191. -- innodb_table()
  192.    -> 0.0001s
  193. -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
  194.    -> 0.0431s
  195. -- add_index("current_nodes", ["id"], {:name=>"current_nodes_id_idx"})
  196.    -> 0.0557s
  197. -- add_index("current_nodes", ["latitude", "longitude"], {:name=>"current_nodes_lat_lon_idx"})
  198.    -> 0.0847s
  199. -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
  200.    -> 0.0625s
  201. -- change_column(:current_nodes, :id, :bigint_auto_64)
  202.    -> 0.1914s
  203. -- innodb_table()
  204.    -> 0.0000s
  205. -- create_table("current_segments", {:options=>"", :force=>true, :id=>false})
  206.    -> 0.0447s
  207. -- add_index("current_segments", ["id", "visible"], {:name=>"current_segments_id_visible_idx"})
  208.    -> 0.0557s
  209. -- add_index("current_segments", ["node_a"], {:name=>"current_segments_a_idx"})
  210.    -> 0.0448s
  211. -- add_index("current_segments", ["node_b"], {:name=>"current_segments_b_idx"})
  212.    -> 0.0666s
  213. -- change_column(:current_segments, :id, :bigint_auto_64)
  214.    -> 0.1802s
  215. -- innodb_table()
  216.    -> 0.0000s
  217. -- create_table("current_way_segments", {:options=>"", :force=>true, :id=>false})
  218.    -> 0.0039s
  219. -- add_index("current_way_segments", ["segment_id"], {:name=>"current_way_segments_seg_idx"})
  220.    -> 0.0380s
  221. -- add_index("current_way_segments", ["id"], {:name=>"current_way_segments_id_idx"})
  222.    -> 0.1140s
  223. -- myisam_table()
  224.    -> 0.0000s
  225. -- create_table("current_way_tags", {:options=>"", :force=>true, :id=>false})
  226.    -> 0.0563s
  227. -- add_index("current_way_tags", ["id"], {:name=>"current_way_tags_id_idx"})
  228.    -> 0.0516s
  229. -- add_fulltext_index("current_way_tags", "v")
  230.    -> 0.0489s
  231. -- myisam_table()
  232.    -> 0.0000s
  233. -- create_table("current_ways", {:options=>"", :force=>true, :id=>false})
  234. NOTICE:  CREATE TABLE will create implicit sequence "current_ways_id_seq" for serial column "current_ways.id"
  235. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_ways_pkey" for table "current_ways"
  236.    -> 0.0585s
  237. -- myisam_table()
  238.    -> 0.0001s
  239. -- create_table("diary_entries", {:options=>"", :force=>true, :id=>false})
  240. NOTICE:  CREATE TABLE will create implicit sequence "diary_entries_id_seq" for serial column "diary_entries.id"
  241. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "diary_entries_pkey" for table "diary_entries"
  242.    -> 0.1010s
  243. -- myisam_table()
  244.    -> 0.0001s
  245. -- create_table("friends", {:options=>"", :force=>true, :id=>false})
  246. NOTICE:  CREATE TABLE will create implicit sequence "friends_id_seq" for serial column "friends.id"
  247. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "friends_pkey" for table "friends"
  248.    -> 0.0559s
  249. -- add_index("friends", ["friend_user_id"], {:name=>"user_id_idx"})
  250.    -> 0.0446s
  251. -- myisam_table()
  252.    -> 0.0000s
  253. -- create_table("gps_points", {:options=>"", :force=>true, :id=>false})
  254.    -> 0.0059s
  255. -- add_index("gps_points", ["latitude", "longitude", "user_id"], {:name=>"points_idx"})
  256.    -> 0.0497s
  257. -- add_index("gps_points", ["user_id"], {:name=>"points_uid_idx"})
  258.    -> 0.0560s
  259. -- add_index("gps_points", ["gpx_id"], {:name=>"points_gpxid_idx"})
  260.    -> 0.0558s
  261. -- myisam_table()
  262.    -> 0.0000s
  263. -- create_table("gpx_file_tags", {:options=>"", :force=>true, :id=>false})
  264. NOTICE:  CREATE TABLE will create implicit sequence "gpx_file_tags_id_seq" for serial column "gpx_file_tags.id"
  265. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "gpx_file_tags_pkey" for table "gpx_file_tags"
  266.    -> 0.0560s
  267. -- add_index("gpx_file_tags", ["gpx_id"], {:name=>"gpx_file_tags_gpxid_idx"})
  268.    -> 0.0558s
  269. -- myisam_table()
  270.    -> 0.0000s
  271. -- create_table("gpx_files", {:options=>"", :force=>true, :id=>false})
  272. NOTICE:  CREATE TABLE will create implicit sequence "gpx_files_id_seq" for serial column "gpx_files.id"
  273. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "gpx_files_pkey" for table "gpx_files"
  274.    -> 0.1127s
  275. -- add_index("gpx_files", ["timestamp"], {:name=>"gpx_files_timestamp_idx"})
  276.    -> 0.0444s
  277. -- add_index("gpx_files", ["visible", "public"], {:name=>"gpx_files_visible_public_idx"})
  278.    -> 0.0448s
  279. -- myisam_table()
  280.    -> 0.0000s
  281. -- create_table("gpx_pending_files", {:options=>"", :force=>true, :id=>false})
  282.    -> 0.0450s
  283. -- myisam_table()
  284.    -> 0.0001s
  285. -- create_table("messages", {:options=>"", :force=>true, :id=>false})
  286. NOTICE:  CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
  287. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
  288.    -> 0.1231s
  289. -- add_index("messages", ["from_display_name"], {:name=>"from_name_idx"})
  290.    -> 0.0465s
  291. -- myisam_table()
  292.    -> 0.0000s
  293. -- create_table("meta_areas", {:options=>"", :force=>true, :id=>false})
  294. NOTICE:  CREATE TABLE will create implicit sequence "meta_areas_id_seq" for serial column "meta_areas.id"
  295. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "meta_areas_pkey" for table "meta_areas"
  296.    -> 0.0561s
  297. -- myisam_table()
  298.    -> 0.0001s
  299. -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
  300.    -> 0.0706s
  301. -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
  302.    -> 0.0524s
  303. -- add_index("nodes", ["latitude", "longitude"], {:name=>"nodes_latlon_idx"})
  304.    -> 0.0447s
  305. -- myisam_table()
  306.    -> 0.0000s
  307. -- create_table("segments", {:options=>"", :force=>true, :id=>false})
  308.    -> 0.0561s
  309. -- add_index("segments", ["node_a"], {:name=>"street_segments_nodea_idx"})
  310.    -> 0.0558s
  311. -- add_index("segments", ["node_b"], {:name=>"street_segments_nodeb_idx"})
  312.    -> 0.0560s
  313. -- add_index("segments", ["id"], {:name=>"street_segment_uid_idx"})
  314.    -> 0.0448s
  315. -- innodb_table()
  316.    -> 0.0000s
  317. -- create_table("users", {:options=>"", :force=>true, :id=>false})
  318. NOTICE:  CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
  319. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
  320.    -> 0.1012s
  321. -- add_index("users", ["email"], {:name=>"users_email_idx"})
  322.    -> 0.0547s
  323. -- add_index("users", ["display_name"], {:name=>"users_display_name_idx"})
  324.    -> 0.0460s
  325. -- myisam_table()
  326.    -> 0.0000s
  327. -- create_table("way_segments", {:options=>"", :force=>true, :id=>false})
  328.    -> 0.0061s
  329. -- add_primary_key("way_segments", ["id", "version", "sequence_id"])
  330. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_segments_pkey" for table "way_segments"
  331.    -> 0.0495s
  332. -- change_column("way_segments", "sequence_id", :bigint_auto_11)
  333.    -> 0.0449s
  334. -- myisam_table()
  335.    -> 0.0000s
  336. -- create_table("way_tags", {:options=>"", :force=>true, :id=>false})
  337.    -> 0.0450s
  338. -- add_index("way_tags", ["id", "version"], {:name=>"way_tags_id_version_idx"})
  339.    -> 0.0518s
  340. -- myisam_table()
  341.    -> 0.0000s
  342. -- create_table("ways", {:options=>"", :force=>true, :id=>false})
  343.    -> 0.0056s
  344. -- add_primary_key("ways", ["id", "version"])
  345. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ways_pkey" for table "ways"
  346.    -> 0.0541s
  347. -- add_index("ways", ["id"], {:name=>"ways_id_version_idx"})
  348.    -> 0.0446s
  349. -- change_column("ways", "version", :bigint_auto_20)
  350.    -> 0.1031s
  351. ==  CreateOsmDb: migrated (3.1531s) ===========================================
  352.  
  353. ==  CleanupOsmDb: migrating ===================================================
  354. -- change_column("current_nodes", "latitude", :double, {:null=>false})
  355.    -> 0.1858s
  356. -- change_column("current_nodes", "longitude", :double, {:null=>false})
  357.    -> 0.1683s
  358. -- change_column("current_nodes", "user_id", :bigint, {:limit=>20, :null=>false})
  359.    -> 0.1687s
  360. -- change_column("current_nodes", "visible", :boolean, {:null=>false})
  361.    -> 0.1574s
  362. -- change_column("current_nodes", "timestamp", :datetime, {:null=>false})
  363.    -> 0.1949s
  364. -- add_primary_key("current_nodes", ["id"])
  365. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_nodes_pkey" for table "current_nodes"
  366.    -> 0.0418s
  367. -- remove_index("current_nodes", {:name=>"current_nodes_id_idx"})
  368.    -> 0.0072s
  369. -- change_column("current_segments", "node_a", :bigint, {:limit=>64, :null=>false})
  370.    -> 0.1729s
  371. -- change_column("current_segments", "node_b", :bigint, {:limit=>64, :null=>false})
  372.    -> 0.1913s
  373. -- change_column("current_segments", "user_id", :bigint, {:limit=>20, :null=>false})
  374.    -> 0.1800s
  375. -- change_column("current_segments", "visible", :boolean, {:null=>false})
  376.    -> 0.1464s
  377. -- change_column("current_segments", "timestamp", :datetime, {:null=>false})
  378.    -> 0.1717s
  379. -- add_primary_key("current_segments", ["id"])
  380. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_segments_pkey" for table "current_segments"
  381.    -> 0.0427s
  382. -- remove_index("current_segments", {:name=>"current_segments_id_visible_idx"})
  383.    -> 0.0057s
  384. -- change_column("current_way_segments", "id", :bigint, {:limit=>64, :null=>false})
  385.    -> 0.0960s
  386. -- change_column("current_way_segments", "segment_id", :bigint, {:limit=>64, :null=>false})
  387.    -> 0.1129s
  388. -- change_column("current_way_segments", "sequence_id", :bigint, {:limit=>11, :null=>false})
  389.    -> 0.1000s
  390. -- add_primary_key("current_way_segments", ["id", "sequence_id"])
  391. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_segments_pkey" for table "current_way_segments"
  392.    -> 0.0439s
  393. -- remove_index("current_way_segments", {:name=>"current_way_segments_id_idx"})
  394.    -> 0.0054s
  395. -- change_column("current_way_tags", "id", :bigint, {:limit=>64, :null=>false})
  396.    -> 0.1639s
  397. -- change_column("current_ways", "user_id", :bigint, {:limit=>20, :null=>false})
  398.    -> 0.0447s
  399. -- change_column("current_ways", "timestamp", :datetime, {:null=>false})
  400.    -> 0.0559s
  401. -- change_column("current_ways", "visible", :boolean, {:null=>false})
  402.    -> 0.0573s
  403. -- change_engine("current_ways", "InnoDB")
  404.    -> 0.0002s
  405. -- change_column("diary_entries", "title", :string, {:null=>false})
  406.    -> 0.0996s
  407. -- change_column("diary_entries", "body", :text, {:null=>false})
  408.    -> 0.1028s
  409. -- change_column("diary_entries", "created_at", :datetime, {:null=>false})
  410.    -> 0.0788s
  411. -- change_column("diary_entries", "updated_at", :datetime, {:null=>false})
  412.    -> 0.1121s
  413. -- add_index("friends", ["user_id"], {:name=>"friends_user_id_idx"})
  414.    -> 0.0558s
  415. -- remove_index("gps_points", {:name=>"points_uid_idx"})
  416.    -> 0.0061s
  417. -- remove_index("gps_points", {:name=>"points_idx"})
  418.    -> 0.0075s
  419. -- remove_column("gps_points", "user_id")
  420.    -> 0.0015s
  421. -- add_index("gps_points", ["latitude", "longitude"], {:name=>"points_idx"})
  422.    -> 0.0506s
  423. -- change_column("gps_points", "trackid", :integer, {:null=>false})
  424.    -> 0.1017s
  425. -- change_column("gps_points", "latitude", :integer, {:null=>false})
  426.    -> 0.1122s
  427. -- change_column("gps_points", "longitude", :integer, {:null=>false})
  428.    -> 0.1012s
  429. -- change_column("gps_points", "gpx_id", :bigint, {:limit=>64, :null=>false})
  430.    -> 0.0898s
  431. -- change_column("gpx_file_tags", "tag", :string, {:null=>false})
  432.    -> 0.0787s
  433. -- change_column("gpx_files", "user_id", :bigint, {:limit=>20, :null=>false})
  434.    -> 0.1706s
  435. -- change_column("gpx_files", "timestamp", :datetime, {:null=>false})
  436.    -> 0.1696s
  437. -- change_column("gpx_files", "description", :string, {:null=>false, :default=>""})
  438.    -> 0.1818s
  439. -- change_column("gpx_files", "inserted", :boolean, {:null=>false})
  440.    -> 0.1878s
  441. -- drop_table("gpx_pending_files")
  442.    -> 0.0024s
  443. -- remove_index("messages", {:name=>"from_name_idx"})
  444.    -> 0.0044s
  445. -- remove_column("messages", "user_id")
  446.    -> 0.0014s
  447. -- remove_column("messages", "from_display_name")
  448.    -> 0.0018s
  449. -- change_column("messages", "title", :string, {:null=>false})
  450.    -> 0.0983s
  451. -- change_column("messages", "body", :text, {:null=>false})
  452.    -> 0.0820s
  453. -- change_column("messages", "sent_on", :datetime, {:null=>false})
  454.    -> 0.0788s
  455. -- change_column("messages", "message_read", :boolean, {:null=>false, :default=>false})
  456.    -> 0.0945s
  457. -- add_index("messages", ["to_user_id"], {:name=>"messages_to_user_id_idx"})
  458.    -> 0.0411s
  459. -- drop_table("meta_areas")
  460.    -> 0.0029s
  461. -- change_column("nodes", "id", :bigint, {:limit=>64, :null=>false})
  462.    -> 0.1674s
  463. -- change_column("nodes", "latitude", :double, {:null=>false})
  464.    -> 0.1340s
  465. -- change_column("nodes", "longitude", :double, {:null=>false})
  466.    -> 0.1350s
  467. -- change_column("nodes", "user_id", :bigint, {:limit=>20, :null=>false})
  468.    -> 0.1242s
  469. -- change_column("nodes", "visible", :boolean, {:null=>false})
  470.    -> 0.1236s
  471. -- change_column("nodes", "timestamp", :datetime, {:null=>false})
  472.    -> 0.1148s
  473. -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
  474.    -> 0.0436s
  475. -- change_column("segments", "id", :bigint, {:limit=>64, :null=>false})
  476.    -> 0.1699s
  477. -- change_column("segments", "node_a", :bigint, {:limit=>64, :null=>false})
  478.    -> 0.1797s
  479. -- change_column("segments", "node_b", :bigint, {:limit=>64, :null=>false})
  480.    -> 0.1690s
  481. -- change_column("segments", "user_id", :bigint, {:limit=>20, :null=>false})
  482.    -> 0.1626s
  483. -- change_column("segments", "visible", :boolean, {:null=>false})
  484.    -> 0.1432s
  485. -- change_column("segments", "timestamp", :datetime, {:null=>false})
  486.    -> 0.1688s
  487. -- add_index("segments", ["timestamp"], {:name=>"segments_timestamp_idx"})
  488.    -> 0.0438s
  489. -- remove_column("users", "preferences")
  490.    -> 0.0018s
  491. -- change_column("users", "email", :string, {:null=>false})
  492.    -> 0.1902s
  493. -- change_column("users", "pass_crypt", :string, {:null=>false})
  494.    -> 0.1576s
  495. -- change_column("users", "creation_time", :datetime, {:null=>false})
  496.    -> 0.1486s
  497. -- change_column("users", "display_name", :string, {:null=>false, :default=>""})
  498.    -> 0.1830s
  499. -- change_column("users", "data_public", :boolean, {:null=>false, :default=>false})
  500.    -> 0.1905s
  501. -- change_column("users", "home_lat", :double, {:default=>nil})
  502.    -> 0.1884s
  503. -- change_column("users", "home_lon", :double, {:default=>nil})
  504.    -> 0.1464s
  505. -- remove_index("users", {:name=>"users_email_idx"})
  506.    -> 0.0054s
  507. -- add_index("users", ["email"], {:unique=>true, :name=>"users_email_idx"})
  508.    -> 0.0538s
  509. -- remove_index("users", {:name=>"users_display_name_idx"})
  510.    -> 0.0049s
  511. -- add_index("users", ["display_name"], {:unique=>true, :name=>"users_display_name_idx"})
  512.    -> 0.0459s
  513. -- change_column("way_segments", "segment_id", :bigint, {:limit=>64, :null=>false})
  514.    -> 0.0795s
  515. -- change_column("way_tags", "k", :string, {:null=>false})
  516.    -> 0.1148s
  517. -- change_column("way_tags", "v", :string, {:null=>false})
  518.    -> 0.1002s
  519. -- change_column("way_tags", "version", :bigint, {:limit=>20, :null=>false})
  520.    -> 0.1888s
  521. -- change_column("ways", "user_id", :bigint, {:limit=>20, :null=>false})
  522.    -> 0.0805s
  523. -- change_column("ways", "timestamp", :datetime, {:null=>false})
  524.    -> 0.0895s
  525. -- change_column("ways", "visible", :boolean, {:null=>false, :default=>true})
  526.    -> 0.1036s
  527. -- remove_index("ways", {:name=>"ways_id_version_idx"})
  528.    -> 0.0050s
  529. -- add_index("ways", ["timestamp"], {:name=>"ways_timestamp_idx"})
  530.    -> 0.0360s
  531. ==  CleanupOsmDb: migrated (8.6391s) ==========================================
  532.  
  533. ==  SqlSessionStoreSetup: migrating ===========================================
  534. -- innodb_option()
  535.    -> 0.0001s
  536. -- create_table("sessions", {:options=>""})
  537. NOTICE:  CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
  538. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
  539.    -> 0.1655s
  540. -- add_index("sessions", ["session_id"], {:unique=>true, :name=>"sessions_session_id_idx"})
  541.    -> 0.0690s
  542. ==  SqlSessionStoreSetup: migrated (0.2350s) ==================================
  543.  
  544. ==  UserEnhancements: migrating ===============================================
  545. -- add_column("diary_entries", "latitude", :double)
  546.    -> 0.0017s
  547. -- add_column("diary_entries", "longitude", :double)
  548.    -> 0.0014s
  549. -- add_column("diary_entries", "language", :string, {:limit=>3})
  550.    -> 0.0013s
  551. -- innodb_table()
  552.    -> 0.0000s
  553. -- create_table("user_preferences", {:options=>"", :force=>true, :id=>false})
  554.    -> 0.0640s
  555. -- add_primary_key("user_preferences", ["user_id", "k"])
  556. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_preferences_pkey" for table "user_preferences"
  557.    -> 0.0446s
  558. -- innodb_table()
  559.    -> 0.0000s
  560. -- create_table("user_tokens", {:options=>"", :force=>true, :id=>false})
  561. NOTICE:  CREATE TABLE will create implicit sequence "user_tokens_id_seq" for serial column "user_tokens.id"
  562. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_tokens_pkey" for table "user_tokens"
  563.    -> 0.0449s
  564. -- add_index("user_tokens", ["token"], {:unique=>true, :name=>"user_tokens_token_idx"})
  565.    -> 0.0448s
  566. -- add_index("user_tokens", ["user_id"], {:name=>"user_tokens_user_id_idx"})
  567.    -> 0.0336s
  568. -- remove_column("users", "token")
  569.    -> 0.0016s
  570. -- remove_column("users", "timeout")
  571.    -> 0.0016s
  572. -- remove_column("users", "within_lon")
  573.    -> 0.0023s
  574. -- remove_column("users", "within_lat")
  575.    -> 0.0017s
  576. -- add_column("users", "nearby", :integer, {:default=>50})
  577.    -> 0.0026s
  578. -- add_column("users", "pass_salt", :string)
  579.    -> 0.0013s
  580. ==  UserEnhancements: migrated (0.2541s) ======================================
  581.  
  582. ==  TileTracepoints: migrating ================================================
  583. -- add_column("gps_points", "tile", :four_byte_unsigned)
  584.    -> 0.0021s
  585. -- add_index("gps_points", ["tile"], {:name=>"points_tile_idx"})
  586.    -> 0.0461s
  587. -- remove_index("gps_points", {:name=>"points_idx"})
  588.    -> 0.0066s
  589. ==  TileTracepoints: migrated (0.0710s) =======================================
  590.  
  591. ==  TileNodes: migrating ======================================================
  592. -- remove_index("current_nodes", {:name=>"current_nodes_timestamp_idx"})
  593.    -> 0.0053s
  594. -- rename_table("current_nodes", "current_nodes_v5")
  595.    -> 0.0015s
  596. -- innodb_table()
  597.    -> 0.0000s
  598. -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
  599. NOTICE:  CREATE TABLE will create implicit sequence "current_nodes_id_seq" for serial column "current_nodes.id"
  600. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_nodes_pkey1" for table "current_nodes"
  601.    -> 0.0980s
  602. -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
  603.    -> 0.0334s
  604. -- add_index("current_nodes", ["tile"], {:name=>"current_nodes_tile_idx"})
  605.    -> 0.0449s
  606. -- change_column("current_nodes", "tile", :four_byte_unsigned)
  607.    -> 0.1465s
  608. -- execute("      INSERT INTO current_nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n      SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n             user_id, visible, tags, timestamp, 0\n      FROM current_nodes_v5\n")
  609.    -> 0.0025s
  610. -- drop_table("current_nodes_v5")
  611.    -> 0.0056s
  612. -- remove_index("nodes", {:name=>"nodes_uid_idx"})
  613.    -> 0.0063s
  614. -- remove_index("nodes", {:name=>"nodes_timestamp_idx"})
  615.    -> 0.0059s
  616. -- rename_table("nodes", "nodes_v5")
  617.    -> 0.0015s
  618. -- myisam_table()
  619.    -> 0.0001s
  620. -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
  621.    -> 0.0404s
  622. -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
  623.    -> 0.0334s
  624. -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
  625.    -> 0.0336s
  626. -- add_index("nodes", ["tile"], {:name=>"nodes_tile_idx"})
  627.    -> 0.0467s
  628. -- change_column("nodes", "tile", :four_byte_unsigned)
  629.    -> 0.1577s
  630. -- execute("      INSERT INTO nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n      SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n             user_id, visible, tags, timestamp, 0\n      FROM nodes_v5\n")
  631.    -> 0.0019s
  632. -- drop_table("nodes_v5")
  633.    -> 0.0034s
  634. ==  TileNodes: migrated (0.8175s) =============================================
  635.  
  636. ==  AddRelations: migrating ===================================================
  637. -- create_enumeration(:nwr_enum, ["Node", "Way", "Relation"])
  638.    -> 0.0026s
  639. -- innodb_table()
  640.    -> 0.0000s
  641. -- create_table("current_relation_members", {:options=>"", :force=>true, :id=>false})
  642.    -> 0.0056s
  643. -- add_primary_key("current_relation_members", ["id", "member_type", "member_id", "member_role"])
  644. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
  645.    -> 0.0498s
  646. -- add_index("current_relation_members", ["member_type", "member_id"], {:name=>"current_relation_members_member_idx"})
  647.    -> 0.0335s
  648. -- myisam_table()
  649.    -> 0.0001s
  650. -- create_table("current_relation_tags", {:options=>"", :force=>true, :id=>false})
  651.    -> 0.0450s
  652. -- add_index("current_relation_tags", ["id"], {:name=>"current_relation_tags_id_idx"})
  653.    -> 0.0445s
  654. -- add_fulltext_index("current_relation_tags", "v")
  655.    -> 0.0338s
  656. -- innodb_table()
  657.    -> 0.0001s
  658. -- create_table("current_relations", {:options=>"", :force=>true, :id=>false})
  659. NOTICE:  CREATE TABLE will create implicit sequence "current_relations_id_seq" for serial column "current_relations.id"
  660. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_relations_pkey" for table "current_relations"
  661.    -> 0.0523s
  662. -- myisam_table()
  663.    -> 0.0001s
  664. -- create_table("relation_members", {:options=>"", :force=>true, :id=>false})
  665.    -> 0.0063s
  666. -- add_primary_key("relation_members", ["id", "version", "member_type", "member_id", "member_role"])
  667. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
  668.    -> 0.0313s
  669. -- add_index("relation_members", ["member_type", "member_id"], {:name=>"relation_members_member_idx"})
  670.    -> 0.0445s
  671. -- myisam_table()
  672.    -> 0.0000s
  673. -- create_table("relation_tags", {:options=>"", :force=>true, :id=>false})
  674.    -> 0.0450s
  675. -- add_index("relation_tags", ["id", "version"], {:name=>"relation_tags_id_version_idx"})
  676.    -> 0.0446s
  677. -- myisam_table()
  678.    -> 0.0001s
  679. -- create_table("relations", {:options=>"", :force=>true, :id=>false})
  680.    -> 0.0061s
  681. -- add_primary_key("relations", ["id", "version"])
  682. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relations_pkey" for table "relations"
  683.    -> 0.0545s
  684. -- add_index("relations", ["timestamp"], {:name=>"relations_timestamp_idx"})
  685.    -> 0.0399s
  686. -- change_column("relations", "version", :bigint_auto_20)
  687.    -> 0.0808s
  688. ==  AddRelations: migrated (0.6241s) ==========================================
  689.  
  690. ==  RemoveSegments: migrating =================================================
  691. -- select_value("SELECT count(*) FROM current_segments")
  692.    -> 0.0027s
  693. -- drop_table(:segments)
  694.    -> 0.0050s
  695. -- drop_table(:way_segments)
  696.    -> 0.0031s
  697. -- myisam_table()
  698.    -> 0.0000s
  699. -- create_table(:way_nodes, {:options=>"", :force=>true, :id=>false})
  700.    -> 0.0051s
  701. -- add_primary_key(:way_nodes, [:id, :version, :sequence_id])
  702. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_nodes_pkey" for table "way_nodes"
  703.    -> 0.0575s
  704. -- drop_table(:current_segments)
  705.    -> 0.0044s
  706. -- drop_table(:current_way_segments)
  707.    -> 0.0026s
  708. -- innodb_table()
  709.    -> 0.0000s
  710. -- create_table(:current_way_nodes, {:options=>"", :force=>true, :id=>false})
  711.    -> 0.0044s
  712. -- add_primary_key(:current_way_nodes, [:id, :sequence_id])
  713. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_nodes_pkey" for table "current_way_nodes"
  714.    -> 0.0433s
  715. -- add_index(:current_way_nodes, [:node_id], {:name=>"current_way_nodes_node_idx"})
  716.    -> 0.0337s
  717. -- execute("TRUNCATE way_tags")
  718.    -> 0.0680s
  719. -- execute("TRUNCATE ways")
  720.    -> 0.0896s
  721. -- execute("TRUNCATE current_way_tags")
  722.    -> 0.1015s
  723. -- execute("TRUNCATE current_ways")
  724.    -> 0.0338s
  725. ==  RemoveSegments: migrated (0.4572s) ========================================
  726.  
  727. ==  WayNodesNodeIdx: migrating ================================================
  728. -- add_index("way_nodes", ["node_id"], {:name=>"way_nodes_node_idx"})
  729.    -> 0.0809s
  730. ==  WayNodesNodeIdx: migrated (0.0811s) =======================================
  731.  
  732. ==  DiaryComments: migrating ==================================================
  733. -- myisam_table()
  734.    -> 0.0001s
  735. -- create_table("diary_comments", {:options=>"", :force=>true, :id=>false})
  736. NOTICE:  CREATE TABLE will create implicit sequence "diary_comments_id_seq" for serial column "diary_comments.id"
  737. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "diary_comments_pkey" for table "diary_comments"
  738.    -> 0.1065s
  739. -- add_index("diary_comments", ["diary_entry_id", "id"], {:unique=>true, :name=>"diary_comments_entry_id_idx"})
  740.    -> 0.0334s
  741. ==  DiaryComments: migrated (0.1406s) =========================================
  742.  
  743. ==  AddUserImage: migrating ===================================================
  744. -- add_column("users", "image", :text)
  745.    -> 0.0020s
  746. ==  AddUserImage: migrated (0.0022s) ==========================================
  747.  
  748. ==  AddAdminFlag: migrating ===================================================
  749. -- add_column("users", "administrator", :boolean, {:null=>false, :default=>false})
  750.    -> 0.0057s
  751. ==  AddAdminFlag: migrated (0.0059s) ==========================================
  752.  
  753. ==  AddEmailValid: migrating ==================================================
  754. -- add_column("users", "email_valid", :boolean, {:null=>false, :default=>false})
  755.    -> 0.0060s
  756. ==  AddEmailValid: migrated (0.0088s) =========================================
  757.  
  758. ==  AddNewEmail: migrating ====================================================
  759. -- add_column("users", "new_email", :string)
  760.    -> 0.0021s
  761. ==  AddNewEmail: migrated (0.0023s) ===========================================
  762.  
  763. ==  AddUserVisible: migrating =================================================
  764. -- add_column("users", "visible", :boolean, {:null=>false, :default=>true})
  765.    -> 0.0057s
  766. ==  AddUserVisible: migrated (0.0074s) ========================================
  767.  
  768. ==  AddCreationIp: migrating ==================================================
  769. -- add_column("users", "creation_ip", :string)
  770.    -> 0.0019s
  771. ==  AddCreationIp: migrated (0.0021s) =========================================
  772.  
  773. ==  AddGpxIndexes: migrating ==================================================
  774. -- add_index("gpx_files", ["user_id"], {:name=>"gpx_files_user_id_idx"})
  775.    -> 0.0394s
  776. -- add_index("gpx_file_tags", ["tag"], {:name=>"gpx_file_tags_tag_idx"})
  777.    -> 0.0337s
  778. ==  AddGpxIndexes: migrated (0.0735s) =========================================
  779.  
  780. ==  CreateAcls: migrating =====================================================
  781. -- myisam_table()
  782.    -> 0.0001s
  783. -- create_table("acls", {:options=>"", :force=>true, :id=>false})
  784. NOTICE:  CREATE TABLE will create implicit sequence "acls_id_seq" for serial column "acls.id"
  785. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acls_pkey" for table "acls"
  786.    -> 0.1034s
  787. -- add_index("acls", ["k"], {:name=>"acls_k_idx"})
  788.    -> 0.0337s
  789. ==  CreateAcls: migrated (0.1378s) ============================================
  790.  
  791. ==  AddTimestampIndexes: migrating ============================================
  792. -- add_index(:current_ways, :timestamp, {:name=>:current_ways_timestamp_idx})
  793.    -> 0.0413s
  794. -- add_index(:current_relations, :timestamp, {:name=>:current_relations_timestamp_idx})
  795.    -> 0.0447s
  796. ==  AddTimestampIndexes: migrated (0.0864s) ===================================
  797.  
  798. ==  PopulateNodeTagsAndRemove: migrating ======================================
  799. -- select_value("SELECT count(*) FROM current_nodes")
  800.    -> 0.0017s
  801. -- execute("TRUNCATE nodes")
  802.    -> 0.1383s
  803. -- remove_column(:nodes, :tags)
  804.    -> 0.0017s
  805. -- remove_column(:current_nodes, :tags)
  806.    -> 0.0015s
  807. -- add_column(:nodes, :version, :bigint, {:limit=>20, :null=>false})
  808.    -> 0.0023s
  809. -- innodb_table()
  810.    -> 0.0000s
  811. -- create_table(:current_node_tags, {:options=>"", :force=>true, :id=>false})
  812.    -> 0.0389s
  813. -- innodb_table()
  814.    -> 0.0001s
  815. -- create_table(:node_tags, {:options=>"", :force=>true, :id=>false})
  816.    -> 0.0448s
  817. ==  PopulateNodeTagsAndRemove: migrated (0.2308s) =============================
  818.  
  819. ==  MoveToInnodb: migrating ===================================================
  820. -- remove_index(:current_way_tags, {:name=>:current_way_tags_v_idx})
  821.    -> 0.0065s
  822. -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_v_idx})
  823.    -> 0.0061s
  824. -- change_column("nodes", "version", :bigint, {:limit=>20, :null=>false})
  825.    -> 0.1109s
  826. -- change_column("ways", "version", :bigint, {:limit=>20, :null=>false})
  827.    -> 0.0790s
  828. -- change_column("relations", "version", :bigint, {:limit=>20, :null=>false})
  829.    -> 0.0807s
  830. -- change_engine("nodes", "InnoDB")
  831.    -> 0.0002s
  832. -- change_engine("ways", "InnoDB")
  833.    -> 0.0001s
  834. -- change_engine("way_tags", "InnoDB")
  835.    -> 0.0001s
  836. -- change_engine("way_nodes", "InnoDB")
  837.    -> 0.0001s
  838. -- change_engine("current_way_tags", "InnoDB")
  839.    -> 0.0001s
  840. -- change_engine("relation_members", "InnoDB")
  841.    -> 0.0001s
  842. -- change_engine("relations", "InnoDB")
  843.    -> 0.0001s
  844. -- change_engine("relation_tags", "InnoDB")
  845.    -> 0.0001s
  846. -- change_engine("current_relation_tags", "InnoDB")
  847.    -> 0.0003s
  848. -- add_column("current_nodes", "version", :bigint, {:limit=>20, :null=>false})
  849.    -> 0.0022s
  850. -- add_column("current_ways", "version", :bigint, {:limit=>20, :null=>false})
  851.    -> 0.0169s
  852. -- add_column("current_relations", "version", :bigint, {:limit=>20, :null=>false})
  853.    -> 0.0087s
  854. ==  MoveToInnodb: migrated (0.4061s) ==========================================
  855.  
  856. ==  KeyConstraints: migrating =================================================
  857. -- add_primary_key(:current_node_tags, [:id, :k])
  858. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_node_tags_pkey" for table "current_node_tags"
  859.    -> 0.0665s
  860. -- add_primary_key(:current_way_tags, [:id, :k])
  861. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_tags_pkey" for table "current_way_tags"
  862.    -> 0.0685s
  863. -- add_primary_key(:current_relation_tags, [:id, :k])
  864. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_tags_pkey" for table "current_relation_tags"
  865.    -> 0.0448s
  866. -- add_primary_key(:node_tags, [:id, :version, :k])
  867. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "node_tags_pkey" for table "node_tags"
  868.    -> 0.0561s
  869. -- add_primary_key(:way_tags, [:id, :version, :k])
  870. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_tags_pkey" for table "way_tags"
  871.    -> 0.0337s
  872. -- add_primary_key(:relation_tags, [:id, :version, :k])
  873. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_tags_pkey" for table "relation_tags"
  874.    -> 0.0339s
  875. -- add_primary_key(:nodes, [:id, :version])
  876. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
  877.    -> 0.0561s
  878. -- remove_index(:current_way_tags, {:name=>:current_way_tags_id_idx})
  879.    -> 0.0048s
  880. -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_id_idx})
  881.    -> 0.0044s
  882. -- remove_index(:way_tags, {:name=>:way_tags_id_version_idx})
  883.    -> 0.0071s
  884. -- remove_index(:relation_tags, {:name=>:relation_tags_id_version_idx})
  885.    -> 0.0067s
  886. -- remove_index(:nodes, {:name=>:nodes_uid_idx})
  887.    -> 0.0119s
  888. -- add_foreign_key(:current_node_tags, [:id], :current_nodes)
  889.    -> 0.0055s
  890. -- add_foreign_key(:node_tags, [:id, :version], :nodes)
  891.    -> 0.0042s
  892. -- add_foreign_key(:current_way_tags, [:id], :current_ways)
  893.    -> 0.0037s
  894. -- add_foreign_key(:current_way_nodes, [:id], :current_ways)
  895.    -> 0.0036s
  896. -- add_foreign_key(:way_tags, [:id, :version], :ways)
  897.    -> 0.0044s
  898. -- add_foreign_key(:way_nodes, [:id, :version], :ways)
  899.    -> 0.0040s
  900. -- add_foreign_key(:current_relation_tags, [:id], :current_relations)
  901.    -> 0.0037s
  902. -- add_foreign_key(:current_relation_members, [:id], :current_relations)
  903.    -> 0.0040s
  904. -- add_foreign_key(:relation_tags, [:id, :version], :relations)
  905.    -> 0.0053s
  906. -- add_foreign_key(:relation_members, [:id, :version], :relations)
  907.    -> 0.0070s
  908. -- add_foreign_key(:current_way_nodes, [:node_id], :current_nodes, [:id])
  909.    -> 0.0043s
  910. ==  KeyConstraints: migrated (0.4482s) ========================================
  911.  
  912. ==  AddChangesets: migrating ==================================================
  913. -- innodb_table()
  914.    -> 0.0001s
  915. -- create_table("changesets", {:options=>"", :force=>true, :id=>false})
  916. NOTICE:  CREATE TABLE will create implicit sequence "changesets_id_seq" for serial column "changesets.id"
  917. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changesets_pkey" for table "changesets"
  918.    -> 0.0568s
  919. -- innodb_table()
  920.    -> 0.0001s
  921. -- create_table("changeset_tags", {:options=>"", :force=>true, :id=>false})
  922.    -> 0.0449s
  923. -- add_index("changeset_tags", ["id"], {:name=>"changeset_tags_id_idx"})
  924.    -> 0.0333s
  925. -- execute("INSERT INTO changesets (id, user_id, created_at, open)SELECT id, id, creation_time, false from users;")
  926.    -> 0.0013s
  927. -- rename_column("current_nodes", :user_id, :changeset_id)
  928.    -> 0.0017s
  929. -- add_foreign_key("current_nodes", [:changeset_id], :changesets, [:id])
  930.    -> 0.0041s
  931. -- rename_column("current_relations", :user_id, :changeset_id)
  932.    -> 0.0013s
  933. -- add_foreign_key("current_relations", [:changeset_id], :changesets, [:id])
  934.    -> 0.0035s
  935. -- rename_column("current_ways", :user_id, :changeset_id)
  936.    -> 0.0017s
  937. -- add_foreign_key("current_ways", [:changeset_id], :changesets, [:id])
  938.    -> 0.0044s
  939. -- rename_column("nodes", :user_id, :changeset_id)
  940.    -> 0.0015s
  941. -- add_foreign_key("nodes", [:changeset_id], :changesets, [:id])
  942.    -> 0.0039s
  943. -- rename_column("relations", :user_id, :changeset_id)
  944.    -> 0.0016s
  945. -- add_foreign_key("relations", [:changeset_id], :changesets, [:id])
  946.    -> 0.0041s
  947. -- rename_column("ways", :user_id, :changeset_id)
  948.    -> 0.0014s
  949. -- add_foreign_key("ways", [:changeset_id], :changesets, [:id])
  950.    -> 0.0041s
  951. ==  AddChangesets: migrated (0.1726s) =========================================
  952.  
  953. ==  OrderRelationMembers: migrating ===========================================
  954. -- add_column(:relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
  955.    -> 0.0060s
  956. -- execute("update relation_members set sequence_id = mod(member_id, 16384)")
  957.    -> 0.0011s
  958. -- alter_primary_key("relation_members", [:id, :version, :member_type, :member_id, :member_role, :sequence_id])
  959. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
  960.    -> 0.0563s
  961. -- add_column(:current_relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
  962.    -> 0.0102s
  963. -- execute("update current_relation_members set sequence_id = mod(member_id, 16384)")
  964.    -> 0.0009s
  965. -- alter_primary_key("current_relation_members", [:id, :member_type, :member_id, :member_role, :sequence_id])
  966. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
  967.    -> 0.0667s
  968. ==  OrderRelationMembers: migrated (0.1422s) ==================================
  969.  
  970. ==  AddEndTimeToChangesets: migrating =========================================
  971. -- add_column(:changesets, :closed_at, :datetime, {:null=>false})
  972.    -> 0.0037s
  973. -- interval_constant("1 hour")
  974.    -> 0.0002s
  975. -- execute("update changesets set closed_at=(now()-'1 hour'::interval) where open=(1=0)")
  976.    -> 0.0022s
  977. -- interval_constant("1 hour")
  978.    -> 0.0007s
  979. -- execute("update changesets set closed_at=(now()+'1 hour'::interval) where open=(1=1)")
  980.    -> 0.0010s
  981. -- remove_column(:changesets, :open)
  982.    -> 0.0020s
  983. -- add_column(:changesets, :num_changes, :integer, {:null=>false, :default=>0})
  984.    -> 0.0057s
  985. ==  AddEndTimeToChangesets: migrated (0.0167s) ================================
  986.  
  987. ==  AddChangesetUserIndex: migrating ==========================================
  988. -- add_index("changesets", ["user_id"], {:name=>"changesets_user_id_idx"})
  989.    -> 0.0597s
  990. ==  AddChangesetUserIndex: migrated (0.0599s) =================================
  991.  
  992. ==  AddChangesetIndexes: migrating ============================================
  993. -- add_index("nodes", ["changeset_id"], {:name=>"nodes_changeset_id_idx"})
  994.    -> 0.0596s
  995. -- add_index("ways", ["changeset_id"], {:name=>"ways_changeset_id_idx"})
  996.    -> 0.0449s
  997. -- add_index("relations", ["changeset_id"], {:name=>"relations_changeset_id_idx"})
  998.    -> 0.0448s
  999. ==  AddChangesetIndexes: migrated (0.1498s) ===================================
  1000.  
  1001. ==  AddMoreChangesetIndexes: migrating ========================================
  1002. -- add_index("changesets", ["created_at"], {:name=>"changesets_created_at_idx"})
  1003.    -> 0.0463s
  1004. -- add_index("changesets", ["closed_at"], {:name=>"changesets_closed_at_idx"})
  1005.    -> 0.0449s
  1006. -- add_index("changesets", ["min_lat", "max_lat", "min_lon", "max_lon"], {:method=>"GIST", :name=>"changesets_bbox_idx"})
  1007.    -> 0.0038s
  1008. ==  AddMoreChangesetIndexes: migrated (0.0956s) ===============================
  1009.  
  1010. ==  AddUserForeignKeys: migrating =============================================
  1011. -- add_foreign_key(:changesets, [:user_id], :users, [:id])
  1012.    -> 0.0045s
  1013. -- add_foreign_key(:diary_comments, [:user_id], :users, [:id])
  1014.    -> 0.0040s
  1015. -- add_foreign_key(:diary_entries, [:user_id], :users, [:id])
  1016.    -> 0.0042s
  1017. -- add_foreign_key(:friends, [:user_id], :users, [:id])
  1018.    -> 0.0052s
  1019. -- add_foreign_key(:friends, [:friend_user_id], :users, [:id])
  1020.    -> 0.0060s
  1021. -- add_foreign_key(:gpx_files, [:user_id], :users, [:id])
  1022.    -> 0.0053s
  1023. -- add_foreign_key(:messages, [:from_user_id], :users, [:id])
  1024.    -> 0.0048s
  1025. -- add_foreign_key(:messages, [:to_user_id], :users, [:id])
  1026.    -> 0.0041s
  1027. -- add_foreign_key(:user_preferences, [:user_id], :users, [:id])
  1028.    -> 0.0042s
  1029. -- add_foreign_key(:user_tokens, [:user_id], :users, [:id])
  1030.    -> 0.0049s
  1031. ==  AddUserForeignKeys: migrated (0.0489s) ====================================
  1032.  
  1033. ==  AddForeignKeys: migrating =================================================
  1034. -- add_foreign_key(:changeset_tags, [:id], :changesets)
  1035.    -> 0.0045s
  1036. -- add_foreign_key(:diary_comments, [:diary_entry_id], :diary_entries, [:id])
  1037.    -> 0.0040s
  1038. -- add_foreign_key(:gps_points, [:gpx_id], :gpx_files, [:id])
  1039.    -> 0.0047s
  1040. -- add_foreign_key(:gpx_file_tags, [:gpx_id], :gpx_files, [:id])
  1041.    -> 0.0040s
  1042. ==  AddForeignKeys: migrated (0.0179s) ========================================
  1043.  
  1044. ==  CreateCountries: migrating ================================================
  1045. -- innodb_table()
  1046.    -> 0.0001s
  1047. -- create_table(:countries, {:options=>"", :force=>true, :id=>false})
  1048. NOTICE:  CREATE TABLE will create implicit sequence "countries_id_seq" for serial column "countries.id"
  1049. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "countries_pkey" for table "countries"
  1050.    -> 0.0434s
  1051. -- add_index(:countries, [:code], {:unique=>true, :name=>"countries_code_idx"})
  1052.    -> 0.0348s
  1053. ==  CreateCountries: migrated (9.7120s) =======================================
  1054.  
  1055. ==  AddUserLocale: migrating ==================================================
  1056. -- add_column("users", "locale", :string)
  1057.    -> 0.0024s
  1058. ==  AddUserLocale: migrated (0.0026s) =========================================
  1059.  
  1060. ==  ChangeDiaryEntriesLanguage: migrating =====================================
  1061. -- remove_column("diary_entries", "language")
  1062.    -> 0.0018s
  1063. -- add_column("diary_entries", "language_code", :string, {:null=>false, :default=>"en"})
  1064.    -> 0.0056s
  1065. ==  ChangeDiaryEntriesLanguage: migrated (0.0078s) ============================
  1066.  
  1067. ==  CreateLanguages: migrating ================================================
  1068. -- innodb_table()
  1069.    -> 0.0001s
  1070. -- create_table(:languages, {:options=>"", :force=>true, :id=>false})
  1071.    -> 0.0499s
  1072. -- add_primary_key(:languages, [:code])
  1073. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "languages_pkey" for table "languages"
  1074.    -> 0.0445s
  1075. -- add_foreign_key(:users, [:locale], :languages, [:code])
  1076.    -> 0.0041s
  1077. -- add_foreign_key(:diary_entries, [:language_code], :languages, [:code])
  1078.    -> 0.0033s
  1079. ==  CreateLanguages: migrated (1.2910s) =======================================
  1080.  
  1081. ==  ChangeUserLocale: migrating ===============================================
  1082. -- remove_foreign_key(:users, [:locale], :languages, [:code])
  1083.    -> 0.0029s
  1084. -- rename_column(:users, :locale, :languages)
  1085.    -> 0.0014s
  1086. ==  ChangeUserLocale: migrated (0.0046s) ======================================
  1087.  
  1088. ==  AddVisibleToMessage: migrating ============================================
  1089. -- add_column(:messages, :visible, :boolean, {:null=>false, :default=>true})
  1090.    -> 0.0060s
  1091. ==  AddVisibleToMessage: migrated (0.0062s) ===================================
  1092.  
  1093. ==  AddSenderVisibleToMessage: migrating ======================================
  1094. -- rename_column(:messages, :visible, :to_user_visible)
  1095.    -> 0.0015s
  1096. -- add_column(:messages, :from_user_visible, :boolean, {:null=>false, :default=>true})
  1097.    -> 0.0054s
  1098. ==  AddSenderVisibleToMessage: migrated (0.0073s) =============================
  1099.  
  1100. ==  AddMessageSenderIndex: migrating ==========================================
  1101. -- add_index(:messages, [:from_user_id], {:name=>"messages_from_user_id_idx"})
  1102.    -> 0.0491s
  1103. ==  AddMessageSenderIndex: migrated (0.0493s) =================================
  1104.  
  1105. ==  AddMoreControlsToGpxFiles: migrating ======================================
  1106. -- create_enumeration(:gpx_visibility_enum, ["private", "public", "trackable", "identifiable"])
  1107.    -> 0.0018s
  1108. -- add_column(:gpx_files, :visibility, :gpx_visibility_enum, {:null=>false, :default=>"public"})
  1109.    -> 0.0056s
  1110. -- add_index(:gpx_files, [:visible, :visibility], {:name=>"gpx_files_visible_visibility_idx"})
  1111.    -> 0.0508s
  1112. -- remove_index(:gpx_files, {:name=>"gpx_files_visible_public_idx"})
  1113.    -> 0.0075s
  1114. -- remove_column(:gpx_files, :public)
  1115.    -> 0.0022s
  1116. ==  AddMoreControlsToGpxFiles: migrated (0.0887s) =============================
  1117.  
  1118. ==  CreateOauthTables: migrating ==============================================
  1119. -- create_table(:client_applications)
  1120. NOTICE:  CREATE TABLE will create implicit sequence "client_applications_id_seq" for serial column "client_applications.id"
  1121. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "client_applications_pkey" for table "client_applications"
  1122.    -> 0.1168s
  1123. -- add_index(:client_applications, :key, {:unique=>true})
  1124.    -> 0.0447s
  1125. -- create_table(:oauth_tokens)
  1126. NOTICE:  CREATE TABLE will create implicit sequence "oauth_tokens_id_seq" for serial column "oauth_tokens.id"
  1127. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "oauth_tokens_pkey" for table "oauth_tokens"
  1128.    -> 0.0563s
  1129. -- add_index(:oauth_tokens, :token, {:unique=>true})
  1130.    -> 0.0466s
  1131. -- create_table(:oauth_nonces)
  1132. NOTICE:  CREATE TABLE will create implicit sequence "oauth_nonces_id_seq" for serial column "oauth_nonces.id"
  1133. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "oauth_nonces_pkey" for table "oauth_nonces"
  1134.    -> 0.0675s
  1135. -- add_index(:oauth_nonces, [:nonce, :timestamp], {:unique=>true})
  1136.    -> 0.0559s
  1137. ==  CreateOauthTables: migrated (0.3887s) =====================================
  1138.  
  1139. ==  AddFineOAuthPermissions: migrating ========================================
  1140. -- add_column(:oauth_tokens, :allow_read_prefs, :boolean, {:null=>false, :default=>false})
  1141.    -> 0.0061s
  1142. -- add_column(:client_applications, :allow_read_prefs, :boolean, {:null=>false, :default=>false})
  1143.    -> 0.0050s
  1144. -- add_column(:oauth_tokens, :allow_write_prefs, :boolean, {:null=>false, :default=>false})
  1145.    -> 0.0226s
  1146. -- add_column(:client_applications, :allow_write_prefs, :boolean, {:null=>false, :default=>false})
  1147.    -> 0.0051s
  1148. -- add_column(:oauth_tokens, :allow_write_diary, :boolean, {:null=>false, :default=>false})
  1149.    -> 0.0050s
  1150. -- add_column(:client_applications, :allow_write_diary, :boolean, {:null=>false, :default=>false})
  1151.    -> 0.0054s
  1152. -- add_column(:oauth_tokens, :allow_write_api, :boolean, {:null=>false, :default=>false})
  1153.    -> 0.0050s
  1154. -- add_column(:client_applications, :allow_write_api, :boolean, {:null=>false, :default=>false})
  1155.    -> 0.0052s
  1156. -- add_column(:oauth_tokens, :allow_read_gpx, :boolean, {:null=>false, :default=>false})
  1157.    -> 0.0053s
  1158. -- add_column(:client_applications, :allow_read_gpx, :boolean, {:null=>false, :default=>false})
  1159.    -> 0.0054s
  1160. -- add_column(:oauth_tokens, :allow_write_gpx, :boolean, {:null=>false, :default=>false})
  1161.    -> 0.0052s
  1162. -- add_column(:client_applications, :allow_write_gpx, :boolean, {:null=>false, :default=>false})
  1163.    -> 0.0051s
  1164. ==  AddFineOAuthPermissions: migrated (0.1915s) ===============================
  1165.  
  1166. ==  AddForeignKeysToOauthTables: migrating ====================================
  1167. -- add_foreign_key(:oauth_tokens, [:user_id], :users, [:id])
  1168.    -> 0.0056s
  1169. -- add_foreign_key(:oauth_tokens, [:client_application_id], :client_applications, [:id])
  1170.    -> 0.0043s
  1171. -- add_foreign_key(:client_applications, [:user_id], :users, [:id])
  1172.    -> 0.0041s
  1173. ==  AddForeignKeysToOauthTables: migrated (0.0145s) ===========================
  1174.  
  1175. ==  AddRefererToUserToken: migrating ==========================================
  1176. -- add_column(:user_tokens, :referer, :text)
  1177.    -> 0.0621s
  1178. ==  AddRefererToUserToken: migrated (0.0623s) =================================
  1179.  
  1180. ==  CreateUserRoles: migrating ================================================
  1181. -- create_enumeration(:user_role_enum, ["administrator", "moderator"])
  1182.    -> 0.0016s
  1183. -- create_table(:user_roles)
  1184. NOTICE:  CREATE TABLE will create implicit sequence "user_roles_id_seq" for serial column "user_roles.id"
  1185. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_roles_pkey" for table "user_roles"
  1186.    -> 0.0450s
  1187. -- add_column(:user_roles, :role, :user_role_enum, {:null=>false})
  1188.    -> 0.0028s
  1189. -- remove_column(:users, :administrator)
  1190.    -> 0.0021s
  1191. -- add_foreign_key(:user_roles, [:user_id], :users, [:id])
  1192.    -> 0.0043s
  1193. ==  CreateUserRoles: migrated (0.0592s) =======================================
  1194.  
  1195. ==  CreateUserBlocks: migrating ===============================================
  1196. -- create_table(:user_blocks)
  1197. NOTICE:  CREATE TABLE will create implicit sequence "user_blocks_id_seq" for serial column "user_blocks.id"
  1198. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_blocks_pkey" for table "user_blocks"
  1199.    -> 0.1059s
  1200. -- add_foreign_key(:user_blocks, [:user_id], :users, [:id])
  1201.    -> 0.0045s
  1202. -- add_foreign_key(:user_blocks, [:moderator_id], :users, [:id])
  1203.    -> 0.0043s
  1204. -- add_foreign_key(:user_blocks, [:revoker_id], :users, [:id])
  1205.    -> 0.0045s
  1206. -- add_index(:user_blocks, [:user_id])
  1207.    -> 0.0421s
  1208. ==  CreateUserBlocks: migrated (0.1622s) ======================================
  1209.  
  1210. ==  AlterUserRolesAndBlocks: migrating ========================================
  1211. -- add_column(:user_roles, :granter_id, :bigint)
  1212.    -> 0.0018s
  1213. -- change_column(:user_roles, :granter_id, :bigint, {:null=>false})
  1214.    -> 0.0533s
  1215. -- add_foreign_key(:user_roles, [:granter_id], :users, [:id])
  1216.    -> 0.0042s
  1217. -- add_index(:user_roles, [:user_id, :role], {:unique=>true, :name=>"user_roles_id_role_unique"})
  1218.    -> 0.0554s
  1219. -- rename_column(:user_blocks, :moderator_id, :creator_id)
  1220.    -> 0.0015s
  1221. -- rename_column(:user_blocks, :end_at, :ends_at)
  1222.    -> 0.0013s
  1223. ==  AlterUserRolesAndBlocks: migrated (0.1260s) ===============================
  1224.  
  1225. ==  AddVisibleToDiaries: migrating ============================================
  1226. -- add_column(:diary_entries, :visible, :boolean, {:null=>false, :default=>true})
  1227.    -> 0.0060s
  1228. -- add_column(:diary_comments, :visible, :boolean, {:null=>false, :default=>true})
  1229.    -> 0.0054s
  1230. ==  AddVisibleToDiaries: migrated (0.0117s) ===================================
  1231.  
  1232. ==  AddDiaryCreationIndexes: migrating ========================================
  1233. -- add_index(:diary_entries, [:created_at], {:name=>"diary_entry_created_at_index"})
  1234.    -> 0.0464s
  1235. -- add_index(:diary_entries, [:user_id, :created_at], {:name=>"diary_entry_user_id_created_at_index"})
  1236.    -> 0.0448s
  1237. -- add_index(:diary_entries, [:language_code, :created_at], {:name=>"diary_entry_language_code_created_at_index"})
  1238.    -> 0.0450s
  1239. ==  AddDiaryCreationIndexes: migrated (0.1367s) ===============================
  1240.  
  1241. ==  ImproveChangesetUserIndex: migrating ======================================
  1242. -- add_index(:changesets, [:user_id, :id], {:name=>"changesets_user_id_id_idx"})
  1243.    -> 0.0478s
  1244. -- remove_index(:changesets, {:name=>"changesets_user_id_idx"})
  1245.    -> 0.0082s
  1246. ==  ImproveChangesetUserIndex: migrated (0.0563s) =============================
  1247.  
  1248. ==  AddUserIndexToDiaryComments: migrating ====================================
  1249. -- add_index(:diary_comments, [:user_id, :created_at], {:name=>"diary_comment_user_id_created_at_index"})
  1250.    -> 0.0479s
  1251. ==  AddUserIndexToDiaryComments: migrated (0.0481s) ===========================
  1252.  
  1253. ==  AddStatusToUser: migrating ================================================
  1254. -- create_enumeration(:user_status_enum, ["pending", "active", "confirmed", "suspended", "deleted"])
  1255.    -> 0.0020s
  1256. -- add_column(:users, :status, :user_status_enum, {:null=>false, :default=>"pending"})
  1257.    -> 0.0059s
  1258. -- remove_column(:users, :active)
  1259.    -> 0.0041s
  1260. -- remove_column(:users, :visible)
  1261.    -> 0.0023s
  1262. ==  AddStatusToUser: migrated (0.0197s) =======================================
  1263.  
  1264. ==  AddContributorTermsToUser: migrating ======================================
  1265. -- add_column(:users, :terms_agreed, :datetime)
  1266.    -> 0.0047s
  1267. -- add_column(:users, :consider_pd, :boolean, {:null=>false, :default=>false})
  1268.    -> 0.0069s
  1269. ==  AddContributorTermsToUser: migrated (0.0120s) =============================
  1270.  
  1271. ==  AddUserDateIndexToChangeset: migrating ====================================
  1272. -- add_index(:changesets, [:user_id, :created_at], {:name=>"changesets_user_id_created_at_idx"})
  1273.    -> 0.0485s
  1274. ==  AddUserDateIndexToChangeset: migrated (0.0487s) ===========================
  1275.  
  1276. ==  AddOpenId: migrating ======================================================
  1277. -- add_column(:users, :openid_url, :string)
  1278.    -> 0.0020s
  1279. -- add_index(:users, [:openid_url], {:unique=>true, :name=>"user_openid_url_idx"})
  1280.    -> 0.0482s
  1281. ==  AddOpenId: migrated (0.0506s) =============================================
  1282.  
  1283. ==  AddCallbackToOauthTokens: migrating =======================================
  1284. -- add_column(:oauth_tokens, :callback_url, :string)
  1285.    -> 0.0022s
  1286. -- add_column(:oauth_tokens, :verifier, :string, {:limit=>20})
  1287.    -> 0.0015s
  1288. ==  AddCallbackToOauthTokens: migrated (0.0041s) ==============================
  1289.  
  1290. ==  AddEditorPreferenceToUser: migrating ======================================
  1291. -- add_column(:users, :preferred_editor, :string)
  1292.    -> 0.0021s
  1293. ==  AddEditorPreferenceToUser: migrated (0.0023s) =============================
  1294.  
  1295. ==  AddTermsSeenToUser: migrating =============================================
  1296. -- add_column(:users, :terms_seen, :boolean, {:null=>false, :default=>false})
  1297.    -> 0.0059s
  1298. ==  AddTermsSeenToUser: migrated (0.0074s) ====================================
  1299.  
  1300. Loaded suite /usr/bin/rake
  1301. Started
  1302.  
  1303. Finished in 0.000269 seconds.
  1304.  
  1305. 0 tests, 0 assertions, 0 failures, 0 errors
  1306. alexandru@alex-lap:~/.osm/rail_port/rails$ echo here we go....
  1307. here we go....
  1308. alexandru@alex-lap:~/.osm/rail_port/rails$ env RAILS_ENV=production rake db:migrate
  1309. WARNING: 'require 'rake/rdoctask'' is deprecated.  Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
  1310.     at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
  1311. ==  CreateOsmDb: migrating ====================================================
  1312. -- innodb_table()
  1313.    -> 0.0000s
  1314. -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
  1315.    -> 0.0386s
  1316. -- add_index("current_nodes", ["id"], {:name=>"current_nodes_id_idx"})
  1317.    -> 0.0616s
  1318. -- add_index("current_nodes", ["latitude", "longitude"], {:name=>"current_nodes_lat_lon_idx"})
  1319.    -> 0.0609s
  1320. -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
  1321.    -> 0.0560s
  1322. -- change_column(:current_nodes, :id, :bigint_auto_64)
  1323.    -> 0.1911s
  1324. -- innodb_table()
  1325.    -> 0.0001s
  1326. -- create_table("current_segments", {:options=>"", :force=>true, :id=>false})
  1327.    -> 0.0468s
  1328. -- add_index("current_segments", ["id", "visible"], {:name=>"current_segments_id_visible_idx"})
  1329.    -> 0.0556s
  1330. -- add_index("current_segments", ["node_a"], {:name=>"current_segments_a_idx"})
  1331.    -> 0.0669s
  1332. -- add_index("current_segments", ["node_b"], {:name=>"current_segments_b_idx"})
  1333.    -> 0.0561s
  1334. -- change_column(:current_segments, :id, :bigint_auto_64)
  1335.    -> 0.1772s
  1336. -- innodb_table()
  1337.    -> 0.0000s
  1338. -- create_table("current_way_segments", {:options=>"", :force=>true, :id=>false})
  1339.    -> 0.0037s
  1340. -- add_index("current_way_segments", ["segment_id"], {:name=>"current_way_segments_seg_idx"})
  1341.    -> 0.0323s
  1342. -- add_index("current_way_segments", ["id"], {:name=>"current_way_segments_id_idx"})
  1343.    -> 0.0559s
  1344. -- myisam_table()
  1345.    -> 0.0001s
  1346. -- create_table("current_way_tags", {:options=>"", :force=>true, :id=>false})
  1347.    -> 0.0560s
  1348. -- add_index("current_way_tags", ["id"], {:name=>"current_way_tags_id_idx"})
  1349.    -> 0.0556s
  1350. -- add_fulltext_index("current_way_tags", "v")
  1351.    -> 0.0561s
  1352. -- myisam_table()
  1353.    -> 0.0001s
  1354. -- create_table("current_ways", {:options=>"", :force=>true, :id=>false})
  1355. NOTICE:  CREATE TABLE will create implicit sequence "current_ways_id_seq" for serial column "current_ways.id"
  1356. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_ways_pkey" for table "current_ways"
  1357.    -> 0.0674s
  1358. -- myisam_table()
  1359.    -> 0.0001s
  1360. -- create_table("diary_entries", {:options=>"", :force=>true, :id=>false})
  1361. NOTICE:  CREATE TABLE will create implicit sequence "diary_entries_id_seq" for serial column "diary_entries.id"
  1362. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "diary_entries_pkey" for table "diary_entries"
  1363.    -> 0.1276s
  1364. -- myisam_table()
  1365.    -> 0.0001s
  1366. -- create_table("friends", {:options=>"", :force=>true, :id=>false})
  1367. NOTICE:  CREATE TABLE will create implicit sequence "friends_id_seq" for serial column "friends.id"
  1368. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "friends_pkey" for table "friends"
  1369.    -> 0.0515s
  1370. -- add_index("friends", ["friend_user_id"], {:name=>"user_id_idx"})
  1371.    -> 0.0668s
  1372. -- myisam_table()
  1373.    -> 0.0001s
  1374. -- create_table("gps_points", {:options=>"", :force=>true, :id=>false})
  1375.    -> 0.0053s
  1376. -- add_index("gps_points", ["latitude", "longitude", "user_id"], {:name=>"points_idx"})
  1377.    -> 0.0525s
  1378. -- add_index("gps_points", ["user_id"], {:name=>"points_uid_idx"})
  1379.    -> 0.0676s
  1380. -- add_index("gps_points", ["gpx_id"], {:name=>"points_gpxid_idx"})
  1381.    -> 0.0551s
  1382. -- myisam_table()
  1383.    -> 0.0001s
  1384. -- create_table("gpx_file_tags", {:options=>"", :force=>true, :id=>false})
  1385. NOTICE:  CREATE TABLE will create implicit sequence "gpx_file_tags_id_seq" for serial column "gpx_file_tags.id"
  1386. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "gpx_file_tags_pkey" for table "gpx_file_tags"
  1387.    -> 0.0561s
  1388. -- add_index("gpx_file_tags", ["gpx_id"], {:name=>"gpx_file_tags_gpxid_idx"})
  1389.    -> 0.0668s
  1390. -- myisam_table()
  1391.    -> 0.0001s
  1392. -- create_table("gpx_files", {:options=>"", :force=>true, :id=>false})
  1393. NOTICE:  CREATE TABLE will create implicit sequence "gpx_files_id_seq" for serial column "gpx_files.id"
  1394. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "gpx_files_pkey" for table "gpx_files"
  1395.    -> 0.1456s
  1396. -- add_index("gpx_files", ["timestamp"], {:name=>"gpx_files_timestamp_idx"})
  1397.    -> 0.0446s
  1398. -- add_index("gpx_files", ["visible", "public"], {:name=>"gpx_files_visible_public_idx"})
  1399.    -> 0.0448s
  1400. -- myisam_table()
  1401.    -> 0.0001s
  1402. -- create_table("gpx_pending_files", {:options=>"", :force=>true, :id=>false})
  1403.    -> 0.0449s
  1404. -- myisam_table()
  1405.    -> 0.0001s
  1406. -- create_table("messages", {:options=>"", :force=>true, :id=>false})
  1407. NOTICE:  CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
  1408. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
  1409.    -> 0.1119s
  1410. -- add_index("messages", ["from_display_name"], {:name=>"from_name_idx"})
  1411.    -> 0.0445s
  1412. -- myisam_table()
  1413.    -> 0.0001s
  1414. -- create_table("meta_areas", {:options=>"", :force=>true, :id=>false})
  1415. NOTICE:  CREATE TABLE will create implicit sequence "meta_areas_id_seq" for serial column "meta_areas.id"
  1416. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "meta_areas_pkey" for table "meta_areas"
  1417.    -> 0.0564s
  1418. -- myisam_table()
  1419.    -> 0.0001s
  1420. -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
  1421.    -> 0.0672s
  1422. -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
  1423.    -> 0.0334s
  1424. -- add_index("nodes", ["latitude", "longitude"], {:name=>"nodes_latlon_idx"})
  1425.    -> 0.0559s
  1426. -- myisam_table()
  1427.    -> 0.0001s
  1428. -- create_table("segments", {:options=>"", :force=>true, :id=>false})
  1429.    -> 0.0559s
  1430. -- add_index("segments", ["node_a"], {:name=>"street_segments_nodea_idx"})
  1431.    -> 0.0723s
  1432. -- add_index("segments", ["node_b"], {:name=>"street_segments_nodeb_idx"})
  1433.    -> 0.0412s
  1434. -- add_index("segments", ["id"], {:name=>"street_segment_uid_idx"})
  1435.    -> 0.0559s
  1436. -- innodb_table()
  1437.    -> 0.0001s
  1438. -- create_table("users", {:options=>"", :force=>true, :id=>false})
  1439. NOTICE:  CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
  1440. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
  1441.    -> 0.1124s
  1442. -- add_index("users", ["email"], {:name=>"users_email_idx"})
  1443.    -> 0.0556s
  1444. -- add_index("users", ["display_name"], {:name=>"users_display_name_idx"})
  1445.    -> 0.0449s
  1446. -- myisam_table()
  1447.    -> 0.0001s
  1448. -- create_table("way_segments", {:options=>"", :force=>true, :id=>false})
  1449.    -> 0.0055s
  1450. -- add_primary_key("way_segments", ["id", "version", "sequence_id"])
  1451. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_segments_pkey" for table "way_segments"
  1452.    -> 0.0612s
  1453. -- change_column("way_segments", "sequence_id", :bigint_auto_11)
  1454.    -> 0.0779s
  1455. -- myisam_table()
  1456.    -> 0.0000s
  1457. -- create_table("way_tags", {:options=>"", :force=>true, :id=>false})
  1458.    -> 0.0568s
  1459. -- add_index("way_tags", ["id", "version"], {:name=>"way_tags_id_version_idx"})
  1460.    -> 0.0441s
  1461. -- myisam_table()
  1462.    -> 0.0001s
  1463. -- create_table("ways", {:options=>"", :force=>true, :id=>false})
  1464.    -> 0.0054s
  1465. -- add_primary_key("ways", ["id", "version"])
  1466. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ways_pkey" for table "ways"
  1467.    -> 0.0502s
  1468. -- add_index("ways", ["id"], {:name=>"ways_id_version_idx"})
  1469.    -> 0.0448s
  1470. -- change_column("ways", "version", :bigint_auto_20)
  1471.    -> 0.1010s
  1472. ==  CreateOsmDb: migrated (3.2350s) ===========================================
  1473.  
  1474. ==  CleanupOsmDb: migrating ===================================================
  1475. -- change_column("current_nodes", "latitude", :double, {:null=>false})
  1476.    -> 0.2069s
  1477. -- change_column("current_nodes", "longitude", :double, {:null=>false})
  1478.    -> 0.1688s
  1479. -- change_column("current_nodes", "user_id", :bigint, {:null=>false, :limit=>20})
  1480.    -> 0.1686s
  1481. -- change_column("current_nodes", "visible", :boolean, {:null=>false})
  1482.    -> 0.1575s
  1483. -- change_column("current_nodes", "timestamp", :datetime, {:null=>false})
  1484.    -> 0.1800s
  1485. -- add_primary_key("current_nodes", ["id"])
  1486. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_nodes_pkey" for table "current_nodes"
  1487.    -> 0.0440s
  1488. -- remove_index("current_nodes", {:name=>"current_nodes_id_idx"})
  1489.    -> 0.0071s
  1490. -- change_column("current_segments", "node_a", :bigint, {:null=>false, :limit=>64})
  1491.    -> 0.2085s
  1492. -- change_column("current_segments", "node_b", :bigint, {:null=>false, :limit=>64})
  1493.    -> 0.1685s
  1494. -- change_column("current_segments", "user_id", :bigint, {:null=>false, :limit=>20})
  1495.    -> 0.1568s
  1496. -- change_column("current_segments", "visible", :boolean, {:null=>false})
  1497.    -> 0.1583s
  1498. -- change_column("current_segments", "timestamp", :datetime, {:null=>false})
  1499.    -> 0.1687s
  1500. -- add_primary_key("current_segments", ["id"])
  1501. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_segments_pkey" for table "current_segments"
  1502.    -> 0.0440s
  1503. -- remove_index("current_segments", {:name=>"current_segments_id_visible_idx"})
  1504.    -> 0.0063s
  1505. -- change_column("current_way_segments", "id", :bigint, {:null=>false, :limit=>64})
  1506.    -> 0.1174s
  1507. -- change_column("current_way_segments", "segment_id", :bigint, {:null=>false, :limit=>64})
  1508.    -> 0.1269s
  1509. -- change_column("current_way_segments", "sequence_id", :bigint, {:null=>false, :limit=>11})
  1510.    -> 0.1015s
  1511. -- add_primary_key("current_way_segments", ["id", "sequence_id"])
  1512. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_segments_pkey" for table "current_way_segments"
  1513.    -> 0.0430s
  1514. -- remove_index("current_way_segments", {:name=>"current_way_segments_id_idx"})
  1515.    -> 0.0054s
  1516. -- change_column("current_way_tags", "id", :bigint, {:null=>false, :limit=>64})
  1517.    -> 0.1526s
  1518. -- change_column("current_ways", "user_id", :bigint, {:null=>false, :limit=>20})
  1519.    -> 0.0449s
  1520. -- change_column("current_ways", "timestamp", :datetime, {:null=>false})
  1521.    -> 0.0561s
  1522. -- change_column("current_ways", "visible", :boolean, {:null=>false})
  1523.    -> 0.0557s
  1524. -- change_engine("current_ways", "InnoDB")
  1525.    -> 0.0002s
  1526. -- change_column("diary_entries", "title", :string, {:null=>false})
  1527.    -> 0.1008s
  1528. -- change_column("diary_entries", "body", :text, {:null=>false})
  1529.    -> 0.1009s
  1530. -- change_column("diary_entries", "created_at", :datetime, {:null=>false})
  1531.    -> 0.1068s
  1532. -- change_column("diary_entries", "updated_at", :datetime, {:null=>false})
  1533.    -> 0.0862s
  1534. -- add_index("friends", ["user_id"], {:name=>"friends_user_id_idx"})
  1535.    -> 0.0327s
  1536. -- remove_index("gps_points", {:name=>"points_uid_idx"})
  1537.    -> 0.0063s
  1538. -- remove_index("gps_points", {:name=>"points_idx"})
  1539.    -> 0.0047s
  1540. -- remove_column("gps_points", "user_id")
  1541.    -> 0.0012s
  1542. -- add_index("gps_points", ["latitude", "longitude"], {:name=>"points_idx"})
  1543.    -> 0.0430s
  1544. -- change_column("gps_points", "trackid", :integer, {:null=>false})
  1545.    -> 0.0907s
  1546. -- change_column("gps_points", "latitude", :integer, {:null=>false})
  1547.    -> 0.0789s
  1548. -- change_column("gps_points", "longitude", :integer, {:null=>false})
  1549.    -> 0.0900s
  1550. -- change_column("gps_points", "gpx_id", :bigint, {:null=>false, :limit=>64})
  1551.    -> 0.0912s
  1552. -- change_column("gpx_file_tags", "tag", :string, {:null=>false})
  1553.    -> 0.0994s
  1554. -- change_column("gpx_files", "user_id", :bigint, {:null=>false, :limit=>20})
  1555.    -> 0.1798s
  1556. -- change_column("gpx_files", "timestamp", :datetime, {:null=>false})
  1557.    -> 0.1820s
  1558. -- change_column("gpx_files", "description", :string, {:null=>false, :default=>""})
  1559.    -> 0.1491s
  1560. -- change_column("gpx_files", "inserted", :boolean, {:null=>false})
  1561.    -> 0.1666s
  1562. -- drop_table("gpx_pending_files")
  1563.    -> 0.0022s
  1564. -- remove_index("messages", {:name=>"from_name_idx"})
  1565.    -> 0.0047s
  1566. -- remove_column("messages", "user_id")
  1567.    -> 0.0012s
  1568. -- remove_column("messages", "from_display_name")
  1569.    -> 0.0013s
  1570. -- change_column("messages", "title", :string, {:null=>false})
  1571.    -> 0.0904s
  1572. -- change_column("messages", "body", :text, {:null=>false})
  1573.    -> 0.1008s
  1574. -- change_column("messages", "sent_on", :datetime, {:null=>false})
  1575.    -> 0.0990s
  1576. -- change_column("messages", "message_read", :boolean, {:null=>false, :default=>false})
  1577.    -> 0.0728s
  1578. -- add_index("messages", ["to_user_id"], {:name=>"messages_to_user_id_idx"})
  1579.    -> 0.0408s
  1580. -- drop_table("meta_areas")
  1581.    -> 0.0049s
  1582. -- change_column("nodes", "id", :bigint, {:null=>false, :limit=>64})
  1583.    -> 0.1260s
  1584. -- change_column("nodes", "latitude", :double, {:null=>false})
  1585.    -> 0.1079s
  1586. -- change_column("nodes", "longitude", :double, {:null=>false})
  1587.    -> 0.1017s
  1588. -- change_column("nodes", "user_id", :bigint, {:null=>false, :limit=>20})
  1589.    -> 0.1238s
  1590. -- change_column("nodes", "visible", :boolean, {:null=>false})
  1591.    -> 0.1117s
  1592. -- change_column("nodes", "timestamp", :datetime, {:null=>false})
  1593.    -> 0.1245s
  1594. -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
  1595.    -> 0.0439s
  1596. -- change_column("segments", "id", :bigint, {:null=>false, :limit=>64})
  1597.    -> 0.1603s
  1598. -- change_column("segments", "node_a", :bigint, {:null=>false, :limit=>64})
  1599.    -> 0.1578s
  1600. -- change_column("segments", "node_b", :bigint, {:null=>false, :limit=>64})
  1601.    -> 0.2024s
  1602. -- change_column("segments", "user_id", :bigint, {:null=>false, :limit=>20})
  1603.    -> 0.1464s
  1604. -- change_column("segments", "visible", :boolean, {:null=>false})
  1605.    -> 0.1802s
  1606. -- change_column("segments", "timestamp", :datetime, {:null=>false})
  1607.    -> 0.1625s
  1608. -- add_index("segments", ["timestamp"], {:name=>"segments_timestamp_idx"})
  1609.    -> 0.0295s
  1610. -- remove_column("users", "preferences")
  1611.    -> 0.0013s
  1612. -- change_column("users", "email", :string, {:null=>false})
  1613.    -> 0.1461s
  1614. -- change_column("users", "pass_crypt", :string, {:null=>false})
  1615.    -> 0.1462s
  1616. -- change_column("users", "creation_time", :datetime, {:null=>false})
  1617.    -> 0.1688s
  1618. -- change_column("users", "display_name", :string, {:null=>false, :default=>""})
  1619.    -> 0.1630s
  1620. -- change_column("users", "data_public", :boolean, {:null=>false, :default=>false})
  1621.    -> 0.1562s
  1622. -- change_column("users", "home_lat", :double, {:default=>nil})
  1623.    -> 0.1556s
  1624. -- change_column("users", "home_lon", :double, {:default=>nil})
  1625.    -> 0.1567s
  1626. -- remove_index("users", {:name=>"users_email_idx"})
  1627.    -> 0.0051s
  1628. -- add_index("users", ["email"], {:name=>"users_email_idx", :unique=>true})
  1629.    -> 0.0390s
  1630. -- remove_index("users", {:name=>"users_display_name_idx"})
  1631.    -> 0.0055s
  1632. -- add_index("users", ["display_name"], {:name=>"users_display_name_idx", :unique=>true})
  1633.    -> 0.0391s
  1634. -- change_column("way_segments", "segment_id", :bigint, {:null=>false, :limit=>64})
  1635.    -> 0.0457s
  1636. -- change_column("way_tags", "k", :string, {:null=>false})
  1637.    -> 0.0865s
  1638. -- change_column("way_tags", "v", :string, {:null=>false})
  1639.    -> 0.0934s
  1640. -- change_column("way_tags", "version", :bigint, {:null=>false, :limit=>20})
  1641.    -> 0.0807s
  1642. -- change_column("ways", "user_id", :bigint, {:null=>false, :limit=>20})
  1643.    -> 0.0787s
  1644. -- change_column("ways", "timestamp", :datetime, {:null=>false})
  1645.    -> 0.0676s
  1646. -- change_column("ways", "visible", :boolean, {:null=>false, :default=>true})
  1647.    -> 0.0700s
  1648. -- remove_index("ways", {:name=>"ways_id_version_idx"})
  1649.    -> 0.0051s
  1650. -- add_index("ways", ["timestamp"], {:name=>"ways_timestamp_idx"})
  1651.    -> 0.0362s
  1652. ==  CleanupOsmDb: migrated (8.1178s) ==========================================
  1653.  
  1654. ==  SqlSessionStoreSetup: migrating ===========================================
  1655. -- innodb_option()
  1656.    -> 0.0000s
  1657. -- create_table("sessions", {:options=>""})
  1658. NOTICE:  CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
  1659. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
  1660.    -> 0.0973s
  1661. -- add_index("sessions", ["session_id"], {:name=>"sessions_session_id_idx", :unique=>true})
  1662.    -> 0.0335s
  1663. ==  SqlSessionStoreSetup: migrated (0.1313s) ==================================
  1664.  
  1665. ==  UserEnhancements: migrating ===============================================
  1666. -- add_column("diary_entries", "latitude", :double)
  1667.    -> 0.0022s
  1668. -- add_column("diary_entries", "longitude", :double)
  1669.    -> 0.0013s
  1670. -- add_column("diary_entries", "language", :string, {:limit=>3})
  1671.    -> 0.0012s
  1672. -- innodb_table()
  1673.    -> 0.0000s
  1674. -- create_table("user_preferences", {:options=>"", :force=>true, :id=>false})
  1675.    -> 0.0505s
  1676. -- add_primary_key("user_preferences", ["user_id", "k"])
  1677. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_preferences_pkey" for table "user_preferences"
  1678.    -> 0.0445s
  1679. -- innodb_table()
  1680.    -> 0.0000s
  1681. -- create_table("user_tokens", {:options=>"", :force=>true, :id=>false})
  1682. NOTICE:  CREATE TABLE will create implicit sequence "user_tokens_id_seq" for serial column "user_tokens.id"
  1683. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_tokens_pkey" for table "user_tokens"
  1684.    -> 0.0449s
  1685. -- add_index("user_tokens", ["token"], {:name=>"user_tokens_token_idx", :unique=>true})
  1686.    -> 0.0445s
  1687. -- add_index("user_tokens", ["user_id"], {:name=>"user_tokens_user_id_idx"})
  1688.    -> 0.0579s
  1689. -- remove_column("users", "token")
  1690.    -> 0.0015s
  1691. -- remove_column("users", "timeout")
  1692.    -> 0.0013s
  1693. -- remove_column("users", "within_lon")
  1694.    -> 0.0012s
  1695. -- remove_column("users", "within_lat")
  1696.    -> 0.0014s
  1697. -- add_column("users", "nearby", :integer, {:default=>50})
  1698.    -> 0.0026s
  1699. -- add_column("users", "pass_salt", :string)
  1700.    -> 0.0014s
  1701. ==  UserEnhancements: migrated (0.2637s) ======================================
  1702.  
  1703. ==  TileTracepoints: migrating ================================================
  1704. -- add_column("gps_points", "tile", :four_byte_unsigned)
  1705.    -> 0.0014s
  1706. -- add_index("gps_points", ["tile"], {:name=>"points_tile_idx"})
  1707.    -> 0.0326s
  1708. -- remove_index("gps_points", {:name=>"points_idx"})
  1709.    -> 0.0075s
  1710. ==  TileTracepoints: migrated (0.2084s) =======================================
  1711.  
  1712. ==  TileNodes: migrating ======================================================
  1713. -- remove_index("current_nodes", {:name=>"current_nodes_timestamp_idx"})
  1714.    -> 0.0055s
  1715. -- rename_table("current_nodes", "current_nodes_v5")
  1716.    -> 0.0013s
  1717. -- innodb_table()
  1718.    -> 0.0001s
  1719. -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
  1720. NOTICE:  CREATE TABLE will create implicit sequence "current_nodes_id_seq" for serial column "current_nodes.id"
  1721. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_nodes_pkey1" for table "current_nodes"
  1722.    -> 0.0743s
  1723. -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
  1724.    -> 0.0445s
  1725. -- add_index("current_nodes", ["tile"], {:name=>"current_nodes_tile_idx"})
  1726.    -> 0.0336s
  1727. -- change_column("current_nodes", "tile", :four_byte_unsigned)
  1728.    -> 0.1591s
  1729. -- execute("      INSERT INTO current_nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n      SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n             user_id, visible, tags, timestamp, 0\n      FROM current_nodes_v5\n")
  1730.    -> 0.0024s
  1731. -- drop_table("current_nodes_v5")
  1732.    -> 0.0035s
  1733. -- remove_index("nodes", {:name=>"nodes_uid_idx"})
  1734.    -> 0.0067s
  1735. -- remove_index("nodes", {:name=>"nodes_timestamp_idx"})
  1736.    -> 0.0051s
  1737. -- rename_table("nodes", "nodes_v5")
  1738.    -> 0.0012s
  1739. -- myisam_table()
  1740.    -> 0.0000s
  1741. -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
  1742.    -> 0.0514s
  1743. -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
  1744.    -> 0.0446s
  1745. -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
  1746.    -> 0.0336s
  1747. -- add_index("nodes", ["tile"], {:name=>"nodes_tile_idx"})
  1748.    -> 0.0554s
  1749. -- change_column("nodes", "tile", :four_byte_unsigned)
  1750.    -> 0.1693s
  1751. -- execute("      INSERT INTO nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n      SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n             user_id, visible, tags, timestamp, 0\n      FROM nodes_v5\n")
  1752.    -> 0.0014s
  1753. -- drop_table("nodes_v5")
  1754.    -> 0.0031s
  1755. ==  TileNodes: migrated (0.7218s) =============================================
  1756.  
  1757. ==  AddRelations: migrating ===================================================
  1758. -- create_enumeration(:nwr_enum, ["Node", "Way", "Relation"])
  1759.    -> 0.0025s
  1760. -- innodb_table()
  1761.    -> 0.0001s
  1762. -- create_table("current_relation_members", {:options=>"", :force=>true, :id=>false})
  1763.    -> 0.0055s
  1764. -- add_primary_key("current_relation_members", ["id", "member_type", "member_id", "member_role"])
  1765. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
  1766.    -> 0.0482s
  1767. -- add_index("current_relation_members", ["member_type", "member_id"], {:name=>"current_relation_members_member_idx"})
  1768.    -> 0.0336s
  1769. -- myisam_table()
  1770.    -> 0.0001s
  1771. -- create_table("current_relation_tags", {:options=>"", :force=>true, :id=>false})
  1772.    -> 0.0338s
  1773. -- add_index("current_relation_tags", ["id"], {:name=>"current_relation_tags_id_idx"})
  1774.    -> 0.0334s
  1775. -- add_fulltext_index("current_relation_tags", "v")
  1776.    -> 0.0484s
  1777. -- innodb_table()
  1778.    -> 0.0001s
  1779. -- create_table("current_relations", {:options=>"", :force=>true, :id=>false})
  1780. NOTICE:  CREATE TABLE will create implicit sequence "current_relations_id_seq" for serial column "current_relations.id"
  1781. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "current_relations_pkey" for table "current_relations"
  1782.    -> 0.0412s
  1783. -- myisam_table()
  1784.    -> 0.0001s
  1785. -- create_table("relation_members", {:options=>"", :force=>true, :id=>false})
  1786.    -> 0.0059s
  1787. -- add_primary_key("relation_members", ["id", "version", "member_type", "member_id", "member_role"])
  1788. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
  1789.    -> 0.0385s
  1790. -- add_index("relation_members", ["member_type", "member_id"], {:name=>"relation_members_member_idx"})
  1791.    -> 0.0336s
  1792. -- myisam_table()
  1793.    -> 0.0001s
  1794. -- create_table("relation_tags", {:options=>"", :force=>true, :id=>false})
  1795.    -> 0.0452s
  1796. -- add_index("relation_tags", ["id", "version"], {:name=>"relation_tags_id_version_idx"})
  1797.    -> 0.0443s
  1798. -- myisam_table()
  1799.    -> 0.0001s
  1800. -- create_table("relations", {:options=>"", :force=>true, :id=>false})
  1801.    -> 0.0058s
  1802. -- add_primary_key("relations", ["id", "version"])
  1803. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relations_pkey" for table "relations"
  1804.    -> 0.0388s
  1805. -- add_index("relations", ["timestamp"], {:name=>"relations_timestamp_idx"})
  1806.    -> 0.0337s
  1807. -- change_column("relations", "version", :bigint_auto_20)
  1808.    -> 0.0900s
  1809. ==  AddRelations: migrated (0.5873s) ==========================================
  1810.  
  1811. ==  RemoveSegments: migrating =================================================
  1812. -- select_value("SELECT count(*) FROM current_segments")
  1813.    -> 0.0020s
  1814. -- drop_table(:segments)
  1815.    -> 0.0052s
  1816. -- drop_table(:way_segments)
  1817.    -> 0.0032s
  1818. -- myisam_table()
  1819.    -> 0.0001s
  1820. -- create_table(:way_nodes, {:options=>"", :force=>true, :id=>false})
  1821.    -> 0.0056s
  1822. -- add_primary_key(:way_nodes, [:id, :version, :sequence_id])
  1823. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_nodes_pkey" for table "way_nodes"
  1824.    -> 0.0529s
  1825. -- drop_table(:current_segments)
  1826.    -> 0.0038s
  1827. -- drop_table(:current_way_segments)
  1828.    -> 0.0025s
  1829. -- innodb_table()
  1830.    -> 0.0000s
  1831. -- create_table(:current_way_nodes, {:options=>"", :force=>true, :id=>false})
  1832.    -> 0.0046s
  1833. -- add_primary_key(:current_way_nodes, [:id, :sequence_id])
  1834. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_nodes_pkey" for table "current_way_nodes"
  1835.    -> 0.0667s
  1836. -- add_index(:current_way_nodes, [:node_id], {:name=>"current_way_nodes_node_idx"})
  1837.    -> 0.0337s
  1838. -- execute("TRUNCATE way_tags")
  1839.    -> 0.0920s
  1840. -- execute("TRUNCATE ways")
  1841.    -> 0.0899s
  1842. -- execute("TRUNCATE current_way_tags")
  1843.    -> 0.1460s
  1844. -- execute("TRUNCATE current_ways")
  1845.    -> 0.0561s
  1846. ==  RemoveSegments: migrated (0.5672s) ========================================
  1847.  
  1848. ==  WayNodesNodeIdx: migrating ================================================
  1849. -- add_index("way_nodes", ["node_id"], {:name=>"way_nodes_node_idx"})
  1850.    -> 0.0490s
  1851. ==  WayNodesNodeIdx: migrated (0.0492s) =======================================
  1852.  
  1853. ==  DiaryComments: migrating ==================================================
  1854. -- myisam_table()
  1855.    -> 0.0001s
  1856. -- create_table("diary_comments", {:options=>"", :force=>true, :id=>false})
  1857. NOTICE:  CREATE TABLE will create implicit sequence "diary_comments_id_seq" for serial column "diary_comments.id"
  1858. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "diary_comments_pkey" for table "diary_comments"
  1859.    -> 0.0982s
  1860. -- add_index("diary_comments", ["diary_entry_id", "id"], {:name=>"diary_comments_entry_id_idx", :unique=>true})
  1861.    -> 0.0445s
  1862. ==  DiaryComments: migrated (0.1434s) =========================================
  1863.  
  1864. ==  AddUserImage: migrating ===================================================
  1865. -- add_column("users", "image", :text)
  1866.    -> 0.0017s
  1867. ==  AddUserImage: migrated (0.0019s) ==========================================
  1868.  
  1869. ==  AddAdminFlag: migrating ===================================================
  1870. -- add_column("users", "administrator", :boolean, {:null=>false, :default=>false})
  1871.    -> 0.0051s
  1872. ==  AddAdminFlag: migrated (0.0053s) ==========================================
  1873.  
  1874. ==  AddEmailValid: migrating ==================================================
  1875. -- add_column("users", "email_valid", :boolean, {:null=>false, :default=>false})
  1876.    -> 0.0041s
  1877. ==  AddEmailValid: migrated (0.0055s) =========================================
  1878.  
  1879. ==  AddNewEmail: migrating ====================================================
  1880. -- add_column("users", "new_email", :string)
  1881.    -> 0.0015s
  1882. ==  AddNewEmail: migrated (0.0018s) ===========================================
  1883.  
  1884. ==  AddUserVisible: migrating =================================================
  1885. -- add_column("users", "visible", :boolean, {:null=>false, :default=>true})
  1886.    -> 0.0043s
  1887. ==  AddUserVisible: migrated (0.0056s) ========================================
  1888.  
  1889. ==  AddCreationIp: migrating ==================================================
  1890. -- add_column("users", "creation_ip", :string)
  1891.    -> 0.0016s
  1892. ==  AddCreationIp: migrated (0.0018s) =========================================
  1893.  
  1894. ==  AddGpxIndexes: migrating ==================================================
  1895. -- add_index("gpx_files", ["user_id"], {:name=>"gpx_files_user_id_idx"})
  1896.    -> 0.0670s
  1897. -- add_index("gpx_file_tags", ["tag"], {:name=>"gpx_file_tags_tag_idx"})
  1898.    -> 0.0561s
  1899. ==  AddGpxIndexes: migrated (0.1235s) =========================================
  1900.  
  1901. ==  CreateAcls: migrating =====================================================
  1902. -- myisam_table()
  1903.    -> 0.0001s
  1904. -- create_table("acls", {:options=>"", :force=>true, :id=>false})
  1905. NOTICE:  CREATE TABLE will create implicit sequence "acls_id_seq" for serial column "acls.id"
  1906. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acls_pkey" for table "acls"
  1907.    -> 0.0895s
  1908. -- add_index("acls", ["k"], {:name=>"acls_k_idx"})
  1909.    -> 0.0516s
  1910. ==  CreateAcls: migrated (0.1417s) ============================================
  1911.  
  1912. ==  AddTimestampIndexes: migrating ============================================
  1913. -- add_index(:current_ways, :timestamp, {:name=>:current_ways_timestamp_idx})
  1914.    -> 0.0600s
  1915. -- add_index(:current_relations, :timestamp, {:name=>:current_relations_timestamp_idx})
  1916.    -> 0.0336s
  1917. ==  AddTimestampIndexes: migrated (0.0941s) ===================================
  1918.  
  1919. ==  PopulateNodeTagsAndRemove: migrating ======================================
  1920. -- select_value("SELECT count(*) FROM current_nodes")
  1921.    -> 0.0015s
  1922. -- execute("TRUNCATE nodes")
  1923.    -> 0.1375s
  1924. -- remove_column(:nodes, :tags)
  1925.    -> 0.0014s
  1926. -- remove_column(:current_nodes, :tags)
  1927.    -> 0.0014s
  1928. -- add_column(:nodes, :version, :bigint, {:null=>false, :limit=>20})
  1929.    -> 0.0017s
  1930. -- innodb_table()
  1931.    -> 0.0000s
  1932. -- create_table(:current_node_tags, {:options=>"", :force=>true, :id=>false})
  1933.    -> 0.0401s
  1934. -- innodb_table()
  1935.    -> 0.0001s
  1936. -- create_table(:node_tags, {:options=>"", :force=>true, :id=>false})
  1937.    -> 0.0448s
  1938. ==  PopulateNodeTagsAndRemove: migrated (0.2298s) =============================
  1939.  
  1940. ==  MoveToInnodb: migrating ===================================================
  1941. -- remove_index(:current_way_tags, {:name=>:current_way_tags_v_idx})
  1942.    -> 0.0054s
  1943. -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_v_idx})
  1944.    -> 0.0046s
  1945. -- change_column("nodes", "version", :bigint, {:null=>false, :limit=>20})
  1946.    -> 0.1131s
  1947. -- change_column("ways", "version", :bigint, {:null=>false, :limit=>20})
  1948.    -> 0.0993s
  1949. -- change_column("relations", "version", :bigint, {:null=>false, :limit=>20})
  1950.    -> 0.0916s
  1951. -- change_engine("nodes", "InnoDB")
  1952.    -> 0.0002s
  1953. -- change_engine("ways", "InnoDB")
  1954.    -> 0.0001s
  1955. -- change_engine("way_tags", "InnoDB")
  1956.    -> 0.0001s
  1957. -- change_engine("way_nodes", "InnoDB")
  1958.    -> 0.0001s
  1959. -- change_engine("current_way_tags", "InnoDB")
  1960.    -> 0.0001s
  1961. -- change_engine("relation_members", "InnoDB")
  1962.    -> 0.0001s
  1963. -- change_engine("relations", "InnoDB")
  1964.    -> 0.0001s
  1965. -- change_engine("relation_tags", "InnoDB")
  1966.    -> 0.0001s
  1967. -- change_engine("current_relation_tags", "InnoDB")
  1968.    -> 0.0001s
  1969. -- add_column("current_nodes", "version", :bigint, {:null=>false, :limit=>20})
  1970.    -> 0.0018s
  1971. -- add_column("current_ways", "version", :bigint, {:null=>false, :limit=>20})
  1972.    -> 0.0022s
  1973. -- add_column("current_relations", "version", :bigint, {:null=>false, :limit=>20})
  1974.    -> 0.0021s
  1975. ==  MoveToInnodb: migrated (0.3582s) ==========================================
  1976.  
  1977. ==  KeyConstraints: migrating =================================================
  1978. -- add_primary_key(:current_node_tags, [:id, :k])
  1979. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_node_tags_pkey" for table "current_node_tags"
  1980.    -> 0.0558s
  1981. -- add_primary_key(:current_way_tags, [:id, :k])
  1982. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_tags_pkey" for table "current_way_tags"
  1983.    -> 0.0375s
  1984. -- add_primary_key(:current_relation_tags, [:id, :k])
  1985. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_tags_pkey" for table "current_relation_tags"
  1986.    -> 0.0356s
  1987. -- add_primary_key(:node_tags, [:id, :version, :k])
  1988. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "node_tags_pkey" for table "node_tags"
  1989.    -> 0.0337s
  1990. -- add_primary_key(:way_tags, [:id, :version, :k])
  1991. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_tags_pkey" for table "way_tags"
  1992.    -> 0.0337s
  1993. -- add_primary_key(:relation_tags, [:id, :version, :k])
  1994. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_tags_pkey" for table "relation_tags"
  1995.    -> 0.0448s
  1996. -- add_primary_key(:nodes, [:id, :version])
  1997. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
  1998.    -> 0.0472s
  1999. -- remove_index(:current_way_tags, {:name=>:current_way_tags_id_idx})
  2000.    -> 0.0045s
  2001. -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_id_idx})
  2002.    -> 0.0046s
  2003. -- remove_index(:way_tags, {:name=>:way_tags_id_version_idx})
  2004.    -> 0.0098s
  2005. -- remove_index(:relation_tags, {:name=>:relation_tags_id_version_idx})
  2006.    -> 0.0047s
  2007. -- remove_index(:nodes, {:name=>:nodes_uid_idx})
  2008.    -> 0.0057s
  2009. -- add_foreign_key(:current_node_tags, [:id], :current_nodes)
  2010.    -> 0.0046s
  2011. -- add_foreign_key(:node_tags, [:id, :version], :nodes)
  2012.    -> 0.0040s
  2013. -- add_foreign_key(:current_way_tags, [:id], :current_ways)
  2014.    -> 0.0039s
  2015. -- add_foreign_key(:current_way_nodes, [:id], :current_ways)
  2016.    -> 0.0084s
  2017. -- add_foreign_key(:way_tags, [:id, :version], :ways)
  2018.    -> 0.0040s
  2019. -- add_foreign_key(:way_nodes, [:id, :version], :ways)
  2020.    -> 0.0077s
  2021. -- add_foreign_key(:current_relation_tags, [:id], :current_relations)
  2022.    -> 0.0037s
  2023. -- add_foreign_key(:current_relation_members, [:id], :current_relations)
  2024.    -> 0.0042s
  2025. -- add_foreign_key(:relation_tags, [:id, :version], :relations)
  2026.    -> 0.0058s
  2027. -- add_foreign_key(:relation_members, [:id, :version], :relations)
  2028.    -> 0.0039s
  2029. -- add_foreign_key(:current_way_nodes, [:node_id], :current_nodes, [:id])
  2030.    -> 0.0092s
  2031. ==  KeyConstraints: migrated (0.3814s) ========================================
  2032.  
  2033. ==  AddChangesets: migrating ==================================================
  2034. -- innodb_table()
  2035.    -> 0.0001s
  2036. -- create_table("changesets", {:options=>"", :force=>true, :id=>false})
  2037. NOTICE:  CREATE TABLE will create implicit sequence "changesets_id_seq" for serial column "changesets.id"
  2038. NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changesets_pkey" for table "changesets"
  2039.    -> 0.0513s
  2040. -- innodb_table()
  2041.    -> 0.0001s
  2042. -- create_table("changeset_tags", {:options=>"", :force=>true, :id=>false})
  2043.    -> 0.0576s
  2044. -- add_index("changeset_tags", ["id"], {:name=>"changeset_tags_id_idx"})
  2045.    -> 0.0429s
  2046. -- execute("INSERT INTO changesets (id, user_id, created_at, open)SELECT id, id, creation_time, false from users;")
  2047.    -> 0.0014s
  2048. -- rename_column("current_nodes", :user_id, :changeset_id)
  2049.    -> 0.0012s
  2050. -- add_foreign_key("current_nodes", [:changeset_id], :changesets, [:id])
  2051.    -> 0.0036s
  2052. -- rename_column("current_relations", :user_id, :changeset_id)
  2053.    -> 0.0011s
  2054. -- add_foreign_key("current_relations", [:changeset_id], :changesets, [:id])
  2055.    -> 0.0035s
  2056. -- rename_column("current_ways", :user_id, :changeset_id)
  2057.    -> 0.0035s
  2058. -- add_foreign_key("current_ways", [:changeset_id], :changesets, [:id])
  2059.    -> 0.0043s
  2060. -- rename_column("nodes", :user_id, :changeset_id)
  2061.    -> 0.0012s
  2062. -- add_foreign_key("nodes", [:changeset_id], :changesets, [:id])
  2063.    -> 0.0036s
  2064. -- rename_column("relations", :user_id, :changeset_id)
  2065.    -> 0.0014s
  2066. -- add_foreign_key("relations", [:changeset_id], :changesets, [:id])
  2067.    -> 0.0050s
  2068. -- rename_column("ways", :user_id, :changeset_id)
  2069.    -> 0.0012s
  2070. -- add_foreign_key("ways", [:changeset_id], :changesets, [:id])
  2071.    -> 0.0079s
  2072. ==  AddChangesets: migrated (0.1942s) =========================================
  2073.  
  2074. ==  OrderRelationMembers: migrating ===========================================
  2075. -- add_column(:relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
  2076.    -> 0.0046s
  2077. -- execute("update relation_members set sequence_id = mod(member_id, 16384)")
  2078.    -> 0.0010s
  2079. -- alter_primary_key("relation_members", [:id, :version, :member_type, :member_id, :member_role, :sequence_id])
  2080. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
  2081.    -> 0.0440s
  2082. -- add_column(:current_relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
  2083.    -> 0.0044s
  2084. -- execute("update current_relation_members set sequence_id = mod(member_id, 16384)")
  2085.    -> 0.0008s
  2086. -- alter_primary_key("current_relation_members", [:id, :member_type, :member_id, :member_role, :sequence_id])
  2087. NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
  2088.    -> 0.0623s
  2089. ==  OrderRelationMembers: migrated (0.1184s) ==================================
  2090.  
  2091. ==  AddEndTimeToChangesets: migrating =========================================
  2092. -- add_column(:changesets, :closed_at, :datetime, {:null=>false})
  2093.    -> 0.0024s
  2094. -- interval_constant("1 hour")
  2095.    -> 0.0002s
  2096. -- execute("update changesets set closed_at=(now()-'1 hour'::interval) where open=(1=0)")
  2097.    -> 0.0014s
  2098. -- interval_constant("1 hour")
  2099.    -> 0.0002s
  2100. -- execute("update changesets set closed_at=(now()+'1 hour'::interval) where open=(1=1)")
  2101.    -> 0.0008s
  2102. -- remove_column(:changesets, :open)
  2103.    -> 0.0018s
  2104. -- add_column(:changesets, :num_changes, :integer, {:null=>false, :default=>0})
  2105.    -> 0.0045s
  2106. ==  AddEndTimeToChangesets: migrated (0.0122s) ================================
  2107.  
  2108. ==  AddChangesetUserIndex: migrating ==========================================
  2109. -- add_index("changesets", ["user_id"], {:name=>"changesets_user_id_idx"})
  2110.    -> 0.0429s
  2111. ==  AddChangesetUserIndex: migrated (0.0431s) =================================
  2112.  
  2113. ==  AddChangesetIndexes: migrating ============================================
  2114. -- add_index("nodes", ["changeset_id"], {:name=>"nodes_changeset_id_idx"})
  2115.    -> 0.0434s
  2116. -- add_index("ways", ["changeset_id"], {:name=>"ways_changeset_id_idx"})
  2117.    -> 0.0337s
  2118. -- add_index("relations", ["changeset_id"], {:name=>"relations_changeset_id_idx"})
  2119.    -> 0.0338s
  2120. ==  AddChangesetIndexes: migrated (0.1116s) ===================================
  2121.  
  2122. ==  AddMoreChangesetIndexes: migrating ========================================
  2123. -- add_index("changesets", ["created_at"], {:name=>"changesets_created_at_idx"})
  2124.    -> 0.0330s
  2125. -- add_index("changesets", ["closed_at"], {:name=>"changesets_closed_at_idx"})
  2126.    -> 0.0337s
  2127. -- add_index("changesets", ["min_lat", "max_lat", "min_lon", "max_lon"], {:method=>"GIST", :name=>"changesets_bbox_idx"})
  2128. rake aborted!
  2129. An error has occurred, this and all later migrations canceled:
  2130.  
  2131. PGError: ERROR:  data type integer has no default operator class for access method "gist"
  2132. HINT:  You must specify an operator class for the index or define a default operator class for the data type.
  2133. : CREATE  INDEX "changesets_bbox_idx" ON "changesets" USING GIST ("min_lat", "max_lat", "min_lon", "max_lon")
  2134.  
  2135. Tasks: TOP => db:migrate
  2136. (See full trace by running task with --trace)
  2137. alexandru@alex-lap:~/.osm/rail_port/rails$
  2138.  
  2139.  
Advertisement
RAW Paste Data Copied
Advertisement