Foreman 1.5 RC1 upgrade error

Hi, I'm getting this error when updating from 1.4.2 to 1.5 RC1 on Ubuntu
please help:

Mysql2::Error: Error on rename of './foreman/user_roles' to
'./foreman/#sql2-3b9-100' (errno: 152): ALTER TABLE user_roles DROP
FOREIGN KEY
user_roles_user_id_fk/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in
query' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inblock in execute'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
block in log' /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/notifications/instrumenter.rb:20:ininstrument'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
log' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inexecute'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in
execute' /usr/share/foreman/vendor/ruby/1.9.1/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:39:inremove_foreign_key'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:466:in
block in method_missing' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:438:inblock in say_with_time'
/usr/lib/ruby/1.9.1/benchmark.rb:280:in measure' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:438:insay_with_time'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:458:in
method_missing' /usr/share/foreman/db/migrate/20131114084718_extend_user_role.rb:3:inup'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:410:in
block (2 levels) in migrate' /usr/lib/ruby/1.9.1/benchmark.rb:280:inmeasure'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:410:in
block in migrate' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:inwith_connection'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:389:in
migrate' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:528:inmigrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:720:in
block (2 levels) in migrate' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:777:incall'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:777:in
ddl_transaction' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:719:inblock in migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:700:in
each' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:700:inmigrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:570:in
up' /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:551:inmigrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/railties/databases.rake:193:in
block (2 levels) in <top (required)>' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:240:incall'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:240:in
block in execute' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:235:ineach'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:235:in
execute' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:179:inblock in invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:211:in mon_synchronize' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:172:ininvoke_with_call_chain'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:165:in
invoke' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:150:ininvoke_task'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:in
block (2 levels) in top_level' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:ineach'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:in
block in top_level' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:115:inrun_with_threads'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:100:in
top_level' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:78:inblock in run'
/usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:176:in
standard_exception_handling' /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:75:inrun'
/usr/bin/rake:27:in `<main>'
Tasks: TOP => db:migrate

self fixed by adding comment to:

remove_foreign_key 'user_roles', :name => 'user_roles_user_id_fk'

from /usr/share/foreman/db/migrate/20131114084718_extend_user_role.rb

Thanks.

ยทยทยท On Sunday, April 20, 2014 10:19:56 AM UTC-4, Alejandro Falcon wrote: > > Hi, I'm getting this error when updating from 1.4.2 to 1.5 RC1 on Ubuntu > please help: > > Mysql2::Error: Error on rename of './foreman/user_roles' to > './foreman/#sql2-3b9-100' (errno: 152): ALTER TABLE `user_roles` DROP > FOREIGN KEY > `user_roles_user_id_fk`/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in > `query' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in > `block in execute' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:280:in > `block in log' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/notifications/instrumenter.rb:20:in > `instrument' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:275:in > `log' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in > `execute' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in > `execute' > /usr/share/foreman/vendor/ruby/1.9.1/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:39:in > `remove_foreign_key' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:466:in > `block in method_missing' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:438:in > `block in say_with_time' > /usr/lib/ruby/1.9.1/benchmark.rb:280:in `measure' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:438:in > `say_with_time' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:458:in > `method_missing' > /usr/share/foreman/db/migrate/20131114084718_extend_user_role.rb:3:in `up' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:410:in > `block (2 levels) in migrate' > /usr/lib/ruby/1.9.1/benchmark.rb:280:in `measure' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:410:in > `block in migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in > `with_connection' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:389:in > `migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:528:in > `migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:720:in > `block (2 levels) in migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:777:in > `call' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:777:in > `ddl_transaction' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:719:in > `block in migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:700:in > `each' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:700:in > `migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:570:in > `up' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/migration.rb:551:in > `migrate' > /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/railties/databases.rake:193:in > `block (2 levels) in ' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:240:in > `call' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:240:in > `block in execute' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:235:in > `each' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:235:in > `execute' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:179:in > `block in invoke_with_call_chain' > /usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:172:in > `invoke_with_call_chain' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/task.rb:165:in > `invoke' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:150:in > `invoke_task' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:in > `block (2 levels) in top_level' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:in > `each' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:106:in > `block in top_level' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:115:in > `run_with_threads' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:100:in > `top_level' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:78:in > `block in run' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:176:in > `standard_exception_handling' > /usr/share/foreman/vendor/ruby/1.9.1/gems/rake-10.3.1/lib/rake/application.rb:75:in > `run' > /usr/bin/rake:27:in `' > Tasks: TOP => db:migrate > >