Upgrades from 15.0.0 to 15.8.0 fail due `UserAchievementsForeignKeys` migration error - 'malformed array literal: "user_id"'
On a pipeline that upgrades test data from 15.0.0
to the latest version 15.8.0
it failed today with the following error:
StandardError: An error has occurred, all later migrations canceled:
PG::InvalidTextRepresentation: ERROR: malformed array literal: "user_id"
LINE 1: ...D "postgres_foreign_keys"."constrained_columns" = 'user_id' ...
^
DETAIL: Array value must start with "{" or dimension information.
The error looks to be thrown by the UserAchievementsForeignKeys
migration introduced by !107027 (merged).
This looks to only affect upgrades from 15.0.0
so likely something was changed in 15.1.0
. However, 15.0.0
to 15.8.0
isn't called out as a unsupported upgrade path so this may need to be added.
Edited by Grant Young