#993901 gitlab upgrade from 13.12.9 to 14.0.10 fails with error ArgumentError: wrong number of arguments (given 0, expected 1)/usr/share/gitlab/config/initializers/postgresql_cte.rb:99:in `build_arel'

Package:
gitlab
Source:
gitlab
Submitter:
Pirate Praveen
Date:
2022-07-15 19:57:04 UTC
Severity:
important
Tags:
#993901#5
Date:
2021-09-07 22:11:46 UTC
From:
To:
When trying to upgrade gitlab from 13.12.9 to 14.0.10, installation
fails during the db migration step with error (log below)

== 20210513163904 CleanupMoveContainerRegistryEnabledToProjectFeature:
migrating
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

wrong number of arguments (given 0, expected 1)
/usr/share/gitlab/config/initializers/postgresql_cte.rb:99:in
`build_arel'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/relation.rb:583:in
 `delete_all'
/usr/share/gitlab/db/post_migrate/20210513163904_cleanup_move_container_registry_enabled_to_proj
ect_feature.rb:16:in `up'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:870:i
n `public_send'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:870:i
n `exec_migration'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:851:i
n `block (2 levels) in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:850:i
n `block in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:462:in `with_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:849:i
n `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1037:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1329:
in `block in execute_migration_in_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1382:
in `ddl_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1328:
in `execute_migration_in_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1302:
in `each'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1302:
in `migrate_without_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1251:
in `block in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1401:
in `block in with_advisory_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1416:
in `block in with_advisory_lock_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:462:in `with_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1416:
in `with_advisory_lock_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1397:
in `with_advisory_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1251:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1086:
in `up'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1061:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/tasks/database_tas
ks.rb:237:in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:92:in `block (3 levels) in <top (required)>'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:90:in `each'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:90:in `block (2 levels) in <top (required)>'
/usr/share/rubygems-integration/all/gems/rake-13.0.3/exe/rake:27:in
`<top (required)>'

Caused by:
ArgumentError: wrong number of arguments (given 0, expected 1)
/usr/share/gitlab/config/initializers/postgresql_cte.rb:99:in
`build_arel'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/relation.rb:583:in
 `delete_all'
/usr/share/gitlab/db/post_migrate/20210513163904_cleanup_move_container_registry_enabled_to_proj
ect_feature.rb:16:in `up'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:870:i
n `public_send'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:870:i
n `exec_migration'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:851:i
n `block (2 levels) in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:850:i
n `block in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:462:in `with_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:849:i
n `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1037:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1329:
in `block in execute_migration_in_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1382:
in `ddl_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1328:
in `execute_migration_in_transaction'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1302:
in `each'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1302:
in `migrate_without_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1251:
in `block in migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1401:
in `block in with_advisory_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1416:
in `block in with_advisory_lock_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:462:in `with_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1416:
in `with_advisory_lock_connection'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1397:
in `with_advisory_lock'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1251:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1086:
in `up'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/migration.rb:1061:
in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/tasks/database_tas
ks.rb:237:in `migrate'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:92:in `block (3 levels) in <top (required)>'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:90:in `each'
/usr/share/rubygems-integration/all/gems/activerecord-6.1.4/lib/active_record/railties/databases
.rake:90:in `block (2 levels) in <top (required)>'
/usr/share/rubygems-integration/all/gems/rake-13.0.3/exe/rake:27:in
`<top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
dpkg: error processing package gitlab (--configure):
 installed gitlab package post-installation script subprocess returned
error exit status 1
Errors were encountered while processing:
 gitlab
E: Sub-process /usr/bin/dpkg returned an error code (1)

A clean installation of gitlab 14.0.10 from
https://wiki.debian.org/gitlab/devel did not fail at this stage.

To install gitlab 13.12.9, https://wiki.debian.org/gitlab/staging repo
can be used.

#993901#10
Date:
2021-09-08 14:24:06 UTC
From:
To:
On Wed, 08 Sep 2021 03:41:46 +0530 Pirate Praveen  <praveen@onenetbeyond.org> wrote:
 > When trying to upgrade gitlab from 13.12.9 to 14.0.10, installation
 > fails during the db migration step with error (log below)

On a fresh installation, the same error is shown in production.log when
creating a new user.

380 Processing by RegistrationsController#create as HTML
381 Parameters: {"authenticity_token"=>"[FILTERED]",
"new_user"=>{"first_name"=>"Pirate", "las
382 Potential spam detected for IP 192.168.150.161. Invisible Captcha
timestamp not found in ses
383 Completed 500 Internal Server Error in 448ms (ActiveRecord: 141.2ms
| Elasticsearch: 0.0ms |
384
385 ArgumentError (wrong number of arguments (given 0, expected 1)):
386
387 config/initializers/postgresql_cte.rb:99:in `build_arel'
388 app/models/route.rb:57:in `delete_conflicting_redirects'
389 app/controllers/registrations_controller.rb:26:in `create'
390 app/controllers/application_controller.rb:487:in `set_current_admin'
391 lib/gitlab/session.rb:11:in `with_session'
392 app/controllers/application_controller.rb:478:in
`set_session_storage'
393 lib/gitlab/i18n.rb:99:in `with_locale'
394 lib/gitlab/i18n.rb:105:in `with_user_locale'
395 app/controllers/application_controller.rb:472:in `set_locale'
396 app/controllers/application_controller.rb:466:in
`set_current_context'
397 lib/gitlab/middleware/speedscope.rb:13:in `call'
398 lib/gitlab/request_profiler/middleware.rb:17:in `call'
399 lib/gitlab/jira/middleware.rb:19:in `call'
400 lib/gitlab/middleware/go.rb:20:in `call'

#993901#15
Date:
2021-09-08 14:53:47 UTC
From:
To:
On ബു, സെപ്റ്റം 8 2021 at 07:54:06 വൈകു +0530 +0530, Pirate Praveen <praveen@onenetbeyond.org> wrote:

This is tracked down to the newer versions of rails/activerecord we
have (6.1.4 and they need 6.1.3.2). I installed rails 6.1.3.2 from
rubygems.org and the failed migrations are now successfull.

#993901#24
Date:
2022-07-15 19:54:27 UTC
From:
To:
no relevant now