[Bug] pgdump/pg_dumpall schema-only - out of memory problem after upgrade from CBDB 2.1.0 to CBDB 2.2.0 found

Ouverte
#2,330 0 commentaires 1 réaction 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 2 jours

Personne n'a encore pris cette issue.

Évaluation

Difficulté
4/5
Temps estimé
3-5 jours
Accessibilité débutants
43/100
Type d'issue
Bug
Clarté
Plutôt claire
Activité
Active
Stack technique
c, postgresql
Domaine
databases

Piste de recherche

The failure occurs in pg_dump while reading column information for interesting tables; the payload does not identify a source file or test. Start by tracing that step in the pg_dump code and find how the reported database schema triggers the out-of-memory error. Done means pg_dump -s and pg_dumpall -s complete on the reporter’s DWH database after upgrading from CBDB 2.1.0 to 2.2.0.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

type: Bug
Apache Cloudberry version

PostgreSQL 14.10 (Apache Cloudberry 2.2.0-incubating build dev) on x86_64-pc-linux-gnu, compiled by gcc (Astra 1.8.2)

What happened

Hi,

After upgrade from CBDB 2.1.0 to CBDB 2.2.0 we found pgdump/pg_dumpall schema-only - out of memory problem

Details the next:

gpadmin@qc1:~$ /usr/cloudberry-db/bin/pg_dump -v -s -f /tmp/qwe1.sql --no-blobs ' dbname=dwh'
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined external protocols
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
out of memory

What you think should happen instead

No response

How to reproduce

Run pgdump -s or pg_dumpall -s on our database DWH

Operating System

Astra Linux 1.8.2 analog Debian 12

Anything else

No response

Are you willing to submit PR?
  • Yes, I am willing to submit a PR!
Code of Conduct
Langage dominant
C
Étoiles
1.4k
Forks
273
Merge moyen
4 j 6 h
PR mergées (30 j)
105

Préparer son environnement

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de apache/cloudberry

Toutes les issues de apache/cloudberry

Issues similaires

Plus d'issues C

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.