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 <top (required)>' /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 `<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
>
>