This is the first issue I have upgrading Gitlab as far as I remember – so that’s not too bad.
However, now I got the following error during my regular apt upgrade
and it is repeated when I try gitlab-ctl reconfigure
:
unrecognized configuration parameter “idle_in_transaction_session_timeout”
Full stacktrace
There was an error running gitlab-ctl reconfigure:
bash[migrate gitlab-rails database] (gitlab::database_migrations line 55) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received ‘1’
---- Begin output of “bash” “/tmp/chef-script20200725-22841-5cobqr” ----
STDOUT: rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedObject: ERROR: unrecognized configuration parameter “idle_in_transaction_session_timeout”
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:148:in execute' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:168:in
reset_db_settings’
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:92:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:335:in
with_lock_retries’
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20200304023245_add_sprint_to_issues.rb:9:in up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in
block (3 levels) in <top (required)>’
/opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in
’
Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR: unrecognized configuration parameter “idle_in_transaction_session_timeout”
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:148:in execute' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:168:in
reset_db_settings’
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:92:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:335:in
with_lock_retries’
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20200304023245_add_sprint_to_issues.rb:9:in up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in
block (3 levels) in <top (required)>’
/opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in
’
Caused by:
PG::UndefinedObject: ERROR: unrecognized configuration parameter “idle_in_transaction_session_timeout”
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:148:in execute' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:168:in
reset_db_settings’
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:92:in run' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:335:in
with_lock_retries’
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20200304023245_add_sprint_to_issues.rb:9:in up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in
block (3 levels) in <top (required)>’
/opt/gitlab/embedded/bin/bundle:23:in load' /opt/gitlab/embedded/bin/bundle:23:in
’
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
== 20200304023245 AddSprintToIssues: migrating ================================
– add_column(:issues, :sprint_id, :bigint)
→ 0.0022s
STDERR:
---- End output of “bash” “/tmp/chef-script20200725-22841-5cobqr” ----
Ran “bash” “/tmp/chef-script20200725-22841-5cobqr” returned 1
How should I proceed?
→ lsb_release -d
Description: Ubuntu 18.04.4 LTS
→ apt-cache policy gitlab-ce
gitlab-ce:
Installed: 13.0.6-ce.0
Candidate: 13.2.1-ce.0
…