Actions
Bug #19189
closeddb:migrate breaks RPM build
Difficulty:
Triaged:
Description
The recent merge of a future dated subscriptions migration is incompatible with sqlite and thus broke RPM building:
== 20170222131211 ChangePoolColumnsToDates: migrating ========================= -- change_column(:katello_pools, :start_date, "timestamp USING CAST(start_date AS timestamp without time zone)") rake aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLException: near "USING": syntax error: CREATE TABLE "katello_pools" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cp_id" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "subscription_id" integer, "account_number" integer, "contract_number" integer, "virtual" boolean, "quantity" integer, "start_date" timestamp USING CAST(start_date AS timestamp without time zone), "pool_type" varchar(255), "end_date" varchar(255), "ram" integer, "multi_entitlement" boolean, "consumed" integer, "virt_only" boolean DEFAULT 'f' NOT NULL, "unmapped_guest" boolean DEFAULT 'f' NOT NULL, "virt_who" boolean DEFAULT 'f' NOT NULL) /opt/rh/sclo-ror42/root/usr/share/gems/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in `initialize' /opt/rh/sclo-ror42/root/usr/share/gems/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in `new' /opt/rh/sclo-ror42/root/usr/share/gems/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in `prepare' /opt/rh/sclo-ror42/root/usr/share/gems/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:134:in `execute' /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-
Updated by Eric Helms over 7 years ago
- Blocks Feature #18631: As a user, I want future-dated subscriptions to be displayed. added
Updated by The Foreman Bot over 7 years ago
- Status changed from New to Ready For Testing
- Assignee set to Thomas McKay
- Pull request https://github.com/Katello/katello/pull/6735 added
Updated by The Foreman Bot over 7 years ago
- Pull request https://github.com/Katello/katello/pull/6738 added
Updated by Justin Sherrill over 7 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|493c5c9fe50ff06e1d77ddab056ed941f0f69ef9.
Updated by Justin Sherrill over 7 years ago
- Assignee changed from Thomas McKay to Justin Sherrill
- Target version set to 181
Updated by The Foreman Bot over 7 years ago
- Pull request https://github.com/Katello/katello/pull/6739 added
Updated by The Foreman Bot over 7 years ago
- Pull request https://github.com/Katello/katello/pull/6740 added
Actions