Project

General

Profile

Actions
Copy link

Bug #2783

closed

db:convert:prod2dev fails on table 'architectures_operatingsystems'

Added by Scuba Floyd almost 11 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Greg Sutcliffe
Category:
DB migrations
Target version:
1.3.2
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

When converting MySQL to Postgres on Foreman1.2, I get the following error (full trace attached):

Converting architectures_operatingsystems...rake aborted!
PG::Error: ERROR: column "id" does not exist
LINE 1: ...re_id", "operatingsystem_id") VALUES ($1, $2) RETURNING "id"
^
: INSERT INTO "architectures_operatingsystems" ("architecture_id", "operatingsystem_id") VALUES ($1, $2) RETURNING "id"

The schemas are consistent on both DBs.

Files

prod2dev.trace prod2dev.trace 7.97 KB Scuba Floyd, 07/14/2013 06:29 AM

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #3268: defer postgresql foreign key constraints for rake db:convert:prod2devClosedGreg Sutcliffe10/08/2013Actions
Actions
Copy link

Also available in: Atom PDF