API tools faq
paste
Guest User

Untitled

a guest
Dec 2nd, 2018
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.32 KB | None | 0 0
raw download clone embed print report
  1. peter@peter-HP:~/harbinger$ rake db:migrate
  2. == RefactorMappingsTable: migrating ==========================================
  3. -- add_column(:mappings, :source_value, :string)
  4. -> 0.0152s
  5. -- add_column(:mappings, :destination_id, :integer)
  6. -> 0.0065s
  7. -- add_column(:mappings, :destination_value, :string)
  8. -> 0.0009s
  9. -- Migrating data to new columns
  10. -- execute(" WITH sources AS (\n SELECT id AS source_id\n FROM integration_sources\n WHERE name = 'Harbinger'\n )\n UPDATE mappings\n SET source_value = from_value,\n destination_value = mapped_data_id,\n destination_id = source_id\n FROM sources\n")
  11. -> 0.0009s
  12. -- execute(" WITH sources AS (\n SELECT id AS source_id\n FROM integration_sources\n WHERE name = 'Harbinger'\n )\n INSERT INTO mappings (\n type,\n destination_id,\n destination_value,\n source_value,\n integration_source_id\n )\n SELECT type,\n integration_source_id,\n to_value,\n mapped_data_id,\n source_id\n FROM mappings, sources\n WHERE to_value IS NOT NULL;\n")
  13. -> 0.0007s
  14. -> 0.0021s
  15. -- change_column(:mappings, :source_value, :string, {:null=>false})
  16. rake aborted!
  17. An error has occurred, this and all later migrations canceled:
  18.  
  19. PG::Error: ERROR: column "source_value" contains null values
  20. : ALTER TABLE "mappings" ALTER "source_value" SET NOT NULL
  21.  
  22. Tasks: TOP => db:migrate
  23. (See full trace by running task with --trace)
  24. peter@peter-HP:~/harbinger$ rake db:migrate --trace
  25. ** Invoke db:migrate (first_time)
  26. ** Invoke environment (first_time)
  27. ** Execute environment
  28. ** Invoke db:load_config (first_time)
  29. ** Execute db:load_config
  30. ** Execute db:migrate
  31. == RefactorMappingsTable: migrating ==========================================
  32. -- add_column(:mappings, :source_value, :string)
  33. -> 0.0022s
  34. -- add_column(:mappings, :destination_id, :integer)
  35. -> 0.0012s
  36. -- add_column(:mappings, :destination_value, :string)
  37. -> 0.0010s
  38. -- Migrating data to new columns
  39. -- execute(" WITH sources AS (\n SELECT id AS source_id\n FROM integration_sources\n WHERE name = 'Harbinger'\n )\n UPDATE mappings\n SET source_value = from_value,\n destination_value = mapped_data_id,\n destination_id = source_id\n FROM sources\n")
  40. -> 0.0009s
  41. -- execute(" WITH sources AS (\n SELECT id AS source_id\n FROM integration_sources\n WHERE name = 'Harbinger'\n )\n INSERT INTO mappings (\n type,\n destination_id,\n destination_value,\n source_value,\n integration_source_id\n )\n SELECT type,\n integration_source_id,\n to_value,\n mapped_data_id,\n source_id\n FROM mappings, sources\n WHERE to_value IS NOT NULL;\n")
  42. -> 0.0009s
  43. -> 0.0022s
  44. -- change_column(:mappings, :source_value, :string, {:null=>false})
  45. rake aborted!
  46. An error has occurred, this and all later migrations canceled:
  47.  
  48. PG::Error: ERROR: column "source_value" contains null values
  49. : ALTER TABLE "mappings" ALTER "source_value" SET NOT NULL
  50. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in `async_exec'
  51. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in `block in execute'
  52. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  53. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  54. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  55. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in `execute'
  56. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1055:in `change_column_null'
  57. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1041:in `change_column'
  58. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in `block in method_missing'
  59. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in `block in say_with_time'
  60. /home/peter/.rvm/rubies/ruby-1.9.3-p0/lib/ruby/1.9.1/benchmark.rb:280:in `measure'
  61. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in `say_with_time'
  62. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in `method_missing'
  63. /home/peter/harbinger/db/migrate/20120815063702_refactor_mappings_table.rb:44:in `up'
  64. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
  65. /home/peter/.rvm/rubies/ruby-1.9.3-p0/lib/ruby/1.9.1/benchmark.rb:280:in `measure'
  66. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in `block in migrate'
  67. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in `with_connection'
  68. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in `migrate'
  69. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in `migrate'
  70. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in `block (2 levels) in migrate'
  71. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in `call'
  72. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in `block in ddl_transaction'
  73. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  74. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in `transaction'
  75. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in `ddl_transaction'
  76. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in `block in migrate'
  77. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in `each'
  78. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in `migrate'
  79. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in `up'
  80. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in `migrate'
  81. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in `block (2 levels) in <top (required)>'
  82. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
  83. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `block in execute'
  84. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
  85. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
  86. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `block in invoke_with_call_chain'
  87. /home/peter/.rvm/rubies/ruby-1.9.3-p0/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
  88. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
  89. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
  90. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
  91. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `block (2 levels) in top_level'
  92. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
  93. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `block in top_level'
  94. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
  95. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
  96. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `block in run'
  97. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
  98. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
  99. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/gems/rake-0.9.2.2/bin/rake:33:in `<top (required)>'
  100. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/bin/rake:19:in `load'
  101. /home/peter/.rvm/gems/ruby-1.9.3-p0@harbinger/bin/rake:19:in `<main>'
  102. Tasks: TOP => db:migrate
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!