Red Hat Satellite upgrade from 6.3 to 6.4 failed with error "foreman-rake db:migrate failed!"

Solution Verified - Updated -

Issue

  • Red Hat Satellite 6.3 fails to upgrade to version 6.4 with the following error :
[DEBUG 2019-01-30T13:27:21 main] StandardError: An error has occurred, this and all later migrations canceled:
[DEBUG 2019-01-30T13:27:21 main] PG::InvalidTextRepresentation: ERROR:  invalid input syntax for integer: "3053_10G"
[DEBUG 2019-01-30T13:27:21 main] ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR:  invalid input syntax for integer: "3053_10G"
[DEBUG 2019-01-30T13:27:21 main] PG::InvalidTextRepresentation: ERROR:  invalid input syntax for integer: "3053_10G"
[ERROR 2019-01-30T13:27:21 main] foreman-rake db:migrate failed! Check the output for error!
[ERROR 2019-01-30T13:27:21 main] Upgrade step migrate_foreman failed. Check logs for more information.
[ERROR 2019-01-30T13:27:21 main] Errors encountered during run:
[ERROR 2019-01-30T13:27:21 main] foreman-rake db:migrate failed! Check the output for error!
[ERROR 2019-01-30T13:27:21 main] Upgrade step migrate_foreman failed. Check logs for more information.
........
[DEBUG 2019-01-30T13:27:21 main] PG::InvalidTextRepresentation: ERROR:  invalid input syntax for integer: "3053_10G"
[DEBUG 2019-01-30T13:27:21 main] : ALTER TABLE "subnets" ALTER COLUMN "vlanid" TYPE integer USING vlanid::integer

Environment

  • Red Hat Satellite 6.3

  • Red Hat Satellite 6.4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content