Foreman upgrade to 1.7 fail

Hello to everybody,

my upgrade to Foreman 1.7 fails during database upgrade:

root@foreman /usr/share/foreman$ foreman-rake reports:expire days=1
status=0 && foreman-rake reports:expire days=7 && foreman-rake
tmp:cache:clear && foreman-rake tmp:sessions:clear && foreman-rake
db:migrate && foreman-rake db:seed && foreman-rake assets:precompile
== RemoveUserJoinTables: migrating

··· =========================================== -- table_exists?(:user_compute_resources) -> 0.0007s -- remove_foreign_key("user_compute_resources", "users") rake aborted! An error has occurred, all later migrations canceled:

Mysql2::Error: Error on rename of ‘./foreman/user_compute_resources’ to
’./foreman/#sql2-5ca-1a’ (errno: 152): ALTER TABLE user_compute_resources
DROP FOREIGN KEY user_compute_resources_user_id_fk

Tasks: TOP => db:migrate
(See full trace by running task with --trace)
root@foreman /usr/share/foreman$

Any hints?

Regards Thomas

Linux … enjoy the ride!

Solved the problem by dropping the tables
from 20140415053029_remove_user_join_tables.rb manually.

Regards Thomas

··· 2014-12-11 15:32 GMT+01:00 Thomas Bendler : > > Hello to everybody, > > my upgrade to Foreman 1.7 fails during database upgrade: > > root@foreman /usr/share/foreman$ foreman-rake reports:expire days=1 > status=0 && foreman-rake reports:expire days=7 && foreman-rake > tmp:cache:clear && foreman-rake tmp:sessions:clear && foreman-rake > db:migrate && foreman-rake db:seed && foreman-rake assets:precompile > == RemoveUserJoinTables: migrating > =========================================== > -- table_exists?(:user_compute_resources) > -> 0.0007s > -- remove_foreign_key("user_compute_resources", "users") > rake aborted! > An error has occurred, all later migrations canceled: > > Mysql2::Error: Error on rename of './foreman/user_compute_resources' to > './foreman/#sql2-5ca-1a' (errno: 152): ALTER TABLE `user_compute_resources` > DROP FOREIGN KEY `user_compute_resources_user_id_fk` > > Tasks: TOP => db:migrate > (See full trace by running task with --trace) > root@foreman /usr/share/foreman$ > > Any hints? > > Regards Thomas > -- > Linux ... enjoy the ride! >


Linux … enjoy the ride!

Adding a +1 here that I ran into this issue and this solution worked
for me as well.

Cheers,

··· On Fri, Dec 12, 2014 at 1:09 PM, Thomas Bendler wrote: > Solved the problem by dropping the tables from > 20140415053029_remove_user_join_tables.rb manually.


Jason Wever