Project

General

Profile

Actions

Bug #19189

closed

db:migrate breaks RPM build

Added by Eric Helms almost 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Urgent
Category:
-
Target version:

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-

Related issues 1 (0 open1 closed)

Blocks Katello - Feature #18631: As a user, I want future-dated subscriptions to be displayed.ClosedThomas McKay02/22/2017Actions
Actions #1

Updated by Eric Helms almost 7 years ago

  • Blocks Feature #18631: As a user, I want future-dated subscriptions to be displayed. added
Actions #2

Updated by The Foreman Bot almost 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
Actions #3

Updated by The Foreman Bot almost 7 years ago

  • Pull request https://github.com/Katello/katello/pull/6738 added
Actions #4

Updated by Justin Sherrill almost 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #5

Updated by Justin Sherrill almost 7 years ago

  • Assignee changed from Thomas McKay to Justin Sherrill
  • Target version set to 181
Actions #6

Updated by The Foreman Bot almost 7 years ago

  • Pull request https://github.com/Katello/katello/pull/6739 added
Actions #7

Updated by The Foreman Bot almost 7 years ago

  • Pull request https://github.com/Katello/katello/pull/6740 added
Actions

Also available in: Atom PDF