I’m trying to update praefect and running a gitlab-ctl reconfigure but I get everytime the following error:
================================================================================
Error executing action `run` on resource 'bash[migrate praefect database]'
================================================================================
Mixlib::ShellOut::ShellCommandFailed
------------------------------------
Expected process to exit with [0], but received '1'
---- Begin output of "bash" "/tmp/chef-script20211026-19918-vj5j32" ----
STDOUT: praefect sql-migrate: fail: pq: payload string too long handling 20210906145021_link_repository_id
STDERR:
---- End output of "bash" "/tmp/chef-script20211026-19918-vj5j32" ----
Ran "bash" "/tmp/chef-script20211026-19918-vj5j32" returned 1
Resource Declaration:
---------------------
# In /opt/gitlab/embedded/cookbooks/cache/cookbooks/praefect/recipes/database_migrations.rb
20: bash 'migrate praefect database' do
21: code <<-EOH
22: set -e
23: log_file="#{node['praefect']['log_directory']}/praefect-sql-migrate-$(date +%Y-%m-%d-%H-%M-%S).log"
24:
25: /opt/gitlab/embedded/bin/praefect -config #{File.join(node['praefect']['dir'], 'config.toml')} sql-migrate 2>& 1 | tee ${log_file}
26:
27: exit ${PIPESTATUS[0]}
28: EOH
29: user account_helper.gitlab_user
30: group account_helper.gitlab_group
31:
32: notifies :hup, "runit_service[praefect]", :immediately
33: only_if { node['praefect']['auto_migrate'] }
34: end
Compiled Resource:
------------------
# Declared in /opt/gitlab/embedded/cookbooks/cache/cookbooks/praefect/recipes/database_migrations.rb:20:in `from_file'
bash("migrate praefect database") do
action [:run]
default_guard_interpreter :default
command nil
backup 5
interpreter "bash"
declared_type :bash
cookbook_name "praefect"
recipe_name "database_migrations"
code " set -e\n log_file=\"/var/log/gitlab/praefect/praefect-sql-migrate-$(date +%Y-%m-%d-%H-%M-%S).log\"\n\n /opt/gitlab/embedded/bin/praefect -config /var/opt/gitlab/praefect/config.toml sql-migrate 2>& 1 | tee ${log_file}\n\n exit ${PIPESTATUS[0]}\n"
domain nil
user "git"
group "git"
only_if { #code block }
end
System Info:
------------
chef_version=15.17.4
platform=amazon
platform_version=2
ruby=ruby 2.7.4p191 (2021-07-07 revision a21a3b7d23) [x86_64-linux]
program_name=/opt/gitlab/embedded/bin/chef-client
executable=/opt/gitlab/embedded/bin/chef-client
can you help please?