Praefect Migrations can fail due to a Postgres limit "payload string too long"
During a regular upgrade on one of our performance test environments today to the latest Omnibus Nightly it failed during Praefect DB Migrations with the following:
bash[migrate praefect database] (praefect::database_migrations line 20) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash" "/tmp/chef-script20211001-17943-13z4d9w" ----
STDOUT: praefect sql-migrate: fail: pq: payload string too long handling 20210906145021_link_repository_id
This error looks to be due to a hard limit in Postgres itself so will likely require refactoring of how we do migrations to compensate.
It's unknown at this time how likely this will affect customers. IT may be a new issue that will come in %14.4 or be one that can affect any environment regardless of issue. As such, initially setting to severity2 as this is a blocker with an awkward workaround that needs to be done each time before migrations occur.