gitlab迁移过后出现500问题

Question

我在gitlab迁移后没有将老的gitlab-secrets.json替换到新的服务器上，结果偶尔出现500错误， gitlab-rake gitlab:doctor:secrets VERBOSE=1运行这个查看，发现了
I, [2024-03-11T10:27:58.604495 #1616] INFO – : - User failures: 85
I, [2024-03-11T10:28:00.006410 #1616] INFO – : - Operations::FeatureFlagsClient failures: 12
这2个错误，网上找了半天都没有找到解决这2个错误的方法，恳请大佬帮忙解答
以下是日志：
root@9d5745568f6d:/# gitlab-rake gitlab:doctor:secrets VERBOSE=1
I, [2024-03-11T10:27:52.423410 #1616] INFO – : Checking encrypted values in the database
I, [2024-03-11T10:27:58.324791 #1616] INFO – : - Ci::InstanceVariable failures: 0
I, [2024-03-11T10:27:58.338428 #1616] INFO – : - Ci::PipelineScheduleVariable failures: 0
I, [2024-03-11T10:27:58.352390 #1616] INFO – : - Ci::Variable failures: 0
I, [2024-03-11T10:27:58.367428 #1616] INFO – : - Ci::GroupVariable failures: 0
I, [2024-03-11T10:27:58.380600 #1616] INFO – : - Ci::PipelineVariable failures: 0
I, [2024-03-11T10:27:58.388771 #1616] INFO – : - Ci::JobVariable failures: 0
I, [2024-03-11T10:27:58.422992 #1616] INFO – : - ApplicationSetting failures: 0
I, [2024-03-11T10:27:58.604495 #1616] INFO – : - User failures: 85
D, [2024-03-11T10:27:58.604596 #1616] DEBUG – : - User[1]: static_object_token
D, [2024-03-11T10:27:58.604628 #1616] DEBUG – : - User[2]: static_object_token
D, [2024-03-11T10:27:58.604653 #1616] DEBUG – : - User[3]: static_object_token
D, [2024-03-11T10:27:58.604677 #1616] DEBUG – : - User[4]: static_object_token
D, [2024-03-11T10:27:58.604738 #1616] DEBUG – : - User[5]: static_object_token
D, [2024-03-11T10:27:58.604763 #1616] DEBUG – : - User[7]: static_object_token
D, [2024-03-11T10:27:58.604786 #1616] DEBUG – : - User[9]: static_object_token
D, [2024-03-11T10:27:58.604809 #1616] DEBUG – : - User[11]: static_object_token
D, [2024-03-11T10:27:58.604831 #1616] DEBUG – : - User[12]: static_object_token
D, [2024-03-11T10:27:58.604861 #1616] DEBUG – : - User[17]: static_object_token
D, [2024-03-11T10:27:58.604882 #1616] DEBUG – : - User[25]: static_object_token
D, [2024-03-11T10:27:58.604901 #1616] DEBUG – : - User[35]: static_object_token
D, [2024-03-11T10:27:58.604922 #1616] DEBUG – : - User[37]: static_object_token
D, [2024-03-11T10:27:58.604947 #1616] DEBUG – : - User[40]: static_object_token
D, [2024-03-11T10:27:58.604967 #1616] DEBUG – : - User[41]: static_object_token
D, [2024-03-11T10:27:58.604989 #1616] DEBUG – : - User[42]: static_object_token
D, [2024-03-11T10:27:58.605012 #1616] DEBUG – : - User[43]: static_object_token
D, [2024-03-11T10:27:58.605032 #1616] DEBUG – : - User[44]: static_object_token
D, [2024-03-11T10:27:58.605053 #1616] DEBUG – : - User[45]: static_object_token
D, [2024-03-11T10:27:58.605075 #1616] DEBUG – : - User[47]: static_object_token
D, [2024-03-11T10:27:58.605159 #1616] DEBUG – : - User[48]: static_object_token
D, [2024-03-11T10:27:58.605186 #1616] DEBUG – : - User[49]: static_object_token
D, [2024-03-11T10:27:58.605207 #1616] DEBUG – : - User[51]: static_object_token
D, [2024-03-11T10:27:58.605227 #1616] DEBUG – : - User[52]: static_object_token
D, [2024-03-11T10:27:58.605246 #1616] DEBUG – : - User[53]: static_object_token
D, [2024-03-11T10:27:58.605269 #1616] DEBUG – : - User[59]: static_object_token
D, [2024-03-11T10:27:58.605289 #1616] DEBUG – : - User[60]: static_object_token
D, [2024-03-11T10:27:58.605308 #1616] DEBUG – : - User[61]: static_object_token
D, [2024-03-11T10:27:58.605329 #1616] DEBUG – : - User[62]: static_object_token
D, [2024-03-11T10:27:58.605349 #1616] DEBUG – : - User[63]: static_object_token
D, [2024-03-11T10:27:58.605368 #1616] DEBUG – : - User[64]: static_object_token
D, [2024-03-11T10:27:58.605386 #1616] DEBUG – : - User[65]: static_object_token
D, [2024-03-11T10:27:58.605410 #1616] DEBUG – : - User[68]: static_object_token
D, [2024-03-11T10:27:58.605433 #1616] DEBUG – : - User[69]: static_object_token
D, [2024-03-11T10:27:58.605452 #1616] DEBUG – : - User[70]: static_object_token
D, [2024-03-11T10:27:58.605470 #1616] DEBUG – : - User[71]: static_object_token
D, [2024-03-11T10:27:58.605525 #1616] DEBUG – : - User[72]: static_object_token
D, [2024-03-11T10:27:58.605546 #1616] DEBUG – : - User[73]: static_object_token
D, [2024-03-11T10:27:58.605566 #1616] DEBUG – : - User[74]: static_object_token
D, [2024-03-11T10:27:58.605587 #1616] DEBUG – : - User[75]: static_object_token
D, [2024-03-11T10:27:58.605607 #1616] DEBUG – : - User[76]: static_object_token
D, [2024-03-11T10:27:58.605628 #1616] DEBUG – : - User[77]: static_object_token
D, [2024-03-11T10:27:58.605648 #1616] DEBUG – : - User[78]: static_object_token
D, [2024-03-11T10:27:58.605671 #1616] DEBUG – : - User[79]: static_object_token
D, [2024-03-11T10:27:58.605691 #1616] DEBUG – : - User[80]: static_object_token
D, [2024-03-11T10:27:58.605716 #1616] DEBUG – : - User[81]: static_object_token
D, [2024-03-11T10:27:58.605736 #1616] DEBUG – : - User[82]: static_object_token
D, [2024-03-11T10:27:58.605758 #1616] DEBUG – : - User[83]: static_object_token
D, [2024-03-11T10:27:58.605782 #1616] DEBUG – : - User[85]: static_object_token
D, [2024-03-11T10:27:58.605803 #1616] DEBUG – : - User[86]: static_object_token
D, [2024-03-11T10:27:58.605827 #1616] DEBUG – : - User[87]: static_object_token
D, [2024-03-11T10:27:58.605846 #1616] DEBUG – : - User[88]: static_object_token
D, [2024-03-11T10:27:58.605864 #1616] DEBUG – : - User[89]: static_object_token
D, [2024-03-11T10:27:58.605887 #1616] DEBUG – : - User[91]: static_object_token
D, [2024-03-11T10:27:58.605937 #1616] DEBUG – : - User[92]: static_object_token
D, [2024-03-11T10:27:58.605958 #1616] DEBUG – : - User[93]: static_object_token
D, [2024-03-11T10:27:58.605980 #1616] DEBUG – : - User[97]: static_object_token
D, [2024-03-11T10:27:58.606000 #1616] DEBUG – : - User[98]: static_object_token
D, [2024-03-11T10:27:58.606019 #1616] DEBUG – : - User[99]: static_object_token
D, [2024-03-11T10:27:58.606041 #1616] DEBUG – : - User[101]: static_object_token
D, [2024-03-11T10:27:58.606061 #1616] DEBUG – : - User[102]: static_object_token
D, [2024-03-11T10:27:58.606080 #1616] DEBUG – : - User[103]: static_object_token
D, [2024-03-11T10:27:58.606099 #1616] DEBUG – : - User[104]: static_object_token
D, [2024-03-11T10:27:58.606123 #1616] DEBUG – : - User[105]: static_object_token
D, [2024-03-11T10:27:58.606142 #1616] DEBUG – : - User[106]: static_object_token
D, [2024-03-11T10:27:58.606165 #1616] DEBUG – : - User[107]: static_object_token
D, [2024-03-11T10:27:58.606184 #1616] DEBUG – : - User[108]: static_object_token
D, [2024-03-11T10:27:58.606203 #1616] DEBUG – : - User[109]: static_object_token
D, [2024-03-11T10:27:58.606223 #1616] DEBUG – : - User[110]: static_object_token
D, [2024-03-11T10:27:58.606245 #1616] DEBUG – : - User[111]: static_object_token
D, [2024-03-11T10:27:58.606298 #1616] DEBUG – : - User[112]: static_object_token
D, [2024-03-11T10:27:58.606324 #1616] DEBUG – : - User[113]: static_object_token
D, [2024-03-11T10:27:58.606346 #1616] DEBUG – : - User[114]: static_object_token
D, [2024-03-11T10:27:58.606366 #1616] DEBUG – : - User[115]: static_object_token
D, [2024-03-11T10:27:58.606405 #1616] DEBUG – : - User[116]: static_object_token
D, [2024-03-11T10:27:58.606426 #1616] DEBUG – : - User[117]: static_object_token
D, [2024-03-11T10:27:58.606447 #1616] DEBUG – : - User[118]: static_object_token
D, [2024-03-11T10:27:58.606466 #1616] DEBUG – : - User[119]: static_object_token
D, [2024-03-11T10:27:58.606486 #1616] DEBUG – : - User[120]: static_object_token
D, [2024-03-11T10:27:58.606509 #1616] DEBUG – : - User[121]: static_object_token
D, [2024-03-11T10:27:58.606528 #1616] DEBUG – : - User[122]: static_object_token
D, [2024-03-11T10:27:58.606547 #1616] DEBUG – : - User[123]: static_object_token
D, [2024-03-11T10:27:58.606568 #1616] DEBUG – : - User[125]: static_object_token
D, [2024-03-11T10:27:58.606589 #1616] DEBUG – : - User[126]: static_object_token
D, [2024-03-11T10:27:58.606609 #1616] DEBUG – : - User[127]: static_object_token
I, [2024-03-11T10:27:58.620811 #1616] INFO – : - Clusters::Platforms::Kubernetes failures: 0
I, [2024-03-11T10:27:58.657770 #1616] INFO – : - Snippet failures: 0
I, [2024-03-11T10:27:58.661845 #1616] INFO – : - PersonalSnippet failures: 0
I, [2024-03-11T10:27:58.665663 #1616] INFO – : - ProjectSnippet failures: 0
I, [2024-03-11T10:27:58.768711 #1616] INFO – : - Integration failures: 0
I, [2024-03-11T10:27:58.771915 #1616] INFO – : - Integrations::Asana failures: 0
I, [2024-03-11T10:27:58.774509 #1616] INFO – : - Integrations::Assembla failures: 0
I, [2024-03-11T10:27:58.777071 #1616] INFO – : - Integrations::BaseCi failures: 0
I, [2024-03-11T10:27:58.779313 #1616] INFO – : - Integrations::Bamboo failures: 0
I, [2024-03-11T10:27:58.781704 #1616] INFO – : - Integrations::Buildkite failures: 0
I, [2024-03-11T10:27:58.784694 #1616] INFO – : - Integrations::DroneCi failures: 0
I, [2024-03-11T10:27:58.788191 #1616] INFO – : - Integrations::Jenkins failures: 0
I, [2024-03-11T10:27:58.793132 #1616] INFO – : - Integrations::Teamcity failures: 0
I, [2024-03-11T10:27:58.798076 #1616] INFO – : - Integrations::MockCi failures: 0
I, [2024-03-11T10:27:58.802812 #1616] INFO – : - Integrations::BaseIssueTracker failures: 0
I, [2024-03-11T10:27:58.807804 #1616] INFO – : - Integrations::Bugzilla failures: 0
I, [2024-03-11T10:27:58.811447 #1616] INFO – : - Integrations::CustomIssueTracker failures: 0
I, [2024-03-11T10:27:58.814302 #1616] INFO – : - Integrations::Ewm failures: 0
I, [2024-03-11T10:27:58.817535 #1616] INFO – : - Integrations::Jira failures: 0
I, [2024-03-11T10:27:58.821712 #1616] INFO – : - Integrations::Redmine failures: 0
I, [2024-03-11T10:27:58.826052 #1616] INFO – : - Integrations::Youtrack failures: 0
I, [2024-03-11T10:27:58.830316 #1616] INFO – : - Integrations::Campfire failures: 0
I, [2024-03-11T10:27:58.834090 #1616] INFO – : - Integrations::BaseThirdPartyWiki failures: 0
I, [2024-03-11T10:27:58.837719 #1616] INFO – : - Integrations::Confluence failures: 0
I, [2024-03-11T10:27:58.841165 #1616] INFO – : - Integrations::Shimo failures: 0
I, [2024-03-11T10:27:58.843965 #1616] INFO – : - Integrations::Datadog failures: 0
I, [2024-03-11T10:27:58.847187 #1616] INFO – : - Integrations::BaseChatNotification failures: 0
I, [2024-03-11T10:27:58.849885 #1616] INFO – : - Integrations::Discord failures: 0
I, [2024-03-11T10:27:58.852423 #1616] INFO – : - Integrations::HangoutsChat failures: 0
I, [2024-03-11T10:27:58.854812 #1616] INFO – : - Integrations::Mattermost failures: 0
I, [2024-03-11T10:27:58.858103 #1616] INFO – : - Integrations::MicrosoftTeams failures: 0
I, [2024-03-11T10:27:58.863492 #1616] INFO – : - Integrations::Slack failures: 0
I, [2024-03-11T10:27:58.869194 #1616] INFO – : - Integrations::WebexTeams failures: 0
I, [2024-03-11T10:27:58.874139 #1616] INFO – : - Integrations::UnifyCircuit failures: 0
I, [2024-03-11T10:27:58.879068 #1616] INFO – : - Integrations::EmailsOnPush failures: 0
I, [2024-03-11T10:27:58.884710 #1616] INFO – : - Integrations::ExternalWiki failures: 0
I, [2024-03-11T10:27:58.891527 #1616] INFO – : - Integrations::Flowdock failures: 0
I, [2024-03-11T10:27:58.895860 #1616] INFO – : - Integrations::Harbor failures: 0
I, [2024-03-11T10:27:58.900207 #1616] INFO – : - Integrations::Irker failures: 0
I, [2024-03-11T10:27:58.906027 #1616] INFO – : - Integrations::BaseSlashCommands failures: 0
I, [2024-03-11T10:27:58.911393 #1616] INFO – : - Integrations::MattermostSlashCommands failures: 0
I, [2024-03-11T10:27:58.915938 #1616] INFO – : - Integrations::SlackSlashCommands failures: 0
I, [2024-03-11T10:27:58.920184 #1616] INFO – : - Integrations::Packagist failures: 0
I, [2024-03-11T10:27:58.923818 #1616] INFO – : - Integrations::PipelinesEmail failures: 0
I, [2024-03-11T10:27:58.927106 #1616] INFO – : - Integrations::Pivotaltracker failures: 0
I, [2024-03-11T10:27:58.930543 #1616] INFO – : - Integrations::BaseMonitoring failures: 0
I, [2024-03-11T10:27:58.933425 #1616] INFO – : - Integrations::Prometheus failures: 0
I, [2024-03-11T10:27:58.936096 #1616] INFO – : - Integrations::MockMonitoring failures: 0
I, [2024-03-11T10:27:58.938620 #1616] INFO – : - Integrations::Pushover failures: 0
I, [2024-03-11T10:27:58.941093 #1616] INFO – : - Integrations::Zentao failures: 0
I, [2024-03-11T10:27:58.952302 #1616] INFO – : - Clusters::Applications::Helm failures: 0
I, [2024-03-11T10:27:58.962104 #1616] INFO – : - Clusters::Applications::Prometheus failures: 0
I, [2024-03-11T10:27:58.973171 #1616] INFO – : - AlertManagement::HttpIntegration failures: 0
I, [2024-03-11T10:27:58.984938 #1616] INFO – : - GrafanaIntegration failures: 0
I, [2024-03-11T10:27:58.999576 #1616] INFO – : - RemoteMirror failures: 0
I, [2024-03-11T10:27:59.036935 #1616] INFO – : - PagesDomain failures: 0
I, [2024-03-11T10:27:59.045963 #1616] INFO – : - PagesDomainAcmeOrder failures: 0
I, [2024-03-11T10:27:59.055429 #1616] INFO – : - JiraConnectInstallation failures: 0
I, [2024-03-11T10:27:59.064271 #1616] INFO – : - ProjectImportData failures: 0
I, [2024-03-11T10:27:59.154142 #1616] INFO – : - WebHook failures: 0
I, [2024-03-11T10:27:59.157546 #1616] INFO – : - ProjectHook failures: 0
I, [2024-03-11T10:27:59.160492 #1616] INFO – : - ServiceHook failures: 0
I, [2024-03-11T10:27:59.162725 #1616] INFO – : - SystemHook failures: 0
I, [2024-03-11T10:27:59.171556 #1616] INFO – : - Atlassian::Identity failures: 0
I, [2024-03-11T10:27:59.180416 #1616] INFO – : - ErrorTracking::ProjectErrorTrackingSetting failures: 0
I, [2024-03-11T10:27:59.208640 #1616] INFO – : - Clusters::KubernetesNamespace failures: 0
I, [2024-03-11T10:27:59.215172 #1616] INFO – : - IncidentManagement::ProjectIncidentManagementSetting failures: 0
I, [2024-03-11T10:27:59.225336 #1616] INFO – : - Alerting::ProjectAlertingSetting failures: 0
I, [2024-03-11T10:27:59.257728 #1616] INFO – : - Serverless::DomainCluster failures: 0
I, [2024-03-11T10:27:59.263696 #1616] INFO – : - BulkImports::Configuration failures: 0
I, [2024-03-11T10:27:59.269723 #1616] INFO – : - Integrations::IssueTrackerData failures: 0
I, [2024-03-11T10:27:59.276630 #1616] INFO – : - Integrations::JiraTrackerData failures: 0
I, [2024-03-11T10:27:59.284085 #1616] INFO – : - Integrations::ZentaoTrackerData failures: 0
I, [2024-03-11T10:27:59.287128 #1616] INFO – : - Clusters::Integrations::Prometheus failures: 0
I, [2024-03-11T10:27:59.296249 #1616] INFO – : - Clusters::Providers::Gcp failures: 0
I, [2024-03-11T10:27:59.306222 #1616] INFO – : - Clusters::Providers::Aws failures: 0
I, [2024-03-11T10:27:59.316069 #1616] INFO – : - Packages::Debian::ProjectDistributionKey failures: 0
I, [2024-03-11T10:27:59.325837 #1616] INFO – : - Packages::Debian::GroupDistributionKey failures: 0
I, [2024-03-11T10:27:59.329471 #1616] INFO – : - Gitlab::BackgroundMigration::BackfillJiraTrackerDeploymentType2::JiraTrackerDataTemp failures: 0
I, [2024-03-11T10:27:59.358476 #1616] INFO – : - Gitlab::BackgroundMigration::BackfillIntegrationsEnableSslVerification::Integration failures: 0
I, [2024-03-11T10:27:59.397304 #1616] INFO – : - Ci::Runner failures: 0
I, [2024-03-11T10:27:59.626766 #1616] INFO – : - Ci::Build failures: 0
I, [2024-03-11T10:27:59.742776 #1616] INFO – : - Group failures: 0
I, [2024-03-11T10:27:59.936988 #1616] INFO – : - Project failures: 0
I, [2024-03-11T10:27:59.955380 #1616] INFO – : - DeployToken failures: 0
I, [2024-03-11T10:27:59.991257 #1616] INFO – : - Clusters::AgentToken failures: 0
I, [2024-03-11T10:28:00.006410 #1616] INFO – : - Operations::FeatureFlagsClient failures: 12
D, [2024-03-11T10:28:00.006528 #1616] DEBUG – : - Operations::FeatureFlagsClient[3]: token
D, [2024-03-11T10:28:00.006596 #1616] DEBUG – : - Operations::FeatureFlagsClient[5]: token
D, [2024-03-11T10:28:00.006652 #1616] DEBUG – : - Operations::FeatureFlagsClient[6]: token
D, [2024-03-11T10:28:00.006706 #1616] DEBUG – : - Operations::FeatureFlagsClient[7]: token
D, [2024-03-11T10:28:00.006770 #1616] DEBUG – : - Operations::FeatureFlagsClient[8]: token
D, [2024-03-11T10:28:00.006823 #1616] DEBUG – : - Operations::FeatureFlagsClient[9]: token
D, [2024-03-11T10:28:00.006873 #1616] DEBUG – : - Operations::FeatureFlagsClient[10]: token
D, [2024-03-11T10:28:00.006930 #1616] DEBUG – : - Operations::FeatureFlagsClient[11]: token
D, [2024-03-11T10:28:00.006982 #1616] DEBUG – : - Operations::FeatureFlagsClient[12]: token
D, [2024-03-11T10:28:00.007046 #1616] DEBUG – : - Operations::FeatureFlagsClient[13]: token
D, [2024-03-11T10:28:00.007157 #1616] DEBUG – : - Operations::FeatureFlagsClient[14]: token
D, [2024-03-11T10:28:00.007209 #1616] DEBUG – : - Operations::FeatureFlagsClient[15]: token
I, [2024-03-11T10:28:00.007271 #1616] INFO – : Total: 97 row(s) affected
I, [2024-03-11T10:28:00.007311 #1616] INFO – : Done!

Answer 1

m0_72246842 下午好🌅🌅🌅
本答案参考ChatGPT-3.5

根据你提供的日志信息，出现了两个错误：User failures 和 Operations::FeatureFlagsClient failures。这可能是由于迁移后未替换老的gitlab-secrets.json文件导致的。下面是解决这两个问题的步骤：

1. 找到存储有gitlab-secrets.json文件的路径。默认情况下，gitlab-secrets.json文件保存在/etc/gitlab/目录下。
2. 将老的gitlab-secrets.json文件从源服务器复制到新的服务器对应的路径下。确保文件权限是正确的。
3. 重启GitLab服务，让新的gitlab-secrets.json文件生效。

解决User failures问题：

1. 使用以下命令清除数据库中的加密数据，并重新加密：

   gitlab-rake gitlab:db:encrypted_column:clear_all
   gitlab-ctl reconfigure
   

解决Operations::FeatureFlagsClient failures问题：

1. 使用以下命令更新数据库中的特性标志（feature flags）：

   gitlab-rake gitlab:feature_flags:fix_schema_mismatches
   

2. 重启GitLab服务：

   gitlab-ctl restart
   

以上步骤应该可以解决你遇到的问题，如果问题还没有解决，可以尝试以下额外步骤：

1. 清理GitLab的缓存和重新编译资产：

   gitlab-rake cache:clear
   gitlab-rake assets:precompile
   

如果问题仍然存在，请提供更多的错误日志和相关配置信息以便更详细地解决问题。