I am using a gitlab in a self-hosted environment, an omnibus package installation Method. I can’t able to back up the database. Below is the Error Message.
[root@localhost ~]# gitlab-rake gitlab:backup:create 2019-11-19 18:32:07 +0530 -- Dumping database ... Dumping PostgreSQL database gitlabhq_production ... pg_dump: Dumping the contents of table "user_agent_details" failed: PQgetCopyData() failed. pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: The command was: COPY public.user_agent_details (id, user_agent, ip_address, subject_id, subject_type, submitted, created_at, updated_at) TO stdout; [FAILED] rake aborted! Backup::Error: Backup failed /opt/gitlab/embedded/service/gitlab-rails/lib/backup/database.rb:50:in `dump' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:99:in `block (4 levels) in <top (required)>' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/backup.rake:10: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:db:create (See full trace by running task with --trace)
It is Clear that something wrong with below table while it tried to make a dump, i’m struck with this Issue for a long While and unable to update gitlab Version too. any leads at this error.
pg_dump: The command was: COPY public.user_agent_details (id, user_agent, ip_address, subject_id, subject_type, submitted, created_at, updated_at) TO stdout;
I’ve tried login db console, and listed the database > table > colums
What to do Further?
Gitlab Version : 11.9.1
hosted environment : centos 7
server type: bare metal Server.