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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In