Red Hat Satellite upgrade from 6.3 to 6.4 failed with error "foreman-rake db:migrate failed!"
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.