Integrations secret doctor fails
After upgrading to 14.9 the integrations stopped working for me (Mattermost and Sentry integrations are enabled).
I cannot open the project integration page, where one of the integrations are enabled. The error is 500 with the same OpenSSL::Cipher::CipherError in the logs.
Suspected related commit: 0ee6c61d
@alexkalderimis Did you encounter such error? Can you give me some tips?
Full secrets doctor log:
I, [2022-03-27T19:42:15.446118 #5613] INFO -- : Checking encrypted values in the database
I, [2022-03-27T19:42:22.385008 #5613] INFO -- : - Ci::InstanceVariable failures: 0
I, [2022-03-27T19:42:22.399595 #5613] INFO -- : - Ci::PipelineScheduleVariable failures: 0
I, [2022-03-27T19:42:23.967890 #5613] INFO -- : - Ci::Variable failures: 0
I, [2022-03-27T19:42:23.988883 #5613] INFO -- : - Ci::GroupVariable failures: 0
I, [2022-03-27T19:42:24.121252 #5613] INFO -- : - Ci::PipelineVariable failures: 0
I, [2022-03-27T19:42:24.143927 #5613] INFO -- : - Ci::JobVariable failures: 0
I, [2022-03-27T19:42:24.156508 #5613] INFO -- : - ApplicationSetting failures: 0
I, [2022-03-27T19:42:24.217612 #5613] INFO -- : - User failures: 0
I, [2022-03-27T19:42:24.240268 #5613] INFO -- : - Clusters::Platforms::Kubernetes failures: 0
I, [2022-03-27T19:42:24.282461 #5613] INFO -- : - Snippet failures: 0
I, [2022-03-27T19:42:24.284571 #5613] INFO -- : - PersonalSnippet failures: 0
I, [2022-03-27T19:42:24.285885 #5613] INFO -- : - ProjectSnippet failures: 0
I, [2022-03-27T19:42:24.300119 #5613] INFO -- : - Clusters::Applications::Helm failures: 0
I, [2022-03-27T19:42:24.314398 #5613] INFO -- : - Clusters::Applications::Prometheus failures: 0
rake aborted!
OpenSSL::Cipher::CipherError:
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/encryptor-3.0.0/lib/encryptor.rb:98:in `final'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/encryptor-3.0.0/lib/encryptor.rb:98:in `crypt'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/encryptor-3.0.0/lib/encryptor.rb:49:in `decrypt'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/attr_encrypted-3.1.0/lib/attr_encrypted.rb:240:in `decrypt'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/attr_encrypted-3.1.0/lib/attr_encrypted.rb:329:in `decrypt'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/attr_encrypted-3.1.0/lib/attr_encrypted.rb:161:in `block (2 levels) in attr_encrypted'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/attr_encrypted-3.1.0/lib/attr_encrypted/adapters/active_record.rb:76:in `block in attr_encrypted'
/home/git/gitlab/app/models/integration.rb:405:in `copy_properties_to_encrypted_properties'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:427:in `block in make_lambda'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:516:in `block in invoke_after'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:516:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:516:in `invoke_after'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:107:in `run_callbacks'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/callbacks.rb:824:in `_run_initialize_callbacks'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/core.rb:549:in `init_with_attributes'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/persistence.rb:403:in `instantiate_instance_of'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/persistence.rb:258:in `instantiate'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/querying.rb:63:in `block (2 levels) in find_by_sql'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/result.rb:62:in `block in each'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/result.rb:62:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/result.rb:62:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/querying.rb:63:in `map'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/querying.rb:63:in `block in find_by_sql'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activesupport-6.1.4.6/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/querying.rb:61:in `find_by_sql'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:843:in `block in exec_queries'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:858:in `block in skip_query_cache_if_necessary'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/connection_adapters/abstract/query_cache.rb:79:in `uncached'
/home/git/gitlab/lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `block in write_using_load_balancer'
/home/git/gitlab/lib/gitlab/database/load_balancing/load_balancer.rb:112:in `block in read_write'
/home/git/gitlab/lib/gitlab/database/load_balancing/load_balancer.rb:172:in `retry_with_backoff'
/home/git/gitlab/lib/gitlab/database/load_balancing/load_balancer.rb:110:in `read_write'
/home/git/gitlab/lib/gitlab/database/load_balancing/connection_proxy.rb:125:in `write_using_load_balancer'
/home/git/gitlab/lib/gitlab/database/load_balancing/connection_proxy.rb:95:in `method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/query_cache.rb:21:in `uncached'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/delegation.rb:108:in `public_send'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/delegation.rb:108:in `block in method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:406:in `block in scoping'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:804:in `_scoping'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:406:in `scoping'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/delegation.rb:108:in `method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:857:in `skip_query_cache_if_necessary'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:828:in `exec_queries'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:631:in `load'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation.rb:249:in `records'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/batches.rb:231:in `block in in_batches'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/batches.rb:229:in `loop'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/batches.rb:229:in `in_batches'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/batches.rb:137:in `find_in_batches'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/relation/batches.rb:70:in `find_each'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.6/lib/active_record/querying.rb:22:in `find_each'
/home/git/gitlab/lib/gitlab/doctor/secrets.rb:38:in `block in check_model_attributes'
/home/git/gitlab/lib/gitlab/doctor/secrets.rb:36:in `each'
/home/git/gitlab/lib/gitlab/doctor/secrets.rb:36:in `check_model_attributes'
/home/git/gitlab/lib/gitlab/doctor/secrets.rb:26:in `run!'
/home/git/gitlab/lib/tasks/gitlab/doctor/secrets.rake:11:in `block (3 levels) in <top (required)>'
/home/git/gitlab/vendor/bundle/ruby/2.7.0/gems/sentry-ruby-core-5.1.1/lib/sentry/rake.rb:26:in `execute'
Tasks: TOP => gitlab:doctor:secrets
(See full trace by running task with --trace)
Edited by Gazder Bence