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
  • Installation Type, remove incorrect values:
    • Other: Docker Compose
  • Is this a single or multiple node installation? Single
  • Resources
    • CPU: 8
    • Memory total: 32768 MB
Edited by Alban B