For completeness sake, the subsequent error (with trace) is thus... I think
at this point, I'm likely stuck -- at least short of wiping the DB and
starting over, fresh (which I'd prefer to not do).
-- begin
-- execute("ALTER TABLE reports ADD CONSTRAINT fk_reports_node_id FOREIGN
KEY (node_id) REFERENCES nodes(id) ON DELETE CASCADE;")
rake aborted!
An error has occurred, all later migrations canceled:
Mysql::Error: Can't create table 'puppet_dashboard.#sql-5675_5' (errno:
121): ALTER TABLE reports ADD CONSTRAINT fk_reports_node_id FOREIGN KEY
(node_id) REFERENCES nodes(id) ON DELETE CASCADE;
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:227:in
`log'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:324:in
`execute'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:352:in
`send'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:352:in
`method_missing'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:328:in
`say_with_time'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:328:in
`say_with_time'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:348:in
`method_missing'
./db/migrate//20111118204121_add_report_foreign_key_constraints.rb:10:in
`up_without_benchmarks'
./db/migrate//20111118204121_add_report_foreign_key_constraints.rb:13:in
`call'
./db/migrate//20111118204121_add_report_foreign_key_constraints.rb:13:in
`up_without_benchmarks'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:282:in
`send'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:282:in
`migrate'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:282:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:365:in
`__send__'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:365:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:491:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:567:in
`call'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:567:in
`ddl_transaction'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:490:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:477:in
`each'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:477:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:401:in
`up'
/opt/puppet-dashboard-1.2.4/vendor/rails/activerecord/lib/active_record/migration.rb:383:in
`migrate'
/opt/puppet-dashboard-1.2.4/vendor/rails/railties/lib/tasks/databases.rake:112
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in
`invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in
`invoke_with_call_chain'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in
`invoke_task'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`each'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in
`top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
/usr/bin/rake:19:in `load'
/usr/bin/rake:19
Tasks: TOP => db:migrate
-- end
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
