Problems with gitlab 15.11.4 when upgrading to latest version
OS Version: Centos 7
yum localinstall gitlab-ce-15.11.13-ce.0.el7.x86_64.rpm
gitlab preinstall: Checking for unmigrated data on legacy storage
gitlab preinstall: Automatically backing up only the GitLab SQL database (excluding everything else!)
2024-01-23 08:54:01 UTC -- Dumping database ...
Dumping PostgreSQL database gitlabhq_production ... pg_dump: error: Dumping the contents of table "merge_request_diff_files" failed: PQgetCopyData() failed.
pg_dump: error: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: error: The command was: COPY public.merge_request_diff_files (merge_request_diff_id, relative_order, new_file, renamed_file, deleted_file, too_large, a_mode, b_mode, new_path, old_path, diff, "binary", external_diff_offset, external_diff_size) TO stdout;
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
rake aborted!
2024-01-22 08:47:55 UTC -- Dumping database in progress ...
Dumping PostgreSQL database gitlabhq_production ... pg_dump: error: Dumping the contents of table "merge_request_diff_files" failed: PQgetCopyData() failed.
pg_dump: error: Error message from server: Server closed the connection unexpectedly!
This may mean that the server abnormally terminated the connection before or during the processing of the request.
Abnormally terminated.
pg_dump: error: The command COPY public.merge_request_diff_files (merge_request_diff_id, relative_order, new_file, renamed_file, deleted_file, too_ large, a_mode, b_mode, b_mode) failed. large, a_mode, b_mode, new_path, old_path, diff, "binary", external_diff_offset, external_diff_size) TO stdout;
WARNING: Connection terminated because another server process crashed!
DETAILS: Postmaster commanded this server process to roll back the current transaction and exit because another server process exited abnormally and may have corrupted shared memory.
Tip: You can reconnect to the database later and repeat your command.
rake aborted!
ActiveRecord::StatementInvalid: PG::ConnectionBad: PQsocket() unable to get socket descriptor
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/load_balancing/connection_proxy.rb:121:in `public_send
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/load_balancing/connection_proxy.rb:121:in `block in write_using_load_ balancer'. balancer'.
.....
/opt/gitlab/embedded/bin/bundle:23:in `<main>'
Task: TOP => gitlab:backup:create
(Run the task with --trace to see the full trace information)
2024-01-22 08:52:53 UTC -- Deleting tar temporary files ...
2024-01-22 08:52:53 UTC -- Cleanup /data/webapps/gitlab-backups/db
2024-01-22 08:52:53 UTC -- Delete tar archive ... done
2024-01-22 08:52:53 UTC -- Deleting backups/tmp ...
2024-01-22 08:52:53 UTC -- Deleting backups/tmp ... Done
2024-01-22 16:52:53 +0800 -- Deleting backups and restoring locked files
gitlab preinstall:
gitlab preinstall: database backup failed! If you want to skip this backup, run the following command and try again:
gitlab preinstall:
gitlab preinstall: sudo touch /etc/gitlab/skip-auto-backup
gitlab preinstall:
Error: %pre(gitlab-15.11.13-ce.0.el7.x86_64) script failed with exit status code 1
Error in PREIN script in rpm package gitlab-ce-15.11.13-ce.0.el7.x86_64
Verified in : gitlab-ce-15.11.13-ce.0.el7.x86_64 1/2
gitlab-ce-15.11.4-ce.0.el7.x86_64 should have been removed, but was not!
Verification in progress : gitlab-ce-15.11.4-ce.0.el7.x86_64 2/2
Failed:
gitlab-ce.x86_64 0:15.11.4-ce.0.el7 gitlab-ce.x86_64 0:15.11.13-ce.0.el7
I didn’t stop the psql service manually, it may have stopped during the upgrade and migration process
What do I do now?