Project

General

Profile

Actions

Bug #5427

closed

Issuing rake tasks for update from 1.4 to 1.5 fails

Added by Marc Richter about 10 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
DB migrations
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

I just followed the upgrade instructions at http://theforeman.org/manuals/1.5/index.html#3.6Upgrade . When issuing the "foreman-rake db:migrate" task, this fails:

[root@monitor foreman]# ruby193-rake db:migrate RAILS_ENV=production
==  ExtendUserRole: migrating =================================================
-- remove_foreign_key("user_roles", {:name=>"user_roles_user_id_fk"})
rake aborted!
An error has occurred, all later migrations canceled:

Mysql2::Error: Error on rename of './foreman@002dpuppet/user_roles' to './foreman@002dpuppet/#sql2-513-3d' (errno: 152): ALTER TABLE `user_roles` DROP FOREIGN KEY `user_roles_user_id_fk`

Tasks: TOP => db:migrate
(See full trace by running task with --trace)
[root@monitor foreman]#

Related issues 1 (0 open1 closed)

Has duplicate Foreman - Bug #5480: Extend user role migration fails on MysqlDuplicate04/28/2014Actions
Actions

Also available in: Atom PDF