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