Dumping PostgreSQL database gitlabhq_production ... pg_dump: error: Dumping the contents of table "ci_builds_metadata" failed: PQgetResult() failed. pg_dump: error: Error message from server: ERROR: unknown type of jsonb container
Summary
I have ran gitlab-ctl reconfigure with no problem. Using the gitlab-backup create command on my 16.11.3-ce Gitlab docker doesn't work.
Steps to reproduce
What is the current bug behavior?
When I run gitlab-backup create SKIP=artifacts,registry,terraform_state,remote from within the Gitlab container, I get :
2024-06-04 13:33:17 UTC -- Dumping database ...
Dumping PostgreSQL database gitlabhq_production ... pg_dump: error: Dumping the contents of table "ci_builds_metadata" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: unknown type of jsonb container
pg_dump: error: The command was: COPY public.ci_builds_metadata (project_id, timeout, timeout_source, config_options, config_variables, interruptible, has_exposed_artifacts, environment_auto_stop_in, expanded_environment_name, secrets, build_id, id, runtime_runner_features,
id_tokens, partition_id, debug_trace_enabled, exit_code) TO stdout;
2024-06-04 13:33:24 UTC -- Dumping database failed: Failed to create compressed file '/var/opt/gitlab/backups/db/database.sql.gz' when trying to backup the main database:
- host: '/var/opt/gitlab/postgresql'
- port: '5432'
- database: 'gitlabhq_production'
What is the expected correct behavior?
It should do the backup of my gitlabhq_production database, as per the doc.
Environment details
- Operating System:
Debian - Installation Target, remove incorrect values:
- Other:
Docker Compose
- Other:
- Installation Type, remove incorrect values:
- Other:
Docker Compose
- Other:
- Is this a single or multiple node installation? Single
- Resources
- CPU:
8 - Memory total:
32768 MB
- CPU:
Edited by Alban B