3k集群用户备份命令报错“ PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly”
还有一个比较困惑的问题集群用户总是会遇到,在备份仓库时会提示数据库连接中断,目前这个问题也是无解。 客户使用命令绕过pgbouncer和报错日志:
GITLAB_BACKUP_PGHOST=10.189.28.102 GITLAB_BACKUP_PGPORT=5432 gitlab-backup create STRATEGY=copy
rake aborted!
ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_cache_with_renamed_table.rb:25:in `columns'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_cache_with_renamed_table.rb:29:in `columns_hash'
/opt/gitlab/embedded/service/gitlab-rails/lib/feature.rb:84:in `enabled?'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:299:in `repository_backup_strategy'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:112:in `block (4 levels) in <top (required)>'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:13:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Caused by:
PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_cache_with_renamed_table.rb:25:in `columns'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_cache_with_renamed_table.rb:29:in `columns_hash'
/opt/gitlab/embedded/service/gitlab-rails/lib/feature.rb:84:in `enabled?'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:299:in `repository_backup_strategy'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:112:in `block (4 levels) in <top (required)>'
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:13:in `block (3 levels) in <top (required)>'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Tasks: TOP => gitlab:backup:repo:create
(See full trace by running task with --trace)
比较奇怪的是我们将rails配置改成直连pg主库后问题不再发生。